{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Section 103 Job Aid","APP_SETTINGS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Section 103 Job Aid","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,1,13,5],[13,7,13,9],[1,1,1,3],[2,6,2,9],[5,1,5,5],[9,1,9,5],[9,7,9,8]]}
[]
[null,"Calculated Manual Awards"]
[null,"Yellow Ribbon Payment"," 74B (Claimant)"," 75B (School)",null,null,{"$f":"IF(AND(B4=0,C4=0,D4=0),\"NO MANUAL AWARD\",\"MANUAL AWARD \")","v":"NO MANUAL AWARD"}]
[null,0,0,0]
[]
[null,"Totals",null,null,null,null,null,"School",{"$f":"IF(ISBLANK(I8),\"\",\"Private School\")","v":""}]
[null,"Total Payments","Total 74B","Total 75B","Net Yellow Ribbon Paid","Yellow Ribbon Due",null,"Facility Code",{"$f":"IF(ISBLANK(I8),\"\",\"National Maximum\")","v":""}]
[null,{"$f":"SUM(IF(ManualAwardsTable[Type]=\"PAYMENT\",ManualAwardsTable[Amount],0))","v":0},{"$f":"SUM(IF(ManualAwardsTable[Type]=\"74B\",ManualAwardsTable[Amount],0))","v":0},{"$f":"SUM(IF(ManualAwardsTable[Type]=\"75B\",ManualAwardsTable[Amount],0))","v":0},{"$f":"SUM(IF(ManualAwardsTable[Type]=\"PAYMENT\",ManualAwardsTable[Amount],IF(OR(ManualAwardsTable[Type]=\"74B\",ManualAwardsTable[Type]=\"75B\"),ManualAwardsTable[Amount]*-1,0)))","v":0},0]
[]
[null,"Enrolllment",null,null,null,null,null,"Correction"]
[null,"Type","Begin","End","Tuition","Yellow Ribbon",null,"Tuition","Yellow Ribbon"]
[]
[]
[null,"Amendments",null,null,null,null,null,"Previous Manual Yellow Ribbon Awards"]
[null,"Type","Protected","Effective Date","Tuition","Yellow Ribbon",null,"Date","Amount","Type"]

{"sheet":"APP_SETTINGS","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["ANNUAL CAP"]
[23671.94]