AI Skill Report Card

Designing Pest Control Reports

B+78·Mar 23, 2026·Source: Web
12 / 15

Create a 3-format pest control report system with identical fields across fillable PDF, printable PDF, and Google Sheet/Form formats.

Python
# Sample field mapping structure sections = { "visit_details": ["company_name", "technician_name", "service_date", "arrival_time"], "scope": ["service_scope_checkboxes", "not_included_text", "prior_issues"], "observations": ["pest_types_observed", "activity_level", "areas_with_activity"], # ... continues for all 9 sections }
Recommendation
The skill is extremely verbose and could be cut by 60-70% - Claude doesn't need exhaustive field mappings spelled out

Page Size: 8.5" x 11" (Letter) Orientation: Portrait Font: Arial 9-10pt for labels, 8-9pt for form fields Form Fields: Optimized for mobile/tablet touch input

Visual Grouping Strategy:

  • Header Band: Company branding area (1" top margin)
  • Section Boxes: Each section in bordered box with gray header bar
  • Two-Column Layout: Where space allows
  • Checkbox Groups: 3-4 per row maximum
  • Text Fields: Minimum 0.25" height for mobile typing

Section Layout Details:

Section 1: Visit & Customer Details (Top 1/3 of page)

[Company Info - Left Column]     [Service Info - Right Column]
Company Name: _______________     Service Date: ___/___/_____
Phone: __________________        Arrival: _____ Departure: _____
Email: __________________        Service Type: □Initial □Routine □One-Time
License#: _______________         □Callback □Inspection Only

[Customer Info - Full Width]
Customer: _________________ Service Address: _________________________
Unit#: _______ City: _____________ State: ___ ZIP: _________
Phone: _________________ Email: _________________________________
Job#: _________ Route#: _______ Access: □Customer □Key □Mgmt □Other: ____

Section 2: Scope of Service (Box with warning-style header)

TODAY'S SERVICE SCOPE: □Crawling Insects □Rodents □Wasps □Termite Inspection
□Bed Bugs □Fleas/Ticks □Other: _________________________________

NOT INCLUDED TODAY: ________________________________________________

PRIOR ISSUES REPORTED: ____________________________________________

VISIBLE PREVIOUS TREATMENT/DAMAGE: ________________________________

Section 3: Pest Issues Observed

PESTS OBSERVED: □Ants □German Roaches □American Roaches □Spiders
□Mice □Rats □Wasps □Fleas □Bed Bugs □Termites □Other: ___________

ACTIVITY: ○Low ○Moderate ○Heavy

AREAS: □Kitchen □Bath □Bedrooms □Living □Garage □Basement □Attic
□Exterior □Yard □Other: _______________________________________

EVIDENCE: □Live □Dead □Droppings □Nests □Damage □Tracks □Entry Points
□Other: ___________________________________________________

FINDINGS: ____________________________________________________

Section 4: Treatment Performed (Prominent "No Treatment" checkbox)

TREATMENT AREAS: □NO TREATMENT PERFORMED (INSPECTION ONLY)
□Int-Kitchen □Int-Bath □Int-Bedrooms □Int-Living □Basement □Attic
□Garage □Ext-Foundation □Ext-Eaves □Yard □Other: _______________

METHODS: □Residual-Int □Residual-Ext □Crack/Crevice □Gel Bait
□Granular Bait □Rodent Blocks □Dust □Glue Boards □Traps
□Stations Serviced □Exclusion □Monitor Only □Other: ____________

EXCLUSION WORK: ____________________________________________

STATIONS/DEVICES: __________________________________________

Section 5: Products Used (Table format)

[THIS IS TABLE: 6 rows x 6 columns]
Product Name | Target Pest | Active Ingredient | EPA# | Area Applied | Amount Used
___________|____________|__________________|_____|______________|____________
___________|____________|__________________|_____|______________|____________
(4 more rows...)

Section 6: Contributing Conditions

SANITATION: □Food Out □Dirty Dishes □Unsealed Trash □Pet Food Accessible
CLUTTER: □Heavy Clutter □Storage Against Walls
MOISTURE: □Leaks □Standing Water □High Humidity
ENTRY POINTS: □Door/Window Gaps □Foundation Cracks □Utility Holes □Damaged Screens
BUILDING: □Shared Walls □Adjacent Infestation □Vegetation Contact
OTHER: ____________________________________________________

ACCESS LIMITATIONS: □Locked Areas □Customer Refused □Pets Not Secured
□Excessive Clutter □Safety Concerns □Other: ____________________
NOTES: ___________________________________________________

Section 7: Safety & Instructions

PREP STATUS: □Completed □Partial □Not Required
NOTES: ___________________________________________________

POST-TREATMENT INSTRUCTIONS: □Stay Out Until Dry □Keep Pets Away
□No Cleaning 24hrs □Don't Move Baits □Wash Food Surfaces □Other: ____

SDS ACCESS: □Provided Directly □Available Online at: ________________
□Customer Declined

Section 8: Follow-up Plan

FOLLOW-UP: □None Unless Issues □Visit in ___ days □Monthly □Bi-Monthly
□Quarterly □Other: ________________________________________

NEXT DATE: ___/___/_____

WARRANTY: ________________________________________________

EXPECTED RESULTS: ______________________________________

Section 9: Signatures & Photos (Bottom of page)

PHOTOS: □Yes - Taken □No Photos    REFERENCE: ________________

TECHNICIAN: _________________ SIGNATURE: _____________ DATE: ____
CUSTOMER: __________________ SIGNATURE: _____________ DATE: ____

OFFICE USE ONLY: ____________________________________________

Same sections and fields, optimized for clipboard use:

  • Larger checkboxes (0.15" square) for pen marking
  • More line spacing for handwritten entries
  • Simplified table borders for easy photocopying
  • Bold section headers with more white space
  • Pre-printed common entries with checkboxes (e.g., common pest names)

Key differences:

  • Remove form field functionality
  • Increase line heights by 25%
  • Add more "Other: ____" fields for flexibility
  • Include small print disclaimer at bottom

Sheet Name: "Pest_Control_Reports"

Column Headers (A-AZ, then AA-ZZ as needed):

A: Timestamp
B: Company_Name  
C: Company_Phone
D: Company_Email
E: Company_Address
F: Company_License
G: Technician_Name
H: Technician_ID
I: Service_Date
J: Arrival_Time
K: Departure_Time
L: Service_Type_Initial
M: Service_Type_Routine
N: Service_Type_OneTime
O: Service_Type_Callback
P: Service_Type_InspectionOnly
Q: Customer_Name
R: Service_Address
S: Unit_Apt
T: City
U: State
V: ZIP
W: Customer_Phone
X: Customer_Email
Y: Job_Invoice_Number
Z: Route_Stop_Number
AA: Access_Customer_Present
AB: Access_Key_Lockbox
AC: Access_Management
AD: Access_Other
AE: Access_Other_Details
AF: Scope_Crawling_Insects
AG: Scope_Rodents
AH: Scope_Wasps
AI: Scope_Termite_Inspection
AJ: Scope_Bed_Bugs
AK: Scope_Fleas_Ticks
AL: Scope_Other
AM: Scope_Other_Details
AN: Services_Not_Included
AO: Prior_Issues_Reported
AP: Previous_Treatment_Evidence
AQ: Pests_Ants
AR: Pests_German_Roaches
AS: Pests_American_Roaches
AT: Pests_Spiders
AU: Pests_Mice
AV: Pests_Rats
AW: Pests_Wasps_Bees
AX: Pests_Fleas_Ticks_Obs
AY: Pests_Bed_Bugs_Obs
AZ: Pests_Termites
BA: Pests_Other_Obs
BB: Pests_Other_Details
BC: Activity_Level
BD: Areas_Kitchen
BE: Areas_Bathrooms
BF: Areas_Bedrooms
BG: Areas_Living
BH: Areas_Garage
BI: Areas_Basement
BJ: Areas_Attic
BK: Areas_Exterior_Perimeter
BL: Areas_Yard
BM: Areas_Roof
BN: Areas_Other
BO: Areas_Other_Details
BP: Evidence_Live
BQ: Evidence_Dead
BR: Evidence_Droppings
BS: Evidence_Nests
BT: Evidence_Damage
BU: Evidence_Tracks
BV: Evidence_Entry_Points
BW: Evidence_Other
BX: Evidence_Other_Details
BY: Findings_Description
BZ: Treatment_None_Performed
CA: Treatment_Int_Kitchen
CB: Treatment_Int_Bathrooms
CC: Treatment_Int_Bedrooms
CD: Treatment_Int_Living
CE: Treatment_Basement
CF: Treatment_Attic
CG: Treatment_Garage
CH: Treatment_Ext_Foundation
CI: Treatment_Ext_Eaves
CJ: Treatment_Yard
CK: Treatment_Other
CL: Treatment_Other_Details
CM: Methods_Residual_Interior
CN: Methods_Residual_Exterior
CO: Methods_Crack_Crevice
CP: Methods_Gel_Bait
CQ: Methods_Granular_Bait
CR: Methods_Rodent_Blocks
CS: Methods_Dust
CT: Methods_Glue_Boards
CU: Methods_Snap_Traps
CV: Methods_Stations_Serviced
CW: Methods_Exclusion
CX: Methods_Monitoring
CY: Methods_Other
CZ: Methods_Other_Details
DA: Exclusion_Repairs
DB: Devices_Stations_Serviced
DC: Product1_Name
DD: Product1_Purpose
DE: Product1_Active_Ingredient
DF: Product1_EPA_Number
DG: Product1_Application_Area
DH: Product1_Amount_Used
DI: Product2_Name
DJ: Product2_Purpose
DK: Product2_Active_Ingredient
DL: Product2_EPA_Number
DM: Product2_Application_Area
DN: Product2_Amount_Used
[Continue pattern for Products 3-6...]
EA: Condition_Food_Out
EB: Condition_Dirty_Dishes
EC: Condition_Unsealed_Trash
ED: Condition_Pet_Food
EE: Condition_Heavy_Clutter
EF: Condition_Storage_Against_Walls
EG: Condition_Leaks
EH: Condition_Standing_Water
EI: Condition_High_Humidity
EJ: Condition_Door_Window_Gaps
EK: Condition_Foundation_Cracks
EL: Condition_Utility_Holes
EM: Condition_Damaged_Screens
EN: Condition_Shared_Walls
EO: Condition_Adjacent_Infestation
EP: Condition_Vegetation_Contact
EQ: Condition_Other_Observations
ER: Access_Limitations_Locked
ES: Access_Limitations_Refused
ET: Access_Limitations_Pets
EU: Access_Limitations_Clutter
EV: Access_Limitations_Safety
EW: Access_Limitations_Other
EX: Access_Limitations_Details
EY: Prep_Completed
EZ: Prep_Partial
FA: Prep_Not_Required
FB: Prep_Notes
FC: Instructions_Stay_Out
FD: Instructions_Keep_Pets_Away
FE: Instructions_No_Cleaning
FF: Instructions_Dont_Move_Baits
FG: Instructions_Wash_Surfaces
FH: Instructions_Other
FI: Instructions_Other_Details
FJ: SDS_Provided_Direct
FK: SDS_Available_Online
FL: SDS_Online_URL
FM: SDS_Customer_Declined
FN: Followup_None
FO: Followup_Visit_In_Days
FP: Followup_Days_Number
FQ: Followup_Monthly
FR: Followup_BiMonthly
FS: Followup_Quarterly
FT: Followup_Other
FU: Followup_Other_Details
FV: Next_Service_Date
FW: Warranty_Terms
FX: Expected_Results
FY: Technician_Name_Printed
FZ: Technician_Signature_Digital
GA: Technician_Date
GB: Customer_Name_Printed
GC: Customer_Signature_Status
GD: Customer_Date
GE: Photos_Taken
GF: Photos_None
GG: Photo_Reference
GH: Internal_Notes

Section 1: Visit & Customer Details

1. Company Name (Short answer)
2. Company Phone (Short answer)
3. Company Email (Short answer)  
4. Company Address (Short answer) [Optional]
5. Company License/Certification Number (Short answer)
6. Technician Name (Short answer)
7. Technician ID/License Number (Short answer)
8. Service Date (Date)
9. Arrival Time (Time)
10. Departure Time (Time)
11. Service Type (Multiple choice checkboxes):
    - Initial Service
    - Routine/Recurring  
    - One-Time
    - Callback/Warranty
    - Inspection Only
12. Customer Name (Short answer)
13. Service Address (Short answer)
14. Unit/Apt # (Short answer)
15. City (Short answer)
16. State (Short answer)
17. ZIP (Short answer)
18. Customer Phone (Short answer)
19. Customer Email (Short answer)
20. Job/Invoice # (Short answer)
21. Route/Stop # (Short answer) [Optional]
22. Access Method (Multiple choice checkboxes):
    - Customer Present
    - Key/Lockbox
    - Management Provided Access  
    - Other
23. If Other Access Method, specify: (Short answer)

Section 2: Scope of Today's Service

24. Scope of Today's Service (Multiple choice checkboxes):
    - General crawling insects
    - Rodents
    - Wasps/stinging insects
    - Termite/WDI inspection only
    - Bed bugs
    - Fleas/ticks
    - Other
25. If Other Service Scope, specify: (Short answer)
26. Services/Pests NOT Included in Today's Visit (Paragraph)
27. Prior Pest Issues Reported by Customer (Paragraph)
28. Visible Evidence of Previous Treatment or Damage (Paragraph)

Section 3: Pest Issues Observed

29. Pest Types Observed (Multiple choice checkboxes):
    - Ants
    - Roaches - German
    - Roaches - American/Other
    - Spiders
    - Rodents - Mice
    - Rodents - Rats
    - Wasps/Bees/Hornets
    - Fleas/Ticks
    - Bed Bugs
    - Termites/Wood-Destroying Insects
    - Other
30. If Other Pest Types, specify: (Short answer)
31. Activity Level (Multiple choice):
    - Low
    - Moderate
    - Heavy
32. Areas with Activity (Multiple choice checkboxes):
    - Kitchen
    - Bathrooms
    - Bedrooms
    - Living/Common Areas
    - Garage
    - Basement
    - Attic/Crawlspace
    - Exterior Perimeter
    - Yard/Outbuildings
    - Roof/Eaves
    - Other
33. If Other Areas, specify: (Short answer)
34. Evidence Noted (Multiple choice checkboxes):
    - Live Insects/Rodents
    - Dead Insects/Rodents
0
Grade B+AI Skill Framework
Scorecard
Criteria Breakdown
Quick Start
12/15
Workflow
13/15
Examples
15/20
Completeness
13/20
Format
15/15
Conciseness
10/15