{"id":312780,"date":"2023-10-23T08:05:56","date_gmt":"2023-10-23T08:05:56","guid":{"rendered":"\/forum\/forums\/topic\/how-to-optimize-design-by-importing-excel-into-optislang\/"},"modified":"2023-10-23T08:05:56","modified_gmt":"2023-10-23T08:05:56","slug":"how-to-optimize-design-by-importing-excel-into-optislang","status":"closed","type":"topic","link":"https:\/\/innovationspace.ansys.com\/forum\/forums\/topic\/how-to-optimize-design-by-importing-excel-into-optislang\/","title":{"rendered":"How to optimize design by importing Excel into OptisLang."},"content":{"rendered":"
hello everyone.<\/div>\n
 <\/div>\n
 <\/div>\n
My current situation is as follows:<\/div>\n
 <\/div>\n
For example, there are three variables for the dimensions (mm) of the model.<\/div>\n
And I will use Optislang for optimized design.<\/div>\n
 <\/div>\n
And I will use the results from other analysis programs.<\/div>\n
(Not directly linked to “optislang”.)<\/strong><\/div>\n
 <\/div>\n
What I’m curious about is:<\/div>\n
  Does Optislang present the “number of cases” for the three variables?<\/strong><\/div>\n
(for example, 5mm, 6mm, 2mm \/ 5.1mm, 6mm 2mm \/ 5mm, 6.1mm, 2mm ……)<\/div>\n
(In the past, I used Minitab to derive the minimum number of cases using an orthogonal array table. In “Optis Lang”, the number of cases seems to be derived by some algorithm rather than an orthogonal array table.<\/div>\n
I just want to see the table with that “number of cases”, not the concatenated analysis.)<\/div>\n
 <\/div>\n
if it is possible,<\/div>\n
After substituting the “number of cases” into another analysis program and deriving the analysis value,<\/div>\n
 <\/div>\n
I will organize these results in Excel along with the number of cases.<\/div>\n
 <\/div>\n
I would like to connect this Excel data to “Optislang” to find the optimal design point.<\/div>\n
 <\/div>\n
If there is a tutorial for this please let me know.<\/div>\n
 <\/div>\n
(This is the same process I used to use “MiniTab” in the past.<\/div>\n
I would like to similarly reproduce this using Optislang.)<\/div>\n
 <\/div>\n
In other words, I want to do an optimized design by importing the values (number of cases + analysis result values) organized in Excel into “optislang”.<\/div>\n","protected":false},"template":"","class_list":["post-312780","topic","type-topic","status-closed","hentry"],"aioseo_notices":[],"acf":[],"custom_fields":[{"0":{"_bbp_subscription":["73450","15556"],"_bbp_author_ip":["96.7.218.223"]," _bbp_last_reply_id":["0"]," _bbp_likes_count":["0"],"_btv_view_count":["1712"],"_bbp_topic_status":["unanswered"],"_bbp_status":["publish"],"_bbp_topic_id":["312780"],"_bbp_forum_id":["275024"],"_bbp_engagement":["15556","73450"],"_bbp_voice_count":["2"],"_bbp_reply_count":["2"],"_bbp_last_reply_id":["313584"],"_bbp_last_active_id":["313584"],"_bbp_last_active_time":["2023-10-27 06:48:39"]},"test":"bcchul1dwdcc-co-kr"}],"_links":{"self":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/312780","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics"}],"about":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/topics\/312780\/revisions"}],"wp:attachment":[{"href":"https:\/\/innovationspace.ansys.com\/forum\/wp-json\/wp\/v2\/media?parent=312780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}