My first job out of uni was developing a devops pipeline for Excel spreadsheets after one went rogue and cost the broker trader I was hired by $10m in one fun afternoon.

▲

jimnotgym 12 hours ago | parent | next [-]

And a devops pipeline developed by a recent graduate is guaranteed 100% error free?

	▲	9 hours ago \| parent [-]
		[deleted]

▲

WorldMaker 16 hours ago | parent | prev [-]

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?

	▲	WorldMaker 9 hours ago \| parent \| next [-]
		I would like to see the finance team that codes all their own C code and is adamant it needs to be in Emacs, especially because if they are that deep in Emacs I'd be wondering why they are insisting on C rather than Emacslisp or something even more esoteric like GNU Guile or someone's custom Forth to Fortran compiler… But to answer the question, that is where I finished. We weren't "okay with it" that the finance team insisted on a C# to Excel files in SharePoint/OneDrive via Microsoft Graph turducken. We lived with it because the finance team had enough of the metaphorical keys to the car to be deeply in the driver's seat of that project. Sometimes you just have to grit your teeth and deliver what the customer wants.
	▲	noosphr 9 hours ago \| parent \| prev [-]
		It's how Linux is written so they must have great taste.