EnCalcGU Formulae


:: Home	:: Calculators	:: Utilities	:: Links	:: Contact Us	Updated: 08-Mar-2010

EnCalcGU Formulae

Version: 2.1
Size: 476KB
Released
09-March-2010

EnCalcGU uses the following formulae to calculate the results:

Actual Results

Days	=	Date 2 - Date 1
Number Quarters (1)	=	The number of complete and partial quarters between Date 1 and Date 2
Number Months	=	The number of complete and partial months between Date 1 and Date 2
Units Used (2)	=	( Meter Reading 2 - Meter Reading 1 )
KWHr Used (3,4)	=	( Units Used * Correction Factor * Calorific Value * Conversion Factor) / 3.6
Rate 1 KWHr (5,7)	=	The lower value of: KWHr Used and (Rate 1/2 Break Point * Number Quarters in Date 1 To Date 2 )
Rate 2 KWHr	=	KWHr Used - Rate 1 KWHr
Rate 1 Cost	=	Rate 1 KWHr * Rate 1 Unit Cost
Rate 2 Cost	=	Rate 2 KWHr * Rate 2 Unit Cost
Total Fixed Charge (7)	=	Fixed Charge * Number Quarters in Date 1 To Date 2
Total Cost (7)	=	Rate 1 Cost + Rate 2 Cost + Total Fixed Charge - ( Discount 1 * Number Quarters )
Total Cost (inc VAT) (6,7)	=	( Total Cost * ( 1 + VAT%) / 100 ) - ( Discount 2 * Number Quarters )
Cost per Day	=	Total Cost (inc VAT) / Days
CO2 Generated (Kg)	=	(Total of Units Used) * CO2 Conversion Factor

1. See Using EnCalcGU for an explanation of this formula.
2. Works in whole units, any decimals entered will be rounded.
3. Conversion Factor is 1 for cubic metres and 2.8 for 100;s of cubic feet (old style UK meters).
4. The Volume Conversion Factor is also known as the Correction Factor
5. If the Break Point = 0 then Rate 1 KWHr = KWHr Used.
6. If the currency selected is not UK Pounds (£) or Euros ( €) then VAT is changed to TAX.
7. If Monthly is checked quarters are replaced by months .

Predicted Results

Predicted Days	=	Date 1 + No Quarters To Predict Forward (This can be less than Actual Days)
Units Used	=	( ( Meter Reading 2 - Meter Reading 1 ) * Predicted Days ) / Actual Days
Rate 1 KWHrs	=	( The lower value of : KWHr Used and ( Rate 1/2 Break Point KWHr * Number Predicted Quarters)
Rate 2 KWHr	=	KWHr Used - Rate 1 KWHr
Rate 1 Cost	=	Rate 1 KWHr * Rate 1 Unit Cost
Rate 2 Cost	=	Rate 2 KWHr * Rate 2 Unit Cost
Fixed Charge Total	=	Fixed Charge * Number Predicted Quarters
Total Cost	=	Rate 1 Cost + Rate 2 Cost + Total Fixed Charge - ( Discount 1 * Number Predicted Quarters )
Total Cost (inc VAT)	=	( Total Cost * ( 1 + VAT%) / 100 ) - ( Discount 2 * Number Predicted Quarters )
Cost per Day	=	Total Cost (inc VAT) / Predicted Days
CO2 Generated (Kg)	=	(Predicted Number Of Units Used) * CO2 Conversion Factor


Legal Disclaimer	Home \| Calculators \| Utilities \| Links \| Contact us	Privacy Policy
Site History	Copyright © 2006-2010 A.J Shadlock. All Rights Reserved. Designed by Nina Flowers	Site Map