{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Budget Journal","Parameters","File Layout"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget Journal","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[14,7,14,9],[15,7,15,9],[16,7,16,9],[17,7,17,9],[18,7,18,9],[7,1,7,6],[8,1,8,6],[11,7,11,9],[12,7,12,9],[13,7,13,9],[24,7,24,9],[25,7,25,9],[26,7,26,9],[27,7,27,9],[28,7,28,9],[19,7,19,9],[20,7,20,9],[21,7,21,9],[22,7,22,9],[23,7,23,9],[34,7,34,9],[35,7,35,9],[36,7,36,9],[37,7,37,9],[38,7,38,9],[29,7,29,9],[30,7,30,9],[31,7,31,9],[32,7,32,9],[33,7,33,9],[44,7,44,9],[45,7,45,9],[46,7,46,9],[47,7,47,9],[48,7,48,9],[39,7,39,9],[40,7,40,9],[41,7,41,9],[42,7,42,9],[43,7,43,9],[54,7,54,9],[55,7,55,9],[56,7,56,9],[57,7,57,9],[58,7,58,9],[49,7,49,9],[50,7,50,9],[51,7,51,9],[52,7,52,9],[53,7,53,9],[64,7,64,9],[65,7,65,9],[66,7,66,9],[67,7,67,9],[68,7,68,9],[59,7,59,9],[60,7,60,9],[61,7,61,9],[62,7,62,9],[63,7,63,9],[74,7,74,9],[75,7,75,9],[76,7,76,9],[77,7,77,9],[78,7,78,9],[69,7,69,9],[70,7,70,9],[71,7,71,9],[72,7,72,9],[73,7,73,9],[84,7,84,9],[85,7,85,9],[86,7,86,9],[87,7,87,9],[88,7,88,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[82,7,82,9],[83,7,83,9],[94,7,94,9],[95,7,95,9],[96,7,96,9],[97,7,97,9],[98,7,98,9],[89,7,89,9],[90,7,90,9],[91,7,91,9],[92,7,92,9],[93,7,93,9],[109,7,109,9],[110,7,110,9],[111,7,111,9],[104,7,104,9],[105,7,105,9],[106,7,106,9],[107,7,107,9],[108,7,108,9],[99,7,99,9],[100,7,100,9],[101,7,101,9],[102,7,102,9],[103,7,103,9]]}
["Actions "]
[]
[]
["Budget Header Information"]
["Business Unit",null,"Ledger Group"]
["Journal Id",null,"Budget Entry Type"]
["Journal Date",null,"Generate Parent?"]
["Description"," "]
["Long Description"," "]
["Budget Line Information"]
["Budget Ref","Fund","Account","Department","Program","Class","Project","Description",null,null,"Jrnl Class","Amount"]

{"sheet":"Parameters","index":1,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Variable Definition"]
[null,"Drive","C"]
[null,"Directory","C:\\TEMP"]
[]
[]
[null," "," "]
[]
[]
[]
[]
[null,null," "]
[null," "," "]
[null,"Budget Entry Types"]
[null,"O","Original"]
[null,"PA","Permanent Adjustment"]
[null,"A","Adjustment"]
[null,null," "]
[]
[null,"Ledger Groups"]
[null,"APPROP","Appropriations"]
[null,"ORG","Organization"]
[null,"REVEST","Revenue Estimate"]
[null,"PROJ_GRT","Project / Grant"]
[null,"PRMST_EXP","Project Expense - Overall"]
[null,"PRMST_REV","Project Revenue - Overall"]
[]
[]
[]
[]
[]
[]
[]
[null,"Business Unit"]

{"sheet":"File Layout","index":2,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Column","Length","Start","End","PS Field"]
["Business Unit",5,1,{"$f":"C2-1+B2","v":5},"BUSINESS_UNIT"]
["Journal Id",10,{"$f":"D2+1","v":6},{"$f":"C3-1+B3","v":15},"JOURNAL_ID"]
["Journal Date",10,{"$f":"D3+1","v":16},{"$f":"C4-1+B4","v":25},"JOURNAL_DATE"]
["Journal Line",9,{"$f":"D4+1","v":26},{"$f":"C5-1+B5","v":34},"LEDGER_GROUP"]
["Ledger Group",10,35,44,"LEDGER_GROUP"]
["Budget Entry Type",1,45,45]
["Description",30,46,75,"DESCR"]
["Budget Period",8,76,83,"BUDGET_PERIOD"]
["Department",10,84,93,"DEPTID"]
["Fund",5,94,98,"FUND_CODE"]
["Program",5,99,103,"PROGRAM_CODE"]
["Account",10,104,113,"ACCOUNT"]
["Budget Reference",8,114,121,"BUDGET_REF"]
["Class",8,122,129,"CLASS_FLD"]
["Flex Field",10,130,139,"CHARTFIELD1"]
["Project",15,140,154,"PROJECT_ID"]
["Amount",28,155,182,"MONETARY_AMOUNT"]
["Begin Date",10,183,192,"BEGIN_DT"]
["End Date",10,193,202,"END_DT"]