MySQL to Excel - repost
$250-750 USD
Paguhet në dorëzim
I have a MySQL database on the internet. The database contains daily work entries from our field technicians. They enter the information though a web page. I would like to find a way to create a report against the database that would be each technicians timecard but there is some data manipulation involved. Each day every technician entry is a separate line item in the database. I would like the report to be able to select one technician, for a specific time range, and add the hours together for each job as a sum total. For example, in a two week time period a single technician may have worked on three jobs, one with overtime. This may be as few as ten entries in the database but could be more depending on if he worked on two jobs in one day. I would like a report in excel that gives me three lines only (the three regular hour jobs with regular time total and the overtime job (same job number, just OT hours) with time total).
I can make a replicant of the current database available for development and an example of what the end report in Excel should look like is included below. All the information in the spreadsheet (minus the sum totals) is available in the database. I am open to suggestion on how to implement this (could be another web page). Some simple security would be needed as well. I can modify the database as need to suite functionality.
ID Projekti: #5321155
Rreth projektit
7 profesionistë freelancer dërguan një ofertë mesatare prej $373 për këtë punë
Hello, I would like to use my expertise and knowledge to accomplish your project with highest order of dedication. I can understand the requirement easily and have good knowledge to keep documentation of each wor Më shumë
Hello Sir, Ready to Start, First Can You show me your Work Details then i can check and let You know How much time take to complete and also can let you know the price of this work done, Expect Your Positive Reply R Më shumë
Hi, I'm very interested helping you creating the reports from your Mysql database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesit Më shumë
Hi, Currently I'm employed by one of the major retailers in the UK working as site merchandising analyst. I'm developing VBA projects to support automated reporting. With my previous job I've developed a mysql to ex Më shumë