Duplicated entries

GAMS
1

Dear Sirs,
Thank you for your help in advance.
I add some rows and columns in the old files which could run well and get the wrong messages as below.
Douglas

samjuly20201019.xlsx (29.8 KB)
**** There were 6 duplicate entries for symbol sam
1: secrub,secrub
2: secrub,total
3: secrub,tartot
4: gov,secrub
5: total,secrub
6: tartot,secrub
Output gdx file deleted: C:\Users\DOUGLAS KUO\Documents\Dissertation\samjuly20201019.gdx
Total time = 3766 Ms
The option “MaxDupeErrors = ” can be used to allow for some duplicate records
HSRTWN2020.gms (2.29 KB)

2

As the error says, it is because of duplicate entries.

There are two columns titled secrub (column G and X)
There are also two rows titled secrub (7 and 24)

As a result, if you query let’s say (secrub, secrub), GAMS does not understand if it is column 7 and G, or column 24 and X.

I am not sure how you populate excel files, but removing duplicates or adding entries in a way that duplicates don’t appear is a good idea.

  • Atharv
3

Dear Atharv,
Thank you very much for your post. Problems solved. Really appreciate it.
Regards,
Douglas