Squink's Tournament History Template

	A	B	D	E
1	ver. 1.0.7 \| Last Updated: April 30, 2023			Discord: Squink#7672
2		Squink's Tournament History Template
3		Adapted from zibi's tournament sheet with permission
4
5
6		Welcome to my tournament sheet! Be sure to check back here from time to time as I'll be constantly updating the sheet and making future versions backwards compatible
7		Here's my personal tournament history sheet if you want to see how it looks in use (incomplete)	Features:
8			• Supports up to 16 player teams
9		Step 0:	• Auto updating player info and ranks
10		From the top left select File -> Make a copy	• Cover page w/ player info (coming soon!)
11		Save a copy wherever you'd like	• Matches history w/ stats (coming soon!)
12			• Scheduling tab synced with ongoing tournaments (coming soon!)
13		Step 1:
14		Go to https://old.ppy.sh/p/api and request an API key	• Advanced stats page (coming soon!)
15		The App Name and URL you choose to use does not matter	• Advanced stats page (coming soon!)
16		Note: if the link doesn't work google search 'osu!api', click on the first 'osu!api · wiki' link & click on the hyperlinked
17		application page link
18
19		Step 2:
20		At the top of the spreadsheet open the 'Sheet Management' tab
21		Click on the first option 'Authorize Scripts'
22		On the google verification screen click on the 'Advanced' button click 'Go to Tournament Sheet Scripts (unsafe)'
23		Click allow on the next screen
24
25		Step 3:
26		In the 'Sheets Management' tab select API Management -> Add API Key
27		Enter the API key you got in step 1
28		A message will appear if the API key worked successfully
29
30		Step 4:
31		Start by entering your osu ID or username into the yellow cell in the 'players' sheet
32		NOTE: If you're using this sheet for a community, and not personal use, select row 2 and delete it first.
33		NOTE: If you want to add tournaments with more than 8 players per team click the little + button found above the top
34		row in 'Tournament History' and 'tourneys'
35
36		Step 5:
37		The sheet is now ready for use and you can begin entering data into their respective columns, be sure to enter your
38		teammate IDs or usernames into 'players' sheet in order for them to automatically populate in 'tourneys'
39		Hide 'Welcome', 'tourneys' and 'players' sheets whenever you're finished making changes and unhide as needed
40		Click the green 'Share' button in the top right and change general access to "Anyone with the link" with the role "Viewer"
41
42		Contact me on discord (Squink#7672), osu! or twitter for support, comments or suggestions
43
44