category:Course

esCalc Operations: Join and Union

When you work with the spreadsheet data, often you need to combine data from multiple sheets. esCalc provides several operations, including join and union, to do this. 1. Join operation   With esCalc, you can perform the join operation to import data from one esCalc sheet into the other according to the primary ke...

2015-10-27 992 0 0

esCalc Operations: Distinct and Group Operations

During data analysis and computing with spreadsheets, you often need to group data according to the computing target. For example, group order records by clients or the manufacturing data by months. In an esCalc spreadsheet, you can use the group operation to divide bands into different groups according to values of ho...

2015-10-23 1204 0 0

esCalc Operations: Sorting and Alignment

With a spreadsheet, often we need to re-sort data we work with to make it more organized according to the computing target. An esCalc sort operation can sort data efficiently. At times the desired order is not a simple ascending or descending order. In those cases the align operation can be used to sort data in a speci...

2015-10-20 1077 0 0

esCalc Operations: Locating and Filtering

Locating desired data and filtering data to delete or hide the unwanted data are common data manipulation operations on a worksheet. esCalc offers locate operation to find the homo-cells satisfying your criteria in a sheet and filter operation to filter away the homo-bands that don’t satisfy them. Here we’ll focus our ...

2015-10-12 928 0 0

esCac Operations: Row Expansion

Data in an esCalc worksheet is stored in hierarchical bands, allowing it to be analyzed through various operations such as grouping, filtering and sorting. This article deals with row expansion. The expand operation allows you to make copies of a record based on a sequence-type cell value. It is used to complete data e...

2015-10-10 963 0 0

esCalc Spreadsheet Editing: Records

esCalc Spreadsheet Editing: Bands expounded the editing on the structure of bands in an esCalc table. Once a band’s structure is decided, you can add, delete or move records and fill them with data. 1. Bands and records In esCalc, a record is defined as a band that can have homo-bands of the same level and with the sam...

2015-09-06 993 0 0

esCalc Structure: The Smart Copying of Formulas

If you enter a formula into a cell in an esCalc spreadsheet, it will automatically appear in each of the cell’s homo-cells and intelligently adapt itself to the new settlement. If you set one of the cell’s properties through a formula, all its homo-cells will receive the property setting simultaneously. Here we’ll disc...

2015-08-17 1172 0 0

esCalc Structure: Homologous Relationship

Some data in a spreadsheet contains the same type of topics. Through the structural and hierarchical way, esCalc creates homologous rows and cells – which are called homo-rows and homo-cells – containing data of the same information type. Here’s the explanation of what this homologous relationship is and the advantage ...

2015-08-13 1215 0 0

esCalc Structure: Functions

esCalc stores data in hierarchical, structured spreadsheet, which enables the use of structure-related functions in performing data analysis and aggregation. Here let’s talk about these functions and their basic usages. 1. The sequence of cell values Through esCalc Basics: Sequences, you know that [a:b] can be used in ...

2015-08-11 1248 0 0

esCalc Structure: The Hierarchy of Rows

Different from other spreadsheet applications, esCalc spreadsheet isn’t designed for holding a normal two-dimensional table, but for holding data in a hierarchical way. Here you’ll see in what type of structure the data is stored in esCalc and the hierarchical relationships between rows. 1 .Row number, slave row number...

2015-08-07 1168 0 0

esCalc Spreadsheet Editing: Bands

A band is the elementary structure unit of an esCalc spreadsheet. So editing a band is the basic operation on a sheet. Different from editing records during which you add or delete data, editing a band means reconstructing it. In examples of this article, Ctrl+Enter will be used to insert records. You can learn more fr...

2015-07-15 1255 0 0

esCalc Spreadsheet Editing: Cells

In esCalc, apart from editing bands to change the cellset’s structure and editing records to add or delete data, you can perform cell editing, which includes structural operations such as adding and deleting cells, as well as data copying and pasting. This article will deal with how to edit cells. 1. Editing cells and ...

2015-07-10 1169 0 0

esCalc Basics: Registration Code and Encryption

esCalc provides encryption choice for data entered in the cellset. Under encryption, cellset description and cell tips help users with certain execution privileges understand the meaning of the data in the cellset. In this article you’ll learn about the esCalc registration and how to encrypt a cellset. 1. Registration ...

2015-07-03 1230 0 0

esCalc Basics: Sequences

Sequence is the most basic data type of set data in esCalc. Let’s get to know the concept of the sequence and related functions. Then you’ll have a deeper understanding about the computing principle of esCalc. 1. Getting to know sequences A sequence is a data set sorted in a certain order. The data that constitutes a s...

2015-06-30 1254 0 0

esCalc Basics: Formulas

esCalc Basics: Cells and Data Types discussed the basic data types in esCalc and mentioned the use of formulas in esCalc spreadsheet. Here we’ll explain how to use formulas in esCalc in a systematic way. 1. Calculation and edit of esCalc formulas In esCalc, if the string in a cell starts with “=”, it will b...

2015-06-26 1183 0 0