| A | B | C | D | E | |
|---|---|---|---|---|---|
1 | |||||
2 | IngressFS Auto Score Sheet | v2.8 | |||
3 | |||||
4 | Welcome Agent and thank you for organising an IngressFS Event! | 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. | 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 | Copy the URL of this spreadsheet and paste it in the "Score Sheet URL" field on your event registration form so that the leaderboard data will be displayed on your event page. | 10 | Copy the URL of this spreadsheet and paste it in the "Score Sheet URL" field on your event registration form so that the leaderboard data will be displayed on your event page. | ||
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 | Bonus Stat (A) | |||
22 | Bonus Stat | Bonus Stat (B) | |||
23 | Bonus Stat | Bonus Stat (C) | |||
24 | Bonus Stat | Bonus Stat (D) | |||
25 | Bonus Stat | Bonus Stat (E) | |||
26 | Bonus Stat | Bonus Stat (F) | |||
27 | Custom Stat | Custom Stat (G) | |||
28 | Bonus Calculated Stat Formula (click for more info) | Bonus Calculated Stat Formula (click for more info) | e.g. A - B | ||
29 | Bonus Calculated Stat Name (Optional) Leave blank to use: | Bonus Calculated Stat Name (Optional) Leave blank to use: | |||
30 | Remove unverified end stats from leaderboard | Remove unverified end stats from leaderboard | |||
31 | Event Format | Event Format | Regular | ||
32 | |||||
33 | |||||
34 | |||||
35 | Important Information | Important Information | |||
36 | Check the requirements you need to follow: | Check the requirements you need to follow: | Organiser's Guide | ||
37 | Remind your attendees of the requirements they need to follow | Remind your attendees of the requirements they need to follow | Agent Requirements | ||
38 | 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 | ||
39 | 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 | |||
40 | |||||
41 | 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 | |||
42 | If you can't fill in the form, that means you've given the worng link to your attendees. Click on the Preview button on the top right of the page to view the live form, THAT is the link you should be sharing with your attendees to fill in. | If you can't fill in the form, that means you've given the worng link to your attendees. Click on the Preview button on the top right of the page to view the live form, THAT is the link you should be sharing with your attendees to fill in. | |||
43 | Before your event, make sure the settings on the form are correct. Click on the Settings cog in the top right corner •Make sure Limit to 1 Response is ticked •Make sure Edit After Submit is ticked If these settings are not ticked, the form will not work for your attendees If attendees are having issues with submitting their end stats, read step 8 above. | Before your event, make sure the settings on the form are correct. Click on the Settings cog in the top right corner •Make sure Limit to 1 Response is ticked •Make sure Edit After Submit is ticked If these settings are not ticked, the form will not work for your attendees If attendees are having issues with submitting their end stats, read step 8 above. | |||
44 | 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 | ||
45 | |||||
46 | |||||
47 | |||||
48 | |||||
49 | 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 | |||
50 | |||||
51 | Technical Information | Technical Information | |||
52 | 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 | 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 | |||
53 | |||||
54 | © 2020 | Jordon Mizzi | cluelessness https://cluelessness.net/about-me/ | ||||
55 | |||||