License for the LAMBDA Library
For LAMBDA Function Code from Vertex42.com - Page Updated 1/29/2024
Note
The following "MIT license" applies only to the LAMBDA Library function code shared by Vertex42.com, but does not apply to the associated documentation contained on vertex42.com. All documentation found within these pages and within files created by Vertex42 is subject to standard copyright. To reference the documentation for specific functions, use the "doc" link associated with each function.
"MIT" is just a name for this type of license. It does not imply any association with a school or other organization.
The MIT License
MIT License Copyright (c) Vertex42 LLC, https://www.vertex42.com/ Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Using Individual Functions
To use individual functions from the LAMBDA Library within your Excel files, you may copy and paste the associated LAMBDA function code, maintaining the "doc" reference within the function code like this:
=LAMBDA(start,end,n, LET(doc,"https://www.vertex42.com/lambda/linspace.html", SEQUENCE(n,1,start,(end-start)/(n-1)) ))
Maintaining a reference to the associated documentation page not only satisfies the conditions of our license, but will allow anyone auditing the spreadsheet to be able to find and compare the function code to the original source (and to learn more about the function).
Using "Substantial Portions"
When using "substantial portions" of the LAMBDA function code in your file(s), there are multiple ways to include the MIT License (you only need one):
- If importing a Gist provided by jonwittwer or Vertex42.com, the MIT License can be included in the comments and can be viewed when using the Excel Labs AFE.
- The License may be added as a separate Named Function in Google Sheets or via the Name Manager in Excel (with workbook scope) such as: Name="LAMBDA_Library_License", Refers To="copy/paste license text"
- The License may be included within a separate worksheet within the spreadsheet workbook. If starting from one of the Vertex42 templates, this may already be included, along with links to the supporting documentation.
References & Resources
