Fill in a Spreadsheet with Data

Working off of the USGS website (link here: [login to view URL]) we’d like to have data pulled for the following commodities: • Lime • Bauxite & Alumina • Iron & Steel • Salt • Nitrogen (fixed), Ammonia For each commodity you will be referencing the Mineral Commodity Summaries. A sample for Bauxite and Alumina is linked here: [login to view URL] From each of these PDF files going back through 1991 (the 1996 file will give you 5 years of historical data) we’d like the following data points pulled into a spreadsheet and organized by commodity: • U.S. Capacity (as available) • U.S. Production • Imports into the U.S. • U.S. consumption (sometimes referred to as "apparent consumption") • U.S. average price Occasionally, the data points given can vary between commodities so if you have any questions feel free to email me.