{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["inserção de dados","JAN","FEV","MAR","ABR","MAI","JUN","JUL","AGO","SET","OUT","NOV","DEZ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"inserção de dados","index":0,"n_rows":27,"n_cols":59,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,3,0,5]]}
[{"$f":"COUNTA(C4:C10)","v":7},null,"JAN","<<==== Informe o mês"]
[]
[null,null,"MÊS","DIA","PROD","QTE","PR UNIT","PR TOTAL","VD1","VD 2","VD3","VD4","VD5","VD6","VD7","VD8","VD9","VD10","VD11","VD12","VD13","VD14","VD15","VD16","VD17","VD18","VD19","VD20","VD21","VD22","VD23","VD24","VD25","VD26","VD27","VD28","VD29","VD30","VD31","VD32","VD33","VD34","VD35","VD36","VD37","VD38","VD39","VD40","VD41","VD42","VD43","VD44","VD45","VD46","VD47","VD48","VD49","VD50","TOTAL"]
[null,null,"JAN",2,"A",6,2,{"$f":"F4*G4","v":12},0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(I4:BE4)","v":6}]
[null,null,"JAN",5,"C",2,3,{"$f":"F5*G5","v":6},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,{"$f":"SUM(I5:BE5)","v":2}]
[null,null,"FEV",4,"C",4,4,16,0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4]
[null,null,"MAR",7,"F",5,5,25,0,0,0,0,1,0,1,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5]
[null,null,"MAR",7,"A",4,6,24,0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4]
[null,null,"MAR",10,"D",2,7,14,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2]
[null,null,"ABR",5,"A",5,8,40,0,0,0,0,1,0,0,0,1,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5]
[null,null,"MAI",4,"G",3,9,27,0,0,0,0,0,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3]
[null,null,"JUN",3,"G",1,10,{"$f":"F12*G12","v":10},0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,"JUN",2,"G",5,11,55,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1]
[null,null,"AGO",1,"H",7,12,84,0,0,3,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,7]
[null,null,"SET",25,"I",6,13,78,2,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6]
[null,null,"SET",4,"A",4,14,56,0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4]
[null,null,"SET",17,"A",5,15,75,0,1,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5]
[null,null,"OUT",23,"A",6,16,96,0,0,2,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6]
[null,null,"NOV",2,"BB",4,17,68,0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4]
[null,null,"DEZ",6,"RF",6,18,108,0,0,0,2,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6]
[null,null,"DEZ",3,"SE",3,19,57,0,0,0,0,0,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3]
[null,null,"DEZ",3,"A",5,20,100,0,0,0,1,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5]
[]
[]
[null,null,"O que preciso resolver:"]
[null,null,"Farei o preenchimento das informações na planilha (inserção de dados) e,"]
[null,null,"Quando indicar o MÊS, como exemplo: JAN, toda(s) a(s) linha(s) (L4 e L5) será(ão) transferida(s) para a planilha JAN na sequência da(s) data(s)"]

{"sheet":"JAN","index":1,"n_rows":4,"n_cols":58,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MÊS","DIA","PROD","QTE","PR UNIT","PR TOTAL","VD1","VD 2","VD3","VD4","VD5","VD6","VD7","VD8","VD9","VD10","VD11","VD12","VD13","VD14","VD15","VD16","VD17","VD18","VD19","VD20","VD21","VD22","VD23","VD24","VD25","VD26","VD27","VD28","VD29","VD30","VD31","VD32","VD33","VD34","VD35","VD36","VD37","VD38","VD39","VD40","VD41","VD42","VD43","VD44","VD45","VD46","VD47","VD48","VD49","VD50","TOTAL"]
[null,"JAN",2,"A",6,2,{"$f":"E3*F3","v":12},0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H3:BD3)","v":6}]
[null,"JAN",5,"C",2,3,{"$f":"E4*F4","v":6},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,{"$f":"SUM(H4:BD4)","v":2}]

{"sheet":"FEV","index":2,"n_rows":3,"n_cols":58,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MÊS","DIA","PROD","QTE","PR UNIT","PR TOTAL","VD1","VD 2","VD3","VD4","VD5","VD6","VD7","VD8","VD9","VD10","VD11","VD12","VD13","VD14","VD15","VD16","VD17","VD18","VD19","VD20","VD21","VD22","VD23","VD24","VD25","VD26","VD27","VD28","VD29","VD30","VD31","VD32","VD33","VD34","VD35","VD36","VD37","VD38","VD39","VD40","VD41","VD42","VD43","VD44","VD45","VD46","VD47","VD48","VD49","VD50","TOTAL"]
[null,"FEV",4,"C",4,4,{"$f":"E3*F3","v":16},0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H3:BD3)","v":4}]

{"sheet":"MAR","index":3,"n_rows":5,"n_cols":58,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MÊS","DIA","PROD","QTE","PR UNIT","PR TOTAL","VD1","VD 2","VD3","VD4","VD5","VD6","VD7","VD8","VD9","VD10","VD11","VD12","VD13","VD14","VD15","VD16","VD17","VD18","VD19","VD20","VD21","VD22","VD23","VD24","VD25","VD26","VD27","VD28","VD29","VD30","VD31","VD32","VD33","VD34","VD35","VD36","VD37","VD38","VD39","VD40","VD41","VD42","VD43","VD44","VD45","VD46","VD47","VD48","VD49","VD50","TOTAL"]
[null,"MAR",7,"F",5,5,{"$f":"E3*F3","v":25},0,0,0,0,1,0,1,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H3:BD3)","v":5}]
[null,"MAR",7,"A",4,6,24,0,0,0,0,1,0,0,0,1,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4]
[null,"MAR",10,"D",2,7,14,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2]

{"sheet":"ABR","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,3,1,6]]}

{"sheet":"MAI","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,3,1,6]]}

{"sheet":"JUN","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,3,1,6]]}

{"sheet":"JUL","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,3,1,6]]}

{"sheet":"AGO","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SET","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"OUT","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"NOV","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DEZ","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}