velu130486
Board Regular
- Joined
- Apr 4, 2014
- Messages
- 99
Dear Seniors,
I would like to seek your help for solving my problem. I have created a Manning Plan by Monthly basis, Now I want to split the values by Weekly Basis as follows. My assumption is every month is having 4 Weeks averagely, so based on the value in months, it should return the results in weekly columns as follows
For Ex
M1 M2 M3
0.5 0.75 1
If the value is 0.5 then it should return the following results
WK1 WK2 WK3 WK4
0 0 0.25 0.25
If the value is 0.75 then it should return the following results
WK1 WK2 WK3 WK4
0 0.25 0.25 0.25
If the value is 1 then it should return the following results
WK1 WK2 WK3 WK4
0.25 0.25 0.25 0.25
If the value is less than 0.25 it should return the following results
WK1 WK2 WK3 WK4
0 0 0 0.25
Please help me to sort out this issue. Please let me know for any further calculations
Thanks and Regards
R. Vadivelan
I would like to seek your help for solving my problem. I have created a Manning Plan by Monthly basis, Now I want to split the values by Weekly Basis as follows. My assumption is every month is having 4 Weeks averagely, so based on the value in months, it should return the results in weekly columns as follows
For Ex
M1 M2 M3
0.5 0.75 1
If the value is 0.5 then it should return the following results
WK1 WK2 WK3 WK4
0 0 0.25 0.25
If the value is 0.75 then it should return the following results
WK1 WK2 WK3 WK4
0 0.25 0.25 0.25
If the value is 1 then it should return the following results
WK1 WK2 WK3 WK4
0.25 0.25 0.25 0.25
If the value is less than 0.25 it should return the following results
WK1 WK2 WK3 WK4
0 0 0 0.25
Please help me to sort out this issue. Please let me know for any further calculations
Thanks and Regards
R. Vadivelan