{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Data","Worksheet A","Worksheet B","Rules","How to use the generator"],"not_rendered":{"images":3,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"merged":[[1,1,5,2],[1,3,2,4],[3,3,5,4],[8,1,8,3],[9,1,9,3]]}
[]
[null,"Welcome to the Mutual dictation generator! Please type/paste your text into the grid below.\nIf you are typing your text, press ALT and Enter to add a line break/start a new line. When you are ready, click on the Worksheet tabs at the bottom of the page. For more information, read the Rules tab. Your Worksheets are now ready to print.",null,"EFLsummerschool"]
[]
[{"$nulls":3},"Enter a level of difficulty in cell E7: 1-30.\n1=difficult, 30=easy.\nWorksheet B will calibrate automatically but the difficulty level can also be entered manually in cell E8."]
[]
[]
[null,"Citation:",null,"Worksheet A:",30]
[null,"    Game name:",null,"Worksheet B:",{"$f":"E7+4","v":34}]
[null,{"$f":"IF(E10>1810,\"You might have written too much\", \"Enter your text here\")","v":"Enter your text here"},null,null,"Text: 1810 characters max (including spaces)"]
[{"$nulls":4},{"$f":"LEN(B10)","v":0}]

{"sheet":"Worksheet A","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[3,1,3,2],[4,1,7,2]]}
[]
[null,{"$f":"IF(Data!C8=\"\",\"\", \"(\" & Data!C8 & \")\")","v":""},"Mutual dictation"]
[null,{"$f":"IF(Data!C7=\"\",\"\",\"(Source: \" & Data!C7 & \")\")","v":""},"eflsummerschool.wordpress.com"]
[null,"Worksheet A. Fill in the gaps:"]
[null,{"$f":"ReplaceWords(Data!B10,\"__________________\",Data!E7)","v":""}]

{"sheet":"Worksheet B","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[3,1,3,2],[4,1,7,2]]}
[]
[null,{"$f":"IF(Data!C8=\"\",\"\", \"(\" & Data!C8 & \")\")","v":""},"Mutual dictation"]
[null,{"$f":"IF(Data!C7=\"\",\"\",\"(Source: \" & Data!C7 & \")\")","v":""},"eflsummerschool.wordpress.com"]
[null,"Worksheet B. Fill in the gaps:"]
[null,{"$f":"ReplaceWords(Data!B10,\"__________________\",Data!E8)","v":""}]

{"sheet":"Rules","index":3,"n_rows":7,"n_cols":2,"rows_kept":7}
[]
[null,"The rules"]
[null,"1. Each student pair needs a Worksheet A and Worksheet B (one each). Both Worksheets will have the same text but different gaps."]
[null,"2. If there is an odd number, make one group of three. Give the third student Worksheet A."]
[null,"3. Student pairs should sit facing each other."]
[null,"4. Each student should not let their partner see their Worksheet."]
[null,"5. Student pairs dictate their text and help each other to complete the gaps in their Worksheet."]

{"sheet":"How to use the generator","index":4,"n_rows":5,"n_cols":2,"rows_kept":5}
[]
[null,"How to use the generator"]
[null,"1.    Type/paste your text into the grid on the Data sheet."]
[null,"2.    Set the level of challenge on the Data sheet by typing a number between 1-30 in cell E7: 1=difficult, 30=easy. Worksheet B will automatically calibrate but can overridden by entering a number between 1-30 to set the difficulty level. Cells E7 and E8 should not contain the same numbers as this will result in both Worksheets having the same gaps."]
[null,"3.    Your Worksheets are ready to print."]