Saturday, March 21, 2015

Spreadsheet Update - Collection Tab: Need Count (Rarity)










































Ok, so just like the color section I removed the Standard Total Count at the bottom, I pull the same data from columns on the Set Tabs, and everything is referenced from this other blog.

http://dogonsiereht-mtg.blogspot.com/2014/05/spreadsheet-update-color-rarity-needs.html

Column T: Mythic Rare
Column U: Rare
Column V: Uncommon
Column W: Common
Column X: Basic Land
Column Y: Token

Column T: ='Journey Into Nyx'!$A$55
Column U: ='Journey Into Nyx'!$A$56
Column V: ='Journey Into Nyx'!$A$57
Column W: ='Journey Into Nyx'!$A$58
Column X: ='Journey Into Nyx'!$A$59
Column Y: ='Journey Into Nyx'!$A$60

Legacy Totals
Column T: =SUM(T2:T9)+SUM(T19:T26)+SUM(T36:T43)+SUM(T45:T65)
- This will get applied to each column with the same cells in that column.

Modern Totals
Column T: =SUM(T10:T17)+T23+T44+SUM(T66:T104)
- This will get applied to each column with the same cells in that column.

No comments:

Post a Comment

Break time

I am going to be taking a break from updating my blog until I start doing more with Magic the Gathering.  I am not going to sell the collect...