MisterBill2
- Joined Jan 23, 2018
- 28,059
This still seems to be a class exercise.
While I haven't been giving this much thought, a "V-Lookup" function in Excel MIGHT solve the problem. You input each of the points you want to calculate - - - no - - - wait - - - OK, forget I mentioned it. If somewhere in the middle of the grid, imagine points AA - AB for instance, the entire grid MUST be calculated in. I don't see a solution. For AA & AB "ALL" other resistors continue to influence the resistance of AA - AB. It's doable with four points but with thousands of points - it'll take a math whiz to even begin to suggest a solution.Only thing I can think of as an approach would be a spread sheet. But I haven't a clue how to construct it.
Of course it's solvable. Given enough time, you can solve it by hand. You just need to devise an algorithm to automate the process.While I haven't been giving this much thought, a "V-Lookup" function in Excel MIGHT solve the problem. You input each of the points you want to calculate - - - no - - - wait - - - OK, forget I mentioned it. If somewhere in the middle of the grid, imagine points AA - AB for instance, the entire grid MUST be calculated in. I don't see a solution. For AA & AB "ALL" other resistors continue to influence the resistance of AA - AB. It's doable with four points but with thousands of points - it'll take a math whiz to even begin to suggest a solution.
My advice, forget about this problem. It's, as far as I can tell, unsolvable.
Possibly. The TS has stated that it isn't, but such claims are not always above board.This still seems to be a class exercise.
First form the admittance matrix for your network. Then do some linear algebra.Thanks all for your valuable feedbacks. I guess I will have to use some kind of simulation software (i dont know which one yet) that would make a giant network of resistors with 10000 nodes. Then, I would apply voltage across any 2 nodes and find current and thus find effective resistance.
I am however trying to figure out how can I make this process automated so that I could find effective resistance between every 2 nodes possible without doing manually.
See the references in this article: https://en.wikipedia.org/wiki/Resistance_distanceAnd I am wondering what sort of real world application this would apply to.
Just because someone is a student doesn't mean that everything they do is related to an assignment -- good students spent more time pondering and solving problems that are not assigned than they do ones that are.Consider that the TS is identified as a student. Of course this could be a MENSA exercise, I understand that occasionally they solve non-solvable equations just for fun, much like I occasionally repair non-repairable devices just for kicks. Some folks assemble difficult "Jigsaw" puzzles, which is strictly for their entertainment.
The resistors don't have to be all one value. The matrix of resistance values has the same dimensions as the admittance matrix. Once you have the pseudoinverse, you then build the final matrix by doing some arithmetic with 4 values from the pseudoinverse for each value in the final matrix.@The Electrician . Also, will this method work because all my resistors do not have same resistance value, which was the case in the worked example you shared.
I am sorry if I am not understanding it properly . I have limited knowledge in electric circuits.
Thank you for your patience !
This method works for any number of nodes as long as you have capability for the necessary number crunching.I actually managed to get it worked for a 4 node network. I am very hopeful that this will also work for 10000 node circuit as well. Thank you very much @The Electrician . Great help indeed . However I wanna know more about it , i mean i wanna know how does it work. Is there any article explaining it?
R is a programming language usually used for statistics computations. Your 10000x10000 matrix will have 100 million elements. I wonder if some other app such as MATLAB, which is especially good for linear algebra math might be better able to handle your problem. I would think most educational institutions would have MATLAB available on their network for student use.I'm using R to do it. Its for my course project where i am analyzing a huge network with edges.. im planning to use effective conductance as a measure of how connected two nodes are.
Is this a standard technique (using effective conductance)? Does your instructor know how to solve your problem, but didn't tell you how because they wanted you to research it for yourself?I'm using R to do it. Its for my course project where i am analyzing a huge network with edges.. im planning to use effective conductance as a measure of how connected two nodes are.
Are you thinking of this problem: https://physics.stackexchange.com/q...-of-resistors-whats-the-equivalent-resistanceWhat I find now that is interesting is that this is far from a new challenge. The first time I saw this question posed was in a Q and A section of an electronics magazine back in about 1964, while I was in High School. It has been repeated many times since then. In one college class years later one instructor showed that the solution could exist as an infinite series, if the network extended that far. At that point the instructor also showed that there would not be an exact solution to an infinite series. That is a valid conclusion, based on a rational evaluation.
Thus the answer depends on how close you need to be to exact.