...
They both calculate the set daily amount for fixed charges based on the calculated number of days in the billing period.
- GB - ElecFixedCharges
- GB - GasFixedCharges
They both require a Property Key to be on the Site.
The Property Key needs a unique name (ie FixedElecCharges or FixedGasCharges) and you need to enter the figure you want to validate against.
For example, if you enter 20 you would expect the Fixed Charges on the Account to be £20 (add a tolerance to the Validator if you don't expect it to be exact, ie 10%)WHAT CELL(S) DOES IT CHECK?? - have i got the right cell?, the Validator will take that as a daily figure, it will then look at the figure in the Fixed Charges field in the bill and divide it by the number of days and match one against the other.
Example:
- Property Key has a value of 25
- Validator allows for a 10% difference
- 25 + 10% higher = 27.5
- The bill is for a period of 30 days
- The Fixed Charges field in the bill has a value of 1050
1050 (the Fixed Charge) / 30 (number of days) = 35
The Validator would fail as 35 is over 27.5 (25 + 10%)
Additional Requirements
A Property Key needs to be attached to the Site, with the exact wording in the Variables (ie FixedElecCharges or FixedGasCharges)
- Click here for more details on how to add the Property Key(s)
Validator Set Up
GB - ElecFixedCharges GB - GasFixedCharges
Variables
| Variable | Description |
|---|---|
| Name of the Property Key defining Tolerance value (attached to Account) | Enter the exact name of the Property Key that is attached to the Account (see above, for example FixedElecCharges) |
| Tolerance Percentage for difference | Enter the percentage difference you want before the validator will fail, (ie 1 will be 1%)above the Property Key value that is acceptable, ie enter 10 for 10% |
Bill Entry screen
...
Electricity
Gas
Failure Prompts
Electricity
Electric Fixed Charges Validator: FAILED - The name of the Validator
'TolerancePercentage=10.00' - The percentage tolerance set in the Validator, ie10 for 10%
'DailyFixedCharge=200035.00' - The daily fixed charge? Where is this figure fromThe Fixed Charges figure (1050) divided by the number of days (30) = 35
'upperLimit=27.50' - Where is this figure from The figure in the Property Key (25) + 10% (the tolerance in the Validator, 10) = 27.50
'ToleranceValue=25.00 - Where is this figure from (the validator tolerance is 10%)?????????? The figure in the Property Key - 25
Gas
Gas Fixed Charges Validator: FAILED - The name of the Validator
'TolerancePercentage=10.00' - The percentage tolerance set in the Validator, ie10 for 10%
'DailyFixedCharge=2000064.00516129' - The daily fixed charge? Where is this figure fromFixed Charges figure (2000) divided by the number of days (31) = 64.516129
'upperLimit=55.00' Where is this figure from - The figure in the Property Key (50) + 10% (the tolerance in the Validator, 10) = 55
'ToleranceValue=50.00' Where is this figure from (the validator tolerance is 10%)?????????? - The figure in the Property Key - 50