Transform your basic spreadsheet into a powerful data hub. Learn to add columns, filters, and formulas to efficiently sort sellers, track QC, and monitor delivery.
The default OrientDig
Step 1: Adding Strategic Data Columns
Expand your view by inserting columns for specific criteria. This creates the fields necessary for meaningful sorting and analysis.
Suggested Columns to Add:
Seller Category: e.g., "Manufacturer", "Trader", "Verified Partner"QC Status: e.g., "Passed", "Failed", "Pending", "AQL Level"Delivery Risk: e.g., "Low", "Medium", "High", "On Time"Contact Date: For tracking follow-up schedules.MOQ Minimum: To quickly filter by order quantity.
Step 2: Implementing Advanced Filters & Views
Use filter and sort functions to create dynamic views of your data, isolating the information you need at any moment.
Actionable Filter Setups:
- Categorize Sellers:Seller Category
- Monitor QC Performance:QC Status
- Track Delivery Status:Delivery Risk
- Monitor QC Performance:QC Status
Tip: Save these filter configurations as named views for one-click access.
Step 3: Creating Formula-Based Summaries
Automate calculations and summaries to gain instant metrics. This is where data transforms into intelligence.
Essential Formulas for Analysis:
| Purpose | Sample Formula (Google Sheets) |
|---|---|
| Count Sellers by Category | =COUNTIF(C2:C100, "Manufacturer") |
| Calculate Average QC Pass Rate | =AVERAGEIF(QC_Score_Range, ">0") |
| Flag Late Deliveries | =IF(AND(Estimated_Delivery < TODAY(), Status="Shipped"), "Delayed", "On Track") |
| Summarize Performance | Use =UNIQUE()=COUNTIFS()
|
Putting It All Together: A Sample Workflow
Imagine you need to evaluate suppliers for a new order. Here's how your customized OrientDig sheet works:
- Filter:Seller CategoryMOQ Minimum
- Sort & Analyze:QC Status
- Decide:Delivery Risk
- Sort & Analyze:QC Status