Spreadsheet: 757690d1638396235-formula-to-bring-values-from-another-table-based-on-a-launch-date-template-excel-product-lifecycle-and-income-statement-based-on-a-launch-date
Sheet: Revenue

 | Product launches
 | PRoduct Launch A | 2021-03-31 00:00:00
 | PRoduct Launch B | 2021-05-31 00:00:00
 | Master Income Statement
 |  | Quarter 1 | Quarter 1 | Quarter 1 | Quarter 2 | Quarter 2 | Quarter 2 | Quarter 3 | Quarter 3 | Quarter 3 | Quarter 4 | Quarter 4 | Quarter 4 | Quarter 5 | Quarter 5 | Quarter 5 | Quarter 6 | Quarter 6 | Quarter 6 | Quarter 7 | Quarter 7 | Quarter 7 | Quarter 8 | Quarter 8 | Quarter 8
 | EUR in 000s | 2021-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-31 00:00:00
 | Revenue
 | Costs
 | Other costs
 | Product Profit before share
 | Partner share
 | PRoduct profit after partner share
 | Standard IS - Lifecycle
 |  | Quarter 1 | Quarter 1 | Quarter 1 | Quarter 2 | Quarter 2 | Quarter 2 | Quarter 3 | Quarter 3 | Quarter 3 | Quarter 4 | Quarter 4 | Quarter 4 | Quarter 5 | Quarter 5 | Quarter 5 | Quarter 6 | Quarter 6 | Quarter 6 | Quarter 7 | Quarter 7 | Quarter 7 | Quarter 8 | Quarter 8 | Quarter 8
 | EUR in 000s | 1
 | Revenue | 17050 | 15400 | 17050 | 17250 | 17825 | 17250 | 18600 | 18600 | 18000 | 19375 | 18750 | 19375 | 40300.00000000001 | 36400.00000000001 | 40300.00000000001 | 40500.00000000001 | 41850.00000000001 | 40500.00000000001 | 43400.00000000001 | 43400.00000000001 | 42000.00000000001 | 44950.00000000001 | 43500.00000000001 | 44950.00000000001
 | Costs | -15500 | -14000 | -15500 | -15000 | -15500 | -15000 | -15500 | -15500 | -15000 | -15500 | -15000 | -15500 | -31000 | -28000 | -31000 | -30000 | -31000 | -30000 | -31000 | -31000 | -30000 | -31000 | -30000 | -31000
 | Other costs | -596.75 | -539.0000000000001 | -596.75 | -603.7500000000002 | -623.8750000000002 | -603.7500000000002 | -651.0000000000002 | -651.0000000000002 | -630.0000000000002 | -678.1250000000002 | -656.2500000000002 | -678.1250000000002 | -1410.5 | -1274 | -1410.5 | -1417.5 | -1464.75 | -1417.5 | -1519.000000000001 | -1519.000000000001 | -1470 | -1573.250000000001 | -1522.500000000001 | -1573.250000000001
 | Product Profit before share | 953.25 | 861.0000000000017 | 953.25 | 1646.250000000003 | 1701.125000000003 | 1646.250000000003 | 2449.000000000004 | 2449.000000000004 | 2370.000000000004 | 3196.875000000004 | 3093.750000000004 | 3196.875000000004 | 7889.500000000007 | 7126.000000000007 | 7889.500000000007 | 9082.500000000007 | 9385.250000000007 | 9082.500000000007 | 10881.00000000001 | 10881.00000000001 | 10530.00000000001 | 12376.75000000001 | 11977.50000000001 | 12376.75000000001
 | Partner share | -476.625 | -430.5000000000009 | -476.625 | -823.1250000000017 | -850.5625000000017 | -823.1250000000017 | -1224.500000000002 | -1224.500000000002 | -1185.000000000002 | -1598.437500000002 | -1546.875000000002 | -1598.437500000002 | -3944.750000000004 | -3563.000000000004 | -3944.750000000004 | -4541.250000000004 | -4692.625000000004 | -4541.250000000004 | -5440.500000000007 | -5440.500000000007 | -5265.000000000004 | -6188.375000000007 | -5988.750000000007 | -6188.375000000007
 | PRoduct profit after partner share | 476.625 | 430.5000000000009 | 476.625 | 823.1250000000017 | 850.5625000000017 | 823.1250000000017 | 1224.500000000002 | 1224.500000000002 | 1185.000000000002 | 1598.437500000002 | 1546.875000000002 | 1598.437500000002 | 3944.750000000004 | 3563.000000000004 | 3944.750000000004 | 4541.250000000004 | 4692.625000000004 | 4541.250000000004 | 5440.500000000007 | 5440.500000000007 | 5265.000000000004 | 6188.375000000007 | 5988.750000000007 | 6188.375000000007
 | # of days | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31 | 31 | 28 | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
 |  | 2021-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-31 00:00:00