2c:null 2d:["$","title",null,{"children":"Sistema de Admisión Escolar | Ernesto Laval | Observable"}] 32:Td35,viewof map = { const target = html`

`; yield target; // Give the container dimensions. // You might have two sets of markers, let's call them markers1 and markers2 const markers1 = [establecimientoSeleccionado].map((d) => [ +d.lon.replace(",", "."), +d.lat.replace(",", ".") ]); const markers2 = postulantesEstablecimientoDetalle.map((d) => [ +d.lon_con_error.replace(",", "."), +d.lat_con_error.replace(",", ".") ]); // Function to create features from coordinates function createFeatures(markers) { return markers.map( (coord) => new ol.Feature({ geometry: new ol.geom.Point(ol.proj.fromLonLat(coord)) }) ); } function createVectorLayer(features, fillColor, shapeType) { let style; switch (shapeType) { case "diamond": style = new ol.style.Style({ image: new ol.style.RegularShape({ fill: new ol.style.Fill({ color: fillColor }), stroke: new ol.style.Stroke({ color: "grey", width: 1 }), points: 4, radius: 10, angle: Math.PI / 2 // Rotate 45 degrees to make it a diamond shape }) }); break; case "square": style = new ol.style.Style({ image: new ol.style.RegularShape({ fill: new ol.style.Fill({ color: fillColor }), stroke: new ol.style.Stroke({ color: "grey", width: 1 }), points: 4, radius: 10, angle: Math.PI / 4 // Rotate 45 degrees to make it a square shape }) }); break; case "star": style = new ol.style.Style({ image: new ol.style.RegularShape({ fill: new ol.style.Fill({ color: fillColor }), stroke: new ol.style.Stroke({ color: "grey", width: 1 }), points: 5, radius: 10, radius2: 3, angle: 0 }) }); break; case "dot": style = new ol.style.Style({ image: new ol.style.Circle({ radius: 3, fill: new ol.style.Fill({ color: fillColor }), stroke: new ol.style.Stroke({ color: "grey", width: 0 }) }) }); break; // add more cases for different shapes default: // Keep the default circle style style = new ol.style.Style({ image: new ol.style.Circle({ radius: 6, fill: new ol.style.Fill({ color: fillColor }), stroke: new ol.style.Stroke({ color: "grey", width: 1 }) }) }); } return new ol.layer.Vector({ source: new ol.source.Vector({ features }), style: style }); } // Creating two sets of features and vector layers with different styles const features1 = createFeatures(markers1); const features2 = createFeatures(markers2); const vectorLayer1 = createVectorLayer(features1, "yellow", "star"); const vectorLayer2 = createVectorLayer(features2, "blue", "dot"); const map = (target.value = new ol.Map({ layers: [ new ol.layer.Tile({ source: new ol.source.OSM() }), vectorLayer2, vectorLayer1 ], target, view: new ol.View({ center: ol.proj.fromLonLat(markers1[0]), zoom: 13 }) })); invalidation.then(() => map.dispose()); return target; }33:T6d5,## Resultados La asignación de vacantes considera 2 etapas (regular y complementaria). En la etapa regular se asignan vacantes y los postulantes pueden responder aceptando, rechazando y/o aceptar condicional a obtener un cupo en una lista de estara en otra postulación ### Etapa regular **${admitidosEtapaRegularQueAceptaAsignacion.length} postulantes** aceptaron la asignación a este establecimiento luego de la asignación inicial y ajustes en listas de espera ${admitidosEtapaRegularInicialmente.length} postulantes fueron admitidos inicialmente ${admitidosEtapaRegularInicialmentePorRespuesta.map(d => ``)}

Postulantes	Respuesta
${d.estudiantes}	${d.respuesta}

#### Luego de correr las listas de espera ${admitidosEtapaRegularPostRespuestaMantieneAsignacion.length} de los que aceptaron esperando por si corría la lista de esprea, mantuvieron su asignación en este establecimiento y esta fue su respuesta final: ${admitidosEtapaRegularPostRespuestaMantieneAsignacionPorRespuesta.map(d => ``)}

Postulantes	Respuesta
${d.estudiantes}	${d.respuesta}

${admitidosEtapaRegularPostRespuesta.length} postulantes fueron admitidos al quedar vacantes en la lista de espera en este establecimiento, y esta fue su respuesta final: ${admitidosEtapaRegularPostRespuestaPorRespuesta.map(d => ``)}

Postulantes	Respuesta
${d.estudiantes}	${d.respuesta}

34:T7c3,/*** admitidosQueAceptan ***/ WITH admitidosQueAceptan as (SELECT mrun FROM D1_Resultados_etapa_regular WHERE (CASE WHEN rbd_admitido = ' ' THEN false WHEN rbd_admitido = ${establecimientoSeleccionado.rbd} AND respuesta_postulante = 1 THEN true ELSE false END OR CASE WHEN rbd_admitido_post_resp = ' ' THEN false WHEN rbd_admitido_post_resp = ${establecimientoSeleccionado.rbd} AND respuesta_postulante_post_lista_espera = 1 THEN true ELSE false END) AND cod_nivel = ${nivelSeleccionado.cod_nivel} UNION SELECT mrun FROM D2_Resultados_etapa_complementaria p WHERE CASE WHEN rbd_admitido = ' ' THEN false WHEN rbd_admitido = ${establecimientoSeleccionado.rbd} THEN true ELSE false END AND cod_nivel = ${nivelSeleccionado.cod_nivel}), /*** postulantesNoAsignados ***/ postulantesNoAsignados AS (SELECT mrun FROM C1_Postulaciones_etapa_regular WHERE rbd = ${establecimientoSeleccionado.rbd} AND cod_nivel = ${nivelSeleccionado.cod_nivel} AND mrun NOT IN (SELECT mrun FROM admitidosQueAceptan)), /*** asignacionDefinitiva ***/ asignacionDefinitiva as ( SELECT p.mrun,rbd_admitido as rbd FROM postulantesNoAsignados p INNER JOIN D1_Resultados_etapa_regular r ON p.mrun = r.mrun WHERE respuesta_postulante = 1 UNION SELECT p.mrun,rbd_admitido_post_resp as rbd FROM postulantesNoAsignados p INNER JOIN D1_Resultados_etapa_regular r ON p.mrun = r.mrun WHERE CASE WHEN respuesta_postulante_post_lista_espera = ' ' THEN false WHEN respuesta_postulante_post_lista_espera = 1 THEN true ELSE false END UNION SELECT p.mrun,rbd_admitido as rbd FROM postulantesNoAsignados p INNER JOIN D2_Resultados_etapa_complementaria r ON p.mrun = r.mrun WHERE rbd_admitido <> ' ') /*** FINAL QUERY ****/ SELECT a.rbd, d.NOM_RBD as establecimiento, d.NOM_COM_RBD as comuna, count(*) as estudiantes FROM asignacionDefinitiva a LEFT JOIN directorio d on a.rbd = d.rbd GROUP BY a.rbd, d.NOM_RBD, d.NOM_COM_RBD ORDER BY estudiantes DESC 35:T43e,regiones = [ { codigoRegion: 15, ordenRegion: 1, nombreRegion: "Arica y Parinacota" }, { codigoRegion: 1, ordenRegion: 2, nombreRegion: "Tarapacá" }, { codigoRegion: 2, ordenRegion: 3, nombreRegion: "Antofagasta" }, { codigoRegion: 3, ordenRegion: 4, nombreRegion: "Atacama" }, { codigoRegion: 4, ordenRegion: 5, nombreRegion: "Coquimbo" }, { codigoRegion: 5, ordenRegion: 6, nombreRegion: "Valparaíso" }, { codigoRegion: 13, ordenRegion: 7, nombreRegion: "Metropolitana" }, { codigoRegion: 6, ordenRegion: 8, nombreRegion: "O'Higgins" }, { codigoRegion: 7, ordenRegion: 9, nombreRegion: "Maule" }, { codigoRegion: 16, ordenRegion: 10, nombreRegion: "Ñuble" }, { codigoRegion: 8, ordenRegion: 11, nombreRegion: "Biobio" }, { codigoRegion: 9, ordenRegion: 12, nombreRegion: "Araucanía" }, { codigoRegion: 14, ordenRegion: 13, nombreRegion: "Los Ríos" }, { codigoRegion: 10, ordenRegion: 14, nombreRegion: "Los Lagos" }, { codigoRegion: 11, ordenRegion: 15, nombreRegion: "Aysén" }, { codigoRegion: 12, ordenRegion: 16, nombreRegion: "Magallanes" } ]36:T6ee,db = DuckDBClient.of({ A1_Oferta_Establecimientos_etapa_regular: FileAttachment( "A1_Oferta_Establecimientos_etapa_regular_2022_Admisión_2023́.parquet" ), B1_Postulantes_etapa_regular: FileAttachment( "B1_Postulantes_etapa_regular_2022_Admisión_2023_PUBĹ.parquet" ), C1_Postulaciones_etapa_regular: FileAttachment( "C1_Postulaciones_etapa_regular_2022_Admisión_2023_PUBL.parquet" ), D1_Resultados_etapa_regular: FileAttachment( "D1_Resultados_etapa_regular_2022_Admisión_2023_PUBĹ.parquet" ), F1_Relaciones_entre_postulantes_etapa_regular: FileAttachment( "F1_Relaciones_entre_postulantes_etapa_regular_2022_Admisión_2023_PUBĹ.parquet" ), A2_Oferta_Establecimientos_etapa_complementaria: FileAttachment( "A2_Oferta_Establecimientos_etapa_complementaria_2022_Admisión_2023́.parquet" ), B2_Postulantes_etapa_complementaria: FileAttachment( "B2_Postulantes_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet" ), C2_Postulaciones_etapa_complementaria: FileAttachment( "C2_Postulaciones_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet" ), D2_Resultados_etapa_complementaria: FileAttachment( "D2_Resultados_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet" ), E2_Información_para_replicar_proceso_etapa_complementaria: FileAttachment( "E2_Información_para_replicar_proceso_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet" ), F2_Relaciones_entre_postulantes_etapa_complementaria: FileAttachment( "F2_Relaciones_entre_postulantes_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet" ), directorio: FileAttachment("directorio2022.parquet"), niveles: niveles, respuestas: respuestas, regiones: regiones, jornadas: jornadas })37:T869,WITH postulantesStaMarta as (SELECT mrun FROM C1_Postulaciones_etapa_regular WHERE rbd = 7401 AND preferencia_postulante = 1 AND cod_nivel = -1), postulantesSanJose as (SELECT mrun FROM C1_Postulaciones_etapa_regular WHERE rbd = 7388 AND cod_nivel = -1), postulantesSantaMartaYSanJose as (SELECT mrun,count(*) as postulaciones FROM C1_Postulaciones_etapa_regular WHERE mrun in (SELECT mrun FROM postulantesStaMarta) AND mrun in (SELECT mrun FROM postulantesSanJose) AND cod_nivel = -1 GROUP BY mrun ORDER BY postulaciones desc), postulantesSoloSantaMartaYSanJose as (SELECT * FROM postulantesSantaMartaYSanJose WHERE postulaciones = 2), admitidos as (SELECT mrun, CASE WHEN (rbd_admitido IN (7401, 7388) AND respuesta_postulante = 1) THEN rbd_admitido WHEN rbd_admitido_post_resp IN (7401, 7388) AND respuesta_postulante_post_lista_espera = 1 THEN rbd_admitido_post_resp END as rbd FROM D1_Resultados_etapa_regular WHERE cod_nivel = -1 and ( (rbd_admitido IN (7401, 7388) AND respuesta_postulante = 1) OR (CASE WHEN rbd_admitido_post_resp = ' ' THEN false WHEN rbd_admitido_post_resp IN (7401, 7388) AND respuesta_postulante_post_lista_espera = 1 THEN true ELSE false END))) SELECT p.mrun, CASE WHEN p.mrun IN (SELECT mrun FROM postulantesSoloSantaMartaYSanJose) THEN true ELSE false END as marca, CASE WHEN p.mrun IN (SELECT mrun FROM admitidos WHERE mrun = p.mrun AND rbd = p.rbd) THEN true ELSE false END as admitido, rbd, preferencia_postulante, loteria_original, prioridad_matriculado, prioridad_hermano, prioridad_hijo_funcionario,prioridad_exalumno, rbd_admitido,respuesta_postulante,rbd_admitido_post_resp,respuesta_postulante_post_lista_espera FROM C1_Postulaciones_etapa_regular p LEFT JOIN D1_Resultados_etapa_regular r on p.mrun = r.mrun /*AND (CASE WHEN r.rbd_admitido = ' ' THEN false ELSE p.rbd = r.rbd_admitido END)*/ WHERE RBD IN (7401,7388) AND p.cod_nivel = -1 ORDER BY rbd, prioridad_hermano DESC, prioridad_hijo_funcionario DESC ,preferencia_postulante, loteria_original /* SELECT * FROM C1_Postulaciones_etapa_regular WHERE mrun IN (SELECT mrun FROM postulantesSoloSantaMartaYSanJose)*/38:[{"id":"ae776b85c41a43bd5338366a6f236e7d78199aa5ce7e2ce30692c797d3411922c6a5ceeacb0c59804cfffc585ef20ce7bb76151800539617835e50b20d65f459","href":"https://static.observableusercontent.com/files/ae776b85c41a43bd5338366a6f236e7d78199aa5ce7e2ce30692c797d3411922c6a5ceeacb0c59804cfffc585ef20ce7bb76151800539617835e50b20d65f459","name":"B2_Postulantes_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":2910191},{"id":"b7ae5fd09c8690efc649bad9396ebfb4a38dcebf41fec1dc0ba51a8229a9a85834f92c6934bf9ffc7558c6c8ec2c75c0118dd6a2d68ffacdd758ee1304e665ed","href":"https://static.observableusercontent.com/files/b7ae5fd09c8690efc649bad9396ebfb4a38dcebf41fec1dc0ba51a8229a9a85834f92c6934bf9ffc7558c6c8ec2c75c0118dd6a2d68ffacdd758ee1304e665ed","name":"C2_Postulaciones_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":2639804},{"id":"9691a812a34231034231fefca61dbf6e38905893e3cf4b33f89dbb342bd54efd58c15ba5e5fe711d29a5b58b6cbdd0e7b9b3613f128e3444020f2b0e143f8400","href":"https://static.observableusercontent.com/files/9691a812a34231034231fefca61dbf6e38905893e3cf4b33f89dbb342bd54efd58c15ba5e5fe711d29a5b58b6cbdd0e7b9b3613f128e3444020f2b0e143f8400","name":"D2_Resultados_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":1119129},{"id":"5cb34b5a9e8044ab3dfb45d0618db1322b9a4e2a305dca69958f85409e13a9581e7b7b79fe0b38c43dd5bf8ad74af27adc88a7d8ffda1aec47e2609dd4400991","href":"https://static.observableusercontent.com/files/5cb34b5a9e8044ab3dfb45d0618db1322b9a4e2a305dca69958f85409e13a9581e7b7b79fe0b38c43dd5bf8ad74af27adc88a7d8ffda1aec47e2609dd4400991","name":"A2_Oferta_Establecimientos_etapa_complementaria_2022_Admisión_2023́.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":614443},{"id":"23400eb3ec195a135b26e35d0da01c765a7f43c9f0887caf83314b961808ef449c10515142db979e624eec7945c2b4ead5c7717fbf590ea6aa343b890e0a7316","href":"https://static.observableusercontent.com/files/23400eb3ec195a135b26e35d0da01c765a7f43c9f0887caf83314b961808ef449c10515142db979e624eec7945c2b4ead5c7717fbf590ea6aa343b890e0a7316","name":"E2_Información_para_replicar_proceso_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":1065385},{"id":"fc42a59f4578b706385fb831d5c9ee4f3c59e7d452af1ee37ac8039ea9eb814fe2eec52f58c242a4e525ec7229af7a03680d50b0d96e5cee6a8659c6b1bcaafd","href":"https://static.observableusercontent.com/files/fc42a59f4578b706385fb831d5c9ee4f3c59e7d452af1ee37ac8039ea9eb814fe2eec52f58c242a4e525ec7229af7a03680d50b0d96e5cee6a8659c6b1bcaafd","name":"directorio2022.parquet","type":"application/octet-stream","lastModified":1698667600705.25,"size":921186},{"id":"217a902cf60d6d9874b52a245db487719ced3852a14400f670822b8ec76944e9250009442f45b187b29005c5ecdd8c4c515b0b32f66fa8756a5d9696e548a094","href":"https://static.observableusercontent.com/files/217a902cf60d6d9874b52a245db487719ced3852a14400f670822b8ec76944e9250009442f45b187b29005c5ecdd8c4c515b0b32f66fa8756a5d9696e548a094","name":"D1_Resultados_etapa_regular_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667828589.408,"size":5648212},{"id":"fb4f89d060105b7b912094ebccfa6ec1133439c809d98f6aa0f9589b44a16b4308b68517bf33ef538742e690ba2351015fe7387738223b03e454b3c6b3935413","href":"https://static.observableusercontent.com/files/fb4f89d060105b7b912094ebccfa6ec1133439c809d98f6aa0f9589b44a16b4308b68517bf33ef538742e690ba2351015fe7387738223b03e454b3c6b3935413","name":"A1_Oferta_Establecimientos_etapa_regular_2022_Admisión_2023́.parquet","type":"application/octet-stream","lastModified":1698667818500.433,"size":671879},{"id":"1b1257ed2cbaa9a7bae21c12be14da7f99912373e8bb47e7db0811858e157963acbfe2167b068aec47b70ca0c967d2a6a77a186ae69326c03d5af17fe5c98fe3","href":"https://static.observableusercontent.com/files/1b1257ed2cbaa9a7bae21c12be14da7f99912373e8bb47e7db0811858e157963acbfe2167b068aec47b70ca0c967d2a6a77a186ae69326c03d5af17fe5c98fe3","name":"F1_Relaciones_entre_postulantes_etapa_regular_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667820399.102,"size":1322919},{"id":"81a161b24b96f1f034b2da43992325fb62a928f21772c656e10577cc2a4d9fbd6d68c66fb7cc7dfb7f1c554776fce17b29690eef41fa508911285338e0af1c46","href":"https://static.observableusercontent.com/files/81a161b24b96f1f034b2da43992325fb62a928f21772c656e10577cc2a4d9fbd6d68c66fb7cc7dfb7f1c554776fce17b29690eef41fa508911285338e0af1c46","name":"B1_Postulantes_etapa_regular_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698667838371.586,"size":12914741},{"id":"696ab8fb566b76ff34f412f1a1de6e7e2249bed4a94eda63f6b70c557702604eeabd56372f33e1f1b7df01a6d579d3d3df09f9d49b5cba8af9b547bc08ee0652","href":"https://static.observableusercontent.com/files/696ab8fb566b76ff34f412f1a1de6e7e2249bed4a94eda63f6b70c557702604eeabd56372f33e1f1b7df01a6d579d3d3df09f9d49b5cba8af9b547bc08ee0652","name":"C1_Postulaciones_etapa_regular_2022_Admisión_2023_PUBL.parquet","type":"application/octet-stream","lastModified":1698667838650.49,"size":14583269},{"id":"e54ab3c4ca491517688d87490faa1e47a20cce0313a12427636d64a8c84d80890e7c826c4357eea3bad2db94917cdb7b0d8964bc1aa05e59926a751144817afa","href":"https://static.observableusercontent.com/files/e54ab3c4ca491517688d87490faa1e47a20cce0313a12427636d64a8c84d80890e7c826c4357eea3bad2db94917cdb7b0d8964bc1aa05e59926a751144817afa","name":"F2_Relaciones_entre_postulantes_etapa_complementaria_2022_Admisión_2023_PUBĹ.parquet","type":"application/octet-stream","lastModified":1698698338928.111,"size":199265}] 30:{"id":"04e6e9f9f270e479","slug":"datos-sistema-de-admision-escolar","title":"Sistema de Admisión Escolar","thumbnail":"d4ac8fee4e434ec01d4a9769c32f708cca48e9332acc125d1e1d5236e2aa99b3","access_level":"public","create_time":"$D2023-10-30T12:06:40.705Z","update_time":"$D2023-11-04T10:03:14.950Z","view_time":null,"first_public_time":"$D2023-11-03T11:03:45.061Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":"starter_2024"},"version":2361,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null}],"members":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":5,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Sistema de Admisión Escolar","cells":[{"id":0,"value":"# Sistema de Admisión Escolar\n## Datos por establecimiento en proceso 2022 ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":777,"value":"viewof regionSeleccionada = Inputs.select(regiones, {\n label: \"Región\",\n format: (d) => d[\"nombreRegion\"],\n value: _.sample(regiones)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"viewof comunaSeleccionada2 = {\n const opciones = _.chain(directorioEstablecimientosConOferta)\n .filter(\n (d) => d.codRegionEstablecimiento == regionSeleccionada.codigoRegion\n )\n .map((d) => d.comunaEstablecimiento)\n .uniq()\n .sort()\n .value();\n\n return Inputs.select(opciones, {\n label: \"Comuna\",\n value: _.sample(opciones)\n\n //format: (d) => d[\"comunaEstablecimiento\"],\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":795,"value":"viewof establecimientoSeleccionado = {\n const opciones = _.chain(directorioEstablecimientosConOferta)\n .filter((d) => d.comunaEstablecimiento == comunaSeleccionada2)\n .uniqBy((d) => d.rbd)\n .sortBy((d) => d[\"nombreEstablecimiento\"])\n .value();\n return Inputs.select(opciones, {\n label: \"Establecimiento\",\n format: (d) => `${d[\"nombreEstablecimiento\"]} (${d[\"rbd\"]})`,\n value: _.sample(regiones)\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":752,"value":"viewof nivelSeleccionado = Inputs.select(nivelesConVacantesEstablecimiento, {\n label: \"Nivel\",\n format: (d) => `${d[\"nivel\"]} | vacantes: ${d[\"vacantes\"]}`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":829,"value":"# ${establecimientoSeleccionado.nombreEstablecimiento} de ${establecimientoSeleccionado.comunaEstablecimiento}\n\n## Resumen del proceso en 2022 \n* **${nivelSeleccionado.vacantes} ${nivelSeleccionado.vacantes == 1 ? \"vacante\" : \"vacantes\"}** ofrecidas para ${nivelSeleccionado.nivel} \n\n* **${postulantesEstablecimientoDetalle.length} **estudiantes **postularon** a las vacantes ofrecidas\n\n${_.chain(postulantesEstablecimientoPoPreferencia).find(d => d.preferencia_postulante == 1).value() ? `* **${_.chain(postulantesEstablecimientoPoPreferencia).find(d => d.preferencia_postulante == 1).value()[\"estudiantes\"]}** postularon en **primera prioridad**` : \"\"} \n\n* **${admitidosEtapaRegularQueAceptaAsignacion.length + detalleResultadoEtapaComplementaria.length}** postulantes fueron **admitidos y aceptaron la asignación**\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1322,"value":"**Mapa de referencia**\n\nEstrella amarilla representa ubicación el establecimiento y puntos azules el domicilio aproximado de los postulantes (con error aleatorio)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":687,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1156,"value":"## Detalle del proceso\n\n## Vacantes\nEn ${nivelSeleccionado.nivel} tenía ${nivelSeleccionado.vacantes} ${nivelSeleccionado.vacantes == 1 ? \"vacante\" : \"vacantes\"}\n${dataEstablecimientoSeleccionadoPorJornada.length == 1 \n ? `(jornada ${dataEstablecimientoSeleccionadoPorJornada[0].jornada})` \n : dataEstablecimientoSeleccionadoPorJornada.map(d => `\n * Jornada ${d.jornada}: ${d.vacantes} vacantes`)}\n\nTipo de vacantes\n${detalleVacantesEstablecimientoSeleccionado.filter(d => d.vacantes > 0).map(d => `* ${d.label}: ${d.vacantes}\\n`)}\n\n## Postulaciones\nPostularon ${postulantesEstablecimientoDetalle.length} estudiantes distribuidos de la siguiente manera según su preferencia:\n\n\n \n${postulantesEstablecimientoPoPreferencia.map(d => ``)}\n

Preferencia	Postulantes
Preferencia ${d.preferencia_postulante}	${d.estudiantes}

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":918,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1116,"value":"Aquellos postulantes que no fueron asignados (o que rechazaron el cupo) fueron finalmente admitidos en los siguientes establecimientos","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1114,"value":"asignaciónFinalNoAsignadosAlEstablecimiento","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1018,"value":"## Etapa complementaria\n\nSe admitió a **${detalleResultadoEtapaComplementaria.length} ${detalleResultadoEtapaComplementaria.length == 1 ? \"postulante\" : \"postulantes\"}**\n\nEl establecimiento ofreció **${ofertaEtapaComplementaria.length ? ofertaEtapaComplementaria[0].vacantes : 0} ${(ofertaEtapaComplementaria.length ? ofertaEtapaComplementaria[0].vacantes : 0) == 1 ? \"vacante\": \"vacantes\"}** en la etapa complementaria\n\nHubo **${postulacionesEtapaComplementaria.length} ${postulacionesEtapaComplementaria.length == 1 ? \"postulante\" : \"postulantes\"}**\n\n\n \n${postulacionesEtapaComplementariaPorPreferencia1.map(d => ``)}\n

Preferencia	Postulantes
Preferencia ${d.preferencia_postulante}	${d.postulantes}

\n\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1174,"value":"