{"id":"https://openalex.org/W3173597350","doi":"https://doi.org/10.3390/a14070191","title":"Optimization of the Weighted Multi-Facility Location Problem Using MS Excel","display_name":"Optimization of the Weighted Multi-Facility Location Problem Using MS Excel","publication_year":2021,"publication_date":"2021-06-25","ids":{"openalex":"https://openalex.org/W3173597350","doi":"https://doi.org/10.3390/a14070191","mag":"3173597350"},"language":"en","primary_location":{"id":"doi:10.3390/a14070191","is_oa":true,"landing_page_url":"https://doi.org/10.3390/a14070191","pdf_url":"https://www.mdpi.com/1999-4893/14/7/191/pdf?version=1624608347","source":{"id":"https://openalex.org/S190629608","display_name":"Algorithms","issn_l":"1999-4893","issn":["1999-4893"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Algorithms","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/1999-4893/14/7/191/pdf?version=1624608347","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090681477","display_name":"Petr N\u011bmec","orcid":"https://orcid.org/0000-0001-6867-5942"},"institutions":[{"id":"https://openalex.org/I96415178","display_name":"University of Defence","ror":"https://ror.org/04arkmn57","country_code":"CZ","type":"education","lineage":["https://openalex.org/I96415178"]}],"countries":["CZ"],"is_corresponding":true,"raw_author_name":"Petr N\u011bmec","raw_affiliation_strings":["Department of Logistics, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic"],"affiliations":[{"raw_affiliation_string":"Department of Logistics, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic","institution_ids":["https://openalex.org/I96415178"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055360490","display_name":"Petr Stodola","orcid":"https://orcid.org/0000-0002-2251-8711"},"institutions":[{"id":"https://openalex.org/I96415178","display_name":"University of Defence","ror":"https://ror.org/04arkmn57","country_code":"CZ","type":"education","lineage":["https://openalex.org/I96415178"]}],"countries":["CZ"],"is_corresponding":false,"raw_author_name":"Petr Stodola","raw_affiliation_strings":["Department of Intelligence Support, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic"],"affiliations":[{"raw_affiliation_string":"Department of Intelligence Support, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic","institution_ids":["https://openalex.org/I96415178"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5085321279","display_name":"Miroslav Pecina","orcid":null},"institutions":[{"id":"https://openalex.org/I96415178","display_name":"University of Defence","ror":"https://ror.org/04arkmn57","country_code":"CZ","type":"education","lineage":["https://openalex.org/I96415178"]}],"countries":["CZ"],"is_corresponding":false,"raw_author_name":"Miroslav Pecina","raw_affiliation_strings":["Department of Logistics, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic"],"affiliations":[{"raw_affiliation_string":"Department of Logistics, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic","institution_ids":["https://openalex.org/I96415178"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101465545","display_name":"Ji\u0159\u0131\u0301 Neubauer","orcid":"https://orcid.org/0000-0003-2497-2739"},"institutions":[{"id":"https://openalex.org/I96415178","display_name":"University of Defence","ror":"https://ror.org/04arkmn57","country_code":"CZ","type":"education","lineage":["https://openalex.org/I96415178"]}],"countries":["CZ"],"is_corresponding":false,"raw_author_name":"Ji\u0159\u00ed Neubauer","raw_affiliation_strings":["Department of Quantitative Methods, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic"],"affiliations":[{"raw_affiliation_string":"Department of Quantitative Methods, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic","institution_ids":["https://openalex.org/I96415178"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101445701","display_name":"Martin Bl\u00e1ha","orcid":"https://orcid.org/0000-0002-2964-1229"},"institutions":[{"id":"https://openalex.org/I96415178","display_name":"University of Defence","ror":"https://ror.org/04arkmn57","country_code":"CZ","type":"education","lineage":["https://openalex.org/I96415178"]}],"countries":["CZ"],"is_corresponding":false,"raw_author_name":"Martin Blaha","raw_affiliation_strings":["Department of Fire Support, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic"],"affiliations":[{"raw_affiliation_string":"Department of Fire Support, University of Defence, Kounicova 65, 662 10 Brno, Czech Republic","institution_ids":["https://openalex.org/I96415178"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5090681477"],"corresponding_institution_ids":["https://openalex.org/I96415178"],"apc_list":{"value":1400,"currency":"CHF","value_usd":1515},"apc_paid":{"value":1400,"currency":"CHF","value_usd":1515},"fwci":0.4141,"has_fulltext":false,"cited_by_count":7,"citation_normalized_percentile":{"value":0.6987986,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"14","issue":"7","first_page":"191","last_page":"191"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11502","display_name":"Facility Location and Emergency Management","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1407","display_name":"Organizational Behavior and Human Resource Management"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11502","display_name":"Facility Location and Emergency Management","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1407","display_name":"Organizational Behavior and Human Resource Management"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10567","display_name":"Vehicle Routing Optimization Methods","score":0.9955999851226807,"subfield":{"id":"https://openalex.org/subfields/2209","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12709","display_name":"Optimization and Mathematical Programming","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/2207","display_name":"Control and Systems Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.7960095405578613},{"id":"https://openalex.org/keywords/simulated-annealing","display_name":"Simulated annealing","score":0.7595480680465698},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7540479302406311},{"id":"https://openalex.org/keywords/metaheuristic","display_name":"Metaheuristic","score":0.7176546454429626},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.5604199171066284},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.5561008453369141},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.4954339265823364},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.48284775018692017},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4266964793205261},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13908281922340393}],"concepts":[{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.7960095405578613},{"id":"https://openalex.org/C126980161","wikidata":"https://www.wikidata.org/wiki/Q863783","display_name":"Simulated annealing","level":2,"score":0.7595480680465698},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7540479302406311},{"id":"https://openalex.org/C109718341","wikidata":"https://www.wikidata.org/wiki/Q1385229","display_name":"Metaheuristic","level":2,"score":0.7176546454429626},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5604199171066284},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.5561008453369141},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.4954339265823364},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.48284775018692017},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4266964793205261},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13908281922340393},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.3390/a14070191","is_oa":true,"landing_page_url":"https://doi.org/10.3390/a14070191","pdf_url":"https://www.mdpi.com/1999-4893/14/7/191/pdf?version=1624608347","source":{"id":"https://openalex.org/S190629608","display_name":"Algorithms","issn_l":"1999-4893","issn":["1999-4893"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Algorithms","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:6b5649a8bc2e404fa87052385cdf2ba7","is_oa":true,"landing_page_url":"https://doaj.org/article/6b5649a8bc2e404fa87052385cdf2ba7","pdf_url":null,"source":{"id":"https://openalex.org/S112646816","display_name":"SHILAP Revista de lepidopterolog\u00eda","issn_l":"0300-5267","issn":["0300-5267","2340-4078"],"is_oa":true,"is_in_doaj":true,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Algorithms, Vol 14, Iss 7, p 191 (2021)","raw_type":"article"},{"id":"pmh:oai:mdpi.com:/1999-4893/14/7/191/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/a14070191","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Algorithms; Volume 14; Issue 7; Pages: 191","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/a14070191","is_oa":true,"landing_page_url":"https://doi.org/10.3390/a14070191","pdf_url":"https://www.mdpi.com/1999-4893/14/7/191/pdf?version=1624608347","source":{"id":"https://openalex.org/S190629608","display_name":"Algorithms","issn_l":"1999-4893","issn":["1999-4893"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Algorithms","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.4699999988079071,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3173597350.pdf","grobid_xml":"https://content.openalex.org/works/W3173597350.grobid-xml"},"referenced_works_count":21,"referenced_works":["https://openalex.org/W167806033","https://openalex.org/W1971536112","https://openalex.org/W1979004882","https://openalex.org/W2007140719","https://openalex.org/W2047270429","https://openalex.org/W2055545070","https://openalex.org/W2061132775","https://openalex.org/W2083777010","https://openalex.org/W2532287826","https://openalex.org/W2534849953","https://openalex.org/W2662297521","https://openalex.org/W2792801182","https://openalex.org/W3026862992","https://openalex.org/W3048718587","https://openalex.org/W3091567946","https://openalex.org/W3092038292","https://openalex.org/W3108874515","https://openalex.org/W3140403984","https://openalex.org/W3151879729","https://openalex.org/W4237773586","https://openalex.org/W6664345689"],"related_works":["https://openalex.org/W2378211422","https://openalex.org/W2745001401","https://openalex.org/W4321353415","https://openalex.org/W2130974462","https://openalex.org/W2789681586","https://openalex.org/W2794361564","https://openalex.org/W1939200287","https://openalex.org/W2082305040","https://openalex.org/W4381955380","https://openalex.org/W150166259"],"abstract_inverted_index":{"This":[0],"article":[1],"presents":[2],"the":[3,7,25,30,72,76,90],"possibilities":[4],"in":[5,131,146],"solving":[6,108],"Weighted":[8],"Multi-Facility":[9,115],"Location":[10,116],"Problem":[11,117],"and":[12,46,48,86,93,121,148],"its":[13],"related":[14],"optimization":[15,53,112,129],"tasks":[16,113],"using":[17,150],"a":[18,33,61],"widely":[19,101],"available":[20,102],"office":[21,103],"software\u2014MS":[22],"Excel":[23,81],"with":[24,38,57,118,134],"Solver":[26,82],"add-in.":[27],"To":[28],"verify":[29],"proposed":[31],"technique,":[32],"set":[34],"of":[35,44,71,126],"benchmark":[36],"instances":[37],"various":[39],"point":[40],"topologies":[41],"(regular,":[42],"combination":[43],"regular":[45],"random,":[47],"random)":[49],"was":[50],"designed.":[51],"The":[52,69,96,141],"results":[54,58],"are":[55],"compared":[56],"achieved":[59,78],"by":[60,79],"metaheuristic":[62],"algorithm":[63],"based":[64],"on":[65,75],"simulated":[66],"annealing":[67],"principles.":[68],"influence":[70],"hardware":[73],"configuration":[74],"performance":[77],"MS":[80],"is":[83,105,144],"also":[84],"examined":[85],"discussed":[87],"from":[88],"both":[89],"execution":[91],"time":[92],"accuracy":[94],"perspectives.":[95],"experiments":[97],"showed":[98],"that":[99],"this":[100],"software":[104],"practical":[106],"for":[107,137],"even":[109],"relatively":[110],"complex":[111],"(Weighted":[114],"100":[119],"points":[120],"20":[122],"centers,":[123],"which":[124],"consists":[125],"40":[127],"continuous":[128],"variables":[130],"two-dimensional":[132],"space)":[133],"sufficient":[135],"quality":[136],"many":[138],"real-world":[139],"applications.":[140],"method":[142],"used":[143],"described":[145],"detail":[147],"step-by-step":[149],"an":[151],"example.":[152]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":3},{"year":2023,"cited_by_count":2}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}