User: pjanik Date: 05/10/20 11:22:27 Modified: /cs/po/helpcontent2/source/text/scalc/ 01.po
Log: *** empty log message *** File Changes: Directory: /cs/po/helpcontent2/source/text/scalc/ ================================================= File [changed]: 01.po Url: http://cs.openoffice.org/source/browse/cs/po/helpcontent2/source/text/scalc/01.po?r1=1.214&r2=1.215 Delta lines: +57 -20 --------------------- --- 01.po 19 Oct 2005 22:31:47 -0000 1.214 +++ 01.po 20 Oct 2005 18:22:22 -0000 1.215 @@ -1963,8 +1963,12 @@ msgstr "DCOUNTA(Databáze;Pole databáze;Kritéria vyhledávánÃ)" #: 04060101.xhp#par_id3153982.102.help.text -msgid "In the example above (scroll up, please), you can search for the number of children whose name starts with an E or a subsequent letter. Edit the formula in B16 to read =DCOUNTA(A1:E10;0;A13:E14). Delete the old search criteria and enter >=E under \\<emph\\>Name\\</emph\\> in field A14. The result is 5. If you now delete all number values for Greta in row 8, the result changes to 4. Row 8 is no longer included in the count because it does not contain any values. The name Greta is text, not a value." -msgstr "Ve výše uvedeném pÅÃkladu zjiÅ¡Å¥ujeme poÄet dÄtÃ, jejichž jméno zaÄÃná pÃsmenem E nebo následujÃcÃmi. Upravte vzorec v buÅce B16 a vložte A za funkci DCOUNT. OdstraÅte staré kritérium vyhledávánà a do buÅky A14 pod položku \\<emph\\>Název\\</emph\\> vložte >=E . Výsledek je 5. Pokud nynà odstranÃte z Åádku 8 vÅ¡echny ÄÃselné hodnoty pro Gretu, výsledek se zmÄnà na 4. Åádek 8 již dále nenà zahrnut do výpoÄtu, protože neobsahuje žádné hodnoty. Jméno Greta je text, ne hodnota." +msgid "" +"In the example above (scroll up, please), you can search for the number of children whose name starts with an E or a subsequent letter. Edit the formula in B16 to read =DCOUNTA(A1:E10;0;A13:E14). Delete the old search criteria and enter >=E under \\<emph\\>Name\\</emph\\> in field A14. The result is 5. If you now delete all number values for Greta in row 8, the result changes to 4. Row 8 is no " +"longer included in the count because it does not contain any values. The name Greta is text, not a value." +msgstr "" +"Ve výše uvedeném pÅÃkladu zjiÅ¡Å¥ujeme poÄet dÄtÃ, jejichž jméno zaÄÃná pÃsmenem E nebo následujÃcÃmi. Upravte vzorec v buÅce B16 a vložte A za funkci DCOUNT. OdstraÅte staré kritérium vyhledávánà a do buÅky A14 pod položku \\<emph\\>Název\\</emph\\> vložte >=E . Výsledek je 5. Pokud nynà odstranÃte z Åádku 8 vÅ¡echny ÄÃselné hodnoty pro Gretu, výsledek se zmÄnà na 4. Åádek 8 již dále nenà zahrnut " +"do výpoÄtu, protože neobsahuje žádné hodnoty. Jméno Greta je text, ne hodnota." #: 04060101.xhp#bm_id3147256.help.text msgid "\\<bookmark_value\\>DGET function\\</bookmark_value\\>" @@ -6262,20 +6266,20 @@ msgstr "FREQUENCY" #: 04060107.xhp#par_id3145777.23.help.text -msgid "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Indicates the frequency distribution in a one-column-array.\\</ahelp\\> The default value supply and the number of intervals or classes are used to count how many values are omitted on the single intervals." -msgstr "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Ukazuje rozdÄlenà Äetnostà hodnot v jednosloupcové matici.\\</ahelp\\>" +msgid "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Indicates the frequency distribution in a one-column-array.\\</ahelp\\> The function counts the number of values in the Data array that are within the values given by the Classes array." +msgstr "" #: 04060107.xhp#par_id3155498.25.help.text msgid "FREQUENCY(Data; Classes)" msgstr "FREQUENCY(Data; TÅÃdy)" #: 04060107.xhp#par_id3154352.26.help.text -msgid "\\<emph\\>Data\\</emph\\> represents the array of or reference to the set of values to be counted." -msgstr "\\<emph\\>Data\\</emph\\> znamená rozsah bunÄk obsahujÃcÃch hodnoty, jejichž Äetnost v jednotlivých intervalech má být spoÄtena." +msgid "\\<emph\\>Data\\</emph\\> represents the reference to the values to be counted." +msgstr "" #: 04060107.xhp#par_id3148402.27.help.text -msgid "\\<emph\\>Classes\\</emph\\> represents the array of the class set." -msgstr "\\<emph\\>TÅÃdy\\</emph\\> pÅedstavujà pole definujÃcà intervaly, pro které majà být spoÄteny Äetnosti." +msgid "\\<emph\\>Classes\\</emph\\> represents the array of the limit values." +msgstr "" # #iFIXME# # ... greater than 5 or greater than or equal to 10 ... @@ -6320,11 +6324,9 @@ #: 04060107.xhp#par_id3150312.29.help.text msgid "" -"Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the measurement range for \\<emph\\>Data\\</emph\\> in (A1:A11), and then a column for \\<emph" -"\\>Classes\\</emph\\>, in which you entered the class limits (B1:B6) Select the \\<emph\\>array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the initially selected range C1:C6." +"Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the \\<emph\\>Data\\</emph\\> range in (A1:A11), and then the \\<emph\\>Classes\\</emph\\> range in " +"which you entered the class limits (B1:B6). Select the \\<emph\\>Array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the range C1:C6." msgstr "" -"Vyberte jednosloupcový rozsah bunÄk, do kterých chcete vložit Äetnosti zdrojových hodnot, spoÄtené pro jednotlivé intervaly (tÅÃdy). MusÃte vybrat o jednu buÅku vÃce, než je poÄet tÅÃd, do této buÅky bude vložena Äetnost hodnot, které pÅekraÄujà hornà limit poslednà tÅÃdy. V tomto pÅÃkladÄ vyberte buÅky C1:C6. V \\<emph\\>Průvodci funkcÃ\\</emph\\> zvolte funkci FREQUENCY. Jako \\<emph\\>Data" -"\\</emph\\> dále zadejte rozsah bunÄk obsahujÃcÃch hodnoty mÄÅenà (A1:A11) a také sloupec obsahujÃcà hornà meze zkoumaných intervalů jako \\<emph\\>TÅÃdy\\</emph\\>; tedy buÅky B1:B6. ZaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\> a klepnÄte na \\<emph\\>OK\\</emph\\>. V původnÄ oznaÄeném rozsahu bunÄk C1:C6 nynà vidÃte Äetnosti hodnot mÄÅenà v pÅÃsluÅ¡ných intervalech." #: 04060107.xhp#bm_id3151030.help.text msgid "\\<bookmark_value\\>MDETERM function\\</bookmark_value\\>" @@ -11484,8 +11486,8 @@ msgstr "NPV" #: 04060119.xhp#par_id3145308.302.help.text -msgid "\\<ahelp hid=\\\"HID_FUNC_NBW\\\"\\>Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.\\</ahelp\\>" -msgstr "\\<ahelp hid=\\\"HID_FUNC_NBW\\\"\\>Vrátà Äistou hodnotu investice na základÄ Åady pravidelných penÄžnÃch toků a pÅi stanovené diskontnà sazbÄ.\\</ahelp\\>" +msgid "\\<ahelp hid=\\\"HID_FUNC_NBW\\\"\\>Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.\\</ahelp\\>" +msgstr "" #: 04060119.xhp#par_id3153321.304.help.text msgid "NPV(RATE;Value 1;Value 2;...)" @@ -11500,12 +11502,12 @@ msgstr "Hodnota 1-30: Výdaje nebo výbÄry." #: 04060119.xhp#par_id3154800.308.help.text -msgid "What is the net present value of periodic payments in hundreds of 345, 276 and -145 currency units with a discount rate of 8.75%." -msgstr "Chcete vypoÄÃtat, jaká je Äistá souÄasná hodnota pro pravidelné platby o hodnotÄ 345, 276 a -145 mÄnových jednotek, je-li diskontnà sazba 8,75 %." +msgid "What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were payed as -40 currency units." +msgstr "" #: 04060119.xhp#par_id3143270.309.help.text -msgid "NPV(8.75%;345;276;-145) = 437.87 currency units. The net present value is therefore 437.87 currency units." -msgstr "NPV(8,75 %;345;276;-145) vrátà hodnotu 437,87 mÄnových jednotek. Äistá souÄasná hodnota je 437,87 mÄnových jednotek." +msgid "NPV(8.75%;10;20;30) = 49.43 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 9.43 currency units." +msgstr "" #: 04060119.xhp#bm_id3149484.help.text msgid "\\<bookmark_value\\>calculating;nominal interest rates\\</bookmark_value\\>\\<bookmark_value\\>nominal interest rates;calculating\\</bookmark_value\\>\\<bookmark_value\\>NOMINAL function\\</bookmark_value\\>" @@ -13489,8 +13491,16 @@ msgstr "\\<emph\\>Data\\</emph\\> je pole, ve kterém hodnotu hledáme." #: 04060185.xhp#par_id3150215.8.help.text -msgid "\\<emph\\>Type\\</emph\\> (optional) is the sequence order. = 0 means ascending, = 1 means descending." -msgstr "\\<emph\\>Typ\\</emph\\> (volitelné) urÄuje poÅadà tÅÃdÄnÃ: 0 znamená vzestupnÄ, 1 sestupnÄ." +msgid "\\<emph\\>Type\\</emph\\> (optional) is the sequence order." +msgstr "" + +#: 04060185.xhp#par_id9305398.help.text +msgid "Type = 0 means descending from the last item of the array to the first (this is the default), " +msgstr "" + +#: 04060185.xhp#par_id9996948.help.text +msgid "Type = 1 means ascending from the first item of the range to the last." +msgstr "" #: 04060185.xhp#par_id3155919.10.help.text msgid "=RANK(A10; A1:A50) returns the ranking of the value in A10 in value range A1:A50. If \\<emph\\>Value\\</emph\\> does not exist within the range an error message is displayed." @@ -19142,6 +19152,33 @@ msgid "\\<ahelp hid=\\\".\\\"\\>Switches \\<emph\\>Edit Points\\</emph\\> mode for an inserted freeform line on and off.\\</ahelp\\>" msgstr "" +#~ msgid "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Indicates the frequency distribution in a one-column-array.\\</ahelp\\> The default value supply and the number of intervals or classes are used to count how many values are omitted on the single intervals." +#~ msgstr "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Ukazuje rozdÄlenà Äetnostà hodnot v jednosloupcové matici.\\</ahelp\\>" + +#~ msgid "\\<emph\\>Data\\</emph\\> represents the array of or reference to the set of values to be counted." +#~ msgstr "\\<emph\\>Data\\</emph\\> znamená rozsah bunÄk obsahujÃcÃch hodnoty, jejichž Äetnost v jednotlivých intervalech má být spoÄtena." + +#~ msgid "\\<emph\\>Classes\\</emph\\> represents the array of the class set." +#~ msgstr "\\<emph\\>TÅÃdy\\</emph\\> pÅedstavujà pole definujÃcà intervaly, pro které majà být spoÄteny Äetnosti." + +#~ msgid "" +#~ "Select a single column range in which to enter the frequency for values that are greater than the upper class limit. You must select one field more than the class ceiling. In this example, select the range C1:C6. Call up the FREQUENCY function in the \\<emph\\>Function Wizard\\</emph\\>. Select the measurement range for \\<emph\\>Data\\</emph\\> in (A1:A11), and then a column for \\<emph" +#~ "\\>Classes\\</emph\\>, in which you entered the class limits (B1:B6) Select the \\<emph\\>array\\</emph\\> check box and click \\<emph\\>OK\\</emph\\>. You will see the frequency count in the initially selected range C1:C6." +#~ msgstr "" +#~ "Vyberte jednosloupcový rozsah bunÄk, do kterých chcete vložit Äetnosti zdrojových hodnot, spoÄtené pro jednotlivé intervaly (tÅÃdy). MusÃte vybrat o jednu buÅku vÃce, než je poÄet tÅÃd, do této buÅky bude vložena Äetnost hodnot, které pÅekraÄujà hornà limit poslednà tÅÃdy. V tomto pÅÃkladÄ vyberte buÅky C1:C6. V \\<emph\\>Průvodci funkcÃ\\</emph\\> zvolte funkci FREQUENCY. Jako \\<emph\\>Data" +#~ "\\</emph\\> dále zadejte rozsah bunÄk obsahujÃcÃch hodnoty mÄÅenà (A1:A11) a také sloupec obsahujÃcà hornà meze zkoumaných intervalů jako \\<emph\\>TÅÃdy\\</emph\\>; tedy buÅky B1:B6. ZaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\> a klepnÄte na \\<emph\\>OK\\</emph\\>. V původnÄ oznaÄeném rozsahu bunÄk C1:C6 nynà vidÃte Äetnosti hodnot mÄÅenà v pÅÃsluÅ¡ných intervalech." + +#~ msgid "\\<ahelp hid=\\\"HID_FUNC_NBW\\\"\\>Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.\\</ahelp\\>" +#~ msgstr "\\<ahelp hid=\\\"HID_FUNC_NBW\\\"\\>Vrátà Äistou hodnotu investice na základÄ Åady pravidelných penÄžnÃch toků a pÅi stanovené diskontnà sazbÄ.\\</ahelp\\>" + +#~ msgid "What is the net present value of periodic payments in hundreds of 345, 276 and -145 currency units with a discount rate of 8.75%." +#~ msgstr "Chcete vypoÄÃtat, jaká je Äistá souÄasná hodnota pro pravidelné platby o hodnotÄ 345, 276 a -145 mÄnových jednotek, je-li diskontnà sazba 8,75 %." + +#~ msgid "NPV(8.75%;345;276;-145) = 437.87 currency units. The net present value is therefore 437.87 currency units." +#~ msgstr "NPV(8,75 %;345;276;-145) vrátà hodnotu 437,87 mÄnových jednotek. Äistá souÄasná hodnota je 437,87 mÄnových jednotek." + +#~ msgid "\\<emph\\>Type\\</emph\\> (optional) is the sequence order. = 0 means ascending, = 1 means descending." +#~ msgstr "\\<emph\\>Typ\\</emph\\> (volitelné) urÄuje poÅadà tÅÃdÄnÃ: 0 znamená vzestupnÄ, 1 sestupnÄ." #~ msgid "\\<ahelp hid=\\\"HID_AAI_FUNC_IMEXP\\\"\\>The result is the power of e (the Eulerian number) and the complex number.\\</ahelp\\>" #~ msgstr "\\<ahelp hid=\\\"HID_AAI_FUNC_IMEXP\\\"\\>Vracà mocninu e (Eulerovo ÄÃslo) a komplexnÃho ÄÃsla.\\</ahelp\\>" --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
