*Author

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1222808#msg1222808
« on: February 08, 2016, 11:23:17 pm »
Bidding process for Brawl #5

Rules involving bidding have changed from previous Brawls, so here's a fancy new sticky for you all to feast your eyes on.

Time until bidding ends: BIDDING IS ENDED

Just before the bidding time starts, Brawlmasters will divide applicants into the different roles to ensure sufficient people have applied. Ranking a role higher will make you more likely to be put into it. They can also prevent players from applying for certain roles. The roles will be restricted only in the case it is absolutely necessary to make all players fit into their desired roles.

Auction proceedings can be viewed in the following spoiler, or here. Bosses have been provided a link by which they can make their bids.

Spoiler for BIDS:

Spoiler for TEAMS:

Bosses have 42 points to spend in the players. They can bid as many points as they like for each player. If a player has that boss's team listed as a preferred boss, the boss will be refunded one point at the beginning of round 1.

Each participant will have roles defined by the list under this post. By default, each player will have one role, but players who opted to have more than 1 role maximum will be placed in more.

If the player already has a bid, the new bid must be equal or higher to the last one.

In the end of the bidding process, the players stay in the team whose boss offered more points. In case there is a tie, the player will stay in the team he or she chooses between the tied teams.

Although players have been divided up into roles, that doesn't stop Bosses from bidding on who they want. It's highly recommended that Bosses bid on players who, in total, cover every Role. But don't let that stop you from getting a monopoly on Artists and failing every other task.

If there are players with no bids by the end of the auction, Brawlmasters will place them in the teams with less than 6 members, according to their desired roles for a cost of 1 point per player.

At the end of the auction, there will be an overtime of ~12 hours after the last bid.

The teams will start Brawl #5 with the remaining points from the Auction.

And now, the roles!

Applicants have been given one of the roles from their application. The order that the roles were listed in have been assumed to be order of preference, except where specified otherwise. Where an applicant has not specified the maximum number of roles they are willing to take, it has been assumed to be 1. Any conditional requirements and obvious preferences have also been taken into account.
We've tried our best to give you your favourite role or your second favourite role.

But obviously these role-lists are now just guidelines, unlike previous Brawls.

MORE ACCURATE ROLE LIST

Note: Removing or reducing a bid is forbidden and will be penalized.

If you have any questions about the bidding process, here is the place to ask them!
« Last Edit: February 18, 2016, 01:34:58 am by CleanOnion »

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1222963#msg1222963
« Reply #1 on: February 09, 2016, 10:57:59 pm »
Update: Added a link to a more accurate role list.

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1222971#msg1222971
« Reply #2 on: February 09, 2016, 11:44:01 pm »
Update: Auction Tracking Spreadsheet completely remodelled.

Will add more conditional formatting soon, as soon as I know how to do so.

Offline JonathanCrazyJ

  • Legendary Member
  • ******
  • Posts: 4216
  • Country: gb
  • Reputation Power: 65
  • JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.
  • Top-Decking Words
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeWar #12 Winner - Team DarknessWinner of Team PvP #812th Trials - Master of WaterSlice of Elements 9th Birthday CakeDeckbuilding Competition - Hierarchy11th Trials - Master of WaterSlice of Elements 8th Birthday CakeCard Competition - Idea Factory EspionageForum Brawl #6 Winner - The Tentacle's GripChampionship League 3/2016 2nd PlaceWar #10 - Sportsmanship AwardWeekly Tournament Winner	 Writing Competition: Elemental Rap WarBattle League 2/2016 1st Place10th Trials - Master of WaterWeekly Tournament WinnerSlice of Elements 7th Birthday CakeDeckbuilding Competition - No Matter How Many Times You Save The World2015 - PvP World ChampionForum Brawl #5 Winner - Abyss BrawlersBattle League 3/2015 1st PlaceWeekly Tournament WinnerCompetition - Result ModifiersSolved the Ruby Mansion MurderBattle League 2/2015 3rd PlaceCard Competition - When Life Gives You Art...Writing Competition - 6th Birthday PartySlice of Elements 6th Birthday CakeBattle League 1/2015 2nd PlaceSilver Donor
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223076#msg1223076
« Reply #3 on: February 10, 2016, 01:39:38 pm »
Is there any way to show a "Current Team" for each brawl team?
This would help to assess the state of the other teams and the likelihood of sniping.

Brawlmaster note: This has now been added.
« Last Edit: February 11, 2016, 08:22:09 pm by CleanOnion »
Competitions!
Competition Mailing Lists are a SERVICE TAILORED FOR YOU!
If you like any Competitions at all, check them out, we are here for you!

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223097#msg1223097
« Reply #4 on: February 10, 2016, 03:44:49 pm »
Is there any way to show a "Current Team" for each brawl team?
This would help to assess the state of the other teams and the likelihood of sniping.
Probably, yes. I'll be working on this as soon as I have time. Probably in a few hours when I can get to a computer.

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223298#msg1223298
« Reply #5 on: February 11, 2016, 06:36:13 pm »
HUGE UPDATE!

There are now two spreadsheets in the spoilers. The first shows the bids. The second shows the teams as they currently stand.

On the bids sheet, if a player's name is red, that means that that bid has been outbid and that bid is no longer valid.

On the teams sheet, the number in the bottom left shows how many points that team has spent. It shouldn't exceed 42.

Both sheets update dynamically and automagically. Thank you very much to UTAlan for helping me with this.

The only problem is that this is my best spreadsheet so far and it's only around for a few days *cry*
« Last Edit: February 11, 2016, 08:21:24 pm by CleanOnion »

Offline JonathanCrazyJ

  • Legendary Member
  • ******
  • Posts: 4216
  • Country: gb
  • Reputation Power: 65
  • JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.
  • Top-Decking Words
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeWar #12 Winner - Team DarknessWinner of Team PvP #812th Trials - Master of WaterSlice of Elements 9th Birthday CakeDeckbuilding Competition - Hierarchy11th Trials - Master of WaterSlice of Elements 8th Birthday CakeCard Competition - Idea Factory EspionageForum Brawl #6 Winner - The Tentacle's GripChampionship League 3/2016 2nd PlaceWar #10 - Sportsmanship AwardWeekly Tournament Winner	 Writing Competition: Elemental Rap WarBattle League 2/2016 1st Place10th Trials - Master of WaterWeekly Tournament WinnerSlice of Elements 7th Birthday CakeDeckbuilding Competition - No Matter How Many Times You Save The World2015 - PvP World ChampionForum Brawl #5 Winner - Abyss BrawlersBattle League 3/2015 1st PlaceWeekly Tournament WinnerCompetition - Result ModifiersSolved the Ruby Mansion MurderBattle League 2/2015 3rd PlaceCard Competition - When Life Gives You Art...Writing Competition - 6th Birthday PartySlice of Elements 6th Birthday CakeBattle League 1/2015 2nd PlaceSilver Donor
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223322#msg1223322
« Reply #6 on: February 11, 2016, 09:35:46 pm »
Wonderful work C0, smashing job
Competitions!
Competition Mailing Lists are a SERVICE TAILORED FOR YOU!
If you like any Competitions at all, check them out, we are here for you!

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223325#msg1223325
« Reply #7 on: February 11, 2016, 10:52:08 pm »
Wonderful work CO, smashing job
Thanks JCJ! <3

Spoiler for formulas, because why not:
Conditional formatting to make names go red
=0=if(index(indirect("'Highest Bids'!$C$2:$C"), match(indirect("$C"&row()),indirect("'Highest Bids'!$B$2:$B"),0))=indirect("$B"&row()),1,0)

Formula to generate columns A and B of the highest bid sheet
=query('Form responses 1'!B1:D, " select max(D), C where B <> '' group by C label max(D)'Highest Bid',C 'Player' ",1)

Formula to generate column C of highest bid sheet
=index(arrayformula(Filter('Form responses 1'!B:B,'Form responses 1'!C:C=B2)), COUNTA(arrayformula(Filter('Form responses 1'!B:B,'Form responses 1'!C:C=B2))), 1)
Thanks UTA!

Formula to generate list of players in each team, excluding Boss
=query('Highest Bids'!A2:C, "select B where C = 'A Toadally Newtral Team' and C <> '' ")

Formula to generate points spent by each team
=query('Highest Bids'!A2:C, "select sum(A) where C = 'A Toadally Newtral Team' label sum(A) '' ")

Offline Naesala

  • Legendary Member
  • ******
  • Posts: 3431
  • Country: us
  • Reputation Power: 52
  • Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.Naesala brings all the vitality and activity of a Life Nymph.
  • Awards: Slice of Elements 7th Birthday CakeSlice of Elements 6th Birthday CakeSlice of Elements 5th Birthday CakeSlice of Elements 4th Birthday Cake
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223329#msg1223329
« Reply #8 on: February 11, 2016, 11:46:54 pm »
If he keeps this up he can have his eye back <3
Your favorite Hotyugh

Offline Physsion

  • Sr. Member
  • ****
  • Posts: 884
  • Country: nz
  • Reputation Power: 19
  • Physsion is a Blue Crawler starting to think about his first run.Physsion is a Blue Crawler starting to think about his first run.Physsion is a Blue Crawler starting to think about his first run.
  • Your friendly neighbourhood owl
  • Awards: 11th Trials - Master of DarknessSlice of Elements 8th Birthday Cake10th Trials - Master of Darkness2nd Grandmaster Battle Winner - DarknessSlice of Elements 7th Birthday CakeWar #9 Winner - Team DarknessWeekly Tournament WinnerWeekly Tournament WinnerMaster Flag - Winner (Air Flag)9th Trials - Master of DarknessSlice of Elements 6th Birthday Cake
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223330#msg1223330
« Reply #9 on: February 12, 2016, 12:18:29 am »
Wonderful work C0, smashing job
Seconding this - fantastic work, Onion, much appreciated! Big thank you to UTAlan as well!

Offline JonathanCrazyJ

  • Legendary Member
  • ******
  • Posts: 4216
  • Country: gb
  • Reputation Power: 65
  • JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.JonathanCrazyJ walks among the Immortals, legends and guardians of all time.
  • Top-Decking Words
  • Awards: Slice of Elements 11th Birthday CakeSlice of Elements 10th Birthday CakeWar #12 Winner - Team DarknessWinner of Team PvP #812th Trials - Master of WaterSlice of Elements 9th Birthday CakeDeckbuilding Competition - Hierarchy11th Trials - Master of WaterSlice of Elements 8th Birthday CakeCard Competition - Idea Factory EspionageForum Brawl #6 Winner - The Tentacle's GripChampionship League 3/2016 2nd PlaceWar #10 - Sportsmanship AwardWeekly Tournament Winner	 Writing Competition: Elemental Rap WarBattle League 2/2016 1st Place10th Trials - Master of WaterWeekly Tournament WinnerSlice of Elements 7th Birthday CakeDeckbuilding Competition - No Matter How Many Times You Save The World2015 - PvP World ChampionForum Brawl #5 Winner - Abyss BrawlersBattle League 3/2015 1st PlaceWeekly Tournament WinnerCompetition - Result ModifiersSolved the Ruby Mansion MurderBattle League 2/2015 3rd PlaceCard Competition - When Life Gives You Art...Writing Competition - 6th Birthday PartySlice of Elements 6th Birthday CakeBattle League 1/2015 2nd PlaceSilver Donor
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223548#msg1223548
« Reply #10 on: February 13, 2016, 02:07:16 pm »
Something odd has happened, majofa is missing from our team but i do not see another bid
Competitions!
Competition Mailing Lists are a SERVICE TAILORED FOR YOU!
If you like any Competitions at all, check them out, we are here for you!

Offline CleanOnionTopic starter

  • Hero Member
  • *****
  • Posts: 1017
  • Country: wales
  • Reputation Power: 33
  • CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.CleanOnion is a Ghost, obsessed with their Elemental pursuits.
  • once you go spreadsheet, you never go breadsheet
  • Awards: Writing Competition - Yellow JournalismWriting Competition - FractaloreTeam Competition - The Spy Who EMed MeArt Competition - Raise the BannersWriting Competition - The Seven Wonders3rd Place Weekly Challenge Winner: September 2015Weekly Design August 2015 - Silver
Re: Auction Process [Brawl #5] https://elementscommunity.org/forum/index.php?topic=61161.msg1223599#msg1223599
« Reply #11 on: February 13, 2016, 08:27:14 pm »
Something odd has happened, majofa is missing from our team but i do not see another bid
odd, the same has happened to rob77dp. This will be investigated. In the meantime, you'll have to work things out manually. Apologies for the inconvenience.

Immediate edit: Error found. Check the "highest bids" sheet and you'll see what has happened. I'll fix it as soon as I can get to a computer.

Edit: Fixed. Some of the cells on the Highest Bids sheet did not contain the formula they were supposed to.
« Last Edit: February 13, 2016, 11:01:54 pm by CleanOnion »

 

anything
blarg: UTAlan,Khaleesi