August 27


Trip gen Back in November I posted about the freshly printed 8th Edition of Trip Generation.  I received several requests for trip generation data, so in an effort to help the industry we've put together a spreadsheet with all of the a.m., p.m., and daily trip generation rates.  With the few land uses where we feel it makes sense to use the trip generation equations, we include those in addition to the average rates.  The spreadsheet also includes pass-by rates from the 2nd Edition of the Trip Generation Handbook.  Here it is (REMOVED BASED ON ITE LEGAL REQUEST).  Details about the spreadsheet are contained on the top and bottom, so scroll all the way down before you ask me any questions.

Caveat emptor -  we have done our best to assure the data is accurate (since we plan on using the spreadsheet ourselves).  If you find any errors, please let us know and we'll post the corrected spreadsheet.

Special thanks to the apprentices – Mike Bultman, Joe Collins, Jenni Hattervig, and Kirk Pettis.  They put in the time with the data entry and quality control. 


  • Hi Mike
    Stunning site, I have added it to my favorites. Just to say, I have no other favorites (say no more). Thanks for the ITE trip rates 8th edition spreadsheet. I was looking for Hotel rates. I will return and read more when time allows.

  • Hi Mike,
    Thanks so much for the Trip Generation Spreadsheet. I know how much work that is to put all of the data in! If you ever decide to start charging for it I would be happy to pay.

  • Mike,
    What is your experience with municipalities wanting the fitted curve equation over the average rate calculations. In most cases it generates more trips and in the developer’s world a higher cost participation fee. Is there any arguement to use against the fitted curve equation with the agencies when the trip generation is higher either way to use the lower number or is it acceptable everywhere to use the higher numbers. Therefore higher fees.

  • We don’t have impact fees in the states I’ve worked in, so it hasn’t been a big issue. We tend to follow the recommendations in the Trip Generation Handbook. We don’t automatically jump to the biggest number we can calculate.

  • Mike-
    great website. Ive read through your comments and thoughts and will be using some of them in discussions in a class. of course i acknowledged you in the intro 🙂

  • Mike: Do you know whether the ITE rates for assisted living (254) include ambulance trips? Thanks.

  • Dean: No guarantees, because the data is voluntarily submitted by traffic engineers, but it should include ambulances. Trip generation is supposed to cover every vehicle entering/exiting a site no matter what the purpose of the vehicle is.

  • Mike
    This excel sheet is great. I noticed that you did not add a column for weekend/saturday rates. What are the weekend/saturday rates for land use 943 if any?

  • Great spreadsheet, but wondering, is there any trip generation data for different typesofwaste processing facility – recycling plant, commercial biogas plant etc?

  • All of the land uses and their subsets that are in the Trip Generation report have been included in the spreadsheet.

  • Mike: What a great tool. I was wondering why line 41, Mini Warehouse 151, weekday employee rate is so high (61.90). I don’t have a copy of the actual handbook so I wasn’t sure if there was any further explanation. Thanks again.

  • I don’t have a definitive answer on the mini-warehouse. By employee they mean how many employees are there at a time. Many warehouses only have one employee on at a time, so I’m not sure it is that high of a number. I’d look at square feet or units.

  • Great spreadsheet! Thank you and your staff for the time to put it all together. When no data is available (like for Convenience Mkt open 16 hrs) for the Daily Total Trips, any advice on how to solve for it? A true blessing to find your site.

  • You can look at other similar land uses (some of the other gas stations categories in this case) to try to get a ratio of daily trip generation rate to p.m. peak hour rate. Then you can apply that ratio to the p.m. peak hour rate to develop the daily rate.

  • Spreadsheet looks very complex. We have a situation where a local main street has been closed and residents on an adjacent street have complained about increased “cut-through” traffic using their street to get to their final destination. Can your spreadsheet be used to determine/estimate this “cut-through” volume and if so, are there any unique/sensitive instructions on how to best use your spreadsheet. Thanks Mark

  • Mark – The quick answer is no. The only way to really get at “cut-through” traffic is to have before/after traffic counts. There are ways to address this, but it’s not a DIY effort – you need a traffic engineer.

  • Mike, I dont see the spreadsheet up any more. Can I still download it from somewhere else?

  • Any chance anyonercould send me a trip generation table for Land Use Code 850, Supermarkets?

  • I am sorry if this question might seem stupid but I am an undergraduate student doing a transportation engineering project. What am I supposed to write for the independent variable to get all the data for General office bldg and what is the difference for the equation row and the one that does not says equation.

    Thank you for your help and time!
    It looks like the Excel took a long time to make so thank you for sharing it!

  • You would use per 1,000s of square feet (ksf) as the variable. Most of the rows are based on an average rate. Their are a few rows that have best fit lines that are statistically valid.

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
    Mike Spack

    My mission is to help traffic engineers, transportation planners, and other transportation professionals improve our world.

    Get these blog posts sent to your email! Sign up below.