...
Checks zero consumption on this bill and/or last years bill
*Similar to TB - tltalCosumptionTolZeroCheck.xml, which checks the previous bill.
Validator Set Up
Variables
| Variable | Description |
|---|---|
| Tolerance % for consumption variation on previous year 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 zeropass 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 , previous non-zeroconsumption and the 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 – bill non-zero, previous zeropass if this bill has consumption and the previous bill has zero consumption |
| PASS if cons difference % fails but kWh trivial, below significance limit (ignore 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 |
...
Note: the Validator will look for an exact period match and if doesn’t find one, will use nearby bills to compare e.g. bill May -June 2022 which is compared against the Feb-Apr 2021 bill. Billing May-July compares the correct period.
Current Bill details
SCREEN SHOT REQUIRED
Failure Prompt
SCREEN SHOT REQUIRED
Explanation:
...
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
...
- This example is where the Validator is set at 10 Tolerance and 600 kWh difference
Total cons within % of prev year's Tenant Bill. PASS/FAIL on selected bill = zero criteria: FAILED
kWhLimit=600.00 - the 'Pass if cons difference%' figure in the Validator (last field) = 600 kWh
TolPcent=10.00 - the 'Tolerance' set in the Validator (first field) = 10 = 10%
LoLimit=31.6845 - the consumption in the previous year's bill 31.6845 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=38.725 - the consumption in the previous year's bill - 38.725 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=35.205 - consumption on the previous year's bill 35.205 kWh (therefore did not pass validation as the previous bill has consumption of 3.205)
bnzz =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
kWhDiff=4332.795 - the difference between this bills consumption and the previous year's bills, 4368 (this bill) - 35.205 (previous bill) = 4332.795
PresCons=4368 - consumption on this bill - 4368 kWh