{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Loyal supporter"],"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":"Loyal supporter","index":0,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,5,0,6],[15,5,15,6],[19,5,19,6],[16,11,16,12],[16,14,16,15],[1,5,1,6],[3,5,3,6],[14,9,14,10],[14,14,14,15],[14,11,14,12]]}
[null,null,null,null,null,"KNOW YOUR DONORS: \nTHE MONEY FOR GOOD UK DONOR SEGMENTATION TOOL"]
[null,null,null,null,null,"LOYAL SUPPORTER"]
[]
[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)"]
[]
["(Coding: B=0,A=1)",null,null,null,null,"Q1.  Pair 1                                                                                                          "]
[{"$f":"IF(B7=1,1,0)","v":0},0,null,null,null,null,"          "]
[0,0,null,null,null,null,"       "]
[0,0,null,null,null,"Q2. Pair 2"]
[]
[null,null,null,null,null,null,"   "]
[null,null,null,null,null,"Q3. Pair 3"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Segments",null,"Segments",null,null,"Segments"]
["(Coding: 1,2,3,4,5 where 5= \"I pay extremely close attention to this\"",null,null,null,null,"How much attention, if any, do you pay to each of the following when giving to charity?",null,null,null,"Other","Loyal supporter","Other","Loyal supporter",null,"Other","Loyal supporter"]
[{"$f":"B17","v":0},0,null,null,null,"Q4. \"Ability to get involved with the organisation\"",null,null,null,"Fisher's scores",null,"Exp score",null,"Sum of exp scores","Probability of group membership"]
[null,null,null,null,null,null,null,null,"Questions",{"$f":"SUMPRODUCT($A7:$A9,J19:J21)+SUMPRODUCT($A17,J22)+SUMPRODUCT($A21:$A22,J23:J24)+SUMPRODUCT($A25:$A26,J25:J26)+SUMPRODUCT($A29,J27)+J28","v":-19.63},{"$f":"SUMPRODUCT($A7:$A9,K19:K21)+SUMPRODUCT($A17,K22)+SUMPRODUCT($A21:$A22,K23:K24)+SUMPRODUCT($A25:$A26,K25:K26)+SUMPRODUCT($A29,K27)+K28","v":-14},{"$f":"EXP(J18)","v":2.9840034453430037E-9},{"$f":"EXP(K18)","v":8.3152871910356788E-7},{"$f":"SUM(L18:M18)","v":8.3451272254891091E-7},{"$f":"L18/N18","v":3.5757435024222901E-3},{"$f":"M18/N18","v":0.99642425649757771}]
[null,null,null,null,null,null,null,null,"Q1   pair1_11",3.65,1.7190000000000001]
["(Coding: 1,2,3,4,5, where 5=Very important)",null,null,null,null,"For each statement please select how important it is to your sense of who you are",null,null,"Q2   pair7_9",1.494,0.184]
[{"$f":"B21","v":0},0,null,null,null,"Q5. \"Your occupation\"",null,null,"Q3    pair5_8",3.4359999999999999,2.1749999999999998]
[{"$f":"B22","v":0},0,null,null,null,"Q6. \"Being part of your local community\"",null,null,"Q4    r12_3",1.6180000000000001,1.284]
[null,null,null,null,null,null,null,null,"Q5    r1_2",2.0310000000000001,1.663]
["(Coding: 0=NO, 1=YES)",null,null,null,null,null,null,null,"Q6    r1_5",2.9380000000000002,2.3809999999999998]
[{"$f":"IF(B25=2,1,0)","v":0},0,null,null,null,"Q7. Have you used an going direct debit or standing order to make a donation to charity in the past year?",null,null,"Q7    d4_3",1.0549999999999999,2.19]
[{"$f":"IF(B26=2,1,0)","v":0},0,null,null,null,"Q8. Have you used Gift of Assets to make a donation to charity in the past year?",null,null,"Q8    d4_13",1.8520000000000001,0.42299999999999999]
[null,null,null,null,null,null,null,null,"Q9    r2_2",3.419,2.786]
["(Coding: 1,2,3,4,5, where 5=Strongly agree)",null,null,null,null,null,null,null,"(Constant)",-19.63,-14]
[{"$f":"B29","v":0},0,null,null,null,"Q9. To what extent do you agree or disagree with the following statement: \" I like to be seen as a role model \""]
[]
[]
[null,{"$f":"IF(MAX(J18:K18)=J18,\"Other segments\",IF(MAX(J18:K18)=K18,\"Loyal supporter\",\"\"))","v":"Loyal supporter"}]