Winged_Cougar [1993598]

[b]Make your own Travel Running Spreadsheet:[/b] I've added example values to this spreadsheet. Note the color coded "profit/day" column. Dark green represents the best current profit for time spent on the given trip if you could do only that trip all day for an entire day. Remember to update the prices from the market before you use this to determine best travel destinations. Use [url=https://travelrun.torncentral.com]https://travelrun.torncentral.com[/url] to determine where stuff is in stock vs not(or better yet, Mauk's [url=https://chrome.google.com/webstore/detail/doctorn-for-torn/kfdghhdnlfeencnfpbpddbceglaamobk]DocTorn Browser Extension[/url] or the associated [url=https://doctorn.mrkishi.com/travel-hub]TravelHub Website[/url], which is both more reliable, and updated more often). [b]It can be *yours*:[/b] You can right click on the tab at the bottom and click "Make a copy" to copy the whole thing to your own Google Sheets account(free), and use it to your heart's content. [b]Price Import Automation![/b] If you're interested in reproducing the API import, you can find instructions for doing so within Google Sheets, in Torn's API forums [b][url=https://www.torn.com/forums.php?p=forums&f=63&b=0&a=0#!p=threads&f=63&t=15957914&b=0&a=0]here[/url][/b]. Note that you'll have to use your own API key(I'm not sharing mine). The second tab on this sheet already has the formula for importing the current bazaar price of Xanax, as an example. Simply insert your API key into that after you get the script set up correctly, and then you can copy that cell with updated item numbers from [url=https://www.tornstats.com/items.php]Torn Stats Item List[/url] to fill in for the other items. Note that going beyond a certain number of items(something like 30) will cause this to exceed your API-calls-per-minute limit when you pull the data. I ended up making a second import sheet to handle a second set of items on my spreadsheet. To force the whole sheet to update later, simply delete the import column(Column B), and then "Undo" the deletion(scary, yes, but it gets the job done). Edit values in light green. All other fields are calculated. Enter your base carry capacity in the field marked(it's also in light green). [url=https://docs.google.com/spreadsheets/d/1LIXN4dX8gM3sinVlWORZXIVvlKtnu1Hfg7NLTbOqr1w/edit?usp=sharing]https://docs.google.com/spreadsheets/d/1LIXN4dX8gM3sinVlWORZXIVvlKtnu1Hfg7NLTbOqr1w/edit?usp=sharing[/url][url=https://docs.google.com/spreadsheets/d/1LIXN4dX8gM3sinVlWORZXIVvlKtnu1Hfg7NLTbOqr1w/edit?usp=sharing] [/url]Let me know if you can't make a copy because it's restricted to commenting only. I can change it to "anyone with link can edit", but then there's the potential for vandalism. It doesn't matter to me, because this isn't my actual sheet anyway, but it wouldn't be useable if someone destroyed it. I can always just copy over it though. Yes, this is kind of a shameless plug for my own trading business, but this also is the exact setup I use to import pricing for my own trading spreadsheet(no, I'm not sharing that with you). So you can compete with me if you can figure out the trading sheet(not really that difficult). [url=https://www.torn.com/forums.php#!p=threads&f=10&t=15975475&b=0&a=0]https://www.torn.com/forums.php#!p=threads&f=10&t=15975475&b=0&a=0[/url] Now sell me your plushies! If you find this helpful, please reply to the thread to share it with others! Throe

Sarcasmboy [2037803]

I've found the Doctor travel hub very useful, but is there somehow that you can use it on a mobile device? So far I only get it to work on a computer..

Winged_Cougar [1993598]

I have my own solution for the cost per trip, and the average sell values, but I'm curious to know how you're pulling average pricing. Also, I'd love to know how you made a refresh button.

Winged_Cougar [1993598]

There's no way to access travelhub on mobile, so far as I know. I'm hopeful that [s]the[/s] Mauk will put a web page together to replace the older, not as reliable, but still in use, Travelrun page. On mobile, I usually use either #runners IRC, or [url=https://travelrun.torncentral.com]https://travelrun.torncentral.com[/url]. I use the application "IRC Cloud" for IRC on my phone. Works on both Android and Apple Mobile OS, and you can effectively get around the "Free Version Limitation" of 2-hours-idle-max by keeping it open on any computer in a web browser. That will keep you connected indefinitely, as long as the computer stays online. As an IRC client on mobile, it's not awesome, but it's useable. I just use the Web version when I get into IRC on my computer, and so I don't even use any other IRC client any more. One additional advantage is that you never have to worry about using groups of nicknames in IRC. It's one persistent session across all devices. One way to run travelhub on a mobile device, potentially, would be to play Torn on a device like a Microsoft Surface Pro, where you can install full Chrome, and any and all Chrome plugins/scripts/extensions. But then you're going to be carrying around a laptop everywhere with you, essentially. EDIT: See Mauk's post just below regarding potentially running DoctorN on Android. I'm not sure I want to even bother, since Android City Watch already does almost everything I want anyway, and as he also states, a travelhub site for mobile is coming. Besides that, I haven't been travelling much at all lately, between trading, helping to run a faction, and also now running a company. I highly recommend Android City Watch, if you haven't heard of it. Costs a bit of points to get the in-game "license" to use City Watch, but then you can essentially get push notifications for anything and everything in Torn on your phone, combined with one click login, which is so fast sometimes I do it on accident and end up logging myself out of my PC session unintentionally. Android City Watch is a grey area application that is semi-sanctioned, but I've tested the version I have(should be the most recent version available; it's no longer supported) with a software firewall on my phone, and it has never attempted to contact any domain or IP address not explicitly Torn owned and operated.