Category Archives: Excel

SCS Dimensionless Unit Hydrograph


Okey, it’s been so long since i didn’t write anything in this “anything” web blog, since i pretty busy on doing anything. I am now living in Japan, by the way. Yea, i think i am kind of adjusting my … Continue reading

Posted in Engineering, Excel, Hydrology, Software | Tagged , , , , | 3 Comments

Reservoir Operation Simulation (01)


As tomorrow we’ll have an exam in Water Resource Management class, i’d like to write about a simple reservoir simulation. Basically, in designing a reservoir operating rule, we can do two types of steps: (1) Simulation, and (2) Optimization. Simulation … Continue reading

Posted in Engineering, Excel, Just a Note, Software | Tagged , | 4 Comments

[Easy Excel] VLOOKUP and INDEX MATCH


I was finishing my task for water resource management course when suddenly i remember that i need to write about “VLOOKUP” and “INDEX MATCH”. Why? simply because i often forget about INDEX MATCH formula. While the VLOOKUP is the additional … Continue reading

Posted in Engineering, Excel, Software | Tagged , , | 3 Comments

Hidrograf Satuan (Unit Hydrograph) dari Data Terukur


iseng2, mari kita catat tentang Metode Polinomial dan Metode Collins di sini. Beberapa cara menentukan hidrograf satuan (Unit Hydrograph) dari data terukur, diantaranya adalah dengan Metode Polinomial, dan Metode Collins. Tentu saja masih dengan mengingat asumsi & teori hidrograf satuan. … Continue reading

Posted in Engineering, Excel, Hydrology, Just a Note, Software | Tagged , , | 12 Comments

Skala Logaritmik pada Ms Excel


Terkadang untuk data tertentu kita perlu mengeplotkan data tersebut ke dalam skala logaritmik. Berikut adalah cara membuat grafik dengan skala log: 1. Plot data dalam XY seperti biasa, misalnya didapatkan grafik seperti gambar di bawah: 2. Klik kanan pada sumbu … Continue reading

Posted in Engineering, Excel, Software | Tagged , | 12 Comments

vlookup in Microsoft Excel


okey, we know that excel has a lot of helpful function which will beautifully make our tasks much easier (or better to say more efficient). One of those is the “vlookup” function. #well, actually, i’m being asked about “vlookup” function, … Continue reading

Posted in Engineering, Excel, Software | Tagged , | 6 Comments