I have 24 hours Road Survey Data in different direction and different Vehicles and these datas at 15 min intervals and these datas are in excel sheet . I want to sum each hour's values eg. (07.00-07.15),(07.15-07.30),(07.30-07-45),(07.45-08.00) I want to add values for these time periods.Then I want to proceed and add all values for the next hour, i.e. between 07.00 and 08.00, and i need Peak Hour Value,Total Hours and Pie & Line chart .
I need these calculations are using vba programming.For example, THIS IS MY DATA FORMAT
<tbody>
</tbody>T.P.V=Total Passenger Vehicles(sum of car+t.w+auto+minibus+bus)
T.G.V=Total Goods Vehicles (sum of 3w Goods+lcv+hcv+mav)
T.S.V=Total Slow Moving Vehicles(cycle+cycleRickshaw+others)
T.V=Total Vehicles(sum of T.P.V+T.G.V+T.S.V)
<o> </o>
HourlyValue : sum of 15 minutes<o></o>
<o> </o>
Peak Hour :Which time the large amount of vehicles will come ,that time is peakhour<o></o>
<o> </o>
Total Hours : sum of every one hour value<o></o>
Every Direction has like this .How to generate these coding in VBA?Can anyone please help?Because i am new for VBA.Thanks
I need these calculations are using vba programming.For example, THIS IS MY DATA FORMAT
time | car | twowheeler | auto | minibus | bus | 3wgoods | lcv | hcv | mav | cycle | c.ricksaw | others | T.P.V | T.G.V | T.S.V | T.V | T.V(PCU) |
7.00-7.15 | 7 | 8 | 9 | 3 | 5 | 45 | 5 | 12 | 0 | 8 | 4 | 0 | |||||
7.15-7.30 | 12 | 6 | 8 | 15 | 14 | 16 | 13 | 8 | 9 | 5 | 2 | 6 | |||||
7.30-7.45 | 6 | 2 | 3 | 8 | 7 | 9 | 5 | 6 | 12 | 3 | 2 | 3 | |||||
7.45-8.00 | 7 | 2 | 18 | 17 | 25 | 23 | 22 | 7 | 6 | 15 | 7 | 12 | |||||
8.00-8.15 | 4 | 2 | 9 | 6 | 8 | 7 | 1 | 2 | 6 | 8 | 3 | 4 | |||||
8.15-8.30 | 7 | 8 | 9 | 4 | 5 | 5 | 15 | 4 | 2 | 45 | 2 | 2 | |||||
8.30-8.45 | 7 | 8 | 9 | 4 | 5 | 61 | 2 | 3 | 6 | 9 | 7 | 4 | |||||
8.45-9.00 | 14 | 15 | 16 | 17 | 18 | 19 | 12 | 13 | 14 | 15 | 19 | 14 | |||||
up to | |||||||||||||||||
text day | |||||||||||||||||
morning | |||||||||||||||||
5.00-5.15 | 14 | 25 | 14 | 1 | 4 | 14 | 48 | 17 | 1 | 98 | 14 | ||||||
5.15-5.30 | 12 | 14 | 15 | 17 | 18 | 189 | 16 | 14 | 12 | 15 | 187 | 7 | |||||
5.30-5.45 | 1 | 2 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 914 | 1 | ||||||
5.45-6.00 | 1 | 4 | 5 | 2 | 8 | 6 | 9 | 7 | 14 | 5 | 8 | 96 | |||||
6.00-6.15 | 12 | 14 | 17 | 18 | 19 | 16 | 15 | 12 | 13 | 11 | 14 | 17 | |||||
6.15-6.30 | 54 | 58 | 49 | 42 | 26 | 78 | 76 | 89 | 46 | 43 | 47 | 58 | |||||
6.30-6.45 | 12 | 13 | 14 | 15 | 156 | 14 | 17 | 18 | 19 | 14 | 15 | 16 | |||||
6.45-7.00 | 12 | 13 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | |||||
total | sum of | sum of | sum of | ||||||||||||||
24 hours | cars | two wheeler | .... | ..... | .... | ..... | .... | .... | .... | ... | ....... | others |
<tbody>
</tbody>
T.G.V=Total Goods Vehicles (sum of 3w Goods+lcv+hcv+mav)
T.S.V=Total Slow Moving Vehicles(cycle+cycleRickshaw+others)
T.V=Total Vehicles(sum of T.P.V+T.G.V+T.S.V)
<o> </o>
HourlyValue : sum of 15 minutes<o></o>
<o> </o>
Peak Hour :Which time the large amount of vehicles will come ,that time is peakhour<o></o>
<o> </o>
Total Hours : sum of every one hour value<o></o>
Every Direction has like this .How to generate these coding in VBA?Can anyone please help?Because i am new for VBA.Thanks