Home

ANSWERv6-TIMES Smart Excel Workbook - Noble

1. ust Include BD Select from Database Select from ITEMS Sheet Limit Set Memberships Restrictions for ACT BND M Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 38 Se ect ram ITEMS Sheet When the Select Limit form appears the option button is disabled the Select from Database option button is on and the form displays the predefined members of the Limit Component that are stored in the ANSWER TIMES database and that are appropriate for the ACT BND Parameter e The Limit Component in TIMES comprises NB non binding as well as FX LO UP but NB is not displayed because only FX LO UP are appropriate for the ACT BND Parameter B 3 Check Sheet Checking for a Data Parameter On each of the worksheets used for specifying Data Parameters the Check sheet button may be clicked at any time to have a standard set of consistency and guality control checks performed The checking that is carried out includes checking that e Each Parameter that is specified is a valid Data Parameter e Fora valid Data Parameter each of its Arguments occurring in the Argi to Arg6 columns columns C through H or columns D through I for a TRADE sheet is valid This means that Arguments must occur on either the ITEMS sheet or in the associated database and must be of the correct Component So for example when checking an instance
2. al TE bilion passenger kilometres bri p k m bilion tonne kilometres annum br t k rm a billion tonne kilometres bn t krn n 7 billion vehicle kilormetres Ev km milion tonnes rt milion tonnes annum mta petajoules PJ petajoules anmum Pal pid RID terajoulesrannum TJ terrajoules TJ thousand tonnes annum ET al thousand tonnes E T unit of volume for MYOs annum uvala tonnes t ow EY unit of weight for MMT sZannum ta unit of volume for MU z real unit of weight for MYT z Lit And if you click on the 0 SetmMembersh pe button when the cursor is positioned in column F for a row in which the Component in column B is T Process the form shown below will be displayed allowing you to specify the Set Memberships that apply for the Process the form is shown after you have selected ELE Day Night Time Slice Level Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERvV6 TIMES Smart Excel Workbook Manual version 6 7 10 Specify Process Set MemberShips To specify Set Memberships click on the appropriate leaf node in the LHS treeview adjust the RHS Additional Characternzation as necessary and then click on the OF button Set Memberships 1 Process PAC ES Combined Heat k Power CHP Annual Time Slice Level E Demand Device DMD Seasonal Time Slice Level B Electric Generation ELE a B Energy PRE E37 Heat Generation HPL B Material by
3. 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 11 6 Time Series Data TS DATA Sheet The TS DATA sheet is where Time Series Data Parameters are specified An example of a TS DATA sheet is shown below a ES ea EL V Z O PR Re A V O AE TES TS DATA DEMO UTOPIA Check Sheet Parameter Argi Arg Arg3 Argt Arg5 Arg LE Opt 6 Parameter Argi Arg2 Arg3 Arg4 Arg5 Arg6 LE Opt EE 9 TS DATA for DEMO UTOPIA regions DEMO UTOPIA ACT COST E01 0 0 3 0 3 0 3 ACT_COST E21 p 2 M p 0 1 5 1 5 15 ACT_COST E41 0 0 4 0 4 0 4 ACT_COST E70 3 0 0 4 0 4 0 4 ACT_COST SRE 0 10 10 10 CAP BND E31 g g LO 0 0 13 0 13 0 13 CAP_BND E31 UP 0 0 13 0 17 0 21 CAP BND E51 UP 0 3 3 3 CAP BND E52 i z LO 0 0 13 0 13 0 13 CAP_BND E52 UP 0 0 13 047 0 21 CAP BND SRE LO 0 01 0 0 CAP BND TXE UP 0 null 4 10 COM_FR RL FAD 0 0 2 0 2 0 2 COM_FR RL a FAN g 0 0 05 0 05 0 05 COM FR RL SPD 0 0 12 0 12 0 12 COM FR RL g SPN 0 0 08 0 08 0 08 COM FR RL SUD 0 01 0 1 0 1 COM_FR RL SUN 0 0 03 0 03 0 03 COM_FR 2 RL VID 0 0 3 0 3 0 3 COM FR RL a WIN 0 0 12 0 12 0 12 COM IE DSL ANNUAL 0 1 1 1 COM IE ELC p ANNUAL 0 1 1 1 COM IE GSL ANNUAL 0 1 1 1 COM IE HCO g ANNUAL 0 1 1 1 COM JE HYD ANNUAL 0 1 1 1 COM JE OIL ANNUAL 0 1 1 1 COM IE URN ANNUAL 0 1 1 1
4. Excel Workbook Manual version 6 7 23 smart worksheets it would be possible to use single TS amp TID DATA and TS amp TID TRADE worksheets so 2 data worksheets replacing 9 data worksheets while retaining the single REGIONS and ITEMS worksheets exactly as they are e There are aspects of the ITEMS sheet that you may find beneficial to often emulate in the ITEMS sheets of your ANSWER TIMES Smart Excel Workbooks Note that when you first create an ITEMS sheet the following rows are automatically generated but the cell A10 will initially be blank and you must enter into cell A10 a comma delimited list of the internal regions for your model Comp Hame Description Unit s Set Memberships Er Pre defined Commodity Groups cell A10 should contain comma delimited list of all Internal Regions REG REG2 REGS D ACTGRP Activity related Group COM_GRP COM_GRPDEF D DEM Demand Commodity Type COM_GRP COM_GRPDEF D EN Environmental Commodity Type COM_GRP COM_GRPDEF D FI Financial Commodity Type COM GRP COM GEPDEF D MAT Material Commodity Type COM _ GRP COM GEPDEF D NRG Energy Commodity Type COM_GRP COM_GRPDEF These rows specifying pre defined Commodity Groups are necessary to ensure that you can specify data parameters that require pre defined Commodity Groups as arguments and for the correct functioning of Check Sheet So you should always retain them Note also that in ANSWER TIMES all TimeSlices must be specified for the
5. _GLOBAL region and for every Internal region Using inheritance of the comma delimited list of region names in cell A18 allows this specification to be made very compactly on rows 18 to 30 e The GlobalTab Data sheet demonstrates how to specify Global Tab data that is not TimeSlice related You may find it beneficial to often have such a sheet in your ANSWER TIMES Excel Workbook What differentiates Global Tab parameters G_DYEAR and G_DRATE from most other parameters is that their definition does not rely on user defined Items The GlobalTab Data sheet also demonstrates both of the new enhancements the new TS amp TID DATA sheet is used with a comma delimited list of region names in cell B1 and with column A used to specify that G_DYEAR should be created for the GLOBAL region only and that G_DRATE should be created for regions REG1 REG2 RE GS only e The TimeSlice Data sheet provides another illustration of the use in column A of a comma delimited list of region names once a region list is specified in column A there is inheritance of this region list to Successive rows in the sheet until such time as anew region list is specified in column A So for rows 11 to 21 by inheritance from row 10 the GLOBAL region applies It is not necessary to have an explicit _GLOBAL in each of cells A11 to A21 Then for rows 25 to 48 by inheritance from row 24 the region list REG1 REG2 REG38 applies It is not necessary to have an explicit REG1 REG2 R
6. mdb CLAN SWER TIMES SMART LS ANSWER TIMES ver66el5 Library testing Example4 v668 Library rr Cancel You should always specify an ANSWER TIMES database because the operation of nearly all of the smart buttons in the ANSWER TIMES workbook requires that you do Once you have used an ANSWER TIMES smart workbook to load information into an ANSWER TIMES database then to derive maximum benefit from the facilities offered by an ANSWER TIMES smart workbook you should specify this ANSWER TIMES database or a copy of it as the associated database when you subsequently load further information into this database from an ANSWER TIMES smart workbook e This is because an ANSWER TIMES smart workbook offers an important new facility not available in an ANSWER MARKAL smart workbook the ability to access Item information that is in the associated database as well as in the ITEMS sheet So for example the Check Sheet button on a TS DATA sheet checks arguments for Time Series Parameters against both Items on the ITEMS sheet and tems in the database Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERvV6 TIMES Smart Excel Workbook Manual version 6 7 4 3 Worksheet Layout and Philosophy This section briefly indicates each of the eight types of smart worksheets currently available in an ANSWER TIMES Smart Excel Workbook as presented in Table 1 They are segregated into two types Decl
7. 1 Role and Operation of smart buttons on ANSWER TIMES Smart Worksheets There are a number of smart buttons on each of the ANSWER TIMES worksheets You can use these buttons to assist in the correct specification of e Set Memberships on the REGIONS sheet Component Unit s and Set Memberships on the ITEMS sheet e Parameter and Parameter Arguments Arg1 Arg2 Arg6 on each of the 6 types of Data sheet and also I E Opt code on the 4 types of Data sheet where Time Series parameters may be specified The operation of these buttons is context sensitive that is you must first position the cursor in the appropriate cell the active cell below the column in which the smart button appears and then click on the smart button to bring up a form that most often allows you to select from a list of possibilities e g from a list of Parameters Processes Commodities etc When you exit the form your selection will be transferred into the active cell in violet But you should also note that use of these smart buttons is entirely at your discretion So for example on a Data sheet if you know the name of the TIMES Parameter that you want to insert in a row and you also know the names of the Items that comprise this Parameter s Arguments then you can directly enter the Parameter and its Arguments into the desired row on the Data sheet with no need to make use of the Parameter Arg1 Arg2 Arg6 smart butt
8. Description Filter Like Apply Filter No Regions sd Description CCCs Memberships DEMO UTOPIA Bilateral Trade in Electricity PRC ELE DAYNITE IRE DEMO UTOPIA Coal Steam Electric PRC ELE DAYNITE DEMO UTOPIA LWR Nuclear Plant PRC ELE SEASON DEMO UTOPIA Hydro electric Plant PRC ELE DAYNITE DEMO UTOPIA Natural gas combined cycle plant PRC ELE DAYNITE DEMO UTOPIA Pumped Storage Power Plant PRC ELE STGTS5 DAYNITE DEMO UTOPIA Hydro electric Plant 2 renewable PRC ELE DAYNITE PRC ELE DAYNITE BITRADE ELC E01 E21 E31 E41 E51 E52 E70 ID1 IMPDSL1 IMPGAS1 IMPGSL1 IMPHCO1 IMPOILI IMPURN1 DEMO UTOPIA Oil Plant DEMO UTOPIA DEMO UTOPIA IMPEXP DEMO UTOPIA IMPEXP DEMO UTOPIA IMPEXP DEMO UTOPIA IMPEXP DEMO UTOPIA IMPEXP DEMO UTOPIA IMPEXP DEMO UTOPIA DEMO UTOPIA Coal Boiler Process Heat Import of Diesel Import of Uranium Import of Gasoline Import of Hard Coal Import of Crude Import of Uranium Electric Boiler Gas oil Boiler PRC DMD ANNUAL PRC PRE ANNUAL IRE PRC PRE ANNUAL IRE PRC PRE ANNUAL IRE PRC PRE ANNUAL IRE PRC PRE ANNUAL IRE PRC PRE ANNUAL IRE PRC DMD DAYNITE PRC DMD ANNUAL VN MO U U U U U NI NNN NN DH EH M DFMO LITOPTA Diesel Roiler PRO DM DAYNITE Select from ITEMS Sheet Process Set Memberships Restrictions for ACT BND Select from Database Select from ITEMS Sheet Select from Database An important
9. ETL ETL SEG Number of segments For cumulative cost curve TID ETL ETL TEG Indicates process For which learning curve is specified Set TID ETL E _ m nina m PPT EE A EA TT Only TID Parameters Specify Param Specify Param Y Parameters Shown Excluded And args Preserve args Cancel ka Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 14 Specify Param Select the desired TID Parameter and normally click on the Ea wa button Then use the oan through to jal buttons as appropriate to specify the Arguments for the selected Parameter followed by specification of the Parameter s numeric value See Appendixes B 1 and B 2 respectively for details regarding the operation of the Parameter selection form and for details regarding the operation of the Item selection form that is displayed when you click on any of the a through to Aras buttons to specify the Arguments for the selected Parameter The Check sheet button may be pressed at any time to have a standard set of consistency and quality control checks performed See Appendix B 3 for details regarding the checking that is carried out for a Data Parameter The results of the checking are presented in a Wordpad file as shown below and any offending cells are highlighted on the sheet in yellow along with a cell comment indicating the nature of the problem EJ CheckSummary Log WordPad ZBR Fi
10. GI OF CD RO Commodity tems for DEMO UTOPIA regions 33 DEMO UTOPIA n E coz E ELC HYD mom omom om a E DEMO UTOPIA IMPEXP E DSL m omom omom I O URN DEMO UTOPIA D E41 OUT D RHG IN D SRE G Process Items for DEMO UTOPIA regions DEMO UTOPIA T T E01 T E21 1 01 OF 071 OF OF OF 0 U t t tal Fal GD GD GG U J 54 GI OF tal GO DI gt CO w GI OT al G3 DD CO CO CO 4 GI O gt A B C GLOBAL DEMO UTOPIA IMPEXP MINRNVY Description Activity related Group Demand Commodity Type Environmental Commodity Type Financial Commodity Type Material Commodity Type Energy Commodity Type TimeSlice tems for GLOBAL DEMO UTOPIA regions Annual Fall Fall Day Fall Night Spring Spring Day Spring Night Summer Summer Day Summer Might Winter Winter Day Winter Night Carbon Dioxide Electricity Hydro Power Industrial Heating Residential Space Heating Residential Lighting Automobile Transportation Diesel GAS Gasoline Coal Oil Natural Uranium Commodity Group Items for DEMO UTOPIA regions E41_OUT RHG_IN PCG for SRE G Oil Refinery BITRADE ELC Bilateral Trade in Electricity Coal Steam Electric OAR Nuclear Plant PJ GW PJ GW PJ GW Rm a a E Unit s Set Memberships Unit s Set Memberships Comment Pre defined Commodity Groups cell A10 should contain comma delimited list of all Internal Regions COM_GRP
11. IMPEXP REGJ TOP_IRE IMFILT OIL OIL 1 30 IMPEXP REGJ TOP_IRE IMPURNA URN URN 1 21 To specify a Time Independent Trade Data Parameter select an empty row below row 7 and enter the regions involved in the trade in the Region and Region2 columns columns A B of this row Then position the cursor in column C of this row and press the Parameter smart button This brings up a TID Trade Data Parameter selection list as shown below Select TID Trade Parameter Name will be transferred to ActiveLell Sets Filter All Data Parameters TS TID Global Set Memberships H IRE CEVT Commodity unit conversion Factor between regions IRE_TSC T Identification and T5 conversion factor between regions TOP_IRE Trade within area of study Set Only TI ly TID F t Specify Param Specify Param nly arameters Parameters Shown Excluded ene Soe Spagenus SEE Cancel Specify Param Select the desired TID Trade Parameter and normally click on the eee wa button Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERVv6 TIMES Smart Excel Workbook Manual version 6 7 19 Then use the oan through to oas buttons as appropriate to specify the Arguments for the selected Parameter followed by specification of the Parameter s numeric value See Appendixes B 1 and B 2 respectively for details regarding the operation of the Parameter selection form and for details regarding the operation of the It
12. Lists 111 column 1 region region lists are OE Check Rows specifying TS TID DATA Parameter instances All of the Rows specifying Parameter instances are OF For Help press Fl Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 13 7 Time Independent Data TID DATA The TID DATA sheet is where Time Independent Data Parameters are specified An example of a TID DATA sheet is shown below O ee TID DATA DEMO UTOPIA 2 3 Check Sheet s Parameter Aral Arg Arg ArH Argi Arg b 7 Parameter Argi Arq Arag3 Arg4 Arg Arg Value O 9 TID DATA for DEMO UTOPIA regions 10 DEME UTOPIA COM GMAF i CO2 Eh a g 1 11 OM GMAP i DSL NRG z S 1 1 OM GMAP DSL RHG IN a 1 13 OM GMAP DSL SRE G E 1 IE COM_GMAP ELC E41 OUT 1 15 COM_GMAP ELC NRG 1 16 COM _ GMAP GAS NRG z z 1 17 OM GMAP s GAS RHG IN 1 16 COM _GMAP GSL NRG S 1 19 OM GMAP A GSL SRE G z 1 20 OM GMAP 2 HEO NRG z 1 z COM_GMAP HYD MRG 1 Ze COM_GMAP GIL NRG g 3 1 2 OM GMAP 2 RH DEM z 1 24 COM GMAP RH E41 OUT 1 25 COM GMAP RL DEM 4 s 2 1 26 COM _GMAP TX DEM A 1 Zt COM_GMAP URM NRG 1 a COM PEAK p ELE s 1 a 5 YRFR a z E ANNUAL 1 30 G_YRFR g a FA 0 25 3 G_YRFR S z f FAD a 0167 32 3 YRFR A 3 i FAN 0 083 J3 G_YRFR z 2 SP 0 25 a4 G_YRFR SPD 0 167 35 G_Y
13. Parameter Selection Form has been invoked from the TS DATA or TID DATA or TS amp TID DATA worksheets e When the ANSWER TIMES database that is associated with the workbook is version 6 7 2 or higher it will often be beneficial to choose the second setting for the combobox All Data Parameters Excluding Parameters for TIMES Extensions so that Parameters that are displayed in the selection list are confined to standard TIMES TS Data Parameters select Ts Parameter Name will be transferred to ActiveCell Sets Filter All Gata Parameters Mame All Dakta Parameters Excluding Parameters For TIMES Extensions ACT BNO Climate Data Parameters k J Damage Data Parameters tate a Discrete Capacity Investment Data Parameters ACT_LEFF Elastic Demand Data Parameters CAP BNO Endogenous Technology Learning ETL Data Parameters CM Exon FI BOH and Time Stepped Data Parameters _ Specify Params buttons Specify Param Two buttons are provided to the left of the button a ial a button and a Specify Param Preserve 4rgs 3 button Specify Param e The led 3 button is used when initially specifying a Parameter instance because it indicates the nature and positions of the Arguments that must be specified for the selected Parameter See the example for the ACT BND Parameter presented above Specify Param e The aoe button the one immediately to the left of the f te button can be useful if you have
14. Parameter Selection Form is described with reference to the Parameter Selection Form as it is displayed when invoked from the TS DATA worksheet Select TS Parameter Name will be transferred to ActiveCell EHEACT BEN Bound on activity of a process EJ ACT COST Variable costs associated with activity of a process ALT EFF Activity efficiency For a process TAP BND Bound on total installed capacity in a period TM EXOFORIC Radiative Forcing From exogenous sources GLOBAL Climate CM_LINFOR Linearized Forcing Function parameter GLOBAL Climate CM Mag Maximum allowable climatic quantity GLOBAL Climate COM _ AGG Commodity aggregation parameter TOM BNDNET Net bound on commodity fe g emissions T M BNDPRO Limit on production of a commodity COM CSTNET Cost on het of commodity fe a emissions bax COM CSTPRE Cost on production of a commodity COM ELAST Elasticity of demand Elastic Demand COM ELASTS Elasticity shape of demand Elastic Demand COM FR Seasonal distribution of a commodity COM IE Seasonal efficiency of a commodity COM PKFLX Peaking flux ratio COM PERSY Peaking reserve margin COM PRO Demand baseline projection TOM SUBNET Subsidy on a commodity net COM _SUBPRD H on i gape A a commodity net hk mR TLI bas ont co hee Only TS Parameters Parameters Shown Excluded specify Param specify Param Cancel a 4nd 4rgs Preserve rgs As has already been explained on the previous page the basic operation of this form is as
15. Region Parameter Argi Arg Arg3 Arg4 Arg Arg LE Opt IRE PRICE IMPURA URM ANNUAL IMF 0 Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 18 10 Time Independent Trade Data TID TRADE Sheet The TID TRADE sheet is where Time Independent Trade Data Parameters are specified These are TID Parameters that have two region indexes An example of a TID TRADE sheet is shown below ety eee Sa Sea eis SS SIA SES ee TID TRADE 1 GLOBAL REG REG REGS IMPEXP hl Check Sheet Parameter Aral Arg Arg Arg Arg Arg Region Region Parameter Argi Arg Arg Arad Arg Arg Value 4 On TID TRADE sheet a single region must be specified in column A a comma separated region list is not allowed IMPEXP REG TOP_IRE IMPDSL1 DSL z DSL 1 12 IMPEXP RE TOP_IRE MPsAS1 GAS GAS 1 13 IMPEXP REG TOP_IRE IMPtSSL1 GSL GSL 1 REG TOP_IRE IMPHOO1 HEO HCO 1 REG TOP IRE IkAPOIL OIL OIL 1 REG TOP IRE IMPOR URN URN 1 REG TOP_IRE IMPOSL1 DSL DSL 1 REG TOP_IRE MPSAS1 GAS GAS 1 REG TOP_IRE IMPtSsSL1 GEL GSL 1 21 REG TOP_IRE MPH HEO HCO 1 22 IMPEXP REG TOP_IRE IMPIL4 OIL OIL 1 IMPEXP REG TOP_IRE IMPURMT URN URN 1 2a 25 IMPFEXP REGJ TOF_IRE IMPDSL1 DSL DSL 1 26 IMPEXP REGS TOP_IRE MPsAS1 GAS GAS 1 2 IMPEXP REGJ TOP_IRE MPSS GEL GSL 1 IMPEXP REGS TOP_IRE IMPHCO1 HEG p Hoo 1 29
16. Specifying Parameter Arguments for Items that cannot occur on the ITEMS sheet We have seen in section 5 that only Items under user control TimeSlices Commodities Commodity Groups Processes and Constraints can be specified on the ITEMS sheet For all such Items the operation of the Parameter Argument Item Selection form mimicks that of the Process Selection Form described above e In particular the user will be able to select such Items as Arguments from either the ITEMS sheet or the associated ANSWER TIMES database Where a TIMES Data Parameter has as an argument a Component Item that cannot occur on the ITEMS sheet an Argument Item Selection form is still displayed when the user clicks on Arg the appropriate button from among the id through to dhe buttons but the user will be able to select such Items as Arguments only from predefined Items in the associated ANSWER TIMES database An example of such a Component is the Limit Component which we previously saw was in the Arg6 position for the ACT_BND parameter To specify the Limit position the cursor in cell H59 and click on the Aras smart button to bring up the Select Limit form Select Limit Name will be transferred to Active Cell Sets Fiter ints 0 r Name and Description Filter Name Filter Like sip COR Description Filter Like Apply Filter Name No Rei Description Set Memberships SEF 1 Fixed LIM BD LIM BD LIM BD
17. Systems Pty Ltd 2005 11 October 2011 ANSWERvV6 TIMES Smart Excel Workbook Manual version 6 7 2 Acknowledgements Aspects of the development of the ANSWER TIMES Smart Excel Workbooks and the creation of this Manual were assisted by the existence of the ANSWER MARKAL Smart Load Templates and Manual The latter were the result of a collaborative effort in 2006 between Gary Goldstein of DecisionWare and Noble Soft Systems But the reader of this Manual who is familiar with the ANSWER MARKAL Smart Load Templates will soon realize that in important respects the ANSWER TIMES Smart Excel Workbooks differ significantly from the ANSWER MARKAL Smart Load Templates In particular the format and operation of the ANSWER TIMES Smart worksheets differ significantly from those of ANSWER MARKAL The development of the ANSWER TIMES Smart Excel Workbooks has benefited from suggestions made by Dr Uwe Remme of the International Energy Agency Some financial support was provided by ETSAP and also by the International Energy Agency the latter in the context of a larger project to create a special Library Region version of ANSWER TIMES for the TIMES version of the IEA s Energy Technology Perspectives ETP Model 1 Background The task of assembling data for a TIMES model requires various data preparation steps that are usually performed using the power and flexibility of soreadsheets Excel New ANSW
18. already specified a Parameter instance including its Arguments and subsequently realize that you got the Parameter Name wrong but that the correct Parameter Name has exactly the same Arguments as those for the wrong Parameter Name Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 35 B 2 Operation of the Parameter Argument Item Selection Form displayed after clicking on Arg1 Arg6 buttons For each of the worksheets used for specifying Data Parameters the Parameter Argument Item Selection Form that is displayed after clicking on any of the oan through to Arg6 l buttons is extremely similar as is the operation of the Form Here the operation of the Parameter Argument Item Selection Form is described with reference to the Select Process Form for the ACT_BND example from Appendix B 1 O Ely Se O ee A TS DATA a Check Sheet REG1 REG REGS Parameter Aragi Arg Arg Arg Arg Arg VE opt Parameter Argi Arg Arg Arg4 Arg gt Arg LE Opt ect ANO Process 3 Time Slice Lirnit 0 i clen CH E i 5 EREBE To specify the Process position the cursor in cell C59 and click on the oan smart button This brings up the Select Process form as shown below Select Process Name will be transferred to Active Gell Sets Filter All Processes PRC Name and Description Filter Name Filter Like AND OR
19. are specified See section 10 Time Series and Data TS amp TID TRADE TIMES Time Series amp Time Independent Time Independent Data Parameters that have two region Bilateral Trade indexes are specified Data See section 11 NOTES 1 Only one REGIONS sheet may be included in a workbook 2 Only one ITEMS sheet may be included in a workbook 3 Any number of each type of Data sheet is permitted 4 Version 6 7 does not handle the TIMES Stochastic Extension and hence does not allow Stochastic Items to be declared on the ITEMS sheet nor does it allow Stochastic Time Series amp Time Independent Data to be specified on the TS DATA TID DATA TS amp TID DATA sheets The name given to each worksheet is up to the user although the ANSWER TIMES Indicators in cell A1 must match those in Table 1 In addition a workbook may contain as Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERVG TIMES Smart Excel Workbook Manual version 6 7 5 many other sheets as desired but the user is encouraged to leave cell A1 the ANSWER TIMES Indicator cell blank Each of the ANSWER TIMES smart worksheets is governed by a few formatting guidelines requirements and has a fairly rigid format The top 7 rows of each sheet comprise the smart buttons and header area These rows are non scrollable A row will be ignored if the first character of the cell in column A contains an or if the row is completely blank 3
20. args Cancel Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 12 Specify Param Select the desired TS Parameter and normally click on the eal wa button Then use the oan through to ags buttons and the VE ops button as appropriate to specify the Arguments and the I E Opt code for the selected Parameter followed by specification of the Parameter s numeric values See Appendixes B 1 and B 2 respectively for details regarding the operation of the Parameter selection form and for details regarding the operation of the Item selection form that is displayed when you click on any of the ssl through to Aras buttons to specify the Arguments for the selected Parameter The Check sheet button may be pressed at any time to have a standard set of consistency and guality control checks performed See Appendix B 3 for details regarding the checking that is carried out for a Data Parameter The results of the checking are presented in a Wordpad file as shown below and any offending cells are highlighted on the sheet in yellow along with a cell comment indicating the nature of the problem CheckSummary Log WordPad Cae Gla A ther Bb Burmary Log File created on Friday 14 October 2011 at 05 31 PH CHECK TS DATA SHEET TS DATA DEMO UTOPIA Check Cell Bl Region Region List The Region Fegion List in cell Bl is OE Check Colum amp Regions Region
21. feature of the form is the pair of option buttons at the bottom left of the form that allow the user to choose whether the form displays e Processes that are specified on the ITEMS sheet when the Select from ITEMS Sheet option button is on the default or e Processes that are specified in the associated ANSWER TIMES database the database that you specified when you opened the smart workbook when the RE A yee rs aor option button is on Another useful feature of the form is the availability at the top of the form of a Sets Filter and a Name and Description Filter Particularly for large models the user may find either or both of these filters beneficial in reducing the number of Process Items that are displayed Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 36 and thereby expediting the selection of the Process Item of interest This pair of Filters may be used for either of the Tissier SC mie option button settings Sets Filter Name and Description Filter The Sets Filter combobox allows the user to filter the Processes that are displayed to those that have particular Set Memberships for example to those that are Electric Generation Processes ELE Select Process Name will be transferred to Active Cell Sets Filter All Processes PRC Name and all Processes PRC WNUAL Processes Annual Time Slice Level Name fw CHP Co
22. follows e Select the Parameter of interest Specify Param e Click on the _ button thereby exiting the Parameter Selection Form and causing the Parameter Name and the nature and positions of its Arguments to be written to the Parameter and Arg1 Arg6 columns of the row where the cursor was Parameter positioned when the button was clicked For example if the cursor is placed in row 59 so at cell B59 and ACT BND is the selected Specify Param Parameter then after clicking on the 7 a ae ee B it SS eee Se a ee ae TS DATA REG REG REGS een Check Sheet Parameter Aragi Arg Arg Arg Arg Arg VE opt Parameter Argi Arg Arg Arg4 Arg gt Arg LE Opt ect ANO Process s a 3 Time Slice Limit 0 button row 59 will appear as follows l 1 CI E EREBE Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 34 This indicates that the ACT BND Parameter must have Process TimeSlice and Limit Arguments in positions 1 5 and 6 respectively and with the place holder of minus in positions 2 3 4 Sets Filter combobox to expedite selection of Parameter of interest The Sets Filter combobox at the top of the form allows the user to reduce the number of Parameters that are displayed in the selection list and thereby to expedite the selection of the Parameter of interest e Use of the Sets Filter combobox may be beneficial when the
23. specified in column A a comma separated region list is not allowed o 41 w 111 IMPEXP REG1 TOP_IRE IMPDSL1 DSL R p p DSL 12 IMPEXP REG1 TOP_IRE IMPGAS1 GAS GAS 13 IMPEXP REG1 TOP_IRE IMPGSL1 GSL R GSL 14 IMPEXP REG1 TOP_IRE IMPHCO1 HCO A i A HCO 115 IMPEXP REG1 TOP_IRE IMPOIL1 OIL z i OIL 7 REG1 TOP_IRE IMPURN1 URN z B URN 17 TO 18 REG1 IMPEXP IRE_PRICE IMPDSL1 DSL ANNUAL IMP 0 10 10 10 19 REG1 IMPEXP IRE PRICE IMPGAS1 GAS ANNUAL IMP 0 6 4 6 4 6 4 20 REG1 IMPEXP IRE_PRICE IMPGSL1 GSL ANNUAL IMP 0 15 15 15 IMPEXP IRE PRICE IMPHCO1 HCO ANNUAL IMP 0 2 2 2 IMPEXP IRE PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 IMPEXP IRE PRICE IMPURN1 URN ANNUAL IMP 0 2 2 2 25 IMPEXP REG2 TOP IRE IMPDSL1 DSL DSL 1 26 IMPEXP REG2 TOP_IRE IMPGAS1 GAS B p GAS 1 27 IMPEXP REG2 TOP_IRE IMPGSL1 GSL R z GSL 1 28 IMPEXP REG2 TOP_IRE IMPHCO1 HCO p gt HCO 1 29 IMPEXP REG2 TOP_IRE MPOLI OIL a OIL 1 ae REG2 TOP_IRE IMPURN1 URN R URN 1 sil 32 REG2 IMPEXP IRE PRICE IMPDSL1 DSL ANNUAL IMP gt 0 10 10 10 33 REG2 IMPEXP IRE_PRICE IMPGAS1 GAS ANNUAL l IMP 0 6 4 6 4 6 4 To specify a Time Series or Time Independent Trade Data Parameter select an empty row below 7 and enter the regions involved in the trade in the Region and Region2 columns of this row Then position the cursor in column C of this row and press the CAERE sma
24. the file ANSWER TIMESver6 XLS distributed by Noble Soft for example open ANSWER TIMESver6 7 XLS Then select Enable Macros to bring up the single visible sheet of ANSWER TIMESver6 7 XLS as follows EJ Microsoft Excel ANSWER TIMESver6 7 xls FIEL fel File Edit view Insert Format Tools Data Window Help Adobe PDF f X TEREA RETE A A A 9 Z 100 deore c All 2 fe AMS 7 Home E eee JANSv6 7 Home Create New ANSWER Smart XLS Version Update XLS to ANSWER Smart XLS Version 6 7 Single reqion gt Multi region no common naming across regions Multi region common naming across regions Add New ANSWER TIMES Smart Sheet to Current XLS TE a1 ee eal 4 4 k H ANSYG Home Ready Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 26 Retain the selection of the Multi region common naming across regions radio buttons and then click on the Create New ANSWER Smart XLS Version 6 7 button This brings up the following form Create New ANSWER Smart LS version 6 f Filename of XL3 bo be created Use the Browse button to bring up the New ANSWER Smart XLS common dialog form and use the Save in combobox at the top of the form to specify the folder where you want the new ANSWER Smart XLS to be located then key in the filename for the new XLS in the File name textbox near th
25. 0 highlighted in yellow as follows A B c OD QR OF C H K TID TRADE GLOBAL REGA REG2 REGS IMPEXP MINRMVY Check Sheet Parameter Aral Arg Arg Arg Ar Arch LB Region Fegion Parameter Argi Arq Arg Arg4 Arg Arg Value 25 IMPEXP REG3 TOP IRE IMPOSL1 DSL z 7 DSL 1 IMPEXP REG TOP_IRE IMPGAST GAS GAS 1 A IMPEXP REG TOP_IRE IMPSSL1 BSL SSL 1 20 IMPEXP REG3 TOP_IRE IMPHOO1 Hoo Hoo 1 24 IMPEXP REG3 TOP IRE MPL iL IL l 301 IMPEXP REG TOP _IRE IMPURMA FN A STR The comment associated with the highlighted cell 130 indicates that the commodity name in the Arg6 column must be a valid Commodity Item Name for Region REG3 where REGS is the region specified in the Region2 column cell B30 Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 20 11 Time Series amp Time Independent Trade Data TS amp TID TRADE Sheet The TS amp TID TRADE sheet offers the convenience of allowing both Time Series and Time Independent Trade Data Parameters to be specified on a single sheet An example of a TS amp TID TRADE sheet is shown below B E D E F G H J K L M TSSTID TRADE 1 GLOBAL REGI REG2 REGS IMPEXP MINRNVYY Check Sheet 4 Parameter Argi Arg Arg3 Arg Arg5 Arg LE Opt 5 6 LE Opt Region Region2 Parameter Arg1 Arg2 Arg3 Arg4 Arg5 Arg6 or Value On TS amp TID TRADE sheet a single region must be
26. ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 October 2011 Noble Soft Systems Pty Ltd Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 Table of Contents PCKHIOWICOOCINCIIS 5 a5 as ul ete hlt uk paisa x oe bina lana an Tlak sa a 2 Pe BACKI OUNO oere rer ee errr tren rere tr ree arene tere tea rer tre rer o 2 2 WVOTKD OOK SEUD crian eE ce NOT ADO AO A TA T RO o noch 3 3 Worksheet Layout and Philosophy soooosnn non ono nn nr nn 4 3 1 Role and Operation of smart buttons on ANSWER TIMES Smart Worksheets 5 4 REGION S a 6 DTS SNC CE oe aise lososa a A agence 8 6 Time Series Data TS DATA SHC cccccccsssseeseeccccecscseeseseecceeesssaeesseeesssssueseeeeeessssaaaneeseeees 11 7 Time Independent Data TID DATA cccccssseeccccsssneseecesnaueeeeenscucseccssauecssesssauaneecessauensessaaaes 13 8 Time Series amp Time Independent Data TS amp TID DATA Sheet osonoononnn non 15 9 Time Series Trade Data TS I RADE Sheet oooon oosnnnn no en nn nn 16 10 Time Independent Trade Data TID TRADE She t ccccssscecccccsseseeceeeseeeeeseaeeeeeseaaees 18 11 Time Series amp Time Independent Trade Data TS amp TID TRADE Sheet 20 12 Loading a Smart Excel Workbook into ANSWER TIMES cccccssssseeeeeeccesscesseeeeeceessessaeees 21 13 Example ANSWER
27. COM PKFLX ELC FAD 0 0 2 0 2 0 2 COM_PKFLX ELC SPD 0 02 0 2 0 2 To specify a Time Series Data Parameter position the cursor in column B of a row below row 7 and press the Parameter smart button This brings up a TS Parameter selection list as shown below Select T5 Parameter Name will be transferred to ActiveCell E EJ ACT COST Variable costs Oe aad vat activity of a process ALT EFF Activity efficiency For a process CAP BND Bound on total installed capacity in 4 period CM_EXOFORC Radiative Forcing From exogenous sources GLOBAL Climate CM LINF R Linearized Forcing Function parameter GLOBAL Climate CMM ASC Maximum allowable climatic quantity GLOBAL Climate COM Aa Commodity aggregation parameter COM _BNDNET Het bound on commodity e g emissions TOM BN FR Limit on production of a commodity TOM CSTNET Cost on Het of commodity fe g emissions tax T M _CSTPRD Cost on production of a commodity COM ELAST Elasticity of demand Elastic Demand COM _ELASTS Elasticity shape of demand Elastic Demand TOM FR Seasonal distribution of a commodity T M TE Seasonal efficiency of a commodity COM_PKFLY Peaking Flux ratio COM_PERSY Peaking reserve margin COM PRO Demand baseline projection COM _ SUBNET Subsidy on a commodity net COM_SUBPRD A on production of a commodity net hk Co ee LIE INT a ee ee Hen Only TS Parameters Specify Param Specify Param Parameters Shown Excluded And args Preserve
28. COM_GRPDEF COM_GRP COM_GRPDEF COM_GRP COM_GRPDEF COM_GRP COM_GRPDEF COM_GRP COM_GRPDEF COM_GRP COM_GRPDEF ALL TS AHHUAL ALL TS SEASOM ALL_TS DAYHITE ALL TS DAYMITE ALL TS SEASOM ALL TS DAYMITE ALL TS DAYNITE ALL TS SEASOM ALL TS DAYNITE ALL_TS DAYHITE ALL_TS SEASON ALL_TS DAYHITE ALL_TS DAYHITE COM ENV ANNUAL GHG COM NRG DAYNITE ELC COM NFRG AHNUAL FRERENEW COM DEM ANNUAL IND COM DEM DAYHITE RES COM DEM ANNUAL RES COM DEM ANNUAL TRH Commodity tems for DEMO UTOPIA IMPEXP regions ANSWER requires Commodity tems to be specified in External Regions involved in Import Export COM NRG AHNUAL FOSSIL COM NRG AHNUAL FOSSIL COM NRG ANNUAL FOSSIL COM NFRG AHNUAL FOSSIL COM NRG ANNUAL FOSSIL COM NFRG AHNUAL HUCLR COM GRP COM GRPTRU COM GRP COM GRPTRU COM GRP COM GRPTRU PRC ELE DAYHITE IRE PRC ELE DAYHITE PRC ELE SEASON Note that when you first create an ITEMS sheet rows 9 15 are automatically generated and you must enter into cell A10 a comma delimited list of the internal regions for your model These auto generated rows specifying pre defined Commodity Groups are necessary to ensure that data parameters that require pre defined Commodity Groups as arguments can be specified and for the correct functioning of Check Sheet So you should always retain them The remaining information entered on the ITEMS sheet that is directly provided by the user for each Item are the Component Item Name and Description appeari
29. EG3 in each of cells A25 to A48 e Onthe Commodity Data sheet the majority of the Commodity specific parameters are assumed to have numeric values that are region independent So all of the parameters specified in rows 10 to 57 of this sheet will be created for each of the regions REG1 REG2 REG8 specified in cell A10 But note the use in column A of a single region name of REG1 in row 60 and of REG2 in row 63 and of REGS in row 66 so that numeric values for the COM PROJ parameter that are region dependent can be specified e The Process Data DMD sheet is presented to show TS and TID process data ona single sheet with the data grouped by process name The user may wish to consider whether this approach is beneficial to adopt for specifying processes For example once a process of a particular type is known to be correctly specified then copying all of its TS and TID data rows and then changing the process name and I O Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERvV6 TIMES Smart Excel Workbook Manual version 6 7 24 commodities and numeric coefficients as necessary may prove to be an efficient way of creating another process of this particular type e The Constraint Data sheet is presented to show how a Cross Region User Constraint a Constraint involving Sum over Regions similar to the one described in section 11 2 of the ANSWERv6 TIMES User Manual can be specified on a TS amp TID DATA sheet Note the role of the GL
30. ER TIMES Smart Excel Workbooks have been developed to allow the analyst to assemble the model data from its sources in a form readily loaded into ANSWER TIMES The process is guided by a few rules and supported by smart buttons and selection trees or lists along with quality control checking to facilitate the direct and correct loading of the data The Smart Excel Workbooks are loaded into an ANSWER TIMES database by means of the File Import Model Data from Excel facility For an overview of the use of this facility see section 12 Loading a Smart Excel Workbook into ANSWER TIMES of this manual and for a detailed explanation see section 2 10 Importing Model Data from Excel in the ANSWERv6 TIMES User Manual paf in folder C AnswerTIMESv6 UserManuals In sections 4 11 that follow each type of worksheet will be presented The next two sections however describe opening a smart workbook and the general layout and philosophy embodied in all the worksheets Note that an example Smart Excel Workbook SmartDemoMultiRegion xls that demonstrates the specification in its entirety of a multi region TIMES model is provided as part of the ANSWERve6 TIMES installation files in folder C AnswerTIMESv6 Ans_WrkTI See section 13 Example ANSWER TIMES Smart Excel Workbook of this manual Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 2 Workbo
31. O FR RHE RH SUN FX 0 0 0 0 0 FLO FR RHE RH VID FX 0 0 4 0 4 0 4 0 4 FLO_FR RHE RH VIN FX 0 0 2 0 2 0 2 0 2 NCAP_AF RHE ANNUAL UP 0 1 1 1 1 NCAP BND RHE UP 0 0 null null null r NCAP COST RHE 0 12 12 12 12 NCAP TLIFE RHE 0 30 30 30 30 PRC_ACTUNT RHE RH 1 PRC_CAPACT RHE 1 TOP IN RHE ELC 1 TOP OUT RHE RH 1 TS and TID Data for RHG ACT EFF RHG RHG_IN ANNUAL 0 0 7 0 7 0 7 0 7 FLO_EMIS RHG CO2 DSL ANNUAL 0 75 75 75 75 FLO_EMIS RHG CO2 GAS ANNUAL 0 56 56 56 56 FLO_FR RHG RH FAD FX 0 0 18 0 18 0 18 0 18 FLO_FR RHG RH FAN FX 0 0 12 0 12 0 12 0 12 To specify a Time Series or Time Independent Data Parameter on a TS amp TID DATA sheet position the cursor in column B of a row below row 7 and press the Parameter smart button This brings up a TS and TID Parameter selection list as shown below Select TS or TID Parameter Name will be transferred to ActiveLell TS TID Global Set Memberships EHIRACT BND Bound on activity of a process B ACT COST Variable costs associated with activity of a process ACT CLM Bound on cumulative process activity ACT EFF Activity efficiency For a process TAP BND Bound on total installed capacity in a period TM CONST Climate module constants GLOBAL Climate CM_EXOFORC Radiative Forcing From exogenous sources GLOBAL Climate TIM HISTORY Calibration values For CO and Forcing GLOBAL Climate TIM LINF R Li
32. OBAL region to specify the RHS for the Cross Region User Constraint If you use the Import Model Data from Excel facility to import SmartDemoMultiRegion xIs into EmptyDemoMultiRegion v67 mdb and then scan the Global TimeSlice Commodity CommGroup Process TradeProcess and Constraint tabs you will see that a multi region TIMES model is indeed fully specified You might also wish to carry out Run Model Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 25 Appendix A Establishing a New ANSWER TIMES Smart Workbook The process of establishing a new workbook must be done with care so as to ensure that all the functionality smart buttons and cell references links to the ITEMS sheet are properly retained The following possibilities are detailed below A 1 Creating a new empty ANSWER TIMES Smart Workbook A 2 Making an existing workbook aware of ANSWER TIMES Smart Workbook facilities A 3 Copying an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities to create a new workbook A 4 Updating an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER TIMES smart XLS A 5 Adding anew ANSWER TIMES smart sheet to the current XLS A 1 Creating a new empty ANSWER TIMES Smart Workbook To create a new empty ANSWER TIMES Smart Workbook open
33. Pad File Edit View Insert Format Help Deh li A Hen H summary Log File created on Friday 14 October 2011 at 04 47 PH CHECK REGIONS SHEET REGIONS GLOBAL DEMO UTOPIA INPEXP MINRNW Check Cell Bl Region Region List The Region Region List in cell Bl is OK Check All Region Names 111 column A regions region lists are OK Check For Duplicate Region Names There are no Duplicate Names in the Region column Check All Region Descriptions All of the Descriptions in the Description column obey ANSWER conventions Check All Region Set Memberships All of the Set Memberships in the Set Memberships column are valid For Help press Fl Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 5 ITEMS Sheet The ITEMS sheet is where all the Items whose specification is under user control TimeSlices Commodities Commodity Groups Processes User Constraints are named and described and where applicable their Units and Set Memberships information are declared An example ITEMS sheet is shown below mE 1 ITEMS 3 Check Sheet EE Component Comp Hame DEMO UTOPIA D ACTGRP DEM ENY FIN MAT NRG H H _GLOBAL DEMO UTOPIA W ANNUAL FA FAD FAN SP SPD SPN SU SUD SUN wi VID VIN ZZZzzz CD CD A M DT a N a a a O a Nj ef J 1 KO O CO CO SI OF GD RO CO CO CO gt
34. RFR SPH 0 083 34 5 YRFR 2 s SU 025 ap G _YRFR z g SUD 018 301 3 YRFR 3 z SUN i 0 07 To specify a Time Independent Data Parameter position the cursor in column B of a row below row 7 and press the Parameter smart button This brings up a TID Parameter selection list as shown below Select TID Parameter Name will be transferred to ActiveCell Ea AT _ CUM Bound on cumulative pr cess a ctivity N IM _ CONST Climate module constants TID GLOBAL Climate CM HISTORY Calibration values For CO and Forcing TID GLOBAL Climate COM _CUMNET Cumulative net bound on commodity e g emissions TID COM OUMPR Cumulative limit on production of a commodity TID COM GM P Commodity and commodity group Set TID TOM LIM List of equation type For balance Set TID COM _ OFF Periods For which a commodity is unavailable Set TID COM PEAK Peaking required flag Set TID COM _PETS Peak timeslice For a commodity group Set TID COM STEP Step size For elastic demand TID Elastic Demand DAM BOTY Base quantity of emissions TID Damage DAM _ELAST Elasticity of damage cost TID Damage DAM STEP Step number For emissions up to base TID Damage D M YOC Variance of emissions TID Damage ETL TLAPO Initial cum capacity starting point on learning curve TID ETL ETL CCAPM Maximum cum capacity fending point on learning curve TID ETL ETL PR T Progress ratio TID ETL ETL 5CO Investment cost corresp to starting point on learning curve TID
35. S IMPEXP MINRNVY Parameter Argi Arg2 Arg3 Arg Arg5 Arg vE op Region Region2 Parameter Arg1 Arg2 Arg3 Arg4 Arg5 Arg6 IE Opt 3 Check Sheet On TS TRADE sheet a single region must be specified in column A a comma separated region list is not allowed 11 REG1 IMPEXP IRE_PRICE IMPDSL1 DSL ANNUAL l IMP 0 10 10 10 12 REG1 IMPEXP IRE_PRICE IMPGAS1 GAS ANNUAL l IMP 0 6 4 6 4 6 4 REG1 IMPEXP IRE_PRICE IMPGSL1 GSL ANNUAL l IMP 0 15 15 15 14 REG1 IMPEXP IRE_PRICE IMPHCO1 HCO ANNUAL IMP 0 2 2 2 15 REG1 IMPEXP IRE_PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 16 REG1 IMPEXP IRE_PRICE IMPURN1 URN ANNUAL l IMP 0 2 2 2 ij REG2 IMPEXP IRE_PRICE IMPDSL1 DSL ANNUAL l IMP 0 10 10 10 REG2 IMPEXP IRE_PRICE IMPGAS1 GAS ANNUAL l IMP 0 6 4 6 4 6 4 REG2 IMPEXP IRE_PRICE IMPGSL1 GSL ANNUAL IMP 0 15 15 15 REG2 IMPEXP IRE_PRICE IMPHCO1 HCO ANNUAL l IMP 0 2 2 2 REG2 IMPEXP IRE_PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 REG2 IMPEXP IRE_PRICE IMPURN1 URN ANNUAL l IMP 0 2 2 2 REG3 IMPEXP IRE_PRICE IMPDSL1 DSL ANNUAL l IMP 0 10 10 10 REG3 IMPEXP IRE_PRICE IMPGAS1 GAS ANNUAL l IMP 0 6 4 6 4 6 4 REG3 IMPEXP IRE_PRICE IMPGSL1 GSL ANNUAL l IMP 0 15 15 15 REG3 IMPEXP IRE_PRICE IMPHCO1 HCO ANNUAL IMP 0 2 2 2 REG3 IMPEXP IRE_PRICE IMPOIL1 OIL ANNUAL l IMP 0 8 8 8 REG3 IMPEXP IRE_PRICE IMPURN1 URN ANNUAL l IMP 0 2 2 2 sl To specify a Time Series Trade Data Parameter select an empty row below row 7 and enter the r
36. Smart XLS version 6 7 Filename of L5 to be updated Filename given to ANSWER Smart L5 created by update For clarity of explanation suppose that the existing workbook that you wish to make aware of ANSWER Smart Workbook facilities is called USER XLS Use the Browse button to select USER XLS The form now appears as follows Update XLS to ANSWER Smart LS version 6 7 Filename of L5 to be updated Cr 4nsiwer TIMES v6 Smarts S1USER xls Browse Filename given to QNSWER Smart L5 created by update Cr 4nswer TIMES v6 Smart SLS1USER w6 7 xls The default filename given to the ANSWER smart XLS that will be created by the update is taken to be the filename of the XLS to be updated with v6 7 appended So above v6 7 is appended to USER to provide USERv6 7 as the default filename Click on the Update button The update process will proceed concluding with a message box indicating that the update has been completed The form remains open so that additional XLS files may be selected to be made aware of ANSWER TIMES Smart Workbook facilities if desired Click on the Close button to close the Update XLS to ANSWER Smart XLS form Close ANSWER TIMESver6 7 XLS A 3 Copying an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities to create a new workbook If an existing workbook is already aware of ANSWER TIMES Smart Workbook facilities then simply copying this workbook
37. TIMES Smart Excel WOrkbDOOK cccccsseeeeecsssneeeeeseneseeessanaeseeessanees 22 Appendix A Establishing a New ANSWER TIMES Smart Workbook osonoonnnnneeme 25 A 1 Creating a new empty ANSWER TIMES Smart Workbook ooooooonnnn mom 25 A 2 Making an existing workbook aware of ANSWER TIMES Smart Workbook facilities Beh ge ees E ec ea tees de ents tetanic ET AS 27 A 3 Copying an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities to create a new WOLKDOOK 1ccccseccccseeccsnecseeeccseeecsssesssusesseesesssessness 28 A 4 Updating an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER TIMES SMIAT XE Sanai a an ii ah a a adn l obl 29 A 5 Adding a New ANSWER TIMES Smart Sheet to the Current XLS oeoee 29 Appendix B Details regarding the operation of the Parameter selection form the Parameter Argument Item selection form and Check Sheet Parameter checking ccccccccsseeees 32 B 1 Operation of the Parameter Selection Form displayed after clicking on Parameter DUTION sh 33 B 2 Operation of the Parameter Argument Item Selection Form displayed after clicking On PATO AlO6 DUMONS isr casero le ho erie va 35 B 3 Check Sheet Checking for a Data Parameter cccccccsseeeseeeeeecaeeeseeeeeseseaaanssseeees 38 Noble Soft
38. WER TIMES Smart Excel Workbook must contain a single REGIONS sheet and a single ITEMS sheet An ordinary ANSWER TIMES Excel Workbook may contain multiple ITEMS sheets e The user is free to have multiple instances of the other worksheets TS DATA TID DATA TS amp TID DATA TS TRADE TID TRADE TS amp TID TRADE e Although each of the sheets has a rather rigid format the user has considerable freedom in regard to how Items information is ordered on an ITEMS sheet and to how TS and TID Data is ordered on the 3 types of DATA sheets and the 3 types of TRADE sheets The introduction of the TS amp TID sheets increases the users flexibility since there is now the choice as to when to use them and when to stay with the TS and TID sheets e To some extent the SmartDemoMultiFRegion xls should be seen as endeavouring to demonstrate a range of possibilities that are available to the user But in some respects it should also be seen as suggesting approaches that may be beneficial to adopt whenever you specify a multi region TIMES model in an ANSWER TIMES Smart Excel Workbook Note that it is not necessary to spread the TS and TID Data over 9 worksheets GlobalTabData through to Trade TIDData as has been done in SmartDemoMultiRegion xls If wanting to specify the exact same information that is contained in SmartDemoMultiRegion xls in the minimum number of Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart
39. are Declaration and Data and are identified by one of the ANSWER TIMES Indicators REGIONS ITEMS TS DATA TID DATA TS amp TID DATA TS TRADE TID TRADE or TS amp TID TRADE appearing in cell A1 of the worksheet Table 1 ANSWER TIMES Smart Worksheets Indicator Regions Declare REGIONS The Internal and External Regions are named and described and their Set Memberships information is declared ANSWER s special GLOBAL region is pre defined on the sheet See section 4 ltems Declare ITEMS ltems whose specification is under user control TimeSlices Commodities Commodity Groups Processes User Constraints are named and described and where applicable their Units and Set Memberships information are declared See section 5 Time Series Data Data TS DATA TIMES Time Series Data Parameters that have a single region index are specified See section 6 Time Independent Data TID DATA TIMES Time Independent Data Data Parameters that have a single region index are specified See section 7 Time Series and Data TS amp TID DATA TIMES Time Series amp Time Independent Time Independent Data Parameters that have a single Data region index are specified See section 8 Time Series Data TS TRADE TIMES Time Series Data Parameters that Bilateral Trade have two region indexes are specified Data See section 9 Time Independent Data TID TRADE TIMES Time Independent Data Bilateral Trade Parameters that have two region indexes Data
40. ave a standard set of consistency and quality control checks performed See Appendix B 3 for details regarding the checking that is carried out for a Data Parameter The results of the checking are presented in a Wordpad file as shown below and any offending cells are highlighted on the sheet in yellow along with a cell comment indicating the nature of the problem Suppose for example you specify parameter IRE_PRICE in row 32 but forget to specify Region and Region2 in cells A32 and B32 Then the Wordpad file will be as follows EB CheckSummary Log WordPad EMER File Edit View Insert Format Help Dk li A 508 6 Summary Lag File created on Monday 17 October 2011 at 02 34 PH wae CHECK TS TRADE SHEET Trade Tadata GLOBAL REGi REGA REGS INPEAP MINRNW Check Cell Bi Region Fegion List The Region Fegion List in cell Bi is OE Check 411 Region Names in column A In colum 14 1 region region lists are not valid in rows 32 Check the yellow cells in column A Check Rows specifying TS TID TRADE Parameter instances 1 rows specifying Parameter instances have problems in rows 32 The yellow cells in each Farameter row indicate where there are problems For Help press Fl and the TS TRADE worksheet will have cells A32 and B32 highlighted in yellow as follows a eJ WWJ eee eee 1 TS TRADE GLOBAL REG REG REGS IMPEXP MINRMVY a Check Sheet Parameter Aripi Arg Arg Arc Arg Arch LE Oy Region
41. e TS DATA 3 and so on 8 To add another smart sheet to the XLS select the type of ANSWER TIMES smart sheet to be added adjust the contents of the Region List combobox as necessary and click on the Add Sheet button 9 Click on the Close button to close the Add New ANSWER Smart Sheet form Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 32 Appendix B Details regarding the operation of the Parameter selection form the Parameter Argument Item selection form and Check Sheet Parameter checking There are six types of smart worksheets currently available in an ANSWER TIMES Smart Excel Workbook for the specifying of Data Parameters TS DATA TID DATA TS amp TID DATA TS TRADE TID TRADE TS amp TID TRADE For each of these worksheets very similar mechanics apply to the specification of Data Parameters with the user proceeding as follows e Selects an empty row below row 7 positions the cursor in the Parameter column of this row column B for a DATA sheet column C for a TRADE sheet and presses the Parameter button This brings up a Parameter selection form that displays all appropriate Parameters for that worksheet Specify Param e Selects the Parameter of interest and normally clicks on the ice a button exiting the Parameter selection form and causing the Parameter Name and the nature and positions of its Arguments to be wr
42. e bottom of the form as follows Mew ANSWER Smart ALS Save I EF DemomultiRegion xls e B discrete iny xls My Recent Aljhase ex4 0ld xls TBE LTS 8 utopia tidy xls F B utopia _demo_uc4 xls B utopia demo uci xls esktop BH utopia_demo_uc xls BS utopia_demo xls My Documents My Computer My Network File name Smart emohultiAegion Y Places Save ag type Microsoft Excel File sl Cancel me Click on the Save button The full filename of the new XLS to be created will appear in the Filename of XLS to be created textbox as follows Greate New ANSWER Smart ZL5 version 6 7 Filename of XL3 bo be created Cn AnswerTIMESY6 Ans WrkTl SmartDenoMultintegion xls Browse An alternative to using the Browse button to specify the full filename of the new XLS is to key the full filename into the textbox but using the Browse button is recommended Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 27 Click on the Create button The creation process will proceed concluding with a message box indicating that the creation of the new XLS has been completed The form remains open so that additional new ANSWER TIMES Smart XLS files may be created if desired Click on the Close button to close the Create New ANSWER Smart XLS form Close ANSWER TIMESver6 7 XLS When you open any o
43. egions involved in the trade in the Region and Region2 columns columns A B of this row Then position the cursor in column C of this row and press the ella smart button This brings up a TS Trade Data Parameter selection list as shown below Select 75 Trade Parameter Name will be transferred to ActiveCell Sets Filter All Data Parameters TS TID Global Set Memberships Limit on inter regional exchange of commodity B E Efficiency of exchange For inter regional transfer IRE_PRICE Price of import export Only TSP t Specify Param Specify Param ny arameters z Parameters Shown Excluded And args Preserve args Cancel Specify Param Select the desired TS Trade Parameter and normally click on the a button Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 17 Then use the oan through to oag buttons and the VE op button as appropriate to specify the Arguments and the I E Opt code for the selected Parameter followed by specification of the Parameter s numeric values See Appendixes B 1 and B 2 respectively for details regarding the operation of the Parameter selection form and for details regarding the operation of the Item selection form that is displayed when you click on any of the doo through to oas buttons to specify the Arguments for the selected Parameter The Check sheet button may be pressed at any time to h
44. em selection form that is displayed when you click on any of the doo through to Aras buttons to specify the Arguments for the selected Parameter The Check sheet button may be pressed at any time to have a standard set of consistency and quality control checks performed See Appendix B 3 for details regarding the checking that is carried out for a Data Parameter The results of the checking are presented in a Wordpad file as shown below and any offending cells are highlighted on the sheet in yellow along with a cell comment indicating the nature of the problem Suppose for example that while specifying parameter TOP_IRE in row 30 you press the Cheek Sheet button before replacing Commodity in the Arg6 column by the desired commodity name URN in this case Then the Wordpad file will be as follows EB checkSummary Log WordPad EBR Caen amp lo A j B amp Summary Log File created on Monday 17 October 4011 at 03 00 PH os wee CHECK TID TRADE SHEET Trade TiDData GLOBAL REG1 REG REGS INPEAP MINRNW Check Cell Bl Region Reqion List The Region Reqion List in cell El is OE Check 411 Region Names in column A 111 column L regionregion lists are OE Check Rows specifying TS TID TRADE Parameter instances 1 rows specifying Parameter instances have problems in rows 30 The yellow cells in each Parameter rov indicate where there are problems For Help press F1 and the TID TRADE worksheet will have cell 13
45. f the new ANSWER TIMES Smart XLS files that you have created you will need to use the Add New ANSWER Smart Sheet to Current XLS button to add sheets to the XLS See A 5 below for details of the operation of this button A 2 Making an existing workbook aware of ANSWER TIMES Smart Workbook facilities To make an existing workbook aware of ANSWER Smart Workbook facilities ensure that this workbook is not open and open the file ANSWER TIMESver6 7 XLS distributed by Noble Soft Then select Enable Macros to bring up the single visible sheet of ANSWER TIMESver6 7 XLS as follows EJ Microsoft Excel ANSWER TIMESy er6 7 xIs HES 14 File Edit View Insert Format Tools Data Window Help Adobe PDF f x LS b Ala la A gt 9 100 iA k i fe AMSG 7 Home 1 JANSv6 7 Home Create New ANSWER Smart XLS Version 6 7 Update XLS to ANSWER Smart XLS Version 6 7 gingle region Multi region no common naming across regions Multi region common naming across regions Add New ANSWER TIMES Smart Sheet to Current XL5 ee a NE a 4 4 H ANSYG Home Ready Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 28 Retain the selection of the Multi region common naming across regions radio buttons and then click on the Update XLS to ANSWER Smart XLS Version 6 7 button This brings up the following form Update XLS to ANSWER
46. ion v67 mdb that has compatible time periods for Import Model Data from Excel is provided in folder C AnswerTIMESv6 Answer_Databases To use SmartDemmoMultiRegion xls to explore various aspects of how an ANSWER TIMES Smart Excel Workbook operates e If as part of exploring how an ANSWER TIMES Smart Excel Workbook operates you intend to change the contents of the ANSWER TIMES Smart Excel Workbook it is suggested that you use Windows Explorer to make copies of both SmartDemoMultiRegion xls and EmptyDemoMultiRegion v67 mdb so that you retain copies of both files as originally distributed e Open SmartDemoMultiRegion xls and click on the Enable Macros button e When the Specify ANSWER Database form appears click on the top radio button and then use the Browse button to select EmptyDemoMultiRegion v67 mdb in folder C AnswerTIMESv6 Answer_ Databases The following points should be noted about SmartDemoMultiRegion xls many of these points are exactly similar to points that have already been made in Enhanced ANSWER TIMES Format for Import Model Data from Excel doc in folder C AnswerTIMESv6 Doc in regard to the non Smart Excel Workbook DemoMultiRegion xls but there are some important differences because an ANSWER TIMES Smart Excel Workbook must contain a single ITEMS sheet e As noted above SmartDemoMultiRegion xls contains the specification in its entirety of a multi region TIMES model e An ANS
47. itten to the previously empty row e Positions the cursor in turn in whichever of the Arg1 through to Arg6 columns of this l l Arg row is appropriate and uses whichever of the ah through to 2 is appropriate to specify the Arguments for the selected Parameter e Specifies the Parameter s I E Opt code if a TS Parameter and specifies the Parameter s numeric value s buttons On any of these worksheets the Check sheet button may be clicked at any tlme to have a standard set of consistency and guality control checks performed Details regarding the operation of the Parameter selection form the Parameter Argument Item selection form and Check Sheet Parameter checking are contained in each of the Appendixes B 1 B 2 and B 3 as follows B 1 Operation of the Parameter Selection Form displayed after clicking on Parameter button B 2 Operation of the Item Selection Form displayed after clicking on Arg1 Arg6 buttons B 3 Check Sheet Checking for a Data Parameter Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 33 B 1 Operation of the Parameter Selection Form displayed after clicking on Parameter button For each of the worksheets used for specifying Data Parameters the Parameter Selection Form that is displayed after clicking on the ZUmeer operation of the Form button is extremely similar as is the Here the operation of the
48. le Edit wiew Insert Format Help Cad 2a A BB R Bummar v Log File created on Friday 14 October 2011 at 05 54 PH 5 CHECK TID DATA SHEET TID DATA DEMG UTOPIA DEMO UTOPIA Check Cell Bl Region Region List The Region Region List in cell Bi is OK Check Column Regions Region Lists Riek Geman deo neg Sn ce ior Check Rows specifying TS TID DATA Parameter instances All of the Rows specifying Parameter instances are OF v For Help press Fl Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 15 8 Time Series amp Time Independent Data TS amp TID DATA Sheet The TS amp TID DATA sheet offers the convenience of allowing both Time Series and Time Independent Data Parameters to be specified on a single sheet An example of a TS amp TID DATA sheet is shown below B e D E F G H 125 E M GLOBAL REG1 REG2 REG3 MPEXP MINRNYY Parameter Argi Arg Arg3 Arg Arg Arg LE opt LE Opt or Value Parameter Argi Arg2 Arg3 Arg4 Arg5 Arg6 TS and TID Process Data for Demand Devices Grouped by Process REG1 REG2 REG3 regions TS and TID Data for RHE REG1 REG2REG3 ACT EFF RHE ELC ANNUAL 0 1 1 1 1 FLO FR RHE RH FAD FX 0 0 18 0 18 0 18 0 18 FLO_FR RHE RH FAN FX 0 0 12 0 12 0 12 0 12 FLO_FR RHE RH SPD FX 0 0 06 0 06 0 06 0 06 FLO_FR RHE RH SPN FX 0 0 04 0 04 0 04 0 04 FLO_FR RHE RH SUD FX 0 0 0 0 0 FL
49. lt Ready 3 Click on the Add New ANSWER Smart Sheet to Current XLS button This brings up the following form Add New ANSWER Smart Sheet to ZLS Select ANSWER Smart Sheet ta be added to XLS ITEMS TS DATA TID DATA TS amp 71D DATA TS TRADE TID TRADE TS amp 71D TRADE Specify Region List to be added to cell B1 of Sheet _ GLOBAL REG REGA REGS IMPESP MINA Add Sheet Close The Select ANSWER Smart Sheet listbox contains the eight types of smart sheets namely REGIONS ITEMS TS DATA TID DATA TS amp TID DATA TS TRADE TID TRADE TS amp TID TRADE Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 31 The Specify Region List combobox contains a comma delimited list of the regions in the ANSWER TIMES database listed in the order GLOBAL Internal Regions in alphabetical order External Regions in alphabetical order Note that the comma delimited list in the combobox may be edited by the user if desired 4 Select the type of ANSWER TIMES smart sheet that you wish to add by clicking on it in the listbox For example click on TS DATA if you wish to add a new TS DATA sheet to the current XLS 5 Edit the comma delimited Region List in the combobox as necessary It is allowable to delete Regions from the Region List and to add new Region Names to the Region List When the smart sheet is created its cell B1 will con
50. mart Workbook to version 6 8 will be to open the file ANSWER TIMESver6 7 XLS and follow the Making an existing workbook aware of ANSWER TIMES Smart Workbook facilities procedure that is documented at A 2 above A 5 Adding a New ANSWER TIMES Smart Sheet to the Current XLS This facility allows the user to easily add a new ANSWER TIMES smart sheet to their current ANSWER TIMES Smart XLS To use the facility proceed as follows 1 Open an ANSWER TIMES Smart XLS and specify the ANSWER TIMES database to be associated with the Smart XLS 2 Make the Home sheet the active sheet For a version 6 7 ANSWER TIMES Smart XLS this sheet appears as follows Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 30 EJ Microsoft Excel ANSWER TIMESyver6 7 Library 05 xIs SNE z Eat File Edit wiew Insert Format Tools Data Window Help Adobe PDF f x Dl ao ome 2 O Bia ak gt fe ANSvb Home E E F a ANSvo Homel Create New ANSWER Smart ALS Version 6 7 Update ALS to ANSWER Smart XLS Version 6 7 gingle region gt Multi region no common naming across regions Multi region common naming across regions Add New ANSWER TIMES Smart Sheet to Current XLS DC Ss eS Sf et al on ool bo CZ LU CO pd Oo Bo Cy oo GI on oo hoy C 4 4 k Hl ANS5Yb 7 Home 4 REGIONS 4 ITEMS 4 TS DATA TID
51. mbined Heat amp Power Processes DAYNITE Processes Day Night Time Slice Level DISTR Distribution Systems Processes JDMD DemandDevices nu Name ELE Electric Generation Processes BITRA DE HFL Heat Generation Processes E01 2 DEMO UTOPIA Coal Steam Electric The Name and Description Filter allows the user to filter the Processes that are displayed by Name or by Description or by a compound filter that involves both a Name Filter and a Description Filter that are applied with a logical AND or OR e For example if the user wishes to display those Processes whose Description contains Electric what is required is to enter Electric in the Description Filter like textbox and then check the Description Filter checkbox Select Process Name will be transferred to Active Cell Sets Filter AJ Processes PRC Name and Description Filter T Name Fiter Like ano Cor M Description Fiter Like i Electric Region s BITRADE ELC z DEM UTOPTA Bilateral Trade in Electricity E01 z DEMO UTOPIA Coal Steam Electric E31 Z DEMO UTOPIA Hydro electric Plant ES z DEMO UTOFIA Hydro electric Plant 2 renewable RHE 2 DEMO UTOPIA Electric Boiler THE 2 DEMG UTOPIO Electric Car The Electric filter where the asterisk character indicates zero or more characters selects those Processes that contain Electric anywhere within their Description To select those Processes whose Description starts with Electric
52. n for data parameters with no REG arg ALL REG Demo region ALL REG REG Litopia region ALL_REG REG IMPEXP region ALL REG REG EXT MI region ALL FREG REG EXT The information entered on the REGIONS sheet that is directly provided by the user are the Region Names and Descriptions appearing in columns A and B respectively To specify that a Region is an Internal Region enter ALL REG REG in column C and to specify that a Region is an Internal Region enter ALL REG REG EXT in column C Or after positioning the cursor in column C of a row use the ___3 t Memberships smart button to select Internal or External from the Region Set Memberships form shown below where the user has selected Internal Specily Region Set Memberships To specify Set Memberships click on the appropriate leaf node in the LHS treeview adjust the RHS Additional Charactenzation as necessary and then click on the OF button Set Memberships Additional Characterization and then click on the OK button the Set Memberships in this case ALL_REG REG for Internal will be entered in column C of the row The Check sheet button may be clicked at any time to have a standard set of consistency and quality control checks performed the results of the checking are presented in a Wordpad file as shown below Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 7 CheckSummary Log Word
53. nearized Forcing Function parameter GLOBAL climate TI MAT Maximum allowable climatic quantity GLOBAL Climate COM Ass Commodity aggregation parameter TOM BNONET Net bound on commodity e g emissions COM BNOPRD Limit on production of a commodity COM _CSTNET Cost on Nek of commodity e g emissions bax COM STPRD Cost on production of a commodity COM _CUMNET Cumulative net bound on commodity e g emissions COM CUMPRD Cumulative limit on production of a commodity COM _ELAST Elasticity of demand Elastic Demand COM ELASTA Elasticity shape of demand Elastic Demand TOM FR Seasonal distribution of a cormmadity TOM GMAP Commodity and commodity group Set b na TO O m m lol mi m m i la m mm mamu m lila TO wr Both TS and TID Parameters Su Parameters Shown Excluded specify Param specify Param O Cancel i And Args Preserve r The mechanics of selecting the desired Parameter and specifying its Arguments and the operation of the Check sheet button are exactly the same as for the TS DATA and TID DATA sheets Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 16 9 Time Series Trade Data TS TRADE Sheet The TS TRADE sheet is where Time Series Trade Data Parameters are specified These are TS Parameters that have two region indexes An example of a TS TRADE sheet is shown below SE a Ea O O PO NEJ EE O OE PE ZE VO EDA ee TS TRADE A GLOBAL REG1 REG2 REG
54. ng in columns B C and D respectively Initially the user may need to use the Component smart button to specify the single character Component Letter in column B Noble Soft Systems Pty Ltd 2005 11 October 201 1 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 Select Component Description Letter CommlGroup Commodity Constraint Process TimeSlice but rather quickly will come to learn the correspondence between the TimeSlice Commodity Commodity Group Process User Constraint Components and these 5 Letters In addition after positioning the cursor in columns E or F of a row the Unisi or michal Micaela smart buttons may be used to select the Unit s or Set Memberships specifications respectively For example if you click on the Unis button when the cursor is positioned in column E for a row in which the Component in column B is T Process the form shown below will be displayed allowing you to specify the Process Activity Unit and Process Capacity Unit that apply for the Process the form is shown after you have selected PJ GW respectively Specify Process Activity Process Capacity Units Specify the Process Activity Unit in the left treeview specify the Process Capacity Unit in the right treeview and then click on the OK button E Process Activity U Process Capacity 000 US million dollars 2000 L5 m billon passenger kilometres anniurn br pass krn
55. of the ACT BND parameter Argi must occur on either the ITEMS sheet or in the associated database and must be a Process Also the Argument must satisfy any Set Memberships requirements For an Argument such as for the Process Component that can be specified on the ITEMS sheet or may already occur in the associated ANSWER TIMES database checking is carried out as follows for clarity of explanation we suppose that the Argument being checked has ltem Name E01 and must be a Process e First the ITEMS sheet is checked to see whether it contains a Process with Item Name E01 If it does then the associated database is not checked However other checking of E01 is carried out a Are its Set Memberships as specified on the ITEMS sheet appropriate for the Parameter b Does the Region List for E01 as specified on the ITEMS sheet embrace every region in the Region List on the TS DATA sheet that applies to the Parameter e lf the ITEMS sheet does not contain a Process with Item Name E01 then the associated database is checked to see if it contains such an Item This checking is carried out for every region in the Region List on the TS DATA sheet that applies to the Parameter In addition the Set Memberships as specified in the associated database are checked for appropriateness for the Parameter Noble Soft Systems Pty Ltd 2005 11 October 2011
56. ok Setup Anyone wishing to work with an ANSWER TIMES Smart Excel Workbook must create an ANSWER TIMES Smart Workbook to start See Appendix A for more information on the various ways in which this can be done In addition note that the functioning of some of the macro facilities in the ANSWER TIMES Excel Workbooks requires that ANSWER TIMES be installed on your computer Upon opening a Smart Workbook depending on your Windows security level setting you may be prompted by the security warning below Security Warning C answerlTIMesve Ans WrkTTSmartDemoMultiRegion xls contains macros Macros may contain viruses It is usually safe to disable macros but if the macros are legitimate you might lose some Functionality M Enable Macros More Info Select Enable Macros so that the smart buttons are made available Once you select Enable Macros you will be prompted to specify an ANSWER TIMES database that will be associated with the workbook Specify ANSWER Database Specify ANSWER database used to provide Parameter Units and Years information E BrOWSse Ci answerTIMesv lansiver Databases EmptyDemoMultinegion v 7 2 mdb Cr 4nswerTIMESv answer atabaseslUtopia emo UC Data mdb Ci 4answerTIMESv answer Databases Retirement OFC Capacity Demno mdb CUANSWER TIMES SMART LS ANSWER TIMES ver66eL5 Library testing Example4 y666 Library Er Cr 4nswerveFlexTS Library Answer Databases B45E ETP 10
57. ons This is the case because in version 6 7 of the ANSWER TIMES Smart Excel Workbooks there are no linked references in Data sheets to Names of TimeSlices Commodities Commodity Groups Processes or Constraints that occur on the ITEMS sheet Note also that every worksheet has a Check Sheet smart button that may be clicked at any time to have a standard set of consistency and quality control checks performed Version 6 7 does not allow inheritance down columns B E and F of Component Units and Set Memberships on the ITEMS sheet Component Units and Set Memberships must be specified in columns B E and F of each row on the ITEMS sheet But it does allow inheritance down column A of the region list on all sheets except the TRADE sheets where a single region must be specified in column A of each row and also in column B of each row In the sections that follow each sheet is presented with the buttons explained Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 4 REGIONS Sheet The REGIONS sheet is where the Internal and External Regions are named and described and their Set Memberships information is declared An example REGIONS sheet is shown below ANSWER s special GLOBAL region is pre defined on the sheet in row 8 U Sa See D REGIONS GLOBAL DEMO UTOPIA JMPEXP MINRNYY Set Memberships Description Set Memberships Comment Special regio
58. orkbooks to be imported 4 Adjust the Target Scenario combobox to select the target scenario for the import 5 Adjust the radio button and checkbox Options to suit your particular needs 6 Click on the Import button to carry out the import If at step 1 above you are unable to open the ANSWER TIMES database and get a message ending in Perhaps it is already in use most likely this database is already in use because you have an open Smart Excel Workbook and this database is associated with it So simply close the Smart Excel Workbook so that the database is no longer associated with it and hence no longer in use Most users will have a number of Smart Excel Workbooks and will often find it convenient to load several Workbooks in a single Import operation To facilitate multi selection of Smart Excel Workbooks at step 3 above store all Workbooks in a single folder Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERV6 TIMES Smart Excel Workbook Manual version 6 7 22 13 Example ANSWER TIMES Smart Excel Workbook To provide users with a concrete example of an ANSWER TIMES Smart Excel Workbook that demonstrates the specification in its entirety of a multi region TIMES model the file SmartDemoMultiRegion xls is provided as part of the ANSWERv 6 TIMES installation files in folder C AnswerTIMESv6 Ans_WrkT1 Also an empty ANSWER TIMES version 6 7 database EmptyDemoMultiReg
59. rt button This brings up a TS and TID Trade Parameter selection list as shown below Select 75 or TID Trade Parameter Name will be transferred to ActiveLell Sets Filter All Data Parameters x TS TID Global Set Memberships E IRE_BND Limit on inter regional exchange of commodity E IRE COVT Commodity unit conversion factor between regions IRE_FLO Efficiency of exchange For inter regional transfer IRE_PRICE Price of importfexport IRE_TSCVT Identification and T3 corersion factor between regions TOP_IRE Trade within area of study Set Bath TS and TID P t Specify Param Specify Param a an arameters Parameters Shown Excluded em RTE Eae ARE Cancel The mechanics of selecting the desired Parameter and specifying its Arguments and the operation of the Check sheet button are exactly the same as for the TS TRADE and TID TRADE sheets Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 21 12 Loading a Smart Excel Workbook into ANSWER TIMES The File Import Model Data from Excel facility is used to load information in a Smart Excel Workbook into an ANSWER TIMES database A brief overview of the steps involved in using this facility follows 1 Open the ANSWER TIMES database into which you wish to import the Smart Excel Workbook 2 Invoke File Import Model Data from Excel to bring up the following form initially
60. tain the comma delimited Region List that is specified in the combobox Also realize that the user can edit the contents of cell B1 at any time after the smart sheet is created to change the Region List 6 Click on the Add Sheet button 7 The new smart sheet is created and the Add New ANSWER Smart Sheet form remains open so that the user can add another smart sheet as follows B D z F G H J K E M 1 ITS DATA _GLOBAL REG1 REG2 REGS IMPEXP MINRNVYY Check Sheet Parameter Argi Arg Arg3 Argt Arg5 Arg LE Opt LE Opt Parameter Argi Arg2 Arg3 Arg4 Arg5 Arg6 Add New ANSWER Smart Sheet to XLS Select ANSWER Smart Sheet to be added to XLS REGIONS ITEMS TID DATA TS amp TID DATA TS TRADE TID TRADE TS amp TID TRADE Specify Region List to be added to cell B1 of Sheet _GLOBAL REG1 REG2 REGS IMPEXP MINRNW v M M KOT KOT nol ROT RT nol nof 2 3 3 3 a 2 gt mal onl cml gel co 1 Co I CA e 03 Ny SS co col a I 1 na S Z By default the name given to the smart sheet that is created will be the same as the name in the listbox so for example a TS DATA sheet will be given the default name TS DATA If the default name is already being used for another sheet then 2 is appended and used as the name for the sheet so for example TS DATA 2 If the name with 2 appended is already being used for another sheet then instead 3 is appended so for exampl
61. to create a renamed copy will result in the renamed copy being aware of ANSWER TIMES Smart Workbook facilities There are two ways of carrying out the copy e Open the existing XLS in Excel and use File Save As to resave with another name or e Use Windows Explorer to make a renamed copy of the XLS Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERvE6 TIMES Smart Excel Workbook Manual version 6 7 29 In either case all cell references links will be associated with the new file name Depending upon your reasons for creating a new workbook by copying an existing workbook consider what changes may be needed in the newly created copy For example consider whether the Region specified in cell B1 on each of the ANSWER TIMES smart sheets may need to be adjusted A 4 Updating an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER TIMES Smart XLS To provide additional ANSWER TIMES Smart Workbook facilities or to correct bugs that are detected from time to time Noble Soft will distribute a new version of the ANSWER TIMES Smart XLS For example in due course a new version ANSWER TIMESver6 8 XLS will become available that provides additional facilities and corrects bugs in this current version ANSWER TIMESver6 7 XLS When this occurs all that will be required to update your existing version 6 7 ANSWER TIMES S
62. use the filter Electric to select those Processes whose Description ends with Electric use the filter Electric e The Name Filter checkbox and textbox operate in an exactly similar fashion to the Description Filter checkbox and textbox e Itis possible to specify a compound filter that involves both a Name and a Description Filter that are applied with a logical AND or OR For example to select those Processes where the Name ends in E or where the Description contains Electric check the Name Filter checkbox and enter E in its textbox select the OR option Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 7 37 button check the Description Filter checkbox and enter Electric in its textbox and Apply Filter then click on the button Select Process Name will be transferred to Active Cell Sets Filter All Processes PRC Name and Description Filter Name Filter Like E C AND OR M Description Filter Like Electric Regionis BITRADE ELT z DEMO UTOPIA Bilateral Trade in Electricity E01 z DEMO UTOPIA Coal Steam Electric E31 z DEMO UTOFIA Hydro electric Plant ESZ z DEMO UTOPIA Hydro electric Plant 2 renewable RHE 2 DEMO UTOPIA Electric Boiler SRE 2 DEMO UTOPTA Oil Refinery TAE 2 DEMO UTOPIA Electric Car e The Name and Description Filter is always used in conjunction with the current setting of the Sets Filter combobox
63. weight PRY B Material by volume PR B Miscellaneous MISC T Import Export IRE Night Storage NST T Storage not NST or STK STGTSS The Check sheet button may be pressed at any time to have a standard set of consistency and quality control checks performed The results of the checking are presented in a Wordpad file as shown below and any offending cells are highlighted on the sheet in yellow along with a cell comment indicating the nature of the problem Z CheckSummary Log WordPad File Edit wiew Insert Format Help Deh li A 5a amp Summary Log File created on Friday 14 October 2011 at 05 25 PH CHECK ITEMS SHEET ITEMS GLOBAL DEMO UTOPIA INPEXP MINRNW Check Cell El Region Region List The Region Region List in cell El is OF Check Column amp Regions Region Lists 411 colum 4 region region list gt are OF Check All Item Components All of the Components in the Component column are Check 411 Item Names All of the Names in the Name column are OE Check For Duplicate Item Names There is no Duplication of Reqion List Name in column 4 and the Name column Check 411 Item Descriptions All of the Descriptions in the Description column obey ANSWER conventions Check 411 Item Unites 111 of the Units in the Units column are valid Check 411 Item Set Memberships All of the Set Memberships in the Set Memberships column are valid For Help press F1 Noble Soft Systems Pty Ltd 2005 11 October
64. with the Excel Files to be Imported list empty and not necessarily with either the Target Scenario or Options settings that are shown below NI Import Model Data from Excel TER a Import Model Data from Excel allows Item T5 and TID data in one or more Microsoft Excel Files to be K u imported into an existing ANSWER database Excel Files to be Imported C WAanswerlIMESvb 4ans Wirk T Smart emoMutA egion xls Remove Remove Al Add U Dr Jw Excel Files contain Interpolate E xtrapolate Option Codes Column Regions Target Scenario BASE Before Import Delete Online Results involving Target Scenario Options jw Strang Checking of TS and TID Data Parameters f Menge Overnite information in the Target Scenario with that on Sheets being Imported Details Before Import Delete Parameter information in the Target Scenario far lteme on Data Sheets Detaile Before Import Delete All Information in the Target Scenario for Regionf being Imported Details Prompt user to decide whether to Import for each Excel File that has errors Import only from Excel Files that are error free without prompting Import error free records from all Excel Files without prompting 3 Click on the Add button to bring up the common dialog file selection form and navigate to the folder in which you have stored the Smart Excel Workbook s then select one or more Smart Excel W

ANSWERv6-TIMES Smart Excel Workbook - Noble

Contents

Download Pdf Manuals

Related Search

Related Contents