{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Guidance","Know your donors tool","Multiple respondents","Multiple respondent Notes"],"not_rendered":{"charts":0,"images":4,"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":"Guidance","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["KNOW YOUR DONORS: \nTHE MONEY FOR GOOD UK DONOR SEGMENTATION TOOL"]
[]
["What is the donor allocation tool?"]
["Working with our research partners, Ipsos MORI, we have developed Know your donor: the Money for Good UK donor segmentation tool, so that you can easily identify your supporters’ donor type."]
["The tool is simple to use: donors answer 13 questions, and the tool allocates them to one of the seven segments based on their responses. We have also created shorter single segment tools which calculate whether or not a donor falls into a particular segment."]
["This tool makes insights from Money for Good UK open and accessible to the whole sector. It offers a straightforward way to apply and test the segmentation, so that individual charities can investigate how it might work for them in practice."]
["The level of confidence with which these tools allocate donors to segments varies by donor type, and depending on whether you use the main tool or the single segment tools. On the fourth worksheet of the main tool, you can see confidence levels, which Ipsos MORI considers very successful."]
[]
["How could you use the tool?"]
["There are a number of ways! You might want to use it when talking to individual donors to find out more about their preferences—either in person or on the phone. For this kind of activity, it is probably best to use the ‘Know your donors’ worksheet: this simply involves clicking your answers on the worksheet and pressing the calculate button at the end."]
["If you want to gather information from a large number of people—by sending the questions in a supporter survey, for example—the Multiple Respondents worksheet might be easier. All you do is collect the data in the right format, and then copy it into this sheet to calculate everyone’s donor type at once. For further instructions, please see the Multiple Respondents Notes."]
[]
["Help, the tool doesn’t seem to be working!"]
["This is an excel-based tool. If you can’t click the ‘calculate’ button, you may need to ‘enable macros’ by clicking on ‘enable content’ in the yellow security warning at the top of the screen."]
["On the ‘Know your Donor’ worksheet, you need to click the ‘calculate’ button before getting your result. Remember to reset the form by clicking ‘clear’ before you start using the tool with a new person."]
[]
["I want to know more about how it works"]
["The calculations for the donor segmentation tool can be seen in the hidden columns to the left and right of the questions (columns A to E, and K to AG on the Know your Donor worksheet). These have been hidden to make the tool easier to use but can be unhidden by clicking on the + sign at the top of the worksheet."]
["The donor allocation tool works using a shortened version of the original Money for Good UK questionnaire. The original questionnaire can be found in Appendix A of the Money for Good UK research. To find out more about how the original segmentation was conducted, see Ipsos MORI’s technical report."]
[]
["This is a summary of the full guidance note which can be found on the webpage at www.thinkNPC.org/know-your-donors/."]
[]
["Know your donors: The Money for Good UK donor segmentation tool is kindly supported by the Gates Foundation and Unity Trust Bank."]

{"sheet":"Know your donors tool","index":1,"n_rows":39,"n_cols":32,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,25,21,31],[19,25,19,31],[20,5,20,6],[25,5,25,6],[0,5,0,6],[2,5,2,6],[19,10,19,16],[21,10,21,16]]}
[null,null,null,null,null,"KNOW YOUR DONORS: \nTHE MONEY FOR GOOD UK DONOR SEGMENTATION TOOL"]
[]
[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)"]
[]
["(Code: A=1,B=0)",null,null,null,null,"Q1.  Pair 1                                                                                                          "]
[{"$f":"IF(B6=1,1,0)","v":0},0,null,null,null,null,"          "]
[{"$f":"IF(B7=1,1,0)","v":0},0,null,null,null,null,"       "]
[{"$f":"IF(B8=1,1,0)","v":0},0,null,null,null,"Q2. Pair 2"]
[{"$f":"IF(B9=1,1,0)","v":0},0]
[{"$f":"IF(B10=1,1,0)","v":0},0,null,null,null,null,"   "]
[null,null,null,null,null,"Q3. Pair 3"]
[]
[]
[null,null,null,null,null,"Q4. Pair 4"]
[]
[]
[null,null,null,null,null,"Q5. Pair 5"]
[null,null,null,null,null,null,null,null,null,"INTERNAL USE"]
[]
[null,null,null,null,null,null,null,null,null,null,"Segments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment"]
["(Code: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,null,"Loyal supporter","Ad-hoc giver","Good citizen","Faith-based donor","Engaged champion","Benefactor","Thoughtful philanthropist",null,null,null,null,null,null,null,null,"Loyal supporter","Ad-hoc giver","Good citizen","Faith-based donor","Engaged champion","Benefactor","Thoughtful philanthropist"]
[{"$f":"B22","v":0},0,null,null,null,"Q6. \"Ability to get involved with the organisation\"",null,null,null,null,"Fisher's scores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability of segment membership"]
[{"$f":"B23","v":0},0,null,null,null,"Q7. \"How often the organisation asks me for money\"",null,null,null,"Qs",{"$f":"SUMPRODUCT($A6:$A10,K24:K28)+SUMPRODUCT($A22:$A23,K29:K30)+SUMPRODUCT($A27:$A29,K31:K33)+SUMPRODUCT($A32:$A33,K34:K35)+SUMPRODUCT($A36,K36)+K37","v":-25.225999999999999},{"$f":"SUMPRODUCT($A6:$A10,L24:L28)+SUMPRODUCT($A22:$A23,L29:L30)+SUMPRODUCT($A27:$A29,L31:L33)+SUMPRODUCT($A32:$A33,L34:L35)+SUMPRODUCT($A36,L36)+L37","v":-31.571000000000002},-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,{"$f":"EXP(K23)","v":1.1078664215998557E-11},{"$f":"EXP(L23)","v":1.9448625416834153E-14},6.1386583525307757E-13,4.9763757242977547E-20,4.5994953037459339E-17,1.2422777390049634E-17,1.372929229321057E-17,{"$f":"SUM(R23:X23)","v":1.1712050873454946E-11},{"$f":"R23/$Y$23","v":0.94592008997399912},{"$f":"S23/$Y$23","v":1.6605653123411503E-3},5.2413180397328042E-2,4.2489362265122835E-9,3.9271476477023925E-6,1.0606833529220344E-6,1.1722363949364026E-6]
[null,null,null,null,null,null,null,null,null,"Q1  pair5_12 ",9.2989999999999995,10.616,1.7849999999999999,9.6129999999999995,10.349,7.944,10.18]
[null,null,null,null,null,null,null,null,null,"Q2  pair1_10",0.17299999999999999,4.5510000000000002,2.798,0.95699999999999996,-0.11899999999999999,2.7749999999999999,1.0820000000000001]
["(Code=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,null,"Q3  pair7_11",6.4000000000000001E-2,1.36,1.2370000000000001,1.623,1.528,0.66500000000000004,0.77200000000000002]
[{"$f":"B27","v":0},0,null,null,null,"Q8. Your family",null,null,null,"Q4  pair6_8",-0.92,-0.83799999999999997,-9.8000000000000004E-2,28.988,-1.397,3.8490000000000002,0.45300000000000001]
[{"$f":"B28","v":0},0,null,null,null,"Q9. Being part of you local community",null,null,null,"Q5  pair4_11",0.80700000000000005,0.94,1.1830000000000001,0.11600000000000001,0.22700000000000001,14.657999999999999,0.52600000000000002]
[{"$f":"B29","v":0},0,null,null,null,"Q10. Your level of income",null,null,null,"Q6  r12_3",1.7010000000000001,1.514,1.613,2.036,2.5310000000000001,1.9610000000000001,2.0070000000000001]
[null,null,null,null,null,null,null,null,null,"Q7  r12_9",2.2429999999999999,2.14,2.2010000000000001,2.0609999999999999,2.706,2.3650000000000002,2.391]
["(Code: NO=0, YES=1)",null,null,null,null,null,null,null,null,"Q8  r1_4",2.7120000000000002,2.9359999999999999,2.823,3.0880000000000001,3.1520000000000001,2.6920000000000002,2.899]
[{"$f":"IF(B32=2,1,0)","v":0},0,null,null,null,"Q11. Have you used an ongoing direct debit or standing order to make a donation to charity in the past year",null,null,null,"Q9  r1_5",1.4450000000000001,1.5620000000000001,1.798,1.702,2.0859999999999999,1.8759999999999999,1.6719999999999999]
[{"$f":"IF(B33=2,1,0)","v":0},0,null,null,null,"Q12. Have you used Gift of Assets to make a donation to charity in the past year",null,null,null,"Q10 r1_6",1.669,1.976,2.0129999999999999,1.766,2.13,2.1179999999999999,1.833]
[null,null,null,null,null,null,null,null,null,"Q11  d4_3",1.871,0.61699999999999999,0.85499999999999998,1.278,0.60899999999999999,0.77,0.98099999999999998]
["(Code: 1,2,3,4,5, where 5 = \"Strongly agree\")",null,null,null,null,null,null,null,null,"Q12  d4_13",0.439,0.19800000000000001,1.57,-0.2,-5.3999999999999999E-2,0.90600000000000003,18.940000000000001]
[{"$f":"B36","v":0},0,null,null,null,"Q13.  To what extent do you agree or disagree with the following statement: \" I like to be seen as a role model \"",null,null,null,"Q13  r2_2",2.9590000000000001,3.5539999999999998,3.7490000000000001,3.012,3.681,3.605,3.637]
[null,null,null,null,null,null,null,null,null,"(Constant)",-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998]
[]
[null,{"$f":"IF(MAX(K23:Q23)=K23,\"Loyal supporter\",IF(MAX(K23:Q23)=L23,\"Ad-hoc giver\",IF(MAX(K23:Q23)=M23,\"Good citizen\",IF(MAX(K23:Q23)=N23,\"Faith-based donor\",IF(MAX(K23:Q23)=O23,\"Engaged champion\",IF(MAX(K23:Q23)=P23,\"Benefactor\",IF(MAX(K23:Q23)=Q23,\"Thoughtful philanthropist\",\"\")))))))","v":"Loyal supporter"}]

{"sheet":"Multiple respondents","index":2,"n_rows":103,"n_cols":63,"rows_kept":103,"cut":false,"hidden":false,"merged":[[0,9,0,16]]}
[null,null,"Most frequent activities",null,"Pairwise comparisons",null,null,null,null,"Segmentation questions"]
["Question Statements",null,null,null,"Q1. The charity deals with a cause that has had a direct impact on me or someone close to me  vs.  Someone in my position ought to give to charity","A friend, colleague, or family member asks me to give / sponsor them  vs. I can see the difference my money makes","The organisation works in my local community  vs.               This organisation focuses on a neglected or under-funded issue","My giving is driven by my religious beliefs  vs.                           The organisation has more impact than others on the cause that I care about","Tax incentives encourage me to give  vs.  This organisation focues on a neglected or under-funded issue","How much attention do you pay to \"Ability to get involved with the organisation\" when giving to charity","How much attention do you pay to \"How often the organisation asks me for money\" when giving to charity","How important is your family to your sense of who you are? ","How important is being part of your local community to your sense of who you are?","How important is your level of income to your sense of who you are? ","Have you used an going DD or standing order to make a donation to charity in the past year","Have you used Gift of Assets to make a donation to charity in the past year","To what extent do you agree or disagree with the following statement: \" I like to be seen as a role model \""]
["Code","Respondent unique reference ",null,null,"Q1. Pair 1","Q2. Pair 2","Q3. pair 3","Q4. Pair 4","Q5. Pair 5","Q6","Q7","Q8","Q9","Q10","Q11","Q12","Q13","pair5_12 ","pair1_10","pair7_11","pair6_8","pair4_11","r12_3","r12_9","r1_4","r1_5","r1_6","d4_3","d4_13","r2_2",null,"Loyal supporter","Ad-hoc giver","Good citizen","Faith-based donor","Engaged champion","Benefactor","Thoughtful philanthropist","Segment",null,null,"Segment Allocation"]
[1,"EXAMPLE",1,0,1,1,0,0,0,2,2,5,3,4,0,0,3,{"$f":"E4","v":1},{"$f":"F4","v":1},{"$f":"G4","v":0},{"$f":"H4","v":0},{"$f":"I4","v":0},{"$f":"J4","v":2},{"$f":"K4","v":2},{"$f":"L4","v":5},{"$f":"M4","v":3},{"$f":"N4","v":4},{"$f":"O4","v":0},{"$f":"P4","v":0},{"$f":"Q4","v":3},null,{"$f":"SUMPRODUCT($AX$6:$BJ$6,R4:AD4)+ $BK$6","v":25.582000000000008},{"$f":"SUMPRODUCT($AX$7:$BJ$7,R4:AD4)+ $BK$7","v":28.836000000000002},{"$f":"SUMPRODUCT($AX$8:$BJ$8,R4:AD4)+ $BK$8","v":22.9},{"$f":"SUMPRODUCT($AX$9:$BJ$9,R4:AD4)+ $BK$9","v":10.963000000000001},{"$f":"SUMPRODUCT($AX$10:$BJ$10,R4:AD4)+ $BK$10","v":24.666999999999987},{"$f":"SUMPRODUCT($AX$11:$BJ$11,R4:AD4)+ $BK$11","v":18.819000000000003},{"$f":"SUMPRODUCT($AX$12:$BJ$12,R4:AD4)+ $BK$12","v":18.984999999999999},{"$f":"IF(MAX(AF4:AL4)=AF4,\"Loyal supporter\",IF(MAX(AF4:AL4)=AG4,\"Ad-hoc giver\",IF(MAX(AF4:AL4)=AH4,\"Good citizen\",IF(MAX(AF4:AL4)=AI4,\"Faith-based donor\",IF(MAX(AF4:AL4)=AJ4,\"Engaged champion\",IF(MAX(AF4:AL4)=AK4,\"Benefactor\",IF(MAX(AF4:AL4)=AL4,\"Thoughtful philanthropist\",\"\")))))))","v":"Ad-hoc giver"},null,null,{"$f":"AM4","v":"Ad-hoc giver"}]
[{"$f":"A4+1","v":2},null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUMPRODUCT($AX$6:$BJ$6,R5:AD5)+ $BK$6","v":-25.225999999999999},{"$f":"SUMPRODUCT($AX$7:$BJ$7,R5:AD5)+ $BK$7","v":-31.571000000000002},{"$f":"SUMPRODUCT($AX$8:$BJ$8,R5:AD5)+ $BK$8","v":-28.119},-44.447000000000003,{"$f":"SUMPRODUCT($AX$10:$BJ$10,R5:AD5)+ $BK$10","v":-37.618000000000002},-38.927,-38.826999999999998,{"$f":"IF(MAX(AF5:AL5)=AF5,\"Loyal supporter\",IF(MAX(AF5:AL5)=AG5,\"Ad-hoc giver\",IF(MAX(AF5:AL5)=AH5,\"Good citizen\",IF(MAX(AF5:AL5)=AI5,\"Faith-based donor\",IF(MAX(AF5:AL5)=AJ5,\"Engaged champion\",IF(MAX(AF5:AL5)=AK5,\"Benefactor\",IF(MAX(AF5:AL5)=AL5,\"Thoughtful philanthropist\",\"\")))))))","v":"Loyal supporter"},null,null,{"$f":"AM5","v":"Loyal supporter"},"Population summary","Freq","%",null,null,null,null,"pair5_12 ","pair1_10","pair7_11","pair6_8","pair4_11","r12_3","r12_9","r1_4","r1_5","r1_6","d4_3","d4_13","r2_2","(Constant)"]
[{"$f":"A5+1","v":3},null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Loyal supporter",{"$f":"COUNTIFS(AP:AP,AQ6)","v":99},{"$f":"AR6/SUM($AR$6:$AR$12)","v":0.99},null,null,null,{"$f":"SUMPRODUCT($R$4:$AD$4,AX6:BJ6)+BK6","v":25.582000000000008},9.2989999999999995,0.17299999999999999,6.4000000000000001E-2,-0.92,0.80700000000000005,1.7010000000000001,2.2429999999999999,2.7120000000000002,1.4450000000000001,1.669,1.871,0.439,2.9590000000000001,-25.225999999999999]
[4,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Ad-hoc giver",{"$f":"COUNTIFS(AP:AP,AQ7)","v":1},{"$f":"AR7/SUM($AR$6:$AR$12)","v":0.01},null,null,null,28.836000000000002,10.616,4.5510000000000002,1.36,-0.83799999999999997,0.94,1.514,2.14,2.9359999999999999,1.5620000000000001,1.976,0.61699999999999999,0.19800000000000001,3.5539999999999998,-31.571000000000002]
[5,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Good citizen",0,0,null,null,null,22.9,1.7849999999999999,2.798,1.2370000000000001,-9.8000000000000004E-2,1.1830000000000001,1.613,2.2010000000000001,2.823,1.798,2.0129999999999999,0.85499999999999998,1.57,3.7490000000000001,-28.119]
[6,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Faith-based donor",0,0,null,null,null,10.963000000000001,9.6129999999999995,0.95699999999999996,1.623,28.988,0.11600000000000001,2.036,2.0609999999999999,3.0880000000000001,1.702,1.766,1.278,-0.2,3.012,-44.447000000000003]
[7,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Engaged champion",0,0,null,null,null,24.666999999999987,10.349,-0.11899999999999999,1.528,-1.397,0.22700000000000001,2.5310000000000001,2.706,3.1520000000000001,2.0859999999999999,2.13,0.60899999999999999,-5.3999999999999999E-2,3.681,-37.618000000000002]
[8,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Benefactor",0,0,null,null,null,18.819000000000003,7.944,2.7749999999999999,0.66500000000000004,3.8490000000000002,14.657999999999999,1.9610000000000001,2.3650000000000002,2.6920000000000002,1.8759999999999999,2.1179999999999999,0.77,0.90600000000000003,3.605,-38.927]
[9,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter","Thoughtful philanthropist",0,0,null,null,null,18.984999999999999,10.18,1.0820000000000001,0.77200000000000002,0.45300000000000001,0.52600000000000002,2.0070000000000001,2.391,2.899,1.6719999999999999,1.833,0.98099999999999998,18.940000000000001,3.637,-38.826999999999998]
[10,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[11,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[12,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[13,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[14,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[15,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[16,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[17,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[18,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[19,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[20,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[21,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[22,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[23,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[24,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[25,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[26,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[27,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[28,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[29,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[30,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[31,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[32,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[33,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E36","v":0},{"$f":"F36","v":0},{"$f":"G36","v":0},{"$f":"H36","v":0},{"$f":"I36","v":0},{"$f":"J36","v":0},{"$f":"K36","v":0},{"$f":"L36","v":0},{"$f":"M36","v":0},{"$f":"N36","v":0},{"$f":"O36","v":0},{"$f":"P36","v":0},{"$f":"Q36","v":0},null,{"$f":"SUMPRODUCT($AX$6:$BJ$6,R36:AD36)+ $BK$6","v":-25.225999999999999},{"$f":"SUMPRODUCT($AX$7:$BJ$7,R36:AD36)+ $BK$7","v":-31.571000000000002},{"$f":"SUMPRODUCT($AX$8:$BJ$8,R36:AD36)+ $BK$8","v":-28.119},{"$f":"SUMPRODUCT($AX$9:$BJ$9,R36:AD36)+ $BK$9","v":-44.447000000000003},{"$f":"SUMPRODUCT($AX$10:$BJ$10,R36:AD36)+ $BK$10","v":-37.618000000000002},{"$f":"SUMPRODUCT($AX$11:$BJ$11,R36:AD36)+ $BK$11","v":-38.927},{"$f":"SUMPRODUCT($AX$12:$BJ$12,R36:AD36)+ $BK$12","v":-38.826999999999998},"Loyal supporter",null,null,"Loyal supporter"]
[34,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[35,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[36,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[37,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[38,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[39,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[40,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[41,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[42,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[43,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[44,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[45,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[46,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[47,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[48,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[49,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[50,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[51,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[52,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[53,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[54,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[55,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[56,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[57,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[58,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[59,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[60,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[61,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[62,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[63,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[64,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[65,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E68","v":0},{"$f":"F68","v":0},{"$f":"G68","v":0},{"$f":"H68","v":0},{"$f":"I68","v":0},{"$f":"J68","v":0},{"$f":"K68","v":0},{"$f":"L68","v":0},{"$f":"M68","v":0},{"$f":"N68","v":0},{"$f":"O68","v":0},{"$f":"P68","v":0},{"$f":"Q68","v":0},null,{"$f":"SUMPRODUCT($AX$6:$BJ$6,R68:AD68)+ $BK$6","v":-25.225999999999999},{"$f":"SUMPRODUCT($AX$7:$BJ$7,R68:AD68)+ $BK$7","v":-31.571000000000002},{"$f":"SUMPRODUCT($AX$8:$BJ$8,R68:AD68)+ $BK$8","v":-28.119},{"$f":"SUMPRODUCT($AX$9:$BJ$9,R68:AD68)+ $BK$9","v":-44.447000000000003},{"$f":"SUMPRODUCT($AX$10:$BJ$10,R68:AD68)+ $BK$10","v":-37.618000000000002},{"$f":"SUMPRODUCT($AX$11:$BJ$11,R68:AD68)+ $BK$11","v":-38.927},{"$f":"SUMPRODUCT($AX$12:$BJ$12,R68:AD68)+ $BK$12","v":-38.826999999999998},"Loyal supporter",null,null,"Loyal supporter"]
[66,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,{"$f":"IF(MAX(AF69:AL69)=AF69,\"Loyal supporter\",IF(MAX(AF69:AL69)=AG69,\"Ad-hoc giver\",IF(MAX(AF69:AL69)=AH69,\"Good citizen\",IF(MAX(AF69:AL69)=AI69,\"Faith-based donor\",IF(MAX(AF69:AL69)=AJ69,\"Engaged champion\",IF(MAX(AF69:AL69)=AK69,\"Benefactor\",IF(MAX(AF69:AL69)=AL69,\"Thoughtful philanthropist\",\"\")))))))","v":"Loyal supporter"},null,null,{"$f":"AM69","v":"Loyal supporter"}]
[{"$f":"A69+1","v":67},null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[68,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[69,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[70,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[71,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[72,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[73,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[74,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[75,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[76,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[77,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[78,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[79,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[80,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[81,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[82,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[83,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[84,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[85,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[86,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[87,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[88,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[89,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[90,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[91,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[92,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[93,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[94,null,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[95,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[96,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[97,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[98,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[99,null,0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E103","v":0},{"$f":"F103","v":0},0,0,0,0,0,0,0,0,0,0,0,null,-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998,"Loyal supporter",null,null,"Loyal supporter"]

{"sheet":"Multiple respondent Notes","index":3,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,7],[3,0,3,7],[2,0,2,7],[4,0,4,7],[10,0,10,7],[8,0,8,7],[6,0,6,7],[5,0,5,7],[7,0,7,7],[9,0,9,7],[12,0,12,7],[19,0,19,7],[20,0,20,7],[11,0,11,7],[13,0,13,7],[14,0,14,7],[21,0,21,7],[40,0,40,7],[41,0,41,7],[15,0,15,7],[16,0,16,7]]}
["MULTIPLE RESPONDENT WORKSHEET NOTES"]
[]
["Coding:"]
["When collecting respondses to the questions, use the following codes"]
["Responses to the paired qs are coded as A=1, B = 0"]
["For questions Q6 and Q7, the values range from 1 - 5 with 5=\"I pay extremely close attention\""]
["For questions Q8 to Q10, the values range from 1-5 with 5=\"Very Important\""]
["Responses to Q11 and Q12 are coded as 0=No and 1=Yes"]
["For question 13, the values range from 1 - 5, with 5=\"Strongly agree\""]
[]
["Data inputting and segment allocation:"]
["Follow the following steps when inputting data into the 'Multiple Respondents' worksheet"]
["For each record, copy and paste the answers to questions (the qs are in row 2) into columns E,F,G,H,I,J,K,L,M,N,O,P and Q"]
["Currently, the formulae to calculate a segment for each respodent applies to only 100 rows of data, if additional rows of data are to be inputted, then the formulae should be copied by  \"dragging\" the mouse from columns R103-AM103 downwards"]
["Where  cells contain the formula for allocating respondents to segments but no data is inputted, the default response is 'Loyal Supporter'. This is because with no data, the calculation picks up the highest constant, which is the Loyal Supporter constant."]
["The 'Population summary' (in columns AQ, AR, AS) indicates what proportion of the population is in each of the segments. To remove the default 'Loyal supporter' entries from this calculation, delete all unused cells containing the formula for allocating to segments."]
["Further calculation details can be found in hidden columns R-AN. "]
[]
[]
["Discriminant function coefficients"]
["The formula for allocating donors to segments uses the following discriminant function coefficients."]
["These coefficients indivate the relative weighting of different factors in allocating individuals to the different segments."]
[]
["Qs","Loyal supporter","Ad-hoc giver","Good citizen","Faith-based donor","Engaged champion","Benefactor","Thoughtful philanthropist"]
["Pair 1",9.2989999999999995,10.616,1.7849999999999999,9.6129999999999995,10.349,7.944,10.18]
["Pair 2",0.17299999999999999,4.5510000000000002,2.798,0.95699999999999996,-0.11899999999999999,2.7749999999999999,1.0820000000000001]
["Pair 3",6.4000000000000001E-2,1.36,1.2370000000000001,1.623,1.528,0.66500000000000004,0.77200000000000002]
["Pair 4",-0.92,-0.83799999999999997,-9.8000000000000004E-2,28.988,-1.397,3.8490000000000002,0.45300000000000001]
["Pair 5",0.80700000000000005,0.94,1.1830000000000001,0.11600000000000001,0.22700000000000001,14.657999999999999,0.52600000000000002]
["Q6",1.7010000000000001,1.514,1.613,2.036,2.5310000000000001,1.9610000000000001,2.0070000000000001]
["Q7",2.2429999999999999,2.14,2.2010000000000001,2.0609999999999999,2.706,2.3650000000000002,2.391]
["Q8",2.7120000000000002,2.9359999999999999,2.823,3.0880000000000001,3.1520000000000001,2.6920000000000002,2.899]
["Q9",1.4450000000000001,1.5620000000000001,1.798,1.702,2.0859999999999999,1.8759999999999999,1.6719999999999999]
["Q10",1.669,1.976,2.0129999999999999,1.766,2.13,2.1179999999999999,1.833]
["Q11",1.871,0.61699999999999999,0.85499999999999998,1.278,0.60899999999999999,0.77,0.98099999999999998]
["Q12",0.439,0.19800000000000001,1.57,-0.2,-5.3999999999999999E-2,0.90600000000000003,18.940000000000001]
["Q13",2.9590000000000001,3.5539999999999998,3.7490000000000001,3.012,3.681,3.605,3.637]
["Constant",-25.225999999999999,-31.571000000000002,-28.119,-44.447000000000003,-37.618000000000002,-38.927,-38.826999999999998]
[]
[]
["Confidence levels"]
["Percentage of respondents from original survey correctly classified using the Know your Donor tool, and the single segment tools."]
[]
[null,"% Correctly classified using 'Know your Donors' allocation tool","% Correctly classified using 'Single segments' allocation tool"]
["Loyal supporter",64.2,61.9]
["Ad-hoc giver",66.900000000000006,71.7]
["Good citizen",64,81.8]
["Faith-based donor",95,92.5]
["Engaged champion",68.8,54.7]
["Benefactor",67.099999999999994,91]
["Thoughtful philanthropist",61.2,99.5]
["Overall",68.2]