Menú
Skills en este repositorio
SkillsMP ha recopilado 4256 skills de ECNU-ICALK/AutoSkill. Abre una skill para revisar su origen y sus detalles.
ECNU-ICALK/AutoSkillMostrando 40 de 4256 skills recopiladas.
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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').
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
Assists in framing strategic or challenging questions, drafting concise responses to executive inquiries, and providing guidelines for meetings with a Senior Vice President.
Idioma del texto original: inglés
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,…
Idioma del texto original: inglés
Expands a provided topic, sentence, or short text into a single paragraph of exactly 54 words, maintaining the original meaning and context.
Idioma del texto original: inglés
Iteratively creates, mixes, and refines ChatGPT prompts using a strict three-section output format and first-person perspective.
Idioma del texto original: inglés
Analyzes provided Chemistry Learning Objectives and Essential Knowledge points to explain what concepts and skills a student needs to learn to meet the objective.
Idioma del texto original: inglés
Explain specific features, processes, or considerations related to event marketing software using simple, clear language. Adhere to specified word count limits if provided.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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).
Idioma del texto original: inglés
Identifies and lists Adverse Events of Special Interest (AESI) from provided clinical study context, adhering to a strict short-answer format.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
Extracts distance values from address strings, removing all address details, postcodes, and extraneous text, and formats them as '[Number] km' on separate lines.
Idioma del texto original: inglés
Extracts client name and tax ID from PDF invoice files using Python, based on specific anchor text 'cliente' and 'N.º de contribuinte'.
Idioma del texto original: inglés
Analyzes Amazon product reviews to identify and list distinct categories of negative feedback with relevant quotes for product improvement research.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
Extract a short quotation from a specified research paper or book and write exactly one sentence explaining how the idea applies to cities.
Idioma del texto original: inglés
Extracts structured subject-relation-object triplets or generates simple sentences and simplified relations based on user request, handling complex grammatical structures.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
Calculates prices for fantasy tavern items (food, drinks, lodging) based on specific cost anchors and formats currency using a lowest-denomination logic.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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).
Idioma del texto original: inglés
Engages in immersive roleplay as a female therapist with a detailed background, maintaining narrative continuity and strict formatting rules while avoiding AI disclaimers.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés
Completes sentences with missing words while strictly preserving the original text structure and wording.
Idioma del texto original: inglés
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.
Idioma del texto original: inglés