Subscribe to the Big Brother Live Feeds

Author Topic: The Amazing Race: Marker-by-Marker Spreadsheet  (Read 1320 times)

0 Members and 1 Guest are viewing this topic.

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
The Amazing Race: Marker-by-Marker Spreadsheet
« on: May 27, 2014, 01:48:33 AM »
:hello2: guys!

I made this spreadsheet, listing the positions of each team for each marker, for each leg. It notes Detour changes, transportation orders, penalties and where they were incurred, Roadblock count, and more. :)

I've finished 11 seasons so far (01, 10-11, 17-24).

Here are the links to the file in Google Docs:
Docs Spreadsheet form
.XLS File (download through 'File' tab)

I made the spreadsheet on a laptop using Excel 2003. Message me if there are technical problems. :D

Have a look and enjoy :waves:
« Last Edit: June 18, 2014, 03:43:48 AM by Karpov617 »


Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #1 on: May 27, 2014, 02:40:35 PM »
Hey there Karpov! Wow, those are really impressive! They will definitely prove interesting and useful to others!

Not to undermine your work or anything, but I thought I'd let you know that some marker-by-marker statistics have already been created for races 1-13 (though not quite to your level of quality)

They're over on The Wiki!
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Subscribe to the Big Brother Live Feeds

Online georgiapeach

  • Amazing Race Moderator
  • RFF Moderator
  • I Live at RFF
  • *****
  • Posts: 39681
  • TAR Detective
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #2 on: May 27, 2014, 02:51:16 PM »
Karpov, how about you work with GB on updating the wiki?? That would be AWESOME!!
"Our fans are pretty good. They don't give away too much. Sometimes people love dropping spoilers, but our fans are good. They tend to do it in such a way that doesn't ruin it for fans who don't want to know."--Phil Keoghan

Offline Alenaveda

  • TAR Detectives
  • RFF Frantic Poster
  • *****
  • Posts: 2663
  • Welcome to the cloneverse.
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #3 on: May 27, 2014, 02:54:23 PM »
What Karpov can do is add his work to the RFF Wiki. :tup:
"When you eliminate the impossible, whatever remains--however improbable--must be the truth." --Sir Arthur Conan Doyle

"No person deserves your tears, and who deserves them will not make you cry." - Gabriel García Márquez

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #4 on: May 27, 2014, 06:46:52 PM »
Yeah, I was planning on adding more marker-by-marker tables at a later date, but if Karpov wants to help he certainly can :D
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.


Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #5 on: May 27, 2014, 09:11:04 PM »
I'd love to help ;) but we have different formats. What do you propose?

Offline nmccarroll91

  • RFF Full Member
  • ***
  • Posts: 248
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #6 on: May 28, 2014, 08:56:29 AM »
This is AWESOME!!!!!  :conf:
..... The World is Waiting! .....

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #7 on: May 28, 2014, 12:26:45 PM »
The wiki currently has the most pertinent information, and on a place like the wiki there's not much room for more than that considering it's a table. (Especially since we usually have to reserve space on the right for images)

It's up to you man. If you'd like to follow the given format, go ahead. If you'd like to propose an improvement to my format, that's fine too. Or, if not, you can continue with your Excel's, since those would still be well received by others here.
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Online georgiapeach

  • Amazing Race Moderator
  • RFF Moderator
  • I Live at RFF
  • *****
  • Posts: 39681
  • TAR Detective
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #8 on: May 28, 2014, 03:01:09 PM »
Karpov, it sure would be great if you could gradually input your data into ours! We are striving to have the most complete and accurate info anywhere, so info such as yours is treasured.
"Our fans are pretty good. They don't give away too much. Sometimes people love dropping spoilers, but our fans are good. They tend to do it in such a way that doesn't ruin it for fans who don't want to know."--Phil Keoghan

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #9 on: May 29, 2014, 11:09:14 AM »
Okay :) So I edited this page to add my information and tweaked the format. The table did become taller. What do you think?

http://realityfanwiki.com/index.php?title=The_Amazing_Race_21_Leg_1#Results


Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #10 on: May 29, 2014, 04:18:07 PM »
I don't think it's necessary to list the Roadblock performers, since on all normal legs, we will colour in the name of who did the Roadblock in bold on the far right.

This doesn't really work in this table, I know, but I've been planning to go back and fix legs with multiple Roadblocks by Bolding whoever did the first Roadblock, and Underlining who did the second one.

Remember that, on a Wiki, it's usually preferred to have really simple tables with extensive "Legends" below them. Usually we want to throw out the information easily and quickly to anyone who wants to read :P

But also, the teams aren't in order anymore. Just like the overall leg placements table, the contestants should be ordered in the order they are "at the end of the day" (Which would be their Pit Stop placements)
« Last Edit: May 29, 2014, 04:24:29 PM by GB »
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #11 on: May 29, 2014, 08:13:20 PM »
The table does look better shorter and without the Roadblock names :-[

However, I do think it's better if the teams are arranged at the start instead of at the end, since it better shows how each team have risen or fallen by the end of the leg.

Also, how about the Detour? I'm assuming the detour choices and detour switching won't be included in the table anymore?

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #12 on: May 29, 2014, 09:05:44 PM »
I haven't reached this point yet, but the pages for each team are going to include synopses of their progression through each leg, and Detour switches will be covered there.

It's, of course, most important to note which Detour they /did/ complete. I think that if you want to show this in the marker leaderboard, then utilizing "A" or "B" next to the team's placement to indicate which Detour they did is a good idea (Detours were originally known by 'Choice A' and 'Choice B', and are still known as Options A and B in the Latin America race)

Then you can also add something like "A blue team placement indicates the team switched Detours at least once" or something similar.
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #13 on: May 30, 2014, 06:40:56 AM »
Here's my take on TAR21 L09:
http://realityfanwiki.com/index.php?title=The_Amazing_Race_21_Leg_9#Results

The leg has a Detour, a Roadblock, a Fast Forward, and a U-Turn. Thoughts?

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #14 on: May 30, 2014, 12:48:47 PM »
It's good except for two things:

First, if there is no change in placement between getting the clue at a Roadblock/Detour, and completion of that Roadblock/Detour, then there only needs to be one column, otherwise it's superfluous.

And again I think I should bring up the order. Having them ordered in terms of finish instead of in terms of start will still show teams that got ahead and teams that fell behind, and it's sort of a general thing to have the last place team be at the bottom. Does anyone else have any input on this?

Oh, and you do need to use the different symbols for the second U-Turn. This is for the benefit of colour-blind people.
« Last Edit: May 30, 2014, 12:52:11 PM by GB »
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Subscribe to the Big Brother Live Feeds

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #15 on: June 02, 2014, 12:05:36 AM »
I really need more input on which order is better before I start adding the Results tables in the pages...

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #16 on: June 03, 2014, 02:35:04 PM »
Third opinion, guys! C'mon! :P
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #17 on: June 19, 2014, 04:12:15 PM »
Everyone, please give your opinion. It's easy

When listing the placement of teams over the legs, is it better to have them arranged by PIT START DEPARTURE, or PIT STOP ARRIVAL?
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.

Offline Bookworm

  • RFF Sr. Member
  • ****
  • Posts: 402
  • Legolas Greenleaf is the best!
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #18 on: June 19, 2014, 04:35:25 PM »
Pit Stop Arrival
"To deny people their human rights is to challenge their very humanity" - Nelson Mandela

Rooting for Tim & Te Jay and Amy & Maya in TAR25!

Offline Jimmer

  • Big Brother Sho2 Updater
  • Big Brother Updaters
  • RFF Frantic Poster
  • *****
  • Posts: 1013
  • Nicole and Christine <3

Online Karpov617

  • RFF Full Member
  • ***
  • Posts: 201
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #20 on: June 23, 2014, 04:45:33 AM »
I would like to ask if and how the penalties should be added in the results table per leg?

Offline Jobby

  • TAR & RFF Fanatic
  • TAR Detectives
  • I Live at RFF
  • *****
  • Posts: 12512
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #21 on: June 23, 2014, 09:43:22 AM »
Have a separate Pit-stop Departure table? :)

Offline GB

  • RFF Full Member
  • ***
  • Posts: 239
  • Team Number One!
    • Youtube
Re: The Amazing Race: Marker-by-Marker Spreadsheet
« Reply #22 on: June 23, 2014, 01:42:07 PM »
I always just show their placements "as-is", even if they have a penalty pending. Then for whenever it's applied (ie, Pit Stop), just have two columns (Only populate the first column with the penalty-given person's initial arrival)

The difference is if they've missed a clue entirely. For example, Chip & Kim missed a clue during their first leg, but went right ahead and performed the Detour. Though they were ahead of everyone, they were most certainly not in first. So I "held back" their placement on anything past the missed clue until they went back and got it.

See what I'm talking about on Race 5 Leg 1's page
Come check out the Reality Fan Wiki! It's not dead anymore!!
-All Country pages Finished!!
-All Season and Series pages Finished!!
-All Team pages Finished!!

-Transcripts!! Season 1, Legs 1-6 up.


 

Custom Search