|
629.
|
|
|
@FUNCTION=interpolation ![](/@@/translation-newline)
@SYNTAX=interpolation(abscissas,ordinates,targets[,interpolation]) ![](/@@/translation-newline)
@DESCRIPTION= ![](/@@/translation-newline)
interpolation returns interpolated values corresponding ![](/@@/translation-newline)
to the given abscissa targets as a one column matrix.
![](/@@/translation-newline)
@abscissas are the absicssas of the data to interpolate. ![](/@@/translation-newline)
@ordinates are the ordinates of the data to interpolate. ![](/@@/translation-newline)
* Strings and empty cells in @abscissas and @ordinates are simply ignored. ![](/@@/translation-newline)
@targets are the abscissas of the interpolated data. If several data ![](/@@/translation-newline)
are provided, they must be in the same column, in consecutive cells ![](/@@/translation-newline)
@interpolation is the method to be used for the interpolation; ![](/@@/translation-newline)
possible values are: ![](/@@/translation-newline)
- 0: linear; ![](/@@/translation-newline)
- 1: linear with averaging; ![](/@@/translation-newline)
- 2: staircase; ![](/@@/translation-newline)
- 3: staircase with averaging; ![](/@@/translation-newline)
- 4: natural cubic spline; ![](/@@/translation-newline)
- 5: natural cubic spline with averaging.
![](/@@/translation-newline)
If an averaging method is used, the number of returned values ![](/@@/translation-newline)
is one less than the number of targets since the evaluation is made by ![](/@@/translation-newline)
averaging the interpolation over the interval between two consecutive data; ![](/@@/translation-newline)
in that case, the targets values must be given in increasing order.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
630.
|
|
|
@FUNCTION=periodogram ![](/@@/translation-newline)
@SYNTAX=periodogram(ordinates,[filter,[abscissas,[interpolation,[number]]]]) ![](/@@/translation-newline)
@DESCRIPTION= ![](/@@/translation-newline)
periodogram returns the periodogram of the data ![](/@@/translation-newline)
as a one column matrix.
![](/@@/translation-newline)
@ordinates are the ordinates of the data to interpolate. ![](/@@/translation-newline)
@filter gives the window function to be used. Possible values are: ![](/@@/translation-newline)
- 0: no filter (rectangular window); ![](/@@/translation-newline)
- 1: Bartlett (triangular window); ![](/@@/translation-newline)
- 2: Hahn (cosine window); ![](/@@/translation-newline)
- 3: Welch (parabolic window); ![](/@@/translation-newline)
@abscissas are the absicssas of the data to interpolate. If no ![](/@@/translation-newline)
abscissa is given, it is supposed that the data absicssas are regularly ![](/@@/translation-newline)
spaced. Otherwise, an interpolation method will be used to evaluate ![](/@@/translation-newline)
regularly spaced data. ![](/@@/translation-newline)
* Strings and empty cells in @abscissas and @ordinates are simply ignored. ![](/@@/translation-newline)
@interpolation is the method to be used for the interpolation; ![](/@@/translation-newline)
possible values are: ![](/@@/translation-newline)
- 0: linear; ![](/@@/translation-newline)
- 1: linear with averaging; ![](/@@/translation-newline)
- 2: staircase; ![](/@@/translation-newline)
- 3: staircase with averaging; ![](/@@/translation-newline)
- 4: natural cubic spline; ![](/@@/translation-newline)
- 5: natural cubic spline with averaging. ![](/@@/translation-newline)
@number is the number of interpolated data to be used. If not given, ![](/@@/translation-newline)
a default number is automatically evaluated.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
(no translation yet)
|
|
|
|
631.
|
|
|
@FUNCTION=EXECSQL ![](/@@/translation-newline)
@SYNTAX=EXECSQL(dsn,username,password,sql) ![](/@@/translation-newline)
@DESCRIPTION=The EXECSQL function lets you execute a command in a database server, and show the results returned in current sheet. It uses libgda as the means for accessing the databases. ![](/@@/translation-newline)
For using it, you need first to set up a libgda data source. ![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use: ![](/@@/translation-newline)
EXECSQL("mydatasource","username","password","SELECT * FROM customers") ![](/@@/translation-newline)
@SEEALSO=READDBTABLE
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=EXECSQL ![](/@@/translation-newline)
@SYNTAX=EXECSQL(i) ![](/@@/translation-newline)
@DESCRIPTION=Hàm EXECSQL cho phép bạn thực hiện một lệnh trong trình phục vụ cơ sở dữ liệu và nhận được kết quả trong tờ làm việc hiện thời. Nó dùng libgda để truy cập cơ sở dữ liệu. ![](/@@/translation-newline)
Để dùng nó, bàn cần thiết lập nguồn dữ liệu libGDA.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
Để lấy mọi dữ liệu từ bảng "Customers" trong nguồn "mydatasource", bạn cần dùng: ![](/@@/translation-newline)
EXECSQL("mydatasource","username","password","SELECT * FROM customers")
![](/@@/translation-newline)
@SEEALSO=READDBTABLE
|
|
Translated and reviewed by
Clytie Siddall
|
|
|
|
632.
|
|
|
@FUNCTION=READDBTABLE ![](/@@/translation-newline)
@SYNTAX=READDBTABLE(dsn,username,password,table) ![](/@@/translation-newline)
@DESCRIPTION=The READDBTABLE function lets you get the contents of a table, as stored in a database. For using it, you need first to set up a libgda data source. ![](/@@/translation-newline)
Note that this function returns all the rows in the given table. If you want to get data from more than one table or want a more precise selection (conditions), use the EXECSQL function. ![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
To get all the data from the table "Customers" present in the "mydatasource" GDA data source, you would use: ![](/@@/translation-newline)
READDBTABLE("mydatasource","username","password","customers") ![](/@@/translation-newline)
@SEEALSO=EXECSQL
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=READDBTABLE ![](/@@/translation-newline)
@SYNTAX=READDBTABLE(dsn,username,password,table) ![](/@@/translation-newline)
@DESCRIPTION=Hàm READDBTABLE cho phép bạn lấy nội dung bảng, như được cất giữ trong cơ sở dữ liệu. Để dùng nó, trước hết bạn cần thiết lập nguồn dữ liệu libgda. ![](/@@/translation-newline)
Hãy ghi chú rầng hàm này trả các hàng trong bảng cho trước. Nếu bạn muốn lấy dữ liệu từ nhiều bảng, hoặc muốn chọn điều kiện một cách chính xác hơn, thì hãy dùng hàm EXECSQL. ![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
Để lấy mọi dữ liệu "Customers" có trong nguồn dữ liệu GDA "mydatasource" thì bạn cần dùng: ![](/@@/translation-newline)
READDBTABLE("mydatasource","username","password","customers") ![](/@@/translation-newline)
@SEEALSO=EXECSQL
|
|
Translated and reviewed by
Clytie Siddall
|
|
|
|
633.
|
|
|
@FUNCTION=NT_PHI ![](/@@/translation-newline)
@SYNTAX=NT_PHI(n) ![](/@@/translation-newline)
@DESCRIPTION=NT_PHI function calculates the number of integers less than or equal to @n that are relatively prime to @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=NT_PHI ![](/@@/translation-newline)
@SYNTAX=NT_PHI(n) ![](/@@/translation-newline)
@DESCRIPTION=Hàm NT_PHI tính số nguyên nhỏ hơn hoặc bằng @n mà tương ứng với số nguyên tố thứ @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_SIGMA
|
|
Translated and reviewed by
Clytie Siddall
|
|
|
|
634.
|
|
|
@FUNCTION=NT_MU ![](/@@/translation-newline)
@SYNTAX=NT_MU(n) ![](/@@/translation-newline)
@DESCRIPTION=NT_MU function (Möbius mu function) returns ![](/@@/translation-newline)
0 if @n is divisible by the square of a prime . ![](/@@/translation-newline)
Otherwise it returns:
-1 if @n has an odd number of different prime factors .
1 if @n has an even number of different prime factors .
![](/@@/translation-newline)
* If @n = 1 NT_MU returns 1.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
|
xgettext: you can translate the funny character as an 'o' if unicode is not available.
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
represents a space character.
Enter a space in the equivalent position in the translation.
|
|
|
|
@FUNCTION=NT_MU ![](/@@/translation-newline)
@SYNTAX=NT_MU(n) ![](/@@/translation-newline)
@DESCRIPTION=Hàm NT_MU (Hàm Möbius mu) trả lại ![](/@@/translation-newline)
0 nếu @n là có thể chia hết cho bình phương của một số nguyên tố. ![](/@@/translation-newline)
Nếu khác nó trả lại:
-1 nếu tổng các thừa số nguyên tố mà tích của chúng tạo thành @n là một số lẻ.
1 nếu tổng các thừa số nguyên tố mà tích của chúng tạo thành @n là một số chẵn.
![](/@@/translation-newline)
* Nếu @n=1 thì trả lại 1
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
Translated by
Clytie Siddall
|
|
|
|
Located in
../plugins/numtheory/numtheory.c:258
|
|
635.
|
|
|
@FUNCTION=NT_D ![](/@@/translation-newline)
@SYNTAX=NT_D(n) ![](/@@/translation-newline)
@DESCRIPTION=NT_D function calculates the number of divisors of @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=ITHPRIME, NT_PHI, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=NT_D ![](/@@/translation-newline)
@SYNTAX=NT_D(n) ![](/@@/translation-newline)
@DESCRIPTION=Hàm NT_D tính số số chia @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=ITHPRIME, NT_PHI, NT_SIGMA
|
|
Translated and reviewed by
Clytie Siddall
|
|
|
|
636.
|
|
|
@FUNCTION=NT_SIGMA ![](/@@/translation-newline)
@SYNTAX=NT_SIGMA(n) ![](/@@/translation-newline)
@DESCRIPTION=NT_SIGMA function calculates the sum of the divisors of @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=NT_SIGMA ![](/@@/translation-newline)
@SYNTAX=NT_SIGMA(n) ![](/@@/translation-newline)
@DESCRIPTION=Hàm NT_SIGMA tính tổng các số chia @n.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, ITHPRIME, NT_PHI
|
|
Translated and reviewed by
Clytie Siddall
|
|
|
|
637.
|
|
|
@FUNCTION=ITHPRIME ![](/@@/translation-newline)
@SYNTAX=ITHPRIME(i) ![](/@@/translation-newline)
@DESCRIPTION=ITHPRIME function returns the @ith prime.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=ITHPRIME ![](/@@/translation-newline)
@SYNTAX=ITHPRIME(i) ![](/@@/translation-newline)
@DESCRIPTION=Hàm ITHPRIME trả lại số nguyên tố thứ @i.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=NT_D, NT_SIGMA
|
|
Translated by
Clytie Siddall
|
|
|
|
638.
|
|
|
@FUNCTION=ISPRIME ![](/@@/translation-newline)
@SYNTAX=ISPRIME(i) ![](/@@/translation-newline)
@DESCRIPTION=ISPRIME function returns TRUE if @i is prime and FALSE otherwise.
![](/@@/translation-newline)
@EXAMPLES= ![](/@@/translation-newline)
@SEEALSO=ITHPRIME, NT_D, NT_SIGMA
|
|
|
represents a line break.
Start a new line in the equivalent position in the translation.
|
|
|
|
@FUNCTION=ISPRIME ![](/@@/translation-newline)
@SYNTAX=ISPRIME(i) ![](/@@/translation-newline)
@DESCRIPTION=Hàm ISPRIME trả lại ĐÚNG nếu @i là số nguyên tố, SAI nếu không phải.
![](/@@/translation-newline)
@SEEALSO=ITHPRIME, NT_D, NT_SIGMA
|
|
Translated by
Clytie Siddall
|
|
|