{"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":39,"macros":1,"external_links":1,"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.6,"Pesos/kg"]
[null,null,null,null,null,"1 USD =",null,20,"Pesos"]
[null,null," "]
[null,null,null,null,null,null," "]
[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 de Junio 2020, actualizado Jun. 22 2022.",null,null,null,null,null,null,null,null,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,null,"Sintesis financiera :",{"$f":"+E19","v":"Ring-pan 2.5 D"},"ESTUDIO AMASADO CONCRETO : PARTE N°4 : Ahorros y soluciones LIEBHERR. 4.1. P6",null,null,null,null,null,"SELECCIONAR:",null,"MEZCLADOR :",null,"PLANTA :",null,null,null,"REVOLVEDORA :",null,"BANDOLLA + ELECTRICA :"]
[null,null,null,"Ahorros totales :",{"$f":"+F23","v":472106.25000000006},"1. Cálculo ahorros si utiliza un mezclador LIEBHERR al lugar de una Revolvedora Olla o TILT.",null,null,null,null,null,"Revolvedora Olla",120]
[null,null,null,"Costo anual :",{"$f":"+F27","v":44719.65},"2. Mejora huella CO2 según Mezclador versus Olla o Tilt + Equipo de Transporte.",null,null,null,null,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,null,"Beneficio adicional :",{"$f":"+F29","v":427386.60000000003},"3. Cálculo ahorro cemento si utiliza una Sistema de Medición Humedad LIEBHERR.",null,null,null,null,null,"Promedio actual",{"$f":"+H45","v":20.833333333333332},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y Versión Twin-shaft Liebherr"]
[null,null,null,"Meses amortización :",{"$f":"+F30","v":6.2637497702024847},"Perfil de producción : concreto para venta al público.",null,null,null,null,null," "," ","Ring-pan         Twin-shaft","Sensor humedad","Mobilmix","LCM1 ","LCM3 Twin-","Mobile Twin","Revolvedora eléctrica :",null,"BANDOLLA","Estacionaria","Reciclador LRS"]
[null,null,null,"Mejora Huella CO2 :",{"$f":"+F33","v":-1998200},"Ejemplos : resistencias variadas y volumenes medianos.",null,null,null,null,null,null,null,"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,null,null,null,"                                 INDICADORES ECONÓMICOS FASE AMASADO :",null,null,null,null,null,null,null," ","EMISION Y HUELLA CO2 CALCULA METODOLOGIA LCA LEGAL :",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,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","Pago","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.5 D","Revolvedora Diesel","Rev. Diesel",null,{"$f":"'Factor CO2'!I28","v":10885000},{"$f":"'Factor CO2'!J28","v":15400},{"$f":"'Factor CO2'!K28","v":10900399.999999998},"Revolvedora Diesel",{"$f":"'Factor CO2'!L28","v":33000},"Camión Diesel",{"$f":"'Factor CO2'!M28","v":165000},{"$f":"'Factor CO2'!N28","v":198000},{"$f":"'Factor CO2'!O28","v":11098400},0,0,null,0]
[null,null,null,null,"Ahorro cemento Sensor Humedad si 2% variación  :",{"$f":"+J59","v":186301.37744707236},{"$f":"+F17","v":186301.37744707236},{"$f":"+F17","v":186301.37744707236},{"$f":"+F17","v":186301.37744707236},{"$f":"+F17","v":186301.37744707236},{"$f":"+SUM(F17:J17)","v":931506.88723536185},{"$f":"+F17","v":186301.37744707236},null,"Amasado Cemento","Revolvedora Olla",10885000,{"$f":"+P17/$P$23","v":0.98061296192861391},"Ring-pan 2.5 D",8885000,{"$f":"-(P17-S17)/P17","v":-0.18373909049150206},"Twin-shaft 1.25",9350000,{"$f":"+(V17-P17)/P17","v":-0.14101975195222782},{"$f":"+V17-P17","v":-1535000},null,"Ring-pan 2.5 D","Revolvedora Gas","Rev. Gas",null,{"$f":"'Factor CO2'!I29","v":10885000},{"$f":"'Factor CO2'!J29","v":12300},{"$f":"'Factor CO2'!K29","v":10897300},"Revolvedora Gas",{"$f":"'Factor CO2'!L29","v":26400},"Camión Gas",{"$f":"'Factor CO2'!M29","v":132000},{"$f":"'Factor CO2'!N29","v":158400},{"$f":"'Factor CO2'!O29","v":11055700},{"$f":"+(AL17-$AL$16)/$AL$16","v":-3.8474014272327542E-3},{"$f":"+AL17-$AL$16","v":-42700},{"$f":"-0.088*AN17","v":3757.6},{"$f":"+AL17-$AL$20","v":158400},{"$f":"-0.088*AP17","v":-13939.199999999999}]
[null,null,null,null,null,null,"              Ahorros con Mezclador LIEBHERR versus Revolvedora :",null,null,null,null,null,null,"Amasado Energia","Diesel",17200,{"$f":"+P18/$P$23","v":1.5495216302408965E-3},"Electricidad",{"$f":"+AE28","v":17200},{"$f":"-(P18-S18)/P18","v":0},"Electricidad",12300,{"$f":"+(V18-P18)/P18","v":-0.28488372093023256},{"$f":"+V18-P18","v":-4900},null,"Twin-shaft 1.25","Revolvedora Eléctrica","Rev Elec Diesel",null,{"$f":"'Factor CO2'!I30","v":10885000},{"$f":"'Factor CO2'!J30","v":10100},{"$f":"'Factor CO2'!K30","v":10895100},"Revolvedora Eléctrica",{"$f":"'Factor CO2'!L30","v":21600},null,{"$f":"'Factor CO2'!M30","v":165000},{"$f":"'Factor CO2'!N30","v":186600},{"$f":"'Factor CO2'!O30","v":11081700},-1.5047214012830679E-3,-16700,{"$f":"-0.088*AN18","v":1469.6},184400,{"$f":"-0.088*AP18","v":-16227.199999999999}]
[null,null,null,"Ahorro 8 a 19% cemento con :","Ring-pan 2.5 D",410556.25000000006,{"$f":"+F19","v":410556.25000000006},{"$f":"+F19","v":410556.25000000006},{"$f":"+F19","v":410556.25000000006},{"$f":"+F19","v":410556.25000000006},{"$f":"+SUM(F19:J19)","v":2052781.2500000002},{"$f":"+F19","v":410556.25000000006},null,"Total Amasado",null,{"$f":"+P18+P17","v":10902200},{"$f":"+Q17+Q18","v":0.98216248355885483},null,{"$f":"+S18+S17","v":8902200},{"$f":"-(P19-S19)/P19","v":-0.18344921208563408},null,{"$f":"+V18+V17","v":9362300},-0.14124672084533396,-1539900,null,"Twin-shaft 2.25","Opción  4","Rev Elec Gas",null,{"$f":"'Factor CO2'!I31","v":10885000},{"$f":"'Factor CO2'!J31","v":10100},{"$f":"'Factor CO2'!K31","v":10895100},null,{"$f":"'Factor CO2'!L31","v":21600},null,{"$f":"'Factor CO2'!M31","v":132000},{"$f":"'Factor CO2'!N31","v":153600},{"$f":"'Factor CO2'!O31","v":11048700},-4.4781229726807469E-3,-49700,4373.5999999999995,151400,-13323.199999999999]
[null,null,null,null,"Ahorro inversión Revolvedora :",{"$f":"+H110","v":54674.999999999993},0,0,0,0,{"$f":"+SUM(F20:J20)","v":54674.999999999993},0,null,"Transporte Paradas","Diesel",{"$f":"+AH16","v":33000},{"$f":"+P20/$P$23","v":2.9729194068575343E-3},"Diesel",{"$f":"+AH28","v":33000},{"$f":"-(P20-S20)/P20","v":0},"Revolvedora Eléctrica",21600,-0.34545454545454546,-11400,null,"Twin-shaft 3.0","Transporte Activo","Tilt Diesel","Tilt",{"$f":"'Factor CO2'!I32","v":10665000},{"$f":"'Factor CO2'!J32","v":34300},{"$f":"+AE20+AD20","v":10699300},null,{"$f":"'Factor CO2'!L32","v":33000},null,{"$f":"'Factor CO2'!M32","v":165000},{"$f":"+AJ20+AH20","v":198000},{"$f":"+AK20+AF20","v":10897300},-1.8119728969941615E-2,-201100,17696.8,0,0]
[null,null,null,null,"Ahorro diesel  Revolvedera Olla :",6875.0000000000009,{"$f":"+F21","v":6875.0000000000009},{"$f":"+F21","v":6875.0000000000009},{"$f":"+F21","v":6875.0000000000009},{"$f":"+F21","v":6875.0000000000009},34375.000000000007,{"$f":"+F21","v":6875.0000000000009},null,"Transporte Activo","Diesel",{"$f":"+AJ16","v":165000},{"$f":"+P21/$P$23","v":1.486459703428767E-2},"Diesel",{"$f":"+AJ28","v":165000},0,"Camión Diesel",165000,0,0,null,"Twin-shaft 4.5","Camión Diesel","Tilt Gas",null,{"$f":"'Factor CO2'!I33","v":10665000},{"$f":"'Factor CO2'!J33","v":34300},{"$f":"+AE21+AD21","v":10699300},null,{"$f":"'Factor CO2'!L33","v":26400},null,{"$f":"'Factor CO2'!M33","v":132000},{"$f":"+AJ21+AH21","v":158400},{"$f":"+AK21+AF21","v":10857700},-2.1687810855618828E-2,-240700,21181.599999999999,{"$f":"+AL21-$AL$20","v":-39600},3484.7999999999997]
[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":198000},{"$f":"+Q21+Q20","v":1.7837516441145205E-2},null,{"$f":"+S21+S20","v":198000},0,null,{"$f":"+V21+V20","v":186600},-5.7575757575757579E-2,-11400,null,"MTS 4.5 Móvil","Camión Gas","Tilt Rev Elec Diesel",null,{"$f":"'Factor CO2'!I34","v":10665000},{"$f":"'Factor CO2'!J34","v":34300},10699300,null,{"$f":"'Factor CO2'!L34","v":21600},null,{"$f":"'Factor CO2'!M34","v":165000},186600,10885900,-1.9146904058242629E-2,-212500,18700,-11400,1003.1999999999999]
[null,null,null,"Ahorros totales con :","Ring-pan 2.5 D",{"$f":"+F19+F20+F21","v":472106.25000000006},417431.25000000006,417431.25000000006,417431.25000000006,417431.25000000006,2141831.25,417431.25000000006,null,"GRAN TOTAL",null,{"$f":"+P22+P19","v":11100200},{"$f":"+Q22+Q19","v":1},null,{"$f":"+S22+S19","v":9100200},-0.18017693374894145,null,{"$f":"+V22+V19","v":9548900},-0.13975423866236644,-1551300,null,"Planta Mobilmix 0.5",null,"Tilt Rev Elec Gas",null,{"$f":"'Factor CO2'!I35","v":10665000},{"$f":"'Factor CO2'!J35","v":34300},10699300,null,{"$f":"'Factor CO2'!L35","v":21600},null,{"$f":"'Factor CO2'!M35","v":132000},153600,10852900,-2.2120305629640308E-2,-245500,21604,-44400,3907.2]
[null,null,null,null," "," ","                Costo amortización Mezclador  LIEBHERR :",null,null,null,"Precio inversión :"," ",null,null,null,null,null," "," "," ",null,null,null,null,null,"Planta LCM 1",null,"Twin-shaft Diesel","Twin-shaft 3.5",{"$f":"'Factor CO2'!I36","v":9350000},{"$f":"'Factor CO2'!J36","v":12300},{"$f":"'Factor CO2'!K36","v":9362300},null,{"$f":"'Factor CO2'!L36","v":33000},null,{"$f":"'Factor CO2'!M36","v":165000},{"$f":"'Factor CO2'!N36","v":198000},{"$f":"'Factor CO2'!O36","v":9560300},{"$f":"+(AL24-$AL$16)/$AL$16","v":-0.13858754415050817},{"$f":"+AL24-$AL$16","v":-1538100},{"$f":"-0.088*AN24","v":135352.79999999999},{"$f":"+AL24-$AL$20","v":-1337000},{"$f":"-0.088*AP24","v":117656}]
[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.98061296192861391},null,null,{"$f":"+N25","v":"Amasado Cemento"},{"$f":"+S17-P17","v":-2000000},null,{"$f":"+N25","v":"Amasado Cemento"},{"$f":"+V17-P17","v":-1535000},null,null,null,"Planta LCM 3",null,"Twin-shaft Gas",null,{"$f":"'Factor CO2'!I37","v":9350000},{"$f":"'Factor CO2'!J37","v":12300},{"$f":"'Factor CO2'!K37","v":9362300},null,{"$f":"'Factor CO2'!L37","v":26400},null,{"$f":"'Factor CO2'!M37","v":132000},{"$f":"'Factor CO2'!N37","v":158400},{"$f":"'Factor CO2'!O37","v":9520700},-0.1421556260361854,-1577700,138837.6,{"$f":"+AL25-$AL$20","v":-1376600},121140.79999999999]
[null,null,null,null,"Costo consumo de electricidad :",1224.8499999999999,{"$f":"+F26","v":1224.8499999999999},{"$f":"+F26","v":1224.8499999999999},{"$f":"+F26","v":1224.8499999999999},{"$f":"+F26","v":1224.8499999999999},{"$f":"+SUM(F26:J26)","v":6124.25},{"$f":"+F26","v":1224.8499999999999},null,{"$f":"+N18","v":"Amasado Energia"},{"$f":"+Q18","v":1.5495216302408965E-3},null,null,{"$f":"+N26","v":"Amasado Energia"},{"$f":"+S18-P18","v":0},null,{"$f":"+N26","v":"Amasado Energia"},{"$f":"+V18-P18","v":-4900},null,null,null,"Opción 1",null,"Twin-shaft Rev Elec Diesel",null,{"$f":"'Factor CO2'!I38","v":9350000},{"$f":"'Factor CO2'!J38","v":12300},{"$f":"'Factor CO2'!K38","v":9362300},null,{"$f":"'Factor CO2'!L38","v":21600},null,{"$f":"'Factor CO2'!M38","v":165000},{"$f":"'Factor CO2'!N38","v":186600},{"$f":"'Factor CO2'!O38","v":9548900},-0.13961471923880919,-1549500,136356,-1348400,118659.2]
[null,null,null,"Total costos mezclado","Ring-pan 2.5 D",{"$f":"+F25+F26","v":44719.65},{"$f":"+F27","v":44719.65},{"$f":"+F27","v":44719.65},{"$f":"+F27","v":44719.65},{"$f":"+F27","v":44719.65},{"$f":"+SUM(F27:J27)","v":223598.25},{"$f":"+F27","v":44719.65},null,{"$f":"+N20","v":"Transporte Paradas"},{"$f":"+Q20","v":2.9729194068575343E-3},null,null,{"$f":"+N20","v":"Transporte Paradas"},{"$f":"-(S20-P20)","v":0},null,"Transporte Paradas",{"$f":"+V20-P20","v":-11400},null,null,null,"Revolvedora Olla",null,"Twin-shaft Rev Elec Gas",null,{"$f":"'Factor CO2'!I39","v":9350000},{"$f":"'Factor CO2'!J39","v":12300},{"$f":"'Factor CO2'!K39","v":9362300},null,{"$f":"'Factor CO2'!L39","v":21600},null,{"$f":"'Factor CO2'!M39","v":132000},{"$f":"'Factor CO2'!N39","v":153600},{"$f":"'Factor CO2'!O39","v":9515900},-0.14258812081020689,-1582500,139260,-1381400,121563.2]
[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.486459703428767E-2},null,null,"Transporte Activo",{"$f":"-(S21-P21)","v":0},null,"Transporte Activo",{"$f":"+V21-P21","v":0},null,null,null,"Revolvedora Tilt",null,"Ring-pan Diesel","Ring-pan 2.5 D",{"$f":"'Factor CO2'!I40","v":8885000},{"$f":"'Factor CO2'!J40","v":17200},{"$f":"'Factor CO2'!K40","v":8902200},null,{"$f":"'Factor CO2'!L40","v":33000},null,{"$f":"'Factor CO2'!M40","v":165000},{"$f":"'Factor CO2'!N40","v":198000},{"$f":"'Factor CO2'!O40","v":9100200},-0.18004397030202551,-1998200,175841.59999999998,-1797100,158144.79999999999]
[null,null,null,"Beneficio adicional con :","Ring-pan 2.5 D",{"$f":"+F23-F27","v":427386.60000000003},{"$f":"+G23-G27","v":372711.60000000003},372711.60000000003,372711.60000000003,372711.60000000003,1918233,372711.60000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ring-pan Gas",null,{"$f":"'Factor CO2'!I41","v":8885000},{"$f":"'Factor CO2'!J41","v":17200},{"$f":"'Factor CO2'!K41","v":8902200},null,{"$f":"'Factor CO2'!L41","v":26400},null,{"$f":"'Factor CO2'!M41","v":132000},{"$f":"'Factor CO2'!N41","v":158400},{"$f":"'Factor CO2'!O41","v":9060600},-0.18361205218770274,-2037800,179326.4,-1836700,161629.59999999998]
[null,null,null,"Años para pagar y cumulativo:","Ring-pan 2.5 D",{"$f":"+(K27/(K23/60))","v":6.2637497702024847},{"$f":"+F29+G29","v":800098.20000000007},{"$f":"+G30+H29","v":1172809.8},{"$f":"+H30+I29","v":1545521.4000000001},{"$f":"+I30+J29","v":1918233.0000000002}," ",{"$f":"+J30+L29","v":2290944.6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ring-pan Rev Elec Diesel",null,{"$f":"'Factor CO2'!I42","v":8885000},{"$f":"'Factor CO2'!J42","v":17200},{"$f":"'Factor CO2'!K42","v":8902200},null,{"$f":"'Factor CO2'!L42","v":21600},null,{"$f":"'Factor CO2'!M42","v":165000},{"$f":"'Factor CO2'!N42","v":186600},{"$f":"'Factor CO2'!O42","v":9088800},-0.18107114539032654,-2009600,176844.79999999999,-1808500,159148]
[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":8885000},{"$f":"'Factor CO2'!J43","v":17200},{"$f":"'Factor CO2'!K43","v":8902200},null,{"$f":"'Factor CO2'!L43","v":21600},null,{"$f":"'Factor CO2'!M43","v":132000},{"$f":"'Factor CO2'!N43","v":153600},{"$f":"'Factor CO2'!O43","v":9055800},-0.1840445469617242,-2042600,179748.8,-1841500,162052]
[null,null,null,"Ahorro valor CO2 con ","Ring-pan 2.5 D",175841.59999999998,{"$f":"+F32","v":175841.59999999998},{"$f":"+F32","v":175841.59999999998},{"$f":"+F32","v":175841.59999999998},{"$f":"+F32","v":175841.59999999998},{"$f":"+SUM(F32:J32)","v":879207.99999999988},{"$f":"+F32","v":175841.59999999998},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.980955991357922},{"$f":"+SUM(AE16:AE31)/SUM($AL$16:$AL$31)","v":1.8683408381336317E-3},{"$f":"+SUM(AF16:AF31)/SUM($AL$16:$AL$31)","v":0.98282433219605558},null,{"$f":"+SUM(AH16:AH31)/SUM($AL$16:$AL$31)","v":2.5297495215111923E-3},null,{"$f":"+SUM(AJ16:AJ31)/SUM($AL$16:$AL$31)","v":1.464591828243322E-2},{"$f":"+SUM(AK16:AK31)/SUM($AL$16:$AL$31)","v":1.7175667803944413E-2}]
[null,null,null,"Evolución Huella CO2 con ","Ring-pan 2.5 D",-1998200,{"$f":"+F33","v":-1998200},{"$f":"+G33","v":-1998200},-1998200,-1998200,{"$f":"+SUM(F33:J33)","v":-9991000},{"$f":"+F33","v":-1998200}]
[null,null,null,null,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":"+AB30","v":"Ring-pan Rev Elec Diesel"},{"$f":"+AL30","v":9088800},{"$f":"+AC34","v":"Ring-pan Rev Elec Diesel"},{"$f":"+AM30","v":-0.18107114539032654}]
[null,null,null,null,"SU PRODUCCIÓN DE CONCRETO ANUAL :",null,null,"ENTRAR DATOS",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":9055800},"Ring-pan Rev Elec Gas",{"$f":"+AM31","v":-0.1840445469617242}]
[null,null,null,null,"Resistencia concreto",null,"Producción ","Formulación kg/m3",null,null,null,null,null,null,null," "]
[null,null," ",null,"Mpa","kg/cm2*","anual","Agua","Cemento","Agregados","Total","Agua/Cem","%Agua","MPa teórica"]
[null,null," ",null,"Bloque 10-20 MPa","90-200 kg/cm2",0,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",0.5,180,325,1650,{"$f":"+SUM(H39:J39)","v":2155},{"$f":"IFERROR('Cálculo humedad'!J28,0)","v":0.55384615384615388},{"$f":"IFERROR(+H39/K39,0)","v":8.3526682134570762E-2},{"$f":"'Cálculo humedad'!$K$28","v":26.111111111111107}]
[null,null," ",null,"30 MPa","300-320 kg/cm2",0,0,0,0,0,{"$f":"IFERROR('Cálculo humedad'!J30,0)","v":0},{"$f":"IFERROR(+H40/K40,0)","v":0},{"$f":"'Cálculo humedad'!K30","v":0}]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,180,350,1600,{"$f":"+SUM(H41:J41)","v":2130},{"$f":"IFERROR('Cálculo humedad'!J31,0)","v":0.51428571428571423},8.4507042253521125E-2,{"$f":"'Cálculo humedad'!K31","v":28.888888888888893}]
[null,null," ",null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,0,0,0,0,{"$f":"'Cálculo humedad'!J33","v":0.36249999999999999},0,{"$f":"'Cálculo humedad'!K33","v":45.172413793103452}]
[null,null," ",null,"Durmiente 65 Mpa","660 kg/cm2",0,null,null,0,0,{"$f":"'Cálculo humedad'!J34","v":0.29555555555555557},0,{"$f":"'Cálculo humedad'!K34","v":57.669172932330824}]
[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:",50000,{"$f":"+G45/(8*6*50)","v":20.833333333333332},null,"Humedad mas alta :",0.03," "]
[]
[]
[null,null,null,null,"SI UTILIZAN UNA SONDA HUMEDAD FMS LIEBHERR : AHORRO CEMENTO."]
[]
[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":-3.0322307039864285},{"$f":"'Cálculo humedad'!$L$44","v":49273.748939779463},{"$f":"'Cálculo humedad'!$J$45","v":-5.5946791862284755},{"$f":"'Cálculo humedad'!$L$45","v":90913.536776212728},{"$f":"'Cálculo humedad'!$J$46","v":-7.7886710239651364},{"$f":"'Cálculo humedad'!$L$46","v":126565.90413943348},null,{"$f":"+E53","v":"25 MPa"},{"$f":"+H53","v":49273.748939779463},{"$f":"+J53","v":90913.536776212728},126565.90413943348]
[null,null,null,null,"30 MPa","300-320 kg/cm2",{"$f":"'Cálculo humedad'!$J$50","v":0},{"$f":"'Cálculo humedad'!$L$50","v":0},{"$f":"'Cálculo humedad'!$J$51","v":0},{"$f":"'Cálculo humedad'!$L$51","v":0},{"$f":"'Cálculo humedad'!$J$52","v":0},{"$f":"'Cálculo humedad'!$L$52","v":0},null,"30 MPa",0,0,0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",{"$f":"'Cálculo humedad'!$J$55","v":-3.1746031746031811},{"$f":"'Cálculo humedad'!$L$55","v":51587.301587301692},{"$f":"'Cálculo humedad'!$J$56","v":-5.8700209643605916},{"$f":"'Cálculo humedad'!$L$56","v":95387.840670859616},{"$f":"'Cálculo humedad'!$J$57","v":-8.1871345029239819},{"$f":"'Cálculo humedad'!$L$57","v":133040.93567251472},null,"35 MPa",51587.301587301692,95387.840670859616,133040.93567251472]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",{"$f":"'Cálculo humedad'!$J$61","v":0},{"$f":"'Cálculo humedad'!$L$61","v":0},{"$f":"'Cálculo humedad'!$J$62","v":0},{"$f":"'Cálculo humedad'!$L$62","v":0},{"$f":"'Cálculo humedad'!$J$63","v":0},{"$f":"'Cálculo humedad'!$L$63","v":0},null,"Vigueta 350-45 Mpa",0,0,0]
[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":100861.05052708116}," ",{"$f":"+SUM(J52:J57)","v":186301.37744707236},null,{"$f":"+SUM(L52:L57)","v":259606.83981194819}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"}," ",{"$f":"+(H58/$H$70)*$G$45","v":100861.05052708117}," ",{"$f":"+(J58/$H$70)*$G$45","v":186301.37744707236},null,{"$f":"+(L58/$H$70)*$G$45","v":259606.83981194816}]
[]
[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.5,{"$f":"'Cálculo cemento'!G19","v":25000},{"$f":"'Cálculo cemento'!I19","v":8125},null,null,{"$f":"+E65","v":"25 MPa"},{"$f":"+H65","v":25000},{"$f":"+I65","v":8125}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,{"$f":"'Cálculo cemento'!G20","v":0},{"$f":"'Cálculo cemento'!I20","v":0},null,null,"30 MPa",0,0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,{"$f":"'Cálculo cemento'!G21","v":25000},{"$f":"'Cálculo cemento'!I21","v":8750},null,null,"35 MPa",25000,8750]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,{"$f":"'Cálculo cemento'!G22","v":0},{"$f":"'Cálculo cemento'!I22","v":0},null,null,"Vigueta 350-45 Mpa",0,0]
[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":50000},{"$f":"'Cálculo cemento'!$I$24","v":16875}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000}," ",{"$f":"'Cálculo cemento'!$I$25","v":16875}]
[]
[]
[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":"+H91*1000","v":0},{"$f":"+I91","v":0}]
[null,null,null,null,"25 MPa","250 kg/cm2",0.5,1080.625,140481.25000000003,null,null,"25 MPa",{"$f":"+H92*1000","v":1486875},{"$f":"+I92","v":193293.75000000003}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,0,0,null,null,"30 MPa",0,{"$f":"+I93","v":0}]
[null,null,null,null,{"$f":"+E40","v":"30 MPa"},{"$f":"+F40","v":"300-320 kg/cm2"},{"$f":"+G41","v":0.5},1233.7499999999998,160387.5,null,null,"30 MPa",1671250,{"$f":"+I94","v":217262.50000000003}]
[null,null,null,null,{"$f":"+E42","v":"Vigueta 350-45 Mpa"},{"$f":"+F42","v":"350-450 kg/cm2"},{"$f":"+G42","v":0},0,0,null,null,"Vigueta 350-45 Mpa",0,{"$f":"+I95","v":0}]
[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,{"$f":"+I96","v":0}]
[null,null,null,null,null,{"$f":"+F44","v":"Total detallado % :"},{"$f":"+SUM(G78:G83)","v":1},{"$f":"'Cálculo cemento'!G42","v":2314.375},{"$f":"+SUM(I78:I83)","v":300868.75}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000},{"$f":"+H84","v":2314.375},{"$f":"+I84","v":300868.75}]
[]
[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,null,{"$f":"+E52","v":"Bloque 10-20 MPa"},{"$f":"+F64","v":"90-200 kg/cm2"},{"$f":"+G64","v":0},0,0]
[null,null,null,null,{"$f":"+E53","v":"25 MPa"},{"$f":"+F65","v":"250 kg/cm2"},0.5,1486.875,193293.75000000003]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,0,0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,1671.25,217262.50000000003]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,0,0]
[null,null,null,null,"Durmiente 65 Mpa","660 kg/cm2",0,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":3158.125},{"$f":"+SUM(I91:I96)","v":410556.25000000006}]
[null,null,null,null,null,{"$f":"+F56","v":"350-450 kg/cm2"},{"$f":"+G71","v":50000},{"$f":"+H97","v":3158.125},{"$f":"+I97","v":410556.25000000006}]
[]
[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.5,{"$f":"'Cálculo cemento'!H49","v":18225},null,null,{"$f":"+E104","v":"25 MPa"},{"$f":"+H104","v":18225},{"$f":"+H116","v":2292.5}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,{"$f":"'Cálculo cemento'!H50","v":0},null,null,"30 MPa",0,0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,{"$f":"'Cálculo cemento'!H51","v":36450},null,null,"35 MPa",36450,4582.5]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,{"$f":"'Cálculo cemento'!H52","v":0},null,null,"Vigueta 350-45 Mpa",0,0]
[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":54675}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000},{"$f":"'Cálculo cemento'!H55","v":54674.999999999993}]
[]
[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.5,{"$f":"'Cálculo cemento'!H60","v":2292.5}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,{"$f":"'Cálculo cemento'!H61","v":0}]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,{"$f":"'Cálculo cemento'!H62","v":4582.5}]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,{"$f":"'Cálculo cemento'!H63","v":0}]
[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":6875}]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000},{"$f":"'Cálculo cemento'!H66","v":6875.0000000000009}]
[]
[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.5,{"$f":"+H116+H104","v":20517.5}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,41032.5]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,0]
[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},61550]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000},61549.999999999993]
[]
[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.5,{"$f":"'Cálculo CO2 directo'!H46","v":5500},"kg/año",null,{"$f":"+E139","v":"25 MPa"},{"$f":"+H139","v":5500}]
[null,null,null,null,"30 MPa","300-320 kg/cm2",0,{"$f":"'Cálculo CO2 directo'!H47","v":0},"kg/año",null,"30 MPa",0]
[null,null,null,null,"35 MPa","350-400 kg/cm2",0.5,{"$f":"'Cálculo CO2 directo'!H48","v":11000},"kg/año",null,"35 MPa",11000]
[null,null,null,null,"Vigueta 350-45 Mpa","350-450 kg/cm2",0,{"$f":"'Cálculo CO2 directo'!H49","v":0},"kg/año",null,"Vigueta 350-45 Mpa",0]
[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":16500},"kg/año"]
[null,null,null,null,null,{"$f":"+F45","v":"Total producido m3:"},{"$f":"+G45","v":50000},{"$f":"'Cálculo CO2 directo'!H52","v":66000},"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," "]
[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," "]
[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":50000}]
[]
[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",217.7,0.308,{"$f":"+I10+J10","v":218.00799999999998},0.66,3.3,{"$f":"+L10+M10","v":3.96},{"$f":"+N10+K10","v":221.96799999999999}]
[null,null,"Rev. Gas","Revolvedora normal","Gas  chasis","Revolvedora+gas","Gas","Gas",{"$f":"+I10","v":217.7},0.246,{"$f":"+I11+J11","v":217.946},0.52800000000000002,2.64,{"$f":"+L11+M11","v":3.1680000000000001},{"$f":"+N11+K11","v":221.114}]
[null,null,"Rev Elec Diesel","Revolvedora eléctrica Plug-in","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I10","v":217.7},0.20200000000000001,217.90199999999999,0.432,{"$f":"+M10","v":3.3},3.7319999999999998,221.63399999999999]
[null,null,"Rev Elec Gas","Revolvedora eléctrica Plug-in","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I10","v":217.7},0.20200000000000001,217.90199999999999,{"$f":"+L12","v":0.432},{"$f":"+M11","v":2.64},3.0720000000000001,220.97399999999999]
[null,null,"Tilt Diesel","Revolvedora Tilt","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",213.3,0.68600000000000005,{"$f":"+I14+J14","v":213.98600000000002},{"$f":"+L10","v":0.66},3.3,{"$f":"+L14+M14","v":3.96},{"$f":"+N14+K14","v":217.94600000000003}]
[null,null,"Tilt Gas","Revolvedora Tilt","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I14","v":213.3},{"$f":"+J14","v":0.68600000000000005},213.98600000000002,0.52800000000000002,2.64,3.1680000000000001,217.15400000000002]
[null,null,"Tilt Rev Elec Diesel","Revolvedora Tilt","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I14","v":213.3},{"$f":"+J14","v":0.68600000000000005},213.98600000000002,0.432,3.3,3.7319999999999998,217.71800000000002]
[null,null,"Tilt Rev Elec Gas","Revolvedora Tilt","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I14","v":213.3},{"$f":"+J14","v":0.68600000000000005},213.98600000000002,0.432,2.64,3.0720000000000001,217.05800000000002]
[null,null,"Twin-shaft Diesel","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",187,0.246,187.24600000000001,{"$f":"+L10","v":0.66},{"$f":"+M10","v":3.3},3.96,191.20600000000002]
[null,null,"Twin-shaft Gas","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I18","v":187},{"$f":"+J18","v":0.246},187.24600000000001,{"$f":"+L11","v":0.52800000000000002},2.64,3.1680000000000001,190.41400000000002]
[null,null,"Twin-shaft Rev Elec Diesel","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I18","v":187},{"$f":"+J18","v":0.246},187.24600000000001,{"$f":"+L12","v":0.432},3.3,3.7319999999999998,190.97800000000001]
[null,null,"Twin-shaft Rev Elec Gas","Mezclador Twin-shaft LIEBHERR","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I18","v":187},{"$f":"+J18","v":0.246},187.24600000000001,{"$f":"+L13","v":0.432},2.64,3.0720000000000001,190.31800000000001]
[null,null,"Ring-pan Diesel","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora+diesel","Diesel","Diesel",177.7,0.34399999999999997,178.04399999999998,{"$f":"+L10","v":0.66},{"$f":"+M10","v":3.3},3.96,182.00399999999999]
[null,null,"Ring-pan Gas","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora+gas","Gas","Gas",{"$f":"+I22","v":177.7},{"$f":"+J22","v":0.34399999999999997},178.04399999999998,{"$f":"+L11","v":0.52800000000000002},2.64,3.1680000000000001,181.21199999999999]
[null,null,"Ring-pan Rev Elec Diesel","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora elec.+diesel","Electricidad CFE","Diesel ",{"$f":"+I22","v":177.7},{"$f":"+J22","v":0.34399999999999997},178.04399999999998,{"$f":"+L12","v":0.432},3.3,3.7319999999999998,181.77599999999998]
[null,null,"Ring-pan Rev Elec Gas","Mezclador Ring-pan LIEBHERR","Electricidad CFE","Revolvedora elec.+gas","Electricidad CFE","Gas",{"$f":"+I22","v":177.7},{"$f":"+J22","v":0.34399999999999997},178.04399999999998,{"$f":"+L13","v":0.432},2.64,3.0720000000000001,181.11599999999999]
[]
[null,null,null,null,null,null,null,null,"HUELLA CO2 EN KG PARA LA PRODUCCIION ANUAL"]
[null,null,{"$f":"+C10","v":"Rev. Diesel"},null,null,null,null,null,{"$f":"+I10*$D$5","v":10885000},{"$f":"+J10*$D$5","v":15400},10900399.999999998,33000,165000,198000,11098400]
[null,null,{"$f":"+C11","v":"Rev. Gas"},null,null,null,null,null,{"$f":"+I11*$D$5","v":10885000},12300,10897300,26400,132000,158400,11055700]
[null,null,{"$f":"+C12","v":"Rev Elec Diesel"},null,null,null,null,null,{"$f":"+I12*$D$5","v":10885000},10100,10895100,21600,165000,186600,11081700]
[null,null,{"$f":"+C13","v":"Rev Elec Gas"},null,null,null,null,null,{"$f":"+I13*$D$5","v":10885000},10100,10895100,21600,132000,153600,11048700]
[null,null,{"$f":"+C14","v":"Tilt Diesel"},null,null,null,null,null,{"$f":"+I14*$D$5","v":10665000},34300,10699300,33000,165000,198000,10897300.000000002]
[null,null,"Tilt Gas",null,null,null,null,null,{"$f":"+I15*$D$5","v":10665000},34300,10699300,26400,132000,158400,10857700.000000002]
[null,null,"Tilt Rev Elec Diesel",null,null,null,null,null,{"$f":"+I16*$D$5","v":10665000},34300,10699300,21600,165000,186600,10885900]
[null,null,"Tilt Rev Elec Gas",null,null,null,null,null,{"$f":"+I17*$D$5","v":10665000},34300,10699300,21600,132000,153600,10852900.000000002]
[null,null,{"$f":"+C18","v":"Twin-shaft Diesel"},null,null,null,null,null,{"$f":"+I18*$D$5","v":9350000},12300,9362300,33000,165000,198000,9560300]
[null,null,"Twin-shaft Gas",null,null,null,null,null,{"$f":"+I19*$D$5","v":9350000},12300,9362300,26400,132000,158400,9520700]
[null,null,"Twin-shaft Rev Elec Diesel",null,null,null,null,null,{"$f":"+I20*$D$5","v":9350000},12300,9362300,21600,165000,186600,9548900]
[null,null,"Twin-shaft Rev Elec Gas",null,null,null,null,null,{"$f":"+I21*$D$5","v":9350000},12300,9362300,21600,132000,153600,9515900]
[null,null,"Ring-pan Diesel",null,null,null,null,null,{"$f":"+I22*$D$5","v":8885000},17200,8902200,33000,165000,198000,9100200]
[null,null,"Ring-pan Gas",null,null,null,null,null,{"$f":"+I23*$D$5","v":8885000},17200,8902200,26400,132000,158400,9060600]
[null,null,"Ring-pan Rev Elec Diesel",null,null,null,null,null,{"$f":"+I24*$D$5","v":8885000},17200,8902200,21600,165000,186600,9088800]
[null,null,"Ring-pan Rev Elec Gas",null,null,null,null,null,{"$f":"+I25*$D$5","v":8885000},17200,8902200,21600,132000,153600,9055800]
[]
[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":10885},{"$f":"+(J10*$D$5)/1000","v":15.4},10900.399999999998,33,165,198,11098.4]
[null,null,{"$f":"+C11","v":"Rev. Gas"},null,null,null,null,null,{"$f":"+(I11*$D$5)/1000","v":10885},12.3,10897.3,26.4,132,158.4,11055.7]
[null,null,{"$f":"+C12","v":"Rev Elec Diesel"},null,null,null,null,null,{"$f":"+(I12*$D$5)/1000","v":10885},10.1,10895.1,21.6,165,186.6,11081.7]
[null,null,{"$f":"+C13","v":"Rev Elec Gas"},null,null,null,null,null,{"$f":"+(I13*$D$5)/1000","v":10885},10.1,10895.1,21.6,132,153.6,11048.7]
[null,null,{"$f":"+C14","v":"Tilt Diesel"},null,null,null,null,null,{"$f":"+(I14*$D$5)/1000","v":10665},34.299999999999997,10699.3,33,165,198,10897.300000000001]
[null,null,"Tilt Gas",null,null,null,null,null,{"$f":"+(I15*$D$5)/1000","v":10665},34.299999999999997,10699.3,26.4,132,158.4,10857.700000000003]
[null,null,"Tilt Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I16*$D$5)/1000","v":10665},34.299999999999997,10699.3,21.6,165,186.6,10885.9]
[null,null,"Tilt Rev Elec Gas",null,null,null,null,null,{"$f":"+(I17*$D$5)/1000","v":10665},34.299999999999997,10699.3,21.6,132,153.6,10852.900000000001]
[null,null,{"$f":"+C18","v":"Twin-shaft Diesel"},null,null,null,null,null,{"$f":"+(I18*$D$5)/1000","v":9350},12.3,9362.2999999999993,33,165,198,9560.2999999999993]
[null,null,"Twin-shaft Gas",null,null,null,null,null,{"$f":"+(I19*$D$5)/1000","v":9350},12.3,9362.2999999999993,26.4,132,158.4,9520.7000000000007]
[null,null,"Twin-shaft Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I20*$D$5)/1000","v":9350},12.3,9362.2999999999993,21.6,165,186.6,9548.9]
[null,null,"Twin-shaft Rev Elec Gas",null,null,null,null,null,{"$f":"+(I21*$D$5)/1000","v":9350},12.3,9362.2999999999993,21.6,132,153.6,9515.9]
[null,null,"Ring-pan Diesel",null,null,null,null,null,{"$f":"+(I22*$D$5)/1000","v":8885},17.2,8902.2000000000007,33,165,198,9100.2000000000007]
[null,null,"Ring-pan Gas",null,null,null,null,null,{"$f":"+(I23*$D$5)/1000","v":8885},17.2,8902.2000000000007,26.4,132,158.4,9060.6]
[null,null,"Ring-pan Rev Elec Diesel",null,null,null,null,null,{"$f":"+(I24*$D$5)/1000","v":8885},17.2,8902.2000000000007,21.6,165,186.6,9088.7999999999993]
[null,null,"Ring-pan Rev Elec Gas",null,null,null,null,null,{"$f":"+(I25*$D$5)/1000","v":8885},17.2,8902.2000000000007,21.6,132,153.6,9055.7999999999993]

{"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,2.6,"Pesos/kg",{"$f":"+G3/G4","v":0.13},"USD"]
[null,null,null,null,"1 USD =",null,20,"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":"1. Cálculo ahorros si utiliza un mezclador LIEBHERR al lugar de una Revolvedora Olla o TILT."},{"$f":"'Ring-pan y Huella CO2'!G10","v":0}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!F12","v":"3. Cálculo ahorro cemento si utiliza una Sistema de Medición Humedad LIEBHERR."},{"$f":"'Ring-pan y Huella CO2'!G11","v":0}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null," ",{"$f":"'Ring-pan y Huella CO2'!B8","v":"EQUIPO FRANCES SA DE CV, Colima, 21 de Junio 2020, actualizado Jun. 22 2022."},null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,"SU PRODUCCIÓN DE CONCRETO ANUAL :"]
[null,null,null,null,null,"%","m3/año","Cemento consumido con Olla* :",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,null,null,null,"kg/m3","t/año",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,null,null,null,null,"<25Mpa",{"$f":"+G18","v":0},{"$f":"+F18","v":0},null,null,null,null,null,"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.5},25000,{"$f":"'Ring-pan y Huella CO2'!I39","v":325},{"$f":"+G19*H19/1000","v":8125},null,null,null,null,null,null,"25 MPa",{"$f":"+G19","v":25000},{"$f":"+F19","v":0.5},null,null,null,null,null,"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},0,{"$f":"'Ring-pan y Huella CO2'!I40","v":0},0,null,null,null,null,null,null,"35 MPa",0,0,null,null,null,null,null,"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.5},25000,350,{"$f":"+G21*H21/1000","v":8750}]
[null,null,null,"Vigueta 45 Mpa","455 kg/cm2",{"$f":"'Ring-pan y Huella CO2'!G42","v":0},0,450,0,null,null,null,null,null,null,"50 Mpa",0,0,null,null,null,null,null,"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,550,0,null,null,null,null,null,null,"65 Mpa",0,0,null,null,null,null,null,"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":50000},{"$f":"IFERROR(+SUM(I18:I23)*1000/G24,0)","v":337.5},{"$f":"+SUM(I18:I23)","v":16875}]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!F45","v":"Total producido m3:"},{"$f":"'Ring-pan y Huella CO2'!$G$45","v":50000},null," ",{"$f":"+(F25*H24)/1000","v":16875}]
[null,null,null,null," "]
[null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"+SUM(#REF!)","v":{"$error":"#REF!"}}]
[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.5,1080.625,{"$f":"+G37*$I$3*1000","v":140481.25000000003},{"$f":"+I19*(K37)*$I$3*1000","v":21125},0.13300000000000001,0.02,{"$f":"+K37*I19","v":162.5},{"$f":"+G37-L37","v":918.125},{"$f":"+H37-I37","v":119356.25000000003},{"$f":"+J37+0.05","v":0.183},1486.875,{"$f":"+P37*$I$3*1000","v":193293.75000000003},{"$f":"+P37-L37","v":1324.375},{"$f":"+Q37-I37","v":172168.75000000003}]
[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,0,0,0,0.107,0.02,0,0,0,0.157,0,0,0,0]
[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.5,1233.7499999999998,160387.5,22750,0.14099999999999999,0.02,175,1058.7499999999998,137637.5,0.191,1671.25,217262.50000000003,1496.25,194512.50000000003]
[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,0,0,0,0.115,0.02,0,0,0,0.16500000000000001,0,0,0,0]
[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":2314.375},{"$f":"+SUM(H36:H41)","v":300868.75},{"$f":"+SUM(I36:I41)","v":43875},null,null,{"$f":"+SUM(L36:L41)","v":337.5},{"$f":"+SUM(M36:M41)","v":1976.8749999999998},256993.75000000003,null,{"$f":"+SUM(P36:P41)","v":3158.125},410556.25000000006,null,366681.25000000006]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":50000},{"$f":"+(G42/G24)*F25","v":2314.375},{"$f":"+G43*I3*1000","v":300868.75000000006},{"$f":"+(I42/G24)*F43","v":43875},null,null,"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,"%","USD/1000m3","Valor USD/año"]
[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,{"$f":"+E37","v":"250 kg/cm2"},0.5,729,18225]
[null,null,null,null,{"$f":"+E38","v":"300-320 kg/cm2"},0,1021,0]
[null,null,null,null,{"$f":"+E39","v":"350-400 kg/cm2"},0.5,1458,36450]
[null,null,null,null,{"$f":"+E40","v":"350-450 kg/cm2"},0,1896,0]
[null,null,null,null,{"$f":"+E41","v":"660 kg/cm2"},0,2188,0]
[null,null,null,null,{"$f":"+E24","v":"Total detallado % :"},{"$f":"+F24","v":1}," ",{"$f":"+SUM(H48:H53)","v":54675}]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":50000},{"$f":"+F25","v":50000},{"$f":"+(H54/G24)*G55","v":54674.999999999993}]
[]
[null,null,null,null,"SI CAMBIO DE OLLA A MTS : AHORRO GAZOLINA :"]
[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.5,91.7,2292.5]
[null,null,null,null,{"$f":"+E38","v":"300-320 kg/cm2"},0,128.30000000000001,0]
[null,null,null,null,{"$f":"+E39","v":"350-400 kg/cm2"},0.5,183.3,4582.5]
[null,null,null,null,{"$f":"+E40","v":"350-450 kg/cm2"},0,238.3,0]
[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":6875}]
[null,null,null,null,{"$f":"+E25","v":"Total producido m3:"},{"$f":"+F25","v":50000},{"$f":"+F37","v":0.5},{"$f":"+(H65/G24)*F66","v":6875.0000000000009}]

{"sheet":"Cálculo humedad","index":6,"n_rows":72,"n_cols":33,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Costo cemento :",null,null,null,null,2.6,null,null,"Pesos/kg",{"$f":"+J3/J4","v":0.13},"USD/kg"]
[null,null,null,null,"1 USD =",null,null,null,null,20,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$8","v":"EQUIPO FRANCES SA DE CV, Colima, 21 de Junio 2020, actualizado Jun. 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":50000}]
[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.03}]
[null,null,null,null,"Variación humedad : ",null,null,{"$f":"+H22-H21","v":1.9999999999999997E-2}]
[]
[]
[null,null,null,null,null,null,null,"Agua","Cemento","Agua/Cemento","Rb28 teórica","Agregados","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":325},{"$f":"IFERROR(+H28/I28,0)","v":0.55384615384615388},{"$f":"IFERROR(+$H$15*$H$16*((1/J28)-0.5),0)","v":26.111111111111107},{"$f":"'Ring-pan y Huella CO2'!J39","v":1650},{"$f":"'Cálculo cemento'!$G$19","v":25000}]
[null,null,null,null,"Total estimado Bloque",null,null,null,null,null,null,null,{"$f":"'Cálculo cemento'!$G$24","v":50000}]
[null,null,null,null,"Prefabricado n°1 30-40 MPa",null,null,{"$f":"'Ring-pan y Huella CO2'!H40","v":0},{"$f":"'Ring-pan y Huella CO2'!I40","v":0},{"$f":"IFERROR(+H30/I30,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/J30)-0.5),0)","v":0},{"$f":"'Ring-pan y Huella CO2'!J40","v":0},{"$f":"'Cálculo cemento'!$G$20","v":0}]
[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":350},{"$f":"+H31/I31","v":0.51428571428571423},{"$f":"+$H$15*$H$16*((1/J31)-0.5)","v":28.888888888888893},{"$f":"'Ring-pan y Huella CO2'!J41","v":1600},{"$f":"'Cálculo cemento'!$G$21","v":25000}]
[null,null,null,null,"Total estimado Prefabricado",null,null,null,null,null,null,null,{"$f":"'Cálculo cemento'!$G$24","v":50000}]
[null,null,null,null,"Vigueta 45 Mpa",null,null,145,400,0.36249999999999999,45.172413793103452,{"$f":"'Ring-pan y Huella CO2'!J42","v":0},{"$f":"'Cálculo cemento'!$I$22","v":0}]
[null,null,null,null,"Durmiento 65 Mpa",null,null,133,450,0.29555555555555557,57.669172932330824,{"$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":16.5},{"$f":"IFERROR(+($H$28+F44)/$I$28,0)","v":0.60461538461538467},{"$f":"IFERROR(+G44-$J$28,0)","v":5.0769230769230789E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G44)-0.5),0)","v":23.078880407124679},{"$f":"IFERROR(+I44-$K$28,0)","v":-3.0322307039864285},{"$f":"-J44*$H$17","v":15.161153519932142},{"$f":"+K44*$N$3*'Cálculo cemento'!$G$19","v":49273.748939779463}]
[null,null,null,null,0.02,{"$f":"+$L$28*E45","v":33},{"$f":"IFERROR(+($H$28+F45)/$I$28,0)","v":0.65538461538461534},{"$f":"IFERROR(+G45-$J$28,0)","v":0.10153846153846147},{"$f":"IFERROR(+$H$15*$H$16*((1/G45)-0.5),0)","v":20.516431924882632},{"$f":"IFERROR(+I45-$K$28,0)","v":-5.5946791862284755},{"$f":"-J45*$H$17","v":27.973395931142377},{"$f":"+K45*$N$3*'Cálculo cemento'!$G$19","v":90913.536776212728}]
[null,null,null,null,0.03,49.5,0.70615384615384613,0.15230769230769226,18.322440087145971,-7.7886710239651364,38.943355119825682,{"$f":"+K46*$N$3*'Cálculo cemento'!$G$19","v":126565.90413943348}]
[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":90913.536776212728}]
[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":0},{"$f":"IFERROR(+($H$30+F50)/$I$30,0)","v":0},{"$f":"IFERROR(+G50-$J$30,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G50)-0.5),0)","v":0},{"$f":"IFERROR(+I50-$K$30,0)","v":0},{"$f":"-J50*$H$17","v":0},{"$f":"+K50*$N$3*'Cálculo cemento'!$G$20","v":0}]
[null,null,null,null,0.02,{"$f":"+$L$30*E51","v":0},{"$f":"IFERROR(+($H$30+F51)/$I$30,0)","v":0},{"$f":"IFERROR(+G51-$J$30,0)","v":0},{"$f":"IFERROR(+$H$15*$H$16*((1/G51)-0.5),0)","v":0},{"$f":"IFERROR(+I51-$K$30,0)","v":0},{"$f":"-J51*$H$17","v":0},{"$f":"+K51*$N$3*'Cálculo cemento'!$G$20","v":0}]
[null,null,null,null,0.03,0,0,0,0,0,0,{"$f":"+K52*$N$3*'Cálculo cemento'!$G$20","v":0}]
[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":16},{"$f":"IFERROR(+($H$31+F55)/$I$31,0)","v":0.56000000000000005},{"$f":"IFERROR(+G55-$J$31,0)","v":4.5714285714285818E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G55)-0.5),0)","v":25.714285714285712},{"$f":"IFERROR(+I55-$K$31,0)","v":-3.1746031746031811},{"$f":"-J55*$H$17","v":15.873015873015905},{"$f":"+K55*$N$3*'Cálculo cemento'!$G$21","v":51587.301587301692}]
[null,null,null,null,0.02,{"$f":"+$L$31*E56","v":32},{"$f":"IFERROR(+($H$31+F56)/$I$31,0)","v":0.60571428571428576},{"$f":"IFERROR(+G56-$J$31,0)","v":9.1428571428571526E-2},{"$f":"IFERROR(+$H$15*$H$16*((1/G56)-0.5),0)","v":23.018867924528301},{"$f":"IFERROR(+I56-$K$31,0)","v":-5.8700209643605916},{"$f":"-J56*$H$17","v":29.350104821802958},{"$f":"+K56*$N$3*'Cálculo cemento'!$G$21","v":95387.840670859616}," "]
[null,null,null,null,0.03,48,0.65142857142857147,0.13714285714285723,20.701754385964911,-8.1871345029239819,40.93567251461991,{"$f":"+K57*$N$3*'Cálculo cemento'!$G$21","v":133040.93567251472}]
[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":95387.840670859616}]
[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":0},{"$f":"+($H$33+F61)/$I$33","v":0.36249999999999999},{"$f":"+G61-$J$33","v":0},{"$f":"+$H$15*$H$16*((1/G61)-0.5)","v":45.172413793103452},{"$f":"+I61-$K$33","v":0},{"$f":"-J61*$H$17","v":0},{"$f":"+K61*$N$3*'Cálculo cemento'!$G$22","v":0}]
[null,null,null,null,0.02,{"$f":"+$L$33*E62","v":0},{"$f":"+($H$33+F62)/$I$33","v":0.36249999999999999},{"$f":"+G62-$J$33","v":0},{"$f":"+$H$15*$H$16*((1/G62)-0.5)","v":45.172413793103452},{"$f":"+I62-$K$33","v":0},{"$f":"-J62*$H$17","v":0},{"$f":"+K62*$N$3*'Cálculo cemento'!$G$22","v":0}]
[null,null,null,null,0.03,0,0.36249999999999999,0,45.172413793103452,0,0,{"$f":"+K63*$N$3*'Cálculo cemento'!$G$22","v":0}]
[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":"+($H$34+F66)/$I$34","v":0.29555555555555557},{"$f":"+G66-$J$34","v":0},{"$f":"+$H$15*$H$16*((1/G66)-0.5)","v":57.669172932330824},{"$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":"+($H$34+F67)/$I$34","v":0.29555555555555557},{"$f":"+G67-$J$34","v":0},{"$f":"+$H$15*$H$16*((1/G67)-0.5)","v":57.669172932330824},{"$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,0.29555555555555557,0,57.669172932330824,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":0},null,{"$f":"+L47+L58+L62+L67","v":186301.37744707236}]
[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"]

{"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,2.2999999999999998,"Pesos/kg"]
[null,null,null,null,"1 USD =",null,20,"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$8","v":"EQUIPO FRANCES SA DE CV, Colima, 21 de Junio 2020, actualizado Jun. 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.5},{"$f":"'Cálculo cemento'!G19","v":25000},5500,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E105","v":"30 MPa"},{"$f":"'Cálculo cemento'!F20","v":0},{"$f":"'Cálculo cemento'!G20","v":0},0,"kg/año"]
[null,null,null,null,{"$f":"'Ring-pan y Huella CO2'!E106","v":"35 MPa"},{"$f":"'Cálculo cemento'!F21","v":0.5},{"$f":"'Cálculo cemento'!G21","v":25000},11000,"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},{"$f":"'Cálculo cemento'!G22","v":0},0,"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":50000},{"$f":"+SUM(H46:H50)","v":16500},"kg/año"]
[null,null,null,null,null,{"$f":"'[1]Pagina a utilizar'!$E$28","v":200000}," ",{"$f":"+(H51/G51)*F52","v":66000}]
[]
[]
[]
[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,2.2999999999999998,"Pesos/kg"]
[null,null,null,null,"1 USD =",null,null,null,null,20,"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$8","v":"EQUIPO FRANCES SA DE CV, Colima, 21 de Junio 2020, actualizado Jun. 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",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":50000},"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":20416.666666666668},{"$f":"+O34*$H$19","v":0.20171666666666666},{"$f":"+Q34*$H$25","v":10085.833333333332},541000,{"$f":"+S34/N34","v":0.36802721088435375},0.78600000000000003,{"$f":"+U34*P34","v":16047.500000000002},{"$f":"+V34/$J$4","v":802.37500000000011}]
[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":69444.444444444438},{"$f":"+O35*$H$19","v":0.68611111111111112},{"$f":"+Q35*$H$25","v":34305.555555555555},541000,{"$f":"+S35/N35","v":0.1082},0.78600000000000003,{"$f":"+U35*P35","v":54583.333333333328},{"$f":"+V35/$J$4","v":2729.1666666666665}]
[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":26190.476190476191},0.25876190476190475,12938.095238095237,null,null,0.78600000000000003,20585.714285714286,1029.2857142857142]
[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":22261.90476190476},0.21994761904761903,10997.380952380952,null,null,0.78600000000000003,17497.857142857141,874.89285714285711]
[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":31166.666666666664},{"$f":"+O38*$H$19","v":0.30792666666666663},{"$f":"+Q38*$H$25","v":15396.333333333332},null,null,0.78600000000000003,24497,1224.8499999999999]
[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":2314.375},{"$f":"+$H$15","v":622},{"$f":"+G42*F42","v":1439541.25}," "]
[null,null,null,null,"Revolvedora 8 m3sobre chasis Gas",{"$f":"'Cálculo cemento'!$G$43","v":2314.375},{"$f":"+$H$15","v":622},{"$f":"+(F43*$H$16)*1000","v":1439541.25}]
[null,null,null,null,"Revolvedora 8 m3 eléctrica sobre chasis diesel",{"$f":"'Cálculo cemento'!$G$43","v":2314.375},622,{"$f":"+(F44*$H$16)*1000","v":1439541.25}]
[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"]