Spreadsheet: 776007d1649434617-retrieve-values-from-different-excel-files-test-dashboard
Sheet: SUBSCRIPTIONS

CID | STATUS | BILL ID | YEAR | QUARTER | START | END | FIXED | RECURRING | TOTAL HTVA | TOTAL TVAC | STATUS | COMMENTS
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 |  | 2999 |  |  |  | à percevoir | website creation
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Billed | 2022-006 |  |  | 2022-04-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | à percevoir | domain name registration
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | domain name renewal
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | domain name renewal
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | domain name renewal
 | Billed | 2022-004 |  |  | 2022-02-01 00:00:00 |  | 2999 |  |  |  | perçu | website creation
 | Billed | 2022-004 |  |  | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  | 100 |  |  | à percevoir | last year's automatic translations
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  | 100 |  |  | à percevoir | last year's automatic translations
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  | 100 |  |  | à percevoir | last year's automatic translations
 | Billed | 2022-003 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | annulé | domain name registration
 | Billed | 2022-002 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | perçu | domain name registration
 | Billed | 2022-001 |  |  | 2022-01-12 00:00:00 |  | 8.46 |  |  |  | annulé | domain name registration
 | Billed | 2021-007 |  |  | 2021-12-01 00:00:00 |  | 1599 |  |  |  | perçu | website creation
 | Billed | 2021-008 |  |  | 2021-12-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Billed | 2021-008 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Billed | 2021-008 |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Billed | 2021-008 |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Billed | 2021-005 |  |  | 2021-10-01 00:00:00 |  | 500 |  |  |  | perçu | website creation
 | Billed | 2021-006 |  |  | 2021-10-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Billed | 2021-003 |  |  | 2021-07-01 00:00:00 |  |  |  |  |  | perçu | website creation
 | Billed | 2021-004 |  |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Billed | 2022-007 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Billed | 2021-001 |  |  | 2021-07-01 00:00:00 |  |  |  |  |  | perçu | website creation
 | Billed | 2021-002 |  |  | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Billed | 2022-005 |  |  | 2022-01-01 00:00:00 | 2022-12-31 00:00:00 |  |  |  |  | perçu | website maintenance
 | Forecast |  |  |  | 2023-01-01 00:00:00 | 2023-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2024-01-01 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance
 | Forecast |  |  |  | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  |  |  | à percevoir | website maintenance