I thought about this some more. I'm going to write a Windows application that will read in your log for the year and generate a .CSV report that matches the format of the Marathon application. You will use a date filter and the logbook window to produce the report. You will still need to open the report in Excel, then copy/paste the information into the CQ application, but if I do this right, there will be a minimal amount of editing required when all is said and done.
I'll post the program and instructions on my DX4WIN web site once it's working. 73 - Jim AD1C --- Jim Reisert AD1C <[EMAIL PROTECTED]> wrote: > 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
