DRAFT User Manual CORRECT
Contents
1. Add Reduce Lanes Change Access 28 Change Curbs N Change Enforcement Change Instrumentation Change Lighting Change Median Change Rails Barriers Having selected a Treatment Category scroll back to the left and select a treatment up to three treatments may be specified in this way Close driveways near intersections Consolidate driveways Eliminate left turns at driveways 13 Insert Initial Cost For each treatment an initial capital cost needs to be estimated This is usually fairly easy to estimate from past project of similar type The results will be entered here Life expectancy and Maintenance costs For each treatment the life of that treatment and the cost per 16 Maint Cost annum to maintain it must be estimated and entered wears Accident Crash Rate Reduction Facto rs 17 Accident Rate Reduction For Roadway jaint Cost Environment Causes er Year 8d 17 Accident Rate Reduction For Roadway Environment Causes For each Treatment the investigator should estimate a Crash rate reduction fac tor associated with each Cause specified If three Causes have been listed then the first row under 8a 8b and 8c in the il lustration shown above will be shown as mandatory Note these are to be speci fied as reduction factors and not modification factors as reflected in the NCHRP re port Further these are not applied to all crashes at the location but ONLY to the crashes th2. WS Instructions Parameters The left portion of the page is for RURAL data and the right portion is for URBAN data Because the ratio of injury to fatality crashes 1s different for rural and urban crashes mainly due to speeds and also the availability of EMS they are calculated independent ly in this spreadsheet As is evident the number of crashes by severity injuries and fatal ities for each of the roadway classes over the last three years will be contained in this worksheet If and only if this worksheet needs to be updated the following procedure should be used 1 Key in the lowest year for the 3 year set of base parameters in cell Al Generally this data will be for the most recent three years for which data area available e1 ther in CARE or other sources 2 For each of the Federal State County Municipal classifications enter the values for e Number of Fatal Crashes Accidents from all causes yellow field e Number of Injury Crashes Accidents from all causes yellow field e Number of Fatalities G ndividuals white field e Number of Injuries individuals white field Repeat this step for the Urban classification on the right Key in the current PDO Property damage only cost per crash Key in the current cost of an injury used by the state Key in the current cost estimate for a fatality used by the state All other fields are calculated and are used in the CASE sheets that will be created When complete c
3. do not key into these fields Edit Parameter Sheets Edit Crash Edit Treatment Edit Cities and Edit List of Crash Edit Treatments Parameters Costs County Lists Causes List Create Items Create Sheet for New Create Summary Location and Listing FileName CORRECT_Template v 0 1 0 xls Analysis Basis lt enter description of basis of parameters used gt M 4 gt mh Instructions Ready Different versions of Excel behave differently it might be necessary to unlock the copy of the spreadsheet if this is the case use help and adjust the settings appropriately The most recent versions will give warnings and directions when a protected field is selected Note the color codes and their definitions They are used in the analysis sheets to help make them easier to read and to avoid erroneously keying into fields that contain formu las Before embarking on the first Benefit Cost estimate it is necessary to set up and or check all the parameter sheets that will be used in all the estimates in this workbook If any such estimate requires a different set of parameters these should be set up in a new Workbook e g if the years used to create base crash statistics see Parameters sheet change then they should be created in a new workbook If not the new values will be applied to ALL estimates in this workbook The buttons on the Control Panel will now be discussed in order Edit Crash Parameters Button Clicking this button w
4. DRAFT User Manual CORRECT Cost benefit Optimization for the Reduction of Roadway Environment Caused Tragedies This document is in draft form and is intended for information purposes only It should not be used for system operation DRAFT February 26 2011 Table of Contents PoS HOM a nseunanete nates ete acerca lot ita et Ai alesente eae aap aaah eterna seca ies 3 CTC ALS ANS Wr PING oc E Ta 3 Control Pane liCinstruicttOns SHECD aoran a 3 Fait Crash Parameters Butona E E E ATER 5 Fie Cie Sain dC OU MES SANS 0S ea a E E A Aa 6 Edit Listor Crash C Ase Soen EE E lol ee cadactuehs tolerated E ERE A O 7 V6 Fi ig PS Biers 8 0 ca Eisbaren A E E A A 8 Edt Heameni COS Senere occas ein tact acca E NG 9 Create Sheet for New Location or Estimate c ccccccceeccceescsecccscceeseeccesscessceesseesseeeees 9 1 Time period for Accident DISTO Visico e eii 11 ZDI snaa a T E the Achat ts ths chiens 11 3 Select INE Roadway SysteM scrisoare naea n a a a 11 4 F ndine IMPOR ON sessa a E aE E a eres 11 5 TOC AION normato ee a aa 11 B eres milo N10 ean E E E E S N oer rec eee rrnt 11 COUDE a Te a 11 CID E E 11 G6 Wile pOSt InN Onna Oi kain a EE E a AES gens 12 7 TVestts atOrs IMT OF Mall oisean A 12 3 Causes Ol AC CICCINUS xiiciic ered a E Wevdeacdadasaevdebiandetemiactadentanctateas 12 Select Ose Crt OUD ig saeawtsiveratordancae E teats wine seiner TE 12 Enter ase etal Sanzo E E batted ER 12 OE id EE E Kaen eee Cm
5. arkings Missing or Faded N Obstructed by a Previous Crash Obstruction in Roadway For the specific cause listed for the roadway location being considered for improvement key in the Numbers of 10 Fatal Accidents Crashes 11 Injury Accidents Crashes 12 12 PDO Accidents Crashes 9 Total Number of 10 Number of Fatal 11 Number of Injury 12 Number of P D O Note These numbers are for the Time Period of Accident History discussed earlier Item 1 Repeat the previous two steps for up to three more causes IMPORTANT any histori cally determined crash must only be assigned to ONE roadway environment cause or else this double counting will result in an exaggerated benefit estimate Assign each crash to its most likely cause only If any historically determined crashes cannot be assigned to any roadway environment cause then they should be excluded from con sideration since the countermeasures proposed will not have any effect on them Note that total accidents are automatically accumulated and the number of causes is counted automatically 13 Treatments Up to three treatments for the segment of road specified are allowed Enter all treatments that are being considered If more than three have to be considered create an additional virtual location to handle it Select a Treatment To enter a Treatment scroll to the right Select Treatment Category Select Treatment Category Change Access
6. at are listed for the corresponding causes Maint Cost Jer Year Benefit Cost Analysis Once all of the above information has been entered the Benefit Cost fields are automati cally calculated Benefit and Cost Analysis Copy All Sheets to Summary Reference Number BRO563 System RURAL STATE Based on 3 years of accident history G 170 000 1 0235 B C Ratiol Benefit Cost B C Ratio2 Benefit Cost Maintenance Cost The following gives another possible completed example for a location 14 Home Insert Pag out Formulas ata Review Vi Add Ins a Q o pp es tt a SAE i l0 A A D7 Custom F FA g eas 74 i Fy l an F Delete 7 1 _ os Oo 00 aatats Ana m men Pal a p r gt A 5 h Gv Y ie Conditional Format Cell or a Sot amp Find amp a ay Formatting as Table Styles Hed Formaty 27 Filter Sele Clipboard M Alignment Styles Cells Editing N34 E fe A B Cc D F G M Candidate Analysis Site Evaluation Form CASE Form Reference Number _BRO563 Create New Location Sheet Copy This Sheet Clear This Sheet 4 Funding ON System __HES403a_si OFF System o oOo O Time Period of EEA 1 Accident History 2 Date Years Municipal 3 System Urban _ Federal State County Description City 6 Location 132 near 009 south of Wetumpka _ _ Elmore Rural Elmore 6 Segment ID s132 ___ From 125 to E System RURAL STATE Node Milepost Node Mi
7. ation CASE sheets that all utilize the same basic parameters that are set up in a single Parameters sheet CASE sheets essen tially define the costs and benefits of alternative improvement scenarios at a given loca tion The Parameters sheet is used to set up the primary parameters that will be used for all CASE sheets in the workbook Create a new file It is generally necessary to create a new file of CASE sheets when making a new COR RECT application To do this copy the delivered file CORRECT_Template_ lt version gt xls to a suitable location and give it a meaningful name Do NOT called it Template give it a name that is representative of the project funds you are allocating e g 2011 HES Allocation Be sure to copy it as an Excel Macro Enabled Spreadsheet if not func tionality will be lost Terminology Each file in Excel jargon a workbook can hold multiple CASE sheets Each CASE sheet will be in a separate worksheet within the workbook Again work sheet is the Excel name for a separate subdivision within their workbook In this manual these will generally be referenced as CASE sheets or just sheets The number of CASE sheets will be dependent on the number of locations under consid eration It is recommended that the total number of potential locations to be improved be subdivided so that for example very large and very small projects are not considered simultaneously within the same wor
8. entID From od te o O RURAL STATE Node Milepast Node Milepost Notice that the System information was filled automatically when it was selected 7 Investigators Information It is often very important to record the names of the investigators who prepared this esti mate This is a free form field in which to record the information 8 Causes of Accidents In any Hot Spot being analyzed there may be more than one significant cause of the ac cidents there The following entries allow the description of and statistics related to those causes At least one cause MUST be inserted and designated by the mandatory colors of the cells Select Cause Group First scroll to the right of the screen to find the Select Cause Group fields Select Cause Group Errop__ and select the appro priate group J By selecting a group the appropriate list of Causes will be made available for selecting in the main Causes panel 9 Total Number of 10 Number of Fatal 11 Number of Injury 12 Number of P D O Roadway Environment Causes of Accidents Accidents Accidents Accidents Accidents Animal Animals Driver Event NonMot Event non fixed Ro Roadbed k Roadway Accessories Signage 8 Total Number of Roadway Environment Causes ___ O Enter Cause Details Select the required Cause in 8a Roadway Environment Causes of Accidents Struck by object set in Motion by Motor Vehicle Lane M
9. ill open the Parameters sheet an example of which is given below URBAN 2006 Federal State County RURAL 2006 3 Fat Ace Inj Acc Fatalities on Federal O 2a a aro 5367 State ter ias2 Ci99 i County at a a aa a E Inj a Fat as Inj Ace Fatalities bibat D e E EEE a EE Fat Aco Inj Ace Fatalities Injuries al et it ss sj eaj 115 12266 Fat Aco Inj Ace Fatalities mu Ca e a a E E EE oo a oe oaa 1228 URBAN Total Fat Ace Federal 305 State 256 Municipal Municipal URBAN 2007 Federal State County RURAL 2007 Federal Stabe County Fatalities mres Municipal Municipal URBAN Federal State County RURAL Federal State County Fat S Fatalities en Municipal Municipal RURAL Total Fat Ace Federal 657 State 494 6228 569 Inj Ace Fatalities 16266 14820 2739 Injuries 24691 zady 3909 Inj Ace Fatalities 10375 feo Injuries 17050 13766 27485 County Gos 16298 934 Municipal 0 36 0 Statewide 2004 36039 2266 Rural Injury and Fatality Costs IF Ratios 15 79 16 66 21 45 nfeasible 18 43 RURAL Federal Stabe County Municipal Statewide 119 medz County Tri Municipal Statewide URBAN Federal State County Municipal Statewide r201 i i 302 26906 1000 60731 Urban Injury and Fatality Costs EF Ratios 44 56 of 69 35 57 69 09 60 73 lumber of Years PDO INJURY Per Crash Costs 100 000 lt Please enter CURRENT costs here 4
10. itial Cost Years Per Year Ba Jja b Jae Jad Copy This Sheetto Summary Copy All Sheets to Summary Based on 0 years of accident history Notice that the Reference number is inserted into the sheet and is used as the sheet name as shown below Reference Number BRO563 BRO563 10 1 Time period for accident history en The cursor will initially be positioned in the cell marked Toa Time period for accident history This is an important number and should be the first 1tem entered It is the number of years of accident history that will be used to generate the statistics used in the four en tries of Causes of Crashes see below Enter the number and press Enter 2 Date Range 2 Date Key in the date range e g 2007 2009 for the crash history esti mates for reference only e g for potential CARE reruns 3 Select the Roadway System In order to set up the calculations correctly and to utilize the proper parameters it 1s nec essary to select the right system from the area of the screen shown below 3 System Urban Federal State County Municipal System Rural __ Federal State County lt Please Click one of the buttons at the left Choose either the Urban or the Rural row and click the appropriate button for Federal State County or Municipal road system Click the button that has the label not the blue box If for example Rural Sta
11. k Create Sheet for New Location Create Summary and Listing Clicking the button Create Summary and Listing causes two sheets Summary and List ing to be created NOTE These two sheets are not dynamically updated The user must again click on one of the Copy buttons to regenerate the pages after a new page is created or any change is made to any of the analysis sheets Summary sheet The summary sheet will contain a copy of the Benefit and Cost Analysis from each anal ysis sheet one below the other for easy reference Listing Sheet Optimization This sheet presents the optimal allocation of resources according to the data input given for the various alternatives at all of the locations Optimal here means that it is impossi ble to produce any greater benefit by changing any alternative specified The specified alternatives produce the maximum possible safety benefit given the budget In order to view how this works it is recommended that users change the value of the budget speci fied and click the Run Optimizer button The alternatives will change to fit the updated optimal set of alternatives within the new budget 16
12. kbook This assists in creating a better situation for optimization and it will also facilitate processing since the more sheets in a single work book the slower the response time may become A suggested target would be 20 to 30 CASE sheets per workbook Further instructions are given in the next section Control Panel Instructions sheet Note Instructions is the name of the sheet containing the Control Panel Once the template is copied open the new file workbook The initial display will be the Control Panel with the worksheet named Instructions bottom tab The Control Panel has only 1 editable field called Analysis Basis otherwise its function is to gain access to basic parameter sheets Insert for reference purposes only the basis and source for the entries made in the Parameters section This could include the name of the particular program being addressed the years for which crash counts were extracted and the date for the current crash costs The Control Panel is shown below for a copy of the template into the file named CORRECT_Template v 0 1 0 xls Microsoft Excel CORRECT_Template v 0 1 0 xls File Edit View Insert Format Tools Data Window Help E A ETENEE IEA E E T Arial 10 B Z U B13 T fe CARE CORRECT Workbook Control Panel Color codes used for fields Mandatory cells requiring data Dark Yellow C Data input cells not mandatory Light Yellow C J cels with formulas
13. lepost 7 Investigators David Brown creating eat case l F 17 Accident Rate Reduction For Roadway haca l a el ag ae ees ss Description of Alternative Safety Treatments 14 Initial Cost Years Per Year gas 8b Total Number of Safety Treatments 2 Benefit and Cost Analysis Copy This Sheetto Summary Copy All Sheetsto Summary _ Reference Number BRO563 System RURAL STATE Based on years of accident history M 4 gt gt Instructions Template BR0563 2 Ready Transferring Data Sheet s to the Summary Clicking the Copy All Sheets to Summary button transfers the Benefit and Cost Analy sis results to a Summary sheet and at the same time enters them into a sortable list in a sheet called Listings Ifa Summary sheet already exists it will be recreated to avoid duplication entries The same is true of the Listings sheet The Copy This Sheet to 15 Summary button will not work until a summary sheet is created which will occur when the Copy All Sheets to Summary button is used to create the Summary sheet Repeat Process for All Locations The process indicated above for the first location will be repeated for all locations this might include dozens of replications of the above procedure to get all of the locations into the spreadsheet All location CASE forms must be entered before going to the next step To enter a new CASE form go back to the Instructions page and clic
14. lick Done button in lower left corner Dn wW Edit Treatment Costs This button is not activated It is a place holder in anticipation that a standard set of treatment costs might be available sometime in the future Edit Cities and Counties Lists This command opens a worksheet used to define city and county pick lists for the CASE sheets The following are the first 20 entries for Alabama Counties Cities poue If these lists need to be updated counties should be entered in the panel shown to the left New cities with their associated county should be entered in the panel on the right All entries should be in alphabetical order with the cities being listed alphabetically within their county When inserting new entries make certain that the following rules are fol lowed e Insert a row within the heavy blue lines e Make certain to insert in alphabetic order e Make certain that in the left panel all cities for one county County column are kept together and are in alphabetic order e Make certain that the spelling of county names in the right hand panel are ex actly the same as those in the left panel list of counties Each cell in the County column of the left panel is a pick list and this method of entry is ad vised When completed click the Done button Edit List of Crash Causes Note During prototyping and beta testing the Wyoming codes have been left in the proto type This can be replaced with Alabama data
15. may be free Enter Reference Numb OF ie are form alphanumeric We recommend it be Cancel kept short since it will become the sheet number as well on the bottom tab Some JBRO563 alpha prefix for a given project might serve to attach the site to a given project Reference Number x The following is an example of the Candidate Analysis Site Evaluation CASE form sheet that will be opened DET amn Ti m x N ONT oe Formulas R j a2 o d o Po a lnsert y ly Aw 11 r Aa Va d Custom al J F 55 tg or g Delete 7 wl Zi s 2 02 Conditional Format Cell m Sot amp Find amp Formatting 7 as Table Styles E Format 2 Filter Select Styles Cells Editing ay LURR Alignment Number Candidate Analysis Site Evaluation Form CASE Form Reference Number _BR0563 Create New Location Sheet Copy This Sheet Clear This Sheet 4 Funding ON System as OFF System Time Period of an 1 Accident History 2 Date 3 System Urban __ Federal State County Municipal State _ County lt Please Click one of the buttons at the left Description County City von Eee iE E Ewwa 6 Segment D C rom oe E system 0 Node Milepost Node Milepost imestgators 0 System Rural 8 8a 8b 8c 17 Accident Rate Reduction For Roadway Da nema fee ee ee Description of Alternative Safety Treatments 14 In
16. once its potential use is verified To po tentially save keying in long descriptions of crash causes these are established as pick lists This button allows editing of those listed and allows new ones to be entered Typi cally these lists will be the same as entries stored in CARE variables for e Roadway Contributing Circumstances codes e Environmental Contributing Circumstances codes e Most Harmful Event for Causal at fault Vehicle Since CORRECT is primarily aimed at finding benefits for roadway projects Driver and Non Motorist causation is omitted from this list Clicking the Edit List of Crash Causes button opens the following sheet Causes of Accidents AA The Groups in the left column are used simply to make it easier for a user to select the Cause when the list of possible causes is very long Although the column names are dif ferent the same rules for entering new values as shown for Editing Cities and Counties apply When finished click the Done button Note The Number column shown is not used and is for reference only Editing Treatments List In a similar fashion to the table of causes of crashes this table presents a table of roadway treatments that could be deployed The default list of treatments is taken from the NCHRP Research Results Digest 299 published in November 2005 This report includes recommendations for Crash Modification Factors for many of these Treatments under various conditions Ho
17. rt were Ne TSE NEC OnE Rete ar eRe eee E eine eT a oe 13 Seka Tee e a aa eR eo N 13 Me Matta OS ea E OA Waaasaseued eoanest 14 Life expectancy and Maintenance costs sesssseoeeessssssseseerrssssssseererssssssseeerrsssssseees 14 Accident Crash Rate Reduction Factors cccccccccccesccceseccesecceecseeesseeueseeesseeenseeees 14 Benerit COStAnaly sis ccnsu ties io wisasteuts wsduien ted O 14 Create SUMMIALY and MASTS canissa a EEA ea sandee boon aewe 16 UII Y SCC E dance secu E E E S T E EE 16 Listine Sheet orsina a a a E A ve ttaxathn 16 Introduction CORRECT is designed to ease the cost and benefit evaluations for determining optimal alternative safety treatments to be applied to the highway system CORRECT has been built as an Excel Workbook into which multiple locations can be added and summarized CORRECT opens a control panel sheet from which a number of commands can be initi ated These are divided into two broad classes 1 editing of parameters and pick lists and 2 creation new analysis CASE sheet and creating the summary The benefit computations are dependent upon the road classification e g Federal State County or Municipal and whether the location under consideration is determined to be Urban or Rural For each combination of these classifications a set of annual crash fre quencies is used to derive the overall Benefit Cost values and ratios Each workbook can contain multiple Candidate Analysis Site Evalu
18. te is selected the resulting screen appears as follows 3 System Urban Federal State County Municipal System Rural __ Federal State xX County By selecting this button not only has the X been set but all the calculation formulas have been adjusted in the benefit calculations It also makes available the area of the screen used to enter the causes of crashes and associated statistics available for entry These are hidden until items 1 and 3 are entered In addition clicking one of these seven buttons enters the description of the system in the field marked System see 6 below 4 Funding Information These funding fields are for record purposes only Insert the names of the On System and or Off system funding sources 4 Funding ON System fF O OFF System fF 5 Location Information The following information is mandatory although not used by the application Description County City Description This field is free form and should be used to describe the highway or street name an other relevant information County This value must be entered from the picklist see Control Panel above City This value must be entered from the picklist see Control Panel above 11 6 Milepost Information In order to record the precise location for which accident statistics are being recorded e g from a Hot Spot identified in CARE the milepost information is recorded here 6 Segm
19. wever because of the levels of uncertainty and the variability in crash causes this sheet makes no attempt to provide that data for inclu sion in the analyses It is left up to the analyst to estimate those numbers based either on the published recommendations modified by best judgment in specific situations or based on best practice established with the analysts organization Clicking the Edit Treatments button opens the following tables Done Treatment Once again the Categories are defined to help to navigate the Treatments in the pick lists Despite the different column headings the rules for editing these tables are the same as for Cities and Counties Edit Treatment Costs Future enhancement Create Sheet for New Location CASE Form A new sheet is required for each location which usually corresponds to a CASE form to be added to the project resource allocation workbook To create a sheet from the Control Panel click on the Create Sheet for New Location button Issues that could arise at this point e If the spreadsheet is not set up for macros it could require the user to indicate the allowance of macros by clicking the yellow bar at the top of the page and e Some macros for which no data pages yet exist might generate a message e g some of the future enhancements Click the appropriate button to ignore these is sues 1n order to proceed This will then prompt you for a Reference Number as shown The number
Download Pdf Manuals
Related Search