{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Columns","Static"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":"Columns","index":0,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[[49,9,49,13]]}
[]
[null,null,null,null,null,null,null,null,null,"JustGiving Gift Aid report manager v2.5"]
[]
[]
["Include (Y/N)","Column Name","Rename Column",null,"Include","Pre v2.0 Column Name","Column Order","Column Address",null,"Instructions"]
["Y","Fundraiser User Id",null,null,"Y","Fundraiser User Id",1,1]
["N","Fundraiser Title",null,null,"Y","Fundraiser Title",2,2,"Step 1:","You need to enable macros for this sheet"]
["Y","Fundraiser FirstName",null,null,"Y","Fundraiser Firstname",3,3,null,"Do this by clicking on the office button (top left hand side) > Trust Center > Trust Center settings "]
["Y","Fundraiser LastName",null,null,"Y","Fundraiser Lastname",4,4,null,"> Macro settings > Enable all macros"]
["N","Fundraiser Address Line 1",null,null,"Y","Fundraiser Address Line 1",5,5]
["N","Fundraiser Address Line 2",null,null,"Y","Fundraiser Address Line 2",6,6]
["N","Fundraiser Town",null,null,"Y","Fundraiser Town",7,7,"Step 2:","Select which columns you'd like to appear by typing Y or N next to them"]
["N","Fundraiser County",null,null,"Y","Fundraiser County",8,8]
["N","Fundraiser Postcode",null,null,"Y","Fundraiser Postcode",9,9,"Step 3:","Rename any columns that need to have different names to match up to your own database"]
["N","Fundraiser Country",null,null,"Y","Fundraiser Country",10,10]
["Y","Fundraiser E-mail",null,null,"Y","Fundraiser E-mail",11,11,"Step 4:","Save this sheet, giving it a memorable name for the settings used (e.g. Finance selections, Jon's selections etc.)"]
["N","Fundraiser Further Contact",null,null,"Y","Fundraiser Further Contact",13,12]
["N","Fundraiser Connected Benefit",null,null,"Y","Fundraiser Connected Benefit",12,13,"Step 5:","Download or open a donation payment report from the JustGiving website"]
["N","Fundraising Page Id",null,null,"Y","Fundraising Page Id",19,14]
["N","Fundraising Page Status",null,null,"Y","Fundraising Page Status",21,15,"Step 6:","Click on the new 'Add-Ins' menu item  and select 'Justgiving'"]
["Y","Page Created Date",null,null,"Y","Page Created Date",16,16]
["Y","Page Event Date",null,null,"Y","Page Event Date",17,17]
["Y","Page Expiry Date",null,null,"Y","Page Expiry Date",18,18]
["Y","Fundraising Page Offline Amount",null,null,"Y","FundraiserOffline Amount",25,19]
["Y","Fundraising Page Target Amount",null,null,"Y","FundraiserTarget Amount",26,20]
["N","Fundraising Page Title",null,null,"Y","Fundraising Page Title",20,21]
["Y","Fundraising Page URL",null,null,"Y","Fundraising Page URL",22,22]
["N","Fundraising Page Team Name",null,null,"Y","Fundraiser Team",14,23]
["N","Fundraising Page Team URL",null,null,"N","NEW COLUMN",-1,24]
["N","Fundraising Page Team Members",null,null,"N","NEW COLUMN",-1,25]
["N","In Memoriam Fund",null,null,"Y","In Memorium Fund",40,26]
["N","Organisation Portal",null,null,"N","NEW COLUMN",-1,27]
["N","Organisation Portal URL",null,null,"N","NEW COLUMN",-1,28,null,"If this does not appear, you may need to save your sheet again and re-open it and check your macro settings"]
["N","Fundraising Page In Memoriam Name",null,null,"N","NEW COLUMN",-1,29]
["N","Fundraising Page Birthday Name",null,null,"N","NEW COLUMN",-1,30]
["N","Fundraising Page Wedding Names",null,null,"N","NEW COLUMN",-1,31]
["N","Page Pledge Release Date",null,null,"Y","Page Pledge Release Date",15,32]
["N","Referral Site",null,null,"Y","Referral Site",23,33,null,"Your report should now be formatted with the columns and column names that you need!"]
["N","Referral Site URL",null,null,"Y","Referral Site URL",24,34,null,"You will also see a sub-total in the bottom left hand corner that will match up with the total paid to your charity"]
["N","Event Id",null,null,"Y","Event Id",45,35]
["Y","Event Name",null,null,"Y","Event Name",44,36]
["N","Promoted Event",null,null,"Y","Promoted Event",46,37]
["N","User-created Event",null,null,"Y","User-created Event",49,38]
["N","Event Category",null,null,"Y","Event Category",47,39]
["N","Overseas Event",null,null,"Y","Overseas Event",48,40]
["N","Event Date",null,null,"Y","Event Date",50,41]
["N","Event Expiry Date",null,null,"Y","Event Expiry Date",51,42]
["N","Donor User Id",null,null,"Y","Donor User Id",27,43]
["N","Donor Title",null,null,"Y","Donor Title",28,44]
["Y","Donor FirstName",null,null,"Y","Donor FirstName",29,45,null,"You can also see instructions for Excel 2003 here"]
["Y","Donor LastName",null,null,"Y","Donor LastName",30,46]
["Y","Donor Address Line 1",null,null,"Y","Donor Address Line 1",31,47]
["Y","Donor Address Line 2",null,null,"Y","Donor Address Line 2",32,48]
["Y","Donor Town",null,null,"Y","Donor Town",33,49]
["Y","Donor County",null,null,"Y","Donor County",34,50]
["Y","Donor PostCode",null,null,"Y","Donor PostCode",35,51]
["Y","Donor Country",null,null,"Y","Donor Country",36,52]
["Y","Donor E-mail",null,null,"Y","Donor E-mail",37,53]
["Y","Donor Further Contact",null,null,"Y","Donor Further Contact",38,54]
["N","Donor Is Connected",null,null,"Y","Donor Is Connected",43,55]
["Y","Donor UK Tax Payer Status",null,null,"Y","Donor UK Tax Payer Status",39,56]
["Y","Donation Ref",null,null,"Y","Donation Ref",53,57]
["Y","Donation Date",null,null,"Y","Donation Date",52,58]
["N","Is Pledge",null,null,"Y","Is Pledge",54,59]
["Y","Donation Source",null,null,"Y","Donation Source",55,60]
["N","Product Source",null,null,"N","NEW COLUMN",-1,61]
["Y","Payment Frequency",null,null,"Y","Payment Frequency",56,62]
["Y","Recurring Mandate Creation Date",null,null,"Y","Recurring Mandate Creation Date",57,63]
["N","Appeal Name",null,null,"Y","Appeal Name",58,64]
["Y","Payment Type",null,null,"Y","Card Type",59,65]
["N","SMS Operator",null,null,"N","NEW COLUMN",-1,66]
["N","SMS Operator Donor Transaction Fee",null,null,"N","NEW COLUMN",-1,67]
["Y","Donation Amount",null,null,"Y","Donation Amount",60,68]
["Y","Donation Payment Reference",null,null,"Y","Donation Payment Reference",61,69]
["Y","Donation Payment Reference Date",null,null,"Y","Donation Payment Reference Date",62,70]
["Y","Gift Aid Payment Reference",null,null,"Y","Gift Aid Payment Reference",63,71]
["Y","Gift Aid Payment Reference Date",null,null,"Y","Gift Aid Payment Reference Date",64,72]
["Y","Gross Gift Aid Payable",null,null,"Y","Gross Gift Aid Payable",66,73]
["Y","Gross Transitional Relief Payable",null,null,"Y","Gross Transitional Relief Payable",67,74]
["N","Gross Gift Aid and Transitional Relief Payable",null,null,"Y","Gross Gift Aid and Transitional Relief Payable",65,75]
["Y","Payment Processing Fee Rate",null,null,"Y","Card Processing Fee Rate",68,76]
["Y","Payment Processing Fee Amount",null,null,"Y","Card Processing Fee Amount",69,77]
["Y","JustGiving Transaction Fee Rate",null,null,"Y","JG Transaction Fee Rate",70,78]
["Y","JustGiving Transaction Fee Amount",null,null,"Y","JG Transaction Fee Amount",71,79]
["Y","Net Gift Aid Amount",null,null,"Y","Net Gift Aid Payable",72,80]
["Y","Estimated VAT",null,null,"Y","Estimated VAT",73,81]
["Y","Amount Of JustGiving Transaction Fee Paid",null,null,"N","NEW COLUMN",-1,82]
["Y","Amount Of Payment Processing Fee Paid",null,null,"N","NEW COLUMN",-1,83]
["N","Commission Payer",null,null,"N","NEW COLUMN",-1,84]
["Y","Net Total Charges By JustGiving",null,null,"N","NEW COLUMN",-1,85]
["Y","Net Gift Aid Amount Paid",null,null,"Y","Net Gift Aid Minus Estimated VAT",74,86]
["N","Donation Origin",null,null,"Y","Donation Origin",41,87]
["N","Donation Nickname",null,null,"Y","Donation Nickname",42,88]
["N","CustomEventCode1",null,null,"Y","CustomEventCode1",75,89]
["N","CustomEventCode2",null,null,"Y","CustomEventCode2",76,90]
["N","CustomEventCode3",null,null,"Y","CustomEventCode3",77,91]
["N","CustomFundraisingCode1",null,null,"Y","CustomFundraisingCode1",78,92]
["N","CustomFundraisingCode2",null,null,"Y","CustomFundraisingCode2",79,93]
["N","CustomFundraisingCode3",null,null,"Y","CustomFundraisingCode3",80,94]
["N","CustomFundraisingCode4",null,null,"Y","CustomFundraisingCode4",81,95]
["N","CustomFundraisingCode5",null,null,"Y","CustomFundraisingCode5",82,96]
["N","CustomFundraisingCode6",null,null,"Y","CustomFundraisingCode6",83,97]

{"sheet":"Static","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Y",null,"Y"]
["N",null,"Y"]