Hello,

I have a historical time series of 72-year monthly inflows. I need to generate, say 100, synthetic scenarios using the historical data.

Simple resampling (by reordering annual blocks of inflows) is not the goal and not accepted. I want synthetic scenarios to have different monthly values, but all summing up to the same value of the annual inflow as in the historical one (e.g. if in the historical data 2015 inflow is 2400 MCM, I want the synthetic scenarios to have the same value for 2015 inflow but with different monthly values). Surely these synthetic scenarios must satisfy some statistical metrics such as autocorrelation etc.

Does any one know of an existing code/script for this, preferably written in Excel, Python, or Matlab? I've heard of ARMA, KNN, etc. but none suits my purpose.

Thanks

Similar questions and discussions