- Aug 20, 2003
Some of the ridiculous formulas they had on spreadsheets at my place, total CPU burners. People would open them and sit there whilst calculations were updating and all their cores would max out for 15 mins
Ive changed the whole place to pretty much run on views I write on a sql server on a warehouse I designed up for BI/olap. Well Holap really. Excel is mostly a front end now for a bit of power BI
I wish I had that power, but SQL (or whatever) with Excel front end with power bi definitely the way forward.
I don't do formulas any more - because (as you know with power bi) you don't have too....
For individual projects, I usually like installing SQL Express on client machines and let them get on with it. I concentrate on writing code to get the data in (usually c#) , because I get presented with spreadsheets that are impossible to import as is - even when automatically created - because they been have written as "reports".
If you need any help importing spreadsheets into a DB, just ask because I've seen it all (all versions of Excel) and a have a "patent" way of doing it.