Import

The Import page allows you to import tasks to the selected project and a scenario.  This page also allows importing of files which contain multiple projects after selecting an import method.  The accepted file types are .xer, .mpp and .xls.  (Figure 1)

 

import

Figure 1

Select Project and Select Scenario:

This is used to select the specific project from the project list for which the tasks will be imported and also the scenario based on which the cost estimation is done.

Steps:

  1. Cost Analysis —>Import
  2. Select the project from the Project List dropdown, and then select the scenario from Scenario Options dropdown. (Figure 2)

 

select project

Figure 2

Import Files:

 

There are 3 methods for file importing: Simple Uncertainty, Quantities and Rates, Multiple Resources.

 

import methods

Figure 3

To know about the import methods, click the help icon (Figure 3) which shows a popup with a brief description about the import types. You can also download the template for each method. (Figure 4)

 

import methods help

Figure 4

Import 1 – Simple Uncertainty

The imported file must be of type xls, mpp, and xer.

Steps:

  1. Cost Analysis —>Import
  2. Select the import method Simple Uncertainty from the combo and the selected method will lock automatically. (Figure 3)
  3. To import .xls file:
    1. Click BROWSE button to browse a .xls file and click LOAD THE FILE button. (Figure 5)
    2. Map the data and click IMPORT VALUES button. (Figure 5)
  1. To import .xer, .mpp files:
    1. Click BROWSE button to browse a .xer or .mpp file and click LOAD THE FILE button. If there are multiple projects in the file, tick the Import all projects in the selected file check box before uploading if needed.  (Figure 6)

 

downstream_simple_uncertainty_import_values

Figure 5

simple_uncertainti_xer_import

Figure 6

Import 2 – Quantities and Rates

The imported file must be of type xls.

Steps:

  1. Cost Analysis —>Import
  2. Select the import method Quantities and Rates from the combo and the selected method will lock automatically. (Figure 3)
  3. Click BROWSE button to browse a .xls file and click LOAD THE FILE (Figure 7)
  4. Map the data and click IMPORT VALUES (Figure 7)

 

7_downstream_quantity_and_rates_import_value

Figure 7

Import 3 – Multiple Resources

While selecting Multiple Resources method, it shows 2 types of break up views.

 

import breakups

Figure 8

The imported file must be of type xls, mpp, and xer.

Steps:

  1. Cost Analysis —>Import
  2. Select the import method Multiple Resources from the combo and the selected method will lock automatically. (Figure 3)
  3. To import .xls file:
    1. Click BROWSE button to browse a .xls file and click LOAD THE FILE button. (Figure 9)
    2. Map the data and click IMPORT VALUES button. (Figure 9)
  1. To import .xer, .mpp files:
    1. Click BROWSE button to browse a .xer or .mpp file and click LOAD THE FILE button. If there are multiple projects in the file, tick the Import all projects in the selected file check box before uploading if needed.  (Figure 10)

 

9_downstream_multiple_resources_import_values

Figure 9

import xer mpp

Figure 10