{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["-HOW TO USE-","Main spreadsheet - all genres","FICTION","FICTION (paper 1 pg)","PERSUASIVE","PERSUASIVE (paper 1 pg)","RECOUNT","RECOUNT (paper 1 pg)","INFO REPORT","INFO REPORT (paper 1 pg)","EXPOSITION","EXPOSITION (paper 1 pg)"],"not_rendered":{"defined_names":22},"read":"whole","date_system":"1900"}

{"sheet":"-HOW TO USE-","index":0,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[0,0,0,13],[0,14,0,15],[6,0,6,15],[8,0,8,15],[11,0,11,15],[13,1,14,13],[17,1,17,15],[19,1,19,15],[20,1,20,13]]}
["Grammar Evaluation & Analysis Tool: Detailed Analysis",{"$nulls":13},"v2"]
["Tool Overview"]
[" -   This tool can be used to evaluate students’ grammar use in oral and written modalities across conversation & text genres.  "]
[]
[" -   This tool can be used as a checklist to evaluate the range of grammar elements used "]
["      and/or to rate the quality of students’ grammar use."]
["                    o   If using the tool to rate quality, these ratings depend on educator judgement.  \n                               As such if making comparisons between students, ratings need to be done by the same educator. "]
[]
["            -   Parts of this tool can be used independently from each other: \n                      choose the grammar aspects that are most suited to your needs and only use those."]
[]
[" -   Use the tool instruction sheet to guide ratings / as a record sheet for individual students"]
["            -   To record multiple students’ data, or to only look at genre-specific grammatical features, \n                        use this excel spreadsheet template (electronically or printed out)."]
[]
[null,"Click here to view the tool instruction sheet for further details and for how to assess students' work"]
[]
[]
["Excel Spreadsheet Overview"]
[null," -  This spreadsheet consists of a several tabs, most being text genre specific. \n -   For each genre there are 2 versions: one spreadsheet set up to be used electronically, \n       another formatted to be printed & used in a paper based way (set up without notes space, to fit on 1 page).\n -  Choose and use the most relevant tab for your needs - customise these by altering the features included in analysis (see below). \n  - Group average scores are displayed at the bottom of each data table"]
[]
[null," - The yellow tab is the main spreadsheet which has all key grammar features.\n    In this tab, each grammar feature has the genres it is particularly important for 'tagged'. \n    There is a row called 'Feature being analysed?', where all features have a \"Y\" above the feature name as a default.\n       If you do not want to analyse your students' work for particular features (e.g. articles), delete the \"Y\" above that grammar feature. \n      This will impact the total and percentage scores automatically calculated for you."]
[null," - The other tabs by default only show the grammar elements particularly relevant to that specific genre.\n     You can unhide columns to show the same information as is present in the main spreadsheet, including space for comments  \n            (each tab is a copy of the main spreadsheet with the less relevant columns hidden).\n      Likewise you can hide columns which you do not need (right click on the column letter & press 'hide')"]

{"sheet":"Main spreadsheet - all genres","index":1,"n_rows":48,"n_cols":63,"rows_kept":48,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nAll Features",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nAll Features"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
["Genres grammar feature is particularly important for:\nKEY:  Fic = Fiction;  Rec = Recount;  \nPers = Persuasive;  Proc = Procedure\nInfo = Information reports; \nExpo = Exposition",{"$nulls":7},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A22=\"\",\"\",(E22+G22)),\"\")","v":""},{"$f":"IFERROR(IF(A22=\"\",\"\",(B22/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E22,G22),\"\")","v":""},{"$nulls":54},{"$f":"IF(A22=\"\",\"\",(COUNTA(I22,K22,M22,O22,Q22,S22,U22,W22,Y22,AA22,AC22,AE22,AG22,AI22,AK22,AM22,AO22,AQ22,AS22,AU22,AW22,AY22,BA22,BC22,BE22)))","v":""},{"$f":"IFERROR(BG22/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A22=\"\",\"\",(IFERROR(SUM(I22,K22,M22,O22,Q22,S22,U22,W22,Y22,AA22,AC22,AE22,AG22,AI22,AK22,AM22,AO22,AQ22,AS22,AU22,AW22,AY22,BA22,BC22,BE22),\"\")))","v":""},{"$f":"IF(A22=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI22=\"\",\"\",(IFERROR(BI22/BJ22,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B47)=0,\"NA\",AVERAGE(B12:B47))","v":"NA"},{"$f":"IF(COUNT(C12:C47)=0,\"NA\",AVERAGE(C12:C47))","v":"NA"},{"$f":"IF(COUNT(D12:D47)=0,\"NA\",AVERAGE(D12:D47))","v":"NA"},{"$f":"IF(COUNTA(E12:E47)=0,\"NA\",(IF(COUNT(E12:E47)>0,AVERAGE(E12:E47),COUNTA(E12:E47))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G47)=0,\"NA\",(IF(COUNT(G12:G47)>0,AVERAGE(G12:G47),COUNTA(G12:G47))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I47)=0,\"NA\",(IF(COUNT(I12:I47)>0,AVERAGE(I12:I47),COUNTA(I12:I47))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K47)=0,\"NA\",(IF(COUNT(K12:K47)>0,AVERAGE(K12:K47),COUNTA(K12:K47))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M47)=0,\"NA\",(IF(COUNT(M12:M47)>0,AVERAGE(M12:M47),COUNTA(M12:M47))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O47)=0,\"NA\",(IF(COUNT(O12:O47)>0,AVERAGE(O12:O47),COUNTA(O12:O47))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q47)=0,\"NA\",(IF(COUNT(Q12:Q47)>0,AVERAGE(Q12:Q47),COUNTA(Q12:Q47))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S47)=0,\"NA\",(IF(COUNT(S12:S47)>0,AVERAGE(S12:S47),COUNTA(S12:S47))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U47)=0,\"NA\",(IF(COUNT(U12:U47)>0,AVERAGE(U12:U47),COUNTA(U12:U47))))","v":"NA"},".",{"$f":"IF(COUNTA(W12:W47)=0,\"NA\",(IF(COUNT(W12:W47)>0,AVERAGE(W12:W47),COUNTA(W12:W47))))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y47)=0,\"NA\",(IF(COUNT(Y12:Y47)>0,AVERAGE(Y12:Y47),COUNTA(Y12:Y47))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA47)=0,\"NA\",(IF(COUNT(AA12:AA47)>0,AVERAGE(AA12:AA47),COUNTA(AA12:AA47))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC47)=0,\"NA\",(IF(COUNT(AC12:AC47)>0,AVERAGE(AC12:AC47),COUNTA(AC12:AC47))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE47)=0,\"NA\",(IF(COUNT(AE12:AE47)>0,AVERAGE(AE12:AE47),COUNTA(AE12:AE47))))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG47)=0,\"NA\",(IF(COUNT(AG12:AG47)>0,AVERAGE(AG12:AG47),COUNTA(AG12:AG47))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI47)=0,\"NA\",(IF(COUNT(AI12:AI47)>0,AVERAGE(AI12:AI47),COUNTA(AI12:AI47))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK47)=0,\"NA\",(IF(COUNT(AK12:AK47)>0,AVERAGE(AK12:AK47),COUNTA(AK12:AK47))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM47)=0,\"NA\",(IF(COUNT(AM12:AM47)>0,AVERAGE(AM12:AM47),COUNTA(AM12:AM47))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO47)=0,\"NA\",(IF(COUNT(AO12:AO47)>0,AVERAGE(AO12:AO47),COUNTA(AO12:AO47))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ47)=0,\"NA\",(IF(COUNT(AQ12:AQ47)>0,AVERAGE(AQ12:AQ47),COUNTA(AQ12:AQ47))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS47)=0,\"NA\",(IF(COUNT(AS12:AS47)>0,AVERAGE(AS12:AS47),COUNTA(AS12:AS47))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU47)=0,\"NA\",(IF(COUNT(AU12:AU47)>0,AVERAGE(AU12:AU47),COUNTA(AU12:AU47))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW47)=0,\"NA\",(IF(COUNT(AW12:AW47)>0,AVERAGE(AW12:AW47),COUNTA(AW12:AW47))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY47)=0,\"NA\",(IF(COUNT(AY12:AY47)>0,AVERAGE(AY12:AY47),COUNTA(AY12:AY47))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA47)=0,\"NA\",(IF(COUNT(BA12:BA47)>0,AVERAGE(BA12:BA47),COUNTA(BA12:BA47))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC47)=0,\"NA\",(IF(COUNT(BC12:BC47)>0,AVERAGE(BC12:BC47),COUNTA(BC12:BC47))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE47)=0,\"NA\",(IF(COUNT(BE12:BE47)>0,AVERAGE(BE12:BE47),COUNTA(BE12:BE47))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG47)=0,\"NA\",AVERAGE(BG12:BG47))","v":"NA"},{"$f":"IF(COUNT(BH12:BH47)=0,\"NA\",AVERAGE(BH12:BH47))","v":"NA"},{"$f":"IF(COUNT(BI12:BI47)=0,\"NA\",AVERAGE(BI12:BI47))","v":"NA"},{"$f":"IF(COUNT(BJ12:BJ47)=0,\"NA\",AVERAGE(BJ12:BJ47))","v":"NA"},"NA"]

{"sheet":"FICTION","index":2,"n_rows":49,"n_cols":63,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[1,57,1,62],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nFICTION",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nFICTION"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":5},"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A20=\"\",\"\",(E20+G20)),\"\")","v":""},{"$f":"IFERROR(IF(A20=\"\",\"\",(B20/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E20,G20),\"\")","v":""},{"$nulls":54},{"$f":"IF(A20=\"\",\"\",(COUNTA(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20)))","v":""},{"$f":"IFERROR(BG20/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A20=\"\",\"\",(IFERROR(SUM(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20),\"\")))","v":""},{"$f":"IF(A20=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI20=\"\",\"\",(IFERROR(BI20/BJ20,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G48)=0,\"NA\",(IF(COUNT(G12:G48)>0,AVERAGE(G12:G48),COUNTA(G12:G48))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I48)=0,\"NA\",(IF(COUNT(I12:I48)>0,AVERAGE(I12:I48),COUNTA(I12:I48))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K48)=0,\"NA\",(IF(COUNT(K12:K48)>0,AVERAGE(K12:K48),COUNTA(K12:K48))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M48)=0,\"NA\",(IF(COUNT(M12:M48)>0,AVERAGE(M12:M48),COUNTA(M12:M48))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O48)=0,\"NA\",(IF(COUNT(O12:O48)>0,AVERAGE(O12:O48),COUNTA(O12:O48))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q48)=0,\"NA\",(IF(COUNT(Q12:Q48)>0,AVERAGE(Q12:Q48),COUNTA(Q12:Q48))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S48)=0,\"NA\",(IF(COUNT(S12:S48)>0,AVERAGE(S12:S48),COUNTA(S12:S48))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U48)=0,\"NA\",(IF(COUNT(U12:U48)>0,AVERAGE(U12:U48),COUNTA(U12:U48))))","v":"NA"},".",{"$f":"IF(COUNT(W12:W48)=0,\"NA\",AVERAGE(W12:W48))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y48)=0,\"NA\",(IF(COUNT(Y12:Y48)>0,AVERAGE(Y12:Y48),COUNTA(Y12:Y48))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA48)=0,\"NA\",(IF(COUNT(AA12:AA48)>0,AVERAGE(AA12:AA48),COUNTA(AA12:AA48))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC48)=0,\"NA\",(IF(COUNT(AC12:AC48)>0,AVERAGE(AC12:AC48),COUNTA(AC12:AC48))))","v":"NA"},".",{"$f":"IF(COUNT(AE12:AE48)=0,\"NA\",AVERAGE(AE12:AE48))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG48)=0,\"NA\",(IF(COUNT(AG12:AG48)>0,AVERAGE(AG12:AG48),COUNTA(AG12:AG48))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI48)=0,\"NA\",(IF(COUNT(AI12:AI48)>0,AVERAGE(AI12:AI48),COUNTA(AI12:AI48))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK48)=0,\"NA\",(IF(COUNT(AK12:AK48)>0,AVERAGE(AK12:AK48),COUNTA(AK12:AK48))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM48)=0,\"NA\",(IF(COUNT(AM12:AM48)>0,AVERAGE(AM12:AM48),COUNTA(AM12:AM48))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO48)=0,\"NA\",(IF(COUNT(AO12:AO48)>0,AVERAGE(AO12:AO48),COUNTA(AO12:AO48))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ48)=0,\"NA\",(IF(COUNT(AQ12:AQ48)>0,AVERAGE(AQ12:AQ48),COUNTA(AQ12:AQ48))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS48)=0,\"NA\",(IF(COUNT(AS12:AS48)>0,AVERAGE(AS12:AS48),COUNTA(AS12:AS48))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU48)=0,\"NA\",(IF(COUNT(AU12:AU48)>0,AVERAGE(AU12:AU48),COUNTA(AU12:AU48))))","v":"NA"},".",{"$f":"IF(COUNT(AW12:AW48)=0,\"NA\",AVERAGE(AW12:AW48))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY48)=0,\"NA\",(IF(COUNT(AY12:AY48)>0,AVERAGE(AY12:AY48),COUNTA(AY12:AY48))))","v":"NA"},".",{"$f":"IF(COUNT(BA12:BA48)=0,\"NA\",AVERAGE(BA12:BA48))","v":"NA"},".",{"$f":"IF(COUNT(BC12:BC48)=0,\"NA\",AVERAGE(BC12:BC48))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE48)=0,\"NA\",(IF(COUNT(BE12:BE48)>0,AVERAGE(BE12:BE48),COUNTA(BE12:BE48))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},"NA","NA"]

{"sheet":"FICTION (paper 1 pg)","index":3,"n_rows":49,"n_cols":64,"rows_kept":49,"merged":[[0,0,0,13],[1,0,4,0],[2,5,2,6],[2,12,2,15],[2,16,2,20],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nFICTION"]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":7},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/ what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":5},"Y",{"$nulls":6},"Notes"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
{"$rows_empty":15}
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},{"$f":"IF(COUNTA(F12:F48)=0,\"NA\",(IF(COUNT(F12:F48)>0,AVERAGE(F12:F48),COUNTA(F12:F48))))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},"NA","NA"]

{"sheet":"PERSUASIVE","index":4,"n_rows":49,"n_cols":63,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nPERSUASIVE",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nPERSUASIVE"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",{"$nulls":7},"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,{"$f":"IFERROR(IF(A14=\"\",\"\",(E14+G14)),\"\")","v":""},{"$f":"IFERROR(IF(A14=\"\",\"\",(B14/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E14,G14),\"\")","v":""},{"$nulls":54},{"$f":"IF(A14=\"\",\"\",(COUNTA(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14)))","v":""},{"$f":"IFERROR(BG14/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A14=\"\",\"\",(IFERROR(SUM(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14),\"\")))","v":""},{"$f":"IF(A14=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI14=\"\",\"\",(IFERROR(BI14/BJ14,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A46=\"\",\"\",(E46+G46)),\"\")","v":""},{"$f":"IFERROR(IF(A46=\"\",\"\",(B46/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E46,G46),\"\")","v":""},{"$nulls":54},{"$f":"IF(A46=\"\",\"\",(COUNTA(I46,K46,M46,O46,Q46,S46,U46,W46,Y46,AA46,AC46,AE46,AG46,AI46,AK46,AM46,AO46,AQ46,AS46,AU46,AW46,AY46,BA46,BC46,BE46)))","v":""},{"$f":"IFERROR(BG46/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A46=\"\",\"\",(IFERROR(SUM(I46,K46,M46,O46,Q46,S46,U46,W46,Y46,AA46,AC46,AE46,AG46,AI46,AK46,AM46,AO46,AQ46,AS46,AU46,AW46,AY46,BA46,BC46,BE46),\"\")))","v":""},{"$f":"IF(A46=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI46=\"\",\"\",(IFERROR(BI46/BJ46,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G48)=0,\"NA\",(IF(COUNT(G12:G48)>0,AVERAGE(G12:G48),COUNTA(G12:G48))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I48)=0,\"NA\",(IF(COUNT(I12:I48)>0,AVERAGE(I12:I48),COUNTA(I12:I48))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K48)=0,\"NA\",(IF(COUNT(K12:K48)>0,AVERAGE(K12:K48),COUNTA(K12:K48))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M48)=0,\"NA\",(IF(COUNT(M12:M48)>0,AVERAGE(M12:M48),COUNTA(M12:M48))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O48)=0,\"NA\",(IF(COUNT(O12:O48)>0,AVERAGE(O12:O48),COUNTA(O12:O48))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q48)=0,\"NA\",(IF(COUNT(Q12:Q48)>0,AVERAGE(Q12:Q48),COUNTA(Q12:Q48))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S48)=0,\"NA\",(IF(COUNT(S12:S48)>0,AVERAGE(S12:S48),COUNTA(S12:S48))))","v":"NA"},".",{"$f":"IF(COUNT(U12:U48)=0,\"NA\",AVERAGE(U12:U48))","v":"NA"},".",{"$f":"IF(COUNT(W12:W48)=0,\"NA\",AVERAGE(W12:W48))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y48)=0,\"NA\",(IF(COUNT(Y12:Y48)>0,AVERAGE(Y12:Y48),COUNTA(Y12:Y48))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA48)=0,\"NA\",(IF(COUNT(AA12:AA48)>0,AVERAGE(AA12:AA48),COUNTA(AA12:AA48))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC48)=0,\"NA\",(IF(COUNT(AC12:AC48)>0,AVERAGE(AC12:AC48),COUNTA(AC12:AC48))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE48)=0,\"NA\",(IF(COUNT(AE12:AE48)>0,AVERAGE(AE12:AE48),COUNTA(AE12:AE48))))","v":"NA"},".",{"$f":"IF(COUNT(AG12:AG48)=0,\"NA\",AVERAGE(AG12:AG48))","v":"NA"},".",{"$f":"IF(COUNT(AI12:AI48)=0,\"NA\",AVERAGE(AI12:AI48))","v":"NA"},".",{"$f":"IF(COUNT(AK12:AK48)=0,\"NA\",AVERAGE(AK12:AK48))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM48)=0,\"NA\",(IF(COUNT(AM12:AM48)>0,AVERAGE(AM12:AM48),COUNTA(AM12:AM48))))","v":"NA"},".",{"$f":"IF(COUNT(AO12:AO48)=0,\"NA\",AVERAGE(AO12:AO48))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ48)=0,\"NA\",(IF(COUNT(AQ12:AQ48)>0,AVERAGE(AQ12:AQ48),COUNTA(AQ12:AQ48))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS48)=0,\"NA\",(IF(COUNT(AS12:AS48)>0,AVERAGE(AS12:AS48),COUNTA(AS12:AS48))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU48)=0,\"NA\",(IF(COUNT(AU12:AU48)>0,AVERAGE(AU12:AU48),COUNTA(AU12:AU48))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW48)=0,\"NA\",(IF(COUNT(AW12:AW48)>0,AVERAGE(AW12:AW48),COUNTA(AW12:AW48))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY48)=0,\"NA\",(IF(COUNT(AY12:AY48)>0,AVERAGE(AY12:AY48),COUNTA(AY12:AY48))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA48)=0,\"NA\",(IF(COUNT(BA12:BA48)>0,AVERAGE(BA12:BA48),COUNTA(BA12:BA48))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC48)=0,\"NA\",(IF(COUNT(BC12:BC48)>0,AVERAGE(BC12:BC48),COUNTA(BC12:BC48))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE48)=0,\"NA\",(IF(COUNT(BE12:BE48)>0,AVERAGE(BE12:BE48),COUNTA(BE12:BE48))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},"NA","NA"]

{"sheet":"PERSUASIVE (paper 1 pg)","index":5,"n_rows":49,"n_cols":64,"rows_kept":49,"merged":[[0,0,0,13],[0,50,0,56],[1,0,4,0],[2,5,2,6],[2,12,2,15],[2,16,2,20],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nPERSUASIVE"]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":7},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",{"$nulls":7},"Y",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":6},"Notes"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,{"$f":"IFERROR(IF(A14=\"\",\"\",(E14+G14)),\"\")","v":""},{"$f":"IFERROR(IF(A14=\"\",\"\",(B14/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E14,G14),\"\")","v":""},{"$nulls":54},{"$f":"IF(A14=\"\",\"\",(COUNTA(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14)))","v":""},{"$f":"IFERROR(BG14/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A14=\"\",\"\",(IFERROR(SUM(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14),\"\")))","v":""},{"$f":"IF(A14=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI14=\"\",\"\",(IFERROR(BI14/BJ14,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},{"$f":"IF(COUNTA(F12:F48)=0,\"NA\",(IF(COUNT(F12:F48)>0,AVERAGE(F12:F48),COUNTA(F12:F48))))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},"NA","NA"]

{"sheet":"RECOUNT","index":6,"n_rows":47,"n_cols":63,"rows_kept":47,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nRECOUNT",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nRECOUNT"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":7},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A20=\"\",\"\",(E20+G20)),\"\")","v":""},{"$f":"IFERROR(IF(A20=\"\",\"\",(B20/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E20,G20),\"\")","v":""},{"$nulls":54},{"$f":"IF(A20=\"\",\"\",(COUNTA(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20)))","v":""},{"$f":"IFERROR(BG20/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A20=\"\",\"\",(IFERROR(SUM(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20),\"\")))","v":""},{"$f":"IF(A20=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI20=\"\",\"\",(IFERROR(BI20/BJ20,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B46)=0,\"NA\",AVERAGE(B12:B46))","v":"NA"},{"$f":"IF(COUNT(C12:C46)=0,\"NA\",AVERAGE(C12:C46))","v":"NA"},{"$f":"IF(COUNT(D12:D46)=0,\"NA\",AVERAGE(D12:D46))","v":"NA"},{"$f":"IF(COUNTA(E12:E46)=0,\"NA\",(IF(COUNT(E12:E46)>0,AVERAGE(E12:E46),COUNTA(E12:E46))))","v":"NA"},{"$f":"IF(COUNTA(F12:F46)=0,\"NA\",(IF(COUNT(F12:F46)>0,AVERAGE(F12:F46),COUNTA(F12:F46))))","v":"NA"},"NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",{"$f":"IF(COUNT(BA12:BA46)=0,\"NA\",AVERAGE(BA12:BA46))","v":"NA"},".",{"$f":"IF(COUNT(BC12:BC46)=0,\"NA\",AVERAGE(BC12:BC46))","v":"NA"},".",{"$f":"IF(COUNT(BE12:BE46)=0,\"NA\",AVERAGE(BE12:BE46))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG46)=0,\"NA\",AVERAGE(BG12:BG46))","v":"NA"},{"$f":"IF(COUNT(BH12:BH46)=0,\"NA\",AVERAGE(BH12:BH46))","v":"NA"},{"$f":"IF(COUNT(BI12:BI46)=0,\"NA\",AVERAGE(BI12:BI46))","v":"NA"},"NA","NA"]

{"sheet":"RECOUNT (paper 1 pg)","index":7,"n_rows":49,"n_cols":64,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,12,2,15],[2,16,2,20],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nRECOUNT",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nRECOUNT"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":7},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":7},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":12},"Notes"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,{"$f":"IFERROR(IF(A13=\"\",\"\",(E13+G13)),\"\")","v":""},{"$f":"IFERROR(IF(A13=\"\",\"\",(B13/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E13,G13),\"\")","v":""},{"$nulls":54},{"$f":"IF(A13=\"\",\"\",(COUNTA(I13,K13,M13,O13,Q13,S13,U13,W13,Y13,AA13,AC13,AE13,AG13,AI13,AK13,AM13,AO13,AQ13,AS13,AU13,AW13,AY13,BA13,BC13,BE13)))","v":""},{"$f":"IFERROR(BG13/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A13=\"\",\"\",(IFERROR(SUM(I13,K13,M13,O13,Q13,S13,U13,W13,Y13,AA13,AC13,AE13,AG13,AI13,AK13,AM13,AO13,AQ13,AS13,AU13,AW13,AY13,BA13,BC13,BE13),\"\")))","v":""},{"$f":"IF(A13=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI26=\"\",\"\",(IFERROR(BI26/BJ26,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A44=\"\",\"\",(E44+G44)),\"\")","v":""},{"$f":"IFERROR(IF(A44=\"\",\"\",(B44/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E44,G44),\"\")","v":""},{"$nulls":54},{"$f":"IF(A44=\"\",\"\",(COUNTA(I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44,AE44,AG44,AI44,AK44,AM44,AO44,AQ44,AS44,AU44,AW44,AY44,BA44,BC44,BE44)))","v":""},{"$f":"IFERROR(BG44/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A44=\"\",\"\",(IFERROR(SUM(I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44,AE44,AG44,AI44,AK44,AM44,AO44,AQ44,AS44,AU44,AW44,AY44,BA44,BC44,BE44),\"\")))","v":""},{"$f":"IF(A44=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI44=\"\",\"\",(IFERROR(BI44/BJ44,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNT(E12:E48)=0,\"NA\",AVERAGE(E12:E48))","v":"NA"},".",{"$f":"IF(COUNT(G12:G48)=0,\"NA\",AVERAGE(G12:G48))","v":"NA"},".",{"$f":"IF(COUNT(I12:I48)=0,\"NA\",AVERAGE(I12:I48))","v":"NA"},".",{"$f":"IF(COUNT(K12:K48)=0,\"NA\",AVERAGE(K12:K48))","v":"NA"},".",{"$f":"IF(COUNT(M12:M48)=0,\"NA\",AVERAGE(M12:M48))","v":"NA"},".",{"$f":"IF(COUNT(O12:O48)=0,\"NA\",AVERAGE(O12:O48))","v":"NA"},".",{"$f":"IF(COUNT(Q12:Q48)=0,\"NA\",AVERAGE(Q12:Q48))","v":"NA"},".",{"$f":"IF(COUNT(S12:S48)=0,\"NA\",AVERAGE(S12:S48))","v":"NA"},".",{"$f":"IF(COUNT(U12:U48)=0,\"NA\",AVERAGE(U12:U48))","v":"NA"},".",{"$f":"IF(COUNT(W12:W48)=0,\"NA\",AVERAGE(W12:W48))","v":"NA"},".",{"$f":"IF(COUNT(Y12:Y48)=0,\"NA\",AVERAGE(Y12:Y48))","v":"NA"},".",{"$f":"IF(COUNT(AA12:AA48)=0,\"NA\",AVERAGE(AA12:AA48))","v":"NA"},".",{"$f":"IF(COUNT(AC12:AC48)=0,\"NA\",AVERAGE(AC12:AC48))","v":"NA"},".",{"$f":"IF(COUNT(AE12:AE48)=0,\"NA\",AVERAGE(AE12:AE48))","v":"NA"},".",{"$f":"IF(COUNT(AG12:AG48)=0,\"NA\",AVERAGE(AG12:AG48))","v":"NA"},".",{"$f":"IF(COUNT(AI12:AI48)=0,\"NA\",AVERAGE(AI12:AI48))","v":"NA"},".",{"$f":"IF(COUNT(AK12:AK48)=0,\"NA\",AVERAGE(AK12:AK48))","v":"NA"},".",{"$f":"IF(COUNT(AM12:AM48)=0,\"NA\",AVERAGE(AM12:AM48))","v":"NA"},".",{"$f":"IF(COUNT(AO12:AO48)=0,\"NA\",AVERAGE(AO12:AO48))","v":"NA"},".",{"$f":"IF(COUNT(AQ12:AQ48)=0,\"NA\",AVERAGE(AQ12:AQ48))","v":"NA"},".",{"$f":"IF(COUNT(AS12:AS48)=0,\"NA\",AVERAGE(AS12:AS48))","v":"NA"},".",{"$f":"IF(COUNT(AU12:AU48)=0,\"NA\",AVERAGE(AU12:AU48))","v":"NA"},".",{"$f":"IF(COUNT(AW12:AW48)=0,\"NA\",AVERAGE(AW12:AW48))","v":"NA"},".",{"$f":"IF(COUNT(AY12:AY48)=0,\"NA\",AVERAGE(AY12:AY48))","v":"NA"},".",{"$f":"IF(COUNT(BA12:BA48)=0,\"NA\",AVERAGE(BA12:BA48))","v":"NA"},".",{"$f":"IF(COUNT(BC12:BC48)=0,\"NA\",AVERAGE(BC12:BC48))","v":"NA"},".",{"$f":"IF(COUNT(BE12:BE48)=0,\"NA\",AVERAGE(BE12:BE48))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},"NA","NA"]

{"sheet":"INFO REPORT","index":8,"n_rows":49,"n_cols":63,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nINFORMATION REPORT",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nINFORMATION REPORT"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/ what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":5},"Y",{"$nulls":3},"Y",{"$nulls":7},"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",{"$nulls":3},"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A20=\"\",\"\",(E20+G20)),\"\")","v":""},{"$f":"IFERROR(IF(A20=\"\",\"\",(B20/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E20,G20),\"\")","v":""},{"$nulls":54},{"$f":"IF(A20=\"\",\"\",(COUNTA(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20)))","v":""},{"$f":"IFERROR(BG20/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A20=\"\",\"\",(IFERROR(SUM(I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20,AE20,AG20,AI20,AK20,AM20,AO20,AQ20,AS20,AU20,AW20,AY20,BA20,BC20,BE20),\"\")))","v":""},{"$f":"IF(A20=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI20=\"\",\"\",(IFERROR(BI20/BJ20,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G48)=0,\"NA\",(IF(COUNT(G12:G48)>0,AVERAGE(G12:G48),COUNTA(G12:G48))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I48)=0,\"NA\",(IF(COUNT(I12:I48)>0,AVERAGE(I12:I48),COUNTA(I12:I48))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K48)=0,\"NA\",(IF(COUNT(K12:K48)>0,AVERAGE(K12:K48),COUNTA(K12:K48))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M48)=0,\"NA\",(IF(COUNT(M12:M48)>0,AVERAGE(M12:M48),COUNTA(M12:M48))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O48)=0,\"NA\",(IF(COUNT(O12:O48)>0,AVERAGE(O12:O48),COUNTA(O12:O48))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q48)=0,\"NA\",(IF(COUNT(Q12:Q48)>0,AVERAGE(Q12:Q48),COUNTA(Q12:Q48))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S48)=0,\"NA\",(IF(COUNT(S12:S48)>0,AVERAGE(S12:S48),COUNTA(S12:S48))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U48)=0,\"NA\",(IF(COUNT(U12:U48)>0,AVERAGE(U12:U48),COUNTA(U12:U48))))","v":"NA"},".",{"$f":"IF(COUNTA(W12:W48)=0,\"NA\",(IF(COUNT(W12:W48)>0,AVERAGE(W12:W48),COUNTA(W12:W48))))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y48)=0,\"NA\",(IF(COUNT(Y12:Y48)>0,AVERAGE(Y12:Y48),COUNTA(Y12:Y48))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA48)=0,\"NA\",(IF(COUNT(AA12:AA48)>0,AVERAGE(AA12:AA48),COUNTA(AA12:AA48))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC48)=0,\"NA\",(IF(COUNT(AC12:AC48)>0,AVERAGE(AC12:AC48),COUNTA(AC12:AC48))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE48)=0,\"NA\",(IF(COUNT(AE12:AE48)>0,AVERAGE(AE12:AE48),COUNTA(AE12:AE48))))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG48)=0,\"NA\",(IF(COUNT(AG12:AG48)>0,AVERAGE(AG12:AG48),COUNTA(AG12:AG48))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI48)=0,\"NA\",(IF(COUNT(AI12:AI48)>0,AVERAGE(AI12:AI48),COUNTA(AI12:AI48))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK48)=0,\"NA\",(IF(COUNT(AK12:AK48)>0,AVERAGE(AK12:AK48),COUNTA(AK12:AK48))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM48)=0,\"NA\",(IF(COUNT(AM12:AM48)>0,AVERAGE(AM12:AM48),COUNTA(AM12:AM48))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO48)=0,\"NA\",(IF(COUNT(AO12:AO48)>0,AVERAGE(AO12:AO48),COUNTA(AO12:AO48))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ48)=0,\"NA\",(IF(COUNT(AQ12:AQ48)>0,AVERAGE(AQ12:AQ48),COUNTA(AQ12:AQ48))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS48)=0,\"NA\",(IF(COUNT(AS12:AS48)>0,AVERAGE(AS12:AS48),COUNTA(AS12:AS48))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU48)=0,\"NA\",(IF(COUNT(AU12:AU48)>0,AVERAGE(AU12:AU48),COUNTA(AU12:AU48))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW48)=0,\"NA\",(IF(COUNT(AW12:AW48)>0,AVERAGE(AW12:AW48),COUNTA(AW12:AW48))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY48)=0,\"NA\",(IF(COUNT(AY12:AY48)>0,AVERAGE(AY12:AY48),COUNTA(AY12:AY48))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA48)=0,\"NA\",(IF(COUNT(BA12:BA48)>0,AVERAGE(BA12:BA48),COUNTA(BA12:BA48))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC48)=0,\"NA\",(IF(COUNT(BC12:BC48)>0,AVERAGE(BC12:BC48),COUNTA(BC12:BC48))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE48)=0,\"NA\",(IF(COUNT(BE12:BE48)>0,AVERAGE(BE12:BE48),COUNTA(BE12:BE48))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},{"$f":"IF(COUNT(BJ12:BJ48)=0,\"NA\",AVERAGE(BJ12:BJ48))","v":"NA"},"NA"]

{"sheet":"INFO REPORT (paper 1 pg)","index":9,"n_rows":49,"n_cols":64,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,12,2,15],[2,16,2,20],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nINFORMATION REPORT",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nINFORMATION REPORT"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":7},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammatic-ality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/ what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":5},"Y",{"$nulls":3},"Y",{"$nulls":7},"Y",null,"Y",{"$nulls":3},"Y",null,"Y",null,"Y",{"$nulls":3},"Y",null,"Y",{"$nulls":3},"Y",{"$nulls":6},"Notes"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,{"$f":"IFERROR(IF(A14=\"\",\"\",(E14+G14)),\"\")","v":""},{"$f":"IFERROR(IF(A14=\"\",\"\",(B14/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E14,G14),\"\")","v":""},{"$nulls":54},{"$f":"IF(A14=\"\",\"\",(COUNTA(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14)))","v":""},{"$f":"IFERROR(BG14/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A14=\"\",\"\",(IFERROR(SUM(I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14,AE14,AG14,AI14,AK14,AM14,AO14,AQ14,AS14,AU14,AW14,AY14,BA14,BC14,BE14),\"\")))","v":""},{"$f":"IF(A14=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI14=\"\",\"\",(IFERROR(BI14/BJ14,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A44=\"\",\"\",(E44+G44)),\"\")","v":""},{"$f":"IFERROR(IF(A44=\"\",\"\",(B44/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E44,G44),\"\")","v":""},{"$nulls":54},{"$f":"IF(A44=\"\",\"\",(COUNTA(I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44,AE44,AG44,AI44,AK44,AM44,AO44,AQ44,AS44,AU44,AW44,AY44,BA44,BC44,BE44)))","v":""},{"$f":"IFERROR(BG44/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A44=\"\",\"\",(IFERROR(SUM(I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44,AE44,AG44,AI44,AK44,AM44,AO44,AQ44,AS44,AU44,AW44,AY44,BA44,BC44,BE44),\"\")))","v":""},{"$f":"IF(A44=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI44=\"\",\"\",(IFERROR(BI44/BJ44,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":"NA"},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":"NA"},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G48)=0,\"NA\",(IF(COUNT(G12:G48)>0,AVERAGE(G12:G48),COUNTA(G12:G48))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I48)=0,\"NA\",(IF(COUNT(I12:I48)>0,AVERAGE(I12:I48),COUNTA(I12:I48))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K48)=0,\"NA\",(IF(COUNT(K12:K48)>0,AVERAGE(K12:K48),COUNTA(K12:K48))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M48)=0,\"NA\",(IF(COUNT(M12:M48)>0,AVERAGE(M12:M48),COUNTA(M12:M48))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O48)=0,\"NA\",(IF(COUNT(O12:O48)>0,AVERAGE(O12:O48),COUNTA(O12:O48))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q48)=0,\"NA\",(IF(COUNT(Q12:Q48)>0,AVERAGE(Q12:Q48),COUNTA(Q12:Q48))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S48)=0,\"NA\",(IF(COUNT(S12:S48)>0,AVERAGE(S12:S48),COUNTA(S12:S48))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U48)=0,\"NA\",(IF(COUNT(U12:U48)>0,AVERAGE(U12:U48),COUNTA(U12:U48))))","v":"NA"},".",{"$f":"IF(COUNTA(W12:W48)=0,\"NA\",(IF(COUNT(W12:W48)>0,AVERAGE(W12:W48),COUNTA(W12:W48))))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y48)=0,\"NA\",(IF(COUNT(Y12:Y48)>0,AVERAGE(Y12:Y48),COUNTA(Y12:Y48))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA48)=0,\"NA\",(IF(COUNT(AA12:AA48)>0,AVERAGE(AA12:AA48),COUNTA(AA12:AA48))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC48)=0,\"NA\",(IF(COUNT(AC12:AC48)>0,AVERAGE(AC12:AC48),COUNTA(AC12:AC48))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE48)=0,\"NA\",(IF(COUNT(AE12:AE48)>0,AVERAGE(AE12:AE48),COUNTA(AE12:AE48))))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG48)=0,\"NA\",(IF(COUNT(AG12:AG48)>0,AVERAGE(AG12:AG48),COUNTA(AG12:AG48))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI48)=0,\"NA\",(IF(COUNT(AI12:AI48)>0,AVERAGE(AI12:AI48),COUNTA(AI12:AI48))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK48)=0,\"NA\",(IF(COUNT(AK12:AK48)>0,AVERAGE(AK12:AK48),COUNTA(AK12:AK48))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM48)=0,\"NA\",(IF(COUNT(AM12:AM48)>0,AVERAGE(AM12:AM48),COUNTA(AM12:AM48))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO48)=0,\"NA\",(IF(COUNT(AO12:AO48)>0,AVERAGE(AO12:AO48),COUNTA(AO12:AO48))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ48)=0,\"NA\",(IF(COUNT(AQ12:AQ48)>0,AVERAGE(AQ12:AQ48),COUNTA(AQ12:AQ48))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS48)=0,\"NA\",(IF(COUNT(AS12:AS48)>0,AVERAGE(AS12:AS48),COUNTA(AS12:AS48))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU48)=0,\"NA\",(IF(COUNT(AU12:AU48)>0,AVERAGE(AU12:AU48),COUNTA(AU12:AU48))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW48)=0,\"NA\",(IF(COUNT(AW12:AW48)>0,AVERAGE(AW12:AW48),COUNTA(AW12:AW48))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY48)=0,\"NA\",(IF(COUNT(AY12:AY48)>0,AVERAGE(AY12:AY48),COUNTA(AY12:AY48))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA48)=0,\"NA\",(IF(COUNT(BA12:BA48)>0,AVERAGE(BA12:BA48),COUNTA(BA12:BA48))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC48)=0,\"NA\",(IF(COUNT(BC12:BC48)>0,AVERAGE(BC12:BC48),COUNTA(BC12:BC48))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE48)=0,\"NA\",(IF(COUNT(BE12:BE48)>0,AVERAGE(BE12:BE48),COUNTA(BE12:BE48))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":"NA"},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":"NA"},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":"NA"},{"$f":"IF(COUNT(BJ12:BJ48)=0,\"NA\",AVERAGE(BJ12:BJ48))","v":"NA"},"NA"]

{"sheet":"EXPOSITION","index":10,"n_rows":49,"n_cols":63,"rows_kept":49,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,8,2,11],[2,12,2,16],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nEXPOSITION",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nEXPOSITION"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":3},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object sentence parts - word types used",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":5},"Y",{"$nulls":3},"Y",null,"Y",{"$nulls":11},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,{"$f":"IFERROR(IF(A19=\"\",\"\",(E19+G19)),\"\")","v":""},{"$f":"IFERROR(IF(A19=\"\",\"\",(B19/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E19,G19),\"\")","v":""},{"$nulls":54},{"$f":"IF(A19=\"\",\"\",(COUNTA(I19,K19,M19,O19,Q19,S19,U19,W19,Y19,AA19,AC19,AE19,AG19,AI19,AK19,AM19,AO19,AQ19,AS19,AU19,AW19,AY19,BA19,BC19,BE19)))","v":""},{"$f":"IFERROR(BG19/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A19=\"\",\"\",(IFERROR(SUM(I19,K19,M19,O19,Q19,S19,U19,W19,Y19,AA19,AC19,AE19,AG19,AI19,AK19,AM19,AO19,AQ19,AS19,AU19,AW19,AY19,BA19,BC19,BE19),\"\")))","v":""},{"$f":"IF(A19=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI19=\"\",\"\",(IFERROR(BI19/BJ19,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[3,0,{"v":0,"d":"0.0%"},"",{"$nulls":54},0,{"v":0,"d":"0%"},0,51,{"v":0,"d":"0.0%"}]
["Group Average",{"$f":"IF(COUNT(B12:B48)=0,\"NA\",AVERAGE(B12:B48))","v":0},{"$f":"IF(COUNT(C12:C48)=0,\"NA\",AVERAGE(C12:C48))","v":{"v":0,"d":"0.0%"}},{"$f":"IF(COUNT(D12:D48)=0,\"NA\",AVERAGE(D12:D48))","v":"NA"},{"$f":"IF(COUNTA(E12:E48)=0,\"NA\",(IF(COUNT(E12:E48)>0,AVERAGE(E12:E48),COUNTA(E12:E48))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G48)=0,\"NA\",(IF(COUNT(G12:G48)>0,AVERAGE(G12:G48),COUNTA(G12:G48))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I48)=0,\"NA\",(IF(COUNT(I12:I48)>0,AVERAGE(I12:I48),COUNTA(I12:I48))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K48)=0,\"NA\",(IF(COUNT(K12:K48)>0,AVERAGE(K12:K48),COUNTA(K12:K48))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M48)=0,\"NA\",(IF(COUNT(M12:M48)>0,AVERAGE(M12:M48),COUNTA(M12:M48))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O48)=0,\"NA\",(IF(COUNT(O12:O48)>0,AVERAGE(O12:O48),COUNTA(O12:O48))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q48)=0,\"NA\",(IF(COUNT(Q12:Q48)>0,AVERAGE(Q12:Q48),COUNTA(Q12:Q48))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S48)=0,\"NA\",(IF(COUNT(S12:S48)>0,AVERAGE(S12:S48),COUNTA(S12:S48))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U48)=0,\"NA\",(IF(COUNT(U12:U48)>0,AVERAGE(U12:U48),COUNTA(U12:U48))))","v":"NA"},".",{"$f":"IF(COUNTA(W12:W48)=0,\"NA\",(IF(COUNT(W12:W48)>0,AVERAGE(W12:W48),COUNTA(W12:W48))))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y48)=0,\"NA\",(IF(COUNT(Y12:Y48)>0,AVERAGE(Y12:Y48),COUNTA(Y12:Y48))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA48)=0,\"NA\",(IF(COUNT(AA12:AA48)>0,AVERAGE(AA12:AA48),COUNTA(AA12:AA48))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC48)=0,\"NA\",(IF(COUNT(AC12:AC48)>0,AVERAGE(AC12:AC48),COUNTA(AC12:AC48))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE48)=0,\"NA\",(IF(COUNT(AE12:AE48)>0,AVERAGE(AE12:AE48),COUNTA(AE12:AE48))))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG48)=0,\"NA\",(IF(COUNT(AG12:AG48)>0,AVERAGE(AG12:AG48),COUNTA(AG12:AG48))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI48)=0,\"NA\",(IF(COUNT(AI12:AI48)>0,AVERAGE(AI12:AI48),COUNTA(AI12:AI48))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK48)=0,\"NA\",(IF(COUNT(AK12:AK48)>0,AVERAGE(AK12:AK48),COUNTA(AK12:AK48))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM48)=0,\"NA\",(IF(COUNT(AM12:AM48)>0,AVERAGE(AM12:AM48),COUNTA(AM12:AM48))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO48)=0,\"NA\",(IF(COUNT(AO12:AO48)>0,AVERAGE(AO12:AO48),COUNTA(AO12:AO48))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ48)=0,\"NA\",(IF(COUNT(AQ12:AQ48)>0,AVERAGE(AQ12:AQ48),COUNTA(AQ12:AQ48))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS48)=0,\"NA\",(IF(COUNT(AS12:AS48)>0,AVERAGE(AS12:AS48),COUNTA(AS12:AS48))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU48)=0,\"NA\",(IF(COUNT(AU12:AU48)>0,AVERAGE(AU12:AU48),COUNTA(AU12:AU48))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW48)=0,\"NA\",(IF(COUNT(AW12:AW48)>0,AVERAGE(AW12:AW48),COUNTA(AW12:AW48))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY48)=0,\"NA\",(IF(COUNT(AY12:AY48)>0,AVERAGE(AY12:AY48),COUNTA(AY12:AY48))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA48)=0,\"NA\",(IF(COUNT(BA12:BA48)>0,AVERAGE(BA12:BA48),COUNTA(BA12:BA48))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC48)=0,\"NA\",(IF(COUNT(BC12:BC48)>0,AVERAGE(BC12:BC48),COUNTA(BC12:BC48))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE48)=0,\"NA\",(IF(COUNT(BE12:BE48)>0,AVERAGE(BE12:BE48),COUNTA(BE12:BE48))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG48)=0,\"NA\",AVERAGE(BG12:BG48))","v":0},{"$f":"IF(COUNT(BH12:BH48)=0,\"NA\",AVERAGE(BH12:BH48))","v":{"v":0,"d":"0.00%"}},{"$f":"IF(COUNT(BI12:BI48)=0,\"NA\",AVERAGE(BI12:BI48))","v":0},{"$f":"IF(COUNT(BJ12:BJ48)=0,\"NA\",AVERAGE(BJ12:BJ48))","v":51},{"v":0,"d":"0.0%"}]

{"sheet":"EXPOSITION (paper 1 pg)","index":11,"n_rows":35,"n_cols":64,"rows_kept":35,"merged":[[0,0,0,13],[0,58,0,62],[1,0,4,0],[2,5,2,6],[2,11,2,14],[2,15,2,30],[4,1,4,7],[4,8,4,62],[5,0,8,0],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[5,16,5,17],[5,18,5,19],[5,20,5,21],[5,22,5,23],[5,24,5,25],[5,26,5,27],[5,28,5,29],[5,30,5,31],[5,32,5,33],[5,34,5,35],[5,36,5,37],[5,38,5,39],[5,40,5,41],[5,42,5,43],[5,44,5,45],[5,46,5,47],[5,48,5,49],[5,50,5,51],[5,52,5,53],[5,54,5,55],[5,56,5,57],[6,1,7,3],[6,4,7,7],[6,8,7,11],[6,12,7,17],[6,18,7,21],[6,22,7,27],[6,28,7,35],[6,36,7,41],[6,42,7,57],[6,58,6,62],[7,58,7,59],[7,60,7,62],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[8,12,9,12],[8,13,9,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,17,9,17],[8,18,9,18],[8,19,9,19],[8,20,9,20],[8,21,9,21],[8,22,9,22],[8,23,9,23],[8,24,9,24],[8,25,9,25],[8,26,9,26],[8,27,9,27],[8,28,9,28],[8,29,9,29],[8,30,9,30],[8,31,9,31],[8,32,9,32],[8,33,9,33],[8,34,9,34],[8,35,9,35],[8,36,9,36],[8,37,9,37],[8,38,9,38],[8,39,9,39],[8,40,9,40],[8,41,9,41],[8,42,9,42],[8,43,9,43],[8,44,9,44],[8,45,9,45],[8,46,9,46],[8,47,9,47],[8,48,9,48],[8,49,9,49],[8,50,9,50],[8,51,9,51],[8,52,9,52],[8,53,9,53],[8,54,9,54],[8,55,9,55],[8,56,9,56],[8,57,9,57],[8,58,9,58],[8,59,9,59],[8,60,9,60],[8,61,9,61],[8,62,9,62]]}
["GEAT Detailed Analysis:\nEXPOSITION",{"$nulls":57},{"$f":"A1","v":"GEAT Detailed Analysis:\nEXPOSITION"}]
["Use as checklist (enter \"Y\") OR, use for quality rating (enter 0-3, see guide)"]
[{"$nulls":4},"Class:",{"$nulls":6},"Assessment context:"]
[]
[null,"Quality Rating - Core Sentence Parts",{"$nulls":6},"Detailed Features - range (checklist) & quality ratings"]
[{"$nulls":8},"All",null,"All",null,"All",null,"All",null,"All",null,"All",null,"All, especially Rec",null,"All",null,"All, especially Fic, Pers, Info",null,"Fic, Pers",null,"All",null,"Pers, Expo",null,"Fic",null,"Fic",null,"Fic, Rec, Info",null,"Fic, Info, Pers",null,"Fic, Rec",null,"Fic, Rec, Pers, Proc",null,"All",null,"Fic, Pers, Expo, Info",null,"Pers, Expo",null,"Fic, Pers, Expo, Info",null,"Pers, Info, Expo",null,"Pers, Expo",null,"All"]
[null,"TOTAL SCORES \n(automatically calculates)",null,null,"Sentence parts\n(Enter data here)",{"$nulls":3},"Grammaticality",{"$nulls":3},"Sentence types used",{"$nulls":5},"Subject / object parts",{"$nulls":3},"Noun phrases modified by",{"$nulls":5},"Types of verbs used",{"$nulls":7},"Verb phrases modified by",{"$nulls":5},"Types of joining words/phrases used",{"$nulls":15},"TOTAL SCORES (automatically calculates)"]
[{"$nulls":58},"RANGE",null,"QUALITY"]
[null,"TOTAL QUALITY RATING SCORE (/6)","% Quality Rating Score","Average Rating Score","Who/what sentence part\n(often noun phrases)","E.g.","Action sentence parts \n(often verb phrases + adverbial phrases)","E.g.","Tense ","Notes","Referencing","Notes","Simple sentences\n(single clause / idea)","Notes","Compound sentences (multiple clauses joined by coordinating conjunction)","Notes","Complex sentences (have a subordinating conjunction)","Notes","Nouns","Notes     ","Pronouns","Notes","Articles \ne.g. a, the","Notes","Adjectives \ne.g. big, stunning","Notes","Figurative language e.g. like a beast","Notes","Doing / being verbs \ne.g. is, was, run, sit, eat","Notes","Modal verbs \ne.g. could, should, must","Notes","Talking verbs\ne.g. shouted, said","Notes","Thinking verbs \ne.g. wondered, wished, thought, decided","Notes  ","Place words \ne.g. above, below, inside, up the tree","Notes","How words (adverbs) \ne.g. cautiously, quietly","Notes","Time words (adverbs) \ne.g. yesterday, in the morning","Notes","Temporal / sequencing (e.g. and then, firstly, secondly, until)","Notes","Additive \n(e.g. and, as well, or)","Notes","Cause-effect / Reason\n(e.g. because, so)","Notes","Comparison  (similar ideas e.g. like, similarly, equally)","Notes","Contrastive / Concession \n(differing ideas e.g. but, yet)","Notes","Illustrating\n(e.g. such as, for example)","Notes","Emphasis/persuasion\n(e.g. notably, furthermore)","Notes","Conditional / Qualifying\n(e.g. if, although, unless)","Notes","Total Number of Grammatical Features Used","Total % of Grammatical Features Used","Students' Quality Rating Total","Quality Rating Total Potential","Students' Quality Rating %"]
["Student ê "]
["      Feature being analysed? è ",{"$nulls":3},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":5},"Y",{"$nulls":3},"Y",null,"Y",{"$nulls":11},"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",null,"Y",{"$nulls":6},"Notes"]
[null,{"$f":"IFERROR(IF(A12=\"\",\"\",(E12+G12)),\"\")","v":""},{"$f":"IFERROR(IF(A12=\"\",\"\",(B12/6)),\"\")","v":""},{"$f":"IFERROR(AVERAGE(E12,G12),\"\")","v":""},{"$nulls":54},{"$f":"IF(A12=\"\",\"\",(COUNTA(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12)))","v":""},{"$f":"IFERROR(BG12/(COUNTIF($I$11:$BF$11,\"Y\")),\"\")","v":""},{"$f":"IF(A12=\"\",\"\",(IFERROR(SUM(I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12,AO12,AQ12,AS12,AU12,AW12,AY12,BA12,BC12,BE12),\"\")))","v":""},{"$f":"IF(A12=\"\",\"\",(COUNTIF($I$11:$BF$11,\"Y\")*3))","v":""},{"$f":"IF(BI12=\"\",\"\",(IFERROR(BI12/BJ12,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",{"$f":"IF(BI13=\"\",\"\",(IFERROR(BI13/BJ13,0)))","v":""}]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
[null,"","","",{"$nulls":54},"","","","",""]
["Group Average",{"$f":"IF(COUNT(B12:B34)=0,\"NA\",AVERAGE(B12:B34))","v":"NA"},{"$f":"IF(COUNT(C12:C34)=0,\"NA\",AVERAGE(C12:C34))","v":"NA"},{"$f":"IF(COUNT(D12:D34)=0,\"NA\",AVERAGE(D12:D34))","v":"NA"},{"$f":"IF(COUNTA(E12:E34)=0,\"NA\",(IF(COUNT(E12:E34)>0,AVERAGE(E12:E34),COUNTA(E12:E34))))","v":"NA"},".",{"$f":"IF(COUNTA(G12:G34)=0,\"NA\",(IF(COUNT(G12:G34)>0,AVERAGE(G12:G34),COUNTA(G12:G34))))","v":"NA"},".",{"$f":"IF(COUNTA(I12:I34)=0,\"NA\",(IF(COUNT(I12:I34)>0,AVERAGE(I12:I34),COUNTA(I12:I34))))","v":"NA"},".",{"$f":"IF(COUNTA(K12:K34)=0,\"NA\",(IF(COUNT(K12:K34)>0,AVERAGE(K12:K34),COUNTA(K12:K34))))","v":"NA"},".",{"$f":"IF(COUNTA(M12:M34)=0,\"NA\",(IF(COUNT(M12:M34)>0,AVERAGE(M12:M34),COUNTA(M12:M34))))","v":"NA"},".",{"$f":"IF(COUNTA(O12:O34)=0,\"NA\",(IF(COUNT(O12:O34)>0,AVERAGE(O12:O34),COUNTA(O12:O34))))","v":"NA"},".",{"$f":"IF(COUNTA(Q12:Q34)=0,\"NA\",(IF(COUNT(Q12:Q34)>0,AVERAGE(Q12:Q34),COUNTA(Q12:Q34))))","v":"NA"},".",{"$f":"IF(COUNTA(S12:S34)=0,\"NA\",(IF(COUNT(S12:S34)>0,AVERAGE(S12:S34),COUNTA(S12:S34))))","v":"NA"},".",{"$f":"IF(COUNTA(U12:U34)=0,\"NA\",(IF(COUNT(U12:U34)>0,AVERAGE(U12:U34),COUNTA(U12:U34))))","v":"NA"},".",{"$f":"IF(COUNTA(W12:W34)=0,\"NA\",(IF(COUNT(W12:W34)>0,AVERAGE(W12:W34),COUNTA(W12:W34))))","v":"NA"},".",{"$f":"IF(COUNTA(Y12:Y34)=0,\"NA\",(IF(COUNT(Y12:Y34)>0,AVERAGE(Y12:Y34),COUNTA(Y12:Y34))))","v":"NA"},".",{"$f":"IF(COUNTA(AA12:AA34)=0,\"NA\",(IF(COUNT(AA12:AA34)>0,AVERAGE(AA12:AA34),COUNTA(AA12:AA34))))","v":"NA"},".",{"$f":"IF(COUNTA(AC12:AC34)=0,\"NA\",(IF(COUNT(AC12:AC34)>0,AVERAGE(AC12:AC34),COUNTA(AC12:AC34))))","v":"NA"},".",{"$f":"IF(COUNTA(AE12:AE34)=0,\"NA\",(IF(COUNT(AE12:AE34)>0,AVERAGE(AE12:AE34),COUNTA(AE12:AE34))))","v":"NA"},".",{"$f":"IF(COUNTA(AG12:AG34)=0,\"NA\",(IF(COUNT(AG12:AG34)>0,AVERAGE(AG12:AG34),COUNTA(AG12:AG34))))","v":"NA"},".",{"$f":"IF(COUNTA(AI12:AI34)=0,\"NA\",(IF(COUNT(AI12:AI34)>0,AVERAGE(AI12:AI34),COUNTA(AI12:AI34))))","v":"NA"},".",{"$f":"IF(COUNTA(AK12:AK34)=0,\"NA\",(IF(COUNT(AK12:AK34)>0,AVERAGE(AK12:AK34),COUNTA(AK12:AK34))))","v":"NA"},".",{"$f":"IF(COUNTA(AM12:AM34)=0,\"NA\",(IF(COUNT(AM12:AM34)>0,AVERAGE(AM12:AM34),COUNTA(AM12:AM34))))","v":"NA"},".",{"$f":"IF(COUNTA(AO12:AO34)=0,\"NA\",(IF(COUNT(AO12:AO34)>0,AVERAGE(AO12:AO34),COUNTA(AO12:AO34))))","v":"NA"},".",{"$f":"IF(COUNTA(AQ12:AQ34)=0,\"NA\",(IF(COUNT(AQ12:AQ34)>0,AVERAGE(AQ12:AQ34),COUNTA(AQ12:AQ34))))","v":"NA"},".",{"$f":"IF(COUNTA(AS12:AS34)=0,\"NA\",(IF(COUNT(AS12:AS34)>0,AVERAGE(AS12:AS34),COUNTA(AS12:AS34))))","v":"NA"},".",{"$f":"IF(COUNTA(AU12:AU34)=0,\"NA\",(IF(COUNT(AU12:AU34)>0,AVERAGE(AU12:AU34),COUNTA(AU12:AU34))))","v":"NA"},".",{"$f":"IF(COUNTA(AW12:AW34)=0,\"NA\",(IF(COUNT(AW12:AW34)>0,AVERAGE(AW12:AW34),COUNTA(AW12:AW34))))","v":"NA"},".",{"$f":"IF(COUNTA(AY12:AY34)=0,\"NA\",(IF(COUNT(AY12:AY34)>0,AVERAGE(AY12:AY34),COUNTA(AY12:AY34))))","v":"NA"},".",{"$f":"IF(COUNTA(BA12:BA34)=0,\"NA\",(IF(COUNT(BA12:BA34)>0,AVERAGE(BA12:BA34),COUNTA(BA12:BA34))))","v":"NA"},".",{"$f":"IF(COUNTA(BC12:BC34)=0,\"NA\",(IF(COUNT(BC12:BC34)>0,AVERAGE(BC12:BC34),COUNTA(BC12:BC34))))","v":"NA"},".",{"$f":"IF(COUNTA(BE12:BE34)=0,\"NA\",(IF(COUNT(BE12:BE34)>0,AVERAGE(BE12:BE34),COUNTA(BE12:BE34))))","v":"NA"},".",{"$f":"IF(COUNT(BG12:BG34)=0,\"NA\",AVERAGE(BG12:BG34))","v":"NA"},{"$f":"IF(COUNT(BH12:BH34)=0,\"NA\",AVERAGE(BH12:BH34))","v":"NA"},{"$f":"IF(COUNT(BI12:BI34)=0,\"NA\",AVERAGE(BI12:BI34))","v":"NA"},{"$f":"IF(COUNT(BJ12:BJ34)=0,\"NA\",AVERAGE(BJ12:BJ34))","v":"NA"},"NA"]