This is an old revision of the document!
Right after campaign closes, document how many books (or whatever) we gotta order. This is separate from address verification and requires no additional user feedback,
Download the KS full backer report CSV, save in richer format. We will chop up this copy, it's dedicated for this role. The goal is to figure out how many books I need to order, so extraneous information like ebook add-ons and how much the backer has paid can and should be deleted. This task is annoying enough without that cruft.
Copy the previous fulfillment spreadsheet. Two halves: the individual books to order for this title, and the backlist bundle section.
Add other columns as needed. You need at least “signed pb,” “signed hb,” “special ed,” “drop pb,” and “drop hb.” Hopefully I'm not dumb enough to add other rows.
Add other rows as needed for items like “add-on extra copies” for dropship and/or signed.
gray out boxes for impossible combinations.
Begin whacking the spreadsheet columns.
Sort by “Reward Title.” Count how many of each reward we got. Fill in the spreadsheet for those numbers.
keep the name and email address for later reference, but chop out money columns.
Look through the Addon columns. If the column refers to a physical thing that I need to buy, keep the column. If it's a digital reward, delete it. If a physical reward had no takers, keep the column for verification.
Sort by each surviving column. See how many of those add-ons we got. The numbers for “all the fiction,” “cross-unix mastery,” “all the tech books,” and “the full michael” go down in the second half.