{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Freeway_Import","Schematic","Listing","Raw-Initial Volume List Entry"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":127,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Freeway_Import","index":0,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Project",{"$f":"Schematic!$L$3","v":"(Highway XX Project)"}]
[null,null,"Scenario",{"$f":"Schematic!$L$4","v":"(Peak Period)"},null,null,null,null,null,null,"LINK_ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"$\"","v":"$"}]
[null,null,null,null,null,null,null,null,null,null,"imbal",0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,"target","$","$"]
[]
[null,null,"LINK_ID","Corridor","Corridor & Direction","Type","Location","Balanced\nVolume"]

{"sheet":"Schematic","index":1,"n_rows":91,"n_cols":90,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Project","(Highway XX Project)"]
[null,null,null,null,null,null,null,null,null,null,"Scenario","(Peak Period)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Do not put intersection data on the left side or above the black border"]
[null,null,null,null,null,"Total network imbalance",{"$f":"ABS(AN22)+ABS(U37)+ABS(BC41)+ABS(AJ56)+ABS(AN57)+ABS(BW57)+ABS(U72)+ABS(BD72)+ABS(BC76)+ABS(CL76)+ABS(AJ91)","v":275}]
[]
[]
[null,null,"Balancing Convergence Criteria"]
[null,null,null,null,null,"Maximum Iterations",500]
[null,null,null,null,null,"Max. Tot. Network Imbalance",0.01]
[]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ19<>\"\",AVERAGE(AJ22,AJ19),AJ22)","v":211},{"$f":"SUM(AH34:AK34)","v":211},{"$f":"SUM(AH37:AK37)","v":211},null,{"$f":"IF(AM21<>\"\",AM21-AM24,0)","v":0},{"$f":"IF(AN21<>\"\",AN21-AN24,0)","v":0},"imbal"]
[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,null,null,null,null,null,null,null,null,null,"target","$","$",null,"#","#","target"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK37,AJ41,AO41,AN35)","v":234},{"$f":"SUM(AK34,AG41,AO44,AQ35)","v":234},{"$f":"IF(AN21<>\"\",AVERAGE(AN24,AN21),AN24)","v":234}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,AL39&\":\",\"IX_NAME\",Y25)","v":"1:"},{"$f":"AC40&\" & \"&AK28","v":"Street 2 & Street 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local OD Raw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw Count Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"local_od_raw_\"&AL39","v":"local_od_raw_1"},1,2,3,4,"est","tgt","err"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AM41","v":0},{"$f":"AP41","v":94},{"$f":"AO41","v":85},{"$f":"AN41","v":85},{"$f":"SUM(AV27:AY27)","v":264},{"$f":"AO56","v":248.5},{"$f":"IFERROR(ABS(AZ27-BA27)/BA27,0)","v":6.2374245472837021E-2}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Street 1",null,null,null,null,null,null,null,null,null,2,{"$f":"AN37","v":64},{"$f":"AN38","v":0},{"$f":"AN35","v":70},{"$f":"AN36","v":56},{"$f":"SUM(AV28:AY28)","v":190},{"$f":"BC36","v":186},{"$f":"IFERROR(ABS(AZ28-BA28)/BA28,0)","v":2.1505376344086023E-2}]
[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,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AI37","v":98},{"$f":"AJ37","v":55},{"$f":"AK37","v":0},{"$f":"AH37","v":58},{"$f":"SUM(AV29:AY29)","v":211},{"$f":"AI22","v":211},0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AJ43","v":59},{"$f":"AJ42","v":51},{"$f":"AJ41","v":79},{"$f":"AJ40","v":0},{"$f":"SUM(AV30:AY30)","v":189},{"$f":"U42","v":189},0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"est",{"$f":"SUM(AV27:AV30)","v":221},{"$f":"SUM(AW27:AW30)","v":200},{"$f":"SUM(AX27:AX30)","v":234},{"$f":"SUM(AY27:AY30)","v":199}]
[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,null,null,null,null,null,null,null,"RNSE",{"$f":"RNSE(AH34,AH37)","v":0},{"$f":"RNSE(AI34,AI37)","v":0},0,"-",null,null,null,null,null,null,null,null,null,"tgt",{"$f":"AI54","v":209.5},{"$f":"BA42","v":167.5},{"$f":"AO24","v":234},{"$f":"W36","v":199}]
[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,null,null,null,null,null,null,null,"%",{"$f":"AH34/AJ22","v":0.27488151658767773},{"$f":"AI34/AJ22","v":0.46445497630331756},{"$f":"AJ34/AJ22","v":0.26066350710900477},{"$f":"AK34/AJ22","v":0},null,null,null,null,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(AV31-AV32)/AV32,0)","v":5.4892601431980909E-2},{"$f":"IFERROR(ABS(AW31-AW32)/AW32,0)","v":0.19402985074626866},0,0,null,null,{"$f":"SUM(AV33:AY33,BB27:BB30)","v":0.33280207399517259}]
[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,null,null,null,null,null,null,null,"bal",{"$f":"AY48","v":58},{"$f":"AV48","v":98},{"$f":"AW48","v":55},{"$f":"AX48","v":0},null,null,"raw","%",null,"bal","%","RNSE"]
[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,null,null,null,null,null,null,null,null,8,"$",9,"M",null,{"$f":"CHOOSE(1,\"<\",\"TURN\",8,AL39,AN35,AQ35)","v":"<"},70,{"$f":"AN35/BC38","v":0.36842105263157893},"<",{"$f":"AX47","v":70},{"$f":"AQ35/BC37","v":0.36842105263157893},{"$f":"RNSE(AQ35,AN35)","v":0},null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"imbal","target",{"$f":"IF(T37<>\"\",AVERAGE(W37,T37),W37)","v":199},null,null,null,null,null,null,null,null,null,"%",{"$f":"AH37/AK22","v":0.27488151658767773},{"$f":"AI37/AK22","v":0.46445497630331756},{"$f":"AJ37/AK22","v":0.26066350710900477},{"$f":"AK37/AK22","v":0},null,{"$f":"CHOOSE(1,\"!\",\"TURN\",7,AL39,AN36,AQ36)","v":"!"},56,{"$f":"AN36/BC38","v":0.29473684210526313},"!",{"$f":"AY47","v":56},{"$f":"AQ36/BC37","v":0.29473684210526313},{"$f":"RNSE(AQ36,AN36)","v":0},null,null,null,null,null,null,null,null,"target",{"$f":"IF(BW59<>\"\",AVERAGE(BC37,BW59),BC37)","v":186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T37<>\"\",T37-W37,0)","v":0},"!",{"$f":"SUM(AG40,AN44,AQ36,AH34)","v":199},null,null,null,null,null,null,null,null,null,"raw",58,98,55,0,null,{"$f":"CHOOSE(1,\">\",\"TURN\",6,AL39,AN37,AQ37)","v":">"},64,{"$f":"AN37/BC38","v":0.33684210526315789},">",{"$f":"AV47","v":64},{"$f":"AQ37/BC37","v":0.33684210526315789},0,null,null,null,null,null,null,null,null,"!",{"$f":"SUM(AQ35:AQ38)","v":190}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T38<>\"\",T38-W38,0)","v":0},"!",{"$f":"SUM(AJ40,AN41,AN36,AH37)","v":199},null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,8,\"TURN\",12,AL39,AH37,AH34)","v":8},{"$f":"CHOOSE(1,\"$\",\"TURN\",11,AL39,AI37,AI34)","v":"$"},{"$f":"CHOOSE(1,\"9\",\"TURN\",10,AL39,AJ37,AJ34)","v":"9"},{"$f":"CHOOSE(1,\"M\",\"TURN\",9,AL39,AK37,AK34)","v":"M"},null,{"$f":"CHOOSE(1,\"N\",\"TURN\",5,AL39,AN38,AQ38)","v":"N"},0,{"$f":"AN38/BC38","v":0},"N",{"$f":"AW47","v":0},{"$f":"AQ38/BC37","v":0},"-",null,null,null,null,null,null,null,null,"!",{"$f":"SUM(AN35:AN38)","v":190}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ40:AJ43)","v":189},"\"",null,null,null,null,null,null,"Street 2",null,{"$f":"RNSE(AG40,AJ40)","v":"-"},{"$f":"AG40/U41","v":0},{"$f":"AY49","v":0},"O",{"$f":"AJ40/U40","v":0},0,{"$f":"CHOOSE(1,\"O\",\"TURN\",13,AL39,AJ40,AG40)","v":"O"},null,{"$f":"CHOOSE(1,\"L\",\"TURN\",1,AL39,AM41,AM44)","v":"L"},{"$f":"CHOOSE(1,\":\",\"TURN\",2,AL39,AN41,AN44)","v":":"},{"$f":"CHOOSE(1,\"#\",\"TURN\",3,AL39,AO41,AO44)","v":"#"},{"$f":"CHOOSE(1,\";\",\"TURN\",4,AL39,AP41,AP44)","v":";"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN38,AJ37,AJ42,AP41)","v":200},"\"",{"$f":"IF(BT57<>\"\",BT57-BA40,0)","v":-65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG40:AG43)","v":189},"\"",null,null,null,null,null,null,null,null,0,{"$f":"AG41/U41","v":0.41798941798941797},{"$f":"AX49","v":79},"=",{"$f":"AJ41/U40","v":0.41798941798941797},79,{"$f":"CHOOSE(1,\"=\",\"TURN\",14,AL39,AJ41,AG41)","v":"="},null,0,85,85,94,"raw",null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ38,AJ34,AG42,AP44)","v":200},"\"",{"$f":"IF(BS57<>\"\",BS57-BA41,0)","v":-65},"<----"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R41<>\"\",AVERAGE(U41,R41),U41)","v":189},"target",null,null,null,null,null,null,null,null,0,{"$f":"AG42/U41","v":0.26984126984126983},{"$f":"AW49","v":51},"\"",{"$f":"AJ42/U40","v":0.26984126984126983},51,{"$f":"CHOOSE(1,\"\"\"\",\"TURN\",15,AL39,AJ42,AG42)","v":"\""},null,{"$f":"AM41/AM56","v":0},{"$f":"AN41/AM56","v":0.32196969696969696},{"$f":"AO41/AM56","v":0.32196969696969696},{"$f":"AP41/AM56","v":0.35606060606060608},"%",null,null,null,null,null,null,null,null,null,{"$f":"IF(BS57<>\"\",AVERAGE(BA41,BS57),BA41)","v":167.5},"target","imbal"]
[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,null,null,"",null,null,0,{"$f":"AG43/U41","v":0.31216931216931215},{"$f":"AV49","v":59},"?",{"$f":"AJ43/U40","v":0.31216931216931215},59,{"$f":"CHOOSE(1,\"?\",\"TURN\",16,AL39,AJ43,AG43)","v":"?"},null,"L",":","#",";"]
[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,null,null,null,null,null,"RNSE","%","bal",null,"%","raw",null,null,{"$f":"AV46","v":0},{"$f":"AY46","v":85},{"$f":"AX46","v":85},{"$f":"AW46","v":94},"bal",null,null,null,"Local OD Estimated"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM44/AN56","v":0},{"$f":"AN44/AN56","v":0.32196969696969696},{"$f":"AO44/AN56","v":0.32196969696969696},{"$f":"AP44/AN56","v":0.35606060606060608},"%",null,null,null,{"$f":"\"local_od_est_\"&AL39","v":"local_od_est_1"},1,2,3,4,"est","tgt","err"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RNSE(AM44,AM41)","v":"-"},0,0,0,"RNSE",null,null,null,1,{"$f":"AV27","v":0},94,85,85,{"$f":"SUM(AV46:AY46)","v":264},{"$f":"BA27","v":248.5},{"$f":"IFERROR(ABS(AZ46-BA46)/BA46,0)","v":6.2374245472837021E-2}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,64,0,70,56,{"$f":"SUM(AV47:AY47)","v":190},186,{"$f":"IFERROR(ABS(AZ47-BA47)/BA47,0)","v":2.1505376344086023E-2}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,98,55,0,58,211,211,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,4,59,51,79,0,189,189,0]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"est",{"$f":"SUM(AV46:AV49)","v":221},{"$f":"SUM(AW46:AW49)","v":200},234,199]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tgt",{"$f":"AV32","v":209.5},167.5,234,199]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(AV50-AV51)/AV51,0)","v":5.4892601431980909E-2},{"$f":"IFERROR(ABS(AW50-AW51)/AW51,0)","v":0.19402985074626866},0,0,null,null,{"$f":"SUM(AV52:AY52,BB46:BB49)","v":0.33280207399517259}]
[]
[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,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ57<>\"\",AVERAGE(AJ54,AJ57),AJ54)","v":209.5},{"$f":"SUM(AM44,AQ37,AI34,AG43)","v":221},{"$f":"SUM(AM41,AN37,AI37,AJ43)","v":221}]
[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,null,null,null,null,null,null,null,null,null,"target","$","$",null,"#","#","target"]
[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,null,null,null,null,null,null,null,null,null,"imbal",{"$f":"IF(AJ57<>\"\",AJ57-AJ54,0)","v":-23},{"$f":"IF(AK57<>\"\",AK57-AK54,0)","v":-23},null,{"$f":"SUM(AM41:AP41)","v":264},{"$f":"SUM(AM44:AP44)","v":264},{"$f":"IF(AN59<>\"\",AVERAGE(AN56,AN59),AN56)","v":248.5},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,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ54<>\"\",AVERAGE(AJ57,AJ54),AJ57)","v":209.5},{"$f":"SUM(AH69:AK69)","v":198},{"$f":"SUM(AH72:AK72)","v":198},null,{"$f":"IF(AM56<>\"\",AM56-AM59,0)","v":31},{"$f":"IF(AN56<>\"\",AN56-AN59,0)","v":31},"imbal",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,null,null,null,{"$f":"IF(BA41<>\"\",AVERAGE(BS57,BA41),BS57)","v":167.5},{"$f":"SUM(BR69:BT69)","v":135},{"$f":"SUM(BR72:BT72)","v":135},null,{"$f":"IF(BC38<>\"\",BC38-BV59,0)","v":8},{"$f":"IF(BC37<>\"\",BC37-BW59,0)","v":8},"imbal"]
[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,null,null,null,null,null,null,null,null,null,"target","$","$",null,"#","#","target",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,null,null,null,"target","$","$",null,"#","#","target"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AK72,AJ76,AO76,AN70)","v":233},{"$f":"SUM(AK69,AG76,AO79,AQ70)","v":233},{"$f":"IF(AN56<>\"\",AVERAGE(AN59,AN56),AN59)","v":248.5},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,null,null,null,null,null,null,null,{"$f":"SUM(BT72,BS76,BW71)","v":182},{"$f":"SUM(BT69,BP76,BZ71)","v":182},{"$f":"IF(BC37<>\"\",AVERAGE(BW59,BC37),BW59)","v":186}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,AL74&\":\",\"IX_NAME\",Y60)","v":"2:"},{"$f":"AC75&\" & \"&AK63","v":"Street 3 & Street 1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local OD Raw",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,BU74&\":\",\"IX_NAME\",BH60)","v":"3:"},{"$f":"BL75&\" & \"&BT63","v":"Street 3 & Street 2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local OD Raw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Raw Count Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"local_od_raw_\"&AL74","v":"local_od_raw_2"},1,2,3,4,"est","tgt","err",null,null,null,null,null,"Raw Count Date:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"local_od_raw_\"&BU74","v":"local_od_raw_3"},2,3,4,"est","tgt","err"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AM76","v":0},{"$f":"AP76","v":86},{"$f":"AO76","v":73},{"$f":"AN76","v":71},{"$f":"SUM(AV62:AY62)","v":230},{"$f":"AO91","v":230},{"$f":"IFERROR(ABS(AZ62-BA62)/BA62,0)","v":0},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,null,null,2,{"$f":"BW73","v":0},{"$f":"BW71","v":84},{"$f":"BW72","v":60},{"$f":"SUM(CE62:CG62)","v":144},{"$f":"CL71","v":144},{"$f":"IFERROR(ABS(CH62-CI62)/CI62,0)","v":0}]
[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,null,null,null,null,null,null,null,null,null,null,null,"Street 1",null,null,null,null,null,null,null,null,null,2,{"$f":"AN72","v":93},{"$f":"AN73","v":0},{"$f":"AN70","v":86},{"$f":"AN71","v":78},{"$f":"SUM(AV63:AY63)","v":257},{"$f":"BC71","v":189},{"$f":"IFERROR(ABS(AZ63-BA63)/BA63,0)","v":0.35978835978835977},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Street 2",null,null,null,null,null,null,null,null,null,3,{"$f":"BS72","v":74},{"$f":"BT72","v":0},{"$f":"BR72","v":61},{"$f":"SUM(CE63:CG63)","v":135},{"$f":"BR57","v":167.5},0.19402985074626866]
[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,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AI72","v":54},{"$f":"AJ72","v":51},{"$f":"AK72","v":0},{"$f":"AH72","v":93},{"$f":"SUM(AV64:AY64)","v":198},{"$f":"AI57","v":209.5},5.4892601431980909E-2,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,null,4,{"$f":"BS77","v":84},{"$f":"BS76","v":98},{"$f":"BS75","v":0},{"$f":"SUM(CE64:CG64)","v":182},{"$f":"BD77","v":188},3.1914893617021274E-2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AJ78","v":50},{"$f":"AJ77","v":57},{"$f":"AJ76","v":74},{"$f":"AJ75","v":0},{"$f":"SUM(AV65:AY65)","v":181},{"$f":"U77","v":181},0,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,null,null,"est",{"$f":"SUM(CE62:CE64)","v":158},{"$f":"SUM(CF62:CF64)","v":182},{"$f":"SUM(CG62:CG64)","v":121}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"est",{"$f":"SUM(AV62:AV65)","v":197},{"$f":"SUM(AW62:AW65)","v":194},{"$f":"SUM(AX62:AX65)","v":233},{"$f":"SUM(AY62:AY65)","v":242},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,null,null,null,null,null,"tgt",{"$f":"CJ77","v":158},{"$f":"BX59","v":186},{"$f":"BF71","v":189}]
[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,null,null,null,null,null,null,null,"RNSE",{"$f":"RNSE(AH69,AH72)","v":0},{"$f":"RNSE(AI69,AI72)","v":0},0,"-",null,null,null,null,null,null,null,null,null,"tgt",{"$f":"AI89","v":197},{"$f":"BA77","v":188},{"$f":"AO59","v":248.5},{"$f":"W71","v":242},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RNSE",{"$f":"RNSE(BR69,BR72)","v":0},{"$f":"RNSE(BS69,BS72)","v":0},"-",null,null,null,null,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(CE65-CE66)/CE66,0)","v":0},2.1505376344086023E-2,0.35978835978835977,null,null,{"$f":"SUM(CE67:CG67,CJ62:CJ64)","v":0.6072384804957357}]
[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,null,null,null,null,null,null,null,"%",{"$f":"AH69/AJ57","v":0.46969696969696972},{"$f":"AI69/AJ57","v":0.27272727272727271},{"$f":"AJ69/AJ57","v":0.25757575757575757},{"$f":"AK69/AJ57","v":0},null,null,null,null,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(AV66-AV67)/AV67,0)","v":0},{"$f":"IFERROR(ABS(AW66-AW67)/AW67,0)","v":3.1914893617021274E-2},6.2374245472837021E-2,0,null,null,{"$f":"SUM(AV68:AY68,BB62:BB65)","v":0.50897010031019896},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",{"$f":"BR69/BS57","v":0.45185185185185184},{"$f":"BS69/BS57","v":0.54814814814814816},{"$f":"BT69/BS57","v":0}]
[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,null,null,null,null,null,null,null,"bal",{"$f":"AY83","v":93},{"$f":"AV83","v":54},{"$f":"AW83","v":51},{"$f":"AX83","v":0},null,null,"raw","%",null,"bal","%","RNSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bal",{"$f":"CG82","v":61},{"$f":"CE82","v":74},{"$f":"CF82","v":0}]
[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,null,null,null,null,null,null,null,null,8,"$",9,"M",null,{"$f":"CHOOSE(1,\"<\",\"TURN\",8,AL74,AN70,AQ70)","v":"<"},86,{"$f":"AN70/BC73","v":0.33463035019455251},"<",{"$f":"AX82","v":86},{"$f":"AQ70/BC72","v":0.33463035019455251},{"$f":"RNSE(AQ70,AN70)","v":0},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,9,"M",null,null,"raw","%",null,"bal","%","RNSE",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"imbal","target",{"$f":"IF(T72<>\"\",AVERAGE(W72,T72),W72)","v":242},null,null,null,null,null,null,null,null,null,"%",{"$f":"AH72/AK57","v":0.46969696969696972},{"$f":"AI72/AK57","v":0.27272727272727271},{"$f":"AJ72/AK57","v":0.25757575757575757},{"$f":"AK72/AK57","v":0},null,{"$f":"CHOOSE(1,\"!\",\"TURN\",7,AL74,AN71,AQ71)","v":"!"},78,{"$f":"AN71/BC73","v":0.30350194552529181},"!",{"$f":"AY82","v":78},{"$f":"AQ71/BC72","v":0.30350194552529181},{"$f":"RNSE(AQ71,AN71)","v":0},null,null,null,null,null,null,null,null,"target",{"$f":"IF(BF72<>\"\",AVERAGE(BC72,BF72),BC72)","v":189},"imbal","target",{"$f":"IF(BC72<>\"\",AVERAGE(BF72,BC72),BF72)","v":189},null,null,null,null,null,null,null,null,null,null,"%",{"$f":"BR72/BT57","v":0.45185185185185184},{"$f":"BS72/BT57","v":0.54814814814814816},{"$f":"BT72/BT57","v":0},null,{"$f":"CHOOSE(1,\"<\",\"TURN\",8,BU74,BW71,BZ71)","v":"<"},84,{"$f":"BW71/CL73","v":0.58333333333333337},"<",{"$f":"CF81","v":84},{"$f":"BZ71/CL72","v":0.58333333333333337},{"$f":"RNSE(BZ71,BW71)","v":0},null,null,null,null,null,null,null,null,"target",{"$f":"IF(CO72<>\"\",AVERAGE(CL72,CO72),CL72)","v":144}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T72<>\"\",T72-W72,0)","v":0},"!",{"$f":"SUM(AG75,AN79,AQ71,AH69)","v":242},null,null,null,null,null,null,null,null,null,"raw",93,54,51,0,null,{"$f":"CHOOSE(1,\">\",\"TURN\",6,AL74,AN72,AQ72)","v":">"},93,{"$f":"AN72/BC73","v":0.36186770428015563},">",{"$f":"AV82","v":93},{"$f":"AQ72/BC72","v":0.36186770428015563},0,null,null,null,null,null,null,null,null,"!",{"$f":"SUM(AQ70:AQ73)","v":257},{"$f":"IF(BC72<>\"\",BC72-BF72,0)","v":136},"!",{"$f":"SUM(BP75,BZ72,BR69)","v":121},null,null,null,null,null,null,null,null,null,null,"raw",61,74,0,null,{"$f":"CHOOSE(1,\"!\",\"TURN\",7,BU74,BW72,BZ72)","v":"!"},60,{"$f":"BW72/CL73","v":0.41666666666666669},"!",{"$f":"CG81","v":60},{"$f":"BZ72/CL72","v":0.41666666666666669},{"$f":"RNSE(BZ72,BW72)","v":0},null,null,null,null,null,null,null,null,"!",{"$f":"SUM(BZ71:BZ73)","v":144}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T73<>\"\",T73-W73,0)","v":0},"!",{"$f":"SUM(AJ75,AN76,AN71,AH72)","v":242},null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,8,\"TURN\",12,AL74,AH72,AH69)","v":8},{"$f":"CHOOSE(1,\"$\",\"TURN\",11,AL74,AI72,AI69)","v":"$"},{"$f":"CHOOSE(1,\"9\",\"TURN\",10,AL74,AJ72,AJ69)","v":"9"},{"$f":"CHOOSE(1,\"M\",\"TURN\",9,AL74,AK72,AK69)","v":"M"},null,{"$f":"CHOOSE(1,\"N\",\"TURN\",5,AL74,AN73,AQ73)","v":"N"},0,{"$f":"AN73/BC73","v":0},"N",{"$f":"AW82","v":0},{"$f":"AQ73/BC72","v":0},"-",null,null,null,null,null,null,null,null,"!",{"$f":"SUM(AN70:AN73)","v":257},{"$f":"IF(BC73<>\"\",BC73-BF73,0)","v":136},"!",{"$f":"SUM(BS75,BW76,BW72,BR72)","v":121},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE(1,8,\"TURN\",12,BU74,BR72,BR69)","v":8},{"$f":"CHOOSE(1,\"9\",\"TURN\",10,BU74,BS72,BS69)","v":"9"},{"$f":"CHOOSE(1,\"M\",\"TURN\",9,BU74,BT72,BT69)","v":"M"},null,{"$f":"CHOOSE(1,\"N\",\"TURN\",5,BU74,BW73,BZ73)","v":"N"},0,{"$f":"BW73/CL73","v":0},"N",{"$f":"CE81","v":0},{"$f":"BZ73/CL72","v":0},{"$f":"RNSE(BZ73,BW73)","v":"-"},null,null,null,null,null,null,null,null,"!",{"$f":"SUM(BW71:BW73)","v":144}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,2,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,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ75:AJ78)","v":181},"\"",null,null,null,null,null,null,"Street 3",null,{"$f":"RNSE(AG75,AJ75)","v":"-"},{"$f":"AG75/U76","v":0},{"$f":"AY84","v":0},"O",{"$f":"AJ75/U75","v":0},0,{"$f":"CHOOSE(1,\"O\",\"TURN\",13,AL74,AJ75,AG75)","v":"O"},null,{"$f":"CHOOSE(1,\"L\",\"TURN\",1,AL74,AM76,AM79)","v":"L"},{"$f":"CHOOSE(1,\":\",\"TURN\",2,AL74,AN76,AN79)","v":":"},{"$f":"CHOOSE(1,\"#\",\"TURN\",3,AL74,AO76,AO79)","v":"#"},{"$f":"CHOOSE(1,\";\",\"TURN\",4,AL74,AP76,AP79)","v":";"},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AN73,AJ72,AJ77,AP76)","v":194},"\"",{"$f":"IF(BD75<>\"\",BD75-BA75,0)","v":-12},{"$f":"SUM(BS75:BS77)","v":182},"\"",null,null,null,null,null,null,"Street 3",null,{"$f":"RNSE(BP75,BS75)","v":"-"},{"$f":"BP75/BD76","v":0},{"$f":"CG83","v":0},"O",{"$f":"BS75/BD75","v":0},0,{"$f":"CHOOSE(1,\"O\",\"TURN\",13,BU74,BS75,BP75)","v":"O"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BW73,BS72,BS77)","v":158},"\"",{"$f":"IF(CM75<>\"\",CM75-CJ75,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG75:AG78)","v":181},"\"",null,null,null,null,null,null,null,null,0,{"$f":"AG76/U76","v":0.40883977900552487},{"$f":"AX84","v":74},"=",{"$f":"AJ76/U75","v":0.40883977900552487},74,{"$f":"CHOOSE(1,\"=\",\"TURN\",14,AL74,AJ76,AG76)","v":"="},null,0,71,73,86,"raw",null,null,null,null,null,null,null,null,null,{"$f":"SUM(AQ73,AJ69,AG77,AP79)","v":194},"\"",{"$f":"IF(BD76<>\"\",BD76-BA76,0)","v":-12},{"$f":"SUM(BP75:BP77)","v":182},"\"",null,null,null,null,null,null,null,null,0,{"$f":"BP76/BD76","v":0.53846153846153844},{"$f":"CF83","v":98},"=",{"$f":"BS76/BD75","v":0.53846153846153844},98,{"$f":"CHOOSE(1,\"=\",\"TURN\",14,BU74,BS76,BP76)","v":"="},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(BZ73,BS69,BP77)","v":158},"\"",{"$f":"IF(CM76<>\"\",CM76-CJ76,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R76<>\"\",AVERAGE(U76,R76),U76)","v":181},"target",null,null,null,null,null,null,null,null,0,{"$f":"AG77/U76","v":0.31491712707182318},{"$f":"AW84","v":57},"\"",{"$f":"AJ77/U75","v":0.31491712707182318},57,{"$f":"CHOOSE(1,\"\"\"\",\"TURN\",15,AL74,AJ77,AG77)","v":"\""},null,{"$f":"AM76/AM91","v":0},{"$f":"AN76/AM91","v":0.30869565217391304},{"$f":"AO76/AM91","v":0.31739130434782609},{"$f":"AP76/AM91","v":0.37391304347826088},"%",null,null,null,null,null,null,null,null,null,{"$f":"IF(BD76<>\"\",AVERAGE(BA76,BD76),BA76)","v":188},"target","imbal",{"$f":"IF(BA76<>\"\",AVERAGE(BD76,BA76),BD76)","v":188},"target",null,null,null,null,null,null,null,null,0,{"$f":"BP77/BD76","v":0.46153846153846156},{"$f":"CE83","v":84},"\"",{"$f":"BS77/BD75","v":0.46153846153846156},84,{"$f":"CHOOSE(1,\"\"\"\",\"TURN\",15,BU74,BS77,BP77)","v":"\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CM76<>\"\",AVERAGE(CJ76,CM76),CJ76)","v":158},"target","imbal"]
[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,null,null,"",null,null,0,{"$f":"AG78/U76","v":0.27624309392265195},{"$f":"AV84","v":50},"?",{"$f":"AJ78/U75","v":0.27624309392265195},50,{"$f":"CHOOSE(1,\"?\",\"TURN\",16,AL74,AJ78,AG78)","v":"?"},null,"L",":","#",";",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"RNSE","%","bal",null,"%","raw"]
[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,null,null,null,null,null,"RNSE","%","bal",null,"%","raw",null,null,{"$f":"AV81","v":0},{"$f":"AY81","v":71},{"$f":"AX81","v":73},{"$f":"AW81","v":86},"bal",null,null,null,"Local OD Estimated",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,null,null,null,null,null,null,null,null,null,"Local OD Estimated"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AM79/AN91","v":0},{"$f":"AN79/AN91","v":0.30869565217391304},{"$f":"AO79/AN91","v":0.31739130434782609},{"$f":"AP79/AN91","v":0.37391304347826088},"%",null,null,null,{"$f":"\"local_od_est_\"&AL74","v":"local_od_est_2"},1,2,3,4,"est","tgt","err",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,null,null,{"$f":"\"local_od_est_\"&BU74","v":"local_od_est_3"},2,3,4,"est","tgt","err"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RNSE(AM79,AM76)","v":"-"},0,0,0,"RNSE",null,null,null,1,{"$f":"AV62","v":0},86,73,71,{"$f":"SUM(AV81:AY81)","v":230},{"$f":"BA62","v":230},{"$f":"IFERROR(ABS(AZ81-BA81)/BA81,0)","v":0},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,null,null,2,{"$f":"CE62","v":0},84,60,{"$f":"SUM(CE81:CG81)","v":144},{"$f":"CI62","v":144},{"$f":"IFERROR(ABS(CH81-CI81)/CI81,0)","v":0}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,93,0,86,78,{"$f":"SUM(AV82:AY82)","v":257},189,{"$f":"IFERROR(ABS(AZ82-BA82)/BA82,0)","v":0.35978835978835977},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,null,null,3,74,0,61,{"$f":"SUM(CE82:CG82)","v":135},{"$f":"CI63","v":167.5},0.19402985074626866]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,54,51,0,93,198,209.5,5.4892601431980909E-2,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,null,null,4,84,98,0,{"$f":"SUM(CE83:CG83)","v":182},{"$f":"CI64","v":188},3.1914893617021274E-2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,4,50,57,74,0,181,181,0,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,null,"est",{"$f":"SUM(CE81:CE83)","v":158},{"$f":"SUM(CF81:CF83)","v":182},{"$f":"SUM(CG81:CG83)","v":121}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"est",{"$f":"SUM(AV81:AV84)","v":197},{"$f":"SUM(AW81:AW84)","v":194},233,242,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,null,null,null,null,null,"tgt",{"$f":"CE66","v":158},{"$f":"CF66","v":186},{"$f":"CG66","v":189}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tgt",{"$f":"AV67","v":197},188,248.5,242,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,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(CE84-CE85)/CE85,0)","v":0},2.1505376344086023E-2,0.35978835978835977,null,null,{"$f":"SUM(CE86:CG86,CJ81:CJ83)","v":0.6072384804957357}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"err",{"$f":"IFERROR(ABS(AV85-AV86)/AV86,0)","v":0},{"$f":"IFERROR(ABS(AW85-AW86)/AW86,0)","v":3.1914893617021274E-2},6.2374245472837021E-2,0,null,null,{"$f":"SUM(AV87:AY87,BB81:BB84)","v":0.50897010031019896}]
[]
[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,null,null,null,null,null,null,null,null,null,{"$f":"IF(AJ92<>\"\",AVERAGE(AJ89,AJ92),AJ89)","v":197},{"$f":"SUM(AM79,AQ72,AI69,AG78)","v":197},{"$f":"SUM(AM76,AN72,AI72,AJ78)","v":197}]
[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,null,null,null,null,null,null,null,null,null,"target","$","$",null,"#","#","target"]
[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,null,null,null,null,null,null,null,null,null,"imbal",{"$f":"IF(AJ92<>\"\",AJ92-AJ89,0)","v":0},{"$f":"IF(AK92<>\"\",AK92-AK89,0)","v":0},null,{"$f":"SUM(AM76:AP76)","v":230},{"$f":"SUM(AM79:AP79)","v":230},{"$f":"IF(AN94<>\"\",AVERAGE(AN91,AN94),AN91)","v":230}]

{"sheet":"Listing","index":2,"n_rows":49,"n_cols":21,"rows_kept":49,"cut":false,"hidden":false,"merged":[[6,12,6,13]]}
[]
[null,null,null,null,null,null,null,null,"Project",{"$f":"Schematic!$L$3","v":"(Highway XX Project)"}]
[null,null,null,null,null,null,null,null,"Scenario",{"$f":"Schematic!$L$4","v":"(Peak Period)"}]
[]
[null,null,"Intersection Numbers & Names",null,null,null,"Intersection Turning Movement Volume Comparison",null,null,null,null,null,null,null,null,null,null,null,null,"Imbalance Cells"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Volume"]
[null,null,"Intersection\nNumber","Intersection\nName",null,null,"SORT","TURN_ID","Intersection Number","Intersection","Intersection","Turn","Raw","Balanced","Diff.\n(Bal - Raw)","RNSE",null,null,null,"Cell","Value"]
[null,null,1,{"$f":"Schematic!$Y$25","v":"Street 2 & Street 1"},null,null,1,"TURN_001_01",1,{"$f":"INDEX($D$9:$D$11, MATCH($I9,$C$9:$C$11,0))","v":"Street 2 & Street 1"},{"$f":"INDEX($D$9:$D$11, MATCH($I9,$C$9:$C$11,0))","v":"Street 2 & Street 1"},"NBU",{"$f":"INDIRECT(H9 & \"_raw\")","v":0},{"$f":"INDIRECT(H9 & \"_bal\")","v":0},{"$f":"$N9-$M9","v":0},{"$f":"IF($M9>0, SQRT($O9^2/$M9),\"\")","v":""},null,null,null,{"$f":"CELL(\"address\",Schematic!$AN$22)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$AN$22"},{"$f":"INDIRECT($T9)","v":0}]
[null,null,2,{"$f":"Schematic!$Y$60","v":"Street 3 & Street 1"},null,null,2,"TURN_001_02",1,null,"Street 2 & Street 1","NBL",85,85,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$U$37)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$U$37"},0]
[null,null,3,{"$f":"Schematic!$BH$60","v":"Street 3 & Street 2"},null,null,3,"TURN_001_03",1,null,"Street 2 & Street 1","NBT",85,85,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$BC$41)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$BC$41"},-65]
[null,null,null,null,null,null,4,"TURN_001_04",1,null,"Street 2 & Street 1","NBR",94,94,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$AJ$56)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$AJ$56"},-23]
[null,null,null,null,null,null,5,"TURN_001_05",1,null,"Street 2 & Street 1","WBU",0,0,0,"",null,null,null,{"$f":"CELL(\"address\",Schematic!$AN$57)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$AN$57"},31]
[null,null,null,null,null,null,6,"TURN_001_06",1,null,"Street 2 & Street 1","WBL",64,64,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$BW$57)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$BW$57"},8]
[null,null,null,null,null,null,7,"TURN_001_07",1,null,"Street 2 & Street 1","WBT",56,56,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$U$72)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$U$72"},0]
[null,null,null,null,null,null,8,"TURN_001_08",1,null,"Street 2 & Street 1","WBR",70,70,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$BD$72)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$BD$72"},136]
[null,null,null,null,null,null,9,"TURN_001_09",1,null,"Street 2 & Street 1","SBU",0,0,0,"",null,null,null,{"$f":"CELL(\"address\",Schematic!$BC$76)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$BC$76"},-12]
[null,null,null,null,null,null,10,"TURN_001_10",1,null,"Street 2 & Street 1","SBL",55,55,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$CL$76)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$CL$76"},0]
[null,null,null,null,null,null,11,"TURN_001_11",1,null,"Street 2 & Street 1","SBT",98,98,0,0,null,null,null,{"$f":"CELL(\"address\",Schematic!$AJ$91)","v":"'[Intersection Balancing Example Triangle.xlsm]Schematic'!$AJ$91"},0]
[null,null,null,null,null,null,12,"TURN_001_12",1,null,"Street 2 & Street 1","SBR",58,58,0,0]
[null,null,null,null,null,null,13,"TURN_001_13",1,null,"Street 2 & Street 1","EBU",0,0,0,""]
[null,null,null,null,null,null,14,"TURN_001_14",1,null,"Street 2 & Street 1","EBL",79,79,0,0]
[null,null,null,null,null,null,15,"TURN_001_15",1,null,"Street 2 & Street 1","EBT",51,51,0,0]
[null,null,null,null,null,null,16,"TURN_001_16",1,null,"Street 2 & Street 1","EBR",59,59,0,0]
[null,null,null,null,null,null,17,"TURN_002_01",2,{"$f":"INDEX($D$9:$D$11, MATCH($I25,$C$9:$C$11,0))","v":"Street 3 & Street 1"},"Street 3 & Street 1","NBU",0,0,0,""]
[null,null,null,null,null,null,18,"TURN_002_02",2,null,"Street 3 & Street 1","NBL",71,71,0,0]
[null,null,null,null,null,null,19,"TURN_002_03",2,null,"Street 3 & Street 1","NBT",73,73,0,0]
[null,null,null,null,null,null,20,"TURN_002_04",2,null,"Street 3 & Street 1","NBR",86,86,0,0]
[null,null,null,null,null,null,21,"TURN_002_05",2,null,"Street 3 & Street 1","WBU",0,0,0,""]
[null,null,null,null,null,null,22,"TURN_002_06",2,null,"Street 3 & Street 1","WBL",93,93,0,0]
[null,null,null,null,null,null,23,"TURN_002_07",2,null,"Street 3 & Street 1","WBT",78,78,0,0]
[null,null,null,null,null,null,24,"TURN_002_08",2,null,"Street 3 & Street 1","WBR",86,86,0,0]
[null,null,null,null,null,null,25,"TURN_002_09",2,null,"Street 3 & Street 1","SBU",0,0,0,""]
[null,null,null,null,null,null,26,"TURN_002_10",2,null,"Street 3 & Street 1","SBL",51,51,0,0]
[null,null,null,null,null,null,27,"TURN_002_11",2,null,"Street 3 & Street 1","SBT",54,54,0,0]
[null,null,null,null,null,null,28,"TURN_002_12",2,null,"Street 3 & Street 1","SBR",93,93,0,0]
[null,null,null,null,null,null,29,"TURN_002_13",2,null,"Street 3 & Street 1","EBU",0,0,0,""]
[null,null,null,null,null,null,30,"TURN_002_14",2,null,"Street 3 & Street 1","EBL",74,74,0,0]
[null,null,null,null,null,null,31,"TURN_002_15",2,null,"Street 3 & Street 1","EBT",57,57,0,0]
[null,null,null,null,null,null,32,"TURN_002_16",2,null,"Street 3 & Street 1","EBR",50,50,0,0]
[null,null,null,null,null,null,33,"TURN_003_05",3,{"$f":"INDEX($D$9:$D$11, MATCH($I41,$C$9:$C$11,0))","v":"Street 3 & Street 2"},"Street 3 & Street 2","WBU",0,0,0,""]
[null,null,null,null,null,null,34,"TURN_003_07",3,null,"Street 3 & Street 2","WBT",60,60,0,0]
[null,null,null,null,null,null,35,"TURN_003_08",3,null,"Street 3 & Street 2","WBR",84,84,0,0]
[null,null,null,null,null,null,36,"TURN_003_09",3,null,"Street 3 & Street 2","SBU",0,0,0,""]
[null,null,null,null,null,null,37,"TURN_003_10",3,null,"Street 3 & Street 2","SBL",74,74,0,0]
[null,null,null,null,null,null,38,"TURN_003_12",3,null,"Street 3 & Street 2","SBR",61,61,0,0]
[null,null,null,null,null,null,39,"TURN_003_13",3,null,"Street 3 & Street 2","EBU",0,0,0,""]
[null,null,null,null,null,null,40,"TURN_003_14",3,null,"Street 3 & Street 2","EBL",98,98,0,0]
[null,null,null,null,null,null,41,"TURN_003_15",3,null,"Street 3 & Street 2","EBT",84,84,0,0]

{"sheet":"Raw-Initial Volume List Entry","index":3,"n_rows":27,"n_cols":21,"rows_kept":27,"cut":false,"hidden":false,"merged":[[21,5,21,8],[21,9,21,12],[21,13,21,16],[21,17,21,20],[8,12,8,15],[9,12,9,15],[15,17,15,20],[16,17,16,20],[15,12,15,13],[14,12,14,13],[22,3,22,4],[22,5,22,8],[22,9,22,12],[22,13,22,16],[22,17,22,20]]}
[]
[null,null,null,"Project",{"$f":"Schematic!$L$3","v":"(Highway XX Project)"}]
[null,null,null,"Scenario",{"$f":"Schematic!$L$4","v":"(Peak Period)"}]
[]
[]
[null,null,null,"Transfer Raw/Initial Volumes to/from the Schematic Worksheet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Turn Numbers in Schematic Orientation"]
[null,null,null,null,null,null,null,null,null,null,null,null,"ê",null,null,null,null,"<",8]
[null,null,null,null,null,null,null,null,null,null,null,null,"Top Leg",null,null,null,null,"!",7,"ç"]
[null,null,null,null,null,null,null,null,null,null,null,null,12,11,10,9,null,">",6,"Right Leg"]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"$","9","M",null,"N",5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"O",null,"L",":","#",";"]
[null,null,null,null,null,null,null,null,null,null,null,null,"è",null,14,"=",null,1,2,3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,"Left Leg",null,15,"\"",null,"é"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"?",null,"Bottom Leg"]
[]
[]
[]
[null,null,null,null,"Turn Number",12,11,10,9,8,7,6,5,4,3,2,1,16,15,14,13]
[null,null,null,null,null,"ê",null,null,null,"ç",null,null,null,"é",null,null,null,"è"]
[null,null,null,"Intersection",null,"Top Leg",null,null,null,"Right Leg",null,null,null,"Bottom Leg",null,null,null,"Left Leg"]
[null,null,null,"Number","Name","Right ","Thru ","Left ","U-Tn","Right ","Thru ","Left ","U-Tn","Right ","Thru ","Left ","U-Tn","Right ","Thru ","Left ","U-Tn"]
[null,null,null,{"$f":"Schematic!$AL$39","v":1},{"$f":"Schematic!$Y$25","v":"Street 2 & Street 1"},58,98,55,0,70,56,64,0,94,85,85,0,59,51,79,0]
[null,null,null,{"$f":"Schematic!$AL$74","v":2},{"$f":"Schematic!$Y$60","v":"Street 3 & Street 1"},93,54,51,0,86,78,93,0,86,73,71,0,50,57,74,0]
[null,null,null,{"$f":"Schematic!$BU$74","v":3},{"$f":"Schematic!$BH$60","v":"Street 3 & Street 2"},61,null,74,0,84,60,null,0,null,null,null,null,null,84,98,0]