User Profile
peterso
Helper II
Joined 6 years ago
User Widgets
Contributions
Plotting a Graph
hi everyone - Objective: Apply the total cost for each month that the project is active. For example, Project A: Jan-2020: $1000 Feb-2020: $1000 Mar-2020: $1000 Apr-2020: $0 Project Cost Start Date End Date A $1,000 1/1/2020 3/31/2020 B $5,000 1/1/2021 5/5/2021 C $6,000 3/3/2020 3/5/2020Another Distribution
Hi everyone, I have another distribution questions, taking into account the project start and end date. I'd like to repeat the total cost each month based the start and end date for the project. For example, project A duration is 37 months (start 1/1/2018 and end 1/30/2021) . I'd like to plot $1000 / month for 37 months. Thank you in advance!Distribution Help
Hi everyone, Hoping you can assist with this distribution, i'll do my best to explain. I'd like to distribute cost by month in such a way where it's cumulative(?) on the graph until the cost reaches it's end date, essentially ignoring the start date. When the end date is reached, the cost drops off. For example, Jan 2018 would have $16,000 in cost (sum of project costs for all projects) and Mar 2021 would have $15,000 in cost (sum of project costs minus project A, since the end date has passed (1/30/2021). Below is the table and I have a date table as well. Thank you in advance.
