ExcelEnergyTracker

*** Coming soon a 30 second Demo Video on how to set-up and use ExcelEnergyTracker ***

Here's my latest tracker spreadsheet ExcelEnergyTracker which is your Excel based ultimate solution for easily tracking your Gas & Electric energy consumption by simply entering your meter reads and meter read dates in a single place.

STEP 1: SET SEASONAL TARGETS

• Set your seasonal Gas Targets

• Set your seasonal Elec Targets

• See your season targets against actuals

STEP 2: ENTER YOUR METER READINGS

• Select your named meter 

• Enter Meter Read Date

• Enter Meter Reading Value

• See your Energy Units Consumed

• See your Average Daily Units Consumed

STEP 3: VIEW YOUR SUMMARY CHARTS

• See your last 20 meter reads Average Daily Units consumed chart

• See your Month / Year Chart (Choose Year)

• See your estimated Annual Units

• See comparison Actual vs Season Target

• For view for both Gas and Elec fuels

STEP 4: VIEW YOUR SUMMARY DASHBOARDS

• See and compare Month vs Month Year vs Targets Dashboard

• See and compare your All Years Performance vs Targets Dashboard

• See estimated Annual Units consumed to date or Annual Units for year 

• See your Elec / Gas Latest Headlines Dashboard

• See your Top 10 / Bottom 10 Average Daily Units

• See your Elec / Gas Consumption Events Dashboard

• Also there is a separate Average Hourly Consumption Units Calculator

Easy to use and plenty of colour coded Navigation buttons so you can get to different tabs of the
Tracker quickly and easily.

The software is available in English language and is compatible with computers, tablets and networking devices.

Take control of your Energy Consumption with ExcelEnergyTracker today!

How ExcelEnergyTracker Might Help You Cut Costs and Save Money on Bills

This tracker helps you spot where your energy is going—and how to cut back.

• See what’s costing you most: Track electricity and gas separately so you know what’s driving your bills

• Catch expensive habits: Tag events like heating boosts or appliance use to see what’s adding up.

• Set smart targets: Plan your energy use by season and stay within budget.

• Find waste fast: Ranked reads show your highest and lowest usage so you can fix what’s not working.

• Easy to use: Colour-coded buttons and a full guide make it simple—even if you’re not a spreadsheet expert.

Questions and Answers:

(Q) Which version of Microsoft® Excel does ExcelEnergyTracker work in?

(A) This product should work on all versions of Excel from Excel 2007 to Excel 365 (Microsoft 365)

(Q) May I install ExcelEnergyTracker on more than one computer? 

(A) Yes, you are free to install on more than one computer with no restrictions.

(Q) Do I have to pay for any future updates? 

(A) You will be pleased to learn that all updates of ExcelEnergyTracker v1 will be completely free of charge and
will be made available to you as a thank you for being a valued customer

(Q) Are the individual Months and Year Summary Printable? 

(A) Yes the individual summary tabs and dashboard tabs have been set-up to be printable ready for your convenience.

(Q) Does ExcelEnergyTracker have any complex VBA or Pivot Tables to worry about?

(A) It is 100% free of VBA and PivotTables, just simply based on reliable Excel Formulas, Conditional Formatting, Charts and easy to use Sheet Navigation button links to switch between individual months, year and helper sheets.

(Q) Are there helper guides within ExcelEnergyTracker?

(A) Yes you will be provided, as part of the bundle zip file, a 20 page PDF document on how to get yourself up

and running with the tracker.

(Q) Can I use ExcelEnergyTracker on my mobile cell?

(A) Yes, if you have Microsoft OneDrive, you can copy your tracker onto this cloud drive and interact with it

on the go on your mobile phone device.

(Q) Do you provide technical support?

(A) Yes, I am happy to provide this. Please use the contact email below and put ExcelEnergyTrackerv1 as the title in your email subject line.

(Q) How do I access the template After Purchase?

(A) Once you successfully complete the purchase of ExcelEnergyTracker, please message me your email address and I will send you an email to download the zip file which will be named as ExcelEnergyTracker.zip containing these files:

ExcelEnergyTracker v1-Blank.xlsx

This is blank ExcelEnergyTracker template ready for you to set up your own seasonal targets and then enter

your meter readings/reading dates for Elec and Gas Fuels for the current year.

ExcelEnergyTracker v1.xlsx

This is a partially completed sample with a huge 3 years of my personal home energy consumption data
for both Electricity and Gas fuels. You can see the data being used in action within the Tracker and interact

with it and see meter read data entered on the Gas and Elec Meter Reads Input sheet as well as the

Summary Charts and Summary Dashboards. You can use my personal consumption data to show you how

everything fits together as a teaching tool.

ExcelEnergyTracker v1 User Guide.pdf

Full easy-to-use PDF format guidance on how to use ExcelEnergyTracker v1 with plenty of screenshots to guide

you through each part of the product relating to setting up Lookups, how to enter Meter Readings, enter seasonal

targets, the summaries charts and summary dashboards, Top 10 / Bottom 10 meter reads, how to use consumption events. There is also a useful QA section at the end for common questions, tips and tricks.

Please note: this is a digital product and no physical product will be shipped and since this is a digital product there are no returns or refunds. Please contact me (email or message me) if you need any support.

Free Lifetime Future Updates and Support to give you even better value for money

***** All this for only £8.45 *****

Thanks for visiting and have a great day!