Skip to main content

How to Auto-Format and Print Parameter List with Professional Header and Organized Layout? - Knowledgebase / Toolkit - Power Generation

How to Auto-Format and Print Parameter List with Professional Header and Organized Layout?

Authors list

This guide will walk you through the process of auto-formatting your parameter list to create a polished, easy-to-read, printable document complete with a header (including your project name and current date/time) and page numbers. By following these steps, you’ll be able to generate a formatted, printable parameter list with just a few clicks.


By following these steps, you’ll save time and ensure your parameter list is presented in a professional and readable format.


Step-by-Step Instructions

  1. Export Your Parameter List

    1. Open the Toolkit application.

    2. Open an afore saved parameter file (*.wset) wset_export.png

      1. In Generic Editor: double-click of the file in its folder where it is stored.

      2. In Offline-View: Open the appropriate .wtool-file in ToolKit first. Then "Settings" -> "Edit", and select the wset file.

    3. Export your easYgen-3000XT configuration/parameter list in a hierarchical structure.

      OT01.jpg

    4. Select view Hierarchical. or Tabular. Select directory where to save and then "ExportOT02.jpg

    5. Save the exported file as a CSV file. This file will contain all the parameters you’ll use for formatting.

  2. Open the Formatting Tool

    1. Locate and open the provided “easYgen_settings_formatting.xlsm” file.

    2. If prompted by Excel, enable macros. (Macros are necessary for automating the formatting process.)

  3. Import Your Parameter Data

    1. Go to the “Controls” sheet within the Excel workbook.

    2. Click the button labeled “Import HTML file to Settings”.

      • A file explorer window will open.

      • Use this window to select the HTML file containing your easYgen settings extract from Toolkit.

    3. Once the file is selected, its content will be copied into the “Settings” sheet.

  4. Format the Data

    1. Return to the “Controls” sheet.

    2. Click the button labeled “Format Settings sheet”.

      • The content of the “Settings” sheet will be automatically edited and formatted.

    3. The result will be a clean, printable format with the following elements:

      • table with formatted data.

      • header that includes:

        • The project title.

        • The current date and time.

      • footer with page numbering.

  5. Preview and Print

    1. Once the formatting process is complete, you can:

      • Inspect the Print Preview to verify the layout.

      • Print the document directly.

    2. The formatted document will feature:

      • A professional look.

      • Well-organized data.

      • Easily identifiable page numbers and a project-specific header.


NOTE: Do not change the name of “Settings” sheet, as this sheet is referenced in prepared macros via its name.