Generates VBA code for the Worksheet_SelectionChange event to hide rows above the selection, unhide rows when cell A1 is selected, and conditionally color cells based on values in a reference sheet.
Skills in this repository
ECNU-ICALK/AutoSkill - Page 37
SkillsMP has collected 4,256 skills from ECNU-ICALK/AutoSkill. Open a skill to review its source and details.
ECNU-ICALK/AutoSkillShowing 40 of 4,256 collected skills.
Analyze and expand the Drake Equation by incorporating specific user-defined habitability, geological, and technological factors to refine probability estimates for extraterrestrial civilizations.
Explains mathematical or machine learning concepts by combining abstract reasoning with concrete numerical examples after every step to ensure the explanation is lively and intuitive.
Takes a user-provided sequence of chords (typically 3) and extends it to a 4-chord progression by adding a suitable resolving or complementary chord.
Filters a Pandas DataFrame to retain only columns where the column name contains any string from a provided list, using case-insensitive substring matching.
Parse customer messages to identify orders or quotes, extract article numbers and quantities using spaCy, and output the result in a structured JSON format with robust entity association.
Extracts the text content following the 'Sub:' label from a given text string using a regular expression.
Generates highly compressed summaries that remove stop words while retaining full meaning and context, specifically tailored for university students with explanations of complex topics.
Simulates a turn-based magic duel RPG where players cast spells for points based on stats. It enforces specific success/failure logic based on Spell Power vs. Requirements, applies a Performance stat multiplier to points, and implements a harsh…
Manages a fantasy RPG scenario (e.g., mage training) where the protagonist regresses in age over a limited timeline. Uses d20 mechanics, tracks spells/stats, and enforces stress-induced regression with difficulty scaling and immersive narrative.
Act as a Game Master for a fantasy RPG where the hero regresses in age due to negative emotions, magical charms, or hidden subtextual traps. Manage d20 action rolls with susceptibility penalties, d6 regression mechanics, and a mischievous magical companion,…
Generates concise, descriptive 3-sentence prompts for AI image generators based on fantasy character or scene descriptions.
Generates novel names, titles, and religions for a list of provided divinities and their domains, adapting to specific cultural influences or tonal constraints.
Run a choose-your-own-adventure game set in a fantasy island resort where the user undergoes physical male-to-female transformations triggered by interactions with items and activities.
Acts as an elite writing critique partner and coauthor to brainstorm, refine, and consolidate complex magic systems and plot concepts for fantasy novels, ensuring logical consistency and narrative depth.
Solves math MCQs under strict time limits (20-30s) using shortcuts and estimation. Provides the solution and high-efficiency techniques, with simple explanations available upon request.
Handle the submission of selected images as Base64 strings from a standard HTML form to a FastAPI backend without using JavaScript for data processing.
Implements a FastAPI endpoint to serve images from a database path with dynamic resizing, aspect ratio preservation, and file-based caching. Supports multiple resize modes including stretch, centered crop, and fit.
Design and implement a local, object-oriented background task management system for FastAPI using SQLAlchemy for persistence. The system must support task lifecycle control (start, pause, stop, resume, restart), load state on startup, and avoid external…
Host a game of 20 Questions where the user thinks of a fictional character and the AI attempts to guess it within 20 yes/no questions.
Paraphrases and summarizes complex, annotated descriptions of fictional entities, organizations, or technologies into clean, coherent prose.
Analyzes descriptions of fictional characters, empires, or elements to assign specific personality traits, ethical alignments, and game-specific frameworks based on provided properties or lore.
Generates nostalgic, community-focused creative content (forums, tweets, blogs, web pages, scripts, schedules) for the Silverburn, S4C, CW4Kids, and Riki Store universes, strictly adhering to lore and emotional tone.
Simulates a TELEX machine connecting to a historical news wire, translating user queries into period-appropriate requests and returning short text passages.
Calculates group-level accuracy and bias for time series forecasts while excluding outliers based on individual accuracy and bias thresholds using Polars.
Generates a Python script to fine-tune a DistilBert model for sequence classification on a custom JSONL dataset with 'question' and 'answer' columns, using custom label encoding (no sklearn), progress logging, and error handling.
Fine-tunes a pre-trained GPT-2 model on JSONL datasets (e.g., Q&A pairs) using Hugging Face Transformers. Implements memory optimization techniques like mixed precision and gradient accumulation, handling specific tokenizer quirks like padding and special…
Generates C-Rank support conversations for RPG characters based on provided lore, backstories, and personality traits. The conversations focus on initial interactions, character introductions, and establishing dynamics between two specific characters.
Refactors Firebase anonymous-to-Google account migration logic into static utility classes, handling data merging, collision detection, and cleanup via callbacks and context passing.
Generates Five Below customer service emails for pick-up orders using specific templates and logic for inventory errors, cancellations, and readiness.
Corrects the `Filtering` Transform stream class to ensure processed audio buffers (e.g., after mono-to-stereo conversion) are pushed downstream instead of the original input chunks.
Implement a Flask PUT route to update a MongoDB document, handling multipart/form-data for images/videos, deleting old files from the server, and saving new ones.
Calculates the required diameter of PE4710 pontoon pipes for floating docks and performs comprehensive structural verification (ULS/SLS), including buoyancy, detailed lateral load checks (wind/berthing) with mooring pile mechanics, wave-induced flexure, and…
Implements the Floyd-Warshall algorithm to find all-pairs shortest paths, printing the Distance (D) and Predecessor (P) matrices at every iteration. The P matrix specifically tracks the highest index of the intermediate vertex on the shortest path.
Converts Supabase bytea image data (hex string with \x prefix) to Uint8List and displays it in a Flutter widget using MemoryImage, including fallback logic.
Provides a step-by-step workflow for implementing Firebase Phone Authentication and profile updates in FlutterFlow, including specific logic to format phone numbers with a +254 prefix (stripping leading zeros) and handling session persistence without…
Simulates a text-based Five Nights at Freddy's game with specific commands, power management, animatronic behaviors, and survival mechanics.
Generates a 5-paragraph cause-effect essay using the Focus-on-Effect method (one cause, three effects) in prose format, supported by 3 online APA references.
Rewrites structural engineering text and section titles with a sophisticated, formal register, strictly preserving LaTeX syntax and maintaining a third-person perspective.
Reorders the properties of data objects to align with a specified header array, appending any extra properties in their original order.