modul algoritma pemrograman tingkat lanjut

Sebelum melakukan penelitian setiap peneliti harus menyiapkan proposal penelitian. For the purpose of this module though, the emphasis would be to help students to write proposal of their Skripsi, Thesis, or Dissertation, which is usually have to go through examination in front of professors other than the advisors. For this reason, it is therefore, that the credential of the researcher is usually appended to the proposal to convince the donor that it is a good research, worth of pursuing and of course funded, and that he is the right person to do the job. Its main purpose is not only as a guide line for the researcher or anybody else (say, who wants to repeat the research in different place and setting – see Sekaran, 2010, on the meaning of “scientific research”) to follow in conducting the research, but also as a document submitted to donor to secure fund for the research. =SUMIF(A1:A5 'A?' B1:B5) sums the values in B1:B5 whose corresponding values in A1:A5 start with 'A' followed by exactly two other characters.Prior to conducting research every researcher must prepare a research proposal. =COUNTIF(A1:A10 'Chi*') counts the number of cells in the range A1:A10 containing strings that start with 'Chi' followed by zero or more characters.

The following examples consider that the options Enable wildcards in formulas and Search criteria = and must apply to whole cells are enabled in Collabora Office - Preferences - Collabora Office Calc - Calculate Tools - Options - Collabora Office Calc - Calculate. Lookup functions: HLOOKUP, LOOKUP and VLOOKUP. Wildcards are supported by the following spreadsheet functions:ĭatabase functions: DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.Ĭonditional functions: AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Wildcards are supported in Collabora Office Calc and in Microsoft Excel. If the option Search criteria = and must apply to whole cells is disabled in Collabora Office - Preferences - Collabora Office Calc - Calculate Tools - Options - Collabora Office Calc - Calculate, then 'forecaster' will be a match using the '*cast' search string.Įscapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character.įor example, the search string 'why~?' matches “why?” but will not match 'whys' nor 'why~s'. For example, the search string '*cast' will match “cast”, “forecast”, and “outcast”, but will not match 'forecaster' using default Collabora Office settings.

Matches any sequence of characters, including an empty string. The '?' wildcard does not correspond to a zero-character match. Note that it will not match 'bg' as well, since '?' must match exactly one character. For example, the search string 'b?g' matches “bag” and “beg” but will not match 'boog' or 'mug'. Note that you can use this dialog to switch to regular expressions by choosing Enable regular expressions in formulas or choose to support neither wildcards nor regular expressions.

To make sure wildcards are supported, go to Collabora Office - Preferences - Collabora Office Calc - Calculate Tools - Options - Collabora Office Calc - Calculate and check if the option Enable wildcards in formulas is selected.

Modul algoritma pemrograman tingkat lanjut