"Lucky friend rate (102 lucky friends in 115 days)"

#PokemonGO: I like working with spreadsheets and I hate inefficiency so a little after the friendship mechanic came out for pokemon go, I started tracking things in a spreadsheet so I could gift more efficiently (no blue glow back then) and easily get many people hitting ultra and best friends at the same time without making anybody wait. I don't really put any money into the game so it is fun for me to see if I can keep up with the hardcore players.When lucky friends came out on April 9, I knew this was going to be good for me. I already had 153 best friends by then and just added a few things to my spreadsheet to keep track of lucky friends also. Being able to sort and prioritize gifing (gift morrning openers first, gift highest % openers when on vacations, etc) help me to maximize getting the most best friend interactions each day.I've seen a lot of people have questions about lucky friends as it is so hard to hit one. So hopefully my keeping track of my lucky experience can be a little helpful for someone. I can try to answer any questions if it may be useful also.Below is a graph of my lucky friend percentage since things started on April 9:https://ift.tt/2YzOJZC far i've done 78 lucky trades and have 24 pending right now. Its can be hard to keep up with the trades and some people don't seem eager to do them! lol I saw someone in a nearby discord/group talking some crazy things about lucky IV percentages so i decide to track that also.https://ift.tt/2Ynsue7 # lucky with one person ................. 5 (the fifth one with her was #100!)longest dry spell - ...................................... 7 days (550+ best friend interactions)"luckiest" day - ........................................... 5 new lucky friends (on April 12th)average daily best friend interactions - .... 8805 / 115 = ~77average lucky friends per week - ............. 102/115 = ~.89 * 7 = 6.23 per weekcumulative lucky friend rate - ................... 102/8805 = ~1.16%average lucky trade Ivs - ............................ 89.77% : 13.30/13.57/13.56current # friends - ....................................... 200current # best friends - .............................. 162peak # of best friends - .............................. 169​tldr cheap spreadsheet nerd plays pokemon go, got lucky friends and kept track of things via /r/TheSilphRoad https://ift.tt/33hNG4a