Here is the first section, and really the first part of this tab that I configured. What this does is total up all the cards on all the set tabs to show you what your current collection is set to. So if we look at the cell configurations we can see that it is pulling directly from the set tabs.
Column B: Set total
Column C: Mythic Rare
Column D: Rare
Column E: Uncommon
Column F: Common
Column G: Basic Land
Column H: Token
Column B: ='Journey Into Nyx'!$A$6
Column C: ='Journey Into Nyx'!$A$7
Column D: ='Journey Into Nyx'!$A$8
Column E: ='Journey Into Nyx'!$A$9
Column F: ='Journey Into Nyx'!$A$10
Column G: ='Journey Into Nyx'!$A$11
Column H: ='Journey Into Nyx'!$A$12
This is a snapshot of the Total Column on the Set Tabs. We are looking at the Collection section near the top. And if you remember from the Set Tab setup, we looked at the card counts and split up those counts by rarity.
So what this will do is collect all the totals from all the Set Tabs and condense them all on to this single tab. You will get the total, and all the other rarities split up for all the sets, and then at the bottom a total for your entire collection of singles. And since we split out the Foil and cards for Trade, you will just get the count for cards you consider in your collection.
Also just wanted to point out that the last set on this picture is Journey Into Nyx, and it is currently pre-release weekend for Dragons of Tarkir, so you can see that I have not really done much for pretty much a year... :-) I have updated the entire spreadsheet with all the latest sets, just not my pictures.
No comments:
Post a Comment