Cookie Notice

This website uses cookies to ensure you get the best experience on our website. By using this site you agree to the use of cookies. We also use Google Analytics for statistical purposes. By selecting "Accept" you agree to the use of cookies by the Google web analysis service. Learn more about our Data Protection Policies.
Excel Report on Economic Evaluation

Excel Report on Economic Evaluation

Navigation:

Exporting the Variant Comparison (Excel)

The data of the economic evaluation and the calculation can be output in a Microsoft Excel document. This process is called Export variant comparison.

In the Project explorer, first select a Variant comparison node. This activates the export function, which is otherwise grayed out. Then you call the function Export variant comparison via the Project ribbon → Export group with the split button Excel.
Alternatively, you can make the selection in the context menu of an element in the Project explorer (right click → Bericht erzeugen Generate report → Export variant comparison.

If there are several Variant comparison nodes in the project, you can export the variants for each individual Variant comparison node. To do this, use the menu entries (see the following figure).

The Variant comparison export is always created from the perspective of an actor (Stakeholder). If there are several Stakeholders in the project, a selection appears in the dialog for saving the Variant comparison export. Select the Stakeholder for which the Variant comparison export is to be executed (see the following figure).

The export dialog after creating the Excel file can be seen here.

Content and Form of the Exported Variant Comparison Calculation

The economic evaluation data for the selected Variant comparison node and all included variants are output in an XLSX document as a multi-sheet workbook. The worksheets contain tables, bar charts, and line charts.

The results of the economic efficiency comparison can be viewed in more detail in the Excel export than in the Variant comparison module, because each of the selected periods can be viewed there. The formulas for calculating the economic results are displayed by clicking on the respective cell.

The following overview lists the individual worksheets and their parts.

  • Economic evaluation
    • Table
      • Investment cost
      • Depreciation
      • Operation cost (w/o Energy)
      • Operation revenues (w/o Energy)
      • Energy cost
      • Energy revenue
      • External finance
      • Cashflow
      • Net present value
      • Dynamic payback period
      • Internal rate of return
    • Diagrams
      • Dynamic payback period
      • Cumulated present value
  • Cost and Revenue
    • Table
      • Energy cost and Energy revenue, each broken down according to the different energy sources (limited to 40 lines for each energy form; if there are more component parts, the component parts of all components are first aggregated. If this is not enough, the residual components are then summarized as Remaining components.)
      • Operating cost (w/o Energy) including Costs for operating resources
      • Operating revenues (w/o Energy) including Revenues for operating resources
    • Diagram
      • Costs and revenues, broken down according to the forms of energy and Operating cost/revenues
  • One worksheet per variant with annually broken down data (in table form)
    • Economic evaluation
    • Investment costs
    • Depreciation
    • External finance
    • Energy costs
    • Operating costs (w/o Energy), including, among other things, Costs for operating resources (Miscellaneous costs)
    • Energy revenues
    • Operating revenues (w/o Energy), including, among other things, Revenues for operating resources (Miscellaneous revenues)
    • CO2 emissions
    • Primary energy use
    • Demand, grid feed-in, and storage charging for the energy forms Electricity, Fuel, Heat, Cooling, Steam, Steam mass flow rate, Compressed air  (for the latter, additionally sink)
    • Supply, grid purchase, and storage discharging for the energy forms Electricity, Fuel, Heat, Cooling, Steam, Steam mass flow rate, Compressed air (for the latter, additionally source)
  • Equipment:
    • Operating hours, Full load hours, and Starts, in tabular form for each plant, e.g., boiler (oil, gas, pellets), district heating supplier
  • One worksheet for each form of energy (Electricity, Fuel, Heat, Cooling, Steam, compressed Air), in tabular form and broken down in the diagram according to variants
  • Component Types

The following slider shows examples of individual worksheets with their parts.

Economic Evaluation
Economic Evaluation

Economic Evaluation

Variant 1

Variant 1

Heat

Heat

Economic EvaluationVariant 1Heat

Variant Comparison Calculation Export Settings

The paths to the storage locations of the template for the Excel file, the configuration file, and the Excel file to be output can be found under Options → Variant comparison → Options for export (to be invoked in the Extras ribbon in the Settings group). You can change these options (see the illustrations in the following slider).

Template

Configuration

Output

The Variant comparison export always takes place for the selected Variant comparison node and all included variants from the point of view of one stakeholder. No further settings are required for the Variant comparison export.

Back To Top