User-Defined Report Columns
Posted: Mon Feb 27, 2006 4:41 pmWhat a great revision 7. The User-Defined Repot Columns really make work easy in being able to user-define your own areas of interest. One item of interest is taking the cumulative delay (CD) and converting it to an average intersection delay by deviding CD by CLN (cumulative number of links in run). This allows Exhibit 16-2 in the 2000 Highway Capacity Manual (HCM) to be used and to estimate a level-of-service (LOS) for corridor being evaluated. A user defined column was created called DPerInt which is "CD/CLN". The box is checked saying "This formula is already an accumulation implicitly". Then, another formula is created called "LOSDelay". The equation used is: If(DperInt<=10,1,if(DperInt<=20,2,if(DperInt<=35,3,if(DperInt<=55,4,if(DperInt<=80,5,6))))). This is taking Exhibit 16-2 in the 2000 HCM and applying a LOS to the report. The only problem is that TS/PP-Draft does not allow "letters" in the "IF" logic, so numbers are used instead. "1" indicates LOS A, "2" indicates LOS B, "3" indicates LOS C, "4" indicates LOS D, "5" indicates LOS E, and "6" indicates LOS F.