05-29-2018, 08:12 AM
suggestion: for card numbers and other high numbers (for visual appeal) use custom number formats.
reason: lots of people are "scared off" of stuff that is not visually appealing as well as stuff that involves large numbers.
alt suggestion: in instructions add the guide to manually changing this. (go to format.numbers.more formats.custom number formats."enter format code provided")
examples of this use can be found throughout mystic empires data sheets
another example is this: (modified form of the card counter provided on the fire clan multicalc info sheet)
https://docs.google.com/spreadsheets/d/1...JZS9gif68/
this shows the original format followed by the k format then the k/m format
ex: [>=1000000]#,##0,,"M";[>=1000]#,##0,"K";0
changes numbers to 100, 1k, 1m etc
ex: [>9999]###,#,"k";;#,##
changes numbers to 100, 1k, 1000k etc
*note: if done properly these do not affect calculations as it is just a visual change.
ex: the number 45598 will still be 45598 for calculations but visually will be shown as 46k
reason: lots of people are "scared off" of stuff that is not visually appealing as well as stuff that involves large numbers.
alt suggestion: in instructions add the guide to manually changing this. (go to format.numbers.more formats.custom number formats."enter format code provided")
examples of this use can be found throughout mystic empires data sheets
another example is this: (modified form of the card counter provided on the fire clan multicalc info sheet)
https://docs.google.com/spreadsheets/d/1...JZS9gif68/
this shows the original format followed by the k format then the k/m format
ex: [>=1000000]#,##0,,"M";[>=1000]#,##0,"K";0
changes numbers to 100, 1k, 1m etc
ex: [>9999]###,#,"k";;#,##
changes numbers to 100, 1k, 1000k etc
*note: if done properly these do not affect calculations as it is just a visual change.
ex: the number 45598 will still be 45598 for calculations but visually will be shown as 46k