League of Legends - Short Stories

	A	B
1	League of Legends Short Story Analysis
2	A look at structure and form for Riot's published short stories.
3	Welcome to my Leage of Legends Short Story Spreadsheet! Thank you for looking. Feel free to peruse as you like.
4	There are a few different types of tabs:
5	datasets - the following are available for download from Kaggle or my website:
6		lol_ss_main_dataset
7		lol_ss_writers_dataset
8		lol_ champions_by_region
9		lol_champions_sstory_spread
10	my working data - where I'm actively messing around and where I keep track of the stories I've read vs the ones I still need to. I WILL READ THEM ALL!
11	Pivot Tables - where I worked with the data to pull out the parameters and metrics for the short stories
12	Chart Tabs - for finalizing visualizations
13
14
15
16
17	Sources: The primary source for this information is Riot Games - League of Legends, Universe website - https://universe.leagueoflegends.com/en_US/ (also source of header and thumbnail image) Supplemental information was also pulled from Fandom's League of Legends Wiki - https://leagueoflegends.fandom.com/wiki/League_of_Legends_Wiki Also included, the short stories from the book - League of Legends: Realms of Runeterra (Official Companion)
18
19	Collection Methodology: The main fields (title, region, writer, date_published, and link) were pulled straight from lists on the universe webpage and put into a Google Sheet (with split-text-to-columns helping clean it.) I looked at the JSON (index.json) for each short story's webpage to get the word count and minutes-to-read as well as confirm writer and publish date. To help fill in the blanks I also cross referenced the short stories to the Fandom Wiki for League of Legends (mostly for the writers/authors and region.) For the pov and tense (simplified to past/present/mix/-) I determined these by looking at and evaluating the stories myself - and so recognize these have the greatest chance for error. (If you have an alternate suggestion, please let me know!) note: I have limited this dataset to the short stories Riot has published on their Universe website and the ones in their League of Legends: Realms of Runeterra (Official Companion) book. To get word counts from the book, I scanned them with the CamScanner android app using their to-text feature. I then put that into a google doc, cleaned the errors in text translation and pulled up the word count for the doc. (These have not and will not be shared, as they are from published material. I only took these steps to get the word count.)
20
21	Places Dataset is shared:
22	Kaggle
23	BigQuery
24	Google Data Studio
25	Tableau
26	dreametching.com
27
28
29
30
31
32
33
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
89
90
91
92
93
94
95
96
97
98
99
100