Calculating and setting repeatitive values on Excel Spread Sheet

[lancesunny]

Hi Guys,

I need help regarding calculating and setting values of hours for the dates as shown in figure. in the Excel spread sheet. For example

E F G H I J K L M
Round Est. Time StartDate Weeks 8/18 8/25 9/1 9/8 9/15 9/22 9/29 10/6 10/13
1st 76 8/18/2014 8 9.55 9/25 9.55 9.55 9.55 9.55 9.55 9.55 9.55
2nd 33.2 10/13/2014 2 16.6 16.6

Here we calculate and set values for dates 8/18 8/25 9/1 9/8 9/15 9/22 9/29 10/6 10/13 = Est Time / Weeks = 76/8 = 9.55 so set the hours = 9.55 for next following 8 dates based on Given no. of weeks as counter.

Can you guys please help me in order to solve this?

Thanks for Help in advance.

Thanks,
-San

 

[excelliot]

cant see image, can attach sample file..

Cheers!!

 

[lancesunny]

I need help regarding calculating and setting values of hours for the dates as shown in figure. in the Excel spread sheet. For example

[TABLE="width: 1112"]
<tbody>[TR]
[TD]Extract[/TD]
[TD][/TD]
[TD]Est. Time[/TD]
[TD]Start Date[/TD]
[TD]Weeks[/TD]
[TD="align: right"]8/18/2014[/TD]
[TD="align: right"]8/25/2014[/TD]
[TD="align: right"]9/1/2014[/TD]
[TD="align: right"]9/8/2014[/TD]
[TD="align: right"]9/15/2014[/TD]
[TD="align: right"]9/22/2014[/TD]
[TD="align: right"]9/29/2014[/TD]
[TD="align: right"]10/6/2014[/TD]
[TD="align: right"]10/13/2014[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mapping[/TD]
[TD][/TD]
[TD="align: right"]8/18/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1st Round[/TD]
[TD="align: right"]76[/TD]
[TD="align: right"]10/13/2014[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"]9.55[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2nd Round[/TD]
[TD="align: right"]33.2[/TD]
[TD="align: right"]10/27/2014[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]16.6[/TD]
[TD="align: right"]16.6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Here we calculate and set values for dates 8/18 8/25 9/1 9/8 9/15 9/22 9/29 10/6 10/13 = Est Time / Weeks = 76/8 = 9.55 so set the hours = 9.55 for next following 8 dates till 10/06/2014 based on Given no. of weeks = 8 for 1st Round as counter. Similarly calculate hrs = 16.6 for 2nd Round and by using counter = 2 for 2nd Round display 16.6 for 8/18/2014 & 8/25/2014
Can you guys please help me in order to solve this?
Thanks for Help in advance.
Thanks,
-San

 

[excelliot]

Check this file, you need to punch in cells in yellow, rest will be taken care by formula.

Download

Cheers!!

 

[lancesunny]

Thank you so much excelliot. It worked. You are the man......

 

[excelliot]

Thanks for appreciations.

Cheers!!