07/27 - Thursday is Dönerstag

Status
Not open for further replies.

Pleco

Friendly Neighborhood Rat
Contributor
Crowd Pleaser
Joined
Jan 23, 2016
Messages
19,190
Reaction score
76,218
Points
1,588
Age
37
Gender
Male
Plans re: tonight, please help rat man. Do I watch Hearts of Darkness first and then Apocalypse Now, or Apocalypse Now and then Hearts of Darkness?
Hearts of Darkness first, you will appreciate the movie that much more. It's easy to take it for granted, but when you realize all the shit that went down when making that movie, it's almost a miracle the end result wasn't Gigli or something.
 

Kerek

Red Cat-Bear
Contributor
Crowd Pleaser
Joined
Jan 12, 2016
Messages
64,808
Reaction score
145,369
Points
2,088
Gender
Male
thanks this is very helpful. so i guess my problem is that i have the dates formatted as "Sunday, March 13, 2016" instead of just the date plus "Sunday" or whatever

edit so i will have to do some reformatting and maybe have a hidden column with just the day of the week so it can pull from that cell
You don't have to reformat anything, that's simply a display type ("long date") for the date string, you could change the dispaly on the column to "short date" and it would look like what I have. You can run =TEXT(A1,"DDD") on long dates to get the day of the week just the same.
 
  • Like
Reactions: bxpretzel

bxpretzel

Ari Gold
Contributor
HIT Poster
Joined
Jan 14, 2016
Messages
11,163
Reaction score
24,621
Points
1,438
Location
Appalachia
You don't have to reformat anything, that's simply a display type for the date string, you could change the dispaly on the column to short date and it would look like what I have. You can run =TEXT(A1,"DDD") on long dates to get the day of the week just the same.
thanks!! i will have to try this tomorrow. i bookmarked your other post. i am burned out from staring at my giant spreadsheet all afternoon rn.
 
  • Like
Reactions: Kerek

SweetiePuff

No Lifer
Contributor
Crowd Pleaser
HIT Poster
Joined
Oct 10, 2016
Messages
19,283
Reaction score
34,574
Points
1,838
Location
Jersey Girl
Gender
Female
Title: Rate lineups of faces(~ 6 minutes) | PANDA
Worker: Preview | Accept | Requester
Requester: Chad Dodson [A1G5WIZSEE6VFG] (Contact)
TO 1: [Pay: 4.77] [Fast: 5.00] [Comm: 5.00] [Fair: 5.00] [Reviews: 15] [ToS: 0]
TO 2:
[Rate: $6.88/hr] [Pen: 0.04 days] [Res: -- of 0] [Rec: 80% of 5] [Rej: 0] [ToS: 0] [Brk: 1]
Description:
Participate in a psychology experiment --usually takes about 7 minutes to complete. You will rate lineups of faces.
Time: 15 minutes
HITs Available: 6
Reward: $0.50
Qualifications: Exc: [-1838407852-51889] DoesNotExist ; Total approved HITs GreaterThanOrEqualTo 100; HIT approval rate (%) GreaterThanOrEqualTo 80; Location In US;
HIT exported from Mturk Suite v1.21.11
 

SweetiePuff

No Lifer
Contributor
Crowd Pleaser
HIT Poster
Joined
Oct 10, 2016
Messages
19,283
Reaction score
34,574
Points
1,838
Location
Jersey Girl
Gender
Female
Title: What would you negotiate? (Bonus payments available)(~ 8 minutes) | PANDA
Worker: Preview | Accept | Requester
Requester: Malia Mason [A282XHN5IJNN2P] (Contact)
TO 1: [Pay: 4.00] [Fast: 4.88] [Comm: 4.20] [Fair: 4.91] [Reviews: 56] [ToS: 0]
TO 2:
Not Available
Description: We are interested in your help with a negotiation, 6-12 mins
Time: 30 minutes
HITs Available: 2
Reward: $0.75
Qualifications: Total approved HITs GreaterThanOrEqualTo 100; Exc: [-415780568-51891] DoesNotExist ; HIT approval rate (%) GreaterThanOrEqualTo 90; Location In US;
HIT exported from Mturk Suite v1.21.11
 

SweetiePuff

No Lifer
Contributor
Crowd Pleaser
HIT Poster
Joined
Oct 10, 2016
Messages
19,283
Reaction score
34,574
Points
1,838
Location
Jersey Girl
Gender
Female
Title: Survey of Personnel Evaluations ($1, 5 min)(~ 5 minutes) | PANDA
Worker: Preview | Accept | Requester
Requester: Leroy Gonsalves [APIZJZAC8RCCZ] (Contact)
TO 1: Not Available
TO 2: Not Available
Description: The purpose of this study is to understand how people make decisions in personnel evaluations.
Time: 45 minutes
HITs Available: 1
Reward: $1.00
Qualifications: Total approved HITs GreaterThanOrEqualTo 100; Exc: [-953998399-51751] DoesNotExist ; HIT approval rate (%) GreaterThanOrEqualTo 96; Location In US;
HIT exported from Mturk Suite v1.21.11
 
  • Like
Reactions: Mr. Krabs

Pleco

Friendly Neighborhood Rat
Contributor
Crowd Pleaser
Joined
Jan 23, 2016
Messages
19,190
Reaction score
76,218
Points
1,588
Age
37
Gender
Male

The Bad Ash

Not Goody Little 2 Shoes
Contributor
Joined
Apr 3, 2016
Messages
3,773
Reaction score
8,694
Points
888
Age
46
Gender
Male
5. Transformers: Revenge of the Fallen
4. Transformers: Dark of the Moon
3. Transformers: Age of Extinction
2.Transformers: The Last Knight
1. The Fast and the Furious: Tokyo Drift
That doesn't look like the complete and comprehensive list of awful movies. Where's Plan 9 from Outer Space?
 
  • Like
Reactions: Pleco
Status
Not open for further replies.