HarmonyOfDissonance Posted August 12, 2016 Share Posted August 12, 2016 Those who use spreadsheets, I'm starting one up now, for the first time. What kind of information do you guys have on yours? What all is on a spreadsheet? Roster information? Feud plans? I'm sure that in the long run, there's no such thing as too much/too little information and it's all subjective, but how do you divide it all up? Link to comment Share on other sites More sharing options...
lois lily Posted August 12, 2016 Share Posted August 12, 2016 Ok mine is massively stolen from flaming red. But I have brand, momentum, stamina, gimmick and rating. Popularity and then I've used my own formulas to work out roughly what angle a wrestler will get the best rating from. There's also a boat load of conditional formatting to alert me of low momentum, rubbish gimmick rating etc. I also use it to keep track of good up and comers. Also running a brand split I have a graph so I can plot show ratings to see which brand is doing the business and who isn't. Link to comment Share on other sites More sharing options...
James Casey Posted August 12, 2016 Share Posted August 12, 2016 Main tab Roster, broken up by push. I've taken to colour coding them of late, too, as the seven slots from ME-ET balance nicely with the seven colours for grades from A-F Titlists Show loop (which show will run in which region; With 2 weekly shows and a PPV/Special each month, I hit all the mainland US regions in a loop) Managers/Stables/Teams, the last of which seems a bit redundant but I forgot to book the Young Pistols or add them to any storylines because they weren't in the spreadsheet as a team A section where I note things like failing gimmicks, thoughts about potential feuds/PPV matches and so on. Feuds - I've previously colour coded these so I could then see at a glance which workers (coloured to match) I could throw together to advance a feud. Other tabs Wages, for when I have a lot of PPA contracts; It's less of a concern nowadays but on older games I'd have so many contracts I had to schedule worker appearances within a budget Worker info, things like size, weight, height, gimmick, catchphrases, notable rivalries/allies... I mainly don't use this unless for a diary Tournaments, 3 tabs with 8/16/32 worker tournaments laid out with seedings, brackets and so on. Link to comment Share on other sites More sharing options...
Dochappy Posted August 23, 2016 Share Posted August 23, 2016 James do you have a copy of your spreadsheet available to download? Link to comment Share on other sites More sharing options...
Owen Rey Posted August 23, 2016 Share Posted August 23, 2016 <p><a href="https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg" rel="external nofollow">https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg</a></p><p> </p><p> Here's mine, feel free to look around. The roster page is unbelievably wildly out of date, I don't know why I still have it there</p> Link to comment Share on other sites More sharing options...
Dochappy Posted August 23, 2016 Share Posted August 23, 2016 Owen can you explain the tournament tab? what's the colors for and etc? Link to comment Share on other sites More sharing options...
Owen Rey Posted August 23, 2016 Share Posted August 23, 2016 So I have my lists of winners, then to the right I have my set up for my mini version of the G1 Climas... The Rock's Invitational. The colors are so I know what to book each week. It's hard to make it so everyone wrestles only once per week so I color coat it to make it my best. You'll see above all the wrestlers I have the weeks there to assign the colors Link to comment Share on other sites More sharing options...
Bonafide_Bluffa Posted August 23, 2016 Share Posted August 23, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Owen Rey" data-cite="Owen Rey" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div><a href="https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg" rel="external nofollow">https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg</a><p> </p><p> Here's mine, feel free to look around. The roster page is unbelievably wildly out of date, I don't know why I still have it there</p></div></blockquote><p> </p><p> Going through your PPV main events was really fun. Really like the Weekend In Japan idea (Cena/Ishii would be money) and I'm glad you gave Punk and Cena a Wrestlemania main event.</p> Link to comment Share on other sites More sharing options...
Owen Rey Posted August 23, 2016 Share Posted August 23, 2016 <p>Yeah man the one cheating thing I did was bringing Punk back and I told myself the one thing I wanted to do with him was main event WM with Cena. Got that done so I'm happy.</p><p> </p><p> The weekend in Japan thing can be tough, I can only PPA guys and that pool keeps getting thinner. NJPW refuses to work with me and all their PPA guys refuse to work for me on 2 apperance PPAs if they're loyal to New Japan. Pried Gedo away after they removed him as booker though so he can come up from his position as NXT booker and wrestler a couple times a year</p><p> </p><p> Glad you enjoyed looking around!</p> Link to comment Share on other sites More sharing options...
The_Monk Posted August 24, 2016 Share Posted August 24, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Owen Rey" data-cite="Owen Rey" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div><a href="https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg" rel="external nofollow">https://mega.nz/#!aIVWQTbJ!4mWFLEABa1nb4oJPe4v2bE9gxKsGAQ1ld8hSBLznASg</a><p> </p><p> Here's mine, feel free to look around. The roster page is unbelievably wildly out of date, I don't know why I still have it there</p></div></blockquote><p> </p><p> I like this layout.... think I'll look at implementing it, only thing i'll potentially change is the roster tab so that it shows Disposition rather than Title, although I may keep title and simply add disposition.</p> Link to comment Share on other sites More sharing options...
The_Monk Posted August 31, 2016 Share Posted August 31, 2016 <p>Finally set my sheet up last night. Awesome. I made a few tweaks as well</p><p> </p><p> Firstly I added disposition to the roster tab. I also added a formula on the side that calculates for me the Number I've got for each push and disposition, ive found this just makes it a quicker glance rather than having to filter each time.</p><p> </p><p> ON the tag team tab ive again added a disposition column and a Experience Column. With another assoictaed formula for dispositions so I can see the balance of my teams.</p><p> </p><p> Removed a couple of sheets im never going to use, Title History etc, but have kept the Events sheet as that works excellently especially for Tournaments.</p><p> </p><p> All in all I think this sheet is now going to:</p><p> a) make my management skills improve</p><p> b) i'll get more out of the game because of reason a) <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p> Link to comment Share on other sites More sharing options...
Dochappy Posted August 31, 2016 Share Posted August 31, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="The_Monk" data-cite="The_Monk" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div> I also added a formula on the side that calculates for me the Number I've got for each push and disposition</div></blockquote><p> </p><p> what formula are you using. I'm trying to set up something like that as well as a formula that will track how many wins a worker has and then figure out the total points that worker has.</p><p> </p><p> In my tag team standings a win gets the team 2 points and a draw 1 point.</p><p> </p><p> any idea how I would go about setting that up?</p> Link to comment Share on other sites More sharing options...
lois lily Posted August 31, 2016 Share Posted August 31, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Dochappy" data-cite="Dochappy" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div>what formula are you using. I'm trying to set up something like that as well as a formula that will track how many wins a worker has and then figure out the total points that worker has.<p> </p><p> In my tag team standings a win gets the team 2 points and a draw 1 point.</p><p> </p><p> any idea how I would go about setting that up?</p></div></blockquote><p> </p><p> Are you looking to manually the results that's pretty to do. Or are you looking to extract the data from the game.</p> Link to comment Share on other sites More sharing options...
lois lily Posted August 31, 2016 Share Posted August 31, 2016 <p>I've added two more sheets to mine. A performance one where I manually add each individual's match rating and have a formula pull out an average. Quite handy for seeing who is consistently tanking matches. </p><p> I've also added a sheet where I add any positive or negative opinions. So least o know who people are high on and who they aren't. At the moment I just keep a tally of positives and negatives rather than what it specifically relates to. But that's quite useful to see who is getting a lot of people with positives opinions on them.</p> Link to comment Share on other sites More sharing options...
Dochappy Posted August 31, 2016 Share Posted August 31, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="lois lily" data-cite="lois lily" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div>Are you looking to manually the results that's pretty to do. Or are you looking to extract the data from the game.</div></blockquote><p> </p><p> I could never get the database to work right so I do it manually.</p><p> </p><p> could you calculate the performance without exporting the database?</p><p> </p><p> if so could you share your formula/method of figuring it out?</p> Link to comment Share on other sites More sharing options...
The_Monk Posted August 31, 2016 Share Posted August 31, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Dochappy" data-cite="Dochappy" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="42379" data-ipsquote-contentclass="forums_Topic"><div>what formula are you using. I'm trying to set up something like that as well as a formula that will track how many wins a worker has and then figure out the total points that worker has.<p> </p><p> In my tag team standings a win gets the team 2 points and a draw 1 point.</p><p> </p><p> any idea how I would go about setting that up?</p></div></blockquote><p> </p><p> So on my "Roster" tab ive got everything that was previously there, but ive also added a column for "Disposition", then on the side I've got all the Pushes Abbreviated (ME,UM,MC,LM etc) and ive got Faces and Heels then the formula ive used is:</p><p> pushes:</p><p> =COUNTIF(C:C,"Main Eventer")</p><p> </p><p> Disposition:</p><p> =COUNTIF(D: D,"Heel")</p><p> </p><p> you simply then substitute the word you want to use. The C:C and D: D are the columns and all the rows in the column</p><p> </p><p> This means at a quikc glance I can for example see that ive got 9 Main Eventers and just saves me filtering the column, obviously I can then filter to see who they are</p> Link to comment Share on other sites More sharing options...
The_Monk Posted August 31, 2016 Share Posted August 31, 2016 <p>for what you want you seems to want a simple league table so watch this video and you'll be fine</p><p> </p><p> </p><div class="ipsEmbeddedVideo"><div><iframe width="200" height="113" src="https://www.youtube-nocookie.com/embed/jxMcaMJaDc0?feature=oembed" frameborder="0" allowfullscreen="" title="a simple league table in excel"></iframe></div></div> Link to comment Share on other sites More sharing options...
Dochappy Posted August 31, 2016 Share Posted August 31, 2016 <p>Thanks for that Monk. Really helps me out</p><p> </p><p> I have a column that ranks my workers based on their win loss record. Each win is 3 points and a draw is 1. in one column I have their total points and then in the next is the rank column where I use this formula to rank the workers</p><p> </p><pre class="ipsCode">=RANK(G2,$G$2:$G$32)+COUNTIF($G$2:G2,G2)-1</pre><div></div><p></p><p> </p><p> Anyone know if it's possible using my rank column and the worker name column to fill tells with my top ten wrestlers based on their record.</p><p> </p><p> I have the rank column set up so it automatically updates when i update wins or losses and would love to have the top ten updated dynamically like that.</p><p> </p><p> i've tried Vlookup and Hlookup without much luck</p><p> </p><p> fixed the formula and it works now: </p><pre class="ipsCode">=INDEX($A$2:$A$32,MATCH(J2:J11,$H$2:$H$32,))</pre><div></div><p></p> Link to comment Share on other sites More sharing options...
Dochappy Posted September 11, 2016 Share Posted September 11, 2016 <p><a href="https://drive.google.com/file/d/0B-p0VKNOdClbcjJQMDlYYzZJaEE/view?usp=sharing" rel="external nofollow">My current spreadsheet. Uses LibreOffice Calc</a></p><p> </p><p> any ideas ona good way to layout the data to keep track of stat changes at the end of each year. I don't mind doing it manually but I can't find a good layout and format that looks good and is easier to update</p> Link to comment Share on other sites More sharing options...
Payne Posted September 11, 2016 Share Posted September 11, 2016 <p>Tab 1: Roster WLD record, with macro to auto update streaks. Managers and clients. Pushes and Chemistry</p><p> Tab 2: Finances, Popularity and shows</p><p> Tab 3: Titles</p><p> Tab 4: Former workers.</p> Link to comment Share on other sites More sharing options...
scuba steve Posted September 11, 2016 Share Posted September 11, 2016 <p>This thread would probably be of interest to you:</p><p> <a href="http://www.greydogsoftware.com/forum/showthread.php?t=526857" rel="external nofollow">http://www.greydogsoftware.com/forum/showthread.php?t=526857</a></p><p> </p><p> Has 2 screenshots of example spreadsheets & then a link to another spreadsheet on GoogleSheets</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.