AllLangHelp_sbasic.mk | 1 source/auxiliary/sbasic.tree | 1 source/text/sbasic/shared/03140004.xhp | 78 +++++++++++++++++++++++++ source/text/sbasic/shared/special_vba_func.xhp | 4 - 4 files changed, 82 insertions(+), 2 deletions(-)
New commits: commit 139a1c699caadd5365e335a432ffd5fdad8d73de Author: Olivier Hallot <[email protected]> Date: Fri Jun 16 17:38:23 2017 -0300 tdf#84675 Add help page for MIRR function of VBA Change-Id: I7b55b4994a1c65b714be3ad4114aee9233502276 Reviewed-on: https://gerrit.libreoffice.org/38897 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk index 731bb7d46..6ef725554 100644 --- a/AllLangHelp_sbasic.mk +++ b/AllLangHelp_sbasic.mk @@ -328,6 +328,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\ helpcontent2/source/text/sbasic/shared/03140001 \ helpcontent2/source/text/sbasic/shared/03140002 \ helpcontent2/source/text/sbasic/shared/03140003 \ + helpcontent2/source/text/sbasic/shared/03140004 \ helpcontent2/source/text/sbasic/shared/05060700 \ helpcontent2/source/text/sbasic/shared/code-stubs \ helpcontent2/source/text/sbasic/shared/keys \ diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree index d95a88c48..b690cf868 100644 --- a/source/auxiliary/sbasic.tree +++ b/source/auxiliary/sbasic.tree @@ -184,6 +184,7 @@ <topic id="sbasic/text/sbasic/shared/03080202.xhp">Log Function [Runtime]</topic> <topic id="sbasic/text/sbasic/shared/03120306.xhp">Mid Function, Mid Statement [Runtime]</topic> <topic id="sbasic/text/sbasic/shared/03030202.xhp">Minute Function [Runtime]</topic> +<topic id="sbasic/text/sbasic/shared/03140004.xhp">MIRR Function [Runtime - VBA]</topic> <topic id="sbasic/text/sbasic/shared/03020411.xhp">MkDir Statement [Runtime]</topic> <topic id="sbasic/text/sbasic/shared/03070600.xhp">Mod-Operator [Runtime]</topic> <topic id="sbasic/text/sbasic/shared/03030104.xhp">Month Function [Runtime]</topic> diff --git a/source/text/sbasic/shared/03140004.xhp b/source/text/sbasic/shared/03140004.xhp new file mode 100644 index 000000000..710b834ca --- /dev/null +++ b/source/text/sbasic/shared/03140004.xhp @@ -0,0 +1,78 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> +<!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . +--> + +<meta> + <topic id="textsbasicshared03140004xml" indexer="include" status="PUBLISH"> + <title id="tit" xml-lang="en-US">MIRR Function [Runtime - VBA]</title> + <filename>/text/sbasic/shared/03140004.xhp</filename> + </topic> +</meta> + +<body> + + +<section id="mirr"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150499"> + <bookmark_value>MIRR function</bookmark_value> +</bookmark> + + +<paragraph id="hd_id3150499" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03140004.xhp" name="MIRR Function [Runtime - VBA]">MIRR Function [Runtime - VBA]</link></paragraph> +<paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">Calculates the modified internal rate of return of a series of investments.</paragraph> +</section> +<embed href="text/sbasic/shared/00000003.xhp#vbasupport"/> + +<paragraph id="hd_id061420170116474964" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functsyntax"/></paragraph> +<bascode> +<paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">MIRR(Values() as Double, Investment as Double, ReinvestRate as Double)</paragraph> +</bascode> + +<paragraph id="hd_id0614201701254487" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functvalue"/></paragraph> +<paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">Double</paragraph> + +<paragraph id="hd_id061420170125448913" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functparameters"/></paragraph> +<paragraph id="par_id061420170730135034" role="paragraph" xml-lang="en-US"><emph>Values(): </emph>An array of cash flows, representing a series of payments and income, where negative values are treated as payments and positive values are treated as income. This array must contain at least one negative and at least one positive value.</paragraph> +<paragraph id="par_id061620170513518949" role="paragraph" xml-lang="en-US"><emph>Investment</emph>: is the rate of interest of the investments (the negative values of the array).</paragraph> +<paragraph id="par_id061420170730137782" role="paragraph" xml-lang="en-US"><emph>ReinvestRate:</emph> the rate of interest of the reinvestment (the positive values of the array).</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> + +<paragraph id="hd_id061420170125449765" role="heading" level="2" xml-lang="en-US"><embedvar href="text/sbasic/shared/00000003.xhp#functexample"/></paragraph> +<bascode> +<paragraph id="par_id06162017021753974" role="bascode" localize="false" xml-lang="en-US">REM ***** BASIC *****</paragraph> +<paragraph id="par_id061620170217534991" role="bascode" localize="false" xml-lang="en-US">Option VBASupport 1</paragraph> +<paragraph id="par_id061620170217535111" role="bascode" localize="false" xml-lang="en-US">Sub ExampleMIRR</paragraph> +<paragraph id="par_id061620170217538573" role="bascode" localize="false" xml-lang="en-US"> Dim cashFlow(0 to 3) As Double</paragraph> +<paragraph id="par_id06162017021753515" role="bascode" localize="false" xml-lang="en-US"> cashFlow(0) = -5</paragraph> +<paragraph id="par_id061620170217538580" role="bascode" localize="false" xml-lang="en-US"> cashFlow(1) = 10</paragraph> +<paragraph id="par_id061620170217543462" role="bascode" localize="false" xml-lang="en-US"> cashFlow(2) = 15</paragraph> +<paragraph id="par_id061620170217549769" role="bascode" localize="false" xml-lang="en-US"> cashFlow(3) = 8</paragraph> +<paragraph id="par_id061620170217542970" role="bascode" localize="false" xml-lang="en-US"> mirrValue = MIRR(cashFlow,0.5,0.1) * 100</paragraph> +<paragraph id="par_id061620170217548258" role="bascode" xml-lang="en-US"> Print mirrValue ' returns 94.16. The modified internal rate of return of the cash flow.</paragraph> +<paragraph id="par_id061620170217544542" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> +</bascode> + +<section id="relatedtopics"> +<paragraph id="par_id061420170153186192" role="paragraph" xml-lang="en-US"><link href="text/scalc/01/04060119.xhp#bm_id3148974">MIRR function in CALC</link></paragraph> +<paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><link href="text/sbasic/shared/special_vba_func.xhp">VBA financial functions</link></paragraph> +</section> +</body> + +</helpdocument> \ No newline at end of file diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp index 12d68f22e..e4101b8f5 100644 --- a/source/text/sbasic/shared/special_vba_func.xhp +++ b/source/text/sbasic/shared/special_vba_func.xhp @@ -79,7 +79,7 @@ <paragraph id="par_id051820170335282035" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140003.xhp">IRR</link></paragraph> </listitem> <listitem> - <paragraph id="par_id051820170335284205" role="paragraph" localize="false" xml-lang="en-US">MIRR</paragraph> + <paragraph id="par_id051820170335284205" role="paragraph" localize="false" xml-lang="en-US"><link href="text/sbasic/shared/03140004.xhp">MIRR</link></paragraph> </listitem> <listitem> <paragraph id="par_id051820170335297182" role="paragraph" localize="false" xml-lang="en-US">NPer</paragraph> @@ -157,4 +157,4 @@ </listitem></list> </body> -</helpdocument> \ No newline at end of file +</helpdocument> _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
