{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CC Expense Form Pg 1","CC Expense Form Pg 2","CC Expense Form Pg 3","Expense Code Definitions","JE - TUF USE ONLY","TABLES - TUF USE ONLY"],"not_rendered":{"charts":0,"images":1,"macros":0,"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":"CC Expense Form Pg 1","index":0,"n_rows":42,"n_cols":11,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,41,5],[40,1,40,7],[25,7,25,8],[26,1,26,3],[27,1,27,3],[29,1,29,3],[4,7,4,8],[12,1,12,2]]}
[null,null,null,null,null,"Revised 3/29/22"]
[]
[null,"Capital One Credit Card Expense Allocation Form (Page 1)"]
[]
[null,"REQUIRED FIELDS:"]
[null,"Credit Card Statement Date ==>",null,null,null,null,null,"<== Enter the date of the CC Statement you are submitting"]
[null,"Cardholder Name ==>",null,null,null,null,null,"<== Name (ex. John Mease)"]
[null,"Cardholder Initials ==>",null,null,null,null,null,"<== Initials (ex. JJM)"]
[]
[]
[null,"Attach original invoices, receipts and/or other documentation to support the expenditure"]
[null,"Remit one copy of this Form with your original paperwork and send a second copy electronically to TUFCORPCARD@TOWSON.EDU"]
[null," \n(Choose from the drop-down menu in cells below.\nSee Blue Tab for Expense Code Definitions.)    Expense Code",null,"Date","DR"," Amount $$",null,"(Please be detailed - Your response is what will be reflected back to you on your reports) \nDescription of Expenditure"," TUF\nProject #","TUF Project Name","Mandatory\nChoose \"Yes\" or \"No\" from drop-down menu below.\nFundraising\nExpense?"]
[1,null,"q",{"$f":"IF(F14<>0,$F$6,\"\")","v":""},{"$f":"IF(F14>0,\"D\",IF(F14<0,\"C\",\"\"))","v":""}]
[2,null,"q","",{"$f":"IF(F15>0,\"D\",IF(F15<0,\"C\",\"\"))","v":""}]
[3,null,"q","",{"$f":"IF(F16>0,\"D\",IF(F16<0,\"C\",\"\"))","v":""}]
[4,null,"q","",{"$f":"IF(F17>0,\"D\",IF(F17<0,\"C\",\"\"))","v":""}]
[5,null,"q","",""]
[6,null,"q","",""]
[7,null,"q","",""]
[8,null,"q","",""]
[9,null,"q","",""]
[10,null,"q","",""]
[null,"Total (Must agree with CC Statement) ==>",null,null,null,{"$f":"SUM(F14:F23)+SUM('CC Expense Form Pg 2'!F14:F23)+SUM('CC Expense Form Pg 3'!F14:F23)","v":0}]
[]
[null,"Program Director",null,null,null,null,null,"Supervisor"]
[]
[null,"Name and Title (Please Print)                ",null,null,null,"Extension",null,"Name and Title (Please Print)                ","Extension"]
[]
[null,"Signature                                          ",null,null,null,"Date",null,"Signature                                          ","Date"]
[]
[null,"Foundation Use ONLY"]
[]
[null,"FORM INSTRUCTIONS:"]
[null,"On the Excel form, please be sure to:"]
[null,"1. Enter the Credit Card Statement Date, your name (first initial and last name), and initials."]
[null,"2. Select the appropriate Expense code from the dropdown menu (sorted alphabetically)."]
[null,"3. Provide a very detailed description of each item (the first 100 characters will be shown on your Project Activity Reports)."]
[null,"4. Provide the Project # and Project Name for each item."]
[null,"5. IMPORTANT: You must answer “Yes” or “No” to the “Fundraising Expense” question."]
[null,"  6. As a reminder, if you are expecting a charge(s) to be reimbursed to the TU Foundation for travel, please code that    charge(s) to Expense Code 1403, NOT Expense Code 5752."]
[null,"The Excel Expense form is set up to allow 10 transactions per page and we’ve provided 3 pages for a total of 30 transactions per month.  Should you require more than 30 lines for your monthly transactions, contact the Foundation office."]

{"sheet":"CC Expense Form Pg 2","index":1,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[[4,7,4,8],[12,1,12,2]]}
[null,null,null,null,null,{"$f":"+'CC Expense Form Pg 1'!F1","v":"Revised 3/29/22"}]
[]
[null,"Capital One Credit Card Expense Allocation Form (Page 2)"]
[]
[null,"REQUIRED FIELDS:"]
[null,"Credit Card Statement Date ==>",null,null,null,{"$f":"IF('CC Expense Form Pg 1'!F6>0,'CC Expense Form Pg 1'!F6,\"\")","v":""}]
[null,"Cardholder Name ==>",null,null,null,{"$f":"+'CC Expense Form Pg 1'!F7","v":0}]
[null,"Cardholder Initials ==>",null,null,null,{"$f":"+'CC Expense Form Pg 1'!F8","v":0}]
[]
[]
[null,"Attach original invoices, receipts and/or other documentation to support the expenditure"]
[null,"Remit one copy of this Form with your original paperwork and send a second copy electronically to TUFCORPCARD@TOWSON.EDU"]
[null," \n(Choose from the drop-down menu in cells below.\nSee Blue Tab for Expense Code Definitions.)    Expense Code",null,"Date","DR"," Amount $$",null,"(Please be detailed - Your response is what will be reflected back to you on your reports) \nDescription of Expenditure"," TUF\nProject #","TUF Project Name","Mandatory\nChoose \"Yes\" or \"No\" from drop-down menu below.\nFundraising\nExpense?"]
[11,null,"q",{"$f":"IF(F14<>0,$F$6,\"\")","v":""},{"$f":"IF(F14>0,\"D\",IF(F14<0,\"C\",\"\"))","v":""}]
[12,null,"q",{"$f":"IF(F15<>0,$F$6,\"\")","v":""},{"$f":"IF(F15>0,\"D\",IF(F15<0,\"C\",\"\"))","v":""}]
[13,null,"q","",{"$f":"IF(F16>0,\"D\",IF(F16<0,\"C\",\"\"))","v":""}]
[14,null,"q","",{"$f":"IF(F17>0,\"D\",IF(F17<0,\"C\",\"\"))","v":""}]
[15,null,"q","",""]
[16,null,"q","",""]
[17,null,"q","",""]
[18,null,"q","",""]
[19,null,"q","",""]
[20,null,"q","",""]

{"sheet":"CC Expense Form Pg 3","index":2,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[4,7,4,8],[12,1,12,2]]}
[null,null,null,null,null,{"$f":"+'CC Expense Form Pg 1'!F1","v":"Revised 3/29/22"}]
[]
[null,"Capital One Credit Card Expense Allocation Form (Page 3)"]
[]
[null,"REQUIRED FIELDS:"]
[null,"Credit Card Statement Date ==>",null,null,null,{"$f":"IF('CC Expense Form Pg 1'!F6>0,'CC Expense Form Pg 1'!F6,\"\")","v":""}]
[null,"Cardholder Name ==>",null,null,null,{"$f":"+'CC Expense Form Pg 1'!F7","v":0}]
[null,"Cardholder Initials ==>",null,null,null,{"$f":"+'CC Expense Form Pg 1'!F8","v":0}]
[]
[]
[null,"Attach original invoices, receipts and/or other documentation to support the expenditure"]
[null,"Remit one copy of this Form with your original paperwork and send a second copy electronically to TUFCORPCARD@TOWSON.EDU"]
[null," \n(Choose from the drop-down menu in cells below.\nSee Blue Tab for Expense Code Definitions.)    Expense Code",null,"Date","DR"," Amount $$",null,"(Please be detailed - Your response is what will be reflected back to you on your reports) \nDescription of Expenditure"," TUF\nProject #","TUF Project Name","Mandatory\nChoose \"Yes\" or \"No\" from drop-down menu below.\nFundraising\nExpense?"]
[21,null,"q",{"$f":"IF(F14<>0,$F$6,\"\")","v":""},{"$f":"IF(F14>0,\"D\",IF(F14<0,\"C\",\"\"))","v":""}]
[22,null,"q",{"$f":"IF(F15<>0,$F$6,\"\")","v":""},{"$f":"IF(F15>0,\"D\",IF(F15<0,\"C\",\"\"))","v":""}]
[23,null,"q","",""]
[24,null,"q","",""]
[25,null,"q","",""]
[26,null,"q","",""]
[27,null,"q","",""]
[28,null,"q","",""]
[29,null,"q","",""]
[30,null,"q","",""]
[]
[]
[null,"Revised 2/28/22"]

{"sheet":"Expense Code Definitions","index":3,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["EXPENSE CODE DEFINITIONS"]
[1402,"ACCOUNTS RECEIVABLE – Expenditures that you expect an outside party to reimburse the TU Foundation for"]
[1410,"ADVANCE DEPOSITS - Use this code for expenditures incurred for events that will occur at a future time"]
[5702,"ADVERTISING – Newspaper, radio or TV ads for a program or University related event"]
[5204,"ALUMNI BENEFITS – For TU Alumni Association Use ONLY - MVA LICENCE PLATES, BRICKS, ETC."]
[5260,"AWARDS – plaques, trophies, faculty/staff awards (not a scholarship award)"]
[5404,"BOOKS / PRINTED MATERIALS / SUBSCRIPTIONS – Purchases of books, magazines, subscriptions, periodicals, etc."]
[5950,"BUILDING REPAIRS & MAINTENANCE – Repairs and maintenance to TU buildings"]
[5300,"CATERING – Payments to vendors who provide food and drink at TU events (Chartwells, Ocean Pride, Classic Catering, etc.)  MUST provide a list of attendees"]
[5654,"CONFERENCES & SEMINARS – Registration fees and/or conference materials for attending both in and out of state conferences and seminars (DO NOT include travel expenses - USE Code 5752)"]
[5256,"CONSULTING & OTHER CONTRACTUAL SERVICES – Payments to an individual or company for a specific or specialized project - someone paid for their expert professional advice"]
[6206,"COST OF GOODS FOR RESALE – Merchandise purchased for resale (T-shirts, CD’s, etc.)"]
[5508,"CREDIT CARD FEES – Self Explanatory"]
[6000,"DUES & MEMBERSHIPS – Payments to outside organizations for annual dues and memberships (Center Club, golf memberships, CPA dues, etc.)"]
[5554,"EDUCATIONAL PROGRAMS – A workshop, field trips, educational workshops, seminars"]
[5558,"EDUCATION SUPPLIES – Resource materials used for classroom activities or research (art supplies, background checks, fingerprinting, uniforms, sports materials)."]
[5352,"EQUIPMENT PURCHASES – Purchases of items individually valued over $500.  This equipment will be inventoried & transferred to TU."]
[5454,"EQUIPMENT RENTAL/PURCHASE – Purchases of items individually valued under $500 or equipment rentals.  (See code 5352 for purchased items over $500)"]
[5452,"EQUIPMENT REPAIRS & MAINTENANCE – Repairs & maintenance to equipment (pianos, office equipment, lab equipment, etc.)"]
[5510,"GIVE GAB FEES – Fees related to the Annual BIG Give"]
[5310,"GOLF – Payments to play in golf tournaments (green fees, cart rentals, food at the golf course, etc.)  USE CODE 6000 for Membership Fees"]
[5252,"HONORARIUM – Payment to a person for their volunteer services or for services for which fees are not traditionally required"]
[5704,"INSURANCE – Payments to obtain / procure insurance coverage"]
[5556,"LAB SERVICES & SUPPLIES – Supplies to be used in a TU lab (propane, kiln supplies, stained glass, chemicals, glassware, etc.)"]
[5904,"LEGAL FEES – Payments to attorneys for legal advice and/or services"]
[6104,"MAILING SERVICES – Payments to a company hired to handle large mailings, zip coding, stuffing envelopes, etc."]
[5302,"MEALS / REFRESHMENTS – Breakfast, Lunch, Dinner expenses with a visitor, guest speaker, potential donor, meal tickets - MUST PROVIDE A LIST OF ATTENDEES"]
[6212,"MISCELLANEOUS – Expenses that don't fit any other category (should be small expenses)"]
[5850,"OFFICE SUPPLIES – Office Expense"]
[5552,"ON-CAMPUS SPONSORED SEMINARS / CONFERENCES – TU Event & Conference Services charges for on-campus events"]
[5602,"OUTSIDE SERVICES – Payments to vendors for amounts invoiced for general services performed (DJ's, audio-visual help, photo services, interpreters, etc.)"]
[6102,"POSTAGE – Stamps, FedEx, UPS, overnight mail, etc."]
[1406,"PREPAID EXPENSES – Use this code when pre-paying for an event or activity to be held at a future date.  The TUF will expense these at the appropriate time the event has concluded"]
[5402,"PRINTING / REPRODUCTION / GRAPHICS – Print jobs, copies of photos, news articles, copies of videos, posters, etc."]
[5304,"PUBLIC RELATIONS / GIFTS – Flowers, t-shirts, pins, TU memorabilia (cash gifts not permitted)"]
[6202,"RECRUITMENT EXPENSE – Taking a job candidate to dinner, lunch, etc., advertising for a job, travel expenses to get a candidate to campus for an interview"]
[6208,"RELOCATION & LIVING EXPENSES – Expenses paid to relocate a new employee, (house hunting, moving and packing expenses, storage fees, transportation, meals and lodging, etc.)"]
[6210,"RENT - ROOM / SPACE / OFFICE – Payment for the use of off-site facilities not related to a conference/seminar"]
[5800,"ROYALTIES / COPYRIGHT FEES – Royalties or copyright fees for manuscripts, plays, music, etc."]
[5456,"SOFTWARE – PURCHASE/LEASE/MAINTENANCE – Purchasing, leasing or maintenance of software, web applications"]
[6010,"SPONSORSHIPS – Payments made in support of events whereby TU is recognized publicly for their support of the event"]
[6050,"TELEPHONE – Telephone, cell phone, FAX, etc."]
[5258,"TEMPORARY EMPLOYMENT SERVICES – Payments to an agency or to individuals for temporary employment services"]
[5306,"TICKETS – COMMUNITY EVENTS – Tickets to events, performances, fund-raisers, sporting events, concerts, etc."]
[5752,"TRAVEL – In-state, out-of-state, foreign travel (parking, hotels, airfare, mileage, tolls, metro, taxi, bus, UBER, etc.) "]
[1403,"TRAVEL CLEARING ACCOUNT - Use this code for expenses you incur that you will be responsible for reimbursing the TU Foundation AFTER you are reimbursed by TU"]

{"sheet":"JE - TUF USE ONLY","index":4,"n_rows":32,"n_cols":23,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+N1","v":{"$error":"#VALUE!"}},{"$f":"+'CC Expense Form Pg 1'!D14","v":""},{"$f":"+'CC Expense Form Pg 1'!E14","v":""},{"$f":"+'CC Expense Form Pg 1'!F14","v":0},{"$f":"+T1","v":"Corp Credit Card Transactions"},{"$f":"+S1","v":"0 - "},{"$f":"IF(W1<3000,\"\",'CC Expense Form Pg 1'!I14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B14,1,4)","v":""},{"$f":"IF(W1<4999,\"01-\",IF('CC Expense Form Pg 1'!K14=\"\",\"\",IF(G1<10000,\"01-\",IF(G1>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"+J1","v":""},{"$f":"IF(W1<4999,\"-0\",IF('CC Expense Form Pg 1'!I14=3450,\"-2\",IF('CC Expense Form Pg 1'!K14=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K14=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(K1,L1,M1)","v":{"$error":"#VALUE!"}},{"$f":"IF('CC Expense Form Pg 1'!H14=\"\",\"\",'CC Expense Form Pg 1'!H14)","v":""},{"$f":"+'CC Expense Form Pg 1'!F8","v":0}," - ",{"$f":"CONCATENATE(P1,Q1,O1)","v":"0 - "},{"$f":"MID(R1,1,100)","v":"0 - "},"Corp Credit Card Transactions",null,{"$f":"-J1","v":{"$error":"#VALUE!"}},{"$f":"-V1","v":{"$error":"#VALUE!"}}]
[{"$f":"+N2","v":{"$error":"#VALUE!"}},{"$f":"+'CC Expense Form Pg 1'!D15","v":""},{"$f":"+'CC Expense Form Pg 1'!E15","v":""},{"$f":"+'CC Expense Form Pg 1'!F15","v":0},"Corp Credit Card Transactions",{"$f":"+S2","v":"0 - "},{"$f":"IF(W2<3000,\"\",'CC Expense Form Pg 1'!I15)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B15,1,4)","v":""},{"$f":"IF(W2<4999,\"01-\",IF('CC Expense Form Pg 1'!K15=\"\",\"\",IF(G2<10000,\"01-\",IF(G2>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W2<4999,\"-0\",IF('CC Expense Form Pg 1'!I15=3450,\"-2\",IF('CC Expense Form Pg 1'!K15=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K15=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(K2,L2,M2)","v":{"$error":"#VALUE!"}},{"$f":"IF('CC Expense Form Pg 1'!H15=\"\",\"\",'CC Expense Form Pg 1'!H15)","v":""},{"$f":"+P1","v":0}," - ",{"$f":"CONCATENATE(P2,Q2,O2)","v":"0 - "},{"$f":"MID(R2,1,100)","v":"0 - "},"Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$f":"-V2","v":{"$error":"#VALUE!"}}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D16","v":""},{"$f":"+'CC Expense Form Pg 1'!E16","v":""},{"$f":"+'CC Expense Form Pg 1'!F16","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W3<3000,\"\",'CC Expense Form Pg 1'!I16)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B16,1,4)","v":""},{"$f":"IF(W3<4999,\"01-\",IF('CC Expense Form Pg 1'!K16=\"\",\"\",IF(G3<10000,\"01-\",IF(G3>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W3<4999,\"-0\",IF('CC Expense Form Pg 1'!I16=3450,\"-2\",IF('CC Expense Form Pg 1'!K16=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K16=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H16=\"\",\"\",'CC Expense Form Pg 1'!H16)","v":""},{"$f":"+P2","v":0}," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D17","v":""},{"$f":"+'CC Expense Form Pg 1'!E17","v":""},{"$f":"+'CC Expense Form Pg 1'!F17","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W4<3000,\"\",'CC Expense Form Pg 1'!I17)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B17,1,4)","v":""},{"$f":"IF(W4<4999,\"01-\",IF('CC Expense Form Pg 1'!K17=\"\",\"\",IF(G4<10000,\"01-\",IF(G4>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W4<4999,\"-0\",IF('CC Expense Form Pg 1'!I17=3450,\"-2\",IF('CC Expense Form Pg 1'!K17=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K17=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H17=\"\",\"\",'CC Expense Form Pg 1'!H17)","v":""},{"$f":"+P3","v":0}," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D18","v":""},{"$f":"+'CC Expense Form Pg 1'!E18","v":""},{"$f":"+'CC Expense Form Pg 1'!F18","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W5<3000,\"\",'CC Expense Form Pg 1'!I18)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B18,1,4)","v":""},{"$f":"IF(W5<4999,\"01-\",IF('CC Expense Form Pg 1'!K18=\"\",\"\",IF(G5<10000,\"01-\",IF(G5>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"+J5","v":""},{"$f":"IF(W5<4999,\"-0\",IF('CC Expense Form Pg 1'!I18=3450,\"-2\",IF('CC Expense Form Pg 1'!K18=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K18=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H18=\"\",\"\",'CC Expense Form Pg 1'!H18)","v":""},{"$f":"+P4","v":0}," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D19","v":""},{"$f":"+'CC Expense Form Pg 1'!E19","v":""},{"$f":"+'CC Expense Form Pg 1'!F19","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W6<3000,\"\",'CC Expense Form Pg 1'!I19)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B19,1,4)","v":""},{"$f":"IF(W6<4999,\"01-\",IF('CC Expense Form Pg 1'!K19=\"\",\"\",IF(G6<10000,\"01-\",IF(G6>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W6<4999,\"-0\",IF('CC Expense Form Pg 1'!I19=3450,\"-2\",IF('CC Expense Form Pg 1'!K19=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K19=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H19=\"\",\"\",'CC Expense Form Pg 1'!H19)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D20","v":""},{"$f":"+'CC Expense Form Pg 1'!E20","v":""},{"$f":"+'CC Expense Form Pg 1'!F20","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W7<3000,\"\",'CC Expense Form Pg 1'!I20)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B20,1,4)","v":""},{"$f":"IF(W7<4999,\"01-\",IF('CC Expense Form Pg 1'!K20=\"\",\"\",IF(G7<10000,\"01-\",IF(G7>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W7<4999,\"-0\",IF('CC Expense Form Pg 1'!I20=3450,\"-2\",IF('CC Expense Form Pg 1'!K20=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K20=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H20=\"\",\"\",'CC Expense Form Pg 1'!H20)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D21","v":""},{"$f":"+'CC Expense Form Pg 1'!E21","v":""},{"$f":"+'CC Expense Form Pg 1'!F21","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W8<3000,\"\",'CC Expense Form Pg 1'!I21)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B21,1,4)","v":""},{"$f":"IF(W8<4999,\"01-\",IF('CC Expense Form Pg 1'!K21=\"\",\"\",IF(G8<10000,\"01-\",IF(G8>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W8<4999,\"-0\",IF('CC Expense Form Pg 1'!I21=3450,\"-2\",IF('CC Expense Form Pg 1'!K21=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K21=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H21=\"\",\"\",'CC Expense Form Pg 1'!H21)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D22","v":""},{"$f":"+'CC Expense Form Pg 1'!E22","v":""},{"$f":"+'CC Expense Form Pg 1'!F22","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W9<3000,\"\",'CC Expense Form Pg 1'!I22)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B22,1,4)","v":""},{"$f":"IF(W9<4999,\"01-\",IF('CC Expense Form Pg 1'!K22=\"\",\"\",IF(G9<10000,\"01-\",IF(G9>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W9<4999,\"-0\",IF('CC Expense Form Pg 1'!I22=3450,\"-2\",IF('CC Expense Form Pg 1'!K22=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K22=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H22=\"\",\"\",'CC Expense Form Pg 1'!H22)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 1'!D23","v":""},{"$f":"+'CC Expense Form Pg 1'!E23","v":""},{"$f":"+'CC Expense Form Pg 1'!F23","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W10<3000,\"\",'CC Expense Form Pg 1'!I23)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 1'!B23,1,4)","v":""},{"$f":"IF(W10<4999,\"01-\",IF('CC Expense Form Pg 1'!K23=\"\",\"\",IF(G10<10000,\"01-\",IF(G10>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W10<4999,\"-0\",IF('CC Expense Form Pg 1'!I23=3450,\"-2\",IF('CC Expense Form Pg 1'!K23=\"Yes\",\"-3\",IF('CC Expense Form Pg 1'!K23=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 1'!H23=\"\",\"\",'CC Expense Form Pg 1'!H23)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$f":"+N11","v":{"$error":"#VALUE!"}},{"$f":"+'CC Expense Form Pg 2'!D14","v":""},{"$f":"+'CC Expense Form Pg 2'!E14","v":""},{"$f":"+'CC Expense Form Pg 2'!F14","v":0},{"$f":"+T11","v":"Corp Credit Card Transactions"},"0 - ",{"$f":"IF(W11<3000,\"\",'CC Expense Form Pg 2'!I14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B14,1,4)","v":""},{"$f":"IF(W11<4999,\"01-\",IF('CC Expense Form Pg 2'!K14=\"\",\"\",IF(G11<10000,\"01-\",IF(G11>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W11<4999,\"-0\",IF('CC Expense Form Pg 2'!I14=3450,\"-2\",IF('CC Expense Form Pg 2'!K14=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K14=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H14=\"\",\"\",'CC Expense Form Pg 2'!H14)","v":""},0," - ",{"$f":"CONCATENATE(P11,Q11,O11)","v":"0 - "},"0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$f":"-V11","v":{"$error":"#VALUE!"}}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D15","v":""},{"$f":"+'CC Expense Form Pg 2'!E15","v":""},{"$f":"+'CC Expense Form Pg 2'!F15","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W12<3000,\"\",'CC Expense Form Pg 2'!I15)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B15,1,4)","v":""},{"$f":"IF(W12<4999,\"01-\",IF('CC Expense Form Pg 2'!K15=\"\",\"\",IF(G12<10000,\"01-\",IF(G12>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W12<4999,\"-0\",IF('CC Expense Form Pg 2'!I15=3450,\"-2\",IF('CC Expense Form Pg 2'!K15=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K15=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H15=\"\",\"\",'CC Expense Form Pg 2'!H15)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D16","v":""},{"$f":"+'CC Expense Form Pg 2'!E16","v":""},{"$f":"+'CC Expense Form Pg 2'!F16","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W13<3000,\"\",'CC Expense Form Pg 2'!I16)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B16,1,4)","v":""},{"$f":"IF(W13<4999,\"01-\",IF('CC Expense Form Pg 2'!K16=\"\",\"\",IF(G13<10000,\"01-\",IF(G13>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W13<4999,\"-0\",IF('CC Expense Form Pg 2'!I16=3450,\"-2\",IF('CC Expense Form Pg 2'!K16=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K16=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H16=\"\",\"\",'CC Expense Form Pg 2'!H16)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D17","v":""},{"$f":"+'CC Expense Form Pg 2'!E17","v":""},{"$f":"+'CC Expense Form Pg 2'!F17","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W14<3000,\"\",'CC Expense Form Pg 2'!I17)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B17,1,4)","v":""},{"$f":"IF(W14<4999,\"01-\",IF('CC Expense Form Pg 2'!K17=\"\",\"\",IF(G14<10000,\"01-\",IF(G14>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W14<4999,\"-0\",IF('CC Expense Form Pg 2'!I17=3450,\"-2\",IF('CC Expense Form Pg 2'!K17=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K17=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H17=\"\",\"\",'CC Expense Form Pg 2'!H17)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D18","v":""},{"$f":"+'CC Expense Form Pg 2'!E18","v":""},{"$f":"+'CC Expense Form Pg 2'!F18","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W15<3000,\"\",'CC Expense Form Pg 2'!I18)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B18,1,4)","v":""},{"$f":"IF(W15<4999,\"01-\",IF('CC Expense Form Pg 2'!K18=\"\",\"\",IF(G15<10000,\"01-\",IF(G15>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W15<4999,\"-0\",IF('CC Expense Form Pg 2'!I18=3450,\"-2\",IF('CC Expense Form Pg 2'!K18=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K18=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H18=\"\",\"\",'CC Expense Form Pg 2'!H18)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D19","v":""},{"$f":"+'CC Expense Form Pg 2'!E19","v":""},{"$f":"+'CC Expense Form Pg 2'!F19","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W16<3000,\"\",'CC Expense Form Pg 2'!I19)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B19,1,4)","v":""},{"$f":"IF(W16<4999,\"01-\",IF('CC Expense Form Pg 2'!K19=\"\",\"\",IF(G16<10000,\"01-\",IF(G16>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W16<4999,\"-0\",IF('CC Expense Form Pg 2'!I19=3450,\"-2\",IF('CC Expense Form Pg 2'!K19=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K19=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H19=\"\",\"\",'CC Expense Form Pg 2'!H19)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D20","v":""},{"$f":"+'CC Expense Form Pg 2'!E20","v":""},{"$f":"+'CC Expense Form Pg 2'!F20","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W17<3000,\"\",'CC Expense Form Pg 2'!I20)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B20,1,4)","v":""},{"$f":"IF(W17<4999,\"01-\",IF('CC Expense Form Pg 2'!K20=\"\",\"\",IF(G17<10000,\"01-\",IF(G17>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W17<4999,\"-0\",IF('CC Expense Form Pg 2'!I20=3450,\"-2\",IF('CC Expense Form Pg 2'!K20=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K20=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H20=\"\",\"\",'CC Expense Form Pg 2'!H20)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D21","v":""},{"$f":"+'CC Expense Form Pg 2'!E21","v":""},{"$f":"+'CC Expense Form Pg 2'!F21","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W18<3000,\"\",'CC Expense Form Pg 2'!I21)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B21,1,4)","v":""},{"$f":"IF(W18<4999,\"01-\",IF('CC Expense Form Pg 2'!K21=\"\",\"\",IF(G18<10000,\"01-\",IF(G18>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W18<4999,\"-0\",IF('CC Expense Form Pg 2'!I21=3450,\"-2\",IF('CC Expense Form Pg 2'!K21=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K21=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H21=\"\",\"\",'CC Expense Form Pg 2'!H21)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D22","v":""},{"$f":"+'CC Expense Form Pg 2'!E22","v":""},{"$f":"+'CC Expense Form Pg 2'!F22","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W19<3000,\"\",'CC Expense Form Pg 2'!I22)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B22,1,4)","v":""},{"$f":"IF(W19<4999,\"01-\",IF('CC Expense Form Pg 2'!K22=\"\",\"\",IF(G19<10000,\"01-\",IF(G19>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W19<4999,\"-0\",IF('CC Expense Form Pg 2'!I22=3450,\"-2\",IF('CC Expense Form Pg 2'!K22=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K22=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H22=\"\",\"\",'CC Expense Form Pg 2'!H22)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 2'!D23","v":""},{"$f":"+'CC Expense Form Pg 2'!E23","v":""},{"$f":"+'CC Expense Form Pg 2'!F23","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W20<3000,\"\",'CC Expense Form Pg 2'!I23)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 2'!B23,1,4)","v":""},{"$f":"IF(W20<4999,\"01-\",IF('CC Expense Form Pg 2'!K23=\"\",\"\",IF(G20<10000,\"01-\",IF(G20>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W20<4999,\"-0\",IF('CC Expense Form Pg 2'!I23=3450,\"-2\",IF('CC Expense Form Pg 2'!K23=\"Yes\",\"-3\",IF('CC Expense Form Pg 2'!K23=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 2'!H23=\"\",\"\",'CC Expense Form Pg 2'!H23)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D14","v":""},{"$f":"+'CC Expense Form Pg 3'!E14","v":""},{"$f":"+'CC Expense Form Pg 3'!F14","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W21<3000,\"\",'CC Expense Form Pg 3'!I14)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B14,1,4)","v":""},{"$f":"IF(W21<4999,\"01-\",IF('CC Expense Form Pg 3'!K14=\"\",\"\",IF(G21<10000,\"01-\",IF(G21>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"+J21","v":""},{"$f":"IF(W21<4999,\"-0\",IF('CC Expense Form Pg 3'!I14=3450,\"-2\",IF('CC Expense Form Pg 3'!K14=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K14=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$f":"CONCATENATE(K21,L21,M21)","v":{"$error":"#VALUE!"}},{"$f":"IF('CC Expense Form Pg 3'!H14=\"\",\"\",'CC Expense Form Pg 3'!H14)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$f":"-V21","v":{"$error":"#VALUE!"}}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D15","v":""},{"$f":"+'CC Expense Form Pg 3'!E15","v":""},{"$f":"+'CC Expense Form Pg 3'!F15","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W22<3000,\"\",'CC Expense Form Pg 3'!I15)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B15,1,4)","v":""},{"$f":"IF(W22<4999,\"01-\",IF('CC Expense Form Pg 3'!K15=\"\",\"\",IF(G22<10000,\"01-\",IF(G22>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W22<4999,\"-0\",IF('CC Expense Form Pg 3'!I15=3450,\"-2\",IF('CC Expense Form Pg 3'!K15=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K15=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H15=\"\",\"\",'CC Expense Form Pg 3'!H15)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$f":"-J22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D16","v":""},{"$f":"+'CC Expense Form Pg 3'!E16","v":""},{"$f":"+'CC Expense Form Pg 3'!F16","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W23<3000,\"\",'CC Expense Form Pg 3'!I16)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B16,1,4)","v":""},{"$f":"IF(W23<4999,\"01-\",IF('CC Expense Form Pg 3'!K16=\"\",\"\",IF(G23<10000,\"01-\",IF(G23>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W23<4999,\"-0\",IF('CC Expense Form Pg 3'!I16=3450,\"-2\",IF('CC Expense Form Pg 3'!K16=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K16=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H16=\"\",\"\",'CC Expense Form Pg 3'!H16)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D17","v":""},{"$f":"+'CC Expense Form Pg 3'!E17","v":""},{"$f":"+'CC Expense Form Pg 3'!F17","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W24<3000,\"\",'CC Expense Form Pg 3'!I17)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B17,1,4)","v":""},{"$f":"IF(W24<4999,\"01-\",IF('CC Expense Form Pg 3'!K17=\"\",\"\",IF(G24<10000,\"01-\",IF(G24>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W24<4999,\"-0\",IF('CC Expense Form Pg 3'!I17=3450,\"-2\",IF('CC Expense Form Pg 3'!K17=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K17=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H17=\"\",\"\",'CC Expense Form Pg 3'!H17)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D18","v":""},{"$f":"+'CC Expense Form Pg 3'!E18","v":""},{"$f":"+'CC Expense Form Pg 3'!F18","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W25<3000,\"\",'CC Expense Form Pg 3'!I18)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B18,1,4)","v":""},{"$f":"IF(W25<4999,\"01-\",IF('CC Expense Form Pg 3'!K18=\"\",\"\",IF(G25<10000,\"01-\",IF(G25>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W25<4999,\"-0\",IF('CC Expense Form Pg 3'!I18=3450,\"-2\",IF('CC Expense Form Pg 3'!K18=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K18=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H18=\"\",\"\",'CC Expense Form Pg 3'!H18)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D19","v":""},{"$f":"+'CC Expense Form Pg 3'!E19","v":""},{"$f":"+'CC Expense Form Pg 3'!F19","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W26<3000,\"\",'CC Expense Form Pg 3'!I19)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B19,1,4)","v":""},{"$f":"IF(W26<4999,\"01-\",IF('CC Expense Form Pg 3'!K19=\"\",\"\",IF(G26<10000,\"01-\",IF(G26>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W26<4999,\"-0\",IF('CC Expense Form Pg 3'!I19=3450,\"-2\",IF('CC Expense Form Pg 3'!K19=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K19=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H19=\"\",\"\",'CC Expense Form Pg 3'!H19)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D20","v":""},{"$f":"+'CC Expense Form Pg 3'!E20","v":""},{"$f":"+'CC Expense Form Pg 3'!F20","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W27<3000,\"\",'CC Expense Form Pg 3'!I20)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B20,1,4)","v":""},{"$f":"IF(W27<4999,\"01-\",IF('CC Expense Form Pg 3'!K20=\"\",\"\",IF(G27<10000,\"01-\",IF(G27>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W27<4999,\"-0\",IF('CC Expense Form Pg 3'!I20=3450,\"-2\",IF('CC Expense Form Pg 3'!K20=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K20=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H20=\"\",\"\",'CC Expense Form Pg 3'!H20)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D21","v":""},{"$f":"+'CC Expense Form Pg 3'!E21","v":""},{"$f":"+'CC Expense Form Pg 3'!F21","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W28<3000,\"\",'CC Expense Form Pg 3'!I21)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B21,1,4)","v":""},{"$f":"IF(W28<4999,\"01-\",IF('CC Expense Form Pg 3'!K21=\"\",\"\",IF(G28<10000,\"01-\",IF(G28>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W28<4999,\"-0\",IF('CC Expense Form Pg 3'!I21=3450,\"-2\",IF('CC Expense Form Pg 3'!K21=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K21=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H21=\"\",\"\",'CC Expense Form Pg 3'!H21)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D22","v":""},{"$f":"+'CC Expense Form Pg 3'!E22","v":""},{"$f":"+'CC Expense Form Pg 3'!F22","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W29<3000,\"\",'CC Expense Form Pg 3'!I22)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B22,1,4)","v":""},{"$f":"IF(W29<4999,\"01-\",IF('CC Expense Form Pg 3'!K22=\"\",\"\",IF(G29<10000,\"01-\",IF(G29>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W29<4999,\"-0\",IF('CC Expense Form Pg 3'!I22=3450,\"-2\",IF('CC Expense Form Pg 3'!K22=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K22=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H22=\"\",\"\",'CC Expense Form Pg 3'!H22)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$error":"#VALUE!"},{"$f":"+'CC Expense Form Pg 3'!D23","v":""},{"$f":"+'CC Expense Form Pg 3'!E23","v":""},{"$f":"+'CC Expense Form Pg 3'!F23","v":0},"Corp Credit Card Transactions","0 - ",{"$f":"IF(W30<3000,\"\",'CC Expense Form Pg 3'!I23)","v":{"$error":"#VALUE!"}},null,null,{"$f":"MID('CC Expense Form Pg 3'!B23,1,4)","v":""},{"$f":"IF(W30<4999,\"01-\",IF('CC Expense Form Pg 3'!K23=\"\",\"\",IF(G30<10000,\"01-\",IF(G30>9999,\"02-\",\"\"))))","v":{"$error":"#VALUE!"}},"",{"$f":"IF(W30<4999,\"-0\",IF('CC Expense Form Pg 3'!I23=3450,\"-2\",IF('CC Expense Form Pg 3'!K23=\"Yes\",\"-3\",IF('CC Expense Form Pg 3'!K23=\"No\",\"-1\",\"\"))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF('CC Expense Form Pg 3'!H23=\"\",\"\",'CC Expense Form Pg 3'!H23)","v":""},0," - ","0 - ","0 - ","Corp Credit Card Transactions",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Must = CC Stmnt Total ==>",null,null,{"$f":"SUM(D1:D31)","v":0}]

{"sheet":"TABLES - TUF USE ONLY","index":5,"n_rows":116,"n_cols":4,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
["Yes"]
["No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1402," - ","Accounts Receivable - Operating",{"$f":"CONCATENATE(A16,B16,C16)","v":"1402 - Accounts Receivable - Operating"}]
[1410," - ","Advance Deposits","1410 - Advance Deposits"]
[5702," - ","Advertising","5702 - Advertising"]
[5204," - ","Alumni Benefits","5204 - Alumni Benefits"]
[5260," - ","Awards","5260 - Awards"]
[5404," - ","Books / Printed Materials / Subscriptions","5404 - Books / Printed Materials / Subscriptions"]
[5950," - ","Building Repairs & Maintenance","5950 - Building Repairs & Maintenance"]
[5300," - ","Catering","5300 - Catering"]
[5654," - ","Conferences & Seminars","5654 - Conferences & Seminars"]
[5256," - ","Consulting & Other Contractual Services","5256 - Consulting & Other Contractual Services"]
[6206," - ","Cost of Goods for Resale","6206 - Cost of Goods for Resale"]
[5508," - ","Credit Card Fees","5508 - Credit Card Fees"]
[6000," - ","Dues & Memberships","6000 - Dues & Memberships"]
[5554," - ","Educational Programs","5554 - Educational Programs"]
[5558," - ","Educational Supplies","5558 - Educational Supplies"]
[5352," - ","Equipment Purchases","5352 - Equipment Purchases"]
[5454," - ","Equipment Rentals","5454 - Equipment Rentals"]
[5452," - ","Equipment Repairs & Maintenance","5452 - Equipment Repairs & Maintenance"]
[6214," - ","Foundation BOD Expense","6214 - Foundation BOD Expense"]
[5510," - ","GiveGab Fees","5510 - GiveGab Fees"]
[5310," - ","Golf","5310 - Golf"]
[5252," - ","Honorarium","5252 - Honorarium"]
[5704," - ","Insurance","5704 - Insurance"]
[5556," - ","Lab Services & Supplies","5556 - Lab Services & Supplies"]
[5904," - ","Legal Fees","5904 - Legal Fees"]
[6104," - ","Mailing Services","6104 - Mailing Services"]
[5302," - ","Meals / Refreshments","5302 - Meals / Refreshments"]
[6212," - ","Miscellaneous Expense","6212 - Miscellaneous Expense"]
[5850," - ","Office Supplies","5850 - Office Supplies"]
[5552," - ","On-Campus Sponsored Seminars / Conferences","5552 - On-Campus Sponsored Seminars / Conferences"]
[5602," - ","Outside Services","5602 - Outside Services"]
[6102," - ","Postage","6102 - Postage"]
[1406," - ","Prepaid Expenses","1406 - Prepaid Expenses"]
[5402," - ","Printing / Reproduction / Graphics","5402 - Printing / Reproduction / Graphics"]
[5304," - ","Public Relations / Gifts","5304 - Public Relations / Gifts"]
[6202," - ","Recruitment Expenses","6202 - Recruitment Expenses"]
[6208," - ","Relocation & Living Expenses","6208 - Relocation & Living Expenses"]
[6210," - ","Rent - Room / Space / Office","6210 - Rent - Room / Space / Office"]
[5800," - ","Royalties / Copyright Fees","5800 - Royalties / Copyright Fees"]
[5456," - ","Software Purchase / Lease / Maintenance","5456 - Software Purchase / Lease / Maintenance"]
[6010," - ","Sponsorships","6010 - Sponsorships"]
[6050," - ","Telephone","6050 - Telephone"]
[5258," - ","Temporary Employment Services","5258 - Temporary Employment Services"]
[5306," - ","Tickets - Community Events","5306 - Tickets - Community Events"]
[5752," - ","Travel","5752 - Travel"]
[1403," - ","Travel Clearing Account","1403 - Travel Clearing Account"]
[5509," - ","WebConnex Fees","5509 - WebConnex Fees"]
[1151," - ","Investments - Operating - Wilmington Trust",{"$f":"CONCATENATE(A63,B63,C63)","v":"1151 - Investments - Operating - Wilmington Trust"}]
[1157," - ","Investments - Operating - Vanguard (TUIG)","1157 - Investments - Operating - Vanguard (TUIG)"]
[1162," - ","Investments - Operating - C.S. McKee S.T. Fixed Income","1162 - Investments - Operating - C.S. McKee S.T. Fixed Income"]
[1195," - ","Investments - Endowment - Wilmington Trust","1195 - Investments - Endowment - Wilmington Trust"]
[1196," - ","Investments - Endowment - C.S. McKee S.T. Fixed Income","1196 - Investments - Endowment - C.S. McKee S.T. Fixed Income"]
[1197," - ","Investments - Endowment - C.S. McKee Aggregate Fixed Income","1197 - Investments - Endowment - C.S. McKee Aggregate Fixed Income"]
[1352," - ","Property & Equipment","1352 - Property & Equipment"]
[1354," - ","Accumulated Depreciation","1354 - Accumulated Depreciation"]
[1401," - ","Clearing Account - Stripe Transaction Fees (BIG Give)","1401 - Clearing Account - Stripe Transaction Fees (BIG Give)"]
[2104," - ","Federal Income Tax W/H Liability","2104 - Federal Income Tax W/H Liability"]
[2106," - ","FICA W/H Tax Liability","2106 - FICA W/H Tax Liability"]
[2108," - ","Medicare Tax W/H Liability","2108 - Medicare Tax W/H Liability"]
[2110," - ","Maryland Income Tax W/H Liability","2110 - Maryland Income Tax W/H Liability"]
[2112," - ","Maryland Unemployment Liability","2112 - Maryland Unemployment Liability"]
[2114," - ","TIAA Retirement Expense & W/H Liability","2114 - TIAA Retirement Expense & W/H Liability"]
[2116," - ","Health Insurance W/H Liability","2116 - Health Insurance W/H Liability"]
[2118," - ","Accrued Salaries Payable","2118 - Accrued Salaries Payable"]
[2120," - ","Annual Fund Payroll W/H Liability",{"$f":"CONCATENATE(A80,B80,C80)","v":"2120 - Annual Fund Payroll W/H Liability"}]
[2122," - ","Dental Insurance W/H Liability","2122 - Dental Insurance W/H Liability"]
[2124," - ","Vision Insurance W/H Liability","2124 - Vision Insurance W/H Liability"]
[2126," - ","Life Insurance W/H Liability","2126 - Life Insurance W/H Liability"]
[2128," - ","S-T Disability W/H Liability","2128 - S-T Disability W/H Liability"]
[2132," - ","AFLAC W/H Liability","2132 - AFLAC W/H Liability"]
[2134," - ","Payroll Garnishment W/H Liability","2134 - Payroll Garnishment W/H Liability"]
[2148," - ","Deferred Revenue","2148 - Deferred Revenue"]
[2150," - ","Maryland Sales Tax Payable","2150 - Maryland Sales Tax Payable"]
[2154," - ","Accrued Expenses","2154 - Accrued Expenses"]
[2202," - ","Annuities Payable","2202 - Annuities Payable"]
[2302," - ","Scholarships Payable","2302 - Scholarships Payable"]
[4102," - ","Gift Income - Alumni - Unrestricted","4102 - Gift Income - Alumni - Unrestricted"]
[4104," - ","Gift Income - Alumni - Restricted or Designated","4104 - Gift Income - Alumni - Restricted or Designated"]
[4106," - ","Gift Income - Alumni - Matching","4106 - Gift Income - Alumni - Matching"]
[4108," - ","Gift Income - Alumni - Gift in Kind","4108 - Gift Income - Alumni - Gift in Kind"]
[4110," - ","Gift Income - Friend - Unrestricted","4110 - Gift Income - Friend - Unrestricted"]
[4112," - ","Gift Income - Friend - Restricted or Designated","4112 - Gift Income - Friend - Restricted or Designated"]
[4114," - ","Gift Income - Friend - Matching","4114 - Gift Income - Friend - Matching"]
[4116," - ","Gift Income - Friend - Gift in Kind","4116 - Gift Income - Friend - Gift in Kind"]
[4118," - ","Gift Income - Foundation - Unrestricted","4118 - Gift Income - Foundation - Unrestricted"]
[4120," - ","Gift Income - Foundation - Restricted or Designated","4120 - Gift Income - Foundation - Restricted or Designated"]
[4122," - ","Gift Income - Foundation - Matching","4122 - Gift Income - Foundation - Matching"]
[4124," - ","Gift Income - Foundation - GIK","4124 - Gift Income - Foundation - GIK"]
[4126," - ","Gift Income - Business - Unrestricted","4126 - Gift Income - Business - Unrestricted"]
[4128," - ","Gift Income - Business - Restricted or Designated","4128 - Gift Income - Business - Restricted or Designated"]
[4130," - ","Gift Income - Business - Matching","4130 - Gift Income - Business - Matching"]
[4132," - ","Gift Income - Business - Gift in Kind","4132 - Gift Income - Business - Gift in Kind"]
[4152," - ","Grants & Contract Income","4152 - Grants & Contract Income"]
[4202," - ","Fee Income - Conference and Seminar","4202 - Fee Income - Conference and Seminar"]
[4302," - ","Sales Revenue - Tickets","4302 - Sales Revenue - Tickets"]
[4304," - ","Sales Revenue - General","4304 - Sales Revenue - General"]
[4352," - ","Other Income","4352 - Other Income"]
[4354," - ","Memberships / Dues Income","4354 - Memberships / Dues Income"]
[4356," - ","Royalty Income","4356 - Royalty Income"]
[4402," - ","Special Event Revenues - Fundraising Activities","4402 - Special Event Revenues - Fundraising Activities"]
[4404," - ","Gift Revenue - Value of Benefits","4404 - Gift Revenue - Value of Benefits"]