Tight Ship
All tools

Hiring

Field Tech Hiring System Tracker

A hiring tracker in Excel for companies that hire field techs.

Every applicant in one place, from application to manager handoff. You type them in by hand.

$19.00

Buy now

Pay once. No subscription.

If a file won't open, won't work on your computer or Microsoft plan, or isn't what the page described, we fix it or refund you, your choice. Tell us within 14 days of your purchase.

Questions? Email support@tightshiphq.com

  • Works in Excel, not Google Sheets.

How you use it

  1. 5OPEN ROLES

    Sample data

    Applicants by open role

    HVAC Install Technician11
    Journeyman Electrician11
    Security Technician10
    HVAC Service Technician7
    Low-Voltage Installer4

    Step 1. List your open roles.

    The Open Roles tab with sample data: one row per job with trade, location, pay range, and hiring manager.

    See the real screen: Open Roles

  2. 14NEW THIS WEEK

    Sample data

    Where applicants come from

    Indeed31
    Referral8
    Company website2
    Walk-in2
    Other1

    Step 2. Add each applicant as they come in.

    The Applicants tab with sample data: one row per applicant. New applicants are shaded and overdue dates turn red.

    See the real screen: Applicants

  3. Gate Questions

    Sample data

    Five quick must-haves to check before you spend time on a call.

    • 1License / certHolds it, or the role accepts in-progress
    • 2Driver's licenseYes, if the role drives a company vehicle
    • 3ExperienceAt or above the role's minimum
    • 4Schedule fitYes
    • 5Work authorizationYes

    A person marks each oneMetNot metAsk on callN/A

    Step 3. Get their answers to your gate questions.

    Mark each one. The Gate Questions tab shows how.

    The Gate Questions tab: five must-have checks, what counts as Met, why each is job-related, how to get the answers.

    See the real screen: Gate Questions

  4. Pipeline by stage

    Sample data

    New8
    Gate check7
    Pre-screen7
    Manager interview5
    Offer2
    Hired3

    Step 4. Move people through the stages as you call and interview them.

    Stage tracking from new applicant to hire, with a next step for each person: pick one from a list of suggested steps or type your own.

    See the real screen: Stage tracking

  5. CANDIDATE SUMMARY FOR THE HIRING MANAGER

    Sample data

    Miguel Santos

    Journeyman Electrician · Hilliard, OH

    License / cert
    Met
    Driver's license
    Met
    Experience
    Met
    Schedule fit
    Met
    Work authorization
    Met

    Reply with one word, or tick one:

    AdvanceHoldPass

    Step 5. Send the one-page handoff to the hiring manager.

    It goes by email or text, and they reply with one word.

    The Manager Handoff tab with sample data: a one-page candidate summary with phone and email, gate checks, and a one-word manager decision line.

    See the real screen: Manager Handoff

Drawn from the sample data in the file. Each step links to the real screen. Made-up data only, in every file and every image.

What's included

  • Hiring tracker workbook with seven tabs: Start Here, Dashboard, Applicants, Open Roles, Gate Questions, Manager Handoff (one page), and Settings
  • A sample-data copy filled with fake applicants, so you can click around before adding real ones
  • A quick-start PDF

Before you buy

  • Works in Excel for Microsoft 365 (Windows, Mac, or web) or Excel 2021 or newer.
  • Does not work in Google Sheets, Apple Numbers, or Excel 2019 and older.
  • Delivered as one .zip file. Unzip it first, then open the workbook.
  • Digital download. Nothing is shipped.

A person makes every decision

This is an organizing tool, not legal advice. It doesn't score, rank, or reject anyone automatically. The gate questions are editable examples; check your state and local rules before you use them.

Questions

Does this work in Google Sheets?

No. It's built for Excel: Excel for Microsoft 365 (Windows, Mac, or web) or Excel 2021 or newer. It does not work in Google Sheets, Apple Numbers, or Excel 2019 and older.

Do I need Indeed?

No. The Tracker works with applicants from anywhere: job boards, referrals, walk-ins, or your website. You type them in.

Does the Tracker add applicants automatically?

No. You add applicants by hand, and the Tracker doesn't send anything to applicants. The Full Kit adds two ready-made Power Automate flows, with a setup guide, that turn each Indeed application email into a new row, send your gate questions, and save each reply on the applicant's row. The automation needs Microsoft 365 Business Basic, Standard, or Premium (see the Full Kit page).

How do I get answers to the gate questions?

The easiest way is to add them to your Indeed job post as screener questions, left optional so a person reads every answer: applicants answer while they apply, and you read the answers in Indeed. You can also reply to Indeed's application email with the questions. The Gate Questions tab shows both. Either way, you mark each gate yourself.

Does anything here screen candidates?

No, in either version. Nothing in this kit scores, ranks, or rejects anyone automatically. A person makes every screening decision.

Does it work on a Mac?

Yes, in Excel for Microsoft 365 for Mac or Excel 2021 or newer for Mac.

Are the gate questions legal advice?

No. They're editable examples that help you check the same must-haves for everyone. Check your state and local rules before you use any screening question.

Field Tech Hiring System Tracker

$19.00

Buy now

Pay once. No subscription.

Sample dataSettingsManager HandoffIN THEIR WORDSMiguel Santos1. Journeyman electrician (OH)2. Yes3. 8 years in electrical4. Yes, on-call is fine5. Yes

Related tool

Field Tech Hiring System Full Kit

The Field Tech Hiring System Full Kit includes this same tracker, plus two ready-made Power Automate flows to import and a step-by-step setup guide: each Indeed application email becomes a new row in your tracker within a few minutes, your gate questions go to the applicant by email, and their reply is saved on their row.

It also adds a gate question library for field roles, applicant email and text templates, a pre-screen call sheet, and a manager handoff form in Word.

The automation needs Microsoft 365 Business Basic, Standard, or Premium. It already includes the tracker, so you never need both.

See this tool$49.00