Breaking Demand into weekly time buckets

[bluetaurean]

Hello,

Could someone help in providing a VBA solution to break down demand number by weeks.
Input range
Product demand is listed in monthly buckets
per day demand is to be calculated excluding all Fridays. So for jan no of days is 26.

Output range needed is
demand broken down into weekly buckets
weeks starts on Saturday. Fridays always off
for cross over weeks i.e weeks with 4 days in one calendar month and 3 in another, calculation will be 4 * demand per day in first month + 2 * demand per day in second month assuming the Friday in in the second month.

 

[Hui]

Have a look at your rearranged file:

Refer: http://chandoo.org/wp/2010/11/18/scheduling-variable-sources/

 

[bluetaurean]

Hi Hui,

the number of days in the respective months dont appear correctly. for feb the no. of day must appear in row 15 in this example and so on. do you know of any similar vba solutions.
thanks

 

[NARAYANK991]

Hi ,

Can you check your file here ?

Narayan