{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Help","Performance","Dashboard"],"not_rendered":{"charts":3,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":27,"n_cols":4,"rows_kept":27}
[]
[]
[{"$nulls":3},"The sheets are protected to prevent accidentally overwriting the formulas. You can unprotect them from the menus."]
[]
[null,null,"Row 1","The week number"]
[]
[null,null,"Actual Duration","This is the actual amount of time passed from the beginning of the project. Unit of time is week."]
[null,null,"Planned Total Budget","The total budget considered for the project. The same number is entered for all columns in the beginning of the project. If you change the total budget, the new number will replace the old one from the decision time, to the end of the project."]
[null,null,"Planned Total Duration","The total duration considered for the project, similar to the Planned Total Budget."]
[null,null,"Plan Limit: Cost","Used for managing deviations."]
[null,null,"Plan Limit: Time","Used for managing deviations."]
[null,null,"Delegation Limit: Cost","Used for escalating RIC decisions. This information is not used in the calculations here."]
[null,null,"Delegation Limit: Time","Used for escalating RIC decisions. This information is not used in the calculations here."]
[null,null,"Planned Cost","The amount of PV (Planned Value) in EVM, which works as the planned progress. These values are extracted from the Scheduling Model."]
[null,null,"Cost Tolerance","The sum of the Planned Total Budget and Cost Plan Limit"]
[null,null,"Time Tolerance","The sum of the Planned Total Duration and Duration Plan Limit"]
[null,null,"Actual Cost","The cumulative actual cost of the project until the week. "]
[null,null,"Earned Value","The cumulative Earned Value of the project until the week. This value is extracted from the Schedule Model, after entering the actual data."]
[{"$nulls":3},"The Actual Cost and Earned Value are the two fields you enter every week. The rest are your baselines, and do not change so frequently. "]
[]
[null,null,"Earned Schedule","The amount of time needed to produce the actual progress, based on the planned values. E.g. if your ES is 15 weeks in the 17th week, it means that you've spent 17 weeks to do the job you were supposed to do in 15 weeks; in other words, you're behind schedule."]
[null,null,"Completion","It's an alternative for more common types of percent complete, which are usually EV/PV. This field is Earned_Schedule/Actual_Duration, which in most case, gives a better completion ratio when there are many dependencies in the project."]
[null,null,"Forecast At-Completion Cost","Forecast for the total cost of the project."]
[null,null,"Forecast Total Duration","Forecast for the total time of the project."]
[]
[{"$nulls":3},"The main outputs for the measurement are the two forecasts. They are compared with the targets, and if there are deviations, we should try to recover. "]
[{"$nulls":3},"When both deviations are below the Plan Limits, the Project Manager decides how to fix them. Otherwise, the Sponsor decides, and the plans would be revised using the Cycle Planning activities. "]

{"sheet":"Performance","index":1,"n_rows":19,"n_cols":101,"rows_kept":19}
["Data","W00","W01","W02","W03","W04","W05","W06","W07","W08","W09","W10","W11","W12","W13","W14","W15","W16","W17","W18","W19","W20","W21","W22","W23","W24","W25","W26","W27","W28","W29","W30","W31","W32","W33","W34","W35","W36","W37","W38","W39","W40","W41","W42","W43","W44","W45","W46","W47","W48","W49","W50","W51","W52","W53","W54","W55","W56","W57","W58","W59","W60","W61","W62","W63","W64","W65","W66","W67","W68","W69","W70","W71","W72","W73","W74","W75","W76","W77","W78","W79","W80","W81","W82","W83","W84","W85","W86","W87","W88","W89","W90","W91","W92","W93","W94","W95","W96","W97","W98","W99"]
["Actual Duration",0]
["Planned Total Budget"]
["Planned Total Duration"]
["Plan Limit: Cost"]
["Plan Limit: Time"]
["Delegation Limit: Cost"]
["Delegation Limit: Time"]
["Planned Cost"]
["Cost Tolerance",{"$f":"IF(B3=\"\",\"\",B3+B5)","v":""},{"$nulls":26},{"$f":"IF(AC3=\"\",\"\",AC3+AC5)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BO3=\"\",\"\",BO3+BO5)","v":""},{"$f":"IF(BP3=\"\",\"\",BP3+BP5)","v":""},{"$f":"IF(BQ3=\"\",\"\",BQ3+BQ5)","v":""},{"$f":"IF(BR3=\"\",\"\",BR3+BR5)","v":""},{"$f":"IF(BS3=\"\",\"\",BS3+BS5)","v":""},{"$f":"IF(BT3=\"\",\"\",BT3+BT5)","v":""},{"$f":"IF(BU3=\"\",\"\",BU3+BU5)","v":""},{"$f":"IF(BV3=\"\",\"\",BV3+BV5)","v":""},{"$f":"IF(BW3=\"\",\"\",BW3+BW5)","v":""},{"$f":"IF(BX3=\"\",\"\",BX3+BX5)","v":""},{"$f":"IF(BY3=\"\",\"\",BY3+BY5)","v":""},{"$f":"IF(BZ3=\"\",\"\",BZ3+BZ5)","v":""},{"$f":"IF(CA3=\"\",\"\",CA3+CA5)","v":""},{"$f":"IF(CB3=\"\",\"\",CB3+CB5)","v":""},{"$f":"IF(CC3=\"\",\"\",CC3+CC5)","v":""},{"$f":"IF(CD3=\"\",\"\",CD3+CD5)","v":""},{"$f":"IF(CE3=\"\",\"\",CE3+CE5)","v":""},{"$f":"IF(CF3=\"\",\"\",CF3+CF5)","v":""},{"$f":"IF(CG3=\"\",\"\",CG3+CG5)","v":""},{"$f":"IF(CH3=\"\",\"\",CH3+CH5)","v":""},{"$f":"IF(CI3=\"\",\"\",CI3+CI5)","v":""},{"$f":"IF(CJ3=\"\",\"\",CJ3+CJ5)","v":""},{"$f":"IF(CK3=\"\",\"\",CK3+CK5)","v":""},{"$f":"IF(CL3=\"\",\"\",CL3+CL5)","v":""},{"$f":"IF(CM3=\"\",\"\",CM3+CM5)","v":""},{"$f":"IF(CN3=\"\",\"\",CN3+CN5)","v":""},{"$f":"IF(CO3=\"\",\"\",CO3+CO5)","v":""},{"$f":"IF(CP3=\"\",\"\",CP3+CP5)","v":""},{"$f":"IF(CQ3=\"\",\"\",CQ3+CQ5)","v":""},{"$f":"IF(CR3=\"\",\"\",CR3+CR5)","v":""},{"$f":"IF(CS3=\"\",\"\",CS3+CS5)","v":""},{"$f":"IF(CT3=\"\",\"\",CT3+CT5)","v":""},{"$f":"IF(CU3=\"\",\"\",CU3+CU5)","v":""},{"$f":"IF(CV3=\"\",\"\",CV3+CV5)","v":""},{"$f":"IF(CW3=\"\",\"\",CW3+CW5)","v":""}]
["Time Tolerance",{"$f":"IF(B4=\"\",\"\",B4+B6)","v":""},{"$nulls":26},{"$f":"IF(AC4=\"\",\"\",AC4+AC6)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BO4=\"\",\"\",BO4+BO6)","v":""},{"$f":"IF(BP4=\"\",\"\",BP4+BP6)","v":""},{"$f":"IF(BQ4=\"\",\"\",BQ4+BQ6)","v":""},{"$f":"IF(BR4=\"\",\"\",BR4+BR6)","v":""},{"$f":"IF(BS4=\"\",\"\",BS4+BS6)","v":""},{"$f":"IF(BT4=\"\",\"\",BT4+BT6)","v":""},{"$f":"IF(BU4=\"\",\"\",BU4+BU6)","v":""},{"$f":"IF(BV4=\"\",\"\",BV4+BV6)","v":""},{"$f":"IF(BW4=\"\",\"\",BW4+BW6)","v":""},{"$f":"IF(BX4=\"\",\"\",BX4+BX6)","v":""},{"$f":"IF(BY4=\"\",\"\",BY4+BY6)","v":""},{"$f":"IF(BZ4=\"\",\"\",BZ4+BZ6)","v":""},{"$f":"IF(CA4=\"\",\"\",CA4+CA6)","v":""},{"$f":"IF(CB4=\"\",\"\",CB4+CB6)","v":""},{"$f":"IF(CC4=\"\",\"\",CC4+CC6)","v":""},{"$f":"IF(CD4=\"\",\"\",CD4+CD6)","v":""},{"$f":"IF(CE4=\"\",\"\",CE4+CE6)","v":""},{"$f":"IF(CF4=\"\",\"\",CF4+CF6)","v":""},{"$f":"IF(CG4=\"\",\"\",CG4+CG6)","v":""},{"$f":"IF(CH4=\"\",\"\",CH4+CH6)","v":""},{"$f":"IF(CI4=\"\",\"\",CI4+CI6)","v":""},{"$f":"IF(CJ4=\"\",\"\",CJ4+CJ6)","v":""},{"$f":"IF(CK4=\"\",\"\",CK4+CK6)","v":""},{"$f":"IF(CL4=\"\",\"\",CL4+CL6)","v":""},{"$f":"IF(CM4=\"\",\"\",CM4+CM6)","v":""},{"$f":"IF(CN4=\"\",\"\",CN4+CN6)","v":""},{"$f":"IF(CO4=\"\",\"\",CO4+CO6)","v":""},{"$f":"IF(CP4=\"\",\"\",CP4+CP6)","v":""},{"$f":"IF(CQ4=\"\",\"\",CQ4+CQ6)","v":""},{"$f":"IF(CR4=\"\",\"\",CR4+CR6)","v":""},{"$f":"IF(CS4=\"\",\"\",CS4+CS6)","v":""},{"$f":"IF(CT4=\"\",\"\",CT4+CT6)","v":""},{"$f":"IF(CU4=\"\",\"\",CU4+CU6)","v":""},{"$f":"IF(CV4=\"\",\"\",CV4+CV6)","v":""},{"$f":"IF(CW4=\"\",\"\",CW4+CW6)","v":""}]
["Actual Cost"]
["Earned Value"]
["Information","W00","W01","W02","W03","W04","W05","W06","W07","W08","W09","W10","W11","W12","W13","W14","W15","W16","W17","W18","W19","W20","W21","W22","W23","W24","W25","W26","W27","W28","W29","W30","W31","W32","W33","W34","W35","W36","W37","W38","W39","W40","W41","W42","W43","W44","W45","W46","W47","W48","W49","W50","W51","W52","W53","W54","W55","W56","W57","W58","W59","W60","W61","W62","W63","W64","W65","W66","W67","W68","W69","W70","W71","W72","W73","W74","W75","W76","W77","W78","W79","W80","W81","W82","W83","W84","W85","W86","W87","W88","W89","W90","W91","W92","W93","W94","W95","W96","W97","W98","W99"]
["Earned Schedule",0,{"$f":"IF(C13=\"\",\"\",MATCH(C13,9:9,1)-2+(-INDEX(9:9,MATCH(C13,9:9,1))+C13)/(INDEX(9:9,MATCH(C13,9:9,1)+1)-INDEX(9:9,MATCH(C13,9:9,1))))","v":""},{"$f":"IF(D13=\"\",\"\",MATCH(D13,9:9,1)-2+(-INDEX(9:9,MATCH(D13,9:9,1))+D13)/(INDEX(9:9,MATCH(D13,9:9,1)+1)-INDEX(9:9,MATCH(D13,9:9,1))))","v":""},"","","","","","","","","","","",{"$f":"IF(P13=\"\",\"\",MATCH(P13,9:9,1)-2+(-INDEX(9:9,MATCH(P13,9:9,1))+P13)/(INDEX(9:9,MATCH(P13,9:9,1)+1)-INDEX(9:9,MATCH(P13,9:9,1))))","v":""},{"$f":"IF(Q13=\"\",\"\",MATCH(Q13,9:9,1)-2+(-INDEX(9:9,MATCH(Q13,9:9,1))+Q13)/(INDEX(9:9,MATCH(Q13,9:9,1)+1)-INDEX(9:9,MATCH(Q13,9:9,1))))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(CC13=\"\",\"\",MATCH(CC13,9:9,1)-2+(-INDEX(9:9,MATCH(CC13,9:9,1))+CC13)/(INDEX(9:9,MATCH(CC13,9:9,1)+1)-INDEX(9:9,MATCH(CC13,9:9,1))))","v":""},"","","","","","","","","","","","","","","","","","","",""]
["Completion",{"$f":"IF(B13=\"\",\"\",B15/B18)","v":""},{"$f":"IF(C13=\"\",\"\",C15/C18)","v":""},{"$f":"IF(D13=\"\",\"\",D15/D18)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BP13=\"\",\"\",BP15/BP18)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Forecast At-Completion Cost",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(C13=\"\",\"\",IF(C13<C3*0.1,NA(),ROUND(C3*C12/C9,0)))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13<D3*0.1,NA(),ROUND(D3*D12/D9,0)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BP13=\"\",\"\",IF(BP13<BP3*0.1,NA(),ROUND(BP3*BP12/BP9,0)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Forecast Total Duration",{"$f":"NA()","v":{"$error":"#N/A"}},{"$f":"IF(C13=\"\",\"\",IF(C13<C3*0.12,NA(),ROUND(C4*C2/C15,0)))","v":""},{"$f":"IF(D13=\"\",\"\",IF(D13<D3*0.12,NA(),ROUND(D4*D2/D15,0)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(BP13=\"\",\"\",IF(BP13<BP3*0.12,NA(),ROUND(BP4*BP2/BP15,0)))","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Current Completion",{"$f":"P2CompletionNow","v":""},{"$f":"B19","v":""},{"$f":"C19","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"BO19","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"Dashboard","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}