If you use the Running Difference command on your raw data, the raw data will be destroyed in the process of calculating the running difference. We recommend that you avoid this problem by creating an extra field to hold the running difference. You can use the Morph Field Dialog to copy the data into the field, and then use the Running Difference command without disturbing the original raw data.
Let’s take a look at how to calculate your gas mileage using the Running Difference command. Start with empty Range and MPG fields, then use the Morph Field Dialog to copy the Odometer field into the Range field.
Now use the Running Difference command (right-click on the field name and select Math>Running Difference) to convert the odometer readings into the distance between fillups.
Now we’ll calculate the actual miles per gallon. Move to the MPG field and use the Morph Field Dialog to calculate the formula Range/Gallons. Presto, the miles per gallon between each fill-up is calculated.
You’ll need to repeat these steps periodically as you continue to drive. This process can be automated with a procedure.
field Range formulafill Odometer runningdifference field MPG formulafill Range/Gallons
See Procedures for more information on creating procedures.
|10.0||No Change||Carried over from Panorama 6.0|