If you have playtesters fill out surveys, do you have them fill out any questions before playtesting so that you can assess changes in variables like mood, energy level, etc.? Mainly the pre-playtest questions are getting used to the process and being comfortable.
How to handle volatile functions like they are dynamite?
In fact, it’s not just entering data that will trigger a volatile function to recalculate, but also these things (among others): Deleting or inserting a row or column. Performing certain Autofilter actions. Double-clicking a row or column divider (in Automatic calculation mode).
Why do volatile functions take so long to calculate?
The fact that each and every cell ‘downstream’ of any volatile formulas get recalculated is an important point to get your head around. Many people think that slow calculation times due to volatility is due to the time it takes to recalculate large amounts of volatile functions in a model.
How can I Make my playtesting experience more enjoyable?
You can make your playtesting experiences more enjoyable by choosing games within the spectrum of games you usually like to play. If you are familiar with other games within the same genre or mechanical style, you’ll be able to offer feedback that’s informed by knowledge of similar games.
What’s the best way to do a playtest?
Below are some answers to playtest related questions I have given over the years: 1. What form (s) of feedback do you collect from playtesters? (e.g. survey, focus group, 1-on-1 interview, playtesters voice thoughts while playing, etc.) If you collect multiple forms, which form do you think gives you the most useful information?
Which is the best interview after a playthrough?
1-on-1 interviews are the best (and, ideally, required) after a playthrough of the experience. Voice thoughts and (even better) video while playing are super useful for team members who can’t be there or for reviewing after a survey or a 1-on-1 has dug up a few outliers. The most useful (in my opinion) is the 1-on-1 interview.