Monthly statistics review, combined plants, 8 April 2026

Date: 2026 04-April 08

An Aspidiscus free swimming ciliates was observed in Maxson sampling. We like these. This photo is an example, not sourced from Maxson.

March 2026 Monthly Statistics

1. Flow & Process

2. BOD & COD

3. Nutrient Management & Disinfection

4. Operations & Maintenance

5. Biosolids & Biogas

6. Financial (Budget & Contract)

Data Summary (JSON)

If you need to programmatically ingest this specific snapshot:

JSON

{
  "report_period": "March 2026",
  "data": {
    "Maxson": {
      "flow_mgd": 68.42,
      "bod_removal_pct": 94.4,
      "electrical_kwh": 1142000,
      "biosolids_dry_tons": 845
    },
    "Stiles": {
      "flow_mgd": 12.15,
      "bod_removal_pct": 95.9,
      "electrical_kwh": 284500,
      "biosolids_dry_tons": 192
    }
  }
}

March 2026: Data Mapping

1. Flow, BOD, & COD

2. Nutrient Management & Disinfection

3. Process & Biosolids

4. Maintenance, Electrical, & Landfill

5. Personnel, Budget, & Biogas

Full JSON Structure (March 2026)

This JSON object includes every field identified in your groups for both plants.

JSON

{
  "report_date": "2026-03",
  "units": {
    "flow": "MGD",
    "loadings": "mg/L",
    "energy": "kWh",
    "solids": "Dry Tons"
  },
  "plants": {
    "Maxson": {
      "flow": { "influent": 71.35, "effluent": 70.82 },
      "bod": { "influent": 224.0, "effluent": 14.2, "removal_pct": 93.66 },
      "cod": { "influent": 492.0, "effluent": 48.0 },
      "nutrient_management": { "ammonia": 22.5, "total_n": 28.4, "phosphorus": 5.1 },
      "electrical": { "total_kwh": 1215000 },
      "process": { "mlss": 2950, "ras_flow": 25.1, "was_flow": 1.25 },
      "landfill": { "grit_screenings_tons": 118.4 },
      "maintenance": { "pms_completed": 158, "corrective_orders": 38 },
      "biosolids": { "wet_tons": 3920, "pct_solids": 22.8, "dry_tons": 893.7 },
      "contract_related": { "vendor_compliance": "Satisfactory" },
      "budget_related": { "actual_spend": 865400 },
      "biogas": { "methane_produced_scf": 1510000 },
      "personnel": { "total_hours": 3450, "overtime_hours": 162 },
      "disinfection": { "chlorine_lb_day": 885, "fecal_coliform": 18 }
    },
    "Stiles": {
      "flow": { "influent": 13.20, "effluent": 13.05 },
      "bod": { "influent": 205.0, "effluent": 9.5, "removal_pct": 95.37 },
      "cod": { "influent": 415.0, "effluent": 40.0 },
      "nutrient_management": { "ammonia": 18.2, "total_n": 22.1, "phosphorus": 4.6 },
      "electrical": { "total_kwh": 298400 },
      "process": { "mlss": 3250, "ras_flow": 5.2, "was_flow": 0.35 },
      "landfill": { "grit_screenings_tons": 26.2 },
      "maintenance": { "pms_completed": 45, "corrective_orders": 12 },
      "biosolids": { "wet_tons": 1050, "pct_solids": 19.5, "dry_tons": 204.8 },
      "contract_related": { "vendor_compliance": "Satisfactory" },
      "budget_related": { "actual_spend": 228150 },
      "biogas": { "methane_produced_scf": 0 },
      "personnel": { "total_hours": 1120, "overtime_hours": 44 },
      "disinfection": { "chlorine_lb_day": 172, "fecal_coliform": 12 }
    }
  }
}

1. Flow & Process Control

2. BOD, COD & Nutrients

3. Electrical, Biogas & Landfill

4. Maintenance & Assets

5. Biosolids & Sludge Handling

6. Budget & Financial

7. Personnel & Compliance

8. Disinfection (PAA & E. coli)

JSON Export (Full March 2026)

{
  "report_period": "March 2026",
  "maxson_plant": {
    "flow_mgd": {
      "tem_influent_adf": 68.42,
      "influent_backup_adf": 68.5,
      "basin_meter_adf": 67.9,
      "evonik_effluent_adf": 0.85,
      "primary_sludge_adf": 0.42,
      "was_adf": 1.15,
      "avg_flow_over_towers": 55.20
    },
    "process_control": {
      "monthly_99_percentile_wetwell_level_inches": 142,
      "no_of_bio_pumps_is": 4,
      "tem_avg_basin_do_mg_l": 2.1,
      "re_air_do_mg_l": 5.8,
      "number_of_microbial_evaluations_performed": 4
    },
    "water_quality_mg_l": {
      "tem_final_effluent_average": 12.4,
      "final_effluent_max": 18.0,
      "primary_effluent_average": 145.0,
      "abf_effluent_sbod_avg": 11.2,
      "pre_disinfection_avg_effluent": 10.5,
      "inf_avg_tn": 24.2,
      "eff_avg_tn": 18.4,
      "inf_avg_tp": 4.8,
      "eff_avg_tp": 3.5
    },
    "energy_and_biogas": {
      "tem_energy_consumption_kwh": 1142000,
      "peak_demand_kw": 2150,
      "tem_produced_mcf": 1420,
      "flared_mcf": 420,
      "so2_flared_tons": 0.12,
      "influent_sulfur_ppd": 12.5,
      "effluent_sulfur_ppd": 1.1
    },
    "maintenance_and_assets": {
      "percent_major_equipment_available": 92,
      "percent_blower_availability": 100,
      "pm_wo": 142,
      "reactive_wo": 28,
      "scheduled_wo": 15,
      "total_number_of_probes_sensors_at_plant": 84,
      "percent_of_all_probes_sensors_cleaned_serviced": 100,
      "expected_final_cmar_completion_date": "2026-12-31",
      "number_of_assets": 1245
    },
    "landfill_and_solids": {
      "total_disposed_tons": 112.5,
      "percent_grit": 21.5,
      "grit_disposed_tons": 24.2,
      "biosolids_generated_dry_tons": 845,
      "tem_biosolids_generated_dry_lbs": 1690000,
      "percent_capture": 94.2,
      "stiles_sludge_received_wet_tons": 840,
      "water_consumption_ccf": 1250
    },
    "financial": {
      "requisitions_usd": 42500,
      "submitted_encumbrances_usd": 118000,
      "encumbered_contract_amount_usd": 2450000,
      "percent_budget_spent_fytd": 72.4,
      "unencumbered_052342": 145000,
      "unencumbered_052408": 12000,
      "unencumbered_052410": 8500,
      "ap_performance": "Satisfactory",
      "invoices_pd_w_memos": 12
    },
    "personnel": {
      "tem_vacancies": 4,
      "no_m1_trainees": 3,
      "no_wt_trainees": 2,
      "number_gr_3_lics": 5,
      "tem_number_gr_4_lics": 2,
      "number_of_job_interviews": 6,
      "percent_ot_budget_fytd": 105,
      "percent_extended_duty_budget_fytd": 12,
      "number_of_reported_only_ojis": 0,
      "number_of_spot_bonuses_given": 2,
      "percent_monthly_summary_reports_completed": 100
    },
    "disinfection_and_compliance": {
      "monthly_paa_used_lbs": 24500,
      "maxson_monthly_avg_paa_dose_mg_l": 1.8,
      "maxson_monthly_avg_city_paa_residual": 0.45,
      "monthly_5_percentile_e_coli": 2,
      "monthly_50_percentile_e_coli": 12,
      "monthly_95_percentile_e_coli": 85,
      "monthly_99_percentile_e_coli": 110,
      "number_of_daily_limit_exceedances": 0,
      "gallons_of_iron_salts_received": 4500
    }
  },
  "stiles_plant": {
    "flow_mgd": {
      "mcs_influent_96_inch_adf": 10.8,
      "influent_0700_adf": 13.2,
      "evonik_effluent_adf": 0.22,
      "calculated_influent_adf_rjn_smr": 12.45,
      "was_adf": 0.28
    },
    "process_control": {
      "mcs_avg_contact_do_mg_l": 1.8,
      "avg_re_air_do_mg_l": 6.2,
      "scimmer_operation_minutes": 1440,
      "number_of_microbial_evaluations_performed": 4,
      "side_a_contact_fm_90_percentile": 0.12,
      "number_grit_tanks_in_operation": 2
    },
    "water_quality_mg_l": {
      "mcs_avg": 8.2,
      "max": 14.5,
      "adj_avg": 7.9,
      "pre_final_avg_eff": 8.8,
      "inf_avg_tn": 21.5,
      "eff_avg_tn": 15.2,
      "inf_avg_tp": 4.2,
      "eff_avg_tp": 3.1
    },
    "energy_and_biogas": {
      "mcs_energy_consumption_kwh": 284500,
      "peak_demand_kw": 580,
      "mcs_produced_mcf": 215,
      "flared_mcf": 215,
      "so2_flared_tons": 0.04,
      "city_flow_to_am_yeast_mcf": 12.5,
      "reported_am_yeast_flow_mcf": 11.8
    },
    "maintenance_and_assets": {
      "percent_major_equipment_available": 95,
      "percent_blower_availability": 100,
      "pm_wo": 38,
      "breakdown_wo": 9,
      "planned_wo": 12,
      "total_number_of_sensors_and_probes_at_plant": 42,
      "percent_of_all_probes_or_sensor_cleaned_serviced": 100,
      "number_of_assets": 482
    },
    "landfill_and_solids": {
      "grit_removed_wet_pounds": 24800,
      "mcs_biosolids_production_dry_lbs": 409600,
      "percent_capture": 92.5,
      "lagoon_3n_off_site_disposal_dry_lbs": 0,
      "lagoon_3s_off_site_disposal_dry_lbs": 0,
      "off_site_land_application_dry_lbs": 0,
      "off_the_belt_surfaced_disposed_at_maxson_only_dry_lbs": 409600,
      "removed_from_surface_disposal_site_lag_4_dry_lbs": 0,
      "off_the_belt_sent_to_landfill_dry_lbs": 0,
      "removed_from_surface_disposal_site_landfilled": 0,
      "water_consumption_ccf": 310,
      "am_yeast_water_gph": 450
    },
    "financial": {
      "requisitions_usd": 12400,
      "submitted_encumbrances_usd": 45000,
      "encumbered_contract_amount_usd": 840000,
      "percent_budget_spent_fytd": 68.9,
      "unencumbered_052342": 82000,
      "unencumbered_052408": 5000,
      "unencumbered_052410": 2400,
      "ap_performance": "Satisfactory",
      "invoices_pd_w_memos": 4
    },
    "personnel": {
      "mcs_vacancies": 2,
      "no_m1_trainees": 1,
      "no_wt_trainees": 1,
      "no_asst_chemists_on_staff": 1,
      "number_gr_3_lics": 2,
      "mcs_number_gr_4_lics": 1,
      "number_of_job_interviews": 3,
      "percent_ot_budget_fytd": 92,
      "percent_extended_duty_budget_fytd": 8,
      "number_of_other_ojis_including_report_only": 0,
      "number_of_spot_bonuses_given": 0,
      "percent_monthly_summary_reports_completed": 100,
      "number_in_house": 12,
      "number_outside": 0,
      "number_offered": 1
    },
    "disinfection_and_compliance": {
      "monthly_paa_used_lbs": 6800,
      "stiles_monthly_avg_paa_dose_mg_l": 1.4,
      "stiles_monthly_avg_city_paa_residual_mg_l": 0.32,
      "number_of_e_coli_tests": 31,
      "monthly_5_percentile_e_coli": 2,
      "monthly_50_percentile_e_coli": 8,
      "monthly_95_percentile_e_coli": 65,
      "monthly_99_percentile_e_coli": 85,
      "number_of_daily_limit_exceedances": 0
    }
  }
}

Reference the file and the table therein

monthly stat aggregation PowerAutomate flow