draft 1 + correct link

taruma · Oct 25, 2022 · Oct 24, 2022 · Oct 24, 2022 · Oct 24, 2022 · Oct 24, 2022
commit f4fb6e9d6dfc6106bb56b6d862725f3b7a60f582
diff --git a/_quarto.yml b/_quarto.yml
@@ -48,11 +48,23 @@ website:
         - href: release/feidlambda.qmd
         - href: release/feidlambda-0-2-0.qmd
         - href: release/feidlambda-0-1-0.qmd
+      - text: Greenhorn
+        menu:
+        - text: "Greenhorn"
+          href: greenhorn/index.qmd
+        - text: feidlambda I
+          href: greenhorn/index.qmd
+          # href: greenhorn/feidlambda-2/presentation.qmd
+        - text: feidlambda II
+          href: greenhorn/feidlambda-2/index.qmd
+        - text: feidlambda III
+          href: greenhorn/index.qmd
+          # href: release/feidlambda-0-1-0.qmd
+
 
-    # right:
-    #   - icon: twitter
-    #     href: https://twitter.com
-    #     aria-label: feidlambda twitter
+    right:
+      - icon: github
+        href: https://github.com/fiakoenjiniring/feidlambda
 
   sidebar: 
     - id: side-docs
@@ -70,6 +82,39 @@ website:
           contents:
             - "yoooo"
             - "aaaa"
+
+    - id: side-feidlambda-2
+      style: floating
+      contents:
+      - text: Pendahuluan
+        href: greenhorn/feidlambda-2/index.qmd
+      - text: Presentasi
+        href: greenhorn/feidlambda-2/presentation.qmd
+      - Review
+      - section: Logical
+        contents:
+          - Fungsi Logical
+          - Operator Logical
+          - Fungsi IS*
+      - section: Dynamic Array Formula
+        contents:
+          - FILTER, UNIQUE
+          - RANDARRAY, SEQUENCE
+          - SORT, SORTBY
+          - XLOOKUP, XMATCH
+      - section: Fungsi Baru
+        contents:
+          - CONCAT
+          - IFS, MAXIFS, MINIFS
+          - SWITCH
+          - TEXTJOIN
+          - LET
+      - section: User Defined Lambda (UDL)
+        contents:
+          - Pengenalan LAMBDA
+          - Menggabungkan LAMBDA dan LET
+          - Advanced Formula Environment (AFE)
+          - Berbagi UDL
 
   ## SIDEBAR
   page-footer:
@@ -82,7 +127,7 @@ website:
 
 format:
   html:
-    theme: zephyr # lux, materia, minty, sandstone, spacelab, yeti
+    theme: default # lux, materia, minty, sandstone, spacelab, yeti, zephyr
     css: styles.css
     toc: true
 

diff --git a/docs/glossary.qmd b/docs/glossary.qmd
@@ -32,9 +32,9 @@ Angka / numerik. Numerik yang dimaksud adalah bilangan real: $\mathbb{R} = \{-1,
 Sel. 
 
 ::: {#fig-glossary-cell .column-page layout-ncol="2" layout-valign="bottom"}
-![Cell (Excel)](./img-glossary/cell_excel.png){#fig-cell-excel width=350}
+![Cell (Excel)](img-glossary/cell_excel.png){#fig-cell-excel width=350}
 
-![Cell (Ilustrasi)](./img-glossary/cell_ilust.png){#fig-cell-ilust width=350}
+![Cell (Ilustrasi)](img-glossary/cell_ilust.png){#fig-cell-ilust width=350}
 
 _Cell_
 :::
@@ -44,9 +44,9 @@ _Cell_
 Rentang yang terdiri dari lebih dari satu sel.
 
 ::: {#fig-glossary-range .column-page layout-ncol="2" layout-valign="bottom"}
-![Range (Excel)](./img-glossary/range_excel.png){#fig-range-excel width=350}
+![Range (Excel)](img-glossary/range_excel.png){#fig-range-excel width=350}
 
-![Range (Ilustrasi)](./img-glossary/range_ilust.png){#fig-range-ilust width=350}
+![Range (Ilustrasi)](img-glossary/range_ilust.png){#fig-range-ilust width=350}
 
 _Range_
 :::
@@ -56,9 +56,9 @@ _Range_
 _Range_ yang memiliki 1 dimensi.
 
 ::: {#fig-glossary-vector .column-page layout-ncol="2" layout-valign="bottom"}
-![Vector (Excel)](./img-glossary/vector_excel.png){#fig-vector-excel width=350}
+![Vector (Excel)](img-glossary/vector_excel.png){#fig-vector-excel width=350}
 
-![Vector (Ilustrasi)](./img-glossary/vector_ilust.png){#fig-vector-ilust width=350}
+![Vector (Ilustrasi)](img-glossary/vector_ilust.png){#fig-vector-ilust width=350}
 
 _Vector_
 :::
@@ -68,9 +68,9 @@ _Vector_
 _Range_ yang memiliki 2 dimensi. Penggunaan istilah _array_ menginformasikan bahwa _range_ berupa dua dimensi. 
 
 ::: {#fig-glossary-array .column-page layout-ncol="2" layout-valign="bottom"}
-![Array (Excel)](./img-glossary/array_excel.png){#fig-array-excel width=350}
+![Array (Excel)](img-glossary/array_excel.png){#fig-array-excel width=350}
 
-![Array (Ilustrasi)](./img-glossary/array_ilust.png){#fig-array-ilust width=350}
+![Array (Ilustrasi)](img-glossary/array_ilust.png){#fig-array-ilust width=350}
 
 _Array_
 :::
@@ -80,9 +80,9 @@ _Array_
 _Array_ yang memiliki _header_ dalam format tabel. 
 
 ::: {#fig-glossary-table .column-page layout-ncol="2" layout-valign="center"}
-![Table (Excel)](./img-glossary/table_excel.png){#fig-table-excel width=350}
+![Table (Excel)](img-glossary/table_excel.png){#fig-table-excel width=350}
 
-![Table (Ilustrasi)](./img-glossary/table_ilust.png){#fig-table-ilust width=350}
+![Table (Ilustrasi)](img-glossary/table_ilust.png){#fig-table-ilust width=350}
 
 _Table_
 :::
@@ -92,9 +92,9 @@ _Table_
 _Vector_ atau _array_ yang berisikan nilai `TRUE` atau `FALSE`.
 
 ::: {#fig-glossary-logical-vector .column-page layout-ncol="2" layout-valign="center"}
-![Logical Vector (Excel)](./img-glossary/logical-vector_excel.png){#fig-logical-vector-excel width=350}
+![Logical Vector (Excel)](img-glossary/logical-vector_excel.png){#fig-logical-vector-excel width=350}
 
-![Logical Vector (Ilustrasi)](./img-glossary/logical-vector_ilust.png){#fig-logical-vector-ilust width=350}
+![Logical Vector (Ilustrasi)](img-glossary/logical-vector_ilust.png){#fig-logical-vector-ilust width=350}
 
 _Logical Vector_
 :::
@@ -104,9 +104,9 @@ _Logical Vector_
 _Vector_ atau _array_ yang berisikan nilai _numerik_. 
 
 ::: {#fig-glossary-numeric-vector .column-page layout-ncol="2" layout-valign="center"}
-![Numeric Vector (Excel)](./img-glossary/numeric-vector_excel.png){#fig-numeric-vector-excel width=350}
+![Numeric Vector (Excel)](img-glossary/numeric-vector_excel.png){#fig-numeric-vector-excel width=350}
 
-![Numeric Vector (Ilustrasi)](./img-glossary/numeric-vector_ilust.png){#fig-numeric-vector-ilust width=350}
+![Numeric Vector (Ilustrasi)](img-glossary/numeric-vector_ilust.png){#fig-numeric-vector-ilust width=350}
 
 _Numeric Vector_
 :::
@@ -115,34 +115,34 @@ _Numeric Vector_
 
 _Vector_ yang melebar ke samping atau berupa baris. 
 
-![Row Vector (Excel)](./img-glossary/row-vector_excel.png){#fig-row-vector-excel width=350}
+![Row Vector (Excel)](img-glossary/row-vector_excel.png){#fig-row-vector-excel width=350}
 
 ##### _COLUMN VECTOR_
 
 _Vector_ yang memanjang ke bawah atau berupa kolom.
 
-![Column Vector (Excel)](./img-glossary/column-vector_excel.png){#fig-column-vector-excel height=350}
+![Column Vector (Excel)](img-glossary/column-vector_excel.png){#fig-column-vector-excel height=350}
 
 ##### _DYNAMIC ARRAY_
 
 Larik dinamis adalah kumpulan nilai / sel yang merupakan satu kesatuan. Dapat berupa _vector_ (1D) atau _array_ (2D).
 
 ::: {#fig-glossary-dynamic-array-vector .column-screen-inset layout="[[1,1,1]]" layout-valign="bottom"}
-![_Column Vector_ Biasa](./img-glossary/dynamic-array_col_nda_excel.png){#fig-dynamic-array-col-nda height=350}
+![_Column Vector_ Biasa](img-glossary/dynamic-array_col_nda_excel.png){#fig-dynamic-array-col-nda height=350}
 
-![_Dynamic Array_ pada _Column Vector_](./img-glossary/dynamic-array_col_excel.gif){#fig-dynamic-array-col-gif height=350}
+![_Dynamic Array_ pada _Column Vector_](img-glossary/dynamic-array_col_excel.gif){#fig-dynamic-array-col-gif height=350}
 
-![_Column Vector_ (_Dynamic Array_)](./img-glossary/dynamic-array_col_da_excel.png){#fig-dynamic-array-col-da height=350}
+![_Column Vector_ (_Dynamic Array_)](img-glossary/dynamic-array_col_da_excel.png){#fig-dynamic-array-col-da height=350}
 
 _Dynamic Array_ (_Vector_)
 :::
 
 ::: {#fig-glossary-dynamic-array-array .column-screen-inset layout="[[1,1,1]]" layout-valign="bottom"}
-![_Array_ Biasa](./img-glossary/dynamic-array_array_nda_excel.png){#fig-dynamic-array-col-nda height=350}
+![_Array_ Biasa](img-glossary/dynamic-array_array_nda_excel.png){#fig-dynamic-array-col-nda height=350}
 
-![_Dynamic Array_ pada _Array_](./img-glossary/dynamic-array_array_excel.gif){#fig-dynamic-array-col-gif height=350}
+![_Dynamic Array_ pada _Array_](img-glossary/dynamic-array_array_excel.gif){#fig-dynamic-array-col-gif height=350}
 
-![_Array_ (_Dynamic Array_)](./img-glossary/dynamic-array_array_da_excel.png){#fig-dynamic-array-col-da height=350}
+![_Array_ (_Dynamic Array_)](img-glossary/dynamic-array_array_da_excel.png){#fig-dynamic-array-col-da height=350}
 
 _Dynamic Array_ (_Array_)
 :::
@@ -154,9 +154,9 @@ Formula yang mengeluarkan hasil lebih dari satu sel (_vector_ / _array_) dalam b
 Persamaan yang termasuk _dynamic array formula_ antara lain: `=POWER()`, `=ABS()`, `=ROUNDUP()`, dll. Yang perlu diingat bahwa formula _dynamic array_ mampu menghasilkan nilai dalam bentuk _vector_ atau _array_ sesuai jenis nilai yang dimasukkan.
 
 ::: {#fig-glossary-dynamic-array-formula .column-screen-inset layout="[[40,60]]" layout-valign="bottom"}
-![Formula Biasa](./img-glossary/dynamic-array-formula_normal_excel.png){#fig-dynamic-array-formula-normal height=350}
+![Formula Biasa](img-glossary/dynamic-array-formula_normal_excel.png){#fig-dynamic-array-formula-normal height=350}
 
-![_Dynamic Array Formula_](./img-glossary/dynamic-array-formula_da_excel.png){#fig-dynamic-array-formula-dynamic height=350}
+![_Dynamic Array Formula_](img-glossary/dynamic-array-formula_da_excel.png){#fig-dynamic-array-formula-dynamic height=350}
 
 _Dynamic Array Formula_
 :::
diff --git a/greenhorn/feidlambda-2/index.qmd b/greenhorn/feidlambda-2/index.qmd
@@ -0,0 +1,35 @@
+---
+pagetitle: "feidlambda II: Exploring Dynamic Array + User Defined Lambda (UDL) with LAMBDA"
+title: feidlambda II
+
+subtitle: |
+    Exploring Dynamic Array + User Defined Lambda (UDL) with LAMBDA
+
+title-block-banner: true
+toc: true
+format: 
+    html:
+        link-external-newwindow: true
+        page-layout: full
+sidebar: side-greenhorn
+
+author: Taruma Sakti Megariansyah
+date: 2022-10-25
+# author-title: Penulis
+abstract: |
+    Pada pertemuan kedua, pembelajaran akan fokus untuk mengeksplorasi kegunaan _dynamic array formula_ dan penggunaan fungsi `LAMBDA`. 
+---
+
+Topik Pembahasan:
+
+- Review _Glossary_ (Daftar Istilah). 
+- Review _Dynamic Array_ dan _Dynamic Array Formula_.
+- Operator & Fungsi Logical: AND (*), OR (+). 
+- Fungsi `IS*`: `ISBLANK`, `ISERR`, `ISERROR`, `ISEVEN`, `ISFORMULA`, `ISNA`, `ISNONTEXT`, `ISNUMBER`, `ISODD`.
+- _Dynamic Array Formula_ (DAF): `FILTER`, `RANDARRAY`, `SEQUENCE`, `SORT`, `SORTBY`, `UNIQUE`, `XLOOKUP`, `XMATCH`.
+- Fungsi Baru (2019-2021): 
+    - 2019: `CONCAT`, `IFS`, `MAXIFS`, `MINIFS`, `SWITCH`, `TEXTJOIN`.
+    - 2021: `LET`.
+- _User Defined Lambda_ (UDL) dengan `LAMBDA`.
+- Kombinasi `LAMBDA` dan `LET`.
+- Berbagi UDL dengan [GitHub Gist](https://gist.github.com) dan _Advanced Formula Environment_ (AFE). 
diff --git a/greenhorn/feidlambda-2/presentation.qmd b/greenhorn/feidlambda-2/presentation.qmd
@@ -0,0 +1,112 @@
+---
+title: "feidlambda II"
+subtitle: "Exploring Dynamic Array + User Defined Lambda (UDL) with LAMBDA"
+date: 2022-10-25
+author: Taruma Sakti Megariansyah
+format:
+  revealjs: 
+    smaller: false
+    scrollable: true
+    slide-tone: false
+    slide-number: true
+    chalkboard: 
+      buttons: true
+    preview-links: true
+    theme: default
+    logo: /fiakologo.png
+    transition: slide
+---
+
+## Agenda
+
+Agenda untuk _feidlambda II: Exploring Dynamic Array + User Defined Lambda (UDL) with LAMBDA_
+
+::: {.incremental}
+- Review Daftar Istilah & _Dynamic Array Formula_
+- _Logical_
+- _Dynamic Array Formula_ (DAF)
+- Fungsi Baru (2019-2021)
+- _User Defined Lambda_ (UDL) dengan `LAMBDA`
+:::
+
+# 1 Review
+
+# [Daftar Istilah](https://lambda.fiako.engineering/docs/glossary.html)
+
+# 2 _Logical_
+
+# Fungsi dan Operator _Logical_
+
+## `AND` {.smaller}
+
+### Syntax
+
+```default 
+=AND(logical1, [logical2], ...)
+```
+
+::: {.incremental}
+- Fungsi logika, untuk menentukan apakah **semua kondisi** dalam sebuah tes adalah `TRUE`. ^[[AND (Fungsi AND)](https://support.microsoft.com/id-id/office/and-fungsi-and-5f19b2e8-e1df-4408-897a-ce285a19e9d9), Microsoft Support.]
+- Menghasilkan nilai `TRUE` ketika dua (atau lebih) bernilai `TRUE`. Jika terdapat satu atau lebih nilai `FALSE` maka menghasilkan nilai `FALSE`. 
+- Jika input berupa _logical vector_ saja (`AND(logical_vector)`), maka akan mengevaluasi seluruh elemen pada _logical vector_ (`AND(elemen_1, elemen_2, ...)`). 
+:::
+
+## Operator `AND` (`*`) {.smaller}
+
+### Syntax
+
+```default 
+=logical_vector1 * logical_vector2
+```
+
+::: {.incremental}
+- Mengevaluasi `AND` pada setiap elemen dengan _vector/array_. <br>`={AND(elemen1_vector1, elemen1_vector2, ...), AND(elemen2_vector1, elemen2_vector2, ...), ...}`.
+- Menghasilkan _numerical vector_ yang bernilai `0` (`FALSE`) atau `1` (`TRUE`). Contohnya: `{1, 0, 1}`
+- Gunakan `numerical_vector=1` untuk menghasilkan _logical vector_ (`{TRUE, FALSE, TRUE}`)
+:::
+
+## `OR`
+
+```default 
+=OR(logical1, [logical2], ...)
+```
+
+::: {.incremental}
+- Fungsi logika, untuk menentukan apakah **salah satu kondisi** dalam sebuah tes adalah `TRUE`. ^[[`OR` function](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0), Microsoft Support.]
+- Menghasilkan nilai `TRUE` ketika salah satu bernilai `TRUE`. 
+- Jika input berupa _logical vector_ saja (`OR(logical_vector)`), maka akan mengevaluasi seluruh elemen pada _logical vector_ (`OR(elemen_1, elemen_2, ...)`). 
+:::
+
+## Operator `OR` (`+`) {.smaller}
+
+### Syntax
+
+```default 
+=logical_vector1 * logical_vector2
+```
+
+::: {.incremental}
+- Mengevaluasi `OR` pada setiap elemen dengan _vector/array_. <br>`={OR(elemen1_vector1, elemen1_vector2, ...), OR(elemen2_vector1, elemen2_vector2, ...), ...}`.
+- Menghasilkan _numerical vector_ yang bernilai `0` (`FALSE`) atau `1` (`TRUE`). Contohnya: `{1, 0, 1}`
+- Gunakan `numerical_vector=1` untuk menghasilkan _logical vector_ (`{TRUE, FALSE, TRUE}`)
+:::
+
+## Menggunakan `AND` dan `OR`
+
+# Fungsi `IS*`
+
+## Kumpulan Fungsi `IS*`
+
+
+
+# 3 _Dynamic Array Formula_ (DAF)
+
+# 4 Fungsi Baru (2019-2021)
+
+# 5 _User Defined Lambda_ (UDL) dengan `LAMBDA`
+
+<!-- 
+
+::: {style="text-align: center; margin-top: 1em"}
+[Daftar Istilah](https://lambda.fiako.engineering/docs/glossary.html){preview-link="true" style="text-align: center"}
+::: -->