I apologize first for such a strange topic, but I need help with excel about my X-Wing collection so I thought I would ask here.
I got started by downloading the Excel Collection Catolog files created by others originally on the Index of Useful Links. The one I use had only up to wave two and I learned enough of the formulas and how to connect it together to get me up to wave 8 and prepared for Veterans and Heroes coming up this year. I had added the calculation to add up all the cards to get the correct amount of sleeves. However after acquiring 8 packages of Pilot Card sized sleeves I have many left over. This is because I am going to sleeve all the pilots, but not more than one of any of the uniques. So I have put aside the second Darth Vader, the second and third Miranda Doni etc. This will also apply to unique titles or crew for the upgrade sleeves. I need to know how I can change the formulas to account for this.
I am using Column B to put in the quantities of the expansions that I have purchased. B5 is the X-Wing Expansion and I have entered 2. I have column E where it lists the Pilot Cards and the first entries are for X-Wing (T65) and the first entry is E5 for Wedge Antilles the =B5 is entered making the number two. Now to count the Pilot cards total I have =E5+E6+E7+ ... which gives me a total. Mine is sitting at 447 and now I want to keep that number for my collection purposes and make another location for sleeves needed. In doing this I want to be able to calculate that I need one sleeve for all the named pilots Wedge, Luke, Jek etc. but I will get a sleeve for each of the 5 red squadron pilots and 5 rookie pilots. I.E. 8 named pilots (8 sleeves) 5 Rookie and 5 Red Squadron (10 Sleeves) even though because of my purchases I have 2 Wedge, 2 Luke 1 Wes etc.
I am sorry for the redundancy and elementary level of explanation, but I know so little about excel, but I know what I want to achieve and not knowing if it is best use a new formula (and what it would be), count if, etc. that would be more understandable to an experienced excel user. For a non-excel user this seems all to pointless and I could just count the cards that I need to sleeve, but if I get this formula I can use if for all the purchases in the future and know what I need to buy.
So if anyone can help me figure out what I can use or send me in the right direction. I would appreciate any help.
Sincerely
Brandon