All the usual financial stuff, job revenue modeling , building models of product / service cost vs revenue, capex needs , overhead scaling and all that fun stuff.
Project economics and NPV calculations and all the PowerPoint charts that are needed.
It gets used as a field invoice, field revenue and cost tracking per job, all manner of job and equipment performance report templates.
Scheduling templates and resource allocation.
Simple databases for job history , operational performance , issue tracking etc
Bill of materials , equipment build tracking , inventory, POs and goods recipt docs.(ok we got a quickbooks compatible ERP pretty quickly when we were a startup)
Some of that stuff gets imported into a system.of some sort (I’ll not start an SAP rant, we have some specific product mangement process data entry templates that make me a tad irate) but for the raw templates which need some sort of user input that’s not from a sensor measurement, they are still excel templates. The user base is not huge and they are trained company staff so it works. Anything I have control over has the requirement, you only enter a specific piece of information once, no matter where else it is needed and you better think about the input format.
This company has vast amounts of reports of useful past data we could mine, but it’s all pretty useless due to the way it was entered. That said I have. a couple of projects on the go for some people (not me for sure) to look at NLP to try and get something out of it all.
I did some Monte carlo simulation modeling many years back, that was pretty clunky until I found the crystal ball plugin software.
A lot of the other part of my day job is dealing with how to understand and make a decision from downhole sensor data . I often use excel as a scratch pad to work out the algorithms on ideal data , but then I punt it to matab for when I need more than a few test data points, and for sure when we get to real world data , that’s in matlab for sure. We also keep ‘sanity check’ spreadsheet so when new algorithms are implemented into the operational software we can hand check the outputs during software testing and actual real field trials.
It would be a strange day when I dont have multiple excel work books open for different needs.
Could I use project for scheduling , some data base for records and MS Forms or adobe or some such for forms, sure , but for ideation, quick work , flexibility etc you can’t beat excel. When you need to scale the tool , for sure move to something more suitable.