{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["WRKINGCohort data&graphs","How to use this spreadsheet","Raw Scores-BOY","Raw Scores-MOY","Raw Scores-EOY","Benchmark Scores","Dropdowns"],"not_rendered":{"charts":18,"images":9,"macros":1,"external_links":0,"defined_names":52,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"WRKINGCohort data&graphs","index":0,"n_rows":55,"n_cols":102,"rows_kept":55,"cut":false,"hidden":true,"merged":[[17,99,17,100],[19,5,20,19],[19,21,19,32],[48,73,48,85],[48,89,48,95],[54,1,54,33],[54,36,54,67],[54,70,54,101],[39,89,39,95],[43,1,44,2],[46,0,46,33],[46,36,46,67],[46,70,46,101],[48,0,81,0],[48,5,48,17],[48,21,48,27],[48,39,48,51],[48,55,48,61],[39,0,44,0],[39,5,39,17],[39,21,39,27],[39,39,39,51],[39,55,39,61],[39,73,39,85],[20,101,21,101],[24,1,24,33],[24,36,24,67],[24,70,24,101],[37,0,37,33],[37,37,37,67],[37,71,37,101],[20,30,20,32],[20,33,21,33],[20,55,20,63],[20,64,20,66],[20,67,21,67],[20,89,20,97],[19,39,20,53],[19,55,19,66],[19,73,20,87],[19,89,19,100],[20,21,20,29],[20,98,20,100],[15,29,15,32],[15,53,15,54],[15,55,15,58],[16,91,16,92],[16,95,17,96],[16,97,16,98],[17,65,17,66],[16,41,17,41],[16,42,17,42],[16,43,17,43],[16,44,17,44],[16,53,17,54],[16,55,16,56],[16,29,16,30],[16,31,16,32],[16,39,17,39],[16,40,17,40],[16,99,16,100],[17,21,17,22],[17,23,17,24],[17,29,17,30],[17,31,17,32],[17,55,17,56],[17,57,17,58],[16,75,17,75],[16,76,17,76],[16,77,17,77],[16,78,17,78],[16,87,17,88],[16,89,16,90],[17,89,17,90],[16,57,16,58],[16,61,17,62],[16,63,16,64],[16,65,16,66],[16,73,17,73],[16,74,17,74],[17,63,17,64],[17,91,17,92],[17,97,17,98],[16,23,16,24],[16,7,17,7],[16,8,17,8],[16,9,17,9],[16,10,17,10],[16,19,17,20],[16,21,16,22],[15,19,15,20],[15,21,15,24],[15,27,15,28],[16,27,17,28],[12,0,12,33],[12,35,12,67],[12,69,12,101],[13,0,35,0],[14,5,15,5],[14,6,14,10],[14,19,14,24],[14,27,14,32],[14,39,15,39],[14,40,14,44],[14,53,14,58],[14,61,14,66],[14,73,15,73],[14,74,14,78],[14,87,14,92],[14,95,14,100],[15,61,15,62],[15,63,15,66],[15,87,15,88],[15,89,15,92],[15,95,15,96],[15,97,15,100],[16,5,17,5],[16,6,17,6],[1,0,3,1],[1,3,1,33],[1,37,1,67],[1,71,1,101],[5,0,10,0],[5,5,5,6],[5,8,5,9],[5,39,5,40],[5,42,5,43],[5,73,5,74],[9,3,9,4],[9,37,9,38],[9,71,9,72],[10,3,10,4],[10,37,10,38],[10,71,10,72],[5,76,5,77],[7,3,7,4],[7,37,7,38],[7,71,7,72],[8,3,8,4],[8,37,8,38],[8,71,8,72]]}
[]
["NLM-L3: \nSummary Scores",null,null,"PP   Beginning of Year   (BOY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP   Middle of Year   (MOY)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PP   End of Year    (EOY)"]
[]
[]
[]
["Risk Categories Distribution",null,null,null,null,"% of students",null,null,"# of students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of students",null,null,"# of students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of students",null,null,"# of students"]
[null,null,null,null,null,"Retell Score","Ques. Score",null,"Retell Score","Ques. Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retell Score","Ques. Score",null,"Retell Score","Ques. Score",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retell Score","Ques. Score",null,"Retell Score","Ques. Score"]
[null,null,null,"Advanced",null,{"$f":"IFERROR(($I$8/$E$45),\"\")","v":0},{"$f":"IFERROR(($J$8/$E$45),\"\")","v":0},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced",null,{"$f":"IFERROR(($AQ$8/$AM$45),\"\")","v":""},{"$f":"IFERROR(($AR$8/$AM$45),\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advanced",null,{"$f":"IFERROR(($BY$8/$BU$45),\"\")","v":""},{"$f":"IFERROR(($BZ$8/$BU$45),\"\")","v":""},null,"",""]
[null,null,null,"Benchmark",null,{"$f":"IFERROR(($I$9/$E$45),\"\")","v":0},{"$f":"IFERROR(($J$9/$E$45),\"\")","v":0},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benchmark",null,{"$f":"IFERROR(($AQ$9/$AM$45),\"\")","v":""},{"$f":"IFERROR(($AR$9/$AM$45),\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Benchmark",null,{"$f":"IFERROR(($BY$9/$BU$45),\"\")","v":""},{"$f":"IFERROR(($BZ$9/$BU$45),\"\")","v":""},null,"",""]
[null,null,null,"Moderate Risk",null,{"$f":"IFERROR(($I$10/$E$45),\"\")","v":0},{"$f":"IFERROR(($J$10/$E$45),\"\")","v":0},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moderate Risk",null,{"$f":"IFERROR(($AQ$10/$AM$45),\"\")","v":""},{"$f":"IFERROR(($AR$10/$AM$45),\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moderate Risk",null,{"$f":"IFERROR(($BY$10/$BU$45),\"\")","v":""},{"$f":"IFERROR(($BZ$10/$BU$45),\"\")","v":""},null,"",""]
[null,null,null,"High Risk",null,{"$f":"IFERROR(($I$11/$E$45),\"\")","v":0},{"$f":"IFERROR(($J$11/$E$45),\"\")","v":0},null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Risk",null,{"$f":"IFERROR(($AQ$11/$AM$45),\"\")","v":""},{"$f":"IFERROR(($AR$11/$AM$45),\"\")","v":""},null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High Risk",null,{"$f":"IFERROR(($BY$11/$BU$45),\"\")","v":""},{"$f":"IFERROR(($BZ$11/$BU$45),\"\")","v":""},null,"",""]
[]
["Average scores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average scores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average scores"]
["Average scores"]
[null,null,null,null,null,"Narrative Discourse Complexity Score","Other Complexity Measures",null,null,null,null,null,null,null,null,null,null,null,null,"NLM Retell Score \n[sum of all complexity measures]",null,null,null,null,null,null,null,"NLM Questions Total Score ",null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity Score","Other Complexity Measures",null,null,null,null,null,null,null,null,null,null,null,null,"NLM Retell Score \n[sum of all complexity measures]",null,null,null,null,null,null,null,"NLM Questions Total Score ",null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity Score","Other Complexity Measures",null,null,null,null,null,null,null,null,null,null,null,null,"NLM Retell Score \n[sum of all complexity measures]",null,null,null,null,null,null,null,"NLM Questions Total Score "]
[null,null,null,null,null,null,"Expository Discourse Complexity","Episode Complexity",null,"Sentence Complexity","Vocabulary Complexity",null,null,null,null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories",null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories",null,null,null,null,null,null,null,null,null,null,"Expository Discourse Complexity","Episode Complexity",null,"Sentence Complexity","Vocabulary Complexity",null,null,null,null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories",null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories",null,null,null,null,null,null,null,null,null,null,"Expository Discourse Complexity","Episode Complexity",null,"Sentence Complexity","Vocabulary Complexity",null,null,null,null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories",null,null,null,null,null,"Cohort Average Score",null,"Most Common Risk Category/ Categories"]
[null,null,null,null,null,"","","",null,"","",null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($I$8:$I$11=MAX($I$8:$I$11), ROW($I$8:$I$11)-ROW($I$8)+1), ROW(1:1))), \"\")","v":"Advanced"},null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($I$8:$I$11=MAX($I$8:$I$11), ROW($I$8:$I$11)-ROW($I$8)+1), ROW(2:2))), \"\")","v":"Benchmark"},null,null,null,"",null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($J$8:$J$11=MAX($J$8:$J$11), ROW($J$8:$J$11)-ROW($J$8)+1), ROW(1:1))), \"\")","v":"Advanced"},null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($J$8:$J$11=MAX($J$8:$J$11), ROW($J$8:$J$11)-ROW($J$8)+1), ROW(2:2))), \"\")","v":"Benchmark"},null,null,null,null,null,null,null,"","","",null,"","",null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AQ$8:$AQ$11=MAX($AQ$8:$AQ$11), ROW($AQ$8:$AQ$11)-ROW($AQ$8)+1), ROW(1:1))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AQ$8:$AQ$11=MAX($AQ$8:$AQ$11), ROW($AQ$8:$AQ$11)-ROW($AQ$8)+1), ROW(2:2))), \"\")","v":""},null,null,null,"",null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AR$8:$AR$11=MAX($AR$8:$AR$11), ROW($AR$8:$AR$11)-ROW($AR$8)+1), ROW(1:1))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AR$8:$AR$11=MAX($AR$8:$AR$11), ROW($AR$8:$AR$11)-ROW($AR$8)+1), ROW(2:2))), \"\")","v":""},null,null,null,null,null,null,null,"","","",null,"","",null,null,null,null,null,null,null,null,"",null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BY$8:$BY$11=MAX($BY$8:$BY$11), ROW($BY$8:$BY$11)-ROW($BY$8)+1), ROW(1:1))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BY$8:$BY$11=MAX($BY$8:$BY$11), ROW($BY$8:$BY$11)-ROW($BY$8)+1), ROW(2:2))), \"\")","v":""},null,null,null,"",null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BZ$8:$BZ$11=MAX($BZ$8:$BZ$11), ROW($BZ$8:$BZ$11)-ROW($BZ$8)+1), ROW(1:1))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BZ$8:$BZ$11=MAX($BZ$8:$BZ$11), ROW($BZ$8:$BZ$11)-ROW($BZ$8)+1), ROW(2:2))), \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($I$8:$I$11=MAX($I$8:$I$11), ROW($I$8:$I$11)-ROW($I$8)+1), ROW(3:3))), \"\")","v":"Moderate Risk"},null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($I$8:$I$11=MAX($I$8:$I$11), ROW($I$8:$I$11)-ROW($I$8)+1), ROW(4:4))), \"\")","v":"High Risk"},null,null,null,null,null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($J$8:$J$11=MAX($J$8:$J$11), ROW($J$8:$J$11)-ROW($J$8)+1), ROW(3:3))), \"\")","v":"Moderate Risk"},null,{"$f":"IFERROR(INDEX($D$8:$D$11, SMALL(IF($J$8:$J$11=MAX($J$8:$J$11), ROW($J$8:$J$11)-ROW($J$8)+1), ROW(4:4))), \"\")","v":"High Risk"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AQ$8:$AQ$11=MAX($AQ$8:$AQ$11), ROW($AQ$8:$AQ$11)-ROW($AQ$8)+1), ROW(3:3))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AQ$8:$AQ$11=MAX($AQ$8:$AQ$11), ROW($AQ$8:$AQ$11)-ROW($AQ$8)+1), ROW(4:4))), \"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AR$8:$AR$11=MAX($AR$8:$AR$11), ROW($AR$8:$AR$11)-ROW($AR$8)+1), ROW(3:3))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($AL$8:$AL$11, SMALL(IF($AR$8:$AR$11=MAX($AR$8:$AR$11), ROW($AR$8:$AR$11)-ROW($AR$8)+1), ROW(4:4))), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BY$8:$BY$11=MAX($BY$8:$BY$11), ROW($BY$8:$BY$11)-ROW($BY$8)+1), ROW(3:3))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BY$8:$BY$11=MAX($BY$8:$BY$11), ROW($BY$8:$BY$11)-ROW($BY$8)+1), ROW(4:4))), \"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BZ$8:$BZ$11=MAX($BZ$8:$BZ$11), ROW($BZ$8:$BZ$11)-ROW($BZ$8)+1), ROW(3:3))), \"\")","v":""},null,{"$f":"IFERROR(INDEX($BT$8:$BT$11, SMALL(IF($BZ$8:$BZ$11=MAX($BZ$8:$BZ$11), ROW($BZ$8:$BZ$11)-ROW($BZ$8)+1), ROW(4:4))), \"\")","v":""}]
[]
[null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factual Questions: Real-World Performance",null,null,null,null,null,null,null,null,"Scores for BM",null,null,"Visual of student's question type score distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factual Questions: Real-World Performance",null,null,null,null,null,null,null,null,"Scores for BM",null,null,"Visual of student's question type score distribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Factual Questions: Real-World Performance",null,null,null,null,null,null,null,null,"Scores for BM",null,null,"Visual of student's question type score distribution"]
[null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution","Narrative Discourse Complexity Score",null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?","Real World Factual Ques. Total Score","Factual ques. difference between real-world & BM scores","Factual Ques \nTotal Score (for BMs)","Inferential Vocabulary Score","Inferential Reasoning Score",null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution","Narrative Discourse Complexity Score",null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?","Real World Factual Ques. Total Score","Factual ques. difference between real-world & BM scores","Factual Ques \nTotal Score (for BMs)","Inferential Vocabulary Score","Inferential Reasoning Score",null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution","Narrative Discourse Complexity Score",null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?","Real World Factual Ques. Total Score","Factual ques. difference between real-world & BM scores","Factual Ques \nTotal Score (for BMs)","Inferential Vocabulary Score","Inferential Reasoning Score"]
[null,null,null,null,"Av. Score:","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","",null,null,null,null,null,"Av. Score:","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","","",null,null,null,null,null,"Av. Score:","","","","","","","","","","","","","",null,"",null,"","","","","","","","","","","",""]
[]
[null,"Average Score Graphs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Score Graphs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Score Graphs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" Number of Students Scoring 0, 1 or 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Number of Students Scoring 0, 1 or 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Number of Students Scoring 0, 1 or 2"]
[]
["# of students with…",null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions"]
[null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling",null,null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?",null,null,null,null,null,null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling",null,null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?",null,null,null,null,null,null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling",null,null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?"]
[null,null,null,0,"points",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"0 p.",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,0,"points","","","","","","","","","","","","","",null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,null,0,"points","","","","","","","","","","","","","",null,null,null,"","","","","","",""]
[null,null,null,1,"point",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"1 p.",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,1,"point","","","","","","","","","","","","","",null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,null,1,"point","","","","","","","","","","","","","",null,null,null,"","","","","","",""]
[null,"Total students→",null,2,"points",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"2 p.",0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,2,"points","","","","","","","","","","","","","",null,null,null,"","","","","","","",null,null,null,null,null,null,null,null,null,2,"points","","","","","","","","","","","","","",null,null,null,"","","","","","",""]
[null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[" % of Students Scoring 0, 1 or 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," % of Students Scoring 0, 1 or 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," % of Students Scoring 0, 1 or 2"]
[]
["% of students with…",null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narrative Discourse Complexity: story parts included",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Questions"]
[null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution",null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/ comp.)","How end?","What did you learn?","Visual of student's responses",null,null,null,null,null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution",null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?","Visual of student's responses",null,null,null,null,null,null,null,null,null,null,"Character","Setting","Problem","Feeling","Plan","Attempt","Complication / Consequence 1","Feeling 2","Plan-2","Attempt-2","Consequence","Ending","End Feeling","Visual of student's story grammar distribution",null,null,"Who?","Where?","Why feel? \n(Problem)","How fix problem? \n(attempt)","Why act? \n(consequence/comp.)","How end?","What did you learn?","Visual of student's responses"]
[null,null,null,0,"points",{"$f":"IFERROR($F$42/$E$45,\"\")","v":0},{"$f":"IFERROR($G$42/$E$45,\"\")","v":0},{"$f":"IFERROR($H$42/$E$45,\"\")","v":0},{"$f":"IFERROR($I$42/$E$45,\"\")","v":0},{"$f":"IFERROR($J$42/$E$45,\"\")","v":0},{"$f":"IFERROR($K$42/$E$45,\"\")","v":0},{"$f":"IFERROR($L$42/$E$45,\"\")","v":0},{"$f":"IFERROR($M$42/$E$45,\"\")","v":0},{"$f":"IFERROR($N$42/$E$45,\"\")","v":0},{"$f":"IFERROR($O$42/$E$45,\"\")","v":0},{"$f":"IFERROR($P$42/$E$45,\"\")","v":0},{"$f":"IFERROR($Q$42/$E$45,\"\")","v":0},{"$f":"IFERROR($R$42/$E$45,\"\")","v":0},null,null,"0 p.",{"$f":"IFERROR($V$42/$E$45,\"\")","v":0},{"$f":"IFERROR($W$42/$E$45,\"\")","v":0},{"$f":"IFERROR($X$42/$E$45,\"\")","v":0},{"$f":"IFERROR($Y$42/$E$45,\"\")","v":0},{"$f":"IFERROR($Z$42/$E$45,\"\")","v":0},{"$f":"IFERROR($AA$42/$E$45,\"\")","v":0},{"$f":"IFERROR($AB$42/$E$45,\"\")","v":0},null,null,null,null,null,null,null,null,null,0,"points",{"$f":"IFERROR($AN$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AO$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AP$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AQ$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AR$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AS$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AT$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AU$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AV$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AW$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AX$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AY$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($AZ$42/$AM$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($BD$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BE$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BF$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BG$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BH$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BI$42/$AM$45,\"\")","v":""},{"$f":"IFERROR($BJ$42/$AM$45,\"\")","v":""},null,null,null,null,null,null,null,null,null,0,"points",{"$f":"IFERROR($BV$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($BW$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($BX$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($BY$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($BZ$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CA$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CB$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CC$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CD$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CE$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CF$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CG$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CH$42/$BU$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($CL$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CM$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CN$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CO$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CP$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CQ$42/$BU$45,\"\")","v":""},{"$f":"IFERROR($CR$42/$BU$45,\"\")","v":""}]
[null,null,null,1,"point",{"$f":"IFERROR($F$43/$E$45,\"\")","v":0},{"$f":"IFERROR($G$43/$E$45,\"\")","v":0},{"$f":"IFERROR($H$43/$E$45,\"\")","v":0},{"$f":"IFERROR($I$43/$E$45,\"\")","v":0},{"$f":"IFERROR($J$43/$E$45,\"\")","v":0},{"$f":"IFERROR($K$43/$E$45,\"\")","v":0},{"$f":"IFERROR($L$43/$E$45,\"\")","v":0},{"$f":"IFERROR($M$43/$E$45,\"\")","v":0},{"$f":"IFERROR($N$43/$E$45,\"\")","v":0},{"$f":"IFERROR($O$43/$E$45,\"\")","v":0},{"$f":"IFERROR($P$43/$E$45,\"\")","v":0},{"$f":"IFERROR($Q$43/$E$45,\"\")","v":0},{"$f":"IFERROR($R$43/$E$45,\"\")","v":0},null,null,"1 p.",{"$f":"IFERROR($V$43/$E$45,\"\")","v":0},{"$f":"IFERROR($W$43/$E$45,\"\")","v":0},{"$f":"IFERROR($X$43/$E$45,\"\")","v":0},{"$f":"IFERROR($Y$43/$E$45,\"\")","v":0},{"$f":"IFERROR($Z$43/$E$45,\"\")","v":0},{"$f":"IFERROR($AA$43/$E$45,\"\")","v":0},{"$f":"IFERROR($AB$43/$E$45,\"\")","v":0},null,null,null,null,null,null,null,null,null,1,"point",{"$f":"IFERROR($AN$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AO$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AP$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AQ$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AR$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AS$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AT$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AU$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AV$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AW$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AX$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AY$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($AZ$43/$AM$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($BD$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BE$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BF$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BG$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BH$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BI$43/$AM$45,\"\")","v":""},{"$f":"IFERROR($BJ$43/$AM$45,\"\")","v":""},null,null,null,null,null,null,null,null,null,1,"point",{"$f":"IFERROR($BV$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($BW$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($BX$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($BY$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($BZ$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CA$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CB$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CC$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CD$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CE$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CF$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CG$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CH$43/$BU$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($CL$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CM$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CN$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CO$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CP$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CQ$43/$BU$45,\"\")","v":""},{"$f":"IFERROR($CR$43/$BU$45,\"\")","v":""}]
[null,null,null,2,"points",{"$f":"IFERROR($F$44/$E$45,\"\")","v":0},{"$f":"IFERROR($G$44/$E$45,\"\")","v":0},{"$f":"IFERROR($H$44/$E$45,\"\")","v":0},{"$f":"IFERROR($I$44/$E$45,\"\")","v":0},{"$f":"IFERROR($J$44/$E$45,\"\")","v":0},{"$f":"IFERROR($K$44/$E$45,\"\")","v":0},{"$f":"IFERROR($L$44/$E$45,\"\")","v":0},{"$f":"IFERROR($M$44/$E$45,\"\")","v":0},{"$f":"IFERROR($N$44/$E$45,\"\")","v":0},{"$f":"IFERROR($O$44/$E$45,\"\")","v":0},{"$f":"IFERROR($P$44/$E$45,\"\")","v":0},{"$f":"IFERROR($Q$44/$E$45,\"\")","v":0},{"$f":"IFERROR($R$44/$E$45,\"\")","v":0},null,null,"2 p.",{"$f":"IFERROR($V$44/$E$45,\"\")","v":0},{"$f":"IFERROR($W$44/$E$45,\"\")","v":0},{"$f":"IFERROR($X$44/$E$45,\"\")","v":0},{"$f":"IFERROR($Y$44/$E$45,\"\")","v":0},{"$f":"IFERROR($Z$44/$E$45,\"\")","v":0},{"$f":"IFERROR($AA$44/$E$45,\"\")","v":0},{"$f":"IFERROR($AB$44/$E$45,\"\")","v":0},null,null,null,null,null,null,null,null,null,2,"points",{"$f":"IFERROR($AN$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AO$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AP$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AQ$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AR$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AS$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AT$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AU$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AV$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AW$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AX$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AY$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($AZ$44/$AM$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($BD$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BE$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BF$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BG$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BH$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BI$44/$AM$45,\"\")","v":""},{"$f":"IFERROR($BJ$44/$AM$45,\"\")","v":""},null,null,null,null,null,null,null,null,null,2,"points",{"$f":"IFERROR($BV$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($BW$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($BX$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($BY$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($BZ$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CA$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CB$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CC$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CD$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CE$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CF$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CG$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CH$44/$BU$45,\"\")","v":""},null,null,null,{"$f":"IFERROR($CL$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CM$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CN$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CO$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CP$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CQ$44/$BU$45,\"\")","v":""},{"$f":"IFERROR($CR$44/$BU$45,\"\")","v":""}]
[]
[null,"Score Distribution Graphs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score Distribution Graphs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Score Distribution Graphs"]

{"sheet":"How to use this spreadsheet","index":1,"n_rows":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,1,96,18],[0,1,0,19],[2,1,2,18],[7,1,7,18],[9,1,13,4],[31,1,31,18],[54,1,54,18]]}
[null,"DDM-3 Spreadsheet v1.1 How To Guide"]
[]
[null,"Tabs overview"]
[null,null,"Orange tabs: Enter student details & data. Data is automatically colour coded based on benchmark (BM) scores."]
[null,null,"Future spreadsheet versions will include graphs, summary data & student tracking"]
[]
[]
[null,"Spreadsheet navigation overview"]
[]
[null,"There are a range of buttons which can be used to navigate to,  select or show/hide data in the spreadsheet."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Data entry tips"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Viewing selected data (filtering)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Sorting data"]

{"sheet":"Raw Scores-BOY","index":2,"n_rows":135,"n_cols":85,"rows_kept":135,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,10,0,43],[0,66,0,69],[1,66,1,84],[2,10,2,43],[2,45,2,47],[2,49,2,51],[2,53,2,63],[2,66,2,69],[2,71,2,73],[2,75,2,77],[2,79,2,84],[3,0,3,1],[3,6,3,9],[3,10,3,20],[3,21,3,26],[3,27,3,37],[3,79,5,79],[3,55,4,56],[3,57,4,58],[3,59,4,60],[3,61,4,62],[3,63,5,63],[3,71,5,71],[4,69,5,69],[3,72,5,72],[3,73,5,73],[3,75,5,75],[3,76,5,76],[3,77,5,77],[4,67,5,67],[4,68,5,68],[4,66,5,66],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[3,80,5,80],[3,81,4,81],[3,82,4,82],[3,83,4,83],[3,84,4,84],[4,20,5,20],[4,26,5,26],[4,27,4,32],[4,33,4,34],[4,6,5,6],[4,9,5,9],[4,7,5,7],[4,8,5,8],[4,10,4,11],[3,53,5,53],[3,54,5,54],[3,38,3,43],[3,47,5,47],[132,10,133,19],[4,37,5,37],[4,38,4,41],[4,43,5,43],[4,12,4,15],[3,46,5,46],[4,35,4,36],[3,45,5,45],[3,49,5,49],[3,50,5,50],[3,51,5,51],[4,17,4,18]]}
["Dynamic Decoding Measures-3 Scores",null,null,null,"PP","BOY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals not working? \nScroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,"Interpretations Summary"]
[null,null,null,null,null,null,null,null,null,null,"Phonemic Awareness",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ortho. Mapping",null,null,null,"Not on test form (no BMs) - Phoneme Manipulation",null,null,null,"Not on test form (no BMs) - Decoding Inventory",null,null,null,null,null,null,null,null,null,null,null,null,"Phonemic Awareness",null,null,null,null,"Orthographic Mapping",null,null,null,"Phoneme Manipulation",null,null,null,"Decoding Inventory"]
[null,null,"Student Details",null,null,null,"  Assessment details",null,null,null,"Phoneme Segmentation",null,null,null,null,null,null,null,null,null,null,"(No BMs available) - Phoneme Blending",null,null,null,null,null,"First Sounds",null,null,null,null,null,null,null,null,null,null,"Continuous Blending",null,null,null,null,null,null,"Letter Names \n(/52)","Letter Sounds\n(/61)"," Irregular Words (/54)",null,"Phoneme Deletion\n(/5)","Phoneme Addition\n(/5)","Phoneme Substitution\n(/5)",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes",null,"Vowel Teams",null,"Vowel-R-Controlled",null,"Advanced Affixes",null,"Decoding Total Targets^ (not benchmarked)",null,null,null,null,null,null,null,"Irregular \nWords","Letter \nSounds","Letter \nNames",null,"Phoneme \nDeletion","Phoneme \nAddition","Phoneme \nSubstitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes","Vowel Teams","Vowel-R -Controlled","Advances Affixes"]
[null,"First Name","Last Name","Year\ngroup^","Class","Optional other details \n(e.g. EALD. Intervention)","Test type done\nBenchmark (BM) or Progress Monitoring (PM)?","Date of Assessment","Comments","Test Used^","CV \n(max. score of 2 sounds)",null,"CVC\n(max. score of 3 sounds)",null,null,null,"CVCC  (max. of 4)","CCVC\n(max. score of 4 sounds)",null,"CVCC  (max. of 4)","Phoneme Segmentation Total^ \n(/32 sounds)","CVC","CCV","CVC","CCVC","Two Syllables","Phoneme Blending Total^  \n(/5)\nColour = %, not BM","CVC",null,null,null,null,null,"CVCC",null,"CCVC",null,"First Sounds Total^ \n(/20)","CVC ",null,null,null,"CCV ","Continuous Blending Total (/10)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phoneme Segmentation Total^","Phoneme Blending Total^","First Sounds Total^","Continuous Blending Total"]
["#",null,null,null,null,null,null,null,null,null,"so","key","pain","dog","bought","gas","last","spice","blame","pest",null,"red","glue","soap","brad","chapter",null,"boat","jet","cut","rot","net","pail","last","dump","stop","grub",null,"ran","sin","moose","main","snow",null,null,null,null,null,null,null,null,null,null,null,null,"Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correct Targets","Correct Targets","Correct Targets","Correct Targets"]
["#","First Name","Last Name","Year group","Class","Optional other details","Test type done","Date of Assessment","Comments","Test Used^","so","key","pain","dog","bought","gas","last","spice","blame","pest","Phoneme Segmentation Total^","red","glue","soap","brad","chapter","Phoneme Blending Total^","boat","jet","cut","rot","net","pail","last","dump","stop","grub","First Sounds Total","ran","sin","moose","main","snow","Continuous Blending Total",null,"Letter Names","Letter Sounds","Irregular Words",null,"Phoneme Deletion","Phoneme Addition","Phoneme Substitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes - WC","Basic Affixes - CT","Vowel Teams - WC","Vowel Teams - CT","Vowel R-Controlled - WC","Vowel R-Controlled - CT","Advanced Affixes - WC","Advanced Affixes - CT","Decoding Total Targets"]
[1,null,null,{"$f":"IF(B8=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B8)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B8=\"\",\"\",IF(G8=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(K8:T8)>0,SUM(K8:T8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(V8:Z8)>0,SUM(V8:Z8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AB8:AK8)>0,SUM(AB8:AK8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AM8:AQ8)>0,SUM(AM8:AQ8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB8:BK8)>1,SUM(BB8,BC8,BE8,BG8,BI8,BK8),\"\")","v":""}]
[2,null,null,"",null,null,{"$f":"IF(COUNTA(B9)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,null,null,"",null,null,{"$f":"IF(COUNTA(B10)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,"",null,null,{"$f":"IF(COUNTA(B11)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,"",null,null,{"$f":"IF(COUNTA(B12)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,"",null,null,{"$f":"IF(COUNTA(B13)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,"",null,null,{"$f":"IF(COUNTA(B14)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,"",null,null,{"$f":"IF(COUNTA(B15)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,"",null,null,{"$f":"IF(COUNTA(B16)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,"",null,null,{"$f":"IF(COUNTA(B17)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,"",null,null,{"$f":"IF(COUNTA(B18)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,"",null,null,{"$f":"IF(COUNTA(B19)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,"",null,null,{"$f":"IF(COUNTA(B20)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,"",null,null,{"$f":"IF(COUNTA(B21)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,"",null,null,{"$f":"IF(COUNTA(B22)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,"",null,null,{"$f":"IF(COUNTA(B23)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,"",null,null,{"$f":"IF(COUNTA(B24)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,"",null,null,{"$f":"IF(COUNTA(B25)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,"",null,null,{"$f":"IF(COUNTA(B26)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,"",null,null,{"$f":"IF(COUNTA(B27)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,"",null,null,{"$f":"IF(COUNTA(B28)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,"",null,null,{"$f":"IF(COUNTA(B29)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,"",null,null,{"$f":"IF(COUNTA(B30)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,"",null,null,{"$f":"IF(COUNTA(B31)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,"",null,null,{"$f":"IF(COUNTA(B32)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,"",null,null,{"$f":"IF(COUNTA(B33)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,"",null,null,{"$f":"IF(COUNTA(B34)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,"",null,null,{"$f":"IF(COUNTA(B35)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,"",null,null,{"$f":"IF(COUNTA(B36)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,"",null,null,{"$f":"IF(COUNTA(B37)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[31,null,null,"",null,null,{"$f":"IF(COUNTA(B38)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[32,null,null,"",null,null,{"$f":"IF(COUNTA(B39)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[33,null,null,"",null,null,{"$f":"IF(COUNTA(B40)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[34,null,null,"",null,null,{"$f":"IF(COUNTA(B41)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[35,null,null,"",null,null,{"$f":"IF(COUNTA(B42)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[36,null,null,"",null,null,{"$f":"IF(COUNTA(B43)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[37,null,null,"",null,null,{"$f":"IF(COUNTA(B44)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[38,null,null,"",null,null,{"$f":"IF(COUNTA(B45)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[39,null,null,"",null,null,{"$f":"IF(COUNTA(B46)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[40,null,null,"",null,null,{"$f":"IF(COUNTA(B47)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[41,null,null,"",null,null,{"$f":"IF(COUNTA(B48)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[42,null,null,"",null,null,{"$f":"IF(COUNTA(B49)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[43,null,null,"",null,null,{"$f":"IF(COUNTA(B50)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[44,null,null,"",null,null,{"$f":"IF(COUNTA(B51)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[45,null,null,"",null,null,{"$f":"IF(COUNTA(B52)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[46,null,null,"",null,null,{"$f":"IF(COUNTA(B53)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[47,null,null,"",null,null,{"$f":"IF(COUNTA(B54)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[48,null,null,"",null,null,{"$f":"IF(COUNTA(B55)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[49,null,null,"",null,null,{"$f":"IF(COUNTA(B56)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[50,null,null,"",null,null,{"$f":"IF(COUNTA(B57)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[51,null,null,"",null,null,{"$f":"IF(COUNTA(B58)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[52,null,null,"",null,null,{"$f":"IF(COUNTA(B59)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[53,null,null,"",null,null,{"$f":"IF(COUNTA(B60)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[54,null,null,"",null,null,{"$f":"IF(COUNTA(B61)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[55,null,null,"",null,null,{"$f":"IF(COUNTA(B62)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[56,null,null,"",null,null,{"$f":"IF(COUNTA(B63)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[57,null,null,"",null,null,{"$f":"IF(COUNTA(B64)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[58,null,null,"",null,null,{"$f":"IF(COUNTA(B65)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[59,null,null,"",null,null,{"$f":"IF(COUNTA(B66)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[60,null,null,"",null,null,{"$f":"IF(COUNTA(B67)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[61,null,null,"",null,null,{"$f":"IF(COUNTA(B68)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[62,null,null,"",null,null,{"$f":"IF(COUNTA(B69)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[63,null,null,"",null,null,{"$f":"IF(COUNTA(B70)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[64,null,null,"",null,null,{"$f":"IF(COUNTA(B71)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[65,null,null,{"$f":"IF(B72=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B72)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B72=\"\",\"\",IF(G72=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(K72:T72)>0,SUM(K72:T72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(V72:Z72)>0,SUM(V72:Z72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AB72:AK72)>0,SUM(AB72:AK72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AM72:AQ72)>0,SUM(AM72:AQ72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB72:BK72)>1,SUM(BB72,BC72,BE72,BG72,BI72,BK72),\"\")","v":""}]
[66,null,null,"",null,null,{"$f":"IF(COUNTA(B73)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[67,null,null,"",null,null,{"$f":"IF(COUNTA(B74)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[68,null,null,"",null,null,{"$f":"IF(COUNTA(B75)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[69,null,null,"",null,null,{"$f":"IF(COUNTA(B76)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[70,null,null,"",null,null,{"$f":"IF(COUNTA(B77)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[71,null,null,"",null,null,{"$f":"IF(COUNTA(B78)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[72,null,null,"",null,null,{"$f":"IF(COUNTA(B79)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[73,null,null,"",null,null,{"$f":"IF(COUNTA(B80)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[74,null,null,"",null,null,{"$f":"IF(COUNTA(B81)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[75,null,null,"",null,null,{"$f":"IF(COUNTA(B82)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[76,null,null,"",null,null,{"$f":"IF(COUNTA(B83)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[77,null,null,"",null,null,{"$f":"IF(COUNTA(B84)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[78,null,null,"",null,null,{"$f":"IF(COUNTA(B85)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[79,null,null,"",null,null,{"$f":"IF(COUNTA(B86)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[80,null,null,"",null,null,{"$f":"IF(COUNTA(B87)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[81,null,null,"",null,null,{"$f":"IF(COUNTA(B88)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[82,null,null,"",null,null,{"$f":"IF(COUNTA(B89)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[83,null,null,"",null,null,{"$f":"IF(COUNTA(B90)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[84,null,null,"",null,null,{"$f":"IF(COUNTA(B91)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[85,null,null,"",null,null,{"$f":"IF(COUNTA(B92)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[86,null,null,"",null,null,{"$f":"IF(COUNTA(B93)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[87,null,null,"",null,null,{"$f":"IF(COUNTA(B94)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[88,null,null,"",null,null,{"$f":"IF(COUNTA(B95)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[89,null,null,"",null,null,{"$f":"IF(COUNTA(B96)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[90,null,null,"",null,null,{"$f":"IF(COUNTA(B97)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[91,null,null,"",null,null,{"$f":"IF(COUNTA(B98)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[92,null,null,"",null,null,{"$f":"IF(COUNTA(B99)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[93,null,null,"",null,null,{"$f":"IF(COUNTA(B100)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[94,null,null,"",null,null,{"$f":"IF(COUNTA(B101)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[95,null,null,"",null,null,{"$f":"IF(COUNTA(B102)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[96,null,null,"",null,null,{"$f":"IF(COUNTA(B103)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[97,null,null,"",null,null,{"$f":"IF(COUNTA(B104)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[98,null,null,"",null,null,{"$f":"IF(COUNTA(B105)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[99,null,null,"",null,null,{"$f":"IF(COUNTA(B106)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[100,null,null,"",null,null,{"$f":"IF(COUNTA(B107)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[101,null,null,"",null,null,{"$f":"IF(COUNTA(B108)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[102,null,null,"",null,null,{"$f":"IF(COUNTA(B109)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[103,null,null,"",null,null,{"$f":"IF(COUNTA(B110)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[104,null,null,"",null,null,{"$f":"IF(COUNTA(B111)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[105,null,null,"",null,null,{"$f":"IF(COUNTA(B112)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[106,null,null,"",null,null,{"$f":"IF(COUNTA(B113)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[107,null,null,"",null,null,{"$f":"IF(COUNTA(B114)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[108,null,null,"",null,null,{"$f":"IF(COUNTA(B115)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[109,null,null,"",null,null,{"$f":"IF(COUNTA(B116)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[110,null,null,"",null,null,{"$f":"IF(COUNTA(B117)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[111,null,null,"",null,null,{"$f":"IF(COUNTA(B118)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[112,null,null,"",null,null,{"$f":"IF(COUNTA(B119)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[113,null,null,"",null,null,{"$f":"IF(COUNTA(B120)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[114,null,null,"",null,null,{"$f":"IF(COUNTA(B121)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[115,null,null,"",null,null,{"$f":"IF(COUNTA(B122)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[116,null,null,"",null,null,{"$f":"IF(COUNTA(B123)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[117,null,null,"",null,null,{"$f":"IF(COUNTA(B124)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[118,null,null,"",null,null,{"$f":"IF(COUNTA(B125)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[119,null,null,"",null,null,{"$f":"IF(COUNTA(B126)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[120,null,null,"",null,null,{"$f":"IF(COUNTA(B127)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[121,null,null,"",null,null,{"$f":"IF(COUNTA(B128)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[122,null,null,"",null,null,{"$f":"IF(COUNTA(B129)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[123,null,null,"",null,null,{"$f":"IF(COUNTA(B130)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[124,null,null,"",null,null,{"$f":"IF(COUNTA(B131)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[125,null,null,"",null,null,{"$f":"IF(COUNTA(B132)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,{"$f":"IF(B134=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B134)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B134=\"\",\"\",IF(G134=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(K134:T134)>0,SUM(K134:T134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(V134:Z134)>0,SUM(V134:Z134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AB134:AK134)>0,SUM(AB134:AK134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AM134:AQ134)>0,SUM(AM134:AQ134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB134:BK134)>1,SUM(BB134,BC134,BE134,BG134,BI134,BK134),\"\")","v":""},null,null,{"$f":"IF(COUNTA(#REF!)>0,SUM(#REF!),\"\")","v":{"$error":"#REF!"}}]
[".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",null,null,".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".","."]

{"sheet":"Raw Scores-MOY","index":3,"n_rows":135,"n_cols":85,"rows_kept":135,"cut":false,"hidden":false,"merged":[[3,53,5,53],[3,54,5,54],[3,42,3,47],[3,10,5,10],[132,14,133,23],[4,41,5,41],[4,42,4,45],[4,47,5,47],[4,16,4,19],[3,11,5,11],[4,39,4,40],[3,12,5,12],[3,49,5,49],[3,50,5,50],[3,51,5,51],[4,21,4,22],[4,24,5,24],[4,30,5,30],[4,31,4,36],[4,37,4,38],[4,6,5,6],[4,9,5,9],[4,7,5,7],[4,8,5,8],[4,14,4,15],[3,80,5,80],[3,81,4,81],[3,82,4,82],[3,83,4,83],[3,84,4,84],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[3,79,5,79],[3,55,4,56],[3,57,4,58],[3,59,4,60],[3,61,4,62],[3,63,5,63],[3,71,5,71],[4,69,5,69],[3,72,5,72],[3,73,5,73],[3,75,5,75],[3,76,5,76],[3,77,5,77],[4,67,5,67],[4,68,5,68],[4,66,5,66],[3,0,3,1],[3,6,3,9],[3,14,3,24],[3,25,3,30],[3,31,3,41],[0,0,0,2],[0,66,0,69],[1,66,1,84],[2,14,2,47],[2,10,2,12],[2,49,2,51],[2,53,2,63],[2,66,2,69],[2,71,2,73],[2,75,2,77],[2,79,2,84]]}
["Dynamic Decoding Measures-3 Scores",null,null,null,{"$f":"'Raw Scores-BOY'!E1","v":"PP"},"MOY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals not working? \nScroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interpretations Summary"]
[null,null,null,null,null,null,null,null,null,null,"OM - Orthographic Mapping",null,null,null,"Phonemic Awareness",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phoneme Manipulation",null,null,null,"Decoding Inventory",null,null,null,null,null,null,null,null,null,null,null,null,"Phonemic Awareness",null,null,null,null,"Orthographic Mapping",null,null,null,"Phoneme Manipulation",null,null,null,"Decoding Inventory"]
[null,null,"Student Details",null,null,null,"Assessment details",null,null,null,"Irregular Words\n(/54)","Letter Sounds\n(/61)","*Letter Names\n(/52)",null,"Phoneme Segmentation",null,null,null,null,null,null,null,null,null,null,"Phoneme Blending",null,null,null,null,null,"*First Sounds",null,null,null,null,null,null,null,null,null,null,"*Continuous Blending",null,null,null,null,null,null,"Phoneme \nDeletion","Phoneme \nAddition","Phoneme \nSubstitution",null,"Closed Syllables","Vowel- \nConsonant -E    .","Basic Affixes",null,"Vowel Teams",null,"Vowel-R-Controlled",null,"Advanced Affixes",null,"Decoding Total Targets^ (not benchmarked)",null,null,null,null,null,null,null,"Irregular \nWords","Letter \nSounds","Letter \nNames",null,"Phoneme \nDeletion","Phoneme \nAddition","Phoneme \nSubstitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes","Vowel Teams","Vowel-R -Controlled","Advances Affixes"]
[null,"First Name","Last Name","Year\ngroup^","Class","Optional other details \n(e.g. EALD. Intervention)","Test type done\nBenchmark (BM) or Progress Monitoring (PM)?","Date of Assessment","Comments","Test Used^",null,null,null,null,"CV \n(max. score of 2 sounds)",null,"CVC\n(max. score of 3 sounds)",null,null,null,"CVCC  (max. of 4)","CCVC\n(max. score of 4 sounds)",null,"CVCC  (max. of 4)","Phoneme Segmentation Total^ \n(/32 sounds)","CVC","CCV","CVC","CCVC","Two Syllables","Phoneme Blending Total^  \n(/5)","CVC",null,null,null,null,null,"CVCC",null,"CCVC",null,"First Sounds Total^ \n(/20)","CVC ",null,null,null,"CCV ","Continuous Blending Total (/10)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phoneme Segmentation Total^","Phoneme Blending Total^","First Sounds Total^","Continuous Blending Total"]
["#",null,null,null,null,null,null,null,null,null,null,null,null,null,"so","key","pain","dog","bought","gas","last","spice","blame","pest",null,"red","glue","soap","brad","chapter",null,"boat","jet","cut","rot","net","pail","last","dump","stop","grub",null,"ran","sin","moose","main","snow",null,null,null,null,null,null,null,null,"Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correct Targets","Correct Targets","Correct Targets","Correct Targets"]
["#","First Name","Last Name","Year group","Class","Optional other details","Test type done","Date of Assessment","Comments","Test Used^","Irregular Words","Letter Sounds","Letter Names",null,"so","key","pain","dog","bought","gas","last","spice","blame","pest","Phoneme Segmentation Total^","red","glue","soap","brad","chapter","Phoneme Blending Total^","boat","jet","cut","rot","net","pail","last","dump","stop","grub","First Sounds Total","ran","sin","moose","main","snow","Continuous Blending Total",null,"Phoneme Deletion","Phoneme Addition","Phoneme Substitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes - WC","Basic Affixes - CT","Vowel Teams - WC","Vowel Teams - CT","Vowel R-Controlled - WC","Vowel R-Controlled - CT","Advanced Affixes - WC","Advanced Affixes - CT","Decoding Total Targets"]
[1,null,null,{"$f":"IF(B8=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B8)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B8=\"\",\"\",IF(G8=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O8:X8)>0,SUM(O8:X8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z8:AD8)>0,SUM(Z8:AD8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF8:AO8)>0,SUM(AF8:AO8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ8:AU8)>0,SUM(AQ8:AU8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB8:BK8)>1,SUM(BB8,BC8,BE8,BG8,BI8,BK8),\"\")","v":""}]
[2,null,null,"",null,null,{"$f":"IF(COUNTA(B9)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,null,null,"",null,null,{"$f":"IF(COUNTA(B10)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,"",null,null,{"$f":"IF(COUNTA(B11)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,"",null,null,{"$f":"IF(COUNTA(B12)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,"",null,null,{"$f":"IF(COUNTA(B13)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,"",null,null,{"$f":"IF(COUNTA(B14)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,"",null,null,{"$f":"IF(COUNTA(B15)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,"",null,null,{"$f":"IF(COUNTA(B16)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,"",null,null,{"$f":"IF(COUNTA(B17)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,"",null,null,{"$f":"IF(COUNTA(B18)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,"",null,null,{"$f":"IF(COUNTA(B19)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,"",null,null,{"$f":"IF(COUNTA(B20)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,"",null,null,{"$f":"IF(COUNTA(B21)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,"",null,null,{"$f":"IF(COUNTA(B22)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,"",null,null,{"$f":"IF(COUNTA(B23)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,"",null,null,{"$f":"IF(COUNTA(B24)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,"",null,null,{"$f":"IF(COUNTA(B25)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,"",null,null,{"$f":"IF(COUNTA(B26)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,"",null,null,{"$f":"IF(COUNTA(B27)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,"",null,null,{"$f":"IF(COUNTA(B28)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,"",null,null,{"$f":"IF(COUNTA(B29)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,"",null,null,{"$f":"IF(COUNTA(B30)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,"",null,null,{"$f":"IF(COUNTA(B31)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,"",null,null,{"$f":"IF(COUNTA(B32)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,"",null,null,{"$f":"IF(COUNTA(B33)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,"",null,null,{"$f":"IF(COUNTA(B34)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,"",null,null,{"$f":"IF(COUNTA(B35)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,"",null,null,{"$f":"IF(COUNTA(B36)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,"",null,null,{"$f":"IF(COUNTA(B37)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[31,null,null,"",null,null,{"$f":"IF(COUNTA(B38)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[32,null,null,"",null,null,{"$f":"IF(COUNTA(B39)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[33,null,null,{"$f":"IF(B40=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B40)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B40=\"\",\"\",IF(G40=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O40:X40)>0,SUM(O40:X40),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z40:AD40)>0,SUM(Z40:AD40),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF40:AO40)>0,SUM(AF40:AO40),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ40:AU40)>0,SUM(AQ40:AU40),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB40:BK40)>1,SUM(BB40,BC40,BE40,BG40,BI40,BK40),\"\")","v":""}]
[34,null,null,"",null,null,{"$f":"IF(COUNTA(B41)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[35,null,null,"",null,null,{"$f":"IF(COUNTA(B42)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[36,null,null,"",null,null,{"$f":"IF(COUNTA(B43)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[37,null,null,"",null,null,{"$f":"IF(COUNTA(B44)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[38,null,null,"",null,null,{"$f":"IF(COUNTA(B45)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[39,null,null,"",null,null,{"$f":"IF(COUNTA(B46)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[40,null,null,"",null,null,{"$f":"IF(COUNTA(B47)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[41,null,null,"",null,null,{"$f":"IF(COUNTA(B48)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[42,null,null,"",null,null,{"$f":"IF(COUNTA(B49)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[43,null,null,"",null,null,{"$f":"IF(COUNTA(B50)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[44,null,null,"",null,null,{"$f":"IF(COUNTA(B51)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[45,null,null,"",null,null,{"$f":"IF(COUNTA(B52)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[46,null,null,"",null,null,{"$f":"IF(COUNTA(B53)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[47,null,null,"",null,null,{"$f":"IF(COUNTA(B54)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[48,null,null,"",null,null,{"$f":"IF(COUNTA(B55)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[49,null,null,"",null,null,{"$f":"IF(COUNTA(B56)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[50,null,null,"",null,null,{"$f":"IF(COUNTA(B57)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[51,null,null,"",null,null,{"$f":"IF(COUNTA(B58)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[52,null,null,"",null,null,{"$f":"IF(COUNTA(B59)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[53,null,null,"",null,null,{"$f":"IF(COUNTA(B60)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[54,null,null,"",null,null,{"$f":"IF(COUNTA(B61)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[55,null,null,"",null,null,{"$f":"IF(COUNTA(B62)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[56,null,null,"",null,null,{"$f":"IF(COUNTA(B63)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[57,null,null,"",null,null,{"$f":"IF(COUNTA(B64)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[58,null,null,"",null,null,{"$f":"IF(COUNTA(B65)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[59,null,null,"",null,null,{"$f":"IF(COUNTA(B66)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[60,null,null,"",null,null,{"$f":"IF(COUNTA(B67)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[61,null,null,"",null,null,{"$f":"IF(COUNTA(B68)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[62,null,null,"",null,null,{"$f":"IF(COUNTA(B69)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[63,null,null,"",null,null,{"$f":"IF(COUNTA(B70)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[64,null,null,"",null,null,{"$f":"IF(COUNTA(B71)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[65,null,null,{"$f":"IF(B72=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B72)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B72=\"\",\"\",IF(G72=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O72:X72)>0,SUM(O72:X72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z72:AD72)>0,SUM(Z72:AD72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF72:AO72)>0,SUM(AF72:AO72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ72:AU72)>0,SUM(AQ72:AU72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB72:BK72)>1,SUM(BB72,BC72,BE72,BG72,BI72,BK72),\"\")","v":""}]
[66,null,null,"",null,null,{"$f":"IF(COUNTA(B73)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[67,null,null,"",null,null,{"$f":"IF(COUNTA(B74)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[68,null,null,"",null,null,{"$f":"IF(COUNTA(B75)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[69,null,null,"",null,null,{"$f":"IF(COUNTA(B76)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[70,null,null,"",null,null,{"$f":"IF(COUNTA(B77)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[71,null,null,"",null,null,{"$f":"IF(COUNTA(B78)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[72,null,null,"",null,null,{"$f":"IF(COUNTA(B79)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[73,null,null,"",null,null,{"$f":"IF(COUNTA(B80)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[74,null,null,"",null,null,{"$f":"IF(COUNTA(B81)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[75,null,null,"",null,null,{"$f":"IF(COUNTA(B82)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[76,null,null,"",null,null,{"$f":"IF(COUNTA(B83)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[77,null,null,"",null,null,{"$f":"IF(COUNTA(B84)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[78,null,null,"",null,null,{"$f":"IF(COUNTA(B85)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[79,null,null,"",null,null,{"$f":"IF(COUNTA(B86)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[80,null,null,"",null,null,{"$f":"IF(COUNTA(B87)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[81,null,null,"",null,null,{"$f":"IF(COUNTA(B88)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[82,null,null,"",null,null,{"$f":"IF(COUNTA(B89)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[83,null,null,"",null,null,{"$f":"IF(COUNTA(B90)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[84,null,null,"",null,null,{"$f":"IF(COUNTA(B91)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[85,null,null,"",null,null,{"$f":"IF(COUNTA(B92)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[86,null,null,"",null,null,{"$f":"IF(COUNTA(B93)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[87,null,null,"",null,null,{"$f":"IF(COUNTA(B94)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[88,null,null,"",null,null,{"$f":"IF(COUNTA(B95)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[89,null,null,"",null,null,{"$f":"IF(COUNTA(B96)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[90,null,null,"",null,null,{"$f":"IF(COUNTA(B97)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[91,null,null,"",null,null,{"$f":"IF(COUNTA(B98)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[92,null,null,"",null,null,{"$f":"IF(COUNTA(B99)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[93,null,null,"",null,null,{"$f":"IF(COUNTA(B100)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[94,null,null,"",null,null,{"$f":"IF(COUNTA(B101)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[95,null,null,"",null,null,{"$f":"IF(COUNTA(B102)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[96,null,null,"",null,null,{"$f":"IF(COUNTA(B103)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[97,null,null,{"$f":"IF(B104=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B104)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B104=\"\",\"\",IF(G104=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O104:X104)>0,SUM(O104:X104),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z104:AD104)>0,SUM(Z104:AD104),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF104:AO104)>0,SUM(AF104:AO104),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ104:AU104)>0,SUM(AQ104:AU104),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB104:BK104)>1,SUM(BB104,BC104,BE104,BG104,BI104,BK104),\"\")","v":""}]
[98,null,null,"",null,null,{"$f":"IF(COUNTA(B105)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[99,null,null,"",null,null,{"$f":"IF(COUNTA(B106)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[100,null,null,"",null,null,{"$f":"IF(COUNTA(B107)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[101,null,null,"",null,null,{"$f":"IF(COUNTA(B108)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[102,null,null,"",null,null,{"$f":"IF(COUNTA(B109)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[103,null,null,"",null,null,{"$f":"IF(COUNTA(B110)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[104,null,null,"",null,null,{"$f":"IF(COUNTA(B111)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[105,null,null,"",null,null,{"$f":"IF(COUNTA(B112)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[106,null,null,"",null,null,{"$f":"IF(COUNTA(B113)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[107,null,null,"",null,null,{"$f":"IF(COUNTA(B114)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[108,null,null,"",null,null,{"$f":"IF(COUNTA(B115)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[109,null,null,"",null,null,{"$f":"IF(COUNTA(B116)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[110,null,null,"",null,null,{"$f":"IF(COUNTA(B117)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[111,null,null,"",null,null,{"$f":"IF(COUNTA(B118)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[112,null,null,"",null,null,{"$f":"IF(COUNTA(B119)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[113,null,null,"",null,null,{"$f":"IF(COUNTA(B120)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[114,null,null,"",null,null,{"$f":"IF(COUNTA(B121)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[115,null,null,"",null,null,{"$f":"IF(COUNTA(B122)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[116,null,null,"",null,null,{"$f":"IF(COUNTA(B123)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[117,null,null,"",null,null,{"$f":"IF(COUNTA(B124)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[118,null,null,"",null,null,{"$f":"IF(COUNTA(B125)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[119,null,null,"",null,null,{"$f":"IF(COUNTA(B126)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[120,null,null,"",null,null,{"$f":"IF(COUNTA(B127)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[121,null,null,"",null,null,{"$f":"IF(COUNTA(B128)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[122,null,null,"",null,null,{"$f":"IF(COUNTA(B129)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[123,null,null,"",null,null,{"$f":"IF(COUNTA(B130)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[124,null,null,"",null,null,{"$f":"IF(COUNTA(B131)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[125,null,null,"",null,null,{"$f":"IF(COUNTA(B132)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,{"$f":"IF(B134=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B134)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B134=\"\",\"\",IF(G134=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O134:X134)>0,SUM(O134:X134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z134:AD134)>0,SUM(Z134:AD134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF134:AO134)>0,SUM(AF134:AO134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ134:AU134)>0,SUM(AQ134:AU134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB134:BK134)>1,SUM(BB134,BC134,BE134,BG134,BI134,BK134),\"\")","v":""},null,null,{"$f":"IF(COUNTA(#REF!)>0,SUM(#REF!),\"\")","v":{"$error":"#REF!"}}]
[".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",null,".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",null,null,".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".","."]

{"sheet":"Raw Scores-EOY","index":4,"n_rows":135,"n_cols":85,"rows_kept":135,"cut":false,"hidden":false,"merged":[[3,79,5,79],[3,80,5,80],[3,81,4,81],[3,82,4,82],[3,83,4,83],[2,71,2,73],[2,79,2,84],[1,66,1,84],[3,63,5,63],[2,53,2,63],[3,55,4,56],[3,54,5,54],[2,75,2,77],[3,71,5,71],[3,72,5,72],[3,73,5,73],[3,75,5,75],[3,76,5,76],[3,77,5,77],[3,84,4,84],[4,66,5,66],[4,4,5,4],[4,5,5,5],[132,14,133,23],[0,66,0,69],[2,66,2,69],[0,14,0,47],[4,24,5,24],[4,14,4,15],[4,16,4,19],[4,21,4,22],[2,49,2,51],[4,67,5,67],[4,68,5,68],[4,69,5,69],[4,7,5,7],[4,9,5,9],[0,0,0,2],[3,0,3,1],[3,6,3,9],[2,10,2,12],[3,14,3,24],[2,14,2,47],[3,31,3,41],[3,42,3,47],[3,12,5,12],[3,11,5,11],[3,10,5,10],[4,41,5,41],[4,47,5,47],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,6,5,6],[4,8,5,8],[3,25,3,30],[4,30,5,30],[3,59,4,60],[3,61,4,62],[4,42,4,45],[4,31,4,36],[4,37,4,38],[4,39,4,40],[3,49,5,49],[3,50,5,50],[3,51,5,51],[3,53,5,53],[3,57,4,58]]}
["Dynamic Decoding Measures-3 Scores",null,null,null,{"$f":"'Raw Scores-BOY'!E1","v":"PP"},"EOY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals not working? \nScroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total not working? Scroll to bottom…",null,null,"Interpretations Summary"]
[null,null,null,null,null,null,null,null,null,null,"OM - Orthographic Mapping",null,null,null,"Phonemic Awareness",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phoneme Manipulation",null,null,null,"Decoding Inventory",null,null,null,null,null,null,null,null,null,null,null,null,"Phonemic Awareness",null,null,null,null,"Orthographic Mapping",null,null,null,"Phoneme Manipulation",null,null,null,"Decoding Inventory"]
[null,null,"Student Details",null,null,null,"Assessment details",null,null,null,"Irregular Words\n(/54)","Letter Sounds\n(/61)","*Letter Names\n(/52)",null,"Phoneme Segmentation",null,null,null,null,null,null,null,null,null,null,"Phoneme Blending",null,null,null,null,null,"*First Sounds",null,null,null,null,null,null,null,null,null,null,"*Continuous Blending",null,null,null,null,null,null,"Phoneme Deletion\n(/5)","Phoneme Addition\n(/5)","Phoneme Substitution\n(/5)",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes",null,"Vowel Teams",null,"Vowel-R-Controlled",null,"Advanced Affixes",null,"Decoding Total Targets^ (not benchmarked)",null,null,null,null,null,null,null,"Irregular \nWords","Letter \nSounds","Letter \nNames",null,"Phoneme \nDeletion","Phoneme \nAddition","Phoneme \nSubstitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes","Vowel Teams","Vowel-R -Controlled","Advances Affixes"]
[null,"First Name","Last Name","Year\ngroup^","Class","Optional other details \n(e.g. EALD. Intervention)","Test type done\nBenchmark (BM) or Progress Monitoring (PM)?","Date of Assessment","Comments","Test Used^",null,null,null,null,"CV \n(max. score of 2 sounds)",null,"CVC\n(max. score of 3 sounds)",null,null,null,"CVCC  (max. of 4)","CCVC\n(max. score of 4 sounds)",null,"CVCC  (max. of 4)","Phoneme Segmentation Total^ \n(/32 sounds)","CVC","CCV","CVC","CCVC","Two Syllables","Phoneme Blending Total^  \n(/5)","CVC",null,null,null,null,null,"CVCC",null,"CCVC",null,"First Sounds Total^ \n(/20)","CVC ",null,null,null,"CCV ","Continuous Blending Total (/10)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phoneme Segmentation Total^","Phoneme Blending Total^","First Sounds Total^","Continuous Blending Total"]
["#",null,null,null,null,null,null,null,null,null,null,null,null,null,"so","key","pain","dog","bought","gas","last","spice","blame","pest",null,"red","glue","soap","brad","chapter",null,"boat","jet","cut","rot","net","pail","last","dump","stop","grub",null,"ran","sin","moose","main","snow",null,null,null,null,null,null,null,null,"Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets","Whole word","Correct Targets",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correct Targets","Correct Targets","Correct Targets","Correct Targets"]
["#","First Name","Last Name","Year group","Class","Optional other details","Test type done","Date of Assessment","Comments","Test Used^","Irregular Words","Letter Sounds","Letter Names",null,"so","key","pain","dog","bought","gas","last","spice","blame","pest","Phoneme Segmentation Total^","red","glue","soap","brad","chapter","Phoneme Blending Total^","boat","jet","cut","rot","net","pail","last","dump","stop","grub","First Sounds Total","ran","sin","moose","main","snow","Continuous Blending Total",null,"Phoneme Deletion","Phoneme Addition","Phoneme Substitution",null,"Closed Syllables","Vowel- \nConsonant -E","Basic Affixes - WC","Basic Affixes - CT","Vowel Teams - WC","Vowel Teams - CT","Vowel R-Controlled - WC","Vowel R-Controlled - CT","Advanced Affixes - WC","Advanced Affixes - CT","Decoding Total Targets"]
[1,null,null,{"$f":"IF(B8=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B8)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B8=\"\",\"\",IF(G8=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O8:X8)>0,SUM(O8:X8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z8:AD8)>0,SUM(Z8:AD8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF8:AO8)>0,SUM(AF8:AO8),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ8:AU8)>0,SUM(AQ8:AU8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB8:BK8)>1,SUM(BB8,BC8,BE8,BG8,BI8,BK8),\"\")","v":""}]
[2,null,null,"",null,null,{"$f":"IF(COUNTA(B9)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[3,null,null,"",null,null,{"$f":"IF(COUNTA(B10)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,"",null,null,{"$f":"IF(COUNTA(B11)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,"",null,null,{"$f":"IF(COUNTA(B12)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,"",null,null,{"$f":"IF(COUNTA(B13)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,"",null,null,{"$f":"IF(COUNTA(B14)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[8,null,null,"",null,null,{"$f":"IF(COUNTA(B15)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[9,null,null,"",null,null,{"$f":"IF(COUNTA(B16)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[10,null,null,"",null,null,{"$f":"IF(COUNTA(B17)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[11,null,null,"",null,null,{"$f":"IF(COUNTA(B18)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[12,null,null,"",null,null,{"$f":"IF(COUNTA(B19)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[13,null,null,"",null,null,{"$f":"IF(COUNTA(B20)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[14,null,null,"",null,null,{"$f":"IF(COUNTA(B21)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[15,null,null,"",null,null,{"$f":"IF(COUNTA(B22)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[16,null,null,"",null,null,{"$f":"IF(COUNTA(B23)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[17,null,null,"",null,null,{"$f":"IF(COUNTA(B24)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[18,null,null,"",null,null,{"$f":"IF(COUNTA(B25)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[19,null,null,"",null,null,{"$f":"IF(COUNTA(B26)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[20,null,null,"",null,null,{"$f":"IF(COUNTA(B27)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[21,null,null,"",null,null,{"$f":"IF(COUNTA(B28)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[22,null,null,"",null,null,{"$f":"IF(COUNTA(B29)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[23,null,null,"",null,null,{"$f":"IF(COUNTA(B30)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[24,null,null,"",null,null,{"$f":"IF(COUNTA(B31)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[25,null,null,"",null,null,{"$f":"IF(COUNTA(B32)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[26,null,null,"",null,null,{"$f":"IF(COUNTA(B33)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[27,null,null,"",null,null,{"$f":"IF(COUNTA(B34)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[28,null,null,"",null,null,{"$f":"IF(COUNTA(B35)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[29,null,null,"",null,null,{"$f":"IF(COUNTA(B36)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[30,null,null,"",null,null,{"$f":"IF(COUNTA(B37)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[31,null,null,"",null,null,{"$f":"IF(COUNTA(B38)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[32,null,null,"",null,null,{"$f":"IF(COUNTA(B39)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[33,null,null,{"$f":"IF(B40=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B40)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B40=\"\",\"\",IF(G40=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O40:X40)>0,SUM(O40:X40),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z40:AD40)>0,SUM(Z40:AD40),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF40:AO40)>0,SUM(AF40:AO40),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ40:AU40)>0,SUM(AQ40:AU40),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB40:BK40)>1,SUM(BB40,BC40,BE40,BG40,BI40,BK40),\"\")","v":""}]
[34,null,null,"",null,null,{"$f":"IF(COUNTA(B41)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[35,null,null,"",null,null,{"$f":"IF(COUNTA(B42)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[36,null,null,"",null,null,{"$f":"IF(COUNTA(B43)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[37,null,null,"",null,null,{"$f":"IF(COUNTA(B44)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[38,null,null,"",null,null,{"$f":"IF(COUNTA(B45)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[39,null,null,"",null,null,{"$f":"IF(COUNTA(B46)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[40,null,null,"",null,null,{"$f":"IF(COUNTA(B47)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[41,null,null,"",null,null,{"$f":"IF(COUNTA(B48)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[42,null,null,"",null,null,{"$f":"IF(COUNTA(B49)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[43,null,null,"",null,null,{"$f":"IF(COUNTA(B50)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[44,null,null,"",null,null,{"$f":"IF(COUNTA(B51)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[45,null,null,"",null,null,{"$f":"IF(COUNTA(B52)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[46,null,null,"",null,null,{"$f":"IF(COUNTA(B53)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[47,null,null,"",null,null,{"$f":"IF(COUNTA(B54)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[48,null,null,"",null,null,{"$f":"IF(COUNTA(B55)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[49,null,null,"",null,null,{"$f":"IF(COUNTA(B56)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[50,null,null,"",null,null,{"$f":"IF(COUNTA(B57)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[51,null,null,"",null,null,{"$f":"IF(COUNTA(B58)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[52,null,null,"",null,null,{"$f":"IF(COUNTA(B59)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[53,null,null,"",null,null,{"$f":"IF(COUNTA(B60)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[54,null,null,"",null,null,{"$f":"IF(COUNTA(B61)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[55,null,null,"",null,null,{"$f":"IF(COUNTA(B62)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[56,null,null,"",null,null,{"$f":"IF(COUNTA(B63)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[57,null,null,"",null,null,{"$f":"IF(COUNTA(B64)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[58,null,null,"",null,null,{"$f":"IF(COUNTA(B65)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[59,null,null,"",null,null,{"$f":"IF(COUNTA(B66)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[60,null,null,"",null,null,{"$f":"IF(COUNTA(B67)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[61,null,null,"",null,null,{"$f":"IF(COUNTA(B68)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[62,null,null,"",null,null,{"$f":"IF(COUNTA(B69)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[63,null,null,"",null,null,{"$f":"IF(COUNTA(B70)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[64,null,null,"",null,null,{"$f":"IF(COUNTA(B71)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[65,null,null,{"$f":"IF(B72=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B72)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B72=\"\",\"\",IF(G72=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O72:X72)>0,SUM(O72:X72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z72:AD72)>0,SUM(Z72:AD72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF72:AO72)>0,SUM(AF72:AO72),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ72:AU72)>0,SUM(AQ72:AU72),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB72:BK72)>1,SUM(BB72,BC72,BE72,BG72,BI72,BK72),\"\")","v":""}]
[66,null,null,"",null,null,{"$f":"IF(COUNTA(B73)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[67,null,null,"",null,null,{"$f":"IF(COUNTA(B74)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[68,null,null,"",null,null,{"$f":"IF(COUNTA(B75)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[69,null,null,"",null,null,{"$f":"IF(COUNTA(B76)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[70,null,null,"",null,null,{"$f":"IF(COUNTA(B77)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[71,null,null,"",null,null,{"$f":"IF(COUNTA(B78)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[72,null,null,"",null,null,{"$f":"IF(COUNTA(B79)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[73,null,null,"",null,null,{"$f":"IF(COUNTA(B80)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[74,null,null,"",null,null,{"$f":"IF(COUNTA(B81)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[75,null,null,"",null,null,{"$f":"IF(COUNTA(B82)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[76,null,null,"",null,null,{"$f":"IF(COUNTA(B83)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[77,null,null,"",null,null,{"$f":"IF(COUNTA(B84)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[78,null,null,"",null,null,{"$f":"IF(COUNTA(B85)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[79,null,null,"",null,null,{"$f":"IF(COUNTA(B86)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[80,null,null,"",null,null,{"$f":"IF(COUNTA(B87)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[81,null,null,"",null,null,{"$f":"IF(COUNTA(B88)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[82,null,null,"",null,null,{"$f":"IF(COUNTA(B89)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[83,null,null,"",null,null,{"$f":"IF(COUNTA(B90)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[84,null,null,"",null,null,{"$f":"IF(COUNTA(B91)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[85,null,null,"",null,null,{"$f":"IF(COUNTA(B92)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[86,null,null,"",null,null,{"$f":"IF(COUNTA(B93)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[87,null,null,"",null,null,{"$f":"IF(COUNTA(B94)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[88,null,null,"",null,null,{"$f":"IF(COUNTA(B95)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[89,null,null,"",null,null,{"$f":"IF(COUNTA(B96)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[90,null,null,"",null,null,{"$f":"IF(COUNTA(B97)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[91,null,null,"",null,null,{"$f":"IF(COUNTA(B98)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[92,null,null,"",null,null,{"$f":"IF(COUNTA(B99)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[93,null,null,"",null,null,{"$f":"IF(COUNTA(B100)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[94,null,null,"",null,null,{"$f":"IF(COUNTA(B101)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[95,null,null,"",null,null,{"$f":"IF(COUNTA(B102)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[96,null,null,"",null,null,{"$f":"IF(COUNTA(B103)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[97,null,null,{"$f":"IF(B104=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B104)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B104=\"\",\"\",IF(G104=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O104:X104)>0,SUM(O104:X104),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z104:AD104)>0,SUM(Z104:AD104),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF104:AO104)>0,SUM(AF104:AO104),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ104:AU104)>0,SUM(AQ104:AU104),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB104:BK104)>1,SUM(BB104,BC104,BE104,BG104,BI104,BK104),\"\")","v":""}]
[98,null,null,"",null,null,{"$f":"IF(COUNTA(B105)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[99,null,null,"",null,null,{"$f":"IF(COUNTA(B106)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[100,null,null,"",null,null,{"$f":"IF(COUNTA(B107)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[101,null,null,"",null,null,{"$f":"IF(COUNTA(B108)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[102,null,null,"",null,null,{"$f":"IF(COUNTA(B109)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[103,null,null,"",null,null,{"$f":"IF(COUNTA(B110)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[104,null,null,"",null,null,{"$f":"IF(COUNTA(B111)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[105,null,null,"",null,null,{"$f":"IF(COUNTA(B112)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[106,null,null,"",null,null,{"$f":"IF(COUNTA(B113)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[107,null,null,"",null,null,{"$f":"IF(COUNTA(B114)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[108,null,null,"",null,null,{"$f":"IF(COUNTA(B115)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[109,null,null,"",null,null,{"$f":"IF(COUNTA(B116)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[110,null,null,"",null,null,{"$f":"IF(COUNTA(B117)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[111,null,null,"",null,null,{"$f":"IF(COUNTA(B118)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[112,null,null,"",null,null,{"$f":"IF(COUNTA(B119)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[113,null,null,"",null,null,{"$f":"IF(COUNTA(B120)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[114,null,null,"",null,null,{"$f":"IF(COUNTA(B121)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[115,null,null,"",null,null,{"$f":"IF(COUNTA(B122)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[116,null,null,"",null,null,{"$f":"IF(COUNTA(B123)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[117,null,null,"",null,null,{"$f":"IF(COUNTA(B124)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[118,null,null,"",null,null,{"$f":"IF(COUNTA(B125)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[119,null,null,"",null,null,{"$f":"IF(COUNTA(B126)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[120,null,null,"",null,null,{"$f":"IF(COUNTA(B127)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[121,null,null,"",null,null,{"$f":"IF(COUNTA(B128)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[122,null,null,"",null,null,{"$f":"IF(COUNTA(B129)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[123,null,null,"",null,null,{"$f":"IF(COUNTA(B130)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[124,null,null,"",null,null,{"$f":"IF(COUNTA(B131)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[125,null,null,"",null,null,{"$f":"IF(COUNTA(B132)=0,\"\",Dropdowns!$C$2)","v":""},null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,{"$f":"IF(B134=\"\",\"\",$E$1)","v":""},null,null,{"$f":"IF(COUNTA(B134)=0,\"\",Dropdowns!$C$2)","v":""},null,null,{"$f":"IF(B134=\"\",\"\",IF(G134=\"PM\",\"\",$F$1))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(O134:X134)>0,SUM(O134:X134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(Z134:AD134)>0,SUM(Z134:AD134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(AF134:AO134)>0,SUM(AF134:AO134),\"\")","v":""},null,null,null,null,null,{"$f":"IF(COUNTA(AQ134:AU134)>0,SUM(AQ134:AU134),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(BB134:BK134)>1,SUM(BB134,BC134,BE134,BG134,BI134,BK134),\"\")","v":""},null,null,{"$f":"IF(COUNTA(#REF!)>0,SUM(#REF!),\"\")","v":{"$error":"#REF!"}}]
[".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",null,null,".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".",".","."]

{"sheet":"Benchmark Scores","index":5,"n_rows":29,"n_cols":33,"rows_kept":29,"cut":false,"hidden":true,"merged":[[9,0,9,24],[0,0,1,0],[1,21,1,22],[1,23,1,24],[1,11,1,12],[1,13,1,14],[1,15,1,16],[1,17,1,18],[1,19,1,20],[1,1,1,2],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,26,1,32],[21,0,21,24],[22,1,22,8],[22,9,22,16],[22,17,22,24],[10,1,10,8],[10,9,10,16],[10,17,10,24],[15,0,15,24],[16,1,16,8],[16,9,16,16],[16,17,16,24],[3,17,3,24],[2,0,2,24],[3,1,3,8],[3,9,3,16]]}
["PP DDM-3 Benchmarks"]
[null,"Significant Risk",null,"Moderate Risk",null,"Benchmark",null,"Advanced",null,"Significant Risk",null,"Moderate Risk",null,"Benchmark",null,"Advanced",null,"Significant Risk",null,"Moderate Risk",null,"Benchmark",null,"Advanced",null,null,"Number of points"]
["Phonemic Awareness",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtest out of",{"$f":"Dropdowns!$L$4","v":0},{"$f":"Dropdowns!$M$4","v":0.25},{"$f":"Dropdowns!$N$4","v":0.26},{"$f":"Dropdowns!$O$4","v":0.75},{"$f":"Dropdowns!$P$4","v":0.76},{"$f":"Dropdowns!$Q$4","v":1}]
[null,"BOY",null,null,null,null,null,null,null,"MOY",null,null,null,null,null,null,null,"EOY"]
["Phoneme Segmentation",0,1,2,13,14,27,28,32,0,19,20,26,27,30,31,32,0,26,27,28,29,32,"-","-"]
["Phoneme Blending ","-","-","-","-","-","-","-","-",0,2,3,3,4,4,5,5,0,2,3,3,4,4,5,5,"Use for BOY only",20,{"$f":"$AA6*AB$3","v":0},5,5.2,15,15.2,20]
["First Sounds",0,9,10,15,16,18,19,20,0,15,16,18,19,19,20,20,0,16,17,18,19,19,20,20]
["Continuous Blending",0,2,3,6,7,9,10,10,0,8,9,9,10,10,"-","-",0,9,"-","-",10,10,"-","-"]
[]
["Phoneme Manipulation"]
[null,"BOY",null,null,null,null,null,null,null,"MOY",null,null,null,null,null,null,null,"EOY",null,null,null,null,null,null,null,null,"Subtest out of",0,0.25,0.26,0.75,0.76,1]
["Phoneme Deletion","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,5,{"$f":"$AA12*AB$3","v":0},1.25,1.3,3.75,3.8,5]
["Phoneme Addition","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,5,0,1.25,1.3,3.75,3.8,5]
["Phoneme Manipulation","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,5,0,1.25,1.3,3.75,3.8,5]
[]
["Orthographic Mapping"]
[null,"BOY",null,null,null,null,null,null,null,"MOY",null,null,null,null,null,null,null,"EOY"]
["Irregular Words","-","-",0,2,3,11,12,54,0,3,4,6,7,14,15,54,0,7,8,11,12,25,26,54]
["Letter Sounds","-","-",0,4,5,9,10,61,0,5,6,14,15,24,25,61,0,18,19,29,30,34,35,61]
["Letter Name",0,2,3,9,10,36,37,52,0,13,14,24,25,42,43,52,0,46,47,49,50,51,52,52]
["Note, letter names are based on percentiles"]
["Decoding Inventory"]
[null,"BOY",null,null,null,null,null,null,null,"MOY",null,null,null,null,null,null,null,"EOY",null,null,null,null,null,null,null,null,"Subtest out of",0,0.25,0.26,0.75,0.76,1]
["Closed Syllables","-","-","-","-","-","-","-","-",0,0,1,1,2,3,4,6,0,1,2,2,3,4,5,6,null,6,{"$f":"$AA24*AB$3","v":0},1.5,1.56,4.5,4.5600000000000005,6]
["Vowel-Consonant-E","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,6,0,1.5,1.56,4.5,4.5600000000000005,6]
["Basic Affixes","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,6,0,1.5,1.56,4.5,4.5600000000000005,6]
["Vowel Teams","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,7,0,1.75,1.82,5.25,5.32,7]
["Vowel-R-Controlled","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,7,0,1.75,1.82,5.25,5.32,7]
["Advanced Affixes","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-",null,6,0,1.5,1.56,4.5,4.5600000000000005,6]

{"sheet":"Dropdowns","index":6,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":true,"merged":[[2,10,4,10]]}
["Scores",null,"Test Types",null,"Grades",null,"Timepoint",null,"Risk Categories",null,"Spreadsheet version: v1.1"]
[null,null,"BM",null,"Kindy",null,"BOY",null,"Advanced"]
[0,null,"PM",null,"PP",null,"MOY",null,"Benchmark",null,"Percentage bands used:"]
[1,null,null,null,"Year 1",null,"EOY",null,"Moderate Risk",null,null,0,0.25,0.26,0.75,0.76,1]
[2,null,null,null,"Year 2",null,null,null,"Significant Risk"]
[3,null,null,null,"Year 3"]
[4,null,null,null,"Year 4"]
[null,null,null,null,"Year 5"]
[null,null,null,null,"Year 6"]
[null,null,null,null,"Year 7"]
[null,null,null,null,"Year 8"]