Seeing Fatal Echoes Procs in WCL
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLM
1
1. Find your favourite WCL parse and select the Aff Lock you want to search the proc rate on
2
2. Click on Queries and go to the option "From Paste"
3
4
5
3. Enter "2$Separate$#244F4B $auras-gained$-1$0.0.0.Any$0.0.0.Any$true$0.0.0.Any$true$233490|233496|233497|233498|233499" as the pin and hit Create Pin
6
4. Navigate to Debuffs and then select this option:
7
8
9
10
11
12
13
14
15
5. Click on Events and scroll to the bottom of the page
16
6. Click on CSV at the bottom
17
7. Open a new Google Spreadsheet
18
8. Import > Upload file from PC
19
9a. Should come up with an upload options thing like this (below) -- The options you care about are the last 2 (Separator character and Convert Text to # and Dates)
20
9b. If the Import File options (pictured on the left) doesn't come up you can get around it by doing the following:
Select all of Column A > Go to Format > Number > Automatic
21
10. Go to the Calcs tab and copy the the cells with info in them
22
11. Paste the cells you copied into the uploaded CSV file and you have the info you wanted
23
12. Grab the total # of UA casts from WCL (Damage Done & have Tables selected)
24
13. xD
25
26
Bonus:
27
If you want the cells to be formatted all special like they are in the example...
28
1. Right click on the spreadhseet
29
2. Select "Conditonal Formatting"
Contact:
30
3. Single Colour
Discord Not#5396
31
4. Range: A2:A600
32
5. Format cells if.... use option "Custom Formula Is"
33
6. Enter formula =COUNTIF($A$1:$A$245, INDIRECT(ADDRESS(ROW(), COLUMN(), 4))) > 1
34
Choose whatever formatting style you want
35
36
37
38
39
40
41
42
43
Loading...
 
 
 
Instructions
Calcs
Example 1 (Import Options)
Example 2 (No Import Options)