I have developed a tool that makes it much faster to make detailed mapping of all energy consuming components in a building, industry, institution, home, etc. I use the tool for very large and detailed mappings. The tool is focused on electrical components, since these most often represents the largest in numbers, especially in industrial facilities. Other energy types can of cause also be mapped.
The tool is entirely programmed in VBA for Excel, and very few formulas are used in the spreadsheet. Any formulas are written by the VBA and clearly marked. A rather complex menu system with many dialog boxes controls the data-input, including extensive validation of the data.
The small video shows some of the basic functions. It is annotated by “Alex” who lives inside my Mac 🙂
Main characteristics of the tool:
The program launches two tool-bars from which I control all actions.
There are a couple of simple text boxes explaining the tool-bar-buttons.
A single click on a tool-bar-button will format a new mapping-workbook.
The new workbook has four pre-formatted sheets with empty data fields.
Dialog boxes guide me to save the new workbook.
The first sheet will contain all the “global” data that are common to the entire mapping:
The second sheet contains the entire electrical components mapping
The third sheet contains mapping of components that are not electrical (oil, gas, etc.).
The fourth sheet is used for generating report output in diagrams and numbers.
There are tool-bar-buttons for simple line editing purposes:
The main feature of the tool is the three-menu sequence launched from one tool-bar-button. A single menu can also be launched form another button. The correct menu is selected automatically from the current position in the data sheet.
First menu selects the component type and the nominal energy related data:
The second menu selects all the components associations to place, user, metering, etc.:
The third menu selects the operating conditions for the component:
A report sequence can be printed, when all components are registered. After each ‘click’ on the reports-button the print sequence is stepped forward:
Other features that are added to the mapping system: