KRISHNA CHIDDARWAR
KRISHNA CHIDDARWAR
  • 77
  • 328 786

วีดีโอ

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!!!
Crush Sand vs Natural Sand | Benefits
มุมมอง 4652 ปีที่แล้ว
Crush Sand vs Natural Sand | Benefits
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
The Rise of Drones in Construction
มุมมอง 9K3 ปีที่แล้ว
The Rise of Drones in Construction
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

ความคิดเห็น

  • @munkhbatnagdalsuren5238
    @munkhbatnagdalsuren5238 14 วันที่ผ่านมา

    Hello, really appreciated to your video, but in my p6 program my float path column is blank. what should i do?

  • @robertbuckham1037
    @robertbuckham1037 2 หลายเดือนก่อน

    Will be very helpful for showing operations management students how to set these up in Excel. Thank you for posting this video.

  • @rajivmittal904
    @rajivmittal904 2 หลายเดือนก่อน

    volumetric weight formula for truck and sea lxbxh/5000 are same for both??

  • @humbertosantos5946
    @humbertosantos5946 3 หลายเดือนก่อน

    Hello, thanks for the vídeo. Very clear and objective explanation. Is it possible to hold these values and make them not to change ?

  • @DAVIDOKOH-sn7xn
    @DAVIDOKOH-sn7xn 3 หลายเดือนก่อน

    What is the volume of a 6 tyre truck

  • @Kypezzz
    @Kypezzz 4 หลายเดือนก่อน

    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!

  • @arshiyakharel8561
    @arshiyakharel8561 5 หลายเดือนก่อน

    great video sir, very informative, i wonder if you could share a template of this spreadsheet to me? thankyou

  • @josie-ey3v
    @josie-ey3v 5 หลายเดือนก่อน

    Very clearly explained 😊

  • @chrisforza3659
    @chrisforza3659 6 หลายเดือนก่อน

    Great Video, thanks. I'll be a loyal follower

  • @Tommybotham
    @Tommybotham 6 หลายเดือนก่อน

    Excellent video.

  • @KomalKamran-t2g
    @KomalKamran-t2g 6 หลายเดือนก่อน

    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?

  • @MrHarpic
    @MrHarpic 6 หลายเดือนก่อน

    Great video. Could you explain the logic behind 'Data Table' function @ 3:37 onwards?

  • @frustrategirl
    @frustrategirl 6 หลายเดือนก่อน

    I just want to know, why crystal ball doesn't support double definition of assumption?

  • @nsmohammed
    @nsmohammed 6 หลายเดือนก่อน

    Excellent explanation, Thank you!

  • @emmanuelalonzo8707
    @emmanuelalonzo8707 6 หลายเดือนก่อน

    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.

  • @techtrooper7793
    @techtrooper7793 7 หลายเดือนก่อน

    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

  • @sabiyaaliyeva5990
    @sabiyaaliyeva5990 7 หลายเดือนก่อน

    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⁹⁹⁹⁹⁹⁹⁹⁹⁹😊

  • @dominicboakye8226
    @dominicboakye8226 9 หลายเดือนก่อน

    Great information here. Thank you sir.

  • @Hasshirkhanbri
    @Hasshirkhanbri 10 หลายเดือนก่อน

    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.

    • @krishnachiddarwar505
      @krishnachiddarwar505 10 หลายเดือนก่อน

      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

  • @anuragchand11
    @anuragchand11 10 หลายเดือนก่อน

    2:32 WHY MY FORMULA IS NOT WORKING? IT IS SHOWING (NAME?)

  • @shahjalal2946
    @shahjalal2946 10 หลายเดือนก่อน

    Make a video on concurrent delay

  • @shahjalal2946
    @shahjalal2946 10 หลายเดือนก่อน

    Your videros are very good and helpful

  • @hsf2047
    @hsf2047 10 หลายเดือนก่อน

    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.

  • @karunadhingra6031
    @karunadhingra6031 10 หลายเดือนก่อน

    Sir, can you please share this excel sheet to me.

  • @anderson9921
    @anderson9921 10 หลายเดือนก่อน

    'promosm'

  • @woodypham6474
    @woodypham6474 11 หลายเดือนก่อน

    Very good modeling.

  • @paulr6222
    @paulr6222 11 หลายเดือนก่อน

    Nice job, man!

  • @RavindraMulye
    @RavindraMulye 11 หลายเดือนก่อน

    This small and lucid video is worth a big book on the subject. Thanks 🙏

  • @harrisonian9213
    @harrisonian9213 ปีที่แล้ว

    Very helpful vedio to explain Mante Carlo Analysis. Great job you've done.

  • @desilvakts2071
    @desilvakts2071 ปีที่แล้ว

    Also how do you show the trend over a period of time like a monthly trend or annual trend using a chart

    • @desilvakts2071
      @desilvakts2071 ปีที่แล้ว

      i think I got the answer for this, so ur simulations are considered based on monthly performance

  • @desilvakts2071
    @desilvakts2071 ปีที่แล้ว

    How did you decide the standard deviation ?

    • @krishnachiddarwar505
      @krishnachiddarwar505 ปีที่แล้ว

      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

  • @mexifrida
    @mexifrida ปีที่แล้ว

    How can you check if there is normal distribution?

    • @krishnachiddarwar505
      @krishnachiddarwar505 ปีที่แล้ว

      You would see it in the histogram, if you are or aren’t getting the bell shape curve

  • @duszan2
    @duszan2 ปีที่แล้ว

    Krishna, thank you so much for your comprehensive guide - this is perfectly explained, I appreciate you a lot!

    • @krishnachiddarwar505
      @krishnachiddarwar505 ปีที่แล้ว

      Thanks!! I have few more Monte Carlo videos

    • @duszan2
      @duszan2 ปีที่แล้ว

      @@krishnachiddarwar505 I'll be sure to check them:)

    • @duszan2
      @duszan2 ปีที่แล้ว

      @@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. :)

  • @ajaydhamnikar2982
    @ajaydhamnikar2982 ปีที่แล้ว

    That’s very sad 😢

  • @markosiridzanski2181
    @markosiridzanski2181 ปีที่แล้ว

    simple truth is that the mean is equal to net profit since std deviations does not have an impact as number of iteration increases

  • @Enthcreations
    @Enthcreations ปีที่แล้ว

    👍👍👍

  • @whopperd
    @whopperd ปีที่แล้ว

    sorry stupid question: how do you determine the standard deviation for the variable at the top

  • @andysurvival346
    @andysurvival346 ปีที่แล้ว

    Thank you, nice! Interesting: I get 8,6% Profit while you get 86, something...

  • @mukeshbannymukeshbanny7567
    @mukeshbannymukeshbanny7567 ปีที่แล้ว

    I like Technology

  • @hussainqahtani4215
    @hussainqahtani4215 ปีที่แล้ว

    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?

  • @mdmamunsarder
    @mdmamunsarder ปีที่แล้ว

    Simple and helpul; thanks

  • @Shamansdurx
    @Shamansdurx ปีที่แล้ว

    Good one!

  • @andreazosi4097
    @andreazosi4097 ปีที่แล้ว

    Extremely helpful, thanks

  • @juanpabloarcos4597
    @juanpabloarcos4597 ปีที่แล้ว

    Thanks you so much, very helpful

  • @john.smith02
    @john.smith02 ปีที่แล้ว

    Thank you sir, I am in urgent need of a M.C simulation video.

  • @user-do1iv6uz8z
    @user-do1iv6uz8z ปีที่แล้ว

    SIR COUNTIF FORMULA CELL & FIRST SIMULATION CAN"T BE SELECTED TOGETHER SO HOW O.OO % COME ?

  • @mohammedsobuh623
    @mohammedsobuh623 ปีที่แล้ว

    Thank you so much wish you the best

  • @truthseeker3999
    @truthseeker3999 ปีที่แล้ว

    is all contents in old version already include in digital age version? or some content different between each other?

  • @havvanurusta61
    @havvanurusta61 ปีที่แล้ว

    Clear explanation, Thank you for this video!

  • @cartoons531
    @cartoons531 ปีที่แล้ว

    Hindi m smjhate to jada smjh aata

    • @krishnachiddarwar505
      @krishnachiddarwar505 ปีที่แล้ว

      I understand, kuch specific question hai toh yaha puch lo, will try to answer it