Hi all,
I work for a small company and I often develop spreadsheet tools that take various user inputs (dropdowns, sliders etc - forms controls mainly), perform some calculations (with or without VBA), show outputs (charts etc) and record user input settings, comments etc. Typically I only need to distribute these to a handful of people so I just send them each the spreadsheet and wait for them to email them back to me.
I'm wondering with the advent of Office 2016 and all that whether there might be options that would allow me to achieve the same ends via some kind of web-app / browser-based form? I've played with the basic survey feature in Online Office but this is too limited - I need to have user inputs linked to my model and show outputs as someone uses the interface.
Anyone any thoughts on how this might be done? Is this something that might be possible with the help of a developer maybe? I'm just not sure where to start and I have no idea whether this is a pipedream or something viable with a bit of effort. I'd be willing to invest some time and $ into this if it were remotely doable.
Anyway, any suggestions to put me on the right path would be much appreciated. Thanks!
I work for a small company and I often develop spreadsheet tools that take various user inputs (dropdowns, sliders etc - forms controls mainly), perform some calculations (with or without VBA), show outputs (charts etc) and record user input settings, comments etc. Typically I only need to distribute these to a handful of people so I just send them each the spreadsheet and wait for them to email them back to me.
I'm wondering with the advent of Office 2016 and all that whether there might be options that would allow me to achieve the same ends via some kind of web-app / browser-based form? I've played with the basic survey feature in Online Office but this is too limited - I need to have user inputs linked to my model and show outputs as someone uses the interface.
Anyone any thoughts on how this might be done? Is this something that might be possible with the help of a developer maybe? I'm just not sure where to start and I have no idea whether this is a pipedream or something viable with a bit of effort. I'd be willing to invest some time and $ into this if it were remotely doable.
Anyway, any suggestions to put me on the right path would be much appreciated. Thanks!
