Intermediate Excel

Data Set for Class 3

Per Capita by Country, as per Wikipedia

Asia	Afghanistan	700
Europe	Albania	4400
Africa	Algeria	5700
Oceania	American Samoa	7400
Africa	Angola	6600
The Americas	Anguilla	12500
The Americas	Antigua and Barbuda	13500
The Americas	Argentina	11300
Asia	Armenia	3400
The Americas	Aruba	23400
Oceania	Australia	65100
Europe	Austria	49100
Asia	Azerbaijan	7900
The Americas	Bahamas	26200
Middle East	Bahrain	22100
Asia	Bangladesh	900
The Americas	Barbados	14700
Europe	Belarus	7500
Europe	Belgium	45600
The Americas	Belize	4900
Africa	Benin	800
Asia	Bhutan	2900
The Americas	Bolivia	2800
Europe	Bosnia and Herzegovina	4800
Africa	Botswana	7300
The Americas	Brazil	11100
Asia	Brunei	39800
Europe	Bulgaria	7300
Africa	Burkina Faso	700
Africa	Burundi	300
Asia	Cambodia	1000
Africa	Cameroon	1200
The Americas	Canada	52100
Africa	Cape Verde	3700
The Americas	Cayman Islands	47000
Africa	Central African Republic	400
Africa	Chad	1200
The Americas	Chile	15700
Asia	China	6900
The Americas	Colombia	8100
Africa	Comoros	900
Africa	Congo, Democratic Republic of the	300
Africa	Congo, Republic of the	3100
The Americas	Costa Rica	10300
Africa	Côte d'Ivoire	1300
Europe	Croatia	13400
The Americas	Cuba	6500
The Americas	Curaçao	36800
Europe	Cyprus	25200
Europe	Denmark	58300
Africa	Djibouti	1800
The Americas	Dominica	6700
The Americas	Dominican Republic	5800
Asia	East Timor	5200
The Americas	Ecuador	5900
Africa	Egypt	3100
The Americas	El Salvador	4000
Africa	Equatorial Guinea	24200
Africa	Eritrea	500
Europe	Estonia	18300
Africa	Ethiopia	400
Europe	European Union	34000
The Americas	Falkland Islands	55400
Europe	Faroe Islands	45300
Oceania	Fiji	4700
Europe	Finland	49200
Europe	France	41700
Oceania	French Polynesia	20600
Africa	Gabon	12200
Africa	Gambia, The	500
Asia	Georgia	3600
Europe	Germany	44300
Africa	Ghana	1800
Europe	Gibraltar	38800
Europe	Greece	21800
The Americas	Greenland	37500
The Americas	Grenada	7400
Oceania	Guam	28700
The Americas	Guatemala	3700
Europe	Guernsey	43400
Africa	Guinea	600
Africa	Guinea-Bissau	500
The Americas	Guyana	5800
The Americas	Haiti	800
The Americas	Honduras	2200
Asia	Hong Kong	38100
Europe	Hungary	13100
Europe	Iceland	46200
Asia	India	1500
Asia	Indonesia	3500
Middle East	Iran	5200
Middle East	Iraq	6600
Europe	Ireland	46000
Europe	Isle of Man	47800
Middle East	Israel	35400
Europe	Italy	33600
The Americas	Jamaica	4900
Asia	Japan	38500
Europe	Jersey	57600
Middle East	Jordan	5300
Asia	Kazakhstan	12700
Africa	Kenya	1000
Oceania	Kiribati	1700
Asia	Korea, North	1200
Asia	Korea, South	24400
Europe	Kosovo	3800
Middle East	Kuwait	66500
Asia	Kyrgyzstan	1300
Asia	Laos	1500
Europe	Latvia	15400
Middle East	Lebanon	10500
Africa	Lesotho	1300
Africa	Liberia	400
Africa	Libya	11800
Europe	Liechtenstein	139300
Europe	Lithuania	15300
Europe	Luxembourg	110700
Asia	Macau	87300
Europe	Macedonia, Republic of	5000
Africa	Madagascar	400
Africa	Malawi	300
Asia	Malaysia	10500
Asia	Maldives	5800
Africa	Mali	700
Europe	Malta	22600
Oceania	Marshall Islands	2800
Africa	Mauritania	1200
Africa	Mauritius	9000
The Americas	Mexico	10600
Oceania	Micronesia, Federated States of	3200
Europe	Moldova	2200
Europe	Monaco	159400
Asia	Mongolia	3900
Europe	Montenegro	6800
Africa	Morocco	3200
Africa	Mozambique	600
Africa	Namibia	5600
Asia	Nepal	600
Europe	Netherlands	47600
Oceania	New Caledonia	35700
Oceania	New Zealand	40600
The Americas	Nicaragua	1900
Africa	Niger	400
Africa	Nigeria	1700
Europe	Norway	101400
Middle East	Oman	26000
Asia	Pakistan	1300
Middle East	Palestine	1700
The Americas	Panama	11400
Oceania	Papua New Guinea	2500
The Americas	Paraguay	4600
The Americas	Peru	6700
Asia	Philippines	2600
Europe	Poland	13300
Europe	Portugal	21000
The Americas	Puerto Rico	23500
Middle East	Qatar	104300
Europe	Romania	8900
Europe	Russia	14600
Africa	Rwanda	600
The Americas	Saint Kitts and Nevis	15000
The Americas	Saint Lucia	8400
The Americas	Saint Vincent and the Grenadines	7100
Oceania	Samoa	3600
Europe	San Marino	57900
Africa	São Tomé and Príncipe	1700
Middle East	Saudi Arabia	24800
Africa	Senegal	1200
Europe	Serbia	6000
Africa	Seychelles	14000
Africa	Sierra Leone	800
Asia	Singapore	54700
The Americas	Sint Maarten	21900
Europe	Slovakia	17700
Europe	Slovenia	22700
Oceania	Solomon Islands	1800
Africa	Somalia	600
Africa	South Africa	6600
Africa	South Sudan	1000
Europe	Spain	28600
Asia	Sri Lanka	3000
Africa	Sudan	1500
The Americas	Suriname	8800
Africa	Swaziland	2700
Europe	Sweden	57200
Europe	Switzerland	80800
Middle East	Syria	2900
Asia	Taiwan	20900
Asia	Tajikistan	1000
Africa	Tanzania	700
Asia	Thailand	5600
Africa	Togo	500
Oceania	Tonga	4500
The Americas	Trinidad and Tobago	22000
Africa	Tunisia	4400
Europe	Turkey	10700
Asia	Turkmenistan	7800
Africa	Uganda	500
Europe	Ukraine	3800
Middle East	United Arab Emirates	70900
Europe	United Kingdom	39600
The Americas	United States	52800
The Americas	Uruguay	15800
Asia	Uzbekistan	1900
Oceania	Vanuatu	3100
The Americas	Venezuela	12900
Asia	Vietnam	1900
The Americas	Virgin Islands, British	38900
Middle East	Yemen	1700
Africa	Zambia	1600
Africa	Zimbabwe	800

Assignment 2 of 3 and Solutions

Now it's time to put the concepts learned to use. Using data provided in Assignment 2 Data Set, try to solve the following tasks:

Below are the solutions... Now don't cheat... Try to solve first and then use the solutions to help you understand.

Class 2 of 3: Text and Lookup Functions

Here are the formulas that we looked at during class 2 of 3:

TEXT FUNCTIONS
The text functions are some of the most used in Excel when you're working with lists and database extractions. Whenever you extract data from a Database, more often than not it needs to be cleaned up. This is where the following text functions come to our help. Be aware however, these are not the comprehensive list of them. There are many other ones and I encourage you to explore the Function Wizard to learn other ones:

LOOKUP FUNCTIONS
The lookup functions are crucial to Excel. Without these the amount of manual work would be huge. Anyone who considers themselves a serious Excel student, must learn these. It is for this reason that I decided to cover them. They are not the easiest to use, but with practice, anyone can learn them.

The VLOOKUP function is the first one most people learn to use. I call it the basic lookup function because it's somewhat easy to understand and use. It definitely has its place among the heavy lifters in Excel; my issues with it is that it requires setup and if you don't follow it, it won't work. Here is its syntax and an example.

The INDEX-MATCH function is the more advanced and elegant of the lookup functions in my opinion. It's not perfect, because it also requires that the data be cleaned up of leading and trailing spaces for it to work. But outside of that, I use it almost exclusively. It's not the most intuitive of functions, but with practice, you'll get the hang of it. Here is its syntax and a example for you to use.

I know it was a lot to cover, but I feel it was necessary. Now, you must practice your skill. Use the data I've provided and look for the assignment and its solution to practice. Keep Excelling!

Assignment 2 Data Set

Rep	Item	Units
Jardine	Binder	94
Thompson	Binder	57
Andrews	Binder	28
Gill	Binder	46
Gill	Binder	80
Howard	Binder	29
Jardine	Binder	11
Jones	Binder	60
Jones	Binder	4
Parent	Binder	81
Smith	Binder	87
Sorvino	Binder	7
Jones	Binder	60
Morgan	Binder	28
Kivell	Binder	50
Kivell	Desk	5
Smith	Desk	2
Sorvino	Desk	3
Gill	Pen	27
Howard	Pen	96
Jones	Pen	64
Parent	Pen	15
Sorvino	Pen	76
Jardine	Pen Set	50
Jones	Pen Set	16
Jones	Pen Set	62
Kivell	Pen Set	42
Morgan	Pen Set	55
Parent	Pen Set	74
Kivell	Pen Set	96
Andrews	Pencil	75
Andrews	Pencil	66
Andrews	Pencil	14
Gill	Pencil	53
Gill	Pencil	7
Jardine	Pencil	36
Jardine	Pencil	90
Sorvino	Pencil	56
Thompson	Pencil	32
Jones	Pencil	35
Jones	Pencil	95
Morgan	Pencil	90
Smith	Pencil	67

REFERENCE TABLE 1

Employee ID	Name
530	Andrews
360	Gill
408	Howard
935	Jardine
989	Jones
505	Kivell
913	Morgan
869	Parent
519	Smith
522	Sorvino
752	Thompson

REFERENCE TABLE 2

Product	Price
Binder	1.99
Desk	125
Pen	1.99
Pen Set	4.99
Pencil	1.29

Class 2 Dataset 1

We will be using this data set for one of the exercises in class.

Ali Small	2
Arden Stone	3
Ariana Tucker	1
Bethany Howell	2
Constance Maxwell	3
Damon Kidd	4
Doris Simmons	3
Drake Middleton	4
Emily Gamble	2
Gary Myers	4
Gay Donaldson	2
Gay Schneider	3
Geoffrey Logan	3
Germaine Richardson	4
Gil Daniel	3
Ginger Mckay	3
Hedley Clark	1
Heidi Guzman	3
Ian Horn	3
India Sharpe	4
Jasper Barrera	4
Karly Stokes	4
Keaton Garcia	2
Keelie Hooper	3
Lilah Shields	4
Lillith Cleveland	4
Lucian Lopez	4
Lyle Kim	3
Mia Pitts	4
Ora Glass	3
Quinn Wolfe	2
Quyn Lyons	3
Reece Christian	4
Reece Holloway	2
Rhiannon Mccarty	1
Sarah Leonard	3
Serena Watkins	2
Shana Byers	4
Shay Carlson	4
Sonia Beach	3
Trevor Bray	4
Ulysses Mann	3
Ulysses Patterson	4
Vance Whitney	4
Vincent Berry	4
Wyatt Dalton	1
Yeo Hewitt	1

Assignment #1 Solutions

Here are the solutions:

Now, the formulas don't have to be in the exact sequence, you could have the > symbol < and the "Less" before the "Greater. But the answers remain.

Best to you and see you!

Assignment #1

For each of the 4 cases, write the corresponding formula.

I will post the solutions on Sunday... but try to do it before then.

How to compare Histograms in Excel

Recently someone asked me to assist with a histogram chart. I have to admit, I had not done one for a couple of years and worried a bit. After a brief refresher online however, I was ready to help.

A histogram is done when you're trying to find out the distribution of a variable through a population. Online examples abound but the most common one is grades in a population of students. I'll differ from that tradition. My variable is a medical condition across a population of patients of varying ages. High Blood Pressure or HBP.

Doing a histogram in Excel is not hard. It's a bit tricky, but have no fear, Marco is here...(sorry, could not resist, lol).

A histogram requires a few things:
a) The data array (Patient Ages)
b) The groupings or intervals: The lowest age of the group is 36 and the oldest is 88. So we have to find a way to segregate them into several groupings. Later we will see how to do this.
c) The Bins: The highest number for each interval
d) The Frequency: This is where Excel does it job using Array Formulas. The trick to Array Formulas is knowing that you have to hold down 3 keys after entering the formula in the cell. Again, more of that later. Just know that this is very important.

Since you already have the data, you must define the rest. Below I prepared a graphic of the above rules using the example discussed:

Now that we have the outline, let's dig a little deeper into a real example with a second variable: another medical condition: Diabetes.

This will make things a little interesting because by introducing a second variable, we now have 3 groupings.

1) Those patients with only HBP

2) Those with Diabetes and

3) Those with both conditions.

If the patients had none of the conditions, they would not be in our histogram, so that's not an option.

A word about Excel's Frequency formula. The Formula calls for the Data Array and the Bin Array. While the Bin Array does not change for all 3 groupings in our example, the Data Array does change for each.

In other words, the HBP group formula only needs the patients where HBP = Yes AND Diabetes = No. Similarly, the Diabetes group's data array is the group of patients where HBP=No AND Diabetes = Yes.

Another point to highlight is that if you add up all the groupings, they total 197 patients. This is important as you must account for all the data.

And now for a shocker... A true Histogram cannot have gaps between the columns. In other words, what I have here is not a true Histogram because of the gaps. However, the methodology followed here is that of a Histogram.

While this chart is more of a Bar graph, it allows us to compare and contrast various groupings--something that a Histogram cannot do well by its very nature.

I hope this quick guide helps get you going.

Data Analysis: Example 2

Below is a typical set of data you will be working with. I found this set on the Internet but it will serve our purposes just right.

Our objective in this exercise is to:

clean this data to end up with accurate and unique records.

The first step is to get the data into Excel: Go ahead, copy it and paste it into Excel.

On the first pass, right away we notice that while each record has two bits of data, both are in the same cell:

a) A code and
b) A Name

The next set of problems to discover is that it contains typos, duplicates, etc. This is where you come in. Your job, should you accept it, is to clean up this data set to end up with a nice clean list of unique Codes and Names.

Since I've already completed the exercise, I'll give you a few tips:
> The starter set consists of 531 records.
> I ended up with 86 unique records.
Warning: Results may vary by + or - 5; but no more than that.

> I used the following features:
a) Text to Columns
b) Remove Dups
c) Conditional Formating: Highlight Dups
d) Apply Filters: Sort by Name

> I also used the following formulas:
a) Len(cell)
b) countif(cell)
c) text(cell,"000000")

I will post my approach solution a little later. Best of luck. Oh, and if you have any questions, ask.

NAICS Code

221112 - Fossil Fuel Electric Power Generation

211111 - Crude Petroleum and Natural Gas Extraction

22111 - Electric Power Generation

32512 - Industrial Gas Manufacturing

325120 - Industrial Gas Manufacturing

221112 - Fossil Fuel Electric Power Generation

325120 - Industrial Gas Manufacturing

221119 - Other Electric Power Generation

324110 - Petroleum Refineries

3152 - Cut and Sew Apparel Manufacturing

221119 - Other Electric Power Generation

541711 - Research and Development in Biotechnology

221119 - Other Electric Power Generation

312120 - Breweries

928110 - National Security

922140 - Correctional Institutions

221112 - Fossil Fuel Electric Power Generation

211111 - Crude Petroleum and Natural Gas Extraction

562212 - Solid Waste Landfill

22111 - Electric Power Generation

611310 - Colleges, Universities, and Professional Schools

221119 - Other Electric Power Generation

22111 - Electric Power Generation

221119 - Other Electric Power Generation

324110 - Petroleum Refineries

324199 - All Other Petroleum and Coal Products Manufacturing

3254 - Pharmaceutical and Medicine Manufacturing

22111 - Electric Power Generation

2211 - Electric Power Generation, Transmission and Distribution

221119 - Other Electric Power Generation

22111 - Electric Power Generation

311514 - Dry, Condensed, and Evaporated Dairy Product Manufacturing

3115 - Dairy Product Manufacturing

6113 - Colleges, Universities, and Professional Schools

22111 - Electric Power Generation

611310 - Colleges, Universities, and Professional Schools

331111 - Iron and Steel Mills

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

32731 - Cement Manufacturing

311421 - Fruit and Vegetable Canning

22111 - Electric Power Generation

332112 - Nonferrous Forging

22111 - Electric Power Generation

2123 - Nonmetallic Mineral Mining and Quarrying

32731 - Cement Manufacturing

22132 - Sewage Treatment Facilities

327993 - Mineral Wool Manufacturing

221112 - Fossil Fuel Electric Power Generation

212312 - Crushed and Broken Limestone Mining and Quarrying

522320 - Financial Transactions Processing, Reserve, and Clearinghouse Activities

237130 - Power and Communication Line and Related Structures Construction

324110 - Petroleum Refineries

211111 - Crude Petroleum and Natural Gas Extraction

221310 - Water Supply and Irrigation Systems

562212 - Solid Waste Landfill

22111 - Electric Power Generation

488119 - Other Airport Operations

22132 - Sewage Treatment Facilities

22111 - Electric Power Generation

221320 - Sewage Treatment Facilities

2213 - Water, Sewage and Other Systems

221330 - Steam and Air-Conditioning Supply

22111 - Electric Power Generation

321113 - Sawmills

311421 - Fruit and Vegetable Canning

324110 - Petroleum Refineries

324199 - All Other Petroleum and Coal Products Manufacturing

324110 - Petroleum Refineries

221112 - Fossil Fuel Electric Power Generation

311221 - Wet Corn Milling

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

311 - Food Manufacturing

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

326140 - Polystyrene Foam Product Manufacturing

311421 - Fruit and Vegetable Canning

32419 - Other Petroleum and Coal Products Manufacturing

221119 - Other Electric Power Generation

212399 - All Other Nonmetallic Mineral Mining

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

325199 - All Other Basic Organic Chemical Manufacturing

221119 - Other Electric Power Generation

22111 - Electric Power Generation

2213 - Water, Sewage and Other Systems

221112 - Fossil Fuel Electric Power Generation

327213 - Glass Container Manufacturing

312130 - Wineries

115114 - Postharvest Crop Activities (except Cotton Ginning)

22132 - Sewage Treatment Facilities

32411 - Petroleum Refineries

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

5622 - Waste Treatment and Disposal

221119 - Other Electric Power Generation

562 - Waste Management and Remediation Services

221112 - Fossil Fuel Electric Power Generation

211111 - Crude Petroleum and Natural Gas Extraction

324110 - Petroleum Refineries

221320 - Sewage Treatment Facilities

221112 - Fossil Fuel Electric Power Generation

311615 - Poultry Processing

22111 - Electric Power Generation

221320 - Sewage Treatment Facilities

311 - Food Manufacturing

221119 - Other Electric Power Generation

22111 - Electric Power Generation

221119 - Other Electric Power Generation

3254 - Pharmaceutical and Medicine Manufacturing

325188 - All Other Basic Inorganic Chemical Manufacturing

311230 - Breakfast Cereal Manufacturing

221112 - Fossil Fuel Electric Power Generation

327420 - Gypsum Product Manufacturing

221119 - Other Electric Power Generation

336413 - Other Aircraft Parts and Auxiliary Equipment Manufacturing

32213 - Paperboard Mills

22111 - Electric Power Generation

327211 - Flat Glass Manufacturing

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

311513 - Cheese Manufacturing

221119 - Other Electric Power Generation

321219 - Reconstituted Wood Product Manufacturing

221112 - Fossil Fuel Electric Power Generation

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

211112 - Natural Gas Liquid Extraction

311 - Food Manufacturing

221112 - Fossil Fuel Electric Power Generation

221320 - Sewage Treatment Facilities

322121 - Paper (except Newsprint) Mills

311421 - Fruit and Vegetable Canning

541711 - Research and Development in Biotechnology

221112 - Fossil Fuel Electric Power Generation

324110 - Petroleum Refineries

22111 - Electric Power Generation

221119 - Other Electric Power Generation

562212 - Solid Waste Landfill

322121 - Paper (except Newsprint) Mills

334413 - Semiconductor and Related Device Manufacturing

221112 - Fossil Fuel Electric Power Generation

5622 - Waste Treatment and Disposal

22132 - Sewage Treatment Facilities

562212 - Solid Waste Landfill

3115 - Dairy Product Manufacturing

327310 - Cement Manufacturing

311513 - Cheese Manufacturing

311 - Food Manufacturing

211111 - Crude Petroleum and Natural Gas Extraction

221112 - Fossil Fuel Electric Power Generation

336411 - Aircraft Manufacturing

336414 - Guided Missile and Space Vehicle Manufacturing

611310 - Colleges, Universities, and Professional Schools

221112 - Fossil Fuel Electric Power Generation

311 - Food Manufacturing

324110 - Petroleum Refineries

221119 - Other Electric Power Generation

21111 - Oil and Gas Extraction

221119 - Other Electric Power Generation

22111 - Electric Power Generation

928110 - National Security

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

22111 - Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

312120 - Breweries

327310 - Cement Manufacturing

22111 - Electric Power Generation

221119 - Other Electric Power Generation

22111 - Electric Power Generation

221119 - Other Electric Power Generation

22111 - Electric Power Generation

562212 - Solid Waste Landfill

2213 - Water, Sewage and Other Systems

311 - Food Manufacturing

3114 - Fruit and Vegetable Preserving and Specialty Food Manufacturing

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

928110 - National Security

311611 - Animal (except Poultry) Slaughtering

327310 - Cement Manufacturing

928110 - National Security

327420 - Gypsum Product Manufacturing

33611 - Automobile and Light Duty Motor Vehicle Manufacturing

22111 - Electric Power Generation

221119 - Other Electric Power Generation

22111 - Electric Power Generation

336411 - Aircraft Manufacturing

334419 - Other Electronic Component Manufacturing

562212 - Solid Waste Landfill

22111 - Electric Power Generation

221330 - Steam and Air-Conditioning Supply

221112 - Fossil Fuel Electric Power Generation

311 - Food Manufacturing

311421 - Fruit and Vegetable Canning

311423 - Dried and Dehydrated Food Manufacturing

22111 - Electric Power Generation

3221 - Pulp, Paper, and Paperboard Mills

921190 - Other General Government Support

221320 - Sewage Treatment Facilities

562212 - Solid Waste Landfill

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

221119 - Other Electric Power Generation

562212 - Solid Waste Landfill

327213 - Glass Container Manufacturing

562212 - Solid Waste Landfill

221320 - Sewage Treatment Facilities

211111 - Crude Petroleum and Natural Gas Extraction

311421 - Fruit and Vegetable Canning

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

31142 - Fruit and Vegetable Canning, Pickling, and Drying

32411 - Petroleum Refineries

22111 - Electric Power Generation

221119 - Other Electric Power Generation

2212 - Natural Gas Distribution

221112 - Fossil Fuel Electric Power Generation

2212 - Natural Gas Distribution

221112 - Fossil Fuel Electric Power Generation

2212 - Natural Gas Distribution

327211 - Flat Glass Manufacturing

922140 - Correctional Institutions

325193 - Ethyl Alcohol Manufacturing

211111 - Crude Petroleum and Natural Gas Extraction

211112 - Natural Gas Liquid Extraction

327211 - Flat Glass Manufacturing

32512 - Industrial Gas Manufacturing

541712 - Research and Development in the Physical, Engineering, and Life Sciences (except Biotechnology)

562212 - Solid Waste Landfill

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

325188 - All Other Basic Inorganic Chemical Manufacturing

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

221119 - Other Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

22111 - Electric Power Generation

221112 - Fossil Fuel Electric Power Generation

321212 - Softwood Veneer and Plywood Manufacturing

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

611210 - Junior Colleges

327213 - Glass Container Manufacturing

22111 - Electric Power Generation

562212 - Solid Waste Landfill

221112 - Fossil Fuel Electric Power Generation

32411 - Petroleum Refineries

22132 - Sewage Treatment Facilities

221119 - Other Electric Power Generation

311513 - Cheese Manufacturing

22111 - Electric Power Generation

486210 - Pipeline Transportation of Natural Gas

48621 - Pipeline Transportation of Natural Gas

22111 - Electric Power Generation

2123 - Nonmetallic Mineral Mining and Quarrying

21111 - Oil and Gas Extraction

311423 - Dried and Dehydrated Food Manufacturing

32411 - Petroleum Refineries

321113 - Sawmills

22111 - Electric Power Generation

321 - Wood Product Manufacturing

321113 - Sawmills

22111 - Electric Power Generation

321 - Wood Product Manufacturing

21111 - Oil and Gas Extraction

22111 - Electric Power Generation

92 - Public Administration

333611 - Turbine and Turbine Generator Set Units Manufacturing

562212 - Solid Waste Landfill

22132 - Sewage Treatment Facilities

562213 - Solid Waste Combustors and Incinerators

22111 - Electric Power Generation

2211 - Electric Power Generation, Transmission and Distribution

22111 - Electric Power Generation

31131 - Sugar Manufacturing

22111 - Electric Power Generation

311421 - Fruit and Vegetable Canning

221119 - Other Electric Power Generation

2213 - Water, Sewage and Other Systems

221119 - Other Electric Power Generation

22111 - Electric Power Generation

4244 - Grocery and Related Product Merchant Wholesalers

22111 - Electric Power Generation

331111 - Iron and Steel Mills

3314 - Nonferrous Metal (except Aluminum) Production and Processing

32411 - Petroleum Refineries

325188 - All Other Basic Inorganic Chemical Manufacturing

324110 - Petroleum Refineries

322 - Paper Manufacturing

221119 - Other Electric Power Generation

562212 - Solid Waste Landfill

31142 - Fruit and Vegetable Canning, Pickling, and Drying

221119 - Other Electric Power Generation

211 - Oil and Gas Extraction

221112 - Fossil Fuel Electric Power Generation

32731 - Cement Manufacturing

92811 - National Security

2123 - Nonmetallic Mineral Mining and Quarrying

327420 - Gypsum Product Manufacturing

324110 - Petroleum Refineries

31 - Food, Textile,& Leather Manufacturing

221320 - Sewage Treatment Facilities

511110 - Newspaper Publishers

488190 - Other Support Activities for Air Transportation

331511 - Iron Foundries

611310 - Colleges, Universities, and Professional Schools

6113 - Colleges, Universities, and Professional Schools

611310 - Colleges, Universities, and Professional Schools

6113 - Colleges, Universities, and Professional Schools

331221 - Rolled Steel Shape Manufacturing

32411 - Petroleum Refineries

2211 - Electric Power Generation, Transmission and Distribution

211111 - Crude Petroleum and Natural Gas Extraction

331492 - Secondary Smelting, Refining, and Alloying of Nonferrous Metal (except Copper and Aluminum)

22111 - Electric Power Generation

562212 - Solid Waste Landfill

339999 - All Other Miscellaneous Manufacturing

22111 - Electric Power Generation

2211 - Electric Power Generation, Transmission and Distribution

221112 - Fossil Fuel Electric Power Generation

311 - Food Manufacturing

22111 - Electric Power Generation

Nav