SSI Schedule Sanitizer Introduction
8:10
SSI PRESENTATION PROFESSIONAL
1:14
2 жыл бұрын
SSI Trace Tools Overview
9:45
4 жыл бұрын
Project Performance Tools
13:20
5 жыл бұрын
SSI Lookup Tools
3:18
6 жыл бұрын
SSI Tools For Microsoft Project
1:04
SSI Tools For Microsoft Excel
1:12
6 жыл бұрын
SSI Time Phased Resource Analysis
3:34
SSI Analysis Tools Intro
2:28
6 жыл бұрын
Пікірлер
@Belle57
@Belle57 Ай бұрын
Is there a video on statusing resource loaded schedules? Is that any different?
@marwanmohamed4275
@marwanmohamed4275 Ай бұрын
Hi . Can I set auto status date periodic weekly on Ms project not manually
@bamsarya8024
@bamsarya8024 2 ай бұрын
what version msproject profesional do you have
@Knarcout
@Knarcout 3 ай бұрын
shouldn't you "set the baseline" first so the baseline start and baseline finish dates are saved. So whatever changes you make on the duration or on the "Start" or "finish" wont affect the baseline... im not a pro, just thinking if setting the baseline should be in the initial procedures. i think it should..
@StructuredSolutionsInc
@StructuredSolutionsInc 2 ай бұрын
Hi! yes, I would recommend having a baseline set before you start to status a project. I didn't cover that because I considered baseline stuff to be out of scope of this video.
@roldanduarteholguin7102
@roldanduarteholguin7102 4 ай бұрын
We want to share with Companies, Universities and Governments 57 years of successful professional experience in several countries, in Oil and Gas, Petrochemical, Steel, Hydroelectric, Engineering and Construction Projects. Since 1981 we have been developing the Digital Twin, which is the most complete technological tool to optimize all types of Companies, Cities and Countries. kzbin.info/www/bejne/m5LHkoSfgcR0gZI kzbin.info/www/bejne/nInPoWeHgcmKh9U
@roldanduarteholguin7102
@roldanduarteholguin7102 4 ай бұрын
Export the Azure, Chat GPT, Revit, Plant 3D, Civil 3D, Inventor, ENGI file of the Building or Refinery to Excel, prepare Budget 1 and export it to COBRA. Prepare Budget 2 and export it to Microsoft Project. Solve the problems of Overallocated Resources, Planning Problems, prepare the Budget 3 with which the construction of the Building or the Refinery is going to be quoted.
@roldanduarteholguin7102
@roldanduarteholguin7102 4 ай бұрын
We want to share with Companies, Universities and Governments 57 years of successful professional experience in several countries, in Oil and Gas, Petrochemical, Steel, Hydroelectric, Engineering and Construction Projects. Since 1981 we have been developing the Digital Twin, which is the most complete technological tool to optimize all types of Companies, Cities and Countries. kzbin.info/www/bejne/m5LHkoSfgcR0gZI kzbin.info/www/bejne/nInPoWeHgcmKh9U
@roldanduarteholguin7102
@roldanduarteholguin7102 4 ай бұрын
Export the Azure, Chat GPT, Revit, Plant 3D, Civil 3D, Inventor, ENGI file of the Building or Refinery to Excel, prepare Budget 1 and export it to COBRA. Prepare Budget 2 and export it to Microsoft Project. Solve the problems of Overallocated Resources, Planning Problems, prepare the Budget 3 with which the construction of the Building or the Refinery is going to be quoted.
@schedulingschedules
@schedulingschedules 5 ай бұрын
When is this coming out?
@StructuredSolutionsInc
@StructuredSolutionsInc 4 ай бұрын
It's out now!
@leahmarnold
@leahmarnold 5 ай бұрын
This is awesome!
@Chrisgomez93
@Chrisgomez93 5 ай бұрын
Great ! Before and after files can be recorded and make quick updates to the live file when the BCR is approved !
@dandanahy8841
@dandanahy8841 6 ай бұрын
Great video - I use "Mark On Track" 100% of the time, after making the other necessary adjustments, as it makes doing updates so easy. I have never used the Remaining Duration field and honestly don't see any advantage in using it over the Duration Field. Maybe I missed something? I have PMs tell me all the time that they believe that a task is, for example, 60% complete. I apply Mark on Track and, in most cases the calculated % Complete ends up being +/- 10% of their guess. By the time the following week rolls around the PM is once again taking a guess and it's all very close. Thanks for the video.
@Chrisgomez93
@Chrisgomez93 6 ай бұрын
Great video! Any video that explains the change to remaining work when you mark on track? I have schedulers who don’t understand the importance of marking on track and how that affects remainingresource export
@craigkaragitz8244
@craigkaragitz8244 7 ай бұрын
Hi Kenny - I frequently use the "Status" column in MSP. The way you updated the status of the tasks, in the Status column it shows that Task A, which is going to finish after the original projected finish date, is "on Schedule" when really the task is "Late". Is there a proper way to Update a task and have it show "Late" in the Status column? Thanks!
@StructuredSolutionsInc
@StructuredSolutionsInc 5 ай бұрын
Hi! the Status column is automatically calculated by MS Project, so you cannot change it. You can however create your own "Status" column using a custom Text field and a formula to have it show whatever you want.
@garymailer6765
@garymailer6765 7 ай бұрын
Kenny, really insightful - thanks 😀
@Shgharavi
@Shgharavi 7 ай бұрын
completely practical
@user-wb6rx1fr9y
@user-wb6rx1fr9y 8 ай бұрын
Excellent explanation. I am having a contractor argue with me that he don't have to update the status date and questioning why he has to. I am going to send him this link so he can hear it from the MASTER. Thank you Kenny!
@StructuredSolutionsInc
@StructuredSolutionsInc 7 ай бұрын
Glad you found the video useful!
@zarkosrzic86
@zarkosrzic86 8 ай бұрын
Great insight in tasks progress. Percentage complete is actually time based value.
@trevorrabey736
@trevorrabey736 8 ай бұрын
Kenny, I love your videos and I especially like your example at 10:36 where the guys say "no, no, no" when asked if they think we should extend the remaining duration and the finish date. Of course they don't want to. They know that task has successors and they know that extending the planned finish will have consequences, so they pretend it is not going to happen. But whether they choose to plan for it or not, it will happen. I would not ask for a forecast finish date, but rather a remaining duration. "but it is the same thing" I hear you say. Well, when we first planned the project we did not estimate dates and we did not ask people to estimate dates. We estimated durations, which is remaining duration entirely if there is no actual, and we let the combination of durations and predecessors determine the dates. Same thing applies part way through the project at any given status date, where the update includes both re-planning and re-scheduling. So I would not ask for dates and even reluctant to ask for remaining duration. Rather, if you have a 50 and 60 that implies, by default, that the remaining duration should be 3 days, not 2, unless someone can give a good reason why not. And not just something like, "well, we did not work very hard for 3 days but we intend to work harder for the next 2 days". The model is trying to tell you something. If you ignore it then in 2 days at the next status date the task will not be actually finished, and the remaining duration will be 1 day.
@stephendevaux9084
@stephendevaux9084 8 ай бұрын
Very nice! An especially good job of explaining the benefits of using critical path drag to identify the best places to go to compress a project schedule. Nice job!
@osmanreddy1
@osmanreddy1 9 ай бұрын
Thank you for yhe explanation . Can you show how to use these two fields physical % vs % complete in burndown chart?
@jorgeorozco5634
@jorgeorozco5634 10 ай бұрын
Awsome Video, i think is the only one in all youtube that explain very well this, i would like to know how should be properly updated once we ad som Work mhrs. caouse seems work and % complete are related even when what i want is to relate Work% Complete with Physical % Complete
@StructuredSolutionsInc
@StructuredSolutionsInc 5 ай бұрын
I will cover statusing tasks that have resource assignments in a future video!
@Eleven2410
@Eleven2410 10 ай бұрын
I don't quite understand how can I keep track of late tasks. Example: today is 1 Jan 2024. The task was supposed to finish on 25 Dec 2023. But it's delayed and will only be completed on 7 Jan 2024. According to your guide, I'd have to adjust the remaining duration, so the new value of the Finish field would be 7 Jan 2024. So, this task is a late task, but MS Project won't highlight this task to me as a late task simply because the updated finish task is in the future. Is there any way around this? Thank you!
@StructuredSolutionsInc
@StructuredSolutionsInc 10 ай бұрын
Hi @Eleven2410. You can keep track of late tasks by making sure you set a baseline on your tasks before you start to status them. When you set a baseline on a task, MS Project will store the originally planned start and finish dates in the Baseline Start and Baseline Finish fields. Once you start statusing tasks, you can see how far off from the baseline dates your tasks have moved by looking at the Start Variance or Finish Variance fields. Hope this answers your question.
@trevorrabey736
@trevorrabey736 8 ай бұрын
If you have task that has an actual start date and some actual duration in the past, and its scheduled finish is 25/12/2023, and you are told that the best estimate now is 07/01/2024, what choice do you have but to increase the remaining duration? You are calling this task "late" simply because you now forecast a finish which is later than the original. If you don't have a baseline, then MSP just forgets about the original 25/12/2023. You only need a baseline if you want to fret about the variance. You can still happily plan and re-plan without it.
@GuillermoTempo
@GuillermoTempo 11 ай бұрын
This is great instruction. Thanks for putting this together.
@darrinkinney2268
@darrinkinney2268 11 ай бұрын
The actual people doing the work and know the dates, should be the actual people updating the schedule. This is a critical failure in the planning world. That being said, kinda cool to watch this. Seeing updates to MSP where people are clueless about the status date is hilarious. Might want to check out your other videos.
@trevorrabey736
@trevorrabey736 8 ай бұрын
I don't know whether you are saying that the people who do the work should update the schedule because they "know" the dates, or should not do it because they don't know how. They don't really know the dates, and they should not be asked for dates. If you already know the dates, you don't need the software. Finding out what the dates are is what CPM is for.
@GeromeVanWyk
@GeromeVanWyk Жыл бұрын
what happens if your actual start and baseline start are different - if you make mark on track will it not affect the actual start to align with the baseline start?
@StructuredSolutionsInc
@StructuredSolutionsInc 5 ай бұрын
No, mark on track does not align the Actual Start date with the Baseline Start. It just adjusts the percent complete (actual duration) of the task relative to the current start and project status date.
@tsegayegirma189
@tsegayegirma189 Жыл бұрын
Thank you for your wonderful demonstration. however, there is no SSI analysis tools in my ribbon. Any help?
@WaterCupBoi
@WaterCupBoi Жыл бұрын
My malware software blocks your website, you have malware on it. I want to use your ssi tools, but I am unwilling to jeperdise my computer.
@garryrogers6699
@garryrogers6699 Жыл бұрын
I would also use a baseline before making any changes to the status so that forecast and actuals can be retained for retrospective analysis. Perhaps this should have been covered. Otherwise, this is a very useful and informative video - many thanks.
@StructuredSolutionsInc
@StructuredSolutionsInc 7 ай бұрын
Yes, I agree! I considered discussing the baseline out of scope for this video, but yes, in general a baseline should be set on the project at the very beginning before any official reporting cycles begin.
@Smoke_C
@Smoke_C Жыл бұрын
Another way to consider is to follow the following sequence (assuming tasks are set to Fixed Work): 1. Enter Actual start, 2. Enter Actual Work, 3. Enter remaining work (enter zero if it is complete), 4. Enter Actual finish. Also, make sure to use the calculation options (Options-Advanced): Move end of completed parts ... and Move start of remaining parts. This will ensure that no incomplete work is left in the past (before the status date). Using work makes it a lot easier to reflect a true completion % because at the end of the day, when human beings are working, effort measured in time is the critical factor.
@rawahasan6707
@rawahasan6707 Жыл бұрын
I've been using MS projects in the wrong way; you really opened my eyes.
@amoghkhadke
@amoghkhadke Жыл бұрын
What about tasks which were expected to start before status date but haven’t started yet. How do I get projected completion date of that task. Is there any way apart from rescheduling uncompleted work after status date.??
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
Ask the person who is responsible for the task when they think it's going to start and when they think it's going to finish.
@trevorrabey736
@trevorrabey736 8 ай бұрын
"Is there any way apart from rescheduling uncompleted work after status date.??" What else would make sense? In CPM tasks are scheduled to start asap. A planned start earlier than the status date is not possible. Immediately after the status date is asap.
@paulfares6994
@paulfares6994 Жыл бұрын
The best video i have seen to date explaining this process!! Thank you :)
@anialikaj878
@anialikaj878 Жыл бұрын
Thank You for your detail explanation. I have questions regarding summary % in your example was 0.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
Hi Ani, the summary "% Complete" is automatically calculated by MS Project based on how many days of actual duration are on the child tasks under the summary. Physical % Complete is a manually entered number, even on summary tasks. I would not recommend worrying about the % Complete or Physical % Complete on summaries because summaries are just an abstract rollup of a collection of tasks. We do not status them, just the tasks under them.
@albatraoz5360
@albatraoz5360 Жыл бұрын
I have some feedback. 1) Although you can see the Assessment Counts and and Optional Additional Audits in the little side window, when you Export Results, they don't appear in the export. 2) In the previous version, new tabs would be created for each of the 14 points even if the result was zero. New version does not do that, however my customer is used to seeing it. 3) The export used to include float data such as, Float<0, Float=0, Float 0-22, Float 23-44, Float>44. I don't see that anywhere and I need that data for another customer deliverable. 4) In the little side window, when you have several options expanded such as the Assessment Count, Optional Additional Audits and Options, you can't see everything and there is no scroll bar. You have to collapse everything to see the different sections.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
Thanks for your feedback. You are welcome to continue using the old version of the 14 Point Assessment. In a future update, we will be including what you listed in #1 and #3.
@albatraoz5360
@albatraoz5360 Жыл бұрын
@@StructuredSolutionsInc How can I use the old version? I didn't see a way to revert back to the last update.
@thewarmth2
@thewarmth2 Жыл бұрын
So, all the percentages you get from the person in charge of the task should go into the “physical % complete? Also, I imagine that changing task relationships just to get rid of the “out of sequence” condition should be made after an analysis, not just changing for the sake of solving the “out of sequence” condition.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
You NEVER want to enter a number in the regular % Complete column. let MS Project calculation that for you by using the "mark on track" button after you update the start/finish dates for the task. Sure, you could wait to resolve the out of sequence issues after you statused all the tasks. It's in the video because many people don't know what it means for something to be out of sequence, let alone how to fix it. Out of sequence issues are very likely to arise when you start taking status on the schedule.
@trevorrabey736
@trevorrabey736 8 ай бұрын
Be very wary of asking questions where the answer could be a % (of anything, whatever), and wary of any answer in %. It is pretty much useless and uninformative. Example, if you have a task to lay 10000 bricks, and it has some planned duration, and it already actually started on some date in the past, and has been in progress for some days, and some number of bricks are laid, and some remain, so that as well as remaining bricks there is also some remaining duration, remaining work and remaining cost, then hearing someone say that the task is some % complete does not get you anywhere, and is not "data" that you can use. On the other hand, if you ask the right questions in the right order, and only accept proper answers to those questions, it all works. Has the task actually started? Answer is yes or no. When did it start? Answer is a date/time? How many days of actual duration? Answer is a number. How many days of remaining duration? Answer is a number. No % required.
@trevorrabey736
@trevorrabey736 Жыл бұрын
At the end, you still have a SNET date constraint on c. Even though the person has an "intended" start date, the task should still be scheduled asap. Why? Because that's basic CPM, and it doesn't work if there are date constraints in the network. We don't input dates when the project is first planned, and we shouldn't start doing it after we start tracking progress.
@kennyarnold6848
@kennyarnold6848 Жыл бұрын
No, we really shouldn’t ignore reality just because of the CPM. If we know for a fact that task C isn’t going start right after task B then we shouldn’t leave it in the schedule that way.
@trevorrabey736
@trevorrabey736 Жыл бұрын
Once task c has an actual start date, its predecessors are irrelevant. There is no need to make the dummy FS link from A to replace the FS link from B to c which was obviously wrong.
@kennyarnold6848
@kennyarnold6848 Жыл бұрын
Would still probably be good to know what tasks were necessary predecessors to the task.
@michaelbreuker4170
@michaelbreuker4170 Жыл бұрын
I see so many Master Schedulers, with 20 - 30 years of experience, updating task status using % Complete, and it is a huge pet peeve of mine. Of course these very experienced schedulers understand how to fix the issues caused by doing this, but it perpetuates a bad practice that junior schedulers then pick up.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
I see it done all the time! People need to be taught the correct way.
@michaeldoherty7434
@michaeldoherty7434 Жыл бұрын
Very well explained and this should be basic training for PMs or schedulers.
@trevorrabey736
@trevorrabey736 Жыл бұрын
You did not take any account of the Physical % Complete, ie 60% Physical % Complete, except to type it in. It implies that % Complete should equal Physical % Complete. We need a new duration and new remaining duration. New Duration = 12/0.6 = 20 days, New remaining duration = 20 - 12 = 8 Days.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
This isn't necessarily true. The Physical % Complete and the Duration Based % Complete do not need to be the same value and are often different in real world projects. Take this scenario for example: Imagine a 10 day task where the status date is at the end of the 5th day. The Duration Based % Complete will be 50% but perhaps the task manager states the physical % complete is only 25%. But they assure me they want to keep the current finish date where it is. How can this make sense? Well, consider this - maybe the task manager only spent 2 hours working on that task for the first 5 days but then plans to spend 6 hours each day working on the task for the next 5 days and therefore believes they can finish the task by the current finish date without moving it. In this case, it makes sense that the Physical % Complete of the task is only 25% but the duration based % complete is 50%.
@michaelbreuker4170
@michaelbreuker4170 Жыл бұрын
@@StructuredSolutionsInc well stated. This is what we teach at the College of Performance Management (CPM). Use the Physical Percent Complete as a sanity check, and if the physical and duration % complete differ by a significant amount, use that to challenge the task owner (CAM, Work Package Lead, key resource. . . whoever is providing the information to the scheduler) and ask why they different. But the finish date / remaining duration must be independently estimated. And, of course, use Physical % Complete for earned value calculations if the schedule is being used for EV.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
@@michaelbreuker4170 I agree 100%!
@trevorrabey736
@trevorrabey736 8 ай бұрын
@@StructuredSolutionsInc I am not saying that physical %complete should always be the same as % complete, only that it usually is or should be. Let's skip the percentages and try some numbers. The task was to lay 10000 bricks. After 5 days of actual duration, it is hoped that 5000 bricks are laid, but sadly it is only 2500. All of the evidence of progress that we have at this point says that 7500 bricks cannot and will not get laid in the remaining 5 days. Pretending otherwise is just denial. However, as you say, someone may think that the first 5 days went different to how the remaining 5 days will go, and the forecast finish date is still the same as it was before any (and not enough bricks) were laid. He believes he can finish the task by the current scheduled finish date. Yeah, right. We should base our project plan on data such as numbers and arithmetic rather than belief. A belief is not the same as an estimate. In your example, you introduced the actual work and the remaining work, which is the information needed for physical %complete to not be the same as % complete. Well, that changes things a bit. The actual 10 hours should be logged on the days it occurred and the estimate of the remaining work should be distributed over the remaining duration. We don't know what the planned work was at the start, but at this point, at this status date, we know the actual work is 10 hours and the remaining work is 30 hours, spread over 5 days. Let's not kid ourselves. That guy resists re-estimating the remaining duration and the planned finish because he doesn't want to say his task is going to be late and that will delay other tasks, it's successors. It's already late, and we don't have to wait 5 days to find that out. If he insists on holding the finish date, then in 5 days we will know if he was right. If he was wrong, then we will have lost the opportunity to act on the early warning. CPM is all about early warning, timely action and avoiding surprises.
@trevorrabey736
@trevorrabey736 Жыл бұрын
There is no need to insert the extra columns/fields into the entry table. There is a tracking table which has all of those fields. Instead of asking when the task started, surely it is necessary to ask first if it has actually started?
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
Sure, you can apply the tracking table if you like, Trevor.
@nirmalmenon1049
@nirmalmenon1049 Жыл бұрын
In which version of MS projects, this assessment tool is available?
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
This assessment tool does not come out of the box with any version of MS Project. It is part of SSI Tools for Microsoft Project, a MS Project add-in that includes this assessment and many other tools to help work with MS Project.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
It works with any version of MS Project 2010 or greater
@darbybell3269
@darbybell3269 2 жыл бұрын
How do I get that tab for SSI tools? I assumed it would be in setting and under customize ribbon, but it doesn't seem to be there.
@StructuredSolutionsInc
@StructuredSolutionsInc Жыл бұрын
You would need to first purchase SSI Tools. If you need help, please reach out to us here: ssitools.com/contact/