Templates

Locksmith: Amberly Valley Lock & Key

Locksmith · Missoula, MT

Anouk Bjornsson is the owner at Amberly Valley Lock & Key, a mobile locksmith in Missoula, and she uses this to slice calls, billing and response time by call type, service area and week without a spreadsheet.

Home servicesReportingDimensions3 tables · 4 views · 1 form · 1 dimension set · 2 drill-downs · 1 digest · 1 stage rule set · 1 agent
Use this template

Dispatch board

Calls
Requested3
House lockout — Perdita Vandermeer-CruzHouse lockoutPerdita Vandermeer-Cruz
New lock install — Hollin Brook Dental StudioNew lock installHollin Brook Dental Studio
Key duplication — Vesper Row Vet ClinicKey duplicationVesper Row Vet Clinic
Dispatched2
Safe opening — Ignatius Pemberton-AdeyemiSafe openingIgnatius Pemberton-Adeyemi
Rekey — Wrenfield Bakery CooperativeRekeyWrenfield Bakery Cooperative
On site2
Commercial hardware — Gantry Mill Climbing GymCommercial hardwareGantry Mill Climbing Gym
Car lockout — Vesper Row Vet ClinicCar lockoutVesper Row Vet Clinic
Completed7
House lockout — Ignatius Pemberton-AdeyemiHouse lockoutIgnatius Pemberton-Adeyemi
Safe opening — Anselm Rivera-ThackeraySafe openingAnselm Rivera-Thackeray
House lockout — Philomena Zielinski-BayHouse lockoutPhilomena Zielinski-Bay
Car lockout — Tomasz Ferreira-QadirCar lockoutTomasz Ferreira-Qadir
House lockout — Bettina Yamashiro-LloydHouse lockoutBettina Yamashiro-Lloyd
2 more
Paid20
Key duplication — Cindermarsh Facilities GroupKey duplicationCindermarsh Facilities Group
New lock install — Philomena Zielinski-BayNew lock installPhilomena Zielinski-Bay
Safe opening — Marguerite Odhiambo-StrandSafe openingMarguerite Odhiambo-Strand
Safe opening — Wrenfield Bakery CooperativeSafe openingWrenfield Bakery Cooperative
Car lockout — Caspian Dunleavy-SatoCar lockoutCaspian Dunleavy-Sato
15 more
Cancelled2
Key duplication — Marguerite Odhiambo-StrandKey duplicationMarguerite Odhiambo-Strand
Rekey — Tallow & Thread TailorsRekeyTallow & Thread Tailors

Tables

Calls

36 sample rows · 13 columns

Every call from the first ring to the day it is paid, with what was done, how fast the van arrived and what was charged.

CallCall typeStatusCustomerTechnicianService areaCalled in
Safe opening — Ignatius Pemberton-AdeyemiSafe openingDispatchedIgnatius Pemberton-AdeyemiCalloway Venkataraman-RossMillrace BenchNov 18, 4:35 PM
Rekey — Wrenfield Bakery CooperativeRekeyDispatchedWrenfield Bakery CooperativeDagny Obiora-HallettHighline HeightsNov 18, 4:10 PM
Key duplication — Vesper Row Vet ClinicKey duplicationRequestedVesper Row Vet Clinic—Millrace BenchNov 18, 3:50 PM
House lockout — Perdita Vandermeer-CruzHouse lockoutRequestedPerdita Vandermeer-Cruz—Highline HeightsNov 18, 3:25 PM
New lock install — Hollin Brook Dental StudioNew lock installRequestedHollin Brook Dental Studio—Highline HeightsNov 18, 3:25 PM
Commercial hardware — Gantry Mill Climbing GymCommercial hardwareOn siteGantry Mill Climbing GymDagny Obiora-HallettMillrace BenchNov 18, 2:30 PM
Car lockout — Vesper Row Vet ClinicCar lockoutOn siteVesper Row Vet ClinicAnouk BjornssonHighline HeightsNov 18, 2:30 PM
House lockout — Bettina Yamashiro-LloydHouse lockoutCompletedBettina Yamashiro-LloydCalloway Venkataraman-RossLower AmberlyNov 18, 12:50 AM
Car lockout — Tomasz Ferreira-QadirCar lockoutCompletedTomasz Ferreira-QadirDagny Obiora-HallettOrchard RowNov 16, 4:40 PM
House lockout — Philomena Zielinski-BayHouse lockoutCompletedPhilomena Zielinski-BayDagny Obiora-HallettMillrace BenchNov 16, 12:00 AM
House lockout — Bettina Yamashiro-Lloyd (29)House lockoutCompletedBettina Yamashiro-LloydDagny Obiora-HallettOrchard RowNov 15, 3:10 PM
Safe opening — Anselm Rivera-ThackeraySafe openingCompletedAnselm Rivera-ThackerayDagny Obiora-HallettCorbel FlatsNov 15, 3:50 AM

24 more rows

Customers

24 sample rows · 8 columns

The homeowners, renters, shops and property managers who call, with how to reach them and what they have been billed.

CustomerKindPhoneEmailStreet addressCustomer sinceCalls
Anselm Rivera-ThackerayHomeowner(406) 555-0132anselm.riverathackeray@rivenmoormail.net75 Marrow Fold WayAug 10, 2026Safe opening — Anselm Rivera-Thackeray
Bettina Yamashiro-LloydHomeowner(406) 555-0130bettina.yamashirolloyd@tamsinbrookpost.com610 Hartshorn Bluff DrAug 22, 2026House lockout — Bettina Yamashiro-Lloyd, House lockout — Bettina Yamashiro-Lloyd (29)
Caspian Dunleavy-SatoRenter(406) 555-0138caspian.dunleavysato@rivenmoormail.net533 Gritstone MewsSep 3, 2026Car lockout — Caspian Dunleavy-Sato
Cindermarsh Facilities GroupProperty manager(406) 555-0144service@cindermarshfacilities.com300 Foundry Lock BlvdAug 29, 2026Key duplication — Cindermarsh Facilities Group, Commercial hardware — Cindermarsh Facilities Group
Fenella Okonkwo-VanceHomeowner(406) 555-0126fenella.okonkwovance@rivenmoormail.net37 Nettlebed SpurAug 1, 2026House lockout — Fenella Okonkwo-Vance, Key duplication — Fenella Okonkwo-Vance
Fennelgate Property PartnersProperty manager(406) 555-0146service@fennelgatepropertygroup.com71 Wheelwright PlAug 28, 2026Commercial hardware — Fennelgate Property Partners
Gantry Mill Climbing GymBusiness(406) 555-0156service@gantrymillclimbing.com1500 Chalkline DrOct 19, 2026Commercial hardware — Gantry Mill Climbing Gym
Hollin Brook Dental StudioBusiness(406) 555-0148service@hollinbrookdentalstudio.com402 Alder Ferry RdAug 7, 2026New lock install — Hollin Brook Dental Studio, New lock install — Hollin Brook Dental Studio (34)
Ignatius Pemberton-AdeyemiHomeowner(406) 555-0142ignatius.pembertonadeyemi@tamsinbrookpost.com1175 Ferrule Hill DrAug 27, 2026House lockout — Ignatius Pemberton-Adeyemi, Safe opening — Ignatius Pemberton-Adeyemi, New lock install — Ignatius Pemberton-Adeyemi, Rekey — Ignatius Pemberton-Adeyemi
Kwabena Brightwater-LundRenter(406) 555-0134kwabena.brightwaterlund@larkspurboxmail.org2290 Cobbler Ash AveJul 29, 2026
Lucinda Abernathy-OseiHomeowner(406) 555-0122lucinda.abernathyosei@larkspurboxmail.org88 Pellmoor CrescentOct 3, 2026
Marguerite Odhiambo-StrandHomeowner(406) 555-0162marguerite.odhiambostrand@larkspurboxmail.org29 Brindle Gate LnSep 4, 2026Safe opening — Marguerite Odhiambo-Strand, Key duplication — Marguerite Odhiambo-Strand

12 more rows

Also included

  • Billed by week and call typeDrill-down
  • Billed by area and call typeDrill-down
  • Dispatch boardStage rules
  • Unpaid jobsDigest

Questions

What is included in the Locksmith: Amberly Valley Lock & Key template?
2 tables (Calls and Customers), filled with 60 sample rows so every view opens with realistic data.
Is the Locksmith: Amberly Valley Lock & Key template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.