User Profile
RecalcOrDie
Iron Contributor
Joined Mar 18, 2020
User Widgets
Recent Discussions
Re: Convex hull Lambda > would it be impossible to build?
ExcelWizard Bo, right now I'm like a little kid with a new toy. Thank you for this! You leave me with good homework to study this mind-blowing formula. I'm attaching this updated version with pivot table slicers for switching the set of dots. Lastly, I have messaged Andy Pope about this post on this forum.Re: Convex hull Lambda > would it be impossible to build?
ExcelWizard I'm a hardcore ALT + ENTER + Space Bar kind of guy, so formatting formulas to be vertically is imperative for me. And in reviewing the formula, I have to ask, what´s this %% (double percentages)? And also, what's this secret function =RAD() ? note: I'm not a LAMBDA expert like the brilliant minds that have posted here. Yet, I'm always eager to learn the -- core concepts -- of interesting and complex formulas.Re: Convex hull Lambda > would it be impossible to build?
To all, Here's another person: Fernando Cinquegrani, who developed a Convex hull UDF. Very interesting stuff. It would be nice to check out his VBA back-end but its locked. Fernando's site: http://www.prodomosua.it/ppage02.html On the link above, you will be able to find the workbook with the convex hull right above the section where the graph below appears.Re: Convex hull Lambda > would it be impossible to build?
JKPieterse Thanks of your comments, I have tried like dozen of Lambdas out from ChatGtP but none worked. I still need to work on grasping recursiveness. Sometimes I feel like "I get it" and then in another case I lost it. 😒 But I'm making progress. Learning -- thunking -- has been fun.Re: Graph data label adjustment
Hi Umairatif , For this dynamic condition, you can opt for four separate series which would be the labels to be shown if series are below or above the other one. In total its 4 because you have to check for above or below from each line (Blue and yellow). Once you have set up the series, then you add them to the chart. Then you add the labels for these four series and here's comes the trick > right click on the labels and in the "Label option section", you will use the option of "Values From Cells" and there you map it to these two new series. If you can share the workbook, I can try to add them and set it for you.Convex hull Lambda > would it be impossible to build?
Hello everyone, Ever since visiting the site of Andy Pope, I saw a chart that fascinated me because it can be very useful for creating the bounding area of a set of points. It's known as Convex Hull. Here's Andy's post > https://andypope.info/charts/convexhull.htm In the post you can download the file, and the VBA is fascinating to say the least. I was wondering, with the LAMBDA technology and its possibility for recursiveness, is it possible with Lambda or has anyone come across a Lambda formula about it? Thanks in advance.Re: Lambda Example: Generate Fibonacci series
PeterBartholomew1 I don't know where to begin writing this reply but thank you for providing that mighty Lambda of yours for the Fibonacci Sequence. 👉🤯👈 Below is the result of visualizing that function combined with the works of Tim Wolverson on plotting this beautiful sequence of numbers in Excel. If interested in Tim's work go here 👉https://lnkd.in/dtYKEj34 For anyone interested in the workbook of the image below go here 👉 https://lnkd.in/dVDJCafX To all of you in this discussion, thank you! 🙏Re: How do we section dynamic arrays for running averages, running slopes or other functions?
PeterBartholomew1 wow! amazing! thank you for another great contribution to this discussion. I am still amazed that the only ways for this calculation of "MEDIANIF" are only possible thru LAMBDA combined with MAP or BYROW. I needed result of this MEDIANIF calculation to be in spilled range because I am working on another "Excel Graphics" (028, coming out soon!) using Dynamic Arrays functions on which with slicers, the user can either sort the boxplots, by median calculation, quartiles (1st or 3rd), IQR, min or max, either by ascending or descending order. Sneak peak on the GIF below. Again, thank you Peter!
