Spreadsheet: 867286d1714128099-formula-to-move-data-depending-on-project-start-date-project-start-date
Sheet: Calculation needed

Start Date | PROJECTS | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00
2024-04-01 00:00:00 | [NAME] | 0 | 0 | 0 | 0 | 80200.47857142857 | 276246.0928571429 | 267334.9285714286 | 276246.0928571429 | 276246.0928571429 | 8911.164285714285 | 0 | 0
2024-04-01 00:00:00 | SLOT2 | 0 | 0 | 0 | 0 | 3228.285714285714 | 142377 | 350031.7142857143 | 415392.4285714286 | 237431.7142857143 | 231440.7142857143 | 173761.7232099165 | 57876
2024-04-01 00:00:00 | SLOT3 | 0 | 0 | 0 | 0 | 130000 | 150000 | 155000 | 155000 | 110000 | 0 | 0
2024-04-01 00:00:00 | SLOT4 | 0 | 0 | 0 | 0 | 99840 | 249600 | 257920 | 257920 | 249600 | 257920 | 83200
2024-04-01 00:00:00 | SLOT5 | 0 | 0 | 0 | 0 | 28571.42857142857 | 171428.5714285714 | 177142.8571428572 | 177142.8571428572 | 171428.5714285714 | 74285.71428571429 | 0
2024-04-01 00:00:00 | SLOT6 | 0 | 0 | 0 | 0 | 85714.28571428571 | 214285.7142857143 | 221428.5714285714 | 221428.5714285714 | 214285.7142857143 | 142857.1428571428 | 0
2024-04-01 00:00:00 | SLOT7 | 0 | 0 | 0 | 0 | 26785.71428571429 | 160714.2857142857 | 166071.4285714286 | 166071.4285714286 | 160714.2857142857 | 166071.4285714286 | 160714.2857142857
2024-04-01 00:00:00 | SLOT8 | 0 | 0 | 0 | 0 | 109090.8 | 241558.2 | 241558.2 | 233766 | 241558.2 | 132467.4
2024-04-01 00:00:00 | SLOT9 | 0 | 0 | 0 | 0 | 118857.12 | 175455.7485714286 | 175455.7485714286 | 169795.8857142857 | 175455.7485714286 | 16979.58857142857
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | SPECULATIVE PROJECTS - LONG FORMAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Yes | 2024 ZAP1 FURTHER DEVELOPMENT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 79081.63265306098 | 79081.63265306097 | 76530.61224489773 | 15306.12244897954 | 0
Yes | 2024 ZAP1 SERIES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2024 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0