1 00:00:00,700 --> 00:00:06,040 Like lots of things in Excel, there are multiple ways to solve this problem. 2 00:00:06,040 --> 00:00:08,980 I'm going to show you what I think is the fastest way. 3 00:00:10,020 --> 00:00:15,488 Using the sort tool, I'm going to select the data I want to sort. 4 00:00:15,488 --> 00:00:20,620 Shift + Ctrl, down, right. 5 00:00:20,620 --> 00:00:21,960 So I've got all my data selected. 6 00:00:21,960 --> 00:00:26,952 And then using another keyboard shortcut Alt, go to A for Data, 7 00:00:26,952 --> 00:00:28,621 and then SS for Sort. 8 00:00:31,241 --> 00:00:33,896 And I haven't selected the data header rows, so 9 00:00:33,896 --> 00:00:35,920 that should remain unchecked here. 10 00:00:36,980 --> 00:00:40,370 And I'm not trying to sort by the mine site, 11 00:00:40,370 --> 00:00:43,090 I'm trying to sort by the cost to produce. 12 00:00:43,090 --> 00:00:48,780 So I'm gonna go column B, and yes, I wanna do smallest to largest. 13 00:00:48,780 --> 00:00:51,240 I wanna see the cheapest to produce on the left, and 14 00:00:51,240 --> 00:00:53,210 the most expensive to produce on the right. 15 00:00:55,240 --> 00:00:55,800 And voila. 16 00:00:57,190 --> 00:00:59,950 So why might this be helpful? 17 00:00:59,950 --> 00:01:01,800 Well, in this example, 18 00:01:01,800 --> 00:01:06,480 we are looking at production costs for a hypothetical commodity. 19 00:01:06,480 --> 00:01:08,200 Let's just pretend its nickel. 20 00:01:08,200 --> 00:01:12,522 Let's imagine that the current price of nickel on the world 21 00:01:12,522 --> 00:01:14,604 market is $40 per pound. 22 00:01:14,604 --> 00:01:18,372 So I'm going to insert a shape, 23 00:01:18,372 --> 00:01:22,848 a line to show what the current price. 24 00:01:22,848 --> 00:01:29,880 is And let's make this line a little bit thicker. 25 00:01:29,880 --> 00:01:38,330 So I'm gonna right click on it, Format Shape and make the width 2. 26 00:01:38,330 --> 00:01:42,250 And I'm gonna make it black so it's a little bit easier to see. 27 00:01:44,340 --> 00:01:47,850 Okay, so we know that this is the current world price for 28 00:01:47,850 --> 00:01:50,700 this nickel, the nickel commodity. 29 00:01:50,700 --> 00:01:53,300 All these mines would be making money, or 30 00:01:53,300 --> 00:01:57,910 breaking even all else equal, given the current price. 31 00:01:57,910 --> 00:02:02,970 However, let's say the price of nickel drops to about $25 per pound for 32 00:02:02,970 --> 00:02:03,830 whatever reason. 33 00:02:05,630 --> 00:02:10,320 So I drop down the line to show the world price, down to 25. 34 00:02:10,320 --> 00:02:13,960 Having a chart like this would allow us to more quickly 35 00:02:13,960 --> 00:02:16,900 identify which mines would no longer be profitable. 36 00:02:18,180 --> 00:02:22,980 So if you're responsible for the mines below this line, you'll be sleeping 37 00:02:22,980 --> 00:02:27,280 a lot more peacefully than if your job is to manage the mines of this line