{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","User Input","Drop Downs","Calculations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Instructions for Using the Federal Highway Administration (FHWA) 2023 Carbon Monoxide (CO) Categorical Hot-Spot Finding Spreadsheet Tool"]
["1. Select the \"User Input\" tab."]
["2. Parameter Table (left-side): In the table on the left hand side enter information about the intersection being analyzed under the \"Input\" column (Column E)."]
["    a. Use the \"Descriptions\" provided in Column C for a defintion of each paramter and instructions on what to enter.  Additional information on each parameter can be found in the Technical Report."]
["    b. Some paramters with a note in bold like area type, peak hour LOS, and number of lanes must be selected from the drop down lists (otherwise Excel will give an error).  Values can be entered directly for all other parameters."]
["3. Shaded Cells: Cells become green if information entered for a parameter falls within the acceptable range noted in Column D.  Cells become red if the information entered falls outside of the acceptable range.  In this case the categorical finding cannot be used."]
["4. Output (middle right box): The information entered on the left for truck percent, grade, and area type will be used to select the scenario, area type, and 1-hour roadway contribution listed under the Output box on the right.  Information from the \"Calculations\" tab will be used to fill this box, but the user does not need to interact with this tab.  The 8-hour roadway contribution will be calculated by multiplying the 1-hour roadway contribution by the persistence factor entered.  A persistence factor of 0.7 (from the 1992 CO Guidline) will be used in cases where a persistence factor less than 0.7 is entered."]
["5. Paramters that Vary by Scenario (top right box): The acceptable range for the 1-hour and 8-hour CO background concentration will dynamically change based on the information from the Output box.  The allowable background concentrations are calculated as the National Ambient Air Quality Standards (35 ppm for 1-hour, 9 ppm for 8-hour) minus the roadway contribution from the Output box."]
["    a. If the background concentrations entered fall below the allowable background concnetrations, those boxes will turn green and the categorical finding can be used as long as all other boxes are also green."]
["7. Bottom-right box: Enter information about the preparer, project name, and intersection name on the bottom right."]
["8. Documentation: Print the User Input tab to include in the documentation for the project-level conformity determination or NEPA document.  Go to File/Print and the print settings should be set to print it all on one landscape page with the date and time of printing in the footer."]
["9. New Intersection: To analyze another intersection Save As a new file and hit the Reset button at the top right or type over the old information."]

{"sheet":"User Input","index":1,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,12,18,12],[6,10,7,10],[8,10,9,10],[0,11,1,11],[14,10,15,11],[12,10,13,11],[17,7,17,11],[18,7,18,11],[12,7,13,7],[11,6,11,11],[0,1,1,9],[12,6,13,6],[3,2,5,2],[3,3,5,3],[19,7,19,11],[14,8,15,9],[8,6,9,7],[3,11,5,11],[12,8,13,9],[8,11,9,11],[0,0,18,0],[14,6,15,6],[14,7,15,7],[3,1,5,1],[3,4,5,4],[16,6,16,11],[3,5,18,5],[6,9,7,9],[8,9,9,9],[3,8,5,8],[6,8,7,8],[8,8,9,8],[3,9,5,10],[6,11,7,11],[6,6,7,7],[3,6,5,7]]}
[null,"Federal Highway Administration (FHWA) 2023 Carbon Monoxide (CO) Categorical Hot-Spot Finding: Spreadsheet Tool Results"]
[]
[]
[null,"Parameter","Description","Acceptable Range","Input",null,"Parameters that Vary by Scenario",null,"Description","Acceptable Range (varies based on previous inputs)",null,"Input"]
[]
[]
[null,"Analysis Year","The year when peak emissions are expected from the project when considered with background.","≥ 2022",2040,null,"1-Hour Avg. CO Background Concentration (ppm)",null,"1-hour average concentration in the project area due to other local sources, determined in most cases from local monitoring data as described in Section 4.7.3 of EPA's 1992 CO Guideline.","≤",{"$f":"35-I15","v":29.8},4]
[null,"Area Type - use drop down to select","An urban area has a population of 5,000 or greater within the FHWA adjusted urban area boundary.  All other areas are rural.","Urban or Rural","Urban"]
[null,"Road Grade (%)","The maximum grade along the approach, as measured from the stop line to a point 100 feet before the stop line along a line parallel to the direction of travel.  Enter the maximum grade among the four approaches.","≤6",4,null,"8-Hour Avg. CO Background Concentration (ppm)",null,"8-hour average concentration in the project area due to other local sources, determined in most cases from local monitoring data as described in Section 4.7.3 of EPA's 1992 CO Guideline.","≤",{"$f":"9-K15","v":5.36},3.6]
[null,"Truck Percent (%)","The percentage of the total traffic volume that is made up of single unit and combination trucks.  Enter the highest truck percentage from all links at the project intersection.","≤20",3]
[null,"Temperature (°F)","Section 4.7.1 of EPA's 1992 CO Guideline allows two methods: 1) temperature corresponding to each of the ten highest non-overlapping 8-hour CO monitoring values for the last 3 years, or 2) average January temperature.","≤ 70",45]
[null,"Speed (mph)","The average speed approaching the intersection during the peak hour. All intersection approaches must be within the acceptable range.","15-45",33,null,"Output"]
[null,"Peak Hour Approach Volume (veh/hr)","The volume approaching the intersection during the peak hour.  Enter the maximum among the four approaches.","≤ 2640",1023,null,"Scenario","Area Type","Roadway Contribution: 1-Hour CO  Concentration (PPM)",null,"Roadway Contribution: 8-Hour CO Concentration (PPM)"]
[null,"Peak Hour Level-of-Service (LOS) - use drop down to select","During the peak hour, the letter representing the quality of service for the entire intersection measured on an A-F scale, with LOS A representing the best operating conditions from the traveler's perspective and LOS F the worst.","A-E","C"]
[null,"Intersection Angle (degrees)","Enter the smallest angle between the two cross-streets of the intersection (90 degrees is perpendicular).","≥ 75",75,null,{"$f":"Calculations!B11&\" \n\"&Calculations!B12","v":"High Grade \nHigh Truck"},{"$f":"E8","v":"Urban"},{"$f":"Calculations!B15","v":5.2},null,{"$f":"Calculations!B15*IF(E20<0.7,0.7,E20)","v":3.6399999999999997}]
[null,"Number of through lanes (one direction) - use drop down to select","The number of lanes approaching the intersection available for vehicles traveling through the intersection without turning. Enter the maximum among the four approaches.","≤ 4",2]
[null,"Number of left turn lanes (one direction) - use drop down to select","The number of lanes approaching the intersection that are designated for use only by vehicles making left turns.  Enter the maximum among the four approaches.","≤ 2",1]
[null,"Lane Width (feet)","The lateral distance between stripes for a single lane.  Enter the minimum among all lanes at the intersection.","≥ 10",12,null,"Prepared By:"]
[null,"Median Width (feet)","The width of the area in the middle of a roadway separating opposing traffic flows.","Any (≥ 0)",22,null,"Project Name:"]
[null,"Persistence Factor","The factor used to calculate 8-hour concentration estimates from 1-hour concentration estimates, as determined by following Section 4.7.2 of EPA's 1992 CO Guideline.","0-1.0",0.7,null,"Intersection Name: "]

{"sheet":"Drop Downs","index":2,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Urban/Rural",null,"LOS",null,"Through Lanes",null,"Left Turn Lanes"]
[]
["Urban",null,"A",null,1,null,0]
["Rural",null,"B",null,2,null,1]
[null,null,"C",null,3,null,2]
[null,null,"D",null,4]
[null,null,"E"]

{"sheet":"Calculations","index":3,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Intersection Scenario","Urban/Rural ","Combined for Lookup","1 Hour CO Concentration Modeling Results (PPM)","Allowable 1 Hour CO Background (PPM)",null,"CO NAAQS Standard","Concentration","Unit"]
["High Grade High Truck","Urban ","High Grade High Truck Urban",5.2,{"$f":"$H$2-D2","v":29.8},null,"1-Hour",35,"ppm"]
["High Grade High Truck","Rural","High Grade High Truck Rural",7.3,{"$f":"$H$2-D3","v":27.7},null,"8-Hour",9,"ppm"]
["Low Grade High Truck","Urban","Low Grade High Truck Urban",3.7,31.3]
["Low Grade High Truck","Rural ","Low Grade High Truck Rural",5.4,29.6]
["High Grade Low Truck","Urban","High Grade Low Truck Urban",4.2,30.8]
["High Grade Low Truck","Rural","High Grade Low Truck Rural",6.1,28.9]
["Low Grade Low Truck","Urban","Low Grade Low Truck Urban",3,32]
["Low Grade Low Truck","Rural","Low Grade Low Truck Rural",4.7,30.3]
[]
["Grade Scenario (determined based on user inputs and min/max values below)",{"$f":"IF(AND('User Input'!E9>=Calculations!B25, 'User Input'!E9<=Calculations!C25), Calculations!A25, IF(AND(Calculations!E9>Calculations!B24, 'User Input'!E9<=Calculations!C24), Calculations!A24, \"Grade Not Allowed\"))","v":"High Grade"}]
["Truck Scenario (determined based on user inputs and min/max values below)",{"$f":"IF(AND('User Input'!E10>=Calculations!B27, 'User Input'!E10<=Calculations!C27), Calculations!A27, IF(AND('User Input'!E10>Calculations!B26, 'User Input'!E10<=Calculations!C26), Calculations!A26, \"Truck Percentage Not Allowed\"))","v":"High Truck"}]
["Urban/Rural (copied from user input)",{"$f":"'User Input'!E8","v":"Urban"}]
["Combined for Lookup",{"$f":"B11&\" \"&B12&\" \"&B13","v":"High Grade High Truck Urban"}]
["1 Hour Conc Function. Lookup Function to determine correct modeled concentration based on user inputs.",{"$f":"VLOOKUP(B14, C2:D9, 2, FALSE)","v":5.2}]
[]
["Scenario","Road Grade*","Truck Percentage**"]
["High Grade High Truck Percentage ","1% <upgrade≤ 6%","2% < trucks ≤ 20%"]
["Low Grade High Truck Percentage ","0% ≤ upgrade ≤ 1%","2% < trucks ≤ 20%"]
["High Grade Low Truck Percentage ","1% <upgrade≤ 6%","0% ≤ trucks ≤ 2% "]
["Low Grade Low Truck Percentage ","0% ≤ upgrade ≤ 1%","0% ≤ trucks ≤ 2% "]
[]
[null,"Min","Max"]
["High Grade",1,6]
["Low Grade",0,1]
["High Truck",2,20]
["Low Truck",0,2]