possible to do this calcluation in javascript 2

[tyutghf]

I have a spreadsheet with calculations in, enter some figures into some fields and a kind of pivot table is created which then generates the results.

[URL unfurl="true"]http://speedy.sh/CM3db/Website-Calculator.xlsx[/URL]

Is it possible to do this in javascript or will I need to use php and create temporary tables in a database to generate the figures from rows 11 to 27?

Thanks

 

[tyutghf]

It works with a variety of tests now, I can't thank you enough. I have noticed lots of changes in this, my plan is to now go through this any comment for myself to try to explain everything that is happening at each stage and learn from it and hopefully produce some more of these myself.

Thanks again

 

[jpadie]

the main changes were to create a nomenclature that mapped the cells to variables so that you could trace, for example, how B6 was being used. i didn't use the new nomenclature slavishly but hopefully used it in the bits that you need to follow to maintain the code.

also the code now automatically updates the table whenever any of the figures are changed, and validates the lower threshold of the principal amount.

lastly i also adjusted the css to make it display a little more like the spreadsheet.