Abstract: Disclosed are novel approaches to debugging a formula in a spreadsheet environment. An execution trace shows step-by-step how a formula is evaluated. Instead of overwhelming users by displaying a step for every atomic evaluation, multiple evaluations are displayed in the same step. This makes the execution trace compact yet intuitive, enabling users to quickly and efficiently understand how the formula is evaluated. Visualizing formula execution in this way also reduces the computing and energy costs of excess recalculations incurred by trial-and-error based debugging techniques.

Abstract: Disclosed is a range preview system that displays data from a relevant range of cells. The range preview system intelligently elides and contextualizes data ranges for efficient visualization. The range preview system optimizes space utilization by selectively collapsing rows and columns. For example, rows and columns that are referenced by a formula may be selected for inclusion in the range preview. This conserves screen real estate while providing users with a concise overview of data ranges. The range preview system may also infer labels, providing context during formula interpretation by associating references with nearby headers or other descriptions.

Abstract: A data processing system implements receiving a first input in a spreadsheet in a spreadsheet application, detecting an indication that the first input includes first executable program code, analyzing the first executable program code to identify first references to one or more first elements of the spreadsheet in the first executable program code, requesting spreadsheet data associated with the one or more first elements of the spreadsheet from the spreadsheet application, receiving the spreadsheet data from the spreadsheet application; executing the first executable program code using the spreadsheet data referenced in the first executable program code to obtain a first program code result and causing the spreadsheet application to display the first program code result in the spreadsheet application.

Abstract: The disclosure relates to a coating agent supply device for supplying coating agent (e.g. paint) to an applicator (e.g. rotary atomizer). The coating agent supply device according to the disclosure has a pig source station, a pig destination station and a pig line which connects the pig source station to the pig destination station. The pig line contains a pig package with two pigs for clamping the coating agent between the two pigs of the pig package for coating agent transport between the pig source station and the pig destination station. Furthermore, the coating agent supply device has a lubricant supply line for supplying a lubricant for friction-reducing lubrication of the pigs in the pig line when moving the pig package between the pig destination station and the pig source station.

Abstract: The disclosure relates to a bell cup for a rotary atomizer for spraying coating agent (e.g. paint), with a spray-off body with a ring-shaped spray edge for spraying the coating agent, a hub part. Assembly of the bell cup on a rotatable hollow shaft of the rotary atomizer, and a fastening arrangement for form-fittingly fastening of the bell cup on the hollow shaft of the rotary atomizer. The disclosure provides that the fastening arrangement in the outer lateral surface of the hub part has a ring-shaped clamping surface that is inclined to the axis of rotation of the bell cup for the contact of a clamping element of the Rotary atomizer in order to clamp the bell cup with an axial clamping force on the hollow shaft of the rotary atomizer.

Abstract: The disclosure relates to a bell cup for a rotary atomizer for spraying coating agent (e.g. paint), with a spray-off body with a ring-shaped spray-off edge for spraying the coating agent, a hub part for mounting the bell cup on a rotatable hollow shaft of the rotary atomizer, and a fastening arrangement for form-fittingly fastening of the bell cup on the hollow shaft of the rotary atomizer. The bell cup according to the disclosure additionally has an outer rinsing chamber for rinsing the outer circumferential surface of the bell cup with a rinsing agent and an outer rinsing channel for supplying the rinsing agent, the outer rinsing channel being supplied by a rinsing agent supply in the interior of the bell cup and flows into the outer rinsing chamber at its outlet opening.

Abstract: Technology is disclosed herein for the integration of spreadsheet environments and LLM services. In an implementation, an application service inputs a first prompt to a LLM service to provide a formula suggestion for a spreadsheet. The application service receives a first output from the LLM service that includes a first formula in a programming language having a syntax that does not support comments. The application service generates a second prompt instructing the LLM service to provide a chain-of-thought breakdown of the first formula and receives a second output. The second output includes a second formula in the same programming language as the first formula and multiple comments corresponding to multiple portions of the second formula.

Abstract: Technology is disclosed herein for the integration of spreadsheet environments and LLM services. In an implementation, an application receives a natural language input from a user associated with a spreadsheet. The application generates a prompt based on the user input and at least a portion of the spreadsheet. The prompt includes a statement of the problem, a request for an LLM service to identify preparatory steps before generating a solution to the problem, and a request to include the preparatory steps in output that includes the solution to problem. The application service receives a reply to the prompt from the LLM service that includes the output. The application service implements the preparatory steps with respect to data in the spreadsheet and implements the solution to the problem with respect to the data in the spreadsheet.

Abstract: Technology is disclosed herein for an application service which interfaces with an LLM service. In an implementation, the application service receives a natural language input from a user associated with a spreadsheet. The application service generates a prompt based on the user input and at least a portion of the spreadsheet and submits the prompt to a large language model (LLM) service. The application service receives a reply to the prompt from the LLM service and responds to the input based on the reply from the LLM service.

Abstract: A mechanism to show how code is operating with different sets of input. After accessing the code that is to be evaluated along with the multiple input sets for that code, the computing system generates a multi-dimensional array of values. This is done by, for each of at least some of the multiple input sets, generating a corresponding intermediate value set of one or more intermediate values that are generated as the code operates upon the corresponding input set to generate a corresponding output value set. Then, the computing system causes a multi-dimensional array of values to be visualized using a multi-dimensional representation. In this multi-dimensional visualization, input sets are represented in at least one dimension against at least one intermediate value of the corresponding intermediate value set in at least another dimension.

Abstract: The disclosure relates to a piezo actuator device, preferably for controlling a dispensing of an application agent onto a component, including: at least one movable valve body for opening and closing at least one valve seat, at least one preferably pivotable actuating arm for actuating the at least one valve body, and a piezo actuator configured to move the at least one valve body to close and/or open the at least one valve seat.

Abstract: The automated generation of a natural language explanation of what code does. The code is structured to perform tasks because the code itself semantically specifies that those tasks are to be performed. A task-centric representation of the code is automatically generated that includes a task representation of each of some or all of the tasks to be performed as specified by the code. Natural language utterances are then automatically generated by generating a corresponding natural language utterance that semantically describes in natural language the corresponding task represented by the corresponding task representation. Controls are rendered for each natural language utterance that each permit a user to edit the corresponding natural language utterance. After editing, the code itself may be automatically modified or regenerated to reflect the changed natural language utterances.

Abstract: The disclosure relates to a coating agent pump for conveying a coating agent in a coating installation, having a pump inlet, an inlet section, a pump outlet and an outlet section. The coating agent pump according to the disclosure additionally has an outlet-side circulation connection for discharging the coating agent into a circulation line that leads back to a paint supply. Furthermore, the disclosure comprises a corresponding coating installation and an associated operating method.

Abstract: A system for provenance aware editing for propagating edits back to spreadsheets is provided. The system receives an indication of an operation to be performed at an output location. The operation indicates one or more input locations on a spreadsheet that each provides an input value. The input values are accessed and tagged with their corresponding input location on the spreadsheet. Based on the operation and the input value from each of the one or more input locations, the system derives and displays the result at the output location. A user edit to the result is received at the output location, which causes transmission of a propagation request to change the input value at one or more of the tagged input locations. Using where-provenance associated with the tagged input locations, the system propagates the user edit to one or more of the tagged input locations.

Abstract: The disclosure concerns a seal, in particular a rod seal for sealing an axially movable rod in a guide cylinder, in particular a piston seal for a pneumatically, electrically or hydraulically driven coating agent pump for pumping coating agent, having an annular sealing element for sealingly resting on a circumferential surface of an axially movable rod, and having at least one elastic annular pretensioning element, the annular pretensioning element surrounding the annular sealing element radially on the outside and pretensioning it radially to the inside. The disclosure provides an annular seal base body which externally surrounds and holds the sealing element and the pretensioning element. In addition, the disclosure also comprises an inverted variant in which the seal is arranged in an annular groove in a lateral surface of a piston and lies sealingly against the cylinder running surface.

Abstract: A spreadsheet application displays a spreadsheet of cells in tabular form. User input is received specifying an input range of cells of the spreadsheet, a destination range of cells of the spreadsheet and a local modification. A memory stores a representation of the spreadsheet indicating formatting, values and formulas. An update of the representation is computed by applying the local modifications to the representation. Values of cells of the input range of the spreadsheet are calculated by using the updated representation and the calculated values are displayed at the destination range.

Abstract: A system for provenance aware editing for propagating edits back to spreadsheets is provided. The system receives an indication of an operation to be performed at an output location. The operation indicates one or more input locations on a spreadsheet that each provides an input value. The input values are accessed and tagged with their corresponding input location on the spreadsheet. Based on the operation and the input value from each of the one or more input locations, the system derives and displays the result at the output location. A user edit to the result is received at the output location, which causes transmission of a propagation request to change the input value at one or more of the tagged input locations. Using where-provenance associated with the tagged input locations, the system propagates the user edit to one or more of the tagged input locations.

Abstract: A solar tracking system preferably associated with a double-reflecting dish solar concentrator having an initial parabolic reflective surface for concentrating solar energy upon a focal cloud preferably spatially coinciding with the primary focus of a subsequent elliptical reflective surface for further concentrating solar energy within a beam directed through an opening defined, preferably at the origin, by the initial parabolic reflective surface to heat a thermal transfer fluid flowing through a heating element; said subsequent elliptical reflective surface having a photovoltaic element on its reverse; said photovoltaic element being divided into plural sections, preferably quadrants, from which respective photovoltaic-based voltmeter readings are utilized to reposition the initial parabolic reflective surface's axis of symmetry closer to parallel with the plurality of incoming solar energy thereby effectively tracking the sun and maximizing collectable/concentrated solar energy.

Abstract: A spreadsheet application displays a spreadsheet of cells in tabular form. User input is received specifying an input range of cells of the spreadsheet, a destination range of cells of the spreadsheet and a local modification. A memory stores a representation of the spreadsheet indicating formatting, values and formulas. An update of the representation is computed by applying the local modifications to the representation. Values of cells of the input range of the spreadsheet are calculated by using the updated representation and the calculated values are displayed at the destination range.

Abstract: A solar tracking system preferably associated with a double-reflecting dish solar concentrator having an initial parabolic reflective surface for concentrating solar energy upon a focal cloud preferably spatially coinciding with the primary focus of a subsequent elliptical reflective surface for further concentrating solar energy within a beam directed through an opening defined, preferably at the origin, by the initial parabolic reflective surface to heat a thermal transfer fluid flowing through a heating element; said subsequent elliptical reflective surface having a photovoltaic element on its reverse; said photovoltaic element being divided into plural sections, preferably quadrants, from which respective photovoltaic-based voltmeter readings are utilized to reposition the initial parabolic reflective surface's axis of symmetry closer to parallel with the plurality of incoming solar energy thereby effectively tracking the sun and maximizing collectable/concentrated solar energy.