– Hey, what’s up, data geeks? Today, I’ve got kind of ashort video for you here.
I was doing some analysis, recently, on the money I’m hopefully saving by having a Tesla.
And it’s something that theytout on their website as saving 6-9,000 dollars a year, I think, and they even factored in when you look at the overall cost of your monthly payment or whatever.
So, I got mine back in January, or early February/late January, and I’ve had it this whole year.
It’s November now, so, you know, good sample size here.
And I wanted to actuallygo back and analyze my bill and my electric bill and compare kind of the gas prices andeverything else, figure out if, and how much, I’m actually saving by having this car.
So, what I have here on my screen is some data I pulled together.
And this first data set here just shows the actual electricity bill I have from the local electrical company here.
So, this is each month.
You can see the number of billing days, the on-peak, the off-peak charges, and then the super off-peak charges.
Now, I highlighted thisbecause, here in California, we have a special rate that you get, during this time, forelectric vehicle owners, so if you have a Tesla or any other kind of electric vehicle.
But if you’re gonna buy one, just get a Tesla, don’t evenworry about the other ones.
You should apply forthis, and you can get, I think it’s close to 40-50%off of the actual rate, the normal kilowatt per hourrate that they charge you.
And so I highlighted thiscolumn because, essentially, this is all the moneygoing towards the cost of gas, or what would be gasfor my car, per month.
And so you can see here, theaverage is about 60 bucks, and that’s not nothing, andso I wanted to get deeper and figure out how muchit actually costs kind of per mile and all that.
I also did some analysis of times when I wasn’t home and my car wasn’t here so it wasn’tcharging, so I could see, you know, okay, maybe wehave the dishwasher going, or whatever else, and isall of this money here, all of these charges,going towards the car? And after looking atthat, I figured it’s 99%.
So, even with dishwashersand other things that you schedule to go at midnight or whatever, during this time, it reallydoesn’t add up to much.
So, I figured, you know what? Just to be conservative,let’s apply all of it to the cost of transportation here.
So then I was able to pull downthe number of miles driven, and I did that with thisapp I use, called MileIQ, which actually shows you,it’s an easy way to classify business versus personal travel and all that kind of stuff so you can get reimbursedfor all your driving.
So I did that and I lookedand I got the number of miles per month, and I punched that in there.
I had to take an averagefor September because I changed my phone over and it lost some data or whatever, so, you know, looking at that andwhere the trend was going, I’ve calculated that thatwas the number for September.
Then I took the average gas price.
And I’m here at San Diego,so gas is pretty cheap, sorry, it’s prettyexpensive, it’s not cheap.
And so that’s the average gas price.
I took the average miles pergallon of a car like mine, and then I calculated outsome other things, so the overall average cost thatsomebody else would be paying for driving this many miles at this gas price is here in column K.
So you can kind of see we’re 90 bucks, low 90s, maybe alittle over 100 that month ’cause the gas price fluctuated a little bit.
Then I compare that to the super off-peak charges that I had, and I can see how muchmoney I’m actually saving.
So, overall, it looks like I’m saving, on average, about $34 a month, which doesn’t sound like a lot, you know, in the grand scheme of things, it’s not a tremendous amount of money.
But if you consider the average percent savings that is on mymonthly gas bill, that’s close to 40%.
So, that’s a lot.
So imagine if you could take any part of your aspect of yourlife, of your monthly costs, something like gas, and save 40% on it.
I mean, that’s really a bigpercentage, a big chunk.
So, I have this data here,and, of course, like always, we need to look at itin a visual form ’cause spreadsheets are boring even though they’re functional.
So if I switch over to Tableu, I can do some cool stuff.
I’ll connect to Google Sheets.
And I’ll pull the data in.
It already loaded it up.
It classified everythingcorrectly, it looks like.
Let me just double check so everything’s in number, pretty much.
Yeah, looks good.
So then we go there, andwe can just kind of see the trend here, so we’lldrag bill period up, and we’ll change this down to month, so we have a monthly trend there.
And I’ll just drag the percent savings on so you can kind of see how that goes.
Here is, essentially, the monthly percent savings from having a Tesla.
Plus, you get to drive a Tesla, which is pretty awesome, right? So you’re saving close to40%, or 40% on average, and you’re also, you know, doing something goodfor the environment and all this other great stuff.
If you guys are interested in more of this stuff, I’mgonna put it on my blog.
You can go check itout there with the link in the bottom of this video.
Hey, thanks for checking out my video, I really, really appreciate it.
Now, I also have a blog, bensullins.
Com, in case you haven’t visited that.
On there, I have videos like this, I have code samples, I havefull articles describing all the tips and tricksand everything that I want to share with youto help you in your career, as well as you can sign upfor my weekly newsletter, which is basically a digest of all that, plus more stuff I’ve found on the web that I found interesting thatmight be pertinent to you.