Excel 2011 add ins for mac data analysis3/13/2023 In the most elementary case, all four entries (X input, Y input, X output, and Y output) are separate ranges, which can even be located on separate worksheets. The colorful buttons on the left indicate the built-in options. So I made the range selection function much more flexible. But I’ll show the new dialog, so you can see what has changed.įirst, the previous interface for selecting input and output ranges was frustratingly restrictive. What makes this utility so great, you ask? The calculations were already perfectly adequate, and I didn’t change them at all. If you’ve never seen “Good Will Hunting”, that means “way cool”. And after a few months of use and a few hour-long sessions aimed at making it do what I want it to do, I’ve developed this utility into something that is, in the local vernacular, “wicked awesome”. Since I am the developer of the utility, I have actually been able to make these changes. Since I use the utility frequently, I encountered many things about it that I wanted to change. I introduced an improved LOESS Smoothing utility in LOESS Utility for Excel. I talked about LOESS smoothing in LOESS Smoothing in Excel, where I showed my improved VBA function for calculating smoothed data.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |