JSutils for Computer Shutdown Utilities and Energy Use Calculators
Updated: 21-Nov-2011
JSutils Compact Disk

EnCalcOU Formulae

Version: 2.2
Size: 520KB
Released: 04-October-2011
EnCalcOU icon

EnCalcOU uses the following formulae to calculate the results:

Actual Results

Days

=

Tank Reading Date 2 - Tank Reading Date 1

Total Oil Used

=

Volume in Tanks on Tank Reading Date 1 - Volume in Tanks on Tank Reading Date 2 + Oil Added between Tank Reading Dates 1 and 2

Cost Before VAT (3)

=

Value of Oil In Tank on Tankreading Date 1 - Value of Oil in Tanks on Tank reading Date 2 + Cost of Oil Added between Tank Reading Dates 1 and 2 + Delivery Charges less VAT

VAT Cost (3, 4)

=

Oil Cost Before VAT * (Oil VAT% / 100 ) + Delivery Cost Before VAT * (Delivery VAT% / 100 )

Total Cost (inc VAT) (1)

=

Cost Before VAT + VAT Cost

Cost per Day

=

Total Cost (inc VAT) / Days

CO2 Generated (Kg)

=

Volume of Oil Used * CO2 Conversion Factor

CO2 Generated (Kg) per Day

=

Volume of Oil Used * CO2 Conversion Factor / Days

Oil Used per Day

=

Total Oil Used / Days

1. If the currency selected is not UK Pounds (£) or Euros ( €) then VAT is changed to TAX.
2. Costs will only be calculated if the Get Last button is used and the instructions for 'First Use' have been followed.
3. If VAT = 0 then Cost before VAT and VAT Cost will be empty.
4. Oil VAT and Delivery VAT must either both be set or 0.

5. If the oil will run out before the end of prediction period delivery costs are added based on the last delivery.
6. If the oil will run out before the end of prediction period delivery VAT costs are added based on the last delivery.
5. If the oil will run out before the end of prediction period the extra oil cost is based on the last delivery.

Predicted Results

Predicted Days

=

Date 1 + No Months To Predict Forward

Predicted Total Oil Used

=

Total Oil Used * ( Predicted Days / Actual Days )

Predicted Cost Before VAT (3,5,7)

=

Total Cost * ( Predicted Days / Actual Days )

Predicted VAT Cost (3,6)

=

VAT Cost * ( Predicted Days / Actual Days )

Predicted Total Cost (inc VAT)

=

Predicted Cost Beforew VAT + Predicted VAT

CO2 Generated (Kg)

=

Predicted Volume of Oil Used * CO2 Conversion Factor

Predicted Fill Up Date

=

Tank Reading Date 2 + (Oil Volume Left / Oil Used per Day)