Mixing
Arrivals based on database
I am trying to retrieve arrival rates from a excel spreadsheet in my model but I don't have the option to select the specific row and column i want. How can I ensure that a specific cell is chosen? (For example i want the value 5 corresponding to "limeConveyor" row and "red" column.
This is the sample spreadsheet
This is the properties window
Thank you in advance for your help! :)
Edit 1:
I am currently unable to select "red" from the
dropdown list of value column. Is my program bugged or something?
anylogic
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
add a comment |
I am trying to retrieve arrival rates from a excel spreadsheet in my model but I don't have the option to select the specific row and column i want. How can I ensure that a specific cell is chosen? (For example i want the value 5 corresponding to "limeConveyor" row and "red" column.
This is the sample spreadsheet
This is the properties window
Thank you in advance for your help! :)
Edit 1:
I am currently unable to select "red" from the
dropdown list of value column. Is my program bugged or something?
anylogic
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08
add a comment |
I am trying to retrieve arrival rates from a excel spreadsheet in my model but I don't have the option to select the specific row and column i want. How can I ensure that a specific cell is chosen? (For example i want the value 5 corresponding to "limeConveyor" row and "red" column.
This is the sample spreadsheet
This is the properties window
Thank you in advance for your help! :)
Edit 1:
I am currently unable to select "red" from the
dropdown list of value column. Is my program bugged or something?
anylogic
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
I am trying to retrieve arrival rates from a excel spreadsheet in my model but I don't have the option to select the specific row and column i want. How can I ensure that a specific cell is chosen? (For example i want the value 5 corresponding to "limeConveyor" row and "red" column.
This is the sample spreadsheet
This is the properties window
Thank you in advance for your help! :)
Edit 1:
I am currently unable to select "red" from the
dropdown list of value column. Is my program bugged or something?
anylogic
anylogic
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
edited Nov 22 '18 at 12:30
Samuel Chua
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
asked Nov 22 '18 at 8:02
Samuel ChuaSamuel Chua
144
144
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08
add a comment |
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08
add a comment |
1 Answer
1
active
oldest
votes
Maybe to clarify Felipe's reply: I suspect your dbase table is not setup correctly and doesn't match your xls screenshot.
First, load your spreadsheet into an AnyLogic dbase table using the wizard. It should then look like this (note the column properties: the column type is important):
Now in your source, you can easily load the required column-row combination and the valuer-dropdown allows you to select "red" if you want:
You can find the example model that I used for the screens here, hope this helps.
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426308%2farrivals-based-on-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Maybe to clarify Felipe's reply: I suspect your dbase table is not setup correctly and doesn't match your xls screenshot.
First, load your spreadsheet into an AnyLogic dbase table using the wizard. It should then look like this (note the column properties: the column type is important):
Now in your source, you can easily load the required column-row combination and the valuer-dropdown allows you to select "red" if you want:
You can find the example model that I used for the screens here, hope this helps.
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
add a comment |
Maybe to clarify Felipe's reply: I suspect your dbase table is not setup correctly and doesn't match your xls screenshot.
First, load your spreadsheet into an AnyLogic dbase table using the wizard. It should then look like this (note the column properties: the column type is important):
Now in your source, you can easily load the required column-row combination and the valuer-dropdown allows you to select "red" if you want:
You can find the example model that I used for the screens here, hope this helps.
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
add a comment |
Maybe to clarify Felipe's reply: I suspect your dbase table is not setup correctly and doesn't match your xls screenshot.
First, load your spreadsheet into an AnyLogic dbase table using the wizard. It should then look like this (note the column properties: the column type is important):
Now in your source, you can easily load the required column-row combination and the valuer-dropdown allows you to select "red" if you want:
You can find the example model that I used for the screens here, hope this helps.
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
Maybe to clarify Felipe's reply: I suspect your dbase table is not setup correctly and doesn't match your xls screenshot.
First, load your spreadsheet into an AnyLogic dbase table using the wizard. It should then look like this (note the column properties: the column type is important):
Now in your source, you can easily load the required column-row combination and the valuer-dropdown allows you to select "red" if you want:
You can find the example model that I used for the screens here, hope this helps.
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
answered Nov 23 '18 at 6:26
BenjaminBenjamin
1,0551613
1,0551613
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
add a comment |
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
PS: don't worry about that weird "al_id" column: this is normally not visible and you don't need to take it into account
– Benjamin
Nov 23 '18 at 8:57
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
ok cool i managed to do it when i created a new model. Might be cause of something wrong about how I setup that previous model. Thank you! @Benjamin
– Samuel Chua
Nov 25 '18 at 7:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53426308%2farrivals-based-on-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
you are doing it.. but you forgot to put the value (which will be "red" in your case) and you are choosing blueConveyor, you can choose "limeConveyor"... You just have to add the value, and it should work fine.
– Felipe
Nov 22 '18 at 10:30
Hmm i am unable to see the options for that in the value column. Am i missing something here?
– Samuel Chua
Nov 22 '18 at 12:31
your database doesn't fit the values.. you are using the wrong database maybe
– Felipe
Nov 22 '18 at 13:08