I have a set of data where there is a start and end date for each activity.
With some formulas, I can put a score (points) for each month depending if it's the start month, a month between start & end, or an end month.

I am trying to get to my pivot table without having to repeat each line, once for each month between the start and end date.

If you look at the file, my raw data is in the first tab, my current process (via vba), generates the table in the second tab, where I can use a pivot table to get the table on the right with the correct numbers per month and project. The last tab has the same data but where I add only columns, resulting in a much smaller dataset but where I am unable to get a pivot table with the correct output like in the second tab.

My main problem with tab 2 is that I have 18,000 rows and over 30 columns, when I need to multiply each row by an average of 5, it takes a long tiem to run the macro and makes the dataset really big.
In the ats tab my dataset keeps the same number of rows and only adds a dozen columns... but I don't know how to get to the pivot table.

Anyone has any idea how to solve this?

See attached file:
Book1.xlsx