Catur Kurniadi 3/2/2011

Like

2086 Views

Dear,

Is it in multi regions analysis the expression can related between one region with others region. For example in Indonesia, Indonesia consist of many regions. and i want to put regional GDP expression that affected by Indonesia GDP, how to make that expression?

Tory Clark 3/2/2011
 

Like

2085 Views

Hi Catur,

It sounds like you want to have a key assumption for total GDP and then key assumptions for shares of GDP for each region.

To tie that into regional analysis, I recommend that you create one overarching template region with all of the data that is true for all regions (e.g. gdp key assumptions). Then you can have all regions inherit from the template region, keeping you from having to enter that data in for each region.

An example of this is below. Assuming you want the activity level for the industrial demand sector to be based on regional GDP, here is what your equation would look like:

For Region 1
key\Total GDP[Million USD]*key\Region 1 GDP[% Share]

For Region 2
key\Total GDP[Million USD]*key\Region 2 GDP[% Share]

etc.

Hope that helps,

Tory