Viewing entries in
Excel

Large IT SLA and KPI Dashboard

Large IT SLA and KPI Dashboard

An IT Service Management (ITSM) Dashboard built for a global investment bank using Microsoft Excel and VBA to report on SLA and KPI performance.

It used a large data set of 92 data fields to  calculate 4 SLAs, 14 KPIs and 46 measures, presented in a variety of graphs and blocks.  There were 23 filters enabling the user to interrogate the data and isolate the cause of any issue.

Project Portfolio Management and Workflow

Project Portfolio Management and Workflow

A Project Portfolio Management and Workflow application built for a global pharmaceuticals company using Microsoft Excel with VBA and delivered via SharePoint.

This one is incredibly complicated and specific, and demonstrates just how much is possible with Excel and VBA.

Church Accounts

Church Accounts

A financial management solution written for a local church to manage a particular set of accounts receivable and payable. The solution was based on Excel VBA and User Forms and featured: extensive VBA code to enforce the process and validate input

There are lots of good accounting packages out there and we don't recommend managing all of your accounts with Excel, but there are occasions when a spreadsheet is the most cost-effective solution to some of your finance challenges.

Complex Calculator – Impact of IT Downtime

Complex Calculator – Impact of IT Downtime

An outage impact calculation system built for a UK Insurance company using Microsoft Excel.  The solution included a user-driven model front-end and calculations from detailed application performance data extracted from a dedicated, third party system.

In this example, an Excel spreadsheet model is used to turn technical data into important business information.

Resource Tracking and Forecasting

Resource Tracking and Forecasting

A resource tracking and forecasting system built for a global IT outsource company using Microsoft Excel and VBA, delivered via SharePoint.  The solution included dynamic filtering to control user input forms, conditional format icons and graphs of actuals and forecast versus budget.

This spreadsheet shows how complicated requirements and processes can be boiled down into a tool that is relatively easy to use.

IT Service Management Dashboard

IT Service Management Dashboard

An IT Service Management (ITSM) dashboard built for an international Commercial Insurance Company using Microsoft Excel and VBA code.  The solution took data from the client’s ITSM ticket system, calculated performance against SLAs and presented the results in a dynamic dashboard. 

Vacation & Training Tracker

Vacation & Training Tracker

A vacation and training tracker system built for a global IT outsourcing company using Microsoft Excel and delivered via SharePoint.  The solution included a data entry sheet, a calendar display and a tracking report.

This is a simple worksheet that is easy to use and support, and has an elegant look and feel.

Department Budget Tracking Spreadsheet

Department Budget Tracking Spreadsheet

A budget tracking system built for a large UK Insurance company using Microsoft Excel.  The solution included combination graphs, conditional formatting and icons.

A team or department budget typically has a number of components, and understanding how each is performing can be difficult.

Asset Depreciation & Refresh Model

Asset Depreciation & Refresh Model

An asset ageing and replacement system built for a large UK Insurance company using Excel.  The solution included a replacement model based on asset age used to create seven year CapEx and Depreciation Budgets and Ageing Summary reports.

This solution demonstrates how a number of modelling tables, combined with purchase information can be used to create accurate year on year budgets.

Task Planning Calendar

Task Planning Calendar

A task planning and scheduling system built for a UK financial services company using Microsoft Excel VBA.  The solution included calendar display, data entry form, search and help facilities.  It was more than just a shared calendar: it used a library of information about tasks to calculate the likely time required and managed scheduling conflicts.

It illustrates a situation where the very implementation of a tool forces adherence to a process, thereby driving consistency and savings.

 

Traditional Service Level Reporting

Traditional Service Level Reporting

A Service Level Agreement (SLA) reporting system built for an outsourced service provider using Microsoft Excel.  The solution included extensive conditional formatting to highlight SLA breaches and VBA code to perform complex calculations.  

Although the design is very traditional – old fashioned even – it is a prime example of Excel being used to bridge the gap between a system’s capabilities and the users’ requirements.

Staff Tracking and Organisation Chart

Staff Tracking and Organisation Chart

A staff resource tracking system built for a large multi-national bank using Microsoft Excel and VBA.  The solution included details required by a number of different departments and a facility to create organisation chart data that could be uploaded into Microsoft Visio. 

This example serves to illustrate that significant time savings and data quality improvements can be made with quite simple Excel projects.