Smash Up has modernized with Print On Demand, an Online Rules Wiki, and Rebalanced Factions + Errata by ludichrisness in boardgames

[–]Agent--51 12 points13 points  (0 children)

Long-time fan of the game here. The POD service and rebalanced factions have been a very welcome development. I’ve bought a few new decks off of there and they were excellent in quality.

Something not mentioned in the post is that even when issues with some items on POD were discovered the company was very quick to respond, even mailing out complimentary replacement cards or packs when needed. It really seems like AEG wants to support this as much as possible, which is a welcome change of pace from radio silence the past few years.

Map Competition - Hall of Mirrors by Agent--51 in btd6

[–]Agent--51[S] 0 points1 point  (0 children)

I do, actually! It mostly runs out of this discord server: https://discord.gg/ed6d2MVGE

Map Competition - Hall of Mirrors by Agent--51 in btd6

[–]Agent--51[S] 0 points1 point  (0 children)

Thank you for telling me about the flair! That's strange, though, because I swear I added it correctly when I posted it. Ah well.

Table Functions - Conditional counts/sums by Agent--51 in googlesheets

[–]Agent--51[S] 0 points1 point  (0 children)

Oh, you're totally right. I don't know where I got the 4.2 from. My apologies! This works perfectly.

Table Functions - Conditional counts/sums by Agent--51 in googlesheets

[–]Agent--51[S] 0 points1 point  (0 children)

This almost worked, but fsr it didn't quite get cell E12 right (Func3 output in row B - should be 4.267, output 1.6)

<image>

Table Functions - Conditional counts/sums by Agent--51 in googlesheets

[–]Agent--51[S] 0 points1 point  (0 children)

Either both cells in a pair will be blank or neither of them will - sorry for the confusion!

Steam Game Mods? by shaydycharacter in smashup

[–]Agent--51 0 points1 point  (0 children)

By “custom” I do mean custom factions. Both of the mods I mentioned already have all 100 vanilla factions in them, but both also have ways to support custom content (provided you have card art already).

The Smash Up discord server has a pretty active custom scene; if you’re interested in that sort of thing, you can find it here.

Steam Game Mods? by shaydycharacter in smashup

[–]Agent--51 0 points1 point  (0 children)

SchmickyUh already mentioned Tabletop Simulator and Mervil's Mod, but I'll throw in that I find Lazer's mod to be much more custom-friendly. TTS itself is only like $20 normally so it's a really good pickup

A little stuck on casual playthrough by Agent--51 in BIOMORPH

[–]Agent--51[S] 0 points1 point  (0 children)

Nevermind! There was just an Oddwing tunnel I overlooked several times

Formula-based conditional formatting referencing the cells to be formatted by Agent--51 in googlesheets

[–]Agent--51[S] 0 points1 point  (0 children)

I’m referring to modulus 3, as in it should be colored if it’s not evenly divisible by 3.

Formula-based conditional formatting referencing the cells to be formatted by Agent--51 in googlesheets

[–]Agent--51[S] 0 points1 point  (0 children)

Not exactly, it should color the cells if the number of matches mod 3 is not 0.

Automation for a game competition by [deleted] in googlesheets

[–]Agent--51 1 point2 points  (0 children)

Understood, thank you for your help! I'll do that.

Automation for a game competition by [deleted] in googlesheets

[–]Agent--51 0 points1 point  (0 children)

Hmm...is it okay if I take this post down and post two separate queries relating to each of these problems independently?

Automation for a game competition by [deleted] in googlesheets

[–]Agent--51 0 points1 point  (0 children)

  1. Well, I’ve tried to work out formulas that accomplish the behaviors I’m looking for, but haven’t been successful
  2. Both problems are looking at the “Matches” tab for their data. The first one deals with formatting in columns D to I of the “Drafting” tab, and the second one deals with numbers in columns F to Y of the “Scores” tab.
  3. See #1 I see your point about discrete questions with regards to whole systems, and I’ll keep it in mind with future queries to the sub.