diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 18:57:14 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 18:57:14 +0000 |
| commit | 9339d40167cc0b3f1e28ff6977f27ab32be32c5c (patch) | |
| tree | 110ce0419aced24ba6a5972de9e7b9f678a52623 /helpcontent2/source/text/scalc/guide/goalseek.xhp | |
| parent | f923ca053473c34d67cec9549368617641bad8a3 (diff) | |
INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED
2004/09/16 11:46:30 fpe 1.1.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source/text/scalc/guide/goalseek.xhp')
| -rwxr-xr-x | helpcontent2/source/text/scalc/guide/goalseek.xhp | 90 |
1 files changed, 45 insertions, 45 deletions
diff --git a/helpcontent2/source/text/scalc/guide/goalseek.xhp b/helpcontent2/source/text/scalc/guide/goalseek.xhp index 62164dcddf..7daefa6a35 100755 --- a/helpcontent2/source/text/scalc/guide/goalseek.xhp +++ b/helpcontent2/source/text/scalc/guide/goalseek.xhp @@ -1,4 +1,4 @@ -<?xml version="1.0" encoding="UTF-8"?>
+<?xml version="1.0" encoding="UTF-8"?> <!--*********************************************************************** * * The Contents of this file are made available subject to the terms of @@ -52,50 +52,50 @@ * Contributor(s): _______________________________________ * * - ************************************************************************-->
-
-<helpdocument version="1.0">
-<meta>
-<topic id="textscalcguidegoalseekxml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Applying Goal Seek</title>
-<filename>/text/scalc/guide/goalseek.xhp</filename>
-</topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-07-20T10:23:49">converted from old format - fpe</lastedited>
-</history>
-</meta>
+ ************************************************************************--> + +<helpdocument version="1.0"> +<meta> +<topic id="textscalcguidegoalseekxml" indexer="include" status="PUBLISH"> +<title id="tit" xml-lang="en-US">Applying Goal Seek</title> +<filename>/text/scalc/guide/goalseek.xhp</filename> +</topic> +<history> +<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> +<lastedited date="2004-09-09T16:38:13">converted from old format - fpe</lastedited> +</history> +</meta> <body> -<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>goal seek</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145068"><bookmark_value>goal seek</bookmark_value> <bookmark_value>equations; goal seek</bookmark_value> -</bookmark>
+</bookmark> <paragraph role="heading" id="hd_id3145068" xml-lang="en-US" level="1" l10n="U" oldref="22"><variable id="goalseek"><link href="text/scalc/guide/goalseek.xhp" name="Applying Goal Seek">Applying Goal Seek</link> -</variable></paragraph>
-<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="2">With the help of Goal Seek you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.</paragraph>
-<paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="2" l10n="U" oldref="14">Goal Seek Example</paragraph>
-<paragraph role="paragraph" id="par_id3150871" xml-lang="en-US" l10n="U" oldref="4">To calculate annual interest (I), create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is:</paragraph>
-<paragraph role="code" id="par_id3152596" xml-lang="en-US" l10n="U" oldref="5">I = C * n* i</paragraph>
-<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US" l10n="CHG" oldref="15">Let us assume that the interest rate <item type="literal">i</item> of 7.5% and the number of years <item type="literal">n</item> (1) will remain constant. However, you want to know how much the investment capital <item type="literal">C</item> would have to be modified in order to attain a particular return <item type="literal">I</item>. For this example, calculate how much capital <item type="literal">C</item> would be required if you want an annual return of $15,000.</paragraph>
-<paragraph role="paragraph" id="par_id3155960" xml-lang="en-US" l10n="CHG" oldref="6">Enter each of the values for Capital <item type="literal">C</item> (an arbitrary value like <item type="literal">$100,000</item>) number of years <item type="literal">n </item>(<item type="literal">1</item>) and interest rate <item type="literal">i</item> (<item type="literal">7.5%</item>) in one cell of the spreadsheet. Enter the formula to calculate the interest <item type="literal">I</item> in another cell. Instead of <item type="literal">C</item>, <item type="literal">n</item>, and <item type="literal">i</item> use the <link href="text/scalc/guide/relativ_absolut_ref.xhp">reference to the cell</link> with the corresponding value.</paragraph>
-<list type="ordered">
-<listitem>
-<paragraph role="listitem" id="par_id3147001" xml-lang="en-US" l10n="U" oldref="16">Place the cursor in the cell containing the interest <item type="literal">I</item>, and choose <emph>Tools - Goal Seek</emph>. The <emph>Goal Seek</emph> dialog appears.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3150088" xml-lang="en-US" l10n="U" oldref="17">The correct cell is already entered in the field <emph>Formula Cell</emph>.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="18">Place the cursor in the field <emph>Variable Cell</emph>. In the sheet, click in the cell that contains the value to be changed, in this example it is the cell with the capital value <item type="literal">C</item>.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3150369" xml-lang="en-US" l10n="U" oldref="19">Enter the expected result of the formula in the <emph>Target Value</emph> text box. In this example, the value is 15,000. Click <emph>OK</emph>.</paragraph>
-</listitem>
-<listitem>
-<paragraph role="listitem" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="20">A dialog appears informing you that the Goal Seek was successful. Click <emph>Yes</emph> to enter the result in the cell with the variable value.</paragraph>
-</listitem>
-</list>
-<section id="relatedtopics">
-<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US" l10n="U" oldref="23"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></paragraph>
-</section>
-</body>
-</helpdocument>
+</variable></paragraph> +<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="2">With the help of Goal Seek you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.</paragraph> +<paragraph role="heading" id="hd_id3153966" xml-lang="en-US" level="2" l10n="U" oldref="14">Goal Seek Example</paragraph> +<paragraph role="paragraph" id="par_id3150871" xml-lang="en-US" l10n="U" oldref="4">To calculate annual interest (I), create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is:</paragraph> +<paragraph role="code" id="par_id3152596" xml-lang="en-US" l10n="U" oldref="5">I = C * n* i</paragraph> +<paragraph role="paragraph" id="par_id3155335" xml-lang="en-US" l10n="CHG" oldref="15">Let us assume that the interest rate <item type="literal">i</item> of 7.5% and the number of years <item type="literal">n</item> (1) will remain constant. However, you want to know how much the investment capital <item type="literal">C</item> would have to be modified in order to attain a particular return <item type="literal">I</item>. For this example, calculate how much capital <item type="literal">C</item> would be required if you want an annual return of $15,000.</paragraph> +<paragraph role="paragraph" id="par_id3155960" xml-lang="en-US" l10n="CHG" oldref="6">Enter each of the values for Capital <item type="literal">C</item> (an arbitrary value like <item type="literal">$100,000</item>), number of years <item type="literal">n </item>(<item type="literal">1</item>), and interest rate <item type="literal">i</item> (<item type="literal">7.5%</item>) in one cell each. Enter the formula to calculate the interest <item type="literal">I</item> in another cell. Instead of <item type="literal">C</item>, <item type="literal">n</item>, and <item type="literal">i</item> use the <link href="text/scalc/guide/relativ_absolut_ref.xhp">reference to the cell</link> with the corresponding value.</paragraph> +<list type="ordered"> +<listitem> +<paragraph role="listitem" id="par_id3147001" xml-lang="en-US" l10n="U" oldref="16">Place the cursor in the cell containing the interest <item type="literal">I</item>, and choose <emph>Tools - Goal Seek</emph>. The <emph>Goal Seek</emph> dialog appears.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3150088" xml-lang="en-US" l10n="U" oldref="17">The correct cell is already entered in the field <emph>Formula Cell</emph>.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3166426" xml-lang="en-US" l10n="U" oldref="18">Place the cursor in the field <emph>Variable Cell</emph>. In the sheet, click in the cell that contains the value to be changed, in this example it is the cell with the capital value <item type="literal">C</item>.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3150369" xml-lang="en-US" l10n="U" oldref="19">Enter the expected result of the formula in the <emph>Target Value</emph> text box. In this example, the value is 15,000. Click <emph>OK</emph>.</paragraph> +</listitem> +<listitem> +<paragraph role="listitem" id="par_id3146978" xml-lang="en-US" l10n="U" oldref="20">A dialog appears informing you that the Goal Seek was successful. Click <emph>Yes</emph> to enter the result in the cell with the variable value.</paragraph> +</listitem> +</list> +<section id="relatedtopics"> +<paragraph role="paragraph" id="par_id3149409" xml-lang="en-US" l10n="U" oldref="23"><link href="text/scalc/01/06040000.xhp" name="Goal Seek">Goal Seek</link></paragraph> +</section> +</body> +</helpdocument> |