B McAndrew

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • in reply to: Complete traffic count and speed summary reports. #2657

    B McAndrew
    Participant

    Thank you. Changing the local profile for the report got it to work.

    For anyone who might be interested I changed the time filter in the report profile settings. You can change the “Auto-Wrap” option. I changed it to “Aligned days”, this cuts out the half days at the beginning and end of the survey, save that to a file. modify the custom report and set it to use the new profile that was just saved.

    Now whenever that report is used, the new local profile is used and it works nicely.  Such a small thing that I missed.

    Thanks for you help.

     

    in reply to: Complete traffic count and speed summary reports. #2644

    B McAndrew
    Participant

    Thanks for the quick reply

    The look of the report isn’t important as it is used as a means to get information into a database. I’m a code monkey so function comes before appearance.

    Below is the output in Metro Count of the custom report I’ve been working on. It shows the tags I’ve used and their results. Most of the them (near the beginning) are speed statistics and class bins, which work nicely. The last few (51 – 60) are my attempts to get ADT, AWDT, and AAWET (virtual days, week days and weekends). It seems that because the survey started on a Tuesday and ended on a Wednesday I can’t get ADT or AWDT from the tags in the report or even the values for virtual days Tuesday and Wednesday (V1and V2), which I thought I could use to calculate ADT myself.

    7 PR_START.TT = 14:21 Tuesday, 16 December 2014
    8 PR_END.TT = 18:50 Wednesday, 7 January 2015
    9 DA_DIR.TT = East (bound)
    10 FA_nCLSBIN.TT.1 = 108549
    11 FA_pCLSBIN.TT.1 = 91.3
    12 FA_nCLSBIN.TT.2 = 3025
    13 FA_pCLSBIN.TT.2 = 2.5
    14 FA_nCLSBIN.TT.3 = 6113
    15 FA_pCLSBIN.TT.3 = 5.1
    16 FA_nCLSBIN.TT.4 = 451
    17 FA_pCLSBIN.TT.4 = 0.4
    18 FA_nCLSBIN.TT.5 = 145
    19 FA_pCLSBIN.TT.5 = 0.1
    20 FA_nCLSBIN.TT.6 = 287
    21 FA_pCLSBIN.TT.6 = 0.2
    22 FA_nCLSBIN.TT.7 = 136
    23 FA_pCLSBIN.TT.7 = 0.1
    24 FA_nCLSBIN.TT.8 = 16
    25 FA_pCLSBIN.TT.8 = 0.0
    26 FA_nCLSBIN.TT.9 = 94
    27 FA_pCLSBIN.TT.9 = 0.1
    28 FA_nCLSBIN.TT.10 = 20
    29 FA_pCLSBIN.TT.10 = 0.0
    30 FA_nCLSBIN.TT.11 = 0
    31 FA_pCLSBIN.TT.11 = 0.0
    32 FA_nCLSBIN.TT.12 = 0
    33 FA_pCLSBIN.TT.12 = 0.0
    34 FA_nTOT.TT = 118836
    35 FA_nLIMIT0.AX = 60
    36 FA_nLIMIT0.TT = 117654
    37 FA_vMEANEX.TT = 76.3
    38 FA_vMAX.TT = 158.5
    39 FA_vMIN.TT = 19.0
    40 FA_vMEAN.TT = 76.0
    41 FA_vPP.TT = 81.4
    42 FA_vPP.AX = 85
    43 FA_vPP2.TT = 85.3
    44 FA_vPP2.AX = 95
    45 FA_vMEAN.TT = 76.0
    46 FA_vPACE.TT = 65.9
    47 FA_vPACE.AX = 20
    48 FA_nPACE.TT = 109202
    49 FA_VARIANCE.TT = 37.9
    50 FA_STDEV.TT = 6.2
    51 FA_nTOT.V0 = 5581
    52 FA_nTOT.V1 = ##Days?##
    53 FA_nTOT.V2 = ##Days?##
    54 FA_nTOT.V3 = 4553
    55 FA_nTOT.V4 = 5681
    56 FA_nTOT.V5 = 4938
    57 FA_nTOT.V6 = 4390
    58 FA_nTOT.WD = ##Days?##
    59 FA_nTOT.VD = ##Days?##
    60 FA_nTOT.VE = 4664
    If I could get all of that in one report (don’t need 51 – 57) that would give us exactly what we need.

    P.S. I think the custom reports and list are a great idea and have found them very useful so far.

Viewing 2 posts - 1 through 2 (of 2 total)

To improve your browsing experience, this website uses cookies.

Cookies are small text files that enable us to record your website usage in accordance with our privacy policy.
Please confirm if you accept our tracking cookies.