InterpolateP

Pattern. Pattern variable, on which the interpolation is based. It must contain output frequency.

PatternType. Pattern type, on which the interpolation is based. Optional parameter. By default the parameter is set to MsPatternType.Average - average by elements.

Period. Period, at which the method is calculated. Optional parameter. By default the parameter is set to Null, the method is calculated at the entire time period.

Description

Comments

On data disaggregation the following calendar frequency settings are taken into account: start period offset relative to its start/end.

The period under consideration: first two weeks of May 2012.

Interpolation method: equal.

Calendar frequency settings: input variable contains weekly and daily frequencies; week start offset is not used; daily frequency contains days from Monday to Friday. Disaggregation result:

Week	Period start date	Day of the week	Initial value	Calculated value
1st week	May 7 2012	Monday	1
	May 7 2012	Monday		0.20
	May 8 2012	Tuesday		0.20
	May 9 2012	Wednesday		0.20
	May 10 2012	Thursday		0.20
	May 11 2012	Friday		0.20
2nd week	May 14 2012	Monday	2
	May 14 2012	Monday		0.40
	May 15 2012	Tuesday		0.40
	May 16 2012	Wednesday		0.40
	May 17 2012	Thursday		0.40
	May 18 2012	Friday		0.40

Calendar frequency settings: input variable contains weekly and daily frequencies; week start is offset on 3 days forward; daily frequency contains days from Monday to Friday. Disaggregation result:

Week	Period start date	Day of the week	Initial value	Calculated value
1st week	May 2 2012	Wednesday	1
	May 2 2012	Wednesday		0.20
	May 3 2012	Thursday		0.20
	May 4 2012	Friday		0.20
	May 7 2012	Monday		0.20
	May 8 2012	Tuesday		0.20
2nd week	May 9 2012	Wednesday	2
	May 9 2012	Wednesday		0.40
	May 10 2012	Thursday		0.40
	May 11 2012	Friday		0.40
	May 14 2012	Monday		0.40
	May 15 2012	Tuesday		0.40

Formula	Result	Application
= InterpolateP({Brazil\|BCA[t]}, MsFrequency.Quarterly, {China\|BCA[t]})	The Brazil\|BCA series data will be disaggregated to quarter frequency by template set by the China\|BCA series for the whole time period.	It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container.
= InterpolateP(X1, MsFrequency.Monthly, X2, MsPatternType.Last, SetPeriod("01.01.2000","01.01.2015"))	The X1 factor data will be disaggregated to monthly frequency by the last template element set by the X2 factor for the period from 2000 to 2015.	It is used in model variable-based formulas of modeling container.

InterpolateP

Syntax

Parameters

Description

Comments

Example