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 3 Next »


TB - totalConsumptionTolYearZeroCheck.xml

Checks that the total consumption is within a percentage of previous year's Tenant Bill. PASS/FAIL on selected 'bill = 0' criteria  ??? (this is taken from the validator)


Validator Set Up


Variables

VariableDescription
Tolerance % for consumption variation on previous year Tenant Bill, if both non-zeroEnter a monitory figure, for example xx
PASS if present bill = zero, previous bill = zero (bzz)xx
PASS if present bill = zero, previous bill non-zero (bznz)xx
PASS if present bill = non-zero, previous bill zero (bnzz)xx
PASS if cons difference % fails but kWh trivial, below significance limit (ignore if 0)xx

Current Bill details

SCREEN SHOT REQUIRED


Failure Prompt

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