This tool is similar to the Bode Plot tool. The amplitude and phase are calculated at 1000 points over the frequency range using  defined names and formulae. All formulae are evaluated in the memory, there are no calculations done directly on the spreadsheet. See the How Bode Plot works page for details of the formulae used.

There are 2 additional formulae used in this tool, these calculate the X and Y axis values for the plot. These formulae are:

Xaxis = Amplitude * cos(Phase); and

Yaxis = Amplitude * sin(Phase).

These values are plotted on the X-Y chart to produce the Nyquist plot.