In this video you will see a practical example of using the XTools Pro's “Edit with MS Excel” tool. XTools Pro provides more than 80 vector spatial analysis, shape conversion and table management tools and features for fast and effective work in ArcGIS Desktop. Download XTools Pro Try it free for 14 days Full transcript: XTools Pro is an extensions to ArcGIS for Desktop.

This video demonstrates a practical example of using the XTools Pro “Edit with MS Excel” tool. Working with tabular data often requires utilizing various formulas for calculating and updating data. ArcGIS provides fewer capabilities for that compared to Microsoft Excel. Suppose you need to calculate average content of silver at the sampling points and standard deviation values and output results to separate columns. Here is how it's done with XTools Pro. Vl 10 kv tipovie proekti download.

Meet XTools Pro 17. #1 Productivity Suite for ArcGIS Community. New version introduces such new tools as Scale Manager, Batch Export Metadata, Batch Clean Metadata, Table to Excel Template, Concave Hull, Square Off Polygons, Center Lines as well as new menu, updated UI and Notifications Center. Thousands of users worldwide successfully apply XTools Pro functionality solving different GIS tasks in their everyday work. XTools Pro tools are used across.

In ArcMap add two new columns to your attribute table where average content of silver and standard deviation values will be calculated. Right-click on the required layer in the Table of contents window and select the “Edit with MS Excel” tool from the layer’s context menu. Note that depending on the dataset size exporting to Excel may take some time. Switch to the Microsoft Excel application.

Enter and apply required formulas in Excel to calculate average content of silver and standard deviation values, saving this Excel document isn't needed. Then copy both average content of silver and standard deviation formulas. After that go back to your ArcMap document without closing the Excel application. Start an editing session for the layer. You can use the “Start Editing Selected Layer” feature from the XTools Pro toolbar for that. Right click on the layer and select the “Import edits from MS Excel” tool from the layer’s context menu.

It is worth mentioning again that data processing, namely importing edits back to ArcGIS, may take some time especially for larger tables. After importing all made edits will appear in the attribute table in ArcMap. Using average and standard deviation functions is just one example of applying the “Edit in MS Excel” tool which brings the power of Excel to table editing capabilities in ArcGIS. There are also other Excel features available for tabular data processing with XTools Pro: data validation, using various calculation formulas, filtering data, data formatting and analysis, spell check, setting styles and color schemes, and more XTools is the #1 Productivity Suite for ArcGIS Professionals! Visit our website to learn more or try XTools Pro free for 14 days.