{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["JPK-Nagłówek","JPK-Lista PZ","JPK-Pozycje PZ","JPK-Lista WZ","JPK-Pozycje WZ","JPK-Lista RW","JPK-Pozycje RW","JPK-Lista MM","JPK-Pozycje MM","Parametry","techniczne"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":125,"comments":11,"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_MAG"]
[null,null,null,{"$f":"DataWytworzenia()","v":"2020-09-18T15:22:00"}]
[]
[null,null,"Cel złożenia:",1,null,null,null,"Pełna nazwa podmiotu:","Pełna nazwa przedsiębiorstwa"]
[null,null,null,null,null,null,null,"NIP:","1111111111"]
[null,null,"Data od:","2015-08-01",null,null,null,"REGON:","000000000"]
[null,null,"Data do:","2015-08-31"]
[null,null,null,null,null,null,null,"Ulica:","Magnoliowa"]
[null,null,"Domyślny kod waluty:","PLN",null,null,null,"Nr domu:","12","Nr lokalu:",""]
[null,null,null,null,null,null,null,"Kod pocztowy:","62-052"]
[null,null,"Kod urzędu skarbowego:","3023",null,null,null,"Miejscowość:","Komorniki"]
[null,null,null,null,null,null,null,"Poczta:","Komorniki"]
[null,null,null,null,null,null,null,"Gmina:","Komorniki"]
[null,null,"Magazyn:","12N",null,null,null,"Powiat:","Poznań"]
[null,null,null,null,null,null,null,"Województwo:","Wielkopolskie"]
[]
[]
[null,"Pola obowiązkowe:"]
[null,"Pola opcjonalne:"]

{"sheet":"JPK-Lista PZ","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(5,G8:G1048576))","v":"2016-05-04"},null,null,"Liczba dokumentów:",{"$f":"SUBTOTAL(3,F8:F1048576)","v":3}]
[null,null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(4,G8:G1048576))","v":"2016-05-30"},null,null,"Wartość dokumentów:",{"$f":"H5","v":21063.05}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,H8:H1048576)","v":21063.05}]
[]
[null,null,null,null,"Błąd","Numer PZ","Data PZ","Wartość PZ","Data przyjęcia PZ","Dostawca","Numer faktury zakupu związanej z PZ","Data faktury zakupu"]
[null,null,null,null,null,"1163786","2016-05-04",20092.27,"2016-05-04","T500000559","104852834"]
[null,null,null,null,null,"1165968","2016-05-06",796,"2016-05-06","T000013005","160301050083"]
[null,null,null,null,null,"1166525","2016-05-30",174.78,"2016-05-30","T000018747","18262/03/16"]

{"sheet":"JPK-Pozycje PZ","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K7:K1048576)","v":21063.05}]
[]
[null,null,null,"Błąd","Numer PZ","Kod towaru","Nazwa towaru","Ilość przyjęta","Jedn. miary","Cena jednostkowa","Wartość pozycji"]
[null,null,null,null,"1163786","GROH-995854","Zestaw baterii Bauedge",50,"KPL",401.85,20092.27]
[null,null,null,null,"1165968","ALTH-157258","ALPERT-Rura 32x3,0 kręg 50m",100,"M",7.96,796]
[null,null,null,null,"1166525","FERR-995630","Zlew.1-kom.b/o gładki + syfon",2,"SZT",87.39,174.78]

{"sheet":"JPK-Lista WZ","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(5,G8:G1048576))","v":"2016-05-11"},null,null,"Liczba dokumentów:",{"$f":"SUBTOTAL(3,F8:F1048576)","v":3}]
[null,null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(4,G8:G1048576))","v":"2016-05-19"},null,null,"Wartość dokumentów:",{"$f":"H5 + IF(LiczbaWZ > 0, 0.00000001, 0)","v":-2755.09999999}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,H8:H1048576)","v":-2755.1}]
[]
[null,null,null,null,"Błąd","Numer WZ","Data WZ","Wartość WZ","Data wydania WZ","Odbiorca","Numer faktury sprzedaży związanej z WZ","Data faktury sprzedaży"]
[null,null,null,null,null,"0005197125","2016-05-19",262.14999999999998,"2016-05-19","T500124677","167009030","2016-05-19"]
[null,null,null,null,null,"0005302920","2016-05-19",-530,"2016-05-19","T000002059","160085280","2016-05-19"]
[null,null,null,null,null,"0005414370","2016-05-11",-2487.25,"2016-05-11","T510107016","160079563","2016-05-11"]

{"sheet":"JPK-Pozycje WZ","index":4,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K7:K1048576)","v":-2755.1}]
[]
[null,null,null,"Błąd","Numer WZ","Kod towaru","Nazwa towaru","Ilość wydana","Jedn. miary","Cena jednostkowa","Wartość pozycji"]
[null,null,null,null,"0005197125","ALTN-124484","Miska ustęp.wisz.b/pół.",1,"SZT",262.14999999999998,262.14999999999998]
[null,null,null,null,"0005302920","SCHP-014022","Obud.brodz.styrop.90x90x16",-10,"SZT",53,-530]
[null,null,null,null,"0005414370","ALTH-158498","Płytka naścienna",-1,"SZT",22.67,-22.67]
[null,null,null,null,"0005414370","CUXX-970202","Cu-Rura twarda 15x1,0",-200,"M",7.86,-1571.01]
[null,null,null,null,"0005414370","INTS-962271","Deska sedesowa twarda",-3,"SZT",24.61,-73.83]
[null,null,null,null,"0005414370","KOŁO-980355","Miska ustęp.wisz.b/pół.",-1,"SZT",130.30000000000001,-130.30000000000001]
[null,null,null,null,"0005414370","STAL-970303","Rura stal.czarna z/szw.Dn  20",-36,"M",4.07,-146.53]
[null,null,null,null,"0005414370","STAL-970306","Rura stal.czarna z/szw.Dn  25",-24,"M",5.58,-133.94999999999999]
[null,null,null,null,"0005414370","STAL-970310","Rura stal.czarna z/szw.Dn  32",-24,"M",7.14,-171.27]
[null,null,null,null,"0005414370","STAL-970411","Rura stal.ocynk. z/szw.Dn  15",-24,"M",5.14,-123.31]
[null,null,null,null,"0005414370","ZOOM-965618","Miska ustęp.wisz.b/pół.",-1,"SZT",114.38,-114.38]

{"sheet":"JPK-Lista RW","index":5,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(5,G8:G1048576))","v":"2016-05-05"},null,null,null,"Liczba dokumentów:",{"$f":"SUBTOTAL(3,F8:F1048576)","v":5}]
[null,null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"},{"$f":"IF(G8=\"\",\"\",SUBTOTAL(4,G8:G1048576))","v":"2016-05-20"},null,null,null,"Wartość dokumentów:",{"$f":"H5 + IF(LiczbaRW > 0, 0.00000001, 0)","v":-9644.0399999900001}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,H8:H1048576)","v":-9644.0400000000009}]
[]
[null,null,null,null,"Błąd","Numer RW","Data RW","Wartość RW","Data wydania RW","Skąd","Dokąd"]
[null,null,null,null,null,"41:0001804473","2016-05-05",-1935.1,"2016-05-05"]
[null,null,null,null,null,"41:0001804474","2016-05-05",-6212.3,"2016-05-05"]
[null,null,null,null,null,"41:0001809652","2016-05-17",-1542.53,"2016-05-17"]
[null,null,null,null,null,"98:0000173765","2016-05-06",0,"2016-05-06"]
[null,null,null,null,null,"różnice inwent.","2016-05-20",45.89,"2016-05-20"]

{"sheet":"JPK-Pozycje RW","index":6,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K7:K1048576)","v":-9644.0399999999972}]
[]
[null,null,null,"Błąd","Numer RW","Kod towaru","Nazwa towaru","Ilość wydana","Jedn. miary","Cena jednostkowa","Wartość pozycji"]
[null,null,null,null,"41:0001804473","GALM-680840","Kocioł pal.stałe 11kW",-1,"SZT",1935.1,-1935.1]
[null,null,null,null,"41:0001804474","GALM-215316","Kocioł pal.stałe 25kW",-1,"SZT",6212.3,-6212.3]
[null,null,null,null,"41:0001809652","FERR-101524","Mimośród do baterii",-34,"SZT",12.12,-412.08]
[null,null,null,null,"41:0001809652","FERR-102248","Zawór kul.wod.DN28",-5,"SZT",21.33,-106.67]
[null,null,null,null,"41:0001809652","FERR-103037","Zawór kul.wod.DN18",-30,"SZT",8.92,-267.51]
[null,null,null,null,"41:0001809652","FERR-103038","Zawór kul.wod.DN22",-20,"SZT",13.03,-260.67]
[null,null,null,null,"41:0001809652","FERR-169432","Reduktor ciśn. wody 1/2\"",-5,"SZT",99.12,-495.6]
[null,null,null,null,"98:0000173765","FLOW-182208","Nagrzewnica wodna LEO FB zesta",1,"SZT",551.6,551.6]
[null,null,null,null,"98:0000173765","FLOW-196229","Aparat grzew-went.",-1,"SZT",551.6,-551.6]
[null,null,null,null,"różnice inwent.","AFRI-042252","Manometr 100/0-0,6MPa rad",-3,"SZT",19.07,-57.21]
[null,null,null,null,"różnice inwent.","AFRI-042253","Manometr  80/0-1,0MPa rad",-1,"SZT",18.309999999999999,-18.309999999999999]
[null,null,null,null,"różnice inwent.","AFRI-050296","Termometr tarcz.120°C-T 80St",-1,"SZT",9.9,-9.9]
[null,null,null,null,"różnice inwent.","AFRI-050297","Manometr  63/0-0,6MPa rad",3,"SZT",7.77,23.32]
[null,null,null,null,"różnice inwent.","AFRI-053649","Termomanometr  80/0-0,4MPa",-2,"SZT",34.35,-68.7]
[null,null,null,null,"różnice inwent.","AFRI-340004","Kurek manometryczny 1/2\"",-6,"SZT",19.11,-114.67]
[null,null,null,null,"różnice inwent.","AFRI-340005","Manometr 100/0-1,0MPa rad",-2,"SZT",18.93,-37.86]
[null,null,null,null,"różnice inwent.","AFRI-643936","Odpowietrznik autom.15 (1/2\")",77,"SZT",14.8,1139.56]
[null,null,null,null,"różnice inwent.","AFRI-644271","Kurek manometryczny 2x1/4\"GW",6,"SZT",14,83.98]
[null,null,null,null,"różnice inwent.","AFRI-649484","Manometr 100/0-0,25MPa rad",1,"SZT",19.61,19.61]
[null,null,null,null,"różnice inwent.","AFRI-659056","Termomanometr 80/0-0,4MPa",6,"SZT",35.75,214.51]
[null,null,null,null,"różnice inwent.","AFRI-705613","Zawór bezp.DN15 (1/2\")- 6,7bar",-1,"SZT",9.98,-9.98]
[null,null,null,null,"różnice inwent.","AFRI-725867","Zawór napełniający 1/2\"",-3,"SZT",12.22,-36.67]
[null,null,null,null,"różnice inwent.","AFRI-952633","Odpowietrznik autom.15 (1/2\")",-75,"SZT",14.5,-1087.5]
[null,null,null,null,"różnice inwent.","AFRI-982340","Zawór bezp.DN20 (3/4\")- 6,7bar",1,"SZT",13.64,13.64]
[null,null,null,null,"różnice inwent.","NIBC-001021","N-ZW Kolano 1/2\"",-4,"SZT",0.79,-3.16]
[null,null,null,null,"różnice inwent.","NIBC-001022","N-ZW Kolano 3/4\"",21,"SZT",0.8,16.8]
[null,null,null,null,"różnice inwent.","NIBC-001023","N-ZW Kolano 1\"",6,"SZT",1.48,8.8800000000000008]
[null,null,null,null,"różnice inwent.","NIBC-001027","N-ZW Kolano nypl.1/2\"",6,"SZT",2.2200000000000002,13.32]
[null,null,null,null,"różnice inwent.","NIBC-001033","N-ZW Kolano gwint.1/2\"",49,"SZT",1.03,50.45]
[null,null,null,null,"różnice inwent.","NIBC-001041","N-ZW Złączka 1/2\"",11,"SZT",0.54,5.93]
[null,null,null,null,"różnice inwent.","NIBC-001042","N-ZW Złączka 3/4\"",4,"SZT",0.78,3.12]
[null,null,null,null,"różnice inwent.","NIBC-001043","N-ZW Złączka 1\"",1,"SZT",1.27,1.27]
[null,null,null,null,"różnice inwent.","NIBC-001048","N-CW Kolano metalowe 1/2\"",1,"SZT",5.38,5.38]
[null,null,null,null,"różnice inwent.","NIBC-001048","N-CW Kolano metalowe 1/2\"",-4,"SZT",5.38,-21.53]
[null,null,null,null,"różnice inwent.","NIBC-001050","N-ZW Rura Sch 40 1/2\"",8,"SZT",6.18,49.44]
[null,null,null,null,"różnice inwent.","NIBC-001051","N-ZW Rura Sch 40 3/4\"",2,"SZT",8.2200000000000006,16.440000000000001]
[null,null,null,null,"różnice inwent.","NIBC-001052","N-ZW Rura Sch 40 1\"",-1,"SZT",13.58,-13.58]
[null,null,null,null,"różnice inwent.","NIBC-001052","N-ZW Rura Sch 40 1\"",2,"SZT",13.58,27.17]
[null,null,null,null,"różnice inwent.","NIBC-001058","N-ZW Trójnik 1/2\"",-4,"SZT",0.93,-3.72]
[null,null,null,null,"różnice inwent.","NIBC-001075","N-ZW Tuleja red.6/4\"x1\"",2,"SZT",1.89,3.78]
[null,null,null,null,"różnice inwent.","NIBC-001076","N-CW Kolano nypl.1/2\"",-5,"SZT",0.93,-4.6399999999999997]
[null,null,null,null,"różnice inwent.","NIBC-001084","N-ZW Złączka gwint.1/2\"",14,"SZT",0.9,12.64]
[null,null,null,null,"różnice inwent.","NIBC-001085","N-ZW Złączka gwint.3/4\"",-10,"SZT",1.1599999999999999,-11.6]
[null,null,null,null,"różnice inwent.","NIBC-001088","N-ZW Złączka gwint.1/2\"",7,"SZT",0.7,4.9000000000000004]
[null,null,null,null,"różnice inwent.","NIBC-001089","N-ZW Złączka gwint.3/4\"",4,"SZT",0.83,3.32]
[null,null,null,null,"różnice inwent.","NIBC-001091","N-ZW Złączka gwint.1\"",-4,"SZT",1.39,-5.55]
[null,null,null,null,"różnice inwent.","NIBC-001091","N-ZW Złączka gwint.1\"",4,"SZT",1.39,5.55]
[null,null,null,null,"różnice inwent.","NIBC-001098","N-CW Złączka 1/2\"",-19,"SZT",0.66,-12.53]
[null,null,null,null,"różnice inwent.","NIBC-001106","N-CW Złączka 3/4\"",-5,"SZT",0.75,-3.75]
[null,null,null,null,"różnice inwent.","NIBC-001143","N-CW Śrubunek 3/4\"",-7,"SZT",6.85,-47.96]
[null,null,null,null,"różnice inwent.","NIBC-001146","N-CW Śrubunek 1/2\"",1,"SZT",4.18,4.18]
[null,null,null,null,"różnice inwent.","NIBC-001148","N-CW Trójnik 1/2\"",-1,"SZT",0.79,-0.79]
[null,null,null,null,"różnice inwent.","NIBC-001164","N-CW Tuleja red.3/4\"x1/2\"",1,"SZT",0.8,0.8]
[null,null,null,null,"różnice inwent.","NIBC-001164","N-CW Tuleja red.3/4\"x1/2\"",-1,"SZT",0.8,-0.8]
[null,null,null,null,"różnice inwent.","NIBC-001175","N-CW Kolano 1/2\"",1,"SZT",0.54,0.54]
[null,null,null,null,"różnice inwent.","NIBC-001176","N-CW Złączka 1/2\"",-7,"SZT",2.57,-17.98]
[null,null,null,null,"różnice inwent.","NIBC-001176","N-CW Złączka 1/2\"",-13,"SZT",2.57,-33.4]
[null,null,null,null,"różnice inwent.","NIBC-001181","N-CW Złączka 1/2\"",17,"SZT",0.8,13.6]
[null,null,null,null,"różnice inwent.","NIBC-001181","N-CW Złączka 1/2\"",-10,"SZT",0.8,-8]
[null,null,null,null,"różnice inwent.","NIBC-001182","N-CW Złączka 3/4\"",-3,"SZT",1.1499999999999999,-3.45]
[null,null,null,null,"różnice inwent.","NIBC-001183","N-CW Kolano 3/4\"",-4,"SZT",1.19,-4.75]
[null,null,null,null,"różnice inwent.","NIBC-001195","N-ZW Kolano 1/2\"x45°",-1,"SZT",1.3,-1.3]
[null,null,null,null,"różnice inwent.","NIBC-001197","N-ZW Kolano 1\"x45°",-1,"SZT",2.17,-2.17]
[null,null,null,null,"różnice inwent.","NIBC-046469","N-ZW Rura Sch 40 1/2\"",-10,"SZT",4.72,-47.24]
[null,null,null,null,"różnice inwent.","NIBC-928370","N- Uchwyt rury   3/4\"CPVC=1/2\"",9,"SZT",0.4,3.6]
[null,null,null,null,"różnice inwent.","NIBC-928376","N- Uchwyt rury   1/2\"CPVC",-31,"SZT",0.36,-11.14]

{"sheet":"JPK-Lista MM","index":7,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"},{"$f":"IF(F8=\"\",\"\",SUBTOTAL(5,F8:F1048576))","v":"2016-05-24"},null,null,null,"Liczba dokumentów:",{"$f":"SUBTOTAL(3,E8:E1048576)","v":2}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"},{"$f":"IF(F8=\"\",\"\",SUBTOTAL(4,F8:F1048576))","v":"2016-05-31"},null,null,null,"Wartość dokumentów:",{"$f":"G5 + IF(LiczbaMM > 0, 0.00000001, 0)","v":-4157.0599999900005}]
[]
[]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,G8:G1048576)","v":-4157.0600000000004}]
[]
[null,null,null,"Błąd","Numer MM","Data MM","Wartość MM","Data wydania MM","Skąd","Dokąd"]
[null,null,null,null,"0001629285","2016-05-31",-61.81,"2016-05-31","11N","15P"]
[null,null,null,null,"0001744198","2016-05-24",-4095.25,"2016-05-24","11N","12N"]

{"sheet":"JPK-Pozycje MM","index":8,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2015-08-01"}]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2015-08-31"}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K7:K1048576)","v":-4157.0599999999995}]
[]
[null,null,null,"Błąd","Numer MM","Kod towaru","Nazwa towaru","Ilość wydana","Jedn. miary","Cena jednostkowa","Wartość pozycji"]
[null,null,null,null,"0001629285","ALTH-174761","PEX-Złącz.skręc.16x1/2\" GZ",-26,"SZT",2.38,-61.81]
[null,null,null,null,"0001744198","RETT-018920","Grzej.płyt.CV 22 600x 900",-1,"SZT",362.9,-362.9]
[null,null,null,null,"0001744198","RETT-019220","Grzej.płyt.CV 22 600x1200",-1,"SZT",418.82,-418.82]
[null,null,null,null,"0001744198","RETT-040443","Grzej.płyt.CV 22 600x1400",-1,"SZT",500.82,-500.82]
[null,null,null,null,"0001744198","WAVI-000392","K.WEW Czwórnik 110x110x110/67°",-2,"SZT",19.55,-39.11]
[null,null,null,null,"0001744198","WAVI-000397","K.ZEW Kolano 160/15°",-5,"SZT",7.93,-39.65]
[null,null,null,null,"0001744198","WAVI-000404","K.ZEW Kolano 160/45°",-5,"SZT",8.02,-40.1]
[null,null,null,null,"0001744198","WAVI-000445","K.ZEW Nasuwka 110",-5,"SZT",3.27,-16.350000000000001]
[null,null,null,null,"0001744198","WAVI-000446","K.ZEW Nasuwka 160",-5,"SZT",7.87,-39.33]
[null,null,null,null,"0001744198","WAVI-000525","K.ZEW Rura kiel.LI 110x3,2x1m",-10,"SZT",9.68,-96.84]
[null,null,null,null,"0001744198","WAVI-000526","K.ZEW Rura kiel.LI 110x3,2x2m",-10,"SZT",18.02,-180.17]
[null,null,null,null,"0001744198","WAVI-000534","K.ZEW Rura kiel.LI 160x4,7x2m",-28,"SZT",31.22,-874.03]
[null,null,null,null,"0001744198","WAVI-000610","K.ZEW Redukcja 160/110",-10,"SZT",4.68,-46.8]
[null,null,null,null,"0001744198","WAVI-000624","K.ZEW Kolano 110/45°",-20,"SZT",3.32,-66.400000000000006]
[null,null,null,null,"0001744198","WAVI-015610","K.ZEW Trójnik 110x110/87°",-10,"SZT",5.81,-58.12]
[null,null,null,null,"0001744198","WAVI-032600","ALPEX-Złącz.z/g 20x1/2\" GZ",-5,"SZT",9.18,-45.9]
[null,null,null,null,"0001744198","WAVI-033573","PE-kolano zacisk. 32x1”/90°",-2,"SZT",3.44,-6.88]
[null,null,null,null,"0001744198","WAVI-033598","PE-złączka zacisk  32",-2,"SZT",4.82,-9.64]
[null,null,null,null,"0001744198","WAVI-058854","K.ZEW Rura kiel.LI 160x4,7x1m",-7,"SZT",16.59,-116.14]
[null,null,null,null,"0001744198","WAVI-070282","K.ZEW Rura kiel.ML 110x3,2x3m",-20,"SZT",19.66,-393.24]
[null,null,null,null,"0001744198","WAVI-101339","K.ZEW Rura kiel.ML 110x3,2x1m",-5,"SZT",7.73,-38.67]
[null,null,null,null,"0001744198","WAVI-103267","K.ZEW Rura kiel.ML 160x3,2x3m",-28,"SZT",25.19,-705.34]

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

{"sheet":"techniczne","index":10,"n_rows":119,"n_cols":20,"rows_kept":119,"cut":false,"hidden":true,"merged":[[112,14,112,15],[112,16,112,17],[113,14,113,15],[113,16,113,17],[114,14,114,15],[114,16,114,17],[118,14,118,15],[118,16,118,17],[115,14,115,15],[115,16,115,17],[116,14,116,15],[116,16,116,17],[117,14,117,15],[117,16,117,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,"PZWartosc",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PZWiersz",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WZWartosc",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WZWiersz",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RWWartosc",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RWWiersz",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMWartosc",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MMWiersz",null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XED","#4538"]
[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_MAG%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/03093/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroToEmpty",true]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroFollowsFields:","WartoscPZ,CenaJednPZ,WartoscPozycjiPZ,WartoscRW,CenaJednRW,WartoscPozycjiRW,WartoscWZ,CenaJednWZ,WartoscPozycjiWZ,WartoscMM,CenaJednMM,WartoscPozycjiMM"]
[]
[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_MAG",{"$f":"\"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być '\" & S22 & \"'\"","v":"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_MAG'"}]
[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:Magazyn",{"$f":"Magazyn","v":"12N"},{"$f":"\"Plik dotyczy magazynu o innym symbolu ({Val}) niż dotychczas wczytane dane (dla magazynu: \" &S23 & \")\"","v":"Plik dotyczy magazynu o innym symbolu ({Val}) niż dotychczas wczytane dane (dla magazynu: 12N)"}]
[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":"1111111111"},{"$f":"\"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: \" &S24 & \")\"","v":"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: 1111111111)"}]
[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":"2015-08-01"},{"$f":"\"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (\" & S25 & \")\"","v":"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (2015-08-01)"}]
[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":"2015-08-31"},{"$f":"\"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (\" & S26 & \")\"","v":"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (2015-08-31)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa skoroszytu:",null,"JPK_MAG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer seryjny:",null,"DEMO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer edycji:",null,1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wygenerowano:",null,"2024-04-02T13:55:21"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komunikaty w oknach dialogowych",null,"00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,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/03093/"}]