Consumption · Planning vs Stock · Cell INV Pricing
Module Configuration — Qty & Watt Peak
⚡ Power Generation Potential
💰 Module Material Cost
$1 = ₹
¥1 = ₹
⇄Three ways to calculate: (1) Set Module Qty → all rows auto-calculate. (2) Type Required Qty → back-calculates Module Qty + Power. (3) Type Generation value + unit → back-calculates Module Qty + Required Qty. Each row is independent. Click ↺ to reset any row.
Material Details
Per Module Consumption
⇄ Calculated Totals (editable either way)
💰 Pricing (Per Module)
⚡ Generation (Editable — W/KW/MW/GW)
Actions
Module Type
Sr.
Material Group
Technical Specifications
UOM
Qty / Module
Wastage %
Consumption / Module
Module Qty ↕
Required Qty ✎
Price Qty (UOM)
Unit Price (Cur)
Cost / Mod ₹
Generation ✏ (Unit Selectable)
Total Power
✎ / ✗
1. Upload Production Planning Sheet
Drop Planning Sheet Here
Excel with Customer Name, OA No, Module Wp, daily planned quantities
2. Upload Store Stock Report
Drop Store Stock Report Here
Excel with Item Description and Quantity columns
💾Previous analysis loaded from saved data. Upload new files to replace.
⏳ Analyzing files, mapping materials to stock, and calculating requirements...
📅Planning Period:
🔍Filter By:
Customer-wise Planning Summary
All Orders Detail
Customer Name
OA No / Line
Production Line
Module Matched
Module Wp
Pending Planned Qty
Total Power
Planned Module Details & Power Output
Consolidated Material Requirements vs Stock
🔗Smart Stock Mapping: Materials are auto-matched to stock items using keywords, dimensions & specs. Click the 🔗 button on any row to manually override the mapping. Click the ❌ button to discard materials you don't need.
Material Details
Requirement
Stock Analysis
Actions
Material Group
Technical Specifications
UOM
Per Module
Used By
Total Modules
Required Qty
Mapped Stock Item(s)
Available
Shortage / Surplus
Discard / Map
Detailed Material Breakdown per Module Type
Module Type
Material Group
Technical Specifications
UOM
Qty / Module
Wastage %
Consumption
Module Qty
Required Qty
Available Stock
Shortage (Buy)
Status
Global Pricing Controls — Editing any value overwrites all rows
Total Amount GLOBAL
$
Blended $/Wp GLOBAL
$
Avg $/Cell GLOBAL
$
⇄Every value is editable & calculates the rest: Cell Size + Eff% auto-fill Wp/Cell. Edit Total Wp, $/Wp, $/Cell or Amount on any row to back-calculate the others. Global controls above overwrite all row pricing at once.
Cell Pricing — Amount & Wp Wise
Cell Specifications
💰 Pricing (Editable Both Ways)
Actions
#
Cell Size
Eff %
Wp / Cell
Qty
Total Wp
$ / Wp
$ / Cell
Amount
✗
🔐
Restricted Access
Vendor data is confidential and requires authorized login to access. Please sign in with your credentials.
🔓 Editing as —
Ready
📋 Activity Log
Loading activity logs…
👥 User Management
#
Name
Password
Actions
Loading…
⚠️
Confirm Deletion
Are you sure?
🗑️ Deletion Log
🔐 Vendor Sheet Login
Vendor data is restricted. Login to view and edit.