fiercE Posted May 12, 2019 Posted May 12, 2019 14 minutes ago, Yvess said: but im just getting the averages and i checked it all... but i'll try that/ update, tried it but it is like the same with the Average function and im more comfy using it. It's fine, I am the only one that gets bothered about this but when round 1 scores is up the DIV/0 error will be gone :D (Sorry I work a lot around spreadsheets) but if you want to make it a "0" for now you can use this =IFERROR(AVERAGE(C7:N7),0) starting on the first one :D
Yvess Posted May 12, 2019 Author Posted May 12, 2019 (edited) 16 hours ago, fiercE said: It's fine, I am the only one that gets bothered about this but when round 1 scores is up the DIV/0 error will be gone :D (Sorry I work a lot around spreadsheets) but if you want to make it a "0" for now you can use this =IFERROR(AVERAGE(C7:N7),0) starting on the first one :D yeah, i know what u mean, u just want to see it clean and it is all fine. SPEADSHEETS are so triicky and fun at the same time xoxoxo Edited May 12, 2019 by Yvess
Yvess Posted May 12, 2019 Author Posted May 12, 2019 18/24 ENTRIES IN Team Element - 7/8 Team Speezy- 6/8 Team Sabbath - 5/8
fiercE Posted May 12, 2019 Posted May 12, 2019 Wait if we have multiple possible entries for a specific round, can we ask our mentor what would be the best entry among them or mentors are just there to judge and pick who they think are the weak ones on their team?
Yvess Posted May 12, 2019 Author Posted May 12, 2019 (edited) 16 hours ago, fiercE said: Wait if we have multiple possible entries for a specific round, can we ask our mentor what would be the best entry among them or mentors are just there to judge and pick who they think are the weak ones on their team? you can always ask your mentors for advice and some insights but at the end of the day, it is still your call at the end of the day on what to send you can create a group chat with ur team and mentor and discuss ideas. as for the eliminations, ur mentors will pick the "tribute" depending on his/her opinion. he/she can also discuss with u guys on who should be the tribute //// Edited May 12, 2019 by Yvess
Fa1x intelectual Posted May 12, 2019 Posted May 12, 2019 4 hours ago, Yvess said: THE PANEL Yvess - your HOEST, Song Joong Ki Speezy - The Double Tap Songstress, Jordin Sparks Element - The Sixteen Songstress, Ellie Goulding Sabbath - The Perfect Places Songstress, Lorde Fa1x Intellectual - Brazilian Excellence, Ariana Calcanhotto Not this again Açso, ADRIANA looks like she's cosplaying as Frida Kahlo in her panel picture. I like it
Yvess Posted May 12, 2019 Author Posted May 12, 2019 16 hours ago, Fa1x intelectual said: Not this again Açso, ADRIANA looks like she's cosplaying as Frida Kahlo in her panel picture. I like it omg fixed ha name now yaaaaas she's serving Frida in that shoot xoxo
Overprotected Posted May 12, 2019 Posted May 12, 2019 5 hours ago, Yvess said: Unfirtunately, Miki Minach can't make it anymore to the competition to focus on power electricity research but hey, Team Element gained another TABS @EriKills - Tinashe Welp She didn't have most of the letters in TABS anyway
Yvess Posted May 12, 2019 Author Posted May 12, 2019 16 hours ago, Overprotected said: Welp She didn't have most of the letters in TABS anyway who sis? EriKills or Miki or BOTH of them?
Overprotected Posted May 12, 2019 Posted May 12, 2019 4 minutes ago, Yvess said: who sis? EriKills or Miki or BOTH of them? I was just talking about Miss Minaj but if the shoe fits
PinkBox Posted May 12, 2019 Posted May 12, 2019 (edited) EriKills switching from Miki before the game even started because he couldn't find one video showing TABS Edited May 12, 2019 by PinkBox
Alena Posted May 12, 2019 Posted May 12, 2019 13 minutes ago, PinkBox said: EriKills switching from Miki before the gamr even started because he couldn't find one video showing TABS I -
Yvess Posted May 12, 2019 Author Posted May 12, 2019 10 minutes ago, Moonlightbae said: didn't know switching was possible Just before we hit the judging time. I offered Queen C that too. For EriKills, she wants to originally sign up with James Charles tho
Yvess Posted May 12, 2019 Author Posted May 12, 2019 46 minutes ago, Overprotected said: I was just talking about Miss Minaj but if the shoe fits I-
Moonlightbae Posted May 12, 2019 Posted May 12, 2019 20 hours ago, Yvess said: The maximum duration of video is 4 minutes 19 hours ago, Yvess said: yaaaas sis, 1:00-4:59 min only.
Yvess Posted May 12, 2019 Author Posted May 12, 2019 21/24 ENTRIES IN Team Element - 7/8 Team Speezy- 7/8 Team Sabbath - 7/8
Loyalty Posted May 12, 2019 Posted May 12, 2019 1 hour ago, PinkBox said: EriKills switching from Miki before the game even started because he couldn't find one video showing TABS T A B S
EriKills Posted May 12, 2019 Posted May 12, 2019 2 hours ago, Overprotected said: I was just talking about Miss Minaj but if the shoe fits Sorry Ogreprotected, the shoe DOESNT fit, I’m serving Kim K foot during pregnancy: The TABS overflowing the shoe
EriKills Posted May 12, 2019 Posted May 12, 2019 34 minutes ago, Loyalty said: T A B S /End tournament
PinkBox Posted May 12, 2019 Posted May 12, 2019 1 minute ago, Loyalty said: T A B S Ok I did stan that performance
Recommended Posts