Hourly Traffic count interpolation error

There is an error interpolating traffic counts for hours with no data entry 
when at least one previous hour and one later hour do have data entry
Example: capture traffic counts for two 10 minute periods 

Capture Traffic count weekday 8:00-8:10 Commercial (5 each)
Capture Traffic count weekday 20:00-20:10 Commercial (8 each)

Thus for the hour of 8:00 to 9:00 the Traffic count weekday on Commercial 5 
/10mins * 60mins = 30
and for the hour of 20:00 to 21:00 the Traffic count weekday on Commercial 
should be 8 /10mins * 60mins = 48

Create Traffic flow report 

The report shows
8:00 to 9:00 Commercial 30 - this is correct
20:00 to 21:00 Commercial  48 - this is correct
for the intermediate hours the calculation should interpolate
this would give (30 + 48)/2 for each intermediate hour = 39
This is shown correctly for hours 9 to 18 but hour 19 shows 43.5 and should 
also show 39 (double interpolation in last hour??)

Original issue reported on code.google.com by jarogers...@gmail.com on 19 Apr 2012 at 2:23

Attachments:

[Interpolation error.docx](https://storage.googleapis.com/google-code-attachments/tamt/issue-79/comment-0/Interpolation error.docx)

hiten4github / tamt

Hourly Traffic count interpolation error #79