| ▲ | WorldMaker 16 hours ago | |||||||||||||
An application I consulted on was a web interface that made heavy use of the Excel portions of Microsoft Graph so that the finance team could continue to send clients spreadsheets that they could adjust without also sending them the formulas to "steal" (and take other parts of their business elsewhere, to noticeable millions of dollars of project spending habit shifts). The finance team wasn't going to stop using Excel ("how dare you suggest it"), so it was wildly custom solution to figure out where formulas existed in any of the spreadsheets finance felt like giving to the app, build a custom UI for entering the inputs to those formulas, run those formulas most with Microsoft Graph cloud magic/some with other web libraries, and return the results. If it were just about any other group than that company's "finance department" that so deeply wanted "just tightly wrap Excel in a web UI and leave the key computations as Excel formulas we can continue to edit in Excel because all we want to understand is Excel" project would probably have been rightfully laughed out of the room. Finance has the keys to a lot of companies and like keeping those keys for comfort in Excel. | ||||||||||||||
| ▲ | jimnotgym 12 hours ago | parent [-] | |||||||||||||
>The finance team wasn't going to stop using Excel ("how dare you suggest it"), If the finance team suggested you have to write all of your code in C using Emacs would you be OK with that? | ||||||||||||||
| ||||||||||||||