Find Jobs
Hire Freelancers

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

$30-250 USD

Complété
Publié il y a environ 4 ans

$30-250 USD

Payé lors de la livraison
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...
N° de projet : 23400702

Concernant le projet

15 propositions
Projet à distance
Actif à il y a 4 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
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 en 3 jours
5,0 (23 commentaires)
5,3
5,3
15 freelances proposent en moyenne $119 USD pour ce travail
Avatar de l'utilisateur
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 en 1 jour
5,0 (168 commentaires)
6,8
6,8
Avatar de l'utilisateur
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 en 1 jour
4,8 (106 commentaires)
6,1
6,1
Avatar de l'utilisateur
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 en 1 jour
4,7 (77 commentaires)
5,4
5,4
Avatar de l'utilisateur
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 en 1 jour
5,0 (46 commentaires)
4,7
4,7
Avatar de l'utilisateur
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 en 3 jours
4,9 (7 commentaires)
2,6
2,6
Avatar de l'utilisateur
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 en 7 jours
0,0 (0 commentaires)
1,6
1,6
Avatar de l'utilisateur
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 en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 2 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 2 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 3 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
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 en 6 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de TAIWAN
Taichung, Taiwan
5,0
11
Méthode de paiement vérifiée
Membre depuis avr. 3, 2015

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.