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 :-)
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
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.
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? 🙂
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
just imagine how messy the world would be without this kind of people who make this kind of videos.. thanks... alot!
You’re welcome.
Mate your teaching skills are elite...didn't understand the lecturer but you made it so easy! Thank you 👏🏿👏🏿👏🏿👏🏿👏🏿
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.
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.
thank you so much for this. you explained it so coherently and simply.
Thank you
Great tutorial.
Thanks from Brazil
Thank you. Glad the video helped.
Thank you so much for this video! Your teaching skills are superb.
Thank you.
Omg, there is so useful information on that video, thank you so much
You’re welcome. Glad it 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.
Thanks so much!! very useful...keep doing your videos!!
Thank you. 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.
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.
Great tutorial
Thank you.
Thank you! This was very helpful ^^
You’re welcome. Glad it helped.
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.
Very nice
It helped me much
Thank you. Glad it helped.
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.
Life saver👍🏾
Glad it helped.
thank you soo muchh sir you really help me with this video
You’re welcome. Glad it helped.
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.
Cool accent, luv it
Thank you.
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? 🙂
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
How can I calculate the inverse of an overdetermined system of equations? m > n
It has to be a square matrix. m=n
I know this video is older, but what about free variables, how can i find them using excel?
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.
Thank you very much
You’re welcome.
i got error saying "you´ve entered too many arguments for this function"?
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
What if there are an infinite number of solutions?
Oh, so I just put it into Linear ABCD form?
nice
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
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.