This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations
Nice. It would be interesting to see if you could attempt to solve Guan's route problem (or the route inspection problem) where the goal is to identify the path that optimizes a route to traverse every path in a given map. I would be super interested in seeing how Excel might be able to help with that. Thanks!
This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations
Chandoo G, do you think that learning Excel, Power BI, and SQL to their full extent is sufficient to become a data scientist, or should we also consider learning other tools like Python, Matplotlib, Seaborn, and ggplot2? In short what is most important to become a more professional data scientist?
Question:: I am using Excel on MAC version 16.88 and the "@" sign is not used for arrays. And I can't get your LS or LF equations to work (without the "@" sign. I did get the ES and EF to work.
A newer Excel for MAC OSX does not use the @ sign for array names. And I can't get LS or LF to work with your questions (with out the "@' sign on the array name.
Sir as a ms Excel export please clear my doubt, copilot 365 will available in ms Excel and other ai tools, so as beginner should I learn ms Excel deeply all functions and advance formulas Or I can do all ms Excel works by using copilot and other ai tools??? What should I do
The CP calculations assume data is sorted by the order of activities and there is no circularity. So adjust that and let me know if you are still seeing wrong results.
hi. i have problem with my excel file. i am use macros and always try to make my program better and better. but for some reason start getting more memory by self and now it is impossible to work on it :/ my excel can extend even 1 Mb more when i use this file.any help please.
Please make more content on Project Management Chandoo. Loving your content.
Sure. Please watch the Project Management videos playlist here - ruclips.net/p/PLmejDGrsgFyCS0n1GEXRuzxjK9wAXFNGo
This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations
It's a lesson from universities for civil engineers and you tell it with automation in excel. Congrats and thanks for your effort.
Thank you for giving such a clear explanation of Critical Path Method and use of Excel for the same!
I'm still trying to understand Excel, and your channel is one of the channels for learning Excel.
Thank you for everything.
Very good sir. Everytime someone thinks that they know many things in Excel, you come up with new gem. Thank you for sharing this knowledge.
I just love the way of your presentation.. So comfortable with it..
This is awesome formula combination. So much brain is involved here to decode it. Thanks to article.
With this video i can memorize my ug studies, operations research classes.
Thank u
Nice. It would be interesting to see if you could attempt to solve Guan's route problem (or the route inspection problem) where the goal is to identify the path that optimizes a route to traverse every path in a given map. I would be super interested in seeing how Excel might be able to help with that. Thanks!
Awesome as always, thanks Chandoo!
This is really helpful I request you to make videos on assembly planning and line balancing how to do it in excel with 200-300 jobs going through 20-30 operations
So well explained!
THANK YOU!
IS there any video explaining how to add FF, FS, SF, SS relationships too for the above excel and also lead and lags using dates ?
This was very helpful! Is there a way to graph off of these right on the gantt?
That's very useful, Chandoo. Could you also share the conditional formatting formula?
The formula goes like this:
=$L7=0
You can see the formula and more explanation here - chandoo.org/wp/critical-path-excel-template/
@@chandoo_ great, many thanks
You're the best bro ❤❤
absolutely awsome
Hi Chandoo, make some videos on demand planning, forecasting, supply chain analytics.
Thanks
Hi. This is great! I’m just wondering if it could be done in Power Bi as well? Perhaps using some of the PATH functions? Thanks a lot
Great content
Can you make a video on how to use excel for management information system , in short what a mis executive has to do in excel
Chandoo G, do you think that learning Excel, Power BI, and SQL to their full extent is sufficient to become a data scientist, or should we also consider learning other tools like Python, Matplotlib, Seaborn, and ggplot2? In short what is most important to become a more professional data scientist?
Question:: I am using Excel on MAC version 16.88 and the "@" sign is not used for arrays. And I can't get your LS or LF equations to work (without the "@" sign. I did get the ES and EF to work.
A newer Excel for MAC OSX does not use the @ sign for array names. And I can't get LS or LF to work with your questions (with out the "@' sign on the array name.
Hi!
Great video!
However, I'm running into problems when I have more than two predecessors. I get the error message "#VALUE!".
What can I do fix this?
Sir as a ms Excel export please clear my doubt, copilot 365 will available in ms Excel and other ai tools, so as beginner should I learn ms Excel deeply all functions and advance formulas
Or I can do all ms Excel works by using copilot and other ai tools???
What should I do
First of all love thalaivar poster on the door 😂
😎
Thanks, let's do PowerPoint presentation tips
Activity 3 is on critical Path, you show 16 as LS, I calculate it as 7, giving activity 3 as on the critical path
The CP calculations assume data is sorted by the order of activities and there is no circularity. So adjust that and let me know if you are still seeing wrong results.
hi. i have problem with my excel file. i am use macros and always try to make my program better and better. but for some reason start getting more memory by self and now it is impossible to work on it :/ my excel can extend even 1 Mb more when i use this file.any help please.
Thank you sir just explain how to draw a CPM diagram in excel
what was the formula for LS? I think you did not include it huhuhu
Is it work in Excel 2007?
Hey Dear, any thought on hiring a video editor?
Sorry chandoo, I want you to help me something, can we talk please
Dad joke countdown