{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Segmentos","Segmento"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Segmentos","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,1,5],[0,6,1,7]]}
["PDV",null,null,null,null,null,"Produtividade",null,null,"OUTROS"]
[]
["NB","Fantasia","VDE","Visita","Segmento","PDM","GPS %","POS %",null,{"$f":"MAX(K5:K20004)","v":3}]
[2450,"Cliente 1",141,"2021-08-11","Rota","-",1,1,{"$f":"IF(E4=\"\",\"\",IF(COUNTIF($E$4:E4,E4)>1,\"\",MAX($I$3:I3)+1))","v":1},{"$f":"IFERROR(INDEX($E$3:$E$13,MATCH(ROW(E1),$I$3:$I$13,0)),\"\")","v":"Rota"},{"$f":"IF(J4=\"\",\"\",1)","v":1}]
[1410,"Cliente 2",141,"2021-08-10","VIP","-",1,0,{"$f":"IF(E5=\"\",\"\",IF(COUNTIF($E$4:E5,E5)>1,\"\",MAX($I$3:I4)+1))","v":2},{"$f":"IFERROR(INDEX($E$3:$E$13,MATCH(ROW(E2),$I$3:$I$13,0)),\"\")","v":"VIP"},{"$f":"IF(J5=\"\",\"\",K4+1)","v":2}]
[2805,"Cliente 3",141,"2021-08-10","Rota","-",1,0,{"$f":"IF(E6=\"\",\"\",IF(COUNTIF($E$4:E6,E6)>1,\"\",MAX($I$3:I5)+1))","v":""},"OUTROS",{"$f":"IF(J6=\"\",\"\",K5+1)","v":3}]
[2395,"Cliente 4",142,"2021-08-11","VIP","-",1,1,{"$f":"IF(E7=\"\",\"\",IF(COUNTIF($E$4:E7,E7)>1,\"\",MAX($I$3:I6)+1))","v":""},"",""]
[2711,"Cliente 5",142,"2021-08-13","Rota","-",1,0,{"$f":"IF(E8=\"\",\"\",IF(COUNTIF($E$4:E8,E8)>1,\"\",MAX($I$3:I7)+1))","v":""},"",""]
[2826,"Cliente 6",143,"2021-08-13","OUTROS","-",1,0,{"$f":"IF(E9=\"\",\"\",IF(COUNTIF($E$4:E9,E9)>1,\"\",MAX($I$3:I8)+1))","v":3},"",""]
[879,"Cliente 7",143,"2021-08-14","OUTROS","-",1,0,{"$f":"IF(E10=\"\",\"\",IF(COUNTIF($E$4:E10,E10)>1,\"\",MAX($I$3:I9)+1))","v":""},"",""]
[2362,"Cliente 8",143,"2021-08-10","VIP","-",1,1,{"$f":"IF(E11=\"\",\"\",IF(COUNTIF($E$4:E11,E11)>1,\"\",MAX($I$3:I10)+1))","v":""},"",""]
[2390,"Cliente 9",144,"2021-08-14","OUTROS","-",1,0,{"$f":"IF(E12=\"\",\"\",IF(COUNTIF($E$4:E12,E12)>1,\"\",MAX($I$3:I11)+1))","v":""},"",""]
[1137,"Cliente 10",144,"2021-08-10","VIP","-",1,1,{"$f":"IF(E13=\"\",\"\",IF(COUNTIF($E$4:E13,E13)>1,\"\",MAX($I$3:I12)+1))","v":""},"",""]

{"sheet":"Segmento","index":1,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,1,5],[0,6,1,7]]}
["PDV",null,null,null,null,null,"Produtividade"]
[]
["NB","Fantasia","VDE","Visita","Segmento","PDM","GPS %","POS %"]
[2826,"Cliente 6",143,"2021-08-13","OUTROS","-",1,0]
[879,"Cliente 7",143,"2021-08-14","OUTROS","-",1,0]
[2390,"Cliente 9",144,"2021-08-14","OUTROS","-",1,0]