Oh that's a really interesting idea! I don't typically play a lot of off stream but you're very correct in that it puts a very different level of focus on the game
This was PREMIUM CONTENT! I love nerding deep into topic like this, thanks for sharing. And congrats on you results, you seem to be rocking it :) I'd love to more in depth content like this. Maybe a monthly report or tracking and reporting on tournament prep. (These are just ideas and no demands since your content is already great and I appreciate the hard work.) Thanks you!
Dude, I have been looking to do something exactly like this. Thank you so much for diving into how you went about this along with how you interpreted everything! I’m super excited to start tracking everything in a much more meaningful way.
This video was really helpful ty for this looking forward to more. I love Mardu and that you played Jeska Tymna, I keep thinking about if I want to invest more into mardu or go with a gruul or temur deck. I have been getting more into CEDH from casual and feeling lost as a boros and mardu player. I made an etali deck recently and all my friends hate me lol
I think mardu is an extremely potent sans-blue color combo and has a lot of what it takes to against really good decks! Wouldn't be my choice for a tournament but that's more of a personal preference for playing blue. Glad you enjoyed it :)!
I think an average hand size of ~6 makes sense if you’re aggressively mulliganing. It means you’re usually looking at 21 cards before you even start, which is pretty wild.
If you wanted to, you could totally nuke the F "Game" column and for counting total number of games, do "=count($E:$E)" as the count function will count the number of numeric values found in the Date column "E" since you are tracking each game on its own unique row and putting the date down for each one.
Do you happen to have an updated list for your Tivit list? I'm about to update mine in advance of a tournament and would love your thoughts. Just saw your win on Scrybabies. Congrats! I've been really iffy on dauntless dismantler... but seems to be putting in work for you.
I think especially for Tivit where Dockside is your biggest enemy, dauntless performs extremely well! The scrybabies ep definitely showcased the best case scenario but I think even the more incremental moments are still really valuable that takes advantage of opponents stumbling well. I think I should have decklists in the video description! Appreciate you watching!
I'm in the middle of watching the video and I had to pause at 14:43 where you mention having problem automating the logic to count wins for Najeela. Looking at how you have your spreadsheet setup what you can do is a countifs() logic and do "=COUNTIFS($J:$J,A9,$G:$G,1)" where A9 is your Najeela label on the side, and what this effectively does is check for every instance in your commander column that Najeela shows up and at the same time looks for in that same row where the respective Win column ($G:$G) is a 1 (Yes we won). And this logic can be copied to the rest of your commander cells (B9:B15) since we have the $ operators for the columns the only change for each cell we apply this logic will be the correlating A9:A15 for each. Hope that helps
50% win rate seems crazy! It’d be interesting to see next year what games are just for content or just with friends and what games are in tournaments.
Oh that's a really interesting idea! I don't typically play a lot of off stream but you're very correct in that it puts a very different level of focus on the game
This was PREMIUM CONTENT! I love nerding deep into topic like this, thanks for sharing. And congrats on you results, you seem to be rocking it :)
I'd love to more in depth content like this. Maybe a monthly report or tracking and reporting on tournament prep. (These are just ideas and no demands since your content is already great and I appreciate the hard work.) Thanks you!
thanks so much! Monthly updates might be interesting, I'll have to look into how much data I'm regularly accruing in a months time!
Dude, I have been looking to do something exactly like this. Thank you so much for diving into how you went about this along with how you interpreted everything! I’m super excited to start tracking everything in a much more meaningful way.
it's a really fun thing to do, glad you enjoyed watching!
This video was really helpful ty for this looking forward to more. I love Mardu and that you played Jeska Tymna, I keep thinking about if I want to invest more into mardu or go with a gruul or temur deck. I have been getting more into CEDH from casual and feeling lost as a boros and mardu player.
I made an etali deck recently and all my friends hate me lol
I think mardu is an extremely potent sans-blue color combo and has a lot of what it takes to against really good decks! Wouldn't be my choice for a tournament but that's more of a personal preference for playing blue.
Glad you enjoyed it :)!
I think an average hand size of ~6 makes sense if you’re aggressively mulliganing. It means you’re usually looking at 21 cards before you even start, which is pretty wild.
very fair assessment!
If you wanted to, you could totally nuke the F "Game" column and for counting total number of games, do "=count($E:$E)" as the count function will count the number of numeric values found in the Date column "E" since you are tracking each game on its own unique row and putting the date down for each one.
Do you happen to have an updated list for your Tivit list? I'm about to update mine in advance of a tournament and would love your thoughts.
Just saw your win on Scrybabies. Congrats!
I've been really iffy on dauntless dismantler... but seems to be putting in work for you.
I think especially for Tivit where Dockside is your biggest enemy, dauntless performs extremely well!
The scrybabies ep definitely showcased the best case scenario but I think even the more incremental moments are still really valuable that takes advantage of opponents stumbling well.
I think I should have decklists in the video description! Appreciate you watching!
I'm in the middle of watching the video and I had to pause at 14:43 where you mention having problem automating the logic to count wins for Najeela. Looking at how you have your spreadsheet setup what you can do is a countifs() logic and do "=COUNTIFS($J:$J,A9,$G:$G,1)" where A9 is your Najeela label on the side, and what this effectively does is check for every instance in your commander column that Najeela shows up and at the same time looks for in that same row where the respective Win column ($G:$G) is a 1 (Yes we won). And this logic can be copied to the rest of your commander cells (B9:B15) since we have the $ operators for the columns the only change for each cell we apply this logic will be the correlating A9:A15 for each. Hope that helps
Based thank you :)!
@@ModAnonMTG Your welcome!
Can we view the Excel file somewhere?
Just added a copy to the video description!
can u make a link for a blank spread sheet
Yeah definitely! Will update soon!
Algorithm content mickey mouse machine.
Appreciate you!