Carbon Copy Assorted Formula with airSlate SignNow

Carbon copy assorted formula

the next problem we're going to look at involves calculating emissions from electricity consumption an international NGO is trying to calculate its scope to emissions from electrical use in their offices abroad they have 16 offices in five countries all with unique emission factors by consulting resources maintained by Defra the United Kingdom's Department for Environmental Food and Rural Affairs they find out that the average energy consumption per square meter is listed as 404 kilowatt hours per year after talking with their staff they conclude that their average office is 9 square meters given the below information what is the NGOs scope to emissions from offices overseas here we have some information we can see that in India there are 4 offices the emission coefficient is 0.94 for kilograms of carbon dioxide 4 kilowatt out per kilowatt hour and we have the same information for China France Sweden and Switzerland since this is a calculation that will require 5 different iterations essentially one for each country we're gonna do this one in a spreadsheet which is typically how we do these calculations under all circumstances so the first thing we're gonna do here is list out the various countries we've got India China France Sweden and Switzerland now up here at the top I'm gonna go ahead and list out some of the things we know the number of offices if we look back at the word document we will see that we have the number of offices listed here and that would be four in India two in China three in France two in Sweden and five in Switzerland we know that the average size of the offices is nine square meters let's go ahead and indicate here that we're talking about square meters and that's across the board nine square meters for each one and we know from the UK's Defra that kilowatt hours per square meter for a year are four hundred and four go ahead and drag that down okay so based on the number of offices and the size of the offices and the kilowatt hours per square meter per year we can now determine the total kilowatt hours consumed per year and that's going to be simply multiplication we're going to multiply the number of offices here in India by the average size in square meters which is nine by kilowatt hours per square meter per year hit enter and we see that in India their offices consume fourteen thousand five hundred and forty four square meters per year excuse me kilowatt hours per year we'll go ahead and drag that number down so now we know kilowatt hours per year if we go back to the word document will that we are given an emission coefficient for each country based on the generation mix of the electricity source so we can see that India's is the highest at 0.94 4 so they're likely heavily reliant on coal China may be using a...