1
00:00:00,05 --> 00:00:03,08
- [Instructor] Okay, so let's make those EVM equations.

2
00:00:03,08 --> 00:00:07,05
Over here, under I, I'm going to type in SPI

3
00:00:07,05 --> 00:00:09,04
for scheduled performance index.

4
00:00:09,04 --> 00:00:14,09
Then in column J, I'll do CPI for cost performance index.

5
00:00:14,09 --> 00:00:25,00
And then in K, I am going to write safety incident count.

6
00:00:25,00 --> 00:00:28,09
So for the SPI, recall that that's going to be the earned value

7
00:00:28,09 --> 00:00:31,05
divided by the planned value.

8
00:00:31,05 --> 00:00:37,05
And the cost performance is going to be the earned value

9
00:00:37,05 --> 00:00:39,08
divided by the actual cost.

10
00:00:39,08 --> 00:00:42,05
And it's always a good idea when you do these divisions

11
00:00:42,05 --> 00:00:45,00
just to put an if error around it.

12
00:00:45,00 --> 00:00:46,05
So we're going to make that zero here,

13
00:00:46,05 --> 00:00:50,00
and then same deal over here.

14
00:00:50,00 --> 00:00:52,08
And then, finally, we want to do the safety incident count.

15
00:00:52,08 --> 00:00:57,03
So in this case, we're going to do a count if,

16
00:00:57,03 --> 00:01:02,03
and the range is going to be over on safety incidents.

17
00:01:02,03 --> 00:01:07,04
We're just going to do the entire project list here.

18
00:01:07,04 --> 00:01:08,06
I'll hit comma right over here,

19
00:01:08,06 --> 00:01:11,06
and then we'll go back to project data

20
00:01:11,06 --> 00:01:13,01
and select the project name over here.

21
00:01:13,01 --> 00:01:15,01
So this is just going to link the two tables.

22
00:01:15,01 --> 00:01:16,07
If it finds that name there,

23
00:01:16,07 --> 00:01:19,05
that means that there is a safety violation.

24
00:01:19,05 --> 00:01:21,06
Okay, and so now we have our count.

25
00:01:21,06 --> 00:01:24,03
So now we have our metrics that we are going to use

26
00:01:24,03 --> 00:01:27,00
to create our dashboard.