Agent skills by ecnu-icalk

ECNU-ICALK/AutoSkill

Generates a list of common repair or replacement parts for a specified list of equipment, including the average national price and the frequency of replacement per year.

ECNU-ICALK/AutoSkill

Act as a Dungeon Master for an erotic role-playing game, displaying specific game screens in bullet points when triggered by user commands.

ECNU-ICALK/AutoSkill

Designs educational writing worksheets for ESL students, specializing in structured tasks like expository career essays with planner tables, checklists, and age-appropriate content.

ECNU-ICALK/AutoSkill

Analyze ethical case studies by identifying the main issue, conflicting values, applicable decision-making models, and appropriate responses.

ECNU-ICALK/AutoSkill

Recommends top electric vehicles based on user-defined technical constraints (features, range, body type, brand) and calculates a weighted percentage match score for ranking.

ECNU-ICALK/AutoSkill

Manages the specific workflow for reviewing vendor quotes against requirements, negotiating costs, validating with the service providers team, and coordinating site visits involving the events team.

ECNU-ICALK/AutoSkill

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.

ECNU-ICALK/AutoSkill

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.

ECNU-ICALK/AutoSkill

Extracts start and end dates from a string formatted as 'Day DD Mon YYYY - Day DD Mon YYYY', converts them to date values, and formats them as 'dd mm yyyy' or extracts individual components.

ECNU-ICALK/AutoSkill

Generates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.

ECNU-ICALK/AutoSkill

Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.

ECNU-ICALK/AutoSkill

Generates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.

ECNU-ICALK/AutoSkill

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.

ECNU-ICALK/AutoSkill

Implement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation.

ECNU-ICALK/AutoSkill

Generates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request').

ECNU-ICALK/AutoSkill

Generates VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white.

ECNU-ICALK/AutoSkill

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.

ECNU-ICALK/AutoSkill

Generates a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements.

ECNU-ICALK/AutoSkill

Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and…

ECNU-ICALK/AutoSkill

A VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status.

ECNU-ICALK/AutoSkill

Generates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications.

ECNU-ICALK/AutoSkill

Generates VBA code to identify the row with the latest time value for each unique date in a dataset and appends a specified text marker to a target column.

ECNU-ICALK/AutoSkill

Validates a repeating sequence of days (Monday to Sunday) in a column, highlights cells that break the sequence in yellow, and resets the sequence check from the breaking cell.

ECNU-ICALK/AutoSkill

A VBA subroutine to search a source sheet for a value, copy all matches to a destination sheet, apply random column colors (excluding white), highlight source cells yellow, and log the search term.