Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-28-2021, 07:10 PM
Arif Arif is offline Milestone weightage Windows 7 64bit Milestone weightage Office 2010
Novice
Milestone weightage
 
Join Date: Feb 2019
Posts: 3
Arif is on a distinguished road
Default Milestone weightage

How to convert duration into task / milestone percentage (e.g project life cycle is based on 500 days and we have 4 milestones so how can we convert it in percentage to set task weightage)? Which formula to be applied?

Reply With Quote
  #2  
Old 04-29-2021, 11:58 PM
miless2111s miless2111s is offline Milestone weightage Windows 7 32bit Milestone weightage Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

I have used a standard set of milestones which had to be applied to each project and then an external spreadsheet to collate across the programme. We had (from memory) 6 milestones picking up key points such as Started, Business Case complete, Initiation complete, Ready for testing, UAT complete, Implemented. In excel we than could weight them by size of project and different "scores" for each milestone which then allowed a very crude form of earned value when comparing baseline to current plan etc.
To do this I had a field for milestone reference which output a table with ID | name | milestone ID | % complete | project and used this data to produce the curves and % complete etc.
Reply With Quote
  #3  
Old 05-06-2021, 07:59 PM
Arif Arif is offline Milestone weightage Windows 7 64bit Milestone weightage Office 2010
Novice
Milestone weightage
 
Join Date: Feb 2019
Posts: 3
Arif is on a distinguished road
Default

Thanks for your feedback but this is secondary option, I heard it can be possible by applying formula but i didn't find yet

Anyways again thanks
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
milestone report squeezebox Project 1 05-13-2021 03:02 AM
Milestone weightage Leveling of resources ignores milestone links gharli Project 1 11-29-2015 11:50 AM
Milestone weightage milestone with more than 0 day duration ketanco Project 3 06-16-2014 11:00 AM
Milestone weightage Is my Milestone working that way it's suppose to? Enuhseh207 Project 1 02-23-2014 09:24 AM
Milestone durations fraserm Project 4 01-13-2012 08:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft