[Spreadsheet] THT - Torn Helper Tool - Page 22 | Tools & Users…
[Spreadsheet] THT - Torn Helper Tool
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:30:45 - 16/05/22 (2 months ago)
    Post link copied to clipboard Copy post link

    jtower [2287159]

    There's an issue with the perks API, which is causing some wrong data, especially in the Travel, Money, Nerve sheets. It'll be back working once they fix the bug
    It should be ok now, but let me know if anyone has still issues
    • Mavri [2402357]
    • Role: Civilian
    • Level: 75
    • Posts: 267
    • Karma: 399
    • Last Action: 8 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:17:14 - 22/05/22 (2 months ago)
    Post link copied to clipboard Copy post link
    Really neat spreadsheet :D

    Mavri
    Torn Stats Central

    • Aelius [2029248]
    • Role: Civilian
    • Level: 96
    • Posts: 190
    • Karma: 239
    • Last Action: 43 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:49:49 - 30/05/22 (2 months ago)
    Post link copied to clipboard Copy post link
    How can I see where a cell is getting its value from when there's no formula specified? Consider, for example, column E on the companies sheet: the special money value. It says an Adult Novelties job provides $1,803,627. This is obviously half the value of an eDVD, because you can get it once every two days. Makes sense. But what about Farm? How is the value of $317,494 calculated? I assume it's based on energy can value, but which energy can(s)? In both cases, the cell isn't a formula - it's a number. Where can I see the formula that decides what to populate these fields with?

    Another example is column M in the StockList sheet. How is McSmoogle's value calculated? We don't get to see that. What about Evil Ducks Candy Corp value? Or HRG? etc.

    It's important to know this information in case we disagree with how to calculate it.
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:55:03 - 30/05/22 (2 months ago)
    Post link copied to clipboard Copy post link

    Aelius [2029248]

    How can I see where a cell is getting its value from when there's no formula specified? Consider, for example, column E on the companies sheet: the special money value. It says an Adult Novelties job provides $1,803,627. This is obviously half the value of an eDVD, because you can get it once every two days. Makes sense. But what about Farm? How is the value of $317,494 calculated? I assume it's based on energy can value, but which energy can(s)? In both cases, the cell isn't a formula - it's a number. Where can I see the formula that decides what to populate these fields with?

    Another example is column M in the StockList sheet. How is McSmoogle's value calculated? We don't get to see that. What about Evil Ducks Candy Corp value? Or HRG? etc.

    It's important to know this information in case we disagree with how to calculate it.
    Hey!

    Those sheets are imported to let me update them easily when Torn change things.

    Column M of the stock list sheet represents the payout value. For stocks that provide items, it's just their market values (updated every minute); for stocks that provide more than 1 item, it's their market value average; for stocks that provide energy/happiness, it's calculated using an average of cans/candies.

    Column E of the companies sheet is a little bit more complicated, because it depends on the user activities, but in general it follows the above approach.

    If you have a better suggestion, you can write it here and i'll add it to the list of suggestions
    • AvengerRed [2349542]
    • Role: Civilian
    • Level: 50
    • Posts: 215
    • Karma: 38
    • Last Action: 42 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:48:07 - 08/06/22 (2 months ago)
    Post link copied to clipboard Copy post link
    Great sheet! Helped me get a merit done within the first few hours! :)
    • Aelius [2029248]
    • Role: Civilian
    • Level: 96
    • Posts: 190
    • Karma: 239
    • Last Action: 43 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:41:58 - 12/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    I keep getting these emails about once a week. Why? And are these errors of any concern?

    Last edited by Aelius on 07:43:04 - 12/06/22
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:55:41 - 12/06/22 (1 month ago)
    Post link copied to clipboard Copy post link

    Aelius [2029248]

    I keep getting these emails about once a week. Why? And are these errors of any concern?

    It's in the guide, but yeah every now and then you'll get these notifications.
    • H4D35 [1487001]
    • Role: Civilian
    • Level: 55
    • Posts: 1880
    • Karma: 1460
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 12:41:26 - 14/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    11/10 infinitely useful. 

    basically must have if you are at all serious about your game and optimising it even further beyond.

    • No1IrishStig [2648238]
    • Role: Civilian
    • Level: 64
    • Posts: 64
    • Karma: 14
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 03:44:36 - 22/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    Very useful and easy to setup.

    Suggestion: Add % completion to Honors & Medals page so we can filter by nearest to completion
    • Dapper_Tramp [2007373]
    • Role: Civilian
    • Level: 100
    • Posts: 305
    • Karma: 308
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:15:21 - 22/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    Interested. It's a good bump racket you have going on :D
    • Tokig [367758]
    • Role: Civilian
    • Level: 100
    • Posts: 894
    • Karma: 545
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:44:14 - 22/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    I've been using this now for about a month. I've really enjoyed the travel, stock and chain list features. Overall this is an incredibly useful spreadsheet for personal use.

    Networth has mostly stabilized and I've been watching spending habits to learn where I can hopefully make changes and see my networth actually grow. I've slowly been adding notes and goals to some sheets (yep - you have to be careful with where you do this so you don't mess things up!) in terms of what stock blocks I want to work towards next etc.

    Thank you for such a wonderful tool!
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 19:30:24 - 22/06/22 (1 month ago)
    Post link copied to clipboard Copy post link

    No1IrishStig [2648238]

    Very useful and easy to setup.

    Suggestion: Add % completion to Honors & Medals page so we can filter by nearest to completion
    Suggestion added to the first post
    • Redxjak [2255595]
    • Role: Civilian
    • Level: 84
    • Posts: 1506
    • Karma: 1521
    • Last Action: 7 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 10:50:51 - 27/06/22 (1 month ago)
    Post link copied to clipboard Copy post link
    Would it be possible to expand the "stockTradingThisMonth" she to encompass a year? Or even the whole history since having the spreadsheet?
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:55:36 - 28/06/22 (1 month ago)
    Post link copied to clipboard Copy post link

    Redxjak [2255595]

    Would it be possible to expand the "stockTradingThisMonth" she to encompass a year? Or even the whole history since having the spreadsheet?
    It could be possible, but it'll require more resources. Is the StockTrading sheet not enough? There, you have a summary of all your stock transactions. But let me know if you have specific reasons.

    One thing you could do, is copying the transactions to a new sheet (tab) you create. But of course, that would be a manual process
    • Redxjak [2255595]
    • Role: Civilian
    • Level: 84
    • Posts: 1506
    • Karma: 1521
    • Last Action: 7 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 07:55:40 - 29/06/22 (1 month ago)
    Post link copied to clipboard Copy post link

    Redxjak [2255595]

    Would it be possible to expand the "stockTradingThisMonth" she to encompass a year? Or even the whole history since having the spreadsheet?

    jtower [2287159]

    It could be possible, but it'll require more resources. Is the StockTrading sheet not enough? There, you have a summary of all your stock transactions. But let me know if you have specific reasons.

    One thing you could do, is copying the transactions to a new sheet (tab) you create. But of course, that would be a manual process
    Would you be willing to add a difference if kept tab to it?
    Last edited by Redxjak on 07:55:47 - 29/06/22
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 12:49:40 - 01/07/22 (1 month ago)
    Post link copied to clipboard Copy post link

    Redxjak [2255595]

    Would it be possible to expand the "stockTradingThisMonth" she to encompass a year? Or even the whole history since having the spreadsheet?

    jtower [2287159]

    It could be possible, but it'll require more resources. Is the StockTrading sheet not enough? There, you have a summary of all your stock transactions. But let me know if you have specific reasons.

    One thing you could do, is copying the transactions to a new sheet (tab) you create. But of course, that would be a manual process

    Redxjak [2255595]

    Would you be willing to add a difference if kept tab to it?
    What do you mean by "add a difference"? Send me a PM so we can discuss the details
    • OmenBinAbdul [2520147]
    • Role: Civilian
    • Level: 80
    • Posts: 463
    • Karma: 287
    • Last Action: 11 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:04:02 - 04/07/22 (1 month ago)
    Post link copied to clipboard Copy post link
    very good spreadsheet. thank you :)
    • jtower [2287159]
    • Role: Civilian
    • Level: 61
    • Posts: 698
    • Karma: 1024
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:04:57 - 08/07/22 (1 month ago)
    Post link copied to clipboard Copy post link
    THT has stopped working as of today. I opened a bug for an issue with Torn API. Once they reply/fix the issue, I'll post an update here as well
    • coconut03 [2236969]
    • Role: Civilian
    • Level: 93
    • Posts: 27
    • Karma: 8
    • Last Action: 55 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:03:42 - 11/07/22 (1 month ago)
    Post link copied to clipboard Copy post link
    Amazing worksheet for tracking almost everything in torn. Beautiful work Jtower!
    • theharks [2702970]
    • Role: Civilian
    • Level: 29
    • Posts: 28
    • Karma: 11
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:27:48 - 23/07/22 (19 days ago)
    Post link copied to clipboard Copy post link
    Been using it for a long while - its worth the price !
Reply
Thread Title: