DELIVERY CHECKLIST — run through this before you send any cleaned file THE NUMBERS [ ] Rows in, minus rows removed, equals rows out [ ] I can explain every removed row (empty, exact duplicate, repeated header, duplicate email) THE FILE [ ] It opens in Excel or Google Sheets with no shifted columns and no garbled characters [ ] Every column the client sent is still there, with the same name (unless they asked for a rename) [ ] Any column I added is named clearly and mentioned in my delivery message THE CHANGES [ ] I compared 10 random rows with the original, cell by cell [ ] I checked 5 of the rows removed as duplicates and they really are duplicates [ ] Dates that could be read two ways (03/04 = March 4 or April 3?) were confirmed with the client [ ] Phones, dates and emails I could not recognize were left unchanged and listed, not guessed THE MESSAGE [ ] Summary: rows in, rows out, what was removed, what was standardized [ ] A list of anything that still needs the client's decision, with row numbers [ ] What is not included (for example: I checked email format, not whether the mailbox exists) [ ] How long I keep the file and how to ask me to delete it BEFORE I HIT SEND [ ] Right client, right email address, right attachment [ ] Two attachments: the cleaned file and the change report [ ] My working copies are stored only where I said they would be