GO GREEN — BNI Kottons

🗺️ Score Journey

🎯 Go Green Progress

Loading…

Target: 70% green

0%

📤 Export CSV

Download for external use

🔍

📊 Score Distribution

🏆 Top Scorers

⚡ Easiest Upgrades

💡 Key Insights

💰 TYFCB Remaining (Top 8)

📋 How BNI Kottons Score is Calculated

Score is calculated over a 6-month rolling period. Weekly averages matter — give more referrals and visitors consistently each week to move up tiers. Total score = sum of all parameter scores below (max 100).

🗺️ How to increase your score — 6 ways

📤 Average 1.2 referrals/week for 6 months → 20 pts

🎓 Attend trainings every month → up to 15 pts

👤 Average 1 visitor/week for 6 months → 20 pts

🗣 Write testimonials regularly → up to 10 pts

✅ Attend every meeting on time → 20 pts

💰 Make sure people thank you for business → 15 pts

Note: Score is calculated over a 6-month period. The "Next Levels" in the PDF shows how many cumulative refs/visitors you need to reach the next tier.

📸 Save Weekly Snapshot

Freeze this week's data before importing next Monday's PDF.

Week Label

📈 Compare Two Weeks

Week A

vs Week B

📱 Member Phone Numbers

Upload CSV/Excel (Name | Phone) or paste below as Name : 91XXXXXXXXXX

📊

Upload CSV / Excel

Name in col A · Phone in col B

Paste Numbers

All Members

🎓 Training Schedule

Add trainings. They appear in WhatsApp messages for members who need them.

📋 Members Needing Training

📸 Step 0 — Save snapshot first!

Preserve this week's data before importing the new PDF.

Monday Workflow

1

Open Claude.ai and upload the PDF

Go to claude.ai → New chat → Click 📎 → Upload BNI PDF

2

Send this exact prompt to Claude

Extract all members from this BNI progress card PDF. Return ONLY a CSV with this exact header row and one member per line: name,score,ref_reco,ref_this_month,visitor_reco,visitor_this_month,tyfcb_reco,tyfcb_this_month,tstl_reco,tstl_this_month,trng_reco,trng_count,att_score,ontime_score,next_levels_ref,next_levels_visitor,next_levels_tyfcb,next_levels_trng,next_levels_score All values must be numbers (no commas in numbers). next_levels fields are comma-separated numbers as a quoted string. No extra text, no markdown, just raw CSV.

3

Upload the CSV here

Names & phones are never overwritten.

📊

Tap to Upload CSV / Excel

.csv · .xlsx · drag & drop

✅ File ready — choose how to import

📢 Group Broadcast Message

🔍

💾 Backup

📥 Download Backup

Save all members + phones + history + training. Do this every Monday after importing.

📤 Restore from Backup

Upload a previously downloaded backup. Replaces all current data.

📤

Upload Backup File

.json or .xlsx backup

⚙️ Settings

🔑 Change Password

Current Password

New Password

Confirm New Password

🎯 Chapter Go Green Target

Weekly goal percentage shown on dashboard.

%

Clear All Data

Delete all members and history. Download backup first!

📊 Data Summary

Loading…

🖨️ Print / PDF Report

Generate Go Green Report

📈 6-Month Monthly Score Trend

📊 Upload Chapter Traffic Lights

Upload the Chapter Traffic Lights Excel from BNI every month. It is a rolling 6-month window — each upload automatically replaces the previous data with the latest 6 months.

🔄 Rolling window — how it works:
June upload: Dec '25 → Jan '26 → Feb '26 → Mar '26 → Apr '26 → May '26
July upload: Jan '26 → Feb '26 → Mar '26 → Apr '26 → May '26 → Jun '26
August upload: Feb '26 → Mar '26 → Apr '26 → May '26 → Jun '26 → Jul '26
Each upload replaces previous trend — no manual cleanup needed.

Column format (auto-detected): S No | Name | Total | Dec 2025 | Jan 2026 | Feb 2026 | Mar 2026 | Apr 2026 | May 2026
Works with full month names (December 2025) or short (Dec '25) or just (Dec).

💡 Advanced Features & Suggestions

✅ Already in this app

🗺️ Full Journey Map — each card shows current → next level → next next → Max 100 with exact actions

⚡ Quick Win filter — filter/sort to see members who can reach next band with 1 easy action this week

📊 Scoring Guide tab — full scoring structure so members understand how each parameter works

📸 History Snapshots — save weekly data, compare any 2 weeks side by side

🖼️ Image Report Cards — generate PNG with score + upgrade path, share directly to WhatsApp

💬 Smart WhatsApp messages — individual messages include upgrade path + quick win + training info

📤 Group Broadcast — includes ⚡ Quick Wins section in group message

🎓 Training score filter — set min/max score for each training, import trainings via Excel

🚀 Suggested Future Features

📱 WhatsApp Auto-Sender Script (Python)

Export CSV → run Python script → sends messages to all members automatically. Currently you send one by one — the script can batch-send to all with one click.

📊 6-Month Trend Graph

Visual chart showing each member's score week by week. Helps identify who is consistently improving vs declining. Needs 4+ weeks of snapshots.

🏅 Achievement Badges

Auto-award badges: "Referral Champion", "Perfect Attendance", "TYFCB Star" etc. Show in cards and WA messages. Motivates members with recognition.

📋 Member Self-Check-in

QR code → members open a form on their phone → mark attendance, confirm visitor brought. Auto-updates the app. No manual entry needed.

📧 Auto Weekly Email Report

Every Monday, auto-email the full PDF report to chapter leadership. Needs a small server-side script (PHP/Python).

👥 Member Self-View Page

Unique link per member → they see only their own score, upgrade paths, upcoming training. No password needed, read-only view.

📆 Google Calendar Integration

Add training sessions directly to Google Calendar with one click. Members click "Add to Calendar" from the training card.

🔔 Reminder Scheduler

Set automated reminders: "3 days before training, send reminder to members who need training". Needs server/cron job.

📊 Training Excel Import Format

Use this column order when importing training sessions from Excel:

      Col A: Training Name (required)

      Col B: Date — YYYY-MM-DD format (required)

      Col C: Time — HH:MM format (e.g. 09:00)

      Col D: Place / Venue (required)

      Col E: Fee in ₹ (0 = free)

      Col F: Category (mandatory / optional / leadership / member-success / visitor-day / other)

      Col G: Min Score (0 = all members)

      Col H: Max Score (0 = no upper limit)

      Col I: Notes / Description

First row can be header (will be skipped automatically)

Add Member

Add Training