File:SSHM Giftable Collections.ods

Summary
An open document spreadsheet list of SSHM giftable collections (all data current through February 2017). **Non-giftable collections are *not* included.**

The Wiki user should NOT use the spreadsheet directly but rather save a copy locally. This spreadsheet is in Open Document Source (ODS) format so I could upload it directly to this Wiki. However, you may wish to save it in XLSX format instead of ODS to make use of features not supported in the latter (like Freeze panes, modified formatting (like adding more cell shading), advanced filtering, and advanced sorting. The spreadsheet was created for onscreen use and has not been formatted for printing.

There are comments in some of the headers for clarification. The list sort column is my numbering based on the order in which items appear in the Collection Item tab of the Gifts screen within Friends in game. The default sort is that order. There is an extra filter column in case a user needs add data to apply a temporary sort or filter not already included elsewhere in the spreadsheet. There is also a column for users to note whether or not they have completed the collection yet. Collection items have varying details. In addition to whether they're required for an artefact, they may be one regularly found in one or more regular locations with or without a quest (N in Col F, # items in Col H), quest only found in a location only with an active quest (Y in Col F, # items in Col G) or a combination of the two (P in Col F, # items in both Cols G & H) and some even require an anomaly or a picture mode. For each collection, its rewards for completion, individual items and combing element requirements are also noted and quantities listed (except coins) are in separate columns. Sorting can be by any column or combination thereof. Likewise with filtering. While the above details are noted for each collection, the specific related artefacts, quest names, regular location names, anomalies and picture modes are *not*. This is both to make updates possible and because these details are subject to change too much (like with the Winter's Tale update in which numerous collection items had their locations updated). Also, where it is noted that a location is indicated in the item's details in game, that refers only to the item's regular location. Many, though not all, quests, when active will indicate a different location where the item can be found. At that time, that location will be noted in the item's details in game temporarily, in addition to the regular location(s), for the duration of the active quest. This makes it seem as though item details change more often than they actually do.