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

TB - totalConsumptionTolZeroCheck.xml

Checks zero consumption on this bill and/or previous bill

*Similar to TB - tltalCosumptionTolYearZeroCheck.xml, which checks the previous years 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 – pass if this bill and the previous bill both have zero consumption
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 – pass if this bill has zero consumption, previous bill has consumption
PASS if present bill = non-zero, previous 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 – pass if this bill has consumption and previous bill has zero consumption

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


Failure Prompt

Explanation: - This example is where the Pass if this bill has consumption, and the previous bill has zero consumption is ticked 

Total cons within % of previous Tenant Bill. PASS/FAIL on selected bill = zero criteria: FAILED

kWhLimit=0.00  - the 'Pass if cons difference%' figure in the Validator (last field) = 0

TolPcent=0.00 - the 'Tolerance' set in the Validator (first field) = 0

LoLimit=34.6 - the consumption in the previous bill 34.6 kWh

bznz=0.00 -  - 0 = not set in this validator, but if ticked, will pass if this bill has consumption and the previous bill has zero consumption 

HiLimit=34.653  - the consumption in the previous bill - 34.653 kWh

bzz=0.00 0 = not set in this validator, but if ticked, will pass if this bill and the previous bill both have zero consumption 

PrevCons=34.653 - consumption on the previous bill 34.653 kWh    (therefore did not pass validation as the previous bill has consumption, it was not zero)

bnzz =1.00  - 1 = set in this validator and will pass if this bill has consumption, and the previous bill has zero consumption  

kWhDiff=4333.347 - the difference between this bills consumption and the previous bills, 4368 (this bill) - 34.653 (previous bill) = 4333.347 

PresCons=4368 - consumption on this bill - 4368 kWh









  • No labels