|
<< Click to Display Table of Contents >> Navigation: Multi-case Editing > Grid Editor > Grid Editing Static Variables |
Navigation: Multi-case Editing > Grid Editor >
Use the Grid Editor to modify the Static Variables in a spreadsheet-like editor for more than one case at a time. This allows users to edit static variable values and add static variables to one or more cases.
To Open the Static Variables Table in Grid Editor
1.Go to the list of Forms and double-click on Grid Editor if it is not already open. 1.Select the cases to edit by dragging and dropping them from the Case List into the right section of the Grid Editor window. Select multiple cases by using Click+Shift, Click+CTRL, or by dragging over a grouping of cases set up in the sort order. The number of cases selected is shown with a case count on the top right. To remove one or more cases, hover over the case and click the 2.Under Available Edit Tables, select Static Variables. 3.Click Edit to open the Grid Editor table. 4.Make the appropriate changes and click Save to save the data and exit the Grid Editor. |
Columns in the Eco Options Table
These are the standard columns in the Static Variables table. Click on the icon on the top left •Case ID - The ID code that was created by PHDwin that ties each record to a case in PHDwin. New rows should be populated with the proper Case ID. •Case Name - The Case Name is presented to make it easy for users to identify the case, even though the Case ID is the value that is used so that the Grid Editor knows which case to add the record to. The case name is used for reference and is displayed so users can identify the case being edited. No changes to the case name will be saved in this table. •Fiscal Model - The name of the fiscal model applied to the case. A new models cannot be created here. •Variable - The name of the Static Variable for the selected regime. •Type - The type of static variable applied. It could be Date, Numeric, MultiSeg, or Model. •Sequence - Lists which segment of the Static Variable the value is for. The Sequence column lists the order of the segments of a Static Variable, if there are multiple segments to model a Static Variable that changes over time. For a single segment Static Variable, the value is 1. For multiple segment Static Variables, the value is 1 for the first segment, 2 for the second segment, and so on. •Value - The value of the Static Variable segment. View the corresponding start date and length of the segment in the next two columns. •Date - The date is only required for the first segment of the Static Variable. It can be populated with a hard-coded or linked date when the Static Variable begins. The length of each segment is set with the # of Months in the next column. Linked dates have to be formatted specifically. •Months - The number of months that the segment lasts. This must be populated for each segment of the Static Variable. To continue until the economic limit, input ECL. For the last value of the segment, this value will automatically be converted to ECL to continue the segment until the economic limit. |
Related Topics