Claude Skills by ECNU-ICALK

Process English text by rephrasing or simplifying it based on specific labels, and subsequently translate the English text to Turkish when prompted.

Transcribes English sentences into Japanese Katakana characters based on phonetic syllables without translating the meaning.

Translates English text into Simplified Chinese, upgrading the vocabulary and style to be more literary and elegant. Outputs only the corrected text without explanations.

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.

Gathers context about user equipment via clarifying questions before providing a final answer, ensuring accuracy by synthesizing gathered details.

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

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

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

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

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.

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.

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

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.

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.

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.

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.

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').

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.

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 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.

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 clears the new value in Column D.

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.

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.

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.

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.

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.

Generates VBA code to trigger a UserForm upon numeric entry in a specific column and writes form data to specific columns on the same row, handling the selection offset caused by pressing Enter.

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.

Assists in framing strategic or challenging questions, drafting concise responses to executive inquiries, and providing guidelines for meetings with a Senior Vice President.

Refines text into polished executive business communication, technical engineering documentation, or optimized CV/resume content. Supports grammar correction, structural editing, strategic implications, and specific constraints including strict word counts, pronoun shifts (we to I), and tonal adjustments (pithy, direct, formal) in English and Greek.

Expands a provided topic, sentence, or short text into a single paragraph of exactly 54 words, maintaining the original meaning and context.

Iteratively creates, mixes, and refines ChatGPT prompts using a strict three-section output format and first-person perspective.

Analyzes provided Chemistry Learning Objectives and Essential Knowledge points to explain what concepts and skills a student needs to learn to meet the objective.

Explain specific features, processes, or considerations related to event marketing software using simple, clear language. Adhere to specified word count limits if provided.

Explain mathematical concepts by providing a full step-by-step demonstration and ensuring that approximately 5% of the sentences in the description are humorous.

Provides step-by-step directions or scripts to explain arithmetic operations like multiplication and division (including decimals and remainders) specifically tailored for a 5th-grade audience.

Simplifies complex topics, definitions, or historical concepts into language and analogies suitable for a young child (approx. 5 years old), supporting both English and Turkish explanations while avoiding jargon.

Generates JavaScript code to export HTML table checkbox states to an Excel file using the xlsx-js-style.js library, ensuring all double quotes are standard ASCII (half-width).

Identifies and lists Adverse Events of Special Interest (AESI) from provided clinical study context, adhering to a strict short-answer format.

Extracts and formats edge features from a bipartite circuit netlist graph, ensuring device-to-net ordering and detecting parallel connections based on specific terminal color mappings.

Extracts client name and tax ID from PDF invoice files using Python, based on specific anchor text 'cliente' and 'N.º de contribuinte'.

Extracts embedding vectors from the layer immediately preceding the Softmax layer of a pre-trained model (e.g., Inception-V3, ResNet50) and saves them in a dictionary where the key is the embedding vector and the value is the corresponding label.

Extract a short quotation from a specified research paper or book and write exactly one sentence explaining how the idea applies to cities.

Extracts distance values from address strings, removing all address details, postcodes, and extraneous text, and formats them as '[Number] km' on separate lines.

Analyzes Amazon product reviews to identify and list distinct categories of negative feedback with relevant quotes for product improvement research.

Extracts structured subject-relation-object triplets or generates simple sentences and simplified relations based on user request, handling complex grammatical structures.

Generates parody names for brands or words in a fantasy setting using portmanteaus, adhering to specific linguistic constraints such as suffix, thematic relation, and syllable count.

Calculates prices for fantasy tavern items (food, drinks, lodging) based on specific cost anchors and formats currency using a lowest-denomination logic.

Generate optimized grid layouts for a farming game where items provide specific buffs to orthogonal neighbors, ensuring no identical items are adjacent and maximizing buff coverage.