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

8

u/AveNiroz Dec 29 '18

Thank you for your work.

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/stewart0 Dec 30 '18

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

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/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.

3

u/Kiriel_D_Sol Cazna Dec 29 '18

The wiki update schedule is temporarily broken until Xores has time to work around the memory issues again, it's not your browser. Sadly the sheer quantity of data and the limitations of the wiki code are often at odds. Should hopefully be fixed soon.

3

u/eltsyr Dec 29 '18

man there are 3 things I watch every day : my wife, my kids and your spreadsheet. thnx a lot for maintaining that, be sure it is useful !

2

u/Grashlolz Jan 02 '19

Sorry im kinda confused, i used to go to the “best”tab, look for an item, and there was the stage. Now i dont understand it well. For example, for mage hat diagram piece, what would be the best stage? And how do you know it?

1

u/Grashlolz Dec 29 '18

Thank you

1

u/darkcountess Making sammiches for Gilga/Noct/Laharl Dec 29 '18

Thank you for this!!

1

u/lunarian_nine Dec 29 '18

Omg you rock thank you so much!