4 ms·

Spreadsheet errors can have disastrous consequences – yet we keep making them

3 points by jethronethro 3y ago

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 ago
  Pandas 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:

3 points by jethronethro 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 ago
Pandas 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: