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

Extract		Est. Time	Start Date	Weeks	8/18/2014	8/25/2014	9/1/2014	9/8/2014	9/15/2014	9/22/2014	9/29/2014	10/6/2014	10/13/2014
	Mapping		8/18/2014
	1st Round	76	10/13/2014	8	9.55	9.55	9.55	9.55	9.55	9.55	9.55	9.55
	2nd Round	33.2	10/27/2014	2	16.6	16.6

<tbody>
</tbody>

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