Damodar
New Member
Hi Team,
Please help me generating Rough Plan as per below requirement. First, kindly look at the attachment. I'm 1/4th of way done, but stuck up with creating the logic.
In the Rough Plan sheet, D20 is Capacity (That means total members can do a number of work) And B2:C16 are the module wise data and count of Test cases. The requirement is when I click on a button named 'Create Plan' in this page, that should create a new sheet and update the sheet with the following (Sample sheet name: "Plan")
1. It should copy all the modules and TC count to the new sheet (Sub copyPasteModueslandCount)
2. Day1 to Day N should be added (Sub addDays)
3. For Day1, Module 1 Count should be added as below. (doPlanning)
If ModuleCount(C3-->100)<Capacity(105) then
update the module count value in Day 1 against the Module name (D3)
Update the remaining value [ModuleCount(C3)-Capacity(105):100-105] with the value for next module in same day against the second module (100-105=5)
else If ModuleCount(C3)=>Capacity(105) then
update the capacity in same day and add the capacity till it comes <modcount.
Its bit confusing, if you see the sheet "Plan" its very easy to understand.
Please let me know if you need additional details.
Please help me generating Rough Plan as per below requirement. First, kindly look at the attachment. I'm 1/4th of way done, but stuck up with creating the logic.
In the Rough Plan sheet, D20 is Capacity (That means total members can do a number of work) And B2:C16 are the module wise data and count of Test cases. The requirement is when I click on a button named 'Create Plan' in this page, that should create a new sheet and update the sheet with the following (Sample sheet name: "Plan")
1. It should copy all the modules and TC count to the new sheet (Sub copyPasteModueslandCount)
2. Day1 to Day N should be added (Sub addDays)
3. For Day1, Module 1 Count should be added as below. (doPlanning)
If ModuleCount(C3-->100)<Capacity(105) then
update the module count value in Day 1 against the Module name (D3)
Update the remaining value [ModuleCount(C3)-Capacity(105):100-105] with the value for next module in same day against the second module (100-105=5)
else If ModuleCount(C3)=>Capacity(105) then
update the capacity in same day and add the capacity till it comes <modcount.
Its bit confusing, if you see the sheet "Plan" its very easy to understand.
Please let me know if you need additional details.