[Charlatan]

I like tinkering around with spreadsheets and I've developed a way to track missions that I really like - so I thought I'd share it with y'all.

This code tracks how how many cards you need to complete the collection, how much you've spent, and how much you still need to spend to complete it. And it answers one simple question: if you completed the collection and sold the reward, would you gain or lose PP?

Note that there's one gigantic assumption here: that the cards making up the collection have no value. You buy them and put them on your reserve roster forever. This calculation is quite different if you end up using a few cards from the collection.

At any rate, let's answer the easy question.

First Picture
The first figure shows how I've got it set up in the spreadsheet. At the top left is the mission name. Top center is how many cards I need to complete the mission. Top right is the "worth it or not" determination... green means "worth it" and red means "not worth it."

The orange column ("Pd") down the middle is where you enter the prices paid for the cards... in this case I don't have any of the cards, so there's no values there. The AH column shows prices I've gotten off the auction house for the cards in question. When I'm not sure of the price (uh... like if I'm completely guessing!) I italicize it.

Second Picture
The second picture shows one of the magic formulas. This formula tracks how many cards you need to complete the mission. As you fill values into the orange column, this number will go down.

Third Picture
The third picture is the second magic formula. The "Remaining" cell consists of the sum of the "lowest n" cards you need to complete the mission, where "n" is the value calculated from the second picture. So as you get cards for the mission, this sum continues to update to reflect how much you still need to spend to complete the mission.

Fourth Picture
This picture describes the formulas or meanings of the remaining cells.