{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Deposit","Instructions","SampleDepositForm"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Deposit","index":0,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[45,1,45,6],[46,0,46,6],[43,0,43,2],[15,1,15,6],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[24,2,24,3],[25,2,25,3],[43,3,43,4],[32,2,32,3],[44,0,44,2],[44,3,44,4],[42,0,42,2],[41,0,41,2],[10,4,13,4],[7,1,7,2],[7,5,7,6],[31,2,31,3],[12,1,12,2],[9,1,9,2],[0,0,0,4],[1,0,1,6],[22,2,22,3],[21,2,21,3],[20,2,20,3],[19,2,19,3],[5,3,5,4],[18,2,18,3],[17,2,17,3],[16,0,16,6],[6,3,6,4],[6,1,6,2],[6,5,6,6],[5,1,5,2],[10,1,10,2],[11,1,11,2],[42,3,42,6],[41,3,41,6],[2,0,3,6],[4,1,4,4],[37,2,37,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[7,3,7,4],[4,5,4,6],[5,5,5,6],[26,2,26,3],[23,2,23,3],[13,1,13,2],[14,2,14,6]]}
["UNC Charlotte - Deposit Form for Cash & Checks",null,null,null,null,"Date Prepared:",{"$f":"NOW()","v":"2018-11-19T15:00:17.690"},null,1]
["Last Revised 11/19/2018",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H26=\"X\",I26=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H27=\"X\",I27=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H28=\"X\",I28=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H29=\"X\",I29=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H30=\"X\",I30=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H31=\"X\",I31=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H32=\"X\",I32=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K3)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H33=\"X\",I33=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H34=\"X\",I34=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H35=\"X\",I35=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H36=\"X\",I36=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H37=\"X\",I37=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H38=\"X\",I38=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H26=\"X\",J26=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",J20=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H27=\"X\",J27=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H28=\"X\",J28=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H29=\"X\",J29=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H30=\"X\",J30=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H31=\"X\",J31=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K5)))))))","v":""}]
["1.","Select Deposit Type",null,null,null,"For Cashiers' Use Only",null,null,null,null,{"$f":"IF(AND(H32=\"X\",J32=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H33=\"X\",J33=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H34=\"X\",J34=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H35=\"X\",J35=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H36=\"X\",J36=\"X\"),\"An Account Code must be enter for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H37=\"X\",J37=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H38=\"X\",J38=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",\"\")))))))","v":""}]
[null,null,null,null,null,"Received By:"]
[null,null,null,null,null,"Receipt #:"]
[null,null,null,null,null,"Chart:                         1"]
[null,"`"]
["2.","Enter Deposit Summary Information",null,"Amount","Error Check","Bank Detail Codes","Total Deposit"]
[null,"Currency",null,null,{"$f":"IF(OR(D14=E39),\"\",IF(OR(G14=E39),\"\",\"THIS DEPOSIT IS OUT OF BALANCE - Detail Information must be added to Rows 1 - 20\"))","v":""}]
[null,"Coin",null,null,null,{"$f":"IF(AND($I$1=0),\"\",IF(AND($I$1=1),\"0921\",IF(AND($I$1=2),\"0971\",IF(AND($I$1=3),\"0911\",IF(AND($I$1=4),\"0961\",IF(AND($I$1=5),\"0971\",IF(AND($I$1=6),\"0971\")))))))","v":"0921"},{"$f":"D11+D12","v":0}]
[null,"Checks",null,null,null,{"$f":"IF(AND($I$1=0),\"\",IF(AND($I$1=1),\"0922\",IF(AND($I$1=2),\"0972\",IF(AND($I$1=3),\"0912\",IF(AND($I$1=4),\"0962\",IF(AND($I$1=5),\"0972\",IF(AND($I$1=6),\"0972\")))))))","v":"0922"},{"$f":"D13","v":0}]
[null,"Total Deposit Summary",null,{"$f":"SUM(D11:D13)","v":0},null,"Total Debit",{"$f":"SUM(G12:G13)","v":0}]
[null,"Deposit Description:"]
["3.","Enter Deposit Detail Information"]
[]
[null,"Detail Code","Description                                                            (30 Characters)",null,"Amount","Index/Fund                                  (6 digits)","Account                                             (6 digits)"]
[1,9900,null,null,null,null,null,{"$f":"IF(OR(I19=\"X\",J19=\"X\",K19=\"X\",L19=\"X\",M19=\"X\",O19=\"X\",Q19=\"X\",R19=\"X\",S19=\"X\"),\"X\",\"\")","v":""},{"$f":"IF(AND(E19>0,F19=\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(E19>0,G19=\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND($I$1=1,F19>119999),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F19<120000,F19<>\"\",F19<>149028),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F19>849999,F19<>\"\",F19<>149028),\"X\",\"\")","v":""},{"$f":"IF(OR(L25=\"X\",M25=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L26=\"X\",M26=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L27=\"X\",M27=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L28=\"X\",M28=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L29=\"X\",M29=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L30=\"X\",M30=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N20))))))","v":""},{"$f":"IF(AND(Deposit=3,F19<>149028,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(I1=3,H26=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H27=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H28=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H29=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H30=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H31=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H32=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",P20)))))))","v":""},{"$f":"IF(AND(Deposit=4,F19<885000,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=4,F19>885999,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=6,F19<885999,F19<>\"\"),\"X\",\"\")","v":""}]
[2,9900,null,null,null,null,null,{"$f":"IF(OR(I20=\"X\",J20=\"X\",K20=\"X\",L20=\"X\",M20=\"X\",O20=\"X\",Q20=\"X\",R20=\"X\",S20=\"X\"),\"X\",\"\")","v":""},"","",{"$f":"IF(AND($I$1=1,F20>119999),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F20<120000,F20<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F20>849999,F20<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(OR(L31=\"X\",M31=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L32=\"X\",M32=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L33=\"X\",M33=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L34=\"X\",M34=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L35=\"X\",M35=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L36=\"X\",M36=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N21))))))","v":""},"",{"$f":"IF(AND(I1=3,H33=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H34=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H..\",IF(AND(I1=3,H35=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H36=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H37=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H38=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""},"","",""]
[3,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(L37=\"X\",M37=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L38=\"X\",M38=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))","v":""},"",null,"","",""]
[4,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F25>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F26>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F27>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F28>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F29>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F30>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N23))))))","v":""},"",null,"","",""]
[5,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F31>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F32>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F33>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F34>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F35>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F36>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N24))))))","v":""},"",null,"","",""]
[6,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F37>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F38>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))","v":""},"",null,"","",""]
[7,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(Q26=\"X\",R26=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q27=\"X\",R27=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q28=\"X\",R28=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q29=\"X\",R29=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q30=\"X\",R30=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q31=\"X\",R31=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q32=\"X\",R32=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N26)))))))","v":""},"",null,"","",""]
[8,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(Q33=\"X\",R33=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q34=\"X\",R34=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q35=\"X\",R35=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q36=\"X\",R36=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q37=\"X\",R37=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q38=\"X\",R38=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""},"",null,"","",""]
[9,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND($I$1=6,H28=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H29=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H30=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H31=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H32=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H33=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N28))))))","v":""},"",null,"","",""]
[10,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND($I$1=6,H34=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H35=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H36=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H37=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H38=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\")))))","v":""},"",null,"","",""]
[11,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[12,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[13,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[14,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[15,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[16,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[17,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[18,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[19,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[20,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[null,null,null,"Total Deposit Detail",{"$f":"SUM(E19:E38)","v":0}]
[]
["4.","Signature ",{"$f":"IF(OR(A42=\"\",D42=\"\",A44=\"\",F44=\"\",G44=\"\"),\"Please complete all fields below\",\"\")","v":"Please complete all fields below"}]
[]
["Preparer's UNC Charlotte ID #",null,null,"Department"]
[null,null,null,{"$f":"IF(OR(A50<>\"\",A51<>\"\",A52<>\"\",A53<>\"\",A54<>\"\",A55<>\"\",A56<>\"\",A57<>\"\",A58<>\"\"),\"THIS FORM CONTAINS ERRORS -             SEE BELOW FOR LIST\",\"\")","v":"THIS FORM CONTAINS ERRORS -             SEE BELOW FOR LIST"}]
["Preparer's Printed Name",null,null,"Preparer's Signature",null,"Phone Number","Date"]
[]
["Complete the form, attach supporting documentation and the Cash and Checks being deposited, \nand submit in person to the Cashiers' Office. Retain a hard and/or an electronic copy for your records."]
[]
["ERROR LISTING"]
[{"$f":"IF(OR(A42=\"\",D42=\"\",A44=\"\",F44=\"\",G44=\"\"),\"Complete the required Signature section fields\",\"\")","v":"Complete the required Signature section fields"}]
[{"$f":"IF(AND(H19=\"X\",I19=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",I20=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H21=\"X\",I21=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H22=\"X\",I22=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H23=\"X\",I23=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H24=\"X\",I24=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H25=\"X\",I25=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K2)))))))","v":""}]
[{"$f":"IF(AND(H19=\"X\",J19=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",J20=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H21=\"X\",J21=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H22=\"X\",J22=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H23=\"X\",J23=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H24=\"X\",J24=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H25=\"X\",J25=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K4)))))))","v":""}]
[{"$f":"IF(AND($I$1=1,F19>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F20>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F21>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F22>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F23>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F24>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N22))))))","v":""}]
[{"$f":"IF(OR(L19=\"X\",M19=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L20=\"X\",M20=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L21=\"X\",M21=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L22=\"X\",M22=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L23=\"X\",M23=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L24=\"X\",M24=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N19))))))","v":""}]
[{"$f":"IF(AND(I1=3,H19=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H20=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H21=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H22=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H23=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H24=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H25=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",P19)))))))","v":""}]
[{"$f":"IF(OR(Q19=\"X\",R19=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q20=\"X\",R20=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q21=\"X\",R21=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q22=\"X\",R22=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q23=\"X\",R23=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q24=\"X\",R24=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q25=\"X\",R25=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N25)))))))","v":""}]
[{"$f":"IF(E11<>\"\",\"This form is Out of Balance.\",\"\")","v":""}]
[{"$f":"IF(AND($I$1=6,H19=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H20=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H21=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H22=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H23=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H24=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N27))))))","v":""}]

{"sheet":"Instructions","index":1,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,0,9,0],[0,0,0,1]]}
["INSTRUCTIONS: On-Screen Preparation of Cashiers' Cash & Checks Deposit Form"]
[]
["General","This Excel template is a multi-fund Deposit Form that can be used to make cash & check deposits for all departments on Campus. When depositing credit card receipts, please use the Payment Book Receipt form. All the information needed to complete a specific deposit is entered into the yellow shaded areas of the form. It is important to complete each deposit in the proper order, starting with Section 1 and ending with Section 4.  Before beginning a new deposit, click on the Clear Form button."]
[]
["Section 1","If depositing into multiple fund groups, use a separate form for each fund group. Select the deposit type by clicking on one of the six option buttons. Deposits can be made to one of six areas, General Funds, Trust Funds, Wachovia, CI, or Trust Fund Gifts, or All Others. These are described more fully below. The Bank Detail Code on the deposit form will automatically change based on the option selected.  \nIt is extremely important that this Section be completed before moving on to Section 2."]
[null,"General Funds - The money that is deposited into this fund group should be in the fund range 10XXXX-11XXXX."]
[null,"Trust Funds - The money that is deposited into this fund group should be in the fund range 12XXXX - 84XXXX.  NOTE:  Funds 149028 (Wachovia) and 149029 (Bank of America) are reserved for Financial Services. Do NOT deposit money into these funds.  Contact General Accounting at 72102 for instructions if you need to make a deposit to these funds."]
[null,"CI - The money that is deposited into this fund group should be in the fund range 885XXX."]
[null,"Trust Fund Gifts - Please contact the Development Office at 72217 for instructions on depositing gifts."]
[null,"All Others - This fund group should be used for any deposit that does not fit into a bank listed above. Contact the Cashiers' Office at 7-5855 for instructions."]
[]
["Section 2","Enter Deposit Summary Information Amount - Itemize the total deposit as currency, coins or checks. The total of the deposit will be generated automatically.  "]
[null,"Error Check - An error message will display if the Total Deposit Summary, Total Debit and Total Deposit Detail do not match.  The Cashiers' Cash & Checks Deposit Form cannot be signed until the deposit is in balance.  This error message will clear itself when the correct detail is added in Section 3."]
[null,"Description of Deposit - Enter a brief description of the type of deposit."]
[null,"Bank Detail Codes and Total Deposit - These values will be generated automatically based upon information entered in Sections 1 and 2 of the form."]
[]
["Section 3","Move the cursor to the yellow shaded area in Line 1 of Section 3. The Cashiers' Deposit form will accept up to 20 separate transaction lines. Each transaction must belong to the deposit type selected in Section 1.  "]
[null,"Detail Code - For most departments the detail code defaults to 9900 (Miscellaneous Deposit). "]
[null,"Description - Each deposit line may contain a description. The description can be up to 30 characters long.  The description provided will be entered into Banner when the deposit is posted."]
[null,"Amount - Enter the amount for each deposit detail line. Most transaction amounts will be positive numbers.  Occasionally a department may need to record a negative amount. To record a negative amount, enter a minus followed by the amount. The number will be displayed with parenthesis around it. If an amount is entered by mistake, do not use the space bar to clear. Enter a zero (0) or use \"clear contents.\""]
[null,"Index/Fund (6 digits) - Enter the appropriate 6 digit index for the deposit detail line. "]
[null,"Account (6 digits) - Enter the appropriate 6 digit account for the deposit detail line. "]
[]
["Section 4","Enter the preparer's UNC Charlotte ID #, Department, Printed Name, Contact Phone Number, and Date of Deposit. Before printing the form, look in the space marked Error Listing at the bottom of the form to make sure no error messages appear. Once all errors have been cleared, print the Cashiers' Cash & Checks Deposit form by clicking on the PRINT FORM button at the top of the form. Sign after printing and bring the deposit to the Cashiers' Office, Reese 2nd Floor, along with the cash and checks and any supporting documentation.  A receipt will be automatically emailed to the preparer based on the UNC Charlotte ID # entered on the form."]
[]
["Questions?","Call the Cashiers' Office at extension 7-5855."]

{"sheet":"SampleDepositForm","index":2,"n_rows":58,"n_cols":19,"rows_kept":58,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,3,5,4],[5,5,5,6],[0,0,0,4],[1,0,1,6],[2,0,3,6],[4,1,4,4],[4,5,4,6],[6,1,6,2],[6,3,6,4],[6,5,6,6],[7,1,7,2],[7,3,7,4],[7,5,7,6],[9,1,9,2],[10,1,10,2],[10,4,13,4],[11,1,11,2],[12,1,12,2],[13,1,13,2],[25,2,25,3],[14,2,14,6],[15,1,15,6],[16,0,16,6],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[37,2,37,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[44,0,44,2],[44,3,44,4],[45,1,45,6],[46,0,46,6],[41,0,41,2],[41,3,41,6],[42,0,42,2],[42,3,42,6],[43,0,43,2],[43,3,43,4]]}
["UNC Charlotte - Deposit Form for Cash & Checks",null,null,null,null,"Date Prepared:",{"$f":"NOW()","v":"2018-11-19T15:00:17.690"},null,2]
["Last Revised 11/19/2018",null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H26=\"X\",I26=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H27=\"X\",I27=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H28=\"X\",I28=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H29=\"X\",I29=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H30=\"X\",I30=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H31=\"X\",I31=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H32=\"X\",I32=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K3)))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H33=\"X\",I33=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H34=\"X\",I34=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H35=\"X\",I35=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H36=\"X\",I36=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H37=\"X\",I37=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H38=\"X\",I38=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(H26=\"X\",J26=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",J20=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H27=\"X\",J27=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H28=\"X\",J28=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H29=\"X\",J29=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H30=\"X\",J30=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H31=\"X\",J31=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K5)))))))","v":""}]
["1.","Select Deposit Type",null,null,null,"For Cashiers' Use Only",null,null,null,null,{"$f":"IF(AND(H32=\"X\",J32=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H33=\"X\",J33=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H34=\"X\",J34=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H35=\"X\",J35=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H36=\"X\",J36=\"X\"),\"An Account Code must be enter for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H37=\"X\",J37=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H38=\"X\",J38=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",\"\")))))))","v":""}]
[null,null,null,null,null,"Received By:"]
[null,null,null,null,null,"Receipt #:"]
[null,null,null,null,null,"Chart:                         1"]
[null,"`"]
["2.","Enter Deposit Summary Information",null,"Amount","Error Check","Bank Detail Codes","Total Deposit"]
[null,"Currency",null,100,{"$f":"IF(OR(D14=E39),\"\",IF(OR(G14=E39),\"\",\"THIS DEPOSIT IS OUT OF BALANCE - Detail Information must be added to Rows 1 - 20\"))","v":""}]
[null,"Coin",null,57.25,null,{"$f":"IF(AND($I$1=0),\"\",IF(AND($I$1=1),\"0921\",IF(AND($I$1=2),\"0971\",IF(AND($I$1=3),\"0911\",IF(AND($I$1=4),\"0961\",IF(AND($I$1=5),\"0971\",IF(AND($I$1=6),\"0971\")))))))","v":"0971"},{"$f":"D11+D12","v":157.25}]
[null,"Checks",null,253,null,{"$f":"IF(AND($I$1=0),\"\",IF(AND($I$1=1),\"0922\",IF(AND($I$1=2),\"0972\",IF(AND($I$1=3),\"0912\",IF(AND($I$1=4),\"0962\",IF(AND($I$1=5),\"0972\",IF(AND($I$1=6),\"0972\")))))))","v":"0972"},{"$f":"D13","v":253}]
[null,"Total Deposit Summary",null,{"$f":"SUM(D11:D13)","v":410.25},null,"Total Debit",{"$f":"SUM(G12:G13)","v":410.25}]
[null,"Deposit Description:","Parking meter & decal revenue"]
["3.","Enter Deposit Detail Information"]
[]
[null,"Detail Code","Description                                                            (30 Characters)",null,"Amount","Index/Fund                                  (6 digits)","Account                                             (6 digits)"]
[1,9900,"Parking meter revenue",null,57.25,334010,105630,{"$f":"IF(OR(I19=\"X\",J19=\"X\",K19=\"X\",L19=\"X\",M19=\"X\",O19=\"X\",Q19=\"X\",R19=\"X\",S19=\"X\"),\"X\",\"\")","v":""},{"$f":"IF(AND(E19>0,F19=\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(E19>0,G19=\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND($I$1=1,F19>119999),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F19<120000,F19<>\"\",F19<>149028),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F19>849999,F19<>\"\",F19<>149028),\"X\",\"\")","v":""},{"$f":"IF(OR(L25=\"X\",M25=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L26=\"X\",M26=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L27=\"X\",M27=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L28=\"X\",M28=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L29=\"X\",M29=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L30=\"X\",M30=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N20))))))","v":""},{"$f":"IF(AND(Deposit=3,F19<>149028,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(I1=3,H26=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H27=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H28=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H29=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H30=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H31=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H32=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",P20)))))))","v":""},{"$f":"IF(AND(Deposit=4,F19<885000,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=4,F19>885999,F19<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=6,F19<885999,F19<>\"\"),\"X\",\"\")","v":""}]
[2,9900,"Parking decal revenue",null,353,334010,105640,{"$f":"IF(OR(I20=\"X\",J20=\"X\",K20=\"X\",L20=\"X\",M20=\"X\",O20=\"X\",Q20=\"X\",R20=\"X\",S20=\"X\"),\"X\",\"\")","v":""},"","",{"$f":"IF(AND($I$1=1,F20>119999),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F20<120000,F20<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(AND(Deposit=2,F20>849999,F20<>\"\"),\"X\",\"\")","v":""},{"$f":"IF(OR(L31=\"X\",M31=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L32=\"X\",M32=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L33=\"X\",M33=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L34=\"X\",M34=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L35=\"X\",M35=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L36=\"X\",M36=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N21))))))","v":""},"",{"$f":"IF(AND(I1=3,H33=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H34=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H..\",IF(AND(I1=3,H35=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H36=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H37=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H38=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""},"","",""]
[3,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(L37=\"X\",M37=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L38=\"X\",M38=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))","v":""},"",null,"","",""]
[4,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F25>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F26>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F27>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F28>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F29>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F30>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N23))))))","v":""},"",null,"","",""]
[5,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F31>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F32>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F33>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F34>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F35>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F36>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N24))))))","v":""},"",null,"","",""]
[6,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND(I1=1,F37>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F38>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))","v":""},"",null,"","",""]
[7,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(Q26=\"X\",R26=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q27=\"X\",R27=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q28=\"X\",R28=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q29=\"X\",R29=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q30=\"X\",R30=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q31=\"X\",R31=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q32=\"X\",R32=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N26)))))))","v":""},"",null,"","",""]
[8,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(OR(Q33=\"X\",R33=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q34=\"X\",R34=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q35=\"X\",R35=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q36=\"X\",R36=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q37=\"X\",R37=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q38=\"X\",R38=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\"))))))","v":""},"",null,"","",""]
[9,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND($I$1=6,H28=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H29=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H30=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H31=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H32=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H33=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N28))))))","v":""},"",null,"","",""]
[10,9900,null,null,null,null,null,"","","","","","",{"$f":"IF(AND($I$1=6,H34=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H35=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H36=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H37=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H38=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",\"\")))))","v":""},"",null,"","",""]
[11,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[12,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[13,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[14,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[15,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[16,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[17,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[18,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[19,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[20,9900,null,null,null,null,null,"","","","","","",null,"",null,"","",""]
[null,null,null,"Total Deposit Detail",{"$f":"SUM(E19:E38)","v":410.25}]
[]
["4.","Signature ",{"$f":"IF(OR(A42=\"\",D42=\"\",A44=\"\",F44=\"\",G44=\"\"),\"Please complete all fields below\",\"\")","v":""}]
[800123456,null,null,"Parking Services"]
["Preparer's UNC Charlotte ID #",null,null,"Department"]
["Norm T. Niner",null,null,{"$f":"IF(OR(A50<>\"\",A51<>\"\",A52<>\"\",A53<>\"\",A54<>\"\",A55<>\"\",A56<>\"\",A57<>\"\",A58<>\"\"),\"THIS FORM CONTAINS ERRORS -             SEE BELOW FOR LIST\",\"\")","v":""},null,"74285","2018-08-14"]
["Preparer's Printed Name",null,null,"Preparer's Signature",null,"Phone Number","Date"]
[]
["Complete the form, attach supporting documentation and the Cash and Checks being deposited, \nand submit in person to the Cashiers' Office. Retain a hard and/or an electronic copy for your records."]
[]
["ERROR LISTING"]
[{"$f":"IF(OR(A42=\"\",D42=\"\",A44=\"\",F44=\"\",G44=\"\"),\"Complete the required Signature section fields\",\"\")","v":""}]
[{"$f":"IF(AND(H19=\"X\",I19=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",I20=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H21=\"X\",I21=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H22=\"X\",I22=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H23=\"X\",I23=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H24=\"X\",I24=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H25=\"X\",I25=\"X\"),\"An Index/Fund Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K2)))))))","v":""}]
[{"$f":"IF(AND(H19=\"X\",J19=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H20=\"X\",J20=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H21=\"X\",J21=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H22=\"X\",J22=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H23=\"X\",J23=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H24=\"X\",J24=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(H25=\"X\",J25=\"X\"),\"An Account Code must be entered for each deposit. Incorrect row is marked with an 'X' in Column H.\",K4)))))))","v":""}]
[{"$f":"IF(AND($I$1=1,F19>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F20>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F21>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F22>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F23>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=1,F24>119999),\"A State Fund (110000 - 119999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N22))))))","v":""}]
[{"$f":"IF(OR(L19=\"X\",M19=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L20=\"X\",M20=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L21=\"X\",M21=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L22=\"X\",M22=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L23=\"X\",M23=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(L24=\"X\",M24=\"X\"),\"A Trust Fund (120000 - 849999) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N19))))))","v":""}]
[{"$f":"IF(AND(I1=3,H19=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H20=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H21=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H22=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H23=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H24=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=3,H25=\"X\"),\"Fund 149028 must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",P19)))))))","v":""}]
[{"$f":"IF(OR(Q19=\"X\",R19=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q20=\"X\",R20=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q21=\"X\",R21=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q22=\"X\",R22=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q23=\"X\",R23=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q24=\"X\",R24=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(OR(Q25=\"X\",R25=\"X\"),\"A CI Fund (885XXX) must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N25)))))))","v":""}]
[{"$f":"IF(E11<>\"\",\"This form is Out of Balance.\",\"\")","v":""}]
[{"$f":"IF(AND($I$1=6,H19=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H20=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H21=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H22=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H23=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",IF(AND(I1=6,H24=\"X\"),\"Funds in the 887000 - 944999 range must be used for this deposit. Incorrect row is marked with an 'X' in Column H.\",N27))))))","v":""}]