 So one of the things that we can do inside of Excel is we see we have sort of this little breakdown on the cost of a project now Since obviously this is just one Estimation of it what I could do is I could come in here right click copy move boom yay now I have two copies of it. I've got two ones that I can work off of well I don't want to do that because what happens if I have ten different scenarios or twenty different scenarios It would be really nice if Excel sort of allowed me to have one sheet and it worked off of that That's actually what the what-if analysis scenario manager allows us to do so in our case We click on it. The first thing we see is there are no scenarios to find Well, let's go ahead and define sort of this as our original type of scenario So the first thing I'm gonna do is I'm gonna call in I'm just gonna name this scenario the original But now all of a sudden changing what sells well, I need to sell change D9 D10 D11 So I'm gonna go ahead and come in and just click hold drag I'm gonna go ahead and hit okay You see that it'll give me just oh, what do we want these values to be this scenario in our case? I'm gonna go ahead and hit okay Now I have suddenly this scenario and right now it doesn't do terribly much But let's go ahead and add in another one and this time we're gonna go ahead and say well Let's say we hired a single contractor They did regular 300 hours, but they also worked some overtime. So a single contractor with overtime Let me go ahead and fix that Single contractor with no time we hit okay. We're gonna leave this as a one We're gonna leave this as a 300, but we're gonna change this to say that they worked 40 extra hours Well, we hit okay. Nothing changed over here, but you see we have two scenarios all of a sudden Right now I'm in my original scenario, but if I come over here to single contractor, I can click show And look what happened over time just went to 40 and we can see how many hours were worked $18,000 I don't want to pay $18,000. So let's see if we can make another scenario this time I'm gonna hire instead of one contractor and pay him overtime I'm gonna pay two contractors to do this work So I come in Multiple contractors No overtime. I still have the same cells being selected. I hit okay D9 this time of all of a sudden I'm gonna do a 2 Now I'm gonna leave this as a 0, but I'm gonna go ahead and change this and obviously I'm just gonna play around with this First I'm gonna go ahead and say that I still want 300, but I want it to be equal to 300 Divided by two two coming from the D9. I'm gonna go ahead and hit okay I do get a little bit of a hey, you know things are doing weird stuff's happening This is just turning into a value And that's what it's gonna do because when I hit show All of a sudden I can see that by hiring two contractors Splitting the amount of hours they both have so they only work a hundred and fifty each It's gonna be same amount same amount of work. Just two people is gonna be cheaper Than the single contractor now the last thing I can do is I can also come in here and I can Select this option called summary Now as you can see who makes all these different things What do I want to be reporting off of for example? We'll go ahead and leave it as is But when I hit okay, all of a sudden I get a new little chart here that shows me each one of my scenarios and The cost breakdown of what each one is going to be pretty nice