{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["PRODUTIVIDADE_INº02","FREQUÊNCIA","Conversor_(2)","Sumula_444_-_TST","MEMORIAL_CALCULO","82,54%","Uniforme","Equip_Maq_","TRT_-_TRIB_","Planilha3","ANEXO III A - PROPOSTA","ANEXO III B - CRO","ANEXO III C - Comp Custos e BDI","ANEXO III D Encargos","ANEXO III E Descricao","OPERAÇÃO DO ATERRO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":31,"comments":0,"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":"PRODUTIVIDADE_INº02","index":0,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Definição do valor por M2"]
[]
[]
[]
["Produtividade IN nº 02/2008",null,"SME","SMM","OBRAS","CAAPSML","SMAA","SEMA","CODEL","SMC","ACESF","SMAS","SMI","SMGP","FEL","TOTAL"]
[]
["Áreas internas","Indicativo"]
["Pisos acarpetados",600,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C8:O8)","v":0}]
["Pisos frios",600,61450.73,{"$f":"576.19-D11-D13","v":423.87},{"$f":"1446.61-E11-E13","v":980.90999999999985},{"$f":"3387.66-F11-F13","v":2168.85},{"$f":"430-G11-G13","v":330},{"$f":"1114.65-H11-H13","v":763.61000000000013},{"$f":"831.3-I13","v":775.03},{"$f":"5117.15-J11-J13","v":3658.56},{"$f":"789-K11-K13","v":729},{"$f":"8150.33-L11-L13","v":5383.87},{"$f":"157.07-M11","v":151.07},{"$f":"29694-N11-N13","v":25769},{"$f":"12394.92-O11-O13","v":1465.4300000000003},104049.93,{"$f":"P9/B9","v":173.41655},{"$f":"1/B9","v":1.6666666666666668E-3},{"$f":"R9*#REF!","v":{"$error":"#REF!"}},{"$f":"S9*P9","v":{"$error":"#REF!"}}]
["Laboratórios",330,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Almoxarifados/galpões",1350,3889.2,36.58,84,304.52,15,107.13,null,409.86,6,349.59,6,718,132.16,6058.0399999999991,{"$f":"P11/B11","v":4.4874370370370364},{"$f":"1/B11","v":7.407407407407407E-4},{"$f":"R11*#REF!","v":{"$error":"#REF!"}},{"$f":"S11*P11","v":{"$error":"#REF!"}}]
["Oficinas",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Áreas com espaço livres/ saguão,hall e salão",800,76142.34,{"$f":"69.99+45.75","v":115.74},381.7,914.29,{"$f":"30+55","v":85},{"$f":"44.52+199.39","v":243.91},56.27,{"$f":"938.67+110.06","v":1048.73},54,{"$f":"768.54+1648.33","v":2416.87},null,{"$f":"1375+1832","v":3207},{"$f":"752.08+10045.25","v":10797.33},95463.18,{"$f":"P13/B13","v":119.32897499999999},{"$f":"1/B13","v":1.25E-3},{"$f":"R13*#REF!","v":{"$error":"#REF!"}},{"$f":"S13*P13","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Áreas externas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pisos pavimentados adjacentes/contínuos às edificações",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"P16/B16","v":0}]
["Varrição de passeios e arruamentos",6000,null,null,null,null,null,null,null,null,148606,null,null,null,null,148606,{"$f":"P17/B17","v":24.767666666666667},{"$f":"1/B17","v":1.6666666666666666E-4},{"$f":"R17*#REF!","v":{"$error":"#REF!"}},{"$f":"S17*P17","v":{"$error":"#REF!"}}]
["Pátios e áreas verdes com alta frequência",1200,124957.45,614.22,2050,1928.02,45,14514.18,45.02,786.06,null,8316.19,96,35820,2517.9,191690.03999999998,{"$f":"P18/B18","v":159.74169999999998},{"$f":"1/B18","v":8.3333333333333339E-4},{"$f":"R18*#REF!","v":{"$error":"#REF!"}},{"$f":"S18*P18","v":{"$error":"#REF!"}}]
["Pátios e áreas verdes com média frequência",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pátios e áreas verdes com baixa frequência",1200,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Coleta de detritos em pátios e áreas verdes com frequência diária",100000,133430.79,3666.58,null,480,35,6731,null,null,null,4842.8,1297,20792,9878.69,181153.86,{"$f":"P21/B21","v":1.8115385999999998},{"$f":"1/B21","v":1.0000000000000001E-5},{"$f":"R21*#REF!","v":{"$error":"#REF!"}},{"$f":"S21*P21","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["esquadrias externas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["face externa com exposição a situação de risco",110,4145.62,null,4,298.99,null,28.84,20,637.05999999999995,null,515.70000000000005,null,1441,null,7091.21,{"$f":"P24/B24","v":64.465545454545449},{"$f":"1/B24","v":9.0909090909090905E-3},{"$f":"R24*#REF!","v":{"$error":"#REF!"}},{"$f":"S24*P24","v":{"$error":"#REF!"}}]
["face externa sem exposição a situação de risco",220,19836.43,67.87,47.01,236.59,66,130.94999999999999,38.65,435.69,219,961.25,57,4928.67,402.17,27427.279999999999,{"$f":"P25/B25","v":124.66945454545454},{"$f":"1/B25","v":4.5454545454545452E-3},{"$f":"R25*#REF!","v":{"$error":"#REF!"}},{"$f":"S25*P25","v":{"$error":"#REF!"}}]
["face interna",220,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Áreas hospitalares e assemelhadas",330,{"$f":"SUM(C9:C26)","v":423852.56},4924.8599999999997,3547.62,6331.26,576,22519.620000000003,934.96999999999991,6975.9599999999982,149614,22786.27,1607.07,92675.67,25193.68]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T8:T28)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"31801.77","v":31801.77}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,58924.92,null,{"$f":"29694-31801.77","v":-2107.7700000000004}]
[null,null,null,null,null,null,null,null,null,null,25810,null,50050,6369.67,4715]
[null,null,null,null,null,null,null,null,null,null,590.20000000000005,null,8844.92,{"$f":"N31+N32+N33","v":97096.36},1598.67]
[null,null,null,null,null,null,null,null,null,null,680,null,30,{"$f":"N34-N28","v":4420.6900000000023},56]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K33:K35)","v":27080.2},null,{"$f":"SUM(M33:M35)","v":58924.92},null,{"$f":"SUM(O33:O35)","v":6369.67}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,56612,null,5276]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M38-M36","v":-2312.9199999999983},null,{"$f":"O36-O38","v":1093.67}]

{"sheet":"FREQUÊNCIA","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
[]
["ESPECIFICAÇÃO DOS SERVIÇOS","FREQUÊNCIA"]
["ÁREAS EXTERNAS - PÁTIOS E ÁREAS VERDES - ALTA FREQUÊNCIA","1 VEZ POR SEMANA"]
["ÁREAS EXTERNAS - PÁTIOS E ÁREAS VERDES - MÉDIA FREQUÊNCIA","1 VEZ A CADA 15 DIAS"]
["ÁREAS EXTERNAS - PÁTIOS E ÁREAS VERDES - BAIXA FREQUÊNCIA","1 VEZ POR MÊS"]
["ÁREAS EXTERNAS - COLETA DE DETRITOS EM PÁTIOS E ÁREAS VERDES","DIÁRIA"]
["VIDROS EXTERNOS (SEM EXPOSIÇÃO A SITUAÇÃO DE RISCO)","FREQUÊNCIA QUINZENAL"]
["VIDROS EXTERNOS (COM EXPOSIÇÃO A SITUAÇÃO DE RISCO)","FREQUÊNCIA QUINZENAL"]

{"sheet":"Conversor_(2)","index":2,"n_rows":158,"n_cols":19,"rows_kept":158,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Decomposição",null,null,null,null,"Parte Inteira",null,null,null,null,"Moeda","Centavos",null,"Valor por Extenso",null,"CONVERSOR DE VALOR EM EXTENSO"]
[]
[]
[]
[]
[]
[]
[null,"trilhões","bilhões","milhões","milhares","unidades","trilhões","bilhões","milhões","milhares","unidades",null,null,"LINCAR VALOR DA GUIA DESEJADA",null,null,null,null,"LINCAR COLUNA \"S\" NA GUIA ONDE DESEJE QUE APAREÇA O EXTENSO"]
[null,{"$f":"TRUNC(($N10-((10^{15,12,9,6,3})*INT($N10/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF($N10<10^15,\"\",IF(OR(B10=1,AND(B10>=100,MOD(B10,100)=0)),IF(TRUNC(($N10-(10^12*INT($N10/(10^12)))))=0,_e_,_sp_),IF(B10<100,\"\",_sp_)))&IF(B10=1,INDEX(Sng,1,5),IF(B10<100,\"\",IF(B10=100,OCem,INDEX(Cem,1,TRUNC(B10/100)))))&IF(MOD(B10,100)=0,\"\",IF(B10=1,\"\",IF(OR(MOD(B10,100)>=20,MOD(B10,100)=10),IF(OR(B10>100,AND($N10>10^15,TRUNC(($N10-(10^12*INT($N10/(10^12)))))=0)),_e_,IF($N10>10^15,_sp_,\"\")),\"\")))&IF(MOD(B10,100)=0,\"\",IF(B10=1,\"\",IF(OR(MOD(B10,100)>=20,MOD(B10,100)=10),INDEX(Dez,1,TRUNC(MOD(B10,100)/10)),\"\")))&IF(MOD(B10,100)=0,\"\",IF(B10=1,\"\",IF(MOD(MOD(B10,100),10)<>0,IF(OR(B10>20,AND($N10>10^15,TRUNC(($N10-(10^12*INT($N10/(10^12)))))=0)),_e_,IF($N10>10^15,_sp_,\"\")),\"\")))&IF(B10=0,\"\",IF(B10=1,\"\",IF(MOD(MOD(B10,100),10)=0,\"\",IF(MOD(B10,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(B10,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(B10,100),10)))))) & IF(B10<=1,\"\",INDEX(Plu,1,5))","v":{"$error":"#REF!"}},{"$f":"IF($N10<10^12,\"\",IF(OR(C10=1,AND(C10>=100,_xlfn.MODE.SNGL(C10,100)=0)),IF(TRUNC(($N10-(10^9*INT($N10/(10^9)))))=0,_e_,_sp_),IF(C10<100,\"\",_sp_)))&IF(C10=1,INDEX(Sng,1,4),IF(C10<100,\"\",IF(C10=100,OCem,INDEX(Cem,1,TRUNC(C10/100)))))&IF(MOD(C10,100)=0,\"\",IF(C10=1,\"\",IF(OR(MOD(C10,100)>=20,MOD(C10,100)=10),IF(OR(C10>100,AND($N10>10^12,TRUNC(($N10-(10^9*INT($N10/(10^9)))))=0)),_e_,IF($N10>10^12,_sp_,\"\")),\"\")))&IF(MOD(C10,100)=0,\"\",IF(C10=1,\"\",IF(OR(MOD(C10,100)>=20,MOD(C10,100)=10),INDEX(Dez,1,TRUNC(MOD(C10,100)/10)),\"\")))&IF(MOD(C10,100)=0,\"\",IF(C10=1,\"\",IF(MOD(MOD(C10,100),10)<>0,IF(OR(C10>20,AND($N10>10^12,TRUNC(($N10-(10^9*INT($N10/(10^9)))))=0)),_e_,IF($N10>10^12,_sp_,\"\")),\"\")))&IF(C10=0,\"\",IF(C10=1,\"\",IF(MOD(MOD(C10,100),10)=0,\"\",IF(MOD(C10,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(C10,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(C10,100),10)))))) & IF(C10<=1,\"\",INDEX(Plu,1,4))","v":{"$error":"#REF!"}},{"$f":"IF($N10<10^9,\"\",IF(OR(D10=1,AND(D10>=100,_xlfn.MODE.SNGL(D10,100)=0)),IF(TRUNC(($N10-(10^6*INT($N10/(10^6)))))=0,_e_,_sp_),IF(D10<100,\"\",_sp_)))&IF(D10=1,INDEX(Sng,1,3),IF(D10<100,\"\",IF(D10=100,OCem,INDEX(Cem,1,TRUNC(D10/100)))))&IF(MOD(D10,100)=0,\"\",IF(D10=1,\"\",IF(OR(MOD(D10,100)>=20,MOD(D10,100)=10),IF(OR(D10>100,AND($N10>10^9,TRUNC(($N10-(10^6*INT($N10/(10^6)))))=0)),_e_,IF($N10>10^9,_sp_,\"\")),\"\")))&IF(MOD(D10,100)=0,\"\",IF(D10=1,\"\",IF(OR(MOD(D10,100)>=20,MOD(D10,100)=10),INDEX(Dez,1,TRUNC(MOD(D10,100)/10)),\"\")))&IF(MOD(D10,100)=0,\"\",IF(D10=1,\"\",IF(MOD(MOD(D10,100),10)<>0,IF(OR(D10>20,AND($N10>10^9,TRUNC(($N10-(10^6*INT($N10/(10^6)))))=0)),_e_,IF($N10>10^9,_sp_,\"\")),\"\")))&IF(D10=0,\"\",IF(D10=1,\"\",IF(MOD(MOD(D10,100),10)=0,\"\",IF(MOD(D10,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(D10,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(D10,100),10)))))) & IF(D10<=1,\"\",INDEX(Plu,1,3))","v":{"$error":"#REF!"}},{"$f":"IF($N10<10^6,\"\",IF(OR(E10=1,AND(E10>=100,_xlfn.MODE.SNGL(E10,100)=0)),IF(TRUNC(($N10-(10^3*INT($N10/(10^3)))))=0,_e_,_sp_),IF(E10<100,\"\",_sp_)))&IF(E10=1,INDEX(Sng,1,2),IF(E10<100,\"\",IF(E10=100,OCem,INDEX(Cem,1,TRUNC(E10/100)))))&IF(MOD(E10,100)=0,\"\",IF(E10=1,\"\",IF(OR(MOD(E10,100)>=20,MOD(E10,100)=10),IF(OR(E10>100,AND($N10>10^6,TRUNC(($N10-(10^3*INT($N10/(10^3)))))=0)),_e_,IF($N10>10^6,_sp_,\"\")),\"\")))&IF(MOD(E10,100)=0,\"\",IF(E10=1,\"\",IF(OR(MOD(E10,100)>=20,MOD(E10,100)=10),INDEX(Dez,1,TRUNC(MOD(E10,100)/10)),\"\")))&IF(MOD(E10,100)=0,\"\",IF(E10=1,\"\",IF(MOD(MOD(E10,100),10)<>0,IF(OR(E10>20,AND($N10>10^6,TRUNC(($N10-(10^3*INT($N10/(10^3)))))=0)),_e_,IF($N10>10^6,_sp_,\"\")),\"\")))&IF(E10=0,\"\",IF(E10=1,\"\",IF(MOD(MOD(E10,100),10)=0,\"\",IF(MOD(E10,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(E10,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(E10,100),10)))))) & IF(E10<=1,\"\",INDEX(Plu,1,2))","v":{"$error":"#REF!"}},{"$f":"IF($N10<10^3,\"\",IF(OR(F10=1,AND(F10>=100,_xlfn.MODE.SNGL(F10,100)=0)),IF(TRUNC(($N10-(10^0*INT($N10/(10^0)))))=0,_e_,_sp_),IF(F10<100,\"\",_sp_)))&IF(F10=1,INDEX(Sng,1,1),IF(F10<100,\"\",IF(F10=100,OCem,INDEX(Cem,1,TRUNC(F10/100)))))&IF(MOD(F10,100)=0,\"\",IF(F10=1,\"\",IF(OR(MOD(F10,100)>=20,MOD(F10,100)=10),IF(OR(F10>100,AND($N10>10^3,TRUNC(($N10-(10^0*INT($N10/(10^0)))))=0)),_e_,IF($N10>10^3,_sp_,\"\")),\"\")))&IF(MOD(F10,100)=0,\"\",IF(F10=1,\"\",IF(OR(MOD(F10,100)>=20,MOD(F10,100)=10),INDEX(Dez,1,TRUNC(MOD(F10,100)/10)),\"\")))&IF(MOD(F10,100)=0,\"\",IF(F10=1,\"\",IF(MOD(MOD(F10,100),10)<>0,IF(OR(F10>20,AND($N10>10^3,TRUNC(($N10-(10^0*INT($N10/(10^0)))))=0)),_e_,IF($N10>10^3,_sp_,\"\")),\"\")))&IF(F10=0,\"\",IF(F10=1,\"\",IF(MOD(MOD(F10,100),10)=0,\"\",IF(MOD(F10,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(F10,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(F10,100),10)))))) & IF(F10<=1,\"\",INDEX(Plu,1,1))","v":{"$error":"#REF!"}},{"$f":"IF($N10<1,\"\",IF(TRUNC($N10)=1,\" real\",IF(AND($N10>=10^6,TRUNC($N10-10^6*INT($N10/10^6))=0),\" de\",\"\") & \" reais\"))","v":{"$error":"#REF!"}},{"$f":"IF((ROUND($N10-TRUNC($N10),2)*100)=0,\"\",IF($N10>=1,_e_,\"\") & IF((ROUND($N10-TRUNC($N10),2)*100)=1,\"um centavo\",IF((ROUND($N10-TRUNC($N10),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($N10-TRUNC($N10),2)*100)/10)) & IF(MOD((ROUND($N10-TRUNC($N10),2)*100),10)<>0,_e_ & INDEX(Sml,1,_xlfn.MODE.SNGL((ROUND($N10-TRUNC($N10),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($N10-TRUNC($N10),2)*100))) & \" centavos\"))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"G10&H10&I10&J10&K10&L10&M10","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(\"(\",O10,\")\")","v":{"$error":"#REF!"}},null,56678,{"$f":"P10","v":{"$error":"#REF!"}}]
[null,{"$f":"TRUNC(($N11-((10^{15,12,9,6,3})*INT($N11/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},null,56,{"$error":"#REF!"}]
[null,{"$f":"TRUNC(($N12-((10^{15,12,9,6,3})*INT($N12/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,4524354,"()"]
[null,{"$f":"TRUNC(($N13-((10^{15,12,9,6,3})*INT($N13/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,656,"()"]
[null,{"$f":"TRUNC(($N14-((10^{15,12,9,6,3})*INT($N14/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,55,"()"]
[null,{"$f":"TRUNC(($N15-((10^{15,12,9,6,3})*INT($N15/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,66,"()"]
[null,{"$f":"TRUNC(($N16-((10^{15,12,9,6,3})*INT($N16/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,55,"()"]
[null,{"$f":"TRUNC(($N17-((10^{15,12,9,6,3})*INT($N17/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,33,"()"]
[null,{"$f":"TRUNC(($N18-((10^{15,12,9,6,3})*INT($N18/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,55,"()"]
[null,{"$f":"TRUNC(($N19-((10^{15,12,9,6,3})*INT($N19/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,77,"()"]
[null,{"$f":"TRUNC(($N20-((10^{15,12,9,6,3})*INT($N20/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,55,"()"]
[null,{"$f":"TRUNC(($N21-((10^{15,12,9,6,3})*INT($N21/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,22,"()"]
[null,{"$f":"TRUNC(($N22-((10^{15,12,9,6,3})*INT($N22/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,557,"()"]
[null,{"$f":"TRUNC(($N23-((10^{15,12,9,6,3})*INT($N23/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,1,"()"]
[null,{"$f":"TRUNC(($N24-((10^{15,12,9,6,3})*INT($N24/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,88,"()"]
[null,{"$f":"TRUNC(($N25-((10^{15,12,9,6,3})*INT($N25/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,66,"()"]
[null,{"$f":"TRUNC(($N26-((10^{15,12,9,6,3})*INT($N26/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,0.89,"()"]
[null,{"$f":"TRUNC(($N27-((10^{15,12,9,6,3})*INT($N27/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",null,"","()",null,0.08,"()"]
[null,{"$f":"TRUNC(($N28-((10^{15,12,9,6,3})*INT($N28/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","um centavo",{"$f":"R28","v":0.01},"um centavo","(um centavo)",null,0.01,"(um centavo)"]
[null,{"$f":"TRUNC(($N29-((10^{15,12,9,6,3})*INT($N29/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N30-((10^{15,12,9,6,3})*INT($N30/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N31-((10^{15,12,9,6,3})*INT($N31/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N32-((10^{15,12,9,6,3})*INT($N32/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N33-((10^{15,12,9,6,3})*INT($N33/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N34-((10^{15,12,9,6,3})*INT($N34/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N35-((10^{15,12,9,6,3})*INT($N35/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N36-((10^{15,12,9,6,3})*INT($N36/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N37-((10^{15,12,9,6,3})*INT($N37/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N38-((10^{15,12,9,6,3})*INT($N38/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N39-((10^{15,12,9,6,3})*INT($N39/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N40-((10^{15,12,9,6,3})*INT($N40/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N41-((10^{15,12,9,6,3})*INT($N41/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N42-((10^{15,12,9,6,3})*INT($N42/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($N42<10^15,\"\",IF(OR(B42=1,AND(B42>=100,MOD(B42,100)=0)),IF(TRUNC(($N42-(10^12*INT($N42/(10^12)))))=0,_e_,_sp_),IF(B42<100,\"\",_sp_)))&IF(B42=1,INDEX(Sng,1,5),IF(B42<100,\"\",IF(B42=100,OCem,INDEX(Cem,1,TRUNC(B42/100)))))&IF(MOD(B42,100)=0,\"\",IF(B42=1,\"\",IF(OR(MOD(B42,100)>=20,MOD(B42,100)=10),IF(OR(B42>100,AND($N42>10^15,TRUNC(($N42-(10^12*INT($N42/(10^12)))))=0)),_e_,IF($N42>10^15,_sp_,\"\")),\"\")))&IF(MOD(B42,100)=0,\"\",IF(B42=1,\"\",IF(OR(MOD(B42,100)>=20,MOD(B42,100)=10),INDEX(Dez,1,TRUNC(MOD(B42,100)/10)),\"\")))&IF(MOD(B42,100)=0,\"\",IF(B42=1,\"\",IF(MOD(MOD(B42,100),10)<>0,IF(OR(B42>20,AND($N42>10^15,TRUNC(($N42-(10^12*INT($N42/(10^12)))))=0)),_e_,IF($N42>10^15,_sp_,\"\")),\"\")))&IF(B42=0,\"\",IF(B42=1,\"\",IF(MOD(MOD(B42,100),10)=0,\"\",IF(MOD(B42,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(B42,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(B42,100),10)))))) & IF(B42<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($N42<10^12,\"\",IF(OR(C42=1,AND(C42>=100,_xlfn.MODE.SNGL(C42,100)=0)),IF(TRUNC(($N42-(10^9*INT($N42/(10^9)))))=0,_e_,_sp_),IF(C42<100,\"\",_sp_)))&IF(C42=1,INDEX(Sng,1,4),IF(C42<100,\"\",IF(C42=100,OCem,INDEX(Cem,1,TRUNC(C42/100)))))&IF(MOD(C42,100)=0,\"\",IF(C42=1,\"\",IF(OR(MOD(C42,100)>=20,MOD(C42,100)=10),IF(OR(C42>100,AND($N42>10^12,TRUNC(($N42-(10^9*INT($N42/(10^9)))))=0)),_e_,IF($N42>10^12,_sp_,\"\")),\"\")))&IF(MOD(C42,100)=0,\"\",IF(C42=1,\"\",IF(OR(MOD(C42,100)>=20,MOD(C42,100)=10),INDEX(Dez,1,TRUNC(MOD(C42,100)/10)),\"\")))&IF(MOD(C42,100)=0,\"\",IF(C42=1,\"\",IF(MOD(MOD(C42,100),10)<>0,IF(OR(C42>20,AND($N42>10^12,TRUNC(($N42-(10^9*INT($N42/(10^9)))))=0)),_e_,IF($N42>10^12,_sp_,\"\")),\"\")))&IF(C42=0,\"\",IF(C42=1,\"\",IF(MOD(MOD(C42,100),10)=0,\"\",IF(MOD(C42,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(C42,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(C42,100),10)))))) & IF(C42<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($N42<10^9,\"\",IF(OR(D42=1,AND(D42>=100,_xlfn.MODE.SNGL(D42,100)=0)),IF(TRUNC(($N42-(10^6*INT($N42/(10^6)))))=0,_e_,_sp_),IF(D42<100,\"\",_sp_)))&IF(D42=1,INDEX(Sng,1,3),IF(D42<100,\"\",IF(D42=100,OCem,INDEX(Cem,1,TRUNC(D42/100)))))&IF(MOD(D42,100)=0,\"\",IF(D42=1,\"\",IF(OR(MOD(D42,100)>=20,MOD(D42,100)=10),IF(OR(D42>100,AND($N42>10^9,TRUNC(($N42-(10^6*INT($N42/(10^6)))))=0)),_e_,IF($N42>10^9,_sp_,\"\")),\"\")))&IF(MOD(D42,100)=0,\"\",IF(D42=1,\"\",IF(OR(MOD(D42,100)>=20,MOD(D42,100)=10),INDEX(Dez,1,TRUNC(MOD(D42,100)/10)),\"\")))&IF(MOD(D42,100)=0,\"\",IF(D42=1,\"\",IF(MOD(MOD(D42,100),10)<>0,IF(OR(D42>20,AND($N42>10^9,TRUNC(($N42-(10^6*INT($N42/(10^6)))))=0)),_e_,IF($N42>10^9,_sp_,\"\")),\"\")))&IF(D42=0,\"\",IF(D42=1,\"\",IF(MOD(MOD(D42,100),10)=0,\"\",IF(MOD(D42,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(D42,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(D42,100),10)))))) & IF(D42<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($N42<10^6,\"\",IF(OR(E42=1,AND(E42>=100,_xlfn.MODE.SNGL(E42,100)=0)),IF(TRUNC(($N42-(10^3*INT($N42/(10^3)))))=0,_e_,_sp_),IF(E42<100,\"\",_sp_)))&IF(E42=1,INDEX(Sng,1,2),IF(E42<100,\"\",IF(E42=100,OCem,INDEX(Cem,1,TRUNC(E42/100)))))&IF(MOD(E42,100)=0,\"\",IF(E42=1,\"\",IF(OR(MOD(E42,100)>=20,MOD(E42,100)=10),IF(OR(E42>100,AND($N42>10^6,TRUNC(($N42-(10^3*INT($N42/(10^3)))))=0)),_e_,IF($N42>10^6,_sp_,\"\")),\"\")))&IF(MOD(E42,100)=0,\"\",IF(E42=1,\"\",IF(OR(MOD(E42,100)>=20,MOD(E42,100)=10),INDEX(Dez,1,TRUNC(MOD(E42,100)/10)),\"\")))&IF(MOD(E42,100)=0,\"\",IF(E42=1,\"\",IF(MOD(MOD(E42,100),10)<>0,IF(OR(E42>20,AND($N42>10^6,TRUNC(($N42-(10^3*INT($N42/(10^3)))))=0)),_e_,IF($N42>10^6,_sp_,\"\")),\"\")))&IF(E42=0,\"\",IF(E42=1,\"\",IF(MOD(MOD(E42,100),10)=0,\"\",IF(MOD(E42,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(E42,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(E42,100),10)))))) & IF(E42<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($N42<10^3,\"\",IF(OR(F42=1,AND(F42>=100,_xlfn.MODE.SNGL(F42,100)=0)),IF(TRUNC(($N42-(10^0*INT($N42/(10^0)))))=0,_e_,_sp_),IF(F42<100,\"\",_sp_)))&IF(F42=1,INDEX(Sng,1,1),IF(F42<100,\"\",IF(F42=100,OCem,INDEX(Cem,1,TRUNC(F42/100)))))&IF(MOD(F42,100)=0,\"\",IF(F42=1,\"\",IF(OR(MOD(F42,100)>=20,MOD(F42,100)=10),IF(OR(F42>100,AND($N42>10^3,TRUNC(($N42-(10^0*INT($N42/(10^0)))))=0)),_e_,IF($N42>10^3,_sp_,\"\")),\"\")))&IF(MOD(F42,100)=0,\"\",IF(F42=1,\"\",IF(OR(MOD(F42,100)>=20,MOD(F42,100)=10),INDEX(Dez,1,TRUNC(MOD(F42,100)/10)),\"\")))&IF(MOD(F42,100)=0,\"\",IF(F42=1,\"\",IF(MOD(MOD(F42,100),10)<>0,IF(OR(F42>20,AND($N42>10^3,TRUNC(($N42-(10^0*INT($N42/(10^0)))))=0)),_e_,IF($N42>10^3,_sp_,\"\")),\"\")))&IF(F42=0,\"\",IF(F42=1,\"\",IF(MOD(MOD(F42,100),10)=0,\"\",IF(MOD(F42,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(F42,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(F42,100),10)))))) & IF(F42<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($N42<1,\"\",IF(TRUNC($N42)=1,\" real\",IF(AND($N42>=10^6,TRUNC($N42-10^6*INT($N42/10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($N42-TRUNC($N42),2)*100)=0,\"\",IF($N42>=1,_e_,\"\") & IF((ROUND($N42-TRUNC($N42),2)*100)=1,\"um centavo\",IF((ROUND($N42-TRUNC($N42),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($N42-TRUNC($N42),2)*100)/10)) & IF(MOD((ROUND($N42-TRUNC($N42),2)*100),10)<>0,_e_ & INDEX(Sml,1,_xlfn.MODE.SNGL((ROUND($N42-TRUNC($N42),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($N42-TRUNC($N42),2)*100))) & \" centavos\"))","v":""},0,{"$f":"G42&H42&I42&J42&K42&L42&M42","v":""},{"$f":"CONCATENATE(\"(\",O42,\")\")","v":"()"},null,null,{"$f":"P42","v":"()"}]
[null,{"$f":"TRUNC(($N43-((10^{15,12,9,6,3})*INT($N43/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N44-((10^{15,12,9,6,3})*INT($N44/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N45-((10^{15,12,9,6,3})*INT($N45/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N46-((10^{15,12,9,6,3})*INT($N46/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N47-((10^{15,12,9,6,3})*INT($N47/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N48-((10^{15,12,9,6,3})*INT($N48/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N49-((10^{15,12,9,6,3})*INT($N49/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N50-((10^{15,12,9,6,3})*INT($N50/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N51-((10^{15,12,9,6,3})*INT($N51/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N52-((10^{15,12,9,6,3})*INT($N52/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N53-((10^{15,12,9,6,3})*INT($N53/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N54-((10^{15,12,9,6,3})*INT($N54/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N55-((10^{15,12,9,6,3})*INT($N55/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N56-((10^{15,12,9,6,3})*INT($N56/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N57-((10^{15,12,9,6,3})*INT($N57/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N58-((10^{15,12,9,6,3})*INT($N58/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N59-((10^{15,12,9,6,3})*INT($N59/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N60-((10^{15,12,9,6,3})*INT($N60/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",{"$f":"R60","v":0},"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N61-((10^{15,12,9,6,3})*INT($N61/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N62-((10^{15,12,9,6,3})*INT($N62/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N63-((10^{15,12,9,6,3})*INT($N63/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N64-((10^{15,12,9,6,3})*INT($N64/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N65-((10^{15,12,9,6,3})*INT($N65/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N66-((10^{15,12,9,6,3})*INT($N66/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N67-((10^{15,12,9,6,3})*INT($N67/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N68-((10^{15,12,9,6,3})*INT($N68/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N69-((10^{15,12,9,6,3})*INT($N69/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N70-((10^{15,12,9,6,3})*INT($N70/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N71-((10^{15,12,9,6,3})*INT($N71/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N72-((10^{15,12,9,6,3})*INT($N72/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N73-((10^{15,12,9,6,3})*INT($N73/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N74-((10^{15,12,9,6,3})*INT($N74/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($N74<10^15,\"\",IF(OR(B74=1,AND(B74>=100,MOD(B74,100)=0)),IF(TRUNC(($N74-(10^12*INT($N74/(10^12)))))=0,_e_,_sp_),IF(B74<100,\"\",_sp_)))&IF(B74=1,INDEX(Sng,1,5),IF(B74<100,\"\",IF(B74=100,OCem,INDEX(Cem,1,TRUNC(B74/100)))))&IF(MOD(B74,100)=0,\"\",IF(B74=1,\"\",IF(OR(MOD(B74,100)>=20,MOD(B74,100)=10),IF(OR(B74>100,AND($N74>10^15,TRUNC(($N74-(10^12*INT($N74/(10^12)))))=0)),_e_,IF($N74>10^15,_sp_,\"\")),\"\")))&IF(MOD(B74,100)=0,\"\",IF(B74=1,\"\",IF(OR(MOD(B74,100)>=20,MOD(B74,100)=10),INDEX(Dez,1,TRUNC(MOD(B74,100)/10)),\"\")))&IF(MOD(B74,100)=0,\"\",IF(B74=1,\"\",IF(MOD(MOD(B74,100),10)<>0,IF(OR(B74>20,AND($N74>10^15,TRUNC(($N74-(10^12*INT($N74/(10^12)))))=0)),_e_,IF($N74>10^15,_sp_,\"\")),\"\")))&IF(B74=0,\"\",IF(B74=1,\"\",IF(MOD(MOD(B74,100),10)=0,\"\",IF(MOD(B74,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(B74,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(B74,100),10)))))) & IF(B74<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($N74<10^12,\"\",IF(OR(C74=1,AND(C74>=100,_xlfn.MODE.SNGL(C74,100)=0)),IF(TRUNC(($N74-(10^9*INT($N74/(10^9)))))=0,_e_,_sp_),IF(C74<100,\"\",_sp_)))&IF(C74=1,INDEX(Sng,1,4),IF(C74<100,\"\",IF(C74=100,OCem,INDEX(Cem,1,TRUNC(C74/100)))))&IF(MOD(C74,100)=0,\"\",IF(C74=1,\"\",IF(OR(MOD(C74,100)>=20,MOD(C74,100)=10),IF(OR(C74>100,AND($N74>10^12,TRUNC(($N74-(10^9*INT($N74/(10^9)))))=0)),_e_,IF($N74>10^12,_sp_,\"\")),\"\")))&IF(MOD(C74,100)=0,\"\",IF(C74=1,\"\",IF(OR(MOD(C74,100)>=20,MOD(C74,100)=10),INDEX(Dez,1,TRUNC(MOD(C74,100)/10)),\"\")))&IF(MOD(C74,100)=0,\"\",IF(C74=1,\"\",IF(MOD(MOD(C74,100),10)<>0,IF(OR(C74>20,AND($N74>10^12,TRUNC(($N74-(10^9*INT($N74/(10^9)))))=0)),_e_,IF($N74>10^12,_sp_,\"\")),\"\")))&IF(C74=0,\"\",IF(C74=1,\"\",IF(MOD(MOD(C74,100),10)=0,\"\",IF(MOD(C74,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(C74,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(C74,100),10)))))) & IF(C74<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($N74<10^9,\"\",IF(OR(D74=1,AND(D74>=100,_xlfn.MODE.SNGL(D74,100)=0)),IF(TRUNC(($N74-(10^6*INT($N74/(10^6)))))=0,_e_,_sp_),IF(D74<100,\"\",_sp_)))&IF(D74=1,INDEX(Sng,1,3),IF(D74<100,\"\",IF(D74=100,OCem,INDEX(Cem,1,TRUNC(D74/100)))))&IF(MOD(D74,100)=0,\"\",IF(D74=1,\"\",IF(OR(MOD(D74,100)>=20,MOD(D74,100)=10),IF(OR(D74>100,AND($N74>10^9,TRUNC(($N74-(10^6*INT($N74/(10^6)))))=0)),_e_,IF($N74>10^9,_sp_,\"\")),\"\")))&IF(MOD(D74,100)=0,\"\",IF(D74=1,\"\",IF(OR(MOD(D74,100)>=20,MOD(D74,100)=10),INDEX(Dez,1,TRUNC(MOD(D74,100)/10)),\"\")))&IF(MOD(D74,100)=0,\"\",IF(D74=1,\"\",IF(MOD(MOD(D74,100),10)<>0,IF(OR(D74>20,AND($N74>10^9,TRUNC(($N74-(10^6*INT($N74/(10^6)))))=0)),_e_,IF($N74>10^9,_sp_,\"\")),\"\")))&IF(D74=0,\"\",IF(D74=1,\"\",IF(MOD(MOD(D74,100),10)=0,\"\",IF(MOD(D74,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(D74,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(D74,100),10)))))) & IF(D74<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($N74<10^6,\"\",IF(OR(E74=1,AND(E74>=100,_xlfn.MODE.SNGL(E74,100)=0)),IF(TRUNC(($N74-(10^3*INT($N74/(10^3)))))=0,_e_,_sp_),IF(E74<100,\"\",_sp_)))&IF(E74=1,INDEX(Sng,1,2),IF(E74<100,\"\",IF(E74=100,OCem,INDEX(Cem,1,TRUNC(E74/100)))))&IF(MOD(E74,100)=0,\"\",IF(E74=1,\"\",IF(OR(MOD(E74,100)>=20,MOD(E74,100)=10),IF(OR(E74>100,AND($N74>10^6,TRUNC(($N74-(10^3*INT($N74/(10^3)))))=0)),_e_,IF($N74>10^6,_sp_,\"\")),\"\")))&IF(MOD(E74,100)=0,\"\",IF(E74=1,\"\",IF(OR(MOD(E74,100)>=20,MOD(E74,100)=10),INDEX(Dez,1,TRUNC(MOD(E74,100)/10)),\"\")))&IF(MOD(E74,100)=0,\"\",IF(E74=1,\"\",IF(MOD(MOD(E74,100),10)<>0,IF(OR(E74>20,AND($N74>10^6,TRUNC(($N74-(10^3*INT($N74/(10^3)))))=0)),_e_,IF($N74>10^6,_sp_,\"\")),\"\")))&IF(E74=0,\"\",IF(E74=1,\"\",IF(MOD(MOD(E74,100),10)=0,\"\",IF(MOD(E74,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(E74,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(E74,100),10)))))) & IF(E74<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($N74<10^3,\"\",IF(OR(F74=1,AND(F74>=100,_xlfn.MODE.SNGL(F74,100)=0)),IF(TRUNC(($N74-(10^0*INT($N74/(10^0)))))=0,_e_,_sp_),IF(F74<100,\"\",_sp_)))&IF(F74=1,INDEX(Sng,1,1),IF(F74<100,\"\",IF(F74=100,OCem,INDEX(Cem,1,TRUNC(F74/100)))))&IF(MOD(F74,100)=0,\"\",IF(F74=1,\"\",IF(OR(MOD(F74,100)>=20,MOD(F74,100)=10),IF(OR(F74>100,AND($N74>10^3,TRUNC(($N74-(10^0*INT($N74/(10^0)))))=0)),_e_,IF($N74>10^3,_sp_,\"\")),\"\")))&IF(MOD(F74,100)=0,\"\",IF(F74=1,\"\",IF(OR(MOD(F74,100)>=20,MOD(F74,100)=10),INDEX(Dez,1,TRUNC(MOD(F74,100)/10)),\"\")))&IF(MOD(F74,100)=0,\"\",IF(F74=1,\"\",IF(MOD(MOD(F74,100),10)<>0,IF(OR(F74>20,AND($N74>10^3,TRUNC(($N74-(10^0*INT($N74/(10^0)))))=0)),_e_,IF($N74>10^3,_sp_,\"\")),\"\")))&IF(F74=0,\"\",IF(F74=1,\"\",IF(MOD(MOD(F74,100),10)=0,\"\",IF(MOD(F74,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(F74,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(F74,100),10)))))) & IF(F74<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($N74<1,\"\",IF(TRUNC($N74)=1,\" real\",IF(AND($N74>=10^6,TRUNC($N74-10^6*INT($N74/10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($N74-TRUNC($N74),2)*100)=0,\"\",IF($N74>=1,_e_,\"\") & IF((ROUND($N74-TRUNC($N74),2)*100)=1,\"um centavo\",IF((ROUND($N74-TRUNC($N74),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($N74-TRUNC($N74),2)*100)/10)) & IF(MOD((ROUND($N74-TRUNC($N74),2)*100),10)<>0,_e_ & INDEX(Sml,1,_xlfn.MODE.SNGL((ROUND($N74-TRUNC($N74),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($N74-TRUNC($N74),2)*100))) & \" centavos\"))","v":""},0,{"$f":"G74&H74&I74&J74&K74&L74&M74","v":""},{"$f":"CONCATENATE(\"(\",O74,\")\")","v":"()"},null,null,{"$f":"P74","v":"()"}]
[null,{"$f":"TRUNC(($N75-((10^{15,12,9,6,3})*INT($N75/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N76-((10^{15,12,9,6,3})*INT($N76/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N77-((10^{15,12,9,6,3})*INT($N77/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N78-((10^{15,12,9,6,3})*INT($N78/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N79-((10^{15,12,9,6,3})*INT($N79/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N80-((10^{15,12,9,6,3})*INT($N80/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N81-((10^{15,12,9,6,3})*INT($N81/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N82-((10^{15,12,9,6,3})*INT($N82/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N83-((10^{15,12,9,6,3})*INT($N83/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N84-((10^{15,12,9,6,3})*INT($N84/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N85-((10^{15,12,9,6,3})*INT($N85/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N86-((10^{15,12,9,6,3})*INT($N86/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N87-((10^{15,12,9,6,3})*INT($N87/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N88-((10^{15,12,9,6,3})*INT($N88/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N89-((10^{15,12,9,6,3})*INT($N89/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N90-((10^{15,12,9,6,3})*INT($N90/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N91-((10^{15,12,9,6,3})*INT($N91/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N92-((10^{15,12,9,6,3})*INT($N92/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",{"$f":"R92","v":0},"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N93-((10^{15,12,9,6,3})*INT($N93/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N94-((10^{15,12,9,6,3})*INT($N94/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N95-((10^{15,12,9,6,3})*INT($N95/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N96-((10^{15,12,9,6,3})*INT($N96/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N97-((10^{15,12,9,6,3})*INT($N97/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N98-((10^{15,12,9,6,3})*INT($N98/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N99-((10^{15,12,9,6,3})*INT($N99/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N100-((10^{15,12,9,6,3})*INT($N100/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N101-((10^{15,12,9,6,3})*INT($N101/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N102-((10^{15,12,9,6,3})*INT($N102/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N103-((10^{15,12,9,6,3})*INT($N103/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N104-((10^{15,12,9,6,3})*INT($N104/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N105-((10^{15,12,9,6,3})*INT($N105/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N106-((10^{15,12,9,6,3})*INT($N106/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($N106<10^15,\"\",IF(OR(B106=1,AND(B106>=100,MOD(B106,100)=0)),IF(TRUNC(($N106-(10^12*INT($N106/(10^12)))))=0,_e_,_sp_),IF(B106<100,\"\",_sp_)))&IF(B106=1,INDEX(Sng,1,5),IF(B106<100,\"\",IF(B106=100,OCem,INDEX(Cem,1,TRUNC(B106/100)))))&IF(MOD(B106,100)=0,\"\",IF(B106=1,\"\",IF(OR(MOD(B106,100)>=20,MOD(B106,100)=10),IF(OR(B106>100,AND($N106>10^15,TRUNC(($N106-(10^12*INT($N106/(10^12)))))=0)),_e_,IF($N106>10^15,_sp_,\"\")),\"\")))&IF(MOD(B106,100)=0,\"\",IF(B106=1,\"\",IF(OR(MOD(B106,100)>=20,MOD(B106,100)=10),INDEX(Dez,1,TRUNC(MOD(B106,100)/10)),\"\")))&IF(MOD(B106,100)=0,\"\",IF(B106=1,\"\",IF(MOD(MOD(B106,100),10)<>0,IF(OR(B106>20,AND($N106>10^15,TRUNC(($N106-(10^12*INT($N106/(10^12)))))=0)),_e_,IF($N106>10^15,_sp_,\"\")),\"\")))&IF(B106=0,\"\",IF(B106=1,\"\",IF(MOD(MOD(B106,100),10)=0,\"\",IF(MOD(B106,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(B106,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(B106,100),10)))))) & IF(B106<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($N106<10^12,\"\",IF(OR(C106=1,AND(C106>=100,_xlfn.MODE.SNGL(C106,100)=0)),IF(TRUNC(($N106-(10^9*INT($N106/(10^9)))))=0,_e_,_sp_),IF(C106<100,\"\",_sp_)))&IF(C106=1,INDEX(Sng,1,4),IF(C106<100,\"\",IF(C106=100,OCem,INDEX(Cem,1,TRUNC(C106/100)))))&IF(MOD(C106,100)=0,\"\",IF(C106=1,\"\",IF(OR(MOD(C106,100)>=20,MOD(C106,100)=10),IF(OR(C106>100,AND($N106>10^12,TRUNC(($N106-(10^9*INT($N106/(10^9)))))=0)),_e_,IF($N106>10^12,_sp_,\"\")),\"\")))&IF(MOD(C106,100)=0,\"\",IF(C106=1,\"\",IF(OR(MOD(C106,100)>=20,MOD(C106,100)=10),INDEX(Dez,1,TRUNC(MOD(C106,100)/10)),\"\")))&IF(MOD(C106,100)=0,\"\",IF(C106=1,\"\",IF(MOD(MOD(C106,100),10)<>0,IF(OR(C106>20,AND($N106>10^12,TRUNC(($N106-(10^9*INT($N106/(10^9)))))=0)),_e_,IF($N106>10^12,_sp_,\"\")),\"\")))&IF(C106=0,\"\",IF(C106=1,\"\",IF(MOD(MOD(C106,100),10)=0,\"\",IF(MOD(C106,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(C106,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(C106,100),10)))))) & IF(C106<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($N106<10^9,\"\",IF(OR(D106=1,AND(D106>=100,_xlfn.MODE.SNGL(D106,100)=0)),IF(TRUNC(($N106-(10^6*INT($N106/(10^6)))))=0,_e_,_sp_),IF(D106<100,\"\",_sp_)))&IF(D106=1,INDEX(Sng,1,3),IF(D106<100,\"\",IF(D106=100,OCem,INDEX(Cem,1,TRUNC(D106/100)))))&IF(MOD(D106,100)=0,\"\",IF(D106=1,\"\",IF(OR(MOD(D106,100)>=20,MOD(D106,100)=10),IF(OR(D106>100,AND($N106>10^9,TRUNC(($N106-(10^6*INT($N106/(10^6)))))=0)),_e_,IF($N106>10^9,_sp_,\"\")),\"\")))&IF(MOD(D106,100)=0,\"\",IF(D106=1,\"\",IF(OR(MOD(D106,100)>=20,MOD(D106,100)=10),INDEX(Dez,1,TRUNC(MOD(D106,100)/10)),\"\")))&IF(MOD(D106,100)=0,\"\",IF(D106=1,\"\",IF(MOD(MOD(D106,100),10)<>0,IF(OR(D106>20,AND($N106>10^9,TRUNC(($N106-(10^6*INT($N106/(10^6)))))=0)),_e_,IF($N106>10^9,_sp_,\"\")),\"\")))&IF(D106=0,\"\",IF(D106=1,\"\",IF(MOD(MOD(D106,100),10)=0,\"\",IF(MOD(D106,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(D106,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(D106,100),10)))))) & IF(D106<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($N106<10^6,\"\",IF(OR(E106=1,AND(E106>=100,_xlfn.MODE.SNGL(E106,100)=0)),IF(TRUNC(($N106-(10^3*INT($N106/(10^3)))))=0,_e_,_sp_),IF(E106<100,\"\",_sp_)))&IF(E106=1,INDEX(Sng,1,2),IF(E106<100,\"\",IF(E106=100,OCem,INDEX(Cem,1,TRUNC(E106/100)))))&IF(MOD(E106,100)=0,\"\",IF(E106=1,\"\",IF(OR(MOD(E106,100)>=20,MOD(E106,100)=10),IF(OR(E106>100,AND($N106>10^6,TRUNC(($N106-(10^3*INT($N106/(10^3)))))=0)),_e_,IF($N106>10^6,_sp_,\"\")),\"\")))&IF(MOD(E106,100)=0,\"\",IF(E106=1,\"\",IF(OR(MOD(E106,100)>=20,MOD(E106,100)=10),INDEX(Dez,1,TRUNC(MOD(E106,100)/10)),\"\")))&IF(MOD(E106,100)=0,\"\",IF(E106=1,\"\",IF(MOD(MOD(E106,100),10)<>0,IF(OR(E106>20,AND($N106>10^6,TRUNC(($N106-(10^3*INT($N106/(10^3)))))=0)),_e_,IF($N106>10^6,_sp_,\"\")),\"\")))&IF(E106=0,\"\",IF(E106=1,\"\",IF(MOD(MOD(E106,100),10)=0,\"\",IF(MOD(E106,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(E106,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(E106,100),10)))))) & IF(E106<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($N106<10^3,\"\",IF(OR(F106=1,AND(F106>=100,_xlfn.MODE.SNGL(F106,100)=0)),IF(TRUNC(($N106-(10^0*INT($N106/(10^0)))))=0,_e_,_sp_),IF(F106<100,\"\",_sp_)))&IF(F106=1,INDEX(Sng,1,1),IF(F106<100,\"\",IF(F106=100,OCem,INDEX(Cem,1,TRUNC(F106/100)))))&IF(MOD(F106,100)=0,\"\",IF(F106=1,\"\",IF(OR(MOD(F106,100)>=20,MOD(F106,100)=10),IF(OR(F106>100,AND($N106>10^3,TRUNC(($N106-(10^0*INT($N106/(10^0)))))=0)),_e_,IF($N106>10^3,_sp_,\"\")),\"\")))&IF(MOD(F106,100)=0,\"\",IF(F106=1,\"\",IF(OR(MOD(F106,100)>=20,MOD(F106,100)=10),INDEX(Dez,1,TRUNC(MOD(F106,100)/10)),\"\")))&IF(MOD(F106,100)=0,\"\",IF(F106=1,\"\",IF(MOD(MOD(F106,100),10)<>0,IF(OR(F106>20,AND($N106>10^3,TRUNC(($N106-(10^0*INT($N106/(10^0)))))=0)),_e_,IF($N106>10^3,_sp_,\"\")),\"\")))&IF(F106=0,\"\",IF(F106=1,\"\",IF(MOD(MOD(F106,100),10)=0,\"\",IF(MOD(F106,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(F106,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(F106,100),10)))))) & IF(F106<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($N106<1,\"\",IF(TRUNC($N106)=1,\" real\",IF(AND($N106>=10^6,TRUNC($N106-10^6*INT($N106/10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($N106-TRUNC($N106),2)*100)=0,\"\",IF($N106>=1,_e_,\"\") & IF((ROUND($N106-TRUNC($N106),2)*100)=1,\"um centavo\",IF((ROUND($N106-TRUNC($N106),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($N106-TRUNC($N106),2)*100)/10)) & IF(MOD((ROUND($N106-TRUNC($N106),2)*100),10)<>0,_e_ & INDEX(Sml,1,_xlfn.MODE.SNGL((ROUND($N106-TRUNC($N106),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($N106-TRUNC($N106),2)*100))) & \" centavos\"))","v":""},0,{"$f":"G106&H106&I106&J106&K106&L106&M106","v":""},{"$f":"CONCATENATE(\"(\",O106,\")\")","v":"()"},null,null,{"$f":"P106","v":"()"}]
[null,{"$f":"TRUNC(($N107-((10^{15,12,9,6,3})*INT($N107/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N108-((10^{15,12,9,6,3})*INT($N108/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N109-((10^{15,12,9,6,3})*INT($N109/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N110-((10^{15,12,9,6,3})*INT($N110/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N111-((10^{15,12,9,6,3})*INT($N111/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N112-((10^{15,12,9,6,3})*INT($N112/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N113-((10^{15,12,9,6,3})*INT($N113/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N114-((10^{15,12,9,6,3})*INT($N114/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N115-((10^{15,12,9,6,3})*INT($N115/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N116-((10^{15,12,9,6,3})*INT($N116/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N117-((10^{15,12,9,6,3})*INT($N117/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N118-((10^{15,12,9,6,3})*INT($N118/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N119-((10^{15,12,9,6,3})*INT($N119/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N120-((10^{15,12,9,6,3})*INT($N120/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N121-((10^{15,12,9,6,3})*INT($N121/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N122-((10^{15,12,9,6,3})*INT($N122/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N123-((10^{15,12,9,6,3})*INT($N123/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N124-((10^{15,12,9,6,3})*INT($N124/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",{"$f":"R124","v":0},"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N125-((10^{15,12,9,6,3})*INT($N125/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N126-((10^{15,12,9,6,3})*INT($N126/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N127-((10^{15,12,9,6,3})*INT($N127/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N128-((10^{15,12,9,6,3})*INT($N128/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N129-((10^{15,12,9,6,3})*INT($N129/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N130-((10^{15,12,9,6,3})*INT($N130/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N131-((10^{15,12,9,6,3})*INT($N131/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N132-((10^{15,12,9,6,3})*INT($N132/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N133-((10^{15,12,9,6,3})*INT($N133/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N134-((10^{15,12,9,6,3})*INT($N134/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N135-((10^{15,12,9,6,3})*INT($N135/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N136-((10^{15,12,9,6,3})*INT($N136/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N137-((10^{15,12,9,6,3})*INT($N137/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N138-((10^{15,12,9,6,3})*INT($N138/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,{"$f":"IF($N138<10^15,\"\",IF(OR(B138=1,AND(B138>=100,MOD(B138,100)=0)),IF(TRUNC(($N138-(10^12*INT($N138/(10^12)))))=0,_e_,_sp_),IF(B138<100,\"\",_sp_)))&IF(B138=1,INDEX(Sng,1,5),IF(B138<100,\"\",IF(B138=100,OCem,INDEX(Cem,1,TRUNC(B138/100)))))&IF(MOD(B138,100)=0,\"\",IF(B138=1,\"\",IF(OR(MOD(B138,100)>=20,MOD(B138,100)=10),IF(OR(B138>100,AND($N138>10^15,TRUNC(($N138-(10^12*INT($N138/(10^12)))))=0)),_e_,IF($N138>10^15,_sp_,\"\")),\"\")))&IF(MOD(B138,100)=0,\"\",IF(B138=1,\"\",IF(OR(MOD(B138,100)>=20,MOD(B138,100)=10),INDEX(Dez,1,TRUNC(MOD(B138,100)/10)),\"\")))&IF(MOD(B138,100)=0,\"\",IF(B138=1,\"\",IF(MOD(MOD(B138,100),10)<>0,IF(OR(B138>20,AND($N138>10^15,TRUNC(($N138-(10^12*INT($N138/(10^12)))))=0)),_e_,IF($N138>10^15,_sp_,\"\")),\"\")))&IF(B138=0,\"\",IF(B138=1,\"\",IF(MOD(MOD(B138,100),10)=0,\"\",IF(MOD(B138,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(B138,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(B138,100),10)))))) & IF(B138<=1,\"\",INDEX(Plu,1,5))","v":""},{"$f":"IF($N138<10^12,\"\",IF(OR(C138=1,AND(C138>=100,_xlfn.MODE.SNGL(C138,100)=0)),IF(TRUNC(($N138-(10^9*INT($N138/(10^9)))))=0,_e_,_sp_),IF(C138<100,\"\",_sp_)))&IF(C138=1,INDEX(Sng,1,4),IF(C138<100,\"\",IF(C138=100,OCem,INDEX(Cem,1,TRUNC(C138/100)))))&IF(MOD(C138,100)=0,\"\",IF(C138=1,\"\",IF(OR(MOD(C138,100)>=20,MOD(C138,100)=10),IF(OR(C138>100,AND($N138>10^12,TRUNC(($N138-(10^9*INT($N138/(10^9)))))=0)),_e_,IF($N138>10^12,_sp_,\"\")),\"\")))&IF(MOD(C138,100)=0,\"\",IF(C138=1,\"\",IF(OR(MOD(C138,100)>=20,MOD(C138,100)=10),INDEX(Dez,1,TRUNC(MOD(C138,100)/10)),\"\")))&IF(MOD(C138,100)=0,\"\",IF(C138=1,\"\",IF(MOD(MOD(C138,100),10)<>0,IF(OR(C138>20,AND($N138>10^12,TRUNC(($N138-(10^9*INT($N138/(10^9)))))=0)),_e_,IF($N138>10^12,_sp_,\"\")),\"\")))&IF(C138=0,\"\",IF(C138=1,\"\",IF(MOD(MOD(C138,100),10)=0,\"\",IF(MOD(C138,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(C138,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(C138,100),10)))))) & IF(C138<=1,\"\",INDEX(Plu,1,4))","v":""},{"$f":"IF($N138<10^9,\"\",IF(OR(D138=1,AND(D138>=100,_xlfn.MODE.SNGL(D138,100)=0)),IF(TRUNC(($N138-(10^6*INT($N138/(10^6)))))=0,_e_,_sp_),IF(D138<100,\"\",_sp_)))&IF(D138=1,INDEX(Sng,1,3),IF(D138<100,\"\",IF(D138=100,OCem,INDEX(Cem,1,TRUNC(D138/100)))))&IF(MOD(D138,100)=0,\"\",IF(D138=1,\"\",IF(OR(MOD(D138,100)>=20,MOD(D138,100)=10),IF(OR(D138>100,AND($N138>10^9,TRUNC(($N138-(10^6*INT($N138/(10^6)))))=0)),_e_,IF($N138>10^9,_sp_,\"\")),\"\")))&IF(MOD(D138,100)=0,\"\",IF(D138=1,\"\",IF(OR(MOD(D138,100)>=20,MOD(D138,100)=10),INDEX(Dez,1,TRUNC(MOD(D138,100)/10)),\"\")))&IF(MOD(D138,100)=0,\"\",IF(D138=1,\"\",IF(MOD(MOD(D138,100),10)<>0,IF(OR(D138>20,AND($N138>10^9,TRUNC(($N138-(10^6*INT($N138/(10^6)))))=0)),_e_,IF($N138>10^9,_sp_,\"\")),\"\")))&IF(D138=0,\"\",IF(D138=1,\"\",IF(MOD(MOD(D138,100),10)=0,\"\",IF(MOD(D138,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(D138,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(D138,100),10)))))) & IF(D138<=1,\"\",INDEX(Plu,1,3))","v":""},{"$f":"IF($N138<10^6,\"\",IF(OR(E138=1,AND(E138>=100,_xlfn.MODE.SNGL(E138,100)=0)),IF(TRUNC(($N138-(10^3*INT($N138/(10^3)))))=0,_e_,_sp_),IF(E138<100,\"\",_sp_)))&IF(E138=1,INDEX(Sng,1,2),IF(E138<100,\"\",IF(E138=100,OCem,INDEX(Cem,1,TRUNC(E138/100)))))&IF(MOD(E138,100)=0,\"\",IF(E138=1,\"\",IF(OR(MOD(E138,100)>=20,MOD(E138,100)=10),IF(OR(E138>100,AND($N138>10^6,TRUNC(($N138-(10^3*INT($N138/(10^3)))))=0)),_e_,IF($N138>10^6,_sp_,\"\")),\"\")))&IF(MOD(E138,100)=0,\"\",IF(E138=1,\"\",IF(OR(MOD(E138,100)>=20,MOD(E138,100)=10),INDEX(Dez,1,TRUNC(MOD(E138,100)/10)),\"\")))&IF(MOD(E138,100)=0,\"\",IF(E138=1,\"\",IF(MOD(MOD(E138,100),10)<>0,IF(OR(E138>20,AND($N138>10^6,TRUNC(($N138-(10^3*INT($N138/(10^3)))))=0)),_e_,IF($N138>10^6,_sp_,\"\")),\"\")))&IF(E138=0,\"\",IF(E138=1,\"\",IF(MOD(MOD(E138,100),10)=0,\"\",IF(MOD(E138,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(E138,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(E138,100),10)))))) & IF(E138<=1,\"\",INDEX(Plu,1,2))","v":""},{"$f":"IF($N138<10^3,\"\",IF(OR(F138=1,AND(F138>=100,_xlfn.MODE.SNGL(F138,100)=0)),IF(TRUNC(($N138-(10^0*INT($N138/(10^0)))))=0,_e_,_sp_),IF(F138<100,\"\",_sp_)))&IF(F138=1,INDEX(Sng,1,1),IF(F138<100,\"\",IF(F138=100,OCem,INDEX(Cem,1,TRUNC(F138/100)))))&IF(MOD(F138,100)=0,\"\",IF(F138=1,\"\",IF(OR(MOD(F138,100)>=20,MOD(F138,100)=10),IF(OR(F138>100,AND($N138>10^3,TRUNC(($N138-(10^0*INT($N138/(10^0)))))=0)),_e_,IF($N138>10^3,_sp_,\"\")),\"\")))&IF(MOD(F138,100)=0,\"\",IF(F138=1,\"\",IF(OR(MOD(F138,100)>=20,MOD(F138,100)=10),INDEX(Dez,1,TRUNC(MOD(F138,100)/10)),\"\")))&IF(MOD(F138,100)=0,\"\",IF(F138=1,\"\",IF(MOD(MOD(F138,100),10)<>0,IF(OR(F138>20,AND($N138>10^3,TRUNC(($N138-(10^0*INT($N138/(10^0)))))=0)),_e_,IF($N138>10^3,_sp_,\"\")),\"\")))&IF(F138=0,\"\",IF(F138=1,\"\",IF(MOD(MOD(F138,100),10)=0,\"\",IF(MOD(F138,100)<20,INDEX(Sml,1,_xlfn.MODE.SNGL(F138,100)),INDEX(Sml,1,_xlfn.MODE.SNGL(_xlfn.MODE.SNGL(F138,100),10)))))) & IF(F138<=1,\"\",INDEX(Plu,1,1))","v":""},{"$f":"IF($N138<1,\"\",IF(TRUNC($N138)=1,\" real\",IF(AND($N138>=10^6,TRUNC($N138-10^6*INT($N138/10^6))=0),\" de\",\"\") & \" reais\"))","v":""},{"$f":"IF((ROUND($N138-TRUNC($N138),2)*100)=0,\"\",IF($N138>=1,_e_,\"\") & IF((ROUND($N138-TRUNC($N138),2)*100)=1,\"um centavo\",IF((ROUND($N138-TRUNC($N138),2)*100)>=20,INDEX(Dez,1,TRUNC((ROUND($N138-TRUNC($N138),2)*100)/10)) & IF(MOD((ROUND($N138-TRUNC($N138),2)*100),10)<>0,_e_ & INDEX(Sml,1,_xlfn.MODE.SNGL((ROUND($N138-TRUNC($N138),2)*100),10)),\"\"),INDEX(Sml,1,(ROUND($N138-TRUNC($N138),2)*100))) & \" centavos\"))","v":""},0,{"$f":"G138&H138&I138&J138&K138&L138&M138","v":""},{"$f":"CONCATENATE(\"(\",O138,\")\")","v":"()"},null,null,{"$f":"P138","v":"()"}]
[null,{"$f":"TRUNC(($N139-((10^{15,12,9,6,3})*INT($N139/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N140-((10^{15,12,9,6,3})*INT($N140/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N141-((10^{15,12,9,6,3})*INT($N141/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N142-((10^{15,12,9,6,3})*INT($N142/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N143-((10^{15,12,9,6,3})*INT($N143/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N144-((10^{15,12,9,6,3})*INT($N144/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N145-((10^{15,12,9,6,3})*INT($N145/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N146-((10^{15,12,9,6,3})*INT($N146/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N147-((10^{15,12,9,6,3})*INT($N147/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N148-((10^{15,12,9,6,3})*INT($N148/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N149-((10^{15,12,9,6,3})*INT($N149/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N150-((10^{15,12,9,6,3})*INT($N150/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N151-((10^{15,12,9,6,3})*INT($N151/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N152-((10^{15,12,9,6,3})*INT($N152/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N153-((10^{15,12,9,6,3})*INT($N153/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N154-((10^{15,12,9,6,3})*INT($N154/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N155-((10^{15,12,9,6,3})*INT($N155/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N156-((10^{15,12,9,6,3})*INT($N156/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N157-((10^{15,12,9,6,3})*INT($N157/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]
[null,{"$f":"TRUNC(($N158-((10^{15,12,9,6,3})*INT($N158/(10^{15,12,9,6,3}))))/10^{12,9,6,3,0})","v":0},0,0,0,0,"","","","","","","",0,"","()",null,null,"()"]

{"sheet":"Sumula_444_-_TST","index":3,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["VIGIA"]
[1109,"SALÁRIO"]
[0,"ASSIDUIDADE"]
[0,"INSALUBRIDADE"]
[{"$f":"SUM(A2:A4)","v":1109},"SALARIO+ASSIDUIDADE"]
[{"$f":"A5/220","v":5.040909090909091},"VALOR DA HORA COM ASSIDUIDADE"]
[14,"FERIADOS NO ANO"]
[12,"HORAS TRABALHADAS E FERIADO"]
[{"$f":"A8*A7","v":168}]
[]
[{"$f":"((A6*A8)*0.5)/12","v":2.5204545454545455}]
[null,null,null,"HORAS DE TRABALHO EM FERIADO NO ANO",null,null,null,{"$f":"A9","v":168}]
[null,null,null,"Nº DE MESES",null,null,null,12]
[null,null,null,"PARCELA TRABALHADA",null,null,null,0.5]
[]
[null,null,null,"DIAS DO ANO",null,null,null,365]
[null,null,null,"DIAS DA SEMANA",null,null,null,7]
[null,null,null,"DIAS UTEIS",null,null,null,6]
[]
[null,null,null,"NÚMERO DE FERIADOS ANO",null,null,null,{"$f":"A7","v":14}]
[null,null,null,null,null,null,null,{"$f":"(H12/H13*H14)/((H16/H17*H18)-H20)","v":2.3422562141491392E-2}]
[]
[null,null,null,null,null,null,null,{"$f":"H21*(H16-((H16/H17*H18)-H20))","v":1.5492351816443586}]
[null,null,null,null,"ADICIONAL DE HORA EXTRA",null,null,{"$f":"H23*(A5/220)","v":7.8095537111072444}]
[]
[null,null,null,null,null,null,null,{"$f":"H24*12","v":93.714644533286929},{"$f":"H26*2","v":187.42928906657386}]
[]
["BOMBEIRO"]
[1524,"SALÁRIO"]
[{"$f":"A29*0.0363","v":55.321199999999997},"ASSIDUIDADE"]
[0,"INSALUBRIDADE"]
[{"$f":"SUM(A29:A31)","v":1579.3212000000001},"SALARIO+ASSIDUIDADE"]
[{"$f":"A32/220","v":7.1787327272727275},"VALOR DA HORA COM ASSIDUIDADE"]
[14,"FERIADOS NO ANO"]
[12,"HORAS TRABALHADAS E FERIADO"]
[{"$f":"A35*A34","v":168}]
[]
[{"$f":"((A33*A35)*0.5)/12","v":3.5893663636363637}]
[null,null,null,"HORAS DE TRABALHO EM FERIADO NO ANO",null,null,null,{"$f":"A36","v":168}]
[null,null,null,"Nº DE MESES",null,null,null,12]
[null,null,null,"PARCELA TRABALHADA",null,null,null,0.5]
[]
[null,null,null,"DIAS DO ANO",null,null,null,365]
[null,null,null,"DIAS DA SEMANA",null,null,null,7]
[null,null,null,"DIAS UTEIS",null,null,null,6]
[]
[null,null,null,"NÚMERO DE FERIADOS ANO",null,null,null,{"$f":"A34","v":14}]
[null,null,null,null,null,null,null,{"$f":"(H39/H40*H41)/((H43/H44*H45)-H47)","v":2.3422562141491392E-2}]
[]
[null,null,null,null,null,null,null,{"$f":"H48*(H43-((H43/H44*H45)-H47))","v":1.5492351816443586}]
[null,null,null,null,"ADICIONAL DE HORA EXTRA",null,null,{"$f":"H50*(A32/220)","v":11.121545300712665}]
[]
[null,null,null,null,null,null,null,{"$f":"H51*12","v":133.45854360855196},{"$f":"H53*2","v":266.91708721710393}]

{"sheet":"MEMORIAL_CALCULO","index":4,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
["Modulo 4 – Encargos Sociais"]
["Submódulo 4.1"]
["Letra A"]
["Previdência Social ou INSS tem como percentual de incidência o importe de 20,00% (vinte por cento) conforme previsão no artigo 22, inciso I, da Lei nº. 8.212/1991.",null,null,null,null,null,null,null,null,null,0.2]
["Letra B"]
["SESI ou SESC tem como percentual de incidência o importe de 1,5% (um vírgula cinco por cento) conforme previsão no artigo 30, da Lei nº. 8.036/1990 e artigo 1º da Lei nº 8.154/1990.",null,null,null,null,null,null,null,null,null,1.4999999999999999E-2]
["Letra C"]
["SENAI ou SENAC tem como percentual de incidência o importe de 1,00% (um por cento) conforme previsão no Decreto-lei nº 2.318/1986.",null,null,null,null,null,null,null,null,null,0.01]
["Letra D"]
["INCRA tem como percentual de incidência o importe de 0,20% (zero vírgula vinte por cento) conforme previsão no artigo 1º, inciso I, do Decreto-lei nº 1.146/1970.",null,null,null,null,null,null,null,null,null,2E-3]
["Letra E"]
["SALÁRIO EDUCAÇÃO tem como percentual de incidência o importe de 2,50% (dois vírgula cinco por cento) conforme previsão no artigo 3º, inciso I, do Decreto-lei nº 87.043/1982 e Lei nº 9.424/1996.",null,null,null,null,null,null,null,null,null,2.5000000000000001E-2]
["Letra F"]
["FGTS tem como percentual de incidência o importe de 8,00% (oito por cento) conforme previsão no artigo 15 da Lei nº 8.036/1990 e art. 7º, inciso III da Constituição Federal de 1.988 inciso I, do Decreto-lei nº 87.043/1982 e Lei nº 9.424/1996.",null,null,null,null,null,null,null,null,null,0.08]
["Letra G"]
["SAT/RAT/FAP é determinado pela lei 8.212/91, sendo o mesmo recolhido à Previdência Social conforme determina a referida lei.",null,null,null,null,null,null,null,null,null,2.3599999999999999E-2]
["Letra H"]
["SEBRAE tem como percentual de incidência o importe de 0,60% (zero vírgula sessenta por cento) conforme previsão na Lei nº 8.029/1990 alterada pela Lei nº 8.154/1990.",null,null,null,null,null,null,null,null,null,6.0000000000000001E-3]
["SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K5:K19)","v":0.36160000000000009}]
["Submodulo 4.2"]
["Tratam do percentual do 13º salário e a incidência do Submodulo 4.1 sobre este, sendo a sua fundamentação:"]
["",null,null,null,null,null,null,null,null,null,{"$f":"0.0833+0.0278","v":0.1111}]
["Tal previsão está amparada no art. 7º, inciso VIII, da Constituição Federal, Lei n. 4.090/1962 e Lei n. 7.787/1989. (Acórdão TCU n. 1.753/2008 - Plenário)."]
["O profissional trabalha onze meses no ano, pois no outro goza suas férias. Assim, o custeio anual do empregado acontece nos onze meses de trabalho. No mês das férias, a remuneração e os encargos são direcionados para custear o substituto por ser uma ausência legal."]
["Incidência do Submódulo 4.1 sobre 13º Salário e adicional de férias",null,null,null,null,null,null,null,null,null,{"$f":"K20*SUM(K23:K25)","v":4.017376000000001E-2}]
["SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K23:K26)","v":0.15127376000000001}]
["Submodulo 4.3"]
["",null,null,null,null,null,null,null,null,null,2.9999999999999997E-4]
["Nesse caso o INSS reembolsa o salário da beneficiária. Entretanto, continuam sendo contados os demais encargos, como férias, adicional de férias, 13º salário, encargos previdenciários, FGTS, bem como benefícios como a assistência médica (se prevista em norma coletiva de trabalho (acordos, convenções ou sentenças normativas em dissídios coletivos). Conforme determina a Constituição Federal de 1988 (Art. 6° e 201), CLT (Art. 392) e as Jurisprudência - TST(Orientação Jurisprudencial, SDI1 44 e Orientação Jurisprudência, SDI1."]
["Considerando as medias da empresa e as previsões futuras o percentual a ser considerado pela empresa neste item é 0,03%"]
["",null,null,null,null,null,null,null,null,null,{"$f":"K29*K20","v":1.0848000000000002E-4}]
["SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K29:K32)","v":4.0848000000000002E-4}]
["Submodulo 4.4"]
["",null,null,null,null,null,null,null,null,null,4.1999999999999997E-3,null,null,{"$f":"1/12*O35*1","v":4.1666666666666666E-3},0.05]
["",null,null,null,null,null,null,null,null,null,{"$f":"0.08*K35","v":3.3599999999999998E-4}]
["",null,null,null,null,null,null,null,null,null,1E-4]
["",null,null,null,null,null,null,null,null,null,2.5000000000000001E-3]
["",null,null,null,null,null,null,null,null,null,{"$f":"K38*K20","v":9.0400000000000029E-4}]
["",null,null,null,null,null,null,null,null,null,{"$f":"K37","v":1E-4}]
["",null,null,null,null,null,null,null,null,null,4.36E-2]
["SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K35:K41)","v":5.1740000000000001E-2}]
["",null,null,null,null,null,null,null,null,null,{"$f":"1/12","v":8.3333333333333329E-2}]
["",null,null,null,null,null,null,null,null,null,{"$f":"(6.45/30)*(1/12)","v":1.7916666666666664E-2}]
["",null,null,null,null,null,null,null,null,null,{"$f":"((5/30)/12)*0.01*1","v":1.3888888888888889E-4}]
["",null,null,null,null,null,null,null,null,null,1.3100000000000001E-2,null,null,{"$f":"(P46/30)*(1/12)","v":8.1944444444444452E-3},null,2.95]
["",null,null,null,null,null,null,null,null,null,2.9999999999999997E-4]
["SUBTOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K43:K47)+0.0001","v":0.11488888888888887}]
["",null,null,null,null,null,null,null,null,null,{"$f":"K48*K20","v":4.1543822222222228E-2}]
["TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"K49+K48+K42+K33+K27+K20","v":0.72145495111111124}]

{"sheet":"82,54%","index":5,"n_rows":145,"n_cols":8,"rows_kept":145,"cut":false,"hidden":true,"merged":[]}
[null,null,"PLANILHA DE CUSTO E FORMAÇÃO DE PREÇOS"]
["A"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Identificação do Serviço"]
["Tipo de Serviço",null,"Unidade de Medida",null,"Quantidade total a contratar "]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["Anexo III-A – Mão-de-obra"]
["Mão-de-obra vinculada à execução contratual"]
[]
["Dados complementares para composição dos custos referente à mão-de-obra"]
[1,"Tipo de serviço (mesmo serviço com características distintas)",null,null,{"$f":"A8","v":{"$error":"#REF!"}}]
[2,"Salário Normativo da Categoria Profissional"]
[3,"Categoria profissional (vinculada à execução contratual)"]
[4,"Data base da categoria (dia/mês/ano)"]
[]
["MÓDULO 1: COMPOSIÇÃO DA REMUNERAÇÃO"]
[1,"Composição da Remuneração",null,null,"%","Valor (R$)"]
["A","Salário Normativo",null,null,{"$f":"F21/$F$32","v":0.46193255784655435},1150]
["B","Adicional Assiduidade",null,0.05,2.3096627892327717E-2,{"$f":"F21*D22","v":57.5}]
["C","Gratificação (Clausula 3 - Item 02.01 da CCT)",null,null,0,0]
["D","Insalubridade",null,0.4,0.18477302313862173,{"$f":"F21*D24","v":460}]
["E","Adicional de Periculosidade",null,0.3,0.13857976735396632,{"$f":"F21*D25","v":345}]
["F","Adicional noturno",null,135,5.6691723008440768E-2,{"$f":"(F21)/220*0.2*D26","v":141.13636363636365}]
["G","Hs noturna reduzida",null,15,4.7243102507033972E-2,{"$f":"F21/220*1.5*D27","v":117.61363636363637}]
["H","Intrajornada",null,15,4.7243102507033972E-2,{"$f":"F21/220*1.5*D28","v":117.61363636363637}]
["I","Horas Extras - 12x36 Sumula 444 TST",null,6,1.2598160668542394E-2,{"$f":"F21/220*D29","v":31.363636363636367}]
["J","Reflexos no DSR",null,0.17,2.7841935077478692E-2,{"$f":"(F29+F28+F27+F26)*D30","v":69.313636363636377}]
["K","Outros (especificar)",null,null,0,0]
[null,"TOTAL DA REMUNERAÇÃO",null,null,{"$f":"SUM(E21:E31)+0.0001","v":1.0001},{"$f":"SUM(F21:F31)","v":2489.5409090909093}]
[]
["MÓDULO 2: BENEFÍCIOS MENSAIS E DIÁRIOS"]
[]
[2,"Benefícios Mensais e Diários",null,null,"%","Valor (R$)"]
["A","Transporte",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F37/$F$44","v":{"$error":"#REF!"}},{"$f":"D37*44-(F21*0.06)","v":{"$error":"#REF!"}}]
["B","Auxílio Alimentação/Refeição  ",null,null,{"$error":"#REF!"},299]
["C","Assistência Médica e Saúde  ",null,null,{"$error":"#REF!"},53]
["D","Auxílio Creche",null,null,{"$error":"#REF!"},0]
["E","Benefício Social Familiar",null,null,{"$error":"#REF!"},16]
["F","Fundo de formação Profissional",null,null,{"$error":"#REF!"},16]
["G","Outros (Específicar)",null,null,{"$error":"#REF!"}]
[null,"TOTAL DE BENEFÍCIOS MENSAIS E DIÁRIOS",null,null,{"$f":"SUM(E37:E43)-0.0001","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(F37:F43),2)","v":{"$error":"#REF!"}}]
[]
["MÓDULO 3: INSUMOS DIVERSOS"]
[3,"Insumos Diversos",null,null,"%","Valor (R$)"]
["A","Uniformes",null,null,{"$f":"F48/$F$53","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["B","EPI, SESMT, ASO, ETC",null,null,{"$f":"F49/$F$53","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["C","Ferramenta, Maquinas",null,null,{"$f":"F50/$F$53","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["D","Produtos",null,null,{"$f":"F51/$F$53","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["E","Outros (Especificar)",null,null,{"$f":"F52/$F$53","v":{"$error":"#REF!"}}]
[null,"TOTAL DE INSUMOS DIVERSOS",null,null,{"$f":"SUM(E48:E52)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(F48:F52),2)","v":{"$error":"#REF!"}}]
[]
["MÓDULO 4:   ENCARGOS SOCIAIS E TRABALHISTAS"]
["Submódulo 4.1 - Encargos previdenciários e FGTS"]
["4.1","Encargos previdenciários e FGTS",null,null,"%","Valor (R$)"]
["A","INSS",null,null,0.2,{"$f":"(F32*E58)","v":497.9081818181819}]
["B","SESI OU SESC",null,null,1.4999999999999999E-2,{"$f":"(F32*E59)","v":37.34311363636364}]
["C","SENAI OU SENAC",null,null,0.01,{"$f":"(F32*E60)","v":24.895409090909094}]
["D","INCRA",null,null,2E-3,{"$f":"(F32*E61)","v":4.9790818181818191}]
["E","Salário Educação",null,null,2.5000000000000001E-2,{"$f":"(F32*E62)","v":62.238522727272738}]
["F","FGTS",null,null,0.08,{"$f":"(F32*E63)","v":199.16327272727275}]
["G","Seguro Acidente de Trabalho",null,null,2.3599999999999999E-2,{"$f":"(F32*E64)","v":58.75316545454546}]
["H","SEBRAE",null,null,6.0000000000000001E-3,{"$f":"(F32*E65)","v":14.937245454545456}]
[null,"TOTAL do Grupo A   ",null,null,{"$f":"SUM(E58:E65)","v":0.36160000000000009},{"$f":"SUM(F58:F65)","v":900.21799272727287}]
[]
["Submódulo 4.2 - 13º Salário"]
["4.2"," 13º Salário e Adicional de Férias",null,null,"%","Valor (R$)"]
["A","13º salário",null,null,9.0899999999999995E-2,{"$f":"(F32*E70)","v":226.29926863636365}]
["Subtotal",null,null,null,{"$f":"E70","v":9.0899999999999995E-2},{"$f":"F70","v":226.29926863636365}]
["b","Incidência do Submódulo 4.1 sobre 13º Salário",null,null,{"$f":"E71*E66","v":3.2869440000000007E-2},{"$f":"(F32*E72)","v":81.829815538909116}]
["Total de 13.º Salário e Adicional de Férias",null,null,null,{"$f":"(E71+E72)","v":0.12376944000000001},{"$f":"(F71+F72)","v":308.12908417527274}]
[]
["Submódulo 4.3 - Afastamento Maternidade"]
["4.3  ","Afastamento Maternidade",null,null,"%","Valor (R$)"]
["A","Afastamento maternidade",null,null,3.0000000000000001E-3,{"$f":"(F32*E77)","v":7.4686227272727281}]
["B","Incidência do submódulo 4.1 sobre afastamento maternidade",null,null,{"$f":"E66*E77","v":1.0848000000000003E-3},{"$f":"(F32*E78)","v":2.7006539781818191}]
["Total de Afastamento Maternidade",null,null,null,{"$f":"SUM(E77:E78)","v":4.0848000000000004E-3},{"$f":"SUM(F77:F78)","v":10.169276705454546}]
[]
["Submódulo 4.4 - Provisão para Rescisão"]
["4.4"," Provisão para Rescisão",null,null,"%","Valor (R$)"]
["A","Aviso prévio indenizado",null,null,4.1999999999999997E-3,{"$f":"(F32*E83)","v":10.456071818181819}]
["B","Incidência do FGTS sobre o aviso prévio indenizado",null,null,{"$f":"E83*E63","v":3.3599999999999998E-4},{"$f":"(F32*E84)","v":0.83648574545454546}]
["C","Multa do FGTS do aviso prévio indenizado",null,null,4.3499999999999997E-2,{"$f":"(F32*E85)","v":108.29502954545454}]
["D","Aviso prévio trabalhado",null,null,1.6500000000000001E-2,{"$f":"(F32*E86)","v":41.077425000000005}]
["E","Incidência do submódulo 4.1 sobre aviso prévio trabalhado",null,null,{"$f":"E66*E86","v":5.9664000000000019E-3},{"$f":"(F32*E87)","v":14.853596880000007}]
["F","Multa do FGTS do aviso prévio trabalhado",null,null,2.6599999999999999E-2,{"$f":"(F32*E88)","v":66.221788181818184}]
["G","Outros especificar",null,null,0,{"$f":"(F32*E89)","v":0}]
["Total de Provisão para Rescisão",null,null,null,{"$f":"SUM(E83:E89)","v":9.7102399999999991E-2},{"$f":"SUM(F83:F89)","v":241.74039717090909}]
[]
["Submódulo 4.5 - Custo de Reposição do Profissional Ausente"]
["4.5","Custo de Reposição do Profissional Ausente",null,null,"%","Valor (R$)"]
["A","Férias + 1/3",null,null,0.1212,{"$f":"(F32*E94)","v":301.7323581818182}]
["B","Ausência por doença",null,null,2.9000000000000001E-2,{"$f":"(F32*E95)","v":72.196686363636374}]
["C","Licença paternidade",null,null,1E-3,{"$f":"(F32*E96)","v":2.4895409090909095}]
["D","Ausências legais",null,null,1.9199999999999998E-2,{"$f":"(F32*E97)","v":47.799185454545452}]
["E","Ausência por Acidente de trabalho",null,null,5.0000000000000001E-3,{"$f":"(F32*E98)","v":12.447704545454547}]
["F","Outros (especificar)",null,null,0,{"$f":"(F39*E99)","v":0}]
["Subtotal",null,null,null,{"$f":"SUM(E94:E99)","v":0.1754},{"$f":"(F32*E100)","v":436.66547545454551}]
["G","Incidência do submódulo 4.1 sobre o Custo de reposição",null,null,{"$f":"(E66*E100)","v":6.3424640000000018E-2},{"$f":"(F32*E101)","v":157.89823592436369}]
["Total do Custo de Reposição do Profisional Ausente",null,null,null,{"$f":"SUM(E100:E101)","v":0.23882464000000003},{"$f":"SUM(F100:F101)","v":594.56371137890915}]
[]
["QUADRO-RESUMO - MÓDULO 4 - ENCARGOS SOCIAIS E TRABALHISTAS"]
[4,"Módulo 4  - Encargos Socias e Trabalhistas",null,null,"%","Valor (R$)"]
["4.2","Encargos previdenciários e FGTS",null,null,{"$f":"E66","v":0.36160000000000009},{"$f":"F66","v":900.21799272727287}]
["4.1","13º salário",null,null,{"$f":"E73","v":0.12376944000000001},{"$f":"F32*E107","v":308.12908417527279}]
["4.3","Afastamento maternidade",null,null,{"$f":"E79","v":4.0848000000000004E-3},{"$f":"F79","v":10.169276705454546}]
["4.4","Provisão para Rescisão",null,null,{"$f":"E90","v":9.7102399999999991E-2},{"$f":"F90","v":241.74039717090909}]
["4.5","Custo de reposição do profissional ausente",null,null,{"$f":"E102","v":0.23882464000000003},{"$f":"F102","v":594.56371137890915}]
["4.6","Outros (especificar)",null,null,0,0]
["Total dos Encargos Sociais e Trabalhistas",null,null,null,{"$f":"SUM(E106:E111)","v":0.82538128000000011},{"$f":"ROUND(SUM(F106:F111),2)","v":2054.8200000000002},{"$f":"H112-F112","v":4.6215781821956625E-4},{"$f":"E112*$F$32","v":2054.8204621578184}]
[]
["MÓDULO 5 - CUSTOS INDIRETOS, TRIBUTOS E LUCRO"]
[5,"Custos indiretos, tributos e lucro",null,null,"%","Valor R$"]
["A","Custos indiretos (DOA - Subtotal dos módulos (1+2+3+4)",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(F32+F44+F53+F112)*E116","v":{"$error":"#REF!"}}]
["B","Tributos",null,null,null,{"$f":"F118+F127","v":{"$error":"#REF!"}}]
[null,"B.1 Tributos Federais (específicar)",null,null,null,{"$f":"F32+F44+F53+F112+F116","v":{"$error":"#REF!"}}]
[null,"B.1.1 PIS",null,null,1.6500000000000001E-2,{"$f":"(E119*F117)/(1-E126)","v":{"$error":"#REF!"}}]
[null,"B.1.2 COFINS",null,null,7.5999999999999998E-2,{"$f":"(E120*F117)/(1-E126)","v":{"$error":"#REF!"}}]
[null,"B.1.3 IRPJ  - PROIBIDO CONFORME ACORDÃO 950/2007",null,null,0,{"$f":"(E121*F117)/(1-E126)","v":{"$error":"#REF!"}}]
[null,"B.1.4 CSLL - PROIBIDO CONFORME ACORDÃO 950/2007",null,null,0,{"$f":"(E122*F117)/(1-E126)","v":{"$error":"#REF!"}}]
[null,"B.2 Tributos Estaduais (especificar)"]
[null,"",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(E124*F117)/(1-E126)","v":{"$error":"#REF!"}}]
[null,"B.4 Outros tributos (específicar)",null,null,null,{"$f":"(E125*F118)/(1-E126)","v":{"$error":"#REF!"}}]
["Total dos Tributos",null,null,null,{"$f":"SUM(E119:E125)","v":{"$error":"#REF!"}},{"$f":"(E126*F117)/(1-E126)","v":{"$error":"#REF!"}},{"$f":"H126-F126","v":{"$error":"#REF!"}},{"$f":"F137*E126","v":{"$error":"#REF!"}}]
["C","Lucro",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"E127*F118","v":{"$error":"#REF!"}}]
[null,"TOTAL -  Custos Indiretos, Tributos e Lucros",null,null,null,{"$f":"ROUND(F116+F126+F127,2)","v":{"$error":"#REF!"}}]
[]
["Anexo III – B – Quadro-resumo do Custo por Empregado"]
[null,"Mão-de-obra vinculada à execução contratual (Valor por empregado)",null,null,null,"Valor (R$)"]
["A","Módulo 1 - Composição da Remuneração",null,null,{"$f":"F132/$F$137","v":{"$error":"#REF!"}},{"$f":"ROUND(F32,2)","v":2489.54}]
["B","Módulo 2 - Benefícios Mensais e Diários",null,null,{"$f":"F133/$F$137","v":{"$error":"#REF!"}},{"$f":"ROUND(F44,2)","v":{"$error":"#REF!"}}]
["C","Módulo 3 - Insumos Diversos (uniformes, materiais, equipamentos e outros)",null,null,{"$f":"F134/$F$137","v":{"$error":"#REF!"}},{"$f":"ROUND(F53,2)","v":{"$error":"#REF!"}}]
["D","Módulo 4 - Encargos Sociais e Trabalhistas (A+B+C+D)",null,null,{"$f":"F135/$F$137","v":{"$error":"#REF!"}},{"$f":"ROUND(F112,2)","v":2054.8200000000002}]
["E","Módulo 5 - Custos indiretos, tributos e lucro",null,null,{"$f":"F136/$F$137","v":{"$error":"#REF!"}},{"$f":"ROUND(F128,2)","v":{"$error":"#REF!"}}]
[null,"VALOR TOTAL POR EMPREGADO",null,null,{"$f":"SUM(E132:E136)","v":{"$error":"#REF!"}},{"$f":"ROUND(SUM(F132:F136),2)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
["COSTA OESTE SERVIÇOS DE LIMPEZA EIRELI"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Uniforme","index":6,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["A"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["PLANIHA UNIFORMES"]
[]
[]
["DEMAIS FUNÇÕES"]
["ITEM","DESCRIÇÃO","QTDE","R$ UNIT","R$ TOTAL"]
[1,"Calça Operacional",2,36.5,{"$f":"D10*C10","v":73}]
[2,"Camisa Operacional",4,22,{"$f":"D11*C11","v":88}]
[3,"Sapato de segurança",2,23,{"$f":"D12*C12","v":46}]
[4,"Cracha de identificação",1,9,{"$f":"D13*C13","v":9}]
["TOTAL GERAL",null,null,null,{"$f":"SUM(E10:E13)","v":216}]
["PERIODO TROCA MESES",null,null,null,12]
["TOTAL POR MêS",null,null,null,{"$f":"E14/E15","v":18}]
[]
[]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
["COSTA OESTE SERVIÇOS DE LIMPEZA EIRELI"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Equip_Maq_","index":7,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["A"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
["PLANILHA DE EQUIPAMENTO, MATERIAIS E MAQUINAS PERMANENTES"]
[]
[]
[]
[]
["ITEM","ESPECIFICAÇÃO","UNID.","QUANT.","Valor Unitário R$","DURABILIDADE MÊS","Valor Total R$"]
[1,"Carrinho para transporte de lixo","Unidade",2,450,36,{"$f":"(E10*D10)/F10","v":25}]
[2,"Enceradeira grande","Unidade",1,1150,36,31.944444444444443]
[3,"Enceradeira pequena","Unidade",1,880,36,24.444444444444443]
[4,"Lixeira plástica de 12 litros","Unidade",48,15,12,60]
[5,"Escada de ferro com seis degraus","Unidade",2,89.95,36,4.9972222222222227]
[6,"Máquina de alta pressão para lavar piso","Unidade",1,349,36,9.6944444444444446]
[7,"Carrinho funcional para limpeza da área de saúde, contendo no mínimo esfregão, conjunto de MOP’S, pá de lixo","Unidade",1,350,48,7.291666666666667]
[8,"Suporte saco hamper, material aço inoxidável, acabamento tubos redondos, com 4 rodízios, diâmetro 50, altura 80,5. Saco de lona lavável preso por cadarço.","Unidade",1,320,48,6.666666666666667]
["CUSTO MENSAL DOS EQUIPAMENTOS/MAQUINAS",null,null,null,null,null,{"$f":"SUM(G10:G17)","v":170.03888888888889}]
["QUANTIDADE DE POSTOS DE TRABALHO A RATEAR CUSTO",null,null,null,null,null,5]
["VALOR DOS EQUIPAMENTOS MENSAL P/ POSTOS",null,null,null,null,null,{"$f":"G18/G19","v":34.007777777777775}]
[]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["COSTA OESTE SERVIÇOS DE LIMPEZA EIRELI"]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}}]

{"sheet":"TRT_-_TRIB_","index":8,"n_rows":137,"n_cols":36,"rows_kept":137,"cut":false,"hidden":true,"merged":[]}
["4.3 POLO LONDRINA"]
[]
["RELAÇÃO DE MATERIAIS / UTENSILIOS PARA LIMPEZA"]
[]
["Item","Material a ser distribuído ANUALMENTE",null,null,null,null,null,null,null,"Qtde","Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,"DIFERENÇA","Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,null,null,"DIFERENÇA",null,"Valor Unitário (R$)",null,"Valor Total (R$)"]
[1,"Lã de aço",null,null,null,null,null,null,null,9,1.1100000000000001,null,null,{"$f":"J6*K6","v":9.99},null,null,{"$f":"K6-R6","v":0.28000000000000014},0.83,null,null,{"$f":"R6*J6","v":7.47},null,null,null,null,{"$f":"K6-AB6","v":0.28000000000000014},{"$f":"Z6/K6","v":0.25225225225225234},0.83,null,{"$f":"AB6*J6","v":7.47}]
[2,"Seladora para pisos",null,null,null,null,null,null,null,0,58,null,null,{"$f":"J7*K7","v":0},null,null,23.1,34.9,null,null,{"$f":"R7*J7","v":0},null,null,null,null,{"$f":"K7-AB7","v":23.1},{"$f":"Z7/K7","v":0.39827586206896554},34.9,null,{"$f":"AB7*J7","v":0}]
[3,"Vassoura Mágica",null,null,null,null,null,null,null,1,118.12,null,null,{"$f":"J8*K8","v":118.12},null,null,57.120000000000005,61,null,null,{"$f":"R8*J8","v":61},null,null,null,null,{"$f":"K8-AB8","v":50.120000000000005},{"$f":"Z8/K8","v":0.42431425668811379},68,null,{"$f":"AB8*J8","v":68}]
["Valor Total Anual",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N6:O8)","v":128.11000000000001},null,null,0,null,null,null,{"$f":"SUM(U6:U8)","v":68.47},null,null,null,null,null,null,null,null,{"$f":"SUM(AD6:AD8)","v":75.47}]
["Valor Total Mensal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N9/12","v":10.675833333333335},null,null,0,null,null,null,{"$f":"U9/12","v":5.7058333333333335},null,null,null,null,null,null,null,null,{"$f":"AD9/12","v":6.2891666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Item","Material a ser distribuído SEMESTRALMENTE",null,null,null,null,null,null,null,"Qtde","Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,{"$error":"#VALUE!"},"Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,null,null,null,null,"Valor Unitário (R$)",null,"Valor Total (R$)"]
[1,"Balde - 8 litros",null,null,null,null,null,null,null,29,4,null,null,{"$f":"J13*K13","v":116},null,null,0.54999999999999982,3.45,null,null,{"$f":"R13*J13","v":100.05000000000001},null,null,null,null,{"$f":"K13-AB13","v":0.54999999999999982},{"$f":"Z13/K13","v":0.13749999999999996},3.45,null,{"$f":"AB13*J13","v":100.05000000000001}]
[2,"Balde - 15 litros",null,null,null,null,null,null,null,13,6.5,null,null,84.5,null,null,2,4.5,null,null,58.5,null,null,null,null,2,0.30769230769230771,4.5,null,58.5]
[3,"Balde espremedor - mínimo 24 litros",null,null,null,null,null,null,null,20,206,null,null,4120,null,null,-38,244,null,null,4880,null,null,null,null,71.28,0.34601941747572817,134.72,null,2694.4]
[4,"Escova de Mão",null,null,null,null,null,null,null,36,2.7,null,null,97.2,null,null,0.85000000000000009,1.85,null,null,66.600000000000009,null,null,null,null,0.85000000000000009,0.31481481481481483,1.85,null,66.600000000000009,null,null,null,null,null,0]
[5,"Espanador",null,null,null,null,null,null,null,28,3.5,null,null,98,null,null,-8.5,12,null,null,336,null,null,null,null,4.9999999999999822E-2,1.4285714285714235E-2,3.45,null,96.600000000000009]
[6,"Espanador Eletrostático",null,null,null,null,null,null,null,0,15.5,null,null,0,null,null,-1.3999999999999986,16.899999999999999,null,null,0,null,null,null,null,0.5,3.2258064516129031E-2,15,null,0]
[7,"Extensor para limpeza de vidros",null,null,null,null,null,null,null,9,79.680000000000007,null,null,717.12000000000012,null,null,66.2,13.48,null,null,121.32000000000001,null,null,null,null,17.680000000000007,0.22188755020080328,62,null,558]
[8,"Kit Completo Mop Água/Pó",null,null,null,null,null,null,null,1,45.81,null,null,45.81,null,null,-66.19,112,null,null,112,null,null,null,null,3.8100000000000023,8.3169613621480065E-2,42,null,42]
[9,"Limpa Tudo (suporte LT com cabo de alumínio  22mm x 1.40m)",null,null,null,null,null,null,null,5,35,null,null,175,null,null,16.100000000000001,18.899999999999999,null,null,94.5,null,null,null,null,16.100000000000001,0.46,18.899999999999999,null,94.5]
[10,"Mop seco (cabo+base+cabeleira)",null,null,null,null,null,null,null,3,76.650000000000006,null,null,229.95000000000002,null,null,47.850000000000009,28.8,null,null,86.4,null,null,null,null,47.850000000000009,0.62426614481409004,28.8,null,86.4]
[11,"Mop úmido (cabo+cabeleira)",null,null,null,null,null,null,null,0,23.94,null,null,0,null,null,4.6400000000000006,19.3,null,null,0,null,null,null,null,4.6400000000000006,0.19381787802840436,19.3,null,0]
[12,"Pá coletora de lixo",null,null,null,null,null,null,null,20,19.98,null,null,399.6,null,null,15.48,4.5,null,null,90,null,null,null,null,15.48,0.77477477477477474,4.5,null,90]
[13,"Pá coletora de lixo com cabo",null,null,null,null,null,null,null,22,3.67,null,null,80.739999999999995,null,null,-7.6300000000000008,11.3,null,null,248.60000000000002,null,null,null,null,-4.33,-1.1798365122615804,8,null,176]
[14,"Palha de aço",null,null,null,null,null,null,null,36,0.6,null,null,21.599999999999998,null,null,-0.22999999999999998,0.83,null,null,29.88,null,null,null,null,0,0,0.6,null,21.599999999999998]
[15,"Rodo médio de borracha (40cm) - cabo de alumínio",null,null,null,null,null,null,null,43,8,null,null,344,null,null,2.5,5.5,null,null,236.5,null,null,null,null,2.5,0.3125,5.5,null,236.5]
[16,"Rodo grande de borracha (80cm) - cabo de alumínio",null,null,null,null,null,null,null,19,12.8,null,null,243.20000000000002,null,null,-32.200000000000003,45,null,null,855,null,null,null,null,-9.1999999999999993,-0.71874999999999989,22,null,418]
[17,"Rodo para vidros",null,null,null,null,null,null,null,16,33,null,null,528,null,null,10.149999999999999,22.85,null,null,365.6,null,null,null,null,10.149999999999999,0.30757575757575756,22.85,null,365.6]
[18,"Vassoura de piaçava com cabo - 40cm largura",null,null,null,null,null,null,null,27,10.15,null,null,274.05,null,null,-0.45999999999999908,10.61,null,null,286.46999999999997,null,null,null,null,-0.45999999999999908,-4.5320197044334883E-2,10.61,null,286.46999999999997]
[19,"Vassoura de nylon c/cabo - 60cm largura",null,null,null,null,null,null,null,41,10.5,null,null,430.5,null,null,5,5.5,null,null,225.5,null,null,null,null,3,0.2857142857142857,7.5,null,307.5]
[20,"Vassoura de pêlo com cabo - 60cm largura",null,null,null,null,null,null,null,1,20,null,null,20,null,null,13.8,6.2,null,null,6.2,null,null,null,null,13.8,0.69000000000000006,6.2,null,6.2]
["Valor Total Semestral",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N13:O32)","v":8025.27},null,null,0,null,null,null,{"$f":"SUM(U13:V32)","v":8199.1200000000026},null,null,null,null,null,null,null,null,{"$f":"SUM(AD13:AE32)","v":5704.92}]
["Valor Total Mensal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N33/6","v":1337.5450000000001},null,null,0,null,null,null,{"$f":"U33/6","v":1366.5200000000004},null,null,null,null,null,null,null,null,{"$f":"AD33/6","v":950.82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"M35-AB35","v":0},{"$f":"Z35/M35","v":{"$error":"#DIV/0!"}}]
["Item","Material a ser distribuído TRIMESTRALMENTE",null,null,null,null,null,null,null,null,"Qtde","Valor Unitário (R$)",null,"Valor Total (R$)",null,null,{"$error":"#VALUE!"},"Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,null,null,{"$f":"M36-AB36","v":{"$error":"#VALUE!"}},{"$f":"Z36/M36","v":{"$error":"#VALUE!"}},"Valor Unitário (R$)",null,"Valor Total (R$)"]
[1,"Aplicador de cera",null,null,null,null,null,null,null,null,2,6.5,null,{"$f":"K37*L37","v":13},null,null,-3.2199999999999998,5.22,null,null,{"$f":"R37*K37","v":10.44},null,null,null,null,{"$f":"L37-AB37","v":1.2800000000000002},{"$f":"Z37/L37","v":0.19692307692307695},5.22,null,{"$f":"AB37*K37","v":10.44}]
[2,"Escova sanitária",null,null,null,null,null,null,null,null,49,2.86,null,{"$f":"K38*L38","v":140.13999999999999},null,null,{"$f":"K38-R38","v":45.95},3.05,null,null,{"$f":"R38*K38","v":149.44999999999999},null,null,null,null,{"$f":"L38-AB38","v":1.6099999999999999},{"$f":"Z38/L38","v":0.56293706293706292},1.25,null,{"$f":"AB38*K38","v":61.25}]
[3,"Pulverizador para limpeza de vidros",null,null,null,null,null,null,null,null,24,3.75,null,{"$f":"K39*L39","v":90},null,null,21.06,2.94,null,null,{"$f":"R39*K39","v":70.56},null,null,null,null,{"$f":"L39-AB39","v":0.81},{"$f":"Z39/L39","v":0.21600000000000003},2.94,null,{"$f":"AB39*K39","v":70.56}]
[4,"Refil mop (cabeleira)",null,null,null,null,null,null,null,null,7,19,null,{"$f":"K40*L40","v":133},null,null,-4.34,11.34,null,null,{"$f":"R40*K40","v":79.38},null,null,null,null,{"$f":"L40-AB40","v":5},{"$f":"Z40/L40","v":0.26315789473684209},14,null,{"$f":"AB40*K40","v":98}]
["Valor Total Trimestral",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N37:O40)","v":376.14},null,null,0,null,null,null,{"$f":"SUM(U37:V40)","v":309.83},null,null,null,null,null,null,null,null,{"$f":"SUM(AD37:AE40)","v":240.25}]
["Valor Total Mensal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N41/3","v":125.38},null,null,0,null,null,null,{"$f":"U41/3","v":103.27666666666666},null,null,null,null,null,null,null,null,{"$f":"AD41/3","v":80.083333333333329}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Item","Material a ser distribuído MENSALMENTE",null,null,null,null,null,null,null,null,"Qtde","Valor Unitário (R$)",null,"Valor Total (R$)",null,null,{"$error":"#VALUE!"},"Valor Unitário (R$)",null,null,"Valor Total (R$)",null,null,null,null,null,null,"Valor Unitário (R$)",null,"Valor Total (R$)"]
[1,"Água Sanitária - 1 litro",null,null,null,null,null,null,null,null,125,2.5,null,{"$f":"K45*L45","v":312.5},null,null,123.52,1.48,null,null,{"$f":"R45*K45","v":185},null,null,null,null,{"$f":"L45-AB45","v":1.02},{"$f":"Z45/L45","v":0.40800000000000003},1.48,null,{"$f":"AB45*K45","v":185}]
[2,"Álcool 70% - gel",null,null,null,null,null,null,null,null,56,5.7,null,{"$f":"K46*L46","v":319.2},null,null,53.07,2.93,null,null,164.08,null,null,null,null,2.77,0.48596491228070177,2.93,null,164.08]
[3,"Álcool 70% - líquido - hospitalar",null,null,null,null,null,null,null,null,27,6.49,null,{"$f":"K47*L47","v":175.23000000000002},null,null,23.92,3.08,null,null,83.16,null,null,null,null,2.3900000000000006,0.36825885978428358,4.0999999999999996,null,110.69999999999999]
[null,"limpeza de filtros elétricos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,0,{"$error":"#DIV/0!"},null,null,0]
[4,"Cera composta de no mínimo 20% de emulsão de polímeros acrílicos, auto brilho, auto tráfego e anti-derrapante",null,null,null,null,null,null,null,null,0,36.700000000000003,null,{"$f":"K49*L49","v":0},null,null,-8,8,null,null,0,null,null,null,null,14.700000000000003,0.40054495912806543,22,null,0]
[5,"Desinfetante pinho concentrado",null,null,null,null,null,null,null,null,122,4.38,null,534.36,null,null,120.66,1.34,null,null,163.48000000000002,null,null,null,null,3.1799999999999997,0.72602739726027388,1.2,null,146.4]
[6,"Desinfetante tensoativo não ionico, quaternário de amônia",null,null,null,null,null,null,null,null,1,10.3,null,10.3,null,null,-23.69,24.69,null,null,24.69,null,null,null,null,-4.6999999999999993,-0.45631067961165039,15,null,15]
[7,"Detergente Amoniacal",null,null,null,null,null,null,null,null,6,22,null,132,null,null,-3.6899999999999995,9.69,null,null,58.14,null,null,null,null,12.21,0.55500000000000005,9.7899999999999991,null,58.739999999999995]
[8,"Detergente desengraxante",null,null,null,null,null,null,null,null,11,22,null,242,null,null,-4.9000000000000004,15.9,null,null,174.9,null,null,null,null,6.1,0.27727272727272728,15.9,null,174.9]
[9,"Detergente removedor de cera",null,null,null,null,null,null,null,null,0,33.4,null,0,null,null,-20.2,20.2,null,null,0,null,null,null,null,13.2,0.39520958083832336,20.2,null,0]
[10,"Disco verde p/ enceradeira industrial 300 mm",null,null,null,null,null,null,null,null,3,9.5,null,28.5,null,null,-10,13,null,null,39,null,null,null,null,0,0,9.5,null,28.5]
[11,"Disco verde p/ enceradeira industrial 350 mm",null,null,null,null,null,null,null,null,0,12.5,null,0,null,null,-13,13,null,null,0,null,null,null,null,0,0,12.5,null,0]
[12,"Disco verde p/ enceradeira industrial 410 mm",null,null,null,null,null,null,null,null,0,15.5,null,0,null,null,-18.2,18.2,null,null,0,null,null,null,null,3,0.19354838709677419,12.5,null,0]
[13,"Disco branco ou bege p/ enceradeira industrial 300 mm",null,null,null,null,null,null,null,null,0,10.53,null,0,null,null,-13,13,null,null,0,null,null,null,null,0,0,10.53,null,0]
[14,"Disco branco ou bege p/ enceradeira industrial 350 mm",null,null,null,null,null,null,null,null,0,14.1,null,0,null,null,-13,13,null,null,0,null,null,null,null,1.0999999999999996,7.8014184397163094E-2,13,null,0]
[15,"Disco branco ou bege p/ enceradeira industrial 410 mm",null,null,null,null,null,null,null,null,0,18.350000000000001,null,0,null,null,-21,21,null,null,0,null,null,null,null,0.35000000000000142,1.9073569482288905E-2,18,null,0]
[16,"Disco preto p/ enceradeira industrial 300 mm",null,null,null,null,null,null,null,null,2,8.5,null,17,null,null,-25.9,27.9,null,null,55.8,null,null,null,null,0.5,5.8823529411764705E-2,8,null,16]
[17,"Disco preto p/ enceradeira industrial 350 mm",null,null,null,null,null,null,null,null,0,9.9,null,0,null,null,-27.9,27.9,null,null,0,null,null,null,null,0.90000000000000036,9.0909090909090939E-2,9,null,0]
[18,"Disco preto p/ enceradeira industrial 410 mm",null,null,null,null,null,null,null,null,0,19,null,0,null,null,-21.9,21.9,null,null,0,null,null,null,null,0,0,19,null,0]
[19,"Esponja de fibra dupla face",null,null,null,null,null,null,null,null,100,0.6,null,60,null,null,99.51,0.49,null,null,49,null,null,null,null,0.10999999999999999,0.18333333333333332,0.49,null,49]
[20,"Esponja de fibra verde limpeza pesada",null,null,null,null,null,null,null,null,70,0.95,null,66.5,null,null,69.010000000000005,0.99,null,null,69.3,null,null,null,null,2.9999999999999916E-2,3.1578947368420963E-2,0.92,null,64.400000000000006]
[21,"Flanela branca/amarela medindo 50x50 cm",null,null,null,null,null,null,null,null,81,1.28,null,103.68,null,null,79.34,1.66,null,null,134.45999999999998,null,null,null,null,3.0000000000000027E-2,2.3437500000000021E-2,1.25,null,101.25]
[22,"Fibra branca multiuso",null,null,null,null,null,null,null,null,8,0.68,null,5.44,null,null,7.16,0.84,null,null,6.72,null,null,null,null,3.0000000000000027E-2,4.4117647058823567E-2,0.65,null,5.2]
[23,"Fibra verde multiuso",null,null,null,null,null,null,null,null,25,0.95,null,23.75,null,null,23.9,1.1000000000000001,null,null,27.500000000000004,null,null,null,null,4.9999999999999933E-2,5.2631578947368356E-2,0.9,null,22.5]
[24,"Hipoclorito de sódio a + ou - 10%",null,null,null,null,null,null,null,null,5,9.44,null,47.199999999999996,null,null,-13.5,18.5,null,null,92.5,null,null,null,null,0,0,9.44,null,47.199999999999996]
[25,"Impermeabilizante incolor",null,null,null,null,null,null,null,null,0,17.7,null,0,null,null,{"$f":"K70-R70","v":-65},65,null,null,0,null,null,null,null,-14.3,-0.80790960451977412,32,null,0]
[26,"Limpa carpete",null,null,null,null,null,null,null,null,11,4,null,44,null,null,-15.8,26.8,null,null,294.8,null,null,null,null,0,0,4,null,44]
[27,"Limpa pedras",null,null,null,null,null,null,null,null,15,7.2,null,108,null,null,5.5500000000000007,9.4499999999999993,null,null,141.75,null,null,null,null,0,0,7.2,null,108]
[28,"Limpa vidros",null,null,null,null,null,null,null,null,16,12.92,null,206.72,null,null,9.98,6.02,null,null,96.32,null,null,null,null,6.9,0.53405572755417963,6.02,null,96.32]
[29,"Limpador geral  ",null,null,null,null,null,null,null,null,6,11.39,null,68.34,null,null,-3.4800000000000004,9.48,null,null,56.88,null,null,null,null,1.9100000000000001,0.16769095697980685,9.48,null,56.88]
[30,"Limpador multiuso",null,null,null,null,null,null,null,null,95,1.53,null,145.35,null,null,85.52,9.48,null,null,900.6,null,null,null,null,0,0,1.53,null,145.35]
[31,"Lustra-móveis - 200ml",null,null,null,null,null,null,null,null,28,1.65,null,46.199999999999996,null,null,26.14,1.86,null,null,52.080000000000005,null,null,null,null,0,0,1.65,null,46.199999999999996]
[32,"Luva de látex de 1ª qualidade - Amarela pequena",null,null,null,null,null,null,null,null,25,2.8,null,70,null,null,22.21,2.79,null,null,{"$f":"R77*K77","v":69.75},null,null,null,null,{"$f":"L77-AB77","v":9.9999999999997868E-3},{"$f":"Z77/L77","v":3.5714285714284954E-3},2.79,null,{"$f":"AB77*K77","v":69.75}]
[33,"Luva de látex de 1ª qualidade - Amarela média",null,null,null,null,null,null,null,null,30,2.8,null,84,null,null,27.21,2.79,null,null,83.7,null,null,null,null,9.9999999999997868E-3,3.5714285714284954E-3,2.79,null,83.7]
[34,"Luva de látex de 1ª qualidade - Amarela grande",null,null,null,null,null,null,null,null,15,2.8,null,42,null,null,12.21,2.79,null,null,41.85,null,null,null,null,9.9999999999997868E-3,3.5714285714284954E-3,2.79,null,41.85]
[35,"Luva de látex de 1ª qualidade - Azul pequena",null,null,null,null,null,null,null,null,6,4.41,null,26.46,null,null,3.21,2.79,null,null,16.740000000000002,null,null,null,null,1.62,0.36734693877551022,2.79,null,16.740000000000002]
[36,"Luva de látex de 1ª qualidade - Azul média",null,null,null,null,null,null,null,null,22,4.41,null,{"$f":"K81*L81","v":97.02000000000001},null,null,19.21,2.79,null,null,61.38,null,null,null,null,1.62,0.36734693877551022,2.79,null,61.38]
[37,"Luva de látex de 1ª qualidade - Azul grande",null,null,null,null,null,null,null,null,6,4.41,null,26.46,null,null,3.21,2.79,null,null,16.740000000000002,null,null,null,null,1.62,0.36734693877551022,2.79,null,16.740000000000002]
[38,"Luva de látex de 1ª qualidade - Verde pequena",null,null,null,null,null,null,null,null,0,6.69,null,0,null,null,-2.79,2.79,null,null,0,null,null,null,null,3.9000000000000004,0.5829596412556054,2.79,null,0]
[39,"Neutralizador de odores - 360ml",null,null,null,null,null,null,null,null,61,8.99,null,548.39,null,null,56.54,4.46,null,null,272.06,null,null,null,null,4.53,0.50389321468298109,4.46,null,272.06]
[40,"Óleo de peroba - 200ml",null,null,null,null,null,null,null,null,3,7.65,null,22.950000000000003,null,null,-0.89000000000000012,3.89,null,null,11.67,null,null,null,null,3.7600000000000002,0.49150326797385624,3.89,null,11.67]
[41,"Pano de chão de saco alvejado especial 40x70, para limpeza de piso - cor branca",null,null,null,null,null,null,null,null,91,2.48,null,225.68,null,null,88.81,2.19,null,null,199.29,null,null,null,null,0.29000000000000004,0.11693548387096776,2.19,null,199.29]
[42,"Pano para secar louça",null,null,null,null,null,null,null,null,16,2,null,32,null,null,14.22,1.78,null,null,28.48,null,null,null,null,0.21999999999999997,0.10999999999999999,1.78,null,28.48]
[43,"Polidor líquido p/metais - 500ml",null,null,null,null,null,null,null,null,0,4.5,null,0,null,null,-14.9,14.9,null,null,0,null,null,null,null,0,0,4.5,null,0]
[44,"Removedor de cêra",null,null,null,null,null,null,null,null,1,56.5,null,56.5,null,null,-19.2,20.2,null,null,20.2,null,null,null,null,4.5,7.9646017699115043E-2,52,null,52]
[45,"Sabão em barra (5x200g)",null,null,null,null,null,null,null,null,19,5.2,null,98.8,null,null,18.39,0.61,null,null,11.59,null,null,null,null,0.20000000000000018,3.8461538461538491E-2,5,null,95]
[46,"Sabão em pó a base de aquil benzeno sulfato",null,null,null,null,null,null,null,null,22,5.01,null,110.22,null,null,18.34,3.66,null,null,80.52000000000001,null,null,null,null,1.3499999999999996,0.26946107784431134,3.66,null,80.52000000000001]
[47,"Sabão líquido para piso",null,null,null,null,null,null,null,null,23,15.96,null,367.08000000000004,null,null,13.21,9.7899999999999991,null,null,225.17,null,null,null,null,6.1700000000000017,0.38659147869674193,9.7899999999999991,null,225.17]
[48,"Saco de lixo azul - 50 L",null,null,null,null,null,null,null,null,2,8.19,null,16.38,null,null,-9.26,11.26,null,null,22.52,null,null,null,null,-3.0700000000000003,-0.3748473748473749,11.26,null,22.52]
[49,"Saco de lixo azul - 60 L",null,null,null,null,null,null,null,null,3,10.52,null,31.56,null,null,-9.26,12.26,null,null,36.78,null,null,null,null,-1.7400000000000002,-0.16539923954372626,12.26,null,36.78]
[50,"Saco de lixo azul - 100 L",null,null,null,null,null,null,null,null,7,22.42,null,156.94,null,null,-11.39,18.39,null,null,128.73000000000002,null,null,null,null,4.0300000000000011,0.17975022301516508,18.39,null,128.73000000000002]
[51,"Saco de lixo preto - 20 L",null,null,null,null,null,null,null,null,13,4.55,null,59.15,null,null,9.15,3.85,null,null,50.050000000000004,null,null,null,null,0.69999999999999973,0.1538461538461538,3.85,null,50.050000000000004]
[52,"Saco de lixo preto - 40 L",null,null,null,null,null,null,null,null,10,7.07,null,70.7,null,null,4.2699999999999996,5.73,null,null,57.300000000000004,null,null,null,null,1.3399999999999999,0.1895332390381895,5.73,null,57.300000000000004]
[53,"Saco de lixo preto - 50 L",null,null,null,null,null,null,null,null,0,"                        -   ",null,0,null,null,-7.54,7.54,null,null,0,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},7.54,null,0]
[54,"Saco de lixo preto - 60 L",null,null,null,null,null,null,null,null,9,8.59,null,{"$f":"K99*L99","v":77.31},null,null,0.46000000000000085,8.5399999999999991,null,null,76.859999999999985,null,null,null,null,5.0000000000000711E-2,5.8207217694995006E-3,8.5399999999999991,null,76.859999999999985]
[55,"Saco de lixo preto - 100 L",null,null,null,null,null,null,null,null,13,19,null,{"$f":"K100*L100","v":247},null,null,-3.1499999999999986,16.149999999999999,null,null,209.95,null,null,null,null,2.8500000000000014,0.15000000000000008,16.149999999999999,null,209.95]
[56,"Saco de lixo preto - 150 L",null,null,null,null,null,null,null,null,2,35.44,null,{"$f":"K101*L101","v":70.88},null,null,-21.21,23.21,null,null,46.42,null,null,null,null,12.229999999999997,0.34509029345372455,23.21,null,46.42]
[57,"Saco de lixo vermelho - 40 L",null,null,null,null,null,null,null,null,0,9.4,null,{"$f":"K102*L102","v":0},null,null,{"$f":"K102-R102","v":-6.17},6.17,null,null,0,null,null,null,null,3.2300000000000004,0.34361702127659577,6.17,null,0]
[58,"Saco de lixo vermelho - 50 L",null,null,null,null,null,null,null,null,0,"                        -   ",null,0,null,null,-11.26,11.26,null,null,0,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},11.26,null,0]
[59,"Saco de lixo vermelho - 60 L",null,null,null,null,null,null,null,null,3,12.08,null,{"$f":"K104*L104","v":36.24},null,null,-9.26,12.26,null,null,36.78,null,null,null,null,-0.17999999999999972,-1.4900662251655606E-2,12.26,null,36.78]
[60,"Saco de lixo vermelho - 100 L",null,null,null,null,null,null,null,null,2,22,null,44,null,null,-16.39,18.39,null,null,36.78,null,null,null,null,3.6099999999999994,0.16409090909090907,18.39,null,36.78]
[61,"Saco de lixo cinza - 60 L",null,null,null,null,null,null,null,null,0,10.52,null,0,null,null,-12.26,12.26,null,null,0,null,null,null,null,-1.7400000000000002,-0.16539923954372626,12.26,null,0]
[62,"Saco de lixo cinza - 100 L",null,null,null,null,null,null,null,null,2,22.61,null,45.22,null,null,-16.39,18.39,null,null,36.78,null,null,null,null,4.2199999999999989,0.18664307828394511,18.39,null,36.78]
[63,"Saco de lixo amarelo - 60 L",null,null,null,null,null,null,null,null,1,11.34,null,11.34,null,null,-8.65,9.65,null,null,9.65,null,null,null,null,1.6899999999999995,0.14902998236331566,9.65,null,9.65]
[64,"Saco de lixo hospitalar - 30 L",null,null,null,null,null,null,null,null,1,10.5,null,10.5,null,null,-13.44,14.44,null,null,{"$f":"R109*K109","v":14.44},null,null,null,null,{"$f":"L109-AB109","v":0.5},{"$f":"Z109/L109","v":4.7619047619047616E-2},10,null,{"$f":"AB109*K109","v":10}]
[65,"Saco para aspirador de pó industrial",null,null,null,null,null,null,null,null,8,4.6500000000000004,null,37.200000000000003,null,null,-22,30,null,null,240,null,null,null,null,0,0,4.6500000000000004,null,37.200000000000003]
[66,"Saponáceo líquido - 300ml",null,null,null,null,null,null,null,null,78,2.0499999999999998,null,159.89999999999998,null,null,75.709999999999994,2.29,null,null,178.62,null,null,null,null,4.9999999999999822E-2,2.4390243902438939E-2,2,null,156]
[67,"Silicone gel - jimo - 200ml",null,null,null,null,null,null,null,null,20,10.31,null,206.20000000000002,null,null,10.29,9.7100000000000009,null,null,194.20000000000002,null,null,null,null,0.59999999999999964,5.8195926285160002E-2,9.7100000000000009,null,194.20000000000002]
[68,"Silicone Líquido",null,null,null,null,null,null,null,null,2,15,null,30,null,null,-26.8,28.8,null,null,57.6,null,null,null,null,1,6.6666666666666666E-2,14,null,28]
[69,"Silicone spray couro",null,null,null,null,null,null,null,null,0,"                        -   ",null,0,null,null,-7.6,7.6,null,null,0,null,null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},12,null,0]
[70,"Vaselina líquida - 500 ml",null,null,null,null,null,null,null,null,0,18.5,null,{"$f":"K115*L115","v":0},null,null,-17.600000000000001,17.600000000000001,null,null,0,null,null,null,null,0.89999999999999858,4.8648648648648575E-2,17.600000000000001,null,0]
["Valor Total Mensal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N45:O115)","v":5814.3499999999985},null,null,null,null,null,null,{"$f":"SUM(U45:V115)","v":5442.7599999999984},null,null,null,null,null,null,null,null,{"$f":"SUM(AD45:AE115)","v":4113.9700000000012}]
["Valor Geral Mensal",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N116+N42+N34+N10","v":7287.9508333333324},null,null,null,null,null,null,{"$f":"U116+U42+U34+U10","v":6918.2624999999989},null,null,null,null,null,null,null,null,{"$f":"AD116+AD42+AD34+AD10","v":5151.1625000000004}]
["Total Geral Anual",null,null,null,null,null,null,null,null,null,null,null,null,87495.360000000001,null,null,null,null,null,null,{"$f":"U117*12","v":83019.149999999994},null,null,null,null,null,null,null,null,{"$f":"ROUND(AD117*12,2)","v":61813.95}]
[]
["DESPESAS ADMINISTRATIVAS",null,null,null,null,null,null,null,null,"Percentual",null,"Valor Mensal (R$)",null,"Valor Anual (R$)",null,null,null,"Valor Mensal (R$)",null,null,"Valor Anual",null,null,null,null,null,null,"Valor Mensal (R$)",null,"Valor Anual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(R$)",null,null,null,null,null,null,null,null,"(R$)"]
["INDIRETAS",null,null,null,null,null,null,null,null,2.5000000000000001E-3,null,{"$f":"$N$117*J122","v":18.21987708333333},null,{"$f":"ROUND($N$118,2)*J122","v":218.73840000000001},null,null,null,{"$f":"$M$117*P122","v":0},null,null,{"$f":"ROUND($M$118,2)*P122","v":0},null,null,null,null,null,null,{"$f":"J122*AD117","v":12.877906250000001},null,{"$f":"AB122*12","v":154.534875}]
["LUCRO",null,null,null,null,null,null,null,null,7.4999999999999997E-3,null,{"$f":"$N$117*J123","v":54.65963124999999},null,{"$f":"ROUND($N$118,2)*J123","v":656.21519999999998},null,null,null,{"$f":"$M$117*P123","v":0},null,null,{"$f":"ROUND($M$118,2)*P123","v":0},null,null,null,null,null,null,{"$f":"J123*AD117","v":38.63371875},null,{"$f":"AB123*12","v":463.604625}]
["SUBTOTAL 1",null,null,null,null,null,null,null,null,0.12790000000000001,null,{"$f":"SUM(L122:M123)","v":72.87950833333332},null,{"$f":"SUM(N122:O123)","v":874.95360000000005},null,null,null,{"$f":"SUM(R122:T123)","v":0},null,null,{"$f":"SUM(U122:V123)","v":0},null,null,null,null,null,null,{"$f":"SUM(AB122:AC123)","v":51.511625000000002},null,{"$f":"SUM(AD122:AE123)","v":618.1395}]
[]
["TRIBUTAÇÃO SOBRE FATURAMENTO",null,null,null,null,null,null,null,null,"Percentual",null,"Valor Mensal (R$)",null,"Valor Anual (R$)",null,null,null,"Valor Mensal (R$)",null,null,"Valor Anual",null,null,null,null,null,null,"Valor Mensal (R$)",null,"Valor Anual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(R$)",null,null,null,null,null,null,null,null,"(R$)"]
["I.S.S.",null,null,null,null,null,null,null,null,0.05,null,null,{"$f":"L131*J128","v":402.89164431673049},{"$f":"N131*J128","v":4836.9082430213466},null,null,null,{"$f":"R131*P128","v":0},null,null,{"$f":"U131*P128","v":0},null,null,null,null,null,null,{"$f":"J128*AB131","v":303.36292274052488},null,{"$f":"AB128*12","v":3640.3550728862983}]
["PIS/COFINS",null,null,null,null,null,null,null,null,9.2499999999999999E-2,null,null,{"$f":"L131*J129","v":745.34954198595142},{"$f":"N131*J129","v":8948.2802495894903},null,null,null,{"$f":"R131*P129","v":0},null,null,{"$f":"U131*P129","v":0},null,null,null,null,null,null,{"$f":"J129*AB131","v":561.22140706997095},null,{"$f":"AB129*12","v":6734.656884839651}]
["SUBTOTAL 2",null,null,null,null,null,null,null,null,{"$f":"J129+J128","v":0.14250000000000002},null,{"$f":"SUM(M128:M129)","v":1148.2411863026819},null,{"$f":"SUM(N128:O129)","v":13785.188492610836},null,null,null,{"$f":"SUM(R128:T129)","v":0},null,null,{"$f":"SUM(U128:V129)","v":0},null,null,null,null,null,null,{"$f":"J130*AB131","v":864.58432981049589},null,{"$f":"SUM(AD128:AE129)","v":10375.01195772595},null,null,{"$f":"AB130*12","v":10375.01195772595}]
["TOTAL GERAL DE MATERIAIS (SUBTOTAL1 +SUBTOTAL2)",null,null,null,null,null,null,null,null,null,null,{"$f":"(N117+L124)/((100-8.65)/100)","v":8057.8328863346096},null,{"$f":"(N118+N124)/((100-8.65)/100)","v":96738.164860426928},null,null,null,{"$f":"(U117+R124)/((100-8.65)/100)","v":7573.3579638752044},null,null,{"$f":"(U118+U124)/((100-8.65)/100)","v":90880.295566502464},null,null,null,null,null,null,{"$f":"(AB124+AD117)/(1-J130)","v":6067.2584548104969},null,{"$f":"AB131*12","v":72807.101457725963}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB130+AB124+AD117","v":6067.258454810496},null,{"$f":"AD130+AD124+AD118","v":72807.101457725948}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB131*12","v":72807.101457725963}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AB135+AB117)/(1-AA120)","v":0}]

{"sheet":"Planilha3","index":9,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["Planilha de Preços e Consumo Estimado de Materiais"]
[]
["COMARCA DE FOZ DO IGUAÇU"]
["Avenida Pedro Basso, 1001 - CEP 85863-756"]
[]
["Fornecimento Mensal"]
[]
["ITEM","DESCRIÇÃO",null,"QTD","Valor Unitário","TOTAL"]
[1,"Água sanitária","1 Lt",20,1.5,{"$f":"E9*D9","v":30}]
[2,"Álcool Gel - 70%","5 Lt",3,21.5,64.5]
[3,"Álcool gel 46%","1 Lt",11,2.7,29.700000000000003]
[4,"Aparelho limpa tudo",null,3,1.1000000000000001,3.3000000000000003]
[5,"Aplicador de cera em microfibra",null,1,1.24,1.24]
[6,"Balde plástico",null,3,2,6]
[8,"Cera","5 Lt",2,27,54]
[9,"Desentupidor para lavatório",null,1,1,1]
[10,"Desentupidor para vaso sanitário",null,1,1.2,1.2]
[11,"Desinfetante","5 Lt",5,8.5,42.5]
[12,"Desodorizador de ambiente",null,9,4.2,37.800000000000004]
[13,"Detergente líquido neutro","5 Lt",5,10,50]
[14,"Detergente p/ louça","5 Lt",2,10,20]
[15,"Detergente removedor de ceras e impermeabilizantes","5 Lt",1,28,28]
[16,"Disco bege 350 mm",null,1,4.5,4.5]
[17,"Disco branco 350 mm",null,1,4.5,4.5]
[18,"Disco preto 350 mm",null,1,4.5,4.5]
[19,"Disco verde 350 mm",null,1,4.5,4.5]
[20,"Escova de mão",null,1,0.9,0.9]
[21,"Escova macia p/ limpeza de estofados de veludo",null,1,1.5,1.5]
[22,"Esponja dupla face – un","UN.",16,0.2,3.2]
[23,"Fibra limpeza pesada",null,1,0.99,0.99]
[24,"Flanela média branca – 40x60 cm – un",null,6,0.5,3]
[25,"Lã de aço – embalagem c/ 8 un",null,4,0.75,3]
[26,"Limpa carpet – 5 L",null,1,18.5,18.5]
[27,"Limpa vidros - 500 ml",null,1,1.1000000000000001,1.1000000000000001]
[28,"Limpador com cera – 5 L",null,2,18,36]
[29,"Lustra móveis – 500 ml",null,1,2.98,2.98]
[30,"Mangueira de borracha completa c/ esguicho – 50 metros",null,1,4,4]
[31,"Mop pó (conjunto com mop, suporte e cabo)",null,1,3.8,3.8]
[32,"Mop úmido (conjunto com mop, suporte e cabo)",null,1,3.8,3.8]
[33,"Multiuso limpador instantâneo – 500 ml",null,10,3.6,36]
[34,"Pá de lixo cabo longo",null,1,1.2,{"$f":"E41*D41","v":1.2}]
[35,"Papel Higiênico folha dupla - fardos com 64 rolos de 40m -  papel de 1ª linha, branco, folhas duplas, extra macias",null,12,47,564]
[36,"Papel toalha – fardo com 2000 fols, Folhas intercaladas, 3 dobras -  Alto grau de alvura, Resistentes e absorventes. Cor Branca, Folha Simples alta qualidade – gofrado, Celulose FC (100% fibras virgens),",null,13,24,312]
[37,"Pasta branca – 500 g",null,2,1.5,3]
[38,"Pedra sanitária - un com suporte",null,10,0.55000000000000004,5.5]
[39,"Pincel cerdas macias para limpeza de teclados",null,1,0.6,0.6]
[40,"Pulverizador - capacidade 1 L",null,1,1.1000000000000001,1.1000000000000001]
[41,"Querosene – 1 L",null,1,1.5,1.5]
[42,"Rodo de plástico com duas borrachas – 40 cm",null,2,2.5,5]
[43,"Rodo de plástico com duas borrachas – 60 cm",null,2,3.5,7]
[44,"Sabão em pedaço – 200 g - embalagem com 5 unidades",null,2,3,6]
[45,"Sabão em pó  - 1 k",null,7,2.99,20.93]
[46,"Sabonete Líquido -  embalagem com 5 litros -  teor cosmético, agentes hidratantes, nutrientes e emolientes, consistência semi-gel. Densidade a 20/4(g/cm3) = 1,01 a 1,05 pH 6,5 a 7,5 para limpeza de mãos, com aroma suave.",null,5,10.5,52.5]
[47,"Saco alvejado para limpeza de piso – un – 50x70 cm – cor branca",null,25,2,50]
[48,"Saco descartável p/ aspirador – A-20 e A-10",null,1,2.4,2.4]
[49,"Saco plástico p/ lixo – 100 L (amarelo) - fardo com 100 um",null,1,14,14]
[50,"Saco plástico p/ lixo – 100 L (azul) - fardo com 100 um",null,1,14,14]
[51,"Saco plástico p/ lixo – 100 L (preto) - fardo com 100 un",null,1,14,14]
[52,"Saco plástico p/ lixo – 100 L (vermelho) - fardo com 100 um",null,1,14,14]
[53,"Saco plástico p/ lixo – 60 L (amarelo) - fardo com 100 un",null,1,7.8,7.8]
[54,"Saco plástico p/ lixo – 60 L (azul) - fardo com 100 un",null,1,7.8,7.8]
[55,"Saco plástico p/ lixo – 60 L (preto) - fardo com 100 un",null,1,6.5,6.5]
[56,"Saco plástico p/ lixo – 60 L (vermelho) - fardo com 100 un",null,1,7.8,7.8]
[57,"Sapóleo líquido – 300 ml",null,6,1.1200000000000001,6.7200000000000006]
[58,"Vaselina líquida – 1 L",null,1,1.2,1.2]
[59,"Vassoura compact plus",null,1,5,5]
[60,"Vassoura de nylon macia",null,1,3.12,3.12]
[61,"Vassoura de palha",null,1,5,5]
[62,"Vassoura de pelo",null,1,5,5]
[63,"Vassoura sanitária (bola) c/ suporte",null,5,1.5,7.5]

{"sheet":"ANEXO III A - PROPOSTA","index":10,"n_rows":30,"n_cols":10,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,0,16,2],[13,3,13,5],[16,3,16,5],[1,0,1,6],[0,0,0,4],[0,5,0,6],[11,0,11,6],[13,0,15,2],[12,0,12,2]]}
["MUNICÍPIO DE APUCARANA",null,null,null,null,"ANEXO III A"]
["    ANEXO II -  PLANILHA QUANTIDADES/PREÇOS"]
[]
["OBRA: - ","SERVIÇOS DE COLETA E TRANSPORTE DE RESIDUOS SOLIDOS - (LIXO DOMESTICO)"]
[]
["ITEM","SERVIÇOS","UN","QUANT.","UNITÁRIO","PARCIAL","TOTAL"]
[]
["01.","SERVIÇOS DE COLETA E TRANSPORTE"]
[]
["01.1","SERVIÇOS MENSAL"]
["01.1.01","Serviços de coleta e transporte (estimado tonelada/ mês) (incluindo o fornecimento dos containers / e o recolhimento de pequenos animais mortos).","m²",2726.9968600000002,183.56800000000001,{"$f":"D11*E11","v":500589.35959648009}]
[]
[null,null,null,"SUBTOTAL - MENSAL",null,null,{"$f":"SUM(F10:F11)","v":500589.35959648009}]
["Obs. Adotamos a quantidade executada em dezembro/2020"]
[null,null,null,"PERIODO DE COLETA",null,"MÊSES",12]
[]
["TOTAL GERAL / PERIODO DE 12 MESES - R$ - ",null,null," ",null,null,{"$f":"G13*G15","v":6007072.3151577609},null,null," "]
[null,null,null,null,null,null,null,null,null," "]
[null,"OBSERVAÇÕES:",null,null,null,null,null,null,null," "]
[]
[null,"01 - Forma de Pagamento em medições mensais"]
[null,"02 - Prazo de execução dos serviços -12 (doze meses)."]
[null,"03 - Preço Base - \"FEVEREIRO/2021\""]
[]
[]
[null,"Apucarana, 23 de fevereiro de 2.021."]
[]
[]
[]
[null,"Secretaria Municipal de Serviços Públicos - SESP"]

{"sheet":"ANEXO III B - CRO","index":11,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[[14,7,14,9],[15,6,15,10],[0,25,0,27],[3,24,3,25],[3,26,3,27],[0,0,0,13],[0,21,0,23],[3,2,3,3],[3,18,3,19],[3,20,3,21],[3,22,3,23]]}
["MUNCIPIO DE APUCARANA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANEXO - III - B"]
["OBRA :- ",{"$f":"'ANEXO III A - PROPOSTA'!B4","v":"SERVIÇOS DE COLETA E TRANSPORTE DE RESIDUOS SOLIDOS - (LIXO DOMESTICO)"}]
[]
["CRONOGRAMA - FÍSICO FINANCEIRO",null,"GLOBAL",null,null,"MÊS 01",null,"MÊS 02",null,"MÊS 03",null,"MÊS 04",null,"MÊS 05",null,"MÊS 06",null,"MÊS 07","MÊS 08",null,"MÊS 09",null,"MÊS 10",null,"MÊS 11",null,"MÊS 12"]
["ITEM ","SERVIÇOS","ETAPA","%","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR","%","VALOR"]
["01.","SERVIÇOS DE COLETA TRANSPORTE RESIDUOS ",{"$f":"'ANEXO III A - PROPOSTA'!G17","v":6007072.3151577609},{"$f":"(C6/$C$10)*100","v":100}]
[null," - RECUROS LIVES",null,null,8.3330000000000002,{"$f":"E7*C6/100","v":500569.33602209622},{"$f":"E7","v":8.3330000000000002},{"$f":"(G7*C6/100)","v":500569.33602209622},{"$f":"E7","v":8.3330000000000002},{"$f":"(I7*C6)/100","v":500569.33602209622},{"$f":"E7","v":8.3330000000000002},{"$f":"(K7*C6)/100","v":500569.33602209622},{"$f":"E7","v":8.3330000000000002},{"$f":"(M7*C6)/100","v":500569.33602209622},{"$f":"M7","v":8.3330000000000002},{"$f":"(O7*C6)/100","v":500569.33602209622},{"$f":"O7","v":8.3330000000000002},{"$f":"(Q7*C6)/100","v":500569.33602209622},{"$f":"Q7","v":8.3330000000000002},{"$f":"(S7*C6)/100","v":500569.33602209622},8.3330000000000002,{"$f":"T7","v":500569.33602209622},{"$f":"S7","v":8.3330000000000002},{"$f":"(W7*C6)/100","v":500569.33602209622},{"$f":"W7","v":8.3330000000000002},{"$f":"(Y7*C6)/100","v":500569.33602209622},8.3369999999999997,{"$f":"(AA7*C6)/100","v":500809.61891470256}]
[]
[]
[null,"VALOR PARCIAL",{"$f":"SUM(C6:C8)","v":6007072.3151577609},{"$f":"SUM(D6:D8)","v":100},{"$f":"F10/C10*100","v":8.3330000000000002},{"$f":"SUM(F6:F8)","v":500569.33602209622},{"$f":"H10/C10*100","v":8.3330000000000002},{"$f":"SUM(H6:H8)","v":500569.33602209622},{"$f":"J10/C10*100","v":8.3330000000000002},{"$f":"SUM(J6:J8)","v":500569.33602209622},{"$f":"L10/C10*100","v":8.3330000000000002},{"$f":"SUM(L6:L8)","v":500569.33602209622},{"$f":"N10/C10*100","v":8.3330000000000002},{"$f":"SUM(N6:N8)","v":500569.33602209622},{"$f":"P10/C10*100","v":8.3330000000000002},{"$f":"SUM(P6:P8)","v":500569.33602209622},{"$f":"R10/C10*100","v":8.3330000000000002},{"$f":"SUM(R6:R8)","v":500569.33602209622},{"$f":"T10/C10*100","v":8.3330000000000002},{"$f":"SUM(T6:T8)","v":500569.33602209622},{"$f":"V10/C10*100","v":8.3330000000000002},{"$f":"SUM(V6:V8)","v":500569.33602209622},{"$f":"X10/C10*100","v":8.3330000000000002},{"$f":"SUM(X6:X8)","v":500569.33602209622},{"$f":"Y7","v":8.3330000000000002},{"$f":"SUM(Z6:Z8)","v":500569.33602209622},{"$f":"AA7","v":8.3369999999999997},{"$f":"SUM(AB6:AB8)","v":500809.61891470256}]
[null,"VALOR ACUMULADO",null,null,{"$f":"E10","v":8.3330000000000002},{"$f":"F10","v":500569.33602209622},{"$f":"G10+E11","v":16.666},{"$f":"H10+F11","v":1001138.6720441924},{"$f":"I10+G11","v":24.999000000000002},{"$f":"J10+H11","v":1501708.0080662887},{"$f":"K10+I11","v":33.332000000000001},{"$f":"L10+J11","v":2002277.3440883849},41.664999999999999,2502846.6801104811,49.997999999999998,3003416.0161325773,58.330999999999996,3503985.3521546735,66.664000000000001,4004554.6881767698,74.997,4505124.0241988655,83.33,5005693.3602209613,{"$f":"Y10+W11","v":91.662999999999997},{"$f":"Z10+X11","v":5506262.696243057},{"$f":"AA10+Y11","v":100},{"$f":"AB10+Z11","v":6007072.3151577599}]
[]
[]
[null,null,"Apucarana, 23 de fevereiro de 2.021"]
[]
[null,null,null,null,null,null,"Secretario Municipal de Serviços Públicos"]

{"sheet":"ANEXO III C - Comp Custos e BDI","index":12,"n_rows":239,"n_cols":9,"rows_kept":239,"cut":false,"hidden":false,"merged":[[189,0,189,5],[159,1,159,4],[228,3,228,5],[4,0,4,5],[116,4,130,4],[228,0,228,2],[239,0,239,2],[67,0,67,5],[56,0,56,5],[45,0,45,5],[36,0,36,5],[222,0,222,5],[102,0,102,5],[108,0,108,5],[114,0,114,5],[134,0,134,5],[160,0,160,4],[167,0,167,5],[176,0,176,5],[234,3,234,5],[235,3,235,5],[236,3,236,5],[0,4,0,5],[0,2,0,3],[1,0,1,2],[229,0,229,2],[26,0,26,5],[18,0,18,5],[76,0,76,5],[84,0,84,5],[93,0,93,5],[148,0,148,5],[203,0,203,5],[209,0,209,5],[216,0,216,5],[197,0,197,5],[3,0,3,5],[183,0,183,5]]}
[null,null,"MODELO ",null,"ANEXO III - C"]
["MUNICIPIO DE APUCARANA"]
[]
["COLETA DE RESÍDUOS SÓLIDOS URBANO"]
["PLANILHA DE COMPOSIÇÃO DE CUSTOS"]
[]
["SÍNTESE DOS CUSTOS - MENSAL","VALOR","% - TOTAL"]
[{"$f":"A17","v":"1. MÃO DE OBRA"},{"$f":"I132","v":239901.56304133331},{"$f":"B8/$B$12*100","v":47.923823953350606}]
[{"$f":"A134","v":"2. UNIFORMES E EPI´S"},{"$f":"I158","v":3841.3249999999998},{"$f":"B9/$B$12*100","v":0.76736049867206135}]
[{"$f":"A160","v":"3. EQUIPAMENTOS E DESPESAS GERAIS"},{"$f":"I226","v":141414.73202614379},28.24964804778498]
[{"$f":"A229","v":"4. BENEFÍCIOS E DESPESAS INDIRETAS"},{"$f":"(B8+B9+B10)*C239","v":115431.7387342229},23.059167500192356]
["TOTAL DE DESPESAS",{"$f":"SUM(B8:B11)","v":500589.3588017}]
["QUANTIDADE MENSAL ESTIMADA (TON)",2727]
["VALOR POR TONELADA - (DEZEMBRO/2020)",{"$f":"B12/B13","v":183.56778833945728}]
["VALOR MÁXIMO GLOBAL",{"$f":"B13*B14","v":500589.3588017},{"$f":"SUM(C8:C11)","v":100}]
[]
["1. MÃO DE OBRA"]
[]
["1.1 SUPERVISOR DIURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,2142.23,{"$f":"C21*D21","v":2142.23}]
["Soma",null,null,null,{"$f":"SUM(E21:E21)","v":2142.23}]
["Encargos Sociais","%",0.76729999999999998,{"$f":"E22","v":2142.23},{"$f":"D23*C23","v":1643.7330790000001}]
["Total por motorista",null,null,null,{"$f":"E22+E23","v":3785.9630790000001}]
["Total do Efetivo","homem",1,{"$f":"E24","v":3785.9630790000001},{"$f":"C25*D25","v":3785.9630790000001},{"$f":"E25","v":3785.9630790000001},null,{"$f":"F25","v":3785.9630790000001}]
[]
["1.2 SUPERVISOR NOTURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,{"$f":"D21","v":2142.23},{"$f":"D29","v":2142.23}]
["Adicional noturno - 4 horas por dia","adc. - 4h/dia",104,197.09,{"$f":"D30","v":197.09}]
["Adicional noturno pela redução da hora","30 mim/dia",14.86,24.64,{"$f":"D31","v":24.64}]
["Soma",null,null,null,{"$f":"SUM(E29:E31)","v":2363.96}]
["Encargos Sociais","%",{"$f":"C23","v":0.76729999999999998},{"$f":"E32","v":2363.96},{"$f":"D33*C33","v":1813.8665080000001}]
["Total por motorista",null,null,null,{"$f":"E32+E33+0.13","v":4177.9565080000002}]
["Total do Efetivo","homem",1,null,{"$f":"E34","v":4177.9565080000002},{"$f":"E35","v":4177.9565080000002},null,{"$f":"F35","v":4177.9565080000002}]
[]
["1.3 MOTORISTA DE CAMINHÃO DIURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,1963.43,{"$f":"C39*D39","v":1963.43}]
["Adicional de Insalubridade","%",0.4,1100,{"$f":"C40*D40","v":440}]
["Soma",null,null,null,{"$f":"SUM(E39:E40)","v":2403.4300000000003}]
["Encargos Sociais","%",{"$f":"C23","v":0.76729999999999998},{"$f":"E41","v":2403.4300000000003},{"$f":"D42*C42","v":1844.1518390000001}]
["Total por Motorista",null,null,null,{"$f":"E41+E42+0.1","v":4247.6818390000008}]
["Total do Efetivo","homem",5,null,{"$f":"E43*C44","v":21238.409195000004},{"$f":"E44","v":21238.409195000004},null,{"$f":"F44","v":21238.409195000004}]
[]
["1.4 MOTORISTA DE CAMINHÃO NOTURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,{"$f":"D39","v":1963.43},{"$f":"C48*D48","v":1963.43}]
["Adicional de Insalubridade","%",0.4,{"$f":"D40","v":1100},{"$f":"C49*D49","v":440}]
["Adicional noturno - 4 horas por dia","adc. - 4h/dia",104,227.64,{"$f":"D50","v":227.64}]
["Adicional noturno pela redução da hora","30 mim/dia",14.86,27.64,{"$f":"D51","v":27.64}]
["Soma",null,null,null,{"$f":"SUM(E48:E51)","v":2658.71}]
["Encargos Sociais","%",{"$f":"C42","v":0.76729999999999998},{"$f":"E52","v":2658.71},{"$f":"D53*C53","v":2040.0281829999999}]
["Total por motorista",null,null,null,{"$f":"E52+E53","v":4698.7381829999995}]
["Total do Efetivo","homem",5,{"$f":"E54","v":4698.7381829999995},{"$f":"C55*D55","v":23493.690914999999},{"$f":"E55","v":23493.690914999999},null,{"$f":"F55","v":23493.690914999999}]
[]
["1.5 COLETOR NOTURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,1395,{"$f":"C59*D59","v":1395}]
["Adicional de Insalubridade","%",0.4,1100,{"$f":"C60*D60","v":440}]
["Adicional noturno - 4 horas por dia","adc. - 4h/dia",104,168.82,{"$f":"D61","v":168.82}]
["Adicional noturno pela redução da hora","30 mim/dia",14.86,21.1,{"$f":"D62","v":21.1}]
["Soma",null,null,null,{"$f":"SUM(E59:E62)","v":2024.9199999999998}]
["Encargos Sociais","%",{"$f":"C42","v":0.76729999999999998},{"$f":"E63","v":2024.9199999999998},{"$f":"D64*C64","v":1553.7211159999999}]
["Total por Coletor",null,null,null,{"$f":"E63+E64","v":3578.6411159999998}]
["Total do Efetivo","homem",20,{"$f":"E65","v":3578.6411159999998},{"$f":"C66*D66","v":71572.822319999992},{"$f":"E66","v":71572.822319999992},null,{"$f":"F66","v":71572.822319999992}]
[]
["1.6 COLETOR DIURNO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,1395,{"$f":"C70*D70","v":1395}]
["Adicional de Insalubridade","%",0.4,1100,{"$f":"C71*D71","v":440}]
["Soma",null,null,null,{"$f":"SUM(E70:E71)","v":1835}]
["Encargos Sociais","%",{"$f":"C64","v":0.76729999999999998},{"$f":"E72","v":1835},{"$f":"D73*C73","v":1407.9955}]
["Total por Coletor",null,null,null,{"$f":"E72+E73","v":3242.9955}]
["Total do Efetivo","homem",20,{"$f":"E74","v":3242.9955},{"$f":"C75*D75","v":64859.91},{"$f":"E75","v":64859.91},null,{"$f":"F75","v":64859.91}]
[]
["1.7 Engenheiro 6 horas semanais"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,6600,{"$f":"C79*D79","v":6600}]
["Soma",null,null,null,{"$f":"SUM(E79:E79)","v":6600}]
["Encargos Sociais","%",{"$f":"C73","v":0.76729999999999998},{"$f":"E80","v":6600},{"$f":"D81*C81","v":5064.18}]
["Total por gerente",null,null,null,{"$f":"E80+E81","v":11664.18}]
["Total do Efetivo","homem",1,{"$f":"E82","v":11664.18},{"$f":"C83*D83","v":11664.18},{"$f":"E83","v":11664.18},null,{"$f":"F83","v":11664.18}]
[]
["1.8 GERENTE"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,2142.23,{"$f":"C87*D87","v":2142.23}]
["Adicional noturno",null,null,373.78,{"$f":"D88","v":373.78}]
["Soma",null,null,null,{"$f":"SUM(E87:E88)","v":2516.0100000000002}]
["Encargos Sociais","%",{"$f":"'ANEXO III C - Comp Custos e BDI'!C81","v":0.76729999999999998},{"$f":"E89","v":2516.0100000000002},{"$f":"D90*C90","v":1930.5344730000002}]
["Total por encarregado",null,null,null,{"$f":"E89+E90","v":4446.5444729999999}]
["Total do Efetivo","homem",1,{"$f":"E91","v":4446.5444729999999},{"$f":"C92*D92","v":4446.5444729999999},{"$f":"E92","v":4446.5444729999999},null,{"$f":"F92","v":4446.5444729999999}]
[]
["1.9 Auxiliar Administrativo"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Salário Normal","mês",1,1516.66,{"$f":"C96*D96","v":1516.66}]
["Adicional de Risco",null,1,30,{"$f":"C97*D97","v":30}]
["Soma",null,null,null,{"$f":"SUM(E96:E97)","v":1546.66}]
["Encargos Sociais","%",{"$f":"'ANEXO III C - Comp Custos e BDI'!C81","v":0.76729999999999998},{"$f":"E98","v":1546.66},{"$f":"D99*C99","v":1186.7522180000001}]
["Total por Auxiliar",null,null,null,{"$f":"E98+E99","v":2733.4122180000004}]
["Total do Efetivo","homem",1,{"$f":"E100","v":2733.4122180000004},{"$f":"C101*D101","v":2733.4122180000004},{"$f":"E101","v":2733.4122180000004},null,{"$f":"F101","v":2733.4122180000004}]
[]
["1.10 Vale Transporte"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["FUNCIONÁRIOS","vale",2808,3,{"$f":"C105*D105","v":8424}]
["Desconto 6% salario base","%",0.06,{"$f":"C35*E29+C55*E48+C75*E70+E39*C44+E59*C66+C25*E21+D87*C92+D96*C101","v":83377.649999999994},{"$f":"D106*C106","v":5002.6589999999997}]
[null,null,null,null,null,{"$f":"E105-E106","v":3421.3410000000003},null,{"$f":"F107","v":3421.3410000000003}]
[]
["1.11 AUXILIO ALIMENTAÇÃO"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["FUNCIONÁRIOS (R$ 450,00) - 20% PAT - Conforme CCT","vale",54,390,{"$f":"C111*D111","v":21060}]
["Seguro de vida/Fundo de formação profisisonal/Assist. Familiar","R$",54,106,{"$f":"D112*C112","v":5724}]
[null,null,null,null,null,{"$f":"(E111+E112)","v":26784},null,{"$f":"F113","v":26784}]
[]
["1.12 EXAMES ADMISSIONAIS, PERIODICOS E DEMISSIONAIS"]
["ADMISSÃO E PERIÓDICO (06 MESES)","Quant Ano","Preço","Total","Quantidade","Total "]
["AG. HBS",2,20,{"$f":"B117*C117","v":40},{"$f":"C44+C66+C55+C75+C25+C35+C83+C92+C101","v":55},{"$f":"D117*$E$117","v":2200}]
["ANTI HBS",2,20,{"$f":"B118*C118","v":40},null,2200]
["ANTI HCV",2,23,46,null,2530]
["AUDIOMETRIA",2,25,50,null,2750]
["ELETROCARDIOGRAMA",2,35,70,null,3850]
["GAMA GT",2,8,16,null,880]
["GLICOSE",2,4,8,null,440]
["TESTE DE VISÃO",2,9,18,null,990]
["Total",null,null,null,null,{"$f":"SUM(F117:F124)","v":15840},null," "]
[" DEMISSIONAL",null,null,null,null,null,null," "]
["AG. HBS",1,20,{"$f":"B127*C127","v":20},null,{"$f":"D127*$E$117","v":1100},null," "]
["ANTI HBS",1,20,{"$f":"B128*C128","v":20},null,{"$f":"D128*$E$117","v":1100}]
["ANTI HCV",1,23,23,null,{"$f":"D129*$E$117","v":1265}]
["AUDIOMETRIA",1,25,25,null,{"$f":"D130*$E$117","v":1375}]
["Total",null,null,{"$f":"SUM(D127:D130)","v":88},null,{"$f":"SUM(F127:F130)","v":4840}]
[null,null,null,null,"Total Mensal",{"$f":"(F125+F131)/12","v":1723.3333333333333},null,{"$f":"F132","v":1723.3333333333333},{"$f":"SUM(H19:H132)","v":239901.56304133331}]
[]
["2. UNIFORMES E EPI´S"]
["2.1. UNIFORMES E EPÍ'S PARA COLETORES"]
["Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
["Calça","unidade",4,55.9,{"$f":"D137/C137","v":13.975}]
["Camiseta manga longa","unidade",4,45.6,11.4]
["Boné c/ protetor de pescoço - sarja","unidade",6,35,5.833333333333333]
["Botina de segurança c/ palmilha aço","par",6,55.9,9.3166666666666664]
["Capa de chuva amarela","unidade",12,40.5,3.375]
["Colete refletivo","unidade",12,25.45,2.1208333333333331]
["Luva de proteção","par",1,13.5,13.5]
["Óculos de proteção","Unidade",3,15.5,5.166666666666667]
["Protetor solar FPS 30","frasco 120g",1,12.8,12.8]
["Total do Efetivo","homem",{"$f":"C75+C66","v":40},{"$f":"SUM(E137:E145)","v":77.487499999999997},{"$f":"C146*D146","v":3099.5}]
[null,null,null,null,null,{"$f":"E146","v":3099.5},null,{"$f":"F147","v":3099.5}]
[]
["2.2. UNIFORMES E EPÍ'S PARA ENCARREGADO E MOTORISTA E APOIO ADMINISTRATIVO"]
["Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
["Calça","unidade",4,{"$f":"D137","v":55.9},{"$f":"D151/C151","v":13.975}]
["Camiseta manga longa","unidade",4,{"$f":"D138","v":45.6},11.4]
["Calçado de Segurança","par",6,{"$f":"D140","v":55.9},9.3166666666666664]
["Capa de chuva amarela","unidade",12,{"$f":"D141","v":40.5},3.375]
["Colete refletivo","unidade",12,{"$f":"D142","v":25.45},2.1208333333333331]
["Protetor solar FPS 30","frasco 120g",1,{"$f":"D145","v":12.8},12.8]
["Total do Efetivo","homem",14,{"$f":"SUM(E151:E156)","v":52.987499999999997},{"$f":"C157*D157","v":741.82499999999993}]
[null,null,null,null,null,{"$f":"E157","v":741.82499999999993},null,{"$f":"F158","v":741.82499999999993},{"$f":"H158+H147","v":3841.3249999999998}]
[]
["3. EQUIPAMENTOS E DESPESAS GERAIS"]
["3.1. EQUIPAMENTOS"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal"]
["Caminhão Chassi  3 eixos - igual ou superior a 2019","unidade",6,230000,{"$f":"C163*D163","v":1380000}]
["Caçamba Compactadora - nova","unidade",6,130000,{"$f":"C164*D164","v":780000}]
["Veículo Utilitário = igual ou superior a 2019","unidade",2,55000,{"$f":"C165*D165","v":110000}]
["Conteiner Metalico 1,2 m³","Unidade",30,2100,{"$f":"C166*D166","v":63000}]
[]
["3.2. DEPRECIAÇÃO EQUIPAMENTOS"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[{"$f":"A163","v":"Caminhão Chassi  3 eixos - igual ou superior a 2019"},"unidade",{"$f":"C163","v":6},230000,{"$f":"C170*D170","v":1380000}]
[{"$f":"A164","v":"Caçamba Compactadora - nova"},"unidade",6,130000,{"$f":"C171*D171","v":780000}]
[{"$f":"A165","v":"Veículo Utilitário = igual ou superior a 2019"},"unidade",2,55000,{"$f":"C172*D172","v":110000}]
["Conteiner Metalico 1,2 m³","Unidade",30,2100,{"$f":"C173*D173","v":63000}]
["Depreciação (60 meses)","%",0.8,{"$f":"SUM(E163:E166)","v":2333000},{"$f":"D174*C174","v":1866400}]
["Depreciação mensal","mês",72,null,{"$f":"SUM(E174:E174)","v":1866400},{"$f":"E175/C175","v":25922.222222222223},null,{"$f":"F175","v":25922.222222222223}]
[]
["3.3. Remuneração do Capital  Investido"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Custo dos caminhões e caçamba","unidade",{"$f":"C170","v":6},{"$f":"SUM(D163+D164)","v":360000},{"$f":"C179*D179","v":2160000}]
["Veículo Utilitário","unidade",{"$f":"C172","v":2},{"$f":"D172","v":55000},{"$f":"C180*D180","v":110000}]
["Conteiner Metalico 1,2 m³","Unidade",{"$f":"C173","v":30},{"$f":"D173","v":2100},{"$f":"C181*D181","v":63000}]
["Remuneração mensal de capital","%",1.4999999999999999E-2,{"$f":"SUM(E179:E181)","v":2333000},{"$f":"C182*D182","v":34995},{"$f":"E182","v":34995},null,{"$f":"F182","v":34995}]
[]
["3.4. Impostos e Seguros"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["IPVA caminhões e utilitário","unidade",1,{"$f":"(E163*0.01)+(E165*0.035)","v":17650},{"$f":"C186*D186","v":17650}]
["Seguro obrigatório + licenciamento","unidade",1,{"$f":"(E163+E165)*0.003","v":4470},{"$f":"D187*C187","v":4470}]
["Impostos e Seguros Mensais","mês",12,{"$f":"E186+E187","v":22120},{"$f":"D188/C188","v":1843.3333333333333},{"$f":"E188","v":1843.3333333333333},null,{"$f":"F188","v":1843.3333333333333}]
[]
["3.5. Consumos"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Custo de óleo diesel / km rodado (caminhão)","km/l",1.7,4.0999999999999996,{"$f":"D192/C192","v":2.4117647058823528}]
["Custo mensal","km",15400,{"$f":"E192","v":2.4117647058823528},{"$f":"C193*D193","v":37141.176470588231}]
["Custo gasolina utilitário","km/l",8,4.9000000000000004,{"$f":"D194/C194","v":0.61250000000000004}]
["Custo mensal","km",4000,{"$f":"E194","v":0.61250000000000004},{"$f":"C195*D195","v":2450}]
[null,null,null,null,null,{"$f":"E193+E195","v":39591.176470588231},null,{"$f":"F196","v":39591.176470588231}]
[]
["3.6. Demais Itens de Consumo"]
["Discriminação","Unidade","quantidade","Preço unitário","Subtotal",""]
["Rastreamento","Unidade/mês",6,200,{"$f":"D200*C200","v":1200}," "]
["Lavagem veicular","Unidade/mês",29,150,{"$f":"D201*C201","v":4350}]
["Custo mensal","mês",null,null,{"$f":"E200+E201","v":5550},{"$f":"E202","v":5550},null,{"$f":"F202","v":5550}]
[]
["3.7. Manutenção"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Custo de aquisição equipamentos ","unidade",1,{"$f":"D182","v":2333000},{"$f":"D206*C206","v":2333000}]
["Coeficiente de manutenção","%",8.9999999999999993E-3,{"$f":"D206","v":2333000},{"$f":"D207*C207","v":20997}]
["Custo mensal com manutenção","mês",1,null,{"$f":"SUM(E207:E207)","v":20997},{"$f":"E207","v":20997},null,{"$f":"F208","v":20997}]
[]
["3.8. Pneu Caminhões"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Custo aquisição pneus","unidade",6,1650,{"$f":"C212*D212","v":9900}]
["Custo recapagem (2 recapagens por pneu)","unidade",12,650,{"$f":"C213*D213","v":7800}]
["Vida útil do conjunto + 2 recapagens","km",40000,"Total Kit R$",{"$f":"C214*D215","v":17600}]
["Rodagem mensal","km",15400,0.44,6776,{"$f":"E215","v":6776},null,{"$f":"F215","v":6776}]
[]
["3.9. Pneu Utilitário"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Custo aquisição pneus","unidade",4,380,{"$f":"C219*D219","v":1520}]
["Vida útil do conjunto + 2 recapagens","km",25000,"Total Kit R$",{"$f":"C220*D221","v":1500}]
["Rodagem mensal","km",4000,0.06,{"$f":"C221*D221","v":240},{"$f":"E221","v":240},null,{"$f":"F221","v":240}]
[]
["3.10 Aluguel de Pátio / Barracão/Serviços Eventuais"]
["Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
["Aluguel de pátio / Barração","Unidade",1,3500,{"$f":"C225*D225","v":3500}]
["Custo mensal com pátio / Barracão (energia, limpeza, lavagens, telefone.)","Unidade",1,2000,{"$f":"C226*D226","v":2000},{"$f":"E226+E225","v":5500},null,{"$f":"F226","v":5500},{"$f":"SUM(H162:H226)","v":141414.73202614379}]
[]
[null,null,null,null," "]
["4. BENEFÍCIOS E DESPESAS INDIRETAS",null,null," Apucarana, 23 de fevereiro de 2.021"]
["4.1. Composição do BDI - Benefícios e Despesas Indiretas"]
["Administração Central","AC",0.04]
["Seguros/Riscos/Garantias","SRG",2.5000000000000001E-3]
["Lucro","L",9.7500000000000003E-2]
["Despesas Financeiras","DF",2.5000000000000001E-3]
["Tributos - ISS","T",2.5000000000000001E-2]
["Tributos - PIS/COFINS",null,9.2499999999999999E-2]
["Fórmula para o cálculo do BDI:",null,null,"Secretaria Municipal de Serviços Públicos - SESP"]
["{[(1+AC+SRG) x (1+L) x (1+DF)] / (1-T)} -1"]
["Resultado do cálculo do BDI:",null,{"$f":"ROUND((((1+C231+C232)*(1+C233)*(1+C234))/(1-(C235+C236))-1),4)","v":0.29970000000000002}]

{"sheet":"ANEXO III D Encargos","index":13,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,0,2,3],[4,0,5,3],[6,0,6,3],[50,0,50,3],[0,0,0,2]]}
["MODELO DE PREENCHIMENTO DE PLANILHA DE ENCARGOS SOCIAIS",null,null,"ANEXO III - D"]
[]
[" MEMÓRIA DE CÁLCULO ENCARGOS SOCIAIS"]
[]
["MEMÓRIA DE CÁLCULO"]
[]
["ENCARGOS SOCIAIS INCIDENTES SOBRE A REMUNERAÇÃO"]
["GRUPO A",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO"]
["A.01 INSS"]
["A.02 FGTS"]
["A.03 SESI/SESC"]
["A.04 SENAI/SENAC"]
["A.05 INCRA"]
["A.06 SEBRAE"]
["A.07 Salário Educação"]
["A.08 Riscos Ambientais do Trabalho – RAT x FAP"]
["TOTAL - GRUPO A",{"$f":"SUM(B9:B16)","v":0}]
[]
["GRUPO B",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO",null,null,{"$f":"1270/220","v":5.7727272727272725}]
["B.01 13º Salário",null,null,null,null,null,{"$f":"G19*0.2","v":1.1545454545454545}]
["B.02 Férias (Incluindo 1/3 constitucional)"]
["B.03 Aviso Prévio Trabalhado¹"]
["B.04 Auxílio Doença²",null,null,null,{"$f":"12/30/12*100","v":3.3333333333333335}]
["B.05 Acidente de Trabalho³",null,null,null,{"$f":"15/30/12*0.5*100","v":2.083333333333333}]
["B: Substituto na cobertura de Ausências Legais"]
["B: Afastamento Maternidade"]
["B: Licença Paterindade"]
["TOTAL - GRUPO B",{"$f":"SUM(B20:B27)","v":0}]
[]
[]
[]
[]
["GRUPO C",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO"]
["C.01 Aviso Prévio Indenizado ¹"]
["C.02 Indenização Adicional ²"]
["C.03 Indenização (rescisão sem justa causa – multa de 40% do FGTS) ³"]
["Multa do FGTS sobre o Aviso Previo Trabalhado "]
["TOTAL - GRUPO C",{"$f":"SUM(B34:B37)","v":0}]
["¹ Estimativa de que 5% (cinco por cento) dos empregados serão substituídos durante um ano."]
["² Estimativa de que 2% (dois por cento) dos empregados serão demitidos em situação de recebimento de indenização adicional."]
["³ Multa de 40% do FGTS em relação aos trabalhadores demitidos."]
[]
["GRUPO D",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO"]
["D.01 Incidência dos encargos do grupo A sobre o grupo B"]
["TOTAL - GRUPO D",{"$f":"SUM(B44:B44)","v":0}]
[]
["GRUPO E",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO"]
["E.01 Incidência do FGTS exclusivamente sobre o aviso prévio indenizado."]
["E.02 Incidência do FGTS exclusivamente sobre o período médio de afastamento superior a 15 dias motivado por acidente do trabalho. ¹"]
["TOTAL - GRUPO E",{"$f":"SUM(B48:B49)","v":0}]
["¹ Estimativa de que 8% (oito por cento) dos empregados sofrem acidentes durante o ano, com ausência média de 30 dias durante o ano. O percentual do FGTS (8%) será aplicado somente sobre os 15 dias restantes do afastamento, porque os 15 primeiros dias já foram calculados no item B.05."]
[]
["GRUPO F",null,"MEMÓRIA DE CÁLCULO","FUNDAMENTO"]
["F.01 Incidência dos encargos do Grupo A sobre os valores constantes da base de cálculo referente ao salário maternidade"]
["TOTAL - GRUPO F",{"$f":"SUM(B54:B54)","v":0}]
[]
["TOTAL - ENCARGOS SOCIAIS (R$)",{"$f":"B17+B28+B38+B45+B50+B55","v":0}]

{"sheet":"ANEXO III E Descricao","index":14,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[31,2,31,3],[30,2,30,3],[12,1,12,3],[13,2,13,3],[25,2,25,3],[28,2,28,3],[29,2,29,3],[9,0,9,3],[11,1,11,3],[10,2,10,3],[10,0,31,0],[22,2,22,3],[26,2,26,3],[20,2,20,3],[18,2,18,3],[19,2,19,3],[21,2,21,3],[23,2,23,3],[24,2,24,3],[15,2,15,3],[14,2,14,3],[16,2,16,3],[17,2,17,3],[0,0,0,3],[3,2,3,3],[4,2,4,3],[6,2,6,3],[7,2,7,3],[1,0,8,0],[1,2,2,3],[1,1,2,1],[5,2,5,3],[8,1,8,3]]}
["QUANTIDADE DE EQUIPAMENTOS E PESSOAL"]
[1,"EQUIPAMENTOS","QUANTIDADE"]
[]
[null,"Chassi Coletor - Ano de Fabricação igual ou superior ao ano de 2019.",6]
[null,"Caçamba \"compactadores hidraulicos\" - Este equipamento deverá ser novo",6]
[]
[null,"Utilitário p/Fiscalização -Ano de Fabricação 2019 ou superior",2]
[null,"Container metálico -  1,5 mil/litros",30]
[]
[]
[2,"DESCRIÇÃO","ANEXO III -E"]
[null,"MÃO DE OBRA - (RELAÇÃO DE PESSOAL - MINIMO)"]
[]
[null,"MÃO DE OBRA","QUANTIDADE"]
[]
[null,"MOTORISTAS"]
[null," - Diurno",5]
[null," - Noturno",5]
[]
[null,"COLETORES"]
[null," - Diurno",20]
[null," - Noturno",20,null,null," "]
[]
[null,"SUPERVISORES"]
[null," - Diurno",1]
[null," - Noturno",1,null,null," "]
[]
[null,"OUTROS"]
[null," - Gerente",1]
[null," - Aux. Escritório",1]
[null," - Engenheiro",1]

{"sheet":"OPERAÇÃO DO ATERRO","index":15,"n_rows":254,"n_cols":9,"rows_kept":254,"cut":false,"hidden":true,"merged":[[253,1,253,3],[83,1,83,6],[74,1,74,6],[65,1,65,6],[56,1,56,6],[104,1,104,6],[98,1,98,6],[92,1,92,6],[219,6,220,6],[224,6,233,6],[237,6,238,6],[106,5,120,5],[243,1,243,3],[242,1,242,3],[1,1,1,6],[2,1,2,6],[190,6,194,6],[200,6,201,6],[211,6,214,6],[47,1,47,6],[38,1,38,6],[28,1,28,6],[16,1,16,6]]}
[]
[null,"OPERAÇÃO DO ATERRO"]
[null,"PLANILHA DE COMPOSIÇÃO DE CUSTOS"]
[]
[null,"SÍNTESE DOS CUSTOS - MENSAL","VALOR"]
[null,{"$f":"B15","v":"1. MÃO DE OBRA"},{"$f":"ROUND((G27+G46+G37+G55+G73+G82+G97+G103+G122+G64+G91),2)","v":{"$error":"#REF!"}}]
[null,{"$f":"B124","v":"2. UNIFORMES E EPI´S"},{"$f":"ROUND(G134+G145+G156+G167,2)","v":639.76}]
[null,"3. EQUIPAMENTOS E DESPESAS GERAIS",{"$f":"ROUND((G187+G197+G203+G208+G216+G222+G235+G241),2)","v":{"$error":"#REF!"}}]
[null,{"$f":"B243","v":"4. BENEFÍCIOS E DESPESAS INDIRETAS"},{"$f":"ROUND(SUM(C6:C8)*D251,2)","v":{"$error":"#REF!"}},{"$f":"SUM(C6:C8)","v":{"$error":"#REF!"}}]
[null,"TOTAL DE DESPESAS",{"$f":"SUM(C6:C9)","v":{"$error":"#REF!"}}]
[null,"VALOR POR TONELADA",{"$f":"ROUND(C10/C12,2)","v":{"$error":"#REF!"}}]
[null,"QUANTIDADE ESTIMADA MENSAL (TON)",2400]
[null,"VALOR MÁXIMO GLOBAL",{"$f":"C10*12","v":{"$error":"#REF!"}}]
[]
[null,"1. MÃO DE OBRA"]
[]
[null,"1.1. VIGIA NOTURNO"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1481.66,{"$f":"D19*E19","v":1481.66}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D20*E20","v":418}]
[null,"Adicional risco",null,null,27.13,{"$f":"E21","v":27.13}]
[null,"Adicional noturno - 4 horas por dia","adc. - 4h/dia",{"$f":"4*25.3","v":101.2},{"$f":"(E19+F20)/220*20%*D22","v":174.76872000000003},{"$f":"E22","v":174.76872000000003},null,{"$f":"(E19+F20)/220*D22*0.2","v":174.76872000000003}]
[null,"Adicional noturno pela redução da hora","30 mim/dia",{"$f":"0.5*25.3","v":12.65},{"$f":"(E19+F20)/220*20%*D23","v":21.846090000000004},{"$f":"E23","v":21.846090000000004},null,{"$f":"(E19+F20)/220*1.5*(D22/7)","v":187.25220000000002}]
[null,"Soma",null,null,null,{"$f":"SUM(F19:F23)","v":2123.40481}]
[null,"Encargos Sociais","%",{"$f":"'ANEXO III D Encargos'!B57","v":0},{"$f":"F24","v":2123.40481},{"$f":"E25*D25","v":0}]
[null,"Total por Vigia",null,null,null,{"$f":"F24+F25","v":2123.40481}]
[null,"Total do Efetivo","homem",{"$f":"2+2/12","v":2.1666666666666665},{"$f":"F26","v":2123.40481},{"$f":"D27*E27","v":4600.7104216666667},{"$f":"F27","v":4600.7104216666667},{"$f":"($E$95*52)-(F19*$D$96)","v":{"$error":"#REF!"}},{"$f":"H27*D27","v":{"$error":"#REF!"}}]
[]
[null,"1.2 VIGIA DIURNO"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1481.66,{"$f":"D31*E31","v":1481.66}]
[null,"Adicional risco",null,1,27.13,{"$f":"D32*E32","v":27.13}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D33*E33","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F31:F33)","v":1926.7900000000002}]
[null,"Encargos Sociais","%",{"$f":"D25","v":0},{"$f":"F34","v":1926.7900000000002},{"$f":"E35*D35","v":0}]
[null,"Total por Vigia",null,null,null,{"$f":"F34+F35","v":1926.7900000000002}]
[null,"Total do Efetivo","homem",{"$f":"2+2/12","v":2.1666666666666665},{"$f":"F36","v":1926.7900000000002},{"$f":"D37*E37","v":4174.711666666667},{"$f":"F37","v":4174.711666666667},{"$f":"($E$95*52)-(F31*$D$96)","v":{"$error":"#REF!"}},{"$f":"H37*D37","v":{"$error":"#REF!"}}]
[]
[null,"1.3 CONTROLADOR DE ACESSO E TRÁFEGO"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1506.65,{"$f":"D41*E41","v":1506.65}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D42*E42","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F41:F42)","v":1924.65}]
[null,"Encargos Sociais","%",{"$f":"D35","v":0},{"$f":"F43","v":1924.65},{"$f":"E44*D44","v":0}]
[null,"Total por Controlador",null,null,null,{"$f":"F43+F44","v":1924.65}]
[null,"Total do Efetivo","homem",{"$f":"1+1/12","v":1.0833333333333333},{"$f":"F45","v":1924.65},{"$f":"D46*E46","v":2085.0374999999999},{"$f":"F46","v":2085.0374999999999},{"$f":"($E$95*52)-(F41*$D$96)","v":{"$error":"#REF!"}},{"$f":"H46*D46","v":{"$error":"#REF!"}}]
[]
[null,"1.4 OPERADOR DE ROÇADEIRA"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1653.17,{"$f":"D50*E50","v":1653.17}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D51*E51","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F50:F51)","v":2071.17}]
[null,"Encargos Sociais","%",{"$f":"D25","v":0},{"$f":"F52","v":2071.17},{"$f":"E53*D53","v":0}]
[null,"Total por Auxiliar",null,null,null,{"$f":"F52+F53","v":2071.17}]
[null,"Total do Efetivo","homem",{"$f":"1+1/12","v":1.0833333333333333},{"$f":"F54","v":2071.17},{"$f":"D55*E55","v":2243.7674999999999},{"$f":"F55","v":2243.7674999999999},{"$f":"($E$95*52)-(F50*$D$96)","v":{"$error":"#REF!"}},{"$f":"H55*D55","v":{"$error":"#REF!"}}]
[]
[null,"1.5 AUXILIAR DE SERVIÇOS GERAIS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1270,{"$f":"D59*E59","v":1270}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D60*E60","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F59:F60)","v":1688}]
[null,"Encargos Sociais","%",{"$f":"D53","v":0},{"$f":"F61","v":1688},{"$f":"E62*D62","v":0}]
[null,"Total por Auxiliar",null,null,null,{"$f":"F61+F62","v":1688}]
[null,"Total do Efetivo","homem",{"$f":"1+1/12","v":1.0833333333333333},{"$f":"F63","v":1688},{"$f":"D64*E64","v":1828.6666666666665},{"$f":"F64","v":1828.6666666666665},{"$f":"($E$95*52)-(F59*$D$96)","v":{"$error":"#REF!"}},{"$f":"H64*D64","v":{"$error":"#REF!"}}]
[]
[null,"1.6 OPERADOR"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal",null,1,1789.18,{"$f":"D68*E68","v":1789.18}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D69*E69","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F68:F69)","v":2207.1800000000003}]
[null,"Encargos Sociais","%",{"$f":"D25","v":0},{"$f":"F70","v":2207.1800000000003},{"$f":"E71*D71","v":0}]
[null,"Total por operador",null,null,null,{"$f":"F70+F71","v":2207.1800000000003}]
[null,"Total do Efetivo","homem",{"$f":"3+3/12","v":3.25},{"$f":"F72","v":2207.1800000000003},{"$f":"D73*E73","v":7173.3350000000009},{"$f":"F73","v":7173.3350000000009},{"$f":"($E$95*52)-(F68*$D$96)","v":{"$error":"#REF!"}},{"$f":"H73*D73","v":{"$error":"#REF!"}}]
[]
[null,"1.7 MOTORISTA DE CAMINHÃO 3 EIXOS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal","mês",1,1912,{"$f":"D77*E77","v":1912}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D78*E78","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F77:F78)","v":2330}]
[null,"Encargos Sociais","%",{"$f":"D53","v":0},{"$f":"F79","v":2330},{"$f":"E80*D80","v":0}]
[null,"Total por Motorista",null,null,null,{"$f":"F79+F80","v":2330}]
[null,"Total do Efetivo","homem",1.08,{"$f":"F81","v":2330},{"$f":"D82*E82","v":2516.4},{"$f":"F82","v":2516.4},{"$f":"($E$95*52)-(F77*$D$96)","v":{"$error":"#REF!"}},{"$f":"H82*D82","v":{"$error":"#REF!"}}]
[]
[null,"1.8 MOTORISTA DE CAMINHÃO 2 EIXOS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Salário Normal","mês",1,1912,{"$f":"D86*E86","v":1912}]
[null,"Adicional de Insalubridade","%",0.4,1045,{"$f":"D87*E87","v":418}]
[null,"Soma",null,null,null,{"$f":"SUM(F86:F87)","v":2330}]
[null,"Encargos Sociais","%",{"$f":"D71","v":0},{"$f":"F88","v":2330},{"$f":"E89*D89","v":0}]
[null,"Total por Motorista",null,null,null,{"$f":"F88+F89","v":2330}]
[null,"Total do Efetivo","homem",1.08,{"$f":"F90","v":2330},{"$f":"D91*E91","v":2516.4},{"$f":"F91","v":2516.4},{"$f":"($E$95*52)-(F86*$D$96)","v":{"$error":"#REF!"}},{"$f":"H91*D91","v":{"$error":"#REF!"}}]
[]
[null,"1.9 Vale Transporte",null,null,null,null,null,null,{"$f":"SUM(I27,I37,I46,I55,I64,I73,I82,I91)","v":{"$error":"#REF!"}}]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"FUNCIONÁRIOS","vale",{"$f":"(D27+D37+D46+D55+D73+D82+D91+D64)*#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D95*E95","v":{"$error":"#REF!"}}]
[null,"Desconto 6% salario base","%",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F19*D27+F31*D37+F41*D46+F50*D55+F59*D64+ F68*D73+F77*D82+F86*D91","v":21164.25333333333},{"$f":"E96*D96","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,{"$f":"F95-F96","v":{"$error":"#REF!"}}]
[]
[null,"1.10 AUXILIO ALIMENTAÇÃO"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"FUNCIONÁRIOS (R$ 414,00) - 20% PAT - Conforme CCT","vale",{"$f":"D27+D37+D46+D55+D73+D82+D91+D64","v":12.993333333333334},331.2,{"$f":"D101*E101","v":4303.3919999999998}]
[null,"Seguro de vida/Fundo de formação profissional/Assist. Familiar","R$",{"$f":"D27+D37+D46+D55+D73+D82+D91+D64","v":12.993333333333334},{"$f":"62.5+20.5+20.5","v":103.5},{"$f":"E102*D102","v":1344.8100000000002}]
[null,null,null,null,null,null,{"$f":"F101+F102","v":5648.2020000000002}]
[]
[null,"1.8 EXAMES ADMISSIONAIS, PERIODICOS E DEMISSIONAIS"]
[null,"ADMISSÃO E PERIÓDICO (06 MESES)","Quant Ano","Preço","Total","Quantidade","Total "]
[null,"AG. HBS",2,18.059999999999999,{"$f":"C107*D107","v":36.119999999999997},{"$f":"D73+D55+D46+D27+D37+D82+D91+D64","v":12.993333333333332},{"$f":"E107*$F$107","v":469.31919999999991}]
[null,"ANTI HBS",2,18.059999999999999,36.119999999999997,null,469.31919999999991]
[null,"ANTI HCV",2,22.8,45.6,null,592.49599999999998]
[null,"AUDIOMETRIA",2,25,50,null,649.66666666666663]
[null,"ELETROCARDIOGRAMA",2,35,70,null,909.5333333333333]
[null,"GAMA GT",2,7.5,15,null,194.89999999999998]
[null,"GLICOSE",2,3.5,7,null,90.953333333333319]
[null,"TESTE DE VISÃO",2,8.5,17,null,220.88666666666666]
[null,"Total",null,null,{"$f":"SUM(E107:E114)","v":276.84000000000003},null,{"$f":"SUM(G107:G114)","v":3597.0744}]
[null," DEMISSIONAL"]
[null,"AG. HBS",1,{"$f":"D107","v":18.059999999999999},{"$f":"C117*D117","v":18.059999999999999},null,{"$f":"E117*$F$107","v":234.65959999999995}]
[null,"ANTI HBS",1,{"$f":"D108","v":18.059999999999999},{"$f":"C118*D118","v":18.059999999999999},null,{"$f":"E118*$F$107","v":234.65959999999995}]
[null,"ANTI HCV",1,{"$f":"D109","v":22.8},{"$f":"C119*D119","v":22.8},null,{"$f":"E119*$F$107","v":296.24799999999999}]
[null,"AUDIOMETRIA",1,{"$f":"D110","v":25},{"$f":"C120*D120","v":25},null,{"$f":"E120*$F$107","v":324.83333333333331}]
[null,"Total",null,null,{"$f":"SUM(E117:E120)","v":83.92},null,{"$f":"SUM(G117:G120)","v":1090.4005333333332}]
[null,null,null,null,null,"Total Mensal",{"$f":"(G115+G121)/12","v":390.62291111111108}]
[]
[null,"2. UNIFORMES E EPI´S"]
[null,"2.1. UNIFORMES E EPÍ'S PARA VIGIAS"]
[null,"Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
[null,"Calça","unidade",4,55.9,{"$f":"E127/D127","v":13.975}]
[null,"Camiseta manga longa","unidade",4,45.6,11.4]
[null,"Boné c/ protetor de pescoço - sarja","unidade",6,35,5.833333333333333]
[null,"Botina de segurança c/ palmilha aço","par",6,55.9,9.3166666666666664]
[null,"Capa de chuva amarela","unidade",12,40.5,3.375]
[null,"Colete refletivo","unidade",12,25.45,2.1208333333333331]
[null,"Total do Efetivo","homem",{"$f":"D27+D37","v":4.333333333333333},{"$f":"SUM(F127:F132)","v":46.020833333333329},{"$f":"D133*E133","v":199.42361111111109}]
[null,null,null,null,null,null,{"$f":"F133","v":199.42361111111109}]
[]
[null,"2.2. UNIFORMES E EPÍ'S PARA OPERADOR/ AUXILIAR DE SERVIÇO GERAIS"]
[null,"Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
[null,"Calça","unidade",4,{"$f":"E127","v":55.9},{"$f":"E138/D138","v":13.975}]
[null,"Camiseta manga longa","unidade",4,{"$f":"E128","v":45.6},11.4]
[null,"Calçado de Segurança","par",6,{"$f":"E130","v":55.9},9.3166666666666664]
[null,"Capa de chuva amarela","unidade",12,{"$f":"E131","v":40.5},3.375]
[null,"Colete refletivo","unidade",12,{"$f":"E132","v":25.45},2.1208333333333331]
[null,"Protetor solar FPS 30","frasco 120g",1,12.8,12.8]
[null,"Total do Efetivo","homem",{"$f":"D73+D64+D55","v":5.4166666666666661},{"$f":"SUM(F138:F143)","v":52.987499999999997},{"$f":"D144*E144","v":287.01562499999994}]
[null,null,null,null,null,null,{"$f":"F144","v":287.01562499999994}]
[]
[null,"2.3. UNIFORMES E EPÍ'S PARA MOTORISTA"]
[null,"Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
[null,"Calça","unidade",4,{"$f":"E139","v":45.6},{"$f":"E149/D149","v":11.4}]
[null,"Camiseta manga longa","unidade",4,{"$f":"E140","v":55.9},13.975]
[null,"Calçado de Segurança","par",6,{"$f":"E142","v":25.45},4.2416666666666663]
[null,"Capa de chuva amarela","unidade",12,{"$f":"E143","v":12.8},1.0666666666666667]
[null,"Colete refletivo","unidade",12,{"$f":"E144","v":52.987499999999997},4.4156249999999995]
[null,"Protetor solar FPS 30","frasco 120g",1,12.8,12.8]
[null,"Total do Efetivo","homem",{"$f":"D82+D91","v":2.16},{"$f":"SUM(F149:F154)","v":47.89895833333334},{"$f":"D155*E155","v":103.46175000000002}]
[null,null,null,null,null,null,{"$f":"F155","v":103.46175000000002}]
[]
[null,"2.4. UNIFORMES E EPÍ'S PARA CONTROLADOR DE ACESSO E TRÁFEGO E SUPERVISOR"]
[null,"Discriminação","Unidade","Durabilidade (meses)","Preço unitário","Subtotal",""]
[null,"Calça","unidade",4,55.9,{"$f":"E160/D160","v":13.975}]
[null,"Camiseta manga longa","unidade",4,45.6,11.4]
[null,"Boné c/ protetor de pescoço - sarja","unidade",6,35,5.833333333333333]
[null,"Botina de segurança c/ palmilha aço","par",6,55.9,9.3166666666666664]
[null,"Capa de chuva amarela","unidade",12,40.5,3.375]
[null,"Colete refletivo","unidade",12,25.45,2.1208333333333331]
[null,"Total do Efetivo","homem",{"$f":"D46","v":1.0833333333333333},{"$f":"SUM(F160:F165)","v":46.020833333333329},{"$f":"D166*E166","v":49.855902777777771}]
[null,null,null,null,null,null,{"$f":"F166","v":49.855902777777771}]
[null,"3. EQUIPAMENTOS E DESPESAS GERAIS"]
[]
[null,"3.1. EQUIPAMENTOS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal"]
[null,"trator esteira","unidade",1,472000,{"$f":"D172*E172","v":472000}]
[null,"escavadeira hidráulica","unidade",1,380000,{"$f":"D173*E173","v":380000}]
[null,"Caminhão basculante 6x4","unidade",1,140000,{"$f":"D174*E174","v":140000}]
[null,"Caminhão Basculante toco","unidade",1,120000,{"$f":"D175*E175","v":120000}]
[null,"pá carregadeira","Unidade",1,265000,{"$f":"D176*E176","v":265000}]
[]
[null,"3.2. DEPRECIAÇÃO EQUIPAMENTOS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,{"$f":"B172","v":"trator esteira"},"unidade",{"$f":"D172","v":1},{"$f":"E172","v":472000},{"$f":"D180*E180","v":472000}]
[null,{"$f":"B173","v":"escavadeira hidráulica"},"unidade",{"$f":"D173","v":1},{"$f":"E173","v":380000},{"$f":"D181*E181","v":380000}]
[null,"Caminhão basculante 6x4","unidade",1,{"$f":"E174","v":140000},{"$f":"D182*E182","v":140000}]
[null,"Caminhão Basculante toco","unidade",1,{"$f":"E175","v":120000},{"$f":"D183*E183","v":120000}]
[null,{"$f":"B176","v":"pá carregadeira"},"unidade",1,{"$f":"E176","v":265000},{"$f":"D184*E184","v":265000}]
[]
[null,"Depreciação (60 meses)","%",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(F180+F181+F184+E185+F183+F182)","v":1377000},{"$f":"E186*D186","v":{"$error":"#REF!"}}]
[null,"Depreciação mensal","mês",{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"SUM(F186:F186)","v":{"$error":"#REF!"}},{"$f":"F187/D187","v":{"$error":"#REF!"}}]
[]
[null,"3.3 Remuneração do Capital  Investido"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"trator esteira","unidade",1,{"$f":"E180","v":472000},{"$f":"D191*E191","v":472000}]
[null,"escavadeira hidráulica","unidade",{"$f":"D183","v":1},{"$f":"E181","v":380000},{"$f":"D192*E192","v":380000}]
[null,"Caminhão basculante 6x4","unidade",1,{"$f":"E182","v":140000},{"$f":"D193*E193","v":140000}]
[null,"Caminhão Basculante toco","unidade",1,{"$f":"E183","v":120000},{"$f":"D194*E194","v":120000}]
[null,"pá carregadeira",null,1,{"$f":"E176","v":265000},{"$f":"D195*E195","v":265000}]
[]
[null,"Remuneração mensal de capital","%",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(F191:F196)","v":1377000},{"$f":"D197*E197","v":{"$error":"#REF!"}},{"$f":"F197","v":{"$error":"#REF!"}}]
[]
[null,"3.4 Impostos e Seguros"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"IPVA caminhões","unidade",1,{"$f":"(F174+F175)*0.01","v":2600},{"$f":"D201*E201","v":2600}]
[null,"Seguro obrigatório + licenciamento","unidade",1,{"$f":"SUM(F174,F175)*0.003","v":780},{"$f":"E202*D202","v":780}]
[null,"Impostos e Seguros Mensais","mês",12,{"$f":"F201+F202","v":3380},{"$f":"E203/D203","v":281.66666666666669},{"$f":"F203","v":281.66666666666669}]
[]
[null,"3.5 Consumos"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Custo de óleo diesel","litros",5600,3.65,{"$f":"E207*D207","v":20440}]
[null,null,null,null,null,null,{"$f":"F207","v":20440}]
[]
[null,"3.6 Demais Itens e insumos da composição do aterro"]
[null,"Discriminação","Unidade","quantidade","Preço unitário","Subtotal",""]
[null,"Insumos operação (incluindo roçagem, manutenção do sistema de drenos de chorume e de águas pluviais)","Unidade/mês",1,4591.8999999999996,{"$f":"D212*E212","v":4591.8999999999996}]
[null,"Manutenção e aferição da balança rodoviária","Unidade/mês",1,500,{"$f":"D213*E213","v":500}]
[null,"Auto monitoramento","Unidade/mês",1,500,{"$f":"D214*E214","v":500}]
[null,"Sistema de recirculação","Unidade/mês",1,1500,{"$f":"D215*E215","v":1500}]
[null,"Custo mensal","mês",null,null,{"$f":"SUM(F212:F215)","v":7091.9},{"$f":"F216","v":7091.9}]
[]
[null,"3.7 Manutenção"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Custo de aquisição equipamentos","unidade",1,{"$f":"SUM(F180:F185)","v":1377000},{"$f":"E220*D220","v":1377000}]
[null,"Coeficiente de manutenção","%",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"F220","v":1377000},{"$f":"E221*D221","v":{"$error":"#REF!"}}]
[null,"Custo mensal com manutenção","mês",1,null,{"$f":"SUM(F221:F221)","v":{"$error":"#REF!"}},{"$f":"F222","v":{"$error":"#REF!"}}]
[]
[null,"3.8 Pneus Caminhões e Pá carregadeira"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Custo aquisição pneus Caminhões","unidade",6,1650,{"$f":"D226*E226","v":9900}]
[null,"Custo recapagem (2 recapagens por pneu)","unidade",12,650,{"$f":"D227*E227","v":7800}]
[null,"Vida útil do conjunto + 2 recapagens","km",20000,"Total kit (R$)",{"$f":"F226+F227","v":17700}]
[null,"Rodagem mensal","km",2500,{"$f":"F228/D228","v":0.88500000000000001},{"$f":"D229*E229","v":2212.5}]
[null,"Custo aquisição pneus - Pá carregadeira","unidade",4,2850,{"$f":"D230*E230","v":11400}]
[null,"Custo recapagem (2 recapagens por pneu)","unidade",8,1150,{"$f":"D231*E231","v":9200}]
[null,"Vida útil do conjunto + 2 recapagens","Horas",2400," Total kit (R$) ",{"$f":"SUM(F230:F231)","v":20600}]
[null,"Rodagem mensal","Horas",90,{"$f":"F232/D232","v":8.5833333333333339},{"$f":"D233*E233","v":772.5}]
[null,"Custo mensal com pneus Pá Carregadeira","mês",1,null,{"$f":"F233*D234","v":772.5}]
[null,"Custo Total mensal com pneus ","mês",1,null,{"$f":"F234+F229","v":2985},{"$f":"F235","v":2985}]
[]
[null,"3.9. Despesas Administrativas - INDIRETOS"]
[null,"Discriminação","Unidade","Quantidade","Preço unitário","Subtotal",""]
[null,"Utilização estrutura administrativa","Percentual",0.7,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"D239*E239","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"F239+F241+F240","v":{"$error":"#REF!"}}]
[]
[null,"4. BENEFÍCIOS E DESPESAS INDIRETAS"]
[null,"4.1. Composição do BDI - Benefícios e Despesas Indiretas"]
[null,"Administração Central","AC",0.01]
[null,"Seguros/Riscos/Garantias","SRG",2.5000000000000001E-3]
[null,"Lucro","L",0.01]
[null,"Despesas Financeiras","DF",2.5000000000000001E-3]
[null,"Tributos - ISS","T",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Tributos - PIS/COFINS",null,9.2499999999999999E-2]
[null,"Fórmula para o cálculo do BDI:",null,{"$f":"(((1+D245+D246)*(1+D247)*(1+D248))/(1-(D249+D250)))-1","v":{"$error":"#REF!"}}]
[null,"{[(1+AC+SRG) x (1+L) x (1+DF)] / (1-T)} -1"]
[null,"Resultado do cálculo do BDI:",null,{"$f":"ROUND((((1+D245+D246)*(1+D247)*(1+D248))/(1-(D249+D250))-1),4)","v":{"$error":"#REF!"}}]
[null,"O cálculo do BDI é realizado levando em conta os itens acima, aplicados na fórmula, esta metodologia é a adotada pelo TCE."]