Welcome to this demonstration on otools – Sheet Duplicator

Contents

Introduction

Try our smart and intuitive sheet duplicator to create 100 sheets or more in a matter of seconds. Import sheet names and sheet numbers using Excel and get sorting options of sheets when creating new sheets.

How to use

Select a sheet template you wish to utilize as a master for creating one or more sheets.

Needed sheets can be created using 2 different functions:

  1.     Duplicate a selected sheet by typing the desired number of copies
  2.     Import Excel and create new sheets. Excel functionality requires 2 columns where sheet name and sheet number can be found. If the Excel workbook contains more than 2 columns, then simply select the sheet name and sheet number in the import process.

When the desired amount of sheets are listed, a simple and intuitive drop-down menu can be utilized to place desired views, schedules, legends and rendering. Pre-used or newly placed views do not appear in the drop-down menu.

The selection process of views, schedules, legends or rendering is made easy by a powerful filter where any information can be typed to be used as a filter. E.g. Floorplan, 1.st. floor, Ceiling.

Click on the delete button to delete any listed sheet.

Duplicate sheet using Excel’s import

  1. Click on “Sheet duplicator” (found on Add-Ins tab under ribbon Optimizer Tool)
  2. Select a sheet template by unfolding “Sheets (all)”
  3. Click on “Browse” to browse after your Excel spreadsheet containing information about sheet name and sheet number
  4. Click on “Import Excel” to import the spreadsheet
  5. Select the column’s letters, where sheet name and sheet number are found and finish by clicking on “Import”
  6. Place views, schedules, legends and renderings if needed. Remember to utilize the filter option as it sorts the view in accordance with the criteria you’ll set.
  7. Click on “X” if you wish to delete any sheet
  8. Click on “Go” to finish

Duplicate sheet using Copy

  1. Click on “Sheet duplicator” (found on Add-Ins tab under ribbon Optimizer Tool)
  2. Select a sheet template by unfolding “Sheets (all)”
  3. Type any number within the field of “Copy”
  4. Give all the new sheets a unique number and a descriptive name
  5. Place views, schedules, legends and renderings if needed. Remember to utilize the filter option as it sorts the view in accordance with the criteria you’ll set
  6. Click on “X” if you wish to delete any sheet
  7. Click on “Go” to finish