{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Opção 1","Opção 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Opção 1","index":0,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,8,5,12],[0,1,0,7],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7]]}
[null,"CÁLCULO PROPORCIONAL DE CONSUMOS PARA FORMAÇÃO DOS CUSTOS"]
[null,"Referência","Grade","Peso","Desperdício\nem kg","Qtde\nPeças","Consumo\nkg/peça","Consumo\nm/peça",null,"Qtde de Folhas:",null,{"$f":"IF(K2=0,\"\",IF(O4=1,\"(simples)\",\"(dupla)\"))","v":""}]
[null,null,null,null,null,null,null,null,null,"Compr. Enfesto:",null,{"$f":"IF(K3=0,\"\",\"( \"&K3*100&\" cm )\")","v":""}]
["1 - ",null,null,null,{"$f":"IF($D$15=0,0,$D$15/$D$14*D4)","v":0},{"$f":"C4*$K$2*$O$4","v":0},{"$f":"IF(C4=0,0,IF(D4=0,0,IF($K$2=0,0,IF($D$15=0,0,(D4+E4)/F4))))","v":0},{"$f":"IF($K$2=0,0,IF($K$3=0,0,IF(C4=0,0,IF(D4=0,0,($K$4/$D$16*(D4+E4))/F4))))","v":0},null,"Total Metros:",{"$f":"K3*K2*O4","v":0},null,null,null,2]
["2 - ",null,null,null,0,0,{"$f":"IF(C5=0,0,IF(D5=0,0,IF($K$2=0,0,IF($D$15=0,0,(D5+E5)/F5))))","v":0},{"$f":"IF($K$2=0,0,IF($K$3=0,0,IF(C5=0,0,IF(D5=0,0,($K$4/$D$16*(D5+E5))/F5))))","v":0},{"$f":"IF(AND(O4=1,O12=1),\"*** OPA! Não poderá informar meia folha com a opção ' Impar '. ***\",IF(O13=2,\"*** Foi informado meia Grade, não poderá informar meia folha. ***\",IF(O4=2,\"\",IF(O15=1,\"ATENÇÃO! Foi informado meia Grade e a opção está com ' Folha Impar ', neste caso não pode existir meio molde no encaixe.\",\"\"))))","v":""}]
["3 - ",null,null,null,0,0,0,0]
["4 - ",null,null,null,0,0,0,0]
["5 - ",null,null,null,0,0,0,0]
["6 - ",null,null,null,0,0,0,0]
["7 - ",null,null,null,0,0,0,0]
["8 - ",null,null,null,0,0,0,0,null,null,null,null,null,null,{"$f":"ROUNDUP(K2,0)","v":0}]
["9 - ",null,null,null,0,0,0,0,null,null,null,null,null,null,{"$f":"IF(K2<>O11,1,0)","v":0}]
["10 - ",null,null,null,0,0,0,0,null,null,null,null,null,null,{"$f":"O12+O15","v":0}]
[null,"Totais =>",{"$f":"SUM(C4:C13)","v":0},{"$f":"SUM(D4:D13)","v":0},{"$f":"SUM(E4:E13)","v":0},{"$f":"SUM(F4:F13)","v":0},null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(C14,0)","v":0}]
[null,null,"Peso do desperdício =>",null,{"$f":"IF(D15=0,0,D15/D16)","v":0},{"$f":"IF(D15=0,0,D15/D14)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(C14<>O14,1,0)","v":0}]
[null,null,"Peso Total =>",{"$f":"D14+D15","v":0}]

{"sheet":"Opção 2","index":1,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7]]}
[null,"CÁLCULO PROPORCIONAL DE CONSUMOS PARA FORMAÇÃO DOS CUSTOS"]
[null,"Referência","Grade","Peso","Desperdício\nem kg","Qtde\nPeças","Consumo\nkg/peça","Consumo\nm/peça",null,"Total Metros:"]
[]
["1 - ",null,null,null,{"$f":"IF($D$15=0,0,$D$15/$D$14*D4)","v":0},null,{"$f":"IF(D4=0,0,IF(F4=0,0,IF($D$15=0,0,(D4+E4)/F4)))","v":0},{"$f":"IF($K$2=0,0,IF(F4=0,0,IF(D4=0,0,($K$2/$D$16*(D4+E4))/F4)))","v":0},null,null,null,null,null,null,2]
["2 - ",null,null,null,{"$f":"IF($D$15=0,0,$D$15/$D$14*D5)","v":0},null,{"$f":"IF(D5=0,0,IF(F5=0,0,IF($D$15=0,0,(D5+E5)/F5)))","v":0},{"$f":"IF($K$2=0,0,IF(F5=0,0,IF(D5=0,0,($K$2/$D$16*(D5+E5))/F5)))","v":0}]
["3 - ",null,null,null,0,null,0,0]
["4 - ",null,null,null,0,null,0,0]
["5 - ",null,null,null,0,null,0,0]
["6 - ",null,null,null,0,null,0,0]
["7 - ",null,null,null,0,null,0,0]
["8 - ",null,null,null,0,null,0,0,null,null,null,null,null,null,{"$f":"ROUNDUP(#REF!,0)","v":{"$error":"#REF!"}}]
["9 - ",null,null,null,0,null,0,0,null,null,null,null,null,null,{"$f":"IF(#REF!<>O11,1,0)","v":{"$error":"#REF!"}}]
["10 - ",null,null,null,0,null,0,0,null,null,null,null,null,null,{"$f":"O12+O15","v":{"$error":"#REF!"}}]
[null,"Totais =>",{"$f":"SUM(C4:C13)","v":0},{"$f":"SUM(D4:D13)","v":0},{"$f":"SUM(E4:E13)","v":0},{"$f":"SUM(F4:F13)","v":0},null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(C14,0)","v":0}]
[null,null,"Peso do desperdício =>",null,{"$f":"IF(D15=0,0,D15/D16)","v":0},{"$f":"IF(D15=0,0,D15/D14)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(C14<>O14,1,0)","v":0}]
[null,null,"Peso Total =>",{"$f":"D14+D15","v":0}]