Boards›General Discussion

Made a spreadsheet to keep track of Arcade Tokens for people.

ModDaenrysTargaryen·6/28/2019, 8:02:24 PM·7 votes·9,161 views

Hello Guys, I have bee working on a Spreadsheet that helps keep track of tokens you earn with the pass and helps you keep pace throughout the event. It took quite a while for me to make but was fun doing 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 (Removed Link) Event has Ended How it works https://imgur.com/BQSlBau ##Fields

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

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

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

#4= Your Missions, Input Yes if you completed It. Missions are Calculated on the start of the week they are launched in the chart.

#5= 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

##Information

#6= What you have gotten for the day.

#7= What you have gotten added up over the days.

#8= What you need to get to to be on pace.

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

Alright, so a bit of extra stuff for you to look at if you want. I have a stats tab that will show you your stats and as you can see in the screenshot I have some graphs.

The Reason why you start off at -120 once you put in the amount of tokens you want is because the way I calculated missions into this is if you have not done the mission it is subtracted, so once you get the missions done you will not see the negative number.

Please Keep in mind this is the first release of this, The math could be wrong at some points and make it so you are paced wrongly, which is why you should double check my work a bit to make sure you are going to make it. I do not want you to miss a reward because I made a mistake I tried my best to double and triple check my work

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.

Update 1: There is 1 thing I could not test and that was the start of the next weeks missions, so if it bugs out during that time I will update it with a fix if it needs it.

Stats are a little messed up right now based on how missions are calculated. will fix that for next event.

Update 2. I have realized that the way the missions are added into the spreadsheet could confuse some people about how many tokens they actually need a day, I will add something for the next event to rectify that.

Also there is only 1 Mission that gives out 60 tokens, and its the first one I put on my spreadsheet so make sure you got that event correct when you check it off.

MAJOR UPDATE 3. I messed up on Calculations with #5 I WOULD RECOMEND IF YOU REDOWNLOAD this or your calculations are messed up

16 Comments

Rodsquad6/28/2019, 8:17:57 PM1 votes

This is really nice, thank you!

CyberiumShadow6/29/2019, 7:20:28 AM1 votes

I had a go at editing the spreadsheet to fit for the OCE event schedule, which I think I've done by changing the Date 1/2/3/4 serials in the data sheet.

however this resulted in "added total" going into the negatives.

Would you mind giving me a bit of an assist to figure it out?

Edit: I'm dumb

Thanks for the good work you've done :)

Cheers

KRAM1Art6/30/2019, 1:47:46 AM1 votes

~~I'm having a bit of an error on the spreadsheet. I downloaded it to my desktop and it's coming up with calculation errors. I got some errors when I tried to first open the document in Excel, and Excel is totally over my head so I had no idea what was going on....

It says there was an error in opening it and it's asking if I want Excel to repair it. When I hit no, it doesn't open. When I hit yes, the calculated columns just end up having "!Name" or "!Value" inside of them~~

Nevermind!! Made a copy into my Google Drive and it works flawlessly. Thank you for doing this!

RawrmenNoodles7/3/2019, 1:30:38 AM1 votes

So if I spend some of the point I have while using this would I subtract the amount I spend from box #5?

BlueLegend167/3/2019, 10:49:36 AM1 votes

Thanks for this file! It is helping me already. Except there is this one calculation which seems strange to me. The negative calculation of the missions. I'll explain it using my own situation. I need 2000 tokens. You subtract the 200 tokens which you get for buying the pass. This means my column 'Expected' totals 1824. (still correct so far) In my loot tab on the lol launcher it says I have 490 tokens (170 from playing, 120 from missions and 200 from buying the pass). This results in me having 1510 tokens to go. Your sheet gives me an 'Added Total' of 170 meaning 'Needed Left' is 1654 tokens (1824 minus 170) although I completed the missions and 'Needed Left' should be on 1534. Now that you know my situation. Am I missing something? Maybe you just had a different thought process. If so, care to explain?

BlueLegend167/4/2019, 8:41:49 AM1 votes

I added the following to my sheet so I am able to see how many tokens I need to earn everyday from the current day forward to get to my goal. So next to seeing how far behind or ahead I am compared to the schedule, I can also see how many tokens per day I still need.

=roundup((I34-H34)/(row(A34)-match(Data!E6,A:A)),0) I34 = Total 'Expected' H34 = Total 'Added Total' A34 = 'Total' (one below the last date to get the correct amount of days left) Data!E6 = Current Date

With this I check the amount of tokens still needed to get to the goal and divide it by the amount of days left on the event. Feel free to use it however you like.