Tag Archives: productivity suite

Using spreadsheets for home economics.

I love spreadsheets.  With a few formulas you can calculate your budget, right down to the earth’s gravitational field.

They can also help you calculate the TOC of an operation, in realtime, and make more accurate analysis when doing logistics.

This is especially useful when you’re moving to another city. Especially if you’re someone who travels light, is a practitioner of simple living and just want to know just how much you have and how that will affect your personal economy.

Well for me, since I am currently moving to another city, I wanted to know how much moving in my new  place would cost.

So I did a new workbook and divided it into three sections. The first is belongings, the second is groceries and installation fees and the last is “Grand total”.

In the “belongings” sheet I put the item name, the quantity and the Cost and if I had already acquired it or not. In “groceries” I had put the same.

The two, I linked their totals to the Grand total sheet, that way each time I changed a value on either of the pages, I would be able to quickly know how much money it had cost .

While simplistic, this can help one to be organized and really help you erase the stress of moving, or at the very least see how much this is costing you and what adjustments you will need to make financially.

The very same can be applied to all kinds of home economic projects, I will include these links to other useful excel workbook templates;

http://christianpf.com/10-free-household-budget-spreadsheets/

http://exceltemplates.net/

http://www.spreadsheetzone.com/

And for the libre-office/Open-office calc fans

http://templates.libreoffice.org/template-center

http://www.kaaredyret.dk/openoffice_links.html

Advertisements
Tagged , , , , , , , ,

Cat’s Meow – My Favorite Open-Source Replacements.

The Digital Cat's Meow

In my line of work, I get often asked if I can give them a copy of “XYZ” software, for home use. It’s the problem that many IT pro’s face, it’s the idea that you can be milked for free software, and who can blame people, software is ridiculously expensive.

Of course, there is the issue of licensing and other workplace “no-no’s” that come into play, but I have found a wonderful way to remedy the matter.

And for this I must thank the open-source movement for providing IT pro’s a myriad of tools that can be giving away for free without fear of the licensing hordes coming knocking on your door with pitchforks and torches.

But of course, I faced another problem. That one of compatibility. Sure a OSS (Open Sourced Software) that does the same function as a popular software is nice, but you have to be able to share your work with others? It has to be compatible with what they got!!

And that is one gripe that many users are confronted with. They would switch to a OSS, heck they would switch to a OS operating system (Linux) but the dark specter of compatibility rears it’s thrice cursed head and what seems to be a wonderful idea, turns into yet another headache for the helpful IT pro.

But I found a way around it. Well, not exactly. I found a method that works in coping with that unfortunate fact.

What I do, is find the OSS that comes the closest in look and feel and compatibility with a “commercial” software, and I make sure in can save in file formats that are universal. PDF’s are a good example. I haven’t seen an OS that adobe reader didn’t like.

Still, over the years I have found a few favorites, that fit the bill and that brought a twinkle to my client’s eyes, and my own.

 

Open Office/Libre Office

This M$ office clone is the OSS personal productivity suite for Windows, Macintosh and GNU/Linux, that gives you six feature-rich applications for all your document production and data processing needs: Writer, Calc, Impress, Draw, Math and Base.

I use it both at work and at home. I actually recommend it to everyone who wants it at home. It’s perfect, it never failed me when I needed something done and I didn’t feel like using M$.

My only gripe with it, is that they haven’t found a way (yet) to be compatible with M$ ACCESS. It would be nice though. But as far as the three basics are concerned (Text, Spreadsheets and presentations), it does a job an a half.

 

The GIMP

GIMP stands for  GNU Image Manipulation Program. It’s roughly a “Photoshop clone”.  Which has some good strengths, it’s got the same tools, the same capabilities and then some.  With some of the extensions I was able to batch-process a whole wackload of cliparts that were in WMF format (photoshop didn’t recongnize them somehow) into PNG with no loss.

The interface takes some getting used to, and those missing Photoshop can use the “Gimpshop” modification, which enables you to have gimp ‘look and feel’ like Photoshop.

 

Dia

A M$ Visio clone. As you will see on the site, it claims that is roughly like Visio. I will say this. It reminds me a whole lot like Visio 2003, only a whole heap better.  It’s a handy tool to have around if you want to remodel a kitchen or want to build a dungeon for a good ol’ fashion game of dungeons and dragons.

 

Thunderbird

I am not a big fan of M$ outlook. I find the 2010 version is confusing, and suffers from a case of user-friendliness deficiency.

So I recommend highly Thunderbird. It’s like outlook 2003 in “general” appearances, hence a little less confusing and, therefore,  less prone to generate headaches while using it. With extensions to enhance it and customize the user experience, it makes a great replacement for outlook.

 

Finally, if you need a specific software, but don’t know how to “replace” it, I can recommend osalt.com

It’s a nice way to learn about what’s out there and save a few bucks.

Tagged , , , ,