Guides

814

December 24, 2018 15:10:51

@SilMyst

This looks very cool! I'll include a simplified breakdown of all the coli familiars with their respective venues and give you an honorable mention! ^ ^ Then, if people want further breakdowns, it's easily accessible but won't clutter up the main sheet.

Hey! I'm trying to get the sheet to update the needed tab - I couldn't get it working in Ice so I re-did the sheet in the arcane tab and it's still not updating. The named range is displaying as Arcane!B2:D726

handdrawnviolist

712

659

1217

2238

December 25, 2018 02:42:22

Hey! I'm trying to get the sheet to update the needed tab - I couldn't get it working in Ice so I re-did the sheet in the arcane tab and it's still not updating. The named range is displaying as Arcane!B2:D726

@handdrawnviolist

Sorry to hear that! I'll need you to change your Share settings* and toss me a link whenever you get the chance. I have a few ideas as to what may be happening, but I'll have to see the sheet and where certain formulas are located to be certain.

* In the upper right of the screen, just below the address bar, there'll be a blue "Share" button; click this and paste the link, keeping it the default "Anyone with a link can view". You can change this later if you'd like.

Fate2726

814

December 25, 2018 06:51:47

@handdrawnviolist

Sorry to hear that! I'll need you to change your Share settings* and toss me a link whenever you get the chance. I have a few ideas as to what may be happening, but I'll have to see the sheet and where certain formulas are located to be certain.

* In the upper right of the screen, just below the address bar, there'll be a blue "Share" button; click this and paste the link, keeping it the default "Anyone with a link can view". You can change this later if you'd like.

@fate2726

Here it is!

https://docs.google.com/spreadsheets/d/1qtdEm75t1D0mLBT6HrnxvboBsqzJ1Za2zp9xTRyHRZI/edit?usp=sharing

handdrawnviolist

712

659

1217

2238

December 25, 2018 21:00:49

@fate2726

Here it is!

https://docs.google.com/spreadsheets/d/1qtdEm75t1D0mLBT6HrnxvboBsqzJ1Za2zp9xTRyHRZI/edit?usp=sharing

@handdrawnviolist

Perfect! It does look like a simple fix thankfully - you did the right troubleshooting steps, it looks like the Query formula I used to filter the familiars is just case sensitive. Cell N4 in the Familiar Breakdown tab of the blank template has the fix, just copy that to N4 in the Familiar Breakdown tab in your sheet and it should fix the problem.

(It's hidden because Query will return an error if nothing comes back. Which means, once you get everything from a venue or specific area, you'll see an "N/A" in bolded red and wonder what the heck happened.)

You'll also need to fix cell W4 in the Coliseum Breakdown tab for the same reason, if you're using it. But once is all done, you're free to delete the tabs you're not using! They don't influence the filtering.

I'm out at the moment but if you'd like a picture walkthrough I can provide it no problem, it's just be a few hours. Thank you for bringing this to my attention!

Fate2726

814

December 26, 2018 09:05:52

@handdrawnviolist

Perfect! It does look like a simple fix thankfully - you did the right troubleshooting steps, it looks like the Query formula I used to filter the familiars is just case sensitive. Cell N4 in the Familiar Breakdown tab of the blank template has the fix, just copy that to N4 in the Familiar Breakdown tab in your sheet and it should fix the problem.

(It's hidden because Query will return an error if nothing comes back. Which means, once you get everything from a venue or specific area, you'll see an "N/A" in bolded red and wonder what the heck happened.)

You'll also need to fix cell W4 in the Coliseum Breakdown tab for the same reason, if you're using it. But once is all done, you're free to delete the tabs you're not using! They don't influence the filtering.

I'm out at the moment but if you'd like a picture walkthrough I can provide it no problem, it's just be a few hours. Thank you for bringing this to my attention!

Update

Both the Glitterfreeze Ambassador and Longneck Lampooner have been added to the blank template.

They've been added to new rows 269 and 364. Additionally, all Nymphs have had their locations changed to "Joxar's Spare Inventory" instead of "Joxar's Crate".

If anything looks wrong, please notify me.

Fate2726

814

January 30, 2019 05:46:13

Update

Both the Glitterfreeze Ambassador and Longneck Lampooner have been added to the blank template.

They've been added to new rows 269 and 364. Additionally, all Nymphs have had their locations changed to "Joxar's Spare Inventory" instead of "Joxar's Crate".

If anything looks wrong, please notify me.

@Fate2726 Firstly, I want to thank you for all the hard work you've put into this spreadsheet. It's incredibly helpful and I use it almost every day!
Secondly, I wanted to ask what might be a dumb question: would the Longneck Lampooner go under "Ambassadors" or another category?

AstralDragons

0

157

508

611

February 01, 2019 00:42:29

@Fate2726 Firstly, I want to thank you for all the hard work you've put into this spreadsheet. It's incredibly helpful and I use it almost every day!
Secondly, I wanted to ask what might be a dumb question: would the Longneck Lampooner go under "Ambassadors" or another category?

@AstralDragons

You're very welcome! It started out as a little side project that I kept ~~getting mad at because it wouldn't do the thing~~ refining down until it functioned correctly, then figured to free this monster onto the forums. ^·^ Always always, it's awesome to know people like yourself get some rad use out of the sheets!

And, might I just say, that's a brilliant question! As the Longneck Lampooner is the accompanying familiar for the Glitterfreeze Ambassador, I could already see the two being listed together as Ambassadors. By definition of "Lampooner" and their item descriptio, it would also (varying by interpretation of the two) be feasible to say the same.

Hope this helps!

Definition wrote:

- A sharp, often virulent satire directed against an individual or institution; a work of literature, art, or the like, ridiculing severely the character or behavior of a person, society, etc.
(Dictionary.com)

- A piece of writing, a drawing, etc. that criticizes a famous person or a public organization in a humorous way, allowing their or its bad qualities to be seen and making them or it seem stupid.
(Cambridge Dictionary, in this case Lampooner would be the creator of such pieces).

Fate2726

814

February 01, 2019 04:41:37

@AstralDragons

You're very welcome! It started out as a little side project that I kept ~~getting mad at because it wouldn't do the thing~~ refining down until it functioned correctly, then figured to free this monster onto the forums. ^·^ Always always, it's awesome to know people like yourself get some rad use out of the sheets!

And, might I just say, that's a brilliant question! As the Longneck Lampooner is the accompanying familiar for the Glitterfreeze Ambassador, I could already see the two being listed together as Ambassadors. By definition of "Lampooner" and their item descriptio, it would also (varying by interpretation of the two) be feasible to say the same.

Hope this helps!

Definition wrote:

- A sharp, often virulent satire directed against an individual or institution; a work of literature, art, or the like, ridiculing severely the character or behavior of a person, society, etc.
(Dictionary.com)

- A piece of writing, a drawing, etc. that criticizes a famous person or a public organization in a humorous way, allowing their or its bad qualities to be seen and making them or it seem stupid.
(Cambridge Dictionary, in this case Lampooner would be the creator of such pieces).

Awesome, thank you so much!!

AstralDragons

0

157

508

611

February 01, 2019 10:07:04

Awesome, thank you so much!!

[center][color=#cc0099][size=5]Update[/size][/color] [br] [color=#7730b5]Both the [b]Chocolate Noggle[/b] and [b]Strawberry Noggle[/b] have been added to the blank template. They've been added to new rows 117 and 641. Additionally, there has been a minor update to the "Misc." column within the "Needed (Breakdown)" tab to include all Valentine's event familiars. To view the code, see Cell L4 in the "Needed (Breakdown)" tab. Alternatively, the new code is also as follows:[/color][/center] [br] [quote=Code - Replace or Edit old code in the Misc. Column] =QUERY(N5:O, "select N where (O contains 'Gift') or (O contains 'April') or (O contains 'Beta') or (O contains 'Kickstarter') or (O contains 'FR') or (O contains 'February')",1)[/quote] [br] [br] -----

Fate2726