Keyboard Shortcuts
ctrl + shift + ? :
Show all keyboard shortcuts
ctrl + g :
Navigate to a group
ctrl + shift + f :
Find
ctrl + / :
Quick actions
esc to dismiss
Likes
Search
K2B Spreadsheet
Hey folks, I was adding in my cumulative totals to the tracking spreadsheet and noticed that the formulas expect values every day of the week (except those before your first day). W4TEA, NT8B, and K0ZR, I filled out your rows by taking your final count and copying it right. Feel free to put in the actuals if you did operate those days. I was just trying to make the totals work as you weren't being counted. Sean N3RTW |
I used RUMLogNG so I had the same problem. The spreadsheet was set up to expect cumulative (running) totals. So if your last QSO on day 1 was #100, put down 100 on that day. If you made 50 more QSOs on day 2 such that your last QSO was #150, put down 150 for day 2. The totals for everyone are on the Jul 7 column, which is why you need to carry things forward to the right for there to be a number at the bottom. IOW, any given cell should be greater than or equal to the one to the left of it. Sean N3RTW On Mon, Jul 8, 2024 at 1:47?PM Frank Stapanowich KN4DUF via <KN4DUF=[email protected]> wrote: Question on the totals tab. I don't use N1MM. |
¿ªÔÆÌåÓýNo, you don¡¯t need to put anything on the spreadsheet, just email me log in adif or cabrillo, please. Several have asked about dupes; I don¡¯t worry about them, it¡¯s not a contest. There are always dupes, because there¡¯s no real-time logging among 30 ops. So we have lots of inter-log dupes anyway. Intra-log dupes no problem either. Thanks, ? ? David Wright, K2WPM PO Box 596 Melfa Va 23410 ? ? ? ? From: [email protected] <[email protected]>
On Behalf Of Frank Stapanowich KN4DUF via groups.io
Sent: Monday, July 8, 2024 1:47 PM To: [email protected] Subject: Re: [K2B-13Colonies2024] K2B Spreadsheet ? Question on the totals tab. I don't use N1MM. |
to navigate to use esc to dismiss