3 ms·
If your data is entered in a spreadsheet, is it really faster and easier for you to run the data through another tool, rather than just writing the formulas rig
by PeterisP 13y ago
If your data is entered in a spreadsheet, is it really faster and easier for you to run the data through another tool, rather than just writing the formulas right there in front of you?
You definitely can do it in R, but the formulas are trivial anyway and writing them in code takes as much time as in Excel, can you help me understand what I could gain by using R here?
- malandrew 13y agoI imagine that the spreadsheet is there to support an easy input format that anyone can get involved with. The spreadsheet basically only holds the assumptions and the facts. Then all the modeling is done in something where following the flow control is far more readable because you're dealing with long well named variables, which are rare to none existent in most spreadsheets. When I worked in Wall Street level finance, basically none of the analysts bothered to use anything more than cell address, e.g. /[A-Z]\{0,1}[0-9]\{0,3}/. They basically treated naming their variables like most software engineers treat commenting their code. That shit was impossible to follow because. The individual formulas may be trivial, but when you have a complex model with many pages representing different aspects of the business internally and external macro aspects, it can get messy fast.