### esCalc

```esCalc Introduction
A brand-new desktop BI tool
www.raqsoft.com
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
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
weeks
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
Homocell
Model
Complete set-lization
Free step by step computation
In esCalc, cells with the same business position (homocell) are
5250
8450
2050
5633
6450
4300
6150
3650
4700
2600
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
below:
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.
\$D\$3
Continue to copy the formula to E327
D327/\$D\$3，this is wrong
\$D\$326
D327
It should be D327/\$D\$326
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
Check the esCalc formula:
The same month：
E3=
E35=
D3/ D2
D35/D2
Will not change what
shouldn’t be changed
Different month ：
E3=
D3/ D2
E326=D326/D325
Will change what should
be changed intelligently
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
For example, what’s the monthly sales growth of each
salesman?
Group by the salesperson and month then summary.
D3
D35
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
homocell model, can just copy the formula by
increment mechanically, which is not in line with the
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
meaningless.
The computation shall be limited to the same
salesman.
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.
Free Step by step Computation
Step by step computation breaks the complex
computation objects into simple steps. However,
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
data.
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”
manually.
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?
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
Whatever the next computation is, filter, add columns, sort,
summary and group, regroup, esCalc is more convenient
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 !
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:
=IF(AND(COUNTIF(\$C\$15:\$C\$19,C4),COUNTIF(\$C\$26:\$C\$30,C4),COUNTIF(\$C\$37:\$C\$41,C4),COUNTIF(
\$C\$48:\$C\$52,C4),COUNTIF(\$C\$59:\$C\$63,C4),COUNTIF(\$C\$70:\$C\$74,C4),COUNTIF(\$C\$81:\$C\$85,C4),
COUNTIF(\$C\$92:\$C\$96,C4),COUNTIF(\$C\$103:\$C\$107,C4),COUNTIF(\$C\$114:\$C\$118,C4),COUNTIF(\$C\$
125:\$C\$129,C4)),C4,"")
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
finally.
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?
are isolated from each other, so we have to
match the whole sheet with complex
formulas
Here is one of the complex formulas.
),2)),0)
),3)),0)
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
table.
Similarly, join Absence into Standard table.
finished!
With the unique homocell model, esCalc can
achieve join and union, including multi-level
operation, without any complex formula.
Formula intelligently copied
Associated
computations of tables
Homocell
Model
Free step by step
computation
Complete set-lization computation
esCalc can easily solve complex computation objects and leads to the