AI Matrx Logo

Pool construction

Marrowgate Row Pools & Spas · Pool construction · Tucson, AZ

Linnea Galbraith is the project manager at Marrowgate Row Pools & Spas, a custom pool builder in Tucson, and she keeps every crew member's schedule, certificates and onboarding in one place, with pay and emergency details shown only where they belong.

Construction and tradesTeam and HRGoverned columns4 tables · 6 views · 1 form · 3 dimension sets · 1 digest · 1 checklist · 1 notification · 1 agent
Use this template

Crew files

Crew files
Crew filePersonEmployee codeCrewEmploymentStatusOnboarding
Alaric Dlamini-Prescott, equipment installerAlaric Dlamini-PrescottMR-114EquipmentFull timeActiveCleared
Ambrose Kuznetsov-Mensah, apprenticeAmbrose Kuznetsov-MensahMR-120FieldApprenticeActivePaperwork
Bartholomew Nkrumah-Vale, pool plumberBartholomew Nkrumah-ValeMR-106PlumbingFull timeActiveCleared
Calliope Banerjee-Strand, apprenticeCalliope Banerjee-StrandMR-119FieldApprenticeActiveSite safety
Caspian Ngata-Delacroix, shotcrete nozzlemanCaspian Ngata-DelacroixMR-108ShotcreteFull timeActiveCleared
Dagobert Hollingsworth-Eze, site superintendentDagobert Hollingsworth-EzeMR-102FieldFull timeActiveCleared
Fenwick Takahashi-Brandt, tile setterFenwick Takahashi-BrandtMR-112FinishingFull timeActiveCleared
Gideon Pellerin-Ncube, service technicianGideon Pellerin-NcubeMR-116ServiceFull timeOn leaveCleared
Ignatius Valcourt-Sibanda, steel and rebar techIgnatius Valcourt-SibandaMR-110ShotcreteSeasonalSeasonalCleared
Imelda Faulkner-Ogunbanjo, pool plumberImelda Faulkner-OgunbanjoMR-107PlumbingFull timeActiveCleared
Leopold Tran-Whitcombe, office coordinatorLeopold Tran-WhitcombeMR-122OfficeFull timeActiveCleared
Linnea Galbraith, project managerLinnea GalbraithMR-101OfficeFull timeActiveCleared

10 more rows

Tables

Crew files

22 sample rows · 18 columns

Each crew member's employee code, crew, onboarding stage, pay and the certificates and shifts linked to them.

Crew filePersonEmployee codeCrewEmploymentStatusOnboarding
Alaric Dlamini-Prescott, equipment installerAlaric Dlamini-PrescottMR-114EquipmentFull timeActiveCleared
Ambrose Kuznetsov-Mensah, apprenticeAmbrose Kuznetsov-MensahMR-120FieldApprenticeActivePaperwork
Bartholomew Nkrumah-Vale, pool plumberBartholomew Nkrumah-ValeMR-106PlumbingFull timeActiveCleared
Calliope Banerjee-Strand, apprenticeCalliope Banerjee-StrandMR-119FieldApprenticeActiveSite safety
Caspian Ngata-Delacroix, shotcrete nozzlemanCaspian Ngata-DelacroixMR-108ShotcreteFull timeActiveCleared
Dagobert Hollingsworth-Eze, site superintendentDagobert Hollingsworth-EzeMR-102FieldFull timeActiveCleared
Fenwick Takahashi-Brandt, tile setterFenwick Takahashi-BrandtMR-112FinishingFull timeActiveCleared
Gideon Pellerin-Ncube, service technicianGideon Pellerin-NcubeMR-116ServiceFull timeOn leaveCleared
Ignatius Valcourt-Sibanda, steel and rebar techIgnatius Valcourt-SibandaMR-110ShotcreteSeasonalSeasonalCleared
Imelda Faulkner-Ogunbanjo, pool plumberImelda Faulkner-OgunbanjoMR-107PlumbingFull timeActiveCleared
Leopold Tran-Whitcombe, office coordinatorLeopold Tran-WhitcombeMR-122OfficeFull timeActiveCleared
Linnea Galbraith, project managerLinnea GalbraithMR-101OfficeFull timeActiveCleared

10 more rows

Certifications

50 sample rows · 9 columns

The licences and safety cards each person holds, with the day each one lapses.

CertificateHolderKindCertificate numberIssuedExpiresRenewal fee
Bartholomew Nkrumah, cpr and first aidBartholomew Nkrumah-Vale, pool plumberCPR and first aidMR-CERT-4114Aug 18, 2024Aug 18, 2026$85
Ignatius Valcourt, cpr and first aidIgnatius Valcourt-Sibanda, steel and rebar techCPR and first aidMR-CERT-4124Aug 18, 2024Aug 18, 2026$85
Perpetua Wanjiru, confined space entryPerpetua Wanjiru-Abbott, excavation leadConfined space entryMR-CERT-4106Sep 21, 2023Sep 20, 2026$140
Zelda Montrose, cpr and first aidZelda Montrose-Adeyinka, plumbing leadCPR and first aidMR-CERT-4112Sep 20, 2024Sep 20, 2026$85
Alaric Dlamini, certified pool operatorAlaric Dlamini-Prescott, equipment installerCertified pool operatorMR-CERT-4131Sep 21, 2021Sep 20, 2026$395
Caspian Ngata, shotcrete nozzlemanCaspian Ngata-Delacroix, shotcrete nozzlemanShotcrete nozzlemanMR-CERT-4119Oct 12, 2021Oct 11, 2026$350
Lysander Okonjo, excavation competent personLysander Okonjo-Pryor, excavator operatorExcavation competent personMR-CERT-4108Oct 28, 2023Oct 27, 2026$220
Dagobert Hollingsworth, excavation competent personDagobert Hollingsworth-Eze, site superintendentExcavation competent personMR-CERT-4105Nov 16, 2023Nov 15, 2026$220
Thessaly Mbeki, shotcrete nozzlemanThessaly Mbeki-Ruddock, shotcrete finisherShotcrete nozzlemanMR-CERT-4121Nov 16, 2021Nov 15, 2026$350
Gideon Pellerin, certified pool operatorGideon Pellerin-Ncube, service technicianCertified pool operatorMR-CERT-4134Nov 16, 2021Nov 15, 2026$395
Dagobert Hollingsworth, commercial driver's licenseDagobert Hollingsworth-Eze, site superintendentCommercial driver's licenseMR-CERT-4103Dec 2, 2022Dec 1, 2026$60
Zelda Montrose, confined space entryZelda Montrose-Adeyinka, plumbing leadConfined space entryMR-CERT-4111Dec 2, 2023Dec 1, 2026$140

38 more rows

Shifts

40 sample rows · 8 columns

Who is on which job site on which day, and for how many hours.

ShiftCrew memberWorkJob siteStartsEndsStatus
Rosamund Achterberg, tile and coping, IronwoodRosamund Achterberg-Oyelowo, tile and coping leadTile and copingIronwood Bend lap poolSep 22, 1:30 PMSep 22, 10:00 PMDone
Caspian Ngata, shotcrete, CallowayCaspian Ngata-Delacroix, shotcrete nozzlemanShotcreteCalloway Heights freeform poolSep 22, 2:00 PMSep 22, 10:00 PMDone
Thessaly Mbeki, shotcrete, IronwoodThessaly Mbeki-Ruddock, shotcrete finisherShotcreteIronwood Bend lap poolSep 22, 2:00 PMSep 22, 10:00 PMDone
Perpetua Wanjiru, excavation, SablecrestPerpetua Wanjiru-Abbott, excavation leadExcavationSablecrest Court courtyard plungeSep 23, 2:00 PMSep 23, 10:00 PMDone
Alaric Dlamini, equipment start-up, VerdantAlaric Dlamini-Prescott, equipment installerEquipment start-upVerdant Mesa spa and spill-overSep 24, 1:30 PMSep 24, 10:00 PMDone
Ignatius Valcourt, shotcrete, MiradorIgnatius Valcourt-Sibanda, steel and rebar techShotcreteMirador Vale cocktail poolSep 25, 1:30 PMSep 25, 10:00 PMDone
Alaric Dlamini, equipment start-up, CoyoteAlaric Dlamini-Prescott, equipment installerEquipment start-upCoyote Lantern backyard resortSep 29, 1:30 PMSep 29, 10:00 PMDone
Dagobert Hollingsworth, site prep, HalcyonDagobert Hollingsworth-Eze, site superintendentSite prepHalcyon Ridge infinity edgeSep 29, 1:30 PMSep 29, 10:00 PMDone
Marguerite Oduya, tile and coping, PinyonMarguerite Oduya-Hallsworth, plaster applicatorTile and copingPinyon Wash family poolSep 29, 1:30 PMSep 29, 10:00 PMDone
Thessaly Mbeki, shotcrete, HalcyonThessaly Mbeki-Ruddock, shotcrete finisherShotcreteHalcyon Ridge infinity edgeOct 1, 1:30 PMOct 1, 10:00 PMDone
Zelda Montrose, plumbing rough-in, IronwoodZelda Montrose-Adeyinka, plumbing leadPlumbing rough-inIronwood Bend lap poolOct 1, 1:30 PMOct 1, 10:00 PMDone
Ignatius Valcourt, shotcrete, CoyoteIgnatius Valcourt-Sibanda, steel and rebar techShotcreteCoyote Lantern backyard resortOct 1, 2:00 PMOct 1, 10:00 PMDone

28 more rows

Forms and booking

New crew sheet

Form
New crew sheetCollects a new hire's details on the first morning.
What is the new hire's name and role? *
Which person on the team list is this? *
What employee code was issued? *Looks like MR-123.
Which crew will they work on?OfficeFieldExcavationPlumbingShotcreteFinishingEquipmentService
Full time, seasonal or apprentice?Full timeSeasonalApprentice
Who should we call in an emergency?
What number reaches that person?
Send to the office

Also included

  • Crew onboardingChecklist
  • Monday renewalsDigest
  • Certificate lapsedNotificationTells the safety officer the moment a card runs out.

Related templates