{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ad hoc giver "],"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":"Ad hoc giver ","index":0,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[19,5,19,6],[0,5,0,6],[3,5,3,6],[14,10,14,11],[16,10,16,11],[16,15,16,16],[14,15,14,16],[1,5,1,6],[15,5,15,6]]}
[null,null,null,null,null,"KNOW YOUR DONORS: \nTHE MONEY FOR GOOD UK DONOR SEGMENTATION TOOL"]
[null,null,null,null,null,"AD HOC GIVER"]
[]
[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: A=1,B=0)",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,null,"SEGMENTS",null,null,null,null,"SEGMENTS"]
["(Coding:1,2,3,4,5, where 5=\"I pay extremely 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,null,"Other segments","Ad-hoc giver",null,null,null,"Other segments","Ad-hoc giver"]
[{"$f":"B17","v":0},0,null,null,null,"Q4. \"Regular progress reports on the organisation’s work\"",null,null,null,null,"Fisher's score",null,null,null,null,"Probability of group membership"]
[{"$f":"B18","v":0},0,null,null,null,"Q5. \"How the organisation will use my donation\"",null,null,null,null,{"$f":"SUMPRODUCT($A7:$A9,K20:K22)+SUMPRODUCT($A17:$A18,K23:K24)+SUMPRODUCT($A21:$A22,K25:K26)+SUMPRODUCT($A25,K27)+K28","v":-19.486000000000001},{"$f":"SUMPRODUCT($A7:$A9,L20:L22)+SUMPRODUCT($A17:$A18,L23:L24)+SUMPRODUCT($A21:$A22,L25:L26)+SUMPRODUCT($A25,L27)+L28","v":-23.542000000000002},{"$f":"EXP(K18)","v":3.4461781588102201E-9},{"$f":"EXP(L18)","v":5.9681441888189867E-11},{"$f":"SUM(M18:N18)","v":3.5058596006984101E-9},{"$f":"M18/O18","v":0.98297665945427459},{"$f":"N18/O18","v":1.702334054572539E-2}]
[null,null,null,null,null,null,null,null,null,"Qs"]
["(Coding: 0=NO, 1=YES)",null,null,null,null,"Which of the following methods have you used to make a donation to any charity in the past 12 months?",null,null,null,"Q1   pair1_10",3.5139999999999998,6.1529999999999996]
[{"$f":"IF(B21=2,1,0)","v":0},0,null,null,null,"Q6. Sponsored someone",null,null,null,"Q2   pair1_11",1.9,4.2910000000000004]
[{"$f":"IF(B22=2,1,0)","v":0},0,null,null,null,"Q7. Gift of Assets ",null,null,null,"Q3   pair3_12",14.923999999999999,18.28]
[null,null,null,null,null,null,null,null,null,"Q4   r12_2",1.5860000000000001,1.18]
["(Coding: 1,2,3,4, where 4= Yes, at least once a week)",null,null,null,null,null,null,null,null,"Q5   r12_6",3.7469999999999999,3.3340000000000001]
[{"$f":"B25","v":0},0,null,null,null,"Q8. Have you volunteered or donated time to a charitable cause in the past 12 months?",null,null,null,"Q6   d4_2",1.79,2.7080000000000002]
[null,null,null,null,null,null,null,null,null,"Q7   d4_13",1.2529999999999999,-0.28699999999999998]
[null,null,null,null,null,null,null,null,null,"Q8   d6",1.5329999999999999,1.0720000000000001]
[null,{"$f":"IF(MAX(K18:L18)=K18,\"Other segments\",IF(MAX(K18:L18)=L18,\"Ad-hoc giver\",\"\"))","v":"Other segments"},null,null,null,null,null,null,null,"(Constant)",-19.486000000000001,-23.542000000000002]