The Copper Emissions Model spreadsheet contains production, energy and cash cost data for 133 mines producing at least 85% of western world iron ore by 56 producer companies in 22 countries. The Zinc model covers 74 mines operated by 37 companies in 18 countries, The Lead model covers 57 mines operated by 32 companies in 13 countries and the Nickel model has 62 mines operated by 35 companies in 18 countries.

Mine production numbers are based on year 2009 actual input costs and production data and estimates for 2010.

The Emissions models contain sufficient code from all the minecost mine models to run independently and to allow users to change operating parameters. Minecost models are built around engineering equations originally developed by the US Bureau of Mines for its Cost Estimation System. The models estimate fuel and power consumption as a component of mine cash operating costs. The fuel and power usage estimates from the models are linked into the Emissions models. These numbers are verified where possible against published sustainability statements and other information. The data is used by the Emissions model to estimate carbon dioxide emissions using known energy and CO2 coefficients for various fuels (these may be changed by the user)to estimate direct CO2 emissions. Indirect emissions from electric power suppliers are estimated from data collected on the power generation mix for each mine and known power conversion efficiencies and CO2 emissions for generation fuels (also changeable by the user).

Complete models of each mining operation are available from http://www.minecost.com. The calculation sections of each model are incorporated into this spreadsheet so that all tables and charts are re-calculated when any of the variables in the Edit sheet are changed and/or any data is sorted. The data from each model and all calculations that control the data tables and charts are in the hidden "calcs" sheet. This can be unhidden if needed.

The Edit sheet contains all the variables which may be changed by the user. These include all electric power sources and generation fuels for each mine, carbon emissions coefficients and energy for each fuel type, and the level of any carbon tax for each producer country. Variables which may be changed by the user are colored grey. Comments are in blue. Options for displaying the charts are also in the Edit sheet. Users may input a carbon tax for each producer country. This will automatically show up in the cost tables and charts.

The Data sheets contain the numbers used to generate the charts. These numbers are estimated by the model calculations in the hidden "calc" sheet and must not be changed. The data in the grey areas may be sorted by mine name, production, energy and CO2 variables, operating cash cost, operator and country. Sorting data in the tables will automatically change the corresponding charts. All Data Tables contain data for mines, producer companies and countries.

• Energy Data lists each mine, producer company and producer country by kt metal production, ore milled, onsite diesel fuel usage in litres/ton ore, electricity in kWh/t ore, offsite (concentrate transport to the smelter, and for mine-smelter complexes, smelting and refining) diesel fuel equivalent in l/t ore, and offsite electricity in kWh/t ore, total energy use in kWh/t ore, electric power generation fuels - coal, oil, natural gas, nuclear, hydro & renewables and diesel - and the supplier utility. Copper mine-smelter complexes are Bingham Canyon, Chuquicamata, El Teniente, Salvador, Flin Flon, Kidd Creek, Mufulira, Mt Isa, Vale Inco, Xstrata Sudbury, Olympic Dam and Ray/Hayden. There are no complexes in the zinc and lead models, but the nickel models contain all smelters and refineries treating nickel mine production.
• Ore CO2 Data lists each mine, producer company and producer country showing CO2 emissions in kg/t ore milled from onsite diesel and electricity and offsite (shipping and metallurgical) diesel equivalent and electricity, and total CO2 emissions per ton of ore milled.
• Metal CO2 Data lists each mine, producer company and producer country showing CO2 emissions in kg/kg metal from onsite diesel and electricity and offsite (shipping and smelter-refinery for complexes) diesel equivalent and electricity, and total CO2 emissions per kg metal. For polymetallic mines, CO2 emissions are weighted by metal production: e.g. if copper represents 50% of metal produced at the mines, then copper carries 50% of the emissions.
• Revenue CO2 Data lists each mine, producer company and producer country showing CO2 emissions in kg/kg metal from onsite diesel and electricity and offsite (shipping and smelter-refinery for complexes) diesel equivalent and electricity, and total CO2 emissions per kg metal. For polymetallic mines, CO2 emissions are weighted by metal values: e.g. if copper represents 50% of metal values produced at the mines, then copper carries 50% of the emissions. So a copper-gold mine would show copper's share of emissions to be much lower on a value-weight basis than on a metal-weight basis.
• Total CO2 Data lists each mine, producer company and producer country by kt metal and Mt ore milled showing total CO2 emissions in kt from onsite and offsite diesel fuel and electricity and total CO2 emitted in kt CO2.
• Energy Departments Data lists each mine, producer company and producer country showing energy consumption in kWh/t metal and in GJ/t metal for onsite mining and milling, offsite shipping, metallurgical processing and total energy.
• CO2 Departments Data lists each mine, producer company and producer country showing CO2 emissions in metric tons/metric ton metal for onsite mining and milling, offsite shipping, metallurgical processing, and total CO2t/t metal.
• Cost Data lists each mine, producer company and producer country by kt metal showing cash operating costs in c/lb paid metal for mine, mill, transport, TC/RC and royalty and also for labor, energy, reagents, other onsite, offsite costs (shipping and TCRC), plus carbon tax on total CO2 emissions, less byproduct credits. For each mine the table shows which metals are co-products and which metals are by-products, according to the settings chosen by the user in the Edit sheet.

The Chart sheets contain the energy, CO2 and cost curves for each mine, producer company and producer countries. Note that the chart titles, legends and stacked bars automatically change according to the user-selected options of displaying onsite mine numbers and mine plus offsite transport numbers. You can also include or exclude smelter-refinery numbers for mine-smelter complexes. Note that for the cost curve charts the titles, legends and stacked bar divisions are independently selectable between activity (mining, milling, transport, smelting & refining) or inputs (labor, onsite fuel and power, other onsite inputs, plus offsite costs) or just cost totals.

For all charts you may select which mine and company names are displayed by setting maximum and minimum production levels, or by simply using the names display switches in the yellow columns in any or all of the data sheets. This degree of control over which mine/company name labels are displayed in the charts is to permit users to display one, some or all names as required.

• Mines Energy Chart ranks each mine by kilowatt hours equivalent energy consumption per metric ton of ore milled. Each bar represents each mine; the width corresponds to ore milled and the height corresponds to total energy consumption. The bar divisions are for diesel energy and electricity.
• Companies Energy Chart ranks each company as above for the mines.
• Countries Energy Chart ranks each producer country as above for the mines and companies charts.
• Mines CO2 Ore Chart ranks each mine by kilograms CO2 emitted per metric ton of ore milled. Each bar represents each mine; the width corresponds to ore milled and the height corresponds to total CO2 emitted. The bar divisions are for CO2 from diesel and CO2 from electricity - roughly corresponding to direct and indirect CO2 emissions.
• Companies CO2 Ore Chart ranks each company as above for the mines.
• Countries CO2 Ore Chart ranks each producer country as above for the mines and company charts.
• Mines CO2 Metal Chart ranks each mine by kilograms CO2 emitted per kg metal produced. Each bar represents each mine; the width corresponds to metal produced and the height corresponds to total CO2 emitted. The bar divisions are for CO2 from diesel and CO2 from electricity - roughly corresponding to direct and indirect CO2 emissions. Note that for polymetallic mines, CO2 emissions are weighted by metal production: e.g. if copper represents 50% of metal produced at the mines, then copper carries 50% of the emissions.
• Companies CO2 Metal Chart ranks each company and producer grouping as above for the mines.
• Countries CO2 Metal Chart ranks each producer country as above for the mines and company charts.
• Mines CO2 Revenue Chart ranks each mine by kilograms CO2 emitted per kg metal produced. Each bar represents each mine; the width corresponds to metal produced and the height corresponds to total CO2 emitted. The bar divisions are for CO2 from diesel and CO2 from electricity - roughly corresponding to direct and indirect CO2 emissions. This time for polymetallic mines, CO2 emissions are weighted by metal values: e.g. if copper represents 50% of metal values produced at the mines, then copper carries 50% of the emissions. In this case a copper-gold mine would show copper's share of emissions to be much lower than on a metal-weight basis.
• Companies CO2 Revenue Chart ranks each company as above for the mines.
• Countries CO2 Revenue Chart ranks each producer country as above for the mines and company charts.
• Mines Total CO2 Chart ranks each mine by thousand metric tons of CO2 emitted at each mine. Each bar represents each mine; the width corresponds to copper produced and the height corresponds to total CO2 emitted. The bar divisions are for CO2 from diesel and CO2 from electricity - roughly corresponding to direct and indirect CO2 emissions.
• Companies Total CO2 Chart ranks each company and producer grouping as above for the mines.
• Countries Total CO2 Chart ranks each producer country as above for the mines and company charts.
• Mines Energy Department Chart ranks each mine by gigajoules of energy per metric ton of metal. Each bar represents each mine; the width corresponds to metric tons of metal and the height corresponds to GJ energy per ton of product. The bar divisions are for energy used for mining and milling onsite, offsite shipping and for smelting-refining at complexes.
• Companies Energy Department Chart ranks each company as above for the mines.
• Countries Energy Department Chart ranks each producer country as above for the mines and company charts.
• Mines CO2 Department Chart ranks each mine by metric tons of CO2 emitted per metric ton of metal. Each bar represents each mine; the width corresponds to metric tons metal and the height corresponds to tons CO2 per ton of metal. The bar divisions are for CO2 emitted in mining and milling onsite, CO2 from offsite shipping and for CO2 from smelter-refineries at complexes.
• Companies CO2 Department Chart ranks each company as above for the mines.
• Countries CO2 Department Chart ranks each producer country as above for the mines and company charts.
• Mines Cost Chart ranks each mine showing kt paid metal produced and cash operating costs in c/lb paid metal for mine, mill, transport, TC/RC and royalty. The bar width corresponds to metric tons of metal prduced and the height corresponds to total cash cost in c/lb paid metal. The bar divisions are for c/lb total cost of mining, milling, shipping, royalties and TC/RC. Alternatively the chart will display the bars for labor, fuel & power, other onsite costs and offsite (shipping and TC/RC) according to the display setting selected by the user. An additional bar showing the carbon tax effect on total costs is added when a carbon tax is input in the edit sheet. If the cost curves include by-product credits (as set by the user in the Edit sheet) the chart shows the by-product credits as bars "below the line" with the same stacked bars for mine, mill and offsite or labor, fuel and power, plus carbon taxes. This way of showing credits (which is selectable by the user)is useful because the contribution of byproduct credits to overall cash cost is immediately apparent.
• Companies Cost Chart ranks each company as above for the mines.
• Countries Cost Chart ranks each producer country as above for the mines and company charts.