MadAsAHatter
Well-known member
Starting a thread to bitch about stupid shit at work that ends up pissing you off.
I'll start.
People seem to rather work harder than smarter...
Our QA officer discovered an oversight in one of our quality tracking spreadsheets. It was calculating a pass/fail on mean value only where requirements are to calculate for mean and individual values. Not a big deal because its rare for mean values to pass, but not individual values so we weren't out of compliance anywhere. Plus you can glance at individual values and know if it passed or failed without the spreadsheet displaying pass/fail. But for ease of evaluation (and lazy people not paying attention) it's better for pass/fail to be shown on the spreadsheet.
So spreadsheets need to be updated to include this. It's not my responsibility to do it, but attempting to be helpful I made copy of the spreadsheet and a quick formula to do the calculation and display pass or fail; took me less than 2 minutes. While I was at it I also deleted password protection on that copy of the workbook; they lost the passwords over a decade ago and have to difficultly work around it so they don't have to redesign the entire thing anytime there's a needed update.
I send a screenshot of what I did just to show them it works. I noted that I didn't do any formatting, just showing that the formula worked, and offered to design a template. I don't even get a thank you for the effort or we appreciate the offer. Even though what I presented accomplishes the exact same thing only easier; just need to write the formula once then copy paste to appropriate cells, the response I get is how what I presented isn't good and long winded explanation of how they will do it. Their way requires creating a formula and rules for each cell where needed. Plus they'll still need to work around that pesky password protection.
Well... sorry I offered to help. I could have had it all updated in about 20 minutes and make easier to edit in the future. But you go ahead and take several weeks to do it your way.
I'll start.
People seem to rather work harder than smarter...
Our QA officer discovered an oversight in one of our quality tracking spreadsheets. It was calculating a pass/fail on mean value only where requirements are to calculate for mean and individual values. Not a big deal because its rare for mean values to pass, but not individual values so we weren't out of compliance anywhere. Plus you can glance at individual values and know if it passed or failed without the spreadsheet displaying pass/fail. But for ease of evaluation (and lazy people not paying attention) it's better for pass/fail to be shown on the spreadsheet.
So spreadsheets need to be updated to include this. It's not my responsibility to do it, but attempting to be helpful I made copy of the spreadsheet and a quick formula to do the calculation and display pass or fail; took me less than 2 minutes. While I was at it I also deleted password protection on that copy of the workbook; they lost the passwords over a decade ago and have to difficultly work around it so they don't have to redesign the entire thing anytime there's a needed update.
I send a screenshot of what I did just to show them it works. I noted that I didn't do any formatting, just showing that the formula worked, and offered to design a template. I don't even get a thank you for the effort or we appreciate the offer. Even though what I presented accomplishes the exact same thing only easier; just need to write the formula once then copy paste to appropriate cells, the response I get is how what I presented isn't good and long winded explanation of how they will do it. Their way requires creating a formula and rules for each cell where needed. Plus they'll still need to work around that pesky password protection.
Well... sorry I offered to help. I could have had it all updated in about 20 minutes and make easier to edit in the future. But you go ahead and take several weeks to do it your way.