I get the appeal of centralized documentation, but I would argue that requiring an external spreadsheet for the information adds complexity, too, just in a different way.You're making it too complicated. The image below is a portion of a wiring plan I am working on. It was easy to set up in Excel.
I come from an engineering tradition that encourages documentation as close to where it matters as possible. External documentation is always suspect and rarely where you need it when you need it. I look at it like this: Is it better to keep a list of bottles I have on my shelf and what each contains? Or, is it better to put the "poison" sticker directly on the bottle? I favor labeling the bottle.
I consider that spreadsheet a good planning document. But, it requires you to have that document and trust that it is up-to-date. If circuits are physically labeled, the information is where it needs to be and is more reliable.
I just think about what I wish I knew when I was crawling around trying to figure out what's going on with existing wiring. I want to know:
- Where does this wire go?
- What is its capacity?
- What is its actual load?
I have seen the 3x5 card approach, where each bus or panel has one of these cards. That approach seems to work pretty well. You can just look at the card and see what's there without having to try to read all of the tiny heat-shrink labels. And, it is easier to update if the actual load on a wire changes.