Calculates the required diameter of PE4710 pontoon pipes for floating docks and performs comprehensive structural verification (ULS/SLS), including buoyancy, detailed lateral load checks (wind/berthing) with mooring pile mechanics, wave-induced flexure, and vibration.
Generates a hypothetical country profile for a specified entity, including the country name, official languages, location, ideology, and flag design, based on the entity's characteristics.
Generates Google Sheets formulas to split comma-separated values in a column into a single list, while removing empty strings and specific unwanted values.
Interpolates GPS coordinate measurements with a grid density calculated as input count multiplied by 10, and exports the result to a CSV file with specific column headers.
Generates a one-row, eight-column table of random numbers less than 80 that sum to a specific target when added from right to left. Outputs only the table data without explanation.
Perform a TOWS analysis by linking items from two provided lists (e.g., Opportunities & Strengths, Threats & Weaknesses) and providing a summarized rationale for each connection.
Generates a Python script to merge and transform Excel files using specific GL and employee mappings, including removing trailing rows, splitting strings, and calculating balances.
Generates Excel array formulas to filter rows by date criteria (range or offset), format dates as 'dd-mm-yyyy', and concatenate multiple columns with double spaces into separate rows.
Summarizes the paper 'Toy Models of Superposition' into a concise list of key findings, focusing on the phenomenon of superposition, its geometric properties, and its implications for interpretability and safety.
Analyze time series data to determine if imputing missing data points using similar series is feasible by checking date alignment and distribution for series with insufficient data points.
Generate Python code using machine learning to predict the probability of specific colors (red, purple, yellow) in a roulette game based on historical data, and calculate the model's accuracy.
Execute a univariate time series forecasting pipeline using StatsForecast and Polars. Includes ID concatenation, cross-validation, ensemble generation (AutoARIMA, AutoETS, DynamicOptimizedTheta), non-negative constraints, outlier-aware metrics, and formatted output with specific type casting for split IDs.
Generates a DAX calculated column that sums a target value column for unique combinations of specified grouping columns, effectively ignoring other columns in the filter context.
Generates a Logical Framework (Logframe) in a table format with specific columns including Objective, Goal, Outcome, Activity, Input, Indicator, Means of Verification, and Assumptions.
Generates an Excel nested IF formula to determine task status (Completed, Incomplete, or Pending) by comparing a Target column against an Actual column and appending the status to an ID column.
Generates a Markdown table dataset of math problems with specific columns for descriptions, solutions, and detailed derivations, adhering to strict output constraints regarding completeness and formatting.
Scrapes TV show data (title, genres, episodes, rating) from a Next.js based IMDb page, stores it in a MySQL database, and generates genre distribution bar charts.
Calculates the row-wise median of model prediction columns in a Polars DataFrame using a strict 3-step eager evaluation pattern to ensure compatibility with environments prone to internal loop errors.
Constructs mathematical models and MATLAB simulations for human population growth coupled with information diffusion, incorporating user-defined feedback loops and carrying capacity constraints.
Generates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values.
Generates a dynamic HTML table where data objects are sorted by a header array. Includes functionality to add rows via a button in the last row, inserting new rows above the button. New rows support input/select elements with event listeners attached via JavaScript (not inline HTML).
Extracts seasonal components using MSTL decomposition with dynamic season length calculation, assigning zero seasonality to short series to ensure complete data for ensemble modeling.
Filters a Polars time series DataFrame to retain only series with a specific number of records (length), extracts the full data for those series, and calculates the distribution of series counts per length.
