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 analysis
Interactive flexible analysis
Interactive flexible analysis
Data visualization& printing& output
Report re-handling
Further data manipulation over report
Desktop computing
No technical cooperationTechnological Advantages
Intrinsic hierarchical structure
Dismantle&Recover a levelwithout 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