agentsclimarketplace

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

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

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.

What its author says it does

Copied from the file, not written here

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.

SKILL.md

2.0 KB, 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

Keep looking

Skills are one crate of 328,083. 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.