[Free] [Spreadsheet] Price List w/ AWH (v2.71) | Tools & Users…
[Free] [Spreadsheet] Price List w/ AWH (v2.71)
    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 04:42:12 - 13/08/21 (11 months ago)
    |
    Last replied 18:48:29 - 03/08/22 (8 days ago)



    Current Version: 2.71

    While this sheet is usuable on mobile, you can NOT set it up on mobile. You must use a computer.

    This is an autoupdating price list w/ calculator for traders. It is absolutely FREE to use.

    Now with AWH integration! (requires you to pay the 1.25m/week AWH sub)
    What is AWH? Check it out here



    Exclusive feature:
    This spreadsheet has built in, automatic, dynamic, and adjustable anti price inflation measures. This means that if someone buys a bunch of something to drive the price up, you will be protected! This spreadsheet will slightly drive up your pricing in order to outprice competitors who are only using item value, but your price will not move much! Additionally, this feature is 100% customizable!



    Trade Calculator example:
    https://docs.google.com/document/d/121iYBFx5gm4bAemBIiG6L24S6-IzG0E4NKrPtmz1kDs/edit?usp=sharing



    Here is the sheet (you need to make your own copy by going to File -> Make a copy): https://docs.google.com/spreadsheets/d/1HNUN02o73KDk75SYhQGqhlxPt3FlI5lbwU6T0NAMzwU/edit?usp=sharing
    Here is the doc explaining set up and features in depth: https://docs.google.com/document/d/1FhnJB6hvQ0-F_NYomccUCOTu3a8EQeGCzvdrry4lP-4/edit?usp=sharing


    DISCLAIMER: Set up is technical and will take 10 to 15 minutes. However it only needs to be done once. I have provided step by step instructions in the doc with professionally edited photos to help guide you.

    Set up options:
    Free
    - I am committed to making this spreadsheet 100% free to use, therefore it will always be free to set up yourself using the guide in the documentation.


    Special thanks:

    Grif [882958] for making the very basic bits of the spreadsheet
    0xHemlock [2662912] for his wonderful script and expertise (highly recommend for any google sheets projects)
    QuinnCarr [2596583] for all her input and pointing out that I am in fact an idiot multiple times
    xedx [2100735] for his amazing script and continual debugging. Highly record for general scripting.

    Known issues:
    -Crow Bars


    Changelog:
    Version 1.1
    -Fixed issue with armor at end of price calc
    -Added price 2.0, 3.0, and 4.0 with alternative price lists
    ----->Added missing items from enhancers and alcohol categories for price sheets 3.0 and 4.0 and removed armor and weapon listings
    Version 1.2
    - Fixed Max, min, and fixed prices stop working when the value is N/A
    -Fixed item based set prices
    -New scripting support
    -Fixed Travel calc issues
    Version 1.3
    -fixed item based set prices....for real this time
    Version 1.4
    -Add up to 600 items now with a two step system (adding a lot of items will slow down the updates with every 200 items adding 15 minutes).
    Version 1.5
    -Scripting fixes
    -Branding on the Price Lists (which you are free to remove)
    Version 2.0
    -Added script
    Version 2.1
    -Fixed Blood Bags
    -Fixed Quran Scripts
    Version 2.2
    -Added Plushie/Flower set support
    -Adding mobile friendly price list
    Version 2.3
    -Added catch all pricing
    -Added receipts
    Version 2.4
    -General item name fixes
    Version 2.5
    -Fixed points based sets on the script
    -Added AWH integration
    -Other stuff
    Version 2.6 Beta
    -Sorting on Price Calc and other sheets
    -Bulk Pricing (for both AWH and the script)
    -Item Name autocorrection
    Version 2.7
    -Advanced receipt generation
    Version2.71
    -Fixed AWH set issue
    Updating your sheet: Unfortunately the only way to update your price sheet is to set up a new one using the new blank spreadsheet. Make sure you DELETE the old one. It will go to trash in your google drive, and you need to delete it from trash too.

    Please report any bugs and issues to me. Thanks and I hope you find it useful.
    Last edited by Xanet on 19:48:03 - 15/04/22

    Trader looking for a FREE auto updating solution? Click here!

    • Dai [2596583]
    • Role: Civilian
    • Level: 69
    • Posts: 1621
    • Karma: 402
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 04:45:46 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    Great spreadsheet! So glad for all the work you put into this :)
    And the fact it's free makes it all the more awesome!
    Last edited by Dai on 04:46:31 - 13/08/21
    • spud [2388968]
    • Role: Civilian
    • Level: 60
    • Posts: 448
    • Karma: 499
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 05:45:19 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    very cool! i like, 10/10 :)

    hola im trader

    trade with me pls so I can make monies

    thanks

    prices: https://tinyurl.com/spudprices

    • CalvinDummers [2563819]
    • Role: Civilian
    • Level: 67
    • Posts: 118
    • Karma: 83
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 05:45:57 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    Xanet, you are just awesome, freakin' awesome!, Let's go people! BUMP!!!!
    • yewnit [2592654]
    • Role: Civilian
    • Level: 69
    • Posts: 987
    • Karma: 2724
    • Last Action: 2 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 09:51:17 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    The hero the people deserve

    • DeKleineKobini [2114440]
    • Role: Committee
    • Level: 98
    • Posts: 3089
    • Karma: 4296
    • Last Action: 5 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 10:09:50 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    While I do think it's great to bring this back after Grif took his down, I do have a single question: why update it every 15 minutes? Market values only update once a day at midnight. You should probably also write in your post that it uses market value, and not bazaar/marker prices.
    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:18:01 - 13/08/21 (11 months ago)
    Post link copied to clipboard Copy post link

    DeKleineKobini [2114440]

    While I do think it's great to bring this back after Grif took his down, I do have a single question: why update it every 15 minutes? Market values only update once a day at midnight. You should probably also write in your post that it uses market value, and not bazaar/marker prices.
    It uses both value and Bazaar prices in a formula I wrote myself for this project. It updates bazaar prices every 15 minutes. If you check the price calc sheet you'll see it references a lot of different cells on the price calc page and some of them are updating bazaar prices.
    Last edited by Xanet on 16:19:34 - 13/08/21

    Trader looking for a FREE auto updating solution? Click here!

    • LINDI [2319655]
    • Role: Civilian
    • Level: 48
    • Posts: 624
    • Karma: 370
    • Last Action: 26 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:15:42 - 16/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    So cool!

    LINDI - Buying Everything on item market. --- Click here to trade with LINDI https://tinyurl.com/TradeLinkk --- I guarantee a fast trade. For price sheet click here https://tinyurl.com/LINDIpricesss  Guaranteed safe mugg free trade 1k+ safe trades done 100+ friends Trade Now!

    • nomoretime [2479907]
    • Role: Civilian
    • Level: 54
    • Posts: 614
    • Karma: 725
    • Last Action: 11 months
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:01:56 - 17/08/21 (11 months ago)
    Post link copied to clipboard Copy post link
    PERFECT!

    • DeKleineKobini [2114440]
    • Role: Committee
    • Level: 98
    • Posts: 3089
    • Karma: 4296
    • Last Action: 5 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 11:45:28 - 17/08/21 (11 months ago)
    Post link copied to clipboard Copy post link

    DeKleineKobini [2114440]

    While I do think it's great to bring this back after Grif took his down, I do have a single question: why update it every 15 minutes? Market values only update once a day at midnight. You should probably also write in your post that it uses market value, and not bazaar/marker prices.

    Xanet [2007324]

    It uses both value and Bazaar prices in a formula I wrote myself for this project. It updates bazaar prices every 15 minutes. If you check the price calc sheet you'll see it references a lot of different cells on the price calc page and some of them are updating bazaar prices.
    Great, didn't look through everything.

    A big concern is your 2nd option for launching the spreadsheet. People will think that having some cells hidden means that nobody can access them, but nothing is less true. If someone who knows how to use spreadsheets well, their api key will be easy to get. I would recommend changing that to having a secondary spreadsheet that loads the content using IMPORTRANGE, it's how I do it for my pricelists.
    • 0xHemlock [2662912]
    • Role: Civilian
    • Level: 29
    • Posts: 521
    • Karma: 596
    • Last Action: 21 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:54:09 - 17/08/21 (11 months ago)
    Post link copied to clipboard Copy post link

    DeKleineKobini [2114440]

    While I do think it's great to bring this back after Grif took his down, I do have a single question: why update it every 15 minutes? Market values only update once a day at midnight. You should probably also write in your post that it uses market value, and not bazaar/marker prices.

    Xanet [2007324]

    It uses both value and Bazaar prices in a formula I wrote myself for this project. It updates bazaar prices every 15 minutes. If you check the price calc sheet you'll see it references a lot of different cells on the price calc page and some of them are updating bazaar prices.

    DeKleineKobini [2114440]

    Great, didn't look through everything.

    A big concern is your 2nd option for launching the spreadsheet. People will think that having some cells hidden means that nobody can access them, but nothing is less true. If someone who knows how to use spreadsheets well, their api key will be easy to get. I would recommend changing that to having a secondary spreadsheet that loads the content using IMPORTRANGE, it's how I do it for my pricelists.
    As a scripter, I can confirm that read access to a sheet is enough to read the contents of the entire sheet - hiding cells and tabs is just UI and UX.
    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:47:18 - 17/08/21 (11 months ago)
    Post link copied to clipboard Copy post link

    DeKleineKobini [2114440]

    While I do think it's great to bring this back after Grif took his down, I do have a single question: why update it every 15 minutes? Market values only update once a day at midnight. You should probably also write in your post that it uses market value, and not bazaar/marker prices.

    Xanet [2007324]

    It uses both value and Bazaar prices in a formula I wrote myself for this project. It updates bazaar prices every 15 minutes. If you check the price calc sheet you'll see it references a lot of different cells on the price calc page and some of them are updating bazaar prices.

    DeKleineKobini [2114440]

    Great, didn't look through everything.

    A big concern is your 2nd option for launching the spreadsheet. People will think that having some cells hidden means that nobody can access them, but nothing is less true. If someone who knows how to use spreadsheets well, their api key will be easy to get. I would recommend changing that to having a secondary spreadsheet that loads the content using IMPORTRANGE, it's how I do it for my pricelists.
    Ah, thank you. I may just leave it only as the publish option then, since I don't really see an issue with that one.

    Trader looking for a FREE auto updating solution? Click here!

    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:14:11 - 03/09/21 (11 months ago)
    Post link copied to clipboard Copy post link
    bump

    Trader looking for a FREE auto updating solution? Click here!

    • Syn- [2653035]
    • Role: Civilian
    • Level: 64
    • Posts: 367
    • Karma: 170
    • Last Action: 3 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 08:57:01 - 04/09/21 (11 months ago)
    Post link copied to clipboard Copy post link
    Since Torn Exchange has gone a bit weird recently I looked for something else to use for the time being (or permanently) and found this. Took a good 10 minutes to set up, not too difficult, but when it's set up, it works great. This is brilliant, thank you.

    • eldragos [1632859]
    • Role: Civilian
    • Level: 72
    • Posts: 883
    • Karma: 647
    • Last Action: 4 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 16:07:47 - 18/09/21 (10 months ago)
    Post link copied to clipboard Copy post link
    Bump
    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:42:10 - 16/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    bump

    Trader looking for a FREE auto updating solution? Click here!

    • Yeala [2599083]
    • Role: Civilian
    • Level: 85
    • Posts: 138
    • Karma: 229
    • Last Action: 14 minutes
      • 1
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:31:55 - 16/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Absolutely brilliant work :) thank you very much!
    While pretty much good to go as is, this is open to so much customization as one could wish. Will keep playing with it, hope I don't destroy it and have to do it over ;D
     

    • de_struction [2162016]
    • Role: Civilian
    • Level: 46
    • Posts: 133
    • Karma: 72
    • Last Action: 25 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:38:55 - 07/11/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Thank you! This is even better than the paid ones

    • GraceWatson [2199610]
    • Role: Civilian
    • Level: 35
    • Posts: 241
    • Karma: 122
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 13:08:45 - 12/11/21 (8 months ago)
    Post link copied to clipboard Copy post link
    Thank you, been using your spreadsheet for me to auto track my profit for flying. Been a big help especially because the price was comparing the market price with current bazaar price
    Last edited by GraceWatson on 13:12:01 - 12/11/21
    • Xanet [2007324]
    • Role: Civilian
    • Level: 78
    • Posts: 3189
    • Karma: 2492
    • Last Action: 12 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:16:15 - 17/11/21 (8 months ago)
    Post link copied to clipboard Copy post link
    bump

    Trader looking for a FREE auto updating solution? Click here!

Reply
Thread Title: