FundraisingLoans spreadsheet

[Guest]

.

[YowieFreak]

My particular "why" is that, even though I find your spreadsheets very useful for various purposes, e.g., finding duplicate listings, I still prefer the image-oriented Kiva Lend Page for browsing selected subsets of listings.

  I must admit that, when I asked the question, I guessed that would be the answer.

How about I change the Partner tab so that the "Partner ID" becomes the link to the normal partner page, and the "Name" becomes a link to the current fundraising loans for that partner (sorted by repayment term just to keep you happy - or perhaps by old to new to keep others happy - hmmm - major dilemma there).

Anyone else want to put up their hand and say that this change is not a good idea?

[RichardF]

Yeah, sure, that sounds like a great idea!  Whatever you decide is fine with me.   

[YowieFreak]

Version 1.02

I have just updated the spreadsheet and attached it to the first post in this thread.


This version is a very minor change to v1.01.  The partner page now uses the Partner Name to link to the currently fundraising loans for that partner on Kiva's website (for those people who can't read a book without pictures ).  And the Partner ID now contains the link to the applicable partner page on Kiva.

[RichardF]

 

[YowieFreak]

Oops - there is a "bug" in the version I uploaded.  It won't update the Partner data until after October 11 at 1pm (your local time).  It's not something wrong in the macros per se - just the data in cell A1 of the Partner tab as I uploaded it.

Partner info is only updated if it is more than 12 hours old, and I left a time last updated in that cell which was too recent.  (Normally I manually edit it so that it is several days old before I upload it.)

If you wait until after 1pm on October 11, everything will work again normally.  Or manually change cell A1 if you are impatient.

[YowieFreak]

I just saw a tweet saying "buildkiva: Nuclear Spike launches the first Kiva app that lets you shop offsite of kiva.org! http://bit.ly/ruWG2".

I guess, once again, the Fundraising Loans spreadsheet doesn't rank as far as Kiva is concerned.

[JohnR]

Ian, thank you for your wonderful spreadsheet.  I've used it several times and it helped me locate a loan I wanted and would have otherwise missed.

I do have a request, though.  (Did you see that one coming?  )  I use it because I don't have access to Firefox (I used a company laptop and they won't allow it) so it is the only way I can sort by currency risk.  Could you put out a stripped-down currency risk spread sheet?  For me, it would only need to have the link to the borrower's page, the country, the MFI, and the currency risk status.  I only use your spreadsheet to filter out loans that have currency risk and then to look at them by country.  I don't mind clicking to the borrower's page to get the dirty details.

If you could do this, then it would load much faster, I think, which is the goal behind my request.

Thanks for considering this.

John

[YowieFreak]

If you could do this, then it would load much faster, I think, which is the goal behind my request.

The problem is, to obtain the currency risk indicator the macros have to make a call to the API which also returns all the other "detailed" info.  And it is the call to the API, and the return of the data, that takes about 99% of the time.

[RichardF]

John, you always can just upload the browser bookmarks for the Fundraising Loans NOT Sharing Currency Exchange Loss.  That way, you get pictures too! 

[JohnR]

Ian, thanks for the explanation.  The wait is still worth it.

Richard, I didn't completely follow your instructions; I'll have to come back to it later in the day when my brain is more active.

John