No video
TEW Booking Tracker 4 - Setup Guide and Walkthrough
Hello everyone,
This is a video setup guide for the TEW Booking Tracker 4, a sheet I've designed to help you organise your roster, plan your shows and manage your storylines in TEW 2020.
This guide firstly shows you step-by-step how to import the data into the sheet, and then talks you through the various different views that exist within the sheet and how you can use them to get the most out of the sheet.
Please feel free to reach out if you have any questions etc., otherwise enjoy the tool and good luck with your booking!
Link to the tracker: docs.google.com/spreadsheets/d/1iyVnhAq-GfFhFqJaKFwuzF7dWeB45_wxJPzGa1_M9gE/edit?usp=sharing
Apologies for the probably poor quality commentary, it's my first time doing anything like this for KZread!
Пікірлер: 20
Nice work bro, this is fantastic.
I'm playing a read worll mod where the WWF does bulk taping for 6 shows at a time every third Tuesday. Gameplay wise, this is fairly exhausting. Having this as an organizational tool I can use to put the shows on an actual calendar is going to be extremely helpful. That is a big complaint I have about TEW in general; there's no calendar view for your shows. Unless I'm just a dope and haven't found it.
The Contracts table now seems to be in a different order than what your sheet is set for. Column B exports as CompanyName, your sheet is looking for it to be in column T
@iaidanlfc3335
Ай бұрын
Hi Paul, I would suggest trying again with a fresh copy of the tracker. It is impossible for the columns to be out of order if the steps are followed correctly.
This is pretty awesome. I'm kinda out the habit of using spreadsheets now, but might need to make an exception here.
Will there be an Version for Event Based Companys? I'm actually Booking an Shoot Style League without Weeklys, so an Event Tracker would be awesome, maybe also nen Fight-Record Tracker, who fought who, and so on :)?
@iaidanlfc3335
Ай бұрын
Hey mate, you can do and event only company, just use the one-off events scheduler rather than weekly to create all of your shows and it should populate as normal. Re a win/loss tracker, no this is out of scope as it’s too complicated to do in a google sheet. It was in a previous version (formatted very differently) so it’s technically possible but with rje way the sheet is setup now, the formula would be monstrous and require too strict an input from the user if it was implemented that it’d probably cause more hassle than it’s worth. You also always run into issues with multi man / tag matches too. Thanks though!
Alright Mate I followed Everything you said But not Getting the Companys To come Up just got number 1 as a opp
@iaidanlfc3335
Ай бұрын
Hi, I suggest you try again with a fresh copy of the sheet and ensure you’re following the steps correctly. It’s impossible for the columns to be out of order as they come directly from the game in the same format every time.
Maybe I've missed it but how do I update the workers and conctracts csv? Do i delete the sheets entirely and paste it in again or do I just replace everything while having clicked on A1? Is tried to do the second but some workers appeared as duplicates in the "Data Sheet" after...
@iaidanlfc3335
Ай бұрын
Yes blank the old csvs out (Ctrl+A then delete) to avoid duplicates.
hey, real quick but you need to fix the youtube link on the sheet. It links to a deleted version of this video.
@iaidanlfc3335
3 ай бұрын
Thanks mate, all fixed now. I re-recorded this and must’ve never changed the link!!
Another short Question: is it possible to create an much greater Dashboard? For my Shoot League i got really much main eventers, but when i enhance the slots i'll f*ck up the whole compare function :( I'm not good at excel so idk how to fix that
@iaidanlfc3335
Ай бұрын
Hi mate, what is it exactly that you’re asking for here please? Happy to help but not sure what you mean.
You're a legend!
@iaidanlfc3335
3 ай бұрын
Thanks!
Really amazing, incredible work! Just a little note (easily fixed by user) is that you forgot to include Canada as a home region on the Initial Set-up tab
@iaidanlfc3335
3 ай бұрын
Thanks mate, and good spot! All fixed now
thanks!