| ▲ | sherburt3 2 days 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 2 days ago | parent | next [-] | |
I 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-relati... 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 2 days ago | parent | prev [-] | |
> 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 | ||