How can I run GAMS in an excel interface?

More Hamit Erdal's questions See All

Are there any real-world machine learning application (or software) for demand forecasting that utilizing by an enterprice?

31 December 2015 1,503 1 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

After a reference from Int J Body Compos Res, can any body help?

Hi, I am after the reference below, my library says it cannot obtain a copy either locally or internationally, any help appreciated! Chris Wang ZM, Heshka S, Wielopolski L, Pi-Sunyer FX, Pierson...

03 March 2021 6,193 1 View

What techniques can I use to determine the miscibility of polymer blends?

The term miscibility refers to the single-phase state in thermodynamics. I do not mean the compatibility of different components. To determine the miscibility I know several techniques such as...

03 March 2021 4,107 4 View

How to repeat an operation on an atom selection for multiple times in PyMol?

Hi, I am trying to construct a multi-layer fibril structure from a single layer in PyMol by translating the layer along the fibril axis. For now, I am able to use the Translate command in PyMol...

02 March 2021 4,569 4 View

Shall I skip the measurement model in SmartPLS?

Hello everyone, I had run a mediation model in SmartPLS using questionnaires that were already validated among my statistical population. A professor who edited my paper -though she is not...

01 March 2021 3,052 3 View

What is involved in morphological changes of SEM images of a substance?

In the sem analysis of CaCO3 nanaoparticles, the morphology images showed spherical shaped particles but the proposed morphology for these type of nanoparticles is trigonal. I prepared the...

01 March 2021 1,960 4 View

Joint behaviour in Abaqus is not captured well?

I am working on roof joint and trying to simulate the behaviour in Abaqus. I am successful in running the model but the final graph does not follow the experimental curve in the negative direction...

01 March 2021 6,661 3 View

How to address this issue in the analysis of Real-Time PCR results?

To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...

01 March 2021 8,683 4 View

Can I download BibExcel for MacOs?

Hi everyone, I would like to ask how I can download BibExcel software for MacOs? There are some links which are supported by Windows but I could not find it for Mac. or is there any other software...

01 March 2021 652 1 View

How to define tie constraint between rigid body and another part in dynamic explicit model of Abaqus?

Hi dear researchers I connected a rigid body into the part of my structure by tie constraint and then I added displacement to rigid body, in static general step every thing is fine and these two...

28 February 2021 3,442 2 View

Arian Razmi Farooji

Hello,

Running GAMS in the background of Excel is totally possible. However, it is a challenging task which needs programming both in VBA (Visual Basic for Applications), the language behind Microsoft Office products like Excel and GAMS itself.

It is basically much more different from reading some data from or writing the data to an Excel file. General necessary steps are:

Co-locating your GAMS and system path directories.

Duplicating your model to a temporary directory.

Reading the data from Excel Spreadsheet and converting the format to .gdx.

Running the model and writing the solution as a .gdx file.

Writing back the outcome into the spreadsheet.

Hamit Erdal

Mr. Arian Razmi Farooji thank you for your answer. You really enlighten me. I wonder if you have any example size application

Yes, Sure. Attached is the link to McCarl GAMS User Guide where you can find an example related to transportation problem in which GAMS is being called from Excel and solves the problem in background.

http://www.gams.com/help/index.jsp?topic=%2Fgams.doc%2Fuserguides%2Fmccarl%2Fexcel_spreadsheet_in_charge.htm