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