Abstract: Examples discussed herein relate to automatically creating lambda functions in spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of automatically creating lambda functions in spreadsheet applications using a lambda shorthand notation is disclosed. The method includes analyzing contents of a cell of a spreadsheet to identify a formulaic expression and determining that the formulaic expression can define a body of a lambda function without using explicit lambda function notation or parameter declarations. The method further includes automatically creating and invoking the lambda function responsive to the determination. As discussed herein, creating the lambda function includes registering the lambda function in a lambda registry using the formulaic expression as the body of the lambda function that evaluates into an output value.

Abstract: A formula abstraction system is described. The system includes detecting a user-generated formula in a cell of a spreadsheet document, generating a graphical user interface that queries entries of a custom function based on the user-generated formula, forming the custom function by abstracting the user-generated formula to the custom function based on the entries, and storing the custom function in a function library of the spreadsheet document. The custom function applies the user-generated formula in a user-selected cell of the spreadsheet document.

Abstract: A formula abstraction system is described. The system includes detecting a user-generated formula in a cell of a spreadsheet document, generating a graphical user interface that queries entries of a custom function based on the user-generated formula, forming the custom function by abstracting the user-generated formula to the custom function based on the entries, and storing the custom function in a function library of the spreadsheet document. The custom function applies the user-generated formula in a user-selected cell of the spreadsheet document.

Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.

Abstract: Examples discussed herein relate to automatically creating lambda functions in spreadsheet applications, e.g., Microsoft Excel®. In an implementation, a method of automatically creating lambda functions in spreadsheet applications using a lambda shorthand notation is disclosed. The method includes analyzing contents of a cell of a spreadsheet to identify a formulaic expression and determining that the formulaic expression can define a body of a lambda function without using explicit lambda function notation or parameter declarations. The method further includes automatically creating and invoking the lambda function responsive to the determination. As discussed herein, creating the lambda function includes registering the lambda function in a lambda registry using the formulaic expression as the body of the lambda function that evaluates into an output value.

Abstract: Examples discussed herein relate to creating and handling lambdas in spreadsheet application, e.g., Microsoft Excel®. As discussed herein, lambdas are user defined functions (UDFs) that are natively creatable and maintainable through the use of a lambda registry in the spreadsheet application. In an implementation, a method of handling lambdas in a spreadsheet application is disclosed. The method includes detecting that a cell of a spreadsheet is populated with an expression that defines a lambda function and registering the lambda function with a lambda registry corresponding to the spreadsheet. The registration includes recording a home cell that identifies a location of the cell of the spreadsheet where the lambda function is defined. The method further includes replacing the expression that defines the lambda function with a reference to the registered lambda function.

Abstract: Some embodiments relate to an apparatus for metallic particulate detection. The apparatus comprises: an entry stage defining an input chamber to receive an element having particulate matter thereon; a sensor defining a passage in fluid communication with the input chamber to receive the particulate matter from the input chamber and to detect the particles in the particulate matter; a vented recovery stage defining a recovery chamber to receive and capture at least some of the particulate matter passing through the passage; and at least one air outlet positioned in the input chamber to direct pressurized air from the at least one air outlet to impinge on the element to remove the particulate matter from the element.

Abstract: A quick analysis tool is configured to present one or more data analysis features that are tailored to the data in a selected portion of a spreadsheet document. The quick analysis tool may provide a quick analysis tool entry button, the selection of which causes a contextual user interface to be displayed. The contextual user interface facilitates a user to easily access one or more data analysis features. The quick analysis tool also provides a mechanism by which a user can preview and/or apply one or more of these data analysis features while bypassing the potentially steep learning curve and traditionally high barrier of entry for new or otherwise less advanced users of the spreadsheet application. Intermediate or otherwise more advanced users of the spreadsheet application will also benefit from the quick analysis tool because of improved efficiency for applying data analysis features to data within a spreadsheet document.

Abstract: Some embodiments relate to an apparatus for metallic particulate detection. The apparatus comprises: an entry stage defining an input chamber to receive an element having particulate matter thereon; a sensor defining a passage in fluid communication with the input chamber to receive the particulate matter from the input chamber and to detect the particles in the particulate matter; a vented recovery stage defining a recovery chamber to receive and capture at least some of the particulate matter passing through the passage; and at least one air outlet positioned in the input chamber to direct pressurised air from the at least one air outlet to impinge on the element to remove the particulate matter from the element.

Abstract: Embodiments are configured to manage memory, including detecting one or more memory leaks. The various embodiments are configured to detect memory leaks and/or associated data without adding extra space or overhead for each associated memory allocation as compared with current implementations. In an embodiment, memory is managed including the detection a memory leak by using a fixed memory overhead, such as a fixed block or buffer of N pointers, instead of adding extra space per memory allocation. The contents of the fixed block can be altered and used to detect when memory has been allocated but not freed based on an analysis of a polynomial associated with one or more allocation and free operations. The polynomial can be solved to determine leaked pointers under certain conditions.

Abstract: Embodiments are configured to manage memory, including detecting one or more memory leaks. The various embodiments are configured to detect memory leaks and/or associated data without adding extra space or overhead for each associated memory allocation as compared with current implementations. In an embodiment, memory is managed including the detection a memory leak by using a fixed memory overhead, such as a fixed block or buffer of N pointers, instead of adding extra space per memory allocation. The contents of the fixed block can be altered and used to detect when memory has been allocated but not freed based on an analysis of a polynomial associated with one or more allocation and free operations. The polynomial can be solved to determine leaked pointers under certain conditions.