William Rosener: Hello welcome back in this video you'll learn more about extending Google sheets, as we work with formulas and charts let's start by taking a look at what you want to create and then we'll walk through the steps there.
William Rosener: So we're going to allow the user, right here, and then he to allow the user to enter a value for Celsius.
William Rosener: They were an automatically convert that to Fahrenheit both using the formula and then also tie press send a command button is I just did right there.
William Rosener: supposed to change this to 100 when I hit the enter key to Formula one it's going to automatically be completed that have to come over here and press on Celsius to Fahrenheit to get this information to be updated.
William Rosener: i'm not you guys work with i'm gonna get you all the code here for the Celsius to Fahrenheit.
William Rosener: Just to challenge a little bit here i'm willing to do niches two centimeters exact same thing and then we're gonna go ahead and create a command button here again.
William Rosener: exam 123 and four i've got some scores here and i'm just going to press on Crete chart and I can see that that's going to go ahead and create a chart if I was to change one of these values, maybe i'll put in 60 here it I create chart.
William Rosener: I can now see that.
William Rosener: chart is yours exam 123 and four easily visualized students has been going the wrong direction here.
William Rosener: Okay let's get started here, so the first step, you don't want to do is you're going to want to when you're hopefully get your Google account.
William Rosener: you're going to press on the little dots appeared open Google Apps you're going to press on the drive button.
William Rosener: And you're going to come right over here and file new and choose Google sheets so Google sheets okay well in the same area as you found a link to this video i'll go ahead and get some code up there just save a little time and Gary.
William Rosener: Moore just our data here.
William Rosener: So me and maybe stretch this out a little bit here.
William Rosener: Okay, and there we go just kind of save a little time okay So the first thing we're going to be doing is working with the Fahrenheit the Formula one and we'll be right in a formal very simple here and will be credited command then do the same thing there.
William Rosener: Okay, so we're supposed to do is come right up here to tools i'm gonna choose a script editor that's going to open up a javascript editor.
William Rosener: And just to save a little time on it's going to come right over here and copy it and they'll just delete this code right here.
William Rosener: and paste, so this is going to be see at Celsius to Fahrenheit and the formula, there is going to be Celsius times 1.8 plus 3832 okay i'm going to go ahead and save this.
William Rosener: And typically when I run it i'm not sure if it's going to do right now.
William Rosener: Well, actually I haven't connected as soon as I run maybe that's soon as I connected run it and i'm going to get a security warning don't have to authorize Google okay let's just go ahead and grab that right there and copy it.
William Rosener: will come back to my code i'm gonna hit paste on the type of equal sign paste it and then i'm just going to simply put a to.
William Rosener: So we've just written this function on javascript function Celsius to Fahrenheit make sure you get the equal sign and then i'm gonna put the information in a two, which is right now is zero then i'm gonna hit enter.
William Rosener: And it's loading and i'm guessing i'm going to probably have to go ahead and.
William Rosener: i'll tell you what let me go ahead and work on up there, we go.
William Rosener: I was thinking, I was going to have to but it's maybe not until I create the command button that that's gonna work, let me just go ahead and check this out one quick thumbs up at 100.
William Rosener: And okay we're off to the races okay now let's go ahead and create a commandment to do that exact same thing.
William Rosener: You can write up here to insert i'm gonna choose a drawing.
William Rosener: Let me drag out a text box.
William Rosener: Go ahead and type in Celsius.
William Rosener: To Fahrenheit.
William Rosener: And then, if you want to feel free to add a little color here and let's get that Center.
William Rosener: Okay we'll save and close now.
William Rosener: and make that a little bit whoops a bit smaller.
William Rosener: Okay, so now what we're going to do is we're going to go ahead and.
William Rosener: We have our command and when this thing gets called it's going to generate some code to enter in here so let's go ahead and then come back to our script and i'm saving more time here i'm going to grab some code, you know.
William Rosener: What this code me too.
William Rosener: Okay, so this is going to be again another Celsius This is just another project on it, so the very first thing i'm going to do is specify my two ranges unless it's two one and two, three.
William Rosener: Here is row two column on and here's where I want to store it and rutu column three.
William Rosener: Okay, so i'm going to first of all get the information from range bond get values that's good stored in alright.
William Rosener: So i'm going to race and javascript started zero so i'm grabbing information which is going to be the temperature out of range one i'm going to multiply that temperature why 1.8.
William Rosener: At the 32 and that's because starting Fahrenheit and i'm gonna take the Fahrenheit and set the value bridge to which is two three there.
William Rosener: Okay, let me go ahead and save this.
William Rosener: And now i'm going to do is go ahead and assign this the control see their copy that.
William Rosener: i'm going to come right back up here to my sheets repress on these three little dots over here hit assigned script and paste and press okay.
William Rosener: Maybe i'll tell you i'm gonna come back here, I make sure I hit looks like the same sort of intellect.
William Rosener: And let me go ahead and press on this command button Fahrenheit to Celsius okay good now it's when I get done what kind of thought, maybe we got it earlier authorization required that sitka continued.
William Rosener: And this sometimes takes a few seconds there.
William Rosener: Are here it is.
William Rosener: and
William Rosener: it's going to go about continue it advanced.
William Rosener: Good entitled project I should give me the title, first of all, and allow.
William Rosener: Typically, I get a little message on my phone here shortly.
William Rosener: And let me try this Celsius to Fahrenheit Fahrenheit okay and it's run Okay, maybe a prisoner of text message them.
William Rosener: Okay, so anyway, let me just send her a value in here like zero, I can see, this one is going to automatically do it per ticket this one, you have to press the command button to get it to go.
William Rosener: From Celsius to Fahrenheit and i'm gonna let you guys do the same thing here with inches two centimeters one time, using the formula second time, using the command button.
William Rosener: But don't let me come over here and we're going to create a a command button to generate a chart just like that okay what to do that i'm going to first of all, create another command button, so you can write up here to insert we're going to draw in.
William Rosener: The press on the text box drag it out and i'm going to type in create.
William Rosener: art.
William Rosener: It looks like if you wanted to resize it here is the time to do it.
William Rosener: If you do it back once you're into the spreadsheet looks like he wants to resize the tax.
William Rosener: game and let's get that centered.
William Rosener: In save.
William Rosener: So if you wanted to resize, this will not click on it come back here.
William Rosener: resize it make a little bit smaller and save and close so.
William Rosener: Okay, so now we've got two commandments first one simply.
William Rosener: Long it's I know it's more and more involved approach there, but sometimes you're going to find it some.
William Rosener: You start combining sheets are starting to combine multiple data you're doing another operations you're going to find the need for the command but let's go ahead and work on the CRATE chart.
William Rosener: And do that i'ma come right up here i'm going to go to my script editor.
William Rosener: yeah that's going to come right down here and they some code here, let me explain what this does the sword is going to be sending this spreadsheet to the active sheet we're going to be creating a variable here called great chart.
William Rosener: feel free to play with other values here i've got a column chart as soon as I put.
William Rosener: You can see here, I could type in a line chart.
William Rosener: A pie chart probably there's a pie here's a line I just went with the column, but feel free to use a different chart.
William Rosener: But he's good with the column again and then here's where we're going to grab our data and if you've entered your data in the same spot notice i'm going to start in a eight going to be going through be 11 so i'm going to be grabbing all of that data.
William Rosener: eight to be 11 this is going to be the initial position i'm just going to have that position, right here so it's going to be rude to come to when I run that watch how it appears right here and goes on down.
William Rosener: Okay, so we're going to simply be grabbing some data created this case a column chart and then we're going to position that into two Okay, and let me go ahead and copy this right here.
William Rosener: i'm going to save this code.
William Rosener: will come back to my spreadsheets on the press and these little dots over here assign a script and paste and go ahead, OK.
William Rosener: OK, let me go ahead and we should you ready to run on hit create chart running in there is my chart and again notice for that so located right there at to to so here's my little chart.
William Rosener: I tell you what let's just go ahead and do a couple things here in 90 let's go ahead and make this one 100 and then, if you want to feel free to let's change that chart time and I kind of like on the wiki cheers just a line, just to be a little bit different here.
William Rosener: Okay i'm gonna save it come back here and good create the chart.
William Rosener: and not as impressive I don't think, but here is my exam one, two and three and back up to the top.
William Rosener: So again, this video I showed you two different ways of working with formulas one is you're going to come and you're going to create the probably the simple approach shred little function here.
William Rosener: With your data what you're going to sometimes find is it's much more involved you're going to be one and access various information in a really hard to cram all that into one little Community there since you're gonna make me want to break it down and use the command button.
William Rosener: So first one, here we did a formula, and the second one was we process them so maybe just let me just put in the value of city.
William Rosener: 10 and when I do, that is the way it's going to require it's 50 degrees Fahrenheit or I can press on the command button and then, finally, we created a chart.
William Rosener: or i'm going to press on that it's going to automatically create the church and just glancing here is that good one more time so here's my little one line.
William Rosener: formula here was my more involved approach from grabbing the range converting that reciting the value and here was the chart.
William Rosener: walk it to the next, video thanks a lot bye Oh, let me make sure you can say this so when you save it to a couple things here, first of all, you probably want to come up here and give this a name i'm just gonna call mine.
William Rosener: or non.
William Rosener: Was and chart and then, what I want you to do is two things here one is I want you to download as a Microsoft excel file it's not going to have it for less than.
William Rosener: X it's not going to have this information there and then also make sure you share that and you're just going to share that with.
William Rosener: read their reznor it is OK.
William Rosener: OK don't know what the thumb steps there with Sharon and save and i'll catch you next video thanks.