CI Day 3, part two
The content inventory we are doing uses more categories than the usual ones (ROT and title). I am realising Excell is not a structured dataformat - it lets you enter bad data and generally mess things up, especially if things are to be imported into a database later. I did set up some dropdowns to structure the categories (so you don't type "redundant" once and "redundent" the next time) but that was it. There is replication of rows and other evil things.
Content Inventory Tip 4: When doing complex categorization, use structured data entry as much as possible. More specific: be careful when ordering columns in Excell. If you order a column alphabetically, the other columns don't order with it. If you assume they do (as me and others I have talked to did), and order a few columns, you will have messed up your spreadsheet beyond recognition and will need to spend a lot of time fixing it. (Yes I did.) In order to order all the columns, select them all and then select data>sort.