{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["User Guide","CAT Tool"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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":"User Guide","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CAT Tool","index":1,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[37,0,37,5],[40,1,40,5],[41,1,41,5],[42,1,42,5],[21,1,21,3],[22,1,22,3],[24,1,24,3],[33,0,33,5],[34,0,34,2],[35,0,35,2],[36,0,36,2],[39,1,39,5],[31,0,31,5],[28,1,28,3],[29,1,29,3],[19,0,29,0],[19,1,19,3],[18,0,18,3],[20,1,20,3],[26,1,26,3],[27,1,27,3],[25,1,25,3],[12,0,12,1],[12,2,12,5],[13,0,13,1],[13,2,13,5],[14,0,14,1],[14,2,14,5],[32,0,32,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[3,1,5,5],[6,0,6,5],[7,0,7,1],[7,2,7,5],[8,0,8,1],[8,2,8,5],[9,0,9,1],[9,2,9,5],[10,0,10,1],[10,2,10,5],[11,0,11,1],[11,2,11,5]]}
[null,"Caltrans Affordable Housing Trip Generation Tool - CAT Tool"]
[null,"September 2018"]
[null,"Developed by Portland State University for the California Department of Transportation*"]
[null,"* Not recommended for sites within rural areas.  For estimating site vehicle and person trip generation for affordable multifamily developments that are open to all (not exclusively serving special populations). Estimates for developments with characteristics outside the recommend ranges for model inputs should be applied with care."]
[]
[]
["Site Description"]
["Project name"]
["Land use description"]
["Address, city, state"]
["Analyst’s name, organization, date"]
["Checked by, date"]
["Analysis year"]
["Analysis period",null,"Typical Weekday Site Peak Hour between 7 and 10 AM & between 4 and 7 PM"]
["Additional comments"]
[]
[]
[]
["Model Inputs",null,null,null,"Input is out of recommended range","Enter values in the orange boxes","Check variables are within range","Check variables are inputted"]
["Development &\nBuilt Environment","Total Dwelling Units (recommended range between 23 - 121)",null,null,{"$f":"IF(H20=FALSE,\"\",IF(G20,\"\",\"Out of Range\"))","v":""},null,{"$f":"IF(AND(23<=ToTDU,ToTDU<=121),TRUE,FALSE)","v":false},{"$f":"IF(ToTDU=\"\",FALSE,TRUE)","v":false},{"$f":"IF(AND(G20=1,ToTDU<>\"\"),\"Please enter a number between 20 and 120 units\",\"\")","v":""}]
[null,"Occupied number of Studio apartments"]
[null,"Occupied number of 1-bedroom apartments"]
[null,"Occupied number of 2-bedrooms apartments"]
[null,"Occupied number of 3-bedrooms apartments"]
[null,"Occupied number of 4-bedrooms apartments",null,null,null,null,{"$f":"IF(AND(ToTODU<>\"Revise Inputs\",ToTODU<>\"\",ToTODU<>\"Missing information\"),0,1)","v":1},null,null,null,"INITIAL ESTIMATES"]
[null,"Total number of occupied dwelling units (recommended range 23 - 121)",null,null,{"$f":"IF(H26=FALSE,\"\",IF(G26,\"\",\"Out of Range\"))","v":""},{"$f":"IF(OR(SUM(F21:F25)<0,ToTDU<SUM(F21:F25),F21<0,F22<0,F23<0,F24<0,F25<0),\"Revise Inputs\",IF(SUM(F21:F25)=0,\"Missing information\",SUM(F21:F25)))","v":"Missing information"},{"$f":"IF(AND(23<=ToTODU,ToTODU<=121),TRUE,FALSE)","v":false},{"$f":"IF(OR(ToTODU=\"\",ToTODU=\"Revise Inputs\",ToTODU=\"Missing information\"),FALSE,TRUE)","v":false},{"$f":"IF(AND(G26=1,ToTODU<>\"\"),\"Please revise number of occupied apartments bedroom size or total apartments\",\"\")","v":""},null,"PT","AT"]
[null,"Average bedroom size for occupied units (recommended range 0 - 2.8)",null,null,{"$f":"IF(H26=FALSE,\"\",IF(G27,\"\",\"Out of Range\"))","v":""},{"$f":"IFERROR((IF(ToTODU=\"\",\"Missing information\",((F21*0+F22*1+F23*2+F24*3+F25*4)/ToTODU))),\"Missing information\")","v":"Missing information"},{"$f":"IF(AND(0<=AvgBdr,AvgBdr<=2.8),TRUE,FALSE)","v":false},null,{"$f":"IF(AND(G27=1,AvgBdr<>\"\"),\"Please revise number of occupied apartments bedroom size\",\"\")","v":""},"AM",{"$f":"0.78*AvgBdr-0.005*EmplDen","v":{"$error":"#VALUE!"}},{"$f":"0.19*AvgBdr+0.24*PrkRat-0.002*EmplDen","v":{"$error":"#VALUE!"}}]
[null,"Parking spaces dedicated for residents",null,null,null,null,null,null,null,"PM",{"$f":"0.5*AvgBdr-0.003*EmplDen","v":{"$error":"#VALUE!"}},{"$f":"0.11*AvgBdr-0.002*ToTDU+0.15*PrkRat-0.001*EmplDen","v":{"$error":"#VALUE!"}}]
[null,"Parking per total dwelling unit ratio (recommended range 0.6 - 2.9)",null,null,{"$f":"IF(H29=FALSE,\"\",IF(G29,\"\",\"Out of Range\"))","v":""},{"$f":"IFERROR(IF(Prk<>\"\",Prk/ToTDU,\"Missing information\"),\"Missing information\")","v":"Missing information"},{"$f":"IFERROR(IF(AND(0.6<=PrkRat,PrkRat<>\"\",PrkRat<=2.9),TRUE,FALSE),1)","v":false},{"$f":"IF(OR(Prk=\"\",PrkRat=\"Missing information\"),FALSE,TRUE)","v":false},{"$f":"IF(AND(G29=1,PrkRat<>\"\"),\"Please revise number of parking spaces or total dwelling units\",\"\")","v":""},null,"Rate >= 0?"]
[null,"Employment density (jobs per acre) for the Census block group where the development is located (recommended values between 1 and 273)1",null,null,{"$f":"IF(H30=FALSE,\"\",IF(G30,\"\",\"Out of Range\"))","v":""},null,{"$f":"IF(AND(1<= EmplDen, EmplDen<=273),TRUE,FALSE)","v":false},{"$f":"IF(EmplDen=\"\",FALSE,TRUE)","v":false},{"$f":"IF(AND(G30=1,EmplDen<>\"\"),\"Please revise number of employment density\",\"\")","v":""},null,"PT","AT"]
[null,null,null,null,null,null,"Summary",null,null,"AM",{"$f":"IF(K27>=0,TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(L27>=0,TRUE,FALSE)","v":{"$error":"#VALUE!"}}]
["Model Outputs",null,null,null,null,null,{"$f":"IF(AND(G30,G29,G27,G26,G20),TRUE,FALSE)","v":false},{"$f":"IF(AND(H20,H26,H29,H30),TRUE,FALSE)","v":false},null,"PM",{"$f":"IF(K28>=0,TRUE,FALSE)","v":{"$error":"#VALUE!"}},{"$f":"IF(L28>=0,TRUE,FALSE)","v":{"$error":"#VALUE!"}}]
["Are inputs within the range of the sites used to develop this tool?",null,null,null,null,{"$f":"IFERROR(IF($H$32<>TRUE,\"Missing Inputs.\",IF($G$32<>TRUE,\"One or more inputs are outside of the recommended range. Please apply resulting rates with caution.\",\"Yes.\")),\"Missing Inputs.\")","v":"Missing Inputs."}]
["Estimated Trips per Occupied Dwelling Unit\n(for peak hour of the adjacent street)"]
["Period",null,null,"    Person trips per occupied dwelling unit",null,"Motorized vehicle trips per occupied dwelling unit"]
["AM Peak Hour*",null,null,{"$f":"IFERROR(IF($H$32,IF(K31,K27,\"Model cannot provide valid estimates for sites with this combination of attributes.\"\n),\"Missing Inputs\"),\"Missing Inputs\")","v":"Missing Inputs"},null,{"$f":"IFERROR(IF($H$32,IF(L31,L27,\"Model cannot provide valid estimates for sites with this combination of attributes.\"),\"Missing Inputs\"),\"Missing Inputs\")","v":"Missing Inputs"}]
["PM Peak hour*",null,null,{"$f":"IFERROR(IF($H$32,IF(K32,K28,\"Model cannot provide valid estimates for sites with this combination of attributes.\"),\"Missing Inputs\"),\"Missing Inputs\")","v":"Missing Inputs"},null,{"$f":"IFERROR(IF($H$32,IF(L32,L28,\"Model cannot provide valid estimates for sites with this combination of attributes.\"),\"Missing Inputs\"),\"Missing Inputs\")","v":"Missing Inputs"}]
["* As defined by the Institute of Transportation Engineers: the highest trip rate for a one-hour period during the peak period of interest."]
["Sources:"]
[1,"2015 LEHD Workplace Area Characteristics (WAC) All Jobs (JT00), Total Jobs (S000), Total Number of Jobs (C000); Divided by Census Block Group area (acres)"]