Spreadsheet: 874706d1721238121-formula-needed-mockup
Sheet: Sheet1

June Deduction |  |  |  |  |  |  | June Bill
Row Labels | DEN125 | DIFF | VIS125 | DIFF |  |  | Row Labels | Sum of DENTAL PREMIUM | Sum of VISION PREMIUM
5 | 871.94 | - | 208.5600000000001 | - |  |  | 5 | 945.9000000000001 | 229.6
2024-06-07 00:00:00 | 435.97 |  | 104.28 |  |  |  | 2024-06-07 00:00:00 | 472.95 | 114.8
2024-06-21 00:00:00 | 435.97 |  | 104.28 |  |  |  | 2024-06-21 00:00:00 | 472.95 | 114.8
75 | 0 | - | 9.7 |  |  |  | 75 | 35.05 | 10.51
2024-06-14 00:00:00 | 0 |  | 4.85 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 0 |  | 4.85 |  |  |  | 2024-06-28 00:00:00 | 35.05 | 10.51
100 | 575.02 |  | 61.7 |  |  |  |  | 0 | 0
2024-06-12 00:00:00 | 98.77 |  | 13.71 |  |  |  |  | 0 | 0
2024-06-14 00:00:00 | 188.74 |  | 17.14 |  |  |  |  | 0 | 0
2024-06-26 00:00:00 | 98.77 |  | 13.71 |  |  |  |  | 0 | 0
2024-06-28 00:00:00 | 188.74 |  | 17.14 |  |  |  |  | 0 | 0
119 | 0 |  | 9.7 |  |  |  | 119 | 0 | 15.36
2024-06-07 00:00:00 | 0 |  | 0 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 0 |  | 9.7 |  |  |  | 2024-06-21 00:00:00 | 0 | 15.36
124 | 980.8 |  | 335.0699999999998 |  |  |  | 124 | 3744.64 | 368.29
2024-06-13 00:00:00 | 490.4 |  | 165.1099999999999 |  |  |  | 2024-06-13 00:00:00 | 0 | 0
2024-06-27 00:00:00 | 490.4 |  | 169.9599999999999 |  |  |  | 2024-06-27 00:00:00 | 3744.64 | 368.29
138 | 72.56 |  | 6.64 |  |  |  | 138 | 695.49 | 153.78
2024-06-07 00:00:00 | 18.14 |  | 1.66 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-14 00:00:00 | 18.14 |  | 1.66 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 18.14 |  | 1.66 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 18.14 |  | 1.66 |  |  |  | 2024-06-28 00:00:00 | 695.49 | 153.78
165 | 327.86 |  | 76.02 |  |  |  | 165 | 327.83 | 75.98
2024-06-13 00:00:00 | 163.93 |  | 38.01 |  |  |  | 2024-06-13 00:00:00 | 0 | 0
2024-06-27 00:00:00 | 163.93 |  | 38.01 |  |  |  | 2024-06-27 00:00:00 | 327.83 | 75.98
171 | 58.72 |  | 11.89 |  |  |  | 171 | 0 | 0
2024-06-14 00:00:00 | 58.72 |  | 11.89 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
179 | 22.12 |  | 29.16 |  |  |  | 179 | 47.94 | 31.53
2024-06-07 00:00:00 | 5.53 |  | 7.290000000000001 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-14 00:00:00 | 5.53 |  | 7.290000000000001 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 5.53 |  | 7.290000000000001 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 5.53 |  | 7.290000000000001 |  |  |  | 2024-06-28 00:00:00 | 47.94 | 31.53
182 | 801.59 |  | 141.56 |  |  |  | 182 | 2197.6 | 213.91
2024-06-13 00:00:00 | 400.8 |  | 70.78 |  |  |  | 2024-06-13 00:00:00 | -49.99 | -10.51
2024-06-27 00:00:00 | 400.79 |  | 70.78 |  |  |  | 2024-06-27 00:00:00 | 2247.59 | 224.42
191 | 346.78 |  | 25.54 |  |  |  | 191 | 375.67 | 27.66
2024-06-07 00:00:00 | 173.39 |  | 12.77 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 173.39 |  | 12.77 |  |  |  | 2024-06-21 00:00:00 | 375.67 | 27.66
205 | 281.92 |  | 48.5 |  |  |  | 205 | 305.41 | 80.2
2024-06-14 00:00:00 | 140.96 |  | 24.25 |  |  |  | 2024-06-14 00:00:00 | 305.41 | 80.2
2024-06-28 00:00:00 | 140.96 |  | 24.25 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
218 | 63.52 |  | 35.24 |  |  |  | 218 | 155.06 | 54.96
2024-06-07 00:00:00 | 15.88 |  | 8.81 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-14 00:00:00 | 15.88 |  | 8.81 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 15.88 |  | 8.81 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 15.88 |  | 8.81 |  |  |  | 2024-06-28 00:00:00 | 155.06 | 54.96
227 | 406.1 |  | 60.73999999999999 |  |  |  | 227 | 439.92 | 65.81
2024-06-14 00:00:00 | 203.05 |  | 30.37 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 203.05 |  | 30.37 |  |  |  | 2024-06-28 00:00:00 | 439.92 | 65.81
232 | 371.32 |  | 56.56 |  |  |  | 232 | 371.32 | 56.56
2024-06-07 00:00:00 | 92.83 |  | 14.14 |  |  |  | 2024-06-07 00:00:00 | 92.83 | 14.14
2024-06-14 00:00:00 | 92.83 |  | 14.14 |  |  |  | 2024-06-14 00:00:00 | 92.83 | 14.14
2024-06-21 00:00:00 | 92.83 |  | 14.14 |  |  |  | 2024-06-21 00:00:00 | 92.83 | 14.14
2024-06-28 00:00:00 | 92.83 |  | 14.14 |  |  |  | 2024-06-28 00:00:00 | 92.83 | 14.14
260 | 1287.08 |  | 228.36 |  |  |  | 260 | 1287 | 255.94
2024-06-07 00:00:00 | 321.77 |  | 57.09000000000001 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-14 00:00:00 | 321.77 |  | 57.09000000000001 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 321.77 |  | 57.09000000000001 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 321.77 |  | 57.09000000000001 |  |  |  | 2024-06-28 00:00:00 | 1287 | 255.94
264 | 0 |  | 194.5 |  |  |  | 264 | 0 | 194.36
2024-06-07 00:00:00 | 0 |  | 97.25 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 0 |  | 97.25 |  |  |  | 2024-06-21 00:00:00 | 0 | 194.36
266 | 160.24 |  | 10.52 |  |  |  | 266 | 160.22 | 10.51
2024-06-14 00:00:00 | 80.12 |  | 5.26 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 80.12 |  | 5.26 |  |  |  | 2024-06-28 00:00:00 | 160.22 | 10.51
274 | 74.45 |  | 27.67 |  |  |  | 274 | 74.44 | 27.66
2024-06-07 00:00:00 | 37.22 |  | 13.83 |  |  |  | 2024-06-07 00:00:00 | -49.99 | -10.51
2024-06-21 00:00:00 | 37.23 |  | 13.84 |  |  |  | 2024-06-21 00:00:00 | 124.43 | 38.17
276 | 601.2 |  | 190.62 |  |  |  | 276 | 601.08 | 190.49
2024-06-07 00:00:00 | 300.6 |  | 95.31 |  |  |  | 2024-06-07 00:00:00 | 601.08 | 190.49
2024-06-21 00:00:00 | 300.6 |  | 95.31 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
286 | 120.14 |  | 20.48 |  |  |  | 286 | 160.13 | 27.31
2024-06-14 00:00:00 | 60.07 |  | 10.24 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 60.07 |  | 10.24 |  |  |  | 2024-06-28 00:00:00 | 160.13 | 27.31
291 | 102.42 |  | 145.08 |  |  |  | 291 | 859.42 | 155.5
2024-06-14 00:00:00 | 51.21 |  | 72.53999999999999 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 51.21 |  | 72.53999999999999 |  |  |  | 2024-06-28 00:00:00 | 859.42 | 155.5
292 | 465.99 |  | 87.57999999999998 |  |  |  | 292 | 1198.93 | 175.4
2024-06-14 00:00:00 | 238.99 |  | 46.41999999999999 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 227 |  | 41.16 |  |  |  | 2024-06-28 00:00:00 | 1198.93 | 175.4
295 | 0 |  | 380.8399999999999 |  |  |  | 295 | 0 | 391.12
2024-06-07 00:00:00 | 0 |  | 190.42 |  |  |  | 2024-06-07 00:00:00 | 0 | 391.12
2024-06-21 00:00:00 | 0 |  | 190.42 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
296 | 453.48 |  | 102.68 |  |  |  | 296 | 478.41 | 107.86
2024-06-07 00:00:00 | 239.24 |  | 53.96999999999999 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 214.24 |  | 48.70999999999999 |  |  |  | 2024-06-21 00:00:00 | 478.41 | 107.86
297 | 540.6600000000001 |  | 107.58 |  |  |  | 297 | 599.68 | 107.51
2024-06-13 00:00:00 | 270.33 |  | 53.78999999999999 |  |  |  | 2024-06-13 00:00:00 | 0 | 0
2024-06-27 00:00:00 | 270.33 |  | 53.78999999999999 |  |  |  | 2024-06-27 00:00:00 | 599.68 | 107.51
298 | 63.36 |  | 10.52 |  |  |  | 298 | 63.36 | 10.51
2024-06-07 00:00:00 | 15.84 |  | 2.63 |  |  |  | 2024-06-07 00:00:00 | 0 | 0
2024-06-14 00:00:00 | 15.84 |  | 2.63 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 15.84 |  | 2.63 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 15.84 |  | 2.63 |  |  |  | 2024-06-28 00:00:00 | 63.36 | 10.51
300 | 2322.82 |  | 434.7800000000001 |  |  |  | 300 | 2385.09 | 434.54
2024-06-07 00:00:00 | 1161.41 |  | 217.39 |  |  |  | 2024-06-07 00:00:00 | 2420.14 | 445.05
2024-06-21 00:00:00 | 1161.41 |  | 217.39 |  |  |  | 2024-06-21 00:00:00 | -35.05 | -10.51
301 | 259.42 |  | 75.67999999999999 |  |  |  | 301 | 321.9 | 75.64
2024-06-14 00:00:00 | 129.71 |  | 37.84 |  |  |  | 2024-06-14 00:00:00 | 321.9 | 75.64
2024-06-28 00:00:00 | 129.71 |  | 37.84 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
303 | 8.32 |  | 8.24 |  |  |  | 303 | 128.77 | 21.02
2024-06-07 00:00:00 | 4.16 |  | 4.12 |  |  |  | 2024-06-07 00:00:00 | 128.77 | 21.02
2024-06-21 00:00:00 | 4.16 |  | 4.12 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
304 | 59.17999999999999 |  | 31.56 |  |  |  | 304 | 179.15 | 31.53
2024-06-13 00:00:00 | 29.59 |  | 15.78 |  |  |  | 2024-06-13 00:00:00 | 179.15 | 31.53
2024-06-27 00:00:00 | 29.59 |  | 15.78 |  |  |  | 2024-06-27 00:00:00 | 0 | 0
308 | 133.02 |  | 19.4 |  |  |  | 308 | 144.1 | 21.02
2024-06-14 00:00:00 | 66.50999999999999 |  | 9.7 |  |  |  | 2024-06-14 00:00:00 | 144.1 | 21.02
2024-06-28 00:00:00 | 66.50999999999999 |  | 9.7 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
- | - |  | - |  |  |  | 313 | 659.25 | 116.22
- | - |  | - |  |  |  | 2024-06-12 00:00:00 | 659.25 | 116.22
- | - |  | - |  |  |  | 2024-06-26 00:00:00 | 0 | 0
314 | 693.2399999999999 |  | 107.4 |  |  |  | 314 | 848.66 | 126.74
2024-06-07 00:00:00 | 173.31 |  | 26.85 |  |  |  | 2024-06-07 00:00:00 | 848.66 | 126.74
2024-06-14 00:00:00 | 173.31 |  | 26.85 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 173.31 |  | 26.85 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 173.31 |  | 26.85 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
320 | 394.8099999999999 |  | 134.55 |  |  |  | 320 | 359.7 | 123.97
2024-06-06 00:00:00 | 98.71 |  | 33.63 |  |  |  | 2024-06-06 00:00:00 | 0 | 0
2024-06-13 00:00:00 | 98.69999999999999 |  | 33.63999999999999 |  |  |  | 2024-06-13 00:00:00 | -35.05 | -10.51
2024-06-20 00:00:00 | 98.69999999999999 |  | 33.63999999999999 |  |  |  | 2024-06-20 00:00:00 | 0 | 0
2024-06-27 00:00:00 | 98.69999999999999 |  | 33.63999999999999 |  |  |  | 2024-06-27 00:00:00 | 394.75 | 134.48
329 | 83.02000000000001 |  | 57.85999999999999 |  |  |  | 329 | 169.25 | 63.06
2024-06-14 00:00:00 | 41.51000000000001 |  | 31.56 |  |  |  | 2024-06-14 00:00:00 | 169.25 | 63.06
2024-06-28 00:00:00 | 41.51000000000001 |  | 26.3 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
332 | 361.08 |  | 77.42 |  |  |  | 332 | 553.87 | 135.18
2024-06-14 00:00:00 | 180.54 |  | 38.71 |  |  |  | 2024-06-14 00:00:00 | 553.87 | 135.18
2024-06-28 00:00:00 | 180.54 |  | 38.71 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
340 | 35.06 |  | 10.52 |  |  |  | 340 | 35.05 | 10.51
2024-06-14 00:00:00 | 17.53 |  | 5.26 |  |  |  | 2024-06-14 00:00:00 | 35.05 | 10.51
2024-06-28 00:00:00 | 17.53 |  | 5.26 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
- | - |  | - |  |  |  | 345 | 86.26 | 16.8
- | - |  | - |  |  |  | 2024-06-14 00:00:00 | 86.26 | 16.8
- | - |  | - |  |  |  | 2024-06-28 00:00:00 | 0 | 0
349 | 117.6 |  | - |  |  |  | 349 | 117.58 | 0
2024-06-07 00:00:00 | 58.8 |  | - |  |  |  | 2024-06-07 00:00:00 | 117.58 | 0
2024-06-21 00:00:00 | 58.8 |  | - |  |  |  | 2024-06-21 00:00:00 | 0 | 0
350 | 227.18 |  | 42.08 |  |  |  | 350 | 412.48 | 63.06
2024-06-07 00:00:00 | 113.59 |  | 21.04 |  |  |  | 2024-06-07 00:00:00 | 412.48 | 63.06
2024-06-21 00:00:00 | 113.59 |  | 21.04 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
352 | - |  | 25.24 |  |  |  | 352 | 0 | 27.31
2024-06-07 00:00:00 | - |  | 6.31 |  |  |  | 2024-06-07 00:00:00 | 0 | 27.31
2024-06-14 00:00:00 | - |  | 6.31 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | - |  | 6.31 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | - |  | 6.31 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
367 | 202.52 |  | 44.96 |  |  |  | 367 | 219.39 | 48.67
2024-06-07 00:00:00 | 50.63 |  | 11.24 |  |  |  | 2024-06-07 00:00:00 | 219.39 | 48.67
2024-06-14 00:00:00 | 50.63 |  | 11.24 |  |  |  | 2024-06-14 00:00:00 | 0 | 0
2024-06-21 00:00:00 | 50.63 |  | 11.24 |  |  |  | 2024-06-21 00:00:00 | 0 | 0
2024-06-28 00:00:00 | 50.63 |  | 11.24 |  |  |  | 2024-06-28 00:00:00 | 0 | 0
370 | 43.8 |  | 81.58 |  |  |  | 370 | 247.71 | 81.57
2024-06-07 00:00:00 | 17.52 |  | 24.34 |  |  |  | 2024-06-07 00:00:00 | 247.71 | 60.84
2024-06-14 00:00:00 | 8.76 |  | 19.08 |  |  |  | 2024-06-14 00:00:00 | 0 | 6.91
2024-06-21 00:00:00 | 8.76 |  | 19.08 |  |  |  | 2024-06-21 00:00:00 | 0 | 6.91
2024-06-28 00:00:00 | 8.76 |  | 19.08 |  |  |  | 2024-06-28 00:00:00 | 0 | 6.91