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
| 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 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 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 (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: Previous 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: 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)