INTEGRATION: CWS hcshared16 (1.6.156); FILE MERGED

2008/02/06 10:51:59 ufi 1.6.156.2: RESYNC: (1.6-1.7); FILE MERGED
2008/01/30 08:09:40 ufi 1.6.156.1: new makefiles

1 files changed, 27 insertions, 66 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060118.xhp b/helpcontent2/source/text/scalc/01/04060118.xhp
index d650cbfd96..ea3982c42d 100644
--- a/helpcontent2/source/text/scalc/01/04060118.xhp
+++ b/helpcontent2/source/text/scalc/01/04060118.xhp
@@ -7,9 +7,9 @@
  *
  *  $RCSfile: 04060118.xhp,v $fileonly,v $
  *
- *  $Revision: 1.7 $
+ *  $Revision: 1.8 $
  *
- *  last change: $Author: vg $ $Date: 2008-01-24 13:51:56 $
+ *  last change: $Author: rt $ $Date: 2008-02-19 22:13:12 $
  *
  *  The Contents of this file are made available subject to
  *  the terms of GNU Lesser General Public License Version 2.1.
@@ -74,11 +74,6 @@
 <paragraph role="paragraph" id="par_id3150539" xml-lang="en-US" l10n="U" oldref="82">
 <emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
-<paragraph role="heading" id="hd_id3156402" xml-lang="en-US" level="3" l10n="U" oldref="83">Example</paragraph>
-<paragraph role="paragraph" id="par_id3153018" xml-lang="en-US" l10n="U" oldref="84">Settlement date: November 11 1999, maturity date: March 1 2012, issue date: October 15 1999; First coupon: March 1 2000. Interest rate: 7.85 per cent, yield: 6.25 per cent, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 1</paragraph>
-<paragraph role="paragraph" id="par_id3159128" xml-lang="en-US" l10n="U" oldref="85">The price per 100 currency units par value of a security, which has an irregular first interest date, is calculated as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3149150" xml-lang="en-US" l10n="U" oldref="86">
-<item type="input">=ODDFPRICE("11/11/1999";"3/1/2012";"10/15/1999";"3/1/2000";0.0785;0.0625;100;2;1)</item> returns 113.5985</paragraph>
 </section>
 <section id="oddfyield">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3157871"><bookmark_value>ODDFYIELD function</bookmark_value>
@@ -105,11 +100,6 @@
 <paragraph role="paragraph" id="par_id3148888" xml-lang="en-US" l10n="U" oldref="98">
 <emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
-<paragraph role="heading" id="hd_id3148437" xml-lang="en-US" level="3" l10n="U" oldref="99">Example</paragraph>
-<paragraph role="paragraph" id="par_id3153035" xml-lang="en-US" l10n="U" oldref="100">Settlement date: January 25 1999, maturity date: January 1 2004, issue date: January 18 1999; First coupon: July 15 1999. Interest rate: 5.75 per cent, price: 84.50 currency units, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 0</paragraph>
-<paragraph role="paragraph" id="par_id3150700" xml-lang="en-US" l10n="U" oldref="101">The yield of the security, with an irregular date for the first coupon, is calculated as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3154548" xml-lang="en-US" l10n="U" oldref="102">
-<item type="input">=ODDFYIELD("1/25/1999";"1/1/2004"; "1/18/1999";"7/15/1999";0.0575;84.50;100;2;0)</item> returns 0.097581 or 9.76%.</paragraph>
 </section>
 <section id="oddlprice">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153933"><bookmark_value>ODDLPRICE function</bookmark_value>
@@ -137,8 +127,7 @@
 <paragraph role="heading" id="hd_id3153111" xml-lang="en-US" level="3" l10n="U" oldref="114">Example</paragraph>
 <paragraph role="paragraph" id="par_id3152999" xml-lang="en-US" l10n="U" oldref="115">Settlement date: February 7 1999, maturity date: June 15 1999, last interest: October 15 1998. Interest rate: 3.75 per cent, yield: 4.05 per cent, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 0</paragraph>
 <paragraph role="paragraph" id="par_id3148567" xml-lang="en-US" l10n="U" oldref="116">The price per 100 currency units per value of a security, which has an irregular last interest date, is calculated as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3150332" xml-lang="en-US" l10n="U" oldref="117">
-<item type="input">=ODDLPRICE("2/7/1999";"6/15/1999";"10/15/1998";0.0375;0.0405;100;2;0)</item> returns 99.87829.</paragraph>
+<paragraph role="paragraph" id="par_id3150332" xml-lang="en-US" l10n="CHG" oldref="117">=ODDLPRICE("1999-02-07";"1999-06-15";"1998-10-15"; 0.0375; 0.0405;100;2;0) returns 99.87829.</paragraph>
 </section>
 <section id="oddlyield">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153564"><bookmark_value>ODDLYIELD function</bookmark_value>
@@ -166,8 +155,7 @@
 <paragraph role="heading" id="hd_id3145303" xml-lang="en-US" level="3" l10n="U" oldref="129">Example</paragraph>
 <paragraph role="paragraph" id="par_id3145350" xml-lang="en-US" l10n="U" oldref="130">Settlement date: April 20 1999, maturity date: June 15 1999, last interest: October 15 1998. Interest rate: 3.75 per cent, price: 99.875 currency units, redemption value: 100 currency units, frequency of payments: half-yearly = 2, basis: = 0</paragraph>
 <paragraph role="paragraph" id="par_id3157990" xml-lang="en-US" l10n="U" oldref="131">The yield of the security, that has an irregular last interest date, is calculated as follows:</paragraph>
-<paragraph role="paragraph" id="par_id3150572" xml-lang="en-US" l10n="U" oldref="132">
-<item type="input">=ODDLYIELD("4/20/1999";"6/15/1999";"10/15/1998";0.0375;99.875;100;2;0)</item> returns 0.044873 or 4.4873%.</paragraph>
+<paragraph role="paragraph" id="par_id3150572" xml-lang="en-US" l10n="CHG" oldref="132">=ODDLYIELD("1999-04-20";"1999-06-15"; "1998-10-15"; 0.0375; 99.875; 100;2;0) returns 0.044873 or 4.4873%.</paragraph>
 </section>
 <section id="vdb">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148768"><bookmark_value>calculating;variable declining depreciations</bookmark_value>
@@ -235,9 +223,7 @@
 <paragraph role="paragraph" id="par_id3147083" xml-lang="en-US" l10n="U" oldref="308">1</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3151187" xml-lang="en-US" l10n="U" oldref="309">
-<item type="input">01/01/01</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3151187" xml-lang="en-US" l10n="CHG" oldref="309">2001-01-01</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
 <paragraph role="paragraph" id="par_id3145212" xml-lang="en-US" l10n="U" oldref="201">-<item type="input">10000</item>
@@ -254,9 +240,7 @@
 <paragraph role="paragraph" id="par_id3153277" xml-lang="en-US" l10n="U" oldref="310">2</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3154052" xml-lang="en-US" l10n="U" oldref="203">
-<item type="input">2/1/2001</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3154052" xml-lang="en-US" l10n="CHG" oldref="203">2001-01-02</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
 <paragraph role="paragraph" id="par_id3151297" xml-lang="en-US" l10n="U" oldref="204">
@@ -274,14 +258,10 @@
 <paragraph role="paragraph" id="par_id3154744" xml-lang="en-US" l10n="U" oldref="311">3</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3153151" xml-lang="en-US" l10n="U" oldref="206">
-<item type="input">3/15/2001</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3153151" xml-lang="en-US" l10n="CHG" oldref="206">2001-03-15</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3145657" xml-lang="en-US" l10n="U" oldref="207">
-<item type="input">2500</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3145657" xml-lang="en-US" l10n="U" oldref="207">2500</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan=""/>
 </tablerow>
@@ -290,14 +270,10 @@
 <paragraph role="paragraph" id="par_id3155101" xml-lang="en-US" l10n="U" oldref="312">4</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3146894" xml-lang="en-US" l10n="U" oldref="208">
-<item type="input">5/12/2001</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3146894" xml-lang="en-US" l10n="CHG" oldref="208">2001-05-12</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3143231" xml-lang="en-US" l10n="U" oldref="209">
-<item type="input">5000</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3143231" xml-lang="en-US" l10n="U" oldref="209">5000</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan=""/>
 </tablerow>
@@ -306,20 +282,15 @@
 <paragraph role="paragraph" id="par_id3156012" xml-lang="en-US" l10n="U" oldref="313">5</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3149758" xml-lang="en-US" l10n="U" oldref="210">
-<item type="input">8/10/2001</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3149758" xml-lang="en-US" l10n="CHG" oldref="210">2001-08-10</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan="">
-<paragraph role="paragraph" id="par_id3147495" xml-lang="en-US" l10n="U" oldref="211">
-<item type="input">1000</item>
-</paragraph>
+<paragraph role="paragraph" id="par_id3147495" xml-lang="en-US" l10n="U" oldref="211">1000</paragraph>
 </tablecell>
 <tablecell colspan="" rowspan=""/>
 </tablerow>
 </table>
-<paragraph role="paragraph" id="par_id3152793" xml-lang="en-US" l10n="U" oldref="212">
-<item type="input">=XIRR(B1:B5;A1:A5;0.1)</item> returns 0.1828.</paragraph>
+<paragraph role="paragraph" id="par_id3152793" xml-lang="en-US" l10n="U" oldref="212">=XIRR(B1:B5; A1:A5; 0.1) returns 0.1828.</paragraph>
 </section>
 <section id="xnpv">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149198"><bookmark_value>XNPV function</bookmark_value>
@@ -406,9 +377,8 @@
 <emph>Redemption</emph> is the selling price.</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3145380" xml-lang="en-US" level="3" l10n="U" oldref="68">Example</paragraph>
-<paragraph role="paragraph" id="par_id3149426" xml-lang="en-US" l10n="U" oldref="69">A painting is bought on 1/15/1990 for 1 million and sold on 5/5/2002 for 2 million. The basis is daily balance calculation (basis = 3). What is the average annual level of interest?</paragraph>
-<paragraph role="paragraph" id="par_id3151125" xml-lang="en-US" l10n="U" oldref="70">
-<item type="input">=INTRATE("1/15/1990";"5/5/2002";1000000;2000000;3)</item> returns 8.12%.</paragraph>
+<paragraph role="paragraph" id="par_id3149426" xml-lang="en-US" l10n="CHG" oldref="69">A painting is bought on 1990-01-15 for 1 million and sold on 2002-05-05 for 2 million. The basis is daily balance calculation (basis = 3). What is the average annual level of interest?</paragraph>
+<paragraph role="paragraph" id="par_id3151125" xml-lang="en-US" l10n="CHG" oldref="70">=INTRATE("1990-01-15"; "2002-05-05"; 1000000; 2000000; 3) returns 8.12%.</paragraph>
 </section>
 <section id="coupncd">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148654"><bookmark_value>COUPNCD function</bookmark_value>
@@ -426,9 +396,8 @@
 <emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3155424" xml-lang="en-US" level="3" l10n="U" oldref="170">Example</paragraph>
-<paragraph role="paragraph" id="par_id3154794" xml-lang="en-US" l10n="U" oldref="171">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) when is the next interest date?</paragraph>
-<paragraph role="paragraph" id="par_id3159251" xml-lang="en-US" l10n="U" oldref="172">
-<item type="input">=COUPNCD("1.25.2001";"11.15.2001";2;3)</item> returns 5.15.2001.</paragraph>
+<paragraph role="paragraph" id="par_id3154794" xml-lang="en-US" l10n="CHG" oldref="171">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) when is the next interest date?</paragraph>
+<paragraph role="paragraph" id="par_id3159251" xml-lang="en-US" l10n="CHG" oldref="172">=COUPNCD("2001-01-25"; "2001-11-15"; 2; 3) returns 2001-05-15.</paragraph>
 </section>
 <section id="coupdays">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3143281"><bookmark_value>COUPDAYS function</bookmark_value>
@@ -446,9 +415,8 @@
 <emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3153705" xml-lang="en-US" level="3" l10n="U" oldref="150">Example</paragraph>
-<paragraph role="paragraph" id="par_id3147530" xml-lang="en-US" l10n="U" oldref="151">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there in the interest period in which the settlement date falls?</paragraph>
-<paragraph role="paragraph" id="par_id3156338" xml-lang="en-US" l10n="U" oldref="152">
-<item type="input">=COUPDAYS("1.25.2001";"11.15.2001";2;3)</item> returns 182.</paragraph>
+<paragraph role="paragraph" id="par_id3147530" xml-lang="en-US" l10n="CHG" oldref="151">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there in the interest period in which the settlement date falls?</paragraph>
+<paragraph role="paragraph" id="par_id3156338" xml-lang="en-US" l10n="CHG" oldref="152">=COUPDAYS("2001-01-25"; "2001-11-15"; 2; 3) returns 181.</paragraph>
 </section>
 <section id="coupdaysnc">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3154832"><bookmark_value>COUPDAYSNC function</bookmark_value>
@@ -466,9 +434,8 @@
 <emph>Frequency </emph>is number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3155604" xml-lang="en-US" level="3" l10n="U" oldref="160">Example</paragraph>
-<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US" l10n="U" oldref="161">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there until the next interest payment?</paragraph>
-<paragraph role="paragraph" id="par_id3156158" xml-lang="en-US" l10n="U" oldref="162">
-<item type="input">=COUPDAYSNC("1.25.2001";"11.15.2001";2;3)</item> returns 110.</paragraph>
+<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US" l10n="CHG" oldref="161">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there until the next interest payment?</paragraph>
+<paragraph role="paragraph" id="par_id3156158" xml-lang="en-US" l10n="CHG" oldref="162">=COUPDAYSNC("2001-01-25"; "2001-11-15"; 2; 3) returns 110.</paragraph>
 </section>
 <section id="coupdaybs">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150408"><bookmark_value>COUPDAYBS function</bookmark_value>
@@ -488,9 +455,8 @@
 <emph>Frequency</emph> is the number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3153880" xml-lang="en-US" level="3" l10n="U" oldref="140">Example</paragraph>
-<paragraph role="paragraph" id="par_id3150592" xml-lang="en-US" l10n="U" oldref="141">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days is this?</paragraph>
-<paragraph role="paragraph" id="par_id3151103" xml-lang="en-US" l10n="U" oldref="142">
-<item type="input">=COUPDAYBS("1.25.2001";"11.15.2001";2;3)</item> returns 71.</paragraph>
+<paragraph role="paragraph" id="par_id3150592" xml-lang="en-US" l10n="CHG" oldref="141">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days is this?</paragraph>
+<paragraph role="paragraph" id="par_id3151103" xml-lang="en-US" l10n="CHG" oldref="142">=COUPDAYBS("2001-01-25"; "2001-11-15"; 2; 3) returns 71.</paragraph>
 </section>
 <section id="couppcd">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3152957"><bookmark_value>COUPPCD function</bookmark_value>
@@ -509,9 +475,8 @@
 <emph>Frequency</emph> is the number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3150826" xml-lang="en-US" level="3" l10n="U" oldref="190">Example</paragraph>
-<paragraph role="paragraph" id="par_id3148968" xml-lang="en-US" l10n="U" oldref="191">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) what was the interest date prior to purchase?</paragraph>
-<paragraph role="paragraph" id="par_id3149992" xml-lang="en-US" l10n="U" oldref="192">
-<item type="input">=COUPPCD("1.25.2001";"11.15.2001";2;3)</item> returns 11.15.2000.</paragraph>
+<paragraph role="paragraph" id="par_id3148968" xml-lang="en-US" l10n="CHG" oldref="191">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) what was the interest date prior to purchase?</paragraph>
+<paragraph role="paragraph" id="par_id3149992" xml-lang="en-US" l10n="CHG" oldref="192">=COUPPCD("2001-01-25"; "2001-11-15"; 2; 3) returns 2000-15-11.</paragraph>
 </section>
 <section id="coupnum">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150673"><bookmark_value>COUPNUM function</bookmark_value>
@@ -530,9 +495,8 @@
 <emph>Frequency</emph> is the number of interest payments per year (1, 2 or 4).</paragraph>
 <embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
 <paragraph role="heading" id="hd_id3149319" xml-lang="en-US" level="3" l10n="U" oldref="180">Example</paragraph>
-<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U" oldref="181">A security is purchased on 1.25.2001; the date of maturity is 11.15.2001. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many interest dates are there?</paragraph>
-<paragraph role="paragraph" id="par_id3150640" xml-lang="en-US" l10n="U" oldref="182">
-<item type="input">=COUPNUM("1.25.2001";"11.15.2001";2;3)</item> returns 2.</paragraph>
+<paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="CHG" oldref="181">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many interest dates are there?</paragraph>
+<paragraph role="paragraph" id="par_id3150640" xml-lang="en-US" l10n="CHG" oldref="182">=COUPNUM("2001-01-25"; "2001-11-15"; 2; 3) returns 2.</paragraph>
 </section>
 <section id="ipmt">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149339"><bookmark_value>IPMT function</bookmark_value>
@@ -554,9 +518,6 @@
 <emph>FV</emph> (optional) is the desired value (future value) at the end of the periods.</paragraph>
 <paragraph role="paragraph" id="par_id3154195" xml-lang="en-US" l10n="U" oldref="272">
 <emph>Type</emph> is the due date for the periodic payments.</paragraph>
-<paragraph role="paragraph" id="par_idN113F8" xml-lang="en-US" l10n="NEW">
-<embedvar href="text/scalc/00/00000004.xhp#optional"/>
-</paragraph>
 <paragraph role="heading" id="hd_id3150102" xml-lang="en-US" level="3" l10n="U" oldref="273">Example</paragraph>
 <paragraph role="paragraph" id="par_id3149438" xml-lang="en-US" l10n="U" oldref="274">What is the interest rate during the fifth period (year) if the constant interest rate is 5% and the cash value is 15,000 currency units? The periodic payment is seven years.</paragraph>
 <paragraph role="paragraph" id="par_id3150496" xml-lang="en-US" l10n="U" oldref="275">