Our Methods

In order to find the amount of carbon that was emitted from each factory based on power consumption, we first had to convert our power consumption data to kg of CO2. We did this by using a total of 3 formulas that converted the power consumption of each factory to kg of CO2 emitted. We used excel and google sheets for our plotting, graphing, and calculations.

01 Formula - Mw to Mwh

Our original dataset included the amount of power in terms of megawatts. We assumed that all of the carbon capture factories were operational 365 days out of the year therefore, we used this formula (amount of megawatts * 0.25 * 365 Days * 24hours) to convert the megawatts into megawatts per hour.

02 Formula - Mwh to Kwh

After converting our power in terms of MWh, we then converted MWh to KWh. We did this simply by multiplying 1,000 to our Mwh power consumption data. We did this so that we can find the amount of carbon emitted.

03 Formula - Kwh to Kg of CO2

After converting the power consumption (MHw to KWh), we then multiplied the kilowatts per hour to 0.7 kg of CO2. We did this because the average carbon cost in the U.S. is about 0.7 kg of CO2 per kWh. After doing this simple calculation, we then gave the amount of CO2 that was emitted by each factory In terms of power consumption.

Simplified Version of all three formulas

Formula 1

Formula 2

Formula 3

the amount of megawatts * o.25 * 365 days * 24 hours * 1000(mwh-kwh) * 0.7(kg of co2 per kwh)