@Hiryuu,
Hiryuu wrote:
Pecky - how long did it take you with Excel? I sent my answer in about 20-30 minutes after the question came out. I really hope I got in top 10
Actually, I sent you a PM about it. I sent mine in slightly before that PM. It took me 5 minutes. Literally, for me it was =b2b(36, 10, $A1) in B2, =pfactorize($B2) in C2, and =IF(LEN($C2)=0,0,LEN(TRIM($C2))-LEN(SUBSTITUTE(TRIM($C2)," ",""))+1) in D2. Then Just checking the Pet Central for all species on my other computer (for speed).
After that, I just had to sort a couple times and =(Absolute Address) for 3 boxes. =SUM(Range), and a last =b2b(10, 36, SUM(Range)) and there was my answer.
All in all, I would say about 5 minutes from looking at the question to getting the answer. I really don't know when the question came out though. I mentioned my final tomorrow? That was what I was doing until I hit my break and remembered to check neopets. lolz.
- PeckyP