 What's happening on my YouTube peeps? Thanks for tuning back into the channel right here with me Kyle the rust belt mechanic and Guests here is captain run. What's up? We've got a couple of questions that we're gonna be answering for you guys today one of the biggest ones that we've received question-wise on the channel is Keeping track of your flat rate hours. I know I kind of introduced it on one of my other videos on how we keep Track of our flat rate hours on Google documents, so I employed the help of captain run to do some Hands-on training for you guys showing how that you guys can set up your Google documents Google sheets to be able to track all your flat rate hours Plus a nice introduction for captain and Ron's channel that you guys definitely need to go check out check out this one So here's how you go about setting up your flat rate form and spreadsheet to keep track your flat rate hours If you don't have a gmail account What you can do is you can go sign up for one for free Even if you don't even decide to use the email address get one It's always good to have a backup email in case you need it But that will also give you access to Google Drive Google Drive is just cloud-based storage that allows you to store pictures videos Documents whatever it is you guys might need You get 15 gigs for free, so you can actually say whatever you want It's always good to have some sort of backup for some of your more important documents So you're gonna have plenty of room up there to throw whatever you need up there and also keep track of your flat rate hours So you guys can already see I've got my Gmail, excuse me my Google Drive already up and going Ignore all these files because obviously you're not gonna have files like this. This is my personal drive, so You can see I have my upcoming turtle tattoos here JRC. That's all about you But yeah, so to make your Google Drive File that you're gonna need you're gonna first click on new And it's gonna give you some options. This is what you guys can explore these options later But getting to the meat and potatoes of this we're just gonna go straight to it So you're gonna go down to more and you're gonna go to Google Forms It's gonna give you a little arrow here to where you can pick from a blank form or from a template We're just gonna pick blank form because we want to make it what we want to make it So clicking on that brings up another page. So what we're gonna do is we're gonna title this form as flat rate hours and Congratulations, you're done with your first step. So the first thing you want to do is you want to keep track of Dates, so we're gonna put in here. Just type in date When you do so it automatically recognizes that you're wanting to keep track of a date so it automatically configures it for month day and year What you're gonna want to do also is there's a little button right here that says required You're gonna want to make sure you toggle that on and all your questions that you're gonna do You want to make sure they're toggled on because you don't want to submit a Form without having all the information in there That just protects you from giving a form with incomplete information and then your backtrack and trying to figure out what it is So wherever you see this required toggle make sure you turn it on. So we've got our first Question of our form done so we're gonna hit the little plus arrow which says add question And we're gonna drop down to number two second one is going to be your Your order number so we're gonna type in order Oops, oh our DER order Number and we can leave that as a short text answer because that's just gonna be a number So we don't really care about any other formatting for that There's different things you can pick from but what we really want is just short answer So again click your required and click your question Third thing you're gonna do is gonna be what car you were working on so we can put in Say year Model and customer So the way I have mine set up and the way Kyle has his setup is that we'll put in what you're the vehicle is What model the vehicle is and typically the last name of the customer again? We're gonna keep that as short answer because we're just gonna put in some small short text hit that required button and hit add question Fourth question you're gonna do is gonna be work performed work performed Now this one didn't automatically generate what kind of we want it gave us a multiple choice We're not gonna use multiple choice because there's always gonna be some sort of variant in the work that you're gonna do So again go back up and pick short answer So we have a short answer box hit that required button and hit the next question and last but not last but not least flat rate Hours and it please Disregard my bad typing So flat rate hours again another short text answer It's giving us some variables here, but we're just gonna ignore those don't add anything don't change anything down there just hit that required button and That's pretty much it now. You do have the option to put in some other Some other forms or not forms you're some other Choices here if you want to do more so like for example, you do have the option with the multiple choice button Say you want to do a flat rate form for multiple people Say you have you and three other people who want to be able to use this form have one spreadsheet But you guys want to be able to designate which which jobs are yours You have the option to make radio buttons in a multiple choice for your own tech name or tech ID number Which you could then sort in the spreadsheet later on down the road But nine times out of ten most people are just going to be using this for their own personal use So again, it's an option, but not one that's really necessarily needed So once we get this required button done We look up here in the corner and it says all changes saved in Drive it automatically updates for you So you don't have to worry about continuously hitting save. It'll do it for you Go ahead and title this if you just click up here where it said untitled form It'll automatically pull whatever you name this to that So we've already got that changed You can make us click the star if you want to make sure it's a favorite file that way you can find it easier But again, not really necessary. So once we get all this done And you get everything set up the way you want You're gonna come up here to the top right and there's a little eyeball icon right here. This is preview Click on that it's gonna open up another tab and here's your form. So Now you have that form and what you're gonna do is you're gonna come up here Depending on what browser you're using You can bookmark this you can favorite it. You can put a link on your desktop So if you were to let's see if I can do this. So if I pull my window down So if I click on this little lock icon right here Click and drag out to my desktop It will actually leave me an icon out here. So if I double click this icon, it will open up this page We have saved right here So going back to full screen We're gonna go back to our original Tab where we were making all of our changes and we're gonna click on responses We don't have any responses yet because we haven't filled out that form But there's one key icon on here that we need and that's little little green icon right here This is open spreadsheet. So if you hold over it says excuse me create spreadsheets So if we click on that, it's gonna give us a window that says what do we want to do? We're just gonna create a new or a spreadsheet leave it named flat rate hours responses and we're gonna hit create So it's gonna take a few seconds link it to the spreadsheet and now we have a spreadsheet with time stamp which means when that input or when that form was filled out the date of What we put in for date order number you're making model work performed and flat rate hours So if we come back over to our form and let's say we do how we did a job today, which is 01 13 2019 Order number was order. I don't know three four three six five five. Why not? What we worked on and we worked on a 2013 I don't know charger and it was for Richardson Why not work performed? Yeah, we did a oil change rotate and I don't know wiper blades and Then whatever your flat rate hours for that the perfect sense for example for us a Oil changes is four tenths a rotate is four tenths and wiper blades will be two tenths. So that's four eight nine ten So that's one full hour of work Once you get all your stuff put in you hit submit and it says hey Your response has been recorded and you can just leave this window up so that next time we need to put in a job You just hit submit other response and it takes you right back to that page Or if you close it out, you've got your handy little link up here. You can go right back into it So Once we have that done we can go over to our spreadsheet and as you can see we have all the information we just put in So one other thing that I like doing as well is up here in let's say g1 or h1. It doesn't really matter This being Excel Essentially you can type in formulas to calculate whatever you want So I like to calculate my I like to keep a running total of my hours So I'm gonna show you a formula you can put in you may have to modify it from week to week But you shouldn't really have to do too much So it is equals sum sum Open parentheses and then you can take your mouse and you can just drag what Cells you want it to do Hit enter And now it puts a one because that's all the hours we have in here So if I come back over here and do a 1 13 2019 order number Whatever year 19 charger blob work performed uh tune up Flight rate hours we got three hours to that tune up. Why not? So put in that one and we're gonna put in one more oh one Oops 13 2019 order number whatever that was a I don't know 15 compass and Say the name is grigger. Why not? And we did another lof rotate and uh battery and we got paid for a 1.3 hours for that. Why not? So once we get a running total of stuff going It'll keep all that information for us right here But as you can see in this cell here It's totaling up all your hours for you So that way you don't have to go through and add it all up yourself It will do the work for you and then at the end of the week when you guys get your time slips all your flagged hours You guys can look through and be like yep that hour right there Matches up with what my total is if it doesn't then you can go back through and start looking at what your hours are See where your discrepancies are um Once you're done with checking all your hours for the previous week Clearing all these out. It's just as simple as selecting. Whoops don't that Um selecting what you want to get rid of so the way I usually do it is I'll click over here I'll hold shift and I will pick another cell And then just hit the delete key and they're gone um You may have to right click and just say delete rows Because a lot of times what will happen is when you do another submission it will actually put it in down here So then you have to delete all these blank rows up here It'll take a little get you getting used to but it's not too terribly bad It'll take you about 30 seconds once you get the hang of it So that in a nutshell is how you guys go about setting up your flat rate time um Form and spreadsheet if you guys have any questions about it You can let rust belt know or you can get ahold of me at my on my channel And I'll be happy to answer any questions that you guys might have Um towards this spreadsheet. So I'm going to kick it back over to rust belt and we'll see in a few Well, what do we tell you guys that really is not that hard of a process to keep track of these things Captain ron's really good at what he does and helping to explain that to you was something that he really wanted to do And it's a nice intro and lead into his channel So make sure you go and check out captain ron's channel I will put a link above and down in the description below for you guys to check that out Captain ron, what kind of things are you going to be doing on your channel? my channel is pretty much going to be a Kind of an intro to a technician channel um with me being in school and me not having a whole lot of um You know automotive background to start with um, I thought it would be a good for I know kyle's had a lot of people asking You know, hey, I'm a guy who's wanting to get into the field of doing Automotive work. What you know, what do I need? What can I do all this other stuff? So I'm going to put out a series starting off of just general Basic automotive stuff had to do oil change properly how to do tire rotation properly um, those might go together, but uh, just other things like how to actually You know dismount and mount rims all that other stuff. Um, I'm also going to be doing a updated toolbox tour of my toolbox So those of you have been asking for those stay tuned for that. We'll have that coming soon Awesome. Thanks captain ron. Like I said, go check him out We appreciate everything you guys have been doing for the channel Make sure you stay up to date hit that subscribe button hit the bell notification So you get notified when I come out with new awesome content for you guys to enjoy I appreciate it guys. Thanks and you guys stay awesome