Sigma Online User Manual

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

TB - totalConsumptionTolZeroCheck.xml

Checks zero consumption on this bill/ previous bill


Validator Set Up


Variables

VariableDescription
Tolerance % for consumption variation on previous Tenant Bill, if both non-zero:Percentage variance allowed where current bill and previous bill consumption greater than zero
PASS if present bill = zero, previous bill = zero (bzz)

Select if validation should pass where both current and previous bills are zero

bzz – bill zero, previous zero
PASS if present bill = zero, previous bill non zero (bznz)

Select if validation should pass where the current bill is zero but the previous bill has consumption e.g. where property is now empty

bznz – bill zero, previous non-zero
PASS if present bill = non-zero, previous bill bill zero (bnzz)

Select if validation should pass where current bill has consumption and previous bills are zero e.g. property was previously empty

bnzz – bill non-zero, previous zero

PASS if cons difference % fails but kWh trivial, below significance limit (ignored if 0)

Enter a kWh value that can be used if the validator fails but by a small amount e.g.

Main tolerance set to 10% and 500 kWh significance limit:

Current cons = 4975 kWh

Previous cons = 4500 kWh

Difference = 475

This fails 10% tolerance as 4950 is the limit, but passes as less than 500 significance limit

If the user leaves the value as 0 then the bill would just FAIL on the breach of 10% (> 450)

Current Bill details

 NEW SCREEN SHOT REQUIRED


Failure Prompt

  NEW SCREEN SHOT REQUIRED


Explanation:  NEW EXPLAINATION REQUIRED

Total consumption within % of previous years bill: FAILED - name of the validator

tolerance=20.00 - the tolerance set in the validator

upperLimit=71149.20  - the amount of the consumption in the previous bill, plus 20%.  59291 (previous years bills consumption) + 11858.20 (20%) = 71149.20 (upper limit)

totalConsumption=98999.00 - the total consumption in the current bill

lowerLimit=47432.80 - the amount of the consumption in the previous bill, minus 02%. 59291 (previous years bills consumption) - 11858.20 (20%) = 47432.80 (upper limit)

MinimumQueryValue=0.00 - the minimum value set in the validator

QueryValue=5956.20 - the monetary amount of the query. £14849.85 (current billed cost) - £8893.65 (previous years billed cost) = £5956.20 (the difference between the two)



  • No labels