{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","1. Data Sheet","2. Performance Dashboard","3. Term Sheet","Calculations"],"not_rendered":{"charts":11,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Instructions","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[[28,2,30,4],[17,1,17,2],[1,1,1,2],[6,1,8,1],[10,1,10,2],[22,1,22,2],[24,2,26,4],[24,1,26,1]]}
[]
[null,"Performance Management Dashboard"]
[]
[]
[null,"About this resource","The purpose of this resource is to provide HR professionals with a high-level overview of key performance metrics to drive critical decisions and discussions with the business at the end of the performance cycle."]
[]
[null,"Included in this resource","1. Data Sheet: Use this sheet to enter information about your employees and their performance ratings."]
[null,null,"2. Performance Dashboard: Use this sheet to review a visual representation of data spanning various business units and demographic categories."]
[null,null,"3. Term Sheet: This sheet allows you to update the fields to customize drop-down menus and make them relevant to your own organization."]
[]
[null," Instructions"]
[null,"STEP 1","Create a copy of this document."]
[null,"STEP 2","Go to the Term Sheet and replace the terms with those relevant to your organization. Ensure that you only replace terms in the blue-outlined cells. "]
[null,"STEP 3","Use the Data Sheet to input your data. Use the set drop-downs where applicable. "]
[null,"STEP 4","You can use the dashboard to visualize both individual and manager ratings across business units and based on demographic information."]
[]
[]
[null,"ATTENTION\nUsing this template means filling it with sensitive, personal information about the employees at your organization. It's important to ensure that this information is kept confidential and protected. \nDon't share this information beyond the relevant and accredited stakeholders."]

{"sheet":"1. Data Sheet","index":1,"n_rows":8,"n_cols":14,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[null,"Data Sheet"]
[null,null,null,null,null,null,"Review period:"]
[null,"Employee full name","Business unit","Age","Demographic","Gender","Tenure","Final rating for\nprevious period","Individual rating for\ncurrent period","Manager","Manager rating for\ncurrent period","Final rating for\ncurrent period"]
[null,"Enter the employee's name and surname.","Choose the employee's business unit.","Choose the employee's age range.","Choose the employee's demographic profile.","Choose the employee's gender.","Enter the employee's tenure in years.","Enter the employee's final rating for previous period.","Enter the employee's individual rating for the current period.","Choose the manager.","Enter the manager's rating for the current period.","Enter the final rating for the current period.",null,"Rating legend:"]
[null,"Filter by name","Filter by business unit","Filter by age rage","Filter by demographic profile","Filter by gender","Filter by tenure","Filter by rating","Filter by rating","Filter by manager","Filter by rating","Filter by rating",null,"1. Insufficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2. Moderate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3. Sufficient"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Exceeding"]

{"sheet":"2. Performance Dashboard","index":2,"n_rows":117,"n_cols":9,"rows_kept":117,"cut":false,"hidden":false,"merged":[[104,2,111,6],[116,2,123,6],[104,8,111,12],[116,8,123,12],[80,2,87,6],[80,8,87,12],[92,8,99,12],[92,2,99,6]]}
[null,null,"Performance Dashboard"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculations!C2","v":0},null,null,null,null,null,{"$f":"Calculations!B2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculations!C3","v":0},null,null,null,null,null,{"$f":"Calculations!B3","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculations!C4","v":0},null,null,null,null,null,{"$f":"Calculations!B4","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Calculations!C5","v":0},null,null,null,null,null,{"$f":"Calculations!B5","v":0}]

{"sheet":"3. Term Sheet","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[225,1,225,4],[1,0,1,5],[2,0,2,5]]}
["Manager","Business unit","Age","Demographic","Gender","Score"]
["You will find some suggested terms here, but you can update all the fields within a cell with a blue border to reflect the data relevant to your own organization. "]
["ATTENTION: If you make changes to the data sheet after you have started adding information to it, the drop-down lists will update automatically, but the data you’ve previously entered will remain unchanged. \nThat means you will need to go back to the data sheet and manually replace the old term with the new one."]
["Manager 1","BU 1","18–24","Asian","Woman",1]
["Manager 2","BU 2","25–34","Black","Man",2]
["Manager 3","BU 3","35–44","Hispanic or Latino","Nonbinary",3]
["Manager 4","BU 4","45–54","White","Other",4]
["Manager 5","BU 5","55–64","American Indian/Alaska Native","Prefers not to disclose"]
["Manager 6","BU 6","65+","Prefers not to identify"]
["Manager 7","BU 7"]
["Manager 8","BU 8"]
["Manager 9","BU 9"]
["Manager 10","BU 10"]
["Manager 11","BU 11"]
["Manager 12","BU 12"]
["Manager 13","BU 13"]
["Manager 14","BU 14"]
["Manager 15","BU 15"]

{"sheet":"Calculations","index":4,"n_rows":173,"n_cols":16,"rows_kept":173,"cut":false,"hidden":true,"merged":[[121,0,121,15],[96,0,96,15],[72,0,72,15],[49,0,49,15],[7,0,7,5],[20,0,20,6],[34,0,34,6],[7,7,7,12],[20,8,20,14],[34,8,34,14]]}
["Score",{"$f":"'1. Data Sheet'!I3","v":"Individual rating for\ncurrent period"},{"$f":"'1. Data Sheet'!K3","v":"Manager rating for\ncurrent period"},{"$f":"'1. Data Sheet'!H3","v":"Final rating for\nprevious period"}]
[{"$f":"'3. Term Sheet'!F4","v":1},{"$f":"COUNTIF('1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$H$6:$H$506,A2)","v":0}]
[{"$f":"'3. Term Sheet'!F5","v":2},{"$f":"COUNTIF('1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$H$6:$H$506,A3)","v":0}]
[{"$f":"'3. Term Sheet'!F6","v":3},{"$f":"COUNTIF('1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$H$6:$H$506,A4)","v":0}]
[{"$f":"'3. Term Sheet'!F7","v":4},{"$f":"COUNTIF('1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIF('1. Data Sheet'!$H$6:$H$506,A5)","v":0}]
[]
[]
["Total Gender Profile Per Current Individual Score",null,null,null,null,null,null,"Total Gender Profile per Current Manager Score"]
[null,{"$f":"'3. Term Sheet'!E4","v":"Woman"},{"$f":"'3. Term Sheet'!E5","v":"Man"},{"$f":"'3. Term Sheet'!E6","v":"Nonbinary"},{"$f":"'3. Term Sheet'!E7","v":"Other"},{"$f":"'3. Term Sheet'!E8","v":"Prefers not to disclose"},null,null,{"$f":"'3. Term Sheet'!E4","v":"Woman"},{"$f":"'3. Term Sheet'!E5","v":"Man"},{"$f":"'3. Term Sheet'!E6","v":"Nonbinary"},{"$f":"'3. Term Sheet'!E7","v":"Other"},{"$f":"'3. Term Sheet'!E8","v":"Prefers not to disclose"}]
[{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},null,{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$K$6:$K$506,A2)","v":0}]
[{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},null,{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$K$6:$K$506,A3)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},null,3,{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$K$6:$K$506,A4)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},null,4,{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$4,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$5,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$6,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$7,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$F$6:$F$506,'3. Term Sheet'!$E$8,'1. Data Sheet'!$K$6:$K$506,A5)","v":0}]
[]
[{"$f":"'3. Term Sheet'!E4","v":"Woman"},{"$f":"SUM(B10:B13)","v":0},{"$f":"IF(B15=0,NA(),B15)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"'3. Term Sheet'!E4","v":"Woman"},{"$f":"SUM(I10:I13)","v":0},{"$f":"IF(I15=0,NA(),I15)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!E5","v":"Man"},{"$f":"SUM(C10:C13)","v":0},{"$f":"IF(B16=0,NA(),B16)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"'3. Term Sheet'!E5","v":"Man"},{"$f":"SUM(J10:J13)","v":0},{"$f":"IF(I16=0,NA(),I16)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!E6","v":"Nonbinary"},{"$f":"SUM(D10:D13)","v":0},{"$error":"#N/A"},null,null,null,null,{"$f":"'3. Term Sheet'!E6","v":"Nonbinary"},{"$f":"SUM(K10:K13)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!E7","v":"Other"},{"$f":"SUM(E10:E13)","v":0},{"$error":"#N/A"},null,null,null,null,{"$f":"'3. Term Sheet'!E7","v":"Other"},{"$f":"SUM(L10:L13)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!E8","v":"Prefers not to disclose"},{"$f":"SUM(F10:F13)","v":0},{"$error":"#N/A"},null,null,null,null,{"$f":"'3. Term Sheet'!E8","v":"Prefers not to disclose"},{"$f":"SUM(M10:M13)","v":0},{"$error":"#N/A"}]
[]
["Total Demographic Profile Per Current Individual Score",null,null,null,null,null,null,null,"Active Demographic Profile Per Current Manager Score"]
[null,{"$f":"'3. Term Sheet'!D4","v":"Asian"},{"$f":"'3. Term Sheet'!D5","v":"Black"},{"$f":"'3. Term Sheet'!D6","v":"Hispanic or Latino"},{"$f":"'3. Term Sheet'!D7","v":"White"},{"$f":"'3. Term Sheet'!D8","v":"American Indian/Alaska Native"},{"$f":"'3. Term Sheet'!D9","v":"Prefers not to identify"},null,null,{"$f":"'3. Term Sheet'!D4","v":"Asian"},{"$f":"'3. Term Sheet'!D5","v":"Black"},{"$f":"'3. Term Sheet'!D6","v":"Hispanic or Latino"},{"$f":"'3. Term Sheet'!D7","v":"White"},{"$f":"'3. Term Sheet'!D8","v":"American Indian/Alaska Native"},{"$f":"'3. Term Sheet'!D9","v":"Prefers not to identify"}]
[{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},null,{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$K$6:K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$K$6:$K$506,A2)","v":0}]
[{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},null,{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$K$6:K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$K$6:$K$506,A3)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},null,3,{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$K$6:K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$K$6:$K$506,A4)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},null,4,{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$4,'1. Data Sheet'!$K$6:K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$5,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$6,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$7,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$8,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$E$6:$E$506,'3. Term Sheet'!$D$9,'1. Data Sheet'!$K$6:$K$506,A5)","v":0}]
[]
[{"$f":"'3. Term Sheet'!D4","v":"Asian"},{"$f":"SUM(B23:B26)","v":0},{"$f":"IF(B28=0,NA(),B28)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"'3. Term Sheet'!D4","v":"Asian"},{"$f":"SUM(J23:J26)","v":0},{"$f":"IF(J28=0,NA(),J28)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!D5","v":"Black"},{"$f":"SUM(C23:C26)","v":0},{"$f":"IF(B29=0,NA(),B29)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"'3. Term Sheet'!D5","v":"Black"},{"$f":"SUM(K23:K26)","v":0},{"$f":"IF(J29=0,NA(),J29)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!D6","v":"Hispanic or Latino"},{"$f":"SUM(D23:D26)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!D6","v":"Hispanic or Latino"},{"$f":"SUM(L23:L26)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!D7","v":"White"},{"$f":"SUM(E23:E26)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!D7","v":"White"},{"$f":"SUM(M23:M26)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!D8","v":"American Indian/Alaska Native"},{"$f":"SUM(F23:F26)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!D8","v":"American Indian/Alaska Native"},{"$f":"SUM(N23:N26)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!D9","v":"Prefers not to identify"},{"$f":"SUM(G23:G26)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!D9","v":"Prefers not to identify"},{"$f":"SUM(O23:O26)","v":0},{"$error":"#N/A"}]
[]
["Total Age Profile Per Current Individual Score",null,null,null,null,null,null,null,"Active Age Profile Per Current Manager Score"]
[null,{"$f":"'3. Term Sheet'!C4","v":"18–24"},{"$f":"'3. Term Sheet'!C5","v":"25–34"},{"$f":"'3. Term Sheet'!C6","v":"35–44"},{"$f":"'3. Term Sheet'!C7","v":"45–54"},{"$f":"'3. Term Sheet'!C8","v":"55–64"},{"$f":"'3. Term Sheet'!C9","v":"65+"},null,null,{"$f":"'3. Term Sheet'!C4","v":"18–24"},{"$f":"'3. Term Sheet'!C5","v":"25–34"},{"$f":"'3. Term Sheet'!C6","v":"35–44"},{"$f":"'3. Term Sheet'!C7","v":"45–54"},{"$f":"'3. Term Sheet'!C8","v":"55–64"},{"$f":"'3. Term Sheet'!C9","v":"65+"}]
[{"$f":"A10","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},null,{"$f":"A10","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$K$6:$K$506,A2)","v":0}]
[{"$f":"A11","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},null,{"$f":"A11","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$K$6:$K$506,A3)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},null,3,{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$K$6:$K$506,A4)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},null,4,{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$4,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$5,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$6,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$7,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$8,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$D$6:$D$506,'3. Term Sheet'!$C$9,'1. Data Sheet'!$K$6:$K$506,A5)","v":0}]
[]
[{"$f":"'3. Term Sheet'!C4","v":"18–24"},{"$f":"SUM(B37:B40)","v":0},{"$f":"IF(B42=0,NA(),B42)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"'3. Term Sheet'!C4","v":"18–24"},{"$f":"SUM(J37:J40)","v":0},{"$f":"IF(J42=0,NA(),J42)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!C5","v":"25–34"},{"$f":"SUM(C37:C40)","v":0},{"$f":"IF(B43=0,NA(),B43)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"'3. Term Sheet'!C5","v":"25–34"},{"$f":"SUM(K37:K40)","v":0},{"$f":"IF(J43=0,NA(),J43)","v":{"$error":"#N/A"}}]
[{"$f":"'3. Term Sheet'!C6","v":"35–44"},{"$f":"SUM(D37:D40)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!C6","v":"35–44"},{"$f":"SUM(L37:L40)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!C7","v":"45–54"},{"$f":"SUM(E37:E40)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!C7","v":"45–54"},{"$f":"SUM(M37:M40)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!C8","v":"55–64"},{"$f":"SUM(F37:F40)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!C8","v":"55–64"},{"$f":"SUM(N37:N40)","v":0},{"$error":"#N/A"}]
[{"$f":"'3. Term Sheet'!C9","v":"65+"},{"$f":"SUM(G37:G40)","v":0},{"$error":"#N/A"},null,null,null,null,null,{"$f":"'3. Term Sheet'!C9","v":"65+"},{"$f":"SUM(O37:O40)","v":0},{"$error":"#N/A"}]
[]
[]
["Individual Score for Current Period per Business Unit"]
[null,{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"'3. Term Sheet'!B18","v":"BU 15"}]
[{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$I$6:$I$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$I$6:$I$506,A2)","v":0}]
[{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$I$6:$I$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$I$6:$I$506,A3)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$I$6:$I$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$I$6:$I$506,A4)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$I$6:$I$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$I$6:$I$506,A5)","v":0}]
[]
[{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"SUM(B52:B55)","v":0}]
[{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"SUM(C52:C55)","v":0}]
[{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"SUM(D52:D55)","v":0}]
[{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"SUM(E52:E55)","v":0}]
[{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"SUM(F52:F55)","v":0}]
[{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"SUM(G52:G55)","v":0}]
[{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"SUM(H52:H55)","v":0}]
[{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"SUM(I52:I55)","v":0}]
[{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"SUM(J52:J55)","v":0}]
[{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"SUM(K52:K55)","v":0}]
[{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"SUM(L52:L55)","v":0}]
[{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"SUM(M52:M55)","v":0}]
[{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"SUM(N52:N55)","v":0}]
[{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"SUM(O52:O55)","v":0}]
[{"$f":"'3. Term Sheet'!B18","v":"BU 15"},{"$f":"SUM(P52:P55)","v":0}]
[]
["Manager Score for Current Period per Business Unit"]
[null,{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"'3. Term Sheet'!B18","v":"BU 15"}]
[{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$K$6:$K$506,A2)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$K$6:$K$506,A2)","v":0}]
[{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$K$6:$K$506,A3)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$K$6:$K$506,A3)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$K$6:$K$506,A4)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$K$6:$K$506,A4)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$K$6:$K$506,A5)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$K$6:$K$506,A5)","v":0}]
[]
[{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"SUM(B75:B78)","v":0}]
[{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"SUM(C75:C78)","v":0}]
[{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"SUM(D75:D78)","v":0}]
[{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"SUM(E75:E78)","v":0}]
[{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"SUM(F75:F78)","v":0}]
[{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"SUM(G75:G78)","v":0}]
[{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"SUM(H75:H78)","v":0}]
[{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"SUM(I75:I78)","v":0}]
[{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"SUM(J75:J78)","v":0}]
[{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"SUM(K75:K78)","v":0}]
[{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"SUM(L75:L78)","v":0}]
[{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"SUM(M75:M78)","v":0}]
[{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"SUM(N75:N78)","v":0}]
[{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"SUM(O75:O78)","v":0}]
[{"$f":"'3. Term Sheet'!B18","v":"BU 15"},{"$f":"SUM(P75:P78)","v":0}]
[]
[]
["Final Score for Current Period per Business Unit"]
[null,{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"'3. Term Sheet'!B18","v":"BU 15"}]
[{"$f":"A2","v":1},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$L$6:$L$506,A99)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$L$6:$L$506,A99)","v":0}]
[{"$f":"A3","v":2},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$L$6:$L$506,A100)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$L$6:$L$506,A100)","v":0}]
[3,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$L$6:$L$506,A101)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$L$6:$L$506,A101)","v":0}]
[4,{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$4,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$5,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$6,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$7,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$8,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$9,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$10,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$11,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$12,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$13,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$14,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$15,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$16,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$17,'1. Data Sheet'!$L$6:$L$506,A102)","v":0},{"$f":"COUNTIFS('1. Data Sheet'!$C$6:$C$506,'3. Term Sheet'!$B$18,'1. Data Sheet'!$L$6:$L$506,A102)","v":0}]
[]
[{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"SUM(B99:B102)","v":0}]
[{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"SUM(C99:C102)","v":0}]
[{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"SUM(D99:D102)","v":0}]
[{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"SUM(E99:E102)","v":0}]
[{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"SUM(F99:F102)","v":0}]
[{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"SUM(G99:G102)","v":0}]
[{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"SUM(H99:H102)","v":0}]
[{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"SUM(I99:I102)","v":0}]
[{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"SUM(J99:J102)","v":0}]
[{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"SUM(K99:K102)","v":0}]
[{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"SUM(L99:L102)","v":0}]
[{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"SUM(M99:M102)","v":0}]
[{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"SUM(N99:N102)","v":0}]
[{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"SUM(O99:O102)","v":0}]
[{"$f":"'3. Term Sheet'!B18","v":"BU 15"},{"$f":"SUM(P99:P102)","v":0}]
[]
[]
[]
["Final rating for the organization"]
[]
[1,{"$f":"COUNTIF('1. Data Sheet'!L6:L506,1)","v":0}]
[2,{"$f":"COUNTIF('1. Data Sheet'!L6:L506,2)","v":0}]
[3,{"$f":"COUNTIF('1. Data Sheet'!L6:L506,3)","v":0}]
[4,{"$f":"COUNTIF('1. Data Sheet'!L6:L506,4)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["List of managers","Drop-down"]
[{"$f":"'3. Term Sheet'!A4","v":"Manager 1"},{"$f":"A142","v":"Manager 1"}]
[{"$f":"'3. Term Sheet'!A5","v":"Manager 2"},{"$f":"IF(A142=\"Manager 1\",\"Manager 2\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\"),A143,\"\"))","v":"Manager 2"}]
[{"$f":"'3. Term Sheet'!A6","v":"Manager 3"},{"$f":"IF(A142=\"Manager 1\",\"Manager 3\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\"),A144,\"\"))","v":"Manager 3"}]
[{"$f":"'3. Term Sheet'!A7","v":"Manager 4"},{"$f":"IF(A142=\"Manager 1\",\"Manager 4\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\"),A145,\"\"))","v":"Manager 4"}]
[{"$f":"'3. Term Sheet'!A8","v":"Manager 5"},{"$f":"IF(A142=\"Manager 1\",\"Manager 5\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\"),A146,\"\"))","v":"Manager 5"}]
[{"$f":"'3. Term Sheet'!A9","v":"Manager 6"},{"$f":"IF(A142=\"Manager 1\",\"Manager 6\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\"),A147,\"\"))","v":"Manager 6"}]
[{"$f":"'3. Term Sheet'!A10","v":"Manager 7"},{"$f":"IF(A142=\"Manager 1\",\"Manager 7\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\"),A148,\"\"))","v":"Manager 7"}]
[{"$f":"'3. Term Sheet'!A11","v":"Manager 8"},{"$f":"IF(A142=\"Manager 1\",\"Manager 8\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\"),A149,\"\"))","v":"Manager 8"}]
[{"$f":"'3. Term Sheet'!A12","v":"Manager 9"},{"$f":"IF(A142=\"Manager 1\",\"Manager 9\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\"),A150,\"\"))","v":"Manager 9"}]
[{"$f":"'3. Term Sheet'!A13","v":"Manager 10"},{"$f":"IF(A142=\"Manager 1\",\"Manager 10\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\"),A151,\"\"))","v":"Manager 10"}]
[{"$f":"'3. Term Sheet'!A14","v":"Manager 11"},{"$f":"IF(A142=\"Manager 1\",\"Manager 11\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\",A152<>\"Manager 11\"),A152,\"\"))","v":"Manager 11"}]
[{"$f":"'3. Term Sheet'!A15","v":"Manager 12"},{"$f":"IF(A142=\"Manager 1\",\"Manager 12\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\",A152<>\"Manager 11\",A153<>\"Manager 12\"),A153,\"\"))","v":"Manager 12"}]
[{"$f":"'3. Term Sheet'!A16","v":"Manager 13"},{"$f":"IF(A142=\"Manager 1\",\"Manager 13\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Managerr 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\",A152<>\"Manager 11\",A153<>\"Manager 12\",A154<>\"Manager 13\"),A154,\"\"))","v":"Manager 13"}]
[{"$f":"'3. Term Sheet'!A17","v":"Manager 14"},{"$f":"IF(A142=\"Manager 1\",\"Manager 14\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\",A152<>\"Manager 11\",A153<>\"Manager 12\",A154<>\"Manager 13\",A155<>\"Manager 14\"),A155,\"\"))","v":"Manager 14"}]
[{"$f":"'3. Term Sheet'!A18","v":"Manager 15"},{"$f":"IF(A142=\"Manager 1\",\"Manager 15\",IF(AND(A142<>\"Manager 1\",A143<>\"Manager 2\",A144<>\"Manager 3\",A145<>\"Manager 4\",A146<>\"Manager 5\",A147<>\"Manager 6\",A148<>\"Manager 7\",A149<>\"Manager 8\",A150<>\"Manager 9\",A151<>\"Manager 10\",A152<>\"Manager 11\",A153<>\"Manager 12\",A154<>\"Manager 13\",A155<>\"Manager 14\",A156<>\"Manager 15\"),A156,\"\"))","v":"Manager 15"}]
[{"$f":"'3. Term Sheet'!A19","v":0}]
["List of BU","Drop-down"]
[{"$f":"'3. Term Sheet'!B4","v":"BU 1"},{"$f":"A159","v":"BU 1"}]
[{"$f":"'3. Term Sheet'!B5","v":"BU 2"},{"$f":"IF(A159=\"BU 1\",\"BU 2\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\"),A160,\"\"))","v":"BU 2"}]
[{"$f":"'3. Term Sheet'!B6","v":"BU 3"},{"$f":"IF(A159=\"BU 1\",\"BU 3\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\"),A161,\"\"))","v":"BU 3"}]
[{"$f":"'3. Term Sheet'!B7","v":"BU 4"},{"$f":"IF(A159=\"BU 1\",\"BU 4\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\"),A162,\"\"))","v":"BU 4"}]
[{"$f":"'3. Term Sheet'!B8","v":"BU 5"},{"$f":"IF(A159=\"BU 1\",\"BU 5\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\"),A163,\"\"))","v":"BU 5"}]
[{"$f":"'3. Term Sheet'!B9","v":"BU 6"},{"$f":"IF(A159=\"BU 1\",\"BU 6\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\"),A164,\"\"))","v":"BU 6"}]
[{"$f":"'3. Term Sheet'!B10","v":"BU 7"},{"$f":"IF(A159=\"BU 1\",\"BU 7\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\"),A165,\"\"))","v":"BU 7"}]
[{"$f":"'3. Term Sheet'!B11","v":"BU 8"},{"$f":"IF(A159=\"BU 1\",\"BU 8\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\"),A166,\"\"))","v":"BU 8"}]
[{"$f":"'3. Term Sheet'!B12","v":"BU 9"},{"$f":"IF(A159=\"BU 1\",\"BU 9\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\"),A167,\"\"))","v":"BU 9"}]
[{"$f":"'3. Term Sheet'!B13","v":"BU 10"},{"$f":"IF(A159=\"BU 1\",\"BU 10\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\"),A168,\"\"))","v":"BU 10"}]
[{"$f":"'3. Term Sheet'!B14","v":"BU 11"},{"$f":"IF(A159=\"BU 1\",\"BU 11\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\",A169<>\"BU 11\"),A169,\"\"))","v":"BU 11"}]
[{"$f":"'3. Term Sheet'!B15","v":"BU 12"},{"$f":"IF(A159=\"BU 1\",\"BU 12\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\",A169<>\"BU 11\",A170<>\"BU 12\"),A170,\"\"))","v":"BU 12"}]
[{"$f":"'3. Term Sheet'!B16","v":"BU 13"},{"$f":"IF(A159=\"BU 1\",\"BU 13\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\",A169<>\"BU 11\",A170<>\"BU 12\",A171<>\"BU 13\"),A171,\"\"))","v":"BU 13"}]
[{"$f":"'3. Term Sheet'!B17","v":"BU 14"},{"$f":"IF(A159=\"BU 1\",\"BU 14\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\",A169<>\"BU 11\",A170<>\"BU 12\",A171<>\"BU 13\",A172<>\"BU 14\"),A172,\"\"))","v":"BU 14"}]
[{"$f":"'3. Term Sheet'!B18","v":"BU 15"},{"$f":"IF(A159=\"BU 1\",\"BU 15\",IF(AND(A159<>\"BU 1\",A160<>\"BU 2\",A161<>\"BU 3\",A162<>\"BU 4\",A163<>\"BU 5\",A164<>\"BU 6\",A165<>\"BU 7\",A166<>\"BU 8\",A167<>\"BU 9\",A168<>\"BU 10\",A169<>\"BU 11\",A170<>\"BU 12\",A171<>\"BU 13\",A172<>\"BU 14\",A173<>\"BU 15\"),A173,\"\"))","v":"BU 15"}]