ECNU-ICALK/AutoSkill - 第 37 页

excel-vba-selection-change-row-hiding-and-coloring

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.

原文语言：英语

expanded-drake-equation-analysis

Analyze and expand the Drake Equation by incorporating specific user-defined habitability, geological, and technological factors to refine probability estimates for extraterrestrial civilizations.

原文语言：英语

explain-math-concepts-with-step-by-step-numerical-examples

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.

原文语言：英语

extend-chord-progression-to-4-chords

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.

原文语言：英语

extract-dataframe-columns-by-keyword-substring-list

Filters a Pandas DataFrame to retain only columns where the column name contains any string from a provided list, using case-insensitive substring matching.

原文语言：英语

extract-order-or-quote-information-to-json

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.

原文语言：英语

extract-subject-line-from-text

Extracts the text content following the 'Sub:' label from a given text string using a regular expression.

原文语言：英语

extreme-tldr-generation

Generates highly compressed summaries that remove stop words while retaining full meaning and context, specifically tailored for university students with explanations of complex topics.

原文语言：英语

fantasy-age-regression-duel

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…

原文语言：英语

fantasy-age-regression-rpg-game-master

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.

原文语言：英语

fantasy-age-regression-rpg

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

原文语言：英语

fantasy-ai-image-prompt-generator-3-sentence-format

Generates concise, descriptive 3-sentence prompts for AI image generators based on fantasy character or scene descriptions.

原文语言：英语

fantasy-deity-pantheon-generator

Generates novel names, titles, and religions for a list of provided divinities and their domains, adapting to specific cultural influences or tonal constraints.

原文语言：英语

fantasy-island-mtf-transformation-adventure

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.

原文语言：英语

fantasy-writing-critique-and-magic-system-design

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.

原文语言：英语

fast-mcq-math-solver

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.

原文语言：英语

fastapi-base64-image-form-submission

Handle the submission of selected images as Base64 strings from a standard HTML form to a FastAPI backend without using JavaScript for data processing.

原文语言：英语

fastapi-dynamic-image-resizing-and-serving

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.

原文语言：英语

fastapi-local-oop-background-task-system

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…

原文语言：英语

fictional-character-20-questions

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.

原文语言：英语

fictional-entity-description-paraphraser

Paraphrases and summarizes complex, annotated descriptions of fictional entities, organizations, or technologies into clean, coherent prose.

原文语言：英语

fictional-entity-profiling

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.

原文语言：英语

fictional-multiverse-content-generator

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.

原文语言：英语

fictional-telex-machine-simulator

Simulates a TELEX machine connecting to a historical news wire, translating user queries into period-appropriate requests and returning short text passages.

原文语言：英语

filtered-group-forecasting-metrics-calculation

Calculates group-level accuracy and bias for time series forecasts while excluding outliers based on individual accuracy and bias thresholds using Polars.

原文语言：英语

fine-tune-distilbert-on-jsonl-dataset

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-tune-gpt2-jsonl-memory-optimized

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…

原文语言：英语

fire-emblem-style-support-conversation-generator

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.

原文语言：英语

firebase-anonymous-google-migration-utility

Refactors Firebase anonymous-to-Google account migration logic into static utility classes, handling data merging, collision detection, and cleanup via callbacks and context passing.

原文语言：英语

five-below-pickup-email-generator

Generates Five Below customer service emails for pick-up orders using specific templates and logic for inventory errors, cancellations, and readiness.

原文语言：英语

fix-native-audio-filter-stream-output

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.

原文语言：英语

flask-mongodb-update-with-file-replacement

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.

原文语言：英语

floating-dock-pontoon-sizing-and-uls-analysis

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…

原文语言：英语

floyd-warshall-algorithm-with-iterative-matrix-output

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.

原文语言：英语

flutter-supabase-bytea-image-conversion-and-display

Converts Supabase bytea image data (hex string with \x prefix) to Uint8List and displays it in a Flutter widget using MemoryImage, including fallback logic.

原文语言：英语

flutterflow-phone-auth-profile-setup-with-254-formatting

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…

原文语言：英语

fnaf-1-text-based-game-simulator

Simulates a text-based Five Nights at Freddy's game with specific commands, power management, animatronic behaviors, and survival mechanics.

原文语言：英语

focus-on-effect-cause-effect-essay-writer

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.

原文语言：英语

formal-structural-latex-rewriter

Rewrites structural engineering text and section titles with a sophisticated, formal register, strictly preserving LaTeX syntax and maintaining a third-person perspective.

原文语言：英语

format-data-objects-to-match-header-array-order

Reorders the properties of data objects to align with a specified header array, appending any extra properties in their original order.

原文语言：英语