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