Ask HN: What do you use Google Sheet or Excel for?

Re:Ask HN: What do you use Google Sheet or Excel for? by ploika on Monday August 24, 2020 @02:42PM (#24263915)

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.

[ Parent | on HN ]

Re:Ask HN: What do you use Google Sheet or Excel for? by huhnmonster on Monday August 24, 2020 @05:47PM (#24265931)

This. 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

[ Parent | on HN ]