Cost of my herc

I've put the Excel spreadsheets I used to generate those nifty charts on my web site. Both files are the same (you only need to grab one). They just have different data for my two purchases. If anything, it will help you add up all those packs so you know when you've hit 10k overall.

pw.solandri.com/files/herc%20purchase%20public.xls
pw.solandri.com/files/phoenix%20purchase%20public.xls

I made them for personal use so they aren't very pretty. I highlighted the fields where you enter your data in yellow, and protected the rest of the cells. Basically you:

1. Clear all the yellow cells of any data.

2. As you open each pet pack, you write down how many SoF or feathers you got from each pack in a new cell in column A, starting from A1 (above the line). Don't worry about whether they're SoF or feathers, you'll figure that out in (3).

2a. The top row will tells you your totals. E1 = total, G1 = average per pack. When E1 hits 10,000 you are done (although you may have to trade SoF for feathers or vice versa). Columns B and C tell you the same thing at any point in time while you were opening the packs.

3. The SoF and feather packs will automatically form stacks in your inventory. Every now and then put the number of packs in these stacks into the yellow region in the upper right. For ease of entry, I suggest putting them in your inventory like they are in the spreadsheet. One row for source packs, the row underneath for feather packs. Going 10, 20, 30, 40, 50 from left to right.

3a. The numbers surrounding that yellow block adds up SoF and feathers, and packs. F5 and L2 should be the same as E1. If they're not, you made a mistake somewhere. M5 and L6 should equal the number of packs you've opened (rows you've filled in column A). (L5 is a checksum and should always be 0. If it's not, the spreadsheet is broken.)

4. The charts should update automatically, up to the number of packs I had to open. I dunno what happens if you open more, you may have to edit the charts. They are just for show, and don't affect the calculation of the totals and averages.

5. If you end up opening more packs than I did, you'll have to copy the formulae from columns B, C, and D down to the new rows. It should work up to 499 or 500 packs. I don't remember what I used as the limit.

5a.Column D is a running average of 20 packs (10 before, 10 after) so it should stop 10 packs before your last one. Likewise, D1 to D10 are also empty for this reason.

6. When you're done, give Peritia a copy of your pack totals (the numbers in the yellow block on the upper right), so we can statistically verify how many packs it should take on average to reach 9999.