I know this thread is kind of old but I'm just now discovering it and thought I could get some advice.

We were interested in tracking some caps for iLVL and thus started the following spreadsheet:
https://docs.google.com/spreadsheet/...M195bWc#gid=33

So my question for the OP (or anyone else) is was this script intended to be run once for a static capture via cut and paste into another sheet? The problem is leaving the function in the sheet makes is constantly update and therefore break from excessive execution (Google's limit).

Does anyone have a suggestion of how I could maybe tie the function to a button that would run only manually? Would it be better to hardcode the player roster into the script and tie it to a button that way? I know it's a little above and beyond the intent of the script but I thought enhancing our spreadsheet could help others guilds or players in the same boat.

Thanks in advance for any help or suggestions.