automated excel to track inventory r for a solar company
ITEM CODE
INVENTORY OVERVIEW
INITIAL STOCK
ITEM NAME
QUANTITY
HDS101
HDS102
555watt Solar Panel
585 watt Solar Panel
27
4
25
4
HDI201
10kw Inverter SRNE
4
3
HDB301
HDB302
HDB303
HDB304
HDB305
JINKO Battery
Mega Tank Battery
WECCO Battery
Durable Force Battery
BEN battery
-
-
HDR401
HDR402
HDR403
HDR404
HDR405
HDR406
Regular Battery (8 sets) rack
TUBULAR Battery (8 sets) Rack
Regular Battery (12 sets) Rack
JINKO Battery (7 sets) Rack
JINKO Battery (9 sets) Rack
Solar Rails
-
-
CSE101
CSE102
CSE103
CSE104
CSE105
CSE106
CSE107
Seanro SR-40C AC surge
Seanro SR-40C DC surge
Seanro SR-125A Solar Breaker
ABB C 32 Breaker
ABB C 63 Breaker
ABB C 20 Breaker
250A DC Breaker
-
-
REMAINING
STOCK
CSE108
CSE109
CSE110
CSE111
CSE112
Rotary Switch
3-phase AVS
20Amps Proton breaker
12 way Enclosure
9-way Enclosure
3
1
4
3
3
3
1
4
3
3
CSC101
CSC102
Earth Cable 4mm
Solar Cable 150mm
1
0
1
0
CSS101
CSS102
CSS103
CSS104
CSS105
CSS106
CSS107
CSS108
CSS109
CSS110
CSS111
CSS112
cable lug 50mm
Cable Tie
Busbar
Flex pipe
Insulation Tape
Enclamp Lots
Silicone
Flashband
Nails
Rails washer
Screw
Peg size 8
1
3
2
1
5
-
-
RECENT STOCK ADDITION
DATE
ITEM CODE
ITEM NAME
NO NEW ADDITION
CRITICAL STORE LEVELS
QUANTITY
RECEIVED
ITEM CODE
HDS102
HDI201
HDB302
HDB303
HDB304
HDR401
HDR402
HDR403
HDR404
HDR405
CSE101
CSE102
CSE103
CSE104
CSE105
CSE106
CSE107
CSE108
CSE109
CSE110
CSE111
CSE112
CSC101
CSC102
CSC104
CSS101
ITEM NAME
585 watt Solar Panel
10kw Inverter SRNE
Mega Tank Battery
WECCO Battery
Durable Force Battery
Regular Battery (8 sets) rack
TUBULAR Battery (8 sets) Rack
Regular Battery (12 sets) Rack
JINKO Battery (7 sets) Rack
JINKO Battery (9 sets) Rack
Seanro SR-40C AC surge
Seanro SR-40C DC surge
Seanro SR-125A Solar Breaker
ABB C 32 Breaker
ABB C 63 Breaker
ABB C 20 Breaker
250A DC Breaker
Rotary Switch
3-phase AVS
20Amps Proton breaker
12 way Enclosure
9-way Enclosure
Earth Cable 4mm
Solar Cable 150mm
Cable 12mtrs 50mm
cable lug 50mm
REMAINING
STOCK-
CSS102
CSS103
CSS104
CSS105
CSS106
CSS108
CSS109
CSS112
Cable Tie
Busbar
Flex pipe
Insulation Tape
Enclamp Lots
Flashband
Nails
Peg size 8
-