Use cases:

Dev environment with 100's of tables, stored procedures, views functions etc... some of which need to be promoted to the production environment.

A combination of excel and powershell means you can maintain a list of items and quickly pull the creation scripts out of the development environment.

The spreadsheet and associated macros are probably worth an article in their own right