Excel Headaches
Formulas become invalid after groups are dismantled, due to rigid data model;It’s difficult to add a computed column, and perform sorting and filtering on a group;It’s a nightmare to copy and edit formulas manually;Cross-group formula copying usually fails and needs manually editing;Endless lookup functions for set operations;IT support is needed to get sheet joined.
esCalc is a desktop interactive analysis tool intended for data analysts & frontline workers. It’s smarter than Excel, and particularly suitable to handle cross-level computations, complex logic computations, and flexible, stepwise computations. Its cooperation with Excel can dramatically relieve the workload.
What you can do with esCalc?
Data analysisInteractive flexible analysis | Interactive flexible analysisData visualization& printing& output | Report re-handlingFurther data manipulation over report | Desktop computingNo technical cooperation |
Technological Advantages
Intrinsic hierarchical structure
Dismantle&Recover a level
without affecting detail data
Record-style data model
Perform sort, filter, aggregation &
add a column over grouped data
Homo-cell model
Smart (cross-row) formula copying &
migration
Relational algebraic model
Alignment joins between sheets
Explicit sets
Intuitive set operations