How do I find which Revit views are not on sheets and which are safe to delete with AI before a model handoff?

Read this Revit View List export [upload the text or CSV file] and build a Views table with one row per view: View Name, Family and Type, Sheet Number, Dependency, Referencing Sheet and View Template, copied exactly. Write NOT SHOWN instead of guessing. List every primary view and the dependents under it, and every view with no sheet number but a Referencing Sheet value. Do not rename, drop or recommend deleting any view.

EXAMPLE DATA ONLY. Here is my Views tab [paste the example rows] and my Rules tab: protected prefixes [type yours] and scratch-view words [type yours]. Write Excel formulas (or a step-by-step Copilot plan) that tag each view in this order: KEEP if it has a sheet number; KEEP if it is a primary view with any dependent that has a sheet number; FIX if it has no sheet number but has a Referencing Sheet; KEEP if it starts with a protected prefix; REVIEW if its name contains a scratch word; otherwise CANDIDATE. Then count each tag. Use only my data.

Views tab (example, saved as view_list.csv; a tab-delimited Revit export works too)
View Name,Type,Sheet Number,Dependency,Referencing Sheet,View Template
Level 1 - Framing Plan,Structural Plan,S-101,Independent,,S Framing
Level 2 - Framing Plan,Structural Plan,,Primary,,S Framing
Level 2 - Framing Plan - Area A,Structural Plan,S-102,Dependent on Level 2 - Framing Plan,,S Framing
Level 2 - Framing Plan - Area B,Structural Plan,S-103,Dependent on Level 2 - Framing Plan,,S Framing
Level 3 - Framing Plan,Structural Plan,S-104,Primary,,S Framing
Level 3 - Framing Plan - Area A,Structural Plan,,Dependent on Level 3 - Framing Plan,,S Framing
Section 4,Section,,Independent,S-301,
Section 7,Section,S-302,Independent,S-101,S Section
Copy of Level 1 - Framing Plan,Structural Plan,,Independent,,
Roof Framing - WORKING,Structural Plan,,Independent,,
COORD - Clash Review 3D,3D View,,Independent,,
{3D},3D View,,Independent,,
Foundation Plan - Old,Structural Plan,,Independent,,
Detail 3 - Typical Beam Bearing,Detail View,,Independent,,
Rules typed by you: protected prefix COORD; scratch words WORKING, Copy of, {3D, Old

EXAMPLE DATA ONLY (not from a real project). Views tab: 14 rows from a Revit View List export with View Name, Type, Sheet Number, Dependency, Referencing Sheet and View Template. Rules tab: protected prefix COORD; scratch words WORKING, Copy of, {3D, Old. Write Excel formulas (or a step-by-step Copilot plan) that tag each view KEEP (on a sheet, primary view with a placed dependent, or protected prefix), FIX (not on a sheet but marker shows on a sheet), REVIEW (scratch word) or CANDIDATE (everything else), and count each tag. Use only my data; do not delete or rename anything.

Expected results on this example (output of the script below on these rows)
Level 1 - Framing Plan             KEEP  on sheet S-101
Level 2 - Framing Plan             KEEP  primary view; dependents placed on S-102, S-103 (deleting it deletes them)
Level 2 - Framing Plan - Area A    KEEP  on sheet S-102
Level 2 - Framing Plan - Area B    KEEP  on sheet S-103
Level 3 - Framing Plan             KEEP  on sheet S-104
Level 3 - Framing Plan - Area A    CANDIDATE not on a sheet, no placed dependents, no marker on a sheet; confirm before deleting
Section 4                          FIX   not on a sheet but its marker shows on S-301: place it or hide the marker, do not just delete
Section 7                          KEEP  on sheet S-302
Copy of Level 1 - Framing Plan     REVIEW scratch-view name; confirm with the view's owner, then delete
Roof Framing - WORKING             REVIEW scratch-view name; confirm with the view's owner, then delete
COORD - Clash Review 3D            KEEP  protected prefix | note: no view template
{3D}                               REVIEW scratch-view name; confirm with the view's owner, then delete
Foundation Plan - Old              REVIEW scratch-view name; confirm with the view's owner, then delete
Detail 3 - Typical Beam Bearing    CANDIDATE not on a sheet, no placed dependents, no marker on a sheet; confirm before deleting
{'KEEP': 7, 'CANDIDATE': 2, 'FIX': 1, 'REVIEW': 4} | total 14

Note what the plain Not on Sheets filter would have shown: 9 views, including Level 2 - Framing Plan (deleting it would also delete two placed dependent views) and Section 4 (deleting it would remove a marker from S-301).

Suggested Excel logic (write against your own sheet layout)
- Placed dependent: in a helper column on dependent rows, the parent name =TRIM(MID([@Dependency],14,200)); a primary view is KEEP when COUNTIFS(Views[Parent],[@[View Name]],Views[Sheet Number],"<>")>0.
- On a sheet: [@[Sheet Number]]<>"". Marker on a sheet: [@[Sheet Number]]="" with [@[Referencing Sheet]]<>"".
- Protected prefix: COUNTIF over the prefix list using LEFT([@[View Name]],LEN(prefix)). Scratch word: ISNUMBER(SEARCH(word,[@[View Name]])) for any word on the Rules tab.
- Tag in that order with IFS, then COUNTIF the tag column for the summary.

Same check as a short Python script (our own code; reads the rows above saved as view_list.csv)
import csv
from collections import Counter
PROTECT = ("COORD",)                                  # name prefixes you never delete (typed by you)
REVIEW_WORDS = ("WORKING", "COPY OF", "{3D", "OLD")   # words that usually mean scratch views (typed by you)
text = open("view_list.csv", encoding="utf-8-sig").read()
rows = list(csv.DictReader(text.splitlines(), delimiter="	" if "	" in text.splitlines()[0] else ","))
placed_children = {}
for r in rows:
    dep = r["Dependency"].strip()
    if dep.lower().startswith("dependent on ") and r["Sheet Number"].strip():
        placed_children.setdefault(dep[13:].strip(), []).append(r["Sheet Number"].strip())
count = Counter()
for r in rows:
    name, sheet, ref = r["View Name"].strip(), r["Sheet Number"].strip(), r["Referencing Sheet"].strip()
    up = name.upper()
    if sheet:
        tag = f"KEEP  on sheet {sheet}"
    elif name in placed_children:
        tag = f"KEEP  primary view; dependents placed on {', '.join(placed_children[name])} (deleting it deletes them)"
    elif ref:
        tag = f"FIX   not on a sheet but its marker shows on {ref}: place it or hide the marker, do not just delete"
    elif up.startswith(PROTECT):
        tag = "KEEP  protected prefix"
    elif any(w in up for w in REVIEW_WORDS):
        tag = "REVIEW scratch-view name; confirm with the view's owner, then delete"
    else:
        tag = "CANDIDATE not on a sheet, no placed dependents, no marker on a sheet; confirm before deleting"
    if not sheet and not r["View Template"].strip() and tag.startswith("KEEP"):
        tag += " | note: no view template"
    count[tag.split()[0]] += 1
    print(f"{name:34} {tag}")
print(dict(count), "| total", len(rows))
print("Flags only. Deleting views is done in Revit by the BIM coordinator on a saved copy.")