🌎Worldvision VII🌎: ✏️Assignment & Confirmation✏️, 🏝️Not sponsored by TUI🏝️ |
Track this thread - Email this thread - Print this thread - Download this thread - Subscribe to this forum |
11th December 2022, 04:37 PM
Post
#61
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 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.
|
|
|
11th December 2022, 06:09 PM
Post
#62
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 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! |
|
|
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 |
|
|
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 |
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. |
|
|
13th December 2022, 12:01 PM
Post
#65
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 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! |
|
|
13th December 2022, 12:03 PM
Post
#66
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 User: 77,363 |
Also if you need help with finding entries, I can suggest a couple of sources x
|
|
|
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 |
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. |
|
|
13th December 2022, 01:01 PM
Post
#68
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 User: 77,363 |
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. |
|
|
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 |
|
|
13th December 2022, 03:24 PM
Post
#70
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 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 |
|
|
14th December 2022, 11:39 AM
Post
#71
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 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
|
|
|
14th December 2022, 01:42 PM
Post
#72
|
|
Alone and wounded
Pronouns: She/her
Joined: 18 January 2011 Posts: 60,193 User: 12,810 |
Thanks for the reminder! Submitted.
|
|
|
15th December 2022, 12:09 AM
Post
#73
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 User: 77,363 |
F**k 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 |
|
|
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 |
|
|
15th December 2022, 03:31 PM
Post
#75
|
|
I feel it COMING!
Pronouns: he/they
Joined: 9 October 2018 Posts: 9,247 User: 77,363 |
I haven't started making the recap and the thread ddd so you're fine x
|
|
|
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
|
|
|
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.
|
|
|
Time is now: 27th April 2024, 03:05 PM |
Copyright © 2006 - 2024 BuzzJack.com
About | Contact | Advertise | Privacy Policy | Terms of Service