{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions & Input","Dropdowns","Chapter 3 Warrant 1","Chapter 3 Warrant 2","Chapter 3 Warrant 3","Chapter 3 Warrant 4","Chapter 3 Warrant 5","Chapter 3 Warrant 6","Chapter 3 Warrant 7","Chapter 3 Warrant 8","Chapter 3 Warrant 9","Warrant Summary"],"not_rendered":{"charts":11,"images":2,"macros":1,"external_links":3,"defined_names":80,"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":"Instructions & Input","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,0,4,9],[13,2,13,9],[14,2,14,9],[26,1,26,3],[17,2,17,9],[8,0,8,1],[49,1,49,3],[45,1,45,4],[38,1,38,3],[38,6,38,8],[26,6,26,8]]}
[null,null,null,"TRAFFIC SIGNAL WARRANT SUMMARY"]
["Introduction"]
["- The Signal Warrant Analysis Spreadsheets are a tool for assisting traffic engineers when evaluating the need for a traffic signal installation"]
["- The filled spreadsheets can be used as part of the supporting documents for the signal warrant evaluation"]
["Note: This templates are a useful resource, but it remains necessary to apply engineering judgment and to consider specific environmental, traffic, geometric, and operational conditions"]
[]
["Instructions"]
["Fill in \"Orange\" areas only"]
["Automated cells based on in Input Data in \"orange\" cells"]
["General Information",null,"Fill in below the general information including:"]
[null,null,"District, County (drop-down menu)"]
[null,null,"City, Engineer, Date"]
[null,null,"Major and Minor Street with corresponding number of lanes and speed limits"]
["Enter Eight Hour Volumes",null,"Any 8 hours of an average day. Major-street and minor-street volumes shall be for the same 8 hours; however, the 8 hours satisfied in Condition A shall not be required to be the same 8 hours satisfied in Condition B for 80% columns only. On the minor street, the higher volume shall not be required to be on the same approach during each of the 8 hours."]
["Enter Four Hour Volumes",null,"Any 4 hours of an average day. Vehicles per hour on the major street (total of both approaches) and the corresponding vehicles per hour on the higher-volume minor-street approach (one direction only, not required to be on the same approach during each of the 4 hours)"]
["Enter Pedestrian Volumes (4-hr)",null,"Pedestrians per hour crossing the major street (total of all crossings) "]
["Enter Peak Hour Volumes",null,"Vehicular: Any four consecutive 15-minute periods of an average day"]
[null,null,"Pedestrian: Any four consecutive 15-minute periods of an average day representing the vehicles per hour on the major street (total of both approaches) and the corresponding pedestrians per hour crossing the major street (total of all crossings)"]
["Input Data"]
["City:"]
["County:",null,"Engineer:"]
["District:",null,"Date:"]
[]
["Major Street:",null,"Major Street # Lanes:",null,null,"Major Approach Speed:"]
["Minor Street:",null,"Minor Street # Lanes:",null,null,"Minor Approach Speed:"]
[]
[null,"Eight Hour Volumes (Condition A)",null,null,"For Warrant 7",null,"Eight Hour Volumes (Condition B)"]
[null,"Hours","Major Street\n(total of both approaches)","Minor Street\n(one direction only)","Ped Crossings on Major Street",null,"Hours","Major Street\n(total of both approaches)","Minor Street\n(one direction only)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Highest Four Hour Vehicular Volumes",null,null,null,null,"Highest Four Hour Pedestrian Volumes"]
[null,"Hours","Major Street\n(total of both approaches)","Minor Street\n(one direction only)",null,null,"Hours","Major Street\n(total of both approaches)","Pedestrian Crossings on Major Street"]
[]
[]
[]
[]
[]
[null,"Vehicular Peak Hour Volumes"]
[null,"Peak Hour","Major Street\n(total of both approaches)","Minor Street\n(one direction only)","Total Entering Volume"]
[]
[]
[null,"Pedestrian Peak Hour Volumes"]
[null,"Peak Hour","Major Street\n(total of both approaches)","Pedestrian Crossing Volumes on Major Street"]

{"sheet":"Dropdowns","index":1,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["District","County","Critical Approach"]
["One","01 – Charlotte","Major"]
["Two","02 – Citrus","Minor"]
["Three","03 – Collier"]
["Four","04 – Desoto"]
["Five","05 – Glades"]
["Six","06 – Hardee"]
["Seven","07 – Hendry"]
[null,"08 – Hernando"]
[null,"09 – Highlands"]
[null,"10 – Hillsborough"]
[null,"11 – Lake"]
[null,"12 – Lee "]
[null,"13 – Manatee"]
[null,"14 – Pasco"]
[null,"15 – Pinellas "]
[null,"16 – Polk"]
[null,"17 – Sarasota"]
[null,"18 – Sumter"]
[null,"26 – Alachua"]
[null,"27 – Baker"]
[null,"28 – Bradford"]
[null,"29 – Columbia"]
[null,"30 – Dixie"]
[null,"31 – Gilchrist"]
[null,"32 – Hamilton"]
[null,"33 – Lafayette"]
[null,"34 – Levy"]
[null,"35 – Madison"]
[null,"36 – Marion"]
[null,"37 – Suwannee"]
[null,"38 – Taylor"]
[null,"39 – Union"]
[null,"46 – Bay"]
[null,"47 – Calhoun"]
[null,"48 – Escambia"]
[null,"49 – Franklin"]
[null,"50 – Gadsden"]
[null,"51 – Gulf"]
[null,"52 – Holmes"]
[null,"53 – Jackson"]
[null,"54 – Jefferson"]
[null,"55 – Leon"]
[null,"56 – Liberty"]
[null,"57 – Okaloosa"]
[null,"58 – Santa Rosa"]
[null,"59 – Wakulla"]
[null,"60 – Walton"]
[null,"61 – Washington"]
[null,"70 – Brevard"]
[null,"71 – Clay"]
[null,"72 – Duval"]
[null,"73 – Flagler"]
[null,"74 – Nassau"]
[null,"75 – Orange"]
[null,"76 – Putnam"]
[null,"77 – Seminole"]
[null,"78 – St. Johns"]
[null,"79 – Volusia"]
[null,"86 – Broward"]
[null,"87 – Miami Dade"]
[null,"88 – Indian River"]
[null,"89 – Martin"]
[null,"90 – Monroe"]
[null,"91 – Okeechobee"]
[null,"92 – Osceola"]
[null,"93 – Palm Beach"]
[null,"94 – St. Lucie"]
[null,"97 – FL. Turnpike"]
[null,"99 – Out Of State"]

{"sheet":"Chapter 3 Warrant 1","index":2,"n_rows":91,"n_cols":45,"rows_kept":91,"cut":false,"hidden":false,"merged":[[63,2,63,22],[48,19,51,20],[52,19,53,20],[38,6,38,9],[69,10,71,18],[72,10,72,12],[72,13,72,15],[6,5,6,14],[9,33,9,35],[47,5,47,20],[40,2,40,5],[40,6,40,9],[52,2,53,4],[52,11,53,12],[52,13,53,14],[52,15,53,16],[52,17,53,18],[52,7,53,8],[52,9,53,10],[48,7,51,8],[48,9,51,10],[48,11,51,12],[48,13,51,14],[48,15,51,16],[48,17,51,18],[47,2,51,4],[48,5,51,6],[52,5,53,6],[76,10,76,12],[76,13,76,15],[76,16,76,18],[88,19,89,20],[54,5,55,6],[54,7,55,8],[54,9,55,10],[54,11,55,12],[54,13,55,14],[54,15,55,16],[54,17,55,18],[54,19,55,20],[69,2,71,9],[88,2,89,4],[76,19,76,21],[54,2,55,4],[58,0,58,35],[59,0,59,35],[76,2,76,5],[72,6,72,9],[84,19,87,20],[73,19,73,21],[75,2,75,5],[75,6,75,9],[88,15,89,16],[88,17,89,18],[84,5,87,6],[84,7,87,8],[84,9,87,10],[84,11,87,12],[84,13,87,14],[84,15,87,16],[84,17,87,18],[72,2,72,5],[75,22,75,24],[5,24,5,34],[8,5,8,19],[8,23,8,24],[9,5,9,19],[9,23,9,24],[76,22,76,24],[69,19,71,27],[72,25,72,27],[73,25,73,27],[74,25,74,27],[75,25,75,27],[76,25,76,27],[73,22,73,24],[74,10,74,12],[74,13,74,15],[74,16,74,18],[74,19,74,21],[74,22,74,24],[75,10,75,12],[75,13,75,15],[74,2,74,5],[74,6,74,9],[90,5,91,6],[90,7,91,8],[90,9,91,10],[90,11,91,12],[73,10,73,12],[73,13,73,15],[73,16,73,18],[83,2,83,20],[84,2,87,4],[75,16,75,18],[75,19,75,21],[90,13,91,14],[90,15,91,16],[90,17,91,18],[90,19,91,20],[73,2,73,5],[73,6,73,9],[90,2,91,4],[76,6,76,9],[88,5,89,6],[88,7,89,8],[88,9,89,10],[88,11,89,12],[88,13,89,14],[38,22,38,24],[39,22,39,24],[40,22,40,24],[41,22,41,24],[39,2,39,5],[41,10,41,12],[40,10,40,12],[39,10,39,12],[38,10,38,12],[41,19,41,21],[38,2,38,5],[39,6,39,9],[41,2,41,5],[41,6,41,9],[2,0,2,35],[34,10,36,18],[37,10,37,12],[37,13,37,15],[37,16,37,18],[37,19,37,21],[4,5,4,14],[4,24,4,34],[5,5,5,14],[8,33,8,35],[37,22,37,24],[34,2,36,9],[37,2,37,5],[37,6,37,9],[11,12,11,25],[23,0,25,27],[72,16,72,18],[72,19,72,21],[72,22,72,24],[64,2,66,22],[1,0,1,35],[38,13,38,15],[39,13,39,15],[40,13,40,15],[41,13,41,15],[38,16,38,18],[39,16,39,18],[40,16,40,18],[41,16,41,18],[38,19,38,21],[39,19,39,21],[40,19,40,21],[34,19,36,27],[37,25,37,27],[38,25,38,27],[39,25,39,27],[28,2,28,22],[30,2,32,22],[40,25,40,27],[41,25,41,27]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0},null,null,{"$f":"IF(Major_Approach_Speed>40,TRUE,FALSE)","v":false}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0},null,null,{"$f":"IF(Major_Approach_Speed<41,TRUE,FALSE)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK12=TRUE,AK11=TRUE),1,0)","v":0}]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[null,"Volume Level Criteria"]
[null,null,"1.  Is the posted speed or 85th-percentile of major street > 40 mph?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK16=TRUE,AK15=TRUE),1,0)","v":0}]
[null,null,"2.  Is the intersection in a built-up area of an isolated community with a  population < 10,000?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK18=TRUE,1,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,{"$f":"IF((OR(AK15,AK9)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(AK17=TRUE,1,0)","v":0}]
[null,null,"\"70%\" volume level may be used if Question 1 or 2 above is answered \"Yes\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,"WARRANT 1 - EIGHT-HOUR VEHICULAR VOLUME",null,null,null,null,null,null,null,null,null,null,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":"AO30","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warrant 1 is satisfied if Condition A or Condition B is \"100%\" satisfied for eight hours.",null,null,null,null,null,null,null,null,{"$f":"AP30","v":false},{"$f":"IF(OR(AK22=TRUE,AK21=TRUE),1,0)","v":0}]
[]
["Warrant 1 is also satisfied if both Condition A and Condition B are \"80%\" satisfied \n(should only be applied  after an adequate trial of other alternatives that could cause less delay and inconvenience to traffic has failed to solve the traffic problems).",null,null,null,null,null,null,null,null,null,null,null,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":"AO31","v":false},{"$f":"IF(OR(AK25=TRUE,AK24=TRUE),1,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,{"$f":"AP31","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AO32","v":false},{"$f":"IF(OR(AK28=TRUE,AK26=TRUE),1,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,"Warrant 1 is satisfied if Condition A or Condition B is \"70%\" satisfied for eight hours.",null,null,null,null,null,null,null,null,{"$f":"AP32","v":false}]
[null,null,"Condition A - Minimum Vehicular Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK31=TRUE,AK29=TRUE),1,0)","v":0},null,null,"Yes","No","Warrant 1 Met"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF((OR(AK32,AK65)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF((AND(AK33,AK66)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(OR(AO31,AO30,AO32=TRUE),1,0)","v":0},null,"Not Applicable"]
[null,null,"Condition A is intended for application at locations where a large volume of intersecting traffic is the principal reason to consider installing a traffic control signal.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK33=TRUE,AK32=TRUE),1,0)","v":0},null,0.8,{"$f":"IF((AND(AK34,AK67)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF((OR(AK35,AK68)=TRUE),TRUE,FALSE)","v":false},"Warrant NOT Met",null,{"$f":"IF(AND(AK12,AK64=TRUE),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"80% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK35=TRUE,AK34=TRUE),1,0)","v":0},null,0.7,{"$f":"IF((OR(AK36,AK69)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF((AND(AK37,AK70)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(AND(AP31,AP30,AP32=TRUE),1,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,"70% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK37=TRUE,AK36=TRUE),1,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,false]
[null,null,"Number of Lanes for moving traffic on each approach",null,null,null,null,null,null,null,"Vehicles per hour on major-street (total of both approaches)",null,null,null,null,null,null,null,null,"Vehicles per hour on minor-street (one direction only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Major",null,null,null,"Minor",null,null,null,"100%a",null,null,"80%b",null,null,"70%c",null,null,"100%a",null,null,"80%b",null,null,"70%c",null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK38=TRUE,1,0)","v":0}]
[null,null,1,null,null,null,1,null,null,null,500,null,null,400,null,null,350,null,null,150,null,null,120,null,null,105]
[null,null,"2 or more",null,null,null,1,null,null,null,600,null,null,480,null,null,420,null,null,150,null,null,120,null,null,105]
[null,null,"2 or more",null,null,null,"2 or more",null,null,null,600,null,null,480,null,null,420,null,null,200,null,null,160,null,null,140]
[null,null,1,null,null,null,"2 or more",null,null,null,500,null,null,400,null,null,350,null,null,200,null,null,160,null,null,140]
[null,null,"a Basic Minimum hourly volume"]
[null,null,"b Used for combination of Conditions A and B after adequate trial of other remedial measures"]
[null,null,"c May be used when the major-street speed exceeds 40 mph or in an isolated community with a population of less than 10,000"]
[]
[null,null,"Record 8 highest hours and the corresponding major-street and minor-street volumes in the Instructions Sheet."]
[null,null,"Street",null,null,"Eight Highest Hours"]
[null,null,null,null,null,{"$f":"'Instructions & Input'!$B29","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B30","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B31","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B32","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B33","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B34","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B35","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$B36","v":"00:00:00"}]
[]
[]
[]
[null,null,"Major",null,null,{"$f":"'Instructions & Input'!$C29","v":0},null,{"$f":"'Instructions & Input'!$C30","v":0},null,{"$f":"'Instructions & Input'!$C31","v":0},null,{"$f":"'Instructions & Input'!$C32","v":0},null,{"$f":"'Instructions & Input'!$C33","v":0},null,{"$f":"'Instructions & Input'!$C34","v":0},null,{"$f":"'Instructions & Input'!$C35","v":0},null,{"$f":"'Instructions & Input'!$C36","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,"Existing Volumes"]
[null,null,"Minor",null,null,{"$f":"'Instructions & Input'!$D29","v":0},null,{"$f":"'Instructions & Input'!$D30","v":0},null,{"$f":"'Instructions & Input'!$D31","v":0},null,{"$f":"'Instructions & Input'!$D32","v":0},null,{"$f":"'Instructions & Input'!$D33","v":0},null,{"$f":"'Instructions & Input'!$D34","v":0},null,{"$f":"'Instructions & Input'!$D35","v":0},null,{"$f":"'Instructions & Input'!$D36","v":0}]
[]
[]
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Condition B - Interruption of Continuous Traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK64=TRUE,AK63=TRUE),1,0)","v":0}]
[null,null,"Condition B is intended for application where Condition A is not satisfied and the traffic volume on a major street is so heavy that traffic on the minor intersecting street suffers excessive delay or conflict in entering or crossing the major street.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK66=TRUE,AK65=TRUE),1,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,"80% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK68=TRUE,AK67=TRUE),1,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,"70% Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK70=TRUE,AK69=TRUE),1,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,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Number of Lanes for moving traffic on each approach",null,null,null,null,null,null,null,"Vehicles per hour on major-street (total of both approaches)",null,null,null,null,null,null,null,null,"Vehicles per hour on minor-street (one direction only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[null,null,"Major",null,null,null,"Minor",null,null,null,"100%a",null,null,"80%b",null,null,"70%c",null,null,"100%a",null,null,"80%b",null,null,"70%c"]
[null,null,1,null,null,null,1,null,null,null,750,null,null,600,null,null,525,null,null,75,null,null,60,null,null,53]
[null,null,"2 or more",null,null,null,1,null,null,null,900,null,null,720,null,null,630,null,null,75,null,null,60,null,null,53]
[null,null,"2 or more",null,null,null,"2 or more",null,null,null,900,null,null,720,null,null,630,null,null,100,null,null,80,null,null,70]
[null,null,1,null,null,null,"2 or more",null,null,null,750,null,null,600,null,null,525,null,null,100,null,null,80,null,null,70]
[null,null,"a Basic Minimum hourly volume"]
[null,null,"b Used for combination of Conditions A and B after adequate trial of other remedial measures"]
[null,null,"c May be used when the major-street speed exceeds 40 mph or in an isolated community with a population of less than 10,000"]
[]
[]
[null,null,"Record 8 highest hours and the corresponding major-street and minor-street volumes in the Instructions Sheet."]
[null,null,"Eight Highest Hours"]
[null,null,"Street",null,null,{"$f":"'Instructions & Input'!$G29","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G30","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G31","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G32","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G33","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G34","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G35","v":"00:00:00"},null,{"$f":"'Instructions & Input'!$G36","v":"00:00:00"}]
[]
[]
[]
[null,null,"Major",null,null,{"$f":"'Instructions & Input'!$H29","v":0},null,{"$f":"'Instructions & Input'!$H30","v":0},null,{"$f":"'Instructions & Input'!$H31","v":0},null,{"$f":"'Instructions & Input'!$H32","v":0},null,{"$f":"'Instructions & Input'!$H33","v":0},null,{"$f":"'Instructions & Input'!$H34","v":0},null,{"$f":"'Instructions & Input'!$H35","v":0},null,{"$f":"'Instructions & Input'!$H36","v":0}]
[]
[null,null,"Minor",null,null,{"$f":"'Instructions & Input'!$I29","v":0},null,{"$f":"'Instructions & Input'!$I30","v":0},null,{"$f":"'Instructions & Input'!$I31","v":0},null,{"$f":"'Instructions & Input'!$I32","v":0},null,{"$f":"'Instructions & Input'!$I33","v":0},null,{"$f":"'Instructions & Input'!$I34","v":0},null,{"$f":"'Instructions & Input'!$I35","v":0},null,{"$f":"'Instructions & Input'!$I36","v":0},null,null,null,null,"Existing Volumes"]

{"sheet":"Chapter 3 Warrant 2","index":3,"n_rows":117,"n_cols":54,"rows_kept":117,"cut":false,"hidden":false,"merged":[[1,0,1,35],[2,0,2,35],[4,5,4,14],[5,5,5,14],[6,5,6,14],[23,11,23,34],[8,5,8,19],[8,23,8,24],[4,24,4,34],[5,24,5,34],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[11,13,11,26],[46,1,46,3],[47,1,47,3],[47,4,47,6],[41,4,41,9],[42,4,43,6],[42,7,43,9],[41,1,43,3],[46,7,46,9],[47,7,47,9],[44,4,44,6],[45,4,45,6],[46,4,46,6],[44,7,44,9],[25,1,25,9],[40,1,40,9],[44,1,44,3],[45,1,45,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[32,7,32,9],[45,7,45,9],[30,4,30,6],[31,4,31,6],[32,4,32,6],[30,7,30,9],[31,7,31,9],[26,4,26,9],[26,1,28,3],[27,4,28,6],[27,7,28,9],[29,1,29,3],[29,4,29,6],[29,7,29,9]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4C-1 (FIGURE A VALUES)",null,null,null,null,null,null,"4C-2 (FIGURE B VALUES)"]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Major ",null,"2 or More","1 Lane","2 or More","1 Lane",null,"Major ",null,"2 or More","1 Lane","2 or More","1 Lane"]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor",null,"2 or More","2 or More","1 Lane","1 Lane",null,"Minor",null,"2 or More","2 or More","1 Lane","1 Lane"]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","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,"X","X trend","Y1","Y2","Y3","Y4",null,"X","X trend","Y1","Y2","Y3","Y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,3,null,null,null,null,null,200,2]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0},null,null,{"$f":"IF(Major_Approach_Speed>40,TRUE,FALSE)","v":false},null,310,3.1,null,null,null,null,null,210,2.1]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0},null,null,{"$f":"IF(Major_Approach_Speed<41,TRUE,FALSE)","v":true},null,320,3.2,null,null,null,null,null,220,2.2000000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,330,3.3,null,null,null,null,null,230,2.2999999999999998]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,350,3.5,null,null,null,null,null,250,2.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,360,3.6,null,null,null,null,null,260,2.6,null,null,null,222.58641919998627]
[null,"Volume Level Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,370,3.7,null,null,null,null,null,270,2.7,null,null,null,218.48486759998406]
[null,null,"1.  Is the posted speed or 85th-percentile of major street > 40 mph?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,380,3.8,null,396.21146528000003,396.21146528000003,318.39589039999998,null,280,2.8,null,271.12657920000004,271.12657920000004,214.35320639998156]
[null,null,"2.  Is the intersection in a built-up area of an isolated community with a  population < 10,000?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK17=TRUE,AK16=TRUE),1,0)","v":0},390,3.9,null,391.19314223000003,391.19314223000003,313.19863865000002,null,290,2.9,null,266.04651505000004,266.04651505000004,210.19554679997879]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK19=TRUE,AK18=TRUE),1,0)","v":0},400,4,null,386.17320000000007,386.17320000000007,308.07599999999996,null,300,3,null,260.98680000000002,260.98680000000002,206.01599999997569]
[null,null,"\"70%\" volume level may be used if Question 1 or 2 above is answered \"Yes\"",null,null,null,null,null,null,null,null,null,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((OR(AK16,AK9)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(AK18=TRUE,1,0)","v":0},410,4.0999999999999996,null,381.15400163000004,381.15400163000004,303.02598664999999,null,310,3.1,null,255.95020964999998,255.95020964999998,201.81867719997229]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK19=TRUE,1,0)","v":0},420,4.2,null,376.13786048000009,376.13786048000009,298.04667439999997,null,320,3.2,null,250.93945600000001,250.93945600000001,197.60768959996852]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,430,4.3,null,371.12704023000003,371.12704023000003,293.13620264999997,null,330,3.3,null,245.95718744999999,245.95718744999999,193.38714839996442]
[null,"WARRANT 2 - FOUR-HOUR VEHICULAR VOLUME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,440,4.4000000000000004,null,366.12375488000004,366.12375488000004,288.29277439999998,null,340,3.4,328.54963839999994,241.00598880000001,241.00598880000001,189.16116479995992]
[null,null," If all four points lie above the appropriate line, then the warrant is satisfied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK21=TRUE,AK20=TRUE),1,0)","v":0},450,4.5,null,361.13016875000005,361.13016875000005,283.51465624999997,null,350,3.5,320.97185624999997,236.08838125000003,236.08838125000003,184.93384999995499]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK23=TRUE,AK22=TRUE),1,0)","v":0},460,4.5999999999999996,null,356.14839648000003,356.14839648000003,278.80017839999999,null,360,3.6,313.52800959999996,231.20682240000002,231.20682240000002,180.7093151999496]
[null,null,null,null,null,null,null,null,null,null,null,"Plot four volume combinations on the applicable figure below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,470,4.7,null,351.18050303000001,351.18050303000001,274.14773464999996,null,370,3.7,306.21891204999991,226.36370625000001,226.36370625000001,176.49167159994377]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,480,4.8,468.47050623999996,346.22850368000007,346.22850368000007,269.5557824,null,380,3.8,299.04522719999994,221.56136320000002,221.56136320000002,172.28503039993745]
[null,"100% Volume Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,490,4.9000000000000004,461.54024968999994,341.29436403,341.29436403,265.02284264999992,null,390,3.9,292.00746864999996,216.80206005000002,216.80206005000002,168.0935027999306]
[null,"Four Highest Hours",null,null,"Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,5,454.65499999999997,336.38,336.38,260.54750000000001,null,400,4,285.10599999999994,212.08800000000002,212.08800000000002,163.9211999999232,null,"Inputs"]
[null,null,null,null,"Major Street",null,null,"Minor Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,510,5.0999999999999996,447.81712548999997,331.48727783000004,331.48727783000004,256.12840265,null,410,4.0999999999999996,278.34103484999997,207.42132265000001,207.42132265000001,159.77223319991521,null,{"$f":"SUM(E30)","v":0},{"$f":"SUM(H30)","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,520,5.2,441.02891263999999,326.61801408000008,326.61801408000008,251.76426240000001,null,420,4.2,271.71263679999998,202.804104,202.804104,155.65071359990665,null,{"$f":"SUM(E31)","v":0},{"$f":"SUM(H31)","v":0}]
[null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!B41>0),'Instructions & Input'!B41,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!C41>0),'Instructions & Input'!C41,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!D41>0),'Instructions & Input'!D41,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,530,5.3,434.29256608999998,321.77397563000005,321.77397563000005,247.45385464999993,null,430,4.3,265.22071944999999,198.23835645000003,198.23835645000003,151.56075239989741,null,{"$f":"SUM(E32)","v":0},{"$f":"SUM(H32)","v":0}]
[null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!B42>0),'Instructions & Input'!B42,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!C42>0),'Instructions & Input'!C42,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!D42>0),'Instructions & Input'!D42,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,540,5.4,427.61020863999994,316.95687968000004,316.95687968000004,243.19601839999996,null,440,4.4000000000000004,258.86504639999993,193.72602879999999,193.72602879999999,147.50646079988752,null,{"$f":"SUM(E33)","v":0},{"$f":"SUM(H33)","v":0}]
[null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!B43>0),'Instructions & Input'!B43,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!C43>0),'Instructions & Input'!C43,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!D43>0),'Instructions & Input'!D43,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,550,5.5,420.98388124999997,312.16839375000006,312.16839375000006,238.98965625,null,450,4.5,252.64523124999994,189.26900625000002,189.26900625000002,143.49194999987699,null,"Graphed Points"]
[null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!B44>0),'Instructions & Input'!B44,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!C44>0),'Instructions & Input'!C44,\"\")","v":""},null,null,{"$f":"IF(($AK$19=TRUE)*AND('Instructions & Input'!D44>0),'Instructions & Input'!D44,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK33=TRUE,1,0)","v":0},560,5.6,414.41554303999999,307.41013568000005,307.41013568000005,234.83373440000003,null,460,4.5999999999999996,246.56073759999998,184.86911040000001,184.86911040000001,139.5213311998657,null,{"$f":"IF(BA28>1400, 1400, BA28)","v":0},{"$f":"IF(BB28>500, 500, BB28)","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,570,5.7,407.90707128999998,302.68367363000004,302.68367363000004,230.72728264999989,null,470,4.7,240.61087904999994,180.52809925000003,180.52809925000003,135.59871559985359,null,{"$f":"IF(BA29>1400, 1400, BA29)","v":0},{"$f":"IF(BB29>500, 500, BB29)","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,580,5.8,401.46026143999995,297.99052608000005,297.99052608000005,226.66939439999999,null,480,4.8,234.79481919999995,176.24766720000002,176.24766720000002,131.72821439984074,null,{"$f":"IF(BA30>1400, 1400, BA30)","v":0},{"$f":"IF(BB30>500, 500, BB30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","115 ph. applies as the lower threshold volume for a minor street approach with two or more lanes and ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,590,5.9,395.07682708999994,293.33216183000002,293.33216183000002,222.65922664999994,null,490,4.9000000000000004,229.11157164999997,172.02944504999999,172.02944504999999,127.91393879982706,null,{"$f":"IF(BA31>1400, 1400, BA31)","v":0},{"$f":"IF(BB31>500, 500, BB31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"80 mph applies as the lower threshold volume threshold for a minor street approach with one lane.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,6,388.75839999999999,288.70999999999998,288.70999999999998,218.69600000000003,null,500,5,223.56,167.875,167.875,124.1599999998125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,610,6.1,382.50653009000001,284.12541003000007,284.12541003000007,214.77899864999995,null,510,5.0999999999999996,218.13881785000001,163.78583565000002,163.78583565000002,120.47050919979705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,620,6.2,376.32268543999999,279.57971168000006,279.57971168000006,210.9075704,null,520,5.2,212.84658879999995,159.76339200000001,159.76339200000001,116.84957759978067]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,630,6.3,370.20825229000002,275.07417503000005,275.07417503000005,207.08112665000004,null,530,5.3,207.68172644999993,155.80904544999999,155.80904544999999,113.30131639976329]
[null,"70% Volume Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,640,6.4,364.16453503999992,270.61002048,270.61002048,203.29914239999994,null,540,5.4,202.64249439999986,151.9241088,151.9241088,109.8298367997449]
[null,"Four Highest Hours",null,null,"Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,650,6.5,358.19275625,266.18841874999998,266.18841874999998,199.56115624999995,null,550,5.5,197.72700624999999,148.10983124999996,148.10983124999996,106.43924999972546]
[null,null,null,null,"Major Street",null,null,"Minor Street",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660,6.6,352.29405664000006,261.81049088000009,261.81049088000009,195.86677039999995,null,560,5.6,192.93322560000001,144.36739840000001,144.36739840000001,103.13366719970497]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,670,6.7,346.46949509000007,257.47730823000006,257.47730823000006,192.21565064999999,null,570,5.7,188.25896604999997,140.69793225000001,140.69793225000001,99.917199599683329,null,"Inputs"]
[null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!B41>0),'Instructions & Input'!B41,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!C41>0),'Instructions & Input'!C41,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!D41>0),'Instructions & Input'!D41,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,680,6.8,340.72004864000002,253.18989248000008,253.18989248000008,188.60752639999998,null,580,5.8,183.70189119999998,137.10249120000003,137.10249120000003,96.793958399660482,null,{"$f":"SUM(E45)","v":0},{"$f":"SUM(H45)","v":0}]
[null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!B42>0),'Instructions & Input'!B42,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!C42>0),'Instructions & Input'!C42,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!D42>0),'Instructions & Input'!D42,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,690,6.9,335.04661249000003,248.94921563000003,248.94921563000003,185.04219064999995,null,590,5.9,179.25951464999991,133.58207004999997,133.58207004999997,93.768054799636474,null,{"$f":"SUM(E46)","v":0},{"$f":"SUM(H46)","v":0}]
[null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!B43>0),'Instructions & Input'!B43,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!C43>0),'Instructions & Input'!C43,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!D43>0),'Instructions & Input'!D43,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,7,329.45,244.75620000000004,244.75620000000004,181.51949999999999,null,600,6,174.92919999999992,130.13760000000002,130.13760000000002,90.843599999611172,null,{"$f":"SUM(E47)","v":0},{"$f":"SUM(H47)","v":0}]
[null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!B44>0),'Instructions & Input'!B44,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!C44>0),'Instructions & Input'!C44,\"\")","v":""},null,null,{"$f":"IF(($AK$33=TRUE)*AND('Instructions & Input'!D44>0),'Instructions & Input'!D44,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,710,7.1,323.93094268999994,240.61171823000006,240.61171823000006,178.03937465000001,null,610,6.1,170.7081608499999,126.76994864999995,126.76994864999995,88.024705199584616,null,{"$f":"SUM(E48)","v":0},{"$f":"SUM(H48)","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,720,7.2,318.49009024000003,236.51659328000005,236.51659328000005,174.60179839999989,null,620,6.2,166.5934608,123.47991999999994,123.47991999999994,85.315481599556676,null,"Graphed Points"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,730,7.3,313.12801049000007,232.47159843000009,232.47159843000009,171.20681864999995,null,630,6.3,162.58201344999998,120.26825444999997,120.26825444999997,82.720040399527392,null,{"$f":"IF(BA45>1000, 1000, BA45)","v":0},{"$f":"IF(BB45>400, 400, BB45)","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,740,7.4,307.84518943999996,228.47745728000007,228.47745728000007,167.8545464,null,640,6.4,158.67058239999994,117.13562879999995,117.13562879999995,80.242492799496631,null,{"$f":"IF(BA46>1000, 1000, BA46)","v":0},{"$f":"IF(BB46>400, 400, BB46)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","80 ph. applies as the lower threshold volume for a minor street approach with two or more lanes and ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,750,7.5,302.64203125000006,224.53484375000005,224.53484375000005,164.54515624999988,null,650,6.5,154.85578124999995,114.08265625000001,114.08265625000001,77.886949999464491,null,{"$f":"IF(BA47>1000, 1000, BA47)","v":0},{"$f":"IF(BB47>400, 400, BB47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"60 ph. applies as the lower threshold volume threshold for a minor street approach with one lane.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,760,7.6,297.51885823999999,220.64438208000001,220.64438208000001,161.27888639999992,null,660,6.6,151.13407360000002,111.10988639999999,111.10988639999999,75.657523199430813,null,{"$f":"IF(BA48>1000, 1000, BA48)","v":0},{"$f":"IF(BB48>400, 400, BB48)","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,770,7.7,292.47591089000002,216.80664683000003,216.80664683000003,158.05603865,null,670,6.7,147.50177304999988,108.21780525000003,108.21780525000003,73.558323599395464]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,780,7.8,287.51334784000016,213.02216288,213.02216288,154.87697839999993,null,680,6.8,143.95504319999992,105.40683520000005,105.40683520000005,71.5934623993586]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,790,7.9,282.63124589000006,209.29140543000005,209.29140543000005,151.74213464999985,null,690,6.9,140.48989764999999,102.67733505000001,102.67733505000001,69.767050799319946]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,8,277.82960000000008,205.61480000000006,205.61480000000006,148.65199999999993,null,700,7,137.10219999999993,100.02960000000007,100.02960000000007,68.083199999279714]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,810,8.1,273.10832329000004,201.99272242999996,201.99272242999996,145.60713064999999,null,710,7.1,133.78766384999994,97.463861650000013,97.463861650000013,66.546021199237629]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,820,8.1999999999999993,268.46724704000007,198.42549888000008,198.42549888000008,142.60814640000001,null,720,7.2,130.5418527999999,94.980287999999973,94.980287999999973,65.159625599193788]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,830,8.3000000000000007,263.90612068999997,194.91340582999999,194.91340582999999,139.6557306499999,null,730,7.3,127.36018045000003,92.57898345000001,92.57898345000001,63.928124399148032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,840,8.4,259.42461184000024,191.45667008000009,191.45667008000009,136.75063039999998,null,740,7.4,124.23791039999981,90.259988799999974,90.259988799999974,62.855628799100401]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,850,8.5,255.02230625000004,188.05546875000005,188.05546875000005,133.89365625000005,null,750,7.5,121.17015624999988,88.023281249999968,88.023281249999968,61.946249999050792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,860,8.6,250.69870784000011,184.70992927999998,184.70992927999998,131.0856824,null,760,7.6,118.15188159999991,85.868774400000007,85.868774400000007,61.204099198999131]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,870,8.6999999999999993,246.45323869000015,181.42012943000009,181.42012943000009,128.32764664999991,null,770,7.7,115.17790004999995,83.796318250000013,83.796318250000013,60.633287598945344]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,880,8.8000000000000007,242.28523904000008,178.18609728000001,178.18609728000001,125.62055039999996,null,780,7.8,112.24287519999996,81.805699199999992,81.805699199999992,60.237926398889556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,890,8.9,238.19396729000016,175.00781123000002,175.00781123000002,122.96545865000007,null,790,7.9,109.34132064999983,80,79.896640049999974,60.022126798831465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,9,234.17860000000007,171.88520000000005,171.88520000000005,120.36349999999993,null,800,8,106.46759999999995,80,78.06880000000001,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,910,9.1,230.23823189000018,168.81814263000007,168.81814263000007,117.81586664999986,null,810,8.1,103.61592684999994,80,76.321774650000009,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,920,9.1999999999999993,226.37187584000003,165.80646848000004,165.80646848000004,115.32381439999995,null,820,8.1999999999999993,100.78036479999992,80,74.655095999999958,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,930,9.3000000000000007,222.5784628900002,162.84995723000003,162.84995723000003,112.88866264999984,null,830,8.3000000000000007,97.954827449999925,80,73.068232449999982,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,940,9.4,218.85684224000011,159.94833888000005,159.94833888000005,110.51179439999999,null,840,8.4,95.133078400000045,80,71.560588800000005,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,950,9.5,215.20578125000009,157.10129375000002,157.10129375000002,108.19465624999987,null,850,8.5,92.308731249999937,80,70.131506249999916,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,960,9.6,211.62396544000023,154.30845248000014,154.30845248000014,105.93875839999993,null,860,8.6,89.475249599999984,80,68.780262400000026,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,9.6999999999999993,208.10999849000007,151.56939603000012,151.56939603000012,103.74567464999996,null,870,8.6999999999999993,86.625947049999922,80,67.506071249999991,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,980,9.8000000000000007,204.66240224000012,148.88365567999995,148.88365567999995,101.61704239999983,null,880,8.8000000000000007,83.75398719999987,80,66.308083199999999,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,990,9.9,201.27961669000013,146.2507130300001,146.2507130300001,99.554562649999866,null,890,8.9,80.852383649999865,80,65.185385049999979,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,10,197.96,143.66999999999999,143.66999999999999,97.559999999999832,null,900,9,80,80,64.137000000000057,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1010,10.1,194.70182849000025,141.14089883000014,141.14089883000014,95.635182649999706,null,910,9.1,80,80,63.16188765000004,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1020,10.199999999999999,191.50329664000003,138.66274208000004,138.66274208000004,93.78200240000001,null,920,9.1999999999999993,80,80,62.258943999999929,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1030,10.3,188.3625170900001,136.23481263000002,136.23481263000002,92.002414649999878,null,930,9.3000000000000007,80,80,61.427001450000091,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1040,10.4,185.27752064000026,133.85634368000024,133.85634368000024,90.298438400000123,null,940,9.4,80,80,60.664828800000066,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1050,10.5,182.24625624999999,131.52651875000004,131.52651875000004,88.672156250000171,null,950,9.5,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1060,10.6,179.26659103999998,129.24447168,129.24447168,87.125714399999879,null,960,9.6,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1070,10.7,176.33631029000014,127.00928663000008,127.00928663000008,85.661322649999761,null,970,9.6999999999999993,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1080,10.8,173.45311744000014,124.81999807999995,124.81999807999995,84.281254399999966,null,980,9.8000000000000007,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1090,10.9,170.6146340900001,122.67559082999998,122.67559082999998,82.987846649999938,null,990,9.9,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,11,167.81840000000022,120.575,120.575,81.783500000000004,null,1000,10,80,80,60,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1110,11.1,165.06187309000018,118.51711102999991,118.51711102999991,80.6706786499999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1120,11.2,162.34242944000016,116.50075967999999,116.50075967999999,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1130,11.3,159.65736329000003,115,114.52473203,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1140,11.4,157.00388704,115,112.58776447999992,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1150,11.5,154.37913125000034,115,110.68854375000018,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1160,11.6,151.78014464,115,108.82570688000004,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1170,11.7,149.2038940900004,115,106.99784123000006,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1180,11.8,146.64726464000034,115,105.20348447999999,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1190,11.9,144.10705948999987,115,103.44112462999988,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200,12,141.58000000000001,115,101.7091999999999,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1210,12.1,139.06272569000021,115,100.0060992299999,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1220,12.2,136.55179424000016,115,98.330161280000141,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1230,12.3,134.04368149000038,115,96.679675429999975,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1240,12.4,131.53478144000019,115,95.052881279999895,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1250,12.5,129.02140625000015,115,93.44796875000003,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1260,12.6,126.49978624000039,115,91.863078080000037,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1270,12.7,123.96606989000031,115,90.29629983000018,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1280,12.8,121.41632384000013,115,88.745674879999797,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1290,12.9,118.84653289000028,115,87.209194430000025,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300,13,116.25260000000037,115,85.684799999999882,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1310,13.1,115,115,84.170383430000186,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1320,13.2,115,115,82.663786880000259,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1330,13.3,115,115,81.162802830000089,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340,13.4,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1350,13.5,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1360,13.6,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1370,13.7,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1380,13.8,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1390,13.9,115,115,80,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400,14,115,115,80,80]

{"sheet":"Chapter 3 Warrant 3","index":4,"n_rows":147,"n_cols":53,"rows_kept":147,"cut":false,"hidden":false,"merged":[[1,0,1,35],[2,0,2,35],[4,5,4,14],[5,5,5,14],[6,5,6,14],[4,24,4,34],[5,24,5,34],[36,1,36,3],[36,4,36,6],[36,7,36,9],[25,1,25,9],[26,1,26,9],[32,1,32,3],[32,4,32,6],[32,7,32,9],[27,1,29,9],[23,11,23,34],[8,5,8,19],[8,23,8,24],[33,1,33,3],[33,4,33,6],[33,7,33,9],[31,1,31,9],[21,2,22,23],[23,1,24,9],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[11,13,11,26],[59,1,59,3],[58,6,58,7],[35,1,35,9],[37,1,37,3],[37,4,37,6],[37,7,37,9],[45,1,45,3],[43,6,43,7],[43,8,43,9],[44,6,44,7],[44,8,44,9],[40,1,40,9],[41,1,41,9],[58,8,58,9],[58,1,58,5],[57,1,57,5],[57,8,57,9],[51,6,51,7],[51,8,51,9],[54,1,54,9],[55,1,55,9],[57,6,57,7],[56,1,56,5],[56,6,56,7],[56,8,56,9],[51,1,51,5],[52,1,52,3],[42,1,42,5],[42,6,42,7],[42,8,42,9],[50,8,50,9],[49,1,49,5],[49,6,49,7],[49,8,49,9],[47,1,47,9],[48,1,48,9],[50,1,50,5],[50,6,50,7],[44,1,44,5]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4C-3 (FIGURE A VALUES)",null,null,null,null,null,null,"4C-4 (FIGURE B VALUES)"]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Major ",null,"2 or More","1 Lane","2 or More","1 Lane",null,"Major ",null,"2 or More","1 Lane","2 or More","1 Lane"]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor",null,"2 or More","2 or More","1 Lane","1 Lane",null,"Minor",null,"2 or More","2 or More","1 Lane","1 Lane"]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","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,"X","X trend","Y1","Y2","Y3","Y4",null,"X","X trend","Y1","Y2","Y3","Y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,4,null,null,null,null,null,300,3]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0},null,null,{"$f":"IF(Major_Approach_Speed>40,TRUE,FALSE)","v":false},null,410,4.0999999999999996,null,null,null,null,null,310,3.1]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0},null,null,{"$f":"IF(Major_Approach_Speed<41,TRUE,FALSE)","v":true},null,420,4.2,null,null,null,null,null,320,3.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,430,4.3,null,null,null,452.19328529998972,null,330,3.3,null,null,null,317.25611938999998]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,440,4.4000000000000004,null,null,null,447.17730559998881,null,340,3.4,null,null,null,310.15692544000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,450,4.5,null,null,null,442.17948749998777,null,350,3.5,null,null,null,303.21359374999997]
[null,"Volume Level Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,460,4.5999999999999996,null,null,null,437.20025039998666,null,360,3.6,null,370.37786368000002,370.37786368000002,296.42321984]
[null,null,"1.  Is the posted speed or 85th-percentile of major street > 40 mph?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK16=TRUE,AK15=TRUE),1,0)","v":0},470,4.7,null,null,null,432.24001369998541,null,370,3.7,null,363.37211038000004,363.37211038000004,289.78294459]
[null,null,"2.  Is the intersection in a built-up area of an isolated community with a  population < 10,000?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,480,4.8,null,null,null,427.29919679998409,null,380,3.8,null,356.5142580800001,356.5142580800001,283.28995424000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,490,4.9000000000000004,null,null,null,422.37821909998274,null,390,3.9,null,349.80072658000006,349.80072658000006,276.94148038999992]
[null,null,"\"70%\" volume level may be used if Question 1 or 2 above is answered \"Yes\"",null,null,null,null,null,null,null,null,null,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((OR(AK15,AK9)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(AK18=TRUE,1,0)","v":0},500,5,null,null,null,417.47749999998126,null,400,4,null,343.22800000000007,343.22800000000007,270.73479999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK19=TRUE,1,0)","v":0},510,5.0999999999999996,null,504.02744390000004,504.02744390000004,412.59745889997976,null,410,4.0999999999999996,null,336.79262678000009,336.79262678000009,264.66723538999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,520,5.2,null,499.21537920000003,499.21537920000003,407.73851519997805,null,420,4.2,null,330.49121967999997,330.49121967999997,258.73615423999991]
[null,"WARRANT 3 - PEAK HOUR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,530,5.3,null,494.39779329999999,494.39779329999999,402.90108829997638,null,430,4.3,413.94037305000001,324.32045578000009,324.32045578000009,252.93896958999994]
[null,null,"If all three criteria are fulfilled or the plotted point lies above the appropriate line, then the warrant is satisfied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK21=TRUE,AK20=TRUE),1,0)","v":0},540,5.4,null,489.57614960000001,489.57614960000001,398.08559759997445,null,440,4.4000000000000004,407.02634880000005,318.27707648000001,318.27707648000001,247.27313983999989]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK23=TRUE,AK22=TRUE),1,0)","v":0},550,5.5,null,484.75188750000001,484.75188750000001,393.2924624999726,null,450,4.5,400.23253125000008,312.3578875,312.3578875,241.73616874999999]
[null,"Unusual condition justifying use of warrant:",null,null,null,null,null,null,null,null,null,"Plot volume combination on the applicable figure below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,560,5.6,null,479.92642240000004,479.92642240000004,388.52210239997049,null,460,4.5999999999999996,393.55505280000006,306.55975888000012,306.55975888000012,236.32560544]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,570,5.7,null,475.10114569999996,475.10114569999996,383.77493669996835,null,470,4.7,386.99015505000006,300.87962498000013,300.87962498000013,231.03904439000002]
[null,"Industrial Complex",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,580,5.8,null,470.27742480000001,470.27742480000001,379.05138479996612,null,480,4.8,380.53418880000015,295.31448448000003,295.31448448000003,225.87412543999994]
[null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,590,5.9,null,465.4566031,465.4566031,374.35186609996367,null,490,4.9000000000000004,374.18361405000007,289.86140038000002,289.86140038000002,220.82853378999994]
[null,"Record hour when criteria are fulfilled and the corresponding delay or volume in boxes provided.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,6,593.28800000000001,460.64,460.64,369.67679999996119,null,500,5,367.935,284.51749999999998,284.51749999999998,215.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,610,6.1,587.04409360000011,455.82891090000004,455.82891090000004,365.0266058999585,null,510,5.0999999999999996,361.78502505000006,279.27997498000013,279.27997498000013,211.08629998999999,"100% Volume Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,620,6.2,580.84494480000001,451.02460719999999,451.02460719999999,360.4017031999557,null,520,5.2,355.73047679999991,274.14608127999998,274.14608127999998,206.38525503999989,"Inputs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,630,6.3,574.69009820000008,446.22833630000002,446.22833630000002,355.80251129995276,null,530,5.3,349.76825205000011,269.11313918000008,269.11313918000008,201.79473179000007,{"$f":"SUM(E34)","v":0},{"$f":"SUM(H34)","v":0}]
[null,"Peak Hour 100% Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,640,6.4,568.57911039999999,441.44132159999998,441.44132159999998,351.2294495999497,null,540,5.4,343.89535680000006,264.17853328000001,264.17853328000001,197.31264223999995,"Points to be graphed"]
[null,"Time",null,null,"Major Vol.",null,null,"Minor Vol.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK33=TRUE,1,0)","v":0},650,6.5,562.51155000000006,436.66476250000005,436.66476250000005,346.68293749994649,null,550,5.5,338.10890625000002,259.33971250000008,259.33971250000008,192.93694374999995,{"$f":"IF(AZ31>1800, 1800, AZ31)","v":0},{"$f":"IF(BA31>600, 600, BA31)","v":0}]
[null,{"$f":"IF(AK19=TRUE,IF('Instructions & Input'!B48>0,'Instructions & Input'!B48,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$19=TRUE,IF('Instructions & Input'!C48>0,'Instructions & Input'!C48,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$19=TRUE,IF('Instructions & Input'!D48>0,'Instructions & Input'!D48,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660,6.6,556.4869976,431.89983440000003,431.89983440000003,342.16339439994312,null,560,5.6,332.40612480000004,254.59419008000009,254.59419008000009,188.66563904000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,670,6.7,550.50504580000006,427.1476887,427.1476887,337.67123969993958,null,570,5.7,326.78434605000007,249.93954358000002,249.93954358000002,184.49677618999993]
[null,"Peak Hour 70% Volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,680,6.8,544.56529920000003,422.40945280000005,422.40945280000005,333.20689279993587,null,580,5.8,321.24101280000002,245.3734148800001,245.3734148800001,180.42844863999994,"70% Volume Level"]
[null,"Time",null,null,"Major Vol.",null,null,"Minor Vol.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,690,6.9,538.66737440000009,417.68623009999999,417.68623009999999,328.770773099932,null,590,5.9,315.77367705000017,240.89351018000013,240.89351018000013,176.45879518999993,"Inputs"]
[null,{"$f":"IF($AK$33=TRUE,IF('Instructions & Input'!B48>0,'Instructions & Input'!B48,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$33=TRUE,IF('Instructions & Input'!C48>0,'Instructions & Input'!C48,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$33=TRUE,IF('Instructions & Input'!D48>0,'Instructions & Input'!D48,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,7,532.81090000000006,412.97910000000002,412.97910000000002,324.36329999992796,null,600,6,310.38,236.49760000000003,236.49760000000003,172.58600000000001,{"$f":"SUM(E38)","v":0},{"$f":"SUM(H38)","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,710,7.1,526.99551660000009,408.28911790000001,408.28911790000001,319.98489289992381,null,610,6.1,305.05775204999998,232.18351917999996,232.18351917999996,168.80829259000006,"Points to be graphed"]
[null,null,null,null,null,"Criteria",null,null,null,null,null,null,"* Note:","150 vph applies as the lower threshold volume for a minor street approach with two or more lanes and  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,720,7.2,521.22087680000004,403.61731520000001,403.61731520000001,315.63597119991942,null,620,6.2,299.80481280000015,227.94916688000001,227.94916688000001,165.12394784000003,{"$f":"IF(AZ38>1300, 1300, AZ38)","v":0},{"$f":"IF(BA38>500, 500, BA38)","v":0}]
[null,"1.  Delay on Minor Approach",null,null,null,null,null,null,null,null,null,null,null,"100 vph applies as the lower threshold volume threshold for a minor street approach with one lane.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,730,7.3,515.48664520000011,398.96469930000006,398.96469930000006,311.31695429991487,null,630,6.3,294.6191710500002,223.79250658000001,223.79250658000001,161.53128599000001]
[null,"*(vehicle-hours)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,740,7.4,509.79249840000011,394.33225359999994,394.33225359999994,307.02826159991008,null,640,6.4,289.49892480000005,219.71156608000001,219.71156608000001,158.02867264000002]
[null,"Approach Lanes",null,null,null,null,1,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,750,7.5,504.13812500000017,389.72093749999999,389.72093749999999,302.77031249990512,null,650,6.5,284.44228125000006,215.70443749999993,215.70443749999993,154.61451874999995]
[null,"Delay Criteria*",null,null,null,null,4,null,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,false,{"$f":"IF(OR(AK45=TRUE,AK44=TRUE),1,0)","v":0},760,7.6,498.52322560000016,385.13168640000004,385.13168640000004,298.54352639989997,null,660,6.6,279.44755680000003,211.7692772800001,211.7692772800001,151.28728063999995]
[null,"Delay*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"SUM(G45:J45)","v":0},770,7.7,492.94751280000014,380.56541170000003,380.56541170000003,294.34832269989454,null,670,6.7,274.51317705000008,207.90430617999994,207.90430617999994,148.04545998999981]
[null,"Fulfilled?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,780,7.8,487.41071120000004,376.02300080000009,376.02300080000009,290.18512079988898,null,680,6.8,269.63767679999989,204.10780927999997,204.10780927999997,144.88760384]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,790,7.9,481.91255740000008,371.50531709999996,371.50531709999996,286.05434009988318,null,690,6.9,264.81970005000005,200.37813598000002,200.37813598000002,141.81230459000005]
[null,"2.  Volume on Minor Approach",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,8,476.45280000000002,367.01319999999998,367.01319999999998,281.95639999987714,null,700,7,260.05799999999988,196.71370000000013,196.71370000000013,138.81819999999993]
[null,"One-Direction *(vehicles per hour)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,810,8.1,471.03119960000004,362.54746489999997,362.54746489999997,277.89171989987085,null,710,7.1,255.35143905000007,193.11297937999996,193.11297937999996,135.9039731900001]
[null,"Approach Lanes",null,null,null,null,1,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,820,8.1999999999999993,465.64752880000015,358.10890319999999,358.10890319999999,273.86071919986443,null,720,7.2,250.69898880000005,189.57451647999994,189.57451647999994,133.06835263999994]
[null,"Volume Criteria*",null,null,null,null,100,null,150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,830,8.3000000000000007,460.30157220000001,353.69828230000002,353.69828230000002,269.86381729985766,null,730,7.3,246.09973004999995,186.09691798000006,186.09691798000006,130.31011219000004]
[null,"Volume*",null,null,null,null,null,null,null,null,null,null,null,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(G52:J52)","v":0},840,8.4,454.99312639999994,349.31634560000003,349.31634560000003,265.90143359985063,null,740,7.4,241.5528528000001,182.67885488000002,182.67885488000002,127.62807104000012]
[null,"Fulfilled?:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK54=TRUE,AK53=TRUE),1,0)","v":0},850,8.5,449.72199999999998,344.96381250000002,344.96381250000002,261.97398749984342,null,750,7.5,237.05765624999992,179.31906250000009,179.31906250000009,125.02109374999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,860,8.6,444.48801360000016,340.64137840000006,340.64137840000006,258.08189839983595,null,760,7.6,232.61354880000033,176.01634048000017,176.01634048000017,122.48809024000013]
[null,"3.  Total Intersection Entering",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,870,8.6999999999999993,439.29099980000001,336.34971470000011,336.34971470000011,254.22558569982823,null,770,7.7,228.22004805000017,172.76955278000025,172.76955278000025,120.02801578999981]
[null,"Volume *(vehicles per hour)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,880,8.8000000000000007,434.13080319999995,332.08946880000008,332.08946880000008,250.40546879982014,null,780,7.8,223.87678080000012,169.57762767999998,169.57762767999998,117.63987103999978]
[null,"No. of Approaches",null,null,null,null,3,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,890,8.9,429.00728040000001,327.86126409999997,327.86126409999997,246.6219670998118,null,790,7.9,219.58348305000015,166.43955777999986,166.43955777999986,115.32270199000004]
[null,"Volume Criteria*",null,null,null,null,650,null,800,null,null,null,null,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(G59:J59)","v":0},900,9,423.92030000000011,323.66570000000002,323.66570000000002,242.87549999980325,null,800,8,215.34,163.35440000000006,163.35440000000006,113.07560000000001]
[null,"Volume*",null,null,null,null,null,null,null,null,null,null,"* Note:","100 ph. applies as the lower threshold volume for a minor street approach with two or more lanes and  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK60=TRUE,AK59=TRUE),1,0)","v":0},910,9.1,418.8697426,319.5033519000001,319.5033519000001,239.16648689979434,null,810,8.1,211.14628605000007,160.32127558000036,160.32127558000036,110.89770179000004]
[null,"Fulfilled?:",null,null,null,null,null,null,null,null,null,null,null,"75 phi applies as the lower threshold volume threshold for a minor street approach with one lane.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,920,9.1999999999999993,413.85550080000007,315.37477120000005,315.37477120000005,235.49534719978516,null,820,8.1999999999999993,207.00240480000014,157.33937008000009,157.33937008000009,108.78818944]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,930,9.3000000000000007,408.87747919999993,311.28048530000007,311.28048530000007,231.86250029977555,null,830,8.3000000000000007,202.90852905000031,154.40793338000015,154.40793338000015,106.7462903899999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,970,9.6999999999999993,389.32610680000016,295.25599770000008,295.25599770000008,217.72242869973451,null,870,8.6999999999999993,187.04035905000001,143.17412337999997,143.17412337999997,99.240963589999865]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,980,9.8000000000000007,384.52817520000008,291.34025680000002,291.34025680000002,214.28733679972333,null,880,8.8000000000000007,183.20292480000001,140.48603007999986,140.48603007999986,97.527130239999792]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,990,9.9,379.76614339999992,287.46147110000004,287.46147110000004,210.89305409971178,null,890,8.9,179.41882605000023,137.8452555800003,137.8452555800003,95.87722739000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,10,375.04,283.62,283.62,207.53999999970006,null,900,9,175.68900000000019,135.25149999999985,135.25149999999985,94.290800000000104]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1010,10.1,370.34974560000001,279.81617890000007,279.81617890000007,204.22859389968789,null,910,9.1,172.01449305000017,132.70452778000015,132.70452778000015,92.767438389999825]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1020,10.199999999999999,365.69539280000015,276.0503192000001,276.0503192000001,200.9592551996754,null,920,9.1999999999999993,168.39646080000023,130.20416768000018,130.20416768000018,91.306778239999858]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1030,10.3,361.07696620000013,272.32270830000004,272.32270830000004,197.73240329966245,null,930,9.3000000000000007,164.83616805000008,127.75031277999983,127.75031277999983,89.908500590000017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1040,10.4,356.49450239999999,268.63360960000011,268.63360960000011,194.54845759964905,null,940,9.4,161.33498880000013,125.34292048000032,125.34292048000032,88.572331840000061]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1050,10.5,351.94804999999997,264.98326250000008,264.98326250000008,191.40783749963538,null,950,9.5,157.89440624999997,122.9820125,122.9820125,87.29804374999992]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1060,10.6,347.43766960000016,261.3718824,261.3718824,188.3109623996213,27,960,9.6,154.51601280000034,120.66767488000005,120.66767488000005,86.085453439999924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1070,10.7,342.96343380000019,257.7996607,257.7996607,185.25825169960689,25,970,9.6999999999999993,151.20151005000025,118.40005798000016,118.40005798000016,84.934423389999893]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1080,10.8,338.52542719999997,254.26676480000003,254.26676480000003,182.25012479959184,37,980,9.8000000000000007,147.9527088000001,116.17937647999997,116.17937647999997,83.844861440000045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1090,10.9,334.12374640000007,250.77333809999993,250.77333809999993,179.28700109957651,48,990,9.9,144.77152905000014,114.00590938000016,114.00590938000016,82.816720789999863]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,11,329.75850000000014,247.31950000000006,247.31950000000006,176.36929999956084,null,1000,10,141.66,111.88,111.88,81.849999999999909]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1110,11.1,325.42980860000034,243.90534590000004,243.90534590000004,173.4974408995447,null,1010,10.1,138.62026004999996,109.80205598000009,109.80205598000009,80.944742989999895]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1120,11.2,321.13780480000003,240.53094720000013,240.53094720000013,170.67184319952798,null,1020,10.199999999999999,135.65455680000002,107.77254928000013,107.77254928000013,80.101039040000046]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1130,11.3,316.8826332000001,237.1963513,237.1963513,167.89292629951086,null,1030,10.3,132.76524704999986,105.79201617999991,105.79201617999991,79.319022789999849]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1140,11.4,312.66445040000008,233.90158159999999,233.90158159999999,165.16110959949333,null,1040,10.4,129.9547967999996,103.86105727999973,103.86105727999973,78.598874239999759]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1150,11.5,308.48342500000012,230.6466375,230.6466375,162.47681249947539,null,1050,10.5,127.2257812500003,101.98033750000013,101.98033750000013,77.940818749999949]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1160,11.6,304.33973760000003,227.43149440000008,227.43149440000008,159.84045439945692,null,1060,10.6,124.58088480000026,100.15058608000015,100.15058608000015,77.345127040000193]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1170,11.7,300.23358080000003,224.25610370000004,224.25610370000004,157.25245469943786,null,1070,10.7,122.02290105000009,100,98.372596580000049,76.812115189999986]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1180,11.8,296.16515920000006,221.1203928000001,221.1203928000001,154.71323279941839,null,1080,10.8,119.55473280000035,100,96.647226879999948,76.342144639999901]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1190,11.9,292.1346894000003,218.02426509999998,218.02426509999998,152.22320809939845,null,1090,10.9,117.17939205000005,100,94.975399179999954,75.935622190000117]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200,12,288.14240000000007,214.9676,214.9676,149.78279999937797,null,1100,11,114.9,100,93.358100000000036,75.592999999999961]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1210,12.1,284.18853160000015,211.95025290000012,211.95025290000012,147.3924278993569,null,1110,11.1,112.71978705000026,100,91.796380179999801,75.31477558999984]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1220,12.2,280.27333680000015,208.9720552,208.9720552,145.05251119933541,null,1120,11.2,110.64209280000011,100,90.291354880000085,75.101491840000222]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1230,12.3,276.39708020000012,206.03281430000004,206.03281430000004,142.76346929931333,null,1130,11.3,108.67036604999987,100,88.844203580000226,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1240,12.4,272.56003839999994,203.13231359999986,203.13231359999986,140.52572159929082,null,1140,11.4,106.8081648000001,100,87.456170080000106,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1250,12.5,268.76249999999999,200.27031250000005,200.27031250000005,138.3396874992676,null,1150,11.5,105.05915625000023,100,86.128562500000157,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1260,12.6,265.00476560000016,197.44654639999999,197.44654639999999,136.20578639924395,null,1160,11.6,103.42711680000014,100,84.862753279999993,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1270,12.7,261.28714779999996,194.66072670000005,194.66072670000005,134.12443769921958,null,1170,11.7,101.91593204999992,100,83.660179179999773,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1280,12.8,257.60997120000002,191.91254079999987,191.91254079999987,132.09606079919479,null,1180,11.8,100.52959680000038,100,82.522341280000205,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1290,12.9,253.97357239999997,189.2016521000001,189.2016521000001,130.12107509916927,null,1190,11.9,100,100,81.450804980000498,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300,13,250.37830000000008,186.5277000000001,186.5277000000001,128.19989999914321,null,1200,12,100,100,80.447199999999953,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1310,13.1,246.82451459999993,183.89029990000017,183.89029990000017,126.33295489911654,null,1210,12.1,100,100,79.513220380000234,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1320,13.2,243.31258880000007,181.28904320000015,181.28904320000015,124.52065919908932,null,1220,12.2,100,100,78.650624479999692,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1330,13.3,239.84290720000013,178.72349729999996,178.72349729999996,122.76343229906126,null,1230,12.3,100,100,77.861234979999949,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1340,13.4,236.41586640000003,176.19320560000006,176.19320560000006,121.06169359903276,null,1240,12.4,100,100,77.146938879999766,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1350,13.5,233.03187500000001,173.69768750000003,173.69768750000003,119.41586249900354,null,1250,12.5,100,100,76.509687499999998,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1360,13.6,229.69135359999996,171.23643840000022,171.23643840000022,117.82635839897375,null,1260,12.6,100,100,75.951496479999946,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1370,13.7,226.39473480000004,168.80892970000025,168.80892970000025,116.29360069894324,null,1270,12.7,100,100,75.47444578000011,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1380,13.8,223.14246320000018,166.41460880000011,166.41460880000011,114.81800879891205,null,1280,12.8,100,100,75.080679679999889,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1390,13.9,219.93499539999993,164.0528991000001,164.0528991000001,113.40000209888024,null,1290,12.9,100,100,75,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400,14,216.77280000000007,161.72320000000013,161.72320000000013,112.03999999884752,null,1300,13,100,100,75,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1410,14.1,213.65635760000009,159.42488690000005,159.42488690000005,110.73842189881429]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1420,14.2,210.58616080000024,157.15731119999987,157.15731119999987,109.49568719878027]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1430,14.3,207.56271419999996,154.91980030000036,154.91980030000036,108.31221529874563]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1440,14.4,204.58653440000001,152.71165760000008,152.71165760000008,107.18842559871018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1450,14.5,201.65815000000009,150.53216249999991,150.53216249999991,106.12473749867388]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1460,14.6,198.77810160000024,150,148.38057040000024,105.121570398637]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1470,14.7,195.94694179999988,150,146.25611270000013,104.17934369859927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1480,14.8,193.1652352000001,150,144.15799679999986,103.29847679856073]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1490,14.9,190.43355840000004,150,142.08540610000023,102.47938909852144]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500,15,187.7525,150,140.03749999999999,101.72249999848134]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1510,15.1,185.12266060000002,150,138.01341389999993,101.02822889844037]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1520,15.2,182.54465280000022,150,136.01225920000002,100.39699519839871]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1530,15.3,180.01910120000002,150,134.03312329999994,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1540,15.4,177.54664240000034,150,132.07506960000012,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1550,15.5,175.127925,150,130.13713750000022,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1560,15.6,172.76360959999988,150,128.21834240000021,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1570,15.7,170.45436880000011,150,126.31767570000034,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1580,15.8,168.20088720000012,150,124.43410480000011,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1590,15.9,166.00386140000001,150,122.56657309999991,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1600,16,163.86400000000003,150,120.71400000000017,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1610,16.100000000000001,161.78202359999989,150,118.87528090000001,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1620,16.2,159.75866480000036,150,117.04928719999987,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1630,16.3,157.79466819999993,150,115.23486630000014,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1640,16.399999999999999,155.89079040000024,150,113.43084160000012,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1650,16.5,154.04780000000028,150,111.63601250000011,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1660,16.600000000000001,152.26647760000026,150,109.84915440000009,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1670,16.7,150.5476157999999,150,108.06901870000047,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1680,16.8,150,150,106.29433280000012,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1690,16.899999999999999,150,150,104.52380010000036,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1700,17,150,150,102.75610000000017,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1710,17.100000000000001,150,150,100.98988790000033,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1720,17.2,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1730,17.3,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1740,17.399999999999999,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1750,17.5,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1760,17.600000000000001,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1770,17.7,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1780,17.8,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1790,17.899999999999999,150,150,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800,18,150,150,100,100]

{"sheet":"Chapter 3 Warrant 4","index":5,"n_rows":97,"n_cols":45,"rows_kept":97,"cut":false,"hidden":false,"merged":[[55,11,56,35],[96,11,97,35],[48,1,48,3],[48,4,48,6],[48,7,48,9],[49,1,49,3],[49,4,49,6],[49,7,49,9],[86,1,86,3],[86,7,86,9],[86,4,86,6],[50,7,50,9],[51,4,51,6],[51,7,51,9],[50,4,50,6],[31,1,31,9],[32,4,32,9],[33,7,34,9],[33,4,34,6],[32,1,34,3],[45,1,47,3],[45,4,45,9],[46,4,47,6],[46,7,47,9],[44,1,44,9],[27,2,28,23],[62,2,63,23],[71,4,71,6],[71,1,71,3],[84,7,85,9],[84,4,85,6],[83,4,83,9],[83,1,85,3],[82,1,82,9],[69,7,70,9],[69,4,70,6],[68,4,68,9],[68,1,70,3],[71,7,71,9],[50,1,50,3],[51,1,51,3],[8,5,8,19],[4,5,4,14],[36,4,36,6],[6,5,6,14],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[11,12,11,25],[29,11,29,35],[30,11,30,35],[21,2,23,26],[35,1,35,3],[35,7,35,9],[35,4,35,6],[31,11,31,35],[1,0,1,35],[4,24,4,34],[5,5,5,14],[5,24,5,34],[67,1,67,9],[65,13,65,35],[36,1,36,3],[37,1,37,3],[38,1,38,3],[36,7,36,9],[37,4,37,6],[37,7,37,9],[38,4,38,6],[38,7,38,9],[2,0,2,35],[8,23,8,24]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 4C-5",null,0.5,0.8]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","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,1400,107,{"$f":"IF($AK$22=TRUE,AN7/2,-100)","v":-100},{"$f":"AN7*0.8","v":85.600000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300,107,{"$f":"IF($AK$22=TRUE,AN8/2,-100)","v":-100},{"$f":"AN8*0.8","v":85.600000000000009}]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0},null,null,{"$f":"IF(Major_Approach_Speed>35,TRUE,FALSE)","v":false},null,1200,107,-100,85.600000000000009]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0},null,null,{"$f":"IF(Major_Approach_Speed<36,TRUE,FALSE)","v":true},null,1100,107,-100,85.600000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,126,-100,100.80000000000001]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,160,-100,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,196,-100,156.80000000000001]
[null,"Volume Level Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,236,-100,188.8]
[null,null,"1.  Is the posted speed or 85th-percentile of major street > 35 mph?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK16=TRUE,AK15=TRUE),1,0)","v":0},600,292,-100,233.60000000000002]
[null,null,"2.  Is the intersection in a built-up area of an isolated community with a  population < 10,000?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,500,348,-100,278.40000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,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((OR(AK15,AK9)=TRUE),TRUE,FALSE)","v":false},{"$f":"IF(AK17=TRUE,1,0)","v":0},400,416,-100,332.8]
[null,null,"\"70%\" volume level may be used if Question 1 or 2 above is answered \"Yes\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK18=TRUE,1,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,"Warrant 4"]
[]
[null,"Option"]
[null,null,"Pedestrian volume crossing the major street may be reduced as much as 50% if the 15th-percentile crossing speed of pedestrians is less than 3.5 ft/sec. A walking speed study was conducted which reported a pedestrian speed less than 3.5 ft/sec for the 15th percentile.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK23=TRUE,AK22=TRUE),1,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,false]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK27=TRUE,AK26=TRUE),1,0)","v":0}]
[null,"WARRANT 4 - PEDESTRIAN VOLUME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,"Not Applicable",{"$f":"IF(AND(AK27,AK63=TRUE),TRUE,FALSE)","v":false}]
[null,null,"For each of any 4 hours of an average day, the plotted points lie above the appropriate line, then the warrant is satisfied.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK29=TRUE,AK28=TRUE),1,0)","v":0},null,null,null,null," Met",{"$f":"IF(OR(AK28,AK64=TRUE),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:",null,null,null,null,null,null,null,null,false,null,null,null,null,null,"Not Met",{"$f":"IF(AND(AK29,AK65=TRUE),TRUE,FALSE)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,"Plot four volume combinations on the applicable figure below."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 4C-6"]
[null,"100% Volume Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,75,{"$f":"IF($AK$22=TRUE,AN32/2,-100)","v":-100}]
[null,"Four Highest Hours",null,null,"Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,75,-100]
[null,null,null,null,"Major Street",null,null,"Pedestrian Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,75,-100,"100% Volume Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,90,-100,"Inputs",null,"Points to be graphed"]
[null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!G41>0,'Instructions & Input'!G41,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!H41>0,'Instructions & Input'!H41,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!I41>0,'Instructions & Input'!I41,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,122,-100,{"$f":"SUM(E36)","v":0},{"$f":"SUM(H36)","v":0},{"$f":"IF(AP36>1400, 1400, AP36)","v":0},{"$f":"IF(AQ36>500, 500, AQ36)","v":0}]
[null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!G42>0,'Instructions & Input'!G42,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!H42>0,'Instructions & Input'!H42,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!I42>0,'Instructions & Input'!I42,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,163,-100,{"$f":"SUM(E37)","v":0},{"$f":"SUM(H37)","v":0},{"$f":"IF(AP37>1400, 1400, AP37)","v":0},{"$f":"IF(AQ37>500, 500, AQ37)","v":0}]
[null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!G43>0,'Instructions & Input'!G43,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!H43>0,'Instructions & Input'!H43,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!I43>0,'Instructions & Input'!I43,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,214,-100,{"$f":"SUM(E38)","v":0},{"$f":"SUM(H38)","v":0},{"$f":"IF(AP38>1400, 1400, AP38)","v":0},{"$f":"IF(AQ38>500, 500, AQ38)","v":0}]
[null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!G43>0,'Instructions & Input'!G43,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!H44>0,'Instructions & Input'!H44,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!I44>0,'Instructions & Input'!I44,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(AK39=TRUE,1,0)","v":0},300,269,-100,{"$f":"SUM(E39)","v":0},{"$f":"SUM(H39)","v":0},{"$f":"IF(AP39>1400, 1400, AP39)","v":0},{"$f":"IF(AQ39>500, 500, AQ39)","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,267,287,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","107 pph applies as the lower threshold volume for 100% volume level "]
[]
[]
[]
[null,"70% Volume Level"]
[null,"Four Highest Hours",null,null,"Volumes"]
[null,null,null,null,"Major Street",null,null,"Pedestrian Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"70% Volume Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inputs",null,"Points to be graphed"]
[null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!G41>0,'Instructions & Input'!G41,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!H41>0,'Instructions & Input'!H41,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!I41>0,'Instructions & Input'!I41,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,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(E49)","v":0},{"$f":"SUM(H49)","v":0},{"$f":"IF(AP49>1000, 1000, AP49)","v":0},{"$f":"IF(AQ49>400, 400, AQ49)","v":0}]
[null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!G42>0,'Instructions & Input'!G42,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!H42>0,'Instructions & Input'!H42,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!I42>0,'Instructions & Input'!I42,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,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(E50)","v":0},{"$f":"SUM(H50)","v":0},{"$f":"IF(AP50>1000, 1000, AP50)","v":0},{"$f":"IF(AQ50>400, 400, AQ50)","v":0}]
[null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!G43>0,'Instructions & Input'!G43,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!H43>0,'Instructions & Input'!H43,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!I43>0,'Instructions & Input'!I43,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,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(E51)","v":0},{"$f":"SUM(H51)","v":0},{"$f":"IF(AP51>1000, 1000, AP51)","v":0},{"$f":"IF(AQ51>400, 400, AQ51)","v":0}]
[null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!G44>0,'Instructions & Input'!G44,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!H44>0,'Instructions & Input'!H44,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$39=TRUE,IF('Instructions & Input'!I44>0,'Instructions & Input'!I44,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,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(E52)","v":0},{"$f":"SUM(H52)","v":0},{"$f":"IF(AP52>1000, 1000, AP52)","v":0},{"$f":"IF(AQ52>400, 400, AQ52)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","75 pph applies as the lower threshold volume for 70% volume level"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$22=TRUE,\"50% volume threshold may be used with the support of a walking speed study reporting 15th-percentile crossing speed less than 3.5 ft/sec. Refer to MUTS Chapter 9 for additional guidance on how to conduct a walking speed study.\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,"WARRANT 4 - PEDESTRIAN VOLUME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK63=TRUE,AK62=TRUE),1,0)","v":0}]
[null,null,"For 1 hour (any four consecutive 15-minute periods) of an average day, the plotted point falls above the appropriate line, then the warrant is satisfied. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK65=TRUE,AK64=TRUE),1,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,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Plot one volume combination on the applicable figure below."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1800,133,{"$f":"IF($AK$22=TRUE,AN67/2,-100)","v":-100}]
[null,"100% Volume Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1700,133,-100]
[null,"Peak Hour",null,null,"Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1600,133,-100]
[null,null,null,null,"Major Street",null,null,"Pedestrian Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500,133,-100,"100% Volume Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400,150,-100,"Inputs",null,"Points to be graphed"]
[null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!B52>0,'Instructions & Input'!B52,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!C52>0,'Instructions & Input'!C52,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$18=TRUE,IF('Instructions & Input'!D52>0,'Instructions & Input'!D52,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300,175,-100,{"$f":"SUM(E72)","v":0},{"$f":"SUM(H72)","v":0},{"$f":"IF(AP72>1800, 1800, AP72)","v":0},{"$f":"IF(AQ72>700, 700, AQ72)","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,1200,200,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,240,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,280,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,325,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,375,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,425,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","133 pph applies as the lower threshold volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,495,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,575,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,650,-100]
[]
[null,"70% Volume Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1200,93,{"$f":"IF($AK$22=TRUE,AN83/2,-100)","v":-100}]
[null,"Peak Hour",null,null,"Volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1100,93,-100]
[null,null,null,null,"Major Street",null,null,"Pedestrian Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1050,93,-100,"70% Volume Level"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,100,-100,"Inputs",null,"Points to be graphed"]
[null,{"$f":"IF($AK$17=TRUE,IF('Instructions & Input'!B52>0,'Instructions & Input'!B52,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$17=TRUE,IF('Instructions & Input'!C52>0,'Instructions & Input'!C52,\"\"),\"\")","v":""},null,null,{"$f":"IF($AK$17=TRUE,IF('Instructions & Input'!D52>0,'Instructions & Input'!D52,\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,120,-100,{"$f":"SUM(E87)","v":0},{"$f":"SUM(H87)","v":0},{"$f":"IF(AP87>1200, 1200, AP87)","v":0},{"$f":"IF(AQ87>500, 500, AQ87)","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,800,150,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,190,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,235,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,290,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,350,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,420,-100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note:","93 pph applies as the lower threshold volume",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,455,-100]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AK$22=TRUE,\"50% volume threshold may be used with the support of a walking speed study reporting 15th-percentile crossing speed less than 3.5 ft/sec. Refer to MUTS Chapter 9 for additional guidance on how to conduct a walking speed study.\",\"\")","v":""}]

{"sheet":"Chapter 3 Warrant 5","index":6,"n_rows":27,"n_cols":38,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,35],[2,0,2,35],[4,5,4,14],[5,5,5,14],[6,5,6,14],[22,2,23,20],[24,2,25,24],[24,1,25,1],[22,1,23,1],[26,2,27,30],[26,1,27,1],[24,28,24,30],[24,25,24,27],[22,25,22,30],[22,21,22,24],[20,1,21,30],[20,31,20,34],[21,31,21,32],[21,33,21,34],[4,24,4,34],[5,24,5,34],[8,5,8,19],[8,23,8,24],[15,2,16,23],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[11,13,11,26],[24,33,25,34],[26,31,27,32],[26,33,27,34],[23,25,23,30],[23,21,23,24],[25,25,25,27],[25,28,25,30],[24,31,25,32],[22,31,23,32],[22,33,23,34]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0}]
[]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK14=TRUE,AK13=TRUE),1,0)","v":0}]
[null,"WARRANT 5 - SCHOOL CROSSING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK16=TRUE,AK15=TRUE),1,0)","v":0}]
[null,null,"Record hours where criteria are fulfilled and the corresponding volume or gap frequency in the boxes provided. The warrant is satisfied if all three of the criteria are fulfilled.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:"]
[]
[]
[]
[null,"Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulfilled?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No"]
[null,"1.","There are a minimum of 20 students crossing the major street during the highest crossing hour.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Students:",null,null,null,"Hour:"]
[]
[null,"2.","There are fewer adequate gaps in the major street traffic stream during the period when the children are using the established school crossing than the number of minutes in the same period.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minutes:",null,null,"Gaps:"]
[]
[null,"3.","The nearest traffic signal along the major street is located more than 300 ft. (90 m) away, or the nearest signal is within 300 ft. (90 m) but the proposed traffic signal will not restrict the progressive movement of traffic."]

{"sheet":"Chapter 3 Warrant 6","index":7,"n_rows":25,"n_cols":38,"rows_kept":25,"cut":false,"hidden":false,"merged":[[11,13,11,26],[6,5,6,14],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[8,5,8,19],[8,23,8,24],[15,2,17,23],[22,2,23,30],[24,2,25,30],[22,1,23,1],[24,1,25,1],[4,5,4,14],[4,24,4,34],[5,5,5,14],[5,24,5,34],[1,0,1,35],[2,0,2,35],[22,31,23,32],[22,33,23,34],[24,31,25,32],[24,33,25,34],[20,1,21,30],[20,31,20,34],[21,31,21,32],[21,33,21,34]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0}]
[]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK14=TRUE,AK13=TRUE),1,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,false]
[null,"WARRANT 6 - COORDINATED SIGNAL SYSTEM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK16=TRUE,AK15=TRUE),1,0)","v":0}]
[null,null,"Indicate if the criteria are fulfilled in the boxes provided.  The warrant is satisfied if either criterion is fulfilled.  This warrant should not be applied when the resulting signal spacing would be less than 300 m (1,000 ft.).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:"]
[]
[]
[]
[null,"Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulfilled?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No"]
[null,"1.","On a one-way street or a street that has traffic predominately in one direction, the adjacent signals are so far apart that they do not provide the necessary degree of vehicle platooning."]
[]
[null,"2.","On a two-way street, adjacent signals do not provide the necessary degree of platooning, and the proposed and adjacent signals will collectively provide a progressive operation."]

{"sheet":"Chapter 3 Warrant 7","index":8,"n_rows":48,"n_cols":45,"rows_kept":48,"cut":false,"hidden":false,"merged":[[31,18,31,22],[31,23,31,26],[32,18,32,22],[32,23,32,26],[33,18,33,22],[33,23,33,26],[34,15,34,17],[35,15,35,17],[34,18,34,22],[34,23,34,26],[35,18,35,22],[35,23,35,26],[25,33,36,34],[25,31,36,32],[28,3,36,14],[29,23,29,26],[29,18,29,22],[30,18,30,22],[30,23,30,26],[36,18,36,22],[36,23,36,26],[36,15,36,17],[30,15,30,17],[29,15,29,17],[28,27,36,30],[31,15,31,17],[32,15,32,17],[33,15,33,17],[15,2,16,23],[11,12,11,25],[6,5,6,14],[8,32,8,34],[9,5,9,18],[9,22,9,23],[9,32,9,34],[8,5,8,18],[8,22,8,23],[1,0,1,34],[2,0,2,34],[4,5,4,14],[4,23,4,33],[5,5,5,14],[5,23,5,33],[23,23,24,28],[21,15,22,17],[26,27,26,30],[27,27,27,30],[25,2,25,26],[25,27,25,30],[21,1,22,1],[21,2,22,14],[26,2,26,14],[27,2,27,14],[23,15,24,17],[19,31,19,34],[20,33,20,34],[20,31,20,32],[19,1,20,30],[28,23,28,26],[28,18,28,22],[21,33,22,34],[23,31,24,32],[23,33,24,34],[21,31,22,32],[23,29,24,30],[21,18,22,30],[23,18,24,22],[28,15,28,17],[23,1,24,1],[23,2,24,14]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 4C-5",1,0.8]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","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,1400,107,{"$f":"AN7*0.8","v":85.600000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1300,107,85.600000000000009]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0},null,null,null,null,null,1200,107,85.600000000000009]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0},null,null,null,null,null,1100,107,85.600000000000009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,126,100.80000000000001]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,900,160,128]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,196,156.80000000000001]
[null,"WARRANT 7 - CRASH EXPERIENCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,236,188.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,292,233.60000000000002]
[null,null,"Record hours where criteria are fulfilled, the corresponding volume, and other information in the boxes provided.  The warrant is satisfied if all three of the criteria are fulfilled.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,null,null,500,348,278.40000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied:",null,null,null,null,null,null,null,null,null,null,400,416,332.8]
[]
[]
[null,"Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulfilled?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No"]
[null,"1.\n","Adequate trial of other remedial measure has failed to reduce crash frequency.",null,null,null,null,null,null,null,null,null,null,null,null,"Measure tried:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK23=TRUE,AK22=TRUE),1,0)","v":0},null,{"$f":"IF(AK22=FALSE,0)","v":0},null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,"No"]
[null,"2.","Five or more reported crashes, of types susceptible to correction by signal, have occurred within a 12-month period.",null,null,null,null,null,null,null,null,null,null,null,null,"Observed Crash Types:",null,null,null,null,null,null,null,"Number of crashes per 12 months:",null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AK25=TRUE,AK24=TRUE),1,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,false]
[null,"3.","One of the following volume warrants is met:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Met?",null,null,null,{"$f":"IF(SUM(AK27:AK29)>0,\"Yes\",\"\")","v":""},null,{"$f":"IF(SUM(AK27:AK29)=0,\"No\",\"\")","v":"No"}]
[null,null,"     Warrant 1, Condition A (80% satisfied), or",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('Chapter 3 Warrant 1'!$AK$34=TRUE,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(AB27=\"Yes\",1,0)","v":0}]
[null,null,"     Warrant 1, Condition B (80% satisfied), or",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('Chapter 3 Warrant 1'!$AK$67=TRUE,\"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(AB28=\"Yes\",1,0)","v":0},null,null,null,null,"100% Volume Level"]
[null,null,null,"Warrant 4, Pedestrian Volume satisfied at 80% of volume requirements for any 8 hours of an average day.",null,null,null,null,null,null,null,null,null,null,null,"Hour",null,null,"Major Street Volume",null,null,null,null,"Ped Crossings Volume",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB29=\"Yes\",1,0)","v":0},null,null,null,null,"Inputs",null,"Points to be graphed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B29","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C29","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"SUM(S30)","v":0},{"$f":"SUM(X30)","v":0},{"$f":"IF(AP30>1400, 1400, AP30)","v":0},{"$f":"IF(AQ30>500, 500, AQ30)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B30","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C30","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,0,{"$f":"IF(AP31>1400, 1400, AP31)","v":0},{"$f":"IF(AQ31>500, 500, AQ31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B31","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C31","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B32","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C32","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E32","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B33","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C33","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E33","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B34","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C34","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E34","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B35","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C35","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Instructions & Input'!B36","v":"00:00:00"},null,null,{"$f":"'Instructions & Input'!C36","v":0},null,null,null,null,{"$f":"'Instructions & Input'!E36","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"* Note:","86 pph applies as the lower threshold volume for the 80% volume threshold."]

{"sheet":"Chapter 3 Warrant 8","index":9,"n_rows":39,"n_cols":39,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,2,36,22],[37,2,38,22],[33,1,34,1],[35,1,36,1],[37,1,38,1],[5,5,5,14],[5,24,5,34],[4,5,4,14],[4,24,4,34],[1,0,1,35],[2,0,2,35],[22,2,25,4],[22,1,25,1],[36,27,36,28],[36,29,36,30],[24,25,24,26],[24,27,25,28],[26,24,27,26],[33,27,33,28],[33,29,33,30],[26,27,27,30],[28,27,29,30],[31,1,32,26],[26,2,29,11],[26,1,29,1],[22,21,22,26],[33,2,34,22],[22,27,23,28],[22,29,23,30],[24,18,24,20],[22,6,23,20],[6,5,6,14],[23,21,23,26],[24,21,24,22],[24,23,24,24],[24,6,25,17],[25,21,25,22],[25,23,25,24],[8,5,8,19],[8,23,8,24],[11,13,11,26],[21,31,21,32],[21,33,21,34],[20,1,21,26],[15,2,18,24],[21,27,21,28],[21,29,21,30],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[20,27,20,30],[20,31,20,34],[22,33,25,34],[24,29,25,30],[26,31,29,32],[26,33,29,34],[28,12,29,14],[28,15,29,17],[25,25,25,26],[26,12,27,14],[26,15,27,17],[26,18,27,20],[26,21,27,23],[28,18,29,20],[28,21,29,23],[28,24,29,26],[25,18,25,20],[22,31,25,32],[31,31,31,34],[32,27,32,28],[32,29,32,30],[32,31,32,32],[32,33,32,34],[31,27,31,30],[33,31,38,32],[33,33,38,34],[34,23,34,26],[34,27,34,28],[34,29,34,30],[35,23,35,26],[35,27,35,28],[35,29,35,30],[33,23,33,26],[37,27,37,28],[37,29,37,30],[38,23,38,26],[38,27,38,28],[38,29,38,30],[37,23,37,26],[36,23,36,26]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0}]
[]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf"]
[]
[null,"WARRANT 8 - ROADWAY NETWORK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AL15=TRUE,AL14=TRUE),1,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,false]
[null,null,"Record hours where criteria are fulfilled, and the corresponding volume or other information in the boxes provided.  The warrant is satisfied if at least one of the criteria is fulfilled and if all intersecting routes have one or more of the Major Route characteristics listed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,false,{"$f":"IF(OR(AL17=TRUE,AL16=TRUE),1,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,"Satisfied:",null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,"Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Met?",null,null,null,"Fulfilled?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,"Yes",null,"No"]
[null,"1.\n\n\n","Both of the criteria to the right are met.",null,null,"a.","Total entering volume of at least 1,000 veh/hr during a typical weekday peak hour.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entering Volume:"]
[]
[null,null,null,null,null,"b.","Five-year projected volumes that satisfy one or more of Warrants 1, 2, or 3.",null,null,null,null,null,null,null,null,null,null,null,"Warrant:",null,null,1,null,2,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Satisfied?:"]
[null,"2.\n\n","Total entering volume at least 1,000 veh/hr for each of any 5 hrs of a non-normal business day (Sat. or Sun.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hour"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volume"]
[]
[]
[null,"Characteristics of Major Routes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Met?",null,null,null,"Fulfilled?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"No",null,"Yes",null,"No"]
[null,"1.\n","Part of the street or highway system that serves as the principal roadway network for through traffic flow.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Street:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Street:"]
[null,"2.","Rural or suburban highway outside of, entering, or traversing a city.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Street:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Street:"]
[null,"3.","Appears as a major route on an official plan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Major Street:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minor Street:"]

{"sheet":"Chapter 3 Warrant 9","index":10,"n_rows":120,"n_cols":55,"rows_kept":120,"cut":false,"hidden":false,"merged":[[96,43,97,43],[96,44,97,44],[11,13,11,26],[107,44,107,49],[25,1,26,30],[26,33,26,34],[27,31,28,32],[27,33,28,34],[33,24,33,33],[55,8,55,17],[56,8,56,17],[56,24,56,29],[43,1,43,7],[44,1,44,7],[53,8,53,17],[54,8,54,17],[54,24,54,29],[55,18,55,23],[55,24,55,29],[56,18,56,23],[49,8,49,29],[47,8,47,14],[46,8,46,14],[45,8,45,14],[8,23,8,24],[29,31,30,32],[1,0,1,36],[8,5,8,19],[29,2,30,30],[29,33,30,34],[4,5,4,14],[4,24,4,34],[5,5,5,14],[5,24,5,34],[29,1,30,1],[2,0,2,36],[27,1,28,1],[27,2,28,30],[25,31,25,34],[26,31,26,32],[6,5,6,14],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[22,2,23,22],[20,2,20,34],[65,1,65,9],[57,18,57,23],[57,24,57,29],[58,18,58,23],[58,24,58,29],[66,7,66,9],[66,4,66,6],[66,1,66,3],[44,18,44,26],[45,18,45,26],[44,8,44,14],[46,18,46,26],[58,8,58,17],[52,18,52,23],[52,24,52,29],[53,18,53,23],[53,24,53,29],[57,8,57,17],[51,18,51,23],[51,24,51,29],[54,18,54,23],[52,8,52,17],[44,27,44,32],[50,8,51,17],[67,1,67,3],[67,4,67,6],[67,7,67,9],[70,1,70,9],[71,1,71,3],[71,4,71,6],[71,7,71,9],[81,7,81,9],[81,4,81,6],[81,1,81,3],[80,1,80,9],[72,7,72,9],[72,4,72,6],[72,1,72,3],[85,1,85,9],[86,1,86,3],[86,4,86,6],[86,7,86,9],[87,1,87,3],[87,4,87,6],[87,7,87,9],[82,1,82,3],[82,4,82,6],[82,7,82,9],[47,1,47,7],[46,27,46,32],[46,1,46,7],[45,1,45,7],[50,18,50,29],[45,27,45,32],[41,1,41,7],[43,8,43,14],[43,18,43,26],[34,18,34,21],[34,26,34,29],[35,18,35,21],[35,26,35,29],[33,1,33,3],[43,27,43,32],[41,27,42,32],[41,18,42,26],[42,8,42,14],[41,8,41,14],[42,1,42,7],[39,1,40,14],[39,18,40,32],[36,18,36,21],[37,26,37,29],[37,18,37,21]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0}]
[]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf"]
[]
[null,"Approach Lane Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(AL14=TRUE,AL15=TRUE),1,0)","v":0}]
[null,null,"1.  How many approach lanes are there at the track crossing?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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(AL14=TRUE,TRUE,FALSE)","v":false}]
[null,null,"If there is 1 lane, use Figure 4C-9 and if there are 2 or more, use Figure 4C-10.",null,null,null,null,null,null,null,null,null,null,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(AL15=TRUE,TRUE,FALSE)","v":false}]
[]
[]
[null,"WARRANT 9 - INTERSECTION NEAR A GRADE CROSSING",null,null,null,null,null,null,null,null,null,null,null,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(AND(AL26=TRUE,AL28=TRUE),TRUE,FALSE)","v":false},null,{"$f":"IF(OR(AL20=TRUE,AL21=TRUE),1,0)","v":0}]
[null,null,"This signal warrant should be applied only after adequate consideration has been given to other alternatives or after a trial of an alternative has failed to alleviate the safety concerns associated with the grade crossing.",null,null,null,null,null,null,null,null,null,null,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(OR(AL27=TRUE,AL29=TRUE),TRUE,FALSE)","v":false}]
[]
[null,null,"Indicate if both criteria are fulfilled in the boxes provided. The warrant is satisfied if both criteria are met. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable:",null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(AL23=TRUE,AL24=TRUE),1,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,"Satisfied:",null,null,null,null,null,null,null,null,null,false]
[]
[null,"Criteria",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fulfilled?",null,null,null,null,null,false,null,{"$f":"IF(OR(AL26=TRUE,AL27=TRUE),1,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,"Yes",null,"No",null,null,null,false]
[null,"1.","A grade crossing exists on an approach controlled by a STOP or YIELD sign and the center of the track nearest to the intersection is within 140 feet of the stop line or yield line on the approach; and",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"IF(OR(AL28=TRUE,AL29=TRUE),1,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,false]
[null,"2.","During the highest traffic volume hour during which the rail uses the crossing, the plotted point falls above the applicable curve for the existing combination of approach lanes over the track and the distance D (clear storage distance)."]
[]
[null,null,"Use the following tables (4C-2, 4C-3, and 4C-4 to appropriately adjust the minor-street approach volume). "]
[]
[null,"Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjustment Factors from Tables"]
[null,"Occurrences of Rail traffic per day",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(S35>12, 1.33, VLOOKUP(S35,AR109:AS120, 2,FALSE ))","v":{"$error":"#N/A"}}]
[null,"% of High Occupancy Buses on Approach Lane at Track Crossing",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(S36<2%, 1, IF(S36<4%, 1.09, IF(S36<6%, 1.19, 1.32)) )","v":1}]
[null,"Enter D (feet)"]
[null,"% of Tractor-Trailer Trucks on Approach Lane at Track Crossing",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(AP42<=2.5%, AN58, IF(AP42<=7.5%, AN59, IF(AP42<=12.5%,AN60,IF(AP42<=17.5%, AN61,IF(AP42<22.5%, AN62, IF(AP42<=27.5%, AN63, AN64))))))","v":0.5}]
[]
[null,"Table 4C-2. Adjustment Factor for Daily Frequency of Rail Traffic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Table 4C-3. Adjustment Factor for Percentage of High-Occupancy Buses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(S37<70, 1, 2)","v":1}]
[null,"Rail Traffic per Day",null,null,null,null,null,null,"Adjustment Factor",null,null,null,null,null,null,null,null,null,"% of High-Occupancy Buses* on Minor Street Approach",null,null,null,null,null,null,null,null,"Adjustment Factor",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S38, 3)","v":0}]
[null,1,null,null,null,null,null,null,0.67]
[null,2,null,null,null,null,null,null,0.91,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,1]
[null,"3 to 5",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,0.02,null,null,null,null,null,null,null,null,1.0900000000000001]
[null,"6 to 8",null,null,null,null,null,null,1.18,null,null,null,null,null,null,null,null,null,0.04,null,null,null,null,null,null,null,null,1.19]
[null,"9 to 11",null,null,null,null,null,null,1.25,null,null,null,null,null,null,null,null,null,"6% or more",null,null,null,null,null,null,null,null,1.32]
[null,"12 or more",null,null,null,null,null,null,1.33,null,null,null,null,null,null,null,null,null,"* A high-occupancy bus is defined as a bus occupied by at least 20 people"]
[]
[null,null,null,null,null,null,null,null,"Table 4C-4. Adjustment Factor for Percentage of Tractor-Trailer Trucks"]
[null,null,null,null,null,null,null,null,"% of Tractor-Trailer Trucks on Minor-Street Approach",null,null,null,null,null,null,null,null,null,"Adjustment Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D less than 70 feet",null,null,null,null,null,"D of 70 feet or more"]
[null,null,null,null,null,null,null,null,"0% to 2.5%",null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,"2.6% to 7.5%",null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,"7.6% to 12.5%",null,null,null,null,null,null,null,null,null,1,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,130,null,110,null,90,null,70,null,50,null,30]
[null,null,null,null,null,null,null,null,"12.6% to 17.5%",null,null,null,null,null,null,null,null,null,2.2999999999999998,null,null,null,null,null,1.1499999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,25,800,25,800,25,800,25,800,25,800,25]
[null,null,null,null,null,null,null,null,"17.6% to 22.5%",null,null,null,null,null,null,null,null,null,2.7,null,null,null,null,null,1.35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,25,700,25,700,25,700,25,700,25,700,25]
[null,null,null,null,null,null,null,null,"22.6% to 27.5%",null,null,null,null,null,null,null,null,null,3.28,null,null,null,null,null,1.64,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($S$37<70, S53, Y53)","v":0.5},null,null,null,600,25,600,25,600,25,600,25,600,25,600,25]
[null,null,null,null,null,null,null,null,"More than 27.5%",null,null,null,null,null,null,null,null,null,4.18,null,null,null,null,null,2.09,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,500,25,500,25,500,25,500,25,500,25,500,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,400,45,400,45,400,45,400,27,400,25,400,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2999999999999998,null,null,null,300,60,300,55,300,55,300,45,300,25,300,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.7,null,null,null,200,130,200,110,200,100,200,70,200,25,200,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.28,null,null,null,100,190,100,160,100,145,100,125,100,50,100,30]
[null,"Input the major and minor street volumes before ",null,null,null,null,null,null,null,null,null,null,null,null,null,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.18,null,null,null,50,225,50,190,50,160,50,145,50,70,50,60]
[null,"adjustment factors are applied"]
[null,"1 Approach Lane"]
[null,{"$f":"$S$37","v":0}]
[null,"D (ft)",null,null,"Major Vol.",null,null,"Minor Vol."]
[]
[null,"After adjustment factors are applied"]
[null,"1 Approach Lane w/Factors"]
[null,{"$f":"S37","v":0},null,null,{"$f":"E67","v":0},null,null,{"$f":"$H$67*$AA$35*$AA$36*$AA$38","v":{"$error":"#N/A"}}]
[null,"D (ft)",null,null,"Major Vol.",null,null,"Minor Vol."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note: 25 vph applies as the lower threshold volume"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* *Note: VPH after applying the adjustment factors in Tables 4C-2, 4C, and or 4C-4, if appropriate"]
[]
[null,"Input D and the major and minor street volumes before ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,800,25,800,25,800,25,800,25,800,25,800,25]
[null,"adjustment factors are applied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,700,25,700,25,700,25,700,25,700,25,700,25]
[null,"2 or more Approach Lanes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,600,25,600,25,600,25,600,25,600,25,600,25]
[null,{"$f":"$S$37","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,500,25,500,25,500,25,500,25,500,25,500,25]
[null,"D (ft)",null,null,"Major Vol.",null,null,"Minor Vol.",null,null,null,null,null,null,null,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":"E72","v":0},{"$f":"H72","v":{"$error":"#N/A"}},null,null,400,45,400,45,400,45,400,27,400,25,400,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AN83>800, 800, AN83)","v":0},{"$f":"IF(AO83>350, 350, AO83)","v":{"$error":"#N/A"}},null,null,300,145,300,125,300,80,300,50,300,25,300,25]
[null,"After adjustment factors are applied",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,220,200,200,200,150,200,75,200,25,200,25]
[null,"2+ Approach Lane w/Factors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,325,100,260,100,225,100,190,100,45,100,30]
[null,{"$f":"$S$37","v":0},null,null,{"$f":"E82","v":0},null,null,{"$f":"$H$82*$AA$35*$AA$36*$AA$38","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,"—",50,"—",50,"—",50,"—",50,75,50,60]
[null,"D (ft)",null,null,"Major Vol.",null,null,"Minor Vol."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* Note: 25 vph applies as the lower threshold volume"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"* *Note: VPH after applying the adjustment factors in Tables 4C-2, 4C, and or 4C-4, if appropriate"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of High-Occupancy Buses* on Minor Street Approach","Adjustment Factor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"E87","v":0},{"$f":"H87","v":{"$error":"#N/A"}},null,null,0,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AN99>800, 800, AN99)","v":0},{"$f":"IF(AO99>350, 350, AO99)","v":{"$error":"#N/A"}},null,null,0.02,1.0900000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.04,1.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.06,1.32]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rail Traffic per Day","Adjustment Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,1.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,1.3]

{"sheet":"Warrant Summary","index":11,"n_rows":31,"n_cols":41,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,5,6,14],[8,5,8,19],[8,23,8,24],[1,0,1,36],[2,0,2,36],[4,5,4,14],[4,24,4,34],[5,5,5,14],[5,24,5,34],[8,33,8,35],[9,5,9,19],[9,23,9,24],[9,33,9,35],[17,4,17,34],[16,4,16,34],[15,4,15,34],[11,13,11,26]]}
[]
["State of Florida Department of Transportation"]
["TRAFFIC SIGNAL WARRANT SUMMARY"]
[]
[null,null,null,null,"City:",{"$f":"'Instructions & Input'!B20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Engineer:",{"$f":"'Instructions & Input'!D21","v":0}]
[null,null,null,null,"County:",{"$f":"'Instructions & Input'!B21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:",{"$f":"'Instructions & Input'!D22","v":"00:00:00"}]
[null,null,null,null,"District:",{"$f":"'Instructions & Input'!B22","v":0}]
[]
[null,null,null,null,"Major Street:",{"$f":"'Instructions & Input'!B24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D24","v":0},null,null,null,null,null,null,null,null,"Major Approach Speed:",{"$f":"'Instructions & Input'!G24","v":0}]
[null,null,null,null,"Minor Street:",{"$f":"'Instructions & Input'!B25","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lanes:",{"$f":"'Instructions & Input'!D25","v":0},null,null,null,null,null,null,null,null,"Minor Approach Speed:",{"$f":"'Instructions & Input'!G25","v":0}]
[]
[null,"MUTCD Electronic Reference to Chapter 4: ",null,null,null,null,null,null,null,null,null,null,null,"http://mutcd.fhwa.dot.gov/pdfs/2009r1r2/part4.pdf"]
[]
[null,"CONCLUSIONS"]
[]
[null,"Remarks:"]
[]
[]
[]
[]
[null,"WARRANTS SATISFIED:"]
[]
[null,null,null,null,null,null,null,null,null,"Warrant 1",null,null,null,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('Chapter 3 Warrant 1'!AS31=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 1'!$AQ$30=1,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 1'!$AQ$32=1,TRUE,FALSE)","v":false},{"$f":"IF(OR(AM23=TRUE,AL23=TRUE,AN23=TRUE),1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,"Warrant 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,{"$f":"IF('Chapter 3 Warrant 2'!$AK$21=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 2'!AK22=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 2'!$AK$23=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 3",null,null,null,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('Chapter 3 Warrant 3'!$AK$21=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 3'!$AK$22=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 3'!$AK$23=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 4",null,null,null,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('Chapter 3 Warrant 4'!AR27=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 4'!AR28=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 4'!AR29=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 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,{"$f":"IF('Chapter 3 Warrant 5'!$AK$14=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 5'!$AK$15=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 5'!$AK$16=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 6",null,null,null,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('Chapter 3 Warrant 6'!$AK$14=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 6'!$AK$15=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 6'!$AK$16=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 7",null,null,null,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('Chapter 3 Warrant 7'!$AK$23=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 7'!$AK$24=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 7'!$AK$25=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 8",null,null,null,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('Chapter 3 Warrant 8'!$AL$15=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 8'!$AL$16=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 8'!$AL$17=TRUE,TRUE,FALSE)","v":false},0]
[null,null,null,null,null,null,null,null,null,"Warrant 9",null,null,null,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('Chapter 3 Warrant 9'!$AL$21=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 9'!$AL$23=TRUE,TRUE,FALSE)","v":false},{"$f":"IF('Chapter 3 Warrant 9'!$AL$24=TRUE,TRUE,FALSE)","v":false},0]