Details of the Output Excel File

There are many hidden features of TURBO PIRANHA and its output Excel file. As you know, Turbo Piranha creates an Excel file as a result of the analysis of your product and price lists. In this guide, we’ll share some of these hidden gems for you to use it in the most powerful ways.

UPDATE: Please don’t forget to check new great feature: Excel Add-In for Turbo Piranha. It makes your analyses easier than ever.

Meanings of the Titles and the Details of Formulas

Actually, the column names of the Excel file are pretty explanatory. On the other hand, some of them still may need some explanations such as how we are calculating does ROI,  does it include a specific cost or not, etc.

For this purpose, we have some hints in such columns to make them clear for you. By checking these hints, you can understand what that column is for and if there is a formula, you can easily understand what the formula does contain or exclude. In order to see these hints, just move your mouse on the header of that column and that hint appears automatically.

Sample Screenshots for the hints

The little “Red Triangles” on the top columns mean there are hints which explain the purpose of that column or the formula if there is any. Just move your mouse pointer over that Excel cell and this hint will show up automatically. (Do not click, just hover over the cell and wait for a few moments)

Formula Example: Landed Purchase Price

As you can see in the image below, by checking the hint of the column, you can easily understand that the Landed Purchase Price means the sum of your purchase price and your shipping cost to get the item from the supplier. It shows you the formula’s meaning in that cell.

Information Example: Amazon Referral  Fee

The Excel output file has many columns that we get the information from Amazon directly or calculate using the formulas given by Amazon. Referral fee is one of these confusing columns which needs some explanation. Using the same technique, you can understand how the referral fee is calculated by Amazon and what the minimum value is for this fee. It also says what to search for more information.

Last Example: FBA Monthly Storage Fee

As you may already know, Amazon charges different storage fees in different time periods of the year. For example, in October. November and December, the storage fees are almost three times more expensive than the fees for the remaining of the year. We give this information and the exact coefficients for your reference.

In this way, if you are planning to buy these items for that specific period, you can either update the formula manually using these numbers to see the exact results, or at least you can have an idea of what you are going to be charged.

Why do We Use Different Colors in the Titles and the Data Cells?

We use different styles for the titles and data itself. They all have some meanings and their purpose is to increase your readability. You can find their meanings briefly in the Styles tab of your Excel as shown in the image below. We’ll explain them in the next section one by one.

The Title Colors and Their Meanings

The light blue color columns come from Amazon directly, so the style name of them is Title-Amazon Data. The data under dark blue color columns are calculated by Turbo Piranha using your inputs, the program settings, the Amazon data, and also some formulas. For this reason, their style name is Title-TURBO PIRANHA.

Similarly, columns which have links use purple if they belong to an Amazon page, and dark purple if they belong to an External page like Keepa.

The Colors of Data Cells and Their Meanings

In addition to titles, data cells have specific styles as well. For example, the most important and popular columns such as Best Seller Rank, Total Offer Count, etc. are highlighted with yellow color.

Another color differentiation is used for NEW and USED items. Due to the fact that new items always have bright colors, NEW FBA and NEW FBM data cells use brighter colors (bright green and bright blue respectively) than the USED FBA and USED FBM data cells.

For USED FBA and USED FBM items, we use relatively faint green and faint blue as you can see in the image below. In addition, we used the dashed borders to make them even more understandable.

ps. There is no data in this example but especially booksellers who selles used books need and use these columns frequently.

We have Buybox specific styles as well. If there are solid borders around the data like these, they belong to Buybox items. NEW Buybox items use white which implies freshness and USED Buybox items uses gray color which implies old condition. In these examples, there is no USED Buybox information but in ISBN analysis you can see an example to USED Buybox as well.

Since Buybox may belong to either FBA or FBM seller, we added a column for that which shows this seller type if Amazon sends us that seller’s seller type. Sometimes Amazon does not show it explicitly, so we use “Undetermined” for those items. On the other hand, for such cases, you can easily navigate to New and Used Prices using Amazon Price Links at the end of each row and check if it is FBA or not easily.