Art Directors Guild Nominations

For the films of 2020
Post Reply
User avatar
OscarGuy
Site Admin
Posts: 13668
Joined: Wed Jan 01, 2003 12:22 am
Location: Springfield, MO
Contact:

Re: Art Directors Guild Nominations

Post by OscarGuy »

I do two columns, sort by the alphabetizing column, and then use concatenate to combine the two fields again. It seems a lot easier that way.
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
Big Magilla
Site Admin
Posts: 19608
Joined: Wed Jan 01, 2003 3:22 pm
Location: Jersey Shore

Re: Art Directors Guild Nominations

Post by Big Magilla »

OscarGuy wrote:I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.
Yes, it's quite annoying. Microsoft has a quick fix for eliminating the articles a, an, the, so that you don't have to do it manually on long lists but then you wither have the titles without the article so if you want to display them you have to add the article back in after the sort. What they need to do is come up with a way of ignoring the article when sorting without eliminating it.

This is the recommended quick fix:

https://answers.microsoft.com/en-us/mso ... 40243f3983
Mister Tee
Tenured Laureate
Posts: 8783
Joined: Wed Jan 01, 2003 2:57 pm
Location: NYC
Contact:

Re: Art Directors Guild Nominations

Post by Mister Tee »

OscarGuy wrote:I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.
Copied from Variety. You know -- the Bible of show business.

Have all the peeves you want. Don't get me started on the Oxford comma.
User avatar
OscarGuy
Site Admin
Posts: 13668
Joined: Wed Jan 01, 2003 12:22 am
Location: Springfield, MO
Contact:

Re: Art Directors Guild Nominations

Post by OscarGuy »

I assume you copied this form elsewhere? I am bugged by how many prominent organizations don't seem to understand that excel spreadsheets do not sort alphabetically. The Prom does not come after Promising Young Woman. The Croods is not alphabetized after Soul and more...

Sorry, major pet peeve.
Wesley Lovell
"Any society that would give up a little liberty to gain a little security will deserve neither and lose both." - Benjamin Franklin
Mister Tee
Tenured Laureate
Posts: 8783
Joined: Wed Jan 01, 2003 2:57 pm
Location: NYC
Contact:

Art Directors Guild Nominations

Post by Mister Tee »

Nominees:

PERIOD FEATURE FILM
“Mank” (Production Designer: Donald Graham Burt)
“Ma Rainey’s Black Bottom” (Production Designer: Mark Ricker)
“Mulan” (Production Designer: Grant Major)
“News of the World (Production Designer: David Crank)
“The Trial of the Chicago 7 (Production Designer: Shane Valentino)

FANTASY FEATURE FILM
“Birds of Prey: And the Fantabulous Emancipation of One Harley Quinn” (Production Designer: K.K. Barrett)
“Pinocchio” (Production Designer: Dimitri Capuani)
“Tenet” (Production Designer: Nathan Crowley)
“The Midnight Sky” (Production Designer: Jim Bissell)
“Wonder Woman 1984” (Production Designer: Aline Bonetto)

CONTEMPORARY FEATURE FILM
“Da 5 Bloods” (Production Designer: Wynn Thomas)
“I’m Thinking of Ending Things” (Production Designer: Molly Hughes)
“Palm Springs (Production Designer: Jason Kisvarday)
“Promising Young Woman (Production Designer: Michael T. Perry)
“The Prom (Production Designer: Jamie Walker McCall)

ANIMATED FEATURE FILM
“A Shawn the Sheep Movie: Farmageddon” (Production Designer: Matt Perry)
“Onward” (Production Designer: Noah Klocek)
“Soul” (Production Designer: Steve Pilcher)
“The Croods: A New Age” (Production Designer: Nate Wragg)
“Wolfwalkers” (Production Designers: Ross Stewart, Tomm Moore, Maria Pareja)
Post Reply

Return to “93rd Academy Awards”