Simple Inventory and Sales Tracker Spreadsheet

If you are looking for a simple way to track your inventory and sales, here is a Excel 2007 spreadsheet that could be of help.

This Simple Inventory and Sales Tracker Spreadsheet has a tab that shows your current inventory, sales and re-stocking transactions.

Click image to enlarge Inventory tab

Credit Card and Consumer Debt Payment Calculator

Click image to enlarge

Most people have a hard time determining the right payment allocation for servicing debts. In general, there are two prevailing thoughts on this subject. These two debt repayment strategies are snowballing (suggesting that the debt with the smallest balance should paid first) and avalanche method (focusing on the interest rate with the debt with the highest one being serviced first).

This Credit  Card and Consumer Debt Payment Calculator spreadsheet is available to support these two debt repayment strategies - showing you how much money should be paid for each outstanding debt for that period. Aside from these two strategies, an third strategy is being introduced called Targeted Avalanche.

ISPF as a training aid

Recently, I received a query from a Project Manager - could I setup a training tool that could help application developers pick up site-specific commands. This was a major problem as his team is new and had limited experience on the application system being supported.

In the mainframe, this challenge is common with all the third-party and in-house utilities being added to the system. To address this, developers have two choices. First, they can either pick up the application manual but more often than not it is not available and sifting through the information in the manual could be quite a challenge. Second, they can search through existing programs and copy the syntax. The issue with this second approach is that this would not provide the complete view of the command syntax and may even perpertuate issues with mistakes being copied a couple of times better.

Mainframe FTP download in Excel

One of the many tasks that IT professionals do when working in mainframe systems is to retrieve data from the mainframe to the desktop. This requirement may range from adhoc downloading of code for review or backup to regular periodic reports.

Although there are processes integrated within the mainframe emulators, most of these involves alot of setup everytime you need to download a file. With this, I thought of creating my own tool that would simplify the process.