After creating a better way to analyse the loans I make through Kiva, which led me to seriously start bagging countries to fill up my map of loans, I was looking for a way to highlight new countries so I could pounce on loans before they got fully funded.
I created my first Greasemonkey Script (Kiva Country Highlighter) to do just that – it looks at a list of countries I am interested in and will highlight them in the list of loans on the Kiva website. It has allowed me to bag a couple of rare countries so far, though there are still a few more I am keeping a lookout for…
So with the development made by Kiva it is now possible to export an Excel Spreadsheet with all you loans – a great step forward but it did leave a little to be desired, and the format made it hard to analyse…
I have created a spreadsheet (in Microsoft Excel and OpenOffice.org Calc formats) which will analyse the data further, splitting fields to allow better sorting, and fields that contain numeric information are now formatted as proper currency or date fields.
Basically you just copy a fresh download of your Kiva Export into a ‘My loans’ tab in the spreadsheet – it does all the necessary using functions, formulas and calculations. No macros are used for those worried about security risks.
I have just finished putting together a calendar promoting Kiva from a suggestion, and a whole lot of hard work, through kivafriends.org – I might be biased but I think it is fantastic.
From a suggestion, and a whole lot of hard work, through kivafriends.org a calendar was developed to promote Kiva. Polls were held to select the photos, and to develop the layout I created.
More information on the entrepreneurs featured in the calendar can be found here on the kivafriends.org website.
So I decided that I am going to try my best to highlight Kiva. After putting a banner on my blog and a footer to my emails I felt something was missing – buttons!
I could not find any, so made a few (then a few more). I hope everyone likes them.
Please feel free to use them (but don’t link to them, download the one(s) you want and save them to your site)…
If you want to make your own I would recomend checking out Brilliant Button Maker by LucaZappa.com.
For those interested here are the hex colours:
- Dark green: #23582c
- Lighter green: #5c9c5f
- Lightest green: #d9ecb0