The project is divided in two part:
1) Python Script
-> Read an Excel File: all the sheets (see attachment)
-> the sheets have this format [login to view URL]:variableName
-> [login to view URL] can have several variables in the example is only three (F_B1_H , F_B2_H, F_B3_H) but the script should be able to group for each [login to view URL] all the variables
please note that the variable name i.e: F_B1_H are not the real one so the script should work with any variableName.
-> the two values per each sheet are important: the timestamp and the value (see example)
-> Create a single Excel Sheet with all the values and with an header for each [login to view URL]:variablename
-> connect to a mysql database
-> create tables named SURNAME for each SURNAME in the excel (create if not exist)
-> create fields in each table caleld variableName (in the example F_B1_H , F_B2_H, F_B3_H)
-> add (append) the timestamp and the value to a new row for each table as found in the excel file
2) Php + bootstrap
Nice visualization of the data from the SQL database
each SURNAME with all the values recorded
specify if in the bid you think you can use a chart javascript such as [login to view URL] to graph the timeseries for each SURNAME
I have an extensive programming background and I'm very skilled with python, so I can provide good quality code. I have also experience with PHP and web technologies so I can handle the frontend task as well. I read and write English fluently. I have worked with js charting libraries like highcharts I can work with the referred one as well.
I would like to apply this job, My experience of 5 years in development and my implementation power keeps me one step ahead for working with any web based application with a very high speed.
I am pro with PHP, Zend, Wordpress, & CakePHP and other related technologies.
Why me?
I believe in Pro active communication and quality delivery. I ensure you that I will satisfy with my work. We can discuss more over chat.
Thanks
Hello, my name is Enrique and i can provide you a solution for your needs.
Do you have any special requirements for the software versions ?
The php need to be made using Bootstrap ?
Just registered few days ago so i'm looking forward to close this deal to make you my first client in this portal :)
Best regards,