Since, according to Google, it is the 25th anniversary of the Buckyball, I thought I would draw one in Excel.

A quick search found a list of coordinates here: Chemistry resources

The problem then was, how to connect them. The information was probably somewhere at the same site as the coordinates, but not in a form I could understand, so I pasted the coordinates into Strand7, and connected the nodes by trial and error, until I got what I wanted. The list of node connections could then easily be copy and pasted into Excel:

Buckyball coordinates and connections

It was then a simple matter to paste the coordinates and connection details onto my Plotxyz spreadsheet, press the Draw button, and hey presto – one Buckyball:

Buckyball

The plotxyz spreadsheet, including Buckyball details, can be downloaded from PlotBuckyBall.zip

Edit Sunday 9:00 PM Sydney time:

Since it is still just Buckyball day somewhere on the globe I thought I’d share a few more images.

The buckyball consists of 90 edges, 60 long ones (1.453 angstroms) and 30 short ones (1.367 angstroms). These form 12 pentagons and 20 hexagons. The pentagons have all long edges, and the hexagons have alternating short and long edges. To make this difference clearer I have coloured the long edges green and the shorter ones red. In addition, to enhance the 3D effect, I have used a heavier line for the edges facing the viewer. Here are the results:

Buckyball viewed from a distance

Close up view

### Like this:

Like Loading...

*Related*

Pretty awesome.

LikeLike

Pingback: Tweets that mention Drawing a Buckyball in Excel | Newton Excel Bach, not (just) an Excel Blog -- Topsy.com

Reminds me of trying to create a dodecahedron for my daughter’s classroom play. OMG, that was a mess. It’s amazing what can be found online.

LikeLike

I did something similar a while back. Back in my Amiga 500 days it was a common demo effect to draw 3d shapes. Of course I had to try in Excel!

http://vangelder.orcon.net.nz/excel/convex3d.html

LikeLike

Rob – very nice. I thought about animating mine but didn’t get round to it. It’s good to have the example.

Looking at your code reminds me that I really must tidy up mine in my plotting program as well, as its suffering from a bad case of bloat.

LikeLike

this is just brilliant!

helps me a lot .. in Group Theory for Chemistry

LikeLike

Pingback: Daily Download 11: Perspective Projection | Newton Excel Bach, not (just) an Excel Blog

Hi dougaj4,

I really enjoyed your other post using plotxy to draw the bat skull in excel. Just wanted to play around with this one, too. It seems as if “PlotBuckyBall.xlsb” for the buckyball is not available anymore. Could you please reupload it?

Thanks a lot!

LikeLike

Thanks for letting me know.

I had to change all my download links to keep Google happy. It is now updated and should work.

LikeLike

much appreciated, thank you very much for the fast reply!

LikeLike