Butters.2807 Posted August 25, 2018 Share Posted August 25, 2018 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:Pip Chest Type (eg wood, bronze etc), selected from a drop downTierCurrent Pips earnedAverage pips per tickAmount of Skirmish Tickets (currently I use the API to pull this directly so theres no need to enter)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 etcMy current spreadsheet will use this data to estimate various stats for you:How many hours to finish current chestHow many tickets are left from this chestHow long until you hit your goal of diamondHow many hours you should put in for remaining days to hit goalHow 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 progressEstimated end date for having enough ticketsvarious other little details...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 progressAnyone have any idea where i could go for doing this? Link to comment Share on other sites More sharing options...
zabandija.9623 Posted December 11, 2018 Share Posted December 11, 2018 So nice! Keep it up! It'd love to see this in-game as overlay sounds very cool Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.