Travel Profit Calc - Plushies / Flowers / Drugs | Tutorials & …

Forums

Back to Forum
  • Forum Main Main
  • Tutorials & Guides T&G
  • Travel Profit Calc - Plushies / Flowers / Drugs Thread

Travel Profit Calc - Plushies / Flowers / Drugs

​

  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 23:14:16 - 09/01/18 (8 years ago)
    |
    Last replied 21:31:45 - 13/05/19 (7 years ago)

    You want the biggest profit with the least effort?






    Then then Torn Travel Run Calculator will solve your problems!

    You can now calculate your plushie, flower and drug flight profits.

    The upper part of each section is currently only for flowers, here you can simply enter your item capacity and see what is the most profitable for you.

    If you want to buy other items, you can use the drop down menu and enter the destination, the item of your choice and your capacity. At the moment only flowers and plushies are usable but drugs and other items will be usable soon.

    The calculator will show you several stats like:

    - estimated travel time to do an complete travel (flight to the destination and back to torn in sum).
    - base price of the item
    - purchase costs (minus your travel costs if you have no PI with airstrip)
    - retail prices
    - profit of your flight


    IMPORTANT:

    The upper part of the sheet is only for newer players that have no with airstrip with pilot.
    The travel times are different and you still need to pay travel costs wich are factored for you already.

    The lower part is for players that can use the airstrip and pilot.


    Prices can now be updated by everyone!







    Thanks to revis290[1893023] for your great work!

    # Changelog
    All notable changes to this project will be documented here.

    ## [Released]

    ## [1.0.0] - 2018-01-06
    ### Added
    - dropdown menu for own choises

    ### Changed
    - english translation
    - updated prices
    - colors and style
    - time in hours and minutes

    ### Removed
    - profit per hour
    - profit per 24h

    ## Bugs and wishes for next big change
    - add drugs to dropdown menu
    - items and counties are not linked so you need to choose manually


    ## [1.0.1] - 2018-01-06
    ### Added
    - profit per minute


    ## [1.1.0] - 2018-01-09
    ### Changed
    - items und countries are now linked, you can only choose the items that are being sold at the destination
    - drugs are now available but the prices need to be entered
    - time will be shown in hours:minutes (only one direction atm)

    ### Removed
    - unnecessary sheets and formulas

    ## Bugs and wishes for next big change
    - add drug prices
    - usability for multiple players


    ## [2.1.4] - 2018-01-18
    ### Added
    - second page "Flights, Ordered" was added. The most profitable destination by profit per minute will be shown on the top.

    ### Changed
    - items and prices can be updated by everyone, description in the spreadsheet
    - stock values can be updated too, description in the spreadsheet

    ### Removed
    - no need for entering your capacity in evey single cell, just enter it once

    ## Bugs and wishes for next big change
    - "Flights, Ordered" shows a warning if you choose your item by hand on the normal "Flights" pages
    - usability for multiple players


    ## [2.1.5] - 2018-04-21
    ### Changed
    - some prices were pulled wrong, prices should be ok now

    ## Bugs and wishes for next big change
    - "Flights, Ordered" shows a warning if you choose your item by hand on the normal "Flights" pages
    - usability for multiple players


    If you have any ideas, please let me know and I consider how to use them.
    Last edited by LexxiFoxx on 00:21:12 - 21/04/18 (8 years ago)

     

    https://i.imgur.com/HHg6YxT.png

  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:56:13 - 10/01/18 (8 years ago)
    Post link copied to clipboard Copy post link
    New updated Version 1.1.1.

    You can now calculate flowers, plushies and drugs too!

     

    https://i.imgur.com/HHg6YxT.png

  • FAM
    • Foe [2092175]
    • Role: Civilian
    • Level: 100
    • Posts: 1,034
    • Karma: 956
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:31:23 - 11/01/18 (8 years ago)
    Post link copied to clipboard Copy post link
    Interesting, but there is already a Torn Pocket Travel Guide which provides the same info.

    I am having trouble editing the "your capacity" tab at the top to 29 rather than 19. Or is that meant to all be done manually, per item you're running? Would be nice to just change it at the top and have it change all capacities throughout the spreadsheet.

    EDIT: Both your spreadsheet and Pocket Travel Guide are quite useful. Not trying to hate on this at all because it's better than what I could make, but I think the Pocket Travel Guide is a bit more helpful overall. I don't see the need (in my opinion) to have multiple of these spreadsheets floating around when the one we have for community use is very good (also my opinion, feel free to disagree.)

    I think with some tweaks and other info that could maybe set it apart from the one that is currently in place, this could be a useful alternative. But, I'll let others weigh in on what they think as well. R+ for the effort and like I said it's far better than what I could create :) Just giving some constructive criticism :P
    Last edited by Foe on 15:37:13 - 11/01/18 (8 years ago)
  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 22:21:02 - 11/01/18 (8 years ago)
    Post link copied to clipboard Copy post link
    Finally some feedback ;)

    First thank you very much for your honest thoughts about my work.
    Tbh, I did not know about the Pocket Travel Guide until now, thanks for that information.

    Back when I developed the sheet, I did not think about publishing it and some parts are not completely thought out.
    You are right, it would be more effective to just put in your capacity once and it will be used everywhere. The upper parts of the sheet that only contain flowers were my first attempts to get an overview. I totally get your point.
    I'll concider a way to change that.

    No worries, I do not perceive your feedback as hate. It's good to get some feedback from other players that have a different POV.

    As I mentioned in the original post, this is an early developmoent stage that can be improved with feedback like yours. ;)

    I really appreciate your suggestions and contribution to my work!

     

    https://i.imgur.com/HHg6YxT.png

  • FAM
    • Foe [2092175]
    • Role: Civilian
    • Level: 100
    • Posts: 1,034
    • Karma: 956
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:03:58 - 11/01/18 (8 years ago)
    Post link copied to clipboard Copy post link

    LexxiFoxx [2040488]

    Finally some feedback ;) First thank you very much for your honest thoughts about my work. Tbh, I did not know about the Pocket Travel Guide until now, thanks for that information. Back when I developed the sheet, I did not think about publishing it and some parts are not completely thought out. You are right, it would be more effective to just put in your capacity once and it will be used everywhere. The upper parts of the sheet that only contain flowers were my first attempts to get an overview. I totally get your point. I'll concider a way to change that. No worries, I do not perceive your feedback as hate. It's good to get some feedback from other players that have a different POV. As I mentioned in the original post, this is an early developmoent stage that can be improved with feedback like yours. ;) I really appreciate your suggestions and contribution to my work!
    Of course, you're welcome :) I'm always interested to see new helpful ways to calculate profits without doing it the long way, and these spreadsheets definitely work wonders for that!

    Hope you can find some ways to optimize it, and who knows maybe one day it will be widely used across torn!
  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:45:23 - 18/01/18 (8 years ago)
    Post link copied to clipboard Copy post link
    New updated Version 2.1.4. Big major update!!



    ## [2.1.4] - 2018-01-18
    ### Added
    - second page "Flights, Ordered" was added. The most profitable destination by profit per minute will be shown on the top.

    ### Changed
    - items and prices can be updated by everyone, description in the spreadsheet
    - stock values can be updated too, description in the spreadsheet

    ### Removed
    - no need for entering your capacity in evey single cell, just enter it once

    ## Bugs and wishes for next big change
    - "Flights, Ordered" shows a warning if you choose your item by hand on the normal "Flights" pages
    - usability for multiple players
    Last edited by LexxiFoxx on 21:45:58 - 18/01/18 (8 years ago)

     

    https://i.imgur.com/HHg6YxT.png

  • -EX-
    • _Vision [1979106]
    • Role: Civilian
    • Level: 100
    • Posts: 213
    • Karma: 0
    • Last Action: 6 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:46:10 - 27/03/18 (8 years ago)
    Post link copied to clipboard Copy post link
    Thanks for putting in the effort
  • IBB
    • manyakimm [2101947]
    • Role: Civilian
    • Level: 100
    • Posts: 467
    • Karma: 174
    • Last Action: 36 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:56:08 - 27/03/18 (8 years ago)
    Post link copied to clipboard Copy post link
    Thanks for the hard work.

    There are a few things i want to mention;

    I can see flowers but i can't see full list of plushies together? So i can compare them.

    Some retail and base prices seems to be wrong. (Like jaguar base must be 10k, and dahlia retail price must be 4.900)

    Torn's Best Shop

  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 08:31:09 - 03/04/18 (8 years ago)
    Post link copied to clipboard Copy post link

    manyakimm [2101947]

    Thanks for the hard work. There are a few things i want to mention; I can see flowers but i can't see full list of plushies together? So i can compare them. Some retail and base prices seems to be wrong. (Like jaguar base must be 10k, and dahlia retail price must be 4.900)
    Your're welcome. Thank you for your feedback.

    I know that plushies are still missing. Still need to implement them! It will take some time but I'll do that ;)

    Have you updated the sheet like I described it? Maybe that is why the prices were wrong?

     

    https://i.imgur.com/HHg6YxT.png

  •  
    • LexxiFoxx [2040488]
    • Role: Civilian
    • Level: 88
    • Posts: 82
    • Karma: 36
    • Last Action: 2 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:17:29 - 21/04/18 (8 years ago)
    Post link copied to clipboard Copy post link
    New updated Version 2.1.5.



    ## [2.1.5] - 2018-04-21
    ### Changed
    - some prices were pulled wrong, prices should be ok now

    ## Bugs and wishes for next big change
    - "Flights, Ordered" shows a warning if you choose your item by hand on the normal "Flights" pages
    - usability for multiple players

     

    https://i.imgur.com/HHg6YxT.png

  •  
    • jurebaao [1188059]
    • Role: Civilian
    • Level: 80
    • Posts: 75
    • Karma: 13
    • Last Action: 5 years
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:52:05 - 18/02/19 (7 years ago)
    Post link copied to clipboard Copy post link

    Foe [2092175]

    Interesting, but there is already a Torn Pocket Travel Guide which provides the same info. I am having trouble editing the "your capacity" tab at the top to 29 rather than 19. Or is that meant to all be done manually, per item you're running? Would be nice to just change it at the top and have it change all capacities throughout the spreadsheet. EDIT: Both your spreadsheet and Pocket Travel Guide are quite useful. Not trying to hate on this at all because it's better than what I could make, but I think the Pocket Travel Guide is a bit more helpful overall. I don't see the need (in my opinion) to have multiple of these spreadsheets floating around when the one we have for community use is very good (also my opinion, feel free to disagree.) I think with some tweaks and other info that could maybe set it apart from the one that is currently in place, this could be a useful alternative. But, I'll let others weigh in on what they think as well. R+ for the effort and like I said it's far better than what I could create :) Just giving some constructive criticism :P
    there is no torn pocket travel guide anymore.

    Dong, J (2018) "never forget to not touch the yellow snow"

  • BoW
    • Strangeh21 [2280521]
    • Role: Civilian
    • Level: 50
    • Posts: 50
    • Karma: 14
    • Last Action: 44 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:13:35 - 13/05/19 (7 years ago)
    Post link copied to clipboard Copy post link
    Is it just me or do the prices seem really off? How can I manually update the prices?
  • CB
    • Kolov [2257167]
    • Role: Civilian
    • Level: 33
    • Posts: 62
    • Karma: 4
    • Last Action: 1 year
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 21:31:45 - 13/05/19 (7 years ago)
    Post link copied to clipboard Copy post link
    It won’t let m edit it! Says read only

Reply
Thread Title: