Team Kilimanjaro Operations Hub

kilimanjaro.vc · Internal tools & coordinator resources

🧭

John's Tools

JRE
📣
Social Media Publisher
kilimanjaro.vc/social.html
Post to Facebook, Instagram, and LinkedIn (copy-paste) for Team Kilimanjaro. Includes AI caption generation. Use this daily — the more consistently it's used, the better the content pipeline.
Next step Link to Anthropic API to auto-suggest post copy in John's voice, drawing from trip reports and recent climbs. Improve content policy clause precision.
JREDaily use
📖
Social Media Manual
kilimanjaro.vc/social-media-manual.html
Step-by-step guide for the social media tool — how to post, refresh expired tokens (Meta and LinkedIn), add images and video, and post to LinkedIn manually. All links included.
JREReference
📸
Image Library — S3 Upload
kilimanjaro.vc/s3-upload.html
Drag and drop photos directly into the TK S3 image library (teamkilimanjaro/resources/). Auto-generates 640px thumbnails. Updates social.html library instantly. Browse, copy URLs, or delete existing images.
JREMedia
🖼️
Image Processor
sas.vc/images.html
Resize and optimise images for web use. Outputs hero (2400×945) and body (2400×1260) formats for Marafiki and other sites. Drag and drop, preview, process, and copy the ready-to-paste HTML code.
JREMedia
🔍
Web Scraper
sas.vc/scrape.html
Extract content and data from web pages for use in TK tools and content pipelines.
JRE
🔗
SEO & Link-Building Manager
kilimanjaro.vc/tk4.html
TK Content Library — manages the full backlink workflow: domain analysis via DataForSEO, spam detection, article generation, placement tracking, health checking, and payment invoicing.
Next step Fix dodgy link destinations to conform to the sitemap. DataForSEO enrichment pipeline needs review. Disavow file management integration.
JREFix links
🌍

Everyone · Core Tools

All team
📅
TK Expedition Calendar
teamkilimanjaro.com/tk-calendar.html
Live expedition calendar populated from the TK26 Google Sheet. Two-tier access: public view and coordinator view (payment status, airport transfer alerts, full briefing system). The operational source of truth for all upcoming climbs.
Next step Passport OCR pipeline: extract climber fields via Claude Vision, crop TANAPA-spec portraits, write to Climber Registration Google Sheet, generate portrait ZIP.
All team
🏔️
Park Fees Calculator
kilimanjaro.vc/park-fees.html
TANAPA & NCAA 2023/2024 tariff calculator. Handles all person categories (foreign, EAC, TZ resident), Marangu vs camping routes, Kilimanjaro staff fees with editable crew counts, VAT breakdown, and TZS conversion.
Next step Update to 2024/2025 tariffs when published. Hook into climb costings generator to auto-populate park fee rows.
All team
🍽
Expedition Food Calculator
kilimanjaro.vc/food.html
Enter climb code, pax, days, series and diet requirements. Outputs a fully itemised food list with quantities and TZS costs for Allmart, local market, and Village Supermarket. Calibrated to real Jun 2026 invoices.
All team
✎
Custom Food Calculator
kilimanjaro.vc/custom-food.html
Alternative to the standard food calculator for guides who prefer to build their own list. Same climb parameters but allows item-by-item quantity overrides before generating the order sheet.
All team
🛒
Local Market Price Survey
kilimanjaro.vc/local-market.html
Price survey tool for Moshi local market. Record current prices for fresh produce, staples, and supplies used on expeditions. Outputs a shopping list with quantities and TZS costs, and allows bulk image capture for the S3 library.
All team
📋

Coordinator Tools

RJ · JP · A
📦
Bundle Creator
kilimanjaro.vc/bundle.html · not yet built
Generates the pre-climb document bundle for each expedition: porter contracts, money declaration, client registration, expedition sheet — auto-populated from TK26 and OCR'd passport data from Google Drive. One click produces a complete, ready-to-print bundle.
Next step Build. Requires: TK26 Google Sheets connection, Google Drive passport OCR pipeline (Claude Vision), and PDF generation (existing PDF skill). Populate from climb code match.
CoordinatorsTo build
💰
Climb Costings Generator
kilimanjaro.vc/costings.html · not yet built
Replaces the yellow-cell Excel expedition sheet shown in the screenshot. User-editable inputs are pre-populated by matching the climb code from TK26 / tk-calendar.html. Outputs feed into a .json recording all payments, and an attractive coordinator summary shows who gets what cash and when.
Next step Build from screenshot. Yellow cells become editable inputs. Park fees tab connects to park-fees.html calculations. JSON records all transactions per expedition, per person.
CoordinatorsTo build
🎒
Equipment Check-Out / Check-In
kilimanjaro.vc/equipment.html · not yet built
Guide selects an expedition from a TK26 dropdown and enters his own name. Toggles between gear-out and gear-in. Checks each item of kit, inputs serial numbers where available, then downloads a .json. Updates the inventory so we always know which items any guide has and which clients they're with. A guide should not be paid until the gear-in .json is submitted.
Next step Build. Uses /data/equipment.json (generated from TK Equipment Inventory.xlsx, now available). JSON log records each item's history: guide, dates, expedition, order of use.
GuidesCoordinatorsTo build
🧗

Guide Tools

Guides
🛒
Rongai Resupply Calculator
kilimanjaro.vc/resupply.html
Calculates per-porter resupply transport costs for the Rongai route. Outputs a WhatsApp-ready formatted breakdown. Covers Arusha→Moshi, Moshi→Tarakea, accommodation, food, and boda boda to gate.
Next step Extend to cover other routes that require resupply. Link to costings generator output.
Guides
🎒
Equipment Check-Out / Check-In
kilimanjaro.vc/equipment.html
Before the climb: select expedition from dropdown, select your name, check out each item of kit and enter serial numbers. Download your gear-out .json. After the climb: toggle to gear-in, confirm all items returned, download gear-in .json. Payment is not released until gear-in .json is submitted.
Next step Build. /data/equipment.json is now ready. Needs TK26 integration for expedition dropdown and guide name list.
GuidesTo build
✉️

Communications & Reports

L
✍️
Correspondence Builder
kilimanjaro.vc/correspond.html
Builds client-facing emails from paragraph libraries (paragraphs-A.json through paragraphs-H.json). Ensures consistent, on-brand communication. Currently uses pre-written paragraphs; AI integration planned.
Next step Connect to Anthropic API. Train on John's voice more accurately by improving all /shared/assets/paragraphs-*.json files — use real sent emails as examples. AI should suggest and adapt paragraphs, not replace the library.
LAI upgrade planned
🗂️
Coordinator Dashboard
teamkilimanjaro.com/coordinator.html
Central coordinator view on the main TK website. Expedition management, client communication tracking, and team briefing tools.
Next step Review what's live and what's broken. Integrate with TK Calendar and bundle creator when built.
L
📝
Report Creator
reports.teamkilimanjaro.com/report-creator.html
Creates and publishes TK Live Reports from field submissions. Guides submit via field.html, photos go to S3, reports.json is the canonical source, and a Lambda function auto-publishes static HTML to SiteGround. AI caption generation (Fiennes-style Improve button) is live.
Next step Lambda S3 trigger health check. KALE day-1 throb diagnosis. Schema validator for reports.json.
LLambda check needed

🦁

Safari Operations

safari.vc
JRE tools
🗺️
Safari Proposal Editor
safari.vc/proposals/coord-editor.html
Coordinator-facing proposal builder for safari itineraries. Builds structured proposals with accommodation, activities, and pricing.
Next step Amend to call safari.vc/proposals/shared/assets/accommodation.json directly (currently broken). Also allow local upload of accommodation.json as fallback. Fix the accommodation data path.
JREFix data path
📍
Track Editor
teamkilimanjaro.com/track-editor.html
GPX/KML import, undo/redo, elevation fill, Douglas-Peucker decimation, and GraphHopper routing. Manages the 36 trek legs in tracks.json. Edits routes for both Kilimanjaro and Toubkal itineraries.
Next step Add export to safari.vc itinerary format. Sync tracks.json updates to S3.
JRE
L tools
🏕️
Lodge Map Browser
safari.vc/proposals/lodge-map.html
Interactive lodge browser with Leaflet map, price histogram, area filters, and photo slideshows. Reads accommodation.json with aka arrays for name matching. Used to research and select lodges for proposals.
Next step Keep accommodation.json up to date. Add direct link from lodge card to proposal editor pre-populated with that lodge.
L
💵
Safari Cost Calculator
safari.vc/u9.html
Universal Safari Cost Calculator v9. Covers accommodation, expedition, park fees, and camping tabs. Password-gated internal margin view. Outputs HTML for webpage embedding and a price-per-person breakdown table for 1–7 pax.
Next step Connect park fees tab to kilimanjaro.vc/park-fees.html data layer. Add NCAA crater fee and 2024/2025 tariff update.
L
📄
Safari Itineraries
safari.vc/itineraries.html
Safari itinerary viewer and management. Feeds the map generator (map-generator.js) which auto-plots routes from itinerary page content via OSRM routing.
Next step Ensure map-generator.js is routing correctly after any OSRM endpoint changes. Sync with lodge-map.html data.
L