CADS RC - Excel Template Creation Manual - Creating custom Excel report templates

Sep 11, 2026

CADS RC Excel Template Creation Manual explains how to build custom Excel schedule and weight report templates for CADS RC v2021 or higher. It covers prerequisites for editing Excel, how CADS RC exports schedule dialog data into designated Excel cells, and where default templates are stored on disk. The manual then guides creation of schedule report templates, including graphical layout, cell naming, report configuration, and defining cell ranges, before extending the workflow to weight and summary weight report templates and template database fields for headers, footers, and bar data.

LanguageEnglish

CategoryPresentations

FormatPDF

Pages33

Reading Time12 min

AccessFree to download

Introduction

Requirements and purpose

Customising the Excel Schedule Template

How CADS RC maps schedule data to Excel cells

Default template storage locations

Create an Excel Schedule Report Template

Create the graphical layout of the template

Naming the cells in the report template

Report Configuration Tab

Defining the Cell Ranges

Create an Excel Weight Report Template

Create an Excel Summary Weight Report Template

Configuring Excel Report Templates in CADS RC

Creating a Report using the Excel Report Templates

Excel Template Database fields

Data fields for header and footer

Data fields for bar data

CADS RC Excel Template Creation Manual CADS RC for AutoCAD, including all software and documentation, contains proprietary information belonging to Computer and Design Services Limited (herein referred to as “The Company”) . They are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or de-compilation of the software, except to the extent required to obtain interoperability with other independently created software or as specified by law is prohibited. If you find any errors in the documentation, please report them to us in writing. The company does not warrant that this document is error free. The information contained in this document is subject to change without notice. Except as may be expressly permitted in your license agreement, no part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of the company. Contents 1 Introduction .................................................................................................................................... 3 2 Customising the Excel Schedule Template ..................................................................................... 3 3 Create an Excel Schedule Report Template .................................................................................... 7 3.1 Create the graphical layout of the template........................................................................... 7 3.2 Naming the cells in the report template................................................................................. 8 3.3 Report Configuration Tab ..................................................................................................... 11 3.4 Defining the Cell Ranges ....................................................................................................... 12 4 Create an Excel Weight Report Template ..................................................................................... 14 5 Create an Excel Summary Weight Report Template..................................................................... 16 6 Configuring Excel Report Templates in CADS RC .......................................................................... 18 7 Creating a Report using the Excel Report Templates ................................................................... 20 8 Excel Template Database fields .................................................................................................... 23 8.1 Data fields for header and footer ......................................................................................... 23 8.2 Data fields for bar data ......................................................................................................... 26 1 Introduction This manual explains how to create your own custom Excel Schedule Template for CADS RC v2021 or higher. You will need to have MS Office v2010 or higher installed in order to edit the Excel Template. 2 Customising the Excel Schedule Template The Excel output routine in CADS RC reads the data from the Schedule Dialog and prints this data in the appropriate Excel cell. For example, the Member assigned in CADS RC to the rebar in the drawing will be printed in the Member data cell in Excel. The default Excel Templates shipped with CADS RC are stored in subfolders under the “C:\ProgramData\CADS\AutoCAD XXXX\CADS RC XXXX.XX\CADS-RC\Templates\Reports\Excel Report Templates” folder. Schedule Report folder BS4466-Dimensioned Sketches BS4466 BS8666-2000-Dimensioned Sketches BS8666 – 2000 BS8666-2005 Dimensioned sketches BS8666-2005 BS8666-2005-Uniclass BS8666-2020 SS Weight Report folder Weight Report by All Scheduled Bars Weight Report by All Scheduled Bars wi

FAQs

What is the purpose of the CADS RC Excel Template Creation Manual?

It explains how to create custom Excel schedule templates and report templates for CADS RC v2021 or higher, including schedule, weight, and summary weight outputs.

Which software versions are required to edit the Excel templates?

The manual requires MS Office v2010 or higher to edit the Excel Template.

Where are the default Excel report templates for CADS RC stored?

They are located in subfolders under the Templates\Reports\Excel Report Templates directory within the CADS RC installation path on the C:\ProgramData folder.

Sep 11, 2026

Uploaded by Maya Linwood