Nationstates Olympic Games Discussion Thread

[Srednjaci]

Congrats Liv

[Liventia]

Thank you. I will prepare signups to go up on the 26th or 27th.

As an aside, I don't recall the NS Olympic announcements thread being a sticky, and not sure it needs to be a sticky, but ok.

[Liventia]

A quick update on signups, signups should go up tomorrow or Friday latest, just cleaning up the signup spreadsheet as I'm using Queb's from the last summer Games so there's a lot of formatting to change.

[Sjovenia]

Tagging so o can find this easier. Looking forward to another great Olympics RP!

[Srednjaci]

A quick update on signups, signups should go up tomorrow or Friday latest, just cleaning up the signup spreadsheet as I'm using Queb's from the last summer Games so there's a lot of formatting to change.

Awesome bro

[Liventia]

Signups are open: viewtopic.php?f=7&t=543919

[Da Cunha]

I have a question relating to the signup excel sheet and the automatic calculations...

I am typing in names and skill numbers, but the cell that counts entries at the very top remains at 0, and I am not good enough at excel/sheets to figure out why that is. It doesn't seem like other people have had the issue from looking at the other entries. Can anyone tell me what I might be doing wrong?

They're cells F18 and F19 for reference. The issue is that if they don't count correctly, I cannot figure out what my Standard deviation is either, and it complicates matters slightly. I get the same issue both in Google Sheets and in Excel, so it's not due to the fact that my Excel translates everything into Danish, at least.

[Liventia]

I have a question relating to the signup excel sheet and the automatic calculations...

I am typing in names and skill numbers, but the cell that counts entries at the very top remains at 0, and I am not good enough at excel/sheets to figure out why that is. It doesn't seem like other people have had the issue from looking at the other entries. Can anyone tell me what I might be doing wrong?

They're cells F18 and F19 for reference. The issue is that if they don't count correctly, I cannot figure out what my Standard deviation is either, and it complicates matters slightly. I get the same issue both in Google Sheets and in Excel, so it's not due to the fact that my Excel translates everything into Danish, at least.

Hmm. That's weird.

There is a workaround to count the total number of entries, which would be =COUNTIF(F30:F495, ">-1"), which should count every cell in the skill column with a value of 0 or greater. You can try replacing what's in F18 with that. (At the moment, F18 references column J, which checks to ensure that all name and skill cells should be filled out, and returns "TRUE" if they are not. F18 counts the number of "FALSE"s, which should be the number of entries).

If you try =COUNTIF(F30:F495, ">-1") in F18, that may solve that issue.

[Da Cunha]

You know what, thanks. I think your solution would have worked, but part of what you wrote led me to the solution in a different way.

It WAS actually my excel translating that was the issue.

What happens is that in all of J column, it returns TRUE or FALSE in Danish.

But in F18, it still said "FALSE". So obviously, since the Danish for "FALSE" is "FALSK", it didn't work. It seems to work now. I have a number at least. Thanks for the assist. Now it's just trying to get 400 names typed in in time for the deadline

[Flipverse]

Hey how can I join the NationStates olympics?

[The Afanc Strait]

Hey how can I join the NationStates olympics?

Welcome to NationStates Sports! The current Olympics is in progress, meaning that you'll have to wait until the next Summer Olympics. After a host wins the rights to host the tournament (do be aware of the warning in the OP of this thread, of course), they will open a sign-up thread with instructions on how to enter your athletes. Unfortunately, there isn't really a specified timeline for this to happen - sometimes we've had a Summer Olympics in the Northern Hemisphere summer, other times in the Southern Hemisphere summer, and it really depends on the availability and schedule of the host. The best thing to do, then, is to watch this thread, or the #olympics channel in the NSS Discord (link is an invitation) for an update as to how the next Olympics will play out.

Once again, welcome!