
Contoh, perumusannya untuk Juara 1:
=INDEX(B3:C12;MATCH(LARGE(C3:C12;{1});$C$3:$C$12;0);1)&" JUARA 1 DENGAN NILAI "&LARGE(C3:C12;{1})

Visual Basic Interface


Label: Tutorial Triks dan Tips Excel 2007
Diposting oleh Verynandus Hutabalian di 11.24 0 komentar
| 1 UserForm | Name: Form1 Text: Deret Fibonacci V. Hutabalian's Blog  | 
| 1 ListBox | Name: ListBox1 | 
| 2 Button | Name:Button1 Text: Proses Deret Name: Button2 Text: Exit  | 
| 1 Label | Name:Label1 Text: Panjang Deret Bilangan  | 
| 1 NumericUpDown | Name:NumericUpDown1 | 



Label: Tutorial Interface VB 2008
Diposting oleh Verynandus Hutabalian di 10.45 0 komentar


Label: Serba-Serbi Anak Kos
Diposting oleh Verynandus Hutabalian di 19.48 0 komentar
| 1 UserForm | Name: Form1 Text: Graphic VB6 Component Vs VB 2008  | 
| 1 PictureBox | Name: PictureBox1 | 
| 1 Button | Name:Button1 Text: View Graphic  | 
| 1 UserForm | Name: Form1 Text: V. Hutabalian's Blog VB6 Vs VB 2008  | 
| 1 PictureBox | Name: PictureBox1 | 
| 1 Button | Name:Button1 Text: View Graphic  | 




Label: Tutorial Interface VB 2008
Diposting oleh Verynandus Hutabalian di 11.01 0 komentar






Label: Tutorial Interface VB 2008
Diposting oleh Verynandus Hutabalian di 12.42 0 komentar

Aplikasi kali ini saya akan memvisualisasikan Graphic 3D Form Paint. Baru-baru ini, saya iseng-iseng mencari tutorial programming Graphic 3D dan menemukan contoh script programnya. Source Code Tutorialnya ===>>> Klik Disini, mengamati coding script programming-nya membuat kepala Nyut-nyutan,....
Kok bisa yahhhh programmer neh coding script kayak beginiannnn......dan Saya sangat berharap menemukan suatu celah atau inspirasi untuk dikembangkan menjadi graphic 3D yang lebih aplikative (harapannya sehh........). Graphic 3D yang ditampilkan berupa Cube 3D.
Sekarang saya coba menampilkan hasil visual dari Script VB.net dari Source Code ===>> Disini Klik Neh.... Tutorialnya. Hasil visualnya perhatikan gambar di atas.
ToolBox yang saya pergunakan, perhatikan tabel di bawah ini:1 UserForm Name: UserForm1 
Text: Programming Graphics 3D V. Hutabalian's Blog
Desain Form dari tabel ToolBox di atas, perhatikan gambar di bawah ini.
Setelah selesai mempersiapkan desain Form, dengan mensetting properties Form sesuai dengan yang saya inginkan. Kemudian klik kanan pada Form, pilih View Code saya mengetikkan Source Program di bawah ini.
Script Visual Basic 2008 Express Edition:
'+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++'
'3D Programming Graphics Visual Basic Express Edition'
'======================================================================='
' Source code Tutorial===>>> Klik Disini'
' Berbagi ilmu Sensasi Kepuasan Tersendiri '
' Visual By: Verynandus Hutabalian'
' Publish to V. Hutabalian's Blog 18 Agustus 2010 '
'+++++++++++++++++++++++========================++++++++++++++++++++++++'
Imports System
Imports System.Drawing
Imports System.Drawing.Drawing2D
Public Enum RotateHorizontal
 Left = -1
 Center = 0
 Right = 1
End Enum
Public Enum RotateVertical
 Up = -1
 Center = 0
 Down = 1
End Enum
Public Enum CubeSides
 Left
 Right
 Top
 Bottom
 Front
 Back
End Enum
Public Structure Cube
 Private FLocation As Point
 Private FHeight As Integer
 Private FWidth As Integer
 Private FDepth As Integer
 Private FCenter As Point
 Private FPath As GraphicsPath
 Private FRotateX As RotateHorizontal
 Private FRotateY As RotateVertical
 Public Property Location() As Point
     Get
         Return FLocation
     End Get
     Set(ByVal Value As Point)
         FLocation = Value
         Changed()
     End Set
 End Property
 Public Property Height() As Integer
     Get
         Return FHeight
     End Get
     Set(ByVal Value As Integer)
         FHeight = Value
         Changed()
     End Set
 End Property
 Public Property Width() As Integer
     Get
         Return FWidth
     End Get
     Set(ByVal Value As Integer)
         FWidth = Value
         Changed()
     End Set
 End Property
 Public Property Depth() As Integer
     Get
         Return FDepth
     End Get
     Set(ByVal Value As Integer)
         FDepth = Value
         Changed()
     End Set
 End Property
 Public Property Center() As Point
     Get
         Return FCenter
     End Get
     Set(ByVal Value As Point)
         FCenter = Value
         Changed()
     End Set
 End Property
 Public ReadOnly Property Path() As GraphicsPath
     Get
         Return FPath
     End Get
 End Property
 Public Property RotateX() As RotateHorizontal
     Get
         Return FRotateX
     End Get
     Set(ByVal Value As RotateHorizontal)
         FRotateX = Value
         Changed()
     End Set
 End Property
 Public Property RotateY() As RotateVertical
     Get
         Return FRotateY
     End Get
     Set(ByVal Value As RotateVertical)
         FRotateY = Value
         Changed()
     End Set
 End Property
 Public ReadOnly Property X() As Integer
     Get
         Return FLocation.X
     End Get
 End Property
 Public ReadOnly Property Y() As Integer
     Get
         Return FLocation.Y
     End Get
 End Property
 'Return the rectangle that bounds the entire polygon
 'representing the cube
 Public ReadOnly Property BoundsRect() As Rectangle
     Get
         If (FPath Is Nothing) Then
             Return New Rectangle(0, 0, 0, 0)
         Else
             Dim r As RectangleF = Path.GetBounds()
             ' Implicit conversion from single to integer,
             ' really only available in VB
             Return New Rectangle(r.X, r.Y, r.Width, r.Height)
         End If
     End Get
 End Property
 Public ReadOnly Property Item(ByVal index As CubeSides) As Point()
     Get
         Select Case index
             Case CubeSides.Back
                 Return Back
             Case CubeSides.Front
                 Return Front
             Case CubeSides.Left
                 Return Left
             Case CubeSides.Right
                 Return Right
             Case CubeSides.Top
                 Return Top
             Case CubeSides.Bottom
                 Return Bottom
             Case Else
                 Return Front
         End Select
     End Get
 End Property
 Public ReadOnly Property Top() As Point()
     Get
         Return GetTop(Location, Height, Width, Depth, _
                       RotateX, RotateY)
     End Get
 End Property
 Public ReadOnly Property Bottom() As Point()
     Get
         Return GetBottom(Location, Height, Width, Depth, _
                          RotateX, RotateY)
     End Get
 End Property
 Public ReadOnly Property Left() As Point()
     Get
         Return GetLeft(Location, Height, Width, Depth, _
                        RotateX, RotateY)
     End Get
 End Property
 Public ReadOnly Property Right() As Point()
     Get
         Return GetRight(Location, Height, Width, Depth, _
                         RotateX, RotateY)
     End Get
 End Property
 Public ReadOnly Property Front() As Point()
     Get
         Return GetFront(Location, Height, Width, Depth, _
                         RotateX, RotateY)
     End Get
 End Property
 Public ReadOnly Property Back() As Point()
     Get
         Return GetBack(Location, Height, Width, Depth, _
                        RotateX, RotateY)
     End Get
 End Property
 Public Sub New(ByVal x As Integer, ByVal Y As Integer, _
     ByVal height As Integer, ByVal width As Integer, _
     ByVal depth As Integer, ByVal rotateX As RotateHorizontal, _
     ByVal rotateY As RotateVertical)
     FPath = New GraphicsPath
     FLocation = New Point(x, Y)
     FHeight = height
     FWidth = width
     FDepth = depth
     FRotateX = rotateX
     FRotateY = rotateY
     FCenter = New Point(Location.X + (width + depth / 2 * _
                                       rotateX) / 2, _
         Location.Y + (height + depth / 2 * rotateY) / 2)
     ConstructPath()
 End Sub
 Public Sub New(ByVal x As Integer, ByVal Y As Integer, _
         ByVal height As Integer, ByVal width As Integer, _
         ByVal depth As Integer)
     FPath = New GraphicsPath
     FLocation = New Point(x, Y)
     FHeight = height
     FWidth = width
     FDepth = depth
     FRotateX = RotateHorizontal.Right
     FRotateY = RotateVertical.Up
     FCenter = New Point(Location.X + (width + depth / 2 * _
                                       RotateX) / 2, _
         Location.Y + (height + depth / 2 * RotateY) / 2)
     ConstructPath()
 End Sub
 Public Sub New(ByVal point As Point, _
     ByVal height As Integer, ByVal width As Integer, _
     ByVal depth As Integer)
     FPath = New GraphicsPath
     FLocation = point
     FHeight = height
     FWidth = width
     FDepth = depth
     FRotateX = RotateHorizontal.Right
     FRotateY = RotateVertical.Up
     FCenter = New Point(Location.X + (width + depth / 2 * _
                                       RotateX) / 2, _
         Location.Y + (height + depth / 2 * RotateY) / 2)
     ConstructPath()
 End Sub
 Private Sub Changed()
     ConstructPath()
 End Sub
 Private Sub ConstructPath()
     FPath = New GraphicsPath
     Path.AddLines(GetBack(Location, Height, Width, Depth, _
                   RotateX, RotateY))
     Path.AddLines(GetFront(Location, Height, Width, Depth, _
                   RotateX, RotateY))
     Path.AddLines(GetTop(Location, Height, Width, Depth, _
                   RotateX, RotateY))
     Path.AddLines(GetBottom(Location, Height, Width, Depth, _
                   RotateX, RotateY))
     Path.AddLines(GetLeft(Location, Height, Width, Depth, _
                   RotateX, RotateY))
     Path.AddLines(GetRight(Location, Height, Width, Depth, _
                   RotateX, RotateY))
 End Sub
 Private Function GetXFromCenter(ByVal newCenter As Point) _
         As Integer
     Return newCenter.X - (FWidth + FDepth / 2 * FRotateX) / 2
 End Function
 Private Function GetYFromCenter(ByVal newCenter As Point) _
         As Integer
     Return newCenter.Y - (FHeight + FDepth / 2 * FRotateY) / 2
 End Function
 Public Sub FilleRectangle(ByVal boundingRect As Rectangle)
     Dim x As Integer
     If (FRotateX = RotateHorizontal.Right) Then
         x = 0
     Else
         x = Math.Abs(Depth / 2 * FRotateX)
     End If
     Dim y As Integer
     If (FRotateY = RotateVertical.Down) Then
         y = 0
     Else
         y = Math.Abs(Depth / 2 * RotateY)
     End If
     FLocation = New Point(x, y)
     FWidth = boundingRect.Width - Depth / 2 - 1
     FHeight = boundingRect.Height - Depth / 2 - 1
     ConstructPath()
 End Sub
 Public Function GetCube() As GraphicsPath
     Return FPath
 End Function
 Public Function GetSides(ByVal theseSides As CubeSides()) _
        As GraphicsPath
     Dim newPath As GraphicsPath = New GraphicsPath
     Dim I As Integer
     For I = 0 To theseSides.Length - 1
         newPath.AddLines(Item(theseSides(I)))
     Next I
     Return newPath
 End Function
 Public Shared Function GetXOffset(ByVal depth As Integer, _
     ByVal rotateX As RotateHorizontal) As Integer
     Return depth / 2 * rotateX
 End Function
 Public Shared Function GetYOffset(ByVal depth As Integer, _
     ByVal rotateY As RotateVertical) As Integer
     Return depth / 2 * rotateY
 End Function
 Public Shared Function GetTop(ByVal point As Point, _
                               ByVal height As Integer, _
                               ByVal width As Integer, _
                               ByVal depth As Integer, _
                               ByVal rotateX As RotateHorizontal, _
                               ByVal rotateY As RotateVertical) _
                                     As Point()
     Return New Point() { _
         New Point(point.X, point.Y), _
New Point(point.X + GetXOffset(depth, rotateX), point.Y + _
GetYOffset(depth, rotateY)), _
         New Point(point.X + width + GetXOffset(depth, rotateX), _
point.Y + GetYOffset(depth, rotateY)), _
         New Point(point.X + width, point.Y), _
         New Point(point.X, point.Y)}
 End Function
 Public Shared Function GetLeft(ByVal point As Point, _
        ByVal height As Integer, _
 ByVal width As Integer, ByVal depth As Integer, _
       ByVal rotateX As RotateHorizontal, _
 ByVal rotateY As RotateVertical)
     Return New Point() {New Point(point.X, point.Y), _
         New Point(point.X + GetXOffset(depth, rotateX), _
             point.Y + GetYOffset(depth, rotateY)), _
         New Point(point.X + GetXOffset(depth, rotateX), _
             point.Y + GetYOffset(depth, rotateY) + height), _
         New Point(point.X, point.Y + height), _
         New Point(point.X, point.Y)}
 End Function
 Public Shared Function GetRight(ByVal point As Point, _
        ByVal height As Integer, _
     ByVal width As Integer, ByVal depth As Integer, _
     ByVal rotateX As RotateHorizontal, ByVal rotateY _
           As RotateVertical)
     Return New Point() {New Point(point.X + width, point.Y), _
         New Point(point.X + width + GetXOffset(depth, rotateX), _
                   point.Y + GetYOffset(depth, rotateY)), _
         New Point(point.X + width + GetXOffset(depth, rotateX), _
                   point.Y + GetYOffset(depth, rotateY) + height), _
         New Point(point.X + width, point.Y + height), _
         New Point(point.X + width, point.Y)}
 End Function
 Public Shared Function GetBottom(ByVal point As Point, _
        ByVal height As Integer, _
        ByVal width As Integer, ByVal depth As Integer, _
        ByVal rotateX As RotateHorizontal, _
        ByVal rotateY As RotateVertical) As Point()
     Return New Point() {New Point(point.X, point.Y + height), _
         New Point(point.X + GetXOffset(depth, rotateX), _
             point.Y + GetYOffset(depth, rotateY) + height), _
         New Point(point.X + width + GetXOffset(depth, rotateX), _
             point.Y + GetYOffset(depth, rotateY) + height), _
         New Point(point.X + width, point.Y + height), _
         New Point(point.X, point.Y + height)}
 End Function
 Public Shared Function GetFront(ByVal point As Point, _
        ByVal height As Integer, _
        ByVal width As Integer, ByVal depth As Integer, _
        ByVal rotateX As RotateHorizontal, ByVal rotateY _
        As RotateVertical) As Point()
     Return New Point() {point, New Point(point.X + width, point.Y), _
         New Point(point.X + width, point.Y + height), _
         New Point(point.X, point.Y + height), point}
 End Function
 Public Shared Function GetBack(ByVal point As Point, _
        ByVal height As Integer, _
        ByVal width As Integer, ByVal depth As Integer, _
        ByVal rotateX As RotateHorizontal, _
        ByVal rotateY As RotateVertical) As Point()
     Dim topLeft As Point = New Point(point.X + _
         GetXOffset(depth, rotateX), _
         point.Y + GetYOffset(depth, rotateY))
     Dim topRight As Point = New Point(point.X + width + _
         GetXOffset(depth, rotateX), point.Y + _
         GetYOffset(depth, rotateY))
     Dim bottomRight As Point = New Point(point.X + width + _
         GetXOffset(depth, rotateX), point.Y + height + _
         GetYOffset(depth, rotateY))
     Dim bottomLeft As Point = New Point(point.X + _
         GetXOffset(depth, rotateX), point.Y + height + _
         GetYOffset(depth, rotateY))
     Return New Point() {topLeft, topRight, bottomRight, _
                         bottomLeft, topLeft}
 End Function
End Structure
Public Class Form1
 Inherits System.Windows.Forms.Form
 Private cube As Cube = New Cube(100, 100, 100, 200, 50)
 Private Sub Form1_Paint(ByVal sender As Object, _
   ByVal e As System.Windows.Forms.PaintEventArgs) _
   Handles MyBase.Paint
     e.Graphics.DrawPath(Pens.Red, cube.GetCube())
 End Sub
End Class
Setelah Anda mengetikkan listing source program diatas tekan F5, maka hasil tampilan visualnya seperti gambar di bawah ini.
Saya sangat berharap bisa mempelajari dan mengembangkan script programming Tutorial Graphics 3D di atas dalam bentuk yang aplikative... Untuk sekarang masih di Plototin Doang......Bagi rekan-rekan yang lebih berpengalaman di tunggu saran-sarannya dan kreativitasnya... Semoga dapat Berguna.
Selamat mencoba Guys! Nantikan Tips Aplikasi Cantik Lainnya by Verynandus Hutabalian.
Label: Tutorial Interface VB 2008
Diposting oleh Verynandus Hutabalian di 22.40 0 komentar
| 1 UserForm | Name: UserForm1 Text: Graph Sin, Cos, Tan V. Hutabalian's Blog  | 
| 1 PictureBox | Name: PictureBox1 | 
| 2 Label | Name:Label1 & 2 Text Label1: Amplitudo Text Label2: Frekuensi  | 
| 3 RadioButton | Name1:Sinus Name2:Cosinus Name3:Tangent Text Sinus: Sinus Graph Text Cosinus: Cosinus Graph Text Tangent: Tangen Graph  | 
| 2 Button | Name:Button1& 2 | 
| 2 ComboBox | Name:ComboBox1& 2 | 






Label: Tutorial Interface VB 2008
Diposting oleh Verynandus Hutabalian di 12.40 2 komentar

Layanan Online merupakan layanan yang praktis, pakai atau gunakan ketika diperlukan. Apalagi hanya untuk mengconvert suatu File dalam format yang berbeda, saya tidak perlu mendownload software aplikasinya dan menginstallnya ke komputer. Software yang diberikan kadangkala Free Trial/limited, yang setelah batas waktu pemakaian yang diberikan tidak bisa digunakan kembali dan akhirnya jadi sampah tak berarti, kadangkala harus di update secara berkala dan yang paling mengesalkan hasil/output PDF-nya bertuliskan nama lisensi produk converternya (Huhhhhhhhhhhhhhhhhhh). Mungkin hal ini merupakan suatu hal yang tidak asing bagi sebagian pengunjung Blog saya tapi ada kemungkinan ini merupakan hal yang baru bagi sebagian pengunjung lainnya.
Saya menggunakan layanan online Word2PDF Converter Situsnya ===>>>  Klik Disini Bro/Sis.
Perhatikan langkah-langkahnya sebagai berikut:
Pertama sekali, tentunya buka layanan onlinenya ===>>>  Situsnya .
Kedua, Perhatikan gambar tampilan situsnya. Terdapat beberapa menu: Doc2PDF, PDF2Word, PDF2HTML, Web2PDF. Misalkan sebagai contoh saya meng-convert file document word saya ke format PDF, kemudian Tekan Tombol "Convert Documents to PDF" . Perhatikan gambar di bawah ini.
Ketiga, Tekan tombol Browse. Kemudian saya mencari keberadaan file yang akan saya convert ke format PDF di komputer saya. Setelah itu saya mengisikan alamat email saya, agar hasil convertnya dikirimkan langsung ke alamat email yang saya berikan tersebut. Perhatikan gambar dibawah ini.
Gambar ini setelah File di upload dan alamat email saya yang telah diisikan.
Keempat, pada laman yang sama terdapat tombol Conver to PDF. Klik Tombol tersebut. Perhatikan gambar di bawah ini.
Kelima, Maka hasil PDFnya akan dikirim ke alamat email yang saya berikan. Perhatikan gambar di bawah ini.
Keenam, untuk mendownloadnya Saya harus membuka email saya. Perhatikan gambar di bawah ini, Inbox email saya yang telah di kirimkan hasilnya.
Ketujuh, Buka dengan mengklik pesan yang dikirimkan. Perhatikan gambar di bawah ini setelah pesan di buka.

Saya menarik Scroll di kiri email saya karena pesan yang di kirimkan terlalu panjang. Saya meng-cut gambarnya menjadi beberapa bagian, Hasil convert PDFnya ada di bagian paling bawah dan saya menekan download untuk menyimpan file tersebut ke komputer saya.
Anda bisa menggunakan fasilitas converter lainya tidak hanya Word2PDF tapi dapat juga dengan format converter yang berbeda pada layanan yang diberikan oleh situs tersebut, Selamat mencoba.
Label: Serba-Serbi Anak Kos
Diposting oleh Verynandus Hutabalian di 18.04 1 komentar
 		My blog is worth $564.54.
How much is your blog worth?
Copyright © September 2009 | Berbagi Tutorial | Berbagi Visual Basic 2008 | Dunia Science
Blog by: V. Hutabalian Tips & Triks