![KRISHNA CHIDDARWAR](/img/default-banner.jpg)
- 77
- 328 786
KRISHNA CHIDDARWAR
United States
เข้าร่วมเมื่อ 24 ม.ค. 2014
Am a 28-year-old construction consultant and civil engineer who started working on transportation projects, residential projects shortly after turning 21, with projects ranging from $500 million to $2 billion. I always wondered how the big guns in the industry came up with a big financial decision, what tools, techniques & information they use before making a billion-dollar investment decision.
I’ve created this channel to share my journey, career growth, successes, failures, and experiences in the construction & finance industry and to support others who are thinking of becoming financially independent. Oh, and I'm also obsessed with Numbers. A lot. So expect to see some financial modeling uploaded to my channel. And Subscribe. Because all the cool kids are doing it.
I’ve created this channel to share my journey, career growth, successes, failures, and experiences in the construction & finance industry and to support others who are thinking of becoming financially independent. Oh, and I'm also obsessed with Numbers. A lot. So expect to see some financial modeling uploaded to my channel. And Subscribe. Because all the cool kids are doing it.
Poor drainage system and illegal permits given by Nagar Parishad had led to loss of life today.
Poor drainage system and illegal permits given by Nagar Parishad had led to loss of life today.
มุมมอง: 155
วีดีโอ
TOP 100 Construction Tips & Hacks of 2022 | Must WATCH!!
มุมมอง 435ปีที่แล้ว
TOP 100 Construction Tips & Hacks of 2022 | Must WATCH!!
3d Printing Construction Technology 2022 | Pros and Cons
มุมมอง 826ปีที่แล้ว
3d Printing Construction Technology 2022 | Pros and Cons
Best Cement for Home construction 2022 | How to save money on cement purchase - 2 Tips
มุมมอง 176ปีที่แล้ว
Best Cement for Home construction 2022 | How to save money on cement purchase - 2 Tips
Construction Estimating: How to estimate the cost of PAINTING a room per Sqft | MS Excel
มุมมอง 4.1Kปีที่แล้ว
Construction Estimating: How to estimate the cost of PAINTING a room per Sqft | MS Excel
How to calculate the volume of SAND & Aggregate in a Truck or Lory on a Construction Site | MS Excel
มุมมอง 23Kปีที่แล้ว
How to calculate the volume of SAND & Aggregate in a Truck or Lory on a Construction Site | MS Excel
Fly Ash Concrete | How using Fly Ash saves you money and gives you free strength - MUST WATCH !!
มุมมอง 1.2Kปีที่แล้ว
Fly Ash Concrete | How using Fly Ash saves you money and gives you free strength - MUST WATCH !!
Basics of Concrete Technology & Development | MUST WATCH!!!
มุมมอง 195ปีที่แล้ว
Basics of Concrete Technology & Development | MUST WATCH!!!
How to Breakdown Project into activities | Primavera P6 & Microsoft Project MSP
มุมมอง 6163 ปีที่แล้ว
How to Breakdown Project into activities | Primavera P6 & Microsoft Project MSP
Critical Path Analysis: How to get correct NEAR-CRITICAL activities in Primavera P6
มุมมอง 3.7K3 ปีที่แล้ว
Critical Path Analysis: How to get correct NEAR-CRITICAL activities in Primavera P6
Critical Path Analysis: How to obtain TRUE Critical path in Primavera P6 | Longest vs Critical Path
มุมมอง 13K3 ปีที่แล้ว
Critical Path Analysis: How to obtain TRUE Critical path in Primavera P6 | Longest vs Critical Path
How to Download and Install latest Primavera P6 | Version 19.12 | Free Trial
มุมมอง 1.9K3 ปีที่แล้ว
How to Download and Install latest Primavera P6 | Version 19.12 | Free Trial
Contract Law: Four Construction Contract Clauses that pose special challenges for contractors
มุมมอง 3.7K4 ปีที่แล้ว
Contract Law: Four Construction Contract Clauses that pose special challenges for contractors
Monte Carlo Technique: How to perform Business Simulations & Assess Projects Profitability | Excel
มุมมอง 117K4 ปีที่แล้ว
Monte Carlo Technique: How to perform Business Simulations & Assess Projects Profitability | Excel
Paperless Construction: How to go PAPERLESS?!
มุมมอง 1.1K4 ปีที่แล้ว
Paperless Construction: How to go PAPERLESS?!
Japanese construction giant to build massive DAM almost entirely with Robots
มุมมอง 1.8K4 ปีที่แล้ว
Japanese construction giant to build massive DAM almost entirely with Robots
Microsoft Excel SOLVER - How to use SOLVER to optimize or simulate scenarios | Evolutionary Engine
มุมมอง 7K4 ปีที่แล้ว
Microsoft Excel SOLVER - How to use SOLVER to optimize or simulate scenarios | Evolutionary Engine
Project Scheduling: Myths and Misconceptions | Project Management 2020
มุมมอง 5494 ปีที่แล้ว
Project Scheduling: Myths and Misconceptions | Project Management 2020
Business Finance: What is Time Value of money & How to Calculate it? | (Excel NPV & XNPV)
มุมมอง 4284 ปีที่แล้ว
Business Finance: What is Time Value of money & How to Calculate it? | (Excel NPV & XNPV)
Construction Management: The Role of Project Scheduler in Construction Industry
มุมมอง 5K4 ปีที่แล้ว
Construction Management: The Role of Project Scheduler in Construction Industry
Portfolio Management: How to Choose BEST combination of investments with Excel SOLVER
มุมมอง 1.8K4 ปีที่แล้ว
Portfolio Management: How to Choose BEST combination of investments with Excel SOLVER
Construction Management: Importance of Construction Schedules !!
มุมมอง 3.5K4 ปีที่แล้ว
Construction Management: Importance of Construction Schedules !!
Monte Carlo Simulation: Business Optimization & Financial Decision Making | Excel Modelling
มุมมอง 16K4 ปีที่แล้ว
Monte Carlo Simulation: Business Optimization & Financial Decision Making | Excel Modelling
Bank Loans: Effect of Paying Extra Principle
มุมมอง 1694 ปีที่แล้ว
Bank Loans: Effect of Paying Extra Principle
Rental Property Investing: How to Analyze Rental Property (Step-By-Step) | Real estate DCF model
มุมมอง 7434 ปีที่แล้ว
Rental Property Investing: How to Analyze Rental Property (Step-By-Step) | Real estate DCF model
Short-term Trading Strategies | Stock Market 2020
มุมมอง 1274 ปีที่แล้ว
Short-term Trading Strategies | Stock Market 2020
How to Invest with Mutual Funds | Mutual Funds for Beginners 2020
มุมมอง 1014 ปีที่แล้ว
How to Invest with Mutual Funds | Mutual Funds for Beginners 2020
Microsoft Excel SOLVER | Explained: How to use Excel SOLVER to optimize Business Plan
มุมมอง 9074 ปีที่แล้ว
Microsoft Excel SOLVER | Explained: How to use Excel SOLVER to optimize Business Plan
Hello, really appreciated to your video, but in my p6 program my float path column is blank. what should i do?
Will be very helpful for showing operations management students how to set these up in Excel. Thank you for posting this video.
volumetric weight formula for truck and sea lxbxh/5000 are same for both??
Hello, thanks for the vídeo. Very clear and objective explanation. Is it possible to hold these values and make them not to change ?
What is the volume of a 6 tyre truck
This is extremely helpful! Thank you for the great resource and sharing your knowledge! Gonna try it out tomorrow with out students in a sustainability university course to simulate some circular business models!
great video sir, very informative, i wonder if you could share a template of this spreadsheet to me? thankyou
Very clearly explained 😊
Great Video, thanks. I'll be a loyal follower
Excellent video.
Hi. I am trying to create a data table like the one you showed by putting row argument as $C$2 and column argument as $E$12, but it is giving error. Could you explain why?
Great video. Could you explain the logic behind 'Data Table' function @ 3:37 onwards?
I just want to know, why crystal ball doesn't support double definition of assumption?
Excellent explanation, Thank you!
May I ask the procedure on how to calculate the loaded qtty in a barge with dimensions L 150m W 35m D 4.5m. Appreciated your kind assistance.
Thanks a lot for this video I had my Financial Modelling exam the next day and I was able to understand and execute this, I understood the concept thanks to your simple and effective explanation
Glad to know that this helped you
All up[JAD⁹⁹⁹⁹⁹XJAD⁹⁹⁹⁹XJAD⁹⁹⁹⁹X99999999⁹⁹⁹⁹XUP⁹⁹⁹⁹⁹XCOS99999⁹⁹⁹⁹XTG9999⁹⁹⁹XCTG99999⁹⁹⁹⁹XSIN9999999⁹⁹⁹⁹XUP⁹⁹⁹⁹XJAD⁹⁹⁹⁹⁹XGOLD TON⁹⁹⁹⁹⁹⁹XUP⁹⁹⁹X9999⁹⁹⁹XJAD⁹⁹⁹⁹]⁹⁹⁹⁹⁹⁹99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x99999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹x123456789⁹⁹⁹⁹⁹⁹⁹x555555555⁹⁹⁹⁹x77777777⁹⁹⁹⁹x3333333⁹⁹⁹⁹ FS up⁹⁹⁹⁹⁹⁹⁹ Relate⁹⁹⁹⁹⁹ 999999999⁹⁹⁹⁹ (MagicxGoldxSpellxCaduxMagiyaxCrystalxDiamond)⁹⁹⁹⁹⁹⁹⁹⁹ 9999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x88888888999999333322111666557777⁹⁹⁹⁹⁹ FS up⁹⁹⁹⁹.+9999999999⁹⁹⁹⁹x999999999999999999999999999999⁹⁹⁹⁹⁹x999999999999999999⁹⁹⁹⁹⁹x9999999999999999⁹⁹⁹⁹x99999999999⁹⁹⁹⁹⁹ fs up⁹⁹⁹⁹⁹⁹⁹⁹⁹😊[JAD⁹⁹⁹⁹⁹XJAD⁹⁹⁹⁹XJAD⁹⁹⁹⁹X99999999⁹⁹⁹⁹XUP⁹⁹⁹⁹⁹XCOS99999⁹⁹⁹⁹XTG9999⁹⁹⁹XCTG99999⁹⁹⁹⁹XSIN9999999⁹⁹⁹⁹XUP⁹⁹⁹⁹XJAD⁹⁹⁹⁹⁹XGOLD TON⁹⁹⁹⁹⁹⁹XUP⁹⁹⁹X9999⁹⁹⁹XJAD⁹⁹⁹⁹]⁹⁹⁹⁹⁹⁹99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x99999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹x123456789⁹⁹⁹⁹⁹⁹⁹x555555555⁹⁹⁹⁹x77777777⁹⁹⁹⁹x3333333⁹⁹⁹⁹ FS up⁹⁹⁹⁹⁹⁹⁹ Relate⁹⁹⁹⁹⁹ 999999999⁹⁹⁹⁹ (MagicxGoldxSpellxCaduxMagiyaxCrystalxDiamond)⁹⁹⁹⁹⁹⁹⁹⁹ 9999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x88888888999999333322111666557777⁹⁹⁹⁹⁹ FS up⁹⁹⁹⁹.+9999999999⁹⁹⁹⁹x999999999999999999999999999999⁹⁹⁹⁹⁹x999999999999999999⁹⁹⁹⁹⁹x9999999999999999⁹⁹⁹⁹x99999999999⁹⁹⁹⁹⁹ fs up⁹⁹⁹⁹⁹⁹⁹⁹⁹😊99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x99999999999999999999999999999999999999999999999999⁹⁹⁹⁹⁹⁹⁹⁹x123456789⁹⁹⁹⁹⁹⁹⁹x555555555⁹⁹⁹⁹x77777777⁹⁹⁹⁹x3333333⁹⁹⁹⁹ FS up⁹⁹⁹⁹⁹⁹⁹ Relate⁹⁹⁹⁹⁹ 999999999⁹⁹⁹⁹ (MagicxGoldxSpellxCaduxMagiyaxCrystalxDiamond)⁹⁹⁹⁹⁹⁹⁹⁹ 9999999999999999⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹⁹x88888888999999333322111666557777⁹⁹⁹⁹⁹ FS up⁹⁹⁹⁹.+9999999999⁹⁹⁹⁹x999999999999999999999999999999⁹⁹⁹⁹⁹x999999999999999999⁹⁹⁹⁹⁹x9999999999999999⁹⁹⁹⁹x99999999999⁹⁹⁹⁹⁹ fs up⁹⁹⁹⁹⁹⁹⁹⁹⁹😊
Great information here. Thank you sir.
Thanks for this video. dear i've a query. if a project is in -90days of total float and total activates are more then 1000, then there will be many activates which causes -ve float of project. 1st: how can i get the total list of activities which causes -ve float? 2nd: how can i get the major activity out of 1000 which cause -ve float.
Answer to first question: there is a simple filter which will give you the list of activities with negative float. Second Answer: sorting out the activities will give you the tasks with maximum float. More sophisticated way to do it is create alternate float lines
2:32 WHY MY FORMULA IS NOT WORKING? IT IS SHOWING (NAME?)
Make a video on concurrent delay
Your videros are very good and helpful
I have come across a research paper in which they have developed regression models using past data (uptil 2016). The pdfs of variables were already known from literature review. For 2017 onwards, they utilized the forecasted values as the mean of the distribution and took 10% of that mean as standard deviation for each year, and performed MCS to calculate annual uncertainty. Is there any relation or basis for taking 10% of mean as SD for future uncertainty analysis? I have analyzed the past data as well SD is nowhere near 10% of the mean value.
Sir, can you please share this excel sheet to me.
'promosm'
Very good modeling.
Nice job, man!
Thanks
This small and lucid video is worth a big book on the subject. Thanks 🙏
Appreciate your comment @RavindraMulye
Very helpful vedio to explain Mante Carlo Analysis. Great job you've done.
Also how do you show the trend over a period of time like a monthly trend or annual trend using a chart
i think I got the answer for this, so ur simulations are considered based on monthly performance
How did you decide the standard deviation ?
As I said in the video, you would have to gather a large sample set and see the pattern for yourself, then select that in your projection
How can you check if there is normal distribution?
You would see it in the histogram, if you are or aren’t getting the bell shape curve
Krishna, thank you so much for your comprehensive guide - this is perfectly explained, I appreciate you a lot!
Thanks!! I have few more Monte Carlo videos
@@krishnachiddarwar505 I'll be sure to check them:)
@@krishnachiddarwar505 one more thing - I realized there potentially should be added one final step, when calculating probability of net profit. We should eliminate outliers from simulated data to calculate probability more reliably. I'd use countifs function to exclude any data points beyond +3 and -3 standard deviations from the mean. :)
That’s very sad 😢
Yes
simple truth is that the mean is equal to net profit since std deviations does not have an impact as number of iteration increases
Ye
👍👍👍
sorry stupid question: how do you determine the standard deviation for the variable at the top
Thank you, nice! Interesting: I get 8,6% Profit while you get 86, something...
I like Technology
wow The way you have presented the sheet is easy despite i need to dig in more about the monte carlo. thanks a lot. i am grateful to your sharing knowledge. Do you have something related to project cost to anticipate the budget?
Yes I do
Simple and helpul; thanks
Thanks
Good one!
Extremely helpful, thanks
Thanks you so much, very helpful
Thanks
Thank you sir, I am in urgent need of a M.C simulation video.
SIR COUNTIF FORMULA CELL & FIRST SIMULATION CAN"T BE SELECTED TOGETHER SO HOW O.OO % COME ?
Will get back to you
Thank you so much wish you the best
Glad you found it useful
is all contents in old version already include in digital age version? or some content different between each other?
Slightly different
Clear explanation, Thank you for this video!
You’re welcome!!
Hindi m smjhate to jada smjh aata
I understand, kuch specific question hai toh yaha puch lo, will try to answer it