Posts Tagged "PHP"

Time Value of Money – Excel PMT in JavaScript and PHP

Tuesday, May 12th, 2009

PMTI’m currently working on a project that happens to need a JavaScript and a PHP implementation of the Excel PMT function.  I won’t bore you with the details (but ask if you’re intrigued), but it has to do with Loan Modifications that are all the rage nowadays thanks to Obama Administration initiatives that will hopefully help Americans save their mortgages, prevent foreclosures, support real estate prices and generally speaking save the world from sure doom.

So after being handed an Excel spreadsheet that made heavy use of the PMT Excel function (and never having used said function), I proceeded to research this beast.  Let me tell you, there are lots of very confused people searching for solutions on how to implement it in various languages, trying to figure out how the function works, etc, etc, etc. I even came across some folks that think Excel / Microsoft is behind a sinister plot to undermine the world’s economy via a wrong implementation of the function.  Rest assured, I think Microsoft understands the Time Value of Money – TMV for those who still remember anything from their Finance class in college.  So I figured I’d do a little writeup of what I figured out to save somebody else the headache.


VIM for PHP Programmers

Wednesday, February 11th, 2009


I came across a pretty good presentation by Andrei Zmievski from Yahoo! Inc.  Its a 77 page walk-through of VIM for PHP Programmers – quite comprehensive!  It covers essentials like setting marks and jumping to them quickly – which was a personal pet peeve of mine.  Little did I know vim had that covered – even global marks across files :) !  Of course vim is a bottomless bucket if you’re going to pour sweat into learning it, Andrei admits it quite succinctly on slide 18 for instance – “vim regexp language is too sophisticated to be covered here.” ;)