Skip to content
TORNLIFE More

Spreadsheets for Torn

Started by Brekker [2492692] on in General Discussion.

21 replies · 726 views · thread synced · 3 days ago · View on torn.com
About this thread

Posts archived: 22 / 22 posts (100%) · the total is Torn's reply count + the opening post at the last fetch

Counted by TornLife from the archived posts.

Archived posts
22
Discussion span
→
Authority score
56 / 100
Historical score
24 / 100
Story score
57 / 100
Engagement score
68 / 100

People posting, likes and official posts are not counted for this thread yet: on threads longer than one page they come from a periodic pass over the archive, which has not covered it.

Most-liked replies

Brekker [2492692]
I want to know what kinds of spreadsheets people are using to enhance their torn gameplay. I've got one for my stats, one for keeping track of how much money in plushies and flowers I've got and one for keeping track of my daily wheel spins. What about you?
KPCSlor [1557404]
Chain hits over time tracker

My best Torn spreadsheet is for tracking chain hits. After every scheduled chain I export to it's own sheet. Then put them all into one and make a pivot table with a row for each member to see how they did across all the chains.

I know that the API and site like Yata pull market prices, but occasionally I'll dust off my old trading spreadsheet. I don't trade much, but when I do I like to have full control over how the numbers are collected.
PuddleofDucks [2120940]
I built myself a plushie tracker for fun. keeps track of what i own, how many points they will turn into, which plushie i need to get next and the $ value of the points they will provide. and a bunch of random stuff, like flight times and cost of a full load, profits.

Also have sheet for tracking my BB's and the benefits i gain, and subtracts their value from my total investment.

I have an accounts sheet, for keeping track of $ in my shared vault, caymans, faction, and the bank investments which will log the interest i make.

lastly I had created a sheet to keep track of those who had purchased raffle tickets for the dp raffle i held.
_Pam_ [2235735]
"Also have sheet for tracking my BB's and the benefits i gain, and subtracts their value from my total investment."

How do you do this? i am trying the same thing, but there are no api for individual payout nor show in personal stats. i saved the bb events, but no api for saved events too.
PuddleofDucks [2120940]
I setup the sheet with drop downs. each block has a small number of possible payouts, each listed item has an assigned value and i made it just tally everything up

I am a very novice spreadsheet enthusiast. I only recently figured out how to screw around with api stuff, none of my sheets incorporate any api functionality atm. this may make them not 100% accurate but it is close enough to see trends and i am happy with it atm
sopwithcamel74 [2199693]
Pretty comprehensive member tracking, including (but not limited to) chain performance, wall sitting results, NNB, and a few faction-confidential metrics.
Father [2131687]
I got shit tons of Spreadsheets. One for my personal revives(got last 12k revives in it), Faction Special Simulator(I know there are tools like Yata and TornStats for it, but it is more fun), Faction Armory Watch, Faction Organised Crimes (put as monthwise and with all relevant details), a Spreadsheet that I call HOMIE, short for how much I earned to track my sales, cash and items received. A Spreadsheet for Vault Tracking, Cash/Items sent and many many more.
Prezze [2121612]
1) training stats to know how far I can go to keep my ratio's correct
2) racing one : i keep track of tests on the same track with different car, aswell as amount of laps + track before my rs goes up with 0.1
3) cityfind & wheels: keep track of all my finds and wheelspins in there
4) museum exchanges : i keep track of my plushie/flower/artifacts purchases in it, I just paste the buy message in it and it shows me my total stock with average value paid per plushie + total cost of a set, i also keep track of my point selling in it and profits
5) ViN fastests laps: spreadsheet I update with people's fastest laps on each track in the faction, it's a small leaderboard for faction racers, i update it monthly with new ranking. People send me their new fastest laps time
6) stocks/renting/auctions : I mainly only use it anymore to keep up to date with my stockpayouts, so I record date, stock, value of payout/item it paid out, how much i earned back, how much i still have to earn to break even from payouts, how many days on average before a payout, + total value of payouts
7) Torn city bank & missions: only use it half to keep track of my banking investments so that I know older investments, the mission one is a wip main goal is to see how often which type of mission i do get
8) ViN racing Tournaments : all the tournaments i've held in the faction that involve racing
9) Holiday extravaganza 2018 en 2019: end of years giveaway game for the faction, it involves keeping track of who joined up, a spreadsheet they can pick a number on, behind the number is a price that I purchased, but first it shows a message involving the gift they'll receive, once the gifts to everyone have been send i reveal the prizes to everyone with the itemsimage from torn + amount of said item they won.
10) Training : old spreadsheet from when I was an even bigger nooblet, used to estimates stat gains based on your happy and training method (stat gains of Vladar's spreadsheet were used), it also showed you the total cost of training
11) City raid game : contains a little game I made for during chains, I ask people in chat first to say RAID gets a chance to win a prize. First member who responds, I then enter his name in the spreadsheet and run the game, it then rng's a raid initiation on a city district in torn and has 50% chance of succeeding, smaller prizes are given away like this
12) Buying and opening supply packs: contains info about goodie baggs, box of grenades, drugpacks, med supplies. Involves amount paid contents after opening + value after opening, ...
13) Mugging/hitting : list with mugtargets and chain targets
14) ViN Holiday Elimination Fest: racegame I held in the faction between Christmas and New Year
15) ViN Sponsored Racing : another racegame i held in the faction, contains rules, game + results
16) Fast Track ViN Nation: racegame i held in the faction
17) Stock broker game : game i'm working on
Brakier [2095393]
i use scripts, tornstats , yata , discord, some documents where i save some info and ofc torns own graphs to keep check everything
Prezze [2121612]
true but not many have a database program they have access too.

Edit if you know of a free to use database program you can let me know aswell :D

Also when are you free to come do the hedge over here? :D