I have a small project. I have many files, each file has 25-30 short transcripts. I need these to be put into spreadsheets (google sheets) . The number of transcripts for each spreadsheets depends on the level and type of transcript. The project will take around 70-75 hours.
Here is a video of a very similar project .
[login to view URL]
Here are the steps need to be completed.
-Open Shadowing Project_Google Sheets Structure
-Read information about Level and Type of Test
-Open file from one set
Open corresponding spreadsheet in Google Sheets Templates folder
Cut and Paste the question name/title “MCQuestionBankB1_3(1)” to the QuestionID cell in the google sheets
Cut and paste the full transcript into the cell titled "FullScript1"
Cut and Paste the individual script lines to the cells in the columns titled Script1 Line1, Script1 Line2, Script1 Line3, Script1 Line4
Choose the next transcript in the file and repeat the process
Cut and Paste the question ID, full script into and individual script lines into the cells in the columns titled QuestionID 2, FullScript2, Script2 Line1, Script2 Line2, Script2 Line3, Script2 Line4
Repeat this process .Each test has different number of transcripts, so look at Listening Project_Google Sheets Structure file, in that file the needed number of transcripts is written.
When finished, change the spreadsheet name to "Level+Type+Test+1". For example "5kyuu_Type1_Test1", 5kyuu_Type1_Test1", "5kyuu_Type1_Test1", ect.
Download the spreadsheet as a CSV file
After you finish all the spreadsheets go to [login to view URL]
In Step 1: Click "Choose File" and select the CSV file you saved from Google Sheets
In Step 5: go to "Save your result" and add the name of the CSV file, (5kyuu_Type1_Test1)
Go to the button "Download Result", click it and download the new json file
Do this for all CSV files
Save both cvs and JSON files
Được trao cho:
Hello dear, As we have discussed and agreed over the things. so please share the related files and docs so that i can start work and can deliver on time. Thanks Ruchi
139 freelancer chào giá trung bình$129 cho công việc này
Hello, I can assist you to put Q&A into the google sheets and then convert to CSV/JSON following your video guide. Please drop a PM if you’re interested. Best regards, Hoang
Hi, I have watched your sample video and I am very interested to work on your project. Ready to here any further details and to start right away. Looking forward to be working with you. Thanks!
I have checked the video. I can do the task 100% accurately at a cheap rate . I am a professional, hard-working, self-motivated, and honest person. Please send a message to further discuss the task. Thank You.
Hi, I have read your requirements and checked your file. I understand the task and ready to work on it asap. Please contact me so we can start. Thanks
Hi Sir, Please provide me these files. I can Easily include these questions and options In a very short time. I watched the video. I can do this job step by step. Contact me soon. Thanks