Fire Clan IOU Multicalc

[Hazard]

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.