{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Zestawienie płatności z WoP ","paragrady budzetowe ","Arkusz2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Zestawienie płatności z WoP ","index":0,"n_rows":41,"n_cols":19,"rows_kept":41,"cut":false,"hidden":false,"merged":[[2,6,2,16],[12,3,13,3],[12,4,13,4],[11,14,13,14],[36,1,36,16],[35,1,35,16],[12,6,13,6],[11,15,13,15],[0,1,0,17],[12,11,13,11],[6,6,6,16],[4,6,4,16],[8,6,8,16],[12,7,12,10],[12,1,13,1],[12,2,13,2],[12,5,13,5],[11,12,13,12],[11,13,13,13],[11,16,13,16]]}
[null,"Zestawienie płatności w poszczególnych wnioskach o płatność wraz ze wskazaniem źródeł finansowania - MF EOG 2014-2021"]
[]
[null,"Umowa ws Projektu nr"]
[]
[null,"Nazwa Beneficjenta"]
[]
[null,"Tytuł projektu"]
[]
[null,"Nabór w ramach którego realizowany jest projekt ",null,null,null,null,"Poprawa efektywności energetycznej w budynkach szkolnych"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Maksymalny % zwiększenia dofinansowania  ","Max. kwota zwiększena dofinansowania ","Kwota dofinansowania możliwa do wypłaty","Kwota dofinansowania po zmianie","% dofinansowania  po zwiększeniu"]
[null,"Nr wniosku o płatność *","Numer techniczny GWD zatwierdzonego WoP**","Wydatki kwalifikowane \nwg umowy obowiązującej na dzień złożenia pierwszej wersji  wniosku o płatność","Dofinansowanie wg umowy obowiązującej na dzień złożenia pierwszej wersji wniosku o płatność","Koszty uznane za  kwalifikowane  w zatwierdzonym wniosku o płatność  ","% dofinansowania                wg. UwP","Źródła finansowania kosztów kwalfikowanych",null,null,null,"Suma",null,null,null,"Kwota dofinansowania po zmianie"]
[null,null,null,null,null,null,null,"Dotacja (MF EOG i budżet państwa)","Środki własne beneficjenta ","Współfinansowanie NFOŚiGW (pożyczka)","Inne krajowe środki publiczne (dotacje, pożyczki umażalne)"]
[null,1,2,null,null,3,4,5,6,7,8,"9=5+6+7+8",10,11,12,13,14]
[null,null,null,null,null,null,{"$f":"IFERROR(ROUND(E16/D16,15),\"\")","v":""},null,null,null,null,{"$f":"IF(H16>0,SUM(H16:K16),\"\")","v":""},{"$f":"IFERROR(IF(G16>0,82%-G16,\"\"),\"\")","v":""},{"$f":"IFERROR(ROUNDDOWN(F16*M16,2),\"\")","v":""},{"$f":"IFERROR(IF(G16>0,IF(IF(N16<=(F16-(ROUNDUP(L16*0.12,2)+K16)-H16),N16,F16-(ROUNDUP(L16*0.12,2)+K16)-H16)>0,IF(N16<=F16-(ROUNDUP(L16*0.12,2)+K16)-H16,N16,F16-(ROUNDUP(L16*0.12,2)+K16)-H16),0),\"\"),\"\")","v":""},{"$f":"ROUNDDOWN((F16*Q16),2)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(G16>0,IF(O16>0,(ROUNDUP((O16+H16)/F16,15)),G16),\"\"),\"\")","v":""},null,{"$f":"IF(L16=F16,\"ok\",\"suma źródeł finansowania kol. J nie jest równa wydatkom kwalifikowanym kol. D\")","v":"ok"}]
[null,null,null,null,null,null,{"$f":"IFERROR(ROUND(E17/D17,15),\"\")","v":""},null,null,null,null,{"$f":"IF(H17>0,SUM(H17:K17),\"\")","v":""},{"$f":"IFERROR(IF(G17>0,82%-G17,\"\"),\"\")","v":""},"",{"$f":"IFERROR(IF(G17>0,IF(IF(N17<=(F17-(ROUNDUP(L17*0.12,2)+K17)-H17),N17,F17-(ROUNDUP(L17*0.12,2)+K17)-H17)>0,IF(N17<=F17-(ROUNDUP(L17*0.12,2)+K17)-H17,N17,F17-(ROUNDUP(L17*0.12,2)+K17)-H17),0),\"\"),\"\")","v":""},{"$f":"ROUNDDOWN((F17*Q17),2)","v":{"$error":"#VALUE!"}},"",null,{"$f":"IF(L17=F17,\"ok\",\"suma źródeł finansowania kol. J nie jest równa wydatkom kwalifikowanym kol. D\")","v":"ok"}]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,null,null,null,null,null,"",null,null,null,null,"","","","",{"$error":"#VALUE!"},"",null,"ok"]
[null,"RAZEM",null,null,null,{"$f":"SUM(F16:F29)","v":0},null,{"$f":"SUM(H16:H29)","v":0},{"$f":"SUM(I16:I29)","v":0},0,0,{"$f":"SUM(L16:L29)","v":0},null,{"$f":"SUM(N16:N29)","v":0},{"$f":"SUM(O16:O29)","v":0},{"$f":"SUM(P16:P29)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[null,"Podpis Beneficjent, kontrasygnata skarbnika"]
[]
[]
[]
[null,"* Należy podać numery wniosków o płatność typu: refundacja oraz rozliczający otrzymaną zaliczkę i dla nich podać dane finansowe"]
[null,"** Należy podać numer techniczy ostatniej (zawierdzonej) wersji wniosku o płatność"]

{"sheet":"paragrady budzetowe ","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Źródło finansowania","Obszar","Typ podmiotu","Klasyfikacja wg budżetu zadaniowego","Skrót","Paragraf klasyfikacji"]
[null,null,null,null,"Proszę wybrać","Proszę wybrać",null,"wybierz"]
["EOG","SRODOWISKO","POZOSTAŁE","12.2.1.1","EOG / SRO / POZ","51.900.90011.2007",null,"Tak"]
["EOG","SRODOWISKO","JST","12.2.1.1","EOG / SRO / JST","51.900.90011.2057",null,"Nie"]
["EOG","ENERGETYKA","POZOSTAŁE","12.3.1.3","EOG / ENE / POZ","51.900.90011.6207",null,"n/d"]
["EOG","ENERGETYKA","JST","12.3.1.3","EOG / ENE / JST","51.900.90011.6257"]
["EOG","KLIMAT","POZOSTAŁE","12.5.1.2","EOG / KLI / POZ","51.900.90011.6207"]
["EOG","KLIMAT","JST","12.5.1.2","EOG / KLI / JST","51.900.90011.6257"]
["EOG","FWD","POZOSTAŁE","17.2.1.1","EOG / FWD / POZ","51.900.90011.2007"]
["EOG","FWD","JST","17.2.1.1","EOG / FWD / JST","51.900.90011.2057"]
[null,null,null,null,"Proszę wybrać","Proszę wybrać"]
[null,null,null,null,"nie dotyczy","nie dotyczy"]
["BP","SRODOWISKO","POZOSTAŁE","12.2.1.1","BP / SRO / POZ","51.900.90011.2006"]
["BP","SRODOWISKO","JST","12.2.1.1","BP / SRO / JST","51.900.90011.2056"]
["BP","ENERGETYKA","POZOSTAŁE","12.3.1.3","BP / ENE / POZ","51.900.90011.6206"]
["BP","ENERGETYKA","JST","12.3.1.3","BP / ENE / JST","51.900.90011.6256"]
["BP","KLIMAT","POZOSTAŁE","12.5.1.2","BP / KLI / POZ","51.900.90011.6206"]
["BP","KLIMAT","JST","12.5.1.2","BP / KLI / JST","51.900.90011.6256"]
[null,null,null,null,"Proszę wybrać","Proszę wybrać"]
[null,null,null,null,"nie dotyczy","nie dotyczy"]
["NMF","FWD","POZOSTAŁE","17.2.1.1","NMF / FWD / POZ","51.900.90011.2007"]
["NMF","FWD","JST","17.2.1.1","NMF / FWD / JST","51.900.90011.2057"]

{"sheet":"Arkusz2","index":2,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Obszar"]
["wybierz"]
["ENV-Środowisko"]
["CLI-ZmKlimatu"]
["EEF-EfektywnośćEnergetyczna"]
["RES-OZE"]
["FWD"]
[]
[]
[]
["TAK"]
["NIE"]