MrExcel's Learn Excel #610 - Ball of Paint

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Mar 31, 2009.
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!
maxresdefault.jpg


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.
 

Forum statistics

Threads
1,213,504
Messages
6,114,016
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top