Home

ANSWERv6-TIMES Smart Excel Workbook - Noble

1. 22 13 Example ANSWER TIMES Smart Excel Workbook esses 23 Appendix A Establishing a New ANSWER TIMES Smart Workbook 26 A 1 Creating a new empty ANSWER TIMES Smart 26 A 2 Making an existing workbook aware of ANSWER TIMES Smart Workbook facilities EP PEERS 28 Copying an existing workbook that is already aware of ANSWER TIMES Smart Workbook facilities to create a new 2 20 000000 0 0 000000000000 000 29 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 HMES Smart XEM a 30 5 Adding New ANSWER TIMES Smart Sheet to the Current XLSM 30 Appendix B Details regarding the operation of the Parameter selection form the Parameter Argument selection form and Check Sheet Parameter checking 33 B 1 Operation of the Parameter Selection Form displayed after clicking on Parameter liie pP 34 B 2 Operation of the Parameter Argument Item Selection Form displayed after clicking ATOT AlOG DUMONS mE 36 Check Sheet Checking for a Data
2. 39 Noble Soft Systems Pty Ltd 2005 12 October 2012 ANSWERve6 TIMES Smart Excel Workbook Manual version 6 8 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 spreads
3. WwirkTI SmartDemoelMultiBegianvb B slem Excel Files contain Interpolate Extrapolate Option Codes Column Target Scenaro 5 Before Import Delete Online Results involving Target Scenario Options Strong Checking of T5 and TID Data Parameters Details Mernge Overarite information in the Target Scenario with that an Sheets being Imported Details Before Import Delete Parameter information in the Target Scenario far Data Sheets Details Before Import Delete All Information in the Target Scenario for Region s being Imported Prompt user ta 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 fram 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 Workbooks 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 datab
4. 1 25 COM TX DEM 1 27 COM NRG 1 28 ELC 5 1 29 G NRFR 2 2 E ANNUAL 1 3t G YRFR 8 FA 0 25 3 G_YRFR FAD 0 167 22 G_YRFR 0 083 J3 G YRFR SP 0 25 34 G YRFR SPD 0 167 35 G NRFR 3 SPH 0 083 3b G NRFR 2 SU 0 25 sn G NRFR 8 SUD 0 18 38 G NRFF SUN 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 Activet ell ACT Bound an cumulative pr civit i CM CONST Climate module constants TID GLOBAL Climate CM HISTORY Calibration values For CO and Forcing TID GLOBAL Climate COM CLIMMNET Cumulative net bound on commodity e g emissions TID COM CLUMPRD Cumulative limit on production of a commodity TID COM Commodity and commodity group Set TID COM LIM List of equation type For balance Set TID Periods For which commodity is unavailable Set TID COM PEAK Peaking required Flag Set TID COM PKTS Peak timeslice For a commodity group Seb TID COM STEP Step size For elastic demand TID Elastic Demand DAM BOTY Base quantity of emissions TID Damage ELAST Elasticity of damage cost TID Damage STEP Step numb
5. 1 mill mn mcm m mn ri Only TS Parameters Specify Param Specify Param y Parameters Shown Excluded and args Preserve args Cancel Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 13 Specify Param Select the desired TS Parameter and normally click on the cca button Then use the oan through to ee buttons and the LI button as appropriate to specify the Arguments and the 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 iiit through to ELM 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 Cae ther Burmary Log File created on Friday 14 October 2011 at 05 31 PM CHECK TS DAT
6. a comma separated region list is not allowed IMPEXP REG TOP IRE IMPDEL1 DSL DSL 1 12 RE TOP_IRE 1 GAS GAZ 1 13 REG TOP IRE 1 GSL GSL 1 REG TOP IRE Ih PHCO1 1 REG TOP IRE 1 REG1 TOP IRE IMPOR 1 REG TOP IRE Ih PD L1 DSL DSL 1 REG TOP IRE Id pcs m1 GAS GAS 1 REG TOP IRE lt 11 GSL GSL 1 21 REG TOP_IRE IMPHCO1 1 22 REG TOP_IRE iL 1 IMPEHP REG TOP IRE IMPLIRNT LIRN URN 1 2a 25 REGJ IMPDSL1 DSL DSL 1 zb IMPEXP TOP IRE MPsAS1 GAS GAS 1 27 IMPEXP TOP IRE lt 11 GSL GSL 1 IMPEXP REGS TOP IRE IMPHCO1 s 5 s Hoo 1 29 IMPEXP REGJ TOP IRE IMFILT 1 30 IMPEXP REGJ TOP IRE 1 71 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 Activetell Sets Filter All Data Parameters TS TID Global Set Memberships IRE CCVT Commodity u
7. button row 59 will appear as follows E CREE Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 35 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 Useofthe Sets Filter combobox may be beneficial when the Parameter Selection Form has been invoked from the TS DATA or TID DATA or TS amp TID DATA worksheets 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 Eransferred Ea ActiveCell Sets Filter All Gata Parameters Mame All Data Parameters Excluding Parameters For TIMES Extensions ACT BNO Climate Data Parameters k 4 Damage Data Parameters a Discrete Capacity Investment Data Parameters ACT EFF
8. CHECK REGIONS SHEET REGIONS GLOBAL UTOPIA INPEXP MINRNW Check Cell B1 Region Region List The Region Region List in cell B1 OK Check All Region Names 11 column region 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 F1 Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 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 EX Component Comp Hame DEMO UTOPIA D ACTGRP DEM NRG H H GLOBAL DEMO UTOPIA W ANNUAL FAD FAN SP SPD SPN SU SUD SUN wi WID WIN zzzzzzzzzzzz CD CD CO N2 2 OT ND IND ND ND ee gt J C M O CO CO 9 CO CO CO 7 Commodity Items for DEMO UTOPIA regions 33 DEMO UTOPIA ______ E cO2 E ELC HY
9. button are exactly the same as for the TS DATA and TID DATA sheets Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 17 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 SEI UTERE ERR TS TRADE GLOBAL REGIT REG2 REGS IMPEXP Parameter Argi Arg Arg3 Arg5 Arg vE op Region Region2 Parameter Argi 4 Arg5 Arg6 LE Opt 3 Check Sheet TS TRADE sheet a single region must be specified in column comma separated region list is not allowed 11 REG1 IMPEXP IRE_PRICE IMPDSL1 DSL ANNUAL l IMP 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 IRE PRICE HCO ANNUAL IMP 0 2 2 2 15 IRE PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 16 IRE PRICE IMPURN1 URN ANNUAL l IMP 0 2 2 2 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 IM
10. 13 14 15 16 Single region n p Multi region no common 419 naming across regions 20 Multi region common 21 naming across regions 22 23 24 25 26 Add New ANSWER 27 TIMES Smart Sheet to 28 Current AL 5M 29 M 4 H ANSV6 8 Home J d Ready Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 29 Retain the selection of the Multi region common naming across regions radio buttons and then click on the Update XLS to ANSWER Smart XLSM Version 6 8 button This brings up the following form Update XLS file to ANSWER Smart XLSM version 6 8 X Filename of XL5 to be updated Filename given to ANSWER Smart 5 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 xlsm Use the Browse button to select USER xlsm The form now appears as follows Update XL5 file to ANSWER Smart XLSM version 6 8 X Filename of XL5 file to be updated C AnswerTIMESv6 Ans_WrkTI USER Filename given to ANSWER Smart XL5M created by update C MnswerTIMESv6lAns v6 8 xlsm The default filename given to the ANSWER smart XLSM that will be created by the update is taken to be the filename of the XLS to be updated with v6 8 appended So above v6 8 i
11. 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 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 34 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 __ operation of the Form button is extremely similar as is the Here the operation of the 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 he transferred to ActiveCell Mir E Bound an activity of a process E COST Variable costs associated with activity of a process EFF Activity efficiency For process CAP Bound on total installed capacity a period EXOFORC Radiative Forcing From exogenous sources GLOBAL Climate CM LINFOR Linearized Forcing Function parameter GLOBAL Climate CM MAXC Maximum allowable climatic quantity GLOBAL Climate COM AGG Commodity aggregation parameter COM BMDMET Met bound an commodity e g emissions COM BNDPRD Limit on production af commodity CSTMET Cost an of commodity e g emissions bax Cost on producti
12. Elastic Demand Data Parameters CAP BNO Endogenous Technology Learning ETL Data Parameters CM and Time Stepped Data Parameters _ Specify Params buttons Specify Param Two buttons are provided to the left of the button a button anda Specify Param Preserve Args button Specify Param e 8 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 ue button the one immediately to the left of the button can be useful if you have 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 1 1 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 36 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 ELM through to Arg m buttons is extremely similar as is the operation of the Form Here the operation of the Parameter Argu
13. It is not possible to determine that this content came from a trustworthy source You should leave this content disabled unless the content provides critical functionality and you trust its source More information File Path 9 C AnswerTIMESv6 Ans_WrkT1 SmartDemoMultiRegion xlsm Help protect me from unknown content recommended C Enable this content Open the Trust Center iEnable thi tent then click on the option button and click on the OK button In the remainder of this document we refer to this process as Enable Macros Once you have carried out the Enable Macros process you will be prompted to specify an ANSWER TIMES database that will be associated with the workbook Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 ANSWER Database Specify ANSWER database used to provide Parameter Units and Years information E Browse CH danswerTIMesyv lansiver Databases EmptyDemoMultinegion v 7 2 mdb CH answerTIMESyv6 answer Databases Utopia_Demo Data mdb CilAnswerTIMESvetlAnswer Databases RetirementOrCapacityDermo mdb CLAN SWER TIMES SMART LS ANSWER TIMES ver66el5 Library testing Example4 v668 Library Er Cr 4nswerveFlexTS Library answer Databases ETP 10 mdb CLAN SWER TIMES SMART LS ANSWER TIMES ver66el5 Library testing Example4 v668 Library rr L ancel You should always s
14. OIL ANNUAL 0 1 1 1 COM IE URN ANNUAL 0 1 1 1 COM PKFLX ELC FAD 0 0 2 0 2 02 COM PKFLX ELC SPD 0 02 02 02 To specify Time Series Data Parameter position the cursor column of a row below row 7 and press the Parameter smart button This brings up a TS Parameter selection list as shown below Select 5 Parameter Name will he transferred to ActiveCell ESEACT BND E COST Variable casts EHE vat activity of a process EFF Activity efficiency For process CAP BMD Bound on total installed capacity a period CM EXOFORC Radiative Forcing From exogenous sources GLOBAL Climate LIMFOR Linearized Forcing Function parameter GLOBAL Climate CM MAXC Maximum allowable climatic quantity GLOBAL Climate AGG Commodity aggregation parameter BMDMET Net bound an commodity e g emissions BMDPRD Limit on production of a CSTMET Cost on of commodity e g emissions CSTPRD Cost an production of a commodity ELAST Elasticity of demand Elastic Demand ELASTx Elasticity shape of demand Elastic Demand COM FR Seasonal distribution of a commodity IE Seasonal efficiency of a commodity COM PKFLX Peaking Flux ratio COM PKRSV Peaking reserve margin PROJ Demand baseline projection SLIBNET Subsidy an a commodity net E COM SUBPRD mec on production of commodity net zh ee
15. 8 32 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 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 XLSM 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 contain 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 Click on the Add Sheet button 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 C D E E G H J K L M TS DATA GLOBAL REG2 REG3 IMPEXP MINRNW Check Sheet Parameter 2 Arg3 Arg4 Arg5 Arg6 Parameter Arg1 Arg2 Arg3 Arg4 Arg5 Arg6 VE Opt 2 3 4 5 6 T 8 9 Add New ANSWER Smart Sheet to XLSM x Select ANSWER Smart Sheet to be added to XLSM TID DATA TS
16. 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 REG3 IMPEXP MINRNW v 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 example TS DATA 3 and so on To add another smart sheet to the XLSM 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 Click on the Close button to close the Add New ANSWER Smart Sheet form Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 33 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 mechanic
17. might also wish to carry out Run Model Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 26 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 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 XLSM A 5 Adding a new ANSWER TIMES smart sheet to the current XL SM A 1 Creating a new empty ANSWER TIMES Smart Workbook To create a new empty ANSWER TIMES Smart Workbook open the file ANSWER TIMESver6 XLSM distributed by Noble Soft for example open ANSWER TIMESver6 8 XLSM Then carry out the Enable Macros process see page 3 to bring up the single visible sheet of ANSWER TIMESver6 8 XLSM as follows 22 E eH a Home dnsert Page Layout Formulas Data Review View m ox EX s Will E m RR ka Fibs ar Number Styl
18. 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 Areits Set Memberships as specified on the ITEMS sheet appropriate for the Parameter 0 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 1 1 October 2011
19. 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 31 LUSERv6 S xIlsm Microsoft Excel e Home a Insert Fage Layout Formulas Data Review View X m mE BO UA m ome g d Paste UM Ses Cea Number Styles Cells ome s 2 Clipboard E Font Alignment Editing 5 8 1 4 1 2 3 4 Create New ANSWER Smart XL Version cH 6 0 7 9 10 Update XLS file to 11 ANSWER Smart 12 XL 5M Version 6 4 13 14 15 16 C Single region Multi region no common 19 naming across regions 20 lt Multi region common 21 ec across regions 22 23 24 25 Add New ANSWER 2T TIMES Smart Sheet to 28 Current 5M 29 3 Click on the Add New ANSWER Smart Sheet to Current XLSM button This brings up the following form Add New ANSWER Smart Sheet to XL 5M Select ANSWER Smart Sheet to be added to XLSM Specify Region ist to be added to cell B1 of Sheet _GLOBAL REG1 REG2 REG3 IMPEXP MINRMW 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
20. 5 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 28 The form remains open so that additional new ANSWER TIMES Smart XLSM files may be created if desired Click on the Close button to close the Create New ANSWER Smart XLSM form Close ANSWER TIMESver6 8 XLSM When you open any of the new ANSWER TIMES Smart XLSM files that you have created you will need to use the Add New ANSWER Smart Sheet to Current XLSM button to add sheets to the XL SM 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 8 XLSM distributed by Noble Soft Then carry out the Enable Macros process see page 3 to bring up the single visible sheet of ANSWER TIMESver6 8 XLSM as follows Da E Home Insert Page Layout Formulas Data Review View x gt amp 10 id zem aj E x m aa EE UA a 4 Eee d Paste 3 perpe umber les ells B Jle Ej an Fant E Alignment uj Editing cQ SO 1 ANSv6 8 Home 2 3 4 Create New ANSWER 5 Smart XL 5M Version 6 6 8 7 9 10 Update 5 file to TE ANSWER Smart 19 ALSM Version 6 8
21. A 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 CO CO CO CO CO DFMO IITOPT Diesel Rniler PRC DMD DAYNTTF Select from ITEMS Sheet Process Set Memberships Restrictions For Select from Database Select fram ITEMS Sheet 7 Select From Database An important 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 Fram 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 Mec d ine yee rs aor i 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 fi
22. A SHEET TS DATA DEMO UTOPIA Check Cell B1 Region Region List The Region Region List in cell B1 is OK Check Column Regions Region Lists ll column region region lists are OK Check Rows specifying TS TID DATA Parameter instances 11 of the Rows specifying Parameter instances are OK For Help press F1 Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 14 T 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 E TID DATA DEMO UTOPIA 2 3 Check Sheet Parameter Aral ArH Parameter Argi Arg4 Arg Arg Value B 9 DATA for DEMO UTOPIA regions 10 DEME UTOPIA COM CO2 1 11 COM 2 DSL NRG 1 12 COM DSL RHG IM 1 13 COM DSL SRE G 1 14 COM ELC OUT 1 15 COM ELC NRG 1 15 COM GAS NRG z 1 14 COM GAS RHG IM 5 1 18 COM s GSL NRG E 1 19 COM GSL SRE G 1 20 COM 2 HEO NRG 1 21 COM HYD NRG 1 22 COM OlL NRG 5 1 23 COM DEM 1 24 COM 41 QUT E 1 25 COM RL DEM
23. ANSWERv6 TIMES Smart Excel Workbook Manual Excel 2007 and higher version 6 8 October 2012 Noble Soft Systems Pty Ltd Noble Soft Systems Pty Ltd 2005 12 October 2012 6 5 Smart Excel Workbook Manual Excel 2007 and higher version 6 8 Table of Contents ACKDOWIeOGeImenls ut ac LEN Portus 2 le BACKI OUN mM 2 Zs SOLO uec tiis eet uuu MMC MM M EIU MEUM 3 3 Worksheet Layo t and PhiIltSophty xcti cies taedis tuer ep eti n dea etae ges aai 5 3 1 Role and Operation of smart buttons ANSWER TIMES Smart Worksheets 6 d REGIONS SNOL curi 7 SATE SINS CL ai eoe UEM III 9 e ume Senes Data 1S DATA SNOET dat rs P Ea E EE 12 7 Time Independent Data TID DATA o t a e po bor e tad de EIS 14 8 Time Series amp Time Independent Data TS amp TID DATA 16 9 Time Series Trade Data TS TRADE 17 10 Time Independent Trade Data TID TRADE 19 11 Time Series amp Time Independent Trade Data TS amp TID TRADE Sheet 21 12 Loading a Smart Excel Workbook into
24. D mmm rmm zu DEMO UTOPIA IMPEXP DSL mmm m m I e 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 Cn OF 0 OF OF OF con cen E t E E 4 4 IE BUCO CO GG CO J 7 9 54 9 CO O9 CO CO E C _GLOBAL DEMO UTOPIA IMPEXP Description Activity related Group Demand Commodity Type Environmental Commodity Type Financial Commodity Type Material Commodity Type Energy Commodity Type TimeSlice Items for _GLOBAL DEMO UTOPIA regions Annual Fall Fal Day Fall Night Spring Spring Day Spring Might 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 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 COM GRPDEF COM GRP COM GRPDEF COM GRP COM GRPDEF COM GRP COM GRPDEF COM GRP C
25. ES Smart Excel Workbook Manual version 6 8 18 Then use the through to me buttons and the LI button as appropriate to specify the Arguments and the 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 through to ns 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 you specify parameter IRE PRICE row 32 but forget to specify Region and Region2 in cells A32 and B32 Then the Wordpad file will be as follows rhecksummary Log WordPad File Edit View Insert Format Help Dk amp S Summary Lag File created on Monday 17 October 2011 02 34 CHECK TS TRADE SHEET Trade TSData GLOBAL REG1I REGZ REGS IMPEXP MINRNW Check Cell B1 Region Region Li
26. G EXT The information entered on the REGIONS sheet that is directly provided by the user are the Region Names and Descriptions appearing in columns 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 5et Memberships smart button to select Internal or External from the Region Set Memberships form shown below where the user has selected Internal Region Set Memberships To specify Set Memberships click on the appropriate leaf node in the LHS treeview adjust the RHS Additional Characterization as necessary and then click on the 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 8 8 El CheckSummary Log WordPad File Edit View Insert Format Help Deh amp amp d 5 RS summary File created on Friday 14 october 2011 at 02 437 PM
27. ID 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 Items Declare ITEMS 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 oee 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 section 9 Time Independent Data TID TRADE TIMES Time Independent Data Bilateral Trade Parameters that have two region indexes Data are specified See section 10 Time Series and Data TS amp TID TRADE TIMES Time Series amp Time Independent Time Independent Data Parameters
28. IMESv6 Ans Organize folder Hz F M 3r Favorites Name Date modified Type Size BE Desktop 554 basebrSEv6 8 xlsm 5 10 2012 9 45PM Microsoft Office Exc 925 KB 8 Downloads USER 5 10 2012 7 48PM Microsoft Office Exc 502 KB 221 Recent Places USERv6 8 xlsm 2 10 2012 6 22PM Microsoft Office Exc 1 199 55 smartDemoMultiRegio 2 10 2012 5 37PM Microsoft Office Exc 502 KB test xlsm version xlem 1 10 2012 10 31PM Microsoft Office Exc 766 KB Homegroup utopia_demov 7 xlsm 1 10 2012 10 02PM Microsoft Office Exc 1 001KB 188 Computer E S3A8048D003 C 4021 File name SmartDemoMultiRegion Save as type Microsoft Excel File xlam Hide Folders Click on the Save button The full filename of the new XLSM to be created will appear in the Filename of XLSM to be created textbox as follows Create New ANSWER Smart XL 5M version 6 8 Filename of XLSM to be created C MnswerTIMESv6MAns WrkTIYsmartDemoMultiRegion xlsm An alternative to using the Browse button to specify the full filename of the new XLSM is to key the full filename into the textbox but using the Browse button is recommended Click on the Create button The creation process will proceed concluding with a message box indicating that the creation of the new XL SM has been completed Noble Soft Systems Pty Ltd 200
29. OM GRPDEF COM GRP COM GRPDEF ALL TS AHHUAL ALL TS SEASON ALL TS DAYHITE ALL TS DAYHITE ALL 5 5 5 ALL TS DAYHITE ALL TS DAYHITE ALL 5 5 5 ALL TS DAYHITE ALL TS DAYHITE ALL TS SEASON ALL TS DAYHITE ALL TS DAYHITE COM EHV AHHUAL GHG COM HRG DAYHITE EL C COM HRG AHHUAL FREREHEW COM DEM AHHUAL IHD COM DEM DAYHITE RES COM DEM AHHUAL RES COM DEM AHHUAL TRH Commodity Items for DEMO UTOPIA IMPEXP regions ANSWER requires Commodity Items to be specified in External Regions involved in Import Export COM HRG AHHUAL FOSSIL COM HRG AHHUAL FOSSIL COM URG ANNUAL FOSSIL COM HRG AHHUAL FOSSIL COM HRG AHHUAL FOSSIL COM URG ANNUAL 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 appearing in columns B C and D respectively Initially the user may
30. PEXP IRE PRICE IMPHCO1 HCO ANNUAL l IMP 2 2 2 REG2 IMPEXP IRE PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 REG2 IMPEXP IRE PRICE IMPURN1 URN ANNUAL IMP 0 2 2 2 gt REG3 IMPEXP IRE PRICE IMPDSL1 DSL ANNUAL l IMP 0 10 10 10 REG3 IMPEXP IRE PRICE IMPGAS1 GAS ANNUAL IMP 0 6 4 6 4 6 4 REG3 IMPEXP IRE_PRICE IMPGSL1 GSL ANNUAL IMP 0 15 15 15 REG3 IMPEXP IRE_PRICE 1 ANNUAL 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 pde To specify a Time Series 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 smart button This brings up a TS Trade Data Parameter selection list as shown below Select 5 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 ers Efficiency of exchange For inter regional transfer IRE_PRICE Price of import export Only TS P t Specify Param Specify ny arameters m Parameters Shown Excluded And args Preserve args Cancel Specify Param Select the desired TS Trade Parameter and normally click on the button Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIM
31. Price of importfexport IRE TSCVT Identification and T5 cenversian 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 cm p 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 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 22 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 with the Excel Files to be Imported list empty and not necessarily with either the Target Scenario or Options settings that are shown below m Import Model Data from Excel m xi A on Import Model Data from Excel allows Item T5 and TID data in one or more Microsoft Excel Files to be X D imported into an existing ANSWER database Excel Files to be Imported Add Hemowv Remove All Up
32. RE 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 IRE PRICE IMPHCO1 ANNUAL IMP 0 2 2 2 IRE PRICE IMPOIL1 OIL ANNUAL IMP 0 8 8 8 IRE PRICE IMPURN1 URN ANNUAL IMP 0 2 2 2 25 REG2 TOP IRE IMPDSL1 DSL DSL 1 25 REG2 IRE IMPGAS1 GAS B p GAS 1 27 IMPEXP REG2 TOP IRE IMPGSL1 GSL z GSL 1 28 REG2 TOP IRE IMPHCO1 HCO 1 29 REG2 IRE MPOLI OIL OIL 1 ET REG2 TOP IRE IMPURN1 URN R URN 1 Bj 32 REG2 IRE PRICE IMPDSL1 DSL ANNUAL IMP 0 10 10 10 33 REG2 IMPEXP IRE PRICE IMPGAS1 GAS ANNUAL l IMP 0 B4 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 smart button This brings up a TS and TID Trade Parameter selection list as shown below Select T or TID Trade Parameter Name will be transferred to Activetell Sets Filter All Data Parameters x TS TID Global Set Memberships S IRE BND Limit an inter regional exchange of commodity IRE CCVT Commodity unit conversion Factor between regions IRE FLO Efficiency of exchange Far inter regional transfer IRE PRICE
33. 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 Arg6 the appropriate button from among the sl through to 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 _ smart button to bring up the Select Limit form Select Limit Name will be Eransferred Eo Active Cell Sets Fiter ints r Name and Description Filter Name Filter Like Description Filter Like Goply Filter Name Regionis Description Set Memberships Bu 1 Fixed LIM BD LIM BD LIM BD ust Include BD Select from Database Select from ITEMS Sheet Limit Set Memberships Restrictions For BND M Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 39 Se ect From 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 databas
34. art 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 Pre defined Commodity Groups cell 10 should contain comma delimited list of all Internal Regions REG1 REG2 REG3 D ACTGRP Activity related Group COM GRP COM GRPDEF D DEM Demand Commodity Type COM GRP COM GRPDEF D Environmental Commodity Type _ GRP COM GRPDEF D Financial Commodity Type COM GRP COM GRPDEF D MAT Material Commodity Type COM_GRP COM_GRPDEF 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 _ 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 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
35. ase is already in use because you have an open Smart Excel Workbook and this database is associated with it 5 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 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 23 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 xlsm is provided as part of the ANSWERv6 TIMES installation files in folder C AnswerTIMESv6 Ans_WrkTI Also an empty ANSWER TIMES version 6 8 database EmptyDemoMultiRegion v68 mdb that has compatible time periods for Import Model Data from Excel is provided in folder CAAnswerTIMESveMAnswer Databases To use SmartDemoMultiRegion xlsm to explore various aspects of how an ANSWER TIMES Smart Excel Workbook operates e If as part of exploring how ANSWER TIMES Smart Excel Workbook operates you intend to change the contents of the ANSWER TIMES Smart Excel Workbook itis sugg
36. d 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 El rhecksummary Log WordPad File Edit Insert Format Help Cad 2a R Eunmary Log File created on Friday 14 october 2011 at 05 54 PH 5 CHECK TID DATA SHEET TID DATA DEMO UTOPIA Check Cell Bl Region Region List The Region Region List in cell is OK Check Column Regions Region Lists ior Check Rows specifying TS TID DATA Parameter instances 11 of the Rows specifying Peremeter instences are OK Y For Help press F1 Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 16 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 3m D E F G H 1 GLOBAL REG1 REG2 MINRNVY Argi Arg Arg3 Arg LE opt LE Opt or Value Parameter Argi Arg2 Arg3 Arg4 Arg5 6 TS a
37. differentiates Global Tab parameters G DYEAR and 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 REGS3 only 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 a new 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 48 by inheritance from row 24 the region list REG1 REG2 REGS3 applies It is not necessary to have an explicit REG1 REG2 REG3 in each of cells A25 to A48 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 REG3 specified in cell A10 But note the use in column A of a single region name of REG1 in
38. e and that are appropriate for the ACT BND Parameter e 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 quality control checks performed The checking that is carried out includes checking that Each Parameter that is specified is a valid Data Parameter e Fora valid Data Parameter each of its Arguments occurring in the Arg1 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 of the ACT BND parameter Arg1 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 Item Name E01 and must be a Process e First the ITEMS sheet is checked to see
39. edom 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 user s flexibility since there is now the choice as to when to use them and when to stay with the TS and TID sheets To some extent the SmartDemoMultiRegion xlsm 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 SmartDemoMultiRegion xlsm f wanting to specify the exact same information Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 24 that is contained SmartDemoMultiRegion xlsm the minimum number 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 Sm
40. er For emissions up to base TID Damage DAM YOC Variance of emissions TID Damage ETL CCAPO Initial cum capacity starting point on learning curve TID ETL ETL CCAPM Maximum cum capacity ending point an learning curve TID ETL ETL PRAT Progress ratio TID ETL ETL 5CO Investment cost corresp to starting point on learning curve TID ETL ETL SEG Number of segments For cumulative cost curve TID ETL ETL TEG Indicates process Far which learning curve is specified Sek TID ETL zh m nina Dmm mmm maa m E n n mac TTF Only TID Parameters Specify Param Specify Param y Parameters Shown Excluded And Args Preserve args Cancel Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 15 Specify Param Select the desired TID Parameter and normally click on the 95 button Then use the _ 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 21 through to _ 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 performe
41. es Cells po _ d Paste 4 mo 1 Clipboard Fant Alignment Jp i Editing A1 1 Je ANSv6 8 Home Y B C D E E G H 1 ANSv6 6 Home 2 3 4 Create New ANSWER Smart 5M Version G 6 6 T 8 9 10 Update 5 file to 11 ANSWER Smart ALSM Version 16 Single region e Multi region no common naming across regions 20 Multi region common 21 naming across regions 26 Add New ANSWER 27 TIMES Smart Sheet to Current ALSM 1751 LIA M 4 k H ANSv6 8 Home 74 A Ready Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 27 Retain the selection of the Multi region common naming across regions radio buttons and then click on the Create New ANSWER Smart XLSM Version 6 8 button This brings up the following form Create New ANSWER Smart XLSM version 6 8 Filename of 5 to be created Use the Browse button to bring up the New ANSWER Smart XLSM common dialog form and if necessary use the LHS of the form to specify the folder where you want the new ANSWER Smart XLSM to be located then key in the filename for the new XLSM in the File name textbox near the bottom of the form as follows i New ANSWER Smart XLSM CJ 12 Computer 53480480003 AnswerT
42. ested that you use Windows Explorer to make copies of both SmartDemoMultiRegion xlsm and EmptyDemoMultiRegion v68 mdb so that you retain copies of both files as originally distributed Open SmartDemoMultiRegion xlsm and carry out the Enable Macros process see page 3 When the Specify ANSWER Database form appears click on the top radio button and then use the Browse button to select EmptyDemoMultiRegion v68 mdb in folder CAAnswerTIMESveMAnswer Databases The following points should be noted about SmartDemoMultiRegion xlsm 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 xlsm but there are some important differences because an ANSWER TIMES Smart Excel Workbook must contain a single ITEMS sheet As noted above SmartDemoMultiRegion xlsm contains the specification in its entirety of a multi region TIMES model An ANSWER 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 fre
43. ghted cell I30 indicates that the commodity name the Arg6 column must be a valid Commodity Item Name for Region REG3 where REG3 is the region specified in the Region2 column cell B30 Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 21 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 TS amp TID TRADE GLOBAL REGI REG2 REGS IMPEXP MINRNVYY Check Sheet 4 Parameter Arg3 Arg LE Opt 5 5 LE Opt Region Region2 Parameter Argi 4 Arg5 Arg6 or Value On TS amp TID TRADE sheet a single region must be specified in column A a comma separated region list is not allowed 49 11 REG1 TOP IRE IMPDSL1 DSL p DSL 12 REG1 TOP IRE IMPGAS1 GAS GAS 13 REG1 IMPGSL1 051 5 GSL 14 REG1 TOP IRE IMPHCO1 i HCO 15 REG1 TOP IRE IMPOIL1 OL z OIL pere REG1 TOP IRE IMPURN1 URN URN 17 gt _ 18 REG1 IMPEXP IRE PRICE IMPDSL1 DSL ANNUAL IMP 0 10 10 10 19 REG1 IMPEXP I
44. heets Excel New ANSWER 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 pdf 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 xlsm that demonstrates the specification in its entirety of a multi region TIMES model is provided as part of the ANSWERv6 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 8 3 2 Wor
45. iption 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 A l Processes PRC Name and Description Filter Name Fiter Like ano Description Fiter Electric Region s BITRADE ELC 2 Bilateral Trade in Electricity E01 2 DEMO LITOPIA Coal Steam Electric E31 2 DEMO UTOPIA Hydro electric Plant ES 2 Hydro electric Plant 2 renewable RHE 2 DEMO UTOPIA Electric Boiler 2 DEMO LITOPIA Eleckric 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 use the filter Electric to select those Processes whose Description ends with Electric use the filter Electric he Name Filter checkbox and textbox operate in an exactly similar fashion to the Description Filter checkbox and textbox e tis 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 o
46. ities 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 8 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 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 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 row 8 Sa CM REGIONS T GLOBAL DEMO UTOPIA IMPEXP Set Memberships Description Set Memberships Comment Special region for data parameters with no REG arg ALL REG Demo region ALL REG REG topia region ALL REG REG region ALL REG REG EXT MINER region ALL REG RE
47. kbook 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 Excel 2007 or higher security settings you may receive a Security Warning indicating that the macro code that underlies the smart buttons has been disabled S5martDemaoMultiRegion xIlsm Microsoft Excel 1297 Home Insert Page Layout Formulas Data Review View I wr General Con amp Arial 110 za s p meum 4 Paste AR mm zm RE vad 38 J B SAT r EE a ang Cell Clipboa Font Alignment Number pl Security Warning Some active content has been disabled Options Options Click on the button to bring up the Microsoft Office Security Options form Microsoft Office Security Options E xl Security Alert Macros amp ActiveX Macros amp Activex Macros and one or more ActiveX controls have been disabled This active content might contain viruses or other security hazards Do not enable this content unless you trust the source of this file Warning
48. mberships FACT BND Bound on activity of a process E ACT COST Variable costs associated with activity of a process ACT Bound on cumulative process activity EFF Activity efficiency Far process CAP BMD Bound on total installed capacity in a period CM CONST Climate module constants GLOBAL Climate CM EXOFORC Radiative Forcing From exogenous sources GLOBAL Climate HISTORY Calibration values Far CO and Forcing GLOBAL Climate CM LIMFOR Linearized Forcing Function parameter GLOBAL Climate CM MAXC Maximum allowable climatic quantity GLOBAL Climate Ass Commodity aggregation parameter COM BMDMET Net bound on commodity e g emissions COM BNDPRD Limit on production of a commodity CSTMET Cost on of commodity e g emissions CSTPRD Cost on production of a commodity CLIMNET Cumulative net bound on commodity e g emissions CLMPRD Cumulative limit on production of commodity COM ELAST Elasticity of demand Elastic Demand ELASTX Elasticity shape of demand Elastic Demand Seasonal distribution of a commadiby Commodity and commodity group Set zh na A Bee Both 5 and TID Parameters vi Parameters Shown Excluded specify Param specify Param 1 And rgs Preserve Args The mechanics of selecting the desired Parameter and specifying its Arguments and the operation of the Check sheet
49. ment Item Selection Form is described with reference to the Select Process Form for the BND example from Appendix B 1 Se NUN Ni TS DATA 2 Check 5heet REG REG REGS Parameter Arg Arg Arg opt Parameter Ar qi Arg Arq3 Ar qe LE Opt ect BMD Process Time Slice E i E Bolo To specify the Process position the cursor in cell C59 and click on the smart button This brings up the Select Process form as shown below Select Process Name will be transferred Eo Active Cell Sets Filter All Processes PRC Mame Description Filter Name Filter Like AND C OR Description Filter Like Apply Filter Regions Set Memberships DEMO UTOPIA Bilateral Trade in Electricity PRC ELE DAYNITE IRE DEMO LITOPIA 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 1 1 IMPDSL1 IMPGAS1 IMPGSL1 IMPHCO1 IMPOIL1 IMPURN1 DEMO UTOPIA Oil Plant DEMO UTOPI
50. n 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 El CheckSummary Log WordPad D GE amp lo X o B8 Summary Log File created on Monday 17 October 2011 at 03 00 PH w CHECK TID TRADE SHEET Trade TIDData GLOBAL REGI REGZ REGS IMPEZP MINENW Check Cell B1 Region Region List Region Region List in cell OK Check 11 Region Names in column 11 column region region lists are OK Check Rows specifying TS TID TRADE Parameter instances 1 rows specifying Parameter instances have problems in rows 30 The yellow cells in each Parameter row indicate where there are problems For Help press F1 and the TID TRADE worksheet will have cell I30 highlighted in yellow as follows B c D o H TID TRADE GLOBAL REGA REG2 REGS IMPEXP MINRMVY Check Sheet Parameter Arg Argi Arg Region Region Parameter Argi Arq Arg4 Arg5 Ar g Value 25 IMPEXP REG3 TOP IRE 1 DSL DSL 1 REG3 TOP IRE 5551 GAZ GAS 1 27 REG3 TOP IRE IPGZL1 BSL SSL 1 JH IMPEXP REG3 TOP IRE 1 1 29 IMPEXP REG3 TOP IRE 1 iL OL 30 IMPEXP REG3 TOP IRE uen 1 The comment associated with the highli
51. nd TID Process Data for Demand Devices Grouped by Process REG1 REG2 REG3 regions TS and TID Data for RHE REG1 REG2 REG3 EFF RHE ELC ANNUAL 0 1 1 1 1 FLO FR RHE RH FX 0 0 18 0 18 0 18 0 18 FLO FR RHE RH 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 FLO 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 0 0 2 0 2 0 2 0 2 ANNUAL UP 0 1 1 1 1 UP 0 null null null r COST RHE 0 12 12 12 12 MCAP TLIFE RHE 0 30 30 30 30 1 1 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 5 56 56 56 FLO_FR RHG RH 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 AchiveGell TSITID Global Set Me
52. nd either or both of these filters beneficial in reducing the number of Process Items that are displayed Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 37 and thereby expediting the selection of the Process Item of interest This pair of Filters may be used for either of the and Bulb 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 Processes PRIC Mame and all Processes Processes Annual Time Slice Level Combined Heat amp Power Processes Processes Day Night Time Slice Level DISTR Distribution Systems Processes 000 ELE Electric Generation Processes _ BITRADEJ 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 Descr
53. need to use the Component smart button to specify the single character Component Letter in column B Noble Soft Systems Pty Ltd 2005 1 1 October 201 1 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 10 Select Component Description Letter CommGroup 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 neg Set Memberships Or smart buttons may be used to select the Unit s or Set Memberships specifications respectively For example if you click on the 2 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 21 Process Activity 1 Process Capacity 2000 US million dollars 200005 billan pagsenger kilometrez annum bn pass km a B billan passenger kilametres bn pass Fm billinr Eonine kilometre
54. nit conversion Factor between regions IRE_TSC T Identification and T5 conversion Factor between regions TOP_IRE Trade within area of study Set lv TID F t Specify Param Specify Param nly arameters Parameters Shown Excluded cms reserve SE Cancel Specify Param Select the desired TID Trade Parameter and normally click on the button Noble Soft Systems Pty Ltd 2005 11 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 20 Then use the through to we 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 through to ns 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 i
55. on of commodity ELAST Elasticity of demand Elastic Demand ELASTX Elasticity shape of demand Elastic Demand COM FR Seasonal distribution of commodity COM IE Seasonal efficiency of a commodity COM PKFLX Peaking Flux ratio COM PKRSV Peaking reserve margin COM PROJ Demand baseline projection SUBNET Subsidy on a commodity net E SUBPRD 2 on DP commodity net zh TLI m Only 5 Parameters Parameters Shown Excluded specify Param specify Param Cancel 4nd Args Preserve Args As has already been explained on the previous page the basic operation of this form is as 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 BND is the selected Specify Param Parameter then after clicking on the 1495 B m TS DATA REG REG REGS Check Sheet Parameter Arce Arg Arg Arg UE opt Parameter Argi Arg Arq3 Ar qe LE Opt ect BMD Process 3 Time Slice Limit
56. pecified 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 XLSM 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 XLSM For example in due course a new version ANSWER TIMESver6 9 XLSM will become available that provides additional facilities and corrects bugs in this current version ANSWER TIMESver6 8 XLSM When this occurs all that will be required to update your existing version 6 8 ANSWER TIMES Smart Workbook to version 6 9 will be to open the file ANSWER TIMESver6 9 XL SM 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 XLSM This facility allows the user to easily add new ANSWER TIMES smart sheet to their current ANSWER TIMES Smart XLSM To use the facility proceed as follows 1 Open ANSWER TIMES Smart XLSM and specify the ANSWER TIMES database to be associated with the Smart XLSM 2 Make the Home sheet the active sheet For a version 6 8 ANSWER TIMES Smart XLSM this sheet appears as follows Noble Soft Systems Pty Ltd 2005 11 October
57. pecify 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 ANSWEH TIMES smart workbook offers an important new facility not available in an ANSWER MARKAL smart workbook the ability to access ltem 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 Items in the database Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERve6 TIMES Smart Excel Workbook Manual version 6 8 5 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 Declare 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 T
58. ption Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERve TIMES Smart Excel Workbook Manual version 6 8 38 button check the Description Filter checkbox and enter Electric in its textbox and Applv Filter then click on the button Select Process Name will be transferred to Active Cell Sets Filter All Processes PRC Mame and Description Filter Filter Like E C AMD OR Description Filter Like Electric Region s BITRADE ELC g DEMO LITOPIA Bilateral Trade in Electricity 01 z DEMO UTOPIA Coal Steam Electric 2 DEMO LITOPTA Hydro electric Plant ESZ 2 DEMO LITOPIA Hydro electric Plant 2 renewable RHE 2 DEMO UTOPIA Electric Boiler SRE 2 Oil Refinery 2 DEMO UTOPIA Electric The Name and Description Filter is always used in conjunction with the current setting of the Sets Filter combobox 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 n particular the user will be able to select such Items as Arguments from either the ITEMS sheet or the associated ANSWER TIMES database Where
59. rkbook Manual version 6 8 12 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 mi uH pue TS DATA DEMO UTOPIA Check Sheet Parameter Argi Arg Arg3 Arg5 VE Opt 6 Parameter Argi Arg2 Arg3 Arg4 Arg5 Arg6 LE Opt 9 TS DATA for DEMO UTOPIA regions DEMO UTOPIA COST E01 0 0 0 0 3 ACT COST E21 0 15 15 15 ACT COST E41 2 0 04 04 0 4 COST E70 0 04 04 04 ACT COST SRE 0 10 10 10 E31 5 LO 0 0 13 0 13 0 13 CAP_BND E31 UP 0 0 13 0417 0 21 E51 UP 0 3 3 3 52 LO 0 0 13 0 13 0 13 CAP_BND E52 i UP 0 0 13 047 0 21 CAP BND SRE LO 0 04 0 0 UP 0 null 4 10 COM FR RL FAD 0 0 2 0 2 0 2 COM FR RL a FAN 0 0 05 0 05 0 05 COM FR RL SPD 0 012 012 012 COM FR RL SPN 0 0 08 0 08 0 08 COM FR RL 500 0 04 01 01 COM FR RL SUN 0 003 003 003 COM FR RL WD 0 0 3 0 3 0 3 COM FR RL VIN 0 012 012 012 COM IE DSL ANNUAL 0 1 1 1 COM IE ELC ANNUAL 0 1 1 1 COM IE GSL ANNUAL 0 1 1 1 COM IE HCO ANNUAL 0 1 1 1 COM IE HYD ANNUAL 0 1 1 1 COM IE
60. row 60 and of REG2 in row 63 and of REG3 in row 66 so that numeric values for the COM PROJ parameter that are region dependent can be specified The Process Data DMD sheet is presented to show TS and TID process data on 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 Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 25 of its TS and TID data rows and then changing the process name and 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 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 be specified on a TS amp TID DATA sheet Note the role of the GLOBAL region to specify the RHS for the Cross Region User Constraint If you use the Import Model Data from Excel facility to import SmartDemoMultiRegion xlsm into EmptyDemoMultiRegion v68 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
61. s appended to USER to provide USERv6 8 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 XLSM form Close ANSWER TIMESver6 8 XLSM 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 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 Open the existing XLSM in Excel and use File Save As to resave with another name being sure to save with a filetype of XL SM or e Use Windows Explorer to make a renamed copy of the XLSM Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERvE6 TIMES Smart Excel Workbook Manual version 6 8 30 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 s
62. s annum bn t km a billion tonne kilometres bn E km T Iw billion ehicle kilametres B v krn milion tonnes mt million tonnes annum mta petajaules PJ petajaules annum Pa pid RID terrajoules annum terrajoules TJ thousand tonnes annum KT al thousand tonnes KT unit of volume for uvala tonnes t unit of weight for Mw Ts annum unit af volume For uwal unit af weight For Pw Ts ut And if you click on the SetMemberships 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 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 11 Specify Process Set Memberships To specify Set Memberships click on the appropriate leaf node in the LHS treeview adjust the RHS Additional Characterization as necessary and then click on the button Set Memberships Process PAC ES Combined Heat amp Power CHF Annual Time Slice Level Demand Device DMD Seasonal Time Slice Level Electric Generation ELE C Energy FRE Heat Generation HPL Material by weight PR Material by volume PR Mi
63. s 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 button exiting the Parameter selection form and causing the Parameter Name and the nature and positions of its Arguments to be written to the previously empty row Positions the cursor in turn in whichever of the Arg1 through to Arg6 columns of this Arg6 row is appropriate and uses whichever of the iit through to 2 iS appropriate to specify the Arguments for the selected Parameter Specifies the Parameter s 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 time to have a standard set of consistency and quality 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
64. scellaneous MISC Import Export IRE Night Storage NST Storage not NST or STK 516755 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 El LhecksSummary Lag WordPad File Edit view Insert Format Help Deh 2 tAn X Summary Log File created on Friday 14 October 2011 at 05 25 PM CHECK ITEMS SHEET ITEMS GLOBAL UTOPIA INPEXP MINRNW Check Cell B1 Region Region List The Region Region List in cell B1 is OK Check Column Regions Region Lists ll column region region lists are OK Check 11 Item Components 11 of the Components in the Component column are Check 11 Item Names All of the Names in the Name column are OK Check For Duplicate Item Names There is no Duplication of i Region List Name in column and the Mame column Check All Item Descriptions All of the Descriptions in the Description column obey ANSWER conventions Check 11 Item Unites 11 of the Units in the Units column are valid Check All 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 2011 ANSWERve TIMES Smart Excel Wo
65. st The Region Region List in cell is OK Check All Region Names in column In column 1 region region lists are not valid in rows 32 Check the yellow cells in column Check Rows specifying TS TID TRADE Parameter instances 1 rows specifying Parameter instances have problems in rows 32 The yellow cells in each Parameter row indicate where there are problems For Help press F1 and the TS TRADE worksheet will have cells A32 and B32 highlighted in yellow as follows C D E H 72 1 TS TRADE GLOBAL REG1 REG2 REGS MINRM A 2 Check 5heet Parameter Arg Arg Arg Opi Region Region Parameter Argi Arg Arg4 Ar ge LE Opt IRE PRICE ANNUAL Noble Soft Systems Pty Ltd 2005 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 19 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 COTES TESI IW m TID TRADE GLOBAL REGI REG REGS IMPEXP Check Sheet Parameter Argi Arg Arg Region Region Parameter Argi Arg Arg4 Value On TID TRADE sheet single region must be specified column
66. that have two region Bilateral Trade indexes are specified Data 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 8 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 1 1 October 2011 ANSWERv6 TIMES Smart Excel Workbook Manual version 6 8 6 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 7 or if the row is completely blank 3 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 workshee
67. ts You can use these buttons to assist in the correct specification of 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 Parameters 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 buttons This is the case because in version 6 8 of the ANSWER TIMES Smart Excel Workbooks there are no linked references in Data sheets to Names of TimeSlices Commod

ANSWERv6-TIMES Smart Excel Workbook - Noble

Contents

Download Pdf Manuals

Related Search

Related Contents