Auto Runner Sheet

I think I put this as a reply to another thread but why all these random sheets when you can just have your own.

https://docs.google.com/spreadsheets/d/1ockL7mfbxfyng2Cz1fd3aTM8gfDP7AOYroJ8bR6rlu4/edit?usp=sharing

Scripts needed below. Go to "tools > Script editor..." and make a new script for each one.

• =getPrice(ItemID,APIKEY) - https://pastebin.com/YGHD9HPf
• =getPointp(APIKEY) - https://pastebin.com/SUvnQ7VR
• Travelrun Stock - https://pastebin.com/zMBxuvQ0
  
• Time conversion - https://pastebin.com/ZhdUEBMw
• Extra conditional formatting - https://pastebin.com/tj37uVrz
• ImportJSON - https://pastebin.com/FDk04mpL

You might need to go through the cells for "Stock", "Last stock update" for everything as well as the "Price per item" for drugs/other while pressing enter to get them to refresh after you copy the spreadhseet.
Apart from that I think everything else is working, nothing has been left out and all the math is correct Load image: tired

Updated main runner sheet

Removed dr.n travel data and cleaned some things, might of broken parts.

i'm not good at scripts at all. but it seems this is working for what tornstats used to be used for? also i think im too dumb to understand the instructions givin about the scripts too :p

 

Aggr, you can use my spreadsheet i made . See my signature

Shows data from http://travelrun.torncentral.com/index.php 

for the scripts click 'tools' in your spreadsheet toolbar then 'script editor' and make the scripts there. 

 

Updated a bit, some stuff that is lost in copy added to op

Thank you so much for this sheet..awesome.

I wonder if you could add data from TornEXT since you already removed data from DoctorN. [:wink:]

Unless the updates are better than travel run is not much point. Added dr.n travel data due to how many people updated it.

Added flight delay stuff

Very useful

i switched the data source to 'Dr.N' in column o but it didnt work. It still displaying data from 'travel run'. Do i miss something?

Thanks :)

Never added dr.n data back after it was down, will try add it back over weekend.

I think i did it correctly

tyty :D it works very well

Readded time conversion script to op

Awesome Work, and great tool. thanks for helping us all out.