ABCDEFGHIJK
1
2
Please follow the instructions on the Instructions sheet and don't request permission on the template/master spreadsheet. Thanks for your interest in the CLA! <3
3
link to the original, updated version in case this is a copy:
https://docs.google.com/spreadsheets/d/1xmKGPH0TGfKtqHh0MufxUd_KU-gh2A7Y3AYNqWFdzgU
4
5
7 Steps to make it work:How-to video: https://www.youtube.com/watch?v=QOQH5itbrgQInsert your information here
Discord
6
7
1.If this isn't a copy already: Make a copy of this entire spreadsheet (File -> Make a Copy).
8
9
2.Scroll down on https://classic.warcraftlogs.com/profile. Enter "CLA" or "RPB" in "V1 Client Name" and hit Set, then copy "V1 Client Key" here:
10
11
3.Open the report you want to run the Role Performance Breakdown (RPB) for and enter the url or id of that ClassicLog here:
12
13
4.Adjust if report titles should be appended to all generated sheet names (default: deactivated): For any questions, ideas or suggestions please contact me:
14
15
5.Enter a Discord webhook to post the generated spreadsheets in a channel (optional): emailmaag.lars+cla@gmail.com
16
17
->Go to the first sheet you want to run and adjust the settings you want to change. discordshariva
18
19
6.Click the button "Start" on that sheet and grant permissions (maybe use a dummy account; source code: -> Tools => Script Editor), then click the button again and wait (takes ~20-120s per sheet). wotlk versionhttps://docs.google.com/spreadsheets/d/1Yf7yUccShV797H5jIT3Efq9hheMCKrUoxca55XOaDO4
20
21
7.Start all the sheets you want to run and wait for everything to be generated. Then select which sheets should be copied to the shareable spreadsheet (no api key etc.). Afterwards click "START export".
22
23
->After everything is finished you will see the url below this text and if you provided a webhook the shareable spreadsheet will be posted on Discord. Changelog (only the shortened most recent changes, more on Discord):
24
25
export gear issues1.1.8f11.01.2021"frost resistance": now also startable for Kel'Thuzad
26
export ignites1.2.012.01.2021you can choose if report titles are part of the sheet names
27
export world buffs1.3.229.01.2021"world buffs": MASSIVE OVERHAUL with lots of new things
28
export frost resi1.3.3a07.02.2021"fights" & more: improved raid start calculations (incl. fix)
29
export validate log1.3.3b16.02.2021"world buffs": fixed a bug where absolute values were off
30
export fights1.4.104.03.2021"world buffs": now startable for a part of the raid
31
Limitations:1.4.601.09.2021changed all boss and zone ids to their new values
32
a)This spreadsheet generator only pulls data from the WarcraftLogs API. WarcraftLogs itself is limited by the WoW Combat Log and only tracks what's used in combat.no---------
33
b)The only way to hit the Start button on mobile is to open the spreadsheet in your browser's desktop mode! Unfortunately all other start options don't work due to Google's limitations.no2.0.018.11.2021now supports Season of Mastery and Classic Era
34
2.0.212.12.2023"validate" & "fights": supporting Blackfathom Deeps
35
2.0.3a15.02.2024"validate" & "fights": supporting Gnomeregan
36
2.0.3b10.04.2024"validate" & "fights": supporting Sunken Temple
37
2.0.3c11.07.2024"world buffs": added Might of Stormwind
38
Due to the high traffic this produces on WarcraftLogs you are limited to 3600 points spent per hour if you are not subscribed to WCL. A sheet's cost varies a lot, but generally it's hard to hit the2.0.513.12.2024adding fresh.warcraftlogs
39
hourly limit. It's no issue unless you want to create sheets for many reports in quick succession. In any case consider spending at least 1$/month on WCL which gives you 36.000 points/h!2.0.5a19.12.2024better support for MC fresh
40
WCL's Patreon (NOT MINE!): https://www.patreon.com/warcraftlogsCheck your used hourly points here:https://classic.warcraftlogs.com/profile (scroll down)2.0.5b29.01.2025"gear issues": new option to show players with no issues
41
2.0.603.02.2025"world buffs": better values when booning infight
42
2.0.6a25.02.2025"fights": supporting fresh.warcraftlogs for the second log id
43
The Role Performance Breakdown (RPB):https://docs.google.com/spreadsheets/d/1KJft2ve1a96PWSifj5xFXkhA_VncG-c0kXXmux_n4g0current version:2.0.6a
44