Excel File

[lois lily]

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Peter.1986" data-cite="Peter.1986" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>I mean sort of a way to list the database (without having to start a game) eg so if I was editing, I could go onto excel and list the whole database by star quality. I would still use the database to edit, but to compare people's stats?<p> </p><p> It would be great to edit in excel and transfer back but I didn't think that would be realistic. Excel is brilliant for mass editing</p></div></blockquote><p> </p><p> All that info can be pulled from the MDB file, in the workers section.</p>

[TheFlamingred]

<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="41603" data-ipsquote-contentclass="forums_Topic"><div>All that info can be pulled from the MDB file, in the workers section.</div></blockquote><p> </p><p> While it can, you can't put it back into the database from the exported one - as it doesn't have any impact from the save.</p><p> </p><p> You'd have to export the password protected save game database, extract from that, edit in excel and then copy and past it back into the password protected save file. </p><p> </p><p> It's doable but has two issues</p><p> 1) you make a tiny error in your edits, e.g., hit o instead of 0, you're going to cause and error and crash when that bit of data is used. It's why Adam doesn't suggest you edit this file like this.</p><p> </p><p> 2) the tabs in the save game database are different to what we are given in the Exported database (it's why it takes so long to export when you've gone through a few game years - as its hacking together a whole new database, not simply making an exact replica of the current database). I believe a workers Id and name are on one tab, their skills are in another, and their popularity are in a third ( it's been a while since I looked at it). In Tew 2013 I had to import about 6 tables, instead of just the two of Contracts and Workers, in order to get the same information.</p><p> </p><p> Needless to say, my codes and things from this file only work with exported databases, and will likely fail if it gets data from the main database.</p>

[lois lily]

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="TheFlamingred" data-cite="TheFlamingred" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>While it can, you can't put it back into the database from the exported one - as it doesn't have any impact from the save.<p> </p><p> You'd have to export the password protected save game database, extract from that, edit in excel and then copy and past it back into the password protected save file. </p><p> </p><p> It's doable but has two issues</p><p> 1) you make a tiny error in your edits, e.g., hit o instead of 0, you're going to cause and error and crash when that bit of data is used. It's why Adam doesn't suggest you edit this file like this.</p><p> </p><p> 2) the tabs in the save game database are different. I believe a workers Id and name are on one tab, their skills are in another, and their popularity are in a third (for example - it's been a while since I looked at it). In Tew 2013 I had to import about 6 tables, instead of just the two of Contracts and Workers, in order to get the same information.</p></div></blockquote><p> </p><p> But to want to pull the info out into excel and then push it back in seems slightly insane, especially when the TEW editor is pretty easy to use.</p>

[TheFlamingred]

<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="41603" data-ipsquote-contentclass="forums_Topic"><div>But to want to pull the info out into excel and then push it back in seems slightly insane, especially when the TEW editor is pretty easy to use.</div></blockquote><p> <img alt=";)" data-src="//content.invisioncic.com/g322608/emoticons/wink.png.686f06e511ee1fbf6bdc7d82f6831e53.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> not insane - just a lot of work for what maybe not be too much reward - bit too much hassle for editing a in the small scale.</p><p> </p><p> However, if I wanted to make a whole new database, I'd extract everything from the main password protected file, edit it all in excel, and push it back into access without hesitation. For that level of information change, it would be worth the effort of unpicking the save file.</p>

[Peter.1986]

<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="41603" data-ipsquote-contentclass="forums_Topic"><div>But to want to pull the info out into excel and then push it back in seems slightly insane, especially when the TEW editor is pretty easy to use.</div></blockquote><p> </p><p> The editor is fairly easy to use, but there's a hell of a lot missing from it, as in what you can in excel. Such as search for certain stats or sort stats, attributes in order. It's hard to compare workers really. You rate someone a B and someone else a B- then side by side think we'll actually the guy at b- I'd better at that stat than the b guy</p>

[gazdaman]

its not allowing me to select from access

[TheFlamingred]

<p>Have you deleted all the cells in the contracts and workers tab completely?</p><p> </p><p>

Failing that, in post 13 is an empty version, which worked for someone else who had this issue. Something about different version of excel incompatibilities.</p>

[Dochappy]

The custom rating is indeed an estimate formula which is half what is in Derek B's mod making thread from 2013, this is true for the With Overness, though you have to set the figures yourself (there is a 0.3 and a 0.7 in the Worker Setup folder which adjusts the custom ranting to overness,

 

The Entertainment rating is an estimate formula for the Entertainemnt skill in angles using facts in the player handbook (which I think I left a screenshot of in Worker Setup.

 

Stamina is worked out in 5 levels, empty meaning they struggle with 5 minute matches, one quarter for ten minute matches, half for 16 minute matches,s three wasters for 35ish and full for upto an hour ish... It is based off of some 2010 stamina to minutes a worker can compete data someone collected.

 

could you share the excel formulas for these or how you came up with these? Would like to add them to my spreadsheet.

[TheFlamingred]

could you share the excel formulas for these or how you came up with these? Would like to add them to my spreadsheet.

 

I can tell you the process of how I made each one, but not until Monday as I am currently out of the country. Additionally, there is a format option where you can reveal each and every formula in the sheet so you can see the exact formula for yourself, though I cannot exactly remember where that is in excel.

[Dochappy]

that sounds great because when I open the spreadsheet in calc the formulas aren't there. thanks

[Vamosrafa]

On several tabsit's not showing all the workers contracted to me. Using a real world mod as WWE and workers like Cena, Orton and a few others aren't showing up. I don't know how to change that, I've used the blank version and tried several times but nothing is working...

[Bluetouch]

<p>I don't know if I have the right to up that topic but anyway...</p><p>

I am interested in excel spreadsheets for TEW and this one was the most interesting I found but I have the same problem as Vamosrafa. Some workers don't show up and I tried stuffs but doesn't work. Anyone has a solution please?</p>

[TheFlamingred]

Feel free to send me your excel files so I can have a look to see what the issue is - as I will need more information than what you've both provided.

[Bluetouch]

<p>I didn't touched the Excel File, it is just the same as the one we can download (I tried numerous time by downloading it again just in case) so I don't know if it could be useful, but anyway here's the excel file (with my data) + the MDB file, if that can help. Thanks in advance for trying to help! <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>

<a href="https://www.mediafire.com/?dd7dyaexy3lg77y" rel="external nofollow">https://www.mediafire.com/?dd7dyaexy3lg77y</a></p>

[per93j05]

<p>I'm working on an all-singing all-dancing Excel file, but am after someone who can test it for me to see if my data transfer method works. If you want to help - PM me</p><p> </p><p>

Below is a screenshot pic:</p><p> </p><p>

<a href="http://s1107.photobucket.com/user/xpsuk/media/Excel_zpsyxuu3ulh.jpg.html" rel="external nofollow"><span>http://i1107.photobucket.com/albums/h398/xpsuk/Excel_zpsyxuu3ulh.jpg</span></a></p>

[TheFlamingred]

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Bluetouch" data-cite="Bluetouch" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>I didn't touched the Excel File, it is just the same as the one we can download (I tried numerous time by downloading it again just in case) so I don't know if it could be useful, but anyway here's the excel file (with my data) + the MDB file, if that can help. Thanks in advance for trying to help! <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> <a href="https://www.mediafire.com/?dd7dyaexy3lg77y" rel="external nofollow">https://www.mediafire.com/?dd7dyaexy3lg77y</a></p></div></blockquote><p> </p><p> Okay, the reason you're not seeing all of the stars is because I setup the original excel sheet to only check each workers contracts for the FIRST 100 workers... It seems like this dataset has a total of 132 workers - so those 32 workers are missing from the sheet. As I was only using CVerse, I never had a situations where I had over 100 workers - so never tested the limits. </p><p> </p><p> As a quick fix, in CODE01, you need to drag the final entry in Column E down further to the orange line...</p><p> </p><p> You then need to look at Column H, row 4 and change =SMALL($G$4:$G$103,C4)</p><p> </p><p> to </p><p> </p><p> =SMALL($G$4:$G$<span style="color:#8B0000;">2</span>03,C4)</p><p> </p><p> This makes it look at the new values you dragged down a moment ago. Then drag this cell down to the orange line. </p><p> </p><p> The rest of the sheet should now update to show the 132ish workers.</p><p> </p><p> </p><blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="per93j05" data-cite="per93j05" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>I'm working on an all-singing all-dancing Excel file, but am after someone who can test it for me to see if my data transfer method works. If you want to help - PM me<p> </p><p> Below is a screenshot pic:</p><p> </p><p> <a href="http://s1107.photobucket.com/user/xpsuk/media/Excel_zpsyxuu3ulh.jpg.html" rel="external nofollow"><span>http://i1107.photobucket.com/albums/h398/xpsuk/Excel_zpsyxuu3ulh.jpg</span></a></p></div></blockquote><p> </p><p> If you like, I'll test this with you. I made this spreadsheet for myself and as such, didn't attach any bells and wistles that I didn't feel I needed. I like your addition of adding the storyline, belts and power 500 rankings. You also display things more User Friendly (UI is something I really don't specialise in).</p><p> </p><p> So I feel that maybe your version would be better suited for the average user. So feel free to send it over for me to look at and test.</p>

[per93j05]

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="TheFlamingred" data-cite="TheFlamingred" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div><p> If you like, I'll test this with you. I made this spreadsheet for myself and as such, didn't attach any bells and wistles that I didn't feel I needed. I like your addition of adding the storyline, belts and power 500 rankings. You also display things more User Friendly (UI is something I really don't specialise in).</p><p> </p><p> So I feel that maybe your version would be better suited for the average user. So feel free to send it over for me to look at and test.</p></div></blockquote><p> </p><p> Excellent - I'll PM you</p>

[Bluetouch]

@TheFlamingred: It worked! Thank you very much, that's a big help for my game, awesome work!

[sdaubs]

<p>@TheFlamingred,</p><p> </p><p>

Is there a way to add a column (specifically the Brand that a worker is a part of) to the TEW2016 tab? I've tried a couple of times this past week to add the brand and I keep running into "simple" errors that tell me that I don't understand the spreadsheet as well as I thought I did. Any pointers on how to add a new column or how to add the brand specifically.</p><p> </p><p>

And finally, thank you for this spreadsheet. It has helped a lot in understanding my workers strengths and has helped me enjoy the game even more now that I can push a worker better.</p>

[TheFlamingred]

@TheFlamingred,

 

Is there a way to add a column (specifically the Brand that a worker is a part of) to the TEW2016 tab? I've tried a couple of times this past week to add the brand and I keep running into "simple" errors that tell me that I don't understand the spreadsheet as well as I thought I did. Any pointers on how to add a new column or how to add the brand specifically.

 

And finally, thank you for this spreadsheet. It has helped a lot in understanding my workers strengths and has helped me enjoy the game even more now that I can push a worker better.

in _code02, column AJ you'll find the BRAND>

 

So have a blank column in _WorkerSetup looking at that (e.g., in cell FO4, "=_code02!AJ2" and drag down a signigicant amount)...

 

Then, get the TEW2016 tab to look directly to the _WorkerSetup tab to grab the data for sorting (i.e., _WorkerSetup must never be re-ordered, but you can do various sorts and stuff with the main tab).

 

I think..... i made this year ago and have been modding Motorsport Manager for the past year, I've really not played any TEW.

[sdaubs]

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="TheFlamingred" data-cite="TheFlamingred" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>in _code02, column AJ you'll find the BRAND<p> </p><p> So have a blank column in _WorkerSetup looking at that (e.g., in cell FO4, "=_code02!AJ2" and drag down a significant amount)...</p><p> </p><p> Then, get the TEW2016 tab to look directly to the _WorkerSetup tab to grab the data for sorting (i.e., _WorkerSetup must never be re-ordered, but you can do various sorts and stuff with the main tab).</p><p> </p><p> I think..... i made this year ago and have been modding Motorsport Manager for the past year, I've really not played any TEW.</p></div></blockquote><p> </p><p> Thank you TheFlamingred. That worked as described. I also did exactly what you said not to do and I inserted a column in _WorkerSetup rather than used an already free one.</p><p> </p><p> Thanks again.</p>

[jshipman2]

Is there anyone around that could still answer a question about this?

[Vash1987]

Is there anyone around that could still answer a question about this?

 

I've been tinkering with the files lately, maybe I can help.