TheFlamingred Posted May 13, 2016 Share Posted May 13, 2016 Hi You said you would upload your excel file and run a tutorial if asked? I would really appreciate that if possible! I've had my own spreadsheets for years but nothing to this extent Thanks I forgot to do this, sorry MrWhippy, I can't even remember which thread we discussed this in, so I'll add it here. https://www.sendspace.com/file/8v7z9m http://i66.tinypic.com/2ltre4l.jpg Well, in Excel, Data you can import a table from a database. I find Workers and Contracts enough for all the data I want. All you have to do is find your FedID by manually looking though the table for your user character. 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. Then adjust the outcome to remove errors, etc and you're left with whats in the above pic. 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. 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. 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. I have added a GUIDE tab in the spreadsheet. So it should be easier to setup. I use Microsoft Office 2013, so items may appear differently in different versions. If you can solve the bug problem I have, do let me know. It saves me spending a few hours one day working it out. I'll update the file with it once I figure it out. Quote Link to comment Share on other sites More sharing options...
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.