The information provide is certainly much more details than what I did in my Excel sheet (my objective was to be simple).
However, here is my thinking. When presenting the information in a pie chart, removing the numbers (%weight) & using identical data (meaning pillars right now), then regardless how you treat the weights of AP/LP or both, the results appearance would look very similar. Graphical presentation shouldn't be off by too much because the sum of the weight will always be 1 or 100%.
When unsure of the weight for LP / Ap, then use average or equal weight of the two. Also, the chart represents specific time or moment, thus time weight is ignore.
What does other think about this approach?