Abqu's Stream - Post Broadcast Thoughts

[Abqu]

hey abqu, I fixed your spreadsheet...
https://docs.google.com/spreadsheets/d/ ... sp=sharing

just had to add some more if statements
also gave you an item based lookup... btw, what exactly is the AQ column doing? I wanted to add an importrange function to the items dataset to pull the newest sheet data, but it broke that column, so I didn't end up doing it...

Are you talking about my very basic thing, or Demonologists obviously more complicated sheet, because mine doesn't have any if statements at all. I don't really even know what that means in the spreadsheet world.

[internetz]

oh. i just found the first spreadsheet link and went to it, didn't even look at who posted it... where is your spreadsheet, and does it suffer from the same flaws as demonologist's spreadsheet?

and demonologist, i fixed your spreadsheet

[Abqu]

oh. i just found the first spreadsheet link and went to it, didn't even look at who posted it... where is your spreadsheet, and does it suffer from the same flaws as demonologist's spreadsheet?

and demonologist, i fixed your spreadsheet

I mean, yeah, but like I've been saying all along, my spreadsheet abilities are very limited.

Kinda scared to show it to you now to be honest, lol.

[internetz]

I've only been working with spreadsheets and databases for 3 years, still learning plenty... if you take a look at what i did with demonologist's sheet, you might be able to see how to fix yours? or you can just ignore the fact that it spits out percentages that add up to more than 100%, and can have negative percentages...

[Abqu]

Thanks to Internet my basic mastery calculator makes more sense, yaaay.

bit.ly/29edTFJ

[Demonologist]

oh. i just found the first spreadsheet link and went to it, didn't even look at who posted it... where is your spreadsheet, and does it suffer from the same flaws as demonologist's spreadsheet?

and demonologist, i fixed your spreadsheet

Ah yeah, I already noticed that there was a bug or miscalculation I made. Can I ask you to share your 'fixed' version?

[internetz]

it's the same link above that abqu quoted...

https://docs.google.com/spreadsheets/d/ ... =426897217
It's semi-locked down, with a data validation lookup giving the info to the numbering system for the lookup (rather than having to look up the item number for the thing you wanted)
also added a stacked percentage graph to the first lookup, just for fun.

[Demonologist]

it's the same link above that abqu quoted...

https://docs.google.com/spreadsheets/d/ ... =426897217
It's semi-locked down, with a data validation lookup giving the info to the numbering system for the lookup (rather than having to look up the item number for the thing you wanted)
also added a stacked percentage graph to the first lookup, just for fun.

Alright. Thx! I'll check it out.

[Shiroe]

lol @ https://www.twitch.tv/abqu_/v/94616997?t=1h12m0s

(Don't want to get into such a situation, so I'm staying away from the Line group... )

[Abqu]

Hey y'all. I never thought this would be a thing to talk about, but hey, I'm excited.

We hit 200 followers on stream tonight, near the end. I was planning on doing giveaways in the stream that I hit that number, but it was very late in the night, so----


Sunday, October 23rd, I'll be doing a stream to celebrate. I'll be giving away some neat stuff (primal flaw/epic/legs) every 10-15 minutes. Come hang out, starting at around 10 PM EDT.

Thanks!