{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Persuna 1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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":"Persuna 1","index":0,"n_rows":97,"n_cols":18,"rows_kept":97,"cut":false,"hidden":false,"merged":[[37,4,37,7],[35,0,35,7],[36,0,36,7],[32,0,32,7],[33,0,33,7],[34,0,34,7],[62,0,62,7],[63,0,63,7],[64,0,64,7],[65,0,65,7],[66,0,66,7],[28,4,28,7],[26,0,26,7],[27,0,27,7],[24,0,24,7],[25,0,25,7],[40,0,40,5],[18,2,18,4],[12,5,12,6],[14,5,14,6],[16,5,16,6],[18,5,18,6],[13,2,13,4],[13,5,13,6],[13,0,13,1],[17,5,17,6],[22,0,22,7],[21,0,21,7],[23,0,23,7],[40,6,40,7],[12,2,12,4],[14,2,14,4],[48,4,48,7],[91,0,91,8],[79,0,79,2],[87,0,87,2],[90,0,90,2],[72,0,72,1],[51,6,51,7],[55,0,55,1],[55,2,55,3],[56,0,56,1],[56,2,56,3],[57,0,57,1],[57,2,57,3],[58,0,58,1],[54,0,54,1],[54,2,54,3],[0,0,2,8],[18,0,18,1],[14,0,14,1],[15,0,15,4],[17,0,17,1],[17,2,17,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[16,2,16,4],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[58,2,58,3],[59,4,59,7],[100,0,100,2],[46,2,46,3],[47,2,47,3],[71,2,71,3],[72,2,72,3],[96,0,96,1],[71,0,71,1],[46,0,46,1],[47,0,47,1],[51,0,51,5],[52,0,52,1],[52,2,52,3],[53,0,53,1],[53,2,53,3]]}
["Formular da rendaquint per mesiras staziunaras da la protecziun d'uffants"]
[]
[]
[]
["Avant maun a medem temp mesira ambulanta e staziunara da la protecziun d'uffants:"]
[]
["Vischnanca"]
["Onn"]
["Perioda"]
[]
[]
["Uffant / giuvenil(a)"]
["Num",null,"Prenum",null,null,"Nasch. (dd/mm/oooo)"]
[]
[]
["Geniturs / titular(a)s da la tgira genituriala "]
["Num",null,"Prenum",null,null,"Via / nr.",null,"NP","Lieu"]
[]
[]
[]
["Prestaziuns da terzas persunas"]
["Entradas mensilas da l'uffant",null,null,null,null,null,null,null,"Import (fr.)"]
["Descripziun",null,null,null,null,null,null,null,"(fr.)"]
["Entradas da rentas / diarias / assicuranzas / agids"]
["Supplements per uffants / supplements da scolaziun"]
["Contribuziuns da mantegniment ed aliments"]
["Stipendis"]
["Ulteriuras entradas periodicas da l'uffant (endatar per plaschair en cas da basegn)"]
[null,null,null,null,"Total da las prestaziuns da terzas persunas (da metter a quint als custs da mesiras)",null,null,null,{"$f":"SUM(I24:I28)","v":0}]
[]
["Èn vegnidas pajadas ora retroactivamain prestaziuns da terzas persunas (p.ex. AI, PS e.u.v.) durant il quartal da rendaquint?"]
[]
["Prestaziuns da terzas persunas pajadas ora retroactivamain (per l'entira durada da las mesiras staziunaras da la protecziun d'uffants)",null,null,null,null,null,null,null,"Import (fr.)"]
["Descripziun",null,null,null,null,null,null,null,"(fr.)"]
[]
[]
[]
[null,null,null,null,"Total da las prestaziuns da terzas persunas pajadas ora retroactivamain (da metter a quint als custs da mesiras)",null,null,null,{"$f":"SUM(I35:I37)","v":0}]
[]
["Custs per mesiras staziunaras da la protecziun d'uffants"]
["Instituziun",null,null,null,null,null,"Durada da la dimora (en il quartal)",null,"Import (fr.)"]
["Num",null,"Via",null,"NP","Lieu","Da (dd/mm/oooo)","Fin (dd/mm/oooo)","(fr.)",null,null,"Eff. Tage","Diff. Anfangsmonat","Tage Anfangsmonat","Diff. Endmonat","Tage Endmonat","Max. Tage","Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",_xlfn.DAYS(H43,G43)+1)","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",IF(DAY(G43)<>1,DAY(G43),1))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",DAY(DATE(YEAR(G43),MONTH(G43)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",IF(DAY(H43)<>DAY(DATE(YEAR(H43),MONTH(H43)+1,0)),DAY(DATE(YEAR(H43),MONTH(H43)+1,0))-DAY(H43),0))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",DAY(DATE(YEAR(H43),MONTH(H43)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G43),ISBLANK(H43)),\"\",SUM(_xlfn.DAYS(H43,G43),M43,O43))","v":""},{"$f":"IFERROR(IF(AND($I$29<>0,I43<>\"\",ISERROR(IF(MONTH(H43)-MONTH(G43)=0,$I$29/Q43*L43,IF(MONTH(H43)-MONTH(G43)=1,($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)),($I$29*(MONTH(H43)-MONTH(G43)-1))+($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)))))),\"Controllar!\",IF(MONTH(H43)-MONTH(G43)=0,$I$29/Q43*L43,IF(MONTH(H43)-MONTH(G43)=1,($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43)),($I$29*(MONTH(H43)-MONTH(G43)-1))+($I$29/N43*(N43-M43+1))+($I$29/P43*(P43-O43))))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",_xlfn.DAYS(H44,G44)+1)","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",IF(DAY(G44)<>1,DAY(G44),1))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",DAY(DATE(YEAR(G44),MONTH(G44)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",IF(DAY(H44)<>DAY(DATE(YEAR(H44),MONTH(H44)+1,0)),DAY(DATE(YEAR(H44),MONTH(H44)+1,0))-DAY(H44),0))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",DAY(DATE(YEAR(H44),MONTH(H44)+1,0)))","v":""},{"$f":"IF(OR(ISBLANK(G44),ISBLANK(H44)),\"\",SUM(_xlfn.DAYS(H44,G44),M44,O44))","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,"","","","","","",""]
[null,null,null,null,"Custs totals per mesiras staziunaras da la protecziun d'uffants",null,null,null,{"$f":"SUM(I43:I48)","v":0}]
[]
["Custs per mesiras ambulantas da la protecziun d'uffants"]
["Instituziun ",null,null,null,null,null,"Durada da la mesira (en il quartal)",null,"Import (fr.)"]
["Num",null,"Via",null,"NP","Lieu","Da (dd/mm/oooo)","Fin (dd/mm/oooo)","(fr.)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Custs totals per mesiras ambulantas da la protecziun d'uffants",null,null,null,{"$f":"SUM(I54:I59)","v":0}]
[]
["Calculaziun dals custs nets"]
["Custs totals per mesiras staziunaras da la protecziun d'uffants",null,null,null,null,null,null,null,{"$f":"I49","v":0}]
["Custs totals per mesiras ambulantas da la protecziun d'uffants",null,null,null,null,null,null,null,{"$f":"I60","v":0}]
["Total da las prestaziuns da terzas persunas",null,null,null,null,null,null,null,{"$f":"IF(OR(R43=\"Controllar!\",R44=\"Controllar!\",R45=\"Controllar!\",R46=\"Controllar!\",R47=\"Controllar!\",R48=\"Controllar!\"),\"Controllar!\",SUM(R43:R48,I38))","v":0},"Endatar per plaschair correctamain la durada da la dimora sut «Custs per mesiras staziunaras da la protecziun d'uffants»"]
["Part che sto vegnir messa a quint al pool intercommunal (95% dals custs per mesiras da la protecziun d'uffants)",null,null,null,null,null,null,null,{"$f":"IF(I65=\"Controllar!\",\"Controllar!\",0.95*(I63+I64-I65))","v":0}]
["Part che resta a la vischnanca (5% dals custs per mesiras da la protecziun d'uffants)",null,null,null,null,null,null,null,{"$f":"IF(I66=\"Controllar!\",\"Controllar!\",0.05*(I63+I64-I65))","v":0}]
[]
["Contribuziun dals geniturs (pajada effectivamain en il quartal respectiv)"]
[]
[]
["Pajà dals geniturs ",null,"Anticipà da la vischnanca",null,"Taxa per di* (fr.)","Dumber da dis","Contribuziun dals geniturs (fr.)","Part a favur da la vischnanca (proporziunalmain)\n(fr.)","Part a favur da la vischnanca (proporziunalmain)\n(fr.) "]
[null,null,null,null,null,null,{"$f":"E73*F73","v":0},{"$f":"0.2*G73","v":0},{"$f":"0.8*G73","v":0}]
[null,null,null,null,"Total",{"$f":"SUM(F73:F73)","v":0},{"$f":"SUM(G73:G73)","v":0},{"$f":"SUM(H73:H73)","v":0},{"$f":"SUM(I73:I73)","v":0}]
[]
["*Tenor l'art. 63a al. 4 LItCCS sto la taxa per di importar almain 10.00 fr. "]
[]
["Import total a favur da la vischnanca",null,null,null,null,null,null,null,{"$f":"I66-I74","v":0}]
[]
["Agiuntas"]
["- disposiziun mesiras staziunaras da la protecziun d'uffants"]
["- rendaquints da la(s) instituziun(s) che furnescha(n) prestaziuns"]
["- calculaziun contribuziun dals geniturs"]
["- cumprova da las contribuziuns dals geniturs pajadas (extract da conto)"]
["- decisiun da prestaziun resp. disposiziun concernent l'agid social"]
["- cumprova d'aliments"]
[]
["Termins d'inoltraziun"]
["30 d'avrigl, 31 da fanadur, 31 d'october e 31 da schaner"]
[]
["Furma d'inoltraziun"]
["Il rendaquint ed ils documents appartegnents ston vegnir inoltrads sin via electronica sur la pCloud (access segir). As annunziai per plaschair per che nus possian endrizzar l'access per Vus. "]
[]
[]
[]
[]
["Lieu / data",null,null,null,null,"Suttascripziun da la vischnanca"]