¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io

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.
Monosnap K2B - 13 Colonies 2024 - Google Sheets 2024-07-08 13-10-44.png

Sean N3RTW

--
Sean Walberg <sean@...>? ??


 

Question on the totals tab. I don't use N1MM.

Can I just put my own numbers in manually? If so, is it a daily number or the cumulative as of that day?

Thanks
KN4DUF


 

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.

Can I just put my own numbers in manually? If so, is it a daily number or the cumulative as of that day?

Thanks
KN4DUF



--
Sean Walberg <sean@...>? ??


 

¿ªÔÆÌåÓý

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.

Can I just put my own numbers in manually? If so, is it a daily number or the cumulative as of that day?

Thanks
KN4DUF