{"id":"https://openalex.org/W2010238412","doi":"https://doi.org/10.1057/palgrave.jors.2601125","title":"Solving electronic spreadsheet models by interactive multicriterion optimization: a budgeting illustration","display_name":"Solving electronic spreadsheet models by interactive multicriterion optimization: a budgeting illustration","publication_year":2001,"publication_date":"2001-05-01","ids":{"openalex":"https://openalex.org/W2010238412","doi":"https://doi.org/10.1057/palgrave.jors.2601125","mag":"2010238412"},"language":"en","primary_location":{"id":"doi:10.1057/palgrave.jors.2601125","is_oa":false,"landing_page_url":"https://doi.org/10.1057/palgrave.jors.2601125","pdf_url":null,"source":{"id":"https://openalex.org/S169988927","display_name":"Journal of the Operational Research Society","issn_l":"0160-5682","issn":["0160-5682","1476-9360"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319703","host_organization_name":"Palgrave Macmillan","host_organization_lineage":["https://openalex.org/P4310319703","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Palgrave Macmillan","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the Operational Research Society","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086429424","display_name":"Marvin D. Troutt","orcid":null},"institutions":[{"id":"https://openalex.org/I149910238","display_name":"Kent State University","ror":"https://ror.org/049pfb863","country_code":"US","type":"education","lineage":["https://openalex.org/I149910238"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"M D Troutt","raw_affiliation_strings":["Kent State University USA"],"affiliations":[{"raw_affiliation_string":"Kent State University USA","institution_ids":["https://openalex.org/I149910238"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037146912","display_name":"Bee Yew","orcid":null},"institutions":[{"id":"https://openalex.org/I9508535","display_name":"Arkansas Tech University","ror":"https://ror.org/03bahkk91","country_code":"US","type":"education","lineage":["https://openalex.org/I9508535"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"B K Yew","raw_affiliation_strings":["Arkansas Tech University USA"],"affiliations":[{"raw_affiliation_string":"Arkansas Tech University USA","institution_ids":["https://openalex.org/I9508535"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5083301238","display_name":"A Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"A Zhang","raw_affiliation_strings":["Southern Illinois University USA","southern illinois university"],"affiliations":[{"raw_affiliation_string":"Southern Illinois University USA","institution_ids":[]},{"raw_affiliation_string":"southern illinois university","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5086429424"],"corresponding_institution_ids":["https://openalex.org/I149910238"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.25741466,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"52","issue":"5","first_page":"576","last_page":"583"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.995199978351593,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.995199978351593,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12709","display_name":"Optimization and Mathematical Programming","score":0.9401999711990356,"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/computer-science","display_name":"Computer science","score":0.7509212493896484},{"id":"https://openalex.org/keywords/connection","display_name":"Connection (principal bundle)","score":0.6211354732513428},{"id":"https://openalex.org/keywords/operations-research","display_name":"Operations research","score":0.5489944219589233},{"id":"https://openalex.org/keywords/project-management","display_name":"Project management","score":0.5381252765655518},{"id":"https://openalex.org/keywords/purchasing","display_name":"Purchasing","score":0.4922892153263092},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.41953274607658386},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.415335088968277},{"id":"https://openalex.org/keywords/management-science","display_name":"Management science","score":0.3210831880569458},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1414482295513153},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.11700397729873657},{"id":"https://openalex.org/keywords/systems-engineering","display_name":"Systems engineering","score":0.09111684560775757}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7509212493896484},{"id":"https://openalex.org/C13355873","wikidata":"https://www.wikidata.org/wiki/Q2920850","display_name":"Connection (principal bundle)","level":2,"score":0.6211354732513428},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.5489944219589233},{"id":"https://openalex.org/C15952604","wikidata":"https://www.wikidata.org/wiki/Q179012","display_name":"Project management","level":2,"score":0.5381252765655518},{"id":"https://openalex.org/C2778813691","wikidata":"https://www.wikidata.org/wiki/Q1369832","display_name":"Purchasing","level":2,"score":0.4922892153263092},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.41953274607658386},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.415335088968277},{"id":"https://openalex.org/C539667460","wikidata":"https://www.wikidata.org/wiki/Q2414942","display_name":"Management science","level":1,"score":0.3210831880569458},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1414482295513153},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.11700397729873657},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.09111684560775757},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1057/palgrave.jors.2601125","is_oa":false,"landing_page_url":"https://doi.org/10.1057/palgrave.jors.2601125","pdf_url":null,"source":{"id":"https://openalex.org/S169988927","display_name":"Journal of the Operational Research Society","issn_l":"0160-5682","issn":["0160-5682","1476-9360"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319703","host_organization_name":"Palgrave Macmillan","host_organization_lineage":["https://openalex.org/P4310319703","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Palgrave Macmillan","Springer Nature"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of the Operational Research Society","raw_type":"journal-article"},{"id":"pmh:oai:RePEc:pal:jorsoc:v:52:y:2001:i:5:d:10.1057_palgrave.jors.2601125","is_oa":false,"landing_page_url":"http://link.springer.com/10.1057/palgrave.jors.2601125","pdf_url":null,"source":{"id":"https://openalex.org/S4306401271","display_name":"RePEc: Research Papers in Economics","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I77793887","host_organization_name":"Federal Reserve Bank of St. Louis","host_organization_lineage":["https://openalex.org/I77793887"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","id":"https://metadata.un.org/sdg/16","score":0.5600000023841858}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W193578436","https://openalex.org/W1509479425","https://openalex.org/W1561610472","https://openalex.org/W1967551692","https://openalex.org/W1992942450","https://openalex.org/W2019228999","https://openalex.org/W2021919197","https://openalex.org/W2034316670","https://openalex.org/W2036737894","https://openalex.org/W2129318555"],"related_works":["https://openalex.org/W2351217280","https://openalex.org/W2086836292","https://openalex.org/W587735977","https://openalex.org/W2354083748","https://openalex.org/W2357949222","https://openalex.org/W2338005294","https://openalex.org/W2104192539","https://openalex.org/W2954733677","https://openalex.org/W2033865166","https://openalex.org/W2393625522"],"abstract_inverted_index":{"Abstract":[0],"In":[1],"previous":[2],"papers":[3],"a":[4,31,46],"connection":[5],"between":[6],"general":[7],"spreadsheet":[8,52],"models":[9],"and":[10,64,100,107],"interactive":[11,39],"multicriterion":[12,40],"optimization":[13,41],"has":[14],"been":[15],"discussed.":[16],"The":[17,34],"purpose":[18],"of":[19,27,49,77,90,105],"the":[20,28,58,85,91,103],"present":[21],"paper":[22],"is":[23,37,70,98],"to":[24,72,81],"provide":[25],"proof":[26],"concept":[29],"with":[30,51],"detailed":[32],"example.":[33],"main":[35],"idea":[36],"that":[38],"can":[42],"be":[43,82],"viewed":[44],"as":[45],"new":[47],"way":[48],"interacting":[50],"models.":[53],"It":[54],"offers":[55],"advantages":[56],"over":[57],"two":[59],"prevailing":[60],"ones,":[61],"namely":[62],"what-if":[63],"goal-seeking.":[65],"A":[66],"simplified":[67],"budgeting":[68],"example":[69],"given":[71],"clarify":[73],"this":[74],"connection.":[75],"Directions":[76],"improvement":[78,96],"are":[79],"assumed":[80],"provided":[83],"by":[84],"decision":[86],"maker":[87],"using":[88],"one":[89],"several":[92],"existing":[93],"methods.":[94],"One":[95],"iteration":[97],"illustrated":[99],"analyzed":[101],"following":[102],"method":[104],"Loganathan":[106],"Sherali.":[108]},"counts_by_year":[],"updated_date":"2026-02-09T09:26:11.010843","created_date":"2025-10-10T00:00:00"}