3v4l.org

run code in 300+ PHP versions simultaneously
<?php function letterToColumnNumber(string $letters, int $indexStart = 0): int { static $ordA = ord('A'); $length = strlen($letters); $number = 0; $pow = 1; for ($i = $length - 1; $i >= 0; $i--) { // calculate the value of each letter and add to the total $number += (ord($letters[$i]) - $ordA + 1) * $pow; $pow *= 26; } return $number - (1 - $indexStart); } function rangeStringToRangeArray(string $range, int $indexStart = 0): array { // Parse Excel range expression if (sscanf($range, '%[A-Z]%d:%[A-Z]%d', $startCol, $startRow, $endCol, $endRow) != 4) { throw new Exception('Invalid range expression'); } return [ [ letterToColumnNumber($startCol, $indexStart), $startRow - (1 - $indexStart) ], [ letterToColumnNumber($endCol, $indexStart), $endRow - (1 - $indexStart) ] ]; } echo json_encode(rangeStringToRangeArray('A1:B2')); // returns [[0,0],[1,1]] echo json_encode(rangeStringToRangeArray('A1:B2', 1)); // returns [[1,1],[2,2]]

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
8.4.140.0100.01117.68
8.4.130.0120.00417.79
8.4.120.0110.00824.44
8.4.110.0060.00319.09
8.4.100.0080.01417.93
8.4.90.0110.00820.74
8.4.80.0100.01019.03
8.4.70.0030.00520.67
8.4.60.0090.00220.60
8.4.50.0090.01217.86
8.4.40.0060.00317.88
8.4.30.0110.00018.81
8.4.20.0030.01618.77
8.4.10.0090.00019.69
8.3.260.0100.00916.64
8.3.250.0100.00919.01
8.3.240.0120.00717.33
8.3.230.0070.01116.87
8.3.220.0100.00820.66
8.3.210.0090.00916.65
8.3.200.0060.00316.34
8.3.190.0100.00916.61
8.3.180.0040.00416.77
8.3.170.0040.00420.99
8.3.160.0100.01017.36
8.3.150.0090.00916.39
8.3.140.0130.00016.20
8.3.130.0040.00418.48
8.3.120.0090.00619.17
8.3.110.0120.00318.39
8.3.100.0130.00618.35
8.3.50.0090.00018.43
8.3.10.0050.00323.65
8.3.00.0080.00020.67
8.2.290.0120.00716.75
8.2.280.0130.00619.93
8.2.270.0070.01118.65
8.2.260.0070.00716.87
8.2.250.0090.00016.46
8.2.240.0060.00317.24
8.2.230.0040.01118.00
8.2.220.0000.00816.58
8.2.140.0030.00520.43
8.2.130.0080.00020.89
8.2.120.0030.00620.62
8.2.110.0030.00620.46
8.2.100.0080.00020.51
8.2.90.0040.00420.60
8.2.80.0050.00520.21
8.2.70.0080.00020.09
8.2.60.0060.00320.24
8.2.50.0030.00620.38
8.2.40.0100.00020.18
8.2.30.0100.00020.34
8.2.20.0060.00320.29
8.2.10.0090.00020.43
8.2.00.0030.00620.44
8.1.330.0200.00915.89
8.1.320.0130.00723.75
8.1.310.0040.00416.34
8.1.300.0110.00418.13
8.1.270.0050.00323.83
8.1.260.0050.00323.73
8.1.250.0090.00023.78
8.1.240.0040.00419.91
8.1.230.0060.00320.18
8.1.220.0030.00620.12
8.1.210.0000.00920.00
8.1.200.0090.00020.16
8.1.190.0000.00820.24
8.1.180.0030.00620.04
8.1.170.0060.00320.26
8.1.160.0030.00620.17
8.1.150.0090.00020.18
8.1.140.0030.00620.05
8.1.130.0000.00920.24
8.1.120.0030.00619.95
8.1.110.0040.00420.16
8.1.100.0090.00020.39
8.1.90.0030.00620.21
8.1.80.0060.00320.23
8.1.70.0060.00320.16
8.1.60.0030.00620.29
8.1.50.0050.00520.16
8.1.40.0100.00020.33
8.1.30.0090.00020.48
8.1.20.0090.00020.35
8.1.10.0090.00020.35
8.1.00.0050.00520.18

preferences:
62.92 ms | 403 KiB | 5 Q