{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["bfi_2","about"],"not_rendered":{"charts":2,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"bfi_2","index":0,"n_rows":38,"n_cols":61,"rows_kept":38}
["bfi2_1","bfi2_2","bfi2_3","bfi2_4","bfi2_5","bfi2_6",null,"bfi2_7","bfi2_8","bfi2_9","bfi2_10","bfi2_11","bfi2_12","bfi2_13","bfi2_14","bfi2_15","bfi2_16","bfi2_17","bfi2_18","bfi2_19","bfi2_20","bfi2_21","bfi2_22","bfi2_23","bfi2_24","bfi2_25","bfi2_26","bfi2_27","bfi2_28","bfi2_29","bfi2_30","bfi2_31","bfi2_32","bfi2_33","bfi2_34","bfi2_35","bfi2_36","bfi2_37","bfi2_38","bfi2_39","bfi2_40","bfi2_41","bfi2_42","bfi2_43","bfi2_44","bfi2_45","bfi2_46","bfi2_47","bfi2_48","bfi2_49","bfi2_50","bfi2_51","bfi2_52","bfi2_53","bfi2_54","bfi2_55","bfi2_56","bfi2_57","bfi2_58","bfi2_59","bfi2_60"]
[{"$f":"IF(A11=\"\",\"\",A11)","v":""},{"$f":"IF(B11=\"\",\"\",B11)","v":""},"","","","",null,{"$f":"IF(G11=\"\",\"\",G11)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",{"$f":"IF(AM11=\"\",\"\",AM11)","v":""},"","","","","","","","","","","","","","","","","","","","",""]
[{"$f":"IF(A2=\"\",\"\",A2)","v":""},{"$f":"IF(B2=\"\",\"\",B2)","v":""},{"$f":"IF(C2=\"\",\"\",6-C2)","v":""},{"$f":"IF(D2=\"\",\"\",6-D2)","v":""},{"$f":"IF(E2=\"\",\"\",6-E2)","v":""},"",null,"",{"$f":"IF(I2=\"\",\"\",6-I2)","v":""},{"$f":"IF(J2=\"\",\"\",6-J2)","v":""},"",{"$f":"IF(L2=\"\",\"\",6-L2)","v":""},{"$f":"IF(M2=\"\",\"\",6-M2)","v":""},"","","",{"$f":"IF(Q2=\"\",\"\",6-Q2)","v":""},{"$f":"IF(R2=\"\",\"\",6-R2)","v":""},"","","","",{"$f":"IF(W2=\"\",\"\",6-W2)","v":""},{"$f":"IF(X2=\"\",\"\",6-X2)","v":""},{"$f":"IF(Y2=\"\",\"\",6-Y2)","v":""},{"$f":"IF(Z2=\"\",\"\",6-Z2)","v":""},{"$f":"IF(AA2=\"\",\"\",6-AA2)","v":""},"",{"$f":"IF(AC2=\"\",\"\",6-AC2)","v":""},{"$f":"IF(AD2=\"\",\"\",6-AD2)","v":""},{"$f":"IF(AE2=\"\",\"\",6-AE2)","v":""},{"$f":"IF(AF2=\"\",\"\",6-AF2)","v":""},"","","","",{"$f":"IF(AK2=\"\",\"\",6-AK2)","v":""},{"$f":"IF(AL2=\"\",\"\",6-AL2)","v":""},"","","","",{"$f":"IF(AQ2=\"\",\"\",6-AQ2)","v":""},"",{"$f":"IF(AS2=\"\",\"\",6-AS2)","v":""},{"$f":"IF(AT2=\"\",\"\",6-AT2)","v":""},"",{"$f":"IF(AV2=\"\",\"\",6-AV2)","v":""},{"$f":"IF(AW2=\"\",\"\",6-AW2)","v":""},{"$f":"IF(AX2=\"\",\"\",6-AX2)","v":""},{"$f":"IF(AY2=\"\",\"\",6-AY2)","v":""},{"$f":"IF(AZ2=\"\",\"\",6-AZ2)","v":""},"","","",{"$f":"IF(BD2=\"\",\"\",6-BD2)","v":""},"","",{"$f":"IF(BG2=\"\",\"\",6-BG2)","v":""},"",""]
["soc","comp","org","anx","as","ass",null,"resp","pro","dep","ic","enlev","tru","respo","ev","ci","soc","comp","org","anx","as","ass","resp","pro","dep","ic","enlev","tru","respo","ev","ci","soc","comp","org","anx","as","ass","resp","pro","dep","ic","enlev","tru","respo","en","ci","soc","comp","org","anx","as","ass","resp","pro","dep","ic","enlev","tru","respo","ev","ci"]
["E","A","C","NE","OM","E",null,"A","C","NE","OM","E ","A","C","NE","OM","E","A","C","NE","OM","E","A","C","NE","OM","E ","A","C","NE","OM","E","A","C","NE","OM","E","A","C","NE","OM","E ","A","C","NE","OM","E","A","C","NE","OM","E","A","C","NE","OM","E ","A","C","NE","OM"]
["Big Five Inventory-2 (BFI-2) - Scoring program",{"$nulls":6},{"$f":"\"Big Five Inventory-2 (BFI-2) - \"& H7","v":"Big Five Inventory-2 (BFI-2) - male norms*"}]
["Gender:",{"$nulls":6},{"$f":"IF(T16=1,\"male norms*\",\"female norms*\")","v":"male norms*"}]
[]
["BFI-2 data input"]
["Item 1","Item 2","Item 3","Item 4","Item 5","Item 6","Item 7","Item 8","Item 9","Item 10","Item 11","Item 12","Item 13","Item 14","Item 15","Item 16","Item 17","Item 18","Item 19","Item 20","Item 21","Item 22","Item 23","Item 24","Item 25","Item 26","Item 27","Item 28","Item 29","Item 30","Item 31","Item 32","Item 33","Item 34","Item 35","Item 36","Item 37","Item 38","Item 39","Item 40","Item 41","Item 42","Item 43","Item 44","Item 45","Item 46","Item 47","Item 48","Item 49","Item 50","Item 51","Item 52","Item 53","Item 54","Item 55","Item 56","Item 57","Item 58","Item 59","Item 60"]
[]
[{"$nulls":23},"Internet sample",{"$nulls":6},"Student sample"]
[{"$nulls":23},"Men",null,"Women",null,"Gender corrected",null,null,"Men",null,"Women",null,"Gender corrected"]
[{"$nulls":4},"Mean","T-score*",null,"T-score*",{"$nulls":3},"NO",{"$nulls":11},"Mean","SD","Mean","SD","Mean","SD",null,"Mean","SD","Mean","SD","Mean","SD"]
["Extraversion","Extraversion",null,null,{"$f":"IF(E16=\"\",\"\",(E16+E17+E18)/3)","v":""},{"$f":"IF(E15=\"\",\"\",50+(10*(E15-AI15)/AJ15))","v":""},null,{"$f":"IF(E15=\"\",\"\",50+(10*(E15-AB15)/AC15))","v":""},{"$nulls":3},"Ekstraversjon",{"$nulls":7},"Gender: (1=male, 2=female):",{"$nulls":3},3.15,0.78,3.31,0.8,{"$f":"IF($T$16=1,X15,Z15)","v":3.15},{"$f":"IF($T$16=1,Y15,AA15)","v":0.78},null,3.2,0.7,3.31,0.73,{"$f":"IF($T$16=1,AE15,AG15)","v":3.2},{"$f":"IF($T$16=1,AF15,AH15)","v":0.7}]
[null,"Sociability",null,null,{"$f":"IF(A3=\"\",\"\",(A3+Q3+AF3+AU3)/4)","v":""},{"$f":"IF(E16=\"\",\"\",50+(10*(E16-AI16)/AJ16))","v":""},null,"",{"$nulls":4},"Sosiabilitet",{"$nulls":6},1,{"$nulls":3},2.8,1.02,3.1,1.07,{"$f":"IF($T$16=1,X16,Z16)","v":2.8},{"$f":"IF($T$16=1,Y16,AA16)","v":1.02},null,2.94,0.86,3.06,1.01,{"$f":"IF($T$16=1,AE16,AG16)","v":2.94},{"$f":"IF($T$16=1,AF16,AH16)","v":0.86}]
[null,"Assertiveness",null,null,{"$f":"IF(F3=\"\",\"\",(F3+V3+AK3+AZ3)/4)","v":""},{"$f":"IF(E17=\"\",\"\",50+(10*(E17-AI17)/AJ17))","v":""},null,"",{"$nulls":4},"Selvhevdelse",{"$nulls":10},3.28,0.92,3.28,0.93,3.28,0.92,null,3.27,0.82,3.28,0.85,3.27,0.82]
[null,"Energy Level",null,null,{"$f":"IF(L3=\"\",\"\",(L3+AA3+AP3+BE3)/4)","v":""},"",null,"",{"$nulls":4},"Energinivå",{"$nulls":10},3.37,0.88,3.56,0.89,3.37,0.88,null,3.4,0.8,3.58,0.72,3.4,0.8]
["Agreeableness","Agreeableness",null,null,{"$f":"IF(E20=\"\",\"\",(E20+E21+E22)/3)","v":""},"",null,"",{"$nulls":3},"Medmenneskelighet",{"$nulls":11},3.57,0.65,3.79,0.6,3.57,0.65,null,3.51,0.63,3.82,0.56,3.51,0.63]
[null,"Compassion",null,null,{"$f":"IF(B3=\"\",\"\",(B3+R3+AG3+AV3)/4)","v":""},"",null,"",{"$nulls":4},"Medfølelse",{"$nulls":10},3.72,0.79,3.97,0.76,3.72,0.79,null,3.6,0.81,3.98,0.69,3.6,0.81]
[null,"Respectfulness",null,null,{"$f":"IF(H3=\"\",\"\",(H3+W3+AL3+BA3)/4)","v":""},"",null,"",{"$nulls":4},"Respekt for andre",{"$nulls":10},3.87,0.73,4.08,0.68,3.87,0.73,null,3.76,0.68,4.05,0.64,3.76,0.68]
[null,"Trust",null,null,{"$f":"IF(M3=\"\",\"\",(M3+AB3+AQ3+BF3)/4)","v":""},"",null,"",{"$nulls":4},"Tilllitsfullhet",{"$nulls":10},3.13,0.83,3.32,0.8,3.13,0.83,null,3.15,0.77,3.43,0.77,3.15,0.77]
["Conscientiousness","Conscientiousness",null,null,{"$f":"IF(E24=\"\",\"\",(E24+E25+E26)/3)","v":""},"",null,"",{"$nulls":3},"Planmessighet",{"$nulls":11},3.35,0.74,3.5,0.79,3.35,0.74,null,3.34,0.6,3.54,0.66,3.34,0.6]
[null,"Organization",null,null,{"$f":"IF(C3=\"\",\"\",(C3+S3+AH3+AW3)/4)","v":""},"",null,"",{"$nulls":4},"Organisering",{"$nulls":10},3.33,0.99,3.51,1.03,3.33,0.99,null,3.46,0.88,3.68,0.87,3.46,0.88]
[null,"Productiveness",null,null,{"$f":"IF(I3=\"\",\"\",(I3+X3+AM3+BB3)/4)","v":""},"",null,"",{"$nulls":4},"Produktivitet",{"$nulls":10},3.31,0.87,3.43,0.93,3.31,0.87,null,3.24,0.75,3.39,0.8,3.24,0.75]
[null,"Responsibility",null,null,{"$f":"IF(N3=\"\",\"\",(N3+AC3+AR3+BG3)/4)","v":""},"",null,"",{"$nulls":4},"Ansvarsbevissthet",{"$nulls":10},3.4,0.78,3.57,0.83,3.4,0.78,null,3.33,0.6,3.55,0.71,3.33,0.6]
["Negative Emotionality","Negative Emotionality",null,null,{"$f":"IF(E28=\"\",\"\",(E28+E29+E30)/3)","v":""},"",null,"",{"$nulls":3},"Negativ emosjonalitet",{"$nulls":11},2.95,0.88,3.18,0.84,2.95,0.88,null,2.84,0.74,2.95,0.79,2.84,0.74]
[null,"Anxiety",null,null,{"$f":"IF(D3=\"\",\"\",(D3+T3+AI3+AX3)/4)","v":""},"",null,"",{"$nulls":4},"Angst",{"$nulls":10},3.28,0.95,3.58,0.88,3.28,0.95,null,3.2,0.78,3.53,0.85,3.2,0.78]
[null,"Depression",null,null,{"$f":"IF(J3=\"\",\"\",(J3+Y3+AN3+BC3)/4)","v":""},"",null,"",{"$nulls":4},"Depresjon",{"$nulls":10},2.82,1.03,2.88,1.02,2.82,1.03,null,2.65,0.92,2.53,0.93,2.65,0.92]
[null,"Emotional Volatility",null,null,{"$f":"IF(O3=\"\",\"\",(O3+AD3+AS3+BH3)/4)","v":""},"",null,"",{"$nulls":4},"Emosjonell ustabilitet",{"$nulls":10},2.77,1.04,3.09,1.04,2.77,1.04,null,2.66,0.91,2.79,0.97,2.66,0.91]
["Open-Mindedness","Open-Mindedness",null,null,{"$f":"IF(E32=\"\",\"\",(E32+E33+E34)/3)","v":""},"",null,"",{"$nulls":3},"Åpenhet",{"$nulls":11},3.93,0.64,3.91,0.67,3.93,0.64,null,3.71,0.65,3.62,0.63,3.71,0.65]
[null,"Intellectual Curiosity",null,null,{"$f":"IF(K3=\"\",\"\",(K3+Z3+AO3+BD3)/4)","v":""},"",null,"",{"$nulls":4},"Intellektuell nysgjerrighet",{"$nulls":10},4.18,0.69,4.03,0.71,4.18,0.69,null,3.89,0.76,3.8,0.7,3.89,0.76]
[null,"Aesthetic Sensitivity",null,null,{"$f":"IF(E3=\"\",\"\",(E3+U3+AJ3+AY3)/4)","v":""},"",null,"",{"$nulls":4},"Estestisk sensitivitet",{"$nulls":10},3.71,0.9,3.88,0.94,3.71,0.9,null,3.57,0.95,3.58,0.9,3.57,0.95]
[null,"Creative Imagination",null,null,{"$f":"IF(P3=\"\",\"\",(P3+AE3+AT3+BI3)/4)","v":""},"",null,"",{"$nulls":4},"Kreativ forestillingsevene",{"$nulls":10},3.89,0.81,3.82,0.8,3.89,0.81,null,3.68,0.75,3.46,0.77,3.68,0.75]
[]
[null,"*T-scores were calculated from the student sample norms, males (n=313) and females (n=146), presented in table 5 in Soto & John (2016). "]
[]
[{"$nulls":6},{"$f":"IF(SUM(A11:BH11)=0,\"\",IF(COUNT(A11:BH11)=60,\"\",\"Missing data analysis: \"& 60-COUNT(A11:BH11)&\" of the 60 items in the data input row are missing (blank cells)\"))","v":""}]

{"sheet":"about","index":1,"n_rows":6,"n_cols":4,"rows_kept":6}
[]
[null,"The BFI-2 scoring program was developed by clinical neuropsychologists Per-Ola Rike and Kristian Køhn in collaboration with Christopher Soto."]
[]
[null,"If you have any questions about the BFI-2 scoring program, please contact us."]
[null,"Per-Ola Rike",null,"perola.rike@gmail.com"]
[null,"Kristian Køhn: ",null,"krikoehn@gmail.com"]