|
These images are from the sample cost curve spreadsheet for 2000 - in practice you get a spreadsheet for each year 2000 to 2006. To save space and to speed up the display we have truncated the tables. Note also that the numbers have been scrambled - but you can still see how the spreadsheets work.
The first sheet contains instructions and explains the underlying assumptions used to draw the curves. 
The Data sheet contains all the raw data used to draw the curves. Data is included for costs on a pro-rata basis and after byproduct credits, and for onsite mine and mill costs. You can change any of the numbers and even add new mines to the spreadsheet. Note that the sheet has been broken up into three images for display purposes. 
Then there are the cost curves which are automatically re-drawn if any of the input data changes. The spreadsheet contains three curves - one ranked on cash costs in c/lb after byproduct credits, one ranked on pro-rata cash costs in c/lb without credits, and one ranked on mine and mill costs in $/t. The mine name labels are also re-sorted and placed in the correct position. You can select which labels display by changing the settings in the Data sheet. 
Finally you get formatted tables ranked in order of cost, showing each mine, its production, cash operating cost and ranking assumptions. 
The flexibility of the data and mine name label sorting routines allow you to draw new cost curves raked on different criteria. Here is a cost curve ranked by producer and another ranked by country. 
|