Monthly WBS planning in Excel
We have received the requirement from client related to WBS monthly plan in Excel.
we have below 2 cases in the requirement ;
- they want to use the excel file to upload the WBS plan values for complete year (from period-1 to period-12 ) and also
- if its required , they want to use the same excel file to upload the WBS plan values for specific periods only ( for periods -2/5/7 )
For case 1, we able to succeed to upload the WBS plan values for complete year without any issues but
for case 2, when we try to upload the plan values for specific period, they upload is successful for this periods but for other old periods values are removed (means its updated with zero plan values ).
so now i need your help to achieve the WBS monthly planning in excel without over right or remove the plan values for other periods.
example for case -2
first upload for complete year (2013)
from period -1 to period -12
each period values in excel file - 100 USD
second time upload for period -8
8th period values in excel is - 200 USD
for other period values in excel is - blank or zero ( means we dont want to change the initial plan values )
after 2nd plan values upload , the initial WBS plans are removed for other periods except 8th period and its showing the WBS plan values only for 8th period with 200 USD
can you please check and help me how to achieve to upload monthly WBS plan values without remove or over right the plan values for other periods.