Home

IDAS Manual - Institute for Transportation Research and Education

1. 72 10 2 Deploying ITS Strategies Into ITS Options 4 ceres eee eerte ee ette seen 74 10 3 Guidance in Selecting the Deployed Links esee crece eee eee ee ee ette nete etta 75 10 4 Setting the Impacts Parameters for the Affected Links eeeeeeeee eee 76 11 0 MANAGING EQUIPMENT AND DEPLOYMENT COSTS eese eene eene enean netto ette ette stet testa 78 B 11 1 A New Approach to Managing ITS Costs eee ee eee e eene eee seen sette etta 78 12 0 USING THE ALTERNATIVES COMPARISON MODULE ee esee eese enean seta sette 85 B 12 1 Selecting a Group of ITS Options 1 ee eee enero ee ense ee s ttes etna sena 85 B 12 2 Specifying the Dollar 8 eene en eee see eaae etta setae seta ae 86 12 2 3 Viewing Benefits Costs cte rto ipta 87 12 24 The Performance Summary Spreadsheets 89 13 0 MANAGING IDAS RESULTS cscssccccssadsotescosescbccesseostussessesvectonssseasscbcvecsevosssbedsesnccosd ssesnsceevestsosnsvoesees 92 13 1 What Are the IDAS e enne e ann ean
2. 7 2 3 How Does IDAS Work isicssccssecscosscosssssseesseessonsssesteonacescsoparsocesoaeessoeensestsonnsosssvsenssseaseeessoersse 8 2 4 Rey 10 3 00 MODEL OVERVIEW P 11 3 1 Network Characteristics reete teorie no tenere tere Uno vna sonas oe Ee Evene orae ae ure un 12 3 1 1 Exporting TransCAD 12 3 2 Trip Tables Travel Demand e soosoossosocssesoossessoesessoesosssesocssesoossessossessossoessssoesseseossesss 13 2244 Exporting Vebicle Trip Tables 13 3 3 Volume Delay CUrVesS ss cosssooscooccoossooesooesooeesoessoocsoocsooosooosoooccooscooseooscosecosesosscossesssesssesssess 14 3 4 Provide the Requisite Data to the IDAS Analyst 15 4 0 PREPARING IDAS FOR ANALYSIS esee ee ense tenens tantos tn seta sts sons tastes sonata sets sens ense ta 16 B 4 1 High Level Data Required for 8 242 000 16 4 1 1 TDM Zone and Area Type 17 4 1 2 TDM Facility Type Information aide 18 4 1 3 TDM District 21 4 1 4 Other Data Used in IDAS Setup 22 4 2 High Level Data for IDAS Saving the Work 1 25
3. 56 8 5 A Finished Benefits 58 Figure 8 6 The Alternatives Comparison Module eene 60 Figure 8 7 Performance Summary by Facility Type anie nitro Sette ied 61 Figure 9 1 Link by Link Validation Using the Alternatives Network Generator 64 FEipure 10 1 EAMPO Model toit istos ttbi reb eter ote tete silia 73 Figure 10 2 Preparing a New ITS Option for ITS Deployment sse 74 Figure 10 3 Selecting Links Tor Deployment esset eite o ptem uestis en citius 75 Figure 104 Specifying Link Level Impact Parameters sk 76 Figure 11 1 Costs foran qai at obti eds 79 Figure 11 2 ITS Equipment GCost5preadsheet i ette teca Hen p IS 80 Figure 11 4 Table of Existing User Defined Costs ice ette etes mde eran 82 Bue ee Why Costs per Yea ates ne Rieti 83 Final IDAS Manual TABLE CONTENTS FINAL IDAS MANUAL T o 0905 84 Figure 12 1 Creating a Group of LTS OpBUODS o o east Hem S Led 86 Figure 12 2 DIbeDbebehts Coste opreadsBeehs oec din 88 Figure 12 3 Difference Between Baseline and Improvement Measures sess 90 LIST OF TABLES Table 1 1 Sample DASA pplication ote rte a m ndi Lorie oe eres A e ode D
4. IDAS ITS Deployment Analysis System File View Modules Reports Window Help tr Ifi Alternative Comparison Module ITS Option Comparison erformance Summary 2 Cost Adjustment Project FAMPO Alternative AM ITS Option Control Alternative Value of Time In Vehicle By Facility Type VCCurve 0 56 3 60 VCCurve 0 71 2 10 VCCurve 0 83 2 70 VCCurve 0 83 5 50 VCCurve 1 00 2 10 Total Vehicle Miles of Travel dene tene Holy Control Alternative 28 734 549 670 155 170 345 422 344 585 1 423 585 Cost of Fuel ITS Option 28 734 549 670 155 170 345 422 344 589 1 423 888 Non Fuel Vehicle Operating Costs Difference 010 08 010 0 010 0 010 08 0 0 08 010 08 Emission Costs Vehicle Hours of Travel Accident Costs Control Alternative 653 17 707 3 201 5 797 10 930 38 288 Fatality ITS Option 653 17 707 3 201 5 797 10 930 38 288 Injury Difference 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Property Damage Only Average Speed Noise Damage Costs Control Alternative 44 0 31 0 48 5 59 6 31 5 37 2 Other Mileage Based Costs ITS Option 44 0 31 0 48 8 53 6 31 8 37 2 Other Non Mileage Based Costs Difference 0 0 08 010 0 0 0 08 0 0 08 010 08 010 08 Risk Analysis Person Hours of Travel Select Ranges Control Alternative 653 17 707 3 201 5 797 10 930 38 288 Run Analysis ITS Option 17 707 3 201 5 797 10 930 38 288 View Difference 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 View O
5. work FAMPO Model Data nodes2 csv File e Step 4 The file shown above is the file exported directly from the Nodes sheet in the master links Excel Workbook Note carefully that the delimited option by comma is shown in the upper left This must be noted IDAS remembers most of the structure of these import files once one of them has been imported however it sometimes overlooks the setting of this option In the above figure the appropriate column in the input data has been associated with the field in IDAS from the dropdowns across the top of the figure Note from the position of the index finger that the user first clicked on the third row of data to indicate Final IDAS Manual 37 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 that import should start on that row This is because the first two rows are used as a note row and a header row with titles e Step 5 IDAS makes an assumption the first time it imports a file of a certain type in this case Nodes The default is that the first column is ignored in Nodes files In certain TDMs an extra field is exported here Thus it is important to double check the field associations In Figure 5 7 it can be seen that the fourth field the an extra longitude value has just been set to none Any field with the association either at none or blank is skipped e Step 6 Press Import in the lower left The system imports th
6. Done Reset Defaults Note that there is no restriction on the combination chosen whatever is convenient for the user in organizing the analysis How this organization ultimately takes form is described in the discussion that follows where the resulting performance spreadsheet will be imported to the IDAS Results system Step1 At this point the user selects the Performance Summary by Facility Type option and the workbook as shown in Figure 13 3 is created This spreadsheet is exported by selecting File Save from the main menu or clicking on the diskette with the question mark that appears on the toolbar Final IDAS Manual 97 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 3 The Performance by Facility Type Spreadsheet If IDAS ITS Deployment Analysis System fo 57 File View Modules Reports Window Help snas t Alternative Comparison Module 62 35 em Dut oF Vehicle Project FAMPO Alternative ITS Option AM FAM ATMSFaye 003 Replacement il Travel Time Reliability Cost of Fuel By Facility Type VCCurve 0 56 3 60 VCCurve 0 71 2 10 VCCurve 0 83 2 70 VCCurve 0 83 5 50 VCCurve 1 00 2 10 Total Non Fuel Vehicle Operating Cost Vehicle Miles of Travel Emission Costs Control Alternative 28 734 549 670 155 170 345 422 344 589 1 423 585 Accident Costs ITS Option 28 590 550 574 155 172 345 185 344 426 1 423 946 Fatality Difference
7. M FAM ATMSAM FAM ATMSAM FAM ATMS AM FAM ATM AM FAM ATM AM FAM SPSI Control NC87 001FMS NC87 002FMS NC87 003FMS SUS401 001F 505401 002 295 001 Safety MS Replacement Patrol Service Costs Analysis Submodules Selection Active Options Assignment Mode Choice Emissions Energy Safety Travel Time Reliability None Assignment Report file name Baseline Step 7 optional If there is an interest in seeing the total accidents emissions or fuel usage that IDAS calculates these submodules can be run to view these figures Final IDAS Manual 56 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Step 8 Deselect all options on this page except rerun baseline The only required input value here is the benefits report file name Enter any file name desired into this field shown on the bottom of Figure 8 4 Note The file produced which you named is of limited value to IDAS analysis It is simply a run time progress report of the assignment module as it proceeds through its steps It is rarely used and then only in detailed level debugging to determine what might have gone wrong in an assignment that produced incorrect results To reiterate do not confuse this report file as someplace to find assignment results Use the Alternatives Comparison Module Section 12 0 to do that 53 the Control Alternative Assignment e Step 1 In Figure 8 5 an assignment run has just
8. FAMPO Regional ITS Strategic Deployment Plan Update Final IDAS Manual Harnett County Spring Lake Pope Air Force Base Fort Bragg Cumberland County 4 Eastover N e Fayetteville Hoke County Prepared for Fayetteville Area Metropolitan Planning Organization FAMPO Prepared by May 2013 TABLE OF CONTENTS FINAL IDAS MANUAL Contents EXECUTIVE SUMMARY sccccscssssessessscssccscsonccscsseccesesscnecsecsenccecsenssccsacsseceecssscneccesessenecsensenccacsecssccssceneceesees I ES L Back round AQ i ES2IDAS Analysis PROCESS sicccscessccecsnssectissssesccescssseseesdvaesesonsseasscasseessiuecentessvseussescsvsnsssecescessoevsecs i iii 1 0 INTRODUCTION ee 1 1 12 Project 1 1 3 What Is IDAS Analysis Intended to 2 2 eerie Leser eese ee ette ette etta setas 2 B 1 4 What Analysis Can Be Performed Using 82 2 22 2 2 15HowtoUse This Document eren eee eoe 5 2 0 5 7 2 2 2522 E 7 2 2 Why Was IDAS 0
9. Merge amp Center 7 110 500 Conditional Format Cell Insert Delete Format amp Find amp lt J Format Painter U E E Bi Mero 68 58 Formatting as Table Styles X X lt 2 Clear Filter Select Clipboard Tu Font Alignment ip Number fa Styles Cells Editing 144 fe 15079632 6 Y A B D E G H J N Q S uU 1 2 3 Costs m System Construction AMD 4 Replacement Costs 6 m O amp M Costs e pital Costs do not incl 25 000 000 replacement O amp M costs 8 a 9 1 10 11 18 20 000 000 12 5 13 cs 14 15 15 000 000 16 18 19 20 10 000 000 21 z 22 23 8 24 5 5 000 000 25 26 5 8 I ini amp il I 29 E 0 30 e e N 31 q qe N N N N e e e e 32 N N N N N N N Ny N N N N N N 33 ear 34 35 36 37 38 39 40 Year 41 Poject 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 42 FAM ATMSFaye 001Replac 4222270 0 0 0 0 0 0 0 0 0 0 0 8222270 0 0 0 0 0 0 0 43 FAM ATMSFaye 002 Replac 222 370 0 0 0 0 0 0 0 0 0 0 0 222370 0 0 0 0 0 0 0 44 FAM ATMSFaye 003 Replac 0 0 0 0 0 0 0 0 0 sof 3 079533 0 0 0 0 0 0 0 0 0 45 FAM ATMSFaye 004FMS 60 646 0
10. 4 Revision History Filename Version Date Authors Comment Draft IDAS Manual 0 1 10 22 12 Clark Initial Draft Final IDAS Manual 1 0 12 3 12 Vorhees Clark Final incorporating comments FAMPO Final IDAS Manual 1 01 4 12 13 B Eisenhart Update for Final Workbook 2013 04 12 FAMPO Final IDAS Manual 1 02 5 24 2013 J Baker Update Final for Workbook and 2013 05 24 DVD Final IDAS Manual 4 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Executive Summary ES 1 Background The intent of the document is to assist future users of IDAS in North Carolina in reaching the full potential of the IDAS system quickly and easily This document follows the entire process of using the Intelligent Transportation Systems ITS Deployment Analysis System IDAS in the Fayetteville region of North Carolina The Triangle region including Raleigh Durham and Chapel Hill was used as a prototype for IDAS implementation in North Carolina in 2010 The Fayetteville IDAS analysis is using the same general process as was developed for the Triangle region As IDAS is deployed in different regions of the state the manual will require modification to account for differences in travel demand models and ITS deployments FS IDAS Analysis Process The ITS Deployment Analysis System software was developed by the Federal Highway Administration FHWA as a sketch plannin
11. Benefit Cost Comparison Final IDAS Manual 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Once the network and travel demand data have been imported and validated the IDAS user is then able to create analysis alternatives by selecting ITS components from a menu of over 60 ITS improvement types and placing these on the desired location on the network After the analysis alternative has been created the user may perform analysis within the software to estimate the incremental impacts of ITS deployment including changes in link speeds and volumes and travel mode shares From these impacts IDAS estimates the changes in a number of performance measures including travel time accidents emissions noise and other impacts These benefits are summarized for the user and form the basis for comparison with other deployment alternatives created by the user IDAS was specifically designed to complement the analysis performed TDMs Combining the capabilities of the two models provides a useful tool for analyzing and comparing ITS deployments as well as more traditional types of infrastructure deployments The number of ITS deployments involved in most analysis efforts can grow quite large Because of this tools have been developed and described here that have shown value in assisting users in keeping all information organized and accessible while at the same time allowing th
12. The list of equipment that was generated as usually required by the National ITS Architecture the source of the ITS Equipment spreadsheet is very detailed generally more detailed than required for most IDAS analyses It also lacks flexibility in that it assumes all of the required and supporting facilities also need to be built to accomplish a deployment It is possible to go into the IDAS equipment list for a deployment and choose certain parts of this equipment list to be already existing or shared However this is a complex and error prone activity in which a step can easily be forgotten e Agencies usually have a very precise understanding of equipment needs and costs Equipment expenditures lifetimes and needs especially the extent to which existing or planned supporting facilities can support ITS are something which vary from one area to another and most transportation agencies can provide detailed information on their own costs This information is clearly preferable to using generic cost estimates These factors together have driven the development of a more locally oriented set of procedures for equipment cost information Again this is explained fully in Section 11 0 3 ITS Entry Defaults When a user is deploying ITS Strategies on the IDAS network certain Impact Levels are applied based on the type of deployment being made For example when ramp metering is deployed the user will provide a
13. 06 0 0 1 2735 04 0 18 2 761E 04 0 0 1 068E 03 0 19 Number of PDO Accidents Control Alternative 138978400 1 2 22598 01 8 52372 01 2 83632400 ITS Option 2 1 36198 00 3 83835 01 2 22415 01 8 51572 01 2 83792400 Difference 96 9 028 05 0 58 2 2368 03 0 28 3 815 06 0 09 1 761 04 0 18 4 019 04 0 00 1 5728 03 0 10 Travel Time Reliability hours of unexpected delay Control Alternative 2 52 508 89 511 41 7 AM FAM ATMSFaye 003 Replacement 1 Show Centroid Connector Data Emissions data does not include cold start or trip duration amounts Accident data does not include intersection collision avoidance impacts Incident delay figures are calculated for freeway links only Person hours of travel data does not include hours accumulated in Transit market sectors e Step 2 Saving these in a consistent location with a name that describes the grouping of the ITS Options is recommended The default name is ftPerformance which should be changed e Step 3 Also it is important to remember to change the extension of the saved file to xls Excel as the default file format vts is of no value in this process e Step 4 Additionally sometimes these workbooks must be combined with others and this should be reflected in the naming convention For example in the FAMPO analysis we are combining results from four IDAS databases AM MD PM and off peak periods Ther
14. 144 0 5 304 0 2 210 0 2 7 0 1 162 0 0 362 0 0 Injury Vehicle Hours of Travel Property Damage Only Control Alternative 653 17 707 3 201 5 797 10 930 38 288 Noise Damage Costs ITS Option 649 17 568 3 205 5 792 10 904 38 119 Other Mileage Based Costs Difference 4 0 6 1 9 410 18 5 0 18 251 0 29 169 0 44 Other Non Mileage Based Costs _ Average Speed Risk Analysis Control Alternative 44 0 31 0 48 5 59 6 31 5 37 2 Select Ranges ITS Option 44 0 31 3 48 4 59 6 31 6 37 2 Run Analysis Difference 010 18 011 08 01 0 18 0 0 08 010 29 010 08 View Results Person Hours of Travel View Outputs Control Alternative 17 707 3 201 5 797 10 930 38 288 Benefit Cost Summary ITS Option eas 17 569 3 205 5 792 10 904 38 119 Difference 4 0 6 1 9 410 18 5 0 18 251 0 29 169 0 4 Performance Summary by Market Sector Number of Person Trips Control Alternative by Facility Type by District Difference 7 x Number of Fatality Accidents Control Alternative 1 89658 04 0992 03 2 10448 02 ITS Option 1 0 0 03 21055802 Difference 9 5228 07 2 876 06 0 08 1 064 08 0 1 Number of Injury Accidents Control Alternative 01 2 63638 01 1 69995 01 4 01 1 9668 00 ITS Option 5 35425 01 63642 01 1 6987z 01 5 e518z 01 1 9678z 00 Difference 67 05 0 5 1 5362 03 0 28 2 623
15. 2 Page Page Break Custom Full Zoom 100 Zoomto Arrange Freeze _ Save Macros layout Preview Views Screen age election Window Panes ide 214 Workspace Windows Workbook Views Show Hide Zoom Window Macros u7 i a R 5 w x 2 m 1 IDASSpeed Model Speed IDAS VT Model 2 342857148 35 071428571 2 08 1 553 523 99 1 563 425 50 0 633 3 34 2857143 35 071428571 2 08 Urban Freeway 34 link Rural Major 6 Rural Freeway 59 links Rural Major 22 Rural Major Arterials 40 4 342857143 35 071428571 2 08 Urban Major 673 Urban Freeway 52 link Urban Major 110 Urban Major Arterials 76 5 34 35 a 2 94 Others 791 Others 49 Others 2759 6 35 35 o 0 00 7 342857143 35 071428571 2 08 8 346153846 35 038461538 1 11 1 2 3 4 5 6 9 353846154 35 038461538 1 09 219 209 151 481 4 38 066 10 33 3333333 35 1 66666667 5 00 0 02 0 08 0 13 0 11 0 04 0 30 11 34 8837209 35 011627907 0 33 28 669 90 549 069 28 345 487 27 155 193 60 343 511 84 129 980 25 12 35 35 o 0 00 13 346153846 35 038461538 211 6 00 14 348387097 35 016129032 0 46 15 354545455 35 045454545 12856 16 336 35 14 4 17 17 35 35 o 0 00 18 35 2 6 06 Ads 19 30 35 5 16 67 20 352941176 35 029411765 0 83 21 33 35 2 6 06 22 36 35 1 278 23 33 3333333 35 166666667 5 00 m 24 342857143 35 071428571 2 08 znos 25 35 35 o 0 00 25 36 35
16. 4 X gem 43 p Johnston Orange Wake 7 Johnston Wm d e 8 Orange HM gt EN gt m gt Delete Fie BN gt Managing District Information Excel A table of the district definitions can be setup in Excel just as in Facility types These can of course be maintained in the same spreadsheet too which is a recommended practice Final IDAS Manual 21 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 4 5 District Names in an Excel Spreadsheet i IdasSetup xls Compatibility Mode Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Acrobat ox 1 2 amp Clip Art Line Area Q Text Box L Signature Line mR al qy Shapes eb rie gt Scatter gt Header amp Footer d Object Table Picture aaa ther Chae Hyperlink 4 Woe symbol Tables Illustrations Charts Links Text 622 fa Y B C D E w J K 1 1 2 3 DistrictID Descriptic Red Green Blue 4 1 Chatham 0 255 0 5 2 Durham 115 255 0 6 3 External 255 255 0 7 4 Franklin 64 64 64 8 5 Grandville 255 255 0 9 6 Harnett 255 0 0 10 7 Johnston 0 255 0 11 8 Orange 0 0 255 12 9 Wake 0 110 110 13 14 Districts Speed Curves 2 Figure 4 5 highlights some minor but important difference
17. ITS Elements e Step 3 Figure 4 6 shows an entry from the Direct Benefits data that can be imported into IDAS Here the user has right clicked on the Traffic Actuated ITS Strategy in the ITS Elements tab and chose ITS Library from the menu These entries simply relate the experience of others that have used this strategy For example Minneapolis St Paul believes a 40 million benefit was achieved Some of these notes from the field actually go into more detail than this 2 ITS Equipment The Equip2 3 xls workbook last updated and shipped with IDAS 2 3 June 2003 contains all of the logic and costing levels of the automated equipment management procedures built into the IDAS ITS deployment mechanism Final IDAS Manual 23 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 During the deployment of ITS strategies onto the IDAS network Section 7 0 the system maintains the actual equipment that is typically required for that deployment to work This behind the scenes population of equipment is driven by the information in the spreadsheet that can be imported at this point in File gt Setup The IDAS equipment mechanism works as intended however two factors usually rule out the widespread reliance on the IDAS equipment costing procedures These are discussed in detail in Section 11 0 but the synopsis is that e The IDAS mechanism is extensive but generalized
18. Node coordinate file Network link characteristics file Turn prohibitor file optional Trip origin destination O D trip table data files Trip in vehicle travel time O D tables optional for nontransit market sectors Trip out of vehicle travel time O D tables optional for nontransit market sectors Checklist The following sections outline key steps required to apply the IDAS model for a regional analysis These steps are provided as a basic checklist of activities Depending on the alternatives identified for evaluation additional sub items will be required The body of the IDAS procedures manual provides additional specifics related to these sub items Additionally the page number within the procedures manual that corresponds with each step is shown in parentheses Run TDM Identify and obtain the TDM for the year s of analysis 11 Run the model and check results 11 Prepare trip tables network files and other files required for input to IDAS 12 Develop TransCAD node definitions 13 Modify TDM output formats as necessary to make sure they are compatible with IDAS 21 Identify characteristics of IDAS scenario s general description page 7 Identify facility types to be included in analysis 24 Identify geographic districts projects or facilities to be evaluated Districts can be defined as corridors municipalities divisions districts or other level of segmentation desired 26 Identify ITS
19. of vehicle time the system imports them more quickly by combining them internally into one file for import If the user attempts to exit the market sector window before performing this final import the system will alert them Before benefits analysis can be run the actual import of the market sector data must occur e Step 3 Once the user has created all the market sectors to be used in the IDAS analysis they should run the baseline condition of the model to verify that all of the data is correct This is done by running the Benefits module for the Control Alternative recalling that the Control Alternative is the baseline performance measure In other words the network performance values produced for the Control Alternative are the values that are then compared to the TDM output to ensure there is at least some comfort level in how close they match Final IDAS Manual 45 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 7 0 Volume Delay Curves in IDAS A volume delay curve is a function that specifies the expected speed dependent variable of traffic on a link based on what the current volume to capacity ratio independent variable is on that link at any given time The IDAS assignment module works like a TDM assignment procedure to estimate the loaded volumes and speeds on all links in the network Topics Covered in This Section e A brief introduction on how IDAS relates curves to facility types e How th
20. 0 9927 0 9989 0 9559 0 9820 VCCurve 0 83 270 nonce Arterial Speed Factor vs VIC ratio for freeway Done VCCurve 1 00 2 10 Ramp Y ACTIVE Project FAMPO Freeway v Centroid Connector Ramp M s Suburban rural Urban Alternative ITS Opti Import default V C curve data ption Control Alternative File e Step 2 It is here during initial Control Alternatives benefits run that we import these curves into IDAS for use not only in the baseline benefits run but for all benefits runs that will occur in the future As shown in Figure 8 2 press the File button in the lower right of the figure e Step 3 Navigate to the spreadsheet containing the V C curves table described in Section 7 0 and select that spreadsheet Final IDAS Manual 54 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Step 4 A message appears asking whether you want to set these curve values as the default for all runs answer yes Specify the Assignment Closure Criteria The assignment process is an iterative procedure that tries to determine the amount of traffic volume and speeds of every link in the network based on the demand represented by the matrices Step 5 As an iterative process it will continue analyzing the network until a certain calculated value either reaches a constant value or the allotted number of iterations has expire
21. Figure 13 7 Report Tables id 9 c IDAS Results xlsm Microsoft Excel 25 a Home Insert Page Layout Formulas Data Review View Developer 2 pue d cut Arial E Wrap Text General d Bad Good 2 ziatua Ad d Copy x 8 Fit Paste 1 amp Center ar y 1 0 20 Conditional Format Neutral Calculation Check Cell T Insert Delete Format Sort amp Find amp f Format Painter u 5 Formatting as Table 2 Clear Filter Select Clipboard Font i Alignment Number 5 Styles Cells Editing _ H lt 5 5 E E R E o 3 o s 2 5 E e 5 gt 6 5 z E s 3 Deployments E 2 B lt s 2 gt s 6 Faye 001 Replacement 0 105 957 158 734 7 002 Replacement 105 094 311 857 43 022 15 025 8 003 Replacement 131 745 5 14 065 215 3 654 964 50 9 Faye 004FMS 510 687 x 29 153 11 733 4 098 10 Faye 005FMS 35 106 597 650 15 644 5 464 11 1295 002FMS 163 743 28 607 E 242 294 249 474 37 153 12 1295 004 Replacement 163 743 28 607 242 294 531 289 50 13 195 001 5 597 172 2 53 243 i i 252 881 78 012
22. Figure 8 9 a Performance by Facility Type spreadsheet was produced by the Alternatives Comparison Module Typically using this spreadsheet is the first and highest level of validation However in the case of the FAMPO model we actually have output of its results for every link in the network Since this is available we can compare the IDAS results on a link by link basis directly within our master Links workbook Initial Validation Using the Alternatives Network Generator As discussed in Section 5 and shown in Figure 5 3 we actually have the link level model generated volumes in the FAMPO network Therefore the visual spot check described here is the first step in validation If this shows a large discrepancy there is no reason to perform the spreadsheet validation of the entire network described next Instead investigate the cause of the difference and re run the benefits module until this step shows more reasonable values e Step 1 Open the Alternatives Network Generator for the Control Alternative after baseline assignment run as detailed in Section 8 0 by double clicking on it in the IDAS Work prompter e Step 2 Right click on a network link of interest and choose Edit from the menu that appears Final IDAS Manual 63 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 9 1 Link by Link Validation Using the Alternatives Network Generator IDAS 15 Deployment Analysis System rer 752
23. counts of a measure that is spent by the traveling public between each zone pair on the entire network To clarify e A zone pair is one of every combination of an origin zone number and a destination zone number Here zones are the special nodes with the ID value between 1 and the maximum internal and external centroid number a critical input value described in Section 4 0 e All centroid connector links either emanate from a zone or arrive at a zone No centroid connectors can exist between any two nodes which are both not also zones e The counts used in IDAS are o Number of trips How many people made a trip between the given O D pair Out of vehicle time How much time was expended by all travelers between the O D pair in activities related to travel but not directly within the vehicle o In vehicle time How much time was spent by all travelers between the pair while actually underway In and out of vehicle time matrixes are only used for transit analysis in IDAS B 62 Required Data Conversion In the case of the Fayetteville area analysis any conversion of market sector data for vehicle travel must happen before transferring the files for import to IDAS Final IDAS Manual 4l FAMPO Regional ITS Strategic Deployment Plan Update May 2013 We obtained trip tables in and out of vehicle time matrices were not needed in this analysis for both Auto and Truck trips for each o
24. is recommended Carefully note the extension when saving the file It defaults to a proprietary vts format but you want to be sure and save it to an xls Excel format Step 4d Repeat steps a through c for the Average Annual Costs The selection is on the left side of the cost module window as shown in Figure 11 6 Save the spreadsheet to the Average Annual Costs spreadsheet and remember to use an xIs extension Final IDAS Manual 83 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 11 6 Average Annual Costs r 8 IDAS ITS Deployment Analysis System File View Modules Reports Window Help BAITS Costs Cost Module Average Annual Costs 1995 Cost Module Inputs User Defined Costs Average Discount Rate Improvement Annual Cost Unit Cost Figures Public Costs User Defined Cost 1 AM FAM ATMSNC24 87 001FMS CC Private Costs Public Capital 9 316 75 Costs per Year Private Capital 0 00 Public O amp M 5 000 00 Private O amp M 0 00 SUBTOTAL 14 316 75 User Defined Cost 2 AM FAM ATMSNC24 87 001FMS DIV Public Capital 43 917 85 Private Capital 0 00 Public O amp M 6 000 00 Private O amp M 0 00 SUBTOTAL 49 917 85 User Defined Cost 3 AM FAM ATMSDunn 001 Traffic Sign Public Capital 192 209 63 Done Private Capital 0 00 Public O amp M 135 000 00 ACTIVE Private O amp M 0 00 FAMPO SUBTOTAL 327 209 63 User Defined Cost 4 AM FAM ATMSFaye 001 Replaceme P
25. used facility type 6 We also note in the above figure that area type is simply used as one of the 2 curve selectors in IDAS whether or not the link is in the city The same is generally true for the curve name the curve name and area type together choose the appropriate curve at IDAS assignment run time and what is important in terms of results is that the proper a and get applied 7 4 Importing the V C Curve Data into IDAS Note This step will be performed using the setup parameters for the IDAS benefits analysis module This means that the action cannot be performed until ITS Options have been created as described in Section 8 0 Final IDAS Manual 50 ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 7 3 IDAS Volume Delay Curves Input Window A IDAS ITS Deployment Analysis System File View Modules Reports Window Help Andbeiis Ola ITS Option Selection as ee Available ITS Options Assignment Volume Delay Curves Altemativename AMAM FAM ATMSFaye 002 Replacement ral Parameters 28 AMAM FAM ATMSFaye 003 Replacement Mode Choice AMAM FAM ATMSFaye 004FMS AMAM FAM ATMSFaye 005FMS QE AMAM FAM ATMS1295 001 Communications QE AMAM FAM ATMS1295 002FMS AMAM FAM ATMS1295 003 Communications AMAM FAM ATMS1295 004 Replacement Safety Aaa CAM ATIACI OE NNE Danlannnannt Travel Time Reliability Run Analysis Temporal Cho
26. 00 Change in External Costs 20 pers 6 620 00 3 889 00 Accident Costs External Only 100 22 423 14 846 19 579 17 690 21 174 004 10 18 839 00 11 066 00 Emissions 9 22 195 005 Replacement 2 56 06 53 56 HC ROG 1 00 6 577 3 955 29 505 40 036 23 195 006 Replacement 02 6 06 3 56 NOx 1 00 17 681 10 249 547 28 477 24 195 007 Replacement GW 0 00 0 00 co 1 00 95 790 58 087 708 231 862 109 25 195 008 Replacement Accident Costs PM10 0 00 0 0 26 195 009 Replacement Internal co2 0 00 o 9 9 9 27 195 010 Replacement Fatality 54 490 000 00 52 317 398 00 502 000 5 o o o o 28 pe Injury 86 415 00 50 760 00 Global Warming 000 0 0 0 0 29 NC87 002FMS Property damage 7 760 00 2 824 00 Noise 000 0 0 0 0 30 NC87 003FMS External Other Mileage Based External Costs 1 00 0 0 0 31 Supporting Deployments Fatality 696 213 00 408 952 00 Other Trip Based External Costs 1 00 0 0 0 0 32 SPSI295 001FSP Injury 15 250 00 8 958 00 Change in Public Agencies Costs 100 0 0 0 0 33 1295 005 Replacement Property damage 847 00 498 00 Other Calculated Benefits 100 0 0 9 34 Non Fuel operating costs S mile 0 11 0 06 User Defined Additional Benefits 100 0 0 35 Noise Damage Costs S mile 0 0011 0 0007 Total Annual Benefits 598 047 311 856 14 065 213 14 975 116 36 Other mileage based S mile 0 00 0 00 37 Other non mileage based S mile 0 00 0 00 Annual Costs 38 Average Ann
27. 1 278 27 375 35 25 6 57 28 323076923 35 2 69230769 8 33 T Volume 29 36 35 1 278 0 00 30 352941176 35 029411765 083 4 1 2 5 a y Wet 31 36 9230769 35 192307692 521 32 323076923 35 2 69230769 8 33 33 347368421 35 026315789 076 336 35 417 35 3375 35 125 3 70 36 342857143 35 071428571 2 08 37 342857143 35 071428571 2 08 38 342857143 35 071428571 2 08 39 323076923 35 2 69230769 8 33 40 327272727 35 227272727 6 94 41 33 3333333 35 166666667 5 00 42 375 35 25 667 336 35 14 417 44 34 2857143 35 071428571 2 08 45 3375 35 125 3 70 00 46 36 35 1 278 47 333333333 35 1 66666667 5 00 36 35 1 278 M M Setup Alpha Beta Curves Netrsits 2035 ReExported Links J Ready 22 Note that the total summed VMT between IDAS and the FAMPO model are close If these VMT values seem high it is important to remember that they also include Centroid Connector links The aggregate VMT for each facility type is shown in row 11 columns U through Z We also compared IDAS speed to the model speed in this exercise to better pinpoint what the input speed should be The validation was in fact further off higher errors until we discovered that the model must be using a factored speed that is adjusted at model startup time to a value somewhere around 95 of the speed limit Once this was discovered IDAS and the model c
28. 14 752 14 NC24 001FMS 159 448 42 200 5271 806 570 191 15 NC24 002FMS 545 634 519 103 i 595 047 531 185 16 NC87 001FMS 50 2 11 794 558 609 523 467 _17 US401 001FMS 0 112 567 15 644 18 US401 002 Replacement 266 283 266 283 954 546 5437 091 19 Dunn 001 356 197 356 197 357 551 0 20 174 001 Replacement 0 7 k 114 536 19 555 0 21 174 002 Replacement 279 704 279 704 136 366 0 22 174 003 Replacement 0 5156 167 523 467 23 174 004 Replacement 760 730 5760 730 5327 280 24 195 005 Replacement 0 k E 595 612 35 199 25 195 006 Replacement 1 974 032 1 974 032 245 460 26 195 007 Replacement 0 153 371 465 232 23 467 27 195 008 Replacement 1 879 008 0 1 879 008 218 186 28 195 009 Replacement 320 073 gt 505 674 11 733 29 195 010 Replacement 273 799 273 799 27 273 1 A 9218 546 30 Lumb 001 1 294 290 0 1 294 290 715 102 i 2 950 363 31 24 87 001 5 232 668 5666 817 570 191 517 953 32 NC87 002FMS 90 x k 32 918 11 733 33 NC87 003FMS 59 19 833 11 733 35 5 51295 001 5 2 602 006 d 3 361 054 218 995 36 1295 005 Replacement 163 743 0 163 743 31 289 46 47 Total Benefits 23 482 592 1 274 090 1 185 263 92 257 604 29 543 051 56 806 773 598 072 3 491 809 522 736 278 48 M 4 Control Instructions Results Report Tables Costs Strea
29. 2013 13 3 1 Importing the Costs Spreadsheet Prerequisite The two costs spreadsheets described in Section 11 0 have been exported out of IDAS into an Excel compatible version These are the Average Annual Cost and the Stream of Costs spreadsheets e Step 1 First open the IDAS Results workbook navigate to the Costs sheet and import these two spreadsheets by clicking on the appropriate button in the upper left Figure 13 1 Importing IDAS Costs Spreadsheets 44 revenus done cpi earam _ 195 008 Replacement 195 009 Replacement 195 010 Replacement Lumb 001 NC24 87 001FMS NC87 002FM Ready Calculate 71 y Some important points to note are e Step 2 Year of initial cost values sent to IDAS Final IDAS Manual 95 id 92 c IDAS Results xlsm Microsoft Excel m Insert Page Layout Formulas Data Review View Developer 27 7 General Conditional Formattingy 3Insert B amp Arial Se rom e eneral Conditional Formatting g Inse 27 d iii Format as Table 3 Delete 3 Paste 3 28 gt amp Find amp 48 59 E Cell Styles Format 2 Filter Clipboard Font fa Alignment fa Number Styles Cells Editing 124 f Y B G D E F G H 1 4 2 3 IDAS Stream of costs spreadsheet 4 D project
30. 5 0 IMPORTING NETWORK 0 26 5 1 Understanding Network Data 0 4 4 40021 26 5 2 Extracting Data from the TDM 4 0 26 5 2 1 Network Nodes TransCAD 5 20 2 44122 00000000000040000000000000000000000000 26 Final IDAS Manual TABLE CONTENTS FINAL IDAS MANUAL 5 3 Importing Data into IDAS 33 5 3 1 Creating a Projecta hope RR NES RN PIENE TIE 33 5 3 2 Creating an ATternatye c os podere tte RE cra Mcr pet 35 6 0 IMPORTING MARKET SECTOR 2 etos etse esos teste 41 6 1 Introduction to Market Sector Data ee eee eee seen nest ense etta setae etta 41 6 2 Required Data ConversiOn ee eee etes eoo enin on eo 41 B 6 3 Importing the Market Sector Data cere ecce ee eee ee eren ee ette aee ease ttes tense eaa 42 7 0 VOLUME DELAY CURVES IN 8 1 100 neto ee eee soe 46 B 7 1 V C Curves Are Related to Facility 40 02 2 46
31. 5 A Merge amp Center 1549 Conditional Format Good Insert Delete Format Sort amp Find amp J Format Painter S ik 2 Formatting as Table i 2 2 Clear Filter Select Clipboard id Font m Alignment iD Number i Styles Cells Editing B2 fa Roadway Devices Item Unit Capital Cost Annual O amp M Cost Lifecycle Total Lifecycle Cost Description and Assumptions CCTV Camera PTZ E Closed circuit television CCTV camera with pan tilt Camera enclosure posi zoom PTZ functionality a dome enclosure metal pole and foundatil 2 cabliny CCTV Camera Fixed y z Fixed position closed circuit television CCTV camera Camera enclosure pole 3 dome enclosure foundation control cabi 5 Qverhead Mount ach 00 000 coal Deployments Equipment Specifications ocr Average 155155 Count9 Sum 53262 oes message sign inms of a large size suitable for Sien structure and Figure 11 3 shows the standard cost for a camera In the specification we need the year of the costs data 2009 the initial capital cost to purchase and install the system the annual Operations and Maintenance O amp M cost and how many years typically elapse before the system needs replaced life cycle costs Final IDAS Manual 80 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update
32. 7 2 Maintaining V C Curves Outside of IDAS ecce eee esee ee eee eere seen seen sette sten 47 7 3 Associating V C Curves to Links eese cente ee eere ee eene sten sesto seta testen eas 49 74 Importing the V C Curve Data into IDAS eee esee ee ee eee seen ee etta seen setas sten 50 8 0 RUNNING THE BASELINE 6515 1 52 8 1 Introduction to the IDAS Benefits Module 5 2 1 eee ee ee enne een 52 8 2 Set Parameters the IDAS Benefits Module 4 ceres ee eee eren ee ette 53 B 8 3 Run the Control Alternative 1 eere aestas eee sette 57 8 4 Open and Save the Alternatives Comparison Module Performance by Facility Type Juv hice 59 9 0 VALIDATING THE IDAS RESULTS e ee eere ee eoe en soto notos eto o epo epo e tees Poe Poe Pose sos ea Peto Peto 62 10 0 CREATING TES OPTIONS 72 10 1 Introduction to the IDAS Alternative Network Generator
33. 832 70 Arterial VCCurve 1 00 2 10 Centroid Connector Ramp m Not Used Not Used Delete s 2 B Jg Figure 4 2 shows the table of facility types e Step 2 The integer number is generated from TDM data as described in Section 5 the Description is simply a label and it can be anything the user wants except in the case of the Centroid Connector facility type e Step 3 Exactly one row in this table must have this description Centroid Connector and it must identify the code used by the TDM to identify Centroid Connector facilities e Step 4 Each row must be associated with one of the aforementioned V C curve names e Step 5 Note also in Figure 4 2 there is a series of color settings for each facility type This is useful if you want a specific facility type to stand out in the IDAS view of the network in which it draws the network graphically in what is called the Alternatives Network Generator Section 7 0 Each color is specified by changing the relative intensity of red green and blue The value of V C curve in combination with the Area type code discussed previously is used by IDAS during the traffic assignment process to characterize the performance of each network link under traffic load Please see Section 8 0 for a complete description of the V C curve setup for IDAS Final IDAS Manual FAMPO Regional ITS Strategic Dep
34. Alternative baseline IDAS assignment has run a user can right click on any link in the network and compare the model volume or whatever volume was imported and IDAS volume on the link This is shown in Figure 5 3 for 1 95 NB north of the northern intersection with 1 95 Business Note that the model volume is 4189 vehicles during the period where IDAS came up with 4134 a 1 32 percent difference This comparison is only valid if the imported volumes are known to be from the model results 6 These columns will be used for import into the AM database there are similar columns for MD PM and OP databases Final IDAS Manual 32 ee 22 222 Regional ITS Strategic Deployment Plan Update May 2013 Figure 5 3 Model and IDAS volume comparison A Node 20399 B Node 20400 LinkNo 101107 Length 2 43 Facility 3 VAC Curve freeway Areatype 2 1 195 Baseline Improvement Difference Amt Pet vam ams Volume 55 5 1 32 Speed 53 Speed Speed 455 it Lanes 2 it Lanes 2 Lanes 0 0 Lane Capacity 3326 40 Lane Capacity 3326 40 Lane Capacity 0 00 0 00 WiC 0 63 VAC 0 62 VAC 0 01 1 32 uiae After setting up all the cross lookup functions in our 3 main network sheets we can take each one and export to csv file suitable for importing into IDAS as described next 53 Importing Data into IDAS It is assumed that the target IDAS database has been
35. File View Modules Reports Zoom Window Help B amp EE D o 4 D 0 ANode 20398 20400 LikNo 101107 Length 2 49 Facility wpe 3 VC Curve freeway Areatype 2 Rural District 1 Name I 35 Baseline Improvement Difference Amt Pet Volume 418897 Volume 413365 Volume 5526 12 Speed 6355 Speed Speed EAEN Lanes 2 Lanes Lanes K Link from node 2039 Lane Capacity 332640 Lane Capacity 3326 40 Lane Capacity 79 053 we 062 wc 132 OK Cancel Name Contra Alternative e Step 3 The data can be reviewed in the screen shown above In the figure a link on I 95 Northbound North of the I 95 Business interchange has been selected it is black right above the inner detail window All of the data about the analyzed by IDAS performance of this link is presented in the middle of the detail window Improvement and the data for this link that was imported into IDAS is on the left It is important to remember that this validation should only be done by viewing the Control Alternative In this special ITS Option the Improvement column of data is Final IDAS Manual 64 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 what IDAS calculated as the baseline 1 no ITS Deployments performance measures In other ITS Options the baseline perform
36. IDAS Manual 72 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 10 1 FAMPO Model 79 16 34 83 lt gt 78 51 35 32 Cancel Altemative Figure 10 1 depicts the Alternatives Network Generator showing T rcx 5 004 5 the entire FAMPO Note that this is a view of the Control EN Inm 51295 002 5 Alternative the baseline conditions for the network upon which E AM FAM Lu AM FAM ATMSISSB DO1FMS ITS deployments can be made AM FAM ATMSIS5 011VSL Zz AM FAM ATMSLumb 001 Traffi 5 24 001 5 e 1 To view the Control Alternative or any existing ITS Option simply double click the name shown IDAS E Work prompter which is shown to the right B a AM FAM ATMSBRA 002 AM FAM ATMSBRAR 001 In this figure the Alternative is the AM Alternative the Bairro 1 aye Control Alternative is the baseline network conditions It AM FAM ATMSFaye 002 Reple ei AM FAM ATMSFaye 003 Reple 1 ee 2 1 AM FAM ATMSI285 001 can be seen that the Control Alternative owns the Traffic r market sector However the market sectors is used by every Final IDAS Manual 73 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 ITS Option which are listed in the work prompter t
37. May 2013 e Step 3 Import the costs data into IDAS As previously mentioned the capabilities of the IDAS cost module are leveraged to use the future value of equipment purchases in an economically correct way in the B C analysis e Step 3a Create an ITS Option in IDAS called Costs No deployments need be made for the ITS Option simply create a new option name it Costs and exit the Alternative Network Generator This only needs to be done for one of the time periods the model provides In the FAMPO analysis we create a separate database for each time period so we chose the AM database to maintain the Costs ITS Option Thus the use of AM in the name of our ITS Options within this database Note that it is not strictly necessary to prepend MD for example in the ITS Options within the Mid Day IDAS database The process of loading the Costs into the IDAS database is automated The implementation is within VBA Visual Basic for Applications code that is embedded in the costs workbook The code for this is relatively simple and can be easily inspected and changed for future needs by an individual familiar with Excel automation For purposes of completeness however the manual method of importing these costs is briefly explained in the box below for use in smaller projects Final IDAS Manual 81 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Alternative Manual Method of Cost Entry When running IDAS c
38. Replacement eee x a m D AM FAM ATM 5174 001 5174 002 5174 003 5174 004 Replacement Replacement Replacement Replacement AM FAM ATM 5195 002 5195 003 5195 004 5195 005 Communicatio Communicatio Communicatio Replacement Done Reset Defaults In Figure 12 1 all ITS Options in the database are shown When the ACM is first run all of these would be in the left pane of the two windows To place ITS Options into a group of interest click on them in the left pane and then click the right arrow button in the middle To select multiple options to move press the Ctrl key while selecting them Similarly to take ITS Options out of a group select them in the right pane and click the left arrow button in the middle 122 Specifying the Dollar Valuations Figure 12 1 shows the entire menu of options in the ACM Most of these deal with the dollar values that should be applied to the changes in the performance measures calculated by IDAS to arrive at the benefit side of the benefits costs calculation There are some items for which the meaning is not intuitive A few of those are clarified below Final IDAS Manual 86 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Number of periods per year sho
39. Strategic Deployment Plan Update May 2013 The combination of these two attributes one with three possibilities the other with two provides a total of six distinct V C curves that can be applied to facility types V C curves are applied to a facility type not on a per link basis There is no ability in IDAS to supply a different curve for different links that share the same facility type number If there is such a situation where certain types of links will utilize a different curve a new facility type must be added and that value used for links of that type 7 2 Maintaining V C Curves Outside of IDAS To facilitate the later import of V C curves into IDAS an Excel spreadsheet should be used to calculate and maintain the curves in tabular form Typically it is recommended a single spreadsheet be used as described in Section 4 0 to manage facility types and district types Figure 7 1 shows a screenshot of such a worksheet with a portion of the tabulation Final IDAS Manual 47 FAMPO Regional ITS Strategic Deployment Plan Update Figure 7 1 V C Curve in Tabular Form do c ldasSetup ls Compatibility M _ m Hom inser Page Form Data Revie View Deve Acrol xX 02 4 ip v PivotTable Table Picture Charts Hyperlink Tables Illustrations Links Tu Al fe 2 3 4 CurveName AreaType VCRatio SpeedFactor 5 freeway 1 0 1 00000
40. amp M 6 000 00 6 000 00 6 000 00 6 000 00 6 000 00 Private O amp M 0 00 0 00 0 00 0 00 0 00 User Defined Cost 3 AM FAM ATMSDunn 001 Traffic Signals Lump Sum Provided Done Public Capital 1 350 000 00 0 00 0 00 0 00 0 00 Private Capital 0 00 0 00 0 00 0 00 0 00 Public O amp M 135 000 00 135 000 00 135 000 00 135 000 00 135 000 00 ACTIVE Private O amp M 0 00 0 00 0 00 0 00 50 00 Project FAMPO User Defined Cost 4 AM FAM ATMSFaye 001 Replacement CCTV Camera PTZ Public Capital 203 500 00 0 00 0 00 0 00 0 00 Alternative AM Private Capital 0 00 0 00 0 00 0 00 0 00 Public O amp M 13 750 00 13 750 00 13 750 00 13 750 00 13 750 00 0 0 00 so 50 ITS Option Costs Private O amp M 0 00 0 0 0 00 0 00 00 User Defined Cost 5 AM FAM ATMSFaye 002 Replacement CCTV Camera PTZ Public Capital 203 500 00 0 00 0 00 0 00 0 00 Private Capital 0 00 0 00 0 00 0 00 0 00 Public O amp M 13 750 00 13 750 00 13 750 00 13 750 00 13 750 00 Private O amp M 0 00 0 00 0 00 0 00 0 00 Uer pened Cost 6 AM FAM ATMSFave 003 Sum Provided 4 Step 4b Double right click this spreadsheet to bring up the VCI formula one internal spreadsheet for the user defined costs as shown in Figure 11 5 e Step 4c Save the file either by choosing File Write from the main menu or clicking on the diskette on the toolbar Any name can be used but stream of costs
41. analyze the impacts of ITS deployments Table 1 1 presents a sample of the locations and purposes of these IDAS studies Table 11 Sample IDAS Applications Location Study Type Type of ITS Deployment Orlando Region Regional ITS Long Range e Variable Message Signs Deployment Plan e Arterial Signal Coordination e Transit Signal Priority Transit AVL Cincinnati OH Evaluation of ITS Components e Incident Management e Variable Message Signs e Traveler Information Systems Several of these sample studies have been documented in case studies available on the IDAS web site at http idas camsys com Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update Location Detroit MI Wisconsin Michigan Kansas City SCOUT St Louis MO Florida DOT District 5 NCDOT Triangle Region Study Type Short Range Pre Deployment Study Regional Deployment Plans in Northeast and Southwest Regions Regional Deployment Plans in 5 DOT Regions Evaluation of Existing and Proposed ITS System Arterial ITS Strategic Deployment Plan Evaluation of Existing System Regional ITS Strategic Plan May 2013 Type of ITS Deployment Incident Management Variable Message Signs Traveler Information Systems Traffic Surveillance Freeway Management Systems Incident Management Traveler Information Systems Traffic Gates and Law Enforcement Support Freeway Management Systems Incident Management Road
42. by First defining the new market sector by selecting File gt New gt Market Sector from the main menu Providing some general parameters for the market sector e g average vehicle occupancy Indicating the data file name and location Defining the data file contents Figure 6 2 shows an example of the parameters used in importing the All Traffic market sector data from the FAMPO model Final IDAS Manual 43 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 6 2 Sample Market Sector Input Parameters Ift IDAS ITS Deployment Analysis System E File View Modules Reports Window Help G Workspace DAPROJECT WORK TRIAML Market SectorSOV Sees Market Sector Import Data Control Altemative s SOV Note The Maximum Centroid ID is 2389 visit setup to change HOV Description 4 Combine All Files and Import One File faster Import n C Import each file at a time use only for re importing i Multiplication E poss 5 Trip Matrix File 1 540 FMS 4 Auto Single Occupancy Tip Type 1 0 D project work Triangle Arch Mo File z Pieds FMS C Auto Multiple Occupancy Vehicle In Vehicle Time 5 Us 70FMS 2 vu apr C Person 10 ee C Exxess Du Out of Vehicle Time ess s Average Vehicle 1 0 NC54FMs C Light Rail ml gt NC5SFMS C Heavy Rail Out of
43. due to changes in cost information without having to re deploy ITS options in IDAS while at the same time ensuring consistent application of costs data across all affected analysis results e Section 12 0 Using the Alternatives Comparison Module This section describes how to use the alternatives comparison module and how to compare multiple ITS options to each other e Section 13 0 Managing IDAS Results This section demonstrates the spreadsheet tools that have been developed to manage the volumes of benefits and costs data that get created during an analysis of an appreciable size Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 2 0 IDAS Overview 21 What Is IDAS The ITS Deployment Analysis System IDAS is an ITS sketch planning analysis tool that can be used to estimate the impacts benefits and costs resulting from the deployment of ITS components IDAS was developed by the FHWA to assist public agencies and consultants in integrating ITS in the transportation planning process IDAS offers the capability for a systematic assessment of ITS and is used for determining the benefits and costs of various ITS deployments IDAS operates as a post processor to travel demand models such as TRANPLAN and TransCAD used by metropolitan planning organizations MPOs and by state departments of transportation DOTs for transportation planning purposes IDAS although a sketch planning tool implements
44. evaluating ITS projects and assessing the impacts of ITS investments Although this document provides a great deal of information regarding IDAS it is not intended to fully document the application and use of these tools The latest IDAS documentation is available at http idas camsys com Most of the information presented here is in fact not included in the information posted on the aforementioned web site That information pertains to the methodologies of IDAS as well as information on interfacing a stock or generic model into IDAS However in the present case we are going through the details of importing a specific model using tools that were not available when IDAS 2 3 was released June 2003 and we will be discussing some analysis support tools that have only recently been developed 12 Project Background This document has been prepared as part of the Fayetteville Area ITS Strategic Deployment Plan Update The overall purpose of this project is to develop an integrated strategic deployment plan for Fayetteville specifically the Fayetteville Area Metropolitan Planning Organization FAMPO To that end there are several key tools references and guidance documents that will be developed as part of the effort These include an evaluation of successful practices in other areas development of regional vision goals and objectives and a gap assessment for the region The project also includes updating of the regional ITS arch
45. expenditures including replacement and new deployments The stream of costs only shows those ITS Groupings that are also selected on the left side of the Results worksheet However every time that combination changes a user needs to click the Calculate as shown in the above figure Recalculation of this worksheet is not automatic because it is slow Therefore a Calculate button is provided circled in Figure 13 6 to regenerate this graph when desired Reviewing the Report Table and the Physical Performance Measures The IDAS Results workbook contains the Report Tables spreadsheet shown in Figure 13 7 which arranges the information shown on the Results Main B C spreadsheet in row form while grouping them in higher level groups such as all time savings dollar values into one travel time benefits cell There will be as many rows in the main dollar values report table as there are selected ITS Option groups on the Results worksheet In other words the current active mix is reported in the dollar values table Below the dollar values the user can see the actual performance measures IDAS calculated for the ITS Options e g total VMT total fuel emissions etc Figure 13 9 shows most of these parameters there are some emissions values to the right that are not shown to keep the figure at a minimum zoom level Final IDAS Manual 107 FAMPO Regional ITS Strategic Deployment Plan Update May 2013
46. future This is illustrated in the next section by the Costs Stream While this tabulation is occurring the system uses this value in the present value calculation for future expenditures Final IDAS Manual 104 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 It is important to remember that this is not an inflation rate nor is it related to the change in the cost of equipment in the future Equipment costs are expected to be the same in the future as they are now albeit in relative year dollars The Costs Stream To see the way that IDAS has calculated the future stream of costs visit the Costs Stream sheet in the IDAS Results workbook When activated this worksheet will pull together all the equipment that is allocated to the chosen ITS Options these are the groupings that are selected on the left side of the Results sheet Final IDAS Manual 105 Deere nOOOILU P ILELLLCLLLLAuSiSXsiXxXi ABAG 3EIFILML LSLVIVVL LnniC Ex c xouxzDAF E FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 6 Stream of Costs Hss y IDAS Results xlsm Microsoft Excel dm RU Home Insert Page Layout Formulas Data Review View Developer a x m J 1 pert Cut Arial ja Ep Wrap Text Currency M dM l zac d Copy rin Paste gt
47. in the table The V C curve table must be given the name vccurves As with other Excel named ranges select the entire table including the header row and insert a named range with this name e Importing the tabular data into IDAS is explained in Section 7 4 Before that is done however it is necessary to create the mapping between the link facility and area types to the appropriate V C curve as discussed in the next section 7 3 Associating V C Curves to Links Because the FAMPO model actually does have the two parameters a and present on each link in the data we set the facility type code for each link based on which curve is indicated by those parameters This works well because the vast majority of links with a unique combination of a and are of the same facility type Figure 7 2 VC Curves used in the FAMPO analysis e 0 56 3 60 Urban Freeway 0 71 2 10 Urban Arterial t 0 83 5 50 Rural Freeway 0 83 2 70 Rural Arterial 1 00 2 10 Urban Ramp 2 1 00 5 40 Rural Ramp Figure 7 2 shows the curves for the distinct a and in the FAMPO network The legend indicates which Facility Type was chosen based on the a and on each link The facility Final IDAS Manual 49 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 type codes used are 1 through 6 ordered top to bottom in the legend The Centroid Connectors where a and are not important
48. link This is not always the case often model data will relate the alpha and beta values to the link through the facility type code of the link Final IDAS Manual 14 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Because the information was available for each link we did not have to ask the modeler for the relationship between facility type and specific BPR Bureau of Public Roads functions The method used to relate facility type to BPR curve is therefore outlined in Section 5 3 4 Provide the Requisite Data to the IDAS Analyst The IDAS analyst will need to be provided the data files and information provided in this section along with a few other ancillary items e The meaning of facility type codes in the links output file e A mapping of each facility to a facility class freeway arterial or ramp e The details about the capacity figure in the links output file e Is the capacity per link or per lane e What time period is being evaluated e The volume at capacity on each link if available e Whether the link speeds provided from the model are for free flow or congested conditions Any level of link performance information that can be provided such as total VMT VHT or average speed by facility is helpful in conducting the validation Sections 4 0 5 0 and 6 0 detail the required steps to use the model data in IDAS Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Upd
49. operational alternatives to be evaluated Data needed for this analysis is listed below 29 Devices Operational strategies Costs capital and O amp M Location of deployments Package deployments at a level that reflects the goals of the analysis 30 ITS Strategic Deployment Plan Update Final IDAS Manual A 2 March 2010 IDAS Manual Export TransCAD files to IDAS Export node and link files 13 Export turn penalty files if required 14 Export trip tables highway market segments transit market segments 15 Export other key files as needed transit travel time skims volume delay curves 16 Prepare IDAS for analysis Provide required zone and area type information 22 Enter maximum zone ID in entry screen 22 Develop matrix matching IDAS facility and area type codes to equivalent TDM codes 22 Develop facility type table 24 Define and set up districts and district names 26 Copy database 31 Import network data Set up fields for extract process extract data selection window 34 Select fields from TDM and associate them with IDAS 35 Convert two way TransCAD links to one way IDAS links 36 Add required IDAS fields not in the TDM time speed indicator conversion of link to lane capacity area type district or travel types not available in TDM data 38 Run the Extract Data tool to export files to IDAS and check files 39 Create node file 41 Convert location informatio
50. per year The value 247 is 52 weeks of 5 days minus 13 holidays e Year of dollar values This is the year for which all dollar values in the column are valid for These dollar values do not have to be in the current year or the year of reference purposes only these values not used in any calculation Final IDAS Manual 103 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 reporting they can be in any year and the workbook will correctly use them along with the inflation rate below it e Inflation rate Used in conjunction with the year above it This value has nothing to do with equipment costs or economic analysis on equipment It is only used to change the dollar values in this column from the year of dollar values to whatever year the benefits are being referenced which is the year of reporting As an example the user may decide to use a value of time from 2005 but want to conduct a benefit cost analysis for year 2010 The inflation rate would be used to adjust the 2005 value of time to 2010 e Actual values Most of these are self explanatory with a few additional notes o Value of time for emergency vehicle multiplier This is not a dollar figure but a multiplier on the in vehicle time value o Internal external accident costs Internal refers to costs experienced by the traveling public involved in accidents such as lost income repair costs etc External refers to the cost t
51. right of Node Coordinates File field in Figure 5 6 opens a file open dialog Navigating the file selector to the saved Node csv file created in preparing the network data the following import specification window appears Figure 5 7 Importing Nodes ea e Jr eese fixed length Input File Contents Please click on the first row from which you want to begin importing data Then choose the appropriate field description for each column from the drop down selectors delimited Rows of data located above the selection will not be imported remove char from file Nodes from the Model Shapefiles ID Lon Start Lat Start Lon End Lat End 20000 78 58136934 893118 78 58136934 893118 NodeN pem cooxa1 fitt Isl d 20000 78 581369 34 893118 78 581369 34 893118 20001 78 572597 34 88126 78 572597 34 88126 20002 78 523732 34 882196 78 523732 34 882196 20003 78 552305 34 888358 78 552305 34 888358 20004 78 551646 34 915542 78 551646 34 915542 20005 78 568446 34 908243 78 568446 34 908243 20006 78 532122 34 873288 78 532122 34 873288 20007 78 645637 35 155585 78 645637 35 155585 20008 78 640255 35 155648 78 640255 35 155648 20009 78 636489 35 158134 78 636489 35 158134 20010 78 634855 35 155365 78 634855 35 155365 20011 78 645177 35 18294 78 645177 35 18294 20012 78 64257 35 170387 78 64257 35 170387 4 7 import cancel
52. some situations the IDAS module is very close The assignment routine within IDAS was built by Urban Analysis Group now Citilabs the creator of the TRANPLAN travel demand model platform Therefore it is often found that matching IDAS results with TRANPLAN produces results in the 2 to 5 percent difference range However it is noted that the way IDAS benefits are intended to be assessed effectively insulates the system from large discrepancies between it and the TDM s performance output When benefits are calculated in IDAS it is always the difference in the network performance results that is taken into account For example the change in speed on a freeway link between a traffic assignment done after an ITS deployment is in place Final IDAS Manual 62 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 and the traffic assignment in the absence of that deployment called the Control Alternative Where some differences may exist between the model s assessment of speed and that of IDAS the underlying cause of that discrepancy will not impact on the change in speed Said another way if one used the model and ran it twice the second time having applied the same network changes IDAS would apply the model is very likely to come up with the same performance delta that IDAS did and it is this delta that drives the benefits side of the analysis Data Required for Validation In Section 8 0
53. sos a ee eon ea eo esa an essa 92 13 2 Why Is Results Management 21 eese etta sete to setate setas eene 93 13 3 The IDAS Results Workbook eee e ee eee eene eere etta sette seta sese ense ee 94 Final IDAS Manual TABLE CONTENTS FINAL IDAS MANUAL APPENDIX QUICK REFERENCE A 1 APPENDIX B QUALIFICATIONS FOR IDAS ANALYST cccsssssscssssscccsssscccssssccccssssccecesssscecessceeceses B 1 APPENDIX C REQUIREMENT TEXT FOR OUTSOURCING IDAS COMPATIBLE TRAVEL DEMAND MODEL DEVELOPMENT R R C 1 Final IDAS Manual iii TABLE CONTENTS FINAL IDAS MANUAL LIST OF FIGURES Figure Bos IDAS Data ii Figure T LIDAS ntc oo sac erect tae date x eu ce not ctr eh een 3 Figure 2 1 IDAS Analysis PEOCGSS ee op qe ipe dubie ste ete dei 9 Figure 3 2 Example TDM Showing Nodes 12 3 2 Vehicle THp cep eb d FASENE 14 Figure 4 1 IDAS Setup TDM ata Det UU 18 Figure 4 2 IDAS Setup Facility as E be oe Eri 19 Figure 4 3 Facility Types in an Excel Spreadsheet x23 225 npe hoe Rd isla Ree 20 IDAS Setup District
54. the scenes populating the list of equipment that is expected to be necessary to build the deployment The logic behind selecting which equipment is required including which supporting equipment such as communications facilities etc works well while generic is also very difficult to customize for a specific region or location Because of this it is usually best to ignore the equipment populated on the ITS deployments by IDAS and to instead utilize a series of powerful costing spreadsheets that can be used to specify customized equipment costs which most agencies have readily available These techniques take advantage of the IDAS cost module capabilities which in correctly assess the capital and O amp M costs for future years by importing costs into a special Costs ITS Option into what are termed the User defined costs Doing this in a systematic way described in Section 11 0 will make the comparison of benefits versus costs much simpler while managing large volumes of data in a way that prevents the wrong costs from being applied to the wrong ITS Option and vice versa Final IDAS Manual 77 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 11 0 Managing Equipment and Deployment Costs Topics Covered in This Section e Using anew method to manage ITS costs e Manage equipment lists in external spreadsheet s e Use a specific naming convention to assist in results management e Import equipment lists in
55. the 2035 AM AII traffic matrix is as follows combinetrips OD Highway AM Auto txt OD Highway AM Preload Auto txt gt OD Highway Part1 txt combinetrips OD Highway AM Preload Truck txt OD Highway AM Truck txt gt OD Highway AM Part2 txt combinetrips OD Highway AM Part1 txt OD Highway AM Part2 txt AM TotalTrips trp In the example the Preload and Normal are combined for auto then for truck and finally the results of these 2 are combined A similar procedure was followed for all time periods for all 3 networks B 6 3 Importing the Market Sector Data The following is the procedure for importing market sector data Final IDAS Manual 42 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Step 1 Prior to the import of any market sector data the maximum zone number used in the model first must be defined in IDAS This information is entered using the Setup menu option as shown in Figure 6 1 In the FAMPO Model this value is 1 051 Figure 6 1 Entering the Maximum Zone Number IDAS Setup TDM Data Facility Types Districts Data Maintenance ITS Equipment Sharing Importing Regionalized TDM Data Maximum External AND Internal Centroid ID Number 1051 Translation From TDM Input Area Type to Urban Suburban Rural o B C Urban Suburban Rural All Urban All Suburban Rural e Step 2 The market sector data are then imported as a new market sector
56. the left Figure 13 2 Selecting ITS Options to Combine IDAS ITS Deployment Analysis System File View Modules Reports Window Help amp k E Alternative Comparison Module TS Option Comparison Cost Adjustment Select ITS Options For Comparison 5 Value of Time ber of d x In Vehicle number of periods per year 247 Out of Vehicle Available ITS Options ITS Options for Comparison Travel Time Reliability Cost of Fuel KU 2E kt 2E Non Fuel Vehicle Operating Costs AM AM AM AM Emission Costs AM FAM ATM AM FAM ATM Accid 5 001 5 005 5 002 SFaye 003 ccident Costs Replacement 5 Replacement Replacement Fatality Injury AM Property Damage Only AM FAM ATM AM FAM ATMS AM FAM ATM AM FAM ATMS Noise Damage Costs SFaye O04FM 1295 002FMS 51295004 NC24 001FMS 5 Replacement Other Mileage Based Costs ea 8 Other Non Mileage Based Costs AM AM AM AM Risk Analysis AM FAM ATMSAM FAM ATMS Select Ranges 5195 001 NC24 002FMS 87 001 5 505401 001 25 am am View Results AM M View Outputs Control AM FAM ATM AM FAM SPSI Benefit Cost Summary Altemative 5054014002 51295 005 295 00 5 Performance Summary Replacement Replacement by Market Sector by Facility Type by District
57. the links In other words the input file for IDAS will be saved from this worksheet but there will be several more supporting sheets containing data to link up with this root sheet Final IDAS Manual 29 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 It is also important to note that though not visible in the above figure there are flags in the FAMPO data that indicate whether each link is actually present in the 2006 network In other words there are future links that will be used in the 2035 network and its analysis In large part links that are not in the 2006 network must be manually deleted from the Excel worksheet for loading the 2006 network only of course Thus there are basically 3 main network worksheets one for each of the 3 networks These 3 base network link data sets form the set of links with the model ID and the direction specification AB or BA that can then be used to match to the data imported from certain TransCAD output files as described next 5 2 1 3 Obtaining specific link information As mentioned previously using the data stored in the TransCAD raw input data is not sufficient for the FAMPO model However because the intermediate output from the model files were available we did find a way to obtain the necessary link data for use in IDAS Because these files are binary files a special tool was written to extract the data and create flat files for import into our
58. the modal split and traffic assignment steps associated with a traditional planning model These steps are crucial to estimating the changes in modal route and temporal decisions of travelers resulting from ITS technologies Because IDAS is a sketch planning analysis system it is intended for use as an alternatives analysis tool and not for ITS operations optimization 2 2 Why Was IDAS Developed As the deployment of ITS increased during the 1990s the FHWA realized that several barriers existed to the analysis of benefits and costs of these types of deployments Principal among these impediments were e Many of the tools available to planners were focused on the analysis of traditional capacity enhancing infrastructure and were not sensitive to the operational impacts represented by ITS improvements e Planners were often unfamiliar with the specific impacts of ITS and had difficulty finding data regarding the impacts that were observed in other regions following the deployment of ITS IDAS was developed as a tool specifically focused on analyzing the impacts of ITS IDAS also was designed to serve as a repository of information on the impacts of various types of ITS deployments and of the costs associated with various types of ITS equipment By providing these capabilities IDAS has the ability to critically analyze and compare different ITS deployment strategies prioritize the deployments and compare the benefits of the ITS deployment
59. two either Urban or Suburban Rural e Step 3 Select Area Type code by using a spinner control The user can change the number inside the control until the desired code from the TDM is reached It has been found that using a directory off of the Documents and Settings directory can be problematic Some fields in the database contain file names and have a length of 128 characters Depending on the user s login name and other factors full physical file names for files stored here can be larger than this causing a SQL error at run time Matrix import files do not actually have to contain all of the nxn entries they can omit records where the trip count or other measure is 0 Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 then click the radio button for either Urban or Suburban Rural then move the spinner to the next code and so on The easiest way to do this is to press the All Urban or All Suburban Rural buttons then change only the remaining codes that are of the opposite meaning See Figure 4 1 For the FAMPO analysis area type 1 is Urban all others are Rural We will be using a calculated area type that is described in Section 5 which has a value of 1 or 2 Figure 4 1 IDAS Setup TDM Data Settings IDAS Setup acility Types Districts Data Maintenance ITS Equipment Sharing Importing Regionalized TDM Data Maximum External AND Inte
60. 0 0 0 0 0 0 0 0 0 0 360046 0 0 0 0 0 0 0 46 FAM ATMSFaye 005FMS 80 862 0 0 0 0 0 0 0 0 0 0 0 340062 0 0 0 0 0 0 0 47 FAM ATMSI295 002FMS 1 310 087 0 0 0 0 0 0 0 0 0 0 0 16 724 0 0 1 748 363 0 0 0 0 48 FAM ATMSI295 004 Replact 0 0 0 0 0 0 0 0 0 0 161 724 0 0 0 0 0 0 0 0 0 49 FAM ATMSI95B 001FMS 558 383 0 0 0 0 0 0 0 0 0 0 0 121 293 0 0 437 091 0 0 0 0 50 FAM ATMSNC24 001FMS 0 0 0 0 0 0 0 0 0 0 517 953 0 0 0 0 0 0 0 0 0 51 FAM ATMSNC24 002FMS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 238 761 0 0 0 0 52 FAM ATMSNC87 001FMS 0 0 0 0 0 0 0 0 0 0 121 293 0 0 0 0 0 0 0 0 0 53 FAM ATMSUS401 001FMS 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80862 0 0 0 0 54 FAM ATMSUS401 002 437 091 0 0 0 0 0 0 0 0 0 0 34370 0 0 0 0 M M Control Instructions Results Report Tables Costs Stream Supporting Deployments IDAS HAS Faye 001 Replacement Faye 002 Replacement Faye 003 Replacement 1 Ready Calculate 2 Final IDAS Manual 106 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 6 shows the deployed ITS Options under consideration and how much capital will be spent and when It also shows the constant amount of O amp M expenditures for each year and identifies the proposed years of various capital
61. 0 6 freeway 1 0 2 0 986406 7 freeway 1 0 3 0 976961 8 freeway 1 0 5 0 948182 9 freeway 1 0 7 0 889105 10 freeway 1 0 8 0 829254 11 freeway 1 0 9 0 715066 12 freeway 1 1 0 500000 13 freeway 1 1 1 0 294250 14 freeway 1 1 2 0 192090 15 freeway 1 1 4 0 110115 16 freeway 1 1 6 0 076707 17 freeway 1 1 8 0 058776 18 freeway 1 2 0 047619 19 freeway 1 2 5 0 032277 20 freeway 1 3 0 024407 21 freeway 1 4 0 016403 freeway 1 5 0 012352 freeway 2 6 0 009905 ility Types Figure 7 1 shows calculations of the V C curve over a range of V C of 0 to 6 highly congested This calculation is usually taken out to a V C of 12 Note that the tabulation step size is smaller around the area of highest change in the curve May 2013 near 1 at a step size of 0 1 and the step size can be larger in other areas of the curve Requirements for V C curve table To summarize the format of the tabular representation of the curves note e The header row row 4 in the figure must be present and organized as shown Each curve type Freeway Arterial Ramp must be in the table e For each type both area type 1 and 2 must be present Final IDAS Manual 48 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e They should be in order that is first Freeway area type 1 and 2 then Arterial area type 1 and 2 and then ramps both area types e Case does not matter but spelling does e There should be no blank rows anywhere
62. 00 AM FAM ATMSI295 002FMS CCTV Camera PTZ 2010 2010 148 000 00 0 00 10 000 00 AM FAM ATMSI295 002FMS DMS Overhead Mount 2010 2010 1 600 000 00 0 00 24 000 00 AM FAM ATMSI295 006FMS CCTV Camera PTZ 2010 2010 148 000 00 0 00 10 000 00 AM FAM ATMSI295 006FMS DMS Overhead Mount 2010 2010 800 000 00 0 00 12 000 00 AM FAM ATMSI295 003 Communications Fiber Optic Cable 2010 2010 2 024 000 00 0 00 51 750 00 LT ESRB S Danlacamant CCTM Camara 2040 2040 QAAR nnn nn nn san nnn nn User Defined Item Ready Note Figure 11 4 is arrived at after a few steps First select Format Sheet and check off Protection Then select all visible columns and select Format Unhide from the menu It can be tricky but all columns should eventually be shown as above One might have to resize the cost columns that are on the right until they come into view In your main source costs spreadsheet organize your data as shown in the above figure For the first column prepend AM to your project name then fill out that row with the pertinent values keeping in mind you want totals for all of your equipment for the options except that you should split rows out when equipment has different useful life values Note the above figure has 2 rows for the first ITS Options cameras and DMS are split because they have different useful life values First delete all existing data clicking and dragging across the header row selects all press the
63. 0011875 1 139830 1 139949 0 000118746 34 215 03 33 872 88 342 1502853 74 195 008 Replacement 0 45 174 594 45 174 594 475 30 204 993 60 204 993 60 0 00 0 799590 0 799590 0 76 751634 76 751634 0 2 303 904 27 2 303 904 27 0 75 195 009 Replacement 0 399 270 399 270 0 00 2 972 51 2 682 57 289 93 0 007067 0 006996 7 0671 05 0 678360 0 678431 7 0671E 05 20 362 79 20 159 16 203 6279026 76 195 010 Replacement 0 6 587 962 6 587 962 69 30 4904635 4904635 0 00 0 116607 0 116607 0 11 192947 11192947 0 335 986 04 335 986 04 0 77 Lumb 001 0 135 300 135 300 0 00 3 97 3 97 0 00 0 002395 0 002395 0 0 229875 0 229875 0 6 945 90 6 945 90 0 T8 NC24 87 001FMS 0 303 000 303 000 51 00 453 73 410 39 43 34 0 005363 0 005318 4 4958 05 0 514797 0 514842 4 4958 05 15 523 00 15 393 46 129 54 79 NC87 002FMS 0 52 000 52 000 0 00 0 17 0 16 0 02 0 000920 0 000911 9 204 06 0 088348 0 088357 9 204E 06 2 652 00 2 625 48 26 52 80 87 003 5 0 31 400 31 400 0 00 0 02 0 02 0 00 0 000556 0 000550 5 558 06 0 053349 0 053354 5 558 06 1 601 40 1 585 39 16 014 82 SPSI295 001FSP 0 15 736 050 15 736 050 0 00 21 573 21 20 244 03 1 329 18 0 238327 0 238203 0 00012374 22 700316 22700316 0 932 338 83 931 601 61 737 2246094 83 1295 005 Replacement 0 15 736 050 15 736 050 156 80 21 57321 21 573 21 0 00 0 238327 0 238327 0 22 700316 22 700316 0 93233883 932 338 83 0 84 1295 006 5 0 12 891 354 12 891 354 61 80 10 923 24 10 778 19 145 05 0 194248 0 194217 3 1043 05 18 331
64. 1 IDAS Data Flows Impact Analysis of Traditional Infrastructure Improvements Network Characteristics Manual Data Interface Trip Tables Link Volumes and Speeds Impact Analysis of ITS Deployments Link Volume and Speeds Change in Travel Time Change in Emissions Change in Accidents Benefit Cost Comparison Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e At which geographic locations does the deployment of ITS components provide the greatest level of benefits e What is the impact of combining different types of ITS components How do the benefits of various deployment scenarios compare to costs either on an annualized basis or over a period of time Although primarily developed to answer these types of questions regarding future potential deployments the IDAS software also has the capability to provide estimates of benefits and costs of ITS components that have been previously deployed and are currently operating IDAS can be used in various planning efforts including Deployment of regional ITS architectures e Statewide regional and local ITS plans TTS alternatives analysis for long range planning e ITS strategies for corridor studies e Evaluations of ITS components or systems e ITS strategic plans or pre deployment studies Since its initial release in 2000 IDAS has been applied by dozens of different regions to
65. 2006 Links SA 2 AJ 6713 14 FALSE N o P a R s 1 10 IDAS Volume Input Volume Difference Pct Difference VMT IDAS Speed Model Speed 2 000001 022223 0 07 0 07 73 53 73 53 73 718 0 188 0 26 2 9412 34 28571429 35 0 714285714 2 08 3 000002 021431 0 07 0 07 48 58 48 58 48 556 0 024 0 05 1 9432 34 28571429 35 0 714285714 2 08 4 000002 021435 0 14 0 14 73 59 73 59 74 069 0 479 0 65 5 8872 34 28571429 35 0 714285714 2 08 5 000003 021401 0 3 0 3 23 71 23 71 23 04 0 67 2 83 4 0307 34 35 1 2 94 6 000003 021978 0 24 0 24 31 62 31 62 32 619 0 999 3 16 4 4268 35 35 0 0 0076 7 000004 021339 0 07 0 07 56 85 56 85 57 083 0 233 0 41 2 274 34 28571429 35 0 714285714 2 08 8 000004 021341 0 52 0 52 16 92 16 92 16 709 0 211 1 25 5 076 34 61538462 35 0 384615385 1 11 9 000004 021429 0 39 0 39 11 19 11 19 11 494 0 304 2 72 2 5737 35 38461538 35 0 384615385 1 09 10 000005 021343 0 09 0 09 129 06 129 06 129 325 0 265 0 21 6 453 33 33333333 35 1 666666667 5 00 11 000006 021302 0 43 0 43 57 16 57 16 53 138 4 022 7 04 14 29 34 88372093 35 0 11627907 0 33 12 000006 021304 0 24 0 24 105 72 105 72 110 071 4 351 4 12 14 8008 35 35 0 0 00 13 000006 021965 0 26 0 26 4 01 4 01 4 014 0 004 0 10 0 6015 34 61538462 35 0 384615385 1 11 14 000007 021348 0 31 0 31 74 9 74 9 68 036 6 864 9 16 13 482 34 83870968 35 0 161290323 0 46 15 000007 021692 0 22 0 22 73 76 73 76 81 302 7 542 10 23 9 5888 35 45454545 35 0 454545455 1 289
66. 21434 0 08 35 10000 1 6 0 14 0 14 28 22 28 22 25 000011 021460 1 21460 0 07 35 10000 1 6 012 012 40 05 40 05 26 000012 021364 12 21364 0 06 35 10000 1 6 01 01 24 69 24 69 27 000012 021391 12 21391 0 05 35 10000 1 6 0 08 0 08 4 11 4 11 4 Setup Alpha Beta Curves Netrslts Netrsits EC 2035 Ready 2 We see the sheet generated from the netrslts file with the following changes Final IDAS Manual 67 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Row 1 has been inserted to provide labels for the columns which are not present in the netrslts file For reference the columns in the netrslts file are A Node B Node Distance Input Speed Lane Capacity Number of Lanes Facility Type Travel time minutes for each market sector If more than 1 market sector a column exists for each Average travel time for all market sectors Volume for each market sector Total volume for all market sectors e Column A has been inserted and an ID field generated by combining the A and B node numbers columns B and C using the Text Function padding the values to six characters left zero filled It is important to follow this pattern in order to be sure that the ID field is 10076 unique Tip Once this worksheet has been setup re importing netrslts after fixing any issues for example should be done by first deleting the data in columns B thru L in rows 2
67. 4 through 9 have a direct and influential impact on how the data are formatted and input into IDAS Steps 2 and 3 Section 4 0 provides additional discussion on how the needs of the analysis impact the overall structure and conduct of the analysis Additional information regarding the structure of IDAS and its processes is presented as Appendix A Even more detailed information is presented in the IDAS User s Manual which is distributed electronically with the IDAS software or is available on the IDAS web site at http idas camsys com 24 KeyTerms Several key terms used in this document are described below These descriptions are provided to clarify key concepts of IDAS to the user More detailed descriptions of specific variables are provided in the relevant sections discussing those variables e Network A network refers to the collection of zones centroid connectors roadway links and link attributes that represent the transportation system infrastructure Market Sector A market sector is a concept unique to IDAS and is generally defined by a common set of input trip tables that define the zone to zone travel demand characteristics Market sectors within an alternative typically will define the different modes of transportation available for analysis they also may be used for defining different trip purposes times of travel or other variables Database The IDAS database serves as the repository of the data read in
68. 6 16 000007 021838 0 25 0 25 2 33 2 33 2 332 0 002 0 09 0 3262 33 6 35 1 4 4 17 17 000008 021400 0 12 0 12 13 79 13 79 14 218 0 428 3 10 0 9653 35 35 0 0 00 18 000008 021402 0 2 0 2 20 56 20 56 20 488 0 072 0 35 2 2616 33 35 2 6 06 19 000009 021411 0 06 0 06 61 57 61 57 61 903 0 333 0 54 1 8471 30 35 5 16 67 20 000009 021670 0 17 0 42 0 451 0 031 7 38 0 042 35 29411765 35 0 294117647 0 83 21 000010 021438 0 9 6 04136 1 50 33 ReExported Links i ndn CMM OMM In the figure Input volume is directly from the FAMPO TDM and it is found using VLOOKUP against the 2006 Links sheet which is the master links sheet for the 2006 network which has the same ID generated in column A Similarly speed is found from the model Column R and speed is calculated from the travel time column in the IDAS results Column Columns 5 and T show the difference and percent difference in speed Finally Figure 9 6 shows the summary error analysis of the comparison of all rows Final IDAS Manual 69 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 9 6 Summary validation chart 5 links 3 Home Inset Pagelayout Formulas Review View Developer V Formula Bar Q 3 H E Eme ness e a V Gridlines V Headings SE ves i Hide hron lling
69. 6 0 137485 0 137478 6 886 06 12 973734 12 973734 0 465 978 06 465 942 45 35 60668945 64 US401 001FMS 0 8 986 791 8 986 791 0 00 5 371 24 5 371 24 0 00 0 137485 0 137461 2 308 05 12 973734 12 973734 0 465 978 06 465 904 35 73 70117188 65 US401 002 Replacement 0 8 986 791 8 986 791 49 60 5 371 24 5 371 24 0 00 0 137485 0 137485 0 12 973734 12973734 0 465 978 06 465 978 06 0 66 Dunn 001 0 26 431 26 431 0 00 0 05 0 05 0 00 0 000468 0 000468 0 0 044906 0 044906 0 1 400 84 1 400 84 0 67 174 001 Replacement 0 391 122 391 122 0 00 8 64 7 87 0 77 0 006923 0 006880 4 3268 05 0 664516 0 664560 4 3268 05 19 947 22 19 822 55 124 6701445 68 174 002 Replacement 0 6 722 410 6 722 410 70 70 47 56 47 56 0 00 0 118987 0 118987 0 11421374 11421374 0 342 842 90 342 842 90 0 69 174 003 Replacement 0 407 419 407 419 0 00 17 47 15 50 1 67 0 007211 0 007139 7 2113 05 0 692204 0 692277 7 2113E 05 20 778 36 20 570 57 207 7835741 70 174 004 Replacement 0 22 298 725 22 298 725 234 60 751 18 751 18 0 00 0 394687 0 394687 0 37 885534 37 885534 0 1 137 23498 1 137 234 98 0 71 195 005 Replacement 0 770 021 770 021 0 00 3 137 01 2 831 03 305 98 0 013629 0 013493 0 00013629 1 308266 1 308403 0 000136294 39 271 10 38 878 38 392 710955 72 195 006 Replacement 0 47 460 213 47 460 213 499 40 258 953 73 258 953 73 0 00 0 840046 0 840046 0 80 634902 80 634902 0 2420 70 85 2 420 470 85 0 73 195 007 Replacement 0 670 883 670 883 0 00 2 804 09 2 530 58 273 51 0 011875 0 011756 0 0
70. 702 18 331702 0 710 333 30 710 155 59 177 7050781 85 0 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 86 0 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 0 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 001 0 88 0 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 89 0 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 900 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 910 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 920 0 0 0 0 00 0 00 0 00 0 00 0 000000 0 000000 0 0 000000 0 000000 0 0 00 0 00 0 93 Total Impacts 7 581 300 431 614 300 424 033 1 785 80 658 189 55 655 514 92 2 674 64 4 898052 4 897080 0 00097188 466 407659 466 405976 0 00168247 15 824 572 85 15 820 079 80 4493 048173 94 M 4 M Control Instructions Report Tables ents IDAS 2 002 Repla Ready 2 Final IDAS Manual 109 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Notes on Viewing the Results e It is important to note that these performance values are the combined values for all ITS Options that comprise a group For example our Faye 001 Replacement grouping really contains 4 ITS Options 1 for each of four time periods The VMT shown for this grouping is therefore 4 times any one of them e If you want
71. 707 3 201 8 797 10 930 38 288 5 649 17 568 3 205 5 732 10 504 38 119 Benefit Cost Summary Difference 4 0 68 139 0 84 400 14 5 0 14 254 0 2 169 0 48 Number of Person Trips DM Control Alternative by Facility Type NS On by District Difference Number of Fatality Accidents Control Alternative 2 74668 03 0992 03 2 10448 02 ITS Option o 2 74658 03 2 6 03632 03 2 10888 02 Difference 36 9 8228 07 0 83 1 6E O5 0 2 2 747 08 0 0 1 564E 06 2 8768 06 0 08 1 064 05 0 14 Number of Injury Acciderits Control Altemative 1 37828 02 9 33695 2 6363 01 1 69998 01 5 85468 01 1 96688 00 ITS Option 1 37138 02 2 63648 01 1 6987 01 5 85188 01 1 9678 00 Difference 9678 05 0 8 2 629E 06 0 08 1 2788 04 0 18 2 7618 0400 0 1 065 03 0 14 Number of PDO Accidents Control Alternative 1 78588 02 1 a 5237z 01 2 8363z 00 ITS Option 1 77688 02 1 36198 00 01 2 2 51972 01 2 827940 Difference 36 5 0285 05 0 5 2 236E 03 0 28 3 815 06 0 0 1 7618 04 0 18 4 0185 04 0 08 1 5725 03 0 18 Travel Time Reliability hours of unexpected delay Control Alternative 2 52 508 85 AM FAM ATMSFaye 003 Replacement 411 1 Show Centroid Connector Data Emissions data does not include cold start or trip duration amounts Accident data does not include intersection collisio
72. 73y Others 43 Others 2759 6 7 8 1 2 3 4 5 6 3 27 6 20 2 48 040 12 92 0 26 E 0 19 0 18 029 0 07 0 07 021 42881 833 126 07 65230014 32283594 65220672 22637243 2 13 m 400 5 1 200 8 9 20 2 000 7 22 4 1 2 3 4 5 4 7 23 24 200 25 26 27 28 400 23 Volume 30 In the 2035 network there is a facility type where IDAS is 12 low However this is for facility type 5 where there will be no deployments made As networks get more congested IDAS and a model are likely to drift apart on secondary roads but we always want to make sure that facility types where deployments will be made are as close as possible and for these the comparison is good Final IDAS Manual 71 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 10 0 Creating ITS Options Topics Covered in This Section e Using the IDAS Alternative Network Generator ANG e Selecting ITS Strategies and placing them on ITS Options e Specifying the location of the deployment e Specifying the effectiveness of the deployment e Creating a transit deployment e A special note regarding equipment population and costs 10 1 Introduction to the IDAS Alternative Network Generator The Alternative Network Generator is the graphical tool in IDAS which is used to deploy ITS Strategies in deployment groups called ITS Options Final
73. AD export utilities see Section 6 0 3 2 1 Exporting Vehicle Trip Tables The vehicle matrices are located in the Output folder and are TransCAD mtx files There are eight separate O D mtx files two auto and truck for each period AM MD PM and Off Peak To export this file in TransCAD open the AM peak period O D matrix file it should look similar to the Figure 3 3 Final IDAS Manual ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 3 3 Vehicle Trip Matrix 52 TransCAD Licensed to Kimley Horn File Edit Matrix Tools Procedures Networks Paths Route Systems Planning Transit Routing Logistics Statistics Window Help 0B id amp sov 1 4A 5 f Z o En d S n Matrix1 AMTrip 50 MatrixView 2389 rows by 2389 columns INetwork None From the TransCAD menu choose Matrix gt Export select the option Cell with a field for each matrix and then select to include all matrices SOV HOV and CV When asked to Save As change files of type to comma delimited text txt csv and save to your desired location Repeat these steps for all matrices Note that the auto and truck files produced this way were later combined to represent all traffic using a technique described in Section 5 33 Volume Delay Curves The FAMPO model s link data included the alpha and beta values for the Volume Delay function for each
74. ATMS03 2 _ not in IDAS o 8 intersections are included See shapefile and camera FAM ATMSFaye 004FMS Deploy ITS on Santa Fe and Yadkin 3 Fayetteville CCTVs Fayetteville ATMSOI 2 01 3 list for locations See shapefile and camera FAM ATMSFaye 005FMS Deploy ITS on US 401 Ramsey Street 4 Fayetteville CCTVs Fayetteville ATMSOI 2 02 4 lt gt M Control Deployments Equipment Specifications CCTV DMS 2 Ready 21 98825 Counti4 Sum 59295 EB E pug Figure 11 2 shows our Costs spreadsheet Again it is keyed by the project name in Column C We also have the complete listing of all cameras Dynamic Message Signs and Fiber runs called out for the FAMPO study By keying that equipment to the project name we then automatically calculate the number of each required for each ITS Option These values for of DMS and Fiber miles would appear in columns L and M in the above Finally we have a menu of costs for each type of equipment This was provided in spreadsheet form a portion of which is shown in Figure 11 3 Figure 11 3 ITS Equipment Costs Per Item Costsaism Microsoft Excel cd ues a x Sees E b cst Calibri Sweep tet General Normal jes e er z E grin Paste U E
75. D B Node Distance FT IDAS Volume 000001 022223 1 22223 0 04 35 10000 1 6 0 07 0 07 73 53 7353 bo 3 000002 021431 2 21431 0 04 35 10000 1 6 0 07 0 07 4858 4858 4 000002 021435 2 21435 0 08 35 10000 1 6 0 14 0 14 73 59 73 59 5 000003 021401 3 21401 0 17 35 10000 1 6 0 3 0 3 23 71 23 71 _6 000003 021978 3 21978 0 14 35 10000 1 0 24 0 24 31 62 31 62 000004 021339 4 21339 0 04 35 10000 1 6 0 07 0 07 56 85 56 85 8 000004 021341 4 21341 0 3 35 10000 1 6 0 52 0 52 16 92 16 92 3 000004 021429 4 21429 0 23 35 10000 1 6 0 39 0 39 11 19 11 13 10 000005 021343 5 21343 0 05 35 10000 1 6 0 09 0 09 123 06 123 06 1 000006 021302 6 21302 0 25 35 10000 1 6 0 43 0 43 57 16 57 16 12 000006 021304 6 21304 0 14 35 10000 1 6 0 24 0 24 105 72 105 72 13 000006 021965 6 21965 0 15 35 10000 1 6 0 26 0 26 4 01 4 01 14 000007021348 7 21348 0 18 35 10000 1 6 0 31 0 31 74 3 74 9 15 000007 021692 7 21692 0 13 35 10000 1 6 0 22 0 22 73 76 73 76 16 000007 021838 7 21838 0 14 35 10000 1 6 0 25 0 25 2 33 2 33 1 000008 021400 8 21400 0 07 35 10000 1 6 012 012 13 79 13 79 18 000008 021402 8 21402 0 11 35 10000 1 6 0 2 0 2 20 56 20 56 13 000009 021411 3 21411 0 03 35 10000 1 6 0 06 0 06 61 57 61 57 20 000009 021670 3 21670 0 1 35 10000 1 6 0 17 0 17 0 42 0 42 21 000010 021438 10 21438 0 11 35 10000 1 6 0 2 0 2 9 07 9 07 22 000010 021439 10 21439 0 06 35 10000 1 6 01 01 9 11 23 000010 021979 10 21979 0 05 35 10000 1 6 0 09 0 09 3 82 3 82 24 000011021434 1
76. DAS Results system can now be seen All of the monetary values used to drive the level of benefits are in one and only one place down the middle left are the IDAS default values for these factors and to the left of that are the particular regional factors settled on for use by stakeholders familiar with local conditions The benefits of using the physical performance measures from IDAS in the form of facility type performance spreadsheets splitting out the equipment costs and allocations into the user defined costs Section 11 0 and placing the dollar valuations and tools to mix match and combine ITS Options into this one place are significant If one feels that the value of time for example is too low simply changing that value in Cell G10 applies the new figure everywhere No need to run the IDAS benefits module or to go to IDAS to export another B C workbook Some pertinent information regarding these valuation factors are e Travel days per year This is the number of days per year with conditions similar to that of the model IDAS is using For example if the model input to IDAS is an AM Peak period and if a PM period is not available typically this value is twice the number of weekday travel days per year This is to capture the benefit of the missing PM period for which no analysis was done In the case of the FAMPO work AM MD PM and off peak were available run and combined so this value would be the number of weekdays
77. DM This topic is covered in Section 9 0 Final IDAS Manual 61 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 9 0 Validating the IDAS Results Validating IDAS results specifically refers to comparing the assignment results from IDAS with the TDM IDAS assumes that the model itself has already been validated in TDM parlance and that the IDAS results can only be as good as those of the model Topics Covered in This Section When to Validate What is Close Data Required for Validation Initial Validation in the Alternatives Network Generator Detailed Validation at the Link Level When to Validate Validation should occur after database loading per Sections 4 0 through 6 0 V C curves have been created and have been imported Section 7 0 and the Control Alternative has been run through the benefits module Section 8 0 Do not deploy ITS Options on the network Section 10 0 without at least some comfort level that the results of the IDAS benefits module match reasonably close What is Close The IDAS assignment subroutine operates similarly to a travel demand model assignment Therefore the baseline output from IDAS should be reasonably similar but will not be identical to the output generated by the model Differences in the capabilities of the models and the required modifications to the network data described in the previous sections guarantee that the results will not be identical In
78. Delimiter to Comma and Text qualifier to single quote Click Finish This screen lets you set the delimiters your data contains You can see how your text is affected in the preview below Delimiters Tab Semicolon Treat consecutive delimiters as one Comma z Text qualifier Other Final IDAS Manual 66 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Now in the just opened worksheet select all rows and columns navigate to your master Links workbook and paste into a blank worksheet Since IDAS identifies links by A and B node numbers we use these two values to relate the IDAS results imported with the FAMPO model values in the volume column of the base Links spreadsheet the one that will provide the links import file for IDAS Investigating the following figure Figure 9 4 IDAS Results in link comparison worksheet On ld links xlsx Microsoft Excel Mr 2 Insert Formulas Data Review View Developer 7 X n X Calibri p General 52 gt gt ESE 3 Delete g d E 3 E E Tem 8 Format 27 ii Font Alignment f Number Cells Editing A2 3 fe TEXT B2 000000 amp 2 amp TEXT C2 000000 AA RINT NN SNNT NN NN IN n J K 1
79. GE RD 80 5 5 1 1 1 1299 862 1 688 43 737 55 44 6 1 0 20004 20005 290213 1 280768 BUTLER ISLAND BRIDGE RD 52 5 4 1 1 1 1590 316 51 336 49 416 55 49 5 1 0 20005 20004 290213 1 280768 BUTLER ISLAND BRIDGE RD 52 5 4 1 1 1 1590 316 30 432 49 472 55 49 5 5 1 0 20002 20006 290739 0 783681 NC HWY 242 50 5 4 1 1 1 1767 018 124 141 49 481 55 49 5 S 1 B 0 20006 20002 290739 0 783681 NC HWY 242 50 5 4 1 1 1 1767 018 123 001 49 487 55 49 5 S 1 B 0 20007 20008 291352 0 306356 US HWY 13 N 41 5 3 1 1 1 2381 848 348 309 54 864 55 55 5 1 0 20008 20007 291352 0 306356 US HWY 13 N 41 5 3 1 1 1 2381 848 578 129 54 62 55 55 5 1 0 20009 20007 291422 0 577747 NC 82 HERB FARM RD 50 5 4 1 1 1 1767 018 75 008 49 369 55 49 5 6 1 0 20007 20009 291422 0 577747 82 HERB FARM RD 50 5 4 1 1 1 1767 018 12 87 49 492 55 49 5 5 1 0 20009 20010 291503 0 212122 NC HWY 82 S 50 5 4 1 1 1 1767 018 6 996 49 5 55 49 5 S 1 AB 0 20010 20009 291503 0 212122 NC HWY 82 5 50 5 4 1 1 1 1767 018 11 811 49 5 55 49 5 5 1 0 20011 20012 291509 0 948615 NC 82 GODWIN FALCON RD 50 5 4 1 1 1 1767 018 7 83 49 499 55 49 5 5 1 0 20012 20011 291509 0 948615 NC 82 GODWIN FALCON RD 50 5 4 1 1 1 1767 018 9 733 49 5 55 49 5 S 1 B 0 20013 20014 292006 0 248736 SMITHFIELD RD 52 5 4 1 1 1 1590 316 74 23 49 306 55 49 5 5 1 0 m import cancel D project work FAMPO Model Data links 2006 AM csv e Step 8 In Figure 5 8 all o
80. MS zl MD FAM ATMSFaye 005FMS MD FAM ATMSI295 002FMS 20 MD FAM ATMSI295 004 Replacement MD FAM ATMSI295 005 Replacement 21 Faye 002 Replacement MD FAM ATMSI95B 001FMS MD FAM ATMSNC24 001FMS 22 D project work FAMPO DAS Output AM 2006 ftPerformance and MD 2006 ftPerformance and 2006 ftPerformance and OP 2006 MD FAM ATMSNC24 002FMS AM FAM ATMSFaye 001 Replacement MD FAM ATMSNC87 001FMS 23 Faye 003 Replacement 6115401 001 lt Faye 004FMS Faye 002 Replacement Faye 003 Replacement 004 4 id 9 c y IDAS Results xlsm Microsoft Excel Insert Page Layout Formulas Data Review View Developer ox a Z Record Macro Sud amp f Properties T Map Properties Use Relative References View Code i Expansion Packs eu Export Visual Macros 4 Insert Design Source gt Basic A Macro Security Run Dialog 9 Refresh Data Code Controls XML H4 vO D E F J K L M N R Initial Year 2012 Final Year 2040 Ready 2 ci Final IDAS Manual 99 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 4 shows how ITS Options are combined into groupings that define whatever form of project desired by stakeholders This will become clearer when looking at the actual Results B C spreadshe
81. Pocket Costs N Durham Parkway p a 1 RM FMS C Transit 1 0 Raleigh Signal System Other E 2 Chapel Hill Signal Syste Note Use this for 1 occupancy vehicle trip tables 77 Strategic Corridor Signals 3 HOV HOT Lane E xport 90 Costs Cancel IMAP Expansion Triangle ITS Elements e Step 3 Figure 6 3 shows the trip matrix data being imported into IDAS from a text file using the IDAS Input Output Interface In this particular case the import file contains one trip count column for all vehicles The first two columns include the origin zone and destination zone number The third column is the number of origin trips and number of destination trips for all traffic To initiate the import process the user presses the File button to the right of the field labeled Trip Matrix File in Figure 6 2 e Step 4 The user then navigates to the matrix import file and selects the fields as outlined in Figure 6 3 Different formats of market sector data in these ASCII files can be encountered For example often the origin zone number is specified in the first column the destination in the second and the number of trips in the third However destination repeats in the fourth and trips again in the fifth This way one row can contain values for one origin and many destinations When this is the case the user selects the input association as Origin destinatio
82. Weather Information Systems Smart Work Zones Freeway Management Systems Incident Management Traveler Information Ramp Metering Corridor Based Arterial Signal Coordination Freeway Management System Arterial ITS Deployments Emergency Management ITS Systems Traveler Information Incident Management Freeway Management System Arterial ITS Deployments Emergency Management ITS Systems Traveler Information Incident Management 1 5 How to Use This Document This document is formatted to guide users quickly to the relevant sections in which they are interested Sections 4 0 9 0 specifically describe the steps necessary to interface the model with IDAS and conduct an analysis Each section provides specific discussions regarding one particular interface issue Appendices provide additional detail including the proper setup and use of the interface tools The topics covered in each of the sections include Section 2 0 IDAS Overview This section provides a brief description of the IDAS model and its structure e Section 3 0 Model Overview This section provides a brief description of the Triangle Region TDM and instructions for extracting data from it for import into IDAS Final IDAS Manual 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Section 4 0 Getting Started This section provides guidance in setting up the IDAS for first time use Section 5 0 Imp
83. a Node shp Settings Link duplication If not selected in the mapping use Direction duplicate 5 Indicator Area Type DiresBon link is A gt B Travel 1 Divide Capacity by lanes Direction link is B gt A Divide lanes by 2 if control selected Set when FT 0 IDAS fields Control fields Limits Longitude 101 integer Im m m Latitude z Include only facilities with name like TAZ ID OLD integer SAVE_NODE int Include only facilities with facility type in TRANSIT_NO integer X E Omit facilities with facility type in s E Export Exit Note in the above figure that the ID field is the only exported data Our goal here is to simply create a file suitable for importing the node IDs and their coordinates into IDAS Final IDAS Manual 27 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 No other input is required for exporting nodes Specifically all the input fields other than the selection of the ID field are left empty The entry in Travel Mode is simply a default and has no effect When the user clicks Export a file called Node links txt will be created This file contains generated A and B Node numbers the selected ID field and the latitude and longitude of each node or record found in the file In this case we discard the generated A and B values in t
84. ach link for each market sector Importing this file into our master links workbook allows us to compare the aforementioned Highway agn bin directly with the IDAS results in an automated way The following two figures step us through the process of importing the results file Final IDAS Manual 65 ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 9 2 Upon Excel File Open Delimited is checked Click Next Text Import Wizard Step 1 of 3 9 The Text Wizard has determined that your data is Delimited If this is correct choose Next or choose the data type that best describes your data Original data type Choose the file type that best describes your data 9 Delimited Characters such as commas tabs separate each field Fixed width Fields are aligned in columns with spaces between each field Start import at row 1 gt File origin 437 OEM United States Preview of file D idas_2 3 DataBase netrslts 1 22223 0 04 35 00 10000 1 00 6 0 07 0 07 73 53 73 4 2 21431 0 04 35 00 10000 1 00 6 0 07 0 07 48 58 48 4 3j 2 21435 0 08 35 00 10000 1 00 6 0 14 0 14 73 59 73 3 21401 0 17 35 00 10000 1 00 6 0 30 0 30 23 71 23 3 21978 0 14 35 00 10000 1 00 6 0 24 0 24 31 62 31 4 Figure 9 3 Switch
85. ame very close in their results It can be seen that facility types 1 2 and 3 are with 762 1 percent In the figure facility types 1 and 3 are freeway and 2 and 4 are arterials For completeness we show the same as above for the 2035 Network in this case the EC network Recalling that these are facility type codes we defined and should not be confused with the codes Final IDAS Manual 70 Regional ITS Strategic Deployment Plan Update May 2013 Figure 9 7 Summary validation for 2035 EC r T links xlsx Microsoft Excel NNI 97 6 75 r i Home Insert Page Layout Formulas Data Review View Developer Wu 3 2a z E a2 General 7 5 insect sl 87 d EY Delete Paste Brdar ee E gt H Merge amp Center gt 520 Conditional Format ed _ Sor amp Find amp gt u j EH Merg E Formatting as Table Styles t Format lt 2 Filter Select Clipboard 5 Font Alignment Number Ta Styles Cells Editing 05 Y x m z ac AD AE AF AG AH AJ AK AL 1 IDASYMT Model YMT 2 273066001 277379024 155 3 Urban Freeway Rural Major 6 Rural Freeway Rural Major 22 Rural Major Arterials 40 4 Urban Major 6i Urban Freeway Urban Major tlt Urban Major Arterials 76 751 Tothersi
86. ance measures are the results of running assignment against the network without ITS Deployments Therefore again in other ITS Options the columns on the left are not the model input volumes as they are in the Control Alternative Here we have a volume on this link of 4188 91 from the TDM and 4133 65 as calculated by IDAS So IDAS is 1 32 percent low on this link e Step 4 Using this technique one can go to any link on the map and see the comparison It is a good idea to select several facility types and also to focus on links where ITS strategies are expected to be deployed Detailed Validation at the Link Level The FAMPO TDM writes out link volumes for every time period and direction for each link For example in the 2006 network TransCAD produces the following file Model_Interface_V7 Output 2006 Highway agn bin In section 5 2 1 3 we discuss at length how this file was read using the readDCB tool and subsequently imported into our master Links workbook into the Model Results worksheet From here appropriate modeled volumes are populated into the volume column for the network links import into IDAS Thus facilitating our ability to utilize the alternatives network generator results view just discussed When the IDAS assignment run completes it will have produced a file in the IDAS database directory called netrslts This is a flat file that can be opened with Excel and which contains the volumes and speeds for e
87. ate May 2013 4 0 Preparing IDAS for Analysis IDAS is a database application The database system that IDAS uses is a relatively simple client based database that uses a single computer file to manage all of its contents The simplicity of the database tool assists users in that they can create copies of the database file at any time essentially archiving stages of the system for later use branching from that stage Databases should be backed up at regular intervals during the IDAS development process For example the database should be backed up after initial setup This allows the user to skip the setup in the future and simply copy the saved database to another location and start from there This section covers the setup of that initial database up to the point of creating alternatives and networks as described in Section 5 0 41 High Level Data Required for IDAS Topics Covered in This Section e Creating the initial database and copying for later use e Setting up the high level TDM data zone count area types e Setting up the facility type and district definitions e Explanation of other setup parameters that are not usually used Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Creating an Initial Empty Database e When IDAS is first run an empty database which resides in a directory off of the installation directory is opened The first thing a user should do is create a new database an
88. ategic Deployment Plan Update May 2013 An Excel workbook is used to automate the loading of costs data into IDAS in order to take out as many manual steps as possible and avoid confusion about the proper dataset Figure 11 2 shows rows from the list of equipment that will be imported into IDAS as user defined costs Note that this spreadsheet is automated so it is not necessary to actually populate the values here if the strategy is adhered to throughout this automation will all but eliminate potential cross ups in the analysis Figure 11 2 ITS Equipment Cost Spreadsheet 9 T Costsaism Microsoft Excel Home Inset Pagelayout Formulas Data Review View Developer SS B Cut Calibri tet General ER d CIAR gm f I 47 A E la ru Paste EH Merge amp Center Conditionat Format Good Insert Delete Format Sort amp Find amp J Format Painter Doa a 88 Bd vero ormatting as Table 22 Select Clipboard g Font i Alignment g Number i Styles Cells Editing n EDSA amp 9 Project Name Project Description Service PackagyComments Questions 1 Life Cycle Replacement Fayetteville Signal System Upgrade Which arterials and FAM ATMSFaye 003 Replacement Fayetteville 13 800 000
89. cessary to accomplish this it is important to remember that once an analysis region has been setup all of it is automated For example if IDAS has to be rerun and this is rarely necessary unless impacts values are changed in deployments or if Costs information is updated and this is not only likely but frequent one simply presses Reimport All shown at the top of Figure 13 4 13 3 2 3 Managing and Reviewing the Combined Results The Results sheet in the IDAS Results workbook contains all of the summary B C columns for any of the ITS Option lists that are populated in the Control sheet AND which have their entry selected in the list of ITS Option groups on the left Please see Figure 13 5 on the next page Note that each column takes into account only those ITS Options selected in one list on the Control worksheet Final IDAS Manual 101 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 5 Initial View of the B C Results id 9 c IDAS Results xlsm Microsoft Excel 2 5 Insert Page Layout Formulas Data Review View Developer B gi Arial m mE General EU Bad Calculation iun Ar d 13 CENT Fill Paste S painter 81 U o gt E center 8 g
90. collection of any number of ITS Options described next The important thing to remember about an alternative is that it is e For a given time period The Market Sectors described later define a number of trips during a certain period of time For this alternative all market sectors used must be for that same period of time e given network It is on this window that the user imports nodes and links It is entirely possible for a given project to have multiple alternatives that have different networks For example a model that contains projected capital improvements new links new facility types and one that does not Step 2 To define this alternative it is given a name in this case one that reflects the time period that will be used the time period of the market sector data AM and the 7 Tt is important to also understand that each network must have its own importable nodes and links from a TDM Final IDAS Manual 36 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 duration of that time period One can see that the facility type of Centroid Connectors is filled in done by the system automatically and that an option already exists in the ITS Options box The Control Alternative is automatically created each time an Alternative is created The Control Alternative is the no option scenario that represents the baseline performance on the network e Step 3 Pressing File to the
91. completed This run was started by clicking on the Run Analysis text on the left side of the figure and then clicking the Run button below that The figure shows a completed run so the user can see what to expect when the analysis finishes Final IDAS Manual 57 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 8 5 A Finished Benefits Run File View Modules Window ITS Option Selection inis doch aq Available ITS Options Assignment Y Due AM FAM ATM AM FAM ATMSAM FAM ATMSAM FAM ATMS Market Sectors 5195 010 5195 011 51 SI95B 001FM SLumb 001 24 001 5 NC24 002FMS NC24 87 001F Assignment Run Parameters Replacement a 5 Traffic Signals Mode Choice AR AR AR AR Hortus FAM ATMSAMFAMATMSAM FAMATMS AM FAMATM AMFAMATM AM AM SPSI FAM ATMSAM FAM ATMSAM FAM ATMS AM FAM ATM FAM meee eee NC87 0D1FMS NCB7 002FMS 87 003 5 SUS401 001F SUS401 002 295 001 Safety Emissions MS Replacement Patrol Service Energy Safety AM Travel Time Reliability Costs Run Analysis Run Benefits Note Select Multiple ITS Options using CTL click Summary Report File Baseline duration Update Using Analysis Results baseline Loading Results network Loading Results matrix Updating Matrix Information Summing VHT Out vehicle for Assigned market sector All matri
92. could open the links file and inspect lines 3850 and 5889 to see the detail about the duplicate links Typically this situation is benign and can be ignored e Step 9 Pressing OK on the screen shown in Figure 5 9 returns the user to the Alternative window Final IDAS Manual 39 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Import Network Turn Prohibitor File Optional Not Used in This Application This file is an optional file that instructs the assignment module in IDAS where turns cannot be made between links The term optional refers to the fact that this typically has little effect on the outcome of the assignment to the network unless the TDM itself relies on the use of turn prohibitors extensively This latter situation would occur for example if the TDM did not include freeway ramps in its network and would use turn prohibitors to prevent assignment from an arterial to a freeway at their common node That situation makes turn prohibitors mandatory In the present effort turn prohibitors were not used Final IDAS Manual 40 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 6 0 Importing Market Sector Data 6 1 Introduction to Market Sector Data The use of market sector data by IDAS is described in Section 10 0 This section focuses entirely on preparing market sector data for use and importing that into IDAS To recap from Section 5 0 a market sector contains one or more
93. d These two settings are specified by clicking on Assignment Run Parameters in the window shown in the left side of Figure 8 3 Figure 8 3 Assignment Run Parameters isl IDAS ITS Deployment Analysis System sos File View Modules Reports Window Help P Benefits Module a ITS Option Selection eg inm Available ITS Options Assignment Volama Dabiy Timas AM FAM ATM AM FAM ATM AM FAM ATM AM FAM ATMSAM FAM ATMSAM FAM ATMS Market Sectors 5195 10 I95 011VSL 5195 00 007 NC24 001FMS NC24 002FMS NC24 87 001F Assignment Run Parameters Replacement i 5 Traffic Signals An ES A af KM Mode Choice Temporal Choice AM AM AM AM AM AM M FAM ATMSAM FAM ATMSAM FAM ATMS AM FAM ATM AM FAM SPSI O oT Induced Foregone Demand NC87 0DIFMS 87 002 5 87 003 5 SUS401 001F SUS401 002 295 001 Safety Emissions MS Replacement Patrol Service Energy Safety Travel Time Reliability Costs Run Analysis Assignment Run Parameters Maximum Number of Iterations 200 Percent Equilibrium Closure 0 0025 ACTIVE Project FAMPO Alternative AM ITS Option Control Alternative e Step 6 The default value of these is 0 0025 for the equilibrium closure gap and 200 as the maximum iteration count Typically an iteration count this high is never reached Final IDAS Manual 55 FAMPO Regi
94. d indicate it should be stored in another location related solely to a particular IDAS study for example EXAMPLE Step1 To do this select File gt Create Database in the main menu A file navigation dialog appears in which you can specify the name and location of the database Note that the database created is simply this file with the extension db e Step 2 Note also that IDAS remembers the name of its database so that when it starts up it will try to find that database If the file gets moved or deleted IDAS prompts the user with a file open dialog to find a database to open 4 1 1 TDM Zone and Area Type Information The information IDAS requires is specified by choosing File gt Setup from the IDAS main menu This window contains two tabs used to supply the data and a third that is sometimes used but not required On the TDMData tab the following must be provided e Step 1 Maximum ID of internal and external zones This is the ID of the last centroid node from the data that will be used This value indicates the size of the network All demand matrixes of any type discussed in Section 6 0 subsequently imported must be the same size as this number For the FAMPO analysis this value is 1 051 e Step 2 The meaning of the Area Type code in network import files IDAS has only two area types while most TDMs have more The setting provided here simply sets up IDAS to the area types into one of these
95. delete key then copy and paste the data from the main costs spreadsheet one column of data at a time Note the blank column to the right of Useful Life Your copy source should include this column Step 4 Export two costs results sheets out of IDAS Final IDAS Manual 82 ee 22 22 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Step 4a While in the IDAS cost module having selected Costs as the active ITS Option select Costs per Year on the left side This creates the Stream of costs spreadsheet Figure 11 5 Costs per Year r E IDAS ITS Deployment Analysis System File View Modules Reports Window BATTS Costs Cost Module osts Year Cost Module Inputs User Defined Costs Display costs based on construction periods Discount Rate C Display costs based on deployment opening year E Unit Cost Figures Public Costs Improvement 2010 2011 2012 2013 2014 Private Costs User Defined Cost 1 AM FAM ATMSNC24 87 001FMS CCTV Camera PTZ A F Cost Public Capital 74 000 00 0 00 0 00 0 00 0 00 Private Capital 0 00 0 00 0 00 0 00 0 00 Public O amp M 5 000 00 5 000 00 5 000 00 5 000 00 5 000 00 Private O amp M 0 00 0 00 0 00 0 00 0 00 User Defined Cost 2 AM FAM ATMSNC24 87 001FMS DMS Overhead Mount Public Capital 400 000 00 0 00 0 00 0 00 0 00 Private Capital 0 00 0 00 0 00 0 00 0 00 Public O
96. ds and imports from e Step2 The header row row 1 must be entered exactly as shown case is not important e Step3 In Excel if the entire table is selected with the mouse cells A1 F7 one performs an Insert Name Define Using ALT I N D brings up the Excel named ranges dialog e Step 4 While creating the named range use the name FacilityTypes case is not important but there should be no space in the name then dispatch the named ranges dialog and save the workbook e Step 5 Now return to IDAS press the File button Figure 4 2 navigate to the Excel workbook just created and select it The facility type table in IDAS automatically updates Note In the FAMPO work we placed the facilities type table within the main Links xlsx file used to manage all information about the network However when you want to Final IDAS Manual 20 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 specify the file used to import via the File button in Figure 4 2 it must be an xls file not xlsx or IDAS will report an error when importing it Therefore it is necessary to save temporary copy of the xlsx file in the xls format 4 1 3 TDM District Definitions While in the IDAS setup window the user will see a Districts tab that is used to define the mapping of the district code in the TDM to the descriptive name and color of each district By supplying a district code on the network links imported i
97. e V C curves are maintained outside of IDAS e How to properly associate each facility type to one of the curves provided e Importing the V C curves into IDAS 71 Curves Are Related to Facility Type Each facility type in the TDM will handle traffic volumes differently than others For example freeway facility types are able to handle higher levels of traffic before speed is significantly reduced due to volume IDAS relates the desired V C curve to the facility type by a combination of two link attributes that are present and imported for each link l Facility type The code provided by the TDM and identified to IDAS during the database setup procedure outlined in Section 4 0 Each facility type is associated to one of the curve names Freeway Arterial or Ramp Note To avoid confusion we will refer to a value of one of the three names Freeway Arterial or Ramp to Curve Type in this document 2 Area type A code provided by the TDM and which is converted to a value of 1 or 2 based on settings also outlined in Section 4 0 There are essentially two available area types in IDAS Urban or Suburban Rural The TDM may include up to 99 such area type codes However as outlined in Section 4 0 the File gt Setup configuration window is used to tell IDAS how each of the distinct codes coming from the TDM are to be interpreted in terms of these two types in IDAS Final IDAS Manual 46 E FAMPO Regional ITS
98. e nodes and waits for the user to press OK Import the Links e Step 7 When returned to the Alternative window press Import to the right of the Network Links File The system prompts the user to navigate to the links file in this case the Links csv file exported from the main links workbook Figure 5 8 Importing Links Eaa C fied length Input File Contents Please click on the first row from which you want to begin importing data Then choose the appropriate field description for each column from the drop down selectors demtes Rows of data located above the selection bar will not imported remove char from file A Node B Node ID Length Name Facility Type Use FT District rea Area Lanes Capacity Volume Speed Speed Limit FF Speed TS Ind Travel Mode AB BA DIR 20000 20001 289515 0 985775 HWY 210 5 50 5 1 1 1 1767 01868 83 48 679 55 19 81 sane ig Faciii Faciij distri mone Area T Runbed 4 Vo1unq gt Speed TineSpeed1ndiq f 20000 20001 289515 0 985775 NC HWY 210 S 50 5 4 1 1 1 1767 018 68 83 48 679 55 49 5 5 1 0 20001 20000 289515 0 985775 HWY 210 S 50 5 4 1 1 1 1767 018 208 448 46 117 55 49 5 6 1 0 20002 20003 289590 1 702857 BROADWATER BRIDGE RD 80 5 5 1 1 1 1299 862 41 121 43 025 55 44 5 1 0 20003 20002 289590 1 702857 BROADWATER BRID
99. e placement of certain parameters at a single point in the collection of results For example when a single deployment is analyzed one can obtain the results of that analysis from a single place However when many deployments are to be analyzed in different combinations and compared it is much better to place those results in a single system in which certain inputs such as the cost of travel time savings or equipment costs can be applied consistently across a full set of scenarios in one place These back end support systems are described in this document in parallel with the traditional discussion of IDAS processes with the aim of allowing the reader to prepare for their use from the beginning ES 3 Conclusions The interface between TDMs and IDAS and the tools used to manage the volumes of information produced by the system as described in this document follow the actual steps taken during the ITS analysis done using the FAMPO travel demand model Final IDAS Manual iii ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 1 0 Introduction 11 Purpose The purpose of this document is to describe all of the steps from model data import to benefits costs reporting and manipulation to efficiently analyze ITS deployments in the Fayetteville area of North Carolina using the Intelligent Transportation Systems ITS Deployment Analysis System IDAS The tools used here can help support planners in
100. e results This is not difficult in and of itself What becomes difficult is keeping the log of what was changed and for what purpose IDAS remembers all of its settings and parameters between runs of the system to extract an output However Final IDAS Manual 93 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 that output itself does not contain enough information to infer or find out what the values of these many parameters and settings were when it was produced All of these issues become an order of magnitude more complex when users want to compare arbitrary sets of deployments For each combination of deployments one wants to look at in IDAS itself the user has to select those ITS Options in the ACM and produce the results That combination is an entity as a group and cannot later be changed or used in comparison to other groups or ITS Options Said another way it became clear that it would be advantageous to have a bucket into which all ITS Options could be placed A user could then reach into that bucket and pull out any combination of ITS Options desired and look at them as a group without having to run IDAS to do it Another major issue involves the complexity of managing costs and ensuring they are matched correctly to the right ITS Option There also is a need for a configuration management system to cover the impacts of users changing important inputs to the system such as the costs
101. ecrease in volume on freeways 3 By District Defining districts to categorize links allows this spreadsheet to show the results of deployment on a corridor or any set of facilities grouped together in an interesting way by the user This is a powerful tool used to isolate the effects of the deployment s on just an area of interest IDAS calculates the Costs results for the B C spreadsheet by using the output of the Cost module which has managed all of the equipment and other costs associated with deployments while deployments were being made in IDAS 13 2 Why Is Results Management Important e Ina complex regional analysis project it is often the case that a large number of ITS Options are analyzed Usually many stakeholder groups are asked what types of ITS strategies they feel may be of importance to them and a list of potential deployments is created from which the analyst will start deploying the options e In addition to this IDAS has a complex and rich set of ITS Impacts parameters These are the values an IDAS user will provide to indicate the effectiveness of a deployment For example what is the estimated increase in capacity that might occur if signals were timed along a corridor IDAS has defaults for these but stakeholders often have an idea of their own about what these should be sometimes even a range of such values e Finally the results of IDAS are locked into the system A user has to run IDAS to look at th
102. efore the exported files names will contain these identifiers to keep them from overwriting each other 13 3 2 2 Import Into IDAS Results Figure 13 4 shows the Control sheet in the IDAS Results workbook Final IDAS Manual 98 Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 4 Importing Performance Spreadsheets Into IDAS Results 2 5 IDAS D project work FAMPO DAS Output AM 2006 ftPerformance and MD 2006 ftPerformance and PM 2006 ftPerformance and OP 2006 ftPerformance xls 24 AM FAM ATMSFaye 004FMS AM FAM ATMSFaye 005FMS 25 AM FAM ATMSI295 002FMS M M Control Instructions Results lt Report Tables Costs Stream Supporting Deployments IDAS ut 2025 AM ftPerformance and MD ftPerformance and PM ftPerformance and OP ftPerformance xls D project work FAMPO IDAS AM FAM ATMSFaye 001 Replacement ra 002 Replacement Faye 001 Replacement AM FAM ATMSFaye 001 Replacement 6 AM FAM ATMSFaye 002 Replacement HAS AM FAM ATMSFaye 003 Replacement y AM FAM ATMSFaye 004FMS D project work FAMPO IDAS Output IDAS In a Spreadsheet Output xls AM FAM ATMSFaye 005FMS FAM ATMSDunn 001 8 AM FAM ATMSI295 002FMS FAM ATMSI74 001 Replacement Faye 001 Replacement AM FAM ATMSI295 004 Replacement FAM ATMSI74 002 Replacement 9 AM FAM ATMSI295 005 Replaceme
103. egional ITS Strategic Deployment Plan Update May 2013 e Step 1 Ensure the Control Alternative is selected as active Set the Volume Delay Curves Information An extensive discussion of the construction and import of volume delay curves for IDAS was provided in Section 7 0 Figure 8 2 IDAS Volume Delay Curves Input Window IDAS ITS Deployment Analysis System Lo ees File View Modules Reports Window Help Analysis Opti ITS Option Selection Options Available ITS Options Assignment Volume Delay Curves AM AM AM AM AM AM AM AM FAM ATM AM FAM ATMSAM FAM ATMSAM FAM ATMS Market Sectors SI95 010 SIS5 011VSL SIS5B O01FM SLumb 001 NC24 001FMS NC24 002FMS NC24 87 001F Assignment Run Parameters Replacement KU 5 Traffic Signals Va Mode Choice Tompa M FAM ATMSAM FAMATMSAM FAM ATMS AM FAM SPs RENS Induced Foregone Demand 7 001 5 NC87002FMS NCB7 003FMS 515401 001 SUS401 002 295 001 Safety Emissions 5 Replacement Patrol Service Energy E Safety Travel Time Reliability Costs Run Analysis AM Volume Delay Curve Selection Reset Defaults VCCurve 0 56 3 60 4 Freeway Arterial Ramp Freeway v Urban Speed Suburban Rural 0 71 2 10 VIC Ratio Factor Speed Factor Arterial M T 1 0000 1 0000 VCCurve 0 83 5 50 0 9983 0 9999
104. eplacement 0 8 986 791 8 986 791 0 00 5 371 24 5 371 24 0 00 0 137485 0 137423 6 1363E 05 12 973734 12 973734 0 465 978 06 465 772 79 205 2675781 55 003 Replacement 7 581 12 891 354 12 883 773 0 00 10 923 24 1065997 263 27 0 194248 0 194243 5 13E 06 18 331702 18 329518 0 00218328 710 333 30 709 230 04 1103 250427 56 004 5 0 12 891 354 12 891 354 0 00 10 923 24 10 923 24 0 00 0 194248 0 194242 6 349 06 18 331702 18 331702 0 710 333 30 710 312 86 20 4375 57 Faye 005FMS 0 8 986 791 8 986 791 0 00 5 371 24 5 371 24 0 00 0 137485 0 137464 2 0498 05 12 973734 12973734 0 46597806 46591397 64 0859375 58 1295 002FMS 0 8 986 791 8 986 791 30 50 5 371 24 5 371 24 0 00 0 137485 0 137468 1 6703 05 12 973734 12973734 0 465 978 06 465 929 92 48 13183594 59 1295 004 Replacement 0 8 986 791 8 986 791 30 50 5 371 24 5 371 24 0 00 0 137485 0 137468 1 6703 05 12 973734 12973734 0 465 978 06 46592992 48 13183594 60 195 001 5 0 8 986 791 8 986 791 18 10 5 371 24 5 370 81 0 43 0 137485 0 137453 3 1088E 05 12 973734 12 973734 0 465 978 06 465 873 98 104 0778809 61 NC24 001FMS 0 8 986 791 8 986 791 29 70 5 371 24 5 371 24 0 00 0 137485 0 137460 2 464 05 12 973734 12973734 0 465 978 06 465 904 14 73 91601563 62 NC24 002FMS 0 8 986 791 8 986 791 8 50 5 371 24 5 371 24 0 00 0 137485 0 137473 1 1154E 05 12 973734 12 973734 0 46597806 465 945 17 32 88525391 63 87 001 5 0 8 986 791 8 986 791 0 00 5 371 24 5 369 48 1 7
105. ercise the costs over time driven a convenient and powerful use of the IDAS cost module through the use of user defined costs To leverage this technique effectively a few steps need to be taken throughout the analysis process Final IDAS Manual 78 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Step 1 Name the ITS Options appropriately When certain tools are used to manage the large volume of ITS benefits and costs data after IDAS benefits calculation s are done the naming convention of ITS Options is used to match up costs data with deployments For example we often have lists of equipment that are associated with agency projects which themselves constitute if not a full ITS Option a deployment within an ITS Option An ITS Option is a grouping of multiple ITS Elements In Figure 11 1 an ITS Option called FAM ATMSFaye 004FMS is highlighted in the spreadsheet Here the costs are well known at the deployment level e g 3 cameras will be deployed When the ITS Option is created it is given the name AM the entry from the Project Name column in the spreadsheet We precede the project name from the spreadsheet with AM for a very specific reason When we want to apply costs to the specific ITS Option and when there are multiple TDM model periods per day available we only want to apply those costs to one of those periods Thus when the benefits for the multiple periods are combi
106. es gt Alternatives Comparison from the IDAS main menu This module features two vertical boxes containing ITS Options on its main page The box on the right contains the ITS Options that are to be grouped together for benefits reporting The box on the left contains the rest of the options Final IDAS Manual 59 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 8 6 The Alternatives Comparison Module I IDAS ITS Deployment Analysis System dejes File View Modules Reports Window Help I Alternative Comparison Module ITS Option Comparison Cost Adjustment Select ITS Options For Comparison 1 Value of Time number of periods per year 27 In Vehicle Out of Vehicle Available ITS Options ITS Options for Comparison Travel Time Reliability ys Cost of Fuel KU KU KU KU 2E Non Fuel Vehicle Operating Costs AM AM AM AM AM Cants AMAICCTV AMAIDMS AM FAM ATM Control Accident Costs SET Altemative Fatality 2i ea Injury Property Damage Only AM FAM ATM AM FAM ATM AM FAM ATM AM FAM ATM Noise Damage Costs SDunn 001 SFaye 001 SFaye 002 SFaye 003 Other Mileage Based Costs Traffic Replacement Replacement Replacement Other Non Mileage Based Costs AM AM AM AM Risk Analysis AM FAM ATM 5 Select Ranges SFaye 004FM SFaye 005FM 51295001 1295 002 5 5 5 Communicatio yd R
107. ese can be easily placed into the data but in some cases they are not strictly necessary in TransCAD and therefore must be placed into the data by the modeler which entails an extra step That extra step was performed by the FAMPO modeler and involved creating a Node shape GIS file by exporting it out of TransCAD as described in Section 3 Final IDAS Manual 26 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 5 2 1 1 Creating the Nodes import file For this purpose we obtained the Node shape file and used the Extract Data tool described at length in the Triangle Study documentation That tool can be used to create a flat file out of any GIS shape file available so we use it to obtain the Node ID along with the latitude and longitude of each node We need no other information about nodes Since we only used the Extract data tool for two purposes in the FAMPO analysis Creating Nodes and Splitting links our coverage of it here is less detailed than within the Triangle Study documentation We refer the reader to that document for detailed information about creating the link network data Description of the Extract Data Screen Figure 5 1 shows the initial setup screen of Extract Data when used to export nodes The FAMPO model Node GIS shape file has been opened with the File button at the top Figure 5 1 The Extract Data Selection Window 5 Import Shape file Import D project work FAMPO Model Dat
108. et but this particular figure shows what will be one of the columns in that main results sheet the Faye 001 Replacement column and that this column will utilize the results of 4 ITS Options the AM MD OP and PM results of the FAM ATMSFaye 001 Replacement ITS Options The OP and PM selections are not visible To see them we would use the scrollbar highlighted for the list Any number of options can be combined for any one column in the results In the FAMPO analysis there are four time periods the AM MD PM periods and an off peak OP period This means that the total picture of any one deployment is actually the combination of the results from all four databases e Step1 To create this combination we use the Merge button in the control spreadsheet In the figure this button is circled under column G IDAS can make any combination of ITS Options within a given database but cannot create a combination across databases e Step 2 When Merge is pressed the user navigates to two files any two files that have been exported out of IDAS can be merged together this way as long as the file name and the ITS Option names within them are distinct This is the reason why when multiple databases are used it is convenient to name the ITS Options such that they can later be recognized as to which database they came from In our example we have merged the AM and MD performance sheet with each other then merged that with
109. f 4 analysis periods for each of 3 networks 2006 and 2 2035 networks Additionally the Auto and Truck trips were actually in two files a Preload matrix and a Normal matrix Ultimately this results in a total of 48 input matrix files Because we don t have any specific commercial vehicle ITS deployments planned we combine the auto and truck matrices into an Traffic matrix for convenience the more matrices in IDAS the slower the benefits module runs will be We also combine the Preload and Normal matrix and after combining arrive at a total of 12 input matrices just one for each of 4 time periods for each of 3 networks To combine trips a simple program was again written to read two matrices and output one The source for this program called combineTrips exe is provided within the area IDAS directory structure Since it is a DOS program there is no graphical user interface to run this tool However it is a simple matter to navigate a DOS prompt as explained in Section 5 2 1 3 to the location of the input matrices and type combineTrips matrix1 txt matrix2 txt gt matrixCombined txt which creates the resulting matrix This small tool simply reads the inputs from the two files which are in the form Origin Zone Destination Zone Trips and adds the Trips values from each appropriately indexed by the zone s and writes out the resulting data in the same format An example which creates
110. f alternative transportation investments benefit cost analysis Experience should include statistical and quantitative analysis modification and application of travel demand models using modeling and spatial analysis software TransCAD ArcGIS Should be able to process and manipulate large databases with tools such as Excel and Access Should have basic knowledge of statistical tools such as SAS Should be familiar with basic transportation economic concepts such as system performance measures and their conversion to monetary values Should be familiar with value of time calculations and have basic understanding of transportation project cost development ITS Strategic Deployment Plan Update Final IDAS Manual 1 2010 SSS IDAS Manual APPENDIX REQUIREMENT TEXT FOR OUTSOURCING IDAS COMPATIBLE TDM DEVELOPMENT IDAS Manual Requirement Text for Outsourcing IDAS Compatible TDM Development The following text is provided for use by agencies contracting consultants for the development of It is intended to include requirements so the adopted model will have all of the necessary files for ITS deployment analysis using IDAS For use with the Intelligent Transportation Systems ITS Deployment Analysis System IDAS software the travel demand forecasting TDF model should include the following files in the final deliverable Zone to district equivalence file optional Node coordinate file Network li
111. f the required fields for IDAS have been selected by the dropdowns and the delimited option has been checked as delimited by comma Pressing Import in the lower left will import these links into IDAS Note that IDAS uses a database system where links are indexed on the premise that no two links can share the same A B pair In other words there can be at most one link between each unique value of A B or B A Occasionally models will have such links in them in which case IDAS will ignore any it finds after the first During import a message is displayed to indicate such duplicate links exist and IDAS ignores the duplicate Final IDAS Manual 38 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 5 9 Links Import Done File Name 196 Integrity constraint violation index TLinks2 for table TLinks would not be unid3850 196 constraint violation index TLinks2 for table TLinks would not be unid3850 DAprojec 196 _ Integrity constraint violation index TLinks2 for table TLinks would not be uniqS889 _ 196 Integrity constraint violation index TLinks2 for table TLinks would not be 5889 4 m The above figure summarizes the link import process for the model It be seen that there are 2 duplicate links in the network IDAS is reporting each error twice One
112. g tool specifically designed to help planners better estimate the potential benefits and costs of proposed ITS deployments The IDAS software utilizes the same techniques a travel demand model would use to estimate transportation network performance characteristics Therefore the point of entry to IDAS involves importing the travel demand model files and parameters into the system for analysis Figure ES 1 shows how a travel demand forecasting TDF model and IDAS interact with this common data The IDAS tool works by importing data from the TDM in order to recreate the validated regional network structure and travel demand within IDAS The data exchanged between the model and IDAS includes network data regarding the characteristics of transportation facilities in the region and travel demand data including the number of trips and mode share of travel between different zone pairs in the model This baseline scenario is then analyzed in IDAS and the results should be compared with the model results for validation purposes Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure ES 1 IDAS Data Flows Impact Analysis of Traditional Infrastructure Improvements Network Characteristics Manual Data Interface Trip Tables Link Volumes and Speeds Impact Analysis of ITS Deployments Link Volume and Speeds Change in Travel Time Change in Emissions Change in Accidents
113. gional ITS Strategic Deployment Plan Update May 2013 An exception to this would be for example when commercial vehicle operations deployments are done in which case the Market Sector performance summary will contain valid information about the split of benefits across market sectors Note This performance summary sheet is the only place to see the number of trips made or the change in those counts It is not possible to calculate the effective number of trips on links network wide By Facility Type This performance summary sheet shown in Figure 12 3 is usually the most useful particularly in the absence of specific districts having been defined Here one can see the direct benefit upon each facility type Typically a specific ITS Strategy affects a single facility type such as only freeways and only arterials To the extent that ITS Strategies affecting multiple types of facilities are not combined into one ITS Option those performance benefits will stand out on this performance summary sheet By District This performance summary sheet is ideal for inspecting any particular area of interest As mentioned in Section 4 0 districts can be defined for the links in the network that can separate them into any grouping of links that may be of interest in the final analysis This is that final analysis where the affect on these groupings can be seen In the FAMPO analysis however there was no interest expressed in splitting out the
114. he actual B C ratio and the net benefit of each ITS Option The B C ratio is the benefit from the deployment divided by the cost Net Benefit is the dollar amount of the benefit minus the cost Note The low B C ratio in the figure should not be of concern Remember that this particular calculation is being performed against the default IDAS equipment specifications that were populated when the deployment was being made In the FAMPO analysis we are not using that equipment so the Costs values and therefore anything derived from it is not relevant from the above figure we should focus solely on the benefits 12 2 4 The Performance Summary Spreadsheets IDAS displays the calculated change s on the network in three related but subtly different ways These are the Performance Summary spreadsheets which show the performance difference by Market Sector Facility Type and District Note The values in these spreadsheets are for a single model run In other words they are not annualized but represent the demand on the network specified by the time period inherent with the number of trips present in the market sector matrices The difference between before and after ITS Deployment performance measures can be seen in Figure 12 3 10The IDAS cost module does not have to be run the necessary calculations are automated at the point in time that the B C spreadsheet is produced Final IDAS Manual 89 ee 22 222 FAMPO Reg
115. he file and use only the ID field and the coordinates lat lon At this point we create our master Links Excel workbook and import the node file created into its own worksheet in which we delete the generated A and B values When it comes time to import the nodes into IDAS Section 5 3 we save this sheet to a Nodes csv file 5 2 1 2 Obtaining the required link data Even though we cannot use the data generated with the Extract Data tool for the model we still need to use the tool in order to split the FAMPO links which are both 1 and 2 direction links into all 1 way links as required by IDAS Final IDAS Manual 28 ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 5 2 Extracting links for direction information Import Shape file 8838 Import D project work FAMPO Model Data Highway_Network_06_18 File Settings Link duplication If not selected in the mapping use Direction 0 duplicate TS Indicator 5 Area Type Travel Mode 1 Divide Capacity by lanes District Convert time min to mph Set when FT 0 Ditection 1 inkisA 8 Ditection 1 Divide lanes by 2 if no control selected IDAS fields Control fields Limits is zl 2 Longitude Ha ID integer LENGTH float Distance sd lene DIR integer v Direction m 4 Include only facilities with name like SRNUMBER character g
116. he first one being ATMSFaye 004FMS e Step 2 To create an ITS Option any series of specific ITS deployments desired in one grouping select File gt New gt ITS Option from the main menu When the map loads the first step is to give the option a descriptive name in the Name field at the bottom of the map e Step 3 Having provided this name we can now deploy on the network any ITS Strategy by highlighting and selecting the strategy from the ITS Elements tab of the workspace view Figure 10 2 shows a new ITS Option under construction which has been given the name Incident Management and upon which a Combination Detection and Response deployment is about to be created The network is zoomed into an area of interest in this case I 95 and Business I 95 10 2 Deploying ITS Strategies Into ITS Options Figure 10 2 Preparing a New ITS Option for ITS Deployments File View Modules Reports Window Help Option Incident Management Arterial Traffic Management Systems Freeway Traffic Management Systems Advanced Public Transit Systems Incident Management Systems Pdl Incident Detection Veritication Incident Response Management 3 Combination Detection amp Response Electronic Payment Collection Systems RR Grade Crossings Emergency Management Services Regional Multimodal Traveler Information Syste Commercial Vehicle Operations Advanced Vehicle Control and Safety Systems Su
117. hoose Modules gt Cost module from the main menu Select the Costs ITS Option Click on User Defined Costs on the left side This will show the table of existing user defined costs in IDAS Anywhere on this table double right click with the mouse This will activate the internal spreadsheet tool that allows you to manipulate this table as a spreadsheet Figure 11 4 Table of Existing User Defined Costs 1224 Formula Workbook Designer File Edit View Insert Format Tools Du E SH x Al Al AM FAM ATMSNC24 87 001FMS CCTV Camera PTZ Year of Mid Point of Public Private Public Private Opening Construction Capital Capital O amp M O amp M AM FAM ATMSNC24 87 001FMS CCTV Camera PTZ 2010 2010 74 000 00 0 00 5 000 00 AM FAM ATMSNC24 87 001FMS DMS Overhead Mount 1 2010 2010 400 000 00 0 00 6 000 00 AM FAM ATMSDunn 001 Traffic Signals Lump Sum Provided 2010 2010 1 350 000 00 0 00 135 000 00 AM FAM ATMSFaye 001 Replacement CCTV Camera PTZ 2010 2010 203 500 00 0 00 13 750 00 AM FAM ATMSFaye 002 Replacement CCTV Camera PTZ 2010 2010 203 500 00 0 00 13 750 00 AM FAM ATMSFaye 003 Replacement Lump Sum Provided 2010 2010 13 800 000 00 0 00 1 380 000 00 AM FAM ATMSFaye 004FMS CCTV Camera PTZ 2010 2010 55 500 00 0 00 3 750 00 AM FAM ATMSFaye 005FMS CCTV Camera PTZ 2010 2010 74 000 00 0 00 5 000 00 AM FAM ATMSI295 001 Communications Fiber Optic Cable 2010 2010 1 408 000 00 0 00 36 000
118. ice Induced Foregone Demand Emissions Energy Volume Delay Curve Selection Reset Defaults VCCurve 0 56 3 60 4 Freeway Arterial Ramp Freeway v Urban Speed Suburban Rural 0 71 2 10 VIC Ratio Factor Speed Factor erial 1 0000 1 0000 VCCurve 0 83 5 50 5 0 9983 0 9999 0 9927 0 9989 0 9559 0 9820 VCCurve 0 83 2 70 n occ7 nonce Arterial peed Feotor vs VIC rato for type freeway Done VCCurve 1 00 2 10 Ramp Z ACTIVE Centroid Connector 7 T Project FAMPO Ramp Si Suburban rural urban Freeway Alternative Import default V C curve data fie ITS Option AM FAM ATMSFaye 004FM Figure 7 3 shows the mechanism to import the V C curves into IDAS The button labeled File in the lower right of the window prompts the user for the name and location of the Excel spreadsheet that contains the previously described V C curves named range Note The values in the dropdown boxes under each Facility Name middle center of the figure do not need to be changed These are set when the facility types table was imported using File gt Setup and are only here if the user wishes to override the curve selection for this particular ITS Option When you import the V C curves IDAS will ask you if you want to reset the V C curves for ALL ITS options defined Generally you would respond Yes This way you only need to import these curve
119. information in any particular way Final IDAS Manual 91 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 13 0 Managing IDAS Results Topics Covered in This Section e Defining the IDAS results e Why results management is important e The IDAS results workbook e Importing costs e Importing facility type performance spreadsheets e Create the performance spreadsheet in IDAS e Import these into IDAS results e Operating the IDAS results workbook Monetary and valuation parameters e The stream of costs e The report table and physical performance measures 13 1 What Are the IDAS Results The primary outputs of IDAS are found in the Benefit Costs spreadsheet created by using the Alternatives Comparison Module ACM which is discussed in Section 12 0 The information in this spreadsheet is created when the user selects the option to display it and it uses a variety of economic assumptions such as value of time and other assumptions that are set in various places within the ACM IDAS calculates the Benefits values in the B C spreadsheet directly from the network performance changes that have occurred due to the deployment of ITS These performance results also can be viewed by the user in one of three spreadsheets called the Performance Spreadsheets These categorize the performance of the network before implementation Control Alternative and after deployment ITS Option measures of several important factors regard
120. ing the benefits module is called the baseline assignment All ITS Options have this baseline run associated with them However the automatically created Control Alternative is the one ITS Option that does not have the second run improvement performed We therefore run the benefits module first with the Control Alternative before making any other ITS Options so that we can be sure that the baseline output of this run matches reasonably well with the TDMs assignment runs Any corrections necessary to the links market sectors or V C curves need to be made now rather than after having deployed an ITS Option Validation is the comparison to the results of the TDM It is not intended to relate in any way to the same term often used by the TDM community It is in essence validating to the TDM and not validation of the TDM Note The assignment routine used in IDAS was developed by the same organization that developed the assignment algorithms for the TRANPLAN travel demand model IDAS Final IDAS Manual 52 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 provides a number of default parameters that are used in conducting the analysis However the likelihood of better replicating the results from a model is increased if the user is able to replace the default parameters within IDAS with the parameters directly from the TDM This section describes those critical parameters 8 2 Set Parameters in the IDAS Benef
121. ing the traveling experience of the public These measures include VMT VHT speed delay due to congestion termed Travel Time Reliability or TTR and safety emissions and fuel results As mentioned previously it is the change in these measures that drive the benefits realized by deploying ITS The three spreadsheets are Final IDAS Manual 92 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 1 By Market Sector This spreadsheet details network performance for each segment of the traveling public that is represented by a market sector It is used primarily to view how each market sector might be affected by ITS deployments Since most market sectors are allowed to comingle on every type of facility the performance of the network should not be gleaned from this spreadsheet rather one of the other two should be used The exception to this is that the market sector performance spreadsheet is the only place to view the number of trips that were made by each market sector Number of trips cannot be calculated for the other two sheets 2 By Facility Type This sheet details the performance characteristics for each facility type It is most useful in consideration of the network as a whole since here you can see how traffic shifts across facility types as well as how a particular facility type is affected For example it is possible to see a deployment on arterials increase volume on the arterials but you also may see a d
122. into the Link Capacities sheet the 2035 capacities into Link Capacities EC 2035 and Link Capacities LRTP 2035 Final IDAS Manual 31 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Once this is done for each of the 3 base network sheets the Capacity column is populated with an Excel VLookup function that finds the appropriate capacity in the capacity sheet using the ID field from the model as a key With the additional constraint that it takes the capacity from either the AB_LOS_E_AM or the BA LOS E AM column depending on the link direction Recalling that the Extract Data tool creates both an AB and a BA record from 2 way TransCAD links Note that capacities are divided by the number of lanes because IDAS uses lane capacity for input Using the same technique we also import volumes into the master links workbook These files are AModel Interface V XOutputX 20065 Highway agn bin for the 2006 model year and as above for the future years In this case we import these into 3 sheets Model Results for 2006 Model Results EC 2035 and Model Results LRTP 2035 Though IDAS does not care what values for volume are imported the column for volume is a placeholder so IDAS knows where to export volume it is convenient to import the model s volume in order to compare the IDAS assignment results with the models results within IDAS Specifically after the Control
123. ional ITS Strategic Deployment Plan Update May 2013 Figure 12 3 Difference Between Baseline and Improvement Measures IDAS ITS Deployment Analysis System Ee File View Modules Reports Window Help T Alternative Comparison Module beka In Vehicle Performance Summary Out oF Vehicle Project FAMPO Alternative AM ITS Option AM FAM ATMSFaye 003 Replacement Travel Time Reliability Cost of Fuel By Facility Type VCCurve 0 56 3 60 VCCurve 0 71 2 10 VCCurve 0 83 2 70 VCCurve 0 83 5 50 VCCurve 1 00 2 10 Total Non Fuel Vehicle Operating Cost Emission Costs Vehicle Miles of Travel Control Alternative 28 734 549 670 155 170 345 422 344 589 1 423 585 Accent Costs ITS Option 28 590 550 574 155 172 345 185 344 426 1 423 946 Fatality Difference 144 0 5 904 0 2 210 08 237 0 18 162 0 08 362 0 08 Injury Vehicle Hours of Travel Property Damage Only Control Alternative 653 17 707 3 201 5 797 10 930 38 288 Noise Damage Costs ITS Option 643 17 568 3 205 5 792 10 904 38 118 Other Mileage Based Costs Difference 4 0 6 139 0 8 410 14 5 0 18 25 0 2 169 0 4 Other Non Mileage Based Costs Average Speed Risk Analysis 3 Control Alternative 44 0 31 0 48 5 53 6 31 5 37 2 Select Ranges ITS Option 44 0 31 3 48 4 55 6 31 6 37 2 Run Analysis Difference 96 000 14 0 1 08 0 0 18 0 0 0 010 28 0 0 0 View Renis Person Hours of Travel View Outputs Control Alternative 653 17
124. ire directory structure for the inputs and outputs from the model With these files we were then able to simply read the data necessary for IDAS without requiring the modeler to specifically export link information from the model In prior work within North Carolina we had in this section documented the necessary steps a modeler would need to perform to prepare data for IDAS input In this case we only needed the modeler to export nodes and trip tables after receiving the model data This has the potential to provide easier access for IDAS to other models within North Carolina if they also contain the data that TransCAD produced with the FAMPO model In any case on a per model basis a viable future approach would be to peruse the entire model data structure for the required files and if available use them if not refer the modeler to the Triangle study documentation provided in March 2010 Therefore with the FAMPO model we retain herein the information about exporting Nodes and Trip tables from the Triangle study documentation and refer the reader to Section 5 for specific information about how the model data was accessed to read the data required for IDAS Topics Covered in This Section e Network characteristics e Exporting the node definitions e Demand characteristics e Vehicle trips e Volume delay curves e Provide the information to the IDAS analyst Final IDAS Manual ee 22 222 FAMPO Regional ITS Strategic Deploy
125. itecture and documentation of that process These initial activities provide input into the development and implementation of an IDAS model for FAMPO The model will be used to evaluate proposed ITS deployments 1 References to the IDAS software in this document refer to IDAS Version 2 3 Final IDAS Manual 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 including both updates and replacement of existing equipment and proposed new deployments A critical part of this effort is to provide documentation and training so that FAMPO and NCDOT staff can maintain the IDAS model on a continuing basis and update it when required It also is anticipated that this process will be replicated throughout the state with the goal of mainstreaming ITS benefit cost analysis into the various MPO and NCDOT planning processes These project objectives generated the need for a tailored manual specifically oriented toward the Fayetteville area IDAS model 13 What Is IDAS Analysis Intended to Do The ITS Deployment Analysis System software was developed by the Federal Highway Administration FHWA as a sketch planning tool specifically designed to help planners better estimate the potential benefits and costs of proposed ITS deployments The IDAS software operates as a post processor to travel demand models Sketch planning tools are intended to provide planning level analysis of various deployment alternatives w
126. ith a minimum effort using existing data sources Instead of being built from the ground up like a TDM IDAS is intended to mimic and build upon an existing model Reliance on data from a validated TDM makes IDAS easier to use since the customization and calibration efforts are significantly less In fact IDAS shares many of the same analysis techniques and processes as TDMs but has expanded capabilities that allow analysis of ITS deployments These capabilities are unavailable in TDMs because they lack the algorithms to apply the necessary characteristic changes to a network However it is important to note that IDAS is not as effective as most TDMs in some areas such as performance analysis when building new facilities or adding lanes 14 What Analysis Can Be Performed Using IDAS The IDAS software as a post processor of travel demand models represents a useful tool for planners wanting to consider various ITS deployment scenarios By carefully structuring the development of alternative scenarios and screening approaches IDAS can be used to answer the following deployment questions e What types of impacts benefits result from different types of ITS components e What types of ITS components provide the greatest benefits for the region e On which facility types does the deployment of ITS components provide the greatest level of benefits Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 1
127. its Module Selecting the Appropriate ITS Option There are many parameters in this model that can be set However only a few affect the benefits run at the baseline level Therefore only those are discussed here The first selection to make is to choose the Control Alternative as the selected active ITS Option Figure 8 1 ITS Option Selection A IDAS ITS Deployment Analysis System kojoj File View Modules Reports Window Help 119 Benefits Module a ae ITS Option Selection T SS paons Available ITS Options Reset Defaults Assignment AM FAM ATM 5 5 5 Market Sectors 5195 10 SIS5 DTTVSL SI95B O01FM 007 24 001 5 NC24 002FMS 24 87 001 Assignment Run Parameters Replacement Kt 5 Traffic Signals Mode Choice zm zm Temporal Choice AM 5 AM FAM ATMS 5 AM FAM ATM AM FAM ATM AM FAM SPSI Control Induced F oregone Demand NC87 001FMS 87 002 5 NC87 003FMS SUS401 001F SUS401 002 295 001 Safety Emissions MS Replacement Patrol Service Energy AB Safety AM Travel Time Reliability Run Analysis ACTIVE Project FAMPO Alternative ITS Option Control Alternative Final IDAS Manual 53 ee FAMPO R
128. ized in Figure 2 1 Final IDAS Manual pu _ _ FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 2 1 IDAS Analysis Process 1 Analysis is conducted in TDF Model Y 2 User formats output from TDF Model for input into IDAS Y 3 IDAS reads and interprets input data Y 4 User creates alternatives by deploying ITS on the network Y 5 IDAS modifies network travel characteristics to represent ITS impacts Y 6 IDAS reassigns traffic and estimates mode shift caused by modifications to network travel characteristics Y 7 IDAS uses new link volumes and speeds and mode shares to calculate changes in travel time accidents emissions and other impacts Y 8 IDAS assigns dollar values to the impacts and estimates the costs of the ITS deployments Y 9 User is able to view B C comparison performance measures and compare alternatives Final IDAS Manual ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 The manual interface presented in this document focuses on procedures necessary to complete Steps 2 and 3 in the figure above However it is critical that the user understand and consider the remaining steps in the analysis process when interfacing a model with IDAS The needs of the analysis conducted in Steps
129. l IDAS Manual 85 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 12 1 Creating a Group of ITS Options Ifl IDAS TTS Deployment Analysis System Jm sa File View Modules Reports Window Ti Alternative Comparison Module Eee 8838 ITS Option Comparison Cost Adjustment Select ITS Options For Comparison number of periods per year 247 Out of Vehicle Available ITS Options ITS Options for Comparison Cote a Se 2 2 wm oc 25 Non Fuel Vehicle Operating Cost zm AM Emission Costs AM AICCTV AM AIIDMS AM FAM ATM mE AM FAM ATM as Accident Cost SBR4 002 SBRAR 001 i aa SFaye 003 Costs i 1 Replacement Fatality Injury Property Damage Only AM FAM ATM SDunn 001 SFaye 001 SFaye 002 Noise Damage Costs Traffic Signals Replacement Replacement E Other Mileage Based Costs Other Non Mileage Based Costs gt Risk Analysis AM FAM ATM 5 Select Ranges SFaye O04FM SFaye 005FM 51295001 1295 002 5 5 5 ti Run Analysis View Results m m 8 Outputs AM FAM ATM AM FAM ATM AM FAM ATMS Benefit Cost Summary 51295 003 51295 004 51295 005 1295 006 5 Performance Summary Communicatio Replacement
130. loyment Plan Update Managing Facility Type Data in Excel May 2013 Figure 4 2 shows a File button below the table of facility types This button is used to import all of the data at once from an Excel spreadsheet which allows the user to avoid manually typing in these settings For any facility type table of appreciable size this technique is highly recommended Figure 4 3 Facility Types in an Excel Spreadsheet P3 0 7 Insert Page Layout Formulas Data Review View Developer Calibri ju S General Y Ej Conditional Formatting 3 Insert 2 d da B z U A ad H Formatas Table 3 Delete g Z Paste ET m 2 Find amp VS 2 Cell Styles Format 27 Filter Select Clipboard Font Alignment Number Styles Cells Editing A2 Mt amp 1 a B c D E F 1 FacilityID Description vccurve red green blue ilvccurve 0 56 3 60 freeway 255 0 0 3 2 VCCurve 0 71 2 10 arterial 0 255 0 3 VCCurve 0 83 5 50 freeway 0 0 255 5 4 VCCurve 0 83 2 70 arterial 255 255 0 6 5 VCCurve 1 00 2 10 ramp 0 255 255 7 6 Centroid Connector ramp 255 255 255 8 9 Model Results EC 2035 Step 1 To use this create an Excel spreadsheet and enter the table of facility types there The table shown in Figure 4 3 is then used to create an Excel Named Range that IDAS rea
131. m Supporting Deployments IDAS HAS Faye 001 Replacement Faye 002 Replacement 003 Replacement 004 5 Faye Ready Calculate Average 511144 6554 Count 508 Sum 220303346 5 Final IDAS Manual 108 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 8 Performance Impacts DE IDAS Results xlsm Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer a E Record Macro 59 Properties T Properties Import Use Relative References View Code Expansion Packs Export Visual Macros Insert Design Source Basic Macro Security RunDialog 9j Refresh Data Code Controls XML P87 He fe INDIRECT amp INDIRECT set amp ROW ROW A 50 amp Name amp ST 52 D E F G H J K L M N vr 48 49 Baseline Improved Base Performance Change in Baseline Improvement ATIS Savings Delay Delay Baseline Improved Fatality Baseline Improved Injury Baseline Improved Fuel HC R 50 Impacts VMT VMT VMT hours hours hours Reduction Fatalities Fatalities Reduction Injuries Injuries Reduction Fuel Fuel Reduction tons 53 Faye 001 Replacement 0 8 986 791 8 986 791 0 00 5 371 24 5 351 50 19 74 0 137485 0 137392 9 2683E 05 12 973734 12 973734 0 465 978 06 46565245 325 6094971 54 Faye 002 R
132. master links workbook then using Excel formulas match up these fields with each row in the network links worksheets The tool developed here is called readDCB and is a small C program built to extract data from the TransCAD binary files with guidance from an associated contents file with the extension DCB The source file for this tool is provided within the FAMPO analysis directory structure Note that the tool was developed for the purpose of importing the FAMPO model data into IDAS It is likely however to work with any of the large numbers of DCB and BIN file pairs TransCAD is creating Since this tool is a simple DOS application it has no graphical interface Running it is a matter of navigating a DOS prompt to the location of the input files and typing the name of the program followed by a root file name For example one of our useful TransCAD files is called Highway Network 06 18 2009 For this there 2 important files a dcb and a bin file There are other files which are of no concern to us In the model data structure these files are in A Model Interface _V7 Input Therefore to produce a Highway Network 06 18 2009 csv file we perform the following Final IDAS Manual 30 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Open a DOS prompt In the Windows Start Menu choose run and type cmd into the Open entry field and press enter e Navigate to the location
133. ment Plan Update May 2013 3 1 Network Characteristics 3 11 Exporting TransCAD Nodes The node file is an additional layer that is attached to the master geographic file When you open the master geographic file the node layer is there but may not be visible With the master geographic file open in TransCAD from the TransCAD main menu choose Map gt Layers and click Show Layer for the Node layer then click Close A network with nodes is seen in Figure 3 2 This particular network is from the Triangle region in North Carolina Figure 3 2 Example TDM Showing Nodes TRM2005_afterMAB 10 x Open the node dataview by clicking the dataview button then from the TransCAD main menu choose File gt Save As change Files of Type to Excel Worksheet xls and save to your desired location Final IDAS Manual 12 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 3 2 Trip Tables Travel Demand Zone to zone trip matrices also must be available as input to IDAS The trip table file is used as direct input to the equilibrium highway assignment process often an intermediate file is best used unless some form of transit ITS analysis is required In the FAMPO model the input trip table file for the equilibrium highway assignment is divided into four time of day periods with 2 matrices for each period auto and truck The trip tables must be converted to an ASCII format using TransC
134. ment Plan Update May 2013 Figure 5 5 Creating a New Project File View Modules Reports Window Help 2 Vorkspace D PROJECT WORKY Project Name Year of Data 20 Zone to District Equivalence File Optional Cancel e Step 3 In Figure 5 5 the user has entered a name which can be any name and the year of data In our case the model data provided was from 2006 Note that the system has created a new tab on the work prompter and has given that tab the same name as the project Thus a project is the white container in the interface that is selected by that tab into which any number of Alternatives can be created 5 3 2 Creating an Alternative Step 1 Dispatching the project definition window then selecting File gt New gt Alternative from the main window creates an alternative as shown in Figure 5 6 Final IDAS Manual 35 Genie nee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 5 6 Creating an Alternative View Modules Reports Window Help Workspace D i Alternative Name Description 3 Time Period PM Hour Off Peak Peak Period Daily ITS Options Control Alternative Facility Type of Centroid Connector Node Coordinates File File Network Links File Import Export Network Turn Prohibitor File File Cancel ITS Elements FAMPO An Alternative is a
135. n trips destination trips and so on for all of the fields present Final IDAS Manual 44 ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 6 3 Sample IDAS Import of Trip Matrix from Text File 1569 fixed length Input File Contents Please click on the first row from which you want to begin importing data Then choose the appropriate field description for each column from the drop down selectors delimited Rows of data located above the selection bar will not be imported remove char from file 1 0 Origin 360000 840000 250000 480000 580000 580000 290000 120000 180000 0 050000 0 230000 0 050000 0 070000 14 0 040000 0 0 0 0 m oN no wN H 350000 090000 080000 1 1 1 1 1 1 1 1 1 9 1 1 1 1 1 1 1 1 1 160000 4 n D project work FAMPO Model Data Trip Tables 2006_AM_TotalTrips trp File EXPLANATION Note the button in the lower left of this import window says OK rather than Import as it does when importing links and nodes The system does not actually import the data until the user goes back to the Market Sector Window Figure 6 2 and presses Import at the top right of that window The reason for this is that when multiple types of matrixes are being imported for a market sector for example trips and in and out
136. n 11 0 was created it was populated with a menu of equipment with each specific equipment type given a cost The year of those costs is not a consideration for that spreadsheet Instead costs are inflated or deflated to the specific year of analysis set in the IDAS Results workbook and by the globally specified inflation rate also the IDAS Results workbook Step 3 Should cost entries be matched exactly to the The answer to this is Yes in the FAMPO analysis The ITS Options were given names while being created in IDAS that explicitly define the relationship of each particular ITS Option to its equipment This option could be used to associate equipment across multiple ITS Options that share a similar name For example all deployments with a name that starts with ramp metering could be associated with a common set of equipment However we provide ALL the costs for Each deployment in this analysis so this option should be set to Yes so that costs don t intermingle between ITS Options that may have similar names e Step4 Any time costs change for example additional equipment is deemed important additional deployments are made or the cost of certain equipment is adjusted the user should perform the steps in Section 11 0 This involves importing the one global equipment costs spreadsheet into IDAS and running IDAS to export the two costs sheets Once those two sheets are available reimport them here e S
137. n Section 11 0 to be sure the costs got applied for only one time period This means that when time periods are combined all time periods of any ITS Option that is selected should be selected Final IDAS Manual 110 IDAS Manual Appendices The following Appendices were created as part of the Triangle Region ITS Strategic Deployment Plan Update conducted in 2010 SSS IDAS Manual APPENDIX A QUICK REFERENCE GUIDE IDAS Manual Purpose of Checklist The purpose of this document is to serve as a quick reference guide to IDAS for more experienced users Additionally it provides a non user with exposure to the steps and procedures required to use IDAS in the analysis of ITS projects Since IDAS is a complex software package with a wide range of capabilities new users are encouraged to use the full procedures manual for guidance in applying IDAS Step by Step Procedures Overview of IDAS The ITS Deployment Analysis System IDAS software was developed by the Federal Highway Administration FHWA as a sketch planning tool specifically designed to help planners better estimate the potential benefits and costs of proposed ITS deployments The IDAS tool works by importing data from the Travel Demand Forecasting TDF model in order to recreate the validated regional network structure and travel demand within IDAS The data exchanged between the model and IDAS includes network data regarding the characteristics of transpor
138. n assumed percentage level of capacity increase on affected freeway links Based on the type of deployment being done the level of effectiveness is essentially embodied in these link s impact values The spreadsheet imported here can be used to replace the default values for these impact parameters so that when subsequent deployments after Final IDAS Manual 24 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 importing are done the user does not have to actually go in and change the impact parameters for those deployments In essence the ITS Entry Defaults spreadsheet can be used to set the local policy in regards to the effectiveness of ITS In this regard it is likely the most useful of the spreadsheets that can be imported into IDAS A state agency for example could decree that all ramp metering analysis utilize an assumed effectiveness level and comparisons by the state would then be comparing apples to apples in looking at IDAS results from multiple agencies ITS Equipment Sharing This final tab on the File gt Setup configuration window details aspects of how the equipment population mechanism works while ITS deployments are being made The choices selected on this screen state how the different combinations of equipment are deployed Population logic should complete its task s For example when certain ITS Strategies are deployed in one ITS Option the
139. n avoidance impacts Incident delay figures are calculated for freeway links only Person hours of travel data does not include hours accumulated in Transit market sectors In Figure 12 3 each measure has three rows of information the Control Alternative the ITS Option and the calculated and percentage difference The benefit is the difference value For example the reduction in travel time benefit reported in the Benefits Costs spreadsheet is the total change in Vehicle Hours of Travel across the entire network total column not shown multiplied by the user supplied Value of In Vehicle Time and finally that value multiplied by the number of model periods per year The different types of usage for these is explained in the following By Market Sector This spreadsheet shows the changes in performance value based on the travelers using it The FAMPO analysis has only one market sector therefore if we were to view the performance spreadsheet by Market Sector there would be only one column of data If we had more than one MS there would be a column for each In the vast majority of ITS Strategies one should see no difference in impact across market sectors because few strategies are targeted at market sectors Specifically if you improve capacity on a freeway link and all vehicles can use that link all market sectors will experience the benefit Final IDAS Manual 90 22 2 2 22222 2 FAMPO Re
140. n in the sample figure are typical of those used by Cambridge Systematics and represent a relatively conservative but realistic estimate of impact values e Step 4 Note that more ITS Elements can be applied to this ITS Option For example if the user wants to analyze the correlated impacts of a signal system along with a nearby ramp metering deployment which might congest an arterial they would deploy both ITS Elements in the same ITS Option When this happens the impacts on the entire network can be seen as they physically would occur on the network For example a higher throughput arterial signal timing deployment might push more traffic toward a metered ramp and cause more congestion on the arterial at that ramp Once your ITS Option has been defined the Benefits Module can be run to compute the Benefits of the strategy From the main IDAS Menu choose Modules Benefits highlight the Incident Management ITS Option select Run Analysis in the menu on the left and click Run To see the benefits spreadsheet after the Benefits module is finished choose Modules gt Alternative Comparison from the main menu In the list of ITS Options on the left highlight the Incident Management ITS Option click the Right arrow to move that option to the right and then choose Benefit Cost Summary the list of choices on the left A Note Concerning Equipment Costs While a user is creating deployments in an ITS Option the IDAS system is behind
141. n to IDAS format 42 Export link and node data to csv files 43 Create project in IDAS 44 Create alternative 45 Import link and node files 47 Import market sector data Define maximum zone number 51 Define provide parameters and import market sector data 52 Process and convert transit matrices 55 Incorporate volume delay curves Relate V C curves to facility type 57 Manage and calculate V C curves in Excel 59 Associate V C curves to links 61 Import V C curves into IDAS 62 ITS Strategic Deployment Plan Update Final IDAS Manual A 3 March 2010 ee IDAS Manual Run the baseline analysis Set parameters in IDAS benefits module 65 Set volume delay curves information 66 Specify the assignment closure criteria 67 Specify the analysis options 68 Run the control alternative assignment 70 Open and save the alternatives comparison module performance by facility type spreadsheet 71 Validate IDAS results Review and identify criteria for validation 75 Conduct initial validation using the alternatives network generator 76 Summarize validation results at the facility type level and review 78 Create IDAS Options Create ITS Options 81 Deploy ITS Strategies 83 Set parameters for impacted links 85 Create transit deployment if being evaluated 86 Manage equipment and deployment costs Name ITS Options 98 Organize cost data in correct fo
142. ned later we don t have to divide the costs among them Figure 11 1 Costs for an ITS Option On HI Project List xlsx Microsoft Excel m tid Home Insert Page Layout Formulas Data Review View Developer P Calibri gt General E Conditional Formatting Insert d Ga E Format as Table 3 Delete g Z Paste y B 7 UH oe A SH Cell Styles iron Clipboard Font fa Alignment t Number Styles Cells Editing R8C1 amp 42 oca Desai 42 FAM ATMSFaye 004FMS Deploy ITS on Santa Fe and Yadkin 3 Fayetteville CCTVs Fayetteville 8 42 FAM ATMSFaye 005FMS Deploy ITS on US 401 Ramsey Street 4 Fayetteville CCTVs Fayetteville Communications Infrastructure Add optical fiber infrastructure 16 miles 1 295 NC 24 N87 Bragg Boulevard to 1 95 51295 001 10 Communications 1 295 from North 1 95 to NC 24 N87 Bragg 2 000 000 7 FAM ATMSI295 002FMS Add ITS Devices Add 8 CCTV cameras and 8 DMS M 4 gt tbiProjectInformation FAM ATMSNC24 87 001FMS 5 001 Replacement Ready 21 42 Count 8 e Step 2 Manage the costs data consistently and within the framework offered by the ITS Option naming convention Final IDAS Manual 79 ee 22 222 FAMPO Regional ITS Str
143. nk characteristics file Turn prohibitor file optional Trip origin destination O D trip table data files Trip in vehicle travel time O D tables optional for nontransit market sectors Trip out of vehicle travel time O D tables optional for nontransit market sectors Volume delay curves ITS Strategic Deployment Plan Update Final IDAS Manual C 1 March 2010
144. nks On most ITS Deployment windows a Select Links button appears which indicates to the user that they should isolate those links that are expected to be affected by the ITS deployment e In some cases there may be multiple types of links for example Traffic Signaling deployments have progression and cross flow links These indicate the corridor which will be positively affected and those that may experience additional stops cross flow Final IDAS Manual 75 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 e Other ITS Strategies might involve selecting centroids in the network Typical of these are any transit deployments where the impact due to deployment is on trips made by transit riders and not on links on the network e links are involved in the deployment as they are selected by the user they appear highlighted in this case in black and their node numbers appear in the list at the bottom of the map as shown in Figure 10 3 10 4 Setting the Impacts Parameters for the Affected Links Step 1 To set the impacts parameters for these links or for centroids depending on the ITS Strategy chosen the user presses Edit Impacts on the bottom left and will then be able to input the impact parameters specific to this deployment Figure 10 4 Specifying Link Level Impact Parameters File View Modules Zoom Window Help es Incident a Combination Detection Resp
145. nt FAM ATMSI74 003 Replacement D project work FAMPO IDAS Output AM 2006 ftPerformance and MD 20 AM FAM ATMSI95B 001FMS FAM ATMSI74 004 Replacement AM FAM ATMSFaye 001 Replacement 10 AM FAM ATMSNC24 001FMS FAM ATMSI95 005 Replacement Coal AM FAM ATMSFaye 002 Replacement AM FAM ATMSNC24 002FMS FAM ATMSI95 006 Replacement AM FAM ATMSFaye 003 Replacement 11 5 87 001 5 FAM ATMSI95 007 Replacement AM FAM ATMSFaye 004FMS AM FAM ATMSUS401 001FMS FAM ATMSI95 008 Replacement AM FAM ATMSFaye 005FMS 12 AM FAM ATMSUS401 002 Replacemen FAM ATMSI95 009 Replacement AM FAM ATMSI295 002FMS AM FAM SPSI295 001FSP FAM ATMSI95 010 Replacement AM FAM ATMSI295 004 Replacement 13 MD FAM ATMSFaye 001 Replacement FAM ATMSLumb 001 AM FAM ATMSI295 005 Replacement MD FAM ATMSFaye 002 Replacement FAM ATMSNC24 87 001FMS 5195 001 5 14 MD FAM ATMSFaye 003 Replacement FAM ATMSNC87 002FMS AM FAM ATMSNC24 001FMS MD FAM ATMSFaye 004FMS FAM ATMSNC87 003FMS AM FAM ATMSNC24 002FMS 15 MD FAM ATMSFaye 005FMS AM FAM ATMSNC87 001FMS MD FAM ATMSI295 002FMS AM FAM ATMSUS401 001FMS Lod 16 MD FAM ATMSI295 004 Replacement AM FAM ATMSUS401 002 Replacemen MD FAM ATMSI295 005 Replacement 5 51295 001 5 17 MD FAM ATMSI95B 001FMS MD FAM ATMSFaye 001 Replacement MD FAM ATMSNC24 001FMS MD FAM ATMSFaye 002 Replacement 18 MD FAM ATMSNC24 002FMS MD FAM ATMSFaye 003 Replacement MD FAM ATMSNC87 001FMS MD FAM ATMSFaye 004FMS 19 MD FAM ATMGIISA401 001F
146. nto IDAS see Section 5 0 the user can then view performance measures on the network aggregated by these districts This can be a useful and powerful technique to separate certain portions of the network that have a special significance to the analyst and stakeholders This may include municipalities DOT districts public transit agency service areas or individual corridors IDAS does not dictate how this separation occurs even though the name is District it does not mean that this has to be some geographic separation of links It can be anything desired All that is required is that the district code be properly setup in the links network import file before import Note In the FAMPO analysis there was no requirement to split results by district Therefore the district definitions were left at their defaults However we retain the information from prior IDAS work Triangle Region for those interested in how this particular IDAS feature works Figure 4 4 IDAS Setup Districts IDAS Setup TDM Data Facility Types 3 Data Maintenance ITS Equipment Sharing 2 Durham External 4 Input District oe Im el Number m gt gt 4 cmm 2 Durham Franklin Grandville Harnett 3 External as 4 Franklin 4 4 4 154 0
147. o supporting agencies such as accident investigation lost taxes facility damage etc e Vehicle occupancy The benefits calculated by IDAS are intended to include all of the traveling public For example when travel time decreases due to the deployment of ITS it is less for the driver and all passengers in the vehicle This value is a multiplier to bring the passengers into the mix as having received benefit from ITS deployment Because this value is available for use here whenever we define Market Sectors within IDAS we set the vehicle occupancy count at 1 e Year of reporting dollar values This value indicates in what year the benefits and costs will be reported Specifically IDAS produces results that should be considered in one year only It does not for example tell you what the benefit will be in 2015 in 2015 dollars it tells you what the benefit will be in any one year in whichever dollar year the user desires To clarify this note that if this year value is changed the bottom line B C ratio does not change the benefit dollar values may rise in the future year s dollars but so do the costs e Discount rate This value is used by the cost module in IDAS to calculate the present value of a future equipment purchase when equipment needs to be replaced The IDAS cost module will tabulate all future year purchases of equipment based on the useful life of the equipment see Section 11 0 over a period of a few decades into the
148. of Highway_Network_06 18 2009 dcb by typing CD lt drive gt lt directory gt If the DOS Prompt does not indicate the current drive is the correct drive then type the correct drive letter followed by then press enter This can be done either before or after the CD command RunreadDCB with the root name of your data file readDCB Highway Network 06 18 2009 Note that in the above case the readDCB exe program has been copied to the parent directory of our data location This can be placed anywhere but wherever it is unless it s copied to a location on the computer s path variable or to the location of the data the path to it must be supplied When successful the above will result in a Highway Network 06 18 2009 csv file which can then be imported into Excel We import the result obtained into our master links workbook into a sheet named Network Data It is from here that many of the fields for the links will be found and pulled into the 3 network sheets These include e Lanes e Length e Facility name e Speed Using the same tool we imported 3 capacities files into the links workbook These files are found in Model_Interface_V7 Output 2006 Link_Capacity bin for the 2006 model year replacing 2006 with 2035_EC and 2035_LRTP for the future networks The generated Link_Capacity csv file was imported into the master links workbook into its own sheet The 2006 capacities were put
149. of certain equipment the dollar valuations etc When these inputs change and they always do all prior IDAS results sets become invalid or at least suspect and probably should be recreated altogether 13 3 The IDAS Results Workbook Section 11 0 introduced a set of spreadsheet tools used to manage costs of equipment and the relationship between equipment and specific ITS Options The result of the equipment costs management effort is two spreadsheets that become the Costs side of the analysis The Benefits side of the analysis is handled by the previously mentioned Facility Type performance spreadsheets that are produced by IDAS The two costs sheets and one or many performance sheets come together into one management system the IDAS Results Workbook The ability of this workbook to correctly manage IDAS results is based on the fact that the monetary considerations e g dollar values of time and the performance results of the network are decoupled and then brought together later from one source of dollar values and multiple sources of performance values Note The IDAS Results workbook is a single Excel file that contains many different worksheets To clarify when we refer to worksheets or sheets in this section remember that these are within the workbook except when we explicitly refer to another file as in importing a spreadsheet Final IDAS Manual 94 FAMPO Regional ITS Strategic Deployment Plan Update May
150. onal ITS Strategic Deployment Plan Update May 2013 unless there is a problem with the network links or capacities The default value of 0 0025 for the closure gap has always worked well as the default value in IDAS Specify the Analysis Options Figure 8 4 shows the analysis submodules available in the IDAS benefits module During this initial run of the Control Alternative only the actual assignment results volumes and speeds on the network are of interest Usually at least in terms of benefits the other submodules do not need to run Since no ITS strategies are deployed there can be no difference in these measures for this particular baseline benefits run Figure 8 4 Benefits Modules Options A IDAS ITS Deployment Analysis System File View Modules Reports Window Help y E Benefits Module Benefits Analysis Options Assignment Volume Delay Curves Market Sectors Assignment Run Parameters Made Choice Temporal Choice Induced Foregone Demand Emissions Energy Safety Travel Time Reliability Run Analysis ACTIVE Project FAMPO Alternative AM ITS Option Control Alternative ITS Option Selection Available ITS Options AM AM AM AM AM AM AM AM FAM ATM AM FAM ATM AM FAM ATMSAM FAM ATMSAM FAM ATMS SI35 010 SIS5 011VSL SIS5B O01FM SLumb 001 NC24 001FMS NC24 002FMS NC24 87 001F Replacement Traffic A
151. onnel deployment etc 12 2 3 Viewing the Benefits Costs Spreadsheet Clicking on View Outputs Benefits Costs Summary in Figure 12 1 produces the Benefits Costs B C spreadsheet Final IDAS Manual 87 Regional ITS Strategic Deployment Plan Update May 2013 Figure 12 2 The Benefits Costs Spreadsheet If IDAS ITS Deployment Analysis System toles File View Modules Reports Window Help k 9 Alternative Comparison Module ITS Option Comparison Cost Adjustment Value of Time In Vehicle Out of Vehicle Travel Time Reliability Cost of Fuel Emission Costs Accident Costs Fatality Injury Property Damage Only Noise Damage Costs Other Mileage Based Costs Risk Analysis Select Ranges Run Analysis View Results View Outputs Benefit Cost Summary Performance Summary aay ae M Non Fuel Vehicle Operating Cost Other Non Mileage Based Costs Benefit Cost Summary Project FAMPO Benefits are reported in 1995 dollars Annual Benefits Weight AM AM FAM ATMSFaye 003 Replacement Change in User Mobility Change In User Travel Time In Vehicle Travel Time Out of Vehicle Travel Time Travel Time Reliability Change in Costs Paid by Users Fuel Costs Non fuel Operating Costs Accident Costs Internal Only Change in External Costs Accident Costs External Only Emissions HC ROG Global Warming Noise Other Mileage Based External Costs Other Trip Based External C
152. onse Normal view Deployment Impacts Values Link From 21644 21634 Facility Type freeway No of Lanes Hl Distance mi 3 51 Input per 3 326 4 cs 00 E e Incident Duration Reduction 50 Fuel Consumption Reduction 1 00 Accident Rate Reductions Fatality Injury Property Damage Emissions Rate Reductions 21635 gt 21643 20354 20353 20351 gt 20352 20398 gt 20397 20399 gt 20400 20284 gt 20283 20281 gt 20282 Save Save Edits Edit Equipment 2 21 374 e Step 2 In this case only one link at a time is selected the map and in the selected links list and the impacts of the specific ITS Deployment on that link is specified by the user Final IDAS Manual 76 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Step3 From the figure the user is stating that the presence of the Incident Management system will produce a 5 percent incident duration reduction on this link a lpercent reduction in fuel consumption fatality accidents and emissions production To help in choosing the impact values applied here there are several sources of information concerning other agencies experience with various ITS strategies and the anecdotal narratives outlining those experiences are included with IDAS in what is called the Direct Benefits spreadsheet The numbers show
153. orting Network Data This section focuses on issues related to the preparation of TDM data for import and the importing of that data This data includes the node coordinate and link characteristics files e Section 6 0 Importing Market Sector Data This section describes the process used to generate and import the matrix files representing the zone to zone travel demand Section 7 0 Volume Delay Curves in IDAS This section describes how volume delay curves are calculated tabulated associated with facility type and area type and then imported into IDAS e Section 8 0 Running the Baseline Analysis This section details running the benefits module on the baseline network in order to find the control alternative network performance measures for validation e Section 9 0 Validating the Baseline Results This section describes how to compare the results from the baseline run against the TDM output to determine whether the IDAS assignment runs will produce reasonable results Section 10 0 Creating ITS Options This section shows examples of creating ITS options which are collections of deployments of ITS strategies An incident management and a transit deployment are given as examples of using the alternative network generator e Section 11 0 Managing Equipment and Deployment Costs This section describes techniques used to keep the complex equipment costs structure under control These tools also can be used to modify results
154. osts Change in Public Agencies Costs Efficiency Induced Other Calculated Benefits User Defined Additional Benefits Total Annual Benefits Annual Costs 1 00 1 00 1 00 1 00 1 00 1 00 1 00 1 00 418 548 0 0 5 679 21 484 4 821 19 152 3 380 1 737 532 45 631 Average Annual Private Sector Cost Average Annual Public Sector Cost Total Annual Cost Benefit Cost Comparison 606 728 606 728 Net Benefit Annual Benefit Annual Cost BIC Ratio Annual Benefit Annual Cost L1 141 591 0 77 Figure 12 2 shows the bottom line output result that IDAS produces To calculate this spreadsheet IDAS has for each measure in the Annual Benefits column in the figure calculated the difference in the measure that occurs between the improved network performance after ITS has been deployed and the baseline network performance before ITS is deployed IDAS takes that difference in the performance measure multiplies it by the dollar valuation that applies to that measure and then multiplies that by the number of model days per year Final IDAS Manual 88 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 The IDAS cost module calculates the average annual cost of the equipment that is deployed for each ITS Option and that value is used to calculate t
155. pporting Deployments Generic Deployments 78 88 34 98 lt gt 78 62 35 19 I ITS Deployments FAMPO ITS Elements I OK Cancel Name Incident Management Choose an ITS Strategy Step 1 In Figure 10 2 the appropriate ITS Element is highlighted in the ITS Elements list and the user will then click and drag that ITS Element onto the map at which Final IDAS Manual 74 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 point the deployment mode of the Alternatives Network Generator will activate preloaded with the input parameters specific to the type of deployment selected e Step 2 In Figure 10 3 the user has provided a description for the deployment the year of opening and midpoint of construction and has zoomed in and selected several links on I 95 selected links are in black Figure 10 3 Selecting Links for Deployment File View Modules Reports Zoom Window Help LA LUE ce Workspace 0 9 j Incident Managemen Combination Detection Response Normal view Improvement Number 1 Description 1 95 Incident Management Year of Opening yr 2010 Mid Point of Construction 2010 Deployment Locations 78 88 34 98 lt gt 78 62 35 19 Selected Links Additional Benefits Save Edit Impacts Edit Equipment Cancel 10 3 Guidance in Selecting the Deployed Li
156. rmat for input to IDAS 98 Import cost data into IDAS 100 Export cost results from IDAS 101 Using the Alternatives Comparison Module Select ITS Options for comparison 103 Specify dollar valuations 104 Review benefit cost and performance summary spreadsheets 105 Review results by 108 Market sector Facility type District Manage IDAS Results Import cost spreadsheet to IDAS results workbook 113 Import performance results spreadsheet to IDAS results workbook 115 Merge into IDAS results spreadsheet 118 Incorporate monetary and valuation factors 121 Review results 123 ITS Strategic Deployment Plan Update Final IDAS Manual A 4 March 2010 5 IDAS Manual APPENDIX B QUALIFICATIONS FOR IDAS ANALYST IDAS Manual Qualifications for IDAS Analyst May be revised based on agency requirements for position level Education requirements should include Bachelor s Degree in Civil Engineering or Transportation Planning and three to five years of experience or equivalent experience Should have background in transportation modeling and analysis travel demand forecasting transit planning data analyses and transportation policy evaluation Experience should include travel demand forecasting preferably with TransCAD including calibration and validation of travel demand models and providing analytical basis for evaluating the benefits o
157. rnal Centroid ID Number 1051 Translation From TDM Input Area Type to Urban Suburban Rural B C Urban Suburban Rural All Urban All Suburban Rural 4 1 2 TDM Facility Type Information e Step 1 On the Facility Types tab the user provides the name and facility type of the facility type codes that the TDM will be using The type of the facility is either Freeway Arterial or Ramp IDAS refers to these as the V C curve These are set using dropdowns next to each facility type name in the small table containing the facility type information Note In the FAMPO network we have generated a facility type code of 1 thru 6 for convenience and translated the model s value to this as described in Section 5 We also named the facility types based on the VC curve found to represent them Basically 1 and 3 are Urban and Rural freeway and 2 and 4 are Urban and Rural arterials respectively Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 4 2 IDAS Setup Facility Types Districts Data Maintenance ITS Equipment Sharing Importing VCCurve 0 56 VCCurve 0 71 VCCurve 0 83 m as ae e Description curve EN EN gt VCCurve 0 56 3 60 Freeway v NN m gt 4 0 71210 VCCurve 0 83 VCCurve 1 00 Centroid VCCurve 0 83 5 50 Freeway VCCurve 0
158. s E RA DUE aa UE EON 21 Figure 4 5 District Names in an Excel Spreadsheet 22 Figure 4 6 ITS Direct Benefits for Traffic Actuated Ramp Metering sess 23 Figure 5 1 The Extract Data election Window 27 Figure 5 2 Extracting links for direction information suus dtd eee Die ort te des 29 Figure 5 3 Model IDAS volume comparison eie crit eras 33 pigurebod An Empty cedens 34 Figure 5 6 Creating an Alternativen 36 Figure 5 7 Importing 37 Figure Importing Links uos e e a euet 38 PUSS Do TIBES Import DONC ites setlist ccc Gt 39 Figure 6 1 Entering the Maximum Zone Number 43 Figure 6 2 Sample Market Sector Input Parameters siad ie tibia seated canal 44 Figure 6 3 Sample IDAS Import of Trip Matrix from Text File sse 45 Fig re 1 V IC curve in Tabular eni 48 Figure 7 3 IDAS Volume Delay Curves Input WIDHOW ciiin pet tct thee tet iet 51 Figare 8 L TTS Option A i 53 Figure 8 2 IDAS Volume Delay Curves Input Wittd stehen dena 54 1 anre ee E 55 Figure 8 4 Benefits Modules
159. s once for all of your ITS Options In fact you can create ITS Options after importing the curves and those options will also use the imported values Final IDAS Manual 51 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 8 0 Running the Baseline Analysis After having set up the IDAS database with initial information Section 4 0 created and imported nodes links and market sectors Sections 5 0 and 6 0 and defined the V C curves that IDAS will use we should validate to assure that the IDAS model runs produce results reasonably close to those of the TDM A reasonable validation should be achieved before investing any more work in building our ITS strategies Topics Covered in This Section e Introduction to the IDAS benefits module e Set parameters in the IDAS benefits module Run the Control Alternative assignment e Open and save the alternatives comparison module ACM Facility type performance spreadsheet 8 1 Introduction to the IDAS Benefits Module The benefits module within IDAS is used to generate estimates of the impacts of deploying ITS on the model network The IDAS benefits module is roughly analogous to the mode choice and traffic assignment functions within a travel demand model with the important distinction that assignment is always done twice and that benefits in terms of network performance changes are linearly driven from the difference between these two assignments The first time in runn
160. s with other improvements to better integrate ITS with traditional planning processes Final IDAS Manual 4 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 23 How Does IDAS Work The IDAS tool works by importing the results from travel demand models in order to recreate the validated regional network structure and travel demand within IDAS The data are imported into IDAS using a special internal input output interface which is capable of reading and interpreting ASCII text data files These input data files are created from data generated by the travel demand model Depending on the needs of the analysis and the format of the available data the user is typically required to perform some data conversion prior to import into IDAS Once the data are imported they are stored in a database accessible by the IDAS software and may be viewed in a graphical output by the user Once the data input is complete IDAS is capable of operating independently of the model The IDAS user is then able to create analysis alternatives by selecting ITS components from a menu and placing these on the desired location on the network The user then provides additional information regarding their deployment such as the implementation date and proposed operational strategies Once the analysis alternative has been created the IDAS software then modifies the network or travel characteristics to represent the likely impacts of the ITS deplo
161. s with the Facility types named range table e Step 1 First the ID column is labeled DistrictID and the VCCurve column is missing thus the named range called DistrictNames is cells gt F12 in this particular case e Step 2 To import this table visit the Districts tab in file setup Figure 4 4 press File and navigate to the spreadsheet 4 1 4 Other Data Used in IDAS Setup Figure 4 1 shows other tabs in the IDAS setup window Data Maintenance and Equipment Sharing These are briefly explained in the event someone might want to use them However they are rarely used Data Maintenance IDAS has the ability to import large amounts of external data maintained in Excel named ranges into its database The three sets of this data available on the Data Maintenance tab of File Setup are 1 ITS Components These are the Direct Benefits anecdotal entries put together by the IDAS team during document research efforts performed during the early development period of IDAS Final IDAS Manual 22 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 They are simply statements of utility for various ITS strategies organized by performance measure and ITS strategy that an IDAS user can peruse to determine the level of effectiveness of the ITS deployment they are about to analyze EXAMPLE e Step 1 For example if a user is considering ramp metering and wants to know what o
162. same combinations can be applied to other options A Freeway Management System could include detection CCTV and certain communications equipment This specification avoids having to enter individual pieces of equipment for each deployment As an example the Transportation Management Center will provide support to both Freeway Service Patrols and the Freeway Management System which may include CCTV detection systems and Dynamic Message Signs Costs can be allocated among different systems based on the percentage of time on different activities by operators or other criteria Another setting on this window is the costing level of equipment In the ITS Equipment spreadsheet there are three levels of costs for each item of equipment The user can choose to use the low medium or high values of these costs when calculating the costs side of the B C ratio 4 2 High Level Data for IDAS Saving the Work As mentioned at the start of this section IDAS uses a database to manage its information Having populated the first database used with the information detailed in this section now is a good time to make a copy of the database This copy then can be provided to anyone else that would want to start from this point which provides the assurance that the analysis they do would be starting from the same place 5 ITS Option is a collection of ITS Strategies that is maintained as a package in one place One of the reasons IDAS has
163. setup and is ready for the creation of an ITS Option See Section 4 0 for information on setting up the IDAS database This section is focused on importing network data into IDAS Market sector data must also be imported before IDAS can run that information is found in Section 6 0 5 3 1 Creating a Project A Project is an entity in IDAS that can contain any number of Alternatives described next Usually for networks of appreciable size a database would contain only one project e Step 1 When IDAS has been setup for the region Section 4 0 a user will see the WorkPrompter the menu area on the left side of the screen which contains a single tab called ITS Elements as shown in Figure 5 4 below Final IDAS Manual 33 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 5 4 An Empty IDAS Database Arterial Traffic Management Systems Freeway Traffic Management Systems Advanced Public Transit Systems Incident Management Systems Electronic Payment Collection Systems RR Grade Crossings Emergency Management Services Regional Multimodal Traveler Information Syste Commercial Vehicle Operations Advanced Vehicle Control and Safety Systems Supporting Deployments Generic Deployments 9 9 4 8 e Step 2 A user creates a project by selecting File gt New Project from the main menu Final IDAS Manual 34 EEE eee FAMPO Regional ITS Strategic Deploy
164. t 2 cnl Explanatory Linked Cell Note Insert Delete Format Boar Sota mnda Clipboard Font Alignment Number Cells Editing Al O fl Y st D E G H 1 M ol R T BF BG BH Bl a Factors affecting Analysis Desired IDAS Defaults Benefit Cost Summary Number of travel days in a year 247 247 Project FAMPO Year of values 2010 1995 Faye 001 Faye 002 Faye 003 9 Faye 004FMS Inflation Rate 3 0 3 Annual Benefits Weight Replacement Replacement Total 10 Faye 005FMS Value of In vehicle time 24 00 9 63 Change in User Mobility 100 0 0 0 11 1295 002 5 Value of In vehicle time commercial 28 87 16 96 Change In User Travel Time 12 we Value of Out vehicle time commercial 28 95 17 00 In Vehicle Travel Time 100 0 O 12 729 261 12 729 261 13 NC24 001FMS Value of time multipler for Emergency Veh 30 0 30 0 Out of Vehicle Travel Time 100 0 0 0 14 NC24 002FMS Value of Out vehicle time 28 95 17 00 Travel Time Reliability 100 5 105 956 210 720 316 677 8 15 NC87 001FMS Value of reduced delay time 16 39 28 90 Change in Costs Paid by Users 16 US401 001FMS Fuel Costs gallon 2 50 1 21 Fuel Costs 100 213 309 134 472 516 246 864 026 17 US401 002 Replacement Emissions Costs S ton Non fuel Operating Costs 100 0 0 2 448 2 448 18 Dunn 001 HC ROG 3 020 00 1 774 00 Accident Costs Internal Only 1 00 136 310 90 247 112 165 114 392 19 174 001 Replacement NOX 6 351 00 3 731
165. t STREETNAME haract Name z Include only facilities with facility type in CONNECTOR character fC CONNECTORI character M Omit facilities with facility type in PROJ NO character 4 COUNTY character bA DISTRICT integer AREA_TYPE integer FACTYPE integer MODEL_FACI character m M Export Exit z Note in Figure 5 2 that ID and Direction are chosen to be exported and that the entries in the Link duplication group are specified The other data Distance and Name are not strictly necessary When the file is created from the above we get an output file that contains all one way links and a value for direction 0 1 or 1 and either AB or BA depending on how that link was split by the Extract Data tool The specific way in which links are split based on the direction code can be understood by looking at the Link duplication settings in Figure 5 2 The IDAS data will contain roughly twice the number of rows links as does the source TransCAD data In each TransCAD row of data from other sources not just the network links file shown above there will be both AB_ and BA_ columns for 2 way links Because IDAS is using 1 way links we must utilize the appropriate column of data for each of the usually 2 rows of IDAS link data The file generated is imported into our Excel workbook and comprises the root worksheet for
166. tation facilities in the region and travel demand data including the number of trips and mode share of travel between different zone pairs in the model This baseline scenario is then analyzed in IDAS It also is important for the IDAS results to be compared with the model results for validation purposes Once the network and travel demand data have been imported and validated the IDAS user is then able to create analysis alternatives by selecting ITS components from a menu of over 60 ITS improvement types and placing these on the desired location on the network The user may then perform analysis within the software to estimate the incremental impacts of ITS deployments including changes in link speeds and volumes and travel mode shares From these impacts IDAS estimates the impacts in a number of performance measures including travel time accidents emissions noise and other impacts These benefits are summarized for the user and form the basis for comparison with other deployment alternatives created by the user Benefits can be compared to costs which include both annual operations and maintenance costs and annualized capital costs ITS Strategic Deployment Plan Update Final IDAS Manual 1 2010 IDAS Manual What You Need In order for an agency to use IDAS as an analysis tool it is important for the TDM to include specific data files Those files are listed below Zone to district equivalence file optional
167. tep 5 After the system imports the costs sheets it prompts the user whether the existing B C sheets should be rescanned to update the costs throughout the system The answer to this is yes if performance results are not about to be imported This is described in the next section 13 3 2 Importing the Performance Results Spreadsheets 13 3 2 1 Export from IDAS Figure 8 7 shows the performance by facility type spreadsheet in IDAS Note that this is really a workbook with several sheets the sheets that are in the workbook are dictated by which ITS Options were chosen in the Alternative Comparison Module ACM prior to showing the spreadsheet single global value which represents the specific year in which benefits and costs are reported Another single value that is specified in only one place to prohibit any chance of these variables from getting mixed into the analysis from different sources Final IDAS Manual 96 ee FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 2 shows the ACM ITS Option selection window with several ITS Options selected and ready to be moved to the right side to have them included in the resulting workbook Note that multiple ITS Options can be chosen by pressing the CTRL key while clicking the icon Upon pressing the right arrow in the middle the specified combination of ITS options will then be produced when the Performance Summary by Facility Type option is selected on
168. the PM performance sheet and finally merged that with the OP sheet arriving at one single combined performance spreadsheet that contains every ITS Option for every time period for the 2006 FAMPO model e Step 3 The Merge process creates a file the same directory as the first selected file with a file name containing the word and between the two original file names Having combined all results AM MD PM and off peak the desired column in the IDAS Results spreadsheet can be populated e Step 4 First the cell in the Control sheet O8 is given the name of the sheet that will be used to manage the B C for this particular grouping It must be distinct from all other names which are in the 214 cell above each of the list boxes This will become the descriptive name for the ITS Grouping assembled out of the associated list contents e Step 5 Pressing the button highlighted at the top left of the list imports the previously combined ITS Options into the system into the B C sheet for that list At It is possible to have all 4 time periods in one database however the size of databases in network this large makes it easier to keep them separate Final IDAS Manual 100 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 the same time the previously imported costs information is parsed to associate the correct costs with the correct ITS Option While there are many steps ne
169. ther agencies might have achieved in terms of say congestion relief that user can look at the notes from other agencies about what percentage of delay might have been reduced by their actual application of ramp metering Step 2 To accomplish this the user can right click on any ITS Strategy in the elements tab of the IDAS work prompter Figure 4 6 ITS Direct Benefits for Traffic Actuated Ramp Metering IDAS ITS Deployment Analysis System aoe ex File View Modules Reports Window Help Ms Workspace D PROJECT WORK TRIA ITS Library Arterial Traffic Management 5 Freeway Traffic Management Category Costs Ramp Metering Pre set Timing Traffic Actuated Costs Improvements Central Control notes from the field Advanced Public Transit Systel Incident Management Systems Freeway Traffic Management Systems Electronic Payment Collection 9 Ramp Metering RR Grade Crossings Traffic Actuated Emergency Management Servi th Regional Multimodal Traveler Commercial Vehicle Operations Vinneapolis St Paul B C ratio of 15 1 from Twin Cities Ramp Meter Evaluation pr Advanced Vehicle Control and Transportation by Cambridge Systematics Supporting Deployments Generic Deployments inneapolis St Paul Ramp metering system results in from Twin Cities Ramp Meter Evaluation pr innual benefit of over 40 million Transportation by Cambridge Systematics 4 m Triangle Region
170. this grouping is to enable cost savings due to sharing Final IDAS Manual 25 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 5 0 Importing Network Data 5 1 Understanding Network Data Topics Covered in This Section e Requirements for importing TDM data into IDAS e Preparing for analysis e Ensuring that IDAS will be able to correctly analyze the network 5 2 Extracting Data from the Building the network involves importing links and nodes into IDAS For the Fayetteville area analysis it became necessary to find a new way to export the model data Upon inspection of the TransCAD model structure for FAMPO it was found that certain link characteristics were slightly changed in a dynamic way during TransCAD model initialization which meant that the inputs obtained through the methods used in the Triangle Region study would not have been the right values Because the entire TransCAD model input and output structure was available to us it was possible to use certain output files that TransCAD creates at runtime to find our network data These files and the techniques used to extract their data is the subject of the following discussion 5 2 1 Network Nodes in TransCAD Models IDAS needs both Nodes coordinates and Links to construct its network Many TransCAD models do not have numbers for the A and B or I to J nodes in their associated GIS shape file s database There have been many occasions where th
171. thru the end and then pasting the new values into there In such a case you select the values from the import sheet by highlighting cell A1 thru the bottom right cells not by using the select entire sheet icon at the upper left of the sheet Simply ensure that the number of rows is the correct after pasting the values in Also ensure that the row counts are correct in the aggregation formulas in the upper right Scrolling Figure 9 4 to the right we can see the Excel formulas used to make the comparison As opposed to deleting the columns Select the cells to delete not the columns in the column header and press the delete key If you get the shift cells dialog stop and do it another way Final IDAS Manual 68 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 9 5 Excel formulas for link comparison 13 id 9 c links xlsx Microsoft Excel Insert Page Layout Formulas Data Review View Developer E EH Ed pue 9 Formula Bar Q Es rab 4 FEE EJ spit 25 Gridlines V Headings Hide 2 Page Custom Full Zoom 100 Zoomto New Arrange Freeze Save Switch Macros Layout Preview Views Screen Mes Selection Window Panes Unhide 3 V Workspace Windows Workbook Views Show Hide Zoom Window Macros M2 fe VLOOKUP A2
172. to IDAS e Generate and save the IDAS costs spreadsheets 111 New Approach to Managing ITS Costs Over many years of experience with the IDAS system in the analysis of ITS strategies in a wide range of regions throughout the country it has consistently held that stakeholder agencies always have a clear idea of the costs of equipment and of the components necessary to build the systems they are analyzing IDAS was built from the beginning to include ancillary costs either over and above deployed equipment or in place of deployed equipment that agencies might want to include should they need to These are called user defined costs However since agencies already have knowledge of equipment lists and cost figures the user defined costs have become the de facto method of providing costs data for the analysis When IDAS uses equipment costs it considers not only the initial capital and O amp M costs for construction but propagates those costs over the future period being analyzed in order to assess the true economic costs of the system over time Travel demand models and long range planning efforts often go out as far as 30 years and IDAS is capable of economic analysis for this length of time However most ITS equipment has a significantly shorter lifespan and changes in technology occur far more rapidly as well Two considerations that agencies have a good handle on specific costs and that IDAS has the correct model to ex
173. to see the contribution of just one of the ITS Options to these numbers simply go to the Control worksheet and click off all but that one ITS Option in the list of options comprising this group e that the Go button circled at the top of this page will create a copy of the two tables shown in Figures 13 7 and 13 8 with a name that is in the text entry field to the left of the Go button unless such a block already exists in the spreadsheet with that name in which case the contents of that block are replaced e The Clear All button erases all of the existing predefined groups This is done to clear out any old data when some event happens that might make them invalid such as re importing costs e To recap to create a snapshot of the specific set of ITS Option groups currently selected as the mix of interesting options including a subset of the ITS Options themselves within each group simply select the groups active in the list of options on the left side of the Results worksheet and then for each group select the ITS Options active by selecting them in the lists on the Control spreadsheet There is no restriction to the combinations that can be created this way CAUTION One must be somewhat careful regarding costs When four time periods are combined as they are in the FAMPO study only one of the time periods should have the costs associated with them This is why AM was prepended to the ITS Option names as described i
174. to the model as well as outputs from the analysis procedures Unlike many traditional travel demand models the IDAS model does not create individual output data files during different phases of the analysis to be passed on to the next analysis phase Instead data are stored in various fields of the IDAS database The different modules access these data directly from the database perform the required data manipulations and pass the results back into the database For some data the input output interface can be used to create output files for subsequent input back into travel demand models Final IDAS Manual FAMPO Regional ITS Strategic Deployment Plan Update May 2013 3 0 Model Overview Travel demand models represent one of the primary tools used in urban transportation planning Computer simulation models generally are validated or calibrated to represent existing conditions and are then subsequently applied to forecast future traffic and transit ridership Most of these models follow a four step process of trip generation trip distribution mode choice and trip assignment TransCAD is a fully integrated Geographic Information System GIS planning modeling platform currently used as the travel model platform for models in North Carolina The model is a traditional four step model with some enhanced features designed to meet evolving state of the practice multimodal modeling standards In this particular study we received the ent
175. ual Cost in 2012 Dollars 43 022 43 022 3 654 963 3 741 007 39 Vehicle Occupancy 1 25 Actual 2012 O amp M Cost in 2012 Dollars 15 025 15 025 0 30 050 40 Benefit Cost Comparison 41 Year of reporting values 2012 Net Benefit Annual Benefit Annual Cost 555 025 268 834 10 410 250 11 234 109 42 Discount Rate 5 0 BIC Ratio Annual Benefit Annual Cost 13 90 7 25 3 85 4 00 43 Initial Capital in year 2012 222 370 222 370 0 444 740 44 Year Bi 2012 2012 2017 45 Capital in year Built 222 370 222 370 15 079 633 46 O amp M year Built 15 025 15 025 1 507 963 47 Control Costs Stream Faye 00SFMS 1295 002 5 Ready 2 Final IDAS Manual 102 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 13 5 shows the bottom line results of the grouping of ITS Options that have been imported and selected as active in the third list of options on the Control sheet e On this worksheet all of the ITS Options can be compared side by side and each column R through BE represents one of the groupings that can again be created in any way a user may desire In our case we combined the 4 periods of three ITS Options e On the left side of Figure 13 5 we choose which groupings to include by clicking them in the list Any grouping not selected will have its corresponding column hidden in the B C table The Use of Monetary and Valuation Factors in a Single Location In Figure 13 5 the most compelling reason to use the I
176. ublic Capital 25 621 05 Private Capital 0 00 Public O amp M 13 750 00 ITS Option Costs Private O amp M 0 00 SUBTOTAL 39 371 05 User Defined Cost 5 AM FAM ATMSFaye 002 Replaceme Public Capital 25 621 05 Private Capital 0 00 Public O amp M 13 750 00 Private O amp M 0 00 SUBTOTAL 39 371 05 Project Alternative AM Once these two costs spreadsheets have been created and when costs or deployments change specifically new ITS Options added the necessary steps from the perspective of preparing costs data are done We will use these costs spreadsheets to apply the costs data to the analysis in the discussion on organizing results in terms of benefits and costs in Section 13 0 Final IDAS Manual 84 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 12 0 Using the Alternatives Comparison Module Topics Covered in This Section e Selecting a group of ITS Options to compare e Setting the dollar valuations that drive the benefits e Viewing the Benefits Costs spreadsheet e Viewing the Performance Summary spreadsheets 12 1 Selecting a Group of ITS Options In the ACM any combination of ITS Options within the current database can be viewed or compared to each other Note that when multiple databases are used there is no facility type view results between them However by exporting spreadsheets from the ACM of each database they can be easily merged to compare results Fina
177. un Analysis am p View Results AM m View Outputs AM FAM ATMS Benefit Cost Summary 51295 003 51295 004 51295 005 1295 006 5 Communicatio Replacement Replacement Summary B BH by Market Sector by Facility Type M nr by District 8174 001 5174 002 5174 003 5174 004 Replacement Replacement Replacement Replacement AM AM AM FAM ATM 5185 002 5195 003 5195 004 5195 005 Communicatio Communicatio Communicatio Replacement 0 4 2 a AM AM Reset Defaults Select the Control Alternative e Step 2 At this point if the Control Alternative option is in the left window click it once and then click the right arrow between the two boxes Produce the Performance by Facility Type Spreadsheet Step 3 Click on the Performance Summary by Facility Type near the bottom of the left side of Figure 8 6 This creates the Facility Type performance spreadsheet shown in Figure 8 7 Final IDAS Manual 60 ee 22 222 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Figure 8 7 Performance Summary by Facility Type
178. utputs Number of Person Trips Control Alternative Benefit Cost Summary 5 Option Performance Summary Difference by Market Sector Number of Fatality Accidents by Facility Type Control Alternative by District ITS Option Difference 96 Number of Injury Acciderits Control Alternative ITS Option 4 Control Alternative 1 Done Show Centroid Connector Data Emissions data does not include cold start or trip duration amounts Accident data does not include intersection collision avoidance impacts Incident delay figures are calculated for freeway links only Person hours of travel data does not include hours accumulated in Transit market sectors Step 4 Note carefully in Figure 8 7 that the Show Centroid Connector Data check box has not been checked This is optional but it is important to remember whether the total column on the right of Figure 8 7 contains Centroid Connector volumes and speeds Save the Facility Type Spreadsheet e Step 5 Click the Diskette icon with a question mark shown in the upper left of Figure 8 9 This provides an option to save this spreadsheet as a workbook In the file dialog box be certain to select xls as the file type as the default file type has no real value e Step 6 Having run the Control Alternative through the benefits module and saving this Performance by Facility type spreadsheet you are ready to perform validation of the IDAS results with information from the T
179. wn at the top of the ITS Option selection window Figure 12 1 This factor indicates how many of the time periods that the original TDM data represents will exist in any given year Because the IDAS Benefits Costs spreadsheet is an annual picture of the benefits this number is needed to convert the single time period network performance measures into an annual period The default value of 247 is 52 weeks of 5 weekdays minus 13 holidays Note It is not valid to specify a value of 1 here to consider the benefits costs on a per day basis All costs including the IDAS calculated equipment costs and the newer costs technique used and described in Section 11 0 are always annualized Given that the lifetime of equipment is given in years and that this is a critical factor in the calculation of future costs it would be problematic to convert costs to anything other than annual e Most of the cost factors down the left side of Figure 12 1 are self explanatory the exceptions are o Emergency vehicle value of time multiplier This is tied to the value of time as a multiplier The default of 30 accounts for the fact that an injured traveler seeking medical treatment values time very highly o Internal and external accident costs Internal costs refers to the affected travelers costs such as vehicle repair lost wages etc External costs refers to public agencies costs such as facility repair costs lost taxes emergency pers
180. work FAMPO Costs stream of costs xls 5 IDAS Average Annual costs spreadsheet 6 D project work FAMPO Costs average annual costs xls 7 8 Should cost entries be matched exactly to the ITS Optionsin the selection list 9 10 Year of initial cost values sent to IDAS 2009 11 Year of Earliest Deployment 2010 12 13 15 16 17 18 18 Importing Costs IDAS Cost Module 21 s 22 23 How Costs work 24 25 Text needs updating 26 27 Aspreadsheet was usedto maintain all of the costs on a per project basis as well as a per ITS strategy basis 28 This spreadsheet gathers it s information a specific place thatis then imported into the IDAS cost module in a specific way described in the IDAS Cost Module tab 30 a It must be remembered thatthe costvalues in the 2 sheets that are imported into this workbook arein inthe year stated above and that this yearis 33 referenced by the code this spreadsheetuses 34 Note that after the above two workbooks are imported via the command buttons on this page then when the FT results sheets are imported see 35 instructions the costs data thus imported will be scanned Therefore itis necessary to importthe costs first before FT results andit is also necessaryto 36 re importthe FT results if the costs change and themselves getre imported 37 38 39 40 41 42 43 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 When the equipment costs spreadsheet Sectio
181. x Summing Trips matrix Done Applying the Control Alternative results Matrix ACTIVE Applying the Control Alternative results Network 03s Finished 01m 52s Project Alternative AM ITS Option Control Alternative Benefits Run Settings Report Final IDAS Manual 58 22 2 2 22222 2 FAMPO Regional ITS Strategic Deployment Plan Update May 2013 Note IDAS is not a multitasking thread aware application In particular while the benefits module is running it is not possible to switch away and manipulate other parts of the IDAS system This means that IDAS may appear not to paint its user interface and may look like it has stalled Windows may even tag the application as not responding during this period of time Please be aware that IDAS is not stalled and will eventually refresh its screen to indicate it is running 8 4 Open and Save the Alternatives Comparison Module Performance by Facility Type Spreadsheet The Alternatives Comparison Module is used to view the results from the IDAS benefits and costs calculations by mixing and matching groups of ITS Options together and reporting on them all at once It is described in its own section Section 12 0 Discussion of this module here only relates to obtaining the data we will use in the next section validation Open the Alternatives Comparison Module e Step 1 Select Modul
182. yments placed on the network by the user These modifications are based on either real world impacts observed in other regions following their deployment of similar ITS components or on local data generated through the existing ITS system or evaluation studies Modifications may include changes in link capacities or speeds zone to zone travel times accident or emissions rates or other impacts specific to the ITS component The IDAS model then uses analysis techniques similar to a TDM to analyze the impacts created by the modifications to the alternative network and travel characteristics A traffic assignment routine is used to estimate the changes in travel patterns caused by ITS deployment and a mode shift routine is used to estimate any travel mode changes The results of this analysis are revised link volumes speeds and mode shares The changes in link volumes speeds and mode shares are then used by IDAS in another series of analyses to calculate changes in the travel time the number of accidents the amount of emissions fuel savings and other impacts Dollar values then are applied by IDAS to these impacts to provide an estimate of the benefits of the ITS components deployed in the alternative In a separate process the costs of the ITS deployments are estimated by IDAS and are compared with the benefits in the form of a benefit cost ratio These outputs are summarized and displayed to the user in several formats This process is summar

IDAS Manual - Institute for Transportation Research and Education

Contents

Download Pdf Manuals

Related Search

Related Contents