To know if the results of scripts are correct, we should also have another (preferably, more controlled/manual) method of calculating same results. Best way to do so is to use Gsheets (not using MS Excel for accessibility) and do equivalent calculations on same input. Which will be matched with results from scripts to verify the scripts are working as expected.
To know if the results of scripts are correct, we should also have another (preferably, more controlled/manual) method of calculating same results. Best way to do so is to use Gsheets (not using MS Excel for accessibility) and do equivalent calculations on same input. Which will be matched with results from scripts to verify the scripts are working as expected.