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.
Subscribe to:
Post Comments (Atom)
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...
-
Trade with me on CardSphere!!! https://www.cardsphere.com/ref/711/e4031f So my plans to keep going with this Blog has hit a proce...
-
So being away from writing I was not just sitting around doing nothing. I was still trading and purchasing cards, but in doing so I hit som...
-
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...
No comments:
Post a Comment