{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Matrix","Matrix Analysis"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Matrix","index":0,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[15,1,15,2],[5,15,5,16],[11,2,11,16],[47,1,47,16],[39,1,39,16],[42,1,42,16],[6,1,8,14],[13,1,13,2]]}
[]
[]
[]
[null,"[Insert Your Organization Name]"]
[null,"Board Skills Matrix",{"$nulls":13},"yes"]
[{"$nulls":15},"Priority Legend"]
[null,"This tool is designed to help boards assess the level of experience each director has in various skill areas, as well as the overall composition of the board as it relates to diversity.\n\nDirections: In the Skills/Experience Section, rate each board director using a scale of High(3) to Low/Not Applicable (1) to reflect the level of experience possessed in a particular area. In the Demographic Background Section, enter the qualifications as it relates to each director. Once completed, continue to Tab 2 (\"Matrix Analysis\").",{"$nulls":13},"High",3]
[{"$nulls":15},"Medium",2]
[{"$nulls":15},"Low/NA",1]
[]
[]
[null,null,"Board of Directors"]
[null,null,"Name","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name","Name"]
[null,"Term Expiration Date"]
[null,"Enter Month Year"]
[null,"Skills & Experience"]
[null,"Belief in/Support of Mission",2,2,3,2,3,3,3,1,3,3,3,3,3,1,2]
[null,"Board of Director Experience"]
[null,"CEO Succession Planning"]
[null,"Community Affiliation/Access"]
[null,"Compensation"]
[null,"Financial"]
[null,"Fundraising"]
[null,"Grant Writing"]
[null,"Human Resources"]
[null,"(Retail) Industry Knowledge"]
[null,"Leadership"]
[null,"Legal"]
[null,"Lobbying"]
[null,"Marketing/PR"]
[null,"Organizational Management"]
[null,"Risk Management"]
[null,"Strategic Planning"]
[null,"Technology/IT"]
[null,"Mission Specific 1"]
[null,"Mission Specific 2"]
[null,"Custom 1"]
[null,"Custom 2"]
[null,"Demographic Background"]
[null,"Gender"]
[null,"Male","Yes","Yes","Yes","Yes","Yes","Yes",null,null,null,"Yes",null,null,"Yes","Yes","Yes"]
[null,"Female",{"$nulls":6},"Yes","Yes","Yes",null,"Yes","Yes"]
[null,"Age"]
[null,"25-40"]
[null,"41-55"]
[null,"56-70"]
[null,"Over 70"]
[null,"Ethnicity"]
[null,"African American/Black"]
[null,"Asian, Hawaiian, or Pacific Islander"]
[null,"White/Caucasian"]
[null,"Hispanic/Latino"]
[null,"American Indian"]
[null,"Other"]
[null,"Custom 1"]
[null,"Custom 2"]

{"sheet":"Matrix Analysis","index":1,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,1,55,4],[6,1,8,4],[5,5,5,6],[45,1,45,4],[37,1,37,4],[40,1,40,4]]}
[]
[]
[]
[null,"[Insert Your Organization Name]"]
[null,"Board Skills Matrix Analysis"]
[{"$nulls":5},"Priority Legend"]
[null,"Using this Matrix Analysis tab, a board may be able to identify existing capabilities as well as areas where board development or additional qualifications are needed. It imports data inputed in Tab 1 (\"Matrix\") and ultimately relates that information to determine recruitment priorities for the board.\n\nDirections: Rate the level of importance for each skill and exerperience and demographic area as it pertains to your board. Then, see how that compares to your current board representation. Finally, determine recruitment priorities based on this comparison. Ratings to be used for level of importance and priority are a scale of High(3) to Low/Not Applicable (1).",null,null,null,"High",3]
[{"$nulls":5},"Medium",2]
[{"$nulls":5},"Low/NA",1]
[]
[]
[]
[null,null,"Level of Importance","Current Board Representation","Recruitment Priority"]
[null,"Skills & Experience"]
[null,{"$f":"Matrix!B17","v":"Belief in/Support of Mission"},3,{"$f":"IF(Matrix!C17:Q17<>0,AVERAGE(Matrix!C17:Q17),\"\")","v":2.4666666666666668},3]
[null,{"$f":"Matrix!B18","v":"Board of Director Experience"},null,{"$f":"IF(Matrix!C18:Q18<>0,AVERAGE(Matrix!C18:Q18),\"\")","v":""}]
[null,{"$f":"Matrix!B19","v":"CEO Succession Planning"},null,{"$f":"IF(Matrix!C19:Q19<>0,AVERAGE(Matrix!C19:Q19),\"\")","v":""}]
[null,{"$f":"Matrix!B20","v":"Community Affiliation/Access"},null,{"$f":"IF(Matrix!C20:Q20<>0,AVERAGE(Matrix!C20:Q20),\"\")","v":""}]
[null,{"$f":"Matrix!B21","v":"Compensation"},null,{"$f":"IF(Matrix!C21:Q21<>0,AVERAGE(Matrix!C21:Q21),\"\")","v":""}]
[null,{"$f":"Matrix!B22","v":"Financial"},null,{"$f":"IF(Matrix!C22:Q22<>0,AVERAGE(Matrix!C22:Q22),\"\")","v":""}]
[null,{"$f":"Matrix!B23","v":"Fundraising"},null,{"$f":"IF(Matrix!C23:Q23<>0,AVERAGE(Matrix!C23:Q23),\"\")","v":""}]
[null,{"$f":"Matrix!B24","v":"Grant Writing"},null,{"$f":"IF(Matrix!C24:Q24<>0,AVERAGE(Matrix!C24:Q24),\"\")","v":""}]
[null,{"$f":"Matrix!B25","v":"Human Resources"},null,{"$f":"IF(Matrix!C25:Q25<>0,AVERAGE(Matrix!C25:Q25),\"\")","v":""}]
[null,{"$f":"Matrix!B26","v":"(Retail) Industry Knowledge"},null,{"$f":"IF(Matrix!C26:Q26<>0,AVERAGE(Matrix!C26:Q26),\"\")","v":""}]
[null,{"$f":"Matrix!B27","v":"Leadership"},null,{"$f":"IF(Matrix!C27:Q27<>0,AVERAGE(Matrix!C27:Q27),\"\")","v":""}]
[null,{"$f":"Matrix!B28","v":"Legal"},null,{"$f":"IF(Matrix!C28:Q28<>0,AVERAGE(Matrix!C28:Q28),\"\")","v":""}]
[null,{"$f":"Matrix!B29","v":"Lobbying"},null,{"$f":"IF(Matrix!C29:Q29<>0,AVERAGE(Matrix!C29:Q29),\"\")","v":""}]
[null,{"$f":"Matrix!B30","v":"Marketing/PR"},null,{"$f":"IF(Matrix!C30:Q30<>0,AVERAGE(Matrix!C30:Q30),\"\")","v":""}]
[null,{"$f":"Matrix!B31","v":"Organizational Management"},null,{"$f":"IF(Matrix!C31:Q31<>0,AVERAGE(Matrix!C31:Q31),\"\")","v":""}]
[null,{"$f":"Matrix!B32","v":"Risk Management"},null,{"$f":"IF(Matrix!C32:Q32<>0,AVERAGE(Matrix!C32:Q32),\"\")","v":""}]
[null,{"$f":"Matrix!B33","v":"Strategic Planning"},null,{"$f":"IF(Matrix!C33:Q33<>0,AVERAGE(Matrix!C33:Q33),\"\")","v":""}]
[null,{"$f":"Matrix!B34","v":"Technology/IT"},null,{"$f":"IF(Matrix!C34:Q34<>0,AVERAGE(Matrix!C34:Q34),\"\")","v":""}]
[null,{"$f":"Matrix!B35","v":"Mission Specific 1"},null,{"$f":"IF(Matrix!C35:Q35<>0,AVERAGE(Matrix!C35:Q35),\"\")","v":""}]
[null,{"$f":"Matrix!B36","v":"Mission Specific 2"},null,{"$f":"IF(Matrix!C36:Q36<>0,AVERAGE(Matrix!C36:Q36),\"\")","v":""}]
[null,{"$f":"Matrix!B37","v":"Custom 1"},null,{"$f":"IF(Matrix!C37:Q37<>0,AVERAGE(Matrix!C37:Q37),\"\")","v":""}]
[null,{"$f":"Matrix!B38","v":"Custom 2"},null,{"$f":"IF(Matrix!C38:Q38<>0,AVERAGE(Matrix!C38:Q38),\"\")","v":""}]
[null,"Demographic Background"]
[null,"Gender"]
[null,"Male",2,{"$f":"IF(COUNTIFS(Matrix!C41:Q41,\"Yes\")<>0,COUNTIFS(Matrix!C41:Q41,\"Yes\"),\"\")","v":10},1]
[null,"Female",2,{"$f":"IF(COUNTIFS(Matrix!C42:Q42,\"Yes\")<>0,COUNTIFS(Matrix!C42:Q42,\"Yes\"),\"\")","v":5},2]
[null,"Age"]
[null,{"$f":"Matrix!B44","v":"25-40"},null,{"$f":"IF(COUNTIFS(Matrix!C44:Q44,\"Yes\")<>0,COUNTIFS(Matrix!C44:Q44,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B45","v":"41-55"},null,{"$f":"IF(COUNTIFS(Matrix!C45:Q45,\"Yes\")<>0,COUNTIFS(Matrix!C45:Q45,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B46","v":"56-70"},null,{"$f":"IF(COUNTIFS(Matrix!C46:Q46,\"Yes\")<>0,COUNTIFS(Matrix!C46:Q46,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B47","v":"Over 70"},null,{"$f":"IF(COUNTIFS(Matrix!C47:Q47,\"Yes\")<>0,COUNTIFS(Matrix!C47:Q47,\"Yes\"),\"\")","v":""}]
[null,"Ethnicity"]
[null,{"$f":"Matrix!B49","v":"African American/Black"},null,{"$f":"IF(COUNTIFS(Matrix!C49:Q49,\"Yes\")<>0,COUNTIFS(Matrix!C49:Q49,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B50","v":"Asian, Hawaiian, or Pacific Islander"},null,{"$f":"IF(COUNTIFS(Matrix!C50:Q50,\"Yes\")<>0,COUNTIFS(Matrix!C50:Q50,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B51","v":"White/Caucasian"},null,{"$f":"IF(COUNTIFS(Matrix!C51:Q51,\"Yes\")<>0,COUNTIFS(Matrix!C51:Q51,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B52","v":"Hispanic/Latino"},null,{"$f":"IF(COUNTIFS(Matrix!C52:Q52,\"Yes\")<>0,COUNTIFS(Matrix!C52:Q52,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B53","v":"American Indian"},null,{"$f":"IF(COUNTIFS(Matrix!C53:Q53,\"Yes\")<>0,COUNTIFS(Matrix!C53:Q53,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B54","v":"Other"},null,{"$f":"IF(COUNTIFS(Matrix!C54:Q54,\"Yes\")<>0,COUNTIFS(Matrix!C54:Q54,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B55","v":"Custom 1"},null,{"$f":"IF(COUNTIFS(Matrix!C55:Q55,\"Yes\")<>0,COUNTIFS(Matrix!C55:Q55,\"Yes\"),\"\")","v":""}]
[null,{"$f":"Matrix!B56","v":"Custom 2"},null,{"$f":"IF(COUNTIFS(Matrix!C56:Q56,\"Yes\")<>0,COUNTIFS(Matrix!C56:Q56,\"Yes\"),\"\")","v":""}]
[]
[null,"Note: This spreadsheet is locked. To edit this spreadheet, go to the Unprotect sheet option and enter the password \"deloitte\"."]