27th May 2008, 11:47 am by Ivan Radenkovic
Couple of years ago I’ve faced with unpleasantness when I’ve upgraded couple of Windows 98 workstation to Windows XP: FoxPro 2.6 applications simple consumed so many system resources that everything is hit: printing takes longer than usual, network traffic throughput is reduced since processor does not have free time to deal with these issues, it’s mainly occupied with currently running MSDOS session with foxpro application within. Some recommendation was to adjust idle sensitivity settings on shortcut but it does not solve the problem: depend of settings you can choose between two extremes: to confess all resources to foxpro process, or to take them from it (in which case foxpro application is running very slow - almost useless). Continue reading ‘FOX 2.6 DOS consume your resources?’ »
20th May 2008, 12:53 pm by Ivan Radenkovic
Several months have passed since I’ve become a proud owner od Western Digital My Book 750Gb External HDD which came in blue carton box (this version shipped with eSata, 2xFirewire and 1xUSB ports). Initially it was or I choosed to format with FAT32 file system since there were no requirements for some security issues and that was reason to discard NTFS option. After two months I’ve realised what mistaqes it was. Due to 2Gb file size limit I was unavaiable to store my several vmware virtual machines on this drive, they required more additional work (to split virtual hdd into files of 2gb) and after this there were no problem with my virtual machines.
Continue reading ‘Convert FAT to NTFS using CONVERT.EXE’ »
9th May 2008, 12:08 pm by Ivan Radenkovic
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!
Continue reading ‘Buxfer - Money Managment Web Service’ »
8th May 2008, 01:19 pm by Ivan Radenkovic
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…
22nd November 2007, 04:02 pm by Ivan Radenkovic

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… Continue reading ‘MS Office: Link Excel to Access’ »
2nd November 2007, 12:00 am by Ivan Radenkovic
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. Continue reading ‘MS Excel: ISERROR Function’ »
1st November 2007, 10:26 am by Ivan Radenkovic
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? Continue reading ‘MS Office: Accounting Express 2007’ »
26th October 2007, 09:57 am by Zoran Cirkovic
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! Continue reading ‘Does Microsoft have any program without bugs?’ »
21st October 2007, 12:00 am by Ivan Radenkovic
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. Continue reading ‘Usual day with ERP users’ »
19th October 2007, 10:00 am by Ivan Radenkovic
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. Continue reading ‘MS Excel: VLOOKUP and HLOOKUP Function’ »