Search found 4 matches
- 2 years ago
- Forum: Syntax
- Topic: Reading time format from excel file
- Replies: 4
- Views: 4325
Re: Reading time format from excel file
Thanks for your recommendation I used that manner and reformed my set labels. however, I have a new problem "278 Lags are not allowed on maps". did not permissible using lags and leads in mapping subset? how should define mapping subset be?
- 2 years ago
- Forum: Syntax
- Topic: Reading time format from excel file
- Replies: 4
- Views: 4325
Re: Reading time format from excel file
I found a way to convert time format to text string format in excel have been defined a formula that can convert time to the text string. Regsignal.xlsx Select the cell which will place the text result, type this formula =TEXT(A1,"hh:mm:ss AM/PM"), press Enter key. And if you need, drag th...
- 2 years ago
- Forum: Syntax
- Topic: Reading time format from excel file
- Replies: 4
- Views: 4325
Reading time format from excel file
Hello, I have a question about reading set elements from the excel file. by default, GAMS read elements of a set as text while elements are about time intervals. Another problem about creat a subset. this subset include every hour of an operation day. I'm going to calculate Mileage Ratio RegD and Re...
- 3 years ago
- Forum: Syntax
- Topic: calculation kind of parameter over dynamic set
- Replies: 0
- Views: 1597
calculation kind of parameter over dynamic set
This program related to calculate life time of battery energy storage. The syntax of calculation this life time considered as two step problem which in the first step this problem solved without considering effect of charge and discharge on life time with objective of maximization of profit. when th...