Document Excel Workbook in Specification Manager

[Pat Yearick]

I'm tasked to document the formulas and functionality of an Excel workbook so we can enhance it and tie it in with models and data brought in from other systems. The application is going to be completely rewritten and extended but I need to capture cell by cell and sheet by sheet what the current workbook does if you enter this or enter that.

I am thinking that it ends up being a large number of user stories but that seems a little too wordy for this. I wanted to ask first if there was a better, more automatic or standardized way. Of course, I'd like to then use EA to track these requirements and later be used to develop the solution.

The workbook has VBA macros but they are very simple. The cell formulas ... can go on forever in some cases.

Thank-you for any suggestions,

Pat

[Glassboy]

Aren't all the formula ultimately business rules?  So rather than documenting use case you want to actually document all of the business rules in the spreadsheet?

[Pat Yearick]

Thanks for your reply. That makes more sense than what I had in mind.