Menu
Skills neste repositório
O SkillsMP coletou 4.256 skills de ECNU-ICALK/AutoSkill. Abra uma skill para revisar a origem e os detalhes.
ECNU-ICALK/AutoSkillMostrando 40 de 4.256 skills coletadas.
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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do texto original: inglês
Iteratively creates, mixes, and refines ChatGPT prompts using a strict three-section output format and first-person perspective.
Idioma do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do 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 do texto original: inglês
Completes sentences with missing words while strictly preserving the original text structure and wording.
Idioma do 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 do texto original: inglês