Dammit, I was hoping there wouldn't be this much interest as I'm a little embarrassed over how rough it looks due to my limited knowledge of spread sheet functions.
Just some quick notes:
It's a slightly modified version of Lee's original sheet as I changed some of the durations and frequency of the events occurring to better fit my universe.
In my Open Office Calc I changed the "Hard recalculate" keyboard short cut keys from Ctrl+Shift+F9 to simply F3. So if your pressing F3 and it's not recalculating try Ctrl+Shift+F9 (click on the 'Sheet2' tab down the bottom to see if it's recalculating)
The way it works is you open it on to 'Sheet1' (Should be a orange page with either 'Event' or 'No Event' on it)
Recalculate to see if an event happens aka "Event" appears.
If so click on the 'Sheet2' tab to see what the 'Event' was. (Should be a purple page with Event type, Card for that month effected, Bout on that card effected, Fighter and the event, the repercussions of the event.)
Sheet3 is just the very messy formulates where Sheet1 and 2 get there info from.
I'd like to redo the whole thing so anyone can download it and easily edit the info in Sheet3 to better suit there universe. Due to lack of time this might not happen for a week or two.
Please feel free to ask me questions or give feedback.
Also it's nowhere as helpful as what jade_00 “new way of universing” excel spreadsheet is.
Cheers Gary
|