3 ms·
> Each of the seven [UK] recruitment regions creates a separate spreadsheet, but these have no standardised template, naming convention or structure. After bein
by alpaca128 3y ago
> Each of the seven [UK] recruitment regions creates a separate spreadsheet, but these have no standardised template, naming convention or structure. After being manually amended, all of the various scores are entered into a Master spreadsheet. This is carried out row-by-row and takes several days, likely to be subject to interruptions
> In the process, a ranking column [..] had been wrongly transferred [..], erroneously appearing as an interview score. After their interviews, candidates were ranked 1 to 24 – with 24 actually being the total number of candidates interviewed in the region.
Is 24 an untypically low number of candidates for a region or are the files structured so badly it takes "several days" to merge a few hundred rows?
- sidewndr46 3y agoI'm unsure what your background is, but I've seen processes at companies like this. It would take several days to a week to aggregate less than a hundred data points and present it.
- richbell 3y agoOne of the first things I did as an intern was write an Excel macro that pulled data from SharePoint and built a monthly "dashboard" in the span of a few minutes. The previous process involved someone spending the better part of 2 weeks building the monthly report by hand, every single month.
- Rebelgecko 3y agoI did something similar. The person whose process was being automated hated it, because they got more work that was more challenging.
- db48x 3y agoCould be worse. I’ve read stories where the report was the only reason the person was hired, and the boss didn’t even bother trying to find different work for them to do.