| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Tutorial - How to use this spreadsheet | ||||||||
2 | language select: | en |  | ||||||
3 | |||||||||
4 | Basics on how to use | ||||||||
5 | |||||||||
6 | Step 0 - Make a copy of the spreadsheet so you can edit it. Go to File > Make a Copy. | ||||||||
7 | |||||||||
8 | Step 1 - Go to Calculator page and select the desired language and desired operator. ( ͡° ͜ʖ ͡°) Step 2 - Select Nikkes on the right to create a set of Nikkes that you want to analyze and use to build your team. You can use filters to hide Nikkes with unwanted characteristics. In this step you can select as many Nikkes as you want. Step 3 - Select the Nikkes using the drop-down menus on the respective slot to create your team. Step 4 - The spreadsheet will provide you with important information about your choices on the left, in the box below the operator. The spreadsheet will also provide you with data on the team's synergy and the buffs received by the team and each nikke. |  | |||||||
9 | |||||||||
10 | Explanation of each area of the spreadsheet | ||||||||
11 | |||||||||
12 | 1 - Language selection 2 - Operator selection 3 - Selection of Nikkes to form the set of Nikkes with which you intend to work. 4 - List of Nikkes selected to build the team, you can select as many as you want at this stage in step 3. 5 - Area where you will select the Nikkes you chose before to form your team. 6 - Area with information on buffs received by DPS Nikkes and buffs sent by support Nikkes. 7 - Area with the score that evaluates the team's synergy. Only DPS Nikkes have synergy points that are added together and make up this total, as they are the ones that best benefit from the buffs offered by support Nikkes. 8 - Area with the evaluation of the system regarding the team formed. Here you can check if your team has all Burst 1,2 and 3 units placed correctly and will have advice on specific Nikkes, as well as an assessment of the team's synergy and DPS/Support ratio. 9 - Area that shows which Nikke the buffs received by the team are coming from and which Nikkes are offering specific buffs that depend on certain conditions for a Nikke to be able to receive them. 10 - Area that lists all buffs offered to the team. 11 - Area that suggests alternatives for the selected Nikkes. Suggestions are based on Nikkes that perform the same or similar function. 12 - Area where you can quickly consult the general information of any team unit. |  | |||||||
13 |  | ||||||||
14 | |||||||||
15 | |||||||||
16 | Important notices | ||||||||
17 | |||||||||
18 | 1 - Ignore the error messages, it only happens because you deselected a Nikke that was already in the team and now this option has become invalid. Google Sheet does not update dropdowns automatically. 2 - Do not edit the CalcData, Database and Database2 pages. 3 - If the text in system notes is too large and does not fit in the cell, try reducing the font size in that cell. 4 - The calculation of the synergy score only takes into account the number of buffs that are being distributed by the team and not the individual kit of each nikke in detail. Improvements will be made over time to make this score more accurate, but the system notes will warn you if there is a problem with mixing Nikkes that should not be together. 5 - The synergy score calculation considers the number of buffs multiplied by a constant which is a number calculated for each Nikke based on its Burst type, Weapon and Class. This formula will be improved in the future. |  | |||||||
19 | |||||||||
20 | |||||||||
21 | |||||||||
22 | |||||||||
23 | |||||||||
24 | |||||||||
25 | |||||||||
26 | |||||||||
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 | |||||||||