4 ms·
I think you'd find some fascinating answers on accounting, finance and actuarial forums, that might not turn up on HN. A few years ago I worked on a couple of
by ploika 6y ago
I think you'd find some fascinating answers on accounting, finance and actuarial forums, that might not turn up on HN.
A few years ago I worked on a couple of different financial services projects that involved porting massive Excel-based jobs over to sturdier setups. Even the relatively simple spreadsheets (for people with a finance background) were long, complex projects that needed an RDBMS, an R or Python program, and a web app to do what Excel was just about handling on its own.
- huhnmonster 6y agoThis. The stuff I am working on is mostly glorified ETL. Some sheets of course are user facing and will have a nice sheet inside the workbook where everything is summed up. Generally it looks like this: 1. Get data from a central source (data warehouse/other departments) 2. Transform/combine different sources etc. (mostly with pivot tables) 3. output to a sheet 4. add some sort of automation so it runs on its own the next time