Really great collaboration. My lambda file is more of a blank file with named lambdas, but I think I'm going to work to improve it to look more like Brittany's, the clear descriptions and samples for each function are great. Now we just need a way to have lambdas that are added to all files!
Yeah, honestly it reminded me that I should do a better job of the same thing myself! My lambda file is also mostly blank, and I have to keep reminding myself how the parts I don't use as often work... Copying a blank sheet from your lambda file (which you can pin to your taskbar) is a passable way to get them all into a new workbook... but it would be nice if you could have something like the personal macro workbook that's always available by default.
What a joy to watch you exchange ideas about lambda's and competition approach. I'm curious: are you allowed to bring your lambda's to the live-competition? Diarmuid mentions that you have 15 seconds to prepare your lambda's, but how does that go? Small suggestion for a next time with a screenshare: as I'm on a laptop now, no big screen, so I had some trouble seeing the formula's, and because only one screen no opportunity to simultaneous look at the Excel file.
I just realized I never answered this… I think what I meant about the 15 seconds was that you’re usually trying to save a very small amount of time if you’re using a generic prepared LAMBDA - e.g. making a dice lookup wouldn’t take long anyway. So if the LAMBDAs you’re using bring any friction with them, it would be easy for them not to be worth it. You can spend as long as you want preparing LAMBDAs ahead of time, but obviously the more specific you make them, the less likely they are to help on any given case. I sometimes also try to write a last-minute one in the time between seeing the case animation (which you get access to ~10 mins before you have to start) and starting. If you get it right, that can be a big help… but I often prepare something that ends up being worthless!
Classic Internet - Spirit of Sharing Knowledge, Helping one another. Great stuff Britney and Diarmuid.
Really great collaboration. My lambda file is more of a blank file with named lambdas, but I think I'm going to work to improve it to look more like Brittany's, the clear descriptions and samples for each function are great.
Now we just need a way to have lambdas that are added to all files!
Yeah, honestly it reminded me that I should do a better job of the same thing myself! My lambda file is also mostly blank, and I have to keep reminding myself how the parts I don't use as often work...
Copying a blank sheet from your lambda file (which you can pin to your taskbar) is a passable way to get them all into a new workbook... but it would be nice if you could have something like the personal macro workbook that's always available by default.
What a joy to watch you exchange ideas about lambda's and competition approach.
I'm curious: are you allowed to bring your lambda's to the live-competition? Diarmuid mentions that you have 15 seconds to prepare your lambda's, but how does that go?
Small suggestion for a next time with a screenshare: as I'm on a laptop now, no big screen, so I had some trouble seeing the formula's, and because only one screen no opportunity to simultaneous look at the Excel file.
You can bring formulas in with you.
I just realized I never answered this…
I think what I meant about the 15 seconds was that you’re usually trying to save a very small amount of time if you’re using a generic prepared LAMBDA - e.g. making a dice lookup wouldn’t take long anyway. So if the LAMBDAs you’re using bring any friction with them, it would be easy for them not to be worth it.
You can spend as long as you want preparing LAMBDAs ahead of time, but obviously the more specific you make them, the less likely they are to help on any given case.
I sometimes also try to write a last-minute one in the time between seeing the case animation (which you get access to ~10 mins before you have to start) and starting. If you get it right, that can be a big help… but I often prepare something that ends up being worthless!