Search the Community
Showing results for tags 'organizer'.
Found 1 result
Whether you're looking to organize a clan or a group, this sheet seeks to help you do it! This sheet does several things to help a growing (or already successful) clan move to the next level. 1) Provides an easy way to consolidate player ship preferences. 2) Allow users to quickly browse ship statistics in a variety of ways. (Unlike some of my previous sheets, this sheet is designed to be as fast as possible.) 3) Track player attendance data and provide a breakdown on that data in a variety of ways that are user friendly. 4) Allow for player notes for out of game communication. (When you don't necessarily want to use a website or facebook for whatever reason.) 5) Expedite tactical preparation by facilitating easy usage of MapTactics. If you want a copy already click this link and it's all yours. If you'd rather read through this first, there's another link at the end. The link gives you the option to copy the sheet to your own google drive. 1) Provides an easy way to consolidate player ship preferences. I used my own name as an example obviously, and I entered the two ships that I've used for ranked so far in the above picture. To the left of where I entered my name, the sheet automatically pulls in everyone that is in an entered clan. Clan tags are entered in cell B1 while the tier may be changed in cell B2. Once a clan tag is entered, it turns the sheet on. To the left of my entered name is a list of everyone in the clan that I entered. That list is for spelling purposes. The sheet operates of of the list of names you can see in the above picture. It does it this way to prevent getting off kilter. What I mean by that is this - if you enter a ship as your preference, and someone either joins or leaves the clan, the manually entered data is going to be off by one if the names are coming in automatically. It's also a problem with the attendance roster I'll be mentioning later. This means that you'll have to enter names manually one time. The auto list is still shown however to help with spelling. 2) Allow users to quickly browse ship statistics in a variety of ways. (Unlike some of my previous sheets, this sheet is designed to be as fast as possible.) But yeah... you have the option of bringing in either random battle data or ranked battle data. All you have to do is use the drop down menu to select randoms or ranked. The sheet will dynamically change the type of data it's bringing in at that point. This is done mostly to help while setting up for Clan Battles, knowing which ships players like to play and feel that they have the stats to back up. The color coding is dynamically set as well. I've set some basic stat goals up to start out with, but they're completely changeable if desired. All you have to do is scroll down and set it up the way you like it. Meeting the stat goals entered on a ship results in a green rating, while exceeding it by the amounts entered into the blue and purple boxes yields their color coding. If you scroll down just a bit more you also have some more options for basic stats analysis. Here you can select individual ship classes. The grey section on the right shows how much more improvement one needs on a particular stat to reach the next color coding. Purpled out means that you're already purple on that stat. The grey section on the left brings in attendance data from the attendance tab at the bottom. We'll see more about that tab later on. For now, just know that if you keep up with attendance, you'll get that nifty breakdown when searching through tier 10 ships for your clan's next Clan Battles team. Scrolling down even more shows the user a breakdown of everyone in the clan. I've whited out everyone's name and data in my clan except for mine (since that's the one I'm using atm to turn the sheet on). Normally the above picture would be filled with everyone in the selected clans data, even if they're not entered in that original list of names I mentioned earlier. WoWs-Numbers.com has excellent recources for clans, and I realized that it's open to import all of their clan data in one giant chunk. This made the import extremely quick and data friendly. It also saves me the time of having to zip over to their website to look for this breakdown. Plus I was able to format it to be much cleaner (in my own opinion of course!). Once again you get the attendance breakdown, the difference is that here you'll see it for everyone, not just those that have a specific ship. So what about ranked? Didn't I mention something about ranked? Ever want to see who's in the lead in your clan in the race for the big rank 1? Want a quick breakdown of basic stats on it? Scrolling down just a bit more you'll find another section. The user can use this to see who's leading the pack, as well as sort to see who's got the best win rate etc while not in the game. Once again I whited out everyone's name and data except for mine. 3) Track player attendance data and provide a breakdown on that data in a variety of ways that are user friendly. Down at the bottom of the web page you should see three tabs. So far everything I've shown you is off of the "DataBase" tab. If you click on the "Attendance" tab you find the following resources. Here I've entered some examples. To the far left you'll see "Wins you Have" as well as "Wins You Need". by entering how many wins a player has in Typhoon league for Clan Battles, the clan may better make decisions on who gets priority when it comes down to those last few days. Once you have 30 wins, the cells turn black and the numbers white. The sheet also counts up how many have 30 wins just above where it says "Wins you Have." Earlier I showed you a picture from the database tab where it had an attendance breakdown. How does the sheet know how many practices you've been to and how many non-practices (events) you've attended? It's all in the name! If you enter the word "practice" in the title of the said event, the sheet will tally it up as such. This way one can make informed decisions like "huh... they've been to every clan battle night... but not a single practice night..." Typing "practice" in the name is all ya gotta do! Attendance data on all the other tabs is populated from this tab. 4) Allow for player notes for out of game communication. (When you don't necessarily want to use a website or facebook for whatever reason.) In the "Lineup" tab you'll find the following resources. In the above you may see a few different things. There are places for the user to set up different lineups of players and ship compositions, this is designed for use with Clan Battles as well as Supremacy League. Well... it's a very toned down version of the one I made for supremacy... this is a bit more generalist. You also have a section in this tab for users to leave notes. If you're using this for a small aspect of your clan or group, and you don't want to muddle up your facebook chat/group or your website with it, this facilitates that need. The big blue cell is for a user to put a link to a specific map tactics room, so everyone is using the same one for strat development. There's also a smaller blue box below it with a link to the basic homepage of the MapTactics website. Scrolling to the right the user will find a database. 5) Expedite tactical preparation by facilitating easy usage of MapTactics. It's in this section where you may leave tactic names along with links to their images. This allows the users to use the drop down menu in cell "K2" to find a tactic name. Once a tactic name is selected, the corresponding image appears. If you're one of those gamers that doesn't want to necessarily share the full breadth of your tactical genius with your group (your precious map tactics theory room... you know I'm talking about who I'm talking about...) then maybe this is better for you. It'll allow your group to see the tactics that you've already pre-prepped up for use. So that's about it. That's what it does. I've already set up protections on the sheet. So whoever owns the copy of my sheet will be able to edit whatever they want. Those who don't actually own it however will only be able to edit cells that are meant to be readily editable. Yup.... well if you like it, and you want a copy, feel free to click the link below for your own copy. This Link Gives You A Copy Of The Sheet