Script to keep track of how much weekly currencies can your raiders still get.
The setup consists of three steps:
- Get the current crest data from WoWAudit. This process is the most convoluted as it tries to expose as little information as possible to the open.
Caution
Script will NOT function properly unless the steps on the section [#WoWAudit Instructions] are precisely followed.
- Manually add droptimizer URLs to the
urls.txtfile. - Run
main.py.
Note
If you do not want to redownload the data and just create the output table, you can use main-py --no-refresh to skip the download step.
- Import the file
output.csvto Excel/Google Sheets for ease of view.
- Weekly caps are wrong!
Yes, this is because of laziness. Due to there being sources of capped and uncapped crests, I've used whoever has the most crests of your roster as the current cap.
If anyone knows the current cap of each type of crest (including uncapped sources), feel free to send me a message on Discord (
.eweer). I'll implement it right away.
- Sparks make no sense!
Yes, that's a WIP. I just wanted to publish the Crest functionality ASAP.
- On a gmail account that has access to the "Overview" tab of the WoWAudit spreadsheet, make a copy (File -> Make a Copy) of the following link: Spreadsheet.
- Paste your WoWAudit spreadsheet URL on the blue cell.
- File -> Share -> Publish to web.
- Choose
Dataon the left dropdown:
- Choose
Comma-separated values (CSV)on the right dropdown
- On
Publish content and settingsClick onEntire Documentto uncheck all, and then chooseData:
- Click
Publish:
- Copy the link of the published data:
- Open the
config.tomlfile with any text editor and paste the link on the url field:
Important
The pasted link must go between quotes