SPINBUTTON

https://www.youtube.com/watch?v=GiM5T3dKRiw&ab_channel=warginosihim 

https://www.youtube.com/watch?v=TmeOMJkf_P8&ab_channel=Bisnis2000 

Terbilang

https://www.youtube.com/watch?v=1kTKdeGVxUI&ab_channel=AndiSetiadi 

MAKRo TerBILANG Google Spreadsheet

function terbilang(Nilai){

    if (Nilai.map){

        return Nilai.map(terbilang);

    }

    var bilangan=Nilai.toString();

    var kalimat="";

    var angka   = new Array('0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');

    var kata    = new Array('','Satu','Dua','Tiga','Empat','Lima','Enam','Tujuh','Delapan','Sembilan');

    var tingkat = new Array('','Ribu','Juta','Milyar','Triliun');

    var panjang_bilangan = bilangan.length;

    /* pengujian panjang bilangan */

    if(panjang_bilangan > 15){

        kalimat = "Diluar Batas";

    }else{

        for(i = 1; i <= panjang_bilangan; i++) {

            angka[i] = bilangan.substr(-(i),1);

        }

        var i = 1;

        var j = 0;

        /* mulai proses iterasi terhadap array angka */

        while(i <= panjang_bilangan){

            subkalimat = "";

            kata1 = "";

            kata2 = "";

            kata3 = "";

            if(angka[i+2] != "0"){

                if(angka[i+2] == "1"){

                    kata1 = "Seratus";

                }else{

                    kata1 = kata[angka[i+2]] + " Ratus";

                }

            }

            if(angka[i+1] != "0"){

                if(angka[i+1] == "1"){

                    if(angka[i] == "0"){

                        kata2 = "Sepuluh";

                    }else if(angka[i] == "1"){

                        kata2 = "Sebelas";

                    }else{

                        kata2 = kata[angka[i]] + " Belas";

                    }

                }else{

                    kata2 = kata[angka[i+1]] + " Puluh";

                }

            }

            if (angka[i] != "0"){

                if (angka[i+1] != "1"){

                    kata3 = kata[angka[i]];

                }

            }

            /* mengecek angka tidak nol semua, lalu ditambahkan tingkat */

            if ((angka[i] != "0") || (angka[i+1] != "0") || (angka[i+2] != "0")){

                subkalimat = kata1+" "+kata2+" "+kata3+" "+tingkat[j]+" ";

            }

            kalimat = subkalimat + kalimat;

            i = i + 3;

            j = j + 1;

        }

        /* mengganti Satu Ribu jadi Seribu jika diperlukan */

        if ((angka[5] == "0") && (angka[6] == "0")){

            kalimat = kalimat.replace("Satu Ribu","Seribu");

        }

    }

    return kalimat;

}