{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Data","Output"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":100,"n_cols":22,"rows_kept":100,"merged":[[0,0,0,11],[1,4,1,5],[2,4,2,5],[3,0,3,2],[4,8,4,11],[11,21,13,21]]}
["KK Budget Journal Entry Form",{"$nulls":11},"Field Length","Fund Summaries",null,"NA"]
["Ledger :",{"$nulls":3},"KK_DPT_DT"]
["Header Description :"]
["Journal Date:",{"$nulls":3},"Budget Period:",2024,{"$nulls":7},{"$f":"IF(MONTH(D4)<10,\"0\",\"\")&MONTH(D4)&IF(DAY(D4)<10,\"0\",\"\")&DAY(D4)&YEAR(D4)","v":"01001900"}]
["Line","Fund","Dept ID","Project\nID","Account","Amount",null,null,{"$f":"IF(F4=\"\",\"All required Fields have not been entered!\",IF(D4=\"\",\"All required Fields have not been entered!\",IF( E2=\"\",\"All required Fields have not been entered!\",IF(E3=\"\",\"All required Fields have not been entered!\",\"OK\"))))","v":"All required Fields have not been entered!"}]
{"$rows_empty":8}
[{"$nulls":16},"T"]
[{"$nulls":16},{"$f":"CONCATENATE(V16,,V17,V18,V19,REPT(\" \",U19-LEN(V19)),V20,\"Y\",\"N\",\"1\",E2,REPT(\" \",U24-LEN(E2)),E3,REPT(\" \",U25-LEN(E3)),V26,V27,V28,V29)","v":"H1NWUNVNEXT      01001900YN1KK_DPT_DT                               USDCRRNT010019001"},null,null,"HEADER"]
[{"$f":"IF(B16<>\"\",(A15+1),\"\")","v":""},{"$nulls":15},{"$f":"CONCATENATE(\"L\", REPT(\" \",$U$32),E16,REPT(\" \",$U$33-LEN(E16)),C16,REPT(\" \",$U$34-LEN(C16)), REPT(\" \",$U$35), REPT(\" \",$U$36),B16, REPT(\" \",$U$37-LEN(B16)), REPT(\" \",$U$38), REPT(\" \",$U$39), REPT(\" \",$U$40), REPT(\" \",$U$41), REPT(\" \",$U$42), REPT(\" \",$U$43), REPT(\" \",$U$44), REPT(\" \",$U$45), REPT(\" \",$U$46),REPT(\" \",$U$47),D16,REPT(\" \",$U$48-LEN(D16)), REPT(\" \",$U$49), REPT(\" \",$U$50),$V$51,REPT(\" \",$U$51-4), REPT(\" \",$U$52), REPT(\" \",$U$53),\"USD\")","v":"L                                                                                                                                                                 2024                        USD"},{"$f":"CONCATENATE(  F16,REPT(\" \",$U$55-LEN(F16)),REPT(\" \",$U$56),REPT(\" \",$U$57),\"CRRNT\", REPT(\" \",$U$59),REPT(\" \",$U$59), REPT(\" \",$U$60),REPT(\" \",$U$61), REPT(\" \",$U$62), REPT(\" \",$U$63))","v":"                                                                    CRRNT                                                                                        "},null,"RECORD_TYPE",1,"H"]
[{"$f":"IF(B17<>\"\",(A16+1),\"\")","v":""},{"$nulls":18},"KK_BUDG_TRANS_TYPE",1,1]
[{"$f":"IF(B18<>\"\",(A17+1),\"\")","v":""},{"$nulls":18},"BUSINESS_UNIT",5,"NWUNV"]
["",{"$nulls":18},"JOURNAL_ID",10,"NEXT"]
["",{"$nulls":18},"JOURNAL_DATE",8,{"$f":"N4","v":"01001900"}]
["",{"$nulls":18},"KK_PARENT_ENT_TYPE",1,0]
["",{"$nulls":18},"KK_GEN_PARENT",1,"Y"]
["",{"$nulls":18},"KK_DEFAULT_EE",1,"N"]
["",{"$nulls":18},"LEDGER_GROUP",10]
["",{"$nulls":18},"DESCR",30]
["",{"$nulls":18},"FOREIGN_CURRENCY",3,"USD"]
["",{"$nulls":18},"RT_TYPE",5,"CRRNT"]
["",{"$nulls":18},"CUR_EFFDT",8,{"$f":"N4","v":"01001900"}]
["",{"$nulls":18},"RATE_MULT",17,1]
["",{"$nulls":18},"LINE "]
["",{"$nulls":18},"RECORD_TYPE",1,"L"]
["",{"$nulls":18},"JOURNAL_LINE",9]
["",{"$nulls":18},"ACCOUNT",10]
["",{"$nulls":18},"DEPTID",10]
["",{"$nulls":18},"OPERATING_UNIT",8]
["",{"$nulls":18},"PRODUCT",6]
["",{"$nulls":18},"FUND_CODE",5]
["",{"$nulls":18},"CLASS_FLD",5]
["",{"$nulls":18},"PROGRAM_CODE",5]
["",{"$nulls":18},"BUDGET_REF",8]
["",{"$nulls":18},"AFFILIATE",5]
["",{"$nulls":18},"AFFILIATE_INTRA1",10]
["",{"$nulls":18},"AFFILIATE_INTRA2",10]
["",{"$nulls":18},"CHARTFIELD1",10]
["",{"$nulls":18},"CHARTFIELD2",10]
["",{"$nulls":18},"CHARTFIELD3",10]
["",{"$nulls":18},"BUSINESS_UNIT_PC",5]
["",{"$nulls":18},"PROJECT_ID",15]
["",{"$nulls":18},"ACTIVITY_ID",15]
["",{"$nulls":18},"RESOURCE_TYPE",5]
["",{"$nulls":18},"BUDGET_PERIOD",8,{"$f":"F4","v":2024}]
["",{"$nulls":18},"STATISTICS_CODE",3]
["",{"$nulls":18},"STATISTIC_AMOUNT",17]
["",{"$nulls":18},"FOREIGN_CURRENC",3,"USD"]
["",{"$nulls":18},"FOREIGN_AMOUNT",28]
["",{"$nulls":18},"JRNL_LN_REF",10]
["",{"$nulls":18},"LINE_DESCR",30]
["",{"$nulls":18},"RT_TYPE",5,"CRRNT"]
["",{"$nulls":18},"RATE_MULT",17]
["",{"$nulls":18},"MONETARY_AMOUNT",28]
["",{"$nulls":18},"ENTRY_EVENT",10]
["",{"$nulls":18},"KK_CUM_BEGIN_DT",8]
["",{"$nulls":18},"KK_CUM_END_DT",8]
["",{"$nulls":18},"FUND_SOURCE",6]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[{"$f":"IF(B82<>\"\",(A81+1),\"\")","v":""}]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]
[""]

{"sheet":"Output","index":1,"n_rows":4,"n_cols":1,"rows_kept":4}
[]
[{"$f":"CONCATENATE(Data!Q15)","v":"H1NWUNVNEXT      01001900YN1KK_DPT_DT                               USDCRRNT010019001"}]
[{"$f":"CONCATENATE(Data!Q16,Data!R16)","v":"L                                                                                                                                                                 2024                        USD                                                                    CRRNT                                                                                        "}]
[{"$f":"CONCATENATE(Data!Q17,Data!R17)","v":""}]