Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Documenting spreadsheets

Latest post Wed, May 21 2008 7:06 AM by jtr63. 0 replies.
  • Wed, May 21 2008 7:06 AM

    • jtr63
    • Top 75 Contributor
    • Joined on Wed, Jan 16 2008
    • Posts 4
    • Points 52

    Documenting spreadsheets

     

    Does anyone have a template for documenting Excel spreadsheets ? The sort of information I am wanting to record is :

    1. The specification of the report.
    2. The sponsor of the report
    3. The owner of the report
    4. The generator of the report
    5. How the report is generated
    6. The frequency the report is generated
    7. The recipient of the report
    8. The actions the recipient takes as a result of data contained within the report
    9. The benefits arising from these actions.

    The aim is that carrying out this exercise will cover the "what if I go under a bus ?" issues, but will also promote some reports from an ad-hoc status to ones that can become KPIs for the group.

    TIA

    John.

    • Post Points: 5
Page 1 of 1 (1 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.