User: vitko605 Date: 05/07/03 09:53:32 Modified: /cs/po/helpcontent2/source/text/scalc/ 01.po
Log: Issue number: Submitted by: Reviewed by: 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.100&r2=1.101 Delta lines: +91 -81 --------------------- --- 01.po 2 Jul 2005 23:35:31 -0000 1.100 +++ 01.po 3 Jul 2005 16:53:29 -0000 1.101 @@ -7,14 +7,13 @@ "Project-Id-Version: 01\n" "Report-Msgid-Bugs-To: \n" "POT-Creation-Date: 2002-07-15 17:13+0100\n" -"PO-Revision-Date: 2005-07-03 01:39+0200\n" +"PO-Revision-Date: 2005-07-03 18:45+0200\n" "Last-Translator: Tomas Jirka <[EMAIL PROTECTED]>\n" "Language-Team: Czech <[email protected]>\n" "MIME-Version: 1.0\n" "Content-Type: text/plain; charset=UTF-8\n" "Content-Transfer-Encoding: 8bit\n" -"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);\n" -"X-Generator: KBabel 1.9.1\n" +"Plural-Forms: nplurals=3; plural=(n%10==1 && n%100!=11 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 || n%100>=20) ? 1 : 2);" #: 02110000.xhp#tit.help.text msgid "Navigator" @@ -1404,7 +1403,7 @@ #: 04060000.xhp#par_id3145587.15.help.text msgid "" -"When you double-click a function, the arguments input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell or drag the required range in the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using \\<link href=\\" +"When you double-click a function, the arguments input field(s) appear on the right side of the dialog. To select a cell reference as an argument, click directly into the cell or drag the required range in the sheet while holding down the mouse button. You can also enter numerical and other values or references directly into the corresponding fields in the dialog. When using \\<link href=\\"" "\"text/scalc/01/04060102.xhp\\\" name=\\\"date entries\\\"\\>date entries\\</link\\> make sure you use the correct format. Click OK to insert the result into the spreadsheet." msgstr "" "Když poklepáte na funkci, na pravé stranÄ dialogu se zobrazà pole pro vloženà argumentů funkce. Chcete-li vložit odkaz na buÅku jako argument, klepnÄte pÅÃmo na buÅku, nebo oznaÄte požadovanou oblast v listu pÅetaženÃm myÅ¡i. Můžete také vložit ÄÃselné a jiné hodnoty nebo odkazy pÅÃmo do odpovÃdajÃcÃho pole v dialogu. Pokud použijete \\<link href=\\\"text/scalc/01/04060102.xhp\\\" name=\\\"date " @@ -6308,7 +6307,7 @@ #: 04060107.xhp#par_idN10DD0.help.text msgid "The following functions provide forced array handling: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. If you use area references as arguments when you call one of these functions, the functions behave as array functions. The following table provides an example of forced array handling:" -msgstr "NásledujÃcà funkce poskytujà vynucené zpracovánà matic: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. Pokud je jako argument funkce použit rozsah bunÄk (matice), funkce se chová jako maticová. NásledujÃcà tabulka poskytuje pÅÃklady vynuceného zpracovánà matic:" +msgstr "NásledujÃcà funkce poskytujà vynucené zpracovánà matic: CORREL, COVAR, FORECAST, FTEST, INTERCEPT, MDETERM, MINVERSE, MMULT, MODE, PEARSON, PROB, RSQ, SLOPE, STEYX, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TTEST. Pokud je jako argument funkce použit rozsah bunÄk (matice), funkce se chová jako maticová. NásledujÃcà tabulka poskytuje pÅÃklady vynuceného zpracovánà matic:--" #: 04060107.xhp#par_idN10DEE.help.text msgid "B (result)" @@ -6316,7 +6315,7 @@ #: 04060107.xhp#par_idN10DF4.help.text msgid "C (forced array formula)" -msgstr "" +msgstr "C (vynucený maticový vzorec)" #: 04060107.xhp#par_idN10DFA.help.text msgid "C (result)" @@ -6344,7 +6343,7 @@ #: 04060107.xhp#par_id3154121.13.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_EINHEITSMATRIX\\\"\\>Returns the unitary square array of a certain size.\\</ahelp\\> The unitary array is a square array where the main diagonal elements equal 1 and all other array elements are equal to 0." -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_EINHEITSMATRIX\\\"\\>Vrátà jednotkovou Ätvercovou matici dané velikosti.\\</ahelp\\> JJednotková matice je Ätvercová matice, která má na diagonále jedniÄky a jejà ostatnà prvky majà hodnotu 0." #: 04060107.xhp#par_id3156271.15.help.text msgid "MUNIT(Dimensions)" @@ -6352,23 +6351,23 @@ #: 04060107.xhp#par_id3159390.16.help.text msgid "\\<emph\\>Dimensions\\</emph\\> refers to the size of the array unit." -msgstr "" +msgstr "\\<emph\\>RozmÄry\\</emph\\> urÄujà velikost matice." #: 04060107.xhp#par_id3150949.18.help.text msgid "Select a square range within the spreadsheet, for example, from A1 to E5." -msgstr "" +msgstr "Vyberte Ätvercový rozsah bunÄk, napÅÃklad A1 až E5." #: 04060107.xhp#par_id3151260.19.help.text msgid "Without deselecting the range, select the MUNIT function. Mark the \\<emph\\>Array\\</emph\\> check box. Enter the desired dimensions for the array unit, in this case 5, and click \\<emph\\>OK\\</emph\\>." -msgstr "" +msgstr "NeruÅ¡te oznaÄenà rozsahu bunÄk a vyberte funkci MUNIT. ZaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\>. Zadejte požadované rozmÄry jednotkové matice, v tomto pÅÃpadÄ 5, a klepnÄte na \\<emph\\>OK\\</emph\\>." #: 04060107.xhp#par_id3150403.20.help.text msgid "You can also enter the =Munit(5) formula in the last cell of the selected range (E5), and press \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"MAC\\\"\\>Shift+Command+Enter \\</caseinline\\>\\<defaultinline\\>Shift+Ctrl+Enter\\</defaultinline\\>\\</switchinline\\>." -msgstr "" +msgstr "Můžete také do poslednà buÅky vybraného rozsahu (E5) zadat vzorec =Munit(5) a stisknout \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"MAC\\\"\\>Shift+Command+Enter \\</caseinline\\>\\<defaultinline\\>Shift+Ctrl+Enter\\</defaultinline\\>\\</switchinline\\>." #: 04060107.xhp#par_id3156143.21.help.text msgid "You now see a unit array with a range of A1:E5." -msgstr "" +msgstr "V rozsahu bunÄk A1:E5 nynà vidÃte jednotkovou matici." #: 04060107.xhp#par_idN10FA7.help.text 04060107.xhp#par_idN11269.help.text 04060107.xhp#par_idN11333.help.text 04060107.xhp#par_idN113EE.help.text 04060107.xhp#par_idN114C3.help.text 04060107.xhp#par_idN115A5.help.text 04060107.xhp#par_idN116C6.help.text 04060107.xhp#par_idN11B04.help.text 04060107.xhp#par_idN11BC3.help.text 04060107.xhp#par_idN11C91.help.text 04060107.xhp#par_idN11D6B.help.text #: 04060107.xhp#par_idN11E45.help.text 04060107.xhp#par_idN11F1F.help.text 04060107.xhp#par_idN12019.help.text 04060107.xhp#par_idN12113.help.text @@ -6385,25 +6384,31 @@ #: 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 "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_HAEUFIGKEIT\\\"\\>Ukazuje rozdÄlenà Äetnostà hodnot v jednosloupcové matici.\\</ahelp\\>" #: 04060107.xhp#par_id3155498.25.help.text msgid "FREQUENCY(Data; Classes)" -msgstr "" +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 "" +msgstr "\\<emph\\>Data\\</emph\\> znamená rozsah bunÄk obsahujÃcÃch hodnoty, jejichž Äetnost v jednotlivých intervalech má být spoÄtena." #: 04060107.xhp#par_id3148402.27.help.text msgid "\\<emph\\>Classes\\</emph\\> represents the array of the class set." -msgstr "" +msgstr "\\<emph\\>TÅÃdy\\</emph\\> pÅedstavujà pole definujÃcà intervaly, pro které majà být spoÄteny Äetnosti." #: 04060107.xhp#par_id3155904.219.help.text +# #iFIXME# +# ... greater than 5 or greater than or equal to 10 ... +# should be +# ... greater than 5 or smaller than or equal to 10 ... +# msgid "" "In the following table, column A lists unsorted measurement values. Column B contains the upper limit you entered for the classes into which you want to divide the data in column A. According to the limit entered in B1, the FREQUENCY function returns the number of measured values less than or equal to 5. As the limit in B2 is 10, the FREQUENCY function returns the second result as the number of " "measured values that are greater than 5 or greater than or equal to 10. The text you entered in B6, \">25\", is only for reference purposes." msgstr "" +"Sloupec A v následujÃcà tabulce obsahuje nesetÅÃdÄné hodnoty mÄÅenÃ. Sloupec B obsahuje hornà meze intervalů, do kterých chceme rozdÄlit údaje ze sloupce A. Funkce FREQUENCY použije hodnotu v B1 k tomu, aby vrátila poÄet hodnot mÄÅenÃ, které jsou menÅ¡Ã nebo rovny 5. Na základÄ hodnoty B2 zase funkce FREQUENCY vrátà poÄet namÄÅených hodnot, které jsou vÄtÅ¡Ã než 5, nebo menÅ¡Ã nebo rovny 10. Text \">25\" zadaný do B6 nemá na funkci FREQUENCY vliv a sloužà pouze pro lepÅ¡Ã názornost." #: 04060107.xhp#par_id3154528.223.help.text 04060107.xhp#par_id3154995.84.help.text msgid "\\<emph\\>1\\</emph\\>" @@ -6438,6 +6443,8 @@ "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." #: 04060107.xhp#bm_id3151030.help.text msgid "\\<bookmark_value\\>MDETERM function\\</bookmark_value\\>" @@ -6449,19 +6456,19 @@ #: 04060107.xhp#par_id3154073.32.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_MDET\\\"\\>Returns the array determinant of an array.\\</ahelp\\> This function returns a value in the current cell; it is not necessary to define a range for the results." -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_MDET\\\"\\>Vracà determinant matice.\\</ahelp\\> Tato funkce vložà do aktuálnà buÅky jedinou hodnotu, nenà tÅeba pro výsledky rezervovat vÄtÅ¡Ã rozsah bunÄk." #: 04060107.xhp#par_id3156380.34.help.text msgid "MDETERM(array)" -msgstr "MDETERM(matice)" +msgstr "MDETERM(Matice)" #: 04060107.xhp#par_id3150290.35.help.text msgid "\\<emph\\>Array\\</emph\\> represents a square array in which the determinants are defined." -msgstr "" +msgstr "\\<emph\\>Matice\\</emph\\> pÅedstavuje Ätvercovou matici (rozsah bunÄk), jejÞ determinant bude vypoÄten." #: 04060107.xhp#par_idN11035.help.text msgid "You can find a general introduction to using Array functions on top of this page." -msgstr "" +msgstr "VÅ¡eobecný úvod do použÃvánà maticových funkcà naleznete na zaÄátku této stránky." #: 04060107.xhp#bm_id3151348.help.text msgid "\\<bookmark_value\\>MINVERSE function\\</bookmark_value\\>" @@ -6473,19 +6480,19 @@ #: 04060107.xhp#par_id3145569.40.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_MINV\\\"\\>Returns the inverse array.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_MINV\\\"\\>Vracà inverznà matici.\\</ahelp\\>" #: 04060107.xhp#par_id3156085.42.help.text msgid "MINVERSE(array)" -msgstr "MINVERSE(matice)" +msgstr "MINVERSE(Matice)" #: 04060107.xhp#par_id3157849.43.help.text msgid "\\<emph\\>Array\\</emph\\> represents a square array that is to be inverted." -msgstr "" +msgstr "\\<emph\\>Matice\\</emph\\> je Ätvercová matice, k nÞ poÄÃtáme inverznà matici." #: 04060107.xhp#par_id3149638.45.help.text msgid "Select a square range and select MINVERSE. Select the output array, select the \\<emph\\>Array\\</emph\\> field and click \\<emph\\>OK\\</emph\\>." -msgstr "" +msgstr "Vyberte Ätvercový rozsah bunÄk a funkci MINVERSE. Vyberte cÃlový rozsah bunÄk, zaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\> a kliknÄte na \\<emph\\>OK\\</emph\\>." #: 04060107.xhp#bm_id3148546.help.text msgid "\\<bookmark_value\\>MMULT function\\</bookmark_value\\>" @@ -6497,7 +6504,7 @@ #: 04060107.xhp#par_id3148518.48.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_MMULT\\\"\\>Calculates the array product of two arrays.\\</ahelp\\> The number of columns for array 1 must match the number of rows for array 2. The square array has an equal number of rows and columns." -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_MMULT\\\"\\>SpoÄte maticový souÄin dvou matic.\\</ahelp\\> PoÄet sloupců prvnà matice se musà rovna poÄtu Åádků druhé matice. Ätvercová matice má stejný poÄet Åádků i sloupců." #: 04060107.xhp#par_id3150798.50.help.text msgid "MMULT(array; array)" @@ -6505,15 +6512,15 @@ #: 04060107.xhp#par_id3150812.51.help.text msgid "\\<emph\\>Array\\</emph\\> at first place represents the first array used in the array product." -msgstr "" +msgstr "\\<emph\\>Matice\\</emph\\> jako prvnà parametr znaÄà prvnà Äinitel maticového souÄinu." #: 04060107.xhp#par_id3152553.52.help.text msgid "\\<emph\\>Array\\</emph\\> at second place represents the second array with the same number of rows." -msgstr "" +msgstr "\\<emph\\>Matice\\</emph\\> jako druhý parametr je druhý Äinitel maticového souÄinu." #: 04060107.xhp#par_id3146826.54.help.text msgid "Select a square range. Choose the MMULT function. Select the first \\<emph\\>Array\\</emph\\>, then select the second \\<emph\\>Array\\</emph\\>. Using \\<emph\\>Function Wizard\\</emph\\>, mark the \\<emph\\>Array\\</emph\\> check box. Click \\<emph\\>OK\\</emph\\>. The output array will appear in the first selected range." -msgstr "" +msgstr "Vyberte Ätvercový rozsah bunÄk. Vyberte funkci MMULT. Zadejte prvnà \\<emph\\>Matici\\</emph\\> a potom druhou \\<emph\\>Matici\\</emph\\>. V \\<emph\\>Průvodci funkcÃ\\</emph\\> zaÅ¡krtnÄte polÃÄko \\<emph\\>Matice\\</emph\\>. KlepnÄte na tlaÄÃtko \\<emph\\>OK\\</emph\\>. Výsledná matice se objevà v rozsahu bunÄk oznaÄeném v prvnÃm kroku." #: 04060107.xhp#bm_id3154970.help.text msgid "\\<bookmark_value\\>TRANSPOSE function\\</bookmark_value\\>" @@ -6525,7 +6532,7 @@ #: 04060107.xhp#par_id3155276.57.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_MTRANS\\\"\\>Transposes the rows and columns of an array.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_MTRANS\\\"\\>Transponuje Åádky a sloupce zadané matice.\\</ahelp\\>" #: 04060107.xhp#par_id3153843.59.help.text msgid "TRANSPOSE(array)" @@ -6533,13 +6540,15 @@ #: 04060107.xhp#par_id3153857.60.help.text msgid "\\<emph\\>Array\\</emph\\> represents the array in the spreadsheet that is to be transposed." -msgstr "" +msgstr "\\<emph\\>Matice\\</emph\\> oznaÄuje matici (rozsah bunÄk), která bude transponována." #: 04060107.xhp#par_id3159366.62.help.text msgid "" "In the spreadsheet, select the range in which the transposed array can appear. If the original array has n rows and m columns, your selected range must have at least m rows and n columns. Then enter the formula directly, select the original array and press \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"MAC\\\"\\>Shift+Command+Enter \\</caseinline\\>\\<defaultinline\\>Shift+Ctrl" "+Enter\\</defaultinline\\>\\</switchinline\\>. Or, if you are using the \\<emph\\>Function Wizard\\</emph\\>, mark the \\<emph\\>Array\\</emph\\> check box. The transposed array appears in the selected target range and is protected automatically against changes." msgstr "" +"Vyberte v listu rozsah bunÄk, ve kterém se objevà transponovaná matice. Pokud má původnà matice n Åádek a m sloupců, musà mÃt Vámi zvolený rozsah bunÄk alespoÅ n sloupců a m Åádek. Potom zadejte vzorec pÅÃmo z ruky, zvolte zdrojovou matici a stisknÄte \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"MAC\\\"\\>Shift+Command+Enter \\</caseinline\\>\\<defaultinline\\>Shift+Ctrl" +"+Enter\\</defaultinline\\>\\</switchinline\\>. Pokud použÃváte \\<emph\\>Průvodce maticÃ\\</emph\\>, nezapomeÅte zaÅ¡krtnout polÃÄko \\<emph\\>Matice\\</emph\\>. Transponovaná matice se objevà v cÃlovém rozsahu bunÄk a je automaticky chránÄna pÅed zmÄnami." #: 04060107.xhp#bm_id3109846.help.text msgid "\\<bookmark_value\\>LINEST function\\</bookmark_value\\>" @@ -6551,35 +6560,35 @@ #: 04060107.xhp#par_id3144733.65.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_RGP\\\"\\>Returns the parameters of a linear trend.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_RGP\\\"\\>Vrátà parametry lineárnà regrese.\\</ahelp\\>" #: 04060107.xhp#par_id3152839.67.help.text msgid "LINEST(Data_Y; Data_X; Linear_Type; Stats)" -msgstr "" +msgstr "LINEST(Data_Y; Data_X; LineárnÃ_typ; Parametr)" #: 04060107.xhp#par_id3152853.68.help.text 04060107.xhp#par_id3163137.154.help.text 04060107.xhp#par_id3166137.200.help.text 04060107.xhp#par_id3166392.211.help.text msgid "\\<emph\\>Data_Y\\</emph\\> represents the Y Data array." -msgstr "" +msgstr "\\<emph\\>Data_Y\\</emph\\> pÅedstavuje data hodnot Y." #: 04060107.xhp#par_id3154428.69.help.text 04060107.xhp#par_id3163155.155.help.text 04060107.xhp#par_id3166156.201.help.text 04060107.xhp#par_id3166411.212.help.text msgid "\\<emph\\>Data_X\\</emph\\> (optional) represents the X Data array." -msgstr "" +msgstr "\\<emph\\>Data_X\\</emph\\> (volitelné) pÅedstavuje pole dat X." #: 04060107.xhp#par_id3154448.70.help.text msgid "\\<emph\\>Linear_Type\\</emph\\> (optional). If the line goes through the zero point, then set Linear_Type = 0." -msgstr "" +msgstr "\\<emph\\>LineárnÃ_typ\\</emph\\> (volitelný). Pokud pÅÃmka procházà poÄátkem soustavy souÅadnic (bodem nula), potom zadejte LineárnÃ_typ = 0." #: 04060107.xhp#par_id3154142.71.help.text msgid "\\<emph\\>Stats\\</emph\\> (optional). If Stats=0, only the regression coefficient is to be calculated. Otherwise, you will see other stats." -msgstr "" +msgstr "\\<emph\\>Parametr\\</emph\\> (volitelný). Pokud Parametr=0, bude vypoÄten pouze regresnà koeficient, jinak uvidÃte jeÅ¡tÄ dalšà údaj." #: 04060107.xhp#par_id3154176.73.help.text msgid "This function returns an array and is handled in the same way as the other array functions. Select a range for the answers and then the function. Select Data_Y. If you want, you can enter other parameters. Select \\<emph\\>Array\\</emph\\> and click \\<emph\\>OK\\</emph\\>." -msgstr "" +msgstr "Tato funkce vracà pole a pracuje se s nà jako s jinými maticovými funkcemi. Zvolte rozsah bunÄk pro odpovÄÄ a vložte funkci. Vyberte Data_Y. Pokud chcete, můžete zadat dalÅ¡Ã parametry. OznaÄte polÃÄko \\<emph\\>Matice\\</emph\\> a klepnÄte na \\<emph\\>OK\\</emph\\>." #: 04060107.xhp#par_id3155468.74.help.text msgid "The results returned by the system (if Stats = 0), will at least show the slope of the regression line and its intersection with the Y axis. If \\<emph\\>Stats\\</emph\\> do not equal 0, other results are to be displayed." -msgstr "" +msgstr "Vrácené výsledky (pokud Parametr = 0) budou obsahovat pÅinejmenÅ¡Ãm smÄrnici regresnà pÅÃmky a jejà průseÄÃk s osou Y. Pokud se \\<emph\\>Parametr\\</emph\\> nerovná nule, budou zobrazeny dalÅ¡Ã detaily." #: 04060107.xhp#hd_id3155491.75.help.text msgid "Other LINEST Results:" @@ -6698,6 +6707,7 @@ "Column A contains several X1 values, column B several X2 values and column C the Y values. You have already entered these values in your spreadsheet. You have now set up E2:G6 in the spreadsheet and activated the \\<emph\\>Function Wizard\\</emph\\>. For the LINEST function to work, you must have marked the \\<emph\\>Array\\</emph\\> check box in the \\<emph\\>Function Wizard\\</emph\\>. Next, " "select the following values in the spreadsheet (or enter them using the keyboard):" msgstr "" +"Sloupec A obsahuje nÄkolik hodnot X1, sloupec B nÄkolik hodnot X2 a sloupec C hodnoty Y. Tyto hodnoty už byly zadány. Nynà oznaÄÃte rozsah bunÄk E2:G6 a spustÃte \\<emph\\>Průvodce funkcÃ\\</emph\\>. Aby funkce LINEST fungovala, musÃte zaÅ¡krtnou polÃÄko \\<emph\\>Matice\\</emph\\> v \\<emph\\>Průvodci funkcÃ\\</emph\\>. Nynà zadejte následujÃcà hodnoty (oznaÄte pÅÃsluÅ¡né rozsahy bunÄk myÅ¡Ã, nebo je zapiÅ¡te pomocà klávesnice):" #: 04060107.xhp#par_id3158020.133.help.text msgid "\\<emph\\>Data_Y\\</emph\\> is C2:C8" @@ -6709,55 +6719,55 @@ #: 04060107.xhp#par_id3158058.135.help.text msgid "\\<emph\\>Linear_Type\\</emph\\> and \\<emph\\>Stats\\</emph\\> are both set to 1." -msgstr "" +msgstr "\\<emph\\>LineárnÃ_typ\\</emph\\> a \\<emph\\>Parametr\\</emph\\> majà oba hodnotu 1." #: 04060107.xhp#par_id3158084.136.help.text msgid "As soon as you click \\<emph\\>OK\\</emph\\>, $[officename] Calc will fill the above example with the LINEST values as shown in the example." -msgstr "" +msgstr "Jakmile klepnete na \\<emph\\>OK\\</emph\\>, $[officename] Calc doplnà výsledky funkce LINEST tak, jak je uvedeno v ukázce." #: 04060107.xhp#par_id3158106.137.help.text msgid "The formula in the \\<emph\\>Formula\\</emph\\> Bar corresponds to each cell of the LINEST array {=LINEST(C2:C8;A2:B8;1;1)}" -msgstr "" +msgstr "Vzorec v \\<emph\\>Panelu vzorců\\</emph\\> odpovÃdá každé buÅce pole LINEST {=LINEST(C2:C8;A2:B8;1;1)}" #: 04060107.xhp#par_id3158128.138.help.text msgid "\\<emph\\>This represents the calculated LINEST values:\\</emph\\>" -msgstr "" +msgstr "\\<emph\\>Toto jsou dalÅ¡Ã hodnoty, vypoÄtené funcà LINEST:\\</emph\\>" #: 04060107.xhp#bm_id3158146.help.text msgid "\\<bookmark_value\\>slopes, see also regression lines\\</bookmark_value\\>\\<bookmark_value\\>regression lines\\</bookmark_value\\>" -msgstr "" +msgstr "\\<bookmark_value\\>smÄrnice, viz regresnà pÅÃmka\\</bookmark_value\\>\\<bookmark_value\\>regresnà pÅÃmka\\</bookmark_value\\>" #: 04060107.xhp#par_id3158146.139.help.text msgid "E2 and F2: Slope \\<emph\\>m\\</emph\\> of the regression line y=b+m*x for the x1 and x2 values. The values are given in reverse order; that is, the slope for x2 in E2 and the slope for x1 in F2." -msgstr "" +msgstr "E2 a F2: SmÄrnice \\<emph\\>m\\</emph\\> regresnà pÅÃmky y=b+m*x pro hodnoty x1 a x2. Hodnoty jsou vráceny v opaÄném poÅadÃ, to znamená že smÄrnice pro x2 je v E2 a smÄrnice pro x1 je v F2." #: 04060107.xhp#par_id3158184.140.help.text msgid "G2: Intersection b with the y axis." -msgstr "G2: Průnik b s osou y." +msgstr "G2: Průnik s osou y (hodnota b)." #: 04060107.xhp#bm_id3158204.help.text msgid "\\<bookmark_value\\>standard errors\\</bookmark_value\\>" -msgstr "" +msgstr "\\<bookmark_value\\>standardnà odchylka\\</bookmark_value\\>" #: 04060107.xhp#par_id3158204.141.help.text msgid "E3 and F3: The standard error of the slope value." -msgstr "" +msgstr "E3 and F3: Standardnà odchylka hodnoty smÄrnice." #: 04060107.xhp#par_id3145845.142.help.text msgid "G3: The standard error of the intercept" -msgstr "G3: Standardnà chyba úseÄky." +msgstr "G3: Standardnà odchylka průseÄÃku s osou y." #: 04060107.xhp#bm_id3145859.help.text msgid "\\<bookmark_value\\>RSQ calculations\\</bookmark_value\\>" -msgstr "" +msgstr "\\<bookmark_value\\>výpoÄet RSQ\\</bookmark_value\\>" #: 04060107.xhp#par_id3145859.143.help.text msgid "E4: RSQ" -msgstr "E4: RSQ." +msgstr "E4: RSQ (Druhá mocnina Pearsonova korelaÄnÃho koeficientu)." #: 04060107.xhp#par_id3145880.144.help.text msgid "F4: The standard error of the regression calculated for the Y value." -msgstr "F4: Standardnà chyba regrese vypoÄtená pro hodnotu y." +msgstr "F4: Standardnà odchylka regrese vypoÄtená pro hodnotu y." #: 04060107.xhp#par_id3145894.145.help.text msgid "E5: The F value from the variance analysis." @@ -6781,23 +6791,23 @@ #: 04060107.xhp#par_id3146037.151.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_RKP\\\"\\>This function calculates the adjustment of the entered data as an exponential regression curve (y=b*m^x).\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_RKP\\\"\\>Tato funkce vypoÄte korekci zadaných hodnot ve formÄ exponenciálnà regresnà funkce (y=b*m^x).\\</ahelp\\>" #: 04060107.xhp#par_id3163123.153.help.text msgid "LOGEST(Data_Y; Data_X; Function_Type; Stats)" -msgstr "" +msgstr "LOGEST(Data_Y; Data_X; Typ_funkce; Parametr)" #: 04060107.xhp#par_id3163174.156.help.text msgid "\\<emph\\>Function_Type\\</emph\\> (optional). If Function_Type = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." -msgstr "" +msgstr "\\<emph\\>Typ_funkce\\</emph\\> (volitelný). Pokud se Typ_funkce = 0, bude ÅeÅ¡ena regresnà funkce ve tvaru y = m^x. V opaÄném pÅÃpadÄ bude ÅeÅ¡ena regrese y = b*m^x." #: 04060107.xhp#par_id3163196.157.help.text msgid "\\<emph\\>Stats\\</emph\\> (optional). If Stats=0, only the regression coefficient is calculated." -msgstr "" +msgstr "\\<emph\\>Parametr\\</emph\\> (volitelný). Pokud Parametr = 0, bude vypoÄten pouze regresnà koeficient." #: 04060107.xhp#par_id3163230.159.help.text msgid "See LINEST. However, no square sum will be returned." -msgstr "" +msgstr "Viz LINEST. V tomto pÅÃpadÄ ale nebudou vráceny žádné souÄty druhých mocnin." #: 04060107.xhp#bm_id3163286.help.text msgid "\\<bookmark_value\\>SUMPRODUCT function\\</bookmark_value\\>" @@ -6809,19 +6819,19 @@ #: 04060107.xhp#par_id3163314.162.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_SUMMENPRODUKT\\\"\\>Multiplies corresponding elements in the given arrays, and returns the sum of those products.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_SUMMENPRODUKT\\\"\\>Vynásobà odpovÃdajÃcà prvky v zadaných maticÃch a vrátà souÄet tÄchto souÄinů.\\</ahelp\\>" #: 04060107.xhp#par_id3163347.164.help.text msgid "SUMPRODUCT(Array 1; Array 2...Array 30)" -msgstr "" +msgstr "SUMPRODUCT(Matice 1; Matice 2...Matice 30)" #: 04060107.xhp#par_id3163362.165.help.text msgid "\\<emph\\>Array 1, Array 2...Array 30\\</emph\\> represent arrays whose corresponding elements are to be multiplied." -msgstr "" +msgstr "\\<emph\\>Matice 1, Matice 2...Matice 30\\</emph\\> pÅedstavujà matice, jejichž odpovÃdajÃcà prvky budou vynásobeny." #: 04060107.xhp#par_idN11B19.help.text msgid "At least one array must be part of the argument list. If only one array is given, all array elements are summed." -msgstr "" +msgstr "Seznam argumentů musà obsahovat alespoÅ jednu matici. Pokud je zadána pouze jedna matice, bude vrácen souÄet jejÃch prvků." #: 04060107.xhp#par_idN11BA1.help.text msgid "=SUMPRODUCT(A1:B3;C1:D3) returns 397." @@ -6829,15 +6839,15 @@ #: 04060107.xhp#par_idN11BA4.help.text msgid "Calculation: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3" -msgstr "" +msgstr "VýpoÄet: A1*C1 + B1*D1 + A2*C2 + B2*D2 + A3*C3 + B3*D3" #: 04060107.xhp#par_idN11BA7.help.text msgid "You can use SUMPRODUCT to calculate the scalar product of two vectors." -msgstr "" +msgstr "Funkci SUMPRODUCT můžete použÃt pro výpoÄet skalárnÃho souÄinu dvou vektorů." #: 04060107.xhp#par_idN11BBC.help.text msgid "SUMPRODUCT returns a single number, it is not necessary to enter the function as an array function." -msgstr "" +msgstr "Funkce SUMPRODUCT vracà jediné ÄÃslo, nenà tÅeba ji zadávat jako maticovou funkci." #: 04060107.xhp#bm_id3144842.help.text msgid "\\<bookmark_value\\>SUMX2MY2 function\\</bookmark_value\\>" @@ -6849,19 +6859,19 @@ #: 04060107.xhp#par_id3144871.170.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_SUMMEX2MY2\\\"\\>Returns the sum of the difference of squares of corresponding values in two arrays.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_SUMMEX2MY2\\\"\\>Vracà souÄet rozdÃlů druhých mocnin odpovÃdajÃcÃch si hodnot dvou matic.\\</ahelp\\>" #: 04060107.xhp#par_id3144903.172.help.text msgid "SUMX2MY2(array X; array Y)" -msgstr "" +msgstr "SUMX2MY2(Pole X; Pole Y)" #: 04060107.xhp#par_id3144916.173.help.text msgid "\\<emph\\>Array X\\</emph\\> represents the first array whose elements are to be squared and added." -msgstr "" +msgstr "\\<emph\\>Pole X\\</emph\\> pÅedstavuje prvnà pole, jehož prvky budou umocnÄny na druhou a seÄteny." #: 04060107.xhp#par_id3144936.174.help.text msgid "\\<emph\\>Array Y\\</emph\\> represents the second array whose elements are to be squared and subtracted." -msgstr "" +msgstr "\\<emph\\>Pole Y\\</emph\\> pÅedstavuje druhé pole, jehož prvky budou umocnÄny na druhou a odeÄteny." #: 04060107.xhp#bm_id3145026.help.text msgid "\\<bookmark_value\\>SUMX2PY2 function\\</bookmark_value\\>" @@ -6873,19 +6883,19 @@ #: 04060107.xhp#par_id3145055.179.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_SUMMEX2PY2\\\"\\>Returns the sum of the sum of squares of corresponding values in two arrays.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_SUMMEX2PY2\\\"\\>Vrátà souÄet souÄtů druhých mocnin odpovÃdajÃcÃch si hodnot ve dvou polÃch.\\</ahelp\\>" #: 04060107.xhp#par_id3163404.181.help.text msgid "SUMX2PY2(Array X; Array Y)" -msgstr "" +msgstr "SUMX2PY2(Pole X; Pole Y)" #: 04060107.xhp#par_id3163417.182.help.text msgid "\\<emph\\>Array X\\</emph\\> represents the first array whose arguments are to be squared and added." -msgstr "" +msgstr "\\<emph\\>Pole X\\</emph\\> pÅedstavuje prvnà pole, jehož prvky budou umocnÄny na druhou a seÄteny." #: 04060107.xhp#par_id3163437.183.help.text msgid "\\<emph\\>Array Y\\</emph\\> represents the second array, whose elements are to be added and squared." -msgstr "" +msgstr "\\<emph\\>Pole Y\\</emph\\> pÅedstavuje druhé pole, jehož prvky budou seÄteny a umocnÄny." #: 04060107.xhp#bm_id3163527.help.text msgid "\\<bookmark_value\\>SUMXMY2 function\\</bookmark_value\\>" @@ -6897,19 +6907,19 @@ #: 04060107.xhp#par_id3163556.188.help.text msgid "\\<ahelp hid=\\\"HID_FUNC_SUMMEXMY2\\\"\\>Adds the squares of the variance between corresponding values in two arrays.\\</ahelp\\>" -msgstr "" +msgstr "\\<ahelp hid=\\\"HID_FUNC_SUMMEXMY2\\\"\\>SeÄte druhé mocniny rozdÃlů mezi odpovÃdajÃcÃmi si hodnotami dvou polÃ.\\</ahelp\\>" #: 04060107.xhp#par_id3163588.190.help.text msgid "SUMXMY2(Array X; Array Y)" -msgstr "" +msgstr "SUMXMY2(Pole X; Pole Y)" #: 04060107.xhp#par_id3163601.191.help.text msgid "\\<emph\\>Array X\\</emph\\> represents the first array whose elements are to be subtracted and squared." -msgstr "" +msgstr "\\<emph\\>Pole X\\</emph\\> pÅedstavuje prvnà pole, jehož prvky budou odeÄteny a umocnÄny." #: 04060107.xhp#par_id3163621.192.help.text msgid "\\<emph\\>Array Y\\</emph\\> represents the second array, whose elements are to be subtracted and squared." -msgstr "" +msgstr "\\<emph\\>Pole Y\\</emph\\> pÅedstavuje druhé pole, jehož prvky budou odeÄteny a umocnÄny." #: 04060107.xhp#bm_id3166062.help.text msgid "\\<bookmark_value\\>TREND function\\</bookmark_value\\>" @@ -7147,7 +7157,7 @@ #: 04060109.xhp#par_id3153081.37.help.text msgid "" -"\\<item type=\\\"keycode\\\"\\>=DDE(\"soffice\";\"c:\\\\office\\\\document\\\\motto.sxw\";\"Today's motto\")\\</item\\> returns a motto in the cell containing this formula. First, you must enter a line in the motto.sxw document containing the motto text and define it as the first line of a section named \\<item type=\\\"literal\\\"\\>Today's Motto\\</item\\> (in \\<item type=\\\"productname\\" +"\\<item type=\\\"keycode\\\"\\>=DDE(\"soffice\";\"c:\\\\office\\\\document\\\\motto.sxw\";\"Today's motto\")\\</item\\> returns a motto in the cell containing this formula. First, you must enter a line in the motto.sxw document containing the motto text and define it as the first line of a section named \\<item type=\\\"literal\\\"\\>Today's Motto\\</item\\> (in \\<item type=\\\"productname\\"" "\"\\>%PRODUCTNAME\\</item\\> Writer under \\<emph\\>Insert - Section\\</emph\\>). If the motto is modified (and saved) in the \\<item type=\\\"productname\\\"\\>%PRODUCTNAME\\</item\\> Writer document, the motto is updated in all \\<item type=\\\"productname\\\"\\>%PRODUCTNAME\\</item\\> Calc cells in which this DDE link is defined." msgstr "" @@ -8855,18 +8865,18 @@ #: 04060112.xhp#par_id3150361.2.help.text msgid "" -"$[officename] Calc can be expanded by Add-Ins, which are external programming modules providing additional functions for working with spreadsheets. These are listed in the \\<emph\\>Function Wizard\\</emph\\> in the \\<emph\\>Add-In\\</emph\\> category. If you would like to program an Add-In yourself, you can learn here which functions must be exported by the \\<switchinline select=\\\"sys\\" +"$[officename] Calc can be expanded by Add-Ins, which are external programming modules providing additional functions for working with spreadsheets. These are listed in the \\<emph\\>Function Wizard\\</emph\\> in the \\<emph\\>Add-In\\</emph\\> category. If you would like to program an Add-In yourself, you can learn here which functions must be exported by the \\<switchinline select=\\\"sys\\"" "\"\\>\\<caseinline select=\\\"UNIX\\\"\\>shared library \\</caseinline\\>\\<defaultinline\\>external DLL\\</defaultinline\\>\\</switchinline\\> so that the Add-In can be successfully attached." msgstr "" -"$[officename] Calc je možno rozÅ¡ÃÅit pomocà doplÅků, což jsou externà programové moduly poskytujÃcà doplÅujÃcà funkce pro práci se seÅ¡ity. Tyto funkce se zobrazà v \\<emph\\>Průvodci funkcÃ\\</emph\\> v kategorii \\<emph\\>DoplnÄk\\</emph\\>. Pokud si chcete naprogramovat doplnÄk sám, doÄtete se zde, které funkce musà \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\" +"$[officename] Calc je možno rozÅ¡ÃÅit pomocà doplÅků, což jsou externà programové moduly poskytujÃcà doplÅujÃcà funkce pro práci se seÅ¡ity. Tyto funkce se zobrazà v \\<emph\\>Průvodci funkcÃ\\</emph\\> v kategorii \\<emph\\>DoplnÄk\\</emph\\>. Pokud si chcete naprogramovat doplnÄk sám, doÄtete se zde, které funkce musà \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\"" "\"\\>sdÃlená knihovna\\</caseinline\\>\\<defaultinline\\>externà DLL\\</defaultinline\\>\\</switchinline\\> exportovat, aby bylo možno doplnÄk úspÄÅ¡nÄ pÅipojit." #: 04060112.xhp#par_id3149211.3.help.text msgid "" -"$[officename] searches the folder defined in \\<emph\\>Tools - Options - $[officename] - Paths - Add-ins \\</emph\\>for a suitable \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\\"\\>shared library \\</caseinline\\>\\<defaultinline\\>DLL\\</defaultinline\\>\\</switchinline\\>. To be recognized by $[officename], the \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\" +"$[officename] searches the folder defined in \\<emph\\>Tools - Options - $[officename] - Paths - Add-ins \\</emph\\>for a suitable \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\\"\\>shared library \\</caseinline\\>\\<defaultinline\\>DLL\\</defaultinline\\>\\</switchinline\\>. To be recognized by $[officename], the \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\"" "\"UNIX\\\"\\>shared library \\</caseinline\\>\\<defaultinline\\>DLL\\</defaultinline\\>\\</switchinline\\> must have certain properties, as explained in the following. This information allows you to program your own Add-In for \\<emph\\>Function Wizard\\</emph\\> of $[officename] Calc." msgstr "" -"$[officename] hledá v adresáÅi urÄeném v \\<emph\\>Nástroje - Volby - $[officename] - Cesty - Moduly\\</emph\\> vhodnou \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\\"\\>sdÃlenou knihovnu\\</caseinline\\>\\<defaultinline\\>DLL knihovnu\\</defaultinline\\>\\</switchinline\\>. Aby $[officename] tuto \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\" +"$[officename] hledá v adresáÅi urÄeném v \\<emph\\>Nástroje - Volby - $[officename] - Cesty - Moduly\\</emph\\> vhodnou \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\\"\\>sdÃlenou knihovnu\\</caseinline\\>\\<defaultinline\\>DLL knihovnu\\</defaultinline\\>\\</switchinline\\>. Aby $[officename] tuto \\<switchinline select=\\\"sys\\\"\\>\\<caseinline select=\\\"UNIX\\"" "\"\\>sdÃlenou knihovnu\\</caseinline\\>\\<defaultinline\\>DLL knihovnu\\</defaultinline\\>\\</switchinline\\> rozeznal, musà mÃt urÄité vlastnosti popsané dále. Tyto informace vám umožnà naprogramovat si vlastnà doplnÄk pro \\<emph\\>Průvodce funkcÃ\\</emph\\> v $[officename] Calc." #: 04060112.xhp#hd_id3146981.4.help.text @@ -9011,7 +9021,7 @@ #: 04060112.xhp#par_id3152981.38.help.text msgid "" -"Returns the number of functions without the management functions of the reference parameter. Each function has a unique number between 0 and nCount-1. This number will be needed for the \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetFunctionData\\\"\\>GetFunctionData\\</link\\> and \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetParameterDescription\\" +"Returns the number of functions without the management functions of the reference parameter. Each function has a unique number between 0 and nCount-1. This number will be needed for the \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetFunctionData\\\"\\>GetFunctionData\\</link\\> and \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetParameterDescription\\"" "\"\\>GetParameterDescription\\</link\\> functions later." msgstr "Vracà poÄet funkcà bez administrativnà funkce referenÄnÃho parametru. Každá funkce má jedineÄné ÄÃslo od 0 do nCount-1. Toto ÄÃslo je potÅeba pro funkce \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetFunctionData\\\"\\>GetFunctionData\\</link\\> a \\<link href=\\\"text/scalc/01/04060112.xhp\\\" name=\\\"GetParameterDescription\\\"\\>GetParameterDescription\\</link\\>." --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
