[size=2] Pinglist snipped, adding @Vivarium. [/size]
Happy Riot, hunters! Sorry for the double ping, but we've got a quick spreadsheet correction to make. In cell G19 of the Summary tab (next to Scrolls, etc.), you'll want to paste this code:
[code]=sumif(Loot!S33:S94, "Scroll*", Loot!T33:T94)+sumif(Loot!S33:S94, "Remove*", Loot!T33:T94)[/code]
I'm glad to hear people are enjoying the bookshelf builder! As always, if you spot a bug, please let myself or 3ctoplasm know.
Happy Riot, hunters! Sorry for the double ping, but we've got a quick spreadsheet correction to make. In cell G19 of the Summary tab (next to Scrolls, etc.), you'll want to paste this code:
@dark78660 Hey there. I can't seem to find Congeal
Congeal
Ability Stone
A frigid attack that will imprison the enemy in ice. Has a chance to apply Freeze. (Prevents the enemy from attacking.) May only be used by ice dragons.
500
Required Level: 12
in the spreadsheet at all. Just thought I'd let y'all know. ^^
@/Sunsire I'm sorry about that -- several people are having that problem today and I'm still not sure what's causing it. When I view your sheet, everything is showing up fine. You can try viewing the ref sheet (it's hidden, so go to the "all sheets" button in the lower left) and replace the code in A1 with this:
[code]=importrange("https://docs.google.com/spreadsheets/d/1JjIqxEX2xvBQmNR2s4iyGLMkIih0hGT-rAgzi5dJm2g/edit?usp=sharing", "ref!$A1:$AB600")[/code]
If you have the problem again, you can force the sheet to reload the ref sheet data by changing that 600 at the end of the formula to another number, then changing it back. Sorry to send you into the guts of the code, but it's the only thing I've found so far that works!
As for the Trick-of-the-Light, you'll need to add the hyphens for that to show as valid. Or just start typing and then click/arrow-key to the option in the autofill.
@/Sunsire I'm sorry about that -- several people are having that problem today and I'm still not sure what's causing it. When I view your sheet, everything is showing up fine. You can try viewing the ref sheet (it's hidden, so go to the "all sheets" button in the lower left) and replace the code in A1 with this:
If you have the problem again, you can force the sheet to reload the ref sheet data by changing that 600 at the end of the formula to another number, then changing it back. Sorry to send you into the guts of the code, but it's the only thing I've found so far that works!
As for the Trick-of-the-Light, you'll need to add the hyphens for that to show as valid. Or just start typing and then click/arrow-key to the option in the autofill.