Understand Equations
Equations are organized inside the Tilos Explorer > Project data Distance Axis Definition > Equations. Equations are used if there are inconsistencies according to the kilometrage e.g. of a railroad line. On railroad lines or pipelines, it often occurs that a segment is missing on the distance axis (1.000 = 1.750; 750 m are missing).
Ways to access
Double click the Tilos Explorer > Project Data > Distance Axis Definition > Equations.
Enable the checkbox 'Enable equations' inside the Tools > Options > Functions tab.
Tools > Options > Distance tab.
Additionally, select from the drop-down menu inside of the tab Distance a 'Default equation'.
Inside the Tilos Explorer > Library > Distance Axis Definition > Equations existing Equations are indicated.
Add an equation
Click the Add Equation icon to delete selected entries Click the Delete Equation icon.
Edit equation properties
Open the dialog Equation Properties and click the 'Equations' icon.
Equivalent edit the items of an equation, see also Equation Item.
Note: This library item is only available if the check box 'Enable equations' inside the dialog Options/ Visibility or via Options/ Distance Is enabled.
Edit which columns are shown in the grid, right-click a column header and select Setup to open the Sheet Settings dialog.
Exchanging Data with other Programs
Use your computer's clipboard to exchange data types from this list with other programs and vice versa. See Export via the Clipboard and Import via the Clipboard for more information.
Import/export using the clipboard
Click either:
Export to Clipboard – Use this to copy all of the data in the list to your computer's clipboard to make it available to paste into other programs, such as Microsoft Excel for MS Project, Asta Powerproject, and Primavera:
First, click Export to Clipboard, check/uncheck boxes for all of the fields you want to include/exclude in the Fields for Clipboard Import/Export dialog, and change the Column Numbers and Column Letters to rearrange the order of the exported columns.
Review the Clipboard preview at the bottom of the pane to see the order and fields that are ready for export and click OK.
Finally, paste from the clipboard into MS Excel or a similar tabular program by clicking in a cell and pressing Control + V.
Import from Clipboard – Use this to copy all of the data on your computer's clipboard to the open Tilos list.
First, copy from MS Excel or a similar tabular program to the clipboard by selecting the data types you need in Tilos and pressing Control + C.
With one of the Project Data or Library lists open in Tilos, click Import from Clipboard, check/uncheck boxes for all of the fields you want to include/exclude in the import in the Fields for Clipboard Import/Export dialog, and change the Column Numbers or Column Letters to rearrange the order of the imported columns.
Review the Clipboard preview at the bottom of the pane to see the order and fields that are ready for import and click OK. The data is pasted into your open Tilos list.
Fields that can be exported/imported
Absolute Station*, Equation, Length, Text, Station Ahead, and Station Post
Note: Only the equation list (lower part of the window), is imported/exported.
Next topic: ---
Equations