Hello all!
I am currently creating a finance dashboard for my government contracting company and have automated the majority of the sheets to disperse a total dollar amount of a contract over a specified time period (in months) evenly and to populate these fields automatically.
The problem is that there is phasing to government contracts or "ramp up" so that the month-by-month spending starts at let's say 25% and slowly ramps up to 100% and eventually 100%+ to make up for the first few months of being below 100% and then back down to 100%.
I need to be able to apply this ramp-up/ramp-down to the time series of evenly distributed dollar amounts in my data, so two part question:
1) How can I design a function to be spread evenly across this time series that will ramp up from some percentage of the overall number to over 100% and then back down and still have the total of the time series come out to be the fixed price of the contract.
2) How can I apply this to my time series (this one is less important as I believe I can figure it out if the above question is answered).
Thank you all so much in advance!
I am currently creating a finance dashboard for my government contracting company and have automated the majority of the sheets to disperse a total dollar amount of a contract over a specified time period (in months) evenly and to populate these fields automatically.
The problem is that there is phasing to government contracts or "ramp up" so that the month-by-month spending starts at let's say 25% and slowly ramps up to 100% and eventually 100%+ to make up for the first few months of being below 100% and then back down to 100%.
I need to be able to apply this ramp-up/ramp-down to the time series of evenly distributed dollar amounts in my data, so two part question:
1) How can I design a function to be spread evenly across this time series that will ramp up from some percentage of the overall number to over 100% and then back down and still have the total of the time series come out to be the fixed price of the contract.
2) How can I apply this to my time series (this one is less important as I believe I can figure it out if the above question is answered).
Thank you all so much in advance!