Demonstration Files Page
Kristopher Kilsby portrait

Kristopher Kilsby

MSc Computing Science | Excel Automation | Full-stack Development | Data Analysis

kriskilsby@gmail.com | LinkedIn

Welcome

Explore some key Excel automation examples — from employee resource reporting, to an advanced energy analysis modelling tool.

Demonstration Files & Downloadables

PV Demand and Generation Dashboard

Advanced Excel | VBA Automation | Data Analysis
Electrical Engineering, Norfolk, UK

An advanced Excel dashboard developed to analyse electricity demand, solar PV generation, and battery storage scenarios across multiple school buildings. The workbook combines VBA automation, dynamic formulas, and interactive reporting to support operational and energy efficiency analysis.

Users can import hourly demand and generation datasets, filter by school, month, or academic period, and simulate the effect of battery storage on peak demand and energy costs through interactive dashboard visualisations.

Key Features
  • VBA-driven data import reset tools
  • Interactive demand and generation dashboard
  • Battery storage and load shifting simulations
  • Seasonal and operational filtering
  • Energy cost and peak demand analysis
Demand & Generation Dashboard

A demonstration Excel workbook for analysing demand and generation data, including advanced formula and VBA.

Download provided as a ZIP archive due to the workbook containing VBA macros.

Download Workbook

This workbook is designed for Microsoft 365 and uses modern Excel functions and calculations. Some features may not operate correctly in older versions of Microsoft Excel.

Business Estates Resources Report

Advanced Excel | VBA Automation | Resource Reporting
Estates & Facilities Reporting, Norfolk, UK

An Excel-based operational reporting dashboard developed to analyse staff resource allocation, maintenance activity, and operational workload across multiple school buildings and business groups.

The workbook combines VBA automation, dynamic formulas, and structured reporting tools to support both internal management analysis and simplified client-facing reporting.

Key Features
  • VBA-driven data reset and report configuration tools
  • Interactive dashboard with Taskcode and building-level reporting
  • Automated SUMIFS-based resource calculations
  • Dynamic helper columns for validation and data preparation
  • Internal and client-facing dashboard reporting modes
  • Resources year-to-date operational workload analysis
Resources Dashboard

A demonstration Excel workbook for analysing staff resources output and operational workload, including advanced formula and VBA.

Download provided as a ZIP archive due to the workbook containing VBA macros.

Download Workbook

This workbook is designed for Microsoft 365 and uses modern Excel functions and calculations. Some features may not operate correctly in older versions of Microsoft Excel.