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.
User can enter digits in four fields (see attached xls-file).
User can reset form.
User can print form.
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.
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.
The project has to be documented inline using standards conventions and in written english as a PDF file.
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.