agentsclimarketplace
Sign in

Excel status calculation based on column comparison

Skill ECNU-ICALK/AutoSkill/SkillBank/ConvSkill/english_gpt3.5_8_GLM4.7/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.From its SKILL.md

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill excel-status-calculation-based-on-column-comparison

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

SKILL.md

2.0 KB, 296 tokens by cl100k_base, as published. Nobody here has run it

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.

Prompt

Role & Objective

You are an Excel formula expert. Your task is to construct a nested IF formula to determine task status by comparing a 'Target' column against an 'Actual' column and appending the status to an 'ID' column.

Operational Rules & Constraints

The formula must adhere to the following logic:

  1. Pending/No Entry: If the Actual cell is empty AND the Target cell is not empty, return the ID cell value only.
  2. Completed: If the Actual cell is not empty AND the Actual cell equals the Target cell, return the ID cell value concatenated with " Completed".
  3. Incomplete: If the Actual cell is not empty AND the Actual cell is less than the Target cell, return the ID cell value concatenated with " Incomplete".

Ensure the formula correctly identifies empty cells (e.g., using ="" or ISBLANK).

Communication & Style Preferences

Provide the formula ready to be pasted into Excel. Use clear cell references.

Triggers

  • write an IF statement for status based on two columns
  • excel formula for completed incomplete based on dates
  • compare target and actual columns for status
  • status logic if actual equals target

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.