Made a new spreadsheet to keep track of Project Tokens for people.

ModDaenrysTargaryen·8/1/2019, 8:10:55 PM·2 votes·1,130 views

Hello Guys I have updated my previous spreadsheet that helps keep track of tokens you earn with the pass and helps you keep pace throughout the event. I had fun making it . To be able to grab this spreadsheet, go to File>Make a Copy(at least that is what it shows on my side) Link of the spreadsheet [EVENT HAS ENDED] How it works https://imgur.com/a/ySZyVhI

##Fields

#1= The Field which you put all your data in: Your Summoner Rift Wins/Losses, your ARAM Wins/Losses Your TFT Placements, and your First Win of the Day

#2 The amount of tokens you want to get to, if you just want to get 200 or less this spreadsheet WILL NOT work for you. YOU MUST FILL THIS OUT

#3 FILL THIS IN ONLY if you started the event Without using this Spreadsheet to begin with, Input your tokens that you currently have in your Loot tab in client and ONLY FILL OUT CURRENT DATE AND ONWARD. if you already have gotten first win of the day for the date you started using this put a No or 0 for FWOD on said date. DO NOT CHANGE THIS NUMBER ONCE YOU SET IT IF YOU USE THIS

#4 If you want to a specific amount of tokens a day instead of the amount that is calculated for you.

##Information

#5 What you have gotten for the day.

#6 What you have gotten added up over the days.

#7 What you need to get to to be on pace.

#8 How much left you need to be on pace. (Negative numbers mean you are doing better then pace)

#9 Stats Tab, gives you info about your games and winrate, for calculations for TFT I consider being top 4 as a win.

I have removed mission Calculation from this spreadsheet, as it was bugged in the last spreadsheet and it was honestly way to hard to keep current for me. so the missions are not even calculated in this spreadsheet, so if you do complete them you will have extra tokens then what this spreadsheet will say.

If you have any questions ask them below and I will answer them and if you have any Suggestions that you want to be added just Message me. If you find any bugs let me know.

while I made this to help all of you, I would suggest you double check your current tokens in your loot tab every once in a while to make sure you are 200(Free pass tokens)+ or more above the amount listed in added total tab.