# 1.4 Block calculation [GstarCAD 2011](../../Index.md) → [Innovative Features](../%28Innovative%20Features%29.md) → [AutoXlsTable](%28AutoXlsTable%29.md) <a id="Layer1"></a> ![](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image006.jpg) ## <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\)         ![](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image002.jpg) On the **AutoXlsTable** menu, click **Insert Function**. Or click **Insert Function** button ![](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image004.jpg)  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. **![*](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image008.jpg)  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. ![](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image009.gif) **1.4.2 Delete Function** 1\)         On the **AutoXlsTable** menu, click **Delete Function**. Or click **Delete Function** button **![](../../assets/AUTOXLSTABLE/1.4%20Block%20calculation_files/image011.jpg)**  on the **AutoXlsTable** toolbar. ## Other versions with matching text [GstarCAD 2012](../../../2012/Innovative%20Features/AutoXlsTable/1.4%20Block%20calculation.md)