Using Excel, how could I calculate a cubic spline curve in monthly granularity when my inputs are a combination of months, quarters and years? The quarter and yearly averages of the spline curve need to be exactly the same as the input. An example set of inputs would be:
Unfortunately, I can only find how to do this if the inputs are all single months.
Any help will be much appreciated.