i have one excel calculator file which contains several sheets and formulas searching across sheets.
I've built up mySQL database to store these data for lookups...using php forms should get user inputs
Is there a way to do this that ensures the accuracy?
The formulas are pretty tough as well. In your case, probably you need to translate a couple of formulas, which can be done by hand. Just assign an unique id to each td in the html (it can be the cellId from excel, like R30), and translate the formulas to JS. To mimic the excel cells, you can place input[type=text] tags in the editable tds.