Having generated a median salary for (so far 2) departments, I think it might be interesting to see a meeting calculator. If a number of people are in a meeting for a number of hours, what is the cost in payroll? (Again, building costs and employer contributions to pensions and NI not considered.) It doesn’t just have to be meetings. What if the technology is so old that it takes about 5 minutes (or 1/12 of an hour) for everyone’s PC to boot up and down in a day.
When I’ve processed DExEU’s Organogram, I might try turning the IAs that weren’t IAs that were so many man-hours of work into a £ cost.
There is R shiny, which throws computations back to the server, but I’m using a free server that doesn’t want me giving it more workload. Also, the hard computation is being done in R when the site is generated, the rest is taking the number of people times the number of hours times the median hourly salary.
DWP_median = 24476 total_hours =(365.25 / 7 * 5 - 25 -9) * (37/5) DWP_hourly = round(DWP_median/total_hours,2)
DWP meeting calculator
DHSC_median = 33675 total_hours =(365.25 / 7 * 5 - 25 -9) * (37/5) DHSC_hourly = round(DHSC_median/total_hours,2)
DHSC meeting calculator
- Get all the latest Org data.
- Filter out departments that no longer exist.
- Standardise the grading systems.
- Optional: Filter out executive agencies.
2 and 3 are going to be the tricky parts. There’s going to be a few runs of “assume the data looks like this, and if it doesn’t alert me” until I’ve found every format someone has used. 2 should be relatively easy once I have a list of active departments, but there’s no guarantee that it’ll match any of the metadata in the data.gov.uk entry.
However, it’s probably time to develop some of the other projects a little. In particular, I started with my graph theory/GIS, but haven’t got it to writeup stage yet.