{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["QB","Instructions","Template","Output --->"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":100,"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":"QB","index":0,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Date","Name Street1","Name Street2","Name City","Name State","Name Zip","Amount"]
[null,"Doe, Jane"]
[null,null,null,"2016-01-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,null,null,"2016-02-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,null,null,"2016-03-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,null,null,"2016-04-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,null,null,"2016-05-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,null,null,"2016-06-20","4112 Old Routt Rd",null,"Louisville","KY","40299",75]
[null,"Total Doe, Jane",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J2:J8),5)","v":450}]
[null,"Smith, John"]
[null,null,null,"2016-01-13","1234 Street",null,"Louisville","KY","40299",40]
[null,null,null,"2016-02-13","1234 Street",null,"Louisville","KY","40299",40]
[null,null,null,"2016-03-13","1234 Street",null,"Louisville","KY","40299",40]
[null,null,null,"2016-04-13","1234 Street",null,"Louisville","KY","40299",40]
[null,"Total Smith, John",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J10:J14),5)","v":160}]
[null,"First Christian Church"]
[null,null,null,"2016-01-28","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-02-28","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-03-28","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-04-28","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-05-28","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-10-23","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-11-23","7777 Street",null,"Louisville","KY","40299",100]
[null,null,null,"2016-12-23","7777 Street",null,"Louisville","KY","40299",100]
[null,"Total First Christian Church",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J16:J24),5)","v":800}]
["TOTAL",null,null,null,null,null,null,null,null,{"$f":"J9+J15+J25","v":1410}]

{"sheet":"Instructions","index":1,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"1. First make sure the tab \"Template\" is ready for the new year's receipts:"]
[null,null,"-Change the date of the letter in K12"]
[null,null,"-Change the year of donations in C40"]
[null,null,"-Change the year in the \"Total\" label in I48"]
[null,null,"-Change the letter in the text box in the center of the page (optional, the standard letter included is fine for all donations)"]
[null,null,"*Other things can be changed or customized, but do not move any of the cells; the script will look to put address"]
[null,null,"  and donation info into the cells where they are positioned in the Template"]
[]
[null,"2. Get the donor information from Quick Books:"]
[null,null,"-From Memorized Reports choose \"Year-End Giving Statement\""]
[null,null,"-In the Columns chooser (lower left corner) check \"Date\", \"Name Street1\", \"Name Street2\", \"Name City\", "]
[null,null,"  \"Name State\", \"Name Zip\" and \"Amount\" (other columns aren't needed; you can deselect them or ignore them; "]
[null,null,"  the script will ignore them)."]
[null,null,"-Export the report to an Excel worksheet. Rename the worksheet \"QB\" and transfer it to this workbook. You might"]
[null,null,"  need to delete or rename last year's QB worksheet first."]
[]
[null,"3. Review the QB page. Make sure that the addresses you want are there, that commas are in the right place, etc."]
[null,null,"-Note: The script is expecting names that are LAST, FIRST. Names written as such will be changed to FIRST LAST. "]
[null,null,"  If there is no comma, the script will assume it's all one name and won't be able to separate FIRST from LAST names."]
[]
[null,"4. Prepare the statements by clicking the button below. They will apear at the end of the workbook. If there are other sheets"]
[null,"    with the same name there will be an error. The sheets are numbered R1, R2, R3…"]
[]
[]
[]
[]
[null,"5. You may go through and print each tab separately.  Or to print all of the completed receipts at once, click on the R1 tab"]
[null," then hold the Shift key and click on the final tab.  This will select all of the receipt tabs.  Now when you print, you will say"]
[null," to print all active sheets.  Be sure to have the \"fit sheet to one page\" option selected or the header and footer will not show "]
[null,"correctly.  You may also print these reports to pdf first to check them."]

{"sheet":"Template","index":2,"n_rows":48,"n_cols":11,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Address 1",null,null,null,null,null,null,null,"2018-01-15"]
[null,null,"Address 2"]
[null,null,"City State Zip"]
[]
[]
[]
[null,null,"Dear Name,"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Thank you for your donations to Team Expansion in 2017:"]
[]
[null,null,null,null,"January: ",0,null,null,"July: ",0]
[null,null,null,null,"February: ",0,null,null,"August: ",0]
[null,null,null,null,"March: ",0,null,null,"September: ",0]
[null,null,null,null,"April: ",0,null,null,"October: ",0]
[null,null,null,null,"May: ",0,null,null,"November: ",0]
[null,null,null,null,"June: ",0,null,null,"December: ",0]
[null,null,null,null,null,null,null,null,"2017 Donation Total: ",{"$f":"SUM(J42:J47,F42:F47)","v":0}]

{"sheet":"Output --->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}