How You Graph Seven or More CPUs › Step 3: Create a Single CSV File

Step 3: Create a Single CSV File

You need to append the CPU data for the same collection interval to the existing record, and keep the order of the CPUs in each record.

To create a single CSV file

1. Edit the first file.
2. Open the second file.
3. Append the CPU ids to the end of the “Time” record.
4. Append the CPU data for each collection interval to the end of the record for that collection interval.
5. Repeat for any additional files.
6. Insert a second comma after “Time” in the time record.
7. Edit the format of the time fields for best display in the Excel graph. Change the quoted string to comma-separated values.

   For example, change

   "15-JAN-2008 13:00"
   To
   15-JAN-2008,13:00

For example, for two files with a total of 12 CPUs