Saturday, March 8, 2014

All In One Microsoft Excel Bowman Chrome MLB Prospect Investment Tool For Sale

Excel All-In-One Prospecting Tool

All-in-one, Microsoft Excel prospecting database tool FOR SALE.  I promise this is the last Excel spreadsheet program you'll need when it comes to Bowman Chrome autos.  Plus, I'll include an eBay sales manager tool for free -- click here to see it.

If you're not satisfied and I can't fix it, I'll offer a full refund and you can keep the program for free.


Overview


This is an inventory manager for Prospect baseball cards, designed by http://www.ProspectsForCash.com.

Player Lists


In the sheets "PROSPECTS 2010 - PRESENT" and the sheets for each individual set, you will find all the Bowman Chrome and Bowman Chrome Draft Autos, along with current team, position, and a hyperlink to their stats. The sheet "PROSPECTS - PRE-2010" does not have hyperlinks. The sheets can be sorted in any way you want. For quick additions to your inventory or watch list, simply highlight the full player name you want (Column A) and click Add to Inventory or Watch List.

Inventory


When a player is added to the inventory, all versions of his card will default to a quantity of 0.


Type in the appropriate quantities for that player. Click Inventory Input for an easy to use pop up input box.

BGS INVENTORY


On the "BGS INVENTORY" sheet, click Add Card to easily add all of your graded cards to your BGS Inventory. Choose the card, variation, and grades for each and click OK. To delete any cards in the BGS Inventory click on any cell in the row you wish to delete, right click, delete, delete row.

Watch List


When a player is added to your watch list, you can use this for anything you want, linking to ebay searches, price tracking, etc.

PULLED SUPERFRACTORS


This is an up to date list of all the pulled superfractors to date, that have been spotted. Any card with an X has been pulled.

EBAY FEE CALCULATOR


Tool to calculate ebay fees and direct paypal fees. Before using for the first time, you can input the USPS shipping costs for each package and insurance costs. These values will add to the dropdown menu in the S/H fields so you do not have to type them ever again. You can just click the price.

Top Prospect Lists


"Matrix" has the full list of prospects and top prospect rankings next to top prospects, from a variety of sources. "BA" has the 2014 Baseball America grids of the top 10 prospects for each MLB team. "BA TOP100" has the Baseball America top 100 prospects with a one line analysis of each. "Top 100 Lists" has the four best Top 100 lists from 2014.

Create A Chart


You will notice buttons on the Inventory and Watch List pages, for creating charts. To quickly and easily make a chart of your inventory, highlight all of the cells with data (including the headers in the top row), and simply click the button. This creates a nice visual chart of your inventory (or data in your watch list). You can resize the chart as needed, by clicking on it and then clicking a corner of the chart and pulling to a larger size.

LEDGER / PROFIT LOSS


The "LEDGER" is used to keep track of all purchases and sales. Click the button CLICK TO ENTER TRANSACTION. Choose the card, variation, and type in the $ amount. If it's a purchase, type a negative number. If it's a sale, type a positive number. When you click enter a few things happen: the card inputs into the ledger, and the ledger updates. Then on the right, it creates a reference, which is the card. This reference list is useful for a quick snapshot of your net profit and loss for each card. I.E. If you enter a thousand transactions (sales and purchases) that involve Buxton, on the right, Buxton will have one line, and will automatically calculate your profit or loss on all Buxton cards. The Profit / Loss Income Statement on the next tab calculates based on all those automatically generated reference net totals. In the yellow cells on the bottom, you can input any other expenses not already included in your Ledger, for a complete Prospecting Income Statement.

PROFIT GOALS


"Profit Goals" is a quick reference chart of when to sell via ebay based on purchase price. It assumes a flat $2.50 s/h cost to you for shipping and supplies, a 3% + $0.30 paypal fee, a free ebay listing fee, a 10% ebay final value fee, and a goal of 20%+ net profit.

Customize Properties


On the main sheet "PROSPECTS 2010 - PRESENT" there is a neat little tool I made to quickly and easily customize the properties of the spreadsheet. Options include toggling on and off showing: formula bar, status bar, sheet tabs, horizontal scroll bar, vertical scroll bar, row and column headers, page breaks, gridlines, and a toggle to zoom in and out.

Questions or comments


Feel free to contact me at Prospects4Cash@gmail.com with any questions, comments, complaints, or to inquire about other prospecting products.

Screenshots




TOP PROSPECT LISTS


SUPERFRACTOR TRACKING

BGS INVENTORY TRACKING

EBAY FEE CALCULATOR


EBAY SALES MANAGER







2 comments:

  1. Nice work here, wish PSA was available though

    ReplyDelete
    Replies
    1. I can easily add a PSA inventory if you would like. Email me at Prospects4Cash@gmail.com.

      Delete