Find Jobs
Hire Freelancers

Create TimeSheet Report From Excel CSV File - repost

$30-100 USD

Completed
Posted about 10 years ago

$30-100 USD

Paid on delivery
Create timesheet report that uses data from csv file and create reports for each name in the report. Source will include 15-20 columns of data, not all columns will be used. Source file will be a csv file imported into Excel and then a customized version of the timesheet is created with all the clock ins and outs on the report. Multpage with multiple names. See attached sample file with fields needed on the report. The hours will have to be calculated to show overtime, i.e. hours over 8 and DT hours of 12, but these should be variables that can be changed. Attached find a sample report. The template should be easy to change in Excel so that when the next batch if data is imported it automatically is imported and formatted.
Project ID: 5325771

About the project

28 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I already started working, and I do have successful import operation from csv to excel. Will work in any excel (2003+). Here is a screenshot of some of the program futures. [login to view URL] (copy and paste to browser if there is no automatic link) If the prize/time is acceptable, there will be some small talks about the final look (I can do it exactly like the sample, but there are paper saving options to discus) . My average grade of 5.0 should be a good recommendation for my skills. All the best. Magnus.
$50 USD in 6 days
5.0 (29 reviews)
4.6
4.6
28 freelancers are bidding on average $77 USD for this job
User Avatar
Hi victorcab, I have studied both the files and can take on the job. - Does the Input file (csv) require any sorting before processing ? - I noticed the Input / Output files cover more than one day for each person. I assume its person specific. - Shall have two text boxes to specify 'Hours Over' and 'DT Hours' values. Shall keep the default values as 8 and 12. - Shall provide a user friendly interface for selecting input csv file. Let me know. Regards, Arul
$100 USD in 3 days
5.0 (220 reviews)
7.4
7.4
User Avatar
Hi, I will be happy to write the macro that will import the csv data and generate the time sheets for individual names, and apply formulas to calculate the regular hours and overtime Looking forward to your reply
$100 USD in 1 day
4.8 (260 reviews)
7.7
7.7
User Avatar
Hi Victor. Being highly proficient in Excel, I can chalk out a reporting Time sheet for you . I recently did very similar work for another client and she is pretty happy with it. Lets discuss and get started on it. Regards. Usman.
$90 USD in 3 days
5.0 (91 reviews)
7.1
7.1
User Avatar
hey Victor, we can do this, please reply, thanks :-)
$83 USD in 4 days
4.8 (207 reviews)
6.2
6.2
User Avatar
Good day, I already done same project, Please check: https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experiences: https://www.freelancer.com/projects/Excel/Drawing-EXCEL.html https://www.freelancer.com/projects/4848189.html https://www.freelancer.com/projects/Visual-Basic-Excel/Excel-user-form.html https://www.freelancer.com/projects/Excel/Excel-Spreadsheet-Timecard-for-work.html https://www.freelancer.com/projects/Data-Entry-Excel/Excel-Line-Restructured.html Regards.
$83 USD in 3 days
5.0 (69 reviews)
6.0
6.0
User Avatar
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 response. Thanks.
$83 USD in 7 days
4.8 (120 reviews)
6.4
6.4
User Avatar
Thank You...............................................................................................................................
$100 USD in 3 days
4.9 (22 reviews)
5.3
5.3
User Avatar
Hi I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% accuracy in minimum time . Pay me only if you are 100% satisfied with my work, after project delivery. I am interested to work for your project. Please give me a chance. I have handled many projects involving data manipulation handling, business solutions, Excel automated dashboards, Report Generation and Excel Applications. If you offer me your project, I can start immediately and deliver the job within 3 days after testing (QA) . I guarantee 100% accuracy for my deliverable. I do hope you'll give me the honorable chance to work with you and help me with making my mark on freelancer.com. I will take your project as the priority job and will complete your work in minimum time with 100% commitment. Thanks Fibin
$80 USD in 3 days
4.9 (53 reviews)
5.5
5.5
User Avatar
I have been developing applications in both Access and Excel for 20 years with extensive use of VBA. I have developed several applications for Freelance clients, please see Feedback. I am UK based, a native English speaker, available on Skype and currently on UTC. My first thought would be to have an Excel file with one sheet linked to a named csv file and another sheet feeding off it to provide the report. A third sheet could be for variables to be entered. Alternatively the whole thing coul;d be programmed in vba I am available now and would plan to finish in 2 to 3 working days. Hope to hear from you Regards David
$90 USD in 3 days
4.9 (37 reviews)
5.3
5.3
User Avatar
Hi, Have done a lot of template type work before including project timelines and hours for activities etc. Can get his done fast for you. PEDIGREE / PREVIOUS WORK My pedigree includes these (my own sites and my own developed software): My Excel and Access development site (I also TEACH development): vbafasttrack.com. I recently completed a project to build a Bitcoin trading application, a binomial and trinomial employee stock options model for a mid-tier US investment bank and have an Insto finance and trading background myself. I am also the developer of the following software freelancesniper. Be advised I have my own company doing this stuff and have an institutional IT background. Cheers. SteveP.
$100 USD in 3 days
4.9 (6 reviews)
4.9
4.9
User Avatar
Hi, We can do the job as per Requirement Recently we Completed a Grid Project Please have a Look Complicated user defined grid Activex Control developed in visual basic 6 Project ID: 4393323 Project Name:-"VB6 Time Grid " .Employer Name ID:-soretebr We can do your Project in short time ,We are Expert in VB6.0/VB.Net/Access/SQL/Mysql/Excel these type of Program of Transferring data from one form of Data base to another form of Data Base Via Front End VB6.0./VB.Net We are expert in VB with 10 years of experience and 7 years of experience in Vb.net and MS-Excel, MS-Access, SQL. Also we are having experience in developing products for various segments (eg. pharma, apparel, supermarket, etc.). So we hope we can do your job to your utmost satisfaction. We have delivered Number of VB Projects Recently in Freelancer. Visit our PORTFOLIO at http://www.freelancer.in/u/srdas2012.html Thank You Das
$69 USD in 3 days
4.8 (23 reviews)
4.8
4.8
User Avatar
Hello, Having more than 12 years of experience in development. Recently I have completed similar project on another site.I would like to work on project.I am having good experience in developing reports. If you require I can give you better solution by using crystal report or Microsoft report I will also provide you the facility to generate single employee report or all employee. I will try to add as much as features I can add. Please see my portfolio for work reference. Looking forward to hearing from you Thanks Chetnaa Desai
$55 USD in 4 days
4.8 (11 reviews)
4.8
4.8
User Avatar
Hello I am working with MS-Excel and VBA for the past 12 years and have completed successfully projects through Freelancer.com. I am ready to do your work and have gone through your project details and the files that you have asked for reference. Give me the job, get it done, satisfy yourself and then make payment. I wont seek any payment from my clients until the job is fully done as per their satisfaction. Customer satisfaction is much more important and our top most priority. No satisfaction no payment. Hope to hear positively from u. Regards John
$50 USD in 3 days
4.9 (18 reviews)
4.5
4.5
User Avatar
Hi, I have studied your project requirements. It is simply a database project. I assure you to provide a robust solution. Using of excel will create problems with the passage of time as your data will grow. This is happened always in case of excel based applications Instead I shall develop you a stand alone desktop application using Visual Basic at front end and Ms Access at back end This is considered best combination for database projects. Here are benefits of this combination --You do not need to install Ms Access on your pc -You do not need to have any additional component on your pc to run this application -You only need to install the proposed application with installation wizard (I shall provide it) and start your work. You will be able to 1-Import of csv data in to access database 1- Add / modify / delete data 2- Auto calculation 3-User friendly input forms 4- Dynamic professional looking reports I shall deliver you -Installable exe package -A robust, relational, and normalized Ms Access database. -Application installation wizard package (which will help you to install the application on your pc). Price: $100 I have more than nine years experience in desktop application development using Vb at front end and Ms Access at back end and assure you quality work. Looking forward to hear from you Regards, Asghar
$111 USD in 5 days
4.2 (6 reviews)
4.8
4.8
User Avatar
Hi, I am a UK based Excel and VBA design specialist with over 10 years of experience in delivering projects such as this. I can provide you with a fully functioning product that meets all of the requirements outlined in the project description. I will design the Excel file using Windows Forms, which provide an excellent interface. The forms will be tailored specifically towards your business in terms of logos, colour themes etc. I have provided similar solutions for many other customers, including TV commercial agencies, mobile phone companies, electronics retailers, marketing firms and economic sustainability planners to name but a few. The final product will be very slick and highly professional, and with all my products I also include full documentation on how it works and fits together - this way, should you need to make any additional changes in future, this can be easily done. I also provide 100% full ongoing support, should you have any questions at a later date. I am more than happy to provide samples of my work, so you can see the level of quality I can provide for you and your business. If you have any questions, or would like any further details, please don't hesitate to let me know. I look forward to hearing from you. Kind regards, Joe
$55 USD in 3 days
5.0 (8 reviews)
3.3
3.3
User Avatar
Hello, Good day to you. I am very excited to do this project. Here is my proposal. Let me create this in Visual Basic. This will give you a professional looking software. The application will have an input as the .csv file and will output the reports. You can choose which person/employee base on the .csv to produce the report or just produce report for all. Finally the application will allow you to export to Excel or print right away. Why you should choose me? 1.) I am proficient in VB and I have finished an inventory system here in freelancer. 2.) I give timely updates on the progress of the project. 3.) I create documentation on the things done so if ever changes are needed, you can either contact me again or ask other programmers. I am currently in the US studying but is from the Philippines. Looking forward to work with you. Thanks! Derrick
$100 USD in 3 days
5.0 (2 reviews)
1.4
1.4
User Avatar
This seems like a very straightforward job. The way I'd probably do it would be to have a form come up on opening the Excel file, where you can select for example whether OT and DT is from 8 / 12 hours or something else, before import. You'd select the csv file, and a timesheet would be created with a name costumized from the csv. I would of course need more specifics before doing the job. Sincerely Ove
$50 USD in 1 day
5.0 (1 review)
1.3
1.3
User Avatar
10USD!! Finish within today!!! However, I cant find the Code, Start Break Time , End break Time in the csv file.
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This seems easy enough. If I understood correctly you want an application that can grab the csv file format the file, manipulate data in it and give you an output. if this is the case I will provide you with such within a weeks time with daily feedback as I progress during the development of you solution. I will accomplish this task using Visual Basic and provide you with the executable application and commented/documented Source code. Please consider me for this project, I look forward to doing business with.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Some additional details will need be clarified. For example, the calculated "hours" are already given in the csv file; do you trust them or do you want them ignored and recalculated from the start/end times? Also, do you need each cell with the total hours to have the "SUM()" formula or just the total values (no formula) would do (or be better). If you need any additional (or different)" fancy" formatting to make the output yet more impressive (like colors or fonts, etc.)--that's no problem at all, and at no additional charge either. In any case, I can turn this around within a few hours.
$72 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Pasadena, United States
4.8
254
Payment method verified
Member since Dec 2, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.