All AutosheetBench tasks

Flag abnormal patient vitals

FormulasMediumDeterministic scoringLatest run

Passed by 10 of 12 products on their best model. Failed: Claude Code + Autosheet MCP and ChatGPT + Autosheet MCP.

Prompt and starting spreadsheet

Task files

Prompt

Flag any vitals outside normal range — heart rate should be 60-100, systolic BP 90-140, diastolic BP 60-90, temperature 97.0-99.5

Add an overall alert column — Critical if 2+ flags, Warning if 1 flag, Normal if none

Starting spreadsheet

Sheet1 · rows 1–21 of 22
ABCDEFGHIJ
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp Flag
2P001James Whitfield67881288298.6
3P002Maria Santos451121589699.1
4P003Robert Chen72581428897.4
5P004Linda Okafor38761187498.9
6P005Thomas Muller5510513585101.3
7P006Patricia Lee816218010897.8
8P007Kevin Patel29951227899.4
9P008Sandra Rivera631201459198.2
10P009David Kim48729864103.2
11P010Helen Nguyen745516510298.7
12P011Frank Morales52841308097
13P012Nancy Thompson661181529499.8
14P013Gregory Walsh43911257998.4
15P014Betty Johnson794817210596.5
16P015Edward Carter577813887100.1
17P016Carol Martinez34681127098.8
18P017Steven Brown611081489399.6
19P018Dorothy Wilson836518511097.3
20P019Paul Anderson46821267698.1
21P020Ruth Taylor709714089102.5

A passing output

Autosheet in Excel · Opus 5.5
Sheet181 cells changed

H2=IF(D2<60,"Low",IF(D2>100,"High","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHighNormalCritical
4P003Robert Chen72581428897.4LowHighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHighHighCritical
19P018Dorothy Wilson836518511097.3NormalHighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

How each AI configuration did

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

Pass criteria

All must be met, checked automatically.
  • K2:K21 hold the expected values

Passed 20

Autosheet in Excel Opus 5.5 · Medium

Passed29s · 12¢
Sheet181 cells changed

H2=IF(D2<60,"Low",IF(D2>100,"High","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHighNormalCritical
4P003Robert Chen72581428897.4LowHighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHighHighCritical
19P018Dorothy Wilson836518511097.3NormalHighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Autosheet in Excel GPT-6 Astra · Low

Passed1m 4s · 28¢
Sheet181 cells changed
ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighSystolic high; Diastolic highNormalCritical
4P003Robert Chen72581428897.4LowSystolic highNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalSystolic high; Diastolic highNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighSystolic high; Diastolic highNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowSystolic high; Diastolic highNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighSystolic high; Diastolic highHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowSystolic high; Diastolic highLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighSystolic high; Diastolic highHighCritical
19P018Dorothy Wilson836518511097.3NormalSystolic high; Diastolic highNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Autosheet in Sheets Opus 5.5 · Medium

Passed40s · 13¢
Sheet181 cells changed

H2=IF(D2<60,"Low",IF(D2>100,"High","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagAlert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHigh Sys, High DiaNormalCritical
4P003Robert Chen72581428897.4LowHigh SysNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHigh Sys, High DiaNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHigh Sys, High DiaNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHigh Sys, High DiaNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHigh Sys, High DiaHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHigh Sys, High DiaLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHigh Sys, High DiaHighCritical
19P018Dorothy Wilson836518511097.3NormalHigh Sys, High DiaNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Autosheet in Excel Sonnet 5.5 · Medium

Passed17s · 4¢
Sheet181 cells changed

H2=IF(D2<60,"Low",IF(D2>100,"High","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHighNormalCritical
4P003Robert Chen72581428897.4LowHighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHighHighCritical
19P018Dorothy Wilson836518511097.3NormalHighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Claude in Excel Opus 5.5 · High

Passed47s · 23¢
Sheet196 cells changed

H2=IF(D2<$M$2,"Low",IF(D2>$N$2,"High","Normal"))

ABCDEFGHIJKLMN
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall AlertNormal RangeMinMax
2P001James Whitfield67881288298.6NormalNormalNormalNormalHeart Rate60100
3P002Maria Santos451121589699.1HighHigh Sys, High DiaNormalCriticalSystolic BP90140
4P003Robert Chen72581428897.4LowHigh SysNormalCriticalDiastolic BP6090
5P004Linda Okafor38761187498.9NormalNormalNormalNormalTemperature97.099.5
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHigh Sys, High DiaNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHigh Sys, High DiaNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHigh Sys, High DiaNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHigh Sys, High DiaHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHigh Sys, High DiaLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHigh Sys, High DiaHighCritical
19P018Dorothy Wilson836518511097.3NormalHigh Sys, High DiaNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Autosheet in Excel Haiku 5.5 · High

Passed48s · 2¢
Sheet181 cells changed

K2=IF(COUNTIF(H2:J2,"Normal")=3,"Normal",IF(COUNTIF(H2:J2,"Normal")=2,"Warning","Critical"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHighNormalCritical
4P003Robert Chen72581428897.4LowHighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHighHighCritical
19P018Dorothy Wilson836518511097.3NormalHighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Claude in Sheets Opus 5.5 · Medium

Passed1m 36s · 20¢
Sheet196 cells changed

H2=IF(D2>$N$2,"High",IF(D2<$M$2,"Low","Normal"))

ABCDEFGHIJKLMN
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall AlertNormal RangeMinMax
2P001James Whitfield67881288298.6NormalNormalNormalNormalHeart Rate60100
3P002Maria Santos451121589699.1HighSys High; Dia HighNormalCriticalBP Systolic90140
4P003Robert Chen72581428897.4LowSys HighNormalCriticalBP Diastolic6090
5P004Linda Okafor38761187498.9NormalNormalNormalNormalTemperature97.099.5
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalSys High; Dia HighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighSys High; Dia HighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowSys High; Dia HighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighSys High; Dia HighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowSys High; Dia HighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighSys High; Dia HighHighCritical
19P018Dorothy Wilson836518511097.3NormalSys High; Dia HighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed2m 7s · N/A
Sheet181 cells changed

H2=IF(D2="","",IF(D2<60,"Low",IF(D2>100,"High","Normal")))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagAlert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighSys High; Dia HighNormalCritical
4P003Robert Chen72581428897.4LowSys HighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalSys High; Dia HighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighSys High; Dia HighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowSys High; Dia HighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighSys High; Dia HighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowSys High; Dia HighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighSys High; Dia HighHighCritical
19P018Dorothy Wilson836518511097.3NormalSys High; Dia HighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Autosheet in Excel GPT-6.1 Sol · Medium

Passed1m 21s · 14¢
Sheet181 cells changed
ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1Out of rangeOut of rangeNormalCritical
4P003Robert Chen72581428897.4Out of rangeOut of rangeNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3Out of rangeNormalOut of rangeCritical
7P006Patricia Lee816218010897.8NormalOut of rangeNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2Out of rangeOut of rangeNormalCritical
10P009David Kim48729864103.2NormalNormalOut of rangeWarning
11P010Helen Nguyen745516510298.7Out of rangeOut of rangeNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8Out of rangeOut of rangeOut of rangeCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5Out of rangeOut of rangeOut of rangeCritical
16P015Edward Carter577813887100.1NormalNormalOut of rangeWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6Out of rangeOut of rangeOut of rangeCritical
19P018Dorothy Wilson836518511097.3NormalOut of rangeNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalOut of rangeWarning

Autosheet in Sheets Haiku 5.5 · High

Passed1m 37s · 2¢
Sheet181 cells changed

K2=IF(SUMPRODUCT((H2:J2<>"Normal")*(H2:J2<>"Missing data"))=0,"Normal",IF(SUMPRODUCT((H2:J2<>"Normal")*(H2:J2<>"Missing data"))=1,"Warning","Critical"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighHigh systolic, High diastolicNormalCritical
4P003Robert Chen72581428897.4LowHigh systolicNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalHigh systolic, High diastolicNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighHigh systolic, High diastolicNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowHigh systolic, High diastolicNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighHigh systolic, High diastolicHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowHigh systolic, High diastolicLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighHigh systolic, High diastolicHighCritical
19P018Dorothy Wilson836518511097.3NormalHigh systolic, High diastolicNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

ChatGPT in Excel GPT-6 Astra · Medium

Passed43s · 85¢
Sheet181 cells changed

H2=IF(ISNUMBER(D2),IF(D2<60,"Low",IF(D2>100,"High","Normal")),"Missing / invalid")

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighOut of rangeNormalCritical
4P003Robert Chen72581428897.4LowOut of rangeNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalOut of rangeNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighOut of rangeNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowOut of rangeNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighOut of rangeHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowOut of rangeLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighOut of rangeHighCritical
19P018Dorothy Wilson836518511097.3NormalOut of rangeNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Claude in Excel Haiku 5.5 · High

Passed38s · 2¢
Sheet196 cells changed

H2=IF(D2<$M$2,"Low",IF(D2>$N$2,"High","Normal"))

ABCDEFGHIJKLMN
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall AlertNormal rangeMinMax
2P001James Whitfield67881288298.6NormalNormalNormalNormalHeart Rate (bpm)60100
3P002Maria Santos451121589699.1HighSys high Dia highNormalCriticalSystolic BP (mmHg)90140
4P003Robert Chen72581428897.4LowSys highNormalCriticalDiastolic BP (mmHg)6090
5P004Linda Okafor38761187498.9NormalNormalNormalNormalTemperature (°F)9799.5
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalSys high Dia highNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighSys high Dia highNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowSys high Dia highNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighSys high Dia highHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowSys high Dia highLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighSys high Dia highHighCritical
19P018Dorothy Wilson836518511097.3NormalSys high Dia highNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Claude in Sheets Haiku 5.5 · High

Passed49s · 0.7¢
Sheet181 cells changed

H2=IF(D2>100,"High",IF(D2<60,"Low",""))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6Normal
3P002Maria Santos451121589699.1HighHighCritical
4P003Robert Chen72581428897.4LowHighCritical
5P004Linda Okafor38761187498.9Normal
6P005Thomas Muller5510513585101.3HighHighCritical
7P006Patricia Lee816218010897.8HighWarning
8P007Kevin Patel29951227899.4Normal
9P008Sandra Rivera631201459198.2HighHighCritical
10P009David Kim48729864103.2HighWarning
11P010Helen Nguyen745516510298.7LowHighCritical
12P011Frank Morales52841308097Normal
13P012Nancy Thompson661181529499.8HighHighHighCritical
14P013Gregory Walsh43911257998.4Normal
15P014Betty Johnson794817210596.5LowHighLowCritical
16P015Edward Carter577813887100.1HighWarning
17P016Carol Martinez34681127098.8Normal
18P017Steven Brown611081489399.6HighHighHighCritical
19P018Dorothy Wilson836518511097.3HighWarning
20P019Paul Anderson46821267698.1Normal
21P020Ruth Taylor709714089102.5HighWarning

Autosheet in Excel GPT-6 Luna · High

Passed34s · 2¢
Sheet181 cells changed
ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1Outside normal rangeOutside normal rangeNormalCritical
4P003Robert Chen72581428897.4Outside normal rangeOutside normal rangeNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3Outside normal rangeNormalOutside normal rangeCritical
7P006Patricia Lee816218010897.8NormalOutside normal rangeNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2Outside normal rangeOutside normal rangeNormalCritical
10P009David Kim48729864103.2NormalNormalOutside normal rangeWarning
11P010Helen Nguyen745516510298.7Outside normal rangeOutside normal rangeNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8Outside normal rangeOutside normal rangeOutside normal rangeCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5Outside normal rangeOutside normal rangeOutside normal rangeCritical
16P015Edward Carter577813887100.1NormalNormalOutside normal rangeWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6Outside normal rangeOutside normal rangeOutside normal rangeCritical
19P018Dorothy Wilson836518511097.3NormalOutside normal rangeNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalOutside normal rangeWarning

Copilot in Excel Auto

Passed41s · N/A
Sheet181 cells changed

H2=IF(OR(D2<60,D2>100),"Abnormal","Normal")

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1AbnormalAbnormalNormalCritical
4P003Robert Chen72581428897.4AbnormalAbnormalNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3AbnormalNormalAbnormalCritical
7P006Patricia Lee816218010897.8NormalAbnormalNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2AbnormalAbnormalNormalCritical
10P009David Kim48729864103.2NormalNormalAbnormalWarning
11P010Helen Nguyen745516510298.7AbnormalAbnormalNormalCritical
12P011Frank Morales52841308097.0NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8AbnormalAbnormalAbnormalCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5AbnormalAbnormalAbnormalCritical
16P015Edward Carter577813887100.1NormalNormalAbnormalWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6AbnormalAbnormalAbnormalCritical
19P018Dorothy Wilson836518511097.3NormalAbnormalNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalAbnormalWarning

ChatGPT + Drive MCP GPT-6 · Medium

Passed1m 6s · N/A
Sheet181 cells changed

H2=IF(D2="","",IF(D2<60,"LOW",IF(D2>100,"HIGH","NORMAL")))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NORMALNORMALNORMALNormal
3P002Maria Santos451121589699.1HIGHSYS HIGH; DIA HIGHNORMALCritical
4P003Robert Chen72581428897.4LOWSYS HIGHNORMALCritical
5P004Linda Okafor38761187498.9NORMALNORMALNORMALNormal
6P005Thomas Muller5510513585101.3HIGHNORMALHIGHCritical
7P006Patricia Lee816218010897.8NORMALSYS HIGH; DIA HIGHNORMALWarning
8P007Kevin Patel29951227899.4NORMALNORMALNORMALNormal
9P008Sandra Rivera631201459198.2HIGHSYS HIGH; DIA HIGHNORMALCritical
10P009David Kim48729864103.2NORMALNORMALHIGHWarning
11P010Helen Nguyen745516510298.7LOWSYS HIGH; DIA HIGHNORMALCritical
12P011Frank Morales52841308097NORMALNORMALNORMALNormal
13P012Nancy Thompson661181529499.8HIGHSYS HIGH; DIA HIGHHIGHCritical
14P013Gregory Walsh43911257998.4NORMALNORMALNORMALNormal
15P014Betty Johnson794817210596.5LOWSYS HIGH; DIA HIGHLOWCritical
16P015Edward Carter577813887100.1NORMALNORMALHIGHWarning
17P016Carol Martinez34681127098.8NORMALNORMALNORMALNormal
18P017Steven Brown611081489399.6HIGHSYS HIGH; DIA HIGHHIGHCritical
19P018Dorothy Wilson836518511097.3NORMALSYS HIGH; DIA HIGHNORMALWarning
20P019Paul Anderson46821267698.1NORMALNORMALNORMALNormal
21P020Ruth Taylor709714089102.5NORMALNORMALHIGHWarning

ChatGPT in Excel GPT-6 Luna · High

Passed41s · 1¢
Sheet181 cells changed

H2=IF(OR(D2<60,D2>100),"OUT OF RANGE","")

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6Normal
3P002Maria Santos451121589699.1OUT OF RANGEOUT OF RANGECritical
4P003Robert Chen72581428897.4OUT OF RANGEOUT OF RANGECritical
5P004Linda Okafor38761187498.9Normal
6P005Thomas Muller5510513585101.3OUT OF RANGEOUT OF RANGECritical
7P006Patricia Lee816218010897.8OUT OF RANGEWarning
8P007Kevin Patel29951227899.4Normal
9P008Sandra Rivera631201459198.2OUT OF RANGEOUT OF RANGECritical
10P009David Kim48729864103.2OUT OF RANGEWarning
11P010Helen Nguyen745516510298.7OUT OF RANGEOUT OF RANGECritical
12P011Frank Morales52841308097Normal
13P012Nancy Thompson661181529499.8OUT OF RANGEOUT OF RANGEOUT OF RANGECritical
14P013Gregory Walsh43911257998.4Normal
15P014Betty Johnson794817210596.5OUT OF RANGEOUT OF RANGEOUT OF RANGECritical
16P015Edward Carter577813887100.1OUT OF RANGEWarning
17P016Carol Martinez34681127098.8Normal
18P017Steven Brown611081489399.6OUT OF RANGEOUT OF RANGEOUT OF RANGECritical
19P018Dorothy Wilson836518511097.3OUT OF RANGEWarning
20P019Paul Anderson46821267698.1Normal
21P020Ruth Taylor709714089102.5OUT OF RANGEWarning

Gemini in Sheets Auto

Passed3m 18s · N/A
Sheet181 cells changed

H2=IF(OR(D2<60, D2>100), "Flag", "Normal")

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1FlagFlagNormalCritical
4P003Robert Chen72581428897.4FlagFlagNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3FlagNormalFlagCritical
7P006Patricia Lee816218010897.8NormalFlagNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2FlagFlagNormalCritical
10P009David Kim48729864103.2NormalNormalFlagWarning
11P010Helen Nguyen745516510298.7FlagFlagNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8FlagFlagFlagCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5FlagFlagFlagCritical
16P015Edward Carter577813887100.1NormalNormalFlagWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6FlagFlagFlagCritical
19P018Dorothy Wilson836518511097.3NormalFlagNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalFlagWarning

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 23s · 89¢
Sheet181 cells changed

H2=IF(ISNUMBER(D2),IF(D2<60,"Low",IF(D2>100,"High","Normal")),"Missing/invalid")

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighOut of rangeNormalCritical
4P003Robert Chen72581428897.4LowOut of rangeNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalOut of rangeNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighOut of rangeNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowOut of rangeNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighOut of rangeHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowOut of rangeLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighOut of rangeHighCritical
19P018Dorothy Wilson836518511097.3NormalOut of rangeNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

ChatGPT in Sheets GPT-6 Luna · High

Passed1m 46s · 2¢
Sheet181 cells changed

H2=IF(D2<60,"Low",IF(D2>100,"High","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1HighSystolic High; Diastolic HighNormalCritical
4P003Robert Chen72581428897.4LowSystolic HighNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HighNormalHighCritical
7P006Patricia Lee816218010897.8NormalSystolic High; Diastolic HighNormalWarning
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HighSystolic High; Diastolic HighNormalCritical
10P009David Kim48729864103.2NormalNormalHighWarning
11P010Helen Nguyen745516510298.7LowSystolic High; Diastolic HighNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HighSystolic High; Diastolic HighHighCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5LowSystolic High; Diastolic HighLowCritical
16P015Edward Carter577813887100.1NormalNormalHighWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6HighSystolic High; Diastolic HighHighCritical
19P018Dorothy Wilson836518511097.3NormalSystolic High; Diastolic HighNormalWarning
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalHighWarning

Failed 2

Claude Code + Autosheet MCP Opus 5.5 · Medium

Failed2m 55s · N/A
Sheet1102 cells changedWrong value

H2=IF(ISBLANK(D2),"Missing HR",IF(NOT(ISNUMBER(D2)),"Non-numeric HR",IF(D2>100,"HR high ("&D2&")",IF(D2<60,"HR low ("&D2&")","Normal"))))

ABCDEFGHIJKL
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagFlagsAlert
2P001James Whitfield67881288298.6NormalNormalNormalNormalNormal
3P002Maria Santos451121589699.1HR high (112)BP Sys high (158); BP Dia high (96)NormalHR high (112); BP Sys high (158); BP Dia high (96)Critical
4P003Robert Chen72581428897.4HR low (58)BP Sys high (142)NormalHR low (58); BP Sys high (142)Critical
5P004Linda Okafor38761187498.9NormalNormalNormalNormalNormal
6P005Thomas Muller5510513585101.3HR high (105)NormalTemp high (101.3)HR high (105); Temp high (101.3)Critical
7P006Patricia Lee816218010897.8NormalBP Sys high (180); BP Dia high (108)NormalBP Sys high (180); BP Dia high (108)Critical
8P007Kevin Patel29951227899.4NormalNormalNormalNormalNormal
9P008Sandra Rivera631201459198.2HR high (120)BP Sys high (145); BP Dia high (91)NormalHR high (120); BP Sys high (145); BP Dia high (91)Critical
10P009David Kim48729864103.2NormalNormalTemp high (103.2)Temp high (103.2)Warning
11P010Helen Nguyen745516510298.7HR low (55)BP Sys high (165); BP Dia high (102)NormalHR low (55); BP Sys high (165); BP Dia high (102)Critical
12P011Frank Morales52841308097NormalNormalNormalNormalNormal
13P012Nancy Thompson661181529499.8HR high (118)BP Sys high (152); BP Dia high (94)Temp high (99.8)HR high (118); BP Sys high (152); BP Dia high (94); Temp high (99.8)Critical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormalNormal
15P014Betty Johnson794817210596.5HR low (48)BP Sys high (172); BP Dia high (105)Temp low (96.5)HR low (48); BP Sys high (172); BP Dia high (105); Temp low (96.5)Critical
16P015Edward Carter577813887100.1NormalNormalTemp high (100.1)Temp high (100.1)Warning
17P016Carol Martinez34681127098.8NormalNormalNormalNormalNormal
18P017Steven Brown611081489399.6HR high (108)BP Sys high (148); BP Dia high (93)Temp high (99.6)HR high (108); BP Sys high (148); BP Dia high (93); Temp high (99.6)Critical
19P018Dorothy Wilson836518511097.3NormalBP Sys high (185); BP Dia high (110)NormalBP Sys high (185); BP Dia high (110)Critical
20P019Paul Anderson46821267698.1NormalNormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalTemp high (102.5)Temp high (102.5)Warning

Why it failed: 13 cells are wrong, such as K3: "HR high (112); BP Sys high (158); BP Dia" instead of "Critical".

ChatGPT + Autosheet MCP GPT-6 · Medium

Failed2m 1s · N/A
Sheet11,060 cells changedWrong value

H2=IF(D2="","",IF(OR(D2<60,D2>100),"Abnormal","Normal"))

ABCDEFGHIJK
1PatientIDNameAgeHeart RateBlood Pressure SysBlood Pressure DiaTemperatureHR FlagBP FlagTemp FlagOverall Alert
2P001James Whitfield67881288298.6NormalNormalNormalNormal
3P002Maria Santos451121589699.1AbnormalAbnormalNormalCritical
4P003Robert Chen72581428897.4AbnormalAbnormalNormalCritical
5P004Linda Okafor38761187498.9NormalNormalNormalNormal
6P005Thomas Muller5510513585101.3AbnormalNormalAbnormalCritical
7P006Patricia Lee816218010897.8NormalAbnormalNormalCritical
8P007Kevin Patel29951227899.4NormalNormalNormalNormal
9P008Sandra Rivera631201459198.2AbnormalAbnormalNormalCritical
10P009David Kim48729864103.2NormalNormalAbnormalWarning
11P010Helen Nguyen745516510298.7AbnormalAbnormalNormalCritical
12P011Frank Morales52841308097NormalNormalNormalNormal
13P012Nancy Thompson661181529499.8AbnormalAbnormalAbnormalCritical
14P013Gregory Walsh43911257998.4NormalNormalNormalNormal
15P014Betty Johnson794817210596.5AbnormalAbnormalAbnormalCritical
16P015Edward Carter577813887100.1NormalNormalAbnormalWarning
17P016Carol Martinez34681127098.8NormalNormalNormalNormal
18P017Steven Brown611081489399.6AbnormalAbnormalAbnormalCritical
19P018Dorothy Wilson836518511097.3NormalAbnormalNormalCritical
20P019Paul Anderson46821267698.1NormalNormalNormalNormal
21P020Ruth Taylor709714089102.5NormalNormalAbnormalWarning

Why it failed: 2 cells are wrong, such as K7: "Critical" instead of "Warning".