Spreadsheet: 830024d1684651577-extract-values-from-cell-and-convert-to-number-book1
Sheet: 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] | 523 | 0 | 23.44 | 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] | 523 | 0 | 24.52 | 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] | 523 | 0 | 80.39 | 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] | 523 | 0 | 111.37 | 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] | 523 | 0 | 277.37 | 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] | 523 | 0 | 398.5 | 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] | 523 | 0 | 472.88 | 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] | 523 | 0 | 558.84 | 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] | 523 | 0 | 1017.54 | 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] | 523 | 0 | 9996.45 | Trans Number | Clinical | [NAME]