PHY 201: Using Kirchhoff's Rules (and Excel) to Solve for the Currents in a Network of Resistors

We will now use Excel to solve this matrix equation. Open Excel and enter the matrix. I got a bit fancy and entered the resistance values and voltage value in cells B1 through B6. And then I entered the matrix entries as formulas. Notice the cell A8 is highlighted, and appearing in the formula bar is =B1+B4.

NEXT
BACK