I have no problem with separately tracking the unique SENC, Proof, and UNL in Haxby.
I was wondering why you were creating separate spreadsheets for the “unique in Christie with Christie listing SENC” and “unique in Christie with Christie
NOT listing SENC” ???
Let me try and understand all the different spreadsheets:
The
"Obsolete Proofs" has all of the Christie proofs.
The
"Unique4" has:
1. All of the unique proofs listed in Christie as "SENC in Haxby" (light yellow)
2. All of the unique proofs listed in Christie as "Proof in Haxby" (dark yellow)
3. All of the unique proofs listed in Christie as "UNL in Haxby" (no shading in mine and red in yours-sorry about that)
We are really mainly interested in number 1 and quit tracking the UNL ones. I still tracked the Proofs in Haxby.
The
"Unique in Sale" has all of the proofs listed in Christie as unique (only 1 entry per cell). This is independent of whether Christie lists them as SENC, Proofs, UNL.
The
"Unique in Sale Sans SENC" is equivalent to "Unique in Sale" but you removed the "Unique4" proofs.
In detail you:
1) Removed all rows that had ONLY unlisted notes (because there is no way to process those)
2a) Delete all rows in which all notes were declared SENC (because I really HAVE processed those rows)
2b) Delete the specific notes declared SENC when noted in the Notes column (because I really have processed those notes)
3) I removed all rows that had no numbers in them (because there's nothing to process)
Number 2a and 2b is equivalent to removing ‘Unique4”.
Thus "Unique in Sale Sans SENC" has all of the unique proofs in Christie that Christie did NOT list as SENC.
Again neglecting the UNL and Proofs in Haxby, I would think you would want one spreadsheet that has all of the potential
“Unique Impressions” whether or not Christie lists them as being SENC or not. I did this by having yellow shading for the ones that Christie lists as SENC (in the notes column) and pink for the SENC notes not listed as SENC in Christie. To obtain this spreadsheet from mine, one would have to remove all of the dark yellow, light blue, and uncolored entries.
Take another look at the bottom of my spreadsheet where I define and sum all of the different possibilities.
So instead of having a "rainbow spreadsheet", we have a rainbow of spreadsheets?
What am I missing???