Hello,
I want you to design a PHP+MySQL application WELL DOCUMENTED in which it mimics the functionability of two excel spreadsheet that i will provide you (READ TILL THE END).
There in the spreadsheet it makes several calculations for each user (contained over a DB built on some data from the xls i will provide), where based on those calculations the application can filter/sort which users are in some risk level (there is low, medium and high risk levels) and display then in group of risk one by one. In addition, show some statistical graphics when asked.
The calculations will be made based on a DB TABLES that I need you to BUILD based on 9 columns of a xls file which contains data.
There has to be calculated 20 parameters for every user (represented with and ID number called NIT). Most of these calculation are basic statistics ones (Standart Deviation, Arithmetic Mean) The rest are just basic math (+ - / *).
A table of the DB based on the xls file that i will provide, must contain some info from the user that will help us to create a RECORD of some parameters, that at the end will give some percentage of the users that mets some requirements, and create some statistical graphics based on them.
I will provide the excel spreadsheet ONLY if you write me back with your proposal and the words "STJ2014" included on it (just to make sure you read this).
I will give you further details for the interface, which is going to be basic, nothing fancy.
BUDGET: $150 USD
DEADLINE: need to be ready on 25th March.
It’s a basic web app, that needs to be WELL DOCUMENTED (CODE) and recreate the calculations based on some data as shown on the excel spreadsheet when you ask for. PLEASE ALSO THE SPECIFY THE FRAMEWORK YOU WILL USE AND WHY.
If you are a great coder you can easily have this on done over the deadline