There are 7 different Validators that will check the consumption on the bill. Some will have a check against the previous bill, some against the previous years bill and either the total consumption in the bill or a daily amount.
These are:
Total Consumption Tolerance
- Checks the consumption in the current bill is within a percentage of the previous bill
- Total Consumption Tolerance Year
- Checks the consumption in the current bill is within a percentage of the previous years bill
- Total Consumption Tolerance (lower only)
- Checks the total LOWER consumption in the current bill is within a specified percentage of the previous bill
- Total Consumption Tolerance (higher only)
- Checks the total HIGHER consumption in the current bill is within a specified percentage of the previous bill
- Daily Consumption Tolerance
- Checks the average daily consumption in the current bill is within a percentage of the previous bill
- Checks the average daily consumption in the current bill is within a HIGHER percentage of the previous bill
Daily Consumption Tolerance HIGH - Same as GB – dailyConsumptionTol but instead of checking against the previous bill , this validator checks this bill against the previous years bill (allows for better benchmarking)
Daily Consumption Tolerance Year
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Tolerance value (%) | The percentage you want this bill and the previous bill to be between. For example, enter 20 for 20% |
GB - totalConsumptionTolYear.xml
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Tolerance value (%) | The percentage you want this bill and the previous years bill to be between. For example, enter 20 for 20% |
GB - totalConsumptionTol(lower only)
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Consumption decrease Tolerance (%) | The percentage decrease you want this bill and the previous bills daily consumption to be between. For example, enter 20 for 20% |
GB - totalConsumptionTol(higher only).xml
...
Variable | Description |
---|---|
Consumption increase tolerance (%) | The percentage increase you want this bill and the previous bills daily consumption to be between. For example, enter 20 for 20% |
Set '1' to check consumption only and ignore Query Value | Enter 1 if you want to check the consumption amount only, and ignore the Query Value |
Bill passes validation if out of tolerance but within the Query Value (£) | Enter a monitory figure, for example 50. The Validator will only fail out of tolerance, but within the Query Value. Enter 50 for £50.00 for example |
GB - dailyConsumptionTol.xml
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Tolerance value (%) | The percentage you want the this bill and the previous bills daily consumption to be between. For example, enter 20 for 20% |
GB - dailyconsumptionTolHIGH.xml
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Tolerance % for Daily Consumption | The percentage increase you want this bill and the previous bills daily consumption to be within. For example, enter 20 for 20% |
Check only verified bills | Tick to check only bills loaded to the Account (EDI Bills) |
...
Variable | Description |
---|---|
Bill will pass validation if the Query Value is less than (£){=(daily cons diff)xpres bill days)x(pres bill avg.PPU)] | Enter a monitory figure, for example 50. The Validator will only fail if the value of the difference is above £50.00 |
Tolerance for daily consumption variation on previous years bill | The percentage difference you want this bill and the previous years bills daily consumption to be within. For example, enter 20 for 20% |
Bill Entry screen
Current bill
...
'TolerancePercent=20.00' - The percentage you are willing to allow, ie 20 is 20% higher or lower
'MinimumQueryValue=50.00' - The minimum difference in the two figures before the validator fails, ie 50.00 is £50
'PrevDailyUpperLimit=7.74' - 200 (previous years bills consumption) / 31 (number of days in previous years bill) = 6.45 units per day. Plus 20% (as set in the Validator): 6.45 + 1.29 (20%) = 7.74 units per day
...
(not in line with screen shots)
Daily consumption within % of previous bill: FAILED - the name of the Validator
'lowerDailyLimit=571266.428571666667' - 10000 The previous bills daily consumption, minus 20%. 10,000 (previous years bills consumption) / 14 30 (number of days in previous years bill) = 714333.285714 3333 units per day. Minus 20% (as set in the Validator): 714333.28571 3333 - 14266.8571 666 (20%) = 571.42871 Lower units per day (571.428571)266.667
'actualDailyConsumption=333806.33333451613' - 10000 The current bills daily consumption. 25,000 (current bills consumption) / 30 31 (number of days in the current bill) = 333806.33333451613
'tolerance=20.00' - The percentage you are willing to allow, ie 20 is 20% higher or lower
'MinimumQueryValue=50.00' - The minimum difference in the two figures before the validator fails, ie 50.00 is £50
'upperDailyLimit=857400.14285700' - The previous bills daily consumption, plus 20%. 10000 0,000 (previous years bills consumption) / 14 30 (number of days in previous years bill) = 714333.285714 3333 units per day. Plus 20% (as set in the Validator): 714333.28571 3333 + 14266.8571428 66666 (20%) = Upper units per day (857399.1428579993)
'QueryValue=12001540.00' - The cost of the the difference between the current usage and the lower limit. 806.451613 (current daily usage) - 333.333 (lower daily limit) = 473.118313 x 30 (days in current bill) = 14193.54939 x 10.85p (average PPU in current bill) = £1540.00
Possible reasons for failure
...