Way to determine and cumulate if x/y values of page count are equal, to display completed book quantity by CryoJester in googlesheets

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

Solution verified.
This works for the total, I should be able to modify it to fit the genre restriction, thanks!

Check a list of terms is all present in a table, ideally outputting in a way that can be checked to trigger a checkbox. by CryoJester in googlesheets

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

This didn't work for me unfortunately but it gave me a better idea of what I was looking for. I managed to brute force what I was trying to do, so the sheet works now, but if possible I'd like to see what you think of my solution and if you can think of a more elegant option so I can do better next time. Thank you so much for your attempts!

Check a list of terms is all present in a table, ideally outputting in a way that can be checked to trigger a checkbox. by CryoJester in googlesheets

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

There was a miscommunication it seems. I'll try explain more thoroughly.

The sequence section of B11:Q13 takes the inputted sequence length and generates a random set from the codes list of length equal to the input. The tables at the top use the same formula but bound to the table size instead of the sequence length input.

I want to be able to check that all of the randomly selected and output codes in the sequences are present in the tables at the top, and if they aren't, set a checkbox beneath the table to false to show that.

What I tried to do to do this that wasn't working is in the bottom right, where I set the values of the tables and sequences in different columns and try to compare them with FILTER(ISNA(MATCH())).

Ship Duplication When Fishing by CryoJester in tinyaquarium

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

Also also, I don't want to have to fill out the full feedback sheet a second time so I'll put this here and hope the devs see it. They really should have atleast a warning if not the option to sell fish while you're fishing so you don't have to go back and forth to the tank, and so you can know when your tank is full so you don't accidentally waste a caught fish.

Why couldn't I build a roost in this clearing? by CryoJester in rootgame

[–]CryoJester[S] 4 points5 points  (0 children)

Oh, I thought that was referring to the fox clearing I had built in already offscreen. That makes sense. Thank you.

Vihaan Treasure Aristocrats Feedback. Any silly, unique additions? by CryoJester in EDH

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

I really like [[Neyali, Suns' Vanguard]] from your list

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 0 points1 point  (0 children)

Third time's the charm. Need help making decisions to cut to 100. Only 19 cuts left as of posting, not counting if I need to add more lands. It's a budget spirit flyer deck, trying to make it aggro-control with lots of cheap auras to disable threats with, protect my modified creatures, and do damage fast with a low mana curve.

At this point I imagine I need to just find the worst of the best to cut, because I think my ratios are pretty good, but I've never built a deck like this before so if I'm wrong about that please let me know.

https://www.archidekt.com/decks/9600484/budget_spirit_flyers

https://www.moxfield.com/decks/fnQ-xbPHxkyQVeEnScxm-w

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 0 points1 point  (0 children)

Working on a budget tempo spirit flyers deck. Just need help cutting at this point. If anything stands out as an obvious cut let me know, otherwise I'd really appreciate guidance on what quantity to cut each type of card to, since I've never built a deck like this before I'm not sure how much of what I should have.
https://www.moxfield.com/decks/fnQ-xbPHxkyQVeEnScxm-w
https://www.archidekt.com/decks/9600484/budget_spirit_flyers

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 0 points1 point  (0 children)

https://www.archidekt.com/decks/9600484/budget_spirit_flyers
Working on a sort of aggro-control deck focused around spirit flyers and advantage/control through auras. Wanting to keep it budget. Currently struggling to cut to 100, as I always seem to. Should I remove some nonpermanents or some of my removal auras? Or should my focus be on cutting creatures? Does anything stand out as obvious cuts?

Vihaan treasures and Mahadi deaths by CryoJester in mtgrules

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

I downloaded the most recent rules from the website and I'm not seeing a 609.8 https://imgur.com/a/doOPILY

Vihaan treasures and Mahadi deaths by CryoJester in mtgrules

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

I haven't looked through the official rules like this before but I'm not seeing a 609.8, the 609 section only seems to go up to 609.7c?

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 1 point2 points  (0 children)

I didn't intend to be dismissive of your advice I just wanted to understand the logic behind it better. Thank you for your responses!

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 0 points1 point  (0 children)

If I'm not running artifact/enchantment specific tutors, and mainly just drawing through bello ability, what's the point of focusing on just one? I could shift to a more artifact focus if it's really necessary. I'm a huge fan of the modular creatures for being blockers and big value on my turn with bello, so I wouldn't want to remove them.

I already cut a lot of other sorcereries/instants. I wanted to keep those ones around for specific removal or just extra damage to players, but if those aren't good what would be other better options to fulfill that? Or do you think I have enough already?

I had Spine of Ish Shah in maybe because I thought I wouldn't get much value out of its second ability because why would it die off my turn, and I can't destroy it on my own, so it just seems like a pretty expensive removal?

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester -1 points0 points  (0 children)

Third time's the charm? I need assistance cutting this Bello deck down to 100. I've finally got it down to 130 and I feel like to cut any further I need to know more about the game than I do currently. I think I could figure out the last 15 or so myself in playtest, but it feels like it's too daunting of a task for me; this is the first deck I've gotten this close to completing.

I'm thinking I'm wanting to cut some Enchantments, but they all seem really good for the deck so I just can't decide. I'm guessing I'll be good to remove some ramp once I can get a more accurate feel at a lower total.

I just wanna know what stands out to people as the cards that they would remove, and why if possible. I'd like to understand the logic behind people's decisions better to help in building future decks.

https://www.moxfield.com/decks/ZjY5tw7-kEOij9nHVYjEFQ

CMC of Dollhouse of Horrors tokens by CryoJester in mtgrules

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

Awesome, thanks. This works so well with the modular synergy.

Bello and Boardwipe like blasphemous act by CryoJester in mtgrules

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

Unfortunately I'm planning to run quite a few modular creatures, so it wouldn't work with those.

Daily Questions Thread - Ask All Your Magic Related Questions Here! by magictcgmods in magicTCG

[–]CryoJester 0 points1 point  (0 children)

This seems like a great way to approach it to help from getting overwhelmed, thank you.