The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
Please vote in the Forum Structure Poll. Polling will close at 2PM EST on January 21, 2025.

Got Excel? Need volunteers to beta-test a game

whuppinswhuppins Registered User regular
edited October 2007 in Help / Advice Forum
This thread is mod-approved.

I'll try to keep this brief. I've written a game in Excel that has recently come close enough to 'finished' to where I am comfortable releasing it to the public. It's not just a Tetris or Minesweeper clone; it's actually a very full-featured, robust game. It's very polished and has a sharp look to it -- it doesn't really look like Excel at all for the most part. What type of game is it? It's a zero-player (ouch) simulation (uh) based on a sport (oh shit)... a fictional sport (Jesus, WTF). If you made it past that last line without throwing your keyboard in disgust, I salute you. It's certainly not everyone's idea of fun.

The point of this thread is that, though it's been in development for over 3 years now, it's only ever been playtested by one person: me. I imagine there's still a good deal of flaws and bugs that I've missed, but at this point I think most of them could only be found by an independent playtester. So, if you'd like to help me out and play a weird little Excel game at the same time, please download it from this site and start goofing around with it.

Is this sitewhoring?
No, I swear to God, it's not. You'll see no ads on that site, no registration, no "free trial" versions, nothing for sale, period. There are no links or other traffic-generating bells and whistles, it's not indexed on any search engines; doesn't even have a hit counter. NFA 2005 has been a 100% labor of love for me and that site only exists as a place to host a three-and-a-half-meg zip file. Of course, it also has some screenshots and a general overview of the game, and I encourage people to read it before they jump right in, but that's only so they know what they need to do to run the game, and have a vague idea of what the fuck is going on once they start playing.

So, what do you want me to do?
Go to the site I linked. Read the info there -- at the very least, read the Requirements section to make sure you can run NFA 2005 without any problems. Download the game, unzip, open nfa2005.xls, and start playing. Of particular interest to me are any UI or game engine improvements (I'm keen on tweaking the engine for a very realistic simulation of sports leagues, despite NFA 2005 being based on a fictional sport) that you think would make it more enjoyable, and, of course, any show-stopping bugs. As long as you play by its rules (read as much of the built-in Help doc as you can stomach), you shouldn't ever see an actual Excel error window. If you do, I'd be very interested in what you did to make it happen. Try to save a copy of nfa2005.xls in the error state and let me know what you were doing when it broke. Feel free to try to break it, of course. It's not supposed to be ironclad, but it should have enough error handling that you can't break it by accident. Also watch out for things that look odd, like if the first player on each team's roster has suspiciously high point totals, or something. NFA 2005 uses hundreds of thousands of Excel formulas and a lot of times, a faulty formula will not be apparent until the numbers have been piling up for hours.

What's required?
In a nutshell, all you need is a version of Excel from the last 10 years. Sorry, people without access to Excel can't help. The NFA 2005 website and the built-in help file will give you more detailed hardware and software requirements.

Feel free to PM me with any bugs, suggestions, or other comments you think of while playing. You can also reply here, though I think the mods would appreciate it if this thread didn't last any longer than the usual H/A thread. If you prefer email, please use nfa2005@cox.net, not the address listed in my profile. If certain questions keep appearing in the next day or so, I'll address them here; otherwise, I'll let the thread die gracefully. I'm doubtful that anyone out there shares my not-even-the-hip-kind-of-geeky interest in this game, but if I can get even one person to try it out and give me some feedback, I'll be happy.

Thanks to anyone who volunteers.

whuppins on

Posts

  • PirateJonPirateJon Registered User regular
    edited October 2007
    Does it work with the excel viewer?

    PirateJon on
    all perfectionists are mediocre in their own eyes
  • whuppinswhuppins Registered User regular
    edited October 2007
    Nope, sorry. Excel Viewer doesn't do VBA. More info's available on the site I linked, but stuff like Quattro Pro and pre-95 Excel won't work either.

    whuppins on
  • CycophantCycophant Registered User regular
    edited October 2007
    Hm, tried running the spreadsheet, and I'm getting a VBA/activex warning as soon as it opens. Office seems to think it's related to some program extension not being installed, which is rather likely, considering I pare down my Office installations to the bare minimum of what I know I'll use.

    I'll see if I can find my CD's later and install whatever the hell it is Office wants me to install. If you're collecting an FAQ or troubleshooting guide though, maybe through it in there, just in case someone else comes across it. The exact error: "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

    Cycophant on
    sig.gif
  • whuppinswhuppins Registered User regular
    edited October 2007
    That's a good point, the OP didn't really mention the amount of VBA it uses, so anything that limits your ability to run VBA (AKA macros) will probably be an issue. It sounds like the warning is more of a "you don't have this component installed" thing than a security thing, right? Because NFA 2005 doesn't link to any executables or anything potentially sketchy like that... but you do need to be able to run VBA for it to work.

    I'll play around with some Office installations when I get the chance to see exactly which components are required. Thanks very much for the info.

    Edit: According to this KB article, it looks like this is just a case of VBA not being checked in the Office installation. I'll update my requirements documentation in the future. Thanks again!

    whuppins on
  • CycophantCycophant Registered User regular
    edited October 2007
    Yeah, it's definitely a component-installation issue. I had macros disabled at first too (new Office installation), but your big warning on the Splash screen ensured that was rectified fast enough. I'm certain it's a component I saw during installation and went "Well, why would I want to use programming features in Excel?" and disabled it.

    When I get around to installing it, I'll let you know which component it was, for future reference. I'm sure there's others out there that do the same thing as me.

    Cycophant on
    sig.gif
  • stigweardstigweard Registered User regular
    edited October 2007
    Autopick is really slow. I'm using an e6600 and it is taking several minutes to pick players.

    stigweard on
  • whuppinswhuppins Registered User regular
    edited October 2007
    If you're doing your initial league setup, I think the problem is just that it has to pick so many damn names. You're usually using it to pick between 50 and 100 names, but in this case, you're picking 900 at once. It'll take a few minutes on probably any machine.

    Technically speaking, using Auto Pick is no different from hitting the button to pick a name over and over again. It's running the exact same code, so the time it takes to pick 900 names should be equal to the time it takes to pick one name, times 900. Even if a single name can be picked in, say, a half-second, that translates into over 7 minutes that it will take to pick 900 names. The best I can tell you is that it's slow for everybody, try to be patient, and you won't have to pick anywhere near that many names again.

    Knowing that the initial player name generation would take a while, I thought about including a default set of names (like I defaulted in team data) to skip that part entirely, but I kind of liked the idea of each person who downloads NFA 2005 having a completely different experience out of the box. If it turns out to be a bother for people, as you've mentioned, I might take a look at including default names after all.

    Thanks for the feedback!

    whuppins on
  • embrikembrik Registered User regular
    edited October 2007
    I've been running it for a little bit with Excel 2007 (Office 2007 Pro) on Vista x64 Business. No problems yet. However, you might want to include a small bit about enabling the macros for 2007, as it's different. You get a bar along the top (like I.E.'s Information Bar) that includes a settings button to enable Macros for the file. To completely enable them, you have to go to the "Trust Center" settings.

    embrik on
    "Damn you and your Daily Doubles, you brigand!"

    I don't believe it - I'm on my THIRD PS3, and my FIRST XBOX360. What the heck?
  • whuppinswhuppins Registered User regular
    edited October 2007
    Damn, I guess I need to get a copy of Office 07. I haven't been able to try it out with 07 yet. Thanks for the info.

    whuppins on
Sign In or Register to comment.