Spreadsheet: 819719d1677667160-help-with-complicated-formula-cant-figure-out-why-it-works-so-inconsistently-testing
Sheet: List1

created_utc | created | available_on_utc | available_on | currency | gross | fee | net | reporting_category | source_id | description | customer_facing_amount | customer_facing_currency | [NAME] | automatic_payout_effective_at_utc | automatic_payout_effective_at | customer_id | customer_email | card_country | statement_descriptor | dispute_reason
2022-05-01 09:58:00 | 2022-05-01 11:58:00 | 2022-05-01 09:58:00 | 2022-05-01 11:58:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-02 09:29:00 | 2022-05-02 11:29:00 | 2022-05-02 09:29:00 | 2022-05-02 11:29:00 | eur | -0.04 | 0 | -0.04 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-02 14:28:00 | 2022-05-02 16:28:00 | 2022-05-05 00:00:00 | 2022-05-05 02:00:00 | eur | 164 | 2.55 | 161.45 | charge | ch_3Kv0EPIUTSlnXgMf0nA9Yfce |  | 164 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 | cus_LcEh3FgPCXffRD |  | ES
2022-05-03 13:59:00 | 2022-05-03 15:59:00 | 2022-05-06 00:00:00 | 2022-05-06 02:00:00 | eur | 143.32 | 2.26 | 141.06 | charge | ch_3KvMFkIUTSlnXgMf1NjyKvQ3 |  | 143.32 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | IT
2022-05-03 19:53:00 | 2022-05-03 21:53:00 | 2022-05-06 00:00:00 | 2022-05-06 02:00:00 | eur | -143.32 | 0 | -143.32 | refund | re_3KvMFkIUTSlnXgMf1yrVbupU |  | -143.32 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | IT
2022-05-04 22:06:00 | 2022-05-05 00:06:00 | 2022-05-04 22:06:00 | 2022-05-05 00:06:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-05 07:22:00 | 2022-05-05 09:22:00 | 2022-05-10 00:00:00 | 2022-05-10 02:00:00 | eur | 284.74 | 8.53 | 276.21 | charge | py_3Kvz07IUTSlnXgMf0ilHWhDJ |  | 284.74 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 | cus_LWrhi8FeyFQn5j
2022-05-05 15:54:00 | 2022-05-05 17:54:00 | 2022-05-05 15:54:00 | 2022-05-05 17:54:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-07 22:05:00 | 2022-05-08 00:05:00 | 2022-05-12 00:00:00 | 2022-05-12 02:00:00 | eur | 31.2 | 0.69 | 30.51 | charge | ch_3KwvkvIUTSlnXgMf082qiKIl |  | 31.2 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | AT
2022-05-08 12:40:00 | 2022-05-08 14:40:00 | 2022-05-12 00:00:00 | 2022-05-12 02:00:00 | eur | 183.59 | 2.82 | 180.77 | charge | ch_3Kx9PLIUTSlnXgMf0ab2oM2Q |  | 183.59 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | DE
2022-05-09 16:28:00 | 2022-05-09 18:28:00 | 2022-05-12 00:00:00 | 2022-05-12 02:00:00 | eur | 14.8 | 0.46 | 14.34 | charge | ch_3KxZRXIUTSlnXgMf0Ae6gIag |  | 14.8 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-09 19:42:00 | 2022-05-09 21:42:00 | 2022-05-09 19:42:00 | 2022-05-09 21:42:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-10 06:35:00 | 2022-05-10 08:35:00 | 2022-05-13 00:00:00 | 2022-05-13 02:00:00 | eur | 456.58 | 6.64 | 449.94 | charge | ch_3KxmeoIUTSlnXgMf2hiEfbnz |  | 456.58 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 | cus_Lf6YfBqaqQXB6q |  | IT
2022-05-10 21:44:00 | 2022-05-10 23:44:00 | 2022-05-13 00:00:00 | 2022-05-13 02:00:00 | eur | 133.65 | 2.12 | 131.53 | charge | [NAME] |  | 133.65 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-11 11:41:00 | 2022-05-11 13:41:00 | 2022-05-16 00:00:00 | 2022-05-16 02:00:00 | eur | 39.9 | 0.81 | 39.09 | charge | ch_3KyDuoIUTSlnXgMf2I323zQx |  | 39.9 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-11 12:07:00 | 2022-05-11 14:07:00 | 2022-05-11 12:07:00 | 2022-05-11 14:07:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-12 08:39:00 | 2022-05-12 10:39:00 | 2022-05-12 08:39:00 | 2022-05-12 10:39:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-12 13:36:00 | 2022-05-12 15:36:00 | 2022-05-17 00:00:00 | 2022-05-17 02:00:00 | eur | 28 | 0.64 | 27.36 | charge | ch_3KycC8IUTSlnXgMf2yJd31se |  | 28 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-12 13:38:00 | 2022-05-12 15:38:00 | 2022-05-17 00:00:00 | 2022-05-17 02:00:00 | eur | -28 | 0 | -28 | refund | re_3KycC8IUTSlnXgMf2FR39hNH |  | -28 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-12 14:09:00 | 2022-05-12 16:09:00 | 2022-05-17 00:00:00 | 2022-05-17 02:00:00 | eur | 153.7 | 2.4 | 151.3 | charge | ch_3KychgIUTSlnXgMf2zQ4tR7T |  | 153.7 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-13 01:29:00 | 2022-05-13 03:29:00 | 2022-05-13 01:29:00 | 2022-05-13 03:29:00 | eur | -0.06 | 0 | -0.06 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-13 12:24:00 | 2022-05-13 14:24:00 | 2022-05-18 00:00:00 | 2022-05-18 02:00:00 | eur | 151.8 | 2.38 | 149.42 | charge | ch_3KyxWZIUTSlnXgMf2hvPjq71 |  | 151.8 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 | cus_LO8dTL5sPW55m5 |  | SI
2022-05-13 18:45:00 | 2022-05-13 20:45:00 | 2022-05-13 18:45:00 | 2022-05-13 20:45:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-14 18:48:00 | 2022-05-14 20:48:00 | 2022-05-14 18:48:00 | 2022-05-14 20:48:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-14 18:48:00 | 2022-05-14 20:48:00 | 2022-05-14 18:48:00 | 2022-05-14 20:48:00 | eur | -0.04 | 0 | -0.04 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-16 22:12:00 | 2022-05-17 00:12:00 | 2022-05-19 00:00:00 | 2022-05-19 02:00:00 | eur | 164.14 | 2.55 | 161.59 | charge | ch_3L0C8yIUTSlnXgMf2dRBkjEc |  | 164.14 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | IT
2022-05-17 09:16:00 | 2022-05-17 11:16:00 | 2022-05-20 00:00:00 | 2022-05-20 02:00:00 | eur | 263.7 | 3.94 | 259.76 | charge | ch_3L0MVNIUTSlnXgMf1hC12RYW |  | 263.7 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-17 09:35:00 | 2022-05-17 11:35:00 | 2022-05-20 00:00:00 | 2022-05-20 02:00:00 | eur | 263.7 | 3.94 | 259.76 | charge | ch_3L0Mo3IUTSlnXgMf2dp0WM6W |  | 263.7 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-17 12:58:00 | 2022-05-17 14:58:00 | 2022-05-17 12:58:00 | 2022-05-17 14:58:00 | eur | -0.04 | 0 | -0.04 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-17 12:58:00 | 2022-05-17 14:58:00 | 2022-05-17 12:58:00 | 2022-05-17 14:58:00 | eur | 0.02 | 0 | 0.02 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-17 13:01:00 | 2022-05-17 15:01:00 | 2022-05-17 13:01:00 | 2022-05-17 15:01:00 | eur | 2.82 | 0 | 2.82 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-17 14:04:00 | 2022-05-17 16:04:00 | 2022-05-20 00:00:00 | 2022-05-20 02:00:00 | eur | 364.36 | 5.35 | 359.01 | charge | ch_3L0R01IUTSlnXgMf2R7rU9yR |  | 364.36 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 | [NAME] |  | SI
2022-05-17 21:17:00 | 2022-05-17 23:17:00 | 2022-05-20 00:00:00 | 2022-05-20 02:00:00 | eur | 305.94 | 4.53 | 301.41 | charge | ch_3L0XlVIUTSlnXgMf2gWwx5B2 |  | 305.94 | eur | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00 |  |  | SI
2022-05-18 05:05:00 | 2022-05-18 07:05:00 | 2022-05-18 05:05:00 | 2022-05-18 07:05:00 | eur | -2.82 | 0 | -2.82 | fee |  |  |  |  | po_1L1Mc1IUTSlnXgMfnWYXm0j8 | 2022-05-20 03:34:00 | 2022-05-20 05:34:00
2022-05-19 10:26:00 | 2022-05-19 12:26:00 | 2022-05-24 00:00:00 | 2022-05-24 02:00:00 | eur | 74.2 | 1.29 | 72.91 | charge | ch_3L16YrIUTSlnXgMf0xhjP7sk |  | 74.2 | eur | po_1L2nPcIUTSlnXgMfjMxu4CAZ | 2022-05-24 02:23:00 | 2022-05-24 04:23:00 | cus_LhlVq26UqVbEdk |  | HR
2022-05-20 02:15:00 | 2022-05-20 04:15:00 | 2022-05-20 02:15:00 | 2022-05-20 04:15:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L2nPcIUTSlnXgMfjMxu4CAZ | 2022-05-24 02:23:00 | 2022-05-24 04:23:00
2022-05-20 17:42:00 | 2022-05-20 19:42:00 | 2022-05-20 17:42:00 | 2022-05-20 19:42:00 | eur | -0.16 | 0 | -0.16 | fee |  |  |  |  | po_1L2nPcIUTSlnXgMfjMxu4CAZ | 2022-05-24 02:23:00 | 2022-05-24 04:23:00
2022-05-21 14:48:00 | 2022-05-21 16:48:00 | 2022-05-26 00:00:00 | 2022-05-26 02:00:00 | eur | 133.8 | 2.12 | 131.68 | charge | ch_3L1tbtIUTSlnXgMf1RJI6XqC |  | 133.8 | eur | po_1L3WEvIUTSlnXgMfyFdlX6rl | 2022-05-26 02:15:00 | 2022-05-26 04:15:00 | cus_LjMHBOgs4TB7Rn |  | SI
2022-05-22 01:41:00 | 2022-05-22 03:41:00 | 2022-05-22 01:41:00 | 2022-05-22 03:41:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L2nPcIUTSlnXgMfjMxu4CAZ | 2022-05-24 02:23:00 | 2022-05-24 04:23:00
2022-05-22 14:28:00 | 2022-05-22 16:28:00 | 2022-05-26 00:00:00 | 2022-05-26 02:00:00 | eur | 25.5 | 0.61 | 24.89 | charge | ch_3L2FlhIUTSlnXgMf1rjCBEfM |  | 25.5 | eur | po_1L3WEvIUTSlnXgMfyFdlX6rl | 2022-05-26 02:15:00 | 2022-05-26 04:15:00 |  |  | SI
2022-05-23 12:52:00 | 2022-05-23 14:52:00 | 2022-05-23 12:52:00 | 2022-05-23 14:52:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L2nPcIUTSlnXgMfjMxu4CAZ | 2022-05-24 02:23:00 | 2022-05-24 04:23:00
2022-05-23 14:22:00 | 2022-05-23 16:22:00 | 2022-05-26 00:00:00 | 2022-05-26 02:00:00 | eur | 165.94 | 2.57 | 163.37 | charge | ch_3L2c9QIUTSlnXgMf1d0QRfeX |  | 165.94 | eur | po_1L3WEvIUTSlnXgMfyFdlX6rl | 2022-05-26 02:15:00 | 2022-05-26 04:15:00 |  |  | SI
2022-05-24 14:57:00 | 2022-05-24 16:57:00 | 2022-05-24 14:57:00 | 2022-05-24 16:57:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L3WEvIUTSlnXgMfyFdlX6rl | 2022-05-26 02:15:00 | 2022-05-26 04:15:00
2022-05-25 10:30:00 | 2022-05-25 12:30:00 | 2022-05-30 00:00:00 | 2022-05-30 02:00:00 | eur | 160.7 | 2.5 | 158.2 | charge | ch_3L3HSmIUTSlnXgMf0RMw5lrn |  | 160.7 | eur | po_1L4yFfIUTSlnXgMfEEF14NCx | 2022-05-30 02:22:00 | 2022-05-30 04:22:00 | cus_LO8dTL5sPW55m5 |  | SI
2022-05-25 16:37:00 | 2022-05-25 18:37:00 | 2022-05-25 16:37:00 | 2022-05-25 18:37:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L3WEvIUTSlnXgMfyFdlX6rl | 2022-05-26 02:15:00 | 2022-05-26 04:15:00
2022-05-27 12:37:00 | 2022-05-27 14:37:00 | 2022-06-01 00:00:00 | 2022-06-01 02:00:00 | eur | 36.9 | 0.77 | 36.13 | charge | ch_3L42PXIUTSlnXgMf1yIm9v09 |  | 36.9 | eur | po_1L5h8CIUTSlnXgMfuD6IFdis | 2022-06-01 02:17:00 | 2022-06-01 04:17:00 |  |  | SI
2022-05-27 23:35:00 | 2022-05-28 01:35:00 | 2022-05-27 23:35:00 | 2022-05-28 01:35:00 | eur | -0.12 | 0 | -0.12 | fee |  |  |  |  | po_1L4yFfIUTSlnXgMfEEF14NCx | 2022-05-30 02:22:00 | 2022-05-30 04:22:00
2022-05-29 00:42:00 | 2022-05-29 02:42:00 | 2022-05-29 00:42:00 | 2022-05-29 02:42:00 | eur | -0.04 | 0 | -0.04 | fee |  |  |  |  | po_1L4yFfIUTSlnXgMfEEF14NCx | 2022-05-30 02:22:00 | 2022-05-30 04:22:00
2022-05-29 18:02:00 | 2022-05-29 20:02:00 | 2022-05-29 18:02:00 | 2022-05-29 20:02:00 | eur | -0.02 | 0 | -0.02 | fee |  |  |  |  | po_1L4yFfIUTSlnXgMfEEF14NCx | 2022-05-30 02:22:00 | 2022-05-30 04:22:00
2022-05-30 12:46:00 | 2022-05-30 14:46:00 | 2022-06-02 00:00:00 | 2022-06-02 02:00:00 | eur | 110.8 | 1.8 | 109 | charge | ch_3L57z4IUTSlnXgMf0RqMG3WO |  | 110.8 | eur | po_1L63fKIUTSlnXgMf1MlSXafU | 2022-06-02 02:21:00 | 2022-06-02 04:21:00 |  |  | SI
2022-05-31 17:04:00 | 2022-05-31 19:04:00 | 2022-06-03 00:00:00 | 2022-06-03 02:00:00 | eur | 39.9 | 0.81 | 39.09 | charge | ch_3L5YV1IUTSlnXgMf0r6TwAJn |  | 39.9 | eur | po_1L6PYyIUTSlnXgMfcknCyYfZ | 2022-06-03 01:44:00 | 2022-06-03 03:44:00 |  |  | SI