Home › Forums › Data issues › off the job calculation This topic contains 10 replies, has 7 voices, and was last updated by GaynorLF 1 year, 10 months ago. Viewing 11 posts - 1 through 11 (of 11 total) Author Posts KateWParticipant Hi all, Does anyone have a simple calculation / tool for how they calculate the 20% off the job now that annual leave can be deducted? We have different ways of calculating it but i know it needs to be clear and standardised. Thanks in advance! December 3, 2018 at 11:38 am #313848 KateParticipant We do the number of hours worked per week * 5.6 December 3, 2018 at 11:45 am #313860 Sue BishopParticipant We’ve created a spreadsheet – let me have your email and I’ll send on. Regards, Sue December 3, 2018 at 11:58 am #313870 donna1805Participant Hi Sue – would you mind sending me the spreadsheet too please? Also do you have a template which you use to record the 20% off the job training? Thank you Donna December 3, 2018 at 12:02 pm #313873 KateWParticipant Hi sue, That would be great! email@example.com Thank you so much for your help 🙂 We use OneFile to record which seems to work well. December 3, 2018 at 12:09 pm #313878 Sue BishopParticipant Hi Donna, no problem. We use our eportfolio to log 20%. Send me your email address. Regards, Sue December 3, 2018 at 12:19 pm #313882 donna1805Participant Thanks Sue – firstname.lastname@example.org December 3, 2018 at 12:29 pm #313889 jessc21Participant Hi Sue, Would it be possible for you to send the spreadsheet to myself too? I would really appreciate it. Email address is email@example.com December 3, 2018 at 2:01 pm #313923 Sue BishopParticipant Hi Jess, Sent across, have based it on a 48 week year, so if the apprentice has, say, 6 weeks annual leave, you’ll need to amend the formulae slightly. Let me know if you need any help with it. Regards, Sue December 3, 2018 at 10:09 pm #314160 Glynn0707Participant Yes please. I normally use hours x46.2 x.2 (based on ‘normal’ allowance) firstname.lastname@example.org December 5, 2018 at 8:46 am #314641 GaynorLFParticipant Hi Sue Can I jump on this bandwagon please and ask you to email me the spreadsheet too email@example.com Many Thanks Gaynor December 5, 2018 at 9:18 am #314658 Viewing 11 posts - 1 through 11 (of 11 total) You must be logged in to reply to this topic.