Gamasutra: The Art & Business of Making Gamesspacer
Microsoft Excel: Revolutionary 3D Game Engine?
View All     RSS
October 24, 2014
arrowPress Releases
October 24, 2014
PR Newswire
View All





If you enjoy reading this site, you might also want to check out these UBM Tech sites:


 
Microsoft Excel: Revolutionary 3D Game Engine?

March 6, 2008 Article Start Previous Page 3 of 5 Next
 

The best example of this exceptional resizeability is Excel's default setting, where the pixels are so distorted and rectangle-shaped that it is very easy to confuse them with a data entry field.

Most users do not even realize these are pixels, and see only data entry fields!


Figure 5: Rendering without grid lines

Figure 6: Rendering with grid lines
  • Sub-pixel size grid lines can be used if needed. It is a very useful feature if rows and columns have different sizes. You can check the grid lines function shown in Figure 5 and 6.
  • Color of the pixels can be set by 24 bits.
  • 255x65535 screen resolution which results the uniquely high 16.7 megapixel resolution not found in other 3D engines.
  • Astounding 1:256 aspect ratio, which can be set by the Hide/Unhide functions to 4:4, 16:9 or other arbitrary ratios.
  • 255 screens in an application, so not only the usual 2 but more screen buffers can be used together.
  • Built-in zoom function to enlarge or diminish the pixels at will.

It can be said that the Excel-native Cell Graphics surpasses its time and contains a lot of unique and unmatched features which are not accessible in other 3D engines: resizeable pixels, arbitrarily variable aspect ratio, 16.7 megapixel resolution, switchable sub-pixel size grid lines.

On the figure below (Figure 7) the engine can be seen in action (with rendered gridlines). You can start the demo by grabbing our example Excel engine files (enable the macros when Excel asks), pressing the ALT+F8 keys and running the ECG_Demo.


Figure 7: Engine in action (with the ECG rendering subsystem)

The drawback of the ECG is the speed and the absence of some common graphical functions (e.g. line drawing, texture mapping, etc) that must be implemented by the developers.



Article Start Previous Page 3 of 5 Next

Related Jobs

Forio
Forio — San Francisco, California, United States
[10.24.14]

Project Manager / Producer (Games)
Yoh
Yoh — Vancouver, British Columbia, Canada
[10.24.14]

Build & Test Engineer
Infinity Ward / Activision
Infinity Ward / Activision — Woodland Hills, California, United States
[10.23.14]

Senior Sound Designer - Infinity Ward
Treyarch / Activision
Treyarch / Activision — Santa Monica, California, United States
[10.23.14]

Multiplayer Level Designer - Treyarch






Comments


Andrew Lauritzen
profile image
Lol this is genius! :D Good work, although you may have too much time on your hands ;)

Jesse McClusky
profile image
This is the type of creativity that opens up the way to new technologies and wins awards. Good job! If I had a position open, I'd likely offer you a job on the spot.

John Minshull-Beech
profile image
Not exactly a games use but I designed my house extension in Excel, working drawings and pics. Resized each cell to 1 x 1 -- took forever. Stopped well short of generating 3D rotating wire model though. Mr Rakos is a genius.

Raymond Grier
profile image
Very interesting. I can't wait to see the new development tools that arise from this.

By the way, th etop level of letters on a keyboard were also arranged to make spelling TYPEWRITER easier for typewriter seles men who went door to door demonstrating their usage.

Brian Embleton
profile image
Wow. This is what happens when VBA programmers have free time? Great. I hate to break it to you, but Excel performs every calculation in sequence. I don't suppose you realize that modern graphics cards perform matrix operations in basically a single cycle whereas Excel probably uses something along the lines of a few thousand in your worksheet cycle? Yeah, when you get Excel to perform a few billion pixel renders per second or start supporting Shaders 2.0, you let us know, m'kay?

Yikuno Barnaby
profile image
It already did. People knew about this back in the 90's.

Kevin McDowell
profile image
Excel is the most under-rated and powerful of all of the Microsoft Office applications. There are some other 2-day animation examples you can find on Office Online (office.microsoft.com) as well as an example of using Excel as a music synthesizer. Just search for "animation engine" or "synthesizer" from the Office homepage to find these examples.

Kevin McDowell
profile image
Errrr, that would be 2-D, not 2-day.

Stephen Chin
profile image
I remember dinking around in Excel to make the foundation for a Rogue-like game. It worked pretty well, all things considered.



And while Excel may not be a modern GPU, it, like the DS, Flash, Shockwave, etc, can be used be used as a commonly available easy to program engine that new programmers and designers can use to make simple games and help ease their way into more meatier and significant projects. They need not worry about graphics, models, or other time consuming assets but purely the scripting and design. Perhaps in some ways, it's the equivalent to MS Paint for artists.

ian walker
profile image
bah! I was doing similar things in the mid 90's with excel - I used it as the basis for my SIAL (statistical image analysis lab) where I did filtering and image processing on shaded cells. The fact that it was slow was really good because I got to *feel* when an algorithm was good or bad. I also used it to investigate Bresenham algorithms and aliasing - you got to see close up in the cell shading jut how well they worked. SO sorry dude - I did all this over a decade ago, and nobody ever called ME a genius ;-)



ps: I also used word as a programming editor - styles, outlining, autotext, templates, grammar checking, macros years and years before visual studio. In a lot of ways word is still a better programming editor than any other, even now...

Anonymous
profile image
hmm i can't get it to work in OpenOffice :(

Harun Vos
profile image
For what it's worth, Anon, I've fiddled with it a bit and got the wireframe cube (mostly) going in OO. I put it up on my page aihtdikh.googlepages.com if you want to play with it.

Marque Sondergaard
profile image
Had to check the date. Is this an April's fools joke?

Anonymous
profile image
Been there, done that (in 2004). :-)



http://youtube.com/watch?v=_whSnPErl7c

Andreas Umbach
profile image
Excel really is the Swiss Army Knife of software tools. It can be used to accomplish *insert MacGyver reference here*.



However, if you have a specialised tool available, it usually beats Excel by a fair margin.

Carl Pearson
profile image
Great article! Excel has always been my very good friend (well, once 'doze 95 came around, and Quattro faded out of existence...). It never ceases to amaze me just *how* versatile a program it is.



Also, thanks for the Dvorak plug! Having typed with it for almost 20 years, I'm sorry so many people continue to hurt their hands with Qwerty!



Lastly, go ahead and flame me, Ian, but you're dead wrong about Word. If you were really that heavy a coder that far back, you would never have used *that* sucky a program.



Word Perfect was THE choice for anyone who typed until 'doze took over. The old DOS Word was absolutely terrible. (You want to stick in all this formatting crap, but don't give me Reveal Codes? Come on...)



The 'doze version of Word may be today's standard, but it still blows dead bears.



However, even with WP's excellent macro abilities & keyboard re-mapping, I would never have considered using it for coding.



Qedit all the way!

Anonymous
profile image
Done before (2002)



http://www.microtron.org.uk/~craig/Microtron/Projects/XL3Drender/
XL3Drender.xls

There are other shapes in that directory that can be rendered.

Tim Leach
profile image
Very interesting! I had never thought of Excel being a 3D Game Engine before, but I like the idea of it!



If I'm understanding this correctly, though, wouldn't it be possible to have 60 sheets and emulate the "60 frames per second" staple we have in traditional video games today? It would certainly sort out the issue of fluidity.

Thomas Eidson
profile image
I worked at a flow pump engineering firm in 1994. They wanted, for some bizarre reason, flow efficiency charts for speed and material graphed in AutoCAD. I used Excel for the datapoints and had it output LISP and used (I believe) DDE to get AutoCAD to cooperate with Excel (Windows 3.11). It took the graphing time from a manual 1 1/2 hours down to 3 minutes. The algorithms to get the splines functioning were in the cells, the conversion was in VB, and the DDE simply was a file to load and execute in AutoCAD. :)

richard feynman
profile image
@ Brian Embleton,



Are you retarded? The author of this article is trying to demonstrate the proof of concept for a change in paradigm with regard to coding structure. He was not attempting to compare the performance of excel data calculations to hardware matrix manipulations. Plus, hardware graphics processes are limited in the size of matrices which can be operated on. Try to work with matrices with thousands, or millions of rows/columns as is done in high energy physics simulations/reconstructions and your GPU is about as as worthless as a Ti-89. Charles Babbage envisioned a "universal machine" which has yet to come to realization. A step away from architecture based paradigms is inevitable. Your gamer oriented thinking is so hardware-centric that it has blinded you from seeing the big, long term picture.

Lorenzo Wang
profile image
Actually, QWERTY was designed to break up common letter pairs, not all succesive keystroke, and no study so far has managed to show Dvorak being superior to QWERTY in typing speed. Comfort is subjective.



Anyways, this was an awesome artilce, I look forward to the first Excel MMORPG!

Tim Maly
profile image
Awesome article and very cool ideas. But Ugh! Why did you have to keep perpetuating the myth that QWERTY was designed to slow typists down? DVORAK may be superior to QWERTY but the idea that QWERTY is intentionally slower has been pretty thoroughly debunked.



http://www.reason.com/news/show/29944.html

[User Banned]
profile image
This user violated Gamasutra’s Comment Guidelines and has been banned.

Jarmo Petajaaho
profile image
Figure 4 is currently linked to a wrong image. This is the correct one:

http://www.gamasutra.com/db_area/images/feature/3563/figure4.png

Andrew Lauritzen
profile image
Hehe I think some of you guys are missing the point. Unless I'm utterly mistaken, the article is written very "tongue in cheek" and while it's structured like an argumentative paper/essay, the ideas itself are ridiculous (Excel as a 3D engine?? lol!).



Indeed *that* is what is genius about the article: the way that it is written! All of the little details and arguments are similarly structured to papers, all-the-while being preposterous when actually considered. While the idea/implementation may not be new, it's the article that is the real cleverness.

Harun Vos
profile image
Hear hear, Andrew!

The idea is clever, but it is the writing that is truly superb.

Peter Mikelsons
profile image
Is it just me, or is this basically reinventing functional programming? And, since Excel yelled at me the last time I tried to make a circular reference in it, without the benefit of recursion?

Anonymous
profile image
Excel was made by Aliens. Bill barrowed the source when he was abducted. It is actually a Universal Galactic Operating System (UGOS). You need 7 fingers on your left hand and 6 on your right to activate it but I found an egg that created a static warp shell around my monitor. Found a way to localize it around my CPU which really increases the over clocking potential. Exciting stuff!

Andy Lundell
profile image
Not as cool as this, but once I implemented Conway's Game of Life in Excel for a school project.



It was the only time in my college career that a prof marked a paper "A+++" like it was eBay feedback.

Zombie Games
profile image
Very interesting I could possibly make pong or something in it, not very useful but fun.

G G
profile image
Makes me think back to the Caslte Wolfenstein / Doom -like Easter egg embedded in Excel 95.

http://www.eeggs.com/items/719.html

Bartlomiej Dzik
profile image
Very well written and ingenious article. While most lay people still believe that Excel is designed to perform boring calculations, accounting and so on, Excel is, in fact, a powerful gaming platform. There are well over a hundred games developed in Excel VBA: arcades puzzles , and even strategy and dungeon crawlers (see my website) and I am currently developing a full-scale RPG in Excel in the style of early Ultimas.



And you can fc play these games at work - this is another strong advantage of Excel gaming engine :)

saç ekimi
profile image
It's not the bleeding-edge engine that can be used to produce famous games like Half Life 2, Unreal Engine (Unreal Tournament), idTech 4 (Doom 3), CryENGINE2 (Crysis) or Clever's Paradox, but it's for simpler usage.

dur cos
profile image
while Excel may not be a modern GPU, it, like the DS, Flash, Shockwave, etc, can be used. excel is very useful program indeed.

dur cos
profile image
while Excel may not be a modern GPU, it, like the DS, Flash, Shockwave, etc, can be used. excel is very useful program indeed.

mos tod
profile image
Big E-Z has lots of cool

programming that makes good use of your Excel program. It doesn't

matter what your skill level is -- anyone can use it

Paul Treneary
profile image
Wow - spooky! I was considering adding perspective to my old Excel 3D cube project from a few years ago and hit this page-good to see someone doing it properly and not like some of those exaples on youtube. Your's looks similar to mine, though mine isn't as tidy, but I never shaded it as I wanted to try doing some form of z-culling(?) which I never did get working. Off the back of this little project I did consider getting into DirectX but never got very far.

Anyway, it's amazing what you can acheive when you're bored at work eh?!

Yikuno Barnaby
profile image
I knew this back in high school, and that was 90 something.


none
 
Comment: