The_Monk Posted January 30, 2017 Share Posted January 30, 2017 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Powerful_Fox" data-cite="Powerful_Fox" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div>I normally use excel as a notepad and also sometimes create a league table.<p> I was playing about tonight and was thinking about Football Manager, so I put this together:</p><p> </p><p> </p></div></blockquote><p> </p><p> Like yeah just go home hand have a "play" about and knock this up....this looks amazing will download tonight and try with my WWF game using the COTT mod.</p><p> </p><p> Tag teams would be nice if you could maybe add something for them? Not sure what yet, so maybe i'll have a think on that once ive used this and have a better understanding of it. Great job tho dude</p><p> </p><p> Having had a quick look (at the stock data) one thing that would be good is under finical would be the Expire date of the persons Contract. ie 365days or 2months 3days etc</p> Link to comment Share on other sites More sharing options...
AfRoMaN36 Posted January 30, 2017 Share Posted January 30, 2017 <p><a href="https://postimg.org/image/4r8bnh6vt/" rel="external nofollow"><img alt="WP_20170127_11_06_12_Pro.jpg" data-src="https://s28.postimg.org/4r8bnh6vt/WP_20170127_11_06_12_Pro.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></a></p><p> </p><p> </p><p> I legit use a notebook and carry it around with me. When I'm on public transportation or on break at work I jot down notes. On top are my matches, on the bottom are the angles to corresponding storylines.</p> Link to comment Share on other sites More sharing options...
steesh07 Posted January 30, 2017 Share Posted January 30, 2017 This is legit what needs to be added in to TEW 19 (or the next iteration), just an example of it in action (on Office 2003 and there is no issues at present). But in TEW terms: A 45 year old Christopher Daniels vs a 39 year old Brock Lesnar. Definitely a fan mate well done. ***EDIT*** Slight mistake with formula on O9 N9 (Comparison Sheet) but sorted it by dragging the formula from N3 and O3 down to the bottom of the comparison column. Link to comment Share on other sites More sharing options...
Powerful_Fox Posted January 30, 2017 Share Posted January 30, 2017 Tag teams would be nice if you could maybe add something for them? Not sure what yet, so maybe i'll have a think on that once ive used this and have a better understanding of it. Great job tho dude Having had a quick look (at the stock data) one thing that would be good is under finical would be the Expire date of the persons Contract. ie 365days or 2months 3days etc Good idea on the tag teams mate, let me know the sort of thing you might be after and I will see about knocking it up. The contract remaining days has been added so will link that one after a couple more bits/ideas have been done . Definitely a fan mate well done. ***EDIT*** Slight mistake with formula on O9 N9 (Comparison Sheet) but sorted it by dragging the formula from N3 and O3 down to the bottom of the comparison column. Cheers mate, thanks a lot. The issue you are seeing, I'm not getting i'm afraid, was it just out of sync for you? Interesting comparison between Daniels and Lesnar. Wonder if mod makers might enjoy it just to see graphically when they create some workers how they compare with others when setting their stats etc. Link to comment Share on other sites More sharing options...
AceCodey Posted January 30, 2017 Share Posted January 30, 2017 http://image.prntscr.com/image/5daefd2352964352b87cb2fe70bf4fd5.png Pretty much Docs. Link to comment Share on other sites More sharing options...
The_Monk Posted January 30, 2017 Share Posted January 30, 2017 OK I cant seem to get this to work, and before I post in technical support I just wonder if anyone has any ideas. When I select the DB to use I get the message "DataFormat.Error: Not a valid password" this is on any save I try.... none of which have passwords on the games? Link to comment Share on other sites More sharing options...
vbase Posted January 31, 2017 Author Share Posted January 31, 2017 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="codeydbw" data-cite="codeydbw" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div><div style="text-align:center;"><span>http://image.prntscr.com/image/5daefd2352964352b87cb2fe70bf4fd5.png</span><p> </p></div><p></p><p></p><p> <span style="font-family:Garamond;"><span style="font-size:14px;">Pretty much Docs.</span></span></p></div></blockquote><p> </p><p> I have tried that, first with notepad and then Word. I think it requires too much effort and some times drags me behind. I mean I can either type for the next 10-15 minutes and then run one show or I can book 2-3 shows in that time.</p> Link to comment Share on other sites More sharing options...
The_Monk Posted January 31, 2017 Share Posted January 31, 2017 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="vbase" data-cite="vbase" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div>I have tried that, first with notepad and then Word. I think it requires too much effort and some times drags me behind. I mean I can either type for the next 10-15 minutes and then run one show or I can book 2-3 shows in that time.</div></blockquote><p> </p><p> Id imagine id use this route if doing a Dynasty as it would be a good memory jerker for my main writing</p> Link to comment Share on other sites More sharing options...
vbase Posted January 31, 2017 Author Share Posted January 31, 2017 <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="43205" data-ipsquote-contentclass="forums_Topic"><div>OK I cant seem to get this to work, and before I post in technical support I just wonder if anyone has any ideas. When I select the DB to use I get the message "DataFormat.Error: Not a valid password" this is on any save I try.... none of which have passwords on the games?</div></blockquote><p> </p><p> You need to export the MDB file by going into settings and using the option "Create MDB file" which will create an MDB file inside the save game folder. That's the data you use.</p> Link to comment Share on other sites More sharing options...
wwfmark Posted February 1, 2017 Share Posted February 1, 2017 This is legit what needs to be added in to TEW 19 (or the next iteration), just an example of it in action (on Office 2003 and there is no issues at present). But in TEW terms: A 45 year old Christopher Daniels vs a 39 year old Brock Lesnar. Definitely a fan mate well done. ***EDIT*** Slight mistake with formula on O9 N9 (Comparison Sheet) but sorted it by dragging the formula from N3 and O3 down to the bottom of the comparison column. As someone who lightly dabbles in excel, this looks really cool. What type of chart is that called? Link to comment Share on other sites More sharing options...
steesh07 Posted February 1, 2017 Share Posted February 1, 2017 @wwfmark It's an excel file mate yeah, I have put instructions on the frontage of the file to show Excel 2016 users how to update it to their data. For Excel 2013 users, you may need to download the Power Query add-in from the Microsoft Support page. The only thing I am trying to figure out at the moment is changing the Popularity region without having to go into the formula. http://i79.photobucket.com/albums/j145/richard_fox/ExcelTEWComparisonPopFormulaChanges_zpse8sefm1z.jpg In order to change this for your specific area, you will need to change the highlighted text to the area name. At the moment I need to figure out how to use the area name as a drop-down list and for the popularity to change based on BOTH the worker name and the area name. This isn't as easy as I thought it would be as the worker name is a value in the data whereas the area name is a column name in the data. I am completely open to suggestions/opinions etc. on what to do to expand this further. Remember though that I can only do what is allowed within the exported data so things like tracking skill/popularity changes and such for a worker is a no-go as it doesn't exist in the exported .mdb files. I have spoken to Adam directly about this and unfortunately it just isn't feasible to include currently. TEW Profiler 1.01: http://www.mediafire.com/file/ouaajc8j75c3fo7/TEW_2016_Profiler_1.01.xlsx Powerful Fox made it, have look a page back mate. Is a brilliant little "extension" for TEW16. Link to comment Share on other sites More sharing options...
Powerful_Fox Posted February 1, 2017 Share Posted February 1, 2017 @wwfmark Powerful Fox made it, have look a page back mate. Is a brilliant little "extension" for TEW16. They are radar charts mate. I will have a look at the data over the next week and see if there is anything else that I can do to enhance the file. Tag Teams mentioned previously was a good idea but I don't know what to pop in for it. I saw there was a match history table in the .mdb so I might be able to pull in a workers average rating and a line chart to see rating progression over time or something, it depends what the table holds though. I encourage suggestions also, I think this sort of thing can only grow with people bouncing ideas etc. . Link to comment Share on other sites More sharing options...
wwfmark Posted February 1, 2017 Share Posted February 1, 2017 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Powerful_Fox" data-cite="Powerful_Fox" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div>They are radar charts mate.<p> I will have a look at the data over the next week and see if there is anything else that I can do to enhance the file. Tag Teams mentioned previously was a good idea but I don't know what to pop in for it. I saw there was a match history table in the .mdb so I might be able to pull in a workers average rating and a line chart to see rating progression over time or something, it depends what the table holds though.</p><p> </p><p> I encourage suggestions also, I think this sort of thing can only grow with people bouncing ideas etc. <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" />.</p></div></blockquote><p> </p><p> Radar charts, thanks I'm going to look into those!</p> Link to comment Share on other sites More sharing options...
vbase Posted February 2, 2017 Author Share Posted February 2, 2017 I encourage suggestions also, I think this sort of thing can only grow with people bouncing ideas etc. . Maybe instead of the font color used for stats in the comparison one, you can use red and green. So if I were to compare two wrestlers, for every stat, the wrestlers with the higher stat gets green and the one with lower stat gets red. Something like this: http://i.imgur.com/1hm4k4d.png Link to comment Share on other sites More sharing options...
Powerful_Fox Posted February 2, 2017 Share Posted February 2, 2017 100% agree mate. I thought the two colours sets made them look far too similar. I will be honest, I had a very similar thought but at the same time I wanted another gradient style that showed a different colour depending on the difference between two peoples stats. I think you maybe right however that just showing the difference with a red/green font colour may well be enough to show the differentiation. Link to comment Share on other sites More sharing options...
steesh07 Posted February 2, 2017 Share Posted February 2, 2017 100% agree mate. I thought the two colours sets made them look far too similar. I will be honest, I had a very similar thought but at the same time I wanted another gradient style that showed a different colour depending on the difference between two peoples stats. I think you maybe right however that just showing the difference with a red/green font colour may well be enough to show the differentiation. Is it possible on the comparison of overness bar to have two colours? So the bar is filled more by the colour of who has the most popularity? Link to comment Share on other sites More sharing options...
AceCodey Posted February 2, 2017 Share Posted February 2, 2017 Id imagine id use this route if doing a Dynasty as it would be a good memory jerker for my main writing It's weird, I can't really enjoy booking SE promotions unless I write at least some general notes about what happens in each segment. Link to comment Share on other sites More sharing options...
pens66 Posted February 4, 2017 Share Posted February 4, 2017 <p>I always write down what happens in all segments of my shows to be able to read up on it after longer breaks from the game. And I keep track of my roster with a spread sheet, that's developed over time (see image).</p><p> You probably don't understand a whole lot at first glance, but it lists the wrestlers with their strengths, a note if they have a manager, are part of a tag team, if they are set for a push or strictly jobbers/developmental projects. It also keeps track of who is involved in storylines, is a member of a stable or is currently unavailable. I originally also listed the gimmicks of each character, but the longer a game goes the better I know everyone. So I can savely remove the gimmicks to save lots of space.</p><p><a class="ipsAttachLink ipsAttachLink_image" href="<fileStore.core_Attachment>/monthly_2017_02/ewrspread.jpg.3b2541775a4b38e77f7510f3fd333512.jpg" data-fileid="3276" data-fileext="jpg" rel=""><img data-fileid="3276" class="ipsImage ipsImage_thumbnailed" alt="ewrspread.jpg.3b2541775a4b38e77f7510f3fd333512.jpg" data-src="<fileStore.core_Attachment>/monthly_2017_02/ewrspread.jpg.3b2541775a4b38e77f7510f3fd333512.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></a></p> Link to comment Share on other sites More sharing options...
Motor Posted February 8, 2017 Share Posted February 8, 2017 I tried to use Access databases or Excel Files and spreadsheets, but I always got lost in the process and ultimately ended up losing interest in the actual game, so now I only use the in-game notepad and the pre-booking feature. I rarely use Xmind to make Mindmaps if I have a lot of ideas for a game, though. Link to comment Share on other sites More sharing options...
vbase Posted February 9, 2017 Author Share Posted February 9, 2017 I tried to use Access databases or Excel Files and spreadsheets, but I always got lost in the process and ultimately ended up losing interest in the actual game, so now I only use the in-game notepad and the pre-booking feature. I rarely use Xmind to make Mindmaps if I have a lot of ideas for a game, though. Sometimes the note taking can become too much time consuming, almost overriding the original purpose. The main idea behind this whole topic was the fact that I either didn't take notes or if I did, I took more time taking notes than the gameplay itself. I took a look at XMind, looks very good, but it is too expensive to just use for note-taking and experience enhancing, don't you think? I use Draw.io for that purpose, it's not exactly the same, but does a great job. http://i.imgur.com/teoPK17.png Here's one I made for my main event scene. The left side is the heels, right is the babyfaces, the top one is the current champion. The red lines suggest feuds within the storyline. However, it was again too time taking, and I couldn't make it look visually appealing, so I never went back to that. http://i.imgur.com/Rt5OcNW.png Although, I guess it will do a great job for tournaments. Link to comment Share on other sites More sharing options...
Defmall Posted February 9, 2017 Share Posted February 9, 2017 <p>Not sure if I'm answering this 100% correctly, but whenever I start a new game I create an Excel spreadsheet.</p><p> </p><p> Left side = faces, right side = heels</p><p> The sheet is broken down by push (Main event, upper card, etc)</p><p> For each wrestler, I list their strongest skills and their pay </p><p> </p><p> At the bottom I list the "positions" like announcers, refs, etc.</p><p> Again with skills and pay.</p><p> </p><p> Yes, it could take 20-30 minutes to set it up, but this gives me an 'at a glance' of who I have...so when I book a card I can make sure I'm using my top guys, and I'm not booking 'pay per show' guys when my budget gets tight.</p> Link to comment Share on other sites More sharing options...
Motor Posted February 10, 2017 Share Posted February 10, 2017 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="vbase" data-cite="vbase" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div>I took a look at XMind, looks very good, but it is too expensive to just use for note-taking and experience enhancing, don't you think? I use <strong>Draw.io</strong> for that purpose, it's not exactly the same, but does a great job.</div></blockquote><p> </p><p> There's a free version of Xmind which allows you to make different types of Mindmaps, like trees or even timelines. I made an Excel sheet for tournament brackets, but for small (8-man) tournaments I also use the in-game notepad. I like the draw.io sheet with the worker pictures, but again I never have more than 10 storylines so I think I can keep track of who is involved. I think the biggest problem is to get an overview of your workers when you start a save. When you're several months into the game it's easier since you've built your own stories with them. </p><blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Defmall" data-cite="Defmall" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="43205" data-ipsquote-contentclass="forums_Topic"><div>Not sure if I'm answering this 100% correctly, but whenever I start a new game I create an Excel spreadsheet.<p> </p><p> Left side = faces, right side = heels</p><p> The sheet is broken down by push (Main event, upper card, etc)</p><p> For each wrestler, I list their strongest skills and their pay </p><p> </p><p> At the bottom I list the "positions" like announcers, refs, etc.</p><p> Again with skills and pay.</p><p> </p><p> Yes, it could take 20-30 minutes to set it up, but this gives me an 'at a glance' of who I have...so when I book a card I can make sure I'm using my top guys, and I'm not booking 'pay per show' guys when my budget gets tight.</p></div></blockquote><p> </p><p> That's a good idea, especially listing up the top skills of every worker would help me to get into a roster faster, I will give it a try.</p> Link to comment Share on other sites More sharing options...
Defmall Posted February 10, 2017 Share Posted February 10, 2017 @Motor - I also use this to make sure I'm putting guys together who are compatible. When you are trying to get your mid-card guys to have good matches, I want to avoid the "they had no chemistry" penalty! Link to comment Share on other sites More sharing options...
wwfmark Posted February 14, 2017 Share Posted February 14, 2017 I downloaded the MDB file but couldn't open it in Excel, any tips? Link to comment Share on other sites More sharing options...
fullMETAL Posted February 14, 2017 Share Posted February 14, 2017 You're supposed to use the Export To Spreadsheet function in the Editor, the MDB files themselves can't be opened in Excel if I'm not mistaken. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.