Spreadsheet: 866835d1713764351-false-result-from-deeply-nested-if-formula-financial-chart-example
Sheet: Consolidated_Invoices

Project | SUBPROJECT/TO/FMS | Payment Date EOM | SUBMITTED DATE | GOVERNMENT DOCUMENT IDENTIFIER | CONTRACT NUMBER | CONTRACT TYPE | DELIVERY ORDER NUMBER | SHIPMENT NUMBER | SHIPMENT DATE | FINAL SHIPMENT INDICATOR | INVOICE NUMBER | INVOICE DATE | INVOICE RECEIVED DATE | DOCUMENT TOTAL | ACTIVE ARCHIVE INDICATOR | DOCUMENT TYPE | COMBO TYPE | INPUT TYPE | DOCUMENT CATEGORY | RECEIVER DATE | LPO CERTIFIED DATE | ACCEPTANCE DATE | LPO REJECT DATE | INSPECTION POINT | ACCEPTANCE POINT | CERTIFICATE OF CONFORMANCE (COC) INDICATOR | ALTERNATE RELEASE PROGRAM (ARP) INDICATOR | UID INDICATOR | PACK INDICATOR | FINAL INDICATOR | ATTACHMENT INDICATOR | QUICK SIGN | VENDOR CAGE | VENDOR CAGE EXT | CONTRACTOR NAME | ADMIN DODAAC | ADMIN NAME | INSPECT BY DODAAC | INSPECT BY EXT | [NAME] | ACCEPTOR NAME | SHIP FROM | ISSUE DODAAC | ISSUE EXT | ISSUE BY NAME | SHIP TO DODAAC | SHIP TO EXT | LPO DODAAC | LPO EXT | LPO NAME | PAY DODAAC | PAY OFFICE NAME | PERIOD OF PERFORMANCE TO | PERIOD OF PERFORMANCE FROM | CLIN | LINE ITEM DESCRIPTION | UNIT OF MEASURE | LINE ITEM UNIT PRICE | LINE ITEM TOTAL PRICE | ACTUAL QUANTITY | [NAME] | QUANTITY RECEIVED | SDN | AAI | ACRN | ACRN AMOUNT | ACRNS | PRODUCT/SERVICE ID QUALIFIER | PRODUCT/SERVICE ID | ITEM SERIAL NUMBER | UII | UII TYPE | SUBLINE NUMBER | SUBLINE AAI | SUBLINE SDN | SUBLINE ACRN | SUBLINE ACRN AMOUNT | VOUCHER NUMBER | PAYMENT DATE | STATUS | INSPECTOR EMAIL | EVENT IDS | NOTES
Proj A |  |  | 2023-02-28 | 133731999 | FA714623C0006 | DoD Contract (Non-FAR) |  | 11015 | 2023-02-28 | N | 11015 | 2023-02-28 | 2023-02-28 | 568725.63 | ARCHIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-04-07 |  | 2023-04-07 |  | D | D |  |  |  |  | N | N |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] | FA7146 |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 |  |  | 0001 | MAC Project - Phases 3.7 and 3.8 | LO | 568725.63 | 568725.63 | 0.0 | 1.0 | 1.0 |  |  | AA | 568725.63 |  | FT - FEDERAL SUPPLY CLASSIFICATION | R425 |  |  |  |  |  |  |  |  | 43002729 | 2023-04-24 | Paid
Proj A |  |  | 2023-02-28 | 133731937 | FA714623C0006 | DoD Contract (Non-FAR) |  | 11014 | 2023-01-31 | N | 11014 | 2023-01-31 | 2023-02-28 | 568725.63 | ARCHIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-04-07 |  | 2023-04-07 |  | D | D |  |  |  |  | N | N |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 |  |  | 0001 | MAC Project - Phases 3.7 and 3.8 | LO | 568725.63 | 568725.63 | 0.0 | 1.0 | 1.0 |  |  | AA | 568725.63 |  | FT - FEDERAL SUPPLY CLASSIFICATION | R425 |  |  |  |  |  |  |  |  | 43002730 | 2023-04-24 | Paid
Proj A |  |  | 2023-04-21 | 134887545 | FA714623C0006 | DoD Contract (Non-FAR) |  | 11047 | 2023-04-21 | N | 11047 | 2023-04-21 | 2023-04-21 | 568725.63 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-05-17 |  | 2023-05-17 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-12-31 | 2023-01-01 | 0001 | MAC Project - Phases 3.7 and 3.8 | LO | 568725.63 | 568725.63 | 0.0 | 1.0 | 1.0 |  |  |  |  |  | FT - FEDERAL SUPPLY CLASSIFICATION | R425 |  |  |  |  |  |  |  |  |  | 2023-05-25 | Paid
Proj A |  |  | 2023-04-27 | 135021517 | FA714623C0006 | DoD Contract (Non-FAR) |  | 11109 | 2023-04-27 | N | 11109 | 2023-04-27 | 2023-04-27 | 568725.62 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-05-05 |  | 2023-05-05 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-12-31 | 2023-01-01 | 0001 | MAC Project - Phases 3.7 and 3.8 | LO | 568725.62 | 568725.62 | 0.0 | 1.0 | 1.0 |  |  |  |  |  | FT - FEDERAL SUPPLY CLASSIFICATION | R425 |  |  |  |  |  |  |  |  | 48503606 | 2023-05-22 | Paid
Proj A |  |  | 2023-07-06 | 136467991 | FA714623C0006 | DoD Contract (FAR) |  | MAC3723006 | 2023-07-06 | N | MAC3723006 | 2023-07-06 | 2023-07-06 | 774988.24 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-08-03 |  | 2023-08-03 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-06-30 | 2023-06-01 | 000102 | MAC 3.7b [NAME] for the month of June 2023 | LO | 774988.24 | 774988.24 | 0.0 | 1.0 | 1.0 |  |  | AB | 774988.24 |  | LT - LOT NUMBER | MACPhase37JUN2023 |  |  |  |  |  |  |  |  | 65303723 | 2023-08-25 | Paid
Proj A |  |  | 2023-07-24 | 136843650 | FA714623C0006 | DoD Contract (FAR) |  | MAC3723005 | 2023-07-24 | N | MAC3723005 | 2023-07-24 | 2023-07-24 | 774988.24 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-08-03 |  | 2023-08-03 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-06-18 | 2023-05-19 | 000102 | MAC Engineering support for May 2023 | LO | 774988.24 | 774988.24 | 0.0 | 1.0 | 1.0 |  |  | AC | 774988.24 |  | FT - FEDERAL SUPPLY CLASSIFICATION | R425 |  |  |  |  |  |  |  |  | 65303722 | 2023-08-25 | Paid
Proj A |  |  | 2023-09-01 | 137805888 | FA714623C0006 | DoD Contract (FAR) |  | MAC3723007 | 2023-07-31 | N | MAC3723007 | 2023-09-01 | 2023-09-01 | 774988.24 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-09-11 |  | 2023-09-11 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-07-31 | 2023-07-01 | 0001 | Funding for CLIN 0001 | LO | 774988.24 | 774988.24 | 0.0 | 1.0 | 1.0 |  |  | AB | 774988.24 |  | LT - LOT NUMBER | MACPhase37July2023 |  |  |  |  |  |  |  |  | 42005489 | 2023-09-21 | Paid
Proj A |  |  | 2023-10-03 | 138510192 | FA714623C0006 | DoD Contract (FAR) |  | MAC3723008V2 | 2023-08-31 | N | MAC3723008V2 | 2023-10-03 | 2023-10-03 | 869410.28 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-11-01 |  | 2023-11-01 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-08-31 | 2023-08-01 | 000103 | Funding for CLIN 0001 - Invoiced against CLIN 0103 | LO | 869410.28 | 869410.28 | 0.0 | 1.0 | 1.0 |  |  | AD | 869410.28 |  | LT - LOT NUMBER | MACPhase37August2023 |  |  |  |  |  |  |  |  | 47506329 | 2023-11-17 | Paid
Proj A |  |  | 2023-10-14 | 138716488 | FA714623C0006 | DoD Contract (FAR) |  | 01 | 2023-09-30 | N | MAC3723009 | 2023-10-14 | 2023-10-14 | 853594.67 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-10-18 |  | 2023-10-18 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-09-30 | 2023-09-01 | 000104 | Funding for CLIN 000104 | LO | 853594.67 | 853594.67 | 0.0 | 1.0 | 1.0 |  |  | AD | 853594.67 |  | LT - LOT NUMBER | MACPhase37SEP2023 |  |  |  |  |  |  |  |  | 66801566 | 2023-10-31 | Paid
Proj A |  |  | 2023-12-14 | 139945789 | FA714623C0006 | DoD Contract (FAR) |  | MAC3723010V2 | 2023-12-14 | N | MAC3723010V2 | 2023-12-14 | 2023-12-14 | 853594.67 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-12-20 |  | 2023-12-20 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-10-31 | 2023-10-01 | 000104 | Resubmitting for Oct Engineering Support due to error in CLIN Number (0104 instead of the the correct 000104). | LO | 853594.67 | 853594.67 | 0.0 | 1.0 | 1.0 |  |  | AD | 853594.67 |  | LT - LOT NUMBER | MACPhase37OCT2023 |  |  |  |  |  |  |  |  | 65210683 | 2024-01-02 | Paid
Proj A |  |  | 2023-12-18 | 140003210 | FA714623C0006 | DoD Contract (FAR) |  | 11 | 2023-12-18 | N | MAC3723011V2 | 2023-12-18 | 2023-12-18 | 853594.66 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2023-12-20 |  | 2023-12-20 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-11-30 | 2023-11-01 | 000104 | Funding for CLIN 0003 | LO | 853594.66 | 853594.66 | 0.0 | 1.0 | 1.0 |  |  | AD | 853594.66 |  | LT - LOT NUMBER | MACPhase37dNOV2023 |  |  |  |  |  |  |  |  | 65210684 | 2024-01-02 | Paid
Proj A |  |  | 2024-01-19 | 140602627 | FA714623C0006 | DoD Contract (FAR) |  | 10 | 2023-12-31 | N | MAC37230012V2 | 2024-01-19 | 2024-01-19 | 844826.31 | ACTIVE | CI2N1 |  | WEB | BOTH INVOICE AND RR | 2024-01-29 |  | 2024-01-29 |  | D | D |  |  |  |  | N | Y |  | 6RPX9 |  | AELIUS EXPLOITATION TECHNOLOGIES LLC | FA7146 | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  | FA7146 | [NAME] |  |  |  | FA7146  CONCEPTS DEVL MGT   SAF CDM | FA7146 |  |  |  |  | F87700 | ACCTG DISB STA NR 387700 | 2023-12-31 | 2023-12-01 | 000105 | Funding for CLIN 0003 - Engineering support for December for the MAC 3.7d Contract. | LO | 844826.31 | 844826.31 | 0.0 | 1.0 | 1.0 |  |  | AE | 844826.31 |  | LT - LOT NUMBER | MACPhase37dDEC2023 |  |  |  |  |  |  |  |  | 65213515 | 2024-02-07 | Paid