📋
RMC Search
Connecting…

📋 RMC Search

Paste your Google Sheets published CSV URL to connect.

Google Sheets Published CSV URL
Loading Data…
Connecting to Google Sheets

⚠ Connection Failed

Could not load data.

✓ Map Your Columns

Match sheet column names to each field. Saved automatically — one time only.

🔍
JMR No · Pour Card · Person Name · Partial match OK
→

Data refreshed

0 records ·

📊 Summary & Analytics

▼
Yesterday
—
m³
This Week
—
m³
This Month
—
m³
Area
Grade
Person

🗂 Multi-Area Pour Cards

Pour Cards jo ek se zyada areas mein use hue

—
Pour Cards
—
Avg Areas
—
Total m³
🔍

🕳 Gap Analysis

Missing JMR / Pour Card numbers in sequence

—
Missing
—
Existing
—
Prefixes
0
Pour Cards
0
Qty Variants
0
Total Records

🔎 360° View

Complete details — areas, persons, timeline

🔍
🔎

Pour Card ya JMR No daalo

Exact ya partial — live search hoga

🧪 Testing Scheduler

Grade-wise cube sampling — daily forecast & range summary

📅 Daily Forecast

7-day & 28-day cube tests due on the selected date, based on past pours

📊 Date Range Summary

Total consumption & total cube sets required over a period

Sampling rule applied: 1 set (3 cubes) per grade per day for consumption ≤ 50 m³; +1 set per additional 50 m³ or part thereof. Each set yields cubes tested at both 7 days & 28 days.
Reference: IS 456:2000 Cl 15 / Table 14 — Frequency of Sampling (full graduated frequency is 1/2/3/4 samples for 1–5/6–15/16–30/31–50 m³ then +1 per additional 50 m³; the rule above is a simplified site-level variant). Cube testing per IS 516 (Part 1/Sec 1):2021; sampling procedure per IS 1199:1959.

🧱 Material Consumption

Mix design database, cement type timeline & auto-calculated material usage

🏷️ Cement Type Timeline

Per grade — each grade can use a different (or simultaneous) cement type

▾

📐 Mix Design Database

Grade + Cement Type + Effective Date → kg per m³ proportions

▾

🧮 Material Consumption

Auto-calculated from dispatch data + mix design

📊 Charts

Area, Grade, Date & Category-wise visual reports

📍 Area-wise
🏗️ Grade-wise
🧱 FILLCRETE / PCC / RCC
📅 Date-wise
Category rule: Grade name contains "FILLCRETE" → Fillcrete. Else Grade number ≤ 20 → PCC. Grade number > 20 → RCC.
Note: If Area/Grade/Date count is large, charts group smaller entries into "Others" for readability — full breakdown always available in Search/Multi-Area tabs.
📲 Install RMC Search App
1️⃣  Tap ⋮ three-dot menu in Chrome (top right)
2️⃣  Tap "Install app" or "Add to Home screen"
3️⃣  Tap "Install" → App opens like native app ✅