{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["AUTOLIQUIDACION"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"AUTOLIQUIDACION","index":0,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[49,2,49,9],[53,2,53,9],[27,18,28,18],[27,19,28,19],[47,1,48,14],[34,13,34,15],[34,16,34,17],[2,5,2,9],[4,2,4,9],[5,8,5,9],[27,13,28,13],[5,2,5,4],[5,5,5,7],[23,14,23,17],[27,14,28,17],[24,2,24,4],[23,2,23,8],[24,13,26,13],[24,14,24,17],[25,14,25,17],[26,14,26,17]]}
[]
[]
[null,null,null,null,null,"DOC. 3 . AUTOLIQUIDACION MATADEROS"]
[]
[null,null,"REDUCCION POR HORARIO DE TRABAJO"]
[null,null,"TIPO D2.1 1 (20%)",null,null,"TIPO D2.1 2 (10%)",null,null,"TIPO D2.1 3 (0%)"]
["CLASE DE GANADO",null,"Nº","TASA","REDUCCION","Nº","TASA","REDUCCION","Nº","TASA","Nº TOTAL","TOTAL TASA BRUTA"]
["Bovino > 218 Kg canal",5,null,{"$f":"C8*B8","v":0},{"$f":"D8*0.2","v":0},null,{"$f":"F8*B8","v":0},{"$f":"G8*0.1","v":0},null,{"$f":"I8*B8","v":0},{"$f":"C8+F8+I8","v":0},{"$f":"D8+G8+J8","v":0}]
["Bovino <218 Kg Canal",2,null,{"$f":"C9*B9","v":0},{"$f":"D9*0.2","v":0},null,{"$f":"F9*B9","v":0},{"$f":"G9*0.1","v":0},null,{"$f":"I9*B9","v":0},{"$f":"C9+F9+I9","v":0},{"$f":"D9+G9+J9","v":0}]
["Solipedos",3,null,0,0,null,0,0,null,0,0,0]
["Porcino < 25 kgr.",0.5,null,0,0,null,0,0,null,0,0,0]
["Porcino ≥ 25 kgr.",1,null,0,0,null,0,0,null,0,0,0]
["Ovino Caprino < 12kgr.",0.15,null,0,0,null,0,0,null,0,0,0]
["Ovino Caprino ≥ 12kgr.",0.25,null,0,0,null,0,0,null,0,0,0]
["Aves y pintadas",5.0000000000000001E-3,null,0,0,null,0,0,null,0,0,0]
["Patos y ocas",0.01,null,0,0,null,0,0,null,0,0,0]
["Pavos",2.5000000000000001E-2,null,0,0,null,0,0,null,0,0,0]
["Conejo de Granja",5.0000000000000001E-3,null,0,0,null,0,0,null,0,0,0]
["Ciervos",0.5,null,0,0,null,0,0,null,0,0,0]
["Otros mamíferos de caza de cría",0.5,null,0,0,null,0,0,null,0,0,0]
[null,"TOTAL",{"$f":"SUM(C8:C20)","v":0},{"$f":"SUM(D8:D20)","v":0},0,0,0,0,0,0,{"$f":"SUM(K8:K20)","v":0},{"$f":"SUM(L8:L20)","v":0}]
[]
[]
[null,null,"OTRAS REDUCCIONES",null,null,null,null,null,null,null,null,null,null,"Total Tasas","Una vez aplicadas las Reducciones variables",null,null,null,{"$f":"L21-E21-H21","v":0},"¿Se puede aplicar la deducción (escribir SI o NO)?"]
[null,null,"TAMAÑO EMPRESA",null,null,null,null,null,null,null,null,null,null,"Reduccion tamaño empresa (SOLO SE ELIGE UNA DE LAS TRES)","A1 MEDIANA EMPRESA",null,null,null,{"$f":"C40","v":0},"SI"]
["CLASE DE GANADO",null,"A1 (10%)","A2 (20%)","A3 (30%)","B (20%)","C (20%)","D1 (20%)","D2.2 (20%)",null,null,null,null,null,"A2 PEQUEÑA EMPRESA",null,null,null,{"$f":"D40","v":0},"NO"]
["Bovino > 218 Kg canal",5,{"$f":"L8*0.1","v":0},{"$f":"L8*0.2","v":0},{"$f":"L8*0.3","v":0},{"$f":"L8*0.2","v":0},{"$f":"L8*0.2","v":0},{"$f":"L8*(0.2)","v":0},{"$f":"L8*0.2","v":0},null,null,null,null,null,"A3 MICROEMPRESA",null,null,null,{"$f":"E40","v":0},"NO"]
["Bovino <218 Kg Canal",2,{"$f":"L9*0.1","v":0},{"$f":"L9*0.2","v":0},{"$f":"L9*0.3","v":0},{"$f":"L9*0.2","v":0},{"$f":"L9*0.2","v":0},0,0,null,null,null,null,"Reducción B","REDUCCION POR UTILIZACION DE METODOS TRADICIONALES DE PRODUCCION (20%)",null,null,null,{"$f":"F40","v":0},"NO"]
["Solipedos",3,0,0,0,0,0,0,0]
["Porcino < 25 kgr.",0.5,0,0,0,0,0,0,0,null,null,null,null,"Reducción C","REDUCCION POR INSTALACION EN ZONAS POCO DESARROLLADAS",null,null,null,{"$f":"G40","v":0},"SI"]
["Porcino ≥ 25 kgr.",1,0,0,0,0,0,0,0,null,null,null,null,"Reducción D1","Cumplimiento Normativa Sanitaria (20%)",null,null,null,{"$f":"H40","v":0},"SI"]
["Ovino Caprino < 12kgr.",0.15,0,0,0,0,0,0,0,null,null,null,null,"Reducción D2.2 ","Reducción por actividad planificada (20%)",null,null,null,{"$f":"I40","v":0},"SI"]
["Ovino Caprino ≥ 12kgr.",0.25,0,0,0,0,0,0,0]
["Aves y pintadas",5.0000000000000001E-3,0,0,0,0,0,0,0]
["Patos y ocas",0.01,0,0,0,0,0,0,0,null,null,null,null,"TOTAL A PAGAR",null,null,{"$f":"S42-S53","v":0}]
["Pavos",2.5000000000000001E-2,0,0,0,0,0,0,0]
["Conejo de Granja",5.0000000000000001E-3,0,0,0,0,0,0,0]
["Ciervos",0.5,0,0,0,0,0,0,0]
["Otros mamíferos de caza de cría",0.5,0,0,0,0,0,0,0]
[null,"TOTAL",{"$f":"SUM(C27:C39)","v":0},0,0,0,0,0,0]
[]
[null,"INSTRUCCIONES PARA RELLENAR DOCUMENTO 3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL TASAS",{"$f":"L21","v":0}]
[null,"1.- En la columna tipo D2.1 1, donde pone nº, se rellenará el nº de animales sacrificados según especie y tipo de animal en el horario indicado en la legislación",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL REDUCCIONES VARIABLES",{"$f":"E21+H21+J21","v":0}]
[null,"2.- En la columna tipo D2.1 2, se rellenará el nº de animales sacrificados según especie y tipo de animal en horario distinto al del punto 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. TAMAÑO EMPRESA",{"$f":"IF(T25=\"SI\",S25,0)","v":0}]
[null,"3.- En la columna D2.1 3, se rellenará el nº de animales sacrificados según especie y tipo de animal en sábados domingos y días no laborables.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. TAMAÑO EMPRESA",{"$f":"IF(T26=\"SI\",S26,0)","v":0}]
[null,"4.- Los datos de las reducciones los calcula la tabla automáticamente, al igual que la tabla de las otras reducciones.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. TAMAÑO EMPRESA",0]
[null,"5.- En la tabla “total tasas”, se escribirá en la columna “¿Se puede aplicar la reducción?” el dato SI o NO (en mayúsculas) según se tenga derecho a las otras reducciones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. METODOS TRAD",0]
[null,"SE ELEGIRAN LAS REDUCCIONES QUE CUMPLAN LO INDICADO EN LA LEY 2/2021, CON UN TOPE MAXIMO DE REDUCCIÓN DEL 80%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. INSTALACION",{"$f":"IF(T30=\"SI\",S30,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. NORMATIVA",{"$f":"IF(T31=\"SI\",S31,0)","v":0}]
[null,null,"INSTRUCCIONES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RED. ACTIV. PLAN",{"$f":"IF(T32=\"SI\",S32,0)","v":0}]
[null,null,"Lo primero, cuando se abre el documento excel, sale un mensaje para habilitar macros (hacerlo)"]
[null,null,"Pasando el puntero del ratón por los encabezados de los conceptos, se ve la descripción de los mismos.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUMA REDUCCIONES",{"$f":"S43+S44+S45+S46+S47+S48+S49+S50","v":0}]
[null,null,"Solo hay que meter valores en los campos de color verde si es necesario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL CON LIMITE",{"$f":"IF(S52>(L21*0.8),L21*0.8,S52)","v":0}]
[null,null,"Por un lado el número de animales sacrificados, y por el otro, escribir SI o NO (en mayúsculas), si se tiene o no tiene derecho a las reducciones tipo A1, A2 o A3, y la B, C, D1 y D2.2"]