Extrapolation is used when you are missing a period of data or quantity of data and wish to infer this quantity from a previous period, similar activity or from a cost value you have available.
Step 1: To begin select the Activity or Meter you wish to extrapolate data for from the meter or activity screen in the Data Management section.
Use the tree view and selectors (Scope, Source Category, Activity Type) (A above) and Search Filter (B) to find the activity/meter. Once you have found the activity/meter click select (C). For this example we are going to use an Electricity meter.
Step 2: Once you have selected the activity/meter and are on the Activity screen, click on Add New Data Item and. You can also Extrapolate an existing item by clicking edit and then Extrapolate beside the Quantity.
Step 3: After clicking Add New Data Item, a screen will appear to input the data item. Input the start and end date (A) that you wish the data item to cover, the activity type, units etc... and then click on the Extrapolate button (C) beside the Quantity box.
Step 4: Next an Extrapolations screen will appear, the user is asked to select with Extrapolations method they would like to use. There are three to choose for Cost, Model Activity and Previous Period. Cost - This involves using the cost from the Electricity bill/Supplier statement and the unit of cost to fine the Quantity. Model Activity – This involves calculating the quantity from a similar activity. Previous Period – This involves calculating using a quantity from a previous period.
Step 5A: If the Cost Method is chosen - The user is then asked to fill in the Total cost (A) value they wish to use to find the kWh figure. This cost can be taken from the Supplier/Electricity Bill.The user is next asked to fill in the Unit of Cost (B). These two figures will then be used to get the kWh value. The User should also add a comment explaining the figures and the reason for Extrapolation (C). When finished click Apply.
Step 5B: If the Model Activity Method is chosen:
The user must first select the Model Activity (A) you wish to use. This is the activity you wish to use to infer the quantity from. The user can select the activity from the dropdown, the dropdown provides a list of similar activities. For example if you are trying to extrapolate an Electricity activity/meter it will show a number of other similar Electricity meters from the organisation.
Next you must choose the dates (B) you wish to model this quantity from. Once you have completed A and B, click Get Data, then the Unit and Quantity taken from the model activity for the requested period will appear in the box (C). If you are not happy with the quantity you can choose another activity/meter or date period. If there is no data in the model activity for the relevant period an error message will show up.
Next the user must input a Multiplier (D).This Multiplier is a modifier that is used to convert the real quantity data from the model Activity into the quantity for this activity you are extrapolating. For example if the building of the activity you are extrapolating for is 1000 sq feet and the building for the modelling activity is 2000sq feet, a multiplier of 0.5 would be inputted to ensure accuracy. The user will need to determine what multiplier to use. If you need assistance contact support.
Finally the user can input a comment (E) explaining why they used the Multiplier and model activity. When finished click Apply.
Step 5C: If the Previous Period method is chosen:
You must select a previous period with the extrapolation activity that you wish to model the quantity on. Input this period in A as shown below.
Next click Get Data (B below) then the Unit and Quantity taken from that period will appear in the box. If you are not happy with the quantity you can choose another date period. If there is no data in the activity for the relevant period an error message will show up.
Next the user must input a Multiplier (C).This Multiplier is a modifier that is used to convert the real quantity data from the previous period into the quantity for this activity you are extrapolating. For example if since the previous period CO2 values have been dropping year on year by 5%. So, to reflect this, you could use a multiplier of .95 to take account the trend. The user will need to determine what multiplier to use. If you need assistance contact support.
Finally the user can input a comment (D) explaining why they used the Multiplier and previous period. When finished click Apply.
Step 6: Once the quantity is extrapolated, it will return to the add data item field, where you can finish inputting general details about the data item. Under the quantity box there will be summary of how the quantity figure was calculated for audit and user purposes. Click Save when finished.