esCalc Introduction
A brand-new desktop BI tool
esCalc is a spreadsheet software
Unlike traditional spreadsheets which emphasized on peripheral functions,
esCalc does not , i.e: photography, social networking and sharing
esCalc leads to revolution in computing capability.
esCalc performs best in the complex computation, which is exactly the
weaknesses of traditional spreadsheets.
For example
Show year-on-year basis and link relative ratio sales amount of
numerous salespersons and products
Join the monthly salary, attendance, performance information table
Find out the products whose price keeping rising for seven consecutive
Find out the months whose sales amount is higher than the average
sales amount of current year since 1999.
Where does the computing capability come from?
Formula intelligently copied
Associated computations of tables
Complete set-lization
Free step by step computation
The traditional spreadsheet cells are isolated from each other, lacking
of business relationship.
In esCalc, cells with the same business position (homocell) are
intrinsically linked.
esCalc can solve complex computational goals easily relying on the
homocell model.
Formula intelligently copy
Formulas in esCalc will automatically be copied to homocells, this
feature can free users from heavy manual operations.
Case: compute the monthly sales amount proportion of each sales
Original data: the sales amount details for each salesman last year
First, group by month
Then group by salesman
Enter the formula in D3 and get the sales value of Baker
Click on group level 2, shrink to Summary band
we can see the formula has been copied to the homocells
such as D35 and D67,etc.
Enter formula in D2, compute the total sales of January
We can see that the formulas are also be automatically
copied to the homocells D325, D616
Last, enter the formula to calculate the ratio: D3/D2
Similarly , the formula has been copied to the homocells.
esCalc finished the calculation without any difficulty.
It is more difficult to do the same operation in traditional
spreadsheets. For example compared with Excel as
The same raw data offered
Excel does not support automatic sort before grouping,
so first sort by month and salesman.
Then group by month
Similarly, group by the salesman
Click on the group level 3, shrink to the summary row.
Then calculate the proportion in E4, enter the formula:
=D4 / $ D $ 3.
Copy the formula in E4, and then paste to E36 to E294
one by one
Note: don’t use drag for bulk copy, otherwise the
formula will be copied to the detail data.
It’s wrong to do it like this.
Obviously, it’s more troublesome while the data
amount gets bigger.
This is nothing compared to the next difficulty.
Continue to copy the formula to E327
D327/$D$3,this is wrong
It should be D327/$D$326
Traditional spreadsheets can just mechanically copy
the formula lacking of intelligent adjustment based on
the business association of the cells.
The homocell model enables formulas not only to
automatically copy, but also to automatically adjust
according to the business relationship.
Check the esCalc formula:
The same month:
D3/ D2
Will not change what
shouldn’t be changed
Different month :
D3/ D2
Will change what should
be changed intelligently
This intelligent adjustment is what the traditional
spreadsheet doesn’t have.
The traditional spreadsheet doesn’t support smart
formula adjustment and can only re-enter the formula
and then manually copy to other cells.
And each set of data must repeat the entire process.
It’s unbearable facing a large amount of data.
There will be even greater difficulties while changing a
computation task.
For example, what’s the monthly sales growth of each
Group by the salesperson and month then summary.
The subtraction of adjacent months is the sales
growth of last month.
For example, Baker’ increment in February should
be D35-D3
How to calculate the increment in March? Let’s try to
copy the formula to E64.
D64-D32?This is obviously wrong
The traditional spreadsheets, due to the lack of
homocell model, can just copy the formula by
increment mechanically, which is not in line with the
business logic.
Manually enter each formula? Absolutely unbearable!
While in esCalc, one can still group by the salesman
and the month first and then summary.
Enter formula D35-D3 in E35
Check the formula of March
D64-D35, this is in line with the business logic!
For continuous data, the earlier formula is perfect.
Replace the salesman by Year.
Check the formula in E381, the increment in
January 2012 should be D381-D348. The formula
is correct.
Change back to the non-continuous data, the
same formula is wrong.
D381-D348 is not in line with the business logic.
The subtraction between different salesmen is
The computation shall be limited to the same
Let’s add a data range for the formula in the E35:
D35 [C2]-D3 [C2].
Here [C2] indicates that the data range is limited
to salesman Baker.
Check E381, the increment of January: = 65040-0
= 65040
Whether the data is continuous or not, esCalc can
intelligently replicate the correct formula.
While traditional spreadsheet can not!
Free Step by step Computation
Step by step computation breaks the complex
computation objects into simple steps. However,
traditional spreadsheets lack of freedom during the
stepwise computation due to timeworn models.
For example : who are monthly top 5 salesman?
We can take 4 steps: group, summary, sort and filter. The
first 2 steps are the same with previous case.
Then, we need to sort by sales value. The traditional
spreadsheets have to sort one month after another.
This is the sorting result of January.
Repeat the operation 12 times to sort each months
Filter out the top 5 of each month.
Use the “top N” filter function?
No way! It cannot distinguish detail data and summary
Method 2 is to delete the data after fifth manually.
Obviously it cannot deal with large amount of data. E.g.
the 10 years data of AXA Insurance company which has
tens of thousands of salesmen.
Advanced users can use the third method.
First select “visible cells” to copy the summary
data to a new sheet.
Then input the formula in D3:
=IF( NOT(ISBLANK(B3)),0,E2+1)
Next, drag to copy this formula into other cells.
So we created the “Serial number within group”
Then set filter mode to filter.
We finally finished the computing after many efforts.
Why cannot sort all the groups directly?
Why cannot filter by serial numbers directly?
Traditional spreadsheets cannot compute data freely
step by step. They often need a lot of skill and manual
manipulation to complete computation object.
esCalc enables free stepwise computation.
First sort in D3 based on the same summary data.
Just one step, all the groups are sorted.
Then filter by serial numbers within group directly.
Just one step to finish filtering.
In esCalc, you can manipulate the current data freely and do
the next computation at will.
Another example, count the orders of salesmen based on
current result just need to enter the formula {D4}.count()
into E3.
It is really annoying to recalculate from the original data in
traditional spreadsheets.
Whatever the next computation is, filter, add columns, sort,
summary and group, regroup, esCalc is more convenient
and free than traditional spreadsheets.
Complete set-lization computation
esCalc directly supports set data types, and can easily solve
the problems related to set.
For example, if you want to find Best Employee of the Year,
that means you need to find whose sales are in the top 5
every month based on the previous case:
First, work out the set of salesmen in each month.
Then calculate the intersection of these sets.
Easily done !
Traditional spreadsheets are more complicated.
Method 1: group the data by salesman, figure out
the appearance numbers of the salesmen, copy
them into a new sheet and filter the sales whose
appearance number is 12.
This method is not easy to understand, but also
makes great damage to data and the reusability is
not strong as well.
Method 2: Simulation set operations
Input this horrible formula into F4:
This formula matches C4 with other sales in other
months, and return C4 if they match.
Drag to copy the formula to the cells fromF5
to F8.
With complex formulas, we get the result
Traditional spreadsheets have high
techniques requirements for users on set
operation and users have to develop abstract
algorithm. This is hard for common users.
esCalc supports sets completely, and it’s
easy to do union, intersection and
subtraction operation and thus solve
complex problems.
Associated computations of tables
Homocell model makes the multiple tables computation
very easy.
Here are three tables recording the basic salary,
absences, and performance of this week separately.
Please compute the actual weekly salary.
Obviously, if we could join the three tables together into
one on the basis of EID columns.
Such as
Then the formula of Rebecca Moore’s weekly
salary is easily worked out as:C2*(1+E2D2/40)+F2
But how to join?
In the traditional spreadsheets, the cells
are isolated from each other, so we have to
match the whole sheet with complex
Here is one of the complex formulas.
It’s hard for common users to master such
complex algorithms.
But it’s easy for esCalc to join tables based
on homocell model. First, please set the
EID of standard as “master cell”.
Set the EID column of absence and
performance as “master cell” as well.
Thus the homocell relationship is established
between the three tables.
Press Ctrl+C
Copy and Join
See, the Performance is joined into Standard
Similarly, join Absence into Standard table.
With the unique homocell model, esCalc can
achieve join and union, including multi-level
operation, without any complex formula.
Formula intelligently copied
computations of tables
Free step by step
Complete set-lization computation
esCalc can easily solve complex computation objects and leads to the
computing capability for the spreadsheets.
More information please visit
Thank you

similar documents