The next step is to have an inventory of spreadsheets
and document key characteristics of' each.
is a pioneering Market Leader in providing a complete range of Spreadsheet
Control and Compliance solutions.
Users can now see their spreadsheet
risk in the form of a workbook, website or PDF report and benefit from automated inventory reviews.
based BlackLine Systems that lets employees upload key spreadsheets
to a secure Web site.
Once identified, VAT related spreadsheets
can be categorized according to their complexity and financial significance and assigned a high, medium or low risk rating.
It not only delivers rapid control over existing business critical spreadsheets
, but also facilitates the development of new, more robust, scalable and supportive spreadsheet
The policy-based automation introduced by Compassoft in this release represents a major step forward in the battle to manage spreadsheets
," said Philip Howard, research director at Bloor Research.
The inherent risk with any spreadsheet
based system is that individual users can cause material losses through personal errors.
But the internal controls for the spreadsheets
that collect and consolidate data for planning, budgeting and reporting are weak at best.
quality guru Raymond Panko notes that rates of error creation in spreadsheets
are roughly similar to comparable tasks: typing for data entry and software coding for formula design.
To do that you'll want to create a hyperlink between a spreadsheet
cell and a separate document containing the detailed explanation, and then display the text directly from the spreadsheet
with a mouse click; the document even could contain backup charts and other graphics.
Literal values in formulas and other aspects of poorly designed spreadsheets
pose problems in programming.