FFS! When you have SIMS why insist on spreadsheets.
So gotta let of steam here, why when I spend loads of time created Marksheets, Reports and methods for analysis do staff insist that they want the data exported in excel, so they can do some analysis ?
And it's not even like they are competent in excel either.
Then of course class list change, students start and leave the school, so the excel analysis is pretty much out of date as soon it leaves SIMS.
But of course I'm the data manager so I should be able to fix and merge and understand all the weird stuff they have done, and know what 20 level subnested folder the spreadsheet called Y11-12-13-Ethnic-English.xls is stored in, so I can cross reference
it with the other 20 spreadsheets spread all over the place, that have no common format, and produce a report for SLT in under 5 minutes.
When if they actually told me what they want I could implement a reproducible solution in SIMS in a couple of hours, that will keep working and allow all the information to be reported on.
But noooooo, they want a spreadsheet.
Gaahhhh, Just Gaahhhhh.