{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["Collectieve deskundigheid","Collectieve competenties","lid x","lid y"],"not_rendered":{"charts":6,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Collectieve deskundigheid","index":0,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Aantal bestuursleden in overzicht:",8]
[]
[]
[]
[]
[null,"Cumulatief",null,null,"collectieve","collectief","lid 1","lid 2","lid 3","lid 4","lid 5","lid 6","lid 7","lid 8","lid 9"]
["Deskundigheid","A","B","Buitengr","eigen norm","bestuur"]
[null,10,15]
[]
["Besturen van een organisatie",{"$f":"B1*B8","v":80},{"$f":"B1*C8","v":120},{"$f":"C10+10","v":130},{"$f":"VLOOKUP(B1,B30:C40,2)","v":100},{"$f":"SUM(G10:O10)","v":120},15,15,15,15,15,15,15,15]
["Wet- en regelgeving",{"$f":"B10","v":80},{"$f":"C10","v":120},{"$f":"D10","v":130},{"$f":"E10","v":100},{"$f":"SUM(G11:O11)","v":115},10,15,15,15,15,15,15,15]
["Pensioenregeling en- soorten",{"$f":"B11","v":80},{"$f":"C11","v":120},{"$f":"D11","v":130},{"$f":"E11","v":100},110,15,15,15,15,10,15,10,15]
["Actuariele aspecten en financiering",80,120,130,100,115,15,15,10,15,15,15,15,15]
["Beleggingsbeleid / vermogensbeheer",80,120,130,100,110,15,15,10,15,15,15,15,10]
["Verslaggeving",80,120,130,100,115,15,15,15,15,15,15,10,15]
["Balansmanagement",80,120,130,100,115,15,15,15,15,15,15,15,10]
["Herverzekering",80,120,130,100,90,10,10,10,15,10,15,10,10]
["Administratieve organisatie en interne controle",80,120,130,100,120,15,15,15,15,15,15,15,15]
["Communicatie",80,120,130,100,120,15,15,15,15,15,15,15,15]
["Uitbesteding",80,120,130,100,120,15,15,15,15,15,15,15,15]
["Informatietechnologie",80,120,130,100,95,15,10,10,10,10,15,15,10]
["Risicomanagement/-beheersing",80,120,130,100,110,15,10,15,15,15,15,15,10]
["ESG",80,120,130,100,{"$f":"SUM(G23:O23)","v":110},15,10,15,15,15,15,15,10]
[]
[]
[]
["Invulvelden zijn in BLAUW weergegeven"]
[]
[]
["Tbv spider normering deskundigheid","Aantal","Eigen norm"]
[]
["1 bestuurslid",1,{"$f":"1*C8","v":15}]
["2 bestuursleden",2,{"$f":"2*C8","v":30}]
["3 bestuursleden",3,{"$f":"3*C8","v":45}]
["4 bestuursleden",4,{"$f":"4*15","v":60}]
["5 bestuursleden",5,{"$f":"C35+10","v":70},"  nl 4x B + 1x A"]
["6 bestuursleden",6,{"$f":"C36+10","v":80},"  nl 4x B + 2x A"]
["7 bestuursleden",7,90,"  nl 4x B + 3x A"]
["8 bestuursleden",8,100,"  nl 4x B + 4x A"]
["9 bestuursleden",9,110,"  nl 4x B + 5x A"]

{"sheet":"Collectieve competenties","index":1,"n_rows":32,"n_cols":15,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Aantal bestuursleden in overzicht:",8]
[]
[null,"Cumulatief",null,null,null,"collectief","lid 1","lid 2","lid 3","lid 4","lid 5","lid 6","lid 7","lid 8","lid 9"]
["Competentie","Laag","Midden","Hoog","Buitengr","bestuur"]
[null,5,10,15]
[]
["Strategisch denken",{"$f":"B1*B5","v":40},{"$f":"B1*C5","v":80},{"$f":"B1*D5","v":120},{"$f":"D7+10","v":130},{"$f":"SUM(G7:O7)","v":85},10,10,10,10,10,15,15,5]
["Multidisciplinair denken en oordeelsvorming",{"$f":"B7","v":40},{"$f":"C7","v":80},120,{"$f":"E7","v":130},{"$f":"SUM(G8:O8)","v":100},15,5,5,15,15,15,15,15]
["Verantwoordelijkheid",{"$f":"B8","v":40},80,120,130,90,10,10,15,15,10,10,10,10]
["Reflecterend vermogen",40,80,120,130,90,10,10,10,10,10,15,10,15]
["Loyaliteit",40,80,120,130,85,10,10,15,10,10,10,10,10]
["Samenwerken",40,80,120,130,85,10,10,10,10,10,10,15,10]
["Communicatief vermogen",40,80,120,130,80,5,10,5,15,10,5,15,15]
["Omgevingsbewust",40,80,120,130,80,15,5,5,10,15,10,10,10]
["Stressbestendigheid",40,80,120,130,95,15,10,10,15,15,10,10,10]
["Onafhankelijkheid",40,80,120,130,95,15,10,10,15,15,15,10,5]
["Authenticiteit",40,80,120,130,90,10,10,10,10,10,15,10,15]
["Besluitvaardigheid",40,80,120,130,85,15,10,10,5,15,10,10,10]
["Onderhandelingsvaardigheid",40,80,120,130,70,5,10,10,10,5,10,10,10]
["Klant-kwaliteit en resultaatgerichtheid",40,80,120,130,95,10,15,15,10,10,10,15,10]
["Strategische sturing",40,80,120,130,80,10,10,10,5,10,10,15,10]
["Overtuigingskracht",40,80,120,130,75,5,15,10,10,5,10,10,10]
{"$rows_empty":9}
["Invulvelden zijn in BLAUW weergegeven"]

{"sheet":"lid x","index":2,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Competentie","Laag","Midden","Hoog","lid x"]
["strategisch denken",5,10,15,10]
["multidisciplinair denken en oordeelsvorming",5,10,15,15]
["verantwoordelijkheid",5,10,15,10]
["reflecterend vermogen",5,10,15,10]
["loyaliteit",5,10,15,10]
["samenwerken",5,10,15,10]
["communicatief vermogen",5,10,15,15]
["omgevingsbewust",5,10,15,15]
["stressbestendigheid",5,10,15,10]
["onafhankelijkheid",5,10,15,15]
["authenticiteit",5,10,15,10]
["besluitvaardigheid",5,10,15,10]
["onderhandelingsvaardigheid",5,10,15,10]
["klant-kwaliteit en resultaatgerichtheid",5,10,15,10]
["strategsiche sturing",5,10,15,10]
["overtuigingskracht",5,10,15,5]
["leiderschap",5,10,15,5]
["voorzittersvaardigheid",5,10,15,10]
[]
[]
[]
["Deskundigheid","A","B","E","lid x "]
["Besturen van een organisatie",10,15,20,15]
["Wet- en regelgeving",10,15,20,15]
["Pensioenregeling en- soorten",10,15,20,15]
["Actuariele aspecten en financiering",10,15,20,15]
["Beleggingsbeleid / vermogensbeheer",10,15,20,15]
["Verslaggeving",10,15,20,15]
["Balansmanagement",10,15,20,15]
["Herverzekering",10,15,20,15]
["Administratieve organisatie en interne controle",10,15,20,15]
["Communicatie",10,15,20,15]
["Uitbesteding",10,15,20,15]

{"sheet":"lid y","index":3,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Competentie","Laag","Midden","Hoog","lid y"]
["strategisch denken",5,10,15,15,"H"]
["multidisciplinair denken en oordeelsvorming",5,10,15,15,"H"]
["verantwoordelijkheid",5,10,15,10,"M"]
["reflecterend vermogen",5,10,15,15,"H"]
["loyaliteit",5,10,15,10,"M"]
["samenwerken",5,10,15,10,"M"]
["communicatief vermogen",5,10,15,5,"L"]
["omgevingsbewust",5,10,15,10,"M"]
["stressbestendigheid",5,10,15,10,"M"]
["onafhankelijkheid",5,10,15,15,"H"]
["authenticiteit",5,10,15,10,"M"]
["besluitvaardigheid",5,10,15,10,"M"]
["onderhandelingsvaardigheid",5,10,15,10,"M"]
["klant-kwaliteit en resultaatgerichtheid",5,10,15,10,"M"]
["strategsiche sturing",5,10,15,5,"L"]
["overtuigingskracht",5,10,15,5,"L"]
[]
[]
[]
[]
[]
["Deskundigheid","A","B","E","lid y"]
["Besturen van een organisatie",10,15,20,10,"A",0.83]
["Wet- en regelgeving",10,15,20,15,"B",0.9]
["Pensioenregeling en- soorten",10,15,20,15,"B",0.71]
["Actuariele aspecten en financiering",10,15,20,10,"A",0.71]
["Beleggingsbeleid / vermogensbeheer",10,15,20,10,"A",0.82]
["Verslaggeving",10,15,20,10,"A",0.38]
["Balansmanagement",10,15,20,10,"A",0.55000000000000004]
["Herverzekering",10,15,20,10,"A",1]
["Administratieve organisatie en interne controle",10,15,20,10,"A",0.5]
["Communicatie",10,15,20,15,"B",0.75]
["Uitbesteding",10,15,20,10,"A",0.88]