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.

Read more »

Envelope Method Budgetting in Excel 2007

Most people find tracking where their hard-earned money went hard. There are many solutions available but nothing works as good as the envelope budget method.

The concept of envelope budget is pretty simple. When you get paid, you allocate all of your money into pre-determined outgoings (expenses and savings) - traditionally through marked envelopes. This way you guarantee you don't spend more than your income or beyond what you allocated for each expense category.

Read more »