TREMOVE v2.7 User Manual - Transport & Mobility Leuven
Contents
1. TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 20 Run TREMOVE gt gt Demandcalibinit TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 37 TRANSPORT amp MOBILITY LEUVEN Figure 21 Run TREMOVE gt gt Demandsiminit WWW TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 38 TRANSPORT amp MOBILITY LEUVEN Figure 22 Run TREMOVE gt gt Stock_Road_BY 39 gt stock Road BY back gt gt Figure 23 Run TREMOVE gt gt Stock_Rail_BY TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 40 Figure 24 Run TREMOVE gt gt Fuel_Consumption_And_Emissions aa J pn_And_ Emissions A i TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 41 Figure 25 Run TREMOVE gt gt Money_Cost_Road y Costs Road Mon o CS TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses Mot TRANSPORT amp MOBILITY LEUVEN 422. Year Veh Name vawe BE f RMILnew RMliLnew RMILnew RMILnew RMILnew VAT RVAT RVAT RVAT RVAT i buses i BUS CNG compressed natural gas buses COACH coaches SHIDI heavy duty trucks diesel lt 7 St HTD2 heavy duty trucks diesel 7 5 16t HTD3 heavy duty trucks diesel 16 32t HTD4 heavy duty trucks diesel gt 32t a heavy duty trucks gasoline light see trucks diesel Uae ETT e hI b of 32 Datasheet View Figure 8 shows the relations between table T VEHICLE PARAMETER and its dimensions T and VEHFULL this view is accessible via Access menu Tools gt Relationships For example for every value for Veh in table T VEHICLE PARAMETER a corresponding value of Name must exist in table VERPULL Dimension RUN e g in RVAT RVEH T RUN is used in the model to distinguish between data for the basecase run RUN BC and for the scenario simulation RUN SIM run This dimension is always ignored in the input database as it only contains basecase data Also note that the input database contains exogenous model data for a countries Therefore all parameter tables have an additional relation with table COUNTRY When the value of a parameter is the same in all countries as is the casethe special value ANY is used in the Count ry field 7 TRANSPORT amp MOBILITY LEUVEN g link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 18 Figure 8 Relati
3. All calculations are single threaded so only one CPU core is used RAM A minimum of 1GB is needed to avoid swapping to disk as this severely slows down the calculations Some calculations use a bit more than 1GB of RAM so 2GB or more is recommended STORAGE Some parts of the TREMOVE runs heavily depend on the speed of the hard drive Laptop drives are considerably slower than desktop hard drives If several scenario runs for many countries are envisaged running TREMOVE on a desktop computer is recommended Fast 7 200rpm SATA desktop drives are recommended drives with higher spindle speeds 10 000rpm or higher are even better For example following hardware configurations are used by Transport amp Mobility Leuven Configuration 1 TREMOVE run time for one country 15 minutes CPU Intel Core 2 Duo E6850 3GHz 4MB L2 cache RAM 8GB dual channel 667MHz DDR2 STORAGE 10 000rpm SATA drive Western Digital Raptor 1500ADFD 150GB 16MB buffer Operating system Windows XP Pro 64 bit edition SP2 Configuration 2 TREMOVE run time for one country 30 minutes CPU Intel Pentium IV 540 3 2GHz 1MB L2 cache RAM 1GB dual channel 533MHz DDR2 STORAGE 7 200rpm SATA drive Seagate Barracuda 7200 7 160GB 8MB buffer Operating system Windows XP Pro SP2 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 4 1 2 Software requirements 1 2 1 Opera
4. Figure 26 Run TREMOVE gt gt Money_Cost_Road gt gt Logit_Life_Time_Costs oe Logit Life Time Costs back TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 27 Run TREMOVE gt gt demandcalibnext UU TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 43 TRANSPORT amp MOBILITY LEUVEN Figure 28 Run TREMOVE gt gt demandsimnext VTC TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 44 TRANSPORT amp MOBILITY LEUVEN 45 Figure 29 Run TREMOVE gt gt Stock_Road ko cay a r Convert Technolog Sales Roac TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 30 Run TREMOVE gt gt Stock_Rail Figure 31 Main gt gt Run_Simulation TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 46 TRANSPORT amp MOBILITY LEUVEN i This kind of modularisation is normally provided in programming languages through functions or procedures Unfortunately GAMS does not support this mechanism The much
5. Table 1 Batch scripts for generation of inc input files Name of Batch script Generates contents of Buid Sets Road Sets Road ince Build seis RALL Dets Bail ane Build Sets INW Sets 1W anc TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 21 The scripts ending with Country generate country specific data and take a country code AT BE as a B ild Parameters Road Emissions Country BC Road Emissions ine parameter Each script generates several related sets or parameters from the database into an include file The correct script the one containing the parameter or set that has been updated in the database can be located with a simple text search Note that the file path to TREMOVE input mdb has to be specified in file T Input DB Access GAMS Conversion Mdb name txt before the build procedures can be executed The scripts write the resulting inc files to folder Input DB Access GAMS Conversion These files should be copied to Model Input a country subfolder for the country specific inc files This is the folder from which input data is read by the GAMS model This procedure is further automated via the scripts Build bat and Build A11 With Build one or mote scripts a Table 1 scripts by default can be executed Build A11 gives the opportunity to run Build for a list of countries aX countries by default Build will also copy the inc fil
6. 30 T File structure As the code is designed in a modular way TREMOVE is made up of a lot of small files each modelling one specific aspect The following pages guide you through the structure of the TREMOVE code to indicate where each file plays its role in the overall model structure or to help you find the right file you should modify to adapt TREMOVE to your specific needs Every grey rectangle stands for a module that is expanded on another page The white rectangles stand for a file of GAMS code the tubes stand for data that is imported The structure of the files has been designed in SmartDraw and then imported in this Word document The original SmartDraw objects contain hyperlinks that allow you to navigate through the TREMOVE structure every grey box is clickable and will lead you directly to the right expanded page SmartDraw has been used because the viewer is free of any charge The original SmartDraw objects and the viewer can be obtained from Transport amp Mobility Leuven The following pages are based on TREMOVE version 2 44 thus have not yet been updated to v2 7 The v2 44 and v2 7 model structure are very similar however TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 14 Main mni ae lt lt lt lt lt lt lt lt TRANSPORT
7. MODEL IMPLEMENTATION eeessseseseseseseescsesesesececscecseecoesececececsescoeseoeceoecseseseeeoeoeosoeceeeeeeoeoeosceoseseeeeo 8 3 1 IVES E ste E A NT OA AE ceca E AE N NEA A A EN EE A E eens 8 32 ONE MODR THIRT ONE COUNTR IES ssesciecsesinastbacessvaceciouadibadeeesicacteadonsscteesicacisadeuedsuataesacdsadosediuatinacdsnseeseceneaiecdiaas 8 3 3 KODEER EO tc aserso destinies A EAA AAEE OEE 8 3 3 1 OIC COTA FOI E A O E E E N A E 9 A Folde a A E E E E E E ERE E EEE 10 B Structure of the demand module code seis sisssscdssansrecasvensdiaianviecdevanhaneasinsenaeloag buseaig vastnesnansen snnsanda svapdiaeusphoaddasanpanvoainsenaeinageansanenents 10 C Callige the demand module mthe vehicle stork MICS ais esisaecusth sy casarsiniadeaicsbuiiunsuintasepis nesses miiucsenbiedbetieoni eds ENON 11 D At asG eh ae wi Ve ICS stock modulos oirra ena EEEa AES EEEE A EEEE EEEE EAE 11 3 4 IPEN EPO R ENE ENO EAN 12 3 4 1 D E 7 OEE OEI E E A ETEA AE T E E EAEE 12 4 INPUT PROCEDURES FOR VEHICLE STOCK EMISSIONS AND WELFARE 0008 14 4 1 T E aA A EEA AE ETA AE OE eacciae 14 4 2 DOT a a EAO E E E A AE 15 4 2 1 E A E T NA E A A A E A E A E E eat 15 4 2 2 D E T EEEE EAT ETETE E E E ETETEN EEN A ATEOA 15 4 2 3 La T T TE O A E EA EAEE A AE EAS 18 4 3 GENERATING GAMS INCLUDE FILES cccccccssssssessssssesscsssesscesecsssesseseesssessessecssesscneesssessessecsecsecesecsaseseesssenseseeeaeens 20 4 4 INPUT FILES POR THE DEMAND MODUL Earrainn E E 22 5
8. OVIPUT PROCEDURES errr ere eee ne Se ee ee eee ee eee eee 23 5 1 E A E E O doce E A 23 5 2 CONVERTING GAMS MODEL OUTPUT TO STRUCTURED OUTPUT DATA uie cccccsscssscsssccsssssscessssssessscessseseeseseees 24 5 3 IMPORTING STRUCTURED OUTPUT DATA IN THE OUTPUT PURE DATABASE ssesesssesssresresssressressseessreessessressee 24 5 4 QUERIES TO GENERATE OUTPUT_PROCESSED DATABASE TABLES esessssessesessesessestesosseseesossestusesesssseeseserseeseses 25 5 5 E IN Oa E ere ene A oc ES AE AE AN u sen SIA N E AT 26 6 ADDING SIMULATION SCENARIOS sasccccssnciscesevcadecesenisinedsbacesaieticancscnaicetentesdateorancsiecasaecntantreandene 28 De OM SW Gg eo acs es vec va sce E E dened gees A ice seoneemeeed arecasce 30 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 1 1 1 System requirements Hardware requirements The minimal hardware requirements for using TREMOVE ate Any computer that is able to run at least Windows 2000 should be able to run TREMOVE In the past Transport amp Mobility Leuven has run TREMOVE on laptops with Pentium II processor and 512MB RAM However for best results it is best to run TREMOVE on recent hardware otherwise the run time will be very long See below for recommended specifications for CPU RAM and hard drive The runtime of TREMOVE depends on CPU Most of the TREMOVE run is completely processor limited So the faster the CPU the better Note
9. gdx g for each country in folder Model Output These archives contain data that have been calculated during the run These files can a o be used to display extra model output values that are not in the standard pivot tables without having to redo the whole model run Note that these output files are automatically overwritten if a new run is executed It is good practice to copy and store outputs elsewhere after each run Expert Tips If you are an expert user you will probably want to short cut some steps in the script code For example you might want to generate pivot tables directly starting from the archived output of an earlier TREMOVE run A custom script can be made for such a task This will however require a good understanding of the individual steps which are described in the different chapters of this document If changes in model or input files are made it might be worth to perform a compilation test for one country before running the complete model A compilation test can be performed as follows 1 Open GAMS via the GAMS IDE 2 Open project Model Run run gpr 3 Open file Model Run run gms 4 Adapt the file paths in the idir statement for the relevant country scenario and scenario variation see 3 4 1 5 Click simultaneously Shift Run button or Shiftt F9 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 8 3 Model implementation The aim of th
10. mote primitive include and bat include constructs offer the only alternative i The working directory is the directory in which the gams command is invoked TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 47
11. starting with hulp The tremove bat procedure will callin output processed mdb the macro UpdateTempTables Once this is done the final TREMOVE output tables can be generated by using pre defined queries To TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 26 do this click in the output_processed database the Queries button in the left pane Then one can run the following queries by double clicking them that generate the final output tables Note that these tables contain all data that is reported in the eventual Excel pivot tables e Demand generates the table with the data for the demand x1s pivot e Stock generates the table with the data for the stock x1s pivot e Emissions_All generates the table with the data for the emissions xl1s pivot e Welfarel generates the table with the data for the first four sheets in the wel fare x1s pivot e Welfare2_MT generates the table with the data for the last sheets of the welfare x1s pivot The database can hold about 17 countries at once Since Microsoft limits Access to handle files of 2 GB it is not possible to put all the countries in one database 5 5 Generating pivot tables The final output of the TREMOVE model is reported in four Excel pivots in Pivots le DEOCK 22 2 Demand xls Se EMLeeions 212 4 Welfare xls The pivots are linked to the aforementioned queries in output processed mdb Each pivot Excel sheet has
12. the current machine Figure 12 Select the Access Driver TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 28 ODBC Microsoft Access Setup Data Source Name Uee EE Description Database Database Select Create Repair Compact Advanced System Database None C Database Figure 13 Adapt the Data Source Name 6 Adding simulation scenarios Simulation scenarios are defined in the Model Scenarios folder As explained in section 3 4 1 they make use of the override mechanism To be compatible with the TREMOVE bat script see section 2 2 following procedure has to be followed Suppose one wants to add a scenario named CAR_POLICY these are the steps that have to be taken 1 Create the folder Model Scenarios CAR_ POLICY Here you will put the overridden files which are common to all CAR POLICY variations 2 Choose a name for the first variation e g CP_1 and create a subfolder with the same name Model Scenarios CAR POLICY CP_ 1 Overridden files which are specific to the variation will be stored here 3 Other variation folders can be created alongside the CP_ 1 folder When the scenarios are set up following this structure TREMOVE can be run by editing the first lines in the TREMOVE bat script and then executing it These folder conventions are the reason for the empty Model Scenarios NULL and Model Scenarios
13. Description FUELSPEC T FUEL FUELPAR_ PARAMETER Fuel specification history GAMMA COUNTRY_PARAMETER Life expectancy parameter 1 GAMMA2 COUNTRY_PARAMETER Life expectancy parameter 2 GAMMAS COUNTRY _PARAMETER Life expectancy parameter 3 ai GAMMA A COUNTRY_PARAMETER Life expectancy parameter 4 GAMMAS COUNTRY _ PARAMETER Life expectancy parameter 5 IWCONFIG T_IWVEH_PARAMETER Indicates for each configuration if a IWCONSFiuel IWVEH_PARAMETER Inland Waterway Fuel consumptior WEMIF WVEH POLL PARAMETER Inland Waterway Emission factor IWENGCOST IWVEH_PARAMETER Additional cost of the engine type IWEQCOST IWVEH_PARAMETER Additional cost of the engine type IWEFCOST T_GENERAL PARAMETER Inland waterway fuel resource cost IWFREDUC WVEH_PARAMETER Reduction in fuel consumption of th IWFTAX IT_GENERAL_PARAMETER Inland waterway fuel tax in EURO IWFUELdens T_GENERAL_PARAMETER Density of inland waterway fuels t HL MOTIVE TAX PARAMETER Marginal cost of public funds Record 4 4 a b epee of 175 Datasheet View NUM A E Another way to find the location of the data you are looking for is by navigating the groups in the database The groups are listed on the bottom left side of the main window in the database see Figure 10 Every group eg Road Cost Other contains a set of hyperlinks to the tables that contain data related to the topic in case of Road Cost Other thes
14. NULL NULL folders Using those in the TREMOVE bat script results in a simulation scenario that is equal to the basecase because no files are overridden Folder Model Vehicle Stock Module contains two empty files Scenario Main gms and Scenario Variation gms which are called from Init Simulation gms In the latter file simulation SIM input values are set equal to basecase BC input values for a long list of input parameters The Scenario Main gms and Scenario Variation gms then are designed to be overridden in the scenario subfolders e g respectively Model Scenarios CAR POLICY and Model Scenarios CAR_ POLICY CP_1 Typically they will specify input values for the simulation SIM input which differ from the basecase BC input values TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 29 Example Folder Model Scenarios FUELTAX includes an empty Scenario Main gms file Folder Model Scenarios FUELTAX HARMONISATION includes a Scenario Variation gms file in which from year 2010 onwards diesel fuel excise taxes are set equal to petrol fuel excise taxes Running tremove bat for scenario FUELTAX and variant HARMONISATION will thus generate a scenario simulation in which from 2010 onwards diesel fuel excise taxes are set equal to petrol fuel excise taxes A 7 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN
15. Z s TRANSPORT amp MOBILITY Wi ee TEF STRAAT O as 000 LEUVEN 3000 LEUVEN Your link to integrated analyses eee http www tmleuven be TEL 32 16 31 77 30 FAX 32 16 31 77 39 Editor Bart Van Herbruggen Last updated 14 December 2007 TREMOVE v2 7 User Manual This document focuses on the technical aspects of running the TREMOVE model The aim is to enable a user with basic IT skills to run the model and offer him a reference manual for making modifications The reader will need a basic knowledge of DOS batch scripting as well as an understanding of the GAMS language in order to understand certain parts TRANSPORT amp MOBILITY LEUVEN 2 Table of contents 05 ore Se CONTENTS eee eee ee ene ne eee ene nee ee ee ee nee ee 2 l SYSICM REQUIREMENTS posin ninne enaA OA E RE EEA EEA EEEE 3 1 1 HARD ARE RO I S eerror nae EEr TaN OER E A NETERA EREE EARE aaa ORTAR Ea 3 1 2 DOR EWA RE Re OU TRE BIN Ess csczsccatassvsonsaanractoncecadssseaniactoaanvacusessatacssaaesaesstca ra rT N a 4 lal B L a O E E E E E O ncessemsedeatcennomren senate ences 4 2a DADO OID a E NN A NA A E A E E A 4 hd E E E E E A A T E A ngs bene ateeeoe acum pease net 4 Pi E O E A O AA IE IAE N A AA EA A EE ET 4 B Smaa eE A A E E EA E ENEE psd dR a EEE A EI AEA ESTAA 4 1 2 4 E D T OT E E E E oeaieteohtotens 5 Fe AGEING STARTED oann oem ete evens went eco tnceescesecen ee nencaseaeees 6 2A W ELIEN I E ea E E E A 6 L PEENI E E E E EEEO O A E OE AEAN 6 3
16. a macro called RefreshPivot which refreshes the pivot data by linking to output processed mdb It requires the database to be in the same directory as the Excel sheet The tremove bat procedure makes use of an additional Excel sheet named Refresh xls This latter Excel file does not contain any data but contains only a special macro which is automatically started when the file is opened This macro starts each of the RefreshPivot macros in the other Excel sheets Hence the four pivot Excel files are automatically updated with the latest data from the output_processed database By default the pivots only include data for five year intervals 1995 2000 2005 2010 Le only for these selected years the data in output processed mdb is transferred to the pivots In order select other years select a data cell in the pivot right click it and choose Wizard gt Back gt Get Data This opens Microsoft Query Click View gt SOL to adapt the selected years in this SQL code Note that given file size restrictions of Excel the pivots cannot include data for all years and countries together thus one has to make a selection Expert user tip If the pivots and output databases are copied to another folder than T model pivots e Using the RefreshPivot macro will refresh the pivot figures using the output processed mdb that is in the same folder as the pivots e Just refreshing the pivot without using the macro will refresh the piv
17. amp MOBILITY LEUVEN Your link to integrated analyses 31 TRANSPORT amp MOBILITY LEUVEN 32 Figure 15 Main gt gt Define Sets define be DOH HL JUULUUUU UU TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 33 Figure 16 Main gt gt Define Parameters eters Uur TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 17 Main gt gt Calibrate Base_Case AU TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses 34 TRANSPORT amp MOBILITY LEUVEN 35 Figure 18 Main gt gt Calibrate Base_Case gt gt Init_Base_Case_Road Years Bi Init Missing Re Init Logit Li TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses Cop er TRANSPORT amp MOBILITY LEUVEN 36 Figure 19 Main gt gt Calibrate Base_Case gt gt Run TREMOVE and Main gt gt Run Simulation gt gt Run TREMOVE Run TREMOVE back t L ra
18. ave located the Access table in which parameter you want to change is stored see 4 2 3 updating data the database is easy just replace the original data by the new data in the database tables Time Saver Tip Importing data into MS Access can be done in many ways but in most cases the fastest is with the help of MS Excel Start from a sheet which contains the data in the same layout as the database table Then simply copy the data select the entire last row of the Access table and paste the data in it When modifying parameter data in the database don t forget to update the Parameter documentation table see 4 2 3 Only exogenous model parameters and their dimensions sets are stored in the database and can be modified in the database The remaining endogenous sets and parameters are defined and calculated in the model code This distinction between endogenous and exogenous data is reflected in the file structure of the TREMOVE model Exogenous parameters and sets which are stored in the database and converted into inc files to be included by the GAMS code are located in the Mode1 Input folder The remaining parameters and sets are endogenous and are directly defined and calculated in the GAMS code which is located in other Model folders Changes to the databases are not automatically propagated to the GAMS mode They will only take effect after the generation of formatted data files include files with extension inc wh
19. cation of Main gms gams run gms idir New Main Input BE Input Vehicle Stock Module Welfare Module This feature is used to implement alternative scenario simulations in TREMOVE Code lines for scenario simulations are stored in a subfolder of Mode1 Scenarios These subfolders are in turn passed as the first items in the idir folder string For example the command gams run gms idir Scenarios FUELTAX HARMONISATION Scenarios FUELTAX Input BE Input Vehicle Stock Module Welfare Module is used to execute the HARMONISATION variant of a FUELTAX scenario for Belgium The default line in the standard batch file that calls the TREMOVE gams code is gams run idiv Scenarios 33 22 7 Scenarios 337 Input a Inputs Vehicle Stock Module Welfare Module s sa ave 2 In which 1 2 and 33 are command line parameters s1 country 32 sim variant e g HARMONISATION 33 sim group e g FUELTAX If you want to use country specific override files in your scenario run you can modify this line as follows gams run idir Scena ari s t3 e2Z Vel 44 Scenarios 45 7 4 lnpuce input eLl Ve icle SLOCK Module Weltars Module s save 22 Of course you then need to make a country specific scenario folder e g Model Scenarios FUELTAX HARMONISATION AT 7 TRANSPORT amp MOBILITY LEUVEN You
20. d in October 2007 it was about 30 euro As an alternative you can request TML to provide you an alternative batch file for running TREMOVE which will not require WinZip This batch file will not delete the uncompressed intermediate model output B SmartDraw The documentation of TREMOVE uses a tool called SmartDraw to illustrate the structure of the GAMS model code There are two versions of this documentation available The first version is chapter 7 in this manual just in text format In order to view this you do not need SmartDraw The second version is a SmartDraw document The advantage of the second version over the Word version is that it includes hyperlinks that allow you to navigate through the hierarchical structure of the GAMS code TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 5 SmartDraw can be downloaded freely from www smartdraw com 1 2 4 GAMS software TREMOVE is programmed in GAMS General Algebraic Modeling System The TREMOVE v2 7 model version can be executed with the free demo version of GAMS v22 0 No GAMS license is needed This version of GAMS can be downloaded at http www gams com download download_old htm On this page follow the link to the GAMS ftp site ftp ftp gams software com and download the folder 22 0 systems win GAMS installation notes are available on the same website http www gams com docs gams win install pdf Actual
21. e demand module is not a module in the sense of those described above but a full GAMS program on its own And it consists of different smaller sub modules This has two important consequences Firstly the Sinclude and Sbatinclude commands are not suitable for calling the demand module instead the special execute GAMS command is needed as explained below Secondly because the calling module and demand module are no longer in the same program specific procedures have been written to exchange data between the demand module and the other modules The following sections discuss the structure of the demand module in more detail TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 10 Figure 3 Call to demand module thick arrow is different from calling other modules TREMOVE OTHER MODULES DEMAND MODULE Module A Module E Module B Module G Module F Module C Module D A Folders The demand module consists of three folders e Model Demand Module Country Input contains subfolders for each modelled country with country specific demand input data stored in an inc file the inc file can be generated automatically from the Demand Input Database in the same folder see 4 4 e Model Demand Module Demand contains the GAMS code for the actual demand module calculations shared by all countries B Structure of the demand module code The demand module code in Model Dema
22. e are the tables COUNTRY PARAMETER I PARAMETER IT ROAD PARAMETER T ROAD PERIOD AGGMODE PARAMETER T VEHICLE PARAMETER VEHICLE AGE PARAMETER VEHICLE PARAMETER TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 20 Figure 10 Groups help you navigate the Input database sE TREMOYE Input Database Access 7000 file format Open f Design New ea E Objects COUNTRY PARAMETER Tables T_PARAMETER T_ROAD PARAMETER T_ROAD PERIOD _AGGMODE_PARAMETER T_VEHICLE_PARAMETER Reports VEHICLE AGE PARAMETER Pages VEHICLE_PARAMETER OuUeries Forms Macros ami ia ts 2 Modules Favorites Road Stock Road Scrappage Road Cost Fuel Road Cost Other Logit General Logit Small Car Logit Medium Big Car Logit HD l L Mil Y 4 3 Generating GAMS Include files Before an update of the database has effect in the GAMS model calculations the data must be converted into a formatted file which can be read by the GAMS model These are called include files and have a inc extension The conversion is not included in the general TREMOVE bat batch file because it is time consuming Instead one has to execute the conversion manually after each updated of the database The conversion is performed by a collection of files DOS batch scripts located in folder Input DB Access GAMS Conversion
23. e second line adds the location of your MS Office programs and of Winzip to the existing folders in your system s Path settings The adapted settings are valid during the entire model run the settings return to their original state after the TREMOVE bat DOS window is closed The next 3 code lines in the TREMOVE bat file make that if Access Excel or Winzip can not be found in the Path folder locations the model will not run but display an error message In that case you have to change the specified paths in the code lines mentioned above Of course you will get a similar message if MS Office or Winzip are not installed on your pc TREMOVE uses macros in Excel to generate the pivot tables that display the final results In Excel the macro security level should be set at low to enable the macro s to be executed This can be done in Excel via Tools gt Macro gt Security To allow running GAMS models as TREMOVE it is needed to express decimals with a period in all input and output files Comma s will not work The easiest way to assure this is to adapt the regional and language settings of your pc control panel gt Regional and Language Options gt ce 99 Customize Set decimal symbol digit grouping symbol and list separator 2 2 Run TREMOVE To run TREMOVE execute the DOS batch script TREMOVE bat by double clicking the file in folder Model Run Alternatively one can sta
24. es to the Model Input folder All Build scripts make use of the mdb2gms tool See http www gams com erwin interface interface html 1 4 4 Download MDB2GMS for more information For expert usets The Build scripts first generate the inc files in folder Input DB Access GAMS Conversion Input Thereafter they are automatically copied to Model Input If ANY ina Country field is replaced by specific country codes the related Build DOS batch script must be modified accordingly add where country 1 to the query L A TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 22 4 4 Input files for the demand module The input for the demand module is stored in the database Model Demand Module Country Input NEC all mdb The information stored in this database includes e Basecase transport quantitities by transport mode e Basecase travel speeds e Basecase tariffs for public transport modes e Duration of the peak and off peak periods e Values of time All this data is derived from the SCENES model This database is not directly read by the GAMS code and it is not automatically converted to GAMS include files by the TREMOVE batch file The database has to be converted to formatted data files again include files with extension inc which can be read by the GAMS code To perform this conversion you can use the batch file extract bat which is located in fo
25. file to be executed Possible values for this parameter are demandcalibinit demandcalibnext demandsiminit and demandsimnext These parameter values are passed through automatically during the execution of the vehicle stock module Next the folder in which the demand module operates thus in which intermediate and output files are stored is indicated parameter wdir The code line also specifies the paths in which the inc input files and the gms GAMS code files are located parameter idir D Data exchange with vehicle stock modules The demand module requires also data from the vehicle stock modules to function correctly And after its execution demand module results are returned to the vehicle stock modules This data exchange is done through the use of gdx files GDX is the GAMS Data Exchange format The file Write Demand Module Input gms in T Model Vehicle Stock Module module ensures that the necessary data is written to following gdx files which are stored in the Module Demand Module folder e Costroad ddx e Costpublic gdx e Costplane gdx e Costis gdx e Networkcost gdx TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 12 These files contain price information for all transport modes that is calculated in the vehicle stock modules and that is read as input by the demand module The demand module writes its results to the following gdx files
26. hese raw output files are converted to structured tab separated text files csv by the GAMS program report gms This program is located and executed in folder Model Report It must be executed using the TREMOVE save file with the restore or r GAMS command The gdx file and the inc are automatically read by the report gms program The tremove bat procedure will automatically copy the raw output files to the folder Model Report and execute Report gms report gms produces an extensive set of csv files that will serve as input to the output_pure database These csv files no longer contain specific references to GAMS set element names The set element names have been converted into integer id numbers Thus the csv files are composed of structured rows and columns of numbers with almost no text characters As normal users will not use these files to consult TREMOVE results these files are automatically deleted by the tremove bat procedure after they have been imported in the output_pure database 5 3 Importing structured output data in the output pure database The MS Access output databases output pure mdb and output _processed mdb are located in folder Pivots The csv files that are generated by Report gms are automatically copied to this folder and are imported to tables in output pure mdb by the Access macro StartImport The report gms code and the Access Start Import macro are executed for every individual country listed in
27. ich can be imported by the GAMS model see section 4 3 A first glance on the input database might be a bit overwhelming The structure will be much clearer when some underlying design principles are understood Moreover one table named Parameter documentation serves as the road map for locating the GAMS parameters Both this table and the design principles are explained below 4 2 2 Database design The TREMOVE input database is designed in MS Access using relational database principles i e as a collection of tables and relations between them Relational databases are used to store data efficiently taking up the least amount of storage room and allowing fast retrieval using the Standard Query Language SQL TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 16 This usually means that the data end up scattered over many tables and are hard to locate without the help of design blueprints The design blueprints for the TREMOVE input database are fairly straightforward Only exogenous GAMS parameters are stored along with their dimensions The dimensions in turn correspond to GAMS sets see Figure 6 for an illustration Figure 6 Relational database representation of a GAMS parameter with three set dimensions Dim1 Dim2 and Dim3 Parameter Dim1 Dim2 Dim3 Dim1 Table relation Parameter Table Name String Description String Dim1 Name String Dim2 Name Stri
28. ies a output_processed database MS Access Step 4 Generating pivots lt a oe pivot reports xls files TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 24 5 2 Converting GAMS model output to structured output data The first step in the output procedure is the conversion of raw model output to structured csv files that can be imported in the output_pure database The raw model output consists of several files e TREMOVE save file In this file all GAMS sets and parameter values are saved with the save or s GAMS command see GAMS documentation for more information The save file does not include information from the demand module which is a GAMS program on its own see 3 3 1 e demandsimdump gdx This file is produced by the demand module after its execution in the last year of the model run This file contains a dump of the relevant demand module output parameters for all years e Active Country inc This file contains the name code of the country for which the output is being processed AT BE It is automatically generated by the tremove bat batch procedure while TREMOVE is executed for a list of countries e Variant inc This file contains the name of the scenario variant that has been run This name is used in the database and pivot tables to identify the scenario variant This file is automatically generated by the tremove bat file T
29. is chapter is to give an overview the software used for building the TREMOVE model 3 1 GAMS The TREMOVE model calculations are implemented in the GAMS language GAMS is short for General Algebraic Modeling System and is particularly well suited for doing simulations that involve large scale non linear optimisation problems GAMS user guides and tutorials can be found on www gams com This chapter is not intended to go into the details of the language We restrict to some conceptual issues in order to make it easy to understand the TREMOVE model for a reader with a minimal background in the GAMS language 3 2 One model thirty one countries A common model is used for all countries Thus there is one TREMOVE model code that is used for all countries As a consequence modifications and developments of the model always apply to all countries which results in guaranteed consistency between the countries This common model then is executed for a specific country by feeding it with country specific exogenous input parameters see figure below Figure 1 A common model is run with country specific parameters Country specific model parameters TREMOVE Model OUTPUT Country specific output 3 3 Modular structure The TREMOVE model is composed of several smaller pieces called odules Each module captures a single coherent piece of model behaviour A modular structure offers a number of advantages e The software conceptual st
30. lder Model Demand Module Country Input This batch file calls expMDB2INC bat which does the actual conversion of a part of the database to an include file for GAMS This batch file does the conversion for one country A list of country codes is passed as a command line parameter by extract bat One can edit the list of countries in extract bat to match only the countries for which data has been updated Besides passing the country code extract bat also ensures that the output of the conversion is stored in the right country subfolder TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 23 5 Output procedures 5 1 Overview The TREMOVE output procedure converts raw GAMS model output into user reports in pivot tables The procedure consists of following steps 1 Convert raw GAMS model output to structured output data 2 Import the structured output data in the output_pure database 3 Execute queries to generate output_processed database tables 4 Generate pivot tables based on the output_processed database tables These steps are illustrated in and further discussed in the following sections Figure 11 The different steps for producing TREMOVE output gdx raw model output gdx and save files Save Step 1 report gms procedure J structured model output csv files Step 2 Writing to database a output_pure database MS Access Step 3 Database quer
31. ly only 2 of the procedures described in these installation notes need to be executed 1 Run setup exe 2 Add the GAMS directory to your path Note that TREMOVE has been developed in GAMS v22 0 compatibility with other versions of GAMS is not assured Also some of the earlier TREMOVE versions e g v2 5 can not be run without a GAMS license TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 6 2 Getting started 2 1 Install TREMOVE TREMOVE is developed for the Microsoft Windows platform There is no installation program for the TREMOVE model Basically all you have to do is download the TREMOVE archive file from http www tremove org model and unzip it in a chosen folder However the scripts which are used for running TREMOVE rely on a number of other applications Mucrosoft Access e Microsoft Excel e Winzip o GAMS 022 0 free demo version TREMOVE needs to know the location of the program files of MS Office and Winzip These are set in the TREMOVE bat file which can be found in the folder Mode1 Run The following lines in TREMOVE bat ensure that every time Access Excel or Winzip is called these programs are searched for in the specified paths set Oldpath PATH PATH Ol1dPath C Program Files Microsoft Office Officel0 C Program Files WinZip The first line reads the current Path settings of your system which you do not want to lose Th
32. nd Module Demand contains seven GAMS files e Demanddefinitions gms e Demandcalibinit gms e Demandcalibnext gms e Demandcalib gms e Demandsiminit gms e Demandsimnext gms e Demandsim gms Figure 4 gives an overview of how these different files are used during a TREMOVE tun for one country TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 11 Figure 4 Demand module GAMS code structure Basecase run Simulation run demandsiminit first model year demandcalibinit e demanddefinitions e demandsim transport e demanddefinitions e demandcalib transport demand input file inc demandcalibnext e demanddefinitions vehicle stock modules demandsimnext e demanddefinitions e demandsim later years e demandcalib costs components C Calling the demand module in the vehicle stock modules As mentioned earlier the demand module is called within the other modules by making use of the GAMS execute command More specificly it is called from the modules that perform vehicle stock calculations This is done in the Call Demand Module gms file which differs slightly for each country and can be found in the country subfolder of Model Input This file contains the following code line execute gams 1 wdir Demand Module idir Country Input AT Demand This code line expects a parameter 31 indicating the name of the specific GAMS
33. ng Dim3 Name String Value Real Number Dim2 Table Name String Dim3 Table Description String Name String Description String Tables containing GAMS sets are easy to locate in the database They have the same name as in the GAMS model or one that is very similar e g e T set of years e N set of vehicle ages e VEHFULL full set of road vehicle types e TECHFULL full set of road vehicle technologies e 4 All records are uniquely identified within the table by the Name field This is in relational database terms the primary key Contrary to sets no table with the same name as a GAMS parameter exists The reason is that many GAMS parameters share the same dimensions e g e RVAT RVEH T RUN VAT rate by road vehicle type and year e RMILnew RVEH T RUN Mileage of a new vehicle by road vehicle type and year Thus it is more convenient to bundle these into one table with an additional Name field For example both parameters RVAT and RMI Lnew are stored in table T VEHICLE PARAMETER see Figure 7 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 17 Figure 7 Table T VEHICLE PARAMETER containing GAMS parameters RVAT and RMILnew Also shown Tables VEHFULL corresponding to GAMS set RVEHFULL and T GAMS set T Microsoft Access File Edit View Insert Format Records Tools M BS 44 4 gt e of E T_VEHICLE PARAMETER Table FT County
34. o the output pure mdb and includes queries to generate the final TREMOVE output tables Expert Tips The link is not automatically updated when the database files are moved from one folder to another the output processed mdb will continue to refer to the information in an output pure mdb in the old folder So if one moves the database files to another folder one has to update the link This can be done as follows A 1 Open the output processed mdb A 2 Go to tools gt Database utilities gt Linked table manager if this is not installed on your PC install it or go to B 1 A 3 Make sure Always prompt for a new location is ticked A 4 Click Select All A 5 Click OK A 6 Browse to the right location of the output pure mdb and select it click open Part B only if you do not have the linked table manager B 1 Go to the table view in the output processed mdb B 2 Delete all the linked tables you recognise them because there is an arrow in front of their name E g Air emission isa linked table hulp EMI A11 is not Make sure not to delete any of the other tables B 3 Go to File gt Get external data gt Link tables B 4 Browse to output pure mdb in the right folder and select it click open B 5 Click all the tables you want to link to and click OK The fastest way to do this is by first clicking select all and then unselected the fixed tables ct r1 click The fixed tables are Welfare2 transposeEmiSel and the tables
35. onships of T VEHICLE PARAMETER Microsoft Access Relationships Seles wA File Edit View Relationships Tools Window Help Type a question for help O m s E LA V db E l hy Bs Bet x EB a r ff x COUNTRY T_VEHICLE_ PARAMETER 4 2 3 Table parameter documentation Table Parameter documentation is the only table where all GAMS parameters are collected making it very convenient as a road map for the input database It is also used to keep track of the different data sources As can be seen in Figure 8 the name of the parameter Name field must correspond to a record in Parameter documentation This is true for T VEHICLE PARAMETER as well as for all other parameter tables The Description field repeats the GAMS parameter description thus giving additional information about the parameter to the user see Figure 9 The field Table info in table Parameter documentation contains the table in which a parameter is stored It has no other purpose than pointing the database user into the right direction Z TRANSPORT amp MOBILITY A LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 19 Figure 9 Table Parameter documentation serves as a road map for the input database pointing to the table where a GAMS parameter can be found Microsoft Access PARAMETER_NAME Table Biela E File Edit View Insert Format Records Tools Window Help f X bE E u Slav imaa nea a FB mlb a I flame Tale
36. ot figures using the output processed mdb in the location where you last applied the refresh macro typically T model pivots This is also the case if the pivot queries are altered in the copied pivot file e g if years are added to the pivots TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 27 Trouble shooting In case you get the error message Microsoft ODBC driver not found This can be caused because your ODBC driver which takes care of the communication between Excel and Access is not recognized The macro in excel that refreshes your pivot table expects the driver to be called MS Access Database which is the default name in English PC s To check and modify the name of your ODBC driver please do the following Go to your Administrative tools either from our start menu or in your control panel Select Data sources ODBC You will see a screen similar to Figure 12 Select the Microsoft Access Driver and click configure You see Figure 13 Adapt the name of the data source to MS Access Database Click OK twice DEC Data Source Administrator Microsoft dBase Driver dbf Excel Files Microsoft Eecel Driver xls MS Access Database Microsoft Access Driver mdb An ODBC User data source stores information about how to connect to the indicated data provider A User data source is only visible to you and can only be used on
37. r link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 14 4 Input procedures for vehicle stock emissions and welfare 4 1 Overview Introducing new basecase input data into the TREMOVE model must be done in two steps see Figure J 1 Import the data into the input database 2 Extract GAMS include inc files from the input database Figure 5 The different steps for producing TREMOVE input input source various file types Step 1 l input database MS Access Step 2 l GAMS include files inc files Section 4 2 describes the structure of the input database in more depth The second step converting the database into GAMS include files is the subject of section 4 3 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 15 4 2 Input database 4 2 1 Updating data The input databases is file TREMOVE input mdb in folder Input DB This database contains e Lists of the elements of sets used in the model code e g the years the vehicle types etc e All information related to the exogenous baseline except those included in the demand module input database see 3 3 1 e g public transport tariffs fuel resource costs e Data for the baseyear e g 1995 vehicle fleet in Austria or timeseries for historic years e g 1995 2004 vehicle fleet in Belgium e Fixed model co fficients e g COPERT co fficients for emission calculations Once you h
38. rt TREMOVE bat from the DOS prompt The latter approach has the advantage that one can follow the proceedings of the calculations in the DOS window TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 7 Before starting a run one has to specify the simulation scenario and countries by editing the TREMOVE bat script in a text editor e g in Notepad Choose the countries you want to run the model for by limiting the list of country codes in line set TREMOVE COUNTRIRSSAI Be CH C4 DE DK ES FI ER GR HU IE IT LU NL NO EL PT om ol UK BE LT LV MT CY SK IR HR RO BG Choose the simulation scenario you want to run by editing the line Set TREMOVE SCENARIOSFUELTAX The possible simulation scenarios correspond to the subfolders in Model Scenarios In the distributed TREMOVE version these are e NULL do nothing i e simulation equals basecase e FUELTAX tutorial fuel tax policy scenario Choose a scenario variation by editing the line set TREMOVE SCENARIO VARIANT HARMONISATION Each scenario can hava a set of variations corresponding to the subfolders in the Model Scenarios folder For example scenario FUELTAX has only one variation e HARMONISATION The TREMOVE bat script ensures that the following output files are automatically created e Excel pivot tables in folder Pivots e Access output databases in folder Pivots e Zip archives containing intermediate files lst csv
39. ructure is emphasised thereby improving readability e The same module can be called at different locations thus avoiding to write the same lines of code more than once and lowering the probability of making mistakes e When the common model is subject to minor changes e g for a specific scenario simulation the necessary modifications can be restricted to one or a few modules leaving the rest of the model unaltered These modified modules from the common model then are overridden by an alternative formulation for these modules see Figure 2 and 3 4 1 TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN Figure 2 Scenario specific TREMOVE change by overriding limited number of modules TREMOVE Common Module A model Module C z Sa Scenario e i specific Ai Module D overriding module 3 3 1 Special case the demand module Calling a module is straightforward a special command i e the GAMS Sinclude or Sbatinclude command ensures that the code of a called module is inserted in another module at the location where the call is made The whole process takes place within one and the same program which ensures automatic exchange of data between the modules There is however one module that is called in a totally different manner As can be seen from Figure 3 this is the demand module which is used for calculating price effects on transport demand Actually th
40. tains one subfolder per scenario for scenario specific GAMS code see chapter 6 for more details e Report GAMS code for TREMOVE output post processing see section 5 for more details e Output location of the zipped intermediate files after running TREMOVE with the TREMOVE bat script 3 4 1 Override mechanism The model code is organised in several folders By default GAMS only looks into the project folder for code You can tell GAMS to look in other folders by using the idir call parameter For example suppose you execute the GAMS command in folder Mode1 Run_ by typing TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 13 gams run gms idir Input BE Input Vehicle Stock Module Welfare Module Then everytime GAMS encounters a include statement in the code e g Sinclude Main it will look for the file e g Main gms first in the working directory and then in each of the folders passed by idir The folders are searched in the passed order If a file with the same name exists in several locations the first one found will be used This is an important property It allows the implementation of the override mechanism described in Figure 2 if you want to override Main gms just put a modified version of the file in a new folder e g Model New Main and make sure it is searched before the folder Vehicle Stock Module the original lo
41. ting system We only tested TREMOVE on the following operating systems Windows XP Professional Windows XP Professional 64 bit edition We presume that TREMOVE will also work with Windows 2000 Professional Notes e TREMOVE has only been tested on these Operating Systems running in native mode Windows running in a virtual environment such as Parallel Desktops for Mac or VMware Workstation is not recommended e TREMOVE has only been tested on pc hardware Tremove should be able to run on Mac Hardware if it is running Windows in native mode But since this has not been tested it is not recommended We invite TREMOVE users to share experiences if they would test TREMOVE on other systems 1 2 2 Microsoft Office TREMOVE uses Microsoft Office The model is developed with Office XP and is expected to work also with Office 2003 The extensive output procedures of the model do not work with Office 2000 1 2 3 Additional software A WinZip TREMOVE uses WinZip and the Winzip Command Line Support Add On to compress the intermediate output of the model which is stored to limit the burden on the user s hard disk It is not a vital part of the model however without WinZip the model will not automatically store the intermediate results You can download and purchase WinZip and the Command Line Support Add On at http www winzip com Please be aware that WinZip is not free software but the purchase cost is limite
42. tremove bat Expert Tips Actually for the first country listed in tremove bat the batch procedure calls macro ImportIDs before macro StartImport is called The macro ImportIDs will clear the output_pure database and import the id numbers for the set elements Thereafter macro TRANSPORT amp MOBILITY LEUVEN Your link to integrated analyses TRANSPORT amp MOBILITY LEUVEN 25 StartImport 1s called for each listed country to import its output data in the database Alternatively one can start with an output_pure database that already contains output data for one or more countries and add other countries In that case one can run the new countries by using tremove bat and adapt the batch procedure such that the macro Import IDs is not executed Macro ImportIDs is called for the first listed country by the following line in the batch file Run And Import bat if exist firstpass txt msaccess exe SDBDIR output pure mdb X ImportIDs To avoid that macro ImportIDs is executed one can write rem before this line Note that Run And Import bat isa batch procedure that is executed for each country listed ify Cremove bat After every country listed in tremove bat has been imported another macro 1s called once UpdateTempTables This macro executes queries in the output_pure database to generate some extra tables in the database 5 4 Queries to generate output_processed database tables The output processed mdb links t
43. which are stored in the Module Demand Module folder e Demandroad gdx e Demandpublic gdx e Demandplane gdx e Demandis gdx In file Read Demand Module Output gms in folder T Model Vehicle Stock Module module these gdx files are read in by the vehicle stock modules These files contain transport volume information for all modes that results from the demand module and that is read as input by the other modules 3 4 TREMOVE folders The TREMOVE archive file that is downloaded has three main folders e Input DB contains the input database and scripts generate coded input files see chapter 4 for more details e Model bundles all GAMS code and execution scripts e Pivots output in pivot tables and output databases see chapter 5 for more details The Model folder is further divided into e Vehicle Stock Module GAMS code for vehicle stock modelling e Demand Module GAMS demand code is stored in subfolder Demand country specific demand datain Country Input and scenario specific code in Scenarios e Welfare Module GAMS code for welfare calculations e Run GAMS project directory containing execution batch scripts TREMOVE bat can be edited and executed to run a simulation see section 2 2 for details e Input GAMS include input files inc extension which are shared by all countries Country specific input files are stored in the country subfolders along with other country specific code e Scenarios con
Download Pdf Manuals
Related Search