{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Vivienda","Resumen","Consumo eléctrico","Consumo de Gas","Transporte","Tabla 1y2","Consumos_Carct._2023","Consumos","Heladera"],"not_rendered":{"charts":60,"images":20,"macros":1,"external_links":6,"defined_names":88,"comments":3,"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":"Vivienda","index":0,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
["2024-03-01",null,"Por favor llenar solo  los casilleros en Azul con fondo Verde",null,null,null,null,null,null,null,null,1,"Si"]
[null,null,null,null,null,null,null,null,null,null,null,2,"No",null,null,"Poner Su factura de Electricidad  Aqui"]
[null,"Por favor llenar solo  los casilleros en Azul con fondo Verde",null,null,null,null,null,null,null,null,null,3,"Gas"]
[null,null,null,null,"Moradores de la vivienda:"," Nombre",null,"Auditoria de Consumo",null,null,null,4,"Electricidad",null,null,"Annual",{"$f":"SUM(Q6:Q12)","v":2017},"kWh"]
["Auditor o Resposable: ",null,"  Su Nombre",null,"e-mail(morador):","mail@unsam.edu.ar",null,"Las celdas con este color se puede modificar",null,null,null,null,"Garrafa"]
["e:mail:",null,"mail@unsam.edu.ar",null,"Cel: (morador):","54911 42401 xxxx",null,"Las otras NO las modifique por favor",null,null,null,null,"A",null,null,"18/05",346]
["Fecha de ensayo:",null,"2016-02-01",null,"Superficie Cubierta (m2)",67,"Area total de la vivienda",null,null,null,null,null,"B",null,null,"18/06",268]
[null,null,null,null,"Superficie Cubierta Efectiva(m2)",60,"Area en la que se usa cafefacción y refrigeración"]
["Tipo de vivienda (casa/Dpto)?",null,"Casa","Casa/Dpto","Número de personas en la Vivienda",4,null,null,null,null,"Estimación del consumo de coccion -Cocina Electrica",null,null,null,null,"19/01",294]
["La vivienda se usa en forma regular todo  el año",null,null,"Si","Direccion","Italia xxx",null,1,"Alto",null,null,null,null,null,null,"19/02",282]
["Se toman vacaciones , cuantos dias al año",null,null,"NN","Localidad:","Su Lugar",null,2,"medio",null,null,"N_pers.=",{"$f":"+n_pers","v":4},null,null,"19/03",365]
[null,null,null,null,null,null,null,3,"bajo",null,"Gas","Consumo=",{"$f":"3.3*n_pers/3","v":4.3999999999999995},"kWh/día",null,"19/04",462]
["La vivienda tiene coneccion a la red de gas natural?",null,null,"Si","Condicion Socioecónomica","alta/media/baja",2,4,"muy bajo/sin medidor/Enganchado",null,"EE","Consumo=",{"$f":"3*n_pers/3","v":4},"kWh/día"]
[null,null,null,null,"Clase","B","A","Con gas por redes",null,null,"Induc.","Consumo=",{"$f":"2.6*n_pers/3","v":3.4666666666666668},"kWh/día",null,"19/05",400]
["La vivienda tiene agua caliente sanitaria?",null,null,"Si","Clase+Cond. Socieconomica",{"$f":"+F14&G13","v":"B2"},"B","Sin gas por redes"]
[]
["La vivienda tiene calefon o termotange a gas?",null,null,"TERMO","Termo/Calefón","Fecha Fabricacion Aprox.",null,null,"Estimación del consumo de ACS con Termotanque Electrico"]
["Si tiene termotanque cuál es su Volumne  Aprox. En Litros",null,null,45,null,{"$f":"2022-D19","v":2019},null,null,"Termotanque Electrico",null,null,"Calefón Electrico"]
["Si tiene termotanque o Calefón, cual es su antiguedad Aprox.",null,null,3,"años",null,null,null,"DT",25,"N_pers.=",{"$f":"+n_pers","v":4}]
["La vivienda tiene mas de un calefon o termotange a gas?",null,null,"Si",null,null,null,null,"Etiqueta de Eficiencia","A","D","Celfon_EE"]
["El calefon  tiene llama piloto?",null,null,null,"Electrico",null,null,null,"V0=",80,80,30]
["Cuantos pilotos encendido tiene?",null,null,1,null," ",null,null,"Q0_mant=",0.95,2.5,0,"kWh/día"]
["Estufas (Número de estufas a gas)",null,null,2,null,null,null,null,"V=",{"$f":"+D18","v":45},{"$f":"+J23","v":45},null,"kWh/día",null,null,"Poner Su factura de gas Aqui"]
["Estufas a gas (Potencia  Total)",null,null,3000,"kcal/hora",null,null,null,"Q_mant=",{"$f":"+$J22*(J23/$J21)^0.667","v":0.64722506925951551},{"$f":"+$K22*(K23/$K21)^0.667","v":1.7032238664724093},0,"kWh/día"]
[null,null,null,null,null,null,null,null,"Eff=",0.95,0.92,{"$f":"+K25","v":0.92},null,null,null,null,"Annual=",{"$f":"+SUM(R28:R33)","v":727.90000000000009}]
[null,null,null,null,null,null,null,null,"Q(kcal/d)=",{"$f":"+$J$19*$L$19*45/J$25","v":4736.8421052631584},{"$f":"+$J$19*$L$19*45/K$25","v":4891.304347826087},{"$f":"+$J$19*$L$19*45/L$25","v":4891.304347826087}]
["Si usa gas en garrafa, ",null,null,"No",null,null,null,null,"Q(kWh/d)=",{"$f":"+J26*10.8/9300","v":5.5008488964346363},{"$f":"+K26*10.8/9300","v":5.6802244039270695},{"$f":"+L26*10.8/9300","v":5.6802244039270695}]
["cuantas garrafas de 10 kg usa al año para cocinar?",null,null,10,null,null,null,null,"Q_tot (kWh/día)=",{"$f":"+J27+J24","v":6.1480739656941514},{"$f":"+K27+K24","v":7.3834482703994784},{"$f":"+L27+L24","v":5.6802244039270695},"kWh/día",null,null,1,"21/5",162.22]
["cuantas garrafas de 10 kg usa para Calefacción.?",null,null,"xx",null,null,null,null,"Q_tot (kWh/año)=",{"$f":"+J28*365","v":2244.0469974783655},{"$f":"+K28*365","v":2694.9586186958095},{"$f":"+L28*365","v":2073.2819074333802},"kWh/año",null,null,2,"21/6",166.5]
["cuantas garrafas de 10 kg usa al año para Agua Calient. San.?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"22/1",101.11]
[null,null,"Coccion",{"$f":"10*D28","v":100},"kg/Año",null,null,null,null,null,null,null,null,null,null,4,"22/2",75.13]
[null,null,null,{"$f":"+D33*10.8","v":1206.3600000000001},"kWh/año",null,null,null,null,null,null,null,null,null,null,5,"22/3",100.37]
[null,null,null,{"$f":"+D31*1.117","v":111.7},"m3 (eq)/año",null,null,null,null,null,null,null,null,null,null,6,"22/4",122.57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"22/5",181.67]
[null,"Incluir fotos"]
[]
[null,"Estufas",null,"Calefones y/o Temotanques y/o Caldera",null,"Cocina","Heldera",null,"Heladera Etiqueta",null,null,"Aire Acond. 1",null,"Aire Acond. 1 Etiqueta",null,"Aire Acond. 2","Aire Acond. 1 Etiqueta",null,"Aire Acond. 3","Aire Acond. 1 Etiqueta"]

{"sheet":"Resumen","index":1,"n_rows":74,"n_cols":79,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,68,1,71]]}
[{"$f":"+$B$2&E2&\"Viviendas con Conex. A G.N.\"","v":"Resumen de 283Viviendas con Conex. A G.N."},null,null,null,null,{"$f":"+F2","v":"Viviendas Con Conexión a redes de gas Natural"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F$1","v":"Viviendas Con Conexión a redes de gas Natural"},null,null,null,null,{"$f":"+$F$1","v":"Viviendas Con Conexión a redes de gas Natural"},null,null,null,"Consumo domestcio de GN AMBA =",null,null,{"$f":"+AB1&ROUND(AI4,0)&\" m3/año\"","v":"Consumo domestcio de GN AMBA =1168 m3/año"},null,null,{"$f":"+$F$1","v":"Viviendas Con Conexión a redes de gas Natural"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F$1","v":"Viviendas Con Conexión a redes de gas Natural"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.29699999999999999,0.20200000000000001,0.26700000000000002,null,null,null,null,{"$f":"+AC4","v":1378.1080522340469},{"$f":"+AD4","v":2617.4226856431542},2299.837307108095,6314.0154257341883]
[null,"Resumen de ",null,"N=",283,"Viviendas Con Conexión a redes de gas Natural",null,null,null,null,null,null,"Viviendas Con Conexción a redes de gas Natural",null,null,null,null,null,null,"Viviendas Con Connexción a redes de gas Natural",null,null,null,null,null,null,"Viviendas Con Connexción a redes de gas Natural",null,null,null,null,null,null,"Viviendas Con Connexción a redes de gas Natural",null,null,null,null,"MWh/año","MWh/año","Viviendas Con Connexción a redes de gas Natural",null,null,null,null,null,null,null,null,"Calef.T. (kWh)","Refrig.T (kWh)",null,"Calf/m2",null,null,"EE/N_pers",null,null,null,"MWh/año","MWh/año","Tn(CO2)/año","Tn(CO2)/año","Tn(CO2)/año","Tn(CO2)/año","Emisiones",null,null,"Análisis Bottom Up"]
["Resumen Historico",null,"A",null,"# Persona",null,"Sup (m2)",null,"# Heladeras","Heladera","Lavarropa","Ilumin.","AA-Cal+Ref.","Cale.EE.","Microonda","Cafetera","TV+Electr.","Inform.","Stand By","Planch.","Bomba","Secador P.","HornoE","ACS_E","Cocina_EE","otros","Extra","Todo Electicidad","Cocción","ACS","Piloto","Calefacción","Otro_gas","TOTAL_GAS","Gas (m3)","kWh/ano",null,null,"Electr.","Gas","Total Cocina ","Heladera","ACS ","Acond.Term","Casa_Electr","Otros","Todo","ACS/per","Elect.Casa/Pers","Calef.T.","Refrig.T ","Ac.Term/m2","Calf/m2","Cocina T./pers","kg(CO2)/m2","EE/N_pers","ACS/Pers","%AA","%AA_Calef","Transp","Total","Electr.","Gas","Transp","Total","Electr+Gas","Electr+Gas",null,null,"m3/año","MWh/año","m3/día"]
["Viviendas con coneccion a redes de GN",null,null,{"$f":"+AB4","v":3343.91346969912},3.2348754448398576,"Promedio",90,null,1.5567199999999999,840.70891731918391,107.12518666617173,282.94639130171015,807.95201114135295,701.29129189316052,105.88516630411523,144.95630749194052,235.97288592619219,273.11938680774642,99.146301735561337,90.330095984400671,206.49924995553943,59.081648561235717,325.15638762263734,1088.7027754166666,0,309.88793771892631,1069.3142068627451,3343.91346969912,1378.1080522340469,2617.4226856431542,2299.837307108095,6314.0154257341883,4474.2235416666526,{"$f":"+SUM(AC4:AF4)","v":12609.383470719484},{"$f":"+AH4/10.8","v":1167.5355065481003},{"$f":"+AB4+AH4","v":15953.296940418604},null,null,{"$f":"+AB4/1000","v":3.3439134696991202},{"$f":"+AH4/1000","v":12.609383470719484},{"$f":"+AC4+W4+P4+O4","v":1954.1059136527401},{"$f":"+J4","v":840.70891731918391},{"$f":"+AD4+AE4","v":4917.2599927512492},{"$f":"+M4+N4+AF4","v":7823.258728768702},{"$f":"+K4+L4+SUM(Q4:V4)","v":1354.2211469385577},{"$f":"+Z4+AA4","v":1379.2021445816713},{"$f":"SUM(AO4:AT4)","v":18268.756844012103},{"$f":"+IF(E4>0,AQ4/E4,AQ4/2.3)","v":1520.0770714665578},{"$f":"+IF(E4>0,AS4/E4,AS4/2.3)","v":418.63161968067624},{"$f":"+AF4+N4+M4*0.667","v":7554.2107090586314},{"$f":"+M4*0.333","v":269.04801971007055},{"$f":"+IF(G4>0,AR4/G4,AR4/65)","v":86.925096986318906},{"$f":"+(AF4+N4+M4*0.667)/G4","v":83.935674545095907},{"$f":"+IF(E4>0,AO4/E4,AO4/2.3)","v":604.07454536459841},{"$f":"+((M4+N4)*$BK$5+AF4*$BL$5)/G4","v":37.298149026102855},{"$f":"+(K4+L4+SUM(Q4:V4))/E4","v":418.63161968067624},{"$f":"+AQ4/E4","v":1520.0770714665578},{"$f":"+M4/AR4","v":0.10327563476460865},{"$f":"+(AF4+AM4*0.66)/AX4","v":0.83611943747479689},null,{"$f":"SUM(AO4:AT4)/1000","v":18.268756844012103},{"$f":"+BJ$1*AM4","v":0.99314230050063868},{"$f":"+BK$1*AN4","v":2.5470954610853358},{"$f":"+BL$1*BH4","v":0},{"$f":"+SUM(BJ4:BL4)","v":3.5402377615859746},{"$f":"+BJ4+BK4","v":3.5402377615859746},3.0821051704949758,null,"Cocción",{"$f":"+BQ1/10.8","v":127.60259742907841},{"$f":"+BQ1/1000","v":1.378108052234047},{"$f":"+BR4/365","v":0.34959615733994087}]
[{"$f":"+$D$30&\"=\"& ROUND(D5/1000,2)&\" \"&$F$30&\" Con GN\"","v":"Total Electr.=2.9 MWh/año Con GN"},null,"Electrico",{"$f":"+AB5","v":2900.1199999999994},{"$f":"+E4","v":3.2348754448398576},"Mediana",85,null,1,711.02,49.788591720779223,164.25,465.9,480,69.958333333333329,56.270833333333329,180.67500000000001,183.34950000000003,61.319999999999993,45,108.75,23.327999999999999,179.14,614.84249999999997,0,112.17666666666666,40.880000000000003,2900.1199999999994,1263.0557333333293,2455.767480833325,2170.8770416666603,5121.1070516666514,4474.2235416666526,{"$f":"+SUM(AC5:AF5)","v":11010.807307499967},{"$f":"+AH5/10.8","v":1019.5191951388857},{"$f":"+AB5+AH5","v":13910.927307499966},null,null,{"$f":"+AB5/1000","v":2.9001199999999994},{"$f":"+AH5/1000","v":11.010807307499967},{"$f":"+AC5+Y5+W5+P5+O5","v":1568.4248999999959},{"$f":"+J5","v":711.02},{"$f":"+AD5+AE5","v":4626.6445224999852},{"$f":"+M5+N5+AF5","v":6067.007051666651},{"$f":"+K5+L5+SUM(Q5:V5)","v":816.46109172077922},{"$f":"+Z5+AA5","v":153.05666666666667},{"$f":"SUM(AO5:AT5)","v":13942.614232554079},{"$f":"+IF(E5>0,AQ5/E5,AQ5/2.3)","v":1430.2388457893244},{"$f":"+IF(E5>0,AS5/E5,AS5/2.3)","v":252.39336278717158},{"$f":"+AF5+N5+M5*0.667","v":5911.8623516666512},{"$f":"+M5*0.333","v":155.1447},{"$f":"+IF(G5>0,AR5/G5,AR5/65)","v":71.37655354901942},{"$f":"+(AF5+N5+M5*0.667)/G5","v":69.551321784313544},{"$f":"+IF(E5>0,AO5/E5,AO5/2.3)","v":484.84862145214396},{"$f":"+((M5+N5)*$BK$5+AF5*$BL$5)/G5","v":24.751232608202024},{"$f":"+(K5+L5+SUM(Q5:V5))/E5","v":252.39336278717158},{"$f":"+AQ5/E5","v":1430.2388457893244},{"$f":"+M5/AR5","v":7.6792394673748376E-2},{"$f":"+AF5/AX5","v":0.86624260631219319},null,{"$f":"SUM(AO5:AT5)/1000","v":13.942614232554078},{"$f":"+BJ$1*AM5","v":0.86133563999999974},{"$f":"+BK$1*AN5","v":2.2241830761149934},{"$f":"+BL$1*BH5","v":0},{"$f":"+SUM(BJ5:BL5)","v":3.0855187161149931},{"$f":"+BJ5+BK5","v":3.0855187161149931},3.0821051704949758,null,"ACS",{"$f":"+BR1/10.8","v":242.35395237436612},{"$f":"+BR1/1000","v":2.6174226856431542},0.66398343116264691]
[{"$f":"+$A$29&ROUND(G6,0)&\" kWh/m2.año\"","v":"Acond.Term.=87 kWh/m2.año"},null,null,{"$f":"+AB4+AH4","v":15953.296940418604},null,"AT/m2=",{"$f":"+AZ4","v":86.925096986318906},"kWh/m2/año",{"$f":"+I4","v":1.5567199999999999},{"$f":"+J4","v":840.70891731918391},{"$f":"+K4","v":107.12518666617173},282.94639130171015,807.95201114135295,701.29129189316052,105.88516630411523,144.95630749194052,235.97288592619219,273.11938680774642,99.146301735561337,90.330095984400671,206.49924995553943,59.081648561235717,325.15638762263734,1088.7027754166666,0,309.88793771892631,1069.3142068627451,null,1378.1080522340469,2617.4226856431542,2299.837307108095,6314.0154257341883,null,null,null,{"$f":"+SUM(AC6:AF6)+AB7","v":17978.257474847098},null,null,null,"Con GN",{"$f":"+AO4","v":1954.1059136527401},840.70891731918391,4917.2599927512492,7823.258728768702,1354.2211469385577,1379.2021445816713,18268.756844012103,1520.0770714665578,418.63161968067624,7554.2107090586314,269.04801971007055,86.925096986318906,83.935674545095907,604.07454536459841,37.298149026102855,418.63161968067624,1520.0770714665578,null,null,null,null,null,null,null,null,null,null,null,"Pasivo",{"$f":"BS1/10.8","v":212.94789880630509},{"$f":"+BS1/1000","v":2.2998373071080951},0.58341890083919201]
[{"$f":"+$F$29&ROUND(G7*100,1)&\" % \"","v":"Porc. BC.=10.3 % "},null,null,null,null,"Porc. BC.=",{"$f":"+BF4","v":0.10327563476460865},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(J6:X6)","v":5368.8740041276142},null,{"$f":"+(AD4/10.8)*9300*0.75/(25*365)","v":185.25137729437847},{"$f":"+AI7&ROUND(AD7,0)&\" l/día/pers.\"","v":"Cons.de Agua Calient./pers.=185 l/día/pers."},null,null,null,"Cons.de Agua Calient./pers.=",null,null,null,null,"Sin GN",{"$f":"+AO14","v":1900.4628721562353},{"$f":"+AP14","v":909.08126418887366},2316.4262769230772,1753.5065421520021,775.81893434960625,157.93113240656794,7813.2270221763629,591.57963379881664,198.13222015697639,1554.1206318390809,199.38591031292103,19.839233147929207,17.583374121446461,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calefacción",{"$f":"+BT1/10.8","v":584.63105793835075},{"$f":"+BT1/1000","v":6.3140154257341887},{"$f":"+BR7/365","v":1.6017289258584952}]
[{"$f":"+$D$31&\"=\"& ROUND(D8/1000,2)&\" \"&$F$31&\" Con GN\"","v":"Total Gas+Electr.=15.95 MWh/año Con GN"},null,"Todos",{"$f":"+AB4+AH4","v":15953.296940418604},null,"Calef/m2",{"$f":"+BA4","v":83.935674545095907},"kWh/m2/año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(J4:W4)+Z4","v":4590.0591664298736},{"$f":"+SUM(J4:W4)+Z4","v":4590.0591664298736},null,null,null,null,null,{"$f":"+SUM(AC4:AF4)","v":12609.383470719484},null,null,null,null,null,null,"Total Cocina ","Heladera","ACS ","Acond.Term","Casa_Electr","Otros","Todo","ACS/per","Elect.Casa/Pers","Calef.T.","Refrig.T ","Ac.Term/m2","Calf/m2","Cocina T./pers","kg(CO2)/m2","EE/N_pers","ACS/Pers","%AA","%AA_Calef","Transp","Total","Electr.","Gas","Transp","Total","Electr+Gas","Electr+Gas",null,"Total",{"$f":"+SUM(BR4:BR7)","v":1167.5355065481003},{"$f":"+SUM(BS4:BS7)","v":12.609383470719486},3.1987274152002749]
[]
[{"$f":"+$B$2&D11&\"Viviendas sin Conex. a G.N.\"","v":"Resumen de 105Viviendas sin Conex. a G.N."},null,null,null,{"$f":"+D11","v":105},"Viviendas Sin  Conexión a redes de Gas Natural",null,null,null,null,null,null,null,null,"Viviendas Sin  Conexción a redes de Gas Natural",null,null,null,null,null,null,null,null,"Viviendas Sin  Conexción a redes de Gas Natural",null,null,null,null,null,null,null,null,"Viviendas Sin  Conexción a redes de Gas Natural",null,null,null,null,null,null,null,"Viviendas Sin  Conexción a redes de Gas Natural",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Viviendas Sin  Conexión a redes de Gas Natural",null,null,null,null,null,null,"Viviendas Sin  Conexión a redes de Gas Natural",null,null,null,null,null,null,{"$f":"+BT1/87","v":72.574889950967687},{"$f":"+BQ11&ROUND(BR10,0)&\" kWh/m2.año\"","v":"Cons. Calef.=73 kWh/m2.año"}]
[null,null,{"$f":"+D2","v":"N="},105,"# Persona",null,"Sup (m2)",null,"# Heladera","Heladera","Lavarropa","Ilumin.","AA-Cal+Ref.","Cale.E.","Microonda","Cafetera","TV+Electr.","Inform.","Stand By","Planch.","Bomba","Secador P.","HornoE","ACS_E","Cocina_EE","otros","Extra","Todo Electicidad","Cocción","ACS","Piloto","Calefacción","Otro_gas","TOTAL_GAS","Gas (m3)","kWh/ano",null,null,"Electr.","Gas","Total Cocina ","Heladera","ACS ","Acond.Term","Casa_Electr","Otros","Todo","ACS/per","Elect.Casa/Pers","Calef.T.","Refrig.T ","Ac.Term/m2","Calf/m2","Cocina T./pers","kg(CO2)/m2","EE/N_pers","ACS/Pers","%AA","%AA_Calef","Transp","Total","Electr.","Gas","Transp","Total","Electr+Gas","Electr+Gas",null,"Cons. Calef.="]
["Resumen Historico",null,"B","total",3.9156626506024095,"Promedio",88.385802469135797,null,1.3322666666666665,909.08126418887366,88.414010007394296,232.64257055867233,598.75648742618921,1154.7500547258128,185.42247024479167,256.64432906416158,258.93712209302328,62.430309399430953,22.878795918367345,15.215049001556181,62.350172768817195,32.950904602344771,242.41619209183679,2316.4262769230772,1063.0830769230768,150.54355914649469,7.3875732600732587,5152.0358628090098,1368.876684587814,null,null,null,0,{"$f":"+SUM(AC12:AF12)","v":1368.876684587814},{"$f":"+AH12/10.8","v":126.74784116553832},{"$f":"+AB12+AH12","v":6520.9125473968234},null,null,{"$f":"+AB12/1000","v":5.1520358628090097},{"$f":"+AH12/1000","v":1.368876684587814},{"$f":"+(AC12+Y12)/2+W12+P12+O12","v":1900.4628721562353},{"$f":"+J12","v":909.08126418887366},{"$f":"+X12","v":2316.4262769230772},{"$f":"+M12+N12+AF12","v":1753.5065421520021},{"$f":"+K12+L12+SUM(Q12:V12)","v":775.81893434960625},{"$f":"+Z12+AA12","v":157.93113240656794},{"$f":"SUM(AO12:AT12)","v":7813.2270221763629},{"$f":"+IF(E12>0,AQ12/E12,AQ12/2.3)","v":591.57963379881664},{"$f":"+IF(E12>0,AS12/E12,AS12/2.3)","v":198.13222015697639},{"$f":"+AF12+N12+M12*0.667","v":1554.1206318390809},{"$f":"+M12*0.333","v":199.38591031292103},{"$f":"+IF(G12>0,AR12/G12,AR12/65)","v":19.839233147929207},{"$f":"+(AF12+N12+M12*0.667)/G12","v":17.583374121446461},{"$f":"+IF(E12>0,AO12/E12,AO12/2.3)","v":485.34897965836166},{"$f":"+((M12+N12)*$BK$5+AF12*$BL$5)/G12","v":44.126086610723732},{"$f":"+(K12+L12+SUM(Q12:V12))/E12","v":198.13222015697639},{"$f":"+AQ12/E12","v":591.57963379881664},{"$f":"+M12/AR12","v":0.34146236300399624},{"$f":"+(AF12+AM12*0.66)/AX12","v":2.187953495881541E-3},null,{"$f":"SUM(AO18:AT18)/1000","v":9.0292069029318078},{"$f":"+BJ$1*AM12","v":1.5301546512542759},{"$f":"+BK$1*AN12","v":0.27651309028673843},{"$f":"+BL$1*BH12","v":0},{"$f":"+SUM(BJ12:BL12)","v":1.8066677415410144},{"$f":"+BJ12+BK12","v":1.8066677415410144},3.0821051704949758]
["Viviendas sin coneccion a redes de GN",null,null,null,4,"mediana",75,null,1,751.024,50.454999999999998,131.04,234,494,70.746075000000005,112.9456,190.52999999999997,32.802,0,0,0,0,0,2007.5,1095,4.9499999999999993,11.04125,4621.5934999999999,1400,null,null,null,0,{"$f":"+SUM(AC13:AF13)","v":1400},{"$f":"+AH13/10.8","v":129.62962962962962},{"$f":"+AB13+AH13","v":6021.5934999999999},null,null,{"$f":"+AB13/1000","v":4.6215935000000004},{"$f":"+AH13/1000","v":1.4},{"$f":"+AC13+Y13+W13+P13+O13","v":2678.691675},{"$f":"+J13","v":751.024},{"$f":"+AD13+AE13+X13","v":2007.5},{"$f":"+M13+N13+AF13","v":728},{"$f":"+K13+L13+SUM(Q13:V13)","v":404.827},{"$f":"+Z13+AA13","v":15.991249999999999},{"$f":"SUM(AO13:AT13)","v":6586.0339249999997},{"$f":"+IF(E13>0,AQ13/E13,AQ13/2)","v":501.875},{"$f":"+IF(E13>0,AS13/E13,AS13/2)","v":101.20675},{"$f":"+AF13+N13+M13*0.667","v":650.07799999999997},{"$f":"+M13*0.333","v":77.922000000000011},{"$f":"+IF(G13>0,AR13/G13,AR13/65)","v":9.706666666666667},{"$f":"+(AF13+N13+M13*0.667)/G13","v":8.6677066666666658},{"$f":"+IF(E13>0,AO13/E13,AO13/2)","v":669.67291875000001},{"$f":"+((M13+N13)*$BK$5+AF13*$BL$5)/G13","v":21.589403725489536},{"$f":"+(K13+L13+SUM(Q13:V13))/E13","v":101.20675},{"$f":"+AQ13/E13","v":501.875},{"$f":"+M13/AR13","v":0.32142857142857145},{"$f":"+(AF13+AM13*0.66)/AX13","v":4.692131882635623E-3},null,{"$f":"SUM(AO13:AT13)/1000","v":6.5860339249999997},{"$f":"+BJ$1*AM13","v":1.3726132695},{"$f":"+BK$1*AN13","v":0.2828},{"$f":"+BL$1*BH13","v":0},{"$f":"+SUM(BJ13:BL13)","v":1.6554132694999999},{"$f":"+BJ13+BK13","v":1.6554132694999999},4.0821051704949802]
[{"$f":"+$D$30&\"=\"& ROUND(D14/1000,2)&\" \"&$F$30&\" Sin GN\"","v":"Total Electr.=6.44 MWh/año Sin GN"},null,"Electrico",{"$f":"+AB15","v":6439.3160090143492},null,"AT/m2=",{"$f":"+AZ18","v":19.839233147929207},"kWh/m2/año",{"$f":"+I12","v":1.3322666666666665},{"$f":"+J12","v":909.08126418887366},{"$f":"+K12","v":88.414010007394296},232.64257055867233,598.75648742618921,1154.7500547258128,185.42247024479167,256.64432906416158,258.93712209302328,62.430309399430953,22.878795918367345,15.215049001556181,62.350172768817195,32.950904602344771,242.41619209183679,2316.4262769230772,1063.0830769230768,150.54355914649469,7.3875732600732587,null,{"$f":"+AC12","v":1368.876684587814},0,0,0,null,{"$f":"+SUM(AC12:AF12)","v":1368.876684587814},null,{"$f":"+SUM(AC14:AF14)+AB15","v":7808.1926936021628},null,null,null,null,{"$f":"+AO12","v":1900.4628721562353},{"$f":"+AP12","v":909.08126418887366},2316.4262769230772,1753.5065421520021,775.81893434960625,157.93113240656794,7813.2270221763629,{"$f":"+AV12","v":591.57963379881664},198.13222015697639,1554.1206318390809,199.38591031292103,19.839233147929207,17.583374121446461,485.34897965836166,44.126086610723732,198.13222015697639,591.57963379881664]
[{"$f":"+$D$31&\"=\"& ROUND(D15/1000,2)&\" \"&$F$31&\" Sin GN\"","v":"Total Gas+Electr.=7.81 MWh/año Sin GN"},null,"Todos",{"$f":"+AB15+AH14","v":7808.1926936021628},null,"Calef/m2",{"$f":"+BA18","v":17.583374121446461},"kWh/m2/año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(J14:X14)","v":6439.3160090143492}]
[{"$f":"+$A$29&ROUND(G14,0)&\" kWh/m2.año\"","v":"Acond.Term.=20 kWh/m2.año"},null,null,null,"Consumo tipico medio de RA",null,null,null,null,"Consumo tipico medio de RA"]
[{"$f":"+$F$29&ROUND(G17*100,1)&\" % \"","v":"Porc. BC.=22.7 % "},null,null,null,null,"Porc. BC.=",{"$f":"+BF19","v":0.22718262624558144},null,{"$f":"+I11","v":"# Heladera"},{"$f":"+J11","v":"Heladera"},"Lavarropa","Ilumin.","AA-Cal+Ref.","Cale.E.","Microonda","Cafetera","TV+Electr.","Inform.","Stand By","Planch.","Bomba","Secador P.","HornoE","ACS_E","Cocina_EE","otros","Extra","Todo Electicidad","Cocción","ACS","Piloto","Calefacción","Otro_gas","TOTAL_GAS","Gas (m3)",{"$f":"+AJ11","v":"kWh/ano"},"Total Gral RA",null,{"$f":"+AM11","v":"Electr."},"Gas","Total Cocina ","Heladera","ACS ","Acond.Term","Casa_Electr","Otros","Todo","ACS/per","Elect.Casa/Pers","Calef.T.","Refrig.T ","Ac.Term/m2","Calf/m2","Cocina T./pers","kg(CO2)/m2","EE/N_pers","ACS/Pers","%AA","%AA_Calef","Transp","Total","Electr.","Gas","Transp","Total","Electr+Gas","Electr+Gas"]
[null,null,null,null,"Con GN",0.6,"Cons. Energ.=",{"$f":"+AJ18/1000","v":12.180343183209892},{"$f":"+$F$18*I4+I12*$F$19","v":1.4669386666666666},868.0578560670599,99.640716002660753,262.824863004495,724.27380165528746,882.67479702622143,137.70008788038581,189.63151612082896,245.15858039292462,188.84375584442023,68.63929940868374,60.284077191262874,148.83961908085053,48.629350977679337,292.06030941031713,1579.7921760192307,425.23323076923072,246.15018628995367,644.54355342167628,4067.1624269430758,1374.4155051755538,1570.4536113858924,1379.9023842648569,3788.4092554405129,2684.5341249999915,8113.1807562668155,751.22044039507557,12180.343183209892,{"$f":"+AB18+SUM(AC18:AF18)","v":12180.343183209892},null,{"$f":"+AB18/1000","v":4.0671624269430762},{"$f":"+AH18/1000","v":8.1131807562668161},{"$f":"+AC12+Y12+W12+P12+O12","v":3116.4427529116806},{"$f":"+J12","v":909.08126418887366},{"$f":"+AD12+AE12+X12","v":2316.4262769230772},{"$f":"+M12+N12+AF12","v":1753.5065421520021},{"$f":"+K12+L12+SUM(Q12:V12)","v":775.81893434960625},{"$f":"+Z12+AA12","v":157.93113240656794},{"$f":"SUM(AO18:AT18)","v":9029.2069029318081},{"$f":"+IF(E12>0,AQ18/E12,AQ18/2.3)","v":591.57963379881664},{"$f":"+IF(E12>0,AS18/E12,AS18/2.3)","v":198.13222015697639},{"$f":"+AF12+N12+M12*0.667","v":1554.1206318390809},{"$f":"+M12*0.333","v":199.38591031292103},{"$f":"+IF(G12>0,AR18/G12,AR18/65)","v":19.839233147929207},{"$f":"+(AF12+N12+M12*0.667)/G12","v":17.583374121446461},{"$f":"+IF(E12>0,AO18/E12,AO18/2.3)","v":795.89153382052154},{"$f":"+((M12+N12)*$BK$5+AF12*$BL$5)/G12","v":44.126086610723732},{"$f":"+(K12+L12+SUM(Q12:V12))/E12","v":198.13222015697639},{"$f":"+AQ18/E12","v":591.57963379881664},{"$f":"+M18/AR18","v":0.41304311346704065},{"$f":"0.66*AM18/AX18","v":1.7272322024358628E-3},null,{"$f":"SUM(AO24:AT24)/1000","v":15.090193116883093},{"$f":"+BJ$1*AM18","v":1.2079472408020935},{"$f":"+BK$1*AN18","v":1.6388625127658969},{"$f":"+BL$1*BH18","v":0},{"$f":"+SUM(BJ18:BL18)","v":2.8468097535679906},{"$f":"+BJ18+BK18","v":2.8468097535679906},3.0821051704949758]
[null,null,null,null,"Sin GN",{"$f":"1-F18","v":0.4},"AT/m2=",{"$f":"+BA19","v":57.394754375636126}," kWh/m2/año",{"$f":"+G19&ROUND(H19,0)&I19","v":"AT/m2=57 kWh/m2/año"},null,null,{"$f":"+F17&ROUND(G17*100,0)&\"%\"","v":"Porc. BC.=23%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$F$18*AM4+AM12*$F$19","v":4.0671624269430762},{"$f":"+$F$18*AN4+AN12*$F$19","v":8.1131807562668161},{"$f":"+$F$18*AO4+AO18*$F$19","v":2419.0406493563164},868.0578560670599,3876.9265064199803,5395.3578541220213,1122.8602619029771,890.69373971162997,14572.936867579985,1148.6780963994613,330.43185987119625,5154.1746781708116,241.18317595121076,60.090751450963026,57.394754375636126,680.80134074696775,40.029324059951207,330.43185987119625,1148.6780963994613,0.22718262624558144,0.5023625553658525,{"$f":"+$F$18*BH4+BH12*$F$19","v":0},14.572936867579985,1.2079472408020937,1.6388625127658969,0,2.8468097535679906,2.8468097535679906,3.0821051704949758]
[null,null,"Consumo tipico medio de RA=",null,null,null,{"$f":"+G18&ROUND(H18,1)&\" MWh/año\"","v":"Cons. Energ.=12.2 MWh/año"},null,null,"Cons. Elect. RA=",null,{"$f":"+J20&ROUND(AB18/1000,1)& \" MWh/año\"","v":"Cons. Elect. RA=4.1 MWh/año"}]
[]
["Vivienda en estudio ",null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,null,null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,null,null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,null,null,null,"Vivienda en estudio ",null,null,null,null,null,null,null,"Vivienda en estudio "]
[{"$f":"+'Consumo eléctrico'!$D$104","v":"Total Electr.=4.22 MWh/año"},null,null,{"$f":"+E24","v":4},"# Persona","Autor o Resposable: ","Sup (m2)","Cond.Soc.Econ.","# de Heladeras","Heladera","Lava.","Ilum.","Refr.Calf. AA","Calef. EE","Microon.","Cafetera","TV+Electr.","Inform.",{"$f":"+'Consumo eléctrico'!X6","v":"Stand By"},{"$f":"+'Consumo eléctrico'!Y6","v":"Plancha"},{"$f":"+'Consumo eléctrico'!Z6","v":"Bomba"},{"$f":"+'Consumo eléctrico'!AA6","v":"Secador Pelo"},{"$f":"+'Consumo eléctrico'!AB6","v":"Horno Eléctrico"},{"$f":"+'Consumo eléctrico'!AC6","v":"Termotanq_EE"},{"$f":"+'Consumo eléctrico'!AD6","v":"Cocina_EE"},{"$f":"+'Consumo eléctrico'!AE6","v":"Otros"},{"$f":"+'Consumo eléctrico'!AF6","v":"Extras"},{"$f":"+'Consumo eléctrico'!AG6","v":"Todo Electicidad"},{"$f":"+'Consumo eléctrico'!AH6","v":"Cocción_Gas"},{"$f":"+'Consumo eléctrico'!AI6","v":"ACS_Gas"},{"$f":"+'Consumo eléctrico'!AJ6","v":"Piloto_GN"},{"$f":"+'Consumo eléctrico'!AK6","v":"Calef._Gas"},{"$f":"+'Consumo eléctrico'!AL6","v":"Otro_gas"},{"$f":"+'Consumo eléctrico'!AM6","v":"Total Gas"},{"$f":"+'Consumo eléctrico'!AN6","v":"Coccion (kWh)"},"kWh/ano",null,null,"Electr.","Gas","Total Cocina ","Heladera","ACS ","Acond.Term","Casa_Electr","Otros","Todo","ACS/per","Elect.Casa/Pers","Calef.T.","Refrig.T ","Ac.Term/m2","Calf/m2","Cocina T./pers","kg(CO2)/m2","EE/N_pers","ACS/Pers","%AA","%AA_Calef","Transp","Total","Electr.","Gas","Transp","Total","Electr+Gas","Electr+Gas"]
[{"$f":"+'Consumo eléctrico'!$D$105","v":"Total Gas+Electr.=18.8 MWh/año"},null,null,{"$f":"+'Consumo eléctrico'!I7","v":"Italia xxx"},{"$f":"+'Consumo eléctrico'!J7","v":4},{"$f":"+'Consumo eléctrico'!K7","v":"  Su Nombre"},{"$f":"+'Consumo eléctrico'!L7","v":67},{"$f":"+'Consumo eléctrico'!M7","v":"B2"},{"$f":"+'Consumo eléctrico'!N7","v":1},{"$f":"+'Consumo eléctrico'!O7","v":730},{"$f":"+'Consumo eléctrico'!P7","v":336.56436688311692},{"$f":"+'Consumo eléctrico'!Q7","v":86.762799999999999},{"$f":"+'Consumo eléctrico'!R7","v":264.39999999999998},{"$f":"+'Consumo eléctrico'!S7","v":0},{"$f":"+'Consumo eléctrico'!T7","v":328.5},{"$f":"+'Consumo eléctrico'!U7","v":524.13499999999999},{"$f":"+'Consumo eléctrico'!V7","v":173.5575},{"$f":"+'Consumo eléctrico'!W7","v":468.41666666666663},{"$f":"+'Consumo eléctrico'!X7","v":122.63999999999999},{"$f":"+'Consumo eléctrico'!Y7","v":114.97499999999999},{"$f":"+'Consumo eléctrico'!Z7","v":87.6},{"$f":"+'Consumo eléctrico'!AA7","v":1.825},{"$f":"+'Consumo eléctrico'!AB7","v":137.25},{"$f":"+'Consumo eléctrico'!AC7","v":2007.5},{"$f":"+'Consumo eléctrico'!AD7","v":912.5},{"$f":"+'Consumo eléctrico'!AE7","v":976.24666666666667},{"$f":"+'Consumo eléctrico'!AF7","v":0},null,{"$f":"+'Consumo eléctrico'!AH7","v":1657.7606499999949},{"$f":"+'Consumo eléctrico'!AI7","v":986.22159999999678},{"$f":"+'Consumo eléctrico'!AJ7","v":1973.5245833333272},{"$f":"+'Consumo eléctrico'!AK7","v":3199.8132833333229},{"$f":"+'Consumo eléctrico'!AL7","v":0},{"$f":"+'Consumo eléctrico'!AM7","v":7817.3201166666422},{"$f":"+'Consumo eléctrico'!AN7","v":2707.5106499999947},{"$f":"+AB24+AH24","v":7817.3201166666422},null,null,{"$f":"+AB24/1000","v":0},{"$f":"+AH24/1000","v":7.8173201166666422},{"$f":"+AC24+Y24+W24+P24+O24","v":3560.1456499999949},{"$f":"+J24","v":730},{"$f":"+AD24+AE24+X24","v":4967.2461833333236},{"$f":"+M24+N24+AF24","v":3464.213283333323},{"$f":"+K24+L24+SUM(Q24:V24)","v":1392.3413335497835},{"$f":"+Z24+AA24","v":976.24666666666667},{"$f":"SUM(AO24:AT24)","v":15090.193116883092},{"$f":"+IF(E24>0,AQ24/E24,AQ24/2.3)","v":1241.8115458333309},{"$f":"+IF(E24>0,AS24/E24,AS24/2.3)","v":348.08533338744587},{"$f":"+AF24+N24+M24*0.667","v":3376.168083333323},{"$f":"+M24*0.333","v":88.045199999999994},{"$f":"+IF(G24>0,AR24/G24,AR24/65)","v":51.704675870646611},{"$f":"+(AF24+N24+M24*0.667)/G24","v":50.390568407960046},{"$f":"+IF(E24>0,AO24/E24,AO24/2.3)","v":890.03641249999873},{"$f":"+((M24+N24)*$BK$5+AF24*$BL$5)/G24","v":8.777223960071705},{"$f":"+(K24+L24+SUM(Q24:V24))/E24","v":348.08533338744587},{"$f":"+AQ24/E24","v":1241.8115458333309},{"$f":"+M24/AR24","v":7.6323245243604038E-2},{"$f":"+AF24/AX24","v":0.94776480446261335},null,{"$f":"SUM(AO24:AT24)/1000","v":15.090193116883093},{"$f":"+BJ$1*AM24","v":0},{"$f":"+BK$1*AN24","v":1.5790986635666617},{"$f":"+BL$1*BH24","v":0},{"$f":"+SUM(BJ24:BL24)","v":1.5790986635666617},{"$f":"+BJ24+BK24","v":1.5790986635666617},3.0821051704949758,null,null,null,null,{"$f":"+AR28/1000","v":0},{"$f":"+AX28/1000","v":0},{"$f":"+Transporte!P24+Transporte!P25","v":0},{"$f":"SUM(BT24:BV24)","v":0},{"$f":"+BS21*BT24","v":0},{"$f":"+BT21*BU24","v":0},{"$f":"+BU21*BV24","v":0},{"$f":"+SUM(BX24:BZ24)","v":0}]
[{"$f":"+'Consumo eléctrico'!E9","v":"Consumos eléctricos anuales Casa en Su Lugar(MWh)=7.27"},null,null,null,null,"Porc. BC.=",{"$f":"+BF17","v":"%AA"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+SUM(J12:W12)+Z12","v":4273.4332912377668},{"$f":"+SUM(J12:W12)+Z12","v":4273.4332912377668},{"$f":"+SUM(J24:AA24)","v":7272.8730002164493},null,null,null,null,null,{"$f":"+SUM(AC24:AG24)","v":7817.3201166666422},null,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":"+'Consumo eléctrico'!BM7","v":2.1600432810642856},{"$f":"+'Consumo eléctrico'!BN7","v":1.5790986635666617},{"$f":"+'Consumo eléctrico'!BI7","v":7.2728730002164497},{"$f":"+'Consumo eléctrico'!BJ7","v":7.8173201166666422},{"$f":"+'Consumo eléctrico'!BK7","v":16.887558920691667},{"$f":"+'Consumo eléctrico'!BL7","v":31.97775203757476},{"$f":"+'Consumo eléctrico'!BM7","v":2.1600432810642856},{"$f":"+'Consumo eléctrico'!BN7","v":1.5790986635666617}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"}]
[{"$f":"+$D$30&\"=\"& ROUND(E30,2)&\" \"&$F$30& F24","v":"Total Electr.=7.27 MWh/año  Su Nombre"},null,null,"Electrico",{"$f":"+E30","v":7.2728730002164497},"AT/m2=",{"$f":"+AZ24","v":51.704675870646611},"kWh/m2/año",null,{"$f":"+J23","v":"Heladera"},{"$f":"+K23","v":"Lava."},"Ilum.","Refr.Calf. AA","Calef. EE","Microon.","Cafetera","TV+Electr.","Inform.","Stand By","Plancha","Bomba","Secador Pelo","Horno Eléctrico","Termotanq_EE","Cocina_EE","Otros","Extras",{"$f":"+AC23","v":"Cocción_Gas"},"ACS_Gas","Piloto_GN","Calef._Gas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+BR27/P25","v":{"$error":"#DIV/0!"}}]
[{"$f":"+$D$31&\"=\"& ROUND(E31,1)&\" \"&$F$31& F24","v":"Total Gas+Electr.=15.1 MWh/año  Su Nombre"},null,null,"Todos",{"$f":"+E31","v":15.090193116883093},"Calef/m2",{"$f":"+BA24","v":50.390568407960046},"kWh/m2/año",null,{"$f":"+J24","v":730},{"$f":"+K24","v":336.56436688311692},86.762799999999999,264.39999999999998,0,328.5,524.13499999999999,173.5575,468.41666666666663,122.63999999999999,114.97499999999999,87.6,1.825,137.25,2007.5,912.5,976.24666666666667,0,1657.7606499999949,986.22159999999678,1973.5245833333272,3199.8132833333229]
["Acond.Term.=",null,"Cons. Total-",null,null,"Porc. BC.=",{"$f":"+BF24","v":7.6323245243604038E-2},{"$f":"+'Consumo eléctrico'!G107","v":"Total Electr."},{"$f":"+'Consumo eléctrico'!H107","v":4.215623000216449},{"$f":"+'Consumo eléctrico'!I107","v":"MWh/año"}]
[{"$f":"+$A$29&ROUND(G27,0)&\" kWh/m2.año\"","v":"Acond.Term.=52 kWh/m2.año"},null,null,"Total Electr.",{"$f":"SUM(J24:AA24)/1000","v":7.2728730002164497},"MWh/año",null,{"$f":"+'Consumo eléctrico'!G108","v":"Total Gas+Electr."},{"$f":"+'Consumo eléctrico'!H108","v":18.774806400216413},{"$f":"+'Consumo eléctrico'!I108","v":"MWh/año"}]
[{"$f":"+$F$29&ROUND(G29*100,1)&\" % \"","v":"Porc. BC.=7.6 % "},null,null,"Total Gas+Electr.",{"$f":"(AB25+AH25)/1000","v":15.090193116883093},"MWh/año",null,{"$f":"+'Consumo eléctrico'!G109","v":"Transp."},{"$f":"+'Consumo eléctrico'!H109","v":3.8924730732958244},{"$f":"+'Consumo eléctrico'!I109","v":"MWh/año"}]
[null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!G110","v":"Total (T.G.EE)="},{"$f":"+'Consumo eléctrico'!H110","v":26.882902473728688},{"$f":"+'Consumo eléctrico'!I110","v":"MWh/año"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumo domésticos en RA Total=",null,null,{"$f":"+AB74&ROUND(D6/1000,1)&\" MWh/año\"","v":"Consumo domésticos en RA Total=16 MWh/año"}]

{"sheet":"Consumo eléctrico","index":2,"n_rows":772,"n_cols":68,"rows_kept":772,"cut":false,"hidden":false,"merged":[[4,14,4,32],[1,2,1,8]]}
["Corregido por ","S.G.",null,null,null,null,null,null,null,"# Persona","Autor o Resposable: ","Sup (m2)","Cond.Soc.Econ.",null,"Heladera","Lavarropa","Iluminacion","Refrigeración Aire Acond.","Calefacción Electr.","Microonda","Cafetera+Tostadora + batidora","TV+Radio+DVD","Informatica","Stand By","Plancha","Bomba","Secador Pelo","Horno Eléctrico","Termotanq_EE",null,"Otros","Extras","Todo Electicidad","Cocción_Gas","ACS_Gas","Piloto_GN","Calef._Gas"]
["Aprobado",null,"Por favor llenar solo  los casilleros en Azul con fondo Verde",null,null,null,null,null,null,"Cosumos estimados","Si/No",null,null,null,null,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":"+'Tabla 1y2'!AG2","v":"Coccion (kWh)"},null,{"$f":"+'Tabla 1y2'!AH2","v":"EE Cocina "},{"$f":"+'Tabla 1y2'!AI2","v":"ACS (kWh)"},{"$f":"+'Tabla 1y2'!AJ2","v":"AT"},{"$f":"+'Tabla 1y2'!AK2","v":"Refrig.T (kWh)"},{"$f":"+'Tabla 1y2'!AL2","v":"ACS/Pers"},{"$f":"+'Tabla 1y2'!AM2","v":"AT/m2"}]
[null,null,null,null,null,null,null,null,null,"Consumos medidos","Si/NO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sintesis Final",null,"Sintesis Final",null,"Sintesis Final"]
[null,null,null,null,"No Modificar esta parte ",null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,null,null,null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,null,null,null,"No Modificar esta parte ",null,null,"No Modificar esta parte ",null,"No Modificar esta parte ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wcal=",{"$f":"1-BD4","v":0.83333333333333337},{"$f":"125/750","v":0.16666666666666666},null,null,null,null,null,null,null,null,0.29699999999999999,0.20200000000000001,0.26700000000000002,"kg(CO2)/MWh"]
["Auditoria de Consumo",null,"Autor o Resposable: ",null,{"$f":"+nombre","v":"  Su Nombre"},null,"Superficie Cubierta (m2)",null,{"$f":"+Area_v","v":67},null,null,null,null,null,"ELECTRICIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GAS","GAS","GAS","GAS","GAS",null,null,null,null,null,null,null,null,null,null,"Cocina T.","Helad.","Ac.Term","ACS_T","Pasivo","Casa_Electr.","Otros",null,null,null,null,null,"MWh/año","MWh/año","MWh/año","MWh/año","kg(CO2)/MWh",null,"kg(CO2)/MWh"]
["Las celdas con este color se puede modificar",null,"e:mail:",null,{"$f":"+Vivienda!C6","v":"mail@unsam.edu.ar"},null,"Número de personas en la Vivienda",null,{"$f":"+n_pers","v":4},"# Persona",{"$f":"+C5","v":"Autor o Resposable: "},"Sup (m2)","Cond.Soc.Econ.","# de Heladeras","Heladera","Lavarropa","Iluminacion",{"$f":"A85","v":"Refr.Calf. AA"},{"$f":"A86","v":"Calef. Electr."},"Microonda","Cafetera+Tostadora + batidora","TV+Radio+DVD","Informatica","Stand By","Plancha","Bomba","Secador Pelo","Horno Eléctrico","Termotanq_EE","Cocina_EE","Otros","Extras",{"$f":"+A110","v":"Todo Electicidad"},{"$f":"+A104","v":"Cocción_Gas"},{"$f":"+A105","v":"ACS_Gas"},{"$f":"+A106","v":"Piloto_GN"},{"$f":"+A107","v":"Calef._Gas"},"Otro_gas",{"$f":"+A111","v":"Total Gas"},"Coccion (kWh)","EE Cocina ","ACS (kWh)","AT","Refrig.T (kWh)","ACS/Pers","AT/m2","EE/N_pers",{"$f":"+A109","v":"Consumo Totales Gas+Electricidad"},"Total Cocina (kWh)","Heladera (kWh)","AT (kWh)","ACS (kWh)","Pasivo","Casa EE","Otros","Todos","AT/m2","EE/N_pers","Calef.T. (kWh)","Calf/m2","Electr.","Gas","Transp","Total","Electr.","Gas","Transp","Total"]
["Las otras NO las modifique por favor",null,"Fecha de ensayo:",null,{"$f":"+Vivienda!C7","v":"2016-02-01"},null,"Dieccion",null,{"$f":"+Vivienda!F10","v":"Italia xxx"},{"$f":"+n_pers","v":4},{"$f":"+nombre","v":"  Su Nombre"},{"$f":"+Area_v","v":67},{"$f":"+Vivienda!F15","v":"B2"},{"$f":"+I11","v":1},{"$f":"+C82","v":730},{"$f":"+C83","v":336.56436688311692},{"$f":"+C84","v":86.762799999999999},{"$f":"+C85","v":264.39999999999998},{"$f":"C86","v":0},{"$f":"+C87","v":328.5},{"$f":"+C88","v":524.13499999999999},{"$f":"+C90","v":173.5575},{"$f":"+C89","v":468.41666666666663},{"$f":"+C91","v":122.63999999999999},{"$f":"+C93","v":114.97499999999999},{"$f":"+C94","v":87.6},{"$f":"+C92","v":1.825},{"$f":"+C96","v":137.25},{"$f":"+C97","v":2007.5},{"$f":"+I51","v":912.5},{"$f":"+C98","v":976.24666666666667},{"$f":"+C99","v":0},{"$f":"+SUM(O7:AF7)","v":7272.8730002164493},{"$f":"+C104","v":1657.7606499999949},{"$f":"+C105","v":986.22159999999678},{"$f":"+C106","v":1973.5245833333272},{"$f":"+C107","v":3199.8132833333229},{"$f":"+D107","v":0},{"$f":"+SUM(AH7:AL7)","v":7817.3201166666422},{"$f":"+AB7+AD7+AH7","v":2707.5106499999947},{"$f":"+T7+U7","v":852.63499999999999},{"$f":"+AI7+AJ7+AC7","v":4967.2461833333236},{"$f":"+AK7+S7+R7*0.667","v":3376.168083333323},{"$f":"+R7*0.333","v":88.045199999999994},{"$f":"+AP7/J7","v":1241.8115458333309},{"$f":"+AQ7/L7","v":50.390568407960046},{"$f":"+(AG7-AC7-AD7-S7-R7)/J7","v":1022.1182500541123},{"$f":"+AG7+AM7","v":15090.193116883092},{"$f":"+AH7+AD7+AB7+U7+T7","v":3560.1456499999949},{"$f":"+O7","v":730},{"$f":"+AK7+S7+R7","v":3464.213283333323},{"$f":"+AI7+AC7","v":2993.7215999999967},{"$f":"+AJ7","v":1973.5245833333272},{"$f":"+(P7+Q7+V7+W7+X7+Z7+Y7+AA7)","v":1392.3413335497833},{"$f":"+AE7+AF7","v":976.24666666666667},{"$f":"+SUM(AW7:BC7)","v":15090.193116883091},{"$f":"+AY7/L7","v":51.704675870646611},{"$f":"+(BB7)/J7","v":348.08533338744581},{"$f":"+AK7+S7+R7*wcal","v":3420.1466166666564},{"$f":"+BG7/L7","v":51.046964427860544},{"$f":"+AG7/1000","v":7.2728730002164497},{"$f":"+AM7/1000","v":7.8173201166666422},{"$f":"+Transporte!L20+Transporte!L21","v":16.887558920691667},{"$f":"SUM(BI7:BK7)","v":31.97775203757476},{"$f":"+BM4*BI7","v":2.1600432810642856},{"$f":"+BN4*BJ7","v":1.5790986635666617},4.5089782318246758,{"$f":"+SUM(BM7:BO7)","v":8.2481201764556236}]
["Auditoria de Consumo",null,"Tipo de vivienda",null,{"$f":"+Vivienda!C9","v":"Casa"},"Casa/Dpto","Localidad:",null,{"$f":"+Vivienda!F11","v":"Su Lugar"},"# Persona","Autor o Resposable: ","Sup (m2)","Cond.Soc.Econ.","# de Heladeras","Heladera","Lavarropa","Iluminacion","Refrigeración Aire Acond.","Calefacción Electr.","Microonda","Cafetera+Tostadora + batidora","TV+Radio+DVD","Informatica","Stand By","Plancha","Bomba","Secador Pelo","Horno Eléctrico","Termotanq_EE",null,"Otros","Extras","Todo Electicidad","Cocción_Gas","ACS_Gas","Piloto_GN","Calef._Gas","Otro_gas","Total Gas","Total Cocina (kWh)",null,"ACS (kWh)","Calef.T. (kWh)","Refrig.T (kWh)",null,"Calf/m2","EE/N_pers",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"},{"$f":"+Transporte!$N$17","v":"Tn(CO2)/año"}]
[null,null,"Consumos Electricos ",null,{"$f":"+\"Consumos eléctricos anuales\"&\" \"&E8&\" en \"&I8&\"(MWh)=\"&ROUND(I74/1000,2)","v":"Consumos eléctricos anuales Casa en Su Lugar(MWh)=7.27"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+BI7*BM4","v":2.1600432810642856},{"$f":"+BJ7*BN4","v":1.5790986635666617},{"$f":"+BK7*BO4","v":4.5089782318246758},{"$f":"SUM(BI9:BK9)","v":8.2481201764556236}]
[{"$f":"+\"Consumos gas+Eletrc.+Tran. anuales\"&\" \"&E8&\" en \"&I8&\"(MWh)=\"&ROUND(H107/1000,2)","v":"Consumos gas+Eletrc.+Tran. anuales Casa en Su Lugar(MWh)=0"},null,null,null,{"$f":"+\"Consumos gas+Eletrc. anuales\"&\" \"&E8&\" en \"&I8&\"(MWh)=\"&ROUND(H107/1000,2)","v":"Consumos gas+Eletrc. anuales Casa en Su Lugar(MWh)=0"}]
[{"$f":"+C9&\"de \"&E8&\" de \"&I5&\" mts.2\"&\" en \"&I8&\" con \"&I6&\" personas adultas\"","v":"Consumos Electricos de Casa de 67 mts.2 en Su Lugar con 4 personas adultas"},null,null,null,null,null,null,null,{"$f":"+COUNTIF(I15:I18,\">1\")","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acond.Term.=",null,"Cons. Total-",{"$f":"+AW11&E5&ROUND(AV7/1000,1)&\" MWh/año\"","v":"Cons. Total-  Su Nombre15.1 MWh/año"}]
[null,null,"[W]","[W]","[h]","[Wh]","[kWh]",null,"[kWh]",null,null,null,null,null,"Wh",null,null,null,null,null,null,null,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":"+AU11&ROUND(BE7,1)&\" kWh/m2.año\"","v":"Acond.Term.=51.7 kWh/m2.año"}]
[null,"Caracteristicas","Potencia Nominal unitaria","Pot_medida unitario","hs_Uso/dia","Consumo diario","Consumo diario","Dias al año utilizado","Consumo Annual [kWh]","Comentarios","Comentarios y Sugerencia","Antiguedad Años",{"$f":"+E5","v":"  Su Nombre"},null,"Consumo dia/cilclo","Años"]
["Artefacto","Marca y Clase",null,null,null,null,null,null,null,null,"Marca, u otro dato útil",null,{"$f":"+A14","v":"Artefacto"},"Marca y Clase"]
["Heladera A","Electrolux Clase A",null,{"$f":"+F15/E15","v":83.333333333333329},24,2000,{"$f":"F15/1000","v":2},365,{"$f":"+G15*H15","v":730},{"$f":"+IF(AND(F15>0,OR(F15<650,F15>4500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?","Heladera A","Electrolux Clase A",{"$f":"+F15","v":2000},{"$f":"+L15","v":"Antiguedad?"}]
["Heladera  B","Acme 0",null,{"$f":"+F16/E16","v":0},25,0,{"$f":"F16/1000","v":0},365,{"$f":"+G16*H16","v":0},{"$f":"+IF(AND(F16>0,OR(F16<650,F16>4500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?","Heladera  B","Acme 0",0,"Antiguedad?"]
["Heladera  C","Acme 2",null,{"$f":"+F17/E17","v":0},25,0,{"$f":"F17/1000","v":0},365,0,"","g","Antiguedad?","Heladera  C","Acme 2",0,"Antiguedad?"]
["Heladera  D","Acme 3",null,{"$f":"+F18/E18","v":0},25,0,{"$f":"F18/1000","v":0},366,{"$f":"+G18*H18","v":0},{"$f":"+IF(AND(F18>0,OR(F18<650,F18>4500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},"g","Antiguedad?","Heladera  D","Acme 3",0,"Antiguedad?"]
["Lavarropa","Acme 2",1800,null,null,272.09415584415586,0.27209415584415586,365,99.31436688311689,{"$f":"+IF(AND(F19>0,OR(F19<50,F19>1200)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},"g","Antiguedad?","Lavarropa","Acme 2",272.09415584415586,"Antiguedad?"]
["Lavavajilla","Acme 3",null,null,null,650,{"$f":"F20/1000","v":0.65},365,237.25,{"$f":"+IF(AND(F20>0,OR(F20<500,F20>1600)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?","Lavavajilla","Acme 3",650,"Antiguedad?"]
["Luces principles ","Las que más frecuentemente se encienden",{"$f":"5*12","v":60},40,4,{"$f":"+D21*E21","v":160},0.16,365,58.4,{"$f":"+IF(AND(F21>0,OR(F21<20,F21>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?",{"$f":"+A59","v":"Agua Cal. Sanit.(TTQ_Electrico)"},{"$f":"+B59","v":"Acme 4"},{"$f":"+I59","v":2007.5},{"$f":"+L59","v":1}]
["Luces ocacionales","Encendido especial",{"$f":"14*12","v":168},129.33333333333334,0.3,{"$f":"+D22*E22","v":38.800000000000004},3.8800000000000001E-2,365,14.162000000000001,{"$f":"+IF(AND(F22>0,OR(F22<20,F22>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?",{"$f":"+A51","v":"Cocina Electr."},{"$f":"+B51","v":"LongVie"},{"$f":"+F51","v":2500},{"$f":"+L51","v":"Antiguedad?"}]
["Luces extras","Encendido Ocacional",null,129.33333333333334,0.3,{"$f":"+D23*E23","v":38.800000000000004},{"$f":"F23/1000","v":3.8800000000000001E-2},366,{"$f":"+G23*H23","v":14.200800000000001},{"$f":"+IF(AND(F23>0,OR(F23<20,F23>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["Ventilador Techo  o Pie","xx",null,60,2,120,0.12,100,12,{"$f":"+IF(AND(F24>0,OR(D24<40,D24>150)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Ventilador Techo  o Pie","yy",null,50,2,{"$f":"+D25*E25","v":100},{"$f":"F25/1000","v":0.1},100,{"$f":"+G25*H25","v":10},{"$f":"+IF(AND(F25>0,OR(D25<40,D25>150)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["Aire Acondicionado 1","AA#",null,1200,0,0,0,100,0,{"$f":"+IF(AND(F26>0,OR(D26<500,D26>2000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Aire Acondicionado 2","AA#",null,1200,0,{"$f":"+D27*E27","v":0},{"$f":"F27/1000","v":0},100,0,{"$f":"+IF(AND(F27>0,OR(D27<500,D27>2000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Aire Acondicionado 3","AA#",null,1200,0,0,0,100,0,"",null,"Antiguedad?"]
["Aire Acondicionado 4","AA#",null,1200,2,{"$f":"+D29*E29","v":2400},{"$f":"F29/1000","v":2.4},101,{"$f":"+G29*H29","v":242.39999999999998},"",null,"Antiguedad?"]
["Estufas Electricas 1","EE #",2000,2500,0,0,0,150,0,{"$f":"+IF(AND(F30>0,OR(D30<300,D30>3000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Estufas Electricas 2","EE #",2000,2500,0,{"$f":"+D31*E31","v":0},{"$f":"F31/1000","v":0},150,0,{"$f":"+IF(AND(F31>0,OR(D31<300,D31>3000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Estufas Electricas 3","EE #",2000,2500,0,0,0,150,0,"",null,"Antiguedad?"]
["Estufas Electricas 4","EE #",2000,2500,0,0,0,150,0,"",null,"Antiguedad?"]
["PC ´s (monit+CPU)",null,40,40,2,80,0.08,365,{"$f":"+G34*H34","v":29.2},{"$f":"+IF(AND(F34>0,OR(D34<30,D34>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Laptop",null,160,154,0,0,0,365,0,{"$f":"+IF(AND(F35>0,OR(D35<30,D35>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Impresoras","Laser HP1022",50,100,3.3333333333333333E-2,3.3333333333333335,3.3333333333333335E-3,365,1.2166666666666668,{"$f":"+IF(AND(F36>0,OR(D36<30,D36>300)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["WiFi +Router",null,50,50,24,1200,1.2,365,438,{"$f":"+IF(AND(F37>0,OR(D37<15,D37>70)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Radio",null,20,12,24,288,0.28799999999999998,365,105.11999999999999,{"$f":"+IF(AND(F38>0,OR(D38<10,D38>100)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["TV 1","LG (LED 35\")",70,90,2,180,0.18,365,65.7,{"$f":"+IF(AND(F39>0,OR(D39<15,D39>140)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["TV 2","Samsung (30\")",70,0,2,{"$f":"+D40*E40","v":0},{"$f":"F40/1000","v":0},366,{"$f":"+G40*H40","v":0},{"$f":"+IF(AND(F40>0,OR(D40<15,D40>140)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["TV 3","Acme 0",70,0,2,0,0,367,0,"",null,"Antiguedad?"]
["TV 4","Acme 1",70,0,2,0,0,368,0,"",null,"Antiguedad?"]
["TV 5","Acme 2",70,0,2,0,0,369,0,{"$f":"+IF(AND(F43>0,OR(D43<2,D43>60)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["TV Stand By"," (todos) ",0.35,0,24,{"$f":"+D44*E44","v":0},{"$f":"F44/1000","v":0},365,{"$f":"+G44*H44","v":0},{"$f":"+IF(AND(F44>0,OR(D44<2,D44>60)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["DVD ","(panasonic S 700)",15,15,0.5,7.5,7.4999999999999997E-3,365,2.7374999999999998,{"$f":"+IF(AND(F45>0,OR(D45<15,D45>140)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Stand By Teléfono","Acme 0",5,5,24,120,0.12,365,43.8,{"$f":"+IF(AND(F45>0,OR(D45<15,D45>140)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Stand By otros","Acme 1",3,3,24,72,7.1999999999999995E-2,365,26.279999999999998,"",null,"Antiguedad?"]
["TV-Cable  (modulo)","Acme 2",12,6,24,144,0.14399999999999999,365,52.559999999999995,"",null,"Antiguedad?"]
["Secador Pelo","Acme 3",300,300,{"$f":"1/60","v":1.6666666666666666E-2},5,5.0000000000000001E-3,365,1.825,{"$f":"+IF(AND(F49>0,OR(D49<200,D49>2000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Plancha","Acme 4",1000,900,0.35,315,0.315,365,114.97499999999999,{"$f":"+IF(AND(F50>0,OR(D50<200,D50>2000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Cocina Electr.","LongVie",null,2500,1,2500,2.5,365,912.5,{"$f":"+IF(AND(F51>0,OR(D51<700,D51>5000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Microondas","Phillips",null,900,1,900,0.9,365,328.5,{"$f":"+IF(AND(F52>0,OR(D52<500,D52>1500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Tostador","Liliana",null,750,1,750,0.75,365,273.75,{"$f":"+IF(AND(F53>0,OR(D53<500,D53>1500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Batidora","Acme 1",25,25,1,25,2.5000000000000001E-2,365,9.125,{"$f":"+IF(AND(F54>0,OR(D54<20,D54>600)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Cafetera","Acme 0",null,1500,0.2,300,0.3,365,109.5,{"$f":"+IF(AND(F55>0,OR(D55<500,D55>2000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Pava Electrica","Acme 1",null,1200,0.3,360,0.36,366,131.76,{"$f":"+IF(AND(F56>0,OR(D56<500,D56>2200)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Dispenser Agua","Acme 2",null,null,null,1230,1.23,365,448.95,{"$f":"+IF(AND(F57>0,OR(F57<500,F57>2800)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,"Antiguedad?"]
["Horno Electrico","Acme 3",null,1500,0.25,375,{"$f":"F58/1000","v":0.375},366,137.25,{"$f":"+IF(AND(F58>0,OR(D58<500,D58>2500)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["Agua Cal. Sanit.(TTQ_Electrico)","Acme 4",null,null,null,5500,5.5,365,2007.5,{"$f":"+IF(AND(F59>0,OR(F59<1000,F59>6000)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""},null,1]
["Bomba Agua",null,null,240,1,{"$f":"+D60*E60","v":240},0.24,365,87.6,{"$f":"+IF(AND(F60>0,OR(F60<400,F60>800)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":" Ojo Valor muy Raro, Revisar"},null,"Antiguedad?"]
["Otros 1(Plancha para el pelo)",null,200,200,{"$f":"1/60","v":1.6666666666666666E-2},{"$f":"+D61*E61","v":3.3333333333333335},3.3333333333333335E-3,365,1.2166666666666668,null,null,"Antiguedad?"]
["Otros 2 (aspiradora)",null,null,20,24,{"$f":"+D62*E62","v":480},0.48,365,175.2,null,null,"Antiguedad?"]
["Otros 3",null,null,20,24,{"$f":"+D63*E63","v":480},0.48,365,175.2,null,null,"Antiguedad?"]
["Otros 4",null,null,20,24,{"$f":"+D64*E64","v":480},{"$f":"F64/1000","v":0.48},366,{"$f":"+G64*H64","v":175.68},null,null,"Antiguedad?"]
["Otros 5",null,null,0,24,0,0,367,0,null,null,"Antiguedad?"]
["Otros 6",null,null,0,24,0,0,368,0,null,null,"Antiguedad?"]
["Otros 7",null,null,0,24,0,0,369,0,null,null,"Antiguedad?"]
["Otros 8",null,null,0,24,0,0,370,0,null,null,"Antiguedad?"]
["Otros 9",null,null,0,24,0,0,371,0,null,null,"Antiguedad?"]
["Otros 10",null,null,0,24,0,0,372,0,null,null,"Antiguedad?"]
["Otros 11 ",null,null,0,24,0,{"$f":"F71/1000","v":0},365,{"$f":"+G71*H71","v":0},null,null,"Antiguedad?"]
["Extras",null,null,0,24,null,{"$f":"F72/1000","v":0},365,{"$f":"+G72*H72","v":0},null,null,"Antiguedad?"]
["Total - auditoria",null,null,null,null,null,null,null,null,null,"Diferencia"]
["Todos los consumo electrico - Medición",null,null,null,null,{"$f":"SUM(F15:F72)","v":21817.860822510822},{"$f":"SUM(G15:G71)","v":21.817860822510827},null,{"$f":"SUM(I15:I71)","v":7272.8730002164502},null,{"$f":"+(I74-I75)/I75","v":2.6057873079903073}]
["Total - Facturación",null,null,null,null,null,"Según Factura Luz",null,{"$f":"+K112","v":2017}]
[null,null,null,null,null,null,null,null,{"$f":"+Vivienda!Q4","v":2017}]
["Cons. Electr./Total=",{"$f":"+I75/C109","v":0.13366296802016112},null,null,null,null,null,"Refrigeración:",{"$f":"+SUM(I24:I29)","v":264.39999999999998},{"$f":"+I77/I74","v":3.6354271550201836E-2}]
[{"$f":"+A77&ROUND(100*B77,1)&\"  %\"","v":"Cons. Electr./Total=13.4  %"},null,null,null,null,null,null,"Calefacción:",{"$f":"+SUM(I30:I33)+C107","v":3199.8132833333229}]
[null,null,null,null,null,null,"[kWh]","AT",{"$f":"+I77+I78","v":3464.213283333323},"AT:"]
["Resumen eléctrico","[kWh]","[kWh]",null,null,null,null,{"$f":"+C81","v":"Consumo Annual [kWh]"},"AT=  ",{"$f":"+I79/Area_eff","v":57.736888055555383},"  kWh/m2.año","# personas",{"$f":"+J7","v":4},{"$f":"+Vivienda!$M$11","v":4}]
["Aterfacto",{"$f":"+G13","v":"Consumo diario"},{"$f":"+I13","v":"Consumo Annual [kWh]"},null,null,null,"Calef. GAS",{"$f":"C107","v":3199.8132833333229},{"$f":"+I80&ROUND(J80,1)&K80","v":"AT=  57.7  kWh/m2.año"},null,null,"Calculo de ACS","Minimo"]
["Heladera",{"$f":"+G14+G15+G16+G17+G18","v":2},{"$f":"+I14+I15+I16+I17+I18","v":730},null,null,null,"Calef._EE",{"$f":"+SUM(I29:I33)","v":242.39999999999998},null,null,null,"Consumo de ACS",{"$f":"+M80*45","v":180},{"$f":"+M82","v":180}]
["Lavarropa (Vaj.)",{"$f":"+G20+G19","v":0.92209415584415588},{"$f":"+I19+I20","v":336.56436688311692},null,null,null,"Calef_Total",{"$f":"+H81+H82","v":3442.213283333323},null,null,null,"DT=",25,25]
["Iluminacion",{"$f":"+G21+G22+G23","v":0.23760000000000001},{"$f":"+I21+I22+I23","v":86.762799999999999},null,null,null,{"$f":"A105","v":"ACS_Gas"},{"$f":"C105","v":986.22159999999678},null,null,null,"eff=",0.95,0.97]
["Refr.Calf. AA",{"$f":"+G22+G24+G25+G26+G27+G28+G29","v":2.6587999999999998},{"$f":"+I24+I25+I26+I27+I28+I29","v":264.39999999999998},null,null,null,{"$f":"A106","v":"Piloto_GN"},{"$f":"C106","v":1973.5245833333272},null,null,null,"Q(kcal/d)=",{"$f":"+M82*M83/M84","v":4736.8421052631584},{"$f":"+N82*N83/N84","v":4639.1752577319585}]
["Calef. Electr.",{"$f":"G30+G31+G32+G33","v":0},{"$f":"I30+I31+I32+I33","v":0},null,null,null,{"$f":"A104","v":"Cocción_Gas"},{"$f":"C104","v":1657.7606499999949},null,null,null,"Q(kWh/d)=",{"$f":"+M85*10.8/9300","v":5.5008488964346363},{"$f":"+N85*10.8/9300","v":5.3874293315596944},{"$f":"+(M85/M80)*10.8/9300","v":1.3752122241086591},{"$f":"+(N85/N80)*10.8/9300","v":1.3468573328899236}]
["Microonda",{"$f":"+G52","v":0.9},{"$f":"+I52","v":328.5},null,null,null,{"$f":"+A95","v":"Cocina_EE"},{"$f":"+C95","v":912.5},null,null,null,"Q_Pasivo(kWh/dia)=",2.5,0.97,null,null,"Si desenchufa despues de"]
["Cafetera+Tostadora + batidora",{"$f":"+G55+G53+G54+G56","v":1.4350000000000001},{"$f":"+I55+I53+I54+I56","v":524.13499999999999},null,null,null,{"$f":"+A97","v":"ACS_EE"},{"$f":"+C97","v":2007.5},null,null,null,"Q_total (kWh/día)",{"$f":"+M86+M87","v":8.0008488964346363},{"$f":"+N86+N87","v":6.3574293315596941},null,null,"ducharse"]
["Informatica",{"$f":"+G37+G36+G35+G34","v":1.2833333333333334},{"$f":"+I37+I36+I35+I34","v":468.41666666666663},null,null,null,{"$f":"A96","v":"Horno Electr."},{"$f":"C96","v":137.25},null,null,null,null,null,null,null,null,"Si no desenchufa"]
["TV+Radio_Electr.",{"$f":"+G39+G38+G40+G41+G42+G43+G44+G45","v":0.47549999999999998},{"$f":"+I38+I39+I40+I41+I42+I43+I44+I45","v":173.5575},null,null,null,{"$f":"A82","v":"Heladera"},{"$f":"C82","v":730},null,null,null,"Calculo de ACS","Mejorado",null,{"$f":"+n_pers","v":4},"persinas"]
["Stand By",{"$f":"+G46+G47+G48","v":0.33599999999999997},{"$f":"+I46+I47+I48","v":122.63999999999999},null,null,null,{"$f":"+A85","v":"Refr.Calf. AA"},{"$f":"C85","v":264.39999999999998},null,null,null,"Personas","Equipo \"C\"","Equipo \"A\"","Equipo \"C\"","Equipo \"A\""]
["Secador Pelo",{"$f":"+G49","v":5.0000000000000001E-3},{"$f":"+I49","v":1.825},null,null,null,{"$f":"A83","v":"Lavarropa (Vaj.)"},{"$f":"C83","v":336.56436688311692},null,null,null,"ACS","Consumo Mínimo por personas",null,null,null,null,null,null,null,null,null,"Consumo de ACS - TTQ Eléctricos"]
["Plancha",{"$f":"+G50","v":0.315},{"$f":"+I50","v":114.97499999999999},null,null,null,{"$f":"A84","v":"Iluminacion"},{"$f":"C84","v":86.762799999999999},null,null,null,{"$f":"+M80","v":4},{"$f":"+$L$93&\" \"&$L$91","v":"4 Personas"},{"$f":"+M93","v":"4 Personas"},{"$f":"+n_pers","v":4},{"$f":"+n_pers","v":4},"personas",null,null,null,null,null,"Equipo\nClase C","Equipo \nClase A"]
["Bomba",{"$f":"+G60","v":0.24},{"$f":"+I60","v":87.6},null,null,null,"Calef.EE.",{"$f":"C86","v":0},null,null,null,"DT=",25,{"$f":"+M94","v":25},{"$f":"+N94","v":25},{"$f":"+O94","v":25},25,null,null,null,null,"N0 Personasa","Consumo (kWh/día)","Consumo (kWh/día)"]
["Cocina_EE",{"$f":"+G51","v":2.5},{"$f":"+I51","v":912.5},8,1,{"$f":"+E95+D95","v":9},{"$f":"A90","v":"TV+Radio_Electr."},{"$f":"C90","v":173.5575},null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"+$M$100+$V95*$O$86","v":4.8752122241086591},{"$f":"+$N$100+V95*$P$86","v":2.3168573328899233}]
["Horno Electr.",{"$f":"+G57","v":1.23},{"$f":"+I58","v":137.25},"Calefacción","Refrigeración",null,{"$f":"A91","v":"Stand By"},{"$f":"C91","v":122.63999999999999},null,null,null,"Vol_Agua",50,{"$f":"+M96","v":50},{"$f":"+O93*M96","v":200},{"$f":"+P93*N96","v":200},{"$f":"+P96","v":200},"litros/dia","Equipo \"D\"","Equipo \"A\"",null,2,{"$f":"+$M$100+$V96*$O$86","v":6.2504244482173181},{"$f":"+$N$100+V96*$P$86","v":3.6637146657798469}]
["ACS_EE",{"$f":"+G59","v":5.5},{"$f":"+I59","v":2007.5},{"$f":"+(D95/$F$95)*$C$97","v":1784.4444444444443},{"$f":"+(E95/$F$95)*$C$97","v":223.05555555555554},{"$f":"+E97+D97","v":2007.5},"Cafet.PavaEE",{"$f":"C88","v":524.13499999999999},null,null,null,"Eff=",0.95,0.97,0.95,0.97,null,null,null,null,null,3,7.6256366723259772,5.0105719986697705]
["Otros",{"$f":"+G62+G61+G63+G64+G65+G66+G71+G67+G68+G69+G70","v":1.4433333333333334},{"$f":"+I61+I62+I63+I64+I65+I66+I67+I68+I69+I70+I71+I57","v":976.24666666666667},null,null,null,{"$f":"A89","v":"Informatica"},{"$f":"C89","v":468.41666666666663},null,null,null,"Q_ACS(kcal/d)=",{"$f":"+$L$93*M94*M96/M97","v":5263.1578947368425},{"$f":"+L93*N94*N96/N97","v":5154.6391752577319},{"$f":"+M98*n_pers","v":21052.63157894737},{"$f":"+N98*n_pers","v":20618.556701030928},null,{"$f":"+N94","v":25},null,null,null,4,9.0008488964346363,6.3574293315596941]
["Extras",{"$f":"G72","v":0},{"$f":"I72","v":0},null,null,null,{"$f":"A87","v":"Microonda"},{"$f":"C87","v":328.5},null,null,null,"Q_ACS(kWh/d)=",{"$f":"+M98*10.8/9300","v":6.1120543293718175},{"$f":"+N98*10.8/9300","v":5.9860325906218828},{"$f":"+O98*10.8/9300","v":24.44821731748727},{"$f":"+P98*10.8/9300","v":23.944130362487531},null,null,null,null,null,5,10.376061120543294,7.7042866644496177]
["TOTAL",{"$f":"SUM(B82:B98)","v":21.481660822510825},{"$f":"SUM(C82:C98)","v":7272.8730002164493},null,null,null,{"$f":"A92","v":"Secador Pelo"},{"$f":"C92","v":1.825},null,null,null,"Q_Mant(kWh/d)=",3.5,0.97,{"$f":"+M100","v":3.5},{"$f":"+N100","v":0.97},null,{"$f":"+M96*O93","v":200},{"$f":"+R100","v":200},"litros/dia",null,6,11.751273344651954,9.0511439973395422]
[null,null,null,null,null,null,{"$f":"A93","v":"Plancha"},{"$f":"C93","v":114.97499999999999},null,null,null,"Q_mant(m3/d)=",{"$f":"+M100/10.8","v":0.32407407407407407},{"$f":"+N100/10.8","v":8.9814814814814806E-2},{"$f":"+O100/10.8","v":0.32407407407407407},{"$f":"+P100/10.8","v":8.9814814814814806E-2},null,0.95,0.97,null,null,7,13.126485568760614,{"$f":"+$N$100+V101*$P$86","v":10.398001330229466}]
[null,"Diario","Anual",null,null,null,{"$f":"A94","v":"Bomba"},{"$f":"C94","v":87.6},null,null,null,"E_dia(KWh/d)=",{"$f":"+M99+M100","v":9.6120543293718175},{"$f":"+N99+N100","v":6.9560325906218825},{"$f":"+O99+O100","v":27.94821731748727},{"$f":"+P99+P100","v":24.91413036248753},null,null,null,null,null,8,14.501697792869273,11.744858663119389]
["Resumen GAS","[kWh]","[kWh]",null,null,null,{"$f":"A98","v":"Otros"},{"$f":"C98","v":976.24666666666667},null,null,null,"E_Tot(kWh/año)=",{"$f":"+M102*365","v":3508.3998302207133},{"$f":"+N102*365","v":2538.9518955769872},{"$f":"+O102*365","v":10201.099320882853},{"$f":"+P102*365","v":9093.6575823079493},null,{"$f":"+R98*S100/S101","v":5154.6391752577319},null,null,null,9,15.876910016977931,13.091715996009313]
["Cocción_Gas",{"$f":"'Consumo de Gas'!D27","v":4.5418099999999866},{"$f":"+'Consumo de Gas'!E27","v":1657.7606499999949},{"$f":"+G107&\"=\"& ROUND(H107,2)&\" \"&I107","v":"Total Electr.=4.22 MWh/año"},null,null,"Electrico",{"$f":"SUM(H87:H103)","v":7272.8730002164521},"kWh/año",null,null,"E_Tot_año (MWh/año)=",{"$f":"+M103/1000","v":3.5083998302207133},{"$f":"+N103/1000","v":2.5389518955769872},{"$f":"+O103/1000","v":10.201099320882854},{"$f":"+P103/1000","v":9.0936575823079497},null,{"$f":"+R103*10.8/9300","v":5.9860325906218828},null,null,null,10,17.252122241086589,14.438573328899237]
["ACS_Gas",{"$f":"'Consumo de Gas'!D28","v":2.7019769863013607},{"$f":"+'Consumo de Gas'!E28","v":986.22159999999678},{"$f":"+G108&\"=\"& ROUND(H108,1)&\" \"&I108","v":"Total Gas+Electr.=18.8 MWh/año"},null,null,"Todos (G+EE)",{"$f":"SUM(H81:H103)","v":18774.806400216414},"kWh/año",null,null,null,null,null,null,null,null,{"$f":"+N100","v":0.97},null,null,null,11,18.627334465195251,15.78543066178916]
["Piloto_GN",{"$f":"'Consumo de Gas'!D29","v":5.4069166666666497},{"$f":"+'Consumo de Gas'!E29","v":1973.5245833333272},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+P103+P104","v":9102.7512398902563},null,{"$f":"+R105/10.8","v":8.9814814814814806E-2},null,null,null,12,20.002546689303909,17.132287994679082]
["Calef._Gas",{"$f":"+C107/365","v":8.7666117351597883},{"$f":"+'Consumo de Gas'!E30","v":3199.8132833333229},null,null,null,"Total Electr.",{"$f":"SUM(H90:H103)/1000","v":4.215623000216449},"MWh/año",null,null,null,null,null,null,{"$f":"+P106*365","v":3322504.2025599438},null,{"$f":"+R104+R105","v":6.9560325906218825}]
["Otro_gas",{"$f":"+'Consumo de Gas'!D31","v":0},{"$f":"+'Consumo de Gas'!E31","v":0},null,null,null,"Total Gas+Electr.",{"$f":"SUM(H81:H103)/1000","v":18.774806400216413},"MWh/año",null,null,null,null,null,null,{"$f":"+P107/1000","v":3322.5042025599437},null,{"$f":"+R107*365","v":2538.9518955769872}]
["Consumo Totales Gas+Electricidad",{"$f":"SUM(B82:B108)","v":64.380637033149426},{"$f":"+C110+C111","v":15090.193116883092},null,null,null,"Transp.",{"$f":"+Transporte!N20+Transporte!N21","v":3.8924730732958244},"MWh/año",null,null,null,null,null,null,null,null,{"$f":"+R108/1000","v":2.5389518955769872}]
["Todo Electicidad",{"$f":"SUM(B82:B98)","v":21.481660822510825},{"$f":"SUM(C82:C98)","v":7272.8730002164493},null,null,null,"Total (T.G.EE)=",{"$f":"+H107+H108+H109","v":26.882902473728688},"MWh/año",null,null,"Poner Su factura de Electricidad  en Vivienda"]
["Total Gas",{"$f":"SUM(B104:B107)","v":21.417315388127786},{"$f":"SUM(C104:C107)","v":7817.3201166666422},null,null,"Calef.=",{"$f":"+\"Consumos total gas+electricidad\"&\" \"&E8&\" en \"&I8&\" (kWh)=\"&ROUND(C109,0)","v":"Consumos total gas+electricidad Casa en Su Lugar (kWh)=15090"}]
[null,null,null,null,null,{"$f":"+F111&ROUND(J80,1)&K80","v":"Calef.=57.7  kWh/m2.año"},null,"kWh/m2.año",null,"Annual",{"$f":"SUM(K114:K119)","v":2017},"kWh"]
[]
[null,null,null,null,null,null,null,null,1,{"$f":"+Vivienda!P6","v":"18/05"},{"$f":"+Vivienda!Q6","v":346}]
[null,null,null,null,null,null,null,null,2,{"$f":"+Vivienda!P7","v":"18/06"},{"$f":"+Vivienda!Q7","v":268}]
[null,null,null,null,null,null,null,null,3,{"$f":"+Vivienda!P9","v":"19/01"},{"$f":"+Vivienda!Q9","v":294}]
[null,null,null,null,null,null,null,null,4,{"$f":"+Vivienda!P10","v":"19/02"},{"$f":"+Vivienda!Q10","v":282}]
[null,null,null,null,null,null,null,null,5,{"$f":"+Vivienda!P11","v":"19/03"},{"$f":"+Vivienda!Q11","v":365}]
[null,null,null,null,null,null,null,null,6,{"$f":"+Vivienda!P12","v":"19/04"},{"$f":"+Vivienda!Q12","v":462}]
[null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,8,{"$f":"+Vivienda!P14","v":"19/05"},{"$f":"+Vivienda!Q14","v":400}]
[]
[]
[]
["Algunos Consumos de refenrecia",null,"Ver Tambien hoja: ",null,"Conusmos_Caract_2023",null,null,null,"Base:",{"$f":"+MIN(K114:K121)","v":268}]
[null,null,null,null,null,null,null,null,"Refrig:",{"$f":"+K112-6*J125","v":409},{"$f":"+J126/K112","v":0.20277640059494298}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"medida kW","medida W"]
[]
[null,null,null,null,null,null,null,null,null,null,null,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":"0.05","v":0.05},{"$f":"+AJ763*1000","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.01,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0900000000000001,1090]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,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":"+AH770-AH769","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,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":"+AH771-AH769","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,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":"+AH772-AH770","v":0},0]

{"sheet":"Consumo de Gas","index":3,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[43,0,43,3],[44,0,44,3],[45,0,45,3],[0,4,0,9],[2,6,2,7],[3,6,3,7],[4,6,4,7],[5,6,5,7],[7,6,7,7],[8,6,8,7]]}
["Auditoría de Gas",null,null,null,"Por favor llenar solo  los casilleros en Azul con fondo Verde",null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,"A_Total","Afect (m2)"]
[null,null,"Autor o Resposable: ",null,{"$f":"+nombre","v":"  Su Nombre"},null,"Superficie Cubierta (m2)",null,{"$f":"+Area_v","v":67},{"$f":"+area_ef","v":60},"Superficie efectivamente calefaccionada"]
[null,null,"e:mail:",null,{"$f":"+Vivienda!C6","v":"mail@unsam.edu.ar"},null,"Número de personas en la Vivienda",null,{"$f":"+n_pers","v":4},{"$f":"+K1/100","v":0.65}]
[null,null,"Fecha de ensayo:",null,{"$f":"+Vivienda!C5","v":"  Su Nombre"},null,"Dirección vivienda",null,{"$f":"+Vivienda!F10","v":"Italia xxx"}]
[null,null,"Tipo de vivienda",null,{"$f":"+Vivienda!C9","v":"Casa"},null,"Localidad:",null,{"$f":"+Vivienda!F11","v":"Su Lugar"}]
[null,null,"Duracion del Invierno (días)",null,120,"AMBA"]
[null,null,"Como calienta el ACS","(calefon, Termot.Cald.)",{"$f":"+Vivienda!D17","v":"TERMO"},"Solo Equip. a gas","Estufas (Número de estufas a gas)",null,{"$f":"+N_est","v":2}]
[null,null,"Antiguedad del Equip de  ACS ( # de Años)",null,null,null,"Estufas (Potencia  Total)",null,null,"(kCal/h)"]
[null,null,null,"\\",{"$f":"\"Consumo de Gas\"&\" =\"&C25&\" m3/año\"","v":"Consumo de Gas =727.9 m3/año"},null,null,null,80]
[{"$f":"\"Consumo de Gas\"&\" =\"&ROUND(E44/1000,2)&\" MWh/año\"&\" =\"&C25&\" m3/año\"","v":"Consumo de Gas =7.82 MWh/año =727.9 m3/año"},null,null,null,"cocc.+ACS+Pil.","Calef.","Horas de uso",null,40]
[null,null,"Dias en un bimestre",{"$f":"365/6","v":60.833333333333336},null,{"$f":"+AVERAGE(F19:F21)","v":0.44969863013698613},null,"Base=",{"$f":"+I10*(I14/100)","v":72}]
[]
["Su sistema de calentamieto de agua tiene Piloto? Cuantos?",null,null,null,null,{"$f":"+N_pil","v":1},{"$f":"+I12","v":72},null,90]
["Bimestre","Bimestre","(m3/bimestre)","diario","base (diario)","Calefacción (m3/día)","base (bim)","Calefacción (Bim)","Base(Nominal)","Base Nominal)"]
["ener-febr",1,{"$f":"+G62","v":162.22},{"$f":"+C16/$D$12","v":2.6666301369863015},{"$f":"+G16/$D$12","v":1.1835616438356165},{"$f":"+IF(D16>E16,D16-E16,0)","v":1.483068493150685},{"$f":"+IF(C16<$G$14,C16,$G$14)","v":72},{"$f":"+IF(C16>G16,C16-G16,0)","v":90.22},{"$f":"+I12","v":72},{"$f":"+I16/$D$12","v":1.1835616438356165}]
["Mar-Abr",2,{"$f":"+G63","v":166.5},2.7369863013698628,1.1835616438356165,{"$f":"+IF(D17>E17,D17-E17,0)","v":1.5534246575342463},{"$f":"+IF(C17<$G$14,C17,$G$14)","v":72},{"$f":"+IF(C17>G17,C17-G17,0)","v":94.5},{"$f":"+I16","v":72},{"$f":"+J16","v":1.1835616438356165}]
["Mayo-Jun",3,101.11,1.6620821917808219,1.1835616438356165,0.47852054794520549,72,29.11,{"$f":"+I17","v":72},1.1835616438356165]
["Jul-Agos",4,75.13,1.2350136986301368,1.1835616438356165,5.1452054794520308E-2,72,3.1299999999999955,72,{"$f":"+J18","v":1.1835616438356165}]
["Sept-Oct",5,100.37,1.6499178082191781,1.1835616438356165,0.46635616438356164,72,28.370000000000005,72,1.1835616438356165]
["Nov-Dic",6,122.57,2.014849315068493,1.1835616438356165,0.8312876712328765,72,50.569999999999993,72,1.1835616438356165]
["ener-febr",1,181.67,2.9863561643835612,1.1835616438356165,1.8027945205479448,72,109.66999999999999,72,1.1835616438356165]
["TOTALES",{"$f":"+G23+H23","v":727.9},{"$f":"SUM(C16:C21)","v":727.90000000000009},null,null,null,{"$f":"SUM(G16:G21)","v":432},{"$f":"SUM(H16:H21)","v":295.89999999999998}]
[null,"Equivalencia","1 m3 (GN)",10.813833333333299,"Kwh "]
["Total Anual",null,{"$f":"SUM(C16:C21)","v":727.90000000000009},null,"base-piloto=",{"$f":"+E16-C29","v":0.68356164383561646},"Observaciones"]
[null,"m3/año","m3/día","kWh /dia","kWh/Año"]
["Cocción",{"$f":"365*C27","v":153.30000000000001},{"$f":"+IF(I4>2,0.22+0.1*(I4-2),0.22)","v":0.42000000000000004},{"$f":"$D$24*C27","v":4.5418099999999866},{"$f":"$D$24*B27","v":1657.7606499999949},{"$f":"+Vivienda!M12","v":4.3999999999999995},{"$f":"+IF(AND(D27>0,OR(D27<F27*0.7,D27>F27*1.3)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["ACS_GN",{"$f":"+G23-B27-B29-B32","v":91.199999999999989},{"$f":"+B28/365","v":0.24986301369863009},{"$f":"$D$24*C28","v":2.7019769863013607},{"$f":"$D$24*B28","v":986.22159999999678},{"$f":"+Vivienda!J27","v":5.5008488964346363},{"$f":"+IF(AND(D28>0,OR(D28<F28*0.7,D28>F28*1.3)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":" Ojo Valor muy Raro, Revisar"}]
["Piloto",{"$f":"365*C29","v":182.5},{"$f":"+F14*0.5","v":0.5},{"$f":"$D$24*C29","v":5.4069166666666497},{"$f":"$D$24*B29","v":1973.5245833333272},null,{"$f":"+IF(AND(D29>0,OR(D29>7)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["Calef.",{"$f":"+H23","v":295.89999999999998},{"$f":"+B30/d_inv","v":2.4658333333333333},{"$f":"$D$24*C30","v":26.665110694444362},{"$f":"$D$24*B30","v":3199.8132833333229},{"$f":"+Area_v*80","v":5360},{"$f":"+IF(AND(E30>0,OR(E30<F30*0.5,E30>F30*1.4)), \" Ojo Valor muy Raro, Revisar\",\"\")","v":""}]
["Otro"]
["Pérdidas",{"$f":"+F32","v":5},{"$f":"+B32/365","v":1.3698630136986301E-2},null,null,5]
["TOTALES",{"$f":"SUM(B27:B31)","v":722.9},{"$f":"SUM(C27:C30)","v":3.6356963470319634},{"$f":"SUM(D27:D31)","v":39.315814347412356},{"$f":"SUM(E27:E31)","v":7817.3201166666422}]
[{"$f":"+D34&ROUND(E34,1)&F34","v":"Calef.=53.3  kWh/m2/año"},null,null,"Calef.=",{"$f":"+E30/Area_eff","v":53.330221388888717},"  kWh/m2/año"]
[null,null,"USO de ACS ",null,null,"Usar si hay sopecha de predidas "]
["Efic=",0.7,"Litros de Agua Caliente Total=",null,{"$f":"+C28*B36*9300/B37","v":65.064328767123286},"de gas "]
["DT=",25,"Litros de Agua Caliente/Pers=",null,{"$f":"+E36/I4","v":16.266082191780821},"Un indicador e un valor alto del consumo de ACS"]
[null,"Valores normales de referencia ",null,"entre","40 y 65 ","litros/día/persona"]
[{"$f":"+E39&ROUND(E37,0)&\" l/día/pers.\"","v":"Cons.ACS/pers.=16 l/día/pers."},null,null,null,"Cons.ACS/pers.="]
[]
[]
[null,"km/mes","lit/mes","kWh/mes","kWh/año"]
["Transporte",1000,{"$f":"+B43/15","v":66.666666666666671},{"$f":"9.6*C43","v":640},{"$f":"12*D43","v":7680},null,"años"]
["Gas",null,null,null,{"$f":"E33","v":7817.3201166666422}]
["Electricidad",null,null,null,{"$f":"'Consumo eléctrico'!I75","v":2017},{"$f":"+E44+E45","v":9834.3201166666422},{"$f":"\"Consumo Total \"&ROUND('Consumo de Gas'!$E$46/1000,1)&\" MWh/año\"","v":"Consumo Total 17.5 MWh/año"}]
["TOTAL",null,null,null,{"$f":"SUM(E43:E45)","v":17514.32011666664}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Poner Su factura de gas en Hoja de Viviena"]
[]
[null,null,null,null,null,"Annual=",{"$f":"+SUM(G62:G67)","v":727.90000000000009}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N63:N68)","v":659.89}]
[]
[null,null,null,null,1,{"$f":"+Vivienda!Q28","v":"21/5"},{"$f":"+Vivienda!R28","v":162.22}]
[null,null,null,null,2,{"$f":"+Vivienda!Q29","v":"21/6"},{"$f":"+Vivienda!R29","v":166.5},null,null,null,null,null,null,43]
[null,null,null,null,3,{"$f":"+Vivienda!Q30","v":"22/1"},{"$f":"+Vivienda!R30","v":101.11},null,null,null,null,null,null,135.69999999999999]
[null,null,null,null,4,{"$f":"+Vivienda!Q31","v":"22/2"},{"$f":"+Vivienda!R31","v":75.13},null,null,null,null,null,null,225.42]
[null,null,null,null,5,{"$f":"+Vivienda!Q32","v":"22/3"},{"$f":"+Vivienda!R32","v":100.37},null,null,null,null,null,null,135.53]
[null,null,null,null,6,{"$f":"+Vivienda!Q33","v":"22/4"},{"$f":"+Vivienda!R33","v":122.57},null,null,null,null,null,null,84.24]
[null,null,null,null,7,{"$f":"+Vivienda!Q34","v":"22/5"},{"$f":"+Vivienda!R34","v":181.67},null,null,null,null,null,null,36]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,56.88]

{"sheet":"Transporte","index":4,"n_rows":101,"n_cols":68,"rows_kept":101,"cut":false,"hidden":false,"merged":[[17,1,17,10],[18,1,18,10],[19,1,19,10],[21,1,21,10],[20,1,20,10]]}
[null,null,null,null,null,null,null,null,null,null,null,"Ref:",null,null,null,null,"Ref:","EPA","https://greengroundswell.com/epa-clean-power-plan-existing-power-plant-co2-emissions/2014/10/16/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g(CO2)/kWh","kWh/l o m3",null,null,"Buses CABA",null,null,"https://es.wikipedia.org/wiki/Colectivos_de_Buenos_Aires",null,null,null,"Reference:"]
[null,null,"Promedio",null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Nat\nNatural",202,10.8,"kWh/m3",null,null,null,"Ref:","https://www.infobae.com/2007/08/28/334279-el-tope-gente-que-puede-viajar-parada-colectivo/"]
["Automoviles","Transporte","Person/viaje","km/mes","km/vacaciones","km/año","km/l","kWh/km","J/m/pers","litro/año","kWh/mes","kWh/año","kg(CO2)/kWh","kg(CO2)/año","km/hora",null,"GLP",244,{"$f":"+S3*1.17","v":12.635999999999999},"kWh/kg",null,"30 litros de gasoil cada 100 kilometros",null,null,null,"Eficacia","Wh/km/pers","g(CO2)/km","Wh/km/pers","g(CO2)/km"]
["Auto1","Automivil",1,800,2000,{"$f":"+D5*12+E5","v":11600},14,{"$f":"10/G5","v":0.7142857142857143},{"$f":"3600*H5/C5","v":2571.4285714285716},{"$f":"+F5/G5","v":828.57142857142856},{"$f":"9.6*G5","v":134.4},{"$f":"+J5*$S$5","v":7931.0746666666655},0.249,{"$f":"+L5*M5","v":1974.8375919999996},null,null,"Gasolina",249,{"$f":"+S16","v":9.5719866666666658},"kWh/l",null,{"$f":"100/30","v":3.3333333333333335},"km/litro",null,20,"Pasajeros/Bus",{"$f":"1000/Y6","v":160.65519166666664},{"$f":"+(AA5/1000)*$R$9","v":42.894936174999991},11.111111111111111,2.9666666666666668,"Bus Urb"]
["Auto2","Automivil",1,null,null,null,10,{"$f":"10/G6","v":1},{"$f":"3600*H6/C6","v":3600},{"$f":"+F6/G6","v":0},{"$f":"9.6*G6","v":96},{"$f":"+J6*$S$5","v":0},0.249,{"$f":"+L6*M6","v":0},null,null,"Biodiesel",255,{"$f":"8248*10.8/9300","v":9.5783225806451622},"kWh/l",null,"Por pasajero",{"$f":"+V5*Y5","v":66.666666666666671},"km/litro",{"$f":"+W6/$S$9","v":6.2245109518454722},"km/kWh"]
["Auto3","Automivil",1,null,null,null,10,{"$f":"10/G7","v":1},{"$f":"3600*H7/C7","v":3600},{"$f":"+F7/G7","v":0},{"$f":"9.6*G7","v":96},{"$f":"+J7*$S$5","v":0},0.249,{"$f":"+L7*M7","v":0},null,null,"Kerosene",259,{"$f":"+S17","v":10.401047222222223},"kWh/l",null,{"$f":"100/20","v":5},"km/litro",null,20,"Pasajeros/Bus Urb",{"$f":"1000/Y8","v":107.10346111111112},{"$f":"+(AA7/1000)*$R$9","v":28.596624116666668},16.666666666666668,4.45,"Bus Urb"]
["SubTotal",null,null,null,null,null,null,null,{"$f":"3600*H8","v":0},{"$f":"SUM(J5:J7)","v":828.57142857142856},{"$f":"SUM(K5:K7)","v":326.39999999999998},{"$f":"SUM(L5:L7)","v":7931.0746666666655},null,{"$f":"SUM(N5:N7)","v":1974.8375919999996},null,null,"Petróleo",264,{"$f":"+S14","v":10.805693888888889},"kWh/l",null,"Por pasajero",{"$f":"+V7*Y7","v":100},"km/litro",{"$f":"+W8/$S$9","v":9.3367664277682074},"km/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gasoil",267,{"$f":"+S18","v":10.710346111111111},"kWh/l",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://en.wikipedia.org/wiki/Energy_efficiency_in_transport"]
[null,null,"Horas/semana",null,null,null,null,null,null,null,null,null,null,{"$f":"+L10*M10","v":0},null,null,"Carbón Min.",346,8.6999999999999993,"kWh/kg",null,{"$f":"100/20","v":5},"km/litro",null,40,"Pasajeros/Bus InterUr.",{"$f":"1000/Y11","v":53.551730555555558},{"$f":"+(AA10/1000)*$R$9","v":14.298312058333334},8.3333333333333339,2.2250000000000001,"Bus Inter Urb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e of transport","Energy Efficiency","Energy consumption","Average number of passengers per vehicle",null,"Energy Efficiency","Energy consumption"]
["Colectivos","Bus",5,{"$f":"+C11*O11*365/(7)","v":7821.4285714285716},null,{"$f":"+C11*O11*52.14","v":7821},{"$f":"+W6","v":66.666666666666671},{"$f":"+AA5/1000","v":0.16065519166666664},{"$f":"3600*H11","v":578.35868999999991},{"$f":"+F11/G11","v":117.315},null,{"$f":"+H11*F11","v":1256.4842540249997},{"$f":"+$R$9/1000","v":0.26700000000000002},{"$f":"+L11*M11/1000","v":0.33548129582467495},30,null,"Leña",403,5.5,"kWh/kg",null,"Por pasajero",{"$f":"+V10*Y10","v":200},"km/litro",{"$f":"+W11/$S$9","v":18.673532855536415},"km/kWh",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mpg(US) of petrol","mpg(imp) of petrol","km/L of petrol","km/MJ","W/km","m/J","L(petrol)/ 100 km","kWh/100 km","Cal/km","MJ/100 km","J/m","(m·pax)/J","(m·pax)/J","(m·pax)/J","J/(m·pax)","J/(m·pax)","W/km/pas"]
["Tren_EE","Tren",0,{"$f":"+C12*O12*365/(7)","v":0},null,{"$f":"+C12*O12*52.1428571428571","v":0},null,8.5000000000000006E-3,{"$f":"3600*H12","v":30.6},null,null,{"$f":"+H12*F12","v":0},{"$f":"+$R$13/1000","v":0.32700000000000001},{"$f":"+L12*M12","v":0},45,null,"Usina CC GN\n (CC)",550,1,"kWh (EE)","Ref:","Factores de comparación energéticos Factores de corrección de eficiencia para distintos insumos energéticos en Argentina, de P. Sinsini, J. Fiora, L. Iannelli y S.Gil- Revista Energías Renovables y Medio Ambiente, ASADES, Vol. 42, pp. 1 - 13, 2018 ISSN 0328-932X",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W/km/Pers","J/m/pas",null,"W/km/Pers","Human propelled"]
["Buses InterUrb","Bus",0,0,null,{"$f":"+C13*O13*52.1428571428571","v":0},{"$f":"+W6","v":66.666666666666671},{"$f":"+AA5/1000","v":0.16065519166666664},{"$f":"3600*H13","v":578.35868999999991},{"$f":"+F13*W8","v":0},null,{"$f":"+H13*F13","v":0},{"$f":"+$R$9/1000","v":0.26700000000000002},{"$f":"+L13*M13","v":0},60,null,"Electricidad RA\n (RA)",327,1,"kWh (EE)",null,null,null,null,null,null,{"$f":"50/34","v":1.4705882352941178},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Velomovil",5,{"$f":"+AU13*3.6","v":18},"caminar",{"$f":"+BN13/3.6","v":61.111111111111107},"Walking",null,null,null,null,4.55,4.5500000000000002E-3,null,null,"52,58[17]",22,220,1,4.5500000000000002E-3,{"$f":"1/BL13","v":219.78021978021977},220,{"$f":"+BM13/3.6","v":61.050061050061046},{"$f":"+AY13","v":"Walking"}]
["Transporte Terrestre",null,null,null,null,null,null,null,null,null,{"$f":"+A14","v":"Transporte Terrestre"},{"$f":"SUM(L11:L13)+L8","v":9187.5589206916648},null,{"$f":"SUM(N11:N13)+N8","v":1975.1730732958242},null,null,"Petróleo Crudo",{"$f":"+R8","v":264},10.805693888888889,"kWh/l"]
["Avion","Avion",null,null,null,7000,null,1.1000000000000001,{"$f":"3600*H15","v":3960.0000000000005},{"$f":"+L15/10","v":770.00000000000011},{"$f":"+A15","v":"Avion"},{"$f":"+H15*F15","v":7700.0000000000009},0.249,{"$f":"+L15*M15","v":1917.3000000000002},null,null,"Aeronaftas",null,9.3161755555555548,"kWh/l"]
["Total Transporte",null,null,null,null,null,null,null,null,null,null,{"$f":"+L14+L15","v":16887.558920691667},null,{"$f":"+N14+N15","v":3892.4730732958242},null,null,"Naftas",{"$f":"+R5","v":249},9.5719866666666658,"kWh/l"]
[null,null,null,null,null,null,null,null,null,null,null,"MWh/año",null,"Tn(CO2)/año",null,null,"Kerosene y Comb. Jets",{"$f":"+R7","v":259},10.401047222222223,"kWh/l"]
[null,"Gas",null,null,null,null,null,null,null,null,null,{"$f":"+'Consumo de Gas'!E33/1000","v":7.8173201166666422},{"$f":"+R3/1000","v":0.20200000000000001},{"$f":"+L18*M18","v":1.5790986635666617},{"$f":"+B18","v":"Gas"},null,"Gas Oil",{"$f":"+R9","v":267},10.710346111111111,"kWh/l"]
[null,"Electricidad",null,null,null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!I75/1000","v":2.0169999999999999},{"$f":"+R13/1000","v":0.32700000000000001},{"$f":"+L19*M19","v":0.65955900000000001},{"$f":"+B19","v":"Electricidad"},null,"Diesel Oil",{"$f":"+R9","v":267},10.948715555555555,"kWh/l"]
[null,"Trans. Terr.",null,null,null,null,null,null,null,null,null,{"$f":"+L14/1000","v":9.1875589206916644},null,{"$f":"+N14/1000","v":1.9751730732958241},{"$f":"+B20","v":"Trans. Terr."},null,"Fuel Oil",null,11.538243888888889,"kWh/l"]
[null,"Transp. Aereo",null,null,null,null,null,null,null,null,null,{"$f":"+L15/1000","v":7.7000000000000011},null,{"$f":"+N15/1000","v":1.9173000000000002},{"$f":"+B21","v":"Transp. Aereo"},null,"Mezcla 70-30",{"$f":"+R4","v":244},11.206852222222222,"kWh/l"]
[null,"TOTAL",null,null,null,null,null,null,null,null,null,{"$f":"SUM(L18:L21)","v":26.721879037358306},null,{"$f":"SUM(N18:N21)","v":6.1311307368624863},{"$f":"+B22","v":"TOTAL"}]
[null,null,{"$f":"+G23&ROUND(D33,1)&\" MWh/año\"","v":"Consumo de Energía=26.7 MWh/año"},null,null,null,"Consumo de Energía=",null,null,{"$f":"+G23&ROUND(L22,2)&\" MWh/año\"","v":"Consumo de Energía=26.72 MWh/año"}]
[null,null,{"$f":"+G24&ROUND(E33,1)&\" Tn(CO2)/año\"","v":"Emisiones de CO2 =6.1 Tn(CO2)/año"},null,null,null,"Emisiones de CO2 =",null,null,{"$f":"+G24&ROUND(N22,2)&\"  Tn(CO2)/año\"","v":"Emisiones de CO2 =6.13  Tn(CO2)/año"}]
[null,null,null,"MWh/año","Tn(CO2/año)",null,"Consumo de Energía Anual =",null,null,{"$f":"+G25&ROUND(D33,1)&\" MWh/año\"","v":"Consumo de Energía Anual =26.7 MWh/año"}]
[null,"Transp.Auto",null,{"$f":"+(L5+L6+L7)/1000","v":7.9310746666666656},{"$f":"+(N5+N6+N7)/1000","v":1.9748375919999996}]
[null,"Tranp. Aereo",null,{"$f":"+(L15)/1000","v":7.7000000000000011},{"$f":"+(N15)/1000","v":1.9173000000000002}]
[null,"Tranp. Bus",null,{"$f":"+(L11+L13)/1000","v":1.2564842540249996},{"$f":"+(N11+N12+N13)/1000","v":3.3548129582467497E-4}]
[null,"Tranp. Tren",null,{"$f":"+(L12/1000)","v":0},{"$f":"+(N12/1000)","v":0},{"$f":"SUM(E26:E29)","v":3.8924730732958248}]
[null,"Gas",null,{"$f":"+(L18)","v":7.8173201166666422},{"$f":"+(N18)","v":1.5790986635666617}]
[null,"Electr.",null,{"$f":"+(L19)","v":2.0169999999999999},{"$f":"+(N19)","v":0.65955900000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z31","v":0},{"$f":"+AC31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z32","v":0},{"$f":"+AC32","v":0}]
[null,"Total",null,{"$f":"SUM(D26:D32)","v":26.72187903735831},{"$f":"SUM(E26:E32)","v":6.1311307368624863},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z33","v":0},{"$f":"+AC33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bicy_EE",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subte",8.3333333333333339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tranvia",8.6111111111111107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Bus",24.166666666666668]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Scoot",35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tren",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus",121]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mini_Car_EE",150]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Auto",200]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avión",354.72222222222223]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto conv.",1300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto Sport",1500]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehículos","Costo Inic."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehículo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convencional \na Gasolina",20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Convencional\n a GNC",21.2,1240,165,315.78947368421052,2.1052631578947367,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus",11,null,{"$f":"+AR51*1000/$AR$48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEV Gasolina",24,520.49240294329263,129.50971322849216,600,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Tren",24,null,{"$f":"+AR52*1000/$AR$48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HEV GNC",25,496.03146125471858,116.56739339485887,189.4736842105263,1.263157894736842,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto",44,null,{"$f":"+AR53*1000/$AR$48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEV_21",27,170,50.49,362.36842105263156,2.4157894736842103,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avion",68,null,{"$f":"+AR54*1000/$AR$48","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BEV_27",21,220,65.34,319.73684210526318,2.1315789473684212]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km/año",15000,"T_Vida(años)",15,"N_Personas",1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"``","Wh/km/pers","J/m/person"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caminar",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehículos","Costo Inic.","W2W","W2W","Combustible","Combustible",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bicy",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehículo","[Wh/km]","[g(CO2)/km]","[U$S/año]","[USD/100 km]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scooter_EE",{"$f":"+AR59*1000/3600","v":5.5555555555555554},20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m_BEV_0",10,160,47.52,227.36842105263156,2.2736842105263158,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subte",{"$f":"+AR60*1000/3600","v":8.3333333333333339},30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m_BEV_1",4,150,44.55,213.15789473684211,2.1315789473684208,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tranvia_EE",8.6111111111111107,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m_BEV_28",2,150,45,213,2.13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus_EE",24.166666666666668,87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moto Conv 150CC",2.1,289.16244607960704,71.949840682495648,222.22222222222223,2.2222222222222223,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tren",27.222222222222221,98]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moto EE",2,35,10.395000000000001,49.736842105263165,0.49736842105263168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto_EE",32.222222222222221,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bicy Conv",0.75,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus_Conv",75,270]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bicy EE",1.6,15,4.4550000000000001,21.315789473684209,0.21315789473684207,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto_Conv",105.55555555555556,380]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km/año",10000,"T_Vida(años)",10,"N_Personas",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aereo",354.72222222222223,1277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto_Sport",475,1710]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J/m/per","kWh/km/pers","Wh/km/pers","kg(CO2)/km"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"+AA75/3600","v":0},{"$f":"+AB75*1000","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Scoot",20,5.5555555555555558E-3,5.5555555555555554]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subte",30,8.3333333333333332E-3,8.3333333333333339]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tranvia",31,8.611111111111111E-3,8.6111111111111107]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Bus",87,2.4166666666666666E-2,24.166666666666668]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tren",98,2.7222222222222221E-2,27.222222222222221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE_Auto",116,3.2222222222222222E-2,32.222222222222221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maglev_Tren",169,4.6944444444444441E-2,46.944444444444443]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bus",270,7.4999999999999997E-2,75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto conv.",380,0.10555555555555556,105.55555555555556]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avión",1277,0.35472222222222222,354.72222222222223]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Auto Sport",1710,0.47499999999999998,475]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daniel Bortolin","jun.2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MJ/km","MJ/km/pasaj","Wh/km/Pasaj."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"car",0.6,0.28599999999999998,{"$f":"+AP94*1000/3.6","v":79.444444444444443}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bus",1,6.0000000000000001E-3,1.6666666666666665]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tram",5.5,0.13800000000000001,38.333333333333336]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"metro",1.3,1.2999999999999999E-2,3.6111111111111112]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"local Train",15,0.152,42.222222222222221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expre Trein",18,0.152,42.222222222222221]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aeroplane",10,9.2999999999999999E-2,25.833333333333332]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ferry",56,5.6000000000000001E-2,15.555555555555555]

{"sheet":"Tabla 1y2","index":5,"n_rows":94,"n_cols":61,"rows_kept":94,"cut":false,"hidden":false,"merged":[[17,2,21,2],[19,23,23,23],[64,2,69,2]]}
[null,null,null,null,null,null,null,"kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","kWh","MWh","MWh","MWh","MWh","kg(CO2)/MWh","kg(CO2)/MWh","kg(CO2)/MWh","kg(CO2)/MWh"]
["Vincular estas",1,{"$f":"+'Consumo eléctrico'!J6","v":"# Persona"},{"$f":"+'Consumo eléctrico'!K6","v":"Autor o Resposable: "},{"$f":"+'Consumo eléctrico'!L6","v":"Sup (m2)"},{"$f":"+'Consumo eléctrico'!M6","v":"Cond.Soc.Econ."},{"$f":"+'Consumo eléctrico'!N6","v":"# de Heladeras"},{"$f":"+'Consumo eléctrico'!O6","v":"Heladera"},{"$f":"+'Consumo eléctrico'!P6","v":"Lavarropa"},{"$f":"+'Consumo eléctrico'!Q6","v":"Iluminacion"},{"$f":"+'Consumo eléctrico'!R6","v":"Refr.Calf. AA"},{"$f":"+'Consumo eléctrico'!S6","v":"Calef. Electr."},{"$f":"+'Consumo eléctrico'!T6","v":"Microonda"},{"$f":"+'Consumo eléctrico'!U6","v":"Cafetera+Tostadora + batidora"},{"$f":"+'Consumo eléctrico'!V6","v":"TV+Radio+DVD"},{"$f":"+'Consumo eléctrico'!W6","v":"Informatica"},{"$f":"+'Consumo eléctrico'!X6","v":"Stand By"},{"$f":"+'Consumo eléctrico'!Y6","v":"Plancha"},{"$f":"+'Consumo eléctrico'!Z6","v":"Bomba"},{"$f":"+'Consumo eléctrico'!AA6","v":"Secador Pelo"},{"$f":"+'Consumo eléctrico'!AB6","v":"Horno Eléctrico"},{"$f":"+'Consumo eléctrico'!AC6","v":"Termotanq_EE"},{"$f":"+'Consumo eléctrico'!AD6","v":"Cocina_EE"},{"$f":"+'Consumo eléctrico'!AE6","v":"Otros"},{"$f":"+'Consumo eléctrico'!AF6","v":"Extras"},{"$f":"+'Consumo eléctrico'!AG6","v":"Todo Electicidad"},{"$f":"+'Consumo eléctrico'!AH6","v":"Cocción_Gas"},{"$f":"+'Consumo eléctrico'!AI6","v":"ACS_Gas"},{"$f":"+'Consumo eléctrico'!AJ6","v":"Piloto_GN"},{"$f":"+'Consumo eléctrico'!AK6","v":"Calef._Gas"},{"$f":"+'Consumo eléctrico'!AL6","v":"Otro_gas"},{"$f":"+'Consumo eléctrico'!AM6","v":"Total Gas"},{"$f":"+'Consumo eléctrico'!AN6","v":"Coccion (kWh)"},{"$f":"+'Consumo eléctrico'!AO6","v":"EE Cocina "},{"$f":"+'Consumo eléctrico'!AP6","v":"ACS (kWh)"},{"$f":"+'Consumo eléctrico'!AQ6","v":"AT"},{"$f":"+'Consumo eléctrico'!AR6","v":"Refrig.T (kWh)"},{"$f":"+'Consumo eléctrico'!AS6","v":"ACS/Pers"},{"$f":"+'Consumo eléctrico'!AT6","v":"AT/m2"},{"$f":"+'Consumo eléctrico'!AU6","v":"EE/N_pers"},{"$f":"+'Consumo eléctrico'!AV6","v":"Consumo Totales Gas+Electricidad"},{"$f":"+'Consumo eléctrico'!AW6","v":"Total Cocina (kWh)"},{"$f":"+'Consumo eléctrico'!AX6","v":"Heladera (kWh)"},{"$f":"+'Consumo eléctrico'!AY6","v":"AT (kWh)"},{"$f":"+'Consumo eléctrico'!AZ6","v":"ACS (kWh)"},{"$f":"+'Consumo eléctrico'!BA6","v":"Pasivo"},{"$f":"+'Consumo eléctrico'!BB6","v":"Casa EE"},{"$f":"+'Consumo eléctrico'!BC6","v":"Otros"},{"$f":"+'Consumo eléctrico'!BD6","v":"Todos"},{"$f":"+'Consumo eléctrico'!BE6","v":"AT/m2"},{"$f":"+'Consumo eléctrico'!BF6","v":"EE/N_pers"},{"$f":"+'Consumo eléctrico'!BG6","v":"Calef.T. (kWh)"},{"$f":"+'Consumo eléctrico'!BH6","v":"Calf/m2"},{"$f":"+'Consumo eléctrico'!BI6","v":"Electr."},{"$f":"+'Consumo eléctrico'!BJ6","v":"Gas"},{"$f":"+'Consumo eléctrico'!BK6","v":"Transp"},{"$f":"+'Consumo eléctrico'!BL6","v":"Total"},{"$f":"+'Consumo eléctrico'!BM6","v":"Electr."},{"$f":"+'Consumo eléctrico'!BN6","v":"Gas"},{"$f":"+'Consumo eléctrico'!BO6","v":"Transp"},{"$f":"+'Consumo eléctrico'!BP6","v":"Total"}]
["dos filas",{"$f":"+'Consumo eléctrico'!I7","v":"Italia xxx"},{"$f":"+'Consumo eléctrico'!J7","v":4},"GABRIELA AGUAYO Y TEDESCO",{"$f":"+'Consumo eléctrico'!L7","v":67},{"$f":"+'Consumo eléctrico'!M7","v":"B2"},{"$f":"+'Consumo eléctrico'!N7","v":1},{"$f":"+'Consumo eléctrico'!O7","v":730},{"$f":"+'Consumo eléctrico'!P7","v":336.56436688311692},{"$f":"+'Consumo eléctrico'!Q7","v":86.762799999999999},{"$f":"+'Consumo eléctrico'!R7","v":264.39999999999998},{"$f":"+'Consumo eléctrico'!S7","v":0},{"$f":"+'Consumo eléctrico'!T7","v":328.5},{"$f":"+'Consumo eléctrico'!U7","v":524.13499999999999},{"$f":"+'Consumo eléctrico'!V7","v":173.5575},{"$f":"+'Consumo eléctrico'!W7","v":468.41666666666663},{"$f":"+'Consumo eléctrico'!X7","v":122.63999999999999},{"$f":"+'Consumo eléctrico'!Y7","v":114.97499999999999},{"$f":"+'Consumo eléctrico'!Z7","v":87.6},{"$f":"+'Consumo eléctrico'!AA7","v":1.825},{"$f":"+'Consumo eléctrico'!AB7","v":137.25},{"$f":"+'Consumo eléctrico'!AC7","v":2007.5},{"$f":"+'Consumo eléctrico'!AD7","v":912.5},{"$f":"+'Consumo eléctrico'!AE7","v":976.24666666666667},{"$f":"+'Consumo eléctrico'!AF7","v":0},{"$f":"+SUM(H3:Y3)","v":7272.8730002164493},{"$f":"+'Consumo eléctrico'!AH7","v":1657.7606499999949},{"$f":"+'Consumo eléctrico'!AI7","v":986.22159999999678},{"$f":"+'Consumo eléctrico'!AJ7","v":1973.5245833333272},{"$f":"+'Consumo eléctrico'!AK7","v":3199.8132833333229},{"$f":"+'Consumo eléctrico'!AL7","v":0},{"$f":"+'Consumo eléctrico'!AM7","v":7817.3201166666422},{"$f":"+'Consumo eléctrico'!AN7","v":2707.5106499999947},{"$f":"+'Consumo eléctrico'!AO7","v":852.63499999999999},{"$f":"+'Consumo eléctrico'!AP7","v":4967.2461833333236},{"$f":"+'Consumo eléctrico'!AQ7","v":3376.168083333323},{"$f":"+'Consumo eléctrico'!AR7","v":88.045199999999994},{"$f":"+'Consumo eléctrico'!AS7","v":1241.8115458333309},{"$f":"+'Consumo eléctrico'!AT7","v":50.390568407960046},{"$f":"+'Consumo eléctrico'!AU7","v":1022.1182500541123},{"$f":"+'Consumo eléctrico'!AV7","v":15090.193116883092},{"$f":"+'Consumo eléctrico'!AW7","v":3560.1456499999949},{"$f":"+'Consumo eléctrico'!AX7","v":730},{"$f":"+'Consumo eléctrico'!AY7","v":3464.213283333323},{"$f":"+'Consumo eléctrico'!AZ7","v":2993.7215999999967},{"$f":"+'Consumo eléctrico'!BA7","v":1973.5245833333272},{"$f":"+'Consumo eléctrico'!BB7","v":1392.3413335497833},{"$f":"+'Consumo eléctrico'!BC7","v":976.24666666666667},{"$f":"+'Consumo eléctrico'!BD7","v":15090.193116883091},{"$f":"+'Consumo eléctrico'!BE7","v":51.704675870646611},{"$f":"+'Consumo eléctrico'!BF7","v":348.08533338744581},{"$f":"+'Consumo eléctrico'!BG7","v":3420.1466166666564},{"$f":"+'Consumo eléctrico'!BH7","v":51.046964427860544},{"$f":"+'Consumo eléctrico'!BI7","v":7.2728730002164497},{"$f":"+'Consumo eléctrico'!BJ7","v":7.8173201166666422},{"$f":"+'Consumo eléctrico'!BK7","v":16.887558920691667},{"$f":"+'Consumo eléctrico'!BL7","v":31.97775203757476},{"$f":"+'Consumo eléctrico'!BM7","v":2.1600432810642856},{"$f":"+'Consumo eléctrico'!BN7","v":1.5790986635666617},{"$f":"+'Consumo eléctrico'!BO7","v":4.5089782318246758},{"$f":"+'Consumo eléctrico'!BP7","v":8.2481201764556236}]
["con la hoja Consumos electricosa",{"$f":"+Vivienda!F11","v":"Su Lugar"},"# Persona","Autor o Resposable: ","Sup (m2)","Cond.Soc.Econ.","# de Heladeras","Heladera","Lavarropa","Iluminacion","Refrigeración Aire Acond.","Calefacción Electr.","Microonda","Cafetera+Tostadora + batidora","TV+Radio+DVD","Informatica","Stand By","Plancha","Bomba","Secador Pelo","Horno Eléctrico","Termotanq_EE",{"$f":"+'Consumo eléctrico'!AD6","v":"Cocina_EE"},"Otros","Extras"," ","Cocción_Gas","ACS_Gas","Piloto_GN","Calef._Gas",{"$f":"+AE2","v":"Otro_gas"},{"$f":"+AF2","v":"Total Gas"},"Coccion (kWh)","EE Cocina ","ACS (kWh)","AT","Refrig.T (kWh)","ACS/Pers","AT/m2","EE/N_pers","Consumo Totales Gas+Electricidad",{"$f":"+AP2","v":"Total Cocina (kWh)"},"Heladera (kWh)","AT (kWh)","ACS (kWh)","Pasivo","Casa EE","Otros","Todos","AT/m2","EE/N_pers",{"$f":"+AZ2","v":"Calef.T. (kWh)"},"Calf/m2","Electr.","Gas","Transp","Total","Electr.","Gas","Transp","Total"]
["DE  \"  I6 a AR7",null,{"$f":"+C3","v":4},{"$f":"+D3","v":"GABRIELA AGUAYO Y TEDESCO"},67,"B2",1,730,336.56436688311692,86.762799999999999,264.39999999999998,0,328.5,524.13499999999999,173.5575,468.41666666666663,122.63999999999999,114.97499999999999,87.6,1.825,137.25,2007.5,912.5,976.24666666666667,0,7272.8730002164493,1657.7606499999949,986.22159999999678,1973.5245833333272,3199.8132833333229,0,{"$f":"+AF3","v":7817.3201166666422},{"$f":"+AG3","v":2707.5106499999947},852.63499999999999,4967.2461833333236,3376.168083333323,88.045199999999994,1241.8115458333309,50.390568407960046,1022.1182500541123,15090.193116883092,{"$f":"+AP3","v":3560.1456499999949},730,3464.213283333323,2993.7215999999967,1973.5245833333272,1392.3413335497833,976.24666666666667,15090.193116883091,51.704675870646611,348.08533338744581,{"$f":"+AZ3","v":3420.1466166666564},51.046964427860544,7.2728730002164497,7.8173201166666422,16.887558920691667,31.97775203757476,2.1600432810642856,1.5790986635666617,4.5089782318246758,8.2481201764556236]
["El resto se acomoda solo","Tabla 1",null,null,null,null,null,null,null,null,null,null,null,null,"TRIUNVIRATO 2467",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AE2","v":"Otro_gas"},{"$f":"+AF2","v":"Total Gas"},"Coccion (kWh)","EE Cocina ","ACS (kWh)","AT","Refrig.T (kWh)","ACS/Pers","AT/m2","EE/N_pers","Consumo Totales Gas+Electricidad","Cocina T.","Helad.","Ac.Term","ACS","Pasivo","Casa_Electr.","Otros",{"$f":"+AW2","v":"Todos"},"AT/m2","EE/N_pers",{"$f":"+AZ2","v":"Calef.T. (kWh)"},"Calf/m2","Electr.","Gas","Transp","Total","Electr.","Gas","Transp","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"+'Consumo eléctrico'!AX11","v":"Cons. Total-  Su Nombre15.1 MWh/año"}]
[null,"Item",null,{"$f":"+B4","v":"Su Lugar"},null,"Modelo ","Modelo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabla 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!AU12","v":"Acond.Term.=51.7 kWh/m2.año"}]
[null,null,null,{"$f":"+B3","v":"Italia xxx"},null,"Eficiente","BAU"]
[null,"Nro. Persona",null,{"$f":"+C3","v":4},null,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item",null,{"$f":"+D8","v":"Su Lugar"},null,"Macizo",null,"Modelo ","Modelo BAU"]
[null,"Superficie Propia (m2)",null,{"$f":"+E3","v":67},null,65,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D9","v":"Italia xxx"},null,{"$f":"+BI47","v":0},null,"Eficiente"]
[null,null,null,"# de Artefactos",null,"# de Artefactos","# de Artefactos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nro. Persona",null,{"$f":"C5","v":4},null,4,null,3,3]
[null,"Nro. Heladera",null,{"$f":"+G3","v":1},null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Superficie Propia (m2)",null,{"$f":"+E5","v":67},null,150,null,65,65]
[null,"Artefactos",null,{"$f":"+D8","v":"Su Lugar"},null,"Eficiente","Modelo BAU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# de Artefactos",null,"# de Artefactos",null,"# de Artefactos","# de Artefactos"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nro. Heladera",null,{"$f":"+G5","v":1},null,2,null,1,1]
[null,"Artefactos",null,"Consumos Anuales","Observación","Consumos Anuales","Consumos Anuales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Artefactos",null,{"$f":"+Y10","v":"Su Lugar"},null,{"$f":"+AA10","v":"Macizo"},null,"Eficiente","Modelo BAU"]
[null,"Unidades",null,"kWh/año",null,"kWh/año","kWh/año"]
["TTQ_EE","Termotanq_EE","Claves",{"$f":"+V5","v":2007.5},{"$f":"+IF(D18<1.35*$F18,\"OK\", \"Excesivo\" )","v":"OK"},2500,3100,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Artefactos",null,"Consumos Anuales","Observación","Consumos Anuales","Observación","Consumos Anuales","Consumos Anuales"]
["Heladera","Heladera",null,{"$f":"+H5","v":730},{"$f":"+IF(D19<1.35*$F19,\"OK\", \"Excesivo\" )","v":"Excesivo"},{"$f":"320*D13","v":320},993.41364453227948,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unidades",null,"kWh/año",null,"kWh/año",null,"kWh/año","kWh/año"]
["Calef.EE","Calefacción Electr.",null,{"$f":"+L5","v":0},"OK",253.49387369565216,828.38980248550729,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B18","v":"Termotanq_EE"},"Claves",{"$f":"+D18","v":2007.5},{"$f":"+IF(Y20<1.35*$F30,\"OK\", \"Excesivo\" )","v":"Excesivo"},2007.5,{"$f":"+IF(AA20<1.35*$F30,\"OK\", \"Excesivo\" )","v":"Excesivo"},{"$f":"+F18","v":2500},{"$f":"+G18","v":3100}]
["Calef.+Ref.-AA","Refrigeración Aire Acond.",null,{"$f":"+K5","v":264.39999999999998},"OK",208.976,736.65431289746209,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B19","v":"Heladera"},null,{"$f":"+D19","v":730},"Excesivo",923.45,"Excesivo",{"$f":"+F19","v":320},993.41364453227948]
["Ilum.","Iluminacion",null,{"$f":"+J5","v":86.762799999999999},"Excesivo",48.55,349.48500187747044,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calefacción Electr.",null,0,"OK",null,"OK",253.49387369565216,828.38980248550729]
["TV+Radio","TV+Radio+DVD",null,{"$f":"+O5","v":173.5575},"Excesivo",63.493312500000002,287.60641666666663,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refrigeración Aire Acond.",null,264.39999999999998,"Excesivo",1298.5,"Excesivo",208.976,736.65431289746209]
["HornoEE","Horno Eléctrico",null,{"$f":"+P5","v":468.41666666666663},"Excesivo",75.655407142857143,273.31780714285713,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Iluminacion",null,86.762799999999999,"OK",41.613,"OK",48.55,349.48500187747044]
["Inform.","Informatica",null,{"$f":"+P5","v":468.41666666666663},"Excesivo",21.564330357142858,106.36361673181587,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TV+Radio+DVD",null,173.5575,"Excesivo",305.14,"Excesivo",63.493312500000002,287.60641666666663]
["Cocina_EE","Cafetera+Tost.a + batidora",null,{"$f":"+N5","v":524.13499999999999},"Excesivo",24.496040458937202,105.72973435091137,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Horno Eléctrico",null,468.41666666666663,"Excesivo",136.875,"Excesivo",75.655407142857143,273.31780714285713]
["Stand By","Stand By",null,{"$f":"+Q5","v":122.63999999999999},"Excesivo",15.8775,98.090099999999978,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Informatica",null,468.41666666666663,"OK",286.52499999999998,"OK",21.564330357142858,106.36361673181587]
["Cuid. Pers.","Secador Pelo",null,{"$f":"+T5","v":1.825},"OK",5.2921967499999996,84.958530901457735,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cafetera+Tost.a + batidora",null,524.13499999999999,"OK",237.60999999999999,"OK",24.496040458937202,105.72973435091137]
["Lavarropa","Lavarropa",null,{"$f":"+I5","v":336.56436688311692},"Excesivo",43.159199999999998,80.464201562350709,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stand By",null,122.63999999999999,{"$f":"+IF(Y29<1.35*$F41,\"OK\", \"Excesivo\" )","v":"OK"},140.16,{"$f":"+IF(AA29<1.35*$F41,\"OK\", \"Excesivo\" )","v":"OK"},15.8775,98.090099999999978]
["Microonda","Microonda",null,{"$f":"+M5","v":328.5},"Excesivo",9.8421085416666667,64.785313462962961,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secador Pelo",null,1.825,"OK",730,"OK",5.2921967499999996,84.958530901457735]
["Plancha","Plancha",null,{"$f":"+R5","v":114.97499999999999},"Excesivo",6.6400919999999992,24.264772643578645,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lavarropa",null,336.56436688311692,{"$error":"#VALUE!"},276.30500000000001,{"$error":"#VALUE!"},43.159199999999998,80.464201562350709]
["Cocina_EE","Cocina_EE",null,{"$f":"+W5","v":912.5},"OK",1700,2000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Microonda",null,328.5,"OK",255.49999999999997,"OK",9.8421085416666667,64.785313462962961]
["Otros","Otros",null,{"$f":"+X5+Y5","v":976.24666666666667},"Excesivo",159.31247724999997,200.58951221003394,{"$f":"+H34-D34","v":-243.56666666666843},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plancha",null,114.97499999999999,"Excesivo",114.97499999999999,"Excesivo",6.6400919999999992,24.264772643578645]
[null,"Todo Electicidad",null,{"$f":"+SUM(D18:D33)","v":7516.4396668831178},null,{"$f":"+SUM(F18:F33)","v":5456.3525386962565},{"$f":"+SUM(G18:G33)","v":9334.1127674653544},{"$f":"+Z5","v":7272.8730002164493},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cocina_EE",null,912.5,"OK",912.5,"OK",1700,2000]
[null,"Claves",null,{"$f":"+SUM(D18:D22)/D34","v":0.41092098611639521},null,{"$f":"+SUM(F18:F22)/F34","v":0.61048472401154041},0.64365440095536308,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otros",null,976.24666666666667,"Excesivo",526.81666666666672,"Excesivo",159.31247724999997,200.58951221003394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todo Electicidad",null,{"$f":"+SUM(Y20:Y35)","v":7516.4396668831178},null,{"$f":"+SUM(AA20:AA35)","v":8193.4696666666678},null,{"$f":"+SUM(AC20:AC35)","v":5456.3525386962565},{"$f":"+SUM(AD20:AD35)","v":9334.1127674653544}]
["Cooción","Cocción_Gas",null,{"$f":"+AA5","v":1657.7606499999949},{"$f":"+IF(D37<1.35*$F37,\"OK\", \"Excesivo\" )","v":"OK"},1650.1303249999974,1462.3864363636349,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Claves",null,{"$f":"+SUM(Y20:Y24)/Y36","v":0.41092098611639521},null,{"$f":"+SUM(AA20:AA24)/AA36","v":0.52127647672583477},null,{"$f":"+SUM(AC20:AC24)/AC36","v":0.61048472401154041},0.64365440095536308]
["Galef.","Calef._Gas",null,{"$f":"+AD5","v":3199.8132833333229},"Excesivo",{"$f":"25*F11","v":1625},{"$f":"50*G11","v":3250}]
["ACS","ACS_Gas",null,{"$f":"+AB5","v":986.22159999999678},"OK",3500,4500]
["Pas.","Pasivo",null,{"$f":"+AC5","v":1973.5245833333272},"Excesivo",0,2000]
["T_gas","Total Gas",null,{"$f":"+D37+D38+D39+D40","v":7817.3201166666422},"Excesivo",1650.1303249999974,1462.3864363636349,{"$f":"+AF5","v":7817.3201166666422},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cocción_Gas",null,{"$f":"+D37","v":1657.7606499999949},{"$f":"+IF(Y41<1.25*$H51,\"OK\", \"Excesivo\" )","v":"Excesivo"},360,{"$f":"+IF(AA41<1.25*$H51,\"OK\", \"Excesivo\" )","v":"Excesivo"},1650.1303249999974,1462.3864363636349]
[null," Totales Gas+Electr.",null,{"$f":"+D41+D34","v":15333.75978354976},null,{"$f":"+F41+F34","v":7106.4828636962538},{"$f":"+G41+G34","v":10796.499203828989},{"$f":"+AO5","v":15090.193116883092},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calef._Gas",null,{"$f":"+D38","v":3199.8132833333229},{"$f":"+IF(Y42<1.25*$H52,\"OK\", \"Excesivo\" )","v":"Excesivo"},null,null,{"$f":"25*AC13","v":1625},{"$f":"50*AD13","v":3250}]
[null,null,null,{"$f":"+D14","v":"Su Lugar"},null,{"$f":"+F14","v":"Eficiente"},{"$f":"+G14","v":"Modelo BAU"},{"$f":"+AN5","v":1022.1182500541123},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Gas",null,{"$f":"+D41","v":7817.3201166666422},null,{"$f":"+AA41+AA42","v":360},null,1650.1303249999974,1462.3864363636349]
["Calef.T","Calefaccion Tot. (kWh/año)",null,{"$f":"+D38+D20+D21*0.67","v":3376.9612833333231},{"$f":"+IF(D44<1.35*$F44,\"OK\", \"Excesivo\" )","v":"Excesivo"},{"$f":"+F38+F20+F21*0.67","v":2018.5077936956523},{"$f":"+G38+G20+G21*0.67","v":4571.948192126807},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Totales Gas+Electr.",null,{"$f":"+Y43+Y36","v":15333.75978354976},null,{"$f":"+AA43+AA36","v":8553.4696666666678},null,{"$f":"+AC43+AC36","v":7106.4828636962538},{"$f":"+AD43+AD36","v":10796.499203828989}]
["Calef. kWh/m2/año","Calef. kWh/m2/año",null,{"$f":"+D44/D11","v":50.402407213930196},"Excesivo",{"$f":"+F44/F11","v":31.05396605685619},{"$f":"+G44/G11","v":70.337664494258576},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y16","v":"Su Lugar"},null,{"$f":"+AA16","v":"Macizo"},null,{"$f":"+AC16","v":"Eficiente"},{"$f":"+AD16","v":"Modelo BAU"}]
["Eléctr. E/N_pers","Eléctr. E/N_pers",null,{"$f":"+(D34-D32-D20-D21-D18)/D10","v":1083.0099167207795},"OK",{"$f":"+(F34-F20-F21-F18)/F10","v":831.29422166686834},{"$f":"+(G34-G20-G21-G18)/G10","v":1556.356217360795},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calefaccion Tot. (kWh/año)",null,{"$f":"+Y42+Y22+Y23*0.67","v":3376.9612833333231},null,{"$f":"+AA42+AA22+AA23*0.67","v":869.995},null,{"$f":"+AC42+AC22+AC23*0.67","v":2018.5077936956523},{"$f":"+AD42+AD22+AD23*0.67","v":4571.948192126807}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calfacc. kWh/m2/año",null,{"$f":"+Y46/Y13","v":50.402407213930196},null,{"$f":"+AA46/AA13","v":5.7999666666666663},null,{"$f":"+AC46/AC13","v":31.05396605685619},{"$f":"+AD46/AD13","v":70.337664494258576}]
[null,"Todo Electicidad",null,{"$f":"+D34","v":7516.4396668831178},"Excesivo",{"$f":"+F34","v":5456.3525386962565},{"$f":"+G34","v":9334.1127674653544},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eléctr. E/N_pers",null,{"$f":"+(Y36-Y34-Y22-Y23-Y20)/Y12","v":1083.0099167207795},null,{"$f":"+(AA36-AA34-AA22-AA23-AA20)/AA12","v":993.74241666666694},null,{"$f":"+(AC36-AC22-AC23-AC20)/AC12","v":831.29422166686834},{"$f":"+(AD36-AD22-AD23-AD20)/AD12","v":1556.356217360795}]
[]
[null,null,{"$f":"+D14&\"-Cons.Eléctr.=\"&ROUND(D34/1000,1)&\" MWh/año\"","v":"Su Lugar-Cons.Eléctr.=7.5 MWh/año"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todo Electicidad",null,5286.4080000000004,null,8193.4696666666678,null,3936.584807446256,5396.5072965670852]
[null,null,null,null,{"$f":"+\"Mod.BAU -Cons.Tot.=\"&ROUND(G42/1000,1)&\" MWh/año\"","v":"Mod.BAU -Cons.Tot.=10.8 MWh/año"}]
[null,"Tabla 2",null,null,{"$f":"+\"Eficiente -Cons.Tot.=\"&ROUND(F42/1000,1)&\" MWh/año\"","v":"Eficiente -Cons.Tot.=7.1 MWh/año"}]
["Cons.Tot.=6.9  MWh/año",null,{"$f":"+D14&\"-Cons.Tot.=\"&ROUND(D42/1000,1)&\" MWh/año\"","v":"Su Lugar-Cons.Tot.=15.3 MWh/año"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y16&\"-Cons.Eléctr.=\"&ROUND(Y36/1000,1)&\" MWh/año\"","v":"Su Lugar-Cons.Eléctr.=7.5 MWh/año"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"+B8","v":"Item"},null,{"$f":"+D8","v":"Su Lugar"},null,"Modelo ","Modelo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Y16&\"-Cons.Tot.=\"&ROUND(Y44/1000,1)&\" MWh/año\"","v":"Su Lugar-Cons.Tot.=15.3 MWh/año"}]
[null,null,null,{"$f":"+D9","v":"Italia xxx"},null,{"$f":"+F9","v":"Eficiente"},{"$f":"+G9","v":"BAU"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+\"Zona \"&AA16&\"-Cons.Eléctr.=\"&ROUND(AA36/1000,1)&\" MWh/año\"","v":"Zona Macizo-Cons.Eléctr.=8.2 MWh/año"}]
[null,{"$f":"+B10","v":"Nro. Persona"},null,4,null,3,3]
[null,"Superficie Propia (m2)",null,67,null,65,65,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+\"Zona \"&AA16&\"-Cons.Tot.=\"&ROUND(AA44/1000,1)&\" MWh/año\"","v":"Zona Macizo-Cons.Tot.=8.6 MWh/año"}]
[null,null,null,{"$f":"+D12","v":"# de Artefactos"},null,{"$f":"+F12","v":"# de Artefactos"},{"$f":"+G12","v":"# de Artefactos"}]
[null,{"$f":"+B13","v":"Nro. Heladera"},null,1,null,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calf/m2",null,56.696474999999865,null,360,null,4.8761809572155412,16.379729794887947]
[null,"Artefactos",null,"Su Lugar",null,"Eficiente","Modelo BAU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE/N_pers",null,184.85199999999998,null,5.7711111111111135,null,276.55435459178136,924.13044887345211]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumo Totales Gas+Electricidad",null,11323.771149999982,null,993.74241666666694,null,2737.5,1462.3864363636349]
[null,{"$f":"+B16","v":"Artefactos"},null,"Consumos Anuales","Observación","Consumos Anuales","Consumos Anuales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Callefac.",null,{"$f":"+Y42+Y22+Y23*0.667","v":3376.168083333323},null,{"$f":"+AA42+AA22+AA23*0.667","v":866.09950000000003},null,{"$f":"+AC42+AC22+AC23*0.667","v":2017.8808656956521},{"$f":"+AD42+AD22+AD23*0.667","v":4569.738229188114}]
[null,"Unidades",null,"kWh/año",null,"kWh/año","kWh/año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calf/m2",null,{"$f":"+Y63/Y13","v":50.390568407960046},null,{"$f":"+AA63/AA13","v":5.7739966666666671},null,{"$f":"+AC63/AC13","v":31.04432101070234},{"$f":"+AD63/AD13","v":70.303665064432522}]
[null,"ACS",{"$f":"+C18","v":"Claves"},{"$f":"+D18+D39+D40","v":4967.2461833333236},{"$f":"+IF(D65<1.35*$F65,\"OK\", \"Excesivo\" )","v":"Excesivo"},{"$f":"+F18","v":2500},{"$f":"+G18","v":3100},2002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EE/N_pers",null,{"$f":"+(Y50-Y34-Y32-Y26-Y23-Y22)/Y12","v":828.14783333333344},null,{"$f":"+(AA50-AA34-AA32-AA26-AA23-AA22)/AA12","v":1397.5236666666669},null,{"$f":"+(AC50-AC34-AC32-AC26-AC23-AC22)/AC12","v":562.87247268869328},{"$f":"+(AD50-AD34-AD32-AD26-AD23-AD22)/AD12","v":497.78668685943188}]
[null,"Acond.Térmico",{"$f":"+C20","v":0},{"$f":"+D20+D21+D38","v":3464.213283333323},"Excesivo",{"$f":"+F20+F21+F38","v":2087.469873695652},{"$f":"+G20+G21+G38","v":4815.0441153829688},{"$f":"+D66","v":3464.213283333323}]
[null,"Cocción",{"$f":"+C21","v":0},{"$f":"+D32+D37","v":2570.2606499999947},"Excesivo",{"$f":"+F37","v":1650.1303249999974},{"$f":"+G37","v":1462.3864363636349},2570.2606499999947]
[null,"Art. EE. Cocina",null,{"$f":"+D24+D30+D26","v":1321.0516666666667},"Excesivo",{"$f":"+F24+F26+F30","v":109.99355614346101},{"$f":"+G24+G26+G30","v":443.83285495673147},2000]
[null,{"$f":"+B19","v":"Heladera"},null,{"$f":"+D19","v":730},"Excesivo",{"$f":"+F19","v":320},{"$f":"+G19","v":993.41364453227948},730]
[null,{"$f":"+B22","v":"Iluminacion"},{"$f":"+C22","v":0},{"$f":"+D22","v":86.762799999999999},"Excesivo",{"$f":"+F22","v":48.55},{"$f":"+G22","v":349.48500187747044},86.762799999999999]
[null,"TV+Infor.+Elect.",null,{"$f":"+D23+D25","v":641.97416666666663},"Excesivo",{"$f":"+F23+F25","v":85.057642857142866},{"$f":"+G23+G25","v":393.97003339848249},641.97416666666663]
[null,"Lavado",null,{"$f":"+D29","v":336.56436688311692},"Excesivo",{"$f":"+F29","v":43.159199999999998},{"$f":"+G29","v":80.464201562350709},1000]
[null,{"$f":"+B33","v":"Otros"},null,{"$f":"+D27+D31+D33","v":1213.8616666666667},"Excesivo",{"$f":"+F33+F27+F28+F31","v":187.12226599999997},{"$f":"+G33+G27+G28+G31","v":407.9029157550703},1213.8616666666667]
[]
[null,{"$f":"+B35","v":"Claves"},null,{"$f":"+SUM(D65:D70)/D82","v":0.85700433564531187},null,{"$f":"+SUM(F65:F70)/F82","v":0.95515325643681104},{"$f":"+SUM(G65:G70)/G82","v":0.92675572082921387}]
[]
[null,{"$f":"+B37","v":"Cocción_Gas"},null,{"$f":"+D37","v":1657.7606499999949},{"$f":"+IF(D77<=1.35*$F77,\"OK\", \"Excesivo\" )","v":"OK"},{"$f":"+F37","v":1650.1303249999974},{"$f":"+G37","v":1462.3864363636349},2000]
[null,{"$f":"+B38","v":"Calef._Gas"},null,{"$f":"+D38","v":3199.8132833333229},"Excesivo",{"$f":"+F38","v":1625},3250,2000]
[null,{"$f":"+B39","v":"ACS_Gas"},null,{"$f":"+D39","v":986.22159999999678},"OK",3500,4500,2000]
[null,{"$f":"+B40","v":"Pasivo"},null,1973.5245833333272,{"$f":"+IF(D80<=1.35*$F80,\"OK\", \"Excesivo\" )","v":"Excesivo"},0,2000,2000]
[null,"Total Gas",null,7817.3201166666422,{"$f":"+IF(D81<=1.35*$F81,\"OK\", \"Excesivo\" )","v":"Excesivo"},1650.1303249999974,1462.3864363636349,2000]
[null,{"$f":"+B42","v":" Totales Gas+Electr."},null,{"$f":"+SUM(D65:D73)","v":15331.934783549757},{"$f":"+IF(D82<1.35*$F82,\"OK\", \"Excesivo\" )","v":"Excesivo"},{"$f":"+SUM(F65:F73)","v":7031.4828636962548},{"$f":"+SUM(G65:G73)","v":12046.499203828989}]
[]
[]
[null,{"$f":"+AP6","v":"Cocina T."},null,{"$f":"+AP3","v":3560.1456499999949}]
[null,{"$f":"+AQ6","v":"Helad."},null,{"$f":"+AQ3","v":730}]
[null,{"$f":"+AR6","v":"Ac.Term"},null,{"$f":"+AR3","v":3464.213283333323}]
[null,{"$f":"+AS6","v":"ACS"},null,{"$f":"+AS3","v":2993.7215999999967}]
[null,{"$f":"+AT6","v":"Pasivo"},null,{"$f":"+AT3","v":1973.5245833333272}]
[null,{"$f":"+AU6","v":"Casa_Electr."},null,{"$f":"+AU3","v":1392.3413335497833}]
[null,{"$f":"+AV6","v":"Otros"},null,{"$f":"+AV3","v":976.24666666666667}]
[null,{"$f":"+B52","v":"Tabla 2"},null,{"$f":"+SUM(D85:D91)","v":15090.193116883091},{"$f":"+D92/1000","v":15.090193116883091},"MWh/año"]
[null,{"$f":"+'Consumo eléctrico'!$AX$11","v":"Cons. Total-  Su Nombre15.1 MWh/año"}]
[null,{"$f":"+'Consumo eléctrico'!$AU$12","v":"Acond.Term.=51.7 kWh/m2.año"}]

{"sheet":"Consumos_Carct._2023","index":6,"n_rows":137,"n_cols":48,"rows_kept":137,"cut":false,"hidden":false,"merged":[[50,15,50,21]]}
[null,"Consumos por rubro",null,null,null,null,null,null,null,"Comparacion de los consumos medidos con loa más eficientes",null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumos por Equipo","Consumo por horas de uso",null,null,null,null,null,"Consumos por Equipo","Consumo por dia y prestación"]
[null,null,null,null,null,null,null,null,null,null,null,"costo gas Nat.=",{"$f":"+M3/10.8","v":2.3148148148148149},"$/kWh"]
[null,null,null,null,null,null,null,null,null,null,null,"costo gas Nat.=",25,"$/m3"]
[null,null,null,null,null,null,null,null,null,"Tabla 1- Comparación",null,"costo electr.=",15,"$/kWh",null,null,null,null,null,null,null,null,null,"Valores de referencia con una incerteza del 20%",null,null," incerteza     20%"]
[null,"Categoria general",null,null,null,null,2019,null,null,"Copia simple de Hoja \"Cons. Electr.\"",null,null,null,null,null,null,"Tabla 2- Comparación",null,null,null,null,null,null,null,"Potencia (W)","Horas/día","kWh/Año","kWh/Año",null,null,null,"Consumo Diario","Consumo Annual"]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","kWh/año","kWh/año",null,"Comparacion de los consumos medidos con loa más eficientes",null,null,null,null,null,"Comparacion de los consumos medidos con loa más eficientes",null,null,null,null,null,null,null,"TV(LED y LSD)",26,4,{"$f":"+Y6*Z6*365/1000","v":37.96},30,null,null,"Valores de referencia con una incerteza del 20%",null,null,null,null,null,null,"4 hs/dia/año"]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio","Eficiente",null,"Equipo o servicio","Consumos medidos","Consumos eficientes","Posibilidad de ahorro (kWh/año)","Conviene cambiar o ahorro porencial $/año",null,"Equipo o servicio","Consumos medidos [kWh/año]","Consumos eficientes  [kWh/año]","Posibilidad de ahorro  [kWh/año]"," Ahorro estimado en [ $/año]","Años de amorizacion","Conviene cambiar o eficientizar el consumo?",null,"TV (Tubos)",66,4,{"$f":"+Y7*Z7*365/1000","v":96.36},30,null,null,null,"Wh/día","kWh/año",null,null,null,"W","kWh/año"]
[null,"Heladera",361.11275000000001,598.18025,834.86085000000003,1800.17635,860.65497011116645,300,null,null,null,null,null,null,null,"Heladera A",730,300,430,6450,{"$f":"+IF(T8>0,V8/T8,\"\")","v":15.503875968992247},100000,null,null,null,null,null,null,null,null,"Heladeras ( Mas de 20 años)",{"$f":"+AG8*1000/365","v":3835.6164383561645},1400,null,null,"TV_LED_32\"",43,63,{"$f":"+AK8*4*0.365","v":62.78}]
[null,"AA-Refrigeración",40.848260869565223,215.14826086956523,570.87249999999995,2476.8225000000002,647.43321257889158,215.14826086956523,null,{"$f":"+'Consumo eléctrico'!A15","v":"Heladera A"},{"$f":"+'Consumo eléctrico'!I15","v":730},300,{"$f":"+IF(K9>1.1*L9,K9-L9,0)","v":430},{"$f":"+IF(M9>1,M9*p_kwh,)","v":6450},null,"Heladera  B",0,300,0,0,{"$f":"+IF(T9>0,V9/T9,\"\")","v":""},100000,null,null,null,null,null,null,null,null,"Heladeras ( Mas de10 años)",{"$f":"+AG9*1000/365","v":2739.7260273972602},1000,null,null,"TV_LED_44\"",44.2,64.5,{"$f":"+AK9*4*0.365","v":64.531999999999996}]
[null,"Ilumin.",74.936324999999997,189.50982500000001,372.41634375000001,2499.6728437500001,416.25964705815971,85,null,{"$f":"+'Consumo eléctrico'!A16","v":"Heladera  B"},{"$f":"+'Consumo eléctrico'!I16","v":0},300,0,0,null,"Heladera  C",0,300,0,0,"",100000,null,"Ahorros Agua",null,null,null,null,null,null,"Heladeras ( Mas de 5 años)",2328.7671232876714,850,null,null,"TV_LED_66\"",103,151,150.38]
[null,"Lavavajilla",0,80,120,370,130,90,null,{"$f":"+'Consumo eléctrico'!A17","v":"Heladera  C"},{"$f":"+'Consumo eléctrico'!I17","v":0},300,0,0,null,"Lavarropa",99.31436688311689,50,49.31436688311689,739.71550324675331,135.18710850466269,100000,null,"ACS_E (calefon)",null,null,null,null,null,null,"Heladeras C",1643.8356164383561,600,null,null,"TV_LED_66\"",107,156,156.22]
[null,"Cale.E.",0.74825000000000008,59.402163043478261,213.11016304347828,1060.3062500000001,289.04725830406909,59.402163043478261,null,{"$f":"+'Consumo eléctrico'!A19","v":"Lavarropa"},{"$f":"+'Consumo eléctrico'!I19","v":99.31436688311689},50,49.31436688311689,739.71550324675331,null,"Lavavajilla",164.25,90,74.25,1113.75,{"$f":"+IF(T12>0,V12/T12,\"\")","v":89.786756453423124},100000,null,null,null,null,null,null,0.15,null,"Heladeras B",1232.8767123287671,450,null,null,"TV_LED_50\"",63,92,91.98]
[null,"Inform.",52.775350000000003,124.64750000000001,251.05749374999999,1166.8424937499999,273.22605854316248,124.64750000000001,null,{"$f":"+'Consumo eléctrico'!A20","v":"Lavavajilla"},{"$f":"+'Consumo eléctrico'!I20","v":237.25},90,147.25,2208.75,null,"Luces principles ",69.958333333333343,60,9.9583333333333428,149.37500000000014,6.6945606694560604,1000,null,"TV y Video","Potencia (W)","Horas/día","Consumo Por año (kWh)",null,null,null,"Heladeras A",931.50684931506851,340,null,null,null,null,null,0]
[null,"TV+Radio+Electr.",58.783250000000002,161.43950000000001,266.72375,654.37200000000007,253.04223080046506,161.43950000000001,null,{"$f":"+'Consumo eléctrico'!A21","v":"Luces principles "},{"$f":"+'Consumo eléctrico'!I21","v":58.4},60,0,0,null,"Luces ocacionales",14.162000000000001,20,0,0,"",1000,null,"Reproductor de video",100,4,{"$f":"+Y14*Z14*0.365","v":146},30,null,null,"Heladeras A++ (Invert)",739.72602739726028,270]
[null,"HornoE",0,4.5421567249999999,144.61090672500001,495.92425000000003,159.41790991642856,4.5421567249999999,null,{"$f":"+'Consumo eléctrico'!A22","v":"Luces ocacionales"},{"$f":"+'Consumo eléctrico'!I22","v":14.162000000000001},20,0,0,null,"Ventilador Techo  o Pie",12,44,0,0,"",10000,null,"Televisor color 14\" Válvula",50,4,{"$f":"+Y15*Z15*0.365","v":73},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Para N_personas",null,{"$f":"+n_pers","v":4},{"$f":"+AT15*50","v":200},"Litros/día"]
[null,"Bomba",0,34.80046875,170.80046874999999,517.42499999999995,154.47228825757577,34.80046875,null,{"$f":"+'Consumo eléctrico'!A24","v":"Ventilador Techo  o Pie"},{"$f":"+'Consumo eléctrico'!I24","v":12},44,0,0,null,"Aire Acondicionado 1",0,200,0,0,"",100000,null,"Televisor color 20\"  Válvula",70,4,102.2,null,null,null,null,null,null,null,null,null,"Termotanques Electricos",null,null,"Para 80 Litros","Para 80 Litros","Para 80 Litros","Para 80 Litros","Para 60 Litros","Para 60 Litros","Para N  Personas","Para N  Personas"]
[null,"Stand By",21.157832907500001,61.891832907499996,117.47525,483.26219000000003,123.28066354408449,61.891832907499996,null,{"$f":"+'Consumo eléctrico'!A26","v":"Aire Acondicionado 1"},{"$f":"+'Consumo eléctrico'!I26","v":0},200,0,0,null,"Aire Acondicionado 2",0,200,0,0,"",100000,null,"Televisor color 27\"  Válvula",100,4,146,null,null,null,null,null,null,null,null,null,"80 litros",null,null,"Consumo de Cal. Agua solo","Consumo de Mentenimiento","Consumo diario total ","Consumo anual total","Consumo diario total x Persona","Consumo anual total x persona","Consumo diario total ","Consumo anual total"]
[null,"Lavarropa",15.007990196078433,40.085500000000003,88.521999999999991,368.286,150,50,null,{"$f":"+'Consumo eléctrico'!A27","v":"Aire Acondicionado 2"},{"$f":"+'Consumo eléctrico'!I27","v":0},200,0,0,null,"Aire Acondicionado 3",0,200,0,0,"",100000,null,"Televisor color 32\" LD",30,4,43.8,null,null,null,null,null,null,null,null,"Efic.","ef","Vol (litros/dia)","DT","AC_kWh","QM24_kWh","AC ( kWh/dia)","kWh/año","AC  (kWh/dia)","kWh/año","AC ( kWh/dia)","kWh/año"]
[null,"Cafetera",5.6574999999999998,28.871499999999994,76.472062499999993,377.92556249999996,98.716022050207798,28.871499999999994,null,{"$f":"+'Consumo eléctrico'!A28","v":"Aire Acondicionado 3"},{"$f":"+'Consumo eléctrico'!I28","v":0},200,0,0,null,"Estufas Electricas 1",0,500,0,0,"",10000,null,"Televisor color 40\" LED",35,4,51.1,null,null,null,null,null,null,null,null,"B",0.96,80,{"$f":"55-17","v":38},{"$f":"+(AL19*AM19/AK19)*10.8/9300","v":3.6774193548387104},2.16,{"$f":"+AO19+AN19","v":5.8374193548387101},{"$f":"+AP19*365","v":2130.6580645161293},{"$f":"+AP19*60/80","v":4.3780645161290321},{"$f":"+AR19*365","v":1597.9935483870968},{"$f":"+AO19+AN19*AU15/AL19","v":11.353548387096776},{"$f":"+AT19*365","v":4144.0451612903234}]
[null,"Microonda",13.282500000000001,46.815937500000004,97.092812500000008,191.30237499999998,83.605283188715291,46.815937500000004,null,{"$f":"+'Consumo eléctrico'!A30","v":"Estufas Electricas 1"},{"$f":"+'Consumo eléctrico'!I30","v":0},500,0,0,null,"Estufas Electricas 2",0,500,0,0,"",10000,null,"Televisor color 50\" LED (EE A)",63,4,91.98,null,null,null,null,null,null,null,null,"C",0.96,80,{"$f":"55-17","v":38},{"$f":"+(AL20*AM20/AK20)*10.8/9300","v":3.6774193548387104},3.5,{"$f":"+AO20+AN20","v":7.17741935483871},{"$f":"+AP20*365","v":2619.7580645161293},{"$f":"+AP20*60/80","v":5.3830645161290329},{"$f":"+AR20*365","v":1964.8185483870971},{"$f":"+AO20+AN20*AW16/AL20","v":3.5},{"$f":"+AT20*365","v":1277.5}]
[null,"Planchado",5.49,24.115000000000002,65.390625,338.765625,78.87899090443122,24.115000000000002,null,{"$f":"+'Consumo eléctrico'!A31","v":"Estufas Electricas 2"},{"$f":"+'Consumo eléctrico'!I31","v":0},500,0,0,null,"Estufas Electricas 3",0,500,0,0,"",10000,null,"Audio  25 W",25,4,36.5,null,null,null,null,null,null,null,null,"A",0.96,80,38,3.6774193548387104,1,4.67741935483871,1707.258064516129,3.5080645161290329,1280.4435483870971,1,365]
[null,"Secador P.",0.91249999999999998,9.9333333333333336,38.803333333333335,211.55250000000001,58.245038135897445,9.9333333333333336,null,{"$f":"+'Consumo eléctrico'!A32","v":"Estufas Electricas 3"},{"$f":"+'Consumo eléctrico'!I32","v":0},500,0,0,null,"Estufas Electricas 4",0,500,0,0,"",10000,null,"Audio  10 W",10,4,14.6]
[null,"Horno Electr.",null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!A33","v":"Estufas Electricas 4"},{"$f":"+'Consumo eléctrico'!I33","v":0},500,0,0,null,"Cafetera",0,30,0,0,"",10000,null,"Reproductor de video",60,4,87.6]
[null,"Total EE (kWh/Año)",{"$f":"SUM(C8:C22)","v":650.71250897314383},1679.3832281288767,3428.2085593518118,13012.635939999998,3776.2795733932549,1296.6076531288768,null,{"$f":"+'Consumo eléctrico'!A55","v":"Cafetera"},{"$f":"+'Consumo eléctrico'!I55","v":109.5},30,79.5,1192.5,null,"Microondas",0,50,0,0,"",10000,null,"Equipo de TV por cable",35,4,51.1]
[null,null,null,null,"P(W)","hs/dia","kWh/dia","kWh/Año",null,{"$f":"+'Consumo eléctrico'!A52","v":"Microondas"},{"$f":"+'Consumo eléctrico'!I52","v":328.5},50,278.5,4177.5,null,"Tostador",0,35,0,0,"",30000,null,"Reproductor de DVD",15,4,21.9]
[null,"ACS_E (Termotanq)",null,null,null,null,7,{"$f":"+G26*365","v":2555},null,{"$f":"+'Consumo eléctrico'!A53","v":"Tostador"},{"$f":"+'Consumo eléctrico'!I53","v":273.75},35,238.75,3581.25,null,"Batidora",18.25,30,0,0,"",10000,null,"TV – LCD 32",55,4,80.3]
[null,"ACS_E (calefon)",null,null,null,null,4,{"$f":"+G27*365","v":1460},null,{"$f":"+'Consumo eléctrico'!A54","v":"Batidora"},{"$f":"+'Consumo eléctrico'!I54","v":9.125},30,0,0,null,"PC ´s (monit+CPU)",8.76,60,0,0,"",100000,null,"TV – Plasma  32",60,4,87.6]
[null,"TV(LED  32) A",null,null,26,4,{"$f":"+E28*F28*365/1000","v":37.96},{"$f":"+G28*4*0.365","v":55.421599999999998},null,{"$f":"+'Consumo eléctrico'!A34","v":"PC ´s (monit+CPU)"},{"$f":"+'Consumo eléctrico'!I34","v":29.2},60,0,0,null,"Laptop",0,50,0,0,"",200000,null,"TV – LCD 40",45,4,65.7]
[null,"TV (Valvulas 32\")",null,null,75,4,{"$f":"+E29*F29*365/1000","v":109.5},{"$f":"+G29*4*0.365","v":159.87},null,{"$f":"+'Consumo eléctrico'!A35","v":"Laptop"},{"$f":"+'Consumo eléctrico'!I35","v":0},50,0,0,null,"Impresoras",1.2166666666666668,25,0,0,"",40000,null,"TV – LED 40",35,4,51.1]
[null,"Ahorros Agua",null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!A36","v":"Impresoras"},{"$f":"+'Consumo eléctrico'!I36","v":1.2166666666666668},25,0,0,null,"WiFi +Router",15.208333333333332,50,0,0,"",5000,null,"TV – Valvula  32",150,4,219]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!A37","v":"WiFi +Router"},{"$f":"+'Consumo eléctrico'!I37","v":438},50,388,5820,null,"Radio",105.11999999999999,30,75.11999999999999,1126.8,35.498757543485979,40000,null,"Frío | Calor"]
[null,null,null,null,null,null,null,30,null,{"$f":"+'Consumo eléctrico'!A38","v":"Radio"},{"$f":"+'Consumo eléctrico'!I38","v":105.11999999999999},30,75.11999999999999,1126.8,null,"TV ",65.7,50,15.700000000000003,235.50000000000006,212.3142250530785,50000,null,"Artefacto"]
[null,"Extra",4198.8439083333324,4207.962125,4217.0803416666658,4226.1985583333335,null,4207.962125,null,{"$f":"+'Consumo eléctrico'!A39","v":"TV 1"},{"$f":"+'Consumo eléctrico'!I39","v":65.7},50,15.700000000000003,235.50000000000006,null,"TV Stand By",3.0659999999999994,25,0,0,"",10000,null,"Aire Acondicionado (2200 frigorías)",850,4,{"$f":"+Y33*Z33*0.2","v":680}]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio (KWh)","Eficiente (kWh)",null,{"$f":"+'Consumo eléctrico'!A44","v":"TV Stand By"},{"$f":"+'Consumo eléctrico'!I44","v":0},25,0,0,null,"DVD ",2.7374999999999998,25,0,0,"",10000,null,"Aire Acondicionado (2200 frigorías) A+",600,4,{"$f":"+Y34*Z34*0.2","v":480}]
[null,null,662.88188397314377,1653.5364231288768,3524.0758043518117,14564.71798251152,3909.5089478013083,1311.9590981288768,null,{"$f":"+'Consumo eléctrico'!A45","v":"DVD "},{"$f":"+'Consumo eléctrico'!I45","v":2.7374999999999998},25,0,0,null,"Stand By Teléfono",219,25,194,2910,3.4364261168384878,10000,null,"Aire Acondicionado (3200 frigorías) A",920,4,736]
[null,"Todo Electicidad",{"$f":"+C24","v":650.71250897314383},1679.3832281288767,3428.2085593518118,13012.635939999998,3776.2795733932549,1296.6076531288768,null,{"$f":"+'Consumo eléctrico'!A46","v":"Stand By Teléfono"},{"$f":"+'Consumo eléctrico'!I46","v":43.8},25,18.799999999999997,281.99999999999994,null,"Stand By otros",26.279999999999998,25,0,0,"",10000,null,"Aire Acondicionado (4200 frigorías) A",1000,4,800]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio (KWh)","Eficiente (kWh)",null,{"$f":"+'Consumo eléctrico'!A47","v":"Stand By otros"},{"$f":"+'Consumo eléctrico'!I47","v":26.279999999999998},25,0,0,null,"TV-Cable  (modulo)",52.559999999999995,25,27.559999999999995,413.39999999999992,24.189646831156271,10000,null,"Estufa de cuarzo (2 velas)",1200,4,{"$f":"+Y37*Z37*0.165","v":792}]
[null,"Calefacción",999.90924657533935,3857.1610287671106,7334.1787821917569,14936.36398041662,6291.2463251496765,3857.1610287671106,null,{"$f":"+'Consumo eléctrico'!A48","v":"TV-Cable  (modulo)"},{"$f":"+'Consumo eléctrico'!I48","v":52.559999999999995},25,27.559999999999995,413.39999999999992,null,"Secador Pelo",1.825,30,0,0,"",10000,null,"Radiador elécrtico",1200,4,{"$f":"+Y38*Z38*0.165","v":792}]
[null,"CAS",819.89891794520554,2216.6857235007565,3355.8868055555513,7815.2205998749814,3296.7977623042702,2216.6857235007565,null,{"$f":"+'Consumo eléctrico'!A49","v":"Secador Pelo"},{"$f":"+'Consumo eléctrico'!I49","v":1.825},30,0,0,null,"Plancha",114.97499999999999,25,89.974999999999994,1349.625,7.4094655922941559,10000,null,"Turbo Calefactor (2000 calorías)",2400,4,1584]
[null,"Piloto",986.76229166666519,2072.2008124999952,2477.7195624999922,4887.3119749999951,2442.5535996444887,2072.2008124999952,null,{"$f":"+'Consumo eléctrico'!A50","v":"Plancha"},{"$f":"+'Consumo eléctrico'!I50","v":114.97499999999999},25,89.974999999999994,1349.625,null,"Bomba Agua",0,35,0,0,"",60000,null,"Turbo ventilador",100,7,115.5]
[null,"Cocción",513.79630555555411,1068.6741722222187,1460.5278666666645,3728.4049933333245,1497.249019875544,1068.6741722222187,null,{"$f":"+'Consumo eléctrico'!A60","v":"Bomba Agua"},{"$f":"+'Consumo eléctrico'!I60","v":87.6},35,52.599999999999994,788.99999999999989,null,null,null,null,null,null,"",null,null,"Ventilador Común",90,7,103.95]
[null,null,null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!A57","v":"Dispenser Agua"},{"$f":"+'Consumo eléctrico'!I57","v":448.95},35,null,null,null,"Cocción",1263.0557333333293,1068.6741722222187,194.38156111111061,449.95731738683014,222.24330205531382,100000,null,"Ventilador de Techo",60,7,69.3]
[null,"Electico",null,null,null,null,null,null,null,{"$f":"+'Consumo eléctrico'!A59","v":"Agua Cal. Sanit.(TTQ_Electrico)"},{"$f":"+'Consumo eléctrico'!I59","v":2007.5},35,null,null,null,"ACS",2013.5357666666603,2216.6857235007565,0,"",{"$error":"#VALUE!"},100000]
[null,"TOTAL_GAS",{"$f":"SUM(C38:C41)","v":3320.3667617427641},9214.7217369900827,14628.313016913962,31367.301548624921,13527.84670697398,9214.7217369900827,null,{"$f":"+'Consumo eléctrico'!A61","v":"Otros 1(Plancha para el pelo)"},{"$f":"+'Consumo eléctrico'!I61","v":1.2166666666666668},null,null,null,null,"Piloto",0,0,0,"",{"$error":"#VALUE!"},50000,null,"Artefacto del Hogar","Potencia (W)","Consumo Por Ciclo (Wh)","Consumo Por año (Wh)"]
[null,"TOTAL_GAS",307.44136682803367,853.21497564722983,1354.4734274920334,2904.3797730208257,1252.5783987938869,853.21497564722983,null,null,null,null,null,null,null,"Calef.",3859.3489783333212,3857.1610287671106,0,"",{"$error":"#VALUE!"},100000,null,"Lavarropa Autom. A+ (Electrolux)",165,200,{"$f":"+Z45*0.3","v":60}]
[null,"Total (kWh/Año)",{"$f":"+C44","v":3320.3667617427641},9214.7217369900827,14628.313016913962,31367.301548624921,13527.84670697398,9214.7217369900827,null,"Cocción",{"$f":"+'Consumo de Gas'!E27","v":1657.7606499999949},1068.6741722222187,{"$f":"+IF(K46>1.1*L46,K46-L46,0)","v":589.08647777777628},{"$f":"+IF(M46>1,M46*p_gas,\"\")","v":1363.6261059670749},null,null,null,null,null,null,null,null,null,"Lavarropas automático A (Sin Calentar Agua)",520,230,{"$f":"+Z46*0.3","v":69}]
[null,"Total_Grl (m3/año)",{"$f":"+C46/10.8","v":307.44136682803367},853.21497564722983,1354.4734274920334,2904.3797730208257,1252.5783987938869,853.21497564722983,null,"ACS",{"$f":"+'Consumo de Gas'!E28","v":986.22159999999678},2216.6857235007565,{"$f":"+IF(K47>1.1*L47,K47-L47,0)","v":0},{"$f":"+IF(M47>1,M47*p_gas,\"\")","v":""},null,null,null,2216.6857235007565,null,"",null,null,null,"Lavarropas automático A (sin calentasr agua)",550,270,{"$f":"+Z47*0.3","v":81}]
[null,null,null,null,null,null,null,null,null,"Piloto",{"$f":"+'Consumo de Gas'!E29","v":1973.5245833333272},0,{"$f":"+IF(K48>1.1*L48,K48-L48,0)","v":1973.5245833333272},{"$f":"+IF(M48>1,M48*p_gas,\"\")","v":4568.3439429012205},null,"Ahorro total aproximado",null,0,{"$f":"SUM(S9:S45)","v":730.25926132756081},{"$f":"SUM(T8:T46)","v":14938.122820633582},null,null,null,"Lavarropas autom. con calentamiento de agua",2520,650,{"$f":"+Z48*0.3","v":195}]
[null,null,null,null,null,null,null,null,null,"Calef.",{"$f":"+'Consumo de Gas'!E30","v":3199.8132833333229},3857.1610287671106,{"$f":"+IF(K49>1.1*L49,K49+K48-L49,0)","v":0},{"$f":"+IF(M49>1,M49*p_gas,\"\")","v":""},null,null,null,3857.1610287671106,null,""]
[null,null,null,null,null,null,null,null,null,null,null,2216.6857235007565,null,{"$f":"+IF(M50>1,M50*p_gn,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Lavarropas semiautomático",200,200,{"$f":"+Z50*0.3","v":60}]
[null,null,null,null,null,null,null,null,null,"Ahorro total aproximado",null,0,{"$f":"SUM(M6:M50)","v":4453.6804279942198},{"$f":"SUM(N6:N50)","v":34298.010552115047},null,"Tabla 2- Comparación",null,null,null,null,null,null,null,"Secarropas centrífugo",240,200,{"$f":"+Z51*0.3","v":60}]
[null,{"$f":"+B5","v":"Categoria general"},null,null,null,null,2021,null,null,null,null,3857.1610287671106,null,{"$f":"+IF(M52>1,M52*p_gn,\"\")","v":""},null,"Comparacion de los consumos medidos con loa más eficientes",null,null,null,null,null,null,null,"Lavavajilla",null,500,1600,null,"https://www.cleanipedia.com/ar/sustentabilidad/cuanto-consume-un-lavavajillas.html"]
[null,null,{"$f":"+C6","v":"Primer Cuart"},"Seg. Cuart","Terc. Cuart","Cuart. Cuart","kWh/año","kWh/año",null,null,null,null,null,null,null,"Equipo o servicio","Consumos medidos [kWh/año]","Consumos eficientes  [kWh/año]","Posibilidad de ahorro  [kWh/año]"," Ahorro estimado en [ $/año]","Años de amorizacion","Conviene cambiar o eficientizar el consumo?",null,"Termotanque Electrico",3000,null,{"$f":"9*365","v":3285}]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio","Eficiente",null,null,null,null,null,null,null,"ACS",2013.5357666666603,2216.6857235007565,0,"",null,null,null,"Freezer",75,null,330]
[null,{"$f":"+B8","v":"Heladera"},361.11275000000001,598.18025,834.86085000000003,1800.17635,860.65497011116645,300,null,"Tabla 2",null,null,null,null,null,"Piloto",0,0,0,"",null,null,null,"Heladera A",80,null,320]
[null,"AA-Refrigeración",40.848260869565223,215.14826086956523,570.87249999999995,2476.8225000000002,647.43321257889158,215.14826086956523,null,"Equipo o servicio","Consumos medidos","Consumos eficientes","Posibilidad de ahorro","Ahorro Anual ($/año)",null,"Heladera A",730,300,430,6450,15.503875968992247,null,null,"Heladera con freezer A",65,null,300]
[null,"Ilumin.",74.936324999999997,189.50982500000001,372.41634375000001,2499.6728437500001,416.25964705815971,85,null,null,null,null,null,null,null,"Stand By Teléfono",219,25,194,2910,3.4364261168384878,{"$f":"+IF(U57<10,\"Si\",\"no\")","v":"Si"},null,"Heladera A++",64,null,280]
[null,"Lavavajilla",0,80,120,370,130,90,null,"Calef.",8380.7208333333074,3857.1610287671106,4523.5598045661973,0,null,"Plancha",114.97499999999999,25,89.974999999999994,1349.625,7.4094655922941559,"Si",null,"Heladera con freezer A++",55,null,260]
[null,"Cale.E.",0.74825000000000008,59.402163043478261,213.11016304347828,1060.3062500000001,289.04725830406909,59.402163043478261,null,"ACS",3411.2237249999898,2216.6857235007565,1194.5380014992334,0,null,"Radio",105.11999999999999,30,75.11999999999999,1126.8,35.498757543485979,"no",null,"Horno microondas",800,null,{"$f":"+Y59*0.365*0.5","v":146}]
[null,"Inform.",52.775350000000003,124.64750000000001,251.05749374999999,1166.8424937499999,273.22605854316248,124.64750000000001,null,"Piloto",2170.8770416666603,0,2170.8770416666603,0,null,"Lavavajilla",164.25,90,74.25,1113.75,89.786756453423124,"no",null,"Horno eléctrico",1300,null,{"$f":"+Y60*0.365*0.5","v":237.25}]
[null,"TV+Radio+Electr.",58.783250000000002,161.43950000000001,266.72375,654.37200000000007,253.04223080046506,161.43950000000001,null,"Cocción",1263.0557333333293,1068.6741722222187,194.38156111111061,0,null,"Lavarropa",99.31436688311689,50,49.31436688311689,739.71550324675331,135.18710850466269,"no",null,"Pequeños electrodomésticos","Potencia (W)","Horas/día","Consumo Por añoo (Wh)"]
[null,"HornoE",0,4.5421567249999999,144.61090672500001,495.92425000000003,159.41790991642856,4.5421567249999999,null,"Heladera A",730,300,430,6450,null,"Cocción",1263.0557333333293,1068.6741722222187,194.38156111111061,449.95731738683014,222.24330205531382,"no",null,"Licuadora",300,0.25,{"$f":"+Y62*Z62*0.365","v":27.375}]
[null,"Bomba",{"$f":"+C16","v":0},34.80046875,170.80046874999999,517.42499999999995,154.47228825757577,34.80046875,null,"Aire Acondicionado 3",240,200,40,600,null,"TV-Cable  (modulo)",52.559999999999995,25,27.559999999999995,413.39999999999992,24.189646831156271,"no",null,"Lustraspiradora",750,1,{"$f":"+Y63*Z63*0.365","v":273.75}]
[null,"Stand By",21.157832907500001,61.891832907499996,117.47525,483.26219000000003,123.28066354408449,61.891832907499996,null,"Stand By Teléfono",219,25,194,2910,null,"TV ",65.7,50,15.700000000000003,235.50000000000006,212.3142250530785,"no",null,"Máquina de coser",90,1,32.85]
[null,"Lavarropa",15.007990196078433,40.085500000000003,88.521999999999991,368.286,150,50,null,"Lavavajilla",164.25,90,74.25,1113.75,null,"Luces principles ",69.958333333333343,60,9.9583333333333428,149.37500000000014,6.6945606694560604,"Si",null,"Multiprocesadora",500,0.3,54.75]
[null,"Cafetera",5.6574999999999998,28.871499999999994,76.472062499999993,377.92556249999996,98.716022050207798,28.871499999999994,null,"Plancha",114.97499999999999,25,89.974999999999994,1349.625,null,"Heladera  B",0,300,0,0,"","no",null,"Plancha",1000,0.25,91.25]
[null,"Microonda",13.282500000000001,46.815937500000004,97.092812500000008,191.30237499999998,83.605283188715291,46.815937500000004,null,"Radio",105.11999999999999,30,75.11999999999999,1126.8,null,"Heladera  C",0,300,0,0,"",null,null,"Purificador de aire",110,0.25,10.0375]
[null,"Planchado",5.49,24.115000000000002,65.390625,338.765625,78.87899090443122,24.115000000000002,null,"Lavarropa",99.31436688311689,50,49.31436688311689,739.71550324675331,null,"Luces ocacionales",14.162000000000001,20,0,0,"",null,null,"Secador de pelo",500,{"$f":"5/16","v":0.3125},57.03125]
[null,"Secador P.",0.91249999999999998,9.9333333333333336,38.803333333333335,211.55250000000001,58.245038135897445,9.9333333333333336,null,"Luces principles ",69.958333333333343,60,9.9583333333333428,149.37500000000014,null,"Ventilador Techo  o Pie",12,44,0,0,"",null,null,"Aspiradora",750,1,273.75]
[null,{"$f":"+B24","v":"Total EE (kWh/Año)"},{"$f":"+SUM(C55:C69)","v":650.71250897314383},{"$f":"+SUM(D55:D69)","v":1679.3832281288767},3428.2085593518118,13012.635939999998,3776.2795733932549,2200,null,"TV ",65.7,50,15.700000000000003,235.50000000000006,null,null,null,null,null,null,null,null,null,"Cafetera",900,0.2,65.7]
[null,"TTQ_EE",2000,3400,5000,6500,{"$f":"+AVERAGE(C71:F71)","v":4225},2200,null,"TV-Cable  (modulo)",52.559999999999995,25,27.559999999999995,413.39999999999992,null,null,null,null,null,null,null,null,null,"Cortadora de Césped",550,0.2,40.15]
[null,null,{"$f":"+D72","v":"kWh/Año"},{"$f":"+E72","v":"kWh/Año"},{"$f":"+F72","v":"kWh/Año"},{"$f":"+G72","v":"kWh/Año"},{"$f":"+H72","v":"kWh/Año"},{"$f":"+H25","v":"kWh/Año"},null,"Stand By otros",26.279999999999998,25,0,"",null,null,null,null,null,null,null,null,null,"Extractor de aire",25,0.25,2.28125]
[null,null,{"$f":"+C37","v":"Primer Cuart"},"Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio (KWh)","Eficiente (kWh)"]
[null,{"$f":"+B38","v":"Calefacción"},999.90924657533935,3857.1610287671106,7334.1787821917569,14936.36398041662,6291.2463251496765,3857.1610287671106,null,"Ventilador Techo  o Pie",24,44,0,"",null,null,null,null,null,null,null,null,null,"Freidora",2000,0.2,146]
[null,"CAS",819.89891794520554,2216.6857235007565,3355.8868055555513,7815.2205998749814,3296.7977623042702,2216.6857235007565,null,"Batidora",18.25,30,0,"",null,null,null,null,null,null,null,null,null,"Ducha eléctrica",1200,{"$f":"20/60","v":0.33333333333333331},146]
[null,"Piloto",986.76229166666519,2072.2008124999952,2477.7195624999922,4887.3119749999951,2442.5535996444887,0,null,"WiFi +Router",15.208333333333332,50,0,"",null,null,null,null,null,null,null,null,null,"Bombas y motores",null,"Horas/día"]
[null,"Cocción",513.79630555555411,1068.6741722222187,1460.5278666666645,3728.4049933333245,1497.249019875544,1068.6741722222187,null,"Luces ocacionales",14.162000000000001,20,0,"",null,null,null,null,null,null,null,null,null,"Artefacto"]
[null,null,null,null,null,null,null,null,null,"PC ´s (monit+CPU)",8.76,60,0,"",null,null,null,null,null,null,null,null,null,"Bomba de agua 1/2 HP",370,4,{"$f":"+Y78*Z78*0.365","v":540.19999999999993}]
[null,"Gas",null,null,null,null,null,null,null,"TV Stand By",3.0659999999999994,25,0,"",null,null,null,null,null,null,null,null,null,"Bomba de agua 3/4 HP",550,4,{"$f":"+Y79*Z79*0.365","v":803}]
[null,{"$f":"+B44","v":"TOTAL_GAS"},3320.3667617427641,9214.7217369900827,14628.313016913962,31367.301548624921,13527.84670697398,9214.7217369900827,null,"DVD ",2.7374999999999998,25,0,"",null,null,null,null,null,null,null,null,null,"Motor de 1 HP",750,4,1095]
[null,{"$f":"+B45","v":"TOTAL_GAS"},{"$f":"+C45","v":307.44136682803367},853.21497564722983,1354.4734274920334,2904.3797730208257,1252.5783987938869,853.21497564722983,null,"Secador Pelo",1.825,30,0,"",null,null,null,null,null,null,null,null,null,"Lavandería"]
[null,null,null,null,null,null,null,null,null,"Impresoras",1.2166666666666668,25,0,"",null,null,null,null,null,null,null,null,null,"Secadora de ropa – Eléctrica",3000,1,1095]
[null,null,null,null,null,null,null,null,null,"Heladera  B",0,300,0,"",null,null,null,null,null,null,null,null,null,"Secadora de ropa – Gas",1800,1,657]
[null,null,null,null,null,null,null,null,null,"Heladera  C",0,300,0,"",null,null,null,null,null,null,null,null,null,"Lavadora de ropa",800,1,292]
[null,null,null,null,null,null,null,null,null,"Aire Acondicionado 1",0,200,0,"",null,null,null,null,null,null,null,null,null,"Plancha",1200,0.25,109.5]
[null,null,null,null,null,null,null,null,null,"Aire Acondicionado 2",0,200,0,"",null,null,null,null,null,null,null,null,null,"Aparato",null,"Horas/día"]
[null,null,null,null,null,null,null,null,null,"Estufas Electricas 1",0,500,0,"",null,null,null,null,null,null,null,null,null,"Sala"]
[null,null,null,null,null,null,null,null,null,"Estufas Electricas 2",0,500,0,"",null,null,null,null,null,null,null,null,null,"Reproductor Blu-ray",15,4,21.9]
[null,null,null,null,null,null,null,null,null,"Estufas Electricas 3",0,500,0,"",null,null,null,null,null,null,null,null,null,"Equipo de TV por cable",35,4,51.1]
[null,null,null,null,null,null,null,null,null,"Estufas Electricas 4",0,500,0,"",null,null,null,null,null,null,"",null,null,"Reproductor de DVD",15,4,21.9]
[null,null,null,null,null,null,null,null,null,"Cafetera",0,30,0,"",null,null,null,null,null,null,null,null,null,"TV – LCD 32",55,4,80.3]
[null,null,null,null,null,null,null,null,null,"Microondas",0,50,0,"",null,null,null,null,null,null,"",null,null,"TV – Plasma  32",60,4,87.6]
[null,null,null,null,null,null,null,null,null,"Tostador",0,35,0,"",null,null,null,null,null,null,null,null,null,"TV – LCD 40",45,4,65.7]
[null,null,null,null,null,null,null,null,null,"Laptop",0,50,0,"",null,null,null,null,null,null,null,null,null,"TV – LED 40",35,4,51.1]
[null,null,null,null,null,null,null,null,null,"Bomba Agua",0,35,0,"",null,null,null,null,null,null,null,null,null,"TV – Valvula  32",150,4,219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minicomponente 20 W ",20,4,29.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ahorro total aproximado",null,0,{"$f":"SUM(S54:S78)","v":1160.2592613275608},{"$f":"SUM(T54:T78)","v":14938.122820633582},null,null,null,"Minicomponente 50 W ",50,4,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antena parabólica",25,4,36.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Receptor estéreo",450,4,657]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consola de videojuegos",150,4,219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Luces  e iluminación",null,"Horas/día"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla CFL – Equivalente de 40 vatios",11,5,20.074999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla CFL – Equivalente de 60 vatios",12,5,21.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla CFL – Equivalente de 75 vatios",15,5,27.375]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla CFL – Equivalente de 100 vatios",25,5,45.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluorescente compacto 30 vatios",22,5,40.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fluorescente compacto de 45 vatios",45,5,82.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Halógeno – 40 vatios",40,5,73]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescente 50 Watt",50,5,91.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Incandescente 100 vatios",100,5,182.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla LED – Equivalente de 40 vatios",5,5,9.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla LED – Equivalente de 60 vatios",6,5,10.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla LED – equivalente a 75 vatios",7.5,5,13.6875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bombilla LED – Equivalente de 100 vatios",10,5,18.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oficina",null,"Horas/día"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computadora de escritorio (estándar)",150,8,438]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Computadora de escritorio (juegos)",200,8,584]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ordenador portátil (LAPTOP)",50,8,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Monitor LCD",50,8,146]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Módem",7,8,20.439999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trituradora de papel",150,2,109.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Impresora",50,1,18.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enrutador",7,24,61.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Teléfono inteligente: recarga",6,10,21.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tableta – Recargue",8,10,29.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Herramientas",null,"Horas/día"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sierra de cinta – 14 “",1100,0.5,200.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lijadora de banda – 3 “",1000,0.5,182.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sierra de cadena – 12 “",1100,0.5,200.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sierra Circular – 7-1 / 4 “",900,0.5,164.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sierra circular 8-1 / 4 “",1400,0.5,255.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cortadora de disco- 9 “",1200,0.5,219]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taladro – 1/4 “",250,0.5,45.625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taladro – 1/2 “",750,0.5,136.875]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taladro – 1 “",1000,0.5,182.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motosierra",450,0.5,82.125]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Motoguadaña electrica",500,0.5,91.25]

{"sheet":"Consumos","index":7,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Categoria general",null,null,null,null,2021]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","kWh/año","kWh/año","kWh/año"]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio","Eficiente","Su Consumo"]
[null,"Heladera",361.11275000000001,598.18025,834.86085000000003,1800.17635,860.65497011116645,361.11275000000001]
[null,"AA-Refrigeración",40.848260869565223,215.14826086956523,570.87249999999995,2476.8225000000002,647.43321257889158,215.14826086956523]
[null,"Ilumin.",74.936324999999997,189.50982500000001,372.41634375000001,2499.6728437500001,416.25964705815971,85]
[null,"otros",12.169374999999999,54.153194999999997,215.86724499999997,1922.0820425115212,307.51389305922214,54.153194999999997]
[null,"Cale.E.",0.74825000000000008,59.402163043478261,213.11016304347828,1060.3062500000001,289.04725830406909,59.402163043478261]
[null,"Inform.",52.775350000000003,124.64750000000001,251.05749374999999,1166.8424937499999,273.22605854316248,124.64750000000001]
[null,"TV+Radio+Electr.",58.783250000000002,161.43950000000001,266.72375,654.37200000000007,253.04223080046506,161.43950000000001]
[null,"HornoE",0,4.5421567249999999,144.61090672500001,495.92425000000003,159.41790991642856,4.5421567249999999]
[null,"Bomba",0,34.80046875,170.80046874999999,517.42499999999995,154.47228825757577,34.80046875]
[null,"Stand By",21.157832907500001,61.891832907499996,117.47525,483.26219000000003,123.28066354408449,61.891832907499996]
[null,"Lavarropa",15.007990196078433,40.085500000000003,88.521999999999991,368.286,150,50]
[null,"Cafetera",5.6574999999999998,28.871499999999994,76.472062499999993,377.92556249999996,98.716022050207798,28.871499999999994]
[null,"Microonda",13.282500000000001,46.815937500000004,97.092812500000008,191.30237499999998,83.605283188715291,46.815937500000004]
[null,"Planchado",5.49,24.115000000000002,65.390625,338.765625,78.87899090443122,24.115000000000002]
[null,"Secador P.",0.91249999999999998,9.9333333333333336,38.803333333333335,211.55250000000001,58.245038135897445,9.9333333333333336]
[null,"Total EE (kWh/Año)",662.88188397314377,1653.5364231288768,3524.0758043518117,14564.71798251152,3953.7934664524769,{"$f":"SUM(H7:H21)","v":1321.8735981288769},{"$f":"SUM(I7:I21)","v":0}]
[null,null,"kWh/Año","kWh/Año","kWh/Año","kWh/Año","kWh/Año","kWh/Año","kWh/Año"]
[null,null,"Primer Cuart","Seg. Cuart","Terc. Cuart","Cuart. Cuart","Promedio (KWh)","Eficiente (kWh)"]
[null,"Calefacción",999.90924657533935,3857.1610287671106,7334.1787821917569,14936.36398041662,6291.2463251496765,3857.1610287671106]
[null,"CAS",819.89891794520554,2216.6857235007565,3355.8868055555513,7815.2205998749814,3296.7977623042702,2216.6857235007565]
[null,"Piloto",986.76229166666519,2072.2008124999952,2477.7195624999922,4887.3119749999951,2442.5535996444887,2072.2008124999952]
[null,"Cocción",513.79630555555411,1068.6741722222187,1460.5278666666645,3728.4049933333245,1497.249019875544,1068.6741722222187]
[]
[null,"Gas"]
[null,"TOTAL_GAS",3320.3667617427641,9214.7217369900827,14628.313016913962,31367.301548624921,13527.84670697398,{"$f":"SUM(H25:H28)","v":9214.7217369900827},{"$f":"SUM(I25:I28)","v":0}]
[null,"TOTAL_GAS",307.44136682803367,853.21497564722983,1354.4734274920334,2904.3797730208257,1252.5783987938869,{"$f":"+H31/10.8","v":853.21497564722983},{"$f":"+I31/10.8","v":0}]

{"sheet":"Heladera","index":8,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"Heladera yyy",null,{"$f":"+B15&ROUND(F3,1)&\" Wh/día\"","v":"Consumo medio diario=808.8 Wh/día"}]
[null,"Heladera  A  Abril 2023",null,{"$f":"+B16&ROUND(C3,1)&\" kWh/año\"","v":"Consumo medio anual=295.2 kWh/año"},null,null,null,"La Pendiente va aqui!"]
[null," Cons. Real=",{"$f":"+F3*0.365","v":295.20835},"  kWh/año","Medic_2",808.79]
[null,null,null,null,"Tmedia=","18 C"]
[null,"Medicion","Hora","Wh","ti(d)","Ei(Wh)"]
[null,"2021-04-26","11:11:00",2090,{"$f":"+B6-$B$6+(C6-$C$6)","v":0},{"$f":"+D6-$D$6","v":0}]
[null,{"$f":"+B6","v":"2021-04-26"},"17:30:00",2246,{"$f":"+B7-$B$6+(C7-$C$6)","v":0.2631944444444444},{"$f":"+D7-$D$6","v":156}]
[null,{"$f":"+B7","v":"2021-04-26"},"22:14:00",2408,0.4604166666666667,318]
[null,{"$f":"+B8+1","v":"2021-04-27"},"12:33:00",2846,1.0569444444444445,756]
[null,{"$f":"+B9","v":"2021-04-27"},"17:01:00",2890,1.2430555555555554,800]
[null,{"$f":"+B10","v":"2021-04-27"},null,"Tmedia=",0.53402777777777777]
[]
[]
[]
[null,"Consumo medio diario=",null,{"$f":"+B15&ROUND(F19,1)&\" Wh/día\"","v":"Consumo medio diario=800.8 Wh/día"}]
[null,"Consumo medio anual=",null,{"$f":"+B16&ROUND(C19,1)&\" kWh/año\"","v":"Consumo medio anual=292.3 kWh/año"}]
[null,"Heladera zzz"]
[null,"Heladera  A++  Abril 2021"]
[null," Cons. Real=",{"$f":"+F19*0.365","v":292.29199999999997},"  kWh/año","Medición (Wh/día)=",800.8,null,"La Pendiente va aqui!"]
[null,null,null,null,"Tmedia=","18 C"]
[null,"Fecha","Hora","Ei(Wh)","ti(d)","Ei(Wh)"]
[null,{"$f":"+B11+1","v":"2021-04-28"},"21:37:00",0,{"$f":"+B22-$B$22+(C22-$C$22)","v":0},{"$f":"+D22-$D$22","v":0}]
[null,{"$f":"+B22+1","v":"2021-04-29"},"00:06:00",103,{"$f":"+B23-$B$22+(C23-$C$22)","v":0.10347222222222219},{"$f":"+D23-$D$22","v":103}]
[null,{"$f":"+B23","v":"2021-04-29"},"17:46:00",662,0.83958333333333324,662]
[null,{"$f":"+B24","v":"2021-04-29"},"20:15:00",770,0.94305555555555554,770]
[null,{"$f":"+B25","v":"2021-04-29"},"23:33:00",879,1.0805555555555557,879]
[]
[]
[]
[]
[]
[null,"Heladera XXX"]
[null,"Consumo medio diario=",null,{"$f":"+B33&ROUND(F36,1)&\" Wh/día\"","v":"Consumo medio diario=1053.8 Wh/día"}]
[null,"Consumo medio anual=",null,{"$f":"+B34&ROUND(C36,1)&\" kWh/año\"","v":"Consumo medio anual=384.6 kWh/año"}]
[null,null,null,null,null,null,null,"La Pendiente va aqui!"]
[null," Cons. Real=",{"$f":"+F36*0.365","v":384.637},"  kWh/año","Medición (Wh/día)=",1053.8]
[null,"Heladera  A++  Abril 2021",null,null,"Tmedia=","18 C"]
[null,"Fecha","Hora","Ei(Wh)","ti(d)","Ei(Wh)"]
[null,"2023-10-28","21:37:00",0,{"$f":"+B39-$B$39+(C39-$C$39)","v":0},{"$f":"+D39-$D$39","v":0}]
[null,{"$f":"+B39+1","v":"2023-10-29"},"00:06:00",180,{"$f":"+B40-$B$39+(C40-$C$39)","v":0.10347222222222219},{"$f":"+D40-$D$39","v":180}]
[null,{"$f":"+B40","v":"2023-10-29"},"17:46:00",790,{"$f":"+B41-$B$39+(C41-$C$39)","v":0.83958333333333324},{"$f":"+D41-$D$39","v":790}]
[null,{"$f":"+B41","v":"2023-10-29"},"20:15:00",1000,0.94305555555555554,1000]
[null,{"$f":"+B42","v":"2023-10-29"},"23:33:00",1200,1.0805555555555557,1200]