diff options
Diffstat (limited to 'source/ja/helpcontent2/source/text/scalc/01.po')
| -rw-r--r-- | source/ja/helpcontent2/source/text/scalc/01.po | 1098 |
1 files changed, 729 insertions, 369 deletions
diff --git a/source/ja/helpcontent2/source/text/scalc/01.po b/source/ja/helpcontent2/source/text/scalc/01.po index 6675baed2d3..9793f3cd668 100644 --- a/source/ja/helpcontent2/source/text/scalc/01.po +++ b/source/ja/helpcontent2/source/text/scalc/01.po @@ -3,7 +3,7 @@ msgid "" msgstr "" "Project-Id-Version: PACKAGE VERSION\n" "Report-Msgid-Bugs-To: https://bugs.libreoffice.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&component=UI\n" -"POT-Creation-Date: 2019-11-13 13:46+0100\n" +"POT-Creation-Date: 2020-01-07 14:09+0100\n" "PO-Revision-Date: 2019-08-09 07:40+0000\n" "Last-Translator: serval2412 <serval2412@yahoo.fr>\n" "Language-Team: LANGUAGE <LL@li.org>\n" @@ -3832,22 +3832,31 @@ msgctxt "" msgid "<bookmark_value>inserting functions; Function Wizard</bookmark_value><bookmark_value>functions;Function Wizard</bookmark_value><bookmark_value>wizards; functions</bookmark_value>" msgstr "<bookmark_value>関数の挿入; 関数ウィザード</bookmark_value><bookmark_value>関数; 関数ウィザード</bookmark_value><bookmark_value>ウィザード; 関数</bookmark_value>" -#. 8hkzg +#. KeWpp #: 04060000.xhp msgctxt "" "04060000.xhp\n" "hd_id3147426\n" "help.text" -msgid "<link href=\"text/scalc/01/04060000.xhp\" name=\"AutoPilot: Functions\">Function Wizard</link>" -msgstr "<link href=\"text/scalc/01/04060000.xhp\" name=\"関数ウィザード\">関数ウィザード</link>" +msgid "<link href=\"text/scalc/01/04060000.xhp\" name=\"AutoPilot: Functions\">Function</link>" +msgstr "" -#. qWAXe +#. wjD4H #: 04060000.xhp msgctxt "" "04060000.xhp\n" "par_id3145271\n" "help.text" -msgid "<variable id=\"funktionsautopilottext\"><ahelp hid=\".\">Opens the <emph>Function Wizard</emph>, which helps you to interactively create formulas.</ahelp></variable> Before you start the Wizard, select a cell or a range of cells from the current sheet, in order to determine the position at which the formula will be inserted." +msgid "<variable id=\"funktionsautopilottext\"><ahelp hid=\".\">Opens the <emph>Function Wizard</emph>, which helps you to interactively create formulas.</ahelp></variable>" +msgstr "" + +#. exDJs +#: 04060000.xhp +msgctxt "" +"04060000.xhp\n" +"par_id491577286833512\n" +"help.text" +msgid "Before you start the Wizard, select a cell or a range of cells from the current sheet, in order to determine the position at which the formula will be inserted." msgstr "" #. xeqnV @@ -5542,13 +5551,13 @@ msgctxt "" msgid "<bookmark_value>date and time functions</bookmark_value> <bookmark_value>functions; date & time</bookmark_value> <bookmark_value>Function Wizard; date & time</bookmark_value>" msgstr "" -#. 27DbC +#. 4twnp #: 04060102.xhp msgctxt "" "04060102.xhp\n" "hd_id3154536\n" "help.text" -msgid "Date & Time Functions" +msgid "<variable id=\"h1\">Date & Time Functions</variable>" msgstr "" #. MJ2GD @@ -7045,23 +7054,23 @@ msgctxt "" msgid "<item type=\"input\">=DISC(\"2001-01-25\";\"2001-11-15\";97;100;3)</item> returns about 0.0372 or 3.72 per cent." msgstr "<item type=\"input\">=DISC(\"2001-01-25\";\"2001-11-15\";97;100;3)</item> は 0.0372 もしくは 3.72% を 返します。" -#. hm7Tq +#. pLhCb #: 04060103.xhp msgctxt "" "04060103.xhp\n" "bm_id3154695\n" "help.text" -msgid "<bookmark_value>DURATION_ADD function</bookmark_value> <bookmark_value>Microsoft Excel functions</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value>" -msgstr "<bookmark_value>DURATION_ADD 関数</bookmark_value><bookmark_value>Microsoft Excel 関数</bookmark_value><bookmark_value>期間;固定金利証券</bookmark_value>" +msgid "<bookmark_value>DURATION function</bookmark_value> <bookmark_value>durations;fixed interest securities</bookmark_value>" +msgstr "" -#. bD2zQ +#. coRDF #: 04060103.xhp msgctxt "" "04060103.xhp\n" "hd_id3154695\n" "help.text" -msgid "DURATION_ADD" -msgstr "DURATION_ADD" +msgid "DURATION" +msgstr "" #. oA2tj #: 04060103.xhp @@ -7072,14 +7081,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_AAI_FUNC_DURATION\">Calculates the duration of a fixed interest security in years.</ahelp>" msgstr "<ahelp hid=\"HID_AAI_FUNC_DURATION\" visibility=\"visible\">固定金利証券の期間の年数を計算します。</ahelp>" -#. MEAyR +#. bJZPP #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3153373\n" "help.text" -msgid "DURATION_ADD(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)" -msgstr "DURATION_ADD(\"Settlement\"; \"Maturity\"; 利札; 利回り; 利息支払回数; 基準)" +msgid "DURATION(\"Settlement\"; \"Maturity\"; Coupon; Yield; Frequency; Basis)" +msgstr "" #. JeeVp #: 04060103.xhp @@ -7135,14 +7144,14 @@ msgctxt "" msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The Coupon rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the duration?" msgstr "証券を 2001 年 1 月 1 日に購入し、満期日は 2006 年 1 月 1 日です。名目利率は 8% です。利回りは 9.0% です。利息は半年に一度支払われます (年間の利息支払回数は 2 回)。1 日単位の未払い利息計算 (基準 3) を使用して、修正された期間を求めます。" -#. vGsKM +#. ggYzf #: 04060103.xhp msgctxt "" "04060103.xhp\n" "par_id3154902\n" "help.text" -msgid "<item type=\"input\">=DURATION_ADD(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" -msgstr "<item type=\"input\">=DURATION_ADD(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" +msgid "<item type=\"input\">=DURATION(\"2001-01-01\";\"2006-01-01\";0.08;0.09;2;3)</item>" +msgstr "" #. TjeEJ #: 04060103.xhp @@ -14443,14 +14452,14 @@ msgctxt "" msgid "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" msgstr "負の数だけを合計するには: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>" -#. rxMQ3 +#. GGT9C #: 04060106.xhp msgctxt "" "04060106.xhp\n" "par_id6670125\n" "help.text" -msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." -msgstr "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:10)</item> は、範囲 A1:A10 の対応する値が 0 より大きい場合だけ、範囲 B1:B10 の値を合計します。" +msgid "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0." +msgstr "" #. G5vdm #: 04060106.xhp @@ -15127,14 +15136,14 @@ msgctxt "" msgid "<item type=\"input\">=ODD(-3.1)</item> returns -5." msgstr "<item type=\"input\">=ODD(-3.1)</item> は、5 を返します。" -#. Tkdj9 +#. CR7gG #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id2957404\n" "help.text" -msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" -msgstr "<bookmark_value>FLOOR 関数</bookmark_value><bookmark_value>丸め;もっとも近い基準値の倍数に切り下げる</bookmark_value>" +msgid "<bookmark_value>FLOOR.PRECISE function</bookmark_value> <bookmark_value>FLOOR.XCL function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgstr "" #. ticPN #: 04060106.xhp @@ -15190,14 +15199,14 @@ msgctxt "" msgid "<item type=\"input\">=FLOOR.PRECISE( -11;-2)</item> returns -12" msgstr "<item type=\"input\">=FLOOR( -11;-2)</item> は、-12 を返します。" -#. qdxiZ +#. aDgE5 #: 04060106.xhp msgctxt "" "04060106.xhp\n" "bm_id3157404\n" "help.text" -msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" -msgstr "<bookmark_value>FLOOR 関数</bookmark_value><bookmark_value>丸め;もっとも近い基準値の倍数に切り下げる</bookmark_value>" +msgid "<bookmark_value>FLOOR function</bookmark_value> <bookmark_value>FLOOR.MATH function</bookmark_value> <bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" +msgstr "" #. BAZE3 #: 04060106.xhp @@ -17800,14 +17809,14 @@ msgctxt "" msgid "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\" name=\"Statistics Functions\">Statistics Functions</link></variable>" msgstr "" -#. eNDVS +#. M7Z6D #: 04060108.xhp msgctxt "" "04060108.xhp\n" "par_id3157874\n" "help.text" -msgid "<variable id=\"statistiktext\">This category contains the <emph>Statistics</emph> functions. </variable>" -msgstr "<variable id=\"statistiktext\">この分類項目には <emph>統計</emph> 関数が含まれています。</variable>" +msgid "<variable id=\"statistiktext\">This category contains the <emph>Statistics</emph> functions.</variable>" +msgstr "" #. HiTED #: 04060108.xhp @@ -17818,33 +17827,6 @@ msgctxt "" msgid "Some of the examples use the following data table:" msgstr "この節では、次の表を例として使用します。" -#. hYpm5 -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3148775\n" -"help.text" -msgid "C" -msgstr "C" - -#. bPvvQ -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3145297\n" -"help.text" -msgid "D" -msgstr "D" - -#. ySt77 -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3150661\n" -"help.text" -msgid "2" -msgstr "2" - #. PeXDp #: 04060108.xhp msgctxt "" @@ -17863,195 +17845,6 @@ msgctxt "" msgid "y value" msgstr "Y 値" -#. pNBpa -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3153224\n" -"help.text" -msgid "3" -msgstr "3" - -#. GCDq5 -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3150475\n" -"help.text" -msgid "-5" -msgstr "-5" - -#. K4fiE -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3155367\n" -"help.text" -msgid "-3" -msgstr "-3" - -#. 8cSjP -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3149783\n" -"help.text" -msgid "4" -msgstr "4" - -#. YQKPp -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3153181\n" -"help.text" -msgid "-2" -msgstr "-2" - -#. p5BEY -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3148429\n" -"help.text" -msgid "0" -msgstr "0" - -#. DT4EG -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3152588\n" -"help.text" -msgid "5" -msgstr "5" - -#. zqQWt -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3147483\n" -"help.text" -msgid "-1" -msgstr "-1" - -#. GsCZB -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3083443\n" -"help.text" -msgid "1" -msgstr "1" - -#. LyuFQ -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3149826\n" -"help.text" -msgid "6" -msgstr "6" - -#. BfBEi -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3163820\n" -"help.text" -msgid "0" -msgstr "0" - -#. 2pfGT -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3154816\n" -"help.text" -msgid "3" -msgstr "3" - -#. 4idBB -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3149276\n" -"help.text" -msgid "7" -msgstr "7" - -#. wUKtq -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3149267\n" -"help.text" -msgid "2" -msgstr "2" - -#. hyKxt -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3156310\n" -"help.text" -msgid "4" -msgstr "4" - -#. 8HMk6 -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3154639\n" -"help.text" -msgid "8" -msgstr "8" - -#. Ec6AG -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3145205\n" -"help.text" -msgid "4" -msgstr "4" - -#. FnpA8 -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3153276\n" -"help.text" -msgid "6" -msgstr "6" - -#. ee6VB -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3150756\n" -"help.text" -msgid "9" -msgstr "9" - -#. EM3Gs -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3156095\n" -"help.text" -msgid "6" -msgstr "6" - -#. oFf2A -#: 04060108.xhp -msgctxt "" -"04060108.xhp\n" -"par_id3152929\n" -"help.text" -msgid "8" -msgstr "8" - #. BbE8F #: 04060108.xhp msgctxt "" @@ -20041,14 +19834,14 @@ msgctxt "" msgid "<item type=\"input\">=HYPERLINK(\"http://www.example.org\";\"Click here\")</item> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked." msgstr "<item type=\"input\">=HYPERLINK(\"http://www.example.org\";\"Click here\")</item> は、クリックされると、セルにテキスト「Click here」を表示し、ハイパーリンク http://www.example.org を実行します。" -#. 6vtR6 +#. nBEGH #: 04060109.xhp msgctxt "" "04060109.xhp\n" "par_id0907200912224534\n" "help.text" -msgid "=HYPERLINK(\"http://www.example.org\";12345) displays the number 12345 and executes the hyperlink http://www.example.org when clicked." -msgstr "=HYPERLINK(\"http://www.example.org\";12345) は 12345 を表示して、クリックするとハイパーリンクhttp://www.example.orgを実行します。" +msgid "<item type=\"input\">=HYPERLINK(\"http://www.example.org\";12345)</item> displays the number 12345 and executes the hyperlink http://www.example.org when clicked." +msgstr "" #. GFCwJ #: 04060109.xhp @@ -30877,14 +30670,14 @@ msgctxt "" msgid "A security is purchased on 1999-02-15; the maturity date is 2007-11-15. The nominal rate of interest is 5.75%. The yield is 6.5%. The redemption value is 100 currency units. Interest is paid half-yearly (frequency is 2). With calculation on basis 0, the price is as follows:" msgstr "証券を 1999 年 02 月 15 日に購入し、満期日は 2007 年 11 月 15 日です。名目利率は 5.75% です。利回りは 6.5% です。償還価値は 100 通貨単位です。利息は半年に一度支払われます (年間の利息支払回数は 2 回)。基準 0 を基に計算すると、取得価額は次のようになります。" -#. SGB87 +#. mvRnh #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3147273\n" "help.text" -msgid "=PRICE(\"1999-02-15\"; \"2007-11-15\"; 0.0575; 0.065; 100; 2; 0) returns 95.04287." -msgstr "=PRICE(\"1999-02-15\"; \"2007-11-15\"; 0.0575; 0.065; 100; 2; 0) は、95.04287 を返します。" +msgid "<input>=PRICE(\"1999-02-15\"; \"2007-11-15\"; 0.0575; 0.065; 100; 2; 0)</input> returns 95.04287." +msgstr "" #. sQGxa #: 04060119.xhp @@ -30967,14 +30760,14 @@ msgctxt "" msgid "A security is purchased on 1999-02-15; the maturity date is 1999-03-01. Discount in per cent is 5.25%. The redemption value is 100. When calculating on basis 2 the price discount is as follows:" msgstr "証券を 1999 年 02 月 15 日に購入し、満期日は 1999 年 3 月 1 日です。割引率は、5.25% です。償還価値は 100 です。基準 2 を基に計算すると、取得価額の割引率は次のようになります。" -#. zWwmn +#. ZeFG7 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3151178\n" "help.text" -msgid "=PRICEDISC(\"1999-02-15\"; \"1999-03-01\"; 0.0525; 100; 2) returns 99.79583." -msgstr "=PRICEDISC(\"1999-02-15\"; \"1999-03-01\"; 0.0525; 100; 2) は、99.79583 を返します。" +msgid "<input>=PRICEDISC(\"1999-02-15\"; \"1999-03-01\"; 0.0525; 100; 2)</input> returns 99.79583." +msgstr "" #. hbGNH #: 04060119.xhp @@ -31075,32 +30868,32 @@ msgctxt "" msgid "The price is calculated as follows:" msgstr "価格の計算は次のようになります:" -#. ed6RY +#. fi4NY #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3158409\n" "help.text" -msgid "=PRICEMAT(\"1999-02-15\";\"1999-04-13\";\"1998-11-11\"; 0.061; 0.061;0) returns 99.98449888." -msgstr "=PRICEMAT(\"1999-02-15\";\"1999-04-13\";\"1998-11-11\"; 0.061; 0.061;0) は、99.98449888 を返します。" +msgid "<input>=PRICEMAT(\"1999-02-15\";\"1999-04-13\";\"1998-11-11\"; 0.061; 0.061;0)</input> returns 99.98449888." +msgstr "" -#. crj7S +#. GAN7n #: 04060119.xhp msgctxt "" "04060119.xhp\n" "bm_id3148448\n" "help.text" -msgid "<bookmark_value>calculating; durations</bookmark_value><bookmark_value>durations;calculating</bookmark_value><bookmark_value>DURATION function</bookmark_value>" -msgstr "<bookmark_value>計算; 期間</bookmark_value><bookmark_value>期間;計算</bookmark_value><bookmark_value>DURATION 関数</bookmark_value>" +msgid "<bookmark_value>calculating; durations</bookmark_value><bookmark_value>durations;calculating</bookmark_value><bookmark_value>PDURATION function</bookmark_value>" +msgstr "" -#. HUEcU +#. EjWXp #: 04060119.xhp msgctxt "" "04060119.xhp\n" "hd_id3148448\n" "help.text" -msgid "DURATION" -msgstr "DURATION" +msgid "PDURATION" +msgstr "" #. mQkqy #: 04060119.xhp @@ -31111,14 +30904,14 @@ msgctxt "" msgid "<ahelp hid=\"HID_FUNC_LAUFZEIT\">Calculates the number of periods required by an investment to attain the desired value.</ahelp>" msgstr "<ahelp hid=\"HID_FUNC_LAUFZEIT\">この関数は、積立ての期間の回数を計算し、特定の値を得ることができます。</ahelp>" -#. brSXj +#. wLSMC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148933\n" "help.text" -msgid "DURATION(Rate; PV; FV)" -msgstr "DURATION(利率; PV; FV)" +msgid "PDURATION(Rate; PV; FV)" +msgstr "" #. Rzxhq #: 04060119.xhp @@ -31327,14 +31120,14 @@ msgctxt "" msgid "A security is purchased on 2001-01-01; the maturity date is 2006-01-01. The nominal rate of interest is 8%. The yield is 9.0%. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how long is the modified duration?" msgstr "証券を 2001 年 1 月 1 日に購入し、満期日は 2006 年 1 月 1 日です。名目利率は 8% です。利回りは 9.0% です。利息は半年に一度支払われます (年間の利息支払回数は 2 回)。1 日単位の未払い利息計算 (基準 3) を使用して、修正された期間を求めます。" -#. uvE3L +#. PWSr2 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3145378\n" "help.text" -msgid "=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3) returns 4.02 years." -msgstr "=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3) は、4.02 年を返します。" +msgid "<input>=MDURATION(\"2001-01-01\"; \"2006-01-01\"; 0.08; 0.09; 2; 3)</input> returns 4.02 years." +msgstr "" #. BrDKP #: 04060119.xhp @@ -31876,14 +31669,14 @@ msgctxt "" msgid "A security is purchased on 1999-02-15. It matures on 2007-11-15. The rate of interest is 5.75%. The price is 95.04287 currency units per 100 units of par value, the redemption value is 100 units. Interest is paid half-yearly (frequency = 2) and the basis is 0. How high is the yield?" msgstr "証券を 1999 年 02 月 15 日に購入し、満期日は 2007 年 11 月 15 日です。利率は 5.75% です。取得価額は、額面 100 単位あたり 95.04287 通貨単位で、償還価値は 100 単位です。利息は半年に一度支払われ (年間の利息支払回数は 2 回)、基準は 0 です。利回りを求めます。" -#. UfrLb +#. iewbU #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154194\n" "help.text" -msgid "=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0) returns 0.065 or 6.50 per cent." -msgstr "=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0) は、0.065、つまり 6.50 パーセントを返します。" +msgid "<input>=YIELD(\"1999-02-15\"; \"2007-11-15\"; 0.0575 ;95.04287; 100; 2; 0)</input> returns 0.065 or 6.50 per cent." +msgstr "" #. AeJmf #: 04060119.xhp @@ -31966,14 +31759,14 @@ msgctxt "" msgid "A non-interest-bearing security is purchased on 1999-02-15. It matures on 1999-03-01. The price is 99.795 currency units per 100 units of par value, the redemption value is 100 units. The basis is 2. How high is the yield?" msgstr "割引債を 1999 年 2 月 15 日に購入しました。満期日は 1999 年 3 月 1 日です。取得価額は、額面 100 単位あたり 99.795 通貨単位で、償還価値は 100 単位です。基準は 2 です。利回りを求めます。" -#. 7YN9G +#. DMev8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155187\n" "help.text" -msgid "=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2) returns 0.052823 or 5.2823 per cent." -msgstr "=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2) は、0.052823、つまり 5.2823 パーセントを返します。" +msgid "<input>=YIELDDISC(\"1999-02-15\"; \"1999-03-01\"; 99.795; 100; 2)</input> returns 0.052823 or 5.2823 per cent." +msgstr "" #. 5mbhE #: 04060119.xhp @@ -32065,14 +31858,14 @@ msgctxt "" msgid "A security is purchased on 1999-03-15. It matures on 1999-11-03. The issue date was 1998-11-08. The rate of interest is 6.25%, the price is 100.0123 units. The basis is 0. How high is the yield?" msgstr "証券を 1999 年 3 月 15 日に購入しました。満期日は 1999 年 11 月 3 日です。発行日は 1998 年 11 月 8 日です。利率は 6.25% で、取得価額は 100.0123 単位です。基準は 0 です。利回りを求めます。" -#. EgFWh +#. DswXC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3155311\n" "help.text" -msgid "=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0) returns 0.060954 or 6.0954 per cent." -msgstr "=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0) は、0.060954、つまり 6.0954 パーセントを返します。" +msgid "<input>=YIELDMAT(\"1999-03-15\"; \"1999-11-03\"; \"1998-11-08\"; 0.0625; 100.0123; 0)</input> returns 0.060954 or 6.0954 per cent." +msgstr "" #. 2ZC4E #: 04060119.xhp @@ -32254,14 +32047,14 @@ msgctxt "" msgid "The return on the treasury bill corresponding to a security is worked out as follows:" msgstr "計算は次のようになります。:" -#. PGMJB +#. QzDeZ #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154382\n" "help.text" -msgid "=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914) returns 0.094151 or 9.4151 per cent." -msgstr "=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914) は、0.094151、つまり 9.4151 パーセントを返します。" +msgid "<input>=TBILLEQ(\"1999-03-31\";\"1999-06-01\"; 0.0914)</input> returns 0.094151 or 9.4151 per cent." +msgstr "" #. zcFRa #: 04060119.xhp @@ -32344,14 +32137,14 @@ msgctxt "" msgid "The price of the treasury bill is worked out as follows:" msgstr "証券の価格計算は次のようになります:" -#. 2oCRv +#. VfuXC #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3154592\n" "help.text" -msgid "=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09) returns 98.45." -msgstr "=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09) は、98.45 を返します。" +msgid "<input>=TBILLPRICE(\"1999-03-31\";\"1999-06-01\"; 0.09)</input> returns 98.45." +msgstr "" #. yEHpt #: 04060119.xhp @@ -32434,14 +32227,14 @@ msgctxt "" msgid "The yield of the treasury bill is worked out as follows:" msgstr "証券の利回り計算は次のようになります:" -#. vwDmA +#. CrxD8 #: 04060119.xhp msgctxt "" "04060119.xhp\n" "par_id3148528\n" "help.text" -msgid "=TBILLYIELD(\"1999-03-31\";\"1999-06-01\"; 98.45) returns 0.091417 or 9.1417 per cent." -msgstr "=TBILLYIELD(\"1999-03-31\";\"1999-06-01\"; 98.45) は、0.091417、つまり 9.1417 パーセントを返します。" +msgid "<input>=TBILLYIELD(\"1999-03-31\";\"1999-06-01\"; 98.45)</input> returns 0.091417 or 9.1417 per cent." +msgstr "" #. NF5nu #: 04060119.xhp @@ -44350,14 +44143,14 @@ msgctxt "" msgid "Insert Function into calculation sheet" msgstr "シートに関数を挿入" -#. 7J4VW +#. UPFoX #: 04080000.xhp msgctxt "" "04080000.xhp\n" "par_id3150043\n" "help.text" -msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\"><alt id=\"alt_id3159267\">Icon</alt></image>" -msgstr "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3155754\">アイコン</alt></image>" +msgid "<image id=\"img_id3159267\" src=\"sc/res/fx.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3159267\">Icon Insert Function</alt></image>" +msgstr "" #. 4Hfgb #: 04080000.xhp @@ -46177,14 +45970,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Displays the list of the available Cell Styles for <link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"indirect cell formatting\">indirect cell formatting</link>.</ahelp>" msgstr "<ahelp hid=\".uno:ParaStyle\"><link href=\"text/shared/00/00000005.xhp#formatierung\" name=\"セルの間接書式設定\">セルの間接書式設定</link>に使用できるセルスタイルのリストが表示されます。</ahelp>" -#. vDDA3 +#. JcMEc #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3150751\n" "help.text" -msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\"><alt id=\"alt_id3153714\">Icon</alt></image>" -msgstr "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3155754\">アイコン</alt></image>" +msgid "<image id=\"img_id3153714\" src=\"sc/res/sf01.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153714\">Icon Cell Styles</alt></image>" +msgstr "" #. HKD2C #: 05100000.xhp @@ -46213,14 +46006,14 @@ msgctxt "" msgid "<ahelp hid=\".\">Displays the Page Styles available for indirect page formatting.</ahelp>" msgstr "<ahelp hid=\".uno:PageStyle\">ページの間接書式設定に使用できるページスタイルが表示されます。</ahelp>" -#. oCa5C +#. cM9f4 #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3159100\n" "help.text" -msgid "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\"><alt id=\"alt_id3149814\">Icon</alt></image>" -msgstr "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\"><alt id=\"alt_id3149814\">アイコン</alt></image>" +msgid "<image id=\"img_id3149814\" src=\"sw/res/sf04.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3149814\">Icon Page Styles</alt></image>" +msgstr "" #. BnFvb #: 05100000.xhp @@ -46249,14 +46042,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_WATERCAN\">Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles window.</ahelp>" msgstr "" -#. JM3as +#. ChsD7 #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3155087\n" "help.text" -msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\"><alt id=\"alt_id3153068\">Icon</alt></image>" -msgstr "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\"><alt id=\"alt_id3153068\">アイコン</alt></image>" +msgid "<image id=\"img_id3153068\" src=\"cmd/sc_fillstyle.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3153068\">Icon Fill Format Mode</alt></image>" +msgstr "" #. TEEFF #: 05100000.xhp @@ -46330,14 +46123,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_NEWBYEXAMPLE\">Creates a new style based on the formatting of a selected object.</ahelp> Assign a name for the style in the <link href=\"text/shared/01/05140100.xhp\" name=\"Create Style\">Create Style</link> dialog." msgstr "" -#. AGMAe +#. T967y #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3150050\n" "help.text" -msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\"><alt id=\"alt_id3154649\">Icon</alt></image>" -msgstr "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3155754\">アイコン</alt></image>" +msgid "<image id=\"img_id3154649\" src=\"cmd/sc_stylenewbyexample.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3154649\">Icon New Style from Selection</alt></image>" +msgstr "" #. aE4gp #: 05100000.xhp @@ -46366,14 +46159,14 @@ msgctxt "" msgid "<ahelp hid=\"SFX2_HID_TEMPLDLG_UPDATEBYEXAMPLE\">Updates the Style selected in the Styles window with the current formatting of the selected object.</ahelp>" msgstr "" -#. 5cyG3 +#. F3Lph #: 05100000.xhp msgctxt "" "05100000.xhp\n" "par_id3145118\n" "help.text" -msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\"><alt id=\"alt_id3155754\">Icon</alt></image>" -msgstr "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"0.1665in\" height=\"0.1665in\"><alt id=\"alt_id3155754\">アイコン</alt></image>" +msgid "<image id=\"img_id3155754\" src=\"cmd/sc_styleupdatebyexample.png\" width=\"1cm\" height=\"1cm\"><alt id=\"alt_id3155754\">Icon Update Style</alt></image>" +msgstr "" #. AbPzG #: 05100000.xhp @@ -51190,14 +50983,14 @@ msgctxt "" msgid "Select Source" msgstr "ソースの選択" -#. 9ePQP +#. tbA55 #: 12090100.xhp msgctxt "" "12090100.xhp\n" "hd_id3153663\n" "help.text" -msgid "Select Source" -msgstr "ソースの選択" +msgid "<link href=\"text/scalc/01/12090100.xhp\" name=\"Pivot Table - Select Source\">Pivot Table - Select Source</link>" +msgstr "" #. JCesq #: 12090100.xhp @@ -58741,15 +58534,6 @@ msgctxt "" msgid "<item type=\"input\">=HOUR(C4)</item> returns 17 if the contents of C4 = <item type=\"input\">17:20:00</item>." msgstr "C4 の内容が <item type=\"input\">17:20:00</item> の場合、<item type=\"input\">=HOUR(C4)</item> は 17 を返します。" -#. aYfHQ -#: func_hour.xhp -msgctxt "" -"func_hour.xhp\n" -"par_id3154188\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060102.xhp\" name=\"YEAR\">YEAR</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"NOW\">NOW</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MINUTE\">MINUTE</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"MONTH\">MONTH</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"DAY\">DAY</link>, <link href=\"text/scalc/01/04060102.xhp\" name=\"WEEKDAY\">WEEKDAY</link>." -msgstr "<link href=\"text/scalc/01/04060102.xhp\" name=\"YEAR\">YEAR</link>、<link href=\"text/scalc/01/04060102.xhp\" name=\"NOW\">NOW</link>、<link href=\"text/scalc/01/04060102.xhp\" name=\"MINUTE\">MINUTE</link>、<link href=\"text/scalc/01/04060102.xhp\" name=\"MONTH\">MONTH</link>、<link href=\"text/scalc/01/04060102.xhp\" name=\"DAY\">DAY</link>、<link href=\"text/scalc/01/04060102.xhp\" name=\"WEEKDAY\">WEEKDAY</link>。" - #. DiCWs #: func_ifs.xhp msgctxt "" @@ -59020,6 +58804,15 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imcosh_des\">Returns the hyperbolic cosine of a complex number.</variable> The hyperbolic cosine of a complex number can be expressed by:</ahelp>" msgstr "" +#. cawEM +#: func_imcosh.xhp +msgctxt "" +"func_imcosh.xhp\n" +"par_id24939266285933\n" +"help.text" +msgid "<image src=\"media/helpimg/sc_func_imcosh.svg\" id=\"img_id211575078735993\" width=\"464.56109px\" height=\"31.5px\"><alt id=\"alt_id401575078735994\">IMCOSH equation</alt></image>" +msgstr "" + #. neXB8 #: func_imcosh.xhp msgctxt "" @@ -59092,13 +58885,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imcot_des\">Returns the cotangent of a complex number.</variable> The cotangent of a complex number can be expressed by:</ahelp>" msgstr "" -#. ofv76 +#. cdma2 #: func_imcot.xhp msgctxt "" "func_imcot.xhp\n" "par_id311713256011430\n" "help.text" -msgid "<image id=\"img_id5988220084990\" src=\"media/helpimg/sc_func_imcot.png\"><alt id=\"alt_id5988220084990\">cot(a+bi)=cos(a+bi)/sin(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imcot.svg\" id=\"img_id211575078735993\" width=\"258.56943px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>" msgstr "" #. z7EtV @@ -59173,13 +58966,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imcsc_des\">Returns the cosecant of a complex number. </variable> The cosecant of a complex number can be expressed by:</ahelp>" msgstr "" -#. Jd8pB +#. 9P8Xq #: func_imcsc.xhp msgctxt "" "func_imcsc.xhp\n" "par_id13510198901485\n" "help.text" -msgid "<image id=\"img_id24404683532568\" src=\"media/helpimg/sc_func_imcsc.png\"><alt id=\"alt_id148492012231637\">csc(a+bi)=1/sin(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imcsc.svg\" id=\"img_id211575078735993\" width=\"594.60278px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>" msgstr "" #. jBzZA @@ -59254,13 +59047,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imcsch_des\">Returns the hyperbolic cosecant of a complex number.</variable> The hyperbolic cosecant of a complex number can be expressed by:</ahelp>" msgstr "" -#. PPDq3 +#. VWFPK #: func_imcsch.xhp msgctxt "" "func_imcsch.xhp\n" "par_id195151657917534\n" "help.text" -msgid "<image id=\"img_id23513691929169\" src=\"media/helpimg/sc_func_imcsch.png\"><alt id=\"alt_id313882186926700\">csch(a+bi)=1/sinh(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imcsch.svg\" id=\"img_id211575078735993\" width=\"619.60278px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>" msgstr "" #. ndjhY @@ -59335,13 +59128,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imsec_des\">Returns the secant of a complex number. </variable> The secant of a complex number can be expressed by:</ahelp>" msgstr "" -#. oFCsQ +#. gbjYF #: func_imsec.xhp msgctxt "" "func_imsec.xhp\n" "par_id17543461310594\n" "help.text" -msgid "<image id=\"img_id112671346811327\" src=\"media/helpimg/sc_func_imsec.png\"><alt id=\"alt_id303562937523579\">sec(a+bi)=1/cos(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imsec.svg\" id=\"img_id211575078735993\" width=\"599.10275px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>" msgstr "" #. CEucF @@ -59416,13 +59209,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imsech_des\">Returns the hyperbolic secant of a complex number. </variable> The hyperbolic secant of a complex number can be expressed by:</ahelp>" msgstr "" -#. kCU6F +#. ymrxb #: func_imsech.xhp msgctxt "" "func_imsech.xhp\n" "par_id74572850718840\n" "help.text" -msgid "<image id=\"img_id8983315386682\" src=\"media/helpimg/sc_func_imsech.png\"><alt id=\"alt_id9157586510683\">sech(a+bi)=1/cosh(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imsech.svg\" id=\"img_id211575078735993\" width=\"624.10275px\" height=\"54.962498px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>" msgstr "" #. Rqker @@ -59497,13 +59290,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imsin_des\">Returns the sine of a complex number. </variable> The sine of a complex number can be expressed by:</ahelp>" msgstr "" -#. ZXSse +#. 5FyPJ #: func_imsin.xhp msgctxt "" "func_imsin.xhp\n" "par_id3189460120934\n" "help.text" -msgid "sin(a+bi)=sin(a)cosh(b)+cos(a)sinh(b)i" +msgid "<image src=\"media/helpimg/sc_func_imsin.svg\" id=\"img_id211575078735993\" width=\"447.2611px\" height=\"31.5px\"><alt id=\"alt_id401575078735994\">IMSIN equation</alt></image>" msgstr "" #. tcmGA @@ -59578,13 +59371,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imsinh_des\">Returns the hyperbolic sine of a complex number.</variable> The hyperbolic sine of a complex number can be expressed by:</ahelp>" msgstr "" -#. eAYir +#. ZDbJS #: func_imsinh.xhp msgctxt "" "func_imsinh.xhp\n" "par_id3189460120934\n" "help.text" -msgid "sinh(a+bi)=sinh(a)cos(b)+cosh(a)sin(b)i" +msgid "<image src=\"media/helpimg/sc_func_imsinh.svg\" id=\"img_id211575078735993\" width=\"459.7611px\" height=\"31.5px\"><alt id=\"alt_id401575078735994\">IMSINH equation</alt></image>" msgstr "" #. CM4Gy @@ -59659,13 +59452,13 @@ msgctxt "" msgid "<ahelp hid=\".\"><variable id=\"imtan_des\">Returns the tangent of a complex number.</variable> The tangent of a complex number can be expressed by:</ahelp>" msgstr "" -#. CNTVt +#. mdUUP #: func_imtan.xhp msgctxt "" "func_imtan.xhp\n" "par_id25021317131239\n" "help.text" -msgid "<image id=\"img_id16283275473700\" src=\"media/helpimg/sc_func_imtan.png\"><alt id=\"alt_id676711494402\">tan(a+bi)=sin(a+bi)/cos(a+bi)</alt></image>" +msgid "<image src=\"media/helpimg/sc_func_imtan.svg\" id=\"img_id211575078735993\" width=\"597.80275px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>" msgstr "" #. 7QtEG @@ -60424,15 +60217,6 @@ msgctxt "" msgid "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days." msgstr "" -#. EVv5k -#: func_networkdays.intl.xhp -msgctxt "" -"func_networkdays.intl.xhp\n" -"par_id23102016225717242\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060102.xhp\">Date functions</link>" -msgstr "" - #. winzV #: func_networkdays.xhp msgctxt "" @@ -60442,14 +60226,14 @@ msgctxt "" msgid "NETWORKDAYS" msgstr "NETWORKDAYS" -#. 7srBV +#. v4yGQ #: func_networkdays.xhp msgctxt "" "func_networkdays.xhp\n" "bm_id3151254\n" "help.text" -msgid "<bookmark_value>NETWORKDAYS function</bookmark_value>" -msgstr "<bookmark_value>NETWORKDAYS 関数</bookmark_value>" +msgid "<bookmark_value>NETWORKDAYS function</bookmark_value> <bookmark_value>NETWORKDAYS_EXCEL2003 function</bookmark_value>" +msgstr "" #. HzF8v #: func_networkdays.xhp @@ -60550,15 +60334,6 @@ msgctxt "" msgid "<item type=\"input\">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays." msgstr "" -#. MpfGY -#: func_networkdays.xhp -msgctxt "" -"func_networkdays.xhp\n" -"par_id23102016225717242\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060102.xhp\">Date functions</link>" -msgstr "" - #. HCN8H #: func_now.xhp msgctxt "" @@ -60712,6 +60487,591 @@ msgctxt "" msgid "<item type=\"input\">=NUMBERVALUE(\"123.456\";\".\";\",\")</item> yields 123.456" msgstr "" +#. EJhfD +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_BARRIER" +msgstr "" + +#. 4HRGX +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"bm_id511575065323638\n" +"help.text" +msgid "<bookmark_value>OPT_BARRIER function</bookmark_value>" +msgstr "" + +#. KrCYn +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"hd_id241575063871994\n" +"help.text" +msgid "<variable id=\"optbrarrierh1\"><link href=\"text/scalc/01/func_opt_barrier.xhp\" name=\"OPT_BARRIER\">OPT_BARRIER</link></variable>" +msgstr "" + +#. uFKBs +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id121575063871995\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the pricing for a barrier option, calculated using the Black-Scholes option pricing model.</ahelp></variable>" +msgstr "" + +#. FxbGq +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id371575067051846\n" +"help.text" +msgid "OPT_BARRIER(Spot; Volatility; Rate; Foreign Rate; Maturity; Strike; LowerBarrier; UpperBarrier; Rebate; PutCall; InOut; BarrierMonitoring; Greek)" +msgstr "" + +#. XEMff +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id681575073426941\n" +"help.text" +msgid "<emph>Strike</emph> is the strike price of the option and should be non-negative." +msgstr "" + +#. 8tgWG +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id671575073495724\n" +"help.text" +msgid "<emph>Rebate</emph> is the amount of money to be paid at maturity if the barrier is hit." +msgstr "" + +#. uAzky +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id691575073511191\n" +"help.text" +msgid "<variable id=\"optputcall\"><emph>Put or Call</emph> is a string that defines whether the option is a put (“p”) or a call (“c”).</variable>" +msgstr "" + +#. PdCJb +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id651575073773761\n" +"help.text" +msgid "<input>=OPT_BARRIER(30;0.2;0.06;0;1;40;25;0;0;\"c\";\"o\";\"c\")</input> returns the value 0.4243." +msgstr "" + +#. ABVQH +#: func_opt_barrier.xhp +msgctxt "" +"func_opt_barrier.xhp\n" +"par_id401575073777593\n" +"help.text" +msgid "<input>=OPT_BARRIER(50;0.4;0.05;0;0.5;65;0;80;0;\"p\";\"o\";\"c\";\"e\")</input> returns the value 10.1585." +msgstr "" + +#. HWhRY +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_PROB_HIT" +msgstr "" + +#. 5Naq2 +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"bm_id961575074485125\n" +"help.text" +msgid "<bookmark_value>OPT_PROB_HIT function</bookmark_value>" +msgstr "" + +#. jn8fF +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"hd_id71575063908363\n" +"help.text" +msgid "<variable id=\"optprobhith1\"><link href=\"text/scalc/01/func_opt_prob_hit.xhp\" name=\"OPT_PROB_HIT\">OPT_PROB_HIT</link></variable>" +msgstr "" + +#. fWecm +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id591575063908364\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the probability that an asset hits a predetermined barrier price, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows." +msgstr "" + +#. ZJBj2 +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id21575078735992\n" +"help.text" +msgid "<image src=\"media/helpimg/sc_func_opt01.svg\" id=\"img_id211575078735993\" width=\"197.38334px\" height=\"51.2125px\"><alt id=\"alt_id401575078735994\">OPT_PROB_HIT equation</alt></image>" +msgstr "" + +#. FnaCP +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id821575074114118\n" +"help.text" +msgid "<literal>µ</literal> is the asset’s percentage drift, <literal>vol</literal> is the percentage volatility of the stock, and <literal>dW</literal> is a random sample drawn from a normal distribution with a zero mean. <literal>W</literal> is a Wiener process or Brownian motion." +msgstr "" + +#. 9NRxu +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id211575074192954\n" +"help.text" +msgid "OPT_PROB_HIT(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier)" +msgstr "" + +#. XaA8K +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id901575074339820\n" +"help.text" +msgid "<variable id=\"optdrift\"><emph>Drift</emph> is the annual stock price percentage drift rate (µ in the above formula). The value is expressed as a decimal (for example, enter 15% as 0.15).</variable>" +msgstr "" + +#. 6yrWk +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id681575073426941\n" +"help.text" +msgid "<variable id=\"optstrike\"><emph>Strike</emph> is the strike price of the option and should be non-negative.</variable>" +msgstr "" + +#. mHW3F +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id971575074431070\n" +"help.text" +msgid "<input>=OPT_PROB_HIT(30;0.2;0.3;1;0;40)</input> returns the value 0.6119." +msgstr "" + +#. 3EshE +#: func_opt_prob_hit.xhp +msgctxt "" +"func_opt_prob_hit.xhp\n" +"par_id171575074434932\n" +"help.text" +msgid "<input>=OPT_PROB_HIT(70;0.3;0.1;0.5;60;0)</input> returns the value 0.4239." +msgstr "" + +#. RFprF +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"tit\n" +"help.text" +msgid "Function OPT_PROB_INMONEY" +msgstr "" + +#. QQBrZ +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"bm_id961575065633373\n" +"help.text" +msgid "<bookmark_value>OPT_PROB_INMONEY function</bookmark_value>" +msgstr "" + +#. kMBbw +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"hd_id941575063929082\n" +"help.text" +msgid "<variable id=\"optprobinmoneyh1\"><link href=\"text/scalc/01/func_opt_prob_inmoney.xhp\" name=\"OPT_PROB_INMONEY\">OPT_PROB_INMONEY</link></variable>" +msgstr "" + +#. QDryb +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id941575063929083\n" +"help.text" +msgid "<variable id=\"variable name\"><ahelp hid=\".\">Returns the probability that an asset will end up between two barrier levels at maturity, assuming that the stock price can be modeled as a process S that follows the stochastic differential equation</ahelp></variable>, as follows." +msgstr "" + +#. 2GJsA +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id21575078735992\n" +"help.text" +msgid "<image src=\"media/helpimg/sc_func_opt01.svg\" id=\"img_id211575078735993\" width=\"197.38334px\" height=\"51.2125px\"><alt id=\"alt_id401575078735994\">OPT_PROB_INMONEY equation</alt></image>" +msgstr "" + +#. 7ja6D +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id941575074893788\n" +"help.text" +msgid "<literal>µ</literal> is the asset’s percentage drift, <literal>vol</literal> is the percentage volatility of the stock, and <literal>dW</literal> is a random sample drawn from a normal distribution with a zero mean. <literal>W</literal> is a Wiener process or Brownian motion." +msgstr "" + +#. pMCin +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id241575075282150\n" +"help.text" +msgid "If the optional <emph>Strike</emph> and <emph>PutCall</emph> arguments are included, then" +msgstr "" + +#. vxxYT +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id931575075314553\n" +"help.text" +msgid "For a call option, the function returns the probability that the asset will end up between <emph>Strike</emph> and <emph>UpperBarrier</emph>." +msgstr "" + +#. UrAPw +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id531575075321659\n" +"help.text" +msgid "For a put option, the function returns the probability that the asset will end up between <emph>LowerBarrier</emph> and <emph>Strike</emph>." +msgstr "" + +#. 9VazP +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id191575075304900\n" +"help.text" +msgid "The function ignores the possibility of knock-out before maturity." +msgstr "" + +#. XTh5Y +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id761575075027094\n" +"help.text" +msgid "OPT_PROB_INMONEY(Spot; Volatility; Drift; Maturity; LowerBarrier; UpperBarrier; Strike; PutCall)" +msgstr "" + +#. mE6CG +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id601575074993334\n" +"help.text" +msgid "<input>=OPT_PROB_INMONEY(30;0.2;0.1;1;0;50)</input> returns the value 0.9844." +msgstr "" + +#. K7AED +#: func_opt_prob_inmoney.xhp +msgctxt "" +"func_opt_prob_inmoney.xhp\n" +"par_id261575074997216\n" +"help.text" +msgid "<input>=OPT_PROB_INMONEY(70;0.3;0.15;1;60;0;80;\"p\")</input> returns the value 0.3440." +msgstr "" + +#. muQEH +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"tit\n" +"help.text" +msgid "OPT_TOUCH" +msgstr "" + +#. r3Awi +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"bm_id951575065400504\n" +"help.text" +msgid "<bookmark_value>OPT_TOUCH function</bookmark_value>" +msgstr "" + +#. DBPBG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"hd_id41575062825964\n" +"help.text" +msgid "<variable id=\"opttouchh1\"><link href=\"text/scalc/01/func_opt_touch.xhp\" name=\"function_opt_touch\">OPT_TOUCH</link></variable>" +msgstr "" + +#. HwW6c +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id531575062825965\n" +"help.text" +msgid "<ahelp hid=\".\">Returns the pricing of a touch / no-touch option, calculated using the Black-Scholes option pricing model.</ahelp>" +msgstr "" + +#. DE8qf +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id371575066515276\n" +"help.text" +msgid "For relevant background information, visit the <link href=\"https://en.wikipedia.org/wiki/Option_(finance)\" name=\"optionfinance\">Options (finance)</link> and <link href=\"https://en.wikipedia.org/wiki/Black–Scholes_model\" name=\"blackscholes\">Black-Scholes</link> model Wikipedia pages." +msgstr "" + +#. 29Wsy +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id571575080642652\n" +"help.text" +msgid "Further information about touch / no-touch options may be found on many financial websites." +msgstr "" + +#. pyway +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id151575063296819\n" +"help.text" +msgid "OPT_TOUCH(Spot; Volatility; Rate; ForeignRate; Maturity; LowerBarrier; UpperBarrier; ForeignDomestic; InOut; BarrierMonitoring; Greek)" +msgstr "" + +#. 6rD5u +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id321575066304659\n" +"help.text" +msgid "<variable id=\"optspot\"><emph>Spot</emph> is the price / value of the underlying asset and should be greater than 0.0.</variable>" +msgstr "" + +#. CoALG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id31575066315078\n" +"help.text" +msgid "<variable id=\"optvolat\"><emph>Volatility</emph> is the annual percentage volatility of the underlying asset expressed as a decimal (for example, enter 30% as 0.3). The value should be greater than 0.0.</variable>" +msgstr "" + +#. iCEkw +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id681575066324254\n" +"help.text" +msgid "<variable id=\"optrate\"><emph>Rate</emph> is the continuously compounded interest rate. This is a percentage expressed as a decimal (for example, enter 40% as 0.4).</variable>" +msgstr "" + +#. eoG8E +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id71575066333773\n" +"help.text" +msgid "<variable id=\"optfrate\"><emph>ForeignRate</emph> is the continuously compounded foreign interest rate. This is a percentage expressed as a decimal (for example, enter 50% as 0.5).</variable>" +msgstr "" + +#. hzfJp +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id21575066338734\n" +"help.text" +msgid "<variable id=\"optmaturity\"><emph>Maturity</emph> is the time to maturity of the option, in years, and should be non-negative.</variable>" +msgstr "" + +#. Gksbz +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id671575066343182\n" +"help.text" +msgid "<variable id=\"optlowbar\"><emph>LowerBarrier</emph> is the predetermined lower barrier price; set to zero for no lower barrier.</variable>" +msgstr "" + +#. KDTDW +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id301575066347357\n" +"help.text" +msgid "<variable id=\"optupbar\"><emph>UpperBarrier</emph> is the predetermined upper barrier price; set to zero for no upper barrier.</variable>" +msgstr "" + +#. oVmg7 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id561575066355924\n" +"help.text" +msgid "<variable id=\"optdomestic\"><emph>ForeignDomestic</emph> is a string that defines whether the option pays domestic (“d”) or foreign (“f”) currency.</variable>" +msgstr "" + +#. zTRA2 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id251575066360596\n" +"help.text" +msgid "<variable id=\"optinout\"><emph>InOut</emph> is a string that defines whether the option is knock-in (“i”) or knock-out (“o”).</variable>" +msgstr "" + +#. AsXAj +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id861575066366861\n" +"help.text" +msgid "<variable id=\"optbarmon\"><emph>BarrierMonitoring</emph> is a string that defines whether the barrier is monitored continuously (“c”) or only at the end / maturity (“e”).</variable>" +msgstr "" + +#. xyF8R +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id721575066374340\n" +"help.text" +msgid "<emph>Greek</emph> (optional) is a string argument. If omitted or set to “value”, “v”, “price”, or “p”, then the function simply returns the option price. If another valid string is entered, the function returns price sensitivities (Greeks) to one of the input parameters. The valid options in this case are as follows." +msgstr "" + +#. NhW28 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id951575063536153\n" +"help.text" +msgid "“delta” or “d”." +msgstr "" + +#. DVKPe +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id361575063554232\n" +"help.text" +msgid "“gamma” or “g”." +msgstr "" + +#. mY7eD +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id961575063563017\n" +"help.text" +msgid "“theta” or “t”." +msgstr "" + +#. 7BNpN +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id971575063570632\n" +"help.text" +msgid "“vega” or “e”." +msgstr "" + +#. F4AQk +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id631575063580705\n" +"help.text" +msgid "“volga” or “o”." +msgstr "" + +#. DcBfK +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id981575063594505\n" +"help.text" +msgid "“vanna” or “a”." +msgstr "" + +#. vjCq4 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id191575063598656\n" +"help.text" +msgid "“rho” or “r”." +msgstr "" + +#. NGCqj +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id751575063602288\n" +"help.text" +msgid "“rhof” or “f”." +msgstr "" + +#. U7QqM +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id181575063666675\n" +"help.text" +msgid "<input>=OPT_TOUCH(50;0.25;0.05;0;1;0;55;\"d\";\"i\";\"c\")</input> returns the value 0.6876." +msgstr "" + +#. 8JFD4 +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id811575063677250\n" +"help.text" +msgid "<input>=OPT_TOUCH(80;0.2;0.05;0;0.5;60;0;\"f\";\"o\";\"c\";\"r\")</input> returns the value 15.5516." +msgstr "" + +#. ychjG +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id121575125779535\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060103.xhp\">Financial Functions Part One</link>" +msgstr "" + +#. aX7LC +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id251575125873714\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060119.xhp\">Financial Functions Part Two</link>" +msgstr "" + +#. Q7SFh +#: func_opt_touch.xhp +msgctxt "" +"func_opt_touch.xhp\n" +"par_id191575125878595\n" +"help.text" +msgid "<link href=\"text/scalc/01/04060118.xhp\">Financial Functions Part Three</link>" +msgstr "" + #. zr5G3 #: func_rawsubtract.xhp msgctxt "" @@ -63205,15 +63565,6 @@ msgctxt "" msgid "<item type=\"input\">=WORKDAY.INTL(C3;D3)</item> gives the result: January 10, 2017." msgstr "" -#. 4CAcU -#: func_workday.intl.xhp -msgctxt "" -"func_workday.intl.xhp\n" -"par_id23102016225717242\n" -"help.text" -msgid "<link href=\"text/scalc/01/04060102.xhp\">Date functions</link>" -msgstr "" - #. 5dvmu #: func_workday.xhp msgctxt "" @@ -63340,14 +63691,14 @@ msgctxt "" msgid "<variable id=\"year\"><link href=\"text/scalc/01/func_year.xhp\">YEAR</link></variable>" msgstr "<variable id=\"year\"><link href=\"text/scalc/01/func_year.xhp\">YEAR</link></variable>" -#. nEAhg +#. jfsgr #: func_year.xhp msgctxt "" "func_year.xhp\n" "par_id3147496\n" "help.text" -msgid "<ahelp hid=\"HID_FUNC_JAHR\">Returns the year as a number according to the internal calculation rules.</ahelp>" -msgstr "<ahelp hid=\"HID_FUNC_JAHR\">内部計算規則に従い、年を数字として返します。</ahelp>" +msgid "<ahelp hid=\"HID_FUNC_JAHR\">Returns the year as a number according to the <link href=\"text/scalc/01/04060102.xhp#datebase\" name=\"date calculation rules\">internal calculation rules</link>.</ahelp>" +msgstr "" #. 3SfLe #: func_year.xhp @@ -63394,6 +63745,15 @@ msgctxt "" msgid "<item type=\"input\">=YEAR(33333.33)</item> returns 1991" msgstr "<item type=\"input\">=YEAR(33333.33)</item> は、1991 を返します。" +#. YXa5g +#: func_year.xhp +msgctxt "" +"func_year.xhp\n" +"par_id141577548861101\n" +"help.text" +msgid "<input>=YEAR(DATEVALUE('2010-09-28'))</input> returns 2010." +msgstr "" + #. kAjPe #: func_yearfrac.xhp msgctxt "" |