Knowledge VS Experience

16 Amazing Classical Music Compositions That Will Inspire You

1. Chopin’s Nocturne in E-flat Major, Opus 9, No. 2

2. Beethoven’s Symphony 7, Allegretto, 2nd movement

3. Beethoven’s Moonlight Sonata, 1st movement 

4. Mozart’s Piano Concerto No. 21, Andante (“Elvira Madigan”)

5. Vivaldi’s Winter, Four Seasons (Allegro)

6. Pachelbel’s Canon in D

7. Bach’s Air (“on the G string”, string orchestra)

8. Bach’s Preludio, Partita in E Major, Lara St. John, solo violin 

9. Bach’s Cello Suite No. 1, 1st movement

10. Schubert’s Piano Trio in E-flat major, 2nd movement 

11. Mendelssohn’s Violin Concerto, 1st movement, E Minor, Opus 64 

12. Mendelssohn’s String Quartet No. 2, 3rd movement, Intermezzo 

13. Tallis’s Spem in Alium (40-voice motet) 

14. Handel’s Hallelujah Chorus from Messiah 

15. Brahms’ String Quartet No. 1, 3rd movement, Allegro Energetico 

16. Brahms, Piano Quartet in C minor, Opus 60, 3rd movement

Complexity to simplicity Perspective

Upon first glance, something may seem to be complex because of the number of different motions and amount of gear involved. But upon closer inspection, you will notice that certain rituals are repeated over and over for generic outcames.

Drum pattern sederhana

Contoh 1: 

step....         1   2   3   4   5   6   7   8   9  10  11  12  13  14  15  16 
Bass drum      | X - / - / - / | X - / - / - / | X - / - / - / | X - / - / - / |
snare drum     | / - / - / - / | X - / - / - / | / - / - / - / | X - / - / - / |
closed hi-hat  | X - X - / - X | X - X - / - X | X - X - / - X | X - X - / - X |
open hi-hat    | / - / - X - / | / - / - X - / | / - / - X - / | / - / - X - / |

10 Scientific Ways to Be happy

I think the "Plant a trip but dont take it" is wrong.

LMMS (Free Music maker software)

Default components:
1. Song-editor
 This is where different sound elements are organized to produce a song.

2. Beat + Bassline Editor
This is where drum beats or basslines can be created.

3. FX-Mixer
Where volume of each channel can be separately controlled.

4. Controller Rack
Where controller is added.

Default screen

 

Jenis-jenis Garis

1. Line
2. Rectangle
3. Ellipse
4. Polygon

Great InfoGraphics on programming language

Major signal in human body

1. Heart rate
2. Blood preasure

Error log VBA

1. #NAME?
Example:
=cetak
using incomplete(do not list a parameter); calling a function but do not supply argument
=aloha()
calling unexist function
=aloha
calling unexist function (although with different notation)

2. #VALUE?
Example:
=mesin()
"not supplying parameters"

Cloud computing benefit

In case of UJAM cloud music maker

1.  Gak perlu beli computer super
In the cloud, the workload is moved from our device to a powerful server, so we don't need to buy a supercomputer in order to make a music.

2.  Bisa diakses dimana saja; bisa dari gadget (Iphone, android smartphone, etc.) juga
Because it's in the cloud, UJAM is accessible from anywhere on the planet, will run on portable devices, and can embedded with other services.

3.  Jasa perkapalan bisa mati (aplikasi gak perlu dikirim lewat kapal lagi :D)
Like all cloud-based solutions, UJAM is easy to distribute to millions of people without shipping physical product.

4.  Upadates gak ribet lagi nge-download software ter-update
When we need to update UJAM, you wan't to have to wait for cumbersome software downloads or be reminded to update your system -- you'll get the updates automatically

Dadam network sound

Sequencial process
contoh:
interface f0/0
ip address 192.168.1.1 255.255.255.0
ip access-group in 123
no shutdown


What would be the first process, the second process the router will do upon receiving a packet?

1st process masking (ip address): checking ip address table, 2nd process filtering (ip access-group in): checkin access-list table, 3rd process

Sistematika penulisan ala gue

Judul
Pertanyaan: Apa yang lo lakukan?
Mandi

Latar belakang
Pertanyaan: Apa yang mendasari lo mandi?
Gw mau pergi

Tujuan
Pertanyaan: Untuk apa lo mandi?
Kenapa atau ngapain lo mandi?
Supaya gw tidak bau, gatal-gatal,

Manfaat
Apa manfaat dari yang lo lakukan itu bagi diri lo dan bagi orang lain?
Mandi buat diri gw: membuat gw tidak bau badan dan tidak gatal-gatal
Manfaat buat orang lain: gw tidak menyebabkan bau tidak sedap, dan tidak membuat orang lain risih karena garuk-garuk



Variabel yang mendukung kesuksesan lo mandi?
Air, sabun, handuk

Your own private theater

Artinya: Kalau kamu pinter memasuk-masukan, kamu bisa jadi engineer :D Cukup melegakan yah?

OOP ala gua

tumbuhan punya daun, batang, bunga, buah

tinggi batang awalnya = 0
warna daun awal = .....

tumbuhan bisa berkembang ditandai dengan perpanjangan batang.
tumbuhan bisa layu, ditandai dengan warna dauh yang kuning.
method adalah
tumbuh()
layu()
segar()

1. Membuat kelas
Contoh: Kelas tumbuhan

2. Membuat objek
Contoh: mawar
bunga.tinggi = 0
bunga.

3. memasukkan/menggolongkan objek ke suatu kelas

Dahulu kita hanya mengenal obyek: benda, manusia, tumbuh-tumbuhan dan hewan, tapi sekarang sejak berdirinya dunia komputer, kita mengenal obyek: file, text, etc :D

Input, output, mesin (fungsi)

Input, output, mesin
Diketahui input, output, tentukan mesin
Diketahui input, mesin, tentukan output
Diketahui output, mesin tentukan input

Command Line Parameters for Wmplayer

Windows Media Player supports a set of command line parameters that specify how the Player behaves when it starts. The following table details the parameters and their behaviors.

Syntax	Behavior
"path\filename"(For example: wmplayer "c:\filename.wma")	Start the Player and play the file.
"path\filename" /fullscreen(For example: wmplayer "c:\filename.wmv" /fullscreen)	Play the specified file in full-screen mode.You must specify the path and file name of the content to play.
/Device:{DVD|AudioCD}(For example: wmplayer /device:audio CD)	Play a DVD or audio CD.
"path\filename?WMPSkin=skin name"For example: wmplayer "c:\filename.wma?wmpskin=headspace"	Open the Player, applying the specified skin.
/Service:keyname	Open the Player showing the online store specified by keyname.Requires Windows Media Player 10 or later.
/Task NowPlaying	Open the Player in the Now Playing feature.
/Task MediaGuide	Open the Player in the Media Guide feature (current active online store in Windows Media Player 10 or later).
/Task CDAudio	Open the Player in the Copy from CD feature (Rip feature in Windows Media Player 10 or Windows Media Player 11). This parameter is not supported in Windows Media Player 12.
/Task CDWrite	Open the Player in the Burn feature.Requires Windows Media Player 10.
/Task MediaLibrary	Open the Player in the Library feature.
/Task RadioTuner	Open the Player in the Radio Tuner feature (current active online store in Windows Media Player 10 or later).
/Task PortableDevice	Open the Player in the Copy to CD or Device feature (Sync feature in Windows Media Player 10 or later).
/Task Services /Service servicename	Open the Player in the Premium Services feature, showing the service specified by the servicename parameter. This value is the unique name for the service. If the specified service has not been previously viewed, the servicename parameter is ignored. (Opens the specified online store in Windows Media Player 10 or later.)
/Task ServiceTaskX	Open the Player in the online store service task pane specified by X. For example, /Task ServiceTask1 opens the Player in the first online store service task pane.
/Task SkinViewer	Open the Player in the Skin Chooser feature.
/Playlist PlaylistName	Open the Player and play the specified playlist.
/Schema:{Music|Pictures|Video|TV|Other}For example: wmplayer /Schema:Pictures /Task:PortableDevice	Open the Player, showing the specified media category. Requires Windows Media Player 11.

My note: Batch programming

Echo command

Echo = display it to command line screen 
Used to display something on the command-line screen.

Gini, jika echo on (default), semua command akan di echo (ditampilkan di layar).
Jika echo off, semua command tidak akan di echo, tapi, command echo off nya tetap ditampilkan. Apa solusi? tambahkan @ di depan command echo off itu.
 

Contoh:
Echo Hello World!

Set command

Set command without refinement (polos) = used to compose a variable

Set command with /a ->used to enter


Set with /P= used to display and input a value to a variable.
 prompt

Contoh:
set /P enter your password

Pause
Press any key to enter..

Goto
:label

Exit

boxes on vba

msgbox
as the names implies it used to message something

inputbox
as the name implies it used to input something

Endank Soekamti BATAL KONSER

Segala sesuatu mutlak membutuhkan persiapan yang matang, apalagi menyangkut hal-hal yang berhubungan dengan profesionalisme.Disini kami akan mengulas kronologis kejadian kenapa pihak manajemen Endank Soekamti membatalkan secara sepihak konser di Politeknik Telkom Bandung pada tanggal 07-12-2013. Hal ini lebih diutamakan untuk menjadi pembelajaran bagi Event Organizer (Panitia), Fans, dan Endank Soekamti itu sendiri.

Sebelum mengundang Endank Soekamti untuk tampil di acara apapun dan dimanapun, Pihak Manajemen dipastikan sudah mengirim Technical Riders ke Panitia sebelum terjadi Dealing (persetujuan). Riders merupakan syarat-syarat yang harus dipenuhi Panitia, dan ini bias dibicarakan sebelumnya jika ada beberapa point-point yang tidak bisa dipenuhi oleh Panitia. Untuk kejadian di Bandung Panitia sudah menerima Riders dan ketika dikonfirmasi ulang, Pihak Panitia memastikan tidak ada masalah, baik untuk akomodasi dan Soundsystem. Sebenarnya pada H-1 Manajemen ES tidak akan memberangkatkan ES ke Bandung, dikarenakan masalah pelunasan. Akhirnya kami tetap memberangkatkan ES ke Bandung, dengan pertimbangan tidak akan mengecewakan Penonton yang sudah beli tiket Pre-sale.

Sabtu 07-Desember-2013 pagi kami tiba di Bandung.Dan sesuai janji Panitia, begitu sampai di Bandung, biaya fee dan lain-lain akan dilunasi. Namun Panitia meminta tenggat waktu sampai jam 17.00 Wib. Jam14.00 Road manager ES menelpon manajemen untuk konsultasi masalah sound system yang disediakan Panitia. Yang sangat jauh dari spesifikasi Sound System yang dibutuhkan ES sesuai Riders, Ampli gitar yang rusak, routing channel yang berantakan, minimnya jumlah channel, beberapa speaker out mati. Juga kapasitas watt yang tidak sesuai dengan luasnya venue.Dari Manajemen member solusi ke Panitia untuk mengganti dan menambah kapasitas Sound System,pada pukul 15.00,namun Panitia merasa kesulitan untuk mengatasinya.Karena tidak ada kepastian dari Panitia untuk Sound System dan pelunasan, jam 17.00 wib tepat Manajemen meminta tim produksi untuk membereskan peralatan pribadi ES yang sudah terpasang di panggung dan dibawa ke hotel. Jam 17.45 wib beberapa wakil dari Panitia menemui Manajer ES dan memohon dengan sangat untuk supaya alat-alat ES dibawa kembali dan dipasang lagi. Dan Panitia memberitahukan kalau akan menambah kapasitas SoundSystem. Namun mengingat waktu yang sangat mepet (butuhwaktu minimal 5 jam untuk setting Sound System baru) dan Panitia yang tidak professional, makaManajemen ES tetap pada keputusan awal untuk membatalkan ES tampil.

Ini kali pertama ES membatalkan konser secara sepihak.Sekedar catatan…setengah tahun yang lalu ES konser di Std. Kridosono Jogja, saat itu hujan sangat deras dan air menggenang setinggi 30 cm. pihak panitia tidak berani melanjutkan event tersebut, dengan alasan arus listrik bisa membahayakan semua. Namun personil ES tetap tampil dengan akustikan didepan puluhan ribu penonton dan hanya menggunakan penerangan dari HP dan senter. Di tahun 2005 ES konser di kota Semarang, hujan sangat deras dan badai. Sound System tidak dinyalakan, namun ada sekelompok kecil Kamtis yang tetap bertahan ditengah lapangan dengan bendera Kamtis yang dikibarkan. Sementara ES tetap bertahan di backstage, merasa terharu dan rasa loyalitas yang tanpa batas.Maka ES memohon kePihak sponsor supaya acara tetap dilanjutkan meski dengan sound yang keluar hanya dari sisi kanan. Show must go on….beberapaKamtis yang sudah minggir dan berteduh…segera berhambur menyusul teman-temannya yang tadi tetap bertahan sembari teriak : Soekamti!!! Soekamti!!! Soekamti!!!

Ibarat bersetubuh, para personil ES pun tidak mengalami orgasme.Kamtis yang sudah datang dari berbagai kota seperti Malang, Bekasi, Wonosobo, Cikarang, Jakarta, Wonogiri, Sragen dan kota lainnya jelas merasa kecewa.Untuk memenuhi hasrat Kamtis Family yang kecewa, pengelola Fans ES menghubungi Kamtis untuk dating ke Hotel tempat ES menginap sekedar beramah tamah dan ngobrol langsung dengan personil ES. Ratusan Kamtis memenuhi halaman hotel meski hujan saat itu turun dengan derasnya.Mereka bertemu langsung tanpa ada jarak dengan personil ES.Suasana hangatpun langsung terasa.Mereka berkumpul, bercengkerama dengan Kamtis yang beda kota, dan sesuai tradisi kamtis…yang datang dari luar kota akan ditampung kamtis tuan rumah. Begitu kuat persaudaraan ini…dan sangat terlihat kedewasaan Kamtis Family untuk menyikapi hal yang terjadi.Bersama-sama kami akhiri kehangatan malam itu dengan bernyanyi bareng-bareng : “ Aku ada disini mengiburmu…sekali lagi seperti dulu, senang ataupun susah selalu ceriaaa….Long Live My Family!!!”

Ini Videonya : https://www.youtube.com/watch?v=8VdLvfbo7U8

A Cloud in a room??

Membuat sistem

Membuat sistem adalah bagaimana
1. menamakan inputan-inputan
2. bagaimana memproses inputan (+,-,/,*) sehingga menghasilkan outputan

MS. Excel: Data analysis

Analysis tools
1. Anova: Single Factor
2. Anova: Single Factor With Replication
3. Anova: Two-factor Without Replication
4. Correlation
5. Covariance
6. Descriptive Statistics
7. Exponential smoothing
8. F-test two Sample using variance
9. Fourier analysis
10. Histogram
11. Moving Average
12. Random Number Generation
13. Rank and Percentile
14. Regression
15. Sampling

Data:
1. Single data
2. Group of data

Upon sets of data:
1. find the simmilliarity

Wolframalpha

http://www.wolframalpha.com/

s

Wolfram is the chief designer of wolfram alpha

MS. Excel: Perform a regression analysis

Their types

Types of regression:
1. Linear regression
2. Exponential regression
3. Multiple regression

Their calculating

Linear regression
x is dependent
y is independent


LOGEST function
you use it to analyze data that is non-linear

GROWTH function
Find points that lie along that curve

SLOPE function

Tables

"Building a table is build a list of questions"

"Building a table is listing all the components and its range of values"

When did you use Microsoft excel VBA

Use microsoft excel vba when do:
1. Repetitive task (search and find)
2. Modified task

But the basic is excel menu itself. The VBA is just its complement.

Thesaurus

The dinosaurus? No, thesaurus is similliarity of a meaning

Example:
Care = Mind, Worry, Attention, Custody, Caution, Treatment
Mind, worry, attention, custody, caution, treatment are care's similliar meaning

Code of success

Microsoft Excel Basic Coding

Yang berhubungan dengan Cell

How to refer to one cell in a particular sheet?
Style1: Using range property
Use: Range property + A1 Notation

Example:

Sub onecell()
    Sheet1.Range("A1").Select
End Sub

Style 2: Using index number
Use: Row Index number, Column index number, cells property
Example:
Sub onecell()
    Sheet1.cells(1,1).Select
End Sub

Note: Also good for used with looping statement.

How to refer to one cell that relative to another active cell? (Relativity)
Use: offset property
Example:
This can be both do to style 1 and style 2

Sub onecell()
    Sheet1.cells(1,1).offset(1,2).Value = 10
end sub


How to refer to cells (more than one cell)
Style1: Using A1 Notation
Use: Range property + A1 Notation
Example:
Sub manycells1()
    Sheet1.Range("A1:A3").Select
End Sub

Style2: Using Range Object
Use: dim, set, object variable

Example:
sub manycells2()
    dim a as range
    set a = sheet1.range("A1:A3")
    a.select
end sub

Style3: Using shortcut notation
As the title implies, this is the shorcut of using Range word. That is, you don't have to type word Range or use Quotation marks anymore for shortcuts.

Use: [A1:A2] or [MyRange] if you have define those cells in name manager.

Example:
Sub manycells()
    Sheet1.[MyRange].Select
End sub

Note: You don't have to type word "Range" or use Quotation marks after Sheet1.

How to refer to all cell in a particular sheet
Use: cells
Example:
sub allcell()
    sheet1.cells.activate
end sub

Yang berhubungan dengan Sheet

How to refer a one sheet?
Style 1:
Use Worksheets name
Example:
Sub onesheet()
    Worksheets("sheet2").Select
End Sub

Style2: 
Use Worksheets index number
Example:
Sub onesheet()
    Worksheets(2).Select
End Sub

How to refer to more than one sheets?
Use: worksheets property and array function
Example:
Sub several_sheets()
    worksheets(Array("Sheet1","Sheet2")).Select
end sub

How to refer to all sheet in a workbook?
Use: Worksheets property without specifications.
Example:
Sub all_sheet()
    Worksheets.Select
End Sub

Yang berhubungan dengan Workbook

How to create a new workbook
Use: workbooks.add
Example:
Sub AddOne()
    Workbooks.add
End sub

How to activate a workbook
Use: workbooks properties and book name(for i.e. : "book1")
Example:
Sub ActivateOne()
    Workbooks("book1").activate
End sub

How to open a workbook
Use: Open method and, path to the file
Example:
Sub OpenUp()
    Workbooks.Open ("C:\Mybook")
End Sub
How to save a workbook
Use: saves or save and path to the file

Example:
Sub Save()
    Workbooks("Mybook").SaveAs ("E:\Mybook")
End Sub

Now you have enough tool to do these tasks:
1. Copy and paste from sheet1 to sheet2
Untuk pemilihan sel saya lebih prefer menggunakan keyword range daripada cells (lebih praktis) meskipun untuk seleksi satu sel saja saya tetap menggunakan keyword range.

Sub copy_paste()
    Sheet1.Range("A1:A2").Copy
    Sheet2.Range("A1:A2").PasteSpecial
End Sub

Well, you can implement those with macro recording though.

2. Adding a comment on a cell or cells
Sub

List of methods (function) of a cell

List of methods (function) of a cell, a block of cells (they are having same methods):
1. Activate
2. AddComment
3. AdvancedFilter
4. ApplyNames
5. ApplyOutlineStyles
6. AutoComplete
7. AutoFill
8. AutoFilter
9. AutoFit
10. AutoOutline
11. BorderAround
12. Calculate
13. CalculateRowMajorOrder
14. CheckSpelling
15. Clear
16. ClearComments
17. ClearContents
18. ClearFormats
19. ClearNotes
20. ClearOutline
21. ColumnDifferences
22. Consolidate
23. Copy
24. CopyFromRecordSet
25. CopyPicture
26. CreateNames
27. Cut
28. DataSeries
29. Delete
30. DialogBox
31. Dirty
32. EditionOptions
33. ExportAsFixedFormat
34. FillDown
35. FillLeft
36. FillRight
37. FillUp
38. Find
39. FindNext
40. FindPrevious
41. FunctionWizard
42. Group
43. Insert
44. InsertIndent
45. Justify
46. ListNames
47. Merge
48. NavigateArrow
49. NoteText
50. Parse
51. PasteSpecial
52. PrintOut
53. PrintPreview
54. RemoveDuplicates
55. RemoveSubtotals
56. Replace
57. RowDifferences
58. Run
59. Select
60. SetPhonetic
61. Show
62. ShowDependents
63. ShowErrors
64. ShowPrecedents
65. Sort
66. SortSpecial
67. Speak
68. SpecialCells
69. SubscribeTo
70. SubTotal
71. Table
72. TextToColumns
73. Ungroup
74. Unmerge

Email component and their functions

MTA
1. Receives mail from client
2. forward mail between servers using SMTP

MDA
1. Resolves final delivery issues
2. performs actual delivery to user's mailbox

MUA
1.Client used to access and to read mail
2. retrieves mail using POP

DNS record type and the resources that it identifies

NS = Authoritative name server

CNAME = canonical or Fully Qualified Domain Name for an alias

MX = Maps a domain name to a list of mail exchange server for that domain

A = End device address

Cisco Packet Tracer 6.1 components

 Cisco Router:

1. Cisco 1841
2. Cisco 1941
3. Cisco 2620XM
4. Cisco 2621XM
5. Cisco 2811
6. Cisco 2901
7. Cisco 2911

Cisco Switch:

1. Cisco 2950-24
2. Cisco 2950T
3. Cisco 2960
4. Cisco 3560 24 PS

Server:

1. HTTP Server
2. DHCP server
3. TFTP server
4. DNS server
5. SYSLOG server
6. AAA server
7. NTP server
8. EMAIL server
9. FTP server
10. FIREWALL server
11. IPv6 FIREWALL

Router modules:

1. NM-1E
2. NM-1E2W
3. NM-1FE-FX
4. NM-1FE-TX
5. NM-1FE2W
6. NM-2E2W
7. NM-2FE2W
8. NM-2W
9. NM-4A/S
10. NM-4E
11. NM-8A/S
12. NM-8AM
13. NM-Cover
14. NM-ESW-161
15. HWIC-2T
16. HWIC-4ESW
17. HWIC-8A
18. HWIC-AP-AG-B
19. WIC-1AM
20. WIC-ENET
21. WIC-1T
22. WIC-2AM
23. WIC-2T
24. WIC-Cover

The 9 hardest things programmers have to do

1. Naming things
2. Explainning what I do and don't do
3. Estimating time to complete task
4. Dealing with other people
5. Working with someone else's code
6. Implementing functionality you disagree with
7. Writing documentation
8. Writing test
9. Designing a solution

Visual Basic LAB

7. Visual basic Errors
Error tergolong atas:
1. Logic error
2. Syntax error
3.

Panduan melihat error: Jendela Error list 

39. Messagebox
- Message/prompt
- Buttons
- Title
- Icon

dim a = msgbox ("Aloha?",vbYesNo, "Asek?")
if messagebox.show("click something", "title", messagebuttons.abort,

38. Toolbox
Button
- Dock : None, top,
Checkedlistbox:
   - item: hello, onlivegamer,
Checkbox




 37. Visual basic form properties
Changing (name):
- Mengubah nama panggilan form.

Changing backcolor:
- Mengubah warna layar utama jendela (bukan layar title).
- System color : Warna-warna yang biasanya digunakan pada sistem (Windows 7 misalnya)
- Web color: Warna yang biasanya digunakan dalam web. Web biasanya membutuhkan lebih banyak variasi warna. Makanya variasi warna web color lebih banyak dari system color.

Changing background image
- Mengubah gambar latar form
- Jika ukuran gambar yang digunakan lebih kecil dari ukuran layar, gambar akan di-tile

 Changing icon
- Mengubah gambar icon jendela formborder title

Changing formborder style
- None, fixedsingle, fixed3d,  fixeddialog, sizable, fixedtoolwindow, sizabletoolwindow
- None: Tidak pakai/tidak ada formborder
- Fixedsingle:
- Fixed3D
- FixedDialog
- Sizable
- Fixedtoolwindow
- Sizabletoolwindow


Change MaximizeBox
- Change whether form can be maximized or not

Change Minimize Box
- Change whether form can minimized or not

Change opacity
- Change the transparency of the form

Changing text (form's title)
- change form's title

Change transparency key
- 

Kondisi
Kondisi maju atau mundurnya suatu perusahaan tergantung dari pendapatan.
Besar / kecilnya pendapatan tergantung dari banyaknya barang yang terjual.

jika perusahaan maju, maka pendapatan besar.
jika perusahaan mundur, maka pendapatan kecil.

lebih ke sebab-akibat

if perusahaan = "maju" then console.writeline = "
else :
    if perusahaan = "mundur" then console.writeline ("Pendapatan kecil")
end if

Jika kasus diperluas, bahwa maju mundurnya perusahaan bukan hanya dari meningkatnya pendapatan, tapi juga berkurangnya pengeluaran

if pendapatan = "meningkat"
    if pengeluaran = "berkurang"
        then console.writeline ("Perusahaan maju")
else
    console.writeline ("Perusahaan tidak maju")

26. Visual Basic Form



23. Comparing String

 .compare


22. Replacing String
a = console.readline()
console.writeline(kata1.replace("Hello","Halo"))

21. Formatting string
21.1 Uppercasing
.toUpper
21.2 Lowercasing
 .toLower


20. Substring
sub main()
dim kata1 as String
kata1 = "Hello World!"
writeline(kata1.substring

End sub

19. Get length of String
Well, jika sesuatu direfer sebagai sesuatu, maka referensi itu mempunyai properti yang sama dan berbeda.
Contoh jika truk dibilang sama dengan mobil, maka truk pada umumnya mempunyai strir, ban, kaca, karena mobil memiliki itu semua.

Sejak kamu mereferensikan sebuah variabel sebagai string (pada waktu kamu mendeklarasikannya: dim kata1 as string), maka variabel itu juga memiliki apa yang dimiliki string.

Jika kamu mereferensikan variabel a sebagai string maka variabel a memiliki length,

Console.WriteLine(angka1.Length.Equals(10))

9. Math operators
+, -, *, /, ^, mod
Contoh syntax modulus:
4 mod 3

10. Declaring variabel and initialization
Berikut hanya deklarasi variabel:
Dim angka1 as Integer
Dim angka2 as Integer

Format deklarasi variabel jika dipersingkat menjadi:
Dim angka1, angka2 as Integer

Berikut deklarasi variabel sekaligus inisialisasi (pemberian nilai awal):
Dim angka1 as Integer = 10
Dim angka2 as Integer = 5

Disingkat menjadi?
Dim angka1, angka2 = 10, 5

3. Datatype primitives
Karena kita hanya berurusan dengan angka dan huruf saja, maka kita perlu variabel untuk menyimpan angka dan huruf itu. Angka dan huruf tersimpan di dalam. 

Data type untuk angka:
Double

Jika double, maka digit dibelakang koma maksimal = 14 dijit. Jika angka yang kamu masukkan 19 dijit dibelakang koma, maka 14 dijit dibelakang koma yang akan disimpan/ditampilkan dan 5 digit yang lainnya akan digenapkan.

Contoh:

sub main()
angka1 = 1.1234567891234568
Console.WriteLine(angka1)
end sub

Output:
 

Integer
Jika integer didesain untuk menyimpan bilangan bulat (bilangan tanpa koma), maka digit didepan koma maksimal = 10 dijit. Lebih daripada itu dijit yang lain tidak akan tersimpan.

Datatype untuk perhurufan

Char

Variabel bertipe char hanya mampu menyimpan 1 huruf saja. Jika kamu ingin menyimpan kata (lebih dari satu huruf) maka hanya 1 huruf saja yang tersimpan.

Contoh:

sub main()
dim kata1 as char
kata1 = "hello world apa kabarnya? Sehat kan? Sudahkah anda minum yakult hari ini?"
Console.WriteLine(angka1)
end sub

Output:


Well, hanya huruf h saja? Yup, betul. Variable char hanya muat 1 huruf!

String

Variabel bertipe string mampu menyimpan lebih dari satu huruf.

Contoh menggunakan contoh yang sama dengan contoh Char tapi variabel kata1 diubah menjadi variabel string:

sub main()
dim kata1 as String
kata1 = "hello world apa kabarnya? Sehat kan? Sudahkah anda minum yakult hari ini?"
Console.WriteLine(angka1)
end sub

Output:







Well, untuk peta lengkapnya adalah dibawah ini: Tapi kita sebagai programmer aplikasi sederhana cukup menggunakan integer, double, char, string saja. Kita sudah cukup bahagia.

 

VIsual Basic Language Features

Link
Materi:
1. Array
2. Collection Initializers
3. Constants and Enumerations
4. Control flow
5. Data types
6. Declared elements
7. Delegates
8. Early and late binding
9. Error types
10. Events
11. Interfaces
12. LINQ
13. Object and classes
14. Operators and expression
15. Procedures
16. Statements
17. Strings
18. Variables
19. XML

Lets learn some new words

Tipe-tipe industri

Tipe-tipe industri:
1. Advertising
2. Audit
3. Banking
4. Chemical Industry and Banking
5. Computer sience and system development
6. Consumer goods
7. Courier
8. Education and trainning consultant
9. Electrical and instrumentation
10. Entertainment and event organizer
11. Food and beverage
12. Foreign exchange and other financial sector
13. Hotel
14. Human resource service
15. Information technology
16. Insurance
17. Journalism
18. Legal
19. Logistics and transportation
20. Manufacturing
21. Marine
22. Mechanical and automotive service
23. Media and publishing
24. Mining
25. Multimedia
26. Oil & Gas and Geothermal production
27. Oil & Gas and Geothermal production and service
28. Oil & Gas and Geothermal services
29. Security
30. Sport
31. Telecommunication

How to refer to Cells and Ranges by using A1 notation (VBA)

You want to change value of many / more than one cells at once? You will use range property to do that.

Range properties is great and flexible meaning: Range can be used to refer 1 cell, and also many cells (a block).

You can refer to a cell, for instance we targeting cell A1's value:
sheet1.range("A1").value
we refer to cell A1's value that contained within.

And, you can also refer to many cells (more than 1 cell), for instance:
sheet.range("A1:A2").value
we refer to cell A1's and cell A2's value contained.

Essentially, you should help / navigate Range property with A1 notation.

What is A1 notation? A1 notation could be: A1, A1:A2, A:A, 1:1, A1:D5
A1 means: cell 1 column A
A1:A2 means: cell 1 column A and cell 2 column A
A:A means all cells in column A
1:1 means all cells in row 1
A1:D5 means a block start from A1 to D5. This kind a awkward, but try that on your VBA.


To recap all: in short explanation use this syntax: sheet.range("A1_Notation") and A1 notation could be: A1, A1:A2, A:A, 1:1, and A1:D5


So now try to combine/write them on your VBA editor:
Sheet1.range("A1").value
Sheet.range("A1:A2").value
Sheet.range("A:A").value
Sheet.range("1:1").value
Sheet.range("A1:D5").value

You are done!

PS: Did you notice that Ms. Excel is indexing his row and column with numeric (1, 2, 3, 4,...) and alphabet (A, B, C, D...). So, in referencing a cell in A1 notation, we must use this convention.

Quiz:
1. How could you refer to a block of cells/matrix (3 x 3) that start from D5?
Clue: Sheet1.Range("Start cell : End cell")

2.  Try this sheet.range("A:A, E6:H9").value = 10
What you see?

Wireless security settings on TP-LINK

We will observe this device:
150M Wireless Lite N Router
Model No. TL-WR740N / TL-WR740ND

WEP
Type: {Automatic, Open System, Shared Key}
WEP Key Format: {Hexadecimal, ASCII}
Key Selected WEP Key(Password) Key Type

Look below picture to clarify:

WPA/WPA2 - Enterprise
Version: {Automatic, WPA, WPA2}
Encryption: {Automatic, TKIP, AES}
Radius Server IP: ___
Radius Port: 1812 (1-65535, 0 stands for default port 1812)
Radius password: ___
Group Key Update Period: ___ (in second, minimum is 30, 0 means no update)

 

WPA/WPA2 - Personal
Version: {Automatic(Recommended), WPA-Personal, WPA2-Personal}
Encryption: {Automatic(Recommended), TKIP, AES}
Password: ___
(You can enter ASCII characters between 8 and 63 Hexadecimal characters between 8 and 64.)
Group Key Update Period: ___ seconds (Keep it default if you are not sure, minimum is 30, 0 means no update)

So whats the different between WPA/WPA2 - Enterprise and WPA/WPA2-Personal?