{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MainMenu","InputSheet","Calcs","OutputSheet","TurnSheets","Data","XML"],"not_rendered":{"charts":0,"images":59,"macros":1,"external_links":0,"defined_names":3,"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":"MainMenu","index":0,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
["TURNS5 Turning Movement Analysis Tool - V2014"]
["Main Menu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"NOTES"]
[null,"The input process is fully menu driven - just fill in data at the prompts."]
[null,"Manually changing the data on the InputSheet page will NOT invoke the macros."]
[null,"The input last entered into the workbook will automatically be shown in prompts."]
[null,"If the shapes (arrows, boxes, buttons) on any tab become distorted, switch to Page "]
[null,"      Break Preview and back to Normal and the format will be corrected."]

{"sheet":"InputSheet","index":1,"n_rows":121,"n_cols":30,"rows_kept":121,"cut":false,"hidden":false,"merged":[[3,21,5,21],[63,4,63,5],[63,2,63,3],[34,8,36,11],[62,4,62,5],[31,4,33,4],[36,14,36,17],[7,2,8,4],[88,8,90,11],[31,3,33,3],[62,2,62,3],[61,8,63,11],[3,2,3,4],[9,2,9,4],[62,6,62,7],[0,8,0,13],[0,0,0,6],[61,4,61,5],[5,2,5,4],[6,2,6,4],[11,0,11,1],[61,2,61,3],[12,0,12,1],[61,6,61,7]]}
["TURNS5 ANALYSIS SHEET - INPUT",null,null,null,null,null,null,null,"Table Step 1a, directly below, contains unaltered DDHVs (not affected by any distribution required to run the macro).These values will feed into 'TurnSheets'."]
[]
[]
[null,"Analyst:",null,null,null,null,null,null,"Step 1a","Approach Volumes: Summarized AADT*K*D",null,null,null,null,null,"Step 1b","Departure Volumes: Summarized AADT*K*(1-D)",null,null,null,null,"Difference between Senter and Sexit. If positive, Sexit<Senter. If negative Sexit>Senter.",null,null,"Summarized AADT (Only used for TurnSheets graphic)"]
[null,"Date:",{"$f":"NOW()","v":"2019-05-16T10:22:52.340"},null,null,null,null,null,null,"From West:","From East:","From North:","From South:","Senter",null,null,"To West:","To East:","To North:","To South:","Sexit",null,null,null,null,"From West:","From East:","From North:","From South:","Senter"]
[null,"Highway:",null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL",null,"Year","WB Departure","EB Departure","NB Departure","SB Departure","TOTAL",null,"Senter=Sexit?",null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,"Intersection:",null,null,null,null,null,null,{"$f":"IF(Data!$B$2=\"yes\",$I$56,$I$42)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$56,0),ROUND($J$42,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$83,0),ROUND($J$69,0)),IF(Data!$B$2=\"yes\",ROUND($J$110,0),ROUND($J$96,0))))*VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$56,0),ROUND($K$42,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$83,0),ROUND($K$69,0)),IF(Data!$B$2=\"yes\",ROUND($K$110,0),ROUND($K$96,0))))*VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$56,0),ROUND($L$42,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$83,0),ROUND($L$69,0)),IF(Data!$B$2=\"yes\",ROUND($L$110,0),ROUND($L$96,0))))*VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$56,0),ROUND($M$42,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$83,0),ROUND($M$69,0)),IF(Data!$B$2=\"yes\",ROUND($M$110,0),ROUND($M$96,0))))*VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(J7:M7)","v":0},null,{"$f":"I7","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$56,0),ROUND($J$42,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$83,0),ROUND($J$69,0)),IF(Data!$B$2=\"yes\",ROUND($J$110,0),ROUND($J$96,0))))*(1-VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$56,0),ROUND($K$42,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$83,0),ROUND($K$69,0)),IF(Data!$B$2=\"yes\",ROUND($K$110,0),ROUND($K$96,0))))*(1-VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$56,0),ROUND($L$42,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$83,0),ROUND($L$69,0)),IF(Data!$B$2=\"yes\",ROUND($L$110,0),ROUND($L$96,0))))*(1-VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$56,0),ROUND($M$42,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$83,0),ROUND($M$69,0)),IF(Data!$B$2=\"yes\",ROUND($M$110,0),ROUND($M$96,0))))*(1-VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(Q7:T7)","v":0},{"$f":"N7-U7","v":0},{"$f":"IF(N7=U7,\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(Data!$B$2=\"yes\",$I$56,$I$42)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$56,0),ROUND($J$42,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$83,0),ROUND($J$69,0)),IF(Data!$B$2=\"yes\",ROUND($J$110,0),ROUND($J$96,0)))),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$56,0),ROUND($K$42,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$83,0),ROUND($K$69,0)),IF(Data!$B$2=\"yes\",ROUND($K$110,0),ROUND($K$96,0)))),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$56,0),ROUND($L$42,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$83,0),ROUND($L$69,0)),IF(Data!$B$2=\"yes\",ROUND($L$110,0),ROUND($L$96,0)))),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$56,0),ROUND($M$42,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$83,0),ROUND($M$69,0)),IF(Data!$B$2=\"yes\",ROUND($M$110,0),ROUND($M$96,0)))),0)","v":0},{"$f":"SUM(Z7:AC7)","v":0}]
[null,"Project:",null,null,null,null,null,null,{"$f":"IF(Data!$B$2=\"yes\",$I$57,$I$43)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$57,0),ROUND($J$43,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$84,0),ROUND($J$70,0)),IF(Data!$B$2=\"yes\",ROUND($J$111,0),ROUND($J$97,0))))*VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$57,0),ROUND($K$43,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$84,0),ROUND($K$70,0)),IF(Data!$B$2=\"yes\",ROUND($K$111,0),ROUND($K$97,0))))*VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$57,0),ROUND($L$43,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$84,0),ROUND($L$70,0)),IF(Data!$B$2=\"yes\",ROUND($L$111,0),ROUND($L$97,0))))*VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$57,0),ROUND($M$43,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$84,0),ROUND($M$70,0)),IF(Data!$B$2=\"yes\",ROUND($M$111,0),ROUND($M$97,0))))*VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(J8:M8)","v":0},null,{"$f":"I8","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$57,0),ROUND($J$43,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$84,0),ROUND($J$70,0)),IF(Data!$B$2=\"yes\",ROUND($J$111,0),ROUND($J$97,0))))*(1-VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$57,0),ROUND($K$43,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$84,0),ROUND($K$70,0)),IF(Data!$B$2=\"yes\",ROUND($K$111,0),ROUND($K$97,0))))*(1-VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$57,0),ROUND($L$43,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$84,0),ROUND($L$70,0)),IF(Data!$B$2=\"yes\",ROUND($L$111,0),ROUND($L$97,0))))*(1-VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$57,0),ROUND($M$43,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$84,0),ROUND($M$70,0)),IF(Data!$B$2=\"yes\",ROUND($M$111,0),ROUND($M$97,0))))*(1-VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(Q8:T8)","v":0},{"$f":"N8-U8","v":0},{"$f":"IF(N8=U8,\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(Data!$B$2=\"yes\",$I$57,$I$43)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$57,0),ROUND($J$43,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$84,0),ROUND($J$70,0)),IF(Data!$B$2=\"yes\",ROUND($J$111,0),ROUND($J$97,0)))),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$57,0),ROUND($K$43,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$84,0),ROUND($K$70,0)),IF(Data!$B$2=\"yes\",ROUND($K$111,0),ROUND($K$97,0)))),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$57,0),ROUND($L$43,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$84,0),ROUND($L$70,0)),IF(Data!$B$2=\"yes\",ROUND($L$111,0),ROUND($L$97,0)))),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$57,0),ROUND($M$43,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$84,0),ROUND($M$70,0)),IF(Data!$B$2=\"yes\",ROUND($M$111,0),ROUND($M$97,0)))),0)","v":0},{"$f":"SUM(Z8:AC8)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$2=\"yes\",$I$58,$I$44)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$58,0),ROUND($J$44,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$85,0),ROUND($J$71,0)),IF(Data!$B$2=\"yes\",ROUND($J$112,0),ROUND($J$98,0))))*VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$58,0),ROUND($K$44,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$85,0),ROUND($K$71,0)),IF(Data!$B$2=\"yes\",ROUND($K$112,0),ROUND($K$98,0))))*VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$58,0),ROUND($L$44,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$85,0),ROUND($L$71,0)),IF(Data!$B$2=\"yes\",ROUND($L$112,0),ROUND($L$98,0))))*VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$58,0),ROUND($M$44,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$85,0),ROUND($M$71,0)),IF(Data!$B$2=\"yes\",ROUND($M$112,0),ROUND($M$98,0))))*VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(J9:M9)","v":0},null,{"$f":"I9","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$58,0),ROUND($J$44,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$85,0),ROUND($J$71,0)),IF(Data!$B$2=\"yes\",ROUND($J$112,0),ROUND($J$98,0))))*(1-VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$58,0),ROUND($K$44,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$85,0),ROUND($K$71,0)),IF(Data!$B$2=\"yes\",ROUND($K$112,0),ROUND($K$98,0))))*(1-VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$58,0),ROUND($L$44,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$85,0),ROUND($L$71,0)),IF(Data!$B$2=\"yes\",ROUND($L$112,0),ROUND($L$98,0))))*(1-VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$58,0),ROUND($M$44,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$85,0),ROUND($M$71,0)),IF(Data!$B$2=\"yes\",ROUND($M$112,0),ROUND($M$98,0))))*(1-VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(Q9:T9)","v":0},{"$f":"N9-U9","v":0},{"$f":"IF(N9=U9,\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(Data!$B$2=\"yes\",$I$58,$I$44)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$58,0),ROUND($J$44,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$85,0),ROUND($J$71,0)),IF(Data!$B$2=\"yes\",ROUND($J$112,0),ROUND($J$98,0)))),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$58,0),ROUND($K$44,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$85,0),ROUND($K$71,0)),IF(Data!$B$2=\"yes\",ROUND($K$112,0),ROUND($K$98,0)))),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$58,0),ROUND($L$44,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$85,0),ROUND($L$71,0)),IF(Data!$B$2=\"yes\",ROUND($L$112,0),ROUND($L$98,0)))),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$58,0),ROUND($M$44,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$85,0),ROUND($M$71,0)),IF(Data!$B$2=\"yes\",ROUND($M$112,0),ROUND($M$98,0)))),0)","v":0},{"$f":"SUM(Z9:AC9)","v":0}]
[null,"County:",null,null,null,null,null,null,{"$f":"IF(Data!$B$2=\"yes\",$I$59,$I$45)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$59,0),ROUND($J$45,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$86,0),ROUND($J$72,0)),IF(Data!$B$2=\"yes\",ROUND($J$113,0),ROUND($J$99,0))))*VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$59,0),ROUND($K$45,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$86,0),ROUND($K$72,0)),IF(Data!$B$2=\"yes\",ROUND($K$113,0),ROUND($K$99,0))))*VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$59,0),ROUND($L$45,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$86,0),ROUND($L$72,0)),IF(Data!$B$2=\"yes\",ROUND($L$113,0),ROUND($L$99,0))))*VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$59,0),ROUND($M$45,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$86,0),ROUND($M$72,0)),IF(Data!$B$2=\"yes\",ROUND($M$113,0),ROUND($M$99,0))))*VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE)*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(J10:M10)","v":0},null,{"$f":"I10","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$59,0),ROUND($J$45,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$86,0),ROUND($J$72,0)),IF(Data!$B$2=\"yes\",ROUND($J$113,0),ROUND($J$99,0))))*(1-VLOOKUP(\"Eastbound (EB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$59,0),ROUND($K$45,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$86,0),ROUND($K$72,0)),IF(Data!$B$2=\"yes\",ROUND($K$113,0),ROUND($K$99,0))))*(1-VLOOKUP(\"Westbound (WB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$18,$C$16),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$59,0),ROUND($L$45,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$86,0),ROUND($L$72,0)),IF(Data!$B$2=\"yes\",ROUND($L$113,0),ROUND($L$99,0))))*(1-VLOOKUP(\"Southbound (SB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$59,0),ROUND($M$45,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$86,0),ROUND($M$72,0)),IF(Data!$B$2=\"yes\",ROUND($M$113,0),ROUND($M$99,0))))*(1-VLOOKUP(\"Northbound (NB)\",$E$16:$F$20,2,FALSE))*IF(Data!$B$1=\"Yes\",$C$16,$C$18),0)","v":0},{"$f":"SUM(Q10:T10)","v":0},{"$f":"N10-U10","v":0},{"$f":"IF(N10=U10,\"Yes\",\"No\")","v":"Yes"},null,{"$f":"IF(Data!$B$2=\"yes\",$I$59,$I$45)","v":0},{"$f":"ROUND(IF($J$11=1,IF(Data!$B$2=\"yes\",ROUND($J$59,0),ROUND($J$45,0)),IF($J$11=2,IF(Data!$B$2=\"yes\",ROUND($J$86,0),ROUND($J$72,0)),IF(Data!$B$2=\"yes\",ROUND($J$113,0),ROUND($J$99,0)))),0)","v":0},{"$f":"ROUND(IF($K$11=1,IF(Data!$B$2=\"yes\",ROUND($K$59,0),ROUND($K$45,0)),IF($K$11=2,IF(Data!$B$2=\"yes\",ROUND($K$86,0),ROUND($K$72,0)),IF(Data!$B$2=\"yes\",ROUND($K$113,0),ROUND($K$99,0)))),0)","v":0},{"$f":"ROUND(IF($L$11=1,IF(Data!$B$2=\"yes\",ROUND($L$59,0),ROUND($L$45,0)),IF($L$11=2,IF(Data!$B$2=\"yes\",ROUND($L$86,0),ROUND($L$72,0)),IF(Data!$B$2=\"yes\",ROUND($L$113,0),ROUND($L$99,0)))),0)","v":0},{"$f":"ROUND(IF($M$11=1,IF(Data!$B$2=\"yes\",ROUND($M$59,0),ROUND($M$45,0)),IF($M$11=2,IF(Data!$B$2=\"yes\",ROUND($M$86,0),ROUND($M$72,0)),IF(Data!$B$2=\"yes\",ROUND($M$113,0),ROUND($M$99,0)))),0)","v":0},{"$f":"SUM(Z10:AC10)","v":0}]
[null,null,null,null,null,null,null,null,"calc method",{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1},null,null,{"$f":"I11","v":"calc method"},{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1},null,null,null,null,"calc method",{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"no\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1},{"$f":"IF(Data!$B$1=\"yes\",Data!$B$8,Data!$C$8)","v":1}]
["Is the Mainline"]
["Oriented North/South?",null,null,null,null,null,null,null,"Step 2a","Approach Volumes to be distributed",null,null,null,null,null,"Step 2b","Departure Volumes to be distributed"]
[null,null,null,null,null,null,null,null,null,"From West:","From East:","From North:","From South:",null,null,null,"To West:","To East:","To North:","To South:"]
[null,"K Factors","Mainline",null,"D Factors","Mainline",null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL",null,"Year","WB Departure","EB Departure","NB Departure","SB Departure","TOTAL"]
[null,null,7.0000000000000007E-2,null,{"$f":"IF(Data!B1=\"yes\",\"Northbound (NB)\",\"Westbound (WB)\")","v":"Westbound (WB)"},0.5,null,null,{"$f":"I7","v":0},{"$f":"IF($V7>=0,\" \",ROUND(J7/$N7*ABS($V7),0))","v":" "}," ",{"$f":"IF($V7>=0,\" \",IF(Data!B5=0,ABS(V7)-J16-K16,ROUND(L7/$N7*ABS($V7),0)))","v":" "},{"$f":"IF($V7>=0,\" \",IF(Data!B5=0,0,ABS($V7)-SUM(J16:L16)))","v":" "},{"$f":"SUM(J16:M16)","v":0},null,{"$f":"P7","v":0},{"$f":"IF($V7<=0,\" \",ROUND(Q7/$U7*$V7,0))","v":" "}," ",{"$f":"IF($V7<=0,\" \",IF(Data!B5=0,V7-Q16-R16,ROUND(S7/$U7*$V7,0)))","v":" "},{"$f":"IF($V7<=0,\" \",IF(Data!B5=0,0,$V7-SUM(Q16:S16)))","v":" "},{"$f":"SUM(Q16:T16)","v":0}]
[null,null,"Side street",null,{"$f":"IF(Data!B1=\"yes\",\"Southbound (SB)\",\"Eastbound (EB)\")","v":"Eastbound (EB)"},0.5,null,null,{"$f":"I8","v":0}," "," ",{"$f":"IF($V8>=0,\" \",IF(Data!B5=0,ABS(V8)-J17-K17,ROUND(L8/$N8*ABS($V8),0)))","v":" "},{"$f":"IF($V8>=0,\" \",IF(Data!B5=0,0,ABS($V8)-SUM(J17:L17)))","v":" "},{"$f":"SUM(J17:M17)","v":0},null,{"$f":"P8","v":0}," "," ",{"$f":"IF($V8<=0,\" \",IF(Data!B5=0,V8-Q17-R17,ROUND(S8/$U8*$V8,0)))","v":" "},{"$f":"IF($V8<=0,\" \",IF(Data!B5=0,0,$V8-SUM(Q17:S17)))","v":" "},{"$f":"SUM(Q17:T17)","v":0}]
[null,null,7.0000000000000007E-2,null,null,"Side street",null,null,{"$f":"I9","v":0}," "," ",{"$f":"IF($V9>=0,\" \",IF(Data!B5=0,ABS(V9)-J18-K18,ROUND(L9/$N9*ABS($V9),0)))","v":" "},{"$f":"IF($V9>=0,\" \",IF(Data!B5=0,0,ABS($V9)-SUM(J18:L18)))","v":" "},{"$f":"SUM(J18:M18)","v":0},null,{"$f":"P9","v":0}," "," ",{"$f":"IF($V9<=0,\" \",IF(Data!B5=0,V9-Q18-R18,ROUND(S9/$U9*$V9,0)))","v":" "},{"$f":"IF($V9<=0,\" \",IF(Data!B5=0,0,$V9-SUM(Q18:S18)))","v":" "},{"$f":"SUM(Q18:T18)","v":0}]
[null,null,null,null,{"$f":"IF(Data!B1=\"no\",\"Northbound (NB)\",\"Westbound (WB)\")","v":"Northbound (NB)"},0.5,null,null,{"$f":"I10","v":0}," "," ",{"$f":"IF($V10>=0,\" \",IF(Data!B5=0,V10-J19-K19,ROUND(L10/$N10*$V10,0)))","v":" "},{"$f":"IF($V10>=0,\" \",IF(Data!B5=0,0,ABS($V10)-SUM(J19:L19)))","v":" "},{"$f":"SUM(J19:M19)","v":0},null,{"$f":"P10","v":0}," "," ",{"$f":"IF($V10<=0,\" \",IF(Data!B5=0,V10-Q19-R19,ROUND(S10/$U10*$V10,0)))","v":" "},{"$f":"IF($V10<=0,\" \",IF(Data!B5=0,0,$V10-SUM(Q19:S19)))","v":" "},{"$f":"SUM(Q19:T19)","v":0}]
[null,null,null,null,{"$f":"IF(Data!B1=\"no\",\"Southbound (SB)\",\"Eastbound (EB)\")","v":"Southbound (SB)"},0.5]
[null,null,null,null,null,null,null,null,"Step 3a","Final Approach Volumes",null,null,null,null,null,"Step 3b","Final Departure Volumes",null,null,null,null,"Difference between Senter and Sexit. Should be 0 on this step."]
[null,null,null,null,null,null,null,null,null,"From West:","From East:","From North:","From South:",null,null,null,"To West:","To East:","To North:","To South:"]
["Do you have FTSUTMS Model Year traffic from which you would like to ",null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL",null,"Year","WB Departure","EB Departure","NB Departure","SB Departure","TOTAL",null,"Senter=Sexit?"]
[null,"interpolate/extrapolate for project years? (Y/N)",null,null,null,null,null,null,{"$f":"I7","v":0},{"$f":"IF(J16=\" \",J7,J7+ABS(J16))","v":0},0,0,0,{"$f":"SUM(J24:M24)","v":0},null,{"$f":"P7","v":0},{"$f":"IF(Q16=\" \",Q7,Q7+Q16)","v":0},0,0,0,{"$f":"SUM(Q24:T24)","v":0},{"$f":"N24-U24","v":0},{"$f":"IF(N24=U24,\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":0},0,0,0,0,{"$f":"SUM(J25:M25)","v":0},null,{"$f":"P8","v":0},0,0,0,0,{"$f":"SUM(Q25:T25)","v":0},{"$f":"N25-U25","v":0},{"$f":"IF(N25=U25,\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,"If \"Yes\" go to cell C47",null,"If \"No\" go to cell C31",null,{"$f":"I9","v":0},0,0,0,0,{"$f":"SUM(J26:M26)","v":0},null,{"$f":"P9","v":0},0,0,0,0,{"$f":"SUM(Q26:T26)","v":0},{"$f":"N26-U26","v":0},{"$f":"IF(N26=U26,\"Yes\",\"No\")","v":"Yes"}]
[null,null,null,null,null,null,null,null,{"$f":"I10","v":0},0,0,0,0,{"$f":"SUM(J27:M27)","v":0},null,{"$f":"P10","v":0},0,0,0,0,{"$f":"SUM(Q27:T27)","v":0},{"$f":"N27-U27","v":0},{"$f":"IF(N27=U27,\"Yes\",\"No\")","v":"Yes"}]
[]
[null,"Enter Year and Growth Rates from Base Year:"]
[null,null,"Year","Rate","(1.0% = 0.01)"]
[null,"Base  ",null,"Mainline","Side Street"]
[null,"Opening  "]
[null,"Mid  "]
[null,"Design  "]
[null,null,null,null,null,null,null,null,"Linear Calcs"]
[]
[null,"Enter Base Year AADTs for Volume Comparison:",null,null,null,null,null,null,null,null,null,null,null,null,"Diagram to accompany above tables nomenclature "]
[null,null,"(growth rates are used to calculate other project years)"]
[null,null,null,null,null,null,null,null,"Calculated by Extrapolation using Rates"]
[null,"From West:","From East:","From North:","From South:",null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,"EB Approach","WB Approach","SB Approach","NB Approach","TOTAL",null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,0,0,0,0,{"$f":"SUM(B42:E42)","v":0},null,null,{"$f":"C31","v":0},{"$f":"B42","v":0},{"$f":"C42","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0},{"$f":"SUM(J42:M42)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C32","v":0},{"$f":"J42*(1+J47*($I43-$I42))","v":0},{"$f":"K42*(1+K47*($I43-$I42))","v":0},{"$f":"L42*(1+L47*($I43-$I42))","v":0},{"$f":"M42*(1+M47*($I43-$I42))","v":0},{"$f":"SUM(J43:M43)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C33","v":0},{"$f":"J42*(1+J47*($I44-$I42))","v":0},{"$f":"K42*(1+K47*($I44-$I42))","v":0},{"$f":"L42*(1+L47*($I44-$I42))","v":0},{"$f":"M42*(1+M47*($I44-$I42))","v":0},{"$f":"SUM(J44:M44)","v":0}]
[null,"Enter Project and Model Years",null,null,null,null,null,null,{"$f":"C34","v":0},{"$f":"J42*(1+J47*($I45-$I42))","v":0},{"$f":"K42*(1+K47*($I45-$I42))","v":0},{"$f":"L42*(1+L47*($I45-$I42))","v":0},{"$f":"M42*(1+M47*($I45-$I42))","v":0},{"$f":"SUM(J45:M45)","v":0}]
[null,null,"Year"]
[null,"Base  ",null,null,null,null,null,null,"Rates",{"$f":"IF(Data!$B$1=\"yes\",E32,D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",E32,D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",D32,E32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",D32,E32)","v":0}]
[null,"Opening  "]
[null,"Mid  "]
[null,"Design  "]
[null,"Model  "]
[]
[null,"Enter Base and Model Year AADTs for Volume Comparison:",null,null,null,null,null,null,"Calculated by Interpolation Using Model Output"]
[null,null,"(volumes for other project years are calculated by interpolation)",null,null,null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,"From West:","From East:","From North:","From South:",null,null,null,{"$f":"C47","v":0},{"$f":"B58","v":0},{"$f":"C58","v":0},{"$f":"D58","v":0},{"$f":"E58","v":0},{"$f":"SUM(J56:M56)","v":0}]
[null,"EB Approach","WB Approach","SB Approach","NB Approach","TOTAL",null,null,{"$f":"C48","v":0},{"$f":"($I57-$I$56)/($C$51-$I$56)*(B$59-B$58)+J$56","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"($I57-$I$56)/($C$51-$I$56)*(D$59-D$58)+L$56","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"SUM(J57:M57)","v":{"$error":"#DIV/0!"}}]
[{"$f":"C47","v":0},0,0,0,0,{"$f":"SUM(B58:E58)","v":0},null,null,{"$f":"C49","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J58:M58)","v":{"$error":"#DIV/0!"}}]
[{"$f":"C51","v":0},0,0,0,0,{"$f":"SUM(B59:E59)","v":0},null,null,{"$f":"C50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J59:M59)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"1st Guess",null,{"$f":"\"  Actual/Counted\"","v":"  Actual/Counted"},null,"First Guess Turning % Option Used",null,"Exponential Calcs"]
[null,null,"Turning %'s for",null,{"$f":"\"  Traffic\"","v":"  Traffic"},null,"Existing Turning Movement Counts"]
[null,null,"AADT Balancing",null,{"$f":"\"  for \"&IF(Data!B2=\"yes\",C47,C31)","v":"  for "}]
[null,"(EB LT) ","West-to-North",null,0]
[null,"(EB THRU) ","West-to-East",null,0,null,null,null,"Calculated by Extrapolation using Rates"]
[null,"(EB RT) ","West-to-South",null,0,null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,"(WB LT) ","East-to-South",null,0,null,null,null,{"$f":"C31","v":0},{"$f":"B42","v":0},{"$f":"C42","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0},{"$f":"SUM(J69:M69)","v":0}]
[null,"(WB THRU) ","East-to-West",null,0,null,null,null,{"$f":"C32","v":0},{"$f":"J69*(1+J74)^($I70-$I69)","v":0},{"$f":"K69*(1+K74)^($I70-$I69)","v":0},{"$f":"L69*(1+L74)^($I70-$I69)","v":0},{"$f":"M69*(1+M74)^($I70-$I69)","v":0},{"$f":"SUM(J70:M70)","v":0}]
[null,"(WB RT) ","East-to-North",null,0,null,null,null,{"$f":"C33","v":0},{"$f":"J69*(1+J74)^($I71-$I69)","v":0},{"$f":"K69*(1+K74)^($I71-$I69)","v":0},{"$f":"L69*(1+L74)^($I71-$I69)","v":0},{"$f":"M69*(1+M74)^($I71-$I69)","v":0},{"$f":"SUM(J71:M71)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C34","v":0},{"$f":"J69*(1+J74)^($I72-$I69)","v":0},{"$f":"K69*(1+K74)^($I72-$I69)","v":0},{"$f":"L69*(1+L74)^($I72-$I69)","v":0},{"$f":"M69*(1+M74)^($I72-$I69)","v":0},{"$f":"SUM(J72:M72)","v":0}]
[null,"(SB LT) ","North-to-East",null,0]
[null,"(SB THRU) ","North-to-South",null,0,null,null,null,"Rates",{"$f":"IF(Data!$B$1=\"yes\",E32,D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",E32,D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",D32,E32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",D32,E32)","v":0}]
[null,"(SB RT) ","North-to-West",null,0]
[]
[null,"(NB LT) ","South-to-West",null,0]
[null,"(NB THRU) ","South-to-North",null,0]
[null,"(NB RT) ","South-to-East",null,0]
[null,null,null,null,null,null,null,null,"Calculated by Interpolation Using Model Output"]
[null,"Desired Closure:",null,0.01,null,null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,null,null,null,null,null,null,null,{"$f":"C47","v":0},{"$f":"B58","v":0},{"$f":"C58","v":0},{"$f":"D58","v":0},{"$f":"E58","v":0},{"$f":"SUM(J83:M83)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C48","v":0},{"$f":"J$83*(1+((J$86-J$83)/J$83+1)^(1/($I$86-$I$83))-1)^($I84-$I$83)","v":{"$error":"#DIV/0!"}},{"$f":"K$83*(1+((K$86-K$83)/K$83+1)^(1/($I$86-$I$83))-1)^($I84-$I$83)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J84:M84)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C49","v":0},{"$f":"J$83*(1+((J$86-J$83)/J$83+1)^(1/($I$86-$I$83))-1)^($I85-$I$83)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J85:M85)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C50","v":0},{"$f":"($I86-$I$56)/($C$51-$I$56)*(B$59-B$58)+J$56","v":{"$error":"#DIV/0!"}},{"$f":"($I86-$I$56)/($C$51-$I$56)*(C$59-C$58)+K$56","v":{"$error":"#DIV/0!"}},{"$f":"($I86-$I$56)/($C$51-$I$56)*(D$59-D$58)+L$56","v":{"$error":"#DIV/0!"}},{"$f":"($I86-$I$56)/($C$51-$I$56)*(E$59-E$58)+M$56","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J86:M86)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,"Decaying Exponential (Logarithmic) Calcs"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Calculated by Extrapolation using Rates"]
[null,null,null,null,null,null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,null,null,null,null,null,null,null,{"$f":"C31","v":0},{"$f":"B42","v":0},{"$f":"C42","v":0},{"$f":"D42","v":0},{"$f":"E42","v":0},{"$f":"SUM(J96:M96)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C32","v":0},{"$f":" J$104 * LOG($I97-$I$96 + 1)+J$96","v":{"$error":"#DIV/0!"}},{"$f":" K$104 * LOG($I97-$I$96 + 1)+K$96","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J97:M97)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C33","v":0},{"$f":" J$104 * LOG($I98-$I$96 + 1)+J$96","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J98:M98)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C34","v":0},{"$f":" J$104 * LOG($I99-$I$96 + 1)+J$96","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J99:M99)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Linear Rate",{"$f":"IF(Data!$B$1=\"yes\",$E32,$D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",$E32,$D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",$E32,$D32)","v":0},{"$f":"IF(Data!$B$1=\"yes\",$E32,$D32)","v":0}]
[null,null,null,null,null,null,null,null,"Out Year (y2)",{"$f":"J96*J101*($I99-$I96)+J96","v":0},{"$f":"K96*K101*($I99-$I96)+K96","v":0},{"$f":"L96*L101*($I99-$I96)+L96","v":0},{"$f":"M96*M101*($I99-$I96)+M96","v":0}]
[null,null,null,null,null,null,null,null,"In Year (y1)",{"$f":"J96","v":0},{"$f":"K96","v":0},{"$f":"L96","v":0},{"$f":"M96","v":0}]
[null,null,null,null,null,null,null,null,"b",{"$f":"(J102-J103)/LOG($I99-$I96+1)","v":{"$error":"#DIV/0!"}},{"$f":"(K102-K103)/LOG($I99-$I96+1)","v":{"$error":"#DIV/0!"}},{"$f":"(L102-L103)/LOG($I99-$I96+1)","v":{"$error":"#DIV/0!"}},{"$f":"(M102-M103)/LOG($I99-$I96+1)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,"Calculated by Interpolation Using Model Output"]
[null,null,null,null,null,null,null,null,null,"From West:","From East:","From North:","From South:"]
[null,null,null,null,null,null,null,null,"Year","EB Approach","WB Approach","SB Approach","NB Approach","TOTAL"]
[null,null,null,null,null,null,null,null,{"$f":"C47","v":0},{"$f":"J83","v":0},{"$f":"K83","v":0},{"$f":"L83","v":0},{"$f":"M83","v":0},{"$f":"SUM(J110:M110)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"C48","v":0},{"$f":"J$119+J$121*LN($I111-$I$110+1)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J111:M111)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C49","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J112:M112)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"C50","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J113:M113)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,"y1=a+b*ln x1","x1=",1,"y1=","row 110 values"]
[null,null,null,null,null,null,null,null,null,"y2=a+b*ln x2","x2=",{"$f":"$C$51-I110+1","v":1},"y2=","row 59 values"]
[null,null,null,null,null,null,null,null,null,{"$f":"\"n = year - \" &I110","v":"n = year - 0"}]
[null,null,null,null,null,null,null,null,null,"b=(y2-y1)/(ln(x2))"]
[null,null,null,null,null,null,null,null,"y1=a=",{"$f":"J110","v":0},{"$f":"K110","v":0},{"$f":"L110","v":0},{"$f":"M110","v":0}]
[null,null,null,null,null,null,null,null,"y2-y1",{"$f":"B59-J110","v":0},{"$f":"C59-K110","v":0},{"$f":"D59-L110","v":0},{"$f":"E59-M110","v":0}]
[null,null,null,null,null,null,null,null,"b",{"$f":"J120/LN($L$116)","v":{"$error":"#DIV/0!"}},{"$f":"K120/LN($L$116)","v":{"$error":"#DIV/0!"}},{"$f":"L120/LN($L$116)","v":{"$error":"#DIV/0!"}},{"$f":"M120/LN($L$116)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Calcs","index":2,"n_rows":318,"n_cols":23,"rows_kept":318,"cut":false,"hidden":false,"merged":[[29,3,32,5],[109,3,112,5],[189,3,192,5],[269,3,272,5]]}
["TURNFLOW - Intersection Turning Movement Program"]
[" (c) Mark C. Schaefer, May 1988, Version 1.00"]
[]
["Modified to Version 4.00, 10/95"]
["by Susan C. Newman / Richard Oujevolk - TEI Orlando, FL"]
["Adapted to Windows 2000, Windows XP, Microsoft Excel2003 by Mike Phillips and Loren Bloomberg CH2M HILL 5/2005"]
["Adapted to accept 3-way intersections by Amanda Schram and Nicholi Arnio RS&H 1/2014"]
["NOTE TO USERS:",null,null,null,null,null,null,null,null,null,null,"The total traffic into the intersection from approach i"]
[null,null,null,null,null,null,null,null,null,null,null,"The total flow out of the intersection to approach j"]
["PURPOSE:","This program computes a likely set of intersection turning movements ",null,null,null,null,null,null,null,null,null,"The total traffic flow from approach i to approach j (i.e. the turning movement from approach i to approach j)"]
[null,"from intersection approach counts and the user's \"best guess\" of the",null,null,null,null,null,null,null,null,null,"The proportion of the approach i traffic flow that turns in the direction of j"]
[null,"turning proportions from each approach.",null,null,null,null,null,null,null,null,null,"The sum of entering flows (equals exiting flows)"]
[null,null,null,null,null,null,null,null,null,null,null,"The number of intersection approaches"]
["REFERENCE:","E. Hauer, E. Pagitsas, and B.T. Shin. \"Estimation of Turning Flows"]
[null,"from Automatic Counts\".  Transportation Research Record #795. 1981."]
[]
["Following are the calculations of the algorithm which produce the output summary table."]
["The spreadsheet offers no new theory to that proposed in the technical reference identified "]
["above.  Users are advised against customizing the spreadsheet since changes may affect"]
["the correct functioning of the macros built into the spreadsheet."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
["BASE YEAR CALCULATIONS:",null,{"$f":"InputSheet!I7","v":0}]
[null,"ORIGINAL","ADJUSTED"]
["eb A1 =",{"$f":"InputSheet!J24/SQRT(InputSheet!N24)","v":{"$error":"#DIV/0!"}},33.746848461175176,"These cells are updated by the macro code - do not protect this range or enter any data in them."]
["wb A2 =",{"$f":"InputSheet!K24/SQRT(InputSheet!N24)","v":{"$error":"#DIV/0!"}},7.1429424435522719]
["sb A3 =",{"$f":"InputSheet!L24/SQRT(InputSheet!N24)","v":{"$error":"#DIV/0!"}},7.0268424373142215]
["nb A4 =",{"$f":"InputSheet!M24/SQRT(InputSheet!N24)","v":{"$error":"#DIV/0!"}},25.74828528324942]
[]
["COMPUTE Bj",{"$f":"C28","v":0}]
["wb B1 =",{"$f":"IF(InputSheet!D$70*Calcs!C31+InputSheet!D$75*C32+InputSheet!D$77*C33=0,0,InputSheet!Q24/(InputSheet!D$70*Calcs!C31+InputSheet!D$75*C32+InputSheet!D$77*C33))","v":0}]
["eb B2 =",{"$f":"IF(InputSheet!D$66*Calcs!C30+InputSheet!D$73*C32+InputSheet!D$79*C33=0,0,InputSheet!R24/(InputSheet!D$66*Calcs!C30+InputSheet!D$73*C32+InputSheet!D$79*C33))","v":0}]
["nb B3 =",{"$f":"IF(InputSheet!D$65*Calcs!C30+InputSheet!D$71*C31+InputSheet!D$78*C33=0,0,InputSheet!S24/(InputSheet!D$65*Calcs!C30+InputSheet!D$71*C31+InputSheet!D$78*C33))","v":0}]
["sb B4 =",{"$f":"IF(InputSheet!D$67*Calcs!C30+InputSheet!D$69*C31+InputSheet!D$74*C32=0,0,InputSheet!T24/(InputSheet!D$67*Calcs!C30+InputSheet!D$69*C31+InputSheet!D$74*C32))","v":0}]
[]
["COMPUTE Anew",{"$f":"B35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["eb A1 =",{"$f":"IF(InputSheet!D$66*Calcs!B37+InputSheet!D$65*B38+InputSheet!D$67*B39=0,0,InputSheet!J24/(InputSheet!D$66*Calcs!B37+InputSheet!D$65*B38+InputSheet!D$67*B39))","v":0}]
["wb A2 =",{"$f":"IF(InputSheet!D$70*Calcs!B36+InputSheet!D$71*B38+InputSheet!D$69*B39=0,0,InputSheet!K24/(InputSheet!D$70*Calcs!B36+InputSheet!D$71*B38+InputSheet!D$69*B39))","v":0}]
["sb A3 =",{"$f":"IF(InputSheet!D$75*Calcs!B36+InputSheet!D$73*B37+InputSheet!D$74*B39=0,0,InputSheet!L24/(InputSheet!D$75*Calcs!B36+InputSheet!D$73*B37+InputSheet!D$74*B39))","v":0}]
["nb A4 =",{"$f":"IF(InputSheet!D$77*Calcs!B36+InputSheet!D$79*B37+InputSheet!D$78*B38=0,0,InputSheet!M24/(InputSheet!D$77*Calcs!B36+InputSheet!D$79*B37+InputSheet!D$78*B38))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["COMPUTE DIFFERENCE Acurrent - Anew"]
[null,"ADJ. CURRENT",null,"ABS(DIFF) >"]
[null," - ANEW =",null,"CLOSURE","FLAG"]
[null,"DIFF","ABS(DIFF)","(1=TRUE)","KEY"]
[null,{"$f":"C30-B42","v":33.746848461175176},{"$f":"ABS(B51)","v":33.746848461175176},{"$f":"IF(C51>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C31-B43","v":7.1429424435522719},{"$f":"ABS(B52)","v":7.1429424435522719},{"$f":"IF(C52>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C32-B44","v":7.0268424373142215},{"$f":"ABS(B53)","v":7.0268424373142215},{"$f":"IF(C53>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C33-B45","v":25.74828528324942},{"$f":"ABS(B54)","v":25.74828528324942},{"$f":"IF(C54>InputSheet!$D$81,1,0)","v":1}]
[null,"Max of Abs= ",{"$f":"MAX(C51:C54)","v":33.746848461175176},{"$f":"MAX(D51:D54)","v":1},{"$f":"IF(D55>0,1,0)","v":1}]
[]
["COMPUTE TURNING MOVEMENTS"]
[null,null,null,"Proportion"]
[null,null,{"$f":"C28","v":0},"of Total"]
["T12","West-to-East",{"$f":"InputSheet!D66*Calcs!B42*Calcs!B37","v":0},{"$f":"IF(C63=0,0,C60/C63)","v":0}]
["T13","West-to-North",{"$f":"InputSheet!D65*Calcs!B42*Calcs!B38","v":0},{"$f":"IF(C63=0,0,C61/C63)","v":0}]
["T14","West-to-South",{"$f":"InputSheet!D67*Calcs!B42*Calcs!B39","v":0},{"$f":"IF(C63=0,0,C62/C63)","v":0}]
[null,null,{"$f":"SUM(C60:C62)","v":0},1]
[]
["T21","East-to-West",{"$f":"InputSheet!D70*Calcs!B43*Calcs!B36","v":0},{"$f":"IF(C68=0,0,C65/C68)","v":0}]
["T23","East-to-North",{"$f":"InputSheet!D71*Calcs!B43*Calcs!B38","v":0},{"$f":"IF(C68=0,0,C66/C68)","v":0}]
["T24","East-to-South",{"$f":"InputSheet!D69*Calcs!B43*Calcs!B39","v":0},{"$f":"IF(C68=0,0,C67/C68)","v":0}]
[null,null,{"$f":"SUM(C65:C67)","v":0},1]
[]
["T31","North-to-West",{"$f":"InputSheet!D75*Calcs!B44*Calcs!B36","v":0},{"$f":"IF(C73=0,0,C70/C73)","v":0}]
["T32","North-to-East",{"$f":"InputSheet!D73*Calcs!B44*Calcs!B37","v":0},{"$f":"IF(C73=0,0,C71/C73)","v":0}]
["T34","North-to-South",{"$f":"InputSheet!D74*Calcs!B44*Calcs!B39","v":0},{"$f":"IF(C73=0,0,C72/C73)","v":0}]
[null,null,{"$f":"SUM(C70:C72)","v":0},1]
[]
["T41","South-to-West",{"$f":"InputSheet!D77*Calcs!B45*Calcs!B36","v":0},{"$f":"IF(C78=0,0,C75/C78)","v":0}]
["T42","South-to-East",{"$f":"InputSheet!D79*Calcs!B45*Calcs!B37","v":0},{"$f":"IF(C78=0,0,C76/C78)","v":0}]
["T43","South-to-North",{"$f":"InputSheet!D78*Calcs!B45*Calcs!B38","v":0},{"$f":"IF(C78=0,0,C77/C78)","v":0}]
[null,null,{"$f":"SUM(C75:C77)","v":0},1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OPENING YEAR CALCULATIONS:",null,{"$f":"InputSheet!I8","v":0}]
[null,"ORIGINAL","ADJUSTED"]
["eb A1 =",{"$f":"InputSheet!J25/SQRT(InputSheet!N25)","v":{"$error":"#DIV/0!"}},36.051257470072912,"These cells are updated by the macro code - do not protect this range or enter any data in them."]
["wb A2 =",{"$f":"InputSheet!K25/SQRT(InputSheet!N25)","v":{"$error":"#DIV/0!"}},7.6345398662823385]
["sb A3 =",{"$f":"InputSheet!L25/SQRT(InputSheet!N25)","v":{"$error":"#DIV/0!"}},7.1891677688674926]
["nb A4 =",{"$f":"InputSheet!M25/SQRT(InputSheet!N25)","v":{"$error":"#DIV/0!"}},26.468754012610333]
[]
["COMPUTE Bj",{"$f":"C108","v":0}]
["wb B1 =",{"$f":"IF(InputSheet!D$70*Calcs!C111+InputSheet!D$75*C112+InputSheet!D$77*C113=0,0,InputSheet!Q25/(InputSheet!D$70*Calcs!C111+InputSheet!D$75*C112+InputSheet!D$77*C113))","v":0}]
["eb B2 =",{"$f":"IF(InputSheet!D$66*Calcs!C110+InputSheet!D$73*C112+InputSheet!D$79*C113=0,0,InputSheet!R25/(InputSheet!D$66*Calcs!C110+InputSheet!D$73*C112+InputSheet!D$79*C113))","v":0}]
["nb B3 =",{"$f":"IF(InputSheet!D$65*Calcs!C110+InputSheet!D$71*C111+InputSheet!D$78*C113=0,0,InputSheet!S25/(InputSheet!D$65*Calcs!C110+InputSheet!D$71*C111+InputSheet!D$78*C113))","v":0}]
["sb B4 =",{"$f":"IF(InputSheet!D$67*Calcs!C110+InputSheet!D$69*C111+InputSheet!D$74*C112=0,0,InputSheet!T25/(InputSheet!D$67*Calcs!C110+InputSheet!D$69*C111+InputSheet!D$74*C112))","v":0}]
[]
["COMPUTE Anew",{"$f":"B115","v":0}]
["eb A1 =",{"$f":"IF(InputSheet!D$66*Calcs!B117+InputSheet!D$65*B118+InputSheet!D$67*B119=0,0,InputSheet!J25/(InputSheet!D$66*Calcs!B117+InputSheet!D$65*B118+InputSheet!D$67*B119))","v":0}]
["wb A2 =",{"$f":"IF(InputSheet!D$70*Calcs!B116+InputSheet!D$71*B118+InputSheet!D$69*B119=0,0,InputSheet!K25/(InputSheet!D$70*Calcs!B116+InputSheet!D$71*B118+InputSheet!D$69*B119))","v":0}]
["sb A3 =",{"$f":"IF(InputSheet!D$75*Calcs!B116+InputSheet!D$73*B117+InputSheet!D$74*B119=0,0,InputSheet!L25/(InputSheet!D$75*Calcs!B116+InputSheet!D$73*B117+InputSheet!D$74*B119))","v":0}]
["nb A4 =",{"$f":"IF(InputSheet!D$77*Calcs!B116+InputSheet!D$79*B117+InputSheet!D$78*B118=0,0,InputSheet!M25/(InputSheet!D$77*Calcs!B116+InputSheet!D$79*B117+InputSheet!D$78*B118))","v":0}]
[]
["COMPUTE DIFFERENCE Acurrent - Anew"]
[null,"ADJ. CURRENT",null,"ABS(DIFF) >"]
[null," - ANEW =",null,"CLOSURE","FLAG"]
[null,"DIFF","ABS(DIFF)","(1=TRUE)","KEY"]
[null,{"$f":"C110-B122","v":36.051257470072912},{"$f":"ABS(B131)","v":36.051257470072912},{"$f":"IF(C131>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C111-B123","v":7.6345398662823385},{"$f":"ABS(B132)","v":7.6345398662823385},{"$f":"IF(C132>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C112-B124","v":7.1891677688674926},{"$f":"ABS(B133)","v":7.1891677688674926},{"$f":"IF(C133>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C113-B125","v":26.468754012610333},{"$f":"ABS(B134)","v":26.468754012610333},{"$f":"IF(C134>InputSheet!$D$81,1,0)","v":1}]
[null,"Max of Abs= ",{"$f":"MAX(C131:C134)","v":36.051257470072912},{"$f":"MAX(D131:D134)","v":1},{"$f":"IF(D135>0,1,0)","v":1}]
[]
["COMPUTE TURNING MOVEMENTS"]
[null,null,null,"Proportion"]
[null,null,{"$f":"C108","v":0},"of Total"]
["T12","West-to-East",{"$f":"InputSheet!D$66*Calcs!B122*Calcs!B117","v":0},{"$f":"IF(C143=0,0,C140/C143)","v":0}]
["T13","West-to-North",{"$f":"InputSheet!D$65*Calcs!B122*Calcs!B118","v":0},{"$f":"IF(C143=0,0,C141/C143)","v":0}]
["T14","West-to-South",{"$f":"InputSheet!D$67*Calcs!B122*Calcs!B119","v":0},{"$f":"IF(C143=0,0,C142/C143)","v":0}]
[null,null,{"$f":"SUM(C140:C142)","v":0},1]
[]
["T21","East-to-West",{"$f":"InputSheet!D$70*Calcs!B123*Calcs!B116","v":0},{"$f":"IF(C148=0,0,C145/C148)","v":0}]
["T23","East-to-North",{"$f":"InputSheet!D$71*Calcs!B123*Calcs!B118","v":0},{"$f":"IF(C148=0,0,C146/C148)","v":0}]
["T24","East-to-South",{"$f":"InputSheet!D$69*Calcs!B123*Calcs!B119","v":0},{"$f":"IF(C148=0,0,C147/C148)","v":0}]
[null,null,{"$f":"SUM(C145:C147)","v":0},1]
[]
["T31","North-to-West",{"$f":"InputSheet!D$75*Calcs!B124*Calcs!B116","v":0},{"$f":"IF(C153=0,0,C150/C153)","v":0}]
["T32","North-to-East",{"$f":"InputSheet!D$73*Calcs!B124*Calcs!B117","v":0},{"$f":"IF(C153=0,0,C151/C153)","v":0}]
["T34","North-to-South",{"$f":"InputSheet!D$74*Calcs!B124*Calcs!B119","v":0},{"$f":"IF(C153=0,0,C152/C153)","v":0}]
[null,null,{"$f":"SUM(C150:C152)","v":0},1]
[]
["T41","South-to-West",{"$f":"InputSheet!D$77*Calcs!B125*Calcs!B116","v":0},{"$f":"IF(C158=0,0,C155/C158)","v":0}]
["T42","South-to-East",{"$f":"InputSheet!D$79*Calcs!B125*Calcs!B117","v":0},{"$f":"IF(C158=0,0,C156/C158)","v":0}]
["T43","South-to-North",{"$f":"InputSheet!D$78*Calcs!B125*Calcs!B118","v":0},{"$f":"IF(C158=0,0,C157/C158)","v":0}]
[null,null,{"$f":"SUM(C155:C157)","v":0},1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MID-YEAR CALCULATIONS:",null,{"$f":"InputSheet!I9","v":0}]
[null,"ORIGINAL","ADJUSTED"]
["eb A1 =",{"$f":"InputSheet!J26/SQRT(InputSheet!N26)","v":{"$error":"#DIV/0!"}},38.757060003472112,"These cells are updated by the macro code - do not protect this range or enter any data in them."]
["wb A2 =",{"$f":"InputSheet!K26/SQRT(InputSheet!N26)","v":{"$error":"#DIV/0!"}},8.1947016606200691]
["sb A3 =",{"$f":"InputSheet!L26/SQRT(InputSheet!N26)","v":{"$error":"#DIV/0!"}},7.4002248186494812]
["nb A4 =",{"$f":"InputSheet!M26/SQRT(InputSheet!N26)","v":{"$error":"#DIV/0!"}},27.374555157594635]
[]
["COMPUTE Bj",{"$f":"C188","v":0}]
["wb B1 =",{"$f":"IF(InputSheet!D$70*Calcs!C191+InputSheet!D$75*C192+InputSheet!D$77*C193=0,0,InputSheet!Q26/(InputSheet!D$70*Calcs!C191+InputSheet!D$75*C192+InputSheet!D$77*C193))","v":0}]
["eb B2 =",{"$f":"IF(InputSheet!D$66*Calcs!C190+InputSheet!D$73*C192+InputSheet!D$79*C193=0,0,InputSheet!R26/(InputSheet!D$66*Calcs!C190+InputSheet!D$73*C192+InputSheet!D$79*C193))","v":0}]
["nb B3 =",{"$f":"IF(InputSheet!D$65*Calcs!C190+InputSheet!D$71*C191+InputSheet!D$78*C193=0,0,InputSheet!S26/(InputSheet!D$65*Calcs!C190+InputSheet!D$71*C191+InputSheet!D$78*C193))","v":0}]
["sb B4 =",{"$f":"IF(InputSheet!D$67*Calcs!C190+InputSheet!D$69*C191+InputSheet!D$74*C192=0,0,InputSheet!T26/(InputSheet!D$67*Calcs!C190+InputSheet!D$69*C191+InputSheet!D$74*C192))","v":0}]
[]
["COMPUTE Anew",{"$f":"B195","v":0}]
["eb A1 =",{"$f":"IF(InputSheet!D$66*Calcs!B197+InputSheet!D$65*B198+InputSheet!D$67*B199=0,0,InputSheet!J26/(InputSheet!D$66*Calcs!B197+InputSheet!D$65*B198+InputSheet!D$67*B199))","v":0}]
["wb A2 =",{"$f":"IF(InputSheet!D$70*Calcs!B196+InputSheet!D$71*B198+InputSheet!D$69*B199=0,0,InputSheet!K26/(InputSheet!D$70*Calcs!B196+InputSheet!D$71*B198+InputSheet!D$69*B199))","v":0}]
["sb A3 =",{"$f":"IF(InputSheet!D$75*Calcs!B196+InputSheet!D$73*B197+InputSheet!D$74*B199=0,0,InputSheet!L26/(InputSheet!D$75*Calcs!B196+InputSheet!D$73*B197+InputSheet!D$74*B199))","v":0}]
["nb A4 =",{"$f":"IF(InputSheet!D$77*Calcs!B196+InputSheet!D$79*B197+InputSheet!D$78*B198=0,0,InputSheet!M26/(InputSheet!D$77*Calcs!B196+InputSheet!D$79*B197+InputSheet!D$78*B198))","v":0}]
[]
["COMPUTE DIFFERENCE Acurrent - Anew"]
[null,"ADJ. CURRENT",null,"ABS(DIFF) >"]
[null," - ANEW =",null,"CLOSURE","FLAG"]
[null,"DIFF","ABS(DIFF)","(1=TRUE)","KEY"]
[null,{"$f":"C190-B202","v":38.757060003472112},{"$f":"ABS(B211)","v":38.757060003472112},{"$f":"IF(C211>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C191-B203","v":8.1947016606200691},{"$f":"ABS(B212)","v":8.1947016606200691},{"$f":"IF(C212>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C192-B204","v":7.4002248186494812},{"$f":"ABS(B213)","v":7.4002248186494812},{"$f":"IF(C213>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C193-B205","v":27.374555157594635},{"$f":"ABS(B214)","v":27.374555157594635},{"$f":"IF(C214>InputSheet!$D$81,1,0)","v":1}]
[null,"Max of Abs= ",{"$f":"MAX(C211:C214)","v":38.757060003472112},{"$f":"MAX(D211:D214)","v":1},{"$f":"IF(D215>0,1,0)","v":1}]
[]
["COMPUTE TURNING MOVEMENTS"]
[null,null,null,"Proportion"]
[null,null,{"$f":"C188","v":0},"of Total"]
["T12","West-to-East",{"$f":"InputSheet!D$66*Calcs!B202*Calcs!B197","v":0},{"$f":"IF(C223=0,0,C220/C223)","v":0}]
["T13","West-to-North",{"$f":"InputSheet!D$65*Calcs!B202*Calcs!B198","v":0},{"$f":"IF(C223=0,0,C221/C223)","v":0}]
["T14","West-to-South",{"$f":"InputSheet!D$67*Calcs!B202*Calcs!B199","v":0},{"$f":"IF(C223=0,0,C222/C223)","v":0}]
[null,null,{"$f":"SUM(C220:C222)","v":0},1]
[]
["T21","East-to-West",{"$f":"InputSheet!D$70*Calcs!B203*Calcs!B196","v":0},{"$f":"IF(C228=0,0,C225/C228)","v":0}]
["T23","East-to-North",{"$f":"InputSheet!D$71*Calcs!B203*Calcs!B198","v":0},{"$f":"IF(C228=0,0,C226/C228)","v":0}]
["T24","East-to-South",{"$f":"InputSheet!D$69*Calcs!B203*Calcs!B199","v":0},{"$f":"IF(C228=0,0,C227/C228)","v":0}]
[null,null,{"$f":"SUM(C225:C227)","v":0},1]
[]
["T31","North-to-West",{"$f":"InputSheet!D$75*Calcs!B204*Calcs!B196","v":0},{"$f":"IF(C233=0,0,C230/C233)","v":0}]
["T32","North-to-East",{"$f":"InputSheet!D$73*Calcs!B204*Calcs!B197","v":0},{"$f":"IF(C233=0,0,C231/C233)","v":0}]
["T34","North-to-South",{"$f":"InputSheet!D$74*Calcs!B204*Calcs!B199","v":0},{"$f":"IF(C233=0,0,C232/C233)","v":0}]
[null,null,{"$f":"SUM(C230:C232)","v":0},1]
[]
["T41","South-to-West",{"$f":"InputSheet!D$77*Calcs!B205*Calcs!B196","v":0},{"$f":"IF(C238=0,0,C235/C238)","v":0}]
["T42","South-to-East",{"$f":"InputSheet!D$79*Calcs!B205*Calcs!B197","v":0},{"$f":"IF(C238=0,0,C236/C238)","v":0}]
["T43","South-to-North",{"$f":"InputSheet!D$78*Calcs!B205*Calcs!B198","v":0},{"$f":"IF(C238=0,0,C237/C238)","v":0}]
[null,null,{"$f":"SUM(C235:C237)","v":0},1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DESIGN YEAR CALCULATIONS:",null,{"$f":"InputSheet!I10","v":0}]
[null,"ORIGINAL","ADJUSTED"]
["eb A1 =",{"$f":"InputSheet!J27/SQRT(InputSheet!N27)","v":{"$error":"#DIV/0!"}},41.289122672054603,"These cells are updated by the macro code - do not protect this range or enter any data in them."]
["wb A2 =",{"$f":"InputSheet!K27/SQRT(InputSheet!N27)","v":{"$error":"#DIV/0!"}},8.7315688491569983]
["sb A3 =",{"$f":"InputSheet!L27/SQRT(InputSheet!N27)","v":{"$error":"#DIV/0!"}},7.5997518671910758]
["nb A4 =",{"$f":"InputSheet!M27/SQRT(InputSheet!N27)","v":{"$error":"#DIV/0!"}},28.258628878477865]
[]
["COMPUTE Bj",{"$f":"C268","v":0}]
["wb B1 =",{"$f":"IF(InputSheet!D$70*Calcs!C271+InputSheet!D$75*C272+InputSheet!D$77*C273=0,0,InputSheet!Q27/(InputSheet!D$70*Calcs!C271+InputSheet!D$75*C272+InputSheet!D$77*C273))","v":0}]
["eb B2 =",{"$f":"IF(InputSheet!D$66*Calcs!C270+InputSheet!D$73*C272+InputSheet!D$79*C273=0,0,InputSheet!R27/(InputSheet!D$66*Calcs!C270+InputSheet!D$73*C272+InputSheet!D$79*C273))","v":0}]
["nb B3 =",{"$f":"IF(InputSheet!D$65*Calcs!C270+InputSheet!D$71*C271+InputSheet!D$78*C273=0,0,InputSheet!S27/(InputSheet!D$65*Calcs!C270+InputSheet!D$71*C271+InputSheet!D$78*C273))","v":0}]
["sb B4 =",{"$f":"IF(InputSheet!D$67*Calcs!C270+InputSheet!D$69*C271+InputSheet!D$74*C272=0,0,InputSheet!T27/(InputSheet!D$67*Calcs!C270+InputSheet!D$69*C271+InputSheet!D$74*C272))","v":0}]
[]
["COMPUTE Anew",{"$f":"B275","v":0}]
["eb A1 =",{"$f":"IF(InputSheet!D$66*Calcs!B277+InputSheet!D$65*B278+InputSheet!D$67*B279=0,0,InputSheet!J27/(InputSheet!D$66*Calcs!B277+InputSheet!D$65*B278+InputSheet!D$67*B279))","v":0}]
["wb A2 =",{"$f":"IF(InputSheet!D$70*Calcs!B276+InputSheet!D$71*B278+InputSheet!D$69*B279=0,0,InputSheet!K27/(InputSheet!D$70*Calcs!B276+InputSheet!D$71*B278+InputSheet!D$69*B279))","v":0}]
["sb A3 =",{"$f":"IF(InputSheet!D$75*Calcs!B276+InputSheet!D$73*B277+InputSheet!D$74*B279=0,0,InputSheet!L27/(InputSheet!D$75*Calcs!B276+InputSheet!D$73*B277+InputSheet!D$74*B279))","v":0}]
["nb A4 =",{"$f":"IF(InputSheet!D$77*Calcs!B276+InputSheet!D$79*B277+InputSheet!D$78*B278=0,0,InputSheet!M27/(InputSheet!D$77*Calcs!B276+InputSheet!D$79*B277+InputSheet!D$78*B278))","v":0}]
[]
["COMPUTE DIFFERENCE Acurrent - Anew"]
[null,"ADJ. CURRENT",null,"ABS(DIFF) >"]
[null," - ANEW =",null,"CLOSURE","FLAG"]
[null,"DIFF","ABS(DIFF)","(1=TRUE)","KEY"]
[null,{"$f":"C270-B282","v":41.289122672054603},{"$f":"ABS(B291)","v":41.289122672054603},{"$f":"IF(C291>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C271-B283","v":8.7315688491569983},{"$f":"ABS(B292)","v":8.7315688491569983},{"$f":"IF(C292>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C272-B284","v":7.5997518671910758},{"$f":"ABS(B293)","v":7.5997518671910758},{"$f":"IF(C293>InputSheet!$D$81,1,0)","v":1}]
[null,{"$f":"C273-B285","v":28.258628878477865},{"$f":"ABS(B294)","v":28.258628878477865},{"$f":"IF(C294>InputSheet!$D$81,1,0)","v":1}]
[null,"Max of Abs= ",{"$f":"MAX(C291:C294)","v":41.289122672054603},{"$f":"MAX(D291:D294)","v":1},{"$f":"IF(D295>0,1,0)","v":1}]
[]
["COMPUTE TURNING MOVEMENTS"]
[null,null,null,"Proportion"]
[null,null,{"$f":"C268","v":0},"of Total"]
["T12","West-to-East",{"$f":"InputSheet!D$66*Calcs!B282*Calcs!B277","v":0},{"$f":"IF(C303=0,0,C300/C303)","v":0}]
["T13","West-to-North",{"$f":"InputSheet!D$65*Calcs!B282*Calcs!B278","v":0},{"$f":"IF(C303=0,0,C301/C303)","v":0}]
["T14","West-to-South",{"$f":"InputSheet!D$67*Calcs!B282*Calcs!B279","v":0},{"$f":"IF(C303=0,0,C302/C303)","v":0}]
[null,null,{"$f":"SUM(C300:C302)","v":0},1]
[]
["T21","East-to-West",{"$f":"InputSheet!D$70*Calcs!B283*Calcs!B276","v":0},{"$f":"IF(C308=0,0,C305/C308)","v":0}]
["T23","East-to-North",{"$f":"InputSheet!D$71*Calcs!B283*Calcs!B278","v":0},{"$f":"IF(C308=0,0,C306/C308)","v":0}]
["T24","East-to-South",{"$f":"InputSheet!D$69*Calcs!B283*Calcs!B279","v":0},{"$f":"IF(C308=0,0,C307/C308)","v":0}]
[null,null,{"$f":"SUM(C305:C307)","v":0},1]
[]
["T31","North-to-West",{"$f":"InputSheet!D$75*Calcs!B284*Calcs!B276","v":0},{"$f":"IF(C313=0,0,C310/C313)","v":0}]
["T32","North-to-East",{"$f":"InputSheet!D$73*Calcs!B284*Calcs!B277","v":0},{"$f":"IF(C313=0,0,C311/C313)","v":0}]
["T34","North-to-South",{"$f":"InputSheet!D$74*Calcs!B284*Calcs!B279","v":0},{"$f":"IF(C313=0,0,C312/C313)","v":0}]
[null,null,{"$f":"SUM(C310:C312)","v":0},1]
[]
["T41","South-to-West",{"$f":"InputSheet!D$77*Calcs!B285*Calcs!B276","v":0},{"$f":"IF(C318=0,0,C315/C318)","v":0}]
["T42","South-to-East",{"$f":"InputSheet!D$79*Calcs!B285*Calcs!B277","v":0},{"$f":"IF(C318=0,0,C316/C318)","v":0}]
["T43","South-to-North",{"$f":"InputSheet!D$78*Calcs!B285*Calcs!B278","v":0},{"$f":"IF(C318=0,0,C317/C318)","v":0}]
[null,null,{"$f":"SUM(C315:C317)","v":0},1]

{"sheet":"OutputSheet","index":3,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,9],[9,2,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[5,3,6,5]]}
["TURNS5 INITIAL TURNING  VOLUME  SUMMARY "]
[]
[]
[null,"Highway:",null,{"$f":"InputSheet!C6","v":0},null,null,"County:",{"$f":"InputSheet!C10","v":0}]
[null,"Intersection:",null,{"$f":"InputSheet!C7","v":0}]
[null,"Project:",null,{"$f":"InputSheet!C8","v":0},null,null,"Analyst:",{"$f":"InputSheet!C4","v":0}]
[null,null,null,null,null,null,"Date:",{"$f":"InputSheet!C5","v":"2019-05-16T10:22:52.340"}]
[]
[]
[null,{"$f":"InputSheet!I7","v":0},{"$f":"B10","v":0},null,{"$f":"InputSheet!I8","v":0},null,{"$f":"InputSheet!I9","v":0},null,{"$f":"InputSheet!I10","v":0}]
["Approach-To-","Initial ","Final ","Calculated ","Final ","Calculated ","Final ","Calculated ","Final ","Calculated "]
["Approach","Estimate ","Estimate ","Volume ","Estimate ","Volume ","Estimate ","Volume ","Estimate ","Volume "]
[]
["West-To-North (LT)",{"$f":"InputSheet!D65","v":0},{"$f":"TurnSheets!C13","v":0},{"$f":"TurnSheets!D13","v":0},{"$f":"TurnSheets!P13","v":0},{"$f":"TurnSheets!Q13","v":0},{"$f":"TurnSheets!C33","v":0},{"$f":"TurnSheets!D33","v":0},{"$f":"TurnSheets!P33","v":0},{"$f":"TurnSheets!Q33","v":0}]
["West-To-East (Thru)",{"$f":"InputSheet!D66","v":0},{"$f":"TurnSheets!C14","v":0},{"$f":"TurnSheets!D14","v":0},{"$f":"TurnSheets!P14","v":0},{"$f":"TurnSheets!Q14","v":0},{"$f":"TurnSheets!C34","v":0},{"$f":"TurnSheets!D34","v":0},{"$f":"TurnSheets!P34","v":0},{"$f":"TurnSheets!Q34","v":0}]
["West-To-South (RT)",{"$f":"InputSheet!D67","v":0},{"$f":"TurnSheets!C15","v":0},{"$f":"TurnSheets!D15","v":0},{"$f":"TurnSheets!P15","v":0},{"$f":"TurnSheets!Q15","v":0},{"$f":"TurnSheets!C35","v":0},{"$f":"TurnSheets!D35","v":0},{"$f":"TurnSheets!P35","v":0},{"$f":"TurnSheets!Q35","v":0}]
[null," "]
["     Total Flow From West:",null,null,{"$f":"SUM(D14:D16)","v":0},null,{"$f":"SUM(F14:F16)","v":0},null,{"$f":"SUM(H14:H16)","v":0},null,{"$f":"SUM(J14:J16)","v":0}]
[null," "]
["East-To-South (LT)",{"$f":"InputSheet!D69","v":0},{"$f":"TurnSheets!K12","v":0},{"$f":"TurnSheets!J12","v":0},{"$f":"TurnSheets!X12","v":0},{"$f":"TurnSheets!W12","v":0},{"$f":"TurnSheets!K32","v":0},{"$f":"TurnSheets!J32","v":0},{"$f":"TurnSheets!X32","v":0},{"$f":"TurnSheets!W32","v":0}]
["East-To-West (Thru)",{"$f":"InputSheet!D70","v":0},{"$f":"TurnSheets!K11","v":0},{"$f":"TurnSheets!J11","v":0},{"$f":"TurnSheets!X11","v":0},{"$f":"TurnSheets!W11","v":0},{"$f":"TurnSheets!K31","v":0},{"$f":"TurnSheets!J31","v":0},{"$f":"TurnSheets!X31","v":0},{"$f":"TurnSheets!W31","v":0}]
["East-To-North (RT)",{"$f":"InputSheet!D71","v":0},{"$f":"TurnSheets!K10","v":0},{"$f":"TurnSheets!J10","v":0},{"$f":"TurnSheets!X10","v":0},{"$f":"TurnSheets!W10","v":0},{"$f":"TurnSheets!K30","v":0},{"$f":"TurnSheets!J30","v":0},{"$f":"TurnSheets!X30","v":0},{"$f":"TurnSheets!W30","v":0}]
[null," "]
["     Total Flow From East:",null,null,{"$f":"SUM(D20:D22)","v":0},null,{"$f":"SUM(F20:F22)","v":0},null,{"$f":"SUM(H20:H22)","v":0},null,{"$f":"SUM(J20:J22)","v":0}]
[]
["North-To-East (LT)",{"$f":"InputSheet!D73","v":0},{"$f":"TurnSheets!G7","v":0},{"$f":"TurnSheets!G8","v":0},{"$f":"TurnSheets!T7","v":0},{"$f":"TurnSheets!T8","v":0},{"$f":"TurnSheets!G27","v":0},{"$f":"TurnSheets!G28","v":0},{"$f":"TurnSheets!T27","v":0},{"$f":"TurnSheets!T28","v":0}]
["North-To-South (Thru)",{"$f":"InputSheet!D74","v":0},{"$f":"TurnSheets!F7","v":0},{"$f":"TurnSheets!F8","v":0},{"$f":"TurnSheets!S7","v":0},{"$f":"TurnSheets!S8","v":0},{"$f":"TurnSheets!F27","v":0},{"$f":"TurnSheets!F28","v":0},{"$f":"TurnSheets!S27","v":0},{"$f":"TurnSheets!S28","v":0}]
["North-To-West (RT)",{"$f":"InputSheet!D75","v":0},{"$f":"TurnSheets!E7","v":0},{"$f":"TurnSheets!E8","v":0},{"$f":"TurnSheets!R7","v":0},{"$f":"TurnSheets!R8","v":0},{"$f":"TurnSheets!E27","v":0},{"$f":"TurnSheets!E28","v":0},{"$f":"TurnSheets!R27","v":0},{"$f":"TurnSheets!R28","v":0}]
[null," "]
["     Total Flow From North:",null,null,{"$f":"SUM(D26:D28)","v":0},null,{"$f":"SUM(F26:F28)","v":0},null,{"$f":"SUM(H26:H28)","v":0},null,{"$f":"SUM(J26:J28)","v":0}]
[null," "]
["South-To-West (LT)",{"$f":"InputSheet!D77","v":0},{"$f":"TurnSheets!G19","v":0},{"$f":"TurnSheets!G18","v":0},{"$f":"TurnSheets!T19","v":0},{"$f":"TurnSheets!T18","v":0},{"$f":"TurnSheets!G39","v":0},{"$f":"TurnSheets!G38","v":0},{"$f":"TurnSheets!T39","v":0},{"$f":"TurnSheets!T38","v":0}]
["South-To-North (Thru)",{"$f":"InputSheet!D78","v":0},{"$f":"TurnSheets!H19","v":0},{"$f":"TurnSheets!H18","v":0},{"$f":"TurnSheets!U19","v":0},{"$f":"TurnSheets!U18","v":0},{"$f":"TurnSheets!H39","v":0},{"$f":"TurnSheets!H38","v":0},{"$f":"TurnSheets!U39","v":0},{"$f":"TurnSheets!U38","v":0}]
["South-To-East (RT)",{"$f":"InputSheet!D79","v":0},{"$f":"TurnSheets!I19","v":0},{"$f":"TurnSheets!I18","v":0},{"$f":"TurnSheets!V19","v":0},{"$f":"TurnSheets!V18","v":0},{"$f":"TurnSheets!I39","v":0},{"$f":"TurnSheets!I38","v":0},{"$f":"TurnSheets!V39","v":0},{"$f":"TurnSheets!V38","v":0}]
[null," "]
["     Total Flow From South:",null,null,{"$f":"SUM(D32:D34)","v":0},null,{"$f":"SUM(F32:F34)","v":0},null,{"$f":"SUM(H32:H34)","v":0},null,{"$f":"SUM(J32:J34)","v":0}]

{"sheet":"TurnSheets","index":4,"n_rows":85,"n_cols":26,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,18,83,22],[3,3,3,7],[3,16,3,20],[23,3,23,7],[23,16,23,20],[47,3,47,7],[47,16,47,20],[67,3,67,7],[67,16,67,20],[83,14,83,16],[64,1,64,3],[64,14,64,16],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[56,6,56,7],[56,19,56,20],[63,18,63,22],[65,1,65,11],[65,14,65,24],[70,9,71,11],[70,22,71,24],[45,1,45,11],[84,1,84,3],[84,14,84,16],[59,1,60,3],[59,14,60,16],[79,1,80,3],[79,14,80,16],[63,5,63,9],[83,5,83,9],[7,22,8,24],[17,24,17,25],[13,6,13,7],[10,3,10,4],[62,1,62,3],[62,14,62,16],[82,1,82,3],[82,14,82,16],[63,1,63,3],[63,14,63,16],[37,11,37,12],[38,11,38,12],[76,6,76,7],[76,19,76,20],[83,1,83,3],[17,11,17,12],[0,1,0,24],[20,18,20,19],[30,3,30,4],[40,5,40,6],[36,1,37,3],[30,16,30,17],[7,9,8,11],[16,1,17,3],[21,5,21,9],[18,1,18,2],[27,22,28,24],[27,9,28,11],[16,14,17,16],[24,19,24,20],[24,6,24,7],[19,18,19,19],[4,6,4,7],[4,19,4,20],[10,16,10,17],[22,14,22,24],[13,19,13,20],[2,1,2,11],[2,14,2,24],[22,1,22,11],[50,22,51,24],[53,3,53,4],[53,16,53,17],[43,1,43,24],[21,1,21,2],[21,18,21,22],[18,24,18,25],[19,24,19,25],[20,24,20,25],[21,24,21,25],[19,14,19,15],[20,14,20,15],[21,14,21,15],[18,14,18,15],[19,1,19,2],[38,1,38,2],[41,1,41,2],[20,1,20,2],[39,1,39,2],[40,1,40,2],[73,3,73,4],[73,16,73,17],[40,18,40,19],[33,6,33,7],[33,19,33,20],[36,14,37,16],[40,14,40,15],[37,24,37,25],[38,24,38,25],[39,24,39,25],[40,24,40,25],[41,24,41,25],[38,14,38,15],[39,14,39,15],[41,14,41,15],[41,5,41,9],[41,18,41,22],[39,11,39,12],[40,11,40,12],[41,11,41,12],[39,5,39,6],[39,18,39,19],[45,14,45,24],[50,9,51,11]]}
[null,{"$f":"\"PROJECT TRAFFIC FOR \"&InputSheet!$C$6&\" AT \"&InputSheet!$C$7&\"\"","v":"PROJECT TRAFFIC FOR  AT "}]
[]
[null,{"$f":"\"DESIGN HOUR TURNING MOVEMENTS IN YEAR \" &InputSheet!I7","v":"DESIGN HOUR TURNING MOVEMENTS IN YEAR 0"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"DESIGN HOUR TURNING MOVEMENTS IN YEAR \" &InputSheet!I8","v":"DESIGN HOUR TURNING MOVEMENTS IN YEAR 0"}]
[null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
[null,null,null,null,null,{"$f":"IF(InputSheet!$AB7<1000,MROUND(-InputSheet!$AB7,-10),IF(InputSheet!$AB7>=10000,MROUND(-InputSheet!$AB7,-1000),MROUND(-InputSheet!$AB7,-100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(InputSheet!$AB8<1000,MROUND(-InputSheet!$AB8,-10),IF(InputSheet!$AB8>=10000,MROUND(-InputSheet!$AB8,-1000),MROUND(-InputSheet!$AB8,-100)))","v":0}]
[null,null,null,null,null,{"$f":"InputSheet!$L7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InputSheet!$L8","v":0}]
[null,null,null,null,{"$f":"IF(Data!$B$5=0,1-G7,ROUND(Calcs!D70,3))","v":0},{"$f":"IF(F6=0,0,IF(Data!$B$5=0,0,1-E7-G7))","v":0},{"$f":"ROUND(Calcs!D71,3)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$5=0,1-T7,ROUND(Calcs!D150,3))","v":0},{"$f":"IF(S6=0,0,IF(Data!$B$5=0,0,1-R7-T7))","v":0},{"$f":"ROUND(Calcs!D151,3)","v":0}]
[null,null,null,null,{"$f":"IF(Data!$B$5=0,F6-G8,ROUND(E7*$F$6,0))","v":0},{"$f":"IF(Data!$B$5=0,0,F6-E8-G8)","v":0},{"$f":"ROUND(G7*$F$6,0)","v":0},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Data!$B$5=0,S6-T8,ROUND(R7*$S$6,0))","v":0},{"$f":"IF(Data!$B$5=0,0,S6-R8-T8)","v":0},{"$f":"ROUND(T7*$S$6,0)","v":0},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,L11-J12,ROUND(K10*$L$11,0))","v":0},{"$f":"IF(Data!$D$5=0,1-K12,ROUND(Calcs!D66,3))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,Y11-W12,ROUND(X10*$Y$11,0))","v":0},{"$f":"IF(Data!$D$5=0,1-X12,ROUND(Calcs!D146,3))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,0,L11-J10-J12)","v":0},{"$f":"IF(L11=0,0,IF(Data!$D$5=0,0,1-K10-K12))","v":0},{"$f":"InputSheet!$K7","v":0},{"$f":"IF(InputSheet!$AA7<1000,MROUND(-InputSheet!$AA7,-10),IF(InputSheet!$AA7>=10000,MROUND(-InputSheet!$AA7,-1000),MROUND(-InputSheet!$AA7,-100)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,0,Y11-W10-W12)","v":0},{"$f":"IF(Y11=0,0,IF(Data!$D$5=0,0,1-X10-X12))","v":0},{"$f":"InputSheet!$K8","v":0},{"$f":"IF(InputSheet!$AA8<1000,MROUND(-InputSheet!$AA8,-10),IF(InputSheet!$AA8>=10000,MROUND(-InputSheet!$AA8,-1000),MROUND(-InputSheet!$AA8,-100)))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K12*$L$11,0)","v":0},{"$f":"ROUND(Calcs!D67,3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X12*$Y$11,0)","v":0},{"$f":"ROUND(Calcs!D147,3)","v":0}]
[null,null,{"$f":"ROUND(Calcs!D61,3)","v":0},{"$f":"ROUND(C13*$B$14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Calcs!D141,3)","v":0},{"$f":"ROUND(P13*$O$14,0)","v":0}]
[{"$f":"IF(InputSheet!$Z7<1000,MROUND(-InputSheet!$Z7,-10),IF(InputSheet!$Z7>=10000,MROUND(-InputSheet!$Z7,-1000),MROUND(-InputSheet!$Z7,-100)))","v":0},{"$f":"InputSheet!$J7","v":0},{"$f":"IF(B14=0,0,IF(Data!$E$5=0,0,1-C13-C15))","v":0},{"$f":"IF(Data!$E$5=0,0,B14-D13-D15)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(InputSheet!$Z8<1000,MROUND(-InputSheet!$Z8,-10),IF(InputSheet!$Z8>=10000,MROUND(-InputSheet!$Z8,-1000),MROUND(-InputSheet!$Z8,-100)))","v":0},{"$f":"InputSheet!$J8","v":0},{"$f":"IF(O14=0,0,IF(Data!$E$5=0,0,1-P13-P15))","v":0},{"$f":"IF(Data!$E$5=0,0,O14-Q13-Q15)","v":0}]
[null,null,{"$f":"IF(Data!$E$5=0,1-C13,ROUND(Calcs!D62,3))","v":0},{"$f":"IF(Data!$E$5=0,B14-D13,ROUND(C15*$B$14,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$E$5=0,1-P13,ROUND(Calcs!D142,3))","v":0},{"$f":"IF(Data!$E$5=0,O14-Q13,ROUND(P15*$O$14,0))","v":0}]
[]
[null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(G19*$H$20,0)","v":0},{"$f":"IF(Data!$C$5=0,0,H20-G18-I18)","v":0},{"$f":"IF(Data!$C$5=0,H20-G18,ROUND(I19*$H$20,0))","v":0},null,null,"D Factors",null,null,null,null,null,null,null,{"$f":"ROUND(T19*$U$20,0)","v":0},{"$f":"IF(Data!$C$5=0,0,U20-T18-V18)","v":0},{"$f":"IF(Data!$C$5=0,U20-T18,ROUND(V19*$U$20,0))","v":0},null,null,"D Factors"]
["(XXXXX)",{"$f":"InputSheet!$I$7&\" AADT\"","v":"0 AADT"},null,null,null,null,{"$f":"ROUND(Calcs!D75,3)","v":0},{"$f":"IF(H20=0,0,IF(Data!$C$5=0,0,1-G19-I19))","v":0},{"$f":"IF(Data!$C$5=0,1-G19,ROUND(Calcs!D76,3))","v":0},null,null,{"$f":"IF(InputSheet!$F$16=0,\" \",TEXT(InputSheet!$F$16,\"#.0%\")&\" \"&MID(InputSheet!$E$16,LEN(InputSheet!$E$16)-2,2))","v":"50.0% WB"},null,"(XXXXX)",{"$f":"InputSheet!$I$8&\" AADT\"","v":"0 AADT"},null,null,null,null,{"$f":"ROUND(Calcs!D155,3)","v":0},{"$f":"IF(U20=0,0,IF(Data!$C$5=0,0,1-T19-V19))","v":0},{"$f":"IF(Data!$C$5=0,1-T19,ROUND(Calcs!D156,3))","v":0},null,null,{"$f":"IF(InputSheet!$F$16=0,\" \",TEXT(InputSheet!$F$16,\"#.0%\")&\" \"&MID(InputSheet!$E$16,LEN(InputSheet!$E$16)-2,2))","v":"50.0% WB"}]
["XXXX",{"$f":"InputSheet!$I$7&\" DDHV\"","v":"0 DDHV"},null,null,null,null,null,{"$f":"InputSheet!$M7","v":0},null,null,null,{"$f":"IF(InputSheet!$F$17=0,\" \",TEXT(InputSheet!$F$17,\"#.0%\")&\" \"&MID(InputSheet!$E$17,LEN(InputSheet!$E$17)-2,2))","v":"50.0% EB"},null,"XXXX",{"$f":"InputSheet!$I$8&\" DDHV\"","v":"0 DDHV"},null,null,null,null,null,{"$f":"InputSheet!$M8","v":0},null,null,null,{"$f":"IF(InputSheet!$F$17=0,\" \",TEXT(InputSheet!$F$17,\"#.0%\")&\" \"&MID(InputSheet!$E$17,LEN(InputSheet!$E$17)-2,2))","v":"50.0% EB"}]
["K ML =",{"$f":"InputSheet!$C$16","v":7.0000000000000007E-2},null,null,null,null,null,{"$f":"IF(InputSheet!$AC7<1000,MROUND(-InputSheet!$AC7,-10),IF(InputSheet!$AC7>=10000,MROUND(-InputSheet!$AC7,-1000),MROUND(-InputSheet!$AC7,-100)))","v":0},null,null,null,{"$f":"IF(InputSheet!$F$19=0,\" \",TEXT(InputSheet!$F$19,\"#.0%\")&\" \"&MID(InputSheet!$E$19,LEN(InputSheet!$E$19)-2,2))","v":"50.0% NB"},null,"K ML =",{"$f":"InputSheet!$C$16","v":7.0000000000000007E-2},null,null,null,null,null,{"$f":"IF(InputSheet!$AC8<1000,MROUND(-InputSheet!$AC8,-10),IF(InputSheet!$AC8>=10000,MROUND(-InputSheet!$AC8,-1000),MROUND(-InputSheet!$AC8,-100)))","v":0},null,null,null,{"$f":"IF(InputSheet!$F$19=0,\" \",TEXT(InputSheet!$F$19,\"#.0%\")&\" \"&MID(InputSheet!$E$19,LEN(InputSheet!$E$19)-2,2))","v":"50.0% NB"}]
["K SS =",{"$f":"InputSheet!$C$18","v":7.0000000000000007E-2},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,{"$f":"IF(InputSheet!$F$20=0,\" \",TEXT(InputSheet!$F$20,\"#.0%\")&\" \"&MID(InputSheet!$E$20,LEN(InputSheet!$E$20)-2,2))","v":"50.0% SB"},null,"K SS =",{"$f":"InputSheet!$C$18","v":7.0000000000000007E-2},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,{"$f":"IF(InputSheet!$F$20=0,\" \",TEXT(InputSheet!$F$20,\"#.0%\")&\" \"&MID(InputSheet!$E$20,LEN(InputSheet!$E$20)-2,2))","v":"50.0% SB"}]
[null,{"$f":"\"DESIGN HOUR TURNING MOVEMENTS IN YEAR \" &InputSheet!I9","v":"DESIGN HOUR TURNING MOVEMENTS IN YEAR 0"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"DESIGN HOUR TURNING MOVEMENTS IN YEAR \" &InputSheet!I10","v":"DESIGN HOUR TURNING MOVEMENTS IN YEAR 0"}]
[null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
[null,null,null,null,null,{"$f":"IF(InputSheet!$AB9<1000,MROUND(-InputSheet!$AB9,-10),IF(InputSheet!$AB9>=10000,MROUND(-InputSheet!$AB9,-1000),MROUND(-InputSheet!$AB9,-100)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(InputSheet!$AB10<1000,MROUND(-InputSheet!$AB10,-10),IF(InputSheet!$AB10>=10000,MROUND(-InputSheet!$AB10,-1000),MROUND(-InputSheet!$AB10,-100)))","v":0}]
[null,null,null,null,null,{"$f":"InputSheet!$L9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InputSheet!$L10","v":0}]
[null,null,null,null,{"$f":"IF(Data!$B$5=0,1-G27,ROUND(Calcs!D230,3))","v":0},{"$f":"IF(F26=0,0,IF(Data!$B$5=0,0,1-E27-G27))","v":0},{"$f":"ROUND(Calcs!D231,3)","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$5=0,1-T27,ROUND(Calcs!D310,3))","v":0},{"$f":"IF(S26=0,0,IF(Data!$B$5=0,0,1-R27-T27))","v":0},{"$f":"ROUND(Calcs!D311,3)","v":0}]
[null,null,null,null,{"$f":"IF(Data!$B$5=0,F26-G28,ROUND(E27*$F$26,0))","v":0},{"$f":"IF(Data!$B$5=0,0,F26-E28-G28)","v":0},{"$f":"ROUND(G27*$F$26,0)","v":0},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,{"$f":"IF(Data!$B$5=0,S26-T28,ROUND(R27*$S$26,0))","v":0},{"$f":"IF(Data!$B$5=0,0,S26-R28-T28)","v":0},{"$f":"ROUND(T27*$S$26,0)","v":0},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,L31-J32,ROUND(K30*$L$31,0))","v":0},{"$f":"IF(Data!$D$5=0,1-K32,ROUND(Calcs!D226,3))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,Y31-W32,ROUND(X30*$Y$31,0))","v":0},{"$f":"IF(Data!$D$5=0,1-X32,ROUND(Calcs!D306,3))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,0,L31-J30-J32)","v":0},{"$f":"IF(L31=0,0,IF(Data!$D$5=0,0,1-K30-K32))","v":0},{"$f":"InputSheet!$K9","v":0},{"$f":"IF(InputSheet!$AA9<1000,MROUND(-InputSheet!$AA9,-10),IF(InputSheet!$AA9>=10000,MROUND(-InputSheet!$AA9,-1000),MROUND(-InputSheet!$AA9,-100)))","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$D$5=0,0,Y31-W30-W32)","v":0},{"$f":"IF(Y31=0,0,IF(Data!$D$5=0,0,1-X30-X32))","v":0},{"$f":"InputSheet!$K10","v":0},{"$f":"IF(InputSheet!$AA10<1000,MROUND(-InputSheet!$AA10,-10),IF(InputSheet!$AA10>=10000,MROUND(-InputSheet!$AA10,-1000),MROUND(-InputSheet!$AA10,-100)))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(K32*$L$31,0)","v":0},{"$f":"ROUND(Calcs!D227,3)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X32*$Y$31,0)","v":0},{"$f":"ROUND(Calcs!D307,3)","v":0}]
[null,null,{"$f":"ROUND(Calcs!D221,3)","v":0},{"$f":"ROUND(C33*$B$34,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Calcs!D301,3)","v":0},{"$f":"ROUND($O$34*P33,0)","v":0}]
[{"$f":"IF(InputSheet!$Z9<1000,MROUND(-InputSheet!$Z9,-10),IF(InputSheet!$Z9>=10000,MROUND(-InputSheet!$Z9,-1000),MROUND(-InputSheet!$Z9,-100)))","v":0},{"$f":"InputSheet!$J9","v":0},{"$f":"IF(B34=0,0,IF(Data!$E$5=0,0,1-C33-C35))","v":0},{"$f":"IF(Data!$E$5=0,0,B34-D33-D35)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(InputSheet!$Z10<1000,MROUND(-InputSheet!$Z10,-10),IF(InputSheet!$Z10>=10000,MROUND(-InputSheet!$Z10,-1000),MROUND(-InputSheet!$Z10,-100)))","v":0},{"$f":"InputSheet!$J10","v":0},{"$f":"IF(O34=0,0,IF(Data!$E$5=0,0,1-P33-P35))","v":0},{"$f":"IF(Data!$E$5=0,0,O34-Q33-Q35)","v":0}]
[null,null,{"$f":"IF(Data!$E$5=0,1-C33,ROUND(Calcs!D222,3))","v":0},{"$f":"IF(Data!$E$5=0,B34-D33,ROUND(C35*$B$34,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$E$5=0,1-P33,ROUND(Calcs!D302,3))","v":0},{"$f":"IF(Data!$E$5=0,O34-Q33,ROUND($O$34*P35,0))","v":0}]
[]
[null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[null,null,null,null,null,null,{"$f":"ROUND(G39*$H$40,0)","v":0},{"$f":"IF(Data!$C$5=0,0,H40-G38-I38)","v":0},{"$f":"IF(Data!$C$5=0,H40-G38,ROUND(I39*$H$40,0))","v":0},null,null,"D Factors",null,null,null,null,null,null,null,{"$f":"ROUND(T39*$U$40,0)","v":0},{"$f":"IF(Data!$C$5=0,0,U40-T38-V38)","v":0},{"$f":"IF(Data!$C$5=0,U40-T38,ROUND(V39*$U$40,0))","v":0},null,null,"D Factors"]
["(XXXXX)",{"$f":"InputSheet!$I$9&\" AADT\"","v":"0 AADT"},null,null,null,null,{"$f":"ROUND(Calcs!D235,3)","v":0},{"$f":"IF(H40=0,0,IF(Data!$C$5=0,0,1-G39-I39))","v":0},{"$f":"IF(Data!$C$5=0,1-G39,ROUND(Calcs!D236,3))","v":0},null,null,{"$f":"IF(InputSheet!$F$16=0,\" \",TEXT(InputSheet!$F$16,\"#.0%\")&\" \"&MID(InputSheet!$E$16,LEN(InputSheet!$E$16)-2,2))","v":"50.0% WB"},null,"(XXXXX)",{"$f":"InputSheet!$I$10&\" AADT\"","v":"0 AADT"},null,null,null,null,{"$f":"ROUND(Calcs!D315,3)","v":0},{"$f":"IF(U40=0,0,IF(Data!$C$5=0,0,1-T39-V39))","v":0},{"$f":"IF(Data!$C$5=0,1-T39,ROUND(Calcs!D316,3))","v":0},null,null,{"$f":"IF(InputSheet!$F$16=0,\" \",TEXT(InputSheet!$F$16,\"#.0%\")&\" \"&MID(InputSheet!$E$16,LEN(InputSheet!$E$16)-2,2))","v":"50.0% WB"}]
["XXXX",{"$f":"InputSheet!$I$9&\" DDHV\"","v":"0 DDHV"},null,null,null,null,null,{"$f":"InputSheet!$M9","v":0},null,null,null,{"$f":"IF(InputSheet!$F$17=0,\" \",TEXT(InputSheet!$F$17,\"#.0%\")&\" \"&MID(InputSheet!$E$17,LEN(InputSheet!$E$17)-2,2))","v":"50.0% EB"},null,"XXXX",{"$f":"InputSheet!$I$10&\" DDHV\"","v":"0 DDHV"},null,null,null,null,null,{"$f":"InputSheet!$M10","v":0},null,null,null,{"$f":"IF(InputSheet!$F$17=0,\" \",TEXT(InputSheet!$F$17,\"#.0%\")&\" \"&MID(InputSheet!$E$17,LEN(InputSheet!$E$17)-2,2))","v":"50.0% EB"}]
["K ML =",{"$f":"InputSheet!$C$16","v":7.0000000000000007E-2},null,null,null,null,null,{"$f":"IF(InputSheet!$AC9<1000,MROUND(-InputSheet!$AC9,-10),IF(InputSheet!$AC9>=10000,MROUND(-InputSheet!$AC9,-1000),MROUND(-InputSheet!$AC9,-100)))","v":0},null,null,null,{"$f":"IF(InputSheet!$F$19=0,\" \",TEXT(InputSheet!$F$19,\"#.0%\")&\" \"&MID(InputSheet!$E$19,LEN(InputSheet!$E$19)-2,2))","v":"50.0% NB"},null,"K ML =",{"$f":"InputSheet!$C$16","v":7.0000000000000007E-2},null,null,null,null,null,{"$f":"IF(InputSheet!$AC10<1000,MROUND(-InputSheet!$AC10,-10),IF(InputSheet!$AC10>=10000,MROUND(-InputSheet!$AC10,-1000),MROUND(-InputSheet!$AC10,-100)))","v":0},null,null,null,{"$f":"IF(InputSheet!$F$19=0,\" \",TEXT(InputSheet!$F$19,\"#.0%\")&\" \"&MID(InputSheet!$E$19,LEN(InputSheet!$E$19)-2,2))","v":"50.0% NB"}]
["K SS =",{"$f":"InputSheet!$C$18","v":7.0000000000000007E-2},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,{"$f":"IF(InputSheet!$F$20=0,\" \",TEXT(InputSheet!$F$20,\"#.0%\")&\" \"&MID(InputSheet!$E$20,LEN(InputSheet!$E$20)-2,2))","v":"50.0% SB"},null,"K SS =",{"$f":"InputSheet!$C$18","v":7.0000000000000007E-2},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,{"$f":"IF(InputSheet!$F$20=0,\" \",TEXT(InputSheet!$F$20,\"#.0%\")&\" \"&MID(InputSheet!$E$20,LEN(InputSheet!$E$20)-2,2))","v":"50.0% SB"}]
[]
[null,{"$f":"\"PROJECT TRAFFIC FOR \"&InputSheet!$C$6&\" AT \"&InputSheet!$C$7&\"\"","v":"PROJECT TRAFFIC FOR  AT "}]
[]
[null,{"$f":"InputSheet!$I$7&\" INPUT TMCs COMPARED TO \"&InputSheet!$I$7&\" DHV\"","v":"0 INPUT TMCs COMPARED TO 0 DHV"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InputSheet!$I$7&\" INPUT TMCs COMPARED TO \"&InputSheet!$I$8&\" DHV\"","v":"0 INPUT TMCs COMPARED TO 0 DHV"}]
[]
[null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
[null,null,null,null,{"$f":"-InputSheet!$E$75","v":0},{"$f":"-InputSheet!$E$74","v":0},{"$f":"-InputSheet!$E$73","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$75","v":0},{"$f":"-InputSheet!$E$74","v":0},{"$f":"-InputSheet!$E$73","v":0}]
[null,null,null,null,{"$f":"E8","v":0},{"$f":"F8","v":0},{"$f":"G8","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"R8","v":0},{"$f":"S8","v":0},{"$f":"T8","v":0}]
[null,null,null,null,{"$f":"IF(E49<>0,-E50/E49,\"N/A\")","v":"N/A"},{"$f":"IF(F49<>0,-F50/F49,\"N/A\")","v":"N/A"},{"$f":"IF(G49<>0,-G50/G49,\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,{"$f":"IF(R49<>0,-R50/R49,\"N/A\")","v":"N/A"},{"$f":"IF(S49<>0,-S50/S49,\"N/A\")","v":"N/A"},{"$f":"IF(T49<>0,-T50/T49,\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L53<>0,-K53/L53,\"N/A\")","v":"N/A"},{"$f":"J10","v":0},{"$f":"-InputSheet!$E$71","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y53<>0,-X53/Y53,\"N/A\")","v":"N/A"},{"$f":"W10","v":0},{"$f":"-InputSheet!$E$71","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L54<>0,-K54/L54,\"N/A\")","v":"N/A"},{"$f":"J11","v":0},{"$f":"-InputSheet!$E$70","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y54<>0,-X54/Y54,\"N/A\")","v":"N/A"},{"$f":"W11","v":0},{"$f":"-InputSheet!$E$70","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L55<>0,-K55/L55,\"N/A\")","v":"N/A"},{"$f":"J12","v":0},{"$f":"-InputSheet!$E$69","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y55<>0,-X55/Y55,\"N/A\")","v":"N/A"},{"$f":"W12","v":0},{"$f":"-InputSheet!$E$69","v":0}]
[null,{"$f":"-InputSheet!$E$65","v":0},{"$f":"D13","v":0},{"$f":"IF(B56<>0,-C56/B56,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$65","v":0},{"$f":"Q13","v":0},{"$f":"IF(O56<>0,-P56/O56,\"N/A\")","v":"N/A"}]
[null,{"$f":"-InputSheet!$E$66","v":0},{"$f":"D14","v":0},{"$f":"IF(B57<>0,-C57/B57,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$66","v":0},{"$f":"Q14","v":0},{"$f":"IF(O57<>0,-P57/O57,\"N/A\")","v":"N/A"}]
[null,{"$f":"-InputSheet!$E$67","v":0},{"$f":"D15","v":0},{"$f":"IF(B58<>0,-C58/B58,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$67","v":0},{"$f":"Q15","v":0},{"$f":"IF(O58<>0,-P58/O58,\"N/A\")","v":"N/A"}]
[]
[null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G63<>0,-G62/G63,\"N/A\")","v":"N/A"},{"$f":"IF(H63<>0,-H62/H63,\"N/A\")","v":"N/A"},{"$f":"IF(I63<>0,-I62/I63,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T63<>0,-T62/T63,\"N/A\")","v":"N/A"},{"$f":"IF(U63<>0,-U62/U63,\"N/A\")","v":"N/A"},{"$f":"IF(V63<>0,-V62/V63,\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,{"$f":"G18","v":0},{"$f":"H18","v":0},{"$f":"I18","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"T18","v":0},{"$f":"U18","v":0},{"$f":"V18","v":0}]
["(XXX)",{"$f":"InputSheet!$I$7&\" Input TMCs\"","v":"0 Input TMCs"},null,null,null,null,{"$f":"-InputSheet!$E$77","v":0},{"$f":"-InputSheet!$E$78","v":0},{"$f":"-InputSheet!$E$79","v":0},null,null,null,null,"(XXX)",{"$f":"InputSheet!$I$7&\" Input TMCs\"","v":"0 Input TMCs"},null,null,null,null,{"$f":"-InputSheet!$E$77","v":0},{"$f":"-InputSheet!$E$78","v":0},{"$f":"-InputSheet!$E$79","v":0}]
["XXX",{"$f":"\"Calculated \"&InputSheet!$I$7&\" DHV\"","v":"Calculated 0 DHV"},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,"XXX",{"$f":"\"Calculated \"&InputSheet!$I$8&\" DHV\"","v":"Calculated 0 DHV"},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
["X.XX","Ratio",null,null,null,null,null,null,null,null,null,null,null,"X.XX","Ratio"]
[null,{"$f":"InputSheet!$I$7&\" INPUT TMCs COMPARED TO \"&InputSheet!$I$9&\" DHV\"","v":"0 INPUT TMCs COMPARED TO 0 DHV"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InputSheet!$I$7&\" INPUT TMCs COMPARED TO \"&InputSheet!$I$10&\" DHV\"","v":"0 INPUT TMCs COMPARED TO 0 DHV"}]
[]
[null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
[null,null,null,null,{"$f":"-InputSheet!$E$75","v":0},{"$f":"-InputSheet!$E$74","v":0},{"$f":"-InputSheet!$E$73","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$75","v":0},{"$f":"-InputSheet!$E$74","v":0},{"$f":"-InputSheet!$E$73","v":0}]
[null,null,null,null,{"$f":"E28","v":0},{"$f":"F28","v":0},{"$f":"G28","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"R28","v":0},{"$f":"S28","v":0},{"$f":"T28","v":0}]
[null,null,null,null,{"$f":"IF(E69<>0,-E70/E69,\"N/A\")","v":"N/A"},{"$f":"IF(F69<>0,-F70/F69,\"N/A\")","v":"N/A"},{"$f":"IF(G69<>0,-G70/G69,\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,{"$f":"IF(R69<>0,-R70/R69,\"N/A\")","v":"N/A"},{"$f":"IF(S69<>0,-S70/S69,\"N/A\")","v":"N/A"},{"$f":"IF(T69<>0,-T70/T69,\"N/A\")","v":"N/A"},null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L73<>0,-K73/L73,\"N/A\")","v":"N/A"},{"$f":"J30","v":0},{"$f":"-InputSheet!$E$71","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y73<>0,-X73/Y73,\"N/A\")","v":"N/A"},{"$f":"W30","v":0},{"$f":"-InputSheet!$E$71","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L74<>0,-K74/L74,\"N/A\")","v":"N/A"},{"$f":"J31","v":0},{"$f":"-InputSheet!$E$70","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y74<>0,-X74/Y74,\"N/A\")","v":"N/A"},{"$f":"W31","v":0},{"$f":"-InputSheet!$E$70","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(L75<>0,-K75/L75,\"N/A\")","v":"N/A"},{"$f":"J32","v":0},{"$f":"-InputSheet!$E$69","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y75<>0,-X75/Y75,\"N/A\")","v":"N/A"},{"$f":"W32","v":0},{"$f":"-InputSheet!$E$69","v":0}]
[null,{"$f":"-InputSheet!$E$65","v":0},{"$f":"D33","v":0},{"$f":"IF(B76<>0,-C76/B76,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$65","v":0},{"$f":"Q33","v":0},{"$f":"IF(O76<>0,-P76/O76,\"N/A\")","v":"N/A"}]
[null,{"$f":"-InputSheet!$E$66","v":0},{"$f":"D34","v":0},{"$f":"IF(B77<>0,-C77/B77,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$66","v":0},{"$f":"Q34","v":0},{"$f":"IF(O77<>0,-P77/O77,\"N/A\")","v":"N/A"}]
[null,{"$f":"-InputSheet!$E$67","v":0},{"$f":"D35","v":0},{"$f":"IF(B78<>0,-C78/B78,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"-InputSheet!$E$67","v":0},{"$f":"Q35","v":0},{"$f":"IF(O78<>0,-P78/O78,\"N/A\")","v":"N/A"}]
[]
[null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$7,InputSheet!$C$6)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G83<>0,-G82/G83,\"N/A\")","v":"N/A"},{"$f":"IF(H83<>0,-H82/H83,\"N/A\")","v":"N/A"},{"$f":"IF(I83<>0,-I82/I83,\"N/A\")","v":"N/A"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T83<>0,-T82/T83,\"N/A\")","v":"N/A"},{"$f":"IF(U83<>0,-U82/U83,\"N/A\")","v":"N/A"},{"$f":"IF(V83<>0,-V82/V83,\"N/A\")","v":"N/A"}]
[null,null,null,null,null,null,{"$f":"G38","v":0},{"$f":"H38","v":0},{"$f":"I38","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"T38","v":0},{"$f":"U38","v":0},{"$f":"V38","v":0}]
["(XXX)",{"$f":"InputSheet!$I$7&\" Input TMCs\"","v":"0 Input TMCs"},null,null,null,null,{"$f":"-InputSheet!$E$77","v":0},{"$f":"-InputSheet!$E$78","v":0},{"$f":"-InputSheet!$E$79","v":0},null,null,null,null,"(XXX)",{"$f":"InputSheet!$I$7&\" Input TMCs\"","v":"0 Input TMCs"},null,null,null,null,{"$f":"-InputSheet!$E$77","v":0},{"$f":"-InputSheet!$E$78","v":0},{"$f":"-InputSheet!$E$79","v":0}]
["XXX",{"$f":"\"Calculated \"&InputSheet!$I$9&\" DHV\"","v":"Calculated 0 DHV"},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0},null,null,null,null,null,null,null,"XXX",{"$f":"\"Calculated \"&InputSheet!$I$10&\" DHV\"","v":"Calculated 0 DHV"},null,null,null,{"$f":"IF(Data!$B$1=\"yes\",InputSheet!$C$6,InputSheet!$C$7)","v":0}]
["X.XX","Ratio",null,null,null,null,null,null,null,null,null,null,null,"X.XX","Ratio"]

{"sheet":"Data","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Mainline N/S?","no","Automatic Estimating?",null,null,3,null,null,"PIN"]
["FSUTMS input?","no"]
["Intersection",4,"(3 or 4 legs?)"]
["Two-Way Selected",1,0,0,1]
["Three-Way Selected",1,1,1,1,"(value of 1 means approach is active) (NB, SB, EB, WB)"]
["Macro Run","no"]
["Errors","Growth"]
[null,1,1,"1=Linear, 2 = Exponential, 3 = Decaying for ML, side street"]
[]
[null,"N/S Road"]
[null,"E/W Road"]

{"sheet":"XML","index":6,"n_rows":29,"n_cols":19,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,"year","kmain","kside","OWDHTM_NB_T","OWDHTM_NB_RT","OWDHTM_NB_LT","OWDHTM_SB_T","OWDHTM_SB_RT","OWDHTM_SB_LT","OWDHTM_EB_T","OWDHTM_EB_RT","OWDHTM_EB_LT","OWDHTM_WB_T","OWDHTM_WB_RT","OWDHTM_WB_LT","NS_ROADNAME","EW_ROADNAME","NOTES"]
["EXISTING",{"$f":"InputSheet!I7","v":0},{"$f":"InputSheet!C16*100","v":7.0000000000000009},{"$f":"InputSheet!C18*100","v":7.0000000000000009},{"$f":"TurnSheets!H18","v":0},{"$f":"TurnSheets!I18","v":0},{"$f":"TurnSheets!G18","v":0},{"$f":"TurnSheets!F8","v":0},{"$f":"TurnSheets!G8","v":0},{"$f":"TurnSheets!E8","v":0},{"$f":"TurnSheets!D14","v":0},{"$f":"TurnSheets!D15","v":0},{"$f":"TurnSheets!D13","v":0},{"$f":"TurnSheets!J11","v":0},{"$f":"TurnSheets!J10","v":0},{"$f":"TurnSheets!J12","v":0},{"$f":"Data!$C$10","v":0},{"$f":"Data!$C$11","v":0}]
["OPEN",{"$f":"InputSheet!I8","v":0},{"$f":"InputSheet!C16*100","v":7.0000000000000009},{"$f":"InputSheet!C18*100","v":7.0000000000000009},{"$f":"TurnSheets!U18","v":0},{"$f":"TurnSheets!V18","v":0},{"$f":"TurnSheets!T18","v":0},{"$f":"TurnSheets!S8","v":0},{"$f":"TurnSheets!T8","v":0},{"$f":"TurnSheets!R8","v":0},{"$f":"TurnSheets!Q14","v":0},{"$f":"TurnSheets!Q15","v":0},{"$f":"TurnSheets!Q13","v":0},{"$f":"TurnSheets!W11","v":0},{"$f":"TurnSheets!W10","v":0},{"$f":"TurnSheets!W12","v":0},{"$f":"Data!$C$10","v":0},{"$f":"Data!$C$11","v":0}]
["MID",{"$f":"InputSheet!I9","v":0},{"$f":"InputSheet!C16*100","v":7.0000000000000009},{"$f":"InputSheet!C18*100","v":7.0000000000000009},{"$f":"TurnSheets!H38","v":0},{"$f":"TurnSheets!I38","v":0},{"$f":"TurnSheets!G38","v":0},{"$f":"TurnSheets!F28","v":0},{"$f":"TurnSheets!G28","v":0},{"$f":"TurnSheets!E28","v":0},{"$f":"TurnSheets!D34","v":0},{"$f":"TurnSheets!D35","v":0},{"$f":"TurnSheets!D33","v":0},{"$f":"TurnSheets!J31","v":0},{"$f":"TurnSheets!J30","v":0},{"$f":"TurnSheets!J32","v":0},{"$f":"Data!$C$10","v":0},{"$f":"Data!$C$11","v":0}]
["DESIGN",{"$f":"InputSheet!I10","v":0},{"$f":"InputSheet!C16*100","v":7.0000000000000009},{"$f":"InputSheet!C18*100","v":7.0000000000000009},{"$f":"TurnSheets!U38","v":0},{"$f":"TurnSheets!V38","v":0},{"$f":"TurnSheets!T38","v":0},{"$f":"TurnSheets!S28","v":0},{"$f":"TurnSheets!T28","v":0},{"$f":"TurnSheets!R28","v":0},{"$f":"TurnSheets!Q34","v":0},{"$f":"TurnSheets!Q35","v":0},{"$f":"TurnSheets!Q33","v":0},{"$f":"TurnSheets!W31","v":0},{"$f":"TurnSheets!W30","v":0},{"$f":"TurnSheets!W32","v":0},{"$f":"Data!$C$10","v":0},{"$f":"Data!$C$11","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OWDHTM","One Way Design Hour Turning Movement"]
["T","Through"]
["LT","Left Turn"]
["RT","Right Turn"]