{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["QUADRO DE CARGAS","SE AÉREA","GERAL","CÁLCULOS","TAB 02","TAB 03","TAB 04","TAB 19","TAB 25","Para Raios"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":1,"defined_names":5,"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":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[59,1,59,10],[1,1,1,10],[56,1,56,4],[57,1,57,4],[58,1,58,4],[55,1,55,4],[2,1,2,8],[57,6,58,10]]}
[]
[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,"",{"$f":"IF(I32=\"\",\"\",H32*I32)","v":""}]
[null,29,null,null,null,"",null,"",null,"",""]
[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,"",""]
[55,null,null,null,null,{"$f":"IF(E55=\"\",\"\",D55*E55)","v":""},null,{"$f":"IF(G55=\"\",\"\",F55/G55)","v":""},null,{"$f":"IF(I55=\"\",\"\",F55*I55)","v":""},""]
[null,"TOTAL",null,null,null,{"$f":"SUM(F5:F55)","v":0},null,{"$f":"SUM(H5:H55)","v":0},null,{"$f":"SUM(J5:J55)","v":0},{"$f":"SUM(K5:K55)","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(F56/H56,\" \")","v":" "}]
[null,"¹ Os cálculos definitivos devem seguir conforme projeto elétrico realizado por profissional devidamente habilitado."]
[null,57]
[null,58]
[null,59]
[null,60]
[null,61]
[null,62]
[null,63]
[null,64]
[null,65]
[null,66]
[null,67]
[null,68]
[null,69]
[null,70]
[null,71]
[null,72]

{"sheet":"SE AÉREA","index":1,"n_rows":273,"n_cols":42,"rows_kept":273,"cut":false,"hidden":false,"merged":[[24,0,31,0],[29,1,29,5],[56,6,56,7],[62,1,62,3],[62,4,62,5],[35,2,36,3],[35,1,36,1],[47,0,55,0],[48,1,48,4],[50,1,50,2],[52,1,52,2],[38,6,39,6],[39,1,40,3],[32,0,46,0],[43,1,44,6],[71,0,92,0],[78,4,79,4],[80,4,81,4],[88,3,88,4],[89,1,90,5],[0,0,0,8],[3,1,4,1],[6,1,7,1],[9,1,10,1],[3,2,4,8],[1,0,23,0],[6,2,7,8],[9,2,10,8],[12,1,12,3],[22,2,22,3],[23,2,23,6],[17,1,17,3],[18,5,20,8],[67,1,67,3],[54,1,54,6],[39,4,40,4],[120,6,120,7],[56,0,70,0],[63,1,63,2],[93,0,105,0],[104,1,105,8],[108,0,144,0],[126,4,126,5],[127,4,127,5],[121,6,121,7],[130,5,131,8],[115,4,116,4],[115,2,116,2],[136,6,136,7],[137,6,137,7],[161,22,161,28],[171,39,171,42],[143,1,143,8],[158,22,158,28],[159,22,159,28],[160,22,160,28]]}
["                                   CÁLCULO E PARÂMETROS PRELIMINARES DE DIMENSIONAMENTO DE SUBESTAÇÃO AEREA ¹"]
["PARÂMETROS DE ENTRADA","I - DADOS DO CLIENTE"]
[]
[null,"Nome Cliente"]
[]
[]
[null,"Endereço "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34.5,"380/220"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.8,"220/127"]
[null,"Contatos ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23.1]
[]
[]
[null,"Especifique as tensões primárias e secundárias"]
[null,"Tensão Primária",null,"kV"]
[]
[null,"Tensão Secundário",null,"V"]
[]
[]
[null,"Carga Instalada",{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF('QUADRO DE CARGAS'!H56=0,\" \",CONCATENATE(ROUND('QUADRO DE CARGAS'!H56,2),\" kVA\")))","v":""},{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF('QUADRO DE CARGAS'!F56=0,\" \",CONCATENATE(ROUND('QUADRO DE CARGAS'!F56,2),\" kW\")))","v":""},null,"Preencha o Quadro de Cargas com seus respectivos valores na aba \"QUADRO DE CARGAS\""]
[]
[null,"Demanda",{"$f":"IF(C19=\"\",\"\",IF('QUADRO DE CARGAS'!K56=0,\" \",CONCATENATE(ROUND('QUADRO DE CARGAS'!K56,2),\" kVA\")))","v":""},{"$f":"IF(C19=\"\",\"\",IF('QUADRO DE CARGAS'!J56=0,\" \",CONCATENATE(ROUND('QUADRO DE CARGAS'!J56,2),\" kW\")))","v":""}]
[]
[null,"Tipo do Eletroduto","AÇO GALVANIZADO"]
[]
["Tabela 25 - NT.002","II - CORREÇÃO DE EXCEDENTE REATIVO - CÁLCULO DE CAPACITOR"]
[]
[null,"Fator de Potência Médio",{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF('QUADRO DE CARGAS'!F59=0,\" \",'QUADRO DE CARGAS'!F59))","v":""}]
[null,"Fator de Potência Referência",{"$f":"IF(C19=\" \",\" \",IF('QUADRO DE CARGAS'!F58=0,\" \",'QUADRO DE CARGAS'!F58))","v":0.92}]
[]
[null,"Potência reativa do (s) Banco (s) de Capacitor (es) para correção do fator de potência"]
[null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF(C19=\" \",\" \",CÁLCULOS!C26))","v":""},"kVAr"]
[]
["Tabela 4 - NT.002","III - CÁLCULO DO TRANSFORMADOR"]
[null,null,{"$f":"IF(CÁLCULOS!C13=0,\" \",CONCATENATE(ROUND(CÁLCULOS!C13,2),\" kVA\"))","v":" "}]
[null,{"$f":"IF(CÁLCULOS!C13>330,\"Consultar NT.31.002.06\",CÁLCULOS!C13)","v":0}]
[null,"Transformador Recomendado",{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF(B35=\"Consultar NT.31.002.06\",\"SE Abrigada NT.31.002\",IF('QUADRO DE CARGAS'!K56=0,\" \",IF('QUADRO DE CARGAS'!K56<60,CÁLCULOS!D15,CONCATENATE(CÁLCULOS!D15,\" kVA\")))))","v":""},null,null,null,"POSTE (m)"]
[null,null,null,null,null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF(B35=0,\" \",IF(B35=\"Consultar NT.31.002.06\",\" \",IFERROR(VLOOKUP(CÁLCULOS!D15,GERAL!A12:D16,4,TRUE),\"11\"))))","v":""}]
[]
[null,null,null,null,null,null,"ESFORÇO (daN)"]
[null,"Potência Mínima do Banco de Capacitores (kVAr) quando o transformador está operando a vazio ou com carga muito baixa",null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(G37=\" \",\" \",CONCATENATE(VLOOKUP(CÁLCULOS!D15,GERAL!A21:B29,2,FALSE),\" kVAr\")),\" \"))","v":""},null,null,null,""]
[null,null,null,null,null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF(G37=\" \",\" \",IFERROR(VLOOKUP(CÁLCULOS!D15,GERAL!A12:D16,3,TRUE),300)))","v":""}]
[]
[]
[null,"NOTA: Deve ser projetado e dimensionado bancos de capacitores fixos instalados na baixa tensão para compensação do fator de potência quando o transformador está operando a vazio ou carga muito baixa."]
[]
[]
[]
["Tabela 2 - NT.002","IV - CÁLCULO DO ELO FUSÍVEL"]
[]
[]
[null,"Elo fusível recomendado para Transformador",null,{"$f":"IF(G37=\" \",\" \",IF(C14=13.8,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:F24,2,0),IF(C14=34.5,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:F24,3,0),IF(C14=23.1,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:F24,6,0)))))","v":false}]
[]
[null,"Elo fusível recomendado para Ponto de derivação",null,{"$f":"IF(G37=\" \",\" \",IF(C14=13.8,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:E24,4,0),IF(C14=34.5,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:E24,5,0),IF(C14=23.1,VLOOKUP(CÁLCULOS!D15,'TAB 02'!A11:F24,6,0)))))","v":false}]
[]
[null,"NOTA: Não será utilizada chave fusível em transformador particular, salvo nas situações em que o ponto de derivação fique a uma distância superior a 30 m do ponto de entrega. A chave fusível é obrigatória em subestações localizadas em áreas classificadas como rurais."]
[]
["Tabelas 3 e 3A - NT.002","V - DIMENSIONAMENTO DOS CIRCUITOS SECUNDÁRIO"]
[]
[null,"Corrente Secundária (A)",{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF($C$16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!$A$16:$M$22,3,TRUE),VLOOKUP(CÁLCULOS!D15,'TAB 03'!$P$15:$AB$21,3,TRUE))),\" \"))","v":""},"A"]
[]
[null,"Disjuntor",{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF(C16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!A16:M22,5,TRUE),VLOOKUP(CÁLCULOS!D15,'TAB 03'!P15:AB21,5,TRUE))),\" \"))","v":""},"A"]
[]
[null,"Cabos de cobre com isolação termofixa (XLPE) 0,6/1kV (mm²)",null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF($C$16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!$A$16:$M$22,7,TRUE),VLOOKUP(CÁLCULOS!D15,'TAB 03'!$P$15:$AB$21,7,TRUE))),\" \"))","v":""}]
[null,"Eletroduto de Aço Galvanizado com Diâmetro nominal mm (pol)",null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF($C$16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!$A$16:$M$22,9,TRUE),VLOOKUP(CÁLCULOS!D15,'TAB 03'!$P$15:$AB$21,9,TRUE))),\" \"))","v":""}]
[]
[]
[]
[null,"Condutor de Aterramento"]
[null,"Cobre (mm²)","Aço Cobreado (AWG)"]
[null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF($C$16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!$A$16:$M$22,11,TRUE),VLOOKUP(CÁLCULOS!D15,'TAB 03'!$P$15:$AB$21,11,TRUE))),\" \"))","v":""},{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IFERROR(IF(C19=\" \",\" \",IF($C$16=\"380/220\",VLOOKUP(CÁLCULOS!D15,'TAB 03'!$A$17:$M$22,13,0),VLOOKUP(CÁLCULOS!D15,'TAB 03'!$P$15:$AB$21,13,0))),\" \"))","v":""}]
[]
["Tabela 3 - NT.31.002.06","VI - CÁLCULO DO ELETRODUTO"]
[]
[]
[null,{"$f":"VLOOKUP(#REF!,#REF!,2,FALSE)","v":{"$error":"#REF!"}},{"$f":"#REF!*4","v":{"$error":"#REF!"}},"Cabos"]
[null,"Circuito por Eletroduto ",{"$f":"#REF!","v":{"$error":"#REF!"}},"Circuitos"]
[null,"Num mesmo Eletroduto",{"$f":"4*#REF!","v":{"$error":"#REF!"}},"Cabos"]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(C81,#REF!,2,TRUE)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,{"$f":"SQRT(((G67*G67)*4*#REF!)/0.4)","v":{"$error":"#REF!"}},"mm"]
[]
[]
[null,"                       n","Número de cabos no Eletroduto"]
[null,"                       t","Taxa de ocupação do Eletroduto"]
[]
[null,"ELETRODUTO(s) DE",{"$f":"VLOOKUP(C68,#REF!,5,FALSE)","v":{"$error":"#REF!"}},null,null,null,{"$f":"VLOOKUP($H$78,#REF!,2,FALSE)","v":{"$error":"#REF!"}},null,{"$f":"VLOOKUP($H$78,#REF!,2,FALSE)","v":{"$error":"#REF!"}}]
[]
[null,{"$f":"IF(C89>1,\"SERÃO INSTALADOS\",\"SERÁ INSTALADO\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP((#REF!/#REF!),#REF!,2,TRUE)","v":{"$error":"#REF!"}},"ELETRODUTO(s) DE",null,{"$f":"VLOOKUP(C68,#REF!,5,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"C23","v":"AÇO GALVANIZADO"},null,null,null,null,null,{"$f":"H78+G87+I87","v":{"$error":"#REF!"}}]
[]
[]
[]
["PROTEÇÃO BT","VI - CÁLCULO DO DISJUNTOR - sugestão"]
[]
[]
[null,"            CORRENTE  ",{"$f":"IF(C16=\"380/220\",C34/(SQRT(3)*0.38),C34/(SQRT(3)*0.22))","v":{"$error":"#VALUE!"}},"A"]
[]
[]
[]
[null,"DE ACORDO COM A CORRENTE ANTERIORMENTE CALCULADA O MÁXIMO VALOR PARA O DISJUNTOR TERMOMAGNÉTICO"]
[]
[]
[null,"SERÁ",null,3,{"$f":"IF(C16=\"380/220\",VLOOKUP(C97,'[1]TAB 03'!A16:M23,5,TRUE),VLOOKUP(C97,'[1]TAB 03'!P15:AB21,5,TRUE))","v":{"$error":"#VALUE!"}},"A"]
[null,"Obs: Dimensionar o Cabo após o Disjuntor com um valor coerente a ele, de acordo com a NBR.5410"]
[]
[]
[]
["DIAGRAMA UNIFILAR","VI - DIAGRAMA UNIFILAR DO POSTO DE TRANSFORMAÇÃO"]
[]
[]
[]
[]
[]
[null,null,"3 Pára-Raios MT",null,"3 Pára-Raios BT"]
[null,null,{"$f":"IF(C14=13.8,\"12 kV   10 kA\",IF(C14=34.5,IF(C16=\"380/220\",\"30 kV   10 kA\",\"30 kV   10 kA\"),\"21kV 10kA \"))","v":"21kV 10kA "},null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",IF(C16=0,\" \",\"280 V   10 kA\"))","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,"Eletroduto"]
[null,null,null,null,null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",D64)","v":""}]
[null,{"$f":"D53","v":false},{"$f":"D51","v":false},{"$f":"C36","v":""},null,null,"AÇO GALVANIZADO"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",C61)","v":""}]
[]
[]
[null,null,null,null,null,"CABOS ISOLADO 0,6/1,0KV - \nXLPE, EPR ou HEPR 90° Proteção Anti-UV"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(C14=\"\",C16=\"\"),\"\",E63)","v":""},null,"(mm²)"]
[]
[null,null,{"$f":"IF(C14=0,\" \",CONCATENATE(C14,\" kV\"))","v":" "},null,{"$f":"IF(C16=0,\" \",CONCATENATE(C16,\" V\"))","v":" "}]
[]
[null,"REDE AÉREA EQUATORIAL",{"$f":"IF(C14=0,\" \",C14)","v":" "},"KV",null,"POSTE (m)","ESFORÇO MÍNIMO (daN)"]
[null,null,null,null,null,{"$f":"G37","v":""},{"$f":"G41","v":""}]
[]
[]
[]
[null,{"$f":"'QUADRO DE CARGAS'!B60:K60","v":"¹ Os cálculos definitivos devem seguir conforme projeto elétrico realizado por profissional devidamente habilitado."}]
[]
[null,"NORMAS UTILIZADAS NA ELABORAÇÃO DESTA PLANILHA DE CÁLCULO NT.002.EQTL.Normas e Padrões / NBR5410 / NBR14039 "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CABOS ISOLADO 0,6/1,0KV - XLPE 90° PROTEÇÃO ANTI-UV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CABOS ISOLADO 0,6/1,0KV - EPR 90° PROTEÇÃO ANTI-UV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOTD - Serviços da Distribuição Sudeste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CABOS ISOLADO 0,6/1,0KV - HEPR 90° PROTEÇÃO ANTI-UV",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DODD - Serviços da Distribuição Nordeste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOLD - Serviços da Distribuição Noroeste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOBD - Serviços da Distribuição Baixada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DOSD - Serviços da Distribuição Oeste"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DUTO",null,"tensão","FD","tensão (elos)","taxa",null,"CORRÇÃO DE FP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PVC RÍGIDO",null,"220/127",0.01,13.8,0.1,null,"BANCO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AÇO GALVANIZADO",null,"380/220",0.02,34.5,0.2,null,"MÓDULO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.04,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.06,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,null,0.7,null,"Cabos / Fase","FATOR Y","FATOR X"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.08,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.09,null,0.9,null,1,{"$f":"IF(#REF!=$AP$182,\"(A)\",\"\")","v":{"$error":"#REF!"}},"CABOS ISOLADO 0,6/1,0KV - XLPE 90° PROTEÇÃO ANTI-UV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONDUTORES - TENSÃO DE ISOLAMENTO 450/750V - PVC 70°C",null,null,0.1,null,1,null,2,{"$f":"IF(#REF!<>$AP$182,\"(B)\",\"\")","v":{"$error":"#REF!"}},"CABOS ISOLADO 0,6/1,0KV - EPR 90° PROTEÇÃO ANTI-UV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.11,null,null,null,3,{"$f":"IF(#REF!<>$AP$182,\"(C)\",\"\")","v":{"$error":"#REF!"}},"CABOS ISOLADO 0,6/1,0KV - HEPR 90° PROTEÇÃO ANTI-UV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.12,null,null,null,4,{"$f":"IF(#REF!<>$AP$182,\"(D)\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.13,null,null,null,null,{"$f":"IF(#REF!<>$AP$182,\"(E)\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.14000000000000001,null,null,null,null,{"$f":"IF(#REF!<>$AP$182,\"(F)\",\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28000000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.28999999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.55000000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56000000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.56999999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.57999999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.66]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.67]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.69]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.71]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.72]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.74]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.76]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.77]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.78]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.81]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.83]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.86]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.88]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.89]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.92]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.93]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.94]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]

{"sheet":"GERAL","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,2,0],[1,1,1,2],[9,0,9,1],[18,0,18,1]]}
["Tabela C - Dimensionamento da capacidade do TF"]
["Transformador (kVA)","Demanda a ser contratada (kW)"]
[null,"Mínima","Máxima"]
[75,60,75]
[112.5,75.099999999999994,112.5]
[150,112.6,150]
[225,150.1,225]
[300,225.1,300]
[]
["Tabela D - Esforço e altura (poste duplo T)"]
["Transformador (kVA)","Poste Duplo T a ser utilizado","Esforço (daN)","Altura (m)"]
["Até 75","300daN / 11m",300,11]
[112.5,"600daN / 11m",600,11]
[150,"600daN / 11m",600,11]
[225,"800daN / 11m",800,11]
[300,"1.000daN / 11m",1000,11]
[]
[]
["Tabela F - BC fixo na baixa"]
["Transformador (kVA)","Potência Mínima do Banco de Capacitores (kVAr)"]
[10,1]
[15,1.5]
[30,2]
[45,3]
[75,4]
[112.5,5]
[150,6]
[225,7.5]
[300,8]
[500,12.5]
[750,17]
[1000,19]
[]
[]
["TENSÃO MT","TENSÃO BT"]
[34.5,"220/127"]
[13.8,"380/220"]

{"sheet":"CÁLCULOS","index":3,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":true,"merged":[[19,1,19,8],[6,1,6,7],[8,1,8,4],[10,1,10,5],[14,1,14,2],[17,1,17,8],[4,6,4,7],[1,2,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4]]}
[]
[null,"TOTAL",null,null,null,{"$f":"'QUADRO DE CARGAS'!F56","v":0},null,{"$f":"'QUADRO DE CARGAS'!H56","v":0},null,{"$f":"'QUADRO DE CARGAS'!J56","v":0},{"$f":"'QUADRO DE CARGAS'!K56","v":0}]
[null,"FATOR DE DEMANDA DA ATIVIDADE",null,null,null,{"$f":"'QUADRO DE CARGAS'!F57","v":0}]
[null,"FATOR DE POTÊNCIA DE REFERÊNCIA",null,null,null,{"$f":"'QUADRO DE CARGAS'!F58","v":0.92}]
[null,"FATOR DE POTÊNCIA MÉDIO DA INSTALAÇÃO ",null,null,null,{"$f":"'QUADRO DE CARGAS'!F59","v":" "}]
[]
[null,"METODOLOGIAS PARA CÁLCULO DA 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,"METODOLOGIA UTILIZADA",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 (kVA)",{"$f":"K2","v":0}]
[]
[null,"TRANSFORMADOR: ",null,{"$f":"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<=330),K12,\"\"))))))","v":"Atendimento em BT"},"kVA"]
[]
[]
[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'!F58>='QUADRO DE CARGAS'!F59,TAN(ACOS(F5))-TAN(ACOS(F4)),0)","v":0}]
[]
[null,"QC",{"$f":"IFERROR(C22*C24,\" \")","v":0},"kVAr","Pela carga instalada"]

{"sheet":"TAB 02","index":4,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2],[8,0,8,2]]}
["TABELA 2 – DIMENSIONAMENTO DE ELOS FUSÍVEIS "]
["Transformadores Monofásicos"]
["Potência (kVA)"]
[5,"0,5H","0,5H"]
[10,"1H","0,5H"]
[15,"2H","0,5H"]
[25,"3H","1H"]
[37.5]
["Transformadores Trifásicos"]
["Potência (kVA)","13,8 kV","34,5 kV","13,8 kV para ramal","13,8 kV para ramal","23,1 KV"]
["Até 15","0,5H","0,5H",{"$f":"B12","v":"1H"},{"$f":"C12","v":"0,5H"},"      -  "]
[30,"1H","0,5H",{"$f":"B13","v":"2H"},"0,5H","      -"]
[45,"2H","0,5H","3H","1H","2H"]
[75,"3H","1H","5H","2H","2H"]
[112.5,"5H","2H","5K","2H","3H"]
[150,"5K","2H","10K","5H","5H"]
[225,"10K","5H","15K","6K","6K"]
[300,"15K","6K","25K","12K","10K"]
[500,"25K","12K","40K","15K","15K"]
[750,"40K","15K","40K","25K","25K"]
[1000,"40K","25K","65K","30K","30K"]
[1500,"65K","30K","100K","50K","40K"]
[2000,"100K","50K","100K","65K","50K"]
[2500,"100K","65K","-","-","65K"]

{"sheet":"TAB 03","index":5,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,0,0,12],[0,15,0,27],[1,0,1,12],[1,15,1,27],[2,0,4,0],[2,1,4,2],[2,3,4,4],[2,5,2,6],[2,7,2,8],[2,9,2,12],[3,5,3,6],[3,7,3,8],[3,9,3,11],[3,22,3,23],[3,24,3,27],[4,5,4,6],[4,7,4,8],[4,9,4,11],[4,22,4,23],[4,24,5,25],[2,16,5,17],[2,18,5,19],[2,20,5,21],[2,22,2,23],[2,24,2,27],[4,26,5,27],[2,15,5,15],[9,3,9,4],[6,22,6,23],[7,22,7,23],[9,22,9,23],[9,24,9,25],[8,26,8,27],[6,18,6,19],[6,20,6,21],[9,26,9,27],[8,9,8,11],[8,18,8,19],[8,20,8,21],[9,7,9,8],[9,9,9,11],[9,18,9,19],[9,20,9,21],[6,26,6,27],[7,24,7,25],[7,7,7,8],[7,9,7,11],[7,18,7,19],[7,20,7,21],[6,24,6,25],[8,22,8,23],[8,24,8,25],[8,3,8,4],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,11],[5,22,5,23],[6,3,6,4],[6,5,6,6],[6,7,6,8],[6,9,6,11],[7,3,7,4],[17,8,17,9],[17,23,17,24],[17,25,17,26],[6,16,9,17],[13,11,13,12],[12,6,12,7],[12,8,12,9],[9,5,9,6],[10,0,10,12],[10,15,10,27],[11,2,14,3],[11,4,14,5],[8,5,8,6],[8,7,8,8],[11,6,11,7],[11,8,11,9],[11,10,12,12],[11,15,13,15],[11,16,13,16],[13,6,13,7],[13,8,13,9],[5,1,9,2],[7,26,7,27],[7,5,7,6],[18,23,18,24],[16,17,16,18],[16,19,16,20],[16,23,16,24],[15,17,15,18],[15,19,15,20],[14,19,14,20],[20,19,20,20],[20,21,20,22],[20,23,20,24],[14,17,14,18],[16,25,16,26],[11,21,13,22],[11,23,11,24],[14,21,14,22],[14,23,14,24],[14,25,14,26],[11,25,11,27],[13,23,13,24],[12,23,12,24],[12,25,13,26],[12,27,13,27],[15,21,15,22],[15,23,15,24],[15,25,15,26],[16,21,16,22],[11,17,13,18],[11,19,13,20],[17,21,17,22],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[17,19,17,20],[18,17,18,18],[17,2,17,3],[17,4,17,5],[17,6,17,7],[15,4,15,5],[15,6,15,7],[15,8,15,9],[17,17,17,18],[16,2,16,3],[16,4,16,5],[14,6,14,7],[14,8,14,9],[14,11,14,12],[14,16,20,16],[16,6,16,7],[16,8,16,9],[20,25,20,26],[18,25,18,26],[19,21,19,22],[19,23,19,24],[19,25,19,26],[19,19,19,20],[18,19,18,20],[18,21,18,22],[15,1,21,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[20,8,20,9],[21,6,21,7],[21,8,21,9],[20,17,20,18],[19,2,19,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[19,17,19,18],[21,2,21,3],[21,4,21,5],[15,2,15,3]]}
["TABELA 3 – DIMENSIONAMENTO DOS CIRCUITOS DE BAIXA TENSÃO – CEMAR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABELA 3A – DIMENSIONAMENTO DOS CIRCUITOS DE BAIXA TENSÃO – CELPA"]
["Transformadores Monofásicos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformadores Monofásicos"]
["Potência (kVA)","Tensão (V)",null,"Corrente Secundária (A)",null,"Cabos de cobre com isolação termofixa (XLPE) 0,6/1kV",null,"Eletroduto de Aço Diâmetro nominal",null,"Condutor de Aterramento",null,null,null,null,null,"Potência (kVA)","Tensão (V)",null,"Corrente Secundária (A)",null,"Cabos de Cobre com isolação termofixa (XLPE) 0,6/1kV (mm²)",null,"Eletroduto de Aço Diâmetro nominal ",null,"Aterramento"]
[null,null,null,null,null,"(mm2)",null,"mm (pol)",null,"Cobre",null,null,"Aço-cobreado",null,null,null,null,null,null,null,null,null,"mm (pol)",null,"Condutor de Aterramento"]
[null,null,null,null,null,null,null,null,null,"(mm2)",null,null,"(AWG)",null,null,null,null,null,null,null,null,null,null,null,"Cobre (mm²)",null,"Aço-cobreado (AWG)"]
[3,220,null,15,null,"1#6 (6)",null,"20 (3/4\")",null,25,null,null,4]
[5,null,null,23,null,"1#6 (6)",null,"20 (3/4\")",null,25,null,null,2,null,null,5,127,null,39,null,"1#6 (6)",null,"20 (3/4\")",null,25,null,2]
[10,null,null,45,null,"1#6 (6)",null,"20 (3/4\")",null,25,null,null,2,null,null,10,null,null,79,null,"1#16 (16)",null,"25 (1\")",null,25,null,2]
[15,null,null,68,null,"1#10 (10)",null,"20 (3/4\")",null,25,null,null,2,null,null,15,null,null,118,null,"1#25 (25)",null,"32 (1 ¼\")",null,25,null,2]
[25,null,null,114,null,"1#25 (25)",null,"25 (1\")",null,25,null,null,2,null,null,25,null,null,197,null,"1#70 (35)",null,"40 ( 1 1/2\")",null,25,null,2]
["Transformadores Trifásicos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transformadores Trifásicos"]
["Potência","Tensão","Corrente Secundária (A)",null,"Disjuntor (A)",null,"Cabos de cobre com isolação termofixa",null,"Eletroduto de Aço Diâmetro nominal",null,"Condutor de Aterramento",null,null,null,null,"Potência (kVA)","Tensão (V)","Corrente Secundária (A)",null,"Disjuntor (A)",null,"Cabos de Cobre com isolação termofixa (XLPE) 0,6/1kV (mm²)",null,"Eletroduto de Aço Diâmetro nominal  ",null,"Condutor de Aterramento"]
["(kVA)","(V)",null,null,null,null,"(XLPE) 0,6/1kV",null,"mm (pol)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mm (pol)",null,"Cobre (mm²)",null,"Aço-cobreado (AWG)"]
[null,null,null,null,null,null,"(mm2)",null,null,null,"Cobre","Aço-cobreado"]
[null,null,null,null,null,null,null,null,null,null,"(mm2)","(AWG)",null,null,null,30,220,87,null,100,null,"3#16 (16)",null,"50 (2\")",null,25,null,2]
[30,380,50,null,50,null,"3#10 (10)",null,"50 (2\")",null,25,null,2,null,null,45,null,118,null,125,null,"3#35 (25)",null,"50 (2\")",null,25,null,2]
[45,null,68,null,75,null,"3#16 (16)",null,"40 (1 ½ \")",null,25,null,2,null,null,75,null,197,null,200,null,"3#70 (35)",null,"65 (2 ½”)",null,25,null,2]
[75,null,114,null,125,null,"3#35 (25)",null,"50 (2\")",null,25,null,2,null,null,112.5,null,295,null,300,null,"3#120 (70)",null,"80 (3”)",null,25,null,2]
[112.5,null,171,null,175,null,"3#70 (35)",null,"65 (2 ½)\"",null,25,null,2,null,null,150,null,394,null,400,null,"3#185 (95)",null,"90 (3 1/2\")",null,50,null,"1/0"]
[150,null,228,null,250,null,"3#95 (50)",null,"65 (2 ½)\"",null,50,null,"1/0",null,null,225,null,590,null,600,null,"2x3#120 (1#120)",null,"100 (4\")",null,50,null,"1/0"]
[225,null,342,null,350,null,"3#150 (70)",null,"80 (3\")",null,50,null,"1/0",null,null,300,null,787,null,800,null,"3x3#95 (1#150)",null,"100 (4\")",null,50,null,"1/0"]
[300,null,456,null,500,null,"2x3#95(1#95)",null,"100 (4\")",null,50,null,"1/0"]

{"sheet":"TAB 04","index":6,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,5,1,8],[4,5,4,6]]}
[]
[null,null,null,null,"Tabela 4 - NT.002","Dimensionamento de Transformadores Particulares"]
[]
[]
[null,null,null,null,null,"Demanda calculada KVA",null,"Trafo Recomendado"]
[null,null,null,null,null,"DE","ATÉ","POTÊNCIA"]
[null,null,null,null,null,60,82.9,75]
[null,null,null,null,null,83,124.9,112.5]
[null,null,"Alterar Apenas os Campos Destacados",null,null,125,165.9,150]
[null,null,null,null,null,166,248.9,225,"Espaço para inserir o Trafo verde"]
[null,null,null,null,null,249,330,300]
[null,null,null,null,null,301,9.9999999999999908E+22," (medição em média Tensão)"]
[null,null,null,null,null,null,null," (medição em média Tensão)"]
[]
[]
[null,null,null,null,null,null,""]

{"sheet":"TAB 19","index":7,"n_rows":93,"n_cols":3,"rows_kept":93,"cut":false,"hidden":true,"merged":[[18,0,18,2],[1,0,2,0],[1,1,1,2],[3,0,3,2],[9,0,9,2],[14,0,14,2],[60,0,60,2],[22,0,22,2],[27,0,27,2],[32,1,32,2],[37,0,37,2],[40,0,40,2],[46,1,46,2],[47,1,47,2],[48,0,49,0],[48,1,48,2],[50,0,50,2],[56,0,56,2],[91,1,91,2],[92,1,92,2],[64,0,64,2],[68,0,68,2],[73,0,73,2],[77,1,77,2],[82,0,82,2],[85,0,85,2]]}
[]
["Materiais e Equipamentos para Instalações classe de Tensão 15 kV","Zona de Corrosão"]
[null,"Baixa ou Média","Alta ou Muito Alta"]
["Chave Fusível Unipolar (uso exterior)"]
["Classe de Tensão","15 kV","15 kV com isolador espaçador"]
["Corrente Nominal","300 A","300 A"]
["Capacidade de Ruptura Simétrica","10 kA","10 kA"]
["Tipo de Base","Tipo C","Tipo C"]
["Nível Básico de Isolamento (NBI)","95 kV","95 kV"]
["Chave Seccionadora Unipolar (uso exterior)"]
["Classe de Tensão","15 kV","15 kV"]
["Corrente Nominal","630 A","630 A"]
["Corrente Suportável - Valor de Crista","16 kA","16 kA"]
["Nível Básico de Isolamento (NBI)","110 kV","110 kV"]
["Chave Seccionadora Tripolar (uso interior)"]
["Classe de Tensão","15 kV","15 kV"]
["Corrente Nominal Mínima","630 A","630 A"]
["Nível Básico de Isolamento (NBI)","95 kV","110 kV"]
["Chave Seccionadora Fusível Tripolar (uso interior)"]
["Classe de Tensão","15 kV","15 kV"]
["Corrente Nominal","100 A","100 A"]
["Nível Básico de Isolamento (NBI)","95 kV","110 kV"]
["Disjuntor de Média Tensão"]
["Classe de Tensão","15 kV","15 kV"]
["Corrente Nominal Mínima","630 A","630 A"]
["Capacidade de Ruptura mínima","350 MVA","350 MVA"]
["Nível Básico de Isolamento (NBI)","95 kV","110 kV"]
["Para-raios"]
["Classe de Tensão","12 kV","12 kV"]
["Capacidade Mínima de Ruptura","10 kA","10 kA"]
["Nível Básico de Isolamento (NBI)","95 kV","95 kV"]
["Condutores Nus do Ramal de Ligação","Cobre ou Alumínio","Cobre"]
["Seção mínima","TABELA 1 – RAMAL DE ENTRADA AÉREO EM CLASSE DE TENSÃO PRIMÁRIA DE DISTRIBUIÇÃO 15 E 36,2 kV"]
["Condutores Isolados","Cobre","Cobre"]
["Isolação Mínima","8,7 / 15 kV","8,7 / 15 kV"]
["Seção (mínimo 25 mm²)","Conforme Potência Instalada","Conforme Potência Instalada"]
["Isoladores de Disco (cadeia)","Com 2 isoladores","Com 3 isoladores"]
["Isolador de Pino "]
["Tipo","Hi-Top","Pilar"]
["Classe de tensão","25kV","24,2kV"]
["Transformador de Distribuição"]
["Classe de Tensão","15 kV","15 kV"]
["Buchas de Média Tensão","24,2 kV","24,2 kV"]
["Material do Tanque","Aço Pintado","Aço Pintado para Ambientes com Alta Corrosividade"]
["Tensão Primária Nominal","13,8 kV","13,8 kV"]
["Tensão Secundária Nominal","380/220 V","380/220 V"]
["Tipo de Ligação","Triangulo - Estrela (com Neutro acessível)"]
["TAP´s Primários (Externos)","13,8 / 13,2 / 12,6 / 12 / 11,4 kV"]
["Materiais e Equipamentos para Instalações de classe de Tensão 36,2 kV","Zona de Corrosão"]
[null,"Baixa ou Média","Alta ou Muito Alta"]
["Chave Fusível Unipolar (uso exterior)"]
["Classe de Tensão","36,2 kV","36,2 kV com isolador espaçador"]
["Corrente Nominal","300 A","300 A"]
["Capacidade de Ruptura Simétrica","5 kA","5 kA"]
["Tipo de Base","Tipo C","Tipo C"]
["Nível Básico de Isolamento (NBI)","150 kV","150 kV"]
["Chave Seccionadora Unipolar (uso exterior)"]
["Classe de Tensão","38 kV","38 kV"]
["Corrente Nominal","630 A","630 A"]
["Nível Básico de Isolamento (NBI)","150 kV","150 kV"]
["Chave Seccionadora Tripolar (uso interior)"]
["Classe de Tensão","38 kV","38 kV"]
["Corrente Nominal Mínima","630 A","630 A"]
["Nível Básico de Isolamento (NBI)","150 kV","150 kV"]
["Chave Seccionadora Fusível Tripolar (uso interior)"]
["Classe de Tensão","38 kV","38 kV"]
["Corrente Nominal","100 A","100 A"]
["Nível Básico de Isolamento (NBI)","150 kV","150 kV"]
["Disjuntor de Média Tensão"]
["Classe de Tensão","36,2 kV","36,2 kV"]
["Corrente Nominal Mínima","630 A","630 A"]
["Capacidade de Ruptura mínima","350 MVA","350 MVA"]
["Nível Básico de Isolamento (NBI)","170 kV","170 kV"]
["Para-raios"]
["Classe de Tensão","30 kV","30 kV"]
["Capacidade Mínima de Ruptura","10 kA","10 kA"]
["Condutores Nus do Ramal de Ligação","Cobre ou Alumínio","Cobre"]
["Seção mínima","TABELA 1 – RAMAL DE ENTRADA AÉREO EM CLASSE DE TENSÃO PRIMÁRIA DE DISTRIBUIÇÃO 15 E 36,2 kV"]
["Condutores Isolados","Cobre","Cobre"]
["Isolação Mínima","20 / 35 kV","20 / 35 kV"]
["Seção (mínimo 25 mm²)","Conforme Potência Instalada","Conforme Potência Instalada"]
["Isoladores de Disco (cadeia)","Com 3 isoladores","Com 4 isoladores"]
["Isolador de Pino "]
["Tipo","Multicorpo","Pilar"]
["Classe de tensão","34,5kV","35kV"]
["Transformador de Distribuição"]
["Classe de Tensão","36,2 kV","36,2 kV"]
["Buchas de Média Tensão","36,2 kV","36,2 kV"]
["Material do Tanque","Aço Pintado","Aço Pintado para Ambientes com Alta Corrosividade"]
["Tensão Primária Nominal","34,5 kV","34,5 kV"]
["Tensão Secundária Nominal","380/220 V","380/220 V"]
["Tipo de Ligação","Triangulo - Estrela (com Neutro acessível)"]
["TAP´s Primários (Externos)","36,2 / 35,3 / 34,5 / 33,0 / 31,5 kV"]

{"sheet":"TAB 25","index":8,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":true,"merged":[[1,2,1,3]]}
[]
[null,null,"Tabela 25 - NT.002",null,"Coeficiente para Dimensionamento do Capacitor"]
[]
[null,null,null,null,"FP original","FP corrigido 0,92"]
[null,null,null,null,0.5,1.306,{"$f":"(TAN(ACOS(E5))-TAN(ACOS(0.92)))","v":1.3060525914326722}]
[null,null,null,null,0.51,1.2609999999999999,{"$f":"(TAN(ACOS(E6))-TAN(ACOS(0.92)))","v":1.2606182562581398}]
[null,null,null,null,0.52,1.2170000000000001,1.2166292072532279]
[null,null,null,null,0.53,1.1739999999999999,1.1739973338754066]
[null,null,null,null,0.54,1.133,1.1326407033082992]
[null,null,null,null,0.55000000000000004,1.0920000000000001,1.0924829737265283]
[null,null,null,null,0.56000000000000005,1.0529999999999999,1.053452867950079]
[null,null,null,null,0.56999999999999995,1.0149999999999999,1.015483699768811]
[null,null,null,null,0.57999999999999996,0.97899999999999998,0.97851294623733343]
[null,null,null,null,0.59,0.94199999999999995,0.94248186009663959]
[null,null,null,null,0.6,0.90700000000000003,0.90733511719712867]
[null,null,null,null,0.61,0.873,0.87302049439871543]
[null,null,null,null,0.62,0.83899999999999997,0.83948857392399079]
[null,null,null,null,0.63,0.80700000000000005,0.80669247055293347]
[null,null,null,null,0.64,0.77500000000000002,0.77458757838245429]
[null,null,null,null,0.65,0.74299999999999999,0.74313133413846177]
[null,null,null,null,0.66,0.71199999999999997,0.71228299422700436]
[null,null,null,null,0.67,0.68200000000000005,0.68200342284692739]
[null,null,null,null,0.68,0.65200000000000002,0.65225488855928693]
[null,null,null,null,0.69,0.623,0.62300086671582866]
[null,null,null,null,0.7,0.59399999999999997,0.59420584508420249]
[null,null,null,null,0.71,0.56599999999999995,0.56583512986144358]
[null,null,null,null,0.72,0.53800000000000003,0.5378546490247661]
[null,null,null,null,0.73,0.51,0.51023074960855019]
[null,null,null,null,0.74,0.48299999999999998,0.48292998498813244]
[null,null,null,null,0.75,0.45600000000000002,0.45591888755199217]
[null,null,null,null,0.76,0.42899999999999999,0.42916372119389645]
[null,null,null,null,0.77,0.40300000000000002,0.40263020677025074]
[null,null,null,null,0.78,0.376,0.37628321192338565]
[null,null,null,null,0.79,0.35,0.35008639429262223]
[null,null,null,null,0.8,0.32400000000000001,0.32400178386379519]
[null,null,null,null,0.81,0.29799999999999999,0.29798928566111604]
[null,null,null,null,0.82,0.27200000000000002,0.27200607758351181]
[null,null,null,null,0.83,0.246,0.2460058690389445]
[null,null,null,null,0.84,0.22,0.21993797273286841]
[null,null,null,null,0.85,0.19400000000000001,0.19374612226689769]
[null,null,null,null,0.86,0.16700000000000001,0.16736693838347316]
[null,null,null,null,0.87,0.14099999999999999,0.14072790044407346]
[null,null,null,null,0.88,0.114,0.1137446060018823]
[null,null,null,null,0.89,8.5999999999999993E-2,8.6316980051570402E-2]
[null,null,null,null,0.9,5.8000000000000003E-2,5.8323888701647952E-2]
[null,null,null,null,0.91,0.03,2.9615244119353124E-2]
[null,null,null,null,0.92,0,0]

{"sheet":"Para Raios","index":9,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[[1,0,1,3]]}
[]
["Para-raios"]
["Classe de Tensão",null,"12 kV","12 kV"]
["Capacidade Mínima de Ruptura",null,"10 kA","10 kA"]
["Classe de Tensão",null,"30 kV","30 kV"]
["Capacidade Mínima de Ruptura",null,"10 kA","10 kA"]