Making Mountains...out of potentials

 

Open Excel. Click in the block at the intersection of the row and column headings to select the entire worksheet.

 

 

By dragging on the edges of the row and column headings, adjust the worksheet so that the cells are small and square.

 

 

Click on cell A1 and enter the following formula. Keep a close eye on the parentheses. Your best bet is to select the text below, copy it, and then paste it into Excel

 

 

= charge1/SQRT((COLUMN(A1) - COLUMN(charge1))^2 + (ROW(A1) - ROW(charge1))^2)+ charge2/SQRT((COLUMN(A1) - COLUMN(charge2))^2 + (ROW(A1) - ROW(charge2))^2)

 

Now duplicate the formula in cell A1 to the rest of the cells in the first row, out to cell CZ1. The easiest way to do this is to first click on cell A1 to select it, then drag the small handle (in the lower right corner of the cell) to the right until you reach cell CZ1. The cursor changes into a thin "plus" sign when you are in the right position over the handle. Release the mouse and the formula will have been inserted into each cell.

 

 

 

 

While that row of cells (from A1 to CZ1) is selected, drag them down to cell CZ52. That will fill in a large grid with your formula.

 

 

 

 

 

Move to cell Z26 (It's hard to read the row numbers, but you can see where you are by reading the Name Box in the corner.) Replace the long formula with the single value of 3, to represent a +3 C charge. Click in the Name Box in the upper left corner of the spreadsheet and replace "Z26" with "charge1" without the quotes, of course. Notice that there is no space between the "e" and the "1". Now your formulas will refer to this particular cell.

 

 

 

 

 

While still on cell charge1 (formerly known as Z26) select Cells... from the Format menu and make the cell a bright red color. Move to cell AZ26, replace its formula with -3, to represent a negative 3 C charge. Then name the cell charge2, and make it blue.

 

When you are done, your screen should look like this:

 

 

Now comes the fun part...select from A1 to CZ52 by pressing the mouse down on CZ52 and dragging to cell A1, then releasing. Click on the Gallery icon in the toolbar so that you can make a graph. Then click Chart.  

 

Select the first Surface graph and behold your handiwork! You've created a 3-D graph of the potential around a dipole. By clicking on the chart and moving the handles around, you can view the scene from different directions.

 

There are two pre-built spreadsheets for this. MakingMountains.xls (in the Files area of the website) shows the finished dipole. This is useful when talking about charges "rolling" down from high to low potential. It also helps you see why defining V = 0 at infinity makes sense. The area between the charges has V = 0, but E ≠ 0. MakingMountains2.xls shows the potential around four positive charges. The area between the charges has V ≠ 0, but E = 0.