Overview
The Energy Source Visualization tool creates interactive charts showing how different energy sources contribute to thermal loads over time. This tool is ideal for analyzing multi-year energy system performance, comparing different equipment operation patterns, and understanding the relative contribution of various energy sources.
Template Download
📥 Download Excel Template
Excel File Structure
Your Excel file must contain two sheets:
- Config - Defines the energy sources/series to visualize with these columns:
- Series_Name: Column name in Hourly_Data sheet (e.g., "Boiler_Output")
- Display_Name: Label shown in chart legend (e.g., "Boiler")
- Color: Hex color code for the series (e.g., "#FF6B6B")
- Category: Group name for organizing sources (e.g., "Heat_Supply", "Cooling_Supply")
- Output_Unit: Unit for display (e.g., "kWh", "MMBtu")
- Hourly_Data - Contains timestamped energy data with these columns:
- Timestamp: Date/time in Excel format (must be chronological)
- Series columns: One column per Series_Name from Config sheet with hourly values
Key Features
- Multiple Granularities: View data as annual totals, monthly profiles, or hourly time series
- Multi-Year Support: Analyze data across multiple years with selective year filtering
- Interactive Hourly View: Zoom and pan through hourly data with automatic resampling for performance
- Category Organization: Group related energy sources for clearer analysis
- Summary Tables: View annual percentages showing relative contribution of each source
Usage Instructions
- Step 1: Download the Excel template and populate it with your data
- Step 2: Upload your completed Excel file using the upload zone below
- Step 3: Select visualization granularity (Annual, Monthly, or Hourly)
- Step 4: Choose which years to display using the checkboxes
- Step 5: For hourly view, use Quick Zoom buttons or custom date range for detailed analysis
- Step 6: Export chart as PNG or download summary table as CSV
Tips for Best Results
- Use consistent positive/negative values to show energy production vs consumption
- Choose contrasting colors for better visual distinction between sources
- Group related sources into logical categories for easier interpretation
- For hourly data, start with annual or monthly view before diving into hourly details
- The tool automatically handles multi-year datasets and creates separate years from continuous timestamps