วีดีโอ

Thanks

Thank you for the clear explanation. Well appreciated 😊

Hello i need the excel file you are working with

Great Videos. Please keep it coming

Music in background is toomuch disturbing in such a serious subject

Excellent lecture!

Thankyou so much sir❤❤

Thanks you

Great, thank you.

Great content. Keep it coming please. These

Thanks for the video. These videos are top notch. Please do a series on ' ANNOVA'

I’m learning. Thank you.

sir these video are goldmine for me. I am a second year MBA student from Great Lakes Chennai and I am greatly benefitted from your videos. Just got to know that you are yourself an XLRI alum. Will share your channel with my batchmates, they will also be benefitted and hopefully you will gain some reach

Thank u sir plz tell me d book

How does one formulate this for 4 weeks and track inventory?

why i still get 0?

why i still get 0?

Thank you sir!

Awesome Video

Just saved me tonight! Thanks!

Can you kindly post a video of the safety stock calculation when the demand pattern doesn’t follow the normal distribution

Thank you! I used this video to create my own chart in my Discrete math course. You explained it in way a that was easy to follow along 💕💕💕

Sir if the company not paying any dividend how to calculate RR ? RR will be 100% ? WAITING FO UR REPLY SIR,

Thanks sir

My dear doctor, why did you put in all constraints less than or equal to 3? I did not understand this point

Excellent Sir

ClassicQuants SIr chad🔥

ClassicQuant Bhai Chad

ClassicQuants Bhai OP

Sir ,pls also explain bass diffusion model of forecasting

The Output variance seems very large??

very honestly made very good video Sir

it was really clear and understandable explanation thank you so much!

Hello, I need some help in Optimization case study, Can you help?

Well Explained. Thank you

thank you, can you please provide the excel sheet for this problem please?

Hey there, this is a great tutorial. May I ask if I want to to limit the solver to just solve 3 cities instead of 4, how can I do that?

Thank you.

Very Well explained

Please start making videos again

he is a very kind hearted man. currently i m freshers n improving my skills. i m personally helped by this channel. i just want to salute him. may god bless u.

Hello. Thank you for putting up your shortest path solution. I am trying to do something similar-but-more complex, and am having trouble, and I was wondering if you could give me some guidance. What I want to in Excel with shortest paths is: 1) layout a large m-by-n matrix of nodes, with distances in meters between them. I'll use pseudo-chess-board nomenclature with one axis being A-Z and one axis being numbered 1-n (calling nodes "A1", "C3", "F7", etc) 2) have the ability to request multiple shortest paths from (say) B3->F8, G2->A14, F2->R23, etc 3) partially congest a route based on previous paths. For example, if a route is found it may be tagged as 25% congested between two nodes. Another route may add to this. Eventually the route would be congested, and an alternative shortest path would have to be found. 4) ideally I'd like to make it iteratively optimise, but I realise that may be impossible to do in Excel, so the above congestion may have be sequentially built in Do you know of any examples where such a thing has been done? Thank you in advance, Adam

can you have the goal function being evaluated by a macro?

Too good🎉

Thank you so much for making such a complex concept so easy.

I would suggest you include comments on the "non-negative" checkbox. I think we typically take that "constraint" for granted, but of course that's not always the case. I might also suggest you explain the "INT", "BIN", and "DIF"" selections for constraint types. Really an excellent discussion. Looking forward to the rest of the video series. Thank you.

Using the SUMPRODUCT function to setup the constraints is a great idea. Really saves time.Thanks.

This is a beautiful and well thought-out way to arrange your Excel spreadsheet for a classic optimization problem. Very helpful. The way you set up the Constraints for easy entry in Solver is quite clever.

Please, could you show how to solve the MILP problem? Thanks a lot

Hello. Please help me with this problem. Consider a set of city districts 𝐼. There is a candidate for building a medical emergency service station in every city district. The cost of building an ambulance station is given by the parameter 𝑓𝑖 and the total budget for building stations throughout the city is 50 million. Furthermore, if a station is built in city district 2, it must not be station built in city district 6. Determine in which city districts to build ambulance stations so that the maximum travel time is minimized. What is the optimal maximum travel time? The cost of building stations in the city district 𝑖 ∈ 𝐼, 𝑓𝑖 are: [32,20,25,30,40,29] The city districts and the driving distances between them are interpreted in the following graph: ( [[ 0, 4, 12, 27, 25, 58], [ 4, 0, 24, 16, 29, 38], [12, 24, 0, 31, 14, 30], [27, 16, 31, 0, 21, 8], [25, 29, 14, 21, 0, 11], [58, 38, 30, 8, 11, 0]]) The right answer is to build stations in districts 2 and 4, and optimal travel time is 24. But how can I solve it with excel or with Python, please, help me.