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

 
View only
 
 
Still loading...
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.


Additionally, please use this form to document any updates.
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
8/20/2012fragma-added leona hotkeys from osteon
13
8/20/2012AmphitAdded the rest of Kog'Maw hotkeys
14
8/20/2012hsurkAdded new Corki Execute (Q)
15
8/20/2012fragmaAdded some bs about ettiquette and excel tips, made document standard 9pt font, please change it if it's too small for you, also Added morehotkeys.txt/utilikeys tab
16
8/20/2012fragmaadded alistar keys.
17
8/21/2012Amphitadded Amumu hotkeys.
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
8/23/2012hsurkAdded Xin Zhao Execute
25
8/23/2012fragmaAdded osteon's Nasus
26
8/28/2012amphitAdded Yorick hotkeys
27
8/30/2012hsurkAdded Ahri combo
28
8/30/2012hsurkUpdated Evelynn E range for latest patch
29
1/9/2012OsteonAdded KassadinPress spacebar to win.
30
9/7/2012hsurkFixed Xin Zhao Execute (HP Included)
31
9/11/2012hsurkkoggy fixed with player_bonusad
32
9/19/2012fragmaadded ugleh to editors...note: use comments now for changelog?
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
Loading...
 
 
 
ChangeLog
Morehotkeys
Hotkeys
LB Functions
Formulas
Rangelist