Sigma Online User Manual
Consumption Tolerance Validators
- Kim Blake
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
@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018