Can we get the leader's names replaced with the team names? Is that something we could do?

Hey no discussion of odds, us team leaders don't know them yet!

Also, slight mistake; I'm playing 10PM EST, or 7 PM Pacific.

@Goody: I summoned Caley, and he brought down the b& hammer on my comment. Don't worry.

Everyone is welcome to use this sheet for scheduling and keeping track of the results. Anyone with this link has read/write permissions to it, so KrazyCaley can insert the dates and times there as soon as they are determined. I've already updated it based on latest known information.

Gah, sorry. Absinthman, I forgot to link it. I'll put it in the main article right now.

It's fine Caley, no problem. I know you're a busy man.

Good luck everyone in round 3.

I'm eager to see what the general observer thread has to say about all the decks after we're finished.

potatoedoughnut: We are ruthless in our commentary, and we even go as far as to badmouth your hair.

@Dallie: That's the spirit! Is it just potatoedoughnut's hair that you are badmouthing, or everybody's? Can't wait to read how we all suck at both MTG and hair styling. :-D

I'm having a great time watching the videos and working within a smaller team, but I gotta say there are aspects of the old format I do miss. Call me old-fashioned or make fun of my (lack of) hair, but it's killing me that we can only have minimal public discussion about game play. Once the tournament is over, few people will care if turn 6 of match 2/game 3 should have been played this way, or that.

@ smash10101 i support your notion that we list the team names next to the pilot names.

@ SupremeAlliesCommander one solution might be to create a new private deck for the two teams who were participants in the match to discuss how the plays went after the match is over.

@ SupremeAlliesCommander

I think it's fun drafting with the smaller teams, but now that the drafting is over it's killing me not being able to read any discussion or commentary on the games.

I've updated the spreadsheet with a new tab that automagically updates the totals table. It also autofills the lower half of the results table, so only enter scores in the TOP half (enter the score for the person on the column).

The auto table is in a new sheet called "AutoSheet", the original tables are untouched on "List 1." If people like the new one we can hide the old one.

Absinthman: you might want to protect the cells in the lower half of the results table and in the totals table so they don't get overwritten. I tried, but I don't think I have permission to protect cells.

@potatoedoughnut: Thanks a lot for this vast upgrade. I knew there would be someone who could automate the sheet (as my knowledge is insufficient in this field). I've presumably locked the lower part of the results table and the totals table. Please try and check that it works when you have time.

@Everybody: I like the idea of having team names there instead of or next to the pilot names, but I don't know all the teams' names. We (DeckBuilder345) are Team Magic Carpet, and RussischerZar's team is Maze Runners, if I remember correctly. What about other teams?

Leafs_suck's is Vox De Bello

@absinthman: The ranges are set up correctly, but you need to change the permissions to comment only.

If you go to Data -> Named and Protected ranges this will open a panel on the right side. For each range click the edit button and click "modify permissions" and change it to "can comment" for the range and hit save.

This should make it so people can leave cell comments (if something is wrong/borken), but can't directly edit the cell.

forgot to tag you Absinthman

Also I changed it so the team names will update from the top of the results table, so you only have to modify the team name in one place to change them all (except the scheduling).

There seems to be some server error right now. I keep getting error messages. I'll wait and try to do it later.

Yeah I kept getting error messages earlier today as well. It's fine if it's not protected. Hopefully people will edit the correct places, and if not we can revert to an earlier version to fix it.

Goody's team is Team Fblthp

My team is The Dark Brotherhood.

@Absinthman - Castle Gureiskull over here.

Also, TridenT and I would like to go for Monday ~1PM PST.

Just to clarify our teamname:

Oh yeah and our next matchup vs Leafs_suck's team is midnight on Sunday PST / 7am on Monday GMT.

Absinthman: Don't worry, we steered clear of the bad words.

I've updated the sheet with the latest schedule and team names that I got.

@Darkness1835: Your team name was a bit long so I dropped "The" from it to make it fit into one row. I hope it won't be a problem. If you insist on having the article there, I can edit the column width later to make it fit.

@Dallie: That's actually a shame. Bad words are to language, what salt and pepper are to a meal. :-)

@potatoedoughnut: For some reason, I can't get the protected ranges locked. I set them to comments but nothing changes I think. And then I start getting those server errors again. I guess it might have something to do with the whole sheet being shared on the link basis, and not on username basis. I guess we have to trust people not to edit wrong cells.

Well it will all have to wait until after the DDD is over, we have lots of time to edit and delete our comments.

@Absinthman: I think it's fine. I went ahead and hid the old sheet so folks should just see the new one.

GureiSeion and TridenT will be at 1pm Eastern on Monday, 8/19.

@KrazyCaley: I have a difficulty converting the times. 1pm Eastern on Monday 8/19 is what time in PST?

10am PST

Updated

KrazyCaley, please change my match time. I am not playing at 10 PM pacific; I am playing at 7 PM Pacific.

@Absinthman, KrazyCaley - TridenT and I have set up for 4pm EST, which I believe is 1pm PST.

It is 1pm Pacific, 4pm Eastern, for Gurei v. TridenT. Correct times should now all be on the article page.

TMC takes the win 2-0 vs Dark Brotherhood.

@ KrazyCaley The match between me and Leafs_Suck is 11pm PST / 7am GMT.

Is GMT 8 hours ahead of PST or 7? I thought 7am GMT was midmight PST.

I think it's 8 hours.

Yeah it's 8 hours difference. So if you want to do it at midnight I'd be glad to get up one hour later at 8am :D

taggin Leafs_suck

No 11pm is okay with me.

11pm Pacific it is; changing.

:( here I was thinking I could actually sleep one hour longer... :(

Just wanna say, special thanks to caley, team pilots, and whoever helped set up the table and chart for us (lazy) spectators who sit back and watch the hard stuff after we do the easy stuff. :p phew, that was a long sentence!

Thanks, Tempest! Appreciate the love.

I updated it. Hopefully didn't completely screw it up lol

I saw. :P

@ Absinthman: the spreadsheet is really nice and helpful. one think I find a bit strange though is that the results table is unintuitive to read (at least for me). I would think that that the left number correlates to the team on the horizontal while the right number relates to the team on the vertical axis. at the moment it's the other way around which left me wondering if the results were put in correctly (which they are, for our part).

@RussischerZar: What you say is true. In fact the original table that I made was like that - first number for horizontal, the second for vertical. When potatoedoughnut created the updated automated version, he switched the numbers. I thought it was strange too, but decided to keep it that way because the change would require to update the totals table to link to other cells than it does now. I then decided to at least make it more clear by alternating column background colors.

I switched them so that it was easier to make the formulas to update. I agree that the other way makes more intuitive sense, sorry for the confusion :(

Calling KrazyCaley to the Trident vs. GureiSeion match!

Sorry, work went late. Starting up now.