LogFAQs > #905578036

crazygamer999 posted...

I would have 1 column for the number amount of each unit, and then YES columns for 7* and STMR.

That way we can make formulas for
-how many have the unit
-how many copies total across the board
-how many have 7*
-how many have the STMR.

That would be better for calculations, but the spreadsheet would get really big and bloated then, since we'd have 3 columns for each unit. Depends on what the actual use of the spreadsheet is for though, since I don't know the original intent.

If it's just for showing who has what in case someone needs help, color coding will be a lot faster for people to skim and get what they need. If it's for calculations color coding is terrible because you can't use it for auto calculations, so additional columns is the better method.

Anyone know what the purpose of the sheet is?
---

FFBE IGN Zero, Whatever I have that best fits the current content. Everything else available on request.