{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["START HERE","Evaluator Score","Indicator Charts"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"START HERE","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9]]}
[]
[]
[]
[]
[]
["Equity Gap Analysis Administrator Tool Directions"]
["Tool Explanation"]
["This tool allows you to compare performance measures for equity indicators between evaluators and compare performance across equity indicators. Additionally, this tool helps you to visually display your data.  "]
["Directions"]
["If you haven't already done so, make sure to enable all content, which can be done by clicking on the \"Enable Content\" button in the yellow bar above. If you don't see a bar, then all content has been enabled. \n \nIn the \"Evaluator Score\" tab, you will add each evaluator's name and total scores from their \"Summary\" tab on the \"Equity Gap Analysis Tool\" spreadsheat. \n\n*Note: If you have more evaluators than rows with borders, please insert new rows above the last row in order to ensure your data is calculated correctly. \n\nFor the \"Indicator Charts\" tab, please select the box with the \"Choose Indicator\" dropdown menu. This menu will allow you to select an indicator. Once you have chosen an indicator to view, the table below will automatically get your data, remove any errors and display it visually in the chart to the right."]

{"sheet":"Evaluator Score","index":1,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Equity Component Score"]
["Evaluator Name","Equitable Student Access & Opportunity","Culturally Responsive Practices","Student-Centered Learning","Diverse Staff of Excellent Educators","Family and Community Engagement","School Climate"]
["Column1","2","3","4","5","6","7"]
["Column1",{"$f":"B5/68","v":{"$error":"#DIV/0!"}},{"$f":"C5/44","v":{"$error":"#DIV/0!"}},{"$f":"D5/32","v":{"$error":"#DIV/0!"}},{"$f":"E5/80","v":{"$error":"#DIV/0!"}},{"$f":"F5/80","v":{"$error":"#DIV/0!"}},{"$f":"G5/76","v":{"$error":"#DIV/0!"}}]
["Average Score",{"$f":"AVERAGE(B6:B35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Indicator Charts","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Evaluator Name","Choose Indicator","Average",null,"Note: To make sure chart is up-to-date, use CTRL+Shift+U (You must have enable macros for this work)",null,null,null,null,null,null,null,null,"Evaluator Name"]
[{"$f":"IF('Evaluator Score'!A6=\"\", NA(), 'Evaluator Score'!A6)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A2,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"<>#N/A"]
[{"$f":"IF('Evaluator Score'!A7=\"\", NA(), 'Evaluator Score'!A7)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A3,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A8=\"\", NA(), 'Evaluator Score'!A8)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A4,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A9=\"\", NA(), 'Evaluator Score'!A9)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A5,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A10=\"\", NA(), 'Evaluator Score'!A10)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A6,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A11=\"\", NA(), 'Evaluator Score'!A11)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A7,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A12=\"\", NA(), 'Evaluator Score'!A12)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A8,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A13=\"\", NA(), 'Evaluator Score'!A13)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A9,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A14=\"\", NA(), 'Evaluator Score'!A14)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A10,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A15=\"\", NA(), 'Evaluator Score'!A15)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A11,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A16=\"\", NA(), 'Evaluator Score'!A16)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A12,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A17=\"\", NA(), 'Evaluator Score'!A17)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A13,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A18=\"\", NA(), 'Evaluator Score'!A18)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A14,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A19=\"\", NA(), 'Evaluator Score'!A19)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A15,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A20=\"\", NA(), 'Evaluator Score'!A20)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A16,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A21=\"\", NA(), 'Evaluator Score'!A21)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A17,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A22=\"\", NA(), 'Evaluator Score'!A22)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A18,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A23=\"\", NA(), 'Evaluator Score'!A23)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A19,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A24=\"\", NA(), 'Evaluator Score'!A24)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A20,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A25=\"\", NA(), 'Evaluator Score'!A25)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A21,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A26=\"\", NA(), 'Evaluator Score'!A26)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A22,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A27=\"\", NA(), 'Evaluator Score'!A27)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A23,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A28=\"\", NA(), 'Evaluator Score'!A28)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A24,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A29=\"\", NA(), 'Evaluator Score'!A29)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A25,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A30=\"\", NA(), 'Evaluator Score'!A30)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A26,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A31=\"\", NA(), 'Evaluator Score'!A31)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A27,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A32=\"\", NA(), 'Evaluator Score'!A32)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A28,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A33=\"\", NA(), 'Evaluator Score'!A33)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A29,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A34=\"\", NA(), 'Evaluator Score'!A34)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A30,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]
[{"$f":"IF('Evaluator Score'!A35=\"\", NA(), 'Evaluator Score'!A35)","v":{"$error":"#N/A"}},{"$f":"IFERROR(VLOOKUP(A31,'Evaluator Score'!$A$4:$G$34,HLOOKUP($B$1,'Evaluator Score'!$B$2:$G$3,2,FALSE),FALSE),\"\")","v":""},{"$f":"HLOOKUP('Indicator Charts'!$B$1,'Evaluator Score'!$B$2:$G$5,4,)","v":{"$error":"#N/A"}}]