Jeff_Ray... wrote:
I'm really stumped... I tried pressing the buttons in the Control Page, but it keeps telling me that it can't load the macro. What's wrong?
I'm not sure. Do you have macros enabled? If not, you'll need to enable them (although I've forgotten how to do it in Excel 2003). However, you can still run the spreadsheet without the macros.
Make sure you have "
maximum iterations"
set to 1, and manual calculation on. Go to the "
Control Page"
spreadsheet.
1. Type 0 in the "
load preset"
and "
begin iterations"
boxes and 1 in the "
reset spreadsheet"
box.
2. Press F9
3. Type 1 in the "
load preset"
box and 0 in the "
reset spreadsheet"
box.
4. Press F9
5. Type 0 in the "
load preset"
box and 1 in the "
begin iterations"
box.
6. Press F9. The "
iteration"
box should begin to count upwards, starting with "
1"
.
7. Now keep pressing F9 at a regular rate (make sure the "
iteration"
counter increases by 1 before pressing F9 again), and you should start seeing a room appear in the "
direct room output"
grid.
You can speed the simulation by setting "
maximum iterations"
to something like 50 or 100, although you will not be able to see all the intermediate stages.
Does this help? Can you run the spreadsheet yourself? If you run the version I attached and if it works, you should get the room I posted
here. Let me know if you need any further help getting this to work; so far it seems like I'm the only person it actually works for!
____________________________
Resident Medic/Mycologist
[Last edited by agaricus5 at 02-16-2009 01:32 AM]
