shawn michaels Posted February 27, 2014 Share Posted February 27, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="TakerNGN74" data-cite="TakerNGN74" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>^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.</div></blockquote><p> </p><p> Indeed. Besides, a lot of the stuff that is written into said Spreadsheets is mostly available in game, via a few clicks.</p> Link to comment Share on other sites More sharing options...
Devilb0y Posted February 27, 2014 Share Posted February 27, 2014 <p>This is the setup I use.</p><p> </p><p> <span>http://i1255.photobucket.com/albums/hh638/theDevilb0y/spread_zpsc1904a33.png</span></p><p> </p><p> <span>http://i1255.photobucket.com/albums/hh638/theDevilb0y/spread2_zps9e8e1e57.png</span></p><p> </p><p> I also have a show planning and form page as well as archived shows so if I ever decide to turn a game into a Dynasty I have the plans available in an easier-to-access way than the game provides.</p><p> </p><p> My biggest problem with it currently is that I'm not very good with excel so there's no way to sort any of the columns or search, which is a bit annoying.</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 27, 2014 Share Posted February 27, 2014 <p>If you pull out the separation of their card placement (Main Event, Midcard, etc.) and make that a column, you would be able to sort and filter that whole sheet.</p><p> </p><p> Also, what do the colors represent for the columns on the right (Star Quality <---> Menace)?</p> Link to comment Share on other sites More sharing options...
Devilb0y Posted February 27, 2014 Share Posted February 27, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="JoshEngleman" data-cite="JoshEngleman" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>If you pull out the separation of their card placement (Main Event, Midcard, etc.) and make that a column, you would be able to sort and filter that whole sheet.</div></blockquote><p> </p><p> Ah ok, but would each row remain with each worker's name?</p><p> </p><p> Really what I want to be able to do is section off my roster designations into little mini-spreadsheets on the same page so I can then add, remove or sort workers within each section of the roster as appropriate without having to copy and paste sections of the whole sheet. I don't know if that's even possible though.</p> Link to comment Share on other sites More sharing options...
Irish Wolf Posted February 27, 2014 Share Posted February 27, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="JoshEngleman" data-cite="JoshEngleman" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>If you pull out the separation of their card placement (Main Event, Midcard, etc.) and make that a column, you would be able to sort and filter that whole sheet.</div></blockquote><p> </p><p> Yeah that's what I do. Push and Disposition are their own columns as are overness and momentum. this way I can sort by push, disposition, overness highest to lowest and momentum highest to lowest. You have to do a custom sort for push so it will sort ME first and Enhancement last but its not that hard.</p> Link to comment Share on other sites More sharing options...
shawn michaels Posted February 27, 2014 Share Posted February 27, 2014 Yeah that's what I do. Push and Disposition are their own columns as are overness and momentum. this way I can sort by push, disposition, overness highest to lowest and momentum highest to lowest. You have to do a custom sort for push so it will sort ME first and Enhancement last but its not that hard. But momentum and overness are always changing. I'm betting you guys spend more time writing than playing. Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 27, 2014 Share Posted February 27, 2014 But momentum and overness are always changing. I'm betting you guys spend more time writing than playing. I'm going to add that to my sheet and track in monthly. Should be pretty quick to do that. Link to comment Share on other sites More sharing options...
Devilb0y Posted February 27, 2014 Share Posted February 27, 2014 But momentum and overness are always changing. I'm betting you guys spend more time writing than playing. I just change it after every PPV as that's when the big shifts happen. Link to comment Share on other sites More sharing options...
Purple Cowboy Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Apupunchau@optonline" data-cite="Apupunchau@optonline" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>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.</div></blockquote><p> </p><p> I completely identify! With my latest SWF game, one in which I purposely named the save "FUNSWF" because I was just going to roll with things and not chart the roster out and track POP & MOM changes (among other things), I've just charted out the roster and storylines in the beginning of March 2013. <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> </p><p> Some great example sheets here, mine are very basic so might have to step things up a bit.</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 28, 2014 Share Posted February 28, 2014 If anyone ever needs any help with putting together a spreadsheet, let me know. I would be happy to lend a hand. Link to comment Share on other sites More sharing options...
MaddoxEra Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Devilb0y" data-cite="Devilb0y" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>I just change it after every PPV as that's when the big shifts happen.</div></blockquote><p> </p><p> That's what I do and it isn't time consuming at all, in fact I enjoy doing it as I can see if what I was doing that month worked on an individual basis and I can come up with new plans & ideas. The only exceptions to the PPV rule are when I'm deliberately jobbing people to someone with low overness and need to track that person (e.g. Henry Godwinn is jobbing to Chyna but she will soon be more over than him making it pretty much pointless and so I will need to move onto a more popular jobber) or to track momentum for an owner goal that's nearly finished (e.g. in 20 days Brian Pillman and Mideon must have a minimum momentum attained so I've been tracking them for a month now to ensure I complete it).</p> Link to comment Share on other sites More sharing options...
Irish Wolf Posted February 28, 2014 Share Posted February 28, 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>But momentum and overness are always changing. I'm betting you guys spend more time writing than playing.</div></blockquote><p> </p><p> Like everyone else has stated I only make adjustments to overness and momentum after each PPV and resort. It takes me less than 5 minutes to type everything in and do the resort. I do spend a fair amount of time writing things out but because of how far I lay out my shows (3 or 4 months worth of shows one time I laid out from Janaury to Supreme challenge) I can run through shows very quickly i don't even have to guess at what angles I have to put or what matches they are all laid out. And then the quick few minute adjustments to the sheet after every PPV. And to tell the truth planning is totally part of the enjoyment to me. I'm a math guy, a statistician, so its fun for me to track these things.</p> Link to comment Share on other sites More sharing options...
Devilb0y Posted February 28, 2014 Share Posted February 28, 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>That's what I do and it isn't time consuming at all, in fact I enjoy doing it as I can see if what I was doing that month worked on an individual basis and I can come up with new plans & ideas. The only exceptions to the PPV rule are when I'm deliberately jobbing people to someone with low overness and need to track that person (e.g. Henry Godwinn is jobbing to Chyna but she will soon be more over than him making it pretty much pointless and so I will need to move onto a more popular jobber) or to track momentum for an owner goal that's nearly finished (e.g. in 20 days Brian Pillman and Mideon must have a minimum momentum attained so I've been tracking them for a month now to ensure I complete it).</div></blockquote><p> </p><p> Yep, that's exactly what I do too. I find putting it on a spreadsheet fun because it's immediate feedback on what I've done well and what I need to work on. It's far easier to spot the guys who need a bit of help that way too.</p> Link to comment Share on other sites More sharing options...
kieranforthewin Posted February 28, 2014 Share Posted February 28, 2014 <p>You should use Microsoft Access.</p><p> </p><p> You can do stuff like Quary designs, so if you only wanted to look at Main Event faces then you can do that. It's good.</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="kieranforthewin" data-cite="kieranforthewin" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>You should use Microsoft Access.<p> </p><p> You can do stuff like Quary designs, so if you only wanted to look at Main Event faces then you can do that. It's good.</p></div></blockquote><p> </p><p> You can do that in Excel, also. Way easier to maintain than a database.</p> Link to comment Share on other sites More sharing options...
shawn michaels Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Apupunchau@optonline" data-cite="Apupunchau@optonline" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Like everyone else has stated I only make adjustments to overness and momentum after each PPV and resort. It takes me less than 5 minutes to type everything in and do the resort. I do spend a fair amount of time writing things out but because of how far I lay out my shows (3 or 4 months worth of shows one time I laid out from Janaury to Supreme challenge) I can run through shows very quickly i don't even have to guess at what angles I have to put or what matches they are all laid out. And then the quick few minute adjustments to the sheet after every PPV. And to tell the truth planning is totally part of the enjoyment to me. I'm a math guy, a statistician, so its fun for me to track these things.</div></blockquote><p> </p><p> It's funny how people with similar behaviours sometimes work in different ways. I also have a great appreciation for history, statistics and numbers, and such, and my fair share of OCD and i run away from that kind of writing and planning. I'm not knocking you down or anything, (or any other person that plans this way) I really think it's amazing how sometimes we can learn new things with this game. It is very interesting to see how sometimes similar persons take different aproaches to similar paths.</p> Link to comment Share on other sites More sharing options...
s6cks Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="JoshEngleman" data-cite="JoshEngleman" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>You can do that in Excel, also. Way easier to maintain than a database.</div></blockquote><p> </p><p> Really? I am a spreadsheet guy and would love to know that! Can you sort guys automaticly from lowest overness to highest this way too?</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted February 28, 2014 Share Posted February 28, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="s6cks" data-cite="s6cks" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Really? I am a spreadsheet guy and would love to know that! Can you sort guys automaticly from lowest overness to highest this way too?</div></blockquote><p> </p><p> For example, sorted by Total Matches:</p><p> </p><p> <a href="http://imgur.com/HiMdDj7" rel="external nofollow"><span>http://i.imgur.com/HiMdDj7.png</span></a></p><p> </p><p> Just Upper Midcard:</p><p> </p><p> <a href="http://imgur.com/eX1wSNl" rel="external nofollow"><span>http://i.imgur.com/eX1wSNl.png</span></a></p><p> </p><p> Just Upper Midcard in CHAOS:</p><p> </p><p> <a href="http://imgur.com/otHJbNj" rel="external nofollow"><span>http://i.imgur.com/otHJbNj.png</span></a></p><p> </p><p> Just upper midcard in CHAOS with more than 2 matches scheduled:</p><p> </p><p> <a href="http://imgur.com/Hsk6rpd" rel="external nofollow"><span>http://i.imgur.com/Hsk6rpd.png</span></a></p> Link to comment Share on other sites More sharing options...
s6cks Posted March 1, 2014 Share Posted March 1, 2014 <p>Impressive, loving it.</p><p> </p><p> Would you mind giving a screenshot of the whole thing? Or publish a blank version for us (me <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" />) to use?</p><p> </p><p> Thanks if this is possible !</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted March 1, 2014 Share Posted March 1, 2014 Absolutely. I'll get something up tomorrow. I ran my first 5k today and I feel like I got hit by a truck. Link to comment Share on other sites More sharing options...
D16NJD16 Posted March 2, 2014 Share Posted March 2, 2014 The game should do this kind of thing for you. As others have said, way too time consuming Link to comment Share on other sites More sharing options...
RKOwnage Posted March 8, 2014 Share Posted March 8, 2014 Currently I just track Momentum and Popularity. I have my roster laid out with momentum by week, so I can book matches where one worker can gain momentum over another. I also track popularity by month because I think it's good to see who's losing or gaining heat without having to go through everyone's profiles. Link to comment Share on other sites More sharing options...
Devilb0y Posted March 8, 2014 Share Posted March 8, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="JoshEngleman" data-cite="JoshEngleman" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>Absolutely. I'll get something up tomorrow. I ran my first 5k today and I feel like I got hit by a truck.</div></blockquote><p> </p><p> I'd love to get a spreadsheet I could sort. Although I use Open Office so I don't know if it will transfer.</p><p> </p><p> What time did you get on the 5k by the way? I ran my first ever 5k race a week ago and it was awesome.</p> Link to comment Share on other sites More sharing options...
TheZies Posted March 9, 2014 Share Posted March 9, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="JoshEngleman" data-cite="JoshEngleman" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div><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></div></blockquote><p> </p><p> this is a data hoarders wet dream. this is fantastic.</p> Link to comment Share on other sites More sharing options...
JoshEngleman Posted March 10, 2014 Share Posted March 10, 2014 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Devilb0y" data-cite="Devilb0y" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="37572" data-ipsquote-contentclass="forums_Topic"><div>I'd love to get a spreadsheet I could sort. Although I use Open Office so I don't know if it will transfer.<p> </p><p> What time did you get on the 5k by the way? I ran my first ever 5k race a week ago and it was awesome.</p></div></blockquote><p> </p><p> Ok, here's a link to my sheet. I left some data in it so you can get an idea of where things are. The Data tab runs everything. On the Tour Builder/Roster tabs, the stuff you want to change would be Name/Stable/Push/Etc. The results will all be pulled automatically from the Data tab. For the Tour Builder tab, you will need to manually change the dates in Row 2, to pull the new information. All of the formatting on the Roster/Tour Builder sheets is automatic. I'm assuming people will have questions. I'll do whatever I can to help. I'd be happy to add more tabs/info for people that want it.</p><p> </p><p> <a href="https://drive.google.com/file/d/0B8ZK66aTOmiJaGdxSVduaTRsVEE/edit?usp=sharing" rel="external nofollow">New Japan Pro Wrestling</a></p><p> </p><p> I believe my time was 32:54. I had a back injury about 2.5 months ago, so I literally had not done any exercise in that entire time. I went in to it completely cold.</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.