I have a goal to have at least 1 sealed booster box per Core and Expansion set all the way back to Revised and The Dark. Yeah, totally crazy but I am hoping to at least one day have a sealed box of Arabian Nights, Antiquities, and Legends but I really have only seen Legends for sale on IDeal808.com.
So the rest of this tab is going to be used to keep track of all the the sealed product I own. The issue that I have hit with this tab through the years is that there are many different forms of packs. I have tried to gather up the data on every type because I own many different variations from many different sets.
Dk = Preconstructed Deck
Bo = Booster Pack
Box = Booster Box
St = Starter Deck
Fa = Fat Pack
FB = Fat Pack Box
As you can see I have grouped the expansion sets by block, and separated the blocks by different colors. There is no defined reason for the color other than to separate them from each other. You will also notice that some of the sets are in Bold, those sets are the ones accepted in Modern, and the non-bold sets are Vintage/Legacy sets. I know you can use Modern cards in Vintage/Legacy decks, but I needed a way to split up the older cards with the newer cards. This also follows the way I have split up the cards stored in the boxes.
Column B, C, D, E, F, and G are used to keep count of the different products.
*I keep track of opened Fat Pack boxes in Column G, there is no card count assigned to these counts, but I just like to keep track of how many boxes I have.
Column H is used to show the price of a complete Sealed Booster box that is manually inputed.
Column I is used to show the price of a complete Sealed Starter Box that is manually inputed.
Normally I gather the prices from www.abugames.com.
Column K is going to be the card count total for all the sets
Column L is going to be used to get the card count for Preconstructed Decks
Column M is going to be used to get the card count for Booster Packs
Column N is going to be used to get the card count for Booster Boxes
Column O is going to be used to get the card count for Starter Packs
- Some of the older prices are based on deck rather than boxes of Starter Packs.
Column P is going to be used to get the card count for Fat Packs
Column R is going to be used to get a total price count of Booster boxes
Formulas
Column L: =IF(B2="","",(B2*60))
- This will look at what is in cell B2 and multiply it by 60 as preconstructed decks have 60 cards
Column M: =IF(C2="","",(C2*15))
- This will look into cell C2 and multiply it by 15 as booster packs have 15 cards
Column N: =IF(D2="","",((D2*36)*15))
- This will look into cell D2 and multiple it by number of packs then by number of cards since booster boxes have 36 packs of 15 cards
Column O: =IF(E2="","",(E2*60))
- This will look into cell E2 and multiply if by 60 as starter packs have 60 cards
Column P: =IF(F2="","",(((9*15)+80)*F2))
- This will look into cell F2 and multiply it by ((number of packs * cards in pack) + land pack) since fat packs normall have 9 booster packs of 15 cards, and an 80 basic land pack
*If you notice, all the formulas for the count will do a check to see if the cell is empty. If it is empty, then it will stay empty, but if there is a value in the cell it will preform the formula.
Column R: =IF(D2>0,D2*H2," ")
- This will look into cell D2 and see if the value is greater than 0, if it is it will multiply the number of boxes by the price manual gathered, if not then it will post a blank cell.
So in this section we have all the Core and Expansion, then we have all the pack types, and we should be able to keep track of the numbers of each pack/box. Then we will find the card count of the sealed products as well as the total prices of the sealed booster boxes. We will use this later on the Total page, but for now on this page you can see the totals on Row 97.
Cell K97: =SUM(K2:K96)
Cell R97: =SUM(R2:R96)
No comments:
Post a Comment