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
⚡ 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 ₹
Total Price ₹
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...
Period
→
Filter
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
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
Actions
Material Group
Specification
UOM
Per Module
Material Code
Stock Qty
Mapped Item(s)
Used By
Modules Possible
Watt (W)
Kilowatt (kW)
MW / GW
🔗 Map
Module Type
Material Group
Specification
UOM
Per Module
Module Wp
Material Code
Mapped Item(s)
Stock Qty
Modules Possible
Power Capacity
🔗 Map
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
✗
📥Pending / Open Purchase Orders. Upload Purchase Record files (reads the “BOM” sheet, open lines only) and/or click 📦 From Stock Statement to list every item (no-PO items show PO No = 0). MSL & Line come from the Store Stock Statement — drop it in the green MSL Source box above (the Planning Report has no MSL column). Every cell is editable; add / delete rows & columns, filter, sort and export.
📄 Purchase Record — File 1
Click or drop an .xlsx (reads the “BOM” sheet)
📄 Purchase Record — File 2 (optional)
Click or drop a second .xlsx
📊 MSL Source — Store Stock Statement
Click or drop the Statement (not the Report) — reads MSL & Line per item to fill the MSL column
Open & Pending PO Lines
Upload a Purchase Record file above to list open / pending purchase orders (from its “BOM” sheet).
🔐
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
Pending PO
MSL Panel
Vendor Pay
Costing Deploy
Loading…
⚠️
Confirm Deletion
Are you sure?
🗑️ Deletion Log
🔐 Vendor Sheet Login
Vendor data is restricted. Login to view and edit.