Need to create a class similar to that in
VEH-19 to generate Statistics based on Servicing
Desired stats are
- Total Mileage recorded
- Total Servicing Cost
- Number of Services/repairs
- Total 'fault' cost
- Total 'non-fault' cost
- Number of fault repairs
- Number of non-fault repairs
- Garage stats
Activity
2013-11-02 14:32:12
2013-11-02 14:43:14
- Average Cost Per Mile (Servicing)
- Average CPM Fault (Servicing)
- Average CPM Non-Fault (Servicing)
- Average Service Cost
- Average Service Cost (fault)
- Average Service Cost (non-fault)
2013-11-02 16:24:02
All stats have datasource 'S'
|StatType|Stat|Modifier|
|MonMiles|Miles recorded||
|MonCn|Service count||
|MonCost|Servicing Cost||
|MonFaultCo|Servicing Cost (Faults)||
|MonNFaultC|Servicing Cost (Non Faults)||
|MonFaultCn|Servicing Count (Faults)||
|MnNFaultCn|Servicing Count (Non Faults)||
|MonAvgCPM|Average Cost Per Mile||
|MonAvgFCPM|Average Cost Per Mile (Faults)||
|MonAvgNFCP|Average Cost Per Mile (Non Faults)||
|MonAvgCost|Average Servicing Cost||
|MonAvgFCs|Average Servicing Cost (Faults)||
|MonAvgNFCs|Average Servicing Cost (Non Faults)||
|MonGarages|Garage Use Count|Garage Name|
To make life easier when running queries that use Fuel and Servicing, have decided to standardise the Stat-Type between Fuellog and Servicelog stats, so will be altering the stat types listed in VEH-19 to match those used above
2013-11-02 16:35:52
2013-11-02 16:35:59
2013-11-02 16:35:59
2013-11-02 16:36:05