{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["ISR PROVISIONALES","XML ENE-DIC-2022 CASO","XML ENE-DIC-2022 respaldo","CatalogoIngresos","TARIFAS 2022"],"not_rendered":{"images":1,"macros":1,"defined_names":16,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"ISR PROVISIONALES","index":0,"n_rows":28,"n_cols":10,"rows_kept":28}
[null,"MetodoPago","(Varios elementos)"]
[]
[null,"Etiquetas de fila","Suma de SubTotal","Ing Acum","Ded Aut","Ded Acum","Base Grav","ISR PP","ISR RET","ISR X PAG"]
["ENERO","01",{"v":911650,"d":"911,650.00"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"01\")","v":{"v":911650,"d":"911,650.00"}},{"v":68212.5,"d":"68,212.50"},{"$f":"SUM($E$4:E4)","v":{"v":68212.5,"d":"68,212.50"}},{"$f":"D4-F4","v":{"v":843437.5,"d":"843,437.50"}},{"$f":"(G4-VLOOKUP(G4,INDIRECT(A4),1))*VLOOKUP(G4,INDIRECT(A4),4)+VLOOKUP(G4,INDIRECT(A4),4)","v":{"v":193160.97149999999,"d":"193,160.97"}},{"$f":"D4*0.1","v":{"v":91165,"d":"91,165.00"}},{"$f":"IF(H4>I4,H4-I4,0)","v":{"v":101995.97149999999,"d":"101,995.97"}}]
["FEBRERO","02",{"v":652250,"d":"652,250.00"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"02\")+D4","v":{"v":1563900,"d":"1,563,900.00"}},{"v":79855,"d":"79,855.00"},{"$f":"SUM($E$4:E5)","v":{"v":148067.5,"d":"148,067.50"}},{"$f":"D5-F5","v":{"v":1415832.5,"d":"1,415,832.50"}},{"$f":"(G5-VLOOKUP(G5,INDIRECT(A5),1))*VLOOKUP(G5,INDIRECT(A5),4)+VLOOKUP(G5,INDIRECT(A5),4)","v":{"v":291456.7214999999,"d":"291,456.72"}},{"$f":"D5*0.1","v":{"v":156390,"d":"156,390.00"}},{"$f":"IF(H5>I5,H5-I5,0)","v":{"v":135066.72149999993,"d":"135,066.72"}}]
["MARZO","03",{"v":690018.6399999999,"d":"690,018.64"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"03\")+D5","v":{"v":2253918.6399999997,"d":"2,253,918.64"}},{"v":69998,"d":"69,998.00"},{"$f":"SUM($E$4:E6)","v":{"v":218065.5,"d":"218,065.50"}},{"v":2035853.1399999997,"d":"2,035,853.14"},{"v":406421.44549999986,"d":"406,421.45"},{"$f":"D6*0.1","v":{"v":225391.86399999997,"d":"225,391.86"}},{"$f":"IF(H6>I6,H6-I6,0)","v":{"v":181029.58149999988,"d":"181,029.58"}}]
["ABRIL","04",{"v":1063984.32,"d":"1,063,984.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"04\")+D6","v":{"v":3317902.96,"d":"3,317,902.96"}},{"v":85710,"d":"85,710.00"},{"$f":"SUM($E$4:E7)","v":{"v":303775.5,"d":"303,775.50"}},{"v":3014127.46,"d":"3,014,127.46"},{"v":646774.9574999999,"d":"646,774.96"},{"v":331790.29600000003,"d":"331,790.30"},{"v":314984.6614999999,"d":"314,984.66"}]
["MAYO","05",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"05\")+D7","v":{"v":3989037.2800000003,"d":"3,989,037.28"}},{"v":97855,"d":"97,855.00"},{"$f":"SUM($E$4:E8)","v":{"v":401630.5,"d":"401,630.50"}},{"v":3587406.7800000003,"d":"3,587,406.78"},{"v":745380.2195000001,"d":"745,380.22"},{"v":398903.72800000006,"d":"398,903.73"},{"v":346476.49150000006,"d":"346,476.49"}]
["JUNIO","06",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"06\")+D8","v":{"v":4660171.600000001,"d":"4,660,171.60"}},{"v":99998,"d":"99,998.00"},{"$f":"SUM($E$4:E9)","v":{"v":501628.5,"d":"501,628.50"}},{"v":4158543.1000000006,"d":"4,158,543.10"},{"v":843235.4315000002,"d":"843,235.43"},{"v":466017.1600000001,"d":"466,017.16"},{"v":377218.2715000001,"d":"377,218.27"}]
["JULIO","07",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"07\")+D9","v":{"v":5331305.920000001,"d":"5,331,305.92"}},{"v":105712,"d":"105,712.00"},{"$f":"SUM($E$4:E10)","v":{"v":607340.5,"d":"607,340.50"}},{"v":4723965.420000001,"d":"4,723,965.42"},{"v":939090.7435000003,"d":"939,090.74"},{"v":533130.5920000001,"d":"533,130.59"},{"v":405960.15150000027,"d":"405,960.15"}]
["AGOSTO","08",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"08\")+D10","v":{"v":6002440.240000001,"d":"6,002,440.24"}},{"v":107497.5,"d":"107,497.50"},{"$f":"SUM($E$4:E11)","v":{"v":714838,"d":"714,838.00"}},{"v":5287602.240000001,"d":"5,287,602.24"},{"v":1034321.1305000004,"d":"1,034,321.13"},{"v":600244.0240000001,"d":"600,244.02"},{"v":434077.10650000034,"d":"434,077.11"}]
["SEPTIEMBRE","09",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"09\")+D11","v":{"v":6673574.560000001,"d":"6,673,574.56"}},{"v":89855,"d":"89,855.00"},{"$f":"SUM($E$4:E12)","v":{"v":804693,"d":"804,693.00"}},{"v":5868881.560000001,"d":"5,868,881.56"},{"v":1135726.3925000005,"d":"1,135,726.39"},{"v":667357.4560000002,"d":"667,357.46"},{"v":468368.9365000003,"d":"468,368.94"}]
["OCTUBRE","10",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"10\")+D12","v":{"v":7344708.880000002,"d":"7,344,708.88"}},{"v":97855,"d":"97,855.00"},{"$f":"SUM($E$4:E13)","v":{"v":902548,"d":"902,548.00"}},{"v":6442160.880000002,"d":"6,442,160.88"},{"v":1234331.6545000006,"d":"1,234,331.65"},{"v":734470.8880000003,"d":"734,470.89"},{"v":499860.7665000004,"d":"499,860.77"}]
["NOVIEMBRE","11",{"v":671134.3200000001,"d":"671,134.32"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"11\")+D13","v":{"v":8015843.200000002,"d":"8,015,843.20"}},{"v":116497.5,"d":"116,497.50"},{"$f":"SUM($E$4:E14)","v":{"v":1019045.5,"d":"1,019,045.50"}},{"v":6996797.700000002,"d":"6,996,797.70"},{"v":1326412.0415000007,"d":"1,326,412.04"},{"v":801584.3200000003,"d":"801,584.32"},{"v":524827.7215000005,"d":"524,827.72"}]
["DICIEMBRE","12",{"v":392850,"d":"392,850.00"},{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3,\"Num Mes\",\"12\")+D14","v":{"v":8408693.200000003,"d":"8,408,693.20"}},{"v":104610,"d":"104,610.00"},{"$f":"SUM($E$4:E15)","v":{"v":1123655.5,"d":"1,123,655.50"}},{"v":7285037.700000003,"d":"7,285,037.70"},{"v":1325253.5415000012,"d":"1,325,253.54"},{"v":840869.3200000003,"d":"840,869.32"},{"v":484384.2215000009,"d":"484,384.22"}]
[null,"Total general",{"v":8408693.200000003,"d":"8,408,693.20"},null,{"$f":"SUM(E4:E15)","v":{"v":1123655.5,"d":"1,123,655.50"}}]
[]
[]
[]
["INGRESOS ANUALES",{"$f":"GETPIVOTDATA(\"SubTotal\",$B$3)","v":{"v":8408693.200000003,"d":"8,408,693.20"}}]
["(-) DEDUCC AUT",{"$f":"E16","v":{"v":1123655.5,"d":"1,123,655.50"}}]
["(=) UTILIDAD FISCAL",{"$f":"B20-B21","v":{"v":7285037.700000003,"d":"7,285,037.70"}}]
["(-) DEDUCC PERSONALES",{"$f":"IF(B20*15%>96.22*30.4*12*3,96.22*30.4*12*3,B20*15%)","v":{"v":105303.16799999999,"d":"105,303.17"}}]
["(=) BASE GRAVABLE",{"$f":"B22-B23","v":{"v":7179734.532000003,"d":"7,179,734.53"}}]
["(=) ISR ANUAL",{"$f":"(B24-VLOOKUP(B24,ANUAL2022,1))*VLOOKUP(B24,ANUAL2022,4)+VLOOKUP(B24,ANUAL2022,3)","v":{"v":2385617.292700001,"d":"2,385,617.29"}}]
["(-) RETENCION ISR",{"$f":"I15","v":{"v":840869.3200000003,"d":"840,869.32"}}]
["(-) PAGOS PROVS EFECT",0]
["(=) ISR X PAGAR",{"$f":"B26-B27","v":{"v":840869.3200000003,"d":"840,869.32"}}]

{"sheet":"XML ENE-DIC-2022 CASO","index":1,"n_rows":46,"n_cols":43,"rows_kept":46,"merged":[[2,3,2,10],[2,11,2,13],[2,14,2,16],[2,22,2,28],[2,29,2,31],[2,32,2,34],[2,35,2,36],[2,37,2,41]]}
[]
[]
[{"$nulls":3},"COMPROBANTE",{"$nulls":7},"EMISOR",null,null,"RECEPTOR",null,null,"UUID",null,"TIPORELACION","CFDIRELACIONADO",null,"CONCEPTOS",{"$nulls":6},"IMPUESTOS",null,null,"IMPUESTOS RETENIDOS",null,null,"CFDIPAGO",null,"CFDIPDOCTORELACIONADO"]
["Mes","Num Mes","Ruta de Acceso a XML","Fecha","MetodoPago","Serie","Folio","LugarExpedicion","TipoDeComprobante","Total","SubTotal","RegimenFiscal","Rfc","Nombre","Nombre","Rfc","UsoCFDI","UUID","COINC EGR Vs ING","TipoRelacion","UUID","COINC ING Vs EGR","Importe","Cantidad","ValorUnitario","ClaveProdServ","Descripcion","Unidad","ClaveUnidad","Importe","TasaOCuota","Impuesto","Importe","TasaOCuota","Impuesto","Monto","FechaPago","NumParcialidad","ImpSaldoAnt","ImpPagado","ImpSaldoInsoluto","IdDocumento","Catalogo Ingresos"]
["ENERO",{"$f":"MID(D5,6,2)","v":"01"},"D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L194-E4DA75FC-64BC-49A4-864A-FE4D7F56CE1E.xml",{"$f":"COMPROBANTE($C5,D$4)","v":"2022-01-03T14:10:56"},"PPD","L","194","01000","I",{"$f":"VALUE(COMPROBANTE($C5,J$4))","v":{"v":247294.58,"d":"247,294.58"}},{"v":259400,"d":"259,400.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",{"$f":"RECEPTOR($C5,O$4)","v":"BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B"},"BMN930209927","G03",{"$f":"UUID($C5,R$4)","v":"e4da75fc-64bc-49a4-864a-fe4d7f56ce1e"},{"$f":"IFERROR(MATCH(U5,$R$5:$R$5,0)+4,\"\")","v":""},{"$f":"TIPORELACION($C5,T$4)","v":0},{"$f":"CFDIRELACIONADO($C5,U$4)","v":0},{"$f":"IFERROR(MATCH(R5,$U$5:$U$5,0)+4,\"\")","v":""},{"$f":"VALUE(CONCEPTOS($C5,W$4))","v":{"v":259400,"d":"259,400.00"}},{"$f":"CONCEPTOS($C5,X$4)","v":"1.000000"},{"$f":"VALUE(CONCEPTOS($C5,Y$4))","v":{"v":259400,"d":"259,400.00"}},null,"HONORARIOS DE ENERO  DEL 2022. ",{"$f":"CONCEPTOS($C5,AB$4)","v":"NO APLICA"},"E48",{"$f":"VALUE(IMPUESTOS($C5,AD$4))","v":{"v":41504,"d":"41,504.00"}},{"$f":"IMPUESTOS($C5,AE$4)","v":"0.160000"},"002",{"$f":"K5*0.1","v":{"v":25940,"d":"25,940.00"}},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C5,AJ$4))","v":0},{"$f":"CFDIPAGO($C5,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C5,AL$4)","v":0},{"$f":"VALUE(CFDIPDOCTORELACIONADO($C5,AM$4))","v":0},0,0,{"$f":"CFDIPDOCTORELACIONADO($C5,AP$4)","v":0},"Servicios profesionales (derechos de autor)"]
["ENERO","01","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L195-0E6D58E0-A7DD-4A2A-BC4F-60C585E145D8.xml","2022-01-07T12:39:32","PUE","L","195","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","0e6d58e0-a7dd-4a2a-bc4f-60c585e145d8","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE ENERO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K6*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ENERO","01","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L196-038B0952-A4AC-425E-91C0-9D1101860B75.xml","2022-01-19T12:17:20","PPD","L","196","01000","I",{"v":247294.58,"d":"247,294.58"},{"v":259400,"d":"259,400.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","038b0952-a4ac-425e-91c0-9d1101860b75","",0,0,"",{"v":259400,"d":"259,400.00"},"1.000000",{"v":259400,"d":"259,400.00"},null,"HONORARIOS DE FEBRERO  DEL 2022. ","NO APLICA","E48",{"v":41504,"d":"41,504.00"},"0.160000","002",{"$f":"K7*0.1","v":{"v":25940,"d":"25,940.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["FEBRERO","02","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L197-34DF2AD6-7D60-4A16-AB37-2059A078C0CA.xml","2022-02-10T15:40:10","PUE","L","197","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","34df2ad6-7d60-4a16-ab37-2059a078c0ca","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE FEBRERO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K8*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["FEBRERO","02","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L198-B2FB4B02-4FA5-4B3F-B95F-29A16FF47634.xml","2022-02-16T12:28:05","PPD","L","198","01000","I",{"v":247294.58,"d":"247,294.58"},{"v":259400,"d":"259,400.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","b2fb4b02-4fa5-4b3f-b95f-29a16ff47634","",0,0,"",{"v":259400,"d":"259,400.00"},"1.000000",{"v":259400,"d":"259,400.00"},null,"A CUENTA DE HONORARIOS DE MARZO  DEL 2022. ","NO APLICA","E48",{"v":41504,"d":"41,504.00"},"0.160000","002",{"$f":"K9*0.1","v":{"v":25940,"d":"25,940.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["FEBRERO","02","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L199-D62FF82E-E1BA-47E3-A5F9-8229DFF5EBB3.xml","2022-02-21T16:33:23",{"$error":"#VALUE!"},"L","199","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","d62ff82e-e1ba-47e3-a5f9-8229dff5ebb3",5,"04","e4da75fc-64bc-49a4-864a-fe4d7f56ce1e","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":247294.58,"d":"247,294.58"},"2022-02-14T12:00:00","1",{"v":247294.58,"d":"247,294.58"},{"v":247294.58,"d":"247,294.58"},0,"e4da75fc-64bc-49a4-864a-fe4d7f56ce1e"]
["FEBRERO","02","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L200-147CB602-5B5E-415C-8162-ED054A0EAEDC.xml","2022-02-27T19:10:24",{"$error":"#VALUE!"},"L","200","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","147cb602-5b5e-415c-8162-ed054a0eaedc","","04","038b0952-a4ac-425e-91c0-9d1101860b75","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":247294.58,"d":"247,294.58"},"2022-02-25T12:00:00","1",{"v":247294.58,"d":"247,294.58"},{"v":247294.58,"d":"247,294.58"},0,"038b0952-a4ac-425e-91c0-9d1101860b75"]
["MARZO","03","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L201-EC264974-B610-48AC-B3BC-48C93B7A1251.xml","2022-03-09T18:41:52","PUE","L","201","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","ec264974-b610-48ac-b3bc-48c93b7a1251","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE MARZO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K12*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","03","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L202-05AC2E9D-1FFE-4944-9E8A-B123CDD9A708.xml","2022-03-16T10:59:08",{"$error":"#VALUE!"},"L","202","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","05ac2e9d-1ffe-4944-9e8a-b123cdd9a708","","04","b2fb4b02-4fa5-4b3f-b95f-29a16ff47634","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":247294.58,"d":"247,294.58"},"2022-03-11T12:00:00","1",{"v":247294.58,"d":"247,294.58"},{"v":247294.58,"d":"247,294.58"},0,"b2fb4b02-4fa5-4b3f-b95f-29a16ff47634"]
["MARZO","03","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L203-93981F4D-D413-4304-8F78-5479DCA74B13.xml","2022-03-16T11:06:49","PPD","L","203","01000","I",{"v":247294.58,"d":"247,294.58"},{"v":259400,"d":"259,400.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","93981f4d-d413-4304-8f78-5479dca74b13","",0,0,"",{"v":259400,"d":"259,400.00"},"1.000000",{"v":259400,"d":"259,400.00"},null,"A CUENTA DE HONORARIOS DE ABRIL  DEL 2022. ","NO APLICA","E48",{"v":41504,"d":"41,504.00"},"0.160000","002",{"$f":"K14*0.1","v":{"v":25940,"d":"25,940.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","03","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L204-11E6AB0D-DE96-46E0-BB2E-C1B2B6702C31.xml",{"$f":"COMPROBANTE($C15,D$4)","v":"2022-03-23T13:57:20"},"PPD","L","204","01000","I",{"v":18003.05,"d":"18,003.05"},{"v":18884.32,"d":"18,884.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","11e6ab0d-de96-46e0-bb2e-c1b2b6702c31","",0,0,"",{"v":18884.32,"d":"18,884.32"},"1.000000",{"v":18884.32,"d":"18,884.32"},null,"COMPLEMENTO DE HONORARIOS DE MARZO  DEL 2022. ","NO APLICA","E48",{"v":3021.49,"d":"3,021.49"},"0.160000","002",{"$f":"K15*0.1","v":{"v":1888.432,"d":"1,888.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","03","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L205-B49E6F80-0727-4AD0-B987-0B45F2D64A16.xml","2022-03-23T16:02:38","PPD","L","205","01000","I",{"v":18003.05,"d":"18,003.05"},{"v":18884.32,"d":"18,884.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","b49e6f80-0727-4ad0-b987-0b45f2d64a16","",0,0,"",{"v":18884.32,"d":"18,884.32"},"1.000000",{"v":18884.32,"d":"18,884.32"},null,"COMPLEMENTO DE HONORARIOS DE ABRIL  DEL 2022. ","NO APLICA","E48",{"v":3021.49,"d":"3,021.49"},"0.160000","002",{"$f":"K16*0.1","v":{"v":1888.432,"d":"1,888.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","04","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L206-7B13F21E-A16E-49F9-B207-8E6D1E9504A9.xml","2022-04-08T12:52:44","PUE","L","206","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","7b13f21e-a16e-49f9-b207-8e6d1e9504a9","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE ABRIL 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K17*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","04","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\7B13F21E-A16E-49F9-B207-8E6D1E9504A9.xml","2022-04-08T12:52:44","PUE","L","206","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","7b13f21e-a16e-49f9-b207-8e6d1e9504a9","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE ABRIL 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K18*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","04","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\94F0AFDC-1677-4843-AFD8-A76C9D365643.xml","2022-04-20T14:11:30",{"$error":"#VALUE!"},"L","208","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","94f0afdc-1677-4843-afd8-a76c9d365643","","04","b49e6f80-0727-4ad0-b987-0b45f2d64a16","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-04-12T12:00:00","1",{"v":18003.05,"d":"18,003.05"},{"v":18003.05,"d":"18,003.05"},0,"b49e6f80-0727-4ad0-b987-0b45f2d64a16"]
["ABRIL","04","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\113ECC33-CC66-4798-9D5E-8DE4748F0C1B.xml","2022-04-20T14:01:19",{"$error":"#VALUE!"},"L","207","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","113ecc33-cc66-4798-9d5e-8de4748f0c1b","","04","11e6ab0d-de96-46e0-bb2e-c1b2b6702c31","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":18003.05,"d":"18,003.05"},"2022-04-12T12:00:00","1",{"v":18003.05,"d":"18,003.05"},{"v":18003.05,"d":"18,003.05"},0,"11e6ab0d-de96-46e0-bb2e-c1b2b6702c31"]
["ABRIL","04","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\E17B9F09-4FB4-4487-9E62-638F69AD17C3.xml","2022-04-20T14:29:38","PPD","L","209","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","e17b9f09-4fb4-4487-9e62-638f69ad17c3","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE MAYO  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K21*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","05","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L210-8A400DE6-A22F-4D3A-8CA2-6D379C1063BC.xml","2022-05-09T18:23:14","PUE","L","210","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA S. DE R.L. DE C.V.","CIM441020BN3","G03","8a400de6-a22f-4d3a-8ca2-6d379c1063bc","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE MAYO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K22*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","05","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L211-A72C16F2-0BC1-45C3-AFD5-4D2CB61C3132.xml","2022-05-17T11:06:39","PPD","L","211","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","a72c16f2-0bc1-45c3-afd5-4d2cb61c3132","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE JUNIO  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K23*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","05","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L212-CANC. .xml","2022-05-18T11:36:40",{"$error":"#VALUE!"},"L","212","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","c8e468bf-515c-48f9-a91b-b60baaa872f7","","04","e17b9f09-4fb4-4487-9e62-638f69ad17c3","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-05-09T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"e17b9f09-4fb4-4487-9e62-638f69ad17c3"]
["MAYO","05","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L213-D8561010-9331-4BD7-A550-F599FC56998C.xml",{"$f":"COMPROBANTE($C25,D$4)","v":"2022-05-23T11:23:05"},{"$error":"#VALUE!"},"L","213","01000","P",{"$f":"VALUE(COMPROBANTE($C25,J$4))","v":0},0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",{"$f":"RECEPTOR($C25,O$4)","v":"BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B"},"BMN930209927","P01","d8561010-9331-4bd7-a550-f599fc56998c","","04","e17b9f09-4fb4-4487-9e62-638f69ad17c3","",0,"1",0,null,"Pago",{"$f":"CONCEPTOS($C25,AB$4)","v":{"$error":"#VALUE!"}},"ACT",0,{"$f":"IMPUESTOS($C25,AE$4)","v":0},0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-05-06T12:00:00","1",{"$f":"VALUE(CFDIPDOCTORELACIONADO($C25,AM$4))","v":{"v":265297.63,"d":"265,297.63"}},{"v":265297.63,"d":"265,297.63"},0,"e17b9f09-4fb4-4487-9e62-638f69ad17c3"]
["JUNIO","06","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L214-D6964E13-2CD1-4C9B-8F37-B91CA2AA5C6B.xml","2022-06-08T11:41:02","PUE","L","214","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","d6964e13-2cd1-4c9b-8f37-b91ca2aa5c6b","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE JUNIO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K26*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JUNIO","06","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L215-7CBDB2E0-B16D-4BB9-B024-1E7E38B614DB.xml","2022-06-15T12:28:09",{"$error":"#VALUE!"},"L","215","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","7cbdb2e0-b16d-4bb9-b024-1e7e38b614db","","04","a72c16f2-0bc1-45c3-afd5-4d2cb61c3132","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-06-10T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"a72c16f2-0bc1-45c3-afd5-4d2cb61c3132"]
["JUNIO","06","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L216-902C13FE-3094-4E4E-8606-6EF45FE613B6.xml","2022-06-15T12:35:10","PPD","L","216","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","902c13fe-3094-4e4e-8606-6ef45fe613b6","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE JULIO  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K28*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JULIO","07","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\5D27FA6F-2C80-4497-8A93-AA88E858621E.xml","2022-07-06T12:35:24","PUE","L","217","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","5d27fa6f-2c80-4497-8a93-aa88e858621e","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE JULIO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K29*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JULIO","07","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\9ABB9958-68A2-4AD6-9EE6-C8119A65B9D0.xml","2022-07-12T16:13:01",{"$error":"#VALUE!"},"L","218","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","9abb9958-68a2-4ad6-9ee6-c8119a65b9d0","","04","902c13fe-3094-4e4e-8606-6ef45fe613b6","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-07-08T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"902c13fe-3094-4e4e-8606-6ef45fe613b6"]
["JULIO","07","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\B7BDAA88-CB56-4BB1-9C71-238727A882C6.xml","2022-07-14T16:28:43","PPD","L","219","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","b7bdaa88-cb56-4bb1-9c71-238727a882c6","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE AGOSTO  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K31*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["AGOSTO","08","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L220-C0CCA26A-96BD-4E3A-9D2D-99F1BCD8FAF5.xml","2022-08-08T14:12:43","PUE","L","220","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","c0cca26a-96bd-4e3a-9d2d-99f1bcd8faf5","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE AGOSTO 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K32*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["AGOSTO","08","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L221-536FB97D-792D-4034-8936-DF6932870AF8.xml","2022-08-09T11:36:16",{"$error":"#VALUE!"},"L","221","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","536fb97d-792d-4034-8936-df6932870af8","","04","b7bdaa88-cb56-4bb1-9c71-238727a882c6","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-08-03T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"b7bdaa88-cb56-4bb1-9c71-238727a882c6"]
["AGOSTO","08","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L222-441BD760-F179-4D7C-9588-3B2B7CCAEBC4.xml","2022-08-16T13:41:31","PPD","L","222","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","441bd760-f179-4d7c-9588-3b2b7ccaebc4","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE SEPTIEMBRE  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K34*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["SEPTIEMBRE","09","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\3DB21F49-5A5D-4F36-89BE-A05AF61595A2.xml",{"$f":"COMPROBANTE($C35,D$4)","v":"2022-09-13T15:18:18"},"PPD","L","225","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","3db21f49-5a5d-4f36-89be-a05af61595a2","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE OCTUBRE  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K35*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["SEPTIEMBRE","09","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\9B5C294F-8A9C-4CBB-B26D-230D5F503B81.xml","2022-09-13T15:09:12",{"$error":"#VALUE!"},"L","224","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","9b5c294f-8a9c-4cbb-b26d-230d5f503b81","","04","441bd760-f179-4d7c-9588-3b2b7ccaebc4","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-09-07T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"441bd760-f179-4d7c-9588-3b2b7ccaebc4"]
["SEPTIEMBRE","09","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\F16044C5-B867-4374-A6CE-1FC96BA49DBC.xml","2022-09-13T14:59:05","PUE","L","223","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","f16044c5-b867-4374-a6ce-1fc96ba49dbc","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE SEPTIEMBRE 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K37*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["OCTUBRE","10","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L226-7DA4F487-F25D-4918-9295-5EA85C5BA953.xml","2022-10-06T11:43:41","PUE","L","226","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","7da4f487-f25d-4918-9295-5ea85c5ba953","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE OCTUBRE 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K38*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["OCTUBRE","10","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L227-362232FC-64F8-42EE-AA9B-C001378FD485.xml","2022-10-13T15:40:51",{"$error":"#VALUE!"},"L","227","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","362232fc-64f8-42ee-aa9b-c001378fd485","","04","3db21f49-5a5d-4f36-89be-a05af61595a2","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-10-05T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"3db21f49-5a5d-4f36-89be-a05af61595a2"]
["OCTUBRE","10","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L228-35F33721-893D-41D9-80BC-42DCD4BEC745.xml","2022-10-13T15:44:45","PPD","L","228","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","35f33721-893d-41d9-80bc-42dcd4bec745","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS POR DERECHOS DE AUTOR DE NOVIEMBRE  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K40*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","11","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L229-02C68F1A-EF44-4A89-AD3A-355C5D687613.xml","2022-11-01T10:26:54","PPD","L","229","01000","I",{"v":265297.63,"d":"265,297.63"},{"v":278284.32,"d":"278,284.32"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","G03","02c68f1a-ef44-4a89-ad3a-355c5d687613","",0,0,"",{"v":278284.32,"d":"278,284.32"},"1.000000",{"v":278284.32,"d":"278,284.32"},null,"HONORARIOS DE DICIEMBRE  DEL 2022. ","NO APLICA","E48",{"v":44525.49,"d":"44,525.49"},"0.160000","002",{"$f":"K41*0.1","v":{"v":27828.432,"d":"27,828.43"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","11","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L230-C06D0AE2-1206-4221-9FAB-38EAD78CC3D0.xml","2022-11-07T12:28:13","PUE","L","230","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","c06d0ae2-1206-4221-9fab-38ead78cc3d0","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"HONORARIOS DE NOVIEMBRE 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K42*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","11","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L231-9278B3E0-E210-4200-B13F-AE92F29DEC6C.xml","2022-11-30T15:47:09",{"$error":"#VALUE!"},"L","231","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","9278b3e0-e210-4200-b13f-ae92f29dec6c","","04","35f33721-893d-41d9-80bc-42dcd4bec745","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-11-29T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"35f33721-893d-41d9-80bc-42dcd4bec745"]
["DICIEMBRE","12","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L232-5E4BF1C6-E0FE-473E-B51D-3AC6D0FCCB53.xml","2022-12-06T12:20:53","PUE","L","232","01000","I",{"v":374516.87,"d":"374,516.87"},{"v":392850,"d":"392,850.00"},612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","COMERCIAL IMPORTADORA, S. DE R.L. DE C.V.","CIM441020BN3","G03","5e4bf1c6-e0fe-473e-b51d-3ac6d0fccb53","",0,0,"",{"v":392850,"d":"392,850.00"},"1.000000",{"v":392850,"d":"392,850.00"},null,"A CUENTA DE HONORARIOS DE DICIEMBRE 2022,  ","NO APLICA","E48",{"v":62856,"d":"62,856.00"},"0.160000","002",{"$f":"K44*0.1","v":{"v":39285,"d":"39,285.00"}},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (derechos de autor)"]
["DICIEMBRE","12","D:\\RTB\\USB-Verde-Plata\\DeclaracionAnual-PF-2022\\CaFiCon\\CasoPractico-PP-ActProf-2022\\XML-2022\\HAHL5702271P2-L233-34B95E20-75F9-4DE9-B47D-BD0875FEE073.xml","2022-12-21T19:19:46",{"$error":"#VALUE!"},"L","233","01000","P",0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA","BANCO MERCANTIL DEL NORTE S.A. INSTITUCION DE BANCA MULTIPLE G.F.B","BMN930209927","P01","34b95e20-75f9-4de9-b47d-bd0875fee073","","04","02c68f1a-ef44-4a89-ad3a-355c5d687613","",0,"1",0,null,"Pago",{"$error":"#VALUE!"},"ACT",0,0,0,{"$nulls":3},{"v":265297.63,"d":"265,297.63"},"2022-12-16T12:00:00","1",{"v":265297.63,"d":"265,297.63"},{"v":265297.63,"d":"265,297.63"},0,"02c68f1a-ef44-4a89-ad3a-355c5d687613"]
[{"$nulls":9},{"$f":"SUBTOTAL(9,J5:J45)","v":{"v":3147565.4599999995,"d":"3,147,565.46"}},{"$f":"SUBTOTAL(9,K5:K45)","v":{"v":3301643.1999999997,"d":"3,301,643.20"}},{"$nulls":11},{"$f":"SUBTOTAL(9,W5:W45)","v":{"v":3301643.1999999997,"d":"3,301,643.20"}},{"$nulls":6},{"$f":"SUBTOTAL(9,AD5:AD45)","v":{"v":528262.8999999999,"d":"528,262.90"}},null,null,{"$f":"SUBTOTAL(9,AG5:AG45)","v":{"v":330164.32000000007,"d":"330,164.32"}}]

{"sheet":"XML ENE-DIC-2022 respaldo","index":2,"n_rows":46,"n_cols":43,"rows_kept":46,"merged":[[2,3,2,10],[2,11,2,13],[2,14,2,16],[2,22,2,28],[2,29,2,31],[2,32,2,34],[2,35,2,36],[2,37,2,41]]}
[]
[]
[{"$nulls":3},"COMPROBANTE",{"$nulls":7},"EMISOR",null,null,"RECEPTOR",null,null,"UUID",null,"TIPORELACION","CFDIRELACIONADO",null,"CONCEPTOS",{"$nulls":6},"IMPUESTOS",null,null,"IMPUESTOS RETENIDOS",null,null,"CFDIPAGO",null,"CFDIPDOCTORELACIONADO"]
["Mes","Num Mes","Ruta de Acceso a XML","Fecha","MetodoPago","Serie","Folio","LugarExpedicion","TipoDeComprobante","Total","SubTotal","RegimenFiscal","Rfc","Nombre","Nombre","Rfc","UsoCFDI","UUID","COINC EGR Vs ING","TipoRelacion","UUID","COINC ING Vs EGR","Importe","Cantidad","ValorUnitario","ClaveProdServ","Descripcion","Unidad","ClaveUnidad","Importe","TasaOCuota","Impuesto","Importe","TasaOCuota","Impuesto","Monto","FechaPago","NumParcialidad","ImpSaldoAnt","ImpPagado","ImpSaldoInsoluto","IdDocumento","Catalogo Ingresos"]
["D:\\RTB\\USB-Verde-Plata\\LigiaHasbun\\EjercicioFiscal-2023\\PagosProvisionales-2023\\02-23\\CFDI-Ligia\\Obtenidas-PaginaSAT\\73EAD20B-3BFC-4FD0-96EF-734805E42F23.xml",{"$f":"MID(D5,6,2)","v":""},null,{"$f":"COMPROBANTE($C5,D$4)","v":0},0,0,0,0,0,{"$f":"VALUE(COMPROBANTE($C5,J$4))","v":0},0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",{"$f":"RECEPTOR($C5,O$4)","v":0},0,0,{"$f":"UUID($C5,R$4)","v":0},{"$f":"IFERROR(MATCH(U5,$R$5:$R$5,0)+4,\"\")","v":5},{"$f":"TIPORELACION($C5,T$4)","v":0},{"$f":"CFDIRELACIONADO($C5,U$4)","v":0},{"$f":"IFERROR(MATCH(R5,$U$5:$U$5,0)+4,\"\")","v":5},{"$f":"VALUE(CONCEPTOS($C5,W$4))","v":0},{"$f":"CONCEPTOS($C5,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C5,Y$4))","v":0},null,"HONORARIOS DE ENERO  DEL 2022. ",{"$f":"CONCEPTOS($C5,AB$4)","v":0},0,{"$f":"VALUE(IMPUESTOS($C5,AD$4))","v":0},{"$f":"IMPUESTOS($C5,AE$4)","v":0},0,{"$f":"K5*0.1","v":0},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C5,AJ$4))","v":0},{"$f":"CFDIPAGO($C5,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C5,AL$4)","v":0},{"$f":"VALUE(CFDIPDOCTORELACIONADO($C5,AM$4))","v":0},0,0,{"$f":"CFDIPDOCTORELACIONADO($C5,AP$4)","v":0},"Servicios profesionales (honorarios)"]
["D:\\RTB\\USB-Verde-Plata\\LigiaHasbun\\EjercicioFiscal-2023\\PagosProvisionales-2023\\02-23\\CFDI-Ligia\\Obtenidas-PaginaSAT\\735EFB13-DC8E-42DE-8E75-82AB60A6D38C.xml","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,{"$f":"UUID($C6,R$4)","v":0},5,{"$f":"TIPORELACION($C6,T$4)","v":0},{"$f":"CFDIRELACIONADO($C6,U$4)","v":0},5,{"$f":"VALUE(CONCEPTOS($C6,W$4))","v":0},{"$f":"CONCEPTOS($C6,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C6,Y$4))","v":0},null,"HONORARIOS DE ENERO 2022,  ",0,0,{"$f":"VALUE(IMPUESTOS($C6,AD$4))","v":0},0,0,{"$f":"K6*0.1","v":0},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C6,AJ$4))","v":0},{"$f":"CFDIPAGO($C6,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C6,AL$4)","v":0},0,0,0,{"$f":"CFDIPDOCTORELACIONADO($C6,AP$4)","v":0},"Servicios profesionales (honorarios)"]
["D:\\RTB\\USB-Verde-Plata\\LigiaHasbun\\EjercicioFiscal-2023\\PagosProvisionales-2023\\02-23\\CFDI-Ligia\\Obtenidas-PaginaSAT\\423856A2-BB4E-4219-883A-829A9AB2F6C5.xml","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,{"$f":"UUID($C7,R$4)","v":0},5,{"$f":"TIPORELACION($C7,T$4)","v":0},{"$f":"CFDIRELACIONADO($C7,U$4)","v":0},5,{"$f":"VALUE(CONCEPTOS($C7,W$4))","v":0},{"$f":"CONCEPTOS($C7,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C7,Y$4))","v":0},null,"HONORARIOS DE FEBRERO  DEL 2022. ",0,0,{"$f":"VALUE(IMPUESTOS($C7,AD$4))","v":0},0,0,{"$f":"K7*0.1","v":0},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C7,AJ$4))","v":0},{"$f":"CFDIPAGO($C7,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C7,AL$4)","v":0},0,0,0,{"$f":"CFDIPDOCTORELACIONADO($C7,AP$4)","v":0},"Servicios profesionales (honorarios)"]
["D:\\RTB\\USB-Verde-Plata\\LigiaHasbun\\EjercicioFiscal-2023\\PagosProvisionales-2023\\02-23\\CFDI-Ligia\\Obtenidas-PaginaSAT\\A7C49884-E6A2-4FD0-A609-A637A8D9B7A0.xml","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,{"$f":"UUID($C8,R$4)","v":0},5,{"$f":"TIPORELACION($C8,T$4)","v":0},{"$f":"CFDIRELACIONADO($C8,U$4)","v":0},5,{"$f":"VALUE(CONCEPTOS($C8,W$4))","v":0},{"$f":"CONCEPTOS($C8,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C8,Y$4))","v":0},null,"HONORARIOS DE FEBRERO 2022,  ",0,0,{"$f":"VALUE(IMPUESTOS($C8,AD$4))","v":0},0,0,{"$f":"K8*0.1","v":0},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C8,AJ$4))","v":0},{"$f":"CFDIPAGO($C8,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C8,AL$4)","v":0},0,0,0,{"$f":"CFDIPDOCTORELACIONADO($C8,AP$4)","v":0},"Servicios profesionales (honorarios)"]
["D:\\RTB\\USB-Verde-Plata\\LigiaHasbun\\EjercicioFiscal-2023\\PagosProvisionales-2023\\02-23\\CFDI-Ligia\\Obtenidas-PaginaSAT\\EDF447B2-FB73-4494-AE2C-DFDB73D2C39D.xml","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,{"$f":"UUID($C9,R$4)","v":0},5,{"$f":"TIPORELACION($C9,T$4)","v":0},{"$f":"CFDIRELACIONADO($C9,U$4)","v":0},5,{"$f":"VALUE(CONCEPTOS($C9,W$4))","v":0},{"$f":"CONCEPTOS($C9,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C9,Y$4))","v":0},null,"A CUENTA DE HONORARIOS DE MARZO  DEL 2022. ",0,0,{"$f":"VALUE(IMPUESTOS($C9,AD$4))","v":0},0,0,{"$f":"K9*0.1","v":0},{"v":0.1,"d":"0.10"},"001",{"$f":"VALUE(CFDIPAGO($C9,AJ$4))","v":0},{"$f":"CFDIPAGO($C9,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C9,AL$4)","v":0},0,0,0,{"$f":"CFDIPDOCTORELACIONADO($C9,AP$4)","v":0},"Servicios profesionales (honorarios)"]
["FEBRERO","",null,{"$f":"COMPROBANTE($C10,D$4)","v":0},0,0,0,0,0,{"$f":"VALUE(COMPROBANTE($C10,J$4))","v":0},0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",{"$f":"RECEPTOR($C10,O$4)","v":0},0,0,{"$f":"UUID($C10,R$4)","v":0},5,{"$f":"TIPORELACION($C10,T$4)","v":0},{"$f":"CFDIRELACIONADO($C10,U$4)","v":0},5,{"$f":"VALUE(CONCEPTOS($C10,W$4))","v":0},{"$f":"CONCEPTOS($C10,X$4)","v":0},{"$f":"VALUE(CONCEPTOS($C10,Y$4))","v":0},null,"Pago",{"$f":"CONCEPTOS($C10,AB$4)","v":0},0,{"$f":"VALUE(IMPUESTOS($C10,AD$4))","v":0},{"$f":"IMPUESTOS($C10,AE$4)","v":0},0,{"$nulls":3},{"$f":"VALUE(CFDIPAGO($C10,AJ$4))","v":0},{"$f":"CFDIPAGO($C10,AK$4)","v":0},{"$f":"CFDIPDOCTORELACIONADO($C10,AL$4)","v":0},{"$f":"VALUE(CFDIPDOCTORELACIONADO($C10,AM$4))","v":0},0,0,{"$f":"CFDIPDOCTORELACIONADO($C10,AP$4)","v":0}]
["FEBRERO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["MARZO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE MARZO 2022,  ",0,0,0,0,0,{"$f":"K12*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["MARZO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"A CUENTA DE HONORARIOS DE ABRIL  DEL 2022. ",0,0,0,0,0,{"$f":"K14*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"COMPLEMENTO DE HONORARIOS DE MARZO  DEL 2022. ",0,0,0,0,0,{"$f":"K15*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MARZO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"COMPLEMENTO DE HONORARIOS DE ABRIL  DEL 2022. ",0,0,0,0,0,{"$f":"K16*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE ABRIL 2022,  ",0,0,0,0,0,{"$f":"K17*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE ABRIL 2022,  ",0,0,0,0,0,{"$f":"K18*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["ABRIL","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["ABRIL","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["ABRIL","",null,{"$f":"COMPROBANTE($C21,D$4)","v":0},0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE MAYO  DEL 2022. ",0,0,0,0,0,{"$f":"K21*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE MAYO 2022,  ",0,0,0,0,0,{"$f":"K22*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE JUNIO  DEL 2022. ",0,0,0,0,0,{"$f":"K23*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["MAYO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["MAYO","",null,0,0,0,0,0,0,{"$f":"VALUE(COMPROBANTE($C25,J$4))","v":0},0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",{"$f":"RECEPTOR($C25,O$4)","v":0},0,0,0,5,0,0,5,0,0,0,null,"Pago",{"$f":"CONCEPTOS($C25,AB$4)","v":0},0,0,{"$f":"IMPUESTOS($C25,AE$4)","v":0},0,{"$nulls":3},0,0,0,{"$f":"VALUE(CFDIPDOCTORELACIONADO($C25,AM$4))","v":0},0,0,0]
["JUNIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE JUNIO 2022,  ",0,0,0,0,0,{"$f":"K26*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JUNIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["JUNIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE JULIO  DEL 2022. ",0,0,0,0,0,{"$f":"K28*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JULIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE JULIO 2022,  ",0,0,0,0,0,{"$f":"K29*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["JULIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["JULIO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE AGOSTO  DEL 2022. ",0,0,0,0,0,{"$f":"K31*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["AGOSTO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE AGOSTO 2022,  ",0,0,0,0,0,{"$f":"K32*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["AGOSTO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["AGOSTO","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE SEPTIEMBRE  DEL 2022. ",0,0,0,0,0,{"$f":"K34*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["SEPTIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE OCTUBRE  DEL 2022. ",0,0,0,0,0,{"$f":"K35*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["SEPTIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["SEPTIEMBRE","",null,{"$f":"COMPROBANTE($C37,D$4)","v":0},0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE SEPTIEMBRE 2022,  ",0,0,0,0,0,{"$f":"K37*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["OCTUBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE OCTUBRE 2022,  ",0,0,0,0,0,{"$f":"K38*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["OCTUBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["OCTUBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS POR DERECHOS DE AUTOR DE NOVIEMBRE  DEL 2022. ",0,0,0,0,0,{"$f":"K40*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE DICIEMBRE  DEL 2022. ",0,0,0,0,0,{"$f":"K41*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"HONORARIOS DE NOVIEMBRE 2022,  ",0,0,0,0,0,{"$f":"K42*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["NOVIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
["DICIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"A CUENTA DE HONORARIOS DE DICIEMBRE 2022,  ",0,0,0,0,0,{"$f":"K44*0.1","v":0},{"v":0.1,"d":"0.10"},"001",0,0,0,0,0,0,0,"Servicios profesionales (honorarios)"]
["DICIEMBRE","",null,0,0,0,0,0,0,0,0,612,"HEHL800510ABC","LIDIA HERNANDEZ HUERTA",0,0,0,0,5,0,0,5,0,0,0,null,"Pago",0,0,0,0,0,{"$nulls":3},0,0,0,0,0,0,0]
[{"$nulls":9},{"$f":"SUBTOTAL(9,J5:J45)","v":0},{"$f":"SUBTOTAL(9,K5:K45)","v":0},{"$nulls":11},{"$f":"SUBTOTAL(9,W5:W45)","v":0},{"$nulls":6},{"$f":"SUBTOTAL(9,AD5:AD45)","v":0},null,null,{"$f":"SUBTOTAL(9,AG5:AG45)","v":0}]

{"sheet":"CatalogoIngresos","index":3,"n_rows":14,"n_cols":2,"rows_kept":14}
["Catalogo Ingresos"]
["Ingresos propios  de la actividad nacionales",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A2,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Ingresos propios  de la actividad extranjeros",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A3,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Ingresos exclusivos por autotransporte de carga federal",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A4,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Ganancia en la enajenación de acciones o por reembolso de capital",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A5,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Ganancia en la enajenación de terrenos y activo fijo",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A6,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Anticipo de clientes",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A7,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Intereses cobrados sin ajuste alguno y ganancia cambiaria relacionados con actividades propias",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A8,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Servicios de transporte terrestre de pasajeros y de entrega de bienes",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A9,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Servicios de hospedaje",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A10,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Enajenación de bienes y prestación de servicios",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A11,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":0}]
["Servicios profesionales (honorarios)",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A12,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":{"v":7756443.200000001,"d":"7,756,443.20"}}]
["Servicios profesionales (derechos de autor)",{"$f":"SUMIF('XML ENE-DIC-2022 CASO'!$AQ$5:$AQ$45,CatalogoIngresos!A13,'XML ENE-DIC-2022 CASO'!$K$5:$K$45)","v":{"v":652250,"d":"652,250.00"}}]
[null,{"$f":"SUM(B2:B13)","v":{"v":8408693.200000001,"d":"8,408,693.20"}}]

{"sheet":"TARIFAS 2022","index":4,"n_rows":120,"n_cols":10,"rows_kept":120,"merged":[[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[20,1,20,4],[20,6,20,9],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[37,1,37,4],[37,6,37,9],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[54,1,54,4],[54,6,54,9],[55,1,56,1],[55,2,56,2],[55,3,56,3],[55,4,56,4],[55,6,56,6],[55,7,56,7],[55,8,56,8],[55,9,56,9],[71,1,71,4],[71,6,71,9],[72,1,73,1],[72,2,73,2],[72,3,73,3],[72,4,73,4],[72,6,73,6],[72,7,73,7],[72,8,73,8],[72,9,73,9],[88,1,88,4],[88,6,88,9],[89,1,90,1],[89,2,90,2],[89,3,90,3],[89,4,90,4],[89,6,90,6],[89,7,90,7],[89,8,90,8],[89,9,90,9],[105,1,105,4],[105,6,105,9],[106,1,107,1],[106,2,107,2],[106,3,107,3],[106,4,107,4],[106,6,107,6],[106,7,107,7],[106,8,107,8],[106,9,107,9]]}
[]
[]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%"]
[null,0.01,{"v":6942.2,"d":"6,942.20"},0,0.0192,null,0.01,{"v":6942.2,"d":"6,942.20"},0,1.92]
[null,{"v":6942.21,"d":"6,942.21"},{"v":58922.16,"d":"58,922.16"},133.28,{"v":0.064,"d":"0.0640"},null,{"v":6942.21,"d":"6,942.21"},{"v":58922.16,"d":"58,922.16"},133.28,6.4]
[null,{"v":58922.17,"d":"58,922.17"},{"v":103550.44,"d":"103,550.44"},{"v":3460.01,"d":"3,460.01"},0.1088,null,{"v":58922.17,"d":"58,922.17"},{"v":103550.44,"d":"103,550.44"},{"v":3460.01,"d":"3,460.01"},10.88]
[null,{"v":103550.45,"d":"103,550.45"},{"v":120372.83,"d":"120,372.83"},{"v":8315.57,"d":"8,315.57"},{"v":0.16,"d":"0.1600"},null,{"v":103550.45,"d":"103,550.45"},{"v":120372.83,"d":"120,372.83"},{"v":8315.57,"d":"8,315.57"},16]
[null,{"v":120372.84,"d":"120,372.84"},{"v":144119.23,"d":"144,119.23"},{"v":11007.14,"d":"11,007.14"},0.1792,null,{"v":120372.84,"d":"120,372.84"},{"v":144119.23,"d":"144,119.23"},{"v":11007.14,"d":"11,007.14"},17.92]
[null,{"v":144119.24,"d":"144,119.24"},{"v":290667.75,"d":"290,667.75"},{"v":15262.49,"d":"15,262.49"},0.2136,null,{"v":144119.24,"d":"144,119.24"},{"v":290667.75,"d":"290,667.75"},{"v":15262.49,"d":"15,262.49"},21.36]
[null,{"v":290667.76,"d":"290,667.76"},{"v":458132.29,"d":"458,132.29"},{"v":46565.26,"d":"46,565.26"},0.2352,null,{"v":290667.76,"d":"290,667.76"},{"v":458132.29,"d":"458,132.29"},{"v":46565.26,"d":"46,565.26"},23.52]
[null,{"v":458132.3,"d":"458,132.30"},{"v":874650,"d":"874,650.00"},{"v":85952.92,"d":"85,952.92"},{"v":0.3,"d":"0.3000"},null,{"v":458132.3,"d":"458,132.30"},{"v":874650,"d":"874,650.00"},{"v":85952.92,"d":"85,952.92"},30]
[null,{"v":874650.01,"d":"874,650.01"},{"v":1166200,"d":"1,166,200.00"},{"v":210908.23,"d":"210,908.23"},{"v":0.32,"d":"0.3200"},null,{"v":874650.01,"d":"874,650.01"},{"v":1166200,"d":"1,166,200.00"},{"v":210908.23,"d":"210,908.23"},32]
[null,{"v":1166200.01,"d":"1,166,200.01"},{"v":3498600,"d":"3,498,600.00"},{"v":304204.21,"d":"304,204.21"},{"v":0.34,"d":"0.3400"},null,{"v":1166200.01,"d":"1,166,200.01"},{"v":3498600,"d":"3,498,600.00"},{"v":304204.21,"d":"304,204.21"},34]
[null,{"v":3498600.01,"d":"3,498,600.01"},"En adelante",{"v":1097220.21,"d":"1,097,220.21"},{"v":0.35,"d":"0.3500"},null,{"v":3498600.01,"d":"3,498,600.01"},"En adelante",{"v":1097220.21,"d":"1,097,220.21"},35]
[]
[]
[null,"Tarifa para el cáculo de los pagos provisionales del ejercicio 2022"]
[]
[null,"Tarifa: pago provisional de enero 2022",{"$nulls":4},"Tarifa: pago provisional de febrero 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,578.52,0,0.0192,null,0.01,1157.04,0,0.0192]
[null,578.53,{"v":4910.18,"d":"4,910.18"},11.11,{"v":0.064,"d":"0.0640"},null,1157.05,{"v":9820.36,"d":"9,820.36"},22.22,{"v":0.064,"d":"0.0640"}]
[null,{"v":4910.19,"d":"4,910.19"},{"v":8629.2,"d":"8,629.20"},288.33,0.1088,null,{"v":9820.37,"d":"9,820.37"},{"v":17258.4,"d":"17,258.40"},576.66,0.1088]
[null,{"v":8629.21,"d":"8,629.21"},{"v":10031.07,"d":"10,031.07"},692.96,{"v":0.16,"d":"0.1600"},null,{"v":17258.41,"d":"17,258.41"},{"v":20062.14,"d":"20,062.14"},{"v":1385.92,"d":"1,385.92"},{"v":0.16,"d":"0.1600"}]
[null,{"v":10031.08,"d":"10,031.08"},{"v":12009.94,"d":"12,009.94"},917.26,0.1792,null,{"v":20062.15,"d":"20,062.15"},{"v":24019.88,"d":"24,019.88"},{"v":1834.52,"d":"1,834.52"},0.1792]
[null,{"v":12009.95,"d":"12,009.95"},{"v":24222.31,"d":"24,222.31"},{"v":1271.87,"d":"1,271.87"},0.2136,null,{"v":24019.89,"d":"24,019.89"},{"v":48444.62,"d":"48,444.62"},{"v":2543.74,"d":"2,543.74"},0.2136]
[null,{"v":24222.32,"d":"24,222.32"},{"v":38177.69,"d":"38,177.69"},{"v":3880.44,"d":"3,880.44"},0.2352,null,{"v":48444.63,"d":"48,444.63"},{"v":76355.38,"d":"76,355.38"},{"v":7760.88,"d":"7,760.88"},0.2352]
[null,{"v":38177.7,"d":"38,177.70"},{"v":72887.5,"d":"72,887.50"},{"v":7162.74,"d":"7,162.74"},{"v":0.3,"d":"0.3000"},null,{"v":76355.39,"d":"76,355.39"},{"v":145775,"d":"145,775.00"},{"v":14325.48,"d":"14,325.48"},{"v":0.3,"d":"0.3000"}]
[null,{"v":72887.51,"d":"72,887.51"},{"v":97183.33,"d":"97,183.33"},{"v":17575.69,"d":"17,575.69"},{"v":0.32,"d":"0.3200"},null,{"v":145775.01,"d":"145,775.01"},{"v":194366.66,"d":"194,366.66"},{"v":35151.38,"d":"35,151.38"},{"v":0.32,"d":"0.3200"}]
[null,{"v":97183.34,"d":"97,183.34"},{"v":291550,"d":"291,550.00"},{"v":25350.35,"d":"25,350.35"},{"v":0.34,"d":"0.3400"},null,{"v":194366.67,"d":"194,366.67"},{"v":583100,"d":"583,100.00"},{"v":50700.7,"d":"50,700.70"},{"v":0.34,"d":"0.3400"}]
[null,{"v":291550.01,"d":"291,550.01"},"En adelante",{"v":91435.02,"d":"91,435.02"},{"v":0.35,"d":"0.3500"},null,{"v":583100.01,"d":"583,100.01"},"En adelante",{"v":182870.04,"d":"182,870.04"},{"v":0.35,"d":"0.3500"}]
[]
[]
[null,"Tarifa: pago provisional de marzo 2022",{"$nulls":4},"Tarifa: pago provisional de abril 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,{"v":1735.56,"d":"1,735.56"},0,0.0192,null,0.01,2314.08,0,0.0192]
[null,{"v":1735.57,"d":"1,735.57"},{"v":14730.54,"d":"14,730.54"},33.33,{"v":0.064,"d":"0.0640"},null,{"v":2314.09,"d":"2,314.09"},{"v":19640.72,"d":"19,640.72"},44.44,{"v":0.064,"d":"0.0640"}]
[null,{"v":14730.550000000001,"d":"14,730.55"},{"v":25887.600000000002,"d":"25,887.60"},864.99,0.1088,null,{"v":19640.73,"d":"19,640.73"},{"v":34516.8,"d":"34,516.80"},1153.32,0.1088]
[null,{"v":25887.61,"d":"25,887.61"},{"v":30093.21,"d":"30,093.21"},{"v":2078.88,"d":"2,078.88"},{"v":0.16,"d":"0.1600"},null,{"v":34516.810000000005,"d":"34,516.81"},{"v":40124.28,"d":"40,124.28"},{"v":2771.84,"d":"2,771.84"},{"v":0.16,"d":"0.1600"}]
[null,{"v":30093.219999999998,"d":"30,093.22"},{"v":36029.82,"d":"36,029.82"},{"v":2751.7799999999997,"d":"2,751.78"},0.1792,null,{"v":40124.29,"d":"40,124.29"},{"v":48039.76,"d":"48,039.76"},{"v":3669.04,"d":"3,669.04"},0.1792]
[null,{"v":36029.83,"d":"36,029.83"},{"v":72666.93000000001,"d":"72,666.93"},{"v":3815.6099999999997,"d":"3,815.61"},0.2136,null,{"v":48039.770000000004,"d":"48,039.77"},{"v":96889.24,"d":"96,889.24"},{"v":5087.48,"d":"5,087.48"},0.2136]
[null,{"v":72666.94,"d":"72,666.94"},{"v":114533.07,"d":"114,533.07"},{"v":11641.32,"d":"11,641.32"},0.2352,null,{"v":96889.25,"d":"96,889.25"},{"v":152710.76,"d":"152,710.76"},{"v":15521.76,"d":"15,521.76"},0.2352]
[null,{"v":114533.08,"d":"114,533.08"},{"v":218662.5,"d":"218,662.50"},{"v":21488.22,"d":"21,488.22"},{"v":0.3,"d":"0.3000"},null,{"v":152710.77000000002,"d":"152,710.77"},{"v":291550,"d":"291,550.00"},{"v":28650.96,"d":"28,650.96"},{"v":0.3,"d":"0.3000"}]
[null,{"v":218662.51,"d":"218,662.51"},{"v":291549.99,"d":"291,549.99"},{"v":52727.06999999999,"d":"52,727.07"},{"v":0.32,"d":"0.3200"},null,{"v":291550.01,"d":"291,550.01"},{"v":388733.32,"d":"388,733.32"},{"v":70302.76,"d":"70,302.76"},{"v":0.32,"d":"0.3200"}]
[null,{"v":291550,"d":"291,550.00"},{"v":874650,"d":"874,650.00"},{"v":76051.04999999999,"d":"76,051.05"},{"v":0.34,"d":"0.3400"},null,{"v":388733.33,"d":"388,733.33"},{"v":1166200,"d":"1,166,200.00"},{"v":101401.4,"d":"101,401.40"},{"v":0.34,"d":"0.3400"}]
[null,{"v":874650.01,"d":"874,650.01"},"En adelante",{"v":274305.06,"d":"274,305.06"},{"v":0.35,"d":"0.3500"},null,{"v":1166200.01,"d":"1,166,200.01"},"En adelante",{"v":365740.08,"d":"365,740.08"},{"v":0.35,"d":"0.3500"}]
[]
[]
[null,"Tarifa: pago provisional de mayo 2022",{"$nulls":4},"Tarifa: pago provisional de junio 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,{"v":2892.6,"d":"2,892.60"},0,0.0192,null,0.01,{"v":3471.12,"d":"3,471.12"},0,0.0192]
[null,{"v":2892.61,"d":"2,892.61"},{"v":24550.9,"d":"24,550.90"},55.55,{"v":0.064,"d":"0.0640"},null,{"v":3471.13,"d":"3,471.13"},{"v":29461.08,"d":"29,461.08"},66.66,{"v":0.064,"d":"0.0640"}]
[null,{"v":24550.91,"d":"24,550.91"},{"v":43146,"d":"43,146.00"},{"v":1441.6499999999999,"d":"1,441.65"},0.1088,null,{"v":29461.09,"d":"29,461.09"},{"v":51775.200000000004,"d":"51,775.20"},{"v":1729.98,"d":"1,729.98"},0.1088]
[null,{"v":43146.01,"d":"43,146.01"},{"v":50155.35,"d":"50,155.35"},{"v":3464.8,"d":"3,464.80"},{"v":0.16,"d":"0.1600"},null,{"v":51775.21000000001,"d":"51,775.21"},{"v":60186.42,"d":"60,186.42"},{"v":4157.76,"d":"4,157.76"},{"v":0.16,"d":"0.1600"}]
[null,{"v":50155.36,"d":"50,155.36"},{"v":60049.700000000004,"d":"60,049.70"},{"v":4586.3,"d":"4,586.30"},0.1792,null,{"v":60186.43,"d":"60,186.43"},{"v":72059.64,"d":"72,059.64"},{"v":5503.5599999999995,"d":"5,503.56"},0.1792]
[null,{"v":60049.71000000001,"d":"60,049.71"},{"v":121111.55,"d":"121,111.55"},{"v":6359.349999999999,"d":"6,359.35"},0.2136,null,{"v":72059.65,"d":"72,059.65"},{"v":145333.86000000002,"d":"145,333.86"},{"v":7631.219999999999,"d":"7,631.22"},0.2136]
[null,{"v":121111.56,"d":"121,111.56"},{"v":190888.45,"d":"190,888.45"},{"v":19402.2,"d":"19,402.20"},0.2352,null,{"v":145333.87000000002,"d":"145,333.87"},{"v":229066.14,"d":"229,066.14"},{"v":23282.64,"d":"23,282.64"},0.2352]
[null,{"v":190888.46000000002,"d":"190,888.46"},{"v":364437.5,"d":"364,437.50"},{"v":35813.7,"d":"35,813.70"},{"v":0.3,"d":"0.3000"},null,{"v":229066.15000000002,"d":"229,066.15"},{"v":437325,"d":"437,325.00"},{"v":42976.44,"d":"42,976.44"},{"v":0.3,"d":"0.3000"}]
[null,{"v":364437.51,"d":"364,437.51"},{"v":485916.65,"d":"485,916.65"},{"v":87878.45,"d":"87,878.45"},{"v":0.32,"d":"0.3200"},null,{"v":437325.01,"d":"437,325.01"},{"v":583099.98,"d":"583,099.98"},{"v":105454.13999999998,"d":"105,454.14"},{"v":0.32,"d":"0.3200"}]
[null,{"v":485916.66000000003,"d":"485,916.66"},{"v":1457750,"d":"1,457,750.00"},{"v":126751.75,"d":"126,751.75"},{"v":0.34,"d":"0.3400"},null,{"v":583099.99,"d":"583,099.99"},{"v":1749300,"d":"1,749,300.00"},{"v":152102.09999999998,"d":"152,102.10"},{"v":0.34,"d":"0.3400"}]
[null,{"v":1457750.01,"d":"1,457,750.01"},"En adelante",{"v":457175.10000000003,"d":"457,175.10"},{"v":0.35,"d":"0.3500"},null,{"v":1749300.01,"d":"1,749,300.01"},"En adelante",{"v":548610.12,"d":"548,610.12"},{"v":0.35,"d":"0.3500"}]
[]
[]
[null,"Tarifa: pago provisional de julio 2022",{"$nulls":4},"Tarifa: pago provisional de agosto 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,{"v":4049.64,"d":"4,049.64"},0,0.0192,null,0.01,{"v":4628.16,"d":"4,628.16"},0,0.0192]
[null,{"v":4049.65,"d":"4,049.65"},{"v":34371.26,"d":"34,371.26"},77.77,{"v":0.064,"d":"0.0640"},null,{"v":4628.17,"d":"4,628.17"},{"v":39281.44,"d":"39,281.44"},88.88,{"v":0.064,"d":"0.0640"}]
[null,{"v":34371.270000000004,"d":"34,371.27"},{"v":60404.40000000001,"d":"60,404.40"},{"v":2018.31,"d":"2,018.31"},0.1088,null,{"v":39281.450000000004,"d":"39,281.45"},{"v":69033.6,"d":"69,033.60"},{"v":2306.64,"d":"2,306.64"},0.1088]
[null,{"v":60404.41000000001,"d":"60,404.41"},{"v":70217.48999999999,"d":"70,217.49"},{"v":4850.72,"d":"4,850.72"},{"v":0.16,"d":"0.1600"},null,{"v":69033.61,"d":"69,033.61"},{"v":80248.56,"d":"80,248.56"},{"v":5543.68,"d":"5,543.68"},{"v":0.16,"d":"0.1600"}]
[null,{"v":70217.49999999999,"d":"70,217.50"},{"v":84069.58,"d":"84,069.58"},{"v":6420.82,"d":"6,420.82"},0.1792,null,{"v":80248.56999999999,"d":"80,248.57"},{"v":96079.52,"d":"96,079.52"},{"v":7338.08,"d":"7,338.08"},0.1792]
[null,{"v":84069.59,"d":"84,069.59"},{"v":169556.17,"d":"169,556.17"},{"v":8903.09,"d":"8,903.09"},0.2136,null,{"v":96079.53,"d":"96,079.53"},{"v":193778.48,"d":"193,778.48"},{"v":10174.96,"d":"10,174.96"},0.2136]
[null,{"v":169556.18000000002,"d":"169,556.18"},{"v":267243.83,"d":"267,243.83"},{"v":27163.08,"d":"27,163.08"},0.2352,null,{"v":193778.49000000002,"d":"193,778.49"},{"v":305421.52,"d":"305,421.52"},{"v":31043.52,"d":"31,043.52"},0.2352]
[null,{"v":267243.84,"d":"267,243.84"},{"v":510212.5,"d":"510,212.50"},{"v":50139.18,"d":"50,139.18"},{"v":0.3,"d":"0.3000"},null,{"v":305421.53,"d":"305,421.53"},{"v":583100,"d":"583,100.00"},{"v":57301.92,"d":"57,301.92"},{"v":0.3,"d":"0.3000"}]
[null,{"v":510212.51,"d":"510,212.51"},{"v":680283.31,"d":"680,283.31"},{"v":123029.82999999999,"d":"123,029.83"},{"v":0.32,"d":"0.3200"},null,{"v":583100.01,"d":"583,100.01"},{"v":777466.64,"d":"777,466.64"},{"v":140605.52,"d":"140,605.52"},{"v":0.32,"d":"0.3200"}]
[null,{"v":680283.3200000001,"d":"680,283.32"},{"v":2040850,"d":"2,040,850.00"},{"v":177452.44999999998,"d":"177,452.45"},{"v":0.34,"d":"0.3400"},null,{"v":777466.65,"d":"777,466.65"},{"v":2332400,"d":"2,332,400.00"},{"v":202802.8,"d":"202,802.80"},{"v":0.34,"d":"0.3400"}]
[null,{"v":2040850.01,"d":"2,040,850.01"},"En adelante",{"v":640045.14,"d":"640,045.14"},{"v":0.35,"d":"0.3500"},null,{"v":2332400.01,"d":"2,332,400.01"},"En adelante",{"v":731480.16,"d":"731,480.16"},{"v":0.35,"d":"0.3500"}]
[]
[]
[null,"Tarifa: pago provisional de septiembre 2022",{"$nulls":4},"Tarifa: pago provisional de octubre de 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,{"v":5206.68,"d":"5,206.68"},0,0.0192,null,0.01,{"v":5785.2,"d":"5,785.20"},0,0.0192]
[null,{"v":5206.6900000000005,"d":"5,206.69"},{"v":44191.62,"d":"44,191.62"},99.99,{"v":0.064,"d":"0.0640"},null,{"v":5785.21,"d":"5,785.21"},{"v":49101.8,"d":"49,101.80"},111.1,{"v":0.064,"d":"0.0640"}]
[null,{"v":44191.630000000005,"d":"44,191.63"},{"v":77662.8,"d":"77,662.80"},{"v":2594.97,"d":"2,594.97"},0.1088,null,{"v":49101.810000000005,"d":"49,101.81"},{"v":86292,"d":"86,292.00"},{"v":2883.2999999999997,"d":"2,883.30"},0.1088]
[null,{"v":77662.81,"d":"77,662.81"},{"v":90279.63,"d":"90,279.63"},{"v":6236.64,"d":"6,236.64"},{"v":0.16,"d":"0.1600"},null,{"v":86292.01,"d":"86,292.01"},{"v":100310.7,"d":"100,310.70"},{"v":6929.6,"d":"6,929.60"},{"v":0.16,"d":"0.1600"}]
[null,{"v":90279.64,"d":"90,279.64"},{"v":108089.46,"d":"108,089.46"},{"v":8255.34,"d":"8,255.34"},0.1792,null,{"v":100310.70999999999,"d":"100,310.71"},{"v":120099.40000000001,"d":"120,099.40"},{"v":9172.6,"d":"9,172.60"},0.1792]
[null,{"v":108089.47,"d":"108,089.47"},{"v":218000.79,"d":"218,000.79"},{"v":11446.829999999998,"d":"11,446.83"},0.2136,null,{"v":120099.41,"d":"120,099.41"},{"v":242223.1,"d":"242,223.10"},{"v":12718.699999999999,"d":"12,718.70"},0.2136]
[null,{"v":218000.80000000002,"d":"218,000.80"},{"v":343599.21,"d":"343,599.21"},{"v":34923.96,"d":"34,923.96"},0.2352,null,{"v":242223.11000000002,"d":"242,223.11"},{"v":381776.9,"d":"381,776.90"},{"v":38804.4,"d":"38,804.40"},0.2352]
[null,{"v":343599.22000000003,"d":"343,599.22"},{"v":655987.5,"d":"655,987.50"},{"v":64464.659999999996,"d":"64,464.66"},{"v":0.3,"d":"0.3000"},null,{"v":381776.91000000003,"d":"381,776.91"},{"v":728875,"d":"728,875.00"},{"v":71627.4,"d":"71,627.40"},{"v":0.3,"d":"0.3000"}]
[null,{"v":655987.51,"d":"655,987.51"},{"v":874649.97,"d":"874,649.97"},{"v":158181.21,"d":"158,181.21"},{"v":0.32,"d":"0.3200"},null,{"v":728875.01,"d":"728,875.01"},{"v":971833.3,"d":"971,833.30"},{"v":175756.9,"d":"175,756.90"},{"v":0.32,"d":"0.3200"}]
[null,{"v":874649.98,"d":"874,649.98"},{"v":2623950,"d":"2,623,950.00"},{"v":228153.15,"d":"228,153.15"},{"v":0.34,"d":"0.3400"},null,{"v":971833.31,"d":"971,833.31"},{"v":2915500,"d":"2,915,500.00"},{"v":253503.5,"d":"253,503.50"},{"v":0.34,"d":"0.3400"}]
[null,{"v":2623950.01,"d":"2,623,950.01"},"En adelante",{"v":822915.18,"d":"822,915.18"},{"v":0.35,"d":"0.3500"},null,{"v":2915500.01,"d":"2,915,500.01"},"En adelante",{"v":914350.2000000001,"d":"914,350.20"},{"v":0.35,"d":"0.3500"}]
[]
[]
[null,"Tarifa: pago provisional de noviembre 2022",{"$nulls":4},"Tarifa: pago provisional de diciembre 2022"]
[null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior",null,"Límite inferior","Límite superior","Cuota fija","Por ciento para aplicarse sobre el excedente del límite inferior"]
[]
[null,"$","$","$","%",null,"$","$","$","%"]
[null,0.01,{"v":6363.719999999999,"d":"6,363.72"},0,0.0192,null,0.01,{"v":6942.24,"d":"6,942.24"},0,0.0192]
[null,{"v":6363.73,"d":"6,363.73"},{"v":54011.98,"d":"54,011.98"},122.21,{"v":0.064,"d":"0.0640"},null,{"v":6942.25,"d":"6,942.25"},{"v":58922.16,"d":"58,922.16"},133.32,{"v":0.064,"d":"0.0640"}]
[null,{"v":54011.990000000005,"d":"54,011.99"},{"v":94921.20000000001,"d":"94,921.20"},{"v":3171.6299999999997,"d":"3,171.63"},0.1088,null,{"v":58922.170000000006,"d":"58,922.17"},{"v":103550.40000000001,"d":"103,550.40"},{"v":3459.96,"d":"3,459.96"},0.1088]
[null,{"v":94921.21,"d":"94,921.21"},{"v":110341.76999999999,"d":"110,341.77"},{"v":7622.56,"d":"7,622.56"},{"v":0.16,"d":"0.1600"},null,{"v":103550.41,"d":"103,550.41"},{"v":120372.84,"d":"120,372.84"},{"v":8315.52,"d":"8,315.52"},{"v":0.16,"d":"0.1600"}]
[null,{"v":110341.77999999998,"d":"110,341.78"},{"v":132109.34,"d":"132,109.34"},{"v":10089.86,"d":"10,089.86"},0.1792,null,{"v":120372.84999999999,"d":"120,372.85"},{"v":144119.28,"d":"144,119.28"},{"v":11007.119999999999,"d":"11,007.12"},0.1792]
[null,{"v":132109.35,"d":"132,109.35"},{"v":266445.41000000003,"d":"266,445.41"},{"v":13990.57,"d":"13,990.57"},0.2136,null,{"v":144119.29,"d":"144,119.29"},{"v":290667.72000000003,"d":"290,667.72"},{"v":15262.439999999999,"d":"15,262.44"},0.2136]
[null,{"v":266445.42000000004,"d":"266,445.42"},{"v":419954.59,"d":"419,954.59"},{"v":42684.840000000004,"d":"42,684.84"},0.2352,null,{"v":290667.73000000004,"d":"290,667.73"},{"v":458132.28,"d":"458,132.28"},{"v":46565.28,"d":"46,565.28"},0.2352]
[null,{"v":419954.60000000003,"d":"419,954.60"},{"v":801762.5,"d":"801,762.50"},{"v":78790.14,"d":"78,790.14"},{"v":0.3,"d":"0.3000"},null,{"v":458132.29000000004,"d":"458,132.29"},{"v":874650,"d":"874,650.00"},{"v":85952.88,"d":"85,952.88"},{"v":0.3,"d":"0.3000"}]
[null,{"v":801762.51,"d":"801,762.51"},{"v":1069016.6300000001,"d":"1,069,016.63"},{"v":193332.59,"d":"193,332.59"},{"v":0.32,"d":"0.3200"},null,{"v":874650.01,"d":"874,650.01"},{"v":1166199.96,"d":"1,166,199.96"},{"v":210908.27999999997,"d":"210,908.28"},{"v":0.32,"d":"0.3200"}]
[null,{"v":1069016.6400000001,"d":"1,069,016.64"},{"v":3207050,"d":"3,207,050.00"},{"v":278853.85,"d":"278,853.85"},{"v":0.34,"d":"0.3400"},null,{"v":1166199.97,"d":"1,166,199.97"},{"v":3498600,"d":"3,498,600.00"},{"v":304204.19999999995,"d":"304,204.20"},{"v":0.34,"d":"0.3400"}]
[null,{"v":3207050.01,"d":"3,207,050.01"},"En adelante",{"v":1005785.2200000001,"d":"1,005,785.22"},{"v":0.35,"d":"0.3500"},null,{"v":3498600.01,"d":"3,498,600.01"},"En adelante",{"v":1097220.24,"d":"1,097,220.24"},{"v":0.35,"d":"0.3500"}]