{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","GLBA","Budget Revision","New Year Budget"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":2},"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":"Instructions","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["In Datatel Run Report:   GLBA - Budget to Actual Report",null,null,null,null,null,null,null,null,"To Revise a Budget"]
[]
["Fiscal Year","Current Fiscal Year",null,null,null,null,null,null,null,"When the cursor is on the line you would like to revise, click on the Revise Budget button on top"]
["Calendar Ending Month of ",6]
["Include Accounts that have","A"]
[]
["GL Account Definition","Drill down"]
[]
["Select/List","Drill down"]
[]
["Inc/Exc",null,"Fund.Group,Fund"]
["Line 1","I ","71 and/or 72 and/or 73"]
[null,null,"GL.CLASS,GL.SUBCLASS,CATEGORY,SUBCATEGORY,OBJECT"]
["Line 9","I ","4 & 5"]
[]
["Prompt for additional selection criteria = N"]
["Save and Update"]
[]
["Sort","Drill down"]
["GLS.Fund","Break = Y"]
["Verify Criteria","No"]
["Detail or Summarize","Summary"]
[]
["Generate Spreadsheet","Yes"]
["Output Device","H"]
["The information is generated in an Excel file"]
[]
["Select all information and copy",null,"Shift Ctrl End will select all information"]
[]
["Paste the information in cell A1 on the GLBA Tab"]
[]
["Click on the Refresh Button"]

{"sheet":"GLBA","index":1,"n_rows":62,"n_cols":19,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["GL Account","GL Description","Allocated Budget","Actual","% Used","Available","Budget Officer","Fund","Fund Description","Account Number","Type","Activity Code","Activity Code Description","Object Code","Object Code Description","Current Year Budget","Current Year Actual","Budget Revision","New Budget"]
["71-0000-1960-696503-48820","Gen : Contrib Grants : AS-ASMJC Presents : Stdnt Development/Campus Life : Assoc Students",0,-2500,0,2500,"Unassigned",{"$f":"LEFT(A1:A2,2)","v":"71"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696503-48820"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696503"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-ASMJC Presents "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48820"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Contrib Grants "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":2500}]
["71-0000-1960-696503-55669","Gen : Activ Events : AS-ASMJC Presents : Stdnt Development/Campus Life : Assoc Students",30000,24229.85,80.77,5770.15,"Unassigned",{"$f":"LEFT(A2:A62,2)","v":"71"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696503-55669"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696503"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-ASMJC Presents "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55669"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activ Events "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":30000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":24229.85}]
["71-0000-1960-696503-55670","Gen : Activities-AS : AS-ASMJC Presents : Stdnt Development/Campus Life : Assoc Students",0,9.6,0,-9.6,"Unassigned",{"$f":"LEFT(A3:A4,2)","v":"71"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696503-55670"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696503"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-ASMJC Presents "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55670"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activities-AS "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":9.6}]
["71-0000-1960-696505-55669","Gen : Activ Events : AS-Cult Div & Ethnic Prog : Stdnt Development/Campus Life : Assoc Students",15000,3204.65,21.36,11795.35,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696505-55669"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696505"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Cult Div & Ethnic Prog "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55669"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activ Events "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":15000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":3204.65}]
["71-0000-1960-696513-55669","Gen : Activ Events : AS-Senator Projects : Stdnt Development/Campus Life : Assoc Students",5000,0,0,5000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696513-55669"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696513"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Senator Projects "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55669"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activ Events "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":5000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696514-55669","Gen : Activ Events : AS-Graduation Supplies : Stdnt Development/Campus Life : Assoc Students",20000,0,0,20000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696514-55669"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696514"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Graduation Supplies "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55669"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activ Events "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":20000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696530-48860","Gen : Int Incm : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,-6593.04,0,6593.04,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-48860"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48860"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Int Incm "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":6593.04}]
["71-0000-1960-696530-48861","Gen : Unreal Gain/(Loss) : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,1631.1,0,-1631.1,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-48861"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48861"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Unreal Gain/(Loss) "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":-1631.1}]
["71-0000-1960-696530-48885","Gen : Other Stu Fees & Charges : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",-300000,-188080,62.69,-111920,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-48885"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48885"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other Stu Fees & Charges "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":300000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":188080}]
["71-0000-1960-696530-48890","Gen : Other Loc Rev : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,-1925.15,0,1925.15,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-48890"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48890"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other Loc Rev "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":1925.15}]
["71-0000-1960-696530-52110","Gen : NonInstuc-Reg : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",50000,15372.5,30.75,34627.5,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-52110"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"52110"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstuc-Reg "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":50000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":15372.5}]
["71-0000-1960-696530-53000","Gen : Benefit Budget Pool : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",40000,0,0,40000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":40000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696530-53203","Gen : PERS-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,3900.02,0,-3900.02,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":3900.02}]
["71-0000-1960-696530-53303","Gen : OASDI-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,953.1,0,-953.1,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":953.1}]
["71-0000-1960-696530-53313","Gen : Medicare-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,222.88,0,-222.88,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":222.88}]
["71-0000-1960-696530-53403","Gen : Health-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,4131.5,0,-4131.5,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":4131.5}]
["71-0000-1960-696530-53453","Gen : Dental-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,275.75,0,-275.75,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":275.75}]
["71-0000-1960-696530-53463","Gen : Vision-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,55.25,0,-55.25,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":55.25}]
["71-0000-1960-696530-53473","Gen : LTD-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,30.25,0,-30.25,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":30.25}]
["71-0000-1960-696530-53493","Gen : Ret Hlth Liab-Class Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,261.87,0,-261.87,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":261.87}]
["71-0000-1960-696530-53503","Gen : St Unempl-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,88.36,0,-88.36,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":88.36}]
["71-0000-1960-696530-53603","Gen : WC-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,217.81,0,-217.81,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":217.81}]
["71-0000-1960-696530-53903","Gen : Life-Class Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,14.6,0,-14.6,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":14.6}]
["71-0000-1960-696530-54431","Gen : NonInstruc-Supplies : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",5000,1535.9,30.72,3464.1,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-54431"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"54431"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstruc-Supplies "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":5000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":1535.9}]
["71-0000-1960-696530-54464","Gen : NonInstruc-Food/Hospitality : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",2000,0,0,2000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-54464"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"54464"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstruc-Food/Hospitality "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":2000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696530-54501","Gen : NonInstruc-Dup Use : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",4000,0,0,4000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-54501"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"54501"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstruc-Dup Use "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":4000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696530-55446","Gen : Services-Repair/Maintenance : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",5000,894.36,17.89,4105.6400000000003,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-55446"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55446"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Services-Repair/Maintenance "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":5000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":894.36}]
["71-0000-1960-696530-55450","Gen : Services-Postage : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,22.82,0,-22.82,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-55450"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55450"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Services-Postage "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":22.82}]
["71-0000-1960-696530-55771","Gen : Rentals-Equipment : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",8000,2335.86,29.2,5664.14,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-55771"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55771"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Rentals-Equipment "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":8000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":2335.86}]
["71-0000-1960-696530-55991","Gen : Other-Unrest : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",0,0.42,0,-0.42,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0.42}]
["71-0000-1960-696530-56400","Gen : Equipment<$5K : AS-Oper Activities : Stdnt Development/Campus Life : Assoc Students",1000,0,0,1000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696530-56400"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"56400"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Equipment<$5K "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":1000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696532-55991","Gen : Other-Unrest : AS-Club Development : Stdnt Development/Campus Life : Assoc Students",10000,765.49,7.65,9234.51,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696532-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696532"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Club Development "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":10000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":765.49}]
["71-0000-1960-696536-55991","Gen : Other-Unrest : AS-Awards & Recognition : Stdnt Development/Campus Life : Assoc Students",10000,0,0,10000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696536-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696536"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Awards & Recognition "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":10000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696540-55991","Gen : Other-Unrest : AS-Activity Fee Expense : Stdnt Development/Campus Life : Assoc Students",8000,49.74,0.62,7950.26,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696540-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696540"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Activity Fee Expense "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":8000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":49.74}]
["71-0000-1960-696546-55991","Gen : Other-Unrest : AS-FLOW : Stdnt Development/Campus Life : Assoc Students",60000,25636.87,42.73,34363.129999999997,"Unassigned",{"$f":"LEFT(A35:A36,2)","v":"71"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696546-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696546"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-FLOW "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":60000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":25636.87}]
["71-0000-1960-696554-55991","Gen : Other-Unrest : AS-African American Conf : Stdnt Development/Campus Life : Assoc Students",3000,0,0,3000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696554-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696554"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-African American Conf "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":3000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696555-55991","Gen : Other-Unrest : AS-Hispanic Education Conf : Stdnt Development/Campus Life : Assoc Students",3000,0,0,3000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696555-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696555"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Hispanic Education Conf "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":3000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["71-0000-1960-696556-55991","Gen : Other-Unrest : AS-Pride Education Conf : Stdnt Development/Campus Life : Assoc Students",3000,0,0,3000,"Unassigned","71",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"71 - Assoc Students"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"71-0000-1960-696556-55991"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696556"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Pride Education Conf "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55991"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other-Unrest "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":3000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["72-0000-1960-696530-48860","Gen : Int Incm : AS-Oper Activities : Stdnt Development/Campus Life : Student Rep Fee",0,0,0,0,"Unassigned","72",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"72 - Student Rep Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"72-0000-1960-696530-48860"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48860"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Int Incm "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["72-0000-1960-696530-48861","Gen : Unreal Gain/(Loss) : AS-Oper Activities : Stdnt Development/Campus Life : Student Rep Fee",0,0,0,0,"Unassigned","72",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"72 - Student Rep Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"72-0000-1960-696530-48861"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48861"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Unreal Gain/(Loss) "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["72-0000-1960-696530-48884","Gen : Student Representation Fee : AS-Oper Activities : Stdnt Development/Campus Life : Student Rep Fee",-60000,-37626,62.71,-22374,"Unassigned","72",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"72 - Student Rep Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"72-0000-1960-696530-48884"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48884"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Student Representation Fee "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":60000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":37626}]
["72-0000-1960-696530-55666","Gen : Activities-Workshops/Conferenc : AS-Oper Activities : Stdnt Development/Campus Life : Student Rep Fee",30000,27527.200000000001,91.76,2472.8000000000002,"Unassigned","72",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"72 - Student Rep Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"72-0000-1960-696530-55666"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55666"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Activities-Workshops/Conferenc "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":30000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":27527.200000000001}]
["72-0000-1960-696530-55881","Gen : Other Expenses : AS-Oper Activities : Stdnt Development/Campus Life : Student Rep Fee",30000,5925,19.75,24075,"Unassigned","72",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"72 - Student Rep Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"72-0000-1960-696530-55881"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"55881"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Other Expenses "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":30000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":5925}]
["73-0000-1960-696530-48860","Gen : Int Incm : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,0,0,0,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-48860"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48860"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Int Incm "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["73-0000-1960-696530-48861","Gen : Unreal Gain/(Loss) : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,0,0,0,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-48861"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48861"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Unreal Gain/(Loss) "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["73-0000-1960-696530-48883","Gen : Student Center Fee : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",-100000,-86608,86.61,-13392,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-48883"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Revenue"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"48883"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Student Center Fee "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":100000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":86608}]
["73-0000-1960-696530-52110","Gen : NonInstuc-Reg : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",98000,41780.5,42.63,56219.5,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-52110"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"52110"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstuc-Reg "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":98000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":41780.5}]
["73-0000-1960-696530-52331","Gen : Stu-NonInstruc-Hourly : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,1344.45,0,-1344.45,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-52331"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"52331"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Stu-NonInstruc-Hourly "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":1344.45}]
["73-0000-1960-696530-53000","Gen : Benefit Budget Pool : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",65000,0,0,65000,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":65000},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":0}]
["73-0000-1960-696530-53203","Gen : PERS-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,10599.72,0,-10599.72,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":10599.72}]
["73-0000-1960-696530-53303","Gen : OASDI-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,2590.4,0,-2590.4,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":2590.4}]
["73-0000-1960-696530-53313","Gen : Medicare-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,605.79999999999995,0,-605.79999999999995,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":605.79999999999995}]
["73-0000-1960-696530-53403","Gen : Health-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,17604,0,-17604,"Unassigned",{"$f":"LEFT(A53:A54,2)","v":"73"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":17604}]
["73-0000-1960-696530-53453","Gen : Dental-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,1006.5,0,-1006.5,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":1006.5}]
["73-0000-1960-696530-53463","Gen : Vision-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,221,0,-221,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":221}]
["73-0000-1960-696530-53473","Gen : LTD-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,82.3,0,-82.3,"Unassigned",{"$f":"LEFT(A56:A57,2)","v":"73"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":82.3}]
["73-0000-1960-696530-53493","Gen : Ret Hlth Liab-Class Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,1047.5,0,-1047.5,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":1047.5}]
["73-0000-1960-696530-53503","Gen : St Unempl-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,240.25,0,-240.25,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":240.25}]
["73-0000-1960-696530-53603","Gen : WC-Classif Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,592.04,0,-592.04,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":592.04}]
["73-0000-1960-696530-53903","Gen : Life-Class Non Class : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,58.5,0,-58.5,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-53000"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"53000"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"Fringe Benefits"},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":58.5}]
["73-0000-1960-696530-54501","Gen : NonInstruc-Dup Use : AS-Oper Activities : Stdnt Development/Campus Life : Student Body Ctr Fee",0,73.400000000000006,0,-73.400000000000006,"Unassigned","73",{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Fund]],Table1[[Fund]:[Fund Description]],2,FALSE),LEFT(Table1[[#This Row],[GL Account]],2)&\" - \"&MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)+1)+2,40))","v":"73 - Student Body Ctr Fee"},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",LEFT(Table1[[#This Row],[GL Account]],20)&\"53000\",Table1[[#This Row],[GL Account]])","v":"73-0000-1960-696530-54501"},{"$f":"+IF(MID(Table1[[#This Row],[GL Account]],21,1)=\"4\",\"Revenue\",\"Expenditures\")","v":"Expenditures"},{"$f":"MID(Table1[[#This Row],[GL Account]],14,6)","v":"696530"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Activity Code]],Table1[[#All],[Activity Code]:[Activity Code Description]],2,FALSE),MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-2))","v":"AS-Oper Activities "},{"$f":"IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"53000\",RIGHT(Table1[[#This Row],[GL Account]],5))","v":"54501"},{"$f":"IF(CELL(\"type\",Table1[[#This Row],[GL Description]])=\"b\",VLOOKUP(Table1[[#This Row],[Object Code]],Table1[[Object Code]:[Object Code Description]],2,FALSE),IF(MID(Table1[[#This Row],[GL Account]],21,2)=\"53\",\"Fringe Benefits\",MID(Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+2,FIND(\":\",Table1[[#This Row],[GL Description]],FIND(\":\",Table1[[#This Row],[GL Description]],1)+1)-FIND(\":\",Table1[[#This Row],[GL Description]],1)-2)))","v":"NonInstruc-Dup Use "},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Allocated Budget]],Table1[[#This Row],[Allocated Budget]])","v":0},{"$f":"IF(Table1[[#This Row],[Type]]=\"Revenue\",-Table1[[#This Row],[Actual]],Table1[[#This Row],[Actual]])","v":73.400000000000006}]

{"sheet":"Budget Revision","index":2,"n_rows":500,"n_cols":12,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
["ASMJC Budget Revision",null,"ASMJC President/Designee:",null,"Date:"]
[null,null,"Dean of Student Services:",null,"Date:"]
[]
[]
[]
["Fund Description","71 - Assoc Students"]
[null,null,null,"Estimated Surplus(Deficit)",{"$f":"IFERROR(GETPIVOTDATA(\"Current Budget\",$A$8,\"Type\",\"Revenue\"),0)-IFERROR(GETPIVOTDATA(\"Current Budget\",$A$8,\"Type\",\"Expenditures\"),0)","v":18000},null,null,{"$f":"IFERROR(GETPIVOTDATA(\"Revision\",$A$8,\"Type\",\"Revenue\"),0)-IFERROR(GETPIVOTDATA(\"Revision\",$A$8,\"Type\",\"Expenditures\"),0)","v":0},{"$f":"IFERROR(GETPIVOTDATA(\"Revised Budget\",$A$8,\"Type\",\"Revenue\"),0)-IFERROR(GETPIVOTDATA(\"Revised Budget\",$A$8,\"Type\",\"Expenditures\"),0)","v":18000}]
["Type","Activity Code Description","Account Number","Object Code Description","Current Budget","Actuals","Balance","Revision","Revised Budget","Revised Balance","Amount","Type"]
["Expenditures","AS-ASMJC Presents ","71-0000-1960-696503-55669","Activ Events ",30000,24229.85,5770.1500000000015,null,30000,5770.1500000000015,{"$f":"IF(CELL(\"type\",H9)=\"b\",\"\",ABS(H9))","v":""},{"$f":"IF(CELL(\"type\",C9)=\"b\",\"\",IF(CELL(\"type\",H9)=\"b\",\"\",IF(MID(C9,21,1)=\"4\",IF(H9>0,\"Credit\",\"Debit\"),IF(H9>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,"71-0000-1960-696503-55670","Activities-AS ",0,9.6,-9.6,null,0,-9.6,{"$f":"IF(CELL(\"type\",H10)=\"b\",\"\",ABS(H10))","v":""},""]
[null,"AS-Cult Div & Ethnic Prog ","71-0000-1960-696505-55669","Activ Events ",15000,3204.65,11795.35,null,15000,11795.35,"",""]
[null,"AS-Senator Projects ","71-0000-1960-696513-55669","Activ Events ",5000,0,5000,null,5000,5000,"",""]
[null,"AS-Oper Activities ","71-0000-1960-696530-52110","NonInstuc-Reg ",50000,15372.5,34627.5,null,50000,34627.5,"",""]
[null,null,"71-0000-1960-696530-53000","Fringe Benefits",40000,10151.390000000001,29848.61,null,40000,29848.61,"",""]
[null,null,"71-0000-1960-696530-54431","NonInstruc-Supplies ",5000,1535.9,3464.1,null,5000,3464.1,"",""]
[null,null,"71-0000-1960-696530-54464","NonInstruc-Food/Hospitality ",2000,0,2000,null,2000,2000,"",""]
[null,null,"71-0000-1960-696530-54501","NonInstruc-Dup Use ",4000,0,4000,null,4000,4000,"",""]
[null,null,"71-0000-1960-696530-55446","Services-Repair/Maintenance ",5000,894.36,4105.6400000000003,null,5000,4105.6400000000003,"",""]
[null,null,"71-0000-1960-696530-55771","Rentals-Equipment ",8000,2335.86,5664.1399999999994,null,8000,5664.1399999999994,"",""]
[null,null,"71-0000-1960-696530-56400","Equipment<$5K ",1000,0,1000,null,1000,1000,"",""]
[null,null,"71-0000-1960-696530-55450","Services-Postage ",0,22.82,-22.82,null,0,-22.82,"",""]
[null,null,"71-0000-1960-696530-55991","Other-Unrest ",0,0.42,-0.42,null,0,-0.42,"",""]
[null,"AS-Club Development ","71-0000-1960-696532-55991","Other-Unrest ",10000,765.49,9234.51,null,10000,9234.51,"",""]
[null,"AS-Awards & Recognition ","71-0000-1960-696536-55991","Other-Unrest ",10000,0,10000,null,10000,10000,"",""]
[null,"AS-Activity Fee Expense ","71-0000-1960-696540-55991","Other-Unrest ",8000,49.74,7950.26,null,8000,7950.26,"",""]
[null,"AS-FLOW ","71-0000-1960-696546-55991","Other-Unrest ",60000,25636.87,34363.130000000005,null,60000,34363.130000000005,"",""]
[null,"AS-Graduation Supplies ","71-0000-1960-696514-55669","Activ Events ",20000,0,20000,null,20000,20000,"",""]
[null,"AS-African American Conf ","71-0000-1960-696554-55991","Other-Unrest ",3000,0,3000,null,3000,3000,"",""]
[null,"AS-Hispanic Education Conf ","71-0000-1960-696555-55991","Other-Unrest ",3000,0,3000,null,3000,3000,"",""]
[null,"AS-Pride Education Conf ","71-0000-1960-696556-55991","Other-Unrest ",3000,0,3000,null,3000,3000,"",{"$f":"IF(CELL(\"type\",C30)=\"b\",\"\",IF(CELL(\"type\",H30)=\"b\",\"\",IF(MID(C30,21,1)=\"4\",IF(H30>0,\"Credit\",\"Debit\"),IF(H30>0,\"Debit\",\"Credit\"))))","v":""}]
["Expenditures Total",null,null,null,282000,84209.45,197790.55000000002,null,282000,197790.55000000002,"",{"$f":"IF(CELL(\"type\",C31)=\"b\",\"\",IF(CELL(\"type\",H31)=\"b\",\"\",IF(MID(C31,21,1)=\"4\",IF(H31>0,\"Credit\",\"Debit\"),IF(H31>0,\"Debit\",\"Credit\"))))","v":""}]
["Revenue","AS-ASMJC Presents ","71-0000-1960-696503-48820","Contrib Grants ",0,2500,-2500,null,0,-2500,"",""]
[null,"AS-Oper Activities ","71-0000-1960-696530-48860","Int Incm ",0,6593.04,-6593.04,null,0,-6593.04,"",""]
[null,null,"71-0000-1960-696530-48885","Other Stu Fees & Charges ",300000,188080,111920,null,300000,111920,"",""]
[null,null,"71-0000-1960-696530-48861","Unreal Gain/(Loss) ",0,-1631.1,1631.1,null,0,1631.1,"",""]
[null,null,"71-0000-1960-696530-48890","Other Loc Rev ",0,1925.15,-1925.15,null,0,-1925.15,"",""]
["Revenue Total",null,null,null,300000,197467.09,102532.91,null,300000,102532.91,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H74)=\"b\",\"\",ABS(H74))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C95)=\"b\",\"\",IF(CELL(\"type\",H95)=\"b\",\"\",IF(MID(C95,21,1)=\"4\",IF(H95>0,\"Credit\",\"Debit\"),IF(H95>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H138)=\"b\",\"\",ABS(H138))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C159)=\"b\",\"\",IF(CELL(\"type\",H159)=\"b\",\"\",IF(MID(C159,21,1)=\"4\",IF(H159>0,\"Credit\",\"Debit\"),IF(H159>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H202)=\"b\",\"\",ABS(H202))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C223)=\"b\",\"\",IF(CELL(\"type\",H223)=\"b\",\"\",IF(MID(C223,21,1)=\"4\",IF(H223>0,\"Credit\",\"Debit\"),IF(H223>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H266)=\"b\",\"\",ABS(H266))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C287)=\"b\",\"\",IF(CELL(\"type\",H287)=\"b\",\"\",IF(MID(C287,21,1)=\"4\",IF(H287>0,\"Credit\",\"Debit\"),IF(H287>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H330)=\"b\",\"\",ABS(H330))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C351)=\"b\",\"\",IF(CELL(\"type\",H351)=\"b\",\"\",IF(MID(C351,21,1)=\"4\",IF(H351>0,\"Credit\",\"Debit\"),IF(H351>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H394)=\"b\",\"\",ABS(H394))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C415)=\"b\",\"\",IF(CELL(\"type\",H415)=\"b\",\"\",IF(MID(C415,21,1)=\"4\",IF(H415>0,\"Credit\",\"Debit\"),IF(H415>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",H458)=\"b\",\"\",ABS(H458))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(CELL(\"type\",C479)=\"b\",\"\",IF(CELL(\"type\",H479)=\"b\",\"\",IF(MID(C479,21,1)=\"4\",IF(H479>0,\"Credit\",\"Debit\"),IF(H479>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"New Year Budget","index":3,"n_rows":500,"n_cols":8,"rows_kept":500,"cut":false,"hidden":false,"merged":[]}
["ASMJC Budget Set-up Form",null,"ASMJC President/Designee:",null,"Date:"]
[null,null,"Dean of Campus Life:",null,"Date:"]
["Fund Description","(All)","Vice President of Student Services",null,"Date:"]
[null,null,null,null,{"$f":"IFERROR(GETPIVOTDATA(\"Sum of Current Year Budget\",$A$5,\"Type\",\"Revenue\"),0)-IFERROR(GETPIVOTDATA(\"Sum of Current Year Budget\",$A$5,\"Type\",\"Expenditures\"),0)","v":-45000},"Estimated Surplus(Deficit)",{"$f":"IFERROR(GETPIVOTDATA(\"New Year Budget\",$A$5,\"Type\",\"Revenue\"),0)-IFERROR(GETPIVOTDATA(\"New Year Budget\",$A$5,\"Type\",\"Expenditures\"),0)","v":0}]
["Type","Activity Code Description","Account Number","Object Code Description","Sum of Current Year Budget","Sum of Current Year Actual","New Year Budget","Type"]
["Expenditures","AS-ASMJC Presents ","71-0000-1960-696503-55669","Activ Events ",30000,24229.85,null,{"$f":"IF(CELL(\"type\",C6)=\"b\",\"\",IF(CELL(\"type\",G6)=\"b\",\"\",IF(MID(C6,21,1)=\"4\",IF(G6>0,\"Credit\",\"Debit\"),IF(G6>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,"71-0000-1960-696503-55670","Activities-AS ",0,9.6,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Cult Div & Ethnic Prog ","71-0000-1960-696505-55669","Activ Events ",15000,3204.65,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Senator Projects ","71-0000-1960-696513-55669","Activ Events ",5000,0,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Oper Activities ","71-0000-1960-696530-52110","NonInstuc-Reg ",50000,15372.5,null,""]
[null,null,"71-0000-1960-696530-53000","Fringe Benefits",40000,10151.390000000001,null,""]
[null,null,"71-0000-1960-696530-54431","NonInstruc-Supplies ",5000,1535.9,null,""]
[null,null,"71-0000-1960-696530-54464","NonInstruc-Food/Hospitality ",2000,0,null,""]
[null,null,"71-0000-1960-696530-54501","NonInstruc-Dup Use ",4000,0,null,""]
[null,null,"71-0000-1960-696530-55446","Services-Repair/Maintenance ",5000,894.36,null,""]
[null,null,"71-0000-1960-696530-55450","Services-Postage ",0,22.82,null,{"$f":"IF(CELL(\"type\",C19)=\"b\",\"\",IF(CELL(\"type\",G19)=\"b\",\"\",IF(MID(C19,21,1)=\"4\",IF(G19>0,\"Credit\",\"Debit\"),IF(G19>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,"71-0000-1960-696530-55771","Rentals-Equipment ",8000,2335.86,null,{"$f":"IF(CELL(\"type\",C20)=\"b\",\"\",IF(CELL(\"type\",G20)=\"b\",\"\",IF(MID(C20,21,1)=\"4\",IF(G20>0,\"Credit\",\"Debit\"),IF(G20>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,"71-0000-1960-696530-55991","Other-Unrest ",0,0.42,null,""]
[null,null,"71-0000-1960-696530-56400","Equipment<$5K ",1000,0,null,""]
[null,null,"72-0000-1960-696530-55666","Activities-Workshops/Conferenc ",30000,27527.200000000001,null,""]
[null,null,"72-0000-1960-696530-55881","Other Expenses ",30000,5925,null,""]
[null,null,"73-0000-1960-696530-52110","NonInstuc-Reg ",98000,41780.5,null,""]
[null,null,"73-0000-1960-696530-52331","Stu-NonInstruc-Hourly ",0,1344.45,null,""]
[null,null,"73-0000-1960-696530-53000","Fringe Benefits",65000,34648.01,null,""]
[null,null,"73-0000-1960-696530-54501","NonInstruc-Dup Use ",0,73.400000000000006,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Club Development ","71-0000-1960-696532-55991","Other-Unrest ",10000,765.49,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Awards & Recognition ","71-0000-1960-696536-55991","Other-Unrest ",10000,0,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Activity Fee Expense ","71-0000-1960-696540-55991","Other-Unrest ",8000,49.74,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-FLOW ","71-0000-1960-696546-55991","Other-Unrest ",60000,25636.87,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Graduation Supplies ","71-0000-1960-696514-55669","Activ Events ",20000,0,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-African American Conf ","71-0000-1960-696554-55991","Other-Unrest ",3000,0,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Hispanic Education Conf ","71-0000-1960-696555-55991","Other-Unrest ",3000,0,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Pride Education Conf ","71-0000-1960-696556-55991","Other-Unrest ",3000,0,null,""]
[null,null,null,null,null,null,null,""]
["Expenditures Total",null,null,null,505000,195508.00999999998,null,""]
[null,null,null,null,null,null,null,""]
["Revenue","AS-ASMJC Presents ","71-0000-1960-696503-48820","Contrib Grants ",0,2500,null,""]
[null,null,null,null,null,null,null,""]
[null,"AS-Oper Activities ","71-0000-1960-696530-48860","Int Incm ",0,6593.04,null,""]
[null,null,"71-0000-1960-696530-48861","Unreal Gain/(Loss) ",0,-1631.1,null,""]
[null,null,"71-0000-1960-696530-48885","Other Stu Fees & Charges ",300000,188080,null,""]
[null,null,"71-0000-1960-696530-48890","Other Loc Rev ",0,1925.15,null,""]
[null,null,"72-0000-1960-696530-48860","Int Incm ",0,0,null,""]
[null,null,"72-0000-1960-696530-48861","Unreal Gain/(Loss) ",0,0,null,""]
[null,null,"72-0000-1960-696530-48884","Student Representation Fee ",60000,37626,null,""]
[null,null,"73-0000-1960-696530-48860","Int Incm ",0,0,null,""]
[null,null,"73-0000-1960-696530-48861","Unreal Gain/(Loss) ",0,0,null,""]
[null,null,"73-0000-1960-696530-48883","Student Center Fee ",100000,86608,null,""]
[null,null,null,null,null,null,null,""]
["Revenue Total",null,null,null,460000,321701.08999999997,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C84)=\"b\",\"\",IF(CELL(\"type\",G84)=\"b\",\"\",IF(MID(C84,21,1)=\"4\",IF(G84>0,\"Credit\",\"Debit\"),IF(G84>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C148)=\"b\",\"\",IF(CELL(\"type\",G148)=\"b\",\"\",IF(MID(C148,21,1)=\"4\",IF(G148>0,\"Credit\",\"Debit\"),IF(G148>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C212)=\"b\",\"\",IF(CELL(\"type\",G212)=\"b\",\"\",IF(MID(C212,21,1)=\"4\",IF(G212>0,\"Credit\",\"Debit\"),IF(G212>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C276)=\"b\",\"\",IF(CELL(\"type\",G276)=\"b\",\"\",IF(MID(C276,21,1)=\"4\",IF(G276>0,\"Credit\",\"Debit\"),IF(G276>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C340)=\"b\",\"\",IF(CELL(\"type\",G340)=\"b\",\"\",IF(MID(C340,21,1)=\"4\",IF(G340>0,\"Credit\",\"Debit\"),IF(G340>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C404)=\"b\",\"\",IF(CELL(\"type\",G404)=\"b\",\"\",IF(MID(C404,21,1)=\"4\",IF(G404>0,\"Credit\",\"Debit\"),IF(G404>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,{"$f":"IF(CELL(\"type\",C468)=\"b\",\"\",IF(CELL(\"type\",G468)=\"b\",\"\",IF(MID(C468,21,1)=\"4\",IF(G468>0,\"Credit\",\"Debit\"),IF(G468>0,\"Debit\",\"Credit\"))))","v":""}]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]