5 ms·
Reviewing the individual formulas in an excel report is psychotic. Normally what I would do when checking someone elses work for errors is spot check a couple o
by sherburt3 1mo ago
Reviewing the individual formulas in an excel report is psychotic. Normally what I would do when checking someone elses work for errors is spot check a couple of the values in a column and calculate them by hand to see if they matched up. Either that or just implement the step myself in excel and see if I got the same output.
That's a lot like reviewing someone's regular expression. Like I'm not going to read through a 100 character regex to see if it matches semantic versions, I'm just gonna pull it up on a regular expression tester and see if it does what it should.
- fodkodrasz 1mo agoI have just recently learned there is a great feature for this, which I really miss in LibreOffice, since I came to know it exists: https://support.microsoft.com/en-us/excel/display-the-relationships-between-formulas-and-cells https://support.microsoft.com/en-us/excel/display-the-relati... https://support.microsoft.com/en-US/Excel/see-links-between-cells-in-excel-for-windows https://support.microsoft.com/en-US/Excel/see-links-between-... These really helped me to review low-to-mid complexity sheets where inserted rows and incorrectly copied formulas messed up stuff.
- eviks 1mo ago> Like I'm not going to read through a 100 character regex to see if it matches semantic versions, I'm just gonna pull it up on a regular expression tester and see if it does what it should. How? Do you have all the values from the semantic versions lying around for a comprehensive test in the engine? But also those 100 chars can be in 10 lines with comments, so you can fire the engine on specific parts to help with verification