Please enable JavaScript to use regex101
/
^
r
e
g
e
x
[
\
-
_
]
?
1
0
1
$
/
i
Reg
ular
Ex
pressions
101
Upgrade to Pro
Enterprise
Regular Expression
/
\b(\w+)\(
/
gm
Input 1
1
New
=SPARKLINE( ArrayFormula({ QUERY(ArrayFormula({ 0, 0, 1 + N("See Comment 1"); 0, 0, 0.8 + N("See Comment 2") ; SEQUENCE(37,1,0,10), SIN(RADIANS(SEQUENCE(37,1,0,10))), COS(RADIANS(SEQUENCE(37,1,0,10))) + N("See Comment 3") ; SEQUENCE(12,1,30,30), 0.9 * SIN(RADIANS(SEQUENCE(12,1,30,30))), 0.9 * COS(RADIANS(SEQUENCE(12,1,30,30))) + N("See Comment 4") ; SEQUENCE(12,1,30,30), SIN(RADIANS(SEQUENCE(12,1,30,30))), COS(RADIANS(SEQUENCE(12,1,30,30))) + N("See Comment 5") ; SEQUENCE(4,1,90,90), 0.8 * SIN(RADIANS(SEQUENCE(4,1,90,90))), 0.8 * COS(RADIANS(SEQUENCE(4,1,90,90))) + N("See Comment 6") ; SEQUENCE(4,1,90,90), SIN(RADIANS(SEQUENCE(4,1,90,90))), COS(RADIANS(SEQUENCE(4,1,90,90))) + N("See Comment 7") }), "SELECT Col2, Col3 ORDER BY Col1", 0 + N("See Comment 8") ) ; IF( MINUTE(NOW()) = 0, 0, SIN(RADIANS(SEQUENCE(MINUTE(NOW())/60*360,1,1,1))) ), IF( MINUTE(NOW())=0, 1, COS(RADIANS(SEQUENCE(MINUTE(NOW())/60*360,1,1,1))) ) + N("See Comment 9"); 0, 0 + N("See Comment 10") ; 0.75 * SIN(RADIANS((MOD(HOUR(NOW()),12)/12 * 360) + MINUTE(NOW())/60 * 30)), 0.75 * COS(RADIANS((MOD(HOUR(NOW()),12)/12 * 360) + MINUTE(NOW())/60 * 30)) + N("See Comment 11") }), {"linewidth",2 + N("See Comment 12") + N(" Comments: 1: Initial (0,1) coordinate at top of circle. Extra 0 included for sort. 2: Coordinates to create mark at 12 o'clock. 3: Coordinates to draw initial circle. Joins markers every 10 degrees starting from 0 at top of circle, e.g. 0, 10, 20, 30,...360 4: Sequence of coordinates every 30 degrees to create small markers for hours 1, 2, 4, 5, 7, 8, 10, 11 5: Sequence of coordinates to connect the 30 degree small markers. Needed to place them correctly on circle. 6: Sequence of coordinates every 90 degrees to create large markers for hours 12, 3, 6, 9 7: Sequence of coordinates to connect the 90 degree large markers. Needed to place them correctly on circle. 8: QUERY function used to sort the circle data by the degrees column, then select just the (x,y) coordinate columns (numbers 2 and 3) to use. 9: Coordinates to create the minute hand. Includes an IF statement to avoid an error when the minute hand arrives at the 12 mark. 10: Coordinates to return to centre of clock at (0,0) after minute hand, to be ready to draw hour hand. 11: Coordinates to create the hour hand. 12: Set linewidth of the Sparkline to 2. . . Google Sheets Formula Clock June 2019 Created by Ben Collins, Google Developer Expert and Founder of The Collins School Of Data Website: benlcollins.com Twitter: @benlcollins ")} )
Extraction
=SPARKLINE( ArrayFormula({ QUERY(ArrayFormula({ 0, 0, 1 + N("See Comment 1"); 0, 0, 0.8 + N("See Comment 2") ; SEQUENCE(37,1,0,10), SIN(RADIANS(SEQUENCE(37,1,0,10))), COS(RADIANS(SEQUENCE(37,1,0,10))) + N("See Comment 3") ; SEQUENCE(12,1,30,30), 0.9 * SIN(RADIANS(SEQUENCE(12,1,30,30))), 0.9 * COS(RADIANS(SEQUENCE(12,1,30,30))) + N("See Comment 4") ; SEQUENCE(12,1,30,30), SIN(RADIANS(SEQUENCE(12,1,30,30))), COS(RADIANS(SEQUENCE(12,1,30,30))) + N("See Comment 5") ; SEQUENCE(4,1,90,90), 0.8 * SIN(RADIANS(SEQUENCE(4,1,90,90))), 0.8 * COS(RADIANS(SEQUENCE(4,1,90,90))) + N("See Comment 6") ; SEQUENCE(4,1,90,90), SIN(RADIANS(SEQUENCE(4,1,90,90))), COS(RADIANS(SEQUENCE(4,1,90,90))) + N("See Comment 7") }), "SELECT Col2, Col3 ORDER BY Col1", 0 + N("See Comment 8") ) ; IF( MINUTE(NOW()) = 0, 0, SIN(RADIANS(SEQUENCE(MINUTE(NOW())/60*360,1,1,1))) ), IF( MINUTE(NOW())=0, 1, COS(RADIANS(SEQUENCE(MINUTE(NOW())/60*360,1,1,1))) ) + N("See Comment 9"); 0, 0 + N("See Comment 10") ; 0.75 * SIN(RADIANS((MOD(HOUR(NOW()),12)/12 * 360) + MINUTE(NOW())/60 * 30)), 0.75 * COS(RADIANS((MOD(HOUR(NOW()),12)/12 * 360) + MINUTE(NOW())/60 * 30)) + N("See Comment 11") }), {"linewidth",2 + N("See Comment 12") + N(" Comments: 1: Initial (0,1) coordinate at top of circle. Extra 0 included for sort. 2: Coordinates to create mark at 12 o'clock. 3: Coordinates to draw initial circle. Joins markers every 10 degrees starting from 0 at top of circle, e.g. 0, 10, 20, 30,...360 4: Sequence of coordinates every 30 degrees to create small markers for hours 1, 2, 4, 5, 7, 8, 10, 11 5: Sequence of coordinates to connect the 30 degree small markers. Needed to place them correctly on circle. 6: Sequence of coordinates every 90 degrees to create large markers for hours 12, 3, 6, 9 7: Sequence of coordinates to connect the 90 degree large markers. Needed to place them correctly on circle. 8: QUERY function used to sort the circle data by the degrees column, then select just the (x,y) coordinate columns (numbers 2 and 3) to use. 9: Coordinates to create the minute hand. Includes an IF statement to avoid an error when the minute hand arrives at the 12 mark. 10: Coordinates to return to centre of clock at (0,0) after minute hand, to be ready to draw hour hand. 11: Coordinates to create the hour hand. 12: Set linewidth of the Sparkline to 2. . . Google Sheets Formula Clock June 2019 Created by Ben Collins, Google Developer Expert and Founder of The Collins School Of Data Website: benlcollins.com Twitter: @benlcollins ")} )