Hi guys, first time poster on here. I was wondering if anyone knew anything about google sheets script?
I currently have a WvW Skirmish Ticket helper spreadsheet.
We don't have API endpoints for pulling pip progress so I currently enter the following into a spreadsheet:
Shopping list -
You can select which items youre aiming to get. Eg Selecting each piece of Triumphant armor and 6 Legendary War Insights. It will calculate the total amount of tickets this costs / how many left to earn / How many you can get this week etc
My current spreadsheet will use this data to estimate various stats for you:
How many weeks of hitting your target chest you will need in order to get enough tickets
-- Estimated Tickets and remaining weeks both before weeks progress and after weeks progress
Estimated end date for having enough tickets
What I want to do:
I know Gw2Efficency has a lovely api for drawing the pvp match progress. I would like a visual representation of your current WvW Skirmish chest progress. I would like to pull the necessary pip graphics, and have them display depending on your current chest/tier/pip data (already recorded in some cells).
Eg: If im in Silver Tier, draw green pips. 4 sets of 10 and a set of 5 (i already have the numbers stored in cells).
Maybe even have them click on the pips to update their progress
Anyone have any idea where i could go for doing this?