r/OnePieceTC • u/Raitei-7 Evil God Raien • May 01 '20
ENG Guide How to maximize your Kizuna ticket pulls
Hello, I made this spreadsheet for myself sometime ago.
Its purpose is to let me see my current rate for pulling wanted items at Kizuna Box 7 and make it easier for me to decide when to reset my box7.
This is my way to maximize the efficiency of my Kizuna tickets.
The idea is; reset your box when your current pull rate is lower than your initial pull rate. This spreadsheet is making it easier to keep track of it.
I hope it will be useful to you guys.
How to use; https://i.imgur.com/H1uisHu.jpg
- First, make a copy of this spreadsheet for yourself. I advise you to use Google spreadsheets but you can also download and use it with Excel or OpenOffice etc. But if you use them, colors of Pull and Reset boxes may disappear.
- Count how many items you actually want from box 7.
- Type it to the left side "Wanted items" box. (cell "A-2")
- Type the size of the box 7 to left side "Box" (cell B-2)
- You will find your initial pull rate at cell "C-3)
- Click to "cell H-2" and modify the text from the top bar. You should change that number to your initial rate.
- Click "cell H-2" again. You should notice there will be a border at cell H2. Click and drag that border to the bottom until you reach "cell H-51" and release it. Doing this will make you apply the updated calculation to the selected cells.
This was preparation before actual use.
Using it is simple.
- Let's say you pulled 2 tablets at your first multipull when you refreshed your box 7 and your wanted items list was 39.
- Decrease your wanted items by 2. Since you pulled 2 tablets at that multipull, it makes 37. Type that number to "cell E-2". (Right beside 490 box size)
- It will show your current rate to pull and it will show you if you should keep pulling or reset your box at your next multipull.
- In this scenario, your current rate will be lower than your initial rate. So, it will show you "Reset" button.
- Keep decreasing the wanted items by how many wanted items you pulled and type it to the corresponding cell. (Corresponding cell is the left of the box size you currently have)
- When you refresh your box, delete the Wanted item numbers at the cells E-3 to E- 51. But keep the number at cell E-2. You should only type there the full amount of wanted items because its the number for full box.
46
Upvotes
2
u/Sooths4y3r May 02 '20
During Kizuna, I'm like "2 tablets in a multi? Reset!"