{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduccion","Und. Conversion","Empresa","Inventario","Cuentas","Hoja de Costos"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":4,"comments":0,"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":"Introduccion","index":0,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,3,19,6],[9,1,9,7],[12,1,13,1],[5,5,5,6],[14,3,14,6],[17,3,17,6],[12,3,13,4],[12,2,13,2],[15,3,15,6],[16,3,16,6],[10,2,10,6]]}
[]
[null,null,null,null,null,null,null,"Introducción"]
[null,null,"www.asesoriasmipyme.com"]
[]
[]
[]
[]
[]
[]
[null,"¿Cómo usar esta Plantilla de Costos de Conversión? "]
[null,null," Realizar la conversión de las unidades de medida: Kg, lb, Oz, L y panales  a unidades más pequeñas y calcula el costo de la MOD, CIF y CC."]
[]
[null,0,"Introducción","Rellena las celdas que esten en color amarillo. "]
[]
[null,1,"Und.                                 Conversión","Revisa y ajusta las unidades de conversión según su pais."]
[null,2,"Empresa","Introduce la información de MOD, salarios y CIF."]
[null,3,"Inventario","Introduce las cantidades precisas para el volumen de producción y las compras para el periodo."]
[null,4,"Cuentas","Revisar los valores. "]
[null,5,"Hoja de costos","Presenta un resumen sobre los costos: MOD, CIF, Iva, costos de conversión del periodo y los detalles por unidad. "]

{"sheet":"Und. Conversion","index":1,"n_rows":177,"n_cols":70,"rows_kept":177,"cut":false,"hidden":false,"merged":[[1,2,1,13],[2,2,2,13],[17,54,36,54],[37,54,56,54],[57,54,76,54],[15,66,15,68],[96,54,116,54],[117,54,136,54],[137,54,156,54],[157,54,176,54],[77,54,95,54]]}
[]
[null,null,"Unidades de Conversion "]
[null,null,"Revisar según tu pais"]
[null,null,"www.asesoriasmipyme.com"]
[]
[]
[]
[null,null,null,null,null,null,"Si aplica"]
[null,"Can.","Und. Conversion ","Abreviatura","Equivalencia",null,"Iva"]
[null,1,"Libra: ","Lb",500,null,0.16]
[null,1,"kilo:","kg",1000]
[null,1,"Onza:","Oz",28.34]
[null,1,"Panal de huevos:","Panal",30]
[null,1,"Litro","L",1000]
[null,1,"Gramo","gr",1E-3]
[null,1,"Mililitro","ml",1E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"valor compra"]
[null,1,"Unidad","u",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conv","n°","valor",null,"valor-. C","organizar","compras","CONDICION 1 ","CONDICION 2","CONDICION 3","Valor c","reseta","condicion 1 ","condicion 2","condiicon 3","conversion gr","conversion ml","conversion unidad","suma"]
[null,1,"Otra",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"$E$10","v":500},1,{"$f":"IF(Inventario!F11=\"Lb\",Inventario!E11*'Und. Conversion'!AZ19,0)","v":0},"LB",{"$f":"IF(Inventario!J11=\"Lb\",Inventario!I11*'Und. Conversion'!AZ18,0)","v":0},{"$f":"SUM((SUMIFS(BB18:BB177,BA18:BA177,BA18)))","v":0},{"$f":"Inventario!J11","v":0},{"$f":"IF(OR(BF18=\"Kg\",BF18=\"Lb\",BF18=\"gr\",BF18=\"Oz\"),\"gr\",\"\")","v":""},{"$f":"IF(OR(BF18=\"L\",BF18=\"ml\"),\"ml\",\"\")","v":""},{"$f":"IF(OR(BF18=\"Panal\", BF18=\"u\"),\"u\",\"\")","v":""},{"$f":"SUM((SUMIFS(BD18:BD177,BA18:BA177,BA18)))","v":0},{"$f":"Inventario!F11","v":0},{"$f":"IF(OR(BK18=\"Kg\",BK18=\"Lb\",BK18=\"gr\",BK18=\"Oz\"),\"gr\",\"\")","v":""},{"$f":"IF(OR(BK18=\"L\",BK18=\"ml\"),\"ml\",\"\")","v":""},{"$f":"IF(OR(BK18=\"Panal\",BK18=\"u\"),\"u\",\"\")","v":""},{"$f":"IF(AND(BG18=\"gr\",BL18=\"gr\"),BJ18,0)","v":0},{"$f":"IF(AND(BH18=\"ml\",BM18=\"ml\"),BJ18,0)","v":0},{"$f":"IF(AND(BI18=\"u\",BN18=\"u\"),BJ18,0)","v":0},{"$f":"SUM(BO18:BQ18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$10","v":500},2,{"$f":"IF(Inventario!F12=\"Lb\",Inventario!E12*'Und. Conversion'!AZ20,0)","v":0},null,{"$f":"IF(Inventario!J12=\"Lb\",Inventario!I12*'Und. Conversion'!AZ19,0)","v":0},{"$f":"SUM((SUMIFS(BB19:BB178,BA19:BA178,BA19)))","v":0},{"$f":"Inventario!J12","v":0},{"$f":"IF(OR(BF19=\"Kg\",BF19=\"Lb\",BF19=\"gr\",BF19=\"Oz\"),\"gr\",\"\")","v":""},{"$f":"IF(OR(BF19=\"L\",BF19=\"ml\"),\"ml\",\"\")","v":""},{"$f":"IF(OR(BF19=\"Panal\", BF19=\"u\"),\"u\",\"\")","v":""},{"$f":"SUM((SUMIFS(BD19:BD178,BA19:BA178,BA19)))","v":0},{"$f":"Inventario!F12","v":0},{"$f":"IF(OR(BK19=\"Kg\",BK19=\"Lb\",BK19=\"gr\",BK19=\"Oz\"),\"gr\",\"\")","v":""},{"$f":"IF(OR(BK19=\"L\",BK19=\"ml\"),\"ml\",\"\")","v":""},{"$f":"IF(OR(BK19=\"Panal\",BK19=\"u\"),\"u\",\"\")","v":""},{"$f":"IF(AND(BG19=\"gr\",BL19=\"gr\"),BJ19,0)","v":0},{"$f":"IF(AND(BH19=\"ml\",BM19=\"ml\"),BJ19,0)","v":0},{"$f":"IF(AND(BI19=\"u\",BN19=\"u\"),BJ19,0)","v":0},{"$f":"SUM(BO19:BQ19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,3,{"$f":"IF(Inventario!F13=\"Lb\",Inventario!E13*'Und. Conversion'!AZ21,0)","v":0},null,{"$f":"IF(Inventario!J13=\"Lb\",Inventario!I13*'Und. Conversion'!AZ20,0)","v":0},0,{"$f":"Inventario!J13","v":0},{"$f":"IF(OR(BF20=\"Kg\",BF20=\"Lb\",BF20=\"gr\",BF20=\"Oz\"),\"gr\",\"\")","v":""},"","",0,{"$f":"Inventario!F13","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,4,{"$f":"IF(Inventario!F14=\"Lb\",Inventario!E14*'Und. Conversion'!AZ22,0)","v":0},null,{"$f":"IF(Inventario!J14=\"Lb\",Inventario!I14*'Und. Conversion'!AZ21,0)","v":0},0,{"$f":"Inventario!J14","v":0},"","","",0,{"$f":"Inventario!F14","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,5,{"$f":"IF(Inventario!F15=\"Lb\",Inventario!E15*'Und. Conversion'!AZ23,0)","v":0},null,{"$f":"IF(Inventario!J15=\"Lb\",Inventario!I15*'Und. Conversion'!AZ22,0)","v":0},0,{"$f":"Inventario!J15","v":0},"","","",0,{"$f":"Inventario!F15","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,6,{"$f":"IF(Inventario!F16=\"Lb\",Inventario!E16*'Und. Conversion'!AZ24,0)","v":0},null,{"$f":"IF(Inventario!J16=\"Lb\",Inventario!I16*'Und. Conversion'!AZ23,0)","v":0},0,{"$f":"Inventario!J16","v":0},"","","",0,{"$f":"Inventario!F16","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,7,{"$f":"IF(Inventario!F17=\"Lb\",Inventario!E17*'Und. Conversion'!AZ25,0)","v":0},null,{"$f":"IF(Inventario!J17=\"Lb\",Inventario!I17*'Und. Conversion'!AZ24,0)","v":0},0,{"$f":"Inventario!J17","v":0},"","","",0,{"$f":"Inventario!F17","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,8,{"$f":"IF(Inventario!F18=\"Lb\",Inventario!E18*'Und. Conversion'!AZ26,0)","v":0},null,{"$f":"IF(Inventario!J18=\"Lb\",Inventario!I18*'Und. Conversion'!AZ25,0)","v":0},0,{"$f":"Inventario!J18","v":0},"","","",0,{"$f":"Inventario!F18","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,9,{"$f":"IF(Inventario!F19=\"Lb\",Inventario!E19*'Und. Conversion'!AZ27,0)","v":0},null,{"$f":"IF(Inventario!J19=\"Lb\",Inventario!I19*'Und. Conversion'!AZ26,0)","v":0},0,{"$f":"Inventario!J19","v":0},"","","",0,{"$f":"Inventario!F19","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,10,{"$f":"IF(Inventario!F20=\"Lb\",Inventario!E20*'Und. Conversion'!AZ28,0)","v":0},null,{"$f":"IF(Inventario!J20=\"Lb\",Inventario!I20*'Und. Conversion'!AZ27,0)","v":0},0,{"$f":"Inventario!J20","v":0},"","","",0,{"$f":"Inventario!F20","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,11,{"$f":"IF(Inventario!F21=\"Lb\",Inventario!E21*'Und. Conversion'!AZ29,0)","v":0},null,{"$f":"IF(Inventario!J21=\"Lb\",Inventario!I21*'Und. Conversion'!AZ28,0)","v":0},0,{"$f":"Inventario!J21","v":0},"","","",0,{"$f":"Inventario!F21","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,12,{"$f":"IF(Inventario!F22=\"Lb\",Inventario!E22*'Und. Conversion'!AZ30,0)","v":0},null,{"$f":"IF(Inventario!J22=\"Lb\",Inventario!I22*'Und. Conversion'!AZ29,0)","v":0},0,{"$f":"Inventario!J22","v":0},"","","",0,{"$f":"Inventario!F22","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,13,{"$f":"IF(Inventario!F23=\"Lb\",Inventario!E23*'Und. Conversion'!AZ31,0)","v":0},null,{"$f":"IF(Inventario!J23=\"Lb\",Inventario!I23*'Und. Conversion'!AZ30,0)","v":0},0,{"$f":"Inventario!J23","v":0},"","","",0,{"$f":"Inventario!F23","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,14,{"$f":"IF(Inventario!F24=\"Lb\",Inventario!E24*'Und. Conversion'!AZ32,0)","v":0},null,{"$f":"IF(Inventario!J24=\"Lb\",Inventario!I24*'Und. Conversion'!AZ31,0)","v":0},0,{"$f":"Inventario!J24","v":0},"","","",0,{"$f":"Inventario!F24","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,15,{"$f":"IF(Inventario!F25=\"Lb\",Inventario!E25*'Und. Conversion'!AZ33,0)","v":0},null,{"$f":"IF(Inventario!J25=\"Lb\",Inventario!I25*'Und. Conversion'!AZ32,0)","v":0},0,{"$f":"Inventario!J25","v":0},"","","",0,{"$f":"Inventario!F25","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,16,{"$f":"IF(Inventario!F26=\"Lb\",Inventario!E26*'Und. Conversion'!AZ34,0)","v":0},null,{"$f":"IF(Inventario!J26=\"Lb\",Inventario!I26*'Und. Conversion'!AZ33,0)","v":0},0,{"$f":"Inventario!J26","v":0},"","","",0,{"$f":"Inventario!F26","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,17,{"$f":"IF(Inventario!F27=\"Lb\",Inventario!E27*'Und. Conversion'!AZ35,0)","v":0},null,{"$f":"IF(Inventario!J27=\"Lb\",Inventario!I27*'Und. Conversion'!AZ34,0)","v":0},0,{"$f":"Inventario!J27","v":0},"","","",0,{"$f":"Inventario!F27","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,18,{"$f":"IF(Inventario!F28=\"Lb\",Inventario!E28*'Und. Conversion'!AZ36,0)","v":0},null,{"$f":"IF(Inventario!J28=\"Lb\",Inventario!I28*'Und. Conversion'!AZ35,0)","v":0},0,{"$f":"Inventario!J28","v":0},"","","",0,{"$f":"Inventario!F28","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,19,{"$f":"IF(Inventario!F29=\"Lb\",Inventario!E29*'Und. Conversion'!AZ37,0)","v":0},null,{"$f":"IF(Inventario!J29=\"Lb\",Inventario!I29*'Und. Conversion'!AZ36,0)","v":0},0,{"$f":"Inventario!J29","v":0},"","","",0,{"$f":"Inventario!F29","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,20,{"$f":"IF(Inventario!F30=\"Lb\",Inventario!E30*'Und. Conversion'!AZ38,0)","v":0},null,{"$f":"IF(Inventario!J30=\"Lb\",Inventario!I30*'Und. Conversion'!AZ37,0)","v":0},0,{"$f":"Inventario!J30","v":0},"","","",0,{"$f":"Inventario!F30","v":0},"","","",0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"$E$11","v":1000},1,{"$f":"IF(Inventario!F11=\"kg\",Inventario!E11*'Und. Conversion'!AZ38,0)","v":0},"KG",{"$f":"IF(Inventario!J11=\"Kg\",Inventario!I11*'Und. Conversion'!AZ38,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$11","v":1000},2,{"$f":"IF(Inventario!F12=\"kg\",Inventario!E12*'Und. Conversion'!AZ39,0)","v":0},null,{"$f":"IF(Inventario!J12=\"Kg\",Inventario!I12*'Und. Conversion'!AZ39,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,3,{"$f":"IF(Inventario!F13=\"kg\",Inventario!E13*'Und. Conversion'!AZ40,0)","v":0},null,{"$f":"IF(Inventario!J13=\"Kg\",Inventario!I13*'Und. Conversion'!AZ40,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,4,{"$f":"IF(Inventario!F14=\"kg\",Inventario!E14*'Und. Conversion'!AZ41,0)","v":0},null,{"$f":"IF(Inventario!J14=\"Kg\",Inventario!I14*'Und. Conversion'!AZ41,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,5,{"$f":"IF(Inventario!F15=\"kg\",Inventario!E15*'Und. Conversion'!AZ42,0)","v":0},null,{"$f":"IF(Inventario!J15=\"Kg\",Inventario!I15*'Und. Conversion'!AZ42,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,6,{"$f":"IF(Inventario!F16=\"kg\",Inventario!E16*'Und. Conversion'!AZ43,0)","v":0},null,{"$f":"IF(Inventario!J16=\"Kg\",Inventario!I16*'Und. Conversion'!AZ43,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,7,{"$f":"IF(Inventario!F17=\"kg\",Inventario!E17*'Und. Conversion'!AZ44,0)","v":0},null,{"$f":"IF(Inventario!J17=\"Kg\",Inventario!I17*'Und. Conversion'!AZ44,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,8,{"$f":"IF(Inventario!F18=\"kg\",Inventario!E18*'Und. Conversion'!AZ45,0)","v":0},null,{"$f":"IF(Inventario!J18=\"Kg\",Inventario!I18*'Und. Conversion'!AZ45,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,9,{"$f":"IF(Inventario!F19=\"kg\",Inventario!E19*'Und. Conversion'!AZ46,0)","v":0},null,{"$f":"IF(Inventario!J19=\"Kg\",Inventario!I19*'Und. Conversion'!AZ46,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,10,{"$f":"IF(Inventario!F20=\"kg\",Inventario!E20*'Und. Conversion'!AZ47,0)","v":0},null,{"$f":"IF(Inventario!J20=\"Kg\",Inventario!I20*'Und. Conversion'!AZ47,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,11,{"$f":"IF(Inventario!F21=\"kg\",Inventario!E21*'Und. Conversion'!AZ48,0)","v":0},null,{"$f":"IF(Inventario!J21=\"Kg\",Inventario!I21*'Und. Conversion'!AZ48,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,12,{"$f":"IF(Inventario!F22=\"kg\",Inventario!E22*'Und. Conversion'!AZ49,0)","v":0},null,{"$f":"IF(Inventario!J22=\"Kg\",Inventario!I22*'Und. Conversion'!AZ49,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,13,{"$f":"IF(Inventario!F23=\"kg\",Inventario!E23*'Und. Conversion'!AZ50,0)","v":0},null,{"$f":"IF(Inventario!J23=\"Kg\",Inventario!I23*'Und. Conversion'!AZ50,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,14,{"$f":"IF(Inventario!F24=\"kg\",Inventario!E24*'Und. Conversion'!AZ51,0)","v":0},null,{"$f":"IF(Inventario!J24=\"Kg\",Inventario!I24*'Und. Conversion'!AZ51,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,15,{"$f":"IF(Inventario!F25=\"kg\",Inventario!E25*'Und. Conversion'!AZ52,0)","v":0},null,{"$f":"IF(Inventario!J25=\"Kg\",Inventario!I25*'Und. Conversion'!AZ52,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,16,{"$f":"IF(Inventario!F26=\"kg\",Inventario!E26*'Und. Conversion'!AZ53,0)","v":0},null,{"$f":"IF(Inventario!J26=\"Kg\",Inventario!I26*'Und. Conversion'!AZ53,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,17,{"$f":"IF(Inventario!F27=\"kg\",Inventario!E27*'Und. Conversion'!AZ54,0)","v":0},null,{"$f":"IF(Inventario!J27=\"Kg\",Inventario!I27*'Und. Conversion'!AZ54,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,18,{"$f":"IF(Inventario!F28=\"kg\",Inventario!E28*'Und. Conversion'!AZ55,0)","v":0},null,{"$f":"IF(Inventario!J28=\"Kg\",Inventario!I28*'Und. Conversion'!AZ55,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,19,{"$f":"IF(Inventario!F29=\"kg\",Inventario!E29*'Und. Conversion'!AZ56,0)","v":0},null,{"$f":"IF(Inventario!J29=\"Kg\",Inventario!I29*'Und. Conversion'!AZ56,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,20,{"$f":"IF(Inventario!F30=\"kg\",Inventario!E30*'Und. Conversion'!AZ57,0)","v":0},null,{"$f":"IF(Inventario!J30=\"Kg\",Inventario!I30*'Und. Conversion'!AZ57,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$12","v":28.34},1,{"$f":"IF(Inventario!F11=\"Oz\",Inventario!E11*'Und. Conversion'!AZ58,0)","v":0},"OZ",{"$f":"IF(Inventario!J11=\"Oz\",Inventario!I11*'Und. Conversion'!AZ58,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$12","v":28.34},2,{"$f":"IF(Inventario!F12=\"Oz\",Inventario!E12*'Und. Conversion'!AZ59,0)","v":0},null,{"$f":"IF(Inventario!J12=\"Oz\",Inventario!I12*'Und. Conversion'!AZ59,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,3,{"$f":"IF(Inventario!F13=\"Oz\",Inventario!E13*'Und. Conversion'!AZ60,0)","v":0},null,{"$f":"IF(Inventario!J13=\"Oz\",Inventario!I13*'Und. Conversion'!AZ60,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,4,{"$f":"IF(Inventario!F14=\"Oz\",Inventario!E14*'Und. Conversion'!AZ61,0)","v":0},null,{"$f":"IF(Inventario!J14=\"Oz\",Inventario!I14*'Und. Conversion'!AZ61,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,5,{"$f":"IF(Inventario!F15=\"Oz\",Inventario!E15*'Und. Conversion'!AZ62,0)","v":0},null,{"$f":"IF(Inventario!J15=\"Oz\",Inventario!I15*'Und. Conversion'!AZ62,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,6,{"$f":"IF(Inventario!F16=\"Oz\",Inventario!E16*'Und. Conversion'!AZ63,0)","v":0},null,{"$f":"IF(Inventario!J16=\"Oz\",Inventario!I16*'Und. Conversion'!AZ63,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,7,{"$f":"IF(Inventario!F17=\"Oz\",Inventario!E17*'Und. Conversion'!AZ64,0)","v":0},null,{"$f":"IF(Inventario!J17=\"Oz\",Inventario!I17*'Und. Conversion'!AZ64,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,8,{"$f":"IF(Inventario!F18=\"Oz\",Inventario!E18*'Und. Conversion'!AZ65,0)","v":0},null,{"$f":"IF(Inventario!J18=\"Oz\",Inventario!I18*'Und. Conversion'!AZ65,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,9,{"$f":"IF(Inventario!F19=\"Oz\",Inventario!E19*'Und. Conversion'!AZ66,0)","v":0},null,{"$f":"IF(Inventario!J19=\"Oz\",Inventario!I19*'Und. Conversion'!AZ66,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,10,{"$f":"IF(Inventario!F20=\"Oz\",Inventario!E20*'Und. Conversion'!AZ67,0)","v":0},null,{"$f":"IF(Inventario!J20=\"Oz\",Inventario!I20*'Und. Conversion'!AZ67,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,11,{"$f":"IF(Inventario!F21=\"Oz\",Inventario!E21*'Und. Conversion'!AZ68,0)","v":0},null,{"$f":"IF(Inventario!J21=\"Oz\",Inventario!I21*'Und. Conversion'!AZ68,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,12,{"$f":"IF(Inventario!F22=\"Oz\",Inventario!E22*'Und. Conversion'!AZ69,0)","v":0},null,{"$f":"IF(Inventario!J22=\"Oz\",Inventario!I22*'Und. Conversion'!AZ69,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,13,{"$f":"IF(Inventario!F23=\"Oz\",Inventario!E23*'Und. Conversion'!AZ70,0)","v":0},null,{"$f":"IF(Inventario!J23=\"Oz\",Inventario!I23*'Und. Conversion'!AZ70,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,14,{"$f":"IF(Inventario!F24=\"Oz\",Inventario!E24*'Und. Conversion'!AZ71,0)","v":0},null,{"$f":"IF(Inventario!J24=\"Oz\",Inventario!I24*'Und. Conversion'!AZ71,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,15,{"$f":"IF(Inventario!F25=\"Oz\",Inventario!E25*'Und. Conversion'!AZ72,0)","v":0},null,{"$f":"IF(Inventario!J25=\"Oz\",Inventario!I25*'Und. Conversion'!AZ72,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,16,{"$f":"IF(Inventario!F26=\"Oz\",Inventario!E26*'Und. Conversion'!AZ73,0)","v":0},null,{"$f":"IF(Inventario!J26=\"Oz\",Inventario!I26*'Und. Conversion'!AZ73,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,17,{"$f":"IF(Inventario!F27=\"Oz\",Inventario!E27*'Und. Conversion'!AZ74,0)","v":0},null,{"$f":"IF(Inventario!J27=\"Oz\",Inventario!I27*'Und. Conversion'!AZ74,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,18,{"$f":"IF(Inventario!F28=\"Oz\",Inventario!E28*'Und. Conversion'!AZ75,0)","v":0},null,{"$f":"IF(Inventario!J28=\"Oz\",Inventario!I28*'Und. Conversion'!AZ75,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,19,{"$f":"IF(Inventario!F29=\"Oz\",Inventario!E29*'Und. Conversion'!AZ76,0)","v":0},null,{"$f":"IF(Inventario!J29=\"Oz\",Inventario!I29*'Und. Conversion'!AZ76,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28.34,20,{"$f":"IF(Inventario!F30=\"Oz\",Inventario!E30*'Und. Conversion'!AZ77,0)","v":0},null,{"$f":"IF(Inventario!J30=\"Oz\",Inventario!I30*'Und. Conversion'!AZ77,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$13","v":30},1,{"$f":"IF(Inventario!F11=\"Panal\",Inventario!E11*'Und. Conversion'!AZ78,0)","v":0},"PANAL",{"$f":"IF(Inventario!J11=\"Panal\",Inventario!I11*'Und. Conversion'!AZ78,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$13","v":30},2,{"$f":"IF(Inventario!F12=\"Panal\",Inventario!E12*'Und. Conversion'!AZ79,0)","v":0},null,{"$f":"IF(Inventario!J12=\"Panal\",Inventario!I12*'Und. Conversion'!AZ79,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,3,{"$f":"IF(Inventario!F13=\"Panal\",Inventario!E13*'Und. Conversion'!AZ80,0)","v":0},null,{"$f":"IF(Inventario!J13=\"Panal\",Inventario!I13*'Und. Conversion'!AZ80,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,4,{"$f":"IF(Inventario!F14=\"Panal\",Inventario!E14*'Und. Conversion'!AZ81,0)","v":0},null,{"$f":"IF(Inventario!J14=\"Panal\",Inventario!I14*'Und. Conversion'!AZ81,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,5,{"$f":"IF(Inventario!F15=\"Panal\",Inventario!E15*'Und. Conversion'!AZ82,0)","v":0},null,{"$f":"IF(Inventario!J15=\"Panal\",Inventario!I15*'Und. Conversion'!AZ82,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,6,{"$f":"IF(Inventario!F16=\"Panal\",Inventario!E16*'Und. Conversion'!AZ83,0)","v":0},null,{"$f":"IF(Inventario!J16=\"Panal\",Inventario!I16*'Und. Conversion'!AZ83,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,7,{"$f":"IF(Inventario!F17=\"Panal\",Inventario!E17*'Und. Conversion'!AZ84,0)","v":0},null,{"$f":"IF(Inventario!J17=\"Panal\",Inventario!I17*'Und. Conversion'!AZ84,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,8,{"$f":"IF(Inventario!F18=\"Panal\",Inventario!E18*'Und. Conversion'!AZ85,0)","v":0},null,{"$f":"IF(Inventario!J18=\"Panal\",Inventario!I18*'Und. Conversion'!AZ85,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,9,{"$f":"IF(Inventario!F19=\"Panal\",Inventario!E19*'Und. Conversion'!AZ86,0)","v":0},null,{"$f":"IF(Inventario!J19=\"Panal\",Inventario!I19*'Und. Conversion'!AZ86,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,10,{"$f":"IF(Inventario!F20=\"Panal\",Inventario!E20*'Und. Conversion'!AZ87,0)","v":0},null,{"$f":"IF(Inventario!J20=\"Panal\",Inventario!I20*'Und. Conversion'!AZ87,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,11,{"$f":"IF(Inventario!F21=\"Panal\",Inventario!E21*'Und. Conversion'!AZ88,0)","v":0},null,{"$f":"IF(Inventario!J21=\"Panal\",Inventario!I21*'Und. Conversion'!AZ88,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,12,{"$f":"IF(Inventario!F22=\"Panal\",Inventario!E22*'Und. Conversion'!AZ89,0)","v":0},null,{"$f":"IF(Inventario!J22=\"Panal\",Inventario!I22*'Und. Conversion'!AZ89,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,13,{"$f":"IF(Inventario!F23=\"Panal\",Inventario!E23*'Und. Conversion'!AZ90,0)","v":0},null,{"$f":"IF(Inventario!J23=\"Panal\",Inventario!I23*'Und. Conversion'!AZ90,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,14,{"$f":"IF(Inventario!F24=\"Panal\",Inventario!E24*'Und. Conversion'!AZ91,0)","v":0},null,{"$f":"IF(Inventario!J24=\"Panal\",Inventario!I24*'Und. Conversion'!AZ91,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,15,{"$f":"IF(Inventario!F25=\"Panal\",Inventario!E25*'Und. Conversion'!AZ92,0)","v":0},null,{"$f":"IF(Inventario!J25=\"Panal\",Inventario!I25*'Und. Conversion'!AZ92,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,16,{"$f":"IF(Inventario!F26=\"Panal\",Inventario!E26*'Und. Conversion'!AZ93,0)","v":0},null,{"$f":"IF(Inventario!J26=\"Panal\",Inventario!I26*'Und. Conversion'!AZ93,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,17,{"$f":"IF(Inventario!F27=\"Panal\",Inventario!E27*'Und. Conversion'!AZ94,0)","v":0},null,{"$f":"IF(Inventario!J27=\"Panal\",Inventario!I27*'Und. Conversion'!AZ94,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,18,{"$f":"IF(Inventario!F28=\"Panal\",Inventario!E28*'Und. Conversion'!AZ95,0)","v":0},null,{"$f":"IF(Inventario!J28=\"Panal\",Inventario!I28*'Und. Conversion'!AZ95,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,19,{"$f":"IF(Inventario!F29=\"Panal\",Inventario!E29*'Und. Conversion'!AZ96,0)","v":0},null,{"$f":"IF(Inventario!J29=\"Panal\",Inventario!I29*'Und. Conversion'!AZ96,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,20,{"$f":"IF(Inventario!F30=\"Panal\",Inventario!E30*'Und. Conversion'!AZ97,0)","v":0},"L",{"$f":"IF(Inventario!J30=\"Panal\",Inventario!I30*'Und. Conversion'!AZ97,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$14","v":1000},1,{"$f":"IF(Inventario!F11=\"L\",Inventario!E11*'Und. Conversion'!AZ98,0)","v":0},null,{"$f":"IF(Inventario!J11=\"L\",Inventario!I11*'Und. Conversion'!AZ98,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$14","v":1000},2,{"$f":"IF(Inventario!F12=\"L\",Inventario!E12*'Und. Conversion'!AZ99,0)","v":0},null,{"$f":"IF(Inventario!J12=\"L\",Inventario!I12*'Und. Conversion'!AZ99,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,3,{"$f":"IF(Inventario!F13=\"L\",Inventario!E13*'Und. Conversion'!AZ100,0)","v":0},null,{"$f":"IF(Inventario!J13=\"L\",Inventario!I13*'Und. Conversion'!AZ100,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,4,{"$f":"IF(Inventario!F14=\"L\",Inventario!E14*'Und. Conversion'!AZ101,0)","v":0},null,{"$f":"IF(Inventario!J14=\"L\",Inventario!I14*'Und. Conversion'!AZ101,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,5,{"$f":"IF(Inventario!F15=\"L\",Inventario!E15*'Und. Conversion'!AZ102,0)","v":0},null,{"$f":"IF(Inventario!J15=\"L\",Inventario!I15*'Und. Conversion'!AZ102,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,6,{"$f":"IF(Inventario!F16=\"L\",Inventario!E16*'Und. Conversion'!AZ103,0)","v":0},null,{"$f":"IF(Inventario!J16=\"L\",Inventario!I16*'Und. Conversion'!AZ103,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,7,{"$f":"IF(Inventario!F17=\"L\",Inventario!E17*'Und. Conversion'!AZ104,0)","v":0},null,{"$f":"IF(Inventario!J17=\"L\",Inventario!I17*'Und. Conversion'!AZ104,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,8,{"$f":"IF(Inventario!F18=\"L\",Inventario!E18*'Und. Conversion'!AZ105,0)","v":0},null,{"$f":"IF(Inventario!J18=\"L\",Inventario!I18*'Und. Conversion'!AZ105,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,9,{"$f":"IF(Inventario!F19=\"L\",Inventario!E19*'Und. Conversion'!AZ106,0)","v":0},null,{"$f":"IF(Inventario!J19=\"L\",Inventario!I19*'Und. Conversion'!AZ106,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,10,{"$f":"IF(Inventario!F20=\"L\",Inventario!E20*'Und. Conversion'!AZ107,0)","v":0},null,{"$f":"IF(Inventario!J20=\"L\",Inventario!I20*'Und. Conversion'!AZ107,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,11,{"$f":"IF(Inventario!F21=\"L\",Inventario!E21*'Und. Conversion'!AZ108,0)","v":0},null,{"$f":"IF(Inventario!J21=\"L\",Inventario!I21*'Und. Conversion'!AZ108,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,12,{"$f":"IF(Inventario!F22=\"L\",Inventario!E22*'Und. Conversion'!AZ109,0)","v":0},null,{"$f":"IF(Inventario!J22=\"L\",Inventario!I22*'Und. Conversion'!AZ109,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,13,{"$f":"IF(Inventario!F23=\"L\",Inventario!E23*'Und. Conversion'!AZ110,0)","v":0},null,{"$f":"IF(Inventario!J23=\"L\",Inventario!I23*'Und. Conversion'!AZ110,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,14,{"$f":"IF(Inventario!F24=\"L\",Inventario!E24*'Und. Conversion'!AZ111,0)","v":0},null,{"$f":"IF(Inventario!J24=\"L\",Inventario!I24*'Und. Conversion'!AZ111,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,15,{"$f":"IF(Inventario!F25=\"L\",Inventario!E25*'Und. Conversion'!AZ112,0)","v":0},null,{"$f":"IF(Inventario!J25=\"L\",Inventario!I25*'Und. Conversion'!AZ112,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,16,{"$f":"IF(Inventario!F26=\"L\",Inventario!E26*'Und. Conversion'!AZ113,0)","v":0},null,{"$f":"IF(Inventario!J26=\"L\",Inventario!I26*'Und. Conversion'!AZ113,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,17,{"$f":"IF(Inventario!F27=\"L\",Inventario!E27*'Und. Conversion'!AZ114,0)","v":0},null,{"$f":"IF(Inventario!J27=\"L\",Inventario!I27*'Und. Conversion'!AZ114,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,18,{"$f":"IF(Inventario!F28=\"L\",Inventario!E28*'Und. Conversion'!AZ115,0)","v":0},null,{"$f":"IF(Inventario!J28=\"L\",Inventario!I28*'Und. Conversion'!AZ115,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,19,{"$f":"IF(Inventario!F29=\"L\",Inventario!E29*'Und. Conversion'!AZ116,0)","v":0},null,{"$f":"IF(Inventario!J29=\"L\",Inventario!I29*'Und. Conversion'!AZ116,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,20,{"$f":"IF(Inventario!F30=\"L\",Inventario!E30*'Und. Conversion'!AZ117,0)","v":0},null,{"$f":"IF(Inventario!J30=\"L\",Inventario!I30*'Und. Conversion'!AZ117,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$15","v":1E-3},1,{"$f":"IF(Inventario!F11=\"gr\",Inventario!E11*1,0)","v":0},"gr",{"$f":"IF(Inventario!J11=\"gr\",Inventario!I11*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$15","v":1E-3},2,{"$f":"IF(Inventario!F12=\"gr\",Inventario!E12*1,0)","v":0},null,{"$f":"IF(Inventario!J12=\"gr\",Inventario!I12*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,3,{"$f":"IF(Inventario!F13=\"gr\",Inventario!E13*1,0)","v":0},null,{"$f":"IF(Inventario!J13=\"gr\",Inventario!I13*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,4,{"$f":"IF(Inventario!F14=\"gr\",Inventario!E14*1,0)","v":0},null,{"$f":"IF(Inventario!J14=\"gr\",Inventario!I14*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,5,{"$f":"IF(Inventario!F15=\"gr\",Inventario!E15*1,0)","v":0},null,{"$f":"IF(Inventario!J15=\"gr\",Inventario!I15*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,6,{"$f":"IF(Inventario!F16=\"gr\",Inventario!E16*1,0)","v":0},null,{"$f":"IF(Inventario!J16=\"gr\",Inventario!I16*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,7,{"$f":"IF(Inventario!F17=\"gr\",Inventario!E17*1,0)","v":0},null,{"$f":"IF(Inventario!J17=\"gr\",Inventario!I17*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,8,{"$f":"IF(Inventario!F18=\"gr\",Inventario!E18*1,0)","v":0},null,{"$f":"IF(Inventario!J18=\"gr\",Inventario!I18*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,9,{"$f":"IF(Inventario!F19=\"gr\",Inventario!E19*1,0)","v":0},null,{"$f":"IF(Inventario!J19=\"gr\",Inventario!I19*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,10,{"$f":"IF(Inventario!F20=\"gr\",Inventario!E20*1,0)","v":0},null,{"$f":"IF(Inventario!J20=\"gr\",Inventario!I20*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,11,{"$f":"IF(Inventario!F21=\"gr\",Inventario!E21*1,0)","v":0},null,{"$f":"IF(Inventario!J21=\"gr\",Inventario!I21*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,12,{"$f":"IF(Inventario!F22=\"gr\",Inventario!E22*1,0)","v":0},null,{"$f":"IF(Inventario!J22=\"gr\",Inventario!I22*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,13,{"$f":"IF(Inventario!F23=\"gr\",Inventario!E23*1,0)","v":0},null,{"$f":"IF(Inventario!J23=\"gr\",Inventario!I23*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,14,{"$f":"IF(Inventario!F24=\"gr\",Inventario!E24*1,0)","v":0},null,{"$f":"IF(Inventario!J24=\"gr\",Inventario!I24*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,15,{"$f":"IF(Inventario!F25=\"gr\",Inventario!E25*1,0)","v":0},null,{"$f":"IF(Inventario!J25=\"gr\",Inventario!I25*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,16,{"$f":"IF(Inventario!F26=\"gr\",Inventario!E26*1,0)","v":0},null,{"$f":"IF(Inventario!J26=\"gr\",Inventario!I26*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,17,{"$f":"IF(Inventario!F27=\"gr\",Inventario!E27*1,0)","v":0},null,{"$f":"IF(Inventario!J27=\"gr\",Inventario!I27*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,18,{"$f":"IF(Inventario!F28=\"gr\",Inventario!E28*1,0)","v":0},null,{"$f":"IF(Inventario!J28=\"gr\",Inventario!I28*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,19,{"$f":"IF(Inventario!F29=\"gr\",Inventario!E29*1,0)","v":0},null,{"$f":"IF(Inventario!J29=\"gr\",Inventario!I29*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,20,{"$f":"IF(Inventario!F30=\"gr\",Inventario!E30*1,0)","v":0},null,{"$f":"IF(Inventario!J30=\"gr\",Inventario!I30*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$16","v":1E-3},1,{"$f":"IF(Inventario!F11=\"ml\",Inventario!E11*1,0)","v":0},"ml",{"$f":"IF(Inventario!J11=\"ml\",Inventario!I11*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$16","v":1E-3},2,{"$f":"IF(Inventario!F12=\"ml\",Inventario!E12*1,0)","v":0},null,{"$f":"IF(Inventario!J12=\"ml\",Inventario!I12*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,3,{"$f":"IF(Inventario!F13=\"ml\",Inventario!E13*1,0)","v":0},null,{"$f":"IF(Inventario!J13=\"ml\",Inventario!I13*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,4,{"$f":"IF(Inventario!F14=\"ml\",Inventario!E14*1,0)","v":0},null,{"$f":"IF(Inventario!J14=\"ml\",Inventario!I14*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,5,{"$f":"IF(Inventario!F15=\"ml\",Inventario!E15*1,0)","v":0},null,{"$f":"IF(Inventario!J15=\"ml\",Inventario!I15*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,6,{"$f":"IF(Inventario!F16=\"ml\",Inventario!E16*1,0)","v":0},null,{"$f":"IF(Inventario!J16=\"ml\",Inventario!I16*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,7,{"$f":"IF(Inventario!F17=\"ml\",Inventario!E17*1,0)","v":0},null,{"$f":"IF(Inventario!J17=\"ml\",Inventario!I17*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,8,{"$f":"IF(Inventario!F18=\"ml\",Inventario!E18*1,0)","v":0},null,{"$f":"IF(Inventario!J18=\"ml\",Inventario!I18*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,9,{"$f":"IF(Inventario!F19=\"ml\",Inventario!E19*1,0)","v":0},null,{"$f":"IF(Inventario!J19=\"ml\",Inventario!I19*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,10,{"$f":"IF(Inventario!F20=\"ml\",Inventario!E20*1,0)","v":0},null,{"$f":"IF(Inventario!J20=\"ml\",Inventario!I20*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,11,{"$f":"IF(Inventario!F21=\"ml\",Inventario!E21*1,0)","v":0},null,{"$f":"IF(Inventario!J21=\"ml\",Inventario!I21*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,12,{"$f":"IF(Inventario!F22=\"ml\",Inventario!E22*1,0)","v":0},null,{"$f":"IF(Inventario!J22=\"ml\",Inventario!I22*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,13,{"$f":"IF(Inventario!F23=\"ml\",Inventario!E23*1,0)","v":0},null,{"$f":"IF(Inventario!J23=\"ml\",Inventario!I23*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,14,{"$f":"IF(Inventario!F24=\"ml\",Inventario!E24*1,0)","v":0},null,{"$f":"IF(Inventario!J24=\"ml\",Inventario!I24*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,15,{"$f":"IF(Inventario!F25=\"ml\",Inventario!E25*1,0)","v":0},null,{"$f":"IF(Inventario!J25=\"ml\",Inventario!I25*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,16,{"$f":"IF(Inventario!F26=\"ml\",Inventario!E26*1,0)","v":0},null,{"$f":"IF(Inventario!J26=\"ml\",Inventario!I26*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,17,{"$f":"IF(Inventario!F27=\"ml\",Inventario!E27*1,0)","v":0},null,{"$f":"IF(Inventario!J27=\"ml\",Inventario!I27*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,18,{"$f":"IF(Inventario!F28=\"ml\",Inventario!E28*1,0)","v":0},null,{"$f":"IF(Inventario!J28=\"ml\",Inventario!I28*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,19,{"$f":"IF(Inventario!F29=\"ml\",Inventario!E29*1,0)","v":0},null,{"$f":"IF(Inventario!J29=\"ml\",Inventario!I29*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1E-3,20,{"$f":"IF(Inventario!F30=\"ml\",Inventario!E30*1,0)","v":0},null,{"$f":"IF(Inventario!J30=\"ml\",Inventario!I30*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$17","v":1},1,{"$f":"IF(Inventario!F11=\"u\",Inventario!E11*1,0)","v":0},"und",{"$f":"IF(Inventario!J11=\"u\",Inventario!I11*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$E$17","v":1},2,{"$f":"IF(Inventario!F12=\"u\",Inventario!E12*1,0)","v":0},null,{"$f":"IF(Inventario!J12=\"u\",Inventario!I12*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,3,{"$f":"IF(Inventario!F13=\"u\",Inventario!E13*1,0)","v":0},null,{"$f":"IF(Inventario!J13=\"u\",Inventario!I13*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,4,{"$f":"IF(Inventario!F14=\"u\",Inventario!E14*1,0)","v":0},null,{"$f":"IF(Inventario!J14=\"u\",Inventario!I14*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5,{"$f":"IF(Inventario!F15=\"u\",Inventario!E15*1,0)","v":0},null,{"$f":"IF(Inventario!J15=\"u\",Inventario!I15*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,6,{"$f":"IF(Inventario!F16=\"u\",Inventario!E16*1,0)","v":0},null,{"$f":"IF(Inventario!J16=\"u\",Inventario!I16*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,7,{"$f":"IF(Inventario!F17=\"u\",Inventario!E17*1,0)","v":0},null,{"$f":"IF(Inventario!J17=\"u\",Inventario!I17*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,8,{"$f":"IF(Inventario!F18=\"u\",Inventario!E18*1,0)","v":0},null,{"$f":"IF(Inventario!J18=\"u\",Inventario!I18*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,9,{"$f":"IF(Inventario!F19=\"u\",Inventario!E19*1,0)","v":0},null,{"$f":"IF(Inventario!J19=\"u\",Inventario!I19*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,10,{"$f":"IF(Inventario!F20=\"u\",Inventario!E20*1,0)","v":0},null,{"$f":"IF(Inventario!J20=\"u\",Inventario!I20*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,11,{"$f":"IF(Inventario!F21=\"u\",Inventario!E21*1,0)","v":0},null,{"$f":"IF(Inventario!J21=\"u\",Inventario!I21*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,12,{"$f":"IF(Inventario!F22=\"u\",Inventario!E22*1,0)","v":0},null,{"$f":"IF(Inventario!J22=\"u\",Inventario!I22*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,13,{"$f":"IF(Inventario!F23=\"u\",Inventario!E23*1,0)","v":0},null,{"$f":"IF(Inventario!J23=\"u\",Inventario!I23*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,14,{"$f":"IF(Inventario!F24=\"u\",Inventario!E24*1,0)","v":0},null,{"$f":"IF(Inventario!J24=\"u\",Inventario!I24*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,15,{"$f":"IF(Inventario!F25=\"u\",Inventario!E25*1,0)","v":0},null,{"$f":"IF(Inventario!J25=\"u\",Inventario!I25*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,16,{"$f":"IF(Inventario!F26=\"u\",Inventario!E26*1,0)","v":0},null,{"$f":"IF(Inventario!J26=\"u\",Inventario!I26*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,17,{"$f":"IF(Inventario!F27=\"u\",Inventario!E27*1,0)","v":0},null,{"$f":"IF(Inventario!J27=\"u\",Inventario!I27*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,18,{"$f":"IF(Inventario!F28=\"u\",Inventario!E28*1,0)","v":0},null,{"$f":"IF(Inventario!J28=\"u\",Inventario!I28*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,19,{"$f":"IF(Inventario!F29=\"u\",Inventario!E29*1,0)","v":0},null,{"$f":"IF(Inventario!J29=\"u\",Inventario!I29*1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,20,{"$f":"IF(Inventario!F30=\"u\",Inventario!E30*1,0)","v":0},null,{"$f":"IF(Inventario!J30=\"u\",Inventario!I30*1,0)","v":0}]

{"sheet":"Empresa","index":2,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,3,1,10],[17,14,21,17],[29,11,29,13],[7,3,7,4],[10,2,10,4]]}
[]
[null,null,null,"Calcular el costo de un producto   "]
[null,"www.asesoriasmipyme.com",null,"Cuando no se tiene claro los valores unitarios pero se conoce el costo de producir una cantidad específica."]
[]
[]
[]
[]
[null,null,"Empresa:"]
[]
[]
[null,null,"Detalles de produccion"]
[null,null,"Producto","cantidad","Frecuencia "]
[null,null,null,null,null,null,null,{"$f":"IF(AND(D13<2,D13<>\"\"),\"Debe ingresar valores mayores a 1\",\"\")","v":""}]
[]
[]
[]
[null,null,null,null," M.O.Directa","salario","CIF","Cuantia ",{"$f":"E13","v":0},"Mod- Dev."]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$13=\"Diario\",H18/30,IF($E$13 =\"Quincenal\",(H18/30)*15,IF($E$13=\"Mensual\",(H18*1),0)))","v":0},{"$f":"IF($E$13=\"Diario\",F18/30,IF($E$13 =\"Quincenal\",(F18/30)*15,IF($E$13=\"Mensual\",(F18*1),0)))","v":0},null,null,null,null," Recuerda ingresa la informacion mensual."]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$13=\"Diario\",H19/30,IF($E$13 =\"Quincenal\",(H19/30)*15,IF($E$13=\"Mensual\",(H19*1),0)))","v":0},{"$f":"IF($E$13=\"Diario\",F19/30,IF($E$13 =\"Quincenal\",(F19/30)*15,IF($E$13=\"Mensual\",(F19*1),0)))","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF($E$13=\"Diario\",H28/30,IF($E$13 =\"Quincenal\",(H28/30)*15,IF($E$13=\"Mensual\",(H28*1),0)))","v":0},{"$f":"IF($E$13=\"Diario\",F28/30,IF($E$13 =\"Quincenal\",(F28/30)*15,IF($E$13=\"Mensual\",(F28*1),0)))","v":0}]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0]

{"sheet":"Inventario","index":3,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[10,18,11,20],[34,3,35,5],[1,4,1,11],[2,6,2,9]]}
[]
[null,null,null,null,"Introduce la información de la materia prima"]
[null,null,null,null,null,null,"y las compras para el primer periodo."]
[null,null,"www.asesoriasmipyme.com"]
[]
[null,null,{"$f":"Empresa!C13","v":0}]
[null,null,"Producción",{"$f":"Empresa!D13","v":0}]
[]
[]
[null,null,"N°","Ingredientes",{"$f":"CONCATENATE(\"Cantidad para cada \",D7)","v":"Cantidad para cada 0"},"Unidad de Medida",{"$f":"CONCATENATE(\"Valor Unitario por cada \",D7)","v":"Valor Unitario por cada 0"},"Inventario","Cantidad","Unidad de medida","Valor Total","Existencia inicial ","Existencia minima a mantener","Existencia Reserva","Unidad de medida","Iva",{"$f":"'Und. Conversion'!G10","v":0.16}]
[null,null,{"$f":"IF(D11=\"\",\"-\",1)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R12","v":0},{"$f":"IF(D11=\"\",\"-\",D11)","v":"-"},null,null,null,{"$f":"IF(AND('Und. Conversion'!BR18=0,I11>0),\"Error en la unidad de medida\",'Und. Conversion'!BR18)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB18:BB177,'Und. Conversion'!BA18:BA177,'Und. Conversion'!BA18)))","v":0},{"$f":"L11-M11","v":0},{"$f":"CONCATENATE('Und. Conversion'!BG18,'Und. Conversion'!BH18,'Und. Conversion'!BI18)","v":""},{"$f":"IF(Q11=\"Si\",$Q$10*K11,\"\")","v":""},null,null,"Compras para el primer periodo"]
[null,null,{"$f":"IF(D12=\"\",\"-\",2)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R13","v":0},{"$f":"IF(D12=\"\",\"-\",D12)","v":"-"},null,null,null,{"$f":"IF(AND('Und. Conversion'!BR19=0,I12>0),\"Error en la unidad de medida\",'Und. Conversion'!BR19)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB19:BB178,'Und. Conversion'!BA19:BA178,'Und. Conversion'!BA19)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG19,'Und. Conversion'!BH19,'Und. Conversion'!BI19)","v":""},""]
[null,null,{"$f":"IF(D13=\"\",\"-\",3)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R14","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR20=0,I13>0),\"Error en la unidad de medida\",'Und. Conversion'!BR20)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB20:BB179,'Und. Conversion'!BA20:BA179,'Und. Conversion'!BA20)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG20,'Und. Conversion'!BH20,'Und. Conversion'!BI20)","v":""},""]
[null,null,{"$f":"IF(D14=\"\",\"-\",4)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R15","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR21=0,I14>0),\"Error en la unidad de medida\",'Und. Conversion'!BR21)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB21:BB180,'Und. Conversion'!BA21:BA180,'Und. Conversion'!BA21)))","v":0},null,{"$f":"CONCATENATE('Und. Conversion'!BG21,'Und. Conversion'!BH21,'Und. Conversion'!BI21)","v":""},""]
[null,null,{"$f":"IF(D15=\"\",\"-\",5)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R16","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR22=0,I15>0),\"Error en la unidad de medida\",'Und. Conversion'!BR22)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB22:BB181,'Und. Conversion'!BA22:BA181,'Und. Conversion'!BA22)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG22,'Und. Conversion'!BH22,'Und. Conversion'!BI22)","v":""},""]
[null,null,{"$f":"IF(D16=\"\",\"-\",6)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R17","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR23=0,I16>0),\"Error en la unidad de medida\",'Und. Conversion'!BR23)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB23:BB182,'Und. Conversion'!BA23:BA182,'Und. Conversion'!BA23)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG23,'Und. Conversion'!BH23,'Und. Conversion'!BI23)","v":""},""]
[null,null,{"$f":"IF(D17=\"\",\"-\",7)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R18","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR24=0,I17>0),\"Error en la unidad de medida\",'Und. Conversion'!BR24)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB24:BB183,'Und. Conversion'!BA24:BA183,'Und. Conversion'!BA24)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG24,'Und. Conversion'!BH24,'Und. Conversion'!BI24)","v":""},""]
[null,null,{"$f":"IF(D18=\"\",\"-\",8)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R19","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR25=0,I18>0),\"Error en la unidad de medida\",'Und. Conversion'!BR25)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB25:BB184,'Und. Conversion'!BA25:BA184,'Und. Conversion'!BA25)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG25,'Und. Conversion'!BH25,'Und. Conversion'!BI25)","v":""},""]
[null,null,{"$f":"IF(D19=\"\",\"-\",9)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R20","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR26=0,I19>0),\"Error en la unidad de medida\",'Und. Conversion'!BR26)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB26:BB185,'Und. Conversion'!BA26:BA185,'Und. Conversion'!BA26)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG26,'Und. Conversion'!BH26,'Und. Conversion'!BI26)","v":""},""]
[null,null,{"$f":"IF(D20=\"\",\"-\",10)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R21","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR27=0,I20>0),\"Error en la unidad de medida\",'Und. Conversion'!BR27)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB27:BB186,'Und. Conversion'!BA27:BA186,'Und. Conversion'!BA27)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG27,'Und. Conversion'!BH27,'Und. Conversion'!BI27)","v":""},""]
[null,null,{"$f":"IF(D21=\"\",\"-\",11)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R22","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR28=0,I21>0),\"Error en la unidad de medida\",'Und. Conversion'!BR28)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB28:BB187,'Und. Conversion'!BA28:BA187,'Und. Conversion'!BA28)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG28,'Und. Conversion'!BH28,'Und. Conversion'!BI28)","v":""},""]
[null,null,{"$f":"IF(D22=\"\",\"-\",12)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R23","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR29=0,I22>0),\"Error en la unidad de medida\",'Und. Conversion'!BR29)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB29:BB188,'Und. Conversion'!BA29:BA188,'Und. Conversion'!BA29)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG29,'Und. Conversion'!BH29,'Und. Conversion'!BI29)","v":""},""]
[null,null,{"$f":"IF(D23=\"\",\"-\",13)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R24","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR30=0,I23>0),\"Error en la unidad de medida\",'Und. Conversion'!BR30)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB30:BB189,'Und. Conversion'!BA30:BA189,'Und. Conversion'!BA30)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG30,'Und. Conversion'!BH30,'Und. Conversion'!BI30)","v":""},""]
[null,null,{"$f":"IF(D24=\"\",\"-\",14)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R25","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR31=0,I24>0),\"Error en la unidad de medida\",'Und. Conversion'!BR31)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB31:BB190,'Und. Conversion'!BA31:BA190,'Und. Conversion'!BA31)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG31,'Und. Conversion'!BH31,'Und. Conversion'!BI31)","v":""},""]
[null,null,{"$f":"IF(D25=\"\",\"-\",15)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R26","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR32=0,I25>0),\"Error en la unidad de medida\",'Und. Conversion'!BR32)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB32:BB191,'Und. Conversion'!BA32:BA191,'Und. Conversion'!BA32)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG32,'Und. Conversion'!BH32,'Und. Conversion'!BI32)","v":""},""]
[null,null,{"$f":"IF(D26=\"\",\"-\",16)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R27","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR33=0,I26>0),\"Error en la unidad de medida\",'Und. Conversion'!BR33)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB33:BB192,'Und. Conversion'!BA33:BA192,'Und. Conversion'!BA33)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG33,'Und. Conversion'!BH33,'Und. Conversion'!BI33)","v":""},""]
[null,null,{"$f":"IF(D27=\"\",\"-\",17)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R28","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR34=0,I27>0),\"Error en la unidad de medida\",'Und. Conversion'!BR34)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB34:BB193,'Und. Conversion'!BA34:BA193,'Und. Conversion'!BA34)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG34,'Und. Conversion'!BH34,'Und. Conversion'!BI34)","v":""},""]
[null,null,{"$f":"IF(D28=\"\",\"-\",18)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R29","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR35=0,I28>0),\"Error en la unidad de medida\",'Und. Conversion'!BR35)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB35:BB194,'Und. Conversion'!BA35:BA194,'Und. Conversion'!BA35)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG35,'Und. Conversion'!BH35,'Und. Conversion'!BI35)","v":""},""]
[null,null,{"$f":"IF(D29=\"\",\"-\",19)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R30","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR36=0,I29>0),\"Error en la unidad de medida\",'Und. Conversion'!BR36)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB36:BB195,'Und. Conversion'!BA36:BA195,'Und. Conversion'!BA36)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG36,'Und. Conversion'!BH36,'Und. Conversion'!BI36)","v":""},""]
[null,null,{"$f":"IF(D30=\"\",\"-\",20)","v":"-"},null,null,null,{"$f":"'Hoja de Costos'!R31","v":0},"-",null,null,null,{"$f":"IF(AND('Und. Conversion'!BR37=0,I30>0),\"Error en la unidad de medida\",'Und. Conversion'!BR37)","v":0},{"$f":"SUM((SUMIFS('Und. Conversion'!BB37:BB196,'Und. Conversion'!BA37:BA196,'Und. Conversion'!BA37)))","v":0},0,{"$f":"CONCATENATE('Und. Conversion'!BG37,'Und. Conversion'!BH37,'Und. Conversion'!BI37)","v":""},""]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Ingresa los ingredientes y las cantidades para una producción de \",D7)","v":"Ingresa los ingredientes y las cantidades para una producción de 0"}]

{"sheet":"Cuentas","index":4,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[7,12,7,13],[1,5,1,12],[2,5,2,12],[7,2,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11]]}
[]
[null,null,null,null,null,"Registros  contables "]
[null,null,null,null,null,{"$f":"Empresa!D8","v":0}]
[]
[]
[]
[]
[null,null,"Inventarios",null,"Inventario en proceso",null,"Iva",null,"Bancos",null,"CMO",null,"CIF",null,null,"Debe ","haber "]
[null,{"$f":"Inventario!C11","v":"-"},{"$f":"Inventario!K11","v":0},{"$f":"IFERROR((C9/Inventario!L11)*Inventario!M11,0)","v":0},{"$f":"D9","v":0},null,{"$f":"Inventario!P11","v":""},null,null,{"$f":"IF(Inventario!P11<>\"\",Inventario!P11+Inventario!K11,Inventario!K11)","v":0},{"$f":"Empresa!J18","v":0},null,{"$f":"Empresa!I18","v":0},null,null,{"$f":"C33+E33+G33+I33+K33+M33","v":0},{"$f":"N33+L33+J33+H33+F33+D33","v":0}]
[null,{"$f":"Inventario!C12","v":"-"},{"$f":"Inventario!K12","v":0},{"$f":"IFERROR((C10/Inventario!L12)*Inventario!M12,0)","v":0},{"$f":"D10","v":0},null,{"$f":"Inventario!P12","v":""},null,null,{"$f":"IF(Inventario!P12<>\"\",Inventario!P12+Inventario!K12,Inventario!K12)","v":0},{"$f":"Empresa!J19","v":0},null,{"$f":"Empresa!I19","v":0}]
[null,{"$f":"Inventario!C13","v":"-"},{"$f":"Inventario!K13","v":0},{"$f":"IFERROR((C11/Inventario!L13)*Inventario!M13,0)","v":0},0,null,{"$f":"Inventario!P13","v":""},null,null,{"$f":"IF(Inventario!P13<>\"\",Inventario!P13+Inventario!K13,Inventario!K13)","v":0},{"$f":"Empresa!J20","v":0},null,{"$f":"Empresa!I20","v":0}]
[null,{"$f":"Inventario!C14","v":"-"},{"$f":"Inventario!K14","v":0},{"$f":"IFERROR((C12/Inventario!L14)*Inventario!M14,0)","v":0},0,null,{"$f":"Inventario!P14","v":""},null,null,{"$f":"IF(Inventario!P14<>\"\",Inventario!P14+Inventario!K14,Inventario!K14)","v":0},{"$f":"Empresa!J21","v":0},null,{"$f":"Empresa!I21","v":0}]
[null,{"$f":"Inventario!C15","v":"-"},{"$f":"Inventario!K15","v":0},{"$f":"IFERROR((C13/Inventario!L15)*Inventario!M15,0)","v":0},0,null,{"$f":"Inventario!P15","v":""},null,null,{"$f":"IF(Inventario!P15<>\"\",Inventario!P15+Inventario!K15,Inventario!K15)","v":0},{"$f":"Empresa!J22","v":0},null,{"$f":"Empresa!I22","v":0}]
[null,{"$f":"Inventario!C16","v":"-"},{"$f":"Inventario!K16","v":0},{"$f":"IFERROR((C14/Inventario!L16)*Inventario!M16,0)","v":0},0,null,{"$f":"Inventario!P16","v":""},null,null,{"$f":"IF(Inventario!P16<>\"\",Inventario!P16+Inventario!K16,Inventario!K16)","v":0},{"$f":"Empresa!J23","v":0},null,{"$f":"Empresa!I23","v":0}]
[null,{"$f":"Inventario!C17","v":"-"},{"$f":"Inventario!K17","v":0},{"$f":"IFERROR((C15/Inventario!L17)*Inventario!M17,0)","v":0},0,null,{"$f":"Inventario!P17","v":""},null,null,{"$f":"IF(Inventario!P17<>\"\",Inventario!P17+Inventario!K17,Inventario!K17)","v":0},{"$f":"Empresa!J24","v":0},null,{"$f":"Empresa!I24","v":0}]
[null,{"$f":"Inventario!C18","v":"-"},{"$f":"Inventario!K18","v":0},{"$f":"IFERROR((C16/Inventario!L18)*Inventario!M18,0)","v":0},0,null,{"$f":"Inventario!P18","v":""},null,null,{"$f":"IF(Inventario!P18<>\"\",Inventario!P18+Inventario!K18,Inventario!K18)","v":0},{"$f":"Empresa!J25","v":0},null,{"$f":"Empresa!I25","v":0}]
[null,{"$f":"Inventario!C19","v":"-"},{"$f":"Inventario!K19","v":0},{"$f":"IFERROR((C17/Inventario!L19)*Inventario!M19,0)","v":0},0,null,{"$f":"Inventario!P19","v":""},null,null,{"$f":"IF(Inventario!P19<>\"\",Inventario!P19+Inventario!K19,Inventario!K19)","v":0},{"$f":"Empresa!J26","v":0},null,{"$f":"Empresa!I26","v":0}]
[null,{"$f":"Inventario!C20","v":"-"},{"$f":"Inventario!K20","v":0},{"$f":"IFERROR((C18/Inventario!L20)*Inventario!M20,0)","v":0},0,null,{"$f":"Inventario!P20","v":""},null,null,{"$f":"IF(Inventario!P20<>\"\",Inventario!P20+Inventario!K20,Inventario!K20)","v":0},{"$f":"Empresa!J27","v":0},null,{"$f":"Empresa!I27","v":0}]
[null,{"$f":"Inventario!C21","v":"-"},{"$f":"Inventario!K21","v":0},{"$f":"IFERROR((C19/Inventario!L21)*Inventario!M21,0)","v":0},0,null,{"$f":"Inventario!P21","v":""},null,null,{"$f":"IF(Inventario!P21<>\"\",Inventario!P21+Inventario!K21,Inventario!K21)","v":0},{"$f":"Empresa!J28","v":0},null,{"$f":"Empresa!I28","v":0}]
[null,{"$f":"Inventario!C22","v":"-"},{"$f":"Inventario!K22","v":0},{"$f":"IFERROR((C20/Inventario!L22)*Inventario!M22,0)","v":0},0,null,{"$f":"Inventario!P22","v":""},null,null,{"$f":"IF(Inventario!P22<>\"\",Inventario!P22+Inventario!K22,Inventario!K22)","v":0},{"$f":"Empresa!J29","v":0},null,{"$f":"Empresa!I29","v":0}]
[null,{"$f":"Inventario!C23","v":"-"},{"$f":"Inventario!K23","v":0},{"$f":"IFERROR((C21/Inventario!L23)*Inventario!M23,0)","v":0},0,null,{"$f":"Inventario!P23","v":""},null,null,{"$f":"IF(Inventario!P23<>\"\",Inventario!P23+Inventario!K23,Inventario!K23)","v":0},{"$f":"Empresa!J30","v":0},null,{"$f":"Empresa!I30","v":0}]
[null,{"$f":"Inventario!C24","v":"-"},{"$f":"Inventario!K24","v":0},{"$f":"IFERROR((C22/Inventario!L24)*Inventario!M24,0)","v":0},0,null,{"$f":"Inventario!P24","v":""},null,null,{"$f":"IF(Inventario!P24<>\"\",Inventario!P24+Inventario!K24,Inventario!K24)","v":0},{"$f":"Empresa!J31","v":0},null,{"$f":"Empresa!I31","v":0}]
[null,{"$f":"Inventario!C25","v":"-"},{"$f":"Inventario!K25","v":0},{"$f":"IFERROR((C23/Inventario!L25)*Inventario!M25,0)","v":0},0,null,{"$f":"Inventario!P25","v":""},null,null,{"$f":"IF(Inventario!P25<>\"\",Inventario!P25+Inventario!K25,Inventario!K25)","v":0},{"$f":"Empresa!J32","v":0},null,{"$f":"Empresa!I32","v":0}]
[null,{"$f":"Inventario!C26","v":"-"},{"$f":"Inventario!K26","v":0},{"$f":"IFERROR((C24/Inventario!L26)*Inventario!M26,0)","v":0},0,null,{"$f":"Inventario!P26","v":""},null,null,{"$f":"IF(Inventario!P26<>\"\",Inventario!P26+Inventario!K26,Inventario!K26)","v":0},{"$f":"Empresa!J33","v":0},null,{"$f":"Empresa!I33","v":0}]
[null,{"$f":"Inventario!C27","v":"-"},{"$f":"Inventario!K27","v":0},{"$f":"IFERROR((C25/Inventario!L27)*Inventario!M27,0)","v":0},0,null,{"$f":"Inventario!P27","v":""},null,null,{"$f":"IF(Inventario!P27<>\"\",Inventario!P27+Inventario!K27,Inventario!K27)","v":0},{"$f":"Empresa!J34","v":0},null,{"$f":"Empresa!I34","v":0}]
[null,{"$f":"Inventario!C28","v":"-"},{"$f":"Inventario!K28","v":0},{"$f":"IFERROR((C26/Inventario!L28)*Inventario!M28,0)","v":0},0,null,{"$f":"Inventario!P28","v":""},null,null,{"$f":"IF(Inventario!P28<>\"\",Inventario!P28+Inventario!K28,Inventario!K28)","v":0},{"$f":"Empresa!J35","v":0},null,{"$f":"Empresa!I35","v":0}]
[null,{"$f":"Inventario!C29","v":"-"},{"$f":"Inventario!K29","v":0},{"$f":"IFERROR((C27/Inventario!L29)*Inventario!M29,0)","v":0},0,null,{"$f":"Inventario!P29","v":""},null,null,{"$f":"IF(Inventario!P29<>\"\",Inventario!P29+Inventario!K29,Inventario!K29)","v":0},{"$f":"Empresa!J36","v":0},null,{"$f":"Empresa!I36","v":0}]
[null,{"$f":"Inventario!C30","v":"-"},{"$f":"Inventario!K30","v":0},{"$f":"IFERROR((C28/Inventario!L30)*Inventario!M30,0)","v":0},0,null,{"$f":"Inventario!P30","v":""},null,null,{"$f":"IF(Inventario!P30<>\"\",Inventario!P30+Inventario!K30,Inventario!K30)","v":0},{"$f":"Empresa!J37","v":0},null,{"$f":"Empresa!I37","v":0}]
[]
[null,"CMO",null,null,null,null,null,null,null,{"$f":"SUM(Empresa!J18:J27)","v":0}]
[null,"CIF",null,null,null,null,null,null,null,{"$f":"SUM(Empresa!I18:I27)","v":0}]
[]
[null,"Total",{"$f":"SUM(C9:C28)","v":0},0,0,0,0,0,0,{"$f":"SUM(J9:J28)+J30+J31","v":0},{"$f":"SUM(K9:K28)","v":0},{"$f":"SUM(L9:L28)","v":0},0,0]

{"sheet":"Hoja de Costos","index":5,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,1,36,2],[36,14,36,15],[39,5,39,6],[39,18,39,19],[1,7,1,19],[36,3,36,4],[8,3,8,10],[8,16,8,23],[10,19,10,20],[10,22,10,23],[36,16,36,17],[10,6,10,7],[10,9,10,10],[10,1,10,4],[10,14,10,17],[8,1,8,2],[8,14,8,15]]}
[]
[null,null,null,null,null,null,null,"Hoja de costos"]
[]
[null,null,"www.asesoriasmipyme.com"]
[]
[]
[]
[]
[null,null,null,{"$f":"CONCATENATE(\"Costo total de producción de \",Empresa!D13,\" unidades\")","v":"Costo total de producción de  unidades"},null,null,null,null,null,null,null,null,null,null,null,null,"Costo de un solo  producto"]
[]
[null,"Materiales directos",null,null,null,null,"MOD",null,null,"CIF",null,null,null,null,"Materiales directos",null,null,null,null,"MOD",null,null,"CIF"]
[null,"IVA ",{"$f":"Cuentas!G9","v":""},{"$f":"Inventario!D11","v":0},{"$f":"Cuentas!D9","v":0},null,{"$f":"Empresa!E18","v":0},{"$f":"Empresa!J18","v":0},null,{"$f":"Empresa!G18","v":0},{"$f":"Empresa!I18","v":0},null,null,null,"IVA",{"$f":"IFERROR(C12/Empresa!$D$13,0)","v":0},{"$f":"D12","v":0},{"$f":"IFERROR(E12/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E18","v":0},{"$f":"IFERROR(H12/Empresa!$D$13,0)","v":0},null,{"$f":"J12","v":0},{"$f":"IFERROR(K12/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G10","v":""},{"$f":"Inventario!D12","v":0},{"$f":"Cuentas!D10","v":0},null,{"$f":"Empresa!E19","v":0},{"$f":"Empresa!J19","v":0},null,{"$f":"Empresa!G19","v":0},{"$f":"Empresa!I19","v":0},null,null,null,null,{"$f":"IFERROR(C13/Empresa!$D$13,0)","v":0},{"$f":"D13","v":0},{"$f":"IFERROR(E13/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E19","v":0},{"$f":"IFERROR(H13/Empresa!$D$13,0)","v":0},null,{"$f":"J13","v":0},{"$f":"IFERROR(K13/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G11","v":""},{"$f":"Inventario!D13","v":0},{"$f":"Cuentas!D11","v":0},null,{"$f":"Empresa!E20","v":0},{"$f":"Empresa!J20","v":0},null,{"$f":"Empresa!G20","v":0},{"$f":"Empresa!I20","v":0},null,null,null,null,{"$f":"IFERROR(C14/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E14/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E20","v":0},{"$f":"IFERROR(H14/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K14/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G12","v":""},{"$f":"Inventario!D14","v":0},{"$f":"Cuentas!D12","v":0},null,{"$f":"Empresa!E21","v":0},{"$f":"Empresa!J21","v":0},null,{"$f":"Empresa!G21","v":0},{"$f":"Empresa!I21","v":0},null,null,null,null,{"$f":"IFERROR(C15/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E15/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E21","v":0},{"$f":"IFERROR(H15/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K15/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G13","v":""},{"$f":"Inventario!D15","v":0},{"$f":"Cuentas!D13","v":0},null,{"$f":"Empresa!E22","v":0},{"$f":"Empresa!J22","v":0},null,{"$f":"Empresa!G22","v":0},{"$f":"Empresa!I22","v":0},null,null,null,null,{"$f":"IFERROR(C16/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E16/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E22","v":0},{"$f":"IFERROR(H16/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K16/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G14","v":""},{"$f":"Inventario!D16","v":0},{"$f":"Cuentas!D14","v":0},null,{"$f":"Empresa!E23","v":0},{"$f":"Empresa!J23","v":0},null,{"$f":"Empresa!G23","v":0},{"$f":"Empresa!I23","v":0},null,null,null,null,{"$f":"IFERROR(C17/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E17/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E23","v":0},{"$f":"IFERROR(H17/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K17/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G15","v":""},{"$f":"Inventario!D17","v":0},{"$f":"Cuentas!D15","v":0},null,{"$f":"Empresa!E24","v":0},{"$f":"Empresa!J24","v":0},null,{"$f":"Empresa!G24","v":0},{"$f":"Empresa!I24","v":0},null,null,null,null,{"$f":"IFERROR(C18/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E18/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E24","v":0},{"$f":"IFERROR(H18/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K18/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G16","v":""},{"$f":"Inventario!D18","v":0},{"$f":"Cuentas!D16","v":0},null,{"$f":"Empresa!E25","v":0},{"$f":"Empresa!J25","v":0},null,{"$f":"Empresa!G25","v":0},{"$f":"Empresa!I25","v":0},null,null,null,null,{"$f":"IFERROR(C19/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E19/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E25","v":0},{"$f":"IFERROR(H19/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K19/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G17","v":""},{"$f":"Inventario!D19","v":0},{"$f":"Cuentas!D17","v":0},null,{"$f":"Empresa!E26","v":0},{"$f":"Empresa!J26","v":0},null,{"$f":"Empresa!G26","v":0},{"$f":"Empresa!I26","v":0},null,null,null,null,{"$f":"IFERROR(C20/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E20/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E26","v":0},{"$f":"IFERROR(H20/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K20/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G18","v":""},{"$f":"Inventario!D20","v":0},{"$f":"Cuentas!D18","v":0},null,{"$f":"Empresa!E27","v":0},{"$f":"Empresa!J27","v":0},null,{"$f":"Empresa!G27","v":0},{"$f":"Empresa!I27","v":0},null,null,null,null,{"$f":"IFERROR(C21/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E21/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E27","v":0},{"$f":"IFERROR(H21/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K21/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G19","v":""},{"$f":"Inventario!D21","v":0},{"$f":"Cuentas!D19","v":0},null,{"$f":"Empresa!E28","v":0},{"$f":"Empresa!J28","v":0},null,{"$f":"Empresa!G28","v":0},{"$f":"Empresa!I28","v":0},null,null,null,null,{"$f":"IFERROR(C22/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E22/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E28","v":0},{"$f":"IFERROR(H22/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K22/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G20","v":""},{"$f":"Inventario!D22","v":0},{"$f":"Cuentas!D20","v":0},null,{"$f":"Empresa!E29","v":0},{"$f":"Empresa!J29","v":0},null,{"$f":"Empresa!G29","v":0},{"$f":"Empresa!I29","v":0},null,null,null,null,{"$f":"IFERROR(C23/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E23/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E29","v":0},{"$f":"IFERROR(H23/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K23/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G21","v":""},{"$f":"Inventario!D23","v":0},{"$f":"Cuentas!D21","v":0},null,{"$f":"Empresa!E30","v":0},{"$f":"Empresa!J30","v":0},null,{"$f":"Empresa!G30","v":0},{"$f":"Empresa!I30","v":0},null,null,null,null,{"$f":"IFERROR(C24/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E24/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E30","v":0},{"$f":"IFERROR(H24/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K24/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G22","v":""},{"$f":"Inventario!D24","v":0},{"$f":"Cuentas!D22","v":0},null,{"$f":"Empresa!E31","v":0},{"$f":"Empresa!J31","v":0},null,{"$f":"Empresa!G31","v":0},{"$f":"Empresa!I31","v":0},null,null,null,null,{"$f":"IFERROR(C25/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E25/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E31","v":0},{"$f":"IFERROR(H25/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K25/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G23","v":""},{"$f":"Inventario!D25","v":0},{"$f":"Cuentas!D23","v":0},null,{"$f":"Empresa!E32","v":0},{"$f":"Empresa!J32","v":0},null,{"$f":"Empresa!G32","v":0},{"$f":"Empresa!I32","v":0},null,null,null,null,{"$f":"IFERROR(C26/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E26/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E32","v":0},{"$f":"IFERROR(H26/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K26/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G24","v":""},{"$f":"Inventario!D26","v":0},{"$f":"Cuentas!D24","v":0},null,{"$f":"Empresa!E33","v":0},{"$f":"Empresa!J33","v":0},null,{"$f":"Empresa!G33","v":0},{"$f":"Empresa!I33","v":0},null,null,null,null,{"$f":"IFERROR(C27/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E27/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E33","v":0},{"$f":"IFERROR(H27/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K27/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G25","v":""},{"$f":"Inventario!D27","v":0},{"$f":"Cuentas!D25","v":0},null,{"$f":"Empresa!E34","v":0},{"$f":"Empresa!J34","v":0},null,{"$f":"Empresa!G34","v":0},{"$f":"Empresa!I34","v":0},null,null,null,null,{"$f":"IFERROR(C28/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E28/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E34","v":0},{"$f":"IFERROR(H28/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K28/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G26","v":""},{"$f":"Inventario!D28","v":0},{"$f":"Cuentas!D26","v":0},null,{"$f":"Empresa!E35","v":0},{"$f":"Empresa!J35","v":0},null,{"$f":"Empresa!G35","v":0},{"$f":"Empresa!I35","v":0},null,null,null,null,{"$f":"IFERROR(C29/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E29/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E35","v":0},{"$f":"IFERROR(H29/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K29/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G27","v":""},{"$f":"Inventario!D29","v":0},{"$f":"Cuentas!D27","v":0},null,{"$f":"Empresa!E36","v":0},{"$f":"Empresa!J36","v":0},null,{"$f":"Empresa!G36","v":0},{"$f":"Empresa!I36","v":0},null,null,null,null,{"$f":"IFERROR(C30/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E30/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E36","v":0},{"$f":"IFERROR(H30/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K30/Empresa!$D$13,0)","v":0}]
[null,null,{"$f":"Cuentas!G28","v":""},{"$f":"Inventario!D30","v":0},{"$f":"Cuentas!D28","v":0},null,{"$f":"Empresa!E37","v":0},{"$f":"Empresa!J37","v":0},null,{"$f":"Empresa!G37","v":0},{"$f":"Empresa!I37","v":0},null,null,null,null,{"$f":"IFERROR(C31/Empresa!$D$13,0)","v":0},0,{"$f":"IFERROR(E31/Empresa!$D$13,0)","v":0},null,{"$f":"Empresa!E37","v":0},{"$f":"IFERROR(H31/Empresa!$D$13,0)","v":0},null,0,{"$f":"IFERROR(K31/Empresa!$D$13,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"Empresa!G38","v":0},{"$f":"Empresa!H38","v":0}]
[]
[null,"TOTAL",{"$f":"SUM(C12:C31)","v":0},null,{"$f":"SUM(E12:E31)","v":0},null,null,{"$f":"SUM(H12:H31)","v":0},null,null,0,null,null,null,"TOTAL",{"$f":"SUM(P12:P31)","v":0},null,{"$f":"SUM(R12:R32)","v":0},{"$f":"SUM(S12:S32)","v":0},0,0,0,0,0]
[]
[]
[null,null,null,"Costo Total",null,null,null,null,null,null,{"$f":"E34+H34+K34+C34","v":0},null,null,null,null,null,"Costo Unitario",null,null,null,null,null,null,{"$f":"R34+U34+X34+P34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K37/Empresa!$D$13","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"Costo de conversion",null,"MOD + CIF",{"$f":"H34+K34","v":0},null,null,null,null,null,null,null,null,null,"Costo de conversion",null,"MOD + CIF",{"$f":"U34+X34","v":0}]