Exelica spreadsheet reporting

Spreadsheet Reporting Scenarios

Scenario 1 Version Control

We admit to being unwaivering advocates of MS Excel. After all, anything that helps people work more effectively should be encouraged. However, uncontrolled MS Excel use can lead to some well known problems for organizations.

Spreadmart hell describes the loss of control of data due to decentralized spreadsheet use. If everyone uses different methods to extract, transform, and display data, then there will be no single consistent view of information in the organization. Have you ever been in a meeting where several people are working from different versions of a report, each believing that theirs is the most current? How can you avoid spreadmarts while still encouraging MS Excel use?

Exelica provides a controlled access point to enterprise data. Business users no longer need to continually export new report versions to MS Excel, modify the reports and re-distribute them. Exelica ensures everyone who needs them will have access to updated report copies that come perfectly formatted in MS Excel. Exelica helps organizations maintain version control and eliminate spreadmarts.


Scenario 2 Communicating Report Requests

Reports are typically initiated by people in non-technical management roles. They approach the IT department with an idea of the content and the layout they want in their report. They might describe it verbally, with written notes, and perhaps with a sketch. How easy is it for the details of a proposed report to be miscommunicated? It happens all the time.

Exelica uses a spreadsheet environment with its report design tools. This makes it as easy as possible for anyone to prototype a report they need using MS Excel. They can communicate the layout and the content in detail without the risk of misunderstanding. A prototype created in MS Excel allows IT to import it directly to the report designer and get a head start on programming the report.


Scenario 3 Managing Wild Spreadsheets

Well intentioned MS Excel users often create complex spreadsheet models for themselves and others in the organization. If the model is useful, they may grow to rely on it. Once the creator of the model is no longer available to maintain it, some unfortunate soul in IT gets tasked with the challenge of untangling the undocumented macros and sorting through the unstructured formulas. This is not a particularly good use of IT resources.

Complex spreadsheet models can be created systematically using Exelica. The report designer not only provides a guiding hand through the model's creation but it also leaves a 'blueprint' to aid any future attempts to modify it.