{"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":0,"macros":1,"external_links":0,"defined_names":120,"comments":3,"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":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Project","(Highway XX Project)"]
[null,null,null,"Scenario","(Peak Period)"]
[]
[null,null,null,"Location Information"]
[]
[null,null,null,"Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Type","Location"]

{"sheet":"Raw-Initial Volumes","index":1,"n_rows":9,"n_cols":38,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,36,5,37]]}
[null,null,null,"Project",{"$f":"project_name","v":"(Highway XX Project)"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"(Peak Period)"}]
[]
[]
[]
[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"]

{"sheet":"Balancing","index":2,"n_rows":11,"n_cols":29,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,11,7,11],[6,20,7,20],[6,9,8,10]]}
[null,"*** Do not sort this worksheet***"]
[null,"Filtering is ok, but sorting may cause errors in the Solver volumes, cumulative sums, and potentially the FINAL volumes."]
[null,"Use the Diagnostics sheet for sorting data."]
[null,"Location Information",null,null,null,null,null,null,"Balancing"]
[null,"Project",{"$f":"project_name","v":"(Highway XX Project)"},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":"(Peak Period)"},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":{"$error":"#N/A"}},"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:$N69)","v":{"$error":"#N/A"}},null,null,null,null,null,null,{"$f":"SUM($U11:$U69)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM($W11:$W69)","v":{"$error":"#N/A"}},{"$f":"_xlfn.STDEV.P($W11:$W69)","v":{"$error":"#N/A"}},{"$f":"SUM($Y11:$Y69)","v":{"$error":"#VALUE!"}},{"$f":"SUM($Z11:$Z69)","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,null,null,null,null,null,null,null,null,{"$f":"IF($K11>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$68,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$68,0)),\"\")","v":{"$error":"#N/A"}},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$68,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$68,0))","v":{"$error":"#N/A"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"IF(K11>0,L11-K11,0)","v":{"$error":"#N/A"}},{"$f":"IF(K11>0,SQRT(M11^2/K11),0)","v":{"$error":"#N/A"}},null,true,null,1,{"$f":"IF(NOT($Q11=\"Fixed\"),1+SUMPRODUCT(NOT($Q$11:$Q$69=\"Fixed\")*($V$11:$V$69>$V11)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"Capacity_Weight(K11/F11,capweight_scale)","v":{"$error":"#VALUE!"}},{"$f":"T11*R11*IF(E11=\"Secondary\",0,1)","v":{"$error":"#VALUE!"}},{"$f":"U11/network_weight*100","v":{"$error":"#VALUE!"}},{"$f":"N11*V11","v":{"$error":"#N/A"}},null,{"$f":"V11*MAX(N11-$Y$6,0)^2","v":{"$error":"#VALUE!"}},{"$f":"IF(Q11=\"Fixed\",999*(L11-K11)^2,0)","v":0}]

{"sheet":"Diagnostics","index":3,"n_rows":8,"n_cols":22,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project",{"$f":"project_name","v":"(Highway XX Project)"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"(Peak Period)"}]
[]
[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,null,null,null,null,null,null,null,null,{"$f":"INDEX(Balancing!$J$11:$J$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Balancing!$K$11:$K$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Balancing!$L$11:$L$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},{"$f":"IF($L8>0,$M8-$L8,\"\")","v":{"$error":"#N/A"}},{"$f":"IF($L8>0,SQRT($N8^2/$L8),\"\")","v":{"$error":"#N/A"}},{"$f":"INDEX(Balancing!$O$11:$O$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},null,{"$f":"INDEX(Balancing!$V$11:$V$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(Balancing!$S$11:$S$69,MATCH($F8,Balancing!$D$11:$D$69,0))","v":{"$error":"#N/A"}},null,{"$f":"M8-T8","v":{"$error":"#N/A"}}]

{"sheet":"Export To Intersection Balancer","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[4,3,4,8]]}
[]
[null,null,null,null,"Project",{"$f":"project_name","v":"(Highway XX Project)"}]
[null,null,null,null,"Scenario",{"$f":"scenario_name","v":"(Peak Period)"}]
[]
[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"]

{"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."]