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
Daily Consumption Tolerance HIGH
- Checks the average daily consumption in the current bill is within a HIGHER percentage of the previous bill
Daily Consumption Tolerance Year
- 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)

GB – totalConsumptionTol.xml

Variables

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

Variables

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)

Variables

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

Variables

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

Variables

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

Variables

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)

GB - dailyConsumptionTolYear.xml

Variables

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

Previous years bill

Failure Prompts

GB - dailyConsumptionTolYear.xml

Daily consumption within % of previous year's bill: FAILED - the name of the Validator

'QueryValuePounds=279.02635' - 1800 (the yearly consumption) x 15.5 (the average PPU on the present bill) = £279

'ConsDailPresentBill=64.52' - 2000 (Current bills consumption) / 31 (number of days in the current bill) = 64.52 units per day

'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

'PrevDailyLowerLimit=5.16' - 200 (previous years bills consumption) / 31 (number of days in previous years bill) = 6.45 units per day. Minus 20% (as set in the Validator): 6.45 - 1.29 (20%) = 5.16 units per day

(not in line with screen shots)

Daily consumption within % of previous bill: FAILED - the name of the Validator

'lowerDailyLimit=266.666667' - The previous bills daily consumption, minus 20%. 10,000 (previous years bills consumption) / 30 (number of days in previous years bill) = 333.3333 units per day. Minus 20% (as set in the Validator): 333.3333 - 66.666 (20%) = 266.667

'actualDailyConsumption=806.451613' - The current bills daily consumption. 25,000 (current bills consumption) / 31 (number of days in the current bill) = 806.451613

'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=400.00' - The previous bills daily consumption, plus 20%. 10,000 (previous years bills consumption) / 30 (number of days in previous years bill) = 333.3333 units per day. Plus 20% (as set in the Validator): 333.3333 + 66.66666 (20%) = Upper units per day (399.9993)

'QueryValue=1540.00' - The cost of 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

Actual invoice after estimate
Current invoice period greater or lesser than the previous invoice
Seasonal changes (ie the current period is August and you are checking against a bill for the previous month - August

Total Consumption Tolerance

GB – totalConsumptionTol.xml

Variables

GB - totalConsumptionTolYear.xml

Variables

GB - totalConsumptionTol(lower only)

Variables

GB - totalConsumptionTol(higher only).xml

Variables

GB - dailyConsumptionTol.xml

Variables

GB - dailyconsumptionTolHIGH.xml

Variables

GB - dailyConsumptionTolYear.xml

Variables

Bill Entry screen

Failure Prompts

Possible reasons for failure

Browser not supported