Well, its not perfect but maybe a way for this first of all create the missed dxcc countries and use this cty file just for the cq Do a search (f8) from 1/1/06 to 31/12/06 In Logbook window create a report with the fields you want. Include the country prefix and put it first Right click and a ad1c2006.csv file. Rename this file to ad1c2006.txt open excel and open txt files. Then import the ad1c2006.txt with the fields seperated with , Choose all data and sort them by the prefix. Manual delete the rows with the same prefix. Sorry but i can't find a more automated way. Best 73 and HNY Kostas sv1dpi
----- Original Message ----- From: "Jim Reisert AD1C" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, December 31, 2006 7:20 PM Subject: [Dx4win] CQ DX Marathon > Is anyone else participating in the CQ DX Marathon? > > http://dxmarathon.com/ > > I am trying to figure out the easiest way to merge my DX4WIN data into the > official submission form. > > There are three problems: > > - Need a list of countries worked in 2006, with callsigns, date, time, > band and mode. > DX4WIN doesn't provide this kind of listing directly. My approach will > be to clear > any DXCC submitted/checked flags, mark all QSOs as confirmed, then > generate > a DXCC Submission Report (mixed-mode only) and save it to a file. And > make > sure I don't ever save this log! > > Of course the CQ list is sorted by entity name, not prefix. I should be > able to do > that with the DXCC submission report. And the submission report does > not have > times in it. > > - Need a way to take that data and merge it into the spreadsheet. I'm no > Excel wizard. > I'll probably just cut/paste. > > - the CQ list contains a half-dozen entities which are not on the DXCC > list: > > 4U1VIC > GM/Shetlands > IH9-IG9/African Italy > IT9/Sicily > JW/Bear Island > TA1/European Turkey > > So I'll have to pull out those QSOs manually. > > - Repeat the same thing for the 40 CQ Zones. I may try just > cutting/pasting the DXCC > info except for those countries with multiple zones (USA, Canada, > Russia, Australia). > > 73 - Jim AD1C > > -- > Jim Reisert AD1C, 7 Charlemont Court, North Chelmsford, MA 01863 > USA +978-251-9933, <[EMAIL PROTECTED]>, http://www.ad1c.us > > _______________________________________________ > Dx4win mailing list > [email protected] > http://mailman.qth.net/mailman/listinfo/dx4win > >
