Craft and develop a complete API corresponding to xlsx file and formula in javascript.

Hi !

We are currently using an excel spreadsheet to make some automatic calculation of 4 types of tax deductions. Everything is calculated from formulas and multiple sheets (a total of 3).

It works as follow :

user fill the blue cells

other cells got filled automatically based on some calculations from hidden sheets.

user get result for the future deduction taxes.

We would like to port this on the web in order to ease the process and avoid people to buy excel or download openoffice.

We need you to transform the formulas in a JS library / framework, that will could use on the website.

To sum up, we want you to create one or multiple JS files with namespace and separate function. This files will expose public function in order to query and help to develop the HTML part that will render the results.

This is a one time schedule thing, no other project will be based on this. We do not need you to produce any design or html wireframe.


More informations :

1. Take a look at [url removed, login to view]

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 that are made by hidden sheets.

Please play with the excel, before bid. This development needs full comprehension of the math behind the calculation.

You can take a look at a part of the prototype realized here :

[url removed, login to view]

2. Look at the other sheets

Other sheets allows the calculation for each results cells.

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...

There are more than 20 separate functions that only do maths :

addition, percentage, sum, multiply, 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 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()

Thank you

Skills: Engineering, HTML5, Javascript, Software Architecture

See more: wireframe software development, web-based javascript spreadsheet, web 2.0 wireframe, three.js developer, the prototype part 1, spreadsheet javascript, spreadsheet in javascript, spreadsheet api javascript, schedule api, render software, public library website design, prototype update html, prototype files download, need a prototype made, maths website, library prototype, js spreadsheet, javascript download, get a prototype made, formula it, download wireframe, download develop html, design craft, complete prototype, calculation logic

About the Employer:
( 0 reviews ) Paris, France

Project ID: #6213825

6 freelancers are bidding on average $285 for this job


hi, i'm 15+ years experienced with strong knowledge of API integration , Plugin development and designing see my few portfolio Prestashop theme and payment plugin - [url removed, login to view] **CSM and eCom** More

$368 USD in 12 days
(18 Reviews)

PM for details .

$250 USD in 7 days
(12 Reviews)

Current API Jobs: [url removed, login to view] [url removed, login to view] https://www.freelancer. More

$232 USD in 7 days
(11 Reviews)

Hi Mate, I have seen your project post and surely telling you that we have an experience for this kind of project development. We are best in outsourcing business since 2004 and we have 250+ highly skilled develope More

$666 USD in 12 days
(0 Reviews)

I have similar experience of converting VBA/Excel code into JS/C#. So it looks like a comfortable assignment for me.

$222 USD in 3 days
(0 Reviews)

Recently I have devoted lots of time getting spreadsheets to work with web pages. I think I may have 2 options for you: 1: pure javascript: See [url removed, login to view] 2. An API type ca More

$388 USD in 3 days
(0 Reviews)

Hi, I hope you are doing well. I am willing to work with you. I have checked the excel sheet and I can create this calculator for you. I will build the JS library of this calculator and give that you with proper More

$250 USD in 20 days
(0 Reviews)