# 1.4 Block calculation
[GstarCAD 2012](../../Index.md) → [Innovative Features](../%28Innovative%20Features%29.md) → [AutoXlsTable](%28AutoXlsTable%29.md)
<a id="Layer1"></a>

## <a id="_Toc59075695"></a><a id="_Toc59257647"></a><a id="_Toc59257782"></a><a id="_Toc59259116"></a><a id="_Toc59259163"></a>1.4 Calculate block quantity
Calculate block
quantity in different layers or current drawing, even based on its
attribute, with the capability of real-time update.
1\)

On the **AutoXlsTable** menu,
click **Insert Function**.
Or click **Insert Function** button  on
the **AutoXlsTable** toolbar.
2\)
Select **Block Calculate** radio button.
3\)
Select block from the **Block** drop-down list.
4\)
Select layer from the **Layer** drop-down list.
**\*All\*** represents all layers of current drawing.
5\)
Close the **Insert Function** dialog box.
**1.4.1 Calculate
block quantity based on its attribute** 1\)
Select **Attribute** check box.
2\)
Select tag from the **Tag** drop-down list.
3\)
Select value from the **Value** drop-down list.
**
Note:**
l
After you insert function in cell, the red triangle at the
top of cell is to indicate
there is one function inserted into this cell. When you move mouse around
the top the cell, Formula bar will dynamically show function expression. For
instance, when counting the block KK in layer 0, the left side figure is to
show
the cell after inserting function. The right side of figure is showing function
expression when moving mouse at the top the cell.

**1.4.2 Delete Function**
1\)
On the **AutoXlsTable** menu,
click **Delete Function**.
Or click **Delete Function** button **** on
the **AutoXlsTable** toolbar.
## Other versions with matching text
[GstarCAD 2011](../../../2011/Innovative%20Features/AutoXlsTable/1.4%20Block%20calculation.md)