0

Does anyone have a good method for approving people who took part in a survey on survey monkey, and who were recruited through mechanical turk? I filter out people who did not pay attention during the survey by asking questions with obvious answers - if people get 'n' number of them wrong, I exclude them from payment.

After I downloaded .csv from mechanical turk, I paste two columns at the end of the .csv the MTurk Id and a 1 or 0 next to the name, indicating whether they will be paid or not. How can I write a function that will search through the two columns containing MTurk ID's (the one that came in the .csv and the one that I pasted in) and then return whether the MTurk ID has a 1 or 0 next to it? his would make dis/approving so much easier.

ProgramFOX
  • 6,131
  • 11
  • 45
  • 51
brainman
  • 163
  • 3
  • 5
  • 11

1 Answers1

1

I assume you are using a spreadsheet program since you mention "Adding two columns"? Why don't you just sort by the column with the one or zero in it to group the approved turk IDs together?

Here is how to accomplish this with a vlookup:

Assume you have your list of Turk IDs and the 1/0 approval code in columns A and B (A contains the Turk IDs and B contains a 1 or 0). Also assume you have the ID to test in column C and you are going to put the result of the vlookup test in column D:

  A - Turk ID     B - Approval     C - ID to test     D - Result
  -----------     ------------     --------------     ----------
1 ABC12345        0                DEF46253
2 ERF78878        1                HFH36251
3 HFH36251        1                ERF78878
4 DEF46253        0                ABC12345

Set the formula of cell D1 to =VLOOKUP(C1,$A$1:$B$4,2,FALSE)

Paste that into D2..D4 (obviously your list will be larger)

It will find the Turk ID in Col A and fill in the corresponding Approval value in Col D.

If you want to know what the arguments to the vlookup function are - the first is the value to look for (the ID you want to check), the second is the entire range of values to check (use the $'s in front of the cell references to make them absolute, so they don't change when you paste the formula into new cells), the third is the column of that range to pull (column 2 of the range is the approval number), the last argument is FALSE which forces an exact match of ID to ID).

Hope that helps.

Jim
  • 2,300
  • 1
  • 19
  • 43
  • the turk ID's are not in the same rows. Do you know how to write a vlookup function that would search for whether there are matching turk IDs, and if so, then look to see if there is a 1 or 0 next to the Turk ID. if there is a 1, then return good, if there is 0, then return bad. This is essentially what i would like to accomplish! – brainman Jun 05 '12 at 21:18
  • @jared - if it helped you out, I'd appreciate you marking my answer as correct – Jim Jun 05 '12 at 22:06