Closed

MySQL to Excel - repost

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.

Skills: Corporate Identity, Logo Design

See more: excel mysql, work on line jobs, two week jobs, the logo design suite, ten one design, technicians needed, technicians jobs, technician jobs in, technician jobs, some one to create me a logo, simple way to create a logo, simple timecard, security technician jobs, ot technician jobs, ot logo design, ot jobs, one hour jobs, make security logo, job technician, jobs technician, jobs in web design and development, jobs in security, jobs available on line, job for a c technician, internet security jobs

About the Employer:
( 0 reviews ) Coronel Oviedo, Paraguay

Project ID: #5321155

7 freelancers are bidding on average $373 for this job

mgliviu

Hi, I have worked in the past 8 years in management decision support systems and the development of business management tools. I have also offered support services for analysis and planning new IT projects. I think I'm More

$300 USD in 10 days
(7 Reviews)
3.9
shamdeshmukh

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 More

$388 USD in 3 days
(0 Reviews)
0.0
silentdream2121

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 More

$290 USD in 10 days
(0 Reviews)
0.0
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$444 USD in 10 days
(0 Reviews)
0.0
vorticesoft

La propuesta todavía no ha sido proveída

$250 USD in 10 days
(0 Reviews)
0.0
elboukharimu

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 More

$609 USD in 10 days
(0 Reviews)
0.0
excelmacrosvba

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 More

$333 USD in 3 days
(0 Reviews)
0.0