Search

Schedule date calcs in Excel

Forum Topic

So to calc a completion date in excel that includes the NTP date itself is @sum((A1+A2)-1) because excel does not count the NTP date in that formula.  With a A1 being the NTP date and A2 being that Calendar Days.  Are there any other, or different fo...

Jan 6, 2022

Advise - Estimating Down Time

Forum Topic

Hi, I have seen a couple of spreashsheets created that estimated days /month or days/activity that a project is likley to lose from different weather conditions such as below.or Both of these do a job but I am wanting to create something that has a b...

Jan 7, 2022

Imported Project Without Baseline

Forum Topic

Hi,I have imported a file without its baseline. But I see baseline start/finishes dates are different than project start/finish dates. I checked there is no assigned baseline. I expect if there is no baseline assigned to the project then baseline dat...

Oct 6, 2020

Customising different column headers for different projects

Forum Topic

I am managing two different projects for different clients in P6 that require the schedules to be published every week.  The clients require different column headers and so far I have had to keep changing the headers when I go to publish each project...

Oct 7, 2020

CCT Exam - recommendations

Forum Topic

Hi everyone, I am hoping to further advance my career in PC, and was wondering if anyone taken the CCT (certified cost technician exam), and if it helped with their career? Was the exam difficult and heavily math oriented (one of the study text books...

Oct 7, 2020

Stand alone cost tools - looking for suggestions

Forum Topic

Always been in scheduling.  Been in and out of cost, getting back into cost.  There have got to be better tools out there than just excel - what are better ones for cost?  For example, I don't want a "whole" system like procore because already using ...

Oct 9, 2020

Actual Costs in P6 - EV Nirvana??

Forum Topic

After a number of years working in Project Controls, and several organisations, I can get my head around Planning and Resources but what i see constant in-fighting, division and confusion around is just how Actual Costs and how actual costs are align...

Oct 9, 2020

Rampup modelisation

Forum Topic

Hello,I have a task under MSProject which corresponds to an action whose duration does not depend on the number of resources. I would like to integrate resources on this task gradually.On the first day, 2 resources are on the task, 3 more the next da...

Oct 10, 2020

Update Baseline

Forum Topic

Hello,I am trying to update a baseline using the "Update" button in the "Maintain Baselines" window. I am working on a project that will have multiple bid packages over the length of the project and the owner wants to use earned value management. I d...

Oct 12, 2020

Contracts and Project Control Procedures and Processes

Forum Topic

Hi,I have been given a task of standardizing Contracts and Project Controls processes and procedures. We are a service company in oil and gas and management is looking to reestablish these procedures based on well-known standards in major oil compani...

Oct 14, 2020

Export of Baseline

Forum Topic

Hello Everyone, I am using  P6.18.8.0 version.When I export it in XER format, the baseline is not been exported.when I export in XML format again the baseline is not exported.Any solution to this.ThanksJithin  

Oct 19, 2020

Color Activity not meeting Baseline

Forum Topic

Hello Everyone, Is there a way by which the Activity Bar which didnt meet the Basline Date can be highlighted in a different colour Say like Orange. Red coloured bar is critical activity, but I would like to show activities which hasnt met the baseli...

Oct 21, 2020

FS vs SS

Forum Topic

Hi,I need to change my relationship from FS to SS. When I try to do this via excel P6 keeps the FS relation. How can I remove the FS relations when I import the excel file. I want only SS relations.Many thanks for your support.

Oct 22, 2020

Primavara Calendar Stopped Work (Covid 19)

Forum Topic

 Hello all,  My site was shutdown on the 24-Mar-20 due to Corona virus. However, my subcontractors returned to site at different time.  Some of them returned on 15-Jun-20, some returned on 29-Jun-20, some on 22-Jun-20 and some on 03-Aug-20.  My comme...

Oct 22, 2020

Exporting Resource Assignment fromp6 to excel

Forum Topic

Hi everyone,I tried copying the resource assignment from P6 to excel, when i do this the units dont get copied across and the date column dates back to 1990 and my projects starts in 2020.Not sure what am doing wrong.Please help.

Oct 22, 2020

Time Location Charting Mini-Course - Survey

Forum Topic

I will be creating a video mini-course on using Time Location Charts (aka Linear Schedules) to make better decisions and improve scheduling communication on projects, based on my practical experience over the past 20yrs in the industry, But first, I'...

Oct 23, 2020

WBS and Activity Names

Forum Topic

In a schedule with a structured WBS what is the best practice for the activity names - exampleWBS: Site1/Building5/Area3/Machine foundations/  Activity Name: Pour ConcreteOR: Activity Name: Pour Machine foundation concrete at Site1, Building5, Area3 ...

Oct 23, 2020