This page lists what Avarni accepts in the Country and Input Unit columns of an upload.
Country
Use the ISO 3166-1 alpha-2 code. Two letters, in capitals.
Correct | Wrong |
|
|
|
|
|
|
|
|
Three-letter codes and country names are rejected. Use capitals: a lower-case code can pass the first check and then fail later when Avarni looks up the region.
Country is required on every row and must be mapped during upload. If a row has no country, Avarni uses the default country you set for the import.
States, provinces and grids
Do not put a state or province in the Country column. There is no AU-NSW or US-CA form.
To get a state, province or grid factor, map a column to Location/Address instead. Put the site address, or the suburb and state, in that column. Avarni finds the point on the map and narrows the factor to the region that covers it.
Without a location, Avarni uses the national factor.
Market-based uploads
A market-based Scope 2 upload accepts only AU and NZ. Any other country is rejected with an error.
Input units
The unit you enter must belong to the unit type you set on the Method. A Method built for Energy will not accept litres.
You can enter the full name or a common abbreviation. Spelling must match the list below. If you are unsure, pick the unit from the dropdown in the importer rather than typing it.
Energy
Kilowatt Hour (kWh), Megawatt Hour (MWh), Gigawatt Hour (GWh), Kilowatt Day (kWd), Megawatt Day (MWd), Terawatt Day (TWd), Terawatt Hour (TWh), Joule (J), Kilojoule (kJ), Megajoule (MJ), Gigajoule (GJ), Kilobritish Thermal Unit (kBTU), Megabritish Thermal Unit (MBTU), Gigabritish Thermal Unit (GBTU), Therm Us (thm)
Volume
Liter (L), Milliliter (ml), Deciliter (dl), Decaliter (dal), Kiloliter (kL), Megaliter (Ml), Cubic Meter (m3), Cubic Centimeter (cm3), Cubic Foot (ft3), Us Gallon, Imperial Gallon, Kilous Gallon, Imperial Ounce, Metric Teaspoon (tsp), Centum Cubic Foot (ccf), Standard Cubic Foot (scf)
Mass
Kilogram (kg), Gram (g), Tonne (t), Kilotonne (kt), Megatonne (Mt), Pound (lb), Kilopound (klb), Megapound (Mlb), Ounce (oz), Short Ton, Long Ton
Distance
Kilometer (km), Meter (m), Mile (mi), Foot (ft), Kilofoot (kft), Yard (yd), Nautical Mile (NM)
Area
Square Meter (m2), Square Kilometer (km2), Square Foot (ft2), Square Inch (in2), Square Mile (mi2), Square Yard (yd2), Hectare (ha), Acre (ac)
Number
Unit, Co2e, tCO2e, CPU Hour, Employee Per Day, Person Night, Person Year, Room Night, ContainerMoved
tCO2e and Co2e are for emission figures entered directly in the Emissions Hub or given in a supplier survey answer. Do not use them as the unit in a Method upload. See Load historical and prior-year data.
Freight and passenger units
Tonne Kilometer (tonne-km), Ton Mile (ton-mile), Passenger-Kilometer (passenger-km), Passenger-Mile (passenger-mile), Vehicle-Kilometer, Vehicle-Mile, Twenty Foot Equivalent Per Kilometer (TEU-km)
Currency
Use the three-letter ISO currency code in capitals.
AED, AUD, BDT, BRL, CAD, CHF, CLP, CNY, CZK, DKK, EUR, GBP, HKD, HUF, IDR, ILS, INR, JPY, KES, KRW, LKR, MXN, MYR, NOK, NZD, PGK, PHP, PKR, PLN, RMB, SAR, SBD, SEK, SGD, THB, TOP, TRY, TWD, USD, VND, VUV, WST, XPF, ZAR
Units Avarni holds but the importer does not offer
These exist in the platform but you cannot select them as an upload unit type: Hour, Kilogram Per Day, Gigabyte, Kilobyte, Megabyte, Terabyte, Kilometers Per Year, Meters Per Year, Square Meters Per Year, Gigabytes Per Hour, Terabytes Per Hour.
If you need one of these, contact us.
When a unit does not convert
Avarni converts your unit to the factor's unit before it multiplies. Litres convert to kilolitres, miles to kilometres, and so on.
Two things stop a conversion:
The unit types differ. A Mass unit cannot become a Volume unit. Avarni multiplies the raw number by the factor anyway, so the result is wrong by whatever the conversion would have been.
The unit has no conversion defined. Centum Cubic Foot, Standard Cubic Foot, the passenger and vehicle distance units and everything under Number are stored as entered and never converted.
Avarni does not warn you on screen when a unit conversion fails. Check the unit conversion line in the calculation breakdown on an emission. A rate of 1.0000 between two different units means no conversion happened.
A unit of Unknown sets the emission to zero.
