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, and more... Everything in one place!

You don't need excel skills at all and I'll 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.
You'll be the only owner of your spreadsheet: your data and API key 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, pi rent, city finds, mugs, bounties, etc...) and your average daily expenses (rent, DP, Xanax, rehab, pi rent, etc...). 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)

Market

It's a combination of 5 tables:
- Top left, cans vs FHC vs xanax price/energy, it also calculates your faction specials automatically

- Top right, worth opening packs and boxes of supplies (updated every 5 minutes)

- Middle left, suggestion about renting or buying a PI.
If you don't have bank investments or all the stocks with high return on investments, this is what you'd see:


If you have all the best stocks, it'd suggest to buy it instead.

- Bottom right, most profitable items to buy from the city shops (updated every 5 mind)

- Bottom left, item price scanner (you put in item name or item ID and it'll give you an avg of lowest bazaar price and market value - market value updated every minute, bazaar price updated every 10 minutes)





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 can also decide to receive an email notification when there is an available position or if there is at least 1 inactive employee, in one of those companies.

City Finds

The values are added to the money sheet, so you know how much you gain per day

Properties

Here you can find your properties and rentals. Your income or expenses are added to the Money sheet, so you know how much you gain/pay per day. Plus, a notification will be sent when there are 3, 2, 1 days left on your rent

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 see 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).

Nerve

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

Inventory (temp removed, see this post)

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, while your file 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)

PRICE 89m

If you're interested in this spreadsheet and when you're ready, you can just send the payment, including your google email address in the comment of the payment. I'll prepare the file and send it when ready - usually within minutes if i'm online or the day after if it's night time for me.

Are you the leader (or co) and do you want to provide this spreadsheet to your faction members at a discounted price? Send me a PM and we'll work it out!

Do you want to gift it to a low-net-worth player? Contact me and I'll match your gift to another random player!
Or if your NW < 10b, you can join our THT Raffle!

What's included when you buy it?

• Full ownership of your file
• Setup instructions
• Fully customizable options and notifications
• Detailed guide, with explanation of each sheet
• Main shared script: free bug fixes, free updates, free new features
• Local script: free bug fixes. Updates and new features are available on demand (cost depends on type of changes/features)

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)
- 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, energy drinks, Stat enhancers) (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)
- 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 attack log link to the attacks sheet (done)
- Add to the Stats tracker (done)
- City Finds tracker (logs api) (done)
- Nerve sheet configurable (logs api) (done)
- Property manager and rental notification (done)
- Refresh all company info for CompanyStalker (done)
- Market value scanner (done)

- Notifications for ended cooldowns and energy/nerve full (done)

Future functionalities, to be implemented:
- 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

- Use real item sales to calculate the travel profit avg

- Keep track of number of trainings given, for each employee

- Notification for item market value

Currently working on:
- 60 days of stock prices (4/day)


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



RELEASE NOTES (2 parts: main script and local file)

MAIN SCRIPT (automatically available/updated - here listing only the updates of the past 12 months)
v10.3.00 (Apr 2024)
Block fetch requests if API key is wrong, empty, or inactive (requires local file v4.00 or higher)

v10.3.01 (Apr 2024)
Fix bug number type for crimes, cityFinds

v10.3.02 (Apr 2024)
Fill equipped items in the Inventory sheet

v11.00.01 (May 2024)
Logging on donator days left errors

v11.00.02 (May 2024)
Clear existing content in the file, only if there are available data from Torn's API

Little note here:
So far 3 people disliked this thread (Cosmic [2090451], Rich [900727], cr4his [2384643]). They did it by mistake with a touchscreen, nothing to do with the spreadsheet. Sadly, after some hours you cannot remove your "dislike"