Emission Calculation on Google Sheets.
Nine easy to use functions to calculate emission factors within Google Sheets. They use the same logic of API and always return CO2 equivalent in grams. These functions are designed for non-technical users who are calculating their footprint using their own spreadsheets.
If you need us to share the Google Sheet with the script, please write to us at support@carbonsutra.com
CO2ELECTRICITY - Calculate emissions from electricity usage in grams of CO2 equivalent
- Syntax: CO2ELECTRICITY(country_name, electricity_value, electricity_unit)
- Example: CO2ELECTRICITY("indonesia","8230","MWH")
CO2FUEL - Calculate emissions from fuel consumption in grams of CO2 equivalent
- Syntax: CO2FUEL(fuel_usage, fuel_name, fuel_value)
- Example: CO2FUEL("industrial", "Coal - Bituminous", "2800")
CO2HOTEL - Calculate emissions from a hotel stay in grams of CO2 equivalent
- Syntax: CO2HOTEL(country_code, [city_name], [hotel_rating], [number_of_nights], [number_of_rooms])
- Example: CO2HOTEL("IN","MUMBAI","4","2","1")
CO2FLIGHT - Calculate emissions from flight travel in grams of CO2 equivalent
- Syntax: CO2FLIGHT(iata_airport_from, iata_airport_to, [flight_class], [round_trip], [add_rf], [include_wtt], [number_of_passengers])
- Example: CO2FLIGHT("LAX","SIN","economy","Y","N","N","1")
CO2FREIGHT - Calculate emissions from freight or shipping in grams of CO2 equivalent
- Syntax: CO2FREIGHT(transport_mode, freight_weight, distance_value)
- Example: CO2FREIGHT("ShortSea","50000","1200")
CO2ECOMMERCE - Calculate emissions from eCommerce Shipments in grams of CO2 equivalent
- Syntax: CO2ECOMMERCE(origin_country_code, origin_postal_code, destination_country_code, destination_postal_code, package_weight, [add_rf], [include_wtt])
- Example: CO2ECOMMERCE("IN","248001","IN","603104","3","N","N")
CO2VEHICLEMODEL - Calculate emissions from vehicles by their model in grams of CO2 equivalent
- Syntax: CO2VEHICLEMODEL(vehicle_make, vehicle_model, distance_value, distance_unit)
- Example: CO2VEHICLEMODEL("Lexus","RX 300","19000","km")
CO2VEHICLETYPE - Calculate emissions from vehicles by their type in grams of CO2 equivalent
- Syntax: CO2VEHICLETYPE(vehicle_type, distance_value, distance_unit, [fuel_type], [include_wtt])
- Example: CO2VEHICLETYPE("Car-Type-Executive","11250","km","Unknown","Y")
CO2SEFR - Calculate emissions using SEFR (Singapore Emission Factors Registry) data in grams of CO2 equivalent
- Syntax: CO2SEFR(category, activity, value)
- Example: CO2SEFR("Fuel", "Bitumen", "2500")
Creating your own Emission Calculation function
The carbonSutra APIs can be easily called by a spreadsheet by creating and calling the function within it. While you (or your AI tool) can easily write one, we have provided the (AppScript Source Code)[https://carbonsutra.com/google-sheet-appscript-code] with instructions to get you started.
Note that you will need an authorization key to run the APIs (or call the functions).
Frequently Asked Questions (for Non-technical users).
How can I write my own Google Sheet function?
Show this page to your technical colleagues - It is really easy for them.
Is clustering feature available on spreadsheet functions?
In the above script, Clustering (and OpenCCF) are not included. Due to nature of spreadsheets, it is actually easier for the user to incorporate clustering.
How do I pass values in spreadsheet functions?
The easy way is to pass the reference of a cell (eg, A2, B3). For absolute values like "Taxi" or "3.2", they all must be passed within double quotes.
Your output is always in grammes but I want in metric tonnes. How can I get that?
Yes, for consistency, the output of all functions is in grammes of CO2 equivalent. To convert to other units, you can use the conversion formulas with the following values:
- 1 kg = 0.001 mt
- 1 kg = 1000 gm
- 1 kg = 2.2046 lb