🌎Worldvision VII🌎: ✏️Assignment & Confirmation✏️

BuzzJack - Entertainment Discussion _ Music Contests _ Buzzjack Song Contest _ BJSC Spin Off

Latest Site News

A chart double for Taylor Swift

Hozier gets a second week at number one

Hozier climbs to number one

4 Pages

« < 2 3 4

🌎Worldvision VII🌎: ✏️Assignment & Confirmation✏️, 🏝️Not sponsored by TUI🏝️

Display modes

Track this thread - Email this thread - Print this thread - Download this thread - Subscribe to this forum

uhsting View member profile	11th December 2022, 04:37 PM Post #61
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	Just about 3 days left before the confirmation and assignment deadline! If you want to participate, here is your chance to do it now and pick an island.


uhsting View member profile	11th December 2022, 06:09 PM Post #62
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	Sorry for the double post here. I want to experiment a bit with the collection of results this edition and I'm trying to write up a code in Python that is going to churn out results a lot more quickly and collect votes through Google Form via a much more user-friendly interface. I'm still happy to receive votes from DM if you would like to format your post nicely. Let's see how this goes for me!


Cowboy Cody View member profile	12th December 2022, 08:29 PM Post #63
new hair, new tee, new Levii’s Jeans Joined: 24 October 2014 Posts: 39,316 User: 21,308	Okay I sent something that is most likely gonna ruin my good form in this spin-off as of late but it's beautiful and I think people should listen to it then again I said this last time and got 5th so we'll see


Iz 🌟 View member profile	13th December 2022, 04:39 AM Post #64
I'm a paragon so don't perceive me Joined: 3 February 2011 Posts: 37,421 User: 12,929	QUOTE(uhsting @ Dec 11 2022, 06:09 PM) Sorry for the double post here. I want to experiment a bit with the collection of results this edition and I'm trying to write up a code in Python that is going to churn out results a lot more quickly and collect votes through Google Form via a much more user-friendly interface. I'm still happy to receive votes from DM if you would like to format your post nicely. Let's see how this goes for me! Ooh that's interesting. Let me know how it goes, I've written pseudocode in my head for how to do the coding logic of similar things on Buzzjack before, but I hadn't considered that the Google API has a good set of tools for retrieving those sorts of things. I still need to do my search but I know where to go with Mexico City, Poland less so, unless you really want bargain basement pop or doom metal which seem to be its main exports and not much inbetween.


uhsting View member profile	13th December 2022, 12:01 PM Post #65
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	I haven't thought of retrieving directly through Google API. I intended to download Google sheet as a .csv file and import it to Python which seems a lot easier to do. Anyways, we have 21 nations signing up and 12 entries so far! I will need to ask the mods about a potential veto but otherwise hope we will get a couple more countries and entries in!


uhsting View member profile	13th December 2022, 12:03 PM Post #66
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	Also if you need help with finding entries, I can suggest a couple of sources x


Iz 🌟 View member profile	13th December 2022, 12:55 PM Post #67
I'm a paragon so don't perceive me Joined: 3 February 2011 Posts: 37,421 User: 12,929	QUOTE(uhsting @ Dec 13 2022, 12:01 PM) I haven't thought of retrieving directly through Google API. I intended to download Google sheet as a .csv file and import it to Python which seems a lot easier to do. That probably also works - and then the objective is to output formatted scoreboards I assume? I usually set my Excel sheets up to procedurally generate scoreboards which didn't take too long but you could easily set up a loop for what I did and make them after pressing a button that way with the right script from a csv sheet.


uhsting View member profile	13th December 2022, 01:01 PM Post #68
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	QUOTE(Iz 💀 @ Dec 13 2022, 12:55 PM) That probably also works - and then the objective is to output formatted scoreboards I assume? I usually set my Excel sheets up to procedurally generate scoreboards which didn't take too long but you could easily set up a loop for what I did and make them after pressing a button that way with the right script from a csv sheet. Yup, the objective is to generate a typical scoreboard which you can see at the end of the contest. I could then do some fancy colouring and make it look nice on Excel later. I am trying to program a code that will generate a random sequence that gives me a scoreboard after x amount of votes.


Silas View member profile	13th December 2022, 01:54 PM Post #69
Queen of Soon Joined: 24 May 2007 Posts: 74,092 User: 3,474	That’s quite easy to do in excel as you go tho. Col A - Position Col B - whatever format spacer you want Col c - Country Col d - spacer Col e - artist - song Col f - spacer Col g - Sum(h2:2) Every scoreboard you replace the with the next column along, double click the bottom corner to apply the change to all and then sort Z-A on Col G. Count 1..2..3..4 and drag down in Col A and then copy A2:G42~ and paste onto buzzjack and you’ll get a standard formatted thing You can even alter the set up to add BBCode as necessary if you wanna like bold country names of those that have voted. Takes maybe a minute to do all of the changes and paste into the text box. It’s how I produce the scoreboards for every contest I’ve hosted. Eg the last TBO results scoreboard is all formatted this way


uhsting View member profile	13th December 2022, 03:24 PM Post #70
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	Ah I did it with PFSC and Pride during my hosting similarly but the issue is that this process is very exhaustive. I will see if I can create a function that will just generate lists in .txt by only inputting the order of votes presentation as I like so I can just copy and paste as I do my results presentation. I could also try to make a graph of how the ranking of countries changes as the votes come along. This post has been edited by uhsting: 13th December 2022, 03:24 PM


uhsting View member profile	14th December 2022, 11:39 AM Post #71
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	I've sent reminders Anyone still interested can still hop on the spaceship by the end of today and I will assign the countries+cities asap x


Jade View member profile	14th December 2022, 01:42 PM Post #72
Alone and wounded Pronouns: She/her Joined: 18 January 2011 Posts: 60,191 User: 12,810	Thanks for the reminder! Submitted.


uhsting View member profile	15th December 2022, 12:09 AM Post #73
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	Fk I forgot to send a reminder to Addy! Hope he can send me an entry soon, which will put the official number of entries to 21! If you still want to sneak in a change, or do a last-minute pick on an island (will assign you the set very quickly x), you are welcome to do so before I put up a thread before like 20:00 today x This post has been edited by uhsting**: 15th December 2022, 12:10 AM


FrankLuck View member profile	15th December 2022, 02:56 PM Post #74
BuzzJack Enthusiast Joined: 22 December 2009 Posts: 1,863 User: 10,284	Can I still switch my entry quickly? Edit: Well, I did If you can't accept it, it's fine. This entry is cool too (and the crowd will enjoy it more than my original one), but that one should be a BJSC entry for sure, even if it flops. This post has been edited by FrankLuck: 15th December 2022, 03:08 PM


uhsting View member profile	15th December 2022, 03:31 PM Post #75
I feel it COMING! Pronouns: he/they Joined: 9 October 2018 Posts: 9,246 User: 77,363	I haven't started making the recap and the thread ddd so you're fine x


Cowboy Cody View member profile	15th December 2022, 07:48 PM Post #76
new hair, new tee, new Levii’s Jeans Joined: 24 October 2014 Posts: 39,316 User: 21,308	is it just me or does 21 feel relatively low for WorldVision


Dobbo View member profile	15th December 2022, 07:51 PM Post #77
BuzzJack Legend Joined: 4 November 2013 Posts: 30,552 User: 20,053	Very low. Actually this is quite an unusual time to be starting one (not that I'm against it personally) as we're usually finished with the main contests by now and we're in a cooling off period with only TBO / Rejects.