Completed

MySQL to Excel

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: MySQL, PHP, Software Architecture

See more: excel mysql, work on line jobs, two week jobs, technicians needed, technicians jobs, technician jobs in, technician jobs, simple timecard, security technician jobs, ot technician jobs, ot jobs, one hour jobs, job technician, jobs technician, jobs in security, jobs available on line, job for a c technician, internet security jobs, i need a technician, how would one find a data entry job, how to find technicians, how to find jobs, how to find data entry jobs, how to find data entry job, how to find a job

About the Employer:
( 3 reviews ) Chadds Ford, United States

Project ID: #5320657

Awarded to:

AphroECS

Hello, We have expertise in reporting and MySQL related tasks. If you can send me two formats: 1) existing report (in html) 2) desired report format (in Excel) I am sure to work around it to deliver it as you l More

$515 USD in 10 days
(110 Reviews)
8.0

59 freelancers are bidding on average $464 for this job

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

$773 USD in 15 days
(157 Reviews)
9.2
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$927 USD in 4 days
(834 Reviews)
8.4
babysoftS

Hi, I am experienced PHP developer and I understand your requirement to generate the reports for the different search queries on the data of technicians data store in MySQL. I can write a small script that will gen More

$250 USD in 3 days
(121 Reviews)
7.6
fattahaabdul

I will make a way to create a report against the database. I did these type of work in fast so i am best person for you. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so t More

$1030 USD in 10 days
(83 Reviews)
7.7
sritechnocrat

Hello Sri Technocrat will provide fully interactive application/website for your project. As per the detail, Sri Technocrat will provide three template functional schemes and sample pages to make your choice for lay More

$684 USD in 30 days
(70 Reviews)
7.5
shikhamehta

Hey, I read through your requirement and as you also mentioned, there are two ways to accomplish what you are looking for. First is to import data in excel, do some manipulations and present the results. Other is to cr More

$611 USD in 10 days
(229 Reviews)
7.0
eperfections

10+ years experience. 600+ projects completed successfully. Very interested in this project. There is no file attached. Please send me complete details. Ready to start ASAP.

$515 USD in 5 days
(257 Reviews)
7.3
petermyvw

You can have me produce a web app which enables you to get the excel data from the MySQL database. It will of course include the business logic you described for grouping the total hours worked. As you indicated in More

$368 USD in 14 days
(214 Reviews)
7.1
mohanchauhan

Hi Sir, I am a lead programmer as i have 10 years of working experience in php,mysql,ajax, jquery, javascript, css, html, Graphics Design. I am a lead developer with a team of developers and designers. I have expe More

$309 USD in 5 days
(75 Reviews)
7.1
ajaxdevman

Hi, Ready to take on this project and guarantee top grade results. I have long experience with creating reports from MySql data. Regards, Nader Moussa.

$555 USD in 10 days
(42 Reviews)
6.8
zeke

Dear Customer! I am an expert PHP developer with over 6 years of experience and very interested to work on this project. Available to start immediately and finish as soon as possible. My bid is for fast professional s More

$515 USD in 10 days
(182 Reviews)
7.5
tzo

A proposal has not yet been provided

$265 USD in 10 days
(291 Reviews)
6.9
rajawi9999

I'm expert in web development for more than 12 years, I'm highly skilled in php , ajax, jquery, SEO, SOAP & XML...I'm ready to start I can start right away. Thanks.

$260 USD in 3 days
(180 Reviews)
6.7
AcuityInfotech

Hi,    We’ve had a good look at your project description and we’re very interested in providing a solution. Please PM us so that we can discuss further.     We are a professional development company headquartered i More

$368 USD in 5 days
(41 Reviews)
6.9
urmate

HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks More

$250 USD in 3 days
(181 Reviews)
6.4
caneadysl

Hi Requirement clear Will you send me the sample database to analyze first I am a master of php more than 11 years now ,I can deliver what you need as it is Waiting for a reply

$383 USD in 5 days
(54 Reviews)
5.8
schungur

EXPERIENCED DEVELOPER. PLEASE CHECK MY BADGES (SQL Level3 100%), REVIEWS AND PROJECTS... and ensure yourself that I can do this job....

$444 USD in 10 days
(29 Reviews)
5.8
spencerb

When you already have the data you need in the DB, Excel is very lenient about what formats it will read and extracting the data from the DB is extremely easy. In this case, I believe you are already set up with all t More

$250 USD in 2 days
(49 Reviews)
5.8
hrarcon

Ready to work on your [url removed, login to view] can do your project as per your requirement. We have good and experienced developers,Testers,Linux Admin,DB Admin,Asterisk PBX,opensips and UI Designers Our team from Chennai,India( More

$789 USD in 25 days
(15 Reviews)
5.9
irenicus

Dear Sir or Madam, I am developer with big experience in database related work and I worked on many projects involving Excel spreadsheet data import and/or export. I can start working on this immediately and I can f More

$300 USD in 2 days
(47 Reviews)
5.9