Custom Search

View Full Version : PinoyPC Freeware Guide #2 – Office Productivity


froilanr
May 17th, 2008, 09:40 AM
PinoyPC Freeware Guide #2 – Office Productivity l
Written by Al Librero
Saturday, 15 March 2008

The Philippine Anti-Piracy Team has been unusually aggressive for the past several months with their seemingly random raids on establishments ranging from internet cafes to corporate buildings. I don't necessarily agree with their actions and methods, but one thing I can't deny is that they do get results. That's something we can't say about every government institution around here.

So, to keep these guys off our backs, we have two options:

1. Pay for your software licenses
2. Abandon all unlicensed software in your systems and opt for open source software/freeware

This edition of the Freeware Guide is for the people looking to go for option #2 – the ones belonging to small to medium businesses as well as academic institutions unable to afford the whole shebang of the leading proprietary productivity software.

I made a conscious decision to pick only cross-platform applications for this edition of the Freeware Guide. While, of course, the earnest thing to do is to go ahead with Linux, I am well aware of the fact that many people are still not willing to take that jump and totally abandon Microsoft Windows. I know I'm one of those. As business managers and administrators fully appreciate, certain compromises need to be made.

Now, let's get on with it...


OpenOffice (Windows, Linux, Mac, Solaris)
http://www.openoffice.org

Sun Microsystems has come a long way since StarOffice. OpenOffice is without a doubt the most feature-rich open source office productivity software package available to mainstream users. Heck, feature-wise, it has enough to give MS Office a run for its money. In addition to the standard-issue word processor (Writer), spreadsheet (Calc), presentation software (Impress) and database app (Base), OpenOffice includes Math, a component designed for rendering mathematical equations (aside from bouts of nosebleeds while answering them, they're also a pain to create on a word processor). There's also Draw, a fairly powerful vector graphic creation software.

While the process of importing MS Office files have improved in these latest revisions, it faces a few challenges. First, the interface can be clunky for some people. Second, OpenOffice runs significantly slower on Windows machines, thanks to it being built with Java. And third, it is unclear how long it will take for the open document format to gain mainstream acceptance. Until that time comes, OpenOffice will always be considered an “alternative” as opposed to being a better choice.


IBM Lotus Symphony (Windows, Linux)
http://symphony.lotus.com

This one's a personal favorite of mine.

I don't know how, but this thing won Datamation Magazine's award for the 2008 Office Productivity Software of the Year (http://itmanagement.earthweb.com/cnews/article.php/3727446), edging out BOTH Open Office 2.3 AND Microsoft Office 2007.

Built on top of the OpenOffice engine itself, Lotus Symphony includes a word processor, spreadsheet and presentation software following the open document format. While it lacks a database application counterpart to OpenOffice Base (or MS Access, for that matter) and a plethora of document templates, this package makes up through a much more refined user interface – a token from the IBM pedigree.

Can other higher profile awards be on the way? Hard to tell, but without these “extras” which the competition has and the suite sharing many of the weaknesses of OpenOffice, I don't think so. There is still a long way to go, but Lotus Symphony is on the right track. I just hope it stays being freeware.


GIMPShop (Windows, Linux, Mac)
http://www.gimpshop.com

For the past years, GIMP has been one of the beacons of the open source movement. Capable of standing toe to toe with many of the capabilities of the de facto standard image editor software Adobe Photoshop, GIMP falls a little short with its user interface. I myself have had some difficulties with it.

Luckily for us who by now have gotten comfortable with Photoshop's interface, there's GIMPShop. This application is still GIMP at the inside, but the UI has been hacked to make it bear some more resemblance to Photoshop. In theory, this should make our transition between the two applications smoother and faster. It has to be – at some point some people will probably prefer to move to GIMP as software revisions don't come along as frequently in GIMPShop.


Inkscape (Windows, Linux)
http://www.inkscape.org

The one in this list I have the least experience with, Inkscape is an open source application for creating 2D vector graphics. It neither has the elegance nor the power ofered by Adobe Illustrator or CorelDraw, but like that of the GIMP community, I have seen impressive clip art created and edited using Inkscape. At the very least, I prefer this much much more than OpenOffice Draw.


Dia (Windows, Linux)
http://live.gnome.org/Dia

For some reason, I never liked Microsoft Visio. I love SmartDraw, but of course, I can't afford it either. Now, I have this.

Dia is a diagram-creation tool meant to be at par with the aforementioned Visio. While it may be a little weak for rendering some types of technical diagrams, it is more than enough for just about everything else, from UML-based diagrams, to network flowcharts and even electronic schematic diagrams.

Dia, being built with the GTK+ library, shares the look and feel of both GIMP and Inkscape. I don't know whether it is a coincidence or not, but these three applications don't look half bad bundled as a graphics suite. Perhaps toughing it out with the interface's learning curve may be worth it.


GANTT Project (Windows, Linux, Mac)
http://www.ganttproject.biz

Need I say what's this for? I conclude this article in an anti-climactic fashion by highlighting the smallest app in this guide.

GANTT Project is a small management tool that helps you create GANTT charts to schedule any sort of activity or project you and your business may have. I've been using it occasionally this past month and it's pretty straight-forward as far as I can tell. Once the bugs are taken care of and the interface is further refined, you'll have a respectable alternative for some tasks delegated for MS Project.



Speak your mind.
Last Updated ( Friday, 09 May 2008 )

littlebadboy
May 17th, 2008, 10:28 AM
thanks for the tips!

if i may also share a very good article from http://blogs.zdnet.com/Ou/?p=989&page=1 by my idol George Ou.

A dozen free & essential apps for Windows

uTorrent - This is the BitTorrent client that is a must have for anyone who wants an effective file sharing application that allows you to download large files. It was developed by a lone old-school programmer Ludvig Strigeus who wrote a BitTorrent client in a few hundred kilobytes (yes, that’s not a typo) which is a real pleasant surprise in this age of bloated Java applications with 100 MB memory footprints. It was bought out by BitTorrent Corporation which raised some concerns among the user base but the client has retained all of its functionality and the new owners have done a good job of maintaining it.

Skype - This is another killer-app for the modern personal computer. If you haven’t already heard of it and installed it, go get it. It’s the first and one of the few VoIP applications on the market that “just works”. Couple it with a good analog microphone or something like the Polycom Communicator and you will be able to send superb wideband audio which is amazing compared to the normal narrow band audio you get on a telephone. If you add Whiteboard Meeting which has a free limited version, you now have a mission critical business collaboration application.

Paint.NET - This is just a nice free replacement for Windows Paint. It requires .Net Framework 2.0 but that’s included in Windows Vista. For a managed programming language, it’s not that bloated and loads relatively quickly. I would love to see RAW image file support along with Lanczos3 image resizing algorithm but these aren’t supported. That softens my enthusiasm for Paint.NET but it’s still a simple image editing application that is very useful.

Infra recorder - If you don’t have a Nero (OEM or retail) for your CD or DVD burner or some other burner application, Infra recorder is a good free alternative. Not only that, it’s a lot less bloated and it has a small memory foot print. While Nero has some great functionality, it comes with too many applications and extra features that gunk up the system though you don’t have to install all those features. It won’t let you do simultaneous DVD or CD burning or other advanced things that Nero lets you do, but it does what it does well and it’s a lot better than what comes with Windows XP or Vista.

Dr. Divx - For anyone who wants to take their movies on the go or backup their DVDs to a smaller format, this is an excellent free solution. Unlike the commercial Divx encoder (which I bought and can’t use), Dr. Divx actually works in Windows Vista. A really cool feature is the ability to handle .dvr-ms files including HD footage from HDV cameras as input. The Divx output can be played in something like this $40 up-converting Philips DVD player on your TV set or it can be played back on any computer. The down side to Dr. Divx is that it is single threaded which means it can’t take advantage of both CPU cores nor can it take advantage of SSE4 on the new Intel 45nm processors which can have a huge impact on performance. Hopefully this will be addressed in future versions. For now I’m just happy that I finally found something to encode my .dvr-ms HD content. Note that you do need to download and install the Divx codec for Dr. Divx to work.

FastStone Photo Resizer - This is an absolute killer application for anyone who deals with images. It can batch resize, rename, and convert images of all formats and sizes. Unlike Paint.NET it does support Lanczos3 image resizing which is a superior algorithm for maintaining as much image fidelity as possible. It installs simply and operates quickly. If you’ve ever taken a load of 2 to 4 MB digital images and you need to distribute them via email or web, you don’t want to spend hours uploading and making your family and friends mad when you make them wait for 100 MB of downloads. FastStone is the perfect mate for digital photographers and bloggers. The only criticism I have is that it doesn’t support RAW files as an image source.

K-Lite Mega Codec pack - If you (or someone else you know) are the kind of person who likes to download videos (especially from questionable sources promising adult content) and you don’t want to end up with malware, K-Lite Mega Codec pack plus QuickTime Alternative is for you. This is CRITICAL security advice that everyone needs to know about. If you can’t play whatever you downloaded with K-Lite’s included codecs and QuickTime Alternative, then trust me, DELETE that file immediately and DO NOT run it. Malware pushers will give you these video files which need special video codecs to play, or so they claim. You download those special codecs and install them and I can assure you that it is no longer your computer.

IZArc - As good as the built in CAB and ZIP utility is in Windows XP and Vista, it isn’t enough because you need compatibility with all the other compression formats out there. IZArc will open any compression format under the sun and it’s free unlike a lot of other utilities on the Internet. Get it, install it, and never worry about some compression format again. If you download something from BitTorrent that claims to be some special compression format and you need another one of those special utilities to open it, the safe bet is to delete that file because there is a good chance that the utility to decompress the file is malware. Don’t fall for it!

CCleaner - CCleaner stands for Crap Cleaner. It is a great registry cleaner and temp file cleaner (note that the built-in disk cleanup utility in Windows XP or Vista will also do a lot of this). I’ve used this application to clear out gigabytes of trash on PCs. It also has an excellent uninstaller and you’d be surprised to see how much junk you can find with it. One note of caution, it does come bundled with web toolbars so be sure you uncheck it if you don’t want it.

Autoruns - Autoruns is an essential tool from Sysinternals (now owned by Microsoft) in the war against crapware. See How to fully de-gunk crapware (experts only, don’t try it unless you know how to recover Windows).

Process Explorer - Process Explorer is another essential tool from Sysinternals for diagnosing computer problems and finding potential malware on your computer. It shows you exactly what’s going on in your computer in an easy to read tree view.

AVG Antivirus Free Edition - Most people who have read my blogs in the past know that I am not a fan of anti-virus. To me the only good anti-virus application is no anti-virus but I realize that most consumers need some kind of protection from the hostile Internet and often themselves. So a really nice compromise is AVG Antivirus Free Edition which has a really small footprint and doesn’t slow your computer down to the point where your dual-core PC feels like an 80286 computer circa 1982. Best of all, it won’t hold you hostage for another $80 to renew your annual anti-virus signature subscription since this is FREE. If you bought a new computer, be sure to remove all of the demo AV software first.

VASILI
May 17th, 2008, 11:14 AM
huwaw halos kalahati nyan dinownload ko sa net kase libre at napaka ganda gamiten....

try nyo tcp/ip repair kung mabagal internet nyo

revo uninstaller para pag nag install kayu na hinde natuloy at naputol eh burahen nya yun junk files na naipasok nya sa pc nyo...

daemon tool virtual drive to ingat lang sa pag install kase itatanung nya kung gusto mo install yun start up page nya na may spy ware

littlebadboy
May 17th, 2008, 11:47 AM
try nyo tcp/ip repair kung mabagal internet nyo

ano pangalan sir at saan maka download?

joms_ini
May 17th, 2008, 02:39 PM
ano pangalan sir at saan maka download?

i think vasili was referring to this

http://img91.imageshack.us/img91/959/71392277sh1.jpg (http://imageshack.us)
http://img91.imageshack.us/img91/959/71392277sh1.64e4b7e455.jpg (http://g.imageshack.us/g.php?h=91&i=71392277sh1.jpg)

If u like to override your internet connection use this tool

http://www.j79zlr.com/cablenutXP2k.php

Also hindi lang software ang niraraid ng OMB ngayon pati CD-Writers and DVD writer!

kung may CDwriters kayo better tago nyo nlang, salpak nyo nlang kung gagamitin

VASILI
May 17th, 2008, 03:43 PM
nope hinde yan pag putol lang internet mo jan sa repair e


eto yung sa desktop ko
http://i239.photobucket.com/albums/ff23/vasili_pao/tcppsettings.jpg

dito mo madownload kung may gusto ka pa idownload e iscan mo muna kung may virus jan ko ren kinuha yun aken walang virus
http://www.download.com/XP-TCP-IP-Repair/3000-2094_4-10410929.html?tag=lst-1&cdlPid=10410930

joms_ini
May 17th, 2008, 06:25 PM
nope hinde yan pag putol lang internet mo jan sa repair e


eto yung sa desktop ko
http://i239.photobucket.com/albums/ff23/vasili_pao/tcppsettings.jpg

dito mo madownload kung may gusto ka pa idownload e iscan mo muna kung may virus jan ko ren kinuha yun aken walang virus
http://www.download.com/XP-TCP-IP-Repair/3000-2094_4-10410929.html?tag=lst-1&cdlPid=10410930

mukang same naman yata sila ng purpose just renewing your IP address and clearing up DNS cache:)

littlebadboy
May 17th, 2008, 07:57 PM
dito mo madownload kung may gusto ka pa idownload e iscan mo muna kung may virus jan ko ren kinuha yun aken walang virus
http://www.download.com/XP-TCP-IP-Repair/3000-2094_4-10410929.html?tag=lst-1&cdlPid=10410930

hey thanks!

question po, how and when do i use this thing? a wireless router is connected to my pc eh.

VASILI
May 17th, 2008, 07:59 PM
download mo lang merun naman jan step by step

pag laggy ang connection o tipong mabagal na paputol putol yan ginagamet ko...

kung gusto mo naman yun mga ccleaner merun sa filehippo.com maganda yun ccleaner binubura nya yun mga junk files na nasa registry para masbumiles ang pc mo

enoch
May 19th, 2008, 11:51 AM
Also hindi lang software ang niraraid ng OMB ngayon pati CD-Writers and DVD writer!

kung may CDwriters kayo better tago nyo nlang, salpak nyo nlang kung gagamitin

Huh? parang di ko to ma-gets.. bawal na din cd or dvd-writers?!

joms_ini
May 19th, 2008, 03:52 PM
Huh? parang di ko to ma-gets.. bawal na din cd or dvd-writers?!

OT

yup u read it right

OMB required to register your CD-DVD writers even selling recordable disc.

so better remove or hide your cd writers pgnaraid kayo kuha yung CPU nyo:crazy:

http://www.omb.gov.ph/

hayden
May 19th, 2008, 06:24 PM
nice topic

tnx! :D