I just started my internship as a computer science student. The project I'm working on is web based price calculation. Previously, the price calculation have been done in a quite huge excel spreadsheet, taking a ton of factors into account when calculating. My first thought when tasked with this, was to study the spreadsheet and make some code that did it all. But, then I was presented with a problem: I'll only be here for 3 months and there are nobody in the office that can do any coding, so how are they going to maintain the calculations when new factors have to be implemented? Therefore, they would far prefer to keep the spreadsheet and have some code that interact with the spreadsheet to calculate the price. But in a server environment, Excel won't be running and as far as I've been able to research, interactions via oledb, only access the data of the spreadsheet and none of the formula will update when new data is being input.
So, my question is: are there any ways to solve this issue with having the spreadsheet formula update without having excel running on a server, or are there any other easy maintainable way for people without coding knowledge to use, to implement the business logic?