Menu
Skills dans ce dépôt
SkillsMP a collecté 4 256 skills depuis ECNU-ICALK/AutoSkill. Ouvrez un skill pour examiner sa source et ses détails.
ECNU-ICALK/AutoSkillAffichage de 40 skills collectés sur 4 256.
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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').
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
Assists in framing strategic or challenging questions, drafting concise responses to executive inquiries, and providing guidelines for meetings with a Senior Vice President.
Langue du texte source : anglais
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,…
Langue du texte source : anglais
Expands a provided topic, sentence, or short text into a single paragraph of exactly 54 words, maintaining the original meaning and context.
Langue du texte source : anglais
Iteratively creates, mixes, and refines ChatGPT prompts using a strict three-section output format and first-person perspective.
Langue du texte source : anglais
Analyzes provided Chemistry Learning Objectives and Essential Knowledge points to explain what concepts and skills a student needs to learn to meet the objective.
Langue du texte source : anglais
Explain specific features, processes, or considerations related to event marketing software using simple, clear language. Adhere to specified word count limits if provided.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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.
Langue du texte source : anglais
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).
Langue du texte source : anglais
Identifies and lists Adverse Events of Special Interest (AESI) from provided clinical study context, adhering to a strict short-answer format.
Langue du texte source : anglais
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.
Langue du texte source : anglais
Extracts distance values from address strings, removing all address details, postcodes, and extraneous text, and formats them as '[Number] km' on separate lines.
Langue du texte source : anglais
Extracts client name and tax ID from PDF invoice files using Python, based on specific anchor text 'cliente' and 'N.º de contribuinte'.
Langue du texte source : anglais
Analyzes Amazon product reviews to identify and list distinct categories of negative feedback with relevant quotes for product improvement research.
Langue du texte source : anglais
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.
Langue du texte source : anglais
Extract a short quotation from a specified research paper or book and write exactly one sentence explaining how the idea applies to cities.
Langue du texte source : anglais
Extracts structured subject-relation-object triplets or generates simple sentences and simplified relations based on user request, handling complex grammatical structures.
Langue du texte source : anglais
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.
Langue du texte source : anglais
Calculates prices for fantasy tavern items (food, drinks, lodging) based on specific cost anchors and formats currency using a lowest-denomination logic.
Langue du texte source : anglais
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.
Langue du texte source : anglais
Implements a generic, reusable filtering mechanism in FastAPI using Pydantic and SQLAlchemy. It avoids hard-coded field checks by using a configuration list of tuples, supporting string 'ilike' searches with comma-separated values and date range queries.
Langue du texte source : anglais
Analyze Federal Reserve statements to determine their monetary policy stance and assign a sentiment score on a specific scale from -100 (most dovish) to +100 (most hawkish).
Langue du texte source : anglais
Engages in immersive roleplay as a female therapist with a detailed background, maintaining narrative continuity and strict formatting rules while avoiding AI disclaimers.
Langue du texte source : anglais
Simulates hypothetical battles between characters based strictly on the specific powers and attributes listed in the user's prompt, providing definitive outcomes and narrative descriptions.
Langue du texte source : anglais
Generates a chat room conversation script with a fictional character, adhering to a strict format where user lines start with {{user}}, character lines start with {{char}}, and actions are italicized on new lines.
Langue du texte source : anglais
Generate short descriptions for fictional entities (such as countries or pets) that strictly avoid physical appearance descriptions and instead focus on one unique or odd characteristic.
Langue du texte source : anglais
Completes sentences with missing words while strictly preserving the original text structure and wording.
Langue du texte source : anglais
A Python coding skill to filter order book bids, selecting only those with a price higher than a specified mark price, and printing their individual price and quantity details.
Langue du texte source : anglais