000 14965cam a2203985Ii 4500
001 634696
008 160302s2011 mau a b 001 0 eng d
020 _a9780975914687 (hardback)
040 _aTR-IsMEF
_beng
_erda
_cTR-IsMEF
049 _aTR-IsMEF
050 0 0 _aHD30.213
_b.D48 2011
245 0 0 _aDeveloping spreadsheet-based decision support systems :
_busing Excel and VBA for Excel /
_cSandra D. Ekşioğlu, Industrial and Systems Engineerimng Bagley College of Engineering Mississippi State University, Michelle M.H. şeref, Virginia Polytechnic Institute and State University, Blacksburg, Ravindra K. Ahuja, Wayne L. Winston, Operations and Decision Technologies, Kelly School of Business Inddiana University, Bloomington ; cover design Saumya Ahuja.
250 _aSecond edition.
264 1 _aBelmont, Massachusetts :
_bDynamic Ideas,
_c2011.
264 4 _a©2011
300 _axx, 956 pages :
_billustrations ;
_c26 cm.
336 _atext
_2rdacontent
337 _aunmediated
_2rdamedia
338 _avolume
_2rdacarrier
500 _aIncludes bibliographical references (929-931) and index.
520 _aA decision support system (DSS) is an intelligent information system that uses data, models it, processes or analyzes it using problem-specific methodologies, and assists the user in the decision-making process through a graphical user interface (GUI). This is a comprehensive book that describes how to build decision support systems using the Excel spreadsheet framework and the VBA programming language. Risk Solver Platform for Education, an Excel Add-In, is used for optimization and simulation. This book illustrates complete decision support development applications through several case studies arising in operations research, industrial engineering, management, and business administration. https://www.amazon.com/Developing-Spreadsheet-Based-Decision-Supp ort-Systems/dp/0975914685
650 0 _aDecision support systems
650 0 _aMicrosoft Excel (Computer file)
650 0 _aVisual Basic for Applications (Computer program language)
700 1 _aEkşioğlu, Sandra D.,
_eauthor.
700 1 _aSeref, Michelle M. H.,
_eauthor.
700 1 _aAhuja, Ravindra K.,
_d1956-,
_eauthor.
700 1 _aWinston, Wayne L.,
_eauthor.
700 1 _aAhuja, Saumya,
_cover designer.
900 _aMEF Üniversitesi Kütüphane katalog kayıtları RDA standartlarına uygun olarak üretilmektedir / MEF University Library Catalogue Records are Produced Compatible by RDA Rules
910 _aÇağlayan
942 _2lcc
_cBKS
970 0 1 _aPreface,
_pxiii.
970 0 1 _aIntroduction,
_p1.
970 1 1 _tIntroduction to Decision Support Systems,
_p2.
970 1 1 _tDefining a Decision Support System,
_p3.
970 1 1 _tDecision Support Systems Applications,
_p5.
970 1 1 _tTextbook Overview,
_p6.
970 0 1 _aSummary,
_p8.
970 0 1 _aExercises,
_p9.
970 1 2 _tExcel basics and formatting,
_p11.
970 0 1 _aIntroduction,
_p12.
970 1 1 _tDefining the Set of Excel Objects,
_p12.
970 1 1 _tEntering Data into cells,
_p13.
970 1 1 _tUnderstanding the Ribbon and quick access toolbar,
_p15.
970 1 1 _tFormatting,
_p24.
970 0 1 _aSummary,
_p32.
970 0 1 _aExercises,
_p33.
970 1 2 _tReferencing and Names,
_p37.
970 0 1 _aIntroduction,
_p38.
970 1 1 _tReferencing Cells,
_p38.
970 1 1 _tNames for cells, references, and worksheets,
_p45.
970 0 1 _aSummary,
_p53.
970 0 1 _aExercises,
_p53.
970 1 2 _tFunctions and Formulas,
_p59.
970 0 1 _aIntroduction,
_p60.
970 1 1 _tFormulas and Function Categories,
_p60.
970 1 1 _tLogical and information functions,
_p65.
970 1 1 _tText and lookup&reference functions,
_p72.
970 1 1 _tDate&Time Functions,
_p83.
970 1 1 _tMathematics and Trigonometry Functions,
_p91.
970 1 1 _tStatistical and Financial Functions,
_p95.
970 1 1 _tConditional Formatting Formulas,
_p102.
970 1 1 _tAuditing,
_p105.
970 0 1 _aSummary,
_p107.
970 0 1 _aExercises,
_p107.
970 1 2 _tCharts&Sparklines,
_p113.
970 0 1 _aIntroduction,
_p114.
970 1 1 _tCreating Charts,
_p114.
970 1 1 _tWorking with chart tools,
_p117.
970 1 1 _tCreating Sparklines,
_p124.
970 1 1 _tCreating Dynamic Charts and Sparklines,
_p127.
970 0 1 _aSummary,
_p130.
970 0 1 _aExercises,
_p131.
970 1 2 _tPivot Tables,
_p135.
970 0 1 _aIntroduction,
_p136.
970 1 1 _tPivot Tables,
_p136.
970 1 1 _tFurther Modifications,
_p141.
970 1 1 _tPivot Charts,
_p155.
970 0 1 _aSummary,
_p157.
970 0 1 _aExercises,
_p158.
970 1 2 _tStatistical analysis with excel,
_p161.
970 0 1 _aIntroduction,
_p162.
970 1 1 _tUnderstanding data,
_p162.
970 1 1 _tRelationships in data,
_p176.
970 1 1 _tDistributions,
_p190.
970 0 1 _aSummary,
_p197.
970 0 1 _aExercises,
_p198.
970 1 2 _tSolving Mathematical Programs,
_p203.
970 0 1 _aIntroduction,
_p204.
970 1 1 _tFormulating Mayhematical programs,
_p204.
970 1 1 _tThe risk solver platform,
_p207.
970 1 1 _tApplications,
_p225.
970 0 1 _aSummary,
_p242.
970 0 1 _aExercises,
_p243.
970 1 2 _tSimulation,
_p247.
970 0 1 _aIntroduction,
_p248.
970 1 1 _tDefining simulation,
_p248.
970 1 1 _tWhat if analysis tools in excel,
_p249.
970 1 1 _tSimulation using the risk solver platform,
_p254.
970 0 1 _aApplications,
_p262.
970 0 1 _aSummary,
_p276.
970 0 1 _aExercises,
_p277.
970 1 2 _tWorking with large data,
_p283.
970 0 1 _aIntroduction,
_p284.
970 1 1 _tImporting data,
_p284.
970 1 1 _tCreating pivot tables from external data,
_p293.
970 1 1 _tUsing excel as a database,
_p296.
970 0 1 _aSummary,
_p318.
970 0 1 _aExercises,
_p318.
970 1 2 _tIntroduction to the visual basic environment,
_p323.
970 0 1 _aIntroduction,
_p324.
970 1 1 _tThe visual basic editor,
_p324.
970 1 1 _tThe object browser,
_p327.
970 0 1 _aSummary,
_p329.
970 0 1 _aExercises,
_p330.
970 1 2 _tRecording macros,
_p331.
970 0 1 _aIntroduction,
_p332.
970 1 1 _tMacros,
_p332.
970 1 1 _tCustomizing the ribbon and quick access toolbar ,
_p346.
970 0 1 _aSummary,
_p349.
970 0 1 _aExercises,
_p349.
970 1 2 _tMore an objects,
_p353.
970 0 1 _aIntroduction,
_p354.
970 1 1 _tMore on properties and methods,
_p354.
970 1 1 _tThe with construct,
_p382.
970 1 1 _tReferencing and names in VBA,
_p385.
970 1 1 _tFormulas in VBA,
_p394.
970 0 1 _aSummary,
_p400.
970 0 1 _aExercises,
_p400.
970 1 2 _tVariable,
_p405.
970 0 1 _aIntroduction,
_p406.
970 1 1 _tVariable declarations and data types,
_p406.
970 1 1 _tVariable scope,
_p410.
970 1 1 _tVariables in user interface,
_p411.
970 1 1 _tVBA math functions,
_p414.
970 0 1 _aApplications,
_p420.
970 0 1 _aSummary,
_p430.
970 0 1 _aExercises,
_p431.
970 1 2 _tSub Procedures and functions procedures,
_p437.
970 0 1 _aIntroduction,
_p438.
970 1 1 _tSub procedures,
_p438.
970 1 1 _tFunction procedures,
_p440.
970 1 1 _tPublic and private procedures,
_p443.
970 0 1 _aApplications,
_p444.
970 0 1 _aSummary,
_p447.
970 0 1 _aExercises,
_p448.
970 1 2 _tProgramming structures,
_p453.
970 0 1 _aIntroduction,
_p454.
970 1 1 _tIf, then statements,
_p454.
970 1 1 _tSelect, case,
_p459.
970 1 1 _tLoops,
_p460.
970 1 1 _tExit statements and end,
_p464.
970 0 1 _aApplications,
_p468.
970 0 1 _aSummary,
_p474.
970 0 1 _aExercises,
_p475.
970 1 2 _tArrays,
_p479.
970 0 1 _aIntroduction,
_p480.
970 1 1 _tWhen and Why to use arrays,
_p480.
970 1 1 _tDefining arrays,
_p480.
970 1 1 _tDynamic Arrays,
_p483.
970 1 1 _tSorting Arrays,
_p484.
970 0 1 _aApplications,
_p486.
970 0 1 _aSummary,
_p491.
970 0 1 _aExercises,
_p491.
970 1 2 _tUser Interface,
_p497.
970 0 1 _aIntroduction,
_p498.
970 1 1 _tUser Form Controls,
_p498.
970 1 1 _tUser form options,
_p515.
970 1 1 _tEvent procedures,
_p516.
970 1 1 _tVariable scope,
_p519.
970 1 1 _tError checking,
_p520.
970 1 1 _tImporting and exporting forms,
_p522.
970 1 1 _tNavigating,
_p522.
970 1 1 _tProfessional Appearance,
_p523.
970 0 1 _aApplications,
_p524.
970 0 1 _aSummary,
_p535.
970 0 1 _aExercises,
_p536.
970 1 2 _tMathematical programming revisited,
_p541.
970 0 1 _aIntroduction,
_p542.
970 1 1 _tReview of chapter 8,
_p542.
970 1 1 _tObject-oriented API in the risk solver platform,
_p546.
970 0 1 _aApplications,
_p552.
970 0 1 _aSummary,
_560.
970 0 1 _aExercises,
_p560.
970 1 2 _tSimulation revisited,
_p565.
970 0 1 _aIntroduction,
_p566.
970 1 1 _tReview of chapter 9,
_p566.
970 1 1 _tSimulation using object-oriented API in the risk solver platform,
_567.
970 0 1 _aApplications,
_574.
970 0 1 _aSummary,
_p581.
970 0 1 _aExercises,
_p582.
970 1 2 _tWorking with larga data using VBA,
_p587.
970 0 1 _aIntroduction,
_p588.
970 1 1 _tCreating pivot tables with VBA,
_p588.
970 1 1 _tUsing external data,
_p594.
970 1 1 _tExporting data,
_p608.
970 0 1 _aApplications,
_p609.
970 0 1 _aSummary,
_p616.
970 0 1 _aExercises,
_p616.
970 1 2 _tThe DSS development process,
_621.
970 1 1 _tDefining the DSS development process,
_p622.
970 1 1 _tApplication overview and model development,
_p622.
970 1 1 _tWorksheets,
_p624.
970 1 1 _tUser interface,
_p630.
970 1 1 _tProcedures,
_p636.
970 1 1 _tRe, solve options,
_p639.
970 1 1 _tTesting and final packaging,
_p643.
970 0 1 _aSummary,
_p643.
970 0 1 _aExercises,
_p644.
970 1 2 _tGUI design,
_p645.
970 1 1 _tGUI design,
_p646.
970 1 1 _tThe theory behind effective GUI Design,
_p646.
970 1 1 _tEffective and ineffective GUI design,
_p652.
970 0 1 _aSummary,
_p657.
970 0 1 _aExercises,
_p657.
970 1 2 _tProgramming principles,
_p659.
970 1 1 _tProgramming practices,
_p660.
970 1 1 _tClarity,
_p660.
970 1 1 _tEfficiency,
_p661.
970 0 1 _aSummary,
_p663.
970 0 1 _aExercises,
_p663.
970 1 2 _tBirthday Simulation,
_p665.
970 1 1 _tApplication overview and model development,
_p666.
970 1 1 _tWorksheets,
_p668.
970 1 1 _tUser Interface,
_p670.
970 1 1 _tProcedures,
_p671.
970 1 1 _tRe-solve options,
_p676.
970 0 1 _aSummary,
_p676.
970 0 1 _aExtensions,
_p677.
970 1 2 _tEight queens,
_p679.
970 1 1 _tApplication overview and model development,
_p680.
970 1 1 _tWorksheets,
_p682.
970 1 1 _tUser interface,
_p684.
970 1 1 _tProcedures,
_p685.
970 1 1 _tRe-solve options,
_p690.
970 0 1 _aSummary,
_p696.
970 0 1 _aExtensions,
_p696.
970 1 2 _tInventory management,
_p697.
970 1 1 _tApplication overview and model development,
_p698.
970 1 1 _tWorksheets,
_p699.
970 1 1 _tUser interface,
_p702.
970 1 1 _tProcedures,
_p705.
970 1 1 _tRe-solve options,
_p713.
970 0 1 _aSummary,
_p715.
970 0 1 _aExtensions,
_p715.
970 1 2 _tWarehouse layout,
_p717.
970 1 1 _tApplication overview and model development,
_p718.
970 1 1 _tWorksheets,
_p723.
970 1 1 _tUser interface,
_p725.
970 1 1 _tProcedures,
_p727.
970 1 1 _tRe-solve options,
_p738.
970 0 1 _aSummary,
_p745.
970 0 1 _aExtensions,
_p745
970 1 2 _tForecasting methods,
_p747.
970 1 1 _tApplication overview and model development,
_p748.
970 1 1 _tWorksheets,
_p750.
970 1 1 _tUser interface,
_p754.
970 1 1 _tProcedures,
_p756.
970 1 1 _tRe-solve options,
_p764.
970 0 1 _aSummary,
_p765.
970 0 1 _aExtensions,
_p766.
970 1 2 _tFacility Layout,
_p767.
970 1 1 _tApplication overview and model development,
_p768.
970 1 1 _tWorksheets,
_p769.
970 1 1 _tUser interface,
_p773.
970 1 1 _tProcedures,
_p775.
970 1 1 _tRe-solve options,
_p785.
970 0 1 _aSummary,
_p786.
970 0 1 _aExtensions,
_p786.
970 1 2 _tPortfolio management and optimization,
_p787.
970 1 1 _tApplication overview and model development,
_p788.
970 1 1 _tWorksheets,
_p790.
970 1 1 _tUser interface,
_p796.
970 1 1 _tProcedures,
_p798.
970 1 1 _tRe-solve options,
_p809.
970 0 1 _aSummary,
_p811.
970 0 1 _tExtensions,
_p811.
970 1 2 _tReliability analysis,
_p813.
970 1 1 _tApplication overview and model development,
_p814.
970 1 1 _tWorksheets,
_p817.
970 1 1 _tUser interface,
_p821.
970 1 1 _tProcedures,
_p823.
970 1 1 _tRe-solve options,
_p828.
970 0 1 _aSummary,
_p833.
970 0 1 _tExtensions,
_p833.
970 1 2 _tRetierement planning,
_p835.
970 1 1 _tApplication overview and model development,
_p836.
970 1 1 _tWorksheets,
_p840.
970 1 1 _tUser interface,
_p844.
970 1 1 _tProcedures,
_p846.
970 1 1 _tRe-solve options,
_p852.
970 0 1 _aSummary,
_p853.
970 0 1 _tExtensions,
_p853.
970 1 2 _tQueuing simulation: single server and multi server,
_p855.
970 1 1 _tSingle server queuing model simulation,
_p856.
970 1 1 _tWorksheets,
_p859.
970 1 1 _tUser interface,
_p862.
970 1 1 _tProcedures,
_p864.
970 1 1 _tRe-solve options,
_p870.
970 1 1 _tMulti server queuing model simulation and optimization,
_871.
970 1 1 _tAdditional worksheets,
_p873.
970 1 1 _tAdditional user interface,
_p874.
970 1 1 _tAdditional procedures,
_p876.
970 1 1 _tNew re-solve options,
_p880.
970 0 1 _aSummary,
_p880.
970 0 1 _aExtensions,
_p880.
970 1 2 _tExcel Add-ins,
_p883.
970 0 1 _aIntroduction,
_p884.
970 1 1 _tIncluding add-ins and references using VBA,
_p884.
970 1 1 _tData analysis toolpak,
_p888.
970 1 1 _tThe Solver,
_p890.
970 1 1 _tCplex,
_p900.
970 1 1 _t@Risk,
_p900.
970 1 1 _tCrystal Ball,
_p901.
970 1 1 _tStatTools,
_p901.
970 0 1 _aSummary,
_p901.
970 1 2 _tDebugging and error checking,
_p903.
970 0 1 _aIntroduction,
_p904.
970 1 1 _tTypes of errors,
_p904.
970 1 1 _tThe debug toolbar,
_p905.
970 1 1 _tThe debug windows,
_p907.
970 1 1 _tDebugging tips,
_p909.
970 1 1 _tError checking,
_p910.
970 0 1 _aSummary,
_p914.
970 1 2 _tAdvanced programming topics,
_p915.
970 0 1 _aIntroduction,
_p916.
970 1 1 _tObject-oriented programming in VBA for excel,
_p916.
970 1 1 _tOpening other applications from VBA,
_p923.
970 0 1 _aSummary,
_p928.
970 0 1 _aReferences,
_p929.
970 0 1 _aAbout the authors,
_p933.
970 0 1 _aIndex,
_p935.
999 _c12972
_d12972
003 KOHA