Chapter 2 49
Test Descriptions
Frequency Accuracy
Performing the frequency accuracy calculations using the CSV
file in a spreadsheet
The following procedure uses Microsoft Excel.
Step 1. Open Excel.
Step 2. Open the .csv file from the A: drive. From the
File menu select Open and
Look in: (A:). Select files of Type: Text Files ( *.prn; *.txt; *.csv).
Figure 2-10 Example Excel File
Column A contains the measured frequency. Column B contains the
corresponding Linear P
hot
value. Disregard Column C null terminator
information.
Step 3. Increase the column widths to 20 to view the data more accurately.
Step 4. Enter the following formula into cell D1 = SUM(B$1:B1), copy this
formula and paste it from cell D2:D201.
Step 5. Enter the following formula into cell D202 =D201/2. This value returns
the ½ Power reading.
To Next Page
Loading...
