I’ve got some excel workbooks I use at work.
They have an input sheet as the first sheet, all the data then feeds through formulas in the other sheets.
I was wondering if it wasn’t possible to put them in a web based format.
One page for the inputs, click ‘submit’, the input page runs through the formulas and then the next page loads with the outputs or generates a pdf with the outputs on it.
Assuming this is possible... can someone give me the basics on how you would get that to work? It seems simple in my head but how ‘difficult’ would it be for someone that knows how to do it?
Thanks
Chris
Comments
But that's probably not helpful.
Have you tried loading it into Google Sheets and see if it gets converted?
Or can something in Microsoft's online tools do it?
Failing that stump up some cash and a programmer (cough) can do it.
I know there’s a few computer bods on here so i’d just like to grasp what’s involved/possible so I can fine tune my ideas.
It would be for external use and is sort of the base of a online business so would need to look decent.
@darthed1981 is this your line of work? How much would it cost to build a web app as you described?
EDIT: Or basically what @darthed1981 said.
EDIT2: Just looked at the spreadsheet converter. You might pay someone who just runs it through that. The results look impressive.
In my experience spreadsheets very quickly become a crap substitute for a proper app with a database behind it.
Alas to this day nobody has come up with a really easy to use app development framework for the web.
The closest I've found is Google's Appmaker.
Similar to MS access but built for the web.
Need to know java script though.
But you might get something easier by searching for "form building tools online".
e.g. https://www.jotform.com/
@roundthebend thanks for the offer. Let me firm up my plans and I will give you a shout.