Media & documents
9,982 rows, by stacks then stars
103 of these skill files have been read, by 99 distinct authors, and what they tell an agent counted. What Media & documents authors agree on, and what they forbid
Excel vba double click task duplicator
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-vba-double-click-task-duplicator Skill
no license551★ repoGenerates VBA code for a worksheet double-click event to duplicate task rows, shift data down, clear specific rows, and prevent edit mode based on user confirmation.
Excel vba formula protection and user notification
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-vba-formula-protection-and-user-notification Skill
no license551★ repoGenerates VBA code to protect only formula cells on a worksheet while allowing VBA macros to run and users to edit non-formula cells. Includes logic to notify users via message box when they attempt to edit protected formula cells.
Excel vba search copy and format macro
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/excel-vba-search-copy-and-format-macro Skill
no license551★ repoGenerates a VBA subroutine to search a source sheet for a user input, copy all matches to a destination sheet, highlight source cells yellow, apply random non-white colors to destination columns, replace destination values with 'X', and log the search term.
Extract name and tax id from pdf invoices
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/extract-name-and-tax-id-from-pdf-invoices Skill
no license551★ repoExtracts the client name and tax ID from PDF invoice files based on specific text markers ('cliente' and 'N.º de contribuinte').
Generate dark humor short video scripts
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/generate-dark-humor-short-video-scripts Skill
no license551★ repoGenerates funny, controversial dialogue scripts for 20-second video reels featuring two characters, using dark humor and organic storytelling.
Generate project presentation content
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/generate-project-presentation-content Skill
no license551★ repoGenerates slide content for a project presentation following a specific structure: description, reasons, learning goals, steps/time, and a concluding invitation with visual placeholders.
Generate two phase commercial strategy slide
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/generate-two-phase-commercial-strategy-slide Skill
no license551★ repoGenerates content for an executive PowerPoint slide outlining a commercial strategy consisting of a piloting phase (validating product reality via KPIs) and a staggered investment phase (triggered by pilot success).
Geometric visualization with single line svg paths
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/geometric-visualization-with-single-line-svg-paths Skill
no license551★ repoGenerate JavaScript and SVG code for geometric shapes (2D and 3D) using dynamic DOM creation and single continuous path lines for wireframes.
Gps data interpolation and csv export
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/gps-data-interpolation-and-csv-export Skill
no license551★ repoGenerates a Python script to interpolate GPS coordinates and measurements, dynamically calculating grid points based on input size (multiplied by 10), and exports the result to a CSV with a specific schema.
Inquiry based slide creator with 7th grade style
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/inquiry-based-slide-creator-with-7th-grade-style Skill
no license551★ repoGenerates content for inquiry-based school projects (like Google Slides) following a specific structure of headings, subheadings, evidence, and reasoning, written at a 7th-grade reading level with a natural tone.
Insert s3 images into excel from dataframe
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/insert-s3-images-into-excel-from-dataframe Skill
no license551★ repoGenerate Python code to iterate through S3 keys stored in a pandas DataFrame, fetch the images using boto3, and embed them as actual images into an Excel file.
Media broadcast status checker
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/media_broadcast_status_checker Skill
no license551★ repoDetermines the broadcast availability of a specific media title across a list of countries, classifying the status as 'yes', 'partially', 'no', or 'unknown' based on dubbing, subtitles, and channel information.
Public health advocacy presentation outline
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/public-health-advocacy-presentation-outline Skill
no license551★ repoGenerates a step-by-step PowerPoint outline to advocate for a public health policy or program, covering political, social, and economic strategies to improve health equity for diverse populations.
Pyinstaller audio file bundling and runtime access
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/pyinstaller-audio-file-bundling-and-runtime-access Skill
no license551★ repoGuides the user on how to bundle audio files into a PyInstaller --onefile executable using the --add-data flag and access them at runtime using sys._MEIPASS.
Python script to write tamil text in docx using python docx
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/python-script-to-write-tamil-text-in-docx-using-python-docx Skill
no license551★ repoGenerates Python code using the `python-docx` library to write Tamil text into a Word document, utilizing the `add_run` method and applying a Tamil font for correct rendering.
Python youtube audio and thumbnail downloader and merger
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/python-youtube-audio-and-thumbnail-downloader-and-merger Skill
no license551★ repoGenerates Python code to download audio and thumbnails from YouTube using pytube, merges them into a video using ffmpeg, and cleans up temporary files.
Refactor excel vba worksheet code to standard module
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/refactor-excel-vba-worksheet-code-to-standard-module Skill
no license551★ repoGuides the user in moving VBA logic from worksheet modules to a standard module to reuse code across multiple sheets, specifically handling the conversion of Private event handlers to Public subs and resolving scope/reference issues like the 'Me' keyword and 'Target' arguments.
Social media content and strategy generator
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/social_media_content_and_strategy_generator Skill
no license551★ repoGenerates algorithm-optimized social media drafts and comprehensive content plans for platforms like LinkedIn, Twitter, and Instagram. Supports professional, humorous, and specific persona-based tones (e.g., Jesus Christ), utilizing specific inputs like stories, links, or single sentences.
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/text-based-excel-simulator Skill
no license551★ repoSimulates a text-based Excel interface, generating tables with row numbers and column letters, executing formulas, and outputting strictly the table text without explanations.
Video summarization via object tracking
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/video-summarization-via-object-tracking Skill
no license551★ repoImplements a computer vision pipeline to summarize videos by detecting and tracking multiple objects, selecting only frames containing motion.
Viral social media campaign assistant
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8/viral-social-media-campaign-assistant Skill
no license551★ repoGenerates content ideas and strategies for social media campaigns focused on awareness and trends. Enforces a 'no decline' policy for helpful ideas, prohibits branding, and optimizes for shareability (stunts, visual hooks) especially on short-form platforms.
Academic media reaction and primary source analysis
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/academic-media-reaction-and-primary-source-analysis Skill
no license551★ repoAdopt the persona of an excellent student to write a two-paragraph analysis of a film or media piece. The first paragraph focuses on initial reactions, surprising elements, and interactions. The second paragraph analyzes the work as a primary source, extracting historical information and evaluating its reliability.
Automate excel to word data transfer on document open
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/automate-excel-to-word-data-transfer-on-document-open Skill
no license551★ repoCreate VBA code for a Word document to automatically pull specific cell values from an active Excel workbook into a 2x2 table when the document is opened.
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/brand-subtitle-copywriting Skill
no license551★ repoGenerates concise, memorable, and attention-grabbing subtitles for businesses or professions that highlight unique value and align with specific brand identity tones.
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/clean-sql-output-for-excel Skill
no license551★ repoFormats raw SQL query results for Excel by removing metadata, rounding numbers, and ensuring a professional layout.
Convert chess descriptive notation to pgn with ocr handling
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/convert-chess-descriptive-notation-to-pgn-with-ocr-handling Skill
no license551★ repoConverts chess games from old descriptive notation to algebraic notation and outputs them in PGN format, specifically handling text scraped from PDFs that may contain OCR inaccuracies.
Correct pdf scraped descriptive chess
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/correct_pdf_scraped_descriptive_chess Skill
no license551★ repoCorrects OCR errors in chess games recorded in descriptive notation, fixing symbol substitutions, character misreads, and spacing issues while ensuring logical validity.
Create pokemon style profiles for video game characters
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/create-pokemon-style-profiles-for-video-game-characters Skill
no license551★ repoTransforms video game bosses or characters into Pokemon-style profiles, assigning Types, Abilities, and Moves based on their original powers and characteristics.
Distributed rate limiting with excel configuration
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/distributed-rate-limiting-with-excel-configuration Skill
no license551★ repoDesign a centralized rate limiting system for Spring Boot applications on Kubernetes that reads API limits from an Excel file and synchronizes request counts across multiple pods using Redis.
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/dna-to-mrna-transcription Skill
no license551★ repoTranscribes DNA sequences into complementary mRNA sequences, adhering to base pairing rules (A-U, T-A, C-G, G-C) and handling specific output directionality requests (5' to 3' or 3' to 5').
English to katakana transcription
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/english-to-katakana-transcription Skill
no license551★ repoTranscribes English sentences into Japanese Katakana characters based on phonetic syllables without translating the meaning.
Excel date range parsing and formatting
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-date-range-parsing-and-formatting Skill
no license551★ repoExtracts start and end dates from a string formatted as 'Day DD Mon YYYY - Day DD Mon YYYY', converts them to date values, and formats them as 'dd mm yyyy' or extracts individual components.
Excel drop down list without blanks
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-drop-down-list-without-blanks Skill
no license551★ repoGenerates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.
Excel financial data analysis and visualization
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-financial-data-analysis-and-visualization Skill
no license551★ repoAnalyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.
Excel formula for right to left text extraction
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-formula-for-right-to-left-text-extraction Skill
no license551★ repoGenerates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.
Excel status calculation based on column comparison
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-status-calculation-based-on-column-comparison Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-caller-specific-macro-execution Skill
no license551★ repoImplement 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-column-validation-logic Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-conditional-row-coloring-macro Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-day-boundary-highlighting Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-double-click-task-duplication-macro Skill
no license551★ repoGenerates 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 duplicate prevention for composite keys columns a and
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-duplicate-prevention-for-composite-keys-columns-a-and- Skill
no license551★ repoGenerates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D.
Excel vba file renaming based on hyperlinks and status
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-file-renaming-based-on-hyperlinks-and-status Skill
no license551★ repoA 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-formula-protection-with-user-interface-restriction Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-mark-latest-time-per-date Skill
no license551★ repoGenerates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-repeating-day-sequence-validator Skill
no license551★ repoValidates 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-search-copy-and-format-macro Skill
no license551★ repoA 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
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel-vba-userform-event-driven-data-entry Skill
no license551★ repoGenerates 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.
Excel data merge transformation pipeline
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel_data_merge_transformation_pipeline Skill
no license551★ repoGenerates a Python script to merge and transform Excel files using specific GL and employee mappings, including removing trailing rows, splitting strings, and calculating balances.
Excel date filter concat formula
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/excel_date_filter_concat_formula Skill
no license551★ repoGenerates Excel array formulas to filter rows by date criteria (range or offset), format dates as 'dd-mm-yyyy', and concatenate multiple columns with double spaces into separate rows.
Export html table to excel using xlsx js style js
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/export-html-table-to-excel-using-xlsx-js-style-js Skill
no license551★ repoGenerates 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 name and tax id from pdf invoices
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/extract-name-and-tax-id-from-pdf-invoices Skill
no license551★ repoExtracts client name and tax ID from PDF invoice files using Python, based on specific anchor text 'cliente' and 'N.º de contribuinte'.
Generate 7th grade inquiry slides
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-7th-grade-inquiry-slides Skill
no license551★ repoGenerates Google Slides content with specific headings, subheadings, and evidence-reasoning logic, written at a 7th-grade reading level.
Generate instagram carousel design ideas for spiritual quotes
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-instagram-carousel-design-ideas-for-spiritual-quotes Skill
no license551★ repoGenerates structured descriptions of Instagram carousel post formats for spiritual quotes, detailing the visual layout of the cover slide and subsequent quote slides.
Generate mermaid flowchart from text
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-mermaid-flowchart-from-text Skill
no license551★ repoExtracts key information from provided text, translates it to English, fact-checks the content, and generates valid Mermaid flowchart code with strict syntax adherence.
Generate organism presentation content from rubric
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-organism-presentation-content-from-rubric Skill
no license551★ repoGenerates presentation slide content for a specific organism based on a structured educational rubric, covering organism classification, ecosystem factors, food chains/webs, interesting facts, and human impact.
Generate small airplane social media content ideas
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-small-airplane-social-media-content-ideas Skill
no license551★ repoGenerate short, punchy video titles and content ideas for a small airplane aviation client, focusing on specific niches like bush flying, tail wheels, and vintage aircraft, suitable for TikTok and Instagram Reels.
Generate two phase commercial strategy slide
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-two-phase-commercial-strategy-slide Skill
no license551★ repoGenerates an executive PowerPoint slide for a commercial strategy consisting of a piloting phase (validating product reality via KPIs) and a conditional staggered investment phase.
Generate youtube video hashtags
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/generate-youtube-video-hashtags Skill
no license551★ repoGenerates high-quality, SEO-optimized hashtags for YouTube video titles to improve discoverability and categorization.
Gps data interpolation and csv export
ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/gps-data-interpolation-and-csv-export Skill
no license551★ repoInterpolates GPS coordinate measurements with a grid density calculated as input count multiplied by 10, and exports the result to a CSV file with specific column headers.