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.017.01.2021added checking for using vs. undead usage on non-ud mob
28
export frost resi1.3.229.01.2021"world buffs": MASSIVE OVERHAUL with lots of new things
29
export validate log1.3.3a07.02.2021"fights" & more: improved raid start calculations (incl. fix)
30
export fights1.3.3b16.02.2021"world buffs": fixed a bug where absolute values were off
31
Limitations:1.4.104.03.2021"world buffs": now startable for a part of the raid
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.no1.4.205.03.2021also deleting the default sheet if language is non-English
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.no1.4.409.04.2021deleting the Start buttons on the generated sheets
34
Guide to update to a newer version:Click here for a YT video1.4.523.04.2021fixed the spell ids for world buffs (Rend/Ony/ZG heart)
35
1.4.601.09.2021changed all boss and zone ids to their new values
36
---------
37
2.0.018.11.2021now supports Season of Mastery and Classic Era
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 theported a lot of functionality from the TBC version back to this
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.212.12.2023"validate" & "fights": supporting Blackfathom Deeps
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.3a15.02.2024"validate" & "fights": supporting Gnomeregan
41
2.0.3b10.04.2024"validate" & "fights": supporting Sunken Temple
42
2.0.3c11.07.2024"world buffs": added Might of Stormwind
43
The Role Performance Breakdown (RPB):https://docs.google.com/spreadsheets/d/1KJft2ve1a96PWSifj5xFXkhA_VncG-c0kXXmux_n4g0current version:2.0.3c
44