Collecting by the Numbers: Catalogue Values, Condition Grades, Set Completion, Auction Results with Fees, Insurance Values & a Collection Index
Manage a collection of coins, stamps, cards or models like a curator. You will build a catalogue with condition grades and value multipliers, track set completion and duplicates, compare catalogue values with fictional auction results after fees, set insurance values, follow the collection's value with a simple index and plan a budget for missing pieces, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you run the numbers of a fictional collector of coins, stamps and railway cards, one spreadsheet lab at a time. You summarise a catalogue by series with COUNTIFS, SUMIFS and MINIFS, value every item with a fictional grade scale and XLOOKUP, and measure how complete a set is and which design is missing first. You count spare copies for a fair swap, turn hammer prices into what the buyer pays and the seller receives after fictional fees, and set replacement values and a premium with a minimum. Then you track the collection's value with a base-100 index and average growth, and plan the cost and months needed to complete every set.
Lessons
- The Catalogue: Item IDs, Series, Years, Conditions and Completeness Checks Pro
- Condition Grades: a Fictional Scale, Value Multipliers and Value per Item Pro
- Set Completion: Owned vs Needed, Per Cent Complete and the Missing List Pro
- Duplicates and Swaps: Spare Copies, Swap Values and a Fair Swap Balance Pro
- Auction Results: Hammer Price, Buyer's Premium, Seller's Commission and Net vs List Value Pro
- Insurance Values: Replacement Value, a Fictional Premium Rate and the Single-Item Limit Pro
- Collection Index: Value per Year, Change Per Cent and a Base-100 Index Pro
- Budget & Dashboard: Cost to Complete Each Set, Months on a Budget and a Chart Pro