Data
Deep Dive
Interpolation Test
First Published:January 13, 2025
Last Updated:March 11, 2025

Simple JSON keys 10.5

Min -41751260787

Min Literals 5

Max 224711041686.6

Max Literals 10

Average 2662627075.8350315

Average Literals 20

Median 298742758.1

Sum 8573659184188.802

Row filter equal 2143414796047.1997

Row filter greater than 458556.5999999996

Row filter less than -70353.70000000345

Decimals (sum) 2662627075.84

Commas ( Decimals (sum) ) 2,662,627,075.84

Human Readable (sum) 8.6 trillion

Human Readable (sum) 9 trillion

Human Readable Literal 12.35 million

Upper (nick) Nick

Lower (JEN) jen

Concat: 1,2,3,4,5

Concat using reference: 2660974296.9238987

Pulling in a single cell 1.811 billion

Auto parse a common format date ("March 6, 2025"): Thursday, Mar 6, 2025

Auto Parse a common format date ("2025-03-06 14:30:00"): March 6, 2025 14:30:00

Auto parse an ISO 8601 format date ("2025-03-06T14:30:00Z"): Mar 6, 2025 14:30:00

Auto parse an RFC2822 format date ("Thu, 06 Mar 2025 14:30:00 GMT"): March 6, 2025

Auto parse a date ("03/06/2025"): March 6, 2025

Auto parse a date ("2025.03.06"): March 6, 2025

Custom parse a date ("03/2025"): March, 2025

Custom parse a date ("2025--11--21") November 21, 2025

World max inflation rate: 10.5% as of September 2022. Africa max inflation rate: 19.8% as of July 2021. 6 6 Add them together for no reason: 30.3%
Some official source