{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Benefactor"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Benefactor","index":0,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,5,18,6],[14,5,14,6],[1,5,1,6],[3,5,3,6],[5,9,5,10],[3,9,3,10],[3,14,3,15],[5,14,5,15],[0,5,0,6]]}
[null,null,null,null,null,"KNOW YOUR DONORS: \nTHE MONEY FOR GOOD UK DONOR SEGMENTATION TOOL"]
[null,null,null,null,null,"BENEFACTOR"]
[]
[null,null,null,null,null,"You will now see some reasons that other people have given for donating to charity.  We will show them to you in pairs.   For each pair of reasons please give the one which would be most important to you of the pair (even if neither are very important to you at all)",null,null,null,"segments",null,null,null,null,"segments"]
[null,null,null,null,null,null,null,null,null,"Other segments","Benefactor",null,null,null,"Other segments","Benefactor"]
["(Code: A=1,B=0)",null,null,null,null,"Q1.  Pair 1                                                                                                          ",null,null,null,"Fisher's score",null,null,null,null,"Probability of group membership"]
[{"$f":"IF(B7=1,1,0)","v":0},0,null,null,null,null,"          ",null,"Qs",{"$f":"SUMPRODUCT($A7:$A9,J8:J10)+SUMPRODUCT($A16,J11)+SUMPRODUCT($A20,J12)+SUMPRODUCT($A21,J13)+J14","v":-29.164999999999999},{"$f":"SUMPRODUCT($A7:$A9,K8:K10)+SUMPRODUCT($A16,K11)+SUMPRODUCT($A20,K12)+SUMPRODUCT($A21,K13)+K14","v":-35.067999999999998},{"$f":"EXP(J7)","v":2.1567580877156074E-13},{"$f":"EXP(K7)","v":5.8906213702945656E-16},{"$f":"SUM(L7:M7)","v":2.162648709085902E-13},{"$f":"L7/N7","v":0.99727620054725186},{"$f":"M7/N7","v":2.7237994527481006E-3}]
[{"$f":"IF(B8=1,1,0)","v":0},0,null,null,null,null,"       ",null,"Q1   pair4_8",8.2349999999999994,34.898000000000003]
[{"$f":"IF(B9=1,1,0)","v":0},0,null,null,null,"Q2. Pair 2",null,null,"Q2   pair3_4",58.35,34.872999999999998]
[null,null,null,null,null,null,null,null,"Q3   pair4_11",3.4460000000000002,10.71]
[null,null,null,null,null,null,"   ",null,"Q4   r2_7",2.4700000000000002,3.0190000000000001]
[null,null,null,null,null,"Q3. Pair 3",null,null,"Q5   d4_5",1.399,0.35]
[null,null,null,null,null,null,null,null,"Q6   d4_13",2.5819999999999999,0.64300000000000002]
[null,null,null,null,null,null,null,null,"(Constant)",-33.146000000000001,-36.061]
["(Code: 1,2,3,4,5, where 5= \"Strongly agree\")",null,null,null,null,"To what extent do you agree or disagree with the following statement:"]
[{"$f":"B16","v":0},0,null,null,null,"Q4.  \"I like to stand out from the crowd\""]
[]
[]
["(Code:NO=0,YES=1)",null,null,null,null,"Which, if any, of the following methods have you used to make a donation to any charity in the past 12 months?"]
[{"$f":"IF(B20=1,0,1)","v":1},0,null,null,null,"Q5. Collection at place of worship"]
[{"$f":"IF(B21=1,0,1)","v":1},0,null,null,null,"Q6. Gift of Assest"]
[]
[]
[null,{"$f":"IF(MAX(J7:K7)=J7,\"Other segments\",IF(MAX(J7:K7)=K7,\"Benefactor\",\"\"))","v":"Other segments"}]