GC Supply/Provisioning Data

[duuude]

I would test it again on a non maintenance week. We're getting mixed/unusual unlock consistency on Rabanastre after some unlocks were undone.

[Raldo]

Sorry for the off-topic bit here but...

How do you limit the rows/columns displayed? I would like to do that to one of my other spreadsheets, but I don't know how.

Oh, here's some on-topic for ya.

Selbina's Maelstrom hasn't got the bonus item for Provisioning even though Carp + Elm are at quota, so the maintenance definitely jacked something up. We should have some better knowledge regarding bonus items with this upcoming week.

[Pyree]

Sorry for the off-topic bit here but...

How do you limit the rows/columns displayed? I would like to do that to one of my other spreadsheets, but I don't know how.

Highlight the rows or columns you don't want to be shown by clicking and dragging across the numbers/letters across the left/top, then right click on one of the numbers/letters and select the option to delete them.

[tragicnate]

Jade popped for me this week after mahogany was filled. However, crimson was filled before mahogany.

[Raldo]

Weirdddd. I changed...
"• A bonus item will appear for turn-in once any Supply or Provisioning category item reaches its quota."
to
"• A bonus item may appear for turn-in once any Supply or Provisioning category item reaches its quota."

I suppose it's possible that provisions require 2 categories complete and supply only 1, but... that would just be stupid. I am slowly filling the Maelstrom up with all these yewseless Yew Logs.

I also turned the top-left cell into a current week indicator, but I'm sure it'll get erased soon enough; people keep accidentally putting random characters in there because that's the default cell.

[miokomioko]

Crimson Crayfish was at 2700/3000 before 10:00am PST yesterday (and I guarantee it's capped now). I can't believe people were stock piling that shit so hard...

[miokomioko]

Server maintenance does indeed reset counts. Crimson Crayfish were capped (which added Jade to Provisioning) before maintenance. Now Jade is gone and Crimson Crayfish are back to 0.

[Raldo]

Someone's already filled up Walnut Logs for the Maelstrom on Selbina this week. There is no extra item present, so there's something more than just filling up a single category to get the bonus item.

For those of you who have seen the new Provisioning item this week, do you know how many of the provisioning items were capped when you saw it?

[miokomioko]

During the same week, I saw Crimson Crayfish get max'd out twice (because of maintenance resetting the counts). One of the times I was the one who finished capping it at 3000/3000. Both times it was the only Provisioning item capped, and both times it brought up Jade as the new item.

[Raldo]

Hnnnnnnnnnng

Y U MAKE THIS COMPLEX SE

[Jamison]

I'm curious, how many weeks were in the rotation before the patch?

[Raldo]

Four

This throws any old data out though because it's so vague.

The range of deliverable items has been expanded.

[Rocl]

well they better bring box turtles back cuz i got like 2000

[miokomioko]

^ Amen. My retainer is like:

[Raldo]

I'm not sure who screwed around with the spreadsheet formatting this time around, but if that person happens to read this thread and have an account here... Why did you decide to change it like that? The patch number and dates are irrelevant. If patch notes state that they've screwed around with the turn-in items, then I'll clear the whole spreadsheet.

I'm fine with the intro + notes being at the bottom, but replacing it with useless data is dumb.

I don't know about anyone else, but I prefer it how it was before...

Edit: I'll fix the spreadsheet if nobody has any objections by mid-Saturday. Can you lock certain cells in a spreadsheet? I'm tired of weird shit happening. Someone's managed to duplicate the 'Linseed Oil' cell 3x overwriting some data...

[Jamison]

Here's my suggestion at this point:

- revert the fuck out of it and get it back to what it was.
- lock the main sheet
- copy the entire sheet, and allow for the 2nd sheet to be updatable by everyone
- second sheet could maybe be only for new items/weeks until everything is figured out
- can give a couple people you trust the ability to update the main sheet

[Raldo]

Ok, well people will have to deal with it 'til Saturday. I don't really want to do that at work.

[miokomioko]

Nothing notable happened when we capped out the additional provisioning item (I don't know if that's been established or not). Northern Pike was capped, which brought up Velodyna Carp and I capped that with my stockpile. No gold star, no nothin'. ;-;

[Vuitton]

I am worried that these are being capped so easily when the servers have barely anyone on them. What happens when the servers are merged and we're playing with a full server?

[Raldo]

Drastically altered the spreadsheet. I hope you all like it.

• There are four protected sheets, one unprotected sheet now, and one protected copy of the raw data.
• The unprotected sheet contains all the raw data, and the protected sheets merely access the data in the cells of the unprotected sheet. This way the default page is protected but is also updated with the latest data.
• The default sheet is the protected sheet that contains all the data.
• The other three protected sheets are GC-specific data. I'm sure some of you are tired of scrolling to your GC, so that should help you out.
• If you want to add data now, you'll have to specifically go over to the unprotected sheet in order to add/edit.

And the best part!
• I added a pretty pretty picture for each of the GC banners instead of just blah text.

Edit: Fuuuuuck the borders got all jacked up on some of the spreadsheets... fixing...
aaand done.