unforum

Rogi Ocnorb

I seem to be stuck on a genre.
So, I'm thinking Indonesia, now and will try, "The Year of Living Dangerously".

**Posted:** Thu Aug 16, 2012 11:53 pm

_________________
I'm telling you now, so you can't say, "Oh, I didn't know...Nobody told me!"

catherwood

**Posted:** Fri Aug 17, 2012 12:02 am

Rogi Ocnorb

Heh. As I really thought those were little Asian hands at the typewriter, I really didn't think this would be right. It's been a lot of years since I saw that one, but It's sorta gel-ing, now that you've confirmed it.

I can go, now, since I'm at home.
So here's the next:

Edit: Adding another still for this Classic.

**Posted:** Fri Aug 17, 2012 12:32 am

_________________
I'm telling you now, so you can't say, "Oh, I didn't know...Nobody told me!"

GuyIncognito · Decorated Joined: 20 Jul 2006 Posts: 295

I've updated the main spreadsheet, but only the List, because I wasn't sure if there's some feature that automatically updates the Leaderboard accordingly or if everything has to be counted and transferred manually by some poor soul/me.

As for the current movie, I'm almost certain that those are the kids from the beginning of The Wild Bunch. Weren't they playing with a scorpion or something crawly like that?

**Posted:** Sun Aug 19, 2012 7:17 pm

Rogi Ocnorb

You got it, Guy.
Coincidentally, I'm watching it on satellite... Right now!
Oh. and yeah. it was scorpions and ants.
~~I'll look over the spreadsheet.~~
Done.
I'm unable to reconcile one guesser, somewhere.
Counting all the guessed movies gives 1124 instead of 1125.
Maybe somebody else can figure it out.
And thanks for doing the list update, Guy.

**Posted:** Sun Aug 19, 2012 7:35 pm

_________________
I'm telling you now, so you can't say, "Oh, I didn't know...Nobody told me!"

catherwood

and my spreadsheet lists this last one as #1126

I'll upload it to my usual sekrit hiding place, then set about tomorrow comparing mine to the googledoc.

My stats/leaderboard were not recalculating on the fly the way I wanted (in a graph or chart), so I ended up using pivot tables which requires a fixed snapshot (as far as I know, in my version at least) I could recalculate those as well, tomorrow.

**Posted:** Sun Aug 19, 2012 11:41 pm

GuyIncognito · Decorated Joined: 20 Jul 2006 Posts: 295

I had another look as well, but the mystery of the missing guesser remains. All I can say is that the values in the Leaderboard seem to be correct, according to my crosscheck. But I'm also pretty sure that 1125 is the correct number of movies we tried to guess.... Maybe it's a problem with the formula or some bug in the spreadsheet?

cath, since you seem to have one additional movie, did you maybe include a Direct-to-DVD-entry in your list, like Wonder Woman (here) or something like that?

It's pretty puzzling, but this is unFiction, so sooner or later I guess we'll figure it out. Wink

Here's the next movie still for now:

stpa

**Posted:** Mon Aug 20, 2012 12:06 pm

Rogi Ocnorb

I figured it out.
The "Guesser" and "Assist" named ranges were set to not capture the last row.
I probably keyed the ending range row number from the "Flick #" column instead of the spreadsheet row number while it was sorted by the former.

**Posted:** Mon Aug 20, 2012 1:30 pm

_________________
I'm telling you now, so you can't say, "Oh, I didn't know...Nobody told me!"

catherwood

Here is an explanation for the discrepancies between the googledoc and my version of the spreadsheet (I think I've mentioned these in the past:

Sorted chronologically, we're in agreement thru #783
At #784 my spreadsheet counted "Cube" when it was reused (for the 2nd occurance) on page 360 of this thread (October 15, 2008) -- the shared doc is missing this occurance.

We remain off by one thru your #921 (my 922), then I have #923 as 'Barton Fink' (guessed on February 22, 2010 on page 431) -- the shared doc is missing this occurance.
(technically the use of this movie again later in December 2011 on page 498 was a duplication but was overlooked.)

We're then off by two thru your #948 (my 950), where an incorrect guess of 'Critters' on October 13, 2010 (page 449) was added to the googledoc and bumped your count,
after which we're back to being off by one, and there we remain.

We have a numbering disagreement during one month (January 18 - February 8, 2010 from pages [426-428]) in the chronology between 'Red Dragon' (your #910, my 911] and 'Airplane' [your #917, my 918] where six movies were entered into the googledoc in reverse sequence.

I have not yet updated my Leaderboard stats.

**Posted:** Mon Aug 20, 2012 2:10 pm

Rogi Ocnorb

Went to do the updates to make the google doc match catherwood's and see that GuyIncognito has already taken care of all of it.
Thanks!

**Posted:** Mon Aug 20, 2012 6:55 pm

_________________
I'm telling you now, so you can't say, "Oh, I didn't know...Nobody told me!"

GuyIncognito · Decorated Joined: 20 Jul 2006 Posts: 295

Thanks to both of you! I just did some legwork.

Here's another still to keep things rolling:
stpa

**Posted:** Mon Aug 20, 2012 7:23 pm

JumboTron

The Haunting (1963)

T'wos remade in 1999 and starred Liam Neeson and Catherine Zeta-Jones, but they never captured the eerie suspense of the original.

**Posted:** Tue Aug 21, 2012 2:17 am

GuyIncognito · Decorated Joined: 20 Jul 2006 Posts: 295

You're right, of course, and this was another one I was surprised we hadn't used yet.

Here's a few more atmospheric shots and then it's over to you, JumboTron.

stpa

**Posted:** Tue Aug 21, 2012 9:02 am

JumboTron

**Posted:** Wed Aug 22, 2012 1:59 am

urthstripe · vlcsnap-2012-08-29-22h46m01s36.png

I think this one oughta be pretty easy.

**Posted:** Wed Aug 29, 2012 8:46 pm

_________________
In this life, there are nothing but possibilities.