Yo! So, can spreadsheet do calculations of a link? Totally! In Google Sheets, you can use REGEXEXTRACT to pull numbers from URLs.
For your example:
`=REGEXEXTRACT(A1, "value=(\d+)")` grabs "100".
Then just add formulas to calculate. It’s a bit fiddly but works!
For Excel, Power Query can parse URLs too—just split by "&" and "=".
Hope that helps!
For your example:
`=REGEXEXTRACT(A1, "value=(\d+)")` grabs "100".
Then just add formulas to calculate. It’s a bit fiddly but works!
For Excel, Power Query can parse URLs too—just split by "&" and "=".
Hope that helps!
