Spreadsheet: 830024d1684651577-extract-values-from-cell-and-convert-to-number-book1
Sheet: Final Upload Entry Template

tranId | subsidiary | tranDate | Name | journalItemLine_memo | journalItemLine_accountRef | journalItemLine_debitAmount | journalItemLine_creditAmount | Memo | journalItemLine_departmentRef | journalItemLine_locationRef
051223JE Loan Upload001 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 630 | 23.44 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload001 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 640 | 24.4 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload001 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f4784Minus2440* TRN: [NAME] | 523 | 0 | 47.84 | Trans Number | Clinical | [NAME]
051223JE Loan Upload002 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 630 | 24.52 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload002 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 640 | 25.52 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload002 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf5004Min us2552* TRN: [NAME] | 523 | 0 | 50.04 | Trans Number | Clinical | [NAME]
051223JE Loan Upload003 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 630 | 80.39 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload003 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 640 | 83.67 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload003 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of16406Minus8367* TRN: [NAME] | 523 | 0 | 164.06 | Trans Number | Clinical | [NAME]
051223JE Loan Upload004 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 630 | 111.37 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload004 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 640 | 115.92 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload004 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f22729Minus11592* TRN: [NAME] | 523 | 0 | 227.29 | Trans Number | Clinical | [NAME]
051223JE Loan Upload005 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 630 | 277.37 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload005 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 640 | 288.69 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload005 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf56606Minus288 69* TRN: [NAME] | 523 | 0 | 566.06 | Trans Number | Clinical | [NAME]
051223JE Loan Upload006 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 630 | 398.5 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload006 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 640 | 414.77 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload006 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f81327Minus41477* TRN: [NAME] | 523 | 0 | 813.27 | Trans Number | Clinical | [NAME]
051223JE Loan Upload007 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 630 | 472.88 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload007 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 640 | 492.19 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload007 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX             IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf96507Minus49 219* TRN: [NAME] | 523 | 0 | 965.07 | Trans Number | Clinical | [NAME]
051223JE Loan Upload008 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 630 | 558.84 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload008 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 640 | 581.64 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload008 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetO f114048Minus58164* TRN: [NAME] | 523 | 0 | 1140.48 | Trans Number | Clinical | [NAME]
051223JE Loan Upload009 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 630 | 1017.54 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload009 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 640 | 1059.08 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload009 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*Net Of207662Minus105908* TRN: [NAME] | 523 | 0 | 2076.62 | Trans Number | Clinical | [NAME]
051223JE Loan Upload010 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 630 | 9996.45 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload010 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 640 | 10404.47 | 0 | Trans Number | Clinical | [NAME]
051223JE Loan Upload010 | Org Name | 2023-05-12 00:00:00 |  | Optum Loan-ORIG CO NAME:Org Name       ORIG ID:XXXXXXXXXXX DESC DATE:       CO ENTRY DESCR:NETSWEEP  SEC:CCD    TRACE#:XXXXXXXXXXX EED:230512   IND ID:XXXXXXXXXXX              IND NAME:Org NameCENSED     TRN*1*XXXXXXXXXXX*NetOf2040092Minus104 0447* TRN: [NAME] | 523 | 0 | 20400.92 | Trans Number | Clinical | [NAME]