{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Welcome","Veh_Updt.","Master Codes","Sample EWB Vehicle Updt"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":69,"n_cols":7,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Ewaybill  Vehicle Number Updation"]
[null,"Column Name","Type","Description","Column Value","Mandatory"]
[null,"E-Way Bill No","Number(12)","Ewaybill Number generated",123456789898,"Yes"]
[null,"Trans Mode","Text(5)","Mode of Transportation","Refer Master Values","Yes"]
[null,"Vehicle Type","Text(10)","Vehicle Type","Regular                                     ODC","Conditional","Mandatory If Trans Mode is Road"]
[null,"Vehicle No","Text(15)","Vehicle Number","KA12KA1234          OR\nKA12K1234             OR   \nKA123456                OR\nKAR1234                  OR              KA123K1234           OR \nKA12KAR1234        OR   DFXXXXXX               OR         TRXXXXXX               OR           BPXXXXXX               OR  NPXXXXXX","Conditional","Mandatory if Mode of transportation is Road and TransId is not entered "]
[null,"Trans Doc No","Text(15)","Transporter Document Number",23456,"Conditional","Mandatory if Trans Mode is Rail/Air/Ship"]
[null,"Trans Doc Date","Text(10)","Transporter Doc Date","2017-07-07","Conditional","Mandatory if Trans Mode is  Rail/Air/Ship"]
[null,"From Place","Text(25)","Start Place of  Vehicle movement","BANGALORE","Yes"]
[null,"From State","Text(25)","Start  State of Vehicle movement","Refer Master Codes","No"]
[null,"Reason for Updation","Text(25)","Reason for vehicle No. Updation","Refer Master Codes","Yes"]
[null,"Remarks","Text(50)","Remarks",null,"Conditional","Mandatory if  Reason for Updation is Others"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"***"]

{"sheet":"Veh_Updt.","index":1,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Updation of Part-B/Vehicle details of E-way bills"]
["GSTIN: *",null,"Name:",null,"Place:",null,"Pin Code: *",null,"State:"]
["E-Way Bill No *","Trans Mode *","Vehicle Type (Ignore only if Part:B has already entered)","Vehicle No","Trans Doc No","Trans Doc Date","From Place *","From State","Reason for Updation *","Remarks"]

{"sheet":"Master Codes","index":2,"n_rows":85,"n_cols":18,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Column Name ","Column Value"]
["From State","ANDAMAN AND NICOBAR"]
[null,"ANDHRA PRADESH"]
[null,"ARUNACHAL PRADESH"]
[null,"ASSAM",null,null,null,null,null,null,null,null,null,null,"ST_NAME","STATE_NO",null,null,"BAGS                     ","BGS"]
[null,"BIHAR",null,null,null,null,null,null,null,null,null,null,"ANDAMAN AND NICOBAR",35,null,null,"BUNDLES                  ","BND"]
[null,"CHANDIGARH",null,null,null,null,null,null,null,null,null,null,"ANDHRA PRADESH",37,null,null,"BOXES                    ","BOX"]
[null,"CHHATTISGARH",null,null,null,null,null,null,"Supply",null,null,null,"ARUNACHAL PRADESH",12,null,null,"CENTI METERS             ","CMS"]
[null,"DADRA  AND NAGAR HAVELI",null,null,null,null,null,null,"Import",null,null,null,"ASSAM",18,null,null,"DOZENS                   ","DZN"]
[null,"DELHI",null,null,null,null,null,null,"SKD/CKD",null,null,null,"BIHAR",10,null,null,"GRAMS                    ","GMS"]
[null,"GOA",null,null,null,null,null,null,"Job work Returns",null,null,null,"CHANDIGARH",4,null,null,"HUNDRED KILOMETERS       ","HKM"]
[null,"GUJARAT",null,null,null,null,null,null,"Sales Return",null,null,null,"CHHATTISGARH",22,null,null,"HUNDRED NUMBERS/UNITS    ","HNO"]
[null,"HARYANA",null,null,null,null,null,null,"Sales Return",null,null,null,"DADRA AND NAGAR HAVELI",26,null,null,"HUNDRED NUMBERS/UNITS    ","HNO"]
[null,"HIMACHAL PRADESH",null,null,null,null,null,null,"Others",null,null,null,"DELHI",7,null,null,"KILO METERS              ","KMS"]
[null,"JAMMU AND KASHMIR",null,null,null,null,null,null,null,null,null,null,"GOA",30,null,null,"LITRES                   ","LTS"]
[null,"JHARKHAND",null,null,null,null,null,null,null,null,null,null,"GUJARAT",24,null,null,"MILLI LITRES             ","MLS"]
[null,"KARNATAKA",null,null,null,null,null,null,null,null,null,null,"HARYANA",6,null,null,"METERS                   ","MTR"]
[null,"KERALA",null,null,null,null,null,null,null,null,null,null,"HIMACHAL PRADESH",2,null,null,"METRIC TONNES            ","MTS"]
[null,"LAKSHADWEEP",null,null,null,null,null,null,null,null,null,null,"JAMMU AND KASHMIR",1,null,null,"NUMBERS/UNITS            ","NOS"]
[null,"LADAKH",null,null,null,null,null,null,null,null,null,null,"JHARKHAND",20,null,null,"PAIRS                    ","PAR"]
[null,"MADHYA PRADESH",null,null,null,null,null,null,null,null,null,null,"KARNATAKA",29,null,null,"QUINTALS                 ","QTS"]
[null,"MAHARASHTRA",null,null,null,null,null,null,null,null,null,null,"KERALA",32,null,null,"THOUSAND NUMBERS/UNITS   ","SNO"]
[null,"MANIPUR",null,null,null,null,null,null,null,null,null,null,"LAKSHADWEEP",31,null,null,"THOUSAND KILOMETERS      ","TKM"]
[null,"MEGHALAYA",null,null,null,null,null,null,null,null,"Road",null,"LADAKH",38,null,null,"THOUSAND LITRES          ","TLT"]
[null,"MIZORAM",null,null,null,null,null,null,null,null,"Air",null,"MADHYA PRADESH",23,null,null,"TEN NUMBERS/UNITS        ","TNO"]
[null,"NAGALAND",null,null,null,null,null,null,null,null,"Rail",null,"MAHARASHTRA",27,null,null,"TONNES                   ","TON"]
[null,"ORISSA",null,null,null,null,null,null,null,null,"Ship/Road cum Ship",null,"MANIPUR",14]
[null,"PONDICHERRY",null,null,null,null,null,null,null,null,null,null,"MEGHALAYA",17]
[null,"PUNJAB",null,null,null,null,null,null,null,null,null,null,"MIZORAM",15]
[null,"RAJASTHAN",null,null,null,null,null,null,null,null,null,null,"NAGALAND",13,null,null,"Due To Break Down",1]
[null,"SIKKIM",null,null,null,null,null,null,null,null,null,null,"ORISSA",21,null,null,"Due To Transhipment",2]
[null,"TAMIL NADU",null,null,null,null,null,null,null,null,null,null,"PONDICHERRY",34,null,null,"Others",3]
[null,"TELANGANA",null,null,null,null,null,null,null,null,null,null,"PUNJAB",3,null,null,"First Time",4]
[null,"TRIPURA",null,null,null,null,null,null,null,null,null,null,"RAJASTHAN",8]
[null,"UTTAR PRADESH",null,null,null,null,null,null,null,null,null,null,"SIKKIM",11]
[null,"UTTARAKHAND",null,null,null,null,null,null,null,null,null,null,"TAMIL NADU",33,null,null,"Regular","R"]
[null,"WEST BENGAL",null,null,null,null,null,null,null,null,null,null,"TELANGANA",36,null,null,"ODC","O"]
[null,"OTHER TERRITORY",null,null,null,null,null,null,null,null,null,null,"TRIPURA",16]
[null,"OTHER COUNTRIES",null,null,null,null,null,null,null,null,null,null,"UTTAR PRADESH",9]
[null,null,null,null,null,null,null,null,null,null,null,null,"UTTARAKHAND",5]
["Trans Mode","Road",null,null,null,null,null,null,null,null,null,null,"WEST BENGAL",19]
[null,"Rail",null,null,null,null,null,null,null,null,null,null,"OTHER TERRITORY",97]
[null,"Air",null,null,null,null,null,null,null,null,null,null,"OTHER COUNTRIES",99]
[null,"Ship/Road cum Ship"]
[]
["Reason for Updation","Due To Break Down"]
[null,"Due To Transhipment"]
[null,"Others"]
[null,"First Time"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Road",1]
[null,null,null,null,null,null,null,null,null,null,null,null,"Air",3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Rail",2]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ship/Road cum Ship",4]
[]
[null,null,null,null,null,null,null,null,null,null,"< 10",1]
[null,null,null,null,null,null,null,null,null,null,"10 - 100",2]
[null,null,null,null,null,null,null,null,null,null,"100 - 300",3]
[null,null,null,null,null,null,null,null,null,null,"300 - 500",4]
[null,null,null,null,null,null,null,null,null,null,"500 - 1000",5]
[null,null,null,null,null,null,null,null,null,null,"> 1000",6]

{"sheet":"Sample EWB Vehicle Updt","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,2,9,4]]}
[null,"Updation of EWaybill Vehicle Number (Ver 1.0.0126)"]
["GSTIN/Trans in:",null,"Name:",null,"Place:",null,"Pin Code:",null,"State:"]
["E-Way Bill No *","Trans Mode *","Vehicle Type (Ignore only if Part:B has already entered)","Vehicle No","Trans Doc No","Trans Doc Date","From Place *","From State","Reason for Updation *","Remarks"]
[123456789878,"Road",null,"KA12KA1234",345,"2018-01-03","BANGALORE","KARNATAKA","Due To Break Down","Due to breakdown we are updating the vehicle number"]
[987678765676,"Rail",null,null,"76567","2018-01-06","BANGALORE","KARNATAKA","Due To Transhipment","Due to Transhipment we are updating the vehicle number"]
[100987650923,"Ship",null,null,"330-3456","2018-01-13","BANGALORE","KARNATAKA","First Time"]
[100045234388,"Air",null,null,"We are updating the vehicle number for other conditions","2018-01-13","BANGALORE","KARNATAKA","Others","We are updating the vehicle number for other conditions"]
[]
[]
[null,null,"Explaination for above Entries."]
[1,"This has sample e-way bill Vehicle Updation requests. It has 4 records."]
[]
[2,"In Row 4, Vehicle Number is getting updated for e-Way Bill. Here Transportation Mode is Road, hence vehicle Number is mandatory."]
[]
[3,"In Row 5, Transport Document Number is getting updated for the e-Way Bill. Transportation Mode is  Rail, Hence, Transport  Document "]
[null,"Number is mandatory."]
[]
[4,"In Row 6, Transport Document Number is getting updated for the e-Way Bill. Transportation Mode is  Ship, Hence, Transport Document"]
[null,"Number is mandatory."]
[]
[5,"In Row 7, Transport Document Number is getting updated for the e-Way Bill. Transportation Mode is  Air, Hence, Transport Document "]
[null,"Number is mandatory and Reason for Updation is  \"Others\" Hence, Remarks is mandatory."]