Kantata Data Extractor
Extract and format inspection data from Palantir sheets
Extraction Status
Ready
The extractor is ready to process data from the Palantir spreadsheet.
Configuration Settings
Spreadsheet Settings
The ID from the Google Sheets URL
Filter Criteria
Column Mapping
| Target Column | Source | Format |
|---|---|---|
| Column A (Target) | Use {A}, {B}, {C}, etc. as column placeholders | |
| Column B (Target) | ||
| Column C (Target) |
Format Settings
Python strftime format for input dates
Python strftime format for output dates
Inspection Analysis
Generate Copy-Paste Report
Analyze Sheet1 data and generate a formatted report categorizing inspections into subcontractor, internal, and non-entered inspections.
The ID from the Google Sheets URL
Analysis Logic
- Subcontractor Inspections: Initials = "RV" AND has invoice in Column H
- Internal Inspections: Initials ≠ "RV" AND has invoice in Column H
- All Inspections (Not Entered): Any inspection without invoice in Column H