Live survey304 models · 14 providers · 22,792 auditsAudited grill-with-docs · SAFE →What changedHow we verifyllms.txt

Agent skill · Audited from source

Excel Vba Mark Latest Time Per Date

skill · ECNU-ICALK/AutoSkillLicence not declaredAudited 14 Oct 2026 · source 04e912cff54b

★ 602pushed 157 days agoversion 0.1.0
✓SAFEGrade B · 89/100 · 14 Oct 2026 · 04e912c
602repo stars · whole ECNU-ICALK/AutoSkill
InstallView source on GitHub ↗

Is it safe? Yes — SAFE, grade B (89/100). We read this skill's source at commit 04e912cff54b and found no filesystem, network or shell access and no hard-coded secrets. What it does: Generates 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.

Ask an AI about this pageGChatGPTCClaudePPerplexityGeGeminiXGrok
More
CoCopilotAIGoogle AI Mode
Cite

Cite this page

ModelsAtlas. “Excel Vba Mark Latest Time Per Date (ECNU-ICALK/AutoSkill)”. Retrieved 14 Oct 2026. https://modelsatlas.com/skills/ecnu-icalk/excel-vba-mark-latest-time-per-date

Trust audit

Audit 0.4.1 · source read 14 Oct 2026

Trust score89/100✓SAFE B
0 critical0 high0 medium0 low0 info

SAFE means nothing in the source contradicts what the skill says it does. Grade B is shared by 16,667 of 17,602 audited skills.

What the source does

  • FilesystemNone observedNo reads or writes in the source
  • NetworkNone observedNo outbound calls in the source
  • ShellNone observedNo commands run in the source
  • DependenciesPinnedNothing floats
  • SecretsNone foundNo keys in source

Five audit layers

LayerWhat we checkResultFindings
L0 ProvenanceRepo owner, licence, archive status, activityPASS0
L1 Static sourceSecrets, path traversal, supply chain, hidden codeNA0
L2 InstructionsPrompt injection, authority framing, hidden directivesPASS0
L3 InventoryThe files and declarations match the sourcePASS0
L4 SandboxRun in isolation and watch behaviourSKIPPED why0

Gates applied: no behavioural pass.

Findings (0)

No findings at any severity. We re-audit when the source changes.

Audit 0.4.1 · source sha 04e912cff54b · 14 Oct 2026Report an issue or request a re-scan

Provenance

Who published it, and what the verdict is pinned to

What it tells the agent

Full source on GitHub ↗

Its description: Generates 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.

---
id: "0d66dea6-05da-42c3-87f5-6d93e6932d7f"
name: "Excel VBA Mark Latest Time per Date"
description: "Generates 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."
version: "0.1.0"
tags:
  - "excel"
  - "vba"
  - "data processing"
  - "automation"
  - "date time"
triggers:
  - "vba code to find latest time per date"
  - "mark row with max time in excel"
  - "append text based on date and time vba"
  - "excel macro group by date find latest time"
---

# Excel VBA Mark Latest Time per Date

Generates 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.

## Prompt

# Role & Objective
You are an Excel VBA Developer. Your task is to write a VBA macro that processes a worksheet to find the latest time entry for each unique date and marks that specific row.

# Operational Rules & Constraints
1. **Input Data**:
   - Column A contains repetitive date values (formatted as Custom date 'dddd dd/mm/yy').
   - Column E contains repetitive time values (formatted as Time '1:30.55 PM').
2. **Core Logic**:
   - Iterate through all rows in the used range.
   - For each unique date found in Column A, determine the maximum (latest) time value present in Column E.
   - Identify the specific row where this latest time occurs for that date.
3. **Output Action**:
   - Append the text 'Close' to the existing content in Column V for the identified row(s).
4. **Error Handling & Syntax**:
   - **Do NOT** use the `Continue For` statement, as it is not supported in Excel VBA. Use `GoTo` labels or nested `If` structures to skip iterations.
   - Handle potential Type Mismatch errors by validating cell contents using `IsDate` before processing.
   - Handle custom date and time formats carefully to avoid 'Expected Array' errors. Use `DateValue` and `TimeValue` functions or direct `.Value` assignment appropriately based on the cell format context.
   - Use a Dictionary object to efficiently track the latest time for each date.

# Interaction Workflow
1. Provide the complete, ready-to-run VBA code within a code block.
2. Include brief instructions on how to insert and run the macro (Alt+F11, Insert Module, Alt+F8).

## Triggers

- vba code to find latest time per date
- mark row with max time in excel
- append text based on date and time vba
- excel macro group by date find latest time

Excerpt, first 2,480 characters of SKILL.md, verbatim from the audited commit. It is text from someone else’s repository, quoted so you can judge it before your agent reads it.

Install

Pinned to the audited commit 04e912c

Download folder ↗
git clone https://github.com/ECNU-ICALK/AutoSkill
git -C AutoSkill checkout 04e912cff54b

The author documents no install command, so this uses the repository directly. Our verdict covers commit 04e912cff54b only.

Works in

The author has not said which agents this skill supports, and we have not tested it in any.

Audit history

Every audit, every source change

  1. ✓SAFE B 89 / 100

    first audit · source 04e912cff54b

Similar skills

All data & analysis skills →
1 Back Working Memory Test✓SAFE

ECNU-ICALK/AutoSkill

Executes a 1-back test by comparing the current input to the immediately preceding input in a sequence, reporting the prior item and a match indicator.

★ 602Grade B
80 20 Learning Plan Generator✓SAFE

ECNU-ICALK/AutoSkill

Identifies the critical 20% of a given topic that yields 80% of the results and creates a focused learning plan to master it.

★ 602Grade B
A1 English Conversation Teacher✓SAFE

ECNU-ICALK/AutoSkill

Act as a friendly English teacher for A1 students. Correct errors briefly, ask clarifying questions to maintain dialogue, and strictly limit responses to 100 words.

★ 602Grade B
ABC结构化信念挑战✓SAFE

ECNU-ICALK/AutoSkill

运用理性情绪疗法ABC模型,按客观事实→情绪反应→自动想法→合理/不合理区分四步顺序,引导来访者辨析创伤相关歪曲信念,并通过挑战式提问促发认知重评。

★ 602Grade B
Academic Content And Essay Generator✓SAFE

ECNU-ICALK/AutoSkill

Generates academic content components (introductions, conclusions, titles, topics) and full expository essays. Includes specialized capabilities for refining research paper titles with specific constraints, emphasis,…

★ 602Grade B
Academic Email Writing With Simple English✓SAFE

ECNU-ICALK/AutoSkill

Draft or improve emails to professors using simple vocabulary, friendly tone, and straightforward grammar.

★ 602Grade B

Questions about Excel Vba Mark Latest Time Per Date

What does the Excel Vba Mark Latest Time Per Date skill do?
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
Is Excel Vba Mark Latest Time Per Date safe to install?
The audit found nothing in the source that contradicts what it says it does, and graded it B (89/100). Grade A is held back for packages that have also passed a sandboxed behavioural run, which is why a clean skill reads B.
What can Excel Vba Mark Latest Time Per Date access on my machine?
The audit observed no filesystem, network or shell use at all in its source.
How current is this page?
The grade is for one exact copy of the source (04e912cff54b), read on 2026-10-14. The repository is watched, and a new audit runs when it changes — this is the first audit.

Sources

Spotted something wrong? Report a correction · Methodology

Keep going in your AI

Opens with this page as the source. We add nothing else to the prompt.