brewk / wowspreadsheet Goto Github PK
View Code? Open in Web Editor NEWWorld of Warcraft character tracking spreadsheet for Google Docs
Home Page: http://bruk.org/wow
License: GNU General Public License v3.0
World of Warcraft character tracking spreadsheet for Google Docs
Home Page: http://bruk.org/wow
License: GNU General Public License v3.0
Users who track too many characters, do too many refreshes, or leave their sheet open for long periods risk locking themselves out of their sheet for the day by hitting google's daily 20,000 URLFetch limit. Currently the sheet is limited to 100 characters for this reason.
After API migration in march 2020 the quest API no longer gives us this info
need logic to prevent the N/As from causing errors
At this time there is no Torghast info in the API that we're aware of
array formulas need to be adjusted to display all value fetched, and all sheets should be doing the same max number of appcalls. right now there's some mismatching between master vs raw, and likely elsewhere as well.
toonName = myUtils.lowerCaseAllWordsExceptFirstLetters(toonName.toUpperCase());
seems to be doing something very funky with folks with very special names
sargeras Åïmßøt -> ÅÏMssøt
This is just a test and can be closed.
enchant audit table will need to have values added/updated. we now have chest armor enchants that give +all stats which will need some special handling
We would like to have the possibility to change the language of the sheet.
I've seen that in the code, when you call the API it finishes "&locale=en_US". I don't know very much about that but, ¿can this be made for any language? e.g. "es_ES" for Spanish (my case).
For the rest for text in the spreadsheet I recommend to script it in the main sheets (sort off "{chest}") and add a locale sheet with all languages supported. When you update the sheets you substitute the scripted value with the translation.
Need any help with Spanish translation? I will do.
Thank you for your great and very very useful work!
When importing my guild in the spreadsheet 1 character does get processed because of the special character in his name.
http://i.imgur.com/y76COea.png
Is there a way I can fix this manually?
Thank you for making this awesome spreadsheet. It has been a great help for our guild!
Currently, the logs shown are the best damage for tanks/dps and best healing for healers.
Being able to change what logs are being checked based on class and spec would improve the clearness of players playing more than one spec (or if a player rerolls spec).
For instance, a restoration druid with boomy offspec (or rerolls boomy) with good damage parses as restoration, will show damage parses as restoration even if the specialization is boomy.
Issue example
Restoration damage
Balance damage
Spreadsheet (balance specced)
Characters showing [empty slot] when the API doesn't indicate the slot was empty. Inspection of these characters api shows there may be something very wrong happening with the way we're assigning soulbinds to slots
Example Character: Isneak Zuljin
I tried to add it myself (basically copying the Nightfallen tracker), however it seems like the reputation id 2165 ( http://www.wowhead.com/faction=2165/army-of-the-light ) is not correct - any non-pandaren Alliance toons report back as hated. Any Pandaren Alliance, or Horde toons properly report back their reputation standing.
issue with google docs not saving settings
need to add a bit of logic to deal with gathering and crafting having 2 separate max numbers
For the following:
Column G. Row 3
=concat("Healer: ",countif(C:C,"Healing")) - Will not calculate due to "Healing" being incorrect.
Updated below:
=concat("Healer: ",countif(C:C,"Healer"))
Inspection tab should have mythic+ info, at the very least! Maybe we can put in a special pvp api call for folks we inspect?
Hi,
Getting splice error with the newest version of guildcheck.js
7/8 being marked as All done! in mythics section, possibly pulled.
User who reported it initially: 'I think I see what that 7/8 mythic deal was. It's pulling from the Mythic+, whereas we're only on Mythic, so it's old mythic content'
Hi,
This is a small function I added:
function numberWithCommas(x) { return x.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ","); }
I call it at line 1058:
artifactRank = artifactRank + " | AP: " + numberWithCommas(toon.achievements.criteriaQuantity[i]);
I makes the total AP more readable
Rgds
we'll need info from both the progression section and raider.io for this. Apparently some of it is based on your LOWEST mythic+ for the week, so we'll need to obtain/(guess?) at that. Would also need to start tracking pvp stuff to 'fully' do this
Some people do pvp? what?
Hello,
I have the above issue. I followed the steps attentively, I think I did not miss a step. Yet, nothing populates.
some details:
the sheets remain empty
the settings:
Please help me :)
My guild rooster`s highest key done is showing a wrong value for some. Very few are correct.
issue is on Blizzard's side. soulbind api shows the entire row and doesn't supply us with the selected trait
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.