{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Email ROI Calculator"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Email ROI Calculator","index":0,"n_rows":17,"n_cols":7,"rows_kept":17}
[]
[null,null,"Email ROI Calculator"]
[null,"Step 1: Enter your data","How many usable email addresses are on your list?",{"$nulls":3},"2018 M+R Fundraising Benchmarks"]
[null,null,"How many fundraising email appeals do you send each year?",{"$nulls":3},25]
[null,null,"What is your average fundraising email response rate?",{"$nulls":3},{"v":0.0006,"d":"0.06%"}]
[null,null,"What is your average donation size?",{"$nulls":3},"$46.50 **"]
[null,null,"What percent of your list unsubscribes and hard bounces each year?",{"$nulls":3},{"v":0.176,"d":"17.60%"}]
[]
[null,"Step 2: Review your results",null,"Number of Usable Emails","Annual Value of List","Cumulative Value of List","Cumulative Value Per Email"]
[null,null,"Year 1",{"$f":"D3","v":0},{"$f":"D3*D4*D5*D6","v":{"v":0,"d":"$0.00"}},{"$f":"E10","v":{"v":0,"d":"$0.00"}},{"$f":"F10/D10","v":{"$error":"#DIV/0!"}}]
[null,null,"Year 2",{"$f":"D10*(1-D7)","v":0},{"$f":"D11*D4*D5*D6","v":{"v":0,"d":"$0.00"}},{"$f":"F10+E11","v":{"v":0,"d":"$0.00"}},{"$f":"F11/D10","v":{"$error":"#DIV/0!"}}]
[null,null,"Year 3",{"$f":"D11*(1-D7)","v":0},{"$f":"D12*D4*D5*D6","v":{"v":0,"d":"$0.00"}},{"$f":"F11+E12","v":{"v":0,"d":"$0.00"}},{"$f":"F12/D10","v":{"$error":"#DIV/0!"}}]
[null,null,"Year 4",{"$f":"D12*(1-D7)","v":0},{"$f":"D13*D4*D5*D6","v":{"v":0,"d":"$0.00"}},{"$f":"F12+E13","v":{"v":0,"d":"$0.00"}},{"$f":"F13/D10","v":{"$error":"#DIV/0!"}}]
[null,null,"Projected Lifetime Value (after 4 years)",null,null,{"$f":"F13","v":{"v":0,"d":"$0.00"}},{"$f":"G13","v":{"$error":"#DIV/0!"}}]
[]
[null,"Please complete the fields highlighted in yellow."]
[null,"** Average gift size from Care2 members (including income from one-time and recurring gifts)"]