Skip to content
Berri
Sign in Try Berri
Sign inTry Berri

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 Berri

Tips

  • 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.
What Berri sends back
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:

PersonPresentLeaveHalfPayable
Staff 1251030
Staff 2223128.5
Staff 3240229
Staff 4195025

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.

Your own job, in your own words.

Try Berri