top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.
Optimization modeling with spreadsheets / / Kenneth R. Baker
Optimization modeling with spreadsheets / / Kenneth R. Baker
Autore Baker Kenneth R. <1943->
Edizione [Third edition.]
Pubbl/distr/stampa Hoboken, New Jersey : , : Wiley, , 2016
Descrizione fisica 1 online resource (391 pages) : illustrations, tables
Disciplina 005.54
Soggetto topico Mathematical optimization
Managerial economics - Mathematical models
Electronic spreadsheets
Programming (Mathematics)
ISBN 1-118-93770-8
1-118-93773-2
Classificazione 417
005.54
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910821140803321
Baker Kenneth R. <1943->  
Hoboken, New Jersey : , : Wiley, , 2016
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Optimization modeling with spreadsheets [[electronic resource] /] / Kenneth R. Baker
Optimization modeling with spreadsheets [[electronic resource] /] / Kenneth R. Baker
Autore Baker Kenneth R. <1943->
Edizione [2nd ed.]
Pubbl/distr/stampa Hoboken, N.J., : Wiley, 2011
Descrizione fisica 1 online resource (431 p.)
Disciplina 005.54
519.6028554
Soggetto topico Mathematical optimization
Managerial economics - Mathematical models
Electronic spreadsheets
Programming (Mathematics)
Soggetto genere / forma Electronic books.
ISBN 1-118-00897-9
1-280-76727-8
9786613678041
0-470-94910-4
0-470-94909-0
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto CONTENTS; Preface; 1. Introduction to Spreadsheet Models for Optimization; 1.1 Elements of a Model; 1.2 Spreadsheet Models; 1.3 A Hierarchy for Analysis; 1.4 Optimization Software; 1.5 Using Solver; Summary; Exercises; References; 2. Linear Programming: Allocation, Covering, and Blending Models; 2.1 Linear Models; 2.1.1 Linear Constraints; 2.1.2 Formulation; 2.1.3 Layout; 2.1.4 Results; 2.2 Allocation Models; 2.2.1 The Product Mix Problem; 2.3 Covering Models; 2.3.1 The Staff-Scheduling Problem; 2.4 Blending Models; 2.5 Modeling Errors in Linear Programming; 2.5.1 Exceptions; 2.5.2 Debugging
2.5.3 LogicSummary; Exercises; Case: JetGreen; 3. Linear Programming: Network Models; 3.1 The Transportation Model; 3.2 The Assignment Model; 3.3 The Transshipment Model; 3.4 Features of Special Network Models; 3.5 Building Network Models with Balance Equations; 3.6 General Network Models with Yields; 3.6.1 Models with Yield Losses; 3.6.2 Models with Yield Gains; 3.7 General Network Models with Transformed Flows; Summary; Exercises; Case: Casey's Famous Roast Beef; Case: Hollingsworth Paper Company; Production and Distribution Facilities; Patterns of Distribution; Expansion Proposals
4. Sensitivity Analysis in Linear Programs4.1 Parameter Analysis in the Transportation Example; 4.2 Parameter Analysis in the Allocation Example; 4.3 The Sensitivity Report and the Transportation Example; 4.4 The Sensitivity Report and the Allocation Example; 4.5 Degeneracy and Alternative Optima; 4.6 Patterns in Linear Programming Solutions; 4.6.1 The Transportation Model; 4.6.2 The Product Portfolio Model; 4.6.3 The Investment Model; 4.6.4 The Allocation Model; 4.6.5 The Refinery Model; Summary; Exercises; Case: Cox Cable and Wire Company; Background; The Contract; The Analysis
5. Linear Programming: Data Envelopment Analysis5.1 A Graphical Perspective on DEA; 5.2 An Algebraic Perspective on DEA; 5.3 A Spreadsheet Model for DEA; 5.4 Indexing; 5.5 Finding Reference Sets and HCUs; 5.6 Assumptions and Limitations of DEA; Summary; Exercises; Case: Branch Performance at Nashville National Bank; Branch Growth at Nashville National Bank; Assessing Branch Productivity; Branch Managers Revolt; Measuring Branches: Available Techniques; The DEA Study; 6. Integer Programming: Binary Choice Models; 6.1 Using Solver with Integer Requirements; 6.2 The Capital Budgeting Problem
6.3 Set Covering6.4 Set Packing; 6.5 Set Partitioning; 6.6 Playoff Scheduling; 6.7 Solving a Large-Scale Set Partitioning Problem; 6.8 The Algorithm for Solving Integer Programs; Summary; Exercises; Case: Motel Location for Nature's Inn; 7. Integer Programming: Logical Constraints; 7.1 Simple Logical Constraints: Exclusivity and Contingency; 7.2 Linking Constraints: The Fixed Cost Problem; 7.3 Linking Constraints: The Threshold Level Problem; 7.4 Linking Constraints: The Facility Location Model; 7.4.1 Capacitated Version; 7.4.2 Uncapacitated Version
7.5 Disjunctive Constraints: The Machine Sequencing Problem
Record Nr. UNINA-9910141010103321
Baker Kenneth R. <1943->  
Hoboken, N.J., : Wiley, 2011
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Optimization modeling with spreadsheets [[electronic resource] /] / Kenneth R. Baker
Optimization modeling with spreadsheets [[electronic resource] /] / Kenneth R. Baker
Autore Baker Kenneth R. <1943->
Edizione [2nd ed.]
Pubbl/distr/stampa Hoboken, N.J., : Wiley, 2011
Descrizione fisica 1 online resource (431 p.)
Disciplina 005.54
519.6028554
Soggetto topico Mathematical optimization
Managerial economics - Mathematical models
Electronic spreadsheets
Programming (Mathematics)
ISBN 1-118-00897-9
1-280-76727-8
9786613678041
0-470-94910-4
0-470-94909-0
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto CONTENTS; Preface; 1. Introduction to Spreadsheet Models for Optimization; 1.1 Elements of a Model; 1.2 Spreadsheet Models; 1.3 A Hierarchy for Analysis; 1.4 Optimization Software; 1.5 Using Solver; Summary; Exercises; References; 2. Linear Programming: Allocation, Covering, and Blending Models; 2.1 Linear Models; 2.1.1 Linear Constraints; 2.1.2 Formulation; 2.1.3 Layout; 2.1.4 Results; 2.2 Allocation Models; 2.2.1 The Product Mix Problem; 2.3 Covering Models; 2.3.1 The Staff-Scheduling Problem; 2.4 Blending Models; 2.5 Modeling Errors in Linear Programming; 2.5.1 Exceptions; 2.5.2 Debugging
2.5.3 LogicSummary; Exercises; Case: JetGreen; 3. Linear Programming: Network Models; 3.1 The Transportation Model; 3.2 The Assignment Model; 3.3 The Transshipment Model; 3.4 Features of Special Network Models; 3.5 Building Network Models with Balance Equations; 3.6 General Network Models with Yields; 3.6.1 Models with Yield Losses; 3.6.2 Models with Yield Gains; 3.7 General Network Models with Transformed Flows; Summary; Exercises; Case: Casey's Famous Roast Beef; Case: Hollingsworth Paper Company; Production and Distribution Facilities; Patterns of Distribution; Expansion Proposals
4. Sensitivity Analysis in Linear Programs4.1 Parameter Analysis in the Transportation Example; 4.2 Parameter Analysis in the Allocation Example; 4.3 The Sensitivity Report and the Transportation Example; 4.4 The Sensitivity Report and the Allocation Example; 4.5 Degeneracy and Alternative Optima; 4.6 Patterns in Linear Programming Solutions; 4.6.1 The Transportation Model; 4.6.2 The Product Portfolio Model; 4.6.3 The Investment Model; 4.6.4 The Allocation Model; 4.6.5 The Refinery Model; Summary; Exercises; Case: Cox Cable and Wire Company; Background; The Contract; The Analysis
5. Linear Programming: Data Envelopment Analysis5.1 A Graphical Perspective on DEA; 5.2 An Algebraic Perspective on DEA; 5.3 A Spreadsheet Model for DEA; 5.4 Indexing; 5.5 Finding Reference Sets and HCUs; 5.6 Assumptions and Limitations of DEA; Summary; Exercises; Case: Branch Performance at Nashville National Bank; Branch Growth at Nashville National Bank; Assessing Branch Productivity; Branch Managers Revolt; Measuring Branches: Available Techniques; The DEA Study; 6. Integer Programming: Binary Choice Models; 6.1 Using Solver with Integer Requirements; 6.2 The Capital Budgeting Problem
6.3 Set Covering6.4 Set Packing; 6.5 Set Partitioning; 6.6 Playoff Scheduling; 6.7 Solving a Large-Scale Set Partitioning Problem; 6.8 The Algorithm for Solving Integer Programs; Summary; Exercises; Case: Motel Location for Nature's Inn; 7. Integer Programming: Logical Constraints; 7.1 Simple Logical Constraints: Exclusivity and Contingency; 7.2 Linking Constraints: The Fixed Cost Problem; 7.3 Linking Constraints: The Threshold Level Problem; 7.4 Linking Constraints: The Facility Location Model; 7.4.1 Capacitated Version; 7.4.2 Uncapacitated Version
7.5 Disjunctive Constraints: The Machine Sequencing Problem
Record Nr. UNINA-9910830414303321
Baker Kenneth R. <1943->  
Hoboken, N.J., : Wiley, 2011
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel and Word [[electronic resource] /] / Dan Gookin
Power Excel and Word [[electronic resource] /] / Dan Gookin
Autore Gookin Dan
Pubbl/distr/stampa San Francisco [Calif.] ; ; London, : SYBEX, c2004
Descrizione fisica 1 online resource (366 p.)
Disciplina 005.52
Soggetto topico Electronic spreadsheets
Word processing
Soggetto genere / forma Electronic books.
ISBN 1-280-64987-9
9786610649877
0-470-11381-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Power Excel and Word; Contents at a Glance; Contents; About the Author; Introduction; About This Book; About You!; What Now?; Chapter 1: Life beyond the Basic Word; Saving and Opening Documents Can Be Torture if You Don't Know a Few Things; Can I Password-Protect My Document?; A Gaggle of Nifty Word Formatting and Editing Tricks; Printing Fun; Chapter 2: Alas, There Is No Such Thing as a "Simple" Document; Measuring Your Way around a Document; Stuff You Can Do Better When You're Writing a Simple Letter; Various Spacing Tricks for Making Your Document Longer or Shorter
Chapter 3: Making Your Documents and Reports More FancyHow Do You Know a Special Page When You See One?; The Woes of Numbering Pages; Chapter 4: Oh the Sacrilege of Drawing in a Word Processor!; Adding Pizzazz with a Text Box; Toss In an Image or Two; Simple Drawing Stuff; Chapter 5: Using Styles and Templates to Save Oodles of Time; Why Bother with Styles?; Some Style Tricks, Tidbits, and Advice; Holy Templates, WordMan!; Chapter 6: Writing That Great American Novel or Screenplay; What the Heck Is Outline Mode?; Organizing Your Work ( after Outlining); How Does Indexing Work?
Ideas for Various Creative ProjectsChapter 7: The Tough Stuff: From Labels to Tables; Getting the Most from Tabs; Stumbling over Tables; Lovely Labels; Dreaming of Fields; Chapter 8: Sharing Your Work with Others; Collaboration Tools; Revealing the Offenses of Others; Chapter 9: Making Your Own Custom Word; To Hell with the Interface!; Belly Up to the Toolbar; An Introduction to Macros; Peeling Personal Information from a Document; Chapter 10: Why the Hell Would Anyone Other than an Accountant Use Excel?; Some Information for Excel Newbies; Worksheet Tricks, Stunts, and Tomfoolery
I Don't Want My Data to Just Sit There! Any Way to Make Cells Do Things to Each Other?The Common "I Am Stupid" List of Excel Error Messages; Plopping an Excel Thing into a Word Thing; Chapter 11: It's Super Dooper Grid Time!; Why Bother with the Extra Worksheets?; Letting Excel Do the Work for You; Letting Excel Be a Database of Sorts; PivotTable Is Designed to Make Me Go Insane, Right?; Chapter 12: Some Excellent Formatting Tricks; The Narrow and Wide of Things; Beyond Simple Formatting; Printing Woes and Worries; Chapter 13: Oh No! The Horrible Math Chapter!; Basic, Annoying Math
The SUM of All ThingsIf Math Gives You a Headache, Wait Until You Start Adding and Subtracting Text; Chapter 14: Fun with Charts and Graphs; Basic Chart Tricks; Yes, Indeed, I'm Grossly Unhappy and Must Redo the Chart; Chapter 15: Excel Templates, Samples, and Web Mischief; The Document You Use Over and Over: The Template; Some Simple Sample Documents; Can I Grab Data from the Web and Use It in a Worksheet?; Index
Record Nr. UNINA-9910457743903321
Gookin Dan  
San Francisco [Calif.] ; ; London, : SYBEX, c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel and Word [[electronic resource] /] / Dan Gookin
Power Excel and Word [[electronic resource] /] / Dan Gookin
Autore Gookin Dan
Pubbl/distr/stampa San Francisco [Calif.] ; ; London, : SYBEX, c2004
Descrizione fisica 1 online resource (366 p.)
Disciplina 005.52
Soggetto topico Electronic spreadsheets
Word processing
ISBN 1-280-64987-9
9786610649877
0-470-11381-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Power Excel and Word; Contents at a Glance; Contents; About the Author; Introduction; About This Book; About You!; What Now?; Chapter 1: Life beyond the Basic Word; Saving and Opening Documents Can Be Torture if You Don't Know a Few Things; Can I Password-Protect My Document?; A Gaggle of Nifty Word Formatting and Editing Tricks; Printing Fun; Chapter 2: Alas, There Is No Such Thing as a "Simple" Document; Measuring Your Way around a Document; Stuff You Can Do Better When You're Writing a Simple Letter; Various Spacing Tricks for Making Your Document Longer or Shorter
Chapter 3: Making Your Documents and Reports More FancyHow Do You Know a Special Page When You See One?; The Woes of Numbering Pages; Chapter 4: Oh the Sacrilege of Drawing in a Word Processor!; Adding Pizzazz with a Text Box; Toss In an Image or Two; Simple Drawing Stuff; Chapter 5: Using Styles and Templates to Save Oodles of Time; Why Bother with Styles?; Some Style Tricks, Tidbits, and Advice; Holy Templates, WordMan!; Chapter 6: Writing That Great American Novel or Screenplay; What the Heck Is Outline Mode?; Organizing Your Work ( after Outlining); How Does Indexing Work?
Ideas for Various Creative ProjectsChapter 7: The Tough Stuff: From Labels to Tables; Getting the Most from Tabs; Stumbling over Tables; Lovely Labels; Dreaming of Fields; Chapter 8: Sharing Your Work with Others; Collaboration Tools; Revealing the Offenses of Others; Chapter 9: Making Your Own Custom Word; To Hell with the Interface!; Belly Up to the Toolbar; An Introduction to Macros; Peeling Personal Information from a Document; Chapter 10: Why the Hell Would Anyone Other than an Accountant Use Excel?; Some Information for Excel Newbies; Worksheet Tricks, Stunts, and Tomfoolery
I Don't Want My Data to Just Sit There! Any Way to Make Cells Do Things to Each Other?The Common "I Am Stupid" List of Excel Error Messages; Plopping an Excel Thing into a Word Thing; Chapter 11: It's Super Dooper Grid Time!; Why Bother with the Extra Worksheets?; Letting Excel Do the Work for You; Letting Excel Be a Database of Sorts; PivotTable Is Designed to Make Me Go Insane, Right?; Chapter 12: Some Excellent Formatting Tricks; The Narrow and Wide of Things; Beyond Simple Formatting; Printing Woes and Worries; Chapter 13: Oh No! The Horrible Math Chapter!; Basic, Annoying Math
The SUM of All ThingsIf Math Gives You a Headache, Wait Until You Start Adding and Subtracting Text; Chapter 14: Fun with Charts and Graphs; Basic Chart Tricks; Yes, Indeed, I'm Grossly Unhappy and Must Redo the Chart; Chapter 15: Excel Templates, Samples, and Web Mischief; The Document You Use Over and Over: The Template; Some Simple Sample Documents; Can I Grab Data from the Web and Use It in a Worksheet?; Index
Record Nr. UNINA-9910784481303321
Gookin Dan  
San Francisco [Calif.] ; ; London, : SYBEX, c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel and Word [[electronic resource] /] / Dan Gookin
Power Excel and Word [[electronic resource] /] / Dan Gookin
Autore Gookin Dan
Edizione [1st ed.]
Pubbl/distr/stampa San Francisco [Calif.] ; ; London, : SYBEX, c2004
Descrizione fisica 1 online resource (366 p.)
Disciplina 005.52
Soggetto topico Electronic spreadsheets
Word processing
ISBN 1-280-64987-9
9786610649877
0-470-11381-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Power Excel and Word; Contents at a Glance; Contents; About the Author; Introduction; About This Book; About You!; What Now?; Chapter 1: Life beyond the Basic Word; Saving and Opening Documents Can Be Torture if You Don't Know a Few Things; Can I Password-Protect My Document?; A Gaggle of Nifty Word Formatting and Editing Tricks; Printing Fun; Chapter 2: Alas, There Is No Such Thing as a "Simple" Document; Measuring Your Way around a Document; Stuff You Can Do Better When You're Writing a Simple Letter; Various Spacing Tricks for Making Your Document Longer or Shorter
Chapter 3: Making Your Documents and Reports More FancyHow Do You Know a Special Page When You See One?; The Woes of Numbering Pages; Chapter 4: Oh the Sacrilege of Drawing in a Word Processor!; Adding Pizzazz with a Text Box; Toss In an Image or Two; Simple Drawing Stuff; Chapter 5: Using Styles and Templates to Save Oodles of Time; Why Bother with Styles?; Some Style Tricks, Tidbits, and Advice; Holy Templates, WordMan!; Chapter 6: Writing That Great American Novel or Screenplay; What the Heck Is Outline Mode?; Organizing Your Work ( after Outlining); How Does Indexing Work?
Ideas for Various Creative ProjectsChapter 7: The Tough Stuff: From Labels to Tables; Getting the Most from Tabs; Stumbling over Tables; Lovely Labels; Dreaming of Fields; Chapter 8: Sharing Your Work with Others; Collaboration Tools; Revealing the Offenses of Others; Chapter 9: Making Your Own Custom Word; To Hell with the Interface!; Belly Up to the Toolbar; An Introduction to Macros; Peeling Personal Information from a Document; Chapter 10: Why the Hell Would Anyone Other than an Accountant Use Excel?; Some Information for Excel Newbies; Worksheet Tricks, Stunts, and Tomfoolery
I Don't Want My Data to Just Sit There! Any Way to Make Cells Do Things to Each Other?The Common "I Am Stupid" List of Excel Error Messages; Plopping an Excel Thing into a Word Thing; Chapter 11: It's Super Dooper Grid Time!; Why Bother with the Extra Worksheets?; Letting Excel Do the Work for You; Letting Excel Be a Database of Sorts; PivotTable Is Designed to Make Me Go Insane, Right?; Chapter 12: Some Excellent Formatting Tricks; The Narrow and Wide of Things; Beyond Simple Formatting; Printing Woes and Worries; Chapter 13: Oh No! The Horrible Math Chapter!; Basic, Annoying Math
The SUM of All ThingsIf Math Gives You a Headache, Wait Until You Start Adding and Subtracting Text; Chapter 14: Fun with Charts and Graphs; Basic Chart Tricks; Yes, Indeed, I'm Grossly Unhappy and Must Redo the Chart; Chapter 15: Excel Templates, Samples, and Web Mischief; The Document You Use Over and Over: The Template; Some Simple Sample Documents; Can I Grab Data from the Web and Use It in a Worksheet?; Index
Record Nr. UNINA-9910827600603321
Gookin Dan  
San Francisco [Calif.] ; ; London, : SYBEX, c2004
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Autore Jelen Bill
Pubbl/distr/stampa Merritt Island, Florida : , : Holy Macro! Books, , 2017
Descrizione fisica 1 online resource (578 pages) : illustrations
Disciplina 005.369
Soggetto topico Electronic spreadsheets
Business - Computer programs
ISBN 1-61547-232-0
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910164219003321
Jelen Bill  
Merritt Island, Florida : , : Holy Macro! Books, , 2017
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Autore Jelen Bill
Edizione [4th ed.]
Pubbl/distr/stampa Uniontown, OH : , : Holy Macro! Books, , [2015]
Descrizione fisica 1 online resource (561 pages)
Disciplina 005.54
Soggetto topico Electronic spreadsheets
Business - Computer programs
Soggetto genere / forma Electronic books.
ISBN 1-61547-125-1
1-61547-348-3
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910461094803321
Jelen Bill  
Uniontown, OH : , : Holy Macro! Books, , [2015]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Autore Jelen Bill
Edizione [4th ed.]
Pubbl/distr/stampa Uniontown, OH : , : Holy Macro! Books, , [2015]
Descrizione fisica 1 online resource (561 pages)
Disciplina 005.54
Soggetto topico Electronic spreadsheets
Business - Computer programs
ISBN 1-61547-125-1
1-61547-348-3
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910797408103321
Jelen Bill  
Uniontown, OH : , : Holy Macro! Books, , [2015]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Power Excel with MrExcel : 567 Excel mysteries solved / / Bill Jelen
Autore Jelen Bill
Edizione [4th ed.]
Pubbl/distr/stampa Uniontown, OH : , : Holy Macro! Books, , [2015]
Descrizione fisica 1 online resource (561 pages)
Disciplina 005.54
Soggetto topico Electronic spreadsheets
Business - Computer programs
ISBN 1-61547-125-1
1-61547-348-3
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Record Nr. UNINA-9910821432603321
Jelen Bill  
Uniontown, OH : , : Holy Macro! Books, , [2015]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui