MySQL to Excel

Budget $250 - $750 USD
Bids 63
Average Bid $458

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.

Post a Project Like This

This project was awarded to

About the Freelancer

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • sritechnocrat Profile Picture

    sritechnocrat

    Lucknow,  India

    Sri Technocrat offers a software services to its clients seeking customized software solutions. Be it complete office automation or database driven solutions, Sri Technocrat is the one stop solution center for all your software requirements. We provide you with customized software at competitive prices with free training and support. Vision To be counted amongst top software giants. Mission Quality, reliability and dependability be associated with every product we deliver. Management The company is managed by engineering graduates having formal training in software development. Technical and Management skill is provided by graduates of Indian Institute of Technology (IIT) and Indian Institute of Management (IIM). Services Research team at Sri Technocrat works towards implementation of clients projects. The service is apart from applications which are fined tuned to customer requirement. Over and above training and full documentation, Sri Technocrat provides round the clock help and support on all its products and applications.

    PHP, ASP, Javascript, and XML

  • scripish Profile Picture

    scripish

    Colombo,  Sri Lanka

    I am a Software Engineer who works in a reputed company for the last 6 years in .net technologies especially in Amazon Web Services, vb.net, c#.net, Zebra label printer ETL and also MySQL, MS SQL Server Programmings.In the meanwhile I am working on Amazon API, Excel Add In for Amazon and Amazon Crawling scraping (AWS & MWS) which is to produce a csv at the end. I have developed many automation bots for forum, social, feed and article sites for automatic posting.Other than that I also have good experience in SQL Server, MySQL and SQL functions. I have some web experience too in Wordpress, PHP and HTML etc I am very friendly character. Very dynamic and flexible personality in reality

    PHP, XML, Visual Basic, and .NET

  • shikhamehta Profile Picture

    shikhamehta

    Pune,  India

    I am an experienced freelance professional with over 7 years of experience. My expertise include excel based reporting and VBA Macros. I have created some elegant dashboards for various clients and have been highly recommended by them for the quality I deliver.

    PHP, C Programming, Java, and XML

  • excelmacrosvba Profile Picture

    excelmacrosvba

    Leeds,  United Kingdom

    advanced excel projects involving vba programming, database integration

    Adobe Flash, Excel, SQL, and Web Scraping

  • caneadysl Profile Picture

    caneadysl

    houston,  United States

    ** Guarantee all the work complete on time with required quality * Expertise in developing of web application & solution over more than 12 years now. I am a generic programmer, experienced on creating applications with Codeigniter / Core PHP /Smarty with databases like, MySQL, MSSQL, DB2 & Oracle. Hands on experience in working with HTML,CSS,Jquery,JavaScript,Ajax Responsive Design, Bootstraps,Joomla . My main objective and focus is to ensure that the customer succeed with his/her projects. I carefully analyze the customer’s requirement and objectives and deliver the right solution in a short period of time. Will guarantee all the work complete on time end to end delivery ownership starting form system requirement gathering, design, coding and testing to implementation. I do have an innovative way of make the application more stable in fast changing client requirements. I will ensure my work timely delivery with required quality & minimum go live defects / known defects.

    PHP, Java, JSP, and Javascript

  • hrarcon Profile Picture

    hrarcon

    Pleasanton,USA,  India

    Android Bootstrap CMS CSS Forum Software Google Analytics GPS Graphic Design HTML HTML5 Java Javascript JSP Landing Pages Mobile Phone MySQL Photoshop Photoshop Design PHP Property Management Software Architecture Software Development System Admin Telecommunications Engineering Web Hosting Web Security Website Design Wireless Wordpress XML Yii

    PHP, Java, JSP, and Javascript

  • babysoftS Profile Picture

    babysoftS

    LUCKNOW,  India

    We have more than 6 years of experience in variety of web & mobile designing and development services. We are experienced in all aspects of web and mobile designing and development and have been involved in various small, medium and large projects from beginning to end. In the last 6 years, we have delivered various WebApplications, Mobile Apps, API Integration, API backend, Ecommerce solution, Social Media Integration, CMS Development and lot more using the latest web and mobile technologies. We work in PHP, JAVA, .NET platform to develop user friendly end product. We have extensive experience in WordPress, Drupal, Magento extensions, OpenCart and MVC framework like Codelgniter, CakePHP, Laravel etc. Our primary skills includeTelerik Kendo UI, jQuery mobile prototype, HTML5, CSS3, jQuery, bootstrap 3,JavaScript, PHP5, MySQL, AJAX, JSON, JAVA etc. Expertise in consuming RESTful api in jQuery AJAX, PHP. Expertise in web service development.

    PHP, ASP, C Programming, and Java

  • GyanomTech Profile Picture

    GyanomTech

    Pune,  United Kingdom

    Gyanom in Buddhism means Excellence and at GyanomTech Studios we strive to attain Excellence beyond Technology, to get you best solutions at optimum cost. We provide pragmatic, reasonable and optimal Software solutions to commonly faced as well as peculiar problems arising in the IT industry today. We are not here to change your world, but to make it a better place within the constraints and limitations that are faced by any IT solution user. With our rich experience, our focus and expertise lies not only in providing creative solutions using the latest technology stack (including but not limited to Java, Spring, Hibernate, Struts, PHP, 3rd party API integration) but also in maintaining, enhancing and improving current systems. Along with development, we have a very strong quality assurance team to make sure we deliver a high quality software to our clients. The QA team is specialized in automating testing using different tools and technologies like: Selenium, QTP, Coded UI, JUnit, TestNG

    PHP, Java, J2EE, and iPhone

  • Minimechanic123 Profile Picture

    Minimechanic123

    Vienna,  Australia

    Grad student looking for work on the side. Have worked in the financial industry in operations and software management. My main technologies are excel (VB and macros), python, java, big data and business intelligence tools. Looking forward to hearing from you.

    Java, and Python

  • ianjardiolin Profile Picture

    ianjardiolin

    Pasadena,  United States

    Over 15 years of SQL development, business intelligence and data architecture.

    PHP, Python, Joomla, and SQL