Extended Features

Manage Country Data

To access the Manage Country Data sub-option, click on Extended Features on the Main Menu of IFs. There you will find two sub-sub-options:

• Edit Country Data
• Display Processed Data
• Historic Data File Processing

This feature of IFs allows users to alter the historic data that underlies IFs. It is suggested that only those with extensive experience using IFs attempt to change this data.

Edit Country Data

To access Edit Country Data, click on Extended Features on the Main Menu of IFs, and then select Manage Country Data.

Editing Initial Conditions for Countries: You may find that the data base for a country is less complete and/or accurate than you would like. You can fix most of that with the normal procedures for changing initial conditions and parameters.

IMAGE http://www.du.edu/ifs/help/use/extended/managecountry/editdata.html

The grid gives you the opportunity to go into all issue areas and all countries and change any values you wish of the raw data. To narrow down your selection, simply click on Please remember that, if you do so, you will need to rebuild the base case again (after indicating the issue area(s) in which you have changed data) and then rerun the model. Also please remember that any changes you make to the raw data are "permanent" and do not disappear after you exit IFs: the only ways to reverse them are to do so number-by-number or to reinstall IFs.

Display Processed Data

To access this feature of IFs, select Extended Features from the Main Menu and then Manage Country Data. Click on Display Processed Country Data.

By clicking on Display Processed Country Data, a window similar to the one below will appear:

IMAGE http://www.du.edu/ifs/help/use/extended/managecountry/processeddata.html

This allows you to view all of the data for each country that underlies the use of IFs. By toggling between the options at the top of the screen, Agriculture, Population, Economics, Social/Political and Energy, you are able to quickly find the variables you are looking for. By clicking Exit, your changes will be saved.

If you would like to incorporate data changes into your version of IFs, make any changes necessary and then Rebuild the Model Base and rerun the model.

Historic Data File Processing

To access Historic Data File Processing, click on Extended Features on the Main Menu of IFs, and then select Manage Country Data.

If you have reason to import large amounts of data into IFs, click on the Historic Data File Processing. This will then present you with three options:

• Importing Data from Excel Files
• Remove Years from Data
• Identify and Save Years

Importing Data from Excel Files

This feature of IFs can be found by selecting Extended Features from the Main Menu, Manage Country Data, Historic Data File Processing and then Import XLS Data.

When you choose to import large amounts of data into IFs via Excel, choose Import Data From XLS File. This will add an .xls access file to the historic data set for IFs.

Choosing this option will cause a window to appear that will look similarly to the one below:

Imagehttp://www.du.edu/ifs/help/use/extended/managecountry/historic/importing.html

Initially, it would be advised to change the Series Orientation function located on the right hand side of this menu. Identify how your data set is orientated and match that to one of the options. You will notice that the graph below changes to visually represent the specific data orientation that you choose.

After you have chosen the Series Orientation, click on the File option located at the top of the menu. You will then be prompted to select an Excel file. After you have made your selection, the file will be loaded into the Import Excel Data form. You will then be prompted to select certain Excel Sheets. These can be seen at the bottom of the Excel file after it is opened. They may have different names or simply be distinguished as "Sheet 1", "Sheet 2", etc. To see the Excel file you have selected, click on Viet Excel.

After you have selected your Excel file, you must further specify the orientation of the data so that IFs knows how to read the data after it has been imported. Fill in the Country Names Start at, Years Start at and Series Name Start at forms before proceeding. To finish the process, you must fill in some more specific information that will help IFs categorize your data. If you have questions, you can consult the Data Dictionary located in the lower-middle of the menu. When finished, click Import.

Other options include Scaling, which allows users to change their data set values by a multiplier. Finally, users are asked to specify a name for their Variable list as well as a brief description.

Remove Years from Data

This feature of IFs can be found by selecting Extended Features from the Main Menu, Manage Country Data, Historic Data File Processing and then Remove Data From Years.

This feature allows users to remove data for all years except for 5 year intervals.

Identify and Save Years

This feature of IFs can be found by selecting Extended Features from the Main Menu, Manage Country Data, Historic Data File Processing and then Identify and Save Years.

This feature allows users to identify and save data years if they have made any substantive change to the years in the raw data file. 

Manage Groups/Regions

To access Manage Groups/Countries/Regions, click on Extended Features on the Main Menu of IFs. There you will find three sub-sub-options: Identify Group or Country/Region Members, Change Grouping/Regionalization, and Display Regionally Aggregated Data.

This feature of IFs allows users to delve more deeply into the structure and membership of groups or Glists that are used in IFs. Users also can create their own groups or alter membership within an existing group to suit their purpose.

• Learn about how to see what countries are members of what groups.
• Learn how to change existing groups and create your own group.
• Learn how to display regional or group data sets.

Identify Groups/Regions

To identify regions or group members used in IFs, click on Extended Features on the Main Menu of IFs, and then select Manage Regionalization.

This feature of IFs allows users to identify which countries/regions are represented in certain groups. By clicking on this feature, you will be presented with a menu that looks similarly to the one below:

image http://www.du.edu/ifs/help/use/extended/manageregion/identify.html

By clicking on Switch to Groups, the list of countries/regions will become a list of groups. By clicking on any of the groups in the left-hand list, the members of that group will appear on the right hand side.

Change Grouping/Regionalization

To change countries in certain regions or groups, click on Extended Features on the Main Menu of IFs, and then select Manage Regionalization.

How do I change the geographic representations of IFs?

This is an advanced topic, and many users may wish to change or add Grouping designations to IFs for analysis purposes. However, before describing the processes, it is important to understand the geographic conceptualizations used in IFs. Learn more about the building blocks of IFs.

image http://www.du.edu/ifs/help/use/extended/manageregion/change.html

Changing or Adding Groupings. On the above form, choose the Switch to Groups option. The list box on the left displays the current Groups of IFs (yours may differ from the one above). The list box in the middle provides check boxes for all countries/regions in your version of IFs; it allows you to change the membership of the Groups in the left-most box. The list box on the right shows the full set of country/region members of whatever group you select in the left-most box. Select one of the groups in the left box by clicking on it; you should see changes in both of the other two boxes as they display the country/region membership of the group and, in the case of the middle box, give you the opportunity to change that membership.

Editing Membership in a Group. The menu options provide help editing groupings. Let’s try adding a member to an existing group. Click on the Group name in the left-hand list to activate it. You will see the group members on the right. Arbitrarily pick and country/region in the middle list that is not checked and check the box in front of its name. After you check it, note that the name is still not in the right-hand list. Now click on the Register Member Changes option from the menu. Note that the country/region is added immediately to the right-hand list. Your editing is complete. You could now exit the form and begin displaying results for the redefined group (or use the group as the basis for parameter change in scenario analysis). But instead, uncheck the box in front of the country/region name and again click on Register Member Changes. You will have undone your arbitrary change.

Adding a Group: Now let’s add a Group. Click on the Add Group option. The system will first confirm that you want to make such a change. Proceed. When asked for a name of the Group, provide that name if you have one in mind for a new group or type Test if you do not. After hitting the Enter key, you will see the new Group at the bottom of the left-hand list.

At this point the Group has been created, but has no members. With the name of the Group in the left-had box activated, select its members by activating the appropriate check-boxes in the middle column. When you have finished that, touch the Register Member Changes option. You will see the members of your Group pop up in the right-hand box.

You can now Exit from the form. You should see a message box that indicates no errors in what you have done. Then you will see a message indicating that your new group has been added to a file of IFs that maintains such groupings. That means that even when you stop the model and begin again later, the new Group will be defined. Go to one of the Display options and try to create a table for the new Group. It should work just like any other.

If you have created a Test group, however, you probably do not want it to always remain an option. So go back into Change Regionalization/Grouping, select the Test group in the left-hand window, and touch the Delete Group option. Again the program will ask for confirmation. Provide it and proceed.

There should be no limit on the number of Groups that you can designate in this way.

Display Regionally Aggregated Data

To display data that is regionally aggregated, click on Extended Features on the Main Menu of IFs, and then select Manage Regionalization.

This feature of IFs allows you to view data that is separated into economic, agricultural or energy sectors for specific countries. By selecting this feature, a window similar to the one below will appear:

http://www.du.edu/ifs/help/use/extended/manageregion/display.html image

Toggle between the options at the top of the menu in order to change the data represented below.

Change Country Subregionalization

Introduction to Sub-regionalization Procedures

Using IFs, the user will be able to not only display all variables for individual countries across time, but also examine their results as a product of larger groups or divide a country into sub-regions and study these regions separately. To learn how the processes work, it is important to understand the geographic representation used in IFs.

Image http://www.du.edu/ifs/help/use/extended/change/intro.html

There are 186 country-specific data sets in IFs and they form the foundation of the program. Groups are the collections of countries and regions organized geographically or by membership in international institutions/regimes. G-lists merge both groups and countries and are mostly geographically bound. The ability to split countries down into smaller regions, provinces or states is represented by the Regions module which is now under development.

The user can choose in which form to display their results. They can also examine the membership of each group, create new groups and add or delete members of an existing group. In particular, they can use the sub-regionalization feature of IFs to explore all variables of individual provinces within a country or a region. This section will primarily introduce the management of sub-regionalization. By learning the process, users can delve deeper into the analysis of any particular country by creating its sub-regions and investigating the variables of individual regions. 

Foundation for the Process: Database Modification

Before a country in IFs can be divided into states or provinces, a new data file called IFsHistSeriesxxx.mdb, for example IFsHistSeriesChina.mdb, must be created for the country. That file is a variation of the country-based file called IFsHistSeries.mdb with data series tables for all countries across time for all variables. In addition, some tables that exist in the file Provinces.mdb on the IFs\Data directory require modifications to initiate the sub-regionalization process.

The process of sub-regionalization actually affects five files: IFs.mdb, IFsHistSeries.mdb, IFsCoVatra.mdb, IFsCoVatraSeries.mdb, and IFsWVSCohort.mdb. For each of the files, the process looks in the IFs\Data folder for an equivalent file with the name of the country at the end, for example IFsHistSeriesChina.mdb, then creates a copy to the IFs\Runfiles directory. Modification is done in the copies on the \Runfiles directory as well to the original files in the \Data directory. Data for both individual provinces and the country as a whole are preserved, and can be copied back and forth between \Data and \Runfiles directories, so the user will be able to switch between model runs with different sub-regionalizations, and reset everything to the starting point without states/provinces.