<em>Arena.Xlsm</em> puts macros to work for leveling, battling, and collecting items.
Read the whole story
Read the whole story
How an accountant created an entire RPG inside an Excel spreadsheet
- Thread starter JournalBot
- Start date
Darn I knew there was a reason I still needed MS Office.
Needs a Google Docs port
Needs a Google Docs port
Upvote
23
(26
/
-3)
I spend a good chunk of time writing Excel macros and I was curious to see his handy work. Unlocking his macros wasn't that difficult and there's guides all over the internet on how to do this.
I would publish the unlocked version if he hadn't explicitly said he didn't want it released, but if you really want to take a look at it, it's not that difficult to do yourself.
I would publish the unlocked version if he hadn't explicitly said he didn't want it released, but if you really want to take a look at it, it's not that difficult to do yourself.
Upvote
11
(11
/
0)
Who said accountants are boring (accountants are bored seems a better description )?
)?
Upvote
38
(38
/
0)
Okay, that is pretty neat. Excel appears to have immersion breaking limitations to it, but he made it work correctly, and that's quite a feat. I probably won't download since the macros are locked and cannot be read however. I just like it conceptually.
Upvote
1
(1
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295093#p24295093:1lpr7s51 said:idea00[/url]":1lpr7s51]Who said accountants are boring (accountants are bored seems a better description
Only the good ones are bored. The rest are still doing everything manually rather than system driven.
What can be system driven that is.
Upvote
0
(0
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295373#p24295373:151mf4m5 said:
Because it's cool. Somewhat insane, even.
Upvote
54
(54
/
0)
Amazing!... and scary =( I don't want to be pessimistic or anything but I foresee lots of macro virus distributed with this when downloaded from other "mirrors"
Upvote
4
(4
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295373#p24295373:2su0oi78 said:
I can't play it to see (got a Mac), but I bet that if he'd done it in either PowerPoint or Word—probably Access too, but that's less common and more programmy—it would have been the same story.
Upvote
0
(0
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24294951#p24294951:3o3fldbe said:Hrmmm[/url]":3o3fldbe]Darn I knew there was a reason I still needed MS Office.
Needs a Google Docs port
Google Doc's spreadsheet is shadow of an imitation of Excel. It doesn't have a scripting language amongst other missing features. Never say never, I guess, but it won't be for years.
Upvote
9
(9
/
0)
Crawling around a Spreadsheet Dungeon to slay monsters? Sounds like my first job.
Stay a while and listen...
Twas an age ago when Graphical User Interfaces were but a pipe dream in the minds of ordinary MicroSerfs. The dungeon in question resided in the land of SuperCalc. It was a dull and sorrowful land rendered in monochromatic green phosphor.
Woe had befallen my Lord for he had to account for the addition of 3 new markets on the gargantuan monstrosity that was the Monthly Turnover report. Many a brave knight had attempted to tame the Beast, but it had been in vain. All challengers failed in their task, they had wildly hacked and slashed at it causing it grow bigger and more angry.
The Monthly Turnover had become a twisted and distended 90 page long Paper Serpent scarred with the marks of braveidiots 'heroes' who foolishly tried to tackle it then fled in terror &/or confusion leaving nary a useful comment in their wake. To make matters worse, many parts of the beast that had been hacked now flailed around uselessly in disconnected cells with no clue as to their purpose.
So my Lord bid me, his young squire, to tame the wretched creature and "Add these three extra markets onto the Monthly Turnover for me.". Twas clear from the outset that my Lord considered it a trivial undertaking that would require but a day. Perhaps he believed in my abilities or possibly he didn't understand the enormity of task I faced.
Boldly I strode through the office and set up camp in the far corner, as far away from my noisy feckless fellow office adventurers as possible. With supplies of Coca-Cola, a pad and pencil, I set about unravelling the mystery laid out across 90 sheets continuous perforated paper. The elephant in the room soon reared its head and realised I was the poor bastard standing behind with neither broom nor bucket. The elephant's gut rumbled ominously, a big job was coming.
With grim determination I hacked through acres of dense cruft. Here and there dotted amongst steaming piles bloat were the glistening jewels of the original writers logic. They could be saved, but I would have to get my hands dirty.
I toiled 5 long days, tidying, rewriting and reducing the once feared freak of hasty revision and careless neglect into a 20 page document with clear summary pages. Helpful comments were hidden in the margins so that any Adventurer following in my footsteps would get to their destination safely.
My reward, a job well done.
Months later my Lord was fired for his incompetence, the cause of all the problems in the first place. As a Squire without a Lord to serve I was soon cast aside with redundancy.
The End
The tales of Sonolumi continue in Fellowship of the part-time Temps.
Stay a while and listen...
Twas an age ago when Graphical User Interfaces were but a pipe dream in the minds of ordinary MicroSerfs. The dungeon in question resided in the land of SuperCalc. It was a dull and sorrowful land rendered in monochromatic green phosphor.
Woe had befallen my Lord for he had to account for the addition of 3 new markets on the gargantuan monstrosity that was the Monthly Turnover report. Many a brave knight had attempted to tame the Beast, but it had been in vain. All challengers failed in their task, they had wildly hacked and slashed at it causing it grow bigger and more angry.
The Monthly Turnover had become a twisted and distended 90 page long Paper Serpent scarred with the marks of brave
So my Lord bid me, his young squire, to tame the wretched creature and "Add these three extra markets onto the Monthly Turnover for me.". Twas clear from the outset that my Lord considered it a trivial undertaking that would require but a day. Perhaps he believed in my abilities or possibly he didn't understand the enormity of task I faced.
Boldly I strode through the office and set up camp in the far corner, as far away from my noisy feckless fellow office adventurers as possible. With supplies of Coca-Cola, a pad and pencil, I set about unravelling the mystery laid out across 90 sheets continuous perforated paper. The elephant in the room soon reared its head and realised I was the poor bastard standing behind with neither broom nor bucket. The elephant's gut rumbled ominously, a big job was coming.
With grim determination I hacked through acres of dense cruft. Here and there dotted amongst steaming piles bloat were the glistening jewels of the original writers logic. They could be saved, but I would have to get my hands dirty.
I toiled 5 long days, tidying, rewriting and reducing the once feared freak of hasty revision and careless neglect into a 20 page document with clear summary pages. Helpful comments were hidden in the margins so that any Adventurer following in my footsteps would get to their destination safely.
My reward, a job well done.
Months later my Lord was fired for his incompetence, the cause of all the problems in the first place. As a Squire without a Lord to serve I was soon cast aside with redundancy.
The End
The tales of Sonolumi continue in Fellowship of the part-time Temps.
Upvote
165
(166
/
-1)
The most amazing spreadsheet game still has got to be whoever implemented pacman in excel. The guy basically used the cells sized as squares for pixels and animated be copying the characters maze and dots as formats from other locations on the workbook.
Upvote
4
(5
/
-1)
about the time of the DnD 4e launch, I was working mostly from home as an analyst. I had been looking for good character tracking spreadsheets and came across something a guy was working that went a lot further. I immediately liked where it was headed, but noted it had a few minor issues, and some calculation issues, on top of some rules issues. The coder was a spreadsheet genius, and I knew a crapload about DnD as I was heavily working in Maptools designing a big campaign, and had beta access to the 4e ruleset.
well, about 15 months of work, a few hundred emails, and we ended up collaborating (with several others), and turned that basic character management tool into a full-blown character creation system containing basically every rule in the entire first run set of expansions to 4e. Die rollers, powers that customized their numbers and stat display as you leveled up, stat trackers, everything. with a laptop, you could run the game right off the spreadsheet directly, level up, swap items, track power statuses, everything. I personally added a few thousand lines of excel formulas into the spreadsheet, several others helped load all the data from the books, and the originator did the UI and base logic. It was HUGE. we had some cells with more than 10K precedent cells. Best thing about it, only 3 cells in the entire system required you to enable macros, and 2 of those were related to importing or exporting characters to and from other formats, and one was just a convenience feature for printing. You could create characters and fully use it otherwise without macros. a HUGE plus when running it on work laptops or tablets.
It would have gone further, we were working on directed output so activity in the spreadsheet could feed right into maptools, but then WoTC released their own character editors officially, and our "license" to do what we were suddenly became in jeapordy. We'd added more than the base rule-set (with a great toggle system so you could toggle on and off supplemental rules and books you did and did not own), but with WoTC having an official generator (that was fee based) we could not continue work on ours. So, instead, I took some existing maptools mods, and re-built the generator in java. Though I didn't import all the data from the books, you could create any character (or monster) and have weapon swaping, and basically click a power and select targets and poof, rolls were made, damage and effects auto added, and we turned what would have been mult-hour complex combat rounds into 15 minutes of quick combat so we could get back to the role playing.
When WoTC dropped the character builder and shut down PDF versions of the manuals, requiring each and every group member to have a $9/mo fee to play instead of just the DM doing that, we stopped playing. The only benefit we really had was each player could mod their own characters online with DnD's official tool, and I could import the file, saving me tons of time between sessions. Once I had to do all the work manually, we lost 2 hours every game session doing menial work, and got bogged down, and stopped playing. stupidest move WoTC made in my opinion.
well, about 15 months of work, a few hundred emails, and we ended up collaborating (with several others), and turned that basic character management tool into a full-blown character creation system containing basically every rule in the entire first run set of expansions to 4e. Die rollers, powers that customized their numbers and stat display as you leveled up, stat trackers, everything. with a laptop, you could run the game right off the spreadsheet directly, level up, swap items, track power statuses, everything. I personally added a few thousand lines of excel formulas into the spreadsheet, several others helped load all the data from the books, and the originator did the UI and base logic. It was HUGE. we had some cells with more than 10K precedent cells. Best thing about it, only 3 cells in the entire system required you to enable macros, and 2 of those were related to importing or exporting characters to and from other formats, and one was just a convenience feature for printing. You could create characters and fully use it otherwise without macros. a HUGE plus when running it on work laptops or tablets.
It would have gone further, we were working on directed output so activity in the spreadsheet could feed right into maptools, but then WoTC released their own character editors officially, and our "license" to do what we were suddenly became in jeapordy. We'd added more than the base rule-set (with a great toggle system so you could toggle on and off supplemental rules and books you did and did not own), but with WoTC having an official generator (that was fee based) we could not continue work on ours. So, instead, I took some existing maptools mods, and re-built the generator in java. Though I didn't import all the data from the books, you could create any character (or monster) and have weapon swaping, and basically click a power and select targets and poof, rolls were made, damage and effects auto added, and we turned what would have been mult-hour complex combat rounds into 15 minutes of quick combat so we could get back to the role playing.
When WoTC dropped the character builder and shut down PDF versions of the manuals, requiring each and every group member to have a $9/mo fee to play instead of just the DM doing that, we stopped playing. The only benefit we really had was each player could mod their own characters online with DnD's official tool, and I could import the file, saving me tons of time between sessions. Once I had to do all the work manually, we lost 2 hours every game session doing menial work, and got bogged down, and stopped playing. stupidest move WoTC made in my opinion.
Upvote
25
(25
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295373#p24295373:3syf33zo said:
I assisted building a full DnD 4e character generator, tracker, die roller, and full-on real-time character management system using exclusively cell functions. it was massive. some cells had over 10K precedents. took us almost 2 years total to get it done.
This, I admire. He's basically taken a simplified character manager (lets just say, less than 10 books of DnD content, probably still damned complex) and merged it with a zork-like story progression system and a few tables of item drops, and positional tracking, so basically a mini version of maptool meets our old spreadsheet. very cool. I totally respect the level of efort.
Upvote
11
(12
/
-1)
This is definitely cool, but a quick search turns up lots of Excel games, many of which are even more pretty than this one. None are RPGs that I've noticed so far, though. Will definitely check this out, as it's been forever since I played something like this. Hope he unlocks it soon so we can tweak the game ourselves if we so desire.
Upvote
2
(3
/
-1)
Funny that I saw this post today, followed by this video of a SCAD student using the Nuke python API to script a brick breaker game with nodes in the nodegraph.
http://www.youtube.com/watch?v=zxTRbh7K1jQ
Nuke is far less common in the office than Excel, but still, I can only applaud the effort.
http://www.youtube.com/watch?v=zxTRbh7K1jQ
Nuke is far less common in the office than Excel, but still, I can only applaud the effort.
Upvote
0
(0
/
0)
@ Sonolumi, that was one of the more entertaining reads I've had in the comments in quite some time. Thank you sir.
Upvote
14
(15
/
-1)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295927#p24295927:vw0wrh3s said:
I admire your effort far more.
My group tried 4E, got fed up very quickly with the ludicrously complex character generations (and let's not talk about combat) and moved onto Pathfinder and now DCC.I know what the guy's done is lots of work, I'm just bemused by the amount of media attention. As an earlier commenter mentions Pacman was done in Excel years ago.
Upvote
1
(3
/
-2)
JustAdComics
Ars Praetorian
I seem to recall there being a full-blown flight simulator stashed away in Excel at one point in the 1990's. Anyone else remember that?
Upvote
9
(9
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24296413#p24296413:h8wew4j2 said:
Well, it wasn't exactly "full-blown", but yes. It had graphics similar to DooM, and I never figured out all the controls, but it was really cool to see that inside a spreadsheet program. (Office '97)
Upvote
4
(4
/
0)
Upvote
3
(3
/
0)
Brilliant!
Now to make sure I don't accidentally attach this to an email to my boss!
Now to make sure I don't accidentally attach this to an email to my boss!
Upvote
6
(6
/
0)
I'm not sure what the big deal is about this. Millions of people every day download executables from the Internet and run them quite happily with absolutely no access to the source code.[url=http://meincmagazine.com/civis/viewtopic.php?p=24296021#p24296021:frefc82b said:
Why should something written in VBA within Excel suddenly be any different? Even more so if it doesn't invoke UAC? Or doesn't require an installer that invokes UAC?
Upvote
7
(7
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24295569#p24295569:27rojbee said:
Someone hire this man, please!
Upvote
5
(6
/
-1)
OK, I just had to comment on this.[url=http://meincmagazine.com/civis/viewtopic.php?p=24295569#p24295569:1sx6c4nl said:
Thanks for the highly amusing and informative read Sonolumi.
Upvote
6
(7
/
-1)
Ok, I wish to revise that RPF for a spreadsheet written in Dwarf Fortress: it needs to be Excel-compatible.
Upvote
-1
(0
/
-1)
I actually really like this project (I'm an excel and RPG geek - but not to this level of dedication!), so thank you for covering it!
But what I want to know... with Excel 2013s new mapping features, I wonder if you could combine the two together to have maps to go exploring through! That would be awesome!
But what I want to know... with Excel 2013s new mapping features, I wonder if you could combine the two together to have maps to go exploring through! That would be awesome!
Upvote
1
(1
/
0)
[url=http://meincmagazine.com/civis/viewtopic.php?p=24296055#p24296055:3sxvunt5 said:
On what planet is a D&D 3.x based game less complex for character gen than 4E? Picking powers from a list is hard now? Clearly you have never played a game like Rolemaster if you think any edition of D&D had complex character gen.
Speaking of...Excel char gen> I had some friends that about 15 years ago built an Excel spreadsheet for making Rolemaster characters. It cut the 4 hour character generation time down from 4 hours to 1. Both methods, still add 1 hour if you were making a caster. Some of those printed character sheets got stupidly long, once you had all the tables printed for each of your weapons and possible crit tables and such. Everyone had everything they needed for the game in front of them tho.
Upvote
0
(2
/
-2)
Ludicrously complex is not how I would describe 4E chargen, especially when comparing it to immensely more number heavy systems like Pathfinder and DCC.[url=http://meincmagazine.com/civis/viewtopic.php?p=24296055#p24296055:1292g3jk said:koolraap[/url]":1292g3jk]
I admire your effort far more.
I would like to point out that I hate, hate, hate Excel spreadsheet chargens. You have to have the full version of that version of MS Office to use them at all and they are god awfully slow is as the wont of too large and ponderous spreadsheets.
Just pick up VB Express (free development programs from Microsoft) and write a damn standalone program.
Upvote
0
(2
/
-2)
- Status