Buxfer – Money Managment Web Service

9 May 2008 by Ivan Radenkovic in Business, Casual | 1 Comment

For the last several months I’ve been trying to find apropriate solution to track my money incomes and expenses, together with budgeting… I’ve been tested several solution but if they were good enough there were not free, otherwise they have lack of functionality… I’ve spend some times on some spreadsheet documents I was able to download and try to adjust them to my needs… Even I made them suit my needs, it was only for the limited time due to lack of spreadsheet design and logic… I have had difficulties to reconcile with fact in case when I borrowing money to my friends, I’m the one who should record this transaction and later remind them to pay me back… And I’m not making any profit in that! It was too much… Then I’ve decided to look for some online solution and on third attempt I’ve discovered Buxfer!

I’m back online!

8 May 2008 by Ivan Radenkovic in Casual | Leave a comment

Due to security issues on previous WordPress engine, this blog has gone unmaintained for some time. Now it’s upgraded with newest WordPress 2.5.1 and hosted on powerfull Xeon server by kind staff of Greenfish web design team (thank you guys for supporting my blog site)…

We are ready to go on further…

MS Office: Link Excel to Access

22 November 2007 by Ivan Radenkovic in Business, Excel | Leave a comment

or on any other data source. Ms Access ability to process large amount of data may come very handy in many cases. Of course, you can perform those analyzes in Excel itself but doing it using Access is both much more comfortable and error-proof. Excel is irreplaceable when you should check less than hundred rows of data but when row numbers came to several hundreds and more possibility to make errors raise exponentially. At the other hand, Access operate with whole columns and it make this job easily as possible. On this post it will be explained how to link Excel on Access, but you can use the vary same method to link Excel on any other data source like text files, xBase, ODBC…

MS Excel: ISERROR Function

2 November 2007 by Ivan Radenkovic in Excel | Leave a comment

Excel Icon IsError function is used to check for errors in expressions or cells. At first sight most usefull case when you will need to use this function is to suppress division by zero error automatically. If not, you can always check for #DIV/0! cell by cell – but it would be inappropriate use of all this comfortable technology. This can’t be done without IF function which one is described in previous post on this website right here. You can save lots of your time resources and energy just by using combinations these two functions.

MS Office: Accounting Express 2007

1 November 2007 by Ivan Radenkovic in Business, ERP | 2 Comments

Microsoft campaign for Office Accounting Express 2007 say it is an essential tool for managing your business finances. Whether you’re a small or home-based business, you can use this accounting program to make pen and paper-based tasks a thing of the past. With the familiar look and feel of Microsoft Office, Office Accounting Express 2007 helps you get organized, save time and sell online. Sound nice?

Does Microsoft have any program without bugs?

26 October 2007 by Zoran Cirkovic in Casual | Leave a comment

The idea-generator for this post is another post about bug in Excel 2007. It is not small bug, it is 10 000 – 65 535 = 34465 of something (dollars or euros perhaps). Anyway, my post is not about Excel. When I heard for this Excel bug I asked some of my in-love-with-microsoft-friends a question: ‘is there some microsoft’s program without bugs?’. There was many answers (there is no bug less software etc…), but one of them says that there is one program that is 100% bug free – NOTEPAD!

Usual day with ERP users

21 October 2007 by Ivan Radenkovic in Casual | 1 Comment

ERP developer job has it own advantages. Working directly on increasing level of implantation and watching how successfully it is. Users satisfaction is at the same time my own. It would be haven if it could be like that all the time. Here (but not hereby) I will describe one recent event. Participants are: Developer, Absent Female User, Female User, Male User, Young Female User and Developer.

MS Excel: VLOOKUP and HLOOKUP Function

19 October 2007 by Ivan Radenkovic in EN, Excel | 7 Comments

Excel Icon Excel’s VLOOKUP and HLOOKUP function, which stands for vertical and horizontal lookup, is used to search for wanted information stored in sheet which could be in same or different XLS file.

If you have sheet “order” with enlisted items and sheet “prices” with items price list you can search for the prices of ordered items to calculate total amount of order.

If you have sheet “overdue” with enlisted over debt partners for sending warning letter and you have sheet “partner master data” with full partners addresses, you can search for selected addresses using these LOOKUP function.

MS Excel: IF Function

18 October 2007 by Ivan Radenkovic in EN, Excel | 1 Comment

Excel Icon Very useful function in Excel is this one. It tests a value in a specific cell to see if that value meets a certain condition. If condition is true, first result will happen, if false, a second result will happen.

It looks complex (especially combined with VLOOKUP – my favorite one) so many people avoid using it. It was complicated to me in beginning but after some time I’m stopped to notice it complexity. Now, its use is so mechanical, I’m not even think much of it when I’m using it.

Master Data Purge

17 October 2007 by Ivan Radenkovic in Business, EN, ERP | Leave a comment

Sometimes master data in your ERP or similar software could be full with obsolete definitions not used anymore. It could look like they should be erased from databases to make data more reliable. There are to many reasons not to do it. Regardless it is item master data, partner master data or any other master data type… Once opened master definitions should exist for all eternity. Clearing those unused definitions could cause more troubles than benefits.