Interactive user input to calculated output

Hi,

my goal with a squarespace site is for a user to input values, ex. latitude, day of year, etc, and then receive an output value. I have an excel sheet which does this function, however I would like the display to be interactive for the user (and also look simple, hiding all the steps in calculation), and the sheet I have embedded is not interactive. 

Thank you,

T

I do not have a solution but a place to start.

I would suggest a form block with custom JavaScript that would make the calculation upon submit. The JS would need to prevent the default behaviour of the SS form button, make the calculation and then present that to the user, perhaps in a custom code block with a div element or some such to receive the output.

If the formula is a, straight forward, here are some numbers, and just make a calculation then JS should be able to handle that OK. If the calculation involves spreadsheet functions then things can be harder to represent in JS.

You would need the business plan or above for the custom JS.

If you are not a developer then you'll need to hire a consultant. I say the project is probably of medium difficulty. It's hard to say for sure without knowing more about the calculation itself.