{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CUPOS PROGRAMADOS 2018","LISTAS","Costos","Certificación Supervisor","Certificación Operador","Convenciones"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":46,"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":61,"n_cols":39,"rows_kept":61,"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,"mes","Alistamiento",null,null,null,null,"Generaciones Étnicas con Bienestar",null,null,null,null,null,"ZONAS DE CONTRATACIÓN","ZONA"]
[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,null,1,null,null,null,"Tradicional",8,null,"Enero","Atención",1,{"$f":"+P5/7","v":10231.857142857143},{"$f":"+AC5*6.5","v":66507.071428571435},null,"Programa para la Promoción del Desarrollo de niñas y niños ",null,null,null,null,null,"AMAZONAS",1]
[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,null,2,null,null,null,"Rural",12,null,"Febrero","Cierre",2,null,null,null,null,null,null,null,null,null,"ANTIOQUIA",1]
[81,"ARAUCA","ARAUCA",null,null,null,null,null,null,null,null,"ARAUCAEtnico","ARAUCA","Etnico",2400,89574,null,null,3,null,null,null,"Etnico",12,null,"Marzo",null,3,null,null,null,null,null,null,null,null,null,"ANTIOQUIA",2]
[8,"ATLÁNTICO","ATLÁNTICO",null,null,null,null,null,null,null,null,"ATLÁNTICOEtnico","ATLÁNTICO","Etnico",800,50104,null,null,4,null,null,null,"Tradicional",8,null,"Abril",null,4,null,null,null,null,null,null,null,null,null,"ANTIOQUIA","AP"]
[11,"BOGOTÁ","BOGOTÁ",null,null,null,null,null,null,null,null,"BOGOTÁEtnico","BOGOTÁ","Etnico",500,50379,null,null,5,null,null,null,"Rural",12,null,"Mayo",null,5,null,null,null,null,null,null,null,null,null,"ARAUCA",1]
[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,null,"Junio",null,null,null,null,null,null,null,null,null,null,null,"ARAUCA","AP"]
[15,"BOYACÁ","BOYACÁ",null,null,null,null,null,null,null,null,"BOYACÁEtnico","BOYACÁ","Etnico",100,59492,null,null,7,null,null,null,null,null,null,"Julio",null,null,null,null,null,null,null,null,null,null,null,"SAN ANDRÉS",1]
[17,"CALDAS","CALDAS",null,null,null,null,null,null,null,null,"CALDASEtnico","CALDAS","Etnico",2700,50742,null,null,8,null,null,null,null,null,null,"Agosto",null,null,null,null,null,null,null,null,null,null,null,"ATLÁNTICO",1]
[18,"CAQUETÁ","CAQUETÁ",null,null,null,null,null,null,null,null,"CAQUETÁEtnico","CAQUETÁ","Etnico",450,55227,null,null,9,null,null,null,"Tradicional",null,null,"Septiembre",null,null,null,null,null,null,null,null,null,null,null,"ATLÁNTICO",2]
[85,"CASANARE","CASANARE",null,null,null,null,null,null,null,null,"CASANAREEtnico","CASANARE","Etnico",800,74250,null,null,10,null,null,null,"Rural",null,null,"Octubre",null,null,null,null,null,null,null,null,null,null,null,"BOGOTÁ",1]
[19,"CAUCA","CAUCA",null,null,null,null,null,null,null,null,"CAUCAEtnico","CAUCA","Etnico",5000,71001,null,null,11,null,null,null,"Etnico",null,null,"Noviembre",null,null,null,null,null,null,null,null,null,null,null,"BOLÍVAR",1]
[20,"CESAR","CESAR",null,null,null,null,null,null,null,null,"CESAREtnico","CESAR","Etnico",2600,54291,null,null,12,null,null,null,null,null,null,"Diciembre",null,null,null,null,null,null,null,null,null,null,null,"BOLÍVAR",2]
[27,"CHOCÓ","CHOCÓ",null,null,null,null,null,null,null,null,"CHOCÓEtnico","CHOCÓ","Etnico",11150,67347,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOLÍVAR","AP"]
[23,"CÓRDOBA","CÓRDOBA",null,null,null,null,null,null,null,null,"CÓRDOBAEtnico","CÓRDOBA","Etnico",4100,73368,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOYACÁ",1]
[25,"CUNDINAMARCA","CUNDINAMARCA",null,null,null,null,null,null,null,null,"CUNDINAMARCAEtnico","CUNDINAMARCA","Etnico",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOYACÁ",2]
[94,"GUAINÍA","GUAINÍA",null,null,null,null,null,null,null,null,"GUAINÍAEtnico","GUAINÍA","Etnico",900,82564,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALDAS",1]
[95,"GUAVIARE","GUAVIARE",null,null,null,null,null,null,null,null,"GUAVIAREEtnico","GUAVIARE","Etnico",1125,79059,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAQUETÁ",1]
[41,"HUILA","HUILA",null,null,null,null,null,null,null,null,"HUILAEtnico","HUILA","Etnico",300,57784,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAQUETÁ","AP"]
[44,"LA GUAJIRA","LA GUAJIRA",null,null,null,null,null,null,null,null,"LA GUAJIRAEtnico","LA GUAJIRA","Etnico",3150,53574,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CASANARE",1]
[47,"MAGDALENA","MAGDALENA",null,null,null,null,null,null,null,null,"MAGDALENAEtnico","MAGDALENA","Etnico",1700,52804,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAUCA",1]
[50,"META","META",null,null,null,null,null,null,null,null,"METAEtnico","META","Etnico",1375,61348,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAUCA",2]
[52,"NARIÑO","NARIÑO",null,null,null,null,null,null,null,null,"NARIÑOEtnico","NARIÑO","Etnico",4600,64423,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CAUCA","AP"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CESAR",1]
[86,"PUTUMAYO","PUTUMAYO",null,null,null,null,null,null,null,null,"PUTUMAYOEtnico","PUTUMAYO","Etnico",2550,72414,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CESAR","AP"]
[63,"QUINDÍO","QUINDÍO",null,null,null,null,null,null,null,null,"QUINDÍOEtnico","QUINDÍO","Etnico",450,59238,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHOCÓ",1]
[66,"RISARALDA","RISARALDA",null,null,null,null,null,null,null,null,"RISARALDAEtnico","RISARALDA","Etnico",1600,53991,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CHOCÓ","AP"]
[88,"SAN ANDRÉS","SAN ANDRÉS",null,null,null,null,null,null,null,null,"SAN ANDRÉSEtnico","SAN ANDRÉS","Etnico",900,58613,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÓRDOBA",1]
[68,"SANTANDER","SANTANDER",null,null,null,null,null,null,null,null,"SANTANDEREtnico","SANTANDER","Etnico",400,66684,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÓRDOBA",2]
[70,"SUCRE","SUCRE",null,null,null,null,null,null,null,null,"SUCREEtnico","SUCRE","Etnico",1200,53037,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CÓRDOBA","AP"]
[73,"TOLIMA","TOLIMA",null,null,null,null,null,null,null,null,"TOLIMAEtnico","TOLIMA","Etnico",1125,55034,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CUNDINAMARCA",1]
[76,"VALLE DEL CAUCA","VALLE DEL CAUCA",null,null,null,null,null,null,null,null,"VALLE DEL CAUCAEtnico","VALLE DEL CAUCA","Etnico",4450,54759,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUAINÍA",1]
[97,"VAUPÉS","VAUPÉS",null,null,null,null,null,null,null,null,"VAUPÉSEtnico","VAUPÉS","Etnico",1100,80265,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GUAVIARE",1]
[99,"VICHADA","VICHADA",null,null,null,null,null,null,null,null,"VICHADAEtnico","VICHADA","Etnico",975,75742,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HUILA",1]
[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},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA GUAJIRA",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LA GUAJIRA","AP"]
[null,"Zona",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAGDALENA",1]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAGDALENA",2]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",1]
[null,"AP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"META",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NARIÑO",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NARIÑO",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NARIÑO","AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTE DE SANTANDER",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTE DE SANTANDER",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NORTE DE SANTANDER","AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PUTUMAYO",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUINDÍO",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RISARALDA",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANTANDER",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SANTANDER",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SUCRE",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOLIMA",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOLIMA",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALLE DEL CAUCA",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALLE DEL CAUCA",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VAUPÉS",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VICHADA",1]

{"sheet":"Costos","index":2,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":true,"merged":[[62,1,62,3],[63,1,63,3],[64,1,64,3],[66,1,66,5],[67,1,67,5],[61,1,61,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[56,1,56,3],[57,1,57,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[49,1,49,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[48,1,48,3],[37,1,37,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[25,1,25,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[13,1,13,3],[1,1,1,10],[1,11,1,12],[3,1,3,12],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
[]
[null,"INSTITUTO COLOMBIANO DE BIENESTAR FAMILIAR\nCecilia De la Fuente de Lleras \nDirección de Abastecimiento",null,null,null,null,null,null,null,null,null,"Clasificación de Información:\n Clasificada"]
[]
[null,"RESUMEN DE COSTOS POR ZONAS DE CONTRATACIÓN "]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"ZONAS DE CONTRATACIÓN",null,null,"ZONA","META SOCIAL TOTAL ","COSTO TOTAL ETAPA 1","COSTO TOTAL ETAPA 2","COSTO TOTAL ETAPA 3","TOTAL POR REGIONAL ","COSTO NIÑA O NIÑO FOCALIZADO POR REGIONAL  ETAPA 1","COSTO CUPO POR NIÑO POR MES POR REGIONAL ETAPA 2","COSTO CUPO POR NIÑO ATENDIDO POR REGIONAL. ETAPA 3"]
[1,"AMAZONAS_1",null,null,1,800,0,679610800,40604000,720214800,0,154457,50755]
[2,"ANTIOQUIA_1",null,null,1,3200,0,2561275212,139356800,2700632012,0,145527,43549]
[3,"ANTIOQUIA_2",null,null,2,3200,0,2561134406,139516800,2700651206,0,145519,43599]
[4,"ANTIOQUIA_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[5,"ARAUCA_1",null,null,1,1600,0,1314992801,74798400,1389791201,0,149431,46749]
[6,"ARAUCA_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[7,"SAN ANDRÉS_1",null,null,1,1600,0,1305180800,81948800,1387129600,0,148316,51218]
[8,"ATLÁNTICO_1",null,null,1,2400,0,1931041200,108352800,2039394000,0,146291,45147]
[9,"ATLÁNTICO_2",null,null,2,1600,0,1305383200,73329600,1378712800,0,148339,45831]
[10,"BOGOTÁ_1",null,null,1,1600,0,1305180800,81948800,1387129600,0,148316,51218]
[11,"BOLÍVAR_1",null,null,1,1600,0,1312740000,72179200,1384919200,0,149175,45112]
[12,"BOLÍVAR_2",null,null,2,2400,0,1941970800,106053600,2048024400,0,147119,44189]
[13,"BOLÍVAR_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[14,"BOYACÁ_1",null,null,1,1600,0,1330956001,73980800,1404936801,0,151245,46238]
[15,"BOYACÁ_2",null,null,2,1600,0,1307002402,71979200,1378981602,0,148523,44987]
[16,"CALDAS_1",null,null,1,2400,0,1932915601,105888000,2038803601,0,146433,44120]
[17,"CAQUETÁ_1",null,null,1,1600,0,1307037600,73390400,1380428000,0,148527,45869]
[18,"CAQUETÁ_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[19,"CASANARE_1",null,null,1,1600,0,1306624000,72096000,1378720000,0,148480,45060]
[20,"CAUCA_1",null,null,1,2400,0,1935027600,106956000,2041983600,0,146593,44565]
[21,"CAUCA_2",null,null,2,3200,0,2562032000,145590400,2707622400,0,145570,45497]
[22,"CAUCA_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[23,"CESAR_1",null,null,1,2400,0,1933839600,106464000,2040303600,0,146503,44360]
[24,"CESAR_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[25,"CHOCÓ_1",null,null,1,3200,0,2568579200,141321600,2709900800,0,145942,44163]
[26,"CHOCÓ_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[27,"CÓRDOBA_1",null,null,1,3200,0,2558652800,142963200,2701616000,0,145378,44676]
[28,"CÓRDOBA_2",null,null,2,1600,0,1306351200,73000000,1379351200,0,148449,45625]
[29,"CÓRDOBA_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[30,"CUNDINAMARCA_1",null,null,1,2400,0,1932480000,105520800,2038000800,0,146400,43967]
[31,"GUAINÍA_1",null,null,1,800,0,679610800,40604000,720214800,0,154457,50755]
[32,"GUAVIARE_1",null,null,1,1600,0,1308076000,75464000,1383540000,0,148645,47165]
[33,"HUILA_1",null,null,1,3200,0,2560166400,139638400,2699804800,0,145464,43637]
[34,"LA GUAJIRA_1",null,null,1,2400,0,1932955200,108434400,2041389600,0,146436,45181]
[35,"LA GUAJIRA_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[36,"MAGDALENA_1",null,null,1,4000,0,3187954002,181928000,3369882002,0,144907,45482]
[37,"MAGDALENA_2",null,null,2,2400,0,1934380800,107613600,2041994400,0,146544,44839]
[38,"META_1",null,null,1,1600,0,1308076003,72897600,1380973603,0,148645,45561]
[39,"META_2",null,null,2,1600,0,1308058403,72096000,1380154403,0,148643,45060]
[40,"NARIÑO_1",null,null,1,3200,0,2562630400,140521600,2703152000,0,145604,43913]
[41,"NARIÑO_2",null,null,2,2400,0,1935582000,105972000,2041554000,0,146635,44155]
[42,"NARIÑO_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[43,"NORTE DE SANTANDER_1",null,null,1,2400,0,1933707604,107488800,2041196404,0,146493,44787]
[44,"NORTE DE SANTANDER_2",null,null,2,1600,0,1307134400,73513600,1380648000,0,148538,45946]
[45,"NORTE DE SANTANDER_AP",null,null,"AP",0,0,0,0,0,0,0,0]
[46,"PUTUMAYO_1",null,null,1,2400,0,1934222400,107059200,2041281600,0,146532,44608]
[47,"QUINDÍO_1",null,null,1,2400,0,1930909206,108763200,2039672406,0,146281,45318]
[48,"RISARALDA_1",null,null,1,2400,0,1931516400,107203200,2038719600,0,146327,44668]
[49,"SANTANDER_1",null,null,1,2400,0,1933628400,105828000,2039456400,0,146487,44095]
[50,"SANTANDER_2",null,null,2,2400,0,1933562400,106216800,2039779200,0,146482,44257]
[51,"SUCRE_1",null,null,1,2400,0,1932123600,106053600,2038177200,0,146373,44189]
[52,"TOLIMA_1",null,null,1,1600,0,1306808803,72076800,1378885603,0,148501,45048]
[53,"TOLIMA_2",null,null,2,1600,0,1306914406,71870400,1378784806,0,148513,44919]
[54,"VALLE DEL CAUCA_1",null,null,1,2400,0,1933298400,105806400,2039104800,0,146462,44086]
[55,"VALLE DEL CAUCA_2",null,null,2,1600,0,1306861600,73041600,1379903200,0,148507,45651]
[56,"VAUPÉS_1",null,null,1,800,0,695125200,38963200,734088400,0,157983,48704]
[57,"VICHADA_1",null,null,1,800,0,710318400,38880800,749199200,0,156734,47185]
[null,"TOTAL",null,null,null,97600,null,79013629250,4405174400,83418803650]
[null,"Controles",null,null,null,null,0,0,0,6.866455078125E-5]
[]
[null,"VALOR TOTAL ATENCIÓN PRIORIZADA",null,null,null,null,0,0,0,0]
[null,"VALOR TOTAL BANCO DE OFERENTES",null,null,null,null,0,0,0,0]

{"sheet":"Certificación Supervisor","index":3,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,0,2,4],[3,1,3,6],[4,0,4,1],[4,2,4,7],[30,0,30,7],[36,0,36,7],[40,0,40,7],[11,0,11,7],[12,0,12,1],[12,2,12,7],[5,0,5,1],[6,0,6,1],[16,0,16,1],[16,2,16,7],[18,0,18,1],[24,0,24,2],[24,3,24,5],[24,6,24,7],[25,0,25,2],[25,3,25,5],[25,6,25,7],[20,0,21,2],[23,0,23,2],[23,3,23,5],[23,6,23,7],[28,0,28,2],[28,3,28,5],[28,6,28,7],[29,0,29,2],[29,3,29,5],[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],[33,0,33,2],[33,3,33,5],[33,6,33,7],[34,0,34,2],[34,3,34,5],[34,6,34,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],[38,0,38,2],[38,3,38,5],[38,6,38,7],[39,0,39,2],[39,3,39,5],[39,6,39,7],[35,0,35,2],[35,3,35,5],[35,6,35,7],[37,0,37,2],[37,3,37,5],[37,6,37,7],[43,0,43,2],[43,3,43,5],[43,6,43,7],[44,0,44,2],[44,3,44,5],[44,6,44,7],[41,0,41,2],[41,3,41,5],[41,6,41,7],[42,0,42,2],[42,3,42,5],[42,6,42,7],[47,0,47,2],[47,3,47,5],[47,6,47,7],[49,0,49,2],[49,3,49,5],[49,6,49,7],[45,0,45,2],[45,3,45,5],[45,6,45,7],[46,0,46,2],[46,3,46,5],[46,6,46,7],[48,0,48,7],[51,0,51,2],[51,4,51,6],[52,0,52,7],[53,0,53,7],[54,0,54,7],[55,0,57,7],[50,0,50,2],[50,3,50,5],[50,6,50,7],[2,5,2,6],[5,2,5,7],[6,2,6,7],[7,0,7,3],[7,4,7,7],[8,0,8,3],[8,4,8,7],[17,0,17,1],[22,0,22,7],[17,2,17,7],[18,2,18,7],[19,0,19,1],[19,2,19,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],[20,3,21,5],[20,6,21,7]]}
["Nombre del Operador:"]
["Numero de contrato :"]
["                                                                                                  CERTIFICACION DE COBERTURA (Corresponde al Supervisor)                                                                                                      ",null,null,null,null,"Mes de Certificación: "]
[{"$f":"IF(C7=\"Alistamiento\",10,IF(C7=\"Atención\",11,IF(C7=\"Cierre\",12,\"\")))","v":""}]
["Regional:"]
["Zona:"]
["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":"B11-D11+F11","v":0}]
["CERTIFICA:"]
["Mes de Ejecución"]
["Encuentro a realizar * mes",null,{"$f":"IF(C5=\"\",\"\",13)","v":""}]
["Valor Cupo Mensual según etapa",null,{"$f":"IFERROR(VLOOKUP(C5&\"_\"&C6,costos_mod,A4,0),\"\")","v":""}]
["Valor Unitario Encuentro",null,{"$f":"IFERROR(IF(C7=\"Alistamiento\",C15,IF(C7=\"Atención\",C15/13,IF(C7=\"Cierre\",C15,\"\"))),\"\")","v":""}]
["Cupos Contratados "]
[{"$f":"IF(C7=\"\",\"\",IF(C7=\"Alistamiento\",\"Cupos Focalizados\",IF(C7=\"Cierre\",\"Participantes actividad\",IF(C7=\"Atención\",\"Niñas y Niños atendidos\"))))","v":""}]
["Proyección Grupos Contratados",null,{"$f":"C17/25","v":0}]
["Grupos  Constituidos"]
["# ENCUENTRO EN EL MES DE OPERACIÓN",null,null,"Número de niñas y niños que participaron en cada Encuentro",null,null,"Subtotales por Encuentro"]
[]
["Encuentros Lectura de Contexto"]
[{"$f":"IF($C$14<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A24<($C$14+1),$C$16*D24,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<2,\" \",2)","v":2},null,null,0,null,null,""]
[{"$f":"IF($C$14<3,\" \",3)","v":3},null,null,0,null,null,""]
[{"$f":"IF($C$14<4,\" \",4)","v":4},null,null,0,null,null,""]
[5,null,null,0,null,null,""]
[6,null,null,0,null,null,""]
["Subtotal de asistencias y recurso ejecutado - encuentros de Lectura de Contexto",null,null,{"$f":"SUBTOTAL(9,D24:F29)","v":0},null,null,{"$f":"SUBTOTAL(9,G24:H29)","v":0}]
["Encuentros de fortalecimiento de habilidades del siglo XXI"]
[{"$f":"IF($C$14<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A32<($C$14+1),$C$16*D32,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<2,\" \",2)","v":2},null,null,0,null,null,{"$f":"IFERROR(IF(A33<($C$14+1),$C$16*D33,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<3,\" \",3)","v":3},null,null,0,null,null,{"$f":"IFERROR(IF(A34<($C$14+1),$C$16*D34,\" \"),\"\")","v":""}]
[4,null,null,0,null,null,{"$f":"IFERROR(IF(A35<($C$14+1),$C$16*D35,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros de fortalecimiento de habilidades del siglo XXI",null,null,{"$f":"SUBTOTAL(9,D32:F35)","v":0},null,null,{"$f":"SUBTOTAL(9,G32:H35)","v":0}]
["Encuentros de prevención de riesgos específicos"]
[5,null,null,0,null,null,{"$f":"IFERROR(IF(A38<($C$14+1),$C$16*D38,\" \"),\"\")","v":""}]
[6,null,null,0,null,null,{"$f":"IFERROR(IF(A39<($C$14+1),$C$16*D39,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros  de prevención de riesgos específicos",null,null,{"$f":"SUBTOTAL(9,D38:F39)","v":0},null,null,{"$f":"SUBTOTAL(9,G38:H39)","v":0}]
["Encuentros de núcleo de desarrollo"]
[7,null,null,0,null,null,{"$f":"IFERROR(IF(A42<($C$14+1),$C$16*D42,\" \"),\"\")","v":""}]
[8,null,null,0,null,null,""]
[9,null,null,0,null,null,""]
[10,null,null,0,null,null,""]
[11,null,null,0,null,null,""]
[12,null,null,0,null,null,""]
["Subtotal de asistencias y recurso ejecutado - encuentros  de núcleo de desarrollo",null,null,{"$f":"SUBTOTAL(9,D42:F47)","v":0},null,null,{"$f":"SUBTOTAL(9,G42:H47)","v":0}]
["Encuentros Intergeneracionales"]
[13,null,null,0,null,null,{"$f":"IFERROR(IF(A50<($C$14+1),$C$16*D50,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros  Intergeneracionales",null,null,{"$f":"SUBTOTAL(9,D50)","v":0},null,null,{"$f":"SUBTOTAL(9,G50)","v":0}]
[{"$f":"IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),\"\",\"SUMATORIA ENCUENTROS\")","v":"SUMATORIA ENCUENTROS"},null,null,{"$f":"IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),\"\",13-(SUM(COUNTIF(D32:F35,0),COUNTIF(D32:F35,\"\"),COUNTIF(D38:F39,0),COUNTIF(D38:F39,\"\"),COUNTIF(D42:F47,0),COUNTIF(D42:F47,\"\"),COUNTIF(D50,0),COUNTIF(D50,\"\"))-24))","v":0},"VALOR A FACTURAR",null,null,{"$f":"IFERROR(IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),(C18*C16),IF(C7=\"Atención\",SUM(G30,G36,G40,G48,G51),\"\")),\"\")","v":""}]
["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":4,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,7],[1,1,1,7],[2,0,2,4],[3,1,3,6],[4,0,4,1],[4,2,4,7],[8,0,8,3],[8,4,8,7],[11,0,11,7],[2,5,2,6],[12,0,12,1],[12,2,12,7],[5,0,5,1],[5,2,5,7],[6,0,6,1],[6,2,6,7],[7,0,7,3],[7,4,7,7],[16,0,16,1],[16,2,16,7],[17,0,17,1],[17,2,17,7],[18,0,18,1],[18,2,18,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],[23,0,23,2],[23,3,23,5],[23,6,23,7],[24,0,24,2],[24,3,24,5],[24,6,24,7],[19,0,19,1],[19,2,19,7],[20,0,21,2],[20,3,21,5],[20,6,21,7],[22,0,22,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],[32,0,32,2],[32,3,32,5],[32,6,32,7],[33,0,33,2],[33,3,33,5],[33,6,33,7],[29,0,29,2],[29,3,29,5],[29,6,29,7],[30,0,30,7],[31,0,31,2],[31,3,31,5],[31,6,31,7],[36,0,36,7],[37,0,37,2],[37,3,37,5],[37,6,37,7],[38,0,38,2],[38,3,38,5],[38,6,38,7],[34,0,34,2],[34,3,34,5],[34,6,34,7],[35,0,35,2],[35,3,35,5],[35,6,35,7],[42,0,42,2],[42,3,42,5],[42,6,42,7],[43,0,43,2],[43,3,43,5],[43,6,43,7],[39,0,39,2],[39,3,39,5],[39,6,39,7],[40,0,40,7],[41,0,41,2],[41,3,41,5],[41,6,41,7],[46,0,46,2],[46,3,46,5],[46,6,46,7],[47,0,47,2],[47,3,47,5],[47,6,47,7],[44,0,44,2],[44,3,44,5],[44,6,44,7],[45,0,45,2],[45,3,45,5],[45,6,45,7],[51,0,51,2],[51,4,51,6],[52,0,52,7],[53,0,53,7],[54,0,54,7],[55,0,57,7],[48,0,48,7],[49,0,49,2],[49,3,49,5],[49,6,49,7],[50,0,50,2],[50,3,50,5],[50,6,50,7]]}
["Nombre del Operador:"]
["Numero de contrato :"]
["CERTIFICACIÓN DE COBERTURA (Corresponde al Operador)",null,null,null,null,"Mes de Certificación: "]
[{"$f":"IF(C7=\"Alistamiento\",10,IF(C7=\"Atención\",11,IF(C7=\"Cierre\",12,\"\")))","v":""}]
["Regional:"]
["Zona:"]
["Etapa:"]
["El suscrito representante legal:"]
["Cédula de ciudadanía:"]
[]
["Valor Inicial del Contrato:",null,"Reducciones al contrato: ",null,"Adiciones al Contrato: ",null,"Valor Total del Contrato:",{"$f":"B11-D11+F11","v":0}]
["CERTIFICA:"]
["Mes de Ejecución"]
["Encuentro a realizar * mes",null,{"$f":"IF(C5=\"\",\"\",13)","v":""}]
["Valor Cupo Mensual según etapa",null,{"$f":"IFERROR(VLOOKUP(C5&\"_\"&C6,costos_mod,A4,0),\"\")","v":""}]
["Valor Unitario Encuentro",null,{"$f":"IFERROR(IF(C7=\"Alistamiento\",C15,IF(C7=\"Atención\",C15/13,IF(C7=\"Cierre\",C15,\"\"))),\"\")","v":""}]
["Cupos Contratados "]
[{"$f":"IF(C7=\"\",\"\",IF(C7=\"Alistamiento\",\"Cupos Focalizados\",IF(C7=\"Cierre\",\"Participantes actividad\",IF(C7=\"Atención\",\"Niñas y Niños atendidos\"))))","v":""}]
["Proyección Grupos Contratados",null,{"$f":"C17/25","v":0}]
["Grupos  Constituidos"]
["# ENCUENTRO EN EL MES DE OPERACIÓN",null,null,"Número de niñas y niños que participaron en cada Encuentro",null,null,"Subtotales por Encuentro"]
[]
["Encuentros Lectura de Contexto"]
[{"$f":"IF($C$14<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A24<($C$14+1),$C$16*D24,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<2,\" \",2)","v":2},null,null,0,null,null,""]
[{"$f":"IF($C$14<3,\" \",3)","v":3},null,null,0,null,null,""]
[{"$f":"IF($C$14<4,\" \",4)","v":4},null,null,0,null,null,""]
[5,null,null,0,null,null,""]
[6,null,null,0,null,null,""]
["Subtotal de asistencias y recurso ejecutado - encuentros de Lectura de Contexto",null,null,{"$f":"SUBTOTAL(9,D24:F29)","v":0},null,null,{"$f":"SUBTOTAL(9,G24:H29)","v":0}]
["Encuentros de fortalecimiento de habilidades del siglo XXI"]
[{"$f":"IF($C$14<1,\" \",1)","v":1},null,null,0,null,null,{"$f":"IFERROR(IF(A32<($C$14+1),$C$16*D32,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<2,\" \",2)","v":2},null,null,0,null,null,{"$f":"IFERROR(IF(A33<($C$14+1),$C$16*D33,\" \"),\"\")","v":""}]
[{"$f":"IF($C$14<3,\" \",3)","v":3},null,null,0,null,null,{"$f":"IFERROR(IF(A34<($C$14+1),$C$16*D34,\" \"),\"\")","v":""}]
[4,null,null,0,null,null,{"$f":"IFERROR(IF(A35<($C$14+1),$C$16*D35,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros de fortalecimiento de habilidades del siglo XXI",null,null,{"$f":"SUBTOTAL(9,D32:F35)","v":0},null,null,{"$f":"SUBTOTAL(9,G32:H35)","v":0}]
["Encuentros de prevención de riesgos específicos"]
[5,null,null,0,null,null,{"$f":"IFERROR(IF(A38<($C$14+1),$C$16*D38,\" \"),\"\")","v":""}]
[6,null,null,0,null,null,{"$f":"IFERROR(IF(A39<($C$14+1),$C$16*D39,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros  de prevención de riesgos específicos",null,null,{"$f":"SUBTOTAL(9,D38:F39)","v":0},null,null,{"$f":"SUBTOTAL(9,G38:H39)","v":0}]
["Encuentros de núcleo de desarrollo"]
[7,null,null,0,null,null,{"$f":"IFERROR(IF(A42<($C$14+1),$C$16*D42,\" \"),\"\")","v":""}]
[8,null,null,0,null,null,""]
[9,null,null,0,null,null,""]
[10,null,null,0,null,null,""]
[11,null,null,0,null,null,""]
[12,null,null,0,null,null,""]
["Subtotal de asistencias y recurso ejecutado - encuentros  de núcleo de desarrollo",null,null,{"$f":"SUBTOTAL(9,D42:F47)","v":0},null,null,{"$f":"SUBTOTAL(9,G42:H47)","v":0}]
["Encuentros Intergeneracionales"]
[13,null,null,0,null,null,{"$f":"IFERROR(IF(A50<($C$14+1),$C$16*D50,\" \"),\"\")","v":""}]
["Subtotal de asistencias y recurso ejecutado - encuentros  Intergeneracionales",null,null,{"$f":"SUBTOTAL(9,D50)","v":0},null,null,{"$f":"SUBTOTAL(9,G50)","v":0}]
[{"$f":"IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),\"\",\"SUMATORIA ENCUENTROS\")","v":"SUMATORIA ENCUENTROS"},null,null,{"$f":"IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),\"\",13-(SUM(COUNTIF(D32:F35,0),COUNTIF(D32:F35,\"\"),COUNTIF(D38:F39,0),COUNTIF(D38:F39,\"\"),COUNTIF(D42:F47,0),COUNTIF(D42:F47,\"\"),COUNTIF(D50,0),COUNTIF(D50,\"\"))-24))","v":0},"VALOR A FACTURAR",null,null,{"$f":"IFERROR(IF(OR(C7=\"Alistamiento\",C7=\"Cierre\"),(C18*C16),IF(C7=\"Atención\",SUM(G30,G36,G40,G48,G51),\"\")),\"\")","v":""}]
["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":5,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[[19,0,19,5],[20,0,20,5],[9,0,9,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[4,0,4,5],[6,0,6,5],[7,0,7,5],[8,0,8,5],[3,0,3,5],[5,0,5,5],[21,0,21,5],[27,0,27,5],[34,0,34,5],[10,0,10,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[18,0,18,5],[32,0,32,5],[33,0,33,5],[31,0,31,5],[25,0,25,5],[28,0,28,5],[29,0,29,5],[30,0,30,5],[26,0,26,5],[22,0,22,5],[23,0,23,5],[24,0,24,5]]}
["CERTIFICADO SUPERVISOR"]
["Mes certificación: Seleccione el mes que corresponda"]
["Regional: Seleccione el nombre de la Regional"]
["Zona: Seleccionar la zona a certificar"]
["Etapa: Seleccione la etapa a certificar"]
["El suscrito supervisor y Cédula de ciudadanía: Registre los datos del supervisor"]
["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"]
["Zona: Seleccionar la zona a certificar"]
["Etapa: Seleccione la etapa a certificar"]
["El suscrito supervisor y Cédula de ciudadanía: Registre los datos del supervisor"]
["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"]