Lengkap

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

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...

Kemahiran: Visual Basic, Excel

Lihat lagi: excel macro sort data multiple columns, vbscript to sort data in excel, excel vba sort worksheet, excel vba sort column ascending, vba sort, vba sort column a to z, excel vba log to text file, how to create a sort macro in excel, perl script find data text file, script check outofmemory log file, data text file excel, exporting data dat file excel 2007, extracting data mdb file excel file, parse data text file excel, python script read data text file, vbs log file excel, extract data pdf file excel, copy data log file php, bash script past hour log file, software engineer resume parser extract data log file

Tentang Majikan:
( 5 ulasan ) Taichung, Taiwan

ID Projek: #23400702

Dianugerahkan kepada:

FreelancerTechX

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 dalam 3 hari
(10 Ulasan)
4.6

22 pekerja bebas membida secara purata $129 untuk pekerjaan ini

ineedWorkJob

Greetings sir, I have read your project details and i will develop the script to sort your raw data based on user/worker name, working hours and overtime he/she worked. Sir, i can deliver this project sooner than Lagi

$100 USD dalam sehari
(116 Ulasan)
6.4
gangabass

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 Lagi

$100 USD dalam sehari
(124 Ulasan)
6.3
bdoutsource

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 dalam sehari
(104 Ulasan)
6.1
paulodayto08

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 Accent Lagi

$30 USD dalam sehari
(36 Ulasan)
4.5
nurnga1218

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 Lagi

$40 USD dalam sehari
(41 Ulasan)
4.5
jmayankjain

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 de Lagi

$100 USD dalam 3 hari
(1 Ulasan)
0.0
jonathanoliveir2

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 entr Lagi

$200 USD dalam 6 hari
(0 Ulasan)
0.0
manuelleal

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 Lagi

$35 USD dalam 3 hari
(0 Ulasan)
0.0
lighthouselk

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 dalam 2 hari
(0 Ulasan)
0.0
vw7613124vw

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 dalam 2 hari
(0 Ulasan)
0.0
JInri012

Hi. I have just checked your excel files. On the second page of the .xls file,you have used 4-8,10-11. I can finish this task within 1day. Please contact me. Best regards!

$100 USD dalam sehari
(0 Ulasan)
0.0
Geokifa

Hello. I have full experience in this field. So I assure you I can do it with high-quality. I will complete your project perfectly, provide good service for you, you will get satisfied. Let's share our idea. Looking fo Lagi

$100 USD dalam 7 hari
(0 Ulasan)
0.0
$155 USD dalam 3 hari
(0 Ulasan)
0.0
MobiAlley

WELCOME TO DESKTOP APP Service!. 100% Completed Job & Preferred Developer! Hi, I CAN COMPLETE YOUR PROJECT Perfectly!. I have enough experiences on Python, C#/.NET, QT/C++ for over 15 years. I can design the architectu Lagi

$250 USD dalam 7 hari
(0 Ulasan)
0.0
MWaqar5246

Hi there, hope you are well. I have years of experience in visual basic, have read your requirements. Can surely help you with a sorting script that would work exactly as required. Let me know if you need quality help? Lagi

$250 USD dalam 7 hari
(0 Ulasan)
0.0
Salikskhan

Hello Dear...! Alert: I will give you 35% discount on my bid rate also give on my All Services. So grabs this special offer is limited. Let’s get to the point. I came to know that you are Looking for a excel expert Lagi

$30 USD dalam sehari
(0 Ulasan)
0.0
SergeiMixakov

Hello. How about today? High-quality & Fast-delivery is promised! As a highly skilled Full-Stack developer and I can help you perfectly. I am very confident with my skills and I'd like to help your business by doing my Lagi

$300 USD dalam 7 hari
(0 Ulasan)
0.0
logo1shop

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 dalam 3 hari
(0 Ulasan)
0.0
Kumagairkia

Hello, I have top skills in EXCEL VBA & Data Entry. While reading your job description, I understood your main goal. As I am strong at this kind of project, I am pretty sure that I can provide you high-quality work wit Lagi

$140 USD dalam 7 hari
(0 Ulasan)
0.0
SergeyEybog

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 Lagi

$140 USD dalam 7 hari
(0 Ulasan)
0.0