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