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
Material Code
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
Material Code
Qty / Module
Wastage %
Consumption
Module Qty
Required Qty
Available Stock
Shortage (Buy)
Status
Customer-wise Material Requirements & Stock Mapping
🔗Customer Stock Mapping: Map specific stock items to each customer. If not mapped, the global/default mapping is used. Click 🔗 Map on any material to assign specific stock items for that customer.
⚡Stock Capacity: Shows how many modules and how much power (W/kW/MW/GW) your current stock can support for each material. The bottleneck material limits actual production capacity.
Material
Stock
⚡ Production Capacity from Stock
Material Group
Specification
UOM
Per Module
Material Code
Stock Qty
Mapped Item(s)
Modules Possible
Watt (W)
Kilowatt (kW)
MW / GW
Module Type
Material Group
Specification
UOM
Per Module
Module Wp
Material Code
Stock Qty
Modules Possible
Power Capacity
Stock Item Description
Material Code
Category
UOM
Stock Qty
Mapped To Material
Consumption/Module
Modules Possible
Power Capacity
🏭 Module Type Based Stock Mapping — Universal Pre-filter
🏭Module Type Mapping: Map specific stock items per module type (e.g. which solar cells are for G12R vs M10R). This acts as a universal pre-filter — only items mapped here will appear in Customer Materials mapping. Auto-populated from smart mapping on first use.
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
Total Users
0
Active Accounts
0
Search Results
0
Add New User
#
User
Password
Actions
Loading…
Control which tabs each user can access. Changes take effect on their next login. Only the admin (31122000) can modify permissions.
User
Calculator
Calc Deploy
Planning View
Planning Edit
Plan Deploy
Cell INV
Vendor View
Vendor Edit
3D Explorer
Loading…
⚠️
Confirm Deletion
Are you sure?
🗑️ Deletion Log
🔐 Vendor Sheet Login
Vendor data is restricted. Login to view and edit.