 |
Gaming and Simulation Using Microsoft Excel
| |
| | Unformatted Document Text:
SB46
J
ACKSON
:
E
XCEL
S
IMULATIONS
P
AGE
19
OF
41
Fig. 6-- Paste Function Dialog in Excel
Lots of different functions are available that are useful for simulations. Pick the "Logical" one from the left list and then "IF" from the right list. Another dialog will come up:
Fig. 7 -- Logical Test Dialog Box.
In "Logical Test," put a formula such as "B3>1" and then in "Value_if_true" put the text or the cell reference with a number or text in it. This could be an error message, a clue to a puzzle, encouragement, a challenge, or whatever. It is an opportunity for feedback to the user based upon what they put into various cells. Logical functions such as IF conditions can be used to create contingent results; if the participant chose a particular alternative earlier on, then one set of choices is displayed. If, however, they chose another alternative at the beginning, their choices later on change.
2. Random numbers. Random numbers are very useful if you want conditions to change during a simulation. If you want a number between, say 1 and 10, then "=RANDBETWEEN(1,10)" is the formula to use. Random numbers are a good way to introduce an element of uncertainty in your simulations so that a number changes within
|
| | Authors: Jackson, Steven. |
|
| |
|
|
SB46
J
ACKSON
:
E
XCEL
S
IMULATIONS
P
AGE
19
OF
41
Fig. 6-- Paste Function Dialog in Excel
Lots of different functions are available that are useful for simulations. Pick the
"Logical" one from the left list and then "IF" from the right list. Another dialog will
come up:
Fig. 7 -- Logical Test Dialog Box.
In "Logical Test," put a formula such as "B3>1" and then in "Value_if_true" put the text
or the cell reference with a number or text in it. This could be an error message, a clue to
a puzzle, encouragement, a challenge, or whatever. It is an opportunity for feedback to
the user based upon what they put into various cells. Logical functions such as IF
conditions can be used to create contingent results; if the participant chose a particular
alternative earlier on, then one set of choices is displayed. If, however, they chose
another alternative at the beginning, their choices later on change.
2. Random numbers. Random numbers are very useful if you want conditions to change
during a simulation. If you want a number between, say 1 and 10, then
"=RANDBETWEEN(1,10)" is the formula to use. Random numbers are a good way to
introduce an element of uncertainty in your simulations so that a number changes within
|
|
 Convention | | Need a solution for abstract management? All Academic can help! Contact us today to find out how our system can help your annual meeting. | | Submission - Custom fields, multiple submission types, tracks, audio visual, multiple upload formats, automatic conversion to pdf. | | Review - Peer Review, Bulk reviewer assignment, bulk emails, ranking, z-score statistics, and multiple worksheets! | | Reports - Many standard and custom reports generated while you wait. Print programs with participant indexes, event grids, and more! | | Scheduling - Flexible and convenient grid scheduling within rooms and buildings. Conflict checking and advanced filtering. | | Communication - Bulk email tools to help your administrators send reminders and responses. Use form letters, a message center, and much more! | | Management - Search tools, duplicate people management, editing tools, submission transfers, many tools to manage a variety of conference management headaches! | | Click here for more information. |
|
|
|
| |
|
|
|
