I knew the mathematical concept. Only I didn't know the exact formulas in Excel! Thanks! A useful thing world be to lock all the cells other than the input cells and save with a simple password, so that the formulae are not affected.
Dear sir, Thank you for your video, I can able to solve the 3 unknown equation for radiation heat exchange for three gray surfaces. Thank you so much :-)
Sir please help me with this that if "b" is a zero matrix then how will we solve the equation as i am unable to do so. My all the variable values are coming 0 which isnt the answer
Very useful tutorial. Big thanks to you from Kuwait. By the way i love your accent. I’ve heard it a lot in movies but i do not know where its origin. I would love to know please :D
Hi Steve. What do you do if your 3 equations are something like r^2 = (5 - X)^2 + (3 - Y)^2 (circle equations)? Excel will not take "(5-X)^2" as parameter in the MINVERSE matrix. How do you solve something like this? 🙂
just imagine how messy the world would be without this kind of people who make this kind of videos.. thanks... alot!
You’re welcome.
thanks very much steve. you make things a lot simpler than my chinese lecturer who goes too fast and also who i have trouble understanding him anyway
You’re welcome. Glad it helped.
Mate your teaching skills are elite...didn't understand the lecturer but you made it so easy! Thank you 👏🏿👏🏿👏🏿👏🏿👏🏿
Thank you.
thank you so much for this. you explained it so coherently and simply.
Thank you
Thank you so much for this video! Your teaching skills are superb.
Thank you.
I'm glad you posted this video , I learned to much things on it , thanks
You’re welcome. Glad it helped.
Very helpful for my brother's lesson! Thank you very much! :)
You’re welcome. Glad it helped.
Great tutorial.
Thanks from Brazil
Thank you. Glad the video helped.
I was manually selecting each cell to calcuate each matrix. Didn't know there was a function for matrix. Thanks alot for your help
You’re welcome. Glad it helped.
Omg, there is so useful information on that video, thank you so much
You’re welcome. Glad it helped.
Nice explanation of the concept and method, thank you so much for your time and effort.
You’re welcome. Thank you for the comment.
Thanks so much!! very useful...keep doing your videos!!
Thank you. Glad it helped.
Great job 👍 please a video on how to use Excel to solve lpps simplex method
Thank you.
Awesome, I'm new to excel and this is a great solution that can be generalized to many problems!!
Thank you. Glad it helped.
Great video. Thanks
Thank you.
I knew the mathematical concept. Only I didn't know the exact formulas in Excel! Thanks!
A useful thing world be to lock all the cells other than the input cells and save with a simple password, so that the formulae are not affected.
Great tutorial
Thank you.
Dear sir, Thank you for your video, I can able to solve the 3 unknown equation for radiation heat exchange for three gray surfaces. Thank you so much :-)
You’re welcome. Glad it helped.
Thank you! This was very helpful ^^
You’re welcome. Glad it helped.
Sir please help me with this that if "b" is a zero matrix then how will we solve the equation as i am unable to do so. My all the variable values are coming 0 which isnt the answer
Very useful tutorial. Big thanks to you from Kuwait. By the way i love your accent. I’ve heard it a lot in movies but i do not know where its origin. I would love to know please :D
Thank you. Glad it helped. Southern United States.
Hi Steve. What do you do if your 3 equations are something like r^2 = (5 - X)^2 + (3 - Y)^2 (circle equations)? Excel will not take "(5-X)^2" as parameter in the MINVERSE matrix. How do you solve something like this? 🙂
Very nice
It helped me much
Thank you. Glad it helped.
I know this video is older, but what about free variables, how can i find them using excel?
Life saver👍🏾
Glad it helped.
i got error saying "you´ve entered too many arguments for this function"?
What if there are an infinite number of solutions?
How can I calculate the inverse of an overdetermined system of equations? m > n
It has to be a square matrix. m=n
thank you soo muchh sir you really help me with this video
You’re welcome. Glad it helped.
Hi.. I did the minverse formula however I got a NUM error. Even though I used the same numbers you did. Would you know why I'm getting this error?
Did you hit Ctrl Shift Enter
Oh, so I just put it into Linear ABCD form?
Hi. Your video is very helpful. But may I know why the answer calculated using calculator is different from in excel?
They should be the same.
Cool accent, luv it
Thank you.
Thank you very much
You’re welcome.
can "named" array be used
I haven’t tried it but I would say yes.
I'll give it a try soon and let you know
nice
dont you need to find DETERMINANT too?
Not if you solve using the inverse. Only Cramers Rule.
what if the determinant of A = 0?
Then you either have no solution or infinite solutions.
I fucking love you Thank you for this video!
You’re welcome.
tnx
You’re welcome. Glad it helped.
Did not work for me.