{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Main Table","Indexation table","Main Table Instructions "," "],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Main Table","index":0,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[[10,3,10,5],[10,0,10,2],[45,0,47,0],[45,1,47,1],[45,2,47,2],[45,3,47,3],[45,4,47,4],[44,0,44,1],[22,0,22,5],[23,1,23,2],[23,3,23,4],[24,0,26,0],[24,1,26,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[5,0,5,2],[5,3,5,5],[6,10,6,11],[8,10,8,11],[9,0,9,2],[8,0,8,2],[8,3,8,5],[9,3,9,5],[69,0,69,5],[70,0,83,5],[43,0,43,4],[62,0,67,5],[61,0,61,5],[0,0,0,5],[24,5,26,5],[12,0,17,0],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,3,17,4],[1,0,1,5],[3,0,3,5],[4,0,4,5],[6,0,6,2],[7,0,7,2],[6,3,6,5],[7,3,7,5]]}
[]
["Calculation of arrears per person*"]
["escolher idoma/chosse language",null,"Idioma:","English"]
["* Please consult the instructions for filling in the form."]
["Decision / Court settlement / Authentic instrument"]
["Name of applicant:"]
["Date (DD/MM/YYYY) and reference number of decision / Court settlement / Authentic instrument:"]
["Name of Court / Competent authority of origin:"]
["Name of the defendant:"]
["Person for whom maintenance is owed:"]
["Reference number of application:"]
[]
["Currency of decision/Court settlement/ Authentic instrument            ",null,"    Euro (EUR)","  ","Lev (BGN)"]
[null,null,"    Czech koruna (CZK)",null,"Croatian kuna (HRK)  "]
[null,null,"    Forint (HUF)",null,"Litas (LTL)"]
[null,null,"    Polish zloty (PLN) ",null,"Romanian leu (RON)"]
[null,null,"    Krona (SEK)",null,"Pound sterling (GBP)"]
[null,null,"    Other (please specify ):"]
[]
[]
[]
[]
["Annual amount table"]
["Year",null,null,"Currency of table     "]
["Month","Monthly amount set","Amounts paid by debtor","Amounts paid in other currencies","Amounts paid by other sources","Amounts in arrears"]
[]
[]
["January",null,null,null,null,{"$f":"B28-C28-E28","v":0}]
["February",null,null,null,null,0]
["March",null,null,null,null,0]
["April",null,null,null,null,0]
["May",null,null,null,null,0]
["June",null,null,null,null,0]
["July",null,null,null,null,0]
["August",null,null,null,null,0]
["September",null,null,null,null,0]
["October",null,null,null,null,0]
["November",null,null,null,null,0]
["December",null,null,null,null,0]
["TOTAL",{"$f":"SUM(B28:B39)","v":0},{"$f":"SUM(C28:C39)","v":0},null,{"$f":"SUM(E28:E39)","v":0},0]
[]
[]
[]
["Summary table"]
["Currency of table     "]
["Year","Yearly amount set","Amounts paid by debtor","Amounts paid by other sources","Amounts in arrears"]
[]
[]
[null,null,null,null,{"$f":"B49-C49-D49","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
["TOTAL",{"$f":"SUM(B49:B58)","v":0},{"$f":"SUM(C49:C58)","v":0},{"$f":"SUM(D49:D58)","v":0},0]
[]
[]
["Other relevant information - to be completed by the requesting central authority"]
[]
[]
[]
[]
[]
[]
[]
["                                  Indexation table"]
["\n\nDone at: ……………………………...…………. on ………………...……...…………... (dd/mm/yyyy)\n\nSignature of applicant: ……………………………………………………………………………..................…...............\n\nand/or, where appropriate\n\nName and signature of the person/authority authorised in the requesting Member State to complete the form on the applicant’s behalf: ……........…………………….............................................……...................................\n…………………………………………………………...……………..............................................…........................…"]

{"sheet":"Indexation table","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[4,6,5,6],[30,1,31,5],[0,0,0,14],[1,0,1,14],[4,9,4,14],[5,0,5,1],[3,6,3,7],[3,2,3,4],[6,0,28,1],[4,3,5,3]]}
["Indexation table"]
["(for calculating indexed amount)"]
[]
[null,null,"Automatic calculation tool",null,null,null,"Summary indexation rates"]
[null,null,"Year","Indexation","Amount",null,"Year","Member State",null,"Responsible entity:",{"$f":"VLOOKUP(idioma,trad_v,26,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(idioma,trad_v,26,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(idioma,trad_v,26,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(idioma,trad_v,26,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(idioma,trad_v,26,FALSE)","v":{"$error":"#REF!"}}]
["Monthly maintenance amount set* ",null,2000,null,100,null,{"$f":"VLOOKUP(idioma,trad_v,7,FALSE)","v":{"$error":"#REF!"}},"General total"]
["Monthly amount set updated",null,{"$f":"C6+1","v":2001},{"$f":"VLOOKUP(C7-1,$G$7:$H$29,2)","v":0},{"$f":"E6+(E6*D7)","v":100},null,1992]
[null,null,{"$f":"C7+1","v":2002},{"$f":"VLOOKUP(C8-1,$G$7:$H$29,2)","v":0},100,null,1993]
[null,null,2003,{"$f":"VLOOKUP(C9-1,$G$7:$H$29,2)","v":0},100,null,1994]
[null,null,2004,0,100,null,1995]
[null,null,2005,0,100,null,1996]
[null,null,2006,0,100,null,1997]
[null,null,2007,0,100,null,1998]
[null,null,2008,0,100,null,1999]
[null,null,2009,0,100,null,2000]
[null,null,2010,0,100,null,2001]
[null,null,2011,0,100,null,2002]
[null,null,2012,0,100,null,2003]
[null,null,2013,0,100,null,2004]
[null,null,2014,0,100,null,2005]
[null,null,2015,0,100,null,2006]
[null,null,2016,0,100,null,2007]
[null,null,2017,0,100,null,2008]
[null,null,2018,0,100,null,2009]
[null,null,2019,0,100,null,2010]
[null,null,2020,0,100,null,2011]
[null,null,2021,0,100,null,2012]
[null,null,2022,0,100,null,2013]
[null,null,2023,0,100,null,2014]
[]
[null,"* enter the year and amount of maintenance or the value set for the previous year entered in the 'annual amount table'"]
[]
[null,"This Indexation table is only an example as the Member States need to develop their own supplementary table and formulas that fit to their system of calculating  indexation. "]

{"sheet":"Main Table Instructions ","index":2,"n_rows":79,"n_cols":1,"rows_kept":79,"cut":false,"hidden":false,"merged":[[86,0,86,8],[28,0,28,8],[78,0,78,8],[79,0,79,8],[45,0,45,8],[65,0,65,8],[77,0,77,8],[76,0,76,8],[63,0,63,8],[67,0,67,8],[66,1,66,9],[49,0,49,8],[44,0,44,8],[47,0,47,8],[46,0,46,8],[0,0,0,8],[12,0,12,8],[11,0,11,8],[16,0,16,8],[1,0,1,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[27,0,27,8],[26,0,26,8],[25,0,25,8],[24,0,24,8],[22,0,22,8]]}
["Instructions - Guide to filling in the main table"]
["This is a non mandatory form. It can be completed by the applicant and/or any person/authority authorised in the requesting Member State to complete the form on the applicant's behalf. It can be completed electronically or on paper, using Excel or PDF format."]
[]
[]
["1."]
["2."]
["3."]
["4."]
["5."]
["6."]
[]
["1. Enter the name of the applicant i.e. the physical person / public body that claims the maintenance amount on his/her/its own behalf."]
["2. Enter the date and reference number of the decision, court settlement or authentic instrument on which the calculation of arrears is based. If the calculation of arrears is based on more than one decision, court settlement, authentic instrument, enter the date and reference of all decisions, court settlements or authentic instruments by enlarging the cell/using more lines in the cell."]
["3. Enter the name of the court or other competent authority of origin. If more than one court or competent authority is involved (as per point 2), enter the name of all in accordance with point 2 respectively, by enlarging the cell/using more lines in the cell."]
["4. Enter the name of the defendant (the person against whom the maintenance application concerned is submitted)."]
["5. Enter the name of the person for whom the maintenance arrears are claimed. Fill in a separate form for each person  for whom maintenance is owed."]
["6. Enter the reference number of the application (requesting central authority)."]
[]
["7."]
[]
[]
[]
["7. Indicate the currency in which the maintenance obligation is established and the record is kept (i.e.  that whichappears in the decision, court settlement or authentic instrument). If, at the time of filling in the form, the currency mentioned in the decision, court settlement or authentic instrument has changed in the State of origin of the document, it is recommended to enter in each annual amount table the amount in the currency in which it was paid so as to obtain for each year an automatic calculation of the arrears in the valid currency for that year. Then  convert the results into the new currency in use at the time of filling the form,  in the summary table so that  the total accumulated is in that currency. In this case, it is advisable to give further explanation in the 'other relevant information' box. "]
["8."]
["8. Enter the calendar year to which the annual amount table applies; Fill in as many tables as necessary to cover the whole period over which  arrears are accumulated (i.e. for each calendar year) starting with  the earliest year  affected by non-payment and ending with the most recent."]
["For adding more annual amount tables, please use the features of the MS Excel by:"]
[" Clicking on the button (macros need to be enabled)  "]
["or "]
["1. Select the annual amount table and one additional line by using the left mouse button and scrolling down on the numbers of the rows (i.e from row 21 to row 39). It is important to select the rows rather than the cells only because due to sheet protection only rows can be copied and inserted; 2. By clicking on the right mouse button choose Copy;  3. Click on the following row number (row 40) on the left side right under the Selected area; 4. By clicking on the right mouse button choose Insert copied cells from the list. 5. An additional blank annual amount table will appear with the formulas included. If you need more annual amount tables please repeat the steps from 1 to 4."]
[]
["9."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10."]
["9. The table calculates the 'amounts in arrears' automatically using the data inserted into the columns (except the amounts paid in other currencies which are for reference only)."]
["Enter the amounts in the cells  as appropriate ; leave blank if not applicable. Not all cells/columns are intended to be used in all cases. \n 'Monthly amount set': enter for each month the amount indicated in the decision, court settlement or authentic instrument.\n 'Amounts paid by the debtor' : enter the amounts actually paid by the debtor. Where this does not correspond to the monthly amount set for the given month,  the final calculation will show the balance. You should ignore the balance in the 'amounts in arrears ' column for the months concerned by the overpayment. The total arrears amount will be shown in the summary table. \n'Amounts paid in other currencies' : enter partial or full payments made by the debtor in a  currency other than that mentioned in the decision, court settlement or authentic instrument. Refer to the currency in which the payment was made (e.g. 1 000 CZK/HUF/PLN etc.) and convert this amount to the currency of the table entering the exchange rate used in the 'amounts paid in other currency' column  and mention the result of the conversion in the 'amounts paid by the debtor' column. This monthly record of 'payments in other currencies' may be useful for some applicants, to explain the figures in the 'amounts paid by the debtor' column."]
["Amounts paid by other sources' : enter any payments made by public bodies or authorities other than the debtor. It is a column which enables the applicant or the authority to indicate any payment that was made not by the debtor but by another authority, office or agency (typically benefits provided in place of maintenance). These payments may be recovered by separate application. Please ignore this column if it does not apply in your case. For any entry, give the details of the 'other source' in the 'other relevant information' box at the end of the table. Do not fill in this column where the applicant is a public body, as there is no other source involved (i.e. 'other'  than the applicant). Amounts  in this column are not covered by  the application for recovery and are deducted from the 'monthly amount set'."]
["Amounts in arrears': This colum shows the balance for each month calculated automatically using the figures in the 'monthly amount Set', 'amounts paid by the debtor', 'amounts paid by other sources' columns. If payments are not regular or equal, some months may show overpayment and some may show underpayment of the maintenance obligation. However, the summary table will show the actual balance regardless of temporary over- or under-payments during the period in which the arrears are accumulated."]
[]
["10. In the last 'total' line of the annual amount table do not enter any amount as it appears automatically."]
[]
[]
[]
["11."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["11. Enter in the first column each year for which an annual amount table has been completed. In the 'amounts' colums, enter the amounts from the 'total' lines in the annual amount tables. The 'amounts paid in other currency' column is not included here as it is for reference only."]
["12."]
["12. Please provide any additional relevant information that could not be given in the previous cells."]
["13."]
["13. If indexation is used and an indexation table is attached, tick the box and enter the indexed amounts for each indexation term (as set by the national legislation in the Member State) in the 'monthly amount set' column. In this case, the monthly amount set may change from term to term.  Show the calculation method for the revised amount in a supplementary table along with the national legislation on which the indexation is based."]
["14."]
["15."]
[]
["16."]
[]
[]
[]
[]
["14. Enter the place and date of signature."]
["15. If the table is filled by the applicant, he/she should sign here."]
["16. If  the table is not filled in by the applicant, enter the name and signature of the authorised person/authority. In such cases, credible information (official record or statement by the applicant) should be provided as to the source of the data into the form."]

{"sheet":" ","index":3,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,5],[3,0,5,0],[3,1,5,1],[3,2,5,2],[3,3,5,3],[3,4,5,4],[3,5,5,5],[2,1,2,2],[2,3,2,4]]}
[]
["Annual amount table"]
["Year",null,null,"Currency of table     "]
["Month","Monthly amount set","Amounts paid by debtor","Amounts paid in other currencies","Amounts paid by other sources","Amounts in arrears"]
[]
[]
["January",null,null,null,null,{"$f":"B7-C7-E7","v":0}]
["February",null,null,null,null,0]
["March",null,null,null,null,0]
["April",null,null,null,null,0]
["May",null,null,null,null,0]
["June",null,null,null,null,0]
["July",null,null,null,null,0]
["August",null,null,null,null,0]
["September",null,null,null,null,0]
["October",null,null,null,null,0]
["November",null,null,null,null,0]
["December",null,null,null,null,0]
["TOTAL",{"$f":"SUM(B7:B18)","v":0},{"$f":"SUM(C7:C18)","v":0},null,{"$f":"SUM(E7:E18)","v":0},0]