Topics started by AlexK
Hello everyone, i want to read out Data from my project to excel. In Order to do so i created the following code: if not axll::WorkBookIsOpen(WorkbookFilename : "data//Auswertung_Szenario2.xlsx" ) then axll::OpenWorkBook(WorkbookFilename : "data//Auswertung_Szenario2.xlsx" );endif;axll::SelectSheet(SheetName : "Tabelle1" );axll::WriteTableQuick( IdentifierReference : LeadTimeOfOperation , TopLeftCell : "A5" , RowDimension : 1, WriteZeros : 0,); I dont get any error codes when i run the Procedure and the LeadTime Parameter is also not empty, but in my Excel Sheets i still cant see the Data. Does anyone know why that could be the case ? Kind regardsAlex
Hey everyone, I´m currently using Aimms to build a model for my Bachelor Thesis. I have never worked with Aimms before so I´m pretty clueless in some regard. So my problem is the following constraint: sum [i, aSP(h,i)*x(i,t)] + sum [j, sum [m, aFP(h,m)*(y(j,m,t))]] <= Capacity(h) Here x(i,t) and y(j,m,t) are the decision variables which represent the accepted requests for two Product types. i are the different types of Product x and j are different types for Product y. t stands for different Periods. aSP and aFP indicate if product x(i) or y(j) needs Ressource h for its production. I have declared Capacity(h) as a parameter with values for each h. My Problem is now that the Programm takes these values for each seperate period, but the capacity in period 2 is of course lower than the capacity in period 1 and so on. I also cant just declare Capacity parameters for each period, because the remaining capacity in the periods after period 1 depend on the sold products and therefore th
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.