JQUERY Calculation -> Build jquery from xls-file

IN PROGRESS
Bids
15
Avg Bid (USD)
$368
Project Budget (USD)
$250 - $750

Project Description:
*Objective*


We use a .xls-spreadsheet (Windows Excel Doc) on our pc to calculate. This spreadsheet shall now be put online on a website. The xls therefore has to be coded in/converted to javascript using jquery and be embedded in a html-file. The formulas in the spreadsheet are pretty much forward and base on basic mathematical formulas.



*Flow*


User enters the website and can fill out form with digital numbers. User then submits the form and the script calculates and puts out the result on screen.

Depending on the result the cells are formatted in a color. For example: a cell with a positive result (+1) is formatted in green, a cell with a negative result (-1) is formatted in red. A style-sheet for formatting of cells will be provided.

In a second step, the user can reset the spreadsheet or enter different numbers and start the calculation again.

User can print the result or generate a pdf-file containing the spreadsheet and a logo.


*Formulas & Calculation*


The formulas are all pretty much straight forward: multiply, divide, subtract and add.

You can check out all formulas in the provided spreadsheet.

Some of the results are rounded up, some are rounded down to the next higher/lower full digit. Some of the results and input-forms have one, some two and some three decimal places.


*Function*

User can enter digits in four fields (see attached xls-file).

User can reset form.

User can print form.


*Technology*

The application will run on a single server.

jquery must be used for creating the application.

All strings used in the frontend need to be able to be edited by us for i18n. During development the correct spelling and/or content of the strings is secondary. All strings (Application/Fields/etc) must be customizable using simple textfiles.

An html- or php-file should be used to embed app.

App must work in FF 3.5+, IE7,8,9, Chrome and Safari.



*Interface/Design/Screens*

The app must fit into a rectangular box with max. dimensions of 900 (width) and 600 (length) pixels.

The app is styled with css. Use a separate .css-file so that we can change colors afterwards.

Formatting, depending on the result, (e.g. red for negative numbers, green for positive numbers), is applied to cells/lines. Styleguide for formatting will be provided, you have to adapt the styleguide to layout/style css.


Some of cells will have a help-bubble. Icons and text are provided.




*Documentation*

The project has to be documented inline using standards conventions and in written english as a PDF file.

Important

Coder must be able to speak/understand English. Please read through this specification again. Please look at the enclosed xls-file before you provide a quote. Please calculate an extra 3 hours for small design changes after the first milestone. Start your reply/PM with “UNDERSTOOD” or I will ignore it.

Skills required:
AJAX, Javascript, jQuery / Prototype, PHP, Software Architecture
Additional Files: matrix-freelancer.xls
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 700
in 15 days
Hire MaximVolobuev
$ 250
in 5 days
Hire stolho
$ 250
in 0 days
Hire xfinder
$ 750
in 12 days
$ 325
in 5 days
Hire yassir2
$ 350
in 1 days
Hire rolanro
$ 430
in 7 days
$ 250
in 0 days
Hire TihiKaric
$ 330
in 12 days
$ 250
in 10 days