[Spreadsheet] THT - Torn Helper Tool | Tools & Userscripts | T…
[Spreadsheet] THT - Torn Helper Tool
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 2
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 21:45:46 - 30/07/20 (2 years ago)
    |
    Last replied 15:50:30 - 11/08/22 (14 hours ago)
    Hi!

    It's now available THT, the biggest Torn spreadsheet that will simplify your game experience, increase your daily profits, help you obtain honors easily, let you check your weekly and monthly stats gain, maximize your respect during chains, and more... Everything in one place!

    You don't need excel skills at all and I'd provide a detailed guide. It works on mobile and computer.

    Here are some screenshots and features with my data, but obviously once you put your API key, it will show your info. Your data will be visible only to you.

    Travel 2


    Here you'll find the list of destinations, with the time of flight, based on your airstrip/WLT/Business Class Ticket. This info is then used to calculate your daily income and your suggestions for your next trip in the "Travel" sheet.
    The API will populate your destinations and it will keep count of all your trips in the last 7 days. It will calculate your potential gain for each day, and the weekly average.




    Travel


    Travel sheet uses APIs to calculate the current market values and lowest bazaar price of all items abroad, their availabilities, and it will give you suggestions about your next trip, based on the best profit, your next OC (Organized Crime), bank time left, education time left, cool-downs, and some custom timers. In this way you don't have to check all this stuff before flying, you just depart for your suggested destination!
    It will also tell you the minimum money to bring for each destination. This will help you maximize your flight gains. With just this, I've increased my flight gains by 45 mil per month




    Money


    Money just tells you where your money are and what's your average daily income (based on flights, stocks, crimes, company wage, bank) and your average daily expenses (rent, DP, Xanax, rehab). Both lists are editable and you can add your own income/expenses or remove the default ones. Most of them use formulas and APIs to get your actual gains and losses




    StockList
    (updated with Stocks 3.0)







    StockList is a list of all the stocks in Torn, sorted by yield (%) and thanks to the APIs it will tell you the current weekly gain for all BBs, current price, increment info.





    You can also set notifications when a specific stock reaches a price you set.



    StockPortfolio
    (updated with Stocks 3.0)





    StockPortfolio contains the stocks you currently have, with gain (or loss) for each transaction




    Stock Trades
    (updated with Stocks 3.0)



    New Stock Trades sheet, with the list of all the stock trades made during the current month, with their price sold, price bought, profit, current price





    Stock Trading Summary
    (updated with Stocks 3.0)



    New Stock Trading Summary sheet, with the data of your tradings for each month.
    On the top, there's a summary and 2 types of averages: an AVG for all the previous months and an AVG of the last X months (you can change X to any number)






    Honors


    Honors is a list of all the honors in Torn. Here you can keep track of each of them, with a count for each specific honor. (example: for Use 50 Speed, the current count is 22). There are also explanations for the tricky ones, with link to the forums when needed

    Since i've started using this, I was able to obtain 30 honors in 1 month






    Medals






    Daily, Weekly, Monthly stats





    Stats will tell you your current Battle Stats, Working Stats, Xanax consumption, and Rehab fees, with your daily, weekly, monthly gain/usage, and with week, month, year predictions





    Time to reach specific goals you set, based on your avg monthly gain or avg weekly gain





    HOF with rank differences from the previous month (https://www.torn.com/halloffame.php)





    MyCompany













    MyCompany sheet, with info about the company, available positions, stat gains, wage, company bonus, and your effectiveness (Working Stats bonus, Settled In bonus, Director Education bonus, Addiction malus).

    Also, if you're the company director, you'll find: stock info and availabilities, employee applications with their working stats (you can check them even if you're flying), complete employee list with their wages, working stats, effectiveness (Working Stats bonus, Settled In bonus, Director Education bonus, Addiction malus), last actions, and last date you trained your employees (the oldest one is in green; X are for new employees with no trainings received)

    You'll also receive an email once a day if there are inactive employees and when you "on order" stock gets delivered.





    Companies




    The Companies sheet contains a list of company specials and an estimated value you can get from them. This is then automatically reported in your daily income (money sheet)





    Company Stalker


    This is super useful if you're trying to join a specific company type (e.g. Grocery or Lingerie 10*).
    Choose the company type (e.g. Lingerie) and the ratings (e.g. 9* and 10*) and THT will show the companies in that range. You'll also receive an email notification when there is an available position or if there is at least 1 inactive employee, in one of those companies.






    Revives
    It will show the list of your last 1,000 (active and passive) revives, and 4 stats table that will show the number of revives by reviver, target, reviver's faction, and target's faction.

    Obviously, if you're a reviver, you'll look at target and target's faction; if you are NOT a reviver, you'll look at reviver and reviver's faction (I'm not a reviver, as you can see by these screenshots )









    Wheels Tracker


    Do you play Wheels at the casino? Here you can keep track of your spins and check if it's worth it for you to continue spinning
    Note: the values of the items update continuously with the current values. This means you can't use this tool to calculate (exactly) how much you made in the past, but it's rather a tool to understand how much you will make if you continue playing





    Gym Info + Nice merit calculator





    Bars + Personal Stats


    Bars and Personal Stats




    Weapons


    Suggestions for the weapons to use for each finishing hit merit (with cost and current hits).



    Chain List









    Chain List is a list of user IDs you add (that you can get from the latest attack list you made - there's another tab for that) and it will keep track of their status, life, bounty, last action, battle stats, drugs used, flat respect gained. You can also add some notes. ChainList also contains the ELIMINATION team name of your targets (and if they have or leave a team). So you know who you want to hit first. You can also set notifications for specific target when they are out of hospital



    Nerve


    Nerve, keeps track of your Natural Nerve Bar, with some suggestions to improve it.




    Inventory



    Inventory sheet (accessible at any moment), with filter of "sellable" items. The value of "sellable items" is then used in the money sheet, to calculate how much "cash" you have






    Bazaar


    Bazaar sheet (accessible at any moment)






    Education List




    Here you can find all the edu courses in Torn, with the outcome, duration, costs.
    It automatically marks the classes you've already completed and the one you're currently doing.


    ----



    If you prefer browsing the spreadsheet instead of looking at screenshots, here is a sample file: this is just an example, with fake data and no formulas. The data in this file won't change, but in the real file it will update every minute with the data coming from the API: view test file (it does not have the latest updates - last update of this test file is Oct 2020)



    If you're interested in this spreadsheet (price is 89 mil), just write here and contact me via PM.

    Do you want to provide this spreadsheet to your faction members? Send me a PM and we'll work it out!

    Do you want to buy it for a low-net-worth player? Contact me and I'll match your gift!

    If you have questions about some specific features, just write here :)





    EDITED -

    I received some feedback from some of you guys, to add:

    - cool-downs (done)
    - stats predictions (done)
    - weapon exp (done)
    - company info (done)
    - events (done)
    - HOF (done)
    - HOF changes from previous month (done)
    - Gym gains (done)
    - Events: store latest 1000 (done)
    - Plushies/Flowers availability abroad (done)
    - Elimination team in chain list (done)
    - Daily notification if investment forecast becomes negative (done)
    - Turn on/off specific email notifications (done)
    - Drugs abroad (done)
    - Stock payouts historical tracker (done)
    - Ignore Energy/Nerve lose for longer flights (done)
    - Rehab fees track (done)
    - Wheels track (done)
    - company detailed info for directors (done)
    - Date last training employee (done)
    - Item list and bazaar list (done)
    - Stock trading history (done)
    - Education tracker (done)
    - Time to reach specific stats, based on the daily/weekly/monthly avg (done)
    - Use types in filter of Inventory sheet (done)
    - Number of flights per destination (done)
    - Revive list (done)
    - Split Stocks "All Stocks" and "MyStocks" (+ Add filters + remaining money left to get a stock BB) (done)
    - Stats sheet (add drugs, net-worth, offences, revives, travels, attacks, defends, busts, respect) (done)
    - Wheels tracker with Logs API (done)
    - Add Lingerie 10* benefits to Destination sheet (done)
    - Add other items to the BestPrices sheet, other than plushies, flowers, and drugs (done)
    - StockPortfolio % gain/loss (done)
    - Notification for specific stock threshold (greater than and less than) (done)
    - Company list from API & Track company income based on company star level (done)
    - Company Stalker update: daily customer, weekly customer, and company age (done)
    - Notification for company directors when the on-order stock get delivered (done)
    - Add medals (done)
    - Add faction and okay notifications in chain list sheet (done)
    - Stock Payouts history (done)
    - Turn off the emails that someone in my own company is inactive (done)
    - Inactive employee notification at 17.30 TCT (done)
    - Lowest stock prices (done)
    - Add energy drinks and Stat enhancers to the Chain List sheet (done)


    Future functionalities, to be implemented:
    - Nerve sheet configurable (will wait for crimes 2.0)
    - City Finds tracker (logs api)
    - Christmas Town tracker
    - Property calculator
    - Job point estimate
    - Items buy and sell report
    - 60 days of stock prices (4/day)
    - Add profit % column to the StockTradingThisMonth sheet
    - Add point listing
    - Add % completion to Honors & Medals page

    Currently working on:
    - Weekly/Monthly Income Avg for company directors
    - Add energy drinks and Stat enhancers to the Stats tracker (and its cost to the money sheet)


    If you have some ideas or if you have specific requests or functionalities that you want to add, just write here, adding all the details, and I'll add them to the list
    Last edited by jtower on 16:06:15 - 02/08/22
    • XLDadbod [2137519]
    • Role: Civilian
    • Level: 99
    • Posts: 705
    • Karma: 1125
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 22:58:29 - 30/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    I've been drinking but from what I skimmed this is pretty interesting. R,+

    • AIex [2384974]
    • Role: Civilian
    • Level: 91
    • Posts: 55
    • Karma: 65
    • Last Action: 4 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:33:17 - 30/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Looks neat!
    • Phillip_J_Fry [2184575]
    • Role: Civilian
    • Level: 50
    • Posts: 257
    • Karma: 123
    • Last Action: 12 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:30:30 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Put me on the waiting list
    • MuRiCa [2144163]
    • Role: Civilian
    • Level: 85
    • Posts: 96
    • Karma: 80
    • Last Action: 10 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:32:57 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    interested in maximizing my torn gains
    • Risengarde [2584072]
    • Role: Civilian
    • Level: 60
    • Posts: 98
    • Karma: 15
    • Last Action: 10 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:13:33 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    sign me up

    • Alascato [2323855]
    • Role: Civilian
    • Level: 71
    • Posts: 2706
    • Karma: 1440
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 10:06:05 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Dang. Sounds interesting. Im totally in

     Hi there if  you wanna trade with me,                  CLICK HERE

    • Zasty [2131289]
    • Role: Civilian
    • Level: 57
    • Posts: 1278
    • Karma: 769
    • Last Action: 4 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:30:49 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Looks good, sign me up 
    • Kidlion [2497660]
    • Role: Civilian
    • Level: 60
    • Posts: 50
    • Karma: 15
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:57:01 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Yea id love to check this out and see more of it when ready
    • snowbeast [2173158]
    • Role: Committee
    • Level: 85
    • Posts: 1172
    • Karma: 1747
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:20:51 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    R+ 

    Interested
    • RobberHood [2361494]
    • Role: Civilian
    • Level: 94
    • Posts: 2755
    • Karma: 5212
    • Last Action: 43 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:09:08 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Interested
    • 1ooo [2273492]
    • Role: Civilian
    • Level: 94
    • Posts: 382
    • Karma: 245
    • Last Action: 4 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:27:39 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Looks good, interested!
    • Frank [2408592]
    • Role: Civilian
    • Level: 65
    • Posts: 1562
    • Karma: 4112
    • Last Action: 6 months
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:08:43 - 31/07/20 (2 years ago)
    Post link copied to clipboard Copy post link
    I am interested. 
    • Signa [2371319]
    • Role: Civilian
    • Level: 40
    • Posts: 32
    • Karma: 1
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:12:15 - 01/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    I’m very interested!
    • PBT [2443331]
    • Role: Civilian
    • Level: 60
    • Posts: 38
    • Karma: 40
    • Last Action: 2 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:04:14 - 02/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    I am interested

    RIP RAX: Love you

    5c28cbbd-be81-cf74-2325477.png

    • BigDrillaFTF [2544165]
    • Role: Civilian
    • Level: 50
    • Posts: 13
    • Karma: 2
    • Last Action: 1 month
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:36:36 - 02/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    interested
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 12:28:05 - 04/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Bump
    • FawkedUp [2124236]
    • Role: Civilian
    • Level: 75
    • Posts: 39
    • Karma: 24
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 03:23:00 - 05/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Interested
    • Thedeecee [2283601]
    • Role: Civilian
    • Level: 49
    • Posts: 17
    • Karma: 26
    • Last Action: 7 months
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 12:05:45 - 05/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    Interested
    • Hamma [2512109]
    • Role: Civilian
    • Level: 91
    • Posts: 175
    • Karma: 138
    • Last Action: 14 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:34:37 - 06/08/20 (2 years ago)
    Post link copied to clipboard Copy post link
    This spreadsheet is so sexy 

    Sign me up :)

Reply
Thread Title: