After running a simulation, you might want to see the number of work orders created vs the number of work orders closed.

  1.  First, you must make sure that you have a successful simulation

  2. Download the Raw Log 
  3. Open the downloaded file in Excel
    1. If the file does not open in Excel with readable data (some data is changed to dates etc), please use this article on how to open the file without Excel automatically formatting the data: How to open a CSV file in Excel

  4. Click on Insert in the ribbon, then click PivotTable
  5. In the window that appears, click OK
  6. You are now sent to a new sheet called "Sheet1" - when you click on the PivotTable, the PivotTable Fields appear on the right hand side
    1. Drag & drop "previousState" to both Filters and Values fields
    2. Drag & drop "weatherYear" into the Columns field
    3. Drag & drop "fixableType" into the Rows field


  7. Once you have finished the fields, you will have to click on the "previousState" filter and search for "Created" - if two filters appear, select both of them and click OK



  8. The listed values in the output will display the number of work orders which were CREATED


Since we are now only displaying the number of CREATED work orders, we will have to create another PivotTable on the same page to view all CLOSED work orders:


  1. Go to the RawLog sheet

  2. Go to Insert in the ribbon bar, and then select the PivotTable

  3. Now click on "Existing worksheet", then click on the "Sheet1" and select a cell to insert the PivotTable
  4. Now we need to find all the CREATED work orders - this is done by
    1. Drag & drop "currentState" into both Filters and Values fields
    2. Drag & drop "weatherYear" into the Columns field
    3. Drag & drop "fixableType" into the Rows field

  5. Once you have finished the fields, you will have to click on the "currentState" filter and search for "Closed" - if two filters appear, select both of them and click OK

  6. The listed values in the output will display the number of work orders which were CLOSED; meaning they were completed


You can now compare the number of CREATED work orders vs the number of CLOSED work orders by year.