OCL Agribusiness Intelligence Platform

Owo Youth Farmers Coop · ONDO/COOP/2025/0847

Total Members

0

—

Finance Eligible

0

—

Total Farmland (Ha)

0

—

Avg Credit Score

0

—

Recent Activity

Active Alerts

Today's Data Collection SequenceLog in order

✓

STEP 1

Weather Log

✓

STEP 2

Market Prices

◑

STEP 3

Soil & Inputs

○

STEP 4

Farm Activity

○

STEP 5

Financials

🔍

Member ID	Full Name	Gender	LGA · State	Ha	Crops	Score	KYC	Finance	Status

◉ Identity & KYC

Full Name *

Required

Date of Birth *

Required

Gender *

Required

Marital Status

Dependents

Education

Phone Primary *

Required

Phone Secondary

Email

ID Type *

Required

ID Number *

Required

BVN

NIN

Residential Address *

Required

LGA *

Required

State *

Required

◧ Farm Information

Total Farmland Ha *

Required

Number of Plots

Plot Latitude 🌐

Plot Longitude 🌐

Crops Cultivated *

Required

Farming Experience (Yrs)

Primary Occupation

Annual Income — Farming ₦

Other Income ₦

◲ Banking & Cooperative

Bank Name

Account Number

Existing Loans

Loan Outstanding ₦

Repayment History

Coop Shares (Units)

Share Value ₦

Coop Savings ₦

◎ Guarantors & Next of Kin

Next of Kin Name

Next of Kin Phone

Guarantor 1 Name

Guarantor 1 Member ID

Guarantor 2 Name

Guarantor 2 Member ID

Score Formula

Repayment History

Good → 25
Fair → 15
No history → 20
Poor → 10

Experience & Status

10+ yrs → 15
5–9 yrs → 10
<5 yrs → 5
Active → 10

Financial Standing

No loans → 15
Both guarantors → 10
Savings >₦100k → 10
Income (max 15)

◎ Register Stakeholder

Stakeholder Registry

Organisation	Type	Contact	Phone	LGA	Products	Contract
No stakeholders yet.

⛅

Owo · Ondo

29°C

Humidity 74% · Rainfall 0mm

LOW Risk

🌧

Akure · Ondo

26°C

Humidity 88% · Rainfall 18mm

MONITOR

☀️

Ile-Ife · Osun

33°C

Humidity 58% · Rainfall 0mm

Drought Watch

◌ Log Weather Entry

Weather Log

Date	LGA	Condition	Max°C	Min°C	Rain mm	Humidity%	Flood Risk	Source
No entries yet.

◧ Log Farm Activity

Farm Activity Log

Date	Member	Activity	Crop	Area Ha	Cost ₦	Follow-up
No entries yet.

◪ Record Harvest & Quality

Harvest Records

Date	Member	Crop	Gross kg	Net kg	Grade	₦/kg	Buyer
No records yet.

◫ Log Input / Inventory

Input Log

Date	Member	Type	Input	Qty	Unit	Total Cost ₦	Crop
No entries yet.

◷ Log Training / Extension

Training Records

Date	Member	Topic	Trainer	Type	Hours	Score	Certified
No records yet.

◳ Register Equipment / Asset

Asset Register

Member	Asset	Type	Purchase Cost ₦	Current Value ₦	Condition	Service Due	Insured
No assets yet.

◲ Log Product Traceability / CoC

Traceability Log

Batch ID	Member	Crop	Qty kg	Grade	Destination	CoC Status
No batches yet.

GINGER/KG ▲ ₦2,800YAM/TUBER ▼ ₦1,200CASSAVA/KG ▲ ₦380PEPPER/KG ▲ ₦4,500TOMATO/KG ▼ ₦1,800

◈ Log Market Price

Price Log

Date	Market	Commodity	Farmgate ₦	Wholesale ₦	Retail ₦	Demand
No entries yet.

◐ Log Financial Transaction

Financial Log

Date	Member	Type	Category	Amount ₦	Related To	Method
No entries yet.

Income vs Expense

Harvest Summary

Price Trend AnalysisCalculated from Market Intelligence log

Commodity	Latest Farmgate ₦	Avg 7-day ₦	Avg 30-day ₦	Min Recorded	Max Recorded	Entries	Trend

Annual Income by Member

Credit Score Distribution

Crop Portfolio

Alerts & Flags

◉ Create New User Account

All User Accounts

⚙ Google Sheet Connection

ℹ

Connect to your Google Sheet by pasting your Apps Script Web App URL below. See the Apps Script file delivered alongside this platform for setup instructions.

1

Open Sheet → Extensions → Apps Script — Delete existing code, paste the ocl_google_apps_script.js file, save.

2

Deploy → New Deployment → Web App — Execute as: Me, Access: Anyone. Copy the Web App URL.

3

Paste the /exec URL below and click Save & Connect. Make sure to copy the /exec URL (not /dev — /dev requires Google login). Platform switches from Demo to Live mode immediately. Then click Test Connection to verify.

Apps Script Web App URL

⚙ User Settings

Your Name

Your Role