Solve Implicit Equations Inside Your Excel Worksheet (Paperback)

M.A. Kumar

ISBN 10: 1452816190 / ISBN 13: 9781452816197

Published by Createspace Independent Publishing Platform, 2010

About this Item

Paperback. This book explains the fundamentals of CONTROLLED FIXED-POINT ITERATIONS and how to solve Colebrook and other implicit equations in Microsoft Excel Worksheet, in a fully controlled fashion. The method presented gives a 15 didgit accurate solution in a fraction of seconds. Now no tedious Moody chart evaluatons . Thousands of instances of Colebrook can be solved in single worksheet now with this method. No VBA/MACRO/SOLVER/USER DEFINED FUNCTIONS. A simple worksheet concept! All this techniques need manual interventions. The method discussed in this book is by equations and so it is all automatic once triggered. The fixed point iteration discussed is well controlled and have freedom to input a seed value, number of iterations etc. and to check the accuracy digits. No differentiations, No need of any theorems like Newton Raphson 15 digit stabilization by iteration: Within fraction of second, we can achieve a 15 digit stabilization, which means ultimate numerical capability of computers utilized by this method. Thousands of such solving loops in single workshet: There is no limits on how many such equations can be independently solved. Your system memory decides the upper limit of thousands of equations that you can handle in a single sheet No manual intervention needed after equations and algorithms set up Simple, no-complication algorithms No 'Devide by zero' error For those who wont believe macros and VBAs - A clean worksheet concept! A new version of this book is available: Solving Colebrook Equation for Pipe Design, Sizing and Optimisation Calculations: Solve Within Excel Worksheet - No VBA, MACRO, UDF of SOLVER This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Seller Inventory # 9781452816197

Bibliographic Details

• Title: Solve Implicit Equations Inside Your Excel Worksheet (Paperback)
• Publisher: Createspace Independent Publishing Platform
• Publication Date: 2010
• Language: English
• ISBN 10: 1452816190
• ISBN 13: 9781452816197
• Binding: Paperback
• Edition: 2nd Edition
• Condition: new

About this title

Synopsis

This book explains the fundamentals of CONTROLLED FIXED-POINT ITERATIONS and how to solve Colebrook and other implicit equations in Microsoft Excel Worksheet, in a fully controlled fashion. The method presented gives a 15 didgit accurate solution in a fraction of seconds. Now no tedious Moody chart evaluatons . Thousands of instances of Colebrook can be solved in single worksheet now with this method. No VBA/MACRO/SOLVER/USER DEFINED FUNCTIONS. A simple worksheet concept! All this techniques need manual interventions. The method discussed in this book is by equations and so it is all automatic once triggered. The fixed point iteration discussed is well controlled and have freedom to input a seed value, number of iterations etc. and to check the accuracy digits. No differentiations , No need of any theorems like Newton Raphson 15 digit stabilization by iteration: Within fraction of second, we can achieve a 15 digit stabilization, which means ultimate numerical capability of computers utilized by this method. Thousands of such solving loops in single workshet: There is no limits on how many such equations can be independently solved. Your system memory decides the upper limit of thousands of equations that you can handle in a single sheet No manual intervention needed after equations and algorithms set up Simple, no-complication algorithms No 'Devide by zero' error For those who wont believe macros and VBAs - A clean worksheet concept! A new version of this book is available: Solving Colebrook Equation for Pipe Design, Sizing and Optimisation Calculations: Solve Within Excel Worksheet - No VBA, MACRO, UDF of SOLVER

From the Back Cover

1. No VBA/Macros/Solver/Goal Seek/User Defined Functions (UDFs). All this techniques need manual interventions.
2. The calculations is fully automatic and fully calculated within the worksheet.
3. The fixed point iteration discussed is well controlled and have freedom to input a seed value, number of iterations etc. and to check the accuracy digits. There is no limits on how many such equations can be independently solved. Your system memory decides the upper limit of thousands of equations that you can handle in a single sheet
4. No need of any theorems like Newton Raphson
5. 15 digit stabilization by iteration: Within fraction of second, we can achieve a 15 digit stabilization, which means ultimate numerical capability of computers utilized by this method.
6. Thousands of such equations solving in single workshet:
7. All equations trigger automatically or if needed manually.
8. No manual intervention needed after equations and algorithms set up
9. Simple, no-complication algorithms
10. No 'Divide by zero' error
11. For those who wont believe macros and VBAs - A clean worksheet concept!
12. Now say NO to Moody Diagram !