Brawl #4 - Standings

[Naesala]

Right here.

[MyNameIsJoey]

in the death section can you make the text white, or at least not black so that it is readable? thanks

[Naesala]

Standings have been kind of updated. Total score isn't displaying correctly and Chapuz's Brawlmaster votes still pending.

[eljoemo]

I'm no spreadsheet expert, but shouldn't the +B value be outside the sum brackets. So cell N5 for DDD should read =sum(M5:M11)+B3 . Would that fix the total scores?

[Naesala]

I'm no spreadsheet expert, but shouldn't the +B value be outside the sum brackets. So cell N5 for DDD should read =sum(M5:M11)+B3 . Would that fix the total scores?

Yes indeed. theelkspeaks also pointed this out in chat. It is fixed. meaning I just need chap's votes.

[OldTrees]

I'm no spreadsheet expert, but shouldn't the +B value be outside the sum brackets. So cell N5 for DDD should read =sum(M5:M11)+B3 . Would that fix the total scores?

I have not dabbled in Google Spreadsheet, but why wouldn't the total be =sum(M5:L11)+B3? Empty cells have a default value of 0 and this would mean the total would automatically update as more scores are added.

Sidenote: When I was a brawler, I frequently checked the auction price of my competitors when I was looking at the standings. Would it make sense to insert a cost column between A and B?

[Naesala]

Sidenote: When I was a brawler, I frequently checked the auction price of my competitors when I was looking at the standings. Would it make sense to insert a cost column between A and B?

I could ad a column to the right (Column O) to display cost per person in each role, if there is enough people wanting such a thing.

[theelkspeaks]

@ OldTrees

The M column is already the sums of the relevant horizontal rows, so adding the L column into the formula directly would double count it.

[OldTrees]

@ OldTrees

The M column is already the sums of the relevant horizontal rows, so adding the L column into the formula directly would double count it.

oops. I look silly.

[russianspy1234]

Sidenote: When I was a brawler, I frequently checked the auction price of my competitors when I was looking at the standings. Would it make sense to insert a cost column between A and B?

I could ad a column to the right (Column O) to display cost per person in each role, if there is enough people wanting such a thing.

It would be cool, but I don't care TOO much.

[Kakerlake]

I would like to see the sum points of each round for each team.

[Naesala]

I would like to see the sum points of each round for each team.

Again, something I could work in for a bit of difficulty if enough people ask.