Project Variables and Project Reports
 You can add custom fields to the Project tab in the Properties window. These added fields are called project variables and are added in the Job Information Section.


To add a project variable you select Project Variable Editor under Tools menu.



The editor lists all the available variables in a project along with their properties. The check box next to a variable sets whether a variable is visible under the Job Information or not, uncheck the box if you don't want a variable visible. To edit a variable you either click on the Edit button or double click on it.



 
On the Edit Variable window you have several items you can edit.

Name:
The name of a variable can only be edited for variables a user has added. The name of the variable is displayed under Job Information in the Project Properties and allows you to set the value of the variable. The value of the variable can also be displayed on the tube map drawing. To do this you add a new text object to the drawing, enter the name of the variable enclosed in square brackets [ ] and then check to box 'Link to variable'

Cell Reference:
The project variables can also be displayed on the Project Report. You select what cell you want the value for a variable by entering a cell reference in the Cell Reference box. Every time a project variable value is changed the referenced cell on the Project Report will automatically be updated.

Optional
Here you can add information that will work as a counter for tubes that meet a certain criteria.

Tube Variable Name:
You add the name of the tube variable that you want to use for counting and then you add the value that you want to check against in the box below. For example, to count the number of tubes that has a wall thickness of <0.0925 you add NominalWallThk as a name and then <0.0925 as the evaluation formula. You can use standard TubePro tube variables as well as the ones you have added your self as counters. There are a number of standard tube variables you can use, contact ISS for a complete list if you are interested.
 
You can also use this as a count that checks how many tubes meet a certain criteria defined by more than one value. To do this you enter the name EVAL in the Tube variable Name box and then enter the formula used for the evaluation in the box below.

Evaluation Formula:
Here you enter the formula that you want to be used to check a tube against. This can either be a single value as <0.0925 or in case of a text value "TS1" (note the enclosing ""). If you are using multiple variables or values to evaluate against you enter those in standard VB script syntax. You can combine several different variables in the formula, ex. PercentLoss > 10 AND PercentLoss<20 AND Section = "E1"

Please contact ISS if you need any help with creating a counter that fits your needs, we can provide a solution very quickly.

 Project Reports
 The project reports that are used in TubePro are based on standard Excel files. Because of this you can use all the functionality of a regular Excel file in the TubePro project reports, including formulas etc. One very important item to note is that when you save a project report template from TubePro, all the Project variables are saved with it. This means that if you read in a project report template then all your current project variables will be replaced with the ones that are stored in the template. This functionality was built in to the program so that it is easy to setup different templates for different inspection types and clients needs.

Excel files can be imported directly to TubePro. Because there are a lot of reports already made up in Excel format it is easy to import them and use them as a base for a TubePro report template. The project report templates in TubePro can be edited directly by typing into cells. Formulas are added by pressing the = key and then entering the formula. More advanced editing of a report template can be done in TubePro by doing a right click on the report and then selecting Workbook Explorer from the menu. However, to creating a template from scratch is almost easiest done by setting up the template and in Excel and then importing the Excel file into TubePro. After that you setup all the project variables and formulas. Don't forget to save the template from the File menu in TubePro when you are done.

Related Links:

Version 4.0 Features:
Copyright © 2010 ISS/HTC, Inc.