this post was submitted on 02 Jul 2023
32 points (94.4% liked)
Melbourne
1843 readers
76 users here now
This community is a place created for the people of Melbourne and Victoria. We are a positive, welcoming and inclusive community. We might not agree about everything, but we always strive to stay civil and respectful.
The focus of our discussions is based around things that effect Victoria, but we are also free to discuss our local perspective on wider issues. Or head to the regular Daily Random Discussion thread to talk about anything.
Ongoing discussions, FAQs & Resources (still under construction)
Adoption Certificate for Nellie, the Daily Thread numbat (with thanks to @Catfish)
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
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!