Hello World. I'm talking about decision tables.

I have some criteria for a new office assistant.

Ideally we would like the person to know Word, Access and Excel and type at least 50 words per minute.

We probably aren't going to find people with all those skills.

So we have the following criteria: tThey must know Word.

If they also know both Access and Excel.

They only have to type 30 words per minute.

If they also know either Access  or Excel, we will interview them if they type at least 50 words per minute.

So, let's make a table for these rules.

So, our columns.

Are going to be Word,

Access,

Excel,

Words per minute.

And...

the result , which is whether we call them for an interview.

Now, Word, Access, and Excel.

Are going to have values of yes or no. so I'm going to just start out and put no

In all of those columns to start with.

And, Words per minute,

I'm not going to put every value of words per minute but let's group them. They either

have less than 30 words per minute.

They have between 30 and 50 words per minute or they type more than 50 words per minute. So, for words per minute.

I'm going to have less than 30.

30 to 49.

and 50.

or more.

The number of columns [rows], let's just do the...

It's going to be equal to.

I mean the number of rows.

Is equal to.

The number of values, possible values, for each of these columns multiplied together so it's 2 for Word.

times 2 for Access.

Times 2 two possible values for Excel times 3 possible values for words per minute.

So we should end up with 24 rows. Now remember we have the heading in one so we should end up down here when we get finished.

So...

For each of the possible values of Words.

per minute.

I want to have Word, Access and Excel all be

No.

Now, after 50, I'm going to go back to the beginning.

And then go.

<30

Increment this to the next value.

Keep the rest of the rows the same.

Increment this.

And we have thirty to 49 words per minute.

And since we imcremented this.

Those rows stay the same COLUMNS  stay the same.

And now we have 50 or more.

And since we incremented that

these stay the same.

Now we go back to the beginning here.

We're already at the end we did no, we did yes, so we go back to the beginning here.

And then go an increment this column

Keep that one the same.

Now...

If you see a pattern.

You could do some copy and paste and save some time but I'm going to go through this Brute Force. This was incremented

So the other.

Columns stay the same.

We're going to implement this to the next value.

Since we were able to increment that the others stay the same. Now we go back to the beginning, because we're at the last value.

That means we have to imcrement this.

So we go to yes.

And you keep the other.

Columns.

30 to 49.

That was incremented.

So these are going to stay the same.

And now we go to 50 or more.

And that was incremented.

So all of these stay the same.

And then we have.

Back to the beginning.

Less than 30.

And we went back to the beginning so we're going to imcrement this or we're the last value should we go back to no.

And we went back so we're going to imcrement this.

And so that becomes back to the beginning.

And then we go here.

And we increment..

that to yes.

OK?

At this point if you're paying attention to the pattern here.

We have.

These.

12 rows.

Are going to be repeated down below but just changing Word to yes.

Let's do that.

And copy and paste.

And.

Change this to yes.

Just drag that down.

And there's our complete table. and do we have 24 rows? Yes, because this one is that.

Header, so this is.

24 of data. That's good The Next Step here is to fill in whether we're going to call them for an interview and then after we fill in that result in the next video I'm going to show you how to reduce this table.

But if you can generate that table it's just like counting.

And you increment the ones place and if you're at 9 you go to the tens place and if you're at 9 there you go to the hundreds place and increment there and you can think of it as count it's very helpful. And that's it for now.