{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Arkusz1","Arkusz2","Arkusz3"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Arkusz1","index":0,"n_rows":76,"n_cols":9,"rows_kept":76,"merged":[[0,0,2,0],[0,4,2,4],[0,7,2,7],[0,8,2,8],[3,0,41,0],[42,0,49,0],[50,0,52,0],[53,0,62,0],[63,0,66,0],[67,0,75,0],[67,4,67,6]]}
["INSTRUKCJA",null,"MeternetPRO v3.8",null,"cena katalogowa netto",null,null,"liczba tokenów w systemie","suma tokenów"]
[null,null,"ceny obowiązują od 15.03.2021 do 31.12.2021"]
[null,"indeks","opis","link",null,"szt.","kwota"]
["urządzenia  pomiarowe","LE-01M","licznik 1f energii czynnej 100A","↗",{"v":209,"d":"209.00 zł"},null,{"$f":"E4*F4","v":{"v":0,"d":"0.00 zł"}},2,{"$f":"H4*F4","v":0}]
[null,"LE-03M","licznik 3f energii czynnej 100A","↗",{"v":495,"d":"495.00 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"LE-03M-CT","licznik 3f energii czynnej, przekładnikowy","↗",{"v":540,"d":"540.00 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"LE-01MR","licznik 1f z analizą parametrów sieci 100A","↗",{"v":249,"d":"249.00 zł"},null,{"v":0,"d":"0.00 zł"},3,0]
[null,"LE-03MP","licznik 3f z analizą parametrów sieci 160A","↗",{"v":630,"d":"630.00 zł"},null,{"v":0,"d":"0.00 zł"},6,0]
[null,"LE-01MQ","licznik 1f 2-kierunkowy z analizą parametrów sieci 100A","↗",{"v":360,"d":"360.00 zł"},null,{"v":0,"d":"0.00 zł"},3,0]
[null,"LE-03MQ","licznik 3f 2-kierunkowy z analizą parametrów sieci 100A","↗",{"v":990,"d":"990.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"LE-03MQ-CT","licznik 3f 2-kierunkowy z analizą parametrów sieci, przekładnikowy","↗",{"v":990,"d":"990.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"LE-01MB","licznik 1f 2-kierunkowy z analizą parametrów sieci 100A                        M-BUS","↗",{"v":360,"d":"360.00 zł"},null,{"$f":"E12*F12","v":{"v":0,"d":"0.00 zł"}},3,{"$f":"H12*F12","v":0}]
[null,"LE-03MB","licznik 3f 2-kierunkowy z analizą parametrów sieci 100A                        M-BUS","↗",{"v":990,"d":"990.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"LE-03MB-CT","licznik 3f 2-kierunkowy z analizą parametrów sieci, przekładnikowy    M-BUS","↗",{"v":990,"d":"990.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"LE-01MW","licznik 1f 2-kierunkowy 4-taryfowy","↗",{"v":295,"d":"295.00 zł"},null,{"v":0,"d":"0.00 zł"},3,0]
[null,"LE-01MW","licznik 1f 2-kierunkowy 4-taryfowy + parametry sieci 80A","↗",{"v":295,"d":"295.00 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"LE-03MW","licznik 3f 2-kierunkowy 4-taryfowy","↗",{"v":650,"d":"650.00 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"LE-03MW","licznik 3f 2-kierunkowy 4-taryfowy  + parametry sieci 80A","↗",{"v":650,"d":"650.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"LE-03MW-CT","licznik 3f 2-kierunkowy 4-taryfowy","↗",{"v":670,"d":"670.00 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"LE-03MW-CT","licznik 3f 2-kierunkowy 4-taryfowy  + parametry sieci, przekładnikowy","↗",{"v":670,"d":"670.00 zł"},null,{"v":0,"d":"0.00 zł"},8,0]
[null,"DMM-5T-2","multimetr z analizą parametrów sieci, przekładnikowy","↗",{"v":921,"d":"921.00 zł"},null,{"$f":"E21*F21","v":{"v":0,"d":"0.00 zł"}},8,{"$f":"H21*F21","v":0}]
[null,"MB-1U-1","przetwornik pomiarowy napiecia 1f 285V","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"MB-3U-1","przetwornik pomiarowy napiecia 3f 3x285V","↗",{"v":415.5,"d":"415.50 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"MB-1I-1 ","przetwornik pomiarowy pradu 1f; ","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"MB-3I-1","przetwornik pomiarowy pradu 3f; wersja 5A lub 15A","↗",{"v":415.5,"d":"415.50 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"MB-PT-100","przetwornik pomiarowy temperatury, sonda PT-100","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"MB-TC-1","przetwornik pomiarowy temperatury, sonda termopara K, J, E, N, T, S, R, B.","↗",{"v":266.5,"d":"266.50 zł"},null,{"$f":"E27*F27","v":{"v":0,"d":"0.00 zł"}},2,{"$f":"H27*F27","v":0}]
[null,"MB-DS-2","przetwornik pomiarowy temperatury, czujnik DS. x2","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},3,0]
[null,"MB-DS-10","przetwornik pomiarowy temperatury, czujnik DS. x10","↗",{"v":365,"d":"365.00 zł"},null,{"$f":"E29*F29","v":{"v":0,"d":"0.00 zł"}},3,{"$f":"H29*F29","v":0}]
[null,"MB-DS-30","przetwornik pomiarowy temperatury, czujnik DS. x30","↗",{"v":450,"d":"450.00 zł"},null,{"$f":"E30*F30","v":{"v":0,"d":"0.00 zł"}},3,{"$f":"H30*F30","v":0}]
[null,"MB-AHT-1","przetwornik pomiarowy wilgotności i temperatury","↗",{"v":300,"d":"300.00 zł"},null,{"$f":"E31*F31","v":{"v":0,"d":"0.00 zł"}},3,{"$f":"H31*F31","v":0}]
[null,"MB-LI-4   ","licznik impulsów; wejście liczące x4; wersja napieciowa Lo lub Hi","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},5,0]
[null,"MB-LG-4","licznik czasu pracy; wejście liczące x4; wersja napieciowa Lo lub Hi","↗",{"v":266.5,"d":"266.50 zł"},null,{"v":0,"d":"0.00 zł"},5,0]
[null,"MR-DI-4","moduł rozszerzeń wejść cyfrowych x4; wersja napieciowa Lo lub Hi","↗",{"v":185,"d":"185.00 zł"},null,{"v":0,"d":"0.00 zł"},3,0]
[null,"MD-DIO-1","moduł rozszerzeń wyjść/wejść cyfrowych x6","↗",{"v":185,"d":"185.00 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"MR-AI-1","moduł rozszerzeń wejść analogowych x4","↗",{"v":234,"d":"234.00 zł"},null,{"$f":"E36*F36","v":{"v":0,"d":"0.00 zł"}},5,{"$f":"H36*F36","v":0}]
[null,"PA-02-MBT","moduł rozszerzeń wejście analogowych x1 + LCD","↗",{"v":305,"d":"305.00 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"MR-RO-1","moduł rozszerzeń wyjść przekaźnikowych styk 1x1P","↗",{"v":99,"d":"99.00 zł"},null,{"v":0,"d":"0.00 zł"},2,0]
[null,"MR-RO-4","moduł rozszerzeń wyjść przekaźnikowych styk 4x1Z","↗",{"v":295,"d":"295.00 zł"},null,{"v":0,"d":"0.00 zł"},4,0]
[null,"MB-LS-1","przetwornik pomiarowy natężenia oświetlenia","↗",{"v":266.5,"d":"266.50 zł"},null,{"$f":"E40*F40","v":{"v":0,"d":"0.00 zł"}},2,{"$f":"H40*F40","v":0}]
[null,null,"urządzenie obce","↗",{"v":0,"d":"0.00 zł"},null,{"$f":"E41*F41","v":{"v":0,"d":"0.00 zł"}},0,{"$f":"H41*F41","v":0}]
[null,null,"urządzenie obce","↗",{"v":0,"d":"0.00 zł"},null,{"$f":"E42*F42","v":{"v":0,"d":"0.00 zł"}},0,{"$f":"H42*F42","v":0}]
["urządzenia sieci RS-485","LT-04","moduł terminacyjny","↗",{"v":30,"d":"30.00 zł"},null,{"$f":"E43*F43","v":{"v":0,"d":"0.00 zł"}}]
[null,"RM-07","wzmacniacz / separator RS","↗",{"v":155,"d":"155.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"CN-USB-485","konwerter USB","↗",{"v":31,"d":"31.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"CN-ETH-485","konwerter LAN","↗",{"v":340,"d":"340.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"CN-GPRS-485","konwerter GPRS","↗",{"v":450,"d":"450.00 zł"},null,{"$f":"E47*F47","v":{"v":0,"d":"0.00 zł"}}]
[null,"ETH2","konwerter MBUS/LAN","↗",{"v":480,"d":"480.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"ZI-21","zasilacz 24V 12W      (dla RM-07, LT-04, CN-ETH-485, ETH2)","↗",{"v":102.5,"d":"102.50 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"ZI-61-24","zasilacz 24V 60W      (dla RM-07, LT-04, CN-ETH-485, ETH2)","↗",{"v":139,"d":"139.00 zł"},null,{"v":0,"d":"0.00 zł"}]
["zasilanie","ECH-06","moduł rezerwy zasilania","↗",{"v":152,"d":"152.00 zł"},1,{"v":152,"d":"152.00 zł"}]
[null,"AKU-12","bateria żelowa 12V 1,3Ah","↗",{"v":40,"d":"40.00 zł"},1,{"v":40,"d":"40.00 zł"}]
[null,"ZI-61-24","zasilacz 24V 60W      (dla MT-CPU-1 w układzie z ECH-06 + AKU-12)","↗",{"v":139,"d":"139.00 zł"},1,{"v":139,"d":"139.00 zł"}]
["MeternetPRO","MT-CPU-1","serwer sprzętowy","↗",{"v":930,"d":"930.00 zł"},1,{"v":930,"d":"930.00 zł"}]
[null,"Pendrive64","pamięć USB 64GB","↗",{"v":195,"d":"195.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"SSD275","pamięć USB 275GB (z funkcją Power Lost Protection); z adapterem na szynę TH35","↗",{"v":569,"d":"569.00 zł"},null,{"v":0,"d":"0.00 zł"}]
[null,"LIC-MT-B","licencja programu - wersja podstawowa (wewnętrzne archiwum INTERNAL + 10 tokenów)","↗",{"v":795,"d":"795.00 zł"},"TAK",{"$f":"IF(Arkusz2!A2,795,0)","v":{"v":795,"d":"795.00 zł"}}]
[null,"LIC-MT-I","licencja rozszerzenia - implementacja obca","↗",{"v":400,"d":"400.00 zł"},null,{"$f":"E58*F58","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-D","token","↗",{"v":12.8,"d":"12.80 zł"},{"$f":"Arkusz2!K5","v":0},{"v":0,"d":"0.00 zł"}]
[null,"LIC-MT-D250","pakiet tokenów: 250 szt.","↗",{"v":2560,"d":"2,560.00 zł"},{"$f":"Arkusz2!J6","v":0},{"v":0,"d":"0.00 zł"}]
[null,"LIC-MT-D500","pakiet tokenów: 500 szt.","↗",{"v":4500,"d":"4,500.00 zł"},{"$f":"Arkusz2!I7","v":0},{"v":0,"d":"0.00 zł"}]
[null,"LIC-MT-D1000","pakiet tokenów: 1000 szt.","↗",{"v":7300,"d":"7,300.00 zł"},{"$f":"Arkusz2!H8","v":0},{"v":0,"d":"0.00 zł"}]
[null,"LIC-MT-D2000","pakiet tokenów: 2000 szt.","↗",{"v":9500,"d":"9,500.00 zł"},{"$f":"Arkusz2!G9","v":0},{"v":0,"d":"0.00 zł"}]
["Rachunek",{"$nulls":4},"RAZEM:",{"$f":"SUM(G4:G63)","v":{"v":2056,"d":"2,056.00 zł"}}]
[null,null,"Liczba wymaganych tokenów (LICMT-D) dla systemu:",{"$f":"Arkusz2!B6","v":0},{"$f":"D65*E59","v":{"v":0,"d":"0.00 zł"}}]
[null,null,"Liczba tokenów pojedynczych i w pakietach zoptymalizowana pod względem ceny:",{"$f":"F59*Arkusz2!D5+F60*Arkusz2!D6+F61*Arkusz2!D7+F62*Arkusz2!D8+F63*Arkusz2!D9","v":0},{"$f":"SUM(G59:G63)","v":{"v":0,"d":"0.00 zł"}}]
[null,null,"Zyskujesz tokenów: ",{"$f":"D66-D65","v":0},{"$f":"E65-E66","v":{"v":0,"d":"0.00 zł"}},"Oszczędzasz! "]
["moduły programowe                                                            i  archiwa",null,"Zaznacz wybrane moduły programowe poprzez wybór opcji TAK/NIE oraz zaznacz typ i liczbę archiwów dodatkowych. Ceny wyrażone są w liczbie tokenów jaką wymaga system przy jego aktywacji. Liczba tokenów, które należy dokupić wliczona jest w wiersze nr 61-64 (LIC-MT-D).",null,"Informacyjna kwota wartości tokenów za wybrany moduł lub archiwum. Kwota jest uwzględniona w wierszu 65 w polu RAZEM.                                                                          ↓"]
[null,"LIC-MT-P","moduł programowy \"pulpity\"","↗","40 tokenów","NIE",{"$f":"IF(Arkusz2!A15,512,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-R","moduł programowy \"raporty\"","↗","40 tokenów","NIE",{"$f":"IF(Arkusz2!A16,512,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-M","moduł programowy \"matematyka\"","↗","GRATIS!!!","TAK",{"$f":"IF(Arkusz2!A17,0,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-K","moduł programowy \"kemping\"","↗","60 tokenów","NIE",{"$f":"IF(Arkusz2!A18,768,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-Z","moduł programowy \"prepaid\"","↗","60 tokenów","NIE",{"$f":"IF(Arkusz2!A19,768,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"LIC-MT-L","moduł programowy \"powiadomienia i sterowanie\"","↗","30 tokenów","NIE",{"$f":"IF(Arkusz2!A20,384,0)","v":{"v":0,"d":"0.00 zł"}}]
[null,"CSV","archiwum \"CSV\" (excel)  - jeden arkusz","↗","10 tokenów",null,{"$f":"128*F75","v":{"v":0,"d":"0.00 zł"}}]
[null,"SQL","archiwum \"Baza danych SQL\" - jedna baza (MSSQL, PostgreSQL, MySQL, ORACLE)","↗","50 tokenów",null,{"$f":"640*F76","v":{"v":0,"d":"0.00 zł"}}]

{"sheet":"Arkusz2","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"merged":[[3,0,4,0]]}
[{"$nulls":3},1172,719]
[{"$f":"EXACT(Arkusz1!F57,C15)","v":true},{"$f":"IF(A2,10,0)","v":10}]
[{"$nulls":7},{"$f":"IF(H4>0,1,0)","v":0},{"$f":"IF(I4>0,1,0)","v":0},{"$f":"IF(J4>0,1,0)","v":0},{"$f":"IF(K4>0,1,0)","v":0}]
[null,{"$f":"SUM(Arkusz1!I4:I42)","v":0},{"$nulls":5},{"$f":"C5-(D9*G9)","v":0},{"$f":"C5-(D9*G9)-(D8*H8)","v":0},{"$f":"C5-(D9*G9)-(D8*H8)-(D7*I7)","v":0},{"$f":"C5-(D9*G9)-(D8*H8)-(D7*I7)-(D6*J6)","v":0}]
[null,{"$f":"SUM(B15:B22,B4)","v":0},{"$f":"B6","v":0},1,{"$f":"TRUNC(F6/D5)","v":0},{"$f":"MOD(C5,D5)","v":0},null,{"$f":"H3*E5","v":0},null,null,{"$f":"K3*E5","v":0}]
[null,{"$f":"IF(B5-B2<0,0,B5-B2)","v":0},null,250,{"$f":"TRUNC(F7/D6)","v":0},{"$f":"MOD(C5,D6)","v":0},null,{"$f":"H3*E6","v":0},null,{"$f":"J12*J3","v":0},"-----------------"]
[{"$nulls":3},500,{"$f":"TRUNC(F8/D7)","v":0},{"$f":"MOD(C5,D7)","v":0},null,{"$f":"H3*E7","v":0},{"$f":"I12*I3","v":0},"-----------------","-----------------"]
[{"$nulls":3},1000,{"$f":"TRUNC(F9/D8)","v":0},{"$f":"MOD(C5,D8)","v":0},null,{"$f":"H12*H3","v":0},"-----------------","-----------------","-----------------"]
[{"$nulls":3},2000,{"$f":"TRUNC(C5/D9)","v":0},{"$f":"MOD(C5,D9)","v":0},{"$f":"E9+(G12*G13)","v":0},"-----------------","-----------------","-----------------","-----------------"]
[{"$nulls":6},{"$f":"E5*Arkusz1!E59+E6*Arkusz1!E60+E7*Arkusz1!E61+E8*Arkusz1!E62+E9*Arkusz1!E63","v":{"v":0,"d":"0.00 zł"}},{"$f":"E8*Arkusz1!E62+Arkusz1!E61*E7+Arkusz1!E60*E6+Arkusz1!E59*E5","v":{"v":0,"d":"0.00 zł"}},{"$f":"E7*Arkusz1!E61+E6*Arkusz1!E60+E5*Arkusz1!E59","v":{"v":0,"d":"0.00 zł"}},{"$f":"E6*Arkusz1!E60+E5*Arkusz1!E59","v":{"v":0,"d":"0.00 zł"}},{"$f":"E5*Arkusz1!E59","v":{"v":0,"d":"0.00 zł"}}]
[{"$nulls":6},2000,1000,500,250,1]
[{"$nulls":6},{"$f":"IF(Arkusz1!E63*(E9+1)<=G10,1,0)","v":0},{"$f":"IF(Arkusz1!E62<=H10,1,0)","v":0},{"$f":"IF(Arkusz1!E61<=I10,1,0)","v":0},{"$f":"IF(Arkusz1!E60<=J10,1,0)","v":0}]
[{"$nulls":6},{"$f":"IF(F9<D1,0,1)","v":0}]
[]
[{"$f":"EXACT(Arkusz1!F69,C15)","v":false},{"$f":"IF(A15,40,0)","v":0},"TAK"]
[{"$f":"EXACT(Arkusz1!F70,C15)","v":false},{"$f":"IF(A16,40,0)","v":0},"NIE"]
[{"$f":"EXACT(Arkusz1!F71,C15)","v":true},{"$f":"IF(A17,0,0)","v":0}]
[{"$f":"EXACT(Arkusz1!F72,C15)","v":false},{"$f":"IF(A18,60,0)","v":0}]
[{"$f":"EXACT(Arkusz1!F73,C15)","v":false},{"$f":"IF(A19,60,0)","v":0}]
[{"$f":"EXACT(Arkusz1!F74,C15)","v":false},{"$f":"IF(A20,30,0)","v":0}]
[10,{"$f":"Arkusz1!F75*A21","v":0}]
[50,{"$f":"Arkusz1!F76*A22","v":0}]

{"sheet":"Arkusz3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}