ADI converter

Document Sample
ADI converter Powered By Docstoc
					Instructions for use.
1. Manually input data on Log worksheet in columns A through E. Erase any data already processed.
   Particularly for contests, it may be easy to fill in columns A through C by copying down the column.
2. Copy down (or delete) formulas in columns G and H on Log worksheet to match length of data input.
3. On the ADIF worksheet, copy down (or delete) formulas in column A to match length of Log sheet.
   The last row occupied on both Log and ADIF sheets will be the same.
4. VERY IMPORTANT: then save this Excel workbook in Excel format (normal save).
5. After saving in Excel format, go to ADIF worksheet and Save As (your choice of name)
   in Text (MS-DOS) format. Choose "Text (MS-DOS)" from the drop-down list in the Save As
   dialog box (it's pretty far down the list). Give the file a name in double-quotes,
   with an .ADI extension, like "W8TM_log3.ADI" This will save only the one worksheet;
   ignore warnings about lost info.
6. Shut down Excel. It will issue a warning and ask you if you want to save. Ignore the
   warning and shut down without saving anything.
7. Check that you didn't screw up by reopening this workbook in Excel (it should be unchanged from step 3)
   and by viewing the .ADI file in a text editor (it should look like the ADIF worksheet but without
   columns or blank lines).
8. The .ADI file you saved should be able to be signed by TQSL and e-mailed to LoTW.

DON'T SKIP STEP 4.
If you screw up steps 5 or later, you can restart from the Excel file saved in Step 4.
If you want to make more manual ADI entry workbooks like this one, you can copy this file in Explorer or
    Save As an Excel workbook from Excel, under a new file name in either case.
If TQSL expands the list of bands it will process, insert them in frequency order on the Band Table worksheet.
    Comment: out-of-band frequency input results in the next-lower frequency band name (or #N/A if less than 1.8).
Mode names should match those listed in TQSL's manual ADIF editor.
         Input Data in red.                            Calculated columns
         My Call              W8TM                     copy down as needed
                                                       QSO # for convenience only.
           Freq MHz Mode     Date Time Worked            Band     QSO #
                1.810 CW    ###### 2103 W8MJ           160M              1
                5.250 PHONE ###### 2105 W8CAR          60M               2
               10.120 CW    ###### 2108 W8AV           30M               3
               14.250 PHONE ###### 2110 NI3S           20M               4
              146.520   FM  ###### 2111 K8DX           2M                5
              220.000   FM  ###### 2113 W2TZ           1.25M             6
              425.000   FM  ###### 2114 WA9IRV         70CM              7
            1240.100 CW     ###### 2116 K4FXN          23CM              8
           47000.000 CW     ###### 2117 K8JM           6MM               9
          450000.000 CW     ###### 2119 W0CG           SUBMM            10




b38a544a-12fc-416d-968a-433396656fb3.xls   12/8/2011                                 Page 2 of 4
<call:4>W8TM<eoh>
<call:4>W8MJ<qso_date:8>19991106<time_on:4>2103<band:4>160M<freq:4>1.81<mode:2>CW<eor>
<call:5>W8CAR<qso_date:8>19991106<time_on:4>2105<band:3>60M<freq:4>5.25<mode:5>PHONE<eor>
<call:4>W8AV<qso_date:8>19991106<time_on:4>2108<band:3>30M<freq:5>10.12<mode:2>CW<eor>
<call:4>NI3S<qso_date:8>19991106<time_on:4>2110<band:3>20M<freq:5>14.25<mode:5>PHONE<eor>
<call:4>K8DX<qso_date:8>19991106<time_on:4>2111<band:2>2M<freq:6>146.52<mode:2>FM<eor>
<call:4>W2TZ<qso_date:8>19991106<time_on:4>2113<band:5>1.25M<freq:3>220<mode:2>FM<eor>
<call:6>WA9IRV<qso_date:8>19991106<time_on:4>2114<band:4>70CM<freq:3>425<mode:2>FM<eor>
<call:5>K4FXN<qso_date:8>19991106<time_on:4>2116<band:4>23CM<freq:6>1240.1<mode:2>CW<eor>
<call:4>K8JM<qso_date:8>19991106<time_on:4>2117<band:3>6MM<freq:5>47000<mode:2>CW<eor>
<call:4>W0CG<qso_date:8>19991106<time_on:4>2119<band:5>SUBMM<freq:6>450000<mode:2>CW<eor>
Table of Bands Processed by TQSL
This table should match that in TQSL's manual ADIF editor.

Lower Limit of Band (MHz)       Band Name
                            1.8       160M
                            3.5         80M
                          5.25          60M
                              7         40M
                          10.1          30M
                             14         20M
                      18.068            17M
                             21         15M
                        24.89           12M
                             28         10M
                             50          6M
                             70          4M
                           144           2M
                           220       1.25M
                           420       70CM
                           902       33CM
                         1240        23CM
                         2300        13CM
                         3300          9CM
                         5650          6CM
                       10000           3CM
                       24000       1.25CM
                       47000           6MM
                       75500           4MM
                     119980         2.5MM
                     142000            2MM
                     241000            1MM
                     300000        SUBMM

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:9
posted:12/8/2011
language:
pages:4