ÿþ<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <html> <head> <title>SN's Goalseek Premium V1.08 - Analysis</title> <meta content="text/html; charset=unicode" http-equiv="Content-Type"> <meta name="GENERATOR" content="Microsoft FrontPage 5.0"> <meta name="description" content="SN's Goalseek Premium Add-in"> <meta name="description" content="Crude Oil Product Tanker Cargo Calculations, hydrostatic calculation, Calculation Add-in"> <meta name="description" content="Crude, Product Tanker, Cargo Calculations, oil calculation addins, work rest hours software, Best Place To Advertise, Where To Advertise, trim, stress, Goalseek"> <meta name="keywords" content="Crude, Product Tanker, Cargo Calculations, hydrostatic, shipping vehicles, solver, Where To Advertise, trim, stress"> <!-- Start Quantcast tag --> <script type="text/javascript" src="http://edge.quantserve.com/quant.js"></script> <script type="text/javascript">_qacct="p-c0ka3lonQZK5g";quantserve();</script> <!-- End Quantcast tag --><noscript></noscript> <meta name="verify-v1" content="wCx4cZ/s222Vkf0SdJXjHyfinOTuUVvehE0xoCGx0Ig="> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js"></script> <script type="text/javascript" src="http://worldbiglove.com/imagemag.js"> </script> <script type="text/javascript"> var _gaq = _gaq || []; _gaq.push(['_setAccount', 'UA-7609137-2']); _gaq.push(['_trackPageview']); (function() { var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); })(); </script> </head> <body bgcolor="#808080"> <script type="text/javascript" src="http://worldbiglove.com/wz_tooltip.js"></script> <p> <table cellspacing="0" cellpadding="0" width="780" align="center" border="0" bgcolor="#000000"> <tbody> <tr> <td bgcolor="#8080c0"> <h1 align="center"><a href="http://cargocal.com"> <img border="0" src="http://cargocal.com/images/cargocallogo.jpg" align="left" alt="Cargocal.com - Customised Solutions For The Tanker Industry" width="123" height="124"></a><font size="6" face="Microsoft Sans Serif" color="#F4F4F4"><b><a name="Top">SN's</a> Goalseek Premium V1.08</b></font></h1><font > <h2 align="center"> <font color="#800080" size=1><a href="http://link40.com/WattR.html"> <font color="#00FF00" face="Microsoft Sans Serif">The Grey Background is a Watt-Reduction Theme.&nbsp; Every milli-Watt counts.</font></a></font></h2> <p align="center"> <b><font color="#00cc66" size="2" face="Arial Narrow"><a onmouseover="Tip('Reduce, Reuse, Recycle <br> Rethink, Refuse, Restructure, Reorganise, Redesign, Repair, Retest <br> Reverse -> Sustain -> Tangible Improvement')" onmouseout=UnTip() href="http://link40.com/WattR.html"> <font color=#00FF00>Reduce....&gt;&gt;&nbsp; Reuse ...&gt;&gt;&nbsp;Recycle ...&gt;&gt;&nbsp;Rethink...&gt;&gt;&nbsp;Repair </font></a></font><font color="#00cc66" size="1" face="Arial"><a onmouseover="Tip('Reduce, Reuse, Recycle <br> Rethink, Refuse, Restructure, Reorganise, Redesign, Repair, Retest <br> Reverse -> Sustain -> Tangible Improvement')" onmouseout=UnTip() href="http://link40.com/WattR.html"> <font color=#00FF00>&nbsp;</font></a></font></b></font></td></tr> <tr> <td bgcolor="#f4f4f4"> <table cellspacing="0" cellpadding="0" width="100%" align="center" border="0" height="1012"> <tbody> <tr> <td width="150" valign="top" height="1012"> <p> <table cellspacing="1" cellpadding="3" width="149" align="center" border=0 bgColor=#8080c0 style="WIDTH: 149px; HEIGHT: 2113"> <tr> <td bgcolor="#004080" height="50" style="font-family: Arial, sans-serif; font-size: 12px"> <p align="center"> <b><a href="http://cargocal.com/index.html"> <font face="Tahoma" size="2" color="#f4f4f4">Home</font></a></b><b style="font-family: Arial, sans-serif; font-size: 12px"><font color="#f4f4f4" face="Tahoma" size="2"> </font></b> </p></td> </tr> <tr> <td width="150" align="center" valign="top" height="1034" style="font-family: Arial, sans-serif; font-size: 12px"> &nbsp;<p>&nbsp;</p> <p>&nbsp;<script type="text/javascript"><!-- google_ad_client = "pub-8491802827119857"; /* NewCCal125 */ google_ad_slot = "7767001574"; google_ad_width = 125; google_ad_height = 125; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></p> <p>&nbsp;</p> <p> <font color="#0066cc" size="2" face="Tahoma"><a href="http://bigloveindia.com"> <font color=#FFFF00>Where to Advertise?</font></a></font><font face="Tahoma" color="#FFFF00" size="2"> </font> </p> <p><a href="http://worldbiglove.com"> <font color="#FFFF00" size="2" face="Tahoma">World Tourist Attractions</font></a></p> <p><font face="Tahoma" size="2" color="#0066CC"> <a href="http://link40.com"><font color="#FFFF00">Best Place To Advertise</font></a></font></p> <p> <font face="Tahoma" size="2" color="#0066CC"> <a href="http://bigloveindia.com/"><font color="#FFFF00">INDIA</font></a></font></p> <p> <font face="Tahoma" size="2" color="#FFFF00"> <a href="http://link40.com/Blogs.html"><font color="#FFFF00">Blogs</font></a></font></p> <p><a href="http://bigloveasia.com"> <font face="Tahoma" size="2" color="#FFFF00">Buy BigLoveAsia</font></a></p> <p><font color="#0000ff" size="2" face="Tahoma"><a href="http://conceptsforum.com/"><font color="#FFFF00">ConceptsForum.com</font></a></font><font color="#FFFF00" size="2" face="Tahoma">&nbsp; </font></p> <p><font color="#0066cc" size="2" face="Microsoft Sans Serif"><a href="http://worldbiglove.com/up.html"> <font color="#FFFF00" face="Tahoma" size="2">Universal Prayer</font></a></font></p> <p> <font color=#0066cc size="2" face="Microsoft Sans Serif"> <a href="http://link40.com/Med_VasRev.html"><img border="0" alt="Link40.com - Connecting The Top 40, A Directory Service" src="http://link40.com/images/vasrev1.jpg" width=113 height=113></a></font><font face="Tahoma" color="#FFFF00" size="2"> </font> <p> &nbsp;<p> &nbsp;<p> &nbsp; <script type="text/javascript"><!-- google_ad_client = "pub-8491802827119857"; /* CargocalVertical1 */ google_ad_slot = "6568869800"; google_ad_width = 120; google_ad_height = 600; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></td> </tr> <tr> <td width="150" height="715"> <p>&nbsp;</p> </td></tr></table> </td> <td width="640" bgcolor="#f4f4f4" VALIGN =top V v height="1012"> <div align="center"> <center> <table cellspacing="6" cellpadding="0" width="657" border=0 style="border-collapse: collapse" bordercolor="#111111"> <tbody> <tr> <td align="left" style="float: left"> <div align="center"> <center> <table border="0" cellpadding="5" cellspacing="5" style="border-collapse: collapse" bordercolor="#111111" width="634" id="AutoNumber1" height="161"> <tr> <td width="293" height="112" valign="top" align="justify"> <font size="5" face="Microsoft Sans Serif"><b>Executive Overview</b></font><p> <font face="Microsoft Sans Serif"><b>An Analysis of an Algorithm Improvement for - Excel&#39;s GoalSeek Function</b></font></p> <p> <font color="#202020" face="Arial" size="2">This document analyzes the capabilities of the SNGSP program compared to Microsoft Excel&#39;s existing GoalSeek algorithm and its stand-in for enhanced goalseeking &#39;Solver&#39;. A compelling case is developed for leveraging SNGSP in future versions of Microsoft Excel.</font></p> <p> <b><font color="#808080" face="Arial">The Purpose of Excel's Goal Seek</font></b></p> </td> <td width="306" height="112" valign="top" align="center"> <p align="center"> <div id="MicrosoftTranslatorWidget" style="width: 200px; min-height: 83px; border-color: #3A5770; background-color: #78ADD0;"><noscript> <a href="http://www.microsofttranslator.com/bv.aspx?a=http%3a%2f%2fcargocal.com%2f">Translate this page</a><br />Powered by <a href="http://www.microsofttranslator.com">Microsoft® Translator</a></noscript></div> <script type="text/javascript"> /* <![CDATA[ */ setTimeout(function() { var s = document.createElement("script"); s.type = "text/javascript"; s.charset = "UTF-8"; s.src = ((location && location.href && location.href.indexOf('https') == 0) ? "https://ssl.microsofttranslator.com" : "http://www.microsofttranslator.com" ) + "/ajax/v2/widget.aspx?siteData=u3prHoobn02HlNRmJ654DbHHdnl_yPpfOUHQrwAD2flkF2rll-7F8Xtcw-MQwevwHfcqnoIKWlC79_D_A9wAC6VP0Mm-U4bzsaSREQTm9gXvKuc4LA-1eiB76uFrvUgI&mode=manual&from=en&layout=ts"; var p = document.getElementsByTagName('head')[0] || document.documentElement; p.insertBefore(s, p.firstChild); }, 0); /* ]]> */ </script> <p align="center"></p> <script type="text/javascript"><!-- google_ad_client = "pub-8491802827119857"; /* cargocaltop2 */ google_ad_slot = "8863659413"; google_ad_width = 200; google_ad_height = 200; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </p> </td> </tr> <tr> <td width="599" height="19" colspan="2" align="justify"> <p><font color="#202020" face="Arial" size="2">Goal Seek is part of a suite of commands in Excel that are used to conduct &#39;what-if&#39; analysis. This type of analysis consists of a process where the user changes values in a single selected cell to determine the impact of other formulas in a worksheet. This approach is particularly useful when the user knows the expected result of a formula, but does not know the initial input starting value to obtain that result. One example involves loans and interest rates in an amortization table, whereby the user can determine the amount of payments. The Excel Goal Seek algorithm can vary the result in only one specific cell, until a formula that depends on that's dependent on that cell returns the result desired by the user.</font></p> <p><font size="2"> <font color="#0066CC"> <a href="#Top"><font color="#0066CC">&lt;&lt; Top &gt;&gt;</font></a></font></font></p> <p><b><font color="#808080" face="Arial">Excel's GoalSeek limitations</font></b><font color="#202020" face="Arial" size="2"><br> <br> GoalSeek is capable of solving a target cell value by changing only one cell. It is also susceptible to the limitations of finite precision computer arithmetic.</font></p> <p><b><font color="#808080" face="Arial">Competitive products</font></b><font face="Arial" size="2" color="#202020"><br> <br> Lotus 123&#39;s BackSolver has a largely superior algorithm. It can solve for required target cell values by changing values in a range of contiguous cells. The drawbacks of their algorithm are that changing cells are either all incremented or all decremented irrespective of the natural relationship of the individual cells w.r.t. the target cell. Further, the changing cells should be contiguous and therefore, naturally on one sheet.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font> </p> <p><font color="#0066CC" size="2"> <a href="#Top"><font color="#0066CC">&lt;&lt; Top &gt;&gt;</font></a></font><font face="Arial" size="2" color="#202020"><br> <br> </font><b><font color="#808080" face="Arial">SNGSP Capability Improvements</font></b><font face="Arial" size="2" color="#202020"><br> <br> - SNGSP can work with multiple variable cells, in multiples of sheets in multiples of open workbooks. Up to 64000 cells in multiple ranges may be incorporated into the problem - but that figure can be increased or lowered to suit business strategy. Those cells, if selected, but do not relate to the target cell by formulae or functions, will be automatically ignored. Upper and lower bounds may be set individually for each range. Solver cannot work with multiple worksheets/workbooks.<br> <br> - SNGSP can work with protected workbooks, Solver cannot.<br> <br> - SNGSP can/will alter its internal precision differently for each variable cell in an effort to find a solution (in case the user has incorporated the Round, etc. functions in his/her workbook). <br> <br> - SNGSP does not get bogged down if the starting values are such that the &quot;set up&quot; sub-routine does not detect a change in target cell value. For example: See the image in <a href="http://cargocal.com/interface.html"><font color="#0066CC"> http://cargocal.com/interface.html</font></a> and look at the Measured Ull column. This column represents the ullage of the respective tank. (Ullage is a measure of the empty space above the liquid cargo in a tank - Total tank height less the height (sounding) of the cargo). The ullage for empty tank is usually an odd figure like 22.068 or 21.567, etc. The users of the program will not write this cumbersome figure to indicate empty tank, they will adopt a rule such as to enter 23 in tanks that are empty. With 23 in the measured ullage column, the volume, etc. will be zero. SNGSP will not be bogged down by this, as it will progressively increase its internal precision in an effort to detect and measure a change. Solver cannot work if start values do not change with changes as per its setup computing sub-routines.<br> <br> - SNGSP can use the value of a referenced cell for the set-cell value. As the value in the referenced cell changes with change of the variable cells, so will the problem target value change, until an equilibrium is reached. Solver cannot.&nbsp;&nbsp; </font> </p> <p><font color="#202020" face="Arial" size="2">-&nbsp; SNGSP uses extensive branching routines to overcome non-linear hitches and limitations of finite precision computer arithmetic. Solver has more limitations in this respect.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font> </p> <p><font color="#202020" face="Arial" size="2">- As computing progresses, should certain cells reach their threshold for upper or lower bounds or if they tend to cause the introduction of an error situation (#div0, #num, etc), those cells are blocked at their last acceptable value and computing continues with the remaining cells. Solver stops at the first encountered error.</font></p> <p><font color="#202020" face="Arial" size="2">- SNGSP is not an optimizing tool and so cannot compute for optimizing scenario where minimum, maximum and a set of constraints are set. Conversely, the optimizing tool, Solver as shipped free with Excel has a host of limitations and cannot backsolve/goalseek as effectively as SNGSP. <br> &nbsp;<br> - SNGSP may be called programmatically from the user&#39;s VBE but limited to 10 ranges. (This feature is under further development). </font> </p> <p><font color="#202020" face="Arial" size="2">Please check out this article on Excel GoalSeek and Solver limitations. SNGSP overcomes any of these with start values up to 120,000. <br> <a href="http://www.bus.ualberta.ca/ite/vol2no2/troxell/"> http://www.bus.ualberta.ca/ite/vol2no2/troxell/</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <br> <br> </font><b><font color="#808080" face="Arial">Current and potential future uses of Excel with SNGSP</font></b><font color="#202020" face="Arial" size="2"><br> <br> SNGSP&#39;s algorithms are called programmatically in cargo related spreadsheet based software written by its author for some tank vessels in various shipping companies.&nbsp; All Excel users are potential customers for the spreadsheet based solutions that has as one of it features, backsolving (premium goalseeking).<br> <br> All those who have changed over from Lotus-123 for various reasons but sorely miss the BackSolve feature but cannot do much about it will welcome this add-in.<br> <br> </font><b><font color="#808080" face="Arial">Conclusions</font></b><font color="#202020" face="Arial" size="2"><br> <br> SNGSP is a tool that should interest any user who knows the result he/she is looking for but does not know the values in the changing cells required to achieve this. The more complicated the project, including a tendency for the project to go into a &#39;circular&#39; computation, enhances to evidence of the need of such a tool.</font></p> <p align="center"><i><font face="Arial" size="2" color="#0066CC">SNGSP can be improved upon in collaboration with Redmond.</font></i></p> </td> </tr> </table> </center> </div> <font > <blockquote> <p><font size="2"> <font color="#0066CC">&nbsp; </font> &nbsp;&nbsp; <a href="http://cargocal.com"><font color="#0066CC">Home</font></a><font color="#0066CC">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="http://cargocal.com/sngsp.html"><font color="#0066CC">Back</font></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#Top"><font color="#0066CC">&lt;&lt; Top &gt;&gt;</font></a></font></font></p> <p> <font color="#FF0000" size="2" face="Microsoft Sans Serif">Can't find&#39;&nbsp;Do a custom search here&nbsp;&nbsp;&nbsp; </font> <font color="#0066cc" size="2" face="Microsoft Sans Serif"> <form id="cse-search-box0" action="http://www.google.com/cse" target=_blank> <div><input value="partner-pub-8491802827119857:8g50mkc1bng" type=hidden name=cx> <input value="ISO-8859-1" type="hidden" name="ie"> <input size="44" name="q"> <input value="Search" type="submit" name="sa">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="http://cargocal.com/index.html#jds"> <font color="#0066CC">Contact Us</font></a>&nbsp;&nbsp;&nbsp; </font> <font color="#0066cc" size="1" face="Microsoft Sans Serif">&nbsp;&nbsp;&nbsp; </font> <p> <font color="#808080" size="1" face="Microsoft Sans Serif">©Copyright Sovereign Newzealand® 1999-2012</font><font size="2" color="#808080">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font><font color="#808080" size="1" face="Microsoft Sans Serif">&nbsp;<a href="http://cargocal.com/privacystatement.html"><font color="#808080">Terms &amp; Conditions / Privacy Statement</font></a></font><p align="center"> <font face="Microsoft Sans Serif" size="1" color="#808080"> <a href="http://cargocal.com/cargocaladspace.html"> <font color="#808080">Advertise With Us</font></a></font></div></form> </blockquote> </font> </td></tr></tbody></table></center> <blockquote> <p align="left">&nbsp;</blockquote> </div> </td></tr></tbody></table></td></tr></tbody></table><font size="1"> <p align="center">&nbsp;</p> </font> <!-- Start of StatCounter Code for Frontpage 2002 --> <script type="text/javascript"> var sc_project=3838703; var sc_invisible=1; var sc_security="6e6dd469"; </script> <script type="text/javascript" src="http://www.statcounter.com/counter/counter.js"></script> <noscript> <div class="statcounter"><a title="tumblr page counter" href="http://statcounter.com/tumblr/" target="_blank"><img class="statcounter" src="http://c.statcounter.com/3838703/0/6e6dd469/1/" alt="tumblr page counter"></a></div></noscript> <!-- End of StatCounter Code for Frontpage 2002 --> </body> </html>