{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Fidelity Dashboard","Coaching Log Summary","Instructions","Pivot Data","Data Validation (FIPP Use Only)","Transition data table","Data Table","CL#1","CL#2","CL#3","CL#4","CL#5","CL#6","CL#7","CL#8","CL#9","CL#10"],"not_rendered":{"charts":6,"images":15,"macros":1,"external_links":0,"defined_names":33,"comments":0,"pivot_tables":7},"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":"Fidelity Dashboard","index":0,"n_rows":27,"n_cols":19,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,18,23,19],[24,18,24,19],[26,15,26,16],[26,18,26,19],[22,15,22,16],[23,15,23,16],[24,15,24,16],[25,15,25,16],[25,18,25,19],[21,18,21,19],[22,18,22,19],[16,15,16,16],[17,15,17,16],[18,15,18,16],[19,15,19,16],[20,15,20,16],[21,15,21,16],[16,18,16,19],[17,18,17,19],[18,18,18,19],[19,18,19,19],[20,18,20,19]]}
["MASTER COACH FIDELITY DASHBOARD"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Joint Planning",null,null,"Observation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D44=\"\",\"\",'Pivot Data'!D44)","v":"00:00:00"},null,{"$f":"IF('Pivot Data'!E44=\"\",\"\",'Pivot Data'!E44)","v":0},null,null,{"$f":"IF('Pivot Data'!F44=\"\",\"\",'Pivot Data'!F44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D45=\"\",\"\",'Pivot Data'!D45)","v":"2018-01-15"},null,{"$f":"IF('Pivot Data'!E45=\"\",\"\",'Pivot Data'!E45)","v":0},null,null,{"$f":"IF('Pivot Data'!F45=\"\",\"\",'Pivot Data'!F45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D46=\"\",\"\",'Pivot Data'!D46)","v":"2018-02-15"},null,{"$f":"IF('Pivot Data'!E46=\"\",\"\",'Pivot Data'!E46)","v":0},null,null,{"$f":"IF('Pivot Data'!F46=\"\",\"\",'Pivot Data'!F46)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D47=\"\",\"\",'Pivot Data'!D47)","v":"2018-03-15"},null,{"$f":"IF('Pivot Data'!E47=\"\",\"\",'Pivot Data'!E47)","v":0},null,null,{"$f":"IF('Pivot Data'!F47=\"\",\"\",'Pivot Data'!F47)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D48=\"\",\"\",'Pivot Data'!D48)","v":"2018-05-15"},null,{"$f":"IF('Pivot Data'!E48=\"\",\"\",'Pivot Data'!E48)","v":0},null,null,{"$f":"IF('Pivot Data'!F48=\"\",\"\",'Pivot Data'!F48)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D49=\"\",\"\",'Pivot Data'!D49)","v":"2021-04-15"},null,{"$f":"IF('Pivot Data'!E49=\"\",\"\",'Pivot Data'!E49)","v":0},null,null,{"$f":"IF('Pivot Data'!F49=\"\",\"\",'Pivot Data'!F49)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D50=\"\",\"\",'Pivot Data'!D50)","v":""},null,{"$f":"IF('Pivot Data'!E50=\"\",\"\",'Pivot Data'!E50)","v":""},null,null,{"$f":"IF('Pivot Data'!F50=\"\",\"\",'Pivot Data'!F50)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D51=\"\",\"\",'Pivot Data'!D51)","v":""},null,{"$f":"IF('Pivot Data'!E51=\"\",\"\",'Pivot Data'!E51)","v":""},null,null,{"$f":"IF('Pivot Data'!F51=\"\",\"\",'Pivot Data'!F51)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D52=\"\",\"\",'Pivot Data'!D52)","v":""},null,{"$f":"IF('Pivot Data'!E52=\"\",\"\",'Pivot Data'!E52)","v":""},null,null,{"$f":"IF('Pivot Data'!F52=\"\",\"\",'Pivot Data'!F52)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D53=\"\",\"\",'Pivot Data'!D53)","v":""},null,{"$f":"IF('Pivot Data'!E53=\"\",\"\",'Pivot Data'!E53)","v":""},null,null,{"$f":"IF('Pivot Data'!F53=\"\",\"\",'Pivot Data'!F53)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Pivot Data'!D53=\"\",\"\",'Pivot Data'!D53)","v":""},null,{"$f":"IF('Pivot Data'!E53=\"\",\"\",'Pivot Data'!E53)","v":""},null,null,{"$f":"IF('Pivot Data'!F53=\"\",\"\",'Pivot Data'!F53)","v":""}]

{"sheet":"Coaching Log Summary","index":1,"n_rows":19,"n_cols":24,"rows_kept":19,"cut":false,"hidden":false,"merged":[[17,3,17,23]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C$1), \"\", 'CL#1'!$C$1)","v":"NC"},null,"Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C$2), \"\", 'CL#1'!$C$2)","v":"Region 1"}]
["Master Coach:",null,null,null,{"$f":"IF(ISBLANK('CL#1'!$C$3),\"\",'CL#1'!$C$3)","v":"Phoebe"},null,null,null,null,null,null,null,"Discipline:",null,null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"}]
["Fidelity Coach:",null,null,null,{"$f":"IF(ISBLANK('CL#1'!$C$5), \"\", 'CL#1'!$C$5)","v":"Sarah"}]
[]
[null,null,null,null,null,null,"Reflection",null,null,null,null,null,null,"Feedback",null,null,null,"Topics",null,null,null,null,null,"Joint Plan \nMaster Coach/Coach(ee)"]
[null,null,null,null,null,null,"Questions",null,null,null,"Yes/No",null,"I",null,"D","E","A"]
["Log #","Date","Log # of pages","Type of Interaction","Joint Plan (+/-) ","Observation of coach(ee)","Awareness","Analysis","Alternatives","Action","Permission/Assumption","Closed-Ended","(I) Informative - Accurate","(I) Informative - Inaccurate","(D) Directive ","(E) Evaluative ","(A) Affirmative ","Coaching","Teaming","Resource-Based","Non-Evidence-Based Practice","NLEP","Other"]
[{"$f":"IF(ISBLANK('CL#1'!$R$1),\"\",(ROW()-7))","v":1},{"$f":"IF(ISBLANK('CL#1'!$R$1), \"\",'CL#1'!$R$1)","v":"2018-01-15"},{"$f":"IF(ISBLANK('CL#1'!$I$1), \"\", 'CL#1'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C19), \"\", 'Data Validation (FIPP Use Only)'!$C19)","v":"IC"},{"$f":"IF('Data Table'!$AT2=0,\"\", IF(SUM('CL#1'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'CL#1'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",COUNTIF('CL#1'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!I30)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!J30)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!K30)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!L30)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!M30)","v":""},{"$f":"IF('Data Table'!$AT2=0,\"\",'Data Validation (FIPP Use Only)'!N30)","v":""}]
[{"$f":"IF(ISBLANK('CL#2'!$R$1),\"\",(ROW()-7))","v":2},{"$f":"IF(ISBLANK('CL#2'!$R$1), \"\",'CL#2'!$R$1)","v":"2018-02-15"},{"$f":"IF(ISBLANK('CL#2'!I1), \"\", 'CL#2'!I1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C20), \"\", 'Data Validation (FIPP Use Only)'!$C20)","v":"IP"},{"$f":"IF('Data Table'!$AT3=0,\"\", IF(SUM('CL#2'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'CL#2'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",COUNTIF('CL#2'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!I31)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!J31)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!K31)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!L31)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!M31)","v":""},{"$f":"IF('Data Table'!$AT3=0,\"\",'Data Validation (FIPP Use Only)'!N31)","v":""}]
[{"$f":"IF(ISBLANK('CL#3'!$R$1),\"\",(ROW()-7))","v":3},{"$f":"IF(ISBLANK('CL#3'!$R$1), \"\",'CL#3'!$R$1)","v":"2018-03-15"},{"$f":"IF(ISBLANK('CL#3'!$I$1), \"\", 'CL#3'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C21), \"\", 'Data Validation (FIPP Use Only)'!$C21)","v":"IC"},{"$f":"IF('Data Table'!$AT4=0,\"\", IF(SUM('CL#3'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'CL#3'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",COUNTIF('CL#3'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!I32)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!J32)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!K32)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!L32)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!M32)","v":""},{"$f":"IF('Data Table'!$AT4=0,\"\",'Data Validation (FIPP Use Only)'!N32)","v":""}]
[{"$f":"IF(ISBLANK('CL#4'!$R$1),\"\",(ROW()-7))","v":4},{"$f":"IF(ISBLANK('CL#4'!$R$1), \"\",'CL#4'!$R$1)","v":"2021-04-15"},{"$f":"IF(ISBLANK('CL#4'!$I$1), \"\", 'CL#4'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C22), \"\", 'Data Validation (FIPP Use Only)'!$C22)","v":"IC"},{"$f":"IF('Data Table'!$AT5=0,\"\", IF(SUM('CL#4'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'CL#4'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",COUNTIF('CL#4'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!I33)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!J33)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!K33)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!L33)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!M33)","v":""},{"$f":"IF('Data Table'!$AT5=0,\"\",'Data Validation (FIPP Use Only)'!N33)","v":""}]
[{"$f":"IF(ISBLANK('CL#5'!$R$1),\"\",(ROW()-7))","v":5},{"$f":"IF(ISBLANK('CL#5'!$R$1), \"\",'CL#5'!$R$1)","v":"2018-05-15"},{"$f":"IF(ISBLANK('CL#5'!$I$1), \"\", 'CL#5'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C23), \"\", 'Data Validation (FIPP Use Only)'!$C23)","v":"IC"},{"$f":"IF('Data Table'!$AT6=0,\"\", IF(SUM('CL#5'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'CL#5'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",COUNTIF('CL#5'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!I34)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!J34)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!K34)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!L34)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!M34)","v":""},{"$f":"IF('Data Table'!$AT6=0,\"\",'Data Validation (FIPP Use Only)'!N34)","v":""}]
[{"$f":"IF(ISBLANK('CL#6'!$R$1),\"\",(ROW()-7))","v":""},{"$f":"IF(ISBLANK('CL#6'!$R$1), \"\",'CL#6'!$R$1)","v":""},{"$f":"IF(ISBLANK('CL#6'!$I$1), \"\", 'CL#6'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C24), \"\", 'Data Validation (FIPP Use Only)'!$C24)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\", IF(SUM('CL#6'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'CL#6'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",COUNTIF('CL#6'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!I35)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!J35)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!K35)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!L35)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!M35)","v":""},{"$f":"IF('Data Table'!$AT7=0,\"\",'Data Validation (FIPP Use Only)'!N35)","v":""}]
[{"$f":"IF(ISBLANK('CL#7'!$R$1),\"\",(ROW()-7))","v":""},{"$f":"IF(ISBLANK('CL#7'!$R$1), \"\",'CL#7'!$R$1)","v":""},{"$f":"IF(ISBLANK('CL#7'!$I$1), \"\", 'CL#7'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C25), \"\", 'Data Validation (FIPP Use Only)'!$C25)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\", IF(SUM('CL#7'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'CL#7'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",COUNTIF('CL#7'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!I36)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!J36)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!K36)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!L36)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!M36)","v":""},{"$f":"IF('Data Table'!$AT8=0,\"\",'Data Validation (FIPP Use Only)'!N36)","v":""}]
[{"$f":"IF(ISBLANK('CL#8'!$R$1),\"\",(ROW()-7))","v":""},{"$f":"IF(ISBLANK('CL#8'!$R$1), \"\",'CL#8'!$R$1)","v":""},{"$f":"IF(ISBLANK('CL#8'!$I$1), \"\", 'CL#8'!$I$1)","v":""},{"$f":"IF(ISBLANK('Data Validation (FIPP Use Only)'!$C26), \"\", 'Data Validation (FIPP Use Only)'!$C26)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\", IF(SUM('CL#8'!$K$12:$K$338)>=1,1,0))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'CL#8'!$J$5)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$L$12:$L$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$L$12:$L$338,\"2\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$L$12:$L$338,\"3\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$L$12:$L$338,\"4\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$M$12:$M$338,\"P/A\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$M$12:$M$338,\"C-E\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$N$12:$N$338,\"A\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!$N$12:$N$338,\"I\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!O$12:O$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!P$12:P$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",COUNTIF('CL#8'!Q$12:Q$338,\"1\"))","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!I37)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!J37)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!K37)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!L37)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!M37)","v":""},{"$f":"IF('Data Table'!$AT9=0,\"\",'Data Validation (FIPP Use Only)'!N37)","v":""}]
[{"$f":"IF(ISBLANK('CL#9'!$R$1),\"\",(ROW()-7))","v":""},null,null,null,null,"O"]
[{"$f":"IF(ISBLANK('CL#10'!$R$1),\"\",(ROW()-7))","v":""},null,null,null,null,"O"]
["Additional Notes:"]
["Type of Interaction Key:  ",null,null,null,"IP - Individual Parent     IC - Individual Coach     GC - Group Coach     PIC - Phone Individual Coach     PGC - Phone Group Coach"]

{"sheet":"Instructions","index":2,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,10]

{"sheet":"Pivot Data","index":3,"n_rows":55,"n_cols":33,"rows_kept":55,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null," Yes/No","Sum of YN Target","Sum of YN F","Sum of YN AF","Sum of YN NF","Sum of % C-E Y/N",null,null,"Column Labels"]
[null,null,null,null,null,null,null,null,null,null,0.2,0,null,null,0,null,"Values",null,"00:00:00","2018-01-15","2018-02-15","2018-03-15","2018-05-15","2021-04-15"]
[null,null,null,null,null,null,null,null,null,"00:00:00",0.2,0,null,null,0,null,"Informative-Accurate",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"2018-01-15",0.2,0,null,null,0,null,"Informative-Inaccurate",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"2018-02-15",0.2,0,null,null,0,null,"Directive",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"2018-03-15",0.2,0,null,null,0,null,"Evaluative",0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"2018-05-15",0.2,0,null,null,0,null,"Affirmative",0,0,0,1,0,0,0]
[null,null,null,null,null,null,null,null,null,"2021-04-15",0.2,0,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q4","v":"Values"},{"$f":"IF(R4=\"\",\"\",R4)","v":""},{"$f":"IF(S4=\"\",\"\",S4)","v":"00:00:00"},"2018-01-15","2018-02-15","2018-03-15","2018-05-15","2021-04-15","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q5","v":"Informative-Accurate"},{"$f":"IF($R$4=\"\",\"\",R5)","v":""},{"$f":"IF($S$4=\"\",\"\",S5)","v":0},{"$f":"IF($T$4=\"\",\"\",T5)","v":0},{"$f":"IF($U$4=\"\",\"\",U5)","v":0},{"$f":"IF($V$4=\"\",\"\",V5)","v":0},{"$f":"IF($W$4=\"\",\"\",W5)","v":0},{"$f":"IF($X$4=\"\",\"\",X5)","v":0},{"$f":"IF($Y$4=\"\",\"\",Y5)","v":""},{"$f":"IF($Z$4=\"\",\"\",Z5)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informative-Inaccurate",{"$f":"IF($R$4=\"\",\"\",R6)","v":""},{"$f":"IF($S$4=\"\",\"\",S6)","v":0},{"$f":"IF($T$4=\"\",\"\",T6)","v":0},{"$f":"IF($U$4=\"\",\"\",U6)","v":0},{"$f":"IF($V$4=\"\",\"\",V6)","v":0},{"$f":"IF($W$4=\"\",\"\",W6)","v":0},{"$f":"IF($X$4=\"\",\"\",X6)","v":0},{"$f":"IF($Y$4=\"\",\"\",Y6)","v":""},{"$f":"IF($Z$4=\"\",\"\",Z6)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directive","",0,0,0,0,0,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evaluative","",0,0,0,0,0,0,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Affirmative","",0,0,1,0,0,0,"",""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," Fidelity Scorecard",null,null,"Sum","OF_F Stack 1","OF_AF Stack 1","OF_NF Stack 1",null,"OF"]
[null,null,null,null,null,null,null,null,null,null,null,null," Joint Planning",0,{"$f":"$M24","v":" Joint Planning"},{"$f":"$N24","v":0},{"$f":"IF(P24>=4,P24,\"\")","v":""},{"$f":"IF(P24=3,P24,\"\")","v":""},{"$f":"IF(P24<=2,P24,\"\")","v":0},null,{"$f":"IF(SUM($P$24+$P$26+$P$27+$P$28)=0,\"\",IF(P24>=4,3,IF(P24=3,2,IF(P24<=2,1,\"\"))))","v":1}]
[null,"Column Labels",null,null,null,null,null,null,null,null,null,null," Observation",1,{"$f":"$M25","v":" Observation"},{"$f":"$N25","v":1},{"$f":"IF(P25>=4,P25,\"\")","v":""},{"$f":"IF(P25=3,P25,\"\")","v":""},{"$f":"IF(P25<=2,P25,\"\")","v":1},null,{"$f":"IF(SUM($P$24+$P$26+$P$27+$P$28)=0,\"\",IF(P25>=4,3,IF(P25=3,2,IF(P25<=2,1,\"\"))))","v":1}]
[" Topics","Phoebe",null,null,null,null,null,null,null,null,null,null," Reflection",0," Reflection",0,{"$f":"IF(P26>=4,P26,\"\")","v":""},{"$f":"IF(P26=3,P26,\"\")","v":""},{"$f":"IF(P26<=2,P26,\"\")","v":0},null,{"$f":"IF(SUM($P$24+$P$26+$P$27+$P$28)=0,\"\",IF(P26>=4,3,IF(P26=3,2,IF(P26<=2,1,\"\"))))","v":1}]
[" Coaching",1,null,null,null,null,null,null,null,null,null,null,"Yes/No ",0,"Yes/No ",0,{"$f":"IF(P27>=3,P27,\"\")","v":""},{"$f":"IF(P27=2,P27,\"\")","v":""},{"$f":"IF(P27<=1,P27,\"\")","v":0},null,1]
[" Teaming",0,null,null,null,null,null,null,null,null,null,null," Feedback",1," Feedback",1,{"$f":"IF(P28>=4,P28,\"\")","v":""},{"$f":"IF(P28=3,P28,\"\")","v":""},{"$f":"IF(P28<=2,P28,\"\")","v":1},null,1]
[" Resource-Based",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U24:U28)","v":5}]
[" NEBP",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F",{"$f":"IF(U29=15,1,\"\")","v":""}]
[" NLEP",0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$29=0,\"\",IF($U$30=1, \"FIDELITY\",IF($U$32=1,\"NO FIDELITY\",IF($U$31=1,\"APPROACHING FIDELITY\"))))","v":"NO FIDELITY"},null,null,null,"AF",{"$f":"IF(AND(U29<15,U29>9),1,\"\")","v":""}]
[" Other",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NF",{"$f":"IF($U$29<=9,1,\"\")","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" Comparison"," Joint Planning"," Observation",null,null,null,null,null,null,null,null,null,"Row Labels"," Joint Planning"," Observation"," Reflection","Feedback","Sum of OF_JP",null,null,null,null,null,null,"Column Labels"]
[null,0,0,null,"Joint Planning","Observation",null,null,null,null,null,null,null,0,0,0,0,1,null,null,null,null,null,"Values",null,"00:00:00","2018-01-15","2018-02-15","2018-03-15","2018-05-15","2021-04-15"]
["00:00:00",0,0,{"$f":"IF(ISBLANK(A44),\"\",A44)","v":"00:00:00"},{"$f":"IF(ISBLANK(B44),\"\",B44)","v":0},{"$f":"IF(ISBLANK(C44),\"\",C44)","v":0},null,null,null,null,null,null,"00:00:00",0,0,0,0,1,null,null,null,null,null," Awareness",0,0,0,0,0,0,0]
["2018-01-15",0,0,{"$f":"IF(ISBLANK(A45),\"\",A45)","v":"2018-01-15"},{"$f":"IF(ISBLANK(B45),\"\",B45)","v":0},{"$f":"IF(ISBLANK(C45),\"\",C45)","v":0},null,null,null,null,null,null,"2018-01-15",0,0,0,0,1,null,null,null,null,null," Analysis",0,0,0,0,0,0,0]
["2018-02-15",0,1,"2018-02-15",0,1,null,null,null,null,null,null,"2018-02-15",0,1,0,1,1,null,null,null,null,null," Alternatives",0,0,0,0,0,0,0]
["2018-03-15",0,0,"2018-03-15",0,0,null,null,null,null,null,null,"2018-03-15",0,0,0,0,1,null,null,null,null,null," Action",0,0,0,0,0,0,0]
["2018-05-15",0,0,"2018-05-15",0,0,null,null,null,null,null,null,"2018-05-15",0,0,0,0,1]
["2021-04-15",0,0,"2021-04-15",0,0,null,null,null,null,null,null,"2021-04-15",0,0,0,0,1]
[null,null,null,"","",""]
[null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X43","v":"Values"},{"$f":"IF(Y43=\"\",\"\",Y43)","v":""},{"$f":"IF(Z43=\"\",\"\",Z43)","v":"00:00:00"},"2018-01-15","2018-02-15","2018-03-15","2018-05-15","2021-04-15","",""]
[null,null,null,"","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X44","v":" Awareness"},{"$f":"IF($Y$43=\"\",\"\",Y44)","v":""},{"$f":"IF($Z$43=\"\",\"\",Z44)","v":0},{"$f":"IF($AA$43=\"\",\"\",AA44)","v":0},{"$f":"IF($AB$43=\"\",\"\",AB44)","v":0},{"$f":"IF($AC$43=\"\",\"\",AC44)","v":0},{"$f":"IF($AD$43=\"\",\"\",AD44)","v":0},{"$f":"IF($AE$43=\"\",\"\",AE44)","v":0},{"$f":"IF($AF$43=\"\",\"\",AF44)","v":""},{"$f":"IF($AG$43=\"\",\"\",AG44)","v":""}]
[null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X45","v":" Analysis"},{"$f":"IF($Y$43=\"\",\"\",Y45)","v":""},{"$f":"IF($Z$43=\"\",\"\",Z45)","v":0},{"$f":"IF($AA$43=\"\",\"\",AA45)","v":0},{"$f":"IF($AB$43=\"\",\"\",AB45)","v":0},{"$f":"IF($AC$43=\"\",\"\",AC45)","v":0},{"$f":"IF($AD$43=\"\",\"\",AD45)","v":0},{"$f":"IF($AE$43=\"\",\"\",AE45)","v":0},{"$f":"IF($AF$43=\"\",\"\",AF45)","v":""},{"$f":"IF($AG$43=\"\",\"\",AG45)","v":""}]
[null,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X46","v":" Alternatives"},"",0,0,0,0,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,{"$f":"X47","v":" Action"},"",0,0,0,0,0,0,"",""]

{"sheet":"Data Validation (FIPP Use Only)","index":4,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["DROP DOWN LISTS"]
["Yes/No/NA","Column1","Discipline","Interaction_Type","Observation","YN_Type","Informative","Column1",null,"Version"," Version 4.1"]
[1,1,null,"IP - Individual Parent","Live","P/A","A","MC"]
[0,2,"Unknown","IC - Individual Coach","Log","C-E","I","C"]
["N/A",3,"Hearing Specialist","GC - Group Coach","Video"]
[null,4,"OT","PIC - Phone Individual Coach"]
["C",5,"Psychologist","PGC - Phone Group Coach"]
["MC",6,"PT"]
[null,7,"RD"]
[null,8,"RN"]
[null,9,"Service Coordinator"]
[null,10,"SLP"]
[null,11,"Social Worker"]
[null,12,"Special Instructor"]
[null,13,"Supervisor"]
[null,14,"Other"]
[]
[null,null,"Interaction Abbreviation"]
["Log#1",null,{"$f":"IF('CL#1'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#1'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#1'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#1'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#1'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":"IC"}]
["Log#2",null,{"$f":"IF('CL#2'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#2'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#2'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#2'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#2'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":"IP"}]
["Log#3",null,{"$f":"IF('CL#3'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#3'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#3'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#3'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#3'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":"IC"}]
["Log#4",null,{"$f":"IF('CL#4'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#4'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#4'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#4'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#4'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":"IC"}]
["Log#5",null,{"$f":"IF('CL#5'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#5'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#5'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#5'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#5'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":"IC"}]
["Log#6",null,{"$f":"IF('CL#6'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#6'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#6'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#6'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#6'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":""}]
["Log#7",null,{"$f":"IF('CL#7'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#7'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#7'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#7'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#7'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":""}]
["Log#8",null,{"$f":"IF('CL#8'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#8'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#8'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#8'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#8'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":""}]
["Log#9",null,{"$f":"IF('CL#9'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#9'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#9'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#9'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#9'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":""}]
["Log#10",null,{"$f":"IF('CL#10'!$R$4='Data Validation (FIPP Use Only)'!$D$3, \"IP\", IF('CL#10'!$R$4='Data Validation (FIPP Use Only)'!$D$4, \"IC\", IF('CL#10'!$R$4='Data Validation (FIPP Use Only)'!$D$5, \"GC\", IF('CL#10'!$R$4='Data Validation (FIPP Use Only)'!$D$6, \"PIC\", IF('CL#10'!$R$4='Data Validation (FIPP Use Only)'!$D$7, \"PGC\", \"\")))))","v":""}]
[null,null,"COACHING","TEAMING","R-B","NEBP","NLEP","OTHER","Coaching","Teaming","RB","NEBP","NLEP","Other"]
["CL#1",null,true,null,false,null,true,null,{"$f":"IF(ISBLANK(C30),\"\",IF(C30=TRUE, 1,0))","v":1},{"$f":"IF(ISBLANK(D30),\"\",IF(D30=TRUE, 1,0))","v":""},0,"",1,""]
["CL#2",null,true,null,null,null,null,true,{"$f":"IF(ISBLANK(C31),\"\",IF(C31=TRUE, 1,0))","v":1},{"$f":"IF(ISBLANK(D31),\"\",IF(D31=TRUE, 1,0))","v":""},{"$f":"IF(ISBLANK(E31),\"\",IF(E31=TRUE, 1,0))","v":""},{"$f":"IF(ISBLANK(F31),\"\",IF(F31=TRUE, 1,0))","v":""},{"$f":"IF(ISBLANK(G31),\"\",IF(G31=TRUE, 1,0))","v":""},{"$f":"IF(ISBLANK(H31),\"\",IF(H31=TRUE, 1,0))","v":1}]
["CL#3",null,true,null,true,null,null,null,1,"",1,"","",""]
["CL#4",null,true,null,null,null,true,null,1,"","","",1,""]
["CL#5",null,true,null,null,null,null,null,1,"","","","",""]
["CL#6",null,null,null,null,null,null,null,"","","","","",""]
["CL#7",null,null,null,null,null,null,null,"","","","","",""]
["CL#8",null,null,null,null,null,null,null,"","","","","",""]
["CL#9",null,null,null,null,null,null,null,"","","","","",""]
["CL#10"]

{"sheet":"Transition data table","index":5,"n_rows":10,"n_cols":47,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Worksheet","State","Team","Name","Discipline","Fidelity Coach","Date","Length of Visit","# Pages","Type of Interaction","Observation","Joint Plan","Awareness","Analysis","Alternatives","Action","P/A","C-E","(I) Informative-Accurate","(I) Informative-Inaccurate","(D) Directive","(E) Evaluative","(A) Affirmative","Total Reflection","%AW","%AN","%AL","%AC","R TOTAL-PA","% C-E Y/N","Total Feedback","%I-A","%I-A2","%D","%E","%A","Ob F","JP F","RF R","Y/N F","FB F","Coaching","Teaming","R-B","NEBP","NLEP","OTHER"]
["CL#1",{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!\")),\"\",INDIRECT(\"'\"&$A2&\"'!$c$1\"))","v":"NC"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!\")),\"\",INDIRECT(\"'\"&$A2&\"'!$C$2\"))","v":"Region 1"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!\")),\"\",INDIRECT(\"'\"&$A2&\"'!$C$3\"))","v":"Phoebe"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!\")),\"\",INDIRECT(\"'\"&$A2&\"'!$h$3\"))","v":"Supervisor"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!\")),\"\",INDIRECT(\"'\"&$A2&\"'!$C$5\"))","v":"Sarah"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!$R$1\")),\"\",INDIRECT(\"'\"&$A2&\"'!$R$1\"))","v":43115},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&A2&\"'!$R$2\")),\"\",INDIRECT(\"'\"&A2&\"'!$R$3\")-INDIRECT(\"'\"&A2&\"'!$R$2\"))","v":"00:30:00"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!$I$1\")),\"\",INDIRECT(\"'\"&$A2&\"'!$I$1\"))","v":""},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!$r$4\")),\"\",INDIRECT(\"'\"&$A2&\"'!$r$4\"))","v":"IC - Individual Coach"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A2&\"'!$j$5\")),\"\",INDIRECT(\"'\"&$A2&\"'!$j$5\"))","v":"Log"},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$l$15:$q$350\"))=0,\"\",SUM(INDIRECT(\"'\"&$A2&\"'!$k$15:$k$350\")))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$l$15:$l$350\"),\"1\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$l$15:$l$350\"),\"2\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$l$15:$l$350\"),\"3\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$l$15:$l$350\"),\"4\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$M$15:$M$350\"),\"P/A\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$M$15:$M$350\"),\"C-E\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$N$15:$N$350\"),\"A\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$N$15:$N$350\"),\"I\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$O$15:$O$350\"),\"1\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$P$15:$P$350\"),\"1\"))","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A2&\"'!$Q$15:$Q$350\"),\"1\"))","v":""},{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A2&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C30=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!D30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D30=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E30=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!F30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F30=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G30=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!H30=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H30=\"TRUE\",1,0))","v":""}]
["CL#2",{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!\")),\"\",INDIRECT(\"'\"&$A3&\"'!$c$1\"))","v":"NC"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!\")),\"\",INDIRECT(\"'\"&$A3&\"'!$C$2\"))","v":"Region 1"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!\")),\"\",INDIRECT(\"'\"&$A3&\"'!$C$3\"))","v":"Phoebe"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!\")),\"\",INDIRECT(\"'\"&$A3&\"'!$h$3\"))","v":"Supervisor"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!\")),\"\",INDIRECT(\"'\"&$A3&\"'!$C$5\"))","v":"Sarah"},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&$A3&\"'!$R$1\")),\"\",INDIRECT(\"'\"&$A3&\"'!$R$1\"))","v":43146},{"$f":"IF(ISBLANK(INDIRECT(\"'\"&A3&\"'!$R$2\")),\"\",INDIRECT(\"'\"&A3&\"'!$R$3\")-INDIRECT(\"'\"&A3&\"'!$R$2\"))","v":"01:05:00"},"","IP - Individual Parent","Log","","","","","","","","","","","",{"$f":"IF(SUM(INDIRECT(\"'\"&$A3&\"'!$L$15:$Q$350\"))=0,\"\",COUNTIF(INDIRECT(\"'\"&$A3&\"'!$Q$15:$Q$350\"),\"1\"))","v":""},{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A3&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C31=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!D31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D31=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E31=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F31=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G31=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H31=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H31=\"TRUE\",1,0))","v":0}]
["CL#3","NC","Region 1","Phoebe","Supervisor","Sarah",43174,"00:45:00","","IC - Individual Coach","Log","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A4&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C32=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!D32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D32=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E32=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!F32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F32=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G32=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H32=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H32=\"TRUE\",1,0))","v":""}]
["CL#4","NC","Region 1","Phoebe","Supervisor","Sarah",44301,"00:25:00","","IC - Individual Coach","Log","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A5&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C33=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!D33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D33=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E33=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F33=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G33=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!H33=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H33=\"TRUE\",1,0))","v":""}]
["CL#5","NC","Region 1","Phoebe","Supervisor","Sarah",43235,"00:25:00","","IC - Individual Coach","Log","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A6&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C34=\"TRUE\",1,0))","v":0},{"$f":"IF('Data Validation (FIPP Use Only)'!D34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D34=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E34=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F34=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G34=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H34=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H34=\"TRUE\",1,0))","v":""}]
["CL#6","NC","Region 1","Phoebe","Supervisor","Sarah","","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A7&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C35=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!D35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D35=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E35=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F35=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G35=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H35=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H35=\"TRUE\",1,0))","v":""}]
["CL#7","NC","Region 1","Phoebe","Supervisor","Sarah","","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A8&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C36=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!D36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D36=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E36=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F36=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G36=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H36=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H36=\"TRUE\",1,0))","v":""}]
["CL#8","NC","Region 1","Phoebe","Supervisor","Sarah","","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A9&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C37=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!D37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D37=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E37=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F37=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G37=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H37=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H37=\"TRUE\",1,0))","v":""}]
["CL#9","NC","Region 1","Phoebe","Supervisor","Sarah","","","","","","","","","","","","","","","","","",{"$f":"IF(SUM(Table5[[#This Row],[Awareness]:[Action]])=0,\"\",SUM(Table5[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[Awareness]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Analysis]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Alternatives]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Action]]/Table5[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[Total Reflection]]-Table5[[#This Row],[P/A]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[C-E]]/Table5[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]])=0,\"\",SUM(Table5[[#This Row],[(I) Informative-Accurate]:[(A) Affirmative]]))","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Accurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(I) Informative-Inaccurate]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(D) Directive]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(E) Evaluative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(Table5[[#This Row],[(A) Affirmative]]/Table5[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(SUM(INDIRECT(\"'\"&$A10&\"'!$L$15:$Q$350\"))=0,\"\",IF(OR(Table5[[#This Row],[Observation]]=\"LOG\",Table5[[#This Row],[Observation]]=\"LIVE\",Table5[[#This Row],[Observation]]=\"VIDEO\"),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Joint Plan]]=\"\",\"\",IF(Table5[[#This Row],[Joint Plan]]=0,0,1))","v":""},{"$f":"IF(Table5[[#This Row],[Total Reflection]]=\"\",\"\",IF(AND(Table5[[#This Row],[%AW]]<0.51,Table5[[#This Row],[%AN]]>0.195,Table5[[#This Row],[%AL]]>0.0445,Table5[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"IF(Table5[[#This Row],[R TOTAL-PA]]=\"\", \"\",IF(Table5[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"IF(Table5[[#This Row],[Total Feedback]]=0,\"\",IF(OR(Table5[[#This Row],[(D) Directive]]=0,Table5[[#This Row],[(I) Informative-Inaccurate]]=0),1,\"\"))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!C38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!C38=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!D38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!D38=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!E38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!E38=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!F38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!F38=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!G38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!G38=\"TRUE\",1,0))","v":""},{"$f":"IF('Data Validation (FIPP Use Only)'!H38=\"\",\"\",IF('Data Validation (FIPP Use Only)'!H38=\"TRUE\",1,0))","v":""}]

{"sheet":"Data Table","index":6,"n_rows":11,"n_cols":58,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["State","Team","Name","Discipline","Log #","Log Count","Date","Log # of Pages","Type of Interaction","Joint Plan","Observation","Observation Fidelity","Awareness","Analysis","Alternatives","Action","Total Reflection","%AW","%AN","%AL","%AC","Reflection Fidelity","P/A","R TOTAL-PA","C-E","% C-E Y/N","Y/N F","I-A","I-I","D","E","A","Total Feedback","%I-A","%I-I","%D","%E","%A","Feedback Fidelity","Coaching","Teaming","Resource-Based","NEBP","NLEP","Other","Helper","JP","AW","AN","AL","AC","P/A2","C-E2","I-A2","I-I2","D2","E2","A2"]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A8)","v":1},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B8","v":"2018-01-15"},{"$f":"'Coaching Log Summary'!C8","v":""},{"$f":"'Coaching Log Summary'!D8","v":"IC"},{"$f":"'Coaching Log Summary'!E8","v":""},{"$f":"'Coaching Log Summary'!F8","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G8","v":""},{"$f":"'Coaching Log Summary'!H8","v":""},{"$f":"'Coaching Log Summary'!I8","v":""},{"$f":"'Coaching Log Summary'!J8","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K8","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L8","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M8","v":""},{"$f":"'Coaching Log Summary'!N8","v":""},{"$f":"'Coaching Log Summary'!O8","v":""},{"$f":"'Coaching Log Summary'!P8","v":""},{"$f":"'Coaching Log Summary'!Q8","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R8","v":""},{"$f":"'Coaching Log Summary'!S8","v":""},{"$f":"'Coaching Log Summary'!T8","v":""},{"$f":"'Coaching Log Summary'!U8","v":""},{"$f":"'Coaching Log Summary'!V8","v":""},{"$f":"'Coaching Log Summary'!W8","v":""},{"$f":"SUM('CL#1'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#1'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#1'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#1'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#1'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#1'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#1'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#1'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#1'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#1'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#1'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#1'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#1'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A9)","v":2},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B9","v":"2018-02-15"},{"$f":"'Coaching Log Summary'!C9","v":""},{"$f":"'Coaching Log Summary'!D9","v":"IP"},{"$f":"'Coaching Log Summary'!E9","v":""},{"$f":"'Coaching Log Summary'!F9","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G9","v":""},{"$f":"'Coaching Log Summary'!H9","v":""},{"$f":"'Coaching Log Summary'!I9","v":""},{"$f":"'Coaching Log Summary'!J9","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K9","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L9","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M9","v":""},{"$f":"'Coaching Log Summary'!N9","v":""},{"$f":"'Coaching Log Summary'!O9","v":""},{"$f":"'Coaching Log Summary'!P9","v":""},{"$f":"'Coaching Log Summary'!Q9","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R9","v":""},{"$f":"'Coaching Log Summary'!S9","v":""},{"$f":"'Coaching Log Summary'!T9","v":""},{"$f":"'Coaching Log Summary'!U9","v":""},{"$f":"'Coaching Log Summary'!V9","v":""},{"$f":"'Coaching Log Summary'!W9","v":""},{"$f":"SUM('CL#2'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#2'!$D$15:$D$342,\"1\")","v":5},{"$f":"COUNTIF('CL#2'!$E$15:$E$342,\"1\")","v":2},{"$f":"COUNTIF('CL#2'!$E$15:$E$342,\"2\")","v":11},{"$f":"COUNTIF('CL#2'!$E$15:$E$342,\"3\")","v":4},{"$f":"COUNTIF('CL#2'!$E$15:$E$342,\"4\")","v":4},{"$f":"COUNTIF('CL#2'!$F$15:$F$342, \"P/A\")","v":0},{"$f":"COUNTIF('CL#2'!$F$15:$F$342, \"C-E\")","v":0},{"$f":"COUNTIF('CL#2'!$G$15:$G$342,\"A\")","v":2},{"$f":"COUNTIF('CL#2'!$G$15:$G$342,\"I\")","v":0},{"$f":"COUNTIF('CL#2'!H$15:H$342, \"1\")","v":0},{"$f":"COUNTIF('CL#2'!I$15:I$342, \"1\")","v":2},{"$f":"COUNTIF('CL#2'!J$15:J$342, \"1\")","v":7}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A10)","v":3},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B10","v":"2018-03-15"},{"$f":"'Coaching Log Summary'!C10","v":""},{"$f":"'Coaching Log Summary'!D10","v":"IC"},{"$f":"'Coaching Log Summary'!E10","v":""},{"$f":"'Coaching Log Summary'!F10","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G10","v":""},{"$f":"'Coaching Log Summary'!H10","v":""},{"$f":"'Coaching Log Summary'!I10","v":""},{"$f":"'Coaching Log Summary'!J10","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K10","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L10","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M10","v":""},{"$f":"'Coaching Log Summary'!N10","v":""},{"$f":"'Coaching Log Summary'!O10","v":""},{"$f":"'Coaching Log Summary'!P10","v":""},{"$f":"'Coaching Log Summary'!Q10","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R10","v":""},{"$f":"'Coaching Log Summary'!S10","v":""},{"$f":"'Coaching Log Summary'!T10","v":""},{"$f":"'Coaching Log Summary'!U10","v":""},{"$f":"'Coaching Log Summary'!V10","v":""},{"$f":"'Coaching Log Summary'!W10","v":""},{"$f":"SUM('CL#3'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#3'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#3'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#3'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#3'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#3'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#3'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#3'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#3'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#3'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#3'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#3'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#3'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A11)","v":4},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B11","v":"2021-04-15"},{"$f":"'Coaching Log Summary'!C11","v":""},{"$f":"'Coaching Log Summary'!D11","v":"IC"},{"$f":"'Coaching Log Summary'!E11","v":""},{"$f":"'Coaching Log Summary'!F11","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G11","v":""},{"$f":"'Coaching Log Summary'!H11","v":""},{"$f":"'Coaching Log Summary'!I11","v":""},{"$f":"'Coaching Log Summary'!J11","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K11","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L11","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M11","v":""},{"$f":"'Coaching Log Summary'!N11","v":""},{"$f":"'Coaching Log Summary'!O11","v":""},{"$f":"'Coaching Log Summary'!P11","v":""},{"$f":"'Coaching Log Summary'!Q11","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R11","v":""},{"$f":"'Coaching Log Summary'!S11","v":""},{"$f":"'Coaching Log Summary'!T11","v":""},{"$f":"'Coaching Log Summary'!U11","v":""},{"$f":"'Coaching Log Summary'!V11","v":""},{"$f":"'Coaching Log Summary'!W11","v":""},{"$f":"SUM('CL#4'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#4'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#4'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#4'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#4'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#4'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#4'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#4'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#4'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#4'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#4'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#4'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#4'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A12)","v":5},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B12","v":"2018-05-15"},{"$f":"'Coaching Log Summary'!C12","v":""},{"$f":"'Coaching Log Summary'!D12","v":"IC"},{"$f":"'Coaching Log Summary'!E12","v":""},{"$f":"'Coaching Log Summary'!F12","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G12","v":""},{"$f":"'Coaching Log Summary'!H12","v":""},{"$f":"'Coaching Log Summary'!I12","v":""},{"$f":"'Coaching Log Summary'!J12","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K12","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L12","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M12","v":""},{"$f":"'Coaching Log Summary'!N12","v":""},{"$f":"'Coaching Log Summary'!O12","v":""},{"$f":"'Coaching Log Summary'!P12","v":""},{"$f":"'Coaching Log Summary'!Q12","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R12","v":""},{"$f":"'Coaching Log Summary'!S12","v":""},{"$f":"'Coaching Log Summary'!T12","v":""},{"$f":"'Coaching Log Summary'!U12","v":""},{"$f":"'Coaching Log Summary'!V12","v":""},{"$f":"'Coaching Log Summary'!W12","v":""},{"$f":"SUM('CL#5'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#5'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#5'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#5'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#5'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#5'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#5'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#5'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#5'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#5'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#5'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#5'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#5'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A13)","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":""},{"$f":"'Coaching Log Summary'!B13","v":""},{"$f":"'Coaching Log Summary'!C13","v":""},{"$f":"'Coaching Log Summary'!D13","v":""},{"$f":"'Coaching Log Summary'!E13","v":""},{"$f":"'Coaching Log Summary'!F13","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G13","v":""},{"$f":"'Coaching Log Summary'!H13","v":""},{"$f":"'Coaching Log Summary'!I13","v":""},{"$f":"'Coaching Log Summary'!J13","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":0},{"$f":"'Coaching Log Summary'!K13","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L13","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M13","v":""},{"$f":"'Coaching Log Summary'!N13","v":""},{"$f":"'Coaching Log Summary'!O13","v":""},{"$f":"'Coaching Log Summary'!P13","v":""},{"$f":"'Coaching Log Summary'!Q13","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R13","v":""},{"$f":"'Coaching Log Summary'!S13","v":""},{"$f":"'Coaching Log Summary'!T13","v":""},{"$f":"'Coaching Log Summary'!U13","v":""},{"$f":"'Coaching Log Summary'!V13","v":""},{"$f":"'Coaching Log Summary'!W13","v":""},{"$f":"SUM('CL#6'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#6'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#6'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#6'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#6'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#6'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#6'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#6'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#6'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#6'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#6'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#6'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#6'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A14)","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":""},{"$f":"'Coaching Log Summary'!B14","v":""},{"$f":"'Coaching Log Summary'!C14","v":""},{"$f":"'Coaching Log Summary'!D14","v":""},{"$f":"'Coaching Log Summary'!E14","v":""},{"$f":"'Coaching Log Summary'!F14","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G14","v":""},{"$f":"'Coaching Log Summary'!H14","v":""},{"$f":"'Coaching Log Summary'!I14","v":""},{"$f":"'Coaching Log Summary'!J14","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":0},{"$f":"'Coaching Log Summary'!K14","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L14","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M14","v":""},{"$f":"'Coaching Log Summary'!N14","v":""},{"$f":"'Coaching Log Summary'!O14","v":""},{"$f":"'Coaching Log Summary'!P14","v":""},{"$f":"'Coaching Log Summary'!Q14","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R14","v":""},{"$f":"'Coaching Log Summary'!S14","v":""},{"$f":"'Coaching Log Summary'!T14","v":""},{"$f":"'Coaching Log Summary'!U14","v":""},{"$f":"'Coaching Log Summary'!V14","v":""},{"$f":"'Coaching Log Summary'!W14","v":""},{"$f":"SUM('CL#7'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#7'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#7'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#7'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#7'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#7'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#7'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#7'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#7'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#7'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#7'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#7'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#7'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A15)","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":""},{"$f":"'Coaching Log Summary'!B15","v":""},{"$f":"'Coaching Log Summary'!C15","v":""},{"$f":"'Coaching Log Summary'!D15","v":""},{"$f":"'Coaching Log Summary'!E15","v":""},{"$f":"'Coaching Log Summary'!F15","v":""},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G15","v":""},{"$f":"'Coaching Log Summary'!H15","v":""},{"$f":"'Coaching Log Summary'!I15","v":""},{"$f":"'Coaching Log Summary'!J15","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":0},{"$f":"'Coaching Log Summary'!K15","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":""},{"$f":"'Coaching Log Summary'!L15","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":0},{"$f":"'Coaching Log Summary'!M15","v":""},{"$f":"'Coaching Log Summary'!N15","v":""},{"$f":"'Coaching Log Summary'!O15","v":""},{"$f":"'Coaching Log Summary'!P15","v":""},{"$f":"'Coaching Log Summary'!Q15","v":""},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R15","v":""},{"$f":"'Coaching Log Summary'!S15","v":""},{"$f":"'Coaching Log Summary'!T15","v":""},{"$f":"'Coaching Log Summary'!U15","v":""},{"$f":"'Coaching Log Summary'!V15","v":""},{"$f":"'Coaching Log Summary'!W15","v":""},{"$f":"SUM('CL#8'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#8'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#8'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#8'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#8'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#8'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#8'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#8'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#8'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#8'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#8'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#8'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#8'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A16)","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B16","v":"00:00:00"},{"$f":"'Coaching Log Summary'!C16","v":0},null,null,{"$f":"'Coaching Log Summary'!F16","v":"O"},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G16","v":0},{"$f":"'Coaching Log Summary'!H16","v":0},{"$f":"'Coaching Log Summary'!I16","v":0},{"$f":"'Coaching Log Summary'!J16","v":0},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K16","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":0},{"$f":"'Coaching Log Summary'!L16","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"'Coaching Log Summary'!M16","v":0},{"$f":"'Coaching Log Summary'!N16","v":0},{"$f":"'Coaching Log Summary'!O16","v":0},{"$f":"'Coaching Log Summary'!P16","v":0},{"$f":"'Coaching Log Summary'!Q16","v":0},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R16","v":0},{"$f":"'Coaching Log Summary'!S16","v":0},{"$f":"'Coaching Log Summary'!T16","v":0},{"$f":"'Coaching Log Summary'!U16","v":0},{"$f":"'Coaching Log Summary'!V16","v":0},{"$f":"'Coaching Log Summary'!W16","v":0},{"$f":"SUM('CL#9'!$K$15:$Q$3409)","v":0},{"$f":"(COUNTIF('CL#9'!$D$15:$D$340,\"1\"))","v":0},{"$f":"COUNTIF('CL#9'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#9'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#9'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#9'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#9'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#9'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#9'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#9'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#9'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#9'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#9'!J$15:J$340, \"1\")","v":0}]
[{"$f":"'Coaching Log Summary'!$C$1","v":"NC"},{"$f":"'Coaching Log Summary'!$G$1","v":"Region 1"},{"$f":"'Coaching Log Summary'!$E$2","v":"Phoebe"},{"$f":"'Coaching Log Summary'!$Q$2","v":"Supervisor"},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\",'Coaching Log Summary'!A17)","v":""},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\",\"\", IF(IndData_Table[[#This Row],[Log '#]]>0,1,\"\"))","v":1},{"$f":"'Coaching Log Summary'!B17","v":"00:00:00"},{"$f":"'Coaching Log Summary'!C17","v":0},{"$f":"'Coaching Log Summary'!D17","v":0},{"$f":"'Coaching Log Summary'!E17","v":0},{"$f":"'Coaching Log Summary'!F17","v":"O"},{"$f":"IF(OR(IndData_Table[[#This Row],[Observation]]=\"LOG\",IndData_Table[[#This Row],[Observation]]=\"LIVE\",IndData_Table[[#This Row],[Observation]]=\"VIDEO\"),1,0)","v":0},{"$f":"'Coaching Log Summary'!G17","v":0},{"$f":"'Coaching Log Summary'!H17","v":0},{"$f":"'Coaching Log Summary'!I17","v":0},{"$f":"'Coaching Log Summary'!J17","v":0},{"$f":"IF(IndData_Table[[#This Row],[Date]]=\"\", \"\", SUM(IndData_Table[[#This Row],[Awareness]:[Action]]))","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Awareness]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Analysis]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Alternatives]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[Action]]/IndData_Table[[#This Row],[Total Reflection]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Reflection]]=0,\"\",IF(AND(IndData_Table[[#This Row],[%AW]]<0.51,IndData_Table[[#This Row],[%AN]]>0.195,IndData_Table[[#This Row],[%AL]]>0.0445,IndData_Table[[#This Row],[%AC]]>0.0445),1,0))","v":""},{"$f":"'Coaching Log Summary'!K17","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[Total Reflection]]-IndData_Table[[#This Row],[P/A]],\"\")","v":0},{"$f":"'Coaching Log Summary'!L17","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[C-E]]/IndData_Table[[#This Row],[R TOTAL-PA]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[R TOTAL-PA]]=0, \"\",IF(IndData_Table[[#This Row],[% C-E Y/N]]<0.20495,1,0))","v":""},{"$f":"'Coaching Log Summary'!M17","v":0},{"$f":"'Coaching Log Summary'!N17","v":0},{"$f":"'Coaching Log Summary'!O17","v":0},{"$f":"'Coaching Log Summary'!P17","v":0},{"$f":"'Coaching Log Summary'!Q17","v":0},{"$f":"SUM(IndData_Table[[#This Row],[I-A]:[A]])","v":0},{"$f":"IFERROR(IndData_Table[[#This Row],[I-A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[I-I]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[D]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[E]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IFERROR(IndData_Table[[#This Row],[A]]/IndData_Table[[#This Row],[Total Feedback]],\"\")","v":""},{"$f":"IF(IndData_Table[[#This Row],[Total Feedback]]=0,\"\",IF(OR(IndData_Table[[#This Row],[D]]>0,IndData_Table[[#This Row],[I-I]]>0),0,1))","v":""},{"$f":"'Coaching Log Summary'!R17","v":0},{"$f":"'Coaching Log Summary'!S17","v":0},{"$f":"'Coaching Log Summary'!T17","v":0},{"$f":"'Coaching Log Summary'!U17","v":0},{"$f":"'Coaching Log Summary'!V17","v":0},{"$f":"'Coaching Log Summary'!W17","v":0},{"$f":"SUM('CL#10'!$K$15:$Q$340)","v":0},{"$f":"COUNTIF('CL#10'!$D$15:$D$340,\"1\")","v":0},{"$f":"COUNTIF('CL#10'!$E$15:$E$340,\"1\")","v":0},{"$f":"COUNTIF('CL#10'!$E$15:$E$340,\"2\")","v":0},{"$f":"COUNTIF('CL#10'!$E$15:$E$340,\"3\")","v":0},{"$f":"COUNTIF('CL#10'!$E$15:$E$340,\"4\")","v":0},{"$f":"COUNTIF('CL#10'!$F$15:$F$340, \"P/A\")","v":0},{"$f":"COUNTIF('CL#10'!$F$15:$F$340, \"C-E\")","v":0},{"$f":"COUNTIF('CL#10'!$G$15:$G$340,\"A\")","v":0},{"$f":"COUNTIF('CL#10'!$G$15:$G$340,\"I\")","v":0},{"$f":"COUNTIF('CL#10'!H$15:H$340, \"1\")","v":0},{"$f":"COUNTIF('CL#10'!I$15:I$340, \"1\")","v":0},{"$f":"COUNTIF('CL#10'!J$15:J$340, \"1\")","v":0}]

{"sheet":"CL#1","index":7,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,"NC",null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:",null,null,null,null,"2018-01-15"]
["Team:",null,"Region 1",null,null,null,null,null,null,null,null,null,"Beginning Time:",null,null,null,null,"03:15:00"]
["MC:",null,"Phoebe",null,"Discipline:",null,null,"Supervisor",null,null,null,null,"Ending Time:",null,null,null,null,"03:45:00"]
["Coach:",null,"Jane",null,"Discipline:",null,null,"Special Instructor",null,null,null,null,"Interaction Type:",null,null,null,null,"IC - Individual Coach"]
["FC:",null,"Sarah",null,"Observation Type:",null,null,null,null,"Log",null,null,"Who was present?",null,null,null,null,"Pheobe and Jim"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":1},"MC","Hi. Thank you for meeting with  me today."]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":2},"MC","The last time we talked you indicated you were not yet comfortable with the capacity-building practices How are you doing with this now?"]
[3,"C","I feel a little better in attempting to use the steps, but I know it is still a work in process."]
[4,"MC","We had the capacity-building family support training a month or so ago. How was that helpful?"]
[5,"C","That training confirmed how we could focus on being intentional and using open-ended questions to keep the parent in the lead of the process. I think it's easier said than done. "]
[6,"MC","Great. I noticed that your visit with the Norton family gave you an opportunity to help them with housing. How did you use the capacity-building practices during that conversation?"]
[7,"C","I'm still shaky on what the step are, but they did already have a good idea of what their priority was, so I was focused helping them think about their options once they are evicted in three weeks. I know this is a stressful time for them, so it is really hard to think about lots of options."]
[8,"MC","How did you help them brainstorm?"]
[9,"C","I guess I could have done a better job of that. I asked them what they were going to do and they were planning to look into some short-term shelters, so we moved forward making a plan for how that transition would look for them."]
[10,"MC","What do you remember about how brainstorming is supposed to look using a capacity-building approach?"]
[11,"C","Well, I know you are supposed to let the family brainstorm first so they don't build a dependence on you. I also remember that you are supposed to have more than one idea. I didn't feel like I could do that here because the situation is so stressful and I don't think the family has any other options."]
[12,"MC","How did you come to the conclusion that the family doesn't have any other options?"]
[13,"C","Well because I know they would not have suggested the shelter if there was anything else they could do."]
[14,"MC","What do you rememiber about our conversation during the training about the impact of toxic stress or chronic stress on the decision-making process?"]
[15,"C","It puts some people in freeze mode and it's hard to made deliberate decisions. "]
[16,"MC","That's right. And the more a person lives in chronic stress, the more likely they are to build a habit of knee-jerk decisions rather than taking the time to systematically think through options and wiegh them. I think its possible that some parents have grown up in the stress that poverty causes and may have never learned a systematic decision-making process. "]
[17,"C","I just hate to ask them about other options only to find out that they don't have any and make them feel even more hopeless."]
[18,"MC","I can understand that. I can understand how that might feel risky to you as well, not knowing what to expect from the convrsation. What do you think about talking through what that process might be like for the family if we were to try to stick to the process we learned in the training?"]
[19,"C","I am open to talking about it."]
[20,"MC","OK. Let's say that the family shared with you that they plan to move to a shelter in a few weeks. What's something you could ask to help them identify other options?"]
[21,"C","I could ask, \"What other options have you thought about and looked into?\""]
[22,"MC","What if they say, \"none, so far.\""]
[23,"C","I don't know. This is what I was afriad of, that there are no other options."]
[24,"MC","Let's think about how to help the family think more specifically. In the training we learned about formal and informal options. What's a question you could ask about informal options?"]
[25,"C","I could ask, \"Who do you know that would be in a poition to help you with housing? Or I could be even more specific and ask them who they could stay with?"]
[26,"MC","Yep, what else?"]
[27,"C","I could ask if they have ever been in this position before and what did they do?"]
[28,"MC","Mm-huh"]
[29,"C","I could ask if they have any friends or family who have had housing problems and what they did?"]
[30,"MC","Right. Right. You don't know that any of those questions will result in more ideas or better ideas, so what do you think is the point of asking them?"]
[31,"C","Well, I don't know that they won't result in more idea. If they do, the family may have better options."]
[32,"MC","Sure. What else would be the benefit of asking those questions?"]
[33,"C","I'm not sure"]
[34,"MC","In the training we learned that we have to be systematic in how we help families obtain resources so that they can learn a systematic and useful process. Every time you decide not to use they systematic process, you are passing up an opportunity to teach the family the process."]
[35,"C","I see what you mean."]
[36,"MC","The other thing I think about is, what happens when the family comes to the end of their time at the shelter? That's not a long-term solution."]
[37,"C","I know, I thought about that. We are going to have to have the conversation anyway, I don't know why I put it off."]
[38,"MC","Why do you think you did put it off?"]
[39,"C","I was nervous."]
[40,"MC","OK, so let's figure out how to get past that nervousness so that you can be comfortable trying these strategies we learned about."]
[41,"C","I think you coming out ot observe me is a good way of holding me accountable. I need to think before I go out, how I am going to remember the steps and really try them with the family. I think practice will help my confidence."]
[42,"MC","Good point, so what will you commit to doing to help you move forward with these practices.? What's one managable step you can start with?"]
[43,"C","I think I need to be better about asking more than one brainstorming question and make this step more a part of my process with families."]
[44,"MC","What will it take to make you successful at that?"]
[45,"C","I think I need to brainstorm my own questions that I can use with families."]
[46,"MC","When do you plan to do that?"]
[47,"C","I have another visit this afternoon with a different family who is looking for reliable transportation. I can spend a few minutes before that visit preparing."]
[48,"MC","OK. What additional support do you need?"]
[49,"C","none until my next observation"]
[50,"MC","So, when do you want for us to schedule your next observation to see how you plan is working?"]
[51,"c","Can we do it next week?"]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B81), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B145), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B209), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B273), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#2","index":8,"n_rows":342,"n_cols":19,"rows_kept":342,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,13,12,16],[12,6,12,9],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:",null,null,null,null,"2018-02-15"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:",null,null,null,null,"01:10:00"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:",null,null,null,null,"02:15:00"]
["Coach:",null,"Jane",null,"Discipline:",null,null,"Service Coordinator",null,null,null,null,"Interaction Type:",null,null,null,null,"IP - Individual Parent"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,"Log",null,null,"Who was present?",null,null,null,null,"Phoebe and Joe"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":1},"MC","Hi. Thank you for meeting with  me today."]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":2},"MC","The last time we talked you indicated you were not yet comfortable with the capacity-building practices How are you doing with this now?",1,2]
[3,"C","I feel a little better in attempting to use the steps, but I know it is still a work in process."]
[4,"MC","We had the capacity-building family support training a month or so ago. How was that helpful?",null,2]
[5,"C","That training confirmed how we could focus on being intentional and using open-ended questions to keep the parent in the lead of the process. I think it's easier said than done. "]
[6,"MC","Great. I noticed that your visit with the Norton family gave you an opportunity to help them with housing. How did you use the capacity-building practices during that conversation?",null,2,null,null,null,1]
[7,"C","I'm still shaky on what the step are, but they did already have a good idea of what their priority was, so I was focused helping them think about their options once they are evicted in three weeks. I know this is a stressful time for them, so it is really hard to think about lots of options."]
[8,"MC","How did you help them brainstorm?",null,2]
[9,"C","I guess I could have done a better job of that. I asked them what they were going to do and they were planning to look into some short-term shelters, so we moved forward making a plan for how that transition would look for them."]
[10,"MC","What do you remember about how brainstorming is supposed to look using a capacity-building approach?",null,1]
[11,"C","Well, I know you are supposed to let the family brainstorm first so they don't build a dependence on you. I also remember that you are supposed to have more than one idea. I didn't feel like I could do that here because the situation is so stressful and I don't think the family has any other options."]
[12,"MC","How did you come to the conclusion that the family doesn't have any other options?",null,2]
[13,"C","Well because I know they would not have suggested the shelter if there was anything else they could do."]
[null,"MC","What do you rememiber about our conversation during the training about the impact of toxic stress or chronic stress on the decision-making process?",null,1]
[15,"C","It puts some people in freeze mode and it's hard to made deliberate decisions. "]
[16,"MC","That's right. And the more a person lives in chronic stress, the more likely they are to build a habit of knee-jerk decisions rather than taking the time to systematically think through options and wiegh them. I think its possible that some parents have grown up in the stress that poverty causes and may have never learned a systematic decision-making process. ",null,null,null,"A",null,1]
[17,"C","I just hate to ask them about other options only to find out that they don't have any and make them feel even more hopeless."]
[18,"MC","I can understand that. I can understand how that might feel risky to you as well, not knowing what to expect from the convrsation. What do you think about talking through what that process might be like for the family if we were to try to stick to the process we learned in the training?",null,2,null,null,null,null,1]
[19,"C","I am open to talking about it."]
[20,"MC","OK. Let's say that the family shared with you that they plan to move to a shelter in a few weeks. What's something you could ask to help them identify other options?",null,3]
[21,"C","I could ask, \"What other options have you thought about and looked into?\""]
[22,"MC","What if they say, \"none, so far.\"",null,3]
[23,"C","I don't know. This is what I was afriad of, that there are no other options."]
[24,"MC","Let's think about how to help the family think more specifically. In the training we learned about formal and informal options. What's a question you could ask about informal options?",null,3]
[25,"C","I could ask, \"Who do you know that would be in a poition to help you with housing? Or I could be even more specific and ask them who they could stay with?"]
[26,"MC","Yep, what else?",null,3,null,null,null,null,1]
[27,"C","I could ask if they have ever been in this position before and what did they do?"]
[28,"MC","Mm-huh",null,null,null,null,null,null,1]
[29,"C","I could ask if they have any friends or family who have had housing problems and what they did?"]
[30,"MC","Right. Right. You don't know that any of those questions will result in more ideas or better ideas, so what do you think is the point of asking them?",null,2,null,null,null,null,1]
[31,"C","Well, I don't know that they won't result in more idea. If they do, the family may have better options."]
[32,"MC","Sure. What else would be the benefit of asking those questions?",null,2,null,null,null,null,1]
[33,"C","I'm not sure"]
[34,"MC","In the training we learned that we have to be systematic in how we help families obtain resources so that they can learn a systematic and useful process. Every time you decide not to use they systematic process, you are passing up an opportunity to teach the family the process.",null,null,null,"A"]
[35,"C","I see what you mean."]
[36,"MC","The other thing I think about is, what happens when the family comes to the end of their time at the shelter? That's not a long-term solution."]
[37,"C","I know, I thought about that. We are going to have to have the conversation anyway, I don't know why I put it off."]
[38,"MC","Why do you think you did put it off?",null,2]
[39,"C","I was nervous."]
[40,"MC","OK, so let's figure out how to get past that nervousness so that you can be comfortable trying these strategies we learned about.",null,2,null,null,null,null,1]
[41,"C","I think you coming out ot observe me is a good way of holding me accountable. I need to think before I go out, how I am going to remember the steps and really try them with the family. I think practice will help my confidence."]
[42,"MC","Good point, so what will you commit to doing to help you move forward with these practices.? What's one managable step you can start with?",1,4,null,null,null,null,1]
[43,"C","I think I need to be better about asking more than one brainstorming question and make this step more a part of my process with families."]
[44,"MC","What will it take to make you successful at that?",null,2]
[45,"C","I think I need to brainstorm my own questions that I can use with families."]
[46,"MC","When do you plan to do that?",1,4]
[47,"C","I have another visit this afternoon with a different family who is looking for reliable transportation. I can spend a few minutes before that visit preparing."]
[48,"MC","OK. What additional support do you need?",1,4]
[49,"C","none until my next observation"]
[50,"MC","So, when do you want for us to schedule your next observation to see how you plan is working?",1,4]
[51,"c","Can we do it next week?"]
[52,"MC","Sure. "]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B82), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B146), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B210), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B274), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B341), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B342), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#3","index":9,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:",null,null,null,null,"2018-03-15"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:",null,null,null,null,"16:00:00"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:",null,null,null,null,"16:45:00"]
["Coach:",null,"Jim",null,"Discipline:",null,null,"Service Coordinator",null,null,null,null,"Interaction Type:",null,null,null,null,"IC - Individual Coach"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,"Log",null,null,"Who was present?",null,null,null,null,"Phoebe and Jim"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#4","index":10,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:",null,null,null,null,"2021-04-15"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:",null,null,null,null,"15:00:00"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:",null,null,null,null,"15:25:00"]
["Coach:",null,"GM",null,"Discipline:",null,null,"PT",null,null,null,null,"Interaction Type:",null,null,null,null,"IC - Individual Coach"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,"Log",null,null,"Who was present?",null,null,null,null,"Phoebe, GM"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#5","index":11,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:",null,null,null,null,"2018-05-15"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:",null,null,null,null,"14:35:00"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:",null,null,null,null,"15:00:00"]
["Coach:",null,"JP",null,"Discipline:",null,null,"PT",null,null,null,null,"Interaction Type:",null,null,null,null,"IC - Individual Coach"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,"Log",null,null,"Who was present?",null,null,null,null,"Pheobe, JP"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#6","index":12,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:"]
["Coach:",null,null,null,"Discipline:",null,null,null,null,null,null,null,"Interaction Type"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,null,null,null,"Who was present?"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#7","index":13,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:"]
["Coach:",null,null,null,"Discipline:",null,null,null,null,null,null,null,"Type of Interaction:"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,null,null,null,"Who was present?"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK(B25), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#8","index":14,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:"]
["Coach:",null,null,null,"Discipline:",null,null,null,null,null,null,null,"Interaction Type:"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,null,null,null,"Who was present?"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
["x",null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK(B25), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#9","index":15,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[2,7,2,11],[3,7,3,11],[4,9,4,11],[12,6,12,9],[12,13,12,16],[10,8,10,18],[10,6,10,7],[12,17,13,17],[7,2,7,17]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:"]
["Coach:",null,null,null,"Discipline:",null,null,null,null,null,null,null,"Type of Interaction:"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,null,null,null,"Who was present?"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
[null,null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]

{"sheet":"CL#10","index":16,"n_rows":340,"n_cols":19,"rows_kept":340,"cut":false,"hidden":false,"merged":[[12,6,12,9],[12,13,12,16],[12,17,13,17],[2,7,2,11],[3,7,3,11],[4,9,4,11],[7,2,7,17],[10,6,10,7],[10,8,10,18]]}
["State:",null,{"$f":"IF(ISBLANK('CL#1'!$C1), \"\", 'CL#1'!$C1)","v":"NC"},null,"# of Pages:",null,null,null,null,null,null,null,"Date of Interaction:"]
["Team:",null,{"$f":"IF(ISBLANK('CL#1'!$C2), \"\", 'CL#1'!$C2)","v":"Region 1"},null,null,null,null,null,null,null,null,null,"Beginning Time:"]
["MC:",null,{"$f":"IF(ISBLANK('CL#1'!$C3), \"\", 'CL#1'!$C3)","v":"Phoebe"},null,"Discipline:",null,null,{"$f":"IF(ISBLANK('CL#1'!$H$3),\"\",'CL#1'!$H$3)","v":"Supervisor"},null,null,null,null,"Ending Time:"]
["Coach:",null,null,null,"Discipline:",null,null,null,null,null,null,null,"Type of Interaction:"]
["FC:",null,{"$f":"IF(ISBLANK('CL#1'!$C5), \"\", 'CL#1'!$C5)","v":"Sarah"},null,"Observation Type:",null,null,null,null,null,null,null,"Who was present?"]
["Topic(s):"]
["x",null,"         Other:",null,null,"         "]
["Notes:"]
["x"]
["x"]
["Coaching Conversations/Observations\nMC=Master Coach      C=Coach(ee)        FC=Fidelity Coach",null,null,"CODING \nKEY",null,null,"🔑",null,"➊   ✔ P-Joint Planning     \n➋  # R-Reflection:  1-Awareness  2-Analysis  3-Alternatives  4-Action\n➌  ▼Y/N-Yes/No:   C-E-Closed-ended      P/A-Permission/Assumption  \n➍  Feedback: 🔽I-Informative:  A=Accurate or  I-Inaccurate ✔D-Directive ✔E-Evaluative ✔A-Affirmative"]
["TOOLS\nFreeze Codes          View Full Page         Spell  Check         Count Page #",null,null,"Master Coach Coding \n",null,null,null,null,null,null,"Fidelity Coach Coding\n(Fidelity Coach Use Only)",null,null,null,null,null,null,"Coach's Reflections/Review","Fidelity Coach Notes"]
[null,null,null,"P","R","Y/N","Feedback",null,null,null,"P","R","Y/N","Feedback",null,null,null,"Analysis of coaching process and promotion of parent's understanding and ability to promote child participation."]
["#","C/ MC","Transcript of Conversation","✔","#","▼","I▼","D","E","A","✔","#","▼","I▼","D","E","A"]
[{"$f":"IF(ISBLANK(B15), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B16), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B80), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B144), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B208), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B272), \"\", (ROW()-14))","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(ISBLANK(B336), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B337), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B338), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B339), \"\", (ROW()-14))","v":""}]
[{"$f":"IF(ISBLANK(B340), \"\", (ROW()-14))","v":""}]