{"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":false,"merged":[[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],[8,3,9,9],[8,10,9,11]]}
[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":59,"n_cols":19,"rows_kept":59,"cut":false,"hidden":true,"merged":[[58,6,58,8],[58,15,58,17],[0,3,0,4],[1,3,1,9],[1,11,1,18],[2,3,2,5],[2,6,2,9],[2,11,2,14],[2,15,2,18]]}
[null,null,null,"B.1 EXPERIENCIA:"]
[null,null,null,"EXPERIENCIA EN MAJADAHONDA",null,null,null,null,null,null,null,"EXPERIENCIA EN OTRAS AA.PP"]
[null,null,null,"PERÍODO",null,null,"CÁLCULO",null,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,null,{"$f":"IF(F5<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(G6)=0,IF(AND(F5<>\"\",G5<>\"\",I5<>\"\"),IF(I5<6,IF(G5>=50,IF(H5=50,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4/2,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4),IF(H5=50,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4*G5/100/2,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4*G5/100)),IF(H5=50,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4/2,(F5-(SUM($F$5:F5)-ROUNDDOWN(SUM($F$5:F5),0)))*variables!$B$4)),\"\"),IF(AND(F5<>\"\",G5<>\"\",I5<>\"\"),IF(I5<6,IF(G5>=50,IF(H5=50,F5*variables!$B$4/2,F5*variables!$B$4),IF(H5=50,F5*variables!$B$4*G5/100/2,F5*variables!$B$4*G5/100)),IF(H5=50,F5*variables!$B$4/2,F5*variables!$B$4)),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(L5<>\"\",M5<>\"\",N5<>\"\"),DATEDIF(L5,M5,\"y\")*12+DATEDIF(L5,M5,\"ym\")+DATEDIF(L5,M5,\"md\")/30,\"\")","v":""},null,null,{"$f":"IF(O5<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(P6)=0,IF(AND(N5<>\"\",O5<>\"\",P5<>\"\",R5<>\"\"),IF(R5<6,IF(P5>=50,IF(Q5=50,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5/2,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5),IF(Q5=50,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5*P5/100/2,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5*P5/100)),IF(Q5=50,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5/2,(O5-(SUM($O$5:O5)-ROUNDDOWN(SUM($O$5:O5),0)))*variables!$B$5)),\"\"),IF(AND(N5<>\"\",O5<>\"\",P5<>\"\",R5<>\"\"),IF(R5<6,IF(P5>=50,IF(Q5=50,O5*variables!$B$5/2,O5*variables!$B$5),IF(Q5=50,O5*variables!$B$5*P5/100/2,O5*variables!$B$5*P5/100)),IF(Q5=50,O5*variables!$B$5/2,O5*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,null,{"$f":"IF(F6<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(G7)=0,IF(AND(F6<>\"\",G6<>\"\",I6<>\"\"),IF(I6<6,IF(G6>=50,IF(H6=50,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4/2,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4),IF(H6=50,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4*G6/100/2,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4*G6/100)),IF(H6=50,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4/2,(F6-(SUM($F$5:F6)-ROUNDDOWN(SUM($F$5:F6),0)))*variables!$B$4)),\"\"),IF(AND(F6<>\"\",G6<>\"\",I6<>\"\"),IF(I6<6,IF(G6>=50,IF(H6=50,F6*variables!$B$4/2,F6*variables!$B$4),IF(H6=50,F6*variables!$B$4*G6/100/2,F6*variables!$B$4*G6/100)),IF(H6=50,F6*variables!$B$4/2,F6*variables!$B$4)),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(L6<>\"\",M6<>\"\",N6<>\"\"),DATEDIF(L6,M6,\"y\")*12+DATEDIF(L6,M6,\"ym\")+DATEDIF(L6,M6,\"md\")/30,\"\")","v":""},null,null,{"$f":"IF(O6<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(P7)=0,IF(AND(N6<>\"\",O6<>\"\",P6<>\"\",R6<>\"\"),IF(R6<6,IF(P6>=50,IF(Q6=50,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5/2,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5),IF(Q6=50,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5*P6/100/2,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5*P6/100)),IF(Q6=50,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5/2,(O6-(SUM($O$5:O6)-ROUNDDOWN(SUM($O$5:O6),0)))*variables!$B$5)),\"\"),IF(AND(N6<>\"\",O6<>\"\",P6<>\"\",R6<>\"\"),IF(R6<6,IF(P6>=50,IF(Q6=50,O6*variables!$B$5/2,O6*variables!$B$5),IF(Q6=50,O6*variables!$B$5*P6/100/2,O6*variables!$B$5*P6/100)),IF(Q6=50,O6*variables!$B$5/2,O6*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,null,{"$f":"IF(F7<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(G8)=0,IF(AND(F7<>\"\",G7<>\"\",I7<>\"\"),IF(I7<6,IF(G7>=50,IF(H7=50,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4/2,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4),IF(H7=50,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4*G7/100/2,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4*G7/100)),IF(H7=50,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4/2,(F7-(SUM($F$5:F7)-ROUNDDOWN(SUM($F$5:F7),0)))*variables!$B$4)),\"\"),IF(AND(F7<>\"\",G7<>\"\",I7<>\"\"),IF(I7<6,IF(G7>=50,IF(H7=50,F7*variables!$B$4/2,F7*variables!$B$4),IF(H7=50,F7*variables!$B$4*G7/100/2,F7*variables!$B$4*G7/100)),IF(H7=50,F7*variables!$B$4/2,F7*variables!$B$4)),\"\"))","v":""},null,null,null,null,{"$f":"IF(AND(L7<>\"\",M7<>\"\",N7<>\"\"),DATEDIF(L7,M7,\"y\")*12+DATEDIF(L7,M7,\"ym\")+DATEDIF(L7,M7,\"md\")/30,\"\")","v":""},null,null,{"$f":"IF(O7<>\"\",(SUM(F$5:F$58)+SUM(O$5:O$58))/12,\"\")","v":""},{"$f":"IF(COUNTA(P8)=0,IF(AND(N7<>\"\",O7<>\"\",P7<>\"\",R7<>\"\"),IF(R7<6,IF(P7>=50,IF(Q7=50,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5/2,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5),IF(Q7=50,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5*P7/100/2,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5*P7/100)),IF(Q7=50,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5/2,(O7-(SUM($O$5:O7)-ROUNDDOWN(SUM($O$5:O7),0)))*variables!$B$5)),\"\"),IF(AND(N7<>\"\",O7<>\"\",P7<>\"\",R7<>\"\"),IF(R7<6,IF(P7>=50,IF(Q7=50,O7*variables!$B$5/2,O7*variables!$B$5),IF(Q7=50,O7*variables!$B$5*P7/100/2,O7*variables!$B$5*P7/100)),IF(Q7=50,O7*variables!$B$5/2,O7*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G9)=0,IF(AND(F8<>\"\",G8<>\"\",I8<>\"\"),IF(I8<6,IF(G8>=50,IF(H8=50,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4/2,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4),IF(H8=50,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4*G8/100/2,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4*G8/100)),IF(H8=50,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4/2,(F8-(SUM($F$5:F8)-ROUNDDOWN(SUM($F$5:F8),0)))*variables!$B$4)),\"\"),IF(AND(F8<>\"\",G8<>\"\",I8<>\"\"),IF(I8<6,IF(G8>=50,IF(H8=50,F8*variables!$B$4/2,F8*variables!$B$4),IF(H8=50,F8*variables!$B$4*G8/100/2,F8*variables!$B$4*G8/100)),IF(H8=50,F8*variables!$B$4/2,F8*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P9)=0,IF(AND(N8<>\"\",O8<>\"\",P8<>\"\",R8<>\"\"),IF(R8<6,IF(P8>=50,IF(Q8=50,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5/2,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5),IF(Q8=50,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5*P8/100/2,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5*P8/100)),IF(Q8=50,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5/2,(O8-(SUM($O$5:O8)-ROUNDDOWN(SUM($O$5:O8),0)))*variables!$B$5)),\"\"),IF(AND(N8<>\"\",O8<>\"\",P8<>\"\",R8<>\"\"),IF(R8<6,IF(P8>=50,IF(Q8=50,O8*variables!$B$5/2,O8*variables!$B$5),IF(Q8=50,O8*variables!$B$5*P8/100/2,O8*variables!$B$5*P8/100)),IF(Q8=50,O8*variables!$B$5/2,O8*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G10)=0,IF(AND(F9<>\"\",G9<>\"\",I9<>\"\"),IF(I9<6,IF(G9>=50,IF(H9=50,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4/2,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4),IF(H9=50,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4*G9/100/2,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4*G9/100)),IF(H9=50,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4/2,(F9-(SUM($F$5:F9)-ROUNDDOWN(SUM($F$5:F9),0)))*variables!$B$4)),\"\"),IF(AND(F9<>\"\",G9<>\"\",I9<>\"\"),IF(I9<6,IF(G9>=50,IF(H9=50,F9*variables!$B$4/2,F9*variables!$B$4),IF(H9=50,F9*variables!$B$4*G9/100/2,F9*variables!$B$4*G9/100)),IF(H9=50,F9*variables!$B$4/2,F9*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P10)=0,IF(AND(N9<>\"\",O9<>\"\",P9<>\"\",R9<>\"\"),IF(R9<6,IF(P9>=50,IF(Q9=50,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5/2,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5),IF(Q9=50,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5*P9/100/2,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5*P9/100)),IF(Q9=50,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5/2,(O9-(SUM($O$5:O9)-ROUNDDOWN(SUM($O$5:O9),0)))*variables!$B$5)),\"\"),IF(AND(N9<>\"\",O9<>\"\",P9<>\"\",R9<>\"\"),IF(R9<6,IF(P9>=50,IF(Q9=50,O9*variables!$B$5/2,O9*variables!$B$5),IF(Q9=50,O9*variables!$B$5*P9/100/2,O9*variables!$B$5*P9/100)),IF(Q9=50,O9*variables!$B$5/2,O9*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G11)=0,IF(AND(F10<>\"\",G10<>\"\",I10<>\"\"),IF(I10<6,IF(G10>=50,IF(H10=50,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4/2,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4),IF(H10=50,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4*G10/100/2,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4*G10/100)),IF(H10=50,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4/2,(F10-(SUM($F$5:F10)-ROUNDDOWN(SUM($F$5:F10),0)))*variables!$B$4)),\"\"),IF(AND(F10<>\"\",G10<>\"\",I10<>\"\"),IF(I10<6,IF(G10>=50,IF(H10=50,F10*variables!$B$4/2,F10*variables!$B$4),IF(H10=50,F10*variables!$B$4*G10/100/2,F10*variables!$B$4*G10/100)),IF(H10=50,F10*variables!$B$4/2,F10*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P11)=0,IF(AND(N10<>\"\",O10<>\"\",P10<>\"\",R10<>\"\"),IF(R10<6,IF(P10>=50,IF(Q10=50,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5/2,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5),IF(Q10=50,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5*P10/100/2,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5*P10/100)),IF(Q10=50,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5/2,(O10-(SUM($O$5:O10)-ROUNDDOWN(SUM($O$5:O10),0)))*variables!$B$5)),\"\"),IF(AND(N10<>\"\",O10<>\"\",P10<>\"\",R10<>\"\"),IF(R10<6,IF(P10>=50,IF(Q10=50,O10*variables!$B$5/2,O10*variables!$B$5),IF(Q10=50,O10*variables!$B$5*P10/100/2,O10*variables!$B$5*P10/100)),IF(Q10=50,O10*variables!$B$5/2,O10*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G12)=0,IF(AND(F11<>\"\",G11<>\"\",I11<>\"\"),IF(I11<6,IF(G11>=50,IF(H11=50,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4/2,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4),IF(H11=50,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4*G11/100/2,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4*G11/100)),IF(H11=50,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4/2,(F11-(SUM($F$5:F11)-ROUNDDOWN(SUM($F$5:F11),0)))*variables!$B$4)),\"\"),IF(AND(F11<>\"\",G11<>\"\",I11<>\"\"),IF(I11<6,IF(G11>=50,IF(H11=50,F11*variables!$B$4/2,F11*variables!$B$4),IF(H11=50,F11*variables!$B$4*G11/100/2,F11*variables!$B$4*G11/100)),IF(H11=50,F11*variables!$B$4/2,F11*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P12)=0,IF(AND(N11<>\"\",O11<>\"\",P11<>\"\",R11<>\"\"),IF(R11<6,IF(P11>=50,IF(Q11=50,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5/2,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5),IF(Q11=50,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5*P11/100/2,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5*P11/100)),IF(Q11=50,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5/2,(O11-(SUM($O$5:O11)-ROUNDDOWN(SUM($O$5:O11),0)))*variables!$B$5)),\"\"),IF(AND(N11<>\"\",O11<>\"\",P11<>\"\",R11<>\"\"),IF(R11<6,IF(P11>=50,IF(Q11=50,O11*variables!$B$5/2,O11*variables!$B$5),IF(Q11=50,O11*variables!$B$5*P11/100/2,O11*variables!$B$5*P11/100)),IF(Q11=50,O11*variables!$B$5/2,O11*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G13)=0,IF(AND(F12<>\"\",G12<>\"\",I12<>\"\"),IF(I12<6,IF(G12>=50,IF(H12=50,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4/2,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4),IF(H12=50,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4*G12/100/2,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4*G12/100)),IF(H12=50,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4/2,(F12-(SUM($F$5:F12)-ROUNDDOWN(SUM($F$5:F12),0)))*variables!$B$4)),\"\"),IF(AND(F12<>\"\",G12<>\"\",I12<>\"\"),IF(I12<6,IF(G12>=50,IF(H12=50,F12*variables!$B$4/2,F12*variables!$B$4),IF(H12=50,F12*variables!$B$4*G12/100/2,F12*variables!$B$4*G12/100)),IF(H12=50,F12*variables!$B$4/2,F12*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P13)=0,IF(AND(N12<>\"\",O12<>\"\",P12<>\"\",R12<>\"\"),IF(R12<6,IF(P12>=50,IF(Q12=50,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5/2,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5),IF(Q12=50,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5*P12/100/2,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5*P12/100)),IF(Q12=50,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5/2,(O12-(SUM($O$5:O12)-ROUNDDOWN(SUM($O$5:O12),0)))*variables!$B$5)),\"\"),IF(AND(N12<>\"\",O12<>\"\",P12<>\"\",R12<>\"\"),IF(R12<6,IF(P12>=50,IF(Q12=50,O12*variables!$B$5/2,O12*variables!$B$5),IF(Q12=50,O12*variables!$B$5*P12/100/2,O12*variables!$B$5*P12/100)),IF(Q12=50,O12*variables!$B$5/2,O12*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G14)=0,IF(AND(F13<>\"\",G13<>\"\",I13<>\"\"),IF(I13<6,IF(G13>=50,IF(H13=50,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4/2,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4),IF(H13=50,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4*G13/100/2,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4*G13/100)),IF(H13=50,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4/2,(F13-(SUM($F$5:F13)-ROUNDDOWN(SUM($F$5:F13),0)))*variables!$B$4)),\"\"),IF(AND(F13<>\"\",G13<>\"\",I13<>\"\"),IF(I13<6,IF(G13>=50,IF(H13=50,F13*variables!$B$4/2,F13*variables!$B$4),IF(H13=50,F13*variables!$B$4*G13/100/2,F13*variables!$B$4*G13/100)),IF(H13=50,F13*variables!$B$4/2,F13*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P14)=0,IF(AND(N13<>\"\",O13<>\"\",P13<>\"\",R13<>\"\"),IF(R13<6,IF(P13>=50,IF(Q13=50,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5/2,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5),IF(Q13=50,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5*P13/100/2,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5*P13/100)),IF(Q13=50,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5/2,(O13-(SUM($O$5:O13)-ROUNDDOWN(SUM($O$5:O13),0)))*variables!$B$5)),\"\"),IF(AND(N13<>\"\",O13<>\"\",P13<>\"\",R13<>\"\"),IF(R13<6,IF(P13>=50,IF(Q13=50,O13*variables!$B$5/2,O13*variables!$B$5),IF(Q13=50,O13*variables!$B$5*P13/100/2,O13*variables!$B$5*P13/100)),IF(Q13=50,O13*variables!$B$5/2,O13*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G15)=0,IF(AND(F14<>\"\",G14<>\"\",I14<>\"\"),IF(I14<6,IF(G14>=50,IF(H14=50,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4/2,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4),IF(H14=50,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4*G14/100/2,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4*G14/100)),IF(H14=50,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4/2,(F14-(SUM($F$5:F14)-ROUNDDOWN(SUM($F$5:F14),0)))*variables!$B$4)),\"\"),IF(AND(F14<>\"\",G14<>\"\",I14<>\"\"),IF(I14<6,IF(G14>=50,IF(H14=50,F14*variables!$B$4/2,F14*variables!$B$4),IF(H14=50,F14*variables!$B$4*G14/100/2,F14*variables!$B$4*G14/100)),IF(H14=50,F14*variables!$B$4/2,F14*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P15)=0,IF(AND(N14<>\"\",O14<>\"\",P14<>\"\",R14<>\"\"),IF(R14<6,IF(P14>=50,IF(Q14=50,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5/2,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5),IF(Q14=50,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5*P14/100/2,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5*P14/100)),IF(Q14=50,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5/2,(O14-(SUM($O$5:O14)-ROUNDDOWN(SUM($O$5:O14),0)))*variables!$B$5)),\"\"),IF(AND(N14<>\"\",O14<>\"\",P14<>\"\",R14<>\"\"),IF(R14<6,IF(P14>=50,IF(Q14=50,O14*variables!$B$5/2,O14*variables!$B$5),IF(Q14=50,O14*variables!$B$5*P14/100/2,O14*variables!$B$5*P14/100)),IF(Q14=50,O14*variables!$B$5/2,O14*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G16)=0,IF(AND(F15<>\"\",G15<>\"\",I15<>\"\"),IF(I15<6,IF(G15>=50,IF(H15=50,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4/2,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4),IF(H15=50,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4*G15/100/2,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4*G15/100)),IF(H15=50,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4/2,(F15-(SUM($F$5:F15)-ROUNDDOWN(SUM($F$5:F15),0)))*variables!$B$4)),\"\"),IF(AND(F15<>\"\",G15<>\"\",I15<>\"\"),IF(I15<6,IF(G15>=50,IF(H15=50,F15*variables!$B$4/2,F15*variables!$B$4),IF(H15=50,F15*variables!$B$4*G15/100/2,F15*variables!$B$4*G15/100)),IF(H15=50,F15*variables!$B$4/2,F15*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P16)=0,IF(AND(N15<>\"\",O15<>\"\",P15<>\"\",R15<>\"\"),IF(R15<6,IF(P15>=50,IF(Q15=50,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5/2,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5),IF(Q15=50,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5*P15/100/2,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5*P15/100)),IF(Q15=50,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5/2,(O15-(SUM($O$5:O15)-ROUNDDOWN(SUM($O$5:O15),0)))*variables!$B$5)),\"\"),IF(AND(N15<>\"\",O15<>\"\",P15<>\"\",R15<>\"\"),IF(R15<6,IF(P15>=50,IF(Q15=50,O15*variables!$B$5/2,O15*variables!$B$5),IF(Q15=50,O15*variables!$B$5*P15/100/2,O15*variables!$B$5*P15/100)),IF(Q15=50,O15*variables!$B$5/2,O15*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G17)=0,IF(AND(F16<>\"\",G16<>\"\",I16<>\"\"),IF(I16<6,IF(G16>=50,IF(H16=50,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4/2,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4),IF(H16=50,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4*G16/100/2,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4*G16/100)),IF(H16=50,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4/2,(F16-(SUM($F$5:F16)-ROUNDDOWN(SUM($F$5:F16),0)))*variables!$B$4)),\"\"),IF(AND(F16<>\"\",G16<>\"\",I16<>\"\"),IF(I16<6,IF(G16>=50,IF(H16=50,F16*variables!$B$4/2,F16*variables!$B$4),IF(H16=50,F16*variables!$B$4*G16/100/2,F16*variables!$B$4*G16/100)),IF(H16=50,F16*variables!$B$4/2,F16*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P17)=0,IF(AND(N16<>\"\",O16<>\"\",P16<>\"\",R16<>\"\"),IF(R16<6,IF(P16>=50,IF(Q16=50,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5/2,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5),IF(Q16=50,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5*P16/100/2,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5*P16/100)),IF(Q16=50,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5/2,(O16-(SUM($O$5:O16)-ROUNDDOWN(SUM($O$5:O16),0)))*variables!$B$5)),\"\"),IF(AND(N16<>\"\",O16<>\"\",P16<>\"\",R16<>\"\"),IF(R16<6,IF(P16>=50,IF(Q16=50,O16*variables!$B$5/2,O16*variables!$B$5),IF(Q16=50,O16*variables!$B$5*P16/100/2,O16*variables!$B$5*P16/100)),IF(Q16=50,O16*variables!$B$5/2,O16*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G18)=0,IF(AND(F17<>\"\",G17<>\"\",I17<>\"\"),IF(I17<6,IF(G17>=50,IF(H17=50,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4/2,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4),IF(H17=50,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4*G17/100/2,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4*G17/100)),IF(H17=50,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4/2,(F17-(SUM($F$5:F17)-ROUNDDOWN(SUM($F$5:F17),0)))*variables!$B$4)),\"\"),IF(AND(F17<>\"\",G17<>\"\",I17<>\"\"),IF(I17<6,IF(G17>=50,IF(H17=50,F17*variables!$B$4/2,F17*variables!$B$4),IF(H17=50,F17*variables!$B$4*G17/100/2,F17*variables!$B$4*G17/100)),IF(H17=50,F17*variables!$B$4/2,F17*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P18)=0,IF(AND(N17<>\"\",O17<>\"\",P17<>\"\",R17<>\"\"),IF(R17<6,IF(P17>=50,IF(Q17=50,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5/2,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5),IF(Q17=50,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5*P17/100/2,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5*P17/100)),IF(Q17=50,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5/2,(O17-(SUM($O$5:O17)-ROUNDDOWN(SUM($O$5:O17),0)))*variables!$B$5)),\"\"),IF(AND(N17<>\"\",O17<>\"\",P17<>\"\",R17<>\"\"),IF(R17<6,IF(P17>=50,IF(Q17=50,O17*variables!$B$5/2,O17*variables!$B$5),IF(Q17=50,O17*variables!$B$5*P17/100/2,O17*variables!$B$5*P17/100)),IF(Q17=50,O17*variables!$B$5/2,O17*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G19)=0,IF(AND(F18<>\"\",G18<>\"\",I18<>\"\"),IF(I18<6,IF(G18>=50,IF(H18=50,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4/2,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4),IF(H18=50,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4*G18/100/2,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4*G18/100)),IF(H18=50,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4/2,(F18-(SUM($F$5:F18)-ROUNDDOWN(SUM($F$5:F18),0)))*variables!$B$4)),\"\"),IF(AND(F18<>\"\",G18<>\"\",I18<>\"\"),IF(I18<6,IF(G18>=50,IF(H18=50,F18*variables!$B$4/2,F18*variables!$B$4),IF(H18=50,F18*variables!$B$4*G18/100/2,F18*variables!$B$4*G18/100)),IF(H18=50,F18*variables!$B$4/2,F18*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P19)=0,IF(AND(N18<>\"\",O18<>\"\",P18<>\"\",R18<>\"\"),IF(R18<6,IF(P18>=50,IF(Q18=50,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5/2,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5),IF(Q18=50,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5*P18/100/2,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5*P18/100)),IF(Q18=50,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5/2,(O18-(SUM($O$5:O18)-ROUNDDOWN(SUM($O$5:O18),0)))*variables!$B$5)),\"\"),IF(AND(N18<>\"\",O18<>\"\",P18<>\"\",R18<>\"\"),IF(R18<6,IF(P18>=50,IF(Q18=50,O18*variables!$B$5/2,O18*variables!$B$5),IF(Q18=50,O18*variables!$B$5*P18/100/2,O18*variables!$B$5*P18/100)),IF(Q18=50,O18*variables!$B$5/2,O18*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G20)=0,IF(AND(F19<>\"\",G19<>\"\",I19<>\"\"),IF(I19<6,IF(G19>=50,IF(H19=50,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4/2,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4),IF(H19=50,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4*G19/100/2,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4*G19/100)),IF(H19=50,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4/2,(F19-(SUM($F$5:F19)-ROUNDDOWN(SUM($F$5:F19),0)))*variables!$B$4)),\"\"),IF(AND(F19<>\"\",G19<>\"\",I19<>\"\"),IF(I19<6,IF(G19>=50,IF(H19=50,F19*variables!$B$4/2,F19*variables!$B$4),IF(H19=50,F19*variables!$B$4*G19/100/2,F19*variables!$B$4*G19/100)),IF(H19=50,F19*variables!$B$4/2,F19*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P20)=0,IF(AND(N19<>\"\",O19<>\"\",P19<>\"\",R19<>\"\"),IF(R19<6,IF(P19>=50,IF(Q19=50,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5/2,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5),IF(Q19=50,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5*P19/100/2,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5*P19/100)),IF(Q19=50,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5/2,(O19-(SUM($O$5:O19)-ROUNDDOWN(SUM($O$5:O19),0)))*variables!$B$5)),\"\"),IF(AND(N19<>\"\",O19<>\"\",P19<>\"\",R19<>\"\"),IF(R19<6,IF(P19>=50,IF(Q19=50,O19*variables!$B$5/2,O19*variables!$B$5),IF(Q19=50,O19*variables!$B$5*P19/100/2,O19*variables!$B$5*P19/100)),IF(Q19=50,O19*variables!$B$5/2,O19*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G21)=0,IF(AND(F20<>\"\",G20<>\"\",I20<>\"\"),IF(I20<6,IF(G20>=50,IF(H20=50,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4/2,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4),IF(H20=50,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4*G20/100/2,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4*G20/100)),IF(H20=50,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4/2,(F20-(SUM($F$5:F20)-ROUNDDOWN(SUM($F$5:F20),0)))*variables!$B$4)),\"\"),IF(AND(F20<>\"\",G20<>\"\",I20<>\"\"),IF(I20<6,IF(G20>=50,IF(H20=50,F20*variables!$B$4/2,F20*variables!$B$4),IF(H20=50,F20*variables!$B$4*G20/100/2,F20*variables!$B$4*G20/100)),IF(H20=50,F20*variables!$B$4/2,F20*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P21)=0,IF(AND(N20<>\"\",O20<>\"\",P20<>\"\",R20<>\"\"),IF(R20<6,IF(P20>=50,IF(Q20=50,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5/2,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5),IF(Q20=50,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5*P20/100/2,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5*P20/100)),IF(Q20=50,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5/2,(O20-(SUM($O$5:O20)-ROUNDDOWN(SUM($O$5:O20),0)))*variables!$B$5)),\"\"),IF(AND(N20<>\"\",O20<>\"\",P20<>\"\",R20<>\"\"),IF(R20<6,IF(P20>=50,IF(Q20=50,O20*variables!$B$5/2,O20*variables!$B$5),IF(Q20=50,O20*variables!$B$5*P20/100/2,O20*variables!$B$5*P20/100)),IF(Q20=50,O20*variables!$B$5/2,O20*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G22)=0,IF(AND(F21<>\"\",G21<>\"\",I21<>\"\"),IF(I21<6,IF(G21>=50,IF(H21=50,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4/2,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4),IF(H21=50,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4*G21/100/2,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4*G21/100)),IF(H21=50,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4/2,(F21-(SUM($F$5:F21)-ROUNDDOWN(SUM($F$5:F21),0)))*variables!$B$4)),\"\"),IF(AND(F21<>\"\",G21<>\"\",I21<>\"\"),IF(I21<6,IF(G21>=50,IF(H21=50,F21*variables!$B$4/2,F21*variables!$B$4),IF(H21=50,F21*variables!$B$4*G21/100/2,F21*variables!$B$4*G21/100)),IF(H21=50,F21*variables!$B$4/2,F21*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P22)=0,IF(AND(N21<>\"\",O21<>\"\",P21<>\"\",R21<>\"\"),IF(R21<6,IF(P21>=50,IF(Q21=50,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5/2,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5),IF(Q21=50,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5*P21/100/2,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5*P21/100)),IF(Q21=50,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5/2,(O21-(SUM($O$5:O21)-ROUNDDOWN(SUM($O$5:O21),0)))*variables!$B$5)),\"\"),IF(AND(N21<>\"\",O21<>\"\",P21<>\"\",R21<>\"\"),IF(R21<6,IF(P21>=50,IF(Q21=50,O21*variables!$B$5/2,O21*variables!$B$5),IF(Q21=50,O21*variables!$B$5*P21/100/2,O21*variables!$B$5*P21/100)),IF(Q21=50,O21*variables!$B$5/2,O21*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G23)=0,IF(AND(F22<>\"\",G22<>\"\",I22<>\"\"),IF(I22<6,IF(G22>=50,IF(H22=50,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4/2,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4),IF(H22=50,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4*G22/100/2,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4*G22/100)),IF(H22=50,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4/2,(F22-(SUM($F$5:F22)-ROUNDDOWN(SUM($F$5:F22),0)))*variables!$B$4)),\"\"),IF(AND(F22<>\"\",G22<>\"\",I22<>\"\"),IF(I22<6,IF(G22>=50,IF(H22=50,F22*variables!$B$4/2,F22*variables!$B$4),IF(H22=50,F22*variables!$B$4*G22/100/2,F22*variables!$B$4*G22/100)),IF(H22=50,F22*variables!$B$4/2,F22*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P23)=0,IF(AND(N22<>\"\",O22<>\"\",P22<>\"\",R22<>\"\"),IF(R22<6,IF(P22>=50,IF(Q22=50,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5/2,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5),IF(Q22=50,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5*P22/100/2,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5*P22/100)),IF(Q22=50,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5/2,(O22-(SUM($O$5:O22)-ROUNDDOWN(SUM($O$5:O22),0)))*variables!$B$5)),\"\"),IF(AND(N22<>\"\",O22<>\"\",P22<>\"\",R22<>\"\"),IF(R22<6,IF(P22>=50,IF(Q22=50,O22*variables!$B$5/2,O22*variables!$B$5),IF(Q22=50,O22*variables!$B$5*P22/100/2,O22*variables!$B$5*P22/100)),IF(Q22=50,O22*variables!$B$5/2,O22*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G24)=0,IF(AND(F23<>\"\",G23<>\"\",I23<>\"\"),IF(I23<6,IF(G23>=50,IF(H23=50,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4/2,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4),IF(H23=50,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4*G23/100/2,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4*G23/100)),IF(H23=50,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4/2,(F23-(SUM($F$5:F23)-ROUNDDOWN(SUM($F$5:F23),0)))*variables!$B$4)),\"\"),IF(AND(F23<>\"\",G23<>\"\",I23<>\"\"),IF(I23<6,IF(G23>=50,IF(H23=50,F23*variables!$B$4/2,F23*variables!$B$4),IF(H23=50,F23*variables!$B$4*G23/100/2,F23*variables!$B$4*G23/100)),IF(H23=50,F23*variables!$B$4/2,F23*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P24)=0,IF(AND(N23<>\"\",O23<>\"\",P23<>\"\",R23<>\"\"),IF(R23<6,IF(P23>=50,IF(Q23=50,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5/2,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5),IF(Q23=50,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5*P23/100/2,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5*P23/100)),IF(Q23=50,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5/2,(O23-(SUM($O$5:O23)-ROUNDDOWN(SUM($O$5:O23),0)))*variables!$B$5)),\"\"),IF(AND(N23<>\"\",O23<>\"\",P23<>\"\",R23<>\"\"),IF(R23<6,IF(P23>=50,IF(Q23=50,O23*variables!$B$5/2,O23*variables!$B$5),IF(Q23=50,O23*variables!$B$5*P23/100/2,O23*variables!$B$5*P23/100)),IF(Q23=50,O23*variables!$B$5/2,O23*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G25)=0,IF(AND(F24<>\"\",G24<>\"\",I24<>\"\"),IF(I24<6,IF(G24>=50,IF(H24=50,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4/2,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4),IF(H24=50,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4*G24/100/2,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4*G24/100)),IF(H24=50,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4/2,(F24-(SUM($F$5:F24)-ROUNDDOWN(SUM($F$5:F24),0)))*variables!$B$4)),\"\"),IF(AND(F24<>\"\",G24<>\"\",I24<>\"\"),IF(I24<6,IF(G24>=50,IF(H24=50,F24*variables!$B$4/2,F24*variables!$B$4),IF(H24=50,F24*variables!$B$4*G24/100/2,F24*variables!$B$4*G24/100)),IF(H24=50,F24*variables!$B$4/2,F24*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P25)=0,IF(AND(N24<>\"\",O24<>\"\",P24<>\"\",R24<>\"\"),IF(R24<6,IF(P24>=50,IF(Q24=50,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5/2,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5),IF(Q24=50,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5*P24/100/2,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5*P24/100)),IF(Q24=50,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5/2,(O24-(SUM($O$5:O24)-ROUNDDOWN(SUM($O$5:O24),0)))*variables!$B$5)),\"\"),IF(AND(N24<>\"\",O24<>\"\",P24<>\"\",R24<>\"\"),IF(R24<6,IF(P24>=50,IF(Q24=50,O24*variables!$B$5/2,O24*variables!$B$5),IF(Q24=50,O24*variables!$B$5*P24/100/2,O24*variables!$B$5*P24/100)),IF(Q24=50,O24*variables!$B$5/2,O24*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G26)=0,IF(AND(F25<>\"\",G25<>\"\",I25<>\"\"),IF(I25<6,IF(G25>=50,IF(H25=50,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4/2,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4),IF(H25=50,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4*G25/100/2,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4*G25/100)),IF(H25=50,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4/2,(F25-(SUM($F$5:F25)-ROUNDDOWN(SUM($F$5:F25),0)))*variables!$B$4)),\"\"),IF(AND(F25<>\"\",G25<>\"\",I25<>\"\"),IF(I25<6,IF(G25>=50,IF(H25=50,F25*variables!$B$4/2,F25*variables!$B$4),IF(H25=50,F25*variables!$B$4*G25/100/2,F25*variables!$B$4*G25/100)),IF(H25=50,F25*variables!$B$4/2,F25*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P26)=0,IF(AND(N25<>\"\",O25<>\"\",P25<>\"\",R25<>\"\"),IF(R25<6,IF(P25>=50,IF(Q25=50,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5/2,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5),IF(Q25=50,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5*P25/100/2,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5*P25/100)),IF(Q25=50,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5/2,(O25-(SUM($O$5:O25)-ROUNDDOWN(SUM($O$5:O25),0)))*variables!$B$5)),\"\"),IF(AND(N25<>\"\",O25<>\"\",P25<>\"\",R25<>\"\"),IF(R25<6,IF(P25>=50,IF(Q25=50,O25*variables!$B$5/2,O25*variables!$B$5),IF(Q25=50,O25*variables!$B$5*P25/100/2,O25*variables!$B$5*P25/100)),IF(Q25=50,O25*variables!$B$5/2,O25*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G27)=0,IF(AND(F26<>\"\",G26<>\"\",I26<>\"\"),IF(I26<6,IF(G26>=50,IF(H26=50,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4/2,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4),IF(H26=50,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4*G26/100/2,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4*G26/100)),IF(H26=50,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4/2,(F26-(SUM($F$5:F26)-ROUNDDOWN(SUM($F$5:F26),0)))*variables!$B$4)),\"\"),IF(AND(F26<>\"\",G26<>\"\",I26<>\"\"),IF(I26<6,IF(G26>=50,IF(H26=50,F26*variables!$B$4/2,F26*variables!$B$4),IF(H26=50,F26*variables!$B$4*G26/100/2,F26*variables!$B$4*G26/100)),IF(H26=50,F26*variables!$B$4/2,F26*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P27)=0,IF(AND(N26<>\"\",O26<>\"\",P26<>\"\",R26<>\"\"),IF(R26<6,IF(P26>=50,IF(Q26=50,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5/2,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5),IF(Q26=50,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5*P26/100/2,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5*P26/100)),IF(Q26=50,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5/2,(O26-(SUM($O$5:O26)-ROUNDDOWN(SUM($O$5:O26),0)))*variables!$B$5)),\"\"),IF(AND(N26<>\"\",O26<>\"\",P26<>\"\",R26<>\"\"),IF(R26<6,IF(P26>=50,IF(Q26=50,O26*variables!$B$5/2,O26*variables!$B$5),IF(Q26=50,O26*variables!$B$5*P26/100/2,O26*variables!$B$5*P26/100)),IF(Q26=50,O26*variables!$B$5/2,O26*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G28)=0,IF(AND(F27<>\"\",G27<>\"\",I27<>\"\"),IF(I27<6,IF(G27>=50,IF(H27=50,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4/2,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4),IF(H27=50,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4*G27/100/2,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4*G27/100)),IF(H27=50,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4/2,(F27-(SUM($F$5:F27)-ROUNDDOWN(SUM($F$5:F27),0)))*variables!$B$4)),\"\"),IF(AND(F27<>\"\",G27<>\"\",I27<>\"\"),IF(I27<6,IF(G27>=50,IF(H27=50,F27*variables!$B$4/2,F27*variables!$B$4),IF(H27=50,F27*variables!$B$4*G27/100/2,F27*variables!$B$4*G27/100)),IF(H27=50,F27*variables!$B$4/2,F27*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P28)=0,IF(AND(N27<>\"\",O27<>\"\",P27<>\"\",R27<>\"\"),IF(R27<6,IF(P27>=50,IF(Q27=50,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5/2,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5),IF(Q27=50,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5*P27/100/2,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5*P27/100)),IF(Q27=50,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5/2,(O27-(SUM($O$5:O27)-ROUNDDOWN(SUM($O$5:O27),0)))*variables!$B$5)),\"\"),IF(AND(N27<>\"\",O27<>\"\",P27<>\"\",R27<>\"\"),IF(R27<6,IF(P27>=50,IF(Q27=50,O27*variables!$B$5/2,O27*variables!$B$5),IF(Q27=50,O27*variables!$B$5*P27/100/2,O27*variables!$B$5*P27/100)),IF(Q27=50,O27*variables!$B$5/2,O27*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G29)=0,IF(AND(F28<>\"\",G28<>\"\",I28<>\"\"),IF(I28<6,IF(G28>=50,IF(H28=50,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4/2,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4),IF(H28=50,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4*G28/100/2,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4*G28/100)),IF(H28=50,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4/2,(F28-(SUM($F$5:F28)-ROUNDDOWN(SUM($F$5:F28),0)))*variables!$B$4)),\"\"),IF(AND(F28<>\"\",G28<>\"\",I28<>\"\"),IF(I28<6,IF(G28>=50,IF(H28=50,F28*variables!$B$4/2,F28*variables!$B$4),IF(H28=50,F28*variables!$B$4*G28/100/2,F28*variables!$B$4*G28/100)),IF(H28=50,F28*variables!$B$4/2,F28*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P29)=0,IF(AND(N28<>\"\",O28<>\"\",P28<>\"\",R28<>\"\"),IF(R28<6,IF(P28>=50,IF(Q28=50,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5/2,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5),IF(Q28=50,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5*P28/100/2,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5*P28/100)),IF(Q28=50,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5/2,(O28-(SUM($O$5:O28)-ROUNDDOWN(SUM($O$5:O28),0)))*variables!$B$5)),\"\"),IF(AND(N28<>\"\",O28<>\"\",P28<>\"\",R28<>\"\"),IF(R28<6,IF(P28>=50,IF(Q28=50,O28*variables!$B$5/2,O28*variables!$B$5),IF(Q28=50,O28*variables!$B$5*P28/100/2,O28*variables!$B$5*P28/100)),IF(Q28=50,O28*variables!$B$5/2,O28*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G30)=0,IF(AND(F29<>\"\",G29<>\"\",I29<>\"\"),IF(I29<6,IF(G29>=50,IF(H29=50,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4/2,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4),IF(H29=50,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4*G29/100/2,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4*G29/100)),IF(H29=50,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4/2,(F29-(SUM($F$5:F29)-ROUNDDOWN(SUM($F$5:F29),0)))*variables!$B$4)),\"\"),IF(AND(F29<>\"\",G29<>\"\",I29<>\"\"),IF(I29<6,IF(G29>=50,IF(H29=50,F29*variables!$B$4/2,F29*variables!$B$4),IF(H29=50,F29*variables!$B$4*G29/100/2,F29*variables!$B$4*G29/100)),IF(H29=50,F29*variables!$B$4/2,F29*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P30)=0,IF(AND(N29<>\"\",O29<>\"\",P29<>\"\",R29<>\"\"),IF(R29<6,IF(P29>=50,IF(Q29=50,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5/2,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5),IF(Q29=50,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5*P29/100/2,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5*P29/100)),IF(Q29=50,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5/2,(O29-(SUM($O$5:O29)-ROUNDDOWN(SUM($O$5:O29),0)))*variables!$B$5)),\"\"),IF(AND(N29<>\"\",O29<>\"\",P29<>\"\",R29<>\"\"),IF(R29<6,IF(P29>=50,IF(Q29=50,O29*variables!$B$5/2,O29*variables!$B$5),IF(Q29=50,O29*variables!$B$5*P29/100/2,O29*variables!$B$5*P29/100)),IF(Q29=50,O29*variables!$B$5/2,O29*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G31)=0,IF(AND(F30<>\"\",G30<>\"\",I30<>\"\"),IF(I30<6,IF(G30>=50,IF(H30=50,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4/2,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4),IF(H30=50,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4*G30/100/2,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4*G30/100)),IF(H30=50,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4/2,(F30-(SUM($F$5:F30)-ROUNDDOWN(SUM($F$5:F30),0)))*variables!$B$4)),\"\"),IF(AND(F30<>\"\",G30<>\"\",I30<>\"\"),IF(I30<6,IF(G30>=50,IF(H30=50,F30*variables!$B$4/2,F30*variables!$B$4),IF(H30=50,F30*variables!$B$4*G30/100/2,F30*variables!$B$4*G30/100)),IF(H30=50,F30*variables!$B$4/2,F30*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P31)=0,IF(AND(N30<>\"\",O30<>\"\",P30<>\"\",R30<>\"\"),IF(R30<6,IF(P30>=50,IF(Q30=50,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5/2,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5),IF(Q30=50,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5*P30/100/2,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5*P30/100)),IF(Q30=50,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5/2,(O30-(SUM($O$5:O30)-ROUNDDOWN(SUM($O$5:O30),0)))*variables!$B$5)),\"\"),IF(AND(N30<>\"\",O30<>\"\",P30<>\"\",R30<>\"\"),IF(R30<6,IF(P30>=50,IF(Q30=50,O30*variables!$B$5/2,O30*variables!$B$5),IF(Q30=50,O30*variables!$B$5*P30/100/2,O30*variables!$B$5*P30/100)),IF(Q30=50,O30*variables!$B$5/2,O30*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G32)=0,IF(AND(F31<>\"\",G31<>\"\",I31<>\"\"),IF(I31<6,IF(G31>=50,IF(H31=50,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4/2,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4),IF(H31=50,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4*G31/100/2,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4*G31/100)),IF(H31=50,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4/2,(F31-(SUM($F$5:F31)-ROUNDDOWN(SUM($F$5:F31),0)))*variables!$B$4)),\"\"),IF(AND(F31<>\"\",G31<>\"\",I31<>\"\"),IF(I31<6,IF(G31>=50,IF(H31=50,F31*variables!$B$4/2,F31*variables!$B$4),IF(H31=50,F31*variables!$B$4*G31/100/2,F31*variables!$B$4*G31/100)),IF(H31=50,F31*variables!$B$4/2,F31*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P32)=0,IF(AND(N31<>\"\",O31<>\"\",P31<>\"\",R31<>\"\"),IF(R31<6,IF(P31>=50,IF(Q31=50,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5/2,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5),IF(Q31=50,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5*P31/100/2,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5*P31/100)),IF(Q31=50,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5/2,(O31-(SUM($O$5:O31)-ROUNDDOWN(SUM($O$5:O31),0)))*variables!$B$5)),\"\"),IF(AND(N31<>\"\",O31<>\"\",P31<>\"\",R31<>\"\"),IF(R31<6,IF(P31>=50,IF(Q31=50,O31*variables!$B$5/2,O31*variables!$B$5),IF(Q31=50,O31*variables!$B$5*P31/100/2,O31*variables!$B$5*P31/100)),IF(Q31=50,O31*variables!$B$5/2,O31*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G33)=0,IF(AND(F32<>\"\",G32<>\"\",I32<>\"\"),IF(I32<6,IF(G32>=50,IF(H32=50,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4/2,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4),IF(H32=50,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4*G32/100/2,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4*G32/100)),IF(H32=50,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4/2,(F32-(SUM($F$5:F32)-ROUNDDOWN(SUM($F$5:F32),0)))*variables!$B$4)),\"\"),IF(AND(F32<>\"\",G32<>\"\",I32<>\"\"),IF(I32<6,IF(G32>=50,IF(H32=50,F32*variables!$B$4/2,F32*variables!$B$4),IF(H32=50,F32*variables!$B$4*G32/100/2,F32*variables!$B$4*G32/100)),IF(H32=50,F32*variables!$B$4/2,F32*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P33)=0,IF(AND(N32<>\"\",O32<>\"\",P32<>\"\",R32<>\"\"),IF(R32<6,IF(P32>=50,IF(Q32=50,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5/2,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5),IF(Q32=50,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5*P32/100/2,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5*P32/100)),IF(Q32=50,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5/2,(O32-(SUM($O$5:O32)-ROUNDDOWN(SUM($O$5:O32),0)))*variables!$B$5)),\"\"),IF(AND(N32<>\"\",O32<>\"\",P32<>\"\",R32<>\"\"),IF(R32<6,IF(P32>=50,IF(Q32=50,O32*variables!$B$5/2,O32*variables!$B$5),IF(Q32=50,O32*variables!$B$5*P32/100/2,O32*variables!$B$5*P32/100)),IF(Q32=50,O32*variables!$B$5/2,O32*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G34)=0,IF(AND(F33<>\"\",G33<>\"\",I33<>\"\"),IF(I33<6,IF(G33>=50,IF(H33=50,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4/2,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4),IF(H33=50,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4*G33/100/2,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4*G33/100)),IF(H33=50,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4/2,(F33-(SUM($F$5:F33)-ROUNDDOWN(SUM($F$5:F33),0)))*variables!$B$4)),\"\"),IF(AND(F33<>\"\",G33<>\"\",I33<>\"\"),IF(I33<6,IF(G33>=50,IF(H33=50,F33*variables!$B$4/2,F33*variables!$B$4),IF(H33=50,F33*variables!$B$4*G33/100/2,F33*variables!$B$4*G33/100)),IF(H33=50,F33*variables!$B$4/2,F33*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P34)=0,IF(AND(N33<>\"\",O33<>\"\",P33<>\"\",R33<>\"\"),IF(R33<6,IF(P33>=50,IF(Q33=50,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5/2,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5),IF(Q33=50,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5*P33/100/2,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5*P33/100)),IF(Q33=50,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5/2,(O33-(SUM($O$5:O33)-ROUNDDOWN(SUM($O$5:O33),0)))*variables!$B$5)),\"\"),IF(AND(N33<>\"\",O33<>\"\",P33<>\"\",R33<>\"\"),IF(R33<6,IF(P33>=50,IF(Q33=50,O33*variables!$B$5/2,O33*variables!$B$5),IF(Q33=50,O33*variables!$B$5*P33/100/2,O33*variables!$B$5*P33/100)),IF(Q33=50,O33*variables!$B$5/2,O33*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G35)=0,IF(AND(F34<>\"\",G34<>\"\",I34<>\"\"),IF(I34<6,IF(G34>=50,IF(H34=50,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4/2,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4),IF(H34=50,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4*G34/100/2,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4*G34/100)),IF(H34=50,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4/2,(F34-(SUM($F$5:F34)-ROUNDDOWN(SUM($F$5:F34),0)))*variables!$B$4)),\"\"),IF(AND(F34<>\"\",G34<>\"\",I34<>\"\"),IF(I34<6,IF(G34>=50,IF(H34=50,F34*variables!$B$4/2,F34*variables!$B$4),IF(H34=50,F34*variables!$B$4*G34/100/2,F34*variables!$B$4*G34/100)),IF(H34=50,F34*variables!$B$4/2,F34*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P35)=0,IF(AND(N34<>\"\",O34<>\"\",P34<>\"\",R34<>\"\"),IF(R34<6,IF(P34>=50,IF(Q34=50,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5/2,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5),IF(Q34=50,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5*P34/100/2,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5*P34/100)),IF(Q34=50,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5/2,(O34-(SUM($O$5:O34)-ROUNDDOWN(SUM($O$5:O34),0)))*variables!$B$5)),\"\"),IF(AND(N34<>\"\",O34<>\"\",P34<>\"\",R34<>\"\"),IF(R34<6,IF(P34>=50,IF(Q34=50,O34*variables!$B$5/2,O34*variables!$B$5),IF(Q34=50,O34*variables!$B$5*P34/100/2,O34*variables!$B$5*P34/100)),IF(Q34=50,O34*variables!$B$5/2,O34*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G36)=0,IF(AND(F35<>\"\",G35<>\"\",I35<>\"\"),IF(I35<6,IF(G35>=50,IF(H35=50,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4/2,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4),IF(H35=50,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4*G35/100/2,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4*G35/100)),IF(H35=50,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4/2,(F35-(SUM($F$5:F35)-ROUNDDOWN(SUM($F$5:F35),0)))*variables!$B$4)),\"\"),IF(AND(F35<>\"\",G35<>\"\",I35<>\"\"),IF(I35<6,IF(G35>=50,IF(H35=50,F35*variables!$B$4/2,F35*variables!$B$4),IF(H35=50,F35*variables!$B$4*G35/100/2,F35*variables!$B$4*G35/100)),IF(H35=50,F35*variables!$B$4/2,F35*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P36)=0,IF(AND(N35<>\"\",O35<>\"\",P35<>\"\",R35<>\"\"),IF(R35<6,IF(P35>=50,IF(Q35=50,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5/2,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5),IF(Q35=50,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5*P35/100/2,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5*P35/100)),IF(Q35=50,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5/2,(O35-(SUM($O$5:O35)-ROUNDDOWN(SUM($O$5:O35),0)))*variables!$B$5)),\"\"),IF(AND(N35<>\"\",O35<>\"\",P35<>\"\",R35<>\"\"),IF(R35<6,IF(P35>=50,IF(Q35=50,O35*variables!$B$5/2,O35*variables!$B$5),IF(Q35=50,O35*variables!$B$5*P35/100/2,O35*variables!$B$5*P35/100)),IF(Q35=50,O35*variables!$B$5/2,O35*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G37)=0,IF(AND(F36<>\"\",G36<>\"\",I36<>\"\"),IF(I36<6,IF(G36>=50,IF(H36=50,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4/2,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4),IF(H36=50,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4*G36/100/2,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4*G36/100)),IF(H36=50,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4/2,(F36-(SUM($F$5:F36)-ROUNDDOWN(SUM($F$5:F36),0)))*variables!$B$4)),\"\"),IF(AND(F36<>\"\",G36<>\"\",I36<>\"\"),IF(I36<6,IF(G36>=50,IF(H36=50,F36*variables!$B$4/2,F36*variables!$B$4),IF(H36=50,F36*variables!$B$4*G36/100/2,F36*variables!$B$4*G36/100)),IF(H36=50,F36*variables!$B$4/2,F36*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P37)=0,IF(AND(N36<>\"\",O36<>\"\",P36<>\"\",R36<>\"\"),IF(R36<6,IF(P36>=50,IF(Q36=50,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5/2,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5),IF(Q36=50,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5*P36/100/2,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5*P36/100)),IF(Q36=50,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5/2,(O36-(SUM($O$5:O36)-ROUNDDOWN(SUM($O$5:O36),0)))*variables!$B$5)),\"\"),IF(AND(N36<>\"\",O36<>\"\",P36<>\"\",R36<>\"\"),IF(R36<6,IF(P36>=50,IF(Q36=50,O36*variables!$B$5/2,O36*variables!$B$5),IF(Q36=50,O36*variables!$B$5*P36/100/2,O36*variables!$B$5*P36/100)),IF(Q36=50,O36*variables!$B$5/2,O36*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G38)=0,IF(AND(F37<>\"\",G37<>\"\",I37<>\"\"),IF(I37<6,IF(G37>=50,IF(H37=50,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4/2,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4),IF(H37=50,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4*G37/100/2,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4*G37/100)),IF(H37=50,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4/2,(F37-(SUM($F$5:F37)-ROUNDDOWN(SUM($F$5:F37),0)))*variables!$B$4)),\"\"),IF(AND(F37<>\"\",G37<>\"\",I37<>\"\"),IF(I37<6,IF(G37>=50,IF(H37=50,F37*variables!$B$4/2,F37*variables!$B$4),IF(H37=50,F37*variables!$B$4*G37/100/2,F37*variables!$B$4*G37/100)),IF(H37=50,F37*variables!$B$4/2,F37*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P38)=0,IF(AND(N37<>\"\",O37<>\"\",P37<>\"\",R37<>\"\"),IF(R37<6,IF(P37>=50,IF(Q37=50,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5/2,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5),IF(Q37=50,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5*P37/100/2,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5*P37/100)),IF(Q37=50,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5/2,(O37-(SUM($O$5:O37)-ROUNDDOWN(SUM($O$5:O37),0)))*variables!$B$5)),\"\"),IF(AND(N37<>\"\",O37<>\"\",P37<>\"\",R37<>\"\"),IF(R37<6,IF(P37>=50,IF(Q37=50,O37*variables!$B$5/2,O37*variables!$B$5),IF(Q37=50,O37*variables!$B$5*P37/100/2,O37*variables!$B$5*P37/100)),IF(Q37=50,O37*variables!$B$5/2,O37*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G39)=0,IF(AND(F38<>\"\",G38<>\"\",I38<>\"\"),IF(I38<6,IF(G38>=50,IF(H38=50,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4/2,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4),IF(H38=50,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4*G38/100/2,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4*G38/100)),IF(H38=50,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4/2,(F38-(SUM($F$5:F38)-ROUNDDOWN(SUM($F$5:F38),0)))*variables!$B$4)),\"\"),IF(AND(F38<>\"\",G38<>\"\",I38<>\"\"),IF(I38<6,IF(G38>=50,IF(H38=50,F38*variables!$B$4/2,F38*variables!$B$4),IF(H38=50,F38*variables!$B$4*G38/100/2,F38*variables!$B$4*G38/100)),IF(H38=50,F38*variables!$B$4/2,F38*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P39)=0,IF(AND(N38<>\"\",O38<>\"\",P38<>\"\",R38<>\"\"),IF(R38<6,IF(P38>=50,IF(Q38=50,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5/2,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5),IF(Q38=50,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5*P38/100/2,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5*P38/100)),IF(Q38=50,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5/2,(O38-(SUM($O$5:O38)-ROUNDDOWN(SUM($O$5:O38),0)))*variables!$B$5)),\"\"),IF(AND(N38<>\"\",O38<>\"\",P38<>\"\",R38<>\"\"),IF(R38<6,IF(P38>=50,IF(Q38=50,O38*variables!$B$5/2,O38*variables!$B$5),IF(Q38=50,O38*variables!$B$5*P38/100/2,O38*variables!$B$5*P38/100)),IF(Q38=50,O38*variables!$B$5/2,O38*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G40)=0,IF(AND(F39<>\"\",G39<>\"\",I39<>\"\"),IF(I39<6,IF(G39>=50,IF(H39=50,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4/2,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4),IF(H39=50,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4*G39/100/2,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4*G39/100)),IF(H39=50,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4/2,(F39-(SUM($F$5:F39)-ROUNDDOWN(SUM($F$5:F39),0)))*variables!$B$4)),\"\"),IF(AND(F39<>\"\",G39<>\"\",I39<>\"\"),IF(I39<6,IF(G39>=50,IF(H39=50,F39*variables!$B$4/2,F39*variables!$B$4),IF(H39=50,F39*variables!$B$4*G39/100/2,F39*variables!$B$4*G39/100)),IF(H39=50,F39*variables!$B$4/2,F39*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P40)=0,IF(AND(N39<>\"\",O39<>\"\",P39<>\"\",R39<>\"\"),IF(R39<6,IF(P39>=50,IF(Q39=50,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5/2,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5),IF(Q39=50,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5*P39/100/2,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5*P39/100)),IF(Q39=50,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5/2,(O39-(SUM($O$5:O39)-ROUNDDOWN(SUM($O$5:O39),0)))*variables!$B$5)),\"\"),IF(AND(N39<>\"\",O39<>\"\",P39<>\"\",R39<>\"\"),IF(R39<6,IF(P39>=50,IF(Q39=50,O39*variables!$B$5/2,O39*variables!$B$5),IF(Q39=50,O39*variables!$B$5*P39/100/2,O39*variables!$B$5*P39/100)),IF(Q39=50,O39*variables!$B$5/2,O39*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G41)=0,IF(AND(F40<>\"\",G40<>\"\",I40<>\"\"),IF(I40<6,IF(G40>=50,IF(H40=50,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4/2,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4),IF(H40=50,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4*G40/100/2,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4*G40/100)),IF(H40=50,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4/2,(F40-(SUM($F$5:F40)-ROUNDDOWN(SUM($F$5:F40),0)))*variables!$B$4)),\"\"),IF(AND(F40<>\"\",G40<>\"\",I40<>\"\"),IF(I40<6,IF(G40>=50,IF(H40=50,F40*variables!$B$4/2,F40*variables!$B$4),IF(H40=50,F40*variables!$B$4*G40/100/2,F40*variables!$B$4*G40/100)),IF(H40=50,F40*variables!$B$4/2,F40*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P41)=0,IF(AND(N40<>\"\",O40<>\"\",P40<>\"\",R40<>\"\"),IF(R40<6,IF(P40>=50,IF(Q40=50,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5/2,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5),IF(Q40=50,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5*P40/100/2,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5*P40/100)),IF(Q40=50,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5/2,(O40-(SUM($O$5:O40)-ROUNDDOWN(SUM($O$5:O40),0)))*variables!$B$5)),\"\"),IF(AND(N40<>\"\",O40<>\"\",P40<>\"\",R40<>\"\"),IF(R40<6,IF(P40>=50,IF(Q40=50,O40*variables!$B$5/2,O40*variables!$B$5),IF(Q40=50,O40*variables!$B$5*P40/100/2,O40*variables!$B$5*P40/100)),IF(Q40=50,O40*variables!$B$5/2,O40*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G42)=0,IF(AND(F41<>\"\",G41<>\"\",I41<>\"\"),IF(I41<6,IF(G41>=50,IF(H41=50,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4/2,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4),IF(H41=50,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4*G41/100/2,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4*G41/100)),IF(H41=50,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4/2,(F41-(SUM($F$5:F41)-ROUNDDOWN(SUM($F$5:F41),0)))*variables!$B$4)),\"\"),IF(AND(F41<>\"\",G41<>\"\",I41<>\"\"),IF(I41<6,IF(G41>=50,IF(H41=50,F41*variables!$B$4/2,F41*variables!$B$4),IF(H41=50,F41*variables!$B$4*G41/100/2,F41*variables!$B$4*G41/100)),IF(H41=50,F41*variables!$B$4/2,F41*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P42)=0,IF(AND(N41<>\"\",O41<>\"\",P41<>\"\",R41<>\"\"),IF(R41<6,IF(P41>=50,IF(Q41=50,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5/2,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5),IF(Q41=50,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5*P41/100/2,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5*P41/100)),IF(Q41=50,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5/2,(O41-(SUM($O$5:O41)-ROUNDDOWN(SUM($O$5:O41),0)))*variables!$B$5)),\"\"),IF(AND(N41<>\"\",O41<>\"\",P41<>\"\",R41<>\"\"),IF(R41<6,IF(P41>=50,IF(Q41=50,O41*variables!$B$5/2,O41*variables!$B$5),IF(Q41=50,O41*variables!$B$5*P41/100/2,O41*variables!$B$5*P41/100)),IF(Q41=50,O41*variables!$B$5/2,O41*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G43)=0,IF(AND(F42<>\"\",G42<>\"\",I42<>\"\"),IF(I42<6,IF(G42>=50,IF(H42=50,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4/2,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4),IF(H42=50,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4*G42/100/2,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4*G42/100)),IF(H42=50,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4/2,(F42-(SUM($F$5:F42)-ROUNDDOWN(SUM($F$5:F42),0)))*variables!$B$4)),\"\"),IF(AND(F42<>\"\",G42<>\"\",I42<>\"\"),IF(I42<6,IF(G42>=50,IF(H42=50,F42*variables!$B$4/2,F42*variables!$B$4),IF(H42=50,F42*variables!$B$4*G42/100/2,F42*variables!$B$4*G42/100)),IF(H42=50,F42*variables!$B$4/2,F42*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P43)=0,IF(AND(N42<>\"\",O42<>\"\",P42<>\"\",R42<>\"\"),IF(R42<6,IF(P42>=50,IF(Q42=50,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5/2,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5),IF(Q42=50,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5*P42/100/2,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5*P42/100)),IF(Q42=50,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5/2,(O42-(SUM($O$5:O42)-ROUNDDOWN(SUM($O$5:O42),0)))*variables!$B$5)),\"\"),IF(AND(N42<>\"\",O42<>\"\",P42<>\"\",R42<>\"\"),IF(R42<6,IF(P42>=50,IF(Q42=50,O42*variables!$B$5/2,O42*variables!$B$5),IF(Q42=50,O42*variables!$B$5*P42/100/2,O42*variables!$B$5*P42/100)),IF(Q42=50,O42*variables!$B$5/2,O42*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G44)=0,IF(AND(F43<>\"\",G43<>\"\",I43<>\"\"),IF(I43<6,IF(G43>=50,IF(H43=50,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4/2,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4),IF(H43=50,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4*G43/100/2,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4*G43/100)),IF(H43=50,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4/2,(F43-(SUM($F$5:F43)-ROUNDDOWN(SUM($F$5:F43),0)))*variables!$B$4)),\"\"),IF(AND(F43<>\"\",G43<>\"\",I43<>\"\"),IF(I43<6,IF(G43>=50,IF(H43=50,F43*variables!$B$4/2,F43*variables!$B$4),IF(H43=50,F43*variables!$B$4*G43/100/2,F43*variables!$B$4*G43/100)),IF(H43=50,F43*variables!$B$4/2,F43*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P44)=0,IF(AND(N43<>\"\",O43<>\"\",P43<>\"\",R43<>\"\"),IF(R43<6,IF(P43>=50,IF(Q43=50,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5/2,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5),IF(Q43=50,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5*P43/100/2,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5*P43/100)),IF(Q43=50,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5/2,(O43-(SUM($O$5:O43)-ROUNDDOWN(SUM($O$5:O43),0)))*variables!$B$5)),\"\"),IF(AND(N43<>\"\",O43<>\"\",P43<>\"\",R43<>\"\"),IF(R43<6,IF(P43>=50,IF(Q43=50,O43*variables!$B$5/2,O43*variables!$B$5),IF(Q43=50,O43*variables!$B$5*P43/100/2,O43*variables!$B$5*P43/100)),IF(Q43=50,O43*variables!$B$5/2,O43*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G45)=0,IF(AND(F44<>\"\",G44<>\"\",I44<>\"\"),IF(I44<6,IF(G44>=50,IF(H44=50,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4/2,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4),IF(H44=50,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4*G44/100/2,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4*G44/100)),IF(H44=50,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4/2,(F44-(SUM($F$5:F44)-ROUNDDOWN(SUM($F$5:F44),0)))*variables!$B$4)),\"\"),IF(AND(F44<>\"\",G44<>\"\",I44<>\"\"),IF(I44<6,IF(G44>=50,IF(H44=50,F44*variables!$B$4/2,F44*variables!$B$4),IF(H44=50,F44*variables!$B$4*G44/100/2,F44*variables!$B$4*G44/100)),IF(H44=50,F44*variables!$B$4/2,F44*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P45)=0,IF(AND(N44<>\"\",O44<>\"\",P44<>\"\",R44<>\"\"),IF(R44<6,IF(P44>=50,IF(Q44=50,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5/2,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5),IF(Q44=50,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5*P44/100/2,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5*P44/100)),IF(Q44=50,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5/2,(O44-(SUM($O$5:O44)-ROUNDDOWN(SUM($O$5:O44),0)))*variables!$B$5)),\"\"),IF(AND(N44<>\"\",O44<>\"\",P44<>\"\",R44<>\"\"),IF(R44<6,IF(P44>=50,IF(Q44=50,O44*variables!$B$5/2,O44*variables!$B$5),IF(Q44=50,O44*variables!$B$5*P44/100/2,O44*variables!$B$5*P44/100)),IF(Q44=50,O44*variables!$B$5/2,O44*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G46)=0,IF(AND(F45<>\"\",G45<>\"\",I45<>\"\"),IF(I45<6,IF(G45>=50,IF(H45=50,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4/2,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4),IF(H45=50,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4*G45/100/2,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4*G45/100)),IF(H45=50,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4/2,(F45-(SUM($F$5:F45)-ROUNDDOWN(SUM($F$5:F45),0)))*variables!$B$4)),\"\"),IF(AND(F45<>\"\",G45<>\"\",I45<>\"\"),IF(I45<6,IF(G45>=50,IF(H45=50,F45*variables!$B$4/2,F45*variables!$B$4),IF(H45=50,F45*variables!$B$4*G45/100/2,F45*variables!$B$4*G45/100)),IF(H45=50,F45*variables!$B$4/2,F45*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P46)=0,IF(AND(N45<>\"\",O45<>\"\",P45<>\"\",R45<>\"\"),IF(R45<6,IF(P45>=50,IF(Q45=50,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5/2,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5),IF(Q45=50,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5*P45/100/2,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5*P45/100)),IF(Q45=50,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5/2,(O45-(SUM($O$5:O45)-ROUNDDOWN(SUM($O$5:O45),0)))*variables!$B$5)),\"\"),IF(AND(N45<>\"\",O45<>\"\",P45<>\"\",R45<>\"\"),IF(R45<6,IF(P45>=50,IF(Q45=50,O45*variables!$B$5/2,O45*variables!$B$5),IF(Q45=50,O45*variables!$B$5*P45/100/2,O45*variables!$B$5*P45/100)),IF(Q45=50,O45*variables!$B$5/2,O45*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G47)=0,IF(AND(F46<>\"\",G46<>\"\",I46<>\"\"),IF(I46<6,IF(G46>=50,IF(H46=50,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4/2,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4),IF(H46=50,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4*G46/100/2,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4*G46/100)),IF(H46=50,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4/2,(F46-(SUM($F$5:F46)-ROUNDDOWN(SUM($F$5:F46),0)))*variables!$B$4)),\"\"),IF(AND(F46<>\"\",G46<>\"\",I46<>\"\"),IF(I46<6,IF(G46>=50,IF(H46=50,F46*variables!$B$4/2,F46*variables!$B$4),IF(H46=50,F46*variables!$B$4*G46/100/2,F46*variables!$B$4*G46/100)),IF(H46=50,F46*variables!$B$4/2,F46*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P47)=0,IF(AND(N46<>\"\",O46<>\"\",P46<>\"\",R46<>\"\"),IF(R46<6,IF(P46>=50,IF(Q46=50,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5/2,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5),IF(Q46=50,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5*P46/100/2,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5*P46/100)),IF(Q46=50,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5/2,(O46-(SUM($O$5:O46)-ROUNDDOWN(SUM($O$5:O46),0)))*variables!$B$5)),\"\"),IF(AND(N46<>\"\",O46<>\"\",P46<>\"\",R46<>\"\"),IF(R46<6,IF(P46>=50,IF(Q46=50,O46*variables!$B$5/2,O46*variables!$B$5),IF(Q46=50,O46*variables!$B$5*P46/100/2,O46*variables!$B$5*P46/100)),IF(Q46=50,O46*variables!$B$5/2,O46*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G48)=0,IF(AND(F47<>\"\",G47<>\"\",I47<>\"\"),IF(I47<6,IF(G47>=50,IF(H47=50,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4/2,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4),IF(H47=50,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4*G47/100/2,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4*G47/100)),IF(H47=50,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4/2,(F47-(SUM($F$5:F47)-ROUNDDOWN(SUM($F$5:F47),0)))*variables!$B$4)),\"\"),IF(AND(F47<>\"\",G47<>\"\",I47<>\"\"),IF(I47<6,IF(G47>=50,IF(H47=50,F47*variables!$B$4/2,F47*variables!$B$4),IF(H47=50,F47*variables!$B$4*G47/100/2,F47*variables!$B$4*G47/100)),IF(H47=50,F47*variables!$B$4/2,F47*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P48)=0,IF(AND(N47<>\"\",O47<>\"\",P47<>\"\",R47<>\"\"),IF(R47<6,IF(P47>=50,IF(Q47=50,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5/2,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5),IF(Q47=50,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5*P47/100/2,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5*P47/100)),IF(Q47=50,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5/2,(O47-(SUM($O$5:O47)-ROUNDDOWN(SUM($O$5:O47),0)))*variables!$B$5)),\"\"),IF(AND(N47<>\"\",O47<>\"\",P47<>\"\",R47<>\"\"),IF(R47<6,IF(P47>=50,IF(Q47=50,O47*variables!$B$5/2,O47*variables!$B$5),IF(Q47=50,O47*variables!$B$5*P47/100/2,O47*variables!$B$5*P47/100)),IF(Q47=50,O47*variables!$B$5/2,O47*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G49)=0,IF(AND(F48<>\"\",G48<>\"\",I48<>\"\"),IF(I48<6,IF(G48>=50,IF(H48=50,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4/2,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4),IF(H48=50,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4*G48/100/2,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4*G48/100)),IF(H48=50,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4/2,(F48-(SUM($F$5:F48)-ROUNDDOWN(SUM($F$5:F48),0)))*variables!$B$4)),\"\"),IF(AND(F48<>\"\",G48<>\"\",I48<>\"\"),IF(I48<6,IF(G48>=50,IF(H48=50,F48*variables!$B$4/2,F48*variables!$B$4),IF(H48=50,F48*variables!$B$4*G48/100/2,F48*variables!$B$4*G48/100)),IF(H48=50,F48*variables!$B$4/2,F48*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P49)=0,IF(AND(N48<>\"\",O48<>\"\",P48<>\"\",R48<>\"\"),IF(R48<6,IF(P48>=50,IF(Q48=50,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5/2,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5),IF(Q48=50,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5*P48/100/2,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5*P48/100)),IF(Q48=50,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5/2,(O48-(SUM($O$5:O48)-ROUNDDOWN(SUM($O$5:O48),0)))*variables!$B$5)),\"\"),IF(AND(N48<>\"\",O48<>\"\",P48<>\"\",R48<>\"\"),IF(R48<6,IF(P48>=50,IF(Q48=50,O48*variables!$B$5/2,O48*variables!$B$5),IF(Q48=50,O48*variables!$B$5*P48/100/2,O48*variables!$B$5*P48/100)),IF(Q48=50,O48*variables!$B$5/2,O48*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G50)=0,IF(AND(F49<>\"\",G49<>\"\",I49<>\"\"),IF(I49<6,IF(G49>=50,IF(H49=50,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4/2,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4),IF(H49=50,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4*G49/100/2,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4*G49/100)),IF(H49=50,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4/2,(F49-(SUM($F$5:F49)-ROUNDDOWN(SUM($F$5:F49),0)))*variables!$B$4)),\"\"),IF(AND(F49<>\"\",G49<>\"\",I49<>\"\"),IF(I49<6,IF(G49>=50,IF(H49=50,F49*variables!$B$4/2,F49*variables!$B$4),IF(H49=50,F49*variables!$B$4*G49/100/2,F49*variables!$B$4*G49/100)),IF(H49=50,F49*variables!$B$4/2,F49*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P50)=0,IF(AND(N49<>\"\",O49<>\"\",P49<>\"\",R49<>\"\"),IF(R49<6,IF(P49>=50,IF(Q49=50,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5/2,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5),IF(Q49=50,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5*P49/100/2,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5*P49/100)),IF(Q49=50,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5/2,(O49-(SUM($O$5:O49)-ROUNDDOWN(SUM($O$5:O49),0)))*variables!$B$5)),\"\"),IF(AND(N49<>\"\",O49<>\"\",P49<>\"\",R49<>\"\"),IF(R49<6,IF(P49>=50,IF(Q49=50,O49*variables!$B$5/2,O49*variables!$B$5),IF(Q49=50,O49*variables!$B$5*P49/100/2,O49*variables!$B$5*P49/100)),IF(Q49=50,O49*variables!$B$5/2,O49*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G51)=0,IF(AND(F50<>\"\",G50<>\"\",I50<>\"\"),IF(I50<6,IF(G50>=50,IF(H50=50,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4/2,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4),IF(H50=50,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4*G50/100/2,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4*G50/100)),IF(H50=50,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4/2,(F50-(SUM($F$5:F50)-ROUNDDOWN(SUM($F$5:F50),0)))*variables!$B$4)),\"\"),IF(AND(F50<>\"\",G50<>\"\",I50<>\"\"),IF(I50<6,IF(G50>=50,IF(H50=50,F50*variables!$B$4/2,F50*variables!$B$4),IF(H50=50,F50*variables!$B$4*G50/100/2,F50*variables!$B$4*G50/100)),IF(H50=50,F50*variables!$B$4/2,F50*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P51)=0,IF(AND(N50<>\"\",O50<>\"\",P50<>\"\",R50<>\"\"),IF(R50<6,IF(P50>=50,IF(Q50=50,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5/2,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5),IF(Q50=50,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5*P50/100/2,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5*P50/100)),IF(Q50=50,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5/2,(O50-(SUM($O$5:O50)-ROUNDDOWN(SUM($O$5:O50),0)))*variables!$B$5)),\"\"),IF(AND(N50<>\"\",O50<>\"\",P50<>\"\",R50<>\"\"),IF(R50<6,IF(P50>=50,IF(Q50=50,O50*variables!$B$5/2,O50*variables!$B$5),IF(Q50=50,O50*variables!$B$5*P50/100/2,O50*variables!$B$5*P50/100)),IF(Q50=50,O50*variables!$B$5/2,O50*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G52)=0,IF(AND(F51<>\"\",G51<>\"\",I51<>\"\"),IF(I51<6,IF(G51>=50,IF(H51=50,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4/2,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4),IF(H51=50,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4*G51/100/2,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4*G51/100)),IF(H51=50,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4/2,(F51-(SUM($F$5:F51)-ROUNDDOWN(SUM($F$5:F51),0)))*variables!$B$4)),\"\"),IF(AND(F51<>\"\",G51<>\"\",I51<>\"\"),IF(I51<6,IF(G51>=50,IF(H51=50,F51*variables!$B$4/2,F51*variables!$B$4),IF(H51=50,F51*variables!$B$4*G51/100/2,F51*variables!$B$4*G51/100)),IF(H51=50,F51*variables!$B$4/2,F51*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P52)=0,IF(AND(N51<>\"\",O51<>\"\",P51<>\"\",R51<>\"\"),IF(R51<6,IF(P51>=50,IF(Q51=50,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5/2,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5),IF(Q51=50,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5*P51/100/2,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5*P51/100)),IF(Q51=50,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5/2,(O51-(SUM($O$5:O51)-ROUNDDOWN(SUM($O$5:O51),0)))*variables!$B$5)),\"\"),IF(AND(N51<>\"\",O51<>\"\",P51<>\"\",R51<>\"\"),IF(R51<6,IF(P51>=50,IF(Q51=50,O51*variables!$B$5/2,O51*variables!$B$5),IF(Q51=50,O51*variables!$B$5*P51/100/2,O51*variables!$B$5*P51/100)),IF(Q51=50,O51*variables!$B$5/2,O51*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G53)=0,IF(AND(F52<>\"\",G52<>\"\",I52<>\"\"),IF(I52<6,IF(G52>=50,IF(H52=50,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4/2,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4),IF(H52=50,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4*G52/100/2,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4*G52/100)),IF(H52=50,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4/2,(F52-(SUM($F$5:F52)-ROUNDDOWN(SUM($F$5:F52),0)))*variables!$B$4)),\"\"),IF(AND(F52<>\"\",G52<>\"\",I52<>\"\"),IF(I52<6,IF(G52>=50,IF(H52=50,F52*variables!$B$4/2,F52*variables!$B$4),IF(H52=50,F52*variables!$B$4*G52/100/2,F52*variables!$B$4*G52/100)),IF(H52=50,F52*variables!$B$4/2,F52*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P53)=0,IF(AND(N52<>\"\",O52<>\"\",P52<>\"\",R52<>\"\"),IF(R52<6,IF(P52>=50,IF(Q52=50,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5/2,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5),IF(Q52=50,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5*P52/100/2,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5*P52/100)),IF(Q52=50,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5/2,(O52-(SUM($O$5:O52)-ROUNDDOWN(SUM($O$5:O52),0)))*variables!$B$5)),\"\"),IF(AND(N52<>\"\",O52<>\"\",P52<>\"\",R52<>\"\"),IF(R52<6,IF(P52>=50,IF(Q52=50,O52*variables!$B$5/2,O52*variables!$B$5),IF(Q52=50,O52*variables!$B$5*P52/100/2,O52*variables!$B$5*P52/100)),IF(Q52=50,O52*variables!$B$5/2,O52*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G54)=0,IF(AND(F53<>\"\",G53<>\"\",I53<>\"\"),IF(I53<6,IF(G53>=50,IF(H53=50,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4/2,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4),IF(H53=50,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4*G53/100/2,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4*G53/100)),IF(H53=50,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4/2,(F53-(SUM($F$5:F53)-ROUNDDOWN(SUM($F$5:F53),0)))*variables!$B$4)),\"\"),IF(AND(F53<>\"\",G53<>\"\",I53<>\"\"),IF(I53<6,IF(G53>=50,IF(H53=50,F53*variables!$B$4/2,F53*variables!$B$4),IF(H53=50,F53*variables!$B$4*G53/100/2,F53*variables!$B$4*G53/100)),IF(H53=50,F53*variables!$B$4/2,F53*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P54)=0,IF(AND(N53<>\"\",O53<>\"\",P53<>\"\",R53<>\"\"),IF(R53<6,IF(P53>=50,IF(Q53=50,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5/2,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5),IF(Q53=50,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5*P53/100/2,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5*P53/100)),IF(Q53=50,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5/2,(O53-(SUM($O$5:O53)-ROUNDDOWN(SUM($O$5:O53),0)))*variables!$B$5)),\"\"),IF(AND(N53<>\"\",O53<>\"\",P53<>\"\",R53<>\"\"),IF(R53<6,IF(P53>=50,IF(Q53=50,O53*variables!$B$5/2,O53*variables!$B$5),IF(Q53=50,O53*variables!$B$5*P53/100/2,O53*variables!$B$5*P53/100)),IF(Q53=50,O53*variables!$B$5/2,O53*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G55)=0,IF(AND(F54<>\"\",G54<>\"\",I54<>\"\"),IF(I54<6,IF(G54>=50,IF(H54=50,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4/2,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4),IF(H54=50,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4*G54/100/2,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4*G54/100)),IF(H54=50,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4/2,(F54-(SUM($F$5:F54)-ROUNDDOWN(SUM($F$5:F54),0)))*variables!$B$4)),\"\"),IF(AND(F54<>\"\",G54<>\"\",I54<>\"\"),IF(I54<6,IF(G54>=50,IF(H54=50,F54*variables!$B$4/2,F54*variables!$B$4),IF(H54=50,F54*variables!$B$4*G54/100/2,F54*variables!$B$4*G54/100)),IF(H54=50,F54*variables!$B$4/2,F54*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P55)=0,IF(AND(N54<>\"\",O54<>\"\",P54<>\"\",R54<>\"\"),IF(R54<6,IF(P54>=50,IF(Q54=50,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5/2,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5),IF(Q54=50,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5*P54/100/2,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5*P54/100)),IF(Q54=50,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5/2,(O54-(SUM($O$5:O54)-ROUNDDOWN(SUM($O$5:O54),0)))*variables!$B$5)),\"\"),IF(AND(N54<>\"\",O54<>\"\",P54<>\"\",R54<>\"\"),IF(R54<6,IF(P54>=50,IF(Q54=50,O54*variables!$B$5/2,O54*variables!$B$5),IF(Q54=50,O54*variables!$B$5*P54/100/2,O54*variables!$B$5*P54/100)),IF(Q54=50,O54*variables!$B$5/2,O54*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G56)=0,IF(AND(F55<>\"\",G55<>\"\",I55<>\"\"),IF(I55<6,IF(G55>=50,IF(H55=50,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4/2,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4),IF(H55=50,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4*G55/100/2,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4*G55/100)),IF(H55=50,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4/2,(F55-(SUM($F$5:F55)-ROUNDDOWN(SUM($F$5:F55),0)))*variables!$B$4)),\"\"),IF(AND(F55<>\"\",G55<>\"\",I55<>\"\"),IF(I55<6,IF(G55>=50,IF(H55=50,F55*variables!$B$4/2,F55*variables!$B$4),IF(H55=50,F55*variables!$B$4*G55/100/2,F55*variables!$B$4*G55/100)),IF(H55=50,F55*variables!$B$4/2,F55*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P56)=0,IF(AND(N55<>\"\",O55<>\"\",P55<>\"\",R55<>\"\"),IF(R55<6,IF(P55>=50,IF(Q55=50,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5/2,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5),IF(Q55=50,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5*P55/100/2,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5*P55/100)),IF(Q55=50,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5/2,(O55-(SUM($O$5:O55)-ROUNDDOWN(SUM($O$5:O55),0)))*variables!$B$5)),\"\"),IF(AND(N55<>\"\",O55<>\"\",P55<>\"\",R55<>\"\"),IF(R55<6,IF(P55>=50,IF(Q55=50,O55*variables!$B$5/2,O55*variables!$B$5),IF(Q55=50,O55*variables!$B$5*P55/100/2,O55*variables!$B$5*P55/100)),IF(Q55=50,O55*variables!$B$5/2,O55*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G57)=0,IF(AND(F56<>\"\",G56<>\"\",I56<>\"\"),IF(I56<6,IF(G56>=50,IF(H56=50,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4/2,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4),IF(H56=50,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4*G56/100/2,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4*G56/100)),IF(H56=50,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4/2,(F56-(SUM($F$5:F56)-ROUNDDOWN(SUM($F$5:F56),0)))*variables!$B$4)),\"\"),IF(AND(F56<>\"\",G56<>\"\",I56<>\"\"),IF(I56<6,IF(G56>=50,IF(H56=50,F56*variables!$B$4/2,F56*variables!$B$4),IF(H56=50,F56*variables!$B$4*G56/100/2,F56*variables!$B$4*G56/100)),IF(H56=50,F56*variables!$B$4/2,F56*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P57)=0,IF(AND(N56<>\"\",O56<>\"\",P56<>\"\",R56<>\"\"),IF(R56<6,IF(P56>=50,IF(Q56=50,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5/2,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5),IF(Q56=50,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5*P56/100/2,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5*P56/100)),IF(Q56=50,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5/2,(O56-(SUM($O$5:O56)-ROUNDDOWN(SUM($O$5:O56),0)))*variables!$B$5)),\"\"),IF(AND(N56<>\"\",O56<>\"\",P56<>\"\",R56<>\"\"),IF(R56<6,IF(P56>=50,IF(Q56=50,O56*variables!$B$5/2,O56*variables!$B$5),IF(Q56=50,O56*variables!$B$5*P56/100/2,O56*variables!$B$5*P56/100)),IF(Q56=50,O56*variables!$B$5/2,O56*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G58)=0,IF(AND(F57<>\"\",G57<>\"\",I57<>\"\"),IF(I57<6,IF(G57>=50,IF(H57=50,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4/2,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4),IF(H57=50,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4*G57/100/2,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4*G57/100)),IF(H57=50,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4/2,(F57-(SUM($F$5:F57)-ROUNDDOWN(SUM($F$5:F57),0)))*variables!$B$4)),\"\"),IF(AND(F57<>\"\",G57<>\"\",I57<>\"\"),IF(I57<6,IF(G57>=50,IF(H57=50,F57*variables!$B$4/2,F57*variables!$B$4),IF(H57=50,F57*variables!$B$4*G57/100/2,F57*variables!$B$4*G57/100)),IF(H57=50,F57*variables!$B$4/2,F57*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P58)=0,IF(AND(N57<>\"\",O57<>\"\",P57<>\"\",R57<>\"\"),IF(R57<6,IF(P57>=50,IF(Q57=50,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5/2,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5),IF(Q57=50,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5*P57/100/2,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5*P57/100)),IF(Q57=50,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5/2,(O57-(SUM($O$5:O57)-ROUNDDOWN(SUM($O$5:O57),0)))*variables!$B$5)),\"\"),IF(AND(N57<>\"\",O57<>\"\",P57<>\"\",R57<>\"\"),IF(R57<6,IF(P57>=50,IF(Q57=50,O57*variables!$B$5/2,O57*variables!$B$5),IF(Q57=50,O57*variables!$B$5*P57/100/2,O57*variables!$B$5*P57/100)),IF(Q57=50,O57*variables!$B$5/2,O57*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(G59)=0,IF(AND(F58<>\"\",G58<>\"\",I58<>\"\"),IF(I58<6,IF(G58>=50,IF(H58=50,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4/2,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4),IF(H58=50,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4*G58/100/2,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4*G58/100)),IF(H58=50,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4/2,(F58-(SUM($F$5:F58)-ROUNDDOWN(SUM($F$5:F58),0)))*variables!$B$4)),\"\"),IF(AND(F58<>\"\",G58<>\"\",I58<>\"\"),IF(I58<6,IF(G58>=50,IF(H58=50,F58*variables!$B$4/2,F58*variables!$B$4),IF(H58=50,F58*variables!$B$4*G58/100/2,F58*variables!$B$4*G58/100)),IF(H58=50,F58*variables!$B$4/2,F58*variables!$B$4)),\"\"))","v":""},null,null,null,null,"",null,null,"",{"$f":"IF(COUNTA(P59)=0,IF(AND(N58<>\"\",O58<>\"\",P58<>\"\",R58<>\"\"),IF(R58<6,IF(P58>=50,IF(Q58=50,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5/2,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5),IF(Q58=50,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5*P58/100/2,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5*P58/100)),IF(Q58=50,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5/2,(O58-(SUM($O$5:O58)-ROUNDDOWN(SUM($O$5:O58),0)))*variables!$B$5)),\"\"),IF(AND(N58<>\"\",O58<>\"\",P58<>\"\",R58<>\"\"),IF(R58<6,IF(P58>=50,IF(Q58=50,O58*variables!$B$5/2,O58*variables!$B$5),IF(Q58=50,O58*variables!$B$5*P58/100/2,O58*variables!$B$5*P58/100)),IF(Q58=50,O58*variables!$B$5/2,O58*variables!$B$5)),\"\"))","v":""}]
[null,null,null,null,null,null,"TOTAL: ",null,null,{"$f":"SUM(J5:J58)","v":0},null,null,null,null,null,"TOTAL: ",null,null,{"$f":"SUM(S5:S58)","v":0}]

{"sheet":"FORMACIÓN","index":2,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":true,"merged":[[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],[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],[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],[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],[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],[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],[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]]}
[null,null,null,"B.2a MÉRITOS FORMACIÓN:",null,null,null,null,null,null,null,null,"B.2b OTROS MÉRITOS (si aplica):"]
[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!$J$59,EXPERIENCIA!$S$59)<variables!$B$1,SUM(EXPERIENCIA!$J$59,EXPERIENCIA!$S$59),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":58,"n_cols":9,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["EXPERIENCIA (puntuación máxima)",70,null,"FORMACIÓN",0,null,"Documento de autobaremación para los procesos de estabilización por el procedimiento de CONCURSO"]
["FORMACIÓN (puntuación máxima)",30,null,"0—20",1]
["# de PLAZA por la que se opta",{"$f":"VLOOKUP(B6,A9:D58,4,0)","v":1},null,"—40",2,null,{"$f":"CONCATENATE(H3,\" \",I3)","v":"Sección de: DATOS PERSONALES"},"Sección de:",{"$f":"MID(CELL(\"nombrearchivo\"),FIND(\"]\",CELL(\"nombrearchivo\"))+1,31)","v":"DATOS PERSONALES"}]
["EXP. MAJADAHONDA (puntos x mes)",{"$f":"INDEX(A9:C58,B3,2)","v":0},null,"—100",3]
["AA.PP. (puntos x mes)",{"$f":"INDEX(A9:C58,B3,3)","v":0},null,"—300",4]
["Plaza elegida:","Seleccione una opción…",null,">300",5]
[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]
["20. INGENIERO DE CAMINOS, CANALES Y PUERTOS",0.4,0.15,2]
["21. INSPECTOR DE SANIDAD",0.75,0.25,3]
["22. MÉDICO PROGRAMA DE DROGAS",0.4,0.15,4]
["23. PSIQUIATRA",0.6,0.2,5]
["24. PSICÓLOGO",0.4,0.15,6]
["25. ADMINISTRADOR CENTRO DE MAYORES",0.75,0.25,7]
["26. TRABAJADOR SOCIAL",0.75,0.25,8]
["27. DUE",0.6,0.2,9]
["28. AYUDANTE DE BIBLIOTECA",0.75,0.25,10]
["29. INGENIERO TÉCNICO INDUSTRIAL",0.4,0.15,11]
["30. AGENTE DE DESARROLLO LOCAL",0.4,0.15,12]
["31. AGENTE SOCIOECONÓMICO",0.4,0.15,13]
["32. MONITOR SOCIOCULTURAL",0.75,0.25,14]
["33. TÉCNICO AUXILIAR DE BIBLIOTECA",0.4,0.15,15]
["34. AUXILIAR DE BIBLIOTECA",0.75,0.25,16]
["35. AUXILIAR DE CLÍNICA",0.6,0.2,17]
["36. CONDUCTOR ESCOLTA",0.4,0.15,18]
["37. OPERADOR DE SERVICIOS INFORMÁTICOS",0.4,0.15,19]
["38. AUXILIAR ADMINISTRATIVO",0.75,0.25,20]
["39. AYUDANTE DE SERVICIOS",0.4,0.15,21]
["40. ORDENANZA",0.4,0.15,22]
["41. CONSERJE ESCOLAR",0.75,0.25,23]
["42. ANIMADOR SOCIOCULTURAL",0.4,0.15,24]
["43. PROFESOR DE DANZA",0.75,0.25,25]
["44. PROFESOR DE FOTOGRAFÍA",0.75,0.25,26]
["45. MONITOR AUXILIAR DE COMERCIO",0.4,0.15,27]
["46. PROFESOR GARANTÍA SOCIAL",0.4,0.15,28]
["47. ADMINISTRATIVO",0.75,0.25,29]
["48. DELINEANTE",0.4,0.15,30]
["49. SOCORRISTA",0.75,0.25,31]
["50. AYUDANTE DE MANTENIMIENTO",0.6,0.2,32]
["51. OFICIAL 2ª JARDINERÍA",0.75,0.25,33]
["52. TÉCNICO AUXILIAR DE PROTECCIÓN CIVIL",0.75,0.25,34]
["53. OPERARIO DE JARDINERÍA",0.6,0.2,35]
["54. PROFESOR DE MÚSICA Y EXPRESIÓN CORPORAL",0.75,0.25,36]
["55. PROFESOR DE LENGUAJE MUSICAL",0.75,0.25,37]
["56. PROFESOR DE ARPA",0.75,0.25,38]
["57. PROFESOR DE VIOLONCHELO",0.75,0.25,39]
["58. PROFESOR DE CANTO",0.75,0.25,40]
["59. PROFESOR DE TROMPETA",0.75,0.25,41]
["60. PROFESOR DE PERCUSIÓN",0.75,0.25,42]
["61. PROFESOR DE CONJUNTO VOCAL E INSTRUMENTOS",0.75,0.25,43]
["62. PROFESOR DE AGRUPACIÓN VOCAL",0.75,0.25,44]
["63. PROFESOR DE MÚSICA Y MOVIMIENTO",0.75,0.25,45]
["64. PROFESOR DE CLARINETE",0.75,0.25,46]
["65. PROFESOR DE PIANO-LENGUAJE MUSICAL",0.75,0.25,47]
["66. PROFESOR DE GUITARRA",0.75,0.25,48]
["67. PROFESOR DE VIOLA-VIOLÍN",0.75,0.25,49]
["68. PROFESOR DE FLAUTA TRAVESERA",0.75,0.25,50]