Work out payable days from an attendance sheet
Present, leave, half days and payable days for every person.
- ForSmall factories, shops and offices that track attendance in Excel.
- HelperAttendance
- ModeBerri Strawberry 1
- AttachExcel sheet
Copy the prompt
This is the attendance sheet for [month] with P, A, L and H for half day. Paid leave allowed is [number] days. Give me present days, leave, half days and payable days for each person.
Change the words in [brackets] to your own.
What to attach
An Excel sheet (.xlsx). Berri reads the first sheet, so keep the data there.
Run it
Berri opens with the prompt filled in and the Attendance helper picked. Nothing is sent until you press send.
Run this in BerriTips
- Tell Berri your own rules, such as whether Sundays are paid, before you ask.
- Ask "remember these attendance rules" so next month you only send the sheet.
Work out payable days from an attendance sheetAttendance
XLSattendance-nov.xlsx
This is the attendance sheet for November with P, A, L and H for half day. Paid leave allowed is 2 days. Give me present days, leave, half days and payable days for each person.
Reading attendance-nov.xlsx
30 days in November, 4 Sundays paid:
| Person | Present | Leave | Half | Payable |
|---|---|---|---|---|
| Staff 1 | 25 | 1 | 0 | 30 |
| Staff 2 | 22 | 3 | 1 | 28.5 |
| Staff 3 | 24 | 0 | 2 | 29 |
| Staff 4 | 19 | 5 | 0 | 25 |
Staff 4 has 3 unpaid leave days. Staff 2 has 1.
Figures here are made up to show the shape of the answer. Yours come from your own file and words.