Figure 1 shows a transistor circuit and Fig. 2 shows its spreadsheet analysis. The red cells are values you input and the blue cells are calculated by the spreadsheet. Using a spreadsheet is one way to analyze the circuit.
Figure 3 shows another way. Think of this as the spreadsheet cells superimposed on the circuit components. Again you input the red cells and watch the blue cells update. This approach has advantages like displaying the equations for the blue cells, showing dc and ac load lines, etc. Check out the different galleries in this web site to see how Visual Spreadsheets for Electronics may be useful.
Figure 1. Base bias.
Figure 2. Base-bias spreadsheet
Figure 3. Spreadsheet circuit
THE BASIC IDEA BEHIND THE PROGRAM