Cancelado

VBA macro for Excel

VBA Macro on Excel

I will describe what the macro will do through the Excel [url removed, login to view] provided in the Zip file.

On the column C, we have TIME data. Here is how to ‘read’ those numbers. The first one (092508) means 9h25 and 8 seconds. Also, « 145639 » would mean 14h56 and 39 seconds.

The Macro will ‘create’ 12 new columns, from AZ to BK with the folling order and titles (to be written in the first cell of each column): CS cumul, CT cumul, SV5 cumul, SV4 cumul, SV3 cumul, SV2 cumul, SV1 cumul, BV1 cumul, BV2 cumul, BV3 cumul, BV4 cumul.

They are already created on the provided Excel file to show how the result should look like. The macro will work without needing the data I manually created in columns AZBK and will act like there is a blank there.

The macro will do the same kind of calculus for the twelve columns. I will thus explain for the first one.

In a given cell of the ‘CS CUMUL’ created column (in AZ), the macro will add up the number from the same line and in the column called ‘CS’ (in column E), plus the number from the cell above itself. You can observe such formulas in all red cells from column AZ to BK.

BUT, when the TIME cell indicates a new 5 minutes period, the formula on the created column won’t include the above cell number. Such formulas are in green.

Indeed, in the C (‘TIME’) column, the line 2 is a new period of 5 minutes, so is the line 3 (9h25 8s and 9h30 8s). But, from the line 3 (9h30 8s) to the line 46 (9h34 58s), we are within a same 5 minutes interval (9h25 0s --> 9h29 59s) so that the formulas in the AZBK columns must include adding up the above cell.

Note : some TIME DATA patterns may be like : 10h28 & 6s, 10h31 & 8s , 10h33 & 40s, 10h37 & 2s. Please, make sure that the macro detects 3 different 5 minutes intervals in such a case.

The macro does not need to include colors pattern as used in the provided Excel file

Habilidades: Microsoft, Visual Basic

Ver mais: we excel, vba work, vba with, time in az, microsoft number, microsoft excel formulas, excel macro how to, excel macro calculus, what is vba in excel, what is vba, what is macro in excel, vba time, vba for, new excel, microsoft vba, microsoft macro, microsoft excel VBA, in vba, how to microsoft excel, how to make patterns, work on excel, vba, vba excel, vba excel macro, vba e

Acerca do Empregador:
( 6 comentários ) luxembourg, Luxembourg

ID do Projeto: #594822

28 freelancers estão ofertando em média $313 para este trabalho

koolsidz

Please see PMB. Also zip file misssing.

$250 USD em 1 dia
(73 Comentários)
6.0
franSystems

Hi, I can't find your attachment, but based on your description of the task, my skillset is perfect for this task. Please see message board. francis,adVBAncedCoder UNLEASH your MS OFFICE

$250 USD in 7 dias
(46 Comentários)
4.2
ahmedsobherfan

hi,i can do this task just send me the excel file Regards

$250 USD in 0 dias
(21 Comentários)
4.2
BrindabanB

Hi, can finish this job in a week time. Am too good with Excel VBA, or VB.NET with Excel. Please feel free to contact me for any clarification or references. Looking forward to hear from you soon. Regards, Mais

$350 USD in 5 dias
(6 Comentários)
4.2
freddyho

Hello, I am excellent in VBA macro. Please let me do the job. Thank you.

$250 USD in 2 dias
(5 Comentários)
3.3
nishajoseph

Hello, I am interested in working on your project. I am well versed in eXcel VBA and have recently completed an excel VBA script for automating the process of load sorting for a aerostructures [url removed, login to view] is m Mais

$250 USD in 7 dias
(1 Comentário)
0.0
ildarfn

It looks like that I can handle this task in two days weekend. I have 2 years experience of implementing financial calculus tasks in Excel VBA. So your problem will be fairly easy for me.

$250 USD in 2 dias
(0 Comentários)
0.0
dotnetwap

Hi, Greetings!! We are a team of 5 people working together as a freelancer. We usually work for around 5 hours a day in week days. Our team includes 1) Business developer (EXP: 2 years) 2) Business analyst: (EXP: 1 yea Mais

$500 USD in 13 dias
(0 Comentários)
0.0
usmi786

Its an easy project. I can develop this project in $150 coz it would be my first project. I've mentioned 2 days for refinements. Initial copy will be sent to you in just 1 day. If i'll have .ZIP file, i'll send you par Mais

$250 USD in 2 dias
(0 Comentários)
0.0
miladinoski

I am experienced in Excel and VBA for 10 years. This task will be done for you in the best possible way.

$250 USD in 2 dias
(0 Comentários)
0.0
NvdLancer

I am ready to start working on it. Please provide the attached XLS file.

$250 USD in 5 dias
(0 Comentários)
0.0
moibelgal

Please refer to PM. Looking forward to working with you. Thanks

$250 USD in 2 dias
(0 Comentários)
0.0
jtbanks

I have 4 years experience with building Excel VBA Sheet for places like Hussmann, i use to build and Excel sheet like to one your asking for asking for and have great knowledge of VBA and Macros. I have created several Mais

$500 USD in 5 dias
(0 Comentários)
0.0
saikrishna77

Hi, I will do this work. If u want plz let me know

$250 USD in 5 dias
(0 Comentários)
0.0
snonchev

VB Macro expert waiting for your task here...

$250 USD in 2 dias
(0 Comentários)
0.0
Zeco

Ready to do it. Read PM Pls

$750 USD in 0 dias
(0 Comentários)
0.0
jayasundarak

I have worked with Excel macros a lot, specially even real time applications containing up to 100,000 data rows. I think i can work this out quite well. Cheers....

$250 USD in 3 dias
(0 Comentários)
0.0
ilyaskazi

Hello, are you looking for an Excel VBA Expert? If yes, see your PM..

$500 USD in 3 dias
(1 Comentário)
0.0
brandenrguess

Please check your PMB!

$450 USD in 5 dias
(0 Comentários)
0.0
DebbieLu1969jan

I can do it.

$300 USD in 5 dias
(0 Comentários)
0.0