{"text_format":"2","workbook":"xlsx","n_sheets":7,"sheets":["Raw Master Data","QR  bin","Audit Team Data","1st cut Report","Sale Data (2ndMaster)","No Price Give - Annexures","End report"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Raw Master Data","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["MASTER DATA"]
["Part Number","Part Description","Sum of Current Stock","Price","count/ not to count","Bin Location ","QR Bin"]
["PartX001","Bolt",100,400,true,"GD001","FA1AB001",70]
["PartX001","Bolt",20,400,true,"HG005","FA1AB002",15]
["PartX001","Bolt",30,401,true,null,"FA1AB003",30]
["PartX002","Pamphlet",300,12,false,null,"FA1AB004"]
["PartX003",null,null,null,false,null,"FA1AB005"]
["PartX004",null,null,null,false,null,"FA1AB006"]
["PartX005",null,null,null,true]

{"sheet":"QR  bin","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Floor","Room","BIN","QRBIN"]
[null,null,1,"A",1,"FA1AB001"]
[null,null,1,"A",2,"FA1AB002"]
[null,null,1,"A",3,"FA1AB003"]
[null,null,1,"B",1,"FA1BB001"]

{"sheet":"Audit Team Data","index":2,"n_rows":17,"n_cols":21,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,7,0,19]]}
["MASTER DATA",{"$nulls":6},"TEAM AUDIT DATA"]
["Taken from the team entry ","taken from master data sheet - by Vlookup","Taken from the master data sheet - using Vlookup","Taken from the Master data sheet","Taken from the Master data sheet","Taken from the Master data sheet",null,"Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","Calculation -\nAudit team count - Sum of Current Stock","Taken from the team entry - from App","Calculation -\nQC Audit team count - Sum of Current Stock","Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","Taken from the team entry - from App","to be analysed from the backend data"]
["Part Number","Part Description","Sum of Current Stock","Price","count/ not to count","Bin Location ","QR bin from master data","QR Bin (scanned)","Audit count","Reviewer","Audit date Date","Audit time","Remark","Balance","QC count","Balance After QC","QC Reviewer","QC Date","QC time","QC remark","Summary flag"]
["PartX001","Bolt",100,400,true,"GD001","FA1AB001","QR bin001",70,"Sharmila","2021-01-25","09:00:00"," -",{"$f":"I4-C4","v":-30},80,-20,{"$nulls":4},"Shortage"]
["PartX001","Bolt",100,400,true,null,"FA1AB002","QR bin001",25,"Naveen","2021-01-26","10:00:00","kkkl",{"$f":"I5-C5","v":-75},20,-80,"Sathyam","2021-01-27","13:00:00","Bad counting - but still less","Excess"]
["PartX001","Bolt",20,400,true,null,"FA1AB003","QR bin003",20,"Abhishek","2021-01-26","10:03:01","kkkl",{"$f":"I6-C6","v":0},20,0,"Sathyam","2021-01-27","13:00:00","Mateches Master data","Counted and Ok"]
["PartX004",{"$nulls":5},"FA1AB004","QR bin",10,"Abhishek","2021-01-27","11:03:01","kkkl",{"$f":"I7-C7","v":10},21,null,"Sathyam","2021-01-28","14:00:00","Parts physically present","Annexure"]
["PartX005","Bolt",100,400,true,"GD001",{"$nulls":14},"Parts Not Found"]
["PartX006","Bolt",20,400,true,"GD002",null,"QR bin003",25]
["PartX007","Bolt",20,400,true,"GD003",null,"QR bin015",20]
["PartX008","Bolt",20,400,true,"GD002",null,"QR bin003",10]
["PartX009","Bolt",20,400,true,"GD003",null,"QR bin015",70]
["PartX010","Bolt",20,400,true,"GD004",null,"QR bin003",25]
["PartX011","Bolt",20,400,true,"GD005",null,"QR bin015",20]
["PartX012","Bolt",20,400,true,"GD006",null,"QR bin003",10]
["PartX013","Bolt",20,400,true,"GD007",null,"QR bin015",70]
["PartX014","Bolt",20,400,true,"GD008",null,"QR bin003",25]

{"sheet":"1st cut Report","index":3,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,9]]}
["MASTER DATA",{"$nulls":4},"TEAM AUDIT DATA"]
["Taken from the team entry ","taken from master data sheet - by Vlookup","Taken from the master data sheet - using Vlookup","Taken from the Master data sheet","Taken from the Master data sheet","Taken from the team entry - from App","Taken from the team entry - from App","Calculation -\nAudit team count - Sum of Current Stock","Physical Qty X Price","Taken from the team entry - from App","Taken from the team entry - from App"]
["Part Number","Part Description","Sum of Current Stock","Price","Bin Location ","Physical QTY","QR Bin","Difference","Strock Value","Remark","Summary"]
["PartX001","Bolt",150,400,"GD001",115,"QR bin001/ QR bin015/ typed bin",{"$f":"F4-C4","v":-35},{"$f":"D4*F4","v":46000},"QC / Audit Remarks. QC, Audit remark","Shortage"]
["PartX002",{"$nulls":4},20,"bin 2, bin 6",200,null,null,"Excess"]
[{"$nulls":10},"Counted and Ok"]
[{"$nulls":10},"Annexure"]
[{"$nulls":10},"Parts Not Found"]

{"sheet":"Sale Data (2ndMaster)","index":4,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,7]]}
["MASTER DATA",null,null,null,"TEAM AUDIT DATA"]
["Part Number","Part Description","Sum of Current Stock","Price","Bin Location ","Physical QTY","QR Bin","Difference","Strock Value","Summary","Sales data"]
["PartX001","Bolt",150,400,"GD001",115,"QR bin001/ QR bin015/ typed bin",{"$f":"F3-C3","v":-35},{"$f":"D3*F3","v":46000},"Shortage"]
["PartX002","breaks",100,500,"GD001",100,"QR bin002",{"$f":"F4-C4","v":0},{"$f":"D4*F4","v":50000},"Excess"]
["PartX003","rubber tube",10000,150,"GD001",5000,"QR bin005",{"$f":"F5-C5","v":-5000},750000,"Counted and Ok"]
["PartX004",null,null,4,"GD001",25,"QR bin011",25,{"$f":"D6*F6","v":100},"Annexure"]
["PartX005",{"$nulls":8},"Parts Not Found"]

{"sheet":"No Price Give - Annexures","index":5,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Part No","Particulars","Qnty","Price","Category"]
[null,"part100",null,200,15,"Annexure"]
[null,"part101",null,200,15,"Annexure"]
[null,"part102",null,200,15,"Annexure"]
[null,"part103",null,200,15,"Annexure"]
[null,"part104",null,200,15,"Annexure"]
[null,"Part300 Damaged part",null,100,15,"Damaged"]
[null,"Part300 Damaged part",null,101,15,"Damaged"]
[null,"Part300 Damaged part",null,102,15,"Damaged"]
[null,"Part300 Damaged part",null,103,15,"Damaged"]
[null,"Part300 Damaged part",null,104,15,"Damaged"]
[null,"Part300 Damaged part",null,105,15,"Damaged"]

{"sheet":"End report","index":6,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,5,0,8],[0,10,0,14]]}
["MASTER DATA",{"$nulls":4},"TEAM AUDIT DATA",null,null,null,"SALE DATA","RECONCILIATION FiNAL DATA"]
["Part Number","Part Description","Sum of Current Stock","Price","Bin Location ","Physical QTY","QR Bin","Difference","Strock Value","Sale ","Physical QTY after Sale (reconciliation)","Difference After Sale","Adjust Value (to DMS)","Final Stock Value","Remark","Summary"]
["PartX001","Bolt",100,400,"GD001",80,"typed bin new",{"$f":"F3-C3","v":-20},{"$f":"D3*F3","v":32000},30,{"$f":"F3","v":80},{"$f":"K3-C3","v":-20},{"$f":"K3","v":80},{"$f":"M3*D3","v":32000},"ttttttt","Shortage"]
["PartX001","Bolt",20,400,"HG005",20,"typed bin new",{"$f":"F4-C4","v":0},{"$f":"D4*F4","v":8000},null,{"$f":"F4","v":20},null,{"$f":"K4","v":20},{"$f":"M4*D4","v":8000},"ttttttt","Counted and Ok"]
["PartX001","Bolt",30,400,null,20,"typed bin new",-10,{"$f":"D5*F5","v":8000},null,{"$f":"F5","v":20},null,20,8000,"ttttttt","Shortage"]
["PartX005",{"$nulls":14},"Annexure"]
[{"$nulls":15},"Parts Not Found"]
[{"$nulls":15},"Excess"]