{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Payment_REQUEST","Instructions","COSTS_Summary","INCOME_Summary","CONSOLIDATED_FS","FUNDS_Distribution","Values","LIST"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":29,"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":"Payment_REQUEST","index":0,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[26,0,26,2],[13,5,13,8],[14,2,14,4],[14,5,14,8],[15,2,15,4],[15,5,15,8],[13,2,13,4],[18,2,18,5],[17,6,19,8],[19,2,19,5],[12,0,15,1],[12,5,12,8],[26,3,26,8],[12,2,12,4],[17,2,17,5],[17,0,19,1],[32,1,32,2],[27,0,27,2],[27,3,27,8],[28,0,28,2],[28,3,28,8],[29,0,29,2],[29,3,29,8],[22,0,22,8],[24,0,24,8],[25,0,25,2],[25,3,25,8],[0,0,0,8],[2,0,2,2],[2,3,2,8],[6,0,6,2],[6,3,6,8],[8,0,8,2],[8,3,8,8],[4,0,4,2],[4,3,4,8],[10,7,10,8],[10,4,10,5],[10,0,10,2]]}
["PAYMENT REQUEST"]
[]
["PROJECT reference :",null,null,"LIFEXX XXX/XX/XXXXXX - ACRONYM"]
[]
["Strand type :",null,null,"CLIMA - CCA"]
[]
["Name of COORDINATING beneficiary"]
[]
["Legal Address :"]
[]
["Financial Statement PERIOD",null,null,"From:",null,null,"To:"]
[]
["Banking details:",null,"Bank account holder (*) : "]
[null,null,"Name of the bank :"]
[null,null,"Address of the bank :"]
[null,null,"I.B.A.N (or bank account number) (**)"]
[]
["Type of payment requested: ",null,{"$f":"IF($D$5=\"INTEGRATED PROJECT - IP\",\" \",\"PRE-FINANCING n°2\")","v":"PRE-FINANCING n°2"},null,null,null,"PAYMENT OF THE BALANCE"]
[null,null,{"$f":"IF($D$5=\"INTEGRATED PROJECT - IP\",\"INTERIM PAYMENT\",\"PRE-FINANCING n°3\")","v":"PRE-FINANCING n°3"}]
[null,null,"PAYMENT OF THE BALANCE"]
[]
["Beneficiary's Certificate:"]
["I certify on my honour that the information contained  in this payment request is full, reliable and true. I also certify that the costs incurred can be considered eligible in accordance with the applicable rules and that this request for payment is substantiated by adequate supporting documents that can be checked."]
[]
["Legal/statutory representative of the COORDINATING beneficiary :"]
["Name:"]
["Title:"]
["Function:"]
["Date:"]
["Signature:"]
[]
[]
[null,"Enclosures:",null,"- Excel Workbook either on a diskette, CD-Rom or USB-key"]
[null,null,null,"- External audit report if appropriate"]
[]
[]
[null,"              (*) Bank account must be opened in the name of the COORDINATING beneficiary"]
[null,"(**) If different from grant agreement, financial identification form should be submitted"]
[null,"template is available here: http://ec.europa.eu/budget/library/contracts_grants/info_contracts/financial_id/fich_sign_ba_gb_en.pdf"]

{"sheet":"Instructions","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,7,6,8],[1,7,1,8],[1,4,1,5],[1,1,1,2]]}
[]
[null,"Worksheet \"COSTS_Summary\"",null,null,"Worksheet \"INCOME_Summary\"",null,null,"Worksheet \"FUNDS_Distribution\""]
[]
[null,1,"Enter Participant's short name in column B and Legal status in column C",null,1,"Participant's short name and legal status are automatically imported from the Costs summary worksheet",null,1,"Participant's short name and legal status are automatically imported from the Costs summary worksheet"]
[null,2,"Declared Costs (Blue row) = Enter the actual costs per category as declared in the cost statement of the relevant participant.",null,2,"Declared Costs (Blue row) = Enter the actual income amounts as declared in the financial statement for the relevant participant.",null,2,"Indicate Planned eligible costs for the complete action for the relevant participant, as reflected in Annex III (blue cells)"]
[null,3,"Ensure that the total eligible cost with non-recoverable VAT matches the total of the individual financial statement of the beneficiary + enter in the last column (Blue cell) the amount of the total cost with non-recoverable VAT (as in the individual financial statement of the benericiary)"]
[null,"In case of \"PAYMENT OF THE BALANCE\" :",null,null,null,null,null,"In case of :"]
[null,"ð","Contractual budget (Yellow row) = Enter the TOTAL contractual budget. This is the budget from the Grant Agreement or the latest Amendment modifying Annex III. Whole numbers only.",null,null,null,null,"ð","Pre-financing n°1: \nIndicate 1st prefinancing payment amount distributed to the relevant beneficiary and the date of transfer (blue cells)"]
[null,"ð","Final Budget (Green row) = Enter your final estimated budget by transferring between cost categories. Whole numbers only.\nPlease note that the total eligible cost and the total EC contribution of the entire consortium may not change !",null,null,null,null,"ð","Pre-financing n°2 or interim : \nIndicate: \n- Total costs incurred by the relevant beneficiary\n- 2nt prefinancing/1st interim payment amount distributed to the relevant beneficiary and the date of transfer (blue cells)"]
[null,"ð","Columns R - budget transfer Variance - will indicate which percentage of the total eligible costs has been transferred between cost categories for the whole project, from the contractual budget to the final budget. \n- The percentage displayed is the one of the transfer between cost categories. \nThis must not exceed 20% of overall eligible costs, otherwise an amendment request had to be submitted at the latest one (1) month before the end of the action",null,null,null,null,"ð","Pre-financing n°3 or interim: \nIndicate: \n- Total costs incurred by the relevant beneficiary\n- 3rt prefinancing/2nd interim payment amount distributed to the relevant beneficiary and the date of transfer (blue cells)"]
[null,null,null,null,null,null,null,"ð","Payment of the balance:\nIndicate:\n-  Total costs incurred by the relevant beneficiary\n-   Payment of the balance amount distributed to the relevant beneficiary and the date of transfer (blue cells) - to be provided 2 months after the payment"]

{"sheet":"COSTS_Summary","index":2,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,18],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,18],[47,3,47,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,13],[46,3,46,8],[41,0,41,3],[42,0,42,3],[44,0,44,3],[46,11,46,13]]}
["COSTS SUMMARY (in €)   -",null,null,null,null,null,{"$f":"Payment_REQUEST!G18:G18&\"   -   \"&Payment_REQUEST!D3","v":"PAYMENT OF THE BALANCE   -   LIFEXX XXX/XX/XXXXXX - ACRONYM"}]
[null,null,null,"Annex III estimated budget versus Final budget (incl. budget transfers) versus Declared costs",null,null,null,null,null,null,null,"PERIOD","From:",{"$f":"Payment_REQUEST!E11:E11","v":"00:00:00"},"To:",{"$f":"Payment_REQUEST!H11:H11","v":"00:00:00"}]
[]
["Participant No.","Participant's short name","Legal status of participant","Costs \ncategory","DIRECT eligible costs with non-recoverable VAT (in €)",null,null,null,null,null,null,null,null,null,"OVERHEADS with non-recoverable VAT \n(in €)","Total ELIGIBLE costs with non-recoverable VAT","TOTAL COSTS with non-recoverable VAT"]
[null,null,null,null,"PERSONNEL","TRAVEL","EXTERNAL ASSISTANCE"," INFRASTRUCTURE","EQUIPMENT","PROTOTYPES","LAND PURCHASE\n/LEASE\n/ONE-OFF Compensation","CONSUMABLES","OTHER direct costs","Sub-total \ndirect eligible costs"]
[1,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E6:M6)","v":0},null,{"$f":"SUM(N6:O6)","v":0}]
[2,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E7:M7)","v":0},null,{"$f":"SUM(N7:O7)","v":0}]
[3,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:M8)","v":0},null,{"$f":"SUM(N8:O8)","v":0}]
[4,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:M9)","v":0},null,{"$f":"SUM(N9:O9)","v":0}]
[5,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:M10)","v":0},null,{"$f":"SUM(N10:O10)","v":0}]
[6,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:M11)","v":0},null,{"$f":"SUM(N11:O11)","v":0}]
[7,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:M12)","v":0},null,{"$f":"SUM(N12:O12)","v":0}]
[8,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:M13)","v":0},null,{"$f":"SUM(N13:O13)","v":0}]
[9,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E14:M14)","v":0},null,{"$f":"SUM(N14:O14)","v":0}]
[10,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:M15)","v":0},null,{"$f":"SUM(N15:O15)","v":0}]
[11,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:M16)","v":0},null,{"$f":"SUM(N16:O16)","v":0}]
[12,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:M17)","v":0},null,{"$f":"SUM(N17:O17)","v":0}]
[13,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E18:M18)","v":0},null,{"$f":"SUM(N18:O18)","v":0}]
[14,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E19:M19)","v":0},null,{"$f":"SUM(N19:O19)","v":0}]
[15,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:M20)","v":0},null,{"$f":"SUM(N20:O20)","v":0}]
[16,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:M21)","v":0},null,{"$f":"SUM(N21:O21)","v":0}]
[17,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E22:M22)","v":0},null,{"$f":"SUM(N22:O22)","v":0}]
[18,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:M23)","v":0},null,{"$f":"SUM(N23:O23)","v":0}]
[19,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:M24)","v":0},null,{"$f":"SUM(N24:O24)","v":0}]
[20,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:M25)","v":0},null,{"$f":"SUM(N25:O25)","v":0}]
[21,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E26:M26)","v":0},null,{"$f":"SUM(N26:O26)","v":0}]
[22,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:M27)","v":0},null,{"$f":"SUM(N27:O27)","v":0}]
[23,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:M28)","v":0},null,{"$f":"SUM(N28:O28)","v":0}]
[24,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:M29)","v":0},null,{"$f":"SUM(N29:O29)","v":0}]
[25,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E30:M30)","v":0},null,{"$f":"SUM(N30:O30)","v":0}]
[26,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E31:M31)","v":0},null,{"$f":"SUM(N31:O31)","v":0}]
[27,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E32:M32)","v":0},null,{"$f":"SUM(N32:O32)","v":0}]
[28,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:M33)","v":0},null,{"$f":"SUM(N33:O33)","v":0}]
[29,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:M34)","v":0},null,{"$f":"SUM(N34:O34)","v":0}]
[30,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E35:M35)","v":0},null,{"$f":"SUM(N35:O35)","v":0}]
[31,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E36:M36)","v":0},null,{"$f":"SUM(N36:O36)","v":0}]
[32,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:M37)","v":0},null,{"$f":"SUM(N37:O37)","v":0}]
[33,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E38:M38)","v":0},null,{"$f":"SUM(N38:O38)","v":0}]
[34,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E39:M39)","v":0},null,{"$f":"SUM(N39:O39)","v":0}]
[35,null,null,"Declared costs",null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:M40)","v":0},null,{"$f":"SUM(N40:O40)","v":0}]
[]
["TOTAL Contractual Budget",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E42:M42)","v":0},null,{"$f":"SUM(N42:O42)","v":0}]
["TOTAL Final Budget",null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"SUM(N43:O43)","v":0},null,{"$f":"P44/P42","v":{"$error":"#DIV/0!"}},{"$f":"IF(R43>0.2,\"Please limit budget shift to max 20%\", \"Ok -> budget shift under 20%\")","v":{"$error":"#DIV/0!"}}]
[null,"Variance",null,null,{"$f":"IF(E43-E42>0,E43-E42,\"-\")","v":"-"},{"$f":"IF(F43-F42>0,F43-F42,\"-\")","v":"-"},"-","-","-","-","-","-","-",0,"-",0]
["TOTAL Declared costs",null,null,null,{"$f":"SUM(E6:E40)","v":0},{"$f":"SUM(F6:F40)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Name of the Person(s) Authorised to sign this Financial Statement",null,null,null,null,null,null,null,"Date and signature"]

{"sheet":"INCOME_Summary","index":3,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,10],[41,0,41,3],[43,1,43,6],[44,1,44,6],[3,4,3,8],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[43,8,43,10],[3,9,4,10]]}
[{"$f":"\"INCOME SUMMARY  -  \"&Payment_REQUEST!G18:G18&\"  -  \"&Payment_REQUEST!D3:D3","v":"INCOME SUMMARY  -  PAYMENT OF THE BALANCE  -  LIFEXX XXX/XX/XXXXXX - ACRONYM"}]
[null,null,null,null,"PERIOD","From:",{"$f":"Payment_REQUEST!E11:E11","v":"00:00:00"},"To:",{"$f":"Payment_REQUEST!H11:H11","v":"00:00:00"}]
[]
["Participant No.","Participant's short name","Legal status of participant","Category","INCOME",null,null,null,null,"PERSONNEL\n\"NON-additional salary costs\"\nwith non-recoverable VAT (in €)\n\nPlease include the above for \"Public Body beneficiaries\"\nin relation to the \"2% rule\""]
[null,null,null,null,"Requested \nUnion \ncontribution","Beneficiary's \nOwn \ncontribution","Co-financer's\ncontribution","Direct \nincome \nof the project","TOTAL\nINCOME"]
[1,{"$f":"COSTS_Summary!B6","v":0},{"$f":"COSTS_Summary!C6","v":0},"INCOME",null,null,null,null,{"$f":"SUM(E6:H6)","v":0},null,{"$f":"IF(C6=\"Public body\",IF(J6>0,\" \",\"<-- Please encode amount\"),\" \")","v":" "}]
[2,{"$f":"COSTS_Summary!B7","v":0},{"$f":"COSTS_Summary!C7","v":0},"INCOME",null,null,null,null,0,null,{"$f":"IF(C7=\"Public body\",IF(J7>0,\" \",\"<-- Please encode amount\"),\" \")","v":" "}]
[3,{"$f":"COSTS_Summary!B8","v":0},{"$f":"COSTS_Summary!C8","v":0},"INCOME",null,null,null,null,0,null,{"$f":"IF(C8=\"Public body\",IF(J8>0,\" \",\"<-- Please encode amount\"),\" \")","v":" "}]
[4,{"$f":"COSTS_Summary!B9","v":0},{"$f":"COSTS_Summary!C9","v":0},"INCOME",null,null,null,null,0,null," "]
[5,{"$f":"COSTS_Summary!B10","v":0},{"$f":"COSTS_Summary!C10","v":0},"INCOME",null,null,null,null,0,null," "]
[6,{"$f":"COSTS_Summary!B11","v":0},{"$f":"COSTS_Summary!C11","v":0},"INCOME",null,null,null,null,0,null," "]
[7,{"$f":"COSTS_Summary!B12","v":0},{"$f":"COSTS_Summary!C12","v":0},"INCOME",null,null,null,null,0,null," "]
[8,{"$f":"COSTS_Summary!B13","v":0},{"$f":"COSTS_Summary!C13","v":0},"INCOME",null,null,null,null,0,null," "]
[9,{"$f":"COSTS_Summary!B14","v":0},{"$f":"COSTS_Summary!C14","v":0},"INCOME",null,null,null,null,0,null," "]
[10,{"$f":"COSTS_Summary!B15","v":0},{"$f":"COSTS_Summary!C15","v":0},"INCOME",null,null,null,null,0,null," "]
[11,{"$f":"COSTS_Summary!B16","v":0},{"$f":"COSTS_Summary!C16","v":0},"INCOME",null,null,null,null,0,null," "]
[12,{"$f":"COSTS_Summary!B17","v":0},{"$f":"COSTS_Summary!C17","v":0},"INCOME",null,null,null,null,0,null," "]
[13,{"$f":"COSTS_Summary!B18","v":0},{"$f":"COSTS_Summary!C18","v":0},"INCOME",null,null,null,null,0,null," "]
[14,{"$f":"COSTS_Summary!B19","v":0},{"$f":"COSTS_Summary!C19","v":0},"INCOME",null,null,null,null,0,null," "]
[15,{"$f":"COSTS_Summary!B20","v":0},{"$f":"COSTS_Summary!C20","v":0},"INCOME",null,null,null,null,0,null," "]
[16,{"$f":"COSTS_Summary!B21","v":0},{"$f":"COSTS_Summary!C21","v":0},"INCOME",null,null,null,null,0,null," "]
[17,{"$f":"COSTS_Summary!B22","v":0},{"$f":"COSTS_Summary!C22","v":0},"INCOME",null,null,null,null,0,null," "]
[18,{"$f":"COSTS_Summary!B23","v":0},{"$f":"COSTS_Summary!C23","v":0},"INCOME",null,null,null,null,0,null," "]
[19,{"$f":"COSTS_Summary!B24","v":0},{"$f":"COSTS_Summary!C24","v":0},"INCOME",null,null,null,null,0,null," "]
[20,{"$f":"COSTS_Summary!B25","v":0},{"$f":"COSTS_Summary!C25","v":0},"INCOME",null,null,null,null,0,null," "]
[21,{"$f":"COSTS_Summary!B26","v":0},{"$f":"COSTS_Summary!C26","v":0},"INCOME",null,null,null,null,0,null," "]
[22,{"$f":"COSTS_Summary!B27","v":0},{"$f":"COSTS_Summary!C27","v":0},"INCOME",null,null,null,null,0,null," "]
[23,{"$f":"COSTS_Summary!B28","v":0},{"$f":"COSTS_Summary!C28","v":0},"INCOME",null,null,null,null,0,null," "]
[24,{"$f":"COSTS_Summary!B29","v":0},{"$f":"COSTS_Summary!C29","v":0},"INCOME",null,null,null,null,0,null," "]
[25,{"$f":"COSTS_Summary!B30","v":0},{"$f":"COSTS_Summary!C30","v":0},"INCOME",null,null,null,null,0,null," "]
[26,{"$f":"COSTS_Summary!B31","v":0},{"$f":"COSTS_Summary!C31","v":0},"INCOME",null,null,null,null,0,null," "]
[27,{"$f":"COSTS_Summary!B32","v":0},{"$f":"COSTS_Summary!C32","v":0},"INCOME",null,null,null,null,0,null," "]
[28,{"$f":"COSTS_Summary!B33","v":0},{"$f":"COSTS_Summary!C33","v":0},"INCOME",null,null,null,null,0,null," "]
[29,{"$f":"COSTS_Summary!B34","v":0},{"$f":"COSTS_Summary!C34","v":0},"INCOME",null,null,null,null,0,null," "]
[30,{"$f":"COSTS_Summary!B35","v":0},{"$f":"COSTS_Summary!C35","v":0},"INCOME",null,null,null,null,0,null," "]
[31,{"$f":"COSTS_Summary!B36","v":0},{"$f":"COSTS_Summary!C36","v":0},"INCOME",null,null,null,null,0,null," "]
[32,{"$f":"COSTS_Summary!B37","v":0},{"$f":"COSTS_Summary!C37","v":0},"INCOME",null,null,null,null,0,null," "]
[33,{"$f":"COSTS_Summary!B38","v":0},{"$f":"COSTS_Summary!C38","v":0},"INCOME",null,null,null,null,0,null," "]
[34,{"$f":"COSTS_Summary!B39","v":0},{"$f":"COSTS_Summary!C39","v":0},"INCOME",null,null,null,null,0,null," "]
[35,{"$f":"COSTS_Summary!B40","v":0},{"$f":"COSTS_Summary!C40","v":0},"INCOME",null,null,null,null,{"$f":"SUM(E40:H40)","v":0},null," "]
[]
["TOTAL",null,null,null,{"$f":"SUM(E6:E40)","v":0},{"$f":"SUM(F6:F40)","v":0},0,0,{"$f":"SUM(E42:H42)","v":0},0,{"$f":"IF(SUMIF(C:C,\"Public body\",F:F)<(J42*1.02),\"Not in line with 2% rule !\",\" \")","v":" "}]
[]
[null,"Name of the Person(s) Authorised to sign this Financial Statement",null,null,null,null,null,null,"Date and signature"]

{"sheet":"CONSOLIDATED_FS","index":4,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,4],[3,1,3,2],[6,1,6,4],[22,0,22,1],[4,1,4,2],[1,0,1,4],[20,0,20,1],[25,0,25,1],[25,2,25,4],[23,0,23,4],[24,0,24,1],[24,2,24,4]]}
["CONSOLIDATED FINANCIAL STATEMENT"]
[{"$f":"Payment_REQUEST!G18","v":"PAYMENT OF THE BALANCE"}]
[]
["PROJECT reference :",{"$f":"Payment_REQUEST!D3:D3","v":"LIFEXX XXX/XX/XXXXXX - ACRONYM"},null,"PERIOD (FROM) :",{"$f":"Payment_REQUEST!E11:E11","v":"00:00:00"}]
["Strand type  :",{"$f":"Payment_REQUEST!D5:D5","v":"CLIMA - CCA"},null,"PERIOD (TO) :",{"$f":"Payment_REQUEST!H11:H11","v":"00:00:00"}]
[]
["Name of COORDINATING beneficiary :",{"$f":"Payment_REQUEST!D7:D7","v":0}]
[]
["Statement of \nEXPENDITURES","Total ELIGIBLE costs\n with non-recoverable VAT (in €)","Statement of \nINCOME (to cover the total cost)","€","% of eligible costs"]
["PERSONNEL",{"$f":"COSTS_Summary!E45","v":0},"Requested Union contribution",{"$f":"INCOME_Summary!E42","v":0},{"$f":"IF($B$20=0,\" \",D10/$B$20)","v":" "}]
["TRAVEL",{"$f":"COSTS_Summary!F45","v":0},"Beneficiary's own contribution",{"$f":"INCOME_Summary!F42","v":0},{"$f":"IF($B$20=0,\" \",D11/$B$20)","v":" "}]
["EXTERNAL ASSISTANCE",{"$f":"COSTS_Summary!G45","v":0},"Co-financer's contribution",{"$f":"INCOME_Summary!G42","v":0}," "]
["Durable goods - INFRASTRUCTURE",{"$f":"COSTS_Summary!H45","v":0},"Direct income of the project",{"$f":"INCOME_Summary!H42","v":0}," "]
["Durable goods - EQUIPMENT",{"$f":"COSTS_Summary!I45","v":0}]
["Durable goods - PROTOTYPES",{"$f":"COSTS_Summary!J45","v":0}]
["LAND PURCHASE/LEASE/ONE-OFF COMPENSATION",{"$f":"COSTS_Summary!K45","v":0}]
["CONSUMABLES",{"$f":"COSTS_Summary!L45","v":0}]
["OTHER direct costs",{"$f":"COSTS_Summary!M45","v":0}]
["OVERHEADS",{"$f":"COSTS_Summary!O45","v":0}]
["TOTAL ELIGIBLE costs",{"$f":"SUM(B10,B11:B19)","v":0},"TOTAL INCOME",{"$f":"SUM(D10:D13)","v":0}]
[]
["TOTAL COSTS\n with non-recoverable VAT (in €)",{"$f":"COSTS_Summary!Q45","v":0},"TOTAL INCOME",{"$f":"D20","v":0},{"$f":"IF(D22<>B22,\"Budget MUST be in balance !\",\" \")","v":" "}]
[]
["We certify that that the information contained in this payment request is full, reliable and true. We also certify that the costs incurred can be considered eligible in accordance with the grant agreement and that: \n- the above costs correspond to the resources employed for the work under the agreement and that those resources were necessary for the work,\n- the costs were incurred and fall within the definition of eligible costs,\n- where necessary, authorisations have been obtained from the EASME, and\n- all the documents supporting the eligible costs reported above, including the time records are available for the purposes of audit by the EASME and its authorised representatives or the Court of Auditors \n  and reflect the costs actually incurred."]
["Name of the Person(s) Authorised to sign this Financial Statement",null,"Date and signature"]

{"sheet":"FUNDS_Distribution","index":5,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,12,43,14],[41,0,41,2],[43,1,43,5],[44,1,44,5],[3,4,3,5],[3,3,4,3],[0,1,0,14],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,9,3,11],[3,12,3,14],[3,6,3,8]]}
[null,{"$f":"\"FUNDS DISTRIBUTION  -  \"&Payment_REQUEST!G18:G18&\"  -  \"&Payment_REQUEST!D3:D3","v":"FUNDS DISTRIBUTION  -  PAYMENT OF THE BALANCE  -  LIFEXX XXX/XX/XXXXXX - ACRONYM"}]
[null,null,null,null,"Financial Statement",null,"From:",{"$f":"Payment_REQUEST!E11:E11","v":"00:00:00"},null,"To:",{"$f":"Payment_REQUEST!H11:H11","v":"00:00:00"}]
[]
["Participant No.","Participant's short name","Legal status of participant","Planned eligible costs for the complete action",{"$f":"IF(Payment_REQUEST!$D$5=\"INTEGRATED PROJECT - IP\",\"Pre-Financing\",\"Pre-Financing n°1\")","v":"Pre-Financing n°1"},null,{"$f":"IF(Payment_REQUEST!$D$5=\"INTEGRATED PROJECT - IP\",\"Interim n°1\",\"Pre-Financing n°2\")","v":"Pre-Financing n°2"},null,null,{"$f":"IF(Payment_REQUEST!$D$5=\"INTEGRATED PROJECT - IP\",\"Interim n°2\",\"Pre-Financing n°3\")","v":"Pre-Financing n°3"},null,null,"PAYMENT OF THE BALANCE"]
[null,null,null,null,"Amount distributed","Date of distribution","TOTAL Costs incurred \n(including overheads)","Amount distributed","Date of distribution","TOTAL Costs incurred \n(including overheads)","Amount distributed","Date of distribution","TOTAL Costs incurred \n(including overheads)","\nAmount distributed","\nDate of distribution"]
[1,{"$f":"COSTS_Summary!B6","v":0},{"$f":"COSTS_Summary!C6","v":0}]
[2,{"$f":"COSTS_Summary!B7","v":0},{"$f":"COSTS_Summary!C7","v":0}]
[3,{"$f":"COSTS_Summary!B8","v":0},{"$f":"COSTS_Summary!C8","v":0}]
[4,{"$f":"COSTS_Summary!B9","v":0},{"$f":"COSTS_Summary!C9","v":0}]
[5,{"$f":"COSTS_Summary!B10","v":0},{"$f":"COSTS_Summary!C10","v":0}]
[6,{"$f":"COSTS_Summary!B11","v":0},{"$f":"COSTS_Summary!C11","v":0}]
[7,{"$f":"COSTS_Summary!B12","v":0},{"$f":"COSTS_Summary!C12","v":0}]
[8,{"$f":"COSTS_Summary!B13","v":0},{"$f":"COSTS_Summary!C13","v":0}]
[9,{"$f":"COSTS_Summary!B14","v":0},{"$f":"COSTS_Summary!C14","v":0}]
[10,{"$f":"COSTS_Summary!B15","v":0},{"$f":"COSTS_Summary!C15","v":0}]
[11,{"$f":"COSTS_Summary!B16","v":0},{"$f":"COSTS_Summary!C16","v":0}]
[12,{"$f":"COSTS_Summary!B17","v":0},{"$f":"COSTS_Summary!C17","v":0}]
[13,{"$f":"COSTS_Summary!B18","v":0},{"$f":"COSTS_Summary!C18","v":0}]
[14,{"$f":"COSTS_Summary!B19","v":0},{"$f":"COSTS_Summary!C19","v":0}]
[15,{"$f":"COSTS_Summary!B20","v":0},{"$f":"COSTS_Summary!C20","v":0}]
[16,{"$f":"COSTS_Summary!B21","v":0},{"$f":"COSTS_Summary!C21","v":0}]
[17,{"$f":"COSTS_Summary!B22","v":0},{"$f":"COSTS_Summary!C22","v":0}]
[18,{"$f":"COSTS_Summary!B23","v":0},{"$f":"COSTS_Summary!C23","v":0}]
[19,{"$f":"COSTS_Summary!B24","v":0},{"$f":"COSTS_Summary!C24","v":0}]
[20,{"$f":"COSTS_Summary!B25","v":0},{"$f":"COSTS_Summary!C25","v":0}]
[21,{"$f":"COSTS_Summary!B26","v":0},{"$f":"COSTS_Summary!C26","v":0}]
[22,{"$f":"COSTS_Summary!B27","v":0},{"$f":"COSTS_Summary!C27","v":0}]
[23,{"$f":"COSTS_Summary!B28","v":0},{"$f":"COSTS_Summary!C28","v":0}]
[24,{"$f":"COSTS_Summary!B29","v":0},{"$f":"COSTS_Summary!C29","v":0}]
[25,{"$f":"COSTS_Summary!B30","v":0},{"$f":"COSTS_Summary!C30","v":0}]
[26,{"$f":"COSTS_Summary!B31","v":0},{"$f":"COSTS_Summary!C31","v":0}]
[27,{"$f":"COSTS_Summary!B32","v":0},{"$f":"COSTS_Summary!C32","v":0}]
[28,{"$f":"COSTS_Summary!B33","v":0},{"$f":"COSTS_Summary!C33","v":0}]
[29,{"$f":"COSTS_Summary!B34","v":0},{"$f":"COSTS_Summary!C34","v":0}]
[30,{"$f":"COSTS_Summary!B35","v":0},{"$f":"COSTS_Summary!C35","v":0}]
[31,{"$f":"COSTS_Summary!B36","v":0},{"$f":"COSTS_Summary!C36","v":0}]
[32,{"$f":"COSTS_Summary!B37","v":0},{"$f":"COSTS_Summary!C37","v":0}]
[33,{"$f":"COSTS_Summary!B38","v":0},{"$f":"COSTS_Summary!C38","v":0}]
[34,{"$f":"COSTS_Summary!B39","v":0},{"$f":"COSTS_Summary!C39","v":0}]
[35,{"$f":"COSTS_Summary!B40","v":0},{"$f":"COSTS_Summary!C40","v":0}]
[]
["TOTAL",null,null,{"$f":"SUM(D6:D40)","v":0},{"$f":"SUM(E6:E40)","v":0},null,0,0,null,0,0,null,0,0]
[]
[null,"Name of the Person(s) Authorised to sign this Financial Statement",null,null,null,null,null,null,null,null,null,null,"Date and signature"]

{"sheet":"Values","index":6,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["Key Action(s)",null,"Gender",null,"ST_NAME","ISO_2",null,"DurationMonths","Year1",null,"Legal Status"]
["Energy-efficient buildings (SAVE)",null,"Ms",null,"Austria","AT",null,12,2006,null,"Governmental","GOV"]
["Industrial excellence in energy (SAVE)",null,"Mr",null,"Belgium","BE",null,13,2005,null,"Public Commercial Organisation","PUC"]
["Energy-efficient products (SAVE)",null,null,null,"Bulgaria","BG",null,14,2004,null,"Private Non-profit making organisation","PNP"]
["Electricity from renewable energy sources (RES-e) (ALTENER)",null,"YesNo",null,"Croatia","HR",null,15,2003,null,"Private Commercial Organisation","PRC"]
["Renewable energy heating/cooling (RES-H/C) (ALTENER)",null,"Yes",null,"Cyprus","CY",null,16,2002,null,"European Economic Interest Group","EEIG"]
["Domestic and other small-scale RE applications (ALTENER)",null,"No",null,"Czech Republic","CZ",null,17,null,null,"International Organisation","INO"]
["Biofuels (ALTENER)",null,null,null,"Denmark","DK",null,18,null,null,"Other","OTH"]
["Alternative fuels and clean vehicles (STEER)",null,null,null,"Estonia","EE",null,19,"Year2"]
["Energy-efficient transport (STEER)",null,"Program",null,"Finland","FI",null,20,2006,null,"Type of organisation"]
["European networking for local action (Integrated Initiative)",null,"IEE PROGRAMME  ",null,"France","FR",null,21,2005,null,"Public Authority "]
["Sustainable energy communities (Integrated Initiative)",null,null,null,"Germany","DE",null,22,2004,null,"Regulatory / Standardisation Body"]
["Bio-business initiative (Integrated Initiative)",null,"Call Year",null,"Greece","GR",null,23,null,null,"(Renewable) Energy Supplier"]
["Energy services initiative (Integrated Initiative)",null,"Call for proposals 2008",null,"Hungary","HU",null,24,null,null,"Public Transport Operator"]
["Intelligent energy education initiative (Integrated Initiative)",null,null,null,"Iceland","IS",null,25,null,null,"Supplier of Technology / Products / Services"]
["Combined heat and power initiative (Integrated Initiative)",null,"Call Name",null,"Ireland","IE",null,26,null,null,"Research Organisation / University"]
[null,null,"Call Identifier: CIP-IEE-2008",null,"Italy","IT",null,27,null,null,"Educational Body / Vocational Training Centre"]
[null,null,null,null,"Latvia","LV",null,28,null,null,"Communication / Media"]
[null,null,"Agency",null,"Liechtenstein","FL",null,29,null,null,"Energy Agency"]
[null,null,"Executive Agency for Competitiveness and Innovation (EACI)",null,"Lithuania","LT",null,30,null,null,"Energy / Transport Consultant"]
[null,null,null,null,"Luxemburg","LU",null,31,null,null,"Business (industry / service sector, please specify further)"]
[null,null,null,null,"Malta","MT",null,32,null,null,"Financing Institution"]
[null,null,"YesNo2",null,"Norway","NO",null,33,null,null,"Interest Group / Trade Association (industry, consumer, building owners, environment, etc.)"]
[null,null,"No, never",null,"Poland","PL",null,34,null,null,"Other"]
[null,null,"Yes, few times (<10 times)",null,"Portugal","PT",null,35]
[null,null,"Yes, regularly (>10 times)",null,"Romania","RO",null,36]
[null,null,null,null,"Slovakia","SK"]
[null,null,"YesNo3",null,"Slovenia","SI"]
[null,null,"No, never",null,"Spain","ES"]
[null,null,"Yes, few times (<5 times)",null,"Sweden","SE"]
[null,null,"Yes, regularly (>5 times)",null,"The Netherlands","NL"]
[null,null,null,null,"United Kingdom","UK"]

{"sheet":"LIST","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Strand types",null,null,"Legal types"]
["CAPACITY BUILDING - CAP",null,null,"Public body"]
["CLIMA - CCA",null,null,"Private commercial"]
["CLIMA - CCM",null,null,"Private NON-commercial"]
["CLIMA - GIC"]
["ENVIRONMENT - ENV"]
["ENVIRONMENT - GIE"]
["ENVIRONMENT - NAT"]
["TECHNICAL ASSISTANCE - TA"]
["INTEGRATED PROJECT - IP"]