Abqu's Stream - Post Broadcast Thoughts

Post your fan creations, streams, off-topic, and the like!
User avatar
Abqu
"Epic" Mastery Member
Posts: 957
Joined: Thu Jan 14, 2016 6:39 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Abqu » Fri Sep 16, 2016 3:13 pm

internetz wrote: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
"Great" Mastery Member
Posts: 169
Joined: Mon May 16, 2016 1:22 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby internetz » Fri Sep 16, 2016 3:17 pm

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 :P

User avatar
Abqu
"Epic" Mastery Member
Posts: 957
Joined: Thu Jan 14, 2016 6:39 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Abqu » Fri Sep 16, 2016 3:25 pm

internetz wrote: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 :P


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
"Great" Mastery Member
Posts: 169
Joined: Mon May 16, 2016 1:22 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby internetz » Fri Sep 16, 2016 3:56 pm

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

User avatar
Abqu
"Epic" Mastery Member
Posts: 957
Joined: Thu Jan 14, 2016 6:39 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Abqu » Sun Sep 18, 2016 12:18 pm

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

bit.ly/29edTFJ

Demonologist
"Great" Mastery Member
Posts: 221
Joined: Sun Mar 27, 2016 12:16 am

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Demonologist » Wed Sep 21, 2016 5:33 am

internetz wrote: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 :P


Ah yeah, I already noticed that there was a bug or miscalculation I made. Can I ask you to share your 'fixed' version?
In-game Name : Demonologist#57775
Shop Villains

internetz
"Great" Mastery Member
Posts: 169
Joined: Mon May 16, 2016 1:22 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby internetz » Wed Sep 21, 2016 2:52 pm

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
"Great" Mastery Member
Posts: 221
Joined: Sun Mar 27, 2016 12:16 am

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Demonologist » Wed Sep 21, 2016 6:30 pm

internetz wrote: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.
In-game Name : Demonologist#57775
Shop Villains

User avatar
Shiroe
"Legendary" Mastery Member
Posts: 2338
Joined: Sun Aug 23, 2015 11:05 am
Location: the Netherlands
Contact:

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Shiroe » Fri Oct 14, 2016 8:14 am

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... ;) )
as of 2016-09-11: Player level: 44, City: Eolythes, Blueprints: 517, Mastered: 419, Crafted: 78.61K
(except for tier 1 and some tier 2 artifacts mostly running my shop/gearing self sufficient)

User avatar
Abqu
"Epic" Mastery Member
Posts: 957
Joined: Thu Jan 14, 2016 6:39 pm

Re: Abqu's Stream - Post Broadcast Thoughts

Postby Abqu » Wed Oct 19, 2016 9:50 pm

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!


Return to “Community Tavern”



Who is online

Users browsing this forum: No registered users and 1 guest

©2015 Cloudcade, Inc. All Rights Reserved.