Talk:All Ocean Memorization Spreadsheet
Jade is missing
Rough remedy is to rename the Sage tab and edit the appropriate cell in Summary. The more detail-oriented memmer will want to edit all the island comments to reflect the Spanish island names, though. (If I can find the time somewhere, I might make those changes and upload the results.) —Preceding unsigned comment added by Vortexae (talk • contribs)
- You think it might be worth removing the obsolete oceans while you're at it? --Belthazar451 03:01, 7 March 2013 (PST)
- That's the easy part :-) Sorry I let this slip off my radar - I should be able to get to it this weekend. -Vortexae 11:19, 16 March 2013 (PDT)
Islands: Visited versus Memmed
While I'm working on a new version: The instructions and graphs all refer to islands as visited or unvisited (whether or not you get the diamond marker on your known world), when I think the real intended use is to do with memming island league points (whether you get the brown circle next to the diamond marker). I was thinking of correcting the wording so that it clearly refers to memming - but would it be worthwhile to have three possible states for the island spots: unvisited, visited and memmed? -Vortexae 11:37, 16 March 2013 (PDT)
- We may have to leave this question up to someone who can actually figure out how a 4th conditional formatting rule got successfully created when Excel seems to only allow 3. I've only got Excel 2002, if that makes any difference. -Vortexae 13:13, 17 March 2013 (PDT)
- Nevermind - I see how it's done, and I can sort of see how to create another island status condition. It'll be a pain in the butt, though, so we'll put it on the back-burner. Meanwhile I'll upload what I've got for now.
Formula Error
There's a minor error in the formula for total LPs Memorised in the Cerulean Ocean sheet, lol.
