Project revision and issue history worksheets

The Title Block Manager creates worksheets with the information from the data records and record formats maintained by the title blocks marked for inclusion in the Title Block Manager operation.

Revision and issue data can also be extracted from title block borders using the Create Report command; see Creating reports.

When the issue history and revision history reports are run, the name of the worksheet resource in the drawing file is automatically incremented with a suffix: “-1” if the report is all on one page, and a series of numbers (-1, -2, -3 and so on) for each page if the Create Pages/Multiple Worksheets option is selected. The sheet revision log has the suffix of the report run date.

The default worksheets have the following names and are available in the default content (Vectorworks Libraries\Defaults\Reports_Schedules\Title Block Reports.vwx).

The worksheet appearance (such as font, color, and so on), field label text, and design company information including a logo can be customized (see Concept: Worksheet overview) and saved into the user folder to be used for future reports. However, rows should not be added or deleted in the top section of the worksheet that displays the issue dates and approvals, since the worksheet formulas depend on these rows.

From the Worksheets section of the Title Block Manager, click on the kind of worksheet to create and set the parameters.

Parameter	Description
Create/Update Project Issue/Revision History or Sheet Revision Log	Select to create/update a project issue history worksheet, a project revision history worksheet, or a sheet revision log worksheet. A worksheet is created and saved as a resource in the file, accessible from the Resource Manager. The sheet revision log is a comprehensive log of all revision records on all sheets in the project, sorted by sheet ID and by revision order.
Worksheet Name	Enter a name
Limit the Number of the Reported Issues (Project Issue/Revision History worksheets only)	Select to display only a certain number of the most recent issues/revision
Show _ most recent issues/revisions (Project Issue/Revision History worksheets only)	Enter the number of issues/revisions to list on the report
Create Pages/Multiple Worksheets	Inserts the data into the worksheet and creates additional pages as needed to accommodate all the rows of title block border data; this is useful if a project has too many rows to fit neatly on a printed page. If deselected, the worksheet uses a database row and lists all the sheets on a single page. The worksheet will contain information from title blocks in external files only when this option is selected.
Start at Row	If creating a multiple page worksheet, specifies the first row of the section in the worksheet to divide across multiple pages
Row Count	Specifies how many rows after the Start at Row to put on each page of the worksheet
Put the Worksheet Data on a Sheet Layer	Select to include the worksheet as a graphic object on a sheet layer; double-click the object to open the worksheet for editing (see Editing worksheets)
Sheet Number	Select the sheet number
Create/Update Sheet Revision Log	Creates a comprehensive log of all revision records on all sheets in the project, sorted by sheet ID and by revision order. A worksheet is created and saved as a resource in the file, accessible from the Resource Manager. Running this log after the initial creation updates the existing log.

Project revisions and issues in custom worksheets/reports

● ='Title Block Revision Data-<Revision Index>'.'<Field Name>', where <Revision Index> is the index of the revision starting from 1 for the latest created revision and <Field Name> is one of the following: Number, Date, Note, Approval, Zone, Recipients, Publish Date.

● ='Title Block Issue Data-<Issue Index>'.'<Field Name>', where <Issue Index> is the index of the issue starting from 1 for the latest created issue and <Field Name> is one of the following: Number, Date, Note, Approval, Zone, Recipients, Publish Date.