I welcome your assistance. Attached is the current version of the spreadsheet. You'll see the states listed across the bottom. Most have the same basic headers... there will be some customization for each state. The alternate ID for TN notes is Garland, for AL notes it's Rosene... I don't know what other alternate references exist. If the default denominations are inadequate, fee free to add more as needed.
My coding on the Haxby reference numbers is probably not completely obvious, so I'll explain. If a lot contained 6 denominations, I list the Haxby type numbers in the order of increasing denomination (i.e. same as the headers). If some notes are listed and others aren't, I put UNL in the slots where the notes are unlisted. That way when I look at the available denominations I can line them up with Haxby numbers. If no Haxby numbers are listed I just put Unlisted in the box, so it's clear I didn't just overlook the numbers.
I'm trying to capture all of the information in the catalog, even if it doesn't necessarily align with my interests. So if I see some Post Notes that are partial prints with no bank/company name, I capture them as best I can in the appropriate state's worksheet. That's the sort of stuff I'll try to sort out later, possible putting them into a Misc worksheet.
Like you, I got the catalog without the prices realized. While I find that information interesting, it isn't something I'm interested in tracking, per se.
As an aside, I do have some slight ancillary information... a few notes from the H.R. Harmer sale last year, for example. My concern with the ancillary information is that in most cases I have no obvious way to discern which of the ancillary notes are already represented in the Christies catalog (i.e. which were sold as sheets and cut up for resale as individual notes). So I'll start with Christies and carefully add whatever is obviously not as described by Christies (i.e. missing the pink stamp when Christies says it is there, or otherwise different enough to be regarded as not the same notes). To your question, I'm not sure how to handle the pre-Christies notes... since in general I don't have a way of knowing whether the note came BC or AC.
Thanks for the offer of assistance. It is truly appreciated.