{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DATOS PERSONALES","EXPERIENCIA","FORMACIÓN","TOTAL BAREMO","variables"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"DATOS PERSONALES","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[[8,3,9,9],[8,10,9,11],[10,3,11,4],[10,5,11,11],[6,3,7,3],[6,4,7,6],[0,3,1,4],[0,5,1,16],[4,3,5,3],[4,4,5,6],[2,3,3,3],[2,4,3,8]]}
[null,null,null,"A.1 DATOS DEL ASPIRANTE:",null,"*NOTA: TODOS LOS CAMPOS DE ESTA SECCION SON OBLIGATORIOS (identificación del aspirante, fecha límite presentación y elección de la plaza).\nEn el resto de secciones cumplimentar (en orden, cuando sea de aplicación) cuantas filas se estimen oportunas (solo casillas COLOR GRIS CLARO)"]
[]
[null,null,null,"APELLIDOS:*"]
[]
[null,null,null,"NOMBRE:*"]
[]
[null,null,null,"DNI/NIE/Id.:*"]
[]
[null,null,null,"FECHA LÍMITE de presentación de la solicitud según BOE (dd/mm/aaaa)*"]
[]
[null,null,null,"PLAZA A LA QUE SE OPTA:*"]

{"sheet":"EXPERIENCIA","index":1,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":true,"merged":[[57,6,57,7],[57,14,57,15],[0,3,0,4],[1,3,1,8],[1,10,1,16],[2,3,2,5],[2,6,2,8],[2,10,2,13],[2,14,2,16]]}
[null,null,null,"B.1 EXPERIENCIA:"]
[null,null,null,"EXPERIENCIA EN MAJADAHONDA",null,null,null,null,null,null,"EXPERIENCIA EN OTRAS AA.PP"]
[null,null,null,"PERÍODO",null,null,"CÁLCULO",null,null,null,"PERÍODO",null,null,null,"CÁLCULO"]
[null,null,null,"INICIO\n(dd/mm/aaaa)","FIN\n(dd/mm/aaaa)","MESES\n(automático)","Jornada (%)","Antigüedad\n(años)\n(automático)","PUNTOS\n(automático)",null,"INICIO\n(dd/mm/aaaa)","FIN\n(dd/mm/aaaa)","Nombre\nADMIN. PÚBLICA","MESES\n(automático)","Jornada (%)","Antigüedad\n(años)\n(automático)","PUNTOS\n(automático)"]
[null,null,null,null,null,{"$f":"IF(AND(D5<>\"\",E5<>\"\"),DATEDIF(D5,E5,\"y\")*12+DATEDIF(D5,E5,\"ym\")+DATEDIF(D5,E5,\"md\")/30,\"\")","v":""},null,{"$f":"IF(F5<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(G6)=0,IF(AND(F5<>\"\",G5<>\"\",H5<>\"\"),IF(H5<6,IF(G5>=50,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4*G5/100),(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4),\"\"),IF(AND(F5<>\"\",G5<>\"\",H5<>\"\"),IF(H5<6,IF(G5>=50,F5*variables!$B$4,F5*variables!$B$4*G5/100),F5*variables!$B$4),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(K5<>\"\",L5<>\"\",M5<>\"\"),DATEDIF(K5,L5,\"y\")*12+DATEDIF(K5,L5,\"ym\")+DATEDIF(K5,L5,\"md\")/30,\"\")","v":""},null,{"$f":"IF(N5<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(O6)=0,IF(AND(M5<>\"\",N5<>\"\",O5<>\"\",P5<>\"\"),IF(P5<6,IF(O5>=50,(N5-(SUM($N$5:N5)-ROUNDDOWN(SUM($N$5:N5),0)))*variables!$B$5,(N5-(SUM($N$5:N5)-ROUNDDOWN(SUM($N$5:N5),0)))*variables!$B$5*O5/100),(N5-(SUM($N$5:N5)-ROUNDDOWN(SUM($N$5:N5),0)))*variables!$B$5),\"\"),IF(AND(M5<>\"\",N5<>\"\",O5<>\"\",P5<>\"\"),IF(P5<6,IF(O5>=50,N5*variables!$B$5,N5*variables!$B$5*O5/100),N5*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(D6<>\"\",E6<>\"\"),DATEDIF(D6,E6,\"y\")*12+DATEDIF(D6,E6,\"ym\")+DATEDIF(D6,E6,\"md\")/30,\"\")","v":""},null,{"$f":"IF(F6<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(G7)=0,IF(AND(F6<>\"\",G6<>\"\",H6<>\"\"),IF(H6<6,IF(G6>=50,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4*G6/100),(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4),\"\"),IF(AND(F6<>\"\",G6<>\"\",H6<>\"\"),IF(H6<6,IF(G6>=50,F6*variables!$B$4,F6*variables!$B$4*G6/100),F6*variables!$B$4),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(K6<>\"\",L6<>\"\",M6<>\"\"),DATEDIF(K6,L6,\"y\")*12+DATEDIF(K6,L6,\"ym\")+DATEDIF(K6,L6,\"md\")/30,\"\")","v":""},null,{"$f":"IF(N6<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(O7)=0,IF(AND(M6<>\"\",N6<>\"\",O6<>\"\",P6<>\"\"),IF(P6<6,IF(O6>=50,(N6-(SUM($N$5:N6)-ROUNDDOWN(SUM($N$5:N6),0)))*variables!$B$5,(N6-(SUM($N$5:N6)-ROUNDDOWN(SUM($N$5:N6),0)))*variables!$B$5*O6/100),(N6-(SUM($N$5:N6)-ROUNDDOWN(SUM($N$5:N6),0)))*variables!$B$5),\"\"),IF(AND(M6<>\"\",N6<>\"\",O6<>\"\",P6<>\"\"),IF(P6<6,IF(O6>=50,N6*variables!$B$5,N6*variables!$B$5*O6/100),N6*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(D7<>\"\",E7<>\"\"),DATEDIF(D7,E7,\"y\")*12+DATEDIF(D7,E7,\"ym\")+DATEDIF(D7,E7,\"md\")/30,\"\")","v":""},null,{"$f":"IF(F7<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(G8)=0,IF(AND(F7<>\"\",G7<>\"\",H7<>\"\"),IF(H7<6,IF(G7>=50,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4*G7/100),(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4),\"\"),IF(AND(F7<>\"\",G7<>\"\",H7<>\"\"),IF(H7<6,IF(G7>=50,F7*variables!$B$4,F7*variables!$B$4*G7/100),F7*variables!$B$4),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(K7<>\"\",L7<>\"\",M7<>\"\"),DATEDIF(K7,L7,\"y\")*12+DATEDIF(K7,L7,\"ym\")+DATEDIF(K7,L7,\"md\")/30,\"\")","v":""},null,{"$f":"IF(N7<>\"\",(SUM(F$5:F$57)+SUM(N$5:N$57))/12,\"\")","v":""},{"$f":"IF(COUNTA(O8)=0,IF(AND(M7<>\"\",N7<>\"\",O7<>\"\",P7<>\"\"),IF(P7<6,IF(O7>=50,(N7-(SUM($N$5:N7)-ROUNDDOWN(SUM($N$5:N7),0)))*variables!$B$5,(N7-(SUM($N$5:N7)-ROUNDDOWN(SUM($N$5:N7),0)))*variables!$B$5*O7/100),(N7-(SUM($N$5:N7)-ROUNDDOWN(SUM($N$5:N7),0)))*variables!$B$5),\"\"),IF(AND(M7<>\"\",N7<>\"\",O7<>\"\",P7<>\"\"),IF(P7<6,IF(O7>=50,N7*variables!$B$5,N7*variables!$B$5*O7/100),N7*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G9)=0,IF(AND(F8<>\"\",G8<>\"\",H8<>\"\"),IF(H8<6,IF(G8>=50,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4*G8/100),(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4),\"\"),IF(AND(F8<>\"\",G8<>\"\",H8<>\"\"),IF(H8<6,IF(G8>=50,F8*variables!$B$4,F8*variables!$B$4*G8/100),F8*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O9)=0,IF(AND(M8<>\"\",N8<>\"\",O8<>\"\",P8<>\"\"),IF(P8<6,IF(O8>=50,(N8-(SUM($N$5:N8)-ROUNDDOWN(SUM($N$5:N8),0)))*variables!$B$5,(N8-(SUM($N$5:N8)-ROUNDDOWN(SUM($N$5:N8),0)))*variables!$B$5*O8/100),(N8-(SUM($N$5:N8)-ROUNDDOWN(SUM($N$5:N8),0)))*variables!$B$5),\"\"),IF(AND(M8<>\"\",N8<>\"\",O8<>\"\",P8<>\"\"),IF(P8<6,IF(O8>=50,N8*variables!$B$5,N8*variables!$B$5*O8/100),N8*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G10)=0,IF(AND(F9<>\"\",G9<>\"\",H9<>\"\"),IF(H9<6,IF(G9>=50,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4*G9/100),(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4),\"\"),IF(AND(F9<>\"\",G9<>\"\",H9<>\"\"),IF(H9<6,IF(G9>=50,F9*variables!$B$4,F9*variables!$B$4*G9/100),F9*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O10)=0,IF(AND(M9<>\"\",N9<>\"\",O9<>\"\",P9<>\"\"),IF(P9<6,IF(O9>=50,(N9-(SUM($N$5:N9)-ROUNDDOWN(SUM($N$5:N9),0)))*variables!$B$5,(N9-(SUM($N$5:N9)-ROUNDDOWN(SUM($N$5:N9),0)))*variables!$B$5*O9/100),(N9-(SUM($N$5:N9)-ROUNDDOWN(SUM($N$5:N9),0)))*variables!$B$5),\"\"),IF(AND(M9<>\"\",N9<>\"\",O9<>\"\",P9<>\"\"),IF(P9<6,IF(O9>=50,N9*variables!$B$5,N9*variables!$B$5*O9/100),N9*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G11)=0,IF(AND(F10<>\"\",G10<>\"\",H10<>\"\"),IF(H10<6,IF(G10>=50,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4*G10/100),(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4),\"\"),IF(AND(F10<>\"\",G10<>\"\",H10<>\"\"),IF(H10<6,IF(G10>=50,F10*variables!$B$4,F10*variables!$B$4*G10/100),F10*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O11)=0,IF(AND(M10<>\"\",N10<>\"\",O10<>\"\",P10<>\"\"),IF(P10<6,IF(O10>=50,(N10-(SUM($N$5:N10)-ROUNDDOWN(SUM($N$5:N10),0)))*variables!$B$5,(N10-(SUM($N$5:N10)-ROUNDDOWN(SUM($N$5:N10),0)))*variables!$B$5*O10/100),(N10-(SUM($N$5:N10)-ROUNDDOWN(SUM($N$5:N10),0)))*variables!$B$5),\"\"),IF(AND(M10<>\"\",N10<>\"\",O10<>\"\",P10<>\"\"),IF(P10<6,IF(O10>=50,N10*variables!$B$5,N10*variables!$B$5*O10/100),N10*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G12)=0,IF(AND(F11<>\"\",G11<>\"\",H11<>\"\"),IF(H11<6,IF(G11>=50,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4*G11/100),(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4),\"\"),IF(AND(F11<>\"\",G11<>\"\",H11<>\"\"),IF(H11<6,IF(G11>=50,F11*variables!$B$4,F11*variables!$B$4*G11/100),F11*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O12)=0,IF(AND(M11<>\"\",N11<>\"\",O11<>\"\",P11<>\"\"),IF(P11<6,IF(O11>=50,(N11-(SUM($N$5:N11)-ROUNDDOWN(SUM($N$5:N11),0)))*variables!$B$5,(N11-(SUM($N$5:N11)-ROUNDDOWN(SUM($N$5:N11),0)))*variables!$B$5*O11/100),(N11-(SUM($N$5:N11)-ROUNDDOWN(SUM($N$5:N11),0)))*variables!$B$5),\"\"),IF(AND(M11<>\"\",N11<>\"\",O11<>\"\",P11<>\"\"),IF(P11<6,IF(O11>=50,N11*variables!$B$5,N11*variables!$B$5*O11/100),N11*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G13)=0,IF(AND(F12<>\"\",G12<>\"\",H12<>\"\"),IF(H12<6,IF(G12>=50,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4*G12/100),(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4),\"\"),IF(AND(F12<>\"\",G12<>\"\",H12<>\"\"),IF(H12<6,IF(G12>=50,F12*variables!$B$4,F12*variables!$B$4*G12/100),F12*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O13)=0,IF(AND(M12<>\"\",N12<>\"\",O12<>\"\",P12<>\"\"),IF(P12<6,IF(O12>=50,(N12-(SUM($N$5:N12)-ROUNDDOWN(SUM($N$5:N12),0)))*variables!$B$5,(N12-(SUM($N$5:N12)-ROUNDDOWN(SUM($N$5:N12),0)))*variables!$B$5*O12/100),(N12-(SUM($N$5:N12)-ROUNDDOWN(SUM($N$5:N12),0)))*variables!$B$5),\"\"),IF(AND(M12<>\"\",N12<>\"\",O12<>\"\",P12<>\"\"),IF(P12<6,IF(O12>=50,N12*variables!$B$5,N12*variables!$B$5*O12/100),N12*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G14)=0,IF(AND(F13<>\"\",G13<>\"\",H13<>\"\"),IF(H13<6,IF(G13>=50,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4*G13/100),(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4),\"\"),IF(AND(F13<>\"\",G13<>\"\",H13<>\"\"),IF(H13<6,IF(G13>=50,F13*variables!$B$4,F13*variables!$B$4*G13/100),F13*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O14)=0,IF(AND(M13<>\"\",N13<>\"\",O13<>\"\",P13<>\"\"),IF(P13<6,IF(O13>=50,(N13-(SUM($N$5:N13)-ROUNDDOWN(SUM($N$5:N13),0)))*variables!$B$5,(N13-(SUM($N$5:N13)-ROUNDDOWN(SUM($N$5:N13),0)))*variables!$B$5*O13/100),(N13-(SUM($N$5:N13)-ROUNDDOWN(SUM($N$5:N13),0)))*variables!$B$5),\"\"),IF(AND(M13<>\"\",N13<>\"\",O13<>\"\",P13<>\"\"),IF(P13<6,IF(O13>=50,N13*variables!$B$5,N13*variables!$B$5*O13/100),N13*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G15)=0,IF(AND(F14<>\"\",G14<>\"\",H14<>\"\"),IF(H14<6,IF(G14>=50,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4*G14/100),(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4),\"\"),IF(AND(F14<>\"\",G14<>\"\",H14<>\"\"),IF(H14<6,IF(G14>=50,F14*variables!$B$4,F14*variables!$B$4*G14/100),F14*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O15)=0,IF(AND(M14<>\"\",N14<>\"\",O14<>\"\",P14<>\"\"),IF(P14<6,IF(O14>=50,(N14-(SUM($N$5:N14)-ROUNDDOWN(SUM($N$5:N14),0)))*variables!$B$5,(N14-(SUM($N$5:N14)-ROUNDDOWN(SUM($N$5:N14),0)))*variables!$B$5*O14/100),(N14-(SUM($N$5:N14)-ROUNDDOWN(SUM($N$5:N14),0)))*variables!$B$5),\"\"),IF(AND(M14<>\"\",N14<>\"\",O14<>\"\",P14<>\"\"),IF(P14<6,IF(O14>=50,N14*variables!$B$5,N14*variables!$B$5*O14/100),N14*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G16)=0,IF(AND(F15<>\"\",G15<>\"\",H15<>\"\"),IF(H15<6,IF(G15>=50,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4*G15/100),(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4),\"\"),IF(AND(F15<>\"\",G15<>\"\",H15<>\"\"),IF(H15<6,IF(G15>=50,F15*variables!$B$4,F15*variables!$B$4*G15/100),F15*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O16)=0,IF(AND(M15<>\"\",N15<>\"\",O15<>\"\",P15<>\"\"),IF(P15<6,IF(O15>=50,(N15-(SUM($N$5:N15)-ROUNDDOWN(SUM($N$5:N15),0)))*variables!$B$5,(N15-(SUM($N$5:N15)-ROUNDDOWN(SUM($N$5:N15),0)))*variables!$B$5*O15/100),(N15-(SUM($N$5:N15)-ROUNDDOWN(SUM($N$5:N15),0)))*variables!$B$5),\"\"),IF(AND(M15<>\"\",N15<>\"\",O15<>\"\",P15<>\"\"),IF(P15<6,IF(O15>=50,N15*variables!$B$5,N15*variables!$B$5*O15/100),N15*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G17)=0,IF(AND(F16<>\"\",G16<>\"\",H16<>\"\"),IF(H16<6,IF(G16>=50,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4*G16/100),(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4),\"\"),IF(AND(F16<>\"\",G16<>\"\",H16<>\"\"),IF(H16<6,IF(G16>=50,F16*variables!$B$4,F16*variables!$B$4*G16/100),F16*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O17)=0,IF(AND(M16<>\"\",N16<>\"\",O16<>\"\",P16<>\"\"),IF(P16<6,IF(O16>=50,(N16-(SUM($N$5:N16)-ROUNDDOWN(SUM($N$5:N16),0)))*variables!$B$5,(N16-(SUM($N$5:N16)-ROUNDDOWN(SUM($N$5:N16),0)))*variables!$B$5*O16/100),(N16-(SUM($N$5:N16)-ROUNDDOWN(SUM($N$5:N16),0)))*variables!$B$5),\"\"),IF(AND(M16<>\"\",N16<>\"\",O16<>\"\",P16<>\"\"),IF(P16<6,IF(O16>=50,N16*variables!$B$5,N16*variables!$B$5*O16/100),N16*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G18)=0,IF(AND(F17<>\"\",G17<>\"\",H17<>\"\"),IF(H17<6,IF(G17>=50,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4*G17/100),(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4),\"\"),IF(AND(F17<>\"\",G17<>\"\",H17<>\"\"),IF(H17<6,IF(G17>=50,F17*variables!$B$4,F17*variables!$B$4*G17/100),F17*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O18)=0,IF(AND(M17<>\"\",N17<>\"\",O17<>\"\",P17<>\"\"),IF(P17<6,IF(O17>=50,(N17-(SUM($N$5:N17)-ROUNDDOWN(SUM($N$5:N17),0)))*variables!$B$5,(N17-(SUM($N$5:N17)-ROUNDDOWN(SUM($N$5:N17),0)))*variables!$B$5*O17/100),(N17-(SUM($N$5:N17)-ROUNDDOWN(SUM($N$5:N17),0)))*variables!$B$5),\"\"),IF(AND(M17<>\"\",N17<>\"\",O17<>\"\",P17<>\"\"),IF(P17<6,IF(O17>=50,N17*variables!$B$5,N17*variables!$B$5*O17/100),N17*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G19)=0,IF(AND(F18<>\"\",G18<>\"\",H18<>\"\"),IF(H18<6,IF(G18>=50,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4*G18/100),(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4),\"\"),IF(AND(F18<>\"\",G18<>\"\",H18<>\"\"),IF(H18<6,IF(G18>=50,F18*variables!$B$4,F18*variables!$B$4*G18/100),F18*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O19)=0,IF(AND(M18<>\"\",N18<>\"\",O18<>\"\",P18<>\"\"),IF(P18<6,IF(O18>=50,(N18-(SUM($N$5:N18)-ROUNDDOWN(SUM($N$5:N18),0)))*variables!$B$5,(N18-(SUM($N$5:N18)-ROUNDDOWN(SUM($N$5:N18),0)))*variables!$B$5*O18/100),(N18-(SUM($N$5:N18)-ROUNDDOWN(SUM($N$5:N18),0)))*variables!$B$5),\"\"),IF(AND(M18<>\"\",N18<>\"\",O18<>\"\",P18<>\"\"),IF(P18<6,IF(O18>=50,N18*variables!$B$5,N18*variables!$B$5*O18/100),N18*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G20)=0,IF(AND(F19<>\"\",G19<>\"\",H19<>\"\"),IF(H19<6,IF(G19>=50,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4*G19/100),(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4),\"\"),IF(AND(F19<>\"\",G19<>\"\",H19<>\"\"),IF(H19<6,IF(G19>=50,F19*variables!$B$4,F19*variables!$B$4*G19/100),F19*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O20)=0,IF(AND(M19<>\"\",N19<>\"\",O19<>\"\",P19<>\"\"),IF(P19<6,IF(O19>=50,(N19-(SUM($N$5:N19)-ROUNDDOWN(SUM($N$5:N19),0)))*variables!$B$5,(N19-(SUM($N$5:N19)-ROUNDDOWN(SUM($N$5:N19),0)))*variables!$B$5*O19/100),(N19-(SUM($N$5:N19)-ROUNDDOWN(SUM($N$5:N19),0)))*variables!$B$5),\"\"),IF(AND(M19<>\"\",N19<>\"\",O19<>\"\",P19<>\"\"),IF(P19<6,IF(O19>=50,N19*variables!$B$5,N19*variables!$B$5*O19/100),N19*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G21)=0,IF(AND(F20<>\"\",G20<>\"\",H20<>\"\"),IF(H20<6,IF(G20>=50,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4*G20/100),(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4),\"\"),IF(AND(F20<>\"\",G20<>\"\",H20<>\"\"),IF(H20<6,IF(G20>=50,F20*variables!$B$4,F20*variables!$B$4*G20/100),F20*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O21)=0,IF(AND(M20<>\"\",N20<>\"\",O20<>\"\",P20<>\"\"),IF(P20<6,IF(O20>=50,(N20-(SUM($N$5:N20)-ROUNDDOWN(SUM($N$5:N20),0)))*variables!$B$5,(N20-(SUM($N$5:N20)-ROUNDDOWN(SUM($N$5:N20),0)))*variables!$B$5*O20/100),(N20-(SUM($N$5:N20)-ROUNDDOWN(SUM($N$5:N20),0)))*variables!$B$5),\"\"),IF(AND(M20<>\"\",N20<>\"\",O20<>\"\",P20<>\"\"),IF(P20<6,IF(O20>=50,N20*variables!$B$5,N20*variables!$B$5*O20/100),N20*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G22)=0,IF(AND(F21<>\"\",G21<>\"\",H21<>\"\"),IF(H21<6,IF(G21>=50,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4*G21/100),(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4),\"\"),IF(AND(F21<>\"\",G21<>\"\",H21<>\"\"),IF(H21<6,IF(G21>=50,F21*variables!$B$4,F21*variables!$B$4*G21/100),F21*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O22)=0,IF(AND(M21<>\"\",N21<>\"\",O21<>\"\",P21<>\"\"),IF(P21<6,IF(O21>=50,(N21-(SUM($N$5:N21)-ROUNDDOWN(SUM($N$5:N21),0)))*variables!$B$5,(N21-(SUM($N$5:N21)-ROUNDDOWN(SUM($N$5:N21),0)))*variables!$B$5*O21/100),(N21-(SUM($N$5:N21)-ROUNDDOWN(SUM($N$5:N21),0)))*variables!$B$5),\"\"),IF(AND(M21<>\"\",N21<>\"\",O21<>\"\",P21<>\"\"),IF(P21<6,IF(O21>=50,N21*variables!$B$5,N21*variables!$B$5*O21/100),N21*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G23)=0,IF(AND(F22<>\"\",G22<>\"\",H22<>\"\"),IF(H22<6,IF(G22>=50,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4*G22/100),(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4),\"\"),IF(AND(F22<>\"\",G22<>\"\",H22<>\"\"),IF(H22<6,IF(G22>=50,F22*variables!$B$4,F22*variables!$B$4*G22/100),F22*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O23)=0,IF(AND(M22<>\"\",N22<>\"\",O22<>\"\",P22<>\"\"),IF(P22<6,IF(O22>=50,(N22-(SUM($N$5:N22)-ROUNDDOWN(SUM($N$5:N22),0)))*variables!$B$5,(N22-(SUM($N$5:N22)-ROUNDDOWN(SUM($N$5:N22),0)))*variables!$B$5*O22/100),(N22-(SUM($N$5:N22)-ROUNDDOWN(SUM($N$5:N22),0)))*variables!$B$5),\"\"),IF(AND(M22<>\"\",N22<>\"\",O22<>\"\",P22<>\"\"),IF(P22<6,IF(O22>=50,N22*variables!$B$5,N22*variables!$B$5*O22/100),N22*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G24)=0,IF(AND(F23<>\"\",G23<>\"\",H23<>\"\"),IF(H23<6,IF(G23>=50,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4*G23/100),(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4),\"\"),IF(AND(F23<>\"\",G23<>\"\",H23<>\"\"),IF(H23<6,IF(G23>=50,F23*variables!$B$4,F23*variables!$B$4*G23/100),F23*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O24)=0,IF(AND(M23<>\"\",N23<>\"\",O23<>\"\",P23<>\"\"),IF(P23<6,IF(O23>=50,(N23-(SUM($N$5:N23)-ROUNDDOWN(SUM($N$5:N23),0)))*variables!$B$5,(N23-(SUM($N$5:N23)-ROUNDDOWN(SUM($N$5:N23),0)))*variables!$B$5*O23/100),(N23-(SUM($N$5:N23)-ROUNDDOWN(SUM($N$5:N23),0)))*variables!$B$5),\"\"),IF(AND(M23<>\"\",N23<>\"\",O23<>\"\",P23<>\"\"),IF(P23<6,IF(O23>=50,N23*variables!$B$5,N23*variables!$B$5*O23/100),N23*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G25)=0,IF(AND(F24<>\"\",G24<>\"\",H24<>\"\"),IF(H24<6,IF(G24>=50,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4*G24/100),(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4),\"\"),IF(AND(F24<>\"\",G24<>\"\",H24<>\"\"),IF(H24<6,IF(G24>=50,F24*variables!$B$4,F24*variables!$B$4*G24/100),F24*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O25)=0,IF(AND(M24<>\"\",N24<>\"\",O24<>\"\",P24<>\"\"),IF(P24<6,IF(O24>=50,(N24-(SUM($N$5:N24)-ROUNDDOWN(SUM($N$5:N24),0)))*variables!$B$5,(N24-(SUM($N$5:N24)-ROUNDDOWN(SUM($N$5:N24),0)))*variables!$B$5*O24/100),(N24-(SUM($N$5:N24)-ROUNDDOWN(SUM($N$5:N24),0)))*variables!$B$5),\"\"),IF(AND(M24<>\"\",N24<>\"\",O24<>\"\",P24<>\"\"),IF(P24<6,IF(O24>=50,N24*variables!$B$5,N24*variables!$B$5*O24/100),N24*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G26)=0,IF(AND(F25<>\"\",G25<>\"\",H25<>\"\"),IF(H25<6,IF(G25>=50,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4*G25/100),(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4),\"\"),IF(AND(F25<>\"\",G25<>\"\",H25<>\"\"),IF(H25<6,IF(G25>=50,F25*variables!$B$4,F25*variables!$B$4*G25/100),F25*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O26)=0,IF(AND(M25<>\"\",N25<>\"\",O25<>\"\",P25<>\"\"),IF(P25<6,IF(O25>=50,(N25-(SUM($N$5:N25)-ROUNDDOWN(SUM($N$5:N25),0)))*variables!$B$5,(N25-(SUM($N$5:N25)-ROUNDDOWN(SUM($N$5:N25),0)))*variables!$B$5*O25/100),(N25-(SUM($N$5:N25)-ROUNDDOWN(SUM($N$5:N25),0)))*variables!$B$5),\"\"),IF(AND(M25<>\"\",N25<>\"\",O25<>\"\",P25<>\"\"),IF(P25<6,IF(O25>=50,N25*variables!$B$5,N25*variables!$B$5*O25/100),N25*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G27)=0,IF(AND(F26<>\"\",G26<>\"\",H26<>\"\"),IF(H26<6,IF(G26>=50,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4*G26/100),(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4),\"\"),IF(AND(F26<>\"\",G26<>\"\",H26<>\"\"),IF(H26<6,IF(G26>=50,F26*variables!$B$4,F26*variables!$B$4*G26/100),F26*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O27)=0,IF(AND(M26<>\"\",N26<>\"\",O26<>\"\",P26<>\"\"),IF(P26<6,IF(O26>=50,(N26-(SUM($N$5:N26)-ROUNDDOWN(SUM($N$5:N26),0)))*variables!$B$5,(N26-(SUM($N$5:N26)-ROUNDDOWN(SUM($N$5:N26),0)))*variables!$B$5*O26/100),(N26-(SUM($N$5:N26)-ROUNDDOWN(SUM($N$5:N26),0)))*variables!$B$5),\"\"),IF(AND(M26<>\"\",N26<>\"\",O26<>\"\",P26<>\"\"),IF(P26<6,IF(O26>=50,N26*variables!$B$5,N26*variables!$B$5*O26/100),N26*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G28)=0,IF(AND(F27<>\"\",G27<>\"\",H27<>\"\"),IF(H27<6,IF(G27>=50,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4*G27/100),(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4),\"\"),IF(AND(F27<>\"\",G27<>\"\",H27<>\"\"),IF(H27<6,IF(G27>=50,F27*variables!$B$4,F27*variables!$B$4*G27/100),F27*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O28)=0,IF(AND(M27<>\"\",N27<>\"\",O27<>\"\",P27<>\"\"),IF(P27<6,IF(O27>=50,(N27-(SUM($N$5:N27)-ROUNDDOWN(SUM($N$5:N27),0)))*variables!$B$5,(N27-(SUM($N$5:N27)-ROUNDDOWN(SUM($N$5:N27),0)))*variables!$B$5*O27/100),(N27-(SUM($N$5:N27)-ROUNDDOWN(SUM($N$5:N27),0)))*variables!$B$5),\"\"),IF(AND(M27<>\"\",N27<>\"\",O27<>\"\",P27<>\"\"),IF(P27<6,IF(O27>=50,N27*variables!$B$5,N27*variables!$B$5*O27/100),N27*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G29)=0,IF(AND(F28<>\"\",G28<>\"\",H28<>\"\"),IF(H28<6,IF(G28>=50,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4*G28/100),(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4),\"\"),IF(AND(F28<>\"\",G28<>\"\",H28<>\"\"),IF(H28<6,IF(G28>=50,F28*variables!$B$4,F28*variables!$B$4*G28/100),F28*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O29)=0,IF(AND(M28<>\"\",N28<>\"\",O28<>\"\",P28<>\"\"),IF(P28<6,IF(O28>=50,(N28-(SUM($N$5:N28)-ROUNDDOWN(SUM($N$5:N28),0)))*variables!$B$5,(N28-(SUM($N$5:N28)-ROUNDDOWN(SUM($N$5:N28),0)))*variables!$B$5*O28/100),(N28-(SUM($N$5:N28)-ROUNDDOWN(SUM($N$5:N28),0)))*variables!$B$5),\"\"),IF(AND(M28<>\"\",N28<>\"\",O28<>\"\",P28<>\"\"),IF(P28<6,IF(O28>=50,N28*variables!$B$5,N28*variables!$B$5*O28/100),N28*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G30)=0,IF(AND(F29<>\"\",G29<>\"\",H29<>\"\"),IF(H29<6,IF(G29>=50,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4*G29/100),(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4),\"\"),IF(AND(F29<>\"\",G29<>\"\",H29<>\"\"),IF(H29<6,IF(G29>=50,F29*variables!$B$4,F29*variables!$B$4*G29/100),F29*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O30)=0,IF(AND(M29<>\"\",N29<>\"\",O29<>\"\",P29<>\"\"),IF(P29<6,IF(O29>=50,(N29-(SUM($N$5:N29)-ROUNDDOWN(SUM($N$5:N29),0)))*variables!$B$5,(N29-(SUM($N$5:N29)-ROUNDDOWN(SUM($N$5:N29),0)))*variables!$B$5*O29/100),(N29-(SUM($N$5:N29)-ROUNDDOWN(SUM($N$5:N29),0)))*variables!$B$5),\"\"),IF(AND(M29<>\"\",N29<>\"\",O29<>\"\",P29<>\"\"),IF(P29<6,IF(O29>=50,N29*variables!$B$5,N29*variables!$B$5*O29/100),N29*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G31)=0,IF(AND(F30<>\"\",G30<>\"\",H30<>\"\"),IF(H30<6,IF(G30>=50,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4*G30/100),(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4),\"\"),IF(AND(F30<>\"\",G30<>\"\",H30<>\"\"),IF(H30<6,IF(G30>=50,F30*variables!$B$4,F30*variables!$B$4*G30/100),F30*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O31)=0,IF(AND(M30<>\"\",N30<>\"\",O30<>\"\",P30<>\"\"),IF(P30<6,IF(O30>=50,(N30-(SUM($N$5:N30)-ROUNDDOWN(SUM($N$5:N30),0)))*variables!$B$5,(N30-(SUM($N$5:N30)-ROUNDDOWN(SUM($N$5:N30),0)))*variables!$B$5*O30/100),(N30-(SUM($N$5:N30)-ROUNDDOWN(SUM($N$5:N30),0)))*variables!$B$5),\"\"),IF(AND(M30<>\"\",N30<>\"\",O30<>\"\",P30<>\"\"),IF(P30<6,IF(O30>=50,N30*variables!$B$5,N30*variables!$B$5*O30/100),N30*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G32)=0,IF(AND(F31<>\"\",G31<>\"\",H31<>\"\"),IF(H31<6,IF(G31>=50,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4*G31/100),(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4),\"\"),IF(AND(F31<>\"\",G31<>\"\",H31<>\"\"),IF(H31<6,IF(G31>=50,F31*variables!$B$4,F31*variables!$B$4*G31/100),F31*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O32)=0,IF(AND(M31<>\"\",N31<>\"\",O31<>\"\",P31<>\"\"),IF(P31<6,IF(O31>=50,(N31-(SUM($N$5:N31)-ROUNDDOWN(SUM($N$5:N31),0)))*variables!$B$5,(N31-(SUM($N$5:N31)-ROUNDDOWN(SUM($N$5:N31),0)))*variables!$B$5*O31/100),(N31-(SUM($N$5:N31)-ROUNDDOWN(SUM($N$5:N31),0)))*variables!$B$5),\"\"),IF(AND(M31<>\"\",N31<>\"\",O31<>\"\",P31<>\"\"),IF(P31<6,IF(O31>=50,N31*variables!$B$5,N31*variables!$B$5*O31/100),N31*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G33)=0,IF(AND(F32<>\"\",G32<>\"\",H32<>\"\"),IF(H32<6,IF(G32>=50,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4*G32/100),(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4),\"\"),IF(AND(F32<>\"\",G32<>\"\",H32<>\"\"),IF(H32<6,IF(G32>=50,F32*variables!$B$4,F32*variables!$B$4*G32/100),F32*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O33)=0,IF(AND(M32<>\"\",N32<>\"\",O32<>\"\",P32<>\"\"),IF(P32<6,IF(O32>=50,(N32-(SUM($N$5:N32)-ROUNDDOWN(SUM($N$5:N32),0)))*variables!$B$5,(N32-(SUM($N$5:N32)-ROUNDDOWN(SUM($N$5:N32),0)))*variables!$B$5*O32/100),(N32-(SUM($N$5:N32)-ROUNDDOWN(SUM($N$5:N32),0)))*variables!$B$5),\"\"),IF(AND(M32<>\"\",N32<>\"\",O32<>\"\",P32<>\"\"),IF(P32<6,IF(O32>=50,N32*variables!$B$5,N32*variables!$B$5*O32/100),N32*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G34)=0,IF(AND(F33<>\"\",G33<>\"\",H33<>\"\"),IF(H33<6,IF(G33>=50,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4*G33/100),(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4),\"\"),IF(AND(F33<>\"\",G33<>\"\",H33<>\"\"),IF(H33<6,IF(G33>=50,F33*variables!$B$4,F33*variables!$B$4*G33/100),F33*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O34)=0,IF(AND(M33<>\"\",N33<>\"\",O33<>\"\",P33<>\"\"),IF(P33<6,IF(O33>=50,(N33-(SUM($N$5:N33)-ROUNDDOWN(SUM($N$5:N33),0)))*variables!$B$5,(N33-(SUM($N$5:N33)-ROUNDDOWN(SUM($N$5:N33),0)))*variables!$B$5*O33/100),(N33-(SUM($N$5:N33)-ROUNDDOWN(SUM($N$5:N33),0)))*variables!$B$5),\"\"),IF(AND(M33<>\"\",N33<>\"\",O33<>\"\",P33<>\"\"),IF(P33<6,IF(O33>=50,N33*variables!$B$5,N33*variables!$B$5*O33/100),N33*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G35)=0,IF(AND(F34<>\"\",G34<>\"\",H34<>\"\"),IF(H34<6,IF(G34>=50,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4*G34/100),(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4),\"\"),IF(AND(F34<>\"\",G34<>\"\",H34<>\"\"),IF(H34<6,IF(G34>=50,F34*variables!$B$4,F34*variables!$B$4*G34/100),F34*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O35)=0,IF(AND(M34<>\"\",N34<>\"\",O34<>\"\",P34<>\"\"),IF(P34<6,IF(O34>=50,(N34-(SUM($N$5:N34)-ROUNDDOWN(SUM($N$5:N34),0)))*variables!$B$5,(N34-(SUM($N$5:N34)-ROUNDDOWN(SUM($N$5:N34),0)))*variables!$B$5*O34/100),(N34-(SUM($N$5:N34)-ROUNDDOWN(SUM($N$5:N34),0)))*variables!$B$5),\"\"),IF(AND(M34<>\"\",N34<>\"\",O34<>\"\",P34<>\"\"),IF(P34<6,IF(O34>=50,N34*variables!$B$5,N34*variables!$B$5*O34/100),N34*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G36)=0,IF(AND(F35<>\"\",G35<>\"\",H35<>\"\"),IF(H35<6,IF(G35>=50,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4*G35/100),(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4),\"\"),IF(AND(F35<>\"\",G35<>\"\",H35<>\"\"),IF(H35<6,IF(G35>=50,F35*variables!$B$4,F35*variables!$B$4*G35/100),F35*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O36)=0,IF(AND(M35<>\"\",N35<>\"\",O35<>\"\",P35<>\"\"),IF(P35<6,IF(O35>=50,(N35-(SUM($N$5:N35)-ROUNDDOWN(SUM($N$5:N35),0)))*variables!$B$5,(N35-(SUM($N$5:N35)-ROUNDDOWN(SUM($N$5:N35),0)))*variables!$B$5*O35/100),(N35-(SUM($N$5:N35)-ROUNDDOWN(SUM($N$5:N35),0)))*variables!$B$5),\"\"),IF(AND(M35<>\"\",N35<>\"\",O35<>\"\",P35<>\"\"),IF(P35<6,IF(O35>=50,N35*variables!$B$5,N35*variables!$B$5*O35/100),N35*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G37)=0,IF(AND(F36<>\"\",G36<>\"\",H36<>\"\"),IF(H36<6,IF(G36>=50,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4*G36/100),(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4),\"\"),IF(AND(F36<>\"\",G36<>\"\",H36<>\"\"),IF(H36<6,IF(G36>=50,F36*variables!$B$4,F36*variables!$B$4*G36/100),F36*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O37)=0,IF(AND(M36<>\"\",N36<>\"\",O36<>\"\",P36<>\"\"),IF(P36<6,IF(O36>=50,(N36-(SUM($N$5:N36)-ROUNDDOWN(SUM($N$5:N36),0)))*variables!$B$5,(N36-(SUM($N$5:N36)-ROUNDDOWN(SUM($N$5:N36),0)))*variables!$B$5*O36/100),(N36-(SUM($N$5:N36)-ROUNDDOWN(SUM($N$5:N36),0)))*variables!$B$5),\"\"),IF(AND(M36<>\"\",N36<>\"\",O36<>\"\",P36<>\"\"),IF(P36<6,IF(O36>=50,N36*variables!$B$5,N36*variables!$B$5*O36/100),N36*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G38)=0,IF(AND(F37<>\"\",G37<>\"\",H37<>\"\"),IF(H37<6,IF(G37>=50,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4*G37/100),(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4),\"\"),IF(AND(F37<>\"\",G37<>\"\",H37<>\"\"),IF(H37<6,IF(G37>=50,F37*variables!$B$4,F37*variables!$B$4*G37/100),F37*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O38)=0,IF(AND(M37<>\"\",N37<>\"\",O37<>\"\",P37<>\"\"),IF(P37<6,IF(O37>=50,(N37-(SUM($N$5:N37)-ROUNDDOWN(SUM($N$5:N37),0)))*variables!$B$5,(N37-(SUM($N$5:N37)-ROUNDDOWN(SUM($N$5:N37),0)))*variables!$B$5*O37/100),(N37-(SUM($N$5:N37)-ROUNDDOWN(SUM($N$5:N37),0)))*variables!$B$5),\"\"),IF(AND(M37<>\"\",N37<>\"\",O37<>\"\",P37<>\"\"),IF(P37<6,IF(O37>=50,N37*variables!$B$5,N37*variables!$B$5*O37/100),N37*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G39)=0,IF(AND(F38<>\"\",G38<>\"\",H38<>\"\"),IF(H38<6,IF(G38>=50,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4*G38/100),(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4),\"\"),IF(AND(F38<>\"\",G38<>\"\",H38<>\"\"),IF(H38<6,IF(G38>=50,F38*variables!$B$4,F38*variables!$B$4*G38/100),F38*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O39)=0,IF(AND(M38<>\"\",N38<>\"\",O38<>\"\",P38<>\"\"),IF(P38<6,IF(O38>=50,(N38-(SUM($N$5:N38)-ROUNDDOWN(SUM($N$5:N38),0)))*variables!$B$5,(N38-(SUM($N$5:N38)-ROUNDDOWN(SUM($N$5:N38),0)))*variables!$B$5*O38/100),(N38-(SUM($N$5:N38)-ROUNDDOWN(SUM($N$5:N38),0)))*variables!$B$5),\"\"),IF(AND(M38<>\"\",N38<>\"\",O38<>\"\",P38<>\"\"),IF(P38<6,IF(O38>=50,N38*variables!$B$5,N38*variables!$B$5*O38/100),N38*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G40)=0,IF(AND(F39<>\"\",G39<>\"\",H39<>\"\"),IF(H39<6,IF(G39>=50,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4*G39/100),(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4),\"\"),IF(AND(F39<>\"\",G39<>\"\",H39<>\"\"),IF(H39<6,IF(G39>=50,F39*variables!$B$4,F39*variables!$B$4*G39/100),F39*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O40)=0,IF(AND(M39<>\"\",N39<>\"\",O39<>\"\",P39<>\"\"),IF(P39<6,IF(O39>=50,(N39-(SUM($N$5:N39)-ROUNDDOWN(SUM($N$5:N39),0)))*variables!$B$5,(N39-(SUM($N$5:N39)-ROUNDDOWN(SUM($N$5:N39),0)))*variables!$B$5*O39/100),(N39-(SUM($N$5:N39)-ROUNDDOWN(SUM($N$5:N39),0)))*variables!$B$5),\"\"),IF(AND(M39<>\"\",N39<>\"\",O39<>\"\",P39<>\"\"),IF(P39<6,IF(O39>=50,N39*variables!$B$5,N39*variables!$B$5*O39/100),N39*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G41)=0,IF(AND(F40<>\"\",G40<>\"\",H40<>\"\"),IF(H40<6,IF(G40>=50,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4*G40/100),(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4),\"\"),IF(AND(F40<>\"\",G40<>\"\",H40<>\"\"),IF(H40<6,IF(G40>=50,F40*variables!$B$4,F40*variables!$B$4*G40/100),F40*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O41)=0,IF(AND(M40<>\"\",N40<>\"\",O40<>\"\",P40<>\"\"),IF(P40<6,IF(O40>=50,(N40-(SUM($N$5:N40)-ROUNDDOWN(SUM($N$5:N40),0)))*variables!$B$5,(N40-(SUM($N$5:N40)-ROUNDDOWN(SUM($N$5:N40),0)))*variables!$B$5*O40/100),(N40-(SUM($N$5:N40)-ROUNDDOWN(SUM($N$5:N40),0)))*variables!$B$5),\"\"),IF(AND(M40<>\"\",N40<>\"\",O40<>\"\",P40<>\"\"),IF(P40<6,IF(O40>=50,N40*variables!$B$5,N40*variables!$B$5*O40/100),N40*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G42)=0,IF(AND(F41<>\"\",G41<>\"\",H41<>\"\"),IF(H41<6,IF(G41>=50,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4*G41/100),(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4),\"\"),IF(AND(F41<>\"\",G41<>\"\",H41<>\"\"),IF(H41<6,IF(G41>=50,F41*variables!$B$4,F41*variables!$B$4*G41/100),F41*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O42)=0,IF(AND(M41<>\"\",N41<>\"\",O41<>\"\",P41<>\"\"),IF(P41<6,IF(O41>=50,(N41-(SUM($N$5:N41)-ROUNDDOWN(SUM($N$5:N41),0)))*variables!$B$5,(N41-(SUM($N$5:N41)-ROUNDDOWN(SUM($N$5:N41),0)))*variables!$B$5*O41/100),(N41-(SUM($N$5:N41)-ROUNDDOWN(SUM($N$5:N41),0)))*variables!$B$5),\"\"),IF(AND(M41<>\"\",N41<>\"\",O41<>\"\",P41<>\"\"),IF(P41<6,IF(O41>=50,N41*variables!$B$5,N41*variables!$B$5*O41/100),N41*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G43)=0,IF(AND(F42<>\"\",G42<>\"\",H42<>\"\"),IF(H42<6,IF(G42>=50,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4*G42/100),(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4),\"\"),IF(AND(F42<>\"\",G42<>\"\",H42<>\"\"),IF(H42<6,IF(G42>=50,F42*variables!$B$4,F42*variables!$B$4*G42/100),F42*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O43)=0,IF(AND(M42<>\"\",N42<>\"\",O42<>\"\",P42<>\"\"),IF(P42<6,IF(O42>=50,(N42-(SUM($N$5:N42)-ROUNDDOWN(SUM($N$5:N42),0)))*variables!$B$5,(N42-(SUM($N$5:N42)-ROUNDDOWN(SUM($N$5:N42),0)))*variables!$B$5*O42/100),(N42-(SUM($N$5:N42)-ROUNDDOWN(SUM($N$5:N42),0)))*variables!$B$5),\"\"),IF(AND(M42<>\"\",N42<>\"\",O42<>\"\",P42<>\"\"),IF(P42<6,IF(O42>=50,N42*variables!$B$5,N42*variables!$B$5*O42/100),N42*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G44)=0,IF(AND(F43<>\"\",G43<>\"\",H43<>\"\"),IF(H43<6,IF(G43>=50,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4*G43/100),(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4),\"\"),IF(AND(F43<>\"\",G43<>\"\",H43<>\"\"),IF(H43<6,IF(G43>=50,F43*variables!$B$4,F43*variables!$B$4*G43/100),F43*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O44)=0,IF(AND(M43<>\"\",N43<>\"\",O43<>\"\",P43<>\"\"),IF(P43<6,IF(O43>=50,(N43-(SUM($N$5:N43)-ROUNDDOWN(SUM($N$5:N43),0)))*variables!$B$5,(N43-(SUM($N$5:N43)-ROUNDDOWN(SUM($N$5:N43),0)))*variables!$B$5*O43/100),(N43-(SUM($N$5:N43)-ROUNDDOWN(SUM($N$5:N43),0)))*variables!$B$5),\"\"),IF(AND(M43<>\"\",N43<>\"\",O43<>\"\",P43<>\"\"),IF(P43<6,IF(O43>=50,N43*variables!$B$5,N43*variables!$B$5*O43/100),N43*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G45)=0,IF(AND(F44<>\"\",G44<>\"\",H44<>\"\"),IF(H44<6,IF(G44>=50,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4*G44/100),(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4),\"\"),IF(AND(F44<>\"\",G44<>\"\",H44<>\"\"),IF(H44<6,IF(G44>=50,F44*variables!$B$4,F44*variables!$B$4*G44/100),F44*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O45)=0,IF(AND(M44<>\"\",N44<>\"\",O44<>\"\",P44<>\"\"),IF(P44<6,IF(O44>=50,(N44-(SUM($N$5:N44)-ROUNDDOWN(SUM($N$5:N44),0)))*variables!$B$5,(N44-(SUM($N$5:N44)-ROUNDDOWN(SUM($N$5:N44),0)))*variables!$B$5*O44/100),(N44-(SUM($N$5:N44)-ROUNDDOWN(SUM($N$5:N44),0)))*variables!$B$5),\"\"),IF(AND(M44<>\"\",N44<>\"\",O44<>\"\",P44<>\"\"),IF(P44<6,IF(O44>=50,N44*variables!$B$5,N44*variables!$B$5*O44/100),N44*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G46)=0,IF(AND(F45<>\"\",G45<>\"\",H45<>\"\"),IF(H45<6,IF(G45>=50,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4*G45/100),(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4),\"\"),IF(AND(F45<>\"\",G45<>\"\",H45<>\"\"),IF(H45<6,IF(G45>=50,F45*variables!$B$4,F45*variables!$B$4*G45/100),F45*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O46)=0,IF(AND(M45<>\"\",N45<>\"\",O45<>\"\",P45<>\"\"),IF(P45<6,IF(O45>=50,(N45-(SUM($N$5:N45)-ROUNDDOWN(SUM($N$5:N45),0)))*variables!$B$5,(N45-(SUM($N$5:N45)-ROUNDDOWN(SUM($N$5:N45),0)))*variables!$B$5*O45/100),(N45-(SUM($N$5:N45)-ROUNDDOWN(SUM($N$5:N45),0)))*variables!$B$5),\"\"),IF(AND(M45<>\"\",N45<>\"\",O45<>\"\",P45<>\"\"),IF(P45<6,IF(O45>=50,N45*variables!$B$5,N45*variables!$B$5*O45/100),N45*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G47)=0,IF(AND(F46<>\"\",G46<>\"\",H46<>\"\"),IF(H46<6,IF(G46>=50,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4*G46/100),(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4),\"\"),IF(AND(F46<>\"\",G46<>\"\",H46<>\"\"),IF(H46<6,IF(G46>=50,F46*variables!$B$4,F46*variables!$B$4*G46/100),F46*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O47)=0,IF(AND(M46<>\"\",N46<>\"\",O46<>\"\",P46<>\"\"),IF(P46<6,IF(O46>=50,(N46-(SUM($N$5:N46)-ROUNDDOWN(SUM($N$5:N46),0)))*variables!$B$5,(N46-(SUM($N$5:N46)-ROUNDDOWN(SUM($N$5:N46),0)))*variables!$B$5*O46/100),(N46-(SUM($N$5:N46)-ROUNDDOWN(SUM($N$5:N46),0)))*variables!$B$5),\"\"),IF(AND(M46<>\"\",N46<>\"\",O46<>\"\",P46<>\"\"),IF(P46<6,IF(O46>=50,N46*variables!$B$5,N46*variables!$B$5*O46/100),N46*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G48)=0,IF(AND(F47<>\"\",G47<>\"\",H47<>\"\"),IF(H47<6,IF(G47>=50,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4*G47/100),(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4),\"\"),IF(AND(F47<>\"\",G47<>\"\",H47<>\"\"),IF(H47<6,IF(G47>=50,F47*variables!$B$4,F47*variables!$B$4*G47/100),F47*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O48)=0,IF(AND(M47<>\"\",N47<>\"\",O47<>\"\",P47<>\"\"),IF(P47<6,IF(O47>=50,(N47-(SUM($N$5:N47)-ROUNDDOWN(SUM($N$5:N47),0)))*variables!$B$5,(N47-(SUM($N$5:N47)-ROUNDDOWN(SUM($N$5:N47),0)))*variables!$B$5*O47/100),(N47-(SUM($N$5:N47)-ROUNDDOWN(SUM($N$5:N47),0)))*variables!$B$5),\"\"),IF(AND(M47<>\"\",N47<>\"\",O47<>\"\",P47<>\"\"),IF(P47<6,IF(O47>=50,N47*variables!$B$5,N47*variables!$B$5*O47/100),N47*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G49)=0,IF(AND(F48<>\"\",G48<>\"\",H48<>\"\"),IF(H48<6,IF(G48>=50,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4*G48/100),(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4),\"\"),IF(AND(F48<>\"\",G48<>\"\",H48<>\"\"),IF(H48<6,IF(G48>=50,F48*variables!$B$4,F48*variables!$B$4*G48/100),F48*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O49)=0,IF(AND(M48<>\"\",N48<>\"\",O48<>\"\",P48<>\"\"),IF(P48<6,IF(O48>=50,(N48-(SUM($N$5:N48)-ROUNDDOWN(SUM($N$5:N48),0)))*variables!$B$5,(N48-(SUM($N$5:N48)-ROUNDDOWN(SUM($N$5:N48),0)))*variables!$B$5*O48/100),(N48-(SUM($N$5:N48)-ROUNDDOWN(SUM($N$5:N48),0)))*variables!$B$5),\"\"),IF(AND(M48<>\"\",N48<>\"\",O48<>\"\",P48<>\"\"),IF(P48<6,IF(O48>=50,N48*variables!$B$5,N48*variables!$B$5*O48/100),N48*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G50)=0,IF(AND(F49<>\"\",G49<>\"\",H49<>\"\"),IF(H49<6,IF(G49>=50,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4*G49/100),(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4),\"\"),IF(AND(F49<>\"\",G49<>\"\",H49<>\"\"),IF(H49<6,IF(G49>=50,F49*variables!$B$4,F49*variables!$B$4*G49/100),F49*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O50)=0,IF(AND(M49<>\"\",N49<>\"\",O49<>\"\",P49<>\"\"),IF(P49<6,IF(O49>=50,(N49-(SUM($N$5:N49)-ROUNDDOWN(SUM($N$5:N49),0)))*variables!$B$5,(N49-(SUM($N$5:N49)-ROUNDDOWN(SUM($N$5:N49),0)))*variables!$B$5*O49/100),(N49-(SUM($N$5:N49)-ROUNDDOWN(SUM($N$5:N49),0)))*variables!$B$5),\"\"),IF(AND(M49<>\"\",N49<>\"\",O49<>\"\",P49<>\"\"),IF(P49<6,IF(O49>=50,N49*variables!$B$5,N49*variables!$B$5*O49/100),N49*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G51)=0,IF(AND(F50<>\"\",G50<>\"\",H50<>\"\"),IF(H50<6,IF(G50>=50,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4*G50/100),(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4),\"\"),IF(AND(F50<>\"\",G50<>\"\",H50<>\"\"),IF(H50<6,IF(G50>=50,F50*variables!$B$4,F50*variables!$B$4*G50/100),F50*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O51)=0,IF(AND(M50<>\"\",N50<>\"\",O50<>\"\",P50<>\"\"),IF(P50<6,IF(O50>=50,(N50-(SUM($N$5:N50)-ROUNDDOWN(SUM($N$5:N50),0)))*variables!$B$5,(N50-(SUM($N$5:N50)-ROUNDDOWN(SUM($N$5:N50),0)))*variables!$B$5*O50/100),(N50-(SUM($N$5:N50)-ROUNDDOWN(SUM($N$5:N50),0)))*variables!$B$5),\"\"),IF(AND(M50<>\"\",N50<>\"\",O50<>\"\",P50<>\"\"),IF(P50<6,IF(O50>=50,N50*variables!$B$5,N50*variables!$B$5*O50/100),N50*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G52)=0,IF(AND(F51<>\"\",G51<>\"\",H51<>\"\"),IF(H51<6,IF(G51>=50,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4*G51/100),(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4),\"\"),IF(AND(F51<>\"\",G51<>\"\",H51<>\"\"),IF(H51<6,IF(G51>=50,F51*variables!$B$4,F51*variables!$B$4*G51/100),F51*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O52)=0,IF(AND(M51<>\"\",N51<>\"\",O51<>\"\",P51<>\"\"),IF(P51<6,IF(O51>=50,(N51-(SUM($N$5:N51)-ROUNDDOWN(SUM($N$5:N51),0)))*variables!$B$5,(N51-(SUM($N$5:N51)-ROUNDDOWN(SUM($N$5:N51),0)))*variables!$B$5*O51/100),(N51-(SUM($N$5:N51)-ROUNDDOWN(SUM($N$5:N51),0)))*variables!$B$5),\"\"),IF(AND(M51<>\"\",N51<>\"\",O51<>\"\",P51<>\"\"),IF(P51<6,IF(O51>=50,N51*variables!$B$5,N51*variables!$B$5*O51/100),N51*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G53)=0,IF(AND(F52<>\"\",G52<>\"\",H52<>\"\"),IF(H52<6,IF(G52>=50,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4*G52/100),(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4),\"\"),IF(AND(F52<>\"\",G52<>\"\",H52<>\"\"),IF(H52<6,IF(G52>=50,F52*variables!$B$4,F52*variables!$B$4*G52/100),F52*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O53)=0,IF(AND(M52<>\"\",N52<>\"\",O52<>\"\",P52<>\"\"),IF(P52<6,IF(O52>=50,(N52-(SUM($N$5:N52)-ROUNDDOWN(SUM($N$5:N52),0)))*variables!$B$5,(N52-(SUM($N$5:N52)-ROUNDDOWN(SUM($N$5:N52),0)))*variables!$B$5*O52/100),(N52-(SUM($N$5:N52)-ROUNDDOWN(SUM($N$5:N52),0)))*variables!$B$5),\"\"),IF(AND(M52<>\"\",N52<>\"\",O52<>\"\",P52<>\"\"),IF(P52<6,IF(O52>=50,N52*variables!$B$5,N52*variables!$B$5*O52/100),N52*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G54)=0,IF(AND(F53<>\"\",G53<>\"\",H53<>\"\"),IF(H53<6,IF(G53>=50,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4*G53/100),(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4),\"\"),IF(AND(F53<>\"\",G53<>\"\",H53<>\"\"),IF(H53<6,IF(G53>=50,F53*variables!$B$4,F53*variables!$B$4*G53/100),F53*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O54)=0,IF(AND(M53<>\"\",N53<>\"\",O53<>\"\",P53<>\"\"),IF(P53<6,IF(O53>=50,(N53-(SUM($N$5:N53)-ROUNDDOWN(SUM($N$5:N53),0)))*variables!$B$5,(N53-(SUM($N$5:N53)-ROUNDDOWN(SUM($N$5:N53),0)))*variables!$B$5*O53/100),(N53-(SUM($N$5:N53)-ROUNDDOWN(SUM($N$5:N53),0)))*variables!$B$5),\"\"),IF(AND(M53<>\"\",N53<>\"\",O53<>\"\",P53<>\"\"),IF(P53<6,IF(O53>=50,N53*variables!$B$5,N53*variables!$B$5*O53/100),N53*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G55)=0,IF(AND(F54<>\"\",G54<>\"\",H54<>\"\"),IF(H54<6,IF(G54>=50,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4*G54/100),(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4),\"\"),IF(AND(F54<>\"\",G54<>\"\",H54<>\"\"),IF(H54<6,IF(G54>=50,F54*variables!$B$4,F54*variables!$B$4*G54/100),F54*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O55)=0,IF(AND(M54<>\"\",N54<>\"\",O54<>\"\",P54<>\"\"),IF(P54<6,IF(O54>=50,(N54-(SUM($N$5:N54)-ROUNDDOWN(SUM($N$5:N54),0)))*variables!$B$5,(N54-(SUM($N$5:N54)-ROUNDDOWN(SUM($N$5:N54),0)))*variables!$B$5*O54/100),(N54-(SUM($N$5:N54)-ROUNDDOWN(SUM($N$5:N54),0)))*variables!$B$5),\"\"),IF(AND(M54<>\"\",N54<>\"\",O54<>\"\",P54<>\"\"),IF(P54<6,IF(O54>=50,N54*variables!$B$5,N54*variables!$B$5*O54/100),N54*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G56)=0,IF(AND(F55<>\"\",G55<>\"\",H55<>\"\"),IF(H55<6,IF(G55>=50,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4*G55/100),(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4),\"\"),IF(AND(F55<>\"\",G55<>\"\",H55<>\"\"),IF(H55<6,IF(G55>=50,F55*variables!$B$4,F55*variables!$B$4*G55/100),F55*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O56)=0,IF(AND(M55<>\"\",N55<>\"\",O55<>\"\",P55<>\"\"),IF(P55<6,IF(O55>=50,(N55-(SUM($N$5:N55)-ROUNDDOWN(SUM($N$5:N55),0)))*variables!$B$5,(N55-(SUM($N$5:N55)-ROUNDDOWN(SUM($N$5:N55),0)))*variables!$B$5*O55/100),(N55-(SUM($N$5:N55)-ROUNDDOWN(SUM($N$5:N55),0)))*variables!$B$5),\"\"),IF(AND(M55<>\"\",N55<>\"\",O55<>\"\",P55<>\"\"),IF(P55<6,IF(O55>=50,N55*variables!$B$5,N55*variables!$B$5*O55/100),N55*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G57)=0,IF(AND(F56<>\"\",G56<>\"\",H56<>\"\"),IF(H56<6,IF(G56>=50,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4*G56/100),(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4),\"\"),IF(AND(F56<>\"\",G56<>\"\",H56<>\"\"),IF(H56<6,IF(G56>=50,F56*variables!$B$4,F56*variables!$B$4*G56/100),F56*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O57)=0,IF(AND(M56<>\"\",N56<>\"\",O56<>\"\",P56<>\"\"),IF(P56<6,IF(O56>=50,(N56-(SUM($N$5:N56)-ROUNDDOWN(SUM($N$5:N56),0)))*variables!$B$5,(N56-(SUM($N$5:N56)-ROUNDDOWN(SUM($N$5:N56),0)))*variables!$B$5*O56/100),(N56-(SUM($N$5:N56)-ROUNDDOWN(SUM($N$5:N56),0)))*variables!$B$5),\"\"),IF(AND(M56<>\"\",N56<>\"\",O56<>\"\",P56<>\"\"),IF(P56<6,IF(O56>=50,N56*variables!$B$5,N56*variables!$B$5*O56/100),N56*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,"",null,"",{"$f":"IF(COUNTA(G58)=0,IF(AND(F57<>\"\",G57<>\"\",H57<>\"\"),IF(H57<6,IF(G57>=50,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4*G57/100),(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4),\"\"),IF(AND(F57<>\"\",G57<>\"\",H57<>\"\"),IF(H57<6,IF(G57>=50,F57*variables!$B$4,F57*variables!$B$4*G57/100),F57*variables!$B$4),\"\"))","v":""},null,null,null,null,"",null,"",{"$f":"IF(COUNTA(O58)=0,IF(AND(M57<>\"\",N57<>\"\",O57<>\"\",P57<>\"\"),IF(P57<6,IF(O57>=50,(N57-(SUM($N$5:N57)-ROUNDDOWN(SUM($N$5:N57),0)))*variables!$B$5,(N57-(SUM($N$5:N57)-ROUNDDOWN(SUM($N$5:N57),0)))*variables!$B$5*O57/100),(N57-(SUM($N$5:N57)-ROUNDDOWN(SUM($N$5:N57),0)))*variables!$B$5),\"\"),IF(AND(M57<>\"\",N57<>\"\",O57<>\"\",P57<>\"\"),IF(P57<6,IF(O57>=50,N57*variables!$B$5,N57*variables!$B$5*O57/100),N57*variables!$B$5),\"\"))","v":""}]
[null,null,null,null,null,null,"TOTAL: ",null,{"$f":"SUM(I5:I57)","v":0},null,null,null,null,null,"TOTAL: ",null,{"$f":"SUM(Q5:Q57)","v":0}]

{"sheet":"FORMACIÓN","index":2,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,12,0,13],[1,3,1,5],[1,6,1,8],[3,6,3,8],[4,6,4,8],[5,6,5,8],[10,6,10,8],[6,3,6,5],[6,6,6,8],[6,13,8,13],[2,12,10,12],[2,13,5,13],[9,13,10,13],[7,6,7,8],[8,6,8,8],[9,6,9,8],[2,3,2,5],[2,6,2,8],[10,3,10,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[11,12,12,12],[11,13,11,14],[39,3,39,5],[33,3,33,5],[33,6,33,8],[12,13,12,14],[11,6,11,8],[12,6,12,8],[11,3,11,5],[12,3,12,5],[34,3,34,5],[34,6,34,8],[35,3,35,5],[35,6,35,8],[32,3,32,5],[32,6,32,8],[13,12,15,12],[13,13,13,14],[30,3,30,5],[30,6,30,8],[31,3,31,5],[31,6,31,8],[14,13,14,14],[22,6,22,8],[15,13,15,14],[13,6,13,8],[14,6,14,8],[15,6,15,8],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,12,18,12],[16,13,16,14],[17,13,17,14],[21,3,21,5],[22,12,22,14],[16,6,16,8],[16,3,16,5],[25,3,25,5],[26,3,26,5],[17,3,17,5],[18,3,18,5],[21,12,21,14],[19,6,19,8],[20,6,20,8],[21,6,21,8],[19,3,19,5],[20,3,20,5],[19,12,19,14],[22,3,22,5],[23,3,23,5],[24,3,24,5],[23,12,23,14],[18,13,18,14],[17,6,17,8],[18,6,18,8],[20,12,20,14],[28,13,28,14],[29,12,29,14],[28,6,28,8],[29,6,29,8],[28,3,28,5],[29,3,29,5],[26,12,28,12],[40,3,40,5],[40,6,40,8],[37,3,37,5],[37,6,37,8],[27,3,27,5],[27,6,27,8],[51,6,51,8],[24,12,24,14],[23,6,23,8],[24,6,24,8],[25,6,25,8],[26,6,26,8],[48,3,48,5],[48,6,48,8],[25,12,25,14],[49,3,49,5],[49,6,49,8],[47,3,47,5],[47,6,47,8],[43,3,43,5],[43,6,43,8],[45,6,45,8],[26,13,26,14],[27,13,27,14],[42,6,42,8],[42,3,42,5],[36,3,36,5],[36,6,36,8],[38,3,38,5],[38,6,38,8],[57,3,57,5],[57,6,57,8],[30,12,30,14],[55,3,55,5],[55,6,55,8],[56,3,56,5],[56,6,56,8],[52,3,52,5],[52,6,52,8],[53,3,53,5],[53,6,53,8],[41,3,41,5],[41,6,41,8],[54,3,54,5],[54,6,54,8],[50,3,50,5],[50,6,50,8],[46,3,46,5],[44,3,44,5],[44,6,44,8],[45,3,45,5],[39,6,39,8],[46,6,46,8],[51,3,51,5]]}
[null,null,null,"MÉRITOS FORMACIÓN:",null,null,null,null,null,null,null,null,"OTROS MÉRITOS (identificador 11):"]
[null,null,null,"DENOMINACIÓN ACTIVIDAD/CURSO",null,null,"ENTIDAD QUE IMPARTE / ASPIRANTE",null,null,"Nº HORAS","PUNTOS\n(automático)",null,"CONCEPTO","VARIACIÓN","Nº AUTORES","Nº UNIDADES","PUNTOS\n(automático)"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D3<>\"\",G3<>\"\",J3<>\"\"),IF(J3>300,variables!$E$6,IF(AND(J3>100,J3<=300),variables!$E$5,IF(AND(J3>40,J3<=100),variables!$E$4,IF(AND(J3>20,J3<=40),variables!$E$3,IF(AND(J3>0,J3<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"COMPOSICIONES","G. FORMATO",1,null,{"$f":"IF(P3<>\"\",P3*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D4<>\"\",G4<>\"\",J4<>\"\"),IF(J4>300,variables!$E$6,IF(AND(J4>100,J4<=300),variables!$E$5,IF(AND(J4>40,J4<=100),variables!$E$4,IF(AND(J4>20,J4<=40),variables!$E$3,IF(AND(J4>0,J4<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,2,null,{"$f":"IF(P4<>\"\",P4*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D5<>\"\",G5<>\"\",J5<>\"\"),IF(J5>300,variables!$E$6,IF(AND(J5>100,J5<=300),variables!$E$5,IF(AND(J5>40,J5<=100),variables!$E$4,IF(AND(J5>20,J5<=40),variables!$E$3,IF(AND(J5>0,J5<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,3,null,{"$f":"IF(P5<>\"\",P5*0.33,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D6<>\"\",G6<>\"\",J6<>\"\"),IF(J6>300,variables!$E$6,IF(AND(J6>100,J6<=300),variables!$E$5,IF(AND(J6>40,J6<=100),variables!$E$4,IF(AND(J6>20,J6<=40),variables!$E$3,IF(AND(J6>0,J6<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,"4 o más",null,{"$f":"IF(P6<>\"\",P6*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D7<>\"\",G7<>\"\",J7<>\"\"),IF(J7>300,variables!$E$6,IF(AND(J7>100,J7<=300),variables!$E$5,IF(AND(J7>40,J7<=100),variables!$E$4,IF(AND(J7>20,J7<=40),variables!$E$3,IF(AND(J7>0,J7<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"CAMERÍSTICA",1,null,{"$f":"IF(P7<>\"\",P7*0.75,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D8<>\"\",G8<>\"\",J8<>\"\"),IF(J8>300,variables!$E$6,IF(AND(J8>100,J8<=300),variables!$E$5,IF(AND(J8>40,J8<=100),variables!$E$4,IF(AND(J8>20,J8<=40),variables!$E$3,IF(AND(J8>0,J8<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,2,null,{"$f":"IF(P8<>\"\",P8*0.375,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D9<>\"\",G9<>\"\",J9<>\"\"),IF(J9>300,variables!$E$6,IF(AND(J9>100,J9<=300),variables!$E$5,IF(AND(J9>40,J9<=100),variables!$E$4,IF(AND(J9>20,J9<=40),variables!$E$3,IF(AND(J9>0,J9<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,"3 o más",null,{"$f":"IF(P9<>\"\",P9*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D10<>\"\",G10<>\"\",J10<>\"\"),IF(J10>300,variables!$E$6,IF(AND(J10>100,J10<=300),variables!$E$5,IF(AND(J10>40,J10<=100),variables!$E$4,IF(AND(J10>20,J10<=40),variables!$E$3,IF(AND(J10>0,J10<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"OTROS",1,null,{"$f":"IF(P10<>\"\",P10*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D11<>\"\",G11<>\"\",J11<>\"\"),IF(J11>300,variables!$E$6,IF(AND(J11>100,J11<=300),variables!$E$5,IF(AND(J11>40,J11<=100),variables!$E$4,IF(AND(J11>20,J11<=40),variables!$E$3,IF(AND(J11>0,J11<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,"2 o más",null,{"$f":"IF(P11<>\"\",P11*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D12<>\"\",G12<>\"\",J12<>\"\"),IF(J12>300,variables!$E$6,IF(AND(J12>100,J12<=300),variables!$E$5,IF(AND(J12>40,J12<=100),variables!$E$4,IF(AND(J12>20,J12<=40),variables!$E$3,IF(AND(J12>0,J12<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"CONCIERTOS","DIRECTOR/SOLISTA",null,null,{"$f":"IF(P12<>\"\",P12*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D13<>\"\",G13<>\"\",J13<>\"\"),IF(J13>300,variables!$E$6,IF(AND(J13>100,J13<=300),variables!$E$5,IF(AND(J13>40,J13<=100),variables!$E$4,IF(AND(J13>20,J13<=40),variables!$E$3,IF(AND(J13>0,J13<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"PARTICIPANTE",null,null,{"$f":"IF(P13<>\"\",P13*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D14<>\"\",G14<>\"\",J14<>\"\"),IF(J14>300,variables!$E$6,IF(AND(J14>100,J14<=300),variables!$E$5,IF(AND(J14>40,J14<=100),variables!$E$4,IF(AND(J14>20,J14<=40),variables!$E$3,IF(AND(J14>0,J14<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"LIBROS,\nMÉTODOS,\nPUBLICACIONES","como AUTOR",null,null,{"$f":"IF(P14<>\"\",P14*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D15<>\"\",G15<>\"\",J15<>\"\"),IF(J15>300,variables!$E$6,IF(AND(J15>100,J15<=300),variables!$E$5,IF(AND(J15>40,J15<=100),variables!$E$4,IF(AND(J15>20,J15<=40),variables!$E$3,IF(AND(J15>0,J15<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"como COAUTOR",null,null,{"$f":"IF(P15<>\"\",P15*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D16<>\"\",G16<>\"\",J16<>\"\"),IF(J16>300,variables!$E$6,IF(AND(J16>100,J16<=300),variables!$E$5,IF(AND(J16>40,J16<=100),variables!$E$4,IF(AND(J16>20,J16<=40),variables!$E$3,IF(AND(J16>0,J16<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"3 o más autores",null,null,{"$f":"IF(P16<>\"\",P16*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D17<>\"\",G17<>\"\",J17<>\"\"),IF(J17>300,variables!$E$6,IF(AND(J17>100,J17<=300),variables!$E$5,IF(AND(J17>40,J17<=100),variables!$E$4,IF(AND(J17>20,J17<=40),variables!$E$3,IF(AND(J17>0,J17<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"CAPÍTULOS\nDE\nLIBROS","como AUTOR",null,null,{"$f":"IF(P17<>\"\",P17*0.25,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D18<>\"\",G18<>\"\",J18<>\"\"),IF(J18>300,variables!$E$6,IF(AND(J18>100,J18<=300),variables!$E$5,IF(AND(J18>40,J18<=100),variables!$E$4,IF(AND(J18>20,J18<=40),variables!$E$3,IF(AND(J18>0,J18<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"como COAUTOR",null,null,{"$f":"IF(P18<>\"\",P18*0.15,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D19<>\"\",G19<>\"\",J19<>\"\"),IF(J19>300,variables!$E$6,IF(AND(J19>100,J19<=300),variables!$E$5,IF(AND(J19>40,J19<=100),variables!$E$4,IF(AND(J19>20,J19<=40),variables!$E$3,IF(AND(J19>0,J19<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"3 o más autores",null,null,{"$f":"IF(P19<>\"\",P19*0.05,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20<>\"\",G20<>\"\",J20<>\"\"),IF(J20>300,variables!$E$6,IF(AND(J20>100,J20<=300),variables!$E$5,IF(AND(J20>40,J20<=100),variables!$E$4,IF(AND(J20>20,J20<=40),variables!$E$3,IF(AND(J20>0,J20<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Montajes teatrales estrenados",null,null,null,{"$f":"IF(P20<>\"\",P20*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D21<>\"\",G21<>\"\",J21<>\"\"),IF(J21>300,variables!$E$6,IF(AND(J21>100,J21<=300),variables!$E$5,IF(AND(J21>40,J21<=100),variables!$E$4,IF(AND(J21>20,J21<=40),variables!$E$3,IF(AND(J21>0,J21<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Escenografía y/o figurín de obra estrenada",null,null,null,{"$f":"IF(P21<>\"\",P21*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D22<>\"\",G22<>\"\",J22<>\"\"),IF(J22>300,variables!$E$6,IF(AND(J22>100,J22<=300),variables!$E$5,IF(AND(J22>40,J22<=100),variables!$E$4,IF(AND(J22>20,J22<=40),variables!$E$3,IF(AND(J22>0,J22<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Exposición de Artes Plásticas y/o Diseño",null,null,null,{"$f":"IF(P22<>\"\",P22*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D23<>\"\",G23<>\"\",J23<>\"\"),IF(J23>300,variables!$E$6,IF(AND(J23>100,J23<=300),variables!$E$5,IF(AND(J23>40,J23<=100),variables!$E$4,IF(AND(J23>20,J23<=40),variables!$E$3,IF(AND(J23>0,J23<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Premios en exposiciones, festivales o concursos",null,null,null,{"$f":"IF(P23<>\"\",P23*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D24<>\"\",G24<>\"\",J24<>\"\"),IF(J24>300,variables!$E$6,IF(AND(J24>100,J24<=300),variables!$E$5,IF(AND(J24>40,J24<=100),variables!$E$4,IF(AND(J24>20,J24<=40),variables!$E$3,IF(AND(J24>0,J24<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Proyectos de investigación",null,null,null,{"$f":"IF(P24<>\"\",P24*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D25<>\"\",G25<>\"\",J25<>\"\"),IF(J25>300,variables!$E$6,IF(AND(J25>100,J25<=300),variables!$E$5,IF(AND(J25>40,J25<=100),variables!$E$4,IF(AND(J25>20,J25<=40),variables!$E$3,IF(AND(J25>0,J25<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Becas de Estudios",null,null,null,{"$f":"IF(P25<>\"\",P25*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D26<>\"\",G26<>\"\",J26<>\"\"),IF(J26>300,variables!$E$6,IF(AND(J26>100,J26<=300),variables!$E$5,IF(AND(J26>40,J26<=100),variables!$E$4,IF(AND(J26>20,J26<=40),variables!$E$3,IF(AND(J26>0,J26<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Participación en jurado de concurso",null,null,null,{"$f":"IF(P26<>\"\",P26*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D27<>\"\",G27<>\"\",J27<>\"\"),IF(J27>300,variables!$E$6,IF(AND(J27>100,J27<=300),variables!$E$5,IF(AND(J27>40,J27<=100),variables!$E$4,IF(AND(J27>20,J27<=40),variables!$E$3,IF(AND(J27>0,J27<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Gestión Escuelas","Director (años)",null,null,{"$f":"IF(P27<>\"\",P27*3,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D28<>\"\",G28<>\"\",J28<>\"\"),IF(J28>300,variables!$E$6,IF(AND(J28>100,J28<=300),variables!$E$5,IF(AND(J28>40,J28<=100),variables!$E$4,IF(AND(J28>20,J28<=40),variables!$E$3,IF(AND(J28>0,J28<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"Jefe estudios (años)",null,null,{"$f":"IF(P28<>\"\",P28*2,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D29<>\"\",G29<>\"\",J29<>\"\"),IF(J29>300,variables!$E$6,IF(AND(J29>100,J29<=300),variables!$E$5,IF(AND(J29>40,J29<=100),variables!$E$4,IF(AND(J29>20,J29<=40),variables!$E$3,IF(AND(J29>0,J29<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,"Secretario (añod)",null,null,{"$f":"IF(P29<>\"\",P29*1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D30<>\"\",G30<>\"\",J30<>\"\"),IF(J30>300,variables!$E$6,IF(AND(J30>100,J30<=300),variables!$E$5,IF(AND(J30>40,J30<=100),variables!$E$4,IF(AND(J30>20,J30<=40),variables!$E$3,IF(AND(J30>0,J30<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Jefaturas de Departamento (años)",null,null,null,{"$f":"IF(P30<>\"\",P30*0.5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D31<>\"\",G31<>\"\",J31<>\"\"),IF(J31>300,variables!$E$6,IF(AND(J31>100,J31<=300),variables!$E$5,IF(AND(J31>40,J31<=100),variables!$E$4,IF(AND(J31>20,J31<=40),variables!$E$3,IF(AND(J31>0,J31<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,"Titulaciones académicas superiores adicionales",null,null,null,{"$f":"IF(P31<>\"\",P31*5,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D32<>\"\",G32<>\"\",J32<>\"\"),IF(J32>300,variables!$E$6,IF(AND(J32>100,J32<=300),variables!$E$5,IF(AND(J32>40,J32<=100),variables!$E$4,IF(AND(J32>20,J32<=40),variables!$E$3,IF(AND(J32>0,J32<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""},null,null,null,null,"TOTAL: ",{"$f":"SUM(Q3:Q31)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D33<>\"\",G33<>\"\",J33<>\"\"),IF(J33>300,variables!$E$6,IF(AND(J33>100,J33<=300),variables!$E$5,IF(AND(J33>40,J33<=100),variables!$E$4,IF(AND(J33>20,J33<=40),variables!$E$3,IF(AND(J33>0,J33<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D34<>\"\",G34<>\"\",J34<>\"\"),IF(J34>300,variables!$E$6,IF(AND(J34>100,J34<=300),variables!$E$5,IF(AND(J34>40,J34<=100),variables!$E$4,IF(AND(J34>20,J34<=40),variables!$E$3,IF(AND(J34>0,J34<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D35<>\"\",G35<>\"\",J35<>\"\"),IF(J35>300,variables!$E$6,IF(AND(J35>100,J35<=300),variables!$E$5,IF(AND(J35>40,J35<=100),variables!$E$4,IF(AND(J35>20,J35<=40),variables!$E$3,IF(AND(J35>0,J35<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D36<>\"\",G36<>\"\",J36<>\"\"),IF(J36>300,variables!$E$6,IF(AND(J36>100,J36<=300),variables!$E$5,IF(AND(J36>40,J36<=100),variables!$E$4,IF(AND(J36>20,J36<=40),variables!$E$3,IF(AND(J36>0,J36<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D37<>\"\",G37<>\"\",J37<>\"\"),IF(J37>300,variables!$E$6,IF(AND(J37>100,J37<=300),variables!$E$5,IF(AND(J37>40,J37<=100),variables!$E$4,IF(AND(J37>20,J37<=40),variables!$E$3,IF(AND(J37>0,J37<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D38<>\"\",G38<>\"\",J38<>\"\"),IF(J38>300,variables!$E$6,IF(AND(J38>100,J38<=300),variables!$E$5,IF(AND(J38>40,J38<=100),variables!$E$4,IF(AND(J38>20,J38<=40),variables!$E$3,IF(AND(J38>0,J38<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D39<>\"\",G39<>\"\",J39<>\"\"),IF(J39>300,variables!$E$6,IF(AND(J39>100,J39<=300),variables!$E$5,IF(AND(J39>40,J39<=100),variables!$E$4,IF(AND(J39>20,J39<=40),variables!$E$3,IF(AND(J39>0,J39<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D40<>\"\",G40<>\"\",J40<>\"\"),IF(J40>300,variables!$E$6,IF(AND(J40>100,J40<=300),variables!$E$5,IF(AND(J40>40,J40<=100),variables!$E$4,IF(AND(J40>20,J40<=40),variables!$E$3,IF(AND(J40>0,J40<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D41<>\"\",G41<>\"\",J41<>\"\"),IF(J41>300,variables!$E$6,IF(AND(J41>100,J41<=300),variables!$E$5,IF(AND(J41>40,J41<=100),variables!$E$4,IF(AND(J41>20,J41<=40),variables!$E$3,IF(AND(J41>0,J41<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D42<>\"\",G42<>\"\",J42<>\"\"),IF(J42>300,variables!$E$6,IF(AND(J42>100,J42<=300),variables!$E$5,IF(AND(J42>40,J42<=100),variables!$E$4,IF(AND(J42>20,J42<=40),variables!$E$3,IF(AND(J42>0,J42<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D43<>\"\",G43<>\"\",J43<>\"\"),IF(J43>300,variables!$E$6,IF(AND(J43>100,J43<=300),variables!$E$5,IF(AND(J43>40,J43<=100),variables!$E$4,IF(AND(J43>20,J43<=40),variables!$E$3,IF(AND(J43>0,J43<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D44<>\"\",G44<>\"\",J44<>\"\"),IF(J44>300,variables!$E$6,IF(AND(J44>100,J44<=300),variables!$E$5,IF(AND(J44>40,J44<=100),variables!$E$4,IF(AND(J44>20,J44<=40),variables!$E$3,IF(AND(J44>0,J44<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D45<>\"\",G45<>\"\",J45<>\"\"),IF(J45>300,variables!$E$6,IF(AND(J45>100,J45<=300),variables!$E$5,IF(AND(J45>40,J45<=100),variables!$E$4,IF(AND(J45>20,J45<=40),variables!$E$3,IF(AND(J45>0,J45<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D46<>\"\",G46<>\"\",J46<>\"\"),IF(J46>300,variables!$E$6,IF(AND(J46>100,J46<=300),variables!$E$5,IF(AND(J46>40,J46<=100),variables!$E$4,IF(AND(J46>20,J46<=40),variables!$E$3,IF(AND(J46>0,J46<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D47<>\"\",G47<>\"\",J47<>\"\"),IF(J47>300,variables!$E$6,IF(AND(J47>100,J47<=300),variables!$E$5,IF(AND(J47>40,J47<=100),variables!$E$4,IF(AND(J47>20,J47<=40),variables!$E$3,IF(AND(J47>0,J47<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D48<>\"\",G48<>\"\",J48<>\"\"),IF(J48>300,variables!$E$6,IF(AND(J48>100,J48<=300),variables!$E$5,IF(AND(J48>40,J48<=100),variables!$E$4,IF(AND(J48>20,J48<=40),variables!$E$3,IF(AND(J48>0,J48<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D49<>\"\",G49<>\"\",J49<>\"\"),IF(J49>300,variables!$E$6,IF(AND(J49>100,J49<=300),variables!$E$5,IF(AND(J49>40,J49<=100),variables!$E$4,IF(AND(J49>20,J49<=40),variables!$E$3,IF(AND(J49>0,J49<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D50<>\"\",G50<>\"\",J50<>\"\"),IF(J50>300,variables!$E$6,IF(AND(J50>100,J50<=300),variables!$E$5,IF(AND(J50>40,J50<=100),variables!$E$4,IF(AND(J50>20,J50<=40),variables!$E$3,IF(AND(J50>0,J50<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D51<>\"\",G51<>\"\",J51<>\"\"),IF(J51>300,variables!$E$6,IF(AND(J51>100,J51<=300),variables!$E$5,IF(AND(J51>40,J51<=100),variables!$E$4,IF(AND(J51>20,J51<=40),variables!$E$3,IF(AND(J51>0,J51<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D52<>\"\",G52<>\"\",J52<>\"\"),IF(J52>300,variables!$E$6,IF(AND(J52>100,J52<=300),variables!$E$5,IF(AND(J52>40,J52<=100),variables!$E$4,IF(AND(J52>20,J52<=40),variables!$E$3,IF(AND(J52>0,J52<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D53<>\"\",G53<>\"\",J53<>\"\"),IF(J53>300,variables!$E$6,IF(AND(J53>100,J53<=300),variables!$E$5,IF(AND(J53>40,J53<=100),variables!$E$4,IF(AND(J53>20,J53<=40),variables!$E$3,IF(AND(J53>0,J53<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D54<>\"\",G54<>\"\",J54<>\"\"),IF(J54>300,variables!$E$6,IF(AND(J54>100,J54<=300),variables!$E$5,IF(AND(J54>40,J54<=100),variables!$E$4,IF(AND(J54>20,J54<=40),variables!$E$3,IF(AND(J54>0,J54<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D55<>\"\",G55<>\"\",J55<>\"\"),IF(J55>300,variables!$E$6,IF(AND(J55>100,J55<=300),variables!$E$5,IF(AND(J55>40,J55<=100),variables!$E$4,IF(AND(J55>20,J55<=40),variables!$E$3,IF(AND(J55>0,J55<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D56<>\"\",G56<>\"\",J56<>\"\"),IF(J56>300,variables!$E$6,IF(AND(J56>100,J56<=300),variables!$E$5,IF(AND(J56>40,J56<=100),variables!$E$4,IF(AND(J56>20,J56<=40),variables!$E$3,IF(AND(J56>0,J56<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D57<>\"\",G57<>\"\",J57<>\"\"),IF(J57>300,variables!$E$6,IF(AND(J57>100,J57<=300),variables!$E$5,IF(AND(J57>40,J57<=100),variables!$E$4,IF(AND(J57>20,J57<=40),variables!$E$3,IF(AND(J57>0,J57<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D58<>\"\",G58<>\"\",J58<>\"\"),IF(J58>300,variables!$E$6,IF(AND(J58>100,J58<=300),variables!$E$5,IF(AND(J58>40,J58<=100),variables!$E$4,IF(AND(J58>20,J58<=40),variables!$E$3,IF(AND(J58>0,J58<=20),variables!$E$2,variables!$E$1))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"TOTAL: ",{"$f":"SUM(K3:K58)","v":0}]

{"sheet":"TOTAL BAREMO","index":3,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":true,"merged":[[7,5,10,9],[11,5,14,9],[15,5,18,9],[15,10,18,10],[7,10,10,10],[11,10,14,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"EXPERIENCIA PROFESIONAL TOTAL: ",null,null,null,null,{"$f":"IF(SUM(EXPERIENCIA!$I$58,EXPERIENCIA!$Q$58)<variables!$B$1,SUM(EXPERIENCIA!$I$58,EXPERIENCIA!$Q$58),variables!$B$1)","v":0}]
[]
[]
[]
[null,null,null,null,null,"FORMACIÓN TOTAL: ",null,null,null,null,{"$f":"IF((FORMACIÓN!$K$59+FORMACIÓN!$Q$32)<variables!$B$2,FORMACIÓN!$K$59+FORMACIÓN!$Q$32,variables!$B$2)","v":0}]
[]
[]
[]
[null,null,null,null,null,"TOTAL BAREMO: ",null,null,null,null,{"$f":"SUM(K8:K15)","v":0}]

{"sheet":"variables","index":4,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["EXPERIENCIA (puntuación máxima)",90,null,"FORMACIÓN",0,null,"Documento de autobaremación para los procesos de estabilización por el procedimiento de CONCURSO-OPOSICIÓN"]
["FORMACIÓN (puntuación máxima)",{"$f":"100-B1","v":10},null,"0—20",0.35]
["# de PLAZA por la que se opta",{"$f":"VLOOKUP(B6,A9:D28,4,0)","v":1},null,"—40",0.65,null,{"$f":"CONCATENATE(H3,\" \",I3)","v":"Sección de: FORMACIÓN"},"Sección de:",{"$f":"MID(CELL(\"nombrearchivo\"),FIND(\"]\",CELL(\"nombrearchivo\"))+1,31)","v":"FORMACIÓN"}]
["EXP. MAJADAHONDA (puntos x mes)",{"$f":"INDEX(A9:C28,B3,2)","v":0},null,"—100",1]
["AA.PP. (puntos x mes)",{"$f":"INDEX(A9:C28,B3,3)","v":0},null,"—300",1.35]
["Plaza elegida:","Seleccione una opción…",null,">300",1.65]
[null,null,null,null,null,null,"AYUNTAMIENTO DE\nMAJADAHONDA\n(MADRID)\nRRHH"]
["Lista de Especialidades:","Maja","Ext","Ordinal"]
["Seleccione una opción…",0,0,1]
["01. PSICÓLOGO (laboral)",1.5,0.75,2]
["02. PSICÓLOGO (funcionario)",1.5,0.75,3]
["03. TRABAJADOR SOCIAL",1.5,0.75,4]
["04. TÉCNICO DE GESTIÓN",1.5,0.75,5]
["05. TÉCNICO AUXILIAR DE BIBLIOTECA",1.5,0.75,6]
["06. ADMINISTRATIVO",1.5,0.75,7]
["07. AUXILIAR ADMINISTRATIVO",1.5,0.75,8]
["08. ORDENANZA",1.5,0.75,9]
["09. CONSERJE ESCOLAR",1.5,0.75,10]
["10. AYUDANTE DE BIBLIOTECA",1.5,0.75,11]
["11. PROFESOR DE GUITARRA",1.5,0.75,12]
["12. PROFESOR DE MANUALIDADES",1.5,0.75,13]
["13. PROFESOR DE PINTURA",1.5,0.75,14]
["14. AYUDANTE DE SERVICIOS",1.5,0.75,15]
["15. AYUDANTE DE MANTENIMIENTO",1.5,0.75,16]
["16. AUXILIAR DE CLÍNICA",1.5,0.75,17]
["17. OFICIAL 2ª FONTANERÍA",1.5,0.75,18]
["18. OFICIAL 2ª ELECTRICISTA",1.5,0.75,19]
["19. OFICIAL 1ª",1.5,0.75,20]