{"kind":"formula","sheet":"01_Entrada","address":"E5","formula":"=IF($B$5<=1000,\"Switch A (<=1G)\",\"Switch B (>1G)\")"}
{"kind":"formula","sheet":"01_Entrada","address":"G5","formula":"=E22"}
{"kind":"formula","sheet":"01_Entrada","address":"J5","formula":"=E23"}
{"kind":"formula","sheet":"01_Entrada","address":"E6","formula":"=IF($B$5<=1000,VLOOKUP(\"Switch_ate_1G\",'03_Parametros_Custos'!$A:$B,2,FALSE),VLOOKUP(\"Switch_acima_1G\",'03_Parametros_Custos'!$A:$B,2,FALSE))+IF($B$5<=1000,VLOOKUP(\"Modulo_1G_par\",'03_Parametros_Custos'!$A:$B,2,FALSE),VLOOKUP(\"Modulo_10G_par\",'03_Parametros_Custos'!$A:$B,2,FALSE))+VLOOKUP(\"Caixa_emenda\",'03_Parametros_Custos'!$A:$B,2,FALSE)+VLOOKUP(\"Caixa_TO\",'03_Parametros_Custos'!$A:$B,2,FALSE)+VLOOKUP(\"Acessorios_gerais\",'03_Parametros_Custos'!$A:$B,2,FALSE)+VLOOKUP(\"Cordao_optico\",'03_Parametros_Custos'!$A:$B,2,FALSE)+VLOOKUP(\"Cabo_CAT6\",'03_Parametros_Custos'!$A:$B,2,FALSE)+($B$6*VLOOKUP(\"Custo_por_m_fibra\",'03_Parametros_Custos'!$A:$B,2,FALSE))"}
{"kind":"formula","sheet":"01_Entrada","address":"G6","formula":"=E23"}
{"kind":"formula","sheet":"01_Entrada","address":"H6","formula":"=$E$23*12 + $E$22"}
{"kind":"formula","sheet":"01_Entrada","address":"J6","formula":"=E22"}
{"kind":"formula","sheet":"01_Entrada","address":"E7","formula":"=VLOOKUP(\"Custo_reparo_mensal\",'03_Parametros_Custos'!$A:$B,2,FALSE)+VLOOKUP(\"Custo_Opex_outros\",'03_Parametros_Custos'!$A:$B,2,FALSE)"}
{"kind":"formula","sheet":"01_Entrada","address":"G7","formula":"=$H$6"}
{"kind":"formula","sheet":"01_Entrada","address":"H7","formula":"=($H$6*VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE))"}
{"kind":"formula","sheet":"01_Entrada","address":"J7","formula":"=$H$6"}
{"kind":"formula","sheet":"01_Entrada","address":"E8","formula":"=VLOOKUP($B$5,'04_Valores_Mercado'!$A:$B,2,FALSE)"}
{"kind":"formula","sheet":"01_Entrada","address":"G8","formula":"=$H$7"}
{"kind":"formula","sheet":"01_Entrada","address":"H8","formula":"=$E$17*12"}
{"kind":"formula","sheet":"01_Entrada","address":"J8","formula":"=$E$13"}
{"kind":"formula","sheet":"01_Entrada","address":"A9","formula":"=IF($B$7=\"Sim\",\"Markup Parceiro (% - operador)\",\"\")"}
{"kind":"formula","sheet":"01_Entrada","address":"E9","formula":"=IF((1-'03_Parametros_Custos'!B12-'03_Parametros_Custos'!B13)<=0,\"\",E17/(1-'03_Parametros_Custos'!B12-'03_Parametros_Custos'!B13))"}
{"kind":"formula","sheet":"01_Entrada","address":"G9","formula":"=$H$8"}
{"kind":"formula","sheet":"01_Entrada","address":"H9","formula":"=($H$6*(1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)) - ($E$17*12) - $E$6)"}
{"kind":"formula","sheet":"01_Entrada","address":"J9","formula":"=$E$16"}
{"kind":"formula","sheet":"01_Entrada","address":"E10","formula":"=$E$22"}
{"kind":"formula","sheet":"01_Entrada","address":"G10","formula":"=$H$9"}
{"kind":"formula","sheet":"01_Entrada","address":"J10","formula":"=$E$17"}
{"kind":"formula","sheet":"01_Entrada","address":"E11","formula":"=$E$23"}
{"kind":"formula","sheet":"01_Entrada","address":"G11","formula":"=IF((E23-E17)<=0,\"Sem payback\",MAX(0,E6-E22)/(E23-E17))"}
{"kind":"formula","sheet":"01_Entrada","address":"H11","formula":"=IF($E$32<=0,\"Sem payback\",MAX(0,$E$6-$E$22)/$E$32)"}
{"kind":"formula","sheet":"01_Entrada","address":"I11","formula":"=IF(E23>E19+0.01,\"Avise ao vendedor que o valor mensal está acima do valor de mercado.\",\"\")"}
{"kind":"formula","sheet":"01_Entrada","address":"E12","formula":"=IF($H$6=0,0,$H$9/$H$6)"}
{"kind":"formula","sheet":"01_Entrada","address":"G12","formula":"=$E$13"}
{"kind":"formula","sheet":"01_Entrada","address":"H12","formula":"=$E$11*$E$25 + $E$10"}
{"kind":"formula","sheet":"01_Entrada","address":"E13","formula":"=IF($E$12>=VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE),\"OK (>= meta)\",\"Abaixo da meta\")"}
{"kind":"formula","sheet":"01_Entrada","address":"H13","formula":"=($H$12*VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE))"}
{"kind":"formula","sheet":"01_Entrada","address":"E15","formula":"=$B$5*'05_Custo_Mbps'!$B$9"}
{"kind":"formula","sheet":"01_Entrada","address":"H15","formula":"=($H$12*(1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)) - $H$14 - $E$6)"}
{"kind":"formula","sheet":"01_Entrada","address":"E16","formula":"=IF($B$7=\"Sim\",MAX($B$5*VLOOKUP($B$5,'06_Parceiro_Tabela'!$A:$B,2,FALSE), $E$8*$E$24),0)"}
{"kind":"formula","sheet":"01_Entrada","address":"G16","formula":"=$E$25"}
{"kind":"formula","sheet":"01_Entrada","address":"E17","formula":"=$E$7+$E$15+$E$16"}
{"kind":"formula","sheet":"01_Entrada","address":"G17","formula":"=$H$12"}
{"kind":"formula","sheet":"01_Entrada","address":"E18","formula":"=IF((1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE))<=0,\"ERRO\", ($E$17 + ($E$6/VLOOKUP(\"Prazo_Contrato_Meses\",'03_Parametros_Custos'!$A:$B,2,FALSE))) / (1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE)))"}
{"kind":"formula","sheet":"01_Entrada","address":"G18","formula":"=$H$13"}
{"kind":"formula","sheet":"01_Entrada","address":"E19","formula":"=$E$8"}
{"kind":"formula","sheet":"01_Entrada","address":"G19","formula":"=$H$15"}
{"kind":"formula","sheet":"01_Entrada","address":"E20","formula":"=IF((1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE))<=0,\"ERRO\", ($E$17*12 + $E$6) / (1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE)))"}
{"kind":"formula","sheet":"01_Entrada","address":"E21","formula":"=$E$20/12"}
{"kind":"formula","sheet":"01_Entrada","address":"G21","formula":"=($E$11*12+$E$10)*(1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)) - ($E$17*12) - $E$26"}
{"kind":"formula","sheet":"01_Entrada","address":"E22","formula":"=$E$37"}
{"kind":"formula","sheet":"01_Entrada","address":"G22","formula":"=IF(($E$11*(1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE))-$E$17)<=0,\"Sem\", (0.3*$E$6) / (($E$11*(1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE))-$E$17)) )"}
{"kind":"formula","sheet":"01_Entrada","address":"E23","formula":"=$E$40"}
{"kind":"formula","sheet":"01_Entrada","address":"E24","formula":"=IF($B$7=\"Sim\",IF(ISNUMBER($B$9),$B$9,VLOOKUP(\"Markup_parceiro\",'03_Parametros_Custos'!$A:$B,2,FALSE)),0)"}
{"kind":"formula","sheet":"01_Entrada","address":"E25","formula":"=MAX(1,INT($B$8))"}
{"kind":"formula","sheet":"01_Entrada","address":"E26","formula":"=IF($E$25>12,$E$6*(0.3+0.7*(12/$E$25)),$E$6)"}
{"kind":"formula","sheet":"01_Entrada","address":"E27","formula":"=IF((1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE))<=0,\"ERRO\", (($E$17*12)+$E$26) / (1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE)) / 12)"}
{"kind":"formula","sheet":"01_Entrada","address":"E28","formula":"=IF((1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE))<=0,\"ERRO\", ($E$17 + (0.3*$E$6)/8) / (1-VLOOKUP(\"Imposto_percentual\",'03_Parametros_Custos'!$A:$B,2,FALSE)-VLOOKUP(\"Lucro_liquido_meta\",'03_Parametros_Custos'!$A:$B,2,FALSE)))"}
{"kind":"formula","sheet":"01_Entrada","address":"E29","formula":"=MAX($E$27,$E$28)"}
{"kind":"formula","sheet":"01_Entrada","address":"E30","formula":"=IF($B$8=24,0.1,IF($B$8=36,0.2,0))"}
{"kind":"formula","sheet":"01_Entrada","address":"E31","formula":"=E19"}
{"kind":"formula","sheet":"01_Entrada","address":"E32","formula":"=E9"}
{"kind":"formula","sheet":"01_Entrada","address":"E33","formula":"=MAX($E$31,$E$32)"}
{"kind":"formula","sheet":"01_Entrada","address":"E34","formula":"=($E$33-E17)"}
{"kind":"formula","sheet":"01_Entrada","address":"E35","formula":"=MAX(0,E6-8*$E$34)"}
{"kind":"formula","sheet":"01_Entrada","address":"E36","formula":"=IF($E$35<=0,0,IF(0.3*$E$35<990,0,MIN(2000,0.3*$E$35)))"}
{"kind":"formula","sheet":"01_Entrada","address":"E37","formula":"=IF(B10>0,B10,$E$36)"}
{"kind":"formula","sheet":"01_Entrada","address":"E38","formula":"=MAX(0,$E$35-$E$37)"}
{"kind":"formula","sheet":"01_Entrada","address":"E39","formula":"=$E$38/8"}
{"kind":"formula","sheet":"01_Entrada","address":"E40","formula":"=$E$33+$E$39"}
{"kind":"formula","sheet":"01_Entrada","address":"E41","formula":"=IF(1-$E$30<=0,$E$40,$E$40/(1-$E$30))"}