jpuk

Montgomery Sr. isn't in the database as a worker. Should he be? Would be good to know which free pictures have been omitted or maybe amend the default data to take them out

<p><strong>V0.5 is now out - the first post is updated with the download link</strong></p><p> </p><p> This corrects the alignment error kindly pointed out by stevedarake</p><p> </p><p> Couple of other amendments: when updating the data it now sorts your roster from A-Z by name (I've not got round to looking at a full sorting workaround for all columns), I've added a Power 500 Graph added to the Company tab, plus I've added a first draft of a Personal tab.</p><p> </p><p> On the Personal tab I was going to incorporate some Road to Glory type info (starting stats vs. current, yearly stats progression, annual best match; it could also incorporate and generate the random year end roles) so if you have any suggestions just let me know.</p>

I was planning on including a Road To Glory tab on my Ultimate Excel document. What info would you want to see? It could record starting stats vs. current, yearly stats progression, annual best match. It could also incorporate and generate the random year end roles. What would you want? You can see and download the current document version here: http://www.greydogsoftware.com/forum/showthread.php?t=546044

Apologies, the link in the first post should now work

V0.4 is now out - the first post is updated with the download link. This corrects the contract error kindly pointed out by Icebound

Many thanks for your feedback - nope the contract thing is an issue my end with the formula used. I'll get this sorted in the next version (will need to come up with a different calculation method so will take some work). I've just corrected the body issue on my working version. If there's anything else you come across just post it.

V0.3 is now out and the first post is updated with some new screenshots and the download link. This new release included: an expanded Roster tab (added: user notes, storylines, attributes, averages for skills and popularity, and previous Power 500 Ranking), completed Workers tab (allows up to three workers to be compared), and there is a first draft of a Company tab with other elements to be expanded in a later release, and unlocked Blank Tabs 1-5 have been added for user completion. Included in the above is the ability to make notes against your workers which will be carried over when you update the data (as long as that worker is still there). Plans for V0.4 will be resolving the sorting issue and expanding on the company info (e.g. storylines, titles, shows, etc.) I'll be taking a slight rest for a few days now! I'm merely exporting what is in the TEW game and MDB files, so terminology used is more a Grey Dog Software / Adam issue. The document can only be used with Microsoft Excel I'm afraid due to the macro needed to update the data. Yes, sorting automatically is disabled when you lock a spreadsheet (although filtering is still available). There is a macro workaround which I'll try to figure out for V0.4. 1. As above it's planned for a future release. 2. Is now addressed in V0.3 3. Not doable I'm afraid. Many thanks for the feedback received.

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="D-Lyrium" data-cite="D-Lyrium" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="48398" data-ipsquote-contentclass="forums_Topic"><div>One weird thing I noticed; when I renamed the file inside TEW (ie, entered "TEW2020 Ultimate Excel" as the name when creating the .mdb file initially) I had the same issue. However, when I left it as "Savename_Jan2020" and then renamed the file manually outside of TEW, it worked fine.</div></blockquote><p> Thanks for that. I'll add a note to that effect in the next version instructions. Glad to hear it worked fine for you.</p><p> </p><p> V0.3 is coming along. I had to go back and rewrite some formulas to streamline the excel as it was starting to slow down a bit but I seem to of sorted that. The next version will start to allow some user input (rather than just displaying info) so the sheets will be be more useful moving forward. Should be out in a couple of days.</p>

If you've been asked for a password when updating the data it's because you've incorrectly copied the save game database into the 'C:\TEW2020 Ultimate Excel' folder. You need to use the file that is generated in the 'MDBFiles' folder kept within your save game folder. Once you try to run the incorrect MDB it'll corrupt the excel so you'll need to redownload and try again.

Are you using the MDB file that is generated via the save game options screen and saved into a separate MDB folder within your save game folder?

<blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="nerodragomir1" data-cite="nerodragomir1" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="48398" data-ipsquote-contentclass="forums_Topic"><div>Did you watch youtube videos or something?... I bet it was youtube videos!</div></blockquote>Nah I work in finance so it's part and parcel of my job. All self taught though.<p> </p><p> </p><blockquote data-ipsquote="" class="ipsQuote" data-ipsquote-username="jean-vic" data-cite="jean-vic" data-ipsquote-contentapp="forums" data-ipsquote-contenttype="forums" data-ipsquote-contentid="48398" data-ipsquote-contentclass="forums_Topic"><div>Can't see any of your preview images.</div></blockquote> I've added some links to the images in the first post if you can't see them.<p> </p><p> Attributes all added to my work in progress V0.3 version with drop-down to select whether you want to see the hidden ones as well as the visible ones. Will look to finish the Worker tab next...</p>

Thanks for the comments and glad it worked with no problems for you. Any feedback or requests would be appreciated. Can you see if you can open the earlier V0.1 as this doesn't have the update macro http://www.mediafire.com/file/63ooapknh7qu4cr/TEW2020_Ultimate_Excel_V0.1.xlsx/file The problem with V0.1 is that is was reliant on an array formula to keep the roster references updated. This just drains a computer hence why I needed a macro workaround. If the previous version works on LibreOffice then I'll have a think if there's another way to update the rosters for a future release. The principle would, but this Excel is specifically coded for the 2020 generated MDB so I'm afraid not. Your comment gave me an idea - I'll insert some unprotected blank tabs to be completed by the user in the next release. At least people can plans things out whilst I work my way through the rest of the Excel functionality. Decided to see what I can do with attributes today...

<p>V0.2 is now out as per the updated first post and screenshots have been refreshed (all based on Zen but I've tested it with a couple of databases).</p><p> </p><p> Feedback would be greatly received along with confirmation that nobody runs into any problems with the macro. With the macro work around I can now increase the number of roster members from 200 fairly easily so this is no longer a limitation moving forward.</p><p> </p><p> V0.3 will finalise the Worker comparison tab and include a Company tab.</p><p> </p><p> Thanks</p>

<p><strong>Welcome to TEW2020 Ultimate Excel!</strong></p><p><strong> </strong></p><p> This Excel file is made to accompany TEW2020 and aid the management, analysis, planning and booking of your promotion; using the save game generated MDB file.</p><p> </p><p> This Excel file can only be used for single player games. Currently it is set up for a maximum roster size of 200, but this can be expanded depending on feedback.</p><p> </p><p> The document is a work in progress with the version number noted below, so whilst only certain functions are currently working many more are planned. There are lots of things possible and I’ve had some pretty impressive docs for previous TEW’s in the past.</p><p> </p><p> <span style="text-decoration:underline;"><strong>Please carefully read the Instructions for Use on the Excel Guide tab, otherwise it will not work.</strong></span> This includes saving the excel into a newly created folder 'C:\TEW2020 Ultimate Excel'.</p><p> </p><p> Leave feedback in this thread and let me know what you think.</p><p> </p><p> Note, there are some limitations due to the nature of Excel (e.g. not being able to list multiple titles per worker) and these are listed in the document.</p><p> </p><p> Latest screenshots are below:</p><p> <img alt="JjMpQArh.jpg" data-src="https://i.imgur.com/JjMpQArh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="SWHkm4Th.jpg" data-src="https://i.imgur.com/SWHkm4Th.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="LU5FtGkh.jpg" data-src="https://i.imgur.com/LU5FtGkh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="KPIyQ3ah.jpg" data-src="https://i.imgur.com/KPIyQ3ah.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="ZufNwAnh.jpg" data-src="https://i.imgur.com/ZufNwAnh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="INWyIslh.jpg" data-src="https://i.imgur.com/INWyIslh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="a0dYqrbh.jpg" data-src="https://i.imgur.com/a0dYqrbh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="AtnXCJlh.jpg" data-src="https://i.imgur.com/AtnXCJlh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="MlWKrpQh.jpg" data-src="https://i.imgur.com/MlWKrpQh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="4POnALHh.jpg" data-src="https://i.imgur.com/4POnALHh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="i29YgpDh.jpg" data-src="https://i.imgur.com/i29YgpDh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> <img alt="eFWUivZh.jpg" data-src="https://i.imgur.com/eFWUivZh.jpg" src="<___base_url___>/applications/core/interface/js/spacer.png" /></p><p> </p><p> <strong>V0.5 link:</strong></p><p> <a href="http://www.mediafire.com/file/wy7fg7ddgk1bf5x/TEW2020_Ultimate_Excel_V0.5.xlsm/file" rel="external nofollow">http://www.mediafire.com/file/wy7fg7ddgk1bf5x/TEW2020_Ultimate_Excel_V0.5.xlsm/file</a></p>

I think where the world is right now and where it's likely heading, this release could not be better timed and will provide some much needed entertainment and diversion. Having played Adam's games, not obsessively but consistently, all the way back to the EWR games this release could see a revival of the modding scene which has felt as stale as modern day WWE. Not on quality but on variety. The amount of input required for current databases to be detailed and balanced requires massive effort and props to those that continue to release what is out there. But people having a lot of time in their hands in the forthcoming months will hopefully bring more new faces and ideas back to the community (one in which I myself watch but dont really partake). Looking forward to it...