{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["City & County Deposit Sheet"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"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":"City & County Deposit Sheet","index":0,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[17,5,17,15],[13,1,13,2],[14,5,14,14],[8,8,8,15],[9,0,9,2],[55,0,55,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[19,0,22,1],[48,0,48,1],[54,0,54,1],[20,6,22,6],[15,5,15,15],[0,1,0,4],[11,3,11,4],[11,5,11,15],[12,5,12,15],[13,5,13,15],[6,0,6,2],[4,12,5,15],[6,3,6,15],[8,3,8,4],[2,2,2,3],[3,2,3,3],[9,8,9,15],[12,1,12,2],[16,5,16,15],[2,6,2,10],[3,6,3,10],[57,3,57,14],[19,15,22,15],[20,12,22,12],[19,4,22,4],[15,3,15,4],[20,10,22,10],[20,14,22,14],[55,2,55,3],[19,2,22,2],[20,5,22,5],[20,8,22,8],[19,5,19,14],[54,2,54,5],[19,3,22,3]]}
[null,"ALOHA UNITED WAY DEPOSIT SHEET City & County\n"]
[]
[null,"File # 2020-",null,null,null,"Department:"]
[null,"Account #",null,null,null,"Phone:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"200 N. Vineyard Blvd., Suite 700, Honolulu, HI 96817\nPhone: 536-1951   \u009f   Fax: 543-2244"]
[]
[null,null,null,"Instructions"]
[]
[null,null,null,"1) Check Pledge Forms for:",null,"\u009fiSignature",null,null,"\u009f For Credit Card: Number, Expiration, Billing Address, Phone"]
["Check one Method of Payment below:",null,null,null,null,"\u009f 10 Digit City Employee ID",null,null,"\u009f For Automatic Transfer: Voided Check Attached"]
[]
[null,null,null,"2) Enter Pledges:",null,"Enter name of employee and their annual pledge amount under the Method of Payment they chose."]
[null,"Cash",null,null,null,"If employee has multiple methods of payment, list employee on their own Deposit Sheet."]
[null,"Check "]
[null,"Credit Card",null,null,null,"Note: The yellow cells are protected and will not allow you to edit.  Also cells with totals will automatically calculate."]
[null,"Automatic Transfer",null,"3) Make the Deposit:",null,"Enclose with this sheet: Pledge Form and if applicable cash, check, voided check."]
[null,"Payroll Deduction & Bill Me",null,null,null,"Schedule an appointment with an Aloha United Way representative and review all materials together."]
[null,null,null,null,null,"Upon completion of review, please sign Deposit Sheet and make a copy for your records."]
[]
["NAME OF EMPLOYEE",null,"10 Digit City Employee ID","Total Amount Donated\n","Per Month\nDeduction\nAmount","Annual Donation",null,null,null,null,null,null,null,null,null,"AUW USE"]
[null,null,null,null,null,"Payroll Deduction","Bill Me",null,"Automatic Transfer",null,"Credit Card",null,"Cash",null,"Check"]
[]
[]
[1,null,null,{"$f":"SUM(F24:O24)","v":0},{"$f":"F24/12","v":0}]
[2,null,null,0,{"$f":"F25/12","v":0}]
[3,null,null,0,0]
[4,null,null,0,0]
[5,null,null,0,0]
[6,null,null,0,0]
[7,null,null,0,0]
[8,null,null,0,0]
[9,null,null,0,0]
[10,null,null,0,0]
[11,null,null,0,0]
[12,null,null,0,0]
[13,null,null,0,0]
[14,null,null,0,0]
[15,null,null,0,0]
[16,null,null,0,0]
[17,null,null,0,0]
[18,null,null,0,0]
[19,null,null,0,0]
[20,null,null,0,0]
[21,null,null,0,0]
[22,null,null,0,0]
[23,null,null,0,0]
[24,null,null,0,0]
[25,null,null,0,0]
["Total Number of Pledges",null,null,0,null,{"$f":"COUNT(F24:F48)","v":0},{"$f":"COUNT(G24:G48)","v":0},null,0,null,0,null,0,null,0,0]
["Total Employee Donations",null,null,{"$f":"SUM(D24:D48)","v":0},null,{"$f":"SUM(F24:F48)","v":0},{"$f":"SUM(G24:G48)","v":0},null,0,null,0,null,0,null,0]
["Total Special Events ",null,null,{"$f":"M51+O51","v":0}]
["GRAND TOTAL",null,null,{"$f":"SUM(D50:D51)","v":0},null,{"$f":"F50","v":0},{"$f":"G50","v":0},null,{"$f":"I50","v":0},null,{"$f":"K50","v":0},null,{"$f":"SUM(M50:M51)","v":0},null,{"$f":"SUM(O50:O51)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H52+#REF!+H51)","v":{"$error":"#REF!"}},null,{"$f":"SUM(J52+#REF!+J51)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L52+#REF!+L51)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N52+#REF!+N51)","v":{"$error":"#REF!"}}]
[]
["Campaign Coordinator's Name:",null,null,null,null,null,null,null,"Aloha United Way Representative:"]
["Signature:",null,null,null,"Date:",null,null,null,"Signature:",null,null,null,"Date:"]