Jump to content

Featured Replies

  • Replies 639
  • Views 15.3k
  • Created
  • Last Reply

Top Posters In This Topic

Most Popular Posts

Posted Images

  • Author
On 23/10/2026 at 10:28, blacksquare said:

Here are the templates that were made for me, hopefully they can help a fellow spreadsheet baby. The instructions were easy to follow (don't touch the formulas!), but let me know if anything feels confusing or needs tweaking. There are checks to help catch mistakes (I needed these) along with colour coded scoreboards (I needed these too). You can select votes from a drop down menu rather than typing anything in, tie breaks are built into the formulas, deductions are easy etc

Even something like this was very helpful 😮

dnq.png

check.png


If you already know your way around a spreadsheet, obviously ignore these, or perhaps give some suggestions on how to make them better or easier to follow. I think there is potential to turn them into a resource for new overwhelmed hosts. I also have these saved as excel files if anyone wants those x

If you have something superior already then why didn't you share it with me ö

Semi Finals Template

Final Template


I'm not sure if anyone saved the template, but it has been updated since I posted it. Thanks to @Iz様 🌟 for their suggestions!

The "How To Use" tab is now clearer and makes it easier to complete the spreadsheet with missing votes. If you prefer manually typing votes instead of using the drop-down menu, that process is now less annoying. Also, Iz had a great idea, you can now create scoreboards within the sheet that can easily be copied into a Word or notes document as you go. All this time I had been pasting black squares into every scoreboard 😶

There are ten scoreboard templates to choose from, but they can all be tweaked. Examples:

01 ■ Sample Nation F14 ■ Sample Artist 14 - Sample Song 14 ■ 18

02 ■ Sample Nation F08 ■ Sample Artist 08 - Sample Song 08 ■ 15

03 ■ Sample Nation F06 ■ Sample Artist 06 - Sample Song 06 ■ 12

04 ■ Sample Nation F09 ■ Sample Artist 09 - Sample Song 09 ■ 11

05 ■ Sample Nation F13 ■ Sample Artist 13 - Sample Song 13 ■ 08

01 || 18 || Sample Nation F14 || Sample Artist 14 - Sample Song 14

02 || 15 || Sample Nation F08 || Sample Artist 08 - Sample Song 08

03 || 12 || Sample Nation F06 || Sample Artist 06 - Sample Song 06

04 || 11 || Sample Nation F09 || Sample Artist 09 - Sample Song 09

05 || 08 || Sample Nation F13 || Sample Artist 13 - Sample Song 13

01 • Sample Nation F14 • Sample Artist 14 - Sample Song 14 • 18

02 • Sample Nation F08 • Sample Artist 08 - Sample Song 08 • 15

03 • Sample Nation F06 • Sample Artist 06 - Sample Song 06 • 12

04 • Sample Nation F09 • Sample Artist 09 - Sample Song 09 • 11

05 • Sample Nation F13 • Sample Artist 13 - Sample Song 13 • 08


If anyone else has any ideas then please let me know! I would love to turn this into something a lot of us can use to make hosting less laborious 🖤

Semi Finals Template

Final Template

Penultimate YTD update of the year jump

I posted before that there was now nearly exactly a 100 point gap between the top 2 of the YTD - but I was mistaken, as I'd forgotten to consider Neliönoir's threat to the leaders. Hendinia's DNQ thus sees them slip from 1st to 3rd, being 99 points behind Bøtanikkä who retake the lead but also now 12 points behind 2025 champions Neliönoir, who have grown from an unassuming start to the year to now looking like a real threat to go 2 in a row with EOY trophies as their top 5 finishing auto-qualifier puts them a mere 87 points off #1. It's still realistically a potential three-horse race (although you'd have to give Bøtanikkä the edge to hang on), although the countries just beyond the top 3 could still snatch a fairytale victory if there's a sufficient train crash of DNQs and a very big hit for them. Cor Lupus hold in 4th, The Spodic Empire and Sovarasma are up two places each to 5th and 6th, Elëdan rise 3 to 7th, Aeroche and Fljótavík both stay top 10 despite adding no additional points due to their DNQ and non-participation respectively and both fall three places to 8th and 9th, and Skall are down a place to 10th. All climbers in the 11th-15th section (as a few of those previously in that region also DNQed), but the only changing face in the top 20 is Bronzil replacing Lentyll. Greenfroze's win propels them up 14 places to 25th, and they're among 13 countries who pass 1,000 total points for the year (which hey look, also includes little old Persephonia who are also back in the top 30 just about).

1 2 1970 Bøtanikkä

2 3 1883 Neliönoir

3 1 1871 Hendinia

4 4 1774 Cor Lupus

5 7 1660 The Spodic Empire

6 8 1637 Sovarasma

7 10 1595 Elëdan

8 5 1570 Aeroche

9 6 1552 Fljótavík

10 9 1509 Skall

11 13 1499 Danæviia

12 16 1498 Altyr Muunilinst

13 15 1427 Séyetana

14 17 1367 Ojnoj

15 19 1357 Terra Avium

16 11 1327 Trifoski

17 12 1299 Kluminican Republic

18 14 1266 Jadakissnia

19 22 1163 Bronzil

20 20 1156 Freidland

21 30 1126 N DNTN

22 18 1126 Lentyll

23 21 1107 Land of DW

24 23 1064 POPHub

25 39 1054 Greenfroze

26 33 1049 FSR Rontvia

27 34 1047 Pestolia

28 29 1044 Lookylion

29 24 1030 Scotland 2

30 35 1017 Persephonia

31 31 1004 Yehesi

32 32 1001 Deandria

33 38 967 FARC

34 43 944 Herbilore

35 42 924 Ajanaeda

36 40 920 Juranabaijan

37 25 907 Zephyra Continuum

38 26 906 Cheiron

39 27 897 République d'Áskorza

40 28 892 Dalisska

41 41 882 Jupiterdonia

42 45 870 Pagasa

43 46 862 East Rukahavian

44 48 802 Ennea

45 36 799 Kathaldazia

46 37 792 Baleghde

47 49 740 Dobago

48 44 707 New Lexico

49 53 689 Mothertopia

50 50 687 Taahino

51 47 666 Aelandor

52 55 610 New Helvetica

53 51 593 Zanmatony

54 57 576 Flynnonda

55 52 530 Summericia

56 60 529 Lotunia

57 54 488 Harmonica

58 56 444 A-Konohagakure

59 58 431 Hushkanukia

60 62 417 Thelonia

61 59 372 Cumulonimbia

62 61 292 Aesthetica

63 68 268 Daehun

64 63 258 Ben's Sanctuary

65 64 180 Utopia

66 65 177 Ramrynia

67 66 156 Wholune

68 67 155 Vaskla

Incidentally - we've still never had an EOY #1 that didn't win at least one contest during the year, and that run now looks more likely to continue as Bøtanikkä and Neliönoir have both had wins while Hendinia haven't (yet their consistency is such that they are still in with a shot of retaking the #1 for the EOY even with only 9/10 qualifiers).

inb4 Hendinia win BJSC 190 anyway

  • Author

Not sure how I managed that after my flops during the first half of the year, but pleasantly surprised! 🖤 Last year feels like less of a fluke at least

4 minutes ago, RobBot said:

Genuinely happy to still be top 3 with a DNQ!

Insane levels of consistent slaying

bratcheeseblock

Bøtanikkä should have this in the bag, but I wouldn’t be surprised to see you return with a massive FLJ type win

26th is a lot better than the mid 40s we were down at in the summer. I think my all-time previous low was the low 20s somewhere, possibly in 2017?

2 minutes ago, gooddelta said:

26th is a lot better than the mid 40s we were down at in the summer. I think my all-time previous low was the low 20s somewhere, possibly in 2017?

Your lowest EOY finish was 27th in 2015 so you're still pacing ahead of that despite the multitude of DNQs! Likewise even with 4 DNQs I'm now at the same position I finished in last year, and still better than my nadir (excluding pre-BJSC 41 which I barely count) of 37th in 2025. Remains to be seen if I carry on my run of top 20 or bust for better or for worse x

It's quite stressful seeing myself #1 lol

Nelly slowly retaking #1 (as they should after smashing contest after contest), but also the power of Hendinia o wub

Wow, I don't remember being EOY Top 10 in over a decade. My highest finish so far this year was also 7th place, yay consistency!

1 hour ago, Addy! said:

It's quite stressful seeing myself #1 lol

Nelly slowly retaking #1 (as they should after smashing contest after contest), but also the power of Hendinia o wub

We are expecting a SMASH. Although even a 175 pointer will do you fine if Hendinia and Nelly don't have a winner up their sleeves.

Just now, gooddelta said:

We are expecting a SMASH. Although even a 175 pointer will do you fine if Hendinia and Nelly don't have a winner up their sleeves.

And that's the problem because let's be real lol

35 minutes ago, Addy! said:

And that's the problem because let's be real lol

It’s Ms Nelly you need to worry about. I don’t have anything in mind yet nor am I frantically looking now I have nothing to upkeep 😂

I love having zero expectations for the year, I’m just enjoying my victory lap 😛

Pop seems to be in the cards for me for next contest bc that’s what’s jumping out to me at the moment. If anything indie/electronic comes out and completely grabs me then I’ll consider it 🤷‍♂️ thanks to everyone who enjoyed my LARPing session though!

Out of 68 countries it is odd to be top 5. I still see myself as very much an outsider in this competition.

Edited by Colm

Create an account or sign in to comment

Recently Browsing 1