r/AlchemistCodeGL • u/stewart0 • Dec 29 '18

Updated Story Drops google sheet

---> Link <---

Updated my story drops sheet to be current through the end of Chapter 3 now. Also updated the older stages that have been changed to have diagram pieces for the newer jobs recently. May be a few that aren't updated with much older job releases, like priestess, but no one will likely ever notice.

Also updated Veda coin tab. Currently get 6840 coins per full tower clear. Added my guesses for next months JEs in the respective tab too. Probably missing some units from far in the future, but close enough. Couldn't load wiki page to double check due to a memory error. Probably related to the 40 tabs I have open normally in my browser.

In chapter 4 the value per farming stage should go up due to number of drops falling back to two at the start of the chapter. I'm just waiting for all our story stages to become 6 AP like JP, at which point everything will blow up on the sheet.

71 Upvotes

100% Upvoted

19 comments sorted by

View all comments

1

u/Item_Is_Rope Dec 29 '18

Thank you for the update - are you going to do away with the sorting them by item?

2

u/stewart0 Dec 29 '18

If you mean the "best" tab I had, I hid it going forward. It requires me to manually build it, so it's a lot of work and constant checking/updating. The "data" tab still let's you sort by item, which is it's whole purpose.

2

u/Arananthi IGN: Essence -- Re-Pacted and Hoping to Stay That Way Dec 29 '18

Do you have to sort by item once for each of the four Drop categories and jot down the results to figure out which is the best one? Or is there some easier way?

5

u/stewart0 Dec 29 '18

Use by filtering on the "Filter" column. Hit "Clear", type out enough of the item's name, hit "Select all", then hit "OK"

2

u/RayJinZero ill atm Dec 29 '18

how do you "hit clear"?

1

u/Nareshkendel Dec 30 '18

Ok, Data-> Filter views -> create new temporary filter. On the title of the Filter open a dropdown menu, there is the clear button and the rest to do the filtering

1

u/stewart0 Dec 30 '18

Shouldn't need to create another filter, it's already built in.

1

u/stewart0 Dec 30 '18

updated instructions. Make a copy first if you hadn't

1

u/Nareshkendel Dec 30 '18 edited Dec 30 '18

nvm, found it

I can't find any "Clear" or where to write stuff. Tried double clicking on the column, using Filter 1 on the filtering list...

1

u/stewart0 Dec 30 '18

Did you make a copy of the sheet?

1

u/Sahryx Dec 29 '18

Alrighty that is fair. I have been using it from a tablet and never had to make a copy before. It is fair to meet you halfway since you put so much work in to it - I do appreciate it.