{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelas de Frequência","Diagrama de Pareto"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Diagrama de Pareto","index":1,"reason":"not_a_worksheet"}],"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":"Tabelas de Frequência","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[5,4,5,7],[5,0,5,2],[0,2,4,4]]}
[null,null,"  DIAGRAMA DE PARETO"]
[]
[]
[]
[]
["Tabela de Frequência",null,null,null,"Tabela de Frequências Ordenadas"]
[]
["Causas","Frequência","Frequência Normalizada",null,"Causas","Frequência","Frequência Normalizada","Frequência Acumulada"]
["Validade vencida",60.5,{"$f":"IF(ROW()-ROW($C$8)<=n,B9/SUM($B$9:$B$24),\"\")","v":0.30632911392405066},null,"Embalagem rasgada",75,{"$f":"IF(ROW()-ROW($C$8)<=n,F9/SUM($B$9:$B$24),\"\")","v":0.379746835443038},{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G9),\"\")","v":0.379746835443038}]
["Preparo inadequado",10,5.0632911392405063E-2,null,"Validade vencida",60.5,0.30632911392405066,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G10),\"\")","v":0.68607594936708871}]
["Embalagem rasgada",75,{"$f":"IF(ROW()-ROW($C$8)<=n,B11/SUM($B$9:$B$24),\"\")","v":0.379746835443038},null,"Pedido trocado",24,0.12151898734177215,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G11),\"\")","v":0.80759493670886084}]
["Pedido trocado",24,0.12151898734177215,null,"Pesagem incorreta",15,7.5949367088607597E-2,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G12),\"\")","v":0.8835443037974684}]
["Pesagem incorreta",15,7.5949367088607597E-2,null,"Falta de monitoramento",13,6.5822784810126586E-2,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G13),\"\")","v":0.949367088607595}]
["Falta de monitoramento",13,6.5822784810126586E-2,null,"Preparo inadequado",10,5.0632911392405063E-2,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G14),\"\")","v":1}]
[null,null,{"$f":"IF(ROW()-ROW($C$8)<=n,B15/SUM($B$9:$B$24),\"\")","v":0},null,null,null,0,{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G15),\"\")","v":1}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G16),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G17),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G18),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G19),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G20),\"\")","v":""}]
[null,null,{"$f":"IF(ROW()-ROW($C$8)<=n,B21/SUM($B$9:$B$24),\"\")","v":""},null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G21),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G22),\"\")","v":""}]
[null,null,"",null,null,null,"",{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G23),\"\")","v":""}]
[null,null,"",null,null,null,{"$f":"IF(ROW()-ROW($C$8)<=n,F24/SUM($B$9:$B$24),\"\")","v":""},{"$f":"IF(ROW()-ROW($G$8)<=n,SUM($G$9:G24),\"\")","v":""}]
[]
[]
[]
[]
[]
["Desenvolvido por Bruno Panarotte"]