| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
1 | Chapter 13 Added | ||||||||
2 | Recent changes in EXP value to better reflect true value taking into account of base production and other variables, refer Calculation Methods | ||||||||
3 | |||||||||
4 | Introduction | ||||||||
5 | Arknights Material Farming List with Drop Rate API Fetcher | ||||||||
6 | This spreadsheet will update drop rates DAILY (using API fetcher) from penguinstats.io to get the latest drop rate updates | ||||||||
7 | This sheet differs from other sheets made by EN players that considers material value is equal to minimum sanity requred | ||||||||
8 | to get one drop, for details on this calculation, refer to Calculation Methods sheet or Reddit link: | ||||||||
9 | https://www.reddit.com/r/arknights/comments/ggdjiu/on_the_calculation_of_material_sanity_value_and/ | ||||||||
10 | This sheet uses similar calculation and approach as CN server's table, but only with EN's current content: | ||||||||
11 | The link below now has calculation specifically for EN/KR/JP and TW server, though without devaluation of EXP from base production and other variables: | ||||||||
12 | https://arkonegraph.herokuapp.com/ | ||||||||
13 | |||||||||
14 | How to use: | ||||||||
15 | ◘ For long run efficiency, use Farming Summary sheet and locate maps that are on the leftmost (under Best Map column) | ||||||||
16 | ◘ For short run efficiency, use Farming Summary and locate maps with Expected Sanity highlighted in BLUE | ||||||||
17 | ◘ This sheet basically functions the same as https://arkonegraph.herokuapp.com/ but due to CN server having maps the EN server | ||||||||
18 | does not, this makes material values slightly different and therefore the changes map rankings and shop exchange rates | ||||||||
19 | |||||||||
20 | |||||||||
21 | |||||||||
22 | |||||||||
23 | |||||||||
24 | |||||||||
25 | |||||||||
26 | |||||||||
27 | |||||||||
28 | |||||||||
29 | |||||||||
30 | |||||||||
31 | |||||||||
32 | |||||||||
33 | |||||||||
34 | Assumptions made for this table: | ||||||||
35 | ◘ If you have absolutely no preference on any type of material you get as subproducts and just want to focus on long term efficiency (this fulfils most player's requirements) | ||||||||
36 | ◘ If your ideal R-I-I-C base setup falls between 2-4-3 and 1-5-3 - hence devalues EXP by 0.78368 of LS-5** | ||||||||
37 | ◘ A workshop byproduct rate of 18% (a range of 15% - 18% is still fair) | ||||||||
38 | ◘ If you have a set of material preferences in mind already, it is better to use ArkPlanner or similar tools | ||||||||
39 | ◘ Does not account for event stages | ||||||||
40 | ◘ Gold Bar value is taken by assuming factory production time relative to XP tickets | ||||||||
41 | |||||||||
42 | ** Refer to Luzark's assumption on R-I-I-C base calculations here: | ||||||||
43 | https://colab.research.google.com/drive/1lHwJDG7WCAr3KMlxY-HLyD8-yG3boazq?usp=sharing | ||||||||
44 | |||||||||
45 | ◘ Why 0.78368 * 0.00386? | ||||||||
46 | This takes into account of base productions and devalues EXP accordingly based on assumptions in the link above. | ||||||||
47 | This will fulfil most players based on the mastery level, operator level, and sanity spent per day. | ||||||||
48 | A player that refreshes sanity using PO will increase their perceived value of EXP because they have less days for the base to produce the required EXP tickets, hence needing to farm LS-5. | ||||||||
49 | |||||||||
50 | Please let me know if you have any questions, suggestions, mistakes or problems. Thank | ||||||||
51 | |||||||||
52 | Discord: | momo.moe | |||||||
53 | Reddit: | u/elmoe0715 | |||||||
54 | Reddit Thread: | https://www.reddit.com/r/arknights/comments/g73rwu/arknights_farming_spreadsheet_with_drop_rate/ | |||||||
55 | Calculation Method: | https://www.reddit.com/r/arknights/comments/ggdjiu/on_the_calculation_of_material_sanity_value_and/ | |||||||
56 | Drop Rates updated: | 4/21/2024 0:52:31 | GMT+8 | ||||||
57 | |||||||||