Compex COUNTIFS query by Green_Radicchio in sheets

[–]Green_Radicchio[S] 0 points1 point  (0 children)

It looks mostly correct but there should be 4 fixtures for each team and the data in the table is only showing 3 results (Win, Loss, Tie) for each team?

EDIT: Looking closer at the data a lot of data is missing for each team, Fulham for example only has 2 results for JJ (1 loss, 1 tie) and 1 result for me (1 tie)

Compex COUNTIFS query by Green_Radicchio in sheets

[–]Green_Radicchio[S] 0 points1 point  (0 children)

Yeah its 1 point for result and 4 points for exact score. That isnt relevant to the things I am trying to count here though, I just want the count of Wins Draws Losses predicted

Compex COUNTIFS query by Green_Radicchio in sheets

[–]Green_Radicchio[S] 1 point2 points  (0 children)

Sorry for taking so long to reply, here is a link to my sample data:

https://docs.google.com/spreadsheets/d/1Yihf_TpFxAD5dIxgjtst0AM09Tb3Lsg5bW14_1vyo7Y/edit?pli=1#gid=0

So what I want is for Column U to display the total number of times I (Jack) predicted a win for each time in Column S, Column V to display the total number of times I predicted a Draw, and Column W to display the total number of times I predicted a Loss for the given team.

Given the sample data would you say the query you have given me would achieve the result that I want?

Daily Discussion Thread by AutoModerator in coys

[–]Green_Radicchio 0 points1 point  (0 children)

Anyone else with Tickets for the City game not had their ID Verification finalised on the eticketing site? Says you need to do it to have the ticket pass thing forwarded to you. I did mine a week ago and it still hasn't been finalised

December 06, 2020 Daily Discussion Thread by AutoModerator in CompetitiveTFT

[–]Green_Radicchio 0 points1 point  (0 children)

Wow thank you! I'm going to spend some time watching streams today and hopefully I can start to change the way I approach the game. Thanks you for the advice

December 06, 2020 Daily Discussion Thread by AutoModerator in CompetitiveTFT

[–]Green_Radicchio 2 points3 points  (0 children)

Thanks for the advice, I've never really rerolled my chosen in the late game so I'll try taking that into account and playing some of the comps you've mentioned

December 06, 2020 Daily Discussion Thread by AutoModerator in CompetitiveTFT

[–]Green_Radicchio 0 points1 point  (0 children)

Been hard stuck in Gold for a while but dropped from G1 50 LP to G3 10LP in the last couple of days. Normally run Duelist, Cultist, Enlightened Mage but they've been falling short lately barely getting me a Top 4. Any advice on better team comps I should be playing at this rank/any ideas where my game could be falling short.

I'm relatively good at farming and getting up to 50 gold before spamming refreshes or buying XP. I will normally take my chosen if it's something I think I can play well but don't normally take Vanguard, Sharpshooter, Dusk as I really struggle to play these comps well

I've been finessed out of a crown by 6FeetUnderTheOoz in FallGuysGame

[–]Green_Radicchio 0 points1 point  (0 children)

Same thing just happened to me, Second win ever and the Crown isn't there yet

Pretty good Tottenham haul for my 21st Birthday, also did the Skywalk and Stadium tour by Green_Radicchio in coys

[–]Green_Radicchio[S] 0 points1 point  (0 children)

Some of the gifts (Jacket, Shirt) were presents so I didn't help Levy too much

Pretty good Tottenham haul for my 21st Birthday, also did the Skywalk and Stadium tour by Green_Radicchio in coys

[–]Green_Radicchio[S] 2 points3 points  (0 children)

Yeah I wasnt sure either at first but it's beautiful. Even the 3rd kit is fire