{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Resumen presupuesto a hoy","Resumen gastos mensuales","Gastos desglosados","Beneficencia y patrocinios"],"not_rendered":{"defined_names":8,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Resumen presupuesto a hoy","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"merged":[[1,0,1,5]]}
[]
["Gastos reales 2005 frente a estado del presupuesto a día de hoy"]
[]
["Código de \nlibro mayor","Partida","Real","Presupuesto","Cantidad \nrestante","Porcentaje \nrestante"]
[]
[1000,"Publicidad",{"$f":"'Resumen gastos mensuales'!O6","v":{"v":750.75,"d":"€750.75"}},{"v":100000,"d":"€100,000.00"},{"$f":"SUM(+D6-C6)","v":{"v":99249.25,"d":"€99,249.25"}},{"$f":"SUM(E6/D6)","v":{"v":0.9924925,"d":"99.25%"}}]
[]
[2000,"Equipamientos oficina",{"$f":"'Resumen gastos mensuales'!O8","v":0},{"v":100000,"d":"€100,000.00"},{"$f":"SUM(+D8-C8)","v":{"v":100000,"d":"€100,000.00"}},{"$f":"SUM(E8/D8)","v":{"v":1,"d":"100.00%"}}]
[]
[3000,"Impresoras",{"$f":"'Resumen gastos mensuales'!O10","v":0},{"v":100000,"d":"€100,000.00"},{"$f":"SUM(+D10-C10)","v":{"v":100000,"d":"€100,000.00"}},{"$f":"SUM(E10/D10)","v":{"v":1,"d":"100.00%"}}]
[]
[4000,"Costos de servidores",{"$f":"'Resumen gastos mensuales'!O12","v":0},{"v":100000,"d":"€100,000.00"},{"$f":"SUM(+D12-C12)","v":{"v":100000,"d":"€100,000.00"}},{"$f":"SUM(E12/D12)","v":{"v":1,"d":"100.00%"}}]
[]
[5000,"Suministros",{"$f":"'Resumen gastos mensuales'!O14","v":0},{"v":50000,"d":"€50,000.00"},{"$f":"SUM(+D14-C14)","v":{"v":50000,"d":"€50,000.00"}},{"$f":"SUM(E14/D14)","v":{"v":1,"d":"100.00%"}}]
[]
[6000,"Gastos de clientes",{"$f":"'Resumen gastos mensuales'!O16","v":0},{"v":25000,"d":"€25,000.00"},{"$f":"SUM(+D16-C16)","v":{"v":25000,"d":"€25,000.00"}},{"$f":"SUM(E16/D16)","v":{"v":1,"d":"100.00%"}}]
[]
[7000,"Equipos",{"$f":"'Resumen gastos mensuales'!O18","v":{"v":2500,"d":"€2,500.00"}},{"v":75000,"d":"€75,000.00"},{"$f":"SUM(+D18-C18)","v":{"v":72500,"d":"€72,500.00"}},{"$f":"SUM(E18/D18)","v":{"v":0.9666666666666667,"d":"96.67%"}}]
[]
[8000,"Seguro médico",{"$f":"'Resumen gastos mensuales'!O20","v":0},{"v":65000,"d":"€65,000.00"},{"$f":"SUM(+D20-C20)","v":{"v":65000,"d":"€65,000.00"}},{"$f":"SUM(E20/D20)","v":{"v":1,"d":"100.00%"}}]
[]
[9000,"Costos de edificios",{"$f":"'Resumen gastos mensuales'!O22","v":0},{"v":125000,"d":"€125,000.00"},{"$f":"SUM(+D22-C22)","v":{"v":125000,"d":"€125,000.00"}},{"$f":"SUM(E22/D22)","v":{"v":1,"d":"100.00%"}}]
[]
[10000,"Marketing",{"$f":"'Resumen gastos mensuales'!O24","v":0},{"v":100000,"d":"€100,000.00"},{"$f":"SUM(+D24-C24)","v":{"v":100000,"d":"€100,000.00"}},{"$f":"SUM(E24/D24)","v":{"v":1,"d":"100.00%"}}]
[]
[11000,"Beneficencia",{"$f":"'Resumen gastos mensuales'!O26","v":{"v":2500,"d":"€2,500.00"}},{"v":250000,"d":"€250,000.00"},{"$f":"SUM(+D26-C26)","v":{"v":247500,"d":"€247,500.00"}},{"$f":"SUM(E26/D26)","v":{"v":0.99,"d":"99.00%"}}]
[]
[12000,"Patrocinios",{"$f":"'Resumen gastos mensuales'!O28","v":{"v":1000,"d":"€1,000.00"}},{"v":50000,"d":"€50,000.00"},{"$f":"SUM(+D28-C28)","v":{"v":49000,"d":"€49,000.00"}},{"$f":"SUM(E28/D28)","v":{"v":0.98,"d":"98.00%"}}]
[]
[null,"TOTAL",{"$f":"SUM(C6:C28)","v":{"v":6750.75,"d":"€6,750.75"}},{"$f":"SUM(D6:D28)","v":{"v":1140000,"d":"€1,140,000.00"}},{"$f":"SUM(E6:E28)","v":{"v":1133249.25,"d":"€1,133,249.25"}},{"$f":"SUM(E30/D30)","v":{"v":0.9940782894736843,"d":"99.41%"}}]

{"sheet":"Resumen gastos mensuales","index":1,"n_rows":30,"n_cols":15,"rows_kept":30,"merged":[[1,0,1,14]]}
[]
["Gastos mensuales 2005"]
[]
["Código de \nlibro mayor","Partida","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01",2005]
[]
[1000,"Publicidad",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":{"v":750.75,"d":"€750.75"}},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A6&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A6&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C6:N6)","v":{"v":750.75,"d":"€750.75"}}]
[]
[2000,"Equipamientos oficina",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A8&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A8&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C8:N8)","v":0}]
[]
[3000,"Impresoras",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A10&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A10&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C10:N10)","v":0}]
[]
[4000,"Costos de servidores",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A12&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A12&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C12:N12)","v":0}]
[]
[5000,"Suministros",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A14&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A14&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C14:N14)","v":0}]
[]
[6000,"Gastos de clientes",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A16&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A16&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C16:N16)","v":0}]
[]
[7000,"Equipos",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":{"v":2500,"d":"€2,500.00"}},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A18&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A18&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C18:N18)","v":{"v":2500,"d":"€2,500.00"}}]
[]
[8000,"Seguro médico",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A20&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A20&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C20:N20)","v":0}]
[]
[9000,"Costos de edificios",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A22&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A22&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C22:N22)","v":0}]
[]
[10000,"Marketing",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A24&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A24&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C24:N24)","v":0}]
[]
[11000,"Beneficencia",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":{"v":2500,"d":"€2,500.00"}},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A26&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A26&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C26:N26)","v":{"v":2500,"d":"€2,500.00"}}]
[]
[12000,"Patrocinios",{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(C$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(C$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":{"v":1000,"d":"€1,000.00"}},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(D$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(D$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(E$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(E$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(F$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(F$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(G$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(G$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(H$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(H$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(I$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(I$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(J$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(J$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(K$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(K$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(L$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(L$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(M$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(M$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUMIF('Beneficencia y patrocinios'!$L:$L,\"=\"&($A28&TEXT(N$4,\"mmm-yy\")),'Beneficencia y patrocinios'!$D:$D)+SUMIF('Gastos desglosados'!$J:$J,\"=\"&($A28&TEXT(N$4,\"mmm-yy\")),'Gastos desglosados'!$E:$E)","v":0},{"$f":"SUM(C28:N28)","v":{"v":1000,"d":"€1,000.00"}}]
[]
[null,"Total",{"$f":"SUM(C6:C28)","v":{"v":4250.75,"d":"€4,250.75"}},{"v":2500,"d":"€2,500.00"},0,0,0,0,0,0,0,0,0,0,{"v":6750.75,"d":"€6,750.75"}]

{"sheet":"Gastos desglosados","index":2,"n_rows":103,"n_cols":10,"rows_kept":103}
["Código de libro mayor","Fecha de factura","Nº factura","Solicitado por"," Cantidad ","Beneficiario","Uso","Método de entrega","Fecha de archivo","Campo clave construido"]
[1000,"2005-01-01",100,"Andy Teal",{"v":750.75,"d":"€750.75"},"Consolidated Messenger ","Sobre de mensajería","Correo","2005-01-04",{"$f":"A2&TEXT(B2,\"mmm-yy\")","v":"1000Jan-05"}]
[7000,"2005-01-15",101,"Robert Walters",{"v":2500,"d":"€2,500.00"},"A. Datum Corporation ","2 equipos de sobremesa","Crédito","2005-01-20","7000Jan-05"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},{"$f":"A34&TEXT(B34,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},{"$f":"A66&TEXT(B66,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},{"$f":"A98&TEXT(B98,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]
[{"$nulls":9},"Jan-00"]

{"sheet":"Beneficencia y patrocinios","index":3,"n_rows":109,"n_cols":12,"rows_kept":109}
["Código de libro mayor","Fecha solicitud cheque","Solicitado por"," Cantidad "," Contribución año anterior ","Beneficiario","Usado para","Autorizado por","Categoría","Método de entrega","Fecha de archivo","Campo clave construido"]
[12000,"2005-01-20","Susan W. Eaton",{"v":1000,"d":"€1,000.00"},0,"Escuela de Bellas Artes ","Becas","Kim Ralls","Artes","Cheque","2005-01-30",{"$f":"A2&TEXT(B2,\"mmm-yy\")","v":"12000Jan-05"}]
[11000,"2005-02-15","Susan W. Eaton",{"v":2500,"d":"€2,500.00"},0,"Wingtip Toys ","Comunidad","Kathie Flood","Comunidad","Cheque","2005-03-01","11000Feb-05"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},{"$f":"A34&TEXT(B34,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},{"$f":"A66&TEXT(B66,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},{"$f":"A98&TEXT(B98,\"mmm-yy\")","v":"Jan-00"}]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]
[{"$nulls":11},"Jan-00"]