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/

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.

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

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.