Sigma Online User Manual

Showing Calorific Value Calculation Steps on Bills

There are many different charges you can add to a Tariff, which in turn will appear on the bill.

You can add additional information on the bill to show a description of the charges where there might be key information you want to expose to the Tenant in terms of how the bill has been created.

Where the Tariff has been configured to perform a calorific value conversion for the consumption being charged, then it is possible to show the different calculation steps in terms of how the metered consumption has been converted into an energy value:

  • Metric Units
  • Volume Correction
  • calorific value
  • m3 to kWh Multiplier
  • Resulting kWh Consumption

To show these on the Bill in the Description field, set up as follows:

Opening the Tariff Editor

Right click on the Tariff (under the Contract)

Click Edit

   

Adding the Metered Consumption Description

Click  

Complete as follows:

FieldDescription
NameEnter Metric Units
Line TypeChoose Bill Data
Input SourceLeave blank
Override SourceLeave blank
Output NameLeave blank
Tariff CodeLeave blank
Bill Data Code

Choose otherDataItem1 to  otherDataItem10

1 = the first line in the description field on the bill, 2 = second line etc.

Equation

Enter:

SINGLE([GasVolume])

Cost DefinitionGreyed out
Charge VATGreyed out


 

Note:  The detail in the square brackets of the equation will need to be exactly the same as the Output Name in the Tariff Entry.

Click OK to close the Tariff Entry Setup Editor.

To set up another Tariff Entry, click  

Alternatively, click OK to save the Tariff Entry.

Adding the Volume Correction Description

Click  

Complete as follows:

FieldDescription
NameEnter Volume Correction
Line TypeChoose Bill Data
Input SourceLeave blank
Override SourceLeave blank
Output NameLeave blank
Tariff CodeLeave blank
Bill Data Code

Choose otherDataItem1 to  otherDataItem10

1 = the first line in the description field on the bill, 2 = second line etc

Equation

Enter:

AVERAGEDTS([TempAndPress])

Cost DefinitionGreyed out
Charge VATGreyed out


 

Note:  The detail in the square brackets of the equation will need to be exactly the same as the Output Name in the Tariff Entry (see below):


   

Click OK to close the Tariff Entry Setup Editor.

To set up another Tariff Entry, click  

Alternatively, click OK to save the Tariff Entry.

Adding the Calorific Value Description

Click  

Complete as follows:

FieldDescription
NameEnter Calorific Value
Line TypeChoose Bill Data
Input SourceLeave blank
Override SourceLeave blank
Output NameLeave blank
Tariff CodeLeave blank
Bill Data Code

Choose otherDataItem1 to  otherDataItem10

1 = the first line in the description field on the bill, 2 = second line etc

Equation

Enter:

AVERAGEDTS([CalValue])

Cost DefinitionGreyed out
Charge VATGreyed out


 

Note:  The detail in the square brackets of the equation will need to be exactly the same as the  Output Name in the Tariff Entry (see below)

   

  

Click OK to close the Tariff Entry Setup Editor

To set up another Tariff Entry, click  

Alternatively, click OK to save the Tariff Entry.

Adding the m3 to kWh Volume Description

Click  

Complete as follows:

FieldDescription
NameEnter m3 to kWh Multiplier
Line TypeChoose Bill Data
Input SourceLeave blank
Override SourceLeave blank
Output NameLeave blank
Tariff CodeLeave blank
Bill Data Code

Choose otherDataItem1 to  otherDataItem10

1 = the first line in the description field on the bill, 2 = second line etc

Equation

Enter:

0.2777

Cost DefinitionGreyed out
Charge VATGreyed out


 

Click OK to close the Tariff Entry Setup Editor.

To set up another Tariff Entry, click  

Alternatively, click OK to save the Tariff Entry.

Adding the kWh Volume Description

Click  

Complete as follows:

FieldDescription
NameEnter kWh Consumption
Line TypeChoose Bill Data
Input SourceLeave blank
Override SourceLeave blank
Output NameLeave blank
Tariff CodeLeave blank
Bill Data Code

Choose otherDataItem1 to  otherDataItem10

1 = the first line in the description field on the bill, 2 = second line etc

Equation

Enter:

SINGLE([ConsumptionkWh])

Cost DefinitionGreyed out
Charge VATGreyed out


 

Note:  The detail in the square brackets of the equation will need to be exactly the same as the Output Name in the Tariff Entry.

Click OK to close the Tariff Entry Setup Editor.

To set up another Tariff Entry, click  

Alternatively, click OK to save the Tariff Entry.


@ Copyright TEAM - Energy Auditing Agency Limited Registered Number 1916768 Website: www.teamenergy.com Telephone: +44 (0)1908 690018