{"id":"https://openalex.org/W78236450","doi":null,"title":"Convexity Determination in the Microsoft Excel Solver Using Automatic Differentiation Techniques","display_name":"Convexity Determination in the Microsoft Excel Solver Using Automatic Differentiation Techniques","alternate_titles":[],"publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W78236450","mag":"78236450"},"language":"en","primary_location":{"id":"mag:78236450","doi":null,"is_oa":false,"landing_page_url":"http://www.autodiff.org/ad04/abstracts/Nenov.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W78236450"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5005797655","display_name":"Ivo P. Nenov","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Ivo P. Nenov","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5076361909","display_name":"Daniel H. Fylstra","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Daniel H. Fylstra","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5000281370","display_name":"Lubomir V. Kolev","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Lubomir V. Kolev","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.9601,"has_fulltext":false,"cited_by_count":18,"citation_normalized_percentile":{"value":0.67811935,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10963","display_name":"Advanced Optimization Algorithms Research","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2612","display_name":"Numerical Analysis"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10963","display_name":"Advanced Optimization Algorithms Research","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2612","display_name":"Numerical Analysis"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10545","display_name":"Optimization and Variational Analysis","score":9.999999747378752e-05,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"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/T13806","display_name":"Mathematical and Computational Methods","score":0.0,"subfield":{"id":"https://openalex.org/subfields/2611","display_name":"Modeling and Simulation"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/automatic-differentiation","display_name":"automatic differentiation","score":0.7319999933242798},{"id":"https://openalex.org/keywords/excel-solver","display_name":"Excel Solver","score":0.8880000114440918},{"id":"https://openalex.org/keywords/constraint-propagation","display_name":"constraint propagation","score":0.8059999942779541},{"id":"https://openalex.org/keywords/global-optimality","display_name":"global optimality","score":0.6150000095367432},{"id":"https://openalex.org/keywords/interior-point-methods","display_name":"interior point methods","score":0.8790000081062317},{"id":"https://openalex.org/keywords/spreadsheet-formulas","display_name":"spreadsheet formulas","score":0.6499999761581421},{"id":"https://openalex.org/keywords/model-diagnosis","display_name":"model diagnosis","score":0.6620000004768372},{"id":"https://openalex.org/keywords/quadratic-programming","display_name":"quadratic programming","score":0.5130000114440918},{"id":"https://openalex.org/keywords/linear-programming","display_name":"linear programming","score":0.6859999895095825},{"id":"https://openalex.org/keywords/sensitivity-analysis","display_name":"sensitivity analysis","score":0.35100001096725464}],"concepts":[{"id":"https://openalex.org/C203616005","wikidata":"https://www.wikidata.org/wiki/Q620495","display_name":"Hessian matrix","level":2,"score":0.7981927394866943},{"id":"https://openalex.org/C72134830","wikidata":"https://www.wikidata.org/wiki/Q5166524","display_name":"Convexity","level":2,"score":0.6952176094055176},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.6855003833770752},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.607154905796051},{"id":"https://openalex.org/C115527620","wikidata":"https://www.wikidata.org/wiki/Q769909","display_name":"Nonlinear programming","level":3,"score":0.583228588104248},{"id":"https://openalex.org/C157972887","wikidata":"https://www.wikidata.org/wiki/Q463359","display_name":"Convex optimization","level":3,"score":0.5412793159484863},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4717215895652771},{"id":"https://openalex.org/C81845259","wikidata":"https://www.wikidata.org/wiki/Q290117","display_name":"Quadratic programming","level":2,"score":0.43327462673187256},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4275173842906952},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3462142050266266},{"id":"https://openalex.org/C112680207","wikidata":"https://www.wikidata.org/wiki/Q714886","display_name":"Regular polygon","level":2,"score":0.3060142397880554},{"id":"https://openalex.org/C158622935","wikidata":"https://www.wikidata.org/wiki/Q660848","display_name":"Nonlinear system","level":2,"score":0.27520352602005005},{"id":"https://openalex.org/C28826006","wikidata":"https://www.wikidata.org/wiki/Q33521","display_name":"Applied mathematics","level":1,"score":0.24292927980422974},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C106159729","wikidata":"https://www.wikidata.org/wiki/Q2294553","display_name":"Financial economics","level":1,"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/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:78236450","doi":null,"is_oa":false,"landing_page_url":"http://www.autodiff.org/ad04/abstracts/Nenov.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W1532625281","https://openalex.org/W2038254351","https://openalex.org/W2296319761"],"related_works":["https://openalex.org/W2151460223","https://openalex.org/W2543624614","https://openalex.org/W201288012","https://openalex.org/W7098977146","https://openalex.org/W3120030401","https://openalex.org/W7095931706","https://openalex.org/W60528795","https://openalex.org/W568873006","https://openalex.org/W1984425167"],"abstract_inverted_index":{"We":[0,28,120],"present":[1],"algorithmic":[2],"tests":[3,382],"to":[4,32,42,110,163,187,224,285,325,438,453],"determine":[5,43,225],"whether":[6,44,54,226],"smooth":[7,218,248],"functions":[8,117,133,435,460],"are":[9,118,195,204,436,515],"convex":[10,60,205,231,478,504],"over":[11,114,232,376],"certain":[12,455],"regions,":[13],"in":[14,20,137,273,316,329,338,363,385,418,444,490,507,517],"an":[15,39,55,151,323,343],"algebraic":[16,301],"modeling":[17,302,318,361],"system":[18],"implemented":[19],"the":[21,33,66,79,83,112,116,138,207,210,233,240,291,317,330,333,339,348,367,386,427,430,445,491,497],"Premium":[22,340,387],"Solver":[23,341,350,388],"Platform":[24,389],"for":[25,59,98,150,216,261,309,390,426],"Microsoft":[26,139,334],"Excel.":[27],"apply":[29,179],"convexity":[30,123,311,327,381,412],"determination":[31,124,328],"objective,":[34],"constraints":[35,467],"and":[36,53,75,132,176,199,242,395,429],"bounds":[37,238],"of":[38,78,87,130,170,196,209,251,281,290,293,312,332,347,357,398,450,519],"optimization":[40,152,313,355],"problem,":[41],"a":[45,95,127,147,155,172,278,448,476,485],"locally":[46],"optimal":[47,174],"solution":[48,67],"will":[49],"be":[50,63,161,164,168,254,286,439],"globally":[51,173],"optimal,":[52],"interior":[56,184],"point":[57,185],"algorithm":[58],"problems":[61,194,203,250,271,283,314,356],"can":[62,160,167,178],"used":[64,457],"as":[65,402],"method.":[68],"The":[69,360,480],"algorithms":[70,125],"generally":[71],"rely":[72],"on":[73,126,239],"fast":[74],"accurate":[76],"computation":[77],"\u2018Hessian":[80],"sign\u2019":[81],"or":[82,159,410,413,502],"full":[84],"interval":[85,393],"Hessian":[86,208],"each":[88,227],"problem":[89,228,482],"function,":[90],"making":[91],"automatic":[92,396],"differentiation":[93,397],"techniques":[94,109,451],"practical":[96,282,420],"requirement":[97],"their":[99,101],"use;":[100],"effectiveness":[102],"is":[103,145,157,212,222,230,258,296,366,372,499],"improved":[104],"by":[105,135,237],"using":[106],"constraint":[107,244,459],"propagation":[108],"narrow":[111],"intervals":[113],"which":[115,371],"evaluated.":[119],"compare":[121],"different":[122],"test":[128],"set":[129],"models":[131],"defined":[134],"expressions":[136],"Excel":[140,335,349,368,399],"formula":[141,369],"language.":[142,319],"Introduction:":[143],"Convexity":[144],"clearly":[146],"desirable":[148],"property":[149],"model.":[153],"If":[154],"model":[156,391],"known":[158],"shown":[162,284],"convex,":[165,198,255,500],"we":[166,177,442],"confident":[169],"finding":[171],"solution,":[175],"(among":[180],"others)":[181],"high":[182],"performance":[183],"methods":[186],"find":[188],"that":[189,299,447,496],"solution.":[190],"Linear":[191],"programming":[192,201],"(LP)":[193],"course":[197],"quadratic":[200],"(QP)":[202],"if":[206],"objective":[211],"positive":[213],"semidefinite.":[214],"But":[215],"general":[217,513],"nonlinear":[219,249],"problems,":[220],"it":[221,295],"nontrivial":[223],"function":[229,486,498],"feasible":[234],"region":[235],"determined":[236],"variables":[241,472],"other":[243],"functions.":[245,379],"Yet":[246],"many":[247,269,419],"interest":[252],"may":[253,408],"more":[256],"than":[257],"commonly":[259,456],"realized;":[260],"example,":[262],"Stephen":[263],"Boyd":[264],"[1],":[265],"who":[266],"has":[267,276],"studied":[268],"such":[270],"arising":[272],"electrical":[274],"engineering,":[275],"described":[277,404],"wide":[279],"range":[280],"convex.":[287],"In":[288,432,509],"view":[289],"importance":[292],"convexity,":[294],"somewhat":[297],"surprising":[298],"existing":[300],"systems":[303],"do":[304],"not":[305],"provide":[306],"much":[307],"support":[308,384],"testing":[310],"written":[315],"This":[320],"paper":[321],"describes":[322],"effort":[324],"implement":[326],"framework":[331],"Solver,":[336],"specifically":[337],"Platform,":[342],"upward":[344],"compatible":[345],"extension":[346],"aimed":[351],"at":[352],"challenging":[353],"industrial":[354],"all":[358],"types.":[359],"language":[362],"this":[364,433],"case":[365],"language,":[370],"richly":[373],"expressive":[374],"with":[375,468],"300":[377],"built-in":[378],"Our":[380],"utilize":[383],"diagnosis,":[392],"evaluation":[394],"spreadsheet":[400],"formulas,":[401],"previously":[403],"[2,":[405],"3].":[406],"They":[407],"prove":[409,494],"disprove":[411],"yield":[414,423],"inconclusive":[415],"results,":[416],"but":[417],"cases":[421],"they":[422],"useful":[424],"information":[425],"modeler":[428],"solver.":[431],"paper,":[434],"assumed":[437],"smooth,":[440],"though":[441],"note":[443],"summary":[446],"variety":[449],"exist":[452],"convert":[454],"non-smooth":[458],"(e.g.":[461],"IF,":[462],"MIN,":[463],"MAX)":[464],"into":[465],"linear":[466],"additional":[469],"binary":[470],"integer":[471],"\u2013":[473],"potentially":[474],"yielding":[475],"mixed-integer":[477],"problem.":[479],"original":[481],"is:":[483],"given":[484],"(twice":[487],"continuously":[488],"differentiable":[489],"box":[492],"),":[493],"computationally":[495],"concave,":[501],"neither":[503],"nor":[505],"concave":[506],".":[508],"our":[510],"implementation":[511],"four":[512],"steps":[514],"used,":[516],"order":[518],"increasing":[520],"computational":[521],"cost:":[522],")":[523],"(":[524],",":[525],":":[526],"2":[527],"x":[528,529],"C":[530],"f":[531,534],"R":[532,533],"n":[535],"\u2208":[536,538],"\u2192":[537]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W78236450","counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-21T10:27:49.728292","created_date":"2016-06-24T00:00:00"}
