{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CUPOS PROGRAMADOS 2018","LISTAS","Certificación Supervisor","Certificación Operador","Convenciones","RESUMEN_REGIONAL_UNIDAD_MEDIDA"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":171,"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":"CUPOS PROGRAMADOS 2018","index":0,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":true,"merged":[[1,9,1,14]]}
[]
[null,null,null,null,null,null,null,null,null,"encuentros vivenciales"]
["Cod Reg","Regional ","TOTAL COBERTURA","Cobertura\nNo Victimas GCB","Cobertura\nNo Victimas  GRCB","Cobertura\nNo Victimas GECB","Cobertura\nVictimas GCB","Cobertura\nVictimas GRCB","Cobertura\nVictimas GECB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES No Victimas GCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES No Victimas  GRCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES No Victimas GECB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES Victimas GCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES Victimas  GRCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES Victimas GECB"]
[91,"AMAZONAS",{"$f":"SUM(D4:I4)","v":1800},500,0,1300,0,0,0,40400,0,67316,0,0,0]
[5,"ANTIOQUIA",{"$f":"SUM(D5:I5)","v":13400},6550,2100,575,350,100,3725,40051,57922,61906,40051,57922,61906]
[81,"ARAUCA",4400,2120,930,800,80,70,400,41271,61901,84187,41271,61901,84187]
[8,"ATLÁNTICO",4100,2910,200,750,190,0,50,38403,47091,47091,38403,0,47091]
[11,"BOGOTÁ",4500,3800,200,500,0,0,0,37356,47349,47349,0,0,0]
[13,"BOLÍVAR",6800,3150,2500,550,250,100,250,39709,54169,51430,39709,54169,51430]
[15,"BOYACÁ",5200,3460,1350,100,240,50,0,38065,50459,55914,38065,50459,0]
[17,"CALDAS",5900,2620,390,1450,180,10,1250,37318,46025,47690,37318,46025,47690]
[18,"CAQUETÁ",4200,2750,840,400,150,60,0,38227,52339,51905,38227,52339,0]
[85,"CASANARE",2500,1490,380,300,110,20,200,38435,49523,69784,38435,49523,69784]
[19,"CAUCA",11550,6600,300,2625,400,0,1625,40253,66731,66731,40253,0,66731]
[20,"CESAR",7100,4140,760,1275,260,40,625,39260,54097,51026,39260,54097,51026]
[27,"CHOCÓ",12500,4600,1500,4000,0,0,2400,40366,53766,63296,0,0,63296]
[23,"CÓRDOBA",6800,4350,1000,550,250,100,550,38957,53801,68955,38957,53801,68955]
[25,"CUNDINAMARCA",3400,3125,0,0,275,0,0,39496,0,0,39496,0,0]
[94,"GUAINÍA",1600,380,300,900,20,0,0,38138,77598,77598,38138,0,0]
[95,"GUAVIARE",2500,500,500,650,300,400,150,42150,61773,74304,42150,61773,74304]
[41,"HUILA",4400,2920,960,300,180,40,0,38124,47897,54309,38124,47897,0]
[44,"LA GUAJIRA",5900,2900,0,3000,0,0,0,37641,0,50352,0,0,0]
[47,"MAGDALENA",9700,7440,675,1175,360,25,25,39120,57103,49628,39120,57103,49628]
[50,"META",4400,2275,1030,325,125,70,575,37526,45292,57658,37526,45292,57658]
[52,"NARIÑO",12100,6740,1130,2900,360,70,900,39465,55872,60549,39465,55872,60549]
[54,"NORTE DE SANTANDER",6700,3500,1800,700,300,100,300,38796,53382,56675,38796,53382,56675]
[86,"PUTUMAYO",5700,2300,830,825,200,70,1475,41860,62683,68059,41860,62683,68059]
[63,"QUINDÍO",4000,2750,600,200,150,0,300,38852,55676,55676,38852,0,55676]
[66,"RISARALDA",4100,2180,500,0,120,0,1300,37491,50743,0,37491,0,50743]
[88,"SAN ANDRÉS",1800,900,0,900,0,0,0,40637,0,55088,0,0,0]
[68,"SANTANDER",4800,4160,300,0,240,0,100,39390,57428,0,39390,0,62674]
[70,"SUCRE",4800,3090,560,400,210,40,500,39067,49283,49847,39067,49283,49847]
[73,"TOLIMA",5800,3580,925,550,220,75,450,37143,45975,51724,37143,45975,51724]
[76,"VALLE DEL CAUCA",9800,5000,1050,475,300,50,2925,37862,45061,51466,37862,45061,51466]
[97,"VAUPÉS",1500,400,300,600,0,0,200,39865,52294,75438,0,0,75438]
[99,"VICHADA",1400,470,370,500,30,30,0,40943,65680,71187,40943,65680,0]
[null,"TOTAL GCB",{"$f":"SUM(C4:C36)","v":185150},103650,24280,29575,5850,1520,20275,{"$f":"+AVERAGE(J4:J36)","v":39140.515151515152},{"$f":"+AVERAGE(K4:K36)","v":47845.848484848488},54367.818181818184,31980.969696969696,32431.424242424244,41713.242424242424]
[]
[null,null,"ESCENARIO META( COBERTURA 2015)"]
[null,null,"PROGRAMA","COBERTURA","TIEMPO DE EJECUCION","VALOR ALISTAMIENTO","ENCUENTROS VIVENCIALES","ACTIVIDAD DE CIERRE","TOTAL"]
[null,null,"RURAL",10000,7,3576,43605,7268,{"$f":"+(D41*F41)+(D41*E41*G41)+(D41*H41)","v":3160790000}]
[null,null,"TRADICIONAL",5000,7,3576,33075,8269,{"$f":"+(D42*F42)+(D42*E42*G42)+(D42*H42)","v":1216850000}]
[null,null,"ETNICO",6375,7,3576,43605,7268,{"$f":"+(D43*F43)+(D43*E43*G43)+(D43*H43)","v":2015003625}]
[null,null,"TOTAL",{"$f":"SUM(D41:D43)","v":21375},null,null,null,null,{"$f":"SUM(I41:I43)","v":6392643625}]
[]
[]
[null,null,null,"VALOR","TIEMPO"]
[null,null,"VALOR TOTAL  Victimas GCB",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"VALOR TOTAL Victimas  GRCB",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"SUBTOTAL VICTIMAS",{"$f":"SUM(D48:D49)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,"VALOR","TIEMPO"]
[null,null,"VALOR TOTAL No Victimas GCB",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"VALOR TOTAL No Victimas  GRCB",{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,null,"SUBTOTAL NO VICTIMAS",{"$f":"SUM(D54:D55)","v":{"$error":"#REF!"}}]
[]
[null,null,"TOTAL",{"$f":"+D50+D56","v":{"$error":"#REF!"}}]

{"sheet":"LISTAS","index":1,"n_rows":38,"n_cols":30,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,"Modalidad"]
[null,null,"Regional ","Modalidad","Cobertura\nNo GCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES GCB",null,"Regional ","Modalidad","Cobertura\nNo  GRCB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES  GRCB",null,"Regional ","Modalidad","Cobertura\nNo GECB","COSTO CUPO MES DE ENCUENTROS VIVENCIALES GECB",null,null,"No. DE ENCUENTROS VIVENCIALES AL MES",null,null,null,"EncuentrosContratados",null,null,"Etapa",null,"Generaciones Étnicas con Bienestar"]
[91,{"$f":"C5&D5","v":"AMAZONAS"},"AMAZONAS",null,null,null,null,null,null,null,null,{"$f":"M5&N5","v":"AMAZONASEtnico"},"AMAZONAS","Etnico",1500,71623,null,1,1,null,null,null,"Tradicional",8,null,"Alistamiento",null,"Programa para la Promoción del Desarrollo de niñas y niños ",{"$f":"+P5/7","v":10231.857142857143},{"$f":"+AC5*6.5","v":66507.071428571435}]
[5,{"$f":"C6&D6","v":"ANTIOQUIA"},"ANTIOQUIA",null,null,null,null,null,null,null,null,{"$f":"M6&N6","v":"ANTIOQUIAEtnico"},"ANTIOQUIA","Etnico",5475,65867,null,2,2,null,null,null,"Rural",12,null,"Operación"]
[81,"ARAUCA","ARAUCA",null,null,null,null,null,null,null,null,"ARAUCAEtnico","ARAUCA","Etnico",2400,89574,null,3,3,null,null,null,"Etnico",12,null,"Cierre"]
[8,"ATLÁNTICO","ATLÁNTICO",null,null,null,null,null,null,null,null,"ATLÁNTICOEtnico","ATLÁNTICO","Etnico",800,50104,null,4,4,null,null,null,"Tradicional",8]
[11,"BOGOTÁ","BOGOTÁ",null,null,null,null,null,null,null,null,"BOGOTÁEtnico","BOGOTÁ","Etnico",500,50379,null,5,5,null,null,null,"Rural",12]
[13,"BOLÍVAR","BOLÍVAR",null,null,null,null,null,null,null,null,"BOLÍVAREtnico","BOLÍVAR","Etnico",1700,54721,null,null,6,null,null,null,"Etnico",12]
[15,"BOYACÁ","BOYACÁ",null,null,null,null,null,null,null,null,"BOYACÁEtnico","BOYACÁ","Etnico",100,59492,null,null,7]
[17,"CALDAS","CALDAS",null,null,null,null,null,null,null,null,"CALDASEtnico","CALDAS","Etnico",2700,50742,null,null,8]
[18,"CAQUETÁ","CAQUETÁ",null,null,null,null,null,null,null,null,"CAQUETÁEtnico","CAQUETÁ","Etnico",450,55227,null,null,9,null,null,null,"Tradicional"]
[85,"CASANARE","CASANARE",null,null,null,null,null,null,null,null,"CASANAREEtnico","CASANARE","Etnico",800,74250,null,null,10,null,null,null,"Rural"]
[19,"CAUCA","CAUCA",null,null,null,null,null,null,null,null,"CAUCAEtnico","CAUCA","Etnico",5000,71001,null,null,11,null,null,null,"Etnico"]
[20,"CESAR","CESAR",null,null,null,null,null,null,null,null,"CESAREtnico","CESAR","Etnico",2600,54291,null,null,12]
[27,"CHOCÓ","CHOCÓ",null,null,null,null,null,null,null,null,"CHOCÓEtnico","CHOCÓ","Etnico",11150,67347]
[23,"CÓRDOBA","CÓRDOBA",null,null,null,null,null,null,null,null,"CÓRDOBAEtnico","CÓRDOBA","Etnico",4100,73368,null,null,"Mes"]
[25,"CUNDINAMARCA","CUNDINAMARCA",null,null,null,null,null,null,null,null,"CUNDINAMARCAEtnico","CUNDINAMARCA","Etnico",0,0,null,null,"Enero"]
[94,"GUAINÍA","GUAINÍA",null,null,null,null,null,null,null,null,"GUAINÍAEtnico","GUAINÍA","Etnico",900,82564,null,null,"Febrero"]
[95,"GUAVIARE","GUAVIARE",null,null,null,null,null,null,null,null,"GUAVIAREEtnico","GUAVIARE","Etnico",1125,79059,null,null,"Marzo"]
[41,"HUILA","HUILA",null,null,null,null,null,null,null,null,"HUILAEtnico","HUILA","Etnico",300,57784,null,null,"Abril "]
[44,"LA GUAJIRA","LA GUAJIRA",null,null,null,null,null,null,null,null,"LA GUAJIRAEtnico","LA GUAJIRA","Etnico",3150,53574,null,null,"Mayo"]
[47,"MAGDALENA","MAGDALENA",null,null,null,null,null,null,null,null,"MAGDALENAEtnico","MAGDALENA","Etnico",1700,52804,null,null,"Junio"]
[50,"META","META",null,null,null,null,null,null,null,null,"METAEtnico","META","Etnico",1375,61348,null,null,"Julio"]
[52,"NARIÑO","NARIÑO",null,null,null,null,null,null,null,null,"NARIÑOEtnico","NARIÑO","Etnico",4600,64423,null,null,"Agosto"]
[54,"NORTE DE SANTANDER","NORTE DE SANTANDER",null,null,null,null,null,null,null,null,"NORTE DE SANTANDEREtnico","NORTE DE SANTANDER","Etnico",1400,60301,null,null,"Septiembre"]
[86,"PUTUMAYO","PUTUMAYO",null,null,null,null,null,null,null,null,"PUTUMAYOEtnico","PUTUMAYO","Etnico",2550,72414,null,null,"Octubre"]
[63,"QUINDÍO","QUINDÍO",null,null,null,null,null,null,null,null,"QUINDÍOEtnico","QUINDÍO","Etnico",450,59238,null,null,"Noviembre"]
[66,"RISARALDA","RISARALDA",null,null,null,null,null,null,null,null,"RISARALDAEtnico","RISARALDA","Etnico",1600,53991,null,null,"Diciembre"]
[88,"SAN ANDRÉS","SAN ANDRÉS",null,null,null,null,null,null,null,null,"SAN ANDRÉSEtnico","SAN ANDRÉS","Etnico",900,58613]
[68,"SANTANDER","SANTANDER",null,null,null,null,null,null,null,null,"SANTANDEREtnico","SANTANDER","Etnico",400,66684]
[70,"SUCRE","SUCRE",null,null,null,null,null,null,null,null,"SUCREEtnico","SUCRE","Etnico",1200,53037]
[73,"TOLIMA","TOLIMA",null,null,null,null,null,null,null,null,"TOLIMAEtnico","TOLIMA","Etnico",1125,55034]
[76,"VALLE DEL CAUCA","VALLE DEL CAUCA",null,null,null,null,null,null,null,null,"VALLE DEL CAUCAEtnico","VALLE DEL CAUCA","Etnico",4450,54759]
[97,"VAUPÉS","VAUPÉS",null,null,null,null,null,null,null,null,"VAUPÉSEtnico","VAUPÉS","Etnico",1100,80265]
[99,"VICHADA","VICHADA",null,null,null,null,null,null,null,null,"VICHADAEtnico","VICHADA","Etnico",975,75742]
[null,null,null,null,{"$f":"SUM(E5:E37)","v":0},{"$f":"+AVERAGE(F5:F37)","v":{"$error":"#DIV/0!"}},null,33472843625,null,{"$f":"SUM(J5:J37)","v":0},40432.060606060608,null,null,null,{"$f":"SUM(O5:O37)","v":68575},{"$f":"+AVERAGE(P5:P37)","v":61503.63636363636}]

{"sheet":"Certificación Supervisor","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,7],[0,1,0,7],[1,1,1,7],[2,0,2,4],[2,5,2,6],[3,1,3,6],[5,0,5,1],[5,2,5,7],[10,0,10,7],[11,0,11,1],[11,2,11,7],[6,0,6,3],[7,0,7,3],[6,4,6,7],[7,4,7,7],[12,0,12,1],[12,2,12,7],[13,0,13,1],[13,2,13,7],[14,0,14,1],[14,2,14,7],[15,0,15,1],[15,2,15,7],[17,0,17,1],[17,2,17,7],[18,0,18,1],[18,2,18,7],[16,0,16,1],[16,2,16,7],[19,0,20,2],[19,3,20,5],[19,6,20,7],[21,0,21,2],[21,3,21,5],[21,6,21,7],[22,0,22,2],[22,3,22,5],[22,6,22,7],[23,0,23,2],[23,3,23,5],[23,6,23,7],[24,0,24,2],[24,3,24,5],[24,6,24,7],[25,0,25,2],[25,3,25,5],[25,6,25,7],[29,6,29,7],[26,0,26,2],[26,3,26,5],[26,6,26,7],[27,0,27,2],[27,3,27,5],[27,6,27,7],[28,0,28,2],[28,3,28,5],[28,6,28,7],[29,0,29,2],[29,3,29,5],[35,0,35,7],[36,0,36,7],[37,0,39,7],[32,0,32,2],[32,3,32,5],[32,6,32,7],[33,0,33,2],[33,4,33,6],[34,0,34,7],[30,0,30,2],[30,3,30,5],[30,6,30,7],[31,0,31,2],[31,3,31,5],[31,6,31,7]]}
["Nombre del Operador:"]
["Numero de contrato:"]
["                                                                                                  CERTIFICACION DE COBERTURA (Corresponde al Supervisor)                                                                                                      ",null,null,null,null,"Mes de Certificación: "]
[{"$f":"IFERROR(IF(C6=\"Alistamiento\",2,IF(C6=\"Operación\",3,IF(C6=\"Cierre\",4))),\"\")","v":false}]
["Regional:"]
["Etapa:"]
["El suscrito supervisor:"]
["Cédula de Ciudadanía:"]
[]
["Valor Inicial del Contrato:",null,"Reducciones al contrato: ",null,"Adiciones al Contrato: ",null,"Valor Total del Contrato:",{"$f":"B10-D10+F10","v":0}]
["CERTIFICA:"]
["Mes de Ejecución"]
["Encuentro a realizar * mes",null,{"$f":"IF(C6=\"Alistamiento\",\"\",IF(C5=\"\",\"\",12))","v":""}]
["Valor Cupo Mensual según etapa",null,{"$f":"IFERROR(VLOOKUP(C5,costos_mod_et,A4,0),\"\")","v":""}]
["Valor Unitario Encuentro",null,{"$f":"IFERROR(IF(C6=\"Alistamiento\",C14,IF(C6=\"Operación\",C14/12,IF(C6=\"Cierre\",C14,\"\"))),\"\")","v":""}]
["Cupos Contratados "]
[{"$f":"IF(C6=\"\",\"\",IF(C6=\"Alistamiento\",\"(12) Cupos Focalizados\",IF(C6=\"Cierre\",\"(12) Participantes actividad\",IF(C6=\"Operación\",\"(12) Niñas y Niños atendidos\"))))","v":""}]
["Proyección Grupos Contratados",null,{"$f":"IF(C6=\"Alistamiento\",\"\",C16/25)","v":0}]
["Grupos  Constituidos"]
["# ENCUENTRO VIVENCIAL EN EL MES DE OPERACIÓN ",null,null,"Número de niñas y niños que participaron en cada Encuentro Vivencial",null,null,"Subtotales por Encuentro Vivencial "]
[]
[{"$f":"IF($C$13<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A22<($C$13+1),$C$15*D22,\" \"),\"\")","v":""}]
[{"$f":"IF($C$13<2,\" \",2)","v":2},null,null,0,null,null,{"$f":"IFERROR(IF(A23<($C$13+1),$C$15*D23,\" \"),\"\")","v":""}]
[{"$f":"IF($C$13<3,\" \",3)","v":3},null,null,0,null,null,""]
[{"$f":"IF($C$13<4,\" \",4)","v":4},null,null,0,null,null,""]
[{"$f":"IF($C$13<5,\" \",5)","v":5},null,null,0,null,null,""]
[{"$f":"IF($C$13<6,\" \",6)","v":6},null,null,0,null,null,""]
[{"$f":"IF($C$13<7,\" \",7)","v":7},null,null,0,null,null,""]
[{"$f":"IF($C$13<8,\" \",8)","v":8},null,null,0,null,null,""]
[{"$f":"IF($C$13<9,\" \",9)","v":9},null,null,0,null,null,""]
[{"$f":"IF($C$13<10,\" \",10)","v":10},null,null,0,null,null,""]
[{"$f":"IF($C$13<11,\" \",11)","v":11},null,null,0,null,null,""]
[{"$f":"IF($C$13<12,\" \",12)","v":12},null,null,0,null,null,{"$f":"IFERROR(IF(A33<($C$13+1),$C$15*D33,\" \"),\"\")","v":""}]
[{"$f":"IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),\"\",\"SUMATORIA ENCUENTROS\")","v":"SUMATORIA ENCUENTROS"},null,null,{"$f":"IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),\"\",12-(SUM(COUNTIF(D22:F33,0),COUNTIF(D22:F33,\"\"))-24))","v":0},"VALOR A FACTURAR",null,null,{"$f":"IFERROR(IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),(C17*C15),(SUM(G22,G23,G24,G25,G26,G27,G28,G29,G30,G31,G32,G33))),\"\")","v":0}]
["La presente certificación se expide a los__________días del mes de_________________del año ___________"]
["                                                                                                    "]
["NOMBRE Y FIRMA DEL SUPERVISOR DEL CONTRATO"]

{"sheet":"Certificación Operador","index":3,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[37,0,39,7],[31,0,31,2],[31,3,31,5],[31,6,31,7],[32,0,32,2],[32,3,32,5],[32,6,32,7],[33,0,33,2],[33,4,33,6],[34,0,34,7],[35,0,35,7],[36,0,36,7],[29,0,29,2],[29,3,29,5],[29,6,29,7],[30,0,30,2],[30,3,30,5],[30,6,30,7],[27,0,27,2],[27,3,27,5],[27,6,27,7],[28,0,28,2],[28,3,28,5],[28,6,28,7],[25,0,25,2],[25,3,25,5],[25,6,25,7],[26,0,26,2],[26,3,26,5],[26,6,26,7],[23,0,23,2],[23,3,23,5],[23,6,23,7],[24,0,24,2],[24,3,24,5],[24,6,24,7],[21,0,21,2],[21,3,21,5],[21,6,21,7],[22,0,22,2],[22,3,22,5],[22,6,22,7],[17,0,17,1],[17,2,17,7],[18,0,18,1],[18,2,18,7],[19,0,20,2],[19,3,20,5],[19,6,20,7],[14,0,14,1],[14,2,14,7],[15,0,15,1],[15,2,15,7],[16,0,16,1],[16,2,16,7],[13,0,13,1],[13,2,13,7],[5,0,5,1],[5,2,5,7],[6,0,6,3],[6,4,6,7],[7,0,7,3],[7,4,7,7],[10,0,10,7],[11,0,11,1],[11,2,11,7],[12,0,12,1],[12,2,12,7],[4,0,4,1],[4,2,4,7],[0,1,0,7],[1,1,1,7],[2,0,2,4],[2,5,2,6],[3,1,3,6]]}
["Nombre del Operador:"]
["Numero de contrato:"]
["CERTIFICACIÓN DE COBERTURA (Corresponde al Operador)",null,null,null,null,"Mes de Certificación: "]
[{"$f":"IFERROR(IF(C6=\"Alistamiento\",2,IF(C6=\"Operación\",3,IF(C6=\"Cierre\",4))),\"\")","v":false}]
["Regional:"]
["Etapa:"]
["El suscrito representante legal:"]
["Cédula de Ciudadanía:"]
[]
["(4) Valor Inicial del Contrato:",null,"(5) Reducciones al contrato: ",null,"(5) Adiciones al Contrato: ",null,"(9) Valor Total del Contrato:",{"$f":"B10-D10+F10","v":0}]
["CERTIFICA:"]
["Mes de Ejecución"]
["Encuentro a realizar * mes",null,{"$f":"IF(C6=\"Alistamiento\",\"\",IF(C5=\"\",\"\",12))","v":""}]
["Valor Cupo Mensual según etapa",null,{"$f":"IFERROR(VLOOKUP(C5,costos_mod_et,A4,0),\"\")","v":""}]
["Valor Unitario Encuentro",null,{"$f":"IFERROR(IF(C6=\"Alistamiento\",C14,IF(C6=\"Operación\",C14/12,IF(C6=\"Cierre\",C14,\"\"))),\"\")","v":""}]
["Cupos Contratados "]
[{"$f":"IF(C6=\"\",\"\",IF(C6=\"Alistamiento\",\"(12) Cupos Focalizados\",IF(C6=\"Cierre\",\"(12) Participantes actividad\",IF(C6=\"Operación\",\"(12) Niñas y Niños atendidos\"))))","v":""}]
["Proyección Grupos Contratados",null,{"$f":"IF(C6=\"Alistamiento\",\"\",C16/25)","v":0}]
["Grupos  Constituidos"]
["# ENCUENTRO VIVENCIAL EN EL MES DE OPERACIÓN ",null,null,"Número de niñas y niños que participaron en cada Encuentro Vivencial",null,null,"Subtotales por Encuentro Vivencial "]
[]
[{"$f":"IF($C$13<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A22<($C$13+1),$C$15*D22,\" \"),\"\")","v":""}]
[{"$f":"IF($C$13<2,\" \",2)","v":2},null,null,0,null,null,{"$f":"IFERROR(IF(A23<($C$13+1),$C$15*D23,\" \"),\"\")","v":""}]
[{"$f":"IF($C$13<3,\" \",3)","v":3},null,null,0,null,null,""]
[{"$f":"IF($C$13<4,\" \",4)","v":4},null,null,0,null,null,""]
[{"$f":"IF($C$13<5,\" \",5)","v":5},null,null,0,null,null,""]
[{"$f":"IF($C$13<6,\" \",6)","v":6},null,null,0,null,null,""]
[{"$f":"IF($C$13<7,\" \",7)","v":7},null,null,0,null,null,""]
[{"$f":"IF($C$13<8,\" \",8)","v":8},null,null,0,null,null,""]
[{"$f":"IF($C$13<9,\" \",9)","v":9},null,null,0,null,null,""]
[{"$f":"IF($C$13<10,\" \",10)","v":10},null,null,0,null,null,""]
[{"$f":"IF($C$13<11,\" \",11)","v":11},null,null,0,null,null,""]
[{"$f":"IF($C$13<12,\" \",12)","v":12},null,null,0,null,null,{"$f":"IFERROR(IF(A33<($C$13+1),$C$15*D33,\" \"),\"\")","v":""}]
[{"$f":"IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),\"\",\"SUMATORIA ENCUENTROS\")","v":"SUMATORIA ENCUENTROS"},null,null,{"$f":"IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),\"\",12-(SUM(COUNTIF(D22:F33,0),COUNTIF(D22:F33,\"\"))-24))","v":0},"VALOR A FACTURAR",null,null,{"$f":"IFERROR(IF(OR(C6=\"Alistamiento\",C6=\"Cierre\"),(C17*C15),(SUM(G22,G23,G24,G25,G26,G27,G28,G29,G30,G31,G32,G33))),\"\")","v":0}]
["La presente certificación se expide a los__________días del mes de_________________del año ___________"]
["                                                                                                    "]
["NOMBRE Y FIRMA DEL REPRESENTANTE LEGAL DEL CONTRATO"]

{"sheet":"Convenciones","index":4,"n_rows":31,"n_cols":1,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,0,5,5],[6,0,6,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[10,0,10,5],[11,0,11,5],[12,0,12,5],[30,0,30,5],[31,0,32,5],[29,0,29,5],[22,0,22,5],[23,0,23,5],[24,0,24,5],[25,0,25,5],[26,0,26,5],[27,0,27,5],[28,0,28,5],[17,0,17,5],[18,0,18,5],[19,0,19,5],[20,0,20,5],[21,0,21,5]]}
["CERTIFICADO SUPERVISOR"]
["Mes certificación: Seleccione el mes que corresponda"]
["Regional: Seleccione el nombre de la Regional"]
["Etapa: Seleccione la etapa a certificar"]
["Valor Inicial del Contrato: Registre el valor Inicial del Contrato"]
["Reducciones al Contrato: Registre las reducciones realizadas al contrato"]
["Adiciones al Contrato: Registre las adiciones realizadas al contrato "]
["Valor Total del Contrato: La matriz calcula el valor total del contrato"]
["Mes de Ejecución: Seleccione el mes de ejecucion"]
["Cupos Contratados: Registre el numero de cupos que se contrataron"]
["Grupos  Constituidos : Registre el numero de grupos constituidos"]
["Número de niñas y niños atendidos: Registre el numero de niñas y niños que participaron en cada encuentro vivencial. NO puede ser mayor al numero de cupos contratados según columna A20; en caso de que sea mayor la celda se tornará de COLOR ROJO lo que indica que debe corregir la cifra"]
["Sumatoria Encuentros: La matriz determina automáticamente la SUMATORIA de los encuentros vivenciales realizados"]
["Valor a Facturar: La matriz determina automáticamente el VALOR A FACTURAR en el periodo"]
["fecha que se suscribe la certificación: Registre la fecha de expedición del Certificado"]
["Nombre y Firma: Registre el NOMBRE Y FIRMA del Supervisor del Contrato"]
["Nota 1: Es responsabilidad del contratista la validación de las cifras, así como la verificación y manipulación de las formulas"]
[]
["CERTIFICADO OPERADOR"]
["Mes certificación: Seleccione el mes que corresponda"]
["Regional: Seleccione el nombre de la Regional"]
["Etapa: Seleccione la etapa a certificar"]
["Mes de Ejecución: Seleccione el mes de ejecucion"]
["Cupos Contratados: Registre el numero de cupos que se contrataron"]
["Grupos  Constituidos : Registre el numero de grupos constituidos"]
["Número de niñas y niños atendidos: Registre el numero de niñas y niños que participaron en cada encuentro vivencial. NO puede ser mayor al numero de cupos contratados según columna A20; en caso de que sea mayor la celda se tornará de COLOR ROJO lo que indica que debe corregir la cifra"]
["Sumatoria Encuentros: La matriz determina automáticamente la SUMATORIA de los encuentros vivenciales realizados"]
["Valor a Facturar: La matriz determina automáticamente el VALOR A FACTURAR en el periodo"]
["fecha que se suscribe la certificación: Registre la fecha de expedición del Certificado"]
["Nombre y Firma: Registre el NOMBRE Y FIRMA del Supervisor del Contrato"]
["Nota 1: Es responsabilidad del contratista la validación de las cifras, así como la verificación y manipulación de las formulas"]

{"sheet":"RESUMEN_REGIONAL_UNIDAD_MEDIDA","index":5,"n_rows":43,"n_cols":5,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,1,1,3],[3,1,3,4],[4,2,4,4],[6,1,6,4]]}
[]
[null,"INSTITUTO COLOMBIANO DE BIENESTAR FAMILIAR\nCecilia De la Fuente de Lleras \nDirección de Abastecimiento",null,null,"Clasificación de Información:\n Pública"]
[]
[null,"ESTUDIO DE COSTOS MODELO"]
[null,"Denominación del Bien o Servicio","El programa Generaciones Étnicas con Bienestar tiene como propósito promover la protección integral y proyectos de vida de las niñas y los niños entre los 6 y los 13 años, 11 meses y 29 días que pertenezcan o se autorreconozcan como parte de una comunidad étnica, a partir de su empoderamiento como sujetos de derechos y del fortalecimiento de la corresponsabilidad de la familia, la sociedad y el Estado, propiciando la consolidación de entornos protectores para ellas y ellos. "]
[]
[null,"RESUMEN DE COSTOS POR UNIDAD DE MEDIDA POR REGIONAL - VIGENCIA 2021"]
[]
[null,"TIEMPO","Por el total de la etapa","Por mes","Por el total de la etapa"]
[null,"COSTO NIÑA O NIÑO","Focalizado en la etapa de alistamiento por regional","Atendido en la etapa de atención por regional","Atendido en la etapa de cierre por regional"]
[null,"AMAZONAS",21303,82965,19934]
[null,"ANTIOQUIA",20754,81492,19522]
[null,"ARAUCA",21735,82938,20374]
[null,"ATLANTICO",22316,83845,20925]
[null,"BOGOTA",25294,89220,23620]
[null,"BOLIVAR",20700,81099,19429]
[null,"BOYACA",46142,127307,42487]
[null,"CALDAS",21125,81782,19847]
[null,"CAQUETA",25294,89317,23620]
[null,"CASANARE",22059,83654,20767]
[null,"CAUCA",21258,82300,19956]
[null,"CESAR",21392,82175,20066]
[null,"CHOCO",21088,82255,19808]
[null,"CORDOBA",21125,81799,19847]
[null,"GUAINÍ\u008dA",23143,86118,21604]
[null,"GUAVIARE",22694,84584,21158]
[null,"HUILA",32244,102008,29909]
[null,"LA GUAJIRA",22123,83550,20713]
[null,"MAGDALENA",20097,80012,18952]
[null,"META",21866,83708,20430]
[null,"NARIÑO",21434,82675,20127]
[null,"NORTE DE SANTANDER",21357,82183,20015]
[null,"PUTUMAYO",21125,81885,19847]
[null,"QUINDIO",26981,92090,25023]
[null,"RISARALDA",20661,80910,19428]
[null,"SAN ANDRES",22316,84036,20925]
[null,"SANTANDER",25294,89359,23620]
[null,"SUCRE",21666,82614,20290]
[null,"TOLIMA",22046,83475,20628]
[null,"VALLE DEL CAUCA",21434,82377,20127]
[null,"VAUPES",21158,83821,19934]
[null,"VICHADA",23274,93718,21669]
[null,"COSTO NIÑA O NIÑO PROMEDIO PONDERADO NACIONAL",21566,82928,20232]