16,552 New Trade in, but not 100%

Lets start out with the big one!

Pretty decent trade here, I did trade away a couple of Revised dual lands for these cards and it was a pretty even up trade, but I really wanted to get the trade done because it is with a really cool trader that I love making trades with.  I did get a couple of Standard cards, and some Legacy cards, but most of them are Modern cards.  Considering that I am starting on the Modern sets I consider this a big win on my side.  I was also able to pick up a Temporal Trespass for trade.  There was one card that I am waiting on to finalize, but I should be able to accept the trade soon.

Next trade:

This was a small trade with one Legacy and four Modern.  Four cards that I needed and one for trade.

16,635 Incoming Trade

Just got a trade in, a couple of Modern and some good Legacy...

A little blurry, but still some good adds.  Getting really close to filling out those Legacy expansion blocks.  I have not even touched the Core sets past Sixth Edition, and I am thinking that I won't even come close until after Modern Blocks are complete.

Love me some Elvish Champion!

16,657 Eldrazi and Reforged are complete!

Keep the count going down!!

Boom!  Rize of the Eldrazi done...

Finally got my Ulamog to finish up this set!

Boom!  Fate Reforged done...

Not as exciting because the this set has just been released, but either way DONE!

Important Mythic Rare for Worldwake...

Then got me some Magic 2011...

Important ones here are the Leyline of Sanctity.  These were hard to come by, but happy they are added.

Khans of Tarkir and Dragons of Tarkir...

These are only the Khans of Tarkir cards

Then I decided to pick up some trading fodder...

So I am pretty sure this is going to get reprinted in Modern Masters 2015, but I needed to pick these up before they head to +$100.  Kind of pains me, used to have 2 foils and traded them away. Seriously need to track back to see what I got for them.

I also was able to pick up these gems...

I really dont think these will go anywhere, but there are some promo cards that were only released in these decks for M15, so I had to pick them up.  I was lucky to find some so late in the release of M15.

I was running low on Ultra-Pro sleeves, so my favorite LGS got me a case.  So it just brings me closer to sleeving the collection...

Dragons of Tarkir pre-order is in!

The Pre-Order is in!  Once again I got my order from Mead Hall Games, which can be found here:

www.meadhallgames.com

Love these guys!

So yeah, I have a massive work weekend with some upgrades we are going through, so my plan is to open all the Tarkir block boxes, print out all the labels, and get everything sorted.  I really need to get caught up and get ready to play some standard.

So I hope I can get all this sorted out, and post my real countdown number to the blog.  But speaking of the countdown number, there is a guy from the Mead that is going for a complete set of Alpha and he is posting pictures of every card he gets.  So that got me thinking, since I always just post my sealed product, I think I am going to start posting pictures of all the cards I do get in, if it is for a trade or a purchase.

Well here is the picture!

Also wanted to add that I got the Buy a Box promo for Dragons of Tarkir!

Spreadsheet Update - Collection Tab: Need Cost

Ok, so just like the color and rarity section I removed the Standard Total Count at the bottom, I pull the same data from columns on the Set Tabs, but with this section I needed to add some more collection cells to those Set Tabs.

Cell A65: =SUMIF(X2:X600,"M",AA2:AA600)
Cell A66: =SUMIF(X2:X600,"R",AA2:AA600)
Cell A67: =SUMIF(X2:X600,"U",AA2:AA600)
Cell A68: =SUMIF(X2:X600,"C",AA2:AA600)
Cell A69: =SUMIF(X2:X600,"L",AA2:AA600)
Cell A70: =SUMIF(X2:X600,"T",AA2:AA600)


What this formula does is Looks into Column X from Cell 2 - 600, then it looks for the character defining the rarity (M = Mythic Rare), and will add up the dollar amounts in column AA if they match the search from Column X.

This way, we can look at the rarity column for the cards and do a check in the rarity we are looking for.  If the rarity is found, we can then SUM up the total price for all the cards with the specific rarity from the price column.

With this new Set Tab data collection we can now total it up in the section on the Collection Tab.

Column AA: Mythic Rare
Column AB: Rare
Column AC: Uncommon
Column AD: Common
Column AE: Land
Column AF: Token

Now we will fill the cells with the formulas with the needed Set Tab information.

Column AA: ='Journey Into Nyx'!$A$65
Column AB: ='Journey Into Nyx'!$A$66
Column AC: ='Journey Into Nyx'!$A$67
Column AD: ='Journey Into Nyx'!$A$68
Column AE: ='Journey Into Nyx'!$A$69
Column AF: ='Journey Into Nyx'!$A$70

So now we can gather all the data from the Set Tabs to find how much I would need to fulfil the sets I need.

Legacy Totals
Column AA: =SUM(AA2:AA9)+SUM(AA19:AA26)+SUM(AA36:AA43)+SUM(AA45:AA65)
- This will get applied to each column with the same cells in that column.
- This Cell is right below the complete total cell in Bold Blue.

Modern Totals
Column AA: =SUM(AA10:AA17)+AA23+AA44+SUM(AA66:AA104)
- This will get applied to each column with the same cells in that column.
- This Cell is right below the Legacy total.

There is a Standard total right under the Modern Totals, but I no longer use that total because it just changed too much, and I would fill out my Standard needs pretty quick.

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.

Spreadsheet Update - Collection Tab: Need Count (Color)

So during my counting of all the cards I had, I hit an issue with how much space I needed for all the cards that I did not have yet.  I had 3200 count boxes, and moved to 3 row boxes that hold up to 4000 cards.  A lot of these cards would be in sleeves, and have card separators.  The question I had is how much space will I need for the rest of the cards, and I would need that count for both Vintage and Modern stacks.  And on top of that I would need to know per color how much space I would need.

I the added these columns to see how many of a color I needed on a per set basis.

Column J: White
Column K: Blue
Column L: Black
Column M: Red
Column N: Green
Column O: Gold
Column P: Colorless
Column Q: Artifact
Column R: Land

And then I populated the cells per color, per set with the data I collected from the Set Tabs.

Column J: ='Journey Into Nyx'!$A$42
Column K: ='Journey Into Nyx'!$A$43
Column L: ='Journey Into Nyx'!$A$44
Column M: ='Journey Into Nyx'!$A$45
Column N: ='Journey Into Nyx'!$A$46
Column O: ='Journey Into Nyx'!$A$47
Column P: ='Journey Into Nyx'!$A$48
Column Q: ='Journey Into Nyx'!$A$49
Column R: ='Journey Into Nyx'!$A$50

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

So really I am taking this data I am collecting from all the Set Tabs and compiling it here for the total counts of all the colors based on sets needed to complete my collection.

Really, it is just a good way to know how many more cards I need to plan for in the boxes I have to finish.















Again, at the bottom I have the totals per collection stack and what is required to finish.  Also, I have updated spreadsheet today to remove the standard totals.  The sets switched out so frequently I just felt it silly to keep up with those counts.

Legacy Totals
Column J: =SUM(J2:J9)+SUM(J19:J26)+SUM(J36:J43)+SUM(J45:J65)
- This will get applied to each column with the same cells in that column.

Modern Totals
Column J: =SUM(J10:J17)+J23+J44+SUM(J66:J104)
- This will get applied to each column with the same cells in that column.