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.
This project was awarded to
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
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.
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
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.
Leeds, United Kingdom
advanced excel projects involving vba programming, database integration
houston, United States
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
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.
Pasadena, United States
Over 15 years of SQL development, business intelligence and data architecture.