We figure out the thickness of a coat of paint, live from the site of the Worlds Largest Ball of Paint.
Episode 610 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Episode 610 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, all right gang.
This is Bill Jelen.
Welcome back to the MrExcel podcast.
This is great. I'm in Alexandria, Indiana today.
I just painted the world's largest ball of paint. That's right, I'm here at the home of Mike Carmichael.
Mike started out with a baseball.
What, how many years ago 20 years ago?
30 years ago and dip this in the bucket of paint and he's been adding layers and layers and layers and I just painted layer number 20405.
So, this is a Guinness record, at least until the next person shows up and paints the, paint's the Ball of Paint.
It's Wild this thing is 2,000 pounds, we just measured it. It was 133 inches around.
All right so, our Excel today we're just gonna do some basic math in Excel.
I start out here with 133 inches as the circumference, and I want to figure out the diameter.
So, circumference is Pi times diameter.
So, what I'm gonna do is take the circumference divided by the pi function.
So, equal Pi and that will tell us that that is 42.3 inches straight through the center right now, and we have 20405 layers.
So, I'm going to divide that by 2 that means the radius is 21.16 inches, every layer then comes out to 0.001037 inches of paint. This is amazing.
You know I love roadside attractions.
This is sponsored by Sherwin-Williams.
They've heard about this, he uses all Sherwin-Williams paint. I'm you can just show up. Give him a call, Alexandria, Indiana were just off of I-69 about 10 miles and you and your kids can set help set a record by painting the world's largest Ball of Paint.
Hey, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I got it Excel. It will will be all good will be how good.
Hey, all right gang. This is Bill Jelen. Welcome back to the MrExcel podcast.
I started out here with 133 inches as the circumference and I want to figure out the diameter, the diameter.
So, diameter is Pi times like circumference is Pi times diameter.
This is Bill Jelen.
Welcome back to the MrExcel podcast.
This is great. I'm in Alexandria, Indiana today.
I just painted the world's largest ball of paint. That's right, I'm here at the home of Mike Carmichael.
Mike started out with a baseball.
What, how many years ago 20 years ago?
30 years ago and dip this in the bucket of paint and he's been adding layers and layers and layers and I just painted layer number 20405.
So, this is a Guinness record, at least until the next person shows up and paints the, paint's the Ball of Paint.
It's Wild this thing is 2,000 pounds, we just measured it. It was 133 inches around.
All right so, our Excel today we're just gonna do some basic math in Excel.
I start out here with 133 inches as the circumference, and I want to figure out the diameter.
So, circumference is Pi times diameter.
So, what I'm gonna do is take the circumference divided by the pi function.
So, equal Pi and that will tell us that that is 42.3 inches straight through the center right now, and we have 20405 layers.
So, I'm going to divide that by 2 that means the radius is 21.16 inches, every layer then comes out to 0.001037 inches of paint. This is amazing.
You know I love roadside attractions.
This is sponsored by Sherwin-Williams.
They've heard about this, he uses all Sherwin-Williams paint. I'm you can just show up. Give him a call, Alexandria, Indiana were just off of I-69 about 10 miles and you and your kids can set help set a record by painting the world's largest Ball of Paint.
Hey, thanks for stopping by.
We'll see you next time for another netcast from MrExcel.
I got it Excel. It will will be all good will be how good.
Hey, all right gang. This is Bill Jelen. Welcome back to the MrExcel podcast.
I started out here with 133 inches as the circumference and I want to figure out the diameter, the diameter.
So, diameter is Pi times like circumference is Pi times diameter.
