Click the Copy button present in the "Other" button in Simulation Results window to copy the simulation results to the clipboard. (Highlighted in yellow in the image below)
The results data for this simulation are copied to the clipboard in a format that you can paste into a spreadsheet application like Microsoft Excel (tab-delimited text). The arrangement of the data is described in the table below. The locations described assume that you paste the data beginning with cell A1. Each piece of result data generally appears in the same cell location, even for different simulations or different HOMER models. This makes it easier for other spreadsheets to reference the pasted results data by referencing specific cells.
Spreadsheet Row Number |
Contents |
1 |
Title, description, filename |
2 |
Project notes |
3 |
Total NPC |
4 |
LCOE |
6-9 |
System architecture |
11-12 |
Sensitivity case parameters |
14-20 |
Cost summary table (Net present dollars) |
22-28 |
Cost summary table (Annualized dollars) |
30-32 |
Electrical summary |
34-36 |
Other outputs |
38-40 |
Thermal summary |
42-46 |
Fuel summary |
48-50 |
Emissions summary |
60-89 |
Generators |
90-109 |
PVs |
130-159 |
Batteries |
160-179 |
Converter |
180-199 |
Boiler |
290-309 |
Utility |
310-319 |
Thermal load controller |