Find Jobs
Hire Freelancers

Write a VB script for sorting data in a log file in excel format

$30-250 USD

Completed
Posted over 4 years ago

$30-250 USD

Paid on delivery
We need someone to write a VB script to scan a few 1000 of lines in an excel file that contains the monthly working hours of some staff members. The purpose is to have the data sorted by name, then the working hours calculated by day, and overtime work and cost added. See the provided xls file, raw data is in the first sheet, the expected result following the VB script run, is shown in the 2nd sheet. If you bid on this project, please mention in your bid message how many line are on the second page of the .xls file, just to make sure you have opened the file...
Project ID: 23400702

About the project

15 proposals
Remote project
Active 4 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
4 lines Hello, I will write VB script for you for sorting data in a log file in excel format Kindly send me a message to discuss. Thanks, Everest Technology
$99 USD in 3 days
5.0 (23 reviews)
5.3
5.3
15 freelancers are bidding on average $119 USD for this job
User Avatar
First of all, you have 4 DATA rows on your second sheet. I can provide you a simple VBA script that will process your raw sheet and generate output you want. I can complete it in less than a day for just $100. Thanks. Roman
$100 USD in 1 day
5.0 (168 reviews)
6.8
6.8
User Avatar
Hi, Greetings. I need a day to write the VB Script. Now question is, do you want a custom field to put the cost(overtime) as that could change or not? Plz let me know if you are interested. Thank you.
$80 USD in 1 day
4.8 (106 reviews)
6.1
6.1
User Avatar
Hi... Good Day! There are 757 lines in the "12. Error record of Dec 2019" sheet and 7 rows with data in the "result" sheet. I 've done something like this before when I am tracking the hours or our employees in Accenture Philippines. I created them a tool that track their hours and generate a report automatically. Please consider my bid. I am a Project Management officer for 8 years in Accenture and Project Manager now in Appen Philippines. I do financial reports and budget forecasting for our Clients. I have all the ability to help you. I've done a lot of Reports and Templates using MS Excel. I can use my expertise in VBA Macro do it quickly and accurately. Please message me anytime to discuss more about this project. I am willing to help you out and show you my expertise. Thank you!
$30 USD in 1 day
4.7 (77 reviews)
5.4
5.4
User Avatar
There are 4 lines in second page and 757 lines in "12. Error record of Dec 2019" sheet, and I'm sure I can do that. You want it in VBA function or just formula, it's up to you. Chat me, you'll get what you want in less than 2 hours. I'm waiting for your reply. Thanks
$40 USD in 1 day
5.0 (46 reviews)
4.7
4.7
User Avatar
Hi, 7 lines have written data. Hi, I read your description carefully and would like to work on your project as i have good experience in this field. I will create vb script to sort the file and it will gives you desire output. Please do let me know if we can discuss on this. Thanks & Regards, Mayank
$100 USD in 3 days
4.9 (7 reviews)
2.6
2.6
User Avatar
Hi, I am VBA Expert. I have rich experience in that fields, so I can deliver you the satisfactory results. I would be happy to discuss your project needs and how I can help you meet them. I look forward to talking to you!
$140 USD in 7 days
0.0 (0 reviews)
1.6
1.6
User Avatar
hello bro , i am really interested for your work.. i read your bid perfectly .. i want this work .. i am waiting for your massage for started this job..
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i would like to work for you on this project in low budget and in good time. I have enough experience of this field. We can start work as soon as possible.I can do it by VB and C#
$155 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, There are 756 data rows except the header row. I am happy to work. Do you use Windows/Mac? I have more than 15 years in using Excel for advanced applications. Thank you, Ravi
$80 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, i have a question: There are multiple checks for each name, i should take the first and the last of the day right? on rows 55 and 56 there are in and out with 2 minutes of difference... Oh, there are 4 rows of James in the second row
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Boa noite! Tudo bem? Gostaria se saber se você quer apenas que mostre esses dados já solicitados sobre a hora dos funcionários ou algo a mais, caso seja, só, eu trabalho com um prazo máximo de 6 dias, podendo ser entregue antes. Qualquer dúvida, por gentileza, me avise.
$200 USD in 6 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TAIWAN
Taichung, Taiwan
5.0
11
Payment method verified
Member since Apr 3, 2015

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.