Home

ANSWERv6-MARKAL Load Templates Manual - Noble

1. Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 13 Select TS or TID Commodity Parameter Name will be transferred to ActiveCell Name Description 0 St Memberships a ESE CEQDISTINY Electric distribution investment cost fE D1ISTOM Electric distribution O amp M cost ELC E LCFEQ Fossil equivalent ELC fE RESER Reserve capacity fraction ELC fE TRANINY Electric transmission investment cost ELC fE JTRANOM Electric transmission O amp M cost ELC BAS EILOAD Baseload fraction of total night production ELC DEMAND End use demand DM DHDE Distribution efficiency for low temperature heat DIFF_DM Indicator to use DIFFCOST values during DIFFDMDS algorithm DM DIFFCOST Min IN COST used for all DMDs servicing DM if DIFF_DM DM 1 DM OTRANINY Low temp heat transmission investment cost LTH DTRANOM Low temp heat transmission O amp M cost LTH ELF Fraction of capacity entering peak equations DM EN _BOUND LO Lower Bound on emissions ENY EN BOUND FX Fixed Bound on emissions ENY ENY_BOUND UP Upper Bound on emissions ENY EN COST Emissions tax ENY ENY_CUMMAX Cumulative emissions limit ENY ENY_ENT Emissions coeficient energy carrier ENY ENY_GWP Global Warming Potential multiple emissions accounting ENY EN _MAT Emissions coefficient material ENY EN _MAXEM Bound on emissions upper use EN _BOUND BD with BD UP ENY Both TS and TID Parameters Parameters Shown Excluded Once a
2. Excel Files to be Imported Add Fema Remove All Up C Answer 6S martT emplates qriculture xls Target Scenario CALIE W Before Import Delete Online Results involving Target Scenario Options Strong Checking of TS and TID Data Parameters Details MergeOvernanite information in the Target Scenario with that on Sheets being Imported Details Before Import Delete Parameter information m the Target Scenaro for leme on Data Sheets Details Before Import Delete All Information in the Target Scenario for Regions being Imported Use LIFE to set RESID where just first period RESID If Set IBOND UP 0 where RESID specified Ignore Technology where first pernod RESID 0 ff Create Compulsory Commodity Technology Parameters 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 Close 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 ANSWER smart template s then select one or more smart templates 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
3. It is essential that the Region in Cell B1 of each load template is the same Region as that identified inside the ANSWER database Before getting underway with the new templates you should check the available units and default units settings in your new database and adjust as needed Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 4 3 Worksheet Layout and Philosophy This section briefly indicates each of the six types of smart worksheets managed by the ANSWER load templates as presented in Table 1 They are segregated into two types Declare Declaration and Data and are identified by one of the ANSWER Indicators Commodities Technologies Constraints CommData TechData or ConstrData appearing in cell A1 of the worksheet Table 1 ANSWER Smart Worksheets Worksheet ANSWER Description Indicator Commodities Declare Commodities All the commodities energy carriers materials demands emissions are named and described and their units and set memberships information are declared In version 6 1 and higher taxes and subsidies are also declared on the Commodities sheet See section 10 Technologies Declare Technologies All the technologies resources processes conversion plants and demand devices are named and described and their units and set memberships information are declared Constraints Declare Constraints All user defined constraints ADRATIOs
4. 40 Noble Soft Systems Pty Ltd 2005 07 August 2007
5. Name has a different and more flexible meaning than in version 4 In version 5 and higher it is allowable for a row to have the same Name in column B as for a row above it provided that there is no overlap in the column A region lists in the respective rows Only where two rows have the same Names in column B and where there is overlap in the column A region lists in the respective rows is this considered to be a duplicate Name situation Suppose for example that the user wants to specify that technology XYZ123 occurs in five regions say R1 R3 R4 R5 R8 In version 5 and higher this may be specified on the Technologies sheet in a number of different ways Of course one way is to have a single row with XYZ123 in column B and with this row having region list R1 R3 R4 R5 R8 in column A Another way is to have five separate rows each with XYZ123 in column B and with the first such row having R1 in column A the second such row having R3 in column A etc Since there is no overlap in the region lists of these five rows this does not create a duplicate Name situation Data Sheets Create one or more CommData sheets with cell B1 of each sheet containing the region list REG1 REG2 REGN on which by default the data for commodities in every region are specified If necessary specify a region list in column A to indicate that data for some commodities apply to a subset of regions rather than to every region Or specify a singl
6. Or a single region may be specified in row 1 of the column above any data parameter Version 5 and higher of the ANSWER Load Templates provides considerable flexibility but ultimately the user must decide which of a number of possible means is most convenient Note that Check Sheet and the Import Model Data from Excel facility check to ensure that any region that may be specified in row 1 does not conflict with any inherited region list that may be specified in column A Summary In summary to handle an N region model that does have common naming conventions across regions cell B1 of each sheet must contain the comma separated region list REG1 REG2 REGN There should be a single Commodities sheet a single Technologies sheet a single Constraints sheet and one or more CommData TechData and ConsirData sheets On both declaration and data sheets a region list in column A that is inherited by following rows may be used to indicate that declarations or data apply to a subset of regions On data sheets only a single region may be specified in row 1 of the column above any data parameter B 3 Technology Data sheet extension to handle Bilateral Trade between Regions Version 5 and higher of the ANSWER Load Templates allows for the display of Bilateral Trade parameters on TechData sheets so permitting the user to specify Bilateral Trade between regions of a multi region model To be more specific when the user clicks o
7. are named and described and their units and set memberships information are declared Commodities Data Data CommData Data associated with commodities e g demand levels energy carrier efficiencies electricity transmission and distribution costs are provided In version 6 1 and higher data associated with taxes and subsidies are also provided on the CommData sheet See section 10 Technology Data Data TechData Data associated with technologies e g residual capacity efficiency availability input output fuels costs are provided In version 6 1 and higher data associated with taxes and subsidies are also provided on the TechData sheet See section 10 Constraint Data Data ConstrData Data associated with user defined constraints ADRATIOs are provided by identifying the individual technologies that comprise the constraint along with their coefficients in the constraint equation Note that for a single region model only one of each type of Declare Declaration sheet may be included in a workbook while any number of each type of Data sheets is permitted The name given to the worksheet is up to the user although the ANSWER Indicators in cell A1 must match those in Table 1 In addition a workbook may contain as many other sheets as desired but the user is encouraged to leave cell A1 the ANSWER Indicator cell blank All of the ANSWER worksheets are governed by a few formatting guidelines requirements but are
8. Check Sht 5 Parameter Qualifier wma TechHame TechDesc TACT TCAP Units CommiH Commout LIFE RESID CF CAP TechName TechDesc CommlN CommOuT TID z000 CHLECOAION Com Space Heat Large COA00 PJ Piva COMCOA CHLE 30 0 13 0 541 CHLEELC100 Com Space Heat Large ELC O0 PJ Piva COMELC CHLE a0 0 43 0 54 CLE CHLEEL 200 Com Space Heat Large ELC 00 PJ Piva COMELC CHLE CHLEGAS100 Com Space Heat Large GAS 00 PJ Pi fa COMGAS CHLE CLE CHLEGAS2ZO0 Com Space Heat Large GAS 00 PJ PJa COMGAS CHLE CHLELFG100 Com Space Heat Large LPG 00 PJ PJa COMLPG CHLE a OF 0 541 a0 1 55 0 541 a0 1 34 0 541 a0 0 12 0 541 CLE CHLELTHIOO Com Space Heat Large LTH 00 APJ Pl a COMLTH CHLE a0 Lae 0 541 CLE CHLEOILIOO Com Space Heat Large OIL 00 F PJ Pl a COMOIL CHLE a0 450 0 541 CLE CHSEC 0A100 Com Space Heat Small C0A 00 PJ Piva COMCOA CHSE CHSEELC100 Com Space Heat Small ELC 00 PJ Piva COMELC eis a INIA RIH DM calib Cc Of Technology Data CE Of DM Calib CH Ready a0 0 04 0 541 a 0 13 0 541 Technology Data CH jal eel al lly If the above sheet had been created using an ANSWER ver 1 xls violet would replace green and there would be the possibility of specifying data for Taxes Subsidies See section 10 Yi p ew LAB L Aw Aae BRI RI hi _ SP ed ee Pe Pe rd J RI C W oo S G po e foo ph e laa or P
9. 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 B CheckSummary Log WordPad oj x Eile Edit view Insert Format Help Delal ee al e 8 Summary Log File created on Tuesday 12 September 2006 at 11 46 AM ttt CHECK TECHNOLOGIES SHEET Technologies CROATIA Check Cell B1 Region Region List The Region Region List in cell Bi is OE Check Colum amp Regions Region Lists All colum amp region region lists are OE Check 411 Technology Names ll of the Names in the TechWarne column are OE Check For Duplicate Technology Names There are no Duplicate Names in the TechName column Check 411 Technology Descriptions All of the Descriptions in the TechDesc column obey ANSWER conventions Check All Technology Activity Units ll of the Units in the TacTUnit column are valid Check 411 Technology Capacity Units 411 of the Units in the TC aPUnit column are valid Check 11 Technology Set Memberships All of the Set Memberships in the Set Memberships column are valid For Help press F1 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 10 6 Constraints Sheet The Constraints sheet is where all the user defined constraints ADRATIOs are named and described and their units and set memberships
10. along with quality control checking to facility the direct and correct loading of the data Initially these templates are more focused on assisting the assembling of initial year data for the calibration of a new model but the approach will be expanded to facilitate load of projection information as well The ANSWER smart templates are loaded into an ANSWER database by means of the File Import Model Data from Excel facility For an overview of the use of this facility see section 11 Loading the Templates into ANSWER of this manual and for a detailed explanation see section 2 10 Importing Model Data from Excel in the ANSWERv6 MARKAL User Manual pdf in folder C AnswerV6 UserManuals In the sections that follow each sheet will be presented The next two sections however describe opening a smart workbook and the general layout and philosophy embodied in all the sheets Note that an example ANSWER smart template UtopiaSmartXLS xls is now provided as part of the ANSWERv6 MARKAL installation files in folder C AnswerV6 UserManuals See section 12 Example ANSWER smart template of this manual Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 3 2 Workbook Setup Anyone wishing to work with an ANSWER smart load workbook must create an existing ANSWER Smart Workbook to start See Appendix A for more information on the various ways in
11. ensure that all the functionality action buttons and cell references links to the Commodities Technologies and Constraints sheets are properly retained The following possibilities are detailed below e Creating anew empty ANSWER Smart Workbook e Making an existing workbook aware of ANSWER Smart Workbook facilities e Copying an existing workbook that is already aware of ANSWER Smart Workbook facilities to create a new workbook e Updating an existing workbook that is already aware of ANSWER Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER smart XLS and e Adding anew ANSWER smart sheet to the current XLS The text and screen snapshots that follow are for an ANSWERver6 0 XLS If working with an ANSWER ver6 1 XLS simply imagine 6 1 replacing all occurrences of 6 0 in the text and screen snapshots A 1 Creating a new empty ANSWER Smart Workbook To create a new empty ANSWER Smart Workbook open the file ANSWERver6 XLS distributed by Noble Soft for example open ANSWERver6 0 XLS Then select Enable Macros to bring up the single visible sheet of ANSWERver6 0 XLS as follows EJ Microsoft Excel ANSWERver6 0 xls Ioj xj Es File Edit wiew Insert Format Tools Data Window Help Type a question Ffor help x ULAGATI sBB F 9 SB z 3 im Bplla E B ANSv6 0 Horme Al ee a ee ae 1_JANSv6 0 Home Create New ANSWER Smart XLS Version 6 0 Update XLS to ANSWER S
12. in blue Note that when specifying Units or Set Memberships the last one provided applies down the column until another specification is provided In the sections that follow each sheet is presented with the buttons explained Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 4 Commodities Sheet The Commodities sheet is where all the commodities energy carriers materials demands and emissions are named and described and their units and set memberships information are declared An example Commodities sheet is shown below Ed Microsoft Excel SEE REDP_AGR_Croatia_ 2 xls B File Edit Yiew Insert Format Tools Data Window Help la x DSehS 46a se elo Ct SC a SSeS BS ee eee 1 Commodities CROATIA Check Sheet A Energy Sets Material Sets 5 ea CommUnit Demand Sets Emission Sets Be CommName CommDesc CommUnit Set Memberships Comment 8 Upstream Energy Carriers need for the Dummy Processes EE BIOWOQ Fuel wood PJ ENT ENC ESY SLD COABRO Brown Coal ENT ENC EFS SLD elt COALIG Lignite ENT ENC EFS SLD dl ELC Electricity ENT ELC Fabl GASGWG GWG ENT ENC EFS GA i GASNAT Natural gas ENT ENC EFS GA P HET Heat ENT LTH OILDST Distillate ENT ENC EFS LIQ EE OILHF O Heavy Fuel Oil ENT ENC EFS LIO ES CILGSL Gasoline ENT ENC EFS LIO QILLPG LPG ENT ENC EFS GAZ 20 all COM Energy Carriers AGRBIO Fuel wood ENT ENC ESY SLD AGRCOA Coal EN
13. information are declared An example version 6 Smart XLS Constraints sheet is shown below SE EE Ss ees Es ae 1 Constraints DEMO Refresh Check Sheet Units Units Constraint Sets ConstrName ConstrDesc Units Set Memberships Comment a ELEMAX Maximum Electricity uconstraint ADRATIO ELEMIN Minimum Electricity WATSEA Hydro electric by Season RENEVWELC Rule based constraint for renewable electricity ADRATIO RULE ADR l KERIGCI Constraints ConstrDat 4 i Similarly to the Commodities and Technologies sheets the key information entered on the Constraints sheet that is directly provided by the user are the Constraint short Names ConstrName and Descriptions ConstrDesc appearing in columns B and C respectively In addition after positioning the cursor in columns D or E of a row the action buttons above may be used to select the Units or Set Memberships specifications respectively For example after positioning the cursor in column E of a row and clicking on the Set Memberships button the following Constraints Set Memberships form appears Set Memberships Set Memberships B User Defined Constraint ADRATIO Additional Characterization The above Constraints Set Memberships form is the simplest possible for an ANSWER database associated with a smart XLS More complicated possibilities exist see below Version 5 and higher Smart XLS enhancement to allow a Constraint to be declared as Rule based on t
14. of regions By default the information on a sheet declaration or data applies to every region in the region list 2 Onboth Declaration and Data sheets the cell B1 region list may be over ridden by specifying a comma separated region list in column A from row 8 down The region list in column A must comprise a subset of the regions in the cell B1 region list Note that a column A region list is inherited by the rows beneath it and applies until such time as another column A region list is encountered This allows the user the convenience of specifying that some declarations and data will apply to a subset of the regions specified in the cell B1 region list 3 On Data sheets only the cell B1 region list and any column A region list that may apply may be over ridden by specifying a single region in row 1 of the column above a data parameter This allows the user the convenience of specifying on a single Data sheet a mix of Data for all regions along with data such as RESID for specific regions Suppose a multi region model that does have common naming conventions across regions involves N regions say REG1 REG2 REGN In this situation the fundamental principle used in building the Load XLS is that each Declaration or Data sheet by default contains Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 34 declarations or data for every region and so cell B1 of each sheet mu
15. season time of day COST Annual resource cost Both TS and TID Parameters r CON PRC CON CON HDE SEP_EXP SEP_EXP SEP_EXP SEP_EXP SEP_IMP SEP_EXP SEP_IMP CON DMD PRC CON DMD PRC CON DMD PRC CON PRC CON PRC CON PRC SRCENCP SRCENCP SRCENCP CON DMD PRC CPD DMD XPR ZLM SRCENCP Parameters Shown Excluded Ok Cancel Note that the Technology Parameter list created using an ANSWERver5 xls and higher differs slightly from that created using an ANSWERver4 xls in that Bilateral Trade Parameters are also displayed these are the 5 parameters above whose name begins with BI_TRD See Appendix B 3 Technology Data sheet extension to handle Bilateral Trade between Regions Of course Bilateral Trade Parameters are only relevant for multi region models As is the case for the Commodity Data sheet once a Parameter is selected its Name is entered into the row 5 cell where the cursor is placed and if itis a TID parameter the TID indicator is automatically entered into row 7 the period row For time dependent parameters the user may leave row 7 blank in which case the numeric values provided in rows 8 and downwards of the column are assumed to apply to all periods Or the user may specify either a single year e g 2000 or a pair of years separated by a comma e g 2000 2010 or a pair of years separated by a hyphen e g 2000 2010 In a situation where the Parameter requires a Qualifier e
16. step 1 above you are unable to open the ANSWER database and get a message ending in Perhaps itis already in use most likely this database is already in use because you have an open ANSWER smart template and this database is associated with it So simply close the ANSWER smart template so that the database is no longer associated with it and hence no longer in use Most users will have a number of ANSWER smart templates and will often find it convenient to load several templates in a single Import operation To facilitate multi selection of ANSWER smart templates at step 3 above store all templates in a single folder Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 24 12 Example ANSWER smart template To provide users with a concrete example of an ANSWER smart template the file UtopiaSmartTemplate xls is now provided as part of the ANSWERv6 MARKAL installation files in folder C AnswerV6 UserManuals Also an ANSWER database UtopiaWithOnlyGlobalTabData mdb that is suitable to be associated with the UtopiaSmartTemplate xls as described in section 2 Workbook Setup is provided in folder C AnswerV6 Answer_Databases This ANSWER database has time periods 1990 2000 2010 has a single region UTOPIA specified and has standard MARKAL timeslices As its name would suggest this database contains only Global tab data and also the speci
17. which this can be done In addition note that the functioning of some of the macro facilities in the ANSWER load workbooks requires that ANSWER 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 Select Enable Macros so that the action buttons are made available security Warning C IRG eIOC SEE REMS Taski RESetc SEE REDP_RSD_Croatia_vi 050627q g 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 It is recommended that you associate the workbook with a target ANSWER database in response to the prompt below This is necessary to make available the smart buttons on the ANSWER workbook related to specifying Units Set Memberships Parameters and Parameter Qualifiers and to make available the Check Sheet button on each worksheet The functioning of the following smart buttons does not depend on associating the workbook with a target ANSWER database the CommName CommDesc CommuUnit button on the Commodity Data worksheet the TechName TechDesc TACT TCAP Units and the CommIN and CommOuT buttons on the Technology Data worksheet and the ConstrName ConstrDesc Units and the TechName buttons on the Constraint Data worksheet specify ANSWER Database Cancel
18. 07 ANSWERv6 MARKAL Load Templates Manual version 6 1 19 Microsoft Excel c Constraint RENEWELC is a rule based Constraint so the TechName column can contain either the Mame of a n Technology Items Filter From the ANSWER database that you are linked to or the Name of a Technology From the associated Technologies sheet Do vou wish to select a Technology Items Filter From the QNSWER database Click Yes to select 4 Technology Items Filter Click No to select a Technology From the Technologies sheet Click Cancel to do neither of the above As advised by the message click on the Yes button to select a Technology Items Filter from those that are available in the ANSWER database associated with the Smart XLS or click on the No button to select a Technology from the Technologies sheet Note also that where the ANSWER database that is associated with a version 5 and higher smart XLS is one that is Rule based Constraint aware then when the Parameter action button is clicked with the cursor in row 5 of column F or G or H or six additional RATRULE_ parameters are displayed in the Parameter selection list Select TS or TID Constraint Parameter Name will be transferred to ActiveCell Name Description SC Set Memberships RAT_RHS RAT_ACT RAT_CAP RAT_HPL RAT_INY RAT_SEP RAT_TC RAT_TE Y RATRULE_ACT RATRULE_CAP RATRULE_FLO_DM RATRULE_FLO_ENT RATRULE_IN RATRULE_SEP Both TS and TI
19. ANSWERv6 MARKAL Load Templates Manual version 6 1 1 ANSWERv6 MARKAL Load Templates Manual version 6 1 Table of Contents PICKTIOWICOGCIICIN cx isch a a a a ted ated et eae 2 TACK OIOUNO siete til waite caus unitate die dyer icine a aedates ontaas bhi teiaea die aici cess 2 2 WOPKDOOK SEOD tases 35 8 ia staste cet aetna a S 3 3 Worksheet Layo t and PRIOSOPRY siisirisdicsei irs asbvhasttiactastaviuigheeresanestvluaedeliaiedeiiehoacntiees 4 GOMMOOINES ONCE eases a T E E eee aa 6 O LECHROIOGICS SNC O ciate cee aiesd A ae ene eee 8 O CONS TUNS ON 2 Mee eee ee ae a a a ee Sere ee ee ye 10 Commodity Data CommData Sheel erosie Se ee a ee E ET 12 8 Technology Data TechData Sheet anniari aan 15 9 Constraints Data GonsirDaia Shet x scares Rese thee Pas eee Re 18 10 Specifying Declaration Information and Data for Taxes Subsidies 1 cccccceseeecensneeeeeaes 20 11 Loading the Templates into ANSWER cccccssssseecccsceeseecessaucseeccsnaaeeeessaaueseecssaaaesseessagees 23 12 Example ANSWER smart templat sisasoei tenon sests Sai ein eicle ie 24 Appendix A Establishing a New ANSWER Calibration and Load WorkbO0k ccc0000ce0e0es 25 A 1 Creating a new empty ANSWER Smart Workbook ccccccccssseeeeeeessneseeesssaeeseeesees 25 A 2 Making an existing workbook aware of ANSWER Smart Workbook facilities 27 A 3 Copying an existing workbook that is already aware of ANSWER Smart Workbook facilities
20. AT__RHS RAT_RHS RAT_CAP RATRULE_ACT RAT_TEZY RAT UP LO I D cf ConstrName ConstrDesc Units TechName 8 g ELEMAX Maximum Electricity uconst RHE 30 1 a TXE 1 ak ELEMIN Minimum Electricity uconst RHE 0 1 le TXE 1 RENEWELC Rule based constraint for renews uconst RENEVY ELE ALL ELE WATSEA Hydro electric by Season uconst E31 0 05 0 1 5277 ia eee ee eS ese 4 b Commodities Z Technologies CommData TechData Constraints ConstrData TechData 2 The Constraint Data sheet functions similarly to the Commodity Data and Technology Data sheets Thus positioning the cursor in column B of a row below 7 and pressing the ConstrName ConstrDesc Units action button brings up a sorted list of the user entries from the Constraints sheet Selecting a constraint from this list results in its Constraint Name Description and Units being inserted into columns B C and D as cell references links to the Constraints sheet Thus for example if a Constraint Name or Description is changed on the Constraints sheet that change will automatically flow through to the Constraint Data sheet via the cell reference In the TechName column column E the technologies that comprise the constraint are listed When more than one technology is involved in a constraint a separate row must be used to identify the technology and provide the associated data With the cursor in column E of a row pressing the TechName button
21. B_BND UP Upper Bound on total tax subsidy revenues TAZSUB TSUB_COST Annual cost of tax subsidy per unit of energy carrier TAZSUB TSUB_ENT ENT Flag indicating energy carrier to which tas subsidy applies TAZSUB TSUB_MAT MAT Flag indicating material to which tax subsidy applies TAZSUB Both TS and TID Parameters Parameters Shown Excluded OK Cancel If you select TSUB_ENT ENT as the desired TaxSub parameter then the CommData sheet appears as follows with Energy in the Qualifier row indicating that an Energy Commodity must be selected by clicking on the _ alfter_ button Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 21 E CommData UTOPIA Refresh Commilame ComnmmMbesc Communit Units CommName CommBDesc Units TID Tax on diesel A completed CommData sheet that specifies TSUB_ENT ENT and TSUB_ COST for Tax Subsidy named TAX might appear as follows Refresh Units TSUB_ENT ENT TSUB_COST DSL CommName CommBDesc Units TID TAX Tax on diesel PJ 1 5 TechData Sheet TSUB_TECH data for a Tax Subsidy is specified on the TechData sheet The appearance of the TechData sheet is unchanged If you click on the _F tet_ button and select Technology TaxSub parameter TSUB_ TECH then the TechData sheet appears as follows with Tax Subsidy in the Qualifier row indicating that a Tax Subsidy must be selected by clicking on t
22. D Parameters r Coefficient RHS user defined constraint Coeff technology activity variable user defined constraint Coeff capacity variable user defined constraint Coeff heating plant activity variable user def constraint Coeff investment variable user defined constraint Coeff resource activity variable user defined constraint Coeff coupled prodn activity variable user def constraint Coeff electricity activity variable user defined constraint Coeff technology activity variable rule based constraint Coeff capacity variable rule based constraint Coeff technology according to demand flow rule based constraint Coeff technology according to energy flow rule based constraint Coeff investment variable rule based constraint Coeff resource activity variable rule based constraint ADRATIO ADRATIO ADRATIO ADRATIO ADRATIO ADRATIO ADRATIO ADRATIO RULE_ADR RULE_ADR RULE_ADR RULE_ADR RULE_ADR RULE_ADR Parameters Shown Excluded Ok Cancel These RATRULE _ parameters are used to define data associated with Rule based Constraints for example the RATRULE_ACT parameter is used in column along with associated numeric entries in rows 13 and 14 as part of defining data associated with the rule based constraint RENEWELC Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 20 10 Specifying Declaration Information and Data for Taxes Subsidies Version 6 1 an
23. EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS GAZ Region Description Set Memberships Note that for a multi region model with common naming conventions across regions we should not be surprised to see that many such energy carriers in the list occur in several if not all regions Select the desired commodity from this list and click on the OK button The name that you selected will be transferred to the Qualifier row and used as the import commodity name in the bilateral trade link Summary The following points should be kept in mind when specifying the Bilateral Trade parameters BI_TRD ELC BI_TRD ENT BI_TRD MAT on a TechData sheet e he Export part of the bilateral trade link is specified via a row that contains the export region in the possibly inherited column A region regionlist the export technology name in the TechName column and the export commodity name in the CommIN column coupled with an INP ENT x data entry of 1 e The mport part of the bilateral trade link is specified via the BI_TRD column that contains the import region in row 1 the implied actual import commodity name in the Qualifier row and coupled with a data entry of 1 in the row where the export part of the bilateral trade link is specified e The Qualifier either implies the import commodity name in the case of a Qualifier of lt SAME gt or lt EXPREGs or is the actual import commodity name The import commodi
24. NSWER Smart Sheet listbox contains the six types of smart sheets namely Commodities Technologies Constraints CommData TechData ConstrData If an ANSWER database was linked to when the XLS was opened the Specify Region combobox contains the regions in the ANSWER database If no ANSWER database was linked to when the XLS was opened the Specify Region combobox contains the regions that appear in cell B1 of sheets in the XLS that are smart sheets namely sheets that in cell A1 have Commodities Technologies Constraints CommData TechData ConstrData Select the type of ANSWER smart sheet that you wish to add by clicking on it in the listbox For example click on TechData if you wish to add a new TechData sheet to the current XLS Select the Region for which this smart sheet will be created either from the regions in the combobox or by typing into the combobox the name of a region if wanting to specify a region name that is not listed in the combobox 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 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 31 Se ee E F G H 1 TechData ICROATIA Refresh i Check ht Techtlame Tech pE A EE E E x a Qualifier Select ANSWER Smart Sheek to be added t
25. Parameter is selected its Name is entered into the row 5 cell where the cursor is placed and if itis a TID parameter the TID indicator is automatically entered into row 7 the period row For time dependent parameters the user may leave row 7 blank in which case the numeric values provided in rows 8 and downwards of the column are assumed to apply to all periods Or the user may specify either a single year e g 2000 or a pair of years separated by a comma e g 2000 2010 or a pair of years separated by a hyphen e g 2000 2010 In a situation where the Parameter requires a Qualifier e g a parameter such as ENV_ENT that requires an Energy qualifier or a parameter such as FR Z Y that requires a Timeslice qualifier the Parameter Name is entered into row 5 and the cursor positioned in row 6 below the Parameter Name and an indication of the nature of the qualifier expected is displayed Pressing the Qualifier button will display a list of the permitted qualifiers for the associated Parameter The parameters can be provided in any order beginning from column E 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 Noble Soft Systems Pty Ltd 2005 07 Au
26. Placing the cursor in row 5 of column G or Hor lor and pressing the Parameter button brings up a Parameter selection list as shown below Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 Select TS or TID Technology Parameter Name will be transferred to ActiveCell l X AF_TID ARAF BI_TRD ELC BI_TRD ENT BI_TRD MAT BI_TRDCST BI_TRDCSTE BOUND LO BOUND FX BOUND UP BOUND LOj O BOUND FX 0 BOUND UP O BOUND LO 0r BOUND FX Or BOUND UP Or CAPUNIT CEH ZX Y CF CF ZKY Annual availability Barz Availability for season time of day Fraction of unavailability which is forced outage Annual reservoir availability Indicator for bilateral trade in electricity by timestice Indicator for bilateral trade in energy Indicator for bilateral trade in material Cost for bilateral trade in energy carrier material Cost for bilateral trade in electricity by timeslice Lower Bound on capacity Fixed Bound on capacity Upper Bound on capacity Lower Bound on activity conversion process technology Fixed Bound on activity conversion process technology Upper Bound on activity conversion process technology Lower Bound on activity resource technology Fixed Bound on activity resource technology Upper Bound on activity resource technology Units of activity unit of capacity Ratio of electricity lost to heat gained Annual utilisation Utilisation for
27. T ENC EFS SLD A AGRELC Electricity ENT ELC AGRGAS Gas ENT ENC EFS GA sare AGRLTH Heat ENT LTH AGRLPG LPG ENT ENC EFS GAZ WAF HA SNSv2 Home Commodities Demand fal Ready A al If the above sheet had been created using an ANSWERver6 1 xls violet would replace green and there would be a TaxSub Sets button in column E See section 10 The key information entered on the Commodities sheet that is directly provided by the user are the Commodity short Names CommName and Descriptions CommDesc appearing in columns B and C respectively In addition after positioning the cursor in columns D or E of a row the action buttons above may be used to select the Units or Set Memberships specifications respectively Sample Commodity Set Memberships and Units forms are shown below Set Memberships Set Memberships 2 Energy Carrier ENT _ Standard ENC Liquid LIG EL Conservation ECY Solid SLD B Fossil EFS C Gaseous GAZ E High Temp Heat or Cooling EHC E Nuclear ENU E Renewable ERN a BL Synthetic ESY E Electric ELC Fy District Heat LTH i E Fossil Equivalent FEQ Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 Specify Commodity Unit To specify a Unit click on the Unit in the treeview and then click on the OK button or just double click on the Unit in the treeview H5 E mmid d i ty Billion vehicle kilomet
28. WER Smart L5 created by update C Answer v SEE Templates USER V6 0 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 0 appended So above v6 0 is appended to USER to provide USERv6 0 as the default filename There is an exception to this rule if the filename of the XLS to be updated ends in v5 then the default filename given to the ANSWER smart XLS is taken to be the filename of the XLS to be updated with the v5 replaced by v6 0 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 Smart Workbook facilities if desired Click on the Close button to close the Update XLS to ANSWER Smart XLS form Close ANSWERver6 0 XLS A 3 Copying an existing workbook that is already aware of ANSWER Smart Workbook facilities to create a new workbook If an existing workbook is already aware of ANSWER Smart Workbook facilities then simply copying this workbook to create a renamed copy will result in the renamed copy being aware of ANSWER 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
29. al energy Carrier FEQ Fossil Equivalent To use UtopiaSmartTemplate xls to explore various aspects of how an ANSWER smart template operate e If as part of exploring how an ANSWER smart template operates you intend to change the contents of the ANSWER smart template it is suggested that you use Windows Explorer to make a copy of UtopiaSmartTemplate xls e Open UtopiaSmartTemplate 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 UtopiaWithOnlyGlobalTabData mdb in folder C AnswerV6 Answer_ Databases The following points should be noted about UtopiaSmartTemplate xls e Commodity Data has been specified with TID commodity data on one CommData sheet named CommData TID and TS commodity data on a second CommData sheet named CommData TS It would be perfectly OK to specify both TID and TS commodity data on a single CommData sheet e Likewise Technology Data has been specified with TID technology data on one TechData sheet named TechData TID and TS commodity data on two TechData sheets named TechData TS1 and TechData TS2 Again it would be perfectly OK to have a different arrangement of TID and TS technology data including one in which one or more of the TechData sheets contained both TID and TS technology data e In particular it could be argued that so far as the electric conversion technologi
30. ch of these options is now discussed e lt SAMEs This is the default option and has already been noted above is the appropriate option if you want to specify a bilateral trade link in which the import commodity in the import region has the same name as the export commodity in the export region e lt EXPREGs This is a rather specialized option that was created for the US EPA 9 region project Use this option if you want to specify a bilateral trade link in which the import commodity name in the import region is formed by taking the export commodity name and appending the export region name So if the export commodity name is ELC and the export region name is R1 use of the lt EXPREG gt option results in the import commodity name in the import region being taken to be ELCR1 NOTE The resultant import commodity name lt ent gt must not exceed 6 characters in length since the associated import technology name will be of the form IMP lt ent gt P where P is the final character of the export technology name and ANSWER has a limitation of 10 characters on the length of technology names e Select Import Commodity from List Use this option if you want to specify a bilateral trade link in which the import commodity name in the import region differs from the export commodity name and where you want to choose the import commodity name from a list of commodities for the import region specified in row 1 of the Bilateral Trade column Note that f
31. cribed for TechData sheets but also applies for CommData and ConstrData sheets Create a TechData sheet on which the data parameter instances that apply in every region are specified As is the case for all TechData sheets cell B1 contains the region list REG1 REG2 REGWN Since these data parameter instances are to apply in every region do not use column A to specify a region list that overrides the cell B1 region list and do not specify a single region in row 1 of the column above any data parameter For each region k k 1 2 N create a TechData sheet on which the data parameter instances that are specific to region k are specified with cell A8 containing the single region REGK and with other cells in column A empty apart from comments that begin with an The single region REGk that is specified in cell A8 overrides the cell B1 region list REG1 REG2 REGWN and by inheritance applies to every data parameter instance on the sheet So there is no need to specify a single region in row 1 of the column above any data parameter There are other means of handling the above situation For example a single TechData sheet may contain data parameter instances rows containing numeric values that apply in every region then a row with REG1 in column A followed by data parameter instances that are specific to region REG1 then a row with REG2 in column A followed by data parameter instances that are specific to region REG2 etc
32. crosoft Excel ANSWER ver6 0 xls jo x S File Edt View Insert Format Toos Data Window Help Type a question for help amp PEETA EEE E E im pela A ANSv6 0 Home k a Bg 1_JANSv6 0 Home Create New ANSWER Smart ALS Version 6 0 Update XLS to ANSWER Smart XLS Version 6 0 Single reqgion Multi region no common naming across reqions gt Multi region common naming across regions Add New ANSWER smart Sheet to Curent ALS H 4b MP ANSY6 0 Home Jal Ready 4 Click on whichever is appropriate of the Single region Multi region no common naming across regions and the Multi region common naming across regions radio buttons and then click on the Update XLS to ANSWER Smart XLS Version 6 0 button This brings up the following form Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 28 Update LS to ANSWER Smart LS version 6 0 Ee X Filename of L5 to be updated Filename given to ANSWER Smart L5 created by update Update Close 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 XLS version 6 0 x Filename of L5 to be updated C Answer voee TermplatesiUSER xls Browse Filename given to ANS
33. d higher of the ANSWER smart load templates allows the specification of declaration information and data for Taxes Subsidies This involves extensions to the operation of the Commodities CommData and TechData sheets Commodities Sheet Declaration information for a Tax Subsidy is specified on the Commodities sheet where a new _TaxSub Sets button is provided in column E the Set Memberships column Commodities UTOPIA Check Sheet Refresh Units Communit TaxSub Sets Energy Sets Material Sets Demand Sets Emission Sets CommName CommbDesc Communit Set Memberships Taxes Subsidies PJ TAXSUB l Comment TAX Tax on diesel CommData Sheet Most of the data for a Tax Subsidy is specified on the CommData sheet Although the appearance of the CommData sheet is unchanged E CommData UTOPIA Fefresh Chk Sheet Commilame Comnmbesc CommUnit Units Parameter CommAbame CommDesc when you click on the _ommilame Commbese commUnit button the list of Commodities that is displayed now includes any Taxes Subsidies that are specified on the Commodities sheet Also when you place the cursor in row 5 of column E or F or and click on the Parameter button the list of Commodity Parameters that is displayed now includes the following TaxSub parameters TSUB_BND LO Lower Bound on total tax subsidy revenues TAZSUB TSUB_BND FX Fixed Bound on total tax subsidy revenues TAZSUB TSU
34. e created textbox as follows Create New ANSWER Smart XLS version 6 0 xj Filename of amp LS ko be created C ansiwervel5EE_Templates 5EE REDP COM Croatia v6 0 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 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 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 27 The form remains open so that additional new ANSWER Smart XLS files may be created if desired Click on the Close button to close the Create New ANSWER Smart XLS form Close ANSWER ver6 0 XLS When you open any of the new ANSWER 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 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 ANSWERver6 0 XLS distributed by Noble Soft Then select Enable Macros to bring up the single visible sheet of ANSWERver6 0 XLS as follows EJ Mi
35. e region in row 1 of the column above a data parameter to indicate that data in that column apply only for that region Likewise create one or more TechData sheets with cell B1 of each sheet containing the region list REG1 REG2 REGN on which by default the data for technologies in every region are specified If necessary specify a region list in column A to indicate that data for some technologies apply to a subset of regions rather than to every region Or specify a single region in row 1 of the column above a data parameter to indicate that data in that column apply only for that region And likewise create one or more ConstrData sheets with cell B1 of each sheet containing the region list REG1 REG2 REGN on which by default the data for constraints in every region are specified If necessary specify a region list in column A to indicate that data for some constraints apply to a subset of regions rather than to Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 35 every region Or specify a single region in row 1 of the column above a data parameter to indicate that data in that column apply only for that region Additional Considerations The user should be aware of the following means of handling the situation where some data parameter instances apply in every region but other data parameter instances such as BOUNDs RESIDs are region specific This will be des
36. ers E w krm Million tons hat ie Petajoules PJ Petajoules if EN Ts being totalled are all in PJ Pu Thousand tone kt Tors t unit of refinery uret unit of volume for Os uvol unit of weight for beT Liat unit vol if MVOs being totalled are all in uvol uval unit wt iF MMT s being totalled are all in ut Liat unit t of DMs being totalled unitD M7 OK Cancel 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 B CheckSummary Log WordPad loj x File Edit wiew Insert Format Help Delal akl al ae B Burmary Log File created on Tuesday 12 September 2006 at 11 46 AM ttt Noble For Help press Fl CHECK COMMODITIES SHEET Commodities CROATIA Check Cell Bil Region Region List The Region Region List in cell Bi is OK Check Column amp Regqions Region Lists All column amp region region lists are OK Check 11 Commodity Names All of the Names in the ConmVame column are OE Check For Duplicate Commodity Names There are no Duplicate Names in the CommYame column Check All Commodity Descriptions All of the Descriptions in the Commbesc column obey ANSWER conventions Check All Commodity Units All of the Units in the CommUnit column are valid Check All Commodity Set Memberships 11 o
37. es E01 E21 E31 E51 E70 are concerned it would be preferable to have the TID parameter OUT ELC TID and the TS parameter INP ENT c both occurring on the same TechData sheet since that way both CommIN and CommOuT for these technologies would occur on the same sheet The UtopiaSmartTemplate xls contains a complete specification of the Utopia model except that it does not contain Global tab data DISCOUNT HEATCOOL Z QHR Z Y STARTYRS the ANSWER smart template does not allow the specification of Global tab data If you import UtopiaSmartTemplate xls into UtopiaWithOnlyGlobalTabData mdb you will find that you can scan the Energy Demand Emission Technology and Constraint tabs and see that the Utopia model is indeed now fully specified e Before attempting to use AnswerV6 exe to open UtopiaWithOnlyGlobalTabData mdb and import UtopiaSmartTemplate xls via the File Import Model Data from Excel facility you must first close UtopiaSmartTemplate xls thereby closing the link to UtopiaWithOnlyGlobalTabData mdb AnswerV6 exe requires exclusive access to open any ANSWER database and so while UtopiaSmartTemplate xls is open it will be unable to open UtopiaWithOnlyGlobalTabData mdb Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 25 Appendix A Establishing a New ANSWER Calibration and Load Workbook The process of establishing a new workbook must be done with care so as to
38. extremely flexible in nature The top 7 rows of each sheet comprise the action button and header area These rows are non scrollable Columns A C on the Declare Declaration sheets A D on the Commodity Data sheets A F on the Technology Data sheets and A E on the Constraint Data sheet contain action buttons and identification columns that are also 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 Likewise a column will be ignored if the first character of the cell in row 1 contains an or if the column is completely blank Other ignore options to be added Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 There are a number of action buttons on each of the ANSWER worksheets These buttons can be used to specify units and set memberships information select parameter labels and perform quality control checks Some buttons are context sensitive that is the user must first position the cursor in the appropriate cell below the column or along the row in which the action button appears Upon selecting from the active list the resulting value is entered into the corresponding cell When a simple value text string is deposited in the cell it is in violet and when a linked reference is inserted e g the name description unit of a commodity or technology or constraint on a Data sheet it is
39. f the Set Memberships in the Set Memberships column are valid Check Each Commodity Row is Fully Specified 411 of the Rows have Name Description Unit s Set Memberships specified d E Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 5 Technologies Sheet The Technologies sheet is where all the technologies resources processes conversion plants and demand devices are named and described and their units and set memberships information are declared An example Technologies sheet is shown below Ed Microsoft Excel SEE REDP_COM_ Croatia_ 2 xls B File Edit View Insert Format Tools Data Window Help x OSs ASRS BBlO B A i oor 10 O O D E a a a E 4 Technologies CROATIA Check Sheet TACTUnnt TCAPUnit Technology Sets lt fer TechName TechDesc TACTUnit TCAPUnit Set Memberships Comment ef 8 cooling EE CCLEELC100 Com Cooling Large FLC 00Fans PJ Pula TCH DMD CCSEELC1IO0 Com Cooling Small ELC 00 Fans z m 12 public lighting CPUELCIOO Com Public Lighting ELC O0 Generic Lamp i j 15 cooking re EH CFODELCIOO Com Cooking FLE OO Stove E CFODGASION Com Cooking GAS 00 Stove z CFODLPGIOO Com Cooking LPGOO Stove aa 19 heating Com opace CHLECOAIOO Heat Large COA OD Stove A 20 g Com opace CHLEELC1OO Heat Large ELC 00 Furnace a o Com opace ALa pL ANSv2 Home 4 Energy Balance 4 Commodi
40. g a parameter such as AF Z Y that requires a Timeslice qualifier the Parameter Name is entered into row 5 and the cursor positioned in row 6 below the Parameter Name and an indication of the nature of the qualifier expected is displayed Pressing the Qualifier button will display a list of the permitted qualifiers for the associated Parameter In general the parameters can be provided in any order beginning from column G However there is an exception to this rule LIFE should be specified in a column to the eft of any RESID column if the user wishes to invoke the Use LIFE to set RESID where just first period RESID option of the Import Model Data from Excel facility This option allows the user to specify the LIFE of a technology and just the first period value for the RESID parameter and causes an automatic calculation to be done that sets RESID 0 in the appropriate period 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 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 17 File Edit wiew Insert Format Help pela Sil al e Burnmary Log File created on Tuesday 12 Septembe
41. gust 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 14 Z CheckSummary Log WordPad z ioj x File Edit wiew Insert Format Help pell alel al aelel BEurmmary Log File created on Tuesday 12 September 2006 at 11 51 AN t CHECK COMMDATA SHEET Demand Data CROATIA Check Cell Bl Region Region List The Region Region List in cell Bil is OE Check Column A Regions Region Lists and Row 1 Regions 11 column region region lists are OE 411 row 1 regions are OK Check All Commodity Names On CommData Sheet Match with Commodities Sheet 411 of the Names in the CommMame column match Commodity Names on the associated Commodities sheet Check For Duplicate Commodity Names On CommData Sheet There are no Duplicate Names in the ConmmMame column Check All Parameter Columns On Commlata Sheet 411 of the Parameter Columns are OE For Help press F1 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 15 8 Technology Data TechData Sheet The Technology Data sheet is where data associated with technologies e g residual capacity efficiency availability input output fuels costs are provided E4 Microsoft Excel SEE REDP_COM_Croatia_ xls File Edit View Insert Format Tools Data Window Help _ o x OSHS 4RY BS Blo B A iy too ajo aB z UB a A AL S TechData i ae e ee a ee ee ee ee ee ee eee TechData ICROATIA A
42. he Sualmet button ee 1 TechData UTOPIA 2 Refresh Check Sh TechName TechDesc TACT TCAP Units Units Commi CommodQut Aele TSUB TECH Qualifier TechName TechDesc Units CommlN CommOQuUT IMPOSL1 Import of Diesel PJ iv DSL A completed TechData sheet that specifies TSUB_TECH for Tax Subsidy named TAX might appear as follows Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 TechName TechDesc IMPOSLI Import of Diesel Units CommlN CommoOuUT 22 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 23 11 Loading the Templates into ANSWER The File Import Model Data from Excel facility is used to load information in an ANSWER smart template into an ANSWER database A brief overview of the steps involved in using this facility follows 1 Open the ANSWER database into which you wish to import the ANSWER smart template 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 E Import Model Data from Excel OR x T a gt Import Model Data from Excel allows Item TS and TID data in one or more Microsoft Excel Files to be imported into an existing ANSWER database
43. he Constraints sheet ANSWER versions 6 0 1 and higher incorporate a Rule based Constraint facility This facility makes it much easier to create a user defined constraint than in previous versions of ANSWER For details regarding Rule based Constraints in ANSWER see section 13 Defining a Rule based Constraint in ANSWER in ANSWERv6 MARKAL User Manual pdf in folder C AnswerV6 UserManuals Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 11 The ANSWER version 5 and higher Smart XLS has been enhanced as compared with version 4 to allow the specification of Rule based Constraints The only requirement is that the ANSWER database that is associated with a version 5 and higher smart XLS must be one that is Rule based Constraint aware and must contain the rules Technology Items Filters that are needed to define the Rule based Constraints of interest When this is the case the Constraints Set Memberships form that appears after positioning the cursor in column E of a row and clicking on the Set Memberships button is as follows Set Memberships Set Memberships me User Defined Constraint AD RATIO Additional Characterization C Rule based Constraint RULE_ADR Note the Rule based Constraint RULE ADR checkbox under Additional Characterization on the RHS of the form To specify that a Constraint is Rule based check
44. ity proceed as follows Open an ANSWER Smart XLS default is to specify the ANSWER database to be used to provide Parameter Units and Years information but this is not essential to the functioning of this facility and make the Home sheet this is the first sheet in the XLS the active sheet For a version 6 ANSWER Smart XLS this sheet appears as follows EJ Microsoft Excel SEE REDP_AGR_Croatia_v6 0 xIs i Joj x Eji File Edit View Insert Format Tools Data Window Help Type a question for help X ISARBAIGRIF GIA aB J A ogn Biera B Ad fe eo Pe a 1 ANSv6 0 Home Create New ANSWER smat ALS Version Update ALS to ANSWER Smart ALS Version 6 0 Single reqion e Multiregion no common naming across regions r Multi region common naming across regions Add New ANSWER Smart Sheet to Current XLS r MI ANSY6 0 Home Demar 4 __ wall Om hol rol po Ro bo bo bo po polo gt T Telesa eelas E T j L lt Y Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 30 Click on the Add New ANSWER Smart Sheet to Current XLS button This brings up the following form Add New ANSWER Smart Sheet to 4L5 x Select QNSWER Smart Sheet to be added to L5 Technologies Constraints ommata TechData ConstrData Specify Region to be added to cell B1 of Sheet CROATIA Add Sheet Close The Select A
45. kewise for each of the N regions create one or more associated ConstrData sheets That is create one or more ConstrData sheets with cell B1 containing only REG1 on which the data for constraints in region REG1 are specified create one or more ConstrData sheets with cell B1 containing only REG2 on which the data for constraints in region REG2 are specified etc Summary In summary to handle an N region model that does not have common naming conventions across regions for each region k k 1 2 N there should be a single corresponding Commodities Technologies and Constraints sheet and one or more CommData TechData and ConsirData sheets with cell B1 of each sheet containing just the single region REGK Thus altogether the Load XLS will contain N Commodities Technologies and Constraints sheets and N or more CommData TechData and ConstrData sheets Of course the Load XLS may also contain as many other sheets as the user wishes containing assumptions documentation raw data and or data transformations B 2 Multi region models that do have common naming conventions across regions In version 5 and higher of the ANSWER Load Templates the following format extensions have been incorporated specifically to simplify the specification of declarations and data for multi region models that have common naming conventions across regions 1 On both Declaration and Data sheets cell B1 may contain a comma separated region list list
46. l Lightning 3 98 1 00 0 14 0 26 0 06 Commercial Cooking 0 84 1 00 0 26 0 14 0 16 Commercial Fridges and Free PJ 0 46 1 00 0 26 0 14 0 16 Commercial Public Lighting PJ 107 1 00 0 26 0 14 0 16 Commercial Other Electricity PJ 0 58 1 00 0 26 0 14 0 16 MELIA laesa slelalalaaElalelE mona r x A ap 29 e KTaM Eneray_Balance f Commodities Technologies Constraints Demand_Data DM_Caib_cc Ready T a Z If the above sheet had been created using an ANSWERver6 1 xls violet would replace green and there would be the possibility of specifying data for Taxes Subsidies See section 10 Positioning the cursor in column B of a row below 7 and pressing the CommName CommDesc Communit action button brings up a sorted list of the user entries from the Commodities sheet Selecting a commodity from this list results in its Commodity Name Description and Units being inserted into columns B C and D as cell references links to the Commodities sheet Thus for example if a Commodity Name or Description is changed on the Commodities sheet that change will automatically flow through to the Commodity Data sheet via the cell reference Columns E F G are where the user provides data Rows 5 7 are used to identify the nature of the data parameter being provided Placing the cursor in row 5 of column E or F or G or and pressing the Parameter button brings up a Parameter selection list as shown below
47. llowing actions need to be taken 1 In cell H1 replace the text Region by the desired import region name in this case by R2 Note that the cursor is automatically positioned in cell H1 to facilitate this 2 In cell H6 consider whether the default Qualifier of lt SAME gt is appropriate It is appropriate if you want the import commodity in the import region to have the same name as the export commodity in the export region To select from the alternative Qualifier options place the cursor in cell H6 and click on the Qualifier action button This will be discussed below 3 Incell H11 insert a 1 to indicate that the export part of the bilateral trade link is EXPELC2 in region R1 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 38 Qualifier Options for Parameters BI TRD ELC BI TRD ENT BI TRD MAT If you place the cursor in row 6 of a column for which one of the parameters BI_TRD ELC Bl_TRD ENT BL_TRD MAT is specified and click on the Qualifier action button you will bring up the following form that displays the three alternative Bilateral Trade Qualifier options Bilateral Trade Qualifier Options X Select BiLateral Trade Qualifier Option f lt SAME gt Import Commodity Export Commodity lt EXPREG gt Import Commodity Export Commodity append Export Region Select Import Commodity From List for Row 1 region R2 Cancel Ea
48. mart XLS Version 6 0 Single reqgion Multi region no common naming across reqions e Multi region common naming across regions Add New ANSWER smart Sheet to Curent ALS M 4 gt H ANSY6 0 Home Jal Ria Ready a Click on whichever is appropriate of the Single region Multi region no common naming across regions and the Multi region common naming across regions radio buttons and then Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 26 click on the Create New ANSWER Smart XLS Version 6 0 button This brings up the following form Create New ANSWER Smart lt L5 version 6 0 Filename of LS 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 the bottom of the form as follows Savein SEE_Templates a fe re EJ My Recent Documents SEE REDP_AGR_Croatia_v6 0 xls Desktop My Documents z BE My Computer ai TEE Fie name SEE REDP_COM_Croatia_v6 O xls save as type Microsoft Excel File xls Cancel Ee Click on the Save button The full filename of the new XLS to be created will appear in the Filename of XLS to b
49. n the Parameter action button on a TechData sheet in addition to the parameters that were previously displayed five Bilateral Trade parameters are now displayed as follows Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 36 e Three TID indicator parameters BI TRD ELC BL TRD ENT BL _TRD MAT and e Two TID cost parameters BL TRDCST BL TRDCSTE Select TS or TID Technology Parameter Name will be transferred to ActiveCell Xj Name Description O O O C d Sek Memberships AF Annual availability CON PRC AFLZ ILY Availability for season time of day CON 4F_TID Fraction of unavailability which is forced outage CON ARAF Annual reservoir availability HDE JBI TRD ELC Indicator for bilateral trade in electricity by timeslice 00 SEP EXP BI_TRD ENT Indicator for bilateral trade in energy SEP_EXP BI_TRO MAT Indicator for bilateral trade in material SEP_EXP BI_TROCST Cost for bilateral trade in energy carrier material SEP_EXP SEP_IMP BI_TRDCSTE Cost for bilateral trade in electricity by timeslice SEP_EXP SEP_IMP BOUND LO Lower Bound on capacity CON DOMD PRC BOUND FX Fixed Bound on capacity CON DMD PRC BOUND UP Upper Bound on capacity CON DOMD PRC BOUND LOj0 Lower Bound on activity conversion process technology CON PRC BOUND FX30 Fixed Bound on activity conversion process technology COM PRC BOUND UP JO Upper Bound on activity conversion pr
50. o LS Commodities Technologies T Constraints Commoata TechName Tech ConstrData Specify Region to be added to cell B1 of Sheet CROATIA kd Close Pet 0 4 ee ot d eA To add another smart sheet to the XLS select the type of ANSWER smart sheet to be added adjust the Region combobox as necessary and click on the Add Sheet button Click on the Close button to close the Add New ANSWER Smart Sheet form Note that 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 TechData sheet will be given the default name TechData 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 TechData 2 If the name with 2 appended is already being used for another sheet then instead 3 is appended so for example TechData 3 and so on Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 32 Appendix B Extension of ANSWER Load Templates to handle multi region models With version 5 and higher of the ANSWER Load Templates as with version 4 there are two different methods of specifying declarations and data for multi region models Which of these methods should be used depends on whether or not the multi region model has common naming c
51. ocess technology CON PRC BOUND LOjOr Lower Bound on activity resource technology SRCENCP BOUND FXIOr Fixed Bound on activity resource technology SRCENCP BOUND UP3OFr Upper Bound on activity resource technology SRCENCP CAPUMIT Units of activity unit of capacity CON DMB PRC CEH 73 Ratio of electricity lost to heat gained CPD CF Annual utilisation DMD SPR CF T Utilisation for season time of day xLM COST Annual resource cost SRCENCP Both TS and TID Parameters r Parameters Shown Excluded OK Cancel NOTE If the target database associated with the workbook is an older version ANSWER database parameters BI TRD ELC and BI_TRDCSTE will appear on the above screen named as BI TRDELC Z Y and BL TRDCSTELC respectively In that case you should cancel out of this form and save and exit your workbook Then open the target ANSWER database with ANSWER version 5 5 8 or higher and close it again Now when you re open the workbook and associate it with this target database you will find that parameters BIl_TRD ELC and BL TRDCSTE appear in place of BL TRDELC Z Y and BL TRDCSTELC Special Considerations for Parameters BI TRD ELC BI TRD ENT BI TRD MAT As compared with the operation of the smart XLS for other data parameters special considerations apply for the Bilateral Trade parameters BI_TRD ELC BI_TRD ENT Bl_TRD MAT These special considerations will be explained using the BI_TRD ELC parameter The same c
52. of the XLS In either case all cell references links will be associated with the new file name Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 29 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 smart sheets may need to be adjusted A 4 Updating an existing workbook that is already aware of ANSWER Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER smart XLS To provide additional ANSWER Smart Workbook facilities or to correct bugs that are detected from time to time Noble Soft will distribute a new version of the ANSWER Calibration and Load Templates So for example ANSWERver6 0 XLS is a new version that provides additional facilities and corrects a few bugs as compared with the previously available version ANSWERver5 XLS All that is required to update your existing version 5 ANSWER Smart Workbook to version 6 0 is to open the file ANSWERver6 0 XLS and follow the Making an existing workbook aware of ANSWER Smart Workbook facilities procedure that is documented at A 2 above A 5 Adding a New ANSWER Smart Sheet to the Current XLS This facility allows the user to easily add anew ANSWER smart sheet to their current ANSWER Smart XLS To use the facil
53. ons across regions B 1 Multi region models that do not have common naming conventions across regions Suppose a multi region model that does not have common naming conventions across regions involves N regions say REG1 REG2 REGN In this situation the fundamental principle used in building the Load XLS is that each Declaration or Data sheet should contain just declarations or data for a single region corresponding to the single region specified on cell B1 of the sheet More specifically to handle such a model in the ANSWER version 5 and higher Load Templates proceed as follows Declaration Sheets For each of the N regions create a single associated Commodities sheet That is create a Commodities sheet with cell B1 containing only REG1 on which the declarations for commodities in region REG1 are specified create another Commodities sheet with cell B1 containing only REG2 on which the declarations for commodities in region REG2 are specified and create another Commodities sheet with cell B1 containing only REGN on which the declarations for commodities in region REGN are specified Thus altogether there will be N Commodities sheets Likewise for each of the N regions create a single associated Technologies sheet That is create a Technologies sheet with cell B1 containing only REG1 on which the declarations for technologies in region REG1 are specified create another Technologies sheet with cell B1 containing onl
54. onsiderations apply for the BL TRD ENT and BlL_TRD MAT parameters Explanation of the special considerations is easiest if we first display part of the completed worksheet that specifies bilateral trade in electricity via a link where export technology EXPELC2 in region R1 exports electricity named ELC in region R1 to region R2 and then consider the actions that the user needed to take in the BL_TRD ELC column column H below to put it into its completed state TechData A Check Shit Qualifier a a ROR R2 RS R4 RS Re R7 Ro RY Techiame TechDesc TACT TCAP Units Refresh Units Commi Comm UT INP ENT x BI TRD ELC Same gt TechName TechDesc Units CommliN CommOuT TID EXPELC Electricity Exports from K1 ta R2 PJ Pofa ELC Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 37 The Export part of the bilateral trade link is specified via the row 11 information in columns A G of the above worksheet namely that region R1 contains export technology EXPELC2 with the CommIN entry of ELC coupled with the INP ENT x data entry of 1 indicating that this technology exports ELC The mport part of the bilateral trade link is specified via the column H information in rows 1 and 5 7 coupled with the data entry of 1 in cell H11 In particular note that 1 The cell H1 entry of R2 indicates that the import region is region R2 2 The cell H6 Qualifier entr
55. onventions across regions In particular note that version 5 and higher of the ANSWER Load Templates incorporates extensions to the format allowed for sheets that considerably simplify the specification of declarations and data for multi region models that do have common naming conventions across regions By way of clarification when we say that a multi region model does have common naming conventions across regions we mean that the same item name necessarily has the same associated description and set memberships and units in each region in which it occurs So for example if E01 is a Coal fired power station whose set memberships indicate that it is base loaded and centralized then with common naming conventions across regions E01 necessarily is a base loaded and centralized Coal fired power station in each region in which it occurs Note that a multi region model that does not have common naming conventions across regions is allowed to have the same name occurring in different regions So for example such a model might have the same technology name say E01 occurring in more than one region but E01 need not necessarily have the same description or set memberships in each region We first present the method that should be used for handling multi region models that do not have common naming conventions across regions and then present the method that should be used for handling multi region models that do have common naming conventi
56. or this option to work it is essential that you have specified a valid region in row 1 f you select this option say for a Bl_TRD ENT parameter an Energy Carrier selection form will be displayed only the top half of the form is shown that lists all appropriate energy carriers that occur for the row 1 region region R2 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 Select Energy Carrier for row 1 region R 2 Name will be transferred to Qualifier row 39 ASP ASPB ASPBR3 ASPBR4 ASPBRE ASPBRT ASPR3 ASPR4 ASPRS COMDSL COMKER COMLPG COMNGA R1 R2 R3 R4 R5 R6 R7 RS R9 R2 R3 R4 R5 R6 RT R R5 R6 R7 R R5 R6 R7 R1i R R3 R4 R5 R8 R9 R 1 R R3 R4 2 5 R6 R8 R9 R2 R6 R7 R8 R2 R6 R7 R8 R2 R6 R1 R2 R3 R4 R5 R6 R7 R8 R9 R1 R2 R3 R4 R5 R6 R7 R8 R9 R1 R2 R3 R4 R5 R6 R7 R8 R9 R1 R2 R3 R4 R5 R6 R7 R8 R9 Asphal ASP Traded by Barge Yessel ASP Traded by Barge Yessel Imported ASP Traded by Barge Yessel Imported ASP Traded by Barge Yessel Imported ASP Traded by Barge essel Imported Asphalt Imported from R3 Asphalt Imported from R4 Asphalt Imported from R5 Distillate Heating Oil No 2 to the Comm Kerosene and Other Refined Products t LPG to the Commercial Sector Natural gas to Commercial sector ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIO ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC EFS LIQ ENT ENC
57. ositioning the cursor in column B of a row below 7 and pressing the TechName TechDesc TACT TCAP Units action button brings up a sorted list of the user entries from the Technologies sheet Selecting a technology from this list results in its Technology Name Description and Units being inserted into columns B C and D as cell references links to the Technologies sheet Thus for example if a Technology Name or Description is changed on the Technologies sheet that change will automatically flow through to the Technology Data sheet via the cell reference In columns E and F the commodities input to CommIN and output from CommOUT the technology are listed When more than one input or output commodity is involved including emissions a separate row must be used to identify the commodity and provide the associated data With the cursor in column E or F of a row pressing the CommIN or CommOUT button respectively will bring up the list of commodities that the user provided on the Commodities Sheet Selecting a commodity from this list results in its Name being inserted into column E or F as acell reference link to the Commodities sheet Note that data that is not commodity dependent e g AF CF should appear on the same line as the Technology Name Columns G H I are where the user provides data As is the case for the Commodity Data sheet rows 5 7 are used to identify the nature of the data parameter being provided
58. r 2006 at 11 57 AM ttt CHECK TECHDATA SHEET Technology Data AGR CROATIA Check Cell Bi Region Region List The Region Region List in cell Bi is OK Check Column A Regions Region Lists and Row 1 Regions A1l column 4 region region lists are OK 411 row 1 regions are OK Check All Technology Names On TechData Sheet Match with Technologies Sheet 411 of the Names in the TechName column match Technology Names on the associated Technologies sheet Check For Duplicate Technology Names On TechData Sheet There are no Duplicate Names in the TechName column Check All CormmIN Names On TechData Sheet Match with Commodities Sheet 411 of the Names in the CommIN column match Commodity Names on the associated Commodities sheet Check All CormmOUT Names On TechData Sheet Match with Commodities Sheet 411 of the Names in the CommOUT column match Commodity Names on the associated Commodities sheet Check All Parameter Columns On TechData Sheet 411 of the Parameter Columns are OK 4 gt For Help press F1 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 18 9 Constraints Data ConstrData Sheet The Constraint Data sheet is where data associated with user defined constraints ADRATIOs are provided An example version 6 Smart XLS Constraint Data sheet is shown below A B ConstrData DEMO Refresh ConstrHame ConstrDesc Units Units TechName R
59. st contain the comma separated region list REG1 REG2 REGN More specifically to handle such a model in the ANSWER version 5 and higher Load Templates proceed as follows Declaration Sheets Create a single Commodities sheet with cell B1 containing the region list REG1 REG2 REGWN on which the declarations for commodities in every region are specified If necessary specify a region list in column A to indicate that some commodities are to be included for a subset of regions rather than for every region Likewise create a single Technologies sheet with cell B1 containing the region list REG1 REG2 REGN on which the declarations for technologies in every region are specified If necessary specify a region list in column A to indicate that some technologies are to be included for a subset of regions rather than for every region And likewise create a single Constraints sheet with cell B1 containing the region list REG1 REG2 REGN on which the declarations for constraints in every region are specified If necessary specify a region list in column A to indicate that some technologies are to be included for a subset of regions rather than for every region Note that on a declaration sheet there is a restriction imposed by the way that the ANSWER smart XLS functions duplicate Names are not permitted However in version 5 and higher of the ANSWER Load Templates what is allowable without creating a duplicate
60. this checkbox and then click on the OK button This results in the Set Memberships of ADRATIO RULE_ ADR being placed in column E at the cursor position For example see cell E12 on the previous page where this is the Set Memberships specification for the Constraint RENEWELC See section 9 Constraints Data ConstrData Sheet for details of how to specify the data associated with a Rule based Constraint Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 12 7 Commodity Data CommData Sheet The Commodity Data sheet is where data associated with commodities e g demand levels energy carrier efficiencies electricity transmission and distribution costs are provided An example of a Commodity Data sheet for Demands is shown below E4 Microsoft Excel SEE REDP_COM_Croatia_ xls File Edit View Insert Format Tools Data Window Help _ o x OSH S S6RY SMBlo Bz A s n B 2 10 a ae E a a 1 CommData CROATIA Chk Sheet CommiHame CommbDesc CommUnit Pariuri DEMAND ELF FRAM FRAM FR FF CommName CommDesc i 2000 TID TID TID Commercial Cooling Small Ex PJ 0 30 1 00 0 70 Commercial Cooling Large Ex PJ 1 01 1 00 0 70 Commercial Heating Small E4PJ 1 42 1 00 0 30 Commercial Heating Large Ex PJ Ate 1 00 0 30 Commercial Hot Water Small PJ 0 40 1 00 0 25 0 14 0 16 Commercial Hot Water Large PJ Lao 1 00 0 26 0 14 0 16 Commercia
61. ties Technologies Demand Data 4 Ready ete ae A ee ye If the above sheet had been created using an ANSWERver6 xls violet would replace green The key information entered on the Technologies sheet that is directly provided by the user are the Technology short Names TechName and Descriptions TechDesc appearing in columns B and C respectively In addition after positioning the cursor in columns D or E or F of a row the TACTUnit or TCAPUnit or Technology Sets action buttons may be used to select the Technology Activity Units or Technology Capacity Units or Set Memberships specifications respectively A sample Technology Set Memberships form is shown below Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 9 Set Memberships Set Memberships J Technology TCH SRCENCP E Conversion CON C Renewable RNT og Electric Mot District Heat IELE C Might Storage System NST B Standard not BAS NLM NBN E Base Loaded BAS B No Load Management NLM J Electric and District Heat CPD B Standard not B45 NLM NBN Base Loaded BAS E No Load Managernent NLM B District Heat Not Electric HPL B Storage STG Sat emand DMO E Process PRC E Energy PRE B Material Volume FRW E Material Weight PR J Resource SACEMCF B Export SEP_EXP E Import SEP_IMP B Extraction SEF_MIN B Renewable SEP_ANw Fy Stockpile SEP_STE
62. to create a new workbook 1cccccsceeeccnscseccnsenecccsausescnacseesscueeensausesssaceesensanesensans 28 A 4 Updating an existing workbook that is already aware of ANSWER Smart Workbook facilities when Noble Soft distributes an updated version of the ANSWER smart XLS 29 A 5 Adding a New ANSWER Smart Sheet to the Current XLS cccccccsececenseeeeeeeeeeens 29 Appendix B Extension of ANSWER Load Templates to handle multi region models 32 B 1 Multi region models that do not have common naming conventions across regions B 2 Multi region models that do have common naming conventions across regions 33 B 3 Technology Data sheet extension to handle Bilateral Trade between Regions 35 Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 2 Acknowledgement The development of the ANSWER Load Templates is the result of a collaborative effort between Gary Goldstein of International Resources Group and Noble Soft Systems 1 Background The task of assembling data for a MARKAL model requires various data preparation steps that are usually performed using the power and flexibility of soreadsheets Excel New ANSWER smart load templates have been developed to allow the analyst to assemble the model data from its sources in a form readily loaded into ANSWER The process is guided by a few rules and supported by action buttons and selection trees or lists
63. ty must exist on the Commodities sheet e Regardless of which Qualifier option applies the name of the import technology is always determined by forming IMP lt ent gt P where lt ent gt is the implied actual import commodity name and P is the final character of the export technology name The import technology must exist on the Technologies sheet and an OUT ENT r of 1 must be specified for the import technology and its associated import commodity on a TechData sheet e Since the name of the import technology is always determined by forming IMP lt ent gt P where lt ent gt is the import commodity name the import technology name always satisfies standard SRCENCP naming conventions namely that the first 3 characters are IMP and the remaining characters from 4 to the second to last character comprise the name of the import commodity It therefore follows that it is only possible to use the smart XLS to specify a bilateral trade link in which the import technology name satisfies standard SRCENCP naming conventions e The export technology name does not need to satisfy standard SRCENCP naming conventions Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 e Finally note that BL TRD ELC instances are automatically generated for every TimeSlice for the TimeSliced Bilateral Trade parameter Bl_TRD ELC This is also the case for the TimeSliced Bilateral Trade parameter BL TRDCSTE
64. will bring up the list of technologies that the user provided on the Technologies Sheet Selecting a technology from this list results in its Name being inserted into column E as a Cell reference link to the Technologies sheet Version 5 and higher Smart XLS enhancement to allow Data for a Rule based Constraint to be specified on a ConstrData sheet As already noted in section 6 Constraints Sheet the ANSWER version 5 and higher Smart XLS has been enhanced as compared with version 4 to allow the specification of Rule based Constraints The only requirement is that the ANSWER database that is associated with a version 5 and higher smart XLS must be one that is Rule based Constraint aware and must contain the rules Technology Items Filters that are needed to define the Rule based Constraints of interest The ConstrName ConstrDesc Units action button is used to select Rule based Constraints from the Constraints sheet in exactly the same fashion as for selecting ordinary Constraints It has been used to place the rule based constraint RENEWELLC in row 13 of the above ConstrData sheet However when the cursor is placed in the TechName column column E in a row that corresponds to a Rule based Constraint so in either row 13 or row 14 of the above ConstrData sheet and the TechName action button is invoked the following message appears Noble Soft Systems Pty Ltd 2005 07 August 20
65. y REG2 on which the declarations for technologies in region REG2 are specified etc And likewise for each of the N regions create a single associated Constraints sheet That is create a Constraints sheet with cell B1 containing only REG1 on which the declarations for constraints in region REG1 are specified create another Constraints sheet with cell B1 containing only REG2 on which the declarations for constraints in region REG2 are specified etc Noble Soft Systems Pty Ltd 2005 07 August 2007 ANSWERv6 MARKAL Load Templates Manual version 6 1 33 Data Sheets For each of the N regions create one or more associated CommData sheets That is create one or more CommData sheets with cell B1 containing only REG1 on which the data for commodities in region REG1 are specified create one or more CommData sheets with cell B1 containing only REG2 on which the data for commodities in region REG G2 are specified and create one or more CommData sheets with cell B1 containing only REGN on which the data for commodities in region REGN are specified Likewise for each of the N regions create one or more associated TechData sheets That is create one or more TechData sheets with cell B1 containing only REG1 on which the data for technologies in region REG1 are specified create one or more TechData sheets with cell B1 containing only REG2 on which the data for technologies in region REG2 are specified etc And li
66. y of lt SAME gt indicates that the import commodity in the import region has the same name as the export commodity in the export region so in this case ELC Alternate Qualifier options to lt SAME gt are available see below 3 The BL TRD ELC data entry of 1 in cell H11 indicates that this column H import technology is linked to the row 11 export technology 4 For this bilateral trade link the name of the import technology is taken to be IMPELC2 determined by forming IMP lt import commodity name gt lt final character of export technology name gt 5 The import commodity must exist on the Commodities sheet 6 The import technology must exist on the Technologies sheet and an OUT ENT r of 1 must be specified for the import technology and its associated import commodity on a TechData sheet Now we consider the actions that the user needed to take in the BL TRD ELC column column H to put it into its completed state as shown above After positioning the cursor in cell H5 clicking on the Parameter action button and selecting parameter BL TRD ENT from the Technology Parameter list column H appears as follows TechData ROR RR RS R4 RS RE RY Ra Ro Region Refresh Check Sht TechName TechDesc TACT TCAP Units Units Commlll CommOUT Parameter INP ENT x BL TRO ELC Qualifier Same gt TechName TechDesc Units CommlN CommOUT TID EXPELC Electricity Exports from R1 ta R2 PJ Pita ELC 1 The fo

ANSWERv6-MARKAL Load Templates Manual - Noble

Contents

Download Pdf Manuals

Related Search

Related Contents