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

 

(1162)

A Skyscraper Remodelling Schedule – displayed in Time-Location-Diagram – with TILOS

Still an unusual sight, but why not? Here we present an example of how to display a Skyscaper-Remodelling-Schedule in a Time-Location Diagram.

The vertical axis represents the levels / floors of the building. Alongside this axis the map of the skyscraper facilitates the connection between activities and level/location of work.

The horizontal axis represents the time axis.

As a result there is a chart, comparable to a standard Gantt view – but enhanced with the location dimension.

The tasks are mainly displayed as ribbons or lines. They represent how the different crafts are moving trough the building. An overlapping of ribbons indicates that different crafts are planned in the same location at the same time.That may be a clash.
The horizontal distance between two neighboring crafts represents the “buffer” between them.

skyscraper-remodelling-Schedule

skyscraper-remodelling-Schedule

Download Skyscraper Remodelling Schedule as PDF.

For sure TILOS can add cost and resource information along each axis: Time and distance.

 

 

(1227)

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

 

(1029)

Tutorial Video: What are the Benefits of Time Location Diagrams for planning infrastructure construction projects?

This is a Tutorial Video for general understanding of the benefits of time-location diagrams for planning infrastructure construction projects.

The major planning and process problems of such projects are also visualized.

Targeted audience:
All people involved in infrastructure construction, who want to get first information about planning in Time-Location-Diagrams: Estimators, planning engineers, project schedulers, controllers, civil engineers, students, teachers.

(Direct Link to the video: http://youtu.be/9sTkqqOcL-g)

(983)

New module for TILOS 8: TILOS ProgressMap

View to the earth: TILOS ProgressMap can show your project and schedule on the globe using GIS programs like Google Earth® or ESRI©

The geometry (path, place marks or polygons) can be connected with the schedule data from TILOS. For each path point a distance value is generated that becomes the connector to the TILOS distance coordinates.

ProgressMapViewExample: The thick lines displaying work areas of selected crews in week 24-28 April 2013. The orange lines aside are displaying the baselines (Where the crews should have worked according to the initial plan)

The yellow symbol displays that the river drill is progressed by 75 %.

Message: It is not needed to create complex BIM data models to make a simulation of the project execution and to see what is built at each location on the map.

Adding geometry: Geometric data can be imported from KML/KMZ files, which is a standardized format. In addition Spreadsheet tables can also be used to import the geometry with the GPS data.

Adding the schedule: Schedule data is imported from the currently opened project in TILOS. During the import, the data is sliced by time to calculate the work planned for each period.

Adding configuration: Simple filter and grouping functions are used to transform the schedule to “moving lines” or to “changing symbols” based on the progress state of the associated activities.

Progress table: The progress table displays the progress situation for each type of work.

ProgressMapSituationEach color corresponds with the % complete of the total cut or fill. The map provides the same overview on each area.

ProgressMapReportClicking on an area, all tasks connected with that area become visible.

 

(1872)

TILOS Version 8 contains Google Earth Integration

Linear project GmbH releases the ‘beta’ version of its linear scheduling software TILOS 8. It is a major step in the development of the software providing the foundation for a wider usage of TILOS in the future: It can handle much bigger projects and works faster. It allows merging of data from different planning phases or partners using the simple drag & drop function to consolidate sub-projects into one central file. The improved planning features of TILOS enable its usage as an analysis and visualization tool for those who still plan with Primavera or Microsoft Project Gantt Charts.

One of the most interesting aspects of TILOS 8 is the new Google Earth add-on component. Just some clicks are required to visualize your project on the globe.

The steps are:

  1. Import the paths and placemarks from Google Earth or a spreadsheet
  2. Load the schedule from TILOS
  3. Set the filters and the display criteria of what you would like to view.

The image above is showing the situation on Feb 09, 2013. The autoplay function simulates the ongoing construction process in user defined steps. The Screen is updatedevery ten seconds to show the new status on the next step. Linear tasks are displayed as lines in different colors while those being executed in one place (buildings) are displayed as symbols. The animated map provides a rough roadmap of the execution of the project for all parties.

To get more information, watch the video on how to make a Google earth visualisation:
This video ist hosted by youtube. please change to the best resolution availlable in the bottom settings bar.

If you would like to test the new TILOS Version 8 with Google Earth Integration, you may sign-up and register for our global test program. Be one of the first to try the new functions with TILOS8. Send an email to BetaTest@TILOS.org.

We intend to release the international version of TILOS 8 (English) at the end of January 2013.

(2947)

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)

(2460)

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

 

(5395)

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)

(1938)