{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":[" fev 2015 BD","janeiro (11)","atual 33","tabelas"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":" fev 2015 BD","index":0,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[3,2]
[4,3]
[5,4]
["s",1]
[]
[]
["Codigo","TIPO","descrição","qtd","valor\nbruto","peso","fator1","valor ","A","C","F","Final","empresa","Barcode","DV","col que contem criteiro de busca","usa","qto","obs"]
["BB001","dd","coruja",5,10,1.2,3,{"$f":"VLOOKUP(G9,$A$2:$B$3,2)*F9","v":2.4},null,{"$f":"E9+H9+Q9","v":12.4},10,{"$f":"CEILING(J9*K9,3)","v":126},"globo",{"$f":"CONCATENATE(VLOOKUP(B9,tabelas!$B$3:$C$30,2),VLOOKUP(M9,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A9,SEARCH(\" \",A9,1)-1),A9),3))","v":"6620001"},{"$f":"N9&CEILING((MID(N9,2,1)+MID(N9,4,1)+MID(N9,6,1))+(MID(N9,1,1)+MID(N9,3,1)+MID(N9,5,1)+MID(N9,7,1))*3,10)-((MID(N9,2,1)+MID(N9,4,1)+MID(N9,6,1))+((MID(N9,1,1)+MID(N9,3,1)+MID(N9,5,1)+MID(N9,7,1)))*3)","v":"66200017"},2]
["BB002","dd","bolinha",5,2,null,3,{"$f":"VLOOKUP(G10,$A$2:$B$3,2)*F10","v":0},null,2,6,12,"globo",{"$f":"CONCATENATE(VLOOKUP(B10,tabelas!$B$3:$C$30,2),VLOOKUP(M10,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A10,SEARCH(\" \",A10,1)-1),A10),3))","v":"6620002"},"66200024"]
["BB003","ff","perola ",5,2.2999999999999998,null,3,{"$f":"VLOOKUP(G11,$A$2:$B$3,2)*F11","v":0},null,2.2999999999999998,6,15,"globo",{"$f":"CONCATENATE(VLOOKUP(B11,tabelas!$B$3:$C$30,2),VLOOKUP(M11,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A11,SEARCH(\" \",A11,1)-1),A11),3))","v":"6620003"},"66200031",2]
["BB004","dd","perola c/ strass",5,1,1.4,3,{"$f":"VLOOKUP(G12,$A$2:$B$3,2)*F12","v":2.8},null,3.8,10,39,"globo",{"$f":"CONCATENATE(VLOOKUP(B12,tabelas!$B$3:$C$30,2),VLOOKUP(M12,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A12,SEARCH(\" \",A12,1)-1),A12),3))","v":"6620004"},"66200048"]
["BB005","dd",null,5,1.2,null,3,{"$f":"VLOOKUP(G13,$A$2:$B$3,2)*F13","v":0},null,1.2,6,9,"globo",{"$f":"CONCATENATE(VLOOKUP(B13,tabelas!$B$3:$C$30,2),VLOOKUP(M13,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A13,SEARCH(\" \",A13,1)-1),A13),3))","v":"6620005"},"66200055",2]
["BB006","dd","encaixe c/ Bolinha",5,1.9,2.2000000000000002,3,{"$f":"VLOOKUP(G14,$A$2:$B$3,2)*F14","v":4.4000000000000004},null,6.3000000000000007,6,39,"globo",{"$f":"CONCATENATE(VLOOKUP(B14,tabelas!$B$3:$C$30,2),VLOOKUP(M14,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A14,SEARCH(\" \",A14,1)-1),A14),3))","v":"6620006"},"66200062"]
["BB007","dd","losango c/ extras",5,1.9,3.2,3,6.4,null,8.3000000000000007,7,60,"globo",{"$f":"CONCATENATE(VLOOKUP(B15,tabelas!$B$3:$C$30,2),VLOOKUP(M15,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A15,SEARCH(\" \",A15,1)-1),A15),3))","v":"6620007"},"66200079"]
["BB008","dd","flor p vazada",5,0.4,0.6,3,1.2,null,1.6,18,30,"sbt",{"$f":"CONCATENATE(VLOOKUP(B16,tabelas!$B$3:$C$30,2),VLOOKUP(M16,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A16,SEARCH(\" \",A16,1)-1),A16),3))","v":"6630008"},"66300083"]
["BB009","dd",null,5,1.9,4.2,3,8.4,null,10.3,7,75,"sbt",{"$f":"CONCATENATE(VLOOKUP(B17,tabelas!$B$3:$C$30,2),VLOOKUP(M17,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A17,SEARCH(\" \",A17,1)-1),A17),3))","v":"6630009"},"66300090"]
["BB010","dd",null,5,1.5,3.2,3,6.4,null,7.9,6,48,"sbt",{"$f":"CONCATENATE(VLOOKUP(B18,tabelas!$B$3:$C$30,2),VLOOKUP(M18,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A18,SEARCH(\" \",A18,1)-1),A18),3))","v":"6630010"},"66300106"]
["BB011","dd","Bola g",5,2.4,3.1,3,6.2,null,8.6,6,54,"sbt",{"$f":"CONCATENATE(VLOOKUP(B19,tabelas!$B$3:$C$30,2),VLOOKUP(M19,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A19,SEARCH(\" \",A19,1)-1),A19),3))","v":"6630011"},"66300113"]
["BB012","dd","Bola m",5,1.9,1.6,3,3.2,null,5.0999999999999996,7,36,"sbt",{"$f":"CONCATENATE(VLOOKUP(B20,tabelas!$B$3:$C$30,2),VLOOKUP(M20,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A20,SEARCH(\" \",A20,1)-1),A20),3))","v":"6630012"},"66300120"]
["BB013","dd","ponto de luz c/ estrela",5,1.9,1.4,3,2.8,null,4.6999999999999993,6,30,"sbt",{"$f":"CONCATENATE(VLOOKUP(B21,tabelas!$B$3:$C$30,2),VLOOKUP(M21,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A21,SEARCH(\" \",A21,1)-1),A21),3))","v":"6630013"},"66300137"]
["BB014","dd","ponto luz G",5,null,null,3,0,null,0,7,0,"record",{"$f":"CONCATENATE(VLOOKUP(B22,tabelas!$B$3:$C$30,2),VLOOKUP(M22,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A22,SEARCH(\" \",A22,1)-1),A22),3))","v":"6612014"},"66120148"]
["BB015","dd",null,5,null,null,3,0,null,0,6,0,"record",{"$f":"CONCATENATE(VLOOKUP(B23,tabelas!$B$3:$C$30,2),VLOOKUP(M23,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A23,SEARCH(\" \",A23,1)-1),A23),3))","v":"6612015"},"66120155"]
["BB016","dd",null,5,null,null,3,0,null,0,6,0,"record",{"$f":"CONCATENATE(VLOOKUP(B24,tabelas!$B$3:$C$30,2),VLOOKUP(M24,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A24,SEARCH(\" \",A24,1)-1),A24),3))","v":"6612016"},"66120162"]
["BB017","dd",null,5,null,null,3,0,null,0,6,0,"record",{"$f":"CONCATENATE(VLOOKUP(B25,tabelas!$B$3:$C$30,2),VLOOKUP(M25,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A25,SEARCH(\" \",A25,1)-1),A25),3))","v":"6612017"},"66120179"]
["BB018","dd",null,null,2.2999999999999998,3.4,3,6.8,null,9.1,7,66,"record",{"$f":"CONCATENATE(VLOOKUP(B26,tabelas!$B$3:$C$30,2),VLOOKUP(M26,tabelas!$E$3:$F$30,2),RIGHT(IFERROR(LEFT(A26,SEARCH(\" \",A26,1)-1),A26),3))","v":"6612018"},{"$f":"N26&CEILING((MID(N26,2,1)+MID(N26,4,1)+MID(N26,6,1))+(MID(N26,1,1)+MID(N26,3,1)+MID(N26,5,1)+MID(N26,7,1))*3,10)-((MID(N26,2,1)+MID(N26,4,1)+MID(N26,6,1))+((MID(N26,1,1)+MID(N26,3,1)+MID(N26,5,1)+MID(N26,7,1)))*3)","v":"66120186"}]

{"sheet":"janeiro (11)","index":1,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[3,2]
[4,3]
[5,4]
["s",1]
[]
[]
["Codigo","TIPO","descrição","qtd","valor\nbruto","peso","fator1","valor ","A","C","F","Final","empresa","Barcode","DV","col que contem criteiro de busca","usa","qto","obs"]
["FF001","dd","coruja",5,10,1.2,3,{"$f":"VLOOKUP(G9,$A$2:$B$3,2)*F9","v":2.4},null,{"$f":"E9+H9+N9","v":1120013.3999999999},10,{"$f":"CEILING(J9*K9,3)","v":11200134},"globo",1120001,11200017,3]
["FF002","dd","bolinha",5,2,null,3,{"$f":"VLOOKUP(G10,$A$2:$B$3,2)*F10","v":0},null,1120004,6,6720024,"globo",1120002,11200024]
["FF003","ff","perola ",5,2.2999999999999998,null,3,{"$f":"VLOOKUP(G11,$A$2:$B$3,2)*F11","v":0},null,1120005.3,6,6720033,"globo",1120003,11200031,3]
["FF004","dd","perola c/ strass",5,1,1.4,3,{"$f":"VLOOKUP(G12,$A$2:$B$3,2)*F12","v":2.8},null,1120007.8,10,11200080,"globo",1120004,11200048]
["FF005","dd",null,5,1.2,null,3,{"$f":"VLOOKUP(G13,$A$2:$B$3,2)*F13","v":0},null,1120006.2,6,6720039,"globo",1120005,11200055,3]
["FF006","dd","encaixe c/ Bolinha",5,1.9,2.2000000000000002,3,{"$f":"VLOOKUP(G14,$A$2:$B$3,2)*F14","v":4.4000000000000004},null,1120012.3,6,6720075,"globo",1120006,11200062]
["FF007","dd","losango c/ extras",5,1.9,3.2,3,6.4,null,1120015.3,7,7840110,"globo",1120007,11200079]
["FF008","dd","flor p vazada",5,0.4,0.6,3,1.2,null,1130009.6000000001,18,20340174,"sbt",1130008,11300083]
["FF009","dd",null,5,1.9,4.2,3,8.4,null,1130019.3,7,7910136,"sbt",1130009,11300090]
["FF010","dd",null,5,1.5,3.2,3,6.4,null,1130017.8999999999,6,6780108,"sbt",1130010,11300106]
["FF011","dd","Bola g",5,2.4,3.1,3,6.2,null,1130019.6000000001,6,6780120,"sbt",1130011,11300113]
["FF012","dd","Bola m",5,1.9,1.6,3,3.2,null,1130017.1000000001,7,7910121,"sbt",1130012,11300120]
["FF013","dd","ponto de luz c/ estrela",5,1.9,1.4,3,2.8,null,1130017.7,6,6780108,"sbt",1130013,11300137]
["FF014","dd","ponto luz G",5,null,null,3,0,null,1112014,7,7784100,"record",1112014,11120148]
["FF015","dd",null,5,null,null,3,0,null,1112015,6,6672090,"record",1112015,11120155]
["FF016","dd",null,5,null,null,3,0,null,1112016,6,6672096,"record",1112016,11120162]
["FF017","dd",null,5,null,null,3,0,null,1112017,6,6672102,"record",1112017,11120179]
["FF018","dd",null,null,2.2999999999999998,3.4,3,6.8,null,1112027.1000000001,7,7784190,"record",1112018,11120186]

{"sheet":"atual 33","index":2,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[3,2]
[4,3]
[5,4]
["s",1]
[]
[]
["Codigo","TIPO","descrição","qtd","valor\nbruto","peso","fator1","valor ","A","C","F","Final","empresa","Barcode","DV","col que contem criteiro de busca","usa","qto","obs"]
["BB001","dd","coruja",5,10,1.2,3,{"$f":"VLOOKUP(G9,$A$2:$B$3,2)*F9","v":2.4},null,{"$f":"E9+H9+Q9","v":12.4},10,{"$f":"CEILING(J9*K9,3)","v":126},"globo",3320001,33200017,"x"]
["BB002","dd","bolinha",5,2,null,3,{"$f":"VLOOKUP(G10,$A$2:$B$3,2)*F10","v":0},null,2,6,12,"globo",3320002,33200024]
["BB003","ff","perola ",5,2.2999999999999998,null,3,{"$f":"VLOOKUP(G11,$A$2:$B$3,2)*F11","v":0},null,2.2999999999999998,6,15,"globo",3320003,33200031,"b"]
["BB004","dd","perola c/ strass",5,1,1.4,3,{"$f":"VLOOKUP(G12,$A$2:$B$3,2)*F12","v":2.8},null,3.8,10,39,"globo",3320004,33200048]
["BB005","dd",null,5,1.2,null,3,{"$f":"VLOOKUP(G13,$A$2:$B$3,2)*F13","v":0},null,1.2,6,9,"globo",3320005,33200055,"d"]
["BB006","dd","encaixe c/ Bolinha",5,1.9,2.2000000000000002,3,{"$f":"VLOOKUP(G14,$A$2:$B$3,2)*F14","v":4.4000000000000004},null,6.3000000000000007,6,39,"globo",3320006,33200062]
["BB007","dd","losango c/ extras",5,1.9,3.2,3,6.4,null,8.3000000000000007,7,60,"globo",3320007,33200079]
["BB008","dd","flor p vazada",5,0.4,0.6,3,1.2,null,1.6,18,30,"sbt",3330008,33300083]
["BB009","dd",null,5,1.9,4.2,3,8.4,null,10.3,7,75,"sbt",3330009,33300090]
["BB010","dd",null,5,1.5,3.2,3,6.4,null,7.9,6,48,"sbt",3330010,33300106]
["BB011","dd","Bola g",5,2.4,3.1,3,6.2,null,8.6,6,54,"sbt",3330011,33300113]
["BB012","dd","Bola m",5,1.9,1.6,3,3.2,null,5.0999999999999996,7,36,"sbt",3330012,33300120]
["BB013","dd","ponto de luz c/ estrela",5,1.9,1.4,3,2.8,null,4.6999999999999993,6,30,"sbt",3330013,33300137]
["BB014","dd","ponto luz G",5,null,null,3,0,null,0,7,0,"record",3312014,33120148]
["BB015","dd",null,5,null,null,3,0,null,0,6,0,"record",3312015,33120155]
["BB016","dd",null,5,null,null,3,0,null,0,6,0,"record",3312016,33120162]
["BB017","dd",null,5,null,null,3,0,null,0,6,0,"record",3312017,33120179]
["BB018","dd",null,null,2.2999999999999998,3.4,3,6.8,null,9.1,7,66,"record",3312018,33120186]

{"sheet":"tabelas","index":3,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"produtos",null,null,"fornecedores"]
[null,"ANEL",11,null,"ADONAI",10]
[null,"BERLOQUE",22,null,"ae",17]
[null,"BOLSA",45,null,"ama",27]
[null,"BRACELETE",33,null,"chalita",28]
[null,"BRINCO",44,null,"cyl",13]
[null,"CINTO",47,null,"di",16]
[null,"COLAR",55,null,"gf",20]
[null,"CORRENTE",66,null,"inbraf",19]
[null,"GARGANTILHA",77,null,"já",21]
[null,"PINGENTE",88,null,"joao",29]
[null,"PULSEIRA",99,null,"julia",23]
[null,"TIARA",46,null,"megafundicao",15]
[null,null,null,null,"megasul",14]
[null,null,null,null,"orbini",26]
[null,null,null,null,"palacio",12]
[null,null,null,null,"renata",22]
[null,null,null,null,"SAMPA",30]
[null,null,null,null,"scherrer",24]
[null,null,null,null,"xxxxxx",25]
[null,null,null,null,"YAN",11]
[null,null,null,null,"zaph",18]