Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Discussion Options
- Subscribe to RSS Feed
- Mark Discussion as New
- Mark Discussion as Read
- Pin this Discussion for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 10:35 AM
Sorry, but for some reason I'm not allowed to upload a screenshot to easily decipher this problem of mine...
The formula is not working in cell O4 (or O5). I realize it's probably due to the conditions all needing to relate to the first condition, but my brain is not working to figure this out.
If E[arned] PTO hours are present, then columns J/G formula; if U[sed] hours are present, then columns K/H formula; if neither of the prior two conditions, then columns L/I formula.
See Rate/Hr column O in red in rows 4 and 5. I have the following in row 4 for the cell:
=IF(J4/G4>0,J4/G4,IF(J4/G4=0,K4/H4,L4/I4))
Column names:
| A = ID | B = Employee | C = Hire Date | D = Code | E = Date | F = Type | G = Earned Hrs | H = Used Hrs | I = Balance Hrs | J = Earned $ | K = Used $ | L = Balance $ | M = border | N = Gained/(Lost) | O = Rate/Hr |
Data:
| ID | Employee | Hire Date | Code | Date | Type | Earned Hrs | Used Hrs | Balance Hrs | Earned $ | Used $ | Balance $ | Gained/(Lost) | Rate/Hr | |
| 139 | Smith, John | 08/25/1998 | PTOS | 09/15/2022 | E | 3.85 | - | 56.00 | $ 485.88 | $ - | $ 7,067.31 | $ 126.202 | ||
| 139 | Smith, John | 08/25/1998 | PTOS | 09/08/2022 | E | 3.85 | - | 52.15 | $ 485.88 | $ - | $ 6,581.43 | $ 126.202 | ||
| 139 | Smith, John | 08/25/1998 | PTOS | 09/08/2022 | C | - | - | 48.30 | $ - | $ - | $ 6,095.56 | $ - | #DIV/0! | |
| 139 | Smith, John | 08/25/1998 | PTOS | 09/08/2022 | U | - | (8.00) | 48.30 | $ - | $ (1,009.62) | $ 6,095.56 | #DIV/0! |
Thank you.
Labels:
- Labels:
-
Excel
-
Formulas and Functions
-
Office 365
11 Replies
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 11:42 AM
=IF(AND(G2<>0,J2<>""),J2/G2,IF(AND(H2<>0,K2<>""),K2/H2,IF(AND(I2<>0,L2<>""),L2/I2,"")))Does this formula return your expected result?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 12:15 PM
Ok, after further review, it's not correct for some rows. How do I copy/paste a screenshot of my Excel spreadsheet? The system won't allow me and that's the easiest way to present and make sense of it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 12:32 PM
After "Reply" -> "Open full text editor" you can select "Insert Photos" to choose the PDF.
Alternatively you can enter additional data and your expected results in the attached xlsx. file. Then you can save the file on your computer and in order to attach the xlsx. file you can select "Reply" -> "Open full text editor" and then select "browse" to select the file.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 12:40 PM
Yes, correct, but it opens a second screen entitled Insert/edit images and has fields for me to fill in (not the usual insert capability like yours has!?)...Source, Image description, Dimensions, and then a checkmark box for Constrain proportions. Odd. And I've also received another message stating I "do not have permissions to upload images."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 12:49 PM
Maybe we have different insert capability. Can you enter your data like in your first post along with the expected results?
If you insert the data like below it's easier to copy and paste the data into a worksheet. From a screenshot i'd have to manually type the data.
| ID | Employee | Hire Date | Code | Date | Type | Earned Hrs | Used Hrs | Balance Hrs | Earned $ | Used $ | Balance $ | Gained/(Lost) | Rate/Hr | expected result | |
| 139 | Smith, John | 08/25/1998 | PTOS | 09/15/2022 | E | 3,85 | 56 | 485,88 | 7067,31 | $ 126.202 | 126,2025974 | ||||
| 139 | Smith, John | 08/25/1998 | PTOS | 09.08.2022 | E | 3,85 | 52,15 | 485,88 | 6581,43 | $ 126.202 | 126,2025974 | ||||
| 139 | Smith, John | 08/25/1998 | PTOS | 09.08.2022 | C | 48,3 | 6095,56 | #DIV/0! | 126,2020704 | ||||||
| 139 | Smith, John | 08/25/1998 | PTOS | 09.08.2022 | U | -8 | 48,3 | -1009,6 | 6095,56 | #DIV/0! | 126,2025 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 12:59 PM
OK, see the very last column showing "Diff" for any differences between your formula and my separate column formulas ("C," "U," and "C/M/Bal")...
- Rows 111 and 112 are off $6.010
- Rows 214 and 215 are off $28.846
- Rows 284 and 285 are off $10.577
- Row 306 is off $14.628 and row 308 is off <$14.628>
- Rows 330 and 331are off $3.846
| ID | Employee | Hire Date | Code | Date | Type | Earned Hrs | Used Hrs | Balance Hrs | Earned $ | Used $ | Balance $ | Gained/(Lost) | Rate/Hr | E | U | C/M/Bal | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/15/2022 | E | 3.85 | - | 56.00 | $ 485.88 | $ - | $ 7,067.31 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/08/2022 | E | 3.85 | - | 52.15 | $ 485.88 | $ - | $ 6,581.43 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/08/2022 | C | - | - | 48.30 | $ - | $ - | $ 6,095.56 | $ - | $ 126.202 | $ - | $ - | $ 126.202 | $ - | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/08/2022 | U | - | (8.00) | 48.30 | $ - | $ (1,009.62) | $ 6,095.56 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/01/2022 | E | 3.85 | - | 56.30 | $ 485.88 | $ - | $ 7,105.17 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/25/2022 | E | 3.85 | - | 52.45 | $ 485.88 | $ - | $ 6,619.29 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/25/2022 | U | - | (4.00) | 48.60 | $ - | $ (504.81) | $ 6,133.42 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/18/2022 | E | 3.69 | - | 52.60 | $ 465.69 | $ - | $ 6,638.23 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/11/2022 | E | 3.69 | - | 48.91 | $ 465.69 | $ - | $ 6,172.54 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/11/2022 | U | - | (40.00) | 45.22 | $ - | $ (5,048.08) | $ 5,706.85 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/04/2022 | E | 3.69 | - | 85.22 | $ 465.69 | $ - | $ 10,754.93 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/28/2022 | E | 3.69 | - | 81.53 | $ 465.69 | $ - | $ 10,289.25 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/21/2022 | E | 3.69 | - | 77.84 | $ 465.69 | $ - | $ 9,823.56 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/14/2022 | E | 3.69 | - | 74.15 | $ 465.69 | $ - | $ 9,357.88 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/14/2022 | U | - | (8.00) | 70.46 | $ - | $ (1,009.62) | $ 8,892.19 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/07/2022 | E | 3.69 | - | 78.46 | $ 465.69 | $ - | $ 9,901.81 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/07/2022 | U | - | (16.00) | 74.77 | $ - | $ (2,019.23) | $ 9,436.12 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/30/2022 | E | 3.69 | - | 90.77 | $ 465.69 | $ - | $ 11,455.36 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/23/2022 | E | 3.69 | - | 87.08 | $ 465.69 | $ - | $ 10,989.67 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/23/2022 | U | - | (8.00) | 83.39 | $ - | $ (1,009.62) | $ 10,523.98 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/16/2022 | E | 3.69 | - | 91.39 | $ 465.69 | $ - | $ 11,533.60 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/09/2022 | E | 3.69 | - | 87.70 | $ 465.69 | $ - | $ 11,067.92 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/09/2022 | U | - | (8.00) | 84.01 | $ - | $ (1,009.62) | $ 10,602.23 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/02/2022 | E | 3.69 | - | 92.01 | $ 465.69 | $ - | $ 11,611.85 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/02/2022 | U | - | (40.00) | 88.32 | $ - | $ (5,048.08) | $ 11,146.16 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/26/2022 | E | 3.69 | - | 128.32 | $ 465.69 | $ - | $ 16,194.24 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/26/2022 | U | - | (8.00) | 124.63 | $ - | $ (1,009.62) | $ 15,728.56 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/19/2022 | E | 3.69 | - | 132.63 | $ 465.69 | $ - | $ 16,738.17 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/12/2022 | E | 3.69 | - | 128.94 | $ 465.69 | $ - | $ 16,272.49 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/05/2022 | E | 3.69 | - | 125.25 | $ 465.69 | $ - | $ 15,806.80 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/28/2022 | E | 3.69 | - | 121.56 | $ 465.69 | $ - | $ 15,341.12 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/21/2022 | E | 3.69 | - | 117.87 | $ 465.69 | $ - | $ 14,875.43 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/21/2022 | U | - | (4.00) | 114.18 | $ - | $ (504.81) | $ 14,409.74 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/14/2022 | E | 3.69 | - | 118.18 | $ 465.69 | $ - | $ 14,914.55 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/07/2022 | E | 3.69 | - | 114.49 | $ 465.69 | $ - | $ 14,448.87 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/07/2022 | U | - | (12.00) | 110.80 | $ - | $ (1,514.42) | $ 13,983.18 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/31/2022 | E | 3.69 | - | 122.80 | $ 465.69 | $ - | $ 15,497.61 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/24/2022 | E | 3.69 | - | 119.11 | $ 465.69 | $ - | $ 15,031.92 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/17/2022 | E | 3.69 | - | 115.42 | $ 465.69 | $ - | $ 14,566.23 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/17/2022 | U | - | 8.00 | 111.73 | $ - | $ 1,009.62 | $ 14,100.55 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/10/2022 | E | 3.69 | - | 103.73 | $ 465.69 | $ - | $ 13,090.93 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/10/2022 | U | - | (8.00) | 100.04 | $ - | $ (1,009.62) | $ 12,625.25 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/03/2022 | E | 3.69 | - | 108.04 | $ 465.69 | $ - | $ 13,634.86 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/03/2022 | U | - | (8.00) | 104.35 | $ - | $ (1,009.62) | $ 13,169.18 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/24/2022 | E | 3.69 | - | 112.35 | $ 465.69 | $ - | $ 14,178.79 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/24/2022 | U | - | (24.00) | 108.66 | $ - | $ (3,028.85) | $ 13,713.11 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/17/2022 | E | 3.69 | - | 132.66 | $ 465.69 | $ - | $ 16,741.96 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/17/2022 | U | - | (16.00) | 128.97 | $ - | $ (2,019.23) | $ 16,276.27 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/10/2022 | E | 3.69 | - | 144.97 | $ 465.69 | $ - | $ 18,295.50 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/03/2022 | E | 3.69 | - | 141.28 | $ 465.69 | $ - | $ 17,829.82 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/27/2022 | E | 3.69 | - | 137.59 | $ 465.69 | $ - | $ 17,364.13 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/20/2022 | E | 3.69 | - | 133.90 | $ 465.69 | $ - | $ 16,898.45 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/13/2022 | E | 3.69 | - | 130.21 | $ 465.69 | $ - | $ 16,432.76 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/06/2022 | E | 3.69 | - | 126.52 | $ 465.69 | $ - | $ 15,967.08 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/06/2022 | U | - | (8.00) | 122.83 | $ - | $ (1,009.62) | $ 15,501.39 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/30/2021 | E | 3.69 | - | 130.83 | $ 465.69 | $ - | $ 16,511.01 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/30/2021 | U | - | (16.00) | 127.14 | $ - | $ (2,019.23) | $ 16,045.32 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/23/2021 | E | 3.69 | - | 143.14 | $ 465.69 | $ - | $ 18,064.55 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/23/2021 | U | - | (4.00) | 139.45 | $ - | $ (504.81) | $ 17,598.87 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/16/2021 | E | 3.69 | - | 143.45 | $ 465.69 | $ - | $ 18,103.68 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/09/2021 | E | 3.69 | - | 139.76 | $ 465.69 | $ - | $ 17,637.99 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/02/2021 | E | 3.69 | - | 136.07 | $ 465.69 | $ - | $ 17,172.31 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/24/2021 | E | 3.69 | - | 132.38 | $ 465.69 | $ - | $ 16,706.62 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/18/2021 | E | 3.69 | - | 128.69 | $ 465.69 | $ - | $ 16,240.94 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/10/2021 | E | 3.69 | - | 125.00 | $ 465.69 | $ - | $ 15,775.25 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/10/2021 | U | - | (16.00) | 121.31 | $ - | $ (2,019.23) | $ 15,309.56 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/04/2021 | E | 3.69 | - | 137.31 | $ 465.69 | $ - | $ 17,328.80 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/04/2021 | U | - | (8.00) | 133.62 | $ - | $ (1,009.62) | $ 16,863.11 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/28/2021 | E | 3.69 | - | 141.62 | $ 465.69 | $ - | $ 17,872.73 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/28/2021 | U | - | (12.00) | 137.93 | $ - | $ (1,514.42) | $ 17,407.04 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/21/2021 | E | 3.69 | - | 149.93 | $ 465.69 | $ - | $ 18,921.47 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/14/2021 | E | 3.69 | - | 146.24 | $ 465.69 | $ - | $ 18,455.78 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/07/2021 | E | 3.69 | - | 142.55 | $ 465.69 | $ - | $ 17,990.10 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/07/2021 | U | - | (40.00) | 138.86 | $ - | $ (5,048.08) | $ 17,524.41 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/30/2021 | E | 3.69 | - | 178.86 | $ 465.69 | $ - | $ 22,572.49 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/23/2021 | E | 3.69 | - | 175.17 | $ 465.69 | $ - | $ 22,106.80 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/16/2021 | E | 3.69 | - | 171.48 | $ 465.69 | $ - | $ 21,641.12 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/09/2021 | E | 3.69 | - | 167.79 | $ 465.69 | $ - | $ 21,175.43 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/09/2021 | C | - | - | 164.10 | $ - | $ - | $ 20,709.75 | $ - | $ 126.202 | $ - | $ - | $ 126.202 | $ - | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/09/2021 | U | - | (8.00) | 164.10 | $ - | $ (1,009.62) | $ 20,709.75 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/02/2021 | E | 3.69 | - | 172.10 | $ 465.69 | $ - | $ 21,719.36 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/26/2021 | E | 3.69 | - | 168.41 | $ 465.69 | $ - | $ 21,253.68 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/26/2021 | U | - | (16.00) | 164.72 | $ - | $ (2,019.23) | $ 20,787.99 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/19/2021 | E | 3.69 | - | 180.72 | $ 465.69 | $ - | $ 22,807.23 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/12/2021 | E | 3.69 | - | 177.03 | $ 465.69 | $ - | $ 22,341.54 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/05/2021 | E | 3.69 | - | 173.34 | $ 465.69 | $ - | $ 21,875.85 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/05/2021 | U | - | (8.00) | 169.65 | $ - | $ (1,009.62) | $ 21,410.17 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/29/2021 | E | 3.69 | - | 177.65 | $ 465.69 | $ - | $ 22,419.79 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/29/2021 | U | - | (16.00) | 173.96 | $ - | $ (2,019.23) | $ 21,954.10 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/22/2021 | E | 3.69 | - | 189.96 | $ 465.69 | $ - | $ 23,973.33 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/15/2021 | E | 3.69 | - | 186.27 | $ 465.69 | $ - | $ 23,507.65 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/15/2021 | U | - | (4.00) | 182.58 | $ - | $ (504.81) | $ 23,041.96 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/08/2021 | E | 3.69 | - | 186.58 | $ 465.69 | $ - | $ 23,546.77 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/08/2021 | U | - | (8.00) | 182.89 | $ - | $ (1,009.62) | $ 23,081.08 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/01/2021 | E | 3.69 | - | 190.89 | $ 465.69 | $ - | $ 24,090.70 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/24/2021 | E | 3.69 | - | 187.20 | $ 465.69 | $ - | $ 23,625.01 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/17/2021 | E | 3.69 | - | 183.51 | $ 465.69 | $ - | $ 23,159.33 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/10/2021 | E | 3.69 | - | 179.82 | $ 465.69 | $ - | $ 22,693.64 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/10/2021 | U | - | (24.00) | 176.13 | $ - | $ (3,028.85) | $ 22,227.96 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/03/2021 | E | 3.69 | - | 200.13 | $ 465.69 | $ - | $ 25,256.81 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/03/2021 | U | - | (8.00) | 196.44 | $ - | $ (1,009.62) | $ 24,791.12 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/27/2021 | E | 3.69 | - | 204.44 | $ 465.69 | $ - | $ 25,800.74 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/20/2021 | E | 3.69 | - | 200.75 | $ 465.69 | $ - | $ 25,335.05 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/20/2021 | U | - | (12.00) | 197.06 | $ - | $ (1,514.42) | $ 24,869.37 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/13/2021 | E | 3.69 | - | 209.06 | $ 465.69 | $ - | $ 26,383.79 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/13/2021 | U | - | (8.00) | 205.37 | $ - | $ (1,009.62) | $ 25,918.10 | $ 126.202 | $ - | $ 126.202 | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/06/2021 | E | 3.69 | - | 213.37 | $ 465.69 | $ - | $ 26,927.72 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/29/2021 | E | 3.69 | - | 209.68 | $ 465.69 | $ - | $ 26,462.04 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/22/2021 | E | 3.69 | - | 205.99 | $ 465.69 | $ - | $ 25,996.35 | $ 126.202 | $ 126.202 | $ - | $ 126.202 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/15/2021 | E | 3.69 | - | 202.30 | $ 443.51 | $ - | $ 24,314.94 | $ 126.202 | $ 120.193 | $ - | $ 120.193 | $ 6.010 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/15/2021 | U | - | (8.00) | 198.61 | $ - | $ (961.54) | $ 23,871.43 | $ 126.202 | $ - | $ 120.193 | $ 120.193 | $ 6.010 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/08/2021 | E | 3.69 | - | 206.61 | $ 443.51 | $ - | $ 24,832.97 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/08/2021 | U | - | (16.00) | 202.92 | $ - | $ (1,923.08) | $ 24,389.46 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/01/2021 | E | 3.69 | - | 218.92 | $ 443.51 | $ - | $ 26,312.54 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/01/2021 | U | - | (4.00) | 215.23 | $ - | $ (480.77) | $ 25,869.03 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/25/2021 | E | 3.69 | - | 219.23 | $ 443.51 | $ - | $ 26,349.80 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/25/2021 | U | - | (8.00) | 215.54 | $ - | $ (961.54) | $ 25,906.29 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/18/2021 | E | 3.69 | - | 223.54 | $ 443.51 | $ - | $ 26,867.83 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/18/2021 | U | - | (4.00) | 219.85 | $ - | $ (480.77) | $ 26,424.32 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/11/2021 | E | 3.69 | - | 223.85 | $ 443.51 | $ - | $ 26,905.09 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/04/2021 | E | 3.69 | - | 220.16 | $ 443.51 | $ - | $ 26,461.58 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/25/2021 | E | 3.69 | - | 216.47 | $ 443.51 | $ - | $ 26,018.07 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/25/2021 | U | - | (4.00) | 212.78 | $ - | $ (480.77) | $ 25,574.56 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/18/2021 | E | 3.69 | - | 216.78 | $ 443.51 | $ - | $ 26,055.33 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/11/2021 | E | 3.69 | - | 213.09 | $ 443.51 | $ - | $ 25,611.82 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/04/2021 | E | 3.69 | - | 209.40 | $ 443.51 | $ - | $ 25,168.31 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/04/2021 | U | - | (4.00) | 205.71 | $ - | $ (480.77) | $ 24,724.80 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/28/2021 | E | 3.69 | - | 209.71 | $ 443.51 | $ - | $ 25,205.57 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/21/2021 | E | 3.69 | - | 206.02 | $ 443.51 | $ - | $ 24,762.06 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/14/2021 | E | 3.69 | - | 202.33 | $ 443.51 | $ - | $ 24,318.55 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/07/2021 | E | 3.69 | - | 198.64 | $ 443.51 | $ - | $ 23,875.04 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/31/2020 | E | 3.69 | - | 194.95 | $ 443.51 | $ - | $ 23,431.53 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/31/2020 | U | - | (16.00) | 191.26 | $ - | $ (1,923.08) | $ 22,988.02 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/24/2020 | E | 3.69 | - | 207.26 | $ 443.51 | $ - | $ 24,911.10 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/17/2020 | E | 3.69 | - | 203.57 | $ 443.51 | $ - | $ 24,467.59 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/17/2020 | U | - | (4.00) | 199.88 | $ - | $ (480.77) | $ 24,024.08 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/10/2020 | E | 3.69 | - | 203.88 | $ 443.51 | $ - | $ 24,504.85 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/03/2020 | E | 3.69 | - | 200.19 | $ 443.51 | $ - | $ 24,061.34 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/25/2020 | E | 3.69 | - | 196.50 | $ 443.51 | $ - | $ 23,617.83 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/25/2020 | U | - | (4.00) | 192.81 | $ - | $ (480.77) | $ 23,174.32 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/19/2020 | E | 3.69 | - | 196.81 | $ 443.51 | $ - | $ 23,655.09 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/19/2020 | U | - | (8.00) | 193.12 | $ - | $ (961.54) | $ 23,211.58 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/12/2020 | E | 3.69 | - | 201.12 | $ 443.51 | $ - | $ 24,173.12 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/05/2020 | E | 3.69 | - | 197.43 | $ 443.51 | $ - | $ 23,729.61 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/29/2020 | E | 3.69 | - | 193.74 | $ 443.51 | $ - | $ 23,286.09 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/22/2020 | E | 3.69 | - | 190.05 | $ 443.51 | $ - | $ 22,842.58 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/22/2020 | U | - | (12.00) | 186.36 | $ - | $ (1,442.31) | $ 22,399.07 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/15/2020 | E | 3.69 | - | 198.36 | $ 443.51 | $ - | $ 23,841.38 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/08/2020 | E | 3.69 | - | 194.67 | $ 443.51 | $ - | $ 23,397.87 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/01/2020 | E | 3.69 | - | 190.98 | $ 443.51 | $ - | $ 22,954.36 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/01/2020 | U | - | (4.00) | 187.29 | $ - | $ (480.77) | $ 22,510.85 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/24/2020 | E | 3.69 | - | 191.29 | $ 443.51 | $ - | $ 22,991.62 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/24/2020 | U | - | (8.00) | 187.60 | $ - | $ (961.54) | $ 22,548.11 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/17/2020 | E | 3.69 | - | 195.60 | $ 443.51 | $ - | $ 23,509.65 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/10/2020 | E | 3.69 | - | 191.91 | $ 443.51 | $ - | $ 23,066.14 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/10/2020 | C | - | - | 188.22 | $ - | $ - | $ 22,622.63 | $ - | $ 120.193 | $ - | $ - | $ 120.193 | $ - | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/10/2020 | U | - | (4.00) | 188.22 | $ - | $ (480.77) | $ 22,622.63 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/03/2020 | E | 3.69 | - | 192.22 | $ 443.51 | $ - | $ 23,103.40 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/03/2020 | U | - | (16.00) | 188.53 | $ - | $ (1,923.08) | $ 22,659.89 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/27/2020 | E | 3.69 | - | 204.53 | $ 443.51 | $ - | $ 24,582.97 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/20/2020 | E | 3.69 | - | 200.84 | $ 443.51 | $ - | $ 24,139.46 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/13/2020 | E | 3.69 | - | 197.15 | $ 443.51 | $ - | $ 23,695.95 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/13/2020 | U | - | (20.00) | 193.46 | $ - | $ (2,403.85) | $ 23,252.44 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/06/2020 | E | 3.69 | - | 213.46 | $ 443.51 | $ - | $ 25,656.29 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/30/2020 | E | 3.69 | - | 209.77 | $ 443.51 | $ - | $ 25,212.78 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/23/2020 | E | 3.69 | - | 206.08 | $ 443.51 | $ - | $ 24,769.27 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/16/2020 | E | 3.69 | - | 202.39 | $ 443.51 | $ - | $ 24,325.76 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/16/2020 | U | - | (8.00) | 198.70 | $ - | $ (961.54) | $ 23,882.25 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/09/2020 | E | 3.69 | - | 206.70 | $ 443.51 | $ - | $ 24,843.79 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/09/2020 | U | - | (4.00) | 203.01 | $ - | $ (480.77) | $ 24,400.28 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/02/2020 | E | 3.69 | - | 207.01 | $ 443.51 | $ - | $ 24,881.05 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/25/2020 | E | 3.69 | - | 203.32 | $ 443.51 | $ - | $ 24,437.54 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/18/2020 | E | 3.69 | - | 199.63 | $ 443.51 | $ - | $ 23,994.03 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/18/2020 | U | - | (4.00) | 195.94 | $ - | $ (480.77) | $ 23,550.52 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/11/2020 | E | 3.69 | - | 199.94 | $ 443.51 | $ - | $ 24,031.29 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/11/2020 | E | - | - | 199.94 | $ - | $ - | $ 24,031.29 | $ 120.193 | $ - | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/04/2020 | E | 3.69 | - | 196.25 | $ 443.51 | $ - | $ 23,587.78 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/04/2020 | U | - | (4.00) | 192.56 | $ - | $ (480.77) | $ 23,144.27 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/28/2020 | E | 3.69 | - | 196.56 | $ 443.51 | $ - | $ 23,625.04 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/28/2020 | U | - | (12.00) | 192.87 | $ - | $ (1,442.31) | $ 23,181.53 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/21/2020 | E | 3.69 | - | 204.87 | $ 443.51 | $ - | $ 24,623.84 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/14/2020 | E | 3.69 | - | 201.18 | $ 443.51 | $ - | $ 24,180.33 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/14/2020 | U | - | (4.00) | 197.49 | $ - | $ (480.77) | $ 23,736.82 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/07/2020 | E | 3.69 | - | 201.49 | $ 443.51 | $ - | $ 24,217.59 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/07/2020 | U | - | (4.00) | 197.80 | $ - | $ (480.77) | $ 23,774.08 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/30/2020 | E | 3.69 | - | 201.80 | $ 443.51 | $ - | $ 24,254.85 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/23/2020 | E | 3.69 | - | 198.11 | $ 443.51 | $ - | $ 23,811.34 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/16/2020 | E | 3.69 | - | 194.42 | $ 443.51 | $ - | $ 23,367.83 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/16/2020 | U | - | (4.00) | 190.73 | $ - | $ (480.77) | $ 22,924.32 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/09/2020 | E | 3.69 | - | 194.73 | $ 443.51 | $ - | $ 23,405.09 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/02/2020 | E | 3.69 | - | 191.04 | $ 443.51 | $ - | $ 22,961.58 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/02/2020 | U | - | (4.00) | 187.35 | $ - | $ (480.77) | $ 22,518.06 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/26/2020 | E | 3.69 | - | 191.35 | $ 443.51 | $ - | $ 22,998.83 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/19/2020 | E | 3.69 | - | 187.66 | $ 443.51 | $ - | $ 22,555.32 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/12/2020 | E | 3.69 | - | 183.97 | $ 443.51 | $ - | $ 22,111.81 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/05/2020 | E | 3.69 | - | 180.28 | $ 443.51 | $ - | $ 21,668.30 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/05/2020 | U | - | (40.00) | 176.59 | $ - | $ (4,807.70) | $ 21,224.79 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/05/2020 | U | - | - | 183.97 | $ - | $ - | $ 22,111.81 | $ 120.193 | $ - | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/27/2020 | E | 3.69 | - | 216.59 | $ 443.51 | $ - | $ 26,032.49 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/27/2020 | U | - | (16.00) | 212.90 | $ - | $ (1,923.08) | $ 25,588.98 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/27/2020 | U | - | - | 180.28 | $ - | $ - | $ 21,668.30 | $ 120.193 | $ - | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/20/2020 | E | 3.69 | - | 228.90 | $ 443.51 | $ - | $ 27,512.06 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/13/2020 | E | 3.69 | - | 225.21 | $ 443.51 | $ - | $ 27,068.55 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/06/2020 | E | 3.69 | - | 221.52 | $ 443.51 | $ - | $ 26,625.04 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/30/2020 | E | 3.69 | - | 217.83 | $ 443.51 | $ - | $ 26,181.53 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/23/2020 | E | 3.69 | - | 214.14 | $ 443.51 | $ - | $ 25,738.02 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/16/2020 | E | 3.69 | - | 210.45 | $ 443.51 | $ - | $ 25,294.51 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/09/2020 | E | 3.69 | - | 206.76 | $ 443.51 | $ - | $ 24,851.00 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/09/2020 | U | - | (8.00) | 203.07 | $ - | $ (961.54) | $ 24,407.49 | $ 120.193 | $ - | $ 120.193 | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/09/2020 | M | - | - | 211.07 | $ - | $ - | $ 25,369.02 | $ 329.32 | $ 120.193 | $ - | $ - | $ 120.192 | $ 0.000 | |
| 139 | John Smith | 08/25/1998 | PTOS | 01/02/2020 | E | 3.69 | - | 208.33 | $ 443.51 | $ - | $ 25,039.70 | $ 120.193 | $ 120.193 | $ - | $ 120.193 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/02/2020 | U | - | (24.00) | 204.64 | $ - | $ (2,884.62) | $ 24,596.19 | $ 120.192 | $ - | $ 120.193 | $ 120.193 | $ (0.000) | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/26/2019 | E | 3.54 | - | 228.64 | $ 323.37 | $ - | $ 20,885.40 | $ 120.193 | $ 91.346 | $ - | $ 91.346 | $ 28.846 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/26/2019 | U | - | (8.00) | 225.10 | $ - | $ (730.77) | $ 20,562.03 | $ 120.193 | $ - | $ 91.346 | $ 91.346 | $ 28.846 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/19/2019 | E | 3.54 | - | 233.10 | $ 323.37 | $ - | $ 21,292.80 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/12/2019 | E | 3.54 | - | 229.56 | $ 323.37 | $ - | $ 20,969.43 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/05/2019 | E | 3.54 | - | 226.02 | $ 323.37 | $ - | $ 20,646.07 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/27/2019 | E | 3.54 | - | 222.48 | $ 323.37 | $ - | $ 20,322.70 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/21/2019 | E | 3.54 | - | 218.94 | $ 323.37 | $ - | $ 19,999.34 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/14/2019 | E | 3.54 | - | 215.40 | $ 323.37 | $ - | $ 19,675.97 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/07/2019 | E | 3.54 | - | 211.86 | $ 323.37 | $ - | $ 19,352.61 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/31/2019 | E | 3.54 | - | 208.32 | $ 323.37 | $ - | $ 19,029.24 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/31/2019 | U | - | (4.00) | 204.78 | $ - | $ (365.38) | $ 18,705.87 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/24/2019 | E | 3.54 | - | 208.78 | $ 323.37 | $ - | $ 19,071.26 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/17/2019 | E | 3.54 | - | 205.24 | $ 323.37 | $ - | $ 18,747.89 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/10/2019 | E | 3.54 | - | 201.70 | $ 323.37 | $ - | $ 18,424.53 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/10/2019 | M | - | - | 198.16 | $ - | $ - | $ 18,101.16 | $ 3,653.85 | $ 91.346 | $ - | $ - | $ 91.346 | $ 0.000 | |
| 139 | John Smith | 08/25/1998 | PTOS | 10/03/2019 | E | 3.54 | - | 158.16 | $ 323.37 | $ - | $ 14,447.31 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/03/2019 | U | - | (40.00) | 154.62 | $ - | $ (3,653.85) | $ 14,123.95 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ (0.000) | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/03/2019 | M | - | - | 194.62 | $ - | $ - | $ 17,777.80 | $ 730.77 | $ 91.346 | $ - | $ - | $ 91.346 | $ (0.000) | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/26/2019 | E | 3.54 | - | 186.62 | $ 323.37 | $ - | $ 17,047.03 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/26/2019 | U | - | (8.00) | 183.08 | $ - | $ (730.77) | $ 16,723.66 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ 0.000 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/19/2019 | E | 3.54 | - | 191.08 | $ 323.37 | $ - | $ 17,454.43 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/12/2019 | E | 3.54 | - | 187.54 | $ 323.37 | $ - | $ 17,131.07 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/12/2019 | C | - | - | 184.00 | $ - | $ - | $ 16,807.70 | $ (4,718.03) | $ 91.346 | $ - | $ - | $ 91.346 | $ - | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/05/2019 | E | 3.54 | - | 235.65 | $ 323.37 | $ - | $ 21,525.73 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/29/2019 | E | 3.54 | - | 232.11 | $ 323.37 | $ - | $ 21,202.37 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/22/2019 | E | 3.54 | - | 228.57 | $ 323.37 | $ - | $ 20,879.00 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/15/2019 | E | 3.54 | - | 225.03 | $ 323.37 | $ - | $ 20,555.64 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/15/2019 | U | - | (8.00) | 221.49 | $ - | $ (730.77) | $ 20,232.27 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/08/2019 | E | 3.54 | - | 229.49 | $ 323.37 | $ - | $ 20,963.04 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/01/2019 | E | 3.54 | - | 225.95 | $ 323.37 | $ - | $ 20,639.67 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/25/2019 | E | 3.54 | - | 222.41 | $ 323.37 | $ - | $ 20,316.31 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/18/2019 | E | 3.54 | - | 218.87 | $ 323.37 | $ - | $ 19,992.94 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/11/2019 | E | 3.54 | - | 215.33 | $ 323.37 | $ - | $ 19,669.58 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/11/2019 | U | - | (12.00) | 211.79 | $ - | $ (1,096.15) | $ 19,346.21 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/03/2019 | E | 3.54 | - | 223.79 | $ 323.37 | $ - | $ 20,442.37 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/27/2019 | E | 3.54 | - | 220.25 | $ 323.37 | $ - | $ 20,119.00 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/20/2019 | E | 3.54 | - | 216.71 | $ 323.37 | $ - | $ 19,795.64 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/20/2019 | U | - | (4.00) | 213.17 | $ - | $ (365.38) | $ 19,472.27 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/13/2019 | E | 3.54 | - | 217.17 | $ 323.37 | $ - | $ 19,837.65 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/13/2019 | U | - | (8.00) | 213.63 | $ - | $ (730.77) | $ 19,514.29 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/06/2019 | E | 3.54 | - | 221.63 | $ 323.37 | $ - | $ 20,245.06 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/06/2019 | U | - | (8.00) | 218.09 | $ - | $ (730.77) | $ 19,921.69 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/30/2019 | E | 3.54 | - | 226.09 | $ 323.37 | $ - | $ 20,652.46 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/30/2019 | U | - | (16.00) | 222.55 | $ - | $ (1,461.54) | $ 20,329.10 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/23/2019 | E | 3.54 | - | 238.55 | $ 323.37 | $ - | $ 21,790.64 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/16/2019 | E | 3.54 | - | 235.01 | $ 323.37 | $ - | $ 21,467.27 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/09/2019 | E | 3.54 | - | 231.47 | $ 323.37 | $ - | $ 21,143.90 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/02/2019 | E | 3.54 | - | 227.93 | $ 323.37 | $ - | $ 20,820.54 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/02/2019 | U | - | (8.00) | 224.39 | $ - | $ (730.77) | $ 20,497.17 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/25/2019 | E | 3.54 | - | 232.39 | $ 323.37 | $ - | $ 21,227.94 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/25/2019 | U | - | (8.00) | 228.85 | $ - | $ (730.77) | $ 20,904.58 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/18/2019 | E | 3.54 | - | 236.85 | $ 323.37 | $ - | $ 21,635.35 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/18/2019 | U | - | (4.00) | 233.31 | $ - | $ (365.38) | $ 21,311.98 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/11/2019 | E | 3.54 | - | 237.31 | $ 323.37 | $ - | $ 21,677.37 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/04/2019 | E | 3.54 | - | 233.77 | $ 323.37 | $ - | $ 21,354.00 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/04/2019 | U | - | (4.00) | 230.23 | $ - | $ (365.38) | $ 21,030.64 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/28/2019 | E | 3.54 | - | 234.23 | $ 323.37 | $ - | $ 21,396.02 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/21/2019 | E | 3.54 | - | 230.69 | $ 323.37 | $ - | $ 21,072.65 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/21/2019 | U | - | (4.00) | 227.15 | $ - | $ (365.38) | $ 20,749.29 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/14/2019 | E | 3.54 | - | 231.15 | $ 323.37 | $ - | $ 21,114.67 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/07/2019 | E | 3.54 | - | 227.61 | $ 323.37 | $ - | $ 20,791.31 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/28/2019 | E | 3.54 | - | 224.07 | $ 323.37 | $ - | $ 20,467.94 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/21/2019 | E | 3.54 | - | 220.53 | $ 323.37 | $ - | $ 20,144.58 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/14/2019 | E | 3.54 | - | 216.99 | $ 323.37 | $ - | $ 19,821.21 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 02/07/2019 | E | 3.54 | - | 213.45 | $ 323.37 | $ - | $ 19,497.85 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/31/2019 | E | 3.54 | - | 209.91 | $ 323.37 | $ - | $ 19,174.48 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/24/2019 | E | 3.54 | - | 206.37 | $ 323.37 | $ - | $ 18,851.12 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/17/2019 | E | 3.54 | - | 202.83 | $ 323.37 | $ - | $ 18,527.75 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/10/2019 | E | 3.54 | - | 199.29 | $ 323.37 | $ - | $ 18,204.38 | $ 91.346 | $ 91.346 | $ - | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/10/2019 | U | - | (8.00) | 195.75 | $ - | $ (730.77) | $ 17,881.02 | $ 91.346 | $ - | $ 91.346 | $ 91.346 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/03/2019 | E | 3.54 | - | 203.75 | $ 285.92 | $ - | $ 16,456.79 | $ 91.346 | $ 80.770 | $ - | $ 80.770 | $ 10.577 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 01/03/2019 | U | - | (24.00) | 200.21 | $ - | $ (1,938.47) | $ 16,170.86 | $ 91.346 | $ - | $ 80.770 | $ 80.770 | $ 10.577 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/27/2018 | E | 3.54 | - | 224.21 | $ 285.92 | $ - | $ 18,109.33 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/20/2018 | E | 3.54 | - | 220.67 | $ 285.92 | $ - | $ 17,823.41 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/13/2018 | E | 3.54 | - | 217.13 | $ 285.92 | $ - | $ 17,537.48 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 12/06/2018 | E | 3.54 | - | 213.59 | $ 285.92 | $ - | $ 17,251.56 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/29/2018 | E | 3.54 | - | 210.05 | $ 285.92 | $ - | $ 16,965.63 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/21/2018 | E | 3.54 | - | 206.51 | $ 285.92 | $ - | $ 16,679.71 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/21/2018 | U | - | (4.00) | 202.97 | $ - | $ (323.08) | $ 16,393.79 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/15/2018 | E | 3.54 | - | 206.97 | $ 285.92 | $ - | $ 16,716.86 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/15/2018 | U | - | (4.00) | 203.43 | $ - | $ (323.08) | $ 16,430.94 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/08/2018 | E | 3.54 | - | 207.43 | $ 285.92 | $ - | $ 16,754.02 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 11/01/2018 | E | 3.54 | - | 203.89 | $ 285.92 | $ - | $ 16,468.09 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/25/2018 | E | 3.54 | - | 200.35 | $ 285.92 | $ - | $ 16,182.17 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/18/2018 | E | 3.54 | - | 196.81 | $ 285.92 | $ - | $ 15,896.25 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/11/2018 | E | 3.54 | - | 193.27 | $ 285.92 | $ - | $ 15,610.32 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 10/04/2018 | E | 3.54 | - | 189.73 | $ 285.92 | $ - | $ 15,324.40 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/27/2018 | E | 3.54 | - | 186.19 | $ 285.92 | $ - | $ 15,038.47 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/27/2018 | U | - | (40.00) | 182.65 | $ - | $ (3,230.78) | $ 14,752.55 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/20/2018 | E | 3.54 | - | 222.65 | $ 285.92 | $ - | $ 17,983.33 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/20/2018 | U | - | (8.00) | 219.11 | $ - | $ (646.16) | $ 17,697.41 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/13/2018 | E | 3.54 | - | 227.11 | $ 285.92 | $ - | $ 18,343.56 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/13/2018 | M | - | - | 223.57 | $ - | $ - | $ 14,787.28 | $ (0.00) | $ 80.770 | $ - | $ - | $ 66.142 | $ 14.628 | |
| 139 | John Smith | 08/25/1998 | PTOS | 09/06/2018 | E | 3.54 | - | 183.08 | $ 285.92 | $ - | $ 14,787.28 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 09/06/2018 | U | - | (8.00) | 179.54 | $ - | $ (646.16) | $ 14,501.36 | $ 66.142 | $ - | $ 80.770 | $ 80.770 | $ (14.628) | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/30/2018 | E | 3.54 | - | 187.54 | $ 285.92 | $ - | $ 15,147.51 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/30/2018 | C | - | - | 184.00 | $ - | $ - | $ 14,861.59 | $ (3,270.36) | $ 80.770 | $ - | $ - | $ 80.770 | $ - | |
| 139 | John Smith | 08/25/1998 | PTOS | 08/30/2018 | U | - | (4.00) | 224.49 | $ - | $ (323.08) | $ 18,131.95 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/23/2018 | E | 3.54 | - | 228.49 | $ 285.92 | $ - | $ 18,455.02 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/16/2018 | E | 3.54 | - | 224.95 | $ 285.92 | $ - | $ 18,169.10 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/16/2018 | U | - | (8.00) | 221.41 | $ - | $ (646.16) | $ 17,883.17 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/09/2018 | E | 3.54 | - | 229.41 | $ 285.92 | $ - | $ 18,529.33 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 08/02/2018 | E | 3.54 | - | 225.87 | $ 285.92 | $ - | $ 18,243.41 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/26/2018 | E | 3.54 | - | 222.33 | $ 285.92 | $ - | $ 17,957.48 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/19/2018 | E | 3.54 | - | 218.79 | $ 285.92 | $ - | $ 17,671.56 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/12/2018 | E | 3.54 | - | 215.25 | $ 285.92 | $ - | $ 17,385.63 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/05/2018 | E | 3.54 | - | 211.71 | $ 285.92 | $ - | $ 17,099.71 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 07/05/2018 | U | - | (8.00) | 208.17 | $ - | $ (646.16) | $ 16,813.79 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/28/2018 | E | 3.54 | - | 216.17 | $ 285.92 | $ - | $ 17,459.94 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/28/2018 | U | - | (8.00) | 212.63 | $ - | $ (646.16) | $ 17,174.02 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/21/2018 | E | 3.54 | - | 220.63 | $ 285.92 | $ - | $ 17,820.17 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/21/2018 | U | - | (8.00) | 217.09 | $ - | $ (646.16) | $ 17,534.25 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/14/2018 | E | 3.54 | - | 225.09 | $ 285.92 | $ - | $ 18,180.41 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 06/07/2018 | E | 3.54 | - | 221.55 | $ 285.92 | $ - | $ 17,894.48 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/31/2018 | E | 3.54 | - | 218.01 | $ 285.92 | $ - | $ 17,608.56 | $ 80.770 | $ 80.770 | $ - | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/31/2018 | U | - | (4.00) | 214.47 | $ - | $ (323.08) | $ 17,322.63 | $ 80.770 | $ - | $ 80.770 | $ 80.770 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/24/2018 | E | 3.54 | - | 218.47 | $ 272.31 | $ - | $ 16,805.41 | $ 80.770 | $ 76.923 | $ - | $ 76.923 | $ 3.846 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/24/2018 | U | - | (12.00) | 214.93 | $ - | $ (923.08) | $ 16,533.10 | $ 80.770 | $ - | $ 76.923 | $ 76.923 | $ 3.846 | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/17/2018 | E | 3.54 | - | 226.93 | $ 272.31 | $ - | $ 17,456.18 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/10/2018 | E | 3.54 | - | 223.39 | $ 272.31 | $ - | $ 17,183.87 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 05/03/2018 | E | 3.54 | - | 219.85 | $ 272.31 | $ - | $ 16,911.57 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/26/2018 | E | 3.54 | - | 216.31 | $ 272.31 | $ - | $ 16,639.26 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/19/2018 | E | 3.54 | - | 212.77 | $ 272.31 | $ - | $ 16,366.95 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/19/2018 | U | - | (8.00) | 209.23 | $ - | $ (615.39) | $ 16,094.64 | $ 76.923 | $ - | $ 76.923 | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/12/2018 | E | 3.54 | - | 217.23 | $ 272.31 | $ - | $ 16,710.03 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/12/2018 | U | - | (8.00) | 213.69 | $ - | $ (615.39) | $ 16,437.72 | $ 76.923 | $ - | $ 76.923 | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 04/05/2018 | E | 3.54 | - | 221.69 | $ 272.31 | $ - | $ 17,053.10 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/29/2018 | E | 3.54 | - | 119.08 | $ 272.31 | $ - | $ 9,160.01 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - | ||
| 139 | John Smith | 08/25/1998 | PTOS | 03/22/2018 | E | 3.54 | - | 115.54 | $ 272.31 | $ - | $ 8,887.71 | $ 76.923 | $ 76.923 | $ - | $ 76.923 | $ - |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 01:36 PM
Thank you. For simplification i deleted many rows without differences. Therefore the differences are now in rows 2 - 11 in the screenshot.
If i correctly understand the values in orange in the screenshot are your expected results.
Can you share the formula for the calculation of these values?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 01:42 PM
No, column O is your formula you provided, and they're incorrect. I would expect P or Q or R (just use R for ease).
For example, the first row does NOT have data for E or U types, so just do L/I. The second row HAS data for U, so do K/H. Meaning, only do formula of L/I if there is NO data listed in J or K.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 01:50 PM
Never mind. I figured it out!
=IF(J2>0,J2/G2,IF(K2<0,K2/H2,L2/I2))
=IF(J2>0,J2/G2,IF(K2<0,K2/H2,L2/I2))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 21 2022 01:51 PM
And, I still don't understand why my initial formula returned the Div/0 error as it truly is the accurate condition:
=IF(J2/G2>0,J2/G2,IF(K2/H2>0,K2/H2,L2/I2))
=IF(J2/G2>0,J2/G2,IF(K2/H2>0,K2/H2,L2/I2))