{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["CNGPRJHOLD"],"read":"whole","date_system":"1900"}

{"sheet":"CNGPRJHOLD","index":0,"n_rows":25,"n_cols":11,"rows_kept":25}
[]
["EXAMPLE:"]
["STEP 1 - Establish Budget in PPM"]
["BC","Activity","Fund","Function ","Program","Project","Budget","Actuals","Balance"]
["BC10","A01611",19900,40,"000","KXXXXXXX99",{"v":50000,"d":"50,000.00"},0,{"$f":"G5-H5","v":{"v":50000,"d":"50,000.00"}},null,"PPM Transactor"]
["BC20","A01611",19900,40,"000","KXXXXXXX99",{"v":30000,"d":"30,000.00"},0,{"v":30000,"d":"30,000.00"},null,"PPM Transactor"]
[]
["STEP 2 - Establish Cost Share Budget in Oracle Budget"]
["BC","Activity","Fund","Function ","Program","Project","Budget","Actuals","Balance"]
["BC75","A01611",19900,40,"000","No Project",{"v":-80000,"d":"(80,000.00)"},0,{"$f":"G10-H10","v":{"v":-80000,"d":"(80,000.00)"}},null,"Dept Transaction"]
["BC75","A01611",19900,40,"000","CNGPRJHOLD",{"v":80000,"d":"80,000.00"},0,{"v":80000,"d":"80,000.00"},null,"Dept Transaction"]
[]
["STEP 3 - Expenses hit against the project"]
["BC10","A01611",19900,40,"000","KXXXXXXX99",0,{"v":45000,"d":"45,000.00"},{"$f":"G14-H14","v":{"v":-45000,"d":"(45,000.00)"}},null,"This is the feed from the GL"]
["BC20","A01611",19900,40,"000","KXXXXXXX99",0,{"v":25000,"d":"25,000.00"},{"$f":"G15-H15","v":{"v":-25000,"d":"(25,000.00)"}}]
[]
[]
["STEP 4 - Actuals remapped in Oracle Budget"]
["BC75","A01611",19900,40,"000","CNGPRJHOLD",{"v":80000,"d":"80,000.00"},0,{"$f":"G19-H19","v":{"v":80000,"d":"80,000.00"}}]
["BC10","A01611",19900,40,"000","CNGPRJHOLD",0,{"$f":"H14","v":{"v":45000,"d":"45,000.00"}},{"v":-45000,"d":"(45,000.00)"},null,"For EPM, the system will run a rule to change the K99 project to the CNGPRJHOLD using same COA"]
["BC20","A01611",19900,40,"000","CNGPRJHOLD",0,{"$f":"H15","v":{"v":25000,"d":"25,000.00"}},{"v":-25000,"d":"(25,000.00)"}]
[{"$nulls":6},{"$f":"SUM(G19:G21)","v":{"v":80000,"d":"80,000.00"}},{"$f":"SUM(H19:H21)","v":{"v":70000,"d":"70,000.00"}},{"$f":"SUM(I19:I21)","v":{"v":10000,"d":"10,000.00"}},null,"CFD process will net all expenses to BC75 where the budget is and move any balance to the new year.  If expenses are final, dept can move balance back to their No Project COA."]
[]
["*Since actuals can encompass multiple K99 Projects - EPM will have a feature to drill through on actuals to see what K99 projects make up the CNGPRJHOLD actuals amounts."]
["**For any K99 projects that FY24 expenses, the unit only has to budget the remaining cost share project budget."]