Search found 4 matches

by Farhad9494
2 years ago
Forum: Syntax
Topic: Reading time format from excel file
Replies: 4
Views: 3918

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?
Untitled_4.gms
(2.5 KiB) Downloaded 171 times
EX_mileage.xlsx
(4.8 MiB) Downloaded 162 times
by Farhad9494
2 years ago
Forum: Syntax
Topic: Reading time format from excel file
Replies: 4
Views: 3918

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...
by Farhad9494
2 years ago
Forum: Syntax
Topic: Reading time format from excel file
Replies: 4
Views: 3918

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...
by Farhad9494
3 years ago
Forum: Syntax
Topic: calculation kind of parameter over dynamic set
Replies: 0
Views: 1520

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...