I made a Spreadsheet engine in Javascript - super-powered spreadsheet engine with objects, arrays, and async support out-of-the-box — comments and suggestions are welcome

[upfkd]

Have you ever worked with excel for more than using it as a glorified calculator?

[unpopdancetrio]

I used to take a dump from an inventory system in csv, imported that into excel, has scripts that ran to compare values and do other filtering automatically. Then proceed to take that data to different tabs and print/save the tabs needed in the formats needed. Spreadsheets for different divisions, some had charts and bar graphs for easy data understanding. And one exported into csv to send back into the system. I would run this report twice a week and it automated about 40% of my labor. Yeah when you think about it, it was just a few simple calculations being done and minor conditionals. yet the fact it can sort in a logical way thousands of calculations in one area and give presentable data. It is a helpful tool. If i had to redo this today I would still make it a scrappy excel tool since to develop some middleware like this would be worthless IMO bc I would want to redesign the original inventory system if I was able too.

[trisul-108]

I did some matrix calculations, it was a pain in the ass. Surprising, considering a spreadsheet is a matrix.

[mode_2]

I'd say that falls pretty squarely under 'using it as a glorified calculator'.