All cards through The Voice of Isengard except the Nightmare decks.
Revised some labels; fixed some formatting; corrected Boons split for The Black Riders.
Renamed file; removed "Cards" tab (moved to my Game Log file); corrected counts split for Assault on Osgiliath; moved Saga expansions to near the bottom; fixed an adventure pack spelling mistake.
All cards available for purchase to date except the Nightmare decks.
Added The Lost Realm, The Old Forest, and Fog on the Barrow-downs. Moved Treasure cards to under Player cards. Added "Side Quest" type to Player cards. Added an Encounter "sphere".
Added the Angmar Awakened cycle, The Treason of Saruman, and The Land of Shadow.
Added The Grey Havens, The Ruins of Belegost, and Murder at the Prancing Pony. Implemented calculations of counts based on user entered number of copies of Core Sets / expansions.
Added the Dream-chaser cycle, The Sands of Harad, and The Flame of the West.
Added all player packs up to latest Erid Mithrin AP, including Starter Set and latest POD's. Created section for Nightmare with a separate total - a new "grand total" will total up everything.
Added new player card type for Contract cards
Added new section for ALeP cards
Starting with v1.6, the card counts are calculated based on the number of copies of Core Sets / expansions entered in column D on the "Counts" tab.
This allows the user to calculate the card counts for the entire pool available, for the user's personal collection, for a pending purchase (to determine the number of sleeves needed), etc.
The default is 3 copies of the Core Set and 1 copy of everything else.
If the number of copies of the Core Set / expansion is 0, the cards that come in the Core Set / expansion will not contribute to the card counts.
If the number of copies of the Core Set / expansion is 1, the counts will reflect the actual number of cards that come in the Core Set / expansion.
If the number of copies of the Core Set / expansion is >1, the counts of non-hero and non-treasure player cards (allies, attachments, events, and side quests) are adjusted for the Core Set and possibly for the expansions (see Settings below).
Multiple copies of the Core Set or expansions do not impact non-player cards, including hero and treasure cards.
The settings below impact the counts of the non-hero and non-treasure player cards.
The Y or N "Cap" setting determines whether the number of copies of any given player card is capped at 3 or not.
Y: A maximum of 3 copies of each player card is included in the counts regardless of the number of Core Sets / expansions owned.
N: The actual number of player cards in the Core Set / expansion is multiplied by the number of copies of the Core Set / expansion owned. (NOTE 12/31/18: This is bugged, for totals to be correct please keep as "Y" for now)
The "Gandalf" setting allows the user to enter the number of copies of Core Gandalf as an override of a "Cap" setting of Y.
For example, I personally own 3 copies of the Core Set but only want to count 3 copies of each player card. However, I want to count 12 of Gandalf, because I could potentially put 3 each in 4 decks.
If the "Cap" setting is Y, then the "Gandalf" setting is N/A and the number of copies of Core Gandalf is calculated normally (the number of Core Sets x4; see below).
The Core Set counts account for how many copies of each player card are in a single Core Set and are used in conjunction with the "Cap" setting.
For example, in a single Core Set, there are 15 Leadership Ally cards (2 cards with 3 copies, 4 cards with 2 copies, and 1 card with 1 copy).
If the "Cap" setting is set to Y, a second Core set increases this to 20 (3x the 6 cards with 2-3 copies + 2x the 1 card with 1 copy), and a third Core set increases this to 21 (3x the 7 cards).
If the "Cap" setting is set to N, a second Core set increases this to 30 (2x the total of 15 cards) and a third Core set increases this to 45 (3x the total of 15 cards).
Of course, any calculation can be overriden by manually entering a number in that cell.
I plan on continuing to expand this sheet with ALeP (community-made continuation to the game)
Cap Player Cards at 3
NOTE 12/31/18: Please keep this as Y for the time being - core set totals may not work correctly without it.
Copies of Core Gandalf
Only applicable when the "Cap" setting is Y.