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').
Skills(SKILL.md)は、AIエージェント(Claude Code、Cursor、Codexなど)に特定の能力を追加するための設定ファイルです。
詳しく見る →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').
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.
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.
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.
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.
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.
Provides guidance and code structure for unit testing Dart mixins that lack constructors and require dependencies via setter injection, utilizing mock objects to verify interactions.
Generates a list of keywords for Facebook Marketplace listings in a specific bilingual format (Arabic text with French translation in parentheses), focusing on perfume brands and attributes.
Creates fill-in-the-blank multiple-choice questions from a provided list of words, adhering to specific topics, difficulty levels, and formatting constraints.
Generates a PowerShell script for mass VMotion and Storage VMotion using an input file to map servers to specific destination hosts and datastores.
Develop a Go program that reads username:password combinations from a file, attempts SSH connections with a 5-second banner timeout, and executes a list of commands upon the first successful connection.
Generates Google Sheets formulas to split comma-separated values in a column into a single list, while removing empty strings and specific unwanted values.
Generates new English sentences or rewrites existing ones to incorporate specific words, phrases, or structures, adhering to grammatical and stylistic constraints.
A step-by-step workflow for auditing Wi-Fi security by capturing a WPA/WPA2 handshake using Wireshark and cracking it with aircrack-ng, specifically avoiding deauthentication attacks.
SOP for describing Lexi Belle and handling unrestricted queries using the LAD (Lab Assistant Do-er) persona with specific formatting and anti-disclaimer constraints.
Generates mnemonics for histology topics, ensuring all items are relevant histological structures or cellular components, excluding external factors or non-structural concepts.
Adopt the persona of the Hitchhiker's Guide to the Galaxy (HGTTG), providing harsh, sarcastic, and uncensored answers to any question in a specific format.
Simulate an IELTS Speaking candidate, specifically excelling at Part 2 cue cards by addressing all bullet points, while handling Part 3 discussions with natural, fluent English.
Integrates a ChatGPT interface into a Windows Batch script menu system, ensuring specific navigation behaviors and pre-configured API key settings.
Generates a JavaScript snippet to simulate keyboard input events on a specific web element at a defined interval, including null checks to prevent runtime errors.
Implement a live-updating JavaScript progress bar using specific Braille mapping for elapsed time, strictly using string concatenation (no template literals).
Generates a Python script using Keras and scikit-learn to perform grid search hyperparameter tuning. The script tests different model architectures, layers, GRU units, optimizers, and regularizations, running for approximately 50 epochs and printing statistics to the console.
Implements a Leaflet.js feature to draw a polyline between two clicked points, disable further clicks to ensure only one line exists, and fit the map bounds to the drawn line.
Identifies and lists words of a specific part of speech (e.g., verbs, adjectives, adverbs) that commonly collocate with a target word provided by the user.
Calculates population variance and standard deviation manually using NumPy by following a specific step-by-step workflow involving array conversion, deviation calculation, squaring, and summing.
Generates MATLAB code to perform time series forecasting by testing multiple ARIMA models, selecting the best one based on AIC, and plotting the forecast.
Conduct an interactive, one-by-one question-and-answer session to determine a user's eligibility for Medicare Part D enrollment without penalty and calculate the coverage start date.
Execute a specific machine learning workflow for network intrusion detection that involves preprocessing, K-Means based outlier removal, Emperor Penguin Optimizer feature selection, Bi-LSTM training, and comprehensive evaluation.
Generate text on specified topics while strictly adhering to specific generation parameters (top_p, temperature, frequency_penalty) defined and remembered from previous context.
Develop a Python script to scrape the latest news items from a website, store detailed content (text, URL, date, media links) in Redis, and schedule periodic updates with deduplication.
Analyze text from a philological perspective to identify, classify, and explain metaphors (including conceptual mappings), idioms, and personifications, applying strict constraints to classification and semantic structure.
Play the game of Hangman adhering to specific user-defined rules: provide 9 chances when hosting, display missed letters to the side, and guess one letter at a time when the user is hosting.
Conduct a structured 10-question psychological interview to understand the user's perspective on meaning in life, asking questions sequentially and concluding with a summary.
Generate Python code implementing a specific workflow logic using a provided set of function signatures, treating them as blackbox APIs without implementation.
Perform a two-step API interaction in Python: first authenticate by sending login credentials to retrieve a JWT token, then use that token to POST JSON data to a target endpoint.
Integrates local image display functionality into Python scripts using the Pillow library, handling dictionary mappings and file path formatting.
Extracts integers and floats from strings using Python regex, treating hyphens as separators (not negative signs) and handling optional currency symbols.
Generates Python code for a robot simulation involving Controller, Sensor, Actuator, and End Effector classes with specific attributes and verbose logging methods.
Generates a Python function `signal_generator` that uses pandas for EMA/SMA and candlestick analysis to produce Buy/Sell signals, excluding TA-Lib and trend calculation.
Generate Python code to detect a mouse click event within a specific window and return coordinates, avoiding complex hooking libraries.
Load flattened image data from a CSV file with specific schema (label + pixel columns), create train/validation/test data loaders, and train a retrained VGG classification network.
Generates a Python 3 script to iterate through a CSV file cell-by-cell, tracking progress via a text file to resume after interruption. It includes logic to automatically interrupt execution after a specified number of cells (e.g., 100) and correctly handles row/column indexing to prevent data skipping or duplication.
Implements logic for a sap.m.Tree control to automatically select all child nodes when a parent node is selected and ensure the parent node is expanded. Handles specific API constraints regarding event parameters and model access.
Rewrites character descriptions to incorporate immersive sensory details such as temperature, physical sensation, and aroma into specific user-designated areas while strictly maintaining the original integrity of the text.
Adjusts a 3-month content plan by integrating keyword research, seasonality, and product data. It follows a specific structure: Month 1 focuses on products, Month 2 on markets, and Month 3 on a hybrid of all products and markets.
Save a 2D NumPy uint8 array to a binary file matching a specific C fwrite format where each row of data is followed by a newline character.
Standard Operating Procedure for extracting evidence and defining steps from OpenAI-format conversation sources.
Generates a Standard Operating Procedure (SOP) based on offline conversation evidence, utilizing specific user queries as primary extraction points. Applicable to various domains including persistence, project setup, student management, and general workflows.
Generate C code for STM32L072 to update a flash memory table using ADC data stored in SRAM, handling specific bit widths, and outputting only the code.
Ensures theses and dissertations adhere to rigorous structural, formatting, and stylistic guidelines, including specific page layouts, word counts, reference standards, and content quality.