Microsoft Project Member for 21 years 8 months Member for 21 years 8 months Submitted by Rafael Davila on Thu, 2015-01-15 13:02 Permalink Suggest using Excel to help Suggest using Excel to help communicate and develop the formulas. It might be you need an additional UDF and formula to calculate Planned Duration depending on the MSP available fields. Good Luck, Rafael Member for 21 years 1 month Member for 21 years 1 month Submitted by Charles Gibbons on Thu, 2015-01-15 11:22 Permalink Hi thanks for the reply these Hi thanks for the reply these links seem to deal with the varience from baseline to resheduled position What Im actually trying to achieve is the traditional slip column you would get in ASTA i.e. 10 day activity is due to complete on the report date but is only 80% so the 3 columns would look like Planned 100 (Pasted into this column from updating project and then undoing) Actual 80 (manually typed) Slip -2 days All without reshedulling Any ideas? Charlie Member for 21 years 8 months Member for 21 years 8 months Submitted by Rafael Davila on Wed, 2015-01-14 17:54 Permalink Long time I have not used Long time I have not used MSP, do not even have a license but maybe this can help: http://www.projectlearning.net/pdf/I1.1.pdf http://office.microsoft.com/en-001/project-help/start-variance-fields-H… http://www.textndata.com/forums/baseline-finish-finish-variance-206769… http://pm.stackexchange.com/questions/7942/how-to-calculate-execution-v… Be careful with formulas and the difference between varanace calculated considering only workdays versus variance that also include non-work days. Good Luck Member for 21 years 1 month Member for 21 years 1 month Submitted by Charles Gibbons on Wed, 2015-01-14 16:30 Permalink anyone? is it possible? anyone? is it possible? Log in or register to post comments
Member for 21 years 8 months Member for 21 years 8 months Submitted by Rafael Davila on Thu, 2015-01-15 13:02 Permalink Suggest using Excel to help Suggest using Excel to help communicate and develop the formulas. It might be you need an additional UDF and formula to calculate Planned Duration depending on the MSP available fields. Good Luck, Rafael
Member for 21 years 1 month Member for 21 years 1 month Submitted by Charles Gibbons on Thu, 2015-01-15 11:22 Permalink Hi thanks for the reply these Hi thanks for the reply these links seem to deal with the varience from baseline to resheduled position What Im actually trying to achieve is the traditional slip column you would get in ASTA i.e. 10 day activity is due to complete on the report date but is only 80% so the 3 columns would look like Planned 100 (Pasted into this column from updating project and then undoing) Actual 80 (manually typed) Slip -2 days All without reshedulling Any ideas? Charlie
Member for 21 years 8 months Member for 21 years 8 months Submitted by Rafael Davila on Wed, 2015-01-14 17:54 Permalink Long time I have not used Long time I have not used MSP, do not even have a license but maybe this can help: http://www.projectlearning.net/pdf/I1.1.pdf http://office.microsoft.com/en-001/project-help/start-variance-fields-H… http://www.textndata.com/forums/baseline-finish-finish-variance-206769… http://pm.stackexchange.com/questions/7942/how-to-calculate-execution-v… Be careful with formulas and the difference between varanace calculated considering only workdays versus variance that also include non-work days. Good Luck
Member for 21 years 1 month Member for 21 years 1 month Submitted by Charles Gibbons on Wed, 2015-01-14 16:30 Permalink anyone? is it possible? anyone? is it possible?
Member for
21 years 8 monthsSuggest using Excel to help
Suggest using Excel to help communicate and develop the formulas.
It might be you need an additional UDF and formula to calculate Planned Duration depending on the MSP available fields.
Good Luck,
Rafael
Member for
21 years 1 monthHi thanks for the reply these
Hi thanks for the reply
these links seem to deal with the varience from baseline to resheduled position
What Im actually trying to achieve is the traditional slip column you would get in ASTA
i.e. 10 day activity is due to complete on the report date but is only 80%
so the 3 columns would look like
Planned 100 (Pasted into this column from updating project and then undoing)
Actual 80 (manually typed)
Slip -2 days
All without reshedulling
Any ideas?
Charlie
Member for
21 years 8 monthsLong time I have not used
Long time I have not used MSP, do not even have a license but maybe this can help:
http://www.projectlearning.net/pdf/I1.1.pdf
http://office.microsoft.com/en-001/project-help/start-variance-fields-H…
http://www.textndata.com/forums/baseline-finish-finish-variance-206769…
http://pm.stackexchange.com/questions/7942/how-to-calculate-execution-v…
Be careful with formulas and the difference between varanace calculated considering only workdays versus variance that also include non-work days.
Good Luck
Member for
21 years 1 monthanyone? is it possible?
anyone? is it possible?