{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Input Sheet Introduction","Highway Input Sheet","Intersection Input Sheet","Bypass Input Sheet","HOV Conv Input Sheet","Transit Input Sheet","Rail Crossing Input Sheet","Park and Ride Input Sheet","Ramp Input Sheet","Highway TMS Input Sheet","Queuing Input Sheet","Active Transportation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":261,"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":"Input Sheet Introduction","index":0,"n_rows":44,"n_cols":24,"rows_kept":44,"cut":false,"hidden":false,"merged":[[16,3,16,5],[17,3,17,5],[6,2,10,6],[4,3,4,5],[15,3,15,5]]}
["The column titles for this worksheet are in row 2. They span cells B2. The data spans cells A3 through H31. There is information in every cell for column A through H inclusive.  If you are not using a screen reader, you can press Alt + R, T for the Review Ribbon, Edit Comment to move to and open a Comment once you are on a cell with a Comment. When you are finished reading the Comment, press Escape to close the comment and return to the worksheet. If you are using the JAWS screen reader, press Ctrl + Shift + Apostrophe to get a list of Comments and their cell coordinates in the worksheet. Press Enter on the Comment you want to go to or Escape once you’ve read the Comment for a cell. You are returned to the workbook. Note that there is no keyboard command with JAWS to reread Comments or read Comments once you are on them in a cell. You must use the ability to list Comments in order to read them if you are using the JAWS screen reader."]
["CALIFORNIA LIFE-CYCLE BENEFIT/COST ANALYSIS MODEL (CAL-B/C)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Types"]
[null,null,null,"INTRODUCTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"HIGHWAY CAPACITY EXPANSION"]
[null,null,"The Cal-B/C model provides a method for preparing a simple economic analysis of highway, rail, and transit projects. Given certain input data for a project, the model calculates its life-cycle costs, life-cycle benefits, net present value, benefit/cost ratio, internal rate of return, and payback period.  Annual benefits are also calculated. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"    General Highway"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"    HOV Lane Addition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"    HOT Lane Addition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"    Passing Lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"    Intersection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"    Bypass"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"    Special (queuing)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"    Pavement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"RAIL OR TRANSIT CAPACITY EXPANSION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"    Passenger Rail"]
[null,null,null,"Type of Project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"    Light-Rail (LRT)"]
[null,null,null,"Select project type from list",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"    Highway-Rail Grade Crossing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"    Bus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"    New Park and Ride Lot"]
[null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"    Park and Ride Leased Lot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"    Park and Ride Lot Expansion"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"OPERATIONAL IMPROVEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"    Auxiliary Lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"    Freeway Connector"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"    HOV Connector"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"    HOV Drop Ramp"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"    Off-Ramp Widening"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"    On-Ramp Widening"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"    HOV/HOT Lane Conversion"]
[null,"For questions and comments, please contact:",null,null,"Rose Agacer",null,"(916) 651-6014","rose_agacer@dot.ca.gov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"TRANSP MGMT SYSTEMS (TMS)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"    Ramp Metering"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"    Ramp Metering Signal Coord"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"    Incident Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"    Traveler Information"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"    Arterial Signal Management"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"    Transit Vehicle Location (AVL)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"    Transit Vehicle Signal Priority"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"    Bus Rapid Transit (BRT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"ACTIVE TRANSPORTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"    Bike/Ped Facility Improvement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"    Pike/Ped Intersection Improvement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"    New Bike/Ped Facility"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"    Non-Infrastructure Program"]

{"sheet":"Highway Input Sheet","index":1,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,15,4,16],[5,15,5,16],[28,13,28,14],[30,13,30,14],[37,13,37,14],[35,13,35,14],[40,13,40,14],[42,13,42,14],[46,13,46,16],[48,7,48,8],[45,4,46,11],[4,4,5,7],[2,6,2,7],[32,13,32,14],[33,13,33,14],[34,13,34,14]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Highway Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Lane Addition",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"HOV Lane Addition",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Passing Lane",null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"Pavement Rehabilitation",null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,"Other (describe:                                            )",null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,"Percent Injury Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Collision Reduction Factor (if applicable)"]
[]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)"]
[null,null,null,null,null,null,null,null,null,null,"PROJECT COSTS"]
[null,null,"Highway Design",null,null,null,"No Build","Build",null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,"Roadway Type (Fwy., Exp., Conv. Hwy.)",null,null,null,null,"HOV"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,"Restriction",null,null,null,"Project Support Costs"]
[null,null,null,"Number of HOV Lanes"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,"(2 or 3 )",null,null,null,"Right-of-Way Costs"]
[null,null,null,"Project Length (in miles)"]
[null,null,null,"Pavement IRI (in inches/mile), if pav. project",null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build"]
[null,null,null,"Current",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[null,null,null,"Forecast (20 years after construction)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,"Average Hourly HOV Traffic (if HOV lanes)",null,null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,"Percent Trucks (include RVs, if applicable)"]
[null,null,"Truck Speed (in mph, if passing lane project)",null,null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Intersection Input Sheet","index":2,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":false,"merged":[[2,7,2,9],[48,4,48,14],[48,16,48,19],[32,16,32,17],[4,18,4,19],[5,18,5,19],[4,4,5,9],[10,8,11,10],[12,8,13,10],[33,16,33,17],[35,16,35,17],[38,16,38,17],[49,4,49,5],[49,8,49,11],[26,16,26,17],[28,16,28,17],[30,16,30,17],[31,16,31,17],[40,16,40,17]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Intersection/Connector Project"]
[]
[null,null,"District: ",null,null,null,"County:",null,null,null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,"Enter \"X\"",null,null,"Description",null,null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Intersection",null,"X",null,"Road 1:",null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"Freeway Connector",null,null,null,null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"HOV Connector",null,null,null,"Road 2:",null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"Other (describe:                     )",null,null,null,null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"Project Location "]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,"Length of Construction Period",null,null,null,"years",null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accident Rate (per mil. vehicles)"]
[null,null,"Length of Peak Period",null,null,null,"hours",null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)",null,null,null,null,null,null,null,null,null,null,null,"PROJECT COSTS"]
[null,"Enter data for appropriate ramps, basic highway sections, or weaving areas",null,null,null,null,null,null,null,null,null,null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[]
[null,null,"Highway Design",null,null,null,"No Build",null,null,"Build",null,null,null,null,null,"Project Support Costs"]
[null,null,null,null,null,null,"Road 1","Road 2",null,"Road 1","Road 2"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[null,null,null,"Number of HOV Lanes"]
[null,null,null,"HOV Restriction (2 or 3, if HOV lanes)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,"Project Length (in miles)",null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,null,"Area Impacted (in miles)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,"Average Daily Traffic",null,null,null,"No Build",null,null,"Build",null,null,null,null,null,"Operations Costs"]
[null,null,null,null,null,null,"Road 1","Road 2",null,"Road 1","Road 2"]
[null,null,null,"Current",null,null,null,null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[null,null,null,"Forecast (20 years after construction)"]
[]
[null,null,"Average Hourly HOV Traffic (if HOV lanes)"]
[null,null,"Percent Traffic in Weave (if connector proj.)"]
[null,null,"Percent Trucks (include RVs, if applicable)"]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[null,"Prepared by:",null,null,null,null,null,"Phone No:    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.",null,"E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447. For questions, contact:",null,null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014",null,"rose_agacer@dot.ca.gov"]

{"sheet":"Bypass Input Sheet","index":3,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[4,17,4,18],[5,17,5,18],[26,15,26,16],[28,15,28,16],[36,15,36,16],[34,15,34,16],[39,15,39,16],[41,15,41,16],[44,4,44,18],[45,4,45,6],[45,15,45,18],[4,4,5,8],[2,6,2,8],[31,15,31,16],[32,15,32,16],[33,15,33,16]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Bypass Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"Bypass",null,null,null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Other (describe:                                      )",null,null,null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)"]
[]
[null,null,"Highway Design",null,null,null,null,null,"Build",null,null,null,"PROJECT COSTS"]
[null,null,null,null,null,null,"No Build",null,"Main","Bypass",null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,"Roadway Type (Fwy., Exp., Conv. Hwy.)"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,null,null,null,null,null,null,"Project Support Costs"]
[null,null,null,"Number of HOV Lanes"]
[null,null,null,"HOV Restriction (2 or 3, if HOV lanes)",null,null,null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[null,null,null,"Highway Free-Flow Speed (in mph)"]
[]
[null,null,null,"Project Length (in miles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,"Average Daily Traffic",null,null,null,null,null,"Build"]
[null,null,null,null,null,null,"No Build",null,"Main","Bypass",null,null,null,null,"Mitigation/Other Costs"]
[null,null,null,"Current"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,"Average Hourly HOV Traffic (if HOV lanes)"]
[null,null,"Percent Trucks (include RVs, if applicable)",null,null,null,null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[]
[null,"COMMENTS:"]
[null,"Prepared by:",null,null,null,null,null,null,"Phone No:    ",null,null,null,null,null,"E-Mail:    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447. For questions, contact:",null,null,null,null,null,null,null,null,"Rose Agacer",null,null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"HOV Conv Input Sheet","index":4,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,15,4,16],[5,15,5,16],[28,13,28,14],[30,13,30,14],[37,13,37,14],[35,13,35,14],[40,13,40,14],[42,13,42,14],[46,13,46,16],[48,7,48,8],[45,4,46,11],[4,4,5,7],[2,6,2,7],[32,13,32,14],[33,13,33,14],[34,13,34,14]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - HOT Lane/HOV Conversion"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"HOT Lane Addition",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"HOT Lane Conversion",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"HOV-2 to HOV-3 Conversion",null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"Other (describe:                                            )",null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"Project Location "]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,"Rate Group"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)"]
[]
[null,null,"Highway Design",null,null,null,"No Build","Build"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,null,null,"PROJECT COSTS"]
[null,null,null,"Number of HOV/HOT Lanes",null,null,null,null,null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,"HOV Restriction (2 or 3)"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,null,null,null,null,"Project Support Costs"]
[null,null,null,"Project Length (in miles)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build"]
[null,null,null,"Current",null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,"Percent of Induced Trips (if any) using HOV/HOT Lane",null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,null,"Average Hourly HOV Traffic (if HOV lanes)"]
[null,null,null,"Percent Trucks (include RVs, if applicable)",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[]
[null,null,"Average Vehicle Occupancy",null,null,null,"No Build","Build",null,null,null,null,"Expected Annual Maintenance/"]
[null,null,null,"On HOV/HOT Lanes",null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,null,"Other Traffic - Peak"]
[null,null,null,"Other Traffic - Non-Peak",null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Transit Input Sheet","index":5,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,3,2,4],[4,3,4,4],[5,3,5,4],[2,8,2,12],[3,8,3,13],[4,8,4,13],[38,6,38,7],[48,4,48,7],[48,11,48,13],[48,16,48,18],[41,6,41,7],[43,6,43,7],[47,4,47,18],[32,6,32,7],[34,6,34,7],[35,6,35,7],[36,6,36,7],[3,16,3,19],[4,16,4,19],[5,16,5,19],[30,6,30,7]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Rail or Transit Project"]
[]
[null,"SPI",null,null,null,null,"Rail Corridor",null,null,null,null,null,null,null,null,null,"Parallel Highway(s):"]
[null,null,null,null,null,null,"Project Description"]
[null,"District",null,null,null,null,"Project Limits",null,"(include rail mileposts)"]
[null,"County",null,null,null,null,"Joint Commuter Rail",null,"  Yes / No   ",null,null,null,"With (Agency)"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,null,"RAIL OR TRANSIT DATA"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Annual Person-Trips",null,null,null,"No Build","Build"]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,null,null,"Base (Year 1)"]
[null,null,null,"Passenger Rail",null,null,null,null,"Exclusive",null,null,null,null,"Forecast (Year 20)"]
[null,null,null,"Light-Rail Transit (LRT)",null,null,null,null,"Bus ROW",null,null,null,"Percent Trips during Peak Period"]
[null,null,null,"Bus Transit",null,null,null,null,null,null,null,null,"Percent New Trips from Parallel Highway"]
[null,null,null,"Vehicle Location (AVL)",null,null,null,null,"(yes or no)"]
[null,null,null,"Vehicle Signal Priority",null,null,null,null,null,null,null,null,"Annual Vehicle-Miles",null,null,null,"No Build","Build"]
[null,null,null,"Bus Rapid Transit (BRT)",null,null,null,null,null,null,null,null,null,"Base (Year 1)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecast (Year 20)"]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,null,"Average Vehicles/Train (if rail project)"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Reduction in Transit Accidents"]
[null,null,"Length of Construction Period",null,null,null,null,null,"years",null,null,null,"(if safety-related project)"]
[null,null,"Length of Peak Period",null,null,null,null,null,"hours"]
[null,null,"Project Length",null,null,null,null,null,"miles",null,null,null,null,null,null,null,"Transit",null,"Savings"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Average Travel Time (in minutes)",null,null,null,"No Build","Build","vs. Hwy."]
[null,null,null,null,null,null,null,null,null,null,null,null,"In-Vehicle","Non-Peak"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Out-of-Vehicle","Non-Peak"]
[null,"PROJECT COSTS",null,null,null,null,null,null,null,null,null,null,null,"Peak"]
[null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[]
[null,null,null,"Project Support Costs",null,null,null,null,null,null,null,"PARALLEL HIGHWAY DATA (indicate if 1 or 2 directional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Highway Design"]
[null,null,null,"Right-Of-Way Costs",null,null,null,null,null,null,null,null,null,"Road Type (Fwy, Exp, Conv Hwy)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Traffic Lanes"]
[null,null,null,null,null,null,null,null,"Year 1",null,null,null,null,"Free-Flow Speed"]
[null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,"Construction Costs",null,null,null,null,"Year 3",null,null,null,"Average Daily Traffic"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Current"]
[null,null,null,"Mitigation/Other Costs",null,null,null,null,null,null,null,null,null,"Forecast (Year 20)"]
[]
[null,null,null,"Expected Annual Maintenance/"]
[null,null,null,"Operations Costs",null,null,null,null,null,null,null,"AGENCY COSTS (If automatic vehicle location, signal priority, or BRT project)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,null,"Rehabilitation Costs ",null,null,null,null,"Year:",null,null,null,"Annual Capital Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Annual Operations and Maintenance Expendure"]
[]
[]
[null,"COMMENTS:"]
[null,"Prepared by:",null,null,null,null,null,null,null,null,"Phone No:    ",null,null,null,null,"E-Mail:    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.",null,"E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447. For questions, contact:",null,null,null,null,null,null,null,null,null,null,"Rose Agacer","(916) 651-6014",null,"rose_agacer@dot.ca.gov"]

{"sheet":"Rail Crossing Input Sheet","index":6,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[4,15,4,16],[5,15,5,16],[28,13,28,14],[30,13,30,14],[37,13,37,14],[35,13,35,14],[40,13,40,14],[42,13,42,14],[46,13,46,16],[48,7,48,8],[45,4,46,11],[4,4,5,7],[2,6,2,7],[32,13,32,14],[33,13,33,14],[34,13,34,14]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Highway-Rail Grade Crossing Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Rail Corridor:"]
[null,null,null,null,null,null,null,null,null,null,null,"Rail Milepost:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,"Highway Route:",null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,"Highway Post Mile:",null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Hwy-Rail Grade Crossing Improvement",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"Other (describe:                                            )",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,null,null,"No Build","Build"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)",null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[null,null,"Highway Design",null,null,null,"No Build","Build"]
[null,null,null,"Roadway Type (Exp. or Conv. Hwy.)"]
[null,null,null,"Number of General Traffic Lanes"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,null,null,"PROJECT COSTS"]
[null,null,null,"Project Length (in miles)",null,null,null,null,null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build",null,null,null,null,"Project Support Costs"]
[null,null,null,"Current"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[null,null,null,"Percent Trucks (include RVs, if applicable)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,"HIGHWAY-RAIL GRADE CROSSING DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,"Grade Crossing Statistics",null,null,null,"Current","Year 20"]
[null,null,null,"Number of Trains in One Year",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[null,null,null,"Average Gate Down Time (in minutes)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,"Grade Crossing Acc. Data (from FRA WBAPS)",null,null,null,"# Killed","# Injured",null,null,null,null,"Operations Costs"]
[null,null,null,"Actual Ten-Year Accident Data"]
[null,null,null,"Predicted Collisions",null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Park and Ride Input Sheet","index":7,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":false,"merged":[[44,5,44,6],[47,4,48,12],[48,14,48,17],[50,7,50,8],[2,6,2,7],[4,4,5,7],[37,5,37,6],[39,5,39,6],[40,5,40,6],[42,5,42,6]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Park and Ride Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"DESTINATION INFORMATION"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Destination Description",null,null,"Dest 1","Dest 2","Dest 3"]
[null,null,null,"New Park and Ride Lot",null,null,null,null,null,null,null,null,"Destination Name"]
[null,null,null,"Park and Ride Leased Lot",null,null,null,null,null,null,null,null,"Distance from Park-and-Ride Lot (miles)"]
[null,null,null,"Park and Ride Lot Expansion",null,null,null,null,null,null,null,null,"Distance to Next Lot (miles)"]
[null,null,null,"Other (describe:                                            )",null,null,null,null,null,null,null,null,"Parking Cost at Destination (avg $/day)"]
[]
[null,null,"Project Location "]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,"Demand for Travel to Destination",null,null,"Dest 1","Dest 2","Dest 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent of Lot Users to Destination"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,null,null,{"$f":"IF(OR(SUM(O18:Q18)=100%,SUM(O18:Q18)=0%),\"\",\"Destination percents must sum to 100%\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Distribution","New Transit Riders"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(percent)","Existing Transit Riders"]
[null,"PARK-AND-RIDE LOT INFORMATION",null,null,null,null,null,null,null,null,null,null,null,"New Carpoolers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Existing Carpoolers"]
[null,null,"Lot Design",null,null,null,"No Build","Build"]
[null,null,null,"Number of Parking Spaces",null,null,0,null,null,null,null,null,null,null,{"$f":"IF(OR(SUM(O20:O23)=100%,SUM(O20:O23)=0%),\"\",\"Sum to 100%\")","v":""},{"$f":"IF(OR(SUM(P20:P23)=100%,SUM(P20:P23)=0%),\"\",\"Sum to 100%\")","v":""},{"$f":"IF(OR(SUM(Q20:Q23)=100%,SUM(Q20:Q23)=0%),\"\",\"Sum to 100%\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Highway Travel to Destination",null,null,"Dest 1","Dest 2","Dest 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"HOV Travel Time (in min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Non-HOV Travel Time (in min)"]
[null,null,"Park-and-Ride Demand",null,null,null,"No Build","Build"]
[null,null,null,"Typical Percent Filled (for current or opening year)",null,null,null,null,null,null,null,null,"Accident Rate (per million vehicle-miles)"]
[null,null,null,"Number of Years until Lot Reaches Capacity",null,null,null,null,null,null,null,null,"Percent Fatal Accidents (Pct Fat)"]
[null,null,null,"Number of Bicycle/Pedestrian Users",null,null,null,null,null,null,null,null,"Percent Injury Accidents (Pct Inj)"]
[null,null,null,"Average Vehicle Occupancy of Lot Users",null,null,1,{"$f":"AVONB","v":1}]
[]
[null,"PROJECT COSTS",null,null,null,null,null,null,null,null,null,"Transit Travel to Destination",null,null,"Dest 1","Dest 2","Dest 3"]
[null,"Enter the net costs of the project in today's dollars ($ thousands)",null,null,null,null,null,null,null,null,null,null,"Express Bus","Travel Time (in min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Fare"]
[null,null,null,"Right-of-Way Costs",null,null,null,null,null,null,null,null,null,"Headway (in min)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Local Bus","Travel Time (in min)"]
[null,null,null,null,null,null,null,"Year 1",null,null,null,null,null,"Average Fare"]
[null,null,null,"Construction Costs",null,null,null,"Year 2"]
[]
[null,null,null,"Project Support/Other Costs",null,null,null,null,null,null,null,"Carpool/Vanpool Travel to Destination",null,null,"Dest 1","Dest 2","Dest 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Average Carpool Size (people/vehicle)"]
[null,null,null,"Expected Annual O&M Costs",null,null,null,null,null,null,null,null,"Average Carpool Wait Time (in min)"]
[]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Ramp Input Sheet","index":8,"n_rows":52,"n_cols":16,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,15,4,16],[5,15,5,16],[26,13,26,14],[28,13,28,14],[35,13,35,14],[33,13,33,14],[38,13,38,14],[40,13,40,14],[47,4,47,11],[47,13,47,16],[49,7,49,8],[2,6,2,7],[4,4,5,7],[30,13,30,14],[31,13,31,14],[32,13,32,14]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Ramp Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Auxiliary Lane",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"HOV Drop Ramp",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Off-Ramp Widening",null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"On-Ramp Widening",null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"Project Location "]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,"Rate Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Accident Rate (per mil. vehicles)"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)",null,null,null,null,null,null,null,null,"PROJECT COSTS"]
[null,null,"Highway Design",null,null,null,"No Build","Build","HOV",null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,"Restriction"]
[null,null,null,"Number of HOV Lanes",null,null,null,null,null,null,null,null,"Project Support Costs"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,"(2 or 3 )"]
[null,null,null,"Ramp Design Speed (in mph)",null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[null,null,null,"Project Length (in miles)"]
[null,null,null,"Area Impacted by Weaving (in miles)",null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build",null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,null,"Current"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[]
[null,null,"Average Hourly HOV Traffic (if HOV lanes)",null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,"Percent Trucks (include RVs, if applicable)",null,null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,"Percent Traffic in Weave"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[null,null,"On-Ramp Volume",null,null,null,"No Build","Build"]
[null,null,null,"Hourly Ramp Volume"]
[null,null,null,"Metering Strategy (cars per green, if on-ramp)"]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Highway TMS Input Sheet","index":9,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[45,4,45,11],[45,13,45,16],[47,7,47,8],[2,6,2,7],[4,4,5,7],[31,13,31,14],[32,13,32,14],[29,13,29,14],[36,13,36,14],[39,13,39,14],[41,13,41,14],[4,15,4,16],[5,15,5,16],[27,13,27,14],[33,13,33,14],[34,13,34,14]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Highway TMS Project"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Ramp Metering",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"Signal Coordination with Ramp Metering",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Incident Management",null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"Traveler Information",null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,"Arterial Signal Management",null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,null,null,null,"No Build","Build"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,"Percent Injury Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Collision Reduction Factor (if applicable)"]
[]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)",null,null,null,null,null,null,null,null,"PROJECT COSTS"]
[null,null,null,null,null,null,null,null,null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,"Highway Design",null,null,null,"No Build","Build","HOV"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,"Restriction",null,null,null,"Project Support Costs"]
[null,null,null,"Number of HOV Lanes"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,"(2 or 3 )",null,null,null,"Right-of-Way Costs"]
[null,null,null,"Project Length (in miles)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build",null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,null,"Current"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[]
[null,null,"Average Hourly HOV Traffic (if HOV lanes)",null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,"Percent Trucks (include RVs, if applicable)",null,null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,"Is detailed model data available? (yes/no)"]
[null,null,"If yes, please attach speed and volume data for the highway, ramps, and arterials,",null,null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[null,null,"as appropriate, for Year 1 and Year 20."]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Queuing Input Sheet","index":10,"n_rows":51,"n_cols":16,"rows_kept":51,"cut":false,"hidden":false,"merged":[[48,7,48,8],[37,13,37,14],[40,13,40,14],[45,4,46,11],[4,4,5,7],[34,13,34,14],[35,13,35,14],[28,13,28,14],[30,13,30,14],[2,6,2,7],[32,13,32,14],[33,13,33,14],[42,13,42,14],[46,13,46,16],[4,15,4,16],[5,15,5,16]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Special (queuing)"]
[]
[null,null,"District: ",null,null,"County:",null,null,null,null,null,"Route:"]
[null,null,null,null,null,null,null,null,null,null,null,"Post mile:"]
[null,null,"Project:",null,null,null,null,null,null,null,null,null,null,null,"EA:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPNO:"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,"HIGHWAY ACCIDENT DATA"]
[]
[null,null,"Issue Addressed by Project",null,null,null,"Enter \"X\"",null,null,null,null,"Actual 3-Year Accident Data (from TASAS Table B)"]
[null,null,null,"Lane Drop",null,null,null,null,null,null,null,null,null,null,null,"Count (No.)"]
[null,null,null,"Geometric Restriction (describe:                   )",null,null,null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Other (describe:                                            )",null,null,null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,"Project Location ",null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)"]
[null,null,null,null,null,null,null,null,null,null,null,"Statewide Basic Average Accident Rate"]
[null,null,"Length of Construction Period",null,null,null,null,"years",null,null,null,null,null,null,"No Build","Build"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rate Group"]
[null,null,"Length of Peak Period",null,null,null,null,"hours",null,null,null,null,"Accident Rate (per mil. veh-mi)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Fatal Accidents"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Percent Injury Accidents"]
[]
[null,"HIGHWAY DESIGN AND TRAFFIC DATA (indicate if 1 or 2 directional)"]
[]
[null,null,"Highway Design",null,null,null,"No Build","Build",null,null,"PROJECT COSTS"]
[null,null,null,"Roadway Type (Fwy, Exp, Conv Hwy)",null,null,null,null,"HOV",null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,"Number of General Traffic Lanes",null,null,null,null,"Restriction"]
[null,null,null,"Number of HOV Lanes",null,null,null,null,null,null,null,null,"Project Support Costs"]
[null,null,null,"Highway Free-Flow Speed (in mph)",null,null,null,null,"(2 or 3 )"]
[null,null,null,"Area Impacted (in miles)",null,null,null,null,null,null,null,null,"Right-of-Way Costs"]
[]
[null,null,"Average Daily Traffic",null,null,null,"No Build","Build",null,null,null,null,null,null,null,"Year 1"]
[null,null,null,"Current",null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,"Forecast (20 years after construction)",null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,"Year 4"]
[null,null,null,"Average Hourly HOV Traffic (if HOV lanes)"]
[null,null,null,"Percent Trucks (include RVs, if applicable)",null,null,null,null,null,null,null,null,"Mitigation/Other Costs"]
[]
[null,null,"Queue Formation (in vehicles per hour)",null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,null,"Upstream Flow (during queue growth)",null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,null,"Upstream Flow (during queue dissipation)"]
[null,null,null,"Downstream Flow",null,null,null,null,null,null,null,null,"Rehabilitation Costs ",null,null,"Year:"]
[]
[]
[]
[null,"COMMENTS:",null,null,null,null,null,null,null,null,null,null,"E-Mail:    "]
[]
[null,"Prepared by:",null,null,null,null,"Phone No:    "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.","E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447.   For questions, contact:",null,null,null,null,null,null,null,"Rose Agacer",null,null,"(916) 651-6014","rose_agacer@dot.ca.gov"]

{"sheet":"Active Transportation","index":11,"n_rows":68,"n_cols":20,"rows_kept":68,"cut":false,"hidden":false,"merged":[[5,3,5,4],[5,17,5,20],[5,9,5,14],[29,5,29,6],[2,3,2,4],[2,9,2,13],[3,9,3,14],[3,17,3,20],[4,3,4,4],[4,9,4,14],[4,17,4,20],[64,12,64,14],[10,17,10,18],[12,17,12,18],[14,17,14,18],[15,17,15,18],[16,17,16,18],[17,17,17,18],[20,17,20,18]]}
["BENEFIT/COST ANALYSIS INPUT SHEET - Active Transportation Project"]
[]
[null,"SPI",null,null,null,null,"Facility Corridor",null,null,null,null,null,null,null,null,null,null,"Nearby Roadway(s)"]
[null,null,null,null,null,null,"Project Description"]
[null,"District",null,null,null,null,"Project Limits"]
[null,"County",null,null,null,null,"Implementing Agency"]
[]
[null,"PROJECT DATA",null,null,null,null,null,null,null,null,null,null,"INFRASTRUCTURE PROJECT AND NON-INFRASTRUCTURE PROGRAM COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Enter the net costs of the project in today's dollars ($ thousands)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Project Costs  "]
[null,null,"Type of Project",null,null,null,"Enter \"X\"",null,"Characteristics",null,null,null,null,null,"Project Support Costs"]
[null,null,null,"Existing Bike/Pedestrian Facility Improvement",null,null,null,null,null,"Length (Miles)"]
[null,null,null,"Existing Bike/Intersection Improvement",null,null,null,null,null,"Number of Intersections",null,null,null,null,"Right-of-Way Costs"]
[null,null,null,"New Bike/Pedestrian Facility Development",null,null,null,null,null,"Length (Miles)"]
[null,null,"Other Characteristics",null,null,null,"Enter \"X\"",null,null,null,null,null,null,null,null,null,null,null,null,"Year 1"]
[null,null,null,"Safe Routes to School (SRTS) Access",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,"Non-Infrastructure Program",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction Costs",null,null,null,null,"Year 4"]
[null,null,"Project Location "]
[null,null,"(enter 1 for So. Cal., 2 for No. Cal., or 3 for rural)",null,null,null,null,null,null,null,null,null,null,null,"Expected Annual Maintenance/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operations Costs"]
[null,null,"Length of Construction Period",null,null,null,null,null,null,"years"]
[null,null,"Length of Peak Period",null,null,null,null,null,null,"hours",null,null,null,"Program Costs"]
[null,null,"Project Length",null,null,null,null,null,null,"miles",null,null,null,null,"Program Set-up Costs",null,null,null,null,"Year 1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Program Costs"]
[]
[null,"PROJECT CHARACTERISTICS"]
[null,"Improvement Characteristics",null,null,null,null,null,null,null,null,null,null,"INTERSECTION ACCIDENT DATA"]
[null,null,"Existing Facility Length, if Applicable",null,null,"Existing",null,null,"New"]
[null,null,null,null,null,"No Build","Build",null,"Build",null,null,null,null,"Actual 5-Year Accident Data"]
[null,null,null,"Bike Paths (miles) ",null,null,null,null,null,"Class I",null,null,null,null,null,null,null,"Cyclists","Pedestrians"]
[null,null,null,"Bike Lanes (miles) ",null,null,null,null,null,"Class II",null,null,null,null,null,null,"Total Accidents (Tot)"]
[null,null,null,"Bike Route (miles) ",null,null,null,null,null,"Class III",null,null,null,null,null,null,"    Fatal Accidents (Fat)"]
[null,null,null,"Separated Bikeways, Cycle Tracks (miles) ",null,null,null,null,null,"Class IV",null,null,null,null,null,null,"    Injury Accidents (Inj)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"    Property Damage Only (PDO) Accidents"]
[null,null,"Pedestrian Improvements"]
[null,null,null,"Street Lighting ",null,null,null,null,null,"Yes =1 or No=0"]
[null,null,null,"Curb Level ",null,null,null,null,null,"Yes =1 or No=0",null,null,null,"Safety Countermeasures (improvements to existing facilities only)"]
[null,null,null,"Crowding ",null,null,null,null,null,"Yes =1 or No=0"]
[null,null,null,"Pavement Evenness ",null,null,null,null,null,"Yes =1 or No=0",null,null,null,"Signalized Intersection",null,null,null,"Yes =1"]
[null,null,null,"Information Panels ",null,null,null,null,null,"Yes =1 or No=0",null,null,null,"Pedestrian Countdown Signal Heads"]
[null,null,null,"Benches ",null,null,null,null,null,"Yes =1 or No=0",null,null,null,"Pedestrian Crossing"]
[null,null,null,"Directional Signage ",null,null,null,null,null,"Yes =1 or No=0",null,null,null,"Advance Stop Bar before Crosswalk"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Install Overpass/Underpass"]
[null,"Trip Data - Adults",null,null,null,null,null,null,null,null,null,null,null,"Unsignalized Intersection"]
[null,null,"Cycling",null,null,null,null,null,null,null,null,null,null,"Raised Medians/Refuge Islands"]
[null,null,null,"Daily Trips (Single Direction)",null,null,null,null,null," trips / day",null,null,null,"Pedestrian Crossing (new signs and markings only)"]
[null,null,null,"Projected Annual Growth Rates",null,null,null,null,null,"% change / year",null,null,null,"Pedestrian Crossing (safety features/curb extensions)"]
[null,null,"Pedestrian",null,null,null,null,null,null,null,null,null,null,"Pedestrian Signals"]
[null,null,null,"Daily Trips (Single Direction)",null,null,null,null,null," trips / day",null,null,null,"Roadways - these issues may not be used to influence benefits"]
[null,null,null,"Projected Annual Growth Rates",null,null,null,null,null,"% change / year",null,null,null,"Bike Lanes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Sidewalk/Pathway (to avoid walking along roadway)"]
[null,"Trip Data - Children - SRTS",null,null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing (with enhanced safety features)"]
[null,null,"Cycling",null,null,null,null,null,null,null,null,null,null,"Pedestrian Crossing"]
[null,null,null,"Daily Trips (Single Direction)",null,null,null,null,null," trips / day",null,null,null,"Other Reduction Factor Countermeasures"]
[null,null,null,"Projected Annual Growth Rates",null,null,null,null,null,"% change / year"]
[null,null,"Pedestrian"]
[null,null,null,"Daily Trips (Single Direction)",null,null,null,null,null," trips / day"]
[null,null,null,"Projected Annual Growth Rates",null,null,null,null,null,"% change / year"]
[]
[]
[null,"COMMENTS:"]
[]
[null,"Prepared by:",null,null,null,null,null,null,null,null,null,"Phone No:    ",null,null,null,null,"E-Mail:    "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone No.",null,"E-Mail"]
[null,"The HQ Division of Transportation Planning FAX number is ATSS 8-453-1447. For questions, contact:",null,null,null,null,null,null,null,null,null,null,null,"Rose Agacer","(916) 651-6014",null,"rose_agacer@dot.ca.gov"]