Excel Help please

nikki702

Help me please I dont know how to calculatate the volume of traffic does any of you know? i managed the rest and am totally stuck :eek:

Thanks

Dave_C_2

Somebody somewhere is charging motorists over £8000 a day.

Why do you need to know?

Dave

nikki702

I just needed to know the calculation would be for mondays volume of traffic, I dont know if I need to just add the cars, lorries and motorbikes together for that day?

Its for an IT course I am doing and I have done all of my tasks but now I am stuck! lol

gonzo127

yes i would suggest its just a basic =sum()

paddyrg

=sum(b9,c9,d9) ?? I doubt they actially want the cubic volume which would indeed be harder ;-)

Dave_C_2

nikki702 wrote: »

I just needed to know the calculation would be for mondays volume of traffic, I dont know if I need to just add the cars, lorries and motorbikes together for that day?

Its for an IT course I am doing and I have done all of my tasks but now I am stuck! lol

In which case it's a simple sum.
In Mondays Volume of traffic, use =SUM(B10:D10) replace B10 with the cell containing Mondays Cars and D10 with Monday's Motor Bikes.

If you are happy. now just click and drag the fill handle to copy the formula to the other days. Double click the fill handle will also work.

Dave

LucianH

According to wikipedia (so it must be right):

Annual average daily traffic, abbreviated AADT, is a measure used primarily in transportation planning and transportation engineering. It is the total volume of vehicle traffic of a highway or road for a year divided by 365 days. AADT is a useful and simple measurement of how busy the road is. It is sometimes incorrectly reported as "average annual daily traffic".

So, although the sum all the vehicles for each day as mentioned in the previous thread, will give you the volume for each day, I suggest that you should also sum all the number of vehicles for the 7 days and divide by 7 to give an average daily taffic volume (perhaps represented as "Weekly Average Daily Traffic")