{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AUW"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"AUW","index":0,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[4,10,5,12],[69,0,69,1],[72,0,72,1],[70,0,70,2],[68,0,68,2],[71,0,71,2],[67,0,67,2],[62,0,62,1],[63,0,63,1],[64,0,64,1],[30,12,33,12],[30,3,33,3],[31,8,33,8],[30,2,33,2],[31,4,33,4],[31,5,33,5],[31,6,33,6],[31,10,33,10],[31,11,33,11],[12,1,12,3],[12,8,12,10],[12,5,12,6],[18,2,18,3],[18,4,18,12],[25,2,25,12],[27,2,27,12],[26,2,26,12],[30,4,30,11],[19,2,19,3],[19,4,19,12],[21,2,21,12],[22,2,22,12],[23,2,23,12]]}
[]
[]
[null,"File # 17-"]
[null,"Account #"]
[null,"Company/Department:",null,null,null,null,null,null,null,null,"200 N. Vineyard Blvd., Suite 700\nHonolulu, HI 96817\nOffice: 535-1951\nFax: 543-2244"]
[null,"Phone:"]
[]
[]
[null,"Select One"]
[]
[null,"Check Method of Payment below to include in this Deposit Sheet.  (All Methods of Payment listed below should have their own Deposit Sheet.)"]
[]
[null,"      Payroll Deduction, Automatic Transfer, Bill Me",null,null,null,"Credit Card",null,null,"      Cash, Check"]
[]
[]
[]
[null,"Instructions"]
[]
["1)","Check Pledge Forms for:","\u009f Original Signature",null,"\u009f\u009f For Credit Card: Card Number, Expiration, Billing Address, Phone"]
[null,null,null,null,"\u009f\u009f For Automatic Transfer: Attached Voided Check"]
[]
["2)","Enter Pledges:","Enter name of employee and their annual pledge amount under the Method of Payment they chose."]
[null,null," If employee(s) has multiple methods of payment, list employee(s) on its own Deposit Sheet."]
[null,null,"Note: The yellow cells are protected with formulas and will not allow you to enter text.  These cells automatically calculate."]
[]
["3)","Make the Deposit:","Enclose with this sheet: Original pledge form and if applicable cash, check, voided check."]
[null,null,"Schedule an appointment with an Aloha United Way representative and review all materials together."]
[null,null,"Upon completion of review, sign Deposit Sheet and make a copy for your records."]
[]
[]
[null,null,"Employee ID","Total","Annual Donation",null,null,null,null,null,null,null,"AUW USE "]
[null,null,null,null,"Payroll Deduction","Automatic Transfer","Bill Me",null,"Credit Card",null,"Cash","Check"]
[]
[]
[null,"Corporate Gift",null,{"$f":"SUM(G35,I35,K35,L35)","v":0}]
[null,"Special Event",null,{"$f":"K36+L36","v":0}]
[null,"NAME OF EMPLOYEE"]
[1,null,null,{"$f":"SUM(E38:L38)","v":0}]
[2]
[3,null,null,0]
[4,null,null,0]
[5,null,null,0]
[6,null,null,0]
[7,null,null,0]
[8,null,null,0]
[9,null,null,0]
[10,null,null,0]
[11,null,null,0]
[12,null,null,0]
[13,null,null,0]
[14,null,null,0]
[15,null,null,0]
[16,null,null,0]
[17,null,null,0]
[18,null,null,0]
[19,null,null,0]
[20,null,null,0]
[21,null,null,0]
[22,null,null,0]
[23,null,null,0]
[24,null,null,0]
[25,null,null,0]
["Total Number of Pledges",null,null,0,{"$f":"COUNT(E38:E62)","v":0},0,0,null,{"$f":"COUNT(I38:I62)","v":0},null,0,0,0]
["Total Employee Gifts",null,null,{"$f":"SUM(D38:D62)","v":0},{"$f":"SUM(E38:E62)","v":0},0,0,null,{"$f":"SUM(I38:I62)","v":0},null,0,0]
["GRAND TOTAL",null,null,{"$f":"SUM(D64+D36+D35)","v":0},{"$f":"SUM(E38:E62)","v":0},{"$f":"SUM(F35:F62)","v":0},{"$f":"SUM(G35:G62)","v":0},null,{"$f":"SUM(I35:I62)","v":0},null,{"$f":"SUM(K38:K62)+K36+K35","v":0},{"$f":"SUM(L38:L62)+L36+L35","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H65+H37+H36)","v":0},null,{"$f":"SUM(J65+J37+J36)","v":0}]
[]
["Campaign Coordinator's Name:",null,null,null,null,null,null,null,null,null,"Date:"]
["Signature:"]
[]
["Aloha United Way Representative Name:",null,null,null,null,null,null,null,null,null,"Date:"]
["Signature:"]