{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Input Data","Ranking","Example Input Data","Example Ranking","DEA Calculations","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":88,"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":"Input Data","index":0,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[8,1,9,1],[8,2,9,2],[1,10,1,11],[2,10,2,11]]}
["Unused","Project Evaluation Toolkit - Multiobjective Project Ranking",null,null,null,null,null,null,null,null,"Legend"]
["Benefit",null,null,null,null,null,null,null,null,null,"User Inputs"]
["Cost","Steps:",null,null,null,null,null,null,null,null,"Key Outputs"]
[null,"1. Enter evaluation categories along top row, indicating which metrics are \"benefits\" and which are \"costs\" from the drop-down menu"]
[null,"2. Enter data for each project"]
[null,"3. Click \"Rank projects\" button"]
[null,"4. Upon completion of project ranking, you will be moved to the Ranking sheet."]
[null,null,null,"mobility","crash","emiss","cost","maint"]
[null,"Project","Name","Metric 1","Metric 2","Metric 3","Metric 4","Metric 5","Metric 6","Metric 7","Metric 8","Metric 9","Metric 10"]
[null,null,null,2,2,2,3,3,1,1,1,1,1]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"Ranking","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Project","Name","Efficiency",{"$f":"'Input Data'!D9","v":"Metric 1"},{"$f":"'Input Data'!E9","v":"Metric 2"},{"$f":"'Input Data'!F9","v":"Metric 3"},{"$f":"'Input Data'!G9","v":"Metric 4"},{"$f":"'Input Data'!H9","v":"Metric 5"},{"$f":"'Input Data'!I9","v":"Metric 6"},{"$f":"'Input Data'!J9","v":"Metric 7"},{"$f":"'Input Data'!K9","v":"Metric 8"},{"$f":"'Input Data'!L9","v":"Metric 9"},{"$f":"'Input Data'!M9","v":"Metric 10"}]
[null,5]
[null,6]
[null,3]
[null,4]
[null,2]
[null,1]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"Example Input Data","index":2,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,10,1,11],[2,10,2,11],[8,1,9,1],[8,2,9,2]]}
["Unused","Project Evaluation Toolkit - Multiobjective Project Ranking",null,null,null,null,null,null,null,null,"Legend"]
["Benefit",null,null,null,null,null,null,null,null,null,"User Inputs"]
["Cost","Steps:",null,null,null,null,null,null,null,null,"Key Outputs"]
[null,"1. Enter evaluation categories along top row, indicating which metrics are \"benefits\" and which are \"costs\" from the drop-down menu"]
[null,"2. Enter data for each project"]
[null,"3. Click \"Rank projects\" button"]
[null,"4. Upon completion of project ranking, you will be moved to the Ranking sheet."]
[]
[null,"Project","Name","Cost","VHT","Emissions","Crashes","Equity","Revenue","Metric 7","Metric 8","Metric 9","Metric 10"]
[null,null,null,3,3,3,3,2,2,1,1,1,1]
[null,1,"Alternative A",740,91,13,5,8,103]
[null,2,"Alternative B",620,79,21,9,5,85]
[null,3,"Alternative C",319,82,47,3,2,95]
[null,4,"Alternative D",440,61,11,7,10,110]
[null,5,"Do Nothing",519,13,55,10,6,20]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"Example Ranking","index":3,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Project","Name","Efficiency","Cost","VHT","Emissions","Crashes","Equity","Revenue","Metric 7","Metric 8","Metric 9","Metric 10"]
[null,5,"Do Nothing",2.8153787769230769,519,13,55,10,6,20]
[null,4,"Alternative D",2.0900845824657122,440,61,11,7,10,110]
[null,3,"Alternative C",1.7390612147012385,319,82,47,3,2,95]
[null,1,"Alternative A",1.2204944103282622,740,91,13,5,8,103]
[null,2,"Alternative B",0.59893680347810418,620,79,21,9,5,85]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"DEA Calculations","index":4,"n_rows":44,"n_cols":46,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Input Data'!B9","v":"Project"},{"$f":"'Input Data'!C9","v":"Name"},{"$f":"'Input Data'!D9","v":"Metric 1"},{"$f":"'Input Data'!E9","v":"Metric 2"},{"$f":"'Input Data'!F9","v":"Metric 3"},{"$f":"'Input Data'!G9","v":"Metric 4"},{"$f":"'Input Data'!H9","v":"Metric 5"},{"$f":"'Input Data'!I9","v":"Metric 6"},{"$f":"'Input Data'!J9","v":"Metric 7"},{"$f":"'Input Data'!K9","v":"Metric 8"},{"$f":"'Input Data'!L9","v":"Metric 9"},{"$f":"'Input Data'!M9","v":"Metric 10"},"Efficiency","z (1)","z (2)","z (3)","z (4)","z (5)","z (6)","z (7)","z (8)","z (9)","z (10)","z (11)","z (12)","z (13)","z (14)","z (15)","z (16)","z (17)","z (18)","z (19)","z (20)","OBJECTIVE","In/Out 1","In/Out 2","In/Out 3","In/Out 4","In/Out 5","In/Out 6","In/Out 7","In/Out 8","In/Out 9","In/Out 10","delta",{"$f":"0.001/(MAX(MAX(C2:L21),-MIN(C2:L21)))","v":5.8823529411764711E-7}]
[1,"Bike Trail",500,10,150,500,40,null,null,null,null,null,0.62499999999999978,0,0,0,0,3.9999999999999991,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M2+delta*SUM(C24:L24)","v":0.62507205882352923},{"$f":"IF(C$22=\"Input\",$M2*C2-SUMPRODUCT(C$2:C$21,$N$2:$N$21)+$N2*C2-C24,IF(C$22=\"Output\",C2-SUMPRODUCT(C$2:C$21,$N$2:$N$21)+$N2*C2+C24,0))","v":-5.6843418860808015E-14},{"$f":"IF(D$22=\"Input\",$M2*D2-SUMPRODUCT(D$2:D$21,$N$2:$N$21)+$N2*D2-D24,IF(D$22=\"Output\",D2-SUMPRODUCT(D$2:D$21,$N$2:$N$21)+$N2*D2+D24,0))","v":0},0,-1.7763568394002505E-15,-7.1054273576010019E-15,0,0,0,0,0]
[2,"Sidewalks",450,10,200,700,50,null,null,null,null,null,0.66666666666666652,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M3-delta*SUM(C25:L25)","v":0.66641176470588226},{"$f":"IF(C$22=\"Input\",$M3*C3-SUMPRODUCT(C$2:C$21,$O$2:$O$21)+$O3*C3-C25,IF(C$22=\"Output\",C3-SUMPRODUCT(C$2:C$21,$O$2:$O$21)+$O3*C3+C25,0))","v":-1.7053025658242404E-13},{"$f":"IF(D$22=\"Input\",$M3*D3-SUMPRODUCT(D$2:D$21,$O$2:$O$21)+$O3*D3-D25,IF(D$22=\"Output\",D3-SUMPRODUCT(D$2:D$21,$O$2:$O$21)+$O3*D3+D25,0))","v":-3.5527136788005009E-15},-2.8421709430404007E-14,-1.7053025658242404E-13,-7.1054273576010019E-15,0,0,0,0,0]
[3,"Corridor Reconstr 1",1500,0,0,1000,150,null,null,null,null,null,0.75000000000000011,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74998267973856225,{"$f":"IF(C$22=\"Input\",$M4*C4-SUMPRODUCT(C$2:C$21,$P$2:$P$21)+$P4*C4-C26,IF(C$22=\"Output\",C4-SUMPRODUCT(C$2:C$21,$P$2:$P$21)+$P4*C4+C26,0))","v":-4.5474735088646412E-13},{"$f":"IF(D$22=\"Input\",$M4*D4-SUMPRODUCT(D$2:D$21,$P$2:$P$21)+$P4*D4-D26,IF(D$22=\"Output\",D4-SUMPRODUCT(D$2:D$21,$P$2:$P$21)+$P4*D4+D26,0))","v":-3.5527136788005009E-15},0,-1.1368683772161603E-13,-5.9952043329758453E-15,0,0,0,0,0]
[4,"Corridor Reconstr 2",1700,-10,100,1200,200,null,null,null,null,null,0.70833333333333315,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.70828842047930263,{"$f":"IF(C$22=\"Input\",$M5*C5-SUMPRODUCT(C$2:C$21,$Q$2:$Q$21)+$Q5*C5-C27,IF(C$22=\"Output\",C5-SUMPRODUCT(C$2:C$21,$Q$2:$Q$21)+$Q5*C5+C27,0))","v":4.5474735088646412E-13},{"$f":"IF(D$22=\"Input\",$M5*D5-SUMPRODUCT(D$2:D$21,$Q$2:$Q$21)+$Q5*D5-D27,IF(D$22=\"Output\",D5-SUMPRODUCT(D$2:D$21,$Q$2:$Q$21)+$Q5*D5+D27,0))","v":7.1054273576010019E-15},-2.8421709430404007E-14,0,-2.1316282072803006E-14,0,0,0,0,0]
[5,"Int. Roundabout",1200,40,300,600,50,null,null,null,null,null,3.3333333333333335,0.5,0.66666666666666674,0.55555555555555569,0.81481481481481477,0,0.83333333333333326,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3326823529411764,{"$f":"IF(C$22=\"Input\",$M6*C6-SUMPRODUCT(C$2:C$21,$R$2:$R$21)+$R6*C6-C28,IF(C$22=\"Output\",C6-SUMPRODUCT(C$2:C$21,$R$2:$R$21)+$R6*C6+C28,0))","v":3.4106051316484809E-13},{"$f":"IF(D$22=\"Input\",$M6*D6-SUMPRODUCT(D$2:D$21,$R$2:$R$21)+$R6*D6-D28,IF(D$22=\"Output\",D6-SUMPRODUCT(D$2:D$21,$R$2:$R$21)+$R6*D6+D28,0))","v":7.1054273576010019E-15},5.6843418860808015E-14,4.5474735088646412E-13,3.5527136788005009E-14,0,0,0,0,0]
[6,"Int. Signal",1000,7,-200,500,100,null,null,null,null,null,0.99999999999999989,0,0,0.83333333333333359,0.72222222222222199,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99968549019607833,{"$f":"IF(C$22=\"Input\",$M7*C7-SUMPRODUCT(C$2:C$21,$S$2:$S$21)+$S7*C7-C29,IF(C$22=\"Output\",C7-SUMPRODUCT(C$2:C$21,$S$2:$S$21)+$S7*C7+C29,0))","v":1.1368683772161603E-13},{"$f":"IF(D$22=\"Input\",$M7*D7-SUMPRODUCT(D$2:D$21,$S$2:$S$21)+$S7*D7-D29,IF(D$22=\"Output\",D7-SUMPRODUCT(D$2:D$21,$S$2:$S$21)+$S7*D7+D29,0))","v":7.1054273576010019E-15},0,0,-7.1054273576010019E-15,0,0,0,0,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M8*C8-SUMPRODUCT(C$2:C$21,$T$2:$T$21)+$T8*C8-C30,IF(C$22=\"Output\",C8-SUMPRODUCT(C$2:C$21,$T$2:$T$21)+$T8*C8+C30,0))","v":0},{"$f":"IF(D$22=\"Input\",$M8*D8-SUMPRODUCT(D$2:D$21,$T$2:$T$21)+$T8*D8-D30,IF(D$22=\"Output\",D8-SUMPRODUCT(D$2:D$21,$T$2:$T$21)+$T8*D8+D30,0))","v":0},0,0,0,0,0,0,0,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M9*C9-SUMPRODUCT(C$2:C$21,$U$2:$U$21)+$U9*C9-C31,IF(C$22=\"Output\",C9-SUMPRODUCT(C$2:C$21,$U$2:$U$21)+$U9*C9+C31,0))","v":0},{"$f":"IF(D$22=\"Input\",$M9*D9-SUMPRODUCT(D$2:D$21,$U$2:$U$21)+$U9*D9-D31,IF(D$22=\"Output\",D9-SUMPRODUCT(D$2:D$21,$U$2:$U$21)+$U9*D9+D31,0))","v":0},0,0,0,0,0,0,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M10*C10-SUMPRODUCT(C$2:C$21,$V$2:$V$21)+$V10*C10-C32,IF(C$22=\"Output\",C10-SUMPRODUCT(C$2:C$21,$V$2:$V$21)+$V10*C10+C32,0))","v":0},{"$f":"IF(D$22=\"Input\",$M10*D10-SUMPRODUCT(D$2:D$21,$V$2:$V$21)+$V10*D10-D32,IF(D$22=\"Output\",D10-SUMPRODUCT(D$2:D$21,$V$2:$V$21)+$V10*D10+D32,0))","v":0},0,0,0,0,0,0,0,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M11*C11-SUMPRODUCT(C$2:C$21,$W$2:$W$21)+$W11*C11-C33,IF(C$22=\"Output\",C11-SUMPRODUCT(C$2:C$21,$W$2:$W$21)+$W11*C11+C33,0))","v":0},{"$f":"IF(D$22=\"Input\",$M11*D11-SUMPRODUCT(D$2:D$21,$W$2:$W$21)+$W11*D11-D33,IF(D$22=\"Output\",D11-SUMPRODUCT(D$2:D$21,$W$2:$W$21)+$W11*D11+D33,0))","v":0},0,0,0,0,0,0,0,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M12*C12-SUMPRODUCT(C$2:C$21,$X$2:$X$21)+$X12*C12-C34,IF(C$22=\"Output\",C12-SUMPRODUCT(C$2:C$21,$X$2:$X$21)+$X12*C12+C34,0))","v":0},{"$f":"IF(D$22=\"Input\",$M12*D12-SUMPRODUCT(D$2:D$21,$X$2:$X$21)+$X12*D12-D34,IF(D$22=\"Output\",D12-SUMPRODUCT(D$2:D$21,$X$2:$X$21)+$X12*D12+D34,0))","v":0},0,0,0,0,0,0,0,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M13*C13-SUMPRODUCT(C$2:C$21,$Y$2:$Y$21)+$Y13*C13-C35,IF(C$22=\"Output\",C13-SUMPRODUCT(C$2:C$21,$Y$2:$Y$21)+$Y13*C13+C35,0))","v":0},{"$f":"IF(D$22=\"Input\",$M13*D13-SUMPRODUCT(D$2:D$21,$Y$2:$Y$21)+$Y13*D13-D35,IF(D$22=\"Output\",D13-SUMPRODUCT(D$2:D$21,$Y$2:$Y$21)+$Y13*D13+D35,0))","v":0},0,0,0,0,0,0,0,0]
[13,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M14*C14-SUMPRODUCT(C$2:C$21,$Z$2:$Z$21)+$Z14*C14-C36,IF(C$22=\"Output\",C14-SUMPRODUCT(C$2:C$21,$Z$2:$Z$21)+$Z14*C14+C36,0))","v":0},{"$f":"IF(D$22=\"Input\",$M14*D14-SUMPRODUCT(D$2:D$21,$Z$2:$Z$21)+$Z14*D14-D36,IF(D$22=\"Output\",D14-SUMPRODUCT(D$2:D$21,$Z$2:$Z$21)+$Z14*D14+D36,0))","v":0},0,0,0,0,0,0,0,0]
[14,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M15*C15-SUMPRODUCT(C$2:C$21,$AA$2:$AA$21)+$AA15*C15-C37,IF(C$22=\"Output\",C15-SUMPRODUCT(C$2:C$21,$AA$2:$AA$21)+$AA15*C15+C37,0))","v":0},{"$f":"IF(D$22=\"Input\",$M15*D15-SUMPRODUCT(D$2:D$21,$AA$2:$AA$21)+$AA15*D15-D37,IF(D$22=\"Output\",D15-SUMPRODUCT(D$2:D$21,$AA$2:$AA$21)+$AA15*D15+D37,0))","v":0},0,0,0,0,0,0,0,0]
[15,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M16*C16-SUMPRODUCT(C$2:C$21,$AB$2:$AB$21)+$AB16*C16-C38,IF(C$22=\"Output\",C16-SUMPRODUCT(C$2:C$21,$AB$2:$AB$21)+$AB16*C16+C38,0))","v":0},{"$f":"IF(D$22=\"Input\",$M16*D16-SUMPRODUCT(D$2:D$21,$AB$2:$AB$21)+$AB16*D16-D38,IF(D$22=\"Output\",D16-SUMPRODUCT(D$2:D$21,$AB$2:$AB$21)+$AB16*D16+D38,0))","v":0},0,0,0,0,0,0,0,0]
[16,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M17*C17-SUMPRODUCT(C$2:C$21,$AC$2:$AC$21)+$AC17*C17-C39,IF(C$22=\"Output\",C17-SUMPRODUCT(C$2:C$21,$AC$2:$AC$21)+$AC17*C17+C39,0))","v":0},{"$f":"IF(D$22=\"Input\",$M17*D17-SUMPRODUCT(D$2:D$21,$AC$2:$AC$21)+$AC17*D17-D39,IF(D$22=\"Output\",D17-SUMPRODUCT(D$2:D$21,$AC$2:$AC$21)+$AC17*D17+D39,0))","v":0},0,0,0,0,0,0,0,0]
[17,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M18*C18-SUMPRODUCT(C$2:C$21,$AD$2:$AD$21)+$AD18*C18-C40,IF(C$22=\"Output\",C18-SUMPRODUCT(C$2:C$21,$AD$2:$AD$21)+$AD18*C18+C40,0))","v":0},{"$f":"IF(D$22=\"Input\",$M18*D18-SUMPRODUCT(D$2:D$21,$AD$2:$AD$21)+$AD18*D18-D40,IF(D$22=\"Output\",D18-SUMPRODUCT(D$2:D$21,$AD$2:$AD$21)+$AD18*D18+D40,0))","v":0},0,0,0,0,0,0,0,0]
[18,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M19*C19-SUMPRODUCT(C$2:C$21,$AE$2:$AE$21)+$AE19*C19-C41,IF(C$22=\"Output\",C19-SUMPRODUCT(C$2:C$21,$AE$2:$AE$21)+$AE19*C19+C41,0))","v":0},{"$f":"IF(D$22=\"Input\",$M19*D19-SUMPRODUCT(D$2:D$21,$AE$2:$AE$21)+$AE19*D19-D41,IF(D$22=\"Output\",D19-SUMPRODUCT(D$2:D$21,$AE$2:$AE$21)+$AE19*D19+D41,0))","v":0},0,0,0,0,0,0,0,0]
[19,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M20*C20-SUMPRODUCT(C$2:C$21,$AF$2:$AF$21)+$AF20*C20-C42,IF(C$22=\"Output\",C20-SUMPRODUCT(C$2:C$21,$AF$2:$AF$21)+$AF20*C20+C42,0))","v":0},{"$f":"IF(D$22=\"Input\",$M20*D20-SUMPRODUCT(D$2:D$21,$AF$2:$AF$21)+$AF20*D20-D42,IF(D$22=\"Output\",D20-SUMPRODUCT(D$2:D$21,$AF$2:$AF$21)+$AF20*D20+D42,0))","v":0},0,0,0,0,0,0,0,0]
[20,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C$22=\"Input\",$M21*C21-SUMPRODUCT(C$2:C$21,$AG$2:$AG$21)+$AG21*C21-C43,IF(C$22=\"Output\",C21-SUMPRODUCT(C$2:C$21,$AG$2:$AG$21)+$AG21*C21+C43,0))","v":0},{"$f":"IF(D$22=\"Input\",$M21*D21-SUMPRODUCT(D$2:D$21,$AG$2:$AG$21)+$AG21*D21-D43,IF(D$22=\"Output\",D21-SUMPRODUCT(D$2:D$21,$AG$2:$AG$21)+$AG21*D21+D43,0))","v":0},0,0,0,0,0,0,0,0]
[null,null,"Output","Output","Output","Input","Input","Output"]
[null,null,"slack","slack","slack","slack","slack","slack","slack","slack","slack","slack"]
[{"$f":"A2","v":1},{"$f":"B2","v":"Bike Trail"},99.999999999999943,10,0,12.499999999999888,0,0,0,0,0,0]
[{"$f":"A3","v":2},"Sidewalks",349.99999999999994,16.666666666666668,0,66.666666666666686,0,0,0,0,0,0]
[{"$f":"A4","v":3},{"$f":"B4","v":"Corridor Reconstr 1"},0,28.055555555555561,0,0,1.3888888888888775,0,0,0,0,0]
[{"$f":"A5","v":4},"Corridor Reconstr 2",0,47.648148148148145,0,0,28.703703703703717,0,0,0,0,0]
[{"$f":"A6","v":5},"Int. Roundabout",799.99999999999989,0,299.99999999999994,0,6.6666666666666785,0,0,0,0,0]
[{"$f":"A7","v":6},"Int. Signal",0,26.333333333333336,450,0,58.333333333333329,0,0,0,0,0]
[{"$f":"A8","v":7},0]
[{"$f":"A9","v":8},0]
[{"$f":"A10","v":9},0]
[{"$f":"A11","v":10},0]
[{"$f":"A12","v":11},0]
[{"$f":"A13","v":12},0]
[{"$f":"A14","v":13},0]
[{"$f":"A15","v":14},0]
[{"$f":"A16","v":15},0]
[{"$f":"A17","v":16},0]
[{"$f":"A18","v":17},0]
[{"$f":"A19","v":18},0]
[{"$f":"A20","v":19},0]
[{"$f":"A21","v":20},0]
[null,null,8.9999999999999999E+99,8.9999999999999999E+99,8.9999999999999999E+99,8.9999999999999999E+99,8.9999999999999999E+99,0,0,0,0,0]

{"sheet":"Sheet1","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}