CADSite Reports
This module is designed to create from simple to sophisticated hierarchical spreadsheet reports by linking drawing information to spreadsheet cells. You can use existing Excel files 97-2010 files or create new spreadsheets in the CADSite Report Template Editor.
Existing formulas and references are automatically updated and additional rows/columns are inserted to accommodate data if needed. If you modify an entity property (such as line length) the corresponding linked cell value will be dynamically updated. Likewise, if you modify a cell value the corresponding linked entity property will be dynamically updated.
CADSite Reports can also detect spatial relationships between entities to extract data. You can, for example, extract and link information from attributes of blocks located inside closed polylines in a certain layer.
CADSite Reports can import and export Excel© 97-2010 XLSX/XLSM/XLS/XLT file format. Can also import and export text files (TXT) and comma delimited files (CSV), no need to have Excel© installed. Information selected in the spreadsheet can also be inserted in AutoCAD as linked tables.
- View CADSite Reports videos.
- View CADSite Reports screenshots.
- Download CADSiteTools.
- Buy CADSite Reports.
This module is composed of the following tools:
- Report Template Editor, where you can create or edit a report template to extract and link drawing information to spreadsheet cells.
- Run Report, to select an existing report template file to extract drawing information and create a report.
- Report Template Library, where you can select a predefined report template to open in the Report Template Editor.
- Open Linked Report Templates, to open all existing report template files linked to the current drawing.
- Insert table, to open and run an existing table template file and insert the resulting report as a linked table in the drawing.
- Edit Linked Table, to select an existing linked table object in drawing and open the Report Viewer where changes can be made to the table's content.
- Open Table Template Editor, to create or edit a table template than can be used to extract entity information from a drawing to create table entities in AutoCAD.
- Table Template Library, where you can select a predefined table template to open in the Table Template Editor.
- Open Linked Table Templates, to open all existing table template files linked to the current drawing.
Features
- Bidirectional linking between entities and spreadsheet cells. If you modify an entity property (such as line length) the corresponding linked cell value will be dynamically updated. Likewise, if you modify a cell value the corresponding linked entity property will be dynamically updated.
- Create from simple to sophisticated hierarchical reports with filtered and sorted groups and subgroups of linked cells. Please view the Grouped Entities Report and the Query Report demo video to see this features in action
- Can detect spatial relationships between entities. You can, for example, extract and link information from attributes of blocks located inside closed polylines in a certain layer. Examples of entity spatial relationships are: when an entity is inside of another (e,g.: a block enclosed by a polyline), an entity related to another (by distance, angle, position, etc.). Please see Entity Relationships Report demo video for more details.<
- Works inside AutoCAD full 2008-2012 32/64 bits and any AutoCAD based product (i.e. Civil 3D, Map, Architecture, Mechanical, Electrical, MEP, P&ID, Plant 3D and Structural Detailing)
- Can import and export to/from Excel© 97-2010 XLSX/XLSM/XLS/XLT file format. Can also import and export to/from text files (TXT) and comma delimited files (CSV). No need to have Excel© installed
- Comes with a Report Viewer where you can zoom in/out and inspect your report prior to printing or saving/exporting. Linked cells and drawing entities can be dynamically updated when a cell value changes or a linked drawing entity is updated.
- Send selected spreadsheet information as linked tables to AutoCAD. If you modify the spreadsheet information or format the corresponding table inserted in AutoCAD will be updated.
- Report templates can be reused in any drawing that has the same characteristics. For example, if you design a report template to extract attribute data from blocks in layer HOUSE you can use this template to extract information from any drawing that has blocks with attributes in a layer named HOUSE.
- Includes a report template library which you can use as a starting point to create your own report templates. Please see examples of included report templates in the Metes & Bounds Report and Construction Estimate Report demo videos
- Excel© compatible charting and formulas. Read/Write Excel© compatible charts. Includes 332 of Excel© financial, date, time, text, lookup, math, trigonometry, statistical, database and Analysis Toolpak functions.
- Dialog box settings and options are saved each time a command is executed.
What can I do with CADSite Reports?
Some, but not all, of the tasks that you can do with CADSite Reports include the following:
- Create estimates, bill of materials (BOM's), schedules, spreadsheets from linked drawing information.
- Import your existing Excel to the Report Editor and fill cells with values from linked drawing entity properties.
- Insert a Metes & Bounds table in AutoCAD selecting an existing polyline.
- Select a cell range from the Report Template Editor spreadsheet and insert it as as linked table in AutoCAD.
- Edit the content and format of a linked table in the Report Viewer and update the linked table in AutoCAD.
- Use a predefined report template from the Report Template Library as a starting point to create new report templates.
- Include screenshots from linked drawing entities in a report.
- Extract block attribute values and link them to spreadsheet cells, then export this information to a comma delimited text file for database processing.