{"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":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":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Project","Example 2 for Freeway Balancing"]
[null,null,null,"Scenario","Year 2012 AM Peak"]
[]
[null,null,null,"Location Information"]
[]
[null,null,null,"Corridor","Corridor & Direction","Link ID","Affects 2+\nCorridors?","# of Lanes","Type","Location"]
[null,null,null,"NB I-39/90","NB I-39/90",1000,null,3,"mainline","Beltline I/C to Badger I/C"]
[null,null,null,null,"NB I-39/90",1010,"Primary",1,"off","off to WB WIS 30"]
[null,null,null,null,"NB I-39/90",1020,"Primary",1,"off","off to EB I-94"]
[null,null,null,null,"NB I-39/90",1030,null,3,"mainline.","b/n ramps"]
[null,null,null,null,"NB I-39/90",1040,"Primary",1,"on","on from EB WIS 30"]
[null,null,null,null,"NB I-39/90",1050,"Primary",2,"on","on from WB I-94"]
[null,null,null,null,"NB I-39/90",1060,null,4,"mainline","Badger to US 151"]
[null,null,null,null,"NB I-39/90",1070,null,2,"CD","off to US 151/High Crossing CD"]
[null,null,null,null,"NB I-39/90",1080,null,1,"off","CD: off to High Crossing"]
[null,null,null,null,"NB I-39/90",1090,"Primary",1,"off","CD: off to NB US 151"]
[null,null,null,null,"NB I-39/90",1100,null,1,"CD","CD: b/n ramps"]
[null,null,null,null,"NB I-39/90",1110,"Primary",1,"on","CD: on from NB US 151"]
[null,null,null,null,"NB I-39/90",1120,"Primary",1,"off","CD: off to SB US 151"]
[null,null,null,null,"NB I-39/90",1130,null,1,"CD","CD: b/n ramps"]
[null,null,null,null,"NB I-39/90",1140,"Primary",1,"on","CD: on from SB US 151"]
[null,null,null,null,"NB I-39/90",1150,null,3,"mainline.","b/n CD exit & CD entrance"]
[null,null,null,null,"NB I-39/90",1160,null,1,"CD","on from CD"]
[null,null,null,null,"NB I-39/90",1170,null,3,"mainline","US 151 to US 51"]
[null,null,null,null,"NB I-39/90",1180,null,1,"off","off to US 51"]
[null,null,null,null,"NB I-39/90",1190,null,1,"on","on from NB US 51"]
[null,null,null,null,"NB I-39/90",1200,null,1,"on","on from SB US 51"]
[null,null,null,null,"NB I-39/90",1210,null,3,"mainline","US 51 to WIS 19"]
[null,null,null,"SB I-39/90","SB I-39/90",2000,null,3,"mainline","WIS 19 to US 51"]
[null,null,null,null,"SB I-39/90",2010,null,1,"off","off to US 51"]
[null,null,null,null,"SB I-39/90",2020,null,1,"on","on from SB US 51"]
[null,null,null,null,"SB I-39/90",2030,null,1,"on","on from NB US 51"]
[null,null,null,null,"SB I-39/90",2040,null,3,"mainline","US 51 to US 151"]
[null,null,null,null,"SB I-39/90",2050,null,1,"CD","off to US 151 CD"]
[null,null,null,null,"SB I-39/90",2060,"Primary",1,"off","CD: off to SB US 151"]
[null,null,null,null,"SB I-39/90",2070,null,1,"CD","CD: b/n ramps"]
[null,null,null,null,"SB I-39/90",2080,"Primary",1,"on","CD: on from SB US 151"]
[null,null,null,null,"SB I-39/90",2090,"Primary",1,"off","CD: off to NB US 151"]
[null,null,null,null,"SB I-39/90",2100,null,1,"CD","CD: b/n ramps"]
[null,null,null,null,"SB I-39/90",2110,"Primary",1,"on","CD: on from NB US 151"]
[null,null,null,null,"SB I-39/90",2120,null,3,"mainline.","b/n CD exit & CD entrance"]
[null,null,null,null,"SB I-39/90",2130,null,1,"CD","on from CD"]
[null,null,null,null,"SB I-39/90",2140,null,1,"on","on from High Crossing"]
[null,null,null,null,"SB I-39/90",2150,null,4,"mainline","US 151 to Badger"]
[null,null,null,null,"SB I-39/90",2160,"Primary",2,"off","off to EB I-94"]
[null,null,null,null,"SB I-39/90",2170,"Primary",1,"off","off to WB WIS 30"]
[null,null,null,null,"SB I-39/90",2180,null,3,"mainline.","b/n ramps"]
[null,null,null,null,"SB I-39/90",2190,"Primary",1,"on","on from WB I-94"]
[null,null,null,null,"SB I-39/90",2200,"Primary",1,"on","on from EB WIS 30"]
[null,null,null,null,"SB I-39/90",2210,null,3,"mainline","Badger I/C to Beltline I/C"]
[null,null,null,"NB US 151","NB US 151",3000,null,3,"mainline","Frontage Rd to I-39/90/94"]
[null,null,null,null,"NB US 151",2110,"Secondary",1,"off","off to SB I-39/90/94"]
[null,null,null,null,"NB US 151",2090,"Secondary",1,"on","on from SB I-39/90/94"]
[null,null,null,null,"NB US 151",1110,"Secondary",1,"off","off to NB I-39/90/94"]
[null,null,null,null,"NB US 151",1090,"Secondary",1,"on","on from NB I-39/90/94"]
[null,null,null,null,"NB US 151",3050,null,3,"mainline","I-39/90/94 to American Pkwy"]
[null,null,null,null,"NB US 151",3060,null,1,"off","off to EB American Pkwy"]
[null,null,null,null,"NB US 151",3070,null,1,"off","off to WB American Pkwy"]
[null,null,null,null,"NB US 151",3080,null,3,"mainline.","b/n ramps"]
[null,null,null,null,"NB US 151",3090,null,1,"on","NB on from American Pkwy"]
[null,null,null,null,"NB US 151",3100,null,3,"mainline","American Pkwy to Reiner Rd"]
[null,null,null,"SB US 151","SB US 151",4000,null,3,"mainline","Reiner Rd to American Pkwy"]
[null,null,null,null,"SB US 151",4010,null,1,"CD","off to American Pkwy/High Crossing"]
[null,null,null,null,"SB US 151",4020,null,1,"off","off to WB American Pkwy"]
[null,null,null,null,"SB US 151",4030,null,1,"off","off to High Crossing"]
[null,null,null,null,"SB US 151",4040,null,1,"on","on from High Crossing"]
[null,null,null,null,"SB US 151",4050,null,3,"mainline.","b/n ramps"]
[null,null,null,null,"SB US 151",4060,null,1,"on","on from EB American Pkwy"]
[null,null,null,null,"SB US 151",4070,null,3,"mainline","American Pkwy to I-39/90/94"]
[null,null,null,null,"SB US 151",1140,"Secondary",1,"off","off to NB I-39/90/94"]
[null,null,null,null,"SB US 151",1120,"Secondary",1,"on","on from NB I-39/90/94"]
[null,null,null,null,"SB US 151",2080,"Secondary",1,"off","off to SB I-39/90/94"]
[null,null,null,null,"SB US 151",2060,"Secondary",1,"on","on from SB I-39/90/94"]
[null,null,null,null,"SB US 151",4120,null,3,"mainline","I-39/90/94 to Frontage Rd"]
[null,null,null,"EB WIS 30","EB WIS 30",5000,null,3,"mainline","Fair Oaks to US 51"]
[null,null,null,null,"EB WIS 30",5010,null,1,"off","off to US 51"]
[null,null,null,null,"EB WIS 30",5020,null,1,"on","on from US 51"]
[null,null,null,null,"EB WIS 30",5030,null,3,"mainline","US 51 to Thompson Dr"]
[null,null,null,null,"EB WIS 30",5040,null,1,"off","off to Thompson Dr"]
[null,null,null,null,"EB WIS 30",5050,null,2,"mainline","Thompson Dr to I-39/90"]
[null,null,null,null,"EB WIS 30",2200,"Secondary",1,"off","off to SB I-39/90"]
[null,null,null,null,"EB WIS 30",1040,"Secondary",1,"off","off to NB I-39/90"]
[null,null,null,null,"EB WIS 30",5080,null,2,"mainline","EB WIS 30 to EB I-94"]
[null,null,null,null,"EB WIS 30",1020,"Secondary",1,"on","on from NB I-39/90"]
[null,null,null,null,"EB WIS 30",2160,"Secondary",2,"on","on from SB I-39/90/94"]
[null,null,null,"EB I-94","EB I-94",5110,null,3,"mainline","Badger to County N"]
[null,null,null,"WB I-94","WB I-94",6000,null,3,"mainline","County N to Badger"]
[null,null,null,null,"WB I-94",1050,"Secondary",2,"off","off to NB I-39/90"]
[null,null,null,null,"WB I-94",2190,"Secondary",1,"off","off to SB I-39/90"]
[null,null,null,"WB WIS 30","WB WIS 30",6030,null,2,"mainline","EB I-94 to EB WIS 30"]
[null,null,null,null,"WB WIS 30",2170,"Secondary",1,"on","on from SB I-39/90/94"]
[null,null,null,null,"WB WIS 30",1010,"Secondary",1,"on","on from NB I-39/90"]
[null,null,null,null,"WB WIS 30",6060,null,2,"mainline","Badger to Thompson Dr"]
[null,null,null,null,"WB WIS 30",6070,null,1,"on","on from Thompson Dr"]
[null,null,null,null,"WB WIS 30",6080,null,3,"mainline","Thompson Dr to US 51"]
[null,null,null,null,"WB WIS 30",6090,null,1,"off","off to US 51"]
[null,null,null,null,"WB WIS 30",6100,null,1,"on","on from US 51"]
[null,null,null,null,"WB WIS 30",6110,null,3,"mainline","US 51 to Fair Oaks"]

{"sheet":"Raw-Initial Volumes","index":1,"n_rows":101,"n_cols":38,"rows_kept":101,"cut":false,"hidden":false,"merged":[[5,36,5,37]]}
[null,null,null,"Project",{"$f":"project_name","v":"Example 2 for Freeway Balancing"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"Year 2012 AM 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,"NB I-39/90","NB I-39/90",1000,null,3,"mainline","Beltline I/C to Badger I/C",130004,null,null,null,null,null,"2012-08-10","07:00:00",3710,null,"2012-08-10","07:00:00",3669,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S10","v":3710}]
[null,null,2,null,"NB I-39/90",1010,"Primary",1,"off","off to WB WIS 30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",504,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA11","v":504}]
[null,null,3,null,"NB I-39/90",1020,"Primary",1,"off","off to EB I-94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",409,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA12","v":409}]
[null,null,4,null,"NB I-39/90",1030,null,3,"mainline.","b/n ramps"]
[null,null,5,null,"NB I-39/90",1040,"Primary",1,"on","on from EB WIS 30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",441,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA14","v":441}]
[null,null,6,null,"NB I-39/90",1050,"Primary",2,"on","on from WB I-94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",787,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA15","v":787}]
[null,null,7,null,"NB I-39/90",1060,null,4,"mainline","Badger to US 151",null,null,null,null,null,null,"2012-08-10","07:00:00",null,null,"2012-08-10","07:00:00",3768]
[null,null,8,null,"NB I-39/90",1070,null,2,"CD","off to US 151/High Crossing CD",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",1843,null,null,null,null,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W17","v":1843}]
[null,null,9,null,"NB I-39/90",1080,null,1,"off","CD: off to High Crossing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-04-05","07:00:00",541,null,null,null,null,null,"2012-05-05","07:00:00",535,null,"TM Count",{"$f":"AA18","v":541}]
[null,null,10,null,"NB I-39/90",1090,"Primary",1,"off","CD: off to NB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",1469,null,"2010-04-05","07:00:00",1627,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W19","v":1469}]
[null,null,11,null,"NB I-39/90",1100,null,1,"CD","CD: b/n ramps"]
[null,null,12,null,"NB I-39/90",1110,"Primary",1,"on","CD: on from NB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",102,null,"2010-04-05","07:00:00",102,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W21","v":102}]
[null,null,13,null,"NB I-39/90",1120,"Primary",1,"off","CD: off to SB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",154,null,"2010-04-05","07:00:00",153,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W22","v":154}]
[null,null,14,null,"NB I-39/90",1130,null,1,"CD","CD: b/n ramps"]
[null,null,15,null,"NB I-39/90",1140,"Primary",1,"on","CD: on from SB US 151",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-04-05","07:00:00",171,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA24","v":171}]
[null,null,16,null,"NB I-39/90",1150,null,3,"mainline.","b/n CD exit & CD entrance"]
[null,null,17,null,"NB I-39/90",1160,null,1,"CD","on from CD"]
[null,null,18,null,"NB I-39/90",1170,null,3,"mainline","US 151 to US 51",130259,null,null,null,null,null,"2012-08-10","07:00:00",1785,null,"2012-08-10","07:00:00",1790,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S27","v":1785}]
[null,null,19,null,"NB I-39/90",1180,null,1,"off","off to US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",297,null,"2010-05-06","07:00:00",349,null,null,null,null,null,"2013-06-06","07:00:00",308,null,"V-SPOC",{"$f":"W28","v":297}]
[null,null,20,null,"NB I-39/90",1190,null,1,"on","on from NB US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-06","07:00:00",108,null,null,null,null,null,"2013-06-06","07:00:00",143,null,"Tube",{"$f":"AA29","v":108}]
[null,null,21,null,"NB I-39/90",1200,null,1,"on","on from SB US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-06","07:00:00",39,null,null,null,null,null,"2013-06-06","07:00:00",12,null,"Tube",{"$f":"AA30","v":39}]
[null,null,22,null,"NB I-39/90",1210,null,3,"mainline","US 51 to WIS 19",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2008-01-01","07:00:00",964,"Too Old to use"]
[null,null,23,"SB I-39/90","SB I-39/90",2000,null,3,"mainline","WIS 19 to US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2008-01-01","07:00:00",1684,"Too Old to use"]
[null,null,24,null,"SB I-39/90",2010,null,1,"off","off to US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-06","07:00:00",911,null,null,null,null,null,"2013-06-06","07:00:00",789,null,"Tube",{"$f":"AA33","v":911}]
[null,null,25,null,"SB I-39/90",2020,null,1,"on","on from SB US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-06","07:00:00",160,null,null,null,null,null,"2013-06-06","07:00:00",269,null,"Tube",{"$f":"AA34","v":160}]
[null,null,26,null,"SB I-39/90",2030,null,1,"on","on from NB US 51",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-05-06","07:00:00",153,null,null,null,null,null,"2013-06-06","07:00:00",76,null,"Tube",{"$f":"AA35","v":153}]
[null,null,27,null,"SB I-39/90",2040,null,3,"mainline","US 51 to US 151",130259,null,null,null,null,null,"2012-08-10","07:00:00",1854,null,"2012-08-10","07:00:00",1875,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S36","v":1854}]
[null,null,28,null,"SB I-39/90",2050,null,1,"CD","off to US 151 CD"]
[null,null,29,null,"SB I-39/90",2060,"Primary",1,"off","CD: off to SB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",145,null,"2010-08-08","07:00:00",154,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W38","v":145}]
[null,null,30,null,"SB I-39/90",2070,null,1,"CD","CD: b/n ramps"]
[null,null,31,null,"SB I-39/90",2080,"Primary",1,"on","CD: on from SB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",1693,null,"2010-08-08","07:00:00",1834,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W40","v":1693}]
[null,null,32,null,"SB I-39/90",2090,"Primary",1,"off","CD: off to NB US 151",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",233,null,"2010-08-08","07:00:00",266,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W41","v":233}]
[null,null,33,null,"SB I-39/90",2100,null,1,"CD","CD: b/n ramps"]
[null,null,34,null,"SB I-39/90",2110,"Primary",1,"on","CD: on from NB US 151",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-08-08","07:00:00",229,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA43","v":229}]
[null,null,35,null,"SB I-39/90",2120,null,3,"mainline.","b/n CD exit & CD entrance"]
[null,null,36,null,"SB I-39/90",2130,null,1,"CD","on from CD"]
[null,null,37,null,"SB I-39/90",2140,null,1,"on","on from High Crossing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-08-08","07:00:00",250,null,null,null,null,null,"2012-05-05","07:00:00",260,null,"Tube",{"$f":"AA46","v":250}]
[null,null,38,null,"SB I-39/90",2150,null,4,"mainline","US 151 to Badger",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",3564,null,null,null,null,null,null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W47","v":3564}]
[null,null,39,null,"SB I-39/90",2160,"Primary",2,"off","off to EB I-94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",442,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA48","v":442}]
[null,null,40,null,"SB I-39/90",2170,"Primary",1,"off","off to WB WIS 30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",844,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA49","v":844}]
[null,null,41,null,"SB I-39/90",2180,null,3,"mainline.","b/n ramps"]
[null,null,42,null,"SB I-39/90",2190,"Primary",1,"on","on from WB I-94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",912,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA51","v":912}]
[null,null,43,null,"SB I-39/90",2200,"Primary",1,"on","on from EB WIS 30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",206,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA52","v":206}]
[null,null,44,null,"SB I-39/90",2210,null,3,"mainline","Badger I/C to Beltline I/C",130004,null,null,null,null,null,"2012-08-10","07:00:00",3536,null,"2012-08-10","07:00:00",3480,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S53","v":3536}]
[null,null,45,"NB US 151","NB US 151",3000,null,3,"mainline","Frontage Rd to I-39/90/94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-05-15","07:00:00",753,null,"TM Count",{"$f":"AI54","v":753}]
[null,null,46,null,"NB US 151",2110,"Secondary",1,"off","off to SB I-39/90/94",{"$f":"IF(NOT(K43=\"\"),K43,\"\")","v":""},"","","","","","","","","","","","","","2010-08-08","07:00:00",229,"","","","","","","","","",{"$f":"IF(NOT(AK43=\"\"),AK43,\"\")","v":"Tube"},229]
[null,null,47,null,"NB US 151",2090,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"IF(NOT(K41=\"\"),K41,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",233,"","2010-08-08","07:00:00",266,"","","","","","","","","",{"$f":"IF(NOT(AK41=\"\"),AK41,\"\")","v":"V-SPOC"},233]
[null,null,48,null,"NB US 151",1110,"Secondary",1,"off","off to NB I-39/90/94",{"$f":"IF(NOT(K21=\"\"),K21,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",102,"","2010-04-05","07:00:00",102,"","","","","","","","","",{"$f":"IF(NOT(AK21=\"\"),AK21,\"\")","v":"V-SPOC"},102]
[null,null,49,null,"NB US 151",1090,"Secondary",1,"on","on from NB I-39/90/94",{"$f":"IF(NOT(K19=\"\"),K19,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",1469,"","2010-04-05","07:00:00",1627,"","","","","","","","","",{"$f":"IF(NOT(AK19=\"\"),AK19,\"\")","v":"V-SPOC"},1469]
[null,null,50,null,"NB US 151",3050,null,3,"mainline","I-39/90/94 to American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-02-02",null,2177,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA59","v":2177}]
[null,null,51,null,"NB US 151",3060,null,1,"off","off to EB American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,155,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA60","v":155}]
[null,null,52,null,"NB US 151",3070,null,1,"off","off to WB American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,910,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA61","v":910}]
[null,null,53,null,"NB US 151",3080,null,3,"mainline.","b/n ramps"]
[null,null,54,null,"NB US 151",3090,null,1,"on","NB on from American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,129,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA63","v":129}]
[null,null,55,null,"NB US 151",3100,null,3,"mainline","American Pkwy to Reiner Rd",136055,null,null,null,null,null,"2012-08-10","07:00:00",1354,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S64","v":1354}]
[null,null,56,"SB US 151","SB US 151",4000,null,3,"mainline","Reiner Rd to American Pkwy",136055,null,null,null,null,null,"2017-08-10","07:00:00",3622,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ATR",{"$f":"S65","v":3622}]
[null,null,57,null,"SB US 151",4010,null,1,"CD","off to American Pkwy/High Crossing"]
[null,null,58,null,"SB US 151",4020,null,1,"off","off to WB American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-09-09",null,271,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA67","v":271}]
[null,null,59,null,"SB US 151",4030,null,1,"off","off to High Crossing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-09-09",null,153,null,null,null,null,null,null,null,null,null,"Tube",153]
[null,null,60,null,"SB US 151",4040,null,1,"on","on from High Crossing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-09-09",null,104,null,null,null,null,null,null,null,null,null,"Tube",104]
[null,null,61,null,"SB US 151",4050,null,3,"mainline.","b/n ramps"]
[null,null,62,null,"SB US 151",4060,null,1,"on","on from EB American Pkwy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-09-09",null,349,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA71","v":349}]
[null,null,63,null,"SB US 151",4070,null,3,"mainline","American Pkwy to I-39/90/94",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-02-02",null,3382,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA72","v":3382}]
[null,null,64,null,"SB US 151",1140,"Secondary",1,"off","off to NB I-39/90/94",{"$f":"IF(NOT(K24=\"\"),K24,\"\")","v":""},"","","","","","","","","","","","","","2010-04-05","07:00:00",171,"","","","","","","","","",{"$f":"IF(NOT(AK24=\"\"),AK24,\"\")","v":"Tube"},171]
[null,null,65,null,"SB US 151",1120,"Secondary",1,"on","on from NB I-39/90/94",{"$f":"IF(NOT(K22=\"\"),K22,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",154,"","2010-04-05","07:00:00",153,"","","","","","","","","",{"$f":"IF(NOT(AK22=\"\"),AK22,\"\")","v":"V-SPOC"},154]
[null,null,66,null,"SB US 151",2080,"Secondary",1,"off","off to SB I-39/90/94",{"$f":"IF(NOT(K40=\"\"),K40,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",1693,"","2010-08-08","07:00:00",1834,"","","","","","","","","",{"$f":"IF(NOT(AK40=\"\"),AK40,\"\")","v":"V-SPOC"},1693]
[null,null,67,null,"SB US 151",2060,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"IF(NOT(K38=\"\"),K38,\"\")","v":""},"","","","","","","","","","2012-08-10","07:00:00",145,"","2010-08-08","07:00:00",154,"","","","","","","","","",{"$f":"IF(NOT(AK38=\"\"),AK38,\"\")","v":"V-SPOC"},145]
[null,null,68,null,"SB US 151",4120,null,3,"mainline","I-39/90/94 to Frontage Rd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-05-15","07:00:00",1835,null,"TM Count",{"$f":"AI77","v":1835}]
[null,null,69,"EB WIS 30","EB WIS 30",5000,null,3,"mainline","Fair Oaks to US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",667,"Seems low compared to tube count","2012-11-01","07:00:00",1377,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA78","v":1377}]
[null,null,70,null,"EB WIS 30",5010,null,1,"off","off to US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",649,null,"2010-09-09","07:00:00",646,null,null,null,null,null,"2012-07-18",null,649,null,"V-SPOC",{"$f":"AI79","v":649}]
[null,null,71,null,"EB WIS 30",5020,null,1,"on","on from US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",503,null,"2010-09-09","07:00:00",576,null,null,null,null,null,"2012-07-18",null,503,null,"V-SPOC",{"$f":"AI80","v":503}]
[null,null,72,null,"EB WIS 30",5030,null,3,"mainline","US 51 to Thompson Dr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2010-03-01","07:00:00",1020]
[null,null,73,null,"EB WIS 30",5040,null,1,"off","off to Thompson Dr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-02",null,271,null,"TM Count",{"$f":"AI82","v":271}]
[null,null,74,null,"EB WIS 30",5050,null,2,"mainline","Thompson Dr to I-39/90"]
[null,null,75,null,"EB WIS 30",2200,"Secondary",1,"off","off to SB I-39/90",{"$f":"IF(NOT(K52=\"\"),K52,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",206,"","","","","","","","","",{"$f":"IF(NOT(AK52=\"\"),AK52,\"\")","v":"Tube"},206]
[null,null,76,null,"EB WIS 30",1040,"Secondary",1,"off","off to NB I-39/90",{"$f":"IF(NOT(K14=\"\"),K14,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",441,"","","","","","","","","",{"$f":"IF(NOT(AK14=\"\"),AK14,\"\")","v":"Tube"},441]
[null,null,77,null,"EB WIS 30",5080,null,2,"mainline","EB WIS 30 to EB I-94"]
[null,null,78,null,"EB WIS 30",1020,"Secondary",1,"on","on from NB I-39/90",{"$f":"IF(NOT(K12=\"\"),K12,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",409,"","","","","","","","","",{"$f":"IF(NOT(AK12=\"\"),AK12,\"\")","v":"Tube"},409]
[null,null,79,null,"EB WIS 30",2160,"Secondary",2,"on","on from SB I-39/90/94",{"$f":"IF(NOT(K48=\"\"),K48,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",442,"","","","","","","","","",{"$f":"IF(NOT(AK48=\"\"),AK48,\"\")","v":"Tube"},442]
[null,null,80,"EB I-94","EB I-94",5110,null,3,"mainline","Badger to County N",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",1014,null,"2010-09-09","07:00:00",612,"Seems lower than V-SPOC",null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W89","v":1014}]
[null,null,81,"WB I-94","WB I-94",6000,null,3,"mainline","County N to Badger",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",2444,null,"2010-09-09","07:00:00",1589,"Seems lower than V-SPOC",null,null,null,null,null,null,null,null,"V-SPOC",{"$f":"W90","v":2444}]
[null,null,82,null,"WB I-94",1050,"Secondary",2,"off","off to NB I-39/90",{"$f":"IF(NOT(K15=\"\"),K15,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",787,"","","","","","","","","",{"$f":"IF(NOT(AK15=\"\"),AK15,\"\")","v":"Tube"},787]
[null,null,83,null,"WB I-94",2190,"Secondary",1,"off","off to SB I-39/90",{"$f":"IF(NOT(K51=\"\"),K51,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",912,"","","","","","","","","",{"$f":"IF(NOT(AK51=\"\"),AK51,\"\")","v":"Tube"},912]
[null,null,84,"WB WIS 30","WB WIS 30",6030,null,2,"mainline","EB I-94 to EB WIS 30"]
[null,null,85,null,"WB WIS 30",2170,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"IF(NOT(K49=\"\"),K49,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",844,"","","","","","","","","",{"$f":"IF(NOT(AK49=\"\"),AK49,\"\")","v":"Tube"},844]
[null,null,86,null,"WB WIS 30",1010,"Secondary",1,"on","on from NB I-39/90",{"$f":"IF(NOT(K11=\"\"),K11,\"\")","v":""},"","","","","","","","","","","","","","2010-03-01","07:00:00",504,"","","","","","","","","",{"$f":"IF(NOT(AK11=\"\"),AK11,\"\")","v":"Tube"},504]
[null,null,87,null,"WB WIS 30",6060,null,2,"mainline","Badger to Thompson Dr"]
[null,null,88,null,"WB WIS 30",6070,null,1,"on","on from Thompson Dr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-02",null,1097,null,"TM Count",{"$f":"AI97","v":1097}]
[null,null,89,null,"WB WIS 30",6080,null,3,"mainline","Thompson Dr to US 51"]
[null,null,90,null,"WB WIS 30",6090,null,1,"off","off to US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",1325,null,"2010-09-09",null,1402,null,null,null,null,null,"2012-07-18",null,1211,null,"V-SPOC",{"$f":"W99","v":1325}]
[null,null,91,null,"WB WIS 30",6100,null,1,"on","on from US 51",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",507,null,"2010-09-09",null,534,null,null,null,null,null,"2012-07-18",null,506,null,"V-SPOC",{"$f":"W100","v":507}]
[null,null,92,null,"WB WIS 30",6110,null,3,"mainline","US 51 to Fair Oaks",null,null,null,null,null,null,null,null,null,null,"2012-08-10","07:00:00",2052,"Seems low compared to tube count","2012-11-01","07:00:00",2781,null,null,null,null,null,null,null,null,null,"Tube",{"$f":"AA101","v":2781}]

{"sheet":"Balancing","index":2,"n_rows":102,"n_cols":29,"rows_kept":102,"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,"Use the Diagnostics sheet for sorting data."]
[null,"Location Information",null,null,null,null,null,null,"Balancing"]
[null,"Project",{"$f":"project_name","v":"Example 2 for Freeway Balancing"},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":"Year 2012 AM 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":3},"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",117.72099595966962,2.4868788828647284,0.14107937359016848,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":8.4946613970424863E-3},{"$f":"1/MAX(normFactor_SD, 0.1)","v":0.40211045535440904},{"$f":"1/MAX(normFactor_wLargeRNSE, 0.1)","v":7.0882083932763358},null,null,null,"First Solver Run?"]
[null,null,null,null,null,null,null,null,null,null,null,"Hourly","Totals",{"$f":"SUM($N11:$N102)","v":105.15896025213515},null,null,null,null,null,null,{"$f":"SUM($U11:$U102)","v":16.308000000000003},null,{"$f":"SUM($W11:$W102)","v":117.72099595966962},{"$f":"_xlfn.STDEV.P($W11:$W102)","v":2.4868788828647284},{"$f":"SUM($Y11:$Y102)","v":0.14107937359016848},{"$f":"SUM($Z11:$Z102)","v":0},null,null,false]
[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,"NB I-39/90","NB I-39/90",1000,null,3,"mainline","Beltline I/C to Badger I/C",null,{"$f":"IF($K11>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D11,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":3710},{"$f":"3610","v":3610},{"$f":"IF(K11>0,L11-K11,0)","v":-100},{"$f":"IF(K11>0,SQRT(M11^2/K11),0)","v":1.6417727582577963},null,true,null,2,{"$f":"IF(NOT($Q11=\"Fixed\"),1+SUMPRODUCT(NOT($Q$11:$Q$102=\"Fixed\")*($V$11:$V$102>$V11)),\"\")","v":1},{"$f":"Capacity_Weight(K11/F11,capweight_scale)","v":0.6183333333333334},{"$f":"T11*R11*IF(E11=\"Secondary\",0,1)","v":1.2366666666666668},{"$f":"U11/network_weight*100","v":7.5831902542719307},{"$f":"N11*V11","v":12.449875180149668},null,{"$f":"V11*MAX(N11-$Y$6,0)^2","v":0},{"$f":"IF(Q11=\"Fixed\",999*(L11-K11)^2,0)","v":0}]
[null,null,"NB I-39/90",1010,"Primary",1,"off","off to WB WIS 30",-1,{"$f":"IF($K12>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D12,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D12,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":504},{"$f":"570","v":570},66,2.939873661036668,null,true,null,1,24,0.252,0.252,1.5452538631346575,4.5428511318447402,null,0,0]
[null,null,"NB I-39/90",1020,"Primary",1,"off","off to EB I-94",-1,{"$f":"IF($K13>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D13,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D13,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":409},{"$f":"470","v":470},61,3.0162558762483074,null,true,null,1,29,0.20449999999999999,0.20449999999999999,1.2539857738533233,3.7823419591168674,null,3.3137014549152599E-4,0]
[null,null,"NB I-39/90",1030,null,3,"mainline.","b/n ramps",null,{"$f":"IF($K14>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D14,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D14,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$11+SUMPRODUCT(L$12:L13,$I$12:$I13)","v":2570},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1040,"Primary",1,"on","on from EB WIS 30",1,{"$f":"IF($K15>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D15,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D15,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":441},{"$f":"380","v":380},-61,2.9047619047619047,null,true,null,1,28,0.2205,0.2205,1.3520971302428253,3.9275202354672545,null,0,0]
[null,null,"NB I-39/90",1050,"Primary",2,"on","on from WB I-94",1,{"$f":"IF($K16>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D16,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D16,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":787},{"$f":"700","v":700},-87,3.1012150752279082,null,true,null,1,30,0.19674999999999998,0.19674999999999998,1.2064630856021581,3.7415015087753911,null,1.2359600769283179E-2,0]
[null,null,"NB I-39/90",1060,null,4,"mainline","Badger to US 151",null,{"$f":"IF($K17>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D17,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D17,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$11+SUMPRODUCT(L$12:L16,$I$12:$I16)","v":3650},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1070,null,2,"CD","off to US 151/High Crossing CD",null,{"$f":"IF($K18>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D18,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D18,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1843},{"$f":"SUM(L19:L20,L23)","v":1970},127,2.9582920972062303,null,null,null,1,11,0.46074999999999999,0.46074999999999999,2.825300466028942,8.3580640408864983,null,0,0]
[null,null,"NB I-39/90",1080,null,1,"off","CD: off to High Crossing",-1,{"$f":"IF($K19>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D19,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"TM Count"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D19,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":541},{"$f":"470","v":470},-71,3.0525284207856691,null,true,null,1,22,0.27050000000000002,0.27050000000000002,1.6586951189600192,5.0632139920439245,null,4.5767296103686704E-3,0]
[null,null,"NB I-39/90",1090,"Primary",1,"off","CD: off to NB US 151",-1,{"$f":"IF($K20>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D20,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D20,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1469},{"$f":"1380","v":1380},-89,2.3220903237706949,null,true,null,1,4,0.73450000000000004,0.73450000000000004,4.5039244542555794,10.458519394221089,null,0,0]
[null,null,"NB I-39/90",1100,null,1,"CD","CD: b/n ramps",null,{"$f":"IF($K21>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D21,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D21,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L18-L19-L20","v":120},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1110,"Primary",1,"on","CD: on from NB US 151",1,{"$f":"IF($K22>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D22,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D22,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":102},{"$f":"70","v":70},-32,3.1684721375253577,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.9428943693434861,null,1.7404256268311897E-2,0]
[null,null,"NB I-39/90",1120,"Primary",1,"off","CD: off to SB US 151",-1,{"$f":"IF($K23>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D23,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D23,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":154},{"$f":"120","v":120},-34,2.7397980776862929,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.6800331602197034,null,0,0]
[null,null,"NB I-39/90",1130,null,1,"CD","CD: b/n ramps",null,{"$f":"IF($K24>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D24,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D24,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L21+L22-L23","v":70},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1140,"Primary",1,"on","CD: on from SB US 151",1,{"$f":"IF($K25>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D25,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D25,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":171},{"$f":"130","v":130},-41,3.1353483628976777,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.9225830039843494,null,1.12332470806239E-2,0]
[null,null,"NB I-39/90",1150,null,3,"mainline.","b/n CD exit & CD entrance",null,{"$f":"IF($K26>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D26,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D26,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L17-L18","v":1680},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1160,null,1,"CD","on from CD",null,{"$f":"IF($K27>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D27,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D27,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"SUM(L22,L25)","v":200},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB I-39/90",1170,null,3,"mainline","US 151 to US 51",null,{"$f":"IF($K28>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D28,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D28,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1785},{"$f":"L$11+SUMPRODUCT(L$12:L27,$I$12:$I27)","v":1880},95,2.2485600745729668,null,null,null,3,2,0.29749999999999999,0.89249999999999996,5.4727740986019118,12.305861335273315,null,0,0]
[null,null,"NB I-39/90",1180,null,1,"off","off to US 51",-1,{"$f":"IF($K29>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D29,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D29,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":297},{"$f":"300","v":300},3,0.17407765595569785,null,true,null,1,33,0.14849999999999999,0.14849999999999999,0.91059602649006599,0.15851442181396325,null,0,0]
[null,null,"NB I-39/90",1190,null,1,"on","on from NB US 51",1,{"$f":"IF($K30>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D30,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D30,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":108},{"$f":"110","v":110},2,0.19245008972987526,null,true,null,1,42,0.1,0.1,0.61319597743438792,0.11800962087924652,null,0,0]
[null,null,"NB I-39/90",1200,null,1,"on","on from SB US 51",1,{"$f":"IF($K31>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D31,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D31,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":39},{"$f":"40","v":40},1,0.16012815380508713,null,true,null,1,42,0.1,0.1,0.61319597743438792,9.8189939787274402E-2,null,0,0]
[null,null,"NB I-39/90",1210,null,3,"mainline","US 51 to WIS 19",null,{"$f":"IF($K32>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D32,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D32,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$11+SUMPRODUCT(L$12:L31,$I$12:$I31)","v":1730},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,"SB I-39/90","SB I-39/90",2000,null,3,"mainline","WIS 19 to US 51",null,{"$f":"IF($K33>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D33,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D33,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"2450","v":2450},0,0,null,true,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2010,null,1,"off","off to US 51",-1,{"$f":"IF($K34>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D34,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D34,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":911},{"$f":"910","v":910},-1,3.3131478096128583E-2,null,true,null,1,13,0.45550000000000002,0.45550000000000002,2.7931076772136372,9.2539785827732202E-2,null,0,0]
[null,null,"SB I-39/90",2020,null,1,"on","on from SB US 51",1,{"$f":"IF($K35>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D35,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D35,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":160},{"$f":"160","v":160},0,0,null,true,null,1,42,0.1,0.1,0.61319597743438792,0,null,0,0]
[null,null,"SB I-39/90",2030,null,1,"on","on from NB US 51",1,{"$f":"IF($K36>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D36,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D36,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":153},{"$f":"150","v":150},-3,0.24253562503633297,null,true,null,1,42,0.1,0.1,0.61319597743438792,0.14872186965681439,null,0,0]
[null,null,"SB I-39/90",2040,null,3,"mainline","US 51 to US 151",null,{"$f":"IF($K37>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D37,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D37,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1854},{"$f":"$L$33+SUMPRODUCT($L$34:L36,$I$34:I36)","v":1850},-4,9.2897735238882354E-2,null,null,null,1,20,0.309,0.309,1.8947755702722584,0.17602035926425458,null,0,0]
[null,null,"SB I-39/90",2050,null,1,"CD","off to US 151 CD",null,{"$f":"IF($K38>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D38,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D38,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"SUM(L39,L42)","v":400},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2060,"Primary",1,"off","CD: off to SB US 151",-1,{"$f":"IF($K39>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D39,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D39,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":145},{"$f":"140","v":140},-5,0.41522739926869984,null,true,null,1,42,0.1,0.1,0.61319597743438792,0.25461577095210924,null,0,0]
[null,null,"SB I-39/90",2070,null,1,"CD","CD: b/n ramps",null,{"$f":"IF($K40>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D40,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D40,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L38-L39","v":260},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2080,"Primary",1,"on","CD: on from SB US 151",1,{"$f":"IF($K41>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D41,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D41,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1693},{"$f":"1690","v":1690},-3,7.2910953141551035E-2,null,true,null,1,3,0.84650000000000003,0.84650000000000003,5.1907039489820939,0.37845917239589738,null,0,0]
[null,null,"SB I-39/90",2090,"Primary",1,"off","CD: off to NB US 151",-1,{"$f":"IF($K42>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D42,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D42,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":233},{"$f":"260","v":260},27,1.7688288116171296,null,true,null,1,38,0.11649999999999999,0.11649999999999999,0.71437331371106183,1.2636040995425284,null,0,0]
[null,null,"SB I-39/90",2100,null,1,"CD","CD: b/n ramps",null,{"$f":"IF($K43>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D43,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D43,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L40+L41-L42","v":1690},{"$f":"IF(K43>0,L43-K43,0)","v":0},{"$f":"IF(K43>0,SQRT(M43^2/K43),0)","v":0},null,null,null,1,{"$f":"IF(NOT($Q43=\"Fixed\"),1+SUMPRODUCT(NOT($Q$11:$Q$102=\"Fixed\")*($V$11:$V$102>$V43)),\"\")","v":54},{"$f":"Capacity_Weight(K43/F43,capweight_scale)","v":0},{"$f":"T43*R43*IF(E43=\"Secondary\",0,1)","v":0},{"$f":"U43/network_weight*100","v":0},{"$f":"N43*V43","v":0},null,{"$f":"V43*MAX(N43-$Y$6,0)^2","v":0},{"$f":"IF(Q43=\"Fixed\",999*(L43-K43)^2,0)","v":0}]
[null,null,"SB I-39/90",2110,"Primary",1,"on","CD: on from NB US 151",1,{"$f":"IF($K44>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D44,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D44,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":229},{"$f":"210","v":210},-19,1.2555553408646707,null,true,null,1,39,0.11449999999999999,0.11449999999999999,0.70210939416237406,0.88153719971182698,null,0,0]
[null,null,"SB I-39/90",2120,null,3,"mainline.","b/n CD exit & CD entrance",null,{"$f":"IF($K45>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D45,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D45,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L37-L38","v":1450},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2130,null,1,"CD","on from CD",null,{"$f":"IF($K46>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D46,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D46,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"SUM(L41,L44)","v":1900},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2140,null,1,"on","on from High Crossing",1,{"$f":"IF($K47>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D47,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D47,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":250},{"$f":"250","v":250},0,0,null,true,null,1,37,0.12499999999999999,0.12499999999999999,0.76649497179298487,0,null,0,0]
[null,null,"SB I-39/90",2150,null,4,"mainline","US 151 to Badger",null,{"$f":"IF($K48>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D48,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D48,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":3564},{"$f":"L$33+SUMPRODUCT(L$34:L47,$I$34:$I47)","v":3600},36,0.60302268915552726,null,null,null,1,15,0.44550000000000001,0.44550000000000001,2.7317880794701979,1.6473301938851319,null,0,0]
[null,null,"SB I-39/90",2160,"Primary",2,"off","off to EB I-94",-1,{"$f":"IF($K49>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D49,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D49,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":442},{"$f":"380","v":380},-62,2.9490392637578631,null,true,null,1,40,0.11049999999999999,0.11049999999999999,0.67758155506499862,1.9982146102847915,null,0,0]
[null,null,"SB I-39/90",2170,"Primary",1,"off","off to WB WIS 30",-1,{"$f":"IF($K50>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D50,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D50,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":844},{"$f":"840","v":840},-4,0.13768567816430285,null,true,null,1,16,0.42199999999999999,0.42199999999999999,2.5876870247731167,0.35628744288285374,null,0,0]
[null,null,"SB I-39/90",2180,null,3,"mainline.","b/n ramps",null,{"$f":"IF($K51>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D51,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D51,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$33+SUMPRODUCT(L$34:L50,$I$34:$I50)","v":2380},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB I-39/90",2190,"Primary",1,"on","on from WB I-94",1,{"$f":"IF($K52>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D52,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D52,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":912},{"$f":"910","v":910},-2,6.6226617853252193E-2,null,true,null,1,12,0.45600000000000002,0.45600000000000002,2.7961736571008089,0.18518112424014591,null,0,0]
[null,null,"SB I-39/90",2200,"Primary",1,"on","on from EB WIS 30",1,{"$f":"IF($K53>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D53,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D53,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":206},{"$f":"240","v":240},34,2.3688922485915,null,true,null,1,41,0.10299999999999999,0.10299999999999999,0.63159185675741958,1.4961730537461642,null,0,0]
[null,null,"SB I-39/90",2210,null,3,"mainline","Badger I/C to Beltline I/C",null,{"$f":"IF($K54>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D54,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D54,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":3536},{"$f":"L$33+SUMPRODUCT(L$34:L53,$I$34:$I53)","v":3530},-6,0.10090091909944687,null,null,null,1,7,0.58933333333333338,0.58933333333333338,3.6137682936799926,0.36463254224475111,null,0,0]
[null,"NB US 151","NB US 151",3000,null,3,"mainline","Frontage Rd to I-39/90/94",null,{"$f":"IF($K55>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D55,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"TM Count"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D55,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":753},{"$f":"820","v":820},67,2.4416157322146623,null,true,null,1,36,0.1255,0.1255,0.76956095168015681,1.8789721265203585,null,0,0]
[null,null,"NB US 151",2110,"Secondary",1,"off","off to SB I-39/90/94",-1,{"$f":"IF($K56>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D56,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D56,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":229},{"$f":"L44","v":210},-19,1.2555553408646707,null,null,null,1,54,0.11449999999999999,0,0,0,null,0,0]
[null,null,"NB US 151",2090,"Secondary",1,"on","on from SB I-39/90/94",1,{"$f":"IF($K57>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D57,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D57,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":233},{"$f":"L42","v":260},27,1.7688288116171296,null,null,null,1,54,0.11649999999999999,0,0,0,null,0,0]
[null,null,"NB US 151",1110,"Secondary",1,"off","off to NB I-39/90/94",-1,{"$f":"IF($K58>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D58,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D58,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":102},{"$f":"L22","v":70},-32,3.1684721375253577,null,null,null,1,54,0.1,0,0,0,null,0,0]
[null,null,"NB US 151",1090,"Secondary",1,"on","on from NB I-39/90/94",1,{"$f":"IF($K59>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D59,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D59,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1469},{"$f":"L20","v":1380},-89,2.3220903237706949,null,null,null,1,54,0.73450000000000004,0,0,0,null,0,0]
[null,null,"NB US 151",3050,null,3,"mainline","I-39/90/94 to American Pkwy",null,{"$f":"IF($K60>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D60,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D60,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":2177},{"$f":"L$55+SUMPRODUCT(L$56:L59,$I$56:$I59)","v":2180},3,6.429719695335713E-2,null,null,null,1,18,0.36283333333333329,0.36283333333333329,2.2248794047911038,0.14305350928732158,null,0,0]
[null,null,"NB US 151",3060,null,1,"off","off to EB American Pkwy",-1,{"$f":"IF($K61>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D61,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D61,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":155},{"$f":"130","v":130},-25,2.0080483222562471,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.2313271537014021,null,0,0]
[null,null,"NB US 151",3070,null,1,"off","off to WB American Pkwy",-1,{"$f":"IF($K62>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D62,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D62,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":910},{"$f":"910","v":910},0,0,null,true,null,1,14,0.45500000000000002,0.45500000000000002,2.790041697326465,0,null,0,0]
[null,null,"NB US 151",3080,null,3,"mainline.","b/n ramps",null,{"$f":"IF($K63>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D63,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D63,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$55+SUMPRODUCT(L$56:L62,$I$56:$I62)","v":1140},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"NB US 151",3090,null,1,"on","NB on from American Pkwy",1,{"$f":"IF($K64>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D64,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D64,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":129},{"$f":"150","v":150},21,1.84894690328381,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.1337668035834005,null,0,0]
[null,null,"NB US 151",3100,null,3,"mainline","American Pkwy to Reiner Rd",null,{"$f":"IF($K65>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D65,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D65,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1354},{"$f":"L$55+SUMPRODUCT(L$56:L64,$I$56:$I64)","v":1290},-64,1.7392845606356608,null,null,null,1,27,0.22566666666666665,0.22566666666666665,1.3837789224102686,2.4067853150812319,null,0,0]
[null,"SB US 151","SB US 151",4000,null,3,"mainline","Reiner Rd to American Pkwy",null,{"$f":"IF($K66>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D66,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"ATR"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D66,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":3622},{"$f":"3550","v":3550},-72,1.1963500537601739,null,true,null,1,6,0.60366666666666657,0.60366666666666657,3.7016597171122543,4.4284808015691155,null,0,0]
[null,null,"SB US 151",4010,null,1,"CD","off to American Pkwy/High Crossing",null,{"$f":"IF($K67>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D67,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D67,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"SUM(L68:L69)","v":510},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB US 151",4020,null,1,"off","off to WB American Pkwy",-1,{"$f":"IF($K68>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D68,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D68,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":271},{"$f":"320","v":320},49,2.9765380222308564,null,true,null,1,34,0.13549999999999998,0.13549999999999998,0.83088054942359546,2.4731475472913962,null,0,0]
[null,null,"SB US 151",4030,null,1,"off","off to High Crossing",-1,{"$f":"IF($K69>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D69,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D69,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":153},{"$f":"190","v":190},37,2.9912727087814401,null,true,null,1,42,0.1,0.1,0.61319597743438792,1.8342363924340443,null,0,0]
[null,null,"SB US 151",4040,null,1,"on","on from High Crossing",1,{"$f":"IF($K70>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D70,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D70,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":104},{"$f":"70","v":70},-34,3.3339742973491284,null,true,null,1,42,0.1,0.1,0.61319597743438792,2.0443796280041253,null,6.8395162674665208E-2,0]
[null,null,"SB US 151",4050,null,3,"mainline.","b/n ramps",null,{"$f":"IF($K71>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D71,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D71,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$66+SUMPRODUCT(L$67:L70,$I$67:$I70)","v":3110},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"SB US 151",4060,null,1,"on","on from EB American Pkwy",1,{"$f":"IF($K72>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D72,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D72,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":349},{"$f":"290","v":290},-59,3.1581975926759167,null,true,null,1,31,0.17449999999999999,0.17449999999999999,1.0700269806230069,3.3793566343018604,null,2.6779007041424097E-2,0]
[null,null,"SB US 151",4070,null,3,"mainline","American Pkwy to I-39/90/94",null,{"$f":"IF($K73>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D73,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D73,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":3382},{"$f":"L$66+SUMPRODUCT(L$67:L72,$I$67:$I72)","v":3400},18,0.30951785248240898,null,null,null,1,8,0.56366666666666665,0.56366666666666665,3.4563813261384997,1.0698117254266892,null,0,0]
[null,null,"SB US 151",1140,"Secondary",1,"off","off to NB I-39/90/94",-1,{"$f":"IF($K74>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D74,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D74,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":171},{"$f":"L25","v":130},-41,3.1353483628976777,null,null,null,1,54,0.1,0,0,0,null,0,0]
[null,null,"SB US 151",1120,"Secondary",1,"on","on from NB I-39/90/94",1,{"$f":"IF($K75>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D75,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D75,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":154},{"$f":"L23","v":120},{"$f":"IF(K75>0,L75-K75,0)","v":-34},{"$f":"IF(K75>0,SQRT(M75^2/K75),0)","v":2.7397980776862929},null,null,null,1,{"$f":"IF(NOT($Q75=\"Fixed\"),1+SUMPRODUCT(NOT($Q$11:$Q$102=\"Fixed\")*($V$11:$V$102>$V75)),\"\")","v":54},{"$f":"Capacity_Weight(K75/F75,capweight_scale)","v":0.1},{"$f":"T75*R75*IF(E75=\"Secondary\",0,1)","v":0},{"$f":"U75/network_weight*100","v":0},{"$f":"N75*V75","v":0},null,{"$f":"V75*MAX(N75-$Y$6,0)^2","v":0},{"$f":"IF(Q75=\"Fixed\",999*(L75-K75)^2,0)","v":0}]
[null,null,"SB US 151",2080,"Secondary",1,"off","off to SB I-39/90/94",-1,{"$f":"IF($K76>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D76,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D76,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1693},{"$f":"L41","v":1690},-3,7.2910953141551035E-2,null,null,null,1,54,0.84650000000000003,0,0,0,null,0,0]
[null,null,"SB US 151",2060,"Secondary",1,"on","on from SB I-39/90/94",1,{"$f":"IF($K77>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D77,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D77,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":145},{"$f":"L39","v":140},-5,0.41522739926869984,null,null,null,1,54,0.1,0,0,0,null,0,0]
[null,null,"SB US 151",4120,null,3,"mainline","I-39/90/94 to Frontage Rd",null,{"$f":"IF($K78>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D78,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"TM Count"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D78,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1835},{"$f":"L$66+SUMPRODUCT(L$67:L77,$I$67:$I77)","v":1840},5,0.11672179831391769,null,null,null,1,21,0.30583333333333329,0.30583333333333329,1.8753576976535027,0.21889512295196517,null,0,0]
[null,"EB WIS 30","EB WIS 30",5000,null,3,"mainline","Fair Oaks to US 51",null,{"$f":"IF($K79>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D79,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D79,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1377},{"$f":"1380","v":1380},3,8.0845208345444328E-2,null,true,null,1,26,0.22949999999999998,0.22949999999999998,1.4072847682119201,0.113772230287463,null,0,0]
[null,null,"EB WIS 30",5010,null,1,"off","off to US 51",-1,{"$f":"IF($K80>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D80,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D80,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":649},{"$f":"650","v":650},1,3.9253433598942983E-2,null,true,null,1,19,0.32450000000000001,0.32450000000000001,1.9898209467745887,7.8107304408002176E-2,null,0,0]
[null,null,"EB WIS 30",5020,null,1,"on","on from US 51",1,{"$f":"IF($K81>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D81,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D81,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":503},{"$f":"500","v":500},-3,0.13376338862031295,null,true,null,1,25,0.2515,0.2515,1.5421878832474856,0.20628827715237122,null,0,0]
[null,null,"EB WIS 30",5030,null,3,"mainline","US 51 to Thompson Dr",null,{"$f":"IF($K82>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D82,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D82,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$79+SUMPRODUCT(L$80:L81,$I$80:$I81)","v":1230},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"EB WIS 30",5040,null,1,"off","off to Thompson Dr",-1,{"$f":"IF($K83>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D83,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"TM Count"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D83,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":271},{"$f":"270","v":270},-1,6.0745673923078697E-2,null,true,null,1,34,0.13549999999999998,0.13549999999999998,0.83088054942359546,5.0472398924314203E-2,null,0,0]
[null,null,"EB WIS 30",5050,null,2,"mainline","Thompson Dr to I-39/90",null,{"$f":"IF($K84>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D84,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D84,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$79+SUMPRODUCT(L$80:L83,$I$80:$I83)","v":960},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"EB WIS 30",2200,"Secondary",1,"off","off to SB I-39/90",-1,{"$f":"IF($K85>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D85,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D85,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":206},{"$f":"L53","v":240},34,2.3688922485915,null,null,null,1,54,0.10299999999999999,0,0,0,null,0,0]
[null,null,"EB WIS 30",1040,"Secondary",1,"off","off to NB I-39/90",-1,{"$f":"IF($K86>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D86,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D86,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":441},{"$f":"L15","v":380},-61,2.9047619047619047,null,null,null,1,54,0.2205,0,0,0,null,0,0]
[null,null,"EB WIS 30",5080,null,2,"mainline","EB WIS 30 to EB I-94",null,{"$f":"IF($K87>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D87,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D87,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$79+SUMPRODUCT(L$80:L86,$I$80:$I86)","v":340},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"EB WIS 30",1020,"Secondary",1,"on","on from NB I-39/90",1,{"$f":"IF($K88>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D88,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D88,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":409},{"$f":"L13","v":470},61,3.0162558762483074,null,null,null,1,54,0.20449999999999999,0,0,0,null,0,0]
[null,null,"EB WIS 30",2160,"Secondary",2,"on","on from SB I-39/90/94",1,{"$f":"IF($K89>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D89,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D89,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":442},{"$f":"L49","v":380},-62,2.9490392637578631,null,null,null,1,54,0.11049999999999999,0,0,0,null,0,0]
[null,"EB I-94","EB I-94",5110,null,3,"mainline","Badger to County N",null,{"$f":"IF($K90>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D90,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D90,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1014},{"$f":"1010","v":1010},-4,0.12561485860426555,null,true,null,1,32,0.16899999999999998,0.16899999999999998,1.0363012018641153,0.13017482894359131,null,0,0]
[null,"WB I-94","WB I-94",6000,null,3,"mainline","County N to Badger",null,{"$f":"IF($K91>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D91,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D91,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":2444},{"$f":"2550","v":2550},106,2.1441504942662473,null,true,null,1,17,0.40733333333333333,0.40733333333333333,2.4977516147494065,5.3555553593192569,null,0,0]
[null,null,"WB I-94",1050,"Secondary",2,"off","off to NB I-39/90",-1,{"$f":"IF($K92>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D92,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D92,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":787},{"$f":"L16","v":700},-87,3.1012150752279082,null,null,null,1,54,0.19674999999999998,0,0,0,null,0,0]
[null,null,"WB I-94",2190,"Secondary",1,"off","off to SB I-39/90",-1,{"$f":"IF($K93>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D93,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D93,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":912},{"$f":"L52","v":910},-2,6.6226617853252193E-2,null,null,null,1,54,0.45600000000000002,0,0,0,null,0,0]
[null,"WB WIS 30","WB WIS 30",6030,null,2,"mainline","EB I-94 to EB WIS 30",null,{"$f":"IF($K94>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D94,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D94,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"0","v":0},0,0,null,true,null,1,54,0,0,0,0,null,0,0]
[null,null,"WB WIS 30",2170,"Secondary",1,"on","on from SB I-39/90/94",1,{"$f":"IF($K95>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D95,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D95,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":844},{"$f":"L50","v":840},-4,0.13768567816430285,null,null,null,1,54,0.42199999999999999,0,0,0,null,0,0]
[null,null,"WB WIS 30",1010,"Secondary",1,"on","on from NB I-39/90",1,{"$f":"IF($K96>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D96,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D96,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":504},{"$f":"L12","v":570},66,2.939873661036668,null,null,null,1,54,0.252,0,0,0,null,0,0]
[null,null,"WB WIS 30",6060,null,2,"mainline","Badger to Thompson Dr",null,{"$f":"IF($K97>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D97,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D97,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$91+SUMPRODUCT(L$92:L96,$I$92:$I96)","v":2350},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"WB WIS 30",6070,null,1,"on","on from Thompson Dr",1,{"$f":"IF($K98>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D98,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"TM Count"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D98,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1097},{"$f":"1110","v":1110},13,0.39250034111545945,null,true,null,1,9,0.54849999999999999,0.54849999999999999,3.3633799362276173,1.320127772270232,null,0,0]
[null,null,"WB WIS 30",6080,null,3,"mainline","Thompson Dr to US 51",null,{"$f":"IF($K99>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D99,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":""},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D99,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":0},{"$f":"L$91+SUMPRODUCT(L$92:L98,$I$92:$I98)","v":3460},0,0,null,null,null,1,54,0,0,0,0,null,0,0]
[null,null,"WB WIS 30",6090,null,1,"off","off to US 51",-1,{"$f":"IF($K100>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D100,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D100,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":1325},{"$f":"1320","v":1320},-5,0.13736056394868904,null,true,null,1,5,0.66249999999999998,0.66249999999999998,4.0624233505028196,0.55801676242339016,null,0,0]
[null,null,"WB WIS 30",6100,null,1,"on","on from US 51",1,{"$f":"IF($K101>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D101,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"V-SPOC"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D101,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":507},{"$f":"550","v":550},43,1.9096970442426084,null,true,null,1,23,0.2535,0.2535,1.5544518027961733,2.9685320132174464,null,0,0]
[null,null,"WB WIS 30",6110,null,3,"mainline","US 51 to Fair Oaks",null,{"$f":"IF($K102>0,INDEX('Raw-Initial Volumes'!$AK$10:$AK$101,MATCH($D102,'Raw-Initial Volumes'!$F$10:$F$101,0)),\"\")","v":"Tube"},{"$f":"INDEX('Raw-Initial Volumes'!$AL$10:$AL$101,MATCH($D102,'Raw-Initial Volumes'!$F$10:$F$101,0))","v":2781},{"$f":"L$91+SUMPRODUCT(L$92:L101,$I$92:$I101)","v":2690},-91,1.7256030427653419,null,null,null,1,10,0.46350000000000002,0.46350000000000002,2.8421633554083883,4.9044457341288688,null,0,0]

{"sheet":"Diagnostics","index":3,"n_rows":99,"n_cols":22,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Project",{"$f":"project_name","v":"Example 2 for Freeway Balancing"}]
[null,null,null,"Scenario",{"$f":"scenario_name","v":"Year 2012 AM 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,"NB I-39/90","NB I-39/90",1000,null,3,"mainline","Beltline I/C to Badger I/C",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":3710},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":3610},{"$f":"IF($L8>0,$M8-$L8,\"\")","v":-100},{"$f":"IF($L8>0,SQRT($N8^2/$L8),\"\")","v":1.6417727582577963},{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":0},3650,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":7.5831902542719307},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F8,Balancing!$D$11:$D$102,0))","v":1},3610,{"$f":"M8-T8","v":0},"K11"]
[null,null,2,null,"NB I-39/90",1010,"Primary",1,"off","off to WB WIS 30",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":504},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":570},66,2.939873661036668,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":0},570,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":1.5452538631346575},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F9,Balancing!$D$11:$D$102,0))","v":24},570,0,"K12"]
[null,null,3,null,"NB I-39/90",1020,"Primary",1,"off","off to EB I-94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":409},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":470},61,3.0162558762483074,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":0},470,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":1.2539857738533233},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F10,Balancing!$D$11:$D$102,0))","v":29},470,0,"K13"]
[null,null,4,null,"NB I-39/90",1030,null,3,"mainline.","b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":2570},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":0},2610,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F11,Balancing!$D$11:$D$102,0))","v":54},2570,0,"L$11+SUMPRODUCT(L$12:L13,$I$12:$I13)"]
[null,null,5,null,"NB I-39/90",1040,"Primary",1,"on","on from EB WIS 30",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":441},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":380},-61,2.9047619047619047,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":0},380,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":1.3520971302428253},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F12,Balancing!$D$11:$D$102,0))","v":28},380,0,"K15"]
[null,null,6,null,"NB I-39/90",1050,"Primary",2,"on","on from WB I-94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":787},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":700},-87,3.1012150752279082,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":0},700,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":1.2064630856021581},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F13,Balancing!$D$11:$D$102,0))","v":30},700,0,"K16"]
[null,null,7,null,"NB I-39/90",1060,null,4,"mainline","Badger to US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":3650},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":0},3690,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F14,Balancing!$D$11:$D$102,0))","v":54},3650,0,"L$11+SUMPRODUCT(L$12:L16,$I$12:$I16)"]
[null,null,8,null,"NB I-39/90",1070,null,2,"CD","off to US 151/High Crossing CD",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":1843},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":1970},127,2.9582920972062303,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":0},1980,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":2.825300466028942},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F15,Balancing!$D$11:$D$102,0))","v":11},1970,0,"SUM(L19:L20,L23)"]
[null,null,9,null,"NB I-39/90",1080,null,1,"off","CD: off to High Crossing",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":"TM Count"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":541},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":470},-71,3.0525284207856691,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":0},470,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":1.6586951189600192},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F16,Balancing!$D$11:$D$102,0))","v":22},470,0,"K19"]
[null,null,10,null,"NB I-39/90",1090,"Primary",1,"off","CD: off to NB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":1469},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":1380},-89,2.3220903237706949,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":0},1400,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":4.5039244542555794},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F17,Balancing!$D$11:$D$102,0))","v":4},1380,0,"K20"]
[null,null,11,null,"NB I-39/90",1100,null,1,"CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":120},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":0},110,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F18,Balancing!$D$11:$D$102,0))","v":54},120,0,"L18-L19-L20"]
[null,null,12,null,"NB I-39/90",1110,"Primary",1,"on","CD: on from NB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":102},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":70},-32,3.1684721375253577,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":0},70,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F19,Balancing!$D$11:$D$102,0))","v":42},70,0,"K22"]
[null,null,13,null,"NB I-39/90",1120,"Primary",1,"off","CD: off to SB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":154},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":120},-34,2.7397980776862929,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":0},110,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F20,Balancing!$D$11:$D$102,0))","v":42},120,0,"K23"]
[null,null,14,null,"NB I-39/90",1130,null,1,"CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":70},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":0},70,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F21,Balancing!$D$11:$D$102,0))","v":54},70,0,"L21+L22-L23"]
[null,null,15,null,"NB I-39/90",1140,"Primary",1,"on","CD: on from SB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":171},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":130},-41,3.1353483628976777,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":0},130,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F22,Balancing!$D$11:$D$102,0))","v":42},130,0,"K25"]
[null,null,16,null,"NB I-39/90",1150,null,3,"mainline.","b/n CD exit & CD entrance",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":1680},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":0},1710,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F23,Balancing!$D$11:$D$102,0))","v":54},1680,0,"L17-L18"]
[null,null,17,null,"NB I-39/90",1160,null,1,"CD","on from CD",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":200},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":0},200,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F24,Balancing!$D$11:$D$102,0))","v":54},200,0,"SUM(L22,L25)"]
[null,null,18,null,"NB I-39/90",1170,null,3,"mainline","US 151 to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":1785},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":1880},95,2.2485600745729668,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":0},1910,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":5.4727740986019118},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F25,Balancing!$D$11:$D$102,0))","v":2},1880,0,"L$11+SUMPRODUCT(L$12:L27,$I$12:$I27)"]
[null,null,19,null,"NB I-39/90",1180,null,1,"off","off to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":297},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":300},3,0.17407765595569785,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":0},300,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":0.91059602649006599},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F26,Balancing!$D$11:$D$102,0))","v":33},300,0,"K29"]
[null,null,20,null,"NB I-39/90",1190,null,1,"on","on from NB US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":108},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":110},2,0.19245008972987526,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":0},110,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F27,Balancing!$D$11:$D$102,0))","v":42},110,0,"K30"]
[null,null,21,null,"NB I-39/90",1200,null,1,"on","on from SB US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":39},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":40},1,0.16012815380508713,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":0},40,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F28,Balancing!$D$11:$D$102,0))","v":42},40,0,"K31"]
[null,null,22,null,"NB I-39/90",1210,null,3,"mainline","US 51 to WIS 19",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":1730},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":0},1760,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F29,Balancing!$D$11:$D$102,0))","v":54},1730,0,"L$11+SUMPRODUCT(L$12:L31,$I$12:$I31)"]
[null,null,23,"SB I-39/90","SB I-39/90",2000,null,3,"mainline","WIS 19 to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":2450},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":0},2450,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F30,Balancing!$D$11:$D$102,0))","v":54},2450,0,2452]
[null,null,24,null,"SB I-39/90",2010,null,1,"off","off to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":911},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":910},-1,3.3131478096128583E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":0},910,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":2.7931076772136372},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F31,Balancing!$D$11:$D$102,0))","v":13},910,0,"K34"]
[null,null,25,null,"SB I-39/90",2020,null,1,"on","on from SB US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":160},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":160},0,0,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":0},160,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F32,Balancing!$D$11:$D$102,0))","v":42},160,0,"K35"]
[null,null,26,null,"SB I-39/90",2030,null,1,"on","on from NB US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":153},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":150},-3,0.24253562503633297,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":0},150,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F33,Balancing!$D$11:$D$102,0))","v":42},150,0,"K36"]
[null,null,27,null,"SB I-39/90",2040,null,3,"mainline","US 51 to US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":1854},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":1850},-4,9.2897735238882354E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":0},1850,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":1.8947755702722584},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F34,Balancing!$D$11:$D$102,0))","v":20},1850,0,"$L$33+SUMPRODUCT($L$34:L36,$I$34:I36)"]
[null,null,28,null,"SB I-39/90",2050,null,1,"CD","off to US 151 CD",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":400},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":0},400,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F35,Balancing!$D$11:$D$102,0))","v":54},400,0,"SUM(L39,L42)"]
[null,null,29,null,"SB I-39/90",2060,"Primary",1,"off","CD: off to SB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":145},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":140},-5,0.41522739926869984,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":0},140,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F36,Balancing!$D$11:$D$102,0))","v":42},140,0,"K39"]
[null,null,30,null,"SB I-39/90",2070,null,1,"CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":260},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":0},260,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F37,Balancing!$D$11:$D$102,0))","v":54},260,0,"L38-L39"]
[null,null,31,null,"SB I-39/90",2080,"Primary",1,"on","CD: on from SB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":1693},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":1690},-3,7.2910953141551035E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":0},1690,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":5.1907039489820939},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F38,Balancing!$D$11:$D$102,0))","v":3},1690,0,"K41"]
[null,null,32,null,"SB I-39/90",2090,"Primary",1,"off","CD: off to NB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":233},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":260},27,1.7688288116171296,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":0},260,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":0.71437331371106183},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F39,Balancing!$D$11:$D$102,0))","v":38},260,0,"K42"]
[null,null,33,null,"SB I-39/90",2100,null,1,"CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":1690},{"$f":"IF($L40>0,$M40-$L40,\"\")","v":""},{"$f":"IF($L40>0,SQRT($N40^2/$L40),\"\")","v":""},{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":0},1690,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F40,Balancing!$D$11:$D$102,0))","v":54},1690,{"$f":"M40-T40","v":0},"L40+L41-L42"]
[null,null,34,null,"SB I-39/90",2110,"Primary",1,"on","CD: on from NB US 151",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":229},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":210},-19,1.2555553408646707,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":0},210,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":0.70210939416237406},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F41,Balancing!$D$11:$D$102,0))","v":39},210,0,"K44"]
[null,null,35,null,"SB I-39/90",2120,null,3,"mainline.","b/n CD exit & CD entrance",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":1450},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":0},1450,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F42,Balancing!$D$11:$D$102,0))","v":54},1450,0,"L37-L38"]
[null,null,36,null,"SB I-39/90",2130,null,1,"CD","on from CD",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":1900},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":0},1900,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F43,Balancing!$D$11:$D$102,0))","v":54},1900,0,"SUM(L41,L44)"]
[null,null,37,null,"SB I-39/90",2140,null,1,"on","on from High Crossing",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":250},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":250},0,0,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":0},250,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":0.76649497179298487},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F44,Balancing!$D$11:$D$102,0))","v":37},250,0,"K47"]
[null,null,38,null,"SB I-39/90",2150,null,4,"mainline","US 151 to Badger",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":3564},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":3600},36,0.60302268915552726,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":0},3600,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":2.7317880794701979},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F45,Balancing!$D$11:$D$102,0))","v":15},3600,0,"L$33+SUMPRODUCT(L$34:L47,$I$34:$I47)"]
[null,null,39,null,"SB I-39/90",2160,"Primary",2,"off","off to EB I-94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":442},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":380},-62,2.9490392637578631,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":0},380,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":0.67758155506499862},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F46,Balancing!$D$11:$D$102,0))","v":40},380,0,"K49"]
[null,null,40,null,"SB I-39/90",2170,"Primary",1,"off","off to WB WIS 30",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":844},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":840},-4,0.13768567816430285,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":0},850,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":2.5876870247731167},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F47,Balancing!$D$11:$D$102,0))","v":16},840,0,"K50"]
[null,null,41,null,"SB I-39/90",2180,null,3,"mainline.","b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":2380},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":0},2370,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F48,Balancing!$D$11:$D$102,0))","v":54},2380,0,"L$33+SUMPRODUCT(L$34:L50,$I$34:$I50)"]
[null,null,42,null,"SB I-39/90",2190,"Primary",1,"on","on from WB I-94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":912},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":910},-2,6.6226617853252193E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":0},910,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":2.7961736571008089},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F49,Balancing!$D$11:$D$102,0))","v":12},910,0,"K52"]
[null,null,43,null,"SB I-39/90",2200,"Primary",1,"on","on from EB WIS 30",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":206},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":240},34,2.3688922485915,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":0},240,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":0.63159185675741958},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F50,Balancing!$D$11:$D$102,0))","v":41},240,0,"K53"]
[null,null,44,null,"SB I-39/90",2210,null,3,"mainline","Badger I/C to Beltline I/C",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":3536},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":3530},-6,0.10090091909944687,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":0},3520,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":3.6137682936799926},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F51,Balancing!$D$11:$D$102,0))","v":7},3530,0,"L$33+SUMPRODUCT(L$34:L53,$I$34:$I53)"]
[null,null,45,"NB US 151","NB US 151",3000,null,3,"mainline","Frontage Rd to I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":"TM Count"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":753},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":820},67,2.4416157322146623,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":0},800,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":0.76956095168015681},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F52,Balancing!$D$11:$D$102,0))","v":36},820,0,"K55"]
[null,null,46,null,"NB US 151",2110,"Secondary",1,"off","off to SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":229},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":210},-19,1.2555553408646707,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":0},210,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":0.70210939416237406},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F53,Balancing!$D$11:$D$102,0))","v":39},210,0,"L44"]
[null,null,47,null,"NB US 151",2090,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":233},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":260},27,1.7688288116171296,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":0},260,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":0.71437331371106183},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F54,Balancing!$D$11:$D$102,0))","v":38},260,0,"L42"]
[null,null,48,null,"NB US 151",1110,"Secondary",1,"off","off to NB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":102},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":70},-32,3.1684721375253577,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":0},70,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F55,Balancing!$D$11:$D$102,0))","v":42},70,0,"L22"]
[null,null,49,null,"NB US 151",1090,"Secondary",1,"on","on from NB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":1469},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":1380},-89,2.3220903237706949,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":0},1400,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":4.5039244542555794},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F56,Balancing!$D$11:$D$102,0))","v":4},1380,0,"L20"]
[null,null,50,null,"NB US 151",3050,null,3,"mainline","I-39/90/94 to American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":2177},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":2180},3,6.429719695335713E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":0},2180,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":2.2248794047911038},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F57,Balancing!$D$11:$D$102,0))","v":18},2180,0,"L$55+SUMPRODUCT(L$56:L59,$I$56:$I59)"]
[null,null,51,null,"NB US 151",3060,null,1,"off","off to EB American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":155},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":130},-25,2.0080483222562471,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":0},130,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F58,Balancing!$D$11:$D$102,0))","v":42},130,0,"K61"]
[null,null,52,null,"NB US 151",3070,null,1,"off","off to WB American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":910},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":910},0,0,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":0},910,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":2.790041697326465},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F59,Balancing!$D$11:$D$102,0))","v":14},910,0,"K62"]
[null,null,53,null,"NB US 151",3080,null,3,"mainline.","b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":1140},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":0},1140,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F60,Balancing!$D$11:$D$102,0))","v":54},1140,0,"L$55+SUMPRODUCT(L$56:L62,$I$56:$I62)"]
[null,null,54,null,"NB US 151",3090,null,1,"on","NB on from American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":129},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":150},21,1.84894690328381,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":0},150,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F61,Balancing!$D$11:$D$102,0))","v":42},150,0,"K64"]
[null,null,55,null,"NB US 151",3100,null,3,"mainline","American Pkwy to Reiner Rd",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":1354},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":1290},-64,1.7392845606356608,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":0},1290,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":1.3837789224102686},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F62,Balancing!$D$11:$D$102,0))","v":27},1290,0,"L$55+SUMPRODUCT(L$56:L64,$I$56:$I64)"]
[null,null,56,"SB US 151","SB US 151",4000,null,3,"mainline","Reiner Rd to American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":"ATR"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":3622},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":3550},-72,1.1963500537601739,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":0},3560,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":3.7016597171122543},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F63,Balancing!$D$11:$D$102,0))","v":6},3550,0,"K66"]
[null,null,57,null,"SB US 151",4010,null,1,"CD","off to American Pkwy/High Crossing",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":510},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":0},510,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F64,Balancing!$D$11:$D$102,0))","v":54},510,0,"SUM(L68:L69)"]
[null,null,58,null,"SB US 151",4020,null,1,"off","off to WB American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":271},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":320},49,2.9765380222308564,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":0},320,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":0.83088054942359546},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F65,Balancing!$D$11:$D$102,0))","v":34},320,0,"K68"]
[null,null,59,null,"SB US 151",4030,null,1,"off","off to High Crossing",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":153},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":190},37,2.9912727087814401,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":0},190,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F66,Balancing!$D$11:$D$102,0))","v":42},190,0,"K69"]
[null,null,60,null,"SB US 151",4040,null,1,"on","on from High Crossing",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":104},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":70},-34,3.3339742973491284,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":0},70,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F67,Balancing!$D$11:$D$102,0))","v":42},70,0,"K70"]
[null,null,61,null,"SB US 151",4050,null,3,"mainline.","b/n ramps",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":3110},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":0},3120,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F68,Balancing!$D$11:$D$102,0))","v":54},3110,0,"L$66+SUMPRODUCT(L$67:L70,$I$67:$I70)"]
[null,null,62,null,"SB US 151",4060,null,1,"on","on from EB American Pkwy",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":349},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":290},-59,3.1581975926759167,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":0},290,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":1.0700269806230069},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F69,Balancing!$D$11:$D$102,0))","v":31},290,0,"K72"]
[null,null,63,null,"SB US 151",4070,null,3,"mainline","American Pkwy to I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":3382},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":3400},18,0.30951785248240898,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":0},3410,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":3.4563813261384997},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F70,Balancing!$D$11:$D$102,0))","v":8},3400,0,"L$66+SUMPRODUCT(L$67:L72,$I$67:$I72)"]
[null,null,64,null,"SB US 151",1140,"Secondary",1,"off","off to NB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":171},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":130},-41,3.1353483628976777,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":0},130,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F71,Balancing!$D$11:$D$102,0))","v":42},130,0,"L25"]
[null,null,65,null,"SB US 151",1120,"Secondary",1,"on","on from NB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":154},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":120},{"$f":"IF($L72>0,$M72-$L72,\"\")","v":-34},{"$f":"IF($L72>0,SQRT($N72^2/$L72),\"\")","v":2.7397980776862929},{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":0},110,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F72,Balancing!$D$11:$D$102,0))","v":42},120,{"$f":"M72-T72","v":0},"L23"]
[null,null,66,null,"SB US 151",2080,"Secondary",1,"off","off to SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":1693},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":1690},-3,7.2910953141551035E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":0},1690,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":5.1907039489820939},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F73,Balancing!$D$11:$D$102,0))","v":3},1690,0,"L41"]
[null,null,67,null,"SB US 151",2060,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":145},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":140},-5,0.41522739926869984,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":0},140,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":0.61319597743438792},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F74,Balancing!$D$11:$D$102,0))","v":42},140,0,"L39"]
[null,null,68,null,"SB US 151",4120,null,3,"mainline","I-39/90/94 to Frontage Rd",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":"TM Count"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":1835},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":1840},5,0.11672179831391769,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":0},1840,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":1.8753576976535027},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F75,Balancing!$D$11:$D$102,0))","v":21},1840,0,"L$66+SUMPRODUCT(L$67:L77,$I$67:$I77)"]
[null,null,69,"EB WIS 30","EB WIS 30",5000,null,3,"mainline","Fair Oaks to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":1377},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":1380},3,8.0845208345444328E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":0},1380,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":1.4072847682119201},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F76,Balancing!$D$11:$D$102,0))","v":26},1380,0,"K79"]
[null,null,70,null,"EB WIS 30",5010,null,1,"off","off to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":649},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":650},1,3.9253433598942983E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":0},650,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":1.9898209467745887},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F77,Balancing!$D$11:$D$102,0))","v":19},650,0,"K80"]
[null,null,71,null,"EB WIS 30",5020,null,1,"on","on from US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":503},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":500},-3,0.13376338862031295,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":0},500,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":1.5421878832474856},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F78,Balancing!$D$11:$D$102,0))","v":25},500,0,"K81"]
[null,null,72,null,"EB WIS 30",5030,null,3,"mainline","US 51 to Thompson Dr",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":1230},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":0},1230,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F79,Balancing!$D$11:$D$102,0))","v":54},1230,0,"L$79+SUMPRODUCT(L$80:L81,$I$80:$I81)"]
[null,null,73,null,"EB WIS 30",5040,null,1,"off","off to Thompson Dr",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":"TM Count"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":271},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":270},-1,6.0745673923078697E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":0},270,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":0.83088054942359546},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F80,Balancing!$D$11:$D$102,0))","v":34},270,0,"K83"]
[null,null,74,null,"EB WIS 30",5050,null,2,"mainline","Thompson Dr to I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":960},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":0},960,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F81,Balancing!$D$11:$D$102,0))","v":54},960,0,"L$79+SUMPRODUCT(L$80:L83,$I$80:$I83)"]
[null,null,75,null,"EB WIS 30",2200,"Secondary",1,"off","off to SB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":206},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":240},34,2.3688922485915,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":0},240,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":0.63159185675741958},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F82,Balancing!$D$11:$D$102,0))","v":41},240,0,"L53"]
[null,null,76,null,"EB WIS 30",1040,"Secondary",1,"off","off to NB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":441},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":380},-61,2.9047619047619047,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":0},380,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":1.3520971302428253},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F83,Balancing!$D$11:$D$102,0))","v":28},380,0,"L15"]
[null,null,77,null,"EB WIS 30",5080,null,2,"mainline","EB WIS 30 to EB I-94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":340},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":0},340,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F84,Balancing!$D$11:$D$102,0))","v":54},340,0,"L$79+SUMPRODUCT(L$80:L86,$I$80:$I86)"]
[null,null,78,null,"EB WIS 30",1020,"Secondary",1,"on","on from NB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":409},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":470},61,3.0162558762483074,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":0},470,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":1.2539857738533233},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F85,Balancing!$D$11:$D$102,0))","v":29},470,0,"L13"]
[null,null,79,null,"EB WIS 30",2160,"Secondary",2,"on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":442},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":380},-62,2.9490392637578631,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":0},380,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":0.67758155506499862},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F86,Balancing!$D$11:$D$102,0))","v":40},380,0,"L49"]
[null,null,80,"EB I-94","EB I-94",5110,null,3,"mainline","Badger to County N",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":1014},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":1010},-4,0.12561485860426555,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":0},1010,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":1.0363012018641153},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F87,Balancing!$D$11:$D$102,0))","v":32},1010,0,"K90"]
[null,null,81,"WB I-94","WB I-94",6000,null,3,"mainline","County N to Badger",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":2444},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":2550},106,2.1441504942662473,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":0},2530,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":2.4977516147494065},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F88,Balancing!$D$11:$D$102,0))","v":17},2550,0,"K91"]
[null,null,82,null,"WB I-94",1050,"Secondary",2,"off","off to NB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":787},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":700},-87,3.1012150752279082,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":0},700,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":1.2064630856021581},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F89,Balancing!$D$11:$D$102,0))","v":30},700,0,"L16"]
[null,null,83,null,"WB I-94",2190,"Secondary",1,"off","off to SB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":912},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":910},-2,6.6226617853252193E-2,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":0},910,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":2.7961736571008089},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F90,Balancing!$D$11:$D$102,0))","v":12},910,0,"L52"]
[null,null,84,"WB WIS 30","WB WIS 30",6030,null,2,"mainline","EB I-94 to EB WIS 30",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":0},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":0},0,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F91,Balancing!$D$11:$D$102,0))","v":54},0,0,"K94"]
[null,null,85,null,"WB WIS 30",2170,"Secondary",1,"on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":844},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":840},-4,0.13768567816430285,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":0},850,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":2.5876870247731167},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F92,Balancing!$D$11:$D$102,0))","v":16},840,0,"L50"]
[null,null,86,null,"WB WIS 30",1010,"Secondary",1,"on","on from NB I-39/90",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":504},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":570},66,2.939873661036668,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":0},570,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":1.5452538631346575},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F93,Balancing!$D$11:$D$102,0))","v":24},570,0,"L12"]
[null,null,87,null,"WB WIS 30",6060,null,2,"mainline","Badger to Thompson Dr",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":2350},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":0},2340,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F94,Balancing!$D$11:$D$102,0))","v":54},2350,0,"L$91+SUMPRODUCT(L$92:L96,$I$92:$I96)"]
[null,null,88,null,"WB WIS 30",6070,null,1,"on","on from Thompson Dr",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":"TM Count"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":1097},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":1110},13,0.39250034111545945,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":0},1110,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":3.3633799362276173},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F95,Balancing!$D$11:$D$102,0))","v":9},1110,0,"K98"]
[null,null,89,null,"WB WIS 30",6080,null,3,"mainline","Thompson Dr to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":""},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":3460},"","",{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":0},3450,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":0},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F96,Balancing!$D$11:$D$102,0))","v":54},3460,0,"L$91+SUMPRODUCT(L$92:L98,$I$92:$I98)"]
[null,null,90,null,"WB WIS 30",6090,null,1,"off","off to US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":1325},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":1320},-5,0.13736056394868904,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":0},1320,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":4.0624233505028196},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F97,Balancing!$D$11:$D$102,0))","v":5},1320,0,"K100"]
[null,null,91,null,"WB WIS 30",6100,null,1,"on","on from US 51",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":"V-SPOC"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":507},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":550},43,1.9096970442426084,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":0},550,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":1.5544518027961733},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F98,Balancing!$D$11:$D$102,0))","v":23},550,0,"K101"]
[null,null,92,null,"WB WIS 30",6110,null,3,"mainline","US 51 to Fair Oaks",{"$f":"INDEX(Balancing!$J$11:$J$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":"Tube"},{"$f":"INDEX(Balancing!$K$11:$K$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":2781},{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":2690},-91,1.7256030427653419,{"$f":"INDEX(Balancing!$O$11:$O$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":0},2680,{"$f":"INDEX(Balancing!$V$11:$V$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":2.8421633554083883},{"$f":"INDEX(Balancing!$S$11:$S$102,MATCH($F99,Balancing!$D$11:$D$102,0))","v":10},2690,0,"L$91+SUMPRODUCT(L$92:L101,$I$92:$I101)"]

{"sheet":"Export To Intersection Balancer","index":4,"n_rows":98,"n_cols":9,"rows_kept":98,"cut":false,"hidden":false,"merged":[[4,3,4,8]]}
[]
[null,null,null,null,"Project",{"$f":"project_name","v":"Example 2 for Freeway Balancing"}]
[null,null,null,null,"Scenario",{"$f":"scenario_name","v":"Year 2012 AM 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"},"NB I-39/90","NB I-39/90","mainline","Beltline I/C to Badger I/C",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C7,Balancing!$D$11:$D$102,0))","v":3610}]
[null,null,1010,"LINK_1010",null,"NB I-39/90","off","off to WB WIS 30",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C8,Balancing!$D$11:$D$102,0))","v":570}]
[null,null,1020,"LINK_1020",null,"NB I-39/90","off","off to EB I-94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C9,Balancing!$D$11:$D$102,0))","v":470}]
[null,null,1030,"LINK_1030",null,"NB I-39/90","mainline.","b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C10,Balancing!$D$11:$D$102,0))","v":2570}]
[null,null,1040,"LINK_1040",null,"NB I-39/90","on","on from EB WIS 30",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C11,Balancing!$D$11:$D$102,0))","v":380}]
[null,null,1050,"LINK_1050",null,"NB I-39/90","on","on from WB I-94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C12,Balancing!$D$11:$D$102,0))","v":700}]
[null,null,1060,"LINK_1060",null,"NB I-39/90","mainline","Badger to US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C13,Balancing!$D$11:$D$102,0))","v":3650}]
[null,null,1070,"LINK_1070",null,"NB I-39/90","CD","off to US 151/High Crossing CD",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C14,Balancing!$D$11:$D$102,0))","v":1970}]
[null,null,1080,"LINK_1080",null,"NB I-39/90","off","CD: off to High Crossing",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C15,Balancing!$D$11:$D$102,0))","v":470}]
[null,null,1090,"LINK_1090",null,"NB I-39/90","off","CD: off to NB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C16,Balancing!$D$11:$D$102,0))","v":1380}]
[null,null,1100,"LINK_1100",null,"NB I-39/90","CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C17,Balancing!$D$11:$D$102,0))","v":120}]
[null,null,1110,"LINK_1110",null,"NB I-39/90","on","CD: on from NB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C18,Balancing!$D$11:$D$102,0))","v":70}]
[null,null,1120,"LINK_1120",null,"NB I-39/90","off","CD: off to SB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C19,Balancing!$D$11:$D$102,0))","v":120}]
[null,null,1130,"LINK_1130",null,"NB I-39/90","CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C20,Balancing!$D$11:$D$102,0))","v":70}]
[null,null,1140,"LINK_1140",null,"NB I-39/90","on","CD: on from SB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C21,Balancing!$D$11:$D$102,0))","v":130}]
[null,null,1150,"LINK_1150",null,"NB I-39/90","mainline.","b/n CD exit & CD entrance",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C22,Balancing!$D$11:$D$102,0))","v":1680}]
[null,null,1160,"LINK_1160",null,"NB I-39/90","CD","on from CD",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C23,Balancing!$D$11:$D$102,0))","v":200}]
[null,null,1170,"LINK_1170",null,"NB I-39/90","mainline","US 151 to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C24,Balancing!$D$11:$D$102,0))","v":1880}]
[null,null,1180,"LINK_1180",null,"NB I-39/90","off","off to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C25,Balancing!$D$11:$D$102,0))","v":300}]
[null,null,1190,"LINK_1190",null,"NB I-39/90","on","on from NB US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C26,Balancing!$D$11:$D$102,0))","v":110}]
[null,null,1200,"LINK_1200",null,"NB I-39/90","on","on from SB US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C27,Balancing!$D$11:$D$102,0))","v":40}]
[null,null,1210,"LINK_1210",null,"NB I-39/90","mainline","US 51 to WIS 19",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C28,Balancing!$D$11:$D$102,0))","v":1730}]
[null,null,2000,"LINK_2000","SB I-39/90","SB I-39/90","mainline","WIS 19 to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C29,Balancing!$D$11:$D$102,0))","v":2450}]
[null,null,2010,"LINK_2010",null,"SB I-39/90","off","off to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C30,Balancing!$D$11:$D$102,0))","v":910}]
[null,null,2020,"LINK_2020",null,"SB I-39/90","on","on from SB US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C31,Balancing!$D$11:$D$102,0))","v":160}]
[null,null,2030,"LINK_2030",null,"SB I-39/90","on","on from NB US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C32,Balancing!$D$11:$D$102,0))","v":150}]
[null,null,2040,"LINK_2040",null,"SB I-39/90","mainline","US 51 to US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C33,Balancing!$D$11:$D$102,0))","v":1850}]
[null,null,2050,"LINK_2050",null,"SB I-39/90","CD","off to US 151 CD",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C34,Balancing!$D$11:$D$102,0))","v":400}]
[null,null,2060,"LINK_2060",null,"SB I-39/90","off","CD: off to SB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C35,Balancing!$D$11:$D$102,0))","v":140}]
[null,null,2070,"LINK_2070",null,"SB I-39/90","CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C36,Balancing!$D$11:$D$102,0))","v":260}]
[null,null,2080,"LINK_2080",null,"SB I-39/90","on","CD: on from SB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C37,Balancing!$D$11:$D$102,0))","v":1690}]
[null,null,2090,"LINK_2090",null,"SB I-39/90","off","CD: off to NB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C38,Balancing!$D$11:$D$102,0))","v":260}]
[null,null,2100,{"$f":"\"LINK_\" & $C39","v":"LINK_2100"},null,"SB I-39/90","CD","CD: b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C39,Balancing!$D$11:$D$102,0))","v":1690}]
[null,null,2110,"LINK_2110",null,"SB I-39/90","on","CD: on from NB US 151",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C40,Balancing!$D$11:$D$102,0))","v":210}]
[null,null,2120,"LINK_2120",null,"SB I-39/90","mainline.","b/n CD exit & CD entrance",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C41,Balancing!$D$11:$D$102,0))","v":1450}]
[null,null,2130,"LINK_2130",null,"SB I-39/90","CD","on from CD",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C42,Balancing!$D$11:$D$102,0))","v":1900}]
[null,null,2140,"LINK_2140",null,"SB I-39/90","on","on from High Crossing",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C43,Balancing!$D$11:$D$102,0))","v":250}]
[null,null,2150,"LINK_2150",null,"SB I-39/90","mainline","US 151 to Badger",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C44,Balancing!$D$11:$D$102,0))","v":3600}]
[null,null,2160,"LINK_2160",null,"SB I-39/90","off","off to EB I-94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C45,Balancing!$D$11:$D$102,0))","v":380}]
[null,null,2170,"LINK_2170",null,"SB I-39/90","off","off to WB WIS 30",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C46,Balancing!$D$11:$D$102,0))","v":840}]
[null,null,2180,"LINK_2180",null,"SB I-39/90","mainline.","b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C47,Balancing!$D$11:$D$102,0))","v":2380}]
[null,null,2190,"LINK_2190",null,"SB I-39/90","on","on from WB I-94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C48,Balancing!$D$11:$D$102,0))","v":910}]
[null,null,2200,"LINK_2200",null,"SB I-39/90","on","on from EB WIS 30",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C49,Balancing!$D$11:$D$102,0))","v":240}]
[null,null,2210,"LINK_2210",null,"SB I-39/90","mainline","Badger I/C to Beltline I/C",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C50,Balancing!$D$11:$D$102,0))","v":3530}]
[null,null,3000,"LINK_3000","NB US 151","NB US 151","mainline","Frontage Rd to I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C51,Balancing!$D$11:$D$102,0))","v":820}]
[null,null,2110,"LINK_2110",null,"NB US 151","off","off to SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C52,Balancing!$D$11:$D$102,0))","v":210}]
[null,null,2090,"LINK_2090",null,"NB US 151","on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C53,Balancing!$D$11:$D$102,0))","v":260}]
[null,null,1110,"LINK_1110",null,"NB US 151","off","off to NB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C54,Balancing!$D$11:$D$102,0))","v":70}]
[null,null,1090,"LINK_1090",null,"NB US 151","on","on from NB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C55,Balancing!$D$11:$D$102,0))","v":1380}]
[null,null,3050,"LINK_3050",null,"NB US 151","mainline","I-39/90/94 to American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C56,Balancing!$D$11:$D$102,0))","v":2180}]
[null,null,3060,"LINK_3060",null,"NB US 151","off","off to EB American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C57,Balancing!$D$11:$D$102,0))","v":130}]
[null,null,3070,"LINK_3070",null,"NB US 151","off","off to WB American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C58,Balancing!$D$11:$D$102,0))","v":910}]
[null,null,3080,"LINK_3080",null,"NB US 151","mainline.","b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C59,Balancing!$D$11:$D$102,0))","v":1140}]
[null,null,3090,"LINK_3090",null,"NB US 151","on","NB on from American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C60,Balancing!$D$11:$D$102,0))","v":150}]
[null,null,3100,"LINK_3100",null,"NB US 151","mainline","American Pkwy to Reiner Rd",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C61,Balancing!$D$11:$D$102,0))","v":1290}]
[null,null,4000,"LINK_4000","SB US 151","SB US 151","mainline","Reiner Rd to American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C62,Balancing!$D$11:$D$102,0))","v":3550}]
[null,null,4010,"LINK_4010",null,"SB US 151","CD","off to American Pkwy/High Crossing",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C63,Balancing!$D$11:$D$102,0))","v":510}]
[null,null,4020,"LINK_4020",null,"SB US 151","off","off to WB American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C64,Balancing!$D$11:$D$102,0))","v":320}]
[null,null,4030,"LINK_4030",null,"SB US 151","off","off to High Crossing",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C65,Balancing!$D$11:$D$102,0))","v":190}]
[null,null,4040,"LINK_4040",null,"SB US 151","on","on from High Crossing",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C66,Balancing!$D$11:$D$102,0))","v":70}]
[null,null,4050,"LINK_4050",null,"SB US 151","mainline.","b/n ramps",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C67,Balancing!$D$11:$D$102,0))","v":3110}]
[null,null,4060,"LINK_4060",null,"SB US 151","on","on from EB American Pkwy",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C68,Balancing!$D$11:$D$102,0))","v":290}]
[null,null,4070,"LINK_4070",null,"SB US 151","mainline","American Pkwy to I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C69,Balancing!$D$11:$D$102,0))","v":3400}]
[null,null,1140,"LINK_1140",null,"SB US 151","off","off to NB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C70,Balancing!$D$11:$D$102,0))","v":130}]
[null,null,1120,{"$f":"\"LINK_\" & $C71","v":"LINK_1120"},null,"SB US 151","on","on from NB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C71,Balancing!$D$11:$D$102,0))","v":120}]
[null,null,2080,"LINK_2080",null,"SB US 151","off","off to SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C72,Balancing!$D$11:$D$102,0))","v":1690}]
[null,null,2060,"LINK_2060",null,"SB US 151","on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C73,Balancing!$D$11:$D$102,0))","v":140}]
[null,null,4120,"LINK_4120",null,"SB US 151","mainline","I-39/90/94 to Frontage Rd",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C74,Balancing!$D$11:$D$102,0))","v":1840}]
[null,null,5000,"LINK_5000","EB WIS 30","EB WIS 30","mainline","Fair Oaks to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C75,Balancing!$D$11:$D$102,0))","v":1380}]
[null,null,5010,"LINK_5010",null,"EB WIS 30","off","off to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C76,Balancing!$D$11:$D$102,0))","v":650}]
[null,null,5020,"LINK_5020",null,"EB WIS 30","on","on from US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C77,Balancing!$D$11:$D$102,0))","v":500}]
[null,null,5030,"LINK_5030",null,"EB WIS 30","mainline","US 51 to Thompson Dr",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C78,Balancing!$D$11:$D$102,0))","v":1230}]
[null,null,5040,"LINK_5040",null,"EB WIS 30","off","off to Thompson Dr",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C79,Balancing!$D$11:$D$102,0))","v":270}]
[null,null,5050,"LINK_5050",null,"EB WIS 30","mainline","Thompson Dr to I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C80,Balancing!$D$11:$D$102,0))","v":960}]
[null,null,2200,"LINK_2200",null,"EB WIS 30","off","off to SB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C81,Balancing!$D$11:$D$102,0))","v":240}]
[null,null,1040,"LINK_1040",null,"EB WIS 30","off","off to NB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C82,Balancing!$D$11:$D$102,0))","v":380}]
[null,null,5080,"LINK_5080",null,"EB WIS 30","mainline","EB WIS 30 to EB I-94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C83,Balancing!$D$11:$D$102,0))","v":340}]
[null,null,1020,"LINK_1020",null,"EB WIS 30","on","on from NB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C84,Balancing!$D$11:$D$102,0))","v":470}]
[null,null,2160,"LINK_2160",null,"EB WIS 30","on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C85,Balancing!$D$11:$D$102,0))","v":380}]
[null,null,5110,"LINK_5110","EB I-94","EB I-94","mainline","Badger to County N",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C86,Balancing!$D$11:$D$102,0))","v":1010}]
[null,null,6000,"LINK_6000","WB I-94","WB I-94","mainline","County N to Badger",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C87,Balancing!$D$11:$D$102,0))","v":2550}]
[null,null,1050,"LINK_1050",null,"WB I-94","off","off to NB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C88,Balancing!$D$11:$D$102,0))","v":700}]
[null,null,2190,"LINK_2190",null,"WB I-94","off","off to SB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C89,Balancing!$D$11:$D$102,0))","v":910}]
[null,null,6030,"LINK_6030","WB WIS 30","WB WIS 30","mainline","EB I-94 to EB WIS 30",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C90,Balancing!$D$11:$D$102,0))","v":0}]
[null,null,2170,"LINK_2170",null,"WB WIS 30","on","on from SB I-39/90/94",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C91,Balancing!$D$11:$D$102,0))","v":840}]
[null,null,1010,"LINK_1010",null,"WB WIS 30","on","on from NB I-39/90",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C92,Balancing!$D$11:$D$102,0))","v":570}]
[null,null,6060,"LINK_6060",null,"WB WIS 30","mainline","Badger to Thompson Dr",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C93,Balancing!$D$11:$D$102,0))","v":2350}]
[null,null,6070,"LINK_6070",null,"WB WIS 30","on","on from Thompson Dr",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C94,Balancing!$D$11:$D$102,0))","v":1110}]
[null,null,6080,"LINK_6080",null,"WB WIS 30","mainline","Thompson Dr to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C95,Balancing!$D$11:$D$102,0))","v":3460}]
[null,null,6090,"LINK_6090",null,"WB WIS 30","off","off to US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C96,Balancing!$D$11:$D$102,0))","v":1320}]
[null,null,6100,"LINK_6100",null,"WB WIS 30","on","on from US 51",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C97,Balancing!$D$11:$D$102,0))","v":550}]
[null,null,6110,"LINK_6110",null,"WB WIS 30","mainline","US 51 to Fair Oaks",{"$f":"INDEX(Balancing!$L$11:$L$102,MATCH($C98,Balancing!$D$11:$D$102,0))","v":2690}]

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