{"text_format":"2","workbook":"xlsx","n_sheets":10,"sheets":["Espacio y rack","Energía","Postes","Ductos","Parámetros","Resumen energía","Inversión energía","Detalle Ed.Principal","Detalle Ed.URA","Detalle Ed.Remoto"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":15,"defined_names":587,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Espacio y rack","index":0,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[48,2,48,6],[48,1,49,1],[2,1,3,1],[2,2,2,6],[31,2,31,6],[31,1,32,1],[40,7,41,7],[40,2,40,6],[40,1,41,1]]}
[1,"ESPACIO EN RACK"]
[null,null,{"$f":"C5*C26","v":61.320087256626842},{"$f":"D5*D26","v":42.434764805901622},42.855996587978261,29.05222540834302,{"$f":"G5*G26","v":23.995043786734566}]
[null,"Variables de la fórmula","1. Espacio en Rack (por tipo de zona)"]
[null,null,"Zona A","Zona B","Zona C","Zona D","Zona E"]
[null,null,{"$f":"C6+C7","v":183.96210139089442},{"$f":"D6+D7","v":127.3055674733796},128.56927545668935,87.157547800507061,{"$f":"G6+G7","v":71.985851218715879}]
[null,"Mensualidad edific. y obra civil=",{"$f":"(C12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))","v":144.00202070602558},{"$f":"(D12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))","v":87.34548678851074},{"$f":"(E12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))","v":88.609194771820498},{"$f":"(F12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))","v":47.197467115638204},{"$f":"(G12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))","v":32.025770533847023},null,null,"Penalidad"]
[null,"Mensualidad rack=",{"$f":"(C13+C51)*($C$18/(1-(1+$C$18)^(-$C$16)))","v":39.960080684868856},{"$f":"(D13+C51)*($C$18/(1-(1+$C$18)^(-$C$16)))","v":39.960080684868856},{"$f":"(E13+C51)*($C$18/(1-(1+$C$18)^(-$C$16)))","v":39.960080684868856},{"$f":"(F13+C51)*($C$18/(1-(1+$C$18)^(-$C$16)))","v":39.960080684868856},{"$f":"(G13+C51)*($C$18/(1-(1+$C$18)^(-$C$16)))","v":39.960080684868856},null,null,null,{"$f":"K9+K10","v":61.320087256626856},{"$f":"L9+L10","v":42.434764805901629},{"$f":"M9+M10","v":42.855996587978268},{"$f":"N9+N10","v":29.052225408343016},{"$f":"O9+O10","v":23.995043786734563}]
[{"$nulls":10},{"$f":"+C4","v":"Zona A"},{"$f":"+D4","v":"Zona B"},"Zona C","Zona D","Zona E"]
[null,"Precio (1/3 Rack) =",{"$f":"(((C12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))+(C13+$C$51)*($C$18/(1-(1+$C$18)^(-$C$16))))+C20+C24)*C26","v":115.30631989816024},{"$f":"(((D12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))+(D13+$C$51)*($C$18/(1-(1+$C$18)^(-$C$16))))+D20+D24)*D26","v":78.863517195354987},{"$f":"(((E12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))+(E13+$C$51)*($C$18/(1-(1+$C$18)^(-$C$16))))+E20+E24)*E26","v":79.676363614388762},{"$f":"(((F12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))+(F13+$C$51)*($C$18/(1-(1+$C$18)^(-$C$16))))+F20+F24)*F26","v":53.039375500119135},{"$f":"(((G12+$D$51)*($C$18/(1-(1+$C$18)^(-$C$15)))+(G13+$C$51)*($C$18/(1-(1+$C$18)^(-$C$16))))+G20+G24)*G26","v":43.280586760906886},null,null,"Mensualidad de inv inicial",{"$f":"+(C26*(C34+D34)*($C$18/(1-(1+$C$18)^(-$C$15))))+(C26*E34*($C$18/(1-(1+$C$18)^(-$C$16))))","v":57.377043327633167},{"$f":"+(D26*(C35+D35)*($C$18/(1-(1+$C$18)^(-$C$15))))+(D26*E35*($C$18/(1-(1+$C$18)^(-$C$16))))","v":38.491720876907941},{"$f":"+(E26*(C36+D36)*($C$18/(1-(1+$C$18)^(-$C$15))))+(E26*E36*($C$18/(1-(1+$C$18)^(-$C$16))))","v":38.91295265898458},{"$f":"+(F26*(C37+D37)*($C$18/(1-(1+$C$18)^(-$C$15))))+(F26*E37*($C$18/(1-(1+$C$18)^(-$C$16))))","v":25.109181479349331},{"$f":"+(G26*(C38+D38)*($C$18/(1-(1+$C$18)^(-$C$15))))+(G26*E38*($C$18/(1-(1+$C$18)^(-$C$16))))","v":20.051999857740878}]
[null,"Precio (Full Rack) =",{"$f":"C9*3","v":345.91895969448069},{"$f":"D9*3","v":236.59055158606498},239.02909084316627,159.11812650035739,129.84176028272066,null,null,"Mensualidad de inv incremental",{"$f":"+(C26*C51*($C$18/(1-(1+$C$18)^(-$C$16))))+(C26*D51*($C$18/(1-(1+$C$18)^(-$C$15))))","v":3.9430439289936858},{"$f":"+(D26*C52*($C$18/(1-(1+$C$18)^(-$C$16))))+(D26*D52*($C$18/(1-(1+$C$18)^(-$C$15))))","v":3.9430439289936858},{"$f":"+(E26*C53*($C$18/(1-(1+$C$18)^(-$C$16))))+(E26*D53*($C$18/(1-(1+$C$18)^(-$C$15))))","v":3.9430439289936858},{"$f":"+(F26*C54*($C$18/(1-(1+$C$18)^(-$C$16))))+(F26*D54*($C$18/(1-(1+$C$18)^(-$C$15))))","v":3.9430439289936858},{"$f":"+(G26*C55*($C$18/(1-(1+$C$18)^(-$C$16))))+(G26*D55*($C$18/(1-(1+$C$18)^(-$C$15))))","v":3.9430439289936858}]
[null,"Precio (2/3 Rack) =",{"$f":"C9*2","v":230.61263979632048},{"$f":"D9*2","v":157.72703439070997},159.35272722877752,106.07875100023827,86.561173521813771,null,null,{"$f":"+B20","v":"OAMr ="},{"$f":"+(C26*C20)","v":53.986232641533405},{"$f":"+(D26*D20)","v":36.428752389453358},{"$f":"+(E26*E20)","v":36.820367026410494},{"$f":"+(F26*F20)","v":23.987150091776122},{"$f":"+(G26*G20)","v":19.285542974172319}]
[null,"Inversión edific. y obra civil (n=240)",{"$f":"SUM(C34:D34)","v":18479.368082215573},{"$f":"SUM(C35:D35)","v":10938.087746253514},{"$f":"SUM(C36:D36)","v":11106.29387370223},{"$f":"SUM(C37:D37)","v":5594.1768086793054},{"$f":"SUM(C38:D38)","v":3574.7448176221433},null,null,{"$f":"+B24","v":"Ct ="},{"$f":"+(C26*C24)","v":0},{"$f":"+(D26*D24)","v":0},{"$f":"+(E26*E24)","v":0},{"$f":"+(F26*F24)","v":0},{"$f":"+(G26*G24)","v":0}]
[null,"Inversión en rack (n=120)",{"$f":"E34","v":2920},{"$f":"E35","v":2920},{"$f":"E36","v":2920},{"$f":"E37","v":2920},{"$f":"E38","v":2920},null,null,{"$f":"+B22","v":"OAMi ="},{"$f":"+(C22*C28)","v":0},{"$f":"+(D22*D28)","v":0},{"$f":"+(E22*E28)","v":0},{"$f":"+(F22*F28)","v":0},{"$f":"+(G22*G28)","v":0}]
[null,"Inversión total",{"$f":"SUM(C12:C13)","v":21399.368082215573},{"$f":"SUM(D12:D13)","v":13858.087746253514},14026.29387370223,8514.1768086793054,6494.7448176221433,null,null,"Precio total (1/3 Rack) =",{"$f":"SUM(K9:K13)","v":115.30631989816027},{"$f":"SUM(L9:L13)","v":78.863517195354987},{"$f":"SUM(M9:M13)","v":79.676363614388762},53.039375500119135,{"$f":"SUM(O9:O13)","v":43.280586760906886}]
[null,"n \"edific. y obra civil\" =",{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$5","v":240}]
[null,"n \"rack\" =",{"$f":"Parámetros!$E$7","v":120},{"$f":"Parámetros!$E$7","v":120},{"$f":"Parámetros!$E$7","v":120},{"$f":"Parámetros!$E$7","v":120},{"$f":"Parámetros!$E$7","v":120},null,null,"% inv incremental=",{"$f":"+K10/K14","v":3.4196251623295433E-2},{"$f":"+L10/L14","v":4.9998327100048853E-2},{"$f":"+M10/M14","v":4.9488251598390105E-2},7.4341824197851444E-2,{"$f":"+O10/O14","v":9.1104216095222471E-2}]
[]
[null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3}]
[]
[null,"OAMr =",{"$f":"SUM(C43:G43)","v":161.96031752777549},{"$f":"SUM(C44:G44)","v":109.28735004186049},{"$f":"SUM(C45:G45)","v":110.46220570128848},{"$f":"SUM(C46:G46)","v":71.962169897027337},{"$f":"SUM(C47:G47)","v":57.857207494591904}]
[]
[null,"OAMi =",0,0,0,0,0]
[]
[null,"Ct =",0,0,0,0,0]
[]
[null,"FUT =",0.33333000000000002,0.33333000000000002,0.33333000000000002,0.33333000000000002,0.33333000000000002]
[]
[null,"FUC ="]
[]
[null,"Adecuación =",0,0,0,0,0]
[null,"Preciario considerado por OSIPTEL"]
[null,"Tipo de zona","Inversión Inicial (relativa a un entrante) S/."]
[null,"Espacio en Rack","Costo 3m2 Edificación","Trabajos de adecuación de 3m2 edif. (a sala técnica)","INVERSIÓN - Rack","Vida útil Edificación (mes)","Vida útil- Rack (mes)"]
[null,"Zona A",16185.8601747476,{"$f":"$C$39*$D$39","v":2293.5079074679734},2920,{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$7","v":120}]
[null,"Zona B",8644.5798387855393,{"$f":"$C$39*$D$39","v":2293.5079074679734},2920,{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$7","v":120}]
[null,"Zona C",8812.7859662342562,{"$f":"$C$39*$D$39","v":2293.5079074679734},2920,{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$7","v":120}]
[null,"Zona D",3300.668901211332,2293.5079074679734,2920,{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$7","v":120}]
[null,"Zona E",1281.2369101541699,2293.5079074679734,2920,{"$f":"Parámetros!$E$5","v":240},{"$f":"Parámetros!$E$7","v":120}]
[null,"Promedio",{"$f":"AVERAGE(C34:C38)","v":7645.0263582265789},0.3]
[]
[null,"Tipo de zona","OAMr (mensual)",{"$nulls":4},"Factor Uso (OPEX + Inversión Inicial)"]
[null,"Espacio en Rack","Costo de operación y mantenimiento","Seguridad","Arbitrios","Gasto Administrativo","Margen Operativo"]
[null,"Zona A",{"$f":"(C12+C13)*$C$48/12","v":121.26308579922159},3.2178005621910377,6.0319385373928611,{"$f":"(SUM(C43:E43)+C5)*$F$48","v":31.447492628969993},0,1]
[null,"Zona B",{"$f":"(D12+D13)*$C$48/12","v":78.529163895436582},3.2178005621910377,6.0319385373928611,{"$f":"(SUM(C44:E44)+D5)*$F$48","v":21.508447046840008},0,1]
[null,"Zona C",{"$f":"(E12+E13)*$C$48/12","v":79.482331950979315},3.2178005621910377,6.0319385373928602,{"$f":"(SUM(C45:E45)+E5)*$F$48","v":21.730134650725258},0,1]
[null,"Zona D",{"$f":"(F12+F13)*$C$48/12","v":48.247001915849403},3.2178005621910377,6.0319385373928611,{"$f":"(SUM(C46:E46)+F5)*$F$48","v":14.465428881594036},0,1]
[null,"Zona E",{"$f":"(G12+G13)*$C$48/12","v":36.803553966525477},3.2178005621910377,6.0319385373928611,{"$f":"(SUM(C47:E47)+G5)*$F$48","v":11.803914428482527},0,1]
[null,null,6.8000000000000005E-2,null,null,0.1]
[null,"Tipo de zona","CAPEX incremental"]
[null,"Espacio en Rack","Adecuación del rack (para compartición)","Adecuación de obra civil (para compartición)","Inversión de adecuación total (incremental)","Instalación","Estudios + Mano Obra","G. Adm.","Factor Uso (CAPEX incremental)"]
[null,"Zona A",{"$f":"(E34*$C$56)","v":584},{"$f":"D34*$D$56","v":688.05237224039195},{"$f":"C51+D51","v":1272.0523722403918},null,null,null,1]
[null,"Zona B",{"$f":"(E35*$C$56)","v":584},{"$f":"D35*$D$56","v":688.05237224039195},{"$f":"C52+D52","v":1272.0523722403918},null,null,null,1]
[null,"Zona C",584,688.05237224039195,1272.0523722403918,null,null,null,1]
[null,"Zona D",584,688.05237224039195,1272.0523722403918,null,null,null,1]
[null,"Zona E",584,688.05237224039195,1272.0523722403918,null,null,null,1]
[null,null,0.2,0.3]

{"sheet":"Energía","index":1,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":false,"merged":[[32,22,33,22],[32,2,32,3],[40,2,40,4],[32,10,32,11],[40,10,40,12],[32,18,32,19],[40,18,40,20],[32,6,33,6],[32,14,33,14],[32,4,32,5],[32,12,32,13],[32,20,32,21],[6,18,6,22],[6,1,7,1],[6,2,6,6],[6,9,7,9],[6,10,6,14],[6,17,7,17]]}
[]
[]
[2,"CAPACIDAD DE ENERGÍA"]
[]
[]
[]
[null,"Variables de la fórmula","2.a Energía AC (por tipo de zona)",{"$nulls":6},"Variables de la fórmula","2.b Energía DC por tipo de zona",{"$nulls":6},"Variables de la fórmula","2.c Energía AC – estabilizada (por tipo de zona)"]
[null,null,"Zona A","Zona B","Zona C","Zona D","Zona E",null,null,null,"Zona A","Zona B","Zona C","Zona D","Zona E",null,null,null,"Zona A","Zona B","Zona C","Zona D","Zona E"]
[]
[null,"Mensualidad de Inversión=",{"$f":"C14*($C$18/(1-(1+$C$18)^(-$C$16)))","v":114.67761566599344},{"$f":"D14*($C$18/(1-(1+$C$18)^(-$C$16)))","v":114.67761566599344},{"$f":"E14*($C$18/(1-(1+$C$18)^(-$C$16)))","v":68.374420853920299},{"$f":"F14*($C$18/(1-(1+$C$18)^(-$C$16)))","v":68.374420853920299},{"$f":"G14*($C$18/(1-(1+$C$18)^(-$C$16)))","v":123.10912096281228},null,null,"Mensualidad de Inversión=",{"$f":"K14*($K$18/(1-(1+$K$18)^(-$K$16)))","v":325.39288168396399},{"$f":"L14*($K$18/(1-(1+$K$18)^(-$K$16)))","v":325.39288168396399},{"$f":"M14*($K$18/(1-(1+$K$18)^(-$K$16)))","v":202.7734694279284},202.7734694279284,259.60875835044993,null,null,"Mensualidad de Inversión=",{"$f":"S14*($S$18/(1-(1+$S$18)^(-$S$16)))","v":214.24095276898302},{"$f":"T14*($S$18/(1-(1+$S$18)^(-$S$16)))","v":214.24095276898302},{"$f":"U14*($S$18/(1-(1+$S$18)^(-$S$16)))","v":183.60257194312709},183.60257194312709,{"$f":"W14*($S$18/(1-(1+$S$18)^(-$S$16)))","v":223.96679679407754}]
[null,null,{"$f":"((C10+C20+C24)*C26)+(C22*C28)","v":188.82649717534605},{"$f":"((D10+D20+D24)*D26)+(D22*D28)","v":188.82649717534605},112.58432878341844,{"$f":"((F10+F20+F24)*F26)+(F22*F28)","v":112.58432878341844},202.70969139653351,null,null,null,{"$f":"((K10+K20+K24)*K26)+(K22*K28)","v":535.78719523722202},{"$f":"((L10+L20+L24)*L26)+(L22*L28)","v":535.78719523722202},333.88385108814293,333.88385108814293,{"$f":"((O10+O20+O24)*O26)+(O22*O28)","v":427.46801274743495},null,null,null,{"$f":"((S10+S20+S24)*S26)+(S22*S28)","v":352.76604268353458},{"$f":"((T10+T20+T24)*T26)+(T22*T28)","v":352.76604268353458},302.31732959447925,302.31732959447925,{"$f":"((W10+W20+W24)*W26)+(W22*W28)","v":368.78047626472528}]
[null,"Precio Mensual (1 KW) =",{"$f":"(((C14*($C$18/(1-(1+$C$18)^(-$C$16))))+C20+C24)*C26)+(C22*C28)","v":188.82649717534605},{"$f":"(((D14*($C$18/(1-(1+$C$18)^(-$C$16))))+D20+D24)*D26)+(D22*D28)","v":188.82649717534605},{"$f":"(((E14*($C$18/(1-(1+$C$18)^(-$C$16))))+E20+E24)*E26)+(E22*E28)","v":112.58432878341844},{"$f":"(((F14*($C$18/(1-(1+$C$18)^(-$C$16))))+F20+F24)*F26)+(F22*F28)","v":112.58432878341844},{"$f":"(((G14*($C$18/(1-(1+$C$18)^(-$C$16))))+G20+G24)*G26)+(G22*G28)","v":202.70969139653351},null,null,"Precio Mensual =",{"$f":"(((K14*($K$18/(1-(1+$K$18)^(-$K$16))))+K20+K24)*K26)+(K22*K28)","v":535.78719523722202},{"$f":"(((L14*($K$18/(1-(1+$K$18)^(-$K$16))))+L20+L24)*L26)+(L22*L28)","v":535.78719523722202},{"$f":"(((M14*($K$18/(1-(1+$K$18)^(-$K$16))))+M20+M24)*M26)+(M22*M28)","v":333.88385108814293},{"$f":"(((N14*($K$18/(1-(1+$K$18)^(-$K$16))))+N20+N24)*N26)+(N22*N28)","v":333.88385108814293},{"$f":"(((O14*($K$18/(1-(1+$K$18)^(-$K$16))))+O20+O24)*O26)+(O22*O28)","v":427.46801274743495},null,null,"Precio Mensual =",{"$f":"(((S14*($S$18/(1-(1+$K$18)^(-$S$16))))+S20+S24)*S26)+(S22*S28)","v":352.76604268353458},{"$f":"(((T14*($S$18/(1-(1+$K$18)^(-$S$16))))+T20+T24)*T26)+(T22*T28)","v":352.76604268353458},302.31732959447925,302.31732959447925,{"$f":"(((W14*($S$18/(1-(1+$K$18)^(-$S$16))))+W20+W24)*W26)+(W22*W28)","v":368.78047626472528}]
[]
[null,"Inversión =",{"$f":"C35","v":10055.794643222447},{"$f":"C36","v":10055.794643222447},{"$f":"C37","v":5995.5827557389475},{"$f":"C38","v":5995.5827557389475},{"$f":"C39","v":10795.1323536},null,null,"Inversión =",{"$f":"K35","v":28532.891772972445},{"$f":"K36","v":28532.891772972445},{"$f":"K37","v":17780.700756805614},{"$f":"K38","v":17780.700756805614},{"$f":"K39","v":22764.445758599999},null,null,"Inversión =",{"$f":"S35","v":18786.255824222448},{"$f":"S36","v":18786.255824222448},{"$f":"S37","v":16099.652479738948},{"$f":"S38","v":16099.652479738948},{"$f":"S39","v":19639.090875599999}]
[]
[null,"n =",{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},null,null,"n =",{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},null,null,"n =",{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120},{"$f":"Parámetros!$E$8","v":120}]
[]
[null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},null,null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},null,null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3}]
[]
[null,"OAMr =",{"$f":"SUM(E35:F35)","v":74.148881509352606},{"$f":"SUM(E36:F36)","v":74.148881509352606},{"$f":"SUM(E37:F37)","v":44.209907929498137},{"$f":"SUM(E38:F38)","v":44.209907929498137},{"$f":"SUM(E39:F39)","v":79.600570433721231},null,null,"OAMr =",{"$f":"SUM(M35:N35)","v":210.39431355325797},{"$f":"SUM(M36:N36)","v":210.39431355325797},{"$f":"SUM(M37:N37)","v":131.1103816602145},{"$f":"SUM(M38:N38)","v":131.1103816602145},{"$f":"SUM(M39:N39)","v":167.85925439698499},null,null,"OAMr =",{"$f":"SUM(U35:V35)","v":138.52508991455156},{"$f":"SUM(U36:V36)","v":138.52508991455156},{"$f":"SUM(U37:V37)","v":118.71475765135216},{"$f":"SUM(U38:V38)","v":118.71475765135216},{"$f":"SUM(U39:V39)","v":144.81367947064777}]
[]
[null,"OAMi =",0,0,0,0,0,null,null,"OAMi =",0,0,0,0,0,null,null,"OAMi =",0,0,0,0,0]
[]
[null,"Ct =",0,0,0,0,0,null,null,"Ct =",0,0,0,0,0,null,null,"Ct =",0,0,0,0,0]
[]
[null,"FUT =",1,1,1,1,1,null,null,"FUT =",1,1,1,1,1,null,null,"FUT =",1,1,1,1,1]
[]
[null,"FUC =",1,1,1,1,1,null,null,"FUC =",1,1,1,1,1,null,null,"FUC =",1,1,1,1,1]
[]
[null,"Adecuación =",{"$f":"SUM(C43:D43)","v":300},{"$f":"SUM(C44:D44)","v":300},{"$f":"SUM(C45:D45)","v":300},{"$f":"SUM(C46:D46)","v":300},{"$f":"SUM(C47:D47)","v":300},null,null,"Adecuación =",{"$f":"SUM(K43:L43)","v":300},{"$f":"SUM(K44:L44)","v":300},{"$f":"SUM(K45:L45)","v":300},{"$f":"SUM(K46:L46)","v":300},{"$f":"SUM(K47:L47)","v":300},null,null,"Adecuación =",{"$f":"SUM(S43:T43)","v":300},{"$f":"SUM(S44:T44)","v":300},{"$f":"SUM(S45:T45)","v":300},{"$f":"SUM(S46:T46)","v":300},{"$f":"SUM(S47:T47)","v":300}]
[]
[null,"Preciario considerado por OSIPTEL",{"$nulls":7},"Preciario considerado por OSIPTEL",{"$nulls":7},"Preciario considerado por OSIPTEL"]
[null,null,"Inversión Inicial (relativa a un entrante)",null,"OAMr",null,"Factor Uso (OPEX + Inversión Inicial)",null,null,null,"Inversión Inicial (relativa a un entrante)",null,"OAMr",null,"Factor Uso (OPEX + Inversión Inicial)",null,null,null,"Inversión Inicial (relativa a un entrante)",null,"OAMr",null,"Factor Uso (OPEX + Inversión Inicial)"]
[null,"Energía AC","Monto de Inversión","Vida útil","Costo de operación y mantenimiento","Gasto Administrativo",null,null,null,"Energía DC","Monto de Inversión","Vida útil","Costo de operación y mantenimiento","Gasto Administrativo",null,null,null,"Energía AC Estabilizada","Monto de Inversión","Vida útil","Costo de operación y mantenimiento","Gasto Administrativo"]
[null,"Zona A",{"$f":"'Resumen energía'!F7","v":10055.794643222447},{"$f":"Parámetros!$E$8","v":120},{"$f":"C14*$E$40/12","v":56.982836311593871},{"$f":"(E35+C10)*$F$40","v":17.166045197758731},1,null,null,"Zona A",{"$f":"'Resumen energía'!F6","v":28532.891772972445},{"$f":"Parámetros!$E$8","v":120},{"$f":"K14*$M$40/12","v":161.68638671351053},{"$f":"(M35+K10)*$N$40","v":48.707926839747451},1,null,null,"Zona A",{"$f":"'Resumen energía'!F8","v":18786.255824222448},{"$f":"Parámetros!$E$8","v":120},{"$f":"S14*$U$40/12","v":106.45544967059386},{"$f":"(U35+S10)*$V$40","v":32.069640243957693},1]
[null,"Zona B",{"$f":"'Resumen energía'!F7","v":10055.794643222447},{"$f":"Parámetros!$E$8","v":120},{"$f":"D14*$E$40/12","v":56.982836311593871},{"$f":"(E36+D10)*$F$40","v":17.166045197758731},1,null,null,"Zona B",{"$f":"'Resumen energía'!F6","v":28532.891772972445},{"$f":"Parámetros!$E$8","v":120},{"$f":"L14*$M$40/12","v":161.68638671351053},{"$f":"(M36+L10)*$N$40","v":48.707926839747451},1,null,null,"Zona B",{"$f":"'Resumen energía'!F8","v":18786.255824222448},{"$f":"Parámetros!$E$8","v":120},{"$f":"T14*$U$40/12","v":106.45544967059386},{"$f":"(U36+T10)*$V$40","v":32.069640243957693},1]
[null,"Zona C",{"$f":"'Resumen energía'!F11","v":5995.5827557389475},{"$f":"Parámetros!$E$8","v":120},{"$f":"E14*$E$40/12","v":33.974968949187371},{"$f":"(E37+E10)*$F$40","v":10.234938980310767},1,null,null,"Zona C",{"$f":"'Resumen energía'!F10","v":17780.700756805614},{"$f":"Parámetros!$E$8","v":120},{"$f":"M14*$M$40/12","v":100.75730428856515},{"$f":"(M37+M10)*$N$40","v":30.353077371649359},1,null,null,"Zona C",{"$f":"'Resumen energía'!F12","v":16099.652479738948},{"$f":"Parámetros!$E$8","v":120},{"$f":"U14*$U$40/12","v":91.231364051854044},{"$f":"(U37+U10)*$V$40","v":27.483393599498115},1]
[null,"Zona D",{"$f":"'Resumen energía'!F11","v":5995.5827557389475},{"$f":"Parámetros!$E$8","v":120},{"$f":"F14*$E$40/12","v":33.974968949187371},{"$f":"(E38+F10)*$F$40","v":10.234938980310767},1,null,null,"Zona D",{"$f":"'Resumen energía'!F10","v":17780.700756805614},{"$f":"Parámetros!$E$8","v":120},{"$f":"N14*$M$40/12","v":100.75730428856515},{"$f":"(M38+N10)*$N$40","v":30.353077371649359},1,null,null,"Zona D",{"$f":"'Resumen energía'!F12","v":16099.652479738948},{"$f":"Parámetros!$E$8","v":120},{"$f":"V14*$U$40/12","v":91.231364051854044},{"$f":"(U38+V10)*$V$40","v":27.483393599498115},1]
[null,"Zona E",{"$f":"'Resumen energía'!F15","v":10795.1323536},{"$f":"Parámetros!$E$8","v":120},{"$f":"G14*$E$40/12","v":61.172416670400004},{"$f":"(E39+G10)*$F$40","v":18.42815376332123},1,null,null,"Zona E",{"$f":"'Resumen energía'!F14","v":22764.445758599999},{"$f":"Parámetros!$E$8","v":120},{"$f":"O14*$M$40/12","v":128.99852596540001},{"$f":"(M39+O10)*$N$40","v":38.860728431584995},1,null,null,"Zona E",{"$f":"'Resumen energía'!F16","v":19639.090875599999},{"$f":"Parámetros!$E$8","v":120},{"$f":"W14*$U$40/12","v":111.28818162840001},{"$f":"(U39+W10)*$V$40","v":33.525497842247759},1]
[{"$nulls":4},6.8000000000000005E-2,0.1,{"$nulls":6},6.8000000000000005E-2,0.1,{"$nulls":6},6.8000000000000005E-2,0.1]
[null,null,"INVERSIÓN incremental",{"$nulls":7},"INVERSIÓN incremental",{"$nulls":7},"INVERSIÓN incremental"]
[null,"Energía AC","Monto de Inversión","Estudio","Factor Uso (inversión incremental)",{"$nulls":4},"Energía DC","Monto de Inversión","Estudio","Factor Uso (inversión incremental)",{"$nulls":4},"Energía AC Estabilizada","Monto de Inversión","Estudio","Factor Uso (inversión incremental)"]
[null,"Zona A",0,300,1,{"$nulls":4},"Zona A",0,300,1,{"$nulls":4},"Zona A",0,300,1]
[null,"Zona B",0,300,1,{"$nulls":4},"Zona B",0,300,1,{"$nulls":4},"Zona B",0,300,1]
[null,"Zona C",0,300,1,{"$nulls":4},"Zona C",0,300,1,{"$nulls":4},"Zona C",0,300,1]
[null,"Zona D",0,300,1,{"$nulls":4},"Zona D",0,300,1,{"$nulls":4},"Zona D",0,300,1]
[null,"Zona E",0,300,1,{"$nulls":4},"Zona E",0,300,1,{"$nulls":4},"Zona E",0,300,1]

{"sheet":"Postes","index":2,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[43,6,44,6],[43,2,43,5],[2,1,3,1],[2,2,2,3],[2,4,2,5],[27,2,27,7],[36,2,36,4],[36,5,37,5],[43,1,44,1],[27,1,28,1],[36,1,37,1]]}
[3,"PUNTO DE APOYO EN POSTE"]
[]
[null,"Variables de la fórmula","Poste de Concreto",null,"Poste de Fibra Vidrio"]
[null,null,"Lima","Provincias","Lima","Provincias"]
[null,"Mensualidad=",{"$f":"C9*($C$13/(1-(1+$C$13)^(-$C$11)))","v":5.4248374705253406},{"$f":"D9*($D$13/(1-(1+$D$13)^(-$D$11)))","v":5.4248374705253388},{"$f":"E9*($E$13/(1-(1+$E$13)^(-$E$11)))","v":9.9450645056469629},{"$f":"F9*($F$13/(1-(1+$F$13)^(-$F$11)))","v":9.9450645056469629}]
[null,null,{"$f":"((C5+C15+C19)*C21)+(C17*C23)","v":3.7545709558592919},{"$f":"((D5+D15+D19)*D21)+(D17*D23)","v":3.7545709558592906},{"$f":"((E5+E15+E19)*E21)+(E17*E23)","v":6.8830542020705536},{"$f":"((F5+F15+F19)*F21)+(F17*F23)","v":6.8830542020705536}]
[null,"Precio mensual (por punto de apoyo)=",{"$f":"(((C9*($C$13/(1-(1+$C$13)^(-$C$11))))+C15+C19)*C21)+(C17*C23)","v":3.7545709558592919},{"$f":"(((D9*($C$13/(1-(1+$C$13)^(-$C$11))))+D15+D19)*D21)+(D17*D23)","v":3.7545709558592906},{"$f":"(((E9*($C$13/(1-(1+$C$13)^(-$C$11))))+E15+E19)*E21)+(E17*E23)","v":6.8830542020705536},{"$f":"(((F9*($C$13/(1-(1+$C$13)^(-$C$11))))+F15+F19)*F21)+(F17*F23)","v":6.8830542020705536}]
[]
[null,"Inversión =",{"$f":"SUM(C30:G30)","v":849.6885000000002},{"$f":"SUM(C32:G32)","v":849.68849999999998},{"$f":"SUM(C31:G31)","v":1557.6885},{"$f":"SUM(C33:G33)","v":1557.6885}]
[]
[null,"n =",{"$f":"Parámetros!$E$9","v":360},{"$f":"Parámetros!$E$9","v":360},{"$f":"Parámetros!$E$9","v":360},{"$f":"Parámetros!$E$9","v":360}]
[]
[null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3}]
[]
[null,"OAMr =",{"$f":"SUM(C39:E39)","v":5.8388753970525356},{"$f":"SUM(C41:E41)","v":5.8388753970525347},{"$f":"SUM(C40:E40)","v":10.704098100564696},{"$f":"SUM(C42:E42)","v":10.704098100564696}]
[]
[null,"OAMi =",0,0,0,0]
[]
[null,"Ct =",0,0,0,0]
[]
[null,"FUT =",{"$f":"1/3","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},0.33333333333333331,0.33333333333333331]
[]
[null,"FUC ="]
[]
[null,"Adecuación por punto de apoyo =",{"$f":"SUM(C46:F46)","v":8.4459466666666678},{"$f":"SUM(C48:F48)","v":13.305658666666668},{"$f":"SUM(C47:F47)","v":8.4459466666666678},{"$f":"SUM(C49:F49)","v":13.305658666666668}]
[]
[null,"Preciario considerado por OSIPTEL"]
[null,"Punto de Apoyo en Postes","Inversión Inicial (relativa a 3 entrantes) S/."]
[null,"Espacio en Rack","Material","Montaje de poste (SICODI)","Grúa","Gasto Administrativo de obra","Licencias y Tributos de obra","Vida útil (mes)"]
[null,"Lima: Espacio en Postes de Concreto",480.05000000000007,{"$f":"C30*$D$34","v":369.63850000000008},0,null,null,{"$f":"Parámetros!$E$9","v":360}]
[null,"Lima: Espacio en Postes de Fibra de Vidrio",880.05,{"$f":"C31*$D$34","v":677.63850000000002},0,null,null,{"$f":"Parámetros!$E$9","v":360}]
[null,"Provincias: Espacio en Postes de Concreto",480.05,{"$f":"C32*$D$34","v":369.63850000000002},0,null,null,{"$f":"Parámetros!$E$9","v":360}]
[null,"Provincias: Espacio en Postes de Fibra de Vidrio",880.05,677.63850000000002,0,null,null,{"$f":"Parámetros!$E$9","v":360}]
[null,"Ratios",null,0.77]
[null,"Promedios"]
[]
[null,"Punto de Apoyo en Postes","OAMr",null,null,"Factor Uso (OPEX + Inversión Inicial)"]
[null,"Espacio en Rack","Costo de operación y mantenimiento","Gasto Administrativo","Margen Operativo"]
[null,"Lima: Espacio en Postes de Concreto",{"$f":"C9*$C$43/12","v":4.8149015000000013},{"$f":"(C39+C5)*$D$43","v":1.0239738970525341},0,0.33333333333333331]
[null,"Lima: Espacio en Postes de Fibra de Vidrio",{"$f":"E9*$C$43/12","v":8.8269015},{"$f":"(C40+E5)*$D$43","v":1.8771966005646963},0,0.33333333333333331]
[null,"Provincias: Espacio en Postes de Concreto",{"$f":"D9*$C$43/12","v":4.8149015000000004},{"$f":"(C41+D5)*$D$43","v":1.0239738970525341},0,0.33333333333333331]
[null,"Provincias: Espacio en Postes de Fibra de Vidrio",{"$f":"F9*$C$43/12","v":8.8269015},{"$f":"(C42+F5)*$D$43","v":1.8771966005646963},0,0.33333333333333331]
[null,null,6.8000000000000005E-2,0.1]
[null,"Tipo de zona","CAPEX incremental (por entrante)",null,null,null,"Factor Uso (CAPEX incremental)"]
[null,"Espacio en Rack","INVERSIÓN","Instalación","Estudios + Mano Obra","G. Adm."]
[null,"Lima: Espacio en Postes de Concreto",0,0.7466666666666667,6.9314666666666671,{"$f":"(D46+E46)*$F$50","v":0.76781333333333346},1]
[null,"Lima: Espacio en Postes de Fibra de Vidrio",0,0.7466666666666667,6.9314666666666671,{"$f":"(D47+E47)*$F$50","v":0.76781333333333346},1]
[null,"Provincias: Espacio en Postes de Concreto",0,0.7466666666666667,11.349386666666668,1.2096053333333334,1]
[null,"Provincias: Espacio en Postes de Fibra de Vidrio",0,0.7466666666666667,11.349386666666668,1.2096053333333334,1]
[null,null,null,1.1499999999999999,1.1499999999999999,0.1]

{"sheet":"Ductos","index":3,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[52,1,53,1],[52,2,52,6],[2,1,3,1],[2,2,2,3],[2,4,2,5],[43,1,44,1],[43,2,43,4],[43,5,44,5],[35,2,35,8],[35,1,36,1]]}
[4,"DUCTOS Y CANALIZACIÓN"]
[]
[null,"Variables de la fórmula","Canalización sobre suelo de concreto",null,"Canalización sobre suelo de concreto y Asfalto"]
[null,null,"Lima","Provincias","Lima","Provincias"]
[]
[null,"Mensualidad de inversión (5 operadores) =",{"$f":"C10*($C$14/(1-(1+$C$14)^(-$C$12)))","v":115.26890513941562},{"$f":"D10*($C$14/(1-(1+$C$14)^(-$C$12)))","v":108.04747856185777},{"$f":"E10*($C$14/(1-(1+$C$14)^(-$C$12)))","v":121.28823461943705},{"$f":"F10*($C$14/(1-(1+$C$14)^(-$C$12)))","v":114.06680804187923}]
[]
[null,"Precio mensual (por operador) =",{"$f":"(((C10*($C$14/(1-(1+$C$14)^(-$C$12))))+C16+C20)*C22)+(C18*C24)","v":44.486632184591443},{"$f":"(((D10*($C$14/(1-(1+$C$14)^(-$C$12))))+D16+D20)*D22)+(D18*D24)","v":41.699610414797633},{"$f":"(((E10*($C$14/(1-(1+$C$14)^(-$C$12))))+E16+E20)*E22)+(E18*E24)","v":46.809719197968612},{"$f":"(((F10*($C$14/(1-(1+$C$14)^(-$C$12))))+F16+F20)*F22)+(F18*F24)","v":44.022697428174808},null,null,{"$f":"+C26","v":613.71571296000002}]
[{"$nulls":8},{"$f":"+E26","v":645.76387962649596}]
[null,"Inversión =",{"$f":"SUM(L38)","v":15342.892824},{"$f":"SUM(L40)","v":14381.683260311964},{"$f":"SUM(L39)","v":16144.096990662398},{"$f":"SUM(L41)","v":15182.887426974365},null,null,{"$f":"+D26","v":575.2673304124786}]
[{"$nulls":8},{"$f":"+F26","v":607.31549707897454}]
[null,"n =",{"$f":"Parámetros!$E$6","v":240},{"$f":"Parámetros!$E$6","v":240},{"$f":"Parámetros!$E$6","v":240},{"$f":"Parámetros!$E$6","v":240}]
[]
[null,"WACC =",{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3},{"$f":"Parámetros!$I$5","v":5.4973670825229082E-3}]
[]
[null,"OAMr =",{"$f":"SUM(C46:E46)","v":107.16425578354159},{"$f":"SUM(C48:E48)","v":100.45057351213036},{"$f":"SUM(C47:E47)","v":112.760361370406},{"$f":"SUM(C49:E49)","v":106.04667909899482}]
[]
[null,"OAMi =",0,0,0,0]
[]
[null,"Ct =",0,0,0,0]
[]
[null,"FUT =",{"$f":"1/5","v":0.2},{"$f":"1/5","v":0.2},0.2,0.2]
[]
[null,"FUC =",0.25,0.25,0.25,0.25]
[]
[null,"Adecuación =",{"$f":"C55","v":613.71571296000002},{"$f":"C57","v":575.2673304124786},{"$f":"C56","v":645.76387962649596},{"$f":"C58","v":607.31549707897454}]
[]
[null,"Inversión considerada en el modelo de costos de terminación de llamada en red fija"]
[null,"Ductos, canalización (US$/km)",38306]
[null,"Cámara (US$/unidad)",1986.39]
[null,"Inversión total (US$/100mt)",{"$f":"+C29/10+C30","v":5816.99}]
[null,"Inversión total (S/100mt)",{"$f":"+C31*Parámetros!H9","v":15342.892823999999}]
[]
[]
[null,"Preciario considerado por OSIPTEL"]
[null,"Ductos","Inversión Inicial (relativa a 5 operadores) S/."]
[null,"Espacio en Rack","Obra Civil (Mano de Obra)","Obra Civil (Materiales)","Vigilancia","Gastos Administrativos de obra","Diseño","Licencias y Tributos de obra","Vida útil",null,null,"Nueva Inversión"]
[null,"Lima: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$nulls":6},{"$f":"Parámetros!$E$6","v":240},null,null,15342.892824]
[null,"Lima: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",{"$nulls":6},{"$f":"Parámetros!$E$6","v":240},null,null,16144.096990662398]
[null,"Provincias: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$nulls":6},{"$f":"Parámetros!$E$6","v":240},null,null,14381.683260311964]
[null,"Provincias: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",{"$nulls":6},{"$f":"Parámetros!$E$6","v":240},null,null,15182.887426974365]
[null,"Ratios"]
[]
[null,"Ductos","OAMr",null,null,"Factor Uso (OPEX + Inversión Inicial)"]
[null,"Espacio en Rack","Costo de operación y mantenimiento","Gasto Administrativo","Margen Operativo"]
[null,"Lima: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$f":"C10*$C$50/12","v":86.943059336000019},{"$f":"(C46+C6)*$D$50","v":20.221196447541566},0,0.2]
[null,"Lima: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",{"$f":"E10*$C$50/12","v":91.483216280420265},{"$f":"(C47+E6)*$D$50","v":21.277145089985734},0,0.2]
[null,"Provincias: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$f":"D10*$C$50/12","v":81.496205141767803},{"$f":"(C48+D6)*$D$50","v":18.954368370362555},0,0.2]
[null,"Provincias: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",{"$f":"F10*$C$50/12","v":86.036362086188078},{"$f":"(C49+F6)*$D$50","v":20.01031701280673},0,0.2]
[null,"Ratios",6.8000000000000005E-2,0.1]
[]
[]
[null,"Ductos","CAPEX incremental (por entrante)"]
[null,"Espacio en Rack","Inversión por operador (a todo costo)",null,null,null,"Factor Uso (CAPEX incremental)"]
[null,"Lima: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$f":"(L38/5)*$C$59","v":613.71571296000002},null,null,null,1]
[null,"Lima: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",{"$f":"(L39/5)*$C$59","v":645.76387962649596},null,null,null,1]
[null,"Provincias: Canalización, ductos y cámaras - Concreto (100m) - 2 pulgadas",{"$f":"(L40/5)*$C$59","v":575.2673304124786},null,null,null,1]
[null,"Provincias: Canalización, ductos y cámaras - Concreto + Asfalto (100m) -  2 pulgadas",607.31549707897454,null,null,null,1]
[null,"Ratios",0.2]

{"sheet":"Parámetros","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,3,2,4],[1,12,2,12],[1,13,2,13]]}
[null,"PARÁMETROS GENERALES"]
[{"$nulls":6},"WACC 2012","WACC después","WACC antes","Tax",null,"Para todos los servicios ","Ratio","Base sobre la que se aplica"]
[null,"ACTIVOS CONSIDERADOS",null,"VIDA ÚTIL",null,null,null,"impuestos S/.","impuestos S/.",0.37,null,"incluidos en la OBC de TdP"]
[null,"Activo","Tipo","Años","Meses",null,"WACC anual ",6.4899999999999999E-2,6.8000000000000005E-2,null,null,"Gastos de Operación y Mantenimiento",6.8000000000000005E-2,"Sobre la inversión (I)"]
[null,"Terreno y Obra Civil","Edificación",20,240,null,"WACC mensual ",{"$f":"(1+H4)^(1/12)-1","v":5.2538280408596094E-3},{"$f":"(1+I4)^(1/12)-1","v":5.4973670825229082E-3},null,null,"Gastos Administrativo",0.1,"Sobre el costo de OyM y la anualidad de inversión (CAPEX)"]
[null,"Ductos","Edificación",20,240,null,"Fuente:"]
[null,"Racks","Soporte",10,120]
[null,"Equipos de Energía","Soporte",10,120,null,"Tipo de cambio",2012]
[null,"Postes (concreto y fibra vidrio)","Postes",30,360,null,"Tipo de cambio S/. por US$",2.6375999999999999]
[{"$nulls":6},"Fuente: SBS"]

{"sheet":"Resumen energía","index":5,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,4,46,7],[36,1,42,1],[36,2,39,2],[36,3,39,3],[36,4,39,7],[40,2,42,2],[40,3,42,3],[40,4,42,7],[13,1,15,1],[13,2,15,2],[13,4,15,4],[28,1,34,1],[28,2,30,2],[28,3,30,3],[28,4,30,7],[31,2,34,2],[31,3,34,3],[31,4,34,7],[9,1,11,1],[9,2,11,2],[9,4,11,4],[3,5,3,6],[5,1,7,1],[5,2,7,2],[5,4,7,4]]}
[null,"RESUMEN DE ENERGÍA"]
[null,"Inversión Inicial (relativa a un entrante) Soles sin IGV"]
[null,"Sin sobrecosto del 15% (por replicar costos del entrante)"]
[{"$nulls":5},"Cálculos corregidos a capacidad instalada e información de Inversión detallada enviada en respuesta a requerimiento."]
[null,"ZONAS","TIPO","PRODUCTO","CONDICIONES TÉCNICAS DEL SITIO","INVERSIÓN INICIAL SOLES x KW","INVERSIÓN INCREMENTAL**"]
[null,"ZONA A y B","Edifico principal","Energía DC","- Edificios ubicados en centro de capitales de departamento. \n- Localidades con energía comercial las 24 hrs todo el año\n- Sitios sin problemas de siniestros en red de energía\n- Posible cortes programados no mayor a 4 hrs.\n- Salas con aire acondicionado y respaldo de grupo electrógeno.",{"$f":"'Inversión energía'!H45","v":28532.891772972445},{"$f":"'Inversión energía'!E45","v":300}]
[null,null,null,"Energía AC ",null,{"$f":"'Inversión energía'!H46","v":10055.794643222447},{"$f":"'Inversión energía'!E46","v":300}]
[null,null,null,"Energía AC Estabilizada",null,{"$f":"'Inversión energía'!H47","v":18786.255824222448},{"$f":"'Inversión energía'!E47","v":300}]
[]
[null,"ZONA C y D","Edifico URA","Energía DC","- Edificios ubicados en Centros Urbanos. \n- Localidades con energía comercial las 24 hrs todo el año\n- Sitios sin problemas de siniestros en red de energía\n- Posible cortes programados no mayor a 4 hrs.\n- Salas con aire acondicionado y respaldo de grupo electrógeno.",{"$f":"'Inversión energía'!H89","v":17780.700756805614},{"$f":"'Inversión energía'!E89","v":300}]
[null,null,null,"Energía AC ",null,{"$f":"'Inversión energía'!H90","v":5995.5827557389475},{"$f":"'Inversión energía'!E90","v":300}]
[null,null,null,"Energía AC Estabilizada",null,{"$f":"'Inversión energía'!H91","v":16099.652479738948},{"$f":"'Inversión energía'!E91","v":300}]
[]
[null,"ZONA E","Edifico remoto","Energía DC","- Edificios ubicados en Centros Poblados Rurales o cerros. \n- Localidades con energía comercial las 24 hrs todo el año\n- Sitios sin problemas de siniestros en red de energía\n- Posible cortes programados no mayor a 4 hrs.\n- Sólo edificios donde existe grupo electrógeno.\n- Facilidades de climatización sujeto a estudio especial.",{"$f":"'Inversión energía'!H133","v":22764.445758599999},{"$f":"'Inversión energía'!E133","v":300}]
[null,null,null,"Energía AC ",null,{"$f":"'Inversión energía'!H134","v":10795.1323536},{"$f":"'Inversión energía'!E134","v":300}]
[null,null,null,"Energía AC Estabilizada",null,{"$f":"'Inversión energía'!H135","v":19639.090875599999},{"$f":"'Inversión energía'!E135","v":300}]
[]
[null,"* La propuesta de TDP considera una inversión previsional estimada en base a 5 KW adicionales por cualquier riesgo operativo  (que no se considera), además de un componente de \"Estudios\"."]
[null,"** Corresponde al rubro \"Estudios\" (re-levantamiento de carga y potencia, acondicionamiento y tableros, línea acometida y toma a tierra y otros) que si se considera por ser una prestación real."]
[null,"Notas:"]
[null,"Energía AC :","Inversión en aire acondiciondo, sistema de posicionamiento a tierra, sala de energía (tableros, subtableros y cableado), grupo electrógeno y una subestación (acometida, celda y tablero). "]
[null,"Energía DC :","Los mismos que para energía AC + un cuadro de fuerza de 3000 A."]
[null,"Energía AC Estabilizada :","Los mismos que para energía AC + costo de la UPS (relativa a la potencia de los equipos)"]
[]
[]
[]
[null,"Definición Ubicaciones (revisado por OSIPTEL)"]
[]
[null,"EDIFICIO PRINCIPAL","MI","ZONA A","Barranco, La Molina, Miraflores, San Borja, San Isidro, Santiago de Surco."]
[]
[]
[null,null,"MII","ZONA B","Breña, Cercado de Lima, Chorrillos, Jesus Maria, Lince, Magdalena, Pueblo Libre, Rimac, San Miguel, Surquillo,Ate, Comas, El Agustino, La victoria, San Juan de Lurigancho, San Luis, San Martin de Porres, Villa Maria del Triunfo, Los Olivos"]
[]
[]
[]
[]
[null,"EDIFICIO URA","PI","ZONA C","Zonas urbanas de capitales de Departamento:Tumbes, Piura, Chiclayo, Trujillo, Chimbote, Ica , Arequipa, Moquegua, Tacna, Puno, Cusco, Apurímac, Ayacucho, Huancavelica, Huancayo, Pasco, Huanuco, San Martin, Amazonas, Cajamarca, Iquitos, Ucayali, Madre de Dios"]
[]
[]
[]
[null,null,"PII","ZONA D","El resto de provincias, Lunahuana"]
[]
[]
[]
[null,"EDIFICIO REMOTO","CER","ZONA E","Cerros Lima y Provincia"]

{"sheet":"Inversión energía","index":6,"n_rows":143,"n_cols":8,"rows_kept":143,"cut":false,"hidden":false,"merged":[[2,2,2,7],[50,2,50,7],[94,2,94,7]]}
[null,null,"Información sin sobrecosto del 15% (por replicar costos del entrante)"]
[null,null,"Información complementaria enviada mediante carta DR-107-C-0101-RE-13 (enviada el 29.01.2014)"]
["I.","CENTRALES (EDIFICIO PRINCIPAL) - Zona A y B","REVISIÓN OSIPTEL"]
[null,"CAPACIDAD INSTALADA",800,"Kw"]
[null,"CAPACIDAD EFECTIVA",612,"Kw",{"$f":"C5/C4","v":0.76500000000000001}]
[{"$nulls":5},"INVERSIÓN TOTAL"]
[{"$nulls":5},{"$f":"F10+F14+F18+F25+F28+F35+F41","v":2894139.27},"Montos con información detallada enviada en respuesta a requerimiento"]
[null,"INVERSIÓN",{"$nulls":4},"Kw"]
[1,"INVERSIÓN SUBESTACIÓN","Acometida","Transformador","Tableros 220V","Totales","Costo unitario"]
[null,"US$",{"$f":"'Detalle Ed.Principal'!C7","v":397543.24},{"$f":"'Detalle Ed.Principal'!C6","v":26461.72},{"$f":"'Detalle Ed.Principal'!C8","v":166425.60000000001},{"$f":"SUM(C10:E10)","v":590430.55999999994},{"$f":"F10/$C$5","v":964.75581699346401}]
[]
[]
[2,"GRUPO ELECTRÓGENO",null,null,null,"Totales","Costo unitario"]
[null,"US$",null,null,null,{"$f":"'Detalle Ed.Principal'!C13","v":600763.6},{"$f":"F14/$C$5","v":981.63986928104566}]
[]
[]
[3,"SALA DE ENERGÍA",null,null,null,"Totales","Costo unitario"]
[null,"US$",null,null,null,{"$f":"'Detalle Ed.Principal'!C15","v":235671.13},{"$f":"F18/$C$5","v":385.08354575163401}]
[]
[]
[4,"SISTEMA DE AIRE ACONDICIONADO"]
[null,"CAPACIDAD INSTALADA",150,"TR"]
[null,"CAPACIDAD EFECTIVA",406,"Kw"]
[{"$nulls":5},"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.Principal'!C21","v":585278.18000000005},{"$f":"F25/$C$23","v":1441.5718719211825}]
[]
[5,"SISTEMA DE PROTECCIÓN A TIERRA",null,null,null,"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.Principal'!C25","v":24129.88},{"$f":"F28/C5","v":39.42790849673203}]
[]
[null,"CUADROS DE FUERZA 3000A"]
[null,"CAPACIDAD DC",120,"Kw"]
[null,"CAPACIDAD EFECTIVA DC",96,"Kw",{"$f":"C32/C31","v":0.8}]
[]
[null,null,null,"Rectificador","Baterias","Totales","Costo unitario"]
[null,null,null,{"$f":"'Detalle Ed.Principal'!C18","v":505723.85},{"$f":"'Detalle Ed.Principal'!C19","v":166781.96},{"$f":"D35+E35","v":672505.80999999994},{"$f":"F35/$C$32","v":7005.2688541666657}]
[]
[null,"ENERGÍA ESTABLE"]
[null,"CAPACIDAD ESTABLE",70,"Kw"]
[null,"CAPACIDAD EFECTIVA",56,"Kw",{"$f":"C39/C38","v":0.8}]
[{"$nulls":5},"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.Principal'!C23","v":185360.11},{"$f":"F41/$C$39","v":3310.0019642857142}]
[]
[{"$nulls":4},"SOLES",null,"US$","SOLES"]
[null,"INVERSIÓN POR TIPO DE ENERGÍA",null,null,"Costo incremental*",null,"Costo unitario","Costo unitario"]
[null,"ENERGÍA DC",null,null,{"$f":"Energía!$L$43","v":300},null,{"$f":"G46+G35","v":10817.747866610724},{"$f":"G45*$C$143","v":28532.891772972445}]
[null,"ENERGÍA AC",null,null,{"$f":"Energía!$D$43","v":300},null,{"$f":"G10+G14+G18+G25+G28","v":3812.4790124440578},{"$f":"G46*$C$143","v":10055.794643222447}]
[null,"ENERGÍA AC Estabilizada",null,null,{"$f":"Energía!$T$43","v":300},null,{"$f":"G46+G41","v":7122.480976729772},{"$f":"G47*$C$143","v":18786.255824222448}]
[]
[null,"* Estudios y re-levantamiento de carga y potencia, acondicionamiento y tableros, línea acometida y toma a tierra y otros."]
[]
["II.","EDIFICIO URA - Zona C y D","REVISIÓN OSIPTEL"]
[null,"CAPACIDAD INSTALADA",250,"Kw"]
[null,"CAPACIDAD EFECTIVA",190,"Kw",{"$f":"C53/C52","v":0.76}]
[{"$nulls":5},"INVERSIÓN TOTAL"]
[{"$nulls":5},{"$f":"F58+F62+F69+F72+F79+F85","v":592557.7699999999},"Montos con información detallada enviada en respuesta a requerimiento"]
[null,"INVERSIÓN",{"$nulls":4},"Kw"]
[1,"SUMINISTRO","Acometida","Transformador","Tableros 220V","Totales","Costo unitario"]
[null,"US$",{"$f":"'Detalle Ed.URA'!$C$7","v":60035.3},{"$f":"'Detalle Ed.URA'!$C$6","v":8066.23},{"$f":"'Detalle Ed.URA'!$C$8","v":30980.44},{"$f":"SUM(C58:E58)","v":99081.97},{"$f":"F58/C53","v":521.48405263157895}]
[]
[]
[2,"GRUPO ELECTRÓGENO",null,null,null,"Totales","Costo unitario"]
[null,"US$",null,null,null,{"$f":"'Detalle Ed.URA'!$C$14","v":144691.31},{"$f":"F62/C53","v":761.53321052631577}]
[]
[]
[3,"SISTEMA DE AIRE ACONDICIONADO"]
[null,"CAPACIDAD INSTALADA",40,"TR"]
[null,"CAPACIDAD EFECTIVA",100,"Kw"]
[{"$nulls":5},"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.URA'!$C$20","v":95966.66},{"$f":"F69/C67","v":959.66660000000002}]
[]
[4,"SISTEMA DE PROTECCIÓN A TIERRA",null,null,null,"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.URA'!$C$24","v":5782.97},{"$f":"F72/C53","v":30.436684210526316}]
[]
[null,"CUADROS DE FUERZA 1500A"]
[null,"CAPACIDAD DC",60,"Kw"]
[null,"CAPACIDAD EFECTIVA DC",45,"Kw",{"$f":"C76/C75","v":0.75}]
[]
[null,null,null,"Rectificador","Baterias","Totales","Costo unitario"]
[null,null,null,{"$f":"'Detalle Ed.URA'!$C$17","v":100199},{"$f":"'Detalle Ed.URA'!$C$18","v":100866.48},{"$f":"D79+E79","v":201065.47999999998},{"$f":"F79/C76","v":4468.1217777777774}]
[]
[null,"ENERGÍA ESTABLE"]
[null,"CAPACIDAD ESTABLE",15,"Kw"]
[null,"CAPACIDAD EFECTIVA",12,"Kw",{"$f":"C83/C82","v":0.8}]
[null,null,"UPS","Costo unitario",null,"Totales","Costo unitario"]
[null,null,40000,4000,null,{"$f":"'Detalle Ed.URA'!$C$22","v":45969.38},{"$f":"F85/C83","v":3830.7816666666663}]
[null,null,null,{"$f":"C85/D85","v":10},"Kw"]
[{"$nulls":4},"SOLES",null,"US$","SOLES"]
[null,"INVERSIÓN POR TIPO DE ENERGÍA",null,null,"Costo incremental*",null,"Costo unitario","Costo unitario"]
[null,"ENERGÍA DC",null,null,{"$f":"Energía!$L$43","v":300},null,{"$f":"G90+G79","v":6741.2423251461987},{"$f":"G89*$C$143","v":17780.700756805614}]
[null,"ENERGÍA AC",null,null,{"$f":"Energía!$D$43","v":300},null,{"$f":"G58+G62+G69+G72","v":2273.1205473684213},{"$f":"G90*$C$143","v":5995.5827557389475}]
[null,"ENERGÍA AC Estabilizada",null,null,{"$f":"Energía!$T$43","v":300},null,{"$f":"G90+G85","v":6103.902214035088},{"$f":"G91*$C$143","v":16099.652479738948}]
[]
[null,"* Estudios y re-levantamiento de carga y potencia, acondicionamiento y tableros, línea acometida y toma a tierra y otros."]
[]
["III.","EDIFICIO REMOTO - Zona E","REVISIÓN OSIPTEL"]
[null,"CAPACIDAD INSTALADA",25,"Kw"]
[null,"CAPACIDAD EFECTIVA",19,"Kw",{"$f":"C97/C96","v":0.76}]
[{"$nulls":5},"INVERSIÓN TOTAL"]
[{"$nulls":5},{"$f":"F102+F106+F113+F116+F123+F129","v":107764.39000000001},"Montos con información detallada enviada en respuesta a requerimiento"]
[null,"INVERSIÓN",{"$nulls":4},"Kw"]
[1,"SUMINISTRO","Acometida","Transformador","Tableros 220V","Totales","Costo unitario"]
[null,"US$",{"$f":"'Detalle Ed.Remoto'!$C$7","v":7019.55},{"$f":"'Detalle Ed.Remoto'!$C$6","v":2053.1799999999998},{"$f":"'Detalle Ed.Remoto'!$C$8","v":2937.53},{"$f":"SUM(C102:E102)","v":12010.26},{"$f":"F102/C97","v":632.11894736842112}]
[]
[]
[2,"GRUPO ELECTRÓGENO",null,null,null,"Totales","Costo unitario"]
[null,"US$",null,null,null,{"$f":"'Detalle Ed.Remoto'!$C$12","v":36531.440000000002},{"$f":"F106/C97","v":1922.7073684210527}]
[]
[]
[3,"VENTILACIÓN FORZADA"]
[null,"CAPACIDAD INSTALADA",2,"TR"]
[null,"CAPACIDAD EFECTIVA",5,"Kw"]
[{"$nulls":5},"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.Remoto'!$C$18","v":7040.83},{"$f":"F113/C111","v":1408.1659999999999}]
[]
[4,"SISTEMA DE PROTECCIÓN A TIERRA",null,null,null,"Totales","Costo unitario"]
[{"$nulls":5},{"$f":"'Detalle Ed.Remoto'!$C$22","v":2466.08},{"$f":"F116/C97","v":129.79368421052632}]
[]
[null,"CUADROS DE FUERZA 300A"]
[null,"CAPACIDAD DC",10,"Kw"]
[null,"CAPACIDAD EFECTIVA DC",8,"Kw",{"$f":"C120/C119","v":0.8}]
[]
[null,null,null,"Rectificador","Baterias","Totales","Costo unitario"]
[null,null,null,{"$f":"'Detalle Ed.Remoto'!$C$15","v":14476},{"$f":"'Detalle Ed.Remoto'!$C$16","v":21827.65},{"$f":"D123+E123","v":36303.65},{"$f":"F123/C120","v":4537.9562500000002}]
[]
[null,"ENERGÍA ESTABLE"]
[null,"CAPACIDAD ESTABLE",5,"Kw"]
[null,"CAPACIDAD EFECTIVA",4,"Kw",{"$f":"C127/C126","v":0.8}]
[null,null,"UPS","Costo unitario",null,"Totales","Costo unitario"]
[null,null,12000,3600,null,{"$f":"'Detalle Ed.Remoto'!$C$20","v":13412.13},{"$f":"F129/C127","v":3353.0324999999998}]
[null,null,null,{"$f":"C129/D129","v":3.3333333333333335},"Kw"]
[{"$nulls":4},"SOLES",null,"US$","SOLES"]
[null,"INVERSIÓN POR TIPO DE ENERGÍA",null,null,"Costo incremental*",null,"Costo unitario","Costo unitario"]
[null,"ENERGÍA DC",null,null,{"$f":"Energía!$L$43","v":300},null,{"$f":"G134+G123","v":8630.7422499999993},{"$f":"G133*$C$143","v":22764.445758599999}]
[null,"ENERGÍA AC",null,null,{"$f":"Energía!$D$43","v":300},null,{"$f":"G102+G106+G113+G116","v":4092.7860000000001},{"$f":"G134*$C$143","v":10795.1323536}]
[null,"ENERGÍA AC Estabilizada",null,null,{"$f":"Energía!$T$43","v":300},null,{"$f":"G134+G129","v":7445.8184999999994},{"$f":"G135*$C$143","v":19639.090875599999}]
[]
[null,"* Estudios y re-levantamiento de carga y potencia, acondicionamiento y tableros, línea acometida y toma a tierra y otros."]
[null,"Notas:"]
[null,"Energía AC :","Inversión en aire acondiciondo, sistema de posicionamiento a tierra, sala de energía (tableros, subtableros y cableado), grupo electrógeno y una subestación (acometida, celda y tablero). "]
[null,"Energía DC :","Los mismos que para energía AC + un cuadro de fuerza de 3000 A."]
[null,"Energía AC Estabilizada :","Los mismos que para energía AC + costo de la UPS (relativa a la potencia de los equipos)"]
[]
[null,"TC =",{"$f":"Parámetros!H9","v":2.6375999999999999},"Fuente: SBS"]

{"sheet":"Detalle Ed.Principal","index":7,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"COSTO US$ SIN IGV"]
[null,"INVERSIÓN EDIFICIO PRINCIPAL",{"$f":"C5+C13+C15+C17+C21+C23+C25","v":2894139.27},{"$nulls":9},"RESUMEN INVERSIÓN EDIFICIO PRINCIPAL"]
[null,"ELEMENTOS:",{"$nulls":9},"N°","ELEMENTOS:","COSTO US$ SIN IGV"]
[{"$nulls":11},1,{"$f":"B5","v":"SUBESTACIÓN"},{"$f":"C5","v":590430.55999999994}]
[1,"SUBESTACIÓN",{"$f":"SUM(C6:C8)","v":590430.55999999994},{"$nulls":8},2,{"$f":"B13","v":"GRUPO ELECTRÓGENO"},{"$f":"C13","v":600763.6}]
[null,"Transformador 800 Kw 10/0.22 Kv - interior",26461.72,{"$nulls":8},3,{"$f":"B15","v":"SALA DE ENERGÍA Y TABLEROS"},{"$f":"C15","v":235671.13}]
[null,"Acometida Electrica - 10 Kv",397543.24,{"$nulls":8},4,{"$f":"B17","v":"PLANTA DE FUERZA"},{"$f":"C17","v":672505.80999999994}]
[null,"Tableros - 220 V",166425.60000000001,{"$nulls":8},5,{"$f":"B21","v":"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO"},{"$f":"C21","v":585278.18000000005}]
[{"$nulls":11},6,{"$f":"B23","v":"ENERGÍA ESTABLE - SISTEMA UPS"},{"$f":"C23","v":185360.11}]
[{"$nulls":11},7,{"$f":"B25","v":"SISTEMA A TIERRA"},{"$f":"C25","v":24129.88}]
[{"$nulls":13},{"$f":"SUM(N4:N10)","v":2894139.27}]
[]
[2,"GRUPO ELECTRÓGENO",600763.6]
[]
[3,"SALA DE ENERGÍA Y TABLEROS",235671.13]
[]
[4,"PLANTA DE FUERZA",{"$f":"C18+C19","v":672505.80999999994}]
[null,"Sistema de Rectificador",505723.85]
[null,"Bancos de Baterias",166781.96]
[]
[5,"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO",585278.18000000005]
[]
[6,"ENERGÍA ESTABLE - SISTEMA UPS",185360.11]
[]
[7,"SISTEMA A TIERRA",24129.88]

{"sheet":"Detalle Ed.URA","index":8,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,null,"COSTO US$ SIN IGV"]
[null,"INVERSIÓN EDIFICIO URA",{"$f":"C5+C14+C16+C20+C22+C24","v":592557.77},{"$nulls":10},"RESUMEN INVERSIÓN EDIFICIO URA"]
[null,"ELEMENTOS:",{"$nulls":10},"N°","ELEMENTOS:","COSTO US$ SIN IGV"]
[{"$nulls":12},1,{"$f":"B5","v":"SUMINISTRO DE ENERGÍA"},{"$f":"C5","v":99081.97}]
[1,"SUMINISTRO DE ENERGÍA",{"$f":"SUM(C6:C8)","v":99081.97},{"$nulls":9},2,{"$f":"B14","v":"GRUPO ELECTRÓGENO"},{"$f":"C14","v":144691.31}]
[null,"Transformador 10/0.22 Kv - interior",8066.23,{"$nulls":9},3,{"$f":"B16","v":"PLANTA DE FUERZA"},{"$f":"C16","v":201065.47999999998}]
[null,"Acometida Electrica - 10 Kv",60035.3,{"$nulls":9},4,{"$f":"B20","v":"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO"},{"$f":"C20","v":95966.66}]
[null,"Tableros - 220 V",30980.44,{"$nulls":9},5,{"$f":"B22","v":"ENERGÍA ESTABLE - SISTEMA UPS"},{"$f":"C22","v":45969.38}]
[{"$nulls":12},6,{"$f":"B24","v":"SISTEMA A TIERRA"},{"$f":"C24","v":5782.97}]
[{"$nulls":14},{"$f":"SUM(O4:O9)","v":592557.77}]
[]
[]
[]
[2,"GRUPO ELECTRÓGENO",144691.31]
[]
[3,"PLANTA DE FUERZA",{"$f":"C17+C18","v":201065.47999999998}]
[null,"Sistema de Rectificador",100199]
[null,"Bancos de Baterias",100866.48]
[]
[4,"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO",95966.66]
[]
[5,"ENERGÍA ESTABLE - SISTEMA UPS",45969.38]
[]
[6,"SISTEMA A TIERRA",5782.97]

{"sheet":"Detalle Ed.Remoto","index":9,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,"COSTO US$ SIN IGV"]
[null,"INVERSIÓN EDIFICIO REMOTO",{"$f":"C5+C12+C14+C18+C20+C22","v":107764.39000000001},{"$nulls":11},"RESUMEN INVERSIÓN EDIFICIO REMOTO"]
[null,"ELEMENTOS:",{"$nulls":11},"N°","ELEMENTOS:","COSTO US$ SIN IGV"]
[{"$nulls":13},1,{"$f":"B5","v":"PLANTA DE ENERGÍA"},{"$f":"C5","v":12010.26}]
[1,"PLANTA DE ENERGÍA",{"$f":"SUM(C6:C8)","v":12010.26},{"$nulls":10},2,{"$f":"B12","v":"GRUPO ELECTRÓGENO"},{"$f":"C12","v":36531.440000000002}]
[null,"Transformador 10/0.22 Kv - interior",2053.1799999999998,{"$nulls":10},3,{"$f":"B14","v":"PLANTA DE FUERZA"},{"$f":"C14","v":36303.65}]
[null,"Acometida Electrica - 10 Kv",7019.55,{"$nulls":10},4,{"$f":"B18","v":"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO"},{"$f":"C18","v":7040.83}]
[null,"Tableros - 220 V",2937.53,{"$nulls":10},5,{"$f":"B20","v":"ENERGÍA ESTABLE - SISTEMA UPS"},{"$f":"C20","v":13412.13}]
[{"$nulls":13},6,{"$f":"B22","v":"SISTEMA A TIERRA"},{"$f":"C22","v":2466.08}]
[{"$nulls":15},{"$f":"SUM(P4:P9)","v":107764.39000000001}]
[]
[2,"GRUPO ELECTRÓGENO",36531.440000000002]
[]
[3,"PLANTA DE FUERZA",{"$f":"C15+C16","v":36303.65}]
[null,"Sistema de Rectificador",14476]
[null,"Bancos de Baterias",21827.65]
[]
[4,"CLIMATIZACIÓN - SISTEMA DE AIRE ACONDICIONADO",7040.83]
[]
[5,"ENERGÍA ESTABLE - SISTEMA UPS",13412.13]
[]
[6,"SISTEMA A TIERRA",2466.08]