Katahdin Logic LLC: Intelligent Data Systems for Mission-Driven Organizations

Intelligent Data Systems for Mission-Driven Organizations

We turn complex data challenges into working systems: automated pipelines, AI-powered document processing, custom dashboards, and integrations that connect your tools. If you have messy data, manual processes, or information locked in documents, we can help.

Founded in Portland, Maine by Allison Dzubak, Ph.D., Katahdin Logic brings research-grade analytical thinking to the practical data challenges facing local and mission-driven organizations. We work closely with clients to build systems that are reliable, maintainable, and built to grow with your organization.

Featured Work

Legislative Transparency Platform

Live

A civic engagement tool that automates Congressional bill tracking with AI-powered summaries, making legislative activity accessible and understandable. Bills are ingested daily from Congress.gov, summarized by Claude API, and surfaced through a clean public interface.

Bill tracker showing stats banner and legislative status categories

Browse by Status

Bills organized by legislative status with real-time counts, from introduction through committee to floor votes and signing.

AI-generated bill summary with expandable details

AI-Powered Summaries

Claude API generates two-tier summaries: key points at a glance plus expandable detail for deeper reading.

Multiple bill cards showing diverse policy areas

From Congress.gov to Plain English

Raw legislative data transformed into readable, searchable bill cards covering diverse policy areas.

The platform runs on Flask and PostgreSQL, deployed on Railway with scheduled jobs for daily bill ingestion from Congress.gov. Key design decisions included a two-tier summary format to balance accessibility with depth, rate limiting and retry logic for reliable API interactions, and a multi-dimensional reviewer feedback system so human oversight can continuously improve summary quality. API cost monitoring was built in from the start to track Claude API usage and ensure sustainable operation at scale.

Solar Energy Intelligence

Live

A real-time monitoring and rate optimization dashboard for residential solar, tracking production, consumption, credit balances, and projected ROI. Designed to scale across any residential installation, it bridges the gap between raw inverter data and the financial picture that homeowners care about.

Dashboard showing real-time energy production and consumption data

Real-Time Monitoring

Production and consumption data updated every 15 minutes from the SolarEdge API, with toggleable daily, weekly, and monthly views.

Savings tracker showing net metering credit balance, cumulative savings, and ROI progress bar

Credit Tracking & ROI

Net metering credits tracked with FIFO expiration logic under Maine's 12-month NEB policy, alongside cumulative savings and payback progress.

Rate plan comparison showing modeled monthly bills across three CMP rate structures

Rate Plan Optimization

Monthly bill modeled across CMP's Rate A, Electric Technology, and Time-of-Use plans to identify the most cost-effective structure.

Automated 15-minute data collection from the SolarEdge API which is combined with utility billing records to model energy costs across three CMP rate structures. Credit tracking uses FIFO queue logic to match Maine's 12-month rolling expiration policy under the Net Energy Billing program. The rate plan comparison reveals whether Rate A, Electric Technology, or Time-of-Use pricing is most favorable given a site's actual production and consumption patterns.

Services

We help mission-driven organizations turn complex data challenges into clear, working systems.

AI Document Processing

Summarization, extraction, and classification powered by AI. Turn documents, reports, and unstructured text into actionable, searchable data.

Data Pipelines & Cleanup

Messy spreadsheets to clean databases. We build automated data ingestion, transformation, and migration workflows that bring order to your data.

Custom Dashboards & Reporting

Program and impact data dashboards, grant reporting automation, and analytics interfaces that help your team make informed decisions.

API Integrations

Connect your nonprofit tools, build intelligent search over organizational knowledge, and automate workflows across systems.

Full-Stack Development

End-to-end web application development with clean code, comprehensive testing, and production deployment. From backend architecture to user-facing interfaces.

Technical Consulting & Strategy

Strategic guidance on technical architecture, AI implementation, and system design. Navigate complex technical decisions with expert insight and hands-on experience.

Get In Touch

Have a data challenge, a process that needs automating, or an idea for how AI could help your organization? Let's talk.