Wednesday, August 25, 2010

VLOOKUP Excel 2007

Fungsi VLOOKUP adalah fungsi yang dipergunakan untuk menemukan data tertentu dengan referensi dari table utama / tabel master.



Video ini menggunakan * Range_lookup = True
Anda bisa belajar banyak dari video yang sangat menarik ini diantaranya Fungsi Random VLOOKUP, dan Absolute in Excel (dengan tombol F4).

Tulisan ini membahas fungsi excel VLOOKUP. jika sumber data tidak ada maka VLOOKUP menghasilkan nilai #N/A yang artinya “Not Available” atau tidak ada nilai yang tepat. Hal ini sangat menolong kita supaya tidak terjadi kesalahan dalam pengambilan data.

* Lookup_value
Nilai apa yang akan kita cari
* Table_array
Table dimana tempat data yang akan dicari
* Col_index_num
Kolom yang keberapa yang akan dicari dari dari seluruh kolom yang di blok.
* Range_lookup
Diisi dengan true(1) atau false(0)
Amannya untuk menghindari salah mencari data pakai nilai false(0) -->> Exact Match --> benar-benar sama. (namun di video menggunakan toleransi atau nilai Range_lookup=1)

Pelengkap:
Penjelasan Absolut : http://fairuzelsaid.wordpress.com/2009/11/23/modul-microsoft-excel-alamat-sel-absolut/

Friday, August 20, 2010

Speed Eye Home Monitoring Telkom Speedy

Speed Eye Home Monitoring Telkom Speedy
Sistem Monitoring yang ditawarkan Telkom Speedy adalah sistem untuk monitoring home dan tempat bertipe residen, namun bisa juga untuk toko (tidak berskala besar).

Menariknya pihak telkom menyediakan ruang penyimpanan di server mereka untuk menyimpan file video yang dapat kita rekam dalam suatu kapasitas terbatas.

Manfaat yang mungkin akan sangat terasa adalah ketika seorang ayah memantau keadaan anak / bayinya di rumah, apakah anak / bayinya sedang istirahat atau sedang dalam ruangan.

Akan lebih baik bila yang digunakan untuk memantau adalah internet dari Jaringan Telkom (Telkom Speedy) karena seolah seperti jaringan lokal (tentunya jaringan Telkom sangat terkait dengan jaringan monitoring ini).

Bandwidth Lokal yang baik (tidak seperti bandwidth Internasional yang harus di share) harus mampu memberikan layanan terbaik bagi pelanggan. Untuk itu layanan ini harus mampu memberikan layanan yang baik karena hanya bisa digunakan bagi mereka yang menggunakan minimal paket 1MBps.

Dengan sebuah login, kita dapat memantau dari jaringan Internet menggunakan Flash maupun Mobile Phone asalkan koneksi memadai.

Berkembangnya layanan yang lebih berbasis konten menandakan akan berubahnya bisnis telco indonesia dari yang mutlak ke layanan telekomunikasi ke arah informasi, media dan konten edukasi dan entertainment.

Thursday, August 19, 2010

Menghapus / Delete file dengan PHP menggunakan fungsi UNLINK

Bagaimana kita dapat menghapus file dengan menggunakan bahasa pemrograman PHP? PHP telah menyediakan sebuah fungsi untuk penghapusan FILE. sayangnya saya tidak mempergunakan sebelum-sebelumnya dikarenakan sebuah keinginan untuk historical data. Namun sebaiknya file file yang datanya di dalam database terhapus sebaiknya ikut kita hapus, karena bakal memenuhkan ruang penyimpanan saja.

Berikut ini adalah cara sederhana untuk Menghapus / Delete file dengan PHP menggunakan fungsi unlink()

Kronologi :

  1. Menghapus data di database (Salah satu field data di database tersebut menyimpan nama file yang akan dihapus).
  2. File ikut terhapus dengan menyertakan fungsi unlink() di dalam syntax PHP.
  3. Data dan File Terhapus, menghemat beban database dan Disk Space.
  4. Selesai
Di dalam Program



if($_GET[action]=="delete"){
// dapatkan nama file
$sql_="select id_video, judul, file
from tb_video where id_video=$_GET[id]";
$hasil_=mysqli_query($link,$sql_);
$data_=mysqli_fetch_array($hasil_);

//delete row

$sql = "delete from tb_video where id_video=$_GET[id]";
$hasil = mysqli_query($link,$sql);

//delete file
if($hasil_) {
unlink("../source/$data_[file]");
}

//reload page otomatis dengan javascript
echo "<script language=javascript>
alert('Data Berhasil Dihapus');</script>";
echo '<script type=text/javascript>
<!--
window.location = "index.php"
//-->
</script>';
}




Demikian sebuah contoh sederhana untuk Menghapus / Delete file dengan PHP menggunakan fungsi UNLINK. Semoga membantu

Wednesday, August 18, 2010

Apply Mathematics in Our Daily Life.

Often the mathematics that we know and are present in front of us is full of mathematical formulas, abstract, theoretical and dry. But is it true that mathematics is dry and only purely theoretical formulas as well as abstract?

Actually there are many other interesting side of mathematics. Unfortunately, we don't know deeply so far, because rarely touched or not present when we learn mathematics in school. There are many interesting side of mathematics if we explored. There are a magic numbers that sometimes feels no sense, there are games that make us stunned, amazed, silly stories that led to the discovery of new math concepts, graphical visualization like beautiful painting of the set function, and etc..

We would agree to admit that math is essential for human life. Imagine how the world today without Math? Could we watching TV, playing computer games, talking with friends over the phone or SMS's? Imagine what a mess this world if people do not know the numbers. What happens if people can not understand the space where they stand / exist, can not understand the price of goods in a store?


It's no doubt about it, Math is pretty important role in human life. Many things have been contributed to the development of human civilization by Mathematics. Do we know that mathematics also played a role in determining the direction and content of philosophical thoughts, in providing answers to fundamental questions about human nature and the world?


"Everything is numbers" that was the Pythagorean philosophy to mathematics. Maybe we will be puzzled to interpret the statement. But that was philosophy, not philosophy if not confusing. It seems that Pythagoras expressed are unreasonable, but what he meant isn't without meaning at all. He discovered the importance of numbers in music, and he built relationships between music and math in mathematical terms, like "The average value of harmony" and "progressions of harmony".


Pythagoras considered numbers as forms, as it existed on the dice or card games. We also still inherit it until now by using terms like square numbers or number two and number cube rank to rank number three, which is none other than the terms derived from Pythagoras. He also uses the term square numbers, triangular numbers, pyramidal numbers, and so forth. Numbers actually represent the number of pebbles used to compile the relevant forms.


Well, apparently that was related to the Pythagorean view that this world is atomic, and assume the body is made up of molecules composed of atoms arranged in various forms. In this case he wants to arithmetic as a field of study that became the basis of the physical sciences as well as aesthetics.

Often we realize Math was the basic of other science like physic, algebra, calculus, chemistry, economics, etc when it using numeric calculation. Sometimes it has it own way to do calculation. The variety way of complexity and problem can be simplify with our math knowledge. We need to understand and convert the problem in the form of Math.

College student sometimes need math help in lesson to find out the real life problem solving. This is the best way to apply math in daily life. The most pure math science maybe about Calculus or Algebra. Calculus or Algebra often use in Programming and Optimization. Algebra help may be ask when any problem of similarity or dissimilarity explain by the teacher. Calculus help may be ask when we found integral or differential problem in our application. The help can be ask to explain about the position of Algebra or Calculus in the application.

A little bit different about Physic, it was more applicable in daily life, like mass, energy, electromagnetic, etc. But the variety of the physic study material need intensive physics help explanation to give easy to understand way to learn physics.

A lot of discussion at the lesson about real life application would reduce  probability of the needs of homework help to the parent at home. But if any math problems or difficulties happen and we need a simplify problem solving, there is a competitive website providing it.

Tuesday, August 17, 2010

Nokia X3-02 Touch and Type REVIEW|PRICE

REVIEW|PRICE OF Nokia X3-02 Touch and Type
Nokia X3-02 Touch and Type
Nokia X3-02 Touch and TypeThe Nokia X3-02 Touch and Type REVIEW and SPECIFICATIONS
The Nokia X3-02 Touch and Type is the first phone from Nokia to feature both a touch screen and the more traditional keypad. This best-of-both-worlds approach allows users to have all the fun of the touch screen experience, while keeping the undeniable practical benefits and ease of use that a keypad provides.

In terms of outward appearance, the Nokia X3 isn’t really breaking any new ground, but the 2.4” touch screen and super-slim design give the phone a modern, sleek look. Add to this the brushed aluminium cover, available in a range of 5 colours, and Nokia have a phone that would look good in anyone’s pocket.

Despite two sets of controls, though, the X3 Touch and Type is one of Nokia’s thinnest devices: it’s 9.6mm deep, 106mm tall, 48mm wide and weighs just 78g. The brushed aluminium finish and choice of five colours are also likely to appeal to fashion-conscious mobilists.

Even though it has a svelte profile, the X3 Touch and Type is full of features. It comes with four bands for voice, 3G, HSPA and WiFi for data, a music player and an FM radio. Mobile photographers get a 5-megapixel camera, with 4X digital zoom, which takes both still images and videos. The Communities app will keep you up-to-date with Twitter and Facebook.

The X3 Touch and Type has also got dedicated music and messaging keys for quick access to the music player and email. All the regular webmail and chat services are catered for by the included applications. Apps downloaded from the Ovi Store can be used through the 2.4-inch touch screen, so users don’t miss out on any of the latest games or productivity apps. They can also use the keys, of course, if they prefer, or adopt a hybrid approach.

PRICE: €125 (about £100)

SPECIFICATIONS
General
2G Network GSM 850 / 900 / 1800 / 1900
3G Network HSDPA 850 / 900 / 1900 / 2100
Announced 2010, August
Status Coming soon. Exp. release 2010, Q3

Size
Dimensions 106.2 x 48.4 x 9.6 mm, 45.2 cc
Weight 78 g

Display
Type TFT resistive touchscreen, 256K colors
Size 240 x 320 pixels, 2.4 inches

Sound
Alert types Vibration, MP3 ringtones
Speakerphone Yes
- 3.5 mm audio jack
- Dedicated music key

Memory
Phonebook Yes, Photocall
Call records Yes
Card slot microSD, up to 16GB

Data
GPRS Class 10 (4+1/3+2 slots), 32 - 48 kbps
EDGE Class 10, 236.8 kbps
3G HSDPA, HSUPA
WLAN Wi-Fi 802.11 b/g/n
Bluetooth Yes, v2.1 with A2DP
Infrared port No
USB Yes, v2.0 microUSB

Camera
Primary 5 MP, 2592 x 1944 pixels
Video Yes
Secondary No

Features
Messaging SMS, MMS, Email, IM
Browser WAP 2.0/xHTML, HTML
Radio Stereo FM radio with RDS
Games Yes + downloadable
Colors White Silver, Dark Metal, Petrol Blue, Pink, Lilac
GPS No
Java Yes, MIDP 2.1
- Windows Live Messenger, Yahoo Messenger, Gtalk
- Facebook, Twitter
- MP4/H.263 player
- MP3/WAV/eAAC+ player
- Organizer
- Voice memo
- T9

Battery

Standard battery, Li-Ion (BL-4S)
Stand-by Up to 408 h (2G) / Up to 408 h (3G)
Talk time Up to 5 h 20 min (2G) / Up to 3 h 30 min (3G)

My Blog List

Pages