Buy/Sell/Trade collection-based Master Spreadsheet?

Pirates with Ben – About Pirates CSG Pirates CSG Forums Pirates CSG Buy/Sell/Trade collection-based Master Spreadsheet?

Tagged: 

Viewing 9 posts - 1 through 9 (of 9 total)
  • Author
    Posts
  • #9667
    Ben
    Keymaster

    I’m working on an alternate Master Spreadsheet that is designed for collecting and trading.  You can see it here.

    For now only the first set has the extra columns – once the format is good enough, I’ll add it to the others and make it more available as a .xlsx file.

    Questions:

    Are those 5 columns enough?  Is the order good?  Do you recommend any changes to the names of those columns?  I almost did “Notes/$” instead of just Notes, but didn’t want to make it too aggressively formulaic.

    I have pre-filled the Total Haves column with the Sum function to combine the haves numbers.  Should I just leave it blank?  The idea is to have a ready-made spreadsheet for collection management and trading, but I don’t want it to look weird off the bat if people don’t want to see a ton of 0’s.

    I think it makes sense to keep the filters on since you could sort someone’s collection by most haves for trade in a set/etc.

    I did delete RtSS and most of the Unreleased stuff.  🙂   (old_man and J_ARRRRR_P can enjoy being the only ones able to fill out anything from that section lol, and name their price if they want 😉 )

    Thank you!

    #9669
    Mitch
    Participant

    I like it, this is a pretty solid idea with a lot of potential. It would be great to have something like this that would allow groups to compare collections, especially in the realm of trading/selling.

    #9683
    Daddy Garand
    Participant

    I love this idea, even though I am just getting back in I already have several multiples and lots to acquire. Would be awesome to find people to trade with and buy from.

    #9688
    Mitch
    Participant

    I can very much agree with that. I try to buy just specifics when I do purchase something, but over the years of buying boxes and packs I’ve found myself in possession of a great many duplicates from rare to common, even some specials. Though basic crew can always be useful as duplicates, I’ve never had much use for the extra ships, thus as you’re saying, it would be wonderful to share, via trade or purchase, those vessels with others.

    #9693
    Daddy Garand
    Participant

    I just got back into it, and while I am gifting most of my doubles to my brother, I am already finding myself stuck with triples haha, I would much prefer finding people who might be missing them, plus there are ships I struggle to find on ebay like the PotSM EL Acorazado 🤦‍♂️ that and the HMS Bolingbroke are the only ships in that series I have left. For such a small series it is hard to get those specific ships.

    #9728
    Mitch
    Participant

    I’ve recently been getting back more to it myself and reevaluating my collection. I too have a number of triples. It seems there are some ships that are just drawn to me, over the years I’ve had a couple I seem to pull with astonishing frequency from packs. I would much prefer my extras go to those missing them as well. I actually have almost 2 complete sets of the Spanish Main series and I’m almost positive I have duplicates of both of those ships, the Bolingbroke for sure I believe. I was able to get most of the British and Pirate stuff in that set pretty easily in the day but a good number of the Spanish ships were hard to find. The one you’re after is a pretty highly sought ship from what I remember and I’m guessing that hasn’t changed. The one that caused me the longest search was the Revenant. Was able to get 2-3 Harbingers but never the Revenant in a pack. I had to make a decent trade to finally get my hands on one. As of current the Spanish Main series is the only one I have a full set of, but I’m very close with Oceans Edge. I have between 1/4-3/4 of most other sets, but have only a few ships from SCS, MI, FN, and POTC.

    #9778
    Matt Lovell
    Participant

    I’d prefer a list with all the sets on the same tab for searchability sake (but that’s why I maintain my own list). It also makes the list unfortunately long which I understand can be bothersome as well. (2425 lines on mine without including 2004/2005 islands or Ger. SM UL)

    I’d say if anything having the extra ‘In collection’ column may be confusing to some (it shouldn’t be but it inevitably is) but I think it’s good for dual purpose of both collecting and trading tracker.

    I’m a big fan of left alignment over center alignment for lists so the column breaks look cleaner.

    I typically will go with a size 8 text, usually Calibri or arial narrow as a means of putting more data on the screen at once, though I know this often annoys people I work with worse off eyes.

    My thoughts for you. Take ’em or leave ’em. Whatever works to get more trade/sell going on on site works for me 🙂 (and am willing to help as I can to make that happen, just let me know.)

    #9780
    Ben
    Keymaster

    My thoughts for you. Take ’em or leave ’em.

    Thank you!  I will take that into consideration as I resume looking at the sheet soon.  I personally find that aligning small bits of text (such as single digit numbers) in the center of cells is easier to look at and digest the information than having it aligned to one side.

    I may even make an additional spreadsheet with just one tab with all the sets.

    Each person would download the sheet (or make a copy in their own Google drive/etc) to make their own edits due to their specific collection, so at that point they could make the font smaller if they wanted to.

    #9888
    Ben
    Keymaster

    New Version

    Now the first sheet contains all the game pieces (except the 1 of 1’s), with each set still present as well with its own sheet.  For the first sheet, I consolidated the info so it is all trade-based and doesn’t include gameplay stats.

    I may just leave it as-is; you can hit File>Download to get your own copy!  Feedback welcome.

Viewing 9 posts - 1 through 9 (of 9 total)
  • You must be logged in to reply to this topic.