[Novalug] Way OT: documenting Excel Spreadsheet

[Palmer]

Megan, the replacement product is something we haven't started thinking
about.  What's needed now is a tool to document the current excel
spreadsheet that will help put a fence around the scope and document teh
business rules, formulas, etc.
Thanks
Cliff

> Cliff Palmer wrote:
>> Our client has handed us "the mother of all spreadsheets" and asked us
>> to turn it into a web-based application with the data stored in, "GASP",
>> a database.  The spreadsheet is huge and no longer meets their file-size
>> limits for email attachments, so it's obviously time to upgrade.
>>
>> The spreadsheet has over a hundred "worksheets" embedded in it, has been
>> worked on by a series of passable-to-near-genius excel users over the
>> last several years, and lots and lots of fine macros (no VB code, excel
>> macros is what we're told).
>>
>> I have seen tools that document the contents of Lotus spreadsheets,
>> printing a report showing what is in each cell in each worksheet, and
>> creating a cross-reference of dependencies and forward references.  I
>> need something like that for Excel.  Does any one know of such a tool ?
>>
>> I know about the command in excel to show the function, macro, etc on
>> the screen - that really won't help me.
> Can the project be re-written in java?
>
> Java can do web interface, multi-threading, database structures (it's
> database structures are used for U of MD Into to DB class), and many
> other things.
>
> megan
>>
>> Thanks
>> Cliff
>>
>> _______________________________________________
>> Novalug mailing list
>> Novalug at calypso.tux.org
>> http://calypso.tux.org/cgi-bin/mailman/listinfo/novalug
>