Building a Seller Ranking Dashboard in FishGoo: A Step-by-Step Guide

Effectively identifying your top-performing sellers is crucial for streamlining procurement and ensuring customer satisfaction at FishGoo. By leveraging built-in spreadsheet formulas and conditional formatting, you can create a dynamic, visual ranking table that highlights sellers based on QC ConsistencyShipping Accuracy. This guide walks you through the process.

Step 1: Structure Your Data

Start with a well-organized sheet. Assume your raw data has the following columns for each seller (or order batch):

A: Seller Name
B: Items Passed QC
C: Total Items Checked
D: Orders Shipped On Time
E: Total Orders

Step 2: Calculate Key Performance Indicators (KPIs)

Insert two new columns to calculate the core metrics:

Column F: QC Score %
=IFERROR((B2/C2)*100, 0)
Column G: Shipping Accuracy % =IFERROR((D2/E2)*100, 0)



    
        Step 3: Create a Composite Ranking Score
        In Column H: Overall Score, create a weighted formula to combine both KPIs. For example, you might prioritize QC (60%) slightly over Shipping (40%):
        =(F2*0.6) + (G2*0.4)
        This single score becomes the basis for your ranking.
    

    
        Step 4: Rank the Sellers
        In Column I: Rank, use the RANK.EQ
        
=RANK.EQ(H2, $H$2:$H$100, 0)

        The 0
    


    
        Step 5: Apply Color Coding (Conditional Formatting)
        Visualize the top performers instantly:
        
            Highlight Top 3 Sellers:=AND($I2<=3, $I2>0)
                
Apply a bold font and a distinct background color (e.g., Green).
            

            Color-Code Performance Bands:Color Scale
            
Flag Low KPIs:Red=F2<95
            

        

    


    
        Sample Ranking Table Visualization
        
            
                
                    
                        Rank
                        Seller
                        QC Score
                        Ship Accuracy
                        Overall Score
                    
                
                
                    
                        1
                        Oceanic Premium
                        99.5%
                        100.0%
                        99.7
                    
                    
                        2
                        Coral Reef Supplies
                        98.8%
                        99.2%
                        99.0
                    
                    
                        3
                        Deep Blue Traders
                        97.0%
                        98.5%
                        97.6
                    
                    
                        12
                        Budget Aquatics
                        91.0%
                        94.5%
                        92.4
                    
                
            
        
    

    
        Conclusion
        Your FishGoo seller ranking table is now complete. This dynamic dashboard automatically updates ranks and colors as you input new data, enabling your team to make informed, data-driven purchasing decisions at a glance. By rewarding consistent quality and reliability, you foster stronger partnerships with your top-rated sellers.
        Pro Tip:SORTFILTER

Rank	Seller	QC Score	Ship Accuracy	Overall Score
1	Oceanic Premium	99.5%	100.0%	99.7
2	Coral Reef Supplies	98.8%	99.2%	99.0
3	Deep Blue Traders	97.0%	98.5%	97.6
12	Budget Aquatics	91.0%	94.5%	92.4