I am in the process of marking up progress on my "current programme", I have a "baseline" sitting as a seperate file. I merge the information using an excel proforma my company has. Each month I export the "baseline" figures and the "current programme" figures to the excel file to generate baseline EV curve, actual EV curve and forecast EV for each month.
Problem is, almost every month I have the difficulty on the "current programme", when I mark up progress, the figures to the left of the progress line do not align match up(No Stacking Option). The planned line on the graph of Cost vs Progress S Curve and the actual line on the graph figures do not match up. I need to move cost bars around etc.. How can I get these cost bars to match up without going through a mammoth task. Clearly I am screwing things up as this should be a straight forward task, but it keeps causing me problems.
The skew in these figures is making it difficult to give the correct forecast figure to the right of the progress line.
The main comparison is done on an external spreadsheet when I compare the figures from the baseline to the figures from my current programme but my forcasts are really difficult to produce without all the pain of moving cost bars about, finding some unprogressed cost bars even though the tasks have been progressed etc.
Any good rules or methods to get these to line up?
Thanks