COUNTIF KURANG DARI

Untuk membayar hutang tulisan saya sebanyak 5 hari.. hari ini saya produksi satu tulisan lagi.. hitung-hitung nyicil.. harapannya tetep bisa memproduksi 365 posting dalam satu tahun.. resolusi!

Tadi, salah seorang rekan saya, sebut saja Prettong *bukan nama sebenarnya* menanyakan sesuatu tentang penggunaan Excel. Pertanyaannya sederhana: "Mas.. cara ngitung jumlah cell yang nilainya dibawah *sebut saja* 7 gimana?". "hemm.. menggelitik" benakku.

Tau sih bakalan pake COUNTIF. struktur COUNTIF ini sendiri biasanya =COUNTIF(range, criteria). Tapi biasanya langsung ngerefer ke jumlah sama dengan atau kondisi tertentu atau nilai cell tertentu,  gak pake lebih dari, kurang dari, kurang dari sama dengan, lebih dari sama dengan, atau embel-embel apapun itu..

Tanpa banyak bicara, langsung pencet F1. Ya..anda benar!!! fitur Help di Excel adalah gudang bantuan yang penuh dengan harta karun jawaban namun tersembunyi di hutan keyword search help. Beruntung saya tahu keyword yang tepat. That's right, COUNTIF. scroll dikit... eh ketemu.. Yay..!!! happy me :)

Rupanya klo kasus diatas kita cukup menggunakan "<7" sebagai kriterianya, cukup simpel bukan. jadi rumus yang digunakan adalah =COUNTIF($B$2:$F$7;"<7"). Tapi klo gak pernah pakai, ya mana bisa tau. Manfaatnya nolong temen, kadang-kadang ikut bantu nolong diri sendiri (untuk belajar) menambah pengetahuan.

Tambahan: mungkin teman-teman memperhatikan klo disana da cell yang referensinya hilang (C7) dan merupakan karakter "-"(C6). Jangan khawatir klo ini bakal ikut keitung karena dianggap nol, karena setelah saya coba dengan angka yang lebih besar, rupanya jumlah nilai yang terjaring sama yaitu 8.

Well that's all for today.. oiya, klo ada yang penasaran dengan kalimat yang dibawah tabel tersebut "Pake UDF Hitung Warna" itu apa maksudnya.. pantengin terus blog ini.. you'll get the answer tomorrow.. or the day after tomorrow, or maybe next week.. just wait :D

See you on my another post :) *jangan lupa komen klo bermanfaat ya, i really apreciate it :)

Resolution are meant to be broken, or NOT!

Pertama-tama saya ingin mengucapkan permohonan maaf kepada para follower blog saya *emangnya ada?* karena telah melanggar janji suci untuk mengupdate blog ini tiap hari. Ya memang, laki-laki itu yang dipegang kata-katanya (kata seorang pepatah). Tapi tenanglah, saya masih laki-laki *walau (beberapa) kata-kata saya belum bisa dipegang*.

Resolution are meant to be broken. Agak mengelitik memang, tapi kenyataannya kebanyakan dari kita seperti itu *or it's just me*. Well, untuk mengatasi hal tersebut saya punya quote yang cukup menarik dari pak Tung Desem Waringin (follow him at @TungDW) bahwa untuk menghindari kemurungan karena kegagalan jangka pendek, maka lihatlah tujuan jangka panjang. Berkaca dari hal tersebut, saya kemudian merevisi Indikator Kinerja Utama (IKU) / Key Performance Indicator (KPI) penerbitan artikel di blog saya yang semula 1 post per hari menjadi at least 1 post per minggu. Klo target capaiannya melebihi 100% dalam beberapa minggu mungkin KPInya bisa tingkatkan menjadi 2, 3, 4, atau 5 post per minggu.. syukur jika bisa jadi 7 post per minggu.. yang artinya back to the right track.. 1 post per day.. sounds good, right?

That's it for today.. see you tomorrow, or next week maybe! :)

Useful Application: Try This!

Seperti yang telah saya janjikan sebelumnya, hari ini saya akan berbagi sekelumit pengalaman saya yaitu penggunaan beberapa aplikasi yang bermanfaat - setidaknya bagi diri saya.

Aplikasi yang pertama adalah MindMaple. Aplikasi ini berjalan seperti konsep Mind Map punya Tony Buzan. Sangat berguna untuk mengorganisasi ide atau materi kuliah, thesis/skripsi, atau kegiatan sosial anda sekalipun. Mencatat menjadi lebih mudah, dan menyenangkan tentunya.

Aplikasi berikutnya adalah TaskCoach. Saya sudah lebih dari dua tahun mencari aplikasi time management, todo list, dan effort tracking yang mumpuni, dan pencarian saya berhenti ketika bertemu dengannya. This is the best time management application ever!

Aplikasi yang terakhir adalah WordWeb. Aplikasi kamus bahasa Inggris english-to-english ini bisa bebas anda miliki jika jumlah penerbangan anda tidak lebih dari dua kali dalam setahun (baca aja ToS-nya klo gak percaya :p). Sangat interaktif, gratis (dengan syarat dan kondisi tertentu), dan BAGUS!. Tersedia untuk berbagai macam platform OS, termasuk Android dan iOS, keren kan? ;)

Itulah beberapa aplikasi terbaik menurut saya. Jika anda memiliki pilihan aplikasi yang lebih baik dari yang saya utarakan di atas (dengan jenis aplikasi yang sama tentunya), saya akan senang sekali mendengan komentar anda dibawah ini. Okey, that's all for today. See you tomorrow for my next articles. Semoga bermanfaat :)

New Year, New Blog Concept

After abandoning my blog for almost two years, i decided that one of my 2013 resolution is regularly writing in my blog. Ups, i did it again. I know what you guys thinking, i bet it's like "Is he for real?", "hell no he's gonna do that!".  Well, you are free to think so, because i going to do this anyway - or maybe not.

So, after taking a few minutes of meditation, I've come to a decision for what is my blog going to look like in this emerging 2013. In general, it's going to cover topic around my journey in the jungle of web development, review of some useful software, learning technique, and anything that i learn from my daily activities or everything i want to share. It's just that simple.

So, i guess that's wrap up our discussion today. Don't forget to come back tomorrow, i promise you there will be a new interesting post for you to read. And one more thing, don't you want to share yours with me? comment below so i can visit it :)

KUNCI JAWABAN SOAL PERANCANGAN BASIS DATA

Buat temen-temen 12.2M.04 yang kesulitan untuk menjawab soal-soal perancangan basis data, kamu-kamu bisa download kunci jawabannya di sini:

KUNCI JAWABAN SOAL PERANCANGAN BASIS DATA

kalo ada yang salah, notify me ya..
selamat mencontek mengerjakan! ;)

Hi there...!!! long time not see..

Hi there..!!!

Long time not see...

“CUT IT OUT...!!! We’ve already sick of read it...!”

Maybe that’s the expression that you guys would convey when reading my first two lines. Heel yeah! It’s no wonder, since this is my another-time-filler-post in my blog – typically me. It’s been two weeks since my last post – what an unproductive blogger, pity me. Sob.

“#pencetidung #buangingus *usap airmata #everythingsgonnabeokay *lambaikan saputangan”.

Ups… my bad. A lil’ bit of mixed and bunch of twisted over here. FYI, that’s strange line is a way how people (me included) express themselves in twitter (#DamnItsTrue said that it’s an abbreviation of Tell What I’m Thinking To Everyone Reading. Though I haven’t seen any strong evidence to confirm this theorem, I think this line of words is quite representative to best describe what twitter really is).

You’ll never get to the place you long for…

Unless you walk the path that guides you there… - Sevtigo, 15.04.2011

Well, as you guys know (or don’t know), I’m a man who is no good when dealing with words. Not words from Microsoft. Not that Ms. Words – in fact, I’m so damn good at it. #sombongkauanakmuda – here it goes again. Sometimes it’s cross my mind to write about Words. Yeah, maybe I’m going to write some tips and tricks using Microsoft Words. I’m going to write a lot! Yippee! Yippee! Yippee!. “But, what is the point if there’s no one read it?” I keep questioning myself. *mendadak #suram –here’s come the other, sigh. Let’s go back to the topic. Despite of my lacking in writing, I still have a strong will to become a legendary blogger –just like Naruto who deadly want to become a hokage.I really envy those peoples who enjoy to live their blogging life, namely Mr. Sedjatee, Bunda Mahes, Uda Riki, Aa’ Jon and another long list of blogger which is hard for me to name them all. Actually, I’m writing this post after doing a little walk to Uda Riki, Bunda Mahes, and Mr. Sedjatee’s Blog. It’s really a mind-blowing journey in a galaxy filled with star words you’ve never heard before. Exaggerating yet touch your heart mildly. It’s not a compliment. I’m feeling it, for real. And I, from the deep of my heart, -*lebay to the max– want to be able to write posts like them. Share and care would be my blog's vision. However, one post a week is a great start I think.

Sometimes, passion needs patience…

Cuz rush often make you crush... sevtigo, 15.04.2011

"if i promise not to kill you, can i have a hug?"

hari ini baca profil facebook seorang sahabat lamaku.. di kolom about me-nya tertulis:

	"if i promise not to kill you, can i have a hug?"

waw.. seketika aku berdecak kagum..
karena penasaran.. ya seperti biasa.. tak 'googling' aja..
ternyata eh ternyata..
rupanya itu kalimat di salah satu komik emo kenamaan..
pas coba pake fasilitas search imagex google..
aku menemukan satu gambar yang menarik..
kalimatnya simple.. tapi sering kali aku (atau mungkin kamu juga) sering merasakannya..
then i decided to post it on my blog.. hoping that someone who know me best will do it..
for me..
check this out..

How to Tell 'I Love You' in @L4y mode: ON

Hi there..!!!

long time not see..

how's life..??

hope you guys doin' just fine..

hayhay.. tak afdhol rasanya jika tak mengakhiri paceklik post (di blog) saya ini dengan monolog.. untaian kalimat retoris yang rasanya tak etis jika hanya sekedar pemanis dari bibirku yang tipis (sound fx: emmh..emmh...emmmh..).

Oke. Kayaknya cukup sama @L4y-nya.. ntar pada like a G6¹ semua lagi.

Enough is Enough – Samuel L. Jackson

back to the topic. Sesuai dengan judul di atas² i just want to tell someone³:

i love you. :*

#wink, #chin, #point, #kiss-bye

*nggak puas karena alaynya kurang greget..??? kurang berasa??? tunjukin cara kamu nyatakan cinta dengan '@L4y 2 da MaX' versi kamu di kolom komeng dibawah ini.. #EkspresikanAksimu

R u 4L@y e-Nough?

1Nge-fly; terbang tinggi.

2Waktu nulis ini “di atas” tuh nggak ada apa-apanya a.k.a 'kosong'

3My dearest beloved wife

Berpetualang di Ionopolis

Kyaa...!!! akhirnya balik nge-blog lagi.. haha.. butuh tempat menumpahkan stress gara-gara gak bisa kerja dan gak bisa ngapa-ngapain.. lho kok gak bisa kerja?? Iya.. Aplikasi yang biasa kupakai tuk mengerjakan tugas.. lagi maintenance.. *jiah bahasa lu tong!* hee.. gara-gara ngupdate data tuh aplikasi di Bandung, pas mo restore databasex bermasalah.. simpel sih.. gara-gara beda platform.. tapi penanganannya itu loh.. ribeud.. jadi pengen bisa MS. SQL Server dan segenap perangkat aplikasi database dari Mikocok itu.. gak enak nunggu kerja bergantung ma orang.. iya klo orang itu gak sibuk.. lha.. klo orang nyang bisa bantu nanganin itu super sibuk.. atau sukanya

“Sante wae cah..
gampang itu..”

haha. no offense- sementara orang-orang dah pada teriak..

“Woi.. kok yang ini gak update sih.. yang itu juga..!!! kan udah dikasih dari minggu kemaren datanya..!!”

Haaa.. Preeet..!!!

Bang kerak ngintip pas aye bikin paragraf pertama diatas..

“Cie.. curhat ya..”

ledeknya.. dasar bang kerak..!! huasem.. :p. Back to the story, nah tadi tuh lantaran gi ga ngapa-ngapain *gagap kerja*.. numpang browsing di desktopx pangeran bakongan.. liat-liat bookmarkx.. eh ada chikenstrip.. blog yang udah lama gak aye tengok.. nah pas lagi blogwalking *btw, blogwalking apaan sih?* eh ada artikel yang ngebahas game ionopolis. Suatu kata yang belakangan ini agak familiar dengan mataku.. YA..!!! tepat sekali.. itu adalah kata yang setiap hari kulihat ketika harus merayap melewati perempatan –atau persepuluhan- pancoran. Iklan pocari yang satu itu emang dah lama bikin penasaran.. lantaran gak da waktu buat browsing yang ‘macem-macem’ aja jadi belum sempet cari tau apa makna dibalik iklan billboard yang terpampang megah di dekat patung pancoran itu.

Baca dibaca.. eh lupanya hadiahnya lumayan lho.. apalagi gara-gara si niwat0ri ngebawain tuh artikel persuasif banget.. jadi pengen nyoba maen juga.. bayangin aja.. ampe ngebela-belain bikin foursquare tuk ikut game itu.. karena ada salah satu cara ngelawan penjahat dengan check pada lokasi tertentu.. *agak lebay sih, ngapain juga bapak beranak satu ngikut nyang begitu-begituan*.

Nah.. game ini sendiri menggunakan mode interface seperti komik.. seperti cerita yang kita ikut serta didalamnya.. dihalaman awal setelah login anda akan dihadapkan pada halaman utama dimana ada sambutan dari pocariman.. terus cara dapetin hadiah ke jepun.. sama lanjut ke tiga misi pertama.. nah.. kamu akan diberi modal power *baca: hydration meter* 100% yang akan direcharge harian.. artinya.. jika hari itu kamu kehabisan cairan tubuh.. a.k.a dehidrasi kamu gak bisa ngelawan musuh-musuh di game tersebut. Keterangan lengkap game tersebut bisa kamu lihat diblognya si ayam aneh itu *tersangka yang telah meracuniku*.

Kamu bisa klik START MISION! Untuk memulai petualang kamu di negeri ionopolis.. selanjutnya.. SELAMAT BERMAIN.. oh iya.. Cuma mo share dikit pengalaman main game ini.. dihari ini *hari pertama ku bermain* aku pilih lokasi OUTDOOR.. ada dua pilihan musuh.. nah.. sebagai awalan, aku pilih si PICNICO sebagai musuhku.. aku pilih trivia sebagai cara untuk melawannya.. rupanya aku dihadapkan pada pertanyaan sekitar kegiatan outdoor..

pertanyaan level 1:

makanan yang biasa dibawa dan dimakan bersama ketika kita piknik adalah?

a. lunchbox

b. blablablabla (aku lupa apa yang ini)

c. rantangan.

Nah.. dengan pedenya aku jawab A.. sialnya.. salah!!! Dan hidrometerku berkurang 15!!! Ha.. berfikir sejenak.. oh mungkin bahasa kerennya kali “RANTANGAN”, kata yang sering digunakan ibuku ketika menyiapkan bekal tuk piknik.. eh.. salah juga.. d*mn!! Ilang deh 30.. pas ku jawab B eh.. bener.. dan walaupun ku menjawab bener.. tetep kepotong 15.. *baru ngeh klo setiap action kita itu membutuhkan 15 hidrometer* -__-‘’a

Wal hasil.. dengan ketidakngehan ku itu.. baru bisa nyampe level 2 lawan si Picnico.. dan hidrometerku menunjukan angka 10.. hahahaha.. haaaaaaseeeemm... -___-“a klo yang udah nyoba.. dishare ya pengalamannya berpetualang di dunia ionopolis..!!!

*semangat ngebog abis baca blog nya oom jon, thank oom :D

sumber gambar: pocarisweat.co.id/ionopolis

Dillema

Jiah..

Lagi iseng-iseng aja googling nama sendiri (sekali lagi bukan narsis, hanya iseng) eh ketemu blog ane yang di wordpress gan.. ane aja yang punya lupa pernah punya tuh blog.. baru keingetan kenapa gak pernah pake blog WP lagi.. lantaran ane lupa passwordnya gan..

nah tadi ane coba-coba beberapa password yang agak kurang familiar.. eh masuk gan.. (setelah percobaan yang kedua sih). hmm.. jadi binun neeh.. should i just keep up with my recently created blog.. or should i continue with my old one.. cuz both of them have their own unique.. couldn't be compared.. just like apple to banana..

anyway.. i'll try to post in both of it.. don't bother any repost.. you can leave just right away if you find that my post is repost from my another blog..

one more thing.. don't forget to visit my blog.. http://save3pw.wordpress.com
have fun..!!! :D

Nitip Lapak ya Yah... (^_^)

Assalamualaykum..
Hallooo.. semua temen2x ayah..
haha.. bunda numpang dagang nih..
monggo diliat-liat.. klo tertarik, jangan lupa diorder yawh.. :D
nitip lewat ayah juga bisa kuk.. cekidot gan..!!

1. Baju Muslim Anak-Anak Bahan Katun Super Cute

Tersedia ukuran bervariasi mulai dari 5 - 12 tahun
Harga terjangkau, mulai dari 60.000 - 70.000 IDR/Pc




Untuk yang perempuan juga ada lho...
Harga dikisaran 55.000 s.d. 70.000 IDR/Pc



2. Baju Muslim Anak-Anak Bahan Kaos Super Cool

Ukuran tersedia dari 6 bln s.d. 5 thn
Harga mulai dari 37.500 - 45.000 IDR/Pc




Klo tertarik.. jangan lupa hubungi ayahnya Ichigo ya..
Thank You..
Wasalamualaykum (^_^)

The Story of Bunda Mahes

It’s been two days since my last post –yes, that very not like post. Yesterday, Bunda Mahes asked me why I didn’t blog another post. Here’s come the conversation:

“Mana nih blognya..? kuk gak nulis lagi”, she said.

“Ga tau nih…, ga ada ide.. mo ditulisin apa nih? Do you have any idea?” I replied. I was asking her suggestion about topic for me to write. Back then, I was thinking: If she said “just write random things...” I will definitely write about her.

“Mmmm… ga tau.. apa aja deh..”, she continued.

As I thought, I had anticipated that she would say such a thing. I didn’t expect much from her (hehe, just kiddin’ Bunes –abbr. of Bunda Mahes :p). So here I am, writing down all I know about her –though I don’t know her too much.

Here it goes…

Bunda Mahes is one of my working partners. Some people (or it’s just me :p)may think she’s a delinquent girl, but she’s not. Trust me. It’s just in her blood –she’s a descendant of Madura Tribe[1]. She’s a very talk active girl. Sometimes, her words are kinda sharp –or I’d rather say straightforward. Even so, she brings a lot of joys to our working environment. Our office room will be so much quieter in a whole different level of hilarity when she’s not around.

Bunda Mahes is really loved and adore her husband. I bet you guys will think that her husband is Sharukh Khan at your first sight –I did thought that her boo was Sharukh Khan, fool me. You guys will know how much she love him just by reading her blog (visit it!). Her blog content random things start from her cook to actual headline stories. Though, most of her blogs contain various stories around her beloved son, Mahes. I’m not sure whether you’ll have a hard time to find the post that I mean or not.

Lately, I found out that one of her favorite movies genre is Bollywood[2] –kind of acha-acha-mecca-mecca-janne-janne things- which one of its shining stars is Sharukh Khan. Is it coincidence? I smell something fishy here. Well, we’ll just leave it. Oh yeah, almost forget one more thing, her husband is also have the same taste of movies –what a couple, I wish my wife love Anime just like I did. A few weeks ago, they both (Bunda Mahes and her husband) directed a video of their son performing modified Indian dancer (mixed with Ngebor Style). Like son like father, like son like mother. Bollywood addicted family –Nice.

However, I feel very glad to know her. She shares a lot of her precious experiences to us, her friend. She really loves to share the joy of having a family, encourage the jomblo and jomblowati in our office to get married soon. Next time, I’ll tell you guys the story of another my co-worker, the jomblo and jomblowati of PP12.

Share the joy, Save the earth.

---

[1] It is a tribe which (in Indonesia) is known for its harshness. No offense. But, most people around me are told me that way. Though, I disagree with the statement that judging people’s personality trait just by it race. It doesn’t make any senses for me.

[2] Indian Movies Industries –The Hollywood of India.

I'm not a good prayer, why should i preach other.

It's only about 50 minutes before the time for me to preach at MBM Purnawarman. Still don't have any idea 'bout what i'm goin' to talk. i've already read a lot of books for my preach , yet not find what kind of topic to bring about. but still, i have to try. Lost in panic, i asked Uda Riki to exchange his scedule with mine. At first, he said that he would try it. But then, he sent messages through GTalk:

"ane udah mampir Gan (referring to my new blog).

semoga sukses ya, Gan..

kultumnya

hehehe"

Well, at last i'll just go for it. Go Tigo Go Tigo Go..!!! (encouraging my self)

#indonesia65

Banker, i beg your apologize for not posting shoutout on twitter using hashtag #indonesia65 -except for just one. Is it became trending topic? i'm so sorry Indonesia.

Unleash: Hello World (again) XD

Well, it’s been a long time since my last time wrote an article in a blog. Actually, I’m not really good in writing, but I never stop to start one. Actually, I have a very unpleasant experience with a blog. Before I decide to publish this one, I’ve already have 5ive –if I don’t miscount. But, it’s always ended up lying waste. My plan was to split the topic into my five blog. Since I lack of motivation, none of it work out.

Besides of my lacking motivation, there are three main reasons that make my (previous) blog stop publishing, namely: my dullness in writing, my ungrammatical English, and my moody woodpecker. I’d love to write so many things, unfortunately my skill in writing is no better that a new born baby. Don’t blame me if you get lost in the jungle of my hilarious words. This one is the worst; I want to write a lot of articles in English yet my English is bad. If you still doesn’t understand –or still don’t get- what the heck I’m talking about. Yes. That’s what I mean. My English is out of reach. Bet it’s hard for people like you to comprehend. This is the last one: my wavering mood. I only write when my mood is good. The problem is I never get in the mood.

I wish I could overcome those obstacles in this blog. I wish I am skillful in writing as Mr. Sedjatee or Uda Riki. I wish my English as fluent as Lady Nusantara or Princess of Bakongan (peace day :D). And I do really hope that my motivation to post my writing as high as Bunda Mahes. Almost forget, I also want to make my blog as cool as Kang Lurik blog’s.

So, this is it. My very first post say hello to this beautiful world (again). This is my new resolution in the 65th Independence Day of my beloved country -Indonesia Raya. Share my thought, my -not so- wisdom words. Just share. Unleash…!!!