How to prepare a Primavera Schedule for Exporting to TILOS Time Location System

Following a description of the most basic preparations on a Primavera Schedule, when you intend to transfer this Schedule to TILOS and display it in a Time-Location-Diagram:

Promavera To TILOS

A. Additional Data Fields

Some additional information for the activities has to be edited in the Primavera project:

  1. Location information
    Each activity needs to have a Start Location and End Location value. Those are needed to display the activity along the location axis and this is displaying the working direction too.
    Preparation: Create User Defined Fields (Text) named StartLocation and EndLocation and insert the corresponding values.
  2. Display information (Colors and shapes)
    In the Time-Location diagram a task cannot only be displayed in one fixed way: They can have different shapes (e.g. lines, rectangles, parallelograms), linestyles and color. Those graphical characteristics are in TILOS controlled by the object “template”.
    Preparation: Create a User Defined Field (Text) named TilosTemplate and insert for each activity a value (e.g.”pipe laying” or “concrete work”): All activities that should look the same in TILOS get the same value.

B. Activity Filter

Preparation: Create a Filter that selects all the activities that you want to transfer. You may create another User Defined Field (Text) named TilosExport and set a value when the Activity should be exported.

Think about Structures, Summaries and Granularity:
Is the Time-Location diagram showing all details or is there a different Granularity? E.G. Some Buildings/construction elements can be displayed by the Summary activity only. In this case Summary/WBS activities or level of effort activities has to be created.

Define the task granularityDownload this description as a PDF

 

(1076)

Video: How to transfer a Construction Project from Primavera to Tilos? – 20min Tutorial

This video tutorial shows how to transfer an existing project schedule created in Primavera P6 to a Time Location Diagram in TILOS. The TILOS Exchange Software is used. 20min to invest for a better understanding of the concept and the how to do.

Direct Link to the video: http://youtu.be/AWLbNw2KuMA

 

(1009)

Video blog: Displaying different projects with different distance scales on one page

See how to create a second Time-distance-diagram, that contains a different project. That method can be used either for showing separate distance areas in one project but also to display different stages of the same project: Displaying the main schedule and a scenario schedule on one page.

Video:


This video ist hosted by youtube. please change to the best resolution availlable in the bottom settings bar.
(Direct link to the video: http://youtu.be/sdE0xfJc6ow)

(2450)

How to import activities to TILOS from a simple Primavera Excel-Output

Primavera P6 allows to put activity data in an Excel Spreadsheet. This small guide is showing how to set up the TILOS Excel import profile in order to create a TILOS chart fast and easy.

1. Preparation

a. Location information:
In Primavera create the activity user defined fields “FromLocation” and “ToLocation”. For each activity in question fill the location values. (e.g.12’580).

b. Template information (Display of the TILOS tasks)
One activity field is necessary to contain the TILOS task template information in order control the display of the task in TILOS.  You may use codings that are containing all names of the TILOS task template. (e.g Code “Welding”, that points to the task template “Welding” in TILOS.)

c. activity selection (Filter)
In most cases not all activities shall be transported. Please use a filter to select the activities to export.

d. Export to Excel file
For Primavera output use the predefined P6 activity fields and add the user defined fields for template code and FromLocation and ToLocation.
The Output file looks similar to that sample: On the page “TASK” you find some columns containing you activity data. The table has two headlines.
(You may also export the Links in the Excel file. In this case for links there will be a page “TASKPRED”.)

Primavera Excel Export

e. Prepare the TILOS file
Adjust the Time-Distance-Diagram to show the time and distance range fitting to the activity data.
Approve, that all activity templates are existing and the display is set up correctly

 2. Importing into TILOS

  • In  TILOS choose “File -> Import” to call the Import Wizard.
  • Import Wizard Step one (Import format): Choose “Microsoft Excel (XLS)” (Note: You have to licene that module)
  • Import Wizard Step two (Data source): Select the xls file that cotains the data.
  • Import Wizard Step three: (Select profile): Select the template profile “Primavera Import Sample WBS as Task field”.
    Once you have to change the profile to match your spreadsheet. Later you may reuse it.

Here are some important hints:
The Format m/d/yyyy h:nn:ss AM/PM describes the Standard US date formatting Primavera uses for the dates.You may adjust that to your local settings.
TILOS Import: Formatting

Number 3: Edit the activity field list used in the spreadsheet. The fields and the number of the columns in the spreadshee has to match:

TILOS Import, Fieldlist

  • Import Wizard Step four (Sub-Project selection):  Choose the subproject the data should be inserted in.

During the import the Wizard is doing.

  • Creating each line as a task with the desired field values
  • Assigning the Template (Display) for each task
  • Checking the Task-Id: if this task is already existing there will be no new task created. Only the values will be updated on the existing task

 

(4563)

Video blog: Creating colored Ribbons in the distance scale

See, how to create colored ribbons in the distance scale and display your project in a professional way:

Video:


This video ist hosted by youtube. please change to the best resolution availlable in the bottom settings bar.
(Direct Link to the video: http://youtu.be/1PfTXUO8_6s)

(1913)

How to insert watermark or background images?

How to add signs for draft or confidential / copyright information to a plan?

There is an easy solution using the layer fuctions to display graphics or texts in the backgound in any cell:

  • Please create a Layer and name it “watermark”.
  • Insert the pictures/objects into the desired cell in the normaly way.
  • Assign the pictures/objects to the layer “watermark”

Now use the layer order and move the layer watermark to the bottom, even beneath the calendar layer:

All objects assigned to this layers are now displayed behind all other objects in the background.

Tipps:

  • Unselect the Display-Flag and and select the Print-Flag for the Watermark layer to make the watermark invisible on screen, but still printed.
  • Unselect the Active-Flag for the Watermark layer: Now the assigned objects canot be selected – and not be moved by accidant.

The layer oder and layer visibility can also be used to order tasks and other objects

– and especially – to hide and show special information on a schedule.

(1850)

How to set up tasks with transparent background – for displaying overlapping tasks?

Sometimes you need to display multiple tasks at the same place – or need to overlap each other. TILOS has the possibility to use transparent colors, that support the desplay of overlapping tasks. The transparent color can be set not only as a solid background color but also as a transparent part of a pattern.

Take the tagged color from the color picker to select the transparent color:

 

 

 

Create different looking transparent task shapes:

Addition:

Use the object order and the layer order additionally to order the tasks and get the desired look by this way.

 

(1260)

When is the crew arriving at a special location?

Mission: Display the date, that a crew/activity is arriving at a special station

Sample application: A pipeline crew is working along the ROW. When is the crew arriving at the river?

Implementation:

  • Create a milestone task at each station you like to have the arrival date/time
  • Link the line activity start/finish to each milestone
  • Select the link option “Calculate lag by Distance tu Successor with the lag value 0. This will force the milestone nearest to the line
  • Add annotations to the milestones and set up the with tokens:

Station: {Start.Distance.Estimate}m
Arriving: {Start.Date.Estimate}

Result after Reschedule:

Addition:

  • The symbol of the milestones can be set in the tab display of the task
  • The size of the milestones can be set in the tab  display of the time-distance cell
  • Station List as a Gantt spreadsheet:

(1112)

How to calculate the meeting point of two lineage tasks

Mission: Calculate and display where and when two tasks will meet, that are working towards each other.

Sample application: Meeting point calculation in Tunnel construction with two driving tasks.

Preconditions:
– Both tasks are calculated by duration  (calculation by profile is possible)
– The Quantity is calculated by the task length

Implementation:

– Create a finish-finish link between those two tasks
– Change the link type to “Calculate meeting point”.
– Reschedule the project.

Result:

Addition:

With the “Lag” value can be defined a waiting time:
– The first task has to be arrived at this station (First is defined with the direction of the link)
– then wait the Lag time
– Then the second tasks arrives

 

(1437)