Optional Equipment - Section 6 OM6008 02/03 Page 6-26 Payload Meter III Creating Graphs The PLMIII software can generate graphs that quickly summarize payload data. These graphs can be customized for printing. Just like the reports, the graphs are generated from the query displayed on the “Payload Summary” screen. From the "Sorting on Time Range" example, the graph that is printed would only contain data from truck 374 during the month of July 2000, from 8:00 AM to 5:00 PM. Exporting Data It is important to carefully select the query data and press the "Query Database & Display" button before creating a graph.
The data from the database can be exported for use with other software applications. The data is selected from the currently displayed query. The exported data can be put into a ".CSV" file or a compressed ".zip" file. 1. From the Payload Summary Screen select the “Graph” button at the bottom. The Histogram Setup screen will display The “.CSV” format allows data to be easily imported into spreadsheet applications and word processing applications. The “.Zip” format allows data to be transferred from one computer to the PDM Software database on another computer. This offers a compact way to transfer data from one computer to another. CSV Export 2. Enter the "Lowest Value".
This will be the low- est payload on the graph. Any payloads less than this value will be summed in the first bar. 3. Enter the "Highest Value". This will be the high- est value on the graph. Payloads over this value will be summed in the last bar. CSV stands for Comma Separated Value. This is an ASCII text file format that allows spreadsheet applications like Excel and Lotus 123 to import data easily. To export the data into a ".csv" file, press the "Export" button at the bottom of the payload sumary screen and select "To CSV". The program will request a filename and location for the file. 4. Enter the "Incremental Change".
This will deter- mine the number of bars and the distance between them. The program limits the number of bars to 20. This allows graphs to fit on the screen and print onto 1 page. 5. Press the “Create Graph” button. The graph will be displayed based on the query settings from the Payload Summary screen. The graph can be customized and printed.