DBO Forums - Chewy added.

Chewy added. (reply)

Chewbaccawakka — Thu, 30 Jul 2015 23:52:37 +0000

Huzzah! My competitive side is rejoicing!

Google fix ur S#!7 (reply)

red robber — Thu, 30 Jul 2015 09:14:58 +0000

Apparently they also made a deal with Activision. :)

I blame Google (reply)

Beorn — Thu, 30 Jul 2015 09:11:35 +0000

- No text -

Try a different browser and don’t log in (reply)

red robber — Thu, 30 Jul 2015 08:51:18 +0000

Hmmm. Tried it. So I see that basically everything works and sorts properly, but as soon as you do resort, the power index goes to $hit. And you guys can't sort the power index at all to see the order. My equation takes the rank of entire columns. Maybe I have to select the cells with data only in those columns? I'll have to experiment and get back later with a fix.

I assume so (reply)

ZackDark — Thu, 30 Jul 2015 08:42:28 +0000

But I find this VERY weird. GSheets used to handle filters exceedingly well back when I used it for work.

Chewy added. (reply)

red robber — Thu, 30 Jul 2015 08:23:55 +0000

Nice job in IB. You almost broke into the top five in the power ranking coming in at 6th!

Try a different browser and don’t log in (reply)

Beorn — Thu, 30 Jul 2015 08:20:20 +0000

- No text -

Yeah, I see the same thing (reply)

red robber — Thu, 30 Jul 2015 08:17:46 +0000

Huh. I've never used filters and never shared a sheet before. I wish I could actively use the sheet from another point of view. I'm assuming the power index gets screwed up for everyone then?

Yeah, I see the same thing (reply)

ZackDark — Thu, 30 Jul 2015 08:04:24 +0000

Since we don't have authorization to change the sheets (not that we would need to anyway), the only way to sort stuff is by creating temporary filters. GSheets does it automatically even if we click the column's name.

Yeah, I see the same thing (reply)

red robber — Thu, 30 Jul 2015 07:24:56 +0000

This is interesting. Here is the trials page sorted first by descending Win%. Otter is 3rd in win% and has a 3.2 power index.

Now sorted by Descending games played, Otter is first on the list but retains his rating 3.2 PIndex.

I can't explain the error, except that while searching the help for functions and chart usage, I saw something about the "new" sheets. Maybe they have 2 versions available?

Edit, I'm seeing in your photo that you have a temporary filter? Perhaps this causing an issue. I don't have any filters applied when I view the sheet.

Yeah, I see the same thing (reply)

Beorn — Thu, 30 Jul 2015 07:04:45 +0000

Not sure if it's just me, but if I try to re-sort on ANYTHING, Power Index breaks.

The power index will follow the GT as the sheet resorts. Are you using the little option drop down button at the top of each column to sort? Highlight the A at the top of a column then use that little down arrow to pull up the menu. Then sort from that.

~~If I sort A-Z, it appears to work, but if I sort Z-A, it breaks:~~
Edit: Now it’s breaking whether I sort ascending or descending. Sometimes numbers actually populate in the PI column before being immediately replaced with #REF! errors.

Sorting in descending order on Win % column.

I suck. Not news. (reply)

Kermit — Thu, 30 Jul 2015 06:50:13 +0000

- No text -

Which character... (reply)

red robber — Thu, 30 Jul 2015 05:44:00 +0000

It's combined on all your characters. (or it should be according to the way I interpret the DTR site)

Just like Matt Smith (reply)

TheeChaos — Thu, 30 Jul 2015 02:29:32 +0000

Give them a bar of gold and they want 2!!! cant you ever be thankful?

My Trials k/d is not that great.... (reply)

Schedonnardus — Thu, 30 Jul 2015 00:16:39 +0000

....but I have the 6th highest assist rate, and 7th highest orbs generated per game. I'm also the 4th highest at reviving my teammates.

That explains my theory last night about rising up to the level of my teammates. I can't really carry a team, but if i have teammates at my level or higher, I can hold my own really well.

lol, me too (reply)

Schedonnardus — Thu, 30 Jul 2015 00:05:21 +0000

we were getting stomped repeatedly. I was like "this is NOT going to reflect well on the Red >>Robber Scale... But I still had fun, and played the same way I always do.

lol. We had a few really bad games last night and i thought the same thing. I started hanging back and sniping more. Gave up on trying to use my messenger, and switched back to thorn. :)

Which character... (reply)

ChrisTheeCrappy — Wed, 29 Jul 2015 19:59:09 +0000

does this use? The most recent, all of them, some odd ball random choice?

Very cool. Thanks for putting this together! (reply)

CruelLEGACEY — Wed, 29 Jul 2015 18:51:56 +0000

- No text -

+1 (reply)

kidtsunami — Wed, 29 Jul 2015 18:40:35 +0000

- No text -

my roll (reply)

kidtsunami — Wed, 29 Jul 2015 18:34:43 +0000

Anyways, honored to be amongst the top players of DBO. You all are awesome and I appreciate your day to day/weekly analysis.

I'd like to know what the heck you are doing to generate 6.28 orbs per game in Iron Banner. That's pretty amazing. Some sort of team Super formation?

The build I roll with is traditionally:

Last Word
Party Crasher, Matador, blah blah blah, some ranged shotgun
and I roll as one of those damn Sunsingers, and I rock Sunburst

Also I just love supers, and I make sure to keep that train going