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.
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?
Sep 21 2022 12:15 PM
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.
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."
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 |
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")...
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 | $ - |
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?
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.
Sep 21 2022 01:50 PM
Sep 21 2022 01:51 PM