Disclaimer: Links on this page pointing to Amazon, eBay and other sites may include affiliate code. If you click them and make a purchase, we may earn a small commission.

Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. 05-02-2017, 09:20 AM #1
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    Please help me by reviewing my fully searchable inventory spreadsheet

    I know that some will say SCF has an inventory so use that. I am thankful for the SCF inventory system but it does lack some functionality that I want.

    Check out my inventory by downloading the Excel file. Please try it out and see if it works well for what you would be searching for. My inventory database isn't fully completed yet but I am working on it.

    If you have any suggestions I would love to hear it! That's what this thread is for.

    Screen Shot 2017-05-02 at 10.05.34 AM.png


    PS. - And if you find anything you'd like to trade for let me know, I'm trading for Leafs, YGs, and Canvas sets.

    Cheers.

    JT
    Last edited by JayT_59; 05-02-2017 at 09:22 AM.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  3. 05-02-2017, 09:53 AM #2
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    I overwrote the most recent file with an older version. Will have it back up shortly.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  4. 05-02-2017, 10:07 AM #3
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    fixed
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  6. 05-02-2017, 11:41 AM #4
    atruong317
    atruong317 is offline



    Join Date
    Apr 2014
    Posts
    453
    SCF Rewards
    773
    Country

    nice spreadsheet!

    What are you suppose to input for the search criteria? "Y" ?

    How do I search for

    Non-Rookie Auto Patches?
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  7. 05-02-2017, 11:56 AM #5
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    Quote Originally Posted by atruong317 View Post
    nice spreadsheet!

    What are you suppose to input for the search criteria? "Y" ?

    How do I search for

    Non-Rookie Auto Patches?

    Any input will work with the boxes. I will include a non-rookie search criteria that will exclude rookie items.


    Thanks for the comment!


    J
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  9. 05-02-2017, 11:59 AM #6
    atruong317
    atruong317 is offline



    Join Date
    Apr 2014
    Posts
    453
    SCF Rewards
    773
    Country

    Quote Originally Posted by JayT_59 View Post
    Any input will work with the boxes. I will include a non-rookie search criteria that will exclude rookie items.


    Thanks for the comment!


    J

    I was thinking of a negate qualifier if that is possible.

    Y for what you want, and N for what you don't want.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  10. 05-02-2017, 12:03 PM #7
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    Non-Rookie search criteria now available.

    Screen Shot 2017-05-02 at 1.08.12 PM.png
    Last edited by JayT_59; 05-02-2017 at 12:08 PM.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  12. 05-02-2017, 12:07 PM #8
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    Negate qualifier is a great idea. It'll take a bit of work but I think it'll be great. Thanks.
    Last edited by JayT_59; 05-02-2017 at 12:16 PM.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  13. 05-02-2017, 12:30 PM #9
    atruong317
    atruong317 is offline



    Join Date
    Apr 2014
    Posts
    453
    SCF Rewards
    773
    Country

    and scandalous that you used CAL for Calgary instead of CGY.

    What are you Elliott Friedman? :P

    https://www.reddit.com/r/hockey/comm...ma_on/d09lejf/
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
  14. 05-02-2017, 12:42 PM #10
    JayT_59
    JayT_59 is offline



    Join Date
    Sep 2010
    Posts
    1,960
    SCF Rewards
    996
    Country
    Toronto Maple Leafs Philadelphia Eagles Toronto Blue Jays
    See maritimesportscards's Items on eBay COMC Cards For Sale Upper Deck ePack
    Member is PayPal Verified

    LOL. Good catch I'll have it changed.

    Quote Originally Posted by atruong317 View Post
    and scandalous that you used CAL for Calgary instead of CGY.

    What are you Elliott Friedman? :P

    https://www.reddit.com/r/hockey/comm...ma_on/d09lejf/

    After checking it was CGY on the inventory database but CAL on the list. Appreciate the feedback brother.
    Last edited by JayT_59; 05-02-2017 at 12:45 PM.
    Reply With Quote Reply With Quote Add as FriendAdd as Friend
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

SCF Sponsors


About SCF

    Sports Card Forum provides sports and non-sports card collectors a safe place to discuss, buy, sell and trade.

    SCF maintains tools that will allow collectors to manage their collections online, information about what is happening with the hobby, as well as providing robust data to send out for Autographs through the mail.

Tools and Forums



Sponsors



Follow SCF on