Really enjoyed this, such a great presenter and fluent way of connecting these concepts / extrapolating forward. Also the game of life implementation without plugins is too cool!!
I'm also a timesheet nerd. And was so very much looking forward to digging into those examples. But in the interest of time, they just got an overview. Are those examples available anywhere?
I'd be interested to see the code behind the functions, if possible. X & Y - at the very least. To be honest, I've struggled with google spreadsheets since I didn't find a good guide for programming it, and the built-in help sucks. So this talk was really illuminating. And I was looking for something like these X() & Y() certainly for my work.
Hi Ivan, I'm happy you found the talk illuminating. I'm preparing a writeup with links to live spreadsheets you can copy, edit & inspect. In the mean time, the code behind _X & _Y is just _X = _XY(x,0) and _Y = _XY(0, y), where _XY =INDIRECT("R["& y &"]C["& x &"]", FALSE). I'm using the relative R1C1 mode of INDIRECT. You can read more about it on Google's reference or Ben Collins's site. (Notice also the underscores, it's there because _Y means AND in spreadsheets, for historical reasons! 🤷🏼♂) (Btw, I replied to you almost a week ago but since I put URLs in my original reponse, it seems it got stuck in moderation limbo. So I'm trying it once more!)
