Quest Reward List

Thank you for the feedback.

I did not intend for it to become a competing sheet but proposed format changes to the existing version. The primary goal was to colour code the rewards in its current state to promote ease of use.

Format changes have now been applied to original sheet.

Looks good! I assume, the V2 sheet is obsolete and gone? (just noticed that it didnt load but forces me to login)

Yeah, the V2 sheet was just used for setting it up. I have removed the links and made it private now to prevent confusion.

Thanks Zanarhi it is already looking a lot better.

Is there any way we can get the document to auto-format when we insert new data? For instance if I were to type in "Ice Nova" then the text would automatically be blue?

Uh I think this would be difficult to handle, well maybe if there's a way to predefine all Skills to just select them, like from a list... but even then; I think the formatting doesnt come from the data but from each cell..? I'll try to catch some infromations about gdoc, maybe I can figure something out.

Google Docs is very limited in functions so there is not much that can be done. Conditional formatting would work, but the rule set only supports 10 conditions total, so a whole lot of entries would be left out.

Copy + Paste does preserve formatting however so that may be an option. I'll look into making a quick reference table for finding entries quickly, then you can copy and paste a list up.

I've added a third tab to the sheet with a quick reference table for finding skills. All you need to do is copy and paste up a list in the open space above, and when complete paste over to page one and set background colour to indicate it has been updated.

Edit: Actually the background colour for the table can be set to whichever colour we are using to indicate current data to save that time as well.

looks good so far! (not tried to copy anything)

I wasn't sure if I had to get permissions to add directly to the google spreadsheet. Anyways, here's the list of gems my marauder was presented for the medicine chest in cruel:

Stun
Weapon Elemental Damage
Melee Damage on Full Life
Added Fire Damage
Life Gain on Hit
Additional Accuracy
Increased Duration
Item Quantity

Edit: I just noticed that some of the cavern of woe gems for cruel on a marauder differed from what is on the list. Here is what I have:

Weapon Elemental Damage
Added Fire Damage
Increased Duration
Item Quantity
Stun
Melee Physical Damage
Blood Magic
Life Leech