3 Data – Logistics Trade Systems Center

*** WELCOME TO LTSCENTER.COM *** South America Trade & Logistics Analysis *** Port of Chancay now operational *** CIP Score now live *** Panama Canal updates *** Brazil port boom continues *** NEW: Interactive choropleth map *** UPDATED: Country profiles ***

◆ LTS CENTER ◆

South America Trade & Logistics Node Analysis

★ NEW ★ Open data for replication — Rice University MGA 2026 ★ NEW ★

► DATA & REPLICATION FILES

All datasets used in this capstone are available for download and replication. The Excel workbook contains 11 sheets covering LPI scores, IDB project scores, CIP composite scores, WGI governance data, and full methodology documentation.

If you use this data, please cite: Ruiz Quevedo, G. (2026). South America Trade and Logistics Node Analysis. Rice University MGA.

📊 CIP / LPI / IDB / WGI SCORES — FULL WORKBOOK File: cip_scores_ruiz.xlsx | 11 sheets | Open .xlsx format
Contains: LPI scores, IDB scores, CIP composite, WGI governance, full methodology tabs

⬇ DOWNLOAD .XLSX

► WHAT’S INSIDE — 11 SHEETS

TAB 1Table for WordClean summary table used in the final report: Country, LPI, IDB, CIP scores.

TAB 2CI Mod 2CIP composite with expanded per-country analysis notes.

TAB 3CI ModCIP master table: LPI (0–2), IDB (0–2), CIP composite score and analysis.

TAB 4CI Combined OGOriginal combined CIP working sheet with formula derivation.

TAB 5LPIRaw LPI customs and timeliness scores with 0–2 pressure conversion.

TAB 6LPI MethodologyFull LPI data: year, overall, customs, timeliness, pressure score, analysis, and formula rationale.

TAB 7IDBIDB repair attempts, recurrence classification, and pressure score per country.

TAB 8IDB MethodologyFull IDB data: project IDs, type, time range, recurrence, score, and keyword search methodology.

TAB 9WGI StatWorld Bank Governance Indicators — Gov. Effectiveness & Control of Corruption with 0–2 risk score.

TAB 10LIPICombined view: CIP pressure score alongside WGI governance risk score per country.

TAB 11WGI MethodologyFull WGI data with scoring thresholds, analysis notes, and source documentation.

► CIP SCORE METHODOLOGY (QUICK REF)

Metric 1 — LPI (World Bank): Customs Efficiency + Timeliness. Both ≥3.2 → 0. Either 2.7–3.2 → 1. Either below 2.7 → 2.

Metric 2 — IDB Projects: No projects → 0. One-off → 1. Recurring → 2.

Composite: If both available: ROUND((LPI + IDB) / 2, 0). If only IDB (Ecuador, Suriname): use IDB score.

■ 0 = Low Pressure ■ 1 = Moderate Pressure ■ 2 = High Pressure