Looking for direction?…
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’ »
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?’ »
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’ »
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’ »
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. Continue reading ‘MS Excel: IF Function’ »
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. Continue reading ‘Master Data Purge’ »
At its simplest level, ERP is a set of best practices for performing the various duties in the departments of your company, including in finance, manufacturing and the warehouse. To get the most from the software, you have to get people inside your company to adopt the work methods outlined in the software. If the people in the different departments that will use ERP don’t agree that the work methods embedded in the software are better than the ones they currently use, they will resist using the software or will want IT to change the software to match the ways they currently do things. This is where ERP projects break down.
Be alerted to an issue in Excel 2007 (and Excel Services 2007) which involving calculation of numbers around 65,535. The first example was =77.1*850, but it became clear from testing as well as additional reports that this was just one instance where Excel 2007 would return a value of 100,000 instead of 65,535. The majority of these additional reports were focused on multiplication (ex. =5.1*12850; =10.2*6425; =20.4*3212.5 ), but testing showed that this really didn’t have anything do to with multiplication - it manifested itself with many but not all calculations in Excel that should have resulted in 65,535 (=65535*1 and =16383.75*4 worked for instance). Further testing showed a similar phenomenon with 65,536 as well. This issue only exists in Excel 2007, not previous versions.
You can open Excel and within Excel you can open XLS files, but not with double click on XLS file in windows explore. This is not a solution for the issue above, it’s bypass with some side effects. You have to disable DDE for selected file type and to pass XLS filename to Excel as parameter. Side effect is with each doubleclick on XLS file you will start new instance of Excel but using existing one. This will affect windows ability to group similar buttons on taskbar. Continue reading ‘Slow opening Excel files through explorer’ »
I would like to thank my friends in Greenfish Web Design Company for moral and technical support during www.radenkovich.com site creation. Sure they have my best recommendations!