Thread Rating:
  • 5 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: 3550+
Reply
Hi there! I added some stuff to the "Party" tab.
I made a custom script that updates your DPS in the party tab. I don't like having to manually change the value every time, but directly linking it to the DPS tab causes the sheet to recalculate everything, which takes time and is resource intensive. The script is:
Code:
function update(){
 var cell1 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Party").getRange("J4");
 var cell2 = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Party").getRange("K4");
 var dps = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Main").getRange("R3").getValue();
 var dpsNum = dps.slice(0, dps.indexOf(" "));
 var dpsExp = dps.slice(dps.indexOf(" ") + 1);
 cell1.setValue(dpsNum);
 cell2.setValue(dpsExp);
}
You can follow the instructions here to find out how to insert a button.

I also added a dropdown menu by each user other than myself for "asleep" users. If the user is asleep (not dealing damage), you just switch the "No" (not asleep) to "Yes" (asleep). Then, the user is no longer dealing damage. To do this, you need to edit the function on Z4, Z5, and Z6. For Z4 (the first user), change the code as follows:
Code:
Old:
if(K7="Qi",J7*10^18,if(K7="Qa",J7*10^15,if(K7="T",J7*10^12,if(K7="B",J7*10^9,if(K7="M",J7*10^6,if(K7="K",J7*10^3,J7))))))
New:
=if(L7="No",if(K7="Qi",J7*10^18,if(K7="Qa",J7*10^15,if(K7="T",J7*10^12,if(K7="B",J7*10^9,if(K7="M",J7*10^6,if(K7="K",J7*10^3,J7)))))),0)
K7 is the spot where I put my dropdown menu.
Hi there! Level 821, member of Nubkillers. Not very active, so don't expect much from me.
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)