{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1 Cartola","Hoja1","Hoja2","Comprobante"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"1 Cartola","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,"Cartola Mensual Pagos Subvenciones"]
[null,null,"Mes de:","Junio 2019"]
["Identificacion Establecimiento"]
["Establecimiento:","Escuela Industrial Salesiana San Ramon",null,null,"Región","COQUIMBO"]
["RBD:",574,null,null,"Provincia","ELQUI"]
["Sostenedor:","Congregación Salesiana",null,null,"Comuna","LA SERENA"]
["RUT:",80230500]
[]
["Montos Transferidos para el mes ",null,null,null,null,"Descargar"]
["Concepto Pago","Liquido Transferido","Fecha pago","Cuenta Corriente","Titular cuenta","Estado Transferencia","Ver Detalle"]
["Subvención Normal",{"$f":"Hoja2!J21","v":13129058.66285},"2019-06-25","001.63.760035","Congregación Salesiana","Realizada"]
["SEP Prioritarios",{"$f":"$B$11*RANDBETWEEN(1,100)/100","v":656452.9331425},"2019-06-25","001.63.760035","Congregación Salesiana","Realizada"]
["SEP Preferentes",2100649.3860559999,"2019-06-25","001.63.760035","Congregación Salesiana","Realizada"]
["BRP (carrera docente)",5120332.8785114996,"2019-06-25","001.63.760035","Congregación Salesiana","Realizada"]
["SNED",9321631.6506235003,"2019-06-30","504.12.32456","Congregación Salesiana"]
["Bono Escolar",11947443.3831935,"2019-06-28","504.12.32456","Congregación Salesiana","Realizada",null,"Rechazo Bancario"]
["Liberación Retenciones",9321631.6506235003,"2019-06-20","001.63.760035","Congregación Salesiana","Realizada"]
["Total transferido en el mes",{"$f":"SUM(B11:B17)","v":51597200.545000501}]

{"sheet":"Hoja1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Hoja2","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[[4,6,4,7]]}
[null,null,null,null,null,"Orden de Pago Resumida"]
[null,null,null,null,null,null,"Subvención Normal"]
["Región",null,"C  O  Q  U  I  M  B  O",null,null,"Dependencia","Particular",null,null,"Ruralidad","NO","R.B.D.:",574]
["Provincia",null,1,null,null,"Financiamiento","Financiamiento Compartido",null,null,"Piso Rural","NO","VALOR USE $",25440.361000000001]
["Comuna",null,"LA SERENA",null,null,"Ingreso Proyectado",187890120,null,null,"zona",10,"MES PAGO : ","Junio 2019"]
[null,null,"  ESTABLECIMIENTO: ","ESCUELA INDUSTRIAL SALESIANA SAN RAMON"]
[]
[]
[null,null,null,null,"RESUMEN CONCEPTOS CALCULADOS RBD",574]
[]
[null,null,null,null,"Subtotal Subvención Base",11303253,null,null,"Monto ley 19.410",508871.1569799998]
[null,null,null,null,"Internado",0,null,null,"Monto ley 19.464",186609.50586999999]
[null,null,null,null,"incremento zona",1130325,null,null,"Desempeño Dificil Docentes",0]
[null,null,null,null,"Incremento ruralidad",0,null,null,"Desempeño Dificil Asistentes",0]
[null,null,null,null,"Diferencia Piso Rural",0,null,null,"Pofesor Encargado",0]
[null,null,null,null,"Descto Según Cobro mensual promedio",0,null,null,"Aportes Adicionales",695480.66284999973]
[null,null,null,null,"Aporte Estado Fondo de Becas",0]
[null,null,null,null,"Derecho escolaridad",0,null,null,"Descuentos",0]
[null,null,null,null,"Aporte por Gratuidad",0,null,null,"Retenciones"]
[]
[null,null,null,"Total Pagos",null,12433578,null,null,"Total a pagar",13129058.66285]

{"sheet":"Comprobante","index":3,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,6],[4,2,5,7]]}
[]
[null,"Comprobante Ingreso a Caja ",null,null,null,null,null,"N° Documento","0011/2021"]
[null,null,null,null,null,null,null,"Fecha Documento","xx"]
[null," "]
[null,null,"Por el presente, el Sostenedor XXX (RUT :xxxxx) declaró haber recibido del Ministerio de Educación, por los pagos  los siguientes  conceptos y montos, para los establecimientos de su dependencia "]
[]
[]
[null,null,"Concepto Pago","Liquido Recibido ","Fecha de pago","Cuenta Corriente","Banco","Titular Cuenta","Observación"]
[null,null,"Apoyo Retorno Seguro ",0,"2021-08-31","xxx","xx","XXX"]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[]
[null,null,"Total Recibido",{"$f":"SUM(D9:D15)","v":0}]
[]
[null,null,"Para efectos de cumplimiento a la Circular  N° 30 de la CGR",null,null,null,"Firma de Representante Legal "]