2 ms·
What are some Software Development methods for reducing errors: 1. AUTOMATED TESTS; test assertions To write spreadsheet tests: A. Write your own test assert
by westurner 3y ago
What are some Software Development methods for reducing errors:
1. AUTOMATED TESTS; test assertions
To write spreadsheet tests:
A. Write your own test assertion library for their macro language; write assertEqual() in VBscript and Apps Script.
B. Use another language with a test library and a test runner; e.g. Python and the `assert` keyword, unittest.TestCase().assertEqual() or pytest.
C. Test the spreadsheet GUI with something like AutoHotKey.
From https://news.ycombinator.com/item?id=35896192 https://news.ycombinator.com/item?id=35896192 :
> The Scientific Method is testing, so testing (tests, assertions, fixtures) should be core to any scientific workflow system.
> awesome-jupyter#testing: https://github.com/markusschanta/awesome-jupyter#testing https://github.com/markusschanta/awesome-jupyter#testing
> ml-tooling/best-of-jupyter lists papermill/papermill under "Interactive Widgets/Visualization" https://github.com/ml-tooling/best-of-jupyter#interactive-widgets--visualization https://github.com/ml-tooling/best-of-jupyter#interactive-wi...
- westurner 3y agoPandas docs > Comparison with spreadsheets: https://pandas.pydata.org/docs/getting_started/comparison/comparison_with_spreadsheets.html https://pandas.pydata.org/docs/getting_started/comparison/co... Pandas docs > I/O > Excel files: https://pandas.pydata.org/docs/user_guide/io.html#excel-files https://pandas.pydata.org/docs/user_guide/io.html#excel-file... nteract/papermill: https://github.com/nteract/papermill https://github.com/nteract/papermill : > papermill is a tool for parameterizing, executing, and analyzing Jupyter Notebooks. [...] > This opens up new opportunities for how notebooks can be used. For example: > - Perhaps you have a financial report that you wish to run with different values on the first or last day of a month or at the beginning or end of the year, using parameters makes this task easier. "The World Excel Championship is being broadcast on ESPN" (2022) https://news.ycombinator.com/item?id=32420925 https://news.ycombinator.com/item?id=32420925 : > Computational notebook speedrun ideas: