ABCDEFGHIJKLMNOPQR
1
2
2
EVENT ANALYSIS
3
Enter Analysis Data Here to update above more easily. Rearranging things may or may not break it the data pull. Generally, will only edit yellow text boxes and sometimes turquoise cells
4
5
INSTRUCTIONS
6
Do not move these tables around, otherwise the Table Lookup Range will be incorrect. If necessary, be sure to modify the lookup range after making modifications to the layout.
Updating this sheet will update the entirety of the submissions and view only sheets
7
8
DO NOT CHANGE
9
Event Common Info:https://docs.google.com/spreadsheets/d/1su2GKPlUJ4uB8Vkdck4wgIwQYINMEBz4kcWSSlhDKtkMats Page:Export SheetMats Interval:A:G
10
11
Event NameNode Info --> Imported into other sheetsEvent Items ID
12
Fate Requiem CollabGacha SetupNotesTypeIDNameBonus Step
13
5* Servant5* Servant 1
Sheet name is imported into
Premium 1E2203A
14
Current Submission Sheet Link5* Servant5* Servant 2
the analyses sheets
Premium 2
15
https://docs.google.com/spreadsheets/d/1_RGMcA_aqua5ZBDXBaq3XIyK_mmuVFLg97kIalaRUg4/edit#gid=18747828365* Servant5* Servant 3Premium 3
16
Analysis Sheet (add here) 4* Servant4* Servant 1
Update node # on a submission
Premium 4
17
https://docs.google.com/spreadsheets/d/184b2XZm4rTZ0BNJHKxnW91v4zL8L0PtURuLf4UKaa-A/edit#gid=04* Servant4* Servant 2
sheet to import the appropriate
Premium 5
18
AP Efficiency Calculator4* Servant4* Servant 3
node info into that section
Premium 6
19
3* Servant3* Servant 1Premium 7
20
Drop Serializer3* Servant3* Servant 2
Unused nodes can be deleted
Premium 8
21
https://apps.atlasacademy.io/drop-serializer/3* Servant3* Servant 3
from the event sheet, just not
Premium 9
22
Reddit Post5* CE5* CE 1the templatePremium 10
23
5* CE5* CE 2Currency 1E220311
24
5* CE5* CE 3Currency 2E220321
25
Wikia Link4* CE4* CE 1Currency 3E220331
26
4* CE4* CE 2Currency 4E220341
27
Cirno Link4* CE4* CE 3Currency 5E220351
28
3* CE3* CE 1Currency 6E220361
29
3* CE3* CE 2Currency 7E220371
30
Guide 1 LinkName/Author3* CE3* CE 3Currency 8E220381
31
3* CE3* CE 4What does column H say?Currency 9E220391
32
Guide 2 LinkName/Author
Only pick one....
Currency 101
33
JP DataPoints 10.3
34
Guide 3 LinkName/AuthorNA OriginalPoints 20.3
35
KazemaiPoints 30.3
36
HELLA HELPDate of threadN/A
37
38
Event Dates & Times (In UTC)Atlas Academy Invite
39
Part 2 SubmissionsNow26/03/2024 15:16:45Days to ThenHours To ThenNat AP remain40 AP remainhttps://discord.gg/sSapWHU
40
Start Date06/05/2022 01:00:000.00.000Event PSA Doc
41
Time Lock 107/05/2022 21:00:000.00.000https://docs.google.com/document/d/1cXMNc24p0rVVWhLbHzE-6lhKhTxiOtC-fLrW8iNu3lc/edit
42
Time Lock 209/05/2022 21:00:000.00.000Read Me First
43
Time Lock 310/05/2022 21:00:000.00.000https://docs.google.com/document/d/1QV51WxeQHfGf2vqhWAuwO_Ogp-sQCh2H1FKHYGpFz2M/edit?usp=sharing
44
End Date19/05/2022 23:59:000.00.000How to track runs
45
This equation works for ANY time, but lacks hard-stops or static values
https://imgur.com/a/KmUTJ
46
Eqn for time until next section
0 days
Eqn for AP in section
0
47
48
Updates from the Mods
49
50
51
52
53
54
Event Setup Checklist
55
Done / NotSetup Page
56
1Event Name
57
2
Submissions and Analysis sheet link
58
3
Node Names, AP Cost, Sheet Location
59
4Event Time
60
5Currency Info
61
6Gacha Info
62
7
Other data source tick
63
8
Wikia/Cirno pages
64
9Guides pages
65
10
Drop Serializer Pages
66
11
Part 2 Submissions (if exists)
67
Gacha
68
1Hide Rows
69
Submissions Page
70
1
Duplicate Pages as needed
71
2
Set Node numbers @ Column E
72
3
Change Mat ID @ Column C
73
4
Change Quantity @ Column I
74
5
Add columns by selecting the entire column and "Insert 1 above/below"
75
7
Delete columns and unused nodes as needed
76
8
Widen Column H as needed
77
9
Add Secondary Data as available in % Droprate
78
10
Hide columns A-E, L
79
11
Hide columns in Material/Currency Drops as needed
80
Calculations Sheet
81
1
Set the Submissions sheet link
82
Others
83
1Reddit Post
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100