TheFlamingred

I would upgrade this and say ‘it’s pretty certain it’s due to the mod you’re using’.

Still not played the game yet, but did you perform the maintance portion in the instructions tab? That used to be an issue in the past and was fixed with a one cell drag. If its somehting different, we'd probably need your current excel sheet and save file.

<p>I don't have the game yet but glad to see the file is still around and glad its being kept up to date with any new stat and features from the 2020 release <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> Is the update 'bug' still a problem as I think I found a way to add an 'alert' to the user that there was an issue and that the maintence step was needed (to save having to do the drag down each update) but don't think I ever released any updated versions back in the day.</p><p> </p><p> Edit : Also! Farewell TinyPic! (see old thread) You were conveinient back in 2016....</p><p> Edit 2: Shocked Sendspace still exists and the original file never got deleted there as I clog up 6mb of their server for free for 4 years. That implies that at least one person has downloaded the file every 30 days for the past 4 years.... that's pretty cool.</p><p> Edit 3 : Also didnt realise the game hadn't yet released >.< Assumed it was given that the sheet was updated <img alt="" data-src="//content.invisioncic.com/g322608/emoticons/tongue.png.ceb643b2956793497cef30b0e944be28.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p>

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.

Does anyone have any ideas on the gimmick/personality/persona for CV97's Sid Streets and Sean McFly. As two of Swf's top stars, I don't really know these two enough to understand them, and thus, how I feel like booking them.

<p>Still loving this mod. I've decided to, for the first time ever, to try SWF for a serious lengthy game.</p><p> </p><p> As I aphave always in the past created my own promotions from nothing building up, I have decided to see what the other end of the game looks like (since first playing Tew 2005) as it's rare for me to take my generated company much beyond cult (as the grind from regional to cult seems to take forever, I end upnlosing steam once I hit it). </p><p> </p><p> What I really like, which I never realised before, was the starting storylines, which involved everyone. As I've always found that when starting a non-company is harder as I don't really understand the story of all the current workers. In a way, I kinda wish they had more storyline history built into the game, so you can see much more of the oath they have taken to get to where I pick them up in 1997 (though I know realistically that's far too much work).</p><p> </p><p> I thought about trying to recreate some Cverse SWF history with this save, so does anyone know if there exists any Canon-ish fuels and storylines which happens in the SWF between 1997 and 2005 (beyond the starting feuds)?</p><p> </p><p> I have the total liniage to go by, and I have the knowledge of some workers (I am looking forward to Lobster Warrior assuming he develops well) and know that the world won't parallel like the actual CVerse, but it would be awesome to have some canon crossover. Anyone know of any resources I can look at?</p>

<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>

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.

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.

<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>

<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>

<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>

<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>Is there anyway of putting the database onto excel for editing purposes? I believe this is only for saved games is that correct?</div></blockquote><p> </p><p> You want to edit the database in excel?</p><p> </p><p> no, I don't think you can. Even if you import your save game database (as opposed to the export database whichever is just a redundant snapshot if your database), you can't export the table back to access - without copy and pasting the same tables back in (by which time, you may as well just edit the database direct). </p><p> </p><p> It's not really advised though, and the in game editor exists as a safe way to do this anyway. It's a bit like hacking a save file for zoo tycoon that already has a money cheat built in.</p>

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="D16NJD16" data-cite="D16NJD16" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>Well, it had promise.</div></blockquote><p> </p><p> .? Didn't it work?</p>

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Dochappy" data-cite="Dochappy" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>oh dang that sucks. I was hoping it would automatically update the stats of my workers.</div></blockquote><p> </p><p> Yeah, I can feel your pain if you're doing all those conversions. I've tried to make it be updatable with as few as steps as possible given the system we have. </p><p> </p><p> There is only one way to make it more automatic, and that is the system I used for Tew2013 where I extracted data right out of the password protected database file. That is persistent so all the fields in my old excel file are updated with every save and refresh. The issue with this, is that you have to close Excel to sever the connection between Excel and That spdatabase, otherwise TEW wouldn't save as the database is considered in use. I had to collected about six tabs worth of data to get what the exported ones do in two tabs, so it was a lot of work (and means that making the tew2016 one for extracted databases quite quick...</p><p> </p><p> Still got no idea why it sometimes bugs out in _code2 on a refresh</p>