Let me start by saying, your worksheet is awesome! It's a great idea and I can tell you've put a lot of hard work into it!
I've updated a few things and over the next few days, I should be able to update more. Primarily info for the Lovebirds, Iguanas, Pomchis and Russian Blues.
Now I noticed a few errors. 1.) I believe you are missing the Labradoodle. 2.) For some animals, the rank 1 information is for one animal, instead of the family of four. 3.) And I think on some, the coins collected reflects the played with amount. When a pet has been played with, it adds $20 to the payout.
I also noticed a trend. The rank 2 amount, in most cases, is exactly the mid point of rank 1 and 3. This is only not true when there is an odd amount collected. But if 1 and 3 are even, then 2 is the mid point. For example, if 1 is $100 and 3 is $200, then 2 will be $150. If 1 is $100 and 3 is $199, then 2 will either be $150 or $149. Make sense? So by that logic, you could fill in rank 2 for a lot of animals.
And one other thing. I can't tell if this is the case or not, but wouldn't rank 1's payout theoretically be 4x the amount of one animal. For example, if you know that one animal pays $10, shouldn't four pay $40? I mention this since any pet still in the market has the payout for one animal. You could multiply it by four to have the rank 1 total. Like I said though, I can't tell if this is accurate or not.
Well, I hope some of this has helped. Maybe it'll allow you to fill in more spaces. And again, your work really is amazing!