[Novalug] Way OT: documenting Excel Spreadsheet
cliff at palmercs.com
Tue Nov 6 11:35:06 EST 2007
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.
> 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.
>> Novalug mailing list
>> Novalug at calypso.tux.org
More information about the Novalug