Score companies for customer fit
Bulk data processingMediumWhole-set scoringLatest run
Passed by 10 of 12 products on their best model. Failed: Claude Code + Sheets MCP and Gemini in Sheets.
Prompt
Score each company as an ideal-customer-profile (ICP) fit. We are an HR solution targetting mature companies with hundreds of employees. We target especially tech-savy companies. Add two new columns: -
icp_scorein column J: a whole number from 1 to 10. -tierin column K: one of Low, Medium, High. Base it on company size and revenue. Fill every row.
Starting spreadsheet
Sheet1 · rows 1–21 of 1,001| A | B | C | D | E | F | G | H | I | |
|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Aster Analytics is evaluating Analytics Cloud fo… | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Atlas Analytics is evaluating Forecasting Pro for a … |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Aurora Analytics is evaluating Research Workspace for … |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Beacon Analytics is evaluating Workflow Suite for a team o… |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Bluebird Analytics is evaluating Security Hub for a team of 71… |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Cedar Analytics is evaluating Support Desk for a… |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Cirrus Analytics is evaluating Data Connector for a … |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Cobalt Analytics is evaluating Billing Automation for … |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Delta Analytics is evaluating Analytics Cloud for a team o… |
| 11 | Ember Analytics | emberanalytics.com | Logistics | 900 | $33.8M | Japan | Leila Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Ember Analytics is evaluating Forecasting Pro for a team of 15… |
| 12 | Evergreen Analytics | evergreenanalytics.com | manufacturing | 60 | 37,500,000 | Germany | Priya Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Evergreen Analytics is evaluating Research Works… |
| 13 | Fjord Analytics | fjordanalytics.com | saas | 6000 | 41200000 | USA | Andrei Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Fjord Analytics is evaluating Workflow Suite for a t… |
| 14 | Harbor Analytics | harboranalytics.com | Software | 320 | $44.9M | United States | Haruto Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Harbor Analytics is evaluating Security Hub for a team… |
| 15 | Helio Analytics | helioanalytics.com | SaaS | 25 | 48,600,000 | Deutschland | Mina Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Helio Analytics is evaluating Support Desk for a team of 2… |
| 16 | Juniper Analytics | juniperanalytics.com | retail | 2500 | 52300000 | Germany | Sofia Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Juniper Analytics is evaluating Data Connector for a team of 2… |
| 17 | Keystone Analytics | keystoneanalytics.com | saas | 140 | $56M | United States | Diego Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Keystone Analytics is evaluating Billing Automat… |
| 18 | Lattice Analytics | latticeanalytics.com | Fintech | 8 | 59,700,000 | FR | Kai Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Lattice Analytics is evaluating Analytics Cloud for … |
| 19 | Lumina Analytics | luminaanalytics.com | Manufacturing | 2500 | 63400000 | DE | Pavel Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Lumina Analytics is evaluating Forecasting Pro for a t… |
| 20 | Meridian Analytics | meridiananalytics.com | 140 | $67.1M | Brasil | Amina Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Meridian Analytics is evaluating Research Workspace for a … | |
| 21 | Nimbus Analytics | nimbusanalytics.com | retail | 8 | 70,800,000 | United States | Hanna Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Nimbus Analytics is evaluating Data Connector for a team of 28… |
A passing output
Autosheet in Excel · Opus 5.5K2=IF(J2="","",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 4 | Low |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Pass criteria
Each must be met on at least 98% of rows.J2:J1001, headed "icp_score": filled with numbersK2:K1001, headed "tier": filled with "Low", "Medium" or "High"
Quality: 45 of 50 sampled rows must pass an LLM judge
- Treat employee count and annual revenue as the primary evidence of company maturity and fit for an HR solution targeting companies with hundreds of employees.
- Use industry, company identity, and domain only as reasonable supporting evidence of technical orientation; do not invent missing company facts.
- A small company with low revenue should score materially below a mature company with hundreds of employees and substantial revenue unless the row contains strong contrary evidence.
- Use the full 1-10 scale directionally rather than requiring one exact score; nearby scores and adjacent tiers are acceptable when the evidence is genuinely borderline.
- The tier must be internally consistent with the score: lower scores should be Low, middle scores Medium, and higher scores High. The prompt does not prescribe exact numeric cutoffs.
Decision rule: PASS when the score and tier are directionally defensible from the row's employee count, revenue, and available technical-orientation signals. Do not require one exact score, one exact tier boundary, or penalize a reasonable nearby calibration. FAIL when the result clearly reverses the maturity evidence, ignores a material size or revenue signal, invents unsupported facts, or uses a tier inconsistent with the submission's score ordering. Empty values and spreadsheet errors always fail.
Passed 20
Autosheet in Excel Opus 5.5 · Medium
K2=IF(J2="","",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 4 | Low |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Autosheet in Excel GPT-6 Astra · Low
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 6 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 8 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 10 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 5 | Medium |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 9 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 9 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 4 | Medium |
10 of 1,001 rows
Autosheet in Sheets Opus 5.5 · Medium
K2=IF(J2>=7,"High",IF(J2>=4,"Medium","Low"))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 5 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 4 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 7 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 7 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Autosheet in Excel Sonnet 5.5 · Medium
K2=IF(J2="","Medium",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 4 | Low |
10 of 1,001 rows
Claude in Excel Opus 5.5 · High
J2=LET(_xlpm.raw,TRIM(E2),_xlpm.isM,RIGHT(_xlpm.raw,1)="M",_xlpm.num,NUMBERVALUE(SUBSTITUTE(IF(_xlpm.isM,LEFT(_xlpm.raw,LEN(_xlpm.raw)-1),_xlpm.raw),"$",""),".",","),_xlpm.revenue,IF(_xlpm.isM,_xlpm.num*1000000,_xlpm.num),_xlpm.sizePts,LOOKUP(D2,'ICP Criteria'!$A$6:$A$11,'ICP Criteria'!$C$6:$C$11),_xlpm.revPts,LOOKUP(_xlpm.revenue,'ICP Criteria'!$A$15:$A$18,'ICP Criteria'!$C$15:$C$18),_xlpm.techPts,IF(ISNUMBER(MATCH(TRIM(C2),'ICP Criteria'!$A$23:$A$26,0)),'ICP Criteria'!$C$21,0),MIN(10,MAX(1,_xlpm.sizePts+_xlpm.revPts+_xlpm.techPts)))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 4 | Low |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 7 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Autosheet in Excel Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier | |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | ||
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 4 | Medium | |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 2 | Low | |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 6 | Medium | |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 4 | Medium | |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 7 | High | |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 4 | Medium | |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 1 | Low |
10 of 1,001 rows
Claude in Sheets Opus 5.5 · Medium
J2=LET(t,SUBSTITUTE(SUBSTITUTE(E2,"$",""),",",""),rev,IF(RIGHT(t)="M",VALUE(LEFT(t,LEN(t)-1))*1000000,VALUE(t)),'ICP Rubric'!$B$13+VLOOKUP(D2,'ICP Rubric'!$A$5:$B$11,2,TRUE)+VLOOKUP(rev,'ICP Rubric'!$D$5:$E$9,2,TRUE))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 6 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Autosheet in Excel GPT-6.1 Sol · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 3 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 7 | High |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 6 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 7 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 5 | Medium |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
10 of 1,001 rows
Claude Code + Autosheet MCP Opus 5.5 · Medium
J2=IFERROR(__xludf.DUMMYFUNCTION("LET( empTxt, LOWER(REGEXREPLACE(TO_TEXT(D2), "","", """")), empBase, IFERROR(AVERAGE(SPLIT(TRIM(REGEXREPLACE(empTxt, ""[^0-9.]+"", "" "")), "" "")), -1), emp, IF(empBase < 0, -1, empBase * IF(REGEXMATCH(empTxt, ""[0-9.]\s*k\b""), 1000, 1)), revTxt, LO"&"WER(REGEXREPLACE(TO_TEXT(E2), "","", """")), revBase, IFERROR(AVERAGE(SPLIT(TRIM(REGEXREPLACE(revTxt, ""[^0-9.]+"", "" "")), "" "")), -1), revMult, IF(REGEXMATCH(revTxt, ""[0-9.]\s*(b|bn|billion)\b""), 1000000000, IF(REGEXMATCH(revTxt, ""[0-9.]\s*(m|mm|"&"mn|million)\b""), 1000000, IF(REGEXMATCH(revTxt, ""[0-9.]\s*(k|thousand)\b""), 1000, 1))), rev, IF(revBase < 0, -1, revBase * revMult), sizePts, IF(emp < 0, 2, IF(AND(emp >= 200, emp <= 2000), 6, IF(OR(AND(emp >= 100, emp < 200), AND(emp > 2000, emp <= "&"3000)), 3, IF(OR(AND(emp >= 50, emp < 100), AND(emp > 3000, emp <= 5000)), 2, IF(emp > 5000, 1, 0))))), revPts, IF(rev < 0, 1, IF(AND(rev >= 20000000, rev <= 1000000000), 2, IF(OR(AND(rev >= 5000000, r…
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
10 of 1,001 rows
ChatGPT + Autosheet MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 5 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 8 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 4 | Medium |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 7 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
10 of 1,001 rows
Autosheet in Sheets Haiku 5.5 · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 8 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 6 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Astra · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 6 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 9 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
10 of 1,001 rows
Claude in Excel Haiku 5.5 · High
J2=LET(_xlpm.t,SUBSTITUTE(SUBSTITUTE(E2,"$",""),",",""),_xlpm.rev,IF(RIGHT(_xlpm.t,1)="M",NUMBERVALUE(LEFT(_xlpm.t,LEN(_xlpm.t)-1),".")*1000000,NUMBERVALUE(_xlpm.t,".")),INDEX('ICP Assumptions'!$B$5:$B$9,MATCH(D2,'ICP Assumptions'!$A$5:$A$9,1))+INDEX('ICP Assumptions'!$E$5:$E$9,MATCH(_xlpm.rev,'ICP Assumptions'!$D$5:$D$9,1)))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 6 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 5 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Claude in Sheets Haiku 5.5 · High
J2=LET(rev, IF(ISNUMBER(FIND("M",E2)), VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E2,"$",""),"M",""),",",""))*1000000, VALUE(SUBSTITUTE(SUBSTITUTE(E2,"$",""),",",""))), INDEX($N$3:$N$7,MATCH(D2,$M$3:$M$7,1)) + INDEX($N$10:$N$14,MATCH(rev,$M$10:$M$14,1)))
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier | ICP scoring assumptions | ||
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 2 | Low | Employees (min) | Points | ||
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 5 | Low | 0 | 1 | |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low | 50 | 2 | |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 7 | Medium | 100 | 3 | |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 6 | Low | 200 | 4 | |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low | 1,000 | 5 | |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium | |||
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 5 | Low | Annual revenue (min, USD) | Points | |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low | $0 | 1 |
10 of 1,001 rows
Autosheet in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 7 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 10 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 5 | Medium |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 10 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 8 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
10 of 1,001 rows
Copilot in Excel Auto
J2=LET(_xlpm.e,D2,_xlpm.r,E2,_xlpm.rv,IF(ISNUMBER(_xlpm.r),_xlpm.r,LET(_xlpm.s,SUBSTITUTE(SUBSTITUTE(_xlpm.r,"$",""),",",""),IF(RIGHT(_xlpm.s,1)="M",NUMBERVALUE(LEFT(_xlpm.s,LEN(_xlpm.s)-1),".",",")*1000000,IF(RIGHT(_xlpm.s,1)="B",NUMBERVALUE(LEFT(_xlpm.s,LEN(_xlpm.s)-1),".",",")*1000000000,NUMBERVALUE(_xlpm.s,".",","))))),_xlpm.es,IFS(_xlpm.e<25,1,_xlpm.e<60,2,_xlpm.e<140,4,_xlpm.e<320,6,_xlpm.e<900,9,_xlpm.e<2500,10,_xlpm.e<6000,9,TRUE,8),_xlpm.rs,IFS(_xlpm.rv<10000000,1,_xlpm.rv<25000000,2,_xlpm.rv<50000000,3,_xlpm.rv<100000000,4,_xlpm.rv<250000000,6,_xlpm.rv<500000000,8,_xlpm.rv<1000000000,9,TRUE,10),MAX(1,MIN(10,ROUND(_xlpm.es*0.65+_xlpm.rs*0.35,0))))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Aster Analytics is evaluating Analytics Cloud for a team of 3; target… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Atlas Analytics is evaluating Forecasting Pro for a team of 20; target de… | 7 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Aurora Analytics is evaluating Research Workspace for a team of 37; target… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Beacon Analytics is evaluating Workflow Suite for a team of 54; target decision… | 6 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Curious but no timeline. Follow up again in two months. Bluebird Analytics is evaluating Security Hub for a team of 71; target decision in… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Cedar Analytics is evaluating Support Desk for a team of 88; target d… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Cirrus Analytics is evaluating Data Connector for a team of 105; target d… | 7 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champion left the company. Need an executive sponsor re-engagement. Cobalt Analytics is evaluating Billing Automation for a team of 122; target… | 5 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: piloting in one region, wants a global rollout next year. Delta Analytics is evaluating Analytics Cloud for a team of 139; target decisio… | 2 | Low |
10 of 1,001 rows
ChatGPT + Drive MCP GPT-6 · Medium
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 9 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 6 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 9 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 6 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
ChatGPT in Excel GPT-6 Luna · High
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 9 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 10 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 7 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
ChatGPT in Sheets GPT-6 Astra · Medium
J2=MIN(10,1+IF(IFERROR(VALUE(D2),0)<20,0,IF(IFERROR(VALUE(D2),0)<50,1,IF(IFERROR(VALUE(D2),0)<100,2,IF(IFERROR(VALUE(D2),0)<200,5,IF(IFERROR(VALUE(D2),0)<1000,6,IF(IFERROR(VALUE(D2),0)<5000,5,4))))))+IF(IFERROR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(E2),"$",""),",",""),"K","E3"),"M","E6"),"B","E9")),0)>=10000000,2,IF(IFERROR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(UPPER(E2),"$",""),",",""),"K","E3"),"M","E6"),"B","E9")),0)>=1000000,1,0))+IF(OR(ISNUMBER(SEARCH("software",C2)),ISNUMBER(SEARCH("saas",C2)),ISNUMBER(SEARCH("fintech",C2)),ISNUMBER(SEARCH("technology",C2)),ISNUMBER(SEARCH("e-commerce",C2)),ISNUMBER(SEARCH("ecommerce",C2))),1,0))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 5 | Medium |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 7 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 9 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 4 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 9 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 9 | High |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 3 | Low |
10 of 1,003 rows
ChatGPT in Sheets GPT-6 Luna · High
J2=LET(rev,IF(ISNUMBER(E2),E2,IFERROR(VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(E2,"$",""),"M",""),",",""))*IF(ISNUMBER(SEARCH("M",E2)),1000000,1),0)),sizeScore,IF(D2>=5000,8,IF(D2>=1000,9,IF(D2>=500,8,IF(D2>=200,7,IF(D2>=100,5,IF(D2>=50,3,1)))))),revScore,IF(rev>=500000000,3,IF(rev>=50000000,2,IF(rev>=10000000,1,0))),techBonus,IF(OR(ISNUMBER(SEARCH("software",C2)),ISNUMBER(SEARCH("saas",C2)),ISNUMBER(SEARCH("tech",C2)),ISNUMBER(SEARCH("fintech",C2)),ISNUMBER(SEARCH("data",C2)),ISNUMBER(SEARCH("analytics",C2)),ISNUMBER(SEARCH("cloud",C2)),ISNUMBER(SEARCH("cyber",C2)),ISNUMBER(SEARCH("information technology",C2)),ISNUMBER(SEARCH("artificial intelligence",C2))),1,0),MIN(10,sizeScore+revScore+techBonus))
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 8 | High |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 4 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 9 | High |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 8 | High |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 10 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 7 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Failed 2
Claude Code + Sheets MCP Opus 5.5 · Medium
J2=1+VLOOKUP($D2,'ICP scoring'!$A$2:$B$8,2,TRUE)+VLOOKUP(IF(RIGHT($E2)="M",VALUE(SUBSTITUTE(SUBSTITUTE($E2,"$",""),"M",""))*1000000,VALUE(SUBSTITUTE($E2,",",""))),'ICP scoring'!$D$2:$E$6,2,TRUE)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 3 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 5 | Low |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 7 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 3 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 5 | Low |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 2 | Low |
10 of 1,001 rows
Why it failed: 701 rows were left empty. The quality judge rejected 38 of 50 sampled rows.
- Row 607 · Source
company: Cedar Robotics domain: cedarrobotics.com employee_count: 320 annual_revenue_raw: 2239000000 country_raw: United Kingdom
- Written
- icp_score: tier:
Assign an icp_score (1-10) and tier (Low, Medium, or High) based on employee count and revenue.
- Row 507 · Source
company: Pioneer Networks domain: pioneernetworks.com industry_raw: fintech employee_count: 60 annual_revenue_raw: 1,869,000,000 country_raw: Brazil
- Written
- icp_score: tier:
Assign an icp_score (1-10) and tier (Low, Medium, or High) based on employee count and revenue.
Gemini in Sheets Auto
J2=IFERROR(__xludf.DUMMYFUNCTION("IFS(AND(D2>=100, D2<1000, REGEXMATCH(LOWER(C2&"" ""&A2), ""saas|software|fintech"")), 10, AND(D2>=1000, REGEXMATCH(LOWER(C2&"" ""&A2), ""saas|software|fintech"")), 9, AND(D2>=100, D2<1000, REGEXMATCH(LOWER(C2&"" ""&A2), ""e-commerce|commerce"")), 8, AND(D"&"2>=50, D2<100, REGEXMATCH(LOWER(C2&"" ""&A2), ""saas|software|fintech"")), 7, AND(D2>=100, D2<1000), 6, AND(D2<50, REGEXMATCH(LOWER(C2&"" ""&A2), ""saas|software|fintech"")), 6, D2>=1000, 5, AND(D2<50, REGEXMATCH(LOWER(C2&"" ""&A2), ""e-commerce|commerce"&""")), 4, AND(D2>=50, D2<100), 3, D2>=20, 2, TRUE, 1)"),1.0)
| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | company | domain | industry_raw | employee_count | annual_revenue_raw | country_raw | contact_name | title | notes | icp_score | tier |
| 2 | Aster Analytics | asteranalytics.com | 8 | $0.5M | USA | Alex Ahmed | VP of Sales | Met at conference; eval… | 1 | Low | |
| 3 | Atlas Analytics | atlasanalytics.com | logistics | 900 | 4,200,000 | BR | Fatima Ahmed | Head of Marketing | Inbound demo request. T… | 6 | Medium |
| 4 | Aurora Analytics | auroraanalytics.com | Software | 60 | 7900000 | United States | Luca Ahmed | CTO | Renewal at risk, champi… | 7 | Low |
| 5 | Beacon Analytics | beaconanalytics.com | retail | 6000 | $11.6M | Deutschland | Ravi Ahmed | IT Director | Expansion opportunity: … | 5 | Medium |
| 6 | Bluebird Analytics | bluebirdanalytics.com | Mfg | 320 | 15,300,000 | USA | Camila Ahmed | Procurement Manager | Cold outreach reply. Cu… | 6 | Medium |
| 7 | Cedar Analytics | cedaranalytics.com | logistics | 25 | 19000000 | Brasil | Ines Ahmed | VP of Sales | Met at conference; eval… | 2 | Low |
| 8 | Cirrus Analytics | cirrusanalytics.com | FinTech | 2500 | $22.7M | Deutschland | Nora Ahmed | Head of Marketing | Inbound demo request. T… | 9 | High |
| 9 | Cobalt Analytics | cobaltanalytics.com | Fintech | 140 | 26,400,000 | UK | Tomas Ahmed | CTO | Renewal at risk, champi… | 10 | Medium |
| 10 | Delta Analytics | deltaanalytics.com | retail | 8 | 30100000 | DE | Elena Ahmed | IT Director | Expansion opportunity: … | 1 | Medium |
10 of 1,001 rows
Why it failed: 2 tiers don't fit the score. The quality judge rejected 17 of 50 sampled rows.
- Row 507 · Source
company: Pioneer Networks domain: pioneernetworks.com industry_raw: fintech employee_count: 60 annual_revenue_raw: 1,869,000,000 country_raw: Brazil
- Written
- icp_score: 7 tier: Medium
A score of 7 with tier Medium contradicts lower scores receiving High, and 60 employees is overscored.
- Row 225 · Source
company: Orbit Digital domain: orbitdigital.com industry_raw: logistics employee_count: 8 annual_revenue_raw: 825,600,000 country_raw: United Kingdom
- Written
- icp_score: 1 tier: Medium
For an ICP score of 1, the tier must be Low rather than Medium.