I love how quickly you can generate a large GraphViz diagram! In a past job we had the "network drive of shame" (actually all 4 of my internships had that). So

I love how quickly you can generate a large GraphViz diagram! In a past job we had the "network drive of shame" (actually all 4 of my internships had that). So many Excel files which had dependencies which weren't documented at all. I once made a script which would go through each subdirectory, open every Excel file, and document all dependencies, and output to a GraphViz diagram. This enabled me to move a file and know which files would break, absolutely vital for making changes in that environment. It wasn't beautiful - VBA checking properties of tables, pivot tables, examining embedded VBA code searching for the network share URI - but it did work. For safety, I copied 200 GB from the network drive locally. 6 months later the guy in IT was curious why imaging my replacement machine took so long. -- Last week I documented how money moves around my various bank accounts. I needed to make sure all the bills get paid even though I'm switching banks. A quick GraphViz diagram is proving to be really handy.