Redesign HVAC Commissioning Report Templates

HVAC Commissioning Report Template Redesign Brief
Objective
Redesign multiple HVAC commissioning report templates to improve data logging efficiency, standardize presentation, and prevent user errors while maintaining professional PDF output.


Key Requirements
1. Design & Visual Consistency
• Unified visual language across all reports (consistent colour scheme, typography, font sizes)
• Professional, cohesive aesthetic that reflects industry standards
• Modernized layout while retaining all original data sections
• Information can be reorganized/presented differently, but no data loss
2. Functionality & Automation
• Formulas: Auto-calculate totals, averages, and derived values
• Conditional Formatting: Visual indicators highlighting sections requiring data entry; auto-clear when populated
• Auto-population:
• Current dates
• Page numbers
• Sequential numbering (e.g., report versions)
• Redundant information on new tabs (automatically filled on tab creation)
• Macro Automation: Generate reports based on keyword triggers
3. Data Protection & Integrity
• Worksheet Protection: Prevent users from altering:
• Font sizes
• Row/column deletion or insertion
• General layout modifications
• Locked Cells: Restrict editing to data entry fields only
• PDF Export Control: Ensure printed versions maintain consistent formatting (colours, text, sizing) regardless of user modifications to source file
4. User Experience
• Simplified data entry process (fewer manual steps, reduced errors)
• Clear visual cues for required vs. optional fields
• Intuitive workflow that guides users through commissioning process

Deliverables
• Redesigned master templates (all commissioning reports)
• Protected worksheets with formula automation
• Macro-enabled workbook for report generation
• Print-ready PDF template with locked formatting
• User guide for data entry and report generation