This sheet had over 20 tabs and each tab had way too many columns. Just viewing this document is a challenge and required side-scrolling. Some of the information was redundant, some of it was false, and all of it required a deep knowledge of the history and layout of the document.
I began by reviewing the relevant information and creating a concept sketch. I stacked the columns horizontally. At this point it was still bad, but was starting to look more feasible.
Instead of endless tabs, we now had an interactive visual diagram of the server rack and its components.
To add a new device, you simply click an empty slot and select a device from the database.
To manage cables, we were able to stack the corresponding rows. We also added visual indicators for colors.