All AutosheetBench tasks

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 and starting spreadsheet

Task files

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_score in column J: a whole number from 1 to 10. - tier in 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
ABCDEFGHI
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotes
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Aster Analytics is evaluating Analytics Cloud fo…
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Atlas Analytics is evaluating Forecasting Pro for a …
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Aurora Analytics is evaluating Research Workspace for …
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Beacon Analytics is evaluating Workflow Suite for a team o…
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Curious but no timeline. Follow up again in two months. Bluebird Analytics is evaluating Security Hub for a team of 71…
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Cedar Analytics is evaluating Support Desk for a…
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Cirrus Analytics is evaluating Data Connector for a …
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Cobalt Analytics is evaluating Billing Automation for …
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Delta Analytics is evaluating Analytics Cloud for a team o…
11Ember Analyticsemberanalytics.comLogistics900$33.8MJapanLeila AhmedProcurement ManagerCold outreach reply. Curious but no timeline. Follow up again in two months. Ember Analytics is evaluating Forecasting Pro for a team of 15…
12Evergreen Analyticsevergreenanalytics.commanufacturing6037,500,000GermanyPriya AhmedVP of SalesMet at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Evergreen Analytics is evaluating Research Works…
13Fjord Analyticsfjordanalytics.comsaas600041200000USAAndrei AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Fjord Analytics is evaluating Workflow Suite for a t…
14Harbor Analyticsharboranalytics.comSoftware320$44.9MUnited StatesHaruto AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Harbor Analytics is evaluating Security Hub for a team…
15Helio Analyticshelioanalytics.comSaaS2548,600,000DeutschlandMina AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Helio Analytics is evaluating Support Desk for a team of 2…
16Juniper Analyticsjuniperanalytics.comretail250052300000GermanySofia AhmedProcurement ManagerCold outreach reply. Curious but no timeline. Follow up again in two months. Juniper Analytics is evaluating Data Connector for a team of 2…
17Keystone Analyticskeystoneanalytics.comsaas140$56MUnited StatesDiego AhmedVP of SalesMet at conference; evaluating a replacement for their legacy tool. Budget approved for Q4. Keystone Analytics is evaluating Billing Automat…
18Lattice Analyticslatticeanalytics.comFintech859,700,000FRKai AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Lattice Analytics is evaluating Analytics Cloud for …
19Lumina Analyticsluminaanalytics.comManufacturing250063400000DEPavel AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Lumina Analytics is evaluating Forecasting Pro for a t…
20Meridian Analyticsmeridiananalytics.com140$67.1MBrasilAmina AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Meridian Analytics is evaluating Research Workspace for a …
21Nimbus Analyticsnimbusanalytics.comretail870,800,000United StatesHanna AhmedProcurement ManagerCold 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.5
Sheet12,002 cells changed

K2=IF(J2="","",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…7Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…5Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …4Low
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…8High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

How each AI configuration did

20 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

Each must be met on at least 98% of rows.
  • J2:J1001, headed "icp_score": filled with numbers
  • K2: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

Passed1m 21s · 40¢
Sheet12,002 cells changed

K2=IF(J2="","",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…7Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…5Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …4Low
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…8High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Autosheet in Excel GPT-6 Astra · Low

Passed1m 51s · 44¢
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…8High
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…6Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …8High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…10High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…5Medium
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…9High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…9High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …4Medium

10 of 1,001 rows

Autosheet in Sheets Opus 5.5 · Medium

Passed3m 7s · 52¢
Sheet12,002 cells changed

K2=IF(J2>=7,"High",IF(J2>=4,"Medium","Low"))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…5Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …4Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…7High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…7High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Autosheet in Excel Sonnet 5.5 · Medium

Passed1m · 30¢
Sheet12,002 cells changed

K2=IF(J2="","Medium",IF(VALUE(J2)>=8,"High",IF(VALUE(J2)>=5,"Medium","Low")))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …5Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…7Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …4Low

10 of 1,001 rows

Claude in Excel Opus 5.5 · High

Passed1m 34s · 49¢
Sheet12,002 cells changed · 1 other sheet changed

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)))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …4Low
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…6Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…7Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Autosheet in Excel Haiku 5.5 · High

Passed1m 54s · 7¢
Sheet12,002 cells changed
ABCDEFGHIJKL
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…4Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…2Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …6Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…4Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…1Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…7High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…4Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …1Low

10 of 1,001 rows

Claude in Sheets Opus 5.5 · Medium

Passed1m 14s · 29¢
Sheet12,002 cells changed · 1 other sheet changed

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))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …5Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…6Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…6Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Autosheet in Excel GPT-6.1 Sol · Medium

Passed2m 1s · 53¢
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…3Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…7High
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…6Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …7High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…5Medium
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…8High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …5Medium

10 of 1,001 rows

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 31s · N/A
Sheet12,002 cells changed

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…

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…7Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …3Low
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…8High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low

10 of 1,001 rows

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed3m 33s · N/A
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…5Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …8High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…4Medium
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…7High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…5Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …5Medium

10 of 1,001 rows

Autosheet in Sheets Haiku 5.5 · High

Passed4m 24s · 31¢
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …8High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…6Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…8High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…4Low
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low

10 of 1,001 rows

ChatGPT in Excel GPT-6 Astra · Medium

Passed2m 7s · $1.17
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …6Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…9High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low

10 of 1,001 rows

Claude in Excel Haiku 5.5 · High

Passed1m 4s · 2¢
Sheet12,002 cells changed · 1 other sheet changed

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)))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …5Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…6Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…5Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…5Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Claude in Sheets Haiku 5.5 · High

Passed2m 16s · 4¢
Sheet12,033 cells changed

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)))

ABCDEFGHIJKLMN
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretierICP scoring assumptions
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…2LowEmployees (min)Points
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…5Low01
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low502
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …7Medium1003
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…6Low2004
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low1,0005
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…7Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…5LowAnnual revenue (min, USD)Points
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low$01

10 of 1,001 rows

Autosheet in Excel GPT-6 Luna · High

Passed2m 7s · 47¢
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…7Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …10High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…5Medium
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…10High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…8High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low

10 of 1,001 rows

Copilot in Excel Auto

Passed54s · N/A
ICP ScoringNew sheet · 10,852 cells changed

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))))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet 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…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Atlas Analytics is evaluating Forecasting Pro for a team of 20; target de…7Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Aurora Analytics is evaluating Research Workspace for a team of 37; target…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Beacon Analytics is evaluating Workflow Suite for a team of 54; target decision…6Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold 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…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet 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…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. Team of 12 analysts, currently on spreadsheets. Price sensitive. Cirrus Analytics is evaluating Data Connector for a team of 105; target d…7Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champion left the company. Need an executive sponsor re-engagement. Cobalt Analytics is evaluating Billing Automation for a team of 122; target…5Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: piloting in one region, wants a global rollout next year. Delta Analytics is evaluating Analytics Cloud for a team of 139; target decisio…2Low

10 of 1,001 rows

ChatGPT + Drive MCP GPT-6 · Medium

Passed49s · N/A
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…5Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …9High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…6Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…9High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…6Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

ChatGPT in Excel GPT-6 Luna · High

Passed1m 11s · 1¢
Sheet12,002 cells changed
ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…8High
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…5Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …9High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…10High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…7Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 19s · 83¢
Sheet12,002 cells changed

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))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…8High
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…5Medium
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …7Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…9High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…4Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…9High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…9High
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …3Low

10 of 1,003 rows

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 40s · 0.9¢
Sheet12,002 cells changed

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))

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…8High
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…4Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …9High
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…8High
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…10High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…7Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Failed 2

Claude Code + Sheets MCP Opus 5.5 · Medium

Failed1m 53s · N/A
Sheet1600 cells changed · 1 other sheet changed

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)

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…3Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …5Low
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…7Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…3Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…6Medium
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…5Low
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …2Low

10 of 1,001 rows

Why it failed: 701 rows were left empty. The quality judge rejected 38 of 50 sampled rows.

  • Row 607 · Sourcecompany: 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 · Sourcecompany: 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

Failed3m 36s · N/A
Sheet12,002 cells changed

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)

ABCDEFGHIJK
1companydomainindustry_rawemployee_countannual_revenue_rawcountry_rawcontact_nametitlenotesicp_scoretier
2Aster Analyticsasteranalytics.com8$0.5MUSAAlex AhmedVP of SalesMet at conference; eval…1Low
3Atlas Analyticsatlasanalytics.comlogistics9004,200,000BRFatima AhmedHead of MarketingInbound demo request. T…6Medium
4Aurora Analyticsauroraanalytics.comSoftware607900000United StatesLuca AhmedCTORenewal at risk, champi…7Low
5Beacon Analyticsbeaconanalytics.comretail6000$11.6MDeutschlandRavi AhmedIT DirectorExpansion opportunity: …5Medium
6Bluebird Analyticsbluebirdanalytics.comMfg32015,300,000USACamila AhmedProcurement ManagerCold outreach reply. Cu…6Medium
7Cedar Analyticscedaranalytics.comlogistics2519000000BrasilInes AhmedVP of SalesMet at conference; eval…2Low
8Cirrus Analyticscirrusanalytics.comFinTech2500$22.7MDeutschlandNora AhmedHead of MarketingInbound demo request. T…9High
9Cobalt Analyticscobaltanalytics.comFintech14026,400,000UKTomas AhmedCTORenewal at risk, champi…10Medium
10Delta Analyticsdeltaanalytics.comretail830100000DEElena AhmedIT DirectorExpansion opportunity: …1Medium

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 · Sourcecompany: 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 · Sourcecompany: 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.