A thread to get us through until the Bot army strikes.

  • Rusty Raven M
    link
    fedilink
    English
    arrow-up
    14
    ·
    1 year ago

    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.

    • Duenan
      link
      fedilink
      English
      arrow-up
      6
      ·
      1 year ago

      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?

      • Rusty Raven M
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        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!