JSutils for Computer Energy Saving and Energy Use Calculation
Bookmark and Share
Updated: 15-Sep-2009
JSUtils Compact Disk

EnCalcLU Formulae

Version: 2.3
Size: 468KB
Released
24-February-2010
EnCalcLU icon
JSutils software logo

EnCalcLU uses the following formulae to calculate the results:

Actual Results

Days

=

Date 2 - Date 1

Number Of Months Or 6 Month Periods (1)

=

Int ( ( ( Number Days Between Date 1 And Date 2 ) - 10 ) / ( 365 / 2 ) ) + 1
OR
Number Of Complete and Partial Months Between Date 1 And Date 2

Water Units Used (2)

=

Meter Reading 2 - Meter Reading 1

Sewage Units Used

=

(Meter Reading 2 - Meter Reading 1 ) * Sewage Volume Allowance

Water Units Cost

=

Water Units Used * Water Volume Charge

Sewage Units Cost

=

Sewage Units Used * Sewage Volume Charge

Water Fixed Charge

=

Period Water Fixed Charge * Number of Periods

Sewage Fixed Charge

=

Period Sewage Charge * Number of Periods

Total Fixed Charge

=

Water Fixed Charge + Sewage Fixed Charge

Total Cost

=

Water Units Cost + Sewage Units Cost + Total Fixed Charge - Discount 1

Total Cost (inc VAT) (3)

=

Total Cost * ( 1 + VAT%) / 100 - Discount 2

1. See Using EnCalcLU for an explanation of this formula.
2. Works in whole units, any decimals entered will be rounded.
3.
If the currency selected is not UK Pounds (£) or Euros ( €) then VAT is changed to TAX.

Predicted Results

Predicted Days

=

Date a + Number of 6 Months or Months To Predict Forward (This can be less than Actual Days)

Water Units Used

=

( Meter Reading 2 - Meter Reading 1 ) * ( Predicted Days / Actual Days )

Sewage Units Used

=

(Meter Reading 2 - Meter Reading 1 ) * Sewage Volume Allowance * (Predicted Days ) / Actual Days )

Water Units Cost

=

Water Units Used * Water Volume Charge * ( Predicted Days / Actual Days )

Sewage Units Cost

=

Sewage Units Used * Sewage Volume Charge * ( Predicted Days / Actual Days )

Water Fixed Charge

=

Period Water Fixed Charge * Number of Prediction Periods

Sewage Fixed Charge

=

Period Sewage Charge * Number of Prediction Periods

Total Fixed Charge

=

Water Fixed Charge + Sewage Fixed Charge

Total Cost

=

Predicted Water Units Cost + Predicted Sewage Units Cost + Predicted Total Fixed Charge - (Discount 1 * Number of Prediction Periods )

Total Cost (inc VAT)

=

( Predicted Total Cost * ( 1 + VAT%) / 100 ) - (Discount 2 * Number of Prediction Periods )