xXSegemoXx Posted February 8, 2014 Share Posted February 8, 2014 Just looking for some ideas on using spreadsheets. I'll upload a pic of mine in a bit for my BHOTWG save. Link to comment Share on other sites More sharing options...
DZen Posted February 8, 2014 Share Posted February 8, 2014 <p>I tend to keep two main pages for my spreadsheet, one to track the roster, and another to track results/recent fortunes.</p><p> </p><p> The roster one, I keep the wrestler name, alignment, their current roster push, and a note on my usage for them (anywhere from goldberg push to job city). Next I have a list of their angle skills, as a shorthand to allow me to see what sort of segments they suit/suit them, followed by a quick note on their second line in-ring skills, because I have a habit of forgetting those (any big positives or negatives I need to be aware of so they don't slip my mind when booking, so stuff like -psy --saf +sel (bad psychology, very bad safety, but good selling)). Finally I have a misc note section, where I might note if I want to use someone as a trainer for example (high second row to put them in matches with wrestlers I want to develop), manager name (and their preferred skill for segments)... basically all the stuff that means if I have a mental slip, I don't have to spend a minute going between menus to refind that information. If they're yet to debut, I'll also colour them in green, to make sure I'm reminded to make their intro angle or match one that gives them good momentum.</p><p> </p><p> The second one is simply a list of wrestler names with Ws or Xs next to them (win or loss), to make sure I don't mess up on recent fortunes. I also give them a colour code for attention when there's stuff that I need to make sure I remember (red = momentum tanked, not going to try to bring it back up, orange = momentum tanked but want to try to save it, blue if I need to be wary of their recent fortunes, green if they're on a heavy push).</p> Link to comment Share on other sites More sharing options...
Irish Wolf Posted February 8, 2014 Share Posted February 8, 2014 My first spread sheet page is my roster: Name, Push, Size, Style, Overneess (either in on region if regional or one area if cult, national or above) and momentum (Disposition and gimmick is added to this if I'm playing a fed that uses them but I usually play CZCW or a Japanese fed) Also on the roster page I have numbered boxes 1 through 10 and I keep W or L in them so I can see my workers last ten matches win loss record. I Will also usually keep my tag teams listed on the main page. An for Japanese feds I will use colored cells to tell me which workers are loyal to me which are loyal to other promotions and which workers are young lions Second page is usually the lay out for my shows. I put in each match and angle if I'm using them that I want and then lay out times with an autocalculation for the time at the bottom to make sure I'm not over or under. I will usually use this to plan out a months worth of matches from PPV to PPV Sometimes I will plan longer depending if I have an idea for a big show I need to build toward like Supreme Challenge for SWF Those are the base for every game but I have others. For Japanese feds I keep a list of all the workers I usually regularly on tours so I don't have to keep retyping them over and over again when I pick people up more than one. For Road to Glory challenge games I keep a detailed list of stat growth mby month including a calculation For total stat growth. And for feds with Dev Territories I keep a list of who's down there. Link to comment Share on other sites More sharing options...
xXSegemoXx Posted February 8, 2014 Author Share Posted February 8, 2014 <span>http://i738.photobucket.com/albums/xx24/xXSegemoXx/MySpreadsheet_zpsf41d68bf.jpg~original</span> Link to comment Share on other sites More sharing options...
Zero Posted February 9, 2014 Share Posted February 9, 2014 <p>I just write down my pay per views, and the direction I want them to go in. Mostly Main Event wise and build my lower card after.</p><p> </p><p> It's a good way to plan for the future</p> Link to comment Share on other sites More sharing options...
shawn michaels Posted February 9, 2014 Share Posted February 9, 2014 Wow...I don't plan via spreadsheets at all. I have the main ideas in my head and I just go along with it. The game is already time consuming without having to write a bible in a spreadsheet. So no...no spreadhseets here. I don't really like to play a game if it requires me to open outside programs, like word, excel, ordinary notebook, and so on. Dudes....it's just a game. Chill. <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> Link to comment Share on other sites More sharing options...
Lack23 Posted February 9, 2014 Share Posted February 9, 2014 Does anyone have a template available which I can use? I'm pretty new to the game, and I'm looking for the best possible experience, any help would be great. Thanks! Link to comment Share on other sites More sharing options...
Donners Posted February 9, 2014 Share Posted February 9, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="shawn michaels 82" data-cite="shawn michaels 82" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Wow...I don't plan via spreadsheets at all. I have the main ideas in my head and I just go along with it. The game is already time consuming without having to write a bible in a spreadsheet. So no...no spreadhseets here. I don't really like to play a game if it requires me to open outside programs, like word, excel, ordinary notebook, and so on. Dudes....it's just a game. Chill. <img alt=":D" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> :D <img alt=":D" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></div></blockquote><p> </p><p> I'm the opposite. I greatly prefer games which allow me to keep a detailed record of what has happened. It's easier than doing a diary, and is a great way to understand the mechanics. </p><p> </p><p> I really only got to understand WMMA and TEW by keeping a very close record of various stats, and watching how they were affected by what happened. </p><p> </p><p> It's also a great way to assess performance over years and see how your influence has affected things.</p> Link to comment Share on other sites More sharing options...
Lack23 Posted February 9, 2014 Share Posted February 9, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Donners" data-cite="Donners" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>I'm the opposite. I greatly prefer games which allow me to keep a detailed record of what has happened. It's easier than doing a diary, and is a great way to understand the mechanics. <p> </p><p> I really only got to understand WMMA and TEW by keeping a very close record of various stats, and watching how they were affected by what happened. </p><p> </p><p> It's also a great way to assess performance over years and see how your influence has affected things.</p></div></blockquote><p> </p><p> Donners, What is your method of keeping track of this information? I'm looking for a few hints and tips.</p> Link to comment Share on other sites More sharing options...
TakerNGN74 Posted February 9, 2014 Share Posted February 9, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="shawn michaels 82" data-cite="shawn michaels 82" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Wow...I don't plan via spreadsheets at all. I have the main ideas in my head and I just go along with it. The game is already time consuming without having to write a bible in a spreadsheet. So no...no spreadhseets here. I don't really like to play a game if it requires me to open outside programs, like word, excel, ordinary notebook, and so on. Dudes....it's just a game. Chill. <img alt=":D" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> :D <img alt=":D" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></div></blockquote><p> </p><p> ^This. Everything that I plan is either written down on the notepad or something that comes directly out of my mind as I play. Ever since I started playing the series with TEW 2008 I have done it this way. The only thing I will do is keep a running log of whats going on in my save (currently my SWF save) which gets posted in the whats going on in your game thread but other than that I don't do much planning. Rather I just have a general idea of where I want the company to go in my head.</p> Link to comment Share on other sites More sharing options...
xXSegemoXx Posted February 10, 2014 Author Share Posted February 10, 2014 <p>@Lack23 Depends on what you're product is. If you look at my spreadsheet, Its important I know who my champions are and young lions, as well as who I'm pushing. On a seperate page im beginning to enter all their stats and on a 3rd page will be their past 5 matches.</p><p> </p><p> Keeping track of those matches allow you to control 'Recent Fortunes' which controls how fast or slow workers rise or fall in popularity. If a worker loses most of his or her matches they'll find it hard to gain pop when they finally get victories, and vice versa. Hope i explained that well. </p><p> </p><p> Also, if your in a sports entertainment fed where popularity basically rules all, you just should keep track of star quality, charisma and entertainment skills along with the performance skills. </p><p> </p><p> Then you could list your tag teams.</p><p> You can describe storylines and plan out each show.. etc. Use spreadsheets to plan out your game like a business. I find it amazingly fun since I'm a spreadsheet kinda person.</p> Link to comment Share on other sites More sharing options...
Donners Posted February 10, 2014 Share Posted February 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Lack23" data-cite="Lack23" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Donners, What is your method of keeping track of this information? I'm looking for a few hints and tips.</div></blockquote><p> </p><p> Well, it depends on what you are trying to achieve.</p><p> </p><p> WMMA is awesome for record-keeping, since you don't pre-determine the results and run fewer shows than TEW. My spreedsheet for that is quite complex.</p><p> </p><p> In TEW, it really depends on what you need from it.</p><p> </p><p> A very basic one would have the key details for your active wrester - name, age, disposition, push, wage and popularity (depending on your promotion, this could be a rough average of a country's regions, a single region, several different regions, etc). Pop is particularly important, as you can see how each show (or however often you update it) affected it.</p><p> </p><p> It helps to differentiate between written and PPA contracts - italics for PPAs work for me. Colour coding disposition and sorting by push (a custom sort from main event to enhancement) then disposition makes it easy to spot match-ups at a glance. </p><p> </p><p> It used to be a lot better in TEW 10 when you could automatically produce a spreedsheet and in-game it had a neat summary of key skill averages on the roster screen, plus sortable tables. For some reason TEW 13 has none of those features, IIRC, so it's a fair bit more work.</p><p> </p><p> If you have a small enough roster, you should be able to recall those who are good at entertainment and performance skills. If not, they're two good ones to note on a spreedsheet - they are the ones to put in angles and to book against raw wrestlers. I assume you can filter your roster to show people above a certain rating in these areas.</p><p> </p><p> Noting opponent chemistry is also useful.</p><p> </p><p> In 10 I went through at the end of each year and got everyone's average match rating for the company. Bit of work, but helpful.</p><p> </p><p> If you wanted to expand, you could have future booking plans (ie your card for the next PPV, or even a few in advance) to guide your booking. </p><p> </p><p> That's just some basic tips and ramblings, anyway. Even a simple spreedsheet helps.</p><p> </p><p> I have my TEW 10 spreedsheet buried somewhere; I'll track it down and see if anything remarkable is there. My WMMA one is more interesting though.</p> Link to comment Share on other sites More sharing options...
Irish Wolf Posted February 10, 2014 Share Posted February 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Donners" data-cite="Donners" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>I'm the opposite. I greatly prefer games which allow me to keep a detailed record of what has happened. It's easier than doing a diary, and is a great way to understand the mechanics. <p> </p><p> I really only got to understand WMMA and TEW by keeping a very close record of various stats, and watching how they were affected by what happened. </p><p> </p><p> It's also a great way to assess performance over years and see how your influence has affected things.</p></div></blockquote><p> </p><p> Yeah I don't think I could live without my spreadsheets. I'm just a math and statistics guy at heart, and I'm also a little OCD. I keep telling myself I'll try a game without it and every time I do it lasts maybe four shows and then I gotta start jotting stuff down.</p> Link to comment Share on other sites More sharing options...
scorpion Posted February 10, 2014 Share Posted February 10, 2014 <p>First I should state I am running a match heavy company with no face/heel divide</p><p> </p><p> <span>http://i4.photobucket.com/albums/y140/jerem77/Edited/sheet.jpg</span></p><p> </p><p> My spreadsheet tells me two things - storyline & recent fortunes</p><p> </p><p> The color of the name denotes the storyline. as i am match heavy I further my storylines mostly through interference. this helps me keep track of who should interfere with who. In this game, Mad Mort and Klondike Red have just exited a storyline and that is why they are white. Before the next event I'll put them in a new one and give them the appropriate color.</p><p> </p><p> the red and green boxes denote wins and losses in their last five matches- green for wins, red for losses. I stole this straight from boxrec. the way i operate whenever a wrestler gets 3 losses in the last 5 he wins until he gets back above .500. there are of course exceptions and storyline considerations. But I've found this effective to keep guys out of the penalty. (though occasionally i still end up there with someone, in which case they keep winning until they are out)</p> Link to comment Share on other sites More sharing options...
aXminster Posted February 10, 2014 Share Posted February 10, 2014 That's too in depth for my taste heh Link to comment Share on other sites More sharing options...
Lack23 Posted February 10, 2014 Share Posted February 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Donners" data-cite="Donners" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Well, it depends on what you are trying to achieve.<p> </p><p> WMMA is awesome for record-keeping, since you don't pre-determine the results and run fewer shows than TEW. My spreedsheet for that is quite complex.</p><p> </p><p> In TEW, it really depends on what you need from it.</p><p> </p><p> A very basic one would have the key details for your active wrester - name, age, disposition, push, wage and popularity (depending on your promotion, this could be a rough average of a country's regions, a single region, several different regions, etc). Pop is particularly important, as you can see how each show (or however often you update it) affected it.</p><p> </p><p> It helps to differentiate between written and PPA contracts - italics for PPAs work for me. Colour coding disposition and sorting by push (a custom sort from main event to enhancement) then disposition makes it easy to spot match-ups at a glance. </p><p> </p><p> It used to be a lot better in TEW 10 when you could automatically produce a spreedsheet and in-game it had a neat summary of key skill averages on the roster screen, plus sortable tables. For some reason TEW 13 has none of those features, IIRC, so it's a fair bit more work.</p><p> </p><p> If you have a small enough roster, you should be able to recall those who are good at entertainment and performance skills. If not, they're two good ones to note on a spreedsheet - they are the ones to put in angles and to book against raw wrestlers. I assume you can filter your roster to show people above a certain rating in these areas.</p><p> </p><p> Noting opponent chemistry is also useful.</p><p> </p><p> In 10 I went through at the end of each year and got everyone's average match rating for the company. Bit of work, but helpful.</p><p> </p><p> If you wanted to expand, you could have future booking plans (ie your card for the next PPV, or even a few in advance) to guide your booking. </p><p> </p><p> That's just some basic tips and ramblings, anyway. Even a simple spreedsheet helps.</p><p> </p><p> I have my TEW 10 spreedsheet buried somewhere; I'll track it down and see if anything remarkable is there. My WMMA one is more interesting though.</p></div></blockquote><p> </p><p> Thanks!!</p> Link to comment Share on other sites More sharing options...
Kainlock Posted February 10, 2014 Share Posted February 10, 2014 I work a lot off a spreadsheet including tabs for managers, tag teams, show booking, PPV and gimmicks. I do it because I have lots of time at work and little time to play at home so I can plan stuff out at work and run it quicker when I get home. Link to comment Share on other sites More sharing options...
Zero Posted February 10, 2014 Share Posted February 10, 2014 <p>Wow, after reviewing some of these, they are really in-depth. I think that is awesome because you can reflect on how your booking has changed year to year.</p><p> </p><p> For instance I started my game in 94 and currently in 99 and over the five years, I write down my roster each month, just to see how much it has changed or who has gone where.</p><p> </p><p> Besides for that, I don't keep much records. I love that it traces workers win and loss ratio because for example I had Kane as "Glenn Bradshaw Jacobs" and basically him and JBL would be a jobber tag team for awhile. I did start building them in late 96 before Glenn Jacobs became Kane.</p><p> </p><p> It is awesome to see how they have grown.</p><p> </p><p> </p><p> The only other thing I like to do is plan out my Pay Per Views a year in advanced or a little more.</p><p> </p><p> It gives me a clear idea who I want to build the title on, who I want to build up, and so forth. I follow real life in some situations so for example I just had the Mankind vs. Rock feud which went great, and true to life.</p><p> </p><p> But I like to mix it up. I love viewing my title reigns as well and seeing who was most over in 95.</p> Link to comment Share on other sites More sharing options...
MaddoxEra Posted February 10, 2014 Share Posted February 10, 2014 <p>I use this as a template for a quick look when booking. Saw somebody else post something similar on this forum a few months ago and I altered it a bit to suit my needs. Then sheet 2 would have details of popularity, momentum, last 5 matches, gimmick and whether it needs to be changed (gimmicks in <strong>bold</strong> are ones that are taking a hit in matches). I only update sheet 2 after PPVs for the most part though and I find it really handy for building popularity of guys I'm looking to push.</p><p> </p><p> <span>http://gyazo.com/366ebdd10c57555a6d4e8f49b93d13cd.png</span></p><p> </p><p> I've tried playing the game completely in my head but I found it hard to visualise my shows and feuds. I also lost track of ideas if I went away from the game for a while so I started using this spreadsheet and a word document to plan some PPVs. Though I don't really plan too far ahead in most cases, only the ending to really big feuds will be planned in advance and most of everything else is booked on the fly.</p> Link to comment Share on other sites More sharing options...
xXSegemoXx Posted February 10, 2014 Author Share Posted February 10, 2014 ^Thats a nice setup. Nice clean and basic while being pretty in depth. Link to comment Share on other sites More sharing options...
Kainlock Posted February 10, 2014 Share Posted February 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="MaddoxEra" data-cite="MaddoxEra" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>I use this as a template for a quick look when booking. Saw somebody else post something similar on this forum a few months ago and I altered it a bit to suit my needs. Then sheet 2 would have details of popularity, momentum, last 5 matches, gimmick and whether it needs to be changed (gimmicks in <strong>bold</strong> are ones that are taking a hit in matches). I only update sheet 2 after PPVs for the most part though and I find it really handy for building popularity of guys I'm looking to push.<p> </p><p> </p></div></blockquote><p> </p><p> going to demand to see sheet 2 <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p> Link to comment Share on other sites More sharing options...
MaddoxEra Posted February 10, 2014 Share Posted February 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Kainlock" data-cite="Kainlock" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>going to demand to see sheet 2 <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></div></blockquote><p> </p><p> No problem, this one's just a really simple Excel table though. I've not filled in the Last 5 Matches section on this one yet since I've been playing different saves lately. Also think I'm going to change the Ent Skills section to just be what their strengths are for angles or what I'm looking to improve because keeping track of that can be a pain.</p><p> </p><p> <span>http://gyazo.com/4d280617f9776d7f5c47e033f0cf969f.png</span></p> Link to comment Share on other sites More sharing options...
Irish Wolf Posted February 11, 2014 Share Posted February 11, 2014 Hopefully this works Current Roster Blue highlighted names denotes they are no longer Young Lions (at the beginning of my game everyone was I didn't hire anyone who wasn't). Green on the push is loyal to me, orange is loyal to somebody else. The dates column is their Power 500 listing for that year. Also it is currently sorted by push, overness in kinki highest to lowest and then momentum highest to llowest. Tag teams are listed on the side in order mostly by push but with slight adjustments if I feel I want to push some one further. I also listed anyone (even if they aren't on my current tour) who has shown up on my NBT list and then a list of everyone who is over Dark Horse for future success in Hot Prospects and a list of people who are just Dark Horse. Current Tour Here is where I lay out my shows, as you can see at show nine each touring show is set up for to 4 vs 4 matches and 3 2 vs 2 matches. Anyone who is touring is going to lose for the most part because they're recent fortunes reset every time they leave and then comeback to the company. The numbers from left to right are the length of the matches, the adjusted length for entrance time (I use ladder matches occassionally so its not always 2 minutes) and then below the adjusted a calculations for the total time of the show. The bordered area is each match rating with a calculation for what the show should be rated under it. Stat Growth Since I'm running a Road To Glory in this save I have a detaled map of my stat growth. Before you hit reputation there is a listing for month by month stat growth and total stat growth. Also since its RTG it keep a list of my yearly rolls. Short List Of Touring Workers Here is my list of workers I use on tours. This is sorted by young lion and not (the blues are not young line) and then from lowest to highest in terms of overness If they have a push its because I used them before and that's how they pushed last time they worked for me. Link to comment Share on other sites More sharing options...
Crzy1051 Posted February 11, 2014 Share Posted February 11, 2014 <p>I have always used Spreadsheets, in 10 it was easy cause you could export the information and do what you need. Since playing 13 I have had issues making one that gets all the info i needed and was organized. </p><p> </p><p> I loved the images that MaddoxEra posted and i used his ideas and added the info I typically use and made a Excel document. Everyone has just been publishing images, i decided to upload the file to my website as I am a Graphic designer and make the Excel Document available. <a href="http://creativedigital.us/wp-content/uploads/2014/02/TEWInfo.xlsx" rel="external nofollow">Download the Excel File here from CreativeDigital.us</a></p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 27, 2014 Share Posted February 27, 2014 <p>Here's a snapshot of the spreadsheet I've working on recently for NJPW. This is the tab I book a specific tour on. Helps to keep an a balance and not just bury anyone. All of the data is input on a different tab so it will populate automatically.</p><p> </p><p> <a href="http://imgur.com/UT9dyKn" rel="external nofollow"><span>http://i.imgur.com/UT9dyKn.png</span></a></p><p> </p><p> I enter the info like this so I can make Pivot Tables to dive in to any specific data. I track match ratings in wins/losses. I can quickly see how many matches people are having in specific years, months and weeks.</p><p> </p><p> <a href="http://imgur.com/07rQlPj" rel="external nofollow"><span>http://i.imgur.com/07rQlPj.png</span></a></p> Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.