Cleanup pass focused on vague buckets: Internal / Other / Unknown and Partners / Advisors / Government. Original categories are preserved; new detail is in refined_relationship_category.
| Refined category | Rows | Examples from cleaned buckets |
|---|---|---|
| Blank / Worksheet Padding | 1,036,247 | ; ; ; |
| Suppliers / Vendors / Service Providers | 5,010 | |
| Customers / Prospects | 2,530 | |
| Internal / Tampa Brass Team | 1,348 | GONZALEZ NUNEZ ALAIN - I26360; Homebase; BERKHALL JACKSON DASIA - H32551; HERNANDEZ RODRIGUEZ DANNI - E30340 |
| Personal / Individual Contact - Needs Review | 880 | Collins Aerospace; Carlos; Cruz Cabrera; Fermin |
| Needs Manual Review / Unresolved Relationship | 854 | Pratt & Whitney; Pratt & Whitney','Collins Aerospace; Product modal includes Company; Align Quality and Supply |
| Software / IT / Workflow Tool | 522 | ECI; Outlook; SeaFaring; Bilingual English / Spanish EDUCATION Santo Tomas University |
| Government / Military / DoD | 324 | us.navy.mil; National Contracts, Inc; Delivery of 30 mid-bodies and 30 tailcones - Full compliance with Raytheon; DX-rated contract - The requirement to meet Raytheon |
| Defense Prime / Aerospace & Security | 264 | rtx.com; Advisor documents should be structured to motivate weekly phone calls, Raytheon; Prepare meeting packets for Ryan/business development/advisors. Advance Raytheon; RTX |
| Manufacturing / Industrial Supplier | 206 | JobBOSS; Aluminum Corp; Techni-Cast; Benton Foundry |
| Finance / Capital / Lender / Advisor | 126 | AGIP; MCG; Ryan should invest at AGIP; Ryan, AGIP |
| Partner / Affiliate - Needs Detail | 119 | Carl Zeiss Industrial; Don Clark Enterprises Inc; DRS Network & Imaging Systems; Leslie Controls, Inc |
| Professional Services / Consulting | 41 | Accounting Director - Global Shared Services; Accounting Supervisor - Corporate Shared Services; abchammers.com; Aerospace & Defense |
| Personal Email / Unclassified Contact | 19 | gmail.com; aol.com; hotmail.com; icloud.com |
| Training / Academic / Standards | 10 | ALISON WETZEL; ALLISON; Allison Gioseffi; Allison Lester |
| Legal / Compliance / Insurance Advisor | 7 | mooreinsuranceoptions.com; Counsel confirms Ryan/MCG document structure matches AGIP; Before signing Counsel confirms AGIP; Before signing','Counsel confirms Ryan/MCG document structure matches AGIP |
| Aerospace & Defense OEM / Manufacturer | 6 | circor.com; ALBERTO; moog.com; SILLART |
| Shipbuilding / Submarine Defense Prime | 5 | Bromley; Cheradyn; gdeb.com; Justin |
| Defense Industrial Base Program / Partner | 4 | blueforgealliance.us; accounting@blueforgealliance.u; accounting@blueforgealliance.us; BlueForge Alliance |
| Defense Training / Simulation Partner | 4 | c4ats.co; c4ats.com; accounting@c4ats.com; ACCOUNTING@C4ATS.COM; Francisco.Hernandez@C4ATS.co |
| Government / Civil Agency | 4 | dol.gov; hcfl.gov; rickscott.senate.gov; uscis.dhs.gov |
| Legal Counsel / Law Firm | 3 | jenner.com; bcalaw.com; jenner.com |
| Metrology / Industrial Equipment | 3 | Smith; Annette; seilerinst.com |
| Defense / Precision Manufacturing Customer | 3 | Williams; cogitic.net; Mike |
| Finance / Factoring / Working Capital | 3 | republicfundus.com; vivacf.net; republicfundus.com |
| Personal/ISP Email / Unclassified Contact | 3 | tampabay.rr.com; AMS.METAL@TAMPABAY.RR.COM; amwi@tampabay.rr.com |
| Finance / Funding / Broker | 2 | aamericanfinancialsvc.com; aamericanfinancialsvc.com |
| Internal / RigFab / TBA System | 2 | rigfab.com; rigfab.com |
| AI / Research Tool | 2 | perplexity.ai; perplexity.ai |
| Finance / Capital Advisor | 2 | adelphicapitalpartners.com; legacycapitalpartners.com |
| Industrial Gas / MRO Supplier | 2 | airgas.com; amy.jones@airgas.com |
| Defense Vehicle Propulsion / Industrial OEM | 2 | allisontransmission.com; alexandria.sigman@allisontransmission.com |
| Banking / Finance | 2 | citynational.com; service.citynational.com |
| Shipbuilding / Defense Prime | 2 | hii-nns.com; Amanda.L.Moore@hii-nns.com |
| Additive Manufacturing / Industrial Technology | 1 | 3dsystems.com |
| Professional Services / Management Consulting | 1 | alvarezandmarsal.com |
| Finance / Growth Capital | 1 | amgrowth.com |
| Insurance / Risk Advisor | 1 | bbrown.com |
| Finance / Commercial Capital | 1 | blackhawkcommercialcapital.com |
| Industrial / Manufacturing Supplier | 1 | camco-ne.com |
| Workflow / E-signature Platform | 1 | docusign.net |
| Defense Electronics / OEM | 1 | drs.com |
| Machine Tool OEM / Equipment Supplier | 1 | mazakcorp.com |
| Workflow / Transcription Tool | 1 | otter.ai |
| Manufacturing Software / RFQ Platform | 1 | paperlessparts.com |
| Metal Supplier / Materials | 1 | seafaring-metals.com |
| Aerospace Parts Distributor / Defense Supplier | 1 | sealdynamics.com |
| Telecom / Wireless Vendor | 1 | verizonwireless.com |
| Source | Rows |
|---|---|
| local_rule | 1,037,981 |
| preserved_existing_category | 7,540 |
| local_keyword_rule | 2,749 |
| local_domain_rule | 159 |
| source_category_rule | 119 |
| perplexity_web | 27 |
| Old final_category | Refined category | Rows |
|---|---|---|
| Internal / Other / Unknown | Blank / Worksheet Padding | 1,036,247 |
| Suppliers / Vendors / Service Providers | Suppliers / Vendors / Service Providers | 5,010 |
| Customers / Prospects | Customers / Prospects | 2,530 |
| Internal / Other / Unknown | Internal / Tampa Brass Team | 1,186 |
| Internal / Other / Unknown | Personal / Individual Contact - Needs Review | 880 |
| Internal / Other / Unknown | Needs Manual Review / Unresolved Relationship | 854 |
| Internal / Other / Unknown | Software / IT / Workflow Tool | 467 |
| Partners / Advisors / Government | Government / Military / DoD | 288 |
| Internal / Other / Unknown | Defense Prime / Aerospace & Security | 261 |
| Internal / Other / Unknown | Manufacturing / Industrial Supplier | 197 |
| Partners / Advisors / Government | Internal / Tampa Brass Team | 162 |
| Partners / Advisors / Government | Partner / Affiliate - Needs Detail | 119 |
| Partners / Advisors / Government | Finance / Capital / Lender / Advisor | 100 |
| Partners / Advisors / Government | Software / IT / Workflow Tool | 55 |
| Internal / Other / Unknown | Professional Services / Consulting | 41 |
| Internal / Other / Unknown | Government / Military / DoD | 36 |
| Internal / Other / Unknown | Finance / Capital / Lender / Advisor | 26 |
| Internal / Other / Unknown | Personal Email / Unclassified Contact | 18 |
| Internal / Other / Unknown | Training / Academic / Standards | 10 |
| Partners / Advisors / Government | Manufacturing / Industrial Supplier | 9 |
| Internal / Other / Unknown | Aerospace & Defense OEM / Manufacturer | 6 |
| Partners / Advisors / Government | Legal / Compliance / Insurance Advisor | 6 |
| Internal / Other / Unknown | Shipbuilding / Submarine Defense Prime | 5 |
| Internal / Other / Unknown | Defense Industrial Base Program / Partner | 4 |
| Internal / Other / Unknown | Defense Training / Simulation Partner | 4 |
| Internal / Other / Unknown | Government / Civil Agency | 4 |
| Internal / Other / Unknown | Legal Counsel / Law Firm | 3 |
| Partners / Advisors / Government | Defense Prime / Aerospace & Security | 3 |
| Internal / Other / Unknown | Metrology / Industrial Equipment | 3 |
| Internal / Other / Unknown | Defense / Precision Manufacturing Customer | 3 |
| Internal / Other / Unknown | Personal/ISP Email / Unclassified Contact | 3 |
| Internal / Other / Unknown | Finance / Funding / Broker | 2 |
| Internal / Other / Unknown | Internal / RigFab / TBA System | 2 |
| Internal / Other / Unknown | Finance / Capital Advisor | 2 |
| Internal / Other / Unknown | Industrial Gas / MRO Supplier | 2 |
| Internal / Other / Unknown | Defense Vehicle Propulsion / Industrial OEM | 2 |
| Internal / Other / Unknown | Banking / Finance | 2 |
| Internal / Other / Unknown | Shipbuilding / Defense Prime | 2 |
| Internal / Other / Unknown | Finance / Factoring / Working Capital | 2 |
| Partners / Advisors / Government | AI / Research Tool | 1 |
| Internal / Other / Unknown | Additive Manufacturing / Industrial Technology | 1 |
| Internal / Other / Unknown | Professional Services / Management Consulting | 1 |
| Internal / Other / Unknown | Finance / Growth Capital | 1 |
| Internal / Other / Unknown | Insurance / Risk Advisor | 1 |
| Internal / Other / Unknown | Finance / Commercial Capital | 1 |
| Internal / Other / Unknown | Industrial / Manufacturing Supplier | 1 |
| Internal / Other / Unknown | Workflow / E-signature Platform | 1 |
| Internal / Other / Unknown | Defense Electronics / OEM | 1 |
| Internal / Other / Unknown | Machine Tool OEM / Equipment Supplier | 1 |
| Internal / Other / Unknown | Legal / Compliance / Insurance Advisor | 1 |
| Internal / Other / Unknown | Workflow / Transcription Tool | 1 |
| Internal / Other / Unknown | Manufacturing Software / RFQ Platform | 1 |
| Internal / Other / Unknown | AI / Research Tool | 1 |
| Internal / Other / Unknown | Metal Supplier / Materials | 1 |
| Internal / Other / Unknown | Aerospace Parts Distributor / Defense Supplier | 1 |
| Internal / Other / Unknown | Telecom / Wireless Vendor | 1 |
| Partners / Advisors / Government | Personal Email / Unclassified Contact | 1 |
| Partners / Advisors / Government | Finance / Factoring / Working Capital | 1 |