Categorized | excel download, excel macro and vba
Tags | ,

You’ve seen 2D, what about 3D simulation in excel

Peter Rakos in his article in Gamasutra shows how to create a 3D simulation in Excel. He uses the create polyline (Shapes.AddPolyline) function in excel to generate a set of  triangles (2D). A paid of these triangles is used to generate one surface of a rotating cube. 12 such triangles are used to generate the entire cube (12 triangles = 6 surfaces = 1 cube). Before each iteration, the previous shapes are destroyed and new ones created. That’s the easy part……the beauty lies in transposing the x,y,z coordinates of a 3D object into x,y coordinates of a 2D shape. Though I disagree with Peter’s suggestion that this has application in gaming….I think it would be better suited as an example for young students to experiment.

Play around with it….change shape, displacement, lighting….it’s good fun.

You can download the original file Gamasutra
I’ve made a slight modification which makes it easier to run the functions here

Excel Formula, Excel Chart, Excel Macro, Excel VBA, Pivot Table Excel, Excel Dashboard

What Do You Think ?

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>


Keep up with the latest stories - Delivered right to your inbox


English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel