{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QUADRO DE CARGAS","CÁLCULOS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":"QUADRO DE CARGAS","index":0,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":false,"merged":[[104,1,104,10],[54,1,54,4],[87,3,87,4],[85,1,85,2],[81,3,81,5],[85,5,85,9],[2,1,2,10],[1,1,1,10],[95,1,95,8],[59,1,59,7],[93,1,93,8],[55,1,55,4],[56,1,56,4],[57,1,57,4],[57,6,57,7],[69,1,69,7],[63,1,63,5],[67,1,67,2],[61,1,61,4],[71,1,71,4],[79,1,79,4],[91,1,91,2]]}
[]
[null,"QUADRO DE CARGAS PARA CÁLCULO PRELIMINAR DA CARGA INSTALADA E DA DEMANDA ¹"]
[null,"OBS: Preencher somente campos em branco"]
[null,"Item","Descrição","Qtd","Potência (kW)","Carga Instalada  (kW)","FP","Carga Instalada (kVA)","FD","Demanda (kW)","Demanda (kVA)"]
[null,1,null,null,null,{"$f":"IF(E5=\"\",\"\",D5*E5)","v":""},null,{"$f":"IF(G5=\"\",\"\",F5/G5)","v":""},null,{"$f":"IF(I5=\"\",\"\",F5*I5)","v":""},{"$f":"IF(I5=\"\",\"\",H5*I5)","v":""}]
[null,2,null,null,null,{"$f":"IF(E6=\"\",\"\",D6*E6)","v":""},null,{"$f":"IF(G6=\"\",\"\",F6/G6)","v":""},null,{"$f":"IF(I6=\"\",\"\",F6*I6)","v":""},{"$f":"IF(I6=\"\",\"\",H6*I6)","v":""}]
[null,3,null,null,null,"",null,"",null,"",""]
[null,4,null,null,null,"",null,"",null,"",""]
[null,5,null,null,null,"",null,"",null,"",""]
[null,6,null,null,null,"",null,"",null,"",""]
[null,7,null,null,null,"",null,"",null,"",""]
[null,8,null,null,null,"",null,"",null,"",""]
[null,9,null,null,null,"",null,"",null,"",""]
[null,10,null,null,null,"",null,"",null,"",""]
[null,11,null,null,null,"",null,"",null,"",""]
[null,12,null,null,null,"",null,"",null,"",""]
[null,13,null,null,null,"",null,"",null,"",""]
[null,14,null,null,null,"",null,"",null,"",""]
[null,15,null,null,null,"",null,"",null,"",""]
[null,16,null,null,null,"",null,"",null,"",""]
[null,17,null,null,null,"",null,"",null,"",""]
[null,18,null,null,null,"",null,"",null,"",""]
[null,19,null,null,null,"",null,"",null,"",""]
[null,20,null,null,null,"",null,"",null,"",""]
[null,21,null,null,null,"",null,"",null,"",""]
[null,22,null,null,null,"",null,"",null,"",""]
[null,23,null,null,null,"",null,"",null,"",""]
[null,24,null,null,null,"",null,"",null,"",""]
[null,25,null,null,null,"",null,"",null,"",""]
[null,26,null,null,null,"",null,"",null,"",""]
[null,27,null,null,null,"",null,"",null,"",""]
[null,28,null,null,null,"",null,"",null,"",""]
[null,29,null,null,null,"",null,"",null,{"$f":"IF(I33=\"\",\"\",F33*I33)","v":""},{"$f":"IF(I33=\"\",\"\",H33*I33)","v":""}]
[null,30,null,null,null,"",null,"",null,"",""]
[null,31,null,null,null,"",null,"",null,"",""]
[null,32,null,null,null,"",null,"",null,"",""]
[null,33,null,null,null,"",null,"",null,"",""]
[null,34,null,null,null,"",null,"",null,"",""]
[null,35,null,null,null,"",null,"",null,"",""]
[null,36,null,null,null,"",null,"",null,"",""]
[null,37,null,null,null,"",null,"",null,"",""]
[null,38,null,null,null,"",null,"",null,"",""]
[null,39,null,null,null,"",null,"",null,"",""]
[null,40,null,null,null,"",null,"",null,"",""]
[null,41,null,null,null,"",null,"",null,"",""]
[null,42,null,null,null,"",null,"",null,"",""]
[null,43,null,null,null,"",null,"",null,"",""]
[null,44,null,null,null,"",null,"",null,"",""]
[null,45,null,null,null,"",null,"",null,"",""]
[null,46,null,null,null,"",null,"",null,"",""]
[null,47,null,null,null,"",null,"",null,"",""]
[null,48,null,null,null,"",null,"",null,"",""]
[null,49,null,null,null,"",null,"",null,"",""]
[null,50,null,null,null,"",null,"",null,"",""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F5:F54)","v":0},null,{"$f":"SUM(H5:H54)","v":0},null,{"$f":"SUM(J5:J54)","v":0},{"$f":"SUM(K5:K54)","v":0}]
[null,"FATOR DE DEMANDA DA ATIVIDADE"]
[null,"FATOR DE POTÊNCIA DE REFERÊNCIA",null,null,null,0.92]
[null,"FATOR DE POTÊNCIA MÉDIO DA INSTALAÇÃO ",null,null,null,{"$f":"IFERROR(J55/K55,\" \")","v":" "}]
[]
[null,"METODOLOGIAS PARA CÁLCULO DA DEMANDA CONFORME NT.31.002:",null,null,null,null,null,null,null,"Demanda Calculada (kVA)","Transformador Recomendado (kVA)"]
[null,null,null,null,null,null,null,null,null,"Até 33",30]
[null,"1. METODOLOGIA 1 - RECOMENDADA",null,null,null,null,null,null,null,"34 a 49",45]
[null,null,null,null,null,null,null,null,null,"50 a 82",75]
[null,"D = Da + Db + Dc + Dd + De = D(kVA) Total da Planilha acima",null,null,null,null,null,null,null,"83 a 124",112.5]
[null,null,null,null,null,null,null,null,null,"125 a 165",150]
[null,"D (kVA)",{"$f":"K55","v":0},null,null,null,null,null,null,"166 a 248",225]
[null,null,null,null,null,null,null,null,null,"249 a 330",300]
[null,"TRANSFORMADOR: ",null,{"$f":"IF(C66=0,\"\",IF(C66<=33,K61,IF(C66<=49,K62,IF(C66<=82,K63,IF(C66<=124,K64,IF(C66<=165,K65,IF(C66<=248,K66,IF(C66<=330,K67,IF(C66<=550,K68,IF(C66<=825,K69,IF(C66<=1100,K70,IF(C66<=1375,K71,IF(C66<=1650,K72,IF(C66<=2200,K73,IF(C66<=2500,K74,\"\")))))))))))))))","v":""},"kVA",null,null,null,null,"334 a 550",500]
[null,null,null,null,null,null,null,null,null,"551 a 825",750]
[null,"2. METODOLOGIA 2 - Alternativa (sujeita análise de sua aplicação, conforme o caso)",null,null,null,null,null,null,null,"826 a 1100",1000]
[null,null,null,null,null,null,null,null,null,"1101 a 1375",1250]
[null,"D (kW) = CI (kW) * FD da Atividade",null,null,null,null,null,null,null,"1376 a 1650",1500]
[null,null,null,null,null,null,null,null,null,"1651 a 2200",2000]
[null,"CI (kW)",{"$f":"F55","v":0},null,null,null,null,null,null,"2201 a 2717",2500]
[]
[null,"FD",{"$f":"F56","v":0}]
[]
[null,"D (kW)",{"$f":"C74*C76","v":0}]
[]
[null,"D (kVA) = D (kW) / FP"]
[]
[null,"FP",{"$f":"F57","v":0.92},"Fator de Potência de Referência"]
[]
[null,"D (kVA)",{"$f":"C78/C82","v":0}]
[]
[null,"TRANSFORMADOR: ",null,{"$f":"IF(C84=0,\"\",IF(C84<=33,K61,IF(C84<=49,K62,IF(C84<=82,K63,IF(C84<=124,K64,IF(C84<=165,K65,IF(C84<=248,K66,IF(C84<=330,K67,IF(C84<=550,K68,IF(C84<=825,K69,IF(C84<=1100,K70,IF(C84<=1375,K71,IF(C84<=1650,K72,IF(C84<=2200,K73,IF(C84<=2500,K74,\"\")))))))))))))))","v":""},"kVA","Pelo FP de Referência (corrigido ou sem necessidade de correção)"]
[]
[null,"FP",{"$f":"F58","v":" "},"Fator de Potência Médio"]
[]
[null,"D (kVA)",{"$f":"IFERROR(C78/C88,\" \")","v":" "}]
[]
[null,"TRANSFORMADOR: ",null,{"$f":"IF(C90=0,\"\",IF(C90<=33,K61,IF(C90<=49,K62,IF(C90<=82,K63,IF(C90<=124,K64,IF(C90<=165,K65,IF(C90<=248,K66,IF(C90<=330,K67,IF(C90<=550,K68,IF(C90<=825,K69,IF(C90<=1100,K70,IF(C90<=1375,K71,IF(C90<=1650,K72,IF(C90<=2200,K73,IF(C90<=2500,K74,\"\")))))))))))))))","v":""},"kVA","Pelo FP Médio (sem correção)"]
[]
[null,"METODOLOGIA PARA CORREÇÃO DO FATOR DE POTÊNCIA CONFORME NT.31.002:"]
[]
[null,"QC (kVAr) = Q1 - Q2 = P (kW) * Δ tg φ = kW * [ tg (φ1) - tg (φ2) ] = kW * { tg [acos (FP1)] - tg [acos (FP2)] }"]
[]
[null,"CI (kW)",{"$f":"F55","v":0}]
[null,"D (kW)",{"$f":"J55","v":0}]
[null,"Δ tg φ",{"$f":"IFERROR(TAN(ACOS(F58))-TAN(ACOS(F57)),\" \")","v":" "}]
[]
[null,"QC",{"$f":"IFERROR(C98*C100,\" \")","v":" "},"kVAr","Pela carga instalada"]
[]
[null,"QC",{"$f":"IFERROR(C99*C100,\" \")","v":" "},"kVAr","Pela demanda"]
[null,"¹ Os cálculos definitivos devem seguir conforme projeto elétrico realizado por profissional devidamente habilitado."]

{"sheet":"CÁLCULOS","index":1,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,1,59,9],[48,1,48,8],[50,1,50,8],[38,5,38,7],[34,3,34,5],[38,1,38,2],[39,1,39,5],[41,3,41,4],[45,5,45,7],[45,1,45,2],[1,2,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[8,1,8,4],[6,1,7,6],[32,1,32,4],[4,6,4,7],[24,1,24,4],[10,1,10,5],[22,1,22,7],[14,5,14,7],[19,5,19,7],[15,1,15,5]]}
[]
[null,"TOTAL",null,null,null,{"$f":"'QUADRO DE CARGAS'!F55","v":0},null,{"$f":"'QUADRO DE CARGAS'!H55","v":0},null,{"$f":"'QUADRO DE CARGAS'!J55","v":0},{"$f":"'QUADRO DE CARGAS'!K55","v":0}]
[null,"FATOR DE DEMANDA DA ATIVIDADE",null,null,null,{"$f":"'QUADRO DE CARGAS'!F56","v":0}]
[null,"FATOR DE POTÊNCIA DE REFERÊNCIA",null,null,null,{"$f":"'QUADRO DE CARGAS'!F57","v":0.92}]
[null,"FATOR DE POTÊNCIA MÉDIO DA INSTALAÇÃO ",null,null,null,{"$f":"'QUADRO DE CARGAS'!F58","v":" "}]
[]
[null,"METODOLOGIAS PARA CÁLCULO PRELIMINAR DE DEMANDA CONFORME NT.002 ¹",null,null,null,null,null,null,null,"Demanda Calculada (kVA)","Transformador Recomendado (kVA)"]
[null,null,null,null,null,null,null,null,null,"60 a 82",75]
[null,"1. METODOLOGIA 1 - RECOMENDADA",null,null,null,null,null,null,null,"83 a 124",112.5]
[null,null,null,null,null,null,null,null,null,"125 a 165",150]
[null,"D = Da + Db + Dc + Dd + De = D(kVA) Total da Planilha acima",null,null,null,null,null,null,null,"166 a 248",225]
[null,null,null,null,null,null,null,null,null,"249 a 330",300]
[null,"D corrigida (kVA)",{"$f":"IF(F5<F4,ROUND(J2/F4,0),\"\")","v":""},{"$f":"IF(F5=\" \", \" \", IF(F5<F4,\" \",\"SEM NECESSIDADE DE CORREÇÃO, FP>=0,92\"))","v":" "},null,null,null,null,null,"334 a 550",500]
[null,null,null,null,null,null,null,null,null,"551 a 825",750]
[null,"TRANSFORMADOR: ",null,{"$f":"IF('QUADRO DE CARGAS'!J55>2500,\" \",IF(C13=0,\"\",IF(C13<60,\"Atendimento em BT\",IF(AND(C13>=60,C13<=82.9),K8,IF(AND(C13>83.1,C13<=124.9),K9,IF(AND(C13>125,C13<=165.9),K10,IF(AND(C13>166,C13<=248.9),K11,IF(AND(C13>249,C13<=333.9),K12,IF(AND(C13>334,C13<=550.9),K13,IF(AND(C13>551,C13<=825.9),K14,IF(AND(C13>826,C13<=1100.9),K15,IF(AND(C13>1101,C13<=1375.9),K16,IF(AND(C13>1376,C13<=1650.9),K17,IF(AND(C13>1651,C13<=2200.9),K18,IF(AND(C13>2201,C13<=2717),K19,\"\")))))))))))))))","v":""},"kVA",{"$f":"IF(D15=\"\",\"\",IF('QUADRO DE CARGAS'!J55>2500,\"ATENDIMENTO EM 69 kV\",IF(C13>2717,\"ATENDIMENTO EM 69 kV\",\"\")))","v":""},null,null,null,"826 a 1100",1000]
[null,"Pelo FP de Referência (corrigido ou sem necessidade de correção)",null,null,null,null,null,null,null,"1101 a 1375",1250]
[null,null,null,null,null,null,null,null,null,"1376 a 1650",1500]
[null,"D (kVA)",{"$f":"IFERROR(ROUND(J2/F5,0),0)","v":0},null,null,null,null,null,null,"1651 a 2200",2000]
[null,null,null,null,null,null,null,null,null,"2201 a 2717",2500]
[null,"TRANSFORMADOR: ",null,{"$f":"IF('QUADRO DE CARGAS'!J55>2500,\" \",IF(C18=0,\"\",IF(C18<60,\"Atendimento em BT\",IF(AND(C18>=60,C18<=82.9),K8,IF(AND(C18>83.1,C18<=124.9),K9,IF(AND(C18>125,C18<=165.9),K10,IF(AND(C18>166,C18<=248.9),K11,IF(AND(C18>249,C18<=333.9),K12,IF(AND(C18>334,C18<=550.9),K13,IF(AND(C18>551,C18<=825.9),K14,IF(AND(C18>826,C18<=1100.9),K15,IF(AND(C18>1101,C18<=1375.9),K16,IF(AND(C18>1376,C18<=1650.9),K17,IF(AND(C18>1651,C18<=2200.9),K18,IF(AND(C18>2201,C18<=2717),K19,\"\")))))))))))))))","v":""},"kVA",{"$f":"IF('QUADRO DE CARGAS'!J55>2500,\"ATENDIMENTO EM 69 kV\",IF(C18>2717,\"ATENDIMENTO EM 69 kV\",\" \"))","v":" "}]
[null,"Pelo FP Médio (sem correção)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"METODOLOGIA PARA CORREÇÃO DO FATOR DE POTÊNCIA CONFORME NT.002:"]
[]
[null,"QC (kVAr) = Q1 - Q2 = P (kW) * Δ tg φ = kW * [ tg (φ1) - tg (φ2) ] = kW * { tg [acos (FP1)] - tg [acos (FP2)] }"]
[]
[null,"CI (kW)",{"$f":"F2","v":0}]
[null,"D (kW)",{"$f":"J2","v":0}]
[null,"Δ tg φ",{"$f":"IF('QUADRO DE CARGAS'!F57>='QUADRO DE CARGAS'!F58,TAN(ACOS(F5))-TAN(ACOS(F4)),0)","v":0}]
[]
[null,"QC",{"$f":"IFERROR(C53*C55,\" \")","v":0},"kVAr","Pela carga instalada"]
[null,null,null,null,{"$f":"IF(F5=\" \", \" \",IF(F5<F4,\" \",\"SEM NECESSIDADE DE CORREÇÃO, FP>=0,92\"))","v":" "}]
[]
[null,{"$f":"'QUADRO DE CARGAS'!B105:K105","v":"¹ Os cálculos definitivos devem seguir conforme projeto elétrico realizado por profissional devidamente habilitado."}]