{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Corridor","Raw-Initial Volumes","Balancing","Diagnostics","Export To Intersection Balancer","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":120,"comments":5,"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":"Corridor","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Project","Example 1"]
[null,null,null,"Scenario","Existing 2019 PM Peak"]
[]
[null,null,null,"Location Information"]
[]
[null,null,null,"Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Type","Location"]
[null,null,null,"EB STH 99","EB STH 99",1000,null,2,"mainline","EB STH 99, west of CTH X"]
[null,null,null,null,"EB STH 99",1001,null,1,"on","on from CTH X"]
[null,null,null,null,"EB STH 99",1002,null,2,"mainline."]
[null,null,null,null,"EB STH 99",1003,null,1,"off","off to CTH  A"]
[null,null,null,null,"EB STH 99",1004,null,2,"mainline."]
[null,null,null,null,"EB STH 99",1005,null,1,"on","on from CTH  A"]
[null,null,null,null,"EB STH 99",1006,null,2,"mainline."]
[null,null,null,null,"EB STH 99",1007,"Primary",1,"on","on from NB US 123"]
[null,null,null,null,"EB STH 99",1008,null,2,"mainline."]
[null,null,null,null,"EB STH 99",1009,null,1,"off","off to CTH B"]
[null,null,null,null,"EB STH 99",1010,null,2,"mainline."]
[null,null,null,null,"EB STH 99",1011,null,1,"on","on from CTH B"]
[null,null,null,null,"EB STH 99",1012,null,2,"mainline","EB STH 99, east of CTH B"]
[null,null,null,"NB US 123","NB US 123",2000,null,2,"mainline","NB US 123, south of STH 1"]
[null,null,null,null,"NB US 123",2001,null,1,"off","off to STH 1"]
[null,null,null,null,"NB US 123",2002,null,2,"mainline."]
[null,null,null,null,"NB US 123",2003,null,1,"on","on from STH 1"]
[null,null,null,null,"NB US 123",2004,null,2,"mainline."]
[null,null,null,null,"NB US 123",1007,"Secondary",1,"off","off to EB STH 99"]
[null,null,null,null,"NB US 123",2005,null,2,"mainline."]
[null,null,null,null,"NB US 123",2006,null,1,"off","off to STH 2"]
[null,null,null,null,"NB US 123",2007,null,2,"mainline."]
[null,null,null,null,"NB US 123",2008,null,1,"on","on from STH 2"]
[null,null,null,null,"NB US 123",2009,null,2,"mainline","NB US 123, north of STH 2"]

{"sheet":"Raw-Initial Volumes","index":1,"n_rows":33,"n_cols":38,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,36,5,37]]}
[null,null,null,"Project",{"$f":"project_name","v":"Example 1"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"Existing 2019 PM Peak"}]
[]
[]
[]
[null,null,null,"Location Information",null,null,null,null,null,null,"Raw/Initial Traffic Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Input to Volume Balancing"]
[null,null,null,null,null,null,null,null,null,null,"AADT",null,null,null,null,null,"ATR",null,null,null,"V-SPOC",null,null,null,"Tube Count 1",null,null,null,"Tube Count 2",null,null,null,"Turning Movement Count"]
[]
[null,null,"SORT","Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Type","Location","TRADAS ID","Year","AADT","K-factor","Hourly Volume","Comments","Date","Hour","Volume","Comments","Date","Hour","Volume","Comments","Date","Hour","Volume","Comments","Date","Hour","Volume","Comments","Date","Hour","Volume","Comments","Source / Comments","Raw\nVolume"]
[null,null,1,"EB STH 99","EB STH 99",1000,null,2,"mainline","EB STH 99, west of CTH X",null,null,null,null,null,null,"2019-01-01","16:00:00",2053,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S10","v":2053}]
[null,null,2,null,"EB STH 99",1001,null,1,"on","on from CTH X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-02","16:00:00",348,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA11","v":348}]
[null,null,3,null,"EB STH 99",1002,null,2,"mainline."]
[null,null,4,null,"EB STH 99",1003,null,1,"off","off to CTH  A",null,null,null,null,null,null,null,null,null,null,"2019-01-01","16:00:00",547,null,"2015-03-03","16:00:00",623,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W13","v":547}]
[null,null,5,null,"EB STH 99",1004,null,2,"mainline."]
[null,null,6,null,"EB STH 99",1005,null,1,"on","on from CTH  A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-03","16:00:00",528,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA15","v":528}]
[null,null,7,null,"EB STH 99",1006,null,2,"mainline."]
[null,null,8,null,"EB STH 99",1007,"Primary",1,"on","on from NB US 123",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-04","16:00:00",1263,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA17","v":1263}]
[null,null,9,null,"EB STH 99",1008,null,2,"mainline."]
[null,null,10,null,"EB STH 99",1009,null,1,"off","off to CTH B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-06","16:00:00",500,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA19","v":500}]
[null,null,11,null,"EB STH 99",1010,null,2,"mainline."]
[null,null,12,null,"EB STH 99",1011,null,1,"on","on from CTH B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-05","16:00:00",265,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA21","v":265}]
[null,null,13,null,"EB STH 99",1012,null,2,"mainline","EB STH 99, east of CTH B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-08","16:00:00",3175,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA22","v":3175}]
[null,null,14,"NB US 123","NB US 123",2000,null,2,"mainline","NB US 123, south of STH 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-07",null,2678,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA23","v":2678}]
[null,null,15,null,"NB US 123",2001,null,1,"off","off to STH 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-02",null,760,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA24","v":760}]
[null,null,16,null,"NB US 123",2002,null,2,"mainline."]
[null,null,17,null,"NB US 123",2003,null,1,"on","on from STH 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-02",null,907,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA26","v":907}]
[null,null,18,null,"NB US 123",2004,null,2,"mainline.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-02",null,2622,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA27","v":2622}]
[null,null,19,null,"NB US 123",1007,"Secondary",1,"off","off to EB STH 99",{"$f":"IF(NOT(K17=\"\"),K17,\"\")","v":""},{"$f":"IF(NOT(L17=\"\"),L17,\"\")","v":""},{"$f":"IF(NOT(M17=\"\"),M17,\"\")","v":""},{"$f":"IF(NOT(N17=\"\"),N17,\"\")","v":""},{"$f":"IF(NOT(O17=\"\"),O17,\"\")","v":""},{"$f":"IF(NOT(P17=\"\"),P17,\"\")","v":""},{"$f":"IF(NOT(Q17=\"\"),Q17,\"\")","v":""},{"$f":"IF(NOT(R17=\"\"),R17,\"\")","v":""},{"$f":"IF(NOT(S17=\"\"),S17,\"\")","v":""},{"$f":"IF(NOT(T17=\"\"),T17,\"\")","v":""},{"$f":"IF(NOT(U17=\"\"),U17,\"\")","v":""},{"$f":"IF(NOT(V17=\"\"),V17,\"\")","v":""},{"$f":"IF(NOT(W17=\"\"),W17,\"\")","v":""},{"$f":"IF(NOT(X17=\"\"),X17,\"\")","v":""},{"$f":"IF(NOT(Y17=\"\"),Y17,\"\")","v":"2019-04-04"},{"$f":"IF(NOT(Z17=\"\"),Z17,\"\")","v":"16:00:00"},{"$f":"IF(NOT(AA17=\"\"),AA17,\"\")","v":1263},{"$f":"IF(NOT(AB17=\"\"),AB17,\"\")","v":""},{"$f":"IF(NOT(AC17=\"\"),AC17,\"\")","v":""},{"$f":"IF(NOT(AD17=\"\"),AD17,\"\")","v":""},{"$f":"IF(NOT(AE17=\"\"),AE17,\"\")","v":""},{"$f":"IF(NOT(AF17=\"\"),AF17,\"\")","v":""},{"$f":"IF(NOT(AG17=\"\"),AG17,\"\")","v":""},{"$f":"IF(NOT(AH17=\"\"),AH17,\"\")","v":""},{"$f":"IF(NOT(AI17=\"\"),AI17,\"\")","v":""},{"$f":"IF(NOT(AJ17=\"\"),AJ17,\"\")","v":""},{"$f":"IF(NOT(AK17=\"\"),AK17,\"\")","v":"Tube"},1263]
[null,null,20,null,"NB US 123",2005,null,2,"mainline."]
[null,null,21,null,"NB US 123",2006,null,1,"off","off to STH 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-03",null,900,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA30","v":900}]
[null,null,22,null,"NB US 123",2007,null,2,"mainline."]
[null,null,23,null,"NB US 123",2008,null,1,"on","on from STH 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-03",null,761,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA32","v":761}]
[null,null,24,null,"NB US 123",2009,null,2,"mainline","NB US 123, north of STH 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-02",null,1578,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA33","v":1578}]

{"sheet":"Balancing","index":2,"n_rows":34,"n_cols":29,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,11,7,11],[6,20,7,20],[6,9,8,10]]}
[null,"*** Do not sort this worksheet***",null,null,null,null,null,null,"Green highlighted cells demonstrate user inputs.  See the notes on each highlighted cell for more info"]
[null,"Filtering is ok, but sorting may cause errors in the Solver volumes, cumulative sums, and potentially the FINAL volumes.",null,null,null,null,null,null,"The automated balancing has not been run yet.  Try runnig it, restting it, playing with the Weight Adjustments, Fixed Anchor, etc."]
[null,"Use the Diagnostics sheet for sorting data."]
[null,"Location Information",null,null,null,null,null,null,"Balancing"]
[null,"Project",{"$f":"project_name","v":"Example 1"},null,null,null,null,null,"User Inputs - Volumes",null,null,null,"Raw vs Balanced Comparison",null,null,"User Inputs - Solver",null,null,"Solver Objective & Penalty Functions"]
[null,"Scenario",{"$f":"scenario_name","v":"Existing 2019 PM Peak"},null,null,null,null,null,null,null,null,null,"Also shown on \"Diagnostics\" worksheet",null,null,null,null,null,{"$f":"total_wRNSE*W8+sd_wRNSE*X8+total_wLargeRNSE*Y8+total_fixedPenalty","v":1609.5813067727777},"Solver Objective",null,null,null,"Large RNSE Penalty Threshold",3,null,null,null,"Check for Blank Cells (show warning)"]
[null,null,null,null,null,null,null,null,null,"Selected Raw/Initial Count used to start balancing",null,"Volume Type",null,null,null,null,null,null,null,null,"Network Weight","Normalization Factors",0,0,0,null,null,null,true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"theta:",{"$f":"1/MAX(normFactor_wRNSE, 0.1)","v":10},{"$f":"1/MAX(normFactor_SD, 0.1)","v":10},{"$f":"1/MAX(normFactor_wLargeRNSE, 0.1)","v":10},null,null,null,"First Solver Run?"]
[null,null,null,null,null,null,null,null,null,null,null,"Hourly","Totals",{"$f":"SUM($N11:$N34)","v":12.03691446385152},null,null,null,null,null,null,{"$f":"SUM($U11:$U34)","v":6.4159999999999995},null,{"$f":"SUM($W11:$W34)","v":116.09069151029585},{"$f":"_xlfn.STDEV.P($W11:$W34)","v":13.411276508058663},{"$f":"SUM($Y11:$Y34)","v":31.456162658923255},{"$f":"SUM($Z11:$Z34)","v":0},null,null,true]
[null,"Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Location\nType","Location","Ramp\nSign","Source / Comments","Raw/Initial\nVolume","FINAL Balanced Volumes","Diff","RNSE","Comments","Include as a Solver Variable?","Fixed Anchor","Weight Adjustment","Global Weight\nRank","Capacity Weight","Weight Product\n(Cap. * Adj.)","Global Weight","Weighted RNSE Penalty","Weighted SD Penalty","Weighted Large RNSE Penalty","Fixed Anchor Penalty",null,null,"DO NOT USE OR DELETE THIS COLUMN"]
[null,"EB STH 99","EB STH 99",1000,null,2,"mainline","EB STH 99, west of CTH X",null,{"$f":"IF($K11>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":2053},{"$f":"K11","v":2053},{"$f":"IF(K11>0,L11-K11,0)","v":0},{"$f":"IF(K11>0,SQRT(M11^2/K11),0)","v":0},null,true,null,1,{"$f":"IF(NOT($Q11=\"Fixed\"),1+SUMPRODUCT(NOT($Q$11:$Q$34=\"Fixed\")*($V$11:$V$34>$V11)),\"\")","v":5},{"$f":"Capacity_Weight(K11/F11,capweight_scale)","v":0.51324999999999998},{"$f":"T11*R11*IF(E11=\"Secondary\",0,1)","v":0.51324999999999998},{"$f":"U11/network_weight*100","v":7.9995324189526196},{"$f":"N11*V11","v":0},null,{"$f":"V11*MAX(N11-$Y$6,0)^2","v":0},{"$f":"IF(Q11=\"Fixed\",999*(L11-K11)^2,0)","v":0}]
[null,null,"EB STH 99",1001,null,1,"on","on from CTH X",1,{"$f":"IF($K12>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D12,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D12,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":348},{"$f":"K12","v":348},0,0,null,true,null,1,14,{"$f":"Capacity_Weight(K12/F12,capweight_scale)","v":0.17399999999999999},0.17399999999999999,{"$f":"U12/network_weight*100","v":2.7119700748129678},0,null,0,0]
[null,null,"EB STH 99",1002,null,2,"mainline.",null,null,{"$f":"IF($K13>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D13,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D13,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"L11+L12","v":2401},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K13/F13,capweight_scale)","v":0},0,{"$f":"U13/network_weight*100","v":0},0,null,0,0]
[null,null,"EB STH 99",1003,null,1,"off","off to CTH  A",-1,{"$f":"IF($K14>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D14,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D14,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":547},{"$f":"K14","v":547},0,0,null,true,null,1,11,{"$f":"Capacity_Weight(K14/F14,capweight_scale)","v":0.27350000000000002},0.27350000000000002,{"$f":"U14/network_weight*100","v":4.2627805486284291},0,null,0,0]
[null,null,"EB STH 99",1004,null,2,"mainline.",null,null,{"$f":"IF($K15>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D15,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D15,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"L13-L14","v":1854},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K15/F15,capweight_scale)","v":0},0,{"$f":"U15/network_weight*100","v":0},0,null,0,0]
[null,null,"EB STH 99",1005,null,1,"on","on from CTH  A",1,{"$f":"IF($K16>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D16,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D16,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":528},{"$f":"K16","v":528},0,0,null,true,null,1,12,{"$f":"Capacity_Weight(K16/F16,capweight_scale)","v":0.26400000000000001},0.26400000000000001,{"$f":"U16/network_weight*100","v":4.1147132169576066},0,null,0,0]
[null,null,"EB STH 99",1006,null,2,"mainline.",null,null,{"$f":"IF($K17>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D17,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D17,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$11+SUMPRODUCT($I$12:I16,$L$12:L16)","v":2382},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K17/F17,capweight_scale)","v":0},0,{"$f":"U17/network_weight*100","v":0},0,null,0,0]
[null,null,"EB STH 99",1007,"Primary",1,"on","on from NB US 123",1,{"$f":"IF($K18>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D18,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D18,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":1263},{"$f":"K18","v":1263},0,0,null,true,null,1,4,{"$f":"Capacity_Weight(K18/F18,capweight_scale)","v":0.63149999999999995},0.63149999999999995,{"$f":"U18/network_weight*100","v":9.8425810473815467},0,null,0,0]
[null,null,"EB STH 99",1008,null,2,"mainline.",null,null,{"$f":"IF($K19>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D19,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D19,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$11+SUMPRODUCT($I$12:I18,$L$12:L18)","v":3645},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K19/F19,capweight_scale)","v":0},0,{"$f":"U19/network_weight*100","v":0},0,null,0,0]
[null,null,"EB STH 99",1009,null,1,"off","off to CTH B",-1,{"$f":"IF($K20>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D20,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D20,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":500},{"$f":"K20","v":500},0,0,null,true,null,1,13,{"$f":"Capacity_Weight(K20/F20,capweight_scale)","v":0.25},0.25,{"$f":"U20/network_weight*100","v":3.8965087281795512},0,null,0,0]
[null,null,"EB STH 99",1010,null,2,"mainline.",null,null,{"$f":"IF($K21>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D21,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D21,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$11+SUMPRODUCT($I$12:I20,$L$12:L20)","v":3145},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K21/F21,capweight_scale)","v":0},0,{"$f":"U21/network_weight*100","v":0},0,null,0,0]
[null,null,"EB STH 99",1011,null,1,"on","on from CTH B",1,{"$f":"IF($K22>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D22,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D22,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":265},{"$f":"K22","v":265},0,0,null,true,null,1,15,{"$f":"Capacity_Weight(K22/F22,capweight_scale)","v":0.13249999999999998},0.13249999999999998,{"$f":"U22/network_weight*100","v":2.0651496259351618},0,null,0,0]
[null,null,"EB STH 99",1012,null,2,"mainline","EB STH 99, east of CTH B",null,{"$f":"IF($K23>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D23,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D23,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":3175},{"$f":"$L$11+SUMPRODUCT($I$12:I22,$L$12:L22)","v":3410},235,4.1705755942557348,null,null,null,1,1,{"$f":"Capacity_Weight(K23/F23,capweight_scale)","v":0.79374999999999996},0.79374999999999996,{"$f":"U23/network_weight*100","v":12.371415211970076},51.595922349446539,null,16.951897324767202,0]
[null,"NB US 123","NB US 123",2000,null,2,"mainline","NB US 123, south of STH 1",null,{"$f":"IF($K24>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D24,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D24,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":2678},{"$f":"K24","v":2678},0,0,null,true,null,1,2,{"$f":"Capacity_Weight(K24/F24,capweight_scale)","v":0.66949999999999998},0.66949999999999998,{"$f":"U24/network_weight*100","v":10.434850374064839},0,null,0,0]
[null,null,"NB US 123",2001,null,1,"off","off to STH 1",-1,{"$f":"IF($K25>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D25,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D25,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":760},{"$f":"K25","v":760},0,0,null,true,null,1,10,{"$f":"Capacity_Weight(K25/F25,capweight_scale)","v":0.38},0.38,{"$f":"U25/network_weight*100","v":5.9226932668329182},0,null,0,0]
[null,null,"NB US 123",2002,null,2,"mainline.",null,null,{"$f":"IF($K26>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D26,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D26,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$24+SUMPRODUCT($I$25:I25,$L$25:L25)","v":1918},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K26/F26,capweight_scale)","v":0},0,{"$f":"U26/network_weight*100","v":0},0,null,0,0]
[null,null,"NB US 123",2003,null,1,"on","on from STH 1",1,{"$f":"IF($K27>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D27,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D27,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":907},{"$f":"K27","v":907},0,0,null,true,null,1,6,{"$f":"Capacity_Weight(K27/F27,capweight_scale)","v":0.45350000000000001},0.45350000000000001,{"$f":"U27/network_weight*100","v":7.0682668329177067},0,null,0,0]
[null,null,"NB US 123",2004,null,2,"mainline.",null,null,{"$f":"IF($K28>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D28,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D28,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":2622},{"$f":"$L$24+SUMPRODUCT($I$25:I27,$L$25:L27)","v":2825},203,3.9644203268373728,null,null,null,1,3,{"$f":"Capacity_Weight(K28/F28,capweight_scale)","v":0.65549999999999997},0.65549999999999997,{"$f":"U28/network_weight*100","v":10.216645885286784},40.503078619730331,null,9.5025694287501921,0]
[null,null,"NB US 123",1007,"Secondary",1,"off","off to EB STH 99",-1,{"$f":"IF($K29>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D29,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D29,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":1263},{"$f":"L18","v":1263},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K29/F29,capweight_scale)","v":0.63149999999999995},0,{"$f":"U29/network_weight*100","v":0},0,null,0,0]
[null,null,"NB US 123",2005,null,2,"mainline.",null,null,{"$f":"IF($K30>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D30,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D30,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$24+SUMPRODUCT($I$25:I29,$L$25:L29)","v":1562},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K30/F30,capweight_scale)","v":0},0,{"$f":"U30/network_weight*100","v":0},0,null,0,0]
[null,null,"NB US 123",2006,null,1,"off","off to STH 2",-1,{"$f":"IF($K31>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D31,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D31,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":900},{"$f":"K31","v":900},0,0,null,true,null,1,7,{"$f":"Capacity_Weight(K31/F31,capweight_scale)","v":0.45},0.45,{"$f":"U31/network_weight*100","v":7.0137157107231927},0,null,0,0]
[null,null,"NB US 123",2007,null,2,"mainline.",null,null,{"$f":"IF($K32>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D32,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D32,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":0},{"$f":"$L$24+SUMPRODUCT($I$25:I31,$L$25:L31)","v":662},0,0,null,null,null,1,16,{"$f":"Capacity_Weight(K32/F32,capweight_scale)","v":0},0,{"$f":"U32/network_weight*100","v":0},0,null,0,0]
[null,null,"NB US 123",2008,null,1,"on","on from STH 2",1,{"$f":"IF($K33>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D33,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D33,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":761},{"$f":"K33","v":761},0,0,null,true,null,1,9,{"$f":"Capacity_Weight(K33/F33,capweight_scale)","v":0.3805},0.3805,{"$f":"U33/network_weight*100","v":5.9304862842892776},0,null,0,0]
[null,null,"NB US 123",2009,null,2,"mainline","NB US 123, north of STH 2",null,{"$f":"IF($K34>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$33,MATCH($D34,'Raw-Initial Volumes'!$F$10:$F$33,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$33,MATCH($D34,'Raw-Initial Volumes'!$F$10:$F$33,0))","v":1578},{"$f":"$L$24+SUMPRODUCT($I$25:I33,$L$25:L33)","v":1423},-155,3.9019185427584118,null,null,null,1,8,{"$f":"Capacity_Weight(K34/F34,capweight_scale)","v":0.39450000000000002},0.39450000000000002,{"$f":"U34/network_weight*100","v":6.148690773067333},23.991690541118981,null,5.0016959054058585,0]

{"sheet":"Diagnostics","index":3,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project",{"$f":"project_name","v":"Example 1"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"Existing 2019 PM Peak"}]
[]
[null,null,null,"Location Information",null,null,null,null,null,null,"Raw vs Balanced Comparison",null,null,null,null,null,"Solver Diagnostics"]
[]
[null,null,"SORT","Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Type","Location","Raw Source / Comments","Raw","Balanced\nFINAL","Diff","RNSE","Comments","Solver Inputs","Input Global Weight","Input Global Weight\nRank","Solver Outputs","Final vs Solver Outputs","First Run Formula"]
[null,null,1,"EB STH 99","EB STH 99",1000,null,2,"mainline","EB STH 99, west of CTH X",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":2053},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":2053},{"$f":"IF($L8>0,$M8-$L8,\"\")","v":0},{"$f":"IF($L8>0,SQRT($N8^2/$L8),\"\")","v":0},{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":7.9995324189526196},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F8,Balancing!$D$11:$D$34,0))","v":5},null,{"$f":"M8-T8","v":2053}]
[null,null,2,null,"EB STH 99",1001,null,1,"on","on from CTH X",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":348},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":348},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":2.7119700748129678},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F9,Balancing!$D$11:$D$34,0))","v":14},null,348]
[null,null,3,null,"EB STH 99",1002,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":2401},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F10,Balancing!$D$11:$D$34,0))","v":16},null,2401]
[null,null,4,null,"EB STH 99",1003,null,1,"off","off to CTH  A",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":547},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":547},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":4.2627805486284291},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F11,Balancing!$D$11:$D$34,0))","v":11},null,547]
[null,null,5,null,"EB STH 99",1004,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":1854},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F12,Balancing!$D$11:$D$34,0))","v":16},null,1854]
[null,null,6,null,"EB STH 99",1005,null,1,"on","on from CTH  A",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":528},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":528},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":4.1147132169576066},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F13,Balancing!$D$11:$D$34,0))","v":12},null,528]
[null,null,7,null,"EB STH 99",1006,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":2382},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F14,Balancing!$D$11:$D$34,0))","v":16},null,2382]
[null,null,8,null,"EB STH 99",1007,"Primary",1,"on","on from NB US 123",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":1263},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":1263},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":9.8425810473815467},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F15,Balancing!$D$11:$D$34,0))","v":4},null,1263]
[null,null,9,null,"EB STH 99",1008,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":3645},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F16,Balancing!$D$11:$D$34,0))","v":16},null,3645]
[null,null,10,null,"EB STH 99",1009,null,1,"off","off to CTH B",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":500},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":500},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":3.8965087281795512},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F17,Balancing!$D$11:$D$34,0))","v":13},null,500]
[null,null,11,null,"EB STH 99",1010,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":3145},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F18,Balancing!$D$11:$D$34,0))","v":16},null,3145]
[null,null,12,null,"EB STH 99",1011,null,1,"on","on from CTH B",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":265},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":265},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":2.0651496259351618},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F19,Balancing!$D$11:$D$34,0))","v":15},null,265]
[null,null,13,null,"EB STH 99",1012,null,2,"mainline","EB STH 99, east of CTH B",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":3175},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":3410},235,4.1705755942557348,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":12.371415211970076},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F20,Balancing!$D$11:$D$34,0))","v":1},null,3410]
[null,null,14,"NB US 123","NB US 123",2000,null,2,"mainline","NB US 123, south of STH 1",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":2678},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":2678},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":10.434850374064839},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F21,Balancing!$D$11:$D$34,0))","v":2},null,2678]
[null,null,15,null,"NB US 123",2001,null,1,"off","off to STH 1",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":760},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":760},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":5.9226932668329182},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F22,Balancing!$D$11:$D$34,0))","v":10},null,760]
[null,null,16,null,"NB US 123",2002,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":1918},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F23,Balancing!$D$11:$D$34,0))","v":16},null,1918]
[null,null,17,null,"NB US 123",2003,null,1,"on","on from STH 1",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":907},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":907},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":7.0682668329177067},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F24,Balancing!$D$11:$D$34,0))","v":6},null,907]
[null,null,18,null,"NB US 123",2004,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":2622},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":2825},203,3.9644203268373728,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":10.216645885286784},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F25,Balancing!$D$11:$D$34,0))","v":3},null,2825]
[null,null,19,null,"NB US 123",1007,"Secondary",1,"off","off to EB STH 99",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":1263},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":1263},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":9.8425810473815467},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F26,Balancing!$D$11:$D$34,0))","v":4},null,1263]
[null,null,20,null,"NB US 123",2005,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":1562},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F27,Balancing!$D$11:$D$34,0))","v":16},null,1562]
[null,null,21,null,"NB US 123",2006,null,1,"off","off to STH 2",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":900},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":900},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":7.0137157107231927},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F28,Balancing!$D$11:$D$34,0))","v":7},null,900]
[null,null,22,null,"NB US 123",2007,null,2,"mainline.",null,{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":662},"","",{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F29,Balancing!$D$11:$D$34,0))","v":16},null,662]
[null,null,23,null,"NB US 123",2008,null,1,"on","on from STH 2",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":761},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":761},0,0,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":5.9304862842892776},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F30,Balancing!$D$11:$D$34,0))","v":9},null,761]
[null,null,24,null,"NB US 123",2009,null,2,"mainline","NB US 123, north of STH 2",{"$f":"INDEX(Balancing!$J$11:$J$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":1578},{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":1423},-155,3.9019185427584118,{"$f":"INDEX(Balancing!$O$11:$O$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":0},null,{"$f":"INDEX(Balancing!$V$11:$V$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":6.148690773067333},{"$f":"INDEX(Balancing!$S$11:$S$34,MATCH($F31,Balancing!$D$11:$D$34,0))","v":8},null,1423]

{"sheet":"Export To Intersection Balancer","index":4,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,3,4,8]]}
[]
[null,null,null,null,"Project",{"$f":"project_name","v":"Example 1"}]
[null,null,null,null,"Scenario",{"$f":"scenario_name","v":"Existing 2019 PM Peak"}]
[]
[null,null,null,"Copy this Data to the Turning Movement Balancing Workbook"]
[null,null,"LINK_ID\n(no prefix)","LINK_ID","Corridor","Corridor & Direction","Type","Location","Balanced\nVolume"]
[null,null,1000,{"$f":"\"LINK_\" & $C7","v":"LINK_1000"},"EB STH 99","EB STH 99","mainline","EB STH 99, west of CTH X",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C7,Balancing!$D$11:$D$34,0))","v":2053}]
[null,null,1001,"LINK_1001",null,"EB STH 99","on","on from CTH X",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C8,Balancing!$D$11:$D$34,0))","v":348}]
[null,null,1002,"LINK_1002",null,"EB STH 99","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C9,Balancing!$D$11:$D$34,0))","v":2401}]
[null,null,1003,"LINK_1003",null,"EB STH 99","off","off to CTH  A",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C10,Balancing!$D$11:$D$34,0))","v":547}]
[null,null,1004,"LINK_1004",null,"EB STH 99","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C11,Balancing!$D$11:$D$34,0))","v":1854}]
[null,null,1005,"LINK_1005",null,"EB STH 99","on","on from CTH  A",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C12,Balancing!$D$11:$D$34,0))","v":528}]
[null,null,1006,"LINK_1006",null,"EB STH 99","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C13,Balancing!$D$11:$D$34,0))","v":2382}]
[null,null,1007,"LINK_1007",null,"EB STH 99","on","on from NB US 123",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C14,Balancing!$D$11:$D$34,0))","v":1263}]
[null,null,1008,"LINK_1008",null,"EB STH 99","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C15,Balancing!$D$11:$D$34,0))","v":3645}]
[null,null,1009,"LINK_1009",null,"EB STH 99","off","off to CTH B",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C16,Balancing!$D$11:$D$34,0))","v":500}]
[null,null,1010,"LINK_1010",null,"EB STH 99","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C17,Balancing!$D$11:$D$34,0))","v":3145}]
[null,null,1011,"LINK_1011",null,"EB STH 99","on","on from CTH B",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C18,Balancing!$D$11:$D$34,0))","v":265}]
[null,null,1012,"LINK_1012",null,"EB STH 99","mainline","EB STH 99, east of CTH B",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C19,Balancing!$D$11:$D$34,0))","v":3410}]
[null,null,2000,"LINK_2000","NB US 123","NB US 123","mainline","NB US 123, south of STH 1",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C20,Balancing!$D$11:$D$34,0))","v":2678}]
[null,null,2001,"LINK_2001",null,"NB US 123","off","off to STH 1",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C21,Balancing!$D$11:$D$34,0))","v":760}]
[null,null,2002,"LINK_2002",null,"NB US 123","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C22,Balancing!$D$11:$D$34,0))","v":1918}]
[null,null,2003,"LINK_2003",null,"NB US 123","on","on from STH 1",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C23,Balancing!$D$11:$D$34,0))","v":907}]
[null,null,2004,"LINK_2004",null,"NB US 123","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C24,Balancing!$D$11:$D$34,0))","v":2825}]
[null,null,1007,"LINK_1007",null,"NB US 123","off","off to EB STH 99",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C25,Balancing!$D$11:$D$34,0))","v":1263}]
[null,null,2005,"LINK_2005",null,"NB US 123","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C26,Balancing!$D$11:$D$34,0))","v":1562}]
[null,null,2006,"LINK_2006",null,"NB US 123","off","off to STH 2",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C27,Balancing!$D$11:$D$34,0))","v":900}]
[null,null,2007,"LINK_2007",null,"NB US 123","mainline.",null,{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C28,Balancing!$D$11:$D$34,0))","v":662}]
[null,null,2008,"LINK_2008",null,"NB US 123","on","on from STH 2",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C29,Balancing!$D$11:$D$34,0))","v":761}]
[null,null,2009,"LINK_2009",null,"NB US 123","mainline","NB US 123, north of STH 2",{"$f":"INDEX(Balancing!$L$11:$L$34,MATCH($C30,Balancing!$D$11:$D$34,0))","v":1423}]

{"sheet":"Data Validation","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"Allowed values in Columns using \"Data Validation\" Drop-down Cells"]
[]
[null,null,null,"Corridor Worksheet",null,null,null,"Balancing Worksheet"]
[null,null,null,"Affects 2+\nCorridors?","Type",null,null,"Capacity Weight"]
[null,null,null,"Primary","on",null,null,"Hourly"]
[null,null,null,"Secondary","off",null,null,"AADT"]
[null,null,null,null,"CD"]
[null,null,null,null,"mainline"]
[null,null,null,null,"mainline."]