- 1 Manage Country Data
- 2 Manage Groups/Regions
- 3 Change Country Subregionalization
- 4 Show Computed Functions
- 5 Rebuild Model Base
- 6 Model Integration
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:
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.
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:
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
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:
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.
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.
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:
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.
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.
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:
Toggle between the options at the top of the menu in order to change the data represented below.