Newer Version Available

This content describes an older version of this product. View Latest

Data Gap Filling

You can locate the sources of gaps in carbon footprint record data and resolve them.
Available in: Lightning Experience and the Salesforce mobile app
Available in: Enterprise, Performance, and Unlimited Editions

Here are the calculated fields:

Input fields

  • Building Energy Intensity Value (BldgEnrgyIntensityVal)

    • Annual Intensity Value (kWh/m2) (AnnualIntensityValueInKwhM2)

  • Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)

    • Regional Building Energy Intensity (RegionalBldgEnergyIntensity)

    • Building Energy Intensity (BuildingEnergyIntensity)

    • Occupied Floor Area (OccupiedFloorArea)

  • Stationary Asset Energy Use (StnryAssetEnrgyUse)

    • Total Fuel Consumption (kWh) (TotalFuelConsumptionInKwh)

    • Start Date (StartDate)

    • End Date (EndDate)

Calculations

  • If Fill Method = Building Energy Intensity, then

    Fill Data = StnryAssetCrbnFtprnt.RegionalBldgEnergyIntensity.BldgEnrgyIntensityVal (for the fuel type).Annual Intensity Value (kWh/m2) * Occupied Floor Area/365 * data gap duration

  • If Fill Method = Regional Building Energy Intensity, then

    Fill Data = StnryAssetCrbnFtprnt.BuildingEnergyIntensity.BldgEnrgyIntensityVal (for the fuel type).Annual Intensity Value (kWh/m2) * Occupied Floor Area/365 * data gap duration

  • If Fill Method = Previous Year Daily Average, then

    Fill Data = SUM(StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.Total Fuel Consumption (kWh) / SUM(StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.End Date - StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.Start Date) for the selected fuel type

  • If Fill Method = Current Year Daily Average, then

    Fill Data = StnryAssetEnrgyUse.Total Fuel Consumption (kWh) / SUM(StnryAssetEnrgyUse.End Date-StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.Start Date) for the selected fuel type