Solvingcorner

You are browsing the archives of 2008 August.

Travelling in Jakarta is very confusing, especially if you don’t own a car or at least a motorcycle. I can’t drive both car or motorcycle, so I become very dependant with public transportation. Different kind of area have different kind of transportation. Bigger buses have larger area to cover, while medium to small buses have [...]

I have lived in Jakarta for as long as I can remember. As a capital city of Indonesia, Jakarta has many problems. One of the most listed problem is traffic. Everytime you look around in the street, there’s always a long line of cars, motorcycle, bus, bajaj (3 wheeled vehicle). No place for you to walk by God most precious Gift; Feet. Most of pedestrian is replaced by “pedagang kaki lima”.

Level Easy
Ver Excel 2000 atau lebih tinggi
COUNTIF syntax =COUNTIF(range, category)
Kita bisa menghitung dengan mudah jumlah record atau data menggunakan COUNT.

Jika anda berniat untuk mengirimkan sesuatu melalui Garuda, berikut ini beberapa tips yang mungkin bisa membantu.

Jika anda membawa kendaraan sendiri siapkan uang pas sebesar Rp. 4.000. Disini bayar parkir tarifnya cukup mahal 1 jam pertama Rp. 4.000. Tips: Ingat karcis jangan sampai hilang nanti akan diminta kembali pada saat anda meninggalkan cargo area, jika hilang [...]

Level Easy
Ver Excel 2000 or above
Microsoft Excel has built in Logic Function like NOT, AND, OR. Observe the picture below.
Look at Cell D5, the formula is =NOT(A5>60). Cell A5 is NOT smaller than 60. Is it True? TRUE
Look at Cell D6, the formula is =AND(A6<=50,B6>=70). While B6<=70 = TRUE, A6<=65 = FALSE. Because the operator [...]

Level Easy
Ver Excel 2000 or above
SUMIF syntax =SUMIF(range, criteria, [sub_range])
Look at the picture below;
We can easily total it in Cell B8 with formula =SUM(B2:B7). The Total is 1727. But, what if we have to total each of the item? We need to know how much NP, how much Mag, and how much Tab.
The Formula for [...]

I remember watching a movie called Finding Forrester. It’s about writing. William Forrester (played by Sean Connery) advised Jamal Wallace how to write a book. Forrester said that if you want to write, just write, think later. Don’t look back. Just write what’s on your mind. Don’t stop for mistype, don’t stop for wrong spelling, just write. You can do fixing things later.

I’m sure there are thousands tips, tutorial and e-book about working at Home with Internet. It’s not all new that you can get paid by just sitting in front of your PC and writing your thoughts. So, where do you begin? The first thing you have to do is build a website.