Read the new book all about Team Fortress 2 trading and the TF2 Spreadsheet.

Thursday, January 19, 2012

Notes on site upgrade

Okay everyone, hopefully you've had a chance to play with the new spreadsheet UI.  We took our time to try and make it work correctly and address a lot of the concerns that you have let us know about.  Here is a list of the new functionality and how to use it.
  1. Show entries selector - the most obvious change is that the spreadsheet is shorter and defaults to 25 items.  You can change this to a different # or all items.  To do this, simply click the drop-down box and choose how many items you want.  We will keep the 3 most traded items on top and the default view as you requested (earbuds, bills, and keys).  From now on we will also add new items to the top of the list.
  2. Search box - any text in the sheet is searchable, including notes sections.
  3. Column sorting - the most requested feature.  In either ascending or descending order, click on the up/down arrow to the right of each column header.
    • Multi-column capability - by clicking on one column's arrow, hold down the Shift key and click on another.  For example, you can sort all the items by quality and then by their value in refined.  First click an arrow in the quality column, then hold shift and click on an arrow in the refined est. column. 
Other changes you may notice:
  • Change of "scrap" to "0.11".  This was not only done to keep the columns thinner but to also let sorting by the "refined est." column work better.   You will also notice that this column works in order of buds/bills/keys.  Thanks to our super-smart programmer for that.
  • Change in item qualities and some color coding.  We are trying to be more in-line with Valve's standards of color coding and item qualities.  At the same time we want it to be easy to differentiate between items that are of limited and unlimited nature.  Hopefully we've found a good solution now.
  • Usability on mobile/tablet devices, steam in-game - we tested this on both ipad/ipod and android tablets as well as while in game with the "shift-tab" option.  While not everything (ex: tooltips on tablets) works, the sheet is usable now on these other platforms better than before.
  • To everyone who requested we share the actual spreadsheet with them, there is a reason we don't.  The sheet itself is very slow because of the number of items and complexity of the formatting.  It would be even worse with everyone accessing it directly.   Having it as a published document makes it very speedy.
Although it may not seem like much it wasn't easy to reverse-engineer things after the sheet had been built for over a year.  This is not the end of the upgrading as we will tweak things as we get more feedback.  Thanks to all of you for your testing things for us and telling us when we screw up (praise is ok too!).  Happy trading!


  1. i have always loved this spreadsheet but since the update it always goes directly to the key and the unusual hats guide and i have no clue how to get to the actual master sheet can someone help me?

  2. cibrock: we've covered this ad nauseam. The price of promos is whatever people are willing to pay for them. What people are paying, we report here.

    John: The other two worksheets do pop up briefly before the main sheet does but it should always end up on the main sheet (part of the code apparently). What browser are you using? I would clean your browser cache first by deleting all files and see if that works.

  3. As a Chrome user, I have noticed that the spreadsheet has stopped working for me. I cannot use the search function, or expand the list to show all the items. I also notice that the search function does not always yield the results I am looking for, instead using the CTRL+F when I search.

  4. same problem as john with opera

  5. Chrome user here, reporting full functionality.

  6. On the sticky and rocket jumper entries the "notes" section says
    "1 reclaimed + 1 0.11 to craft | 1 in 4 chance"
    while it should say
    "1 reclaimed + 1 scrap to craft | 1 in 4 chance"
    might wanna fix that, lol

  7. Pete: that is odd. Try the same as we told John, clear the cache and reload. We tested this on Chrome/Firefox/IE/Safari so it should work.

    Brock: I'll let the developer know, meanwhile use another browser. We don't have a lot of users on Opera so it wasn't on our list to test.

    Jeremy: thanks for the feedback.

    MrKnowItAll: fixed! Thanks. A good name for you!