ABCDEFGHI
1
Chapter 11 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: 🍑Moe🍑#2568
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/26/2023 19:24:49GMT+8
57