| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | |||||
2 | IngressFS Auto Score Sheet | v2.4.1 | |||
3 | |||||
4 | Welcome Agent and thank you for organising an IngressFS Event! | ||||
5 | This sheet and attached form can be used to automate the collection and calculations for FS Stats. | ||||
6 | |||||
7 | Instructions | Instructions | Language: en | ||
8 | In the Toolbar above the sheet, click File > Spreadsheet Settings to change the timezone and locale to your local settings | 1 | In the Toolbar above the sheet, click File > Spreadsheet Settings to change the timezone and locale to your local settings | ||
9 | In the Toolbar above the sheet, click Form > Go to live form | 2 | In the Toolbar above the sheet, click Form > Go to live form | ||
10 | Share the link to the live form with your attendees | 3 | Share the link to the live form with your attendees | ||
11 | At the start of the event, get your attendees to follow these steps: | 4 | At the start of the event, get your attendees to follow these steps: | ||
12 | Go to their agent profile in the scanner, ensure they are looking at their all time stats then click the copy button | 5 | Go to their agent profile in the scanner, ensure they are looking at their all time stats then click the copy button | ||
13 | Go to the form and paste their stats into the Start Stats field then click the submit button. | 6 | Go to the form and paste their stats into the Start Stats field then click the submit button. | ||
14 | As agents submit their stats, verify the data in the yellow Data tab is the same as on their device then tick the start verified box next to their name | 7 | As agents submit their stats, verify the data in the yellow Data tab is the same as on their device then tick the start verified box next to their name | ||
15 | At the end of the event, repeat steps 5, 6 and 7 for End Stats. They'll need to click the edit response link when accessing the form the second time. | 8 | At the end of the event, repeat steps 5, 6 and 7 for End Stats. They'll need to click the edit response link when accessing the form the second time. | ||
16 | Once everyone has checked out, the leaderboard will have the final results of all agents ranked for each stat, falling back to AP gained in the case of a tie | 9 | Once everyone has checked out, the leaderboard will have the final results of all agents ranked for each stat, falling back to AP gained in the case of a tie | ||
17 | The top agent for each stat for each faction is in the top yellow section of the leaderboard and also in the Winners tab | 10 | The top agent for each stat for each faction is in the top yellow section of the leaderboard and also in the Winners tab | ||
18 | Once the event is over, click the Submit Results link on the right to submit your scores | 11 | Once the event is over, click the Submit Results link on the right to submit your scores | Submit Results | |
19 | |||||
20 | Options | Options | |||
21 | Bonus Stat 1 (Optional, Click + on the left to show more) | Bonus Stat 1 (Optional, Click + on the left to show more) | Glyph Hack Points | ||
29 | Remove unverified end stats from leaderboard | Remove unverified end stats from leaderboard | |||
30 | Event Format | Event Format | Regular | ||
31 | |||||
32 | |||||
33 | |||||
34 | Important Information | Important Information | |||
35 | Check the requirements you need to follow: | Check the requirements you need to follow: | Organiser's Guide | ||
36 | Remind your attendees of the requirements they need to follow | Remind your attendees of the requirements they need to follow | Agent Requirements | ||
37 | Take a group photo and post it online following the guidelines | Take a group photo and post it online following the guidelines | Group Photo Guide | ||
38 | Make sure the link to this sheet is publicly accessible in case we need to verify the results | Make sure the link to this sheet is publicly accessible in case we need to verify the results | |||
39 | |||||
40 | If you can't edit this sheet, either follow the create new sheet link below while on a PC or if you're on mobile, click the 3 dots menu button > Share & Export > Create a Copy | If you can't edit this sheet, either follow the create new sheet link below while on a PC or if you're on mobile, click the 3 dots menu button > Share & Export > Create a Copy | |||
41 | For a new copy of this sheet, use this link: | For a new copy of this sheet, use this link: | Create new sheet and form | ||
42 | |||||
43 | |||||
44 | |||||
45 | |||||
46 | |||||
47 | If you need any help or have any questions, you can contact @JordonMizzi in the IFS Slack Workspace or @cluelessness on Telegram | If you need any help or have any questions, you can contact @JordonMizzi in the IFS Slack Workspace or @cluelessness on Telegram | |||
48 | |||||
49 | Technical Information | ||||
50 | If you are brave enough to unhide the hidden tabs, be sure not to even touch any of the form responses because a Google Sheets bug will automatically replace all tab delimiters with spaces and will destroy the submitted data | ||||
51 | |||||
52 | © 2020 | Jordon Mizzi | cluelessness https://cluelessness.net/about-me/ | ||||
53 | |||||