You must be registered to see the links
, both with the new 382-407 events for v0.002, as well as a "few" other changes. I wanted to make the spreadsheet a little easier to use, and originally planned to just move some columns around and retitle them for ease of use.
...I
may have gone slightly beyond what I intended. But hey, easier filtering! Also, I shouldn't have to do nearly as much work to update it in the future.
Regarding the moving of columns, Prior Event really needed to be next to Event. Prerequisites can take some work to figure out, especially when trying to get the Helena/Kately threesome in the pool. It's event0363, and it has 2 prerequisite events, the first of which requires L3 Alexa. Also, one of the v0.002 events is an Alexa pool scene that has 0363 as a prereq.
(A couple notes on the time filters: First, I really wanted to be able to filter by only updating one value instead of TimeMn and TimeMx separately, so I did a fair amount of learning in getting the conditional time slicers to work. Unfortunately, after I did all that work, I realized that other users can't edit the time value cell on the public copy. Whoops. So anyone that wants to use the existing time filter will have to make their own copy of the spreadsheet. All the other filters should work for anyone though, and if people really don't want to make a copy, they can always change the "Filter by Condition" on TimeMn to "Greater Than or Equal To" their time, and on TimeMx to "Less Than or Equal To" their time.
Second, Sheets doesn't seem to support real-time filtering based on a cell value. I worked around that as best I could, but users will have to manually refresh the filters to update them. Fortunately, that's as easy as clicking on the "funnel", then clicking "Okay". It's a little annoying, but it's easier than manually typing the new value into both filters each time.)