wwe9112 Posted May 5, 2016 Share Posted May 5, 2016 I posted this in the small questions thread a while back, but perhaps its too large of a question for that. So, essentially what I want to do export the MDB file, open it in access then show ONLY MY WORKERS STATS and export that to excel (if I can). I have two monitors, I think it would be nice to have all of my workers all on one screen so I can quickly see their stats as I make my cards up. Has anyone found a way to do this? Thank you. Link to comment Share on other sites More sharing options...
Infernalmiko Posted May 5, 2016 Share Posted May 5, 2016 I posted this in the small questions thread a while back, but perhaps its too large of a question for that. So, essentially what I want to do export the MDB file, open it in access then show ONLY MY WORKERS STATS and export that to excel (if I can). I have two monitors, I think it would be nice to have all of my workers all on one screen so I can quickly see their stats as I make my cards up. Has anyone found a way to do this? Thank you. I've used a free MDB viewer to look at the file and it allowed me to filter. But I don't have anything that can export to Excel, much as I'd love it. Link to comment Share on other sites More sharing options...
wwe9112 Posted May 5, 2016 Author Share Posted May 5, 2016 I've used a free MDB viewer to look at the file and it allowed me to filter. But I don't have anything that can export to Excel, much as I'd love it. I have Access (I'm actually a certified Microsoft Office Specialist in Access) lol. Thats not the problem. I just cannot figure out how to get only MY ROSTER to display -_-. I guess that is the question lol. Link to comment Share on other sites More sharing options...
wwe9112 Posted May 6, 2016 Author Share Posted May 6, 2016 Anyone? Link to comment Share on other sites More sharing options...
Idolized Posted May 6, 2016 Share Posted May 6, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="wwe9112" data-cite="wwe9112" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>Anyone?</div></blockquote><p> </p><p> Download Libre office and use their version of Access, Base. You can also export the data to Calc, their version excel</p> Link to comment Share on other sites More sharing options...
wwe9112 Posted May 6, 2016 Author Share Posted May 6, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Idolized" data-cite="Idolized" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>Download Libre office and use their version of Access, Base. You can also export the data to Calc, their version excel</div></blockquote><p> </p><p> LOL NO, I know how to do that. I actually own Access haha. I'm not sure how to get ONLY my roster with their stats is all. I can only find EVERYONE's stats. That's the question. Maybe I was misunderstood.</p> Link to comment Share on other sites More sharing options...
Scorpio3060 Posted May 6, 2016 Share Posted May 6, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="wwe9112" data-cite="wwe9112" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>LOL NO, I know how to do that. I actually own Access haha. I'm not sure how to get ONLY my roster with their stats is all. I can only find EVERYONE's stats. That's the question. Maybe I was misunderstood.</div></blockquote><p> </p><p> With Access, you should be able to setup a quarry that will only show the info that you want. You tell it what columns to show and how to sort and filter them.</p> Link to comment Share on other sites More sharing options...
Idolized Posted May 7, 2016 Share Posted May 7, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="wwe9112" data-cite="wwe9112" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>LOL NO, I know how to do that. I actually own Access haha. I'm not sure how to get ONLY my roster with their stats is all. I can only find EVERYONE's stats. That's the question. Maybe I was misunderstood.</div></blockquote><p> </p><p> Ah, that was my bad - thought you were asking a way to access them.</p> Link to comment Share on other sites More sharing options...
TheFlamingred Posted May 7, 2016 Share Posted May 7, 2016 <p>Shamelessly quoting myself from another thread, but you mean something like this...?</p><p> </p><blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="TheFlamingred" data-cite="TheFlamingred" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div><span>http://i66.tinypic.com/2ltre4l.jpg</span><p> </p><p> Well, in Excel, Data you can import a table from a database. I find Workers and Contracts enough for all the data I want. </p><p> </p><p> All you have to do is find your FedID by manually looking though the table for your user character. </p><p> </p><p> From there, create some code to search all the contracts that are linked to your FedID, and then bring all those rows into a table, and link those with all the rows which have the corresponding WorkerID.</p><p> </p><p> Then adjust the outcome to remove errors, etc and you're left with whats in the above pic.</p><p> </p><p> It's an hour or two of coding but I only have to do it once. (there is sometimes a small copy error in one of my code sections. I dont know why but sometimes on refresh of data - it mis-copies it. However, grabbing the above row in the right place and copying it down corrects it). The only downside is it gives you actual data, not scouting level data - if you like to have that bit of mystery. I also have some of my own formulas for some comparative numbers. </p><p> </p><p> I say it takes an hour or two, I spent about 20 hours doing the same for TEW13, as I had to use the main database save file and collect about 5 different tables to collate, instead of two, so I was well versed in this when TEW16 had Database exports.</p><p> </p><p> If you want me to upload the excel file and a tutorial on how to use it, I can but you'll probably have to wait till Monday as I work all weekend.</p></div></blockquote> Link to comment Share on other sites More sharing options...
Lucas Posted May 7, 2016 Share Posted May 7, 2016 <p>Just run a SQL Query like this in Access, either one will do: </p><p> </p><p> SELECT Workers.* FROM Workers, Contracts WHERE Workers.UID=Contracts.WorkerUID AND Contracts.CompanyName ="WWF";</p><p> </p><p> OR </p><p> </p><p> SELECT * FROM Workers LEFT JOIN Contracts ON Workers.UID=Contracts.WorkerUID WHERE Contracts.CompanyName ="WWF";</p><p> </p><p> This will return the Workers Table filtered by the Workers who work for WWF, in this case. In your case, just replace WWF with the initials for your promotion as it appears in game.</p><p> </p><p> You can then just copy this table over to Excel.</p><p> </p><p> This takes about 2 minutes, obviously code formatting in Excel or something even more advanced can take a lot longer depending on what data you're trying to pull and what it is you're trying to do.</p> Link to comment Share on other sites More sharing options...
TheFlamingred Posted May 7, 2016 Share Posted May 7, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="MrCreative" data-cite="MrCreative" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>Just run a SQL Query like this in Access, either one will do: <p> </p><p> SELECT Workers.* FROM Workers, Contracts WHERE Workers.UID=Contracts.WorkerUID AND Contracts.CompanyName ="WWF";</p><p> </p><p> OR </p><p> </p><p> SELECT * FROM Workers LEFT JOIN Contracts ON Workers.UID=Contracts.WorkerUID WHERE Contracts.CompanyName ="WWF";</p><p> </p><p> This will return the Workers Table filtered by the Workers who work for WWF, in this case. In your case, just replace WWF with the initials for your promotion as it appears in game.</p><p> </p><p> You can then just copy this table over to Excel.</p><p> </p><p> This takes about 2 minutes, obviously code formatting in Excel or something even more advanced can take a lot longer depending on what data you're trying to pull and what it is you're trying to do.</p></div></blockquote><p> </p><p> That sounds like the clever, smart, efficient way <img alt=";)" data-src="//content.invisioncic.com/g322608/emoticons/wink.png.686f06e511ee1fbf6bdc7d82f6831e53.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> </p><p> I should really learn how to use databases. I pulled my data doing a pretty much iterative search of the entire contracts/workers file, and a lot of IFERROR commands. <img alt=":p" data-src="//content.invisioncic.com/g322608/emoticons/tongue.png.ceb643b2956793497cef30b0e944be28.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p> Link to comment Share on other sites More sharing options...
Lucas Posted May 7, 2016 Share Posted May 7, 2016 <p>Yeah you don't need to do it that way, it can be done a lot more efficiently <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> </p><p> Learning SQL (there are a lot of different types so your syntax and what you can do may vary, AccessSQL is the language for TEW) and using this for TEW can be pretty rewarding for data mining and having stuff for your own game to help with planning. </p><p> </p><p> The thing with Ifs, are that it can get very complex and time consuming to set up and process. Remember that with Ifs it will always test the condition you are asking for, until it reaches the desired result. So I can only imagine how painful that might have been to do (doing IFs in Excel I really hate thanks to the single line textbox).</p> Link to comment Share on other sites More sharing options...
TheFlamingred Posted May 7, 2016 Share Posted May 7, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="MrCreative" data-cite="MrCreative" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>Yeah you don't need to do it that way, it can be done a lot more efficiently <img alt=":D" data-src="//content.invisioncic.com/g322608/emoticons/biggrin.png.929299b4c121f473b0026f3d6e74d189.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /><p> </p><p> Learning SQL (there are a lot of different types so your syntax and what you can do may vary, AccessSQL is the language for TEW) and using this for TEW can be pretty rewarding for data mining and having stuff for your own game to help with planning. </p><p> </p><p> The thing with Ifs, are that it can get very complex and time consuming to set up and process. Remember that with Ifs it will always test the condition you are asking for, until it reaches the desired result. So I can only imagine how painful that might have been to do (doing IFs in Excel I really hate thanks to the single line textbox).</p></div></blockquote><p> </p><p> The good thing is though, I used to write simuations for mathematically modelling animal behaviour (movement), so I can happily IF statement and FOR loop for hours. It was never pretty, but it always got the job done. </p><p> </p><p> Lack of efficiency FTW! </p><p> </p><p> Ps., there needs to be a fed made in TEW called FTW.</p> Link to comment Share on other sites More sharing options...
Motor Posted May 7, 2016 Share Posted May 7, 2016 Finally I found a way to combine TEW with learning for my exams in Operations Research. Thanks <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...
TheFlamingred Posted May 7, 2016 Share Posted May 7, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Motor" data-cite="Motor" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41471" data-ipsquote-contentclass="forums_Topic"><div>Finally I found a way to combine TEW with learning for my exams in Operations Research. Thanks <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> Come to the 0/0/0/0 thread. I'm using Linear Programming to determine how easy / impossible surviving 18 months is based on poor Wrestling Industry / economy. </p><p> </p><p> </p><p> Fixed Constants: Show Cost per show C, Popularity Gain per show G, Sponspor per Popularity S.</p><p> Variables: Shows in Month 1 (m1), Shows in Month 2 (m2)... shows in Month 18 (m18).</p><p> </p><p> Maximise month 18 profits, P.</p> Link to comment Share on other sites More sharing options...
Jay Jay Killer Posted March 30, 2017 Share Posted March 30, 2017 The Flemingred.I liked it a lot and I want this file the Tew database. Can you send to this email: <a href="mailto:" rel="">jjkbrasfoot@gmail.com</a>? Grateful Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.