Energy Consumption Calculator Spreadsheet

summer winter power consumption

I got  a request from one of my blog reader that he wants a electricity consumption calculator sheet so here are my best ones. You can pick any one from them.

First one can be termed as best for determining the stats for both domestic as well as commercial. I would say it is pretty neat work. Appliances ,lighting ,heating & hot water energy demand and in another sheet you can calc the commercial KWH demand.

home lighting

This spreadsheet is split in two pages one is used to calculate the energy consumption by various devices like bulbs etc during summer and the other in winter. User has to provide information such as qty,appliance power and daily usage and it will automatically calculate the energy requirement.
summer winter power consumption


The sheet is solely created to determine the energy  efficiency of water pumps. You have to fill in following data to get information. Electrical energy consumption (measured or nameplate), run hours etc along with the average unit price in your area. You have to click on image to download the worksheet.pump efficiency


Now this last one is a bit different it allows user to calculate energy in terms of fossil fuel.

fossil fuel consumption calculator

5 Event budget excel templates that you will love

event worksheet

Event management is not a easy task, one has to take care of different things and arrangements. We are providing you some spreadsheets that will lessen your burden a bit at-least related to budget and management.

  • This cool worksheet have three different sheets for comparison of budget projected and actual along with charts. Colorful presentation makes it eye catchy and i would say one must try it. You can edit the headings and sub-headings after downloading the template. (Download the template)event worksheet
  • This editable sheet consist two parts one is for budget for the event and the other is for budget. User can alter headings and use it with ease.
    programe template
  • Yellow colored theme with headings for revenue and expenses user can fill in stats like estimated quantity estimated unit price and it will automatically calculate estimated amount then he can compare them with actual. Quite easy but effective.


event name template

    • This sheet can be used in conjunction with other spreadsheets. It consist sample completed template along with a empty one. It is not a budget thing it is actually a planning sheet.

event management

  • Just a sample sheet to manage expenses and revenues.



Lease vs Own Analysis

comparison calculator lease

Many of us get confused whether to get a property, car or any other thing on lease or purchase it.We have collected some of the best tools to help you make this decision.

Compare between the three worksheet

comparison calculator lease

This sheet allows user to insert data and compare between purchasing,leasing or renting a machinery or asset. You have to be careful while inputting number of years for comparison. As number of years must not be lower than combined lease&finance term.Make sure you read the instruction given on introduction page. File comes with macro and graphs. Graphs make it more easier for user to analyse the differences.Though a little bit complex but one can understand why it is so. Sheet consist macros.


Spreadsheet for comparing loan cash flow.

operating lease vs own

This one is a bit simple  user have to fill in details like tax information, decision date and purchase information along with leasing information. Then there is a asset lifetime cost comparison sheet and the last one if for loan cash flow.


Employee Roster Template Excel sheet

sales roster

Simple example of a worker roster form with macros. One can simply click the image and download/view the format.
simple roster form

Another sample sheet showing how to manage personnel roster for mining workers.

personnel register roster

Incentive sheet : This spreadsheet will help you determine individual sales targets for each employee based on the daily sales goal and calculate data based on those numbers. There are 3 sheets involved in it, 1 st is for calculation, second one is for weekly breakdown of the sum and the last one is for instructions.

sales roster

Free Volere Templates (Examples)


Free of cost sample Volere templates that can be downloaded in excel,pdf and doc formats. Volere is used by business firms to manage their organisations. Some of the themes include requirement specifications,stakeholder analysis and others.

Download sample spreadsheet


The next one is atomic requirement sample

atomic requirement

Some example themes are provided free by official volere website itself all you have to do is get your self registered to download it.

Rolled Throughput Yield (RTY)Excel Calculator

It is one of the process to detect the probability that a single unit can pass a series of process without defects, it is a part and parcel of six sigma (quality). Following are some of the top calculating tools and examples to practice this method. RTY is the product of each process’s throughput yield, TPY.


Here is another one more sophisticated and good one View demo



Tour Operator Profit and loss Account Example


Download this example for tour and travel agents depicting how the costs and incomes are distributed among various items. You can edit information according to your assessment year, this example sheet also consist balance sheet.

travel agent balance sheet


This sample sheet shows what major items are included when handling the accounts of a tourism business. This sample sheet is available on onedrive so if you want to download it you have to click on the download link provided . Below is the image showing it.

download link

FMEA Product Example

Download this editable sample templates for excel. You can even print them, some of them contains MACRO and examples to understand how they work.For Product : This worksheet helps user to identify the potential failure and their effects on product reliability. The product with high RPN requires most attention as it has more chances to fail. Probability of the failure along with detect-ability and severity are examined and tracked.
FMEA product template