Archive for the ‘ Arena.Xlsm ’ Category

Known Bug: Arena.Xlsm v1.3 “Compile error in hidden module: Sheet14” (FIXED)

Edit on 2/21/15: This appears to have been a problem that was created by a recent Office update that broke ActiveX controls. For a step-by-step guide to fix your client please see the link here: http://excelmatters.com/2014/12/10/office-update-breaks-activex-controls/ Special thanks to the amazing testers who volunteered to help track this down!

Some people are reporting seeing the following error when opening the game:

Sheet14 Error

I have received reports of this occurring in both Office 2010 and 2013 however I am unable to recreate the bug on my testing machines. I am now asking for volunteers who are using systems that are encountering the above bug to provide feedback on updated versions  so that I can try to tackle this. If you’d like to volunteer please let me know at email with your operating system and excel version and I shall add you to the tester list.

Thank you for your patience and your assistance with this bug.

Canadian Technological Achievement of the Year

So this is a very nice New Years Eve surprise!

From The Globe and Mail:

In a year that saw BlackBerry’s fortunes take yet another turn for the worse, it was often easy to feel pessimistic about the state of technological innovation in Canada. Fortunately for us, people like Cary Walkin exist.

Mr. Walkin, a chartered accountant, decided to build a dungeon-crawler role-playing video game all by himself. Now, this on its own would be a fairly impressive endeavour. But no, Mr. Walkin took things a step further by building this video game entirely within the confines of Microsoft Excel.

Now you may ask: Could Mr. Walkin have spent his time and ample talent doing something more worthwhile than building a video game using only spreadsheet macros? We say no. Keep on fighting the good fight, Cary.

Arena.Xlsm Animations Early Preview

I was going to hold off on uploading this until I had more animations in the game but I felt the desire to share. So this is a early preview of what will be coming in the future. Please forgive the choppiness and lack of audio, in the future I will use better screen capture software.

VBA4Play Part 2: Animation in Excel

This is the second part of the VBA4Play tutorial series. This tutorial is going to leverage off some of the code in VBA4Play Part 1: Movement and Collision Detection so be sure to view that prior to starting.

By the end of this tutorial, you’ll be able to make your own customized animations within Microsoft Excel. This tutorial is going to cover three different types of animation techniques: Uncontrolled, Wait, and Real-Time. Each type of animation has its own benefits and drawbacks so I’ll be going through the implementation of each of them step-by-step so that you will have the skills to use them in your own projects. Animation appears in every type of game so it’s important that we understand how to make effective animations so that we can make bigger and better games!

Okay, now let’s get started!

Continue reading

Arena.Xlsm is now on Steam Greenlight!

Arena.Xlsm on Steam Greenlight

If you want to see Arena.Xlsm on Steam vote here: http://steamcommunity.com/sharedfiles/filedetails/?id=149050793

Open Call for Localization Volunteers!

Currently Arena.Xlsm is in a state that I am happy with, the game mechanics are all in and they seem to be working well together. Now that there will be few game changes, I can now proceed with localization of the game into various languages. Arena.Xlsm was designed in Microsoft Excel for free to be accessible to the largest number of people as possible. By localizing the game into various languages, more people will be able to enjoy the experience!

The most commonly requested languages are:

  • Russian
  • French
  • Portuguese
  • Italian
  • Dutch
  • Chinese

If you can speak any of these languages and English fluently and would like to help translate Arena.Xlsm, please contact me via e-mail or comment below. If you want to translate the game into a language not listed above, please contact me and we can discuss the viability of getting another localized version out.

If you’re interested in helping make the game accessible to more people in another language, this is your opportunity to make it happen!

Thank you so much for your continued support!

Arena.Xlsm Version 1.3 Released!

The-Obstacle-Course

Arena.Xlsm Version 1.3 is now available here: Download Arena.Xlsm

This update contains a number of new features and content. Here are the highlights:

  • New Feature: Keyboard Controls. Access the controls through the new control button. You can now customize hot-keys for your most frequently used spells!
  • New Feature: Hard Mode! Unlockable after completing a play-through on Normal. Blood harvested from enemies is decreased by 1. Fame required to level up is increased by a factor of 2. The player does not start with any heals. Enemy health and damage is increased by 25%. Exhausted enemies do not lose their immunities.
  • New Feature: Statistics. The statistics will track your actions across multiple games.
  • New Feature: “Boss Key” – The Statistics spreadsheet is unlocked and can be quickly accessed by pressing the F key from within the game. You can add corporate logos and work to this spreadsheet to mask the fact that you are playing a game at work. NOTE: If you feel the need to use a “boss key” you probably should not be playing this at work. I will not be held liable if you get yourself fired for playing a video game at work.
  • New Feature: Title Screen. There is now a title screen when opening the game and after the player dies. The logo is dynamic and will change based on the player’s progress throughout the game.
  • 3 New Terrain Types: Movable Walls, Pressure Switches and Switch Walls. Move the Movable Walls on to the Pressure Switches to trigger an explosion on Switch Walls connected to the Pressure Switch. This can allow the player to access new parts of the arena and provides an additional challenge while you’re battling enemies simultaneously.
  • 3 New Arenas: The Box, The Obstacle Course, and The Great Barrier.
  • New Collection: Arena Tourist.
  • 61 New Achievements!

For the full patch notes, see the Arena.Xlsm Wiki.

Arena.Xlsm Version 1.3 Preview

Arena.Xlsm version 1.3 is coming along nicely. Here are some of the main things to look forward to!

New Tiles: Movable Walls and Pressure Switches – Movable walls are heavy walls that you can push around the arena. Push a movable wall onto a pressure switch to detonate the dynamite attached to that switch.  Dynamite can be attached to walls to access new areas of the map. Dynamite may also be attached to cracked terrain, explode the terrain under an enemy to cause the enemy to fall down a bottomless pit! Note that walls with dynamite attached can only be exploded via pressure switch. Be careful, if you push the movable wall onto cracked terrain or a bottomless pit, it will fall down and make the pressure switch unusable!

v1.3-arena-2c

New Feature: Keyboard Controls – You can now control every action in the game with the keyboard in addition to the mouse. This dramatically increases the speed of gameplay!

v1.3-Keyboard-Controls

New Feature: Statistics and “Boss Key” – The game now tracks your statistics across play-throughs. A lot of people have been requesting that I implement a “boss key”, which is a spreadsheet that can be pulled up quickly to mask the fact that you’re playing a video game. The Statistics spreadsheet can be pulled up quickly by pressing the F key while playing the game. The Statistics page is an unlocked and unprotected spreadsheet if you need it for this purpose you can customize it with work. NOTE: If you feel the need to use a “boss key” you probably should not be playing this at work. I will not be held liable if you get yourself fired for playing a video game at work.

v1.3---Statistics

If you want to volunteer as a tester and receive version 1.3 prior to the general public, please feel free to send me an e-mail with the version of excel you are using and I’ll add you to the volunteer tester group.

Please continue to follow me on Facebook and Twitter and Reddit for Arena.Xlsm updates and discussion. Thanks very much for your interest in Arena.Xlsm!

Arena.Xlsm Version 1.2 Released!

v1.2-arena-3b

Arena.Xlsm Version 1.2 is now available here: Download Arena.Xlsm

This update contains a number of new features and content. Here are the highlights:

  • New Feature: Import Data. You can now import old games! This allows you to continue your game in a new version without losing your progress!
  • New Feature: Dynamic Player Avatar – The player’s avatar will now change to reflect how the player is feeling.
  • 2 New Terrain Types: Cracked Terrain and Bottomless Pits present new situational strategies and challenges!
  • 3 New Arenas! 
  • New Attack: Lunge. Moving offensively into the melee range of an enemy will now automatically perform a lunge attack on the enemy with the player’s melee weapon. This will make it possible for the player to have the first hit in a melee confrontation.
  • New Collection: Emotional Breakdown.
  • 2 New Achievements:
    • My Emotions!!! – Collect all 10 Emotions.
    • Darkness Falls – Cause an enemy to fall down a bottomless pit.
  • New Enemy Type: Chance to Knockback.
  • Final Boss fight has been redesigned and is now much more strategic!

For the full patch notes, see the Arena.Xlsm Wiki.

Arena.Xlsm Version 1.2 Progress Update

Thanks for your patience regarding the version 1.2 update. Final exams and assignments have been dominating most of my time. However, I’ve been making significant progress on version 1.2. Have a look at the few remaining items still on my to-do list for version 1.2:

  • New Enemy Ability: Chance to Knockback. This will make it more challenging to avoid fire and the new bottomless pits!
  • The Ultimate Evil Boss Encounter: I’m redesigning this boss fight to give it a more “epic” feel. This requires some heavy scripting on my part but I think it’ll be worth it. Without spoiling the redesign, there will be multiple targets and you will need to make a strategic decision which target to hit at any time. This will be in addition to some new counterattacks that have been added to The Ultimate Evil to deal with some of the simpler strategies from earlier versions. I’m trying to get the balance on this just right so it’s not too hard but not too easy while still being a challenge.

In regards to the specific time for release, please continue to follow me on Facebook and Twitter and Reddit for updates and discussion. I hope to get the new version to the volunteer tester group sometime next week. Speaking of which, if you want to be a volunteer tester, please e-mail me with your Excel version(s) and I’ll add you to the list. You’ll be able to try out version 1.2 before everyone else!

In addition to the version 1.2 preview that I posted earlier, please enjoy some screenshots from the upcoming update below:

Continue reading