Schedule Analyzer Overview

SAe Related Schedules
By Ron Winter Consulting LLC, Copyright 2006
(770) 587-4903 or email at Ron@RonWinterConsulting.com.com

It is extremely important that submitted schedules show the same calculated dates after they are exported as they did before they were exported. Exporting and importing Primavera schedules is difficult to do with 100% accuracy. This is mainly due to the enterprise structure concept.

The enterprise concept of a single database holding multiple schedules is a very powerful idea. Schedules can be related via connecting logical relationships. They can share a common pool of resources. They can even use the same calendars for determining weekends and holidays.

The problem with all of this relational ‘sharing’ becomes evident when you export a single schedule out of your database and import it somewhere else. What happens to all of that schedule interconnectivity? More importantly, will the newly imported schedule reflect the same CPM calculated dates as it did before it was exported? After all, if the dates displayed in your schedule are a function of the related schedules that are no longer present, how can the new schedule reflect the same issues as the old one? In other words, the new schedule is not a real copy of the old one.

It is very difficult to anticipate all of the related schedule’s interactions. SAe Related Schedules researches the issues for you and only reports on this issues. To be effective, you must run Related Schedules on the database that is being exported from, not the one that is being exported to.

Below is a sample Related Schedules output report for sample Project Highway South.



                       SAe RELATED SCHEDULES
                   ============================
                   |        Version 1.22      |
                   ============================
             Copyright (c) Ron Winter Consulting 2006

Project: HwySouth, Phase 1 - Southbound
 Analysis Date: 01-30-2006 at 13:40:27

============================================================================

The following projects and relationships are SUCCESSORS to Project HwySouth.

    Project HwyNorth, Phase 2 - Northbound

        Predecessor Activity P1G110, GENERAL CONDITIONS
            Successor Activity P2G600, PROJECT COMPLETE

        Predecessor Activity P1N2210, EXCAVATE RETAINING WALL
            Successor Activity P2N2115B, REMOVE GUIDE RAIL

        Predecessor Activity P1N3225B, CONSTRUCT CONCRETE BARRIER AGAINST WALL
            Successor Activity P2G600, PROJECT COMPLETE

    3 external relationships exist.
    This will cause problems with your schedule export showing different
    dates unless all related schedules are exported as a group.

----------------------------------------------------------------------------

The following RESOURCES are shared with Project HwySouth.
    Key: Project
             Resource, Number of Activities

    Project Bldg, Office Building Addition

        Finisher, # Acts = 5
        Truck Crane, # Acts = 1

    Project HwyNorth, Phase 2 - Northbound

        Asphalt Paver, 130 H.P., # Acts = 2
        Foreman, # Acts = 15
        Truck Driver - Heavy, # Acts = 1
        General Laborer, # Acts = 5
        Skilled Laborer, # Acts = 2
        Equipment Operator - Light, # Acts = 1
        Equipment Operator, # Acts = 11
        Loader/Backhoe 80 H.P., # Acts = 8
        Aggregate Spreader, # Acts = 1
        Roller, Tandem, # Acts = 1
        Roller, Steel Wheel, # Acts = 3
        Truck - Flatbed, 3 Ton, # Acts = 1
        Truck Crane, # Acts = 4
        Dozer, 200 H.P., # Acts = 2

    63 activities share resources with Project HwySouth
    This can pose a portability issue if resource leveling is being used.

----------------------------------------------------------------------------

The following BASE CALENDARS are shared with Project HwySouth.
    Key: Project
             Calendar, Number of Activities

    Project Lincoln Hospital- A, Lincoln Hospital Project Trauma Ward - April update

        Standard 5 Day Workweek, # Acts = 13

    Project Lincoln Hospital- R, Recovery Plan -Lincoln Hospital Project Trauma Ward

        Standard 5 Day Workweek, # Acts = 12

    Project Bldg, Office Building Addition

        Standard 5 Day Workweek, # Acts = 19

    Project DsgnAEB1000, Design for model AEB1000 S.R.S.

        Standard 5 Day Workweek, # Acts = 57

    Project HwyNorth, Phase 2 - Northbound

        Standard 5 Day Workweek, # Acts = 16

    Project Auto, Automated System

        Standard 5 Day Workweek, # Acts = 8

    Project T&EInst, Tooling & Equipment Installation

        Standard 5 Day Workweek, # Acts = 14

    Project Conv, Conveyor System

        Standard 5 Day Workweek, # Acts = 7

    Project Architectural Design, Architectural Design Template for Mid Rise Commercial Office

        Standard 5 Day Workweek, # Acts = 57

    203 activities share calendars with Project HwySouth
    Note:  The default import option is to not update the calendar with
    new holiday data. This can leave the imported schedule with different
    holidays than the original schedule, causing dates to be different.


The following RESOURCE CALENDARS are shared with Project HwySouth.
    Key: Project
             Resource Calendar, Number of Activitiy Resourcess

    Project Lincoln Hospital- A, Lincoln Hospital Project Trauma Ward - April update

        Standard 5 Day Workweek, # Acts = 25

    Project Proposed Project HC1, Hampton Gardens Senior Communities (Design, Bid, Build)

        School District 5 Day, # Acts = 1

    Project Proposed Project HC2, Hampton Gardens Senior Communities (Finishes Details)

        Standard 5 Day Workweek, # Acts = 5

    Project Lincoln Hospital- R, Recovery Plan -Lincoln Hospital Project Trauma Ward

        Standard 5 Day Workweek, # Acts = 25

    Project Lofty Heights, 9 Pacific Drive - Lofty Heights

        Standard 5 Day Workweek, # Acts = 81
        School District 5 Day, # Acts = 8

    Project Edison High, Edison Area High School (Renovation & New Construction)

        School District 5 Day, # Acts = 394

    Project Bldg, Office Building Addition

        Standard 5 Day Workweek, # Acts = 80

    Project HwyNorth, Phase 2 - Northbound

        Standard 5 Day Workweek, # Acts = 54
        School District 5 Day, # Acts = 8

    Project Auto, Automated System

        Standard 5 Day Workweek, # Acts = 65

    Project Conv, Conveyor System

        Standard 5 Day Workweek, # Acts = 22

    768 activities share resource calendars with Project HwySouth
    Resource calendars are only important if you have resource-dependent
    activity durations.

    Note:  The default import option is to not update the calendar with
    new holiday data. This can leave the imported schedule with different
    holidays than the original schedule, causing dates to be different.

----------------------------------------------------------------------------

The following documents are referenced by Project HwySouth.

    Cast in place concrete quote, revised on 28FEB03
        Location: C:\Program Files\Primavera P3ec for Construction\Project M
        anager\Documents\Cast in Place Concrete Quote.htm

    Crane Equipment, revised on 28FEB03
        Location: C:\Program Files\Primavera P3ec for Construction\Project M
        anager\Documents\Crane.bmp

    Specification, revised on 28FEB03
        Location: C:\Program Files\Primavera P3ec for Construction\Project M
        anager\Documents\Specifications.doc

    3 documents are referenced by this project and will not be exported.