[Novalug] Way OT: documenting Excel Spreadsheet
cliff at palmercs.com
Tue Nov 6 11:38:41 EST 2007
Joel, the immediate task is documenting the behavior of this current excel
spreadsheet. Once that is done and we have an idea of scope, we'll take
on how to replace it.
> How much of any of the following do you have for this particular
> -> time
> -> money
> -> Java knowledge
> And are you looking for the macros documented as well, or just
> - Joel
> On Tue, 2007-11-06 at 06:28 -0500, 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.
>> Novalug mailing list
>> Novalug at calypso.tux.org
More information about the Novalug