Hey my guys imma let you finish but convert those fucked up hardcoded cell refs to tables with names so you can change your data shape without having to fuck with the whole goddamn thing.
fwiw the shape of this would be extremely unlikely to change. it’s a pto calculator that would be embedded on adp since our pto accrues differently now that we have 4 day work week
So is mine because my data management folks mostly did that so I never had much of a chance, but my Matlab days I worked with some professional programmers who did their best to inculcate good habits.
That sounds cool but not needed for my formula — it’s a tool with a handful of entry cells that category managers hand key values into to get a calculated result. If I were better it would use SQL commands to retrieve data but I don’t know how to do that
I had a bunch of spreadsheets at Central that had catapult sql queries built into them that would pull sales data and then run it through a bizarre series of overly complicated excel formulas. You would love them. You should hit them up for copies.