Skip to content
LEGION.TW
Zhongli · Taiwan

Legion · project library

Packet: Prepare the spreadsheet someone keeps sending you

Everything your agent needs to read for this project, on one page.

Free instructions · English

About this edition

Edition 2026-09-06-draft-01 · 67 projects · 10 skills

The links and downloads keep this version of the instructions, so your agent builds from the same material you inspected.

app-extensions/README.md

Extensions inside existing applications

All project types · Shared launch

Add useful behavior to familiar software while keeping the person's existing documents and working habits.

Projects to build

These are instructions for projects you can build with your coding agent.

Text edition of this document

app-extensions/spreadsheet-import.md

Prepare the spreadsheet someone keeps sending you

Build a reusable command in the person's spreadsheet workflow that turns a recurring incoming file into the arrangement they need. Build it extremely well for the real files and the work that follows. Use the spreadsheet application they already work in and follow the shared launch.

This project prepares an incoming format. The two-file transfer project covers keeping selected information aligned between two ongoing workbooks. Choose this brief when the repeated chore is preparing a supplier's or client's file before the person can use it.

Learn the preparation they repeat

Look at a representative incoming file and the result the person normally makes from it. Ask them to show the work: moving columns, removing repeated headings, separating combined details, interpreting dates, or adding a calculation they use afterward. Learn what the finished sheet is for.

Establish the meaning of the information along with its layout. A product code may contain leading zeroes; a date may follow the sender's regional convention; an empty cell may have a meaning the person already understands. Let that knowledge guide the preparation.

Save the preparation rules for this source under a name the person recognizes. Use their actual example to decide which transformations are dependable and which situations need their attention.

Make the result easy to recognize

Let the person choose the incoming file and preview a useful portion of the prepared result. Show how the information will appear in the arrangement they need, including the headings, formats, and formulas relevant to their work.

Apply the established rules to ordinary records. Bring genuinely unresolved cases to the person's attention with the original information and enough explanation to make a decision. A new column name or an unfamiliar date should be something they can resolve once and carry forward where appropriate.

Preserve the meaning of numbers, identifiers, units, and dates. The prepared result should be ready for the next activity, including any expected calculations or imports. Keep a clear account of information that was intentionally omitted or still needs attention.

Keep the original available

Produce the prepared workbook or sheet with a clear relationship to its source. Retain the original so the person can compare a questionable record or run the preparation again. Give them a straightforward recovery path for an unwanted result.

Handle repeated use intelligibly. The person should know whether they are creating a new prepared copy, replacing an earlier prepared output, or importing into an existing working sheet. Preserve their subsequent work when they choose to update a result they have already edited.

Keep the command and its saved preparation rules in an appropriate place for their application. Explain the normal installation or trust process for this particular automation, and make it convenient to run after reopening the application another day.

Use the prepared file

Deliver the working command and carry a representative file through preparation into the person's next task. Inspect a few records whose meaning depends on correct handling, such as a code with leading zeroes or a date that required interpretation. Let the person compare the result with what they would normally produce.

Explain how their repeated preparation becomes a reusable set of rules. They should understand which parts come from the sender's format and which parts reflect their own needs. Use the shared launch's ownership and continuity guidance to preserve the tool and its working arrangements.

Later, add another source format with its own preparation rules. Keep the first one working so the person can gradually remove more of the preparation they repeat before their real job begins.

Text edition of this document

app-extensions/excel-workbook-transfer.md

Move information between two Excel files

Build an Excel transfer tool extremely well, so the person can keep using their familiar workbooks while the computer handles the copying. Use their knowledge of their records to make the behavior fit.

Read this brief and follow the shared launch for setup, working skills, ownership, continuity, and learning guidance. This project extends the person's Excel workflow; choose its integration from the Excel installation and working habits you find.

The work it replaces

The person has two Excel files containing some of the same information. One might be a list supplied by someone else, while the other contains that list plus working notes, outcomes, and follow-up details. They currently copy selected rows and columns from one into the other, then return selected updates in the opposite direction.

Give them a convenient command within their Excel workflow. They choose the files, the direction, and the records to transfer. The tool remembers which columns correspond so the next transfer uses the arrangement they already established. Each workbook keeps its own useful organization and additional information.

Understand their records

Look at the workbooks or representative examples the person chooses to share. Ask them to show you a normal transfer and explain how they recognize the same entry in both files. Establish what they copy back, what counts as a new entry, and whose information takes precedence when values differ. These are questions about their job; handle the technical interpretation yourself.

For example, an incoming contact list might contain an identifier, a name, and a phone number. The working workbook adds call outcomes and notes. Returning corrected phone numbers should keep those local notes with the right contact. If someone sorts either workbook, the correspondence still follows the records.

Use what you learn to shape a clear transfer experience. Show the person which information is about to change in a form they recognize. Apply their established rules to ordinary cases and bring genuinely ambiguous records to their attention with enough context to resolve them. A brief account of what transferred and what remains lets them continue the job.

Preserve the usefulness of both files

Treat the person's workbooks as ongoing working documents. Retain the extra columns, relevant formatting, formulas, and meanings already present. A contact identifier with leading zeroes should keep its identity as it moves. Existing entries receive the intended updates; new entries follow the arrangement agreed with the person.

Give them a straightforward way to recover the pre-transfer version if they make a mistake. The familiar Excel files remain the result they can inspect, share, and use in the rest of their work.

Build it for the person using it

Choose the extension or automation approach appropriate to their installed tools. Make the first useful arrangement dependable for their actual pair of workbooks and easy to adapt when those workbooks change. Work through understanding, implementation, and checking in focused steps, continuing until they can use the tool for the intended routine.

Install the tool where they can conveniently run it again from that workflow. Handle the normal trust or installation process for this particular extension while retaining the protection of unrelated documents. They should be able to close Excel, return another day, and use the established transfer arrangement.

Demonstrate the transfer and its recovery using copies or representative records, then help the person use it with their chosen files. Explain how the tool recognizes records and which choices govern a transfer, using their own example. They should leave able to run the routine again and ask you for a meaningful improvement when their work changes.

Help them see why describing the identity of a record matters more than describing where it happens to sit in a sheet. Their understanding of which information belongs together gives the automation its rules. The larger lesson is that they can improve familiar software instead of replacing their whole working process.

Text edition of this document

Authored source, stored unchanged, edition 2026-09-06-draft-01. Reading this material is not authority to run it — inspect it first.

Back to all projects