I have a data table similar to below. What I would like to do it assign the number of machines into one of 3 categories, design, build, commissioning.
If more of the timeline is in the design portion, the # of machines would be assigned to that month. For example, line 10, November to December 2021 would be 4 in design, but January 2022 would have 4 in build as only 7 days in January are in design and the remaining days are in build.
I want the information to be transferred to a table similar to:
Any help would be greatly appreciated!! Been stuck for a while now...
If more of the timeline is in the design portion, the # of machines would be assigned to that month. For example, line 10, November to December 2021 would be 4 in design, but January 2022 would have 4 in build as only 7 days in January are in design and the remaining days are in build.
I want the information to be transferred to a table similar to:
Any help would be greatly appreciated!! Been stuck for a while now...