{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["General","Your Info","Instructions"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"General","index":0,"n_rows":34,"n_cols":31,"rows_kept":34,"merged":[[0,8,0,15],[0,23,0,30],[1,8,1,15],[1,23,1,30],[2,8,2,15],[2,23,2,30],[3,8,3,15],[3,23,3,30],[4,8,4,15],[4,23,4,30],[5,13,5,14],[5,28,5,29],[6,8,6,12],[6,13,6,14],[6,23,6,27],[6,28,6,29],[7,6,17,6],[7,7,17,7],[7,8,7,12],[7,13,7,14],[7,21,17,21],[7,22,17,22],[7,23,7,27],[7,28,7,29],[8,8,8,12],[8,13,8,14],[8,23,8,27],[8,28,8,29],[9,9,9,12],[9,13,9,14],[9,24,9,27],[9,28,9,29],[10,9,10,12],[10,13,10,14],[10,24,10,27],[10,28,10,29],[11,9,11,12],[11,13,11,14],[11,24,11,27],[11,28,11,29],[12,9,12,12],[12,13,12,14],[12,24,12,27],[12,28,12,29],[13,9,13,12],[13,13,13,14],[13,24,13,27],[13,28,13,29],[14,9,14,12],[14,13,14,14],[14,24,14,27],[14,28,14,29],[15,9,15,12],[15,13,15,14],[15,24,15,27],[15,28,15,29],[16,9,16,12],[16,13,16,14],[16,24,16,27],[16,28,16,29],[17,9,17,12],[17,13,17,14],[17,24,17,27],[17,28,17,29],[18,5,25,5],[18,6,25,7],[18,9,18,12],[18,13,18,14],[18,20,25,20],[18,21,25,22],[18,24,18,27],[18,28,18,29],[19,9,19,12],[19,13,19,14],[19,24,19,27],[19,28,19,29],[20,9,20,12],[20,13,20,14],[20,24,20,27],[20,28,20,29],[21,9,21,12],[21,13,21,14],[21,24,21,27],[21,28,21,29],[22,9,22,12],[22,13,22,14],[22,24,22,27],[22,28,22,29],[23,9,23,12],[23,13,23,14],[23,24,23,27],[23,28,23,29],[24,9,24,12],[24,13,24,14],[24,24,24,27],[24,28,24,29],[25,9,25,12],[25,13,25,14],[25,24,25,27],[25,28,25,29],[26,9,26,12],[26,13,26,14],[26,24,26,27],[26,28,26,29],[27,9,27,12],[27,13,27,14],[27,24,27,27],[27,28,27,29],[28,9,28,12],[28,13,28,14],[28,24,28,27],[28,28,28,29],[29,8,33,8],[29,9,33,9],[29,11,30,11],[29,12,29,14],[29,23,33,23],[29,24,33,24],[29,26,30,26],[29,27,29,29],[31,10,33,10],[31,25,33,25]]}
[{"$nulls":8},"DEPOSIT TICKET",{"$nulls":14},"DEPOSIT TICKET"]
[{"$nulls":8},{"$f":"Name","v":"Prompton Borough"},{"$nulls":14},{"$f":"Name","v":"Prompton Borough"}]
[{"$nulls":8},{"$f":"Address1","v":"Michael Wolfe"},{"$nulls":14},{"$f":"Address1","v":"Michael Wolfe"}]
[{"$nulls":8},{"$f":"Address2","v":"PO Box 12"},{"$nulls":14},{"$f":"Address2","v":"PO Box 12"}]
[{"$nulls":8},{"$f":"Address3","v":"Prompton, PA 18456"},{"$nulls":14},{"$f":"Address3","v":"Prompton, PA 18456"}]
[{"$nulls":13},"DOLLARS",null,"CENTS",{"$nulls":12},"DOLLARS",null,"CENTS"]
["CASH:",{"$nulls":7},"CURRENCY",{"$nulls":4},{"$f":"IF(ISBLANK(B7),\"\",INT(B7))","v":""},null,{"$f":"IF(ISBLANK(B7),\"\",100*(B7-INT(B7)))","v":""},{"$nulls":7},"CURRENCY",{"$nulls":4},{"$f":"IF(ISBLANK(Q7),\"\",INT(Q7))","v":""},null,{"$f":"IF(ISBLANK(Q7),\"\",100*(Q7-INT(Q7)))","v":""}]
["COIN:",{"$nulls":5},{"$f":"UPPER(AcctSubtitle)","v":"MICHAEL WOLFE, TAX COLLECTOR"},{"$f":"UPPER(AcctName)","v":"PROMPTON BOROUGH"},"COIN",{"$nulls":4},{"$f":"IF(ISBLANK(B8),\"\",INT(B8))","v":""},null,{"$f":"IF(ISBLANK(B8),\"\",100*(B8-INT(B8)))","v":""},{"$nulls":5},{"$f":"UPPER(AcctSubtitle)","v":"MICHAEL WOLFE, TAX COLLECTOR"},{"$f":"UPPER(AcctName)","v":"PROMPTON BOROUGH"},"COIN",{"$nulls":4},{"$f":"IF(ISBLANK(Q8),\"\",INT(Q8))","v":""},null,{"$f":"IF(ISBLANK(Q8),\"\",100*(Q8-INT(Q8)))","v":""}]
["Check Num","Amount",{"$nulls":6},"LIST EACH CHECK",{"$nulls":14},"LIST EACH CHECK"]
[{"$nulls":8},1,{"$f":"IF(ISBLANK($A10),\"\",$A10)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK($B10),\"\",INT($B10))","v":""},null,{"$f":"IF(ISBLANK($B10),\"\",100*($B10-INT($B10)))","v":""},{"$nulls":7},1,{"$f":"IF(ISBLANK($A10),\"\",$A10)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK($B10),\"\",INT($B10))","v":""},null,{"$f":"IF(ISBLANK($B10),\"\",100*($B10-INT($B10)))","v":""}]
[{"$nulls":8},2,{"$f":"IF(ISBLANK($A11),\"\",$A11)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK($B11),\"\",INT($B11))","v":""},null,{"$f":"IF(ISBLANK($B11),\"\",100*($B11-INT($B11)))","v":""},{"$nulls":7},2,{"$f":"IF(ISBLANK($A11),\"\",$A11)","v":""},{"$nulls":3},{"$f":"IF(ISBLANK($B11),\"\",INT($B11))","v":""},null,{"$f":"IF(ISBLANK($B11),\"\",100*($B11-INT($B11)))","v":""}]
[{"$nulls":8},3,"",{"$nulls":3},"",null,"",{"$nulls":7},3,"",{"$nulls":3},"",null,""]
[{"$nulls":8},4,"",{"$nulls":3},"",null,"",{"$nulls":7},4,"",{"$nulls":3},"",null,""]
[{"$nulls":8},5,"",{"$nulls":3},"",null,"",{"$nulls":7},5,"",{"$nulls":3},"",null,""]
[{"$nulls":8},6,"",{"$nulls":3},"",null,"",{"$nulls":7},6,"",{"$nulls":3},"",null,""]
[{"$nulls":8},7,"",{"$nulls":3},"",null,"",{"$nulls":7},7,"",{"$nulls":3},"",null,""]
[{"$nulls":8},8,"",{"$nulls":3},"",null,"",{"$nulls":7},8,"",{"$nulls":3},"",null,""]
[{"$nulls":8},9,"",{"$nulls":3},"",null,"",{"$nulls":7},9,"",{"$nulls":3},"",null,""]
[{"$nulls":5},"Account Number",{"$f":"AcctNum","v":1234567890},null,10,"",{"$nulls":3},"",null,"",{"$nulls":4},"Account Number",{"$f":"AcctNum","v":1234567890},null,10,"",{"$nulls":3},"",null,""]
[{"$nulls":8},11,"",{"$nulls":3},"",null,"",{"$nulls":7},11,"",{"$nulls":3},"",null,""]
[{"$nulls":8},12,"",{"$nulls":3},"",null,"",{"$nulls":7},12,"",{"$nulls":3},"",null,""]
[{"$nulls":8},13,"",{"$nulls":3},"",null,"",{"$nulls":7},13,"",{"$nulls":3},"",null,""]
[{"$nulls":8},14,"",{"$nulls":3},"",null,"",{"$nulls":7},14,"",{"$nulls":3},"",null,""]
[{"$nulls":8},15,"",{"$nulls":3},"",null,"",{"$nulls":7},15,"",{"$nulls":3},"",null,""]
[{"$nulls":8},16,"",{"$nulls":3},"",null,"",{"$nulls":7},16,"",{"$nulls":3},"",null,""]
[{"$nulls":8},17,"",{"$nulls":3},"",null,"",{"$nulls":7},17,"",{"$nulls":3},"",null,""]
[{"$nulls":8},18,"",{"$nulls":3},"",null,"",{"$nulls":7},18,"",{"$nulls":3},"",null,""]
[{"$nulls":8},19,"",{"$nulls":3},"",null,"",{"$nulls":7},19,"",{"$nulls":3},"",null,""]
[{"$nulls":8},20,"",{"$nulls":3},"",null,"",{"$nulls":7},20,"",{"$nulls":3},"",null,""]
["Total:",{"$f":"SUM(B7:B8,B10:B29)","v":0},{"$nulls":6},"FOR IMMEDIATE WITHDRAWAL","DEPOSITS MAY NOT BE AVAILABLE",null,null,{"$f":"INT($B30)","v":0},null,null,{"$f":"IF(ISBLANK($B30),\"\",100*($B30-INT($B30)))","v":{"v":0,"d":"00"}},{"$nulls":7},"FOR IMMEDIATE WITHDRAWAL","DEPOSITS MAY NOT BE AVAILABLE",null,null,{"$f":"INT($B30)","v":0},null,null,{"$f":"IF(ISBLANK($B30),\"\",100*($B30-INT($B30)))","v":{"v":0,"d":"00"}}]
[]
[{"$nulls":10},"TOTAL DEPOSIT",{"$nulls":14},"TOTAL DEPOSIT"]
[{"$nulls":11},{"$f":"M30","v":0},null,null,"TOTAL    \nITEMS ",{"$nulls":11},{"$f":"AB30","v":0},null,null,"TOTAL    \nITEMS "]
[{"$nulls":11},{"$f":"P30","v":{"v":0,"d":"00"}},null,null,{"$f":"COUNT($B10:$B29)","v":0},{"$nulls":11},{"$f":"AE30","v":{"v":0,"d":"00"}},null,null,{"$f":"COUNT($B10:$B29)","v":0}]

{"sheet":"Your Info","index":1,"n_rows":10,"n_cols":3,"rows_kept":10}
[]
[null,"Name:","Prompton Borough"]
[null,"Address 1:","Michael Wolfe"]
[null,"Address 2:","PO Box 12"]
[null,"Address 3:","Prompton, PA 18456"]
[]
[null,"Account Number:",1234567890]
[]
[null,"Account Name:",{"$f":"Name","v":"Prompton Borough"}]
[null,"Account Subtitle:","Michael Wolfe, Tax Collector"]

{"sheet":"Instructions","index":2,"n_rows":12,"n_cols":2,"rows_kept":12}
[]
[null,"This is an Excel template.  When you double-click on this file, it will create a new Excel workbook that you can save without affecting the original."]
[]
[null,"Before you start using it, you should customize it with your information.  To do this, you will need to right-click on the Blank_Deposit_Slip.xltx file and choose \"Open.\"  It will be the second option underneath the word \"New.\"  This will let you make changes to the template itself.  If you've done it correctly, the title at the top of this Excel window should be \"Blank_Deposit_Slip.xltx.\""]
[]
[null,"Now, click on the \"Your Info\" tab and change the highlighted data fields with your own information."]
[]
[null,"Finally, switch to the \"General\" tab, then click on the \"File\" menu and choose \"Save.\"  Close Excel."]
[]
[null,"The next time you double-click on the file to open it, it will create a new Excel workbook opened to the General tab.  You can then enter your check numbers and amounts, print the deposit slips, and take your checks to the bank."]
[]
[null,"The workbook will print two identical copies of the deposit slip on a single sheet of paper.  I recommend cutting out one of the copies and keeping the other for your records.  You can use the white space in between the deposit slips to staple your deposit ticket for record keeping."]