Sigma Online User Manual
Gas Band ppu
GB – GasBandppu 
Compares the band rate on the current gas bill against the the previous bill. This Validator will fail if there is a difference (higher or lower) than the previous bill.
Validator Set Up
Variables
| Variable | Description |
|---|---|
| Bill will pass validation if the Query Value is less than (£) | Enter a monitory figure, for example 10. The Validator will only fail if the value of the difference is above £10 |
| Unit rate change threshold (p) )e.g. 0.0001) | Enter a value that you want the Unit rate difference to fail if over. For example, enter 0.01 and if the difference between this bills and the previous bills ppu is more than 0.01p the validator will fail |
Bill Entry screen
Current Bill
Previous Bill
Failure Prompt
Gas unit rate has changed from the previous invoice: FAILED - the name of the Validator
'threshold=0.01' - the threshold set in the validator,, allowing 0.01p high or lower than the previous bill
'previous=2.50' - the figure in the Cost rate field (19854) in the previous bill
'MinimumQueryValue=10.00' - the minimum cost of the query, £10.00
'QueryValue=26.42916' - the difference (in £s) between charging the current units at 2.70 (current cost) and 2.50 (previous cost), ie 13214.58 x 0.20 (the difference between 2.50 and 2.70) = £26.42
'present=2.70' the figure in the Cost rate field (19854) in the present bill
@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018