Averaging % Complete Schedules that have different timelines

TG@sapir.com

New member
Joined
Jun 11, 2019
Messages
1
Reaction score
0
Points
0
Location
New York
Excel Version(s)
Excel for MSO 16 32-bit
Hello All,

I'm trying to average different data that shows the % complete of a renovation project with different timelines. See one of the data sets attached.

I want to use this data set with other % complete data sets to get an average % complete for the projects and each subcategory. I have been trying to normalize this data, but am having a lot of trouble. Is there anyone here that knows how to normalize timeline schedule data or create a meaningful way to average this data? Thank you and your help would be greatly appreciated.


-Best, T
 

Attachments

  • % complete data snip.PNG
    % complete data snip.PNG
    88.2 KB · Views: 13
Hi and welcome
please post a sample sheet, no pics please ( click Go advanced - Manage attachments) with some data and expected results
 
Back
Top