Jump to content

CAWs.ws
Facebook Twitter YouTube RSS Feed

2K Universe Mode Tracker by Too Many Limes

excel stats tracking tracker universe simple

  • Please log in to reply
7 replies to this topic

#1 Too Many Limes

Too Many Limes

    Lower Midcard

  • Members
  • 730 posts
  • Gamertag: rickyrules
  • SEN (PS3): rickyrules0

Posted 16 October 2016 - 05:33 PM

Hey, this is a fairly simple excel spreadsheet that I've actually personally been using since 2K15 to keep track of basic stats for my Universes. After some polishing, I figured at least someone else could get some use out of this thing too. There's an information tab in the spreadsheet that explains in-depth all the functions and keys for the tracker but I'll briefly go over what this thing is and what it does.

 

 

axi5b7.png
 

Brief Introduction:

 

The main component is what you see in the picture above, it's a 2K Universe Mode tracker. You input wins, losses and other information and the sheet will spit out percentages and totals for you through the usage of formulas. There are three long buttons in the tracker that allow you to add or subtract 1 from the selected cell or to set the selected cell value to 0. I suggest using these buttons to help you keep track of streaks as currently I don't have a formula for streaks. You can sort any of these columns in various ways, such as alphabetically or by highest to lowest number or even by cell shading color which I personally used to indicate brands. Conditional formatting was used to provide some visual indicators of these stats, such as green flags indicating a winning streak or percentage shading that compares with all the other percentages.

 

There are 2 trackers in the spreadsheet, the original which includes all playable superstars in WWE 2K17, and the "PLUS" version which includes an extended selection of past and present superstars. Both trackers also include blank spots for you to fill in as you please. However, feel free to customize any row's name and ID as you please as they aren't set in stone.

 

Speaking of the ID, another neat feature is the ID Search box where you type an "ID" that matches an ID in the tracker and the corresponding superstar's stats will be shown. Make sure to NEVER edit the stats within the ID Search box, only in the tracker. Any header that's shaded tells you that row or column uses formulas and you shouldn't mess with those cells. Below this box is a simple area for you to type in your champions. 

There are also simplified sheets for power rankings, which includes visual indicators for movement along the ranking, and championship history.

 

Download:

WWE 2K Universe Mode Tracker by Too Many Limes 1.0.0

Alternate Link

 

I will keep updating this tracker and I will add new features like a streak sheet so the streak can be automated with a formula instead of being tracked manually. Message me here or email me at rickyfrules@gmail.com if you have any problems, questions, or suggestions. Hope you find this as useful as I have!


Edited by Too Many Limes, 16 October 2016 - 06:01 PM.


#2 Counting Lights

Counting Lights

    Life Finds A Way

  • Members
  • 18,733 posts
  • Location: Chicago
  • Gamertag: None
  • SEN (PS3): GreendaleDragonS
  • Twitter: @TheeJakubDulak

Posted 16 October 2016 - 05:50 PM

Nice! My friend and I are doing a Shareplay Universe as kind of a GM mode, so this will be super helpful!



#3 BlInd_Monkey1989

BlInd_Monkey1989

    Opener

  • Members
  • 382 posts
  • SEN (PS3): Blind_Monkey1989
  • Twitter: @Tatsumaki89

Posted 16 October 2016 - 05:54 PM

This is awesome. I'll be sure to download this when I get home. I always wanted to do something like this with my CAWs.

#4 Too Many Limes

Too Many Limes

    Lower Midcard

  • Members
  • 730 posts
  • Gamertag: rickyrules
  • SEN (PS3): rickyrules0

Posted 16 October 2016 - 09:26 PM

Glad I can help you guys out!



#5 SassyTroy

SassyTroy

    Jobber

  • Members
  • 112 posts

Posted 16 October 2016 - 10:43 PM

This looks really cool. I tried something like this last year on my own but nowhere near as good as this.



#6 CM_EDGE

CM_EDGE

    Lower Midcard

  • Members
  • 949 posts

Posted 17 October 2016 - 05:06 AM

First. Thank you very much. :)

Second, is it as good as this from last year?



I like the idea of this tracker with automatic ranking and points and the shows in it.

#7 Too Many Limes

Too Many Limes

    Lower Midcard

  • Members
  • 730 posts
  • Gamertag: rickyrules
  • SEN (PS3): rickyrules0

Posted 18 October 2016 - 12:00 AM

I can't really compare mine to that one. It's really advanced. I actually like the concept of that one a lot and want to incorporate some of the formulas it uses. I don't use it though because I've been using mine since 2K15 and that one feels too complicated (the ELO system confuses me). I consider mine to be a much simpler tracker that lets you keep track of the bare bones in a way that makes sense and is easy to maneuver. 



#8 sandman67

sandman67

    New Talent

  • Members
  • 12 posts
  • Location: Rotterdam, Netherlands

Posted 22 January 2017 - 02:54 PM

Chrome didn't want to download is because the file is harmful.

Firefox warned me after downloading that the file contains a virus or malware.

 

Maybe my browsers are too sensitive but I won't deny a security warning.







Also tagged with one or more of these keywords: excel, stats, tracking, tracker, universe, simple