Tygart Media

Author: will_tygart

  • Crawl Space HVAC: Why Equipment in the Crawl Space Benefits Most from Encapsulation

    Roughly 40% of U.S. homes with crawl spaces have their HVAC air handler and a significant portion of their ductwork located in the crawl space. This is common in both single-story ranch-style construction (where the only available mechanical space other than the attic is the crawl space) and in multi-story homes where first-floor distribution is most efficiently handled from below. When the HVAC system lives in the crawl space, the condition of that crawl space directly affects the system’s efficiency, reliability, and lifespan — and encapsulation provides benefits beyond moisture control that are directly measurable in energy bills and equipment replacement schedules.

    What Happens to HVAC in an Unencapsulated Crawl Space

    Duct Sweating and Condensation

    In summer, air conditioning systems supply cold air (typically 55–65°F) through ductwork. When this cold ductwork passes through a hot, humid crawl space (80°F, 80%+ RH), the duct exterior surface may fall below the dewpoint of the surrounding air — causing condensation on the duct exterior. Wet duct insulation loses R-value, allows mold growth on duct facing material, and if unchecked over years, causes the duct insulation to become saturated and slump, exposing bare metal that condenses even more aggressively.

    Duct sweating is particularly problematic in Southern states where summer dewpoints routinely exceed 70°F. A properly encapsulated crawl space that maintains 50–60°F in summer eliminates the temperature differential that causes duct sweating — the duct exterior no longer contacts air that is above the duct’s surface temperature.

    Air Handler and Coil Corrosion

    HVAC air handlers in vented crawl spaces are exposed to the crawl space’s humidity, soil gases, and mold spore load for the life of the equipment. The effects:

    • Evaporator coil corrosion: Copper coils in high-humidity environments corrode and develop pinholes that cause refrigerant leaks — the most expensive common HVAC failure. Equipment in crawl spaces averages refrigerant service calls more frequently than equipment in conditioned mechanical rooms.
    • Heat exchanger corrosion: In furnaces, the heat exchanger can corrode prematurely in high-humidity environments, creating a potential carbon monoxide hazard in addition to the performance degradation.
    • Electrical component degradation: Control boards, capacitors, and contactors in air handlers are rated for normal residential environments — not the sustained high humidity, mold spore load, and occasional moisture exposure of a wet crawl space.

    Duct Leakage and Energy Loss

    HVAC distribution systems lose energy through duct leakage — conditioned air escaping from the duct before it reaches the supply registers. In an unconditioned vented crawl space, this leakage:

    • Discharges conditioned air directly to the outdoor environment (through the vented crawl space) — 100% wasted
    • Creates negative pressure in the return system that draws in crawl space air (including mold spores, soil gases, and radon) through return duct leaks
    • Research from the Department of Energy’s Building America program found duct leakage to unconditioned spaces represents an average of 20–30% of HVAC output in homes with ductwork in vented crawl spaces or unconditioned attics

    Encapsulation converts the crawl space from an unconditioned space (where duct leakage is total loss) to a semi-conditioned space where leaked conditioned air still benefits the crawl space thermal environment. The effective energy loss from duct leakage is dramatically reduced even without sealing the ducts themselves.

    The Specific Energy Benefit When HVAC Is in the Crawl Space

    The Advanced Energy Corporation research that documented 15–18% HVAC energy savings from encapsulation was conducted in North Carolina homes where the HVAC equipment was primarily in the crawl space. This context is important: homes where HVAC is elsewhere (attic, interior closet, garage) will see smaller encapsulation energy benefits — primarily from reduced floor heat loss and reduced latent load from crawl space air infiltration, which are real but smaller impacts.

    When the air handler and ductwork are in the crawl space, encapsulation provides:

    • Duct leakage that no longer exits to the outdoors — partial recovery of what was previously 100% loss
    • Elimination of duct sweating — no more wet duct insulation and associated R-value degradation
    • Supply air temperature that is maintained closer to the design temperature because the duct is no longer losing heat through conduction to the hot crawl space air in summer
    • Return air that is no longer contaminated with crawl space air through return duct leaks

    Equipment Life Extension

    HVAC equipment manufacturers warranty their products for use in “normal residential environments” — not in wet, mold-laden crawl spaces. While hard data on differential equipment life by installation environment is limited, contractor experience consistently shows that air handlers in sealed, humidity-controlled crawl spaces operate longer between service calls and reach the end of their useful service life (typically 15–20 years) more often, compared to equipment in vented crawl spaces where 10–12 year lifespans are common due to corrosion and moisture-related failures.

    An HVAC system replacement costs $4,000–$12,000 for a typical single-family home. If encapsulation extends equipment life by even 3–5 years, the equipment life benefit alone approaches or exceeds the cost of the encapsulation — before counting energy savings.

    Frequently Asked Questions

    Is it bad to have HVAC in a crawl space?

    In a vented, unencapsulated crawl space: yes, it creates real problems — duct condensation, accelerated equipment corrosion, duct energy losses, and contaminated return air. In a sealed, conditioned crawl space: HVAC in the crawl space performs nearly as well as equipment in a conditioned mechanical room, and the encapsulation energy benefits are larger when HVAC is in the crawl space than when it is elsewhere.

    Why does my crawl space ductwork sweat?

    Duct sweating (condensation on the exterior of ductwork) occurs when the duct exterior surface is cooler than the dewpoint of the surrounding air. In summer, cold supply air (55–65°F) through ductwork in a hot, humid crawl space (80°F, 80%+ RH) creates this temperature differential. Encapsulation eliminates duct sweating by reducing crawl space temperature and humidity to levels where the duct exterior surface stays above the crawl space air’s dewpoint.

    How much energy does encapsulation save when HVAC is in the crawl space?

    Field research in North Carolina homes with HVAC in the crawl space documented 15–18% HVAC energy savings from encapsulation — the highest documented energy benefit in any crawl space research. Homes where HVAC is elsewhere see smaller energy benefits (5–10%) from encapsulation. The presence of HVAC equipment and ductwork in the crawl space is the single largest predictor of encapsulation energy savings.

  • Termites in Crawl Spaces: How to Identify Them and What Treatment Costs

    Termites cause more property damage annually in the United States than all natural disasters combined — approximately $5 billion per year — and crawl spaces are the primary point of entry for the subterranean termites responsible for the vast majority of this damage. Understanding how to identify termite activity in a crawl space, what treatment options exist, and how much they cost gives homeowners the information to act before structural damage becomes severe.

    Subterranean vs. Drywood Termites: What’s in Your Crawl Space

    Subterranean Termites

    Subterranean termites — Eastern subterranean (Reticulitermes flavipes, present throughout the eastern U.S.) and Formosan subterranean (Coptotermes formosanus, established in the Gulf Coast states and spreading) — are the overwhelming majority of crawl space termite infestations. They live in soil-based colonies that may contain hundreds of thousands to millions of workers, and they require continuous contact with moist soil to survive. They enter structures through:

    • Direct soil-to-wood contact — where structural wood touches or is close to the soil
    • Mud tubes — pencil-width earthen tunnels built from soil particles and termite saliva that maintain humidity as termites travel from soil to wood
    • Foundation cracks — particularly in block foundations where hollow cores create protected pathways
    • Expansion joints and utility penetrations in slab or footing

    Drywood Termites

    Drywood termites (Incisitermes and Cryptotermes species) infest wood directly — they do not require soil contact or high moisture. They are most prevalent in coastal California, Hawaii, Florida, and parts of the Gulf Coast. A drywood termite infestation in a crawl space presents differently: no mud tubes, no soil contact required, and the wood itself is the colony’s entire habitat. Drywood termite damage produces distinctive “pellet” frass — small, ridged, hexagonal pellets that accumulate below the infested wood. Drywood termite treatment typically involves tent fumigation of the entire structure rather than soil treatment.

    Identifying Termite Activity in Your Crawl Space

    Mud Tubes (Subterranean Termites)

    The most reliable indicator of subterranean termite activity. Look for:

    • Pencil-width earthen tubes on foundation walls, piers, sill plates, and the underside of subfloor
    • Tubes running vertically from the soil to wood surfaces, or horizontally across concrete or masonry surfaces
    • Active tubes feel slightly moist and may show worker termites inside if broken open
    • Abandoned tubes are dry and brittle — but abandoned tubes confirm past activity, warranting inspection for current activity elsewhere

    Damaged Wood

    Termite-damaged wood:

    • Sounds hollow when tapped — a solid rapping sound changes to a hollow thud where galleries have been excavated
    • Shows “honeycomb” pattern of galleries when broken or cut — soil-packed tunnels running with the wood grain
    • May appear intact on the exterior surface while being completely hollowed internally — probe test with an awl reveals how much solid wood remains
    • Distinct from wood rot: termite galleries follow the grain and contain soil particles; wood rot breaks across the grain in cubes (brown rot) or leaves stringy fibrous residue (white rot)

    Swarmers and Wings

    Reproductive termites (alates) swarm during specific seasons — spring for most Eastern subterranean species, January–May for Formosan. Swarmers near foundation vents, window wells, or crawl space access points indicate a mature colony nearby. Piles of shed wings (swarmers drop their wings after mating) near these areas confirm recent swarming. Termite wings are equal-length and roughly twice the body length — distinguishing them from carpenter ant swarmers whose wings are unequal.

    Treatment Options and Costs

    Liquid Termiticide Barrier

    A continuous liquid chemical barrier applied to the soil around and beneath the foundation — the most common treatment for subterranean termites. Termiticides approved for this use include non-repellent chemicals (Termidor/fipronil, Altriset/chlorantraniliprole) that are transferred between termites through grooming and trophallaxis, killing the entire colony over weeks, and repellent chemicals that create a barrier termites avoid.

    Cost: $800–$2,500 for an average single-family home, depending on linear footage of foundation perimeter, soil conditions (drilling through concrete may be required), and the product used. Non-repellent termiticides (Termidor) cost more but produce more reliable colony elimination. Annual re-treatment may be required for some products; others provide multi-year protection.

    Bait Stations

    Termite bait systems (Sentricon, Advance Termite Bait System) use monitoring stations installed in the soil around the foundation perimeter. Stations are checked periodically; when termite activity is detected at a station, a toxic bait is installed that workers take back to the colony. Colony elimination typically takes 3–6 months.

    Cost: $1,200–$3,500 for initial installation plus $300–$600/year for ongoing monitoring and bait replacement. Bait systems are particularly appropriate for: homes where liquid treatment would be difficult (finished basement, concrete slab that cannot be drilled, environmentally sensitive areas); homes requiring ongoing monitoring; and situations where colony elimination rather than barrier creation is the priority.

    Direct Wood Treatment

    Borate treatments (Tim-bor, Boracare) applied directly to structural wood kill termites and other wood-destroying insects that contact the treated wood. Used as a supplemental treatment to soil termiticide or bait systems, or as a primary preventive treatment for new construction before encapsulation. Cost: $500–$1,500 for crawl space wood treatment, depending on accessible surface area.

    The Moisture-Termite Connection

    Subterranean termite colonies require sustained soil moisture for survival and colony maintenance — desiccation is lethal to worker termites. A crawl space with bare soil and 80%+ relative humidity creates ideal conditions. Crawl space encapsulation — specifically reducing soil surface moisture and crawl space relative humidity — creates conditions that are less hospitable for termite colony maintenance. This is a real benefit, though not a substitute for professional treatment. The correct approach in termite-pressure areas: treat first, encapsulate second, and maintain annual inspections thereafter.

    Frequently Asked Questions

    How do I know if I have termites in my crawl space?

    Look for mud tubes — pencil-width earthen tunnels on foundation walls, piers, or the underside of the subfloor. Tap structural wood members — hollow-sounding areas indicate galleries. Look for piles of shed wings near foundation vents or access points, indicating recent swarming. Any of these signs warrants immediate professional pest control inspection.

    How much does termite treatment for a crawl space cost?

    Liquid termiticide barrier treatment: $800–$2,500 for an average home. Termite bait system installation: $1,200–$3,500 plus $300–$600/year for monitoring. Direct wood treatment as supplement: $500–$1,500. Structural damage repair from termite destruction ranges from minor sistering ($1,000–$3,000) to extensive reconstruction ($10,000+) depending on how long the infestation went undetected.

    Will crawl space encapsulation prevent termites?

    Encapsulation reduces the moisture conditions that support termite colony maintenance — making the crawl space less hospitable — but does not prevent termite entry or eliminate existing colonies. Professional termite treatment is required for both prevention and elimination. Encapsulation after professional treatment creates the least favorable long-term conditions for termite reestablishment.

  • Claude Code: The Complete Beginner’s Guide for 2026

    Claude Code is the fastest-growing AI coding tool in the developer community. The r/ClaudeCode subreddit has 4,200+ weekly contributors — roughly 3x larger than r/Codex. Anthropic reports $2.5B+ in annualized revenue attributable to Claude Code adoption. This complete guide takes you from installation to your first productive agentic coding session.

    What Is Claude Code?

    Claude Code is a terminal-native AI coding tool from Anthropic. Unlike IDE plugins that assist line-by-line, Claude Code operates at the project level — it reads your entire codebase, understands the architecture, writes and edits multiple files in a single session, runs tests, and works through complex engineering tasks autonomously. It uses Claude models with a 1-million-token context window — large enough to hold an entire codebase in memory.

    Installation

    Requirements: Node.js 18+, a Claude Max subscription ($100+/month) or Anthropic API key.

    # Install globally
npm install -g @anthropic-ai/claude-code

# Navigate to your project
cd your-project

# Authenticate
claude login

# Start a session
claude

    Setting Up CLAUDE.md (The Most Important Step)

    CLAUDE.md is a file you create in your project root that Claude Code reads at the start of every session. It’s the most important setup step — it gives Claude the context it needs to work effectively in your specific codebase without you re-explaining everything every time.

    A good CLAUDE.md includes:

    # Project: [Your Project Name]

## Architecture
[Brief description of how the codebase is organized]

## Tech Stack
- Language: [Python 3.11 / Node.js 20 / etc.]
- Framework: [Django / Next.js / etc.]
- Database: [PostgreSQL / MongoDB / etc.]
- Testing: [pytest / Jest / etc.]

## Coding Standards
- [Style guide, naming conventions, etc.]
- [Preferred patterns for this codebase]

## Common Tasks
- Run tests: `[command]`
- Start dev server: `[command]`
- Lint: `[command]`

## Known Issues / Context
- [Anything Claude should know before working]

    Key Slash Commands

    Command What It Does
    /init Scans your codebase and generates an initial CLAUDE.md
    /memory View and edit Claude’s memory for this project
    /compact Compact the conversation to free up context space
    /batch Run multiple commands or edits in one operation
    /clear Clear conversation history (start fresh)

    Your First Agentic Session

    Start Claude Code in your project directory and try:

    • “Explain the overall architecture of this codebase” — Claude reads and summarizes
    • “Add input validation to the user registration endpoint” — Claude finds the right file, writes the validation, updates tests
    • “There’s a bug where [describe issue] — find it and fix it” — Claude searches the codebase, identifies the cause, fixes it
    • “Write tests for [module or function]” — Claude reads the code and writes comprehensive tests

    Rate Limits and Token Management

    Claude Code on Max 5x gets approximately 44,000-220,000 tokens per 5-hour window. Long sessions with large codebases consume tokens quickly. Best practices:

    • Use /compact when sessions get long to free up context
    • Be specific in your requests — “fix the authentication bug in auth.py” uses fewer tokens than “look through all my files for problems”
    • Auto-compaction (beta) handles this automatically when enabled

    Frequently Asked Questions

    What subscription do I need for Claude Code?

    Claude Max at $100/month minimum. Claude Code can also be accessed via API billing — often more cost-effective for lower-volume use.

    Can Claude Code edit multiple files at once?

    Yes. Claude Code can read, edit, and create multiple files in a single session — and runs the edits atomically, so you can review and accept or reject changes.

    How do I install Claude Code on Windows?

    Claude Code requires Node.js 18+ and runs via WSL (Windows Subsystem for Linux) on Windows. Install WSL, then follow the standard npm installation steps within your WSL terminal.


    Need this set up for your team?
    Talk to Will →

  • Claude vs Amazon Q: Which AI Coding Assistant for AWS Developers?

    For AWS developers, Claude and Amazon Q represent two distinct approaches to AI-assisted development. Amazon Q is deeply integrated into the AWS ecosystem — built to understand your AWS environment, your IAM policies, your CloudFormation stacks, and your AWS-specific workflows. Claude is a more capable general-purpose AI that can handle complex reasoning and code but requires you to provide AWS context manually. This comparison helps you choose — and explains why many AWS developers use both.

    What Amazon Q Does Well

    • AWS-native context: Q can read your actual AWS account state — running resources, IAM permissions, CloudWatch logs — without you describing them
    • AWS documentation: Q is trained specifically on AWS documentation and gives more accurate, up-to-date answers for AWS-specific questions
    • Console integration: Q is embedded in the AWS Console, CloudShell, and VS Code via the AWS Toolkit — zero additional setup for AWS users
    • Troubleshooting: Q can analyze your actual CloudWatch errors and IAM policy conflicts directly
    • Cost optimization: Q analyzes your actual usage data for cost recommendations

    What Claude Does Better

    • Code quality: Claude Opus 4.6 scores 80.8% on SWE-bench vs Amazon Q’s lower published benchmarks — for complex, multi-file code generation, Claude produces better results
    • General reasoning: Architecture decisions, trade-off analysis, and complex problem-solving — Claude reasons more deeply
    • Non-AWS work: If you’re building multi-cloud or have significant non-AWS code, Claude handles everything equally; Q is heavily AWS-optimized
    • Document analysis: Claude’s 200K context window for reading technical specs, RFCs, or lengthy docs far exceeds Q’s capabilities
    • Writing: Technical blog posts, documentation, runbooks — Claude writes better

    Pricing Comparison

    Claude Amazon Q
    Individual $20-200/month $19/month (Q Developer Pro)
    Free tier Yes (limited) Yes (Q Developer Free)
    Business Custom $19/user/month

    Amazon Q Developer Pro at $19/month is competitive with Claude Pro at $20/month. For AWS-heavy developers, Q Pro includes features with no Claude equivalent (direct AWS account analysis). For general development, Claude holds the performance edge per dollar.

    The Combined Workflow

    Many AWS developers use Amazon Q for AWS-specific questions (CloudFormation troubleshooting, IAM policy analysis, service limits) and Claude Code for complex coding tasks (architecture, large refactors, code review). The tools are complementary rather than competing.

    Frequently Asked Questions

    Is Amazon Q better than Claude for AWS development?

    For AWS-native questions with real account context: Amazon Q wins. For complex code generation, architecture decisions, and general programming: Claude is stronger. Many AWS developers use both.

    Can Claude access my AWS account?

    Not directly. You can paste CloudFormation templates, error logs, or resource configurations into Claude for analysis. Amazon Q connects directly to your AWS account with appropriate permissions.


    Need this set up for your team?
    Talk to Will →

  • Is Claude AI Safe? Security, Ethics, and Trustworthiness Assessed

    Safety means different things depending on who’s asking. For a parent wondering if Claude is appropriate for their teenager: yes, with caveats. For an enterprise considering Claude for sensitive workflows: that requires a more detailed answer. For a researcher wondering about AI existential risk: that’s a different conversation entirely. This guide covers all three dimensions of Claude safety in 2026.

    Content Safety: What Claude Will and Won’t Do

    Claude’s content policies are enforced through Constitutional AI training, not just a filter layer bolted on afterward. This makes them more robust than keyword blocklists. Claude will decline to:

    • Generate content facilitating violence or illegal activities
    • Produce sexual content involving minors (zero tolerance, no exceptions)
    • Provide detailed instructions for creating weapons capable of mass casualties
    • Generate content designed to facilitate harassment or stalking of specific individuals

    Claude’s refusals are imperfect — it occasionally refuses legitimate requests and occasionally allows borderline ones. But the overall calibration has improved substantially with each model generation.

    Data Security

    Anthropic is a US-incorporated company subject to US law. Conversation data is stored on Anthropic’s infrastructure. Consumer accounts may be used for model training (opt-out available). Enterprise and API accounts have zero-data-retention options. Anthropic has published a privacy policy at privacy.claude.com and does not sell conversation data to third parties or advertisers.

    Anthropic’s Responsible Scaling Policy

    Anthropic has published a Responsible Scaling Policy (RSP) — a commitment to evaluate Claude models against specific safety thresholds before deployment. The RSP creates public accountability: if future Claude models show dangerous capability thresholds in evaluation, Anthropic has committed to not deploying them until additional safety measures are in place. This is a meaningful governance commitment uncommon among AI companies.

    Fake Claude Scams: What Every User Should Know

    Malwarebytes and other security researchers have documented phishing campaigns using fake “Claude AI” websites to steal credentials and install malware. Key indicators of legitimate Claude access:

    • The official Claude interface is at claude.ai — any other domain claiming to be Claude is not
    • Anthropic does not offer Claude through third-party websites requiring separate account creation
    • Claude’s API is accessed at api.anthropic.com
    • If you’re ever unsure, go directly to anthropic.com and navigate from there

    Frequently Asked Questions

    Is Claude safe for kids?

    Claude has content filters that prevent most inappropriate content, but it’s not specifically designed as a children’s product. Parental supervision is recommended for younger users. Claude doesn’t have age verification on the free tier.

    Can Claude be jailbroken?

    Attempts to manipulate Claude into ignoring its safety training exist. Anthropic actively works to patch these. Claude is more robust against jailbreaking than most models, but no AI system is perfectly immune to sophisticated manipulation attempts.


    Need this set up for your team?
    Talk to Will →

  • Claude Zapier Automation: 10 Workflows That Save Hours Every Week

    Claude and Zapier together create one of the most flexible automation combinations available in 2026. Through Zapier’s MCP server (mcp.zapier.com), Claude can connect to over 8,000 apps — sending emails, updating CRMs, creating tasks, posting to Slack, and more. This guide covers 10 practical workflows and how to set them up.

    Setting Up Claude + Zapier MCP

    Add Zapier’s MCP server to Claude Desktop by editing your configuration file:

    {
  "mcpServers": {
    "zapier": {
      "url": "https://mcp.zapier.com/api/mcp/a/YOUR_ACCOUNT_ID/mcp",
      "type": "url"
    }
  }
}

    Find your Zapier MCP URL in your Zapier account under Settings → MCP. Once connected, Claude can trigger any Zap you’ve built in Zapier, ask it to take actions across your connected apps.

    10 High-Value Automation Workflows

    1. Email Triage and Draft Generation

    New email arrives → Zapier sends to Claude → Claude categorizes (urgent/action needed/FYI/spam) and drafts a reply → Draft saved to Gmail or sent to you via Slack for approval.

    2. CRM Note Generation from Calls

    Call recording transcript arrives (from Otter.ai or Fireflies) → Claude generates structured CRM notes (summary, pain points, next steps, deal stage) → Notes automatically posted to Salesforce or HubSpot record.

    3. Social Media Content from Blog Posts

    New WordPress post published → Claude generates LinkedIn post, Twitter/X thread, and Instagram caption → Drafts sent to Buffer or Hootsuite for scheduled publishing.

    4. Meeting Summary and Action Item Distribution

    Meeting transcript uploaded → Claude extracts summary, decisions made, and action items with owners → Summary sent to meeting participants via email, action items created in Asana or Notion.

    5. Customer Support Ticket Drafts

    New support ticket received (Zendesk, Freshdesk) → Claude categorizes the issue and drafts a response → Draft queued for agent review before sending.

    6. Lead Research and Enrichment

    New lead added to CRM → Claude researches company context from provided information → Enriched notes (industry, company size, likely pain points) added to CRM record automatically.

    7. Contract Summary on Receipt

    PDF contract received via email → Claude generates key terms summary (parties, obligations, deadlines, payment terms) → Summary posted to Slack or added to Notion database.

    8. Weekly Report Generation

    Every Friday → Zapier pulls data from your project management tool → Claude generates weekly progress narrative → Report emailed to stakeholders automatically.

    9. Review Response Drafting

    New Google or Yelp review received → Claude drafts a personalized response matching your brand voice → Draft sent to you for approval via email or Slack.

    10. Job Application Screening Summaries

    New application received → Claude summarizes candidate background, flags matches to job requirements, notes potential concerns → Summary added to your ATS or hiring Notion board.

    Frequently Asked Questions

    Do I need Zapier paid plan to use Claude MCP?

    Zapier MCP access requires a paid Zapier plan. Check Zapier’s current pricing for MCP feature availability.

    Can Claude take actions in Zapier automatically without human approval?

    Yes — but for actions like sending emails or creating CRM records, building in a human-approval step (Slack notification with approve/reject) is recommended until you trust the automation’s output quality.


    Need this set up for your team?
    Talk to Will →

  • Claude AI for Excel and Spreadsheets: Formulas, Analysis, and Automation

    Spreadsheet work is one of the highest-leverage applications for Claude AI — and one where the time savings are immediately measurable. Claude writes complex formulas, explains your data, debugs broken functions, and helps design spreadsheet structures for any use case. This guide covers the specific workflows where Claude saves the most time.

    1. Formula Writing

    Describe what you want in plain English and Claude writes the formula:

    “Write an Excel formula that looks up a value in column A, finds the matching row in a separate table on Sheet2, and returns the value from column C of that row. Handle the case where no match is found by returning ‘Not Found’.”

    Claude returns the exact formula with an explanation of how it works — and will modify it if your structure is different from what it assumed.

    2. Formula Debugging

    Paste a broken formula and describe what it should do:

    “This formula is returning #VALUE! instead of the expected sum: =SUMIF(A:A,”Q1″,B:B). My date column (A) has dates in MM/DD/YYYY format. What’s wrong and how do I fix it?”

    3. Data Analysis and Interpretation

    Paste CSV data directly into Claude (up to tens of thousands of rows depending on token limits) and ask:

    • “What are the top 5 trends in this sales data?”
    • “Identify any outliers in this dataset and explain what might be causing them”
    • “Calculate month-over-month growth rates from these monthly totals”
    • “What’s the correlation between [column A] and [column B]?”

    4. Spreadsheet Design

    Before building a complex spreadsheet, describe your use case to Claude:

    “I need a spreadsheet to track client projects. Each project has: client name, project type, start date, deadline, status, hours budgeted, hours logged, and assigned team member. I want a dashboard tab that shows overdue projects and hours variance. Design the sheet structure and formulas I’ll need.”

    5. Claude’s Excel Add-In

    Anthropic launched a Claude Excel add-in that embeds Claude directly in Microsoft Excel. This allows you to interact with Claude in a side panel while working in your spreadsheet — selecting data ranges, asking questions about your data, and getting formula suggestions without switching applications.

    Frequently Asked Questions

    Can Claude write Google Sheets formulas as well as Excel?

    Yes. Claude writes formulas for both Excel and Google Sheets. Most formulas are identical or very similar between the two — just specify which you’re using if there might be syntax differences.

    Can Claude analyze data I paste into the conversation?

    Yes. Paste CSV data directly and Claude will analyze it. For very large datasets, paste a representative sample or aggregate summary.


    Need this set up for your team?
    Talk to Will →

  • Claude AI for Startups: Pitch Decks, Product Dev, and Hiring

    Startups operate at a pace that makes every AI productivity gain multiply. Claude AI has become one of the most useful tools for founders who need to write, think, research, and build simultaneously — often without the headcount to specialize any of it. This guide covers the highest-leverage startup use cases.

    1. Pitch Deck Writing and Refinement

    Claude can’t design slides, but it can write the content that makes them work:

    • Problem slide narrative (crisp, investor-compelling)
    • Solution positioning and differentiation language
    • Market size calculation narrative (TAM/SAM/SOM explanations)
    • Business model clarity
    • Traction slide copy from your metrics
    • Team bios that emphasize relevant experience
    • Ask and use of funds language

    Prompt: “I’m raising a [stage] round for [company]. We [what you do] for [who]. Our differentiation is [X]. Write the problem and solution slides in [Y] words each — investor audience, direct and specific, no jargon.”

    2. Product Requirements and Spec Writing

    Early-stage founders often write PRDs themselves. Claude drafts them faster:

    • User story generation from feature descriptions
    • MVP scope definition and prioritization
    • Technical spec outlines for engineering handoffs
    • API documentation first drafts

    3. Competitive Analysis

    Paste competitor landing pages, pricing pages, or product releases into Claude and ask: “Analyze this competitor’s positioning. What are their claimed strengths, their apparent weaknesses, and the gap my product could own?” Do this across 5 competitors in one session and you have a competitive landscape in an hour that would take a day manually.

    4. Hiring: JDs, Outreach, and Interviews

    • Job description writing that attracts the right candidate profile
    • LinkedIn outreach messages for sourcing
    • Interview question sets by role
    • Offer letter language (review with legal counsel)
    • Culture doc and values articulation

    5. Investor Research

    Paste an investor’s portfolio page, blog posts, or thesis into Claude: “Based on this investor’s portfolio and stated thesis, how should I position my company for a conversation with them? What aspects of our business align with their focus?”

    Frequently Asked Questions

    Can Claude help write a pitch deck?

    Yes — the narrative content. Claude writes compelling problem/solution/market/traction/team copy. Slide design requires dedicated tools (Canva, Pitch, PowerPoint).


    Want this for your workflow?

    We set Claude up for teams in your industry — end-to-end, fully configured, documented, and ready to use.

    Tygart Media has run Claude across 27+ client sites. We know what works and what wastes your time.

    See the implementation service →

    Need this set up for your team?
    Talk to Will →

  • Claude AI for Small Business: Operations, Marketing, and Customer Service

    Small business owners are among the professionals getting the most value from Claude AI — because they wear every hat and the time savings compound across every function. This guide covers the highest-leverage use cases: marketing, operations, customer service, and financial communication.

    Why Claude Works Well for Small Business

    Small businesses typically can’t afford specialists for every function. The owner writes the marketing copy, drafts the employee handbook, responds to reviews, and handles client emails — all in the same day. Claude handles the first draft of almost all of these, at a quality level that previously required hiring freelancers or agencies.

    1. Marketing Content

    • Website copy (homepage, about page, service descriptions)
    • Google Business Profile posts and updates
    • Email newsletter content
    • Social media captions (Instagram, Facebook, LinkedIn)
    • Local SEO blog posts
    • Seasonal promotions and campaign copy

    Prompt template: “Write a [content type] for my [business type] in [city]. My unique selling point is [differentiator]. Target customer: [describe]. Tone: [conversational/professional/enthusiastic]. Length: [X words].”

    2. Operations Documents

    • Standard operating procedures (SOPs) for any business process
    • Employee onboarding guides and training materials
    • Job descriptions for hiring
    • Vendor agreements and simple contracts (always review with attorney)
    • Process documentation and checklists

    3. Customer Service

    • Response templates for common questions
    • Difficult customer situation scripts
    • Online review responses (positive and negative)
    • FAQ page content
    • Refund and complaint handling language

    4. Financial Communication

    • Invoice and payment reminder language
    • Proposal and estimate narratives
    • Client update letters for project status
    • Grant application narratives (for eligible businesses)

    Recommended Starting Setup

    Create a Claude Project with a system prompt containing: your business name and type, your city and target market, your brand voice (3 adjectives), and 2-3 things that differentiate you. Once set up, every Claude conversation is pre-loaded with your business context — no re-explaining needed.

    The free tier works for occasional use. Claude Pro at $20/month is the right starting point for daily business use — Projects are included and the rate limits are workable for most small business owners.

    Frequently Asked Questions

    What is the best Claude plan for small business owners?

    Claude Pro at $20/month. Projects let you store your business context so every conversation is pre-loaded. The free tier works if you use Claude occasionally.


    Want this for your workflow?

    We set Claude up for teams in your industry — end-to-end, fully configured, documented, and ready to use.

    Tygart Media has run Claude across 27+ client sites. We know what works and what wastes your time.

    See the implementation service →

    Need this set up for your team?
    Talk to Will →

  • Claude AI for Students: Study Guides, Essays, and Research

    Claude AI is one of the most powerful learning tools available to students in 2026 — and one of the most misused. The difference between using Claude to learn faster and using it to circumvent learning is real and matters. This guide covers the legitimate, effective ways students use Claude, where the ethical line is, and how to actually get better at the things you’re studying.

    The Ethical Framework First

    The question isn’t “will I get caught” — it’s “am I actually learning?” Using Claude to understand a concept faster, check your reasoning, or get feedback on your writing builds capability. Using Claude to generate an essay you submit as your own work without engaging with it doesn’t — and violates academic integrity policies at virtually every institution. This guide covers the former.

    1. Concept Explanation and Tutoring

    Claude is an exceptional tutor for concepts you don’t understand. Unlike a textbook, you can ask it to explain the same thing ten different ways until one clicks.

    • “Explain the difference between correlation and causation using a sports example”
    • “Why does the mitochondria produce ATP — explain it like I’m 12”
    • “I understand that X is true but I don’t understand why. Can you walk me through the reasoning?”
    • “Quiz me on [topic] with increasingly hard questions and explain each answer”

    2. Research Assistance

    Claude helps structure research and synthesize sources — but cannot replace primary source research:

    • Upload research papers and ask Claude to explain key findings
    • Generate an outline of subtopics to research for a paper
    • Ask Claude to identify potential counterarguments to your thesis
    • Summarize academic sources you’ve found and pull out relevant passages

    Important: Claude cannot browse the internet or access current academic databases. For current research, use Google Scholar, JSTOR, or your institution’s library resources directly.

    3. Writing Feedback and Improvement

    This is ethically clear territory: use Claude as an editor, not a ghostwriter.

    • “Review this paragraph for clarity and logical flow. Don’t rewrite it — just tell me what’s weak.”
    • “Does my thesis statement clearly set up the argument in my essay? Here it is: [thesis]”
    • “What’s missing from this argument? [paste your argument]”
    • “Suggest 3 ways I could strengthen the conclusion without changing my core argument”

    4. Exam Preparation

    • Generate practice questions on any topic at any difficulty level
    • Explain wrong answers after you attempt practice problems
    • Create flashcard-style Q&A for memorization
    • Summarize a textbook chapter into key points for review

    Claude’s Learning Mode

    Claude has a Learning Mode feature that makes it more likely to ask you to reason through problems yourself before providing answers — reinforcing actual learning rather than answer-delivery. Enable it in settings when you want Claude to teach rather than just tell.

    Frequently Asked Questions

    Is using Claude for homework cheating?

    It depends on how you use it. Using Claude to understand concepts faster, get writing feedback, and check your reasoning is not cheating. Submitting Claude-generated work as your own without engaging with it is academic dishonesty.

    Can Claude write my essay for me?

    Claude can generate text on any topic. Whether submitting that text violates your institution’s policies is a separate question — and it almost certainly does. Use Claude for tutoring and feedback, not to replace your own writing.


    Need this set up for your team?
    Talk to Will →