Feature | Benefit |
familiar spreadsheet interface | - Quick to learn:
- less time out from work
- less intimidating
- better retention for infrequent users
- Useful sooner
|
Spreadsheet Builder uses structure of results |
- rapid ad hoc spreadsheets
- fast formating
- enter & edit formula in single location
- no range errors
- fast
|
one-button refresh |
- fast results (no manual adjustments for changes to data)
- avoid most common error (due to range sizes changing)
|
no downtime |
- people don't have to wait for someone else to develop spreadsheets
|
all Excel functions and data formats available |
- use favourite and familiar functions
|
launch macros, VBA, apps, web pages |
|
multi-level breaks & summary calculations |
- cluster data for easier understanding
- eliminate tedious work
- exterminate common cause of errors (range selection mistakes)
|
hide duplicate values |
- spreadsheet much easier to read and scan
- eliminates time-consuming task
|
moving calculations |
- moving average, percent change, etc.
- removes nonsense values (e.g. percent change for first row of data)
|
date- & timestamp |
- use in calculations
- avoid unreliable file timestamping
- available in printed versions
|
include prompt values |
- retain parameters used for query
|
Feature | Benefit |
familiar spreadsheet interface |
- shorter training sessions
- fewer refresher courses required
- fewer and shorter support calls
- reduce report requests
|
powerful interface uses results structure |
- develop reports in less of your time & return faster to user
- spend time on value-added tasks instead of mundane chores
- far lower maintenance costs than alternatives
|
attach text or HTML documentation |
- use intranet documentation to reduce support calls
- documentation isnt separate from spreadsheet definition (wont get lost)
|
trigger macro sheets or applications |
- completely extensible
- simplify existing VBA applications and Excel macros
- lets Spreadsheet Builder perform common spreadsheet work so administrators can concentrate on business-specific logic
|