Docstoc

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. My Call

W8TM

Freq MHz Mode Date Time Worked 1.810 CW ###### 2103 W8MJ 5.250 PHONE ###### 2105 W8CAR 10.120 CW ###### 2108 W8AV 14.250 PHONE ###### 2110 NI3S 146.520 FM ###### 2111 K8DX 220.000 FM ###### 2113 W2TZ 425.000 FM ###### 2114 WA9IRV 1240.100 CW ###### 2116 K4FXN 47000.000 CW ###### 2117 K8JM 450000.000 CW ###### 2119 W0CG

Calculated columns copy down as needed QSO # for convenience only. Band QSO # 160M 1 60M 2 30M 3 20M 4 2M 5 1.25M 6 70CM 7 23CM 8 6MM 9 SUBMM 10

c8df8a17-a1e8-4778-a65c-329fe1a00ec5.xls

11/27/2009

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:
Tags: ADI-c, onver
Stats:
views:43
posted:11/28/2009
language:English
pages:4
Description: ADI-converter