I am on 2.8 and I am wondering how many call signs have I worked? I have over 10,000 digital QSOs but I am guessing I probably only have worked 2,500 call signs - the rest coming from duplicates on a band (I usually will re-work someone I have had a QSO with on a band if they contact me) and from working others multiple times on different bands.
I tried to figure out how it could be done in 2.8 but no joy.
Anybody know how I could do this?
Charlie
W4EBB
How many call signs have I worked?
Re: How many call signs have I worked?
You can do that relatively quickly with PowerShell text processing.
In Log4OM:
File->Export CSV
check ONLY the call field
save to "calls.csv"
In PowerShell:
Get-Content .\calls.csv | Sort-Object -Unique | Measure-Object
You can also get a list of your 10 most frequent contacts in PowerShell:
Get-Content .\calls.csv | Group-Object -NoElement | Sort-Object -Property Count -Descending | Select-Object -First 10
In Log4OM:
File->Export CSV
check ONLY the call field
save to "calls.csv"
In PowerShell:
Get-Content .\calls.csv | Sort-Object -Unique | Measure-Object
You can also get a list of your 10 most frequent contacts in PowerShell:
Get-Content .\calls.csv | Group-Object -NoElement | Sort-Object -Property Count -Descending | Select-Object -First 10
—
Dale
Dale
Re: How many call signs have I worked?
Dale:
No experience with powershell.
But will try your suggestion and let you know.
Thanks,
Charlie
W4EBB
No experience with powershell.
But will try your suggestion and let you know.
Thanks,
Charlie
W4EBB
Re: How many call signs have I worked?
Dale:
Ran Powershell with your specs and got an unexpected answer.
Out of 10,047 contacts I estimated that probably 2,500 were unique. Mainly because it seems like most of my contacts I have worked before on other bands so I only want to count all of the multiple contacts with the same call sign as only one.
My answer was 6,644.
So I made up a test file to which I knew the answer. Ran it and the answer was correct.
So thank you on two accounts. One - I got my answer. Two you made me aware of how to use Powershell.
Thanks again and stay safe!
Charlie
W4EBB
Ran Powershell with your specs and got an unexpected answer.
Out of 10,047 contacts I estimated that probably 2,500 were unique. Mainly because it seems like most of my contacts I have worked before on other bands so I only want to count all of the multiple contacts with the same call sign as only one.
My answer was 6,644.
So I made up a test file to which I knew the answer. Ran it and the answer was correct.
So thank you on two accounts. One - I got my answer. Two you made me aware of how to use Powershell.
Thanks again and stay safe!
Charlie
W4EBB
Re: How many call signs have I worked?
Congrats on all the unique calls!
Glad PowerShell answered the question. I am not a PS expert (more comfortable with awk and sed) but it's useful for quickly exploring Windows text data . PS can handle multi column data reasonably well, so if there is interest in things like "how many unique Olivia contacts on 30m in 2019?" I can probably pull together some more advanced report examples.
Stay safe.
Glad PowerShell answered the question. I am not a PS expert (more comfortable with awk and sed) but it's useful for quickly exploring Windows text data . PS can handle multi column data reasonably well, so if there is interest in things like "how many unique Olivia contacts on 30m in 2019?" I can probably pull together some more advanced report examples.
Stay safe.
—
Dale
Dale