ECNU-ICALK/AutoSkill - Page 63

excel-status-calculation-based-on-column-comparison

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.

excel-vba-caller-specific-macro-execution

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.

excel-vba-column-validation-logic

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

excel-vba-conditional-row-coloring-macro

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.

excel-vba-day-boundary-highlighting

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.

excel-vba-double-click-task-duplication-macro

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.

excel-vba-file-renaming-based-on-hyperlinks-and-status

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.

excel-vba-formula-protection-with-user-interface-restriction

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.

excel-vba-mark-latest-time-per-date

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.

excel-vba-repeating-day-sequence-validator

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.

excel-vba-search-copy-and-format-macro

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.

excel-vba-userform-event-driven-data-entry

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.

executive-communication-assistant-for-senior-vp-interactions

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

executive-technical-refiner

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,…

expand-text-to-54-words

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

expert-prompt-architect-creator

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

explain-chemistry-learning-requirements

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-event-marketing-software-features-simply

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

explain-math-operations-to-5th-graders

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.

explain-to-a-young-child

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.

export-html-table-to-excel-using-xlsx-js-stylejs

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

extract-adverse-events-of-special-interest-aesi

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

extract-circuit-graph-edge-features

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.

extract-distance-values-km

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

extract-name-and-tax-id-from-pdf-invoices

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

extract-negative-feedback-categories

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

extract-pre-softmax-embeddings-to-dictionary

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-quote-and-apply-to-cities

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

extract-triplets-and-simple-sentences

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

fantasy-brand-parody-generator

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.

fantasy-tavern-pricing-and-currency-formatting

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

farm-layout-optimization

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.

fastapi-generic-dynamic-filtering-with-pydantic-and-sqlalchemy

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.

federal-reserve-statement-sentiment-scoring

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

female-therapist-detailed-roleplay

Engages in immersive roleplay as a female therapist with a detailed background, maintaining narrative continuity and strict formatting rules while avoiding AI disclaimers.

fictional-battle-simulation

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.

fictional-character-chat-roleplay

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.

fictional-entity-description-with-unique-feature

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.

fill-in-the-blanks-without-changing-text

Completes sentences with missing words while strictly preserving the original text structure and wording.

filter-and-print-bids-above-mark-price

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.