If found this comparison surprisingly useful. We were missing more annotation values than I had anticipated!
Here we bring together stuff for the previous two posts. And it is fairly easy to compare OCI vs CI annotations and annotations rules and get a report of what is missing. First run this tool:
Then run this tool:
Bring both sheets into the same excel workbook, turn the data into tables. Create a column D on both sheets to combine annotation and annotation value as per:
Then I found using INDEX, MATCH, and the range worked best, something like this (change XXXX with the final row of the OciAnnosAndValues tab, and YYYY with the final row of the CiAnnosAndValues tab.)
For the OciAnnosAndValues tab:
For the CiAnnosAndValues tab:
Add in a little bit of conditional formatting and job done!