Excel spreadsheet to estimate the utility costs of several services for chemical processes.
This excel spreadsheet can be used to calculate the utility costs of a variety of services. The formulas and coefficients were taken from the report by Ulrich and Vasudevan
The excel spreadsheet has 5 tabs: Input, coefficientes, CEPCI, Utility costs and Natural gas price.
1. Input: Here you enter the requested information for the utility you wan to estimate the cost. Check the range of the parameters that you should include in the value column
2. Coefficients: These are the values reported by the authors in Table 1 of the document.
3. CEPCI (Chemical Engineering Plant Cost Index): This index is published monthly by the Magazine of Chemical Engineering.
4. Utility Costs: Here you can see the formula to estimate the utility cost using as parameter the coefficients, CEPCI and fuel price. Here you find the utility cost based on your inputs.
5. Natural gas Price: Data of the market price for natural gas extracted from Eurostat
You can add another fuel (e.g., diesel, nuclear, coal, oil,etc) to estimate the price of your utility.