Skip to main content

Currently Skimming:


Pages 39-69

The Chapter Skim interface presents what we've algorithmically identified as the most significant single chunk of text within every page in the chapter.
Select key terms on the right to highlight them within pages of the chapter.


From page 39...
... 39 The following are step-by-step instructions showing the user how to perform the different analyses available in the Rural Transit Need and Demand Spreadsheet. Each of the analyses is performed along with discussion of how to collect the necessary data and where to enter the information.
From page 40...
... 40 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation certificate was not issued by a licensed certificate dealer, authorized by Microsoft, the user must complete the following steps to accept LSC's certificate. NOTE: These procedures are not necessary if macro security is set to Low.
From page 41...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 41 Office 2007 users must take these additional steps: Macros will likely be automatically disabled on opening the spreadsheet.
From page 42...
... 42 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 3. Excel 2007 Options Menu.
From page 43...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 43 Figure 6. Excel 2007 Digital Signature Details Menu.
From page 44...
... 44 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 8. Excel 2007 Certificate Import Wizard.
From page 45...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 45 5. The Analysis Setup tab allows the user to choose the appropriate analysis or analyses they would like to perform (Figure 10)
From page 46...
... 46 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 10. Analysis Setup Tab.
From page 47...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 47 3. Access the ACS4 via the website link (1)
From page 48...
... 48 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Table 1. ACS Table B17001 – Bedford County, VA.
From page 49...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 49 The following is the manual computation of the number of persons in need of public transportation for Bedford County using the TCRP Project B36 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Workbook as a check to the spreadsheet values produced. PERSONS HAVING TRANSPORATION NEED Number of= Persons Below the Poverty Level Number o+ f Persons with No Vehicle Available NEED = 5,897 1 789 2 274 3 112 4 18 5 897 + × + × + × + × = [( )
From page 50...
... 50 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation 2. Click the Input tab at the bottom of the spreadsheet.
From page 51...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 51 ANNUAL TRIP NEED = × ≈1 551 300 465 300, , Note: to determine UNMET NEED, it is necessary to know how many trips are being served by existing passenger transportation services. The number of trips being served can be determined from surveys or interviews with agencies or transportation service providers in the area of interest.
From page 52...
... 52 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation 4. Enter the appropriate information related to each program (3)
From page 53...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 53 ESTIMATED PROGRAMTRIPS meals( )
From page 54...
... 54 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation size. A factoring of the households must be done to produce a figure of persons with no access to a vehicle (4)
From page 55...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 55 Demand – General Public Rural Passenger Transportation (refer to Figures 20 and 21)
From page 56...
... 56 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 17. Demand - Program (Output Tab)
From page 57...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 57 Figure 18. Demand - Non-Program (Input Tab)
From page 58...
... 58 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation 1. Select the Demand – Small City Fixed Rural box on the Analysis tab.
From page 59...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 59 4. Click the Output tab at the bottom of the spreadsheet.
From page 60...
... 60 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation 2. Click the Input tab at the bottom of the spreadsheet.
From page 61...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 61 e. The OnTheMap results map (Figure 29)
From page 62...
... 62 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 21. Demand - General Public Rural Passenger Transportation (Output)
From page 63...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 63 Source: U.S. Census Bureau, 2006-2010 American Community Survey Table 8.
From page 64...
... 64 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 22. Demand - Small City (Input Tab)
From page 65...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 65 Figure 23. Demand - Small City (Output)
From page 66...
... 66 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 24. Demand – Commuters (Input Tab)
From page 67...
... Step-By-Step Instructions for the Transit Need and Demand Spreadsheet Tool 67 Figure 26. LEHD OnTheMap Program Search Page.
From page 68...
... 68 Methods for Forecasting Demand and Quantifying Need for Rural Passenger Transportation Figure 28. OnTheMap Analysis Settings.
From page 69...
... Figure 30. Determining Commuter Distance.

Key Terms



This material may be derived from roughly machine-read images, and so is provided only to facilitate research.
More information on Chapter Skim is available.