One data file is from a SAP system and updated weekly. The second file/sheet is a base file that will not change but needs to be compared to current data. Finally, the third file/sheet is the schedule.
The project always begins with the second file to create a baseline budget. The schedule is then created based on previous delivery of material from the baseline. The third file updated weekly need to be ingested into the file to compare what was originally in the baseline for cost and schedule. This also has to identify additions/differences from baseline to the current weekly file. Some lines will have duplicate material but may be assigned to a separate account and/or the same. It the same, the quantity and cost need to be summed.
The material is summed into a kit or module and needs to be added together so that the sheet shows progress to complete.
The data needs to be available on a dashboard tab that reflects earned value data and graphs for each account or work package.
This is a material resource plan and earned value together into one file. The weekly file will be updated weekly in the file.