{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Ring-pan y Huella CO2","Reemplazar Olla por Ring-pan","Reemplazar Olla por TWIN-SHAFT","Reemplazar Tilt por Twin-shaft","Factor CO2","Cálculo cemento","Cálculo humedad","Cálculo CO2 directo","Cálculo huella CO2"],"not_rendered":{"charts":9,"images":40,"macros":1,"external_links":2,"defined_names":6,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ring-pan y Huella CO2","index":0,"n_rows":145,"n_cols":43,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Costo cemento :",null,2.1,"Pesos/kg"]
[null,null,null,null,null,"1 USD =",null,18,"Pesos"]
[null,null," ",null,null,null,null,null,null,null,null,null,null,"SOLUCIONES PRACTICAS LIEBHERR PARA BAJAR SU HUELLA CO2 :"]
[null,"EQUIPO FRANCES SA DE CV, Colima, 21 Jun. 2020, versión Sep. 22 2022.",null,null,null,"ESTUDIO AMASADO CONCRETO : PARTE N°4 : Ahorros y soluciones LIEBHERR. 4.1. P6"]
[null," ",null,null,null,"1. Ahorro cemento mezclador LIEBHERR versus Revolvedora Olla o Tilt."]
[null," ",null,null,null,"2. Mejora huella CO2 según Mezclador versus Olla o Tilt + Equipo de Transporte."]
[null,null,null,null,null,"3. Ahorro cemento+CO2 si utiliza una Sistema de Medición Humedad LIEBHERR."]
[null,null,null,null,null," ","m3/año","Agua","Cemento","Arena húmeda",null,null,null,"1. Fase AMASADO :",null,null,null,null,null,"2. Fase TRANSPORTE",null,"2. Fase COLOCACION",null,"4. FIN DE VIDA :"]
[null,null,"Sintesis financiera :",{"$f":"+E19","v":"Ring-pan 2.5 D"},null,"Bloque 10-20 MPa",0,0,0,0,null,"SELECCIONAR :",null,"MEZCLADOR :",null,"PLANTA :",null,null,null,"REVOLVEDORA :",null,"BANDOLLA + ELECTRICA :"]
[null,null,"Ahorros totales Mezclador:",{"$f":"+F23","v":494684.2},{"$f":"+(D10/G45)*H2","v":148.40526},"25 MPa",0.3,180,250,600,null,"Revolvedora Olla",60]
[null,null,"Costo anual :",{"$f":"+F27","v":45127.933333333334},{"$f":"+(D11/G45)*H2","v":13.53838},"30 MPa",0.3,180,300,600,null,"Ring-pan 2.5 D",106,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Añadir Tilt para  Holcim"]
[null,null,"Beneficio adicional :",{"$f":"+F29","v":449556.26666666666},{"$f":"+E10-E11","v":134.86688000000001},"35 MPa",0.2,180,430,600,null,"Promedio actual",{"$f":"+H45","v":25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y Versión Twin-shaft Liebherr"]
[null,null,"Meses amortización :",{"$f":"+F30","v":6.1920053200904315},null,"Vigueta 35-45 MPa",0.2,180,450,600,"Huella CO2 cemento :",622,"Su huella actual :","Ring-pan         Twin-shaft","Sensor humedad","Mobilmix","LCM1 ","LCM3 Twin-","Mobile Twin","Revolvedora eléctrica :",null,"BANDOLLA","Estacionaria","Reciclador LRS"]
[null,null,"Mejora Huella CO2 :",{"$f":"+F33","v":-2204608.9200000018},{"$f":"+D14/G45","v":-36.743482000000029},"Durmiente 65 MPa",0,null,null,0,"Bajada huella cemento :",0,{"$f":"'Cálculo cemento'!$L$25","v":212.102},"Instalar o plataforma.","en Arena y Agregado","Rin-pan 0.5 m3","Rin-pan 1.0 m3","-shaft3.0 m3","shaft 4.5 m3","Chasis","Remolque",null,"Eléctrica",null," ","Opción 2","Opcion 3",null,null,"                     AMASADO",null,null,null,"              TRANSPORTE",null,null,null,"TOTAL","MEJORA ",null,"Precio 80 Euros/t","DIFERENCIA","Precio 80 Euros/t"]
[null,null,"Ahorro control humedad",{"$f":"+L59","v":120555.55555555558},{"$f":"+M47","v":36.166666666666671},"Producción anual:",60000,null,null,null,null,"Su nueva huella si nuevo cemento :",{"$f":"'Cálculo cemento'!$N$25","v":212.102},"EMISION Y HUELLA CO2 (cálculo con metodologia LCA oficial y Huella CO2 oficial electricidad CFE 0.494 KG/KWh) :",null,null,null,null,null,null,null,null,null,null," ","Cemento-Mezclador :","Transporte Parada",null,"#CementoSistema","CEMENTO","ENERGIA","TOTAL","#TransporteParadas","PARADAS","#TransporteActivo","ACTIVO","TOTAL",null,"/ OLLA %","KG","ahorro USD/m3","CON TILT","ahorro USD/m3"]
[null,"INDICADORES ECONÓMICOS FASE AMASADO :",null,null,null,"Año n°1","Año n°2","Año n°3","Año n°4","Año n°5","Total 5 años","Año 6"," ","SU HUELLA CO2 ACTUAL : con",null,"Revolvedora Olla","%/Total","HUELLA con","Ring-pan 2.5 D","Mejoras:","HUELLA CO2 CON OTRAS OPCIONES :",null,"Mejoras  con Huella Actual :",null,null,"Ring-pan 1.0 M","Revolvedora Diesel","Rev. Diesel",null,{"$f":"'Factor CO2'!I28","v":12726120},{"$f":"'Factor CO2'!J28","v":18480},{"$f":"'Factor CO2'!K28","v":12744600},"Revolvedora Diesel",{"$f":"'Factor CO2'!L28","v":39600},"Camión Diesel",{"$f":"'Factor CO2'!M28","v":198000},{"$f":"'Factor CO2'!N28","v":237600},{"$f":"'Factor CO2'!O28","v":12982200},0,0,null,0]
[null,null,null,null,"Ahorro cemento Sensor Humedad si 3% variación  :",{"$f":"+L59","v":120555.55555555558},{"$f":"+F17","v":120555.55555555558},{"$f":"+F17","v":120555.55555555558},{"$f":"+F17","v":120555.55555555558},{"$f":"+F17","v":120555.55555555558},{"$f":"+SUM(F17:J17)","v":602777.77777777787},{"$f":"+F17","v":120555.55555555558},null,"Amasado Cemento","Revolvedora Olla",12726120,{"$f":"+P17/$P$23","v":0.98011145716847037},"Ring-pan 2.5 D",10519351.079999998,{"$f":"-(P17-S17)/P17","v":-0.17340469208211157},"Ring-pan 2.5 D",10519351.079999998,{"$f":"+(V17-P17)/P17","v":-0.17340469208211157},{"$f":"+V17-P17","v":-2206768.9200000018},null,"Ring-pan 1.5 D","Revolvedora Gas","Rev. Gas",null,{"$f":"'Factor CO2'!I29","v":12726120},{"$f":"'Factor CO2'!J29","v":14760},{"$f":"'Factor CO2'!K29","v":12740880},"Revolvedora Gas",{"$f":"'Factor CO2'!L29","v":31680},"Camión Gas",{"$f":"'Factor CO2'!M29","v":158400},{"$f":"'Factor CO2'!N29","v":190080},{"$f":"'Factor CO2'!O29","v":12930960.000000002},{"$f":"+(AL17-$AL$16)/$AL$16","v":-3.9469427369781809E-3},{"$f":"+AL17-$AL$16","v":-51239.999999998137},{"$f":"-0.088*AN17","v":4509.1199999998362},{"$f":"+AL17-$AL$20","v":180602.40000000224},{"$f":"-0.088*AP17","v":-15893.011200000195}]
[null,null,null,null,null,{"$f":"+M47","v":36.166666666666671},"              Ahorros con Mezclador LIEBHERR versus Revolvedora :",null,null,null,null,null,null,"Amasado Energia","Diesel",20640,{"$f":"+P18/$P$23","v":1.5896047244531113E-3},"Electricidad",{"$f":"+AE28","v":20640},{"$f":"-(P18-S18)/P18","v":0},"Electricidad",20640,{"$f":"+(V18-P18)/P18","v":0},{"$f":"+V18-P18","v":0},null,"Ring-pan 1.5 D","Revolvedora Eléctrica","Rev Elec Diesel",null,{"$f":"'Factor CO2'!I30","v":12726120},{"$f":"'Factor CO2'!J30","v":12120},{"$f":"'Factor CO2'!K30","v":12738240},"Revolvedora Eléctrica",{"$f":"'Factor CO2'!L30","v":25920},null,{"$f":"'Factor CO2'!M30","v":198000},{"$f":"'Factor CO2'!N30","v":223920},{"$f":"'Factor CO2'!O30","v":12962160},-1.5436520774599067E-3,-20040,{"$f":"-0.088*AN18","v":1763.52},211802.40000000037,{"$f":"-0.088*AP18","v":-18638.611200000032}]
[null,null,null,"Ahorro 8 a 19% cemento con :","Ring-pan 2.5 D",413917,{"$f":"+F19","v":413917},{"$f":"+F19","v":413917},{"$f":"+F19","v":413917},{"$f":"+F19","v":413917},{"$f":"+SUM(F19:J19)","v":2069585},{"$f":"+F19","v":413917},null,"Total Amasado",null,{"$f":"+P18+P17","v":12746760},{"$f":"+Q17+Q18","v":0.9817010618929235},null,{"$f":"+S18+S17","v":10539991.079999998},{"$f":"-(P19-S19)/P19","v":-0.17312390913455669},null,{"$f":"+V18+V17","v":10539991.079999998},-0.17312390913455669,-2206768.9200000018,null,"Ring-pan 2.5 D","Opción  4","Rev Elec Gas",null,{"$f":"'Factor CO2'!I31","v":12726120},{"$f":"'Factor CO2'!J31","v":12120},{"$f":"'Factor CO2'!K31","v":12738240},null,{"$f":"'Factor CO2'!L31","v":25920},null,{"$f":"'Factor CO2'!M31","v":158400},{"$f":"'Factor CO2'!N31","v":184320},{"$f":"'Factor CO2'!O31","v":12922560},-4.5939825299255903E-3,-59640,5248.32,172202.40000000037,-15153.811200000031]
[null,null,null,null,"Ahorro inversión Revolvedora :",{"$f":"+H110","v":71748},0,0,0,0,{"$f":"+SUM(F20:J20)","v":71748},0,null,"Transporte Paradas","Diesel",{"$f":"+AH16","v":39600},{"$f":"+P20/$P$23","v":3.0498230178460854E-3},"Diesel",{"$f":"+AH28","v":39600},{"$f":"-(P20-S20)/P20","v":0},"Revolvedora Eléctrica",25920,-0.34545454545454546,-13680,null,"Twin-shaft 1.25","Transporte Activo","Tilt Diesel","Tilt",{"$f":"'Factor CO2'!I32","v":12471597.6},{"$f":"'Factor CO2'!J32","v":41160},{"$f":"+AE20+AD20","v":12512757.6},null,{"$f":"'Factor CO2'!L32","v":39600},null,{"$f":"'Factor CO2'!M32","v":198000},{"$f":"+AJ20+AH20","v":237600},{"$f":"+AK20+AF20","v":12750357.6},-1.7858483153856849E-2,-231842.40000000037,20402.131200000033,0,0]
[null,null,null,null,"Ahorro diesel  Revolvedera Olla :",9019.2000000000007,{"$f":"+F21","v":9019.2000000000007},{"$f":"+F21","v":9019.2000000000007},{"$f":"+F21","v":9019.2000000000007},{"$f":"+F21","v":9019.2000000000007},45096,{"$f":"+F21","v":9019.2000000000007},null,"Transporte Activo","Diesel",{"$f":"+AJ16","v":198000},{"$f":"+P21/$P$23","v":1.5249115089230427E-2},"Diesel",{"$f":"+AJ28","v":198000},0,"Camión Gas",158400,-0.2,-39600,null,"Twin-shaft 2.25","Camión Diesel","Tilt Gas",null,{"$f":"'Factor CO2'!I33","v":12471597.6},{"$f":"'Factor CO2'!J33","v":41160},{"$f":"+AE21+AD21","v":12512757.6},null,{"$f":"'Factor CO2'!L33","v":31680},null,{"$f":"'Factor CO2'!M33","v":158400},{"$f":"+AJ21+AH21","v":190080},{"$f":"+AK21+AF21","v":12702837.6},-2.1518879696815669E-2,-279362.40000000037,24583.891200000031,{"$f":"+AL21-$AL$20","v":-47520},4181.7599999999993]
[null,null,null,null,"Ahorro/consumo electricidad Revolvedera Tilt :",0,{"$f":"+F22","v":0},{"$f":"+F22","v":0},{"$f":"+F22","v":0},{"$f":"+F22","v":0},{"$f":"+SUM(F22:J22)","v":0},{"$f":"+F22","v":0},null,"Total Transporte",null,{"$f":"+P21+P20","v":237600},{"$f":"+Q21+Q20","v":1.8298938107076512E-2},null,{"$f":"+S21+S20","v":237600},0,null,{"$f":"+V21+V20","v":184320},-0.22424242424242424,-53280,null,"Twin-shaft 3.0","Camión Gas","Tilt Rev Elec Diesel",null,{"$f":"'Factor CO2'!I34","v":12471597.6},{"$f":"'Factor CO2'!J34","v":41160},12512757.6,null,{"$f":"'Factor CO2'!L34","v":25920},null,{"$f":"'Factor CO2'!M34","v":198000},223920,12736677.6,-1.8912233673799538E-2,-245522.40000000037,21605.971200000033,-13680,1203.8399999999999]
[null,null,null,"Ahorros totales con :","Ring-pan 2.5 D",{"$f":"+F19+F20+F21","v":494684.2},422936.2,422936.2,422936.2,422936.2,2186429,422936.2,null,"GRAN TOTAL",null,{"$f":"+P22+P19","v":12984360},{"$f":"+Q22+Q19","v":1},null,{"$f":"+S22+S19","v":10777591.079999998},-0.1699559254364483,null,{"$f":"+V22+V19","v":10724311.079999998},-0.17405932367864121,-2260048.9200000018,null,"Twin-shaft 4.5",null,"Tilt Rev Elec Gas",null,{"$f":"'Factor CO2'!I35","v":12471597.6},{"$f":"'Factor CO2'!J35","v":41160},12512757.6,null,{"$f":"'Factor CO2'!L35","v":25920},null,{"$f":"'Factor CO2'!M35","v":158400},184320,12697077.6,-2.1962564126265221E-2,-285122.40000000037,25090.771200000032,-53280,4688.6399999999994]
[null,null,null,null," "," ","                Costo amortización Mezclador  LIEBHERR :",null,null,null,"Precio inversión :"," ",null,null,null,null,null," ",null,null,null,"Ahorro CO2 con control humedad con FMS LIEBHERR :",{"$f":"+X24/P23","v":-1.7171919164384802E-2},{"$f":"-'Cálculo cemento'!$V$26","v":-222966.38032127143},null,"MTS 4.5 Móvil",null,"Twin-shaft Diesel","Twin-shaft 3.5",{"$f":"'Factor CO2'!I36","v":11155657.08},{"$f":"'Factor CO2'!J36","v":14760},{"$f":"'Factor CO2'!K36","v":11170417.08},null,{"$f":"'Factor CO2'!L36","v":39600},null,{"$f":"'Factor CO2'!M36","v":198000},{"$f":"'Factor CO2'!N36","v":237600},{"$f":"'Factor CO2'!O36","v":11408017.08},{"$f":"+(AL24-$AL$16)/$AL$16","v":-0.12125702269260988},{"$f":"+AL24-$AL$16","v":-1574182.92},{"$f":"-0.088*AN24","v":138528.09696},{"$f":"+AL24-$AL$20","v":-1342340.5199999996},{"$f":"-0.088*AP24","v":118125.96575999995}]
[null,null,null,"Amortización :","Ring-pan 2.5 D",{"$f":"+K25/5","v":43494.8},{"$f":"+F25","v":43494.8},{"$f":"+F25","v":43494.8},{"$f":"+F25","v":43494.8},{"$f":"+F25","v":43494.8},217474,0," ",{"$f":"+N17","v":"Amasado Cemento"},{"$f":"+Q17","v":0.98011145716847037},null,null,{"$f":"+N25","v":"Amasado Cemento"},{"$f":"+S17-P17","v":-2206768.9200000018},null,{"$f":"+N25","v":"Amasado Cemento"},{"$f":"+V17-P17","v":-2206768.9200000018},null,null,null,"Planta Mobilmix 0.5",null,"Twin-shaft Gas",null,{"$f":"'Factor CO2'!I37","v":11155657.08},{"$f":"'Factor CO2'!J37","v":14760},{"$f":"'Factor CO2'!K37","v":11170417.08},null,{"$f":"'Factor CO2'!L37","v":31680},null,{"$f":"'Factor CO2'!M37","v":158400},{"$f":"'Factor CO2'!N37","v":190080},{"$f":"'Factor CO2'!O37","v":11360497.08},-0.12491741923556869,-1621702.92,142709.85695999998,{"$f":"+AL25-$AL$20","v":-1389860.5199999996},122307.72575999996]
[null,null,null,null,"Costo consumo de electricidad :",1633.1333333333334,{"$f":"+F26","v":1633.1333333333334},{"$f":"+F26","v":1633.1333333333334},{"$f":"+F26","v":1633.1333333333334},{"$f":"+F26","v":1633.1333333333334},{"$f":"+SUM(F26:J26)","v":8165.666666666667},{"$f":"+F26","v":1633.1333333333334},null,{"$f":"+N18","v":"Amasado Energia"},{"$f":"+Q18","v":1.5896047244531113E-3},null,null,{"$f":"+N26","v":"Amasado Energia"},{"$f":"+S18-P18","v":0},null,{"$f":"+N26","v":"Amasado Energia"},{"$f":"+V18-P18","v":0},null,null,null,"Planta LCM 1",null,"Twin-shaft Rev Elec Diesel",null,{"$f":"'Factor CO2'!I38","v":11155657.08},{"$f":"'Factor CO2'!J38","v":14760},{"$f":"'Factor CO2'!K38","v":11170417.08},null,{"$f":"'Factor CO2'!L38","v":25920},null,{"$f":"'Factor CO2'!M38","v":198000},{"$f":"'Factor CO2'!N38","v":223920},{"$f":"'Factor CO2'!O38","v":11394337.08},-0.12231077321255257,-1587862.92,139731.93695999999,-1356020.5199999996,119329.80575999996]
[null,null,null,"Total costos mezclado","Ring-pan 2.5 D",{"$f":"+F25+F26","v":45127.933333333334},{"$f":"+F27","v":45127.933333333334},{"$f":"+F27","v":45127.933333333334},{"$f":"+F27","v":45127.933333333334},{"$f":"+F27","v":45127.933333333334},{"$f":"+SUM(F27:J27)","v":225639.66666666669},{"$f":"+F27","v":45127.933333333334},null,{"$f":"+N20","v":"Transporte Paradas"},{"$f":"+Q20","v":3.0498230178460854E-3},null,null,{"$f":"+N20","v":"Transporte Paradas"},{"$f":"-(S20-P20)","v":0},null,"Transporte Paradas",{"$f":"+V20-P20","v":-13680},null,null,null,"Planta LCM 3",null,"Twin-shaft Rev Elec Gas",null,{"$f":"'Factor CO2'!I39","v":11155657.08},{"$f":"'Factor CO2'!J39","v":14760},{"$f":"'Factor CO2'!K39","v":11170417.08},null,{"$f":"'Factor CO2'!L39","v":25920},null,{"$f":"'Factor CO2'!M39","v":158400},{"$f":"'Factor CO2'!N39","v":184320},{"$f":"'Factor CO2'!O39","v":11354737.08},-0.12536110366501824,-1627462.92,143216.73695999998,-1395620.5199999996,122814.60575999995]
[null,null,null,null," "," ","Balance financiero = Beneficio adicional con Mezclador LIEBHERR :",null,null,null,null,"  ",null,{"$f":"+N21","v":"Transporte Activo"},{"$f":"+Q21","v":1.5249115089230427E-2},null,null,"Transporte Activo",{"$f":"-(S21-P21)","v":0},null,"Transporte Activo",{"$f":"+V21-P21","v":-39600},null,null,null,"Opción 1",null,"Ring-pan Diesel","Ring-pan 2.5 D",{"$f":"'Factor CO2'!I40","v":10519351.079999998},{"$f":"'Factor CO2'!J40","v":20640},{"$f":"'Factor CO2'!K40","v":10539991.079999998},null,{"$f":"'Factor CO2'!L40","v":39600},null,{"$f":"'Factor CO2'!M40","v":198000},{"$f":"'Factor CO2'!N40","v":237600},{"$f":"'Factor CO2'!O40","v":10777591.079999998},-0.16981782132458303,-2204608.9200000018,194005.58496000015,-1972766.5200000014,173603.45376000012]
[null,null,null,"Beneficio adicional con :","Ring-pan 2.5 D",{"$f":"+F23-F27","v":449556.26666666666},{"$f":"+G23-G27","v":377808.26666666666},377808.26666666666,377808.26666666666,377808.26666666666,1960789.3333333333,377808.26666666666,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revolvedora Olla",null,"Ring-pan Gas",null,{"$f":"'Factor CO2'!I41","v":10519351.079999998},{"$f":"'Factor CO2'!J41","v":20640},{"$f":"'Factor CO2'!K41","v":10539991.079999998},null,{"$f":"'Factor CO2'!L41","v":31680},null,{"$f":"'Factor CO2'!M41","v":158400},{"$f":"'Factor CO2'!N41","v":190080},{"$f":"'Factor CO2'!O41","v":10730071.079999998},-0.17347821786754186,-2252128.9200000018,198187.34496000013,-2020286.5200000014,177785.2137600001]
[null,null,null,"Años para pagar y cumulativo:","Ring-pan 2.5 D",{"$f":"+(K27/(K23/60))","v":6.1920053200904315},{"$f":"+F29+G29","v":827364.53333333333},{"$f":"+G30+H29","v":1205172.8},{"$f":"+H30+I29","v":1582981.0666666667},{"$f":"+I30+J29","v":1960789.3333333333}," ",{"$f":"+J30+L29","v":2338597.6},null,null,null,null,null,null,null,null,null,null,null,null,null,"Revolvedora Tilt",null,"Ring-pan Rev Elec Diesel",null,{"$f":"'Factor CO2'!I42","v":10519351.079999998},{"$f":"'Factor CO2'!J42","v":20640},{"$f":"'Factor CO2'!K42","v":10539991.079999998},null,{"$f":"'Factor CO2'!L42","v":25920},null,{"$f":"'Factor CO2'!M42","v":198000},{"$f":"'Factor CO2'!N42","v":223920},{"$f":"'Factor CO2'!O42","v":10763911.079999998},-0.17087157184452573,-2218288.9200000018,195209.42496000015,-1986446.5200000014,174807.29376000012]
[null,null,null,null," "," ","               Ahorro CO2 adicional con Mezclador M LIEBHERR :",null,null,null," ","  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ring-pan Rev Elec Gas",null,{"$f":"'Factor CO2'!I43","v":10519351.079999998},{"$f":"'Factor CO2'!J43","v":20640},{"$f":"'Factor CO2'!K43","v":10539991.079999998},null,{"$f":"'Factor CO2'!L43","v":25920},null,{"$f":"'Factor CO2'!M43","v":158400},{"$f":"'Factor CO2'!N43","v":184320},{"$f":"'Factor CO2'!O43","v":10724311.079999998},-0.17392190229699139,-2257888.9200000018,198694.22496000014,-2026046.5200000014,178292.09376000011]
[null,null,null,"Ahorro valor CO2 con ","Ring-pan 2.5 D",194005.58496000015,{"$f":"+F32","v":194005.58496000015},{"$f":"+F32","v":194005.58496000015},{"$f":"+F32","v":194005.58496000015},{"$f":"+F32","v":194005.58496000015},{"$f":"+SUM(F32:J32)","v":970027.92480000074},{"$f":"+F32","v":194005.58496000015},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Porcentaje del TOTAL",null,{"$f":"+SUM(AD16:AD31)/SUM($AL$16:$AL$31)","v":0.9806096605406357},{"$f":"+SUM(AE16:AE31)/SUM($AL$16:$AL$31)","v":1.9023181389005704E-3},{"$f":"+SUM(AF16:AF31)/SUM($AL$16:$AL$31)","v":0.98251197867953632},null,{"$f":"+SUM(AH16:AH31)/SUM($AL$16:$AL$31)","v":2.5757550782078329E-3},null,{"$f":"+SUM(AJ16:AJ31)/SUM($AL$16:$AL$31)","v":1.4912266242255874E-2},{"$f":"+SUM(AK16:AK31)/SUM($AL$16:$AL$31)","v":1.7488021320463707E-2}]
[null,null,null,"Evolución Huella CO2 con ","Ring-pan 2.5 D",-2204608.9200000018,{"$f":"+F33","v":-2204608.9200000018},{"$f":"+G33","v":-2204608.9200000018},-2204608.9200000018,-2204608.9200000018,{"$f":"+SUM(F33:J33)","v":-11023044.600000009},{"$f":"+F33","v":-2204608.9200000018}]
[null,null,null,null,"Ahorro CO2 si control humedad 2 %",{"$f":"+X24","v":-222966.38032127143},{"$f":"+F34","v":-222966.38032127143},{"$f":"+G34","v":-222966.38032127143},{"$f":"+H34","v":-222966.38032127143},{"$f":"+I34","v":-222966.38032127143},{"$f":"+SUM(F34:J34)","v":-1114831.9016063572},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AB30","v":"Ring-pan Rev Elec Diesel"},{"$f":"+AL30","v":10763911.079999998},{"$f":"+AC34","v":"Ring-pan Rev Elec Diesel"},{"$f":"+AM30","v":-0.17087157184452573}]
[null,null,null,null,"SU PRODUCCIÓN DE CONCRETO ANUAL :",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AB31","v":"Ring-pan Rev Elec Gas"},{"$f":"+AL31","v":10724311.079999998},"Ring-pan Rev Elec Gas",{"$f":"+AM31","v":-0.17392190229699139}]
[null,null,null,null,"Resistencia concreto",null,"Producción ","Formulación kg/m3",null,"Agregados",null,null,null,null,null," "]
[null,null," ",null,"Mpa","kg/cm2*","anual","Agua","Cemento","húmedos","Total","Agua/Cem","%Agua","MPa teórica"]
[null,null," ",null,"Bloque 10-20 MPa","90-200 kg/cm2",{"$f":"+G9","v":0},{"$f":"+H9","v":0},0,0,{"$f":"+SUM(H38:J38)","v":0},{"$f":"IFERROR('Cálculo humedad'!J27,0)","v":0},{"$f":"IFERROR(+H38/K38,0)","v":0},{"$f":"'Cálculo humedad'!$K$27","v":0}]
[null,null," ",null,"25 MPa","250 kg/cm2",{"$f":"+G10","v":0.3},180,250,600,{"$f":"+SUM(H39:J39)","v":1030},{"$f":"IFERROR('Cálculo humedad'!J28,0)","v":0.72},{"$f":"IFERROR(+H39/K39,0)","v":0.17475728155339806},{"$f":"'Cálculo humedad'!$K$28","v":17.777777777777779}]
[null,null," ",null,"30 MPa","300-320 kg/cm2",0.3,180,300,600,1080,{"$f":"IFERROR('Cálculo humedad'!J30,0)","v":0.6},{"$f":"IFERROR(+H40/K40,0)","v":0.16666666666666666},{"$f":"'Cálculo humedad'!K30","v":23.333333333333336}]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,180,430,600,{"$f":"+SUM(H41:J41)","v":1210},{"$f":"IFERROR('Cálculo humedad'!J31,0)","v":0.41860465116279072},0.1487603305785124,{"$f":"'Cálculo humedad'!K31","v":37.777777777777779}]
[null,null," ",null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,180,450,600,1230,{"$f":"'Cálculo humedad'!J33","v":0.4},0.14634146341463414,{"$f":"'Cálculo humedad'!K33","v":40}]
[null,null," ",null,"Durmiente 65 Mpa","660 kg/cm2",0,0,0,0,0,{"$f":"'Cálculo humedad'!J34","v":0},0,{"$f":"'Cálculo humedad'!K34","v":0}]
[null,null,null,null,"* 1 kg/cm2 = 1,02 Mpa","Total detallado % :",{"$f":"+SUM(G38:G43)","v":1},"m3/hora",null,"Humedad mas baja :",0.01," "]
[null,null," ",null,null,"Total producido m3:",{"$f":"+G15","v":60000},{"$f":"+G45/(8*6*50)","v":25},null,"Humedad mas alta :",0.05," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ahorro cemento  y CO2 si 3% h°:"]
[null,null,null,null,null,null,null,null,null,null,"Ahorro cemento :",{"$f":"+L59","v":120555.55555555558},{"$f":"+(L47*H2)/G45","v":36.166666666666671}]
[null,null,null,null,"SI UTILIZAN UNA SONDA HUMEDAD FMS LIEBHERR : AHORRO CEMENTO y CO2.",null,null,null,null,null,"Mejora Huella CO2 :",{"$f":"'Cálculo cemento'!$V$26","v":222966.38032127143},{"$f":"+L48/G45","v":3.7161063386878572}]
[]
[null,null,null,null,"Resistencia concreto",null,"Si variación 1% corregida",null,"Si variación 2% corregida",null,"Si variación 3% corregida"]
[null,null,null,null,"Mpa","kg/cm2*","Bajada MPa","USD cemento","Bajada MPa","USD cemento","Bajada MPa","USD cemento",null,null,"Variación 1%","Variación 2%","Variación 3%"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",{"$f":"'Cálculo humedad'!$J$39","v":0},{"$f":"'Cálculo humedad'!$L$39","v":0},{"$f":"'Cálculo humedad'!$J$40","v":0},{"$f":"'Cálculo humedad'!$L$40","v":0},{"$f":"'Cálculo humedad'!$J$41","v":0},{"$f":"'Cálculo humedad'!$L$41","v":0},null,{"$f":"+E52","v":"Bloque 10-20 MPa"},{"$f":"+H52","v":0},{"$f":"+J52","v":0},{"$f":"+L52","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",{"$f":"'Cálculo humedad'!$J$44","v":-0.89605734767025425},{"$f":"'Cálculo humedad'!$L$44","v":9408.6021505376684},{"$f":"'Cálculo humedad'!$J$45","v":-1.7361111111111143},{"$f":"'Cálculo humedad'!$L$45","v":18229.166666666701},{"$f":"'Cálculo humedad'!$J$46","v":-2.5252525252525277},{"$f":"'Cálculo humedad'!$L$46","v":26515.151515151541},null,{"$f":"+E53","v":"25 MPa"},{"$f":"+H53","v":9408.6021505376684},{"$f":"+J53","v":18229.166666666701},26515.151515151541]
[null,null,null,null,"30 MPa","300-320 kg/cm2",{"$f":"'Cálculo humedad'!$J$50","v":-1.0752688172043001},{"$f":"'Cálculo humedad'!$L$50","v":11290.322580645152},{"$f":"'Cálculo humedad'!$J$51","v":-2.0833333333333357},{"$f":"'Cálculo humedad'!$L$51","v":21875.000000000025},{"$f":"'Cálculo humedad'!$J$52","v":-3.0303030303030312},{"$f":"'Cálculo humedad'!$L$52","v":31818.181818181827},null,"30 MPa",11290.322580645152,21875.000000000025,31818.181818181827]
[null,null,null,null,"35 MPa","350-400 kg/cm2",{"$f":"'Cálculo humedad'!$J$55","v":-1.5412186379928272},{"$f":"'Cálculo humedad'!$L$55","v":10788.530465949791},{"$f":"'Cálculo humedad'!$J$56","v":-2.9861111111111072},{"$f":"'Cálculo humedad'!$L$56","v":20902.777777777752},{"$f":"'Cálculo humedad'!$J$57","v":-4.3434343434343461},{"$f":"'Cálculo humedad'!$L$57","v":30404.040404040421},null,"35 MPa",10788.530465949791,20902.777777777752,30404.040404040421]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",{"$f":"'Cálculo humedad'!$J$61","v":-1.6129032258064484},{"$f":"'Cálculo humedad'!$L$61","v":11290.322580645139},{"$f":"'Cálculo humedad'!$J$62","v":-3.125},{"$f":"'Cálculo humedad'!$L$62","v":21875},{"$f":"'Cálculo humedad'!$J$63","v":-4.5454545454545396},{"$f":"'Cálculo humedad'!$L$63","v":31818.18181818178},null,"Vigueta 350-45 Mpa",11290.322580645139,21875,31818.18181818178]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",{"$f":"'Cálculo humedad'!$J$66","v":0},{"$f":"'Cálculo humedad'!$L$66","v":0},{"$f":"'Cálculo humedad'!$J$67","v":0},{"$f":"'Cálculo humedad'!$L$67","v":0},{"$f":"'Cálculo humedad'!$J$68","v":0},{"$f":"'Cálculo humedad'!$L$68","v":0},null,"Durmiente 65 Mpa",0,0,0]
[null,null,null,null," ","Total especificado :"," ",{"$f":"+SUM(H52:H57)","v":42777.777777777752}," ",{"$f":"+SUM(J52:J57)","v":82881.944444444482},null,{"$f":"+SUM(L52:L57)","v":120555.55555555558}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"}," ",{"$f":"+(H58/$H$70)*$G$45","v":42777.777777777752}," ",{"$f":"+(J58/$H$70)*$G$45","v":82881.944444444482},null,{"$f":"+(L58/$H$70)*$G$45","v":120555.55555555558}]
[]
[null,null,null,null,"SU PRODUCCIÓN DE CONCRETO ANUAL :",null,null,"REPARTICION Y CONSUMO CEMENTO"]
[null,null,null,null,"Resistencia concreto",null,"Producción ","Concreto","Cemento"]
[null,null,null,null,"Mpa","kg/cm2*","Entrar %","M3  ","Tonelada",null,null,null,"Concreto m3","Cemento t"]
[null,null," ",null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,{"$f":"'Cálculo cemento'!G18","v":0},{"$f":"'Cálculo cemento'!I18","v":0},null,null,{"$f":"+E64","v":"Bloque 10-20 MPa"},{"$f":"+H64","v":0},{"$f":"+I64","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,{"$f":"'Cálculo cemento'!G19","v":18000},{"$f":"'Cálculo cemento'!I19","v":4500},null,null,{"$f":"+E65","v":"25 MPa"},{"$f":"+H65","v":18000},{"$f":"+I65","v":4500}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,{"$f":"'Cálculo cemento'!G20","v":18000},{"$f":"'Cálculo cemento'!I20","v":5400},null,null,"30 MPa",18000,5400]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,{"$f":"'Cálculo cemento'!G21","v":12000},{"$f":"'Cálculo cemento'!I21","v":5160},null,null,"35 MPa",12000,5160]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,{"$f":"'Cálculo cemento'!G22","v":12000},{"$f":"'Cálculo cemento'!I22","v":5400},null,null,"Vigueta 350-45 Mpa",12000,5400]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,{"$f":"'Cálculo cemento'!G23","v":0},{"$f":"'Cálculo cemento'!I23","v":0},null,null,"Durmiente 65 Mpa",0,0]
[null,null,null,null," ",{"$f":"+F44","v":"Total detallado % :"},{"$f":"+G44","v":1},{"$f":"'Cálculo cemento'!$G$24","v":60000},{"$f":"'Cálculo cemento'!$I$24","v":20460}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000}," ",{"$f":"'Cálculo cemento'!$I$25","v":20460}]
[]
[]
[null,null,null,null,"SI CAMBIA DE REVOLVEDORA A TWIN-SHAFT : AHORRO DE 9-14 % de CEMENTO : POR AÑO."]
[]
[null,null,null,null,"Resistencia concreto",null,"Producción anual ","     Ahorro cemento"]
[null,null,null,null,"Mpa","kg/cm2*","% entrados ","ton/año","USD/año",null,null,null,"kg","USD"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,0,0,null,null,{"$f":"+E78","v":"Bloque 10-20 MPa"},{"$f":"+H78*1000","v":0},{"$f":"+I78","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,598.5,69825,null,null,"25 MPa",{"$f":"+H79*1000","v":598500},{"$f":"+I79","v":69825}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,577.79999999999995,67410,null,null,"30 MPa",577800,67410]
[null,null,null,null,{"$f":"+E40","v":"30 MPa"},{"$f":"+F40","v":"300-320 kg/cm2"},{"$f":"+G41","v":0.2},727.56,84881.999999999985,null,null,"30 MPa",727560,84881.999999999985]
[null,null,null,null,{"$f":"+E42","v":"Vigueta 350-45 Mpa"},{"$f":"+F42","v":"350-450 kg/cm2"},{"$f":"+G42","v":0.2},621,72450,null,null,"Vigueta 350-45 Mpa",621000,72450]
[null,null,null,null,{"$f":"+E43","v":"Durmiente 65 Mpa"},{"$f":"+F43","v":"660 kg/cm2"},{"$f":"+G43","v":0},0,0,null,null,"Durmiente 65 Mpa",0,0]
[null,null,null,null,null,{"$f":"+F44","v":"Total detallado % :"},{"$f":"+SUM(G78:G83)","v":1},{"$f":"'Cálculo cemento'!G42","v":2524.8599999999997},{"$f":"+SUM(I78:I83)","v":294567}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000},{"$f":"+H84","v":2524.8599999999997},{"$f":"+I84","v":294567}]
[]
[null,null,null,null,"SI CAMBIO DE REVOLVEDORA A RING-PAN : AHORRO DE 20 % CEMENTO : POR AÑO."]
[]
[null,null,null,null,"Resistencia concreto",null,"Producción anual ","     Ahorro cemento"]
[null,null,null,null,"Mpa","kg/cm2*","% entrados ","ton/año","USD/año",null,null,null,"kg","USD"]
[null,null,null,null,{"$f":"+E52","v":"Bloque 10-20 MPa"},{"$f":"+F64","v":"90-200 kg/cm2"},{"$f":"+G64","v":0},0,0,null,null,{"$f":"+E91","v":"Bloque 10-20 MPa"},{"$f":"+H91*1000","v":0},{"$f":"+I91","v":0}]
[null,null,null,null,{"$f":"+E53","v":"25 MPa"},{"$f":"+F65","v":"250 kg/cm2"},0.3,823.5,96075,null,null,"25 MPa",823500,96075]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,847.8,98910,null,null,"30 MPa",847800,98910]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,985.56000000000006,114982.00000000001,null,null,"35 MPa",985560.00000000012,114982.00000000001]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,891,103950,null,null,"Vigueta 350-45 Mpa",891000,103950]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,0,0,null,null,"Durmiente 65 Mpa",0,0]
[null,null,null,null," ",{"$f":"+F55","v":"350-400 kg/cm2"},{"$f":"+SUM(G91:G96)","v":1},{"$f":"'Cálculo cemento'!P42","v":3547.86},{"$f":"+SUM(I91:I96)","v":413917}]
[null,null,null,null,null,{"$f":"+F56","v":"350-450 kg/cm2"},{"$f":"+G71","v":60000},{"$f":"+H97","v":3547.86},{"$f":"+I97","v":413917}]
[]
[null,null,null,null,"SI CAMBIA DE OLLA A MEZCLADOR LIEBHERR : AHORRO COSTO REVOLVEDORA."]
[null,null,null,null,"Resistencia concreto",null,"Producción anual ","Ahorro tiempo hormigonera"]
[null,null,null,null,"Mpa","kg/cm2","% entrados ","Valor USD/año",null,null,null,"Inversión olla","Gazolina"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,{"$f":"'Cálculo cemento'!H48","v":0},null,null,{"$f":"+E103","v":"Bloque 10-20 MPa"},{"$f":"+H103","v":0},{"$f":"+H115","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,{"$f":"'Cálculo cemento'!H49","v":13122},null,null,{"$f":"+E104","v":"25 MPa"},{"$f":"+H104","v":13122},{"$f":"+H116","v":1650.6}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,{"$f":"'Cálculo cemento'!H50","v":18378},null,null,"30 MPa",18378,2309.4]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,{"$f":"'Cálculo cemento'!H51","v":17496},null,null,"35 MPa",17496,2199.6]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,{"$f":"'Cálculo cemento'!H52","v":22752},null,null,"Vigueta 350-45 Mpa",22752,2859.6]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,{"$f":"'Cálculo cemento'!H53","v":0},null,null,"Durmiente 65 Mpa",0,0]
[null,null,null,null," ",{"$f":"+F44","v":"Total detallado % :"},{"$f":"+G44","v":1},{"$f":"'Cálculo cemento'!H54","v":71748}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000},{"$f":"'Cálculo cemento'!H55","v":71748}]
[]
[null,null,null,null,"SI CAMBIA DE OLLA A MEZCLADOR LIEBHERR : AHORRO GAZOLINA."]
[null,null,null,null,"Resistencia concreto",null,"Producción anual ","Ahorro gazolina"]
[null,null,null,null,"Mpa","kg/cm2","% entrados ","Valor USD/año"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,{"$f":"'Cálculo cemento'!H59","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,{"$f":"'Cálculo cemento'!H60","v":1650.6}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,{"$f":"'Cálculo cemento'!H61","v":2309.4}]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,{"$f":"'Cálculo cemento'!H62","v":2199.6}]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,{"$f":"'Cálculo cemento'!H63","v":2859.6}]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,{"$f":"'Cálculo cemento'!H64","v":0}]
[null,null,null,null," ",{"$f":"+F44","v":"Total detallado % :"},{"$f":"+G44","v":1},{"$f":"'Cálculo cemento'!H65","v":9019.2000000000007}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000},{"$f":"'Cálculo cemento'!H66","v":9019.2000000000007}]
[]
[null,null,null,null,"SI CAMBIO DE OLLA A TWIN-SHAFT LIEBHERR : AHORRO OLLA+GAZOLINA."]
[null,null,null,null,"Resistencia concreto",null,"Producción anual ","Ahorro gazolina"]
[null,null,null,null,"Mpa","kg/cm2","% entrados ","Valor USD/año"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,{"$f":"+H115+H103","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,{"$f":"+H116+H104","v":14772.6}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,20687.400000000001]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,19695.599999999999]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,25611.599999999999]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,0]
[null,null,null,null," ",{"$f":"+F44","v":"Total detallado % :"},{"$f":"+G44","v":1},80767.199999999997]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000},80767.199999999997]
[]
[null,null,null,null,"SI CAMBIO DE OLLA A MTS : GAZOLINA  : EMISION CO2 : Gramos/M3 :"]
[null,null,null,null,null,"%","m3/año","Kg CO2 emitidos por año",null,null,null,"Emisión CO2 kg"]
[null,null,null,null,{"$f":"+E38","v":"Bloque 10-20 MPa"},"90-200 kg/cm2",0,{"$f":"'Cálculo CO2 directo'!H45","v":0},"kg/año",null,{"$f":"+E138","v":"Bloque 10-20 MPa"},{"$f":"+H138","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.3,{"$f":"'Cálculo CO2 directo'!H46","v":3960},"kg/año",null,{"$f":"+E139","v":"25 MPa"},{"$f":"+H139","v":3960}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0.3,{"$f":"'Cálculo CO2 directo'!H47","v":5544},"kg/año",null,"30 MPa",5544]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.2,{"$f":"'Cálculo CO2 directo'!H48","v":5280},"kg/año",null,"35 MPa",5280]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0.2,{"$f":"'Cálculo CO2 directo'!H49","v":6863.9999999999991},"kg/año",null,"Vigueta 350-45 Mpa",6863.9999999999991]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,{"$f":"'Cálculo CO2 directo'!H50","v":0},"kg/año",null,"Durmiente 65 Mpa",0]
[null,null,null,null,null,{"$f":"+F44","v":"Total detallado % :"},{"$f":"+G44","v":1},{"$f":"'Cálculo CO2 directo'!H51","v":21648},"kg/año"]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":60000},{"$f":"'Cálculo CO2 directo'!H52","v":72160},"kg/año"]

{"sheet":"Reemplazar Olla por Ring-pan","index":1,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"SOLUCIONES LIEBHERR CON MEZCLADOR RING-PAN :",null,null,null,null,null,null,null,null,"Si"]
[null,null,null,null,null,null,null,null,null,"RING-PAN : ",null,"hasta 120 m3/hora, cualquier tipo de concreto.",null,null,null,null,null,null,"No"]
[null,"PLANTA DOSIFICADORA   +   REVOLVEDORA CAMION (OLLA)",null,null,null,null,null,null,null,"Solución n°1 : INSTALAR EL RING-PAN.",null,null,null,null,"Cuestionario técnico"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Planta dosificadora antes :",null,null,null,"Planta dosificadora después :"]
[]
[null,null,null,null,null,null,null,"AHORRO 15-20 % "]
[null,null,null,null,null,null,null,"CEMENTO"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Solución n°2 : ",null,"INSTALAR EL MEZCLADOR SOBRE PLATAFORMA."]
[null,null,null,null,null,null,null,null,null,null,null,"Cuestionario técnico."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"ITISA Tlaxcala, 2021."]
[]
[null,null,null,null,null,null,null,null,null,"CEMEX Aeropuerto Texcoco.",null,null,null,"CEMEX Autopista Cd. Obregon"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Solución n°3 : PLANTA COMPLETA LIEBHERR. ",null,null,null,null,"Precisión 0.5 %."]
[null,null,null,null,null,null,null,null,null,"MOBILMIX 0.5 CON Ring-pan 0.5 ",null,null,null,"LCM 1.0 con Ring-pan 1.0 "]
[null,null,null,null,null,null,null,null,null,"30 m3/hora",null,null,null,"60 m3/hora"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"                         HOLCIM Swiza, 2022."]
[null,null,null,null,null,null,null," "]

{"sheet":"Reemplazar Olla por TWIN-SHAFT","index":2,"n_rows":57,"n_cols":19,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"SOLUCIONES LIEBHERR CON MEZCLADOR :"]
[null,null,null,null,null,null,null,null,null,"TWIN-SHAFT : ",null,"hasta 190 m3/hora, concreto hasta 45 MPa.",null,null,null,null,null,null," "]
[null,"PLANTA DOSIFICADORA   +   REVOLVEDORA CAMION (OLLA)",null,null,null,null,null,null,null,"Solución n°1 : INSTALAR EL TWIN-SHAFT",null,null,null,null,"Cuestionario técnico"]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Planta dosificadora antes :",null,null,null,"Planta dosificadora después :"]
[]
[null,null,null,null,null,null,null,"AHORRO 8-13 % "]
[null,null,null,null,null,null,null,"CEMENTO"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Solución n°2 : ",null,"INSTALAR EL MEZCLADOR SOBRE PLATAFORMA."]
[null,null,null,null,null,null,null,null,null,null,null,"Cuestionario técnico."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,"CEMEX Aeropuerto Texcoco.",null,null,null,"CEMEX Autopista Cd. Obregon"]
[null,null,null,null,null,null,null,null,null,"Solución n°3 : ",null,"MOBILE TWIN-SHAFT 4.5 MTS"]
[null,null,null,null,null,null,null,null,null,"                            MEZCLADOR Y INGENIERIA LIEBHERR."," "," "]
[]
[null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Autopista Monterrey a Laredo; Magnamaq.",null,null,null,"Autopista Cd. Obregon a Hermosillo."]
[null,null,null,null,null,null,null,null,null,"Solución n°4 : PLANTA COMPLETA LIEBHERR. ",null,null,null,null,"Precisión 0.5 %."]
[null,null,null,null,null,null,null,null,null,"LCM 3 con TWIN-SHAFT  3.0 ",null,null,null,"Betomix Twin-shaft 2.5"]
[null,null,null,null,null,null,null,null,null,"150 m3/hora",null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,"Solución n°5 : FABRICAR UNA PLANTA EN MEXICO CON"]
[null,null,null,null,null,null,null,null,null,"                            MEZCLADOR Y INGENIERIA LIEBHERR."]
[]
[null,null,null,null,null,null,null,null,null,"HOLCIM : Twin-shaft 4.5"]

{"sheet":"Reemplazar Tilt por Twin-shaft","index":3,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"PLANTA DOSIFICADORA   +   REVOLVEDORA TILT ",null,null,null,null,null,null,null,null,null,"SOLUCIONES LIEBHERR CON MEZCLADOR :"]
[null,null,null,null,null,null,null,null,null,null,null,"TWIN-SHAT;  hasta 190 m3/hora."]
[null,null,null,null,null,null,null,null,null,null,null,"SOLUCION N°1 : INSTALAR UN TWIN-SHAFT."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuestionario técnico"]
[]
[null,null,null,null,null,null,null,"AHORRO DE 8-13 % CEMENTO"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revolvedora Tilt"]
[]
[]
[]
[]
[null,null,null,null,null," "]
[null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Solución n°2 : ",null,"MOBILE TWIN-SHAFT 4.5 MTS"]
[null,null,null,null,null,null,null,null,null,null,null,"                            MEZCLADOR Y INGENIERIA LIEBHERR."," "," "]
[]
[null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Autopista Monterrey a Laredo; Magnamaq.",null,null,null,"Autopista Cd. Obregon a Hermosillo."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,593.25,77122.500000000015]
[null,null,null,null,null,null,null,548.1,71253.000000000015]
[null,null,null,null,null,null,null,592.9,77077]
[null,null,null,null,null,null,null,598.5,77805]
[null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,945,122850]
[null,null,null,null,null,null,null,1134,147420]
[null,null,null,null,null,null,null,882,114660]
[null,null,null,null,null,null,null,1134,147420]
[null,null,null,null,null,null,null,0,0]

{"sheet":"Factor CO2","index":4,"n_rows":61,"n_cols":15,"rows_kept":61,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,"Producción anual :",{"$f":"'Ring-pan y Huella CO2'!$G$45","v":60000}]
[]
[null,null,"Nombre","SISTEMA AMASADO","ENERGIA ","TRANSPORTE ","ENERGIA","ENERGIA","             AMASADO",null,null,"         TRANSPORTE",null,null,"TOTAL"]
[null,null,null,null,"UTILIZASA "," ","UTILIZADA","UTILIZADA","CEMENTO","ENERGIA","TOTAL","PARADAS","ACTIVO","TOTAL"]
[null,null,null,null,"AMASADO",null,"PARADAS","TRANSPORTE ACTIVO"]
[null,null,"Rev. Diesel","Revolvedora normal","Diesel chasis","Revolvedora+diesel","Diesel","Diesel",{"$f":"'Cálculo cemento'!$N$25","v":212.102},0.308,{"$f":"+I10+J10","v":212.41},0.66,3.3,{"$f":"+L10+M10","v":3.96},{"$f":"+N10+K10","v":216.37}]
[null,null,"Rev. Gas","Revolvedora normal","Gas  chasis","Revolvedora+gas","Gas","Gas",{"$f":"+I10","v":212.102},0.246,{"$f":"+I11+J11","v":212.34800000000001},0.52800000000000002,2.64,{"$f":"+L11+M11","v":3.1680000000000001},{"$f":"+N11+K11","v":215.51600000000002}]
[null,null,"Rev Elec Diesel","Revolvedora eléctrica Plug-in","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I10","v":212.102},0.20200000000000001,212.304,0.432,{"$f":"+M10","v":3.3},3.7319999999999998,216.036]
[null,null,"Rev Elec Gas","Revolvedora eléctrica Plug-in","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I10","v":212.102},0.20200000000000001,212.304,{"$f":"+L12","v":0.432},{"$f":"+M11","v":2.64},3.0720000000000001,215.376]
[null,null,"Tilt Diesel","Revolvedora Tilt","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",{"$f":"'Cálculo cemento'!$O$25","v":207.85996},0.68600000000000005,{"$f":"+I14+J14","v":208.54596000000001},{"$f":"+L10","v":0.66},3.3,{"$f":"+L14+M14","v":3.96},{"$f":"+N14+K14","v":212.50596000000002}]
[null,null,"Tilt Gas","Revolvedora Tilt","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I14","v":207.85996},{"$f":"+J14","v":0.68600000000000005},208.54596000000001,0.52800000000000002,2.64,3.1680000000000001,211.71396000000001]
[null,null,"Tilt Rev Elec Diesel","Revolvedora Tilt","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I14","v":207.85996},{"$f":"+J14","v":0.68600000000000005},208.54596000000001,0.432,3.3,3.7319999999999998,212.27796000000001]
[null,null,"Tilt Rev Elec Gas","Revolvedora Tilt","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I14","v":207.85996},{"$f":"+J14","v":0.68600000000000005},208.54596000000001,0.432,2.64,3.0720000000000001,211.61796000000001]
[null,null,"Twin-shaft Diesel","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",{"$f":"'Cálculo cemento'!$Q$25","v":185.927618},0.246,186.173618,{"$f":"+L10","v":0.66},{"$f":"+M10","v":3.3},3.96,190.13361800000001]
[null,null,"Twin-shaft Gas","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I18","v":185.927618},{"$f":"+J18","v":0.246},186.173618,{"$f":"+L11","v":0.52800000000000002},2.64,3.1680000000000001,189.34161800000001]
[null,null,"Twin-shaft Rev Elec Diesel","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I18","v":185.927618},{"$f":"+J18","v":0.246},186.173618,{"$f":"+L12","v":0.432},3.3,3.7319999999999998,189.905618]
[null,null,"Twin-shaft Rev Elec Gas","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I18","v":185.927618},{"$f":"+J18","v":0.246},186.173618,{"$f":"+L13","v":0.432},2.64,3.0720000000000001,189.24561800000001]
[null,null,"Ring-pan Diesel","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",{"$f":"'Cálculo cemento'!$S$25","v":175.32251799999997},0.34399999999999997,175.66651799999997,{"$f":"+L10","v":0.66},{"$f":"+M10","v":3.3},3.96,179.62651799999998]
[null,null,"Ring-pan Gas","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I22","v":175.32251799999997},{"$f":"+J22","v":0.34399999999999997},175.66651799999997,{"$f":"+L11","v":0.52800000000000002},2.64,3.1680000000000001,178.83451799999997]
[null,null,"Ring-pan Rev Elec Diesel","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I22","v":175.32251799999997},{"$f":"+J22","v":0.34399999999999997},175.66651799999997,{"$f":"+L12","v":0.432},3.3,3.7319999999999998,179.39851799999997]
[null,null,"Ring-pan Rev Elec Gas","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I22","v":175.32251799999997},{"$f":"+J22","v":0.34399999999999997},175.66651799999997,{"$f":"+L13","v":0.432},2.64,3.0720000000000001,178.73851799999997]
[]
[null,null,null,null,null,null,null,null,"HUELLA CO2 EN KG PARA LA PRODUCCION ANUAL"]
[null,null,{"$f":"+C10","v":"Rev. Diesel"},null,null,null,null,null,{"$f":"+I10*$D$5","v":12726120},{"$f":"+J10*$D$5","v":18480},12744600,39600,198000,237600,12982200]
[null,null,{"$f":"+C11","v":"Rev. Gas"},null,null,null,null,null,{"$f":"+I11*$D$5","v":12726120},14760,12740880,31680,158400,190080,12930960.000000002]
[null,null,{"$f":"+C12","v":"Rev Elec Diesel"},null,null,null,null,null,{"$f":"+I12*$D$5","v":12726120},12120,12738240,25920,198000,223920,12962160]
[null,null,{"$f":"+C13","v":"Rev Elec Gas"},null,null,null,null,null,{"$f":"+I13*$D$5","v":12726120},12120,12738240,25920,158400,184320,12922560]
[null,null,{"$f":"+C14","v":"Tilt Diesel"},null,null,null,null,null,{"$f":"+I14*$D$5","v":12471597.6},41160,12512757.6,39600,198000,237600,12750357.600000001]
[null,null,"Tilt Gas",null,null,null,null,null,{"$f":"+I15*$D$5","v":12471597.6},41160,12512757.6,31680,158400,190080,12702837.600000001]
[null,null,"Tilt Rev Elec Diesel",null,null,null,null,null,{"$f":"+I16*$D$5","v":12471597.6},41160,12512757.6,25920,198000,223920,12736677.6]
[null,null,"Tilt Rev Elec Gas",null,null,null,null,null,{"$f":"+I17*$D$5","v":12471597.6},41160,12512757.6,25920,158400,184320,12697077.600000001]
[null,null,{"$f":"+C18","v":"Twin-shaft Diesel"},null,null,null,null,null,{"$f":"+I18*$D$5","v":11155657.08},14760,11170417.08,39600,198000,237600,11408017.08]
[null,null,"Twin-shaft Gas",null,null,null,null,null,{"$f":"+I19*$D$5","v":11155657.08},14760,11170417.08,31680,158400,190080,11360497.08]
[null,null,"Twin-shaft Rev Elec Diesel",null,null,null,null,null,{"$f":"+I20*$D$5","v":11155657.08},14760,11170417.08,25920,198000,223920,11394337.08]
[null,null,"Twin-shaft Rev Elec Gas",null,null,null,null,null,{"$f":"+I21*$D$5","v":11155657.08},14760,11170417.08,25920,158400,184320,11354737.08]
[null,null,"Ring-pan Diesel",null,null,null,null,null,{"$f":"+I22*$D$5","v":10519351.079999998},20640,10539991.079999998,39600,198000,237600,10777591.079999998]
[null,null,"Ring-pan Gas",null,null,null,null,null,{"$f":"+I23*$D$5","v":10519351.079999998},20640,10539991.079999998,31680,158400,190080,10730071.079999998]
[null,null,"Ring-pan Rev Elec Diesel",null,null,null,null,null,{"$f":"+I24*$D$5","v":10519351.079999998},20640,10539991.079999998,25920,198000,223920,10763911.079999998]
[null,null,"Ring-pan Rev Elec Gas",null,null,null,null,null,{"$f":"+I25*$D$5","v":10519351.079999998},20640,10539991.079999998,25920,158400,184320,10724311.079999998]
[]
[null,null,null,null,null,null,null,null,"HUELLA CO2 EN TONELADA PARA LA PRODUCCIION ANUAL"]
[null,null,{"$f":"+C10","v":"Rev. Diesel"},null,null,null,null,null,{"$f":"+(I10*$D$5)/1000","v":12726.12},{"$f":"+(J10*$D$5)/1000","v":18.48},12744.6,39.6,198,237.6,12982.2]
[null,null,{"$f":"+C11","v":"Rev. Gas"},null,null,null,null,null,{"$f":"+(I11*$D$5)/1000","v":12726.12},14.76,12740.88,31.68,158.4,190.08,12930.960000000003]
[null,null,{"$f":"+C12","v":"Rev Elec Diesel"},null,null,null,null,null,{"$f":"+(I12*$D$5)/1000","v":12726.12},12.12,12738.24,25.92,198,223.92,12962.16]
[null,null,{"$f":"+C13","v":"Rev Elec Gas"},null,null,null,null,null,{"$f":"+(I13*$D$5)/1000","v":12726.12},12.12,12738.24,25.92,158.4,184.32,12922.56]
[null,null,{"$f":"+C14","v":"Tilt Diesel"},null,null,null,null,null,{"$f":"+(I14*$D$5)/1000","v":12471.597599999999},41.16,12512.757599999999,39.6,198,237.6,12750.357600000001]
[null,null,"Tilt Gas",null,null,null,null,null,{"$f":"+(I15*$D$5)/1000","v":12471.597599999999},41.16,12512.757599999999,31.68,158.4,190.08,12702.837600000001]
[null,null,"Tilt Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I16*$D$5)/1000","v":12471.597599999999},41.16,12512.757599999999,25.92,198,223.92,12736.677599999999]
[null,null,"Tilt Rev Elec Gas",null,null,null,null,null,{"$f":"+(I17*$D$5)/1000","v":12471.597599999999},41.16,12512.757599999999,25.92,158.4,184.32,12697.077600000002]
[null,null,{"$f":"+C18","v":"Twin-shaft Diesel"},null,null,null,null,null,{"$f":"+(I18*$D$5)/1000","v":11155.657080000001},14.76,11170.417079999999,39.6,198,237.6,11408.01708]
[null,null,"Twin-shaft Gas",null,null,null,null,null,{"$f":"+(I19*$D$5)/1000","v":11155.657080000001},14.76,11170.417079999999,31.68,158.4,190.08,11360.497079999999]
[null,null,"Twin-shaft Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I20*$D$5)/1000","v":11155.657080000001},14.76,11170.417079999999,25.92,198,223.92,11394.337079999999]
[null,null,"Twin-shaft Rev Elec Gas",null,null,null,null,null,{"$f":"+(I21*$D$5)/1000","v":11155.657080000001},14.76,11170.417079999999,25.92,158.4,184.32,11354.737080000001]
[null,null,"Ring-pan Diesel",null,null,null,null,null,{"$f":"+(I22*$D$5)/1000","v":10519.351079999999},20.64,10539.991079999998,39.6,198,237.6,10777.591079999998]
[null,null,"Ring-pan Gas",null,null,null,null,null,{"$f":"+(I23*$D$5)/1000","v":10519.351079999999},20.64,10539.991079999998,31.68,158.4,190.08,10730.071079999998]
[null,null,"Ring-pan Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I24*$D$5)/1000","v":10519.351079999999},20.64,10539.991079999998,25.92,198,223.92,10763.911079999998]
[null,null,"Ring-pan Rev Elec Gas",null,null,null,null,null,{"$f":"+(I25*$D$5)/1000","v":10519.351079999999},20.64,10539.991079999998,25.92,158.4,184.32,10724.311079999998]

{"sheet":"Cálculo cemento","index":5,"n_rows":66,"n_cols":28,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Costo cemento :",null,{"$f":"'Ring-pan y Huella CO2'!$H$1","v":2.1},"Pesos/kg",{"$f":"+G3/G4","v":0.11666666666666667},"USD"]
[null,null,null,null,"1 USD =",null,{"$f":"'Ring-pan y Huella CO2'!$H$2","v":18},"Pesos"]
[null,null," "]
[null,null,null,null," "]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!F10","v":"25 MPa"},{"$f":"'Ring-pan y Huella CO2'!G10","v":0.3}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!F12","v":"35 MPa"},{"$f":"'Ring-pan y Huella CO2'!G11","v":0.3}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!B4","v":"EQUIPO FRANCES SA DE CV, Colima, 21 Jun. 2020, versión Sep. 22 2022."},null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,"SU PRODUCCIÓN DE CONCRETO ANUAL :",null,null,null,null,null,"Estimación mercado","Bajada huella","Huella final"]
[null,null,null,null,null,"%","m3/año","Cemento consumido con Olla* :",null,null,{"$f":"'Ring-pan y Huella CO2'!$L$13","v":622},{"$f":"'Ring-pan y Huella CO2'!$L$14","v":0},{"$f":"+K16*(1-L16)","v":622},null,"Tilt","Twin-shaft",null,"Ring-pan",null,"Sistema FMS 3 % :",null,null,null,"Ahorro entre Olla y Planetario o Twin-shaft :"]
[null,null,null,null,null,null,null,"kg/m3","t/año",null,"kg CO2","kg CO2/m3",null,null," ","kg CO2","Kg CO2/m3","kg CO2","Kg CO2/m3","kg cemento/m3","kg cemento","kg CO2","USD","15 Mpa*",20,{"$f":"+Y17/AA17","v":{"$error":"#REF!"}},{"$f":"'Ring-pan y Huella CO2'!#REF!","v":{"$error":"#REF!"}},0.13333333333333333]
[null,null,null,"Bloque n°1 Sólido 5MPa","40-50 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G38","v":0},{"$f":"+F18*$F$25","v":0},{"$f":"'Ring-pan y Huella CO2'!I38","v":0},{"$f":"+G18*H18/1000","v":0},null,{"$f":"+I18*$K$16","v":0},{"$f":"+K18/G18","v":{"$error":"#DIV/0!"}},{"$f":"+I18*$M$16","v":0},{"$f":"+M18/G18","v":{"$error":"#DIV/0!"}},{"$f":"+N18*(1-K36)","v":{"$error":"#DIV/0!"}},{"$f":"+I18*(1-J36)*$M$16","v":0},{"$f":"+P18/G18","v":{"$error":"#DIV/0!"}},{"$f":"+I18*(1-O36)*$M$16","v":0},null,{"$f":"'[1]Cálculo humedad'!$K$41","v":0},{"$f":"+T18*G18","v":0},{"$f":"+(U18*$M$16)/1000","v":0},{"$f":"+U18*$I$3","v":0},"25 MPa",26.787499999999994,{"$f":"+Y18/AA18","v":0.10714999999999998},250,0.10714999999999998]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!$E$39","v":"25 MPa"},"90 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G39","v":0.3},18000,{"$f":"'Ring-pan y Huella CO2'!I39","v":250},{"$f":"+G19*H19/1000","v":4500},null,{"$f":"+I19*$K$16","v":2799000},{"$f":"+K19/G19","v":155.5},{"$f":"+I19*$M$16","v":2799000},{"$f":"+M19/G19","v":155.5},{"$f":"+N19*(1-K37)","v":152.38999999999999},{"$f":"+I19*(1-J37)*$M$16","v":2426733},{"$f":"+P19/G19","v":134.8185},{"$f":"+I19*(1-O37)*$M$16","v":2286782.9999999995},null,{"$f":"'[1]Cálculo humedad'!$K$46","v":0},{"$f":"+T19*G19","v":0},{"$f":"+(U19*$M$16)/1000","v":0},{"$f":"+U19*$I$3","v":0},"30 MPa",26.65,{"$f":"+Y19/AA19","v":8.8833333333333334E-2},300,8.8833333333333334E-2]
[null,null,null,"Prefabricado 35 MPa","357 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G40","v":0.3},18000,{"$f":"'Ring-pan y Huella CO2'!I40","v":300},5400,null,3358800,186.6,3358800,186.6,182.86799999999999,2999408.4,166.63380000000001,2831468.4,null,{"$f":"'[1]Cálculo humedad'!$K$52","v":10.590500641848539},190629.01155327371,118571.24518613625,22240.051347881934,"35 MPa",49.400000000000006,0.14114285714285715,350,0.14114285714285715]
[null,null,null,"Prefabricado 35 MPa","357 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G41","v":0.2},12000,{"$f":"'Ring-pan y Huella CO2'!$I$41","v":430},{"$f":"+G21*H21/1000","v":5160},null,3209520,267.45999999999998,3209520,267.45999999999998,262.11079999999998,2756977.6799999997,229.74813999999998,2596501.6799999997,null,{"$f":"'[1]Cálculo humedad'!$K$57","v":13.986486486486491},167837.8378378379,104395.13513513518,19581.081081081087]
[null,null,null,"Vigueta 45 Mpa","455 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G42","v":0.2},12000,{"$f":"'Ring-pan y Huella CO2'!$I$42","v":450},5400,null,3358800,279.89999999999998,3358800,279.89999999999998,274.30199999999996,2972538,247.7115,2804598,null,{"$f":"'[1]Cálculo humedad'!$K$63","v":0},0,0,0,"50 MPa",51.800000000000004,0.11511111111111112,450,0.11511111111111112]
[null,null,null,"Durmiento 65 Mpa","663 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!$G$43","v":0},0,{"$f":"'Ring-pan y Huella CO2'!$I$43","v":0},0,null,0,{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,null,{"$f":"'[1]Cálculo humedad'!$K$68","v":0},0,0,0,"65 MPa",{"$f":"+AA23*Z23","v":65.55},0.115,570,0.11511111111111112]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!F44","v":"Total detallado % :"},{"$f":"+SUM(F18:F23)","v":1},{"$f":"+SUM(G18:G23)","v":60000},{"$f":"IFERROR(+SUM(I18:I23)*1000/G24,0)","v":341},{"$f":"+SUM(I18:I23)","v":20460},null,12726120,212.102,12726120,212.102,207.85996]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!F45","v":"Total producido m3:"},{"$f":"'Ring-pan y Huella CO2'!$G$45","v":60000},null," ",{"$f":"+(F25*H24)/1000","v":20460},null,12726120,{"$f":"+K25/F25","v":212.102},12726120,{"$f":"+M25/F25","v":212.102},207.85996,{"$f":"+SUM(P18:P23)","v":11155657.08},{"$f":"+P25/F25","v":185.927618},{"$f":"+SUM(R18:R23)","v":10519351.079999998},{"$f":"+R25/F25","v":175.32251799999997},null,null,null,{"$f":"+SUM(W18:W23)","v":41821.132428963021}]
[null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(Q25-S25)/Q25","v":5.7038863371013666E-2},null,{"$f":"+SUM(U18:U23)","v":358466.84939111164},{"$f":"+SUM(V18:V23)","v":222966.38032127143},{"$f":"+U26*I3","v":41821.132428963028}]
[null,null,null,null," "]
[]
[]
[null,null,null,null,"SI CAMBIO DE OLLA A MEZCLADOR : AHORRO DE 9-14% de CEMENTO :",null,null,null,null," "]
[null,null,null,null," "]
[]
[null,null,null,null,null,"%","        TWIN-SHAFT con Olla",null,"Tilt","Twin-shaft","              TILT vs Olla",null,"DW versus Tilt",null,"Ring-pan","Ring-pan versus Olla",null,"Ring-pan vs Tilt",null,null,null,null,null," "]
[null,null,null,null,null,null,"t cemento","Valor USD",null,"vs Olla","% ahorro","t cemento","t","USD","Ahorros","cemento"]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,"toneladas","USD","t","USD"]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E38","v":"Bloque 10-20 MPa"},{"$f":"'Ring-pan y Huella CO2'!F38","v":"90-200 kg/cm2"},{"$f":"+F18","v":0},{"$f":"+I18*J36","v":0},{"$f":"+G36*$I$3*1000","v":0},{"$f":"+I18*(K36)*$I$3*1000","v":0},0.13300000000000001,0.02,{"$f":"+K36*I18","v":0},{"$f":"+G36-L36","v":0},{"$f":"+H36-I36","v":0},{"$f":"+J36+0.05","v":0.183},{"$f":"+O36*I18","v":0},{"$f":"+P36*$I$3*1000","v":0},{"$f":"+P36-L36","v":0},{"$f":"+Q36-I36","v":0}]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E39","v":"25 MPa"},{"$f":"'Ring-pan y Huella CO2'!F39","v":"250 kg/cm2"},0.3,598.5,{"$f":"+G37*$I$3*1000","v":69825},{"$f":"+I19*(K37)*$I$3*1000","v":10500},0.13300000000000001,0.02,{"$f":"+K37*I19","v":90},{"$f":"+G37-L37","v":508.5},{"$f":"+H37-I37","v":59325},{"$f":"+J37+0.05","v":0.183},823.5,{"$f":"+P37*$I$3*1000","v":96075},{"$f":"+P37-L37","v":733.5},{"$f":"+Q37-I37","v":85575}]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E40","v":"30 MPa"},{"$f":"'Ring-pan y Huella CO2'!F40","v":"300-320 kg/cm2"},0.3,577.79999999999995,67410,12600,0.107,0.02,108,469.79999999999995,54810,0.157,847.8,98910,739.8,86310]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E41","v":"35 MPa"},{"$f":"'Ring-pan y Huella CO2'!F41","v":"350-400 kg/cm2"},0.2,727.56,84881.999999999985,12040.000000000002,0.14099999999999999,0.02,103.2,624.3599999999999,72841.999999999985,0.191,985.56000000000006,114982.00000000001,882.36,102942.00000000001]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E42","v":"Vigueta 350-45 Mpa"},{"$f":"'Ring-pan y Huella CO2'!F42","v":"350-450 kg/cm2"},0.2,621,72450,12600,0.115,0.02,108,513,59850,0.16500000000000001,891,103950,783,91350]
[null,null,null,{"$f":"'Ring-pan y Huella CO2'!E43","v":"Durmiente 65 Mpa"},{"$f":"'Ring-pan y Huella CO2'!F43","v":"660 kg/cm2"},0,0,0,0,0.115,0.02,0,0,0,0.16500000000000001,0,0,0,0]
[null,null,null,null,{"$f":"+E24","v":"Total detallado % :"},{"$f":"+SUM(F36:F41)","v":1},{"$f":"+SUM(G36:G41)","v":2524.8599999999997},{"$f":"+SUM(H36:H41)","v":294567},{"$f":"+SUM(I36:I41)","v":47740},null,0.02,{"$f":"+SUM(L36:L41)","v":409.2},{"$f":"+SUM(M36:M41)","v":2115.66},246827,null,{"$f":"+SUM(P36:P41)","v":3547.86},413917,null,366177]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":60000},{"$f":"+(G42/G24)*F25","v":2524.8599999999997},{"$f":"+G43*I3*1000","v":294566.99999999994},{"$f":"+(I42/G24)*F43","v":47740},null,0.02,"A calculer",null,null,null,null,"A calculer"]
[null,null,null,null,null," "," ",null,null," "]
[]
[null,null,null,null,"SI CAMBIO DE OLLA A MTS : AHORRO DE OLLA  : TIEMPO PARA MEZCLAR.",null,null,null,null,null,null,null,"Twin-shaft versus Planetario",null,"Ring-pan","Ring-pan versus Planetario"]
[null,null,null,null,null,"%","USD/1000m3","Valor USD/año",null,null,null,null,"t","USD","Ahorros","cemento"]
[null,null,null,null,{"$f":"+E36","v":"90-200 kg/cm2"},{"$f":"+F36","v":0},{"$f":"+G49","v":729},{"$f":"+G48*G18/1000","v":0},null,null,null,null,null,null,null,"toneladas","USD"]
[null,null,null,null,{"$f":"+E37","v":"250 kg/cm2"},0.3,729,13122,null,null,null,null,{"$f":"+G49-L49","v":729},{"$f":"+H49-I49","v":13122},{"$f":"+J49+0.05","v":0.05},{"$f":"+O49*I31","v":0},{"$f":"+P49*$I$3*1000","v":0}]
[null,null,null,null,{"$f":"+E38","v":"300-320 kg/cm2"},0.3,1021,18378,null,null,null,null,{"$f":"+G50-L50","v":1021},{"$f":"+H50-I50","v":18378},{"$f":"+J50+0.05","v":0.05},0,{"$f":"+P50*$I$3*1000","v":0}]
[null,null,null,null,{"$f":"+E39","v":"350-400 kg/cm2"},0.2,1458,17496,null,null,null,null,1458,17496,0.05,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,{"$f":"+E40","v":"350-450 kg/cm2"},0.2,1896,22752,null,null,null,null,1896,22752,0.05,0,0]
[null,null,null,null,{"$f":"+E41","v":"660 kg/cm2"},0,2188,0,null,null,null,null,2188,0,0.05,0,0]
[null,null,null,null,{"$f":"+E24","v":"Total detallado % :"},{"$f":"+F24","v":1}," ",{"$f":"+SUM(H48:H53)","v":71748},null,null,null,null,{"$error":"#VALUE!"},71748,0.05,0,0]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":60000},{"$f":"+F25","v":60000},{"$f":"+(H54/G24)*G55","v":71748},null,null,null,null,{"$f":"+SUM(M49:M54)","v":{"$error":"#VALUE!"}},143496,null,{"$f":"+SUM(P49:P54)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A calculer"]
[null,null,null,null,"SI CAMBIO DE OLLA A MTS : AHORRO GAZOLINA :",null,null,null,null,null,null,null,"Planetario ahorra :",0.02,null,"Planetario ahorra :",0.06]
[null,null,null,null,null,"%","USD/1000m3","Valor USD/año"]
[null,null,null,null,{"$f":"+E36","v":"90-200 kg/cm2"},{"$f":"+F36","v":0},{"$f":"+G60","v":91.7},{"$f":"+G18*G59/1000","v":0}]
[null,null,null,null,{"$f":"+E37","v":"250 kg/cm2"},0.3,91.7,1650.6]
[null,null,null,null,{"$f":"+E38","v":"300-320 kg/cm2"},0.3,128.30000000000001,2309.4]
[null,null,null,null,{"$f":"+E39","v":"350-400 kg/cm2"},0.2,183.3,2199.6]
[null,null,null,null,{"$f":"+E40","v":"350-450 kg/cm2"},0.2,238.3,2859.6]
[null,null,null,null,{"$f":"+E41","v":"660 kg/cm2"},0,275,0]
[null,null,null,null,{"$f":"+E24","v":"Total detallado % :"},{"$f":"+F24","v":1}," ",{"$f":"+SUM(H59:H64)","v":9019.2000000000007}]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":60000},{"$f":"+F37","v":0.3},{"$f":"+(H65/G24)*F66","v":9019.2000000000007}]

{"sheet":"Cálculo humedad","index":6,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Costo cemento :",null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$H$1","v":2.1},null,null,"Pesos/kg",{"$f":"+J3/J4","v":0.11666666666666667},"USD/kg"]
[null,null,null,null,"1 USD =",null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$H$2","v":18},null,null,"Pesos"]
[null,null," "]
[null,null,null,null," "]
[null,null,null,null," ","MEZCLADO CENTRAL : PARTE N°4 : Ahorros y soluciones LIEBHERR. "]
[null,null,null,null," ","4.1. P4 : 1. Cálculo ahorros en cemento si utiliza un mezclador Ring-pan "]
[null,null,null,null," ","               2. Cáculco ahorro cemento si utiliza una Sonda de humedad LIEBHERR FMS."]
[null,null,null,null," ","Perfil : bloque, pretensado y prefabricado volumen entre 5,000 m3/año y 50,000 m3/año."]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$B$4","v":"EQUIPO FRANCES SA DE CV, Colima, 21 Jun. 2020, versión Sep. 22 2022."},null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,"Fórmula de Bolomey :"]
[null,null,null,null,"Rb28 = G x Rc x (C/A – 0,5)",null,null," "," "]
[null,null,null,null,"Coeficiente agregado G= ",null,null,0.5]
[null,null,null,null,"Clase resistencia cemento Rc =",null,null,40]
[null,null,null,null,"Consumo cemento por 1 MPa =",null,null,5,"kg"]
[]
[null,null,null,null," ",null,null," ",null,null,null,null," ",null,null,null,null,null,42,"GxRc=",{"$f":"+H15*S19","v":21}]
[null,null,null,null,"Producción estimada total :",null,null,{"$f":"'Ring-pan y Huella CO2'!$G$45","v":60000}]
[null,null,null,null,"Humedad mínima :",null,null,{"$f":"'Ring-pan y Huella CO2'!K44","v":0.01}]
[null,null,null,null,"Humedad maxima :",null,null,{"$f":"'Ring-pan y Huella CO2'!K45","v":0.05}]
[null,null,null,null,"Variación humedad : ",null,null,{"$f":"+H22-H21","v":0.04}]
[]
[]
[null,null,null,null,null,null,null,"Agua","Cemento","Agua/Cemento","Rb28 teórica","Agregado húmedo","Producción"]
[null,null,null,null,"Bloque n°1 Sólido 5 MPa",null,null,{"$f":"'Ring-pan y Huella CO2'!H38","v":0},{"$f":"'Ring-pan y Huella CO2'!I38","v":0},{"$f":"IFERROR(+H27/I27,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/J27)-0.5),0)","v":0},{"$f":"'Ring-pan y Huella CO2'!J38","v":0},{"$f":"'Cálculo cemento'!$G$18","v":0}]
[null,null,null,null,"Boque n°2 Hueco 10-15 MPa",null,null,{"$f":"'Ring-pan y Huella CO2'!H39","v":180},{"$f":"'Ring-pan y Huella CO2'!I39","v":250},{"$f":"IFERROR(+H28/I28,0)","v":0.72},{"$f":"IFERROR(+$H$15*$H$16*((1/J28)-0.5),0)","v":17.777777777777779},{"$f":"'Ring-pan y Huella CO2'!J39","v":600},{"$f":"'Cálculo cemento'!$G$19","v":18000}]
[null,null,null,null,"Total estimado Bloque",null,null,null,null,null,null,null,{"$f":"'Cálculo cemento'!$G$24","v":60000}]
[null,null,null,null,"Prefabricado n°1 30-40 MPa",null,null,{"$f":"'Ring-pan y Huella CO2'!H40","v":180},{"$f":"'Ring-pan y Huella CO2'!I40","v":300},{"$f":"IFERROR(+H30/I30,0)","v":0.6},{"$f":"IFERROR(+$H$15*$H$16*((1/J30)-0.5),0)","v":23.333333333333336},{"$f":"'Ring-pan y Huella CO2'!J40","v":600},{"$f":"'Cálculo cemento'!$G$20","v":18000}]
[null,null,null,null,"Prefabricado n°2 30-40 MPa",null,null,{"$f":"'Ring-pan y Huella CO2'!H41","v":180},{"$f":"'Ring-pan y Huella CO2'!I41","v":430},{"$f":"IFERROR(+H31/I31,0)","v":0.41860465116279072},{"$f":"IFERROR(+$H$15*$H$16*((1/J31)-0.5),0)","v":37.777777777777779},{"$f":"'Ring-pan y Huella CO2'!J41","v":600},{"$f":"'Cálculo cemento'!$G$21","v":12000}]
[null,null,null,null,"Total estimado Prefabricado",null,null,null,null,null,null,null,{"$f":"'Cálculo cemento'!$G$24","v":60000}]
[null,null,null,null,"Vigueta 45 Mpa",null,null,{"$f":"'Ring-pan y Huella CO2'!$H$42","v":180},{"$f":"'Ring-pan y Huella CO2'!$I$42","v":450},{"$f":"IFERROR(+H33/I33,0)","v":0.4},{"$f":"IFERROR(+$H$15*$H$16*((1/J33)-0.5),0)","v":40},{"$f":"'Ring-pan y Huella CO2'!J42","v":600},{"$f":"'Cálculo cemento'!$I$22","v":5400}]
[null,null,null,null,"Durmiento 65 Mpa",null,null,{"$f":"'Ring-pan y Huella CO2'!$H$43","v":0},{"$f":"'Ring-pan y Huella CO2'!$I$43","v":0},{"$f":"IFERROR(+H34/I34,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/J34)-0.5),0)","v":0},{"$f":"'Ring-pan y Huella CO2'!J43","v":0},{"$f":"'Cálculo cemento'!$I$23","v":0}]
[]
[null,null,null,null," ",null," "," "," "," "," "]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$38","v":"Bloque 10-20 MPa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :",null,null,null," ",null,null,null,null,null,null,"Tipo concreto","m3/año",null,null,null,null,null,null,"Ahorro entre Olla y Planetario o Twin-shaft :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$27*E39","v":0},{"$f":"IFERROR(+($H$27+F39)/$I$27,0)","v":0},{"$f":"IFERROR(+G39-$J$27,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G39)-0.5),0)","v":0},{"$f":"IFERROR(+I39-$K$27,0)","v":0},{"$f":"-J39*$H$17","v":0},{"$f":"+K39*$N$3*'Cálculo cemento'!$G$18","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15 Mpa*",20,{"$f":"+AD39/AF39","v":0.13333333333333333},150,0.13333333333333333]
[null,null,null,null,0.02,{"$f":"+$L$27*E40","v":0},{"$f":"IFERROR(+($H$27+F40)/$I$27,0)","v":0},{"$f":"IFERROR(+G40-$J$27,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G40)-0.5),0)","v":0},{"$f":"IFERROR(+I40-$K$27,0)","v":0},{"$f":"-J40*$H$17","v":0},{"$f":"+K40*$N$3*'Cálculo cemento'!$G$18","v":0},null," ",null,null,null,null,null,null,"<25Mpa",{"$f":"+I40","v":0},{"$f":"+F40","v":0},null,null,null,null,null,"25 MPa",26.787499999999994,{"$f":"+AD40/AF40","v":0.10714999999999998},250,0.10714999999999998]
[null,null,null,null,0.03,{"$f":"+$L$27*E41","v":0},{"$f":"IFERROR(+($H$27+F41)/$I$27,0)","v":0},{"$f":"IFERROR(+G41-$J$27,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G41)-0.5),0)","v":0},{"$f":"IFERROR(+I41-$K$27,0)","v":0},0,{"$f":"+K41*$N$3*'Cálculo cemento'!$G$18","v":0},null," ",null,null,null,null,null,null,"25 MPa",{"$f":"+I41","v":0},{"$f":"+F41","v":0},null,null,null,null,null,"30 MPa",26.65,{"$f":"+AD41/AF41","v":8.8833333333333334E-2},300,8.8833333333333334E-2]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$39","v":"25 MPa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$28*E44","v":6},{"$f":"IFERROR(+($H$28+F44)/$I$28,0)","v":0.74399999999999999},{"$f":"IFERROR(+G44-$J$28,0)","v":2.4000000000000021E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G44)-0.5),0)","v":16.881720430107524},{"$f":"IFERROR(+I44-$K$28,0)","v":-0.89605734767025425},{"$f":"-J44*$H$17","v":4.4802867383512712},{"$f":"+K44*$N$3*'Cálculo cemento'!$G$19","v":9408.6021505376684}]
[null,null,null,null,0.02,{"$f":"+$L$28*E45","v":12},{"$f":"IFERROR(+($H$28+F45)/$I$28,0)","v":0.76800000000000002},{"$f":"IFERROR(+G45-$J$28,0)","v":4.8000000000000043E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G45)-0.5),0)","v":16.041666666666664},{"$f":"IFERROR(+I45-$K$28,0)","v":-1.7361111111111143},{"$f":"-J45*$H$17","v":8.6805555555555713},{"$f":"+K45*$N$3*'Cálculo cemento'!$G$19","v":18229.166666666701}]
[null,null,null,null,0.03,18,0.79200000000000004,7.2000000000000064E-2,15.252525252525251,-2.5252525252525277,12.626262626262639,{"$f":"+K46*$N$3*'Cálculo cemento'!$G$19","v":26515.151515151541}]
[null,null,"Estimación bloque volumen total 2 %",null,null,null,null,null,null,null,null,{"$f":"IFERROR(+((L40+L45)/M29)*$H$20,0)","v":18229.166666666701}]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$40","v":"30 MPa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$30*E50","v":6},{"$f":"IFERROR(+($H$30+F50)/$I$30,0)","v":0.62},{"$f":"IFERROR(+G50-$J$30,0)","v":2.0000000000000018E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G50)-0.5),0)","v":22.258064516129036},{"$f":"IFERROR(+I50-$K$30,0)","v":-1.0752688172043001},{"$f":"-J50*$H$17","v":5.3763440860215006},{"$f":"+K50*$N$3*'Cálculo cemento'!$G$20","v":11290.322580645152}]
[null,null,null,null,0.02,{"$f":"+$L$30*E51","v":12},{"$f":"IFERROR(+($H$30+F51)/$I$30,0)","v":0.64},{"$f":"IFERROR(+G51-$J$30,0)","v":4.0000000000000036E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G51)-0.5),0)","v":21.25},{"$f":"IFERROR(+I51-$K$30,0)","v":-2.0833333333333357},{"$f":"-J51*$H$17","v":10.416666666666679},{"$f":"+K51*$N$3*'Cálculo cemento'!$G$20","v":21875.000000000025}]
[null,null,null,null,0.03,18,0.66,6.0000000000000053E-2,20.303030303030305,-3.0303030303030312,15.151515151515156,{"$f":"+K52*$N$3*'Cálculo cemento'!$G$20","v":31818.181818181827}]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$41","v":"35 MPa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$31*E55","v":6},{"$f":"IFERROR(+($H$31+F55)/$I$31,0)","v":0.4325581395348837},{"$f":"IFERROR(+G55-$J$31,0)","v":1.3953488372092981E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G55)-0.5),0)","v":36.236559139784951},{"$f":"IFERROR(+I55-$K$31,0)","v":-1.5412186379928272},{"$f":"-J55*$H$17","v":7.7060931899641361},{"$f":"+K55*$N$3*'Cálculo cemento'!$G$21","v":10788.530465949791}]
[null,null,null,null,0.02,{"$f":"+$L$31*E56","v":12},{"$f":"IFERROR(+($H$31+F56)/$I$31,0)","v":0.44651162790697674},{"$f":"IFERROR(+G56-$J$31,0)","v":2.7906976744186018E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G56)-0.5),0)","v":34.791666666666671},{"$f":"IFERROR(+I56-$K$31,0)","v":-2.9861111111111072},{"$f":"-J56*$H$17","v":14.930555555555536},{"$f":"+K56*$N$3*'Cálculo cemento'!$G$21","v":20902.777777777752}," "]
[null,null,null,null,0.03,18,0.46046511627906977,4.1860465116279055E-2,33.434343434343432,-4.3434343434343461,21.71717171717173,{"$f":"+K57*$N$3*'Cálculo cemento'!$G$21","v":30404.040404040421}]
[null,null,"Estimación prefabricado volumen total 2%",null,null,null,null,null,null,null,null,{"$f":"IFERROR(+((L51+L56)/M32)*$H$20,0)","v":42777.777777777781}]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$42","v":"Vigueta 350-45 Mpa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$33*E61","v":6},{"$f":"IFERROR(+($H$33+F61)/$I$33,0)","v":0.41333333333333333},{"$f":"+G61-$J$33","v":1.3333333333333308E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G61)-0.5),0)","v":38.387096774193552},{"$f":"+I61-$K$33","v":-1.6129032258064484},{"$f":"-J61*$H$17","v":8.064516129032242},{"$f":"+K61*$N$3*'Cálculo cemento'!$G$22","v":11290.322580645139}]
[null,null,null,null,0.02,{"$f":"+$L$33*E62","v":12},{"$f":"IFERROR(+($H$33+F62)/$I$33,0)","v":0.42666666666666669},{"$f":"+G62-$J$33","v":2.6666666666666672E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G62)-0.5),0)","v":36.875},{"$f":"+I62-$K$33","v":-3.125},{"$f":"-J62*$H$17","v":15.625},{"$f":"+K62*$N$3*'Cálculo cemento'!$G$22","v":21875}]
[null,null,null,null,0.03,18,{"$f":"IFERROR(+($H$33+F63)/$I$33,0)","v":0.44},3.999999999999998E-2,{"$f":"IFERROR(+$H$15*$H$16*((1/G63)-0.5),0)","v":35.45454545454546},-4.5454545454545396,22.727272727272698,{"$f":"+K63*$N$3*'Cálculo cemento'!$G$22","v":31818.18181818178}]
[null,null,{"$f":"'Ring-pan y Huella CO2'!$E$43","v":"Durmiente 65 Mpa"},null,"HUMEDAD :",null,"AUMENTO A/C :",null,"Nueva MPa","PERDIDAS :"]
[null,null,null,null,"Variación   ","Agua l adicional","A/C nuevo","Variación +","inferior","Mpa","kg cem/m3","Cemento USD/año"]
[null,null,null,null,0.01,{"$f":"+$L$34*E66","v":0},{"$f":"IFERROR(+($H$34+F66)/$I$34,0)","v":0},{"$f":"+G66-$J$34","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G66)-0.5),0)","v":0},{"$f":"+I66-$K$34","v":0},{"$f":"-J66*$H$17","v":0},{"$f":"+K66*$N$3*'Cálculo cemento'!$G$23","v":0}]
[null,null,null,null,0.02,{"$f":"+$L$34*E67","v":0},{"$f":"IFERROR(+($H$34+F67)/$I$34,0)","v":0},{"$f":"+G67-$J$34","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G67)-0.5),0)","v":0},{"$f":"+I67-$K$34","v":0},{"$f":"-J67*$H$17","v":0},{"$f":"+K67*$N$3*'Cálculo cemento'!$G$23","v":0}]
[null,null,null,null,0.03,0,{"$f":"IFERROR(+($H$34+F68)/$I$34,0)","v":0},0,{"$f":"IFERROR(+$H$15*$H$16*((1/G68)-0.5),0)","v":0},0,0,{"$f":"+K68*$N$3*'Cálculo cemento'!$G$23","v":0}]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Suma estimado perdidas a 2 %",null,null,{"$f":"+J47+J58+J62+J67","v":-3.125},null,{"$f":"+L47+L58+L62+L67","v":82881.944444444482}]
[null,null,null,null,null,null,null,null,null,"Necesita un Macro VisualBasic para extraer o calcular "]
[null,null,null,null,null,null,null,null,null,"la bajada de MPa sola o de varios concretos"]
[null,null,null," ",null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Cálculo CO2 directo","index":7,"n_rows":59,"n_cols":13,"rows_kept":59,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Costo cemento :",null,{"$f":"'Ring-pan y Huella CO2'!$H$1","v":2.1},"Pesos/kg"]
[null,null,null,null,"1 USD =",null,{"$f":"'Ring-pan y Huella CO2'!$H$2","v":18},"Pesos"]
[null,null," "]
[null,null,null,null," "]
[null,null,null,null,"MEZCLADO CENTRAL : 4. SU SITUACION.",null,null,null,null,null,null,null,"Hoja 2 : cálculos."]
[null,null,null,null,"4.0.5. Cálculo de sus ahorros de USD si utiliza un Mobile Twin-shaft 4.5 m3 "]
[null,null,null,null,"al lugar de Plandta dosificadora+Hormigonera (\"Olla\")."]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$B$4","v":"EQUIPO FRANCES SA DE CV, Colima, 21 Jun. 2020, versión Sep. 22 2022."}]
[]
[null,null,null,null,"DATOS FIJOS :"]
[null,null,null,null,"´-Tipo de cambio 1 Pesos por un USD",null,null," "," ","Pesos",20]
[null,null,null,null,"-Hora de trabajo de una olla al año = 8 horas x 5 dias x 50 semanas =",null,null,null,null,"horas",2000]
[null,null,null,null,null,null,null,null,null,"segundos",{"$f":"+K14*3600","v":7200000}]
[null,null,null,null,"´-Precio de una Olla+Camión =",null,null," "," ","USD",140000]
[null,null,null,null,"´Consumo gazolina por hora",null,null,null,null,"Litro",8]
[null,null,null,null,"´Consumo gazolina por segundo",null,null,null,null,"Segundo ",{"$f":"+K17/3600","v":2.2222222222222222E-3}]
[null,null,null,null,"´Costo gazolina por hora = 8 litros x 22 Pesos / tipo cambio =",null,null,null,null,"USD por hora",{"$f":"8*22/K13","v":8.8000000000000007}]
[null,null,null,null,null,null,null,null,"    ","USD por segundo",{"$f":"+K19/3600","v":2.4444444444444448E-3}]
[null,null,null,null,"´Volumen de concreto por olla =",null,null,null,null,"m3",8]
[null,null,null,null,"CALCULO DEL CO2 POR M3 DEL MOTOR DE LA REVOLVEDORA :"]
[null,null,null,null,"A 15 C°C un litro de diesel pesar, masa volumétrica kg/m3",null,null,null," ","gramo/l",835]
[null,null,null,null,"Contiene en atomo de Carbono C",null,null,null,null,"%",86.2]
[null,null,null,null,"Cantidad de C pero litro de diesel",null,null,null,null,"gramo",720]
[null,null,null,null,"Para quemar este C, hace falta en Oxigeno O",null,null,null,null,"gramo",1920]
[null,null,null,null,"Cantidad de CO2 producido C+O por litro",null,null,null,null,"gramo/litro",{"$f":"+K26+K25","v":2640}]
[null,null,null,null,"Cantidad de CO2 producido C+O por litro",null,null,null,null,"kg/litro",{"$f":"+K27/1000","v":2.64}]
[]
[null,null,null,null,"CALCULO DEL CO2 POR M3 DEL MOTOR DE LA REVOLVEDORA :",null,null,null,null,null,"Primera estimación transporte :"]
[null,null,null,null,null,null,null,null,null,null,"20 litros/100 km si 100km/jourx4 semainex12 mois=24,000 km"]
[null,null,null,null,"TIEMPO Y  DEL MEZCLADO FIJO CON LA OLLA POR M3.",null,null,null,null,null,"4 voyage/jour soient 32 m3 donc 20/32=0.625 l/m3"]
[null,null,null,null,null,"Tiempo de","Tiempo seg.","EMISION CO2",null,null,"´x 2,64 g CO\"=1.65 kg CO2/m3"]
[null,null,null,null,null,"mezclado min.","por m3","Litro diesel/m3","CO2 g/m3","CO2 kg/m3"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E103","v":"Bloque 10-20 MPa"},3,{"$f":"+(F35*60)/$K$21","v":22.5},{"$f":"+G35*$K$18","v":0.05},{"$f":"+H35*$K$27","v":132},{"$f":"+I35/1000","v":0.13200000000000001}]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E104","v":"25 MPa"},5,37.5,8.3333333333333329E-2,220,0.22]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E105","v":"30 MPa"},7,52.5,0.11666666666666667,308,0.308]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E106","v":"35 MPa"},10,75,0.16666666666666666,440,0.44]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E107","v":"Vigueta 350-45 Mpa"},13,97.5,0.21666666666666667,572,0.57199999999999995]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E108","v":"Durmiente 65 Mpa"},15,112.5,0.25,660,0.66]
[]
[]
[null,null,null,null,"SI UTILIZA REVOLVEDORA  : EMISION CO2 : G/M3 :",null,null,null," "]
[null,null,null,null,null,"%","m3/año","Kg CO2 emitidos por año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E103","v":"Bloque 10-20 MPa"},{"$f":"'Cálculo cemento'!F18","v":0},{"$f":"'Cálculo cemento'!G18","v":0},{"$f":"+G45*J35","v":0}]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E104","v":"25 MPa"},{"$f":"'Cálculo cemento'!F19","v":0.3},{"$f":"'Cálculo cemento'!G19","v":18000},3960,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E105","v":"30 MPa"},{"$f":"'Cálculo cemento'!F20","v":0.3},{"$f":"'Cálculo cemento'!G20","v":18000},5544,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E106","v":"35 MPa"},{"$f":"'Cálculo cemento'!F21","v":0.2},{"$f":"'Cálculo cemento'!G21","v":12000},5280,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E107","v":"Vigueta 350-45 Mpa"},{"$f":"'Cálculo cemento'!F22","v":0.2},{"$f":"'Cálculo cemento'!G22","v":12000},6863.9999999999991,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E108","v":"Durmiente 65 Mpa"},{"$f":"'Cálculo cemento'!F23","v":0},{"$f":"'Cálculo cemento'!G23","v":0},0,"kg/año"]
[null,null,null,null,null,"Total",{"$f":"+SUM(G46:G50)","v":60000},{"$f":"+SUM(H46:H50)","v":21648},"kg/año"]
[null,null,null,null,null,{"$f":"'[2]Pagina a utilizar'!$E$28","v":200000}," ",{"$f":"+(H51/G51)*F52","v":72160}]
[]
[]
[]
[null,null,null,null,null,null," "]
[]
[]
[null,null,null,null,null,null,"  "]

{"sheet":"Cálculo huella CO2","index":8,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Costo cemento :",null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$H$1","v":2.1},"Pesos/kg"]
[null,null,null,null,"1 USD =",null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$H$2","v":18},"Pesos"]
[null,null,null,null," "]
[null,null,null,null,"MEZCLADO CENTRAL : 4. SU SITUACION.",null,null,null,null,null,null,null,null,null,null,"Hoja 2 : cálculos."]
[null,null,null,null,"4.0.5. Cálculo de sus ahorros de USD si utiliza un Mobile Twin-shaft 4.5 m3 "]
[null,null,null,null,"al lugar de Plandta dosificadora+Hormigonera (\"Olla\")."]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!$B$4","v":"EQUIPO FRANCES SA DE CV, Colima, 21 Jun. 2020, versión Sep. 22 2022."}]
[]
[null,null,null,null,"Leyenda color de poliza :",null,"Entrada dato","Entrada dato","Cálculo","Texto","Título"]
[null,null,null,null,null,null,"esta hoja","otra hoja"]
[null,null,null,null,"CONSTANTES :",null,"Unidad","Valor","Precisión"]
[null,null,null,null,"Cemento :"]
[null,null,null,null,"Emisión de CO2 para fabricar",null,"kg/t",{"$f":"'Ring-pan y Huella CO2'!$L$13","v":622},"Cemex 791 kg/t (objectif 475 en 2030 soit 40% de moins), Holcim serait à 590 kg"]
[null,null,null,null,"Emisión de CO2 para fabricar",null,"gramo/kg",{"$f":"+H15/1000","v":0.622}]
[null,null,null,null,"Electricidad :"]
[null,null,null,null,"Emisión de CO2 para producir electricidad en México",null,"tCO2/MWh",494,"Ver Estudio Ecologia 0.1. Coeficiente oficial Link"]
[null,null,null,null,"Emisión de CO2 para producir electricidad en México",null,"kgCO2/kWh",{"$f":"+H18/1000","v":0.49399999999999999}," "]
[null,null,null,null,"Emisión de CO2 para producir electricidad en México",null,"gCO2/kWh",{"$f":"+H19*1000","v":494}," "]
[null,null,null,null,"kiloWatt ",null,"Watt (Joule/s)",1000]
[null,null,null,null,"kiloWatt-hora = kWh =",null,"Joule",3600000,"Energia (o trabajo) de un aparato de 1000 Watt (1 Joule/segundo) durante una hora"]
[null,null,null,null,null,null,"MJoule",{"$f":"+H22/1000000","v":3.6}]
[null,null,null,null,"VARIABLES :",null,"Unidad","Valor"]
[null,null,null,null,"Producción anual; ver Tabla Entrada datos",null,null,{"$f":"'Ring-pan y Huella CO2'!$G$45","v":60000},"m3"]
[null,null,null,null,"Eficiencia jemorada en tiempo Twin-shaft Liebherr / Twin-shaft Otra mrca",null,null,0.15,"%"]
[null,null,null,null,"Eficiencia jemorada en tiempo Ring-pan Liebherr para cemento",null,null,0.15,"%"]
[]
[null,null,null,null,"CONSUMO ELECTRICIDAD :",null,"Para concreto 30 MPa :"]
[null,null,null,null,null,"Mezclado","Mezclado","Mezclado","Mezclado","Mezclado","Mezclado","       Potencia",null,"                      Energia utilizada",null,null,"Huella kg CO2",null,"J/m3","Eficiencia","Precio","Consumo"]
[null,null,null,null," ","m3","tiempo min","segundo","s/m3","min/m3","hora/m3","kW","J/s","por m3 J/m3","kWh/m3","kWh total","por m3","total","aplicado","potencia/aplicado","KWh","KWh "]
[null,null,null,null,"Revolvedora 8 m3 sobre chasis Diesel Tier 1",8,7,{"$f":"+G32*60","v":420},{"$f":"+H32/F32","v":52.5},{"$f":"+I32/60","v":0.875},{"$f":"+J32/60","v":1.4583333333333334E-2}," ",null,null,null,null,null,null,null,null,null,"Pesos","USD"]
[null,null,null,null,"Revolvedora 8 m3sobre chasis Gas",8,7,{"$f":"+G33*60","v":420},{"$f":"+H33/F33","v":52.5},{"$f":"+I33/60","v":0.875},1.4583333333333334E-2]
[null,null,null,null,"Revolvedora 8 m3 eléctrica sobre chasis diesel",8,7,420,52.5,{"$f":"+I34/60","v":0.875},1.4583333333333334E-2,28,{"$f":"+L34*1000","v":28000},{"$f":"+M34*I34","v":1470000},{"$f":"+N34/$H$22","v":0.40833333333333333},{"$f":"+O34*$H$25","v":24500},{"$f":"+O34*$H$19","v":0.20171666666666666},{"$f":"+Q34*$H$25","v":12103},541000,{"$f":"+S34/N34","v":0.36802721088435375},0.78600000000000003,{"$f":"+U34*P34","v":19257},{"$f":"+V34/$J$4","v":1069.8333333333333}]
[null,null,null,null,"Tilt 9 m3",9,5,300,33.333333333333336,{"$f":"+I35/60","v":0.55555555555555558},9.2592592592592605E-3,150,{"$f":"+L35*1000","v":150000},{"$f":"+M35*I35","v":5000000},{"$f":"+N35/$H$22","v":1.3888888888888888},{"$f":"+O35*$H$25","v":83333.333333333328},{"$f":"+O35*$H$19","v":0.68611111111111112},{"$f":"+Q35*$H$25","v":41166.666666666664},541000,{"$f":"+S35/N35","v":0.1082},0.78600000000000003,{"$f":"+U35*P35","v":65500},{"$f":"+V35/$J$4","v":3638.8888888888887}]
[null,null,null,null,"Mezclador otro 3.5",3.5,1,60,17.142857142857142,{"$f":"+I36/60","v":0.2857142857142857},4.7619047619047615E-3,110,110000,1885714.2857142857,{"$f":"+N36/$H$22","v":0.52380952380952384},{"$f":"+O36*$H$25","v":31428.571428571431},0.25876190476190475,15525.714285714284,null,null,0.78600000000000003,24702.857142857145,1372.3809523809525]
[null,null,null,null,"Mezclador LIEBHERR 3.5",3.5,{"$f":"+G36*(1-H26)","v":0.85},51,14.571428571428571,{"$f":"+I37/60","v":0.24285714285714285},4.0476190476190473E-3,110,110000,1602857.1428571427,{"$f":"+N37/$H$22","v":0.44523809523809521},{"$f":"+O37*$H$25","v":26714.285714285714},0.21994761904761903,13196.857142857141,null,null,0.78600000000000003,20997.428571428572,1166.5238095238096]
[null,null,null,null,"Mezclador Ring-pan 2.5 D",2.5,{"$f":"+G37*(1-H28)","v":0.85},{"$f":"+G38*60","v":51},{"$f":"+H38/F38","v":20.399999999999999},{"$f":"+I38/60","v":0.33999999999999997},{"$f":"+J38/60","v":5.6666666666666662E-3},110,{"$f":"+L38*1000","v":110000},{"$f":"+M38*I38","v":2244000},{"$f":"+N38/$H$22","v":0.62333333333333329},{"$f":"+O38*$H$25","v":37400},{"$f":"+O38*$H$19","v":0.30792666666666663},{"$f":"+Q38*$H$25","v":18475.599999999999},null,null,0.78600000000000003,29396.400000000001,1633.1333333333334]
[null,null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,"Resultados"]
[null,null,null,null,"EMISION CEMENTO EN EXCESO ","Consumo ","     Huella kg CO2",null,null,null,null,null,null,null,null,null,null,"a hoja entrada"]
[null,null,null,null,"AL MEZCLADOR :","cemento t","por t","total"]
[null,null,null,null,"Revolvedora 8 m3 sobre chasis Diesel Tier 1",{"$f":"'Cálculo cemento'!$G$43","v":2524.8599999999997},{"$f":"+$H$15","v":622},{"$f":"+G42*F42","v":1570462.9199999997}," "]
[null,null,null,null,"Revolvedora 8 m3sobre chasis Gas",{"$f":"'Cálculo cemento'!$G$43","v":2524.8599999999997},{"$f":"+$H$15","v":622},{"$f":"+(F43*$H$16)*1000","v":1570462.9199999997}]
[null,null,null,null,"Revolvedora 8 m3 eléctrica sobre chasis diesel",{"$f":"'Cálculo cemento'!$G$43","v":2524.8599999999997},622,{"$f":"+(F44*$H$16)*1000","v":1570462.9199999997}]
[null,null,null,null,"Tilt 9 m3 (revolvedora - 3%)",{"$f":"'Cálculo cemento'!$L$43","v":"A calculer"},622,{"$f":"+(F45*$H$16)*1000","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"Mezclador otro 3.5"]
[null,null,null,null,"Mezclador LIEBHERR 3.5"]