support

Homorow and Homocell

• The data with the same business significance is stored in homorows.

• The appearance properties of homocells in the homorows will change concurrently.

• Through the intelligent formula migration between homocells, calculations of the same business logic will be completed all at once.

Based on the following table of the technical data of pitchers in some baseball teams, calculate the Earned Run Average [ERA] of each pitcher:

esCalc_multi_structure_4

To calculate ERA, firstly, check the innings pitched (IP) and convert the decimal part of each IP by counting every one third of an inning as 1 inning. The formula is IP2=int(IP)+(IP-int(IP))/0.3. Secondly, calculate ERA through the formula ERA=9*ER/IP2. In esCalc, simply enter the formula in any homorow and you’ll get results of all homorows.

esCalc_multi_structure_5

The ERA of each player will be calculated regardless of groups.

In esCalc, homorows that may exist in multiple groups hold data of the same business background. When a cell of a homorow receives an entry of a formula or modification to display properties , all its homocells in the same column across the homorows will take on the handling concurrently. The definition of homorows enables users to manipulate spreadsheet data in batches, greatly improving the efficiency.