Change a code made by windows to Mac OS

GAMS
1

Hello everyone,
I have a problem with an GAMS-code which was created on a Microsoft system. The code needs an excel file with several sheets and I read about, that this is not easy to do it the same way on a Mac system. Is it possible to use a similar package on a MacBook or do I have to write a complete new code? If it is easy to adapt the code to Mac it would be the best solution for me otherwise I have to use another computer with a Windows system. The first attached link is the excel spreadsheet and the second one the word file with the code. You will also find it here: Economics of autonomous equipment for arable farms | Precision Agriculture there is the code published.
https://static-content.springer.com/esm/art%3A10.1007%2Fs11119-021-09822-x/MediaObjects/11119_2021_9822_MOESM2_ESM.xlsx
https://static-content.springer.com/esm/art%3A10.1007%2Fs11119-021-09822-x/MediaObjects/11119_2021_9822_MOESM1_ESM.docx

Thanks for your help

Jan

2

Hi,

The problematic lines are the ones starting with

$call GDXXRW ...

GDXXRW is a Windows only tool that reads data from Excel and writes it to GDX from where your code loads the data into GAMS. You could replace GDXXRW with GAMS Connect which is platform independent.

I hope this helps!

3

Hello and thanks for the reply,

I am trying to get it run and I am not sure if it is enough to replace the gdxxrw line s with the gams connect line or do I have to write the code complete new.
I am quite new in this programming and I am very grateful for any advices.

Thanks Jan

4

The GDXXRW line uses a file tasks.txt as input. This file is created on the fly your GAMS code ($onecho > tasks.txt). This file contains instructions what data should be read from the Excel by GDXXRW.

With Connect, such instructions need to be implemented in a YAML file.

I hope this helps!

1 Like
5

Hi Jan,

I have attached a version of the GAMS code where the first GDXXRW call is translated to Connect.

connect.gms (9.3 KB)

With Connect you do not need to write a GDX file and then import the symbols from it but you can directly write the symbols to GAMS (using the GAMSWriter). There is also another difference: GDXXRW has the maxDupeErrors option that allows for duplicate records - in Connect duplicate records are allowed in general. Only if you write to GDX or GAMS you have to take care of duplicate records and therefore, I specified duplicateRecords: first with the GAMSWriter.
Note that I have used abbreviated YAML syntax for dictionaries with the ExcelReader - I left the first symbol (t) in regular YAML syntax so that you can see the difference.

I hope this helps you getting started!

Aileen

1 Like