Arrivals based on database












0















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?










share|improve this question

























  • 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
















0















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?










share|improve this question

























  • 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














0












0








0








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?










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 '18 at 12:30







Samuel Chua

















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



















  • 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












1 Answer
1






active

oldest

votes


















0














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):



enter image description here



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:
enter image description here



You can find the example model that I used for the screens here, hope this helps.






share|improve this answer
























  • 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











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
});


}
});














draft saved

draft discarded


















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









0














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):



enter image description here



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:
enter image description here



You can find the example model that I used for the screens here, hope this helps.






share|improve this answer
























  • 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
















0














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):



enter image description here



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:
enter image description here



You can find the example model that I used for the screens here, hope this helps.






share|improve this answer
























  • 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














0












0








0







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):



enter image description here



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:
enter image description here



You can find the example model that I used for the screens here, hope this helps.






share|improve this answer













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):



enter image description here



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:
enter image description here



You can find the example model that I used for the screens here, hope this helps.







share|improve this answer












share|improve this answer



share|improve this answer










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



















  • 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




















draft saved

draft discarded




















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

'app-layout' is not a known element: how to share Component with different Modules

android studio warns about leanback feature tag usage required on manifest while using Unity exported app?

WPF add header to Image with URL pettitions [duplicate]