LB Useful Hotkeys and Calculations
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRST
1
Note: This is a living document currently being edited by Fragma, Amphit, Valdorian, Hsurk, Osteon and Ugleh. Any currently contributing member of LB may request access to edit this spreadsheet for everyone's benefit. Please PM "Fragma" on the forums with your gmail/google docs email you would like to use to edit this document.

Excel Training:ETTIQUETTE NOTE: Please ensure if you copy a key/formula into this document that you give attributions to the original creator and link to their forum post for convenience. Additionally, if you choose to use images, please upload them directly to imgur and reference them from there, please do not reference images directly from any vendor website including leagueoflegends as it is a drain on their resources and poor nettiquette...
2
DateForum IDUpdatesEditor Comment 1Editor Comment 2Key/formulaInformation
3
8/15/2012FragmaLocked columns and rows, made top column filterable for ease of use.Formulas for lazykeysLazykeys are easy, the formula is "=keypressed#&" "&formula#" without quotes, for example, on hotkeys it's '=Brownum&" "&Drownum' (ex. =B2&" "&D2)
4
8/15/2012ValdorianAdded Ahri, Akali, Katarina.&The & symbol will append multiple rows/text together in a formula, in the example above it adds a space between the two rows being referenced.
5
8/17/2012FragmaAdded _ALL_ champion images for aesthetics"="The = symbol starts a formula and is an easy way to reference cell data or in general insert an image.
6
8/17/2012FragmaAdded Cho'gath from hsurk's posting"=image("url",3)"You can read more on the google page for all info, this is how I added images, I used the = for formula, image to define an image type, "URL" is for the full URL to the image and 3 is the image resizing field, 3 specifies to keep the image in it's original size when inserting, 1, 2 and 4 are other options (google them or test yourself.)
7
8/17/2012FragmaAdded volibear from Amphit's postingMulti Row SizingSelect Multiple rows, then drag and size, this will shrink the row height to the lowest possible
8
8/17/2012FragmaaAlt+EnterUsing this inside a cell inserts a carriage return or newline
Like this for example
9
8/19/2012ValdorianAdded Ezreal.Multi Row FormattingMake 2 rows the alternating colors you want, select those 2 rows, select copy or ctrl-c, then select all cells you want to format, to to edit -> Paste Special -> Paste Format Only to format all selected rows in alternating colors
10
8/19/2012ValdorianMade original-links smaller for better overview.Reference another sheetYou can reference data in another sheet using the formula ='Sheet Name'!Cell, this is useful is you want to reference the rangelist directly in a formula (e.g RANGE='Rangelist!D4') NOTE: This requires you to actually make the entire row a formula and concatenate the hotkey using &
11
8/19/2012hsurkAdded Corki, Evelynn, Irelia, Jax, Kogmaw Execute
12
13
8/20/2012AmphitAdded the rest of Kog'Maw hotkeys
14
15
16
17
18
8/21/2012Fragmaadded riven hotkeys from osteon, caitlyn from xkjtx
19
8/22/2012hsurkAdded Keywords sheet. Needs revision, update with new keywords and maybe better formatting/layoutOk, done and done!Looking ace -hsurk
20
8/22/2012hsurkAdded Brand, RengarHold X to win -hsurk
21
8/22/2012fragmaadded kassadin keys, updated keywords/functions with info from help page, added new game variables from 08/22 update to keywords page, added rangelist, started playing with autorange hotkeys to make them always updated
22
8/23/2012fragmaAdded all champion skill ranges from LoL website, needs autoattack ranges now...will work on a lazyrangelist later
23
8/23/2012hsurkAdded autoattack ranges, quick fixes at other ranges
24
25
26
27
28
8/30/2012hsurkUpdated Evelynn E range for latest patch
29
30
9/7/2012hsurkFixed Xin Zhao Execute (HP Included)
31
32
33
9/19/2012UglehAdded USESELF, SETTARGET, CLEARTARGET, and USETARGET to LB Functions. First edit, someone should check if I did it right, its at the bottom of LB Functions.
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88