This simple post processing utility may be useful when doing parametric analyses. It takes a CSV (comma separated values file) and performs some simple statistics. It is a very small application with no interface. It is typically executed from the command line.
- Open a DOS command prompt window (Start Programs Accessories Command Prompt)
- Change to the directory where EnergyPlus is installed (modify the commands below if you did not install EnergyPlus in the default install path):
C:
CD \<root folder>\
- Change to the specific folder for the coefficient conversion applications:
CD PostProcess
- Run the program:
CSVproc
Where is the name of a CSV file, including extension. There is a simple readme.txt file in the folder. The program performs some simple statistics on each column and creates a new file with the same name without extension and -PROC.CSV added to the name.
The statistics performed on each column are:
SUM
MAX
MIN
AVERAGE
COUNT
COUNTIF > 0
COUNTIF > 5
COUNTIF > 10
COUNTIF > 15
COUNTIF > 20
COUNTIF > 25
COUNTIF > 30
COUNTIF > 35
COUNTIF > 40
COUNTIF > 45
COUNTIF > 50
COUNTIF > 55
COUNTIF > 60
COUNTIF > 65
COUNTIF > 70
COUNTIF > 75
COUNTIF > 80
COUNTIF > 85
COUNTIF > 90
COUNTIF > 95
COUNTIF > 100
COUNTIF = 1
COUNTIF < 19.9
COUNTIF > 24.0
Obviously, not all statistics are relevant for every output report variable. The average is based on the sum divided by the number of non-blank rows. The average is not based on the length of time for that timestep. Due to this, CSVproc is best suited for an hourly output file.
Source code is available upon request from jglazer@gard.com.
CSVproc[LINK]
This simple post processing utility may be useful when doing parametric analyses. It takes a CSV (comma separated values file) and performs some simple statistics. It is a very small application with no interface. It is typically executed from the command line.
CSVproc
Where is the name of a CSV file, including extension. There is a simple readme.txt file in the folder. The program performs some simple statistics on each column and creates a new file with the same name without extension and -PROC.CSV added to the name.
The statistics performed on each column are:
SUM
MAX
MIN
AVERAGE
COUNT
COUNTIF > 0
COUNTIF > 5
COUNTIF > 10
COUNTIF > 15
COUNTIF > 20
COUNTIF > 25
COUNTIF > 30
COUNTIF > 35
COUNTIF > 40
COUNTIF > 45
COUNTIF > 50
COUNTIF > 55
COUNTIF > 60
COUNTIF > 65
COUNTIF > 70
COUNTIF > 75
COUNTIF > 80
COUNTIF > 85
COUNTIF > 90
COUNTIF > 95
COUNTIF > 100
COUNTIF = 1
COUNTIF < 19.9
COUNTIF > 24.0
Obviously, not all statistics are relevant for every output report variable. The average is based on the sum divided by the number of non-blank rows. The average is not based on the length of time for that timestep. Due to this, CSVproc is best suited for an hourly output file.
Source code is available upon request from jglazer@gard.com.
Documentation content copyright © 1996-2014 The Board of Trustees of the University of Illinois and the Regents of the University of California through the Ernest Orlando Lawrence Berkeley National Laboratory. All rights reserved. EnergyPlus is a trademark of the US Department of Energy.
This documentation is made available under the EnergyPlus Open Source License v1.0.