Closed

Convert xlsx file and formula into a JS API - repost

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.

2. Look at [url removed, login to view],

You will see the same sheet as the [url removed, login to view] + other sheets that allow 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.

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: web framework top 10, web-based javascript spreadsheet, web 2.0 wireframe, three.js developer, spreadsheet in javascript, spreadsheet api javascript, schedule api, render software, public library website design, js spreadsheet, formula it, download wireframe, convert excel to website, calculation logic, ask software developer, api architecture design, openoffice project, js framework, excel spreadsheet formula, excel sheet formula, excel help formula, look for api developer, download website developer software, download top developer, xlsx

About the Employer:
( 0 reviews ) Paris, France

Project ID: #5043726

12 freelancers are bidding on average $191 for this job

toinnisfree

I have read your project details, and I am interested in offering my services. I provide 100% satisfaction guaranteed on all my work. Milestone is required to begin; to be released when the job has been satisfactor More

$200 USD in 3 days
(170 Reviews)
7.0
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$144 USD in 3 days
(40 Reviews)
6.8
salmanaim

I have an extensive experience in javascript / jQuery . I have carefully read and understood the details, and reviewed the document. I understand javascript OOP concepts as well so I can make a proper structure in js w More

$226 USD in 3 days
(14 Reviews)
6.3
SharpMinds007

Hi If you can provide me the design i can add this excel sheet functionality to that. as many fields are involved in it API feature is not suitable i guess. Regards

$277 USD in 3 days
(126 Reviews)
5.8
nitelfreelance

Hi. The [url removed, login to view] ([url removed, login to view]) might help to implement the functions easily. On the other hand you may use Google spreadsheets! Thanks

$140 USD in 5 days
(14 Reviews)
5.2
pallavibk

hi I am experienced developer. I can create these javascript function and apply it in HTML page. but my query is don't you want to save data? thnaks

$222 USD in 5 days
(12 Reviews)
3.7
umadevisathesh

Hi, I am Umadevi, having 5+ years of experience in HTML,JavaScript,JQuery,Java,J2EE working in MNC, for developing web based product. I will do this job. Please contact me with the details

$100 USD in 3 days
(4 Reviews)
2.9
doyz

Hi Sir, I am interested in converting this xls to JS lib, I am experienced and certified in programming. I am graduated from Mathematics Department, maybe this is match with your needs. Please let me know should y More

$155 USD in 5 days
(3 Reviews)
2.8
logoDS761

Hello, i am very experienced vb6 / vba macro coding in all Ms. Office + JS javascript inside html, and will do this excellent quality

$155 USD in 7 days
(5 Reviews)
1.8
linuxsqlvoipvpn

Hi, I have know how to do your project. I think do it in php , what do you think about it ? I have a question about the file example , the static data and the algorithm you need to change or not?

$250 USD in 15 days
(1 Review)
1.2
fetrovsky

I know many programming languages and algorithm theory, and a programming background which goes back to the early 90's; this allows me to develop very efficient and elegant code, and to avoid common pitfalls. Besides More

$222 USD in 5 days
(0 Reviews)
0.0
alain34

Bonjour Super Dady, J'ai toutes les connaissances necessaire pour livrer votre projet (html, Js et Web Development en General). Je suis francais et il semble que vous ayez besoin de quelqu'un qui sait lire cette More

$200 USD in 7 days
(0 Reviews)
0.0