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, ...

Continue Reading

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

Creating tree structure in excel

Posted on 06 September 2008

Creating tree structure in excel
You can use the group and outline features in excel to create tree structures. On expanding each node the next branch becomes visible. You can download the file here.
Continue Reading

Comments     

DNA Strand simulation using Excel

Posted on 01 September 2008

DNA Strand simulation using Excel
Excel can be used to create neat little simulations for classroom traings. I remember a long time back, I had a tough time trying to understand how the strands of a DNA coil around each other. Well....I tired my hands at creating a rotating DNA strand using 3-D bubble charts.....stright 'n simple for the most part......the trick lies in making the base and linking pairs change their overlaps after rotating every ...
Continue Reading

Comments     



Translate

Chinese (Simplified)DutchEnglishFilipinoFrenchGermanHebrewHindiItalianJapanesePortugueseRussianSpanish

treeemap software for excel