support

Support for Set Calculation All-roundly

Features of esCalc: Support for Set Calculation All-roundly

a. Full support for sets, and capable to handle the sum, subtraction, intersection, union, and other operations on sets directly

b. The sets exist in the form of object, making the summarization more intuitive and easy to read and write
Given the score statistics for the last three games of a certain basketball team, make statistics on players whose scores are among the top 5 and all players who once scored.

esCalc set calculation 4

Firstly, sort the players in each game by score. To do so, select D3 and sort in descending order:

esCalc set calculation 2

The result after sorting is as shown below:

esCalc set calculation 3

Add the slave row after the 1st row to store the calculation result, and fold the data of game to the number of game. In the column D, calculate the player who once scored in any game. In column E, calculate the players of which the scores are among the top 5 in any game. To do so, fill the formula ={A4} in D3, and fill the formula ={A4}(to(5)) in E3:

esCalc set calculation 4

Calculate the result, and fill the formula ={D3}.union() in A2 to calculate all players who once scored. Fill the formula ={E3}.isect() in B2 to calculate the players whose scores rank the top 5 in all games, as shown below:

esCalc set calculation 5

Once calculated, the result in A2 is [Kerron Diaz,Ryan Williams,Jerome Horton,Steffen Ivey,Keith Parker,Duke Flanagan,Tim Sanders,Noah Crawford,Nelson Miller,Riley Iglesias], and the result in B2 is [Kerron Diaz,Ryan Williams,Jerome Horton,Steffen Ivey].

esCalc provides full support for various calculations all-roundly, such as the calculation of subset, intersection set, and union set. It is convenient for users to handle such problems and saves them the trouble of programming or converting the natural train of thoughts.