On 05/08/2026 at 22:15, Juranamo said:

Hoping to also be able to import full detailed votes at some point, but that feels like a mission unless the results spreadsheets are routinely shared!

Luckily it's a mission I've already completed although am hoarding until I eventually find enough time and motivation to finally finish revamping the Songs of BJSC thread x

(clicky if you want to peruse - I plan to convert these to Google Sheets to be linked in said mythical Songs of thread revamp "eventually" but for now they're stuck in the archaic old Excel file format, that file contains all the available voting data in the contest's history though, plus some that is no longer viewable on the actual forum due to link rot but that I saved before it went offline, sadly some of the semi spreadsheets before BJSC 41 were either never posted or were already inaccessible by the time I started archiving)

((the reason I have still not posted this is largely because I'm in the painfully slow process of updating old artist/song tags, have been doing that on and mostly off for a few years at this point but I'll complete it eventually))

15 hours ago, Bror said:

Luckily it's a mission I've already completed although am hoarding until I eventually find enough time and motivation to finally finish revamping the Songs of BJSC thread x

(clicky if you want to peruse - I plan to convert these to Google Sheets to be linked in said mythical Songs of thread revamp "eventually" but for now they're stuck in the archaic old Excel file format, that file contains all the available voting data in the contest's history though, plus some that is no longer viewable on the actual forum due to link rot but that I saved before it went offline, sadly some of the semi spreadsheets before BJSC 41 were either never posted or were already inaccessible by the time I started archiving)

((the reason I have still not posted this is largely because I'm in the painfully slow process of updating old artist/song tags, have been doing that on and mostly off for a few years at this point but I'll complete it eventually))

I did know you had a big master spreadsheet somewhere! 'Tis a shame we don't have complete votes for pre-41 semis, but will just live with what we do have!

I'm hoping to make something that can generate a wiki table (or similar) with everyone's votes on so that if anyone fancied it they can look at it on the wiki page for each contest and it'll all look pretty and have everyone's flags and everything.

Hopefully once the method of generating the table is sorted (probably some form of conkitten formula), it'll be super easy to go back through the spreadsheet and get all the wiki pages updated!

In reality, I'll forget about this project before creating a formula that works and we'll be left with a half completed wiki forever! Which is probably for the best as I'd be surprised if even 10% of BJSC participants end up looking at them (though part of me hopes that if the wiki ends up 'complete', it would make a really cool BJSC)

Thanks for that @Bror! I should be able to complete the list on the Deandria wiki of all my entries and their positions and points with this.

On 07/08/2026 at 16:04, Juranamo said:

I did know you had a big master spreadsheet somewhere! 'Tis a shame we don't have complete votes for pre-41 semis, but will just live with what we do have!

I'm hoping to make something that can generate a wiki table (or similar) with everyone's votes on so that if anyone fancied it they can look at it on the wiki page for each contest and it'll all look pretty and have everyone's flags and everything.

Hopefully once the method of generating the table is sorted (probably some form of conkitten formula), it'll be super easy to go back through the spreadsheet and get all the wiki pages updated!

In reality, I'll forget about this project before creating a formula that works and we'll be left with a half completed wiki forever! Which is probably for the best as I'd be surprised if even 10% of BJSC participants end up looking at them (though part of me hopes that if the wiki ends up 'complete', it would make a really cool BJSC)

Just noticed I passed 10,000 posts and this was the 10,000th.

For someone that has spent the best part of the last 2 decades floating in and out of BJSC, forgetting about it entirely, forgetting to vote in contests, completely losing steam with my personal chart about 4 or 5 times, basically forgetting about the website despite regularly browsing it... It feels pretty serendipitous that I'd clock the reality that this project I want to do wont really go anywhere in that 10,000th post... 🤣