{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Home","Step1","Step2","Step2B","Step2C","Step3","Step4","Step5","Step6","Step6_Charts","_parameters","_maintcosts","_1normal","_2weight","_3sum","_Criteria"],"not_rendered":{"charts":16,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,15,10,23],[11,15,11,23],[1,15,3,23],[4,15,8,23],[26,2,27,11],[17,10,17,11],[2,1,2,12],[5,2,5,3],[5,4,5,9],[5,10,5,11],[9,2,9,3],[9,4,9,9],[9,10,9,11],[6,2,7,11],[10,2,11,11],[14,2,15,11],[1,1,1,12],[21,2,21,3],[21,4,21,9],[21,10,21,11],[25,2,25,3],[25,4,25,9],[25,10,25,11],[13,2,13,3],[13,10,13,11],[17,2,17,3],[17,4,17,9],[18,2,19,11],[22,2,23,11]]}
[]
[null,"Rightsizing Return on Investment Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Limited Use Application\" & CHAR(10)&\"Prepared for the\" & CHAR(10) &\"Transportation Research Board\"&CHAR(10)&\"NAS-NRC\"","v":"Limited Use Application\nPrepared for the\nTransportation Research Board\nNAS-NRC"}]
[null,"A tool for measuring and comparing rightsizing projects"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This application has been prepared under the National Highway Cooperative Research Program (NCHRP) project 19-14. The Transportation Research Board is not responsible for the accuracy nor maintenance of the application.  Dissemination of the information included therein must be approved by the Transportation Research Board."]
[null,null,"Step 1",null,"Define Project Scenarios"]
[null,null,"What are the rightsizing scenarios that are being considered?"]
[]
[]
[null,null,"Step 2",null,"Identify Partners",null,null,null,null,null,"Go"]
[null,null,"What agencies or organizations have a role in the rightsizing?  Supplemental tools facilitate estimating partners' financial contributions.",null,null,null,null,null,null,null,null,null,null,null,null,"Developers' Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This tool is intended for use with 4 scenarios, 4 partners, and 14 criteria."]
[]
[null,null,"Step 3",null,"Select Criteria",null,null,null,null,null,"Go"]
[null,null,"By what criteria will each partner judge the rightsizing scenarios' success?"]
[]
[]
[null,null,"Step 4",null,"Enter Criteria Values",null,null,null,null,null,"Go"]
[null,null,"How are the rightsizing scenarios expected to change the criteria's values?"]
[]
[]
[null,null,"Step 5",null,"Weight Criteria by Importance",null,null,null,null,null,"Go"]
[null,null,"What criteria are most and least important to each partner?"]
[]
[]
[null,null,"Step 6",null,"Results",null,null,null,null,null,"Go"]
[null,null,"How well do the rightsizing scenarios achieve each partner's criteria for success?"]

{"sheet":"Step1","index":1,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,1,1,2],[7,7,7,11],[6,7,6,11],[1,5,1,11],[41,2,44,5],[41,7,44,11],[26,1,26,3],[29,7,29,11],[28,7,28,11],[28,2,28,5],[40,7,40,11],[39,7,39,11],[39,2,39,5],[37,1,37,3],[4,14,4,22],[6,15,6,17],[19,2,22,5],[19,7,22,11],[30,2,33,5],[30,7,33,11],[18,7,18,11],[17,7,17,11],[17,2,17,5],[15,1,15,3],[8,2,11,5],[8,7,11,11],[4,1,4,3],[6,2,6,5],[14,15,14,17],[22,15,22,17],[22,18,29,21],[14,18,19,21],[6,18,11,21],[7,15,11,17],[15,15,19,17],[23,15,29,17]]}
[]
[null,"Home",null,null,null,"STEP 1 - DEFINE PROJECT SCENARIOS"]
[]
[]
[null,"SCENARIO 1",null,null,null,null,null,null,null,null,null,null,null,null,"RIGHTSIZING INFORMATION"]
[]
[null,null,"Scenario Name",null,null,null,null,null,null,null,null,null,null,null,null,"Rightsizing Problem"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add a brief description of the rightsizing problem that the project scenarios seek to address.  For record keeping purposes"]
[null,null,"Project Description (optional, for \nrecord keeping only)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rightsizing Objective"]
[null,"SCENARIO 2",null,null,null,null,null,null,null,null,null,null,null,null,null,"Briefly summarize the primary objectives of rightsizing for record keeping purposes."]
[]
[null,null,"Scenario Name"]
[]
[null,null,"Project Description (optional, for \nrecord keeping only)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add any additional information that is relevant to the analysis. "]
[]
[]
[null,"SCENARIO 3"]
[]
[null,null,"Scenario Name"]
[]
[null,null,"Project Description (optional, for \nrecord keeping only)"]
[]
[]
[]
[]
[]
[]
[null,"SCENARIO 4"]
[]
[null,null,"Scenario Name"]
[]
[null,null,"Project Description (optional, for \nrecord keeping only)"]

{"sheet":"Step2","index":2,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,1,14,2],[13,7,14,8],[13,13,14,14],[13,19,14,20],[21,1,22,2],[21,7,22,8],[21,13,22,14],[21,19,22,20],[13,3,13,5],[29,19,30,20],[29,13,30,14],[29,7,30,8],[19,20,19,23],[19,2,19,5],[27,20,27,23],[27,2,27,5],[29,3,29,5],[29,9,29,11],[29,15,29,17],[27,14,27,17],[1,2,1,3],[3,2,3,3],[4,3,4,5],[3,8,3,9],[4,9,4,11],[1,7,1,20],[3,20,3,21],[4,21,4,23],[3,14,3,15],[4,15,4,17],[37,21,37,23],[37,3,37,5],[37,9,37,11],[11,2,11,5],[11,20,11,23],[13,21,13,23],[21,3,21,5],[21,9,21,11],[21,15,21,17],[21,21,21,23],[11,8,11,11],[19,8,19,11],[27,8,27,11],[35,8,35,11],[11,14,11,17],[19,14,19,17],[31,19,31,20],[35,20,35,23],[35,2,35,5],[9,2,9,8],[17,2,17,8],[25,2,25,8],[33,2,33,8],[33,9,33,14],[25,9,25,14],[17,9,17,14],[9,9,9,14],[35,14,35,17],[13,9,13,11],[13,15,13,17],[29,21,29,23],[29,1,30,2],[37,13,38,14],[37,19,38,20],[37,7,38,8],[37,1,38,2],[37,15,37,17]]}
[]
[null,null,"Home",null,null,null,null,"STEP 2 - IDENTIFY PARTNERS"]
[]
[null,null,"Partner 1",null,null,null,null,null,"Partner 2",null,null,null,null,null,"Partner 3",null,null,null,null,null,"Partner 4"]
[null,null,"Name",null,null,null,null,null,"Name",null,null,null,null,null,"Name",null,null,null,null,null,"Name"]
[]
[]
[]
[]
[null,null,"COSTS FOR SCENARIO 1",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""}]
[]
[null,"Partner 1",{"$f":"Step2!$D$5","v":0},null,null,null,null,"Partner 2",{"$f":"$J$5","v":0},null,null,null,null,"Partner 3",{"$f":"$P$5","v":0},null,null,null,null,"Partner 4",{"$f":"IF(ISBLANK($V$5),\"\",$V$5)","v":""}]
[]
[null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!K10","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!K11","v":""}]
[]
[]
[]
[null,null,"COSTS FOR SCENARIO 2",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""}]
[]
[null,"Partner 1",{"$f":"Step2!$D$5","v":0},null,null,null,null,"Partner 2",{"$f":"$J$5","v":0},null,null,null,null,"Partner 3",{"$f":"$P$5","v":0},null,null,null,null,"Partner 4",{"$f":"IF(ISBLANK($V$5),\"\",$V$5)","v":""}]
[]
[null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!M11","v":""}]
[]
[]
[]
[null,null,"COSTS FOR SCENARIO 3",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""}]
[]
[null,"Partner 1",{"$f":"Step2!$D$5","v":0},null,null,null,null,"Partner 2",{"$f":"$J$5","v":0},null,null,null,null,"Partner 3",{"$f":"$P$5","v":0},null,null,null,null,"Partner 4",{"$f":"IF(ISBLANK($V$5),\"\",$V$5)","v":""}]
[]
[null,"Total Financial Contribution",null,null,null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!O9","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!O10","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!O11","v":""}]
[]
[]
[]
[null,null,"COSTS FOR SCENARIO 4",null,null,null,null,null,null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[]
[null,"Partner 1",{"$f":"Step2!$D$5","v":0},null,null,null,null,"Partner 2",{"$f":"$J$5","v":0},null,null,null,null,"Partner 3",{"$f":"$P$5","v":0},null,null,null,null,"Partner 4",{"$f":"IF(ISBLANK($V$5),\"\",$V$5)","v":""}]
[]
[null,"Total Financial Contribution",null,{"$f":"Step2C!Q8","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!Q9","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!Q10","v":""},null,null,null,"Total Financial Contribution",null,{"$f":"Step2C!Q11","v":""}]

{"sheet":"Step2B","index":3,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,13,21,16],[21,17,21,19],[21,20,21,22],[21,2,21,5],[21,6,21,8],[21,9,21,11],[11,2,11,5],[11,6,11,8],[11,9,11,11],[11,13,11,16],[11,17,11,19],[11,20,11,22],[20,2,20,5],[20,6,20,8],[20,9,20,11],[20,13,20,16],[20,17,20,19],[20,20,20,22],[19,2,19,5],[19,6,19,8],[19,9,19,11],[19,13,19,16],[19,17,19,19],[19,20,19,22],[18,2,18,5],[18,6,18,8],[18,9,18,11],[16,17,16,19],[18,13,18,16],[18,17,18,19],[18,20,18,22],[17,2,17,5],[17,6,17,8],[17,9,17,11],[17,13,17,16],[17,17,17,19],[17,20,17,22],[10,13,10,16],[10,17,10,19],[10,20,10,22],[16,20,16,22],[13,2,13,5],[13,6,13,11],[13,13,13,16],[13,17,13,22],[14,2,14,5],[14,6,14,8],[14,13,14,16],[14,17,14,19],[16,2,16,5],[16,6,16,8],[16,9,16,11],[16,13,16,16],[10,9,10,11],[3,17,3,22],[4,13,4,16],[4,17,4,19],[6,13,6,16],[6,17,6,19],[6,20,6,22],[7,13,7,16],[7,17,7,19],[7,20,7,22],[8,13,8,16],[8,17,8,19],[8,20,8,22],[9,13,9,16],[9,17,9,19],[9,20,9,22],[4,2,4,5],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[1,2,1,3],[1,7,1,15],[4,6,4,8],[3,13,3,16],[10,6,10,8],[6,2,6,5],[6,6,6,8],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[3,2,3,5],[3,6,3,11],[7,6,7,8],[8,6,8,8],[9,6,9,8]]}
[]
[null,null,"Home",null,null,null,null,"STEP 2B - TOOL FOR ESTIMATING PARTNER COSTS"]
[]
[null,null,"SCENARIO 1",null,null,null,{"$f":"IF(Step1!$H$7=0,\"\",Step1!$H$7)","v":""},null,null,null,null,null,null,"SCENARIO 2",null,null,null,{"$f":"IF(Step1!$H$18=0,\"\",Step1!$H$18)","v":""}]
[null,null,"Total Project Capital Costs",null,null,null,null,null,null,null,null,null,null,"Total Project Capital Costs"]
[]
[null,null,"Partner",null,null,null,"Percentage Contribution",null,null,"Total Contribution",null,null,null,"Partner",null,null,null,"Percentage Contribution",null,null,"Total Contribution"]
[null,null,{"$f":"IF(Step2!D5=0,\"\",Step2!D5)","v":""},null,null,null,null,null,null,{"$f":"G8*$G$5","v":0},null,null,null,{"$f":"IF(Step2!D5=0,\"\",Step2!D5)","v":""},null,null,null,null,null,null,{"$f":"R8*$R$5","v":0}]
[null,null,{"$f":"IF(Step2!J5=0,\"\",Step2!J5)","v":""},null,null,null,null,null,null,{"$f":"G9*$G$5","v":0},null,null,null,{"$f":"IF(Step2!J5=0,\"\",Step2!J5)","v":""},null,null,null,null,null,null,{"$f":"R9*$R$5","v":0}]
[null,null,{"$f":"IF(Step2!P5=0,\"\",Step2!P5)","v":""},null,null,null,null,null,null,{"$f":"G10*$G$5","v":0},null,null,null,{"$f":"IF(Step2!P5=0,\"\",Step2!P5)","v":""},null,null,null,null,null,null,0]
[null,null,{"$f":"IF(Step2!V5=0,\"\",Step2!V5)","v":""},null,null,null,null,null,null,{"$f":"G11*$G$5","v":0},null,null,null,{"$f":"IF(Step2!V5=0,\"\",Step2!V5)","v":""},null,null,null,null,null,null,0]
[null,null,"Total (should add to 100%)",null,null,null,{"$f":"SUM(G8:I11)","v":0},null,null,{"$f":"SUM(J8:L11)","v":0},null,null,null,"Total (should add to 100%)",null,null,null,{"$f":"SUM(R8:T11)","v":0},null,null,{"$f":"SUM(U8:W11)","v":0}]
[]
[null,null,"SCENARIO 3",null,null,null,{"$f":"IF(Step1!$H$29=0,\"\",Step1!$H$29)","v":""},null,null,null,null,null,null,"SCENARIO 4",null,null,null,{"$f":"IF(Step1!$H$40=0,\"\",Step1!$H$40)","v":""}]
[null,null,"Total Project Capital Costs",null,null,null,null,null,null,null,null,null,null,"Total Project Capital Costs"]
[]
[null,null,"Partner",null,null,null,"Percentage Contribution",null,null,"Total Contribution",null,null,null,"Partner",null,null,null,"Percentage Contribution",null,null,"Total Contribution"]
[null,null,{"$f":"IF(Step2!D5=0,\"\",Step2!D5)","v":""},null,null,null,null,null,null,{"$f":"G18*$G$15","v":0},null,null,null,{"$f":"IF(Step2!D5=0,\"\",Step2!D5)","v":""},null,null,null,null,null,null,{"$f":"R18*$R$15","v":0}]
[null,null,{"$f":"IF(Step2!J5=0,\"\",Step2!J5)","v":""},null,null,null,null,null,null,{"$f":"G19*$G$15","v":0},null,null,null,{"$f":"IF(Step2!J5=0,\"\",Step2!J5)","v":""},null,null,null,null,null,null,{"$f":"R19*$R$15","v":0}]
[null,null,{"$f":"IF(Step2!P5=0,\"\",Step2!P5)","v":""},null,null,null,null,null,null,0,null,null,null,{"$f":"IF(Step2!P5=0,\"\",Step2!P5)","v":""},null,null,null,null,null,null,0]
[null,null,{"$f":"IF(Step2!V5=0,\"\",Step2!V5)","v":""},null,null,null,null,null,null,0,null,null,null,{"$f":"IF(Step2!V5=0,\"\",Step2!V5)","v":""},null,null,null,null,null,null,0]
[null,null,"Total (should add to 100%)",null,null,null,{"$f":"SUM(G18:I21)","v":0},null,null,{"$f":"SUM(J18:L21)","v":0},null,null,null,"Total (should add to 100%)",null,null,null,{"$f":"SUM(R18:T21)","v":0},null,null,{"$f":"SUM(U18:W21)","v":0}]

{"sheet":"Step2C","index":4,"n_rows":111,"n_cols":37,"rows_kept":111,"cut":false,"hidden":false,"merged":[[39,4,39,6],[37,4,37,6],[33,2,34,3],[34,4,34,6],[35,4,35,6],[38,4,38,6],[4,12,4,13],[5,12,6,13],[18,1,18,3],[37,2,38,3],[33,4,33,6],[30,4,30,6],[31,4,31,6],[25,2,26,3],[29,2,30,3],[29,4,29,6],[26,4,26,6],[27,4,27,6],[10,10,10,11],[19,1,20,3],[7,10,7,11],[32,4,32,6],[28,4,28,6],[24,4,24,6],[9,6,9,9],[10,6,10,9],[10,12,10,13],[10,14,10,15],[10,16,10,17],[11,16,11,17],[11,14,11,15],[11,12,11,13],[11,10,11,11],[4,1,4,2],[24,2,24,3],[28,2,28,3],[32,2,32,3],[36,2,36,3],[4,16,4,17],[5,16,6,17],[8,10,8,11],[9,10,9,11],[7,12,7,13],[8,12,8,13],[9,12,9,13],[7,14,7,15],[8,14,8,15],[9,14,9,15],[7,16,7,17],[8,16,8,17],[9,16,9,17],[4,10,4,11],[5,10,6,11],[4,14,4,15],[5,14,6,15],[7,6,7,9],[8,6,8,9],[49,2,50,3],[49,4,49,6],[50,4,50,6],[51,4,51,6],[52,2,52,3],[52,4,52,6],[1,2,1,3],[1,7,1,15],[42,1,42,3],[43,1,44,3],[48,2,48,3],[48,4,48,6],[12,5,12,9],[11,5,11,9],[3,10,3,17],[12,16,12,17],[12,14,12,15],[12,12,12,13],[12,10,12,11],[22,1,22,2],[21,1,21,2],[45,1,45,2],[25,4,25,6],[36,4,36,6],[57,2,58,3],[57,4,57,6],[58,4,58,6],[59,4,59,6],[60,2,60,3],[60,4,60,6],[53,2,54,3],[53,4,53,6],[54,4,54,6],[55,4,55,6],[56,2,56,3],[56,4,56,6],[72,2,72,3],[72,4,72,6],[73,2,74,3],[73,4,73,6],[74,4,74,6],[61,2,62,3],[61,4,61,6],[62,4,62,6],[66,1,66,3],[67,1,68,3],[79,4,79,6],[80,2,80,3],[80,4,80,6],[81,2,82,3],[81,4,81,6],[82,4,82,6],[75,4,75,6],[76,2,76,3],[76,4,76,6],[77,2,78,3],[77,4,77,6],[78,4,78,6],[91,1,92,3],[96,2,96,3],[96,4,96,6],[97,2,98,3],[97,4,97,6],[98,4,98,6],[83,4,83,6],[84,2,84,3],[84,4,84,6],[85,2,86,3],[85,4,85,6],[86,4,86,6],[46,1,46,2],[69,1,69,2],[70,1,70,2],[93,1,93,2],[94,1,94,2],[107,4,107,6],[108,2,108,3],[108,4,108,6],[109,2,110,3],[109,4,109,6],[110,4,110,6],[103,4,103,6],[104,2,104,3],[104,4,104,6],[105,2,106,3],[105,4,105,6],[106,4,106,6],[99,4,99,6],[100,2,100,3],[100,4,100,6],[101,2,102,3],[101,4,101,6],[102,4,102,6],[90,1,90,3]]}
[]
[null,null,"Home",null,null,null,null,"STEP 2C - TOOL FOR ESTIMATING LIFE CYCLE COSTS"]
[]
[null,null,null,null,null,null,null,null,null,null,"NET PRESENT VALUE"]
[null,"Discount Rate",null,7.0000000000000007E-2,null,null,null,null,null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":""},null,{"$f":"B44","v":""},null,{"$f":"B68","v":""},null,{"$f":"B92","v":""}]
[]
[null,null,null,null,null,"Partner 1",{"$f":"C26","v":""},null,null,null,{"$f":"IF((SUM(H27:AB27)=0),\"\",SUM(H27:AB27))","v":""},null,{"$f":"IF((SUM(H51:AK51)=0),\"\",SUM(H51:AK51))","v":""},null,{"$f":"IF((SUM(H75:AK75)=0),\"\",SUM(H75:AK75))","v":""},null,{"$f":"IF(SUM(H99:AK99)=0,\"\",SUM(H99:AK99))","v":""}]
[null,null,null,null,null,"Partner 2",{"$f":"C30","v":""},null,null,null,{"$f":"IF((SUM(H31:AB31)=0),\"\",SUM(H31:AB31))","v":""},null,{"$f":"IF((SUM(H55:AK55)=0),\"\",SUM(H55:AK55))","v":""},null,{"$f":"IF((SUM(H79:AK79)=0),\"\",SUM(H79:AK79))","v":""},null,{"$f":"IF(SUM(H103:AK103)=0,\"\",SUM(H103:AK103))","v":""}]
[null,null,null,null,null,"Partner 3",{"$f":"C34","v":""},null,null,null,{"$f":"IF((SUM(H35:AB35)=0),\"\",SUM(H35:AB35))","v":""},null,{"$f":"IF((SUM(H59:AK59)=0),\"\",SUM(H59:AK59))","v":""},null,{"$f":"IF((SUM(H83:AK83)=0),\"\",SUM(H83:AK83))","v":""},null,{"$f":"IF(SUM(H107:AK107)=0,\"\",SUM(H107:AK107))","v":""}]
[null,null,null,null,null,"Partner 4",{"$f":"C38","v":""},null,null,null,{"$f":"IF((SUM(H39:AB39)=0),\"\",SUM(H39:AB39))","v":""},null,{"$f":"IF((SUM(H63:AK63)=0),\"\",SUM(H63:AK63))","v":""},null,{"$f":"IF(SUM(H87:AK87)=0,\"\",SUM(H87:AK87))","v":""},null,{"$f":"IF(SUM(H111:AK111)=0,\"\",SUM(H111:AK111))","v":""}]
[null,null,null,null,null,"Total (Net Present Value)",null,null,null,null,{"$f":"IF((SUM(K8:L11)=0),\"\",SUM(K8:L11))","v":""},null,{"$f":"IF((SUM(M8:N11)=0),\"\",SUM(M8:N11))","v":""},null,{"$f":"IF(SUM(O8:P11)=0,\"\",SUM(O8:P11))","v":""},null,{"$f":"IF(SUM(Q8:R11)=0,\"\",SUM(Q8:R11))","v":""}]
[null,null,null,null,null,"Equivalent Annual Annuity",null,null,null,null,{"$f":"IF(ISERROR($D$5*K12/(1-(1+$D$5)^(D22-D23))),\"\",$D$5*K12/(1-(1+$D$5)^(D22-D23)))","v":""},null,{"$f":"IF(ISERROR($D$5*M12/(1-(1+$D$5)^(D46-D47))),\"\",$D$5*M12/(1-(1+$D$5)^(D46-D47)))","v":""},null,{"$f":"IF(ISERROR($D$5*O12/(1-(1+$D$5)^(D70-D71))),\"\",$D$5*O12/(1-(1+$D$5)^(D70-D71)))","v":""},null,{"$f":"IF(ISERROR($D$5*Q12/(1-(1+$D$5)^(D94-D95))),\"\",$D$5*Q12/(1-(1+$D$5)^(D94-D95)))","v":""}]
[]
[]
[]
[]
[]
[null,"Scenario 1"]
[null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""}]
[]
[null,"Start Year",null,2018]
[null,"End Year",null,2045]
[null,null,null,null,null,null,null,{"$f":"D22","v":2018},{"$f":"IF(ISERROR(IF(H24+1<=$D$23,H24+1,\"\")),\"\",IF(H24+1<=$D$23,H24+1,\"\"))","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,"",""]
[null,null,"Partner 1",null,"Nominal Cost"]
[null,null,{"$f":"IF(ISBLANK(Step2!D5),\"\",Step2!D5)","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H26-H25)/(1+$D$5)^(H$24-$H$24)),\"\",-1*(H26-H25)/(1+$D$5)^(H$24-$H$24))","v":0},{"$f":"IF(ISERROR((I26-I25)/(1+$D$5)^(I$24-$H$24)),\"\",-1*(I26-I25)/(1+$D$5)^(I$24-$H$24))","v":0},{"$f":"IF(ISERROR((J26-J25)/(1+$D$5)^(J$24-$H$24)),\"\",-1*(J26-J25)/(1+$D$5)^(J$24-$H$24))","v":0},{"$f":"IF(ISERROR((K26-K25)/(1+$D$5)^(K$24-$H$24)),\"\",-1*(K26-K25)/(1+$D$5)^(K$24-$H$24))","v":0},{"$f":"IF(ISERROR((L26-L25)/(1+$D$5)^(L$24-$H$24)),\"\",-1*(L26-L25)/(1+$D$5)^(L$24-$H$24))","v":0},{"$f":"IF(ISERROR((M26-M25)/(1+$D$5)^(M$24-$H$24)),\"\",-1*(M26-M25)/(1+$D$5)^(M$24-$H$24))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 2",null,"Nominal Cost"]
[null,null,{"$f":"IF(ISBLANK(Step2!J5),\"\",Step2!J5)","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H30-H29)/(1+$D$5)^(H$24-$H$24)),\"\",-1*(H30-H29)/(1+$D$5)^(H$24-$H$24))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 3",null,"Nominal Cost"]
[null,null,{"$f":"IF(ISBLANK(Step2!P5), \"\", Step2!P5)","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H34-H33)/(1+$D$5)^(H$24-$H$24)),\"\",-1*(H34-H33)/(1+$D$5)^(H$24-$H$24))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 4",null,"Nominal Cost"]
[null,null,{"$f":"IF(ISBLANK(Step2!V5), \"\", Step2!V5)","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H38-H37)/(1+$D$5)^(H$24-$H$24)),\"\",-1*(H38-H37)/(1+$D$5)^(H$24-$H$24))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[]
[]
[null,"Scenario 2"]
[null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""}]
[]
[null,"Start Year",null,{"$f":"D22","v":2018}]
[null,"End Year",null,{"$f":"D23","v":2045}]
[null,null,null,null,null,null,null,{"$f":"D46","v":2018},{"$f":"IF(ISERROR(IF(H48+1<=$D$47,H48+1,\"\")),\"\",IF(H48+1<=$D$47,H48+1,\"\"))","v":2019},{"$f":"IF(ISERROR(IF(I48+1<=$D$47,I48+1,\"\")),\"\",IF(I48+1<=$D$47,I48+1,\"\"))","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,"",""]
[null,null,"Partner 1",null,"Nominal Cost"]
[null,null,{"$f":"C26","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H50-H49)/(1+$D$5)^(H$48-$H$24)),\"\",-1*(H50-H49)/(1+$D$5)^(H$24-$H$24))","v":0},{"$f":"IF(ISERROR((I50-I49)/(1+$D$5)^(I$48-$H$48)),\"\",-1*(I50-I49)/(1+$D$5)^(I$48-$H$48))","v":0},{"$f":"IF(ISERROR((J50-J49)/(1+$D$5)^(J$48-$H$48)),\"\",-1*(J50-J49)/(1+$D$5)^(J$48-$H$48))","v":0},{"$f":"IF(ISERROR((K50-K49)/(1+$D$5)^(K$48-$H$48)),\"\",-1*(K50-K49)/(1+$D$5)^(K$48-$H$48))","v":0},{"$f":"IF(ISERROR((L50-L49)/(1+$D$5)^(L$48-$H$48)),\"\",-1*(L50-L49)/(1+$D$5)^(L$48-$H$48))","v":0},{"$f":"IF(ISERROR((M50-M49)/(1+$D$5)^(M$48-$H$24)),\"\",-1*(M50-M49)/(1+$D$5)^(M$48-$H$24))","v":0},{"$f":"IF(ISERROR((N50-N49)/(1+$D$5)^(N$48-$H$48)),\"\",-1*(N50-N49)/(1+$D$5)^(N$48-$H$48))","v":0},{"$f":"IF(ISERROR((O50-O49)/(1+$D$5)^(O$48-$H$48)),\"\",-1*(O50-O49)/(1+$D$5)^(O$48-$H$48))","v":0},{"$f":"IF(ISERROR((P50-P49)/(1+$D$5)^(P$48-$H$48)),\"\",-1*(P50-P49)/(1+$D$5)^(P$48-$H$48))","v":0},{"$f":"IF(ISERROR((Q50-Q49)/(1+$D$5)^(Q$48-$H$48)),\"\",-1*(Q50-Q49)/(1+$D$5)^(Q$48-$H$48))","v":0},{"$f":"IF(ISERROR((R50-R49)/(1+$D$5)^(R$48-$H$24)),\"\",-1*(R50-R49)/(1+$D$5)^(R$48-$H$24))","v":0},{"$f":"IF(ISERROR((S50-S49)/(1+$D$5)^(S$48-$H$48)),\"\",-1*(S50-S49)/(1+$D$5)^(S$48-$H$48))","v":0},{"$f":"IF(ISERROR((T50-T49)/(1+$D$5)^(T$48-$H$48)),\"\",-1*(T50-T49)/(1+$D$5)^(T$48-$H$48))","v":0},{"$f":"IF(ISERROR((U50-U49)/(1+$D$5)^(U$48-$H$48)),\"\",-1*(U50-U49)/(1+$D$5)^(U$48-$H$48))","v":0},{"$f":"IF(ISERROR((V50-V49)/(1+$D$5)^(V$48-$H$48)),\"\",-1*(V50-V49)/(1+$D$5)^(V$48-$H$48))","v":0},{"$f":"IF(ISERROR((W50-W49)/(1+$D$5)^(W$48-$H$24)),\"\",-1*(W50-W49)/(1+$D$5)^(W$48-$H$24))","v":0},{"$f":"IF(ISERROR((X50-X49)/(1+$D$5)^(X$48-$H$48)),\"\",-1*(X50-X49)/(1+$D$5)^(X$48-$H$48))","v":0},{"$f":"IF(ISERROR((Y50-Y49)/(1+$D$5)^(Y$48-$H$48)),\"\",-1*(Y50-Y49)/(1+$D$5)^(Y$48-$H$48))","v":0},{"$f":"IF(ISERROR((Z50-Z49)/(1+$D$5)^(Z$48-$H$48)),\"\",-1*(Z50-Z49)/(1+$D$5)^(Z$48-$H$48))","v":0},{"$f":"IF(ISERROR((AA50-AA49)/(1+$D$5)^(AA$48-$H$48)),\"\",-1*(AA50-AA49)/(1+$D$5)^(AA$48-$H$48))","v":0},{"$f":"IF(ISERROR((AB50-AB49)/(1+$D$5)^(AB$48-$H$24)),\"\",-1*(AB50-AB49)/(1+$D$5)^(AB$48-$H$24))","v":0},{"$f":"IF(ISERROR((AC50-AC49)/(1+$D$5)^(AC$48-$H$48)),\"\",-1*(AC50-AC49)/(1+$D$5)^(AC$48-$H$48))","v":0},{"$f":"IF(ISERROR((AD50-AD49)/(1+$D$5)^(AD$48-$H$48)),\"\",-1*(AD50-AD49)/(1+$D$5)^(AD$48-$H$48))","v":0},{"$f":"IF(ISERROR((AE50-AE49)/(1+$D$5)^(AE$48-$H$48)),\"\",-1*(AE50-AE49)/(1+$D$5)^(AE$48-$H$48))","v":0},{"$f":"IF(ISERROR((AF50-AF49)/(1+$D$5)^(AF$48-$H$48)),\"\",-1*(AF50-AF49)/(1+$D$5)^(AF$48-$H$48))","v":0},{"$f":"IF(ISERROR((AG50-AG49)/(1+$D$5)^(AG$48-$H$24)),\"\",-1*(AG50-AG49)/(1+$D$5)^(AG$48-$H$24))","v":0},{"$f":"IF(ISERROR((AH50-AH49)/(1+$D$5)^(AH$48-$H$48)),\"\",-1*(AH50-AH49)/(1+$D$5)^(AH$48-$H$48))","v":0},{"$f":"IF(ISERROR((AI50-AI49)/(1+$D$5)^(AI$48-$H$48)),\"\",-1*(AI50-AI49)/(1+$D$5)^(AI$48-$H$48))","v":0},{"$f":"IF(ISERROR((AJ50-AJ49)/(1+$D$5)^(AJ$48-$H$48)),\"\",-1*(AJ50-AJ49)/(1+$D$5)^(AJ$48-$H$48))","v":""},{"$f":"IF(ISERROR((AK50-AK49)/(1+$D$5)^(AK$48-$H$48)),\"\",-1*(AK50-AK49)/(1+$D$5)^(AK$48-$H$48))","v":""}]
[]
[null,null,"Partner 2",null,"Nominal Cost"]
[null,null,{"$f":"C30","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H54-H53)/(1+$D$5)^(H$48-$H$24)),\"\",-1*(H54-H53)/(1+$D$5)^(H$24-$H$24))","v":0},{"$f":"IF(ISERROR((I54-I53)/(1+$D$5)^(I$48-$H$48)),\"\",-1*(I54-I53)/(1+$D$5)^(I$48-$H$48))","v":0},{"$f":"IF(ISERROR((J54-J53)/(1+$D$5)^(J$48-$H$48)),\"\",-1*(J54-J53)/(1+$D$5)^(J$48-$H$48))","v":0},{"$f":"IF(ISERROR((K54-K53)/(1+$D$5)^(K$48-$H$48)),\"\",-1*(K54-K53)/(1+$D$5)^(K$48-$H$48))","v":0},{"$f":"IF(ISERROR((L54-L53)/(1+$D$5)^(L$48-$H$48)),\"\",-1*(L54-L53)/(1+$D$5)^(L$48-$H$48))","v":0},{"$f":"IF(ISERROR((M54-M53)/(1+$D$5)^(M$48-$H$24)),\"\",-1*(M54-M53)/(1+$D$5)^(M$48-$H$24))","v":0},{"$f":"IF(ISERROR((N54-N53)/(1+$D$5)^(N$48-$H$48)),\"\",-1*(N54-N53)/(1+$D$5)^(N$48-$H$48))","v":0},{"$f":"IF(ISERROR((O54-O53)/(1+$D$5)^(O$48-$H$48)),\"\",-1*(O54-O53)/(1+$D$5)^(O$48-$H$48))","v":0},{"$f":"IF(ISERROR((P54-P53)/(1+$D$5)^(P$48-$H$48)),\"\",-1*(P54-P53)/(1+$D$5)^(P$48-$H$48))","v":0},{"$f":"IF(ISERROR((Q54-Q53)/(1+$D$5)^(Q$48-$H$48)),\"\",-1*(Q54-Q53)/(1+$D$5)^(Q$48-$H$48))","v":0},{"$f":"IF(ISERROR((R54-R53)/(1+$D$5)^(R$48-$H$24)),\"\",-1*(R54-R53)/(1+$D$5)^(R$48-$H$24))","v":0},{"$f":"IF(ISERROR((S54-S53)/(1+$D$5)^(S$48-$H$48)),\"\",-1*(S54-S53)/(1+$D$5)^(S$48-$H$48))","v":0},{"$f":"IF(ISERROR((T54-T53)/(1+$D$5)^(T$48-$H$48)),\"\",-1*(T54-T53)/(1+$D$5)^(T$48-$H$48))","v":0},{"$f":"IF(ISERROR((U54-U53)/(1+$D$5)^(U$48-$H$48)),\"\",-1*(U54-U53)/(1+$D$5)^(U$48-$H$48))","v":0},{"$f":"IF(ISERROR((V54-V53)/(1+$D$5)^(V$48-$H$48)),\"\",-1*(V54-V53)/(1+$D$5)^(V$48-$H$48))","v":0},{"$f":"IF(ISERROR((W54-W53)/(1+$D$5)^(W$48-$H$24)),\"\",-1*(W54-W53)/(1+$D$5)^(W$48-$H$24))","v":0},{"$f":"IF(ISERROR((X54-X53)/(1+$D$5)^(X$48-$H$48)),\"\",-1*(X54-X53)/(1+$D$5)^(X$48-$H$48))","v":0},{"$f":"IF(ISERROR((Y54-Y53)/(1+$D$5)^(Y$48-$H$48)),\"\",-1*(Y54-Y53)/(1+$D$5)^(Y$48-$H$48))","v":0},{"$f":"IF(ISERROR((Z54-Z53)/(1+$D$5)^(Z$48-$H$48)),\"\",-1*(Z54-Z53)/(1+$D$5)^(Z$48-$H$48))","v":0},{"$f":"IF(ISERROR((AA54-AA53)/(1+$D$5)^(AA$48-$H$48)),\"\",-1*(AA54-AA53)/(1+$D$5)^(AA$48-$H$48))","v":0},{"$f":"IF(ISERROR((AB54-AB53)/(1+$D$5)^(AB$48-$H$24)),\"\",-1*(AB54-AB53)/(1+$D$5)^(AB$48-$H$24))","v":0},{"$f":"IF(ISERROR((AC54-AC53)/(1+$D$5)^(AC$48-$H$48)),\"\",-1*(AC54-AC53)/(1+$D$5)^(AC$48-$H$48))","v":0},{"$f":"IF(ISERROR((AD54-AD53)/(1+$D$5)^(AD$48-$H$48)),\"\",-1*(AD54-AD53)/(1+$D$5)^(AD$48-$H$48))","v":0},{"$f":"IF(ISERROR((AE54-AE53)/(1+$D$5)^(AE$48-$H$48)),\"\",-1*(AE54-AE53)/(1+$D$5)^(AE$48-$H$48))","v":0},{"$f":"IF(ISERROR((AF54-AF53)/(1+$D$5)^(AF$48-$H$48)),\"\",-1*(AF54-AF53)/(1+$D$5)^(AF$48-$H$48))","v":0},{"$f":"IF(ISERROR((AG54-AG53)/(1+$D$5)^(AG$48-$H$24)),\"\",-1*(AG54-AG53)/(1+$D$5)^(AG$48-$H$24))","v":0},{"$f":"IF(ISERROR((AH54-AH53)/(1+$D$5)^(AH$48-$H$48)),\"\",-1*(AH54-AH53)/(1+$D$5)^(AH$48-$H$48))","v":0},{"$f":"IF(ISERROR((AI54-AI53)/(1+$D$5)^(AI$48-$H$48)),\"\",-1*(AI54-AI53)/(1+$D$5)^(AI$48-$H$48))","v":0},{"$f":"IF(ISERROR((AJ54-AJ53)/(1+$D$5)^(AJ$48-$H$48)),\"\",-1*(AJ54-AJ53)/(1+$D$5)^(AJ$48-$H$48))","v":""},{"$f":"IF(ISERROR((AK54-AK53)/(1+$D$5)^(AK$48-$H$48)),\"\",-1*(AK54-AK53)/(1+$D$5)^(AK$48-$H$48))","v":""}]
[]
[null,null,"Partner 3",null,"Nominal Cost"]
[null,null,{"$f":"C34","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H58-H57)/(1+$D$5)^(H$48-$H$24)),\"\",-1*(H58-H57)/(1+$D$5)^(H$24-$H$24))","v":0},{"$f":"IF(ISERROR((I58-I57)/(1+$D$5)^(I$48-$H$48)),\"\",-1*(I58-I57)/(1+$D$5)^(I$48-$H$48))","v":0},{"$f":"IF(ISERROR((J58-J57)/(1+$D$5)^(J$48-$H$48)),\"\",-1*(J58-J57)/(1+$D$5)^(J$48-$H$48))","v":0},{"$f":"IF(ISERROR((K58-K57)/(1+$D$5)^(K$48-$H$48)),\"\",-1*(K58-K57)/(1+$D$5)^(K$48-$H$48))","v":0},{"$f":"IF(ISERROR((L58-L57)/(1+$D$5)^(L$48-$H$48)),\"\",-1*(L58-L57)/(1+$D$5)^(L$48-$H$48))","v":0},{"$f":"IF(ISERROR((M58-M57)/(1+$D$5)^(M$48-$H$24)),\"\",-1*(M58-M57)/(1+$D$5)^(M$48-$H$24))","v":0},{"$f":"IF(ISERROR((N58-N57)/(1+$D$5)^(N$48-$H$48)),\"\",-1*(N58-N57)/(1+$D$5)^(N$48-$H$48))","v":0},{"$f":"IF(ISERROR((O58-O57)/(1+$D$5)^(O$48-$H$48)),\"\",-1*(O58-O57)/(1+$D$5)^(O$48-$H$48))","v":0},{"$f":"IF(ISERROR((P58-P57)/(1+$D$5)^(P$48-$H$48)),\"\",-1*(P58-P57)/(1+$D$5)^(P$48-$H$48))","v":0},{"$f":"IF(ISERROR((Q58-Q57)/(1+$D$5)^(Q$48-$H$48)),\"\",-1*(Q58-Q57)/(1+$D$5)^(Q$48-$H$48))","v":0},{"$f":"IF(ISERROR((R58-R57)/(1+$D$5)^(R$48-$H$24)),\"\",-1*(R58-R57)/(1+$D$5)^(R$48-$H$24))","v":0},{"$f":"IF(ISERROR((S58-S57)/(1+$D$5)^(S$48-$H$48)),\"\",-1*(S58-S57)/(1+$D$5)^(S$48-$H$48))","v":0},{"$f":"IF(ISERROR((T58-T57)/(1+$D$5)^(T$48-$H$48)),\"\",-1*(T58-T57)/(1+$D$5)^(T$48-$H$48))","v":0},{"$f":"IF(ISERROR((U58-U57)/(1+$D$5)^(U$48-$H$48)),\"\",-1*(U58-U57)/(1+$D$5)^(U$48-$H$48))","v":0},{"$f":"IF(ISERROR((V58-V57)/(1+$D$5)^(V$48-$H$48)),\"\",-1*(V58-V57)/(1+$D$5)^(V$48-$H$48))","v":0},{"$f":"IF(ISERROR((W58-W57)/(1+$D$5)^(W$48-$H$24)),\"\",-1*(W58-W57)/(1+$D$5)^(W$48-$H$24))","v":0},{"$f":"IF(ISERROR((X58-X57)/(1+$D$5)^(X$48-$H$48)),\"\",-1*(X58-X57)/(1+$D$5)^(X$48-$H$48))","v":0},{"$f":"IF(ISERROR((Y58-Y57)/(1+$D$5)^(Y$48-$H$48)),\"\",-1*(Y58-Y57)/(1+$D$5)^(Y$48-$H$48))","v":0},{"$f":"IF(ISERROR((Z58-Z57)/(1+$D$5)^(Z$48-$H$48)),\"\",-1*(Z58-Z57)/(1+$D$5)^(Z$48-$H$48))","v":0},{"$f":"IF(ISERROR((AA58-AA57)/(1+$D$5)^(AA$48-$H$48)),\"\",-1*(AA58-AA57)/(1+$D$5)^(AA$48-$H$48))","v":0},{"$f":"IF(ISERROR((AB58-AB57)/(1+$D$5)^(AB$48-$H$24)),\"\",-1*(AB58-AB57)/(1+$D$5)^(AB$48-$H$24))","v":0},{"$f":"IF(ISERROR((AC58-AC57)/(1+$D$5)^(AC$48-$H$48)),\"\",-1*(AC58-AC57)/(1+$D$5)^(AC$48-$H$48))","v":0},{"$f":"IF(ISERROR((AD58-AD57)/(1+$D$5)^(AD$48-$H$48)),\"\",-1*(AD58-AD57)/(1+$D$5)^(AD$48-$H$48))","v":0},{"$f":"IF(ISERROR((AE58-AE57)/(1+$D$5)^(AE$48-$H$48)),\"\",-1*(AE58-AE57)/(1+$D$5)^(AE$48-$H$48))","v":0},{"$f":"IF(ISERROR((AF58-AF57)/(1+$D$5)^(AF$48-$H$48)),\"\",-1*(AF58-AF57)/(1+$D$5)^(AF$48-$H$48))","v":0},{"$f":"IF(ISERROR((AG58-AG57)/(1+$D$5)^(AG$48-$H$24)),\"\",-1*(AG58-AG57)/(1+$D$5)^(AG$48-$H$24))","v":0},{"$f":"IF(ISERROR((AH58-AH57)/(1+$D$5)^(AH$48-$H$48)),\"\",-1*(AH58-AH57)/(1+$D$5)^(AH$48-$H$48))","v":0},{"$f":"IF(ISERROR((AI58-AI57)/(1+$D$5)^(AI$48-$H$48)),\"\",-1*(AI58-AI57)/(1+$D$5)^(AI$48-$H$48))","v":0},{"$f":"IF(ISERROR((AJ58-AJ57)/(1+$D$5)^(AJ$48-$H$48)),\"\",-1*(AJ58-AJ57)/(1+$D$5)^(AJ$48-$H$48))","v":""},{"$f":"IF(ISERROR((AK58-AK57)/(1+$D$5)^(AK$48-$H$48)),\"\",-1*(AK58-AK57)/(1+$D$5)^(AK$48-$H$48))","v":""}]
[]
[null,null,"Partner 4",null,"Nominal Cost"]
[null,null,{"$f":"C38","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H62-H61)/(1+$D$5)^(H$48-$H$24)),\"\",-1*(H62-H61)/(1+$D$5)^(H$24-$H$24))","v":0},{"$f":"IF(ISERROR((I62-I61)/(1+$D$5)^(I$48-$H$48)),\"\",-1*(I62-I61)/(1+$D$5)^(I$48-$H$48))","v":0},{"$f":"IF(ISERROR((J62-J61)/(1+$D$5)^(J$48-$H$48)),\"\",-1*(J62-J61)/(1+$D$5)^(J$48-$H$48))","v":0},{"$f":"IF(ISERROR((K62-K61)/(1+$D$5)^(K$48-$H$48)),\"\",-1*(K62-K61)/(1+$D$5)^(K$48-$H$48))","v":0},{"$f":"IF(ISERROR((L62-L61)/(1+$D$5)^(L$48-$H$48)),\"\",-1*(L62-L61)/(1+$D$5)^(L$48-$H$48))","v":0},{"$f":"IF(ISERROR((M62-M61)/(1+$D$5)^(M$48-$H$24)),\"\",-1*(M62-M61)/(1+$D$5)^(M$48-$H$24))","v":0},{"$f":"IF(ISERROR((N62-N61)/(1+$D$5)^(N$48-$H$48)),\"\",-1*(N62-N61)/(1+$D$5)^(N$48-$H$48))","v":0},{"$f":"IF(ISERROR((O62-O61)/(1+$D$5)^(O$48-$H$48)),\"\",-1*(O62-O61)/(1+$D$5)^(O$48-$H$48))","v":0},{"$f":"IF(ISERROR((P62-P61)/(1+$D$5)^(P$48-$H$48)),\"\",-1*(P62-P61)/(1+$D$5)^(P$48-$H$48))","v":0},{"$f":"IF(ISERROR((Q62-Q61)/(1+$D$5)^(Q$48-$H$48)),\"\",-1*(Q62-Q61)/(1+$D$5)^(Q$48-$H$48))","v":0},{"$f":"IF(ISERROR((R62-R61)/(1+$D$5)^(R$48-$H$24)),\"\",-1*(R62-R61)/(1+$D$5)^(R$48-$H$24))","v":0},{"$f":"IF(ISERROR((S62-S61)/(1+$D$5)^(S$48-$H$48)),\"\",-1*(S62-S61)/(1+$D$5)^(S$48-$H$48))","v":0},{"$f":"IF(ISERROR((T62-T61)/(1+$D$5)^(T$48-$H$48)),\"\",-1*(T62-T61)/(1+$D$5)^(T$48-$H$48))","v":0},{"$f":"IF(ISERROR((U62-U61)/(1+$D$5)^(U$48-$H$48)),\"\",-1*(U62-U61)/(1+$D$5)^(U$48-$H$48))","v":0},{"$f":"IF(ISERROR((V62-V61)/(1+$D$5)^(V$48-$H$48)),\"\",-1*(V62-V61)/(1+$D$5)^(V$48-$H$48))","v":0},{"$f":"IF(ISERROR((W62-W61)/(1+$D$5)^(W$48-$H$24)),\"\",-1*(W62-W61)/(1+$D$5)^(W$48-$H$24))","v":0},{"$f":"IF(ISERROR((X62-X61)/(1+$D$5)^(X$48-$H$48)),\"\",-1*(X62-X61)/(1+$D$5)^(X$48-$H$48))","v":0},{"$f":"IF(ISERROR((Y62-Y61)/(1+$D$5)^(Y$48-$H$48)),\"\",-1*(Y62-Y61)/(1+$D$5)^(Y$48-$H$48))","v":0},{"$f":"IF(ISERROR((Z62-Z61)/(1+$D$5)^(Z$48-$H$48)),\"\",-1*(Z62-Z61)/(1+$D$5)^(Z$48-$H$48))","v":0},{"$f":"IF(ISERROR((AA62-AA61)/(1+$D$5)^(AA$48-$H$48)),\"\",-1*(AA62-AA61)/(1+$D$5)^(AA$48-$H$48))","v":0},{"$f":"IF(ISERROR((AB62-AB61)/(1+$D$5)^(AB$48-$H$24)),\"\",-1*(AB62-AB61)/(1+$D$5)^(AB$48-$H$24))","v":0},{"$f":"IF(ISERROR((AC62-AC61)/(1+$D$5)^(AC$48-$H$48)),\"\",-1*(AC62-AC61)/(1+$D$5)^(AC$48-$H$48))","v":0},{"$f":"IF(ISERROR((AD62-AD61)/(1+$D$5)^(AD$48-$H$48)),\"\",-1*(AD62-AD61)/(1+$D$5)^(AD$48-$H$48))","v":0},{"$f":"IF(ISERROR((AE62-AE61)/(1+$D$5)^(AE$48-$H$48)),\"\",-1*(AE62-AE61)/(1+$D$5)^(AE$48-$H$48))","v":0},{"$f":"IF(ISERROR((AF62-AF61)/(1+$D$5)^(AF$48-$H$48)),\"\",-1*(AF62-AF61)/(1+$D$5)^(AF$48-$H$48))","v":0},{"$f":"IF(ISERROR((AG62-AG61)/(1+$D$5)^(AG$48-$H$24)),\"\",-1*(AG62-AG61)/(1+$D$5)^(AG$48-$H$24))","v":0},{"$f":"IF(ISERROR((AH62-AH61)/(1+$D$5)^(AH$48-$H$48)),\"\",-1*(AH62-AH61)/(1+$D$5)^(AH$48-$H$48))","v":0},{"$f":"IF(ISERROR((AI62-AI61)/(1+$D$5)^(AI$48-$H$48)),\"\",-1*(AI62-AI61)/(1+$D$5)^(AI$48-$H$48))","v":0},{"$f":"IF(ISERROR((AJ62-AJ61)/(1+$D$5)^(AJ$48-$H$48)),\"\",-1*(AJ62-AJ61)/(1+$D$5)^(AJ$48-$H$48))","v":""},{"$f":"IF(ISERROR((AK62-AK61)/(1+$D$5)^(AK$48-$H$48)),\"\",-1*(AK62-AK61)/(1+$D$5)^(AK$48-$H$48))","v":""}]
[]
[]
[]
[null,"Scenario 3"]
[null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""}]
[]
[null,"Start Year",null,{"$f":"D22","v":2018}]
[null,"End Year",null,{"$f":"D23","v":2045}]
[null,null,null,null,null,null,null,{"$f":"D70","v":2018},{"$f":"IF(ISERROR(IF(H72+1<=$D$71,H72+1,\"\")),\"\",IF(H72+1<=$D$71,H72+1,\"\"))","v":2019},{"$f":"IF(ISERROR(IF(I72+1<=$D$71,I72+1,\"\")),\"\",IF(I72+1<=$D$71,I72+1,\"\"))","v":2020},2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,"",""]
[null,null,"Partner 1",null,"Nominal Cost"]
[null,null,{"$f":"C26","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H74-H73)/(1+$D$5)^(H$72-$H$72)),\"\",-1*(H74-H73)/(1+$D$5)^(H$72-$H$72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 2",null,"Nominal Cost"]
[null,null,{"$f":"C30","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H78-H77)/(1+$D$5)^(H$72-$H$72)),\"\",-1*(H78-H77)/(1+$D$5)^(H$72-$H$72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 3",null,"Nominal Cost"]
[null,null,{"$f":"C34","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H82-H81)/(1+$D$5)^(H$72-$H$72)),\"\",-1*(H82-H81)/(1+$D$5)^(H$72-$H$72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 4",null,"Nominal Cost"]
[null,null,{"$f":"C38","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H86-H85)/(1+$D$5)^(H$72-$H$72)),\"\",-1*(H86-H85)/(1+$D$5)^(H$72-$H$72))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[]
[]
[null,"Scenario 4"]
[null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[]
[null,"Start Year",null,{"$f":"D22","v":2018}]
[null,"End Year",null,{"$f":"D23","v":2045}]
[null,null,null,null,null,null,null,{"$f":"D94","v":2018},{"$f":"IF(ISERROR(IF(H96+1<=$D$95,H96+1,\"\")),\"\",IF(H96+1<=$D$95,H96+1,\"\"))","v":2019},2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037,2038,2039,2040,2041,2042,2043,2044,2045,"",""]
[null,null,"Partner 1",null,"Nominal Cost"]
[null,null,{"$f":"C26","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H98-H97)/(1+$D$5)^(H$96-$H$96)),\"\",-1*(H98-H97)/(1+$D$5)^(H$96-$H$96))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 2",null,"Nominal Cost"]
[null,null,{"$f":"C30","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H102-H101)/(1+$D$5)^(H$96-$H$96)),\"\",-1*(H102-H101)/(1+$D$5)^(H$96-$H$96))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 3",null,"Nominal Cost"]
[null,null,{"$f":"C34","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H106-H105)/(1+$D$5)^(H$96-$H$96)),\"\",-1*(H106-H105)/(1+$D$5)^(H$96-$H$96))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]
[]
[null,null,"Partner 4",null,"Nominal Cost"]
[null,null,{"$f":"C38","v":""},null,"Nominal Revenue"]
[null,null,null,null,"Present Value of Costs",null,null,{"$f":"IF(ISERROR((H110-H109)/(1+$D$5)^(H$96-$H$96)),\"\",-1*(H110-H109)/(1+$D$5)^(H$96-$H$96))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"",""]

{"sheet":"Step3","index":5,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,5,1,11],[19,1,19,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[7,1,7,3],[1,1,1,2],[6,1,6,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[16,7,16,9],[17,7,17,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9],[15,7,15,9],[7,10,7,11],[8,10,8,11],[9,10,9,11],[10,10,10,11],[11,10,11,11],[11,4,11,5],[12,4,12,5],[13,4,13,5],[6,7,6,9],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[18,10,18,11],[19,10,19,11],[20,10,20,11],[24,1,24,5],[23,7,23,11],[24,7,24,11],[12,10,12,11],[13,10,13,11],[14,10,14,11],[15,10,15,11],[16,10,16,11],[17,10,17,11],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[18,7,18,9],[19,7,19,9],[20,7,20,9],[20,1,20,3],[18,1,18,3],[28,1,28,3],[28,4,28,5],[28,7,28,9],[28,10,28,11],[29,1,29,3],[29,4,29,5],[29,7,29,9],[29,10,29,11],[26,1,26,3],[26,7,26,9],[27,1,27,3],[27,4,27,5],[27,7,27,9],[27,10,27,11],[32,1,32,3],[32,4,32,5],[32,7,32,9],[32,10,32,11],[33,1,33,3],[33,4,33,5],[33,7,33,9],[33,10,33,11],[30,1,30,3],[30,4,30,5],[30,7,30,9],[30,10,30,11],[31,1,31,3],[31,4,31,5],[31,7,31,9],[31,10,31,11],[37,10,37,11],[34,1,34,3],[34,4,34,5],[34,7,34,9],[34,10,34,11],[35,1,35,3],[35,4,35,5],[35,7,35,9],[35,10,35,11],[40,1,40,3],[40,4,40,5],[40,7,40,9],[40,10,40,11],[4,1,4,5],[4,7,4,11],[3,7,3,11],[3,1,3,5],[23,1,23,5],[38,1,38,3],[38,4,38,5],[38,7,38,9],[38,10,38,11],[39,1,39,3],[39,4,39,5],[39,7,39,9],[39,10,39,11],[36,1,36,3],[36,4,36,5],[36,7,36,9],[36,10,36,11],[37,1,37,3],[37,4,37,5],[37,7,37,9]]}
[]
[null,null,null,null,null,"STEP 3 - SELECT CRITERIA"]
[]
[null,"Partner 1",null,null,null,null,null,"Partner 2"]
[null,{"$f":"IF(ISBLANK(Step2!D5),\"\",Step2!D5)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Step2!J5),\"\",Step2!J5)","v":""}]
[]
[null,"Indicator",null,null,"Units",null,null,"Indicator",null,null,"Units"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Partner 3",null,null,null,null,null,"Partner 4"]
[null,{"$f":"IF(ISBLANK(Step2!P5),\"\",Step2!P5)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(Step2!V5),\"\",Step2!V5)","v":""}]
[]
[null,"Indicator",null,null,"Units",null,null,"Indicator",null,null,"Units"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H28,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H29,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H30,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H31,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H32,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H33,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H34,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H35,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H36,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H37,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H38,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H39,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H40,_Criteria!B:C,2,FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(H41,_Criteria!B:C,2,FALSE),\"\")","v":""}]

{"sheet":"Step4","index":6,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":false,"merged":[[7,4,7,11],[9,17,9,18],[27,17,27,18],[45,17,45,18],[63,17,63,18],[12,14,12,15],[13,1,13,3],[13,8,13,9],[13,10,13,11],[13,12,13,13],[13,14,13,15],[12,1,12,3],[12,8,12,9],[12,10,12,11],[17,12,17,13],[17,14,17,15],[16,1,16,3],[16,8,16,9],[12,12,12,13],[16,12,16,13],[21,12,21,13],[21,14,21,15],[20,1,20,3],[17,4,17,7],[1,8,1,15],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[14,1,14,3],[14,8,14,9],[14,10,14,11],[14,12,14,13],[7,1,7,3],[10,14,10,15],[11,1,11,3],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[10,1,10,3],[10,8,10,9],[14,4,14,7],[13,4,13,7],[10,12,10,13],[8,8,9,9],[8,10,9,11],[8,12,9,13],[10,10,10,11],[14,14,14,15],[18,14,18,15],[19,1,19,3],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[18,1,18,3],[18,8,18,9],[18,10,18,11],[18,12,18,13],[16,14,16,15],[17,1,17,3],[17,8,17,9],[17,10,17,11],[15,1,15,3],[20,14,20,15],[21,1,21,3],[15,20,15,21],[15,22,15,23],[16,20,16,21],[16,10,16,11],[21,8,21,9],[21,10,21,11],[16,4,16,7],[18,20,18,21],[18,22,18,23],[19,20,19,21],[19,22,19,23],[20,20,20,21],[20,22,20,23],[16,22,16,23],[17,20,17,21],[17,22,17,23],[12,20,12,21],[12,22,12,23],[13,20,13,21],[13,22,13,23],[14,20,14,21],[14,22,14,23],[9,20,9,21],[9,22,9,23],[10,20,10,21],[10,22,10,23],[11,20,11,21],[11,22,11,23],[31,1,31,3],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[31,20,31,21],[31,22,31,23],[21,20,21,21],[21,22,21,23],[22,20,22,21],[22,22,22,23],[23,20,23,21],[23,22,23,23],[22,14,22,15],[23,1,23,3],[23,8,23,9],[23,10,23,11],[23,12,23,13],[23,14,23,15],[22,1,22,3],[22,8,22,9],[22,10,22,11],[22,12,22,13],[29,12,29,13],[29,14,29,15],[29,20,29,21],[29,22,29,23],[30,1,30,3],[30,8,30,9],[30,10,30,11],[30,12,30,13],[29,1,29,3],[29,8,29,9],[29,10,29,11],[30,14,30,15],[30,20,30,21],[30,22,30,23],[32,1,32,3],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,20,32,21],[32,22,32,23],[33,12,33,13],[34,4,34,7],[33,4,33,7],[34,8,34,9],[34,10,34,11],[32,4,32,7],[33,1,33,3],[33,8,33,9],[33,10,33,11],[33,14,33,15],[33,20,33,21],[35,22,35,23],[37,20,37,21],[37,22,37,23],[33,22,33,23],[34,14,34,15],[34,20,34,21],[34,22,34,23],[35,1,35,3],[35,8,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,15],[34,12,34,13],[34,1,34,3],[35,20,35,21],[41,12,41,13],[41,14,41,15],[41,20,41,21],[39,12,39,13],[39,14,39,15],[38,1,38,3],[38,8,38,9],[38,10,38,11],[38,12,38,13],[38,14,38,15],[38,20,38,21],[41,22,41,23],[39,20,39,21],[39,22,39,23],[40,1,40,3],[40,8,40,9],[40,10,40,11],[40,12,40,13],[40,14,40,15],[36,22,36,23],[37,1,37,3],[37,8,37,9],[37,10,37,11],[37,12,37,13],[37,14,37,15],[38,22,38,23],[39,1,39,3],[39,8,39,9],[39,10,39,11],[36,1,36,3],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[36,20,36,21],[27,20,27,21],[27,22,27,23],[28,1,28,3],[28,8,28,9],[28,10,28,11],[28,12,28,13],[28,14,28,15],[28,20,28,21],[28,22,28,23],[49,1,49,3],[49,8,49,9],[49,10,49,11],[49,12,49,13],[49,14,49,15],[49,20,49,21],[49,22,49,23],[40,20,40,21],[45,22,45,23],[46,1,46,3],[46,8,46,9],[46,10,46,11],[46,12,46,13],[46,14,46,15],[46,20,46,21],[46,22,46,23],[45,20,45,21],[41,4,41,7],[40,4,40,7],[43,1,43,3],[40,22,40,23],[41,1,41,3],[41,8,41,9],[41,10,41,11],[47,14,47,15],[47,20,47,21],[47,22,47,23],[48,1,48,3],[48,8,48,9],[48,10,48,11],[48,12,48,13],[48,14,48,15],[47,1,47,3],[47,8,47,9],[47,10,47,11],[47,12,47,13],[48,20,48,21],[48,22,48,23],[50,1,50,3],[50,8,50,9],[50,10,50,11],[50,12,50,13],[50,14,50,15],[50,20,50,21],[50,22,50,23],[51,12,51,13],[53,1,53,3],[53,8,53,9],[53,10,53,11],[53,12,53,13],[53,14,53,15],[53,20,53,21],[53,22,53,23],[52,22,52,23],[52,4,52,7],[52,1,52,3],[52,8,52,9],[52,10,52,11],[52,12,52,13],[52,14,52,15],[51,1,51,3],[51,8,51,9],[54,1,54,3],[54,8,54,9],[54,10,54,11],[54,12,54,13],[54,14,54,15],[54,20,54,21],[54,22,54,23],[54,4,54,7],[53,4,53,7],[56,1,56,3],[56,8,56,9],[56,10,56,11],[56,12,56,13],[56,14,56,15],[55,1,55,3],[55,8,55,9],[55,10,55,11],[55,12,55,13],[56,4,56,7],[55,4,55,7],[58,1,58,3],[58,8,58,9],[58,10,58,11],[58,12,58,13],[58,14,58,15],[58,20,58,21],[58,22,58,23],[58,4,58,7],[57,4,57,7],[66,1,66,3],[66,8,66,9],[66,10,66,11],[66,12,66,13],[66,14,66,15],[66,20,66,21],[64,14,64,15],[64,20,64,21],[65,1,65,3],[65,8,65,9],[65,10,65,11],[65,12,65,13],[65,14,65,15],[65,20,65,21],[66,4,66,7],[65,4,65,7],[64,4,64,7],[64,1,64,3],[64,8,64,9],[64,10,64,11],[64,12,64,13],[67,1,67,3],[67,8,67,9],[67,10,67,11],[67,12,67,13],[67,14,67,15],[67,20,67,21],[67,22,67,23],[70,1,70,3],[70,8,70,9],[70,10,70,11],[70,12,70,13],[70,14,70,15],[70,20,70,21],[68,14,68,15],[68,20,68,21],[69,1,69,3],[69,8,69,9],[69,10,69,11],[69,12,69,13],[69,14,69,15],[68,1,68,3],[68,12,68,13],[67,4,67,7],[71,1,71,3],[71,8,71,9],[71,10,71,11],[71,12,71,13],[71,4,71,7],[70,4,70,7],[69,4,69,7],[68,4,68,7],[74,1,74,3],[74,8,74,9],[74,10,74,11],[74,12,74,13],[74,14,74,15],[74,20,74,21],[72,14,72,15],[72,20,72,21],[73,1,73,3],[73,8,73,9],[73,10,73,11],[73,12,73,13],[73,14,73,15],[72,1,72,3],[72,8,72,9],[72,10,72,11],[72,12,72,13],[74,4,74,7],[73,4,73,7],[72,4,72,7],[75,1,75,3],[75,8,75,9],[75,10,75,11],[75,12,75,13],[75,14,75,15],[75,20,75,21],[75,22,75,23],[77,1,77,3],[77,8,77,9],[77,10,77,11],[77,12,77,13],[77,14,77,15],[76,1,76,3],[76,8,76,9],[76,10,76,11],[76,12,76,13],[77,20,77,21],[77,22,77,23],[76,14,76,15],[76,20,76,21],[76,22,76,23],[77,4,77,7],[76,4,76,7],[75,4,75,7],[74,22,74,23],[73,20,73,21],[73,22,73,23],[72,22,72,23],[70,22,70,23],[69,20,69,21],[69,22,69,23],[68,22,68,23],[66,22,66,23],[59,20,59,21],[59,22,59,23],[55,14,55,15],[55,20,55,21],[55,22,55,23],[56,20,56,21],[56,22,56,23],[51,14,51,15],[51,20,51,21],[51,22,51,23],[52,20,52,21],[57,14,57,15],[57,20,57,21],[57,22,57,23],[65,22,65,23],[64,22,64,23],[63,20,63,21],[71,14,71,15],[71,20,71,21],[71,22,71,23],[68,8,68,9],[68,10,68,11],[63,22,63,23],[31,4,31,7],[30,4,30,7],[29,4,29,7],[28,4,28,7],[37,4,37,7],[36,4,36,7],[35,4,35,7],[51,10,51,11],[39,4,39,7],[38,4,38,7],[51,4,51,7],[50,4,50,7],[49,4,49,7],[48,4,48,7],[47,4,47,7],[46,4,46,7],[43,4,43,11],[8,14,9,15],[8,4,9,7],[8,1,9,3],[26,1,27,3],[26,4,27,7],[26,8,27,9],[26,10,27,11],[26,12,27,13],[26,14,27,15],[12,4,12,7],[11,4,11,7],[10,4,10,7],[23,4,23,7],[22,4,22,7],[21,4,21,7],[20,4,20,7],[19,4,19,7],[18,4,18,7],[15,4,15,7],[25,4,25,11],[25,1,25,3],[20,8,20,9],[20,10,20,11],[20,12,20,13],[44,1,45,3],[44,4,45,7],[44,8,45,9],[44,10,45,11],[44,12,45,13],[44,14,45,15],[62,1,63,3],[62,4,63,7],[62,8,63,9],[62,10,63,11],[62,12,63,13],[62,14,63,15],[59,14,59,15],[61,1,61,3],[59,1,59,3],[59,8,59,9],[59,10,59,11],[59,12,59,13],[59,4,59,7],[61,4,61,11],[57,1,57,3],[57,8,57,9],[57,10,57,11],[57,12,57,13]]}
[]
[null,null,"Home",null,null,null,null,null,"STEP 4 - ENTER CRITERIA VALUES"]
[]
[]
[]
[]
[]
[null,"Partner 1",null,null,{"$f":"IF(ISBLANK(Step2!D5),\"\",Step2!D5)","v":""}]
[null,"Criteria",null,null,"Units",null,null,null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""},null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""},null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""},null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Better Values Are--",null,null,"What is Poor?",null,"What is Excellent?"]
[null,{"$f":"IF(ISBLANK(Step3!B8),\"\",Step3!B8)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E8),\"\",Step3!E8)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B9),\"\",Step3!B9)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E9),\"\",Step3!E9)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B10),\"\",Step3!B10)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E10),\"\",Step3!E10)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B11),\"\",Step3!B11)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E11),\"\",Step3!E11)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B12),\"\",Step3!B12)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E12),\"\",Step3!E12)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B13),\"\",Step3!B13)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E13),\"\",Step3!E13)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B14),\"\",Step3!B14)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E14),\"\",Step3!E14)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B15),\"\",Step3!B15)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E15),\"\",Step3!E15)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B16),\"\",Step3!B16)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E16),\"\",Step3!E16)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B17),\"\",Step3!B17)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E17),\"\",Step3!E17)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B18),\"\",Step3!B18)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E18),\"\",Step3!E18)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B19),\"\",Step3!B19)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E19),\"\",Step3!E19)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B20),\"\",Step3!B20)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E20),\"\",Step3!E20)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B21),\"\",Step3!B21)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E21),\"\",Step3!E21)","v":""}]
[]
[null,"Partner 2",null,null,{"$f":"IF(ISBLANK(Step2!J5),\"\",Step2!J5)","v":""}]
[null,"Criteria",null,null,"Units",null,null,null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""},null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""},null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""},null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Better Values Are--",null,null,"What is Poor?",null,"What is Excellent?"]
[null,{"$f":"IF(ISBLANK(Step3!H8),\"\",Step3!H8)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K8),\"\",Step3!K8)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H9),\"\",Step3!H9)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K9),\"\",Step3!K9)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H10),\"\",Step3!H10)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K10),\"\",Step3!K10)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H11),\"\",Step3!H11)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K11),\"\",Step3!K11)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H12),\"\",Step3!H12)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K12),\"\",Step3!K12)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H13),\"\",Step3!H13)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K13),\"\",Step3!K13)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H14),\"\",Step3!H14)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K14),\"\",Step3!K14)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H15),\"\",Step3!H15)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K15),\"\",Step3!K15)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H16),\"\",Step3!H16)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K16),\"\",Step3!K16)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H17),\"\",Step3!H17)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K17),\"\",Step3!K17)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H18),\"\",Step3!H18)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K18),\"\",Step3!K18)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H19),\"\",Step3!H19)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K19),\"\",Step3!K19)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H20),\"\",Step3!H20)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K20),\"\",Step3!K20)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H21),\"\",Step3!H21)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K21),\"\",Step3!K21)","v":""}]
[]
[null,"Partner 3",null,null,{"$f":"IF(ISBLANK(Step2!P5),\"\",Step2!P5)","v":""}]
[null,"Criteria",null,null,"Units",null,null,null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""},null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""},null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""},null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Better Values Are--",null,null,"What is Poor?",null,"What is Excellent?"]
[null,{"$f":"IF(ISBLANK(Step3!B28),\"\",Step3!B28)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E28),\"\",Step3!E28)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B29),\"\",Step3!B29)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E29),\"\",Step3!E29)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B30),\"\",Step3!B30)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E30),\"\",Step3!E30)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B31),\"\",Step3!B31)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E31),\"\",Step3!E31)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B32),\"\",Step3!B32)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E32),\"\",Step3!E32)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B33),\"\",Step3!B33)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E33),\"\",Step3!E33)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B34),\"\",Step3!B34)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E34),\"\",Step3!E34)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B35),\"\",Step3!B35)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E35),\"\",Step3!E35)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B36),\"\",Step3!B36)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E36),\"\",Step3!E36)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B37),\"\",Step3!B37)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E37),\"\",Step3!E37)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B38),\"\",Step3!B38)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E38),\"\",Step3!E38)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B39),\"\",Step3!B39)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E39),\"\",Step3!E39)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B40),\"\",Step3!B40)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E40),\"\",Step3!E40)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!B41),\"\",Step3!B41)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!E41),\"\",Step3!E41)","v":""}]
[]
[null,"Partner 4",null,null,{"$f":"IF(ISBLANK(Step2!V5),\"\",Step2!V5)","v":""}]
[null,"Criteria",null,null,"Units",null,null,null,{"$f":"IF(ISBLANK(Step1!H7),\"\",Step1!H7)","v":""},null,{"$f":"IF(ISBLANK(Step1!H18),\"\",Step1!H18)","v":""},null,{"$f":"IF(ISBLANK(Step1!H29),\"\",Step1!H29)","v":""},null,{"$f":"IF(ISBLANK(Step1!H40),\"\",Step1!H40)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Better Values Are--",null,null,"What is Poor",null,"What is Excellent?"]
[null,{"$f":"IF(ISBLANK(Step3!H28),\"\",Step3!H28)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K28),\"\",Step3!K28)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H29),\"\",Step3!H29)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K29),\"\",Step3!K29)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H30),\"\",Step3!H30)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K30),\"\",Step3!K30)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H31),\"\",Step3!H31)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K31),\"\",Step3!K31)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H32),\"\",Step3!H32)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K32),\"\",Step3!K32)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H33),\"\",Step3!H33)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K33),\"\",Step3!K33)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H34),\"\",Step3!H34)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K34),\"\",Step3!K34)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H35),\"\",Step3!H35)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K35),\"\",Step3!K35)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H36),\"\",Step3!H36)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K36),\"\",Step3!K36)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H37),\"\",Step3!H37)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K37),\"\",Step3!K37)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H38),\"\",Step3!H38)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K38),\"\",Step3!K38)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H39),\"\",Step3!H39)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K39),\"\",Step3!K39)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H40),\"\",Step3!H40)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K40),\"\",Step3!K40)","v":""}]
[null,{"$f":"IF(ISBLANK(Step3!H41),\"\",Step3!H41)","v":""},null,null,{"$f":"IF(ISBLANK(Step3!K41),\"\",Step3!K41)","v":""}]

{"sheet":"Step5","index":7,"n_rows":89,"n_cols":17,"rows_kept":89,"cut":false,"hidden":false,"merged":[[73,11,74,12],[73,9,74,10],[73,7,74,8],[73,5,74,6],[73,2,74,4],[7,2,7,4],[7,5,7,12],[9,5,9,12],[13,2,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[12,2,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[10,11,11,12],[10,2,11,4],[10,5,11,6],[10,7,11,8],[10,9,11,10],[15,2,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[14,2,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[17,2,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[16,2,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[19,2,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[18,2,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[21,2,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[20,2,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[23,2,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[22,2,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[28,2,28,4],[28,5,28,12],[25,2,25,4],[26,2,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[24,2,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[40,2,40,4],[41,2,41,4],[33,2,33,4],[34,2,34,4],[35,2,35,4],[31,2,32,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[30,5,30,12],[31,11,32,12],[31,9,32,10],[31,7,32,8],[31,5,32,6],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,2,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[45,2,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[46,2,46,4],[57,2,57,4],[58,2,58,4],[59,2,59,4],[60,2,60,4],[61,2,61,4],[62,2,62,4],[49,2,49,4],[49,5,49,12],[54,2,54,4],[55,2,55,4],[56,2,56,4],[52,11,53,12],[52,9,53,10],[52,7,53,8],[52,5,53,6],[52,2,53,4],[72,5,72,12],[1,5,1,12],[88,2,88,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[85,2,85,4],[86,2,86,4],[87,2,87,4],[76,2,76,4],[77,2,77,4],[78,2,78,4],[79,2,79,4],[80,2,80,4],[81,2,81,4],[51,5,51,12],[70,2,70,4],[70,5,70,12],[75,2,75,4],[63,2,63,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[67,2,67,4]]}
[]
[null,null,null,null,null,"STEP 5 - WEIGHT CRITERIA BY IMPORTANCE"]
[]
[]
[]
[]
[]
[null,null,"Partner 1",null,null,{"$f":"IF(ISBLANK(Step2!D5),\"\",Step2!D5)","v":""}]
[]
[null,null,null,null,null,"How important is each criteria to the partner?"]
[null,null,"Criteria",null,null,"Somewhat Important",null,"Important",null,"Very Important",null,"Extremely Important",null,null,null,null,"Weight"]
[]
[null,null,{"$f":"IF(ISBLANK(Step3!B8),\"\",Step3!B8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B9),\"\",Step3!B9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B10),\"\",Step3!B10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B11),\"\",Step3!B11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B12),\"\",Step3!B12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B13),\"\",Step3!B13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B14),\"\",Step3!B14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B15),\"\",Step3!B15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B16),\"\",Step3!B16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B17),\"\",Step3!B17)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B18),\"\",Step3!B18)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B19),\"\",Step3!B19)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B20),\"\",Step3!B20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B21),\"\",Step3!B21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B21),\"\",Step3!B21)","v":""}]
[]
[null,null,"Partner 2",null,null,{"$f":"IF(ISBLANK(Step2!J5),\"\",Step2!J5)","v":""}]
[]
[null,null,null,null,null,"How important is each criteria to the partner?"]
[null,null,"Criteria",null,null,"Somewhat Important",null,"Important",null,"Very Important",null,"Extremely Important",null,null,null,null,"Weight"]
[]
[null,null,{"$f":"IF(ISBLANK(Step3!H8),\"\",Step3!H8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H9),\"\",Step3!H9)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H10),\"\",Step3!H10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H11),\"\",Step3!H11)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H12),\"\",Step3!H12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H13),\"\",Step3!H13)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H14),\"\",Step3!H14)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H15),\"\",Step3!H15)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H16),\"\",Step3!H16)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H17),\"\",Step3!H17)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H18),\"\",Step3!H18)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H19),\"\",Step3!H19)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H20),\"\",Step3!H20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H22),\"\",Step3!H22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,"Partner 3",null,null,{"$f":"IF(ISBLANK(Step2!P5),\"\",Step2!P5)","v":""}]
[]
[null,null,null,null,null,"How important is each criteria to the partner?"]
[null,null,"Criteria",null,null,"Somewhat Important",null,"Important",null,"Very Important",null,"Extremely Important"]
[]
[null,null,{"$f":"IF(ISBLANK(Step3!B28),\"\",Step3!B28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B29),\"\",Step3!B29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B30),\"\",Step3!B30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B31),\"\",Step3!B31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B32),\"\",Step3!B32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B33),\"\",Step3!B33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B34),\"\",Step3!B34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B35),\"\",Step3!B35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B36),\"\",Step3!B36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B37),\"\",Step3!B37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B38),\"\",Step3!B38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B39),\"\",Step3!B39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B40),\"\",Step3!B40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!B41),\"\",Step3!B41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,"Partner 4",null,null,{"$f":"IF(ISBLANK(Step2!V5),\"\",Step2!V5)","v":""}]
[]
[null,null,null,null,null,"How important is each criteria to the partner?"]
[null,null,"Criteria",null,null,"Somewhat Important",null,"Important",null,"Very Important",null,"Extremely Important"]
[]
[null,null,{"$f":"IF(ISBLANK(Step3!H28),\"\",Step3!H28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H29),\"\",Step3!H29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H30),\"\",Step3!H30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H31),\"\",Step3!H31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H32),\"\",Step3!H32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H33),\"\",Step3!H33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H34),\"\",Step3!H34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H35),\"\",Step3!H35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H36),\"\",Step3!H36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H37),\"\",Step3!H37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H38),\"\",Step3!H38)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H39),\"\",Step3!H39)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H40),\"\",Step3!H40)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,{"$f":"IF(ISBLANK(Step3!H41),\"\",Step3!H41)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Step6","index":8,"n_rows":108,"n_cols":25,"rows_kept":108,"cut":false,"hidden":false,"merged":[[11,1,11,2],[8,16,10,17],[11,16,13,17],[8,20,10,21],[11,20,13,21],[14,20,16,21],[17,20,19,21],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,16,20,17],[14,3,16,4],[2,5,3,8],[2,17,3,20],[5,11,7,12],[8,11,10,12],[11,11,13,12],[14,11,16,12],[17,11,19,12],[29,2,29,4],[17,1,17,2],[17,16,19,17],[14,16,16,17],[11,3,13,4],[28,2,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[26,2,26,4],[26,5,26,12],[20,1,20,2],[20,3,20,4],[20,5,20,6],[20,18,20,19],[20,20,20,21],[30,2,30,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[29,11,29,12],[20,22,20,23],[8,22,10,23],[14,5,16,6],[14,7,16,8],[14,9,16,10],[11,9,13,10],[11,7,13,8],[11,5,13,6],[8,5,10,6],[8,7,10,8],[8,9,10,10],[14,22,16,23],[11,22,13,23],[11,18,13,19],[8,18,10,19],[17,18,19,19],[14,18,16,19],[8,3,10,4],[14,1,14,2],[1,6,1,16],[41,2,41,4],[42,2,42,4],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,7,35,8],[37,5,37,6],[38,5,38,6],[39,5,39,6],[42,7,42,8],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[39,2,39,4],[40,2,40,4],[40,5,40,6],[41,5,41,6],[42,5,42,6],[29,5,29,6],[30,11,30,12],[31,11,31,12],[32,11,32,12],[33,11,33,12],[33,9,33,10],[34,5,34,6],[35,5,35,6],[36,5,36,6],[34,9,34,10],[35,9,35,10],[36,9,36,10],[30,5,30,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[36,7,36,8],[37,7,37,8],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[34,11,34,12],[35,11,35,12],[36,11,36,12],[37,11,37,12],[34,2,34,4],[38,11,38,12],[39,11,39,12],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[38,7,38,8],[39,7,39,8],[37,9,37,10],[49,2,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,5,43,6],[44,5,44,6],[43,7,43,8],[44,7,44,8],[43,9,43,10],[44,9,44,10],[43,11,43,12],[47,2,47,4],[47,5,47,12],[42,9,42,10],[44,2,44,4],[44,11,44,12],[43,2,43,4],[40,7,40,8],[41,7,41,8],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[52,2,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[53,2,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[54,2,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[55,2,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[56,2,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[57,2,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[58,2,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[59,2,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[60,2,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[61,2,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[62,2,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[63,2,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[68,2,68,4],[68,5,68,12],[70,2,70,4],[70,5,70,6],[70,7,70,8],[70,9,70,10],[70,11,70,12],[64,2,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[65,2,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[71,2,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[72,2,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,11,72,12],[73,2,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[74,2,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[75,2,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[76,2,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[77,2,77,4],[77,5,77,6],[77,7,77,8],[77,9,77,10],[77,11,77,12],[78,2,78,4],[78,5,78,6],[78,7,78,8],[78,9,78,10],[78,11,78,12],[79,2,79,4],[79,5,79,6],[79,7,79,8],[79,9,79,10],[79,11,79,12],[80,2,80,4],[80,5,80,6],[80,7,80,8],[80,9,80,10],[80,11,80,12],[81,2,81,4],[81,5,81,6],[81,7,81,8],[81,9,81,10],[81,11,81,12],[82,2,82,4],[82,5,82,6],[82,7,82,8],[82,9,82,10],[82,11,82,12],[85,9,85,10],[85,11,85,12],[86,2,86,4],[86,5,86,6],[86,7,86,8],[86,9,86,10],[86,11,86,12],[83,2,83,4],[83,5,83,6],[83,7,83,8],[83,9,83,10],[83,11,83,12],[84,2,84,4],[84,5,84,6],[84,7,84,8],[84,9,84,10],[84,11,84,12],[92,11,92,12],[93,2,93,4],[93,5,93,6],[93,7,93,8],[93,9,93,10],[93,11,93,12],[89,2,89,4],[89,5,89,12],[91,2,91,4],[91,5,91,6],[91,7,91,8],[91,9,91,10],[91,11,91,12],[96,11,96,12],[97,2,97,4],[97,5,97,6],[97,7,97,8],[97,9,97,10],[97,11,97,12],[94,2,94,4],[94,5,94,6],[94,7,94,8],[94,9,94,10],[94,11,94,12],[95,2,95,4],[95,5,95,6],[95,7,95,8],[95,9,95,10],[95,11,95,12],[100,11,100,12],[101,2,101,4],[101,5,101,6],[101,7,101,8],[101,9,101,10],[101,11,101,12],[98,2,98,4],[98,5,98,6],[98,7,98,8],[98,9,98,10],[98,11,98,12],[99,2,99,4],[99,5,99,6],[99,7,99,8],[99,9,99,10],[99,11,99,12],[102,9,102,10],[102,11,102,12],[103,2,103,4],[103,5,103,6],[103,7,103,8],[103,9,103,10],[103,11,103,12],[107,2,107,4],[107,5,107,6],[107,7,107,8],[107,9,107,10],[107,11,107,12],[104,2,104,4],[104,5,104,6],[104,7,104,8],[104,9,104,10],[104,11,104,12],[105,2,105,4],[105,5,105,6],[105,7,105,8],[105,9,105,10],[105,11,105,12],[106,11,106,12],[5,7,5,8],[5,9,5,10],[106,2,106,4],[106,5,106,6],[106,7,106,8],[106,9,106,10],[100,2,100,4],[100,5,100,6],[100,7,100,8],[100,9,100,10],[96,2,96,4],[96,5,96,6],[96,7,96,8],[96,9,96,10],[92,2,92,4],[92,5,92,6],[92,7,92,8],[92,9,92,10],[85,2,85,4],[85,5,85,6],[85,7,85,8],[102,2,102,4],[102,5,102,6],[102,7,102,8],[5,18,5,19],[5,16,5,17],[17,22,19,23],[5,20,5,21],[5,22,5,23],[8,1,8,2],[6,9,7,10],[6,7,7,8],[6,5,7,6],[6,3,7,4],[6,16,7,17],[6,18,7,19],[6,20,7,21],[6,22,7,23],[17,9,19,10],[17,7,19,8],[17,5,19,6],[18,1,19,2],[15,1,16,2],[12,1,13,2],[9,1,10,2],[17,3,19,4],[5,3,5,4],[5,5,5,6],[21,16,21,17],[21,18,21,19],[21,20,21,21],[21,22,21,23],[8,13,8,15],[9,13,10,15],[11,13,11,15],[12,13,13,15],[15,13,16,15],[14,13,14,15],[21,13,21,15],[20,13,20,15],[18,13,19,15],[17,13,17,15]]}
[]
[null,null,"Home",null,null,null,"STEP 6 - RESULTS"]
[null,null,null,null,null,"Summary Benefits",null,null,null,null,{"$f":"IF(OR(ISERROR(C8), ISERROR(C11),ISERROR(C14),AND(ISERROR(C17),A18<>0)),\"Error: Did you fill out all the steps and tabs, including the importance weighting for each criteria? (step 5)\",\"\")","v":""},null,null,null,null,null,null,"Summary Costs"]
[]
[]
[null,null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4",null,null,null,null,null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,null,{"$f":"IF(Step1!H7=0,\"\",Step1!H7)","v":""},null,{"$f":"IF(Step1!H18=0,\"\",Step1!H18)","v":""},null,{"$f":"IF(Step1!H29=0,\"\",Step1!H29)","v":""},null,{"$f":"IF(Step1!H40=0,\"\",Step1!H40)","v":""},null,null,null,null,null,null,{"$f":"D7","v":""},null,{"$f":"F7","v":""},null,{"$f":"H7","v":""},null,{"$f":"J7","v":""}]
[]
[null,"Partner 1",null,{"$f":"IF(OR(B10=\"\",D7=\"\"),\"\",_3sum!R9)","v":""},null,{"$f":"IF(OR(B10=\"\",F7=\"\"),\"\",_3sum!S9)","v":""},null,{"$f":"IF(OR(B10=\"\",H7=\"\"),\"\",_3sum!T9)","v":""},null,{"$f":"IF(OR(B10=\"\",J7=\"\"),\"\",_3sum!U9)","v":""},null,null,null,"Partner 1",null,null,{"$f":"IF(OR(N10=\"\",Q7=\"\"),\"\",Step2!D14)","v":""},null,{"$f":"IF(OR(N10=\"\",S7=\"\"),\"\",(Step2!D22))","v":""},null,{"$f":"IF(OR(N10=\"\",U7=\"\"),\"\",(Step2!D30))","v":""},null,{"$f":"IF(OR(N10=\"\",W7=\"\"),\"\",(Step2!D38))","v":""}]
[null,{"$f":"Step2!D5","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B10","v":0}]
[]
[null,"Partner 2",null,{"$f":"IF(OR(B13=\"\",D7=\"\"),\"\",_3sum!R10)","v":""},null,{"$f":"IF(OR(B13=\"\",F7=\"\"),\"\",_3sum!S10)","v":""},null,{"$f":"IF(OR(B13=\"\",H7=\"\"),\"\",_3sum!T10)","v":""},null,{"$f":"IF(OR(B13=\"\",J7=\"\"),\"\",_3sum!U10)","v":""},null,null,null,"Partner 2",null,null,{"$f":"IF(OR(N13=\"\",Q7=\"\"),\"\",(Step2!J14))","v":""},null,{"$f":"IF(OR(N13=\"\",S7=\"\"),\"\",(Step2!J22))","v":""},null,{"$f":"IF(OR(N13=\"\",U7=\"\"),\"\",(Step2!J30))","v":""},null,{"$f":"IF(OR(N13=\"\",W7=\"\"),\"\",(Step2!J38))","v":""}]
[null,{"$f":"IF(Step2!J5=0,\"\",Step2!J5)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":""}]
[]
[null,"Partner 3",null,{"$f":"IF(OR(B16=\"\",D7=\"\"),\"\",_3sum!R11)","v":""},null,{"$f":"IF(OR(B16=\"\",F7=\"\"),\"\",_3sum!S11)","v":""},null,{"$f":"IF(OR(B16=\"\",H7=\"\"),\"\",_3sum!T11)","v":""},null,{"$f":"IF(OR(B16=\"\",J7=\"\"),\"\",_3sum!U11)","v":""},null,null,null,"Partner 3",null,null,{"$f":"IF(OR(N16=\"\",Q7=\"\"),\"\",(Step2!P14))","v":""},null,{"$f":"IF(OR(N16=\"\",S7=\"\"),\"\",(Step2!P22))","v":""},null,{"$f":"IF(OR(N16=\"\",U7=\"\"),\"\",(Step2!P30))","v":""},null,{"$f":"IF(OR(N16=\"\",W7=\"\"),\"\",(Step2!P38))","v":""}]
[null,{"$f":"IF(Step2!P5=0,\"\",Step2!P5)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B16","v":""}]
[]
[null,"Partner 4",null,{"$f":"IF(OR(B19=\"\",D7=\"\"),\"\",_3sum!R12)","v":""},null,{"$f":"IF(OR(B19=\"\",F7=\"\"),\"\",_3sum!S12)","v":""},null,{"$f":"IF(OR(B19=\"\",H7=\"\"),\"\",_3sum!T12)","v":""},null,{"$f":"IF(OR(B19=\"\",J7=\"\"),\"\",_3sum!U12)","v":""},null,null,null,"Partner 4",null,null,{"$f":"IF(OR(N19=\"\",Q7=\"\"),\"\",(Step2!V14))","v":""},null,{"$f":"IF(OR(N19=\"\",S7=\"\"),\"\",(Step2!V22))","v":""},null,{"$f":"IF(OR(N19=\"\",U7=\"\"),\"\",(Step2!V30))","v":""},null,{"$f":"IF(OR(N19=\"\", W7=\"\"),\"\",(Step2!V38))","v":""}]
[null,{"$f":"IF(Step2!V5=0,\"\",Step2!V5)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B19","v":""}]
[]
[null,"Average of Partners",null,{"$f":"IF(D7=\"\",\"\",AVERAGE(D9:E20))","v":""},null,{"$f":"IF(F7=\"\",\"\",AVERAGE(F9:G20))","v":""},null,{"$f":"IF(H7=\"\",\"\",AVERAGE(H9:I20))","v":""},null,{"$f":"IF(J7=\"\",\"\",AVERAGE(J9:K20))","v":""},null,{"$f":"MAX(D21:K21)","v":0},null,"Total Cost",null,null,{"$f":"IF(Q7=\"\",\"\",SUM(Q9:R20))","v":""},null,{"$f":"IF(S7=\"\",\"\",SUM(S9:T20))","v":""},null,{"$f":"IF(U7=\"\",\"\",SUM(U9:V20))","v":""},null,{"$f":"IF(W7=\"\",\"\",SUM(W9:X20))","v":""},null,{"$f":"MIN(Q21:X21)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Equivalent Annual Annuity",null,null,{"$f":"Step2C!K13","v":""},null,{"$f":"Step2C!M13","v":""},null,{"$f":"Step2C!O13","v":""},null,{"$f":"Step2C!Q13","v":""}]
[]
[]
[]
[]
[null,null,"Partner 1",null,null,{"$f":"IF(ISBLANK(Step5!F8),\"\",Step5!F8)","v":""}]
[]
[null,null,"Improvement by Criteria",null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,{"$f":"IF(ISBLANK(Step3!B8),\"\",Step3!B8)","v":""},null,null,{"$f":"IFERROR(_2weight!J7,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K7,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L7,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M7,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B9),\"\",Step3!B9)","v":""},null,null,{"$f":"IFERROR(_2weight!J8,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K8,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L8,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M8,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B10),\"\",Step3!B10)","v":""},null,null,{"$f":"IFERROR(_2weight!J9,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K9,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L9,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M9,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B11),\"\",Step3!B11)","v":""},null,null,{"$f":"IFERROR(_2weight!J10,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K10,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L10,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M10,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B12),\"\",Step3!B12)","v":""},null,null,{"$f":"IFERROR(_2weight!J11,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K11,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L11,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M11,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B13),\"\",Step3!B13)","v":""},null,null,{"$f":"IFERROR(_2weight!J12,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K12,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L12,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M12,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B14),\"\",Step3!B14)","v":""},null,null,{"$f":"IFERROR(_2weight!J13,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K13,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L13,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M13,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B15),\"\",Step3!B15)","v":""},null,null,{"$f":"IFERROR(_2weight!J14,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K14,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L14,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M14,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B16),\"\",Step3!B16)","v":""},null,null,{"$f":"IFERROR(_2weight!J15,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K15,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L15,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M15,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B17),\"\",Step3!B17)","v":""},null,null,{"$f":"IFERROR(_2weight!J16,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K16,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L16,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M16,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B18),\"\",Step3!B18)","v":""},null,null,{"$f":"IFERROR(_2weight!J17,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K17,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L17,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M17,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B19),\"\",Step3!B19)","v":""},null,null,{"$f":"IFERROR(_2weight!J18,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K18,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L18,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M18,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B20),\"\",Step3!B20)","v":""},null,null,{"$f":"IFERROR(_2weight!J19,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K19,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L19,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M19,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B21),\"\",Step3!B21)","v":""},null,null,{"$f":"IFERROR(_2weight!J20,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K20,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L20,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M20,\"\")","v":""}]
[null,null,"Overall Benefit",null,null,{"$f":"IFERROR(D9,\"\")","v":""},null,{"$f":"F9","v":""},null,{"$f":"H9","v":""},null,{"$f":"J9","v":""}]
[null,null,"Overall Cost",null,null,{"$f":"Step2!D16+Step2!D14","v":0},null,{"$f":"Step2!D22+Step2!D24","v":0},null,{"$f":"Step2!D30+Step2!D32","v":0},null,{"$f":"Step2!D38+Step2!D40","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Partner 2",null,null,{"$f":"Step5!F29","v":""}]
[]
[null,null,"Improvement by Criteria",null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,{"$f":"IF(ISBLANK(Step3!H8),\"\",Step3!H8)","v":""},null,null,{"$f":"IFERROR(_2weight!J21,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K21,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L21,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M21,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H9),\"\",Step3!H9)","v":""},null,null,{"$f":"IFERROR(_2weight!J22,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K22,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L22,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M22,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H10),\"\",Step3!H10)","v":""},null,null,{"$f":"IFERROR(_2weight!J23,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K23,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L23,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M23,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H11),\"\",Step3!H11)","v":""},null,null,{"$f":"IFERROR(_2weight!J24,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K24,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L24,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M24,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H12),\"\",Step3!H12)","v":""},null,null,{"$f":"IFERROR(_2weight!J25,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K25,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L25,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M25,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H13),\"\",Step3!H13)","v":""},null,null,{"$f":"IFERROR(_2weight!J26,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K26,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L26,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M26,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H14),\"\",Step3!H14)","v":""},null,null,{"$f":"IFERROR(_2weight!J27,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K27,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L27,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M27,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H15),\"\",Step3!H15)","v":""},null,null,{"$f":"IFERROR(_2weight!J28,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K28,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L28,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M28,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H16),\"\",Step3!H16)","v":""},null,null,{"$f":"IFERROR(_2weight!J29,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K29,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L29,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M29,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H17),\"\",Step3!H17)","v":""},null,null,{"$f":"IFERROR(_2weight!J30,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K30,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L30,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M30,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H18),\"\",Step3!H18)","v":""},null,null,{"$f":"IFERROR(_2weight!J31,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K31,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L31,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M31,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H19),\"\",Step3!H19)","v":""},null,null,{"$f":"IFERROR(_2weight!J32,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K32,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L32,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M32,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H20),\"\",Step3!H20)","v":""},null,null,{"$f":"IFERROR(_2weight!J33,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K33,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L33,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M33,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H21),\"\",Step3!H21)","v":""},null,null,{"$f":"IFERROR(_2weight!J34,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K34,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L34,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M34,\"\")","v":""}]
[null,null,"Overall Benefit",null,null,{"$f":"D12","v":""},null,{"$f":"F12","v":""},null,{"$f":"H12","v":""},null,{"$f":"J12","v":""}]
[null,null,"Overall Cost",null,null,{"$f":"Step2!J14+Step2!J16","v":0},null,{"$f":"Step2!J22+Step2!J24","v":0},null,{"$f":"Step2!J30+Step2!J32","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!J38+Step2!J40","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Partner 3",null,null,{"$f":"Step5!F50","v":""}]
[]
[null,null,"Improvement by Criteria",null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,{"$f":"IF(ISBLANK(Step3!B28),\"\",Step3!B28)","v":""},null,null,{"$f":"IFERROR(_2weight!J35,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K35,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L35,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M35,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B29),\"\",Step3!B29)","v":""},null,null,{"$f":"IFERROR(_2weight!J36,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K36,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L36,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M36,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B30),\"\",Step3!B30)","v":""},null,null,{"$f":"IFERROR(_2weight!J37,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K37,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L37,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M37,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B31),\"\",Step3!B31)","v":""},null,null,{"$f":"IFERROR(_2weight!J38,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K38,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L38,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M38,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B32),\"\",Step3!B32)","v":""},null,null,{"$f":"IFERROR(_2weight!J39,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K39,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L39,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M39,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B33),\"\",Step3!B33)","v":""},null,null,{"$f":"IFERROR(_2weight!J40,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K40,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L40,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M40,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B34),\"\",Step3!B34)","v":""},null,null,{"$f":"IFERROR(_2weight!J41,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K41,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L41,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M41,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B35),\"\",Step3!B35)","v":""},null,null,{"$f":"IFERROR(_2weight!J42,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K42,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L42,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M42,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B36),\"\",Step3!B36)","v":""},null,null,{"$f":"IFERROR(_2weight!J43,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K43,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L43,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M43,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B37),\"\",Step3!B37)","v":""},null,null,{"$f":"IFERROR(_2weight!J44,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K44,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L44,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M44,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B38),\"\",Step3!B38)","v":""},null,null,{"$f":"IFERROR(_2weight!J45,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K45,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L45,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M45,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B39),\"\",Step3!B39)","v":""},null,null,{"$f":"IFERROR(_2weight!J46,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K46,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L46,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M46,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B40),\"\",Step3!B40)","v":""},null,null,{"$f":"IFERROR(_2weight!J47,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K47,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L47,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M47,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!B41),\"\",Step3!B41)","v":""},null,null,{"$f":"IFERROR(_2weight!J48,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K48,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L48,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M48,\"\")","v":""}]
[null,null,"Overall Benefit",null,null,{"$f":"D15","v":""},null,{"$f":"F15","v":""},null,{"$f":"H15","v":""},null,{"$f":"J15","v":""}]
[null,null,"Overall Cost",null,null,{"$f":"Step2!P14+Step2!P16","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!P22+Step2!P24","v":0},null,{"$f":"Step2!P30+Step2!P32","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!P38+Step2!P40","v":{"$error":"#VALUE!"}}]
[]
[]
[null,null,"Partner 4",null,null,{"$f":"Step5!F71","v":""}]
[]
[null,null,"Improvement by Criteria",null,null,"Scenario 1",null,"Scenario 2",null,"Scenario 3",null,"Scenario 4"]
[null,null,{"$f":"IF(ISBLANK(Step3!H28),\"\",Step3!H28)","v":""},null,null,{"$f":"IFERROR(_2weight!J49,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K49,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L49,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M49,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H29),\"\",Step3!H29)","v":""},null,null,{"$f":"IFERROR(_2weight!J50,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K50,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L50,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M50,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H30),\"\",Step3!G30)","v":""},null,null,{"$f":"IFERROR(_2weight!J51,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K51,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L51,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M51,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H31),\"\",Step3!G31)","v":""},null,null,{"$f":"IFERROR(_2weight!J52,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K52,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L52,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M52,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H32),\"\",Step3!G32)","v":""},null,null,{"$f":"IFERROR(_2weight!J53,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K53,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L53,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M53,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H33),\"\",Step3!G33)","v":""},null,null,{"$f":"IFERROR(_2weight!J54,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K54,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L54,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M54,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H34),\"\",Step3!G34)","v":""},null,null,{"$f":"IFERROR(_2weight!J55,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K55,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L55,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M55,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H35),\"\",Step3!G35)","v":""},null,null,{"$f":"IFERROR(_2weight!J56,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K56,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L56,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M56,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H36),\"\",Step3!G36)","v":""},null,null,{"$f":"IFERROR(_2weight!J57,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K57,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L57,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M57,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H37),\"\",Step3!G37)","v":""},null,null,{"$f":"IFERROR(_2weight!J58,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K58,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L58,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M58,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H38),\"\",Step3!G38)","v":""},null,null,{"$f":"IFERROR(_2weight!J59,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K59,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L59,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M59,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H39),\"\",Step3!G39)","v":""},null,null,{"$f":"IFERROR(_2weight!J60,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K60,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L60,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M60,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H40),\"\",Step3!G40)","v":""},null,null,{"$f":"IFERROR(_2weight!J61,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K61,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L61,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M61,\"\")","v":""}]
[null,null,{"$f":"IF(ISBLANK(Step3!H41),\"\",Step3!G41)","v":""},null,null,{"$f":"IFERROR(_2weight!J62,\"\")","v":""},null,{"$f":"IFERROR(_2weight!K62,\"\")","v":""},null,{"$f":"IFERROR(_2weight!L62,\"\")","v":""},null,{"$f":"IFERROR(_2weight!M62,\"\")","v":""}]
[null,null,"Overall Benefit",null,null,{"$f":"D18","v":""},null,{"$f":"F18","v":""},null,{"$f":"H18","v":""},null,{"$f":"J18","v":""}]
[null,null,"Overall Cost",null,null,{"$f":"Step2!V14+Step2!V16","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!V22+Step2!V24","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!V30+Step2!V32","v":{"$error":"#VALUE!"}},null,{"$f":"Step2!V38+Step2!V40","v":{"$error":"#VALUE!"}}]

{"sheet":"Step6_Charts","index":9,"n_rows":201,"n_cols":24,"rows_kept":201,"cut":false,"hidden":false,"merged":[[1,5,1,16],[45,9,45,17],[94,2,94,3],[94,6,94,7],[94,10,94,11],[94,14,94,15],[3,5,3,8],[101,9,101,17],[141,7,141,19],[4,5,5,10],[121,3,121,10],[121,16,121,23],[103,3,103,10],[103,16,103,23],[6,5,7,10],[6,11,7,12],[4,11,5,12]]}
[]
[null,null,"Home",null,null,"STEP 6 - CHARTS"]
[]
[null,null,null,null,null,"Table of Figures"]
[null,null,null,null,null,"Distribution of Benefits and Costs - All Partners and Scenarios",null,null,null,null,null,"Bar Chart"]
[]
[null,null,null,null,null,"Distribution of Benefits and Costs - All Partners and Scenarios",null,null,null,null,null,"Pie Chart"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4",null,null,null,null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
[null,null,{"$f":"Step6!D7","v":""},{"$f":"IF(Step6!F7=0,\"\",Step6!F7)","v":""},{"$f":"IF(Step6!H7=0,\"\",Step6!H7)","v":""},{"$f":"IF(Step6!J7=0,\"\",Step6!J7)","v":""},null,null,null,null,null,{"$f":"Step6!Q7","v":""},{"$f":"IF(Step6!S7=0,\"\",Step6!S7)","v":""},{"$f":"IF(Step6!U7=0,\"\",Step6!U7)","v":""},{"$f":"IF(Step6!W7=0,\"\",Step6!W7)","v":""}]
[null,{"$f":"Step6!B10","v":0},{"$f":"Step6!D9","v":""},{"$f":"Step6!F9","v":""},{"$f":"Step6!H9","v":""},{"$f":"Step6!J9","v":""},null,null,null,null,{"$f":"Step6!N10","v":0},{"$f":"Step6!Q9","v":""},{"$f":"Step6!S9","v":""},{"$f":"Step6!U9","v":""},{"$f":"Step6!W9","v":""}]
[null,{"$f":"IF(Step6!B13=0,\"\",Step6!B13)","v":""},{"$f":"Step6!D12","v":""},{"$f":"Step6!F12","v":""},{"$f":"Step6!H12","v":""},{"$f":"S6P1On","v":""},null,null,null,null,{"$f":"IF(Step6!N13=0,\"\",Step6!N13)","v":""},{"$f":"Step6!Q12","v":""},{"$f":"Step6!S12","v":""},{"$f":"Step6!U12","v":""},{"$f":"Step6!W12","v":""}]
[null,{"$f":"IF(Step6!B16=0,\"\",Step6!B16)","v":""},{"$f":"Step6!D15","v":""},{"$f":"Step6!F15","v":""},{"$f":"Step6!H15","v":""},{"$f":"Step6!J15","v":""},null,null,null,null,{"$f":"IF(Step6!N16=0,\"\",Step6!N16)","v":""},{"$f":"Step6!Q15","v":""},{"$f":"Step6!S15","v":""},{"$f":"Step6!U15","v":""},{"$f":"Step6!W15","v":""}]
[null,{"$f":"IF(Step6!B19=0,\"\",Step6!B19)","v":""},{"$f":"Step6!D18","v":""},{"$f":"Step6!F18","v":""},{"$f":"Step6!H18","v":""},{"$f":"Step6!J18","v":""},null,null,null,null,{"$f":"IF(Step6!N19=0,\"\",Step6!N19)","v":""},{"$f":"Step6!Q18","v":""},{"$f":"Step6!S18","v":""},{"$f":"Step6!U18","v":""},{"$f":"Step6!W18","v":""}]
[null,null,null,null,null,null,null,null,null,"Distribution of Benefits and Costs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C40","v":"Scenario 1"},"Scenario 2","Scenario 3","Scenario 4",null,null,null,null,null,{"$f":"L40","v":"Scenario 1"},"Scenario 2","Scenario 3","Scenario 4"]
[null,null,{"$f":"C41","v":""},"","","",null,null,null,null,null,{"$f":"L41","v":""},"","",""]
[null,{"$f":"B42","v":0},"","","","",null,null,null,null,{"$f":"K42","v":0},"",{"$f":"M42","v":""},"",""]
[null,{"$f":"B43","v":""},"","","","",null,null,null,null,{"$f":"K43","v":""},"","","",""]
[null,{"$f":"B44","v":""},"","","","",null,null,null,null,{"$f":"K44","v":""},"","","",""]
[null,{"$f":"B45","v":""},"","","","",null,null,null,null,{"$f":"K45","v":""},"","","",""]
[]
[null,null,{"$f":"C89","v":""},null,null,null,{"$f":"D89","v":""},null,null,null,{"$f":"E89","v":""},null,null,null,{"$f":"F89","v":""}]
[null,null,"Benefits","Costs","Costs",null,"Benefits","Costs","Costs",null,"Benefits","Costs","Costs",null,"Benefits","Costs","Costs"]
[null,{"$f":"B90","v":0},{"$f":"C90/SUM($C$90:$C$93)","v":{"$error":"#VALUE!"}},{"$f":"L90","v":""},{"$f":"D97/SUM(D$97:D$100)","v":{"$error":"#VALUE!"}},{"$f":"B90","v":0},{"$f":"D90/SUM($D$90:$D$93)","v":{"$error":"#VALUE!"}},{"$f":"M90","v":""},{"$f":"H97/SUM(H$97:H$100)","v":{"$error":"#VALUE!"}},{"$f":"B90","v":0},{"$f":"E90/SUM($E$90:$E$93)","v":{"$error":"#VALUE!"}},{"$f":"N90","v":""},{"$f":"L97/SUM(L$97:L$100)","v":{"$error":"#VALUE!"}},{"$f":"B90","v":0},{"$f":"F90/SUM($F$90:$F$93)","v":{"$error":"#VALUE!"}},{"$f":"O90","v":""},{"$f":"P97/SUM(P$97:P$100)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B91","v":""},{"$f":"C91/SUM($C$90:$C$93)","v":{"$error":"#VALUE!"}},{"$f":"L91","v":""},{"$f":"D98/SUM(D$97:D$100)","v":{"$error":"#VALUE!"}},{"$f":"B91","v":""},{"$f":"D91/SUM($D$90:$D$93)","v":{"$error":"#VALUE!"}},{"$f":"M91","v":""},{"$f":"H98/SUM(H$97:H$100)","v":{"$error":"#VALUE!"}},{"$f":"B91","v":""},{"$f":"E91/SUM($E$90:$E$93)","v":{"$error":"#VALUE!"}},{"$f":"N91","v":""},{"$f":"L98/SUM(L$97:L$100)","v":{"$error":"#VALUE!"}},{"$f":"B91","v":""},{"$f":"F91/SUM($F$90:$F$93)","v":{"$error":"#VALUE!"}},{"$f":"O91","v":""},{"$f":"P98/SUM(P$97:P$100)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B92","v":""},{"$f":"C92/SUM($C$90:$C$93)","v":{"$error":"#VALUE!"}},"",{"$f":"D99/SUM(D$97:D$100)","v":{"$error":"#VALUE!"}},"",{"$f":"D92/SUM($D$90:$D$93)","v":{"$error":"#VALUE!"}},"",{"$f":"H99/SUM(H$97:H$100)","v":{"$error":"#VALUE!"}},"",{"$f":"E92/SUM($E$90:$E$93)","v":{"$error":"#VALUE!"}},"",{"$f":"L99/SUM(L$97:L$100)","v":{"$error":"#VALUE!"}},"",{"$f":"F92/SUM($F$90:$F$93)","v":{"$error":"#VALUE!"}},"",{"$f":"P99/SUM(P$97:P$100)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"B93","v":""},{"$f":"C93/SUM($C$90:$C$93)","v":{"$error":"#VALUE!"}},"",{"$f":"D100/SUM(D$97:D$100)","v":{"$error":"#VALUE!"}},"",{"$f":"D93/SUM($D$90:$D$93)","v":{"$error":"#VALUE!"}},"",{"$f":"H100/SUM(H$97:H$100)","v":{"$error":"#VALUE!"}},"",{"$f":"E93/SUM($E$90:$E$93)","v":{"$error":"#VALUE!"}},"",{"$f":"L100/SUM(L$97:L$100)","v":{"$error":"#VALUE!"}},"",{"$f":"F93/SUM($F$90:$F$93)","v":{"$error":"#VALUE!"}},"",{"$f":"P100/SUM(P$97:P$100)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,"Distribution of Benefits and Costs"]
[]
[null,null,null,{"$f":"C95","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G95","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"K95","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O95","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Comparison between Costs Borne and Benefits Received by Each Partner"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Partner 1",{"$f":"Step6!F27","v":""},null,null,null,null,"Partner 2",null,null,null,null,null,"Partner 3",null,null,null,null,null,"Partner 3"]
[null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4",null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4",null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4",null,null,"Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
[null,"Improvement by Criteria",{"$f":"Step6!D7","v":""},{"$f":"Step6!F7","v":""},{"$f":"Step6!H7","v":""},{"$f":"Step6!J7","v":""},null,"Improvement by Criteria",{"$f":"C187","v":""},{"$f":"D187","v":""},"","",null,"Improvement by Criteria",{"$f":"C187","v":""},{"$f":"D187","v":""},"","",null,"Improvement by Criteria",{"$f":"C187","v":""},{"$f":"D187","v":""},"",""]
[null,{"$f":"Step6!C30","v":""},{"$f":"IF(Step6!F30=\"\",\"\",Step6!F30)","v":""},{"$f":"IF(Step6!H30=\"\",\"\",Step6!H30)","v":""},{"$f":"IF(Step6!J30=\"\",\"\",Step6!J30)","v":""},{"$f":"IF(Step6!L30=\"\", \"\",Step6!L30)","v":""},null,{"$f":"Step6!C51","v":""},{"$f":"IF(Step6!F51=\"\",\"\",Step6!F51)","v":""},{"$f":"IF(Step6!H51=\"\",\"\",Step6!H51)","v":""},{"$f":"IF(Step6!J51=\"\",\"\",Step6!J51)","v":""},{"$f":"IF(Step6!L51=\"\", \"\",Step6!L51)","v":""},null,{"$f":"Step6!C72","v":""},{"$f":"IF(Step6!F72=\"\",\"\",Step6!F72)","v":""},{"$f":"IF(Step6!H72=\"\",\"\",Step6!H72)","v":""},{"$f":"IF(Step6!J72=\"\",\"\",Step6!J72)","v":""},{"$f":"IF(Step6!L72=\"\", \"\",Step6!L72)","v":""},null,{"$f":"Step6!U30","v":0},{"$f":"IF(Step6!X30=\"\",\"\",Step6!X30)","v":""},{"$f":"IF(Step6!Z30=\"\",\"\",Step6!Z30)","v":""},{"$f":"IF(Step6!AB30=\"\",\"\",Step6!AB30)","v":""},{"$f":"IF(Step6!AD30=\"\", \"\",Step6!AD30)","v":""}]
[null,{"$f":"Step6!C31","v":""},{"$f":"IF(Step6!F31=\"\",\"\",Step6!F31)","v":""},{"$f":"IF(Step6!H31=\"\",\"\",Step6!H31)","v":""},{"$f":"IF(Step6!J31=\"\",\"\",Step6!J31)","v":""},{"$f":"IF(Step6!L31=\"\", \"\",Step6!L31)","v":""},null,{"$f":"Step6!C52","v":""},{"$f":"IF(Step6!F52=\"\",\"\",Step6!F52)","v":""},{"$f":"IF(Step6!H52=\"\",\"\",Step6!H52)","v":""},{"$f":"IF(Step6!J52=\"\",\"\",Step6!J52)","v":""},{"$f":"IF(Step6!L52=\"\", \"\",Step6!L52)","v":""},null,{"$f":"Step6!C73","v":""},{"$f":"IF(Step6!F73=\"\",\"\",Step6!F73)","v":""},{"$f":"IF(Step6!H73=\"\",\"\",Step6!H73)","v":""},{"$f":"IF(Step6!J73=\"\",\"\",Step6!J73)","v":""},{"$f":"IF(Step6!L73=\"\", \"\",Step6!L73)","v":""},null,{"$f":"Step6!U31","v":0},{"$f":"IF(Step6!X31=\"\",\"\",Step6!X31)","v":""},{"$f":"IF(Step6!Z31=\"\",\"\",Step6!Z31)","v":""},{"$f":"IF(Step6!AB31=\"\",\"\",Step6!AB31)","v":""},{"$f":"IF(Step6!AD31=\"\", \"\",Step6!AD31)","v":""}]
[null,{"$f":"Step6!C32","v":""},{"$f":"IF(Step6!F32=\"\",\"\",Step6!F32)","v":""},{"$f":"IF(Step6!H32=\"\",\"\",Step6!H32)","v":""},{"$f":"IF(Step6!J32=\"\",\"\",Step6!J32)","v":""},{"$f":"IF(Step6!L32=\"\", \"\",Step6!L32)","v":""},null,{"$f":"Step6!C53","v":""},{"$f":"IF(Step6!F53=\"\",\"\",Step6!F53)","v":""},{"$f":"IF(Step6!H53=\"\",\"\",Step6!H53)","v":""},{"$f":"IF(Step6!J53=\"\",\"\",Step6!J53)","v":""},{"$f":"IF(Step6!L53=\"\", \"\",Step6!L53)","v":""},null,{"$f":"Step6!C74","v":""},{"$f":"IF(Step6!F74=\"\",\"\",Step6!F74)","v":""},{"$f":"IF(Step6!H74=\"\",\"\",Step6!H74)","v":""},{"$f":"IF(Step6!J74=\"\",\"\",Step6!J74)","v":""},{"$f":"IF(Step6!L74=\"\", \"\",Step6!L74)","v":""},null,{"$f":"Step6!U32","v":0},{"$f":"IF(Step6!X32=\"\",\"\",Step6!X32)","v":""},{"$f":"IF(Step6!Z32=\"\",\"\",Step6!Z32)","v":""},{"$f":"IF(Step6!AB32=\"\",\"\",Step6!AB32)","v":""},{"$f":"IF(Step6!AD32=\"\", \"\",Step6!AD32)","v":""}]
[null,{"$f":"Step6!C33","v":""},{"$f":"IF(Step6!F33=\"\",\"\",Step6!F33)","v":""},{"$f":"IF(Step6!H33=\"\",\"\",Step6!H33)","v":""},{"$f":"IF(Step6!J33=\"\",\"\",Step6!J33)","v":""},{"$f":"IF(Step6!L33=\"\", \"\",Step6!L33)","v":""},null,{"$f":"Step6!C54","v":""},{"$f":"IF(Step6!F54=\"\",\"\",Step6!F54)","v":""},{"$f":"IF(Step6!H54=\"\",\"\",Step6!H54)","v":""},{"$f":"IF(Step6!J54=\"\",\"\",Step6!J54)","v":""},{"$f":"IF(Step6!L54=\"\", \"\",Step6!L54)","v":""},null,{"$f":"Step6!C75","v":""},{"$f":"IF(Step6!F75=\"\",\"\",Step6!F75)","v":""},{"$f":"IF(Step6!H75=\"\",\"\",Step6!H75)","v":""},{"$f":"IF(Step6!J75=\"\",\"\",Step6!J75)","v":""},{"$f":"IF(Step6!L75=\"\", \"\",Step6!L75)","v":""},null,{"$f":"Step6!U33","v":0},{"$f":"IF(Step6!X33=\"\",\"\",Step6!X33)","v":""},{"$f":"IF(Step6!Z33=\"\",\"\",Step6!Z33)","v":""},{"$f":"IF(Step6!AB33=\"\",\"\",Step6!AB33)","v":""},{"$f":"IF(Step6!AD33=\"\", \"\",Step6!AD33)","v":""}]
[null,{"$f":"Step6!C34","v":""},{"$f":"IF(Step6!F34=\"\",\"\",Step6!F34)","v":""},{"$f":"IF(Step6!H34=\"\",\"\",Step6!H34)","v":""},{"$f":"IF(Step6!J34=\"\",\"\",Step6!J34)","v":""},{"$f":"IF(Step6!L34=\"\", \"\",Step6!L34)","v":""},null,{"$f":"Step6!C55","v":""},{"$f":"IF(Step6!F55=\"\",\"\",Step6!F55)","v":""},{"$f":"IF(Step6!H55=\"\",\"\",Step6!H55)","v":""},{"$f":"IF(Step6!J55=\"\",\"\",Step6!J55)","v":""},{"$f":"IF(Step6!L55=\"\", \"\",Step6!L55)","v":""},null,{"$f":"Step6!C76","v":""},{"$f":"IF(Step6!F76=\"\",\"\",Step6!F76)","v":""},{"$f":"IF(Step6!H76=\"\",\"\",Step6!H76)","v":""},{"$f":"IF(Step6!J76=\"\",\"\",Step6!J76)","v":""},{"$f":"IF(Step6!L76=\"\", \"\",Step6!L76)","v":""},null,{"$f":"Step6!U34","v":0},{"$f":"IF(Step6!X34=\"\",\"\",Step6!X34)","v":""},{"$f":"IF(Step6!Z34=\"\",\"\",Step6!Z34)","v":""},{"$f":"IF(Step6!AB34=\"\",\"\",Step6!AB34)","v":""},{"$f":"IF(Step6!AD34=\"\", \"\",Step6!AD34)","v":""}]
[null,{"$f":"Step6!C35","v":""},{"$f":"IF(Step6!F35=\"\",\"\",Step6!F35)","v":""},{"$f":"IF(Step6!H35=\"\",\"\",Step6!H35)","v":""},{"$f":"IF(Step6!J35=\"\",\"\",Step6!J35)","v":""},{"$f":"IF(Step6!L35=\"\", \"\",Step6!L35)","v":""},null,{"$f":"Step6!C56","v":""},{"$f":"IF(Step6!F56=\"\",\"\",Step6!F56)","v":""},{"$f":"IF(Step6!H56=\"\",\"\",Step6!H56)","v":""},{"$f":"IF(Step6!J56=\"\",\"\",Step6!J56)","v":""},{"$f":"IF(Step6!L56=\"\", \"\",Step6!L56)","v":""},null,{"$f":"Step6!C77","v":""},{"$f":"IF(Step6!F77=\"\",\"\",Step6!F77)","v":""},{"$f":"IF(Step6!H77=\"\",\"\",Step6!H77)","v":""},{"$f":"IF(Step6!J77=\"\",\"\",Step6!J77)","v":""},{"$f":"IF(Step6!L77=\"\", \"\",Step6!L77)","v":""},null,{"$f":"Step6!U35","v":0},{"$f":"IF(Step6!X35=\"\",\"\",Step6!X35)","v":""},{"$f":"IF(Step6!Z35=\"\",\"\",Step6!Z35)","v":""},{"$f":"IF(Step6!AB35=\"\",\"\",Step6!AB35)","v":""},{"$f":"IF(Step6!AD35=\"\", \"\",Step6!AD35)","v":""}]
[null,{"$f":"Step6!C36","v":""},{"$f":"IF(Step6!F36=\"\",\"\",Step6!F36)","v":""},{"$f":"IF(Step6!H36=\"\",\"\",Step6!H36)","v":""},{"$f":"IF(Step6!J36=\"\",\"\",Step6!J36)","v":""},{"$f":"IF(Step6!L36=\"\", \"\",Step6!L36)","v":""},null,{"$f":"Step6!C57","v":""},{"$f":"IF(Step6!F57=\"\",\"\",Step6!F57)","v":""},{"$f":"IF(Step6!H57=\"\",\"\",Step6!H57)","v":""},{"$f":"IF(Step6!J57=\"\",\"\",Step6!J57)","v":""},{"$f":"IF(Step6!L57=\"\", \"\",Step6!L57)","v":""},null,{"$f":"Step6!C78","v":""},{"$f":"IF(Step6!F78=\"\",\"\",Step6!F78)","v":""},{"$f":"IF(Step6!H78=\"\",\"\",Step6!H78)","v":""},{"$f":"IF(Step6!J78=\"\",\"\",Step6!J78)","v":""},{"$f":"IF(Step6!L78=\"\", \"\",Step6!L78)","v":""},null,{"$f":"Step6!U36","v":0},{"$f":"IF(Step6!X36=\"\",\"\",Step6!X36)","v":""},{"$f":"IF(Step6!Z36=\"\",\"\",Step6!Z36)","v":""},{"$f":"IF(Step6!AB36=\"\",\"\",Step6!AB36)","v":""},{"$f":"IF(Step6!AD36=\"\", \"\",Step6!AD36)","v":""}]
[null,{"$f":"Step6!C37","v":""},{"$f":"IF(Step6!F37=\"\",\"\",Step6!F37)","v":""},{"$f":"IF(Step6!H37=\"\",\"\",Step6!H37)","v":""},{"$f":"IF(Step6!J37=\"\",\"\",Step6!J37)","v":""},{"$f":"IF(Step6!L37=\"\", \"\",Step6!L37)","v":""},null,{"$f":"Step6!C58","v":""},{"$f":"IF(Step6!F58=\"\",\"\",Step6!F58)","v":""},{"$f":"IF(Step6!H58=\"\",\"\",Step6!H58)","v":""},{"$f":"IF(Step6!J58=\"\",\"\",Step6!J58)","v":""},{"$f":"IF(Step6!L58=\"\", \"\",Step6!L58)","v":""},null,{"$f":"Step6!C79","v":""},{"$f":"IF(Step6!F79=\"\",\"\",Step6!F79)","v":""},{"$f":"IF(Step6!H79=\"\",\"\",Step6!H79)","v":""},{"$f":"IF(Step6!J79=\"\",\"\",Step6!J79)","v":""},{"$f":"IF(Step6!L79=\"\", \"\",Step6!L79)","v":""},null,{"$f":"Step6!U37","v":0},{"$f":"IF(Step6!X37=\"\",\"\",Step6!X37)","v":""},{"$f":"IF(Step6!Z37=\"\",\"\",Step6!Z37)","v":""},{"$f":"IF(Step6!AB37=\"\",\"\",Step6!AB37)","v":""},{"$f":"IF(Step6!AD37=\"\", \"\",Step6!AD37)","v":""}]
[null,{"$f":"Step6!C38","v":""},{"$f":"IF(Step6!F38=\"\",\"\",Step6!F38)","v":""},{"$f":"IF(Step6!H38=\"\",\"\",Step6!H38)","v":""},{"$f":"IF(Step6!J38=\"\",\"\",Step6!J38)","v":""},{"$f":"IF(Step6!L38=\"\", \"\",Step6!L38)","v":""},null,{"$f":"Step6!C59","v":""},{"$f":"IF(Step6!F59=\"\",\"\",Step6!F59)","v":""},{"$f":"IF(Step6!H59=\"\",\"\",Step6!H59)","v":""},{"$f":"IF(Step6!J59=\"\",\"\",Step6!J59)","v":""},{"$f":"IF(Step6!L59=\"\", \"\",Step6!L59)","v":""},null,{"$f":"Step6!C80","v":""},{"$f":"IF(Step6!F80=\"\",\"\",Step6!F80)","v":""},{"$f":"IF(Step6!H80=\"\",\"\",Step6!H80)","v":""},{"$f":"IF(Step6!J80=\"\",\"\",Step6!J80)","v":""},{"$f":"IF(Step6!L80=\"\", \"\",Step6!L80)","v":""},null,{"$f":"Step6!U38","v":0},{"$f":"IF(Step6!X38=\"\",\"\",Step6!X38)","v":""},{"$f":"IF(Step6!Z38=\"\",\"\",Step6!Z38)","v":""},{"$f":"IF(Step6!AB38=\"\",\"\",Step6!AB38)","v":""},{"$f":"IF(Step6!AD38=\"\", \"\",Step6!AD38)","v":""}]
[null,{"$f":"Step6!C39","v":""},{"$f":"IF(Step6!F39=\"\",\"\",Step6!F39)","v":""},{"$f":"IF(Step6!H39=\"\",\"\",Step6!H39)","v":""},{"$f":"IF(Step6!J39=\"\",\"\",Step6!J39)","v":""},{"$f":"IF(Step6!L39=\"\", \"\",Step6!L39)","v":""},null,{"$f":"Step6!C60","v":""},{"$f":"IF(Step6!F60=\"\",\"\",Step6!F60)","v":""},{"$f":"IF(Step6!H60=\"\",\"\",Step6!H60)","v":""},{"$f":"IF(Step6!J60=\"\",\"\",Step6!J60)","v":""},{"$f":"IF(Step6!L60=\"\", \"\",Step6!L60)","v":""},null,{"$f":"Step6!C81","v":""},{"$f":"IF(Step6!F81=\"\",\"\",Step6!F81)","v":""},{"$f":"IF(Step6!H81=\"\",\"\",Step6!H81)","v":""},{"$f":"IF(Step6!J81=\"\",\"\",Step6!J81)","v":""},{"$f":"IF(Step6!L81=\"\", \"\",Step6!L81)","v":""},null,{"$f":"Step6!U39","v":0},{"$f":"IF(Step6!X39=\"\",\"\",Step6!X39)","v":""},{"$f":"IF(Step6!Z39=\"\",\"\",Step6!Z39)","v":""},{"$f":"IF(Step6!AB39=\"\",\"\",Step6!AB39)","v":""},{"$f":"IF(Step6!AD39=\"\", \"\",Step6!AD39)","v":""}]
[null,{"$f":"Step6!C40","v":""},{"$f":"IF(Step6!F40=\"\",\"\",Step6!F40)","v":""},{"$f":"IF(Step6!H40=\"\",\"\",Step6!H40)","v":""},{"$f":"IF(Step6!J40=\"\",\"\",Step6!J40)","v":""},{"$f":"IF(Step6!L40=\"\", \"\",Step6!L40)","v":""},null,{"$f":"Step6!C61","v":""},{"$f":"IF(Step6!F61=\"\",\"\",Step6!F61)","v":""},{"$f":"IF(Step6!H61=\"\",\"\",Step6!H61)","v":""},{"$f":"IF(Step6!J61=\"\",\"\",Step6!J61)","v":""},{"$f":"IF(Step6!L61=\"\", \"\",Step6!L61)","v":""},null,{"$f":"Step6!C82","v":""},{"$f":"IF(Step6!F82=\"\",\"\",Step6!F82)","v":""},{"$f":"IF(Step6!H82=\"\",\"\",Step6!H82)","v":""},{"$f":"IF(Step6!J82=\"\",\"\",Step6!J82)","v":""},{"$f":"IF(Step6!L82=\"\", \"\",Step6!L82)","v":""},null,{"$f":"Step6!U40","v":0},{"$f":"IF(Step6!X40=\"\",\"\",Step6!X40)","v":""},{"$f":"IF(Step6!Z40=\"\",\"\",Step6!Z40)","v":""},{"$f":"IF(Step6!AB40=\"\",\"\",Step6!AB40)","v":""},{"$f":"IF(Step6!AD40=\"\", \"\",Step6!AD40)","v":""}]
[null,{"$f":"Step6!C41","v":""},{"$f":"IF(Step6!F41=\"\",\"\",Step6!F41)","v":""},{"$f":"IF(Step6!H41=\"\",\"\",Step6!H41)","v":""},{"$f":"IF(Step6!J41=\"\",\"\",Step6!J41)","v":""},{"$f":"IF(Step6!L41=\"\", \"\",Step6!L41)","v":""},null,{"$f":"Step6!C62","v":""},{"$f":"IF(Step6!F62=\"\",\"\",Step6!F62)","v":""},{"$f":"IF(Step6!H62=\"\",\"\",Step6!H62)","v":""},{"$f":"IF(Step6!J62=\"\",\"\",Step6!J62)","v":""},{"$f":"IF(Step6!L62=\"\", \"\",Step6!L62)","v":""},null,{"$f":"Step6!C83","v":""},{"$f":"IF(Step6!F83=\"\",\"\",Step6!F83)","v":""},{"$f":"IF(Step6!H83=\"\",\"\",Step6!H83)","v":""},{"$f":"IF(Step6!J83=\"\",\"\",Step6!J83)","v":""},{"$f":"IF(Step6!L83=\"\", \"\",Step6!L83)","v":""},null,{"$f":"Step6!U41","v":0},{"$f":"IF(Step6!X41=\"\",\"\",Step6!X41)","v":""},{"$f":"IF(Step6!Z41=\"\",\"\",Step6!Z41)","v":""},{"$f":"IF(Step6!AB41=\"\",\"\",Step6!AB41)","v":""},{"$f":"IF(Step6!AD41=\"\", \"\",Step6!AD41)","v":""}]
[null,{"$f":"Step6!C42","v":""},{"$f":"IF(Step6!F42=\"\",\"\",Step6!F42)","v":""},{"$f":"IF(Step6!H42=\"\",\"\",Step6!H42)","v":""},{"$f":"IF(Step6!J42=\"\",\"\",Step6!J42)","v":""},{"$f":"IF(Step6!L42=\"\", \"\",Step6!L42)","v":""},null,{"$f":"Step6!C63","v":""},{"$f":"IF(Step6!F63=\"\",\"\",Step6!F63)","v":""},{"$f":"IF(Step6!H63=\"\",\"\",Step6!H63)","v":""},{"$f":"IF(Step6!J63=\"\",\"\",Step6!J63)","v":""},{"$f":"IF(Step6!L63=\"\", \"\",Step6!L63)","v":""},null,{"$f":"Step6!C84","v":""},{"$f":"IF(Step6!F84=\"\",\"\",Step6!F84)","v":""},{"$f":"IF(Step6!H84=\"\",\"\",Step6!H84)","v":""},{"$f":"IF(Step6!J84=\"\",\"\",Step6!J84)","v":""},{"$f":"IF(Step6!L84=\"\", \"\",Step6!L84)","v":""},null,{"$f":"Step6!U42","v":0},{"$f":"IF(Step6!X42=\"\",\"\",Step6!X42)","v":""},{"$f":"IF(Step6!Z42=\"\",\"\",Step6!Z42)","v":""},{"$f":"IF(Step6!AB42=\"\",\"\",Step6!AB42)","v":""},{"$f":"IF(Step6!AD42=\"\", \"\",Step6!AD42)","v":""}]
[null,{"$f":"Step6!C43","v":""},{"$f":"IF(Step6!F43=\"\",\"\",Step6!F43)","v":""},{"$f":"IF(Step6!H43=\"\",\"\",Step6!H43)","v":""},{"$f":"IF(Step6!J43=\"\",\"\",Step6!J43)","v":""},{"$f":"IF(Step6!L43=\"\", \"\",Step6!L43)","v":""},null,{"$f":"Step6!C64","v":""},{"$f":"IF(Step6!F64=\"\",\"\",Step6!F64)","v":""},{"$f":"IF(Step6!H64=\"\",\"\",Step6!H64)","v":""},{"$f":"IF(Step6!J64=\"\",\"\",Step6!J64)","v":""},{"$f":"IF(Step6!L64=\"\", \"\",Step6!L64)","v":""},null,{"$f":"Step6!C85","v":""},{"$f":"IF(Step6!F85=\"\",\"\",Step6!F85)","v":""},{"$f":"IF(Step6!H85=\"\",\"\",Step6!H85)","v":""},{"$f":"IF(Step6!J85=\"\",\"\",Step6!J85)","v":""},{"$f":"IF(Step6!L85=\"\", \"\",Step6!L85)","v":""},null,{"$f":"Step6!U43","v":0},{"$f":"IF(Step6!X43=\"\",\"\",Step6!X43)","v":""},{"$f":"IF(Step6!Z43=\"\",\"\",Step6!Z43)","v":""},{"$f":"IF(Step6!AB43=\"\",\"\",Step6!AB43)","v":""},{"$f":"IF(Step6!AD43=\"\", \"\",Step6!AD43)","v":""}]

{"sheet":"_parameters","index":10,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Inflation",0.02]
["Discount rate",7.0000000000000007E-2]

{"sheet":"_maintcosts","index":11,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":true,"merged":[[1,1,1,16]]}
[]
[null,"This can be repeated for each scenario.  It is intended to calculate NPV for maintenance costs for each partner and scenario.  It will need to modify the number of years based on the forecast horizon."]
[]
[null,"Scenario 1"]
[null,"Year",{"$f":"Step1!H8","v":0},{"$f":"C5+1","v":1},{"$f":"D5+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14]
[null,"Inflated annual maintenance, p1",{"$f":"Step2!D15","v":0},{"$f":"$C6*(1+_parameters!B3)^(_maintcosts!D$5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!C3)^(_maintcosts!E5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!D3)^(_maintcosts!F5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!E3)^(_maintcosts!G5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!F3)^(_maintcosts!H5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!G3)^(_maintcosts!I5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!H3)^(_maintcosts!J5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!I3)^(_maintcosts!K5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!J3)^(_maintcosts!L5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!K3)^(_maintcosts!M5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!L3)^(_maintcosts!N5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!M3)^(_maintcosts!O5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!N3)^(_maintcosts!P5-_maintcosts!$C$5)","v":0},{"$f":"$C$6*(1+_parameters!O3)^(_maintcosts!Q5-_maintcosts!$C$5)","v":0}]
[null,"Inflated annual maintenance, p2",{"$f":"Step2!J15","v":0},{"$f":"$C7*(1+_parameters!B4)^(_maintcosts!D$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!C4)^(_maintcosts!E$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!D4)^(_maintcosts!F$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!E4)^(_maintcosts!G$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!F4)^(_maintcosts!H$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!G4)^(_maintcosts!I$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!H4)^(_maintcosts!J$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!I4)^(_maintcosts!K$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!J4)^(_maintcosts!L$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!K4)^(_maintcosts!M$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!L4)^(_maintcosts!N$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!M4)^(_maintcosts!O$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!N4)^(_maintcosts!P$5-_maintcosts!$C$5)","v":0},{"$f":"$C7*(1+_parameters!O4)^(_maintcosts!Q$5-_maintcosts!$C$5)","v":0}]
[null,"Inflated annual maintenance, p3",{"$f":"Step2!P15","v":0},{"$f":"$C8*(1+_parameters!B5)^(_maintcosts!D$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!C5)^(_maintcosts!E$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!D5)^(_maintcosts!F$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!E5)^(_maintcosts!G$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!F5)^(_maintcosts!H$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!G5)^(_maintcosts!I$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!H5)^(_maintcosts!J$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!I5)^(_maintcosts!K$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!J5)^(_maintcosts!L$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!K5)^(_maintcosts!M$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!L5)^(_maintcosts!N$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!M5)^(_maintcosts!O$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!N5)^(_maintcosts!P$5-_maintcosts!$C$5)","v":0},{"$f":"$C8*(1+_parameters!O5)^(_maintcosts!Q$5-_maintcosts!$C$5)","v":0}]
[null,"Inflated annual maintenance, p4",{"$f":"Step2!V15","v":0},{"$f":"$C9*(1+_parameters!B6)^(_maintcosts!D$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!C6)^(_maintcosts!E$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!D6)^(_maintcosts!F$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!E6)^(_maintcosts!G$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!F6)^(_maintcosts!H$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!G6)^(_maintcosts!I$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!H6)^(_maintcosts!J$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!I6)^(_maintcosts!K$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!J6)^(_maintcosts!L$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!K6)^(_maintcosts!M$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!L6)^(_maintcosts!N$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!M6)^(_maintcosts!O$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!N6)^(_maintcosts!P$5-_maintcosts!$C$5)","v":0},{"$f":"$C9*(1+_parameters!O6)^(_maintcosts!Q$5-_maintcosts!$C$5)","v":0}]

{"sheet":"_1normal","index":12,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":true,"merged":[[3,10,3,14],[3,2,3,6],[0,0,0,4],[3,15,3,19]]}
["Normalization of Criteria"]
[]
[]
[null,null,"Unnormalized",null,null,null,null,null,null,null,"Partially Normalized Vars",null,null,null,null,"Normalized Vars"]
["Partner","Criteria","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Poor","Excellent","Difference","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
["P1",{"$f":"Step4!B11","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B8),\"\",Step4!I11)","v":""},{"$f":"IF(ISBLANK(Step3!$B8),\"\",Step4!K11)","v":""},{"$f":"IF(ISBLANK(Step3!$B8),\"\",Step4!M11)","v":""},{"$f":"IF(ISBLANK(Step3!$B8),\"\",Step4!O11)","v":""},{"$f":"Step4!U11","v":0},{"$f":"Step4!W11","v":0},{"$f":"I6-H6","v":0},{"$f":"IF(OR(ABS($H6-C6)>ABS($I6-$H6),ABS($I6-C6)>ABS($I6-$H6)),IF(ABS($I6-C6)>ABS($H6-C6),0,1),(C6-$H6)/($I6-$H6))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ABS($H6-D6)>ABS($I6-$H6),ABS($I6-D6)>ABS($I6-$H6)),IF(ABS($I6-D6)>ABS($H6-D6),0,1),(D6-$H6)/($I6-$H6))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ABS($H6-E6)>ABS($I6-$H6),ABS($I6-E6)>ABS($I6-$H6)),IF(ABS($I6-E6)>ABS($H6-E6),0,1),(E6-$H6)/($I6-$H6))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(K6<0,0,IF(K6>1,1,K6))","v":{"$error":"#REF!"}},{"$f":"IF(L6<0,0,IF(L6>1,1,L6))","v":{"$error":"#VALUE!"}},{"$f":"IF(M6<0,0,IF(M6>1,1,M6))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(O6<0,0,IF(O6>1,1,O6))","v":{"$error":"#VALUE!"}}]
["P1",{"$f":"Step4!B12","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B9),\"\",Step4!I12)","v":""},{"$f":"IF(ISBLANK(Step3!$B9),\"\",Step4!K12)","v":""},{"$f":"IF(ISBLANK(Step3!$B9),\"\",Step4!M12)","v":""},{"$f":"IF(ISBLANK(Step3!$B9),\"\",Step4!O12)","v":""},{"$f":"Step4!U12","v":0},{"$f":"Step4!W12","v":0},{"$f":"I7-H7","v":0},{"$f":"IF(OR(ABS($H7-C7)>ABS($I7-$H7),ABS($I7-C7)>ABS($I7-$H7)),IF(ABS($I7-C7)>ABS($H7-C7),0,1),(C7-$H7)/($I7-$H7))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ABS($H7-D7)>ABS($I7-$H7),ABS($I7-D7)>ABS($I7-$H7)),IF(ABS($I7-D7)>ABS($H7-D7),0,1),(D7-$H7)/($I7-$H7))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ABS($H7-E7)>ABS($I7-$H7),ABS($I7-E7)>ABS($I7-$H7)),IF(ABS($I7-E7)>ABS($H7-E7),0,1),(E7-$H7)/($I7-$H7))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ABS($H7-F7)>ABS($I7-$H7),ABS($I7-F7)>ABS($I7-$H7)),IF(ABS($I7-F7)>ABS($H7-F7),0,1),(F7-$H7)/($I7-$H7))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ABS($H7-G7)>ABS($I7-$H7),ABS($I7-G7)>ABS($I7-$H7)),IF(ABS($I7-G7)>ABS($H7-G7),0,1),(G7-$H7)/($I7-$H7))","v":{"$error":"#VALUE!"}},{"$f":"IF(K7<0,0,IF(K7>1,1,K7))","v":{"$error":"#REF!"}},{"$f":"IF(L7<0,0,IF(L7>1,1,L7))","v":{"$error":"#VALUE!"}},{"$f":"IF(M7<0,0,IF(M7>1,1,M7))","v":{"$error":"#VALUE!"}},{"$f":"IF(N7<0,0,IF(N7>1,1,N7))","v":{"$error":"#VALUE!"}},{"$f":"IF(O7<0,0,IF(O7>1,1,O7))","v":{"$error":"#VALUE!"}}]
["P1",{"$f":"Step4!B13","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B10),\"\",Step4!I13)","v":""},{"$f":"IF(ISBLANK(Step3!$B10),\"\",Step4!K13)","v":""},{"$f":"IF(ISBLANK(Step3!$B10),\"\",Step4!M13)","v":""},{"$f":"IF(ISBLANK(Step3!$B10),\"\",Step4!O13)","v":""},{"$f":"Step4!U13","v":0},{"$f":"Step4!W13","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B14","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B11),\"\",Step4!I14)","v":""},{"$f":"IF(ISBLANK(Step3!$B11),\"\",Step4!K14)","v":""},{"$f":"IF(ISBLANK(Step3!$B11),\"\",Step4!M14)","v":""},{"$f":"IF(ISBLANK(Step3!$B11),\"\",Step4!O14)","v":""},{"$f":"Step4!U14","v":0},{"$f":"Step4!W14","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B15","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B12),\"\",Step4!I15)","v":""},{"$f":"IF(ISBLANK(Step3!$B12),\"\",Step4!K15)","v":""},{"$f":"IF(ISBLANK(Step3!$B12),\"\",Step4!M15)","v":""},{"$f":"IF(ISBLANK(Step3!$B12),\"\",Step4!O15)","v":""},{"$f":"Step4!U15","v":0},{"$f":"Step4!W15","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B16","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B13),\"\",Step4!I16)","v":""},{"$f":"IF(ISBLANK(Step3!$B13),\"\",Step4!K16)","v":""},{"$f":"IF(ISBLANK(Step3!$B13),\"\",Step4!M16)","v":""},{"$f":"IF(ISBLANK(Step3!$B13),\"\",Step4!O16)","v":""},{"$f":"Step4!U16","v":0},{"$f":"Step4!W16","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B17","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B14),\"\",Step4!I17)","v":""},{"$f":"IF(ISBLANK(Step3!$B14),\"\",Step4!K17)","v":""},{"$f":"IF(ISBLANK(Step3!$B14),\"\",Step4!M17)","v":""},{"$f":"IF(ISBLANK(Step3!$B14),\"\",Step4!O17)","v":""},{"$f":"Step4!U17","v":0},{"$f":"Step4!W17","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B18","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B15),\"\",Step4!I18)","v":""},{"$f":"IF(ISBLANK(Step3!$B15),\"\",Step4!K18)","v":""},{"$f":"IF(ISBLANK(Step3!$B15),\"\",Step4!M18)","v":""},{"$f":"IF(ISBLANK(Step3!$B15),\"\",Step4!O18)","v":""},{"$f":"Step4!U18","v":0},{"$f":"Step4!W18","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B19","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B16),\"\",Step4!I19)","v":""},{"$f":"IF(ISBLANK(Step3!$B16),\"\",Step4!K19)","v":""},{"$f":"IF(ISBLANK(Step3!$B16),\"\",Step4!M19)","v":""},{"$f":"IF(ISBLANK(Step3!$B16),\"\",Step4!O19)","v":""},{"$f":"Step4!U19","v":0},{"$f":"Step4!W19","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B20","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B17),\"\",Step4!I20)","v":""},{"$f":"IF(ISBLANK(Step3!$B17),\"\",Step4!K20)","v":""},{"$f":"IF(ISBLANK(Step3!$B17),\"\",Step4!M20)","v":""},{"$f":"IF(ISBLANK(Step3!$B17),\"\",Step4!O20)","v":""},{"$f":"Step4!U20","v":0},{"$f":"Step4!W20","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B21","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B18),\"\",Step4!I21)","v":""},{"$f":"IF(ISBLANK(Step3!$B18),\"\",Step4!K21)","v":""},{"$f":"IF(ISBLANK(Step3!$B18),\"\",Step4!M21)","v":""},{"$f":"IF(ISBLANK(Step3!$B18),\"\",Step4!O21)","v":""},{"$f":"Step4!U21","v":0},{"$f":"Step4!W21","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B22","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B19),\"\",Step4!I22)","v":""},{"$f":"IF(ISBLANK(Step3!$B19),\"\",Step4!K22)","v":""},{"$f":"IF(ISBLANK(Step3!$B19),\"\",Step4!M22)","v":""},{"$f":"IF(ISBLANK(Step3!$B19),\"\",Step4!O22)","v":""},{"$f":"Step4!U22","v":0},{"$f":"Step4!W22","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B23","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B20),\"\",Step4!I23)","v":""},{"$f":"IF(ISBLANK(Step3!$B20),\"\",Step4!K23)","v":""},{"$f":"IF(ISBLANK(Step3!$B20),\"\",Step4!M23)","v":""},{"$f":"IF(ISBLANK(Step3!$B20),\"\",Step4!O23)","v":""},{"$f":"Step4!U23","v":0},{"$f":"Step4!W23","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P1",{"$f":"Step4!B24","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B21),\"\",Step4!I24)","v":""},{"$f":"IF(ISBLANK(Step3!$B21),\"\",Step4!K24)","v":""},{"$f":"IF(ISBLANK(Step3!$B21),\"\",Step4!M24)","v":""},{"$f":"IF(ISBLANK(Step3!$B21),\"\",Step4!O24)","v":""},{"$f":"Step4!U24","v":0},{"$f":"Step4!W24","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B29","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H8),\"\",Step4!I29)","v":""},{"$f":"IF(ISBLANK(Step3!$H8),\"\",Step4!K29)","v":""},{"$f":"IF(ISBLANK(Step3!$H8),\"\",Step4!M29)","v":""},{"$f":"IF(ISBLANK(Step3!$H8),\"\",Step4!O29)","v":""},{"$f":"Step4!U29","v":0},{"$f":"Step4!W29","v":0},{"$f":"I20-H20","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B30","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H9),\"\",Step4!I30)","v":""},{"$f":"IF(ISBLANK(Step3!$H9),\"\",Step4!K30)","v":""},{"$f":"IF(ISBLANK(Step3!$H9),\"\",Step4!M30)","v":""},{"$f":"IF(ISBLANK(Step3!$H9),\"\",Step4!O30)","v":""},{"$f":"Step4!U30","v":0},{"$f":"Step4!W30","v":0},{"$f":"I21-H21","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B31","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H10),\"\",Step4!I31)","v":""},{"$f":"IF(ISBLANK(Step3!$H10),\"\",Step4!K31)","v":""},{"$f":"IF(ISBLANK(Step3!$H10),\"\",Step4!M31)","v":""},{"$f":"IF(ISBLANK(Step3!$H10),\"\",Step4!O31)","v":""},{"$f":"Step4!U31","v":0},{"$f":"Step4!W31","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B32","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H11),\"\",Step4!I32)","v":""},{"$f":"IF(ISBLANK(Step3!$H11),\"\",Step4!K32)","v":""},{"$f":"IF(ISBLANK(Step3!$H11),\"\",Step4!M32)","v":""},{"$f":"IF(ISBLANK(Step3!$H11),\"\",Step4!O32)","v":""},{"$f":"Step4!U32","v":0},{"$f":"Step4!W32","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B33","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H12),\"\",Step4!I33)","v":""},{"$f":"IF(ISBLANK(Step3!$H12),\"\",Step4!K33)","v":""},{"$f":"IF(ISBLANK(Step3!$H12),\"\",Step4!M33)","v":""},{"$f":"IF(ISBLANK(Step3!$H12),\"\",Step4!O33)","v":""},{"$f":"Step4!U33","v":0},{"$f":"Step4!W33","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B34","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H13),\"\",Step4!I34)","v":""},{"$f":"IF(ISBLANK(Step3!$H13),\"\",Step4!K34)","v":""},{"$f":"IF(ISBLANK(Step3!$H13),\"\",Step4!M34)","v":""},{"$f":"IF(ISBLANK(Step3!$H13),\"\",Step4!O34)","v":""},{"$f":"Step4!U34","v":0},{"$f":"Step4!W34","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B35","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H14),\"\",Step4!I35)","v":""},{"$f":"IF(ISBLANK(Step3!$H14),\"\",Step4!K35)","v":""},{"$f":"IF(ISBLANK(Step3!$H14),\"\",Step4!M35)","v":""},{"$f":"IF(ISBLANK(Step3!$H14),\"\",Step4!O35)","v":""},{"$f":"Step4!U35","v":0},{"$f":"Step4!W35","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B36","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H15),\"\",Step4!I36)","v":""},{"$f":"IF(ISBLANK(Step3!$H15),\"\",Step4!K36)","v":""},{"$f":"IF(ISBLANK(Step3!$H15),\"\",Step4!M36)","v":""},{"$f":"IF(ISBLANK(Step3!$H15),\"\",Step4!O36)","v":""},{"$f":"Step4!U36","v":0},{"$f":"Step4!W36","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B37","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H16),\"\",Step4!I37)","v":""},{"$f":"IF(ISBLANK(Step3!$H16),\"\",Step4!K37)","v":""},{"$f":"IF(ISBLANK(Step3!$H16),\"\",Step4!M37)","v":""},{"$f":"IF(ISBLANK(Step3!$H16),\"\",Step4!O37)","v":""},{"$f":"Step4!U37","v":0},{"$f":"Step4!W37","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B38","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H17),\"\",Step4!I38)","v":""},{"$f":"IF(ISBLANK(Step3!$H17),\"\",Step4!K38)","v":""},{"$f":"IF(ISBLANK(Step3!$H17),\"\",Step4!M38)","v":""},{"$f":"IF(ISBLANK(Step3!$H17),\"\",Step4!O38)","v":""},{"$f":"Step4!U38","v":0},{"$f":"Step4!W38","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B39","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H18),\"\",Step4!I39)","v":""},{"$f":"IF(ISBLANK(Step3!$H18),\"\",Step4!K39)","v":""},{"$f":"IF(ISBLANK(Step3!$H18),\"\",Step4!M39)","v":""},{"$f":"IF(ISBLANK(Step3!$H18),\"\",Step4!O39)","v":""},{"$f":"Step4!U39","v":0},{"$f":"Step4!W39","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B40","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H19),\"\",Step4!I40)","v":""},{"$f":"IF(ISBLANK(Step3!$H19),\"\",Step4!K40)","v":""},{"$f":"IF(ISBLANK(Step3!$H19),\"\",Step4!M40)","v":""},{"$f":"IF(ISBLANK(Step3!$H19),\"\",Step4!O40)","v":""},{"$f":"Step4!U40","v":0},{"$f":"Step4!W40","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B41","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H20),\"\",Step4!I41)","v":""},{"$f":"IF(ISBLANK(Step3!$H20),\"\",Step4!K41)","v":""},{"$f":"IF(ISBLANK(Step3!$H20),\"\",Step4!M41)","v":""},{"$f":"IF(ISBLANK(Step3!$H20),\"\",Step4!O41)","v":""},{"$f":"Step4!U41","v":0},{"$f":"Step4!W41","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P2",{"$f":"Step4!B42","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H21),\"\",Step4!I42)","v":""},{"$f":"IF(ISBLANK(Step3!$H21),\"\",Step4!K42)","v":""},{"$f":"IF(ISBLANK(Step3!$H21),\"\",Step4!M42)","v":""},{"$f":"IF(ISBLANK(Step3!$H21),\"\",Step4!O42)","v":""},{"$f":"Step4!U42","v":0},{"$f":"Step4!W42","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B47","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B28),\"\",Step4!I47)","v":""},{"$f":"IF(ISBLANK(Step3!$B28),\"\",Step4!K47)","v":""},{"$f":"IF(ISBLANK(Step3!$B28),\"\",Step4!M47)","v":""},{"$f":"IF(ISBLANK(Step3!$B28),\"\",Step4!O47)","v":""},{"$f":"Step4!U47","v":0},{"$f":"Step4!W47","v":0},{"$f":"I34-H34","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B48","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B29),\"\",Step4!I48)","v":""},{"$f":"IF(ISBLANK(Step3!$B29),\"\",Step4!K48)","v":""},{"$f":"IF(ISBLANK(Step3!$B29),\"\",Step4!M48)","v":""},{"$f":"IF(ISBLANK(Step3!$B29),\"\",Step4!O48)","v":""},{"$f":"Step4!U48","v":0},{"$f":"Step4!W48","v":0},{"$f":"I35-H35","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B49","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B30),\"\",Step4!I49)","v":""},{"$f":"IF(ISBLANK(Step3!$B30),\"\",Step4!K49)","v":""},{"$f":"IF(ISBLANK(Step3!$B30),\"\",Step4!M49)","v":""},{"$f":"IF(ISBLANK(Step3!$B30),\"\",Step4!O49)","v":""},{"$f":"Step4!U49","v":0},{"$f":"Step4!W49","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B50","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B31),\"\",Step4!I50)","v":""},{"$f":"IF(ISBLANK(Step3!$B31),\"\",Step4!K50)","v":""},{"$f":"IF(ISBLANK(Step3!$B31),\"\",Step4!M50)","v":""},{"$f":"IF(ISBLANK(Step3!$B31),\"\",Step4!O50)","v":""},{"$f":"Step4!U50","v":0},{"$f":"Step4!W50","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B51","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B32),\"\",Step4!I51)","v":""},{"$f":"IF(ISBLANK(Step3!$B32),\"\",Step4!K51)","v":""},{"$f":"IF(ISBLANK(Step3!$B32),\"\",Step4!M51)","v":""},{"$f":"IF(ISBLANK(Step3!$B32),\"\",Step4!O51)","v":""},{"$f":"Step4!U51","v":0},{"$f":"Step4!W51","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B52","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B33),\"\",Step4!I52)","v":""},{"$f":"IF(ISBLANK(Step3!$B33),\"\",Step4!K52)","v":""},{"$f":"IF(ISBLANK(Step3!$B33),\"\",Step4!M52)","v":""},{"$f":"IF(ISBLANK(Step3!$B33),\"\",Step4!O52)","v":""},{"$f":"Step4!U52","v":0},{"$f":"Step4!W52","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B53","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B34),\"\",Step4!I53)","v":""},{"$f":"IF(ISBLANK(Step3!$B34),\"\",Step4!K53)","v":""},{"$f":"IF(ISBLANK(Step3!$B34),\"\",Step4!M53)","v":""},{"$f":"IF(ISBLANK(Step3!$B34),\"\",Step4!O53)","v":""},{"$f":"Step4!U53","v":0},{"$f":"Step4!W53","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B54","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B35),\"\",Step4!I54)","v":""},{"$f":"IF(ISBLANK(Step3!$B35),\"\",Step4!K54)","v":""},{"$f":"IF(ISBLANK(Step3!$B35),\"\",Step4!M54)","v":""},{"$f":"IF(ISBLANK(Step3!$B35),\"\",Step4!O54)","v":""},{"$f":"Step4!U54","v":0},{"$f":"Step4!W54","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B55","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B36),\"\",Step4!I55)","v":""},{"$f":"IF(ISBLANK(Step3!$B36),\"\",Step4!K55)","v":""},{"$f":"IF(ISBLANK(Step3!$B36),\"\",Step4!M55)","v":""},{"$f":"IF(ISBLANK(Step3!$B36),\"\",Step4!O55)","v":""},{"$f":"Step4!U55","v":0},{"$f":"Step4!W55","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B56","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B37),\"\",Step4!I56)","v":""},{"$f":"IF(ISBLANK(Step3!$B37),\"\",Step4!K56)","v":""},{"$f":"IF(ISBLANK(Step3!$B37),\"\",Step4!M56)","v":""},{"$f":"IF(ISBLANK(Step3!$B37),\"\",Step4!O56)","v":""},{"$f":"Step4!U56","v":0},{"$f":"Step4!W56","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B57","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B38),\"\",Step4!I57)","v":""},{"$f":"IF(ISBLANK(Step3!$B38),\"\",Step4!K57)","v":""},{"$f":"IF(ISBLANK(Step3!$B38),\"\",Step4!M57)","v":""},{"$f":"IF(ISBLANK(Step3!$B38),\"\",Step4!O57)","v":""},{"$f":"Step4!U57","v":0},{"$f":"Step4!W57","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B58","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B39),\"\",Step4!I58)","v":""},{"$f":"IF(ISBLANK(Step3!$B39),\"\",Step4!K58)","v":""},{"$f":"IF(ISBLANK(Step3!$B39),\"\",Step4!M58)","v":""},{"$f":"IF(ISBLANK(Step3!$B39),\"\",Step4!O58)","v":""},{"$f":"Step4!U58","v":0},{"$f":"Step4!W58","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B59","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B40),\"\",Step4!I59)","v":""},{"$f":"IF(ISBLANK(Step3!$B40),\"\",Step4!K59)","v":""},{"$f":"IF(ISBLANK(Step3!$B40),\"\",Step4!M59)","v":""},{"$f":"IF(ISBLANK(Step3!$B40),\"\",Step4!O59)","v":""},{"$f":"Step4!U59","v":0},{"$f":"Step4!W59","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P3",{"$f":"Step4!B60","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$B41),\"\",Step4!I60)","v":""},{"$f":"IF(ISBLANK(Step3!$B41),\"\",Step4!K60)","v":""},{"$f":"IF(ISBLANK(Step3!$B41),\"\",Step4!M60)","v":""},{"$f":"IF(ISBLANK(Step3!$B41),\"\",Step4!O60)","v":""},{"$f":"Step4!U60","v":0},{"$f":"Step4!W60","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B65","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H28),\"\",Step4!I65)","v":""},{"$f":"IF(ISBLANK(Step3!$H28),\"\",Step4!K65)","v":""},{"$f":"IF(ISBLANK(Step3!$H28),\"\",Step4!M65)","v":""},{"$f":"IF(ISBLANK(Step3!$H28),\"\",Step4!O65)","v":""},{"$f":"Step4!U65","v":0},{"$f":"Step4!W65","v":0},{"$f":"I48-H48","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B66","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H29),\"\",Step4!I66)","v":""},{"$f":"IF(ISBLANK(Step3!$H29),\"\",Step4!K66)","v":""},{"$f":"IF(ISBLANK(Step3!$H29),\"\",Step4!M66)","v":""},{"$f":"IF(ISBLANK(Step3!$H29),\"\",Step4!O66)","v":""},{"$f":"Step4!U66","v":0},{"$f":"Step4!W66","v":0},{"$f":"I49-H49","v":0},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B67","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H30),\"\",Step4!I67)","v":""},{"$f":"IF(ISBLANK(Step3!$H30),\"\",Step4!K67)","v":""},{"$f":"IF(ISBLANK(Step3!$H30),\"\",Step4!M67)","v":""},{"$f":"IF(ISBLANK(Step3!$H30),\"\",Step4!O67)","v":""},{"$f":"Step4!U67","v":0},{"$f":"Step4!W67","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B68","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H31),\"\",Step4!I68)","v":""},{"$f":"IF(ISBLANK(Step3!$H31),\"\",Step4!K68)","v":""},{"$f":"IF(ISBLANK(Step3!$H31),\"\",Step4!M68)","v":""},{"$f":"IF(ISBLANK(Step3!$H31),\"\",Step4!O68)","v":""},{"$f":"Step4!U68","v":0},{"$f":"Step4!W68","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B69","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H32),\"\",Step4!I69)","v":""},{"$f":"IF(ISBLANK(Step3!$H32),\"\",Step4!K69)","v":""},{"$f":"IF(ISBLANK(Step3!$H32),\"\",Step4!M69)","v":""},{"$f":"IF(ISBLANK(Step3!$H32),\"\",Step4!O69)","v":""},{"$f":"Step4!U69","v":0},{"$f":"Step4!W69","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B70","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H33),\"\",Step4!I70)","v":""},{"$f":"IF(ISBLANK(Step3!$H33),\"\",Step4!K70)","v":""},{"$f":"IF(ISBLANK(Step3!$H33),\"\",Step4!M70)","v":""},{"$f":"IF(ISBLANK(Step3!$H33),\"\",Step4!O70)","v":""},{"$f":"Step4!U70","v":0},{"$f":"Step4!W70","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B71","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H34),\"\",Step4!I71)","v":""},{"$f":"IF(ISBLANK(Step3!$H34),\"\",Step4!K71)","v":""},{"$f":"IF(ISBLANK(Step3!$H34),\"\",Step4!M71)","v":""},{"$f":"IF(ISBLANK(Step3!$H34),\"\",Step4!O71)","v":""},{"$f":"Step4!U71","v":0},{"$f":"Step4!W71","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B72","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H35),\"\",Step4!I72)","v":""},{"$f":"IF(ISBLANK(Step3!$H35),\"\",Step4!K72)","v":""},{"$f":"IF(ISBLANK(Step3!$H35),\"\",Step4!M72)","v":""},{"$f":"IF(ISBLANK(Step3!$H35),\"\",Step4!O72)","v":""},{"$f":"Step4!U72","v":0},{"$f":"Step4!W72","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B73","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H36),\"\",Step4!I73)","v":""},{"$f":"IF(ISBLANK(Step3!$H36),\"\",Step4!K73)","v":""},{"$f":"IF(ISBLANK(Step3!$H36),\"\",Step4!M73)","v":""},{"$f":"IF(ISBLANK(Step3!$H36),\"\",Step4!O73)","v":""},{"$f":"Step4!U73","v":0},{"$f":"Step4!W73","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B74","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H37),\"\",Step4!I74)","v":""},{"$f":"IF(ISBLANK(Step3!$H37),\"\",Step4!K74)","v":""},{"$f":"IF(ISBLANK(Step3!$H37),\"\",Step4!M74)","v":""},{"$f":"IF(ISBLANK(Step3!$H37),\"\",Step4!O74)","v":""},{"$f":"Step4!U74","v":0},{"$f":"Step4!W74","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B75","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H38),\"\",Step4!I75)","v":""},{"$f":"IF(ISBLANK(Step3!$H38),\"\",Step4!K75)","v":""},{"$f":"IF(ISBLANK(Step3!$H38),\"\",Step4!M75)","v":""},{"$f":"IF(ISBLANK(Step3!$H38),\"\",Step4!O75)","v":""},{"$f":"Step4!U75","v":0},{"$f":"Step4!W75","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B76","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H39),\"\",Step4!I76)","v":""},{"$f":"IF(ISBLANK(Step3!$H39),\"\",Step4!K76)","v":""},{"$f":"IF(ISBLANK(Step3!$H39),\"\",Step4!M76)","v":""},{"$f":"IF(ISBLANK(Step3!$H39),\"\",Step4!O76)","v":""},{"$f":"Step4!U76","v":0},{"$f":"Step4!W76","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B77","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H40),\"\",Step4!I77)","v":""},{"$f":"IF(ISBLANK(Step3!$H40),\"\",Step4!K77)","v":""},{"$f":"IF(ISBLANK(Step3!$H40),\"\",Step4!M77)","v":""},{"$f":"IF(ISBLANK(Step3!$H40),\"\",Step4!O77)","v":""},{"$f":"Step4!U77","v":0},{"$f":"Step4!W77","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["P4",{"$f":"Step4!B78","v":""},{"$f":"Step4!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(ISBLANK(Step3!$H41),\"\",Step4!I78)","v":""},{"$f":"IF(ISBLANK(Step3!$H41),\"\",Step4!K78)","v":""},{"$f":"IF(ISBLANK(Step3!$H41),\"\",Step4!M78)","v":""},{"$f":"IF(ISBLANK(Step3!$H41),\"\",Step4!O78)","v":""},{"$f":"Step4!U78","v":0},{"$f":"Step4!W78","v":0},0,{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]

{"sheet":"_2weight","index":13,"n_rows":62,"n_cols":28,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,0,11],[4,8,4,12],[4,13,4,17],[4,18,4,22],[4,23,4,27],[4,3,4,7]]}
["Weighting Criteria's Importance"]
[]
[]
[]
[null,null,null,"Weight for valid criteria only",null,null,null,null,"Normalized Vars",null,null,null,null,"Weighted Normalized Vars",null,null,null,null,"Is Valid?",null,null,null,null,"Is Valid (Eliminate Errors)?"]
["Partner","Criteria","Weight","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
["P1",{"$f":"_1normal!B6","v":""},{"$f":"Step5!Q13","v":0},{"$f":"IF(ISERROR(S7),0,$C7)","v":0},{"$f":"IF(ISERROR(T7),0,$C7)","v":0},{"$f":"IF(ISERROR(U7),0,$C7)","v":0},{"$f":"IF(ISERROR(V7),0,$C7)","v":0},{"$f":"IF(ISERROR(W7),0,$C7)","v":0},{"$f":"_1normal!P6","v":{"$error":"#REF!"}},{"$f":"_1normal!Q6","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R6","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S6","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T6","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR($C7*I7),\"\",$C7*I7)","v":""},{"$f":"IF(ISERROR($C7*J7),\"\",$C7*J7)","v":""},"","",{"$f":"IF(ISERROR($C7*M7),\"\",$C7*M7)","v":""},{"$f":"IF(I7>=0,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(J7>=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K7>=0,1,0)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(S7,0)","v":0},{"$f":"IFERROR(T7,0)","v":0},{"$f":"IFERROR(U7,0)","v":0},{"$f":"IFERROR(V7,0)","v":0},{"$f":"IFERROR(W7,0)","v":0}]
["P1",{"$f":"_1normal!B7","v":""},{"$f":"Step5!Q14","v":0},{"$f":"IF(ISERROR(S8),0,$C8)","v":0},{"$f":"IF(ISERROR(T8),0,$C8)","v":0},{"$f":"IF(ISERROR(U8),0,$C8)","v":0},{"$f":"IF(ISERROR(V8),0,$C8)","v":0},{"$f":"IF(ISERROR(W8),0,$C8)","v":0},{"$f":"_1normal!P7","v":{"$error":"#REF!"}},{"$f":"_1normal!Q7","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R7","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S7","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T7","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR($C8*I8),\"\",$C8*I8)","v":""},{"$f":"IF(ISERROR($C8*J8),\"\",$C8*J8)","v":""},{"$f":"IF(ISERROR($C8*K8),\"\",$C8*K8)","v":""},{"$f":"IF(ISERROR($C8*L8),\"\",$C8*L8)","v":""},{"$f":"IF(ISERROR($C8*M8),\"\",$C8*M8)","v":""},{"$f":"IF(I8>=0,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(J8>=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(K8>=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(L8>=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IF(M8>=0,1,0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(S8,0)","v":0},{"$f":"IFERROR(T8,0)","v":0},{"$f":"IFERROR(U8,0)","v":0},{"$f":"IFERROR(V8,0)","v":0},{"$f":"IFERROR(W8,0)","v":0}]
["P1",{"$f":"_1normal!B8","v":""},{"$f":"Step5!Q15","v":0},0,0,0,0,0,{"$f":"_1normal!P8","v":{"$error":"#REF!"}},{"$f":"_1normal!Q8","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R8","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S8","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T8","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B9","v":""},{"$f":"Step5!Q16","v":0},0,0,0,0,0,{"$f":"_1normal!P9","v":{"$error":"#REF!"}},{"$f":"_1normal!Q9","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R9","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S9","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T9","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B10","v":""},{"$f":"Step5!Q17","v":0},{"$f":"IF(ISERROR(S11),0,$C11)","v":0},0,0,0,0,{"$f":"_1normal!P10","v":{"$error":"#REF!"}},{"$f":"_1normal!Q10","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R10","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S10","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T10","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B11","v":""},{"$f":"Step5!Q18","v":0},0,0,0,0,0,{"$f":"_1normal!P11","v":{"$error":"#REF!"}},{"$f":"_1normal!Q11","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R11","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S11","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T11","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B12","v":""},{"$f":"Step5!Q19","v":0},0,0,0,0,0,{"$f":"_1normal!P12","v":{"$error":"#REF!"}},{"$f":"_1normal!Q12","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R12","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S12","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T12","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B13","v":""},{"$f":"Step5!Q20","v":0},0,0,0,0,0,{"$f":"_1normal!P13","v":{"$error":"#REF!"}},{"$f":"_1normal!Q13","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R13","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S13","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T13","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B14","v":""},{"$f":"Step5!Q21","v":0},0,0,0,0,0,{"$f":"_1normal!P14","v":{"$error":"#REF!"}},{"$f":"_1normal!Q14","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R14","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S14","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T14","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B15","v":""},{"$f":"Step5!Q22","v":0},0,0,0,0,0,{"$f":"_1normal!P15","v":{"$error":"#REF!"}},{"$f":"_1normal!Q15","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R15","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S15","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T15","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B16","v":""},{"$f":"Step5!Q23","v":0},0,0,0,0,0,{"$f":"_1normal!P16","v":{"$error":"#REF!"}},{"$f":"_1normal!Q16","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R16","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S16","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T16","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B17","v":""},{"$f":"Step5!Q24","v":0},0,0,0,0,0,{"$f":"_1normal!P17","v":{"$error":"#REF!"}},{"$f":"_1normal!Q17","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R17","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S17","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T17","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B18","v":""},{"$f":"Step5!Q25","v":0},0,0,0,0,0,{"$f":"_1normal!P18","v":{"$error":"#REF!"}},{"$f":"_1normal!Q18","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R18","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S18","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T18","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P1",{"$f":"_1normal!B19","v":""},{"$f":"Step5!Q26","v":0},0,0,0,0,0,{"$f":"_1normal!P19","v":{"$error":"#REF!"}},{"$f":"_1normal!Q19","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R19","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S19","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T19","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B20","v":""},{"$f":"Step5!Q34","v":0},0,0,0,0,0,{"$f":"_1normal!P20","v":{"$error":"#REF!"}},{"$f":"_1normal!Q20","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R20","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S20","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T20","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B21","v":""},{"$f":"Step5!Q35","v":0},0,0,0,0,0,{"$f":"_1normal!P21","v":{"$error":"#REF!"}},{"$f":"_1normal!Q21","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R21","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S21","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T21","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B22","v":""},{"$f":"Step5!Q36","v":0},0,0,0,0,0,{"$f":"_1normal!P22","v":{"$error":"#REF!"}},{"$f":"_1normal!Q22","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R22","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S22","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T22","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B23","v":""},{"$f":"Step5!Q37","v":0},0,0,0,0,0,{"$f":"_1normal!P23","v":{"$error":"#REF!"}},{"$f":"_1normal!Q23","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R23","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S23","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T23","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B24","v":""},{"$f":"Step5!Q38","v":0},0,0,0,0,0,{"$f":"_1normal!P24","v":{"$error":"#REF!"}},{"$f":"_1normal!Q24","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R24","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S24","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T24","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B25","v":""},{"$f":"Step5!Q39","v":0},0,0,0,0,0,{"$f":"_1normal!P25","v":{"$error":"#REF!"}},{"$f":"_1normal!Q25","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R25","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S25","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T25","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B26","v":""},{"$f":"Step5!Q40","v":0},0,0,0,0,0,{"$f":"_1normal!P26","v":{"$error":"#REF!"}},{"$f":"_1normal!Q26","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R26","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S26","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T26","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B27","v":""},{"$f":"Step5!Q41","v":0},0,0,0,0,0,{"$f":"_1normal!P27","v":{"$error":"#REF!"}},{"$f":"_1normal!Q27","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R27","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S27","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T27","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B28","v":""},{"$f":"Step5!Q42","v":0},0,0,0,0,0,{"$f":"_1normal!P28","v":{"$error":"#REF!"}},{"$f":"_1normal!Q28","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R28","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S28","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T28","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B29","v":""},{"$f":"Step5!Q43","v":0},0,0,0,0,0,{"$f":"_1normal!P29","v":{"$error":"#REF!"}},{"$f":"_1normal!Q29","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R29","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S29","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T29","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B30","v":""},{"$f":"Step5!Q44","v":0},0,0,0,0,0,{"$f":"_1normal!P30","v":{"$error":"#REF!"}},{"$f":"_1normal!Q30","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R30","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S30","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T30","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B31","v":""},{"$f":"Step5!Q45","v":0},0,0,0,0,0,{"$f":"_1normal!P31","v":{"$error":"#REF!"}},{"$f":"_1normal!Q31","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R31","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S31","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T31","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B32","v":""},{"$f":"Step5!Q46","v":0},0,0,0,0,0,{"$f":"_1normal!P32","v":{"$error":"#REF!"}},{"$f":"_1normal!Q32","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R32","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S32","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T32","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P2",{"$f":"_1normal!B33","v":""},{"$f":"Step5!Q47","v":0},0,0,0,0,0,{"$f":"_1normal!P33","v":{"$error":"#REF!"}},{"$f":"_1normal!Q33","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R33","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S33","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T33","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B34","v":""},{"$f":"Step5!Q55","v":0},0,0,0,0,0,{"$f":"_1normal!P34","v":{"$error":"#REF!"}},{"$f":"_1normal!Q34","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R34","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S34","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T34","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B35","v":""},{"$f":"Step5!Q56","v":0},0,0,0,0,0,{"$f":"_1normal!P35","v":{"$error":"#REF!"}},{"$f":"_1normal!Q35","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R35","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S35","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T35","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B36","v":""},{"$f":"Step5!Q57","v":0},0,0,0,0,0,{"$f":"_1normal!P36","v":{"$error":"#REF!"}},{"$f":"_1normal!Q36","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R36","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S36","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T36","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B37","v":""},{"$f":"Step5!Q58","v":0},0,0,0,0,0,{"$f":"_1normal!P37","v":{"$error":"#REF!"}},{"$f":"_1normal!Q37","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R37","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S37","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T37","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B38","v":""},{"$f":"Step5!Q59","v":0},0,0,0,0,0,{"$f":"_1normal!P38","v":{"$error":"#REF!"}},{"$f":"_1normal!Q38","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R38","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S38","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T38","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B39","v":""},{"$f":"Step5!Q60","v":0},0,0,0,0,0,{"$f":"_1normal!P39","v":{"$error":"#REF!"}},{"$f":"_1normal!Q39","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R39","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S39","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T39","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B40","v":""},{"$f":"Step5!Q61","v":0},0,0,0,0,0,{"$f":"_1normal!P40","v":{"$error":"#REF!"}},{"$f":"_1normal!Q40","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R40","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S40","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T40","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B41","v":""},{"$f":"Step5!Q62","v":0},0,0,0,0,0,{"$f":"_1normal!P41","v":{"$error":"#REF!"}},{"$f":"_1normal!Q41","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R41","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S41","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T41","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B42","v":""},{"$f":"Step5!Q63","v":0},0,0,0,0,0,{"$f":"_1normal!P42","v":{"$error":"#REF!"}},{"$f":"_1normal!Q42","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R42","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S42","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T42","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B43","v":""},{"$f":"Step5!Q64","v":0},0,0,0,0,0,{"$f":"_1normal!P43","v":{"$error":"#REF!"}},{"$f":"_1normal!Q43","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R43","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S43","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T43","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B44","v":""},{"$f":"Step5!Q65","v":0},0,0,0,0,0,{"$f":"_1normal!P44","v":{"$error":"#REF!"}},{"$f":"_1normal!Q44","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R44","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S44","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T44","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B45","v":""},{"$f":"Step5!Q66","v":0},0,0,0,0,0,{"$f":"_1normal!P45","v":{"$error":"#REF!"}},{"$f":"_1normal!Q45","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R45","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S45","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T45","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B46","v":""},{"$f":"Step5!Q67","v":0},0,0,0,0,0,{"$f":"_1normal!P46","v":{"$error":"#REF!"}},{"$f":"_1normal!Q46","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R46","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S46","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T46","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P3",{"$f":"_1normal!B47","v":""},{"$f":"Step5!Q68","v":0},0,0,0,0,0,{"$f":"_1normal!P47","v":{"$error":"#REF!"}},{"$f":"_1normal!Q47","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R47","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S47","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T47","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B48","v":""},{"$f":"Step5!Q76","v":0},0,0,0,0,0,{"$f":"_1normal!P48","v":{"$error":"#REF!"}},{"$f":"_1normal!Q48","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R48","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S48","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T48","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B49","v":""},{"$f":"Step5!Q77","v":0},0,0,0,0,0,{"$f":"_1normal!P49","v":{"$error":"#REF!"}},{"$f":"_1normal!Q49","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R49","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S49","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T49","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B50","v":""},{"$f":"Step5!Q78","v":0},0,0,0,0,0,{"$f":"_1normal!P50","v":{"$error":"#REF!"}},{"$f":"_1normal!Q50","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R50","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S50","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T50","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B51","v":""},{"$f":"Step5!Q79","v":0},0,0,0,0,0,{"$f":"_1normal!P51","v":{"$error":"#REF!"}},{"$f":"_1normal!Q51","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R51","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S51","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T51","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B52","v":""},{"$f":"Step5!Q80","v":0},0,0,0,0,0,{"$f":"_1normal!P52","v":{"$error":"#REF!"}},{"$f":"_1normal!Q52","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R52","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S52","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T52","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B53","v":""},{"$f":"Step5!Q81","v":0},0,0,0,0,0,{"$f":"_1normal!P53","v":{"$error":"#REF!"}},{"$f":"_1normal!Q53","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R53","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S53","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T53","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B54","v":""},{"$f":"Step5!Q82","v":0},0,0,0,0,0,{"$f":"_1normal!P54","v":{"$error":"#REF!"}},{"$f":"_1normal!Q54","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R54","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S54","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T54","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B55","v":""},{"$f":"Step5!Q83","v":0},0,0,0,0,0,{"$f":"_1normal!P55","v":{"$error":"#REF!"}},{"$f":"_1normal!Q55","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R55","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S55","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T55","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B56","v":""},{"$f":"Step5!Q84","v":0},0,0,0,0,0,{"$f":"_1normal!P56","v":{"$error":"#REF!"}},{"$f":"_1normal!Q56","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R56","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S56","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T56","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B57","v":""},{"$f":"Step5!Q85","v":0},0,0,0,0,0,{"$f":"_1normal!P57","v":{"$error":"#REF!"}},{"$f":"_1normal!Q57","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R57","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S57","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T57","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B58","v":""},{"$f":"Step5!Q86","v":0},0,0,0,0,0,{"$f":"_1normal!P58","v":{"$error":"#REF!"}},{"$f":"_1normal!Q58","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R58","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S58","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T58","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B59","v":""},{"$f":"Step5!Q87","v":0},0,0,0,0,0,{"$f":"_1normal!P59","v":{"$error":"#REF!"}},{"$f":"_1normal!Q59","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R59","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S59","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T59","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B60","v":""},{"$f":"Step5!Q88","v":0},0,0,0,0,0,{"$f":"_1normal!P60","v":{"$error":"#REF!"}},{"$f":"_1normal!Q60","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R60","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S60","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T60","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]
["P4",{"$f":"_1normal!B61","v":""},{"$f":"Step5!Q89","v":0},0,0,0,0,0,{"$f":"_1normal!P61","v":{"$error":"#REF!"}},{"$f":"_1normal!Q61","v":{"$error":"#VALUE!"}},{"$f":"_1normal!R61","v":{"$error":"#VALUE!"}},{"$f":"_1normal!S61","v":{"$error":"#VALUE!"}},{"$f":"_1normal!T61","v":{"$error":"#VALUE!"}},"","","","","",{"$error":"#REF!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,0,0,0]

{"sheet":"_3sum","index":14,"n_rows":12,"n_cols":26,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,11],[6,21,6,25],[6,1,6,5],[6,11,6,15],[6,6,6,10],[6,16,6,20]]}
["Summarize for Each Partner"]
[]
[]
[]
[]
[]
[null,"Number of Valid Criteria",null,null,null,null,"Sum of Importance for Valid Criteria",null,null,null,null,"Sum of Criteria Index",null,null,null,null,"Divide Sum of Criteria Index by Sum of Importance",null,null,null,null,"Divide by Number of Valid Criteria"]
["Partner","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4","Status Quo","Scenario 1","Scenario 2","Scenario 3","Scenario 4"]
["P1",{"$f":"SUM(_2weight!X7:X20)","v":0},{"$f":"SUM(_2weight!Y7:Y20)","v":0},{"$f":"SUM(_2weight!Z7:Z20)","v":0},{"$f":"SUM(_2weight!AA7:AA20)","v":0},{"$f":"SUM(_2weight!AB7:AB20)","v":0},{"$f":"SUM(_2weight!D7:D20)","v":0},{"$f":"SUM(_2weight!E7:E20)","v":0},{"$f":"SUM(_2weight!F7:F20)","v":0},{"$f":"SUM(_2weight!G7:G20)","v":0},{"$f":"SUM(_2weight!H7:H20)","v":0},{"$f":"SUM(_2weight!N7:N20)","v":0},{"$f":"SUM(_2weight!O7:O20)","v":0},{"$f":"SUM(_2weight!P7:P20)","v":0},{"$f":"SUM(_2weight!Q7:Q20)","v":0},{"$f":"SUM(_2weight!R7:R20)","v":0},{"$f":"IF(ISERROR(L9/#REF!),\"\",L9/#REF!)","v":""},{"$f":"IF(ISERROR(M9/H9),\"\",M9/H9)","v":""},{"$f":"IF(ISERROR(N9/I9),\"\",N9/I9)","v":""},"","",{"$f":"IF(ISERROR(Q9/B9),\"\",Q9/B9)","v":""},"","","",""]
["P2",{"$f":"SUM(_2weight!X21:X34)","v":0},{"$f":"SUM(_2weight!Y21:Y34)","v":0},{"$f":"SUM(_2weight!Z21:Z34)","v":0},{"$f":"SUM(_2weight!AA21:AA34)","v":0},{"$f":"SUM(_2weight!AB21:AB34)","v":0},{"$f":"SUM(_2weight!D21:D34)","v":0},{"$f":"SUM(_2weight!E21:E34)","v":0},{"$f":"SUM(_2weight!F21:F34)","v":0},{"$f":"SUM(_2weight!G21:G34)","v":0},{"$f":"SUM(_2weight!H21:H34)","v":0},{"$f":"SUM(_2weight!N21:N34)","v":0},{"$f":"SUM(_2weight!O21:O34)","v":0},{"$f":"SUM(_2weight!P21:P34)","v":0},{"$f":"SUM(_2weight!Q21:Q34)","v":0},{"$f":"SUM(_2weight!R21:R34)","v":0},{"$f":"IF(ISERROR(L10/#REF!),\"\",L10/#REF!)","v":""},"","","","","","","","",""]
["P3",{"$f":"SUM(_2weight!X35:X48)","v":0},{"$f":"SUM(_2weight!Y35:Y48)","v":0},{"$f":"SUM(_2weight!Z35:Z48)","v":0},{"$f":"SUM(_2weight!AA35:AA48)","v":0},{"$f":"SUM(_2weight!AB35:AB48)","v":0},{"$f":"SUM(_2weight!D35:D48)","v":0},{"$f":"SUM(_2weight!E35:E48)","v":0},{"$f":"SUM(_2weight!F35:F48)","v":0},{"$f":"SUM(_2weight!G35:G48)","v":0},{"$f":"SUM(_2weight!H35:H48)","v":0},{"$f":"SUM(_2weight!N35:N48)","v":0},{"$f":"SUM(_2weight!O35:O48)","v":0},{"$f":"SUM(_2weight!P35:P48)","v":0},{"$f":"SUM(_2weight!Q35:Q48)","v":0},{"$f":"SUM(_2weight!R35:R48)","v":0},{"$f":"IF(ISERROR(L11/#REF!),\"\",L11/#REF!)","v":""},"","","","","","","","",""]
["P4",{"$f":"SUM(_2weight!X49:X62)","v":0},{"$f":"SUM(_2weight!Y49:Y62)","v":0},{"$f":"SUM(_2weight!Z49:Z62)","v":0},{"$f":"SUM(_2weight!AA49:AA62)","v":0},{"$f":"SUM(_2weight!AB49:AB62)","v":0},{"$f":"SUM(_2weight!D49:D62)","v":0},{"$f":"SUM(_2weight!E49:E62)","v":0},{"$f":"SUM(_2weight!F49:F62)","v":0},{"$f":"SUM(_2weight!G49:G62)","v":0},{"$f":"SUM(_2weight!H49:H62)","v":0},{"$f":"SUM(_2weight!N49:N62)","v":0},{"$f":"SUM(_2weight!O49:O62)","v":0},{"$f":"SUM(_2weight!P49:P62)","v":0},{"$f":"SUM(_2weight!Q49:Q62)","v":0},{"$f":"SUM(_2weight!R49:R62)","v":0},{"$f":"IF(ISERROR(L12/#REF!),\"\",L12/#REF!)","v":""},"","","","","","","","",""]

{"sheet":"_Criteria","index":15,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["Criteria Category","Indicator","Units"]
[null,"CATEGORY - SAFETY"]
["Safety","Crash rate (vehicles)","Collisions per year"]
["Safety","Collisions with roadway departure","Collisions per year"]
["Safety","Collisions involving pedestrians or bicyclists","Collisions per year"]
["Safety","Collisions at an intersection","Collisions per year"]
["Safety","Collisions with adverse weather conditions (e.g., rain, snow)","Collisions per year"]
["Safety","Collisions involving animals","Collisions per year"]
["Safety","Collisions involving objects on the road","Collisions per year"]
["Safety","Collisions involving alcohol","Collisions per year"]
["Safety","Collisions involving high speeds","Collisions per year"]
["Safety","Number of collisions (all)","Collisions per year"]
["Safety","Number of severe collisions (all)","Severe collisions per year"]
["Safety","Number of collisions involving pedestrians","Collisions per year"]
["Safety","Number of collisions involving cyclists","Collisions per year"]
["Safety","Number of conflict points","Count"]
["Safety","Number of conflict points with pedestrians","Count"]
["Safety","Number of conflict points with cyclists","Count"]
["Safety","Perceived safety","1 (poor) - 5 (excellent)"]
["Safety","Perceived security","1 (poor) - 5 (excellent)"]
["Safety","Change in traffic speed","MPH"]
[null,"CATEGORY - INFRASTRUCTURE CONDITION"]
["Infrastructure Condition","Pavement in 'good' condition","Lane-miles"]
["Infrastructure Condition","Pavement in 'fair' condition","Lane-miles"]
["Infrastructure Condition","Pavement in 'poor' condition","Lane-miles"]
["Infrastructure Condition","Percentage of bridges rated good or better","Percent"]
["Infrastructure Condition","Average ride quality","Change in International Roughness Index (IRI)"]
["Infrastructure Condition","Percent of sidewalk meeting ADA requirements","Change in percent"]
["Infrastructure Condition","Pedestrian level of service 'A'","Sidewalk miles"]
["Infrastructure Condition","Pedestrian level of service 'B'","Sidewalk miles"]
["Infrastructure Condition","Pedestrian level of service 'C'","Sidewalk miles"]
["Infrastructure Condition","Pedestrian level of service 'D'","Sidewalk miles"]
["Infrastructure Condition","Pedestrian level of service 'E'","Sidewalk miles"]
["Infrastructure Condition","Pedestrian level of service 'F'","Sidewalk miles"]
["Infrastructure Condition","Condition of transit station(s)","1 (poor) - 5 (excellent)"]
[null,"CATEGORY - CONGESTION REDUCTION"]
["Congestion Reduction","Delay hours (facility only)","Annual hours of delay"]
["Congestion Reduction","Delay hours (within ~1 mile of facility)","Annual hours of delay"]
["Congestion Reduction","Congestion costs","$ of annual congestion costs"]
["Congestion Reduction","Number of hours facility is congested","Change in hours"]
[null,"CATEGORY - SYSTEM RELIABILITY"]
["System Reliability ","Buffer index (in neighborhood of rightsized route)","Percent"]
["System Reliability ","Planning time index (in neighborhood of rightsized route)","[unitless index]"]
[null,"CATEGORY - ECONOMIC VITALITY"]
["Economic Vitality","Sales tax near rightsized route","$ annual receipts"]
["Economic Vitality","Property tax near rightsized route","$ annual receipts"]
["Economic Vitality","Employment near rightsized route","Jobs"]
["Economic Vitality","Business output near rightsized route","$ annually"]
["Economic Vitality","Worker income near rightsized route","$ annually"]
["Economic Vitality","Commercial vacancies","Area (sq-ft)"]
["Economic Vitality","Residential vacancies","Units"]
["Economic Vitality","Average property value","$ per sq-ft"]
["Economic Vitality","Value of new investment in corridor","$"]
[null,"CATEGORY - EQUITY"]
["Equity","Mean percent of income spent on transportation","% annual income"]
["Equity","Mean housing-to-income ratio","[unitless ratio]"]
[null,"CATEGORY - ENVIRONMENT"]
["Environmental Sustainability","Improvement in local air quality","1 (significant degradation) - 10 (major improvement)"]
["Environmental Sustainability","Improvement in regional air quality","1 (significant degradation) - 10 (major improvement)"]
["Environmental Sustainability","'Environmental justice' initiative","Binary (1, yes / 2, no)"]
[null,"CATEGORY - MOBILITY / ACCESSIBILITY"]
["Mobility / Accessibility","Percent of residents with more than one modal option","%"]
["Mobility / Accessibility","Bicycle level of service","1 (F) - 6 (A)"]
["Mobility / Accessibility","Bicycle level of traffic stress ","1 (low) - 5 (high)"]
["Mobility / Accessibility","Miles of bike lanes / cycle tracks","Miles"]
["Mobility / Accessibility","Pedestrian signal delay","Minutes of average delay"]
["Mobility / Accessibility","Intersection density","Intersections per sq-mile"]
["Mobility / Accessibility","Average transit passenger wait times","Minutes"]
["Mobility / Accessibility","Quality of transit stations","1 (poor) - 5 (excellent)"]