All Ocean Memorization Spreadsheet

From YPPedia
Official installicon.png
ATTENTION: This application is a third party tool.
It has been developed independently by a Puzzle Pirate player(s). It is not created, supported, or endorsed by Three Rings or Grey Havens.
Players use third party tools at their own risk. For a full list of third-party tools, see this category list.
For official rules and regulations regarding the use and acceptable functionality of third-party tools, see this page.

The All Ocean Memorization Spreadsheet is a Google Sheets spreadsheet to help users keep track of how many of the various oceans' league points they have memorized. Current oceans in the spreadsheet are Cerulean, Emerald, Ice, Jade, Meridian, and Opal.

Click here for a link to the Google Sheet of the most recent version. From there, you can create your own Google Sheet or download the spreadsheet in the format of your choice.

Previous Versions

Click here to download a previous version of the spreadsheet (it doesn't contain the portrait item logic or the pretty formatting).

Click here to download a previous version of the spreadsheet, which includes legacy oceans Cobalt, Hunter, Malachite, Midnight, Sage and Viridian; merged oceans Meridian, Emerald and Cerulean; international ocean Opal; and test ocean Ice.


The spreadsheet format and the Cobalt/Viridian and Sage maps were designed by Kerix. The merged oceans, Cerulean, Meridian, and Emerald were created by Aarghbird. The other ocean maps and the summary page were developed by Kargach. Jade Ocean (from Sage template) and archipelago labels added, and obsolete oceans pruned, by Vortexae. The portrait item logic and fancy formatting were added by Jamesh.