All AutosheetBench tasks

Summarize spend by department

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

Add a department spend summary to Sheet1 starting at H1. Use one header row, list the departments alphabetically, and calculate total spend with formulas.

Add average transaction size and transaction count to the same summary, using formulas for both.

Starting spreadsheet

Sheet1 · rows 1–21 of 52
ABCDEF
1Transaction IDDateDepartmentVendorCategoryAmount
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150
4TXN-0032024-01-07HRLinkedInRecruiting1200
5TXN-0042024-01-08FinanceQuickBooksSoftware450
6TXN-0052024-01-10OperationsFedExShipping380
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

A passing output

Autosheet in Excel · Opus 5.5
Sheet128 cells changed

I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering€23,370.5011€2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance€34,520.009€3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR€14,070.009€1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing€13,619.0011€1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations€6,086.8010€608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total€91,666.3050€1,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • H2:I6 hold the expected values
  • I2:K6 use formulas
  • Average transaction size and transaction count columns in either order (2 accepted ways)

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed32s · 11¢
Sheet128 cells changed

I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering€23,370.5011€2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance€34,520.009€3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR€14,070.009€1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing€13,619.0011€1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations€6,086.8010€608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total€91,666.3050€1,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Excel GPT-6 Astra · Low

Passed27s · 21¢
Sheet124 cells changed

H2=_xlws.SORT(UNIQUE(_xlws.FILTER(C2:C52,C2:C52<>"")))

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.50$2,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.00$3,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.00$1,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.00$1,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.80$608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Sheets Opus 5.5 · Medium

Passed30s · 9¢
Sheet124 cells changed

I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.5011$2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.009$3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.009$1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.0011$1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.8010$608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Excel Sonnet 5.5 · Medium

Passed16s · 4¢
Sheet128 cells changed

I2=SUMIFS($F$2:$F$51,$C$2:$C$51,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAverage Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.5011$2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.009$3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.009$1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.0011$1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.8010$608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total$91,666.3050$1,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude in Excel Opus 5.5 · High

Passed27s · 27¢
Sheet124 cells changed

I2=SUMIFS($F:$F,$C:$C,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.50112,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.0093,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.0091,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.00111,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.8010608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Excel Haiku 5.5 · High

Passed19s · 0.4¢
Sheet128 cells changed

I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAverage Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.50112,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.0093,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.0091,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.00111,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.8010608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total91,666.30501,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude in Sheets Opus 5.5 · Medium

Passed1m 7s · 22¢
Sheet128 cells changed

I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.5011$2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.009$3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.009$1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.0011$1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.8010$608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total$91,666.3050$1,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed1m 12s · N/A
Sheet124 cells changed

I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAverage Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.50112,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.0093,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.0091,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.00111,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.8010608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Excel GPT-6.1 Sol · Medium

Passed43s · 8¢
Sheet124 cells changed

H2=_xlws.SORT(UNIQUE(_xlws.FILTER(C2:C52,C2:C52<>"")))

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.502,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.003,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.001,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.001,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.80608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 21s · N/A
Sheet124 cells changed

I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23370.5112124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance3452093835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR1407091563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13619111238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6086.810608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed1m 42s · N/A
Sheet124 cells changed

I2=SUMIF($C$2:$C$51, H2, $F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.50$2,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.00$3,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.00$1,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.00$1,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.80$608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Sheets Haiku 5.5 · High

Passed56s · 0.4¢
Sheet128 cells changed

I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAverage Transaction
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.50112,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.0093,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.0091,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.00111,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.8010608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total91,666.30501,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT in Excel GPT-6 Astra · Medium

Passed31s · 84¢
Sheet124 cells changed

I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.502,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.003,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.001,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.001,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.80608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude in Excel Haiku 5.5 · High

Passed27s · 1¢
Sheet128 cells changed

I2=SUMIFS(Sheet1!$F:$F,Sheet1!$C:$C,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.50112,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.0093,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.0091,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.00111,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.8010608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total91,666.30501,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Claude in Sheets Haiku 5.5 · High

Passed1m 19s · 1¢
Sheet128 cells changed

I2=SUMIFS($F$2:$F1000,$C$2:$C1000,H2)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendTransaction CountAvg Transaction Size
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.5011$2,124.59
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.009$3,835.56
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.009$1,563.33
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.0011$1,238.09
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.8010$608.68
7TXN-0062024-01-11EngineeringGitHubSoftware840Total$91,666.3050$1,833.33
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Autosheet in Excel GPT-6 Luna · High

Passed23s · 0.5¢
Sheet124 cells changed

I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23370.52124.59090911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance345203835.5555569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR140701563.3333339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing136191238.09090911
6TXN-0052024-01-10OperationsFedExShipping380Operations6086.8608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Copilot in Excel Auto

Passed33s · N/A
Sheet124 cells changed

I2=SUMIF($C$2:$C$52,H2,$F$2:$F$52)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering€23,370.50€2,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance€34,520.00€3,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR€14,070.00€1,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing€13,619.00€1,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations€6,086.80€608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT + Drive MCP GPT-6 · Medium

Passed59s · N/A
Sheet124 cells changed

I2=SUMIF($C$2:$C1000,H2,$F$2:$F1000)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.502,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.003,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.001,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.001,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.80608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT in Excel GPT-6 Luna · High

Passed49s · 1¢
Sheet124 cells changed

I2=SUMIF($C:$C,H2,$F:$F)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.502,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.003,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.001,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.001,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.80608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

Gemini in Sheets Auto

Passed4m 22s · N/A
Sheet124 cells changed

I2=SUMIF($C:$C, H2, $F:$F)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.50$2,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.00$3,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.00$1,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.00$1,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.80$608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 5s · 79¢
Sheet124 cells changed

I2=SUMIF($C$2:$C$51,H2,$F$2:$F$51)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering23,370.502,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance34,520.003,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR14,070.001,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing13,619.001,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations6,086.80608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600

ChatGPT in Sheets GPT-6 Luna · High

Passed39s · 0.9¢
Sheet124 cells changed

I2=SUMIF($C:$C,H2,$F:$F)

ABCDEFGHIJK
1Transaction IDDateDepartmentVendorCategoryAmountDepartmentTotal SpendAverage Transaction SizeTransaction Count
2TXN-0012024-01-03EngineeringAWSCloud Services4820.5Engineering$23,370.50$2,124.5911
3TXN-0022024-01-05MarketingGoogle AdsAdvertising3150Finance$34,520.00$3,835.569
4TXN-0032024-01-07HRLinkedInRecruiting1200HR$14,070.00$1,563.339
5TXN-0042024-01-08FinanceQuickBooksSoftware450Marketing$13,619.00$1,238.0911
6TXN-0052024-01-10OperationsFedExShipping380Operations$6,086.80$608.6810
7TXN-0062024-01-11EngineeringGitHubSoftware840
8TXN-0072024-01-12MarketingHubSpotSoftware2100
9TXN-0082024-01-14HRIndeedRecruiting950
10TXN-0092024-01-15OperationsStaplesOffice Supplies215.4
11TXN-0102024-01-17FinanceDeloitteConsulting8500
12TXN-0112024-01-18EngineeringDatadogCloud Services1760
13TXN-0122024-01-19MarketingCanvaSoftware180
14TXN-0132024-01-21OperationsUPSShipping490
15TXN-0142024-01-22HRBambooHRSoftware620
16TXN-0152024-01-23FinancePwCConsulting6200
17TXN-0162024-01-24EngineeringSlackSoftware1320
18TXN-0172024-01-25MarketingFacebook AdsAdvertising2800
19TXN-0182024-01-28OperationsAmazon BusinessOffice Supplies875.3
20TXN-0192024-01-29HRWorkdaySoftware3400
21TXN-0202024-01-30EngineeringSnowflakeCloud Services5600