Excel dataset ============= Database schema: workbook Platform: sqlite Tables: 2 Total rows: 160 ABOUT THE BUSINESS ------------------ GreenScape Pro is a mid-sized commercial landscaping company servicing office parks, retail centers, and municipal properties across four regional divisions. The company employs multiple field crews who log hours on job sites and purchase materials such as mulch, sod, fertilizer, and irrigation supplies. Management uses quarterly invoicing to bill clients and tracks job profitability by comparing crew labor costs against material expenditures and billed revenue. The Excel assignment requires students to analyze crew efficiency, material spending patterns, and quarterly revenue performance across regions and job types. WHAT EACH TABLE HOLDS --------------------- Jobs (80 rows) One row per transaction — this is where the volume is, and where most analysis starts. SiteDirectory (80 rows) One row per transaction — this is where the volume is, and where most analysis starts. HOW THE TABLES RELATE --------------------- Day-to-day activity is recorded in Jobs and SiteDirectory. DATA DICTIONARY --------------- Jobs JobID pk e.g. 1 Unique identifier for each Jobs row. Region category e.g. North One of: North, South, East, West. JobType category e.g. Landscape Design One of: Lawn Maintenance, Irrigation Install, Mulching, Sod Installation, …. ClientType category e.g. Retail Center One of: Office Park, Retail Center, Municipal, HOA, …. Quarter category e.g. Q4 One of: Q1, Q2, Q3, Q4. JobDate date e.g. 2025-03-15 CrewLead full_name e.g. Dalia Larsen Full name of the crew leader responsible for the job CrewSize int e.g. 3 Number of workers on the crew including the lead HoursWorked decimal e.g. 39.6 Total crew hours logged for the job HourlyRate decimal e.g. 22.92 Blended hourly labor rate per crew member in USD MaterialCost decimal e.g. 2093.92 Actual cost of materials purchased for the job in USD InvoiceAmount decimal e.g. 9123.57 Amount billed to the client for the job in USD PaymentStatus category e.g. Pending One of: Paid, Pending, Overdue. JobSiteID text e.g. Wholesale case Alphanumeric site code linking to the SiteDirectory lookup sheet, e.g. SITE-042 SiteDirectory JobSiteID text e.g. Clearance run Unique alphanumeric site code matching JobSiteID in the Jobs sheet SiteName text e.g. Refurbished bundle Descriptive name of the client property, e.g. Riverside Office Park ContractTier category e.g. Gold One of: Bronze, Silver, Gold, Platinum. AnnualContractValue decimal e.g. 56273.8 Total annual contracted value with the client in USD Region category e.g. North One of: North, South, East, West. PROVENANCE ---------- Every value in this dataset is synthetic. No real person, company, or record is represented. Generated by the Agoge dataset generator 1.0.0 with seed 42. The same brief and seed reproduce this data exactly.