{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RESOLVIDO2","RESOLVIDO","TAB_BD","AplicarFunção"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"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":"RESOLVIDO2","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["QTD","MATERIAL","Qtd",null,"A solução pretenda é esta:"]
[{"$f":"ROW(A1)","v":1},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B2,RESOLVIDO!$A$2:$A$7,0),A2)","v":"centeio"},null,"centeio"]
[{"$f":"IF(B2=B3,A2+1,1)","v":2},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B3,RESOLVIDO!$A$2:$A$7,0),A3)","v":"arroz"},null,"arroz"]
[{"$f":"IF(B3=B4,A3+1,1)","v":3},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B4,RESOLVIDO!$A$2:$A$7,0),A4)","v":"trigo"},null,"trigo"]
[4,"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B5,RESOLVIDO!$A$2:$A$7,0),A5)","v":"agua"},null,"agua"]
[1,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B6,RESOLVIDO!$A$2:$A$7,0),A6)","v":"esparguete"},null,"esparguete"]
[2,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B7,RESOLVIDO!$A$2:$A$7,0),A7)","v":"rolo"},null,"rolo"]
[3,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B8,RESOLVIDO!$A$2:$A$7,0),A8)","v":"cubos"},null,"cubos"]
[4,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B9,RESOLVIDO!$A$2:$A$7,0),A9)","v":"pevide"},null,"pevide"]
[5,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B10,RESOLVIDO!$A$2:$A$7,0),A10)","v":"pequena"},null,"pequena"]
[1,"arroz",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B11,RESOLVIDO!$A$2:$A$7,0),A11)","v":"cigala"},null,"cigala"]
[1,"fermento",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B12,RESOLVIDO!$A$2:$A$7,0),A12)","v":"neve"},null,"neve"]
[2,"fermento",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B13,RESOLVIDO!$A$2:$A$7,0),A13)","v":"trigo"},null,"trigo"]
[1,"ovos",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B14,RESOLVIDO!$A$2:$A$7,0),A14)","v":"galinha"},null,"galinha"]
[1,"colher",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B15,RESOLVIDO!$A$2:$A$7,0),A15)","v":"pau"},null,"pau"]

{"sheet":"RESOLVIDO","index":1,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["MATERIAL",1,2,3,4,5,6,7,8,10,null,"contar","MAX"]
["pão","centeio","arroz","trigo","agua","milho",null,null,null,null,null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A2)","v":4},{"$f":"MAX(L2:L7)","v":5}]
["massa","esparguete","rolo","cubos","pevide","pequena","redonda","triangular","quadrada","italiana",null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A3)","v":5}]
["arroz","cigala","sucesso","chines","japones","africano",null,null,null,null,null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A4)","v":1}]
["fermento","neve","trigo","agua","milho",null,null,null,null,null,null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A5)","v":2}]
["ovos","galinha","pato","cordeniz","ganso",null,null,null,null,null,null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A6)","v":1}]
["colher","pau","metal",null,null,null,null,null,null,null,null,{"$f":"COUNTIF(RESOLVIDO2!B:B,RESOLVIDO!A7)","v":1}]

{"sheet":"TAB_BD","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["QTD","MATERIAL","Qtd"]
[{"$f":"ROW(A1)","v":1},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B2,RESOLVIDO!$A$2:$A$7,0),A2)","v":"centeio"}]
[{"$f":"IF(B2=B3,A2+1,1)","v":2},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B3,RESOLVIDO!$A$2:$A$7,0),A3)","v":"arroz"}]
[{"$f":"IF(B3=B4,A3+1,1)","v":3},"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B4,RESOLVIDO!$A$2:$A$7,0),A4)","v":"trigo"}]
[4,"pão",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B5,RESOLVIDO!$A$2:$A$7,0),A5)","v":"agua"}]
[1,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B6,RESOLVIDO!$A$2:$A$7,0),A6)","v":"esparguete"}]
[2,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B7,RESOLVIDO!$A$2:$A$7,0),A7)","v":"rolo"}]
[3,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B8,RESOLVIDO!$A$2:$A$7,0),A8)","v":"cubos"}]
[4,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B9,RESOLVIDO!$A$2:$A$7,0),A9)","v":"pevide"}]
[5,"massa",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B10,RESOLVIDO!$A$2:$A$7,0),A10)","v":"pequena"}]
[1,"arroz",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B11,RESOLVIDO!$A$2:$A$7,0),A11)","v":"cigala"}]
[1,"fermento",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B12,RESOLVIDO!$A$2:$A$7,0),A12)","v":"neve"}]
[2,"fermento",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B13,RESOLVIDO!$A$2:$A$7,0),A13)","v":"trigo"}]
[1,"ovos",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B14,RESOLVIDO!$A$2:$A$7,0),A14)","v":"galinha"}]
[1,"colher",{"$f":"OFFSET(RESOLVIDO!$A$1,MATCH(B15,RESOLVIDO!$A$2:$A$7,0),A15)","v":"pau"}]

{"sheet":"AplicarFunção","index":3,"n_rows":7,"n_cols":22,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,11,6,11]]}
["MATERIAL",1,2,3,4,5,6,7,8,10,null,"Solução pretendida a ser preenchida na tabela ao lado->","MATERIAL",1,2,3,4,5,6,7,8,10]
["pão",null,null,null,null,null,null,null,null,null,null,null,"pão","centeio","arroz","trigo","agua","N/A","N/A","N/A","N/A","N/A"]
["massa",null,null,null,null,null,null,null,null,null,null,null,"massa","esparguete","rolo","cubos","pevide","pequena","N/A","N/A","N/A","N/A"]
["arroz",null,null,null,null,null,null,null,null,null,null,null,"arroz","cigala","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["fermento",null,null,null,null,null,null,null,null,null,null,null,"fermento","neve","trigo","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["ovos",null,null,null,null,null,null,null,null,null,null,null,"ovos","galinha","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
["colher",null,null,null,null,null,null,null,null,null,null,null,"colher","pau","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]