Payload Meter III - Section 60 OM6009 1/04 Page 60-26 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 AND 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 com- pressed .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 lowest 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. 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. CSV stands for Comma Separated Value. This is an ASCII text file format that allows spreadsheet appli- cations like Excel and Lotus 123 to import data eas- ily. 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. 5.
Press the CREATE GRAPH button. The graph will be displayed based on the query set- tings from the Payload Summary screen. The graph can be customized and printed.