SheetGen

Batch create Drawing Sheets, place Views based on a pre-defined template, and easily manage Drawing Sheets revisions. Export and sheets/views lists to/from Excel.

Table of contents

1. Sheet List
   1. Sheet template
   2. New Sheet
      1. Search sheet
   3. Actions between the sheets
      1. Open Sheet
      2. Duplicate Sheet
      3. Delete Sheet
      4. Add parameters columns
   4. Edit sheets Number and Name
      1. Import/Export excel file
      2. Rename
      3. Build Number and Build Name
   5. Save V/S Set
      1. Filter by V/S Sets
   6. Clear editions

Sheet List

The first step is to select the SheetGen from the DiRootsOne menu and choose the Sheet List tab. This page will show all sheets in the project.

# Note:
You must have at least one sheet created, to be used as a template in SheetGen.

Sheet template

The first step before you start managing the sheets in SheetGen, is to create a sheet as a template. Basically, you need to create a sheet and fill it in, organizing the views as you wish. So, that will be used to generate new sheets on SheetGen, which will have the same settings as the template sheet. A sheet template is simply a sheet with some views in place.

_{Note: the version on the image may not reflect the latest version of SheetGen.}

New Sheet

1. Click on the New Sheet button, or right-click on an existing sheet and choose the Create Sheets from sheet template option.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Fill the fields for the new sheet.

• Number of Sheets - put the number of sheets you want to create.
• Populate View from template - Create the new sheet with the same view settings as the template sheet.
• Keep Legends - you can choose to keep the legends as the template sheet.
• Keep Schedules - you can choose to keep the schedules as the template sheet.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Select the existing sheet to be used as a template for the new sheet.

Search sheet

The search box will look for the sheets contained in the project.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Note that the new sheets appear in the list of sheets, but have not yet been created in the project. To complete the creation, click Apply.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Actions between the sheets

Open Sheet

Right-click on the sheet and choose Open sheet option, to see the new sheet you have created.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Duplicate Sheet

You can perform this action for individual sheets by right-clicking and choosing the Duplicate option, or you can perform this action in batch for several sheets simultaneously. To duplicate in batch, select the sheets you want, and in the Batch Actions list, choose Duplicate.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Options for duplicating individual sheets.

• Set a number of copies
• Select the checkbox if you want to Duplicate Views from sheet
• Select the checkbox if you want to Keep Legends from sheet
• Select the checkbox if you want to Keep Schedules from sheet
• Select the checkbox if you want to Copy Revisions from sheet
• Select the checkbox if you want to Copy Title Block Parameter Values from sheet

# Note:
If you prefer, you could select the checkbox Change Template for copies, so the list of sheets will be able to select another one.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Options for duplicating sheets in batch.

• Set a number of copies
• Select the checkbox if you want to Duplicate Views from sheet
• Select the checkbox if you want to Keep Legends from sheet
• Select the checkbox if you want to Keep Schedules from sheet
• Select the checkbox if you want to Copy Revisions from sheet
• Select the checkbox if you want to Copy Title Block Parameter Values from sheet

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Delete Sheet

You can perform this action for individual sheets by right-clicking and choosing the Delete Sheet option, or you can perform this action in batch for several sheets simultaneously. To delete in batch, select the sheets you want, and in the Batch Actions list, choose Delete.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Add parameters columns

By default, the list of sheets will only shows the the number and name of the sheet. Right-click under the column header and add the desired parameters.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Edit sheets Number and Name

To edit the individual sheets, double-click on the cell you want to edit (number or name), and enter the text edit.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Import/Export excel file

If you have several sheets created in the project, this tool makes editing much easier. Export an Excel file, edit it as you want, then import it into SheetGen and update the number and name of the sheets. Note that in the Sheet Name header column has a lock icon, by activating this icon, the column will be locked for any editing. In the Excel file exported you can numbering, naming, changing parameters and also add new rows to create new Sheets.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Export the excel file from sheet list.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Once you have edited the Excel file, import it to SheetGen.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Rename

SheetGen also allows sheets to be renamed in batch. To do this, select the sheets you want and click Rename. Then define a Prefix, a Suffix, enter the name that will be replaced and finally the name that will replace it.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Build Number and Build Name

1. Similar the Rename tool, SheetGen has a Build Number. Select the sheets you want and click Build Number. Then set the Default Field Separator, Custom Field, Custom Separator, Counter and add or remove Parameters.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. For the Build Name tool, it is the same steps. Select the sheets you want and click to Build Name. Then define the Default Field Separator, Custom Field, Custom Separator, and add or remove Parameters.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Save V/S Set

To organize the project sheets, especially when there are many sheets created, SheetGen offers the tool to save sets. To create a new set, select the sheets you want to separate into this set and click on New Set, then assign a name to finish creating the set.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

You can also add sheets to an existing set.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Filter by V/S Sets

Once you have organized the project sheets into sets, you can apply filters to make the work process easier.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

Clear editions

1. Click the Clear all Modifications button, and reset all edition applied to the sheet names and numbers, in the table view by the Rename, Build Name or Build Number commands.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}

1. Click on the Clear Staging button, and clear the staging cached modifications.

# Note:
With this tool, only changes that have not yet been applied will be cleared. Changes that have been applied cannot be cleared.

_{Note: the version on the image may not reflect the latest version of SheetGen/DiRootsOne.}