Is there a way to filter the countries to find which ones I have not submitted or granted by LOTW. I would like to do this by band and mode. I have yet to find the proper filter to do this.
Greg
WB2BIN
Countries not submitted or granted by LOTW
Moderator: OE6CLD
- G4POP
- Log4OM Alpha Team
- Posts: 10815
- Joined: 21 Jan 2013, 14:55
- Location: Burnham on Crouch, Essex UK
Re: Countries not submitted or granted by LOTW
In the filters/confirmations dialog select LOTW and sent = No
For NOT granted at this time you should export from the Award statistics to Excel and sort/filter in Excel
If there are not many then clicking a cell in the Awrds view enables you to edit the applicable QSO's
For NOT granted at this time you should export from the Award statistics to Excel and sort/filter in Excel
If there are not many then clicking a cell in the Awrds view enables you to edit the applicable QSO's
73 Terry G4POP
Re: Countries not submitted or granted by LOTW
Terry,
Thanks, but I was hoping for a simple filter to do the job. I have quite a few. I am trying to get CW and Phone cards submitted that were not available via LOTW. I have asked and may I suggest again some filters with "not" in the expression. Like countries not worked by band, mode, not selected by LOTW. I do appreciate your answer but I am not good and Excel and by the way when are you going to do some more UTUBES. Would like to see one in depth on the cluster. Like what is happening in detail. As I always say I am learning something new with Log4OMv2 everyday.
Thanks,
Greg
WB2BIN
Thanks, but I was hoping for a simple filter to do the job. I have quite a few. I am trying to get CW and Phone cards submitted that were not available via LOTW. I have asked and may I suggest again some filters with "not" in the expression. Like countries not worked by band, mode, not selected by LOTW. I do appreciate your answer but I am not good and Excel and by the way when are you going to do some more UTUBES. Would like to see one in depth on the cluster. Like what is happening in detail. As I always say I am learning something new with Log4OMv2 everyday.
Thanks,
Greg
WB2BIN
Re: Countries not submitted or granted by LOTW
Hi Greg,
For a quick overview, you can go to View -> Award Status -> DXCC. If everything is up-to-date, you will see different color boxes: blue = granted (GRA), green = verified (on LoTW, but yet not applied for/granted), orange = confirmed (by QSL card, but not verified by DXAC or field checker) and grey = worked (worked but not confirmed by LoTW or QSL).
Under "Predefined Config" on the left you can select single bands or modes. On the Statistics tab you can see a quick overview by mode and status. For more flexibility yiou can set various filters under the "Award Filters" tab.
If you double-click on a box, you will see all matching QSOs for this band/mode slot.
Hope this helps.
73,
Claus
For a quick overview, you can go to View -> Award Status -> DXCC. If everything is up-to-date, you will see different color boxes: blue = granted (GRA), green = verified (on LoTW, but yet not applied for/granted), orange = confirmed (by QSL card, but not verified by DXAC or field checker) and grey = worked (worked but not confirmed by LoTW or QSL).
Under "Predefined Config" on the left you can select single bands or modes. On the Statistics tab you can see a quick overview by mode and status. For more flexibility yiou can set various filters under the "Award Filters" tab.
If you double-click on a box, you will see all matching QSOs for this band/mode slot.
Hope this helps.
73,
Claus
Claus, OE6CLD/DJ0DX/EI7JZ
Re: Countries not submitted or granted by LOTW
Claus,
I have tried all that you suggested and they work fine but as of yet I have not found a way for Log4OMv2 to tell me how many countries that I have not worked without some heave Excel work and I thought there must be an easier way from within the program. My old DXBase program did that along with "live" worked, confirmed by band and mode from the DX Cluster not type in a call. maybe you can tell me on the stats main page....phone, cw, digital the green squares does not tell me if it is confirmed or not. Am I thinking correct.
Greg
WB2BIN
I have tried all that you suggested and they work fine but as of yet I have not found a way for Log4OMv2 to tell me how many countries that I have not worked without some heave Excel work and I thought there must be an easier way from within the program. My old DXBase program did that along with "live" worked, confirmed by band and mode from the DX Cluster not type in a call. maybe you can tell me on the stats main page....phone, cw, digital the green squares does not tell me if it is confirmed or not. Am I thinking correct.
Greg
WB2BIN