01/21 - Thinking About.... Thursday

Discussion in 'Daily mTurk HITs Threads' started by GreenMachine842, Jan 21, 2021.

Thread Status:
Not open for further replies.
  1. Slowdive

    Slowdive Active Turker

    Messages:
    637
    Gender:
    Male
    Ratings:
    +1,549
    I prefer to be completely oblivious to how much money I earn. It makes things more exciting.
     
    • LOL LOL x 2
  2. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    What are you using, would be using, and I can point you to where the conditional formatting is.
     
    • Love Love x 1
  3. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    Especially on tax day.
     
    • LOL LOL x 1
  4. gurlondrums

    gurlondrums Cracker of the Step Whip

    Messages:
    27,160
    Gender:
    Female
    Ratings:
    +76,023
    nice nice. understood. I do love excel but at work, other people make the spreadsheets so all I have to do is programming and sql. so I gets lazy.
     
  5. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    Which SQL?
     
  6. Kayashi

    Kayashi Titler

    Messages:
    7,285
    Gender:
    Male
    Ratings:
    +14,928
    i too, do not balance my checkbook
     
    • LOL LOL x 1
  7. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    What's a check...book?
     
    • LOL LOL x 2
    • WOW WOW x 1
  8. gurlondrums

    gurlondrums Cracker of the Step Whip

    Messages:
    27,160
    Gender:
    Female
    Ratings:
    +76,023
    microsoft sql server management studio (not by choice) :emoji_rolling_eyes:
     
  9. Kayashi

    Kayashi Titler

    Messages:
    7,285
    Gender:
    Male
    Ratings:
    +14,928
    sorry, forgot you werent an american. Cheque book
     
    • LOL LOL x 1
  10. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    Also, just for the non-spreedsheet / SQL inclined out there, here is one IF string from one cell on one sheet.

    =IF(D4="Paid",$C$4,(IF(D4="--",0,(IF(D4>0,D4,0)))))+IF(D5="Paid",$C$5,(IF(D5="--",0,(IF(D5>0,D5,0)))))+IF(D6="Paid",$C$6,(IF(D6="--",0,(IF(D6>0,D6,0)))))+IF(D7="Paid",$C$7,(IF(D7="--",0,(IF(D7>0,D7,0)))))+IF(D8="Paid",$C$8,(IF(D8="--",0,(IF(D8>0,D8,0)))))+IF(D9="Paid",$C$9,(IF(D9="--",0,(IF(D9>0,D9,0)))))+IF(D10="Paid",$C$10,(IF(D10="--",0,(IF(D10>0,D10,0)))))+IF(D11="Paid",$C$11,(IF(D11="--",0,(IF(D11>0,D11,0)))))+IF(D12="Paid",$C$12,(IF(D12="--",0,(IF(D12>0,D12,0)))))+IF(D13="Paid",$C$13,(IF(D13="--",0,(IF(D13>0,D13,0)))))+IF(D14="Paid",$C$14,(IF(D14="--",0,(IF(D14>0,D14,0)))))

    What's even better is that it's actually super basic and just a way of totaling my bills as I pay them.
     
    • LOL LOL x 1
  11. gurlondrums

    gurlondrums Cracker of the Step Whip

    Messages:
    27,160
    Gender:
    Female
    Ratings:
    +76,023
    [​IMG]
     
    • LOL LOL x 1
  12. AlexZ

    AlexZ Distinguished Butthat The Prophet

    Messages:
    15,791
    Gender:
    Male
    Ratings:
    +49,225
    Meh. Not enough parentheses if you ask me.
     
    • LOL LOL x 2
  13. LumosDC

    LumosDC Survey Slinger

    Messages:
    8,457
    Gender:
    Male
    Ratings:
    +7,429
    Title: Workplace Strain and Reaction Time 1(~ 20 minutes) | Accept
    Requester: Sanjay Goel [ABV5QGBWK548H] Contact
    TV: [Hrly=$12.31] [Pay=Good] [Approval=1-3 days] [Comm=Unrated] [Rej=0] [Blk=0]
    TO: [Pay=2.38] [Fast=2.80] [Comm=1.00] [Fair=2.60] [Reviews=11] [ToS=0]
    TO2: No Reviews
    Reward: 1.00
    Duration: 1:30:00
    Available: 34
    Description: Please tell us how you would react when facing difficult workplace situations.
    Qualifications: SurveyGroup [3999] DoesNotExist ; Exc: [-1532740535-270636] DoesNotExist ; Total approved HITs GreaterThanOrEqualTo 1000; CR Research Group #2 DoesNotExist ; HIT approval rate (%) GreaterThanOrEqualTo 90; CR Research Group #1 GreaterThanOrEqualTo 100; Location In US
     
  14. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    It's also not the worst, like Tableau. Or having to use both MS SQL and PostGreSQL and randomly forgetting which one uses ; and which uses ,.
     
    • Yikes Yikes x 1
  15. SunlitSunflower

    SunlitSunflower baby head

    Messages:
    22,494
    Ratings:
    +36,431
    • LOL LOL x 1
    • Love Love x 1
    • WOW WOW x 1
  16. Kahil01

    Kahil01 Well-Known Turker

    Messages:
    3,347
    Gender:
    Female
    Ratings:
    +701
    Hong Zhang [A2LEVQ04GDIWWM] A decision-making task - $2.50 | PANDA


    Fair

    Unrated

    Unrated
    $15.85 / hour
    00:09:28 / completion time
    Pros:
    Cons:


    Catchability: Great (HIT Last Seen: 2 minutes ago)
    Qualifications: Completed Work Scenario Study 1 DoesNotExist ; Completed in October DoesNotExist ; Total approved HITs > 100; HIT approval rate (%) > 95; Location EqualTo US;

    To read Hong Zhang's full profile check out TurkerView!
     
  17. Moridin

    Moridin Well-Known Turker

    Messages:
    5,607
    Gender:
    Male
    Ratings:
    +1,904
    SIFT AMT [A3FTIZ5TURK6TO] Perspective Taking Study - $5.00 | PANDA


    Unrated

    Unrated

    Unrated
    $59.60 / hour
    00:05:02 / completion time
    Pros:
    Cons:
    180 char min writing prompt


    Catchability: Okay (HIT Last Seen: 26 minutes ago)
    Qualifications: HIT approval rate (%) > 90;

    To read SIFT AMT's full profile check out TurkerView!
     
  18. InfiniteChanges

    InfiniteChanges Survey Slinger TurkerView Masters

    Messages:
    9,034
    Gender:
    Male
    Ratings:
    +10,396
    I want LESS parentheses as that means there are less bills to be calculated. Do you want some of my parentheses, and if yes what's your CC information so I can them to to auto pay starting with my $1500 rent.
     
    • LOL LOL x 1
  19. Squatcobbler

    Squatcobbler Survey Slinger

    Messages:
    10,041
    Gender:
    Male
    Ratings:
    +11,818
    ok, thx!
     
  20. gurlondrums

    gurlondrums Cracker of the Step Whip

    Messages:
    27,160
    Gender:
    Female
    Ratings:
    +76,023
    man, I haven't seen that in years

    [​IMG]
     
    • LOL LOL x 2
Thread Status:
Not open for further replies.