|
Ladies and Gentleman.
I give you Version 2
Firstly a very big thanks to Lee for crafting the dice chart that this is based of, secondly I hope people find it useful in some way or another.
It's still Ctrl+Shift+F9 to refresh / hard recalculate it, though every time you open it, it recalculates the sheet (check out the random number in the bottom right just to check it is refreshing).
It does pretty much the same as the previous one but everything now just happens in 'Sheet1', Sheets 2-5 are just lookup tables and random numbers that 'Sheet1' refers to.
(NOTE: Pink shaded cells signify random number generators, Grey shaded ones are displaying text that they've looked up from another part of the spreadsheet).
In this version an 'Event' occurs roughly 8 times in every 100.
Once again, if there's any questions just post them here.
Also if anyone who is unfamiliar with spreadsheets wants this slightly modified just say and I'll see what I can do
(e.g. Increasing or decreasing the number of times an 'Event' occurs or removing “Cards” from 'Sheet1' because its not relevant to your universe)
Cheers
Gary
This still requires OpenOffice Calc to use it.
|