Excel Spreadsheet

Discussion Spreadsheet example of Summit calculations Excel

You must be logged in to download this document
Reviews
Shared by: PHMSA
Stats
views:
29
downloads:
0
rating:
not rated
reviews:
0
posted:
6/30/2008
language:
English
pages:
0
Illustrative Mode-Choice Calculations for Travel by One Market Segment between a Pair of Zones for Base and Alternative Scenarios Information item PERSON-TRIP production zone (I) INFORMATION attraction zone (J) total person trips from I to J item TRANSIT-ACCESS can-walk person trips CALCULATIONS must-drive person trips no-transit person trips item in-vehicle time (mins.) out-of-vehicle time (mins.) cost (cents) constant: transit/walk constant: transit/drive utility MODE-CHOICE exp(utility) CALCULATIONS can-walk sum[exp(utility)] can-walk mode shares can-walk trips by mode must-drive sum[exp(utility)] must-drive mode shares must-drive trips by mode no-transit trips by mode total trips by mode production zone (I) attraction zone (J) INFORMATION market segment total person trips ON RECORD motorized person trips PASSED TO SUMMIT FOR exp[utility(other modes)] USER-BENEFIT fraction, can-walk to transit CALCULATIONS transit share, can walk fraction, must-drive to transit transit share, must-drive Forecast for the Base Alternative zone # % walkable 11 75 20 50 mkt seg #1 100 mkt seg trips i-j 1 37.5 1 12.5 1 50.0 auto transit/walk transit/drive 20 40 40 3 30 40 240 125 125 0 1 0 0 0 1 -1.27 -3.175 -4.175 0.2808 0.0418 0.0154 0.3380 0.8309 0.1237 0.0455 31.2 4.6 1.7 0.2962 0.9481 --0.0519 11.9 --0.6 50.0 ----93.0 4.6 2.4 11 20 1 100.0 100.0 0.2808 0.3750 0.1691 0.1250 0.0519 Forecast for the Build Alternative zone # % walkable 11 100 20 75 mkt seg #1 100 mkt seg trips i-j 1 75.0 1 0.0 1 25.0 auto transit/walk transit/drive 22 30 25 3 30 30 240 125 125 0 1 0 0 0 1 -1.31 -2.975 -3.375 0.2698 0.0510 0.0342 0.3551 0.7599 0.1438 0.0964 57.0 10.8 7.2 0.3040 0.8875 --0.1125 0.0 --0.0 25.0 ----82.0 10.8 7.2 11 20 1 100.0 100.0 0.2698 0.7500 0.2401 0.0000 0.1125 Highlighted cells contain input values that can be changed to explore the properties of the mode choice calculations and the information written to the file passed to Summit. coefficients in the mode choice model -0.0200 in-vehicle time (mins.) -0.0500 out-of-vehicle time -0.0030 cost (cents) -0.5000 transit/walk constant -1.0000 transit/drive constant Note: illustrative only; approach works with any logit mode-choice model. Summit Calculations of Transit-Access Markets, User Benefits, and Capped User Benefits Build Alternative market can-walk must-drive no-transit base % 37.5% 12.5% 50.0% 0.0% 25.0% build % 75.0% 0.0% 0.0% gains 37.5% market % can-walk must-drive no-transit can-walk 37.5% 0.0% 0.0% must-drive 12.5% 0.0% 0.0% no-transit 25.0% 0.0% 25.0% total 75.0% 0.0% 25.0% Build Alternative market all e(Uoth) 0.2698 LS oth -1.3100 Poth (m.) 65.5 all dPoth (m.) all 2.0 Build Alternative uncapped With dPtrn cap (m.) = 45.0 must-drive no-transit applied to diagonal cells only 0.0342 --caps dPtrn e[U(dPtrn)] -3.3750 --max -45.0 2.4596 168.8 --max + 45.0 0.4066 must-drive no-transit can-walk must-drive no-transit 25.7 ---20.0 25.7 ---40.0 ---85.7 -40.0 ------------Build Alternative uncapped must-drive no-transit can-walk 0.0342 --0.0853 -1.1906 -1.3100 -1.0354 59.5 65.5 51.8 must-drive no-transit can-walk 5.3 11.3 -2.5 -1.3 4.7 -9.1 -4.0 2.0 -11.7 Build Alternative uncapped must-drive no-transit can-walk 0.0 0.0 92.5 0.0 0.0 113.3 0.0 -50.0 293.3 449.0 Build Alternative uncapped must-drive no-transit can-walk 0.0 0.0 152.0 0.0 0.0 134.5 0.0 0.0 336.7 623.3 Travel market classified jointly by access condition in the base Build Alternative and access condition in the build Build Alternative market can-walk must-drive no-transit total base % 37.5% 12.5% 50.0% 100.0% build % 75.0% 0.0% 25.0% 100.0% losses 0.0% 12.5% 25.0% 37.5% B a s e total 100.0% 100.0% 37.5% total 37.5% 12.5% 50.0% 100.0% Change in the price of travel by all other modes (minutes) B market all e(Uoth) 0.2808 LSoth -1.2700 Poth (m.) 63.5 Changes in the price of travel by transit (minutes) B a s e market can-walk must-drive no-transit e(Utrn) 0.0572 0.0154 --- LStrn -2.8617 -4.1750 --- Ptrn (m.) 143.1 208.8 --- capping market can-walk e(Utrn) 0.0853 LStrn -2.4620 Ptrn (m.) 123.1 dPt (m.) can-walk can-walk -20.0 must-drive -85.7 no-transit --- Changes in the price of travel by all modes (minutes) B a s e market can-walk must-drive no-transit e(Utrn) 0.0572 0.0154 --- LSall -1.0847 -1.2167 -1.2700 Pall (m.) 54.2 60.8 63.5 capping market can-walk e(Utrn) 0.0853 LSall -1.0354 Pall (m.) 51.8 dP (mins) can-walk can-walk -2.5 must-drive -9.1 no-transit -11.7 capped must-drive 0.0342 -1.1906 59.5 must-drive 5.3 -1.3 -4.0 no-transit ---1.3100 65.5 no-transit 11.3 4.7 2.0 capping User benefits caused by changes in the price of travel by all modes (person-minutes) market can-walk B a can-walk 92.5 s must-drive 113.3 e no-transit 293.3 grand total capped must-drive 0.0 0.0 0.0 no-transit 0.0 0.0 -50.0 449.0 capping User benefits caused by changes in the price of travel by transit (person-minutes) B a s e market can-walk can-walk 152.0 must-drive 134.5 no-transit 336.7 grand total capped must-drive 0.0 0.0 0.0 no-transit 0.0 0.0 0.0 623.3 Page 2
Related docs
Summary of Discussion
Views: 5  |  Downloads: 0
SUMMARY OF DISCUSSION
Views: 4  |  Downloads: 0
Summary of the discussion
Views: 3  |  Downloads: 0
Journal Discussion
Views: 1  |  Downloads: 0
Introduction to the discussion
Views: 0  |  Downloads: 0
For discussion
Views: 46  |  Downloads: 0
Discussion template 5-9-05.xls
Views: 0  |  Downloads: 0
Tutorial Questions for Discussion
Views: 4  |  Downloads: 0
Summary of the AQIP Discussion
Views: 1  |  Downloads: 0
PRESENTATION SUMMARY OF DISCUSSION
Views: 3  |  Downloads: 0
Discussion Summary of 8
Views: 4  |  Downloads: 0
A Discussion of What is Possible
Views: 6  |  Downloads: 0
Other docs by PHMSA