Optimization Modeling with Spreadsheets, 2/e (Hardcover)

Kenneth R. Baker

  • 出版商: TP
  • 出版日期: 2011-05-24
  • 定價: $1,350
  • 售價: 8.0$1,080
  • 語言: 英文
  • 頁數: 432
  • 裝訂: Hardcover
  • ISBN: 0470928638
  • ISBN-13: 9780470928639
  • 相關分類: Excel
  • 立即出貨(限量) (庫存=1)

買這商品的人也買了...

商品描述

This introductory book on optimization (mathematical programming) includes coverage on linear programming, nonlinear programming, integer programming and heuristic programming; as well as an emphasis on model building using Excel and Solver. The emphasis on model building (rather than algorithms) is one of the features that makes this book distinctive. Most books devote more space to algorithmic details than to formulation principles. These days, however, it is not necessary to know a great deal about algorithms in order to apply optimization tools, especially when relying on the spreadsheet as a solution platform. The emphasis on spreadsheets is another feature that makes this book distinctive. Few books devoted to optimization pay much attention to spreadsheet implementation of optimization principles, and most books that emphasize model building ignore spreadsheets entirely. Thus, someone looking for a spreadsheet-based treatment would otherwise need to use a book that was designed for some other purpose, like a survey of management science topics, rather than one devoted to optimization. The model building emphasis derives from an attempt to be realistic about what readers need most when learning about optimization. At an introductory level, the most practical and motivating theme is the wide applicability of optimization tools. To apply optimization effectively, readers needs more than a brief exposure to a series of numerical examples, which is the way that most mathematical programming books treat applications. With a systematic modeling emphasis, readers can begin to see the basic structures that appear in optimization models and as a result, develop an appreciation for potential applications well beyond the examples in the book. Formulating optimization models is both an art and a science, and this book pays attention to both. The art can be refined with practice, especially supervised practice, just the way a student would learn sculpture or painting. The science is reflected in the structure that organizes the topics in this book. For example, there are several distinct problem types that lend themselves to linear programming formulations, and it makes sense to study these types systematically. In that spirit, the book builds a library of templates against which new problems can be compared. Analogous structures are developed for the presentation of other topics as well. 

商品描述(中文翻譯)

這本介紹性的優化(數學規劃)書籍包含線性規劃、非線性規劃、整數規劃和啟發式規劃的內容;同時強調使用Excel和Solver進行模型建立。強調模型建立(而非演算法)是這本書的特點之一。大多數書籍將更多的篇幅用於演算法細節,而非制定原則。然而,現在不需要對演算法有很多了解就能應用優化工具,尤其是當依賴試算表作為解決平台時。強調試算表是這本書的另一個特點。很少有專門研究優化的書籍對試算表實施優化原則給予太多關注,而大多數強調模型建立的書籍則完全忽略了試算表。因此,尋找基於試算表的教材的讀者,否則需要使用為其他目的設計的書籍,例如管理科學主題的調查,而不是專門研究優化的書籍。模型建立的強調是基於對讀者在學習優化時最需要的實際需求的試圖。在入門級別上,最實用和激勵人的主題是優化工具的廣泛應用性。為了有效應用優化,讀者需要更多的不僅僅是對一系列數值例子的簡要介紹,這是大多數數學規劃書籍對待應用的方式。通過系統建模的強調,讀者可以開始看到出現在優化模型中的基本結構,並因此對書中的例子之外的潛在應用有所體會。制定優化模型既是一門藝術,也是一門科學,這本書兼顧了兩者。藝術可以通過練習來提高,尤其是有監督的練習,就像學生學習雕塑或繪畫一樣。科學反映在組織本書主題的結構中。例如,有幾種不同的問題類型適合線性規劃制定,系統地研究這些類型是有意義的。本書建立了一個模板庫,可以將新問題與之進行比較。類似的結構也用於其他主題的呈現。