Thread Rating:
  • 4 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Fire Clan IOU Multicalc
7.1.0 and "a" version in pets tab upgrade selector " 1 lvel" dont work - reset all values to 0 on list
Reply
(05-17-2018, 06:43 PM)damador Wrote: 7.1.0  and "a" version in pets tab upgrade selector  " 1 lvel" dont work - reset all values to 0 on list

Porkbob fixed this in 7.1.0b
A leader of Fire Clan
Reply
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
Reply
@TyhmaAave, yesterday I implemented that for the pet sheet dps/pp values. A good candidate because numbers didn't scale as hard, still in the 100M range for me and it works well until 100-1000B dps/pp range. Also, space is limited in the pet map. Quite a big UX change for readability.

We used,

[>999999999]#,###.00,,,"B";[>999999]#,###.00,,"M";#,##0

One big drawback of custom number formatting is that it doesn't scale. You have a very limited number of conditions.

What numbers are an issue for you? Most things support K-Qi.

One thing about the card tracker is that all digits can be quite significant when you're doing packs. I used to use a mix of medium and small. Easier now though that porkbob implemented the more advanced pack selection.
A leader of Fire Clan
Reply
Custom number formattings are really nice, unfortunately googlesheets only supports having 4 different ones. We tried ages ago, the solution we have now is having visual cells that manually append formatting, but this makes it a bit awkward and adds extra cells.

I'm wondering if scripts could bypass this
Status: Leader of Fire Clan Level: 2200+
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)