I would love to spend some time on this, but I just can't at the moment and what spare time I am trying to find will shortly have to be focused on picture and calendar stuff which I am also way behind on.
The copy of the spreadsheet et al you have been using was my early prototype and only hacked together for fun. This version is a bit more polished:
http://www.editgrid.com/user/kivaexport/Kiva_Loans-no_additional_data and you should be able to find some useful formula to reuse - including working map factor (which is overridden if you include coordinates on a per loan basis).
Chris, I need some help again, the map factor doesn't work, and the KML latitude and longitude coordinates are not replaced by the info in Additional Info
and the status of the loans on the first page no longer works however that may not be important, Chris, because I don't know how you made this and Kiva has changed their XML format for exporting it would be nice if you could update the spreadsheet if you had extra time on your hands...