basictypeuser
Technical User
Hi All;
Hope someone could help with either a function or a macro to help speed my data crunch. Here is my example.
The following are each in a column. Bus number, miles traveled, date fueled, qty of fuel. I have alot of data which so far I have broke down into months. I am trying to figure miles per gallon on a monthly basis for each vehicle, then a miles per gallon average for all. So far I am doing this on each vehicle. I have 232 buses to perform this on.
some data examples attached.
Bus Number Accum Mileage Date Quantity
2201 191 2/15/2005 122
2201 191 2/16/2005 118.3
2201 203 2/18/2005 122.5
2201 199 2/18/2005 110.3
2201 89 2/25/2005 77.7
2201 169 2/26/2005 112.8
2201 198 2/27/2005 131.9
2201 191 2/28/2005 135
2202 192 2/15/2005 144.4
2202 196 2/16/2005 150.9
2202 196 2/17/2005 142.3
2202 206 2/18/2005 136.6
2202 205 2/19/2005 146.5
2202 197 2/20/2005 128.5
2202 199 2/21/2005 114.7
2202 46 2/22/2005 43.6
Any help would be appreciated.
Hope someone could help with either a function or a macro to help speed my data crunch. Here is my example.
The following are each in a column. Bus number, miles traveled, date fueled, qty of fuel. I have alot of data which so far I have broke down into months. I am trying to figure miles per gallon on a monthly basis for each vehicle, then a miles per gallon average for all. So far I am doing this on each vehicle. I have 232 buses to perform this on.
some data examples attached.
Bus Number Accum Mileage Date Quantity
2201 191 2/15/2005 122
2201 191 2/16/2005 118.3
2201 203 2/18/2005 122.5
2201 199 2/18/2005 110.3
2201 89 2/25/2005 77.7
2201 169 2/26/2005 112.8
2201 198 2/27/2005 131.9
2201 191 2/28/2005 135
2202 192 2/15/2005 144.4
2202 196 2/16/2005 150.9
2202 196 2/17/2005 142.3
2202 206 2/18/2005 136.6
2202 205 2/19/2005 146.5
2202 197 2/20/2005 128.5
2202 199 2/21/2005 114.7
2202 46 2/22/2005 43.6
Any help would be appreciated.