{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["JPK-Nagłówek","JPK-Lista faktur","JPK-Pozycje faktur","Parametry","techniczne"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":110,"comments":5,"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":"JPK-Nagłówek","index":0,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,8,3,15],[10,8,10,11],[13,8,13,9],[14,8,14,9],[7,8,7,11],[11,8,11,11],[12,8,12,11]]}
[null,null,null,null,null,"JPK_FA"]
[null,null,null,{"$f":"DataWytworzenia()","v":"2023-05-29T17:05:46"}]
[]
[null,null,"Cel złożenia:",null,null,null,null,"Pełna nazwa podmiotu:"]
[null,null,null,null,null,null,null,"NIP:",""]
[null,null,"Data od:",null,null,null,null,"REGON:",""]
[null,null,"Data do:"]
[null,null,null,null,null,null,null,"Ulica:"]
[null,null,"Domyślny kod waluty:",null,null,null,null,"Nr domu:","","Nr lokalu:",""]
[null,null,null,null,null,null,null,"Kod pocztowy:"]
[null,null,"Kod urzędu skarbowego:",null,null,null,null,"Miejscowość:"]
[null,null,null,null,null,null,null,"Poczta:"]
[null,null,null,null,null,null,null,"Gmina:"]
[null,null,null,null,null,null,null,"Powiat:"]
[null,null,null,null,null,null,null,"Województwo:"]
[]
[]
[null,"Pola obowiązkowe:"]
[null,"Pola opcjonalne:"]

{"sheet":"JPK-Lista faktur","index":1,"n_rows":6,"n_cols":55,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":""},{"$f":"IF(E7=\"\",\"\",SUBTOTAL(5,E7:E1048576))","v":""},null,null,"Liczba faktur:",{"$f":"SUBTOTAL(3,E7:E1048576)","v":0}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":""},{"$f":"IF(E7=\"\",\"\",SUBTOTAL(4,E7:E1048576))","v":""},null,null,"Wartość faktur:",{"$f":"AB4","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,P7:P1048576)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,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,{"$f":"SUBTOTAL(9,BB7:BB1048576)","v":0},0]
[]
[null,null,null,"Błąd","P 1","P 2A","P 3A","P 3B","P 3C","P 3D","P 4A","P 4B","P 5A","P 5B","P 6","P 13 1","P 14 1","P 13 2","P 14 2","P 13 3","P 14 3","P 13 4","P 14 4","P 13 5","P 14 5","P 13 6","P 13 7","P 15","P 16","P 17","P 18","P 19","P 19A","P 19B","P 19C","P 20","P 20A","P 20B","P 21","P 21A","P 21B","P 21C","P 22A","P 22B","P 22C","P 23","P 106E 2","P 106E 3","P 106E 3A","Rodzaj Faktury","Przyczyna korekty","Nr fa. korygowanej","Okres fa. Korygowanej","ZAL. Zapłata","ZAL. Podatek"]

{"sheet":"JPK-Pozycje faktur","index":2,"n_rows":6,"n_cols":14,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":""},null,null,"Liczba wierszy:",{"$f":"SUBTOTAL(3,E7:E1048576)","v":0}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":""},null,null,"Wartość wierszy",{"$f":"L4","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,L7:L1048576)","v":0},{"$f":"SUBTOTAL(9,M7:M1048576)","v":0}]
[]
[null,null,null,"Błąd","P 2B","P 7","P 8A","P 8B","P 9A","P 9B","P 10","P 11","P 11A","P 12"]

{"sheet":"Parametry","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rozszerzenie pliku importu:"]
[]
[]
[null,"Arkusz","Komponent obsługujący import"]
[null,"JPK-Lista faktur","brak"]
[null,"JPK-Pozycje faktur","brak"]
[]
[]
[null,"Modyfikuj pola sumaryczne",0]

{"sheet":"techniczne","index":4,"n_rows":108,"n_cols":20,"rows_kept":108,"cut":false,"hidden":true,"merged":[[101,14,101,15],[101,16,101,17],[102,14,102,15],[102,16,102,17],[103,14,103,15],[103,16,103,17],[107,14,107,15],[107,16,107,17],[104,14,104,15],[104,16,104,17],[105,14,105,15],[105,16,105,17],[106,14,106,15],[106,16,106,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elementy list","Numery automat:","Nr obowiązkowej kolumny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faktura",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FakturaWiersz",null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XED","#4507"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSD:","http://www.mf.gov.pl/documents/764034/5134536/Schemat_JPK_FA%281%29_v1-0.xsd"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namespace:","http://jpk.mf.gov.pl/wzor/2016/03/09/03095/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroToEmpty",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroFollowsFields:","P_14_1,P_14_2,P_14_3,P_14_4,P_14_5"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dodatkowe testy merytoryczne podczas Importu i dopisywania (Append):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprawdź podczas importu","Sprawdź podczas dołączania","Wykonać przed walidacją XSD?","Węzeł z porównywaną wartością (wyrażenie Xpath) (uruchamiane dla DocumentNode)","Oczekiwana wartość","Komunikat o ewentualnym błędzie (Wpisz {Val} tam, gdzie ma być podstawiona wartość z importowanego dokumentu)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},"jpk:Naglowek/jpk:KodFormularza","JPK_FA",{"$f":"\"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być '\" & S16 & \"'\"","v":"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_FA'"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Podmiot1/jpk:IdentyfikatorPodmiotu/etd:NIP",{"$f":"NIP","v":""},{"$f":"\"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: \" &S17 & \")\"","v":"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: )"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataOd",{"$f":"TEXT(DataOd,\"rrrr-MM-dd\")","v":"1900-01-00"},{"$f":"\"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (\" & S18 & \")\"","v":"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (1900-01-00)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataDo",{"$f":"TEXT(DataDo,\"rrrr-MM-dd\")","v":"1900-01-00"},{"$f":"\"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (\" & S19 & \")\"","v":"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (1900-01-00)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa skoroszytu:",null,"JPK_FA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer seryjny:",null,"EVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer edycji:",null,1.58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wygenerowano:",null,"2023-05-29T17:05:47"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komunikaty w oknach dialogowych",null,"00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Specyficzne dla tego skoroszytu:"]
["Wartości logiczne:",null,0,1,"tak","nie",true,false,null,null,null,null,null,null,"Schematy, używane gdy nie można użyć wersji online z Ministerstwa Finansów:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa ramki",null,"Przestrzeń nazw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyCechyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2013/05/23/eD/KodyCECHKRAJOW/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UrzedySkarbowe",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ElementarneTypyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StrukturyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2016/01/25/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JPK",null,{"$f":"JPK_Namespace","v":"http://jpk.mf.gov.pl/wzor/2016/03/09/03095/"}]