I wrote a little piece of code that identified 624 rows in BI's spreadsheet which contain values in the keyword field that don't appear in the keyword sheet, then submitted a report to BI. He'll need to update the keywords sheet and the records in the main sheet and return.
Added bit of code to identify rows which have NULL in the chapter field. It's OK to have NULL in that field, but I gave BI the report in case some of those rows should have a value in that field.
Added bit of code to identify rows which have NULL in the document_type field. It's OK to have NULL in that field, but I gave BI the report in case some of those rows should have a value in that field.