Hi,
I have a Gantt covering 500+ rows of events past and planned. I use it to predict and track values around these events. Using helper columns to identify the current week, I get an email report on a Monday that tells me the upcoming events in the current week (7 days) and their values.
Currently if an event spans between two weeks, I get the total value reported in week1 and week2, however to be accurate week2's value should actually just be the value M>S of week2 (minus week 1's total).
EG
'eventX' has a value of 2 per day.
'eventX' runs F S S M, total value is 8,
Week1 report says 'eventX' total is 8,
Week2 report should say 'eventX' total is 2.
What complicates matters is the value per day can fluctuate. I already us a lot of parent/children in formatting, would prefer not to be indenting events into sub events, but cant think of a more efficient way of doing this.
Any idea on this?
I've made a copy of the gantt and replaced data with easier numbers, and added in below what I'd like reported: Sheet
Not sure if what I want is even achievable, but worth aiming high. Any help appreaciated.
