Hi,

I use Mturk of Amazon to some of my tasks. In one of them I upload batch of sentences that I want each one to be rewritten twice.

After that task completed,the output contain many columns but there are two important columns:

"Input.sentence" - The original sentence that needs to be rewritten
"Answer.Q2" - Which contain the rewritten sentence.

So, for each sentence I have two rows, where the "Input.sentence" values are duplicate.

The problem:

I use spin tool that take the three sentences (the original and its two rewritten sentences) and each iteration pick one of them.
To do that the sentences needs to be in the following format: {original sentence|rewritten sentence1|rewritten sentence2}

The Project:

Attached Mturk output file to test the macro.

The Macro needs to create new worksheet that will be named: "Spun Article" in the Mturk out file.

In this worksheet will contain five columns: "Sentence ID","Original Sentence","Rewritten Sentence 1","Rewritten Sentence 2","Spin sentence". The first column values of course will be the sentence ID (1,2,3) in the order they appear in the Mturk output file. The next three columns will contain each one the relevant sentence. The lat column will contain the spun sentences in the spin format {original sentence|rewritten sentence1|rewritten sentence2}

In the attached file I created the new worksheet with just one sentence as example. Of course that the worksheet needs to include all the sentences in the output.

The macro should be compatible with Excel 2007.

Please provide also instructions document that will describe how to install it and how I run it.





Attached file: Batch_207016_result-Source.csv
File info: Mturk Output FileAttached file: Batch_207016_result.csv
File info: The Macro Output ExampleI attached two files. One is the Mturk output file and one it the desired Macro output file. I did it for one sentence but it should be for all sentences and in the same worksheet.

Thanks,
Ori