...
Checks zero consumption on this bill and/or previous bill
Validator Set Up
Variables
| Variable | Description |
|---|---|
| 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 – this bill zero, previous zeroand 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 – this bill has zero consumption, previous non-zerobill has consumption |
| 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 – this bill non-zerohas consumption, 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 |
Current Bill details
NEW SCREEN SHOT REQUIRED
Failure Prompt
...
Explanation: NEW EXPLAINATION REQUIRED
Total consumption cons within % of previous years bill: FAILED - name of the validatortolerance=20Tenant 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 'Tolerance' set in the validatorupperLimit=71149.20 - the amount of the Validator (first field) = 0
LoLimit=34.6 - 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)(in 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 (in 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 of 34.653)
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 in this bill