Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Selamat datang di blog zakylinuxer.blogspot.com

Sunday, June 12, 2011

Software Padanan Windows di Linux

Sumber : http://www.linuxalt.com/

3D Home Architect

* Sweet Home 3D (http://sweethome3d.sourceforge.net/index.html)

3D Studio Max

* Art of Illusion (http://www.artofillusion.org/)
* Blender (http://www.blender.org/)
* K-3D (http://www.k-3d.org/)
* Wings 3D (http://www.wings3d.com/)

ACDSee

* Eye of GNOME (http://www.gnome.org/projects/eog/)
* Geeqie (http://geeqie.sourceforge.net/)
* GQview (http://gqview.sourceforge.net/)
* Gwenview (http://gwenview.sourceforge.net/)
* KuickShow (http://kuickshow.sourceforge.net/)
* ShowImg (http://www.jalix.org/projects/showimg/)

Adobe Acrobat Reader

* ePDFView (http://trac.emma-soft.com/epdfview/)
* Evince (http://www.gnome.org/projects/evince/)
* okular (http://okular.kde.org/)
* Xpdf (http://www.foolabs.com/xpdf/)

Adobe Audition

* Audacity (http://audacity.sourceforge.net/)

Adobe Illustrator

* Inkscape (http://www.inkscape.org/)
* Karbon14 (http://www.koffice.org/karbon/)
* Skencil (http://www.skencil.org/)
* Xara Xtreme for Linux (http://www.xaraxtreme.org/)

Adobe Lightroom

* Darktable (http://darktable.sourceforge.net/)

Adobe PageMaker

* Scribus (http://www.scribus.net/)

Adobe Photoshop

* CinePaint (http://www.cinepaint.org/)
* GIMP (http://www.gimp.org/)
* Krita (http://www.koffice.org/krita/)

Ant Movie Catalog

* Moviefly (https://savannah.nongnu.org/projects/lmc/)

AOL Instant Messenger (AIM)

* Kopete (http://kopete.kde.org/)
* Pidgin (http://pidgin.im)

APC PowerChute

* Apcupsd (http://www.apcupsd.com/)
* Network UPS Tools (http://www.networkupstools.org/)
* PowerD (http://power.sourceforge.net/)

Collectorz

* Alexandria (http://alexandria.rubyforge.org/)
* aviManager (http://avimanager.sourceforge.net/)
* GCstar (http://www.gcstar.org/)
* Griffith (http://griffith.cc/)
* Katalog (http://salvaste.altervista.org/)
* Tellico (http://tellico-project.org/)
* vMovieDB (http://vmoviedb.sourceforge.net/)

Dreamweaver

* Bluefish (http://bluefish.openoffice.nl/index.html)
* Geany (http://geany.uvena.de)
* KompoZer (http://www.kompozer.net/)
* Nvu (http://www.nvu.com/)
* Quanta Plus (http://quanta.kdewebdev.org/)
* Screem (http://www.screem.org/)

DVDShrink

* AcidRip (http://untrepid.com/acidrip/)
* dvd::rip (http://www.exit1.org/dvdrip/)
* k9copy (http://k9copy.sourceforge.net/)
* OGMRip (http://ogmrip.sourceforge.net/)
* qVamps (http://vamps.sourceforge.net/)
* Thoggen (http://thoggen.net/)
* xdvdshrink (http://dvdshrink.sourceforge.net/)

Everest

* HardInfo (http://hardinfo.berlios.de/web/HomePage)

Evernote

* BasKet (http://basket.kde.org/)
* QuickFox Notes (https://addons.mozilla.org/en-US/firefox/addon/13572/)
* Tomboy (http://live.gnome.org/Tomboy/)
* Zim (http://zim-wiki.org/)

Finale

* Brahms (http://brahms.sourceforge.net/)
* Denemo (http://denemo.sourceforge.net/index.html)
* Lilypond (http://www.lilypond.org)
* MuseScore (http://musescore.org/)
* NoteEdit (http://noteedit.berlios.de/)
* Rosegarden (http://www.rosegardenmusic.com/)

FL Studio

* Ardour (http://www.ardour.org)
* Jokosher (http://www.jokosher.org/)
* LMMS (http://lmms.sourceforge.net/)

Fontographer

* FontForge (http://fontforge.sourceforge.net/)

foobar2000

* Amarok (http://amarok.kde.org/)
* Aqualung (http://aqualung.factorial.hu/misc.html)
* aTunes (http://www.atunes.org/)
* Banshee (http://banshee-project.org/Main_Page)
* Exaile (http://www.exaile.org/)
* gtkpod (http://www.gtkpod.org/)
* Listen (http://listengnome.free.fr/)
* Quod Libet (http://www.sacredchao.net/quodlibet)
* Rhythmbox (http://www.gnome.org/projects/rhythmbox/)

Forte Agent

* Pan (http://pan.rebelbase.com/)

Fraps

* recordMyDesktop (http://recordmydesktop.sourceforge.net/)
* Yukon (https://devel.neopsis.com/projects/yukon/)

FreeRIP

* Grip (http://nostatic.org/grip/)
* KAudioCreator (http://www.icefox.net/programs/?program=KAudioCreator)
* ripperX (http://ripperx.sourceforge.net/)
* Rubyripper (http://wiki.hydrogenaudio.org/index.php?title=Rubyripper)
* Sound Juicer (http://www.burtonini.com/blog/computers/sound-juicer)

FruityLoops

* Hydrogen (http://www.hydrogen-music.org/)

Google Desktop Search

* Beagle (http://beagle-project.org/)
* Google Desktop (http://desktop.google.com/linux/index.html)

Guitar Pro

* DGuitar (http://dguitar.sourceforge.net/)
* kguitar (http://sourceforge.net/projects/kguitar/)
* TuxGuitar (http://www.tuxguitar.com.ar/home.html)

Legacy Family Tree

* GRAMPS (http://gramps-project.org/)

LimeWire

* FrostWire (http://www.frostwire.com/)

Meal Master

* Gourmet Recipe Manager (http://grecipe-manager.sourceforge.net/)
* krecipe (http://krecipes.sourceforge.net/)

Microsoft Access

* GNOME-DB (http://www.gnome-db.org/)
* Kexi (http://www.koffice.org/kexi/)
* knoda (http://www.knoda.org)

Microsoft Excel

* Gnumeric (http://www.gnome.org/projects/gnumeric/)
* KSpread (http://www.koffice.org/kspread/)
* Open Calc (http://www.openoffice.org/product/calc.html)

Microsoft HyperTerminal

* GtkTerm (http://freshmeat.net/projects/gtkterm/)
* minicom (http://alioth.debian.org/projects/minicom/)

Microsoft Internet Explorer

* Epiphany (http://www.gnome.org/projects/epiphany/)
* Firefox (http://www.mozilla.com/firefox/)
* Konqueror (http://www.konqueror.org/)
* Opera (http://www.opera.com/download/)

Microsoft Money

* Gnofin (http://gnofin.sourceforge.net/)
* GNUcash (http://www.gnucash.org/)
* Grisbi (http://www.grisbi.org/)
* HomeBank (http://homebank.free.fr/)
* KMyMoney (http://kmymoney2.sourceforge.net/)
* Skrooge (http://skrooge.org/)

Microsoft Office

* GNOME Office (http://www.gnome.org/gnome-office/)
* KOffice (http://www.koffice.org/)
* OpenOffice (http://www.openoffice.org/)

Microsoft Outlook (Express)

* Evolution (http://www.gnome.org/projects/evolution/)
* Thunderbird (http://www.mozilla.com/thunderbird/)

Microsoft Powerpoint

* KPresenter (http://www.koffice.org/kpresenter/)
* Open Office Impress (http://www.openoffice.org/product/impress.html)

Microsoft Project

* GanttProject (http://ganttproject.sourceforge.net/)
* KPlato (http://www.koffice.org/kplato/)
* OpenProj (http://openproj.org/openproj)
* Planner (http://live.gnome.org/Planner)
* TaskJuggler (http://www.taskjuggler.org/)

Microsoft Visio

* Dia (http://www.gnome.org/projects/dia/)
* Kivio (http://www.koffice.org/kivio/)

Microsoft Windows Media Center

* Boxee (http://www.boxee.tv/)
* Freevo (http://freevo.sourceforge.net/)
* LinuxMCE (http://www.linuxmce.com/)
* Moovida (http://www.moovida.com)
* MythTV (http://www.mythtv.org)
* XBMC Media Center (http://xbmc.org/)

Microsoft Word

* AbiWord (http://www.abisource.com/)
* Kword (http://www.koffice.org/kword/)
* Open Office Writer (http://www.openoffice.org/product/writer.html)

mIRC

* BitchX (http://www.bitchx.org/)
* ChatZilla! (http://chatzilla.hacksrus.com/)
* irssi (http://www.irssi.org/)
* Konversation (http://konversation.kde.org/)
* KVIrc (http://www.kvirc.net/)
* Pidgin (http://pidgin.im)
* Xchat (http://www.xchat.org/)

Mp3tag

* Audio Tag Tool (http://pwp.netcabo.pt/paol/tagtool/)
* Cowbell (http://more-cowbell.org/)
* EasyTAG (http://easytag.sourceforge.net/)
* Kid3 (http://kid3.sourceforge.net/)
* Pinkytagger (http://pinkytagger.sourceforge.net/)

MS Paint

* KolourPaint (http://kolourpaint.sourceforge.net/)
* Pencil (http://www.pencil-animation.org/)
* Pinta (http://pinta-project.com/)
* TuxPaint (http://tuxpaint.org/)

MSN messenger

* aMSN (http://amsn-project.net/)
* Kopete (http://kopete.kde.org/)
* Mercury Messenger (http://www.mercury.to/)
* Pidgin (http://pidgin.im)

Mudbox

* SharpConstruct (http://sourceforge.net/projects/sharp3d/)

Nero Burning Rom

* Brasero (http://perso.orange.fr/bonfire/index.htm)
* GnomeBaker (http://gnomebaker.sourceforge.net/)
* Graveman! (http://graveman.tuxfamily.org/)
* K3b (http://www.k3b.org/)
* X-CD-Roast (http://www.xcdroast.org/)

NetMeeting

* Ekiga (http://www.gnomemeeting.org/)

NetStumbler

* Kismet (http://www.kismetwireless.net/)
* SWScanner (http://www.swscanner.org/)

NewzCrawler

* Akregator (http://akregator.kde.org/)
* BasKet (http://basket.kde.org/)
* Blam (http://www.cmartin.tk/blam.html)
* Liferea (http://liferea.sourceforge.net/)
* RSSOwl (http://www.rssowl.org/)
* Straw (http://www.gnome.org/projects/straw/)

Notepad

* gedit (http://www.gnome.org/projects/gedit/)
* jEdit (http://www.jedit.org/)
* Kate (http://kate-editor.org/)
* leafpad (http://tarot.freeshell.org/leafpad/)
* NEdit (http://www.nedit.org/)
* Scribes (http://scribes.sourceforge.net/)
* tpad (http://tclpad.sourceforge.net/)

OrangeCD Catalog

* GWhere (http://www.gwhere.org)

Origin

* SciGraphica (http://scigraphica.sourceforge.net/)

Partition Magic

* GParted (http://gparted.sourceforge.net/)
* Partimage (http://www.partimage.org/Main_Page)
* QtParted (http://qtparted.sourceforge.net)

PhotoME

* FotoTagger (http://sourceforge.net/projects/fototagger/)

Picasa

* digiKam (http://www.digikam.org/)
* F-Spot (http://f-spot.org/Main_Page)
* flPhoto (http://www.easysw.com/~mike/flphoto/)
* gThumb (http://live.gnome.org/gthumb/)
* jBrout (http://jbrout.manatlan.com/)
* KPhotoAlbum (http://www.kphotoalbum.org/)
* Shotwell (http://www.yorba.org/shotwell/)

SoulSeek

* Nicotine (http://nicotine.thegraveyard.org/)
* Nicotine-Plus (http://nicotine-plus.sourceforge.net/)

SoundForge

* ReZound (http://rezound.sourceforge.net/)

Total Commander

* GNOME Commander (http://www.nongnu.org/gcmd/)
* Krusader (http://krusader.sourceforge.net/)
* Midnight Commander (http://www.ibiblio.org/mc/)
* Tux Commander (http://tuxcmd.sourceforge.net/)
* xfe (http://roland65.free.fr/xfe/)

Traktor DJ

* Mixxx (http://mixxx.sourceforge.net/)
* terminatorX (http://www.terminatorx.org/)

TweetDeck

* Choqok (http://choqok.gnufolks.org/)
* Gwibber (http://gwibber.com/)
* Pino (http://pino-app.appspot.com/)

uTorrent

* qBittorrent (http://qbittorrent.sourceforge.net/)
* Transmission (http://www.transmissionbt.com/)

Videora

* thin liquid film (http://thinliquidfilm.org/)

Winamp

* Amarok (http://amarok.kde.org/)
* Audacious (http://audacious-media-player.org/Main_Page)
* XMMS (http://www.xmms.org/)

Windows Media Player

* KPlayer (http://kplayer.sourceforge.net/)
* mplayer (http://www.mplayerhq.hu/design7/news.html)
* VLC Player (http://www.videolan.org/vlc/)
* xine (http://xinehq.de/)

Windows Movie Maker

* cinefx (http://www.cinefx.org/)
* Cinelerra (http://cvs.cinelerra.org/)
* Kdenlive (http://kdenlive.sourceforge.net/)
* Kino (http://www.kinodv.org/)
* LiVES (http://lives.sourceforge.net/)
* Lombard (http://yorba.org/lombard/)
* Open Movie Editor (http://www.openmovieeditor.org/)
* OpenShot (http://www.openshotvideo.com/)
* PiTiVi (http://www.pitivi.org/wiki/Main_Page)
* VideoLAN Movie Creator (http://trac.videolan.org/vlmc/)

WinIso

* KIso (http://kiso.sourceforge.net/)

WinMerge

* KDiff3 (http://kdiff3.sourceforge.net/)
* Kile (http://kile.sourceforge.net/)
* Meld (http://meld.sourceforge.net/)
* xxdiff (http://furius.ca/xxdiff/)

WinTV

* KWinTV (http://www.kwintv.org/)
* tvtime (http://tvtime.sourceforge.net/)
* xawtv (http://linux.bytesex.org/xawtv/)
* XdTV (http://xawdecode.sourceforge.net/)
* Zapping (http://zapping.sourceforge.net/Zapping/index.html)

WS_FTP

* FireFTP (http://fireftp.mozdev.org/)
* gFTP (http://gftp.seul.org/)

ZoneAlarm

* Firestarter (http://www.fs-security.com/)
* Guarddog (http://www.simonzone.com/software/guarddog/)

Zscreen

* Shutter (http://shutter-project.org/)

Friday, June 10, 2011

Funsi "if' di Calc

Fungsi if di Calc

Salah satu yang saya sukai dari Calc adalah kemampuan logika sederhananya. Contoh klasik misalnya pada saat membuat raport. Kita bisa bikin beberapa kolom berisi nilai per mata pelajaran, lalu dibuat rata-ratanya. Nah, sekarang menentukan apakah pemilik raport ini akan naik kelas atau tidak.

Aturannya, jika rata-rata di atas 6, maka naik kelas, di bawah 6 maka tidak naik kelas. Tentu mudah membuat rumusnya dengan Calc. Misalkan nilai rata-rata ada di sel A10, maka rumusnya:

=IF(A10>=6,"Naik","Tidak Naik")

Kita lihat lagi rumus di dalam kurung. A10>6 maksudnya syarat bahwa sel A10 lebih besar dari 6. Berikutnya, setelah koma, kita masukkan kategori “Naik”, jika sel A10 memang lebih besar dari 6. Perhatikan bahwa untuk membuat pernyataan dalam bentuk teks, gunakan tanda petik. Kemudian, setelah tanda koma, kita berikan kategori “Tidak Naik”. Kategori ini akan muncul bila ternyata sel A10 nilainya kurang dari 6.

Contoh ini mungkin terlalu sederhana. Bagaimana jika ada syarat lain, misalnya nilai pelajaran Agama harus di atas 7? Jangan khawatir, excel masih bisa menulis rumus untuk ini.

Katakanlah nilai pelajaran agama ada di sel A2. Maka kita paksa Excel berpikir: sel A10 harus di atas 6. Kalau ya, lihat set A2, harus di atas 7. Kalau ya, berarti naik, kalau tidak berarti tidak naik. Nah, begini cara kita mengajari Excel:

=IF(A10>=6,(IF(A2>=7,"Naik","Tidak Naik")),"Tidak Naik")

Ribet? Ya, memang. Bagaimana kalau syaratnya diperbanyak menjadi 3 atau lebih? Misalnya, selain pelajaran Agama di sel A2, pelajaran Bahasa Indonesia (sel A3) juga harus lebih besar dari 6.

Ada cara lain yang lebih mudah dibaca, pakai operator AND. Perhatikan contoh berikut:

=IF(AND(A2>=7,A3>=6,A10>=6),"Naik","Tidak Naik")

Masih memakai fungsi IF, hanya sekarang kita pakai tambahan AND. Semua syarat di dalam tanda kurung () setelah AND, harus terpenuhi semua, baru dinyatakan Naik, jika salah satu saja tidak terpenuhi, akan dinyatakan Tidak Naik.