You have chosen to sponsor your bid up to a maximum amount of .
We currently use an excel spreadsheet to make some function and calculate everything thru formula and multiple sheet.
We would like to port it on the web in order to ease the process.
We just need to transform the formula part in a sort of JS API, that will be called by the website.
So basically we want you to create a JS file with namespace and separate function. Private function should do the logic and public function should be called to get result.
We could provide basic prototype and excel spreadsheet in order for you to get a clear picture of the project.
This is a one time schedule thing.
Additional Project Description:
09/25/2013 at 21:08 BST
Ok, as many ask what was the point of all of it, I prefere to clarify a bit.
1. Take a look at simple_example.xls
This will allow you to fill the blue area.
Filling the blue area will give you some result in each cells. These result comes from calculation.
2. if you look at sheets_to_convert_logic_expose.xls, you will see the same sheet as the original document + the sheets that allow the calculation for each cells. Basically the three sheets are linked and work together. One calculate some tax, an other one calculate the income, an other one is in charge of percent, etc...
3. You have some default value that make all of this working. This default value should be taken as configurable value at the top of the JS lib. Thus when init the JS and if the rules are changing it will be easy to update the calculation.
4. All the logic part in the sheet and should never be expose to the end user. If some developer access to the JS lib/api he should just ask for a function like : tax_without_xx_and()
Hope it helps you better understand !