Spreadsheet: 725133d1616553581-sumifs-offset-proc-file
Sheet: Sheet1

FY | SSN_Parent | PRGM | OA | Org | MDEP | SSN_Baby | Allotment | Commitment | Obligation
2019 | AD5070A | BASE | 5L | USAASC | 0000 | AD5070A | 29913000 | 0 | 0 |  |  | Data to sum | Col H
2019 | AD5070A | BASE | 5L | USAASC | FPFB | AD5070A | 0 | 29913000 | 29913000 |  |  | Expected Result | Col F:  RH01
2019 | B00009A | BASE | 00 | Withholding/ Execution Errors | 0000 | B00009A | 0 | 0 | 0 |  |  |  | Col E:  USAASC
2019 | B00009A | BASE | 5F | USAASC | 0000 | B00009A | 13888000 | 0 | 0 |  |  |  | Col E:  AMC
2019 | B00009A | BASE | 5F | USAASC | FPMC | B00009A | 0 | 13609791.58 | 12809791.58
2019 | B00010A | BASE | 00 | Withholding/ Execution Errors | 0000 | B00010A | 135412.2 | 0 | 0
2019 | B00010A | BASE | 5F | USAASC | 0000 | B00010A | 82044563.66000001 | 0 | 0
2019 | B00010A | BASE | 5F | USAASC | FPMC | B00010A | 0 | 82044563.65999998 | 81579278.65999998
2019 | B03001A | BASE | 00 | Withholding/ Execution Errors | 0000 | B03001A | 0 | 0 | 0
2019 | B03001A | BASE | 5D | USAASC | RH01 | B03001A | 0 | 8411000 | 8411000
2019 | B03001A | SUPP | 5D | USAASC | RH01 | B03001A | 0 | 13190000 | 13190000
2019 | B03001A | Unknown | 5D | USAASC | (blank) | B03001A | 21601000 | 0 | 0
2019 | B05201A | BASE | 5L | USAASC | 0000 | B05201A | 6107000 | 0 | 0
2019 | B05201A | BASE | 5L | USAASC | FPDH | B05201A | 0 | 6059544.83 | 6034157.83
2019 | B07100A | BASE | 00 | Withholding/ Execution Errors | 0000 | B07100A | 214000 | 0 | 0
2019 | B07100A | BASE | 5F | USAASC | 0000 | B07100A | 568153000 | 0 | 0
2019 | B07100A | BASE | 5F | USAASC | FPMC | [NAME] | 0 | 565784136.29 | 565717394.0799999
2019 | B08400A | BASE | 00 | Withholding/ Execution Errors | 0000 | B08400A | 0 | 0 | 0
2019 | B08400A | BASE | 5F | USAASC | 0000 | B08400A | 32553000 | 0 | 0
2019 | B08400A | BASE | 5F | USAASC | FPMC | B00015A | 0 | 31376648.63 | 31184698.63
2019 | B22603A | BASE | 00 | Withholding/ Execution Errors | 0000 | B22603A | 10000 | 0 | 0
2019 | B22603A | BASE | 5F | USAASC | 0000 | B22603A | 6724999.999999999 | 0 | 0
2019 | B22603A | BASE | 5F | USAASC | FPFB | B22603A | 0 | 6680357.29 | 6680357.29
2019 | B28501A | BASE | 00 | Withholding/ Execution Errors | 0000 | B28501A | 9000 | 0 | 0
2019 | B28501A | BASE | 5F | USAASC | 0000 | B28501A | 19715000.00000001 | 0 | 0
2019 | B28501A | BASE | 5F | USAASC | FPFL | B28620A | 0 | 7265246.609999999 | 7265246.609999999
2019 | B28501A | BASE | 5F | USAASC | FPFL | BZ9851A | 0 | 10611431.57 | 10611431.57
2019 | B28501A | BASE | 5F | USAASC | FPFL | B28504A | 0 | 1679000 | 1679000
2019 | B29810A | BASE | 00 | Withholding/ Execution Errors | 0000 | B29810A | 0 | 0 | 0
2019 | B29810A | BASE | 0W | UNDISTRIBUTED | 0000 | B29810A | 0 | 0 | 0
2019 | B29810A | BASE | 5F | USAASC | 0000 | B29810A | 0 | 0 | 0
2019 | B33000A | BASE | 00 | Withholding/ Execution Errors | 0000 | B33000A | 0 | 0 | 0
2019 | B33000A | BASE | 5T | USAASC | 0000 | B33000A | 24460000 | 0 | 0
2019 | B33000A | BASE | 5T | USAASC | MSHS | B33011A | 0 | 24435849.48999999 | 24435849.48999999
2019 | B54020A | BASE | 00 | Withholding/ Execution Errors | 0000 | B54020A | 0 | 0 | 0
2019 | B54020A | BASE | 0W | UNDISTRIBUTED | 0000 | B54020A | 2747000 | 0 | 0
2019 | B54020A | BASE | 1B | USAASC | 0000 | B54020A | 7929000 | 0 | 0
2019 | B54020A | BASE | 1B | USAASC | FPSN | B54020A | 0 | 7501967.409999999 | 7501967.409999999
2019 | B55500A | BASE | 00 | Withholding/ Execution Errors | 0000 | B55500A | 0 | 0 | 0
2019 | B55500A | BASE | 5T | USAASC | 0000 | B55500A | 10969000 | 0 | 0
2019 | B55500A | BASE | 5T | USAASC | VGFB | BE4168A | 0 | 4394797.88 | 4394797.88
2019 | B55500A | BASE | 5T | USAASC | VGFB | B55511A | 0 | 6574202.119999999 | 6574202.119999999
2019 | B55510A | BASE | 00 | Withholding/ Execution Errors | 0000 | B55510A | 0 | 0 | 0
2019 | B55510A | BASE | 1D | USAASC | 0000 | B55510A | 812000 | 0 | 0
2019 | B55510A | BASE | 1D | USAASC | RJS1 | B55510A | 0 | 812000 | 812000
2019 | B55510A | SUPP | 1D | USAASC | 0000 | B55510A | 9549000 | 0 | 0
2019 | B55510A | SUPP | 1D | USAASC | RJS1 | B55510A | 0 | 9003829.219999999 | 9003829.219999999
2019 | B58601A | BASE | 00 | Withholding/ Execution Errors | 0000 | B58601A | 0 | 0 | 0
2019 | B58601A | BASE | 5Y | USAASC | 0000 | B58601A | 16258000 | 0 | 0
2019 | B58601A | BASE | 5Y | USAASC | FPMC | B58601A | 0 | 16257630.67 | 16257630.67
2019 | B63000A | BASE | 00 | Withholding/ Execution Errors | 0000 | B63000A | 0 | 0 | 0
2019 | B63000A | BASE | 5T | USAASC | 0000 | B63000A | 51320000 | 0 | 0
2019 | B63000A | BASE | 5T | USAASC | FPFP | B63103A | 0 | 51069972.80999999 | 51069972.71
2019 | [NAME] | BASE | 1E | USAASC | 0000 | [NAME] | 0 | 0 | 0
2019 | [NAME] | BASE | 1E | USAASC | RL07 | [NAME] | 0 | 2733511.96 | 3000000
2019 | [NAME] | BASE | 1E | USAASC | (blank) | [NAME] | 3000000 | 0 | 0
2019 | [NAME] | Unknown | 1E | USAASC | RL07 | [NAME] | 0 | 3000000 | 0
2019 | B66001A | BASE | 00 | Withholding/ Execution Errors | 0000 | B66001A | 0 | 0 | 0
2019 | B66001A | BASE | 0W | UNDISTRIBUTED | 0000 | B66001A | 0 | 0 | 0
2019 | B66001A | BASE | 5T | USAASC | 0000 | B66001A | 0 | 0 | 0
2019 | B66001A | BASE | 5T | USAASC | X4SA | B66002A | 0 | 0 | 0
2019 | B66501A | BASE | 08 | USACE | 0000 | B66501A | 66330000 | 0 | 0
2019 | B66501A | BASE | 08 | USACE | RK11 | B66501A | 0 | 66178694.16 | 66178694.16
2019 | B66501A | Unknown | 08 | USACE | RK11 | B66501A | 0 | -629449.9 | -629592.7600000001
2019 | B66701A | BASE | 00 | Withholding/ Execution Errors | 0000 | B66701A | 0 | 0 | 0
2019 | B66701A | BASE | 5T | USAASC | 0000 | B66701A | 16782000 | 0 | 0
2019 | B66701A | BASE | 5T | USAASC | FPFP | B66706A | 0 | 16779975.38 | 16779975.38
2019 | B68501A | BASE | 00 | Withholding/ Execution Errors | 0000 | B68501A | 0 | 0 | 0
2019 | B68501A | BASE | 5F | USAASC | 0000 | B68501A | 4391000 | 0 | 0
2019 | B68501A | BASE | 5F | USAASC | FPMC | B68501A | 0 | 4391000 | 4391000
2019 | B70000A | BASE | 00 | Withholding/ Execution Errors | 0000 | B70000A | 0 | 0 | 0
2019 | B70000A | BASE | 5F | USAASC | 0000 | B70000A | 20497000 | 0 | 0
2019 | B70000A | BASE | 5F | USAASC | FPFP | B70005A | 0 | 20496968.72 | 20496968.72
2019 | B85800A | BASE | 00 | Withholding/ Execution Errors | 0000 | B85800A | 0 | 0 | 0
2019 | B85800A | BASE | 5F | USAASC | 0000 | B85800A | 69819000 | 0 | 0
2019 | B85800A | BASE | 5F | USAASC | FPMJ | B85800A | 0 | 69819000.00000001 | 69819000.00000001
2019 | B85800A | SUPP | 5F | USAASC | 0000 | B85800A | 7100000 | 0 | 0
2019 | B85800A | SUPP | 5F | USAASC | FPMJ | B85800A | 0 | 7100000.000000001 | 7100000.000000001
2019 | B85800A | SUPP | 5T | USAASC | 0000 | B85800A | 0 | 0 | 0
2019 | B88801A | BASE | 00 | Withholding/ Execution Errors | 0000 | B88801A | 0 | 0 | 0
2019 | B88801A | BASE | 5D | USAASC | 0000 | B88801A | 127892008.12 | 0 | 0
2019 | B88801A | BASE | 5D | USAASC | X4SA | B88801A | 0 | 125036992.48 | 123001417.98
2019 | B88801A | BASE | 5R | USAASC | 0000 | B88801A | 16245991.88 | 0 | 0
2019 | B88801A | BASE | 5R | USAASC | X4SA | B88801A | 0 | 15712579.88 | 15712579.88
2019 | B89000A | BASE | 5T | USAASC | 0000 | B89000A | 330000 | 0 | 0
2019 | B89000A | BASE | 5T | USAASC | FPFP | B89001A | 0 | 330000 | 330000
2019 | B95004A | BASE | 00 | Withholding/ Execution Errors | 0000 | B95004A | 0 | 0 | 0
2019 | B95004A | BASE | 0W | UNDISTRIBUTED | 0000 | B95004A | 0 | 0 | 0
2019 | B95004A | BASE | 5F | USAASC | 0000 | B95004A | 294702988.0000001 | 0 | 0
2019 | B95004A | BASE | 5F | USAASC | FPMM | B95006A | 0 | 78085240.58 | 78085240.58
2019 | B95004A | BASE | 5F | USAASC | FPMM | B95007A | 0 | 216445371.92 | 216445371.92
2019 | B96000A | BASE | 00 | Withholding/ Execution Errors | 0000 | B96000A | 10000 | 0 | 0
2019 | B96000A | BASE | 0W | UNDISTRIBUTED | 0000 | B96000A | 0 | 0 | 0
2019 | B96000A | BASE | 5F | USAASC | 0000 | B96000A | 62027999.99999999 | 0 | 0
2019 | B96000A | BASE | 5F | USAASC | FPMC | B96002A | 0 | 26346452.48 | 26346452.48
2019 | B96000A | BASE | 5F | USAASC | FPMC | B96004A | 0 | 35678573.65 | 35678573.65
2019 | B99901A | BASE | 08 | USACE | 0000 | B99901A | 1177000 | 0 | 0
2019 | B99901A | BASE | 08 | USACE | FPFS | B99901A | 0 | 1176994.61 | 1176994.61
2019 | B99901A | BASE | 5D | USAASC | 0000 | B99901A | 0 | 0 | 0
2019 | B99901A | Unknown | 08 | USACE | FPFS | B99901A | 0 | 0 | 0
2019 | BA0326A | BASE | 6A | AMC | 0000 | BA0326A | 20623000 | 0 | 0
2019 | BA0326A | BASE | 76 | FORSCOM | 0000 | BA0326A | 15000 | 0 | 0
2019 | BA0326A | SUPP | 6A | AMC | 0000 | BA0326A | 6326000 | 0 | 0
2019 | BA0326A | SUPP | 6A | AMC | VIRQ | BA0326A | 0 | 5400000 | 5400000
2019 | BA0326A | SUPP | 6A | AMC | VOFS | BA0326A | 0 | 926000 | 926000
2019 | BA0326A | Unknown | 6A | AMC | GPIS | BA0326A | 0 | 14552849.73 | 14552849.73
2019 | BA0326A | Unknown | 6A | AMC | RH01 | BA0326A | 0 | 6666734.97 | 6666734.97
2019 | BA0326A | Unknown | 6A | AMC | (blank) | BA0326A | 0 | 0 | 0
2019 | BA0326A | ERI | 6A | AMC | 0000 | BA0326A | 600000 | 0 | 0
2019 | BA1300A | BASE | 5D | USAASC | 0000 | BA1300A | 8319000 | 0 | 0
2019 | BA1300A | BASE | 5D | USAASC | MSEC | BA1300A | 0 | 8319000 | 8319000
2019 | BA5500A | BASE | 00 | Withholding/ Execution Errors | 0000 | BA5500A | 0 | 0 | 0
2019 | BA5500A | BASE | 5L | USAASC | 0000 | BA5500A | 159210197.79 | 0 | 0
2019 | BA5500A | BASE | 5L | USAASC | FPDH | B05310A | 0 | 158545232.4699999 | 158317972.9399999
2019 | BA5500A | SUPP | 5L | USAASC | 0000 | BA5500A | 164024000 | 0 | 0
2019 | BA5500A | SUPP | 5L | USAASC | FPDH | B05310A | 0 | 164024000 | 164024000
2019 | BA9301A | BASE | 00 | Withholding/ Execution Errors | 0000 | BA9301A | 0 | 0 | 0
2019 | BA9301A | BASE | 5F | USAASC | 0000 | BA9301A | 15084000 | 0 | 0
2019 | BA9301A | BASE | 5F | USAASC | FPMC | BA9315A | 0 | 8189000 | 8189000
2019 | BA9301A | BASE | 5F | USAASC | FPMC | BA9312A | 0 | 6894922.039999999 | 6894922.039999999
2019 | BA9320A | BASE | 00 | Withholding/ Execution Errors | 0000 | BA9320A | 0 | 0 | 0
2019 | BA9320A | BASE | 5F | USAASC | 0000 | BA9320A | 29140000 | 0 | 0
2019 | BA9320A | BASE | 5F | USAASC | FPFP | BA9320A | 0 | 29140000 | 29140000
2019 | BA9350A | BASE | 00 | Withholding/ Execution Errors | 0000 | BA9350A | 0 | 0 | 0
2019 | BA9350A | BASE | 0W | UNDISTRIBUTED | 0000 | BA9350A | 0 | 0 | 0
2019 | BA9350A | BASE | 5F | USAASC | 0000 | BA9350A | 10374000 | 0 | 0
2019 | BA9350A | BASE | 5F | USAASC | FPMJ | BA9350A | 0 | 10345645.75 | 10316322.74
2019 | BB5777A | BASE | 6A | AMC | 0000 | BB5777A | 4866000 | 0 | 0
2019 | BB5777A | BASE | 6A | AMC | FPMC | BB5777A | 0 | 4864815.26 | 4864815.26
2019 | BB8500A | BASE | 00 | Withholding/ Execution Errors | 0000 | BB8500A | 0 | 0 | 0
2019 | BB8500A | BASE | 5T | USAASC | 0000 | BB8500A | 96605000 | 0 | 0
2019 | BB8500A | BASE | 5T | USAASC | FPMH | BB8509A | 0 | 48299345.68999999 | 48299345.68999999
2019 | BB8500A | BASE | 5T | USAASC | FPMH | B08900A | 0 | 1997409.67 | 1920247.9
2019 | BB8500A | BASE | 5T | USAASC | FPMH | BB8416A | 0 | 23973286.32 | 23973286.32
2019 | BB8500A | BASE | 5T | USAASC | FPMH | BB8501A | 0 | 22318785.54 | 22318785.54
2019 | BB8500A | BASE | 6A | AMC | 0000 | BB8500A | 0 | 0 | 0
2019 | BB8650A | BASE | 0W | UNDISTRIBUTED | 0000 | BB8650A | 0 | 0 | 0
2019 | BB8650A | BASE | 6A | AMC | 0000 | BB8650A | 71314000.00000001 | 0 | 0
2019 | BB8650A | BASE | 6A | AMC | ERVC | BB1400A | 0 | 15869321.05 | 15869321.05
2019 | BB8650A | BASE | 6A | AMC | ERVT | BB8700A | 0 | 5440000 | 5440000
2019 | BB8650A | BASE | 6A | AMC | GPIS | B31510A | 0 | 31955904.75 | 31955904.75
2019 | BB8650A | BASE | 6A | AMC | MXUS | BB1400A | 0 | 430678.95 | 430678.95
2019 | BB8650A | BASE | 6A | AMC | MXUS | B31510A | 0 | 11051000 | 11051000
2019 | BB8650A | BASE | 6A | AMC | OISR | B31510A | 0 | 1581000 | 1581000
2019 | BB8650A | BASE | 6A | AMC | WGMD | B31510A | 0 | 165000 | 165000
2019 | BB8650A | BASE | 6A | AMC | WHST | B31510A | 0 | 491000 | 491000
2019 | BB8650A | BASE | 6A | AMC | XMGI | B31510A | 0 | 4326975.25 | 4320274.76
2019 | BB8650A | SUPP | 00 | Withholding/ Execution Errors | 0000 | BB8650A | 0 | 0 | 0
2019 | BB8650A | SUPP | 0W | UNDISTRIBUTED | 0000 | BB8650A | 0 | 0 | 0
2019 | BB8650A | SUPP | 6A | AMC | 0000 | BB8650A | 0 | 0 | 0
2019 | BC3000A | BASE | 00 | Withholding/ Execution Errors | 0000 | BC3000A | 0 | 0 | 0
2019 | BC3000A | BASE | 0W | UNDISTRIBUTED | 0000 | BC3000A | 0 | 0 | 0
2019 | BC3000A | BASE | 5D | USAASC | RH01 | BC3000A | 0 | 1186827.7 | 1186827.7
2019 | BC3000A | BASE | 5D | USAASC | (blank) | BC3000A | 1187000 | 0 | 0
2019 | BC4002A | BASE | 00 | Withholding/ Execution Errors | 0000 | BC4002A | 0 | 0 | 0
2019 | BC4002A | BASE | 5F | USAASC | 0000 | BC4002A | 22988000 | 0 | 0
2019 | BC4002A | BASE | 5F | USAASC | FPMJ | BC4002A | 0 | 22986282.12 | 22986282.12
2019 | BC4120A | BASE | 00 | Withholding/ Execution Errors | 0000 | BC4120A | 0 | 0 | 0
2019 | BC4120A | BASE | 5F | USAASC | 0000 | BC4120A | 17673000 | 0 | 0
2019 | BC4120A | BASE | 5F | USAASC | FPMJ | BC4120A | 0 | 17672702.31 | 17669692.35
2019 | BD3000A | BASE | 00 | Withholding/ Execution Errors | 0000 | BD3000A | 180270.04 | 0 | 0