Jump to content


  • Content count

  • Joined

  • Last visited

  • Battles

  • Clan


About Koruption

  • Rank
    Able Seaman
  • Insignia
  1. Yes, but that's two ranked reward ships for the work of a single clan wars reward ship. If a player isn't interested in the Stalingrad, that sure sounds... interesting.
  2. So, by playing in clan battles for three seasons a player could purchase both of the ranked reward ships without ever having played ranked? (Discount included)
  3. Winrate on stats - how is this even possible?

    Even the strongest of ships sink. Divisions of poor players are multiplicative of poor play. Positioning skills, knowing where to be 5 minutes from now so that you'll consistently be able to catch the enemy off guard however... that's the true skill.
  4. Thank you for the kind words. Originally, I had left deficit areas blank. However it was @Boris_MNE who suggested inputting something that would quickly and concisely list what needed improvement. It was too good of an idea to not include!
  5. I could have done so, and I may in the future, however for this the central idea was to use 6 core statistics that every ship type desires to attain.
  6. There have been some errors in how the API transmits data into a google sheet recently. For instance, if you have a ship, but haven't played it, the api simply duplicates data from another ship and applies it to the blank data ship. This can also happen to a ship that a player has a 0% win rate on, resulting in the amount of wins from another ship being duplicated. That tricks the sheet into thinking you have a 100% win rate instead. I have updated the sheet's logic to prevent these errors from manifesting in the final product. For these fixes, simply make a new copy from the original post.
  7. Spotting damage can be ascertained from the api, but yeah... not for CB. And yeah! We can all see our CB win rate in game... but it's not in the API! I do wish they'd at least include how many battles you've played in CB as well as your win rate.
  8. Balance problem division vs no division

    Honestly I'd rather not have matched divs. If you give me a div of pure tater, that's three taters... but if you give me three individuals I stand a better chance of one of them being perdy good.
  9. Don't rush through it! Take your time. I just started back on working towards my first EU t10... Problem is... idk what I want to work towards heh
  10. Well, do remember that the stat goals are built around tier 10... and gauged as proof of competency for typhoon league or higher. The sheet definitely works for any tier, however the stat goals aren't designed for them. You're welcome to set your own goals though!
  11. I hope they keep the clan battles stats quiet anyways. I'm constantly in the API and it's taken me a while to really wrap my head around how everything matches up. Clan Battles is where stats matter the least for destroyers of all things. How do you accurately quantify successfully smoking up an ally, screening them for torps, all while cap contesting and spotting... without dying? To quantify that in a manner that the average joe can agree on? Random battle stats do however work to serve as... proof of competency if it were. But where should that little grey line of competency reside? I have my opinions, and they're in the stat goals, but they're obviously subjective and should be editable by others.
  12. Correct, they aren't in the API. Thank you by the way for the kind words! I agree, mostly because during season one I played exclusively z-52 and in season two the Gearing. I did notice however that there was generally a correlation between random battles success (not playstyle) and Clan Wars success (not playstyle). Also, that's exactly why the stat goals are editable! :)
  13. Btw, thank you to @RobS80 and @Boris_MNE for taking the time to go over the sheet and critique it. Heck, half of the descriptors idea was Boris's.
  14. I've seen the question "What is the Greatest Stat?" asked quite a lot recently. I have my own opinions about that, and I've even voiced those opinions. (Hint: it's overall win rate with reasonable asterisks attached to the theory.) But my opinions on the greatest stat isn't really what this is about. This is about giving players a way to discover and manipulate data themselves. I spend a lot of time delving into the API that Wargaming so kindly provides to us, and I like to think that gives me a certain perspective on things. This spreadsheet is designed to give that ability to you as well. With the upcoming third season of Clan Battles on our doorstep, I was hoping that this could help players understand a little better where they need to prepare themselves. The first thing one does is turn the sheet on, which is done in cell B1 by entering any clan tag. It doesn't matter if you're in that clan, as entering a clan tag simply turns the sheet on. You'll then be able to either type a name into cell C5 (make sure you spell it right) or select one of the members of that clan from the drop down menu there. You don't have to search for a player in that clan, but it does make it easier. From there the sheet will begin loading data. What you're able to manipulate is in the middle of the screen labeled "Stat Goals." The sheet comes preset with the above stat goals. I've so far spent two seasons in clan wars at the Typhoon/Hurricane level. When I saw a player make an influential play, or just in general really helped their team, I took notice. I have based these stat goals on those players. Basically, if you want to play at the Typhoon or higher level, these are what you'll need to shoot for. My own clan uses an adapted version of this, and they disagree with me on the numbers. Disagreement is fine! We have a few players that successfully got their flags that theoretically wouldn't make it based on these numbers. The preset values are simply based upon my own observations. And I definitely observed that there is a wholesome correlation between a player's random battles statistics and their ability to perform in Clan Battles. Once you have your own copy of the sheet however, you can change these to whatever you like. These stat goals are quite important. For each one that you meet on a ship, you gain one "Qualifying Rank." Once you have met at least 4, you earn the basic descriptor "Qualified" for that ship. Exceeding the goals results in earning better descriptors on a ship. Working to earn better descriptors on a ship is kindof the entire point of the sheet. As you improve on a ship, you earn better descriptors! The sheet will not give you 4 qualifying ranks until you have at least 25 battles on a ship. These for example, are my descriptors for tier 10. I know... I sucketh quite greatly with the Gearing... But what about outlier ships? Ships that don't really fit the traditional dd, ca, bb, cv mold? By scrolling down below everything else, you'll see the section labeled "Individualized Stat Goals." If you set a ships' stat goals here, they'll override the more generalized versions above. The sheet comes preset with the Khaba already having individualized stat goals. WEIGHTED STAT GOALS Here's the kicker though. By looking below all of the individual ship results, you'll see a couple of nondescript areas (cells D80 and D82) labeled "Weighted Stat Goals" and "Weighted Player Averages." What if a player only has 2 battles on a ship, but they have 100% win rate etc? Should that be weighted as much as a ship that they have 100's of battles in? In this section the sheet takes all of the different ships, their goals, and weights them with their number of battles as the control. Those are my weighted stat goals. As you can see, I need to play more at t10, as my weighted stat goal for battles is in the red. I on average have too many t10's for how much I actually play at t10. However when I do play at t10, my other stats are all in the green. This section is best used to a quick glance to see if the player is overall actually performing at the level they should be or not. I can't take credit for this section though, the guys in OPG took the time to critique the sheet and they suggested it. They even took the time to explain the math to me! The sheet will also take the time to look up a series of achievements for a given player so that at a glance the user may see if they have any experience in Clan Battles. All it's really saying here is that they played in those leagues, but if I recall correctly you only have to play a few battles in a league to earn the achievement from Wargaming. You don't have to earn a Stalingrad flag to earn the Typhoon league Achievement. But it does serve as a quick reference on a new player to your group. Remember, this is simply a tool. However it is a tool designed for the user to set their own goals and rewards. I hope this is useful to players! If you would like a copy of this spreadsheet, click here. I have spent a lot of time looking for critiques on this latest piece of work. However it cannot ever truly be perfect. If you notice something is wrong, or something that could be improved, please let me know.