HSN code

strip- 72269990
seam les tube - 73049119
seal - 40169390
nylon- 4008
plastic tube -3923

EXCEL

selcting record CTRL+shift down arrow left right up arror
writing same value in all selcted cell , selct cell pres contol on top or bottom cell write value press ctrl + enter
formula IF("condition","va;ue on true ",value on false
formula sum (range1.....range 32)
formula sumif(range,"criteria" , sum range)
formula left (cell address,left count eg 1,2,3 )
formula right (cell address,right count eg 1,2,3 )
formul format painter (select cell click format painter and piant icon apper the apply on which cell to format, double click to lock format painter and escape key to excape to exist format painter)
formula vlookup(search string , range, column to look , true for near match flase for excat match) search column whitch which match be first coloumn as it is search from left
formula percentage write ce11 x/cell y and click % incon in home tab
formula Max(range 1......range255)
formula Min(range 1......range255)
formula Average(range 1......range30)
formula AverageA(range 1......range30) also calculate blank or text cell
formula LARGE(G13:G16,1) top largest LARGE(G13:G16,2) second largest and so on
formula SMALL(G13:G16,1) top lowest SMALL (G13:G16,2) second lowest and so on
formula RANK (number to rank, list of numbers, rank order 0 larger 1 small no )
formula CONCATENATE(I21,I22,I23) CONCATENATE(text1…text30)
formula LEN("kamlendra")
formula upper case UPPER(I21 or text )
formula lower case LOWER (I21 or text )
formula make first letter capital PROPER (I21 or text )
formula FIND look for specific letter in text . letter found postion shown as number . if text contain more than one refernce ,firdt occurance us used or provide start point
FIND (letter to look for , text look inside , start position)
formula =REPLACE(E1,1,3,"gal") REPLACE("old text ",start postion,no of caharcter,"new text") if cell E conatin kamlendra then o/p is gallendra
formula =FREQUENCY(E2:E16 data array ,I2:I5 bin array ) for curly brace ctrl+shift +enter

seal 0814 - 2020141-0009
seal 3016- 2020141-0010
seal 47730 -2020141-0020
seal 202618- 2020141-0012
seal 1214- 1020141-0001

VENDOR
ARK 1345
GANDHI 0283
OMEX 00532
NEEKES 01449
PERFECT 00422
RKEW 0076
PYRAMID 00115
HOWRAH FABRICATOR
AND 1388
AVA 1461
SMP 00983
MOTHER 00453
MIKRON 00143
VARUN 01534
TCE 01030
UTURN 01196
EMERY 01523
MERCURY 01175
castor wheel 00164
LUBRO 01335
BALAJI RUBBER 01223
APPLIED 0063
SREE 00708
NTC 00495
SAGAR STEEL 01584
BLUE OCEAN 01194
MURLIDHAR TRADER 01530
COMPRESSOR MINING 01422
SK ENGINEERING 01323
ASHFA 00167
srs 00994
acla
kausiki 01122
sn sdales 01181
keyance 01472
misumi 01474
victor corporation 00838
indian thermal 00954
computer vision 00856
cumi 00150
minakshi 00457
ram bhagat 00615
jyoti furniture 01068
sri ram trading01435
deepak timber 00190
nobel engineering001377
solar daimond 01249
FIBRO 01198
khalsa 01167
technotrade 00800
sushil magnet 00736
indian precision 00344
hitesh metal 01409
saket 00779
golden precision 00286
garuda 01522
hi tech lub 01594
raghav 00606
kennametal 00396
austenetic 00166
Vr sons – 0837
MASTER TOOLS – 0308
PARAMOUNT -0735
FIZA- 01589
ABHYUT- 01184
MIM- 01460
SAINEST-00773
ADVANCE COOLING – 0050
ANJALI VIBRO TECH – 01418
ELSCINT AUTOMATION- 01337
INFINITY TOOLS- 01603
TRIDAC SOLUTION-01463
MACHINO SPARE- 01157
AMBER TURNIUNG – 1029
BALAJI RUBBER- 0727
ROOP PLOYMER- 01223
SIMPLEX POLYMER – 0667
SANGITA ENTERPRISE – 00719
FIBRO – 01198
GLOBAL SOLUTION – 01568
VIBRANT BEARING – 01577
LHP- 01119
MANGLAM- 00455
AMRIT ENTERPISE – 1089
SWATI ELECTRONICS – 00814
SOHAIL- 00687
ORIENTAL – 00533
DR MULLER – 0204
New Parvati
Ntc
Jivanlal
Calcutta store
Fibre cham
Lohia trader
Suprapha
Supreme
Afc
Ranchi gas
dalal plastics
indian thermal
prabodh nirman

arkengineers001@gmail.com;rege@gandhitubes.com; mdshaban2109@gmail.com; neekesh.n@gmail.com; perfectengineering.2007@rediffmail.com; rkew2003@rediffmail.com; pyramid_industries@rediffmail.com; andengineering2013@gmail.com; avaenterprises17@gmail.com; sm_packers@yahoo.com; mother_trading@rediffmail.com; mikron@toliacarbides.com; malay@toliacarbides.com; varunindtools@gmail.com; fibresandchemicals09@gmail.com; uturnconcepts@gmail.com; solar_industries@hotmail.com; mercurycommercialco@gmail.com; cwtbom@gmail.com; lubroneeraj@gmail.com; mohnish.chitalia@balaji-rubber.in; appliedsolutions.jsr@gmail.com; sssuppliersrnc@yahoo.com; nationaltradingcorpn@gmail.com; blueoceanoffshore@gmail.com; VIPULT53@GMAIL.COM; compressor.mining@gmail.com; skengineering303@gmail.com; ashfa91@hotmail.com; surendra.srsp@gmail.com; kaushikiautomobiles_ioc@rediffmail.com; sn.sales123@gmail.com; victorcorporationindia@yahoo.co.in; info@indianthermalengineering.com; computervision14@gmail.com; banerjeer@cumi.murugappa.com; minakshiadvertisers@gmail.com; noble_engg@yahoo.com; solardiamondtools@gmail.com; akgescon@rediffmail.com; jayendra@fibro-india.com; kicchucks@gmail.com; kicchucks@yahoo.com; techno_trade2@rediffmail.com; sushil_magnetic@yahoo.co.in; ipe@narsipurgroup.com; hiteshmetal@yahoo.com; saket_services@yahoo.com; office@golden-india.com; Subrata.Kabiraj@garudapower.com; samiran.mahapatra@garudapower.com; hitechlub.in2017@gmail.com; shalavtibrewal@yahoo.com; Debanjan.Ghosh@kennametal.com; office@asplwires.com; vrsonsengineerspl@gmail.com; dsilva_alwin@hotmail.com; paramount.bbsr@gmail.com; fizaengg983@gmail.com; sales@abhyut.com ; abhyut.engg@gmail.com; motion@tckmim.com; marketing@sainest.com;info@sainest.com; sales@advancecooling.com; anjalivibrotech@gmail.com; sales@elscintautomation.com; girish@infinitytoolings.in; machinospares@hotmail.com; amberturning@yahoo.in; marketing.pune@rooppolymers.com; mail@simplexpolymers.com; sangitaenterprise11@gmail.com; jayendra@fibro-india.com; vbip09@gmail.com; mishramech@yahoo.com; sn@mangalamlubricants.com; michael@mangalamlubricants.com; orientrahul@gmail.com; jivancorp@yahoo.co.in; lohia.traders@yahoo.in; jsrsales@suprabha.com; mktg@vnssteel.com;info@vnssteel.com; mktg@supremesteels.com; ab.patel@afcelastomers.com; despatch@afcelastomers.com; afcelastomers@gmail.com; murtaza@dalalplastics.com; marketing@prabodhnirman.com; crm.tech@ashutoshrubber.com; manojaaraya.singh@gmail.com; smengineering.ms12@gmail.com; associated.controls@gmail.com; service@nashrobotics.com; dularsteelproducts@gmail.com;

Gandhi
PO2100062 dated 09/04/21 June 15
SCM415 10.00IDX1.95MM KBK 1000 arrived 973 meter on 23/06/21
ST45 BK 12IDX1.95 500 arrived 500.11 on 23/06/21
ST45 BK 21.15IDX1.95 3000 arrived 2972 on 23/06/21
PO2100243 dated 22/05/21 July 10
ST45 BK 12IDX1.95 1000 in transit 23 july
aug 10
SCM415 10.00IDX1.95MM KBK 1000
Sept 10
ST45 BK 12IDX1.95 500
oct 10
ST45 BK 21.15IDX1.95 3000
nov 10
ST45 BK 21.15IDX1.95 3000
dec 10
ST45 BK 21.15IDX1.95 4000

Sainest :
PO2100063 June 15
ST35 28ODMMX1.00 MM KZK 500 picked up 29 june 500.230
ST35 STEEL TUBE , OD 33 X 1.2 MM THICK. 1000 picked up 29 june 1000.960
PO2100244 July 10
ST35 28ODMMX1.00 MM KZK 1000 in transit 23 july
ST35 24OD X 1.2 mm THICK 1000 dispatch by 26 july
August 10
ST35 24OD X 1.2 mm THICK 1000 dispatch by 26 july
ST35 STEEL TUBE , OD 33 X 1.2 MM THICK. 1000 in transit 23 july
Sept 10
ST35 STEEL TUBE , OD 33 X 1.2 MM THICK. 1000
Oct 10 ST35 24OD X 1.2 mm THICK 1000
ST35 STEEL TUBE , OD 33 X 1.2 MM THICK. 1000

vns:
po2100933 dt . 13/10/21.
0.6x15.30 500kg required 30 nov 21
0.75x13.60 2000 kf required 16 oct 2021
po2101027 dt 05 nov 21 rd 15 jan 21
9.45x0.75 1500kg
13.45x0.75 3000 kg
6.40x0.75 1000 kg
po2101180 dt 08 dec 21 required 15 feb 2021
0.60x8.55 1000kg
0.88x17.7 1000 kg
13.45x0.75 3000 kg

Supplier above 50 lac turnpver 10 crore
Supreme ,sainest , gandhi , nrb , mim , dalal, afc, roop , vns, cdw, miniature , dular,
kawaity , victor, Indian thermal, mikron, kennameat, varun, dular , miniature , omex
Sangita, solar industries , fibre chem , jivanlal , ashfa , techno trade
, shyam sree .lubroSm packer , srs,
mktg@vnssteel.com; info@vnssteel.com; Mktg SHPL ; 'Office
- SK' ; MIM PLASTICS ; To: 'To:
'Sourabh (Marketing)'' ; Pradhuman/RPL/PUN/MKT
; Prashant Rege ;
Jrk ; Debanjan Ghosh
; mikron@toliacarbides.com;
rajan@dalalplastics.com; murtaza@dalalplastics.com; afcelastomers@gmail.com;
Kwality Ball Company ; Sumit Maheshwari
; omkar ; mdshaban2109@gmail.com; JATIN DOSHI ;
Notification Team ; Reena Lodaya
; JIVANLAL CORPORATION
; hitesh mehta ;
techno_trade2@rediffmail.com; Ashok Paul ; Rajib
Banerjee -Manager -MKTG -ABR -Kolkatta -CUMI
; Shyam shree suppliers
; LUBRO AIR ENGINEERS PVT LTD 9204734373
; sm_packers@yahoo.com; surendra.srsp@gmail.com

AMC
Xerox: cont 190086 dated 03/12/19 valid 2024 or 05 lac print
Cont 200063 20kva valid 21/10/23 ( 60134 01/11/20 to 31/10/21, 64343 01/11/21/ to
31/10/2022 ,68847 01/11/2022 to 31/10/23) ) payment half yearly
Ac 13 nos cont 200034 valid 30/06/21 payment quterly .
Compressor 03 nos cont 200081 valid 29/12/2021 payment half yearly
Dg cont 200066 6/11/21 payment two installment start and after six month
Cont 200044 6 kva 10 kva 31/07/2021
Ro plant membrane change 01/08/20 19000 next 01/08/21 and vessel media change
004/06/21 14000 Next after 01 year
cctv camera valid up 30/10/21 18 camra in vga dvr 30 camera in usb dvr

The following strip dispatched on 19/03/21 by msc container MEDU2603367
0.90x90 6405 kg
1.13x81 2954 kg
0.95x82 2921 kg
The following strip dispatched on 19/03/21 by msc container FSCU3974918
1.13X67 3641 KG
1.13X114 3943 KG
0.95X82 2843 KG
The following strip dispatched on 19/03/21 by msc container TEMU4465038
0.95X67 2143 KG
0.95X67 3610 KG
0.90X90 4768 KG
0.85X55 3398 KG
The following strip dispatched on 04/04/21 by msc container GLDU5087621
0.90x90 1615 kg
1.13x67 3558 kg
1.13x89 6534 kg
The following strip dispatched on 04/04/21 by msc container FTAU1444885
0.90x90 3261 kg
0.88x52 1771 kg
0.88x52 3558 kg
0.85x76 3504 kg
The following strip dispatched on 11/04/21 by msc container MEDU6198940
0.95x67 2293 kg po2001016
0.95x102 3852 kg po2000722
1.13x89 3186 kg po2000722
The following strip dispatched on 11/04/21 by msc container MEDU1045489
1.15x96 4247 kg po2001016
1.13x89 5312 kg po2000722
The following strip dispatched on 11/04/21 by msc container FCGU2260329
1.15x96 5222 kg po2001016 0.95x102 3327 kg po2000722
1.15x96 1051 kg po201016
The following strip dispatched on 20/04/21 by msc container TRHU2147319
1.13x67 2287 kg po200722
0.95x67 5777 kg po20001016
0.95x102 3270 kg po2001016
The following strip dispatched on 27/04/21 by msc container MSCU3585338
0.95x82 1513 kg PO1016
0.95x67 3421 kg PO722
0.95x67 5875 kg PO722
0.95x102 1754 kg PO1016
The following strip dispatched on 27/04/21 by msc container TGBU2596722
1.13x89 1539 kg po1016
1.13x67 5499 k g po1016
0.95x53 3866 kg po1016
0.95x82 1481 kg po1016
Material arrived till above in factory 08/06/21
The following strip dispatched on 18/05/21 by NAGOYA EXPRESS GLDU5636974 eta
PORT 18/06/2021 in trasit from Mumbai on 24/06/21
0.90x90 4481 kg
0.85x55 3503 kg
The following strip dispatched on 18/05/21 by NAGOYA EXPRESS TCKU1751075 eta
port 18/06/2021 in trasit form Mumbai on 24/06/21
1.13x89 4372 kg
1.13x67 3382 kg
1.13x114 2904 kg
The following strip dispatched on 21/05/21 by ONE HENERY HUDSON container
UACU4019104 eta port 26/06/2021
0.90X90 2094 KG
0.95X67 3392 KG
0.85X55 3504 KG
1.13X114 2086 KG
The following strip dispatched on 21/05/21 by ONE HENERY HUDSON container
TRHU1909596 ESTIMATED ARRIVAL AT PORT 26/06/2021
1.15X96 10489 KG
The following strip dispatched on 28/05/21 by kyoto express hapag Lloyd
HLXU3203549 estimated arrival at port 02/07/2021
R0.90X90 3137 KG
1.13X67 4631 KG
1.13X81 2782 KG
1.13X67 1139 KG
The following strip dispatched on 28/05/21 by kyoto express hapag Lloyd
UETU2772047 estimated arrival at port 02/07/2021
1.13X67 2792 KG
1.13X89 3080 KG
1.13X89 1526 KG
1.13X67 2211 KG
1.13X67 1157 KG
The following strip dispatched on 25/06/21 by hapag Lloyd TRLU8898779
1.15X96 5084 KG
1.13X67 5738 KG
0.95X67 1346 KG
The following strip dispatched on 25/06/21 by hapag Lloyd CPSU1806251
0.95X67 4632 KG
0.95X67 3257 KG
RST 0.95X53 3648 KG
The following strip dispatched on 03/07/21 by hapag Lloyd container HLXU3443452
1.15x96 4053 kg PO1421
1.13x78 2020 kg po1251
1.13x67 1153 kg po1016
1.13x81 2597 kg Po1016
The following strip dispatched on 03/07/21 by hapag Lloyd container HAMU1053313
1.15x96 5043 kg
1.15x96 1012 kg
The following strip dispatched on 16/07/21 by hapag Lloyd nagoya express container UACU3466659
rst 443 0.95x82 2998 kg po1421
rst 443 0.90x90 4899 kg po1251
0.95x637 5800 kg po1251
The following strip dispatched on 29 july by msc MSCU6865902 container eta 10 SEPT
0.90X90 6565 KG
1.130X78 3028 KG
1.13X78 3324 KG
The following strip dispatched on 29 july by msc BMOU2451258 container eta 10 SEPT
0.95X82 3104 KG
0.85X76 2881 KG
1.05X92 2175 KG
1.15X74 3369 KG
The following strip dispatched on 13/08 by HAPAG FBIU0448694 container
0.85X68 3827 KG
1.13X67 2778 KG
1.13X89 3168 KG