TheFlamingred Posted June 28, 2016 Author Share Posted June 28, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="Amante" data-cite="Amante" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>Thank you flamingred, just download your spreadsheet then I modify with my own spreadsheet. <p> </p><p> Just wondering, do you have calculation / assumption about the charisma and star quality bonuses on angle or custom rating? Or another possible bonuses.</p></div></blockquote><p> </p><p> Honestly, I can't remember. I think I want to say No though, as I can't remember off hand how much those bonuses are. </p><p> </p><p> I don't have a column which does an Angle custom rating, so all those stats are raw, other then the actual Entertamint formula, - so that one might have star quality included. </p><p> </p><p> Custom match rating though I think I only used Psycology, basics and max top row stat. </p><p> </p><p> All the formulas I use are just a slight guide anyway to tell me </p><p> a) is this person decent at a match or an angle for where I want them on the card</p><p> b) how over is everyone compared to everyone else (which was the hardest thing to see in the game itself)</p><p> C)checking various information out of game to see if they can fit a role I want.</p><p> </p><p> I don't feel like I need anything more accurate formula wise, i just like to be able to look at my workers and do quick comparisons.</p><p> </p><p> </p><p> </p><p> On another excel sheet, I keep a copy of my cards (which I pre plan there anyway) and with each show, I copy down the results, angle and match scores, and now individual performance scores. This takes a few minutes but let's me see actual worker improvements.</p> Quote Link to comment Share on other sites More sharing options...
woody316 Posted June 29, 2016 Share Posted June 29, 2016 Thanks for uploading this i'm finding it really useful and certainly better than anything that I have come up with. Just a quick question as you said about only using it for small companies and therefore only having the pop for one region present. How do I change which region pop it shows on the TEW16 tab? How would I add a second region/country etc if my company reaches that size? (I don't want to ruin the spreadsheet by adding them in the wrong way) Quote Link to comment Share on other sites More sharing options...
woody316 Posted June 29, 2016 Share Posted June 29, 2016 Also when I refresh the data do I need to create another mdb file and then use the refresh button or will that MDB file just continually update as I play? Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted June 29, 2016 Author Share Posted June 29, 2016 <p>In regard to the refresh:</p><p> </p><p> So long as the save file your using is the same, so long as you Delete the old exported databas, and call your new one The Same thing, when you refresh it will think it's just an updated database and import all the changes.</p><p> </p><p> You only need to do things manually again if you either 1) use a new save file (as that changes the file path) or 2) call the database something different. </p><p> </p><p> Unfortunately, tew2016 doesn't allow you to overwrite an export database, so you must manually delete old ones. (I make a shortcut next to where I keep my excel file to take me right to that folder). Maybe Adam could implement overwriting a database file in a future update if it's requested, I don't know how much work that would involved (as there has to be a check to see if the file is being used elsewhere first).</p><p> </p><p> Your other question is far more intricate. I'll have to be careful how I word it or use diagram or a video, so I will wait till I am not busy to answer it (am just about to grab lunch)</p> Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted June 29, 2016 Author Share Posted June 29, 2016 <p>To change the Home region for overness:</p><p> </p><p> In WorkerSetup, click on Mid South cell, and type '='</p><p> </p><p> Then, find the cell of the region you want to be your home... (It is towards the far right of the spreadsheet - all of them are there), press enter once on the right cell.</p><p> </p><p> If the heading has changed correctly, you can just drag the rest of the column down there, to update all the values. Everything else that uses the hime region overness should auto update...</p><p> </p><p> Beyond that, it becomes a little more complex, as you'd need to begin inserting cells in both WorkerSetup and the main tab, to add more regions to that part of the spreadsheet.</p><p> </p><p> It does already have the USA national average overness on it though. You can later that, but I think that was just an Average formula over all the regions you desire.</p> Quote Link to comment Share on other sites More sharing options...
woody316 Posted June 29, 2016 Share Posted June 29, 2016 <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 regard to the refresh:<p> </p><p> So long as the save file your using is the same, so long as you Delete the old exported databas, and call your new one The Same thing, when you refresh it will think it's just an updated database and import all the changes.</p><p> </p><p> You only need to do things manually again if you either 1) use a new save file (as that changes the file path) or 2) call the database something different. </p><p> </p><p> Unfortunately, tew2016 doesn't allow you to overwrite an export database, so you must manually delete old ones. (I make a shortcut next to where I keep my excel file to take me right to that folder). Maybe Adam could implement overwriting a database file in a future update if it's requested, I don't know how much work that would involved (as there has to be a check to see if the file is being used elsewhere first).</p><p> </p><p> Your other question is far more intricate. I'll have to be careful how I word it or use diagram or a video, so I will wait till I am not busy to answer it (am just about to grab lunch)</p></div></blockquote><p> </p><p> So I am still using the same game save, I just delete the mdb file I exported first time and export another one into the same folder?</p> Quote Link to comment Share on other sites More sharing options...
Alec_Burkhardt Posted June 29, 2016 Share Posted June 29, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="woody316" data-cite="woody316" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>So I am still using the same game save, I just delete the mdb file I exported first time and export another one into the same folder?</div></blockquote><p> </p><p> It will need to have the same filename. TEW defaults to putting a _MonYYYY ending on the created file, so you will either need to make sure you create it using the same name each time or rename it to the correct name after it has been created.</p> Quote Link to comment Share on other sites More sharing options...
emil1116 Posted July 6, 2016 Share Posted July 6, 2016 <p>Step 5?</p><p> </p><p> Huge fan of your work!</p><p> </p><p> Do you know how to make name appear insted of worker name (from contract tab) in TEW 2016 tab?</p><p> </p><p> Having a issue using modsquads past montreal screwjob mod where Kane is called Glen Jacobs and Faarooq is called Ron Simmons ect. </p><p> </p><p> Thanks again for the spreadsheet</p> Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted July 7, 2016 Author Share Posted July 7, 2016 <blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="emil1116" data-cite="emil1116" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>Huge fan of your work!<p> </p><p> Do you know how to make name appear insted of worker name (from contract tab) in TEW 2016 tab?</p><p> </p><p> Having a issue using modsquads past montreal screwjob mod where Kane is called Glen Jacobs and Faarooq is called Ron Simmons ect. </p><p> </p><p> Thanks again for the spreadsheet</p></div></blockquote><p> </p><p> This one is quite easy. In <em>_WorkerSetup,</em> in cell J4... The code is <em>"=_code02!F2"</em> for the everyday worker name. I believe what you are after is just referred to as "Name" so replace that code with <em><strong>"=_code02!H2"</strong></em> and then drag that down about 200 cells and that will auto-update the main tab</p><p> </p><p> (You'll have to drag those columns more if you have more then 200 workers ... I don't play real world mods so don't have the file using over 200).</p><p> </p><p> Thanks for the support <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p> Quote Link to comment Share on other sites More sharing options...
Dochappy Posted July 9, 2016 Share Posted July 9, 2016 is there any way to get this spreadsheet to work with libreOffice Calc? Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted July 10, 2016 Author Share Posted July 10, 2016 <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>is there any way to get this spreadsheet to work with libreOffice Calc?</div></blockquote><p> </p><p> </p><p> I have zero idea. It would need to 1) be able to import dbm files into cells, and 2) have the exact same formulas that excel knows (VLookUp, etc). I don't know if that program does this</p><p> </p><p> (Optional 3/ has conditional formatting to allow it to look similar to my screenshots)</p> Quote Link to comment Share on other sites More sharing options...
Dochappy Posted July 10, 2016 Share Posted July 10, 2016 i see the option to import from xml so I don't think it will work. bummer. lol appreciate all the hard work you put into it Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted July 10, 2016 Author Share Posted July 10, 2016 <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>i see the option to import from xml so I don't think it will work. bummer. lol appreciate all the hard work you put into it</div></blockquote><p> </p><p> Well, if LibreOffice has a database 'app', you Maybe able to convert the access database and then export that somehow. Of course, then you have the problem of redoing any formula that Calc sorts out slightly differently to Excel. </p><p> </p><p> I believe Excel and OneDrive have some sort of online tool for free... I don't know much about how that system works (or if it is only pretending to be free), but that could well be easier to get working then with open office like applications. </p><p> </p><p> <img alt=":)" data-src="//content.invisioncic.com/g322608/emoticons/smile.png.142cfa0a1cd2925c0463c1d00f499df2.png" src="<___base_url___>/applications/core/interface/js/spacer.png" /> and thank you</p> Quote Link to comment Share on other sites More sharing options...
Dochappy Posted July 10, 2016 Share Posted July 10, 2016 libreoffice has a database app called base. I've imported the access database but I'm having trouble creating a query that shows the roster and stats from a certain company Quote Link to comment Share on other sites More sharing options...
Dochappy Posted July 11, 2016 Share Posted July 11, 2016 ok i'm slowly making progress. just wondering though will the changes update in the spreadsheet automatically or do I have to update the fields manually? because right now it's not updating Quote Link to comment Share on other sites More sharing options...
01gognaa Posted July 12, 2016 Share Posted July 12, 2016 I've run into a bit of hiccup. I'm running the Territory Daze 2013 mod, which I converted to 2016. I've created a new save, and selected Vince Sr. as my user profile (not sure if this is relevant). I go into the save's option menu and select "Create MDB file", leave the name as the default and hit create. It runs through the process, but then says "Unspecified Error: Sorry an error has taken place and the file could not be created". Any help?? As always, thanks in advance. Quote Link to comment Share on other sites More sharing options...
mrwhippy Posted July 12, 2016 Share Posted July 12, 2016 <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>ok i'm slowly making progress. just wondering though will the changes update in the spreadsheet automatically or do I have to update the fields manually? because right now it's not updating</div></blockquote><p> </p><p> You have to manually update your MDB file, ie. import it fresh from TEW whenever you want your file updating.</p><p> </p><p> </p><blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="01gognaa" data-cite="01gognaa" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="41603" data-ipsquote-contentclass="forums_Topic"><div>I've run into a bit of hiccup. I'm running the Territory Daze 2013 mod, which I converted to 2016. I've created a new save, and selected Vince Sr. as my user profile (not sure if this is relevant). I go into the save's option menu and select "Create MDB file", leave the name as the default and hit create. It runs through the process, but then says "Unspecified Error: Sorry an error has taken place and the file could not be created". Any help?? As always, thanks in advance.</div></blockquote><p> </p><p> That's an error in the game, not the Excel file. Ask Adam in Tech Support.</p> Quote Link to comment Share on other sites More sharing options...
Dochappy Posted July 13, 2016 Share Posted July 13, 2016 You have to manually update your MDB file, ie. import it fresh from TEW whenever you want your file updating. That's an error in the game, not the Excel file. Ask Adam in Tech Support. oh dang that sucks. I was hoping it would automatically update the stats of my workers. Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted July 13, 2016 Author Share Posted July 13, 2016 <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> Quote Link to comment Share on other sites More sharing options...
mrwhippy Posted July 14, 2016 Share Posted July 14, 2016 Still got no idea why it sometimes bugs out in _code2 on a refresh That's Excel for you. The file is too big and it just can't cope with all the automatic updating. I've even tried re-coding your sheet but to no avail. Quote Link to comment Share on other sites More sharing options...
D16NJD16 Posted August 10, 2016 Share Posted August 10, 2016 Well, it had promise. Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted August 11, 2016 Author Share Posted August 11, 2016 <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> Quote Link to comment Share on other sites More sharing options...
Peter.1986 Posted August 11, 2016 Share Posted August 11, 2016 Is there anyway of putting the database onto excel for editing purposes? I believe this is only for saved games is that correct? Quote Link to comment Share on other sites More sharing options...
TheFlamingred Posted August 11, 2016 Author Share Posted August 11, 2016 <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> Quote Link to comment Share on other sites More sharing options...
Peter.1986 Posted August 11, 2016 Share Posted August 11, 2016 <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>You want to edit the database in excel?<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></div></blockquote><p> </p><p> 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><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> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.