 Yn y cwmhiliad, mae gweithio'r fideo yma o'r cyfleoedd yw'r cyffredig yn ymddangos. Mae'r diagram ond ei wneud o'r tythio'r cyffredig yn ymweld ar hyn yw... Felly yw'r bod yn dweud i'n dyn nhw'n ddysgu o'r holl ymdau, yw'n ddod eich cyffredig o'r cyffredig yn ni'n ddysgu yw'r cyffredig. Felly mae gennych y dyn nhw'n ddyn nhw, a maen nhw'n ddyn nhw lle eich cyffredig yn 50, Felly, mae gennym ni'n gwybod yw'r gweithio'r cyfnod o'r 5. Mae'r gweithio'r diagram yn ymgyrch. Mae'r gweithio'r gweithio'r gweithio'r 26. Felly mae'n cael ei ddweud o'r gweithio'r gweithio, ac mae'n gweithio'r gweithio ar y llwyllach, oedd yn y ddwy'r gweithio'r gweithio. Ac mae'r twyr o'r cyfrifiadau yn 26-5. Felly, mae'n gweithio'r gweithio'r 1 o'r gweithio'r gweithio'r gweithio? Fe yna bryd o ddaeth i am ddidd оч toast cofnolaeth oedradd-Ormychsal oelleadio ei ddweudio gweithio arno NEW Mae'r ddweudio sicrho sydd oedd y maesawd digon nhw. Mae'n meddwl o'rnoch gyda blaillio ez Gertrwane. Mae'n dod i mesurio. Felly mae haar eich gwleigio ar gweithio'r Greithilee sydd yn eu meddwl o'r lines.�료 sydd erir. Fe yw'r gweithio arni fel dangor gweithio� Williams bandf braking podcast o'r gwleithio. ydych chi'n gweld? Yn ystod dwi'n ddim o'n mynd i ddim yn ymdweud y tawddol a'r trafoddol a'r ddau, ond rydym ni'n dweud y cyfaciliad y bwret. Yn ymwysgrifeth, mae'n fwy o 50cm ac rwy'n dweud ymwysgrifeth. Yn ymwysgrifeth, ymwysgrifeth, ymwysgrifeth. Dwy'n dweud ymwysgrifeth. Yn ymwysgrifeth, mae'n dweud ymwysgrifeth. Yn ymwysgrifeth, mae'n dweud 99 ym 100, ym 100 mae'n dweud ymwysgrifeth, ac rwy'n dweud yn dweud ymwysgrifeth? Dwy'n dweud dyma'n Grin teisw principleau, dysgu 25cm sy'n gweld ac rwy'n dweud hyn ymwysgrifeth, dweud ymwysgrifeth rwy'n dweud ymwysgrifeth. Felly'r rwyf gwell yn llwyddi. A'r gwybod yw'n gwneud am hynny'n wych. Yn ymwysgrifeth yma, ac rwy'n mwy o'r llwyddiol ac oeddiw. input. Right, so now someone wants to come along and fill those numbers in if they can. So we're going to build a stacked bar chart but what are we going to make that stacked bar charting? We can't just highlight all of these and add in a graph that's not going to work like that. So we need to figure out kind of how much is remaining in the burette, how much was used, and well the error at the top. So you don't need to at this point do the labelling because no one else is going to see this in the background but it might be useful to keep an eye on it. So well the used is, well we're going to calculate this separately, it's going to be the ending point minus the start point, so that's how much was used. The error is obviously going to be the start point and then the remaining amount, well that's the capacity minus the end point, isn't it? So if we add all of those up we realise it adds to 50. Okay there are a couple of things that we can actually now do to make this a little bit more flexible. So what if, I'm going to set this end point to 20 for a moment, what if it was a smaller burette and it was 25? So what we want to do is try and get these numbers not as raw numbers but as percentages. So in the first instance I'm just going to take all of that and divide it by the capacity. So each of these wrapping brackets around it, divide by the capacity, don't need to wrap brackets around this one but divide by capacity. Now that adds up to 1, if I change the capacity back to 50 still adds up to 1. That makes things a little bit neater, especially when we bring in a bar chart later, the axis is going to always be between 0 and 100% which is really useful if we want to add this flexibility where we don't really know what the capacity is going to be in advance. We want to give you a user that flexibility. Now let's have a look again. Let's go back and have a look at what happens as you fill this in. We've got 50, the capacity of the starting point is 5, and what you might notice is that the amount used now becomes negative. That's not really brilliant, is it? We never at any point have a negative number here, so that will screw with any graph. So instead we're going to try and get rid of this where it's going to subtract these two things together if that's blank. You can do that with this statement, you can do it with all the fancy things, but what I'm going to do is use max and then inside that max formula just put in both of those. Now what that's going to do is it's going to find the largest of these values and subtract the starting point away from that. So this is blank, the ending point is blank, it's going to count it as 0, so it's going to take away from 5. So there you go, at the very beginning the amount used is 0. So if our end point was in fact higher, well it's going to come out as being used as 0, isn't it? But if the ending point is a bit further down the purette, it calculates it correctly. Now what else? Our remaining is in fact at this point kind of incorrect as well, because this is going to add up to more than one. Great, so let's rethink this from scratch. Well we only need to know what is the remaining actually. We don't really need to know anything about the capacity at this point. So actually let's just do equals 1 minus the amount used, minus the amount that's there. Ah, now it's always going to add up to the right amount. You get rid of that, the remaining amount is 1 or 98% of it. So it's now starting to work a bit better, it's given these values. And I'll just insert that bar graph now, just so you can see how that's going to work. So if we go to insert the bar chart, it hasn't quite worked because it hasn't stacked them. So we just go to switch rule column, now they're all on top of each other. And I'll start getting rid of a couple of things just to tidy it up. So you can see it, make it a bit smaller. And you can kind of see what's going to happen here. If my starting point is a bit lower, that grey area is a bit smaller because that's going to be the air at the top. The ending point is a bit lower, then the remaining goes down and the titra gets larger. So what else do we need to do here? Well one of the important things is I've got to go into this axis by double clicking it. And I'm just going to make sure that the minimum is set to 0 and the maximum is set to 1. So, as long as these big reset buttons appear, that's then locked in place. The last thing you want to do is, if you mess around with anything, that it starts rescaling this. Otherwise it'll not work. This is part of the reason why you end up dividing by the capacity to make this actually kind of more of a percentage. So now no matter what this is or what order we start sticking things in, it's always going to be scaled correctly. It's the next thing. I'm going to just delete these axes, select them, hit the delete key. Nothing really fancy. I'm going to make sure I've got an end point in here. And then it's all just case of formatting. So this top one, I'm going to click the grey one, come to format. Shape fill, no fill. Get rid of any fill there. And the middle one, shape fill. I'll go to texture and kind of more textures. Pattern fill, this is the one. I'll usually just pick kind of a bubbly looking one. Maybe a bit of a wish. Maybe a lighter blue than that. And then just add an outline to it as well so I can see it. And the bottom one, well that's the same blue as on that diagram, which I'll show you in a moment. So this is it. I'm just going to clear the outline. In another point, I'm going to set the starting point as zero. So this is as tall as it gets. Make it a bit thinner, put it somewhere, and then bring this to the front or copy and paste it to the right place. And then just going to resize them to sit on top. So maybe I'll make this a little bit thinner. Make sure I remove the outline from the whole graph. Once I remove the grid lines from Excel, there you go. Now it looks like it's kind of in place. So I just need to hand just that just a little bit. But now suddenly it's starting to look right. Change the class to 50. Oh, now it's empty the bureaucrat completely. Let's move it a little bit wider. The end point is 25. You can see it came half-wiffle. If the starting point was 10, you can see we kind of started a little bit earlier. So that's it. So the main thing there is you can probably delete these labels if you don't need them anymore. Maybe make that white or hide the thing. And then move that over the top of it, put it in the right place that you want. And there you go, you've got your titration simulator right there.