将突发事件纳入项目计划
管理持续时间高度不确定的任务的最佳方法是什么?例如解决一个设计问题——有时很快,有时需要一段时间。
我们之前使用的一个软件,允许你对每个任务进行最佳情况和最坏情况的估计——根据每个任务的不确定性水平,有效地为每个任务增加偶然性。然后,软件将所有这些小意外事件加在一起,并将其中的一部分(默认为50%)添加到项目结束时作为意外缓冲。
这样做的好处是,你可以非常准确地掌握你需要多少应急,你可以跟踪你在项目的任何阶段用了多少应急缓冲,因此,达到目标日期的可能性是多少。
在研发中,我们的许多任务都有很高的不确定性,所以给出一个单一的日期是很棘手的,除非我们一直保守下去,这是有效的,但人们会担心项目太长了。
最佳答案
-
Just_Chris ✭✭
嘿:)
您可以添加一种时间线风险列,为您的项目计划结束添加缓冲-这里是它可能看起来的快速视图
答案
-
Just_Chris ✭✭
嘿:)
您可以添加一种时间线风险列,为您的项目计划结束添加缓冲-这里是它可能看起来的快速视图
-
好主意!谢谢克里斯!
-
tplavac ✭✭✭
我喜欢这个主意,但是谁能帮我弄一下这个公式吗?我是一个用公式的新手️
-
吉纳维芙P。 员工管理
-
tplavac ✭✭✭
-
吉纳维芙P。 员工管理
是的,你说得对!如果你的表有相同的列名和设置作为这个表,那么你可以写一个嵌套的If语句来组合所有的语句在Days + Buffer列,像这样:
=IF([时间风险]@row =“零”,[计划天数]@row * 1, IF([时间风险]@row =“低”,[计划天数]@row * 1.25, IF([时间风险]@row =“中”,[计划天数]@row * 1.5, IF([时间风险]@row =“高”,[计划天数]@row * 2))))
最后一列就是把这个单元格乘以4。明白了吗?
-
tplavac ✭✭✭
@Genevieve P。谢谢你!
这对我来说不太管用,但我正在努力弄明白。它确实有意义,但我得到了一个不可解析的错误。我在上面的[计划天数]栏中使用了持续时间栏。
-
吉纳维芙P。 员工管理
你能在你的工作表中发布一个公式的屏幕截图吗?
-
tplavac ✭✭✭
@Genevieve P。当然,给你。
-
tplavac ✭✭✭
非常感谢你的帮助!我正在努力学习和理解项目管理公式。你是先推荐下面这门课,还是先推荐别的?
https://smartu.smartsheet.com/plan/formulas-for-project-management
-
吉纳维芙P。 员工管理
类别
You are welcome. One Day the platform will allow this but for now we wait. If my answer was sufficient please mark your question as answered.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":105945,"type":"question","name":"Dashboard reports not showing on published dashboard in SharePoint","excerpt":"I have embedded a Smartsheet dashboard in a SharePoint Online site. Some reports show just fine, two do not and I can't figure out why. I published the dashboard and grabbed the embed code. Used an embed web part in SharePoint to embed the dashboard. Two reports show fine, the other two have errors. There is nothing…","categoryID":321,"dateInserted":"2023-06-02T12:17:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-02T12:33:24+00:00","insertUserID":81546,"insertUser":{"userID":81546,"name":"Andrea Zenner","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Zenner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-03\/c8\/bb\/nc8bb6b7bd2a9297545e5baeb6a5ba8ed.jpg","dateLastActive":"2023-06-02T12:33:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":29,"score":null,"hot":3371419869,"url":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105945\/dashboard-reports-not-showing-on-published-dashboard-in-sharepoint","format":"Rich","tagIDs":[265,292],"lastPost":{"discussionID":105945,"commentID":378523,"name":"Re: Dashboard reports not showing on published dashboard in SharePoint","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/378523#Comment_378523","dateInserted":"2023-06-02T12:33:24+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-02T20:54:24+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/PF6NIRYD5DHX\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-02T12:34:10+00:00","dateAnswered":"2023-06-02T12:33:24+00:00","acceptedAnswers":[{"commentID":378523,"body":"
That is exactly it. Is the \"Their Own Perspective\" the broken one? Basically... You have to be logged in to Smartsheet for Smartsheet to know who is viewing the report so that it can provide the correct \"perspective\".<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"}]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">