I spent way too much time today perfecting my pay calculation spreadsheet. But is now a little neater, includes more automation, and calculates the super I should be getting as well as the pay.
We have a ridiculously complicated pay structure, so I have 7 types of leave, 6 types of overtime payment, 6 different penalty levels (there are more, that’s just the ones that apply to me) and a few allowances. We also get paid basic wages for the period finishing on Friday, but penalties and overtime are for the period finishing on Wednesday. And our standard work day is broken into normal hours, rostered overtime and leave acruual, so the hours used to calculate each type of pay are different. So it is really hard to figure out whether we are being paid correctly without a computer and complicated maths.
I’ve managed to get to the point that except for mistakes my calculations only differ due to minor rounding differences, and I can project future income for my budget fairly easily too. NGL pretty pleased with myself.
Well done. It must have been a lot of work to get that worked out.
I’ve been doing a very rudimentary budget every week or two to make sure I’m on top of everything and it’s so complicated without everything you mentioned and takes a lot of time!
I’ve been working on it for a couple of years and improving a bit at a time. Now that I’m in the habit of recording things like the utility bills and petrol it’s becoming a lot more accurate, and I can make better forecasts for the future. It’s also been very educational, and there are a lot of similarities between complicated excel formulas and the way the code for the bot is written, so it has probably helped with that too!
I spent way too much time today perfecting my pay calculation spreadsheet. But is now a little neater, includes more automation, and calculates the super I should be getting as well as the pay.
We have a ridiculously complicated pay structure, so I have 7 types of leave, 6 types of overtime payment, 6 different penalty levels (there are more, that’s just the ones that apply to me) and a few allowances. We also get paid basic wages for the period finishing on Friday, but penalties and overtime are for the period finishing on Wednesday. And our standard work day is broken into normal hours, rostered overtime and leave acruual, so the hours used to calculate each type of pay are different. So it is really hard to figure out whether we are being paid correctly without a computer and complicated maths.
I’ve managed to get to the point that except for mistakes my calculations only differ due to minor rounding differences, and I can project future income for my budget fairly easily too. NGL pretty pleased with myself.
that is ridiculous
Well done. It must have been a lot of work to get that worked out.
I’ve been doing a very rudimentary budget every week or two to make sure I’m on top of everything and it’s so complicated without everything you mentioned and takes a lot of time!
Not that you’ve done that is it time to R&R?
I’ve been working on it for a couple of years and improving a bit at a time. Now that I’m in the habit of recording things like the utility bills and petrol it’s becoming a lot more accurate, and I can make better forecasts for the future. It’s also been very educational, and there are a lot of similarities between complicated excel formulas and the way the code for the bot is written, so it has probably helped with that too!