AB
1
BDM Enhancement Black Stone Datasheet - Advanced Copy by covertrui
2
3
I don't have the time to clean up the sheet daily, so I'll be locking the edit permissions.
Please save a copy (File -> Make a Copy) for personal use instead :) Thanks!
4
Instructions
5
1. See each calculation sheet for individual instructions. Blue highlighted cells are where data input is needed for the calculator to function.
6
2. Unprotected ranges are currently:
7
......a. Sheet "Black Stone Ratios" Columns "Real Data" (C:C, F:F, J:J, N:N, P:P, Q:Q) empty cells only
8
............i. Currently looking for data on Restoration Costs! Please include screenshot! If you choose to restore, please also include Memory Fragment EXP!
9
......b. Sheet "Basic Black Stone Optimizer" ranges for user input (B1:B3, B7:E7, B10:E10)
10
......c. Sheet "Data Converter" highlighted areas to find out raw data
11
3. When inputting data, indicate with bold text which value is the raw data.
12
......a. Indicate using a note the calculation of the raw data value
13
............i. For example:
14
..................O+34: 100% = G*666 + F*9 + P*3
15
..................or
16
..................O+18: Restore Cost XXXXXXXX for 1% to 7.1%, Raw Cost XXXXXXXX*(7/7.1)
17
..................etc
18
......b. Check that the truncated value of the raw data matches the given decimal as a sanity check
19
20
Notes
21
1. Sheet "(Real Data Version) Black Stone Counter Chart" tests if the "Real Data" value is blank
22
......a. If the value is blank, it returns calculations based on the given truncated value
23
......b. If the value is present, it will calculate using this more accurate "Real Data" value
24
2. Sheet "(Real Data Version) Black Stone Counter Chart" therefore changes its bolded or red values based on the above calculations
25
......a. Red values indicate a wasted black stone as the exp passes 100%
26
............i. Ideally as we move to real data, there will no longer be red values as each level can be perfectly added by poor stones.
27
3. The fit so far is not perfectly exponential/logarithmic, but close. There's a slight arch to the plots "Modeling by Good BS" and "Level by Poor BS"
28
29
Coming Soon
30
1. Optimization of switching gear grades using given most optimal feeding and most optimal restorations at any given level
31
......a. Will need full Restoration data, then combine Basic Black Stone Optimizer, Restoration Cost Checker, and (RDV) Black Stone Counter Chart
32
33
Changelog [YYYY-MM-DD TIME PST]
34
[2020-02-06 10:01] Version 1.0: Initial sheets finalized. | Known issue of transition point between BS grades not being automated when rows shift
35
[2020-02-06 16:17] Version 2.0: Added Black Stone calculator. Basic functional optimization achieved for minimal silver cost of Black Stones
36
[2020-02-07 14:55] Version 2.1: Fixed code for poor stone exp and solver constraints on sheet "Basic Black Stone Optimizer"
37
[2020-02-07 20:25] Version 2.2: Added optimization for selling/buying black stones. | Known issue: False unprofitable result due to unprecise raw data
38
[2020-02-07 22:54] Version 2.3: Fixed #REF error, changed to VLOOKUP() for lower CPU cost, and updated support for real data in the correct format
39
[2020-02-13 16:12] Version 3.0: Added Restoration calculator. Basic formula functions are available, but requires more data
40
[2020-02-21 18:05] Version 3.1: Locking edit permissions, please switch to making copies (File -> Make a Copy) if you wish to use the calculators!
41