{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Dane wyjściowe","Dane kadrowe","PRACOWNICY","Pracownicy podsuma","MASZYNY SPRZĘT","MASZYNY SPRZĘT ceny","CHEMIA","HIGIENA","ZIMA","ZIMA ceny","POZOSTAŁE","POZOSTAŁE ceny","PODSUMOWANIE","Karta obiektu","Wykorzystanie budżetu"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Dane wyjściowe","index":0,"n_rows":85,"n_cols":30,"rows_kept":85,"cut":false,"hidden":true,"merged":[[0,14,0,15],[20,8,24,8],[18,9,18,16]]}
["SEZON","ILOŚĆ PRACUJĄCYCH MIESIĘCY",null,"RODZAJ UMOWY","WSKAŹNIK UBRUTTOWIENIA","WSKAŹNIK OPERACYJNY",null,null,"DOJAZD",null,"NARODOWOŚĆ",null,"KSIĘGOWOŚĆ",null,"Rezerwy (liczone od podst. wynagrodzenia mies. brutto) - tylko do UOP",null,null,"MASZYNY",null,null,"SPÓŁKI",null,"RODZAJ CZYNNOŚCI",null,"Odzież",null,"Zima"]
["Cały rok",12,null,"O pracę",1.65,1.6840352075556022,null,null,2.39,null,"Polak",null,30,null,"Chorobowe",0.05,null,"Postojowe",null,null,"DL2 SP. Z O.O.",null,"Doczyszczanie koszy na śmieci – mycie pojemników wewnątrz, klap od śmietników ",null,null,null,11,null,"data teraz",{"$f":"TODAY()","v":"2026-06-11"}]
["Lato",7,null,"Zlecenie",1.65,1.6095833333333336,null,null,null,null,"Obcokrajowiec",null,15,null,"Urlopowe",0.1,null,"Dojazd",null,null,"DL2 SP. Z O.O. SP.K.",null,"Dystrybutor na wodę – kratka ociekająca na wodę ",null,"X",null,12,null,"miesiąc teraz",{"$f":"MONTH(AD2)","v":6}]
["Zima",5,null,"Agencja",1.7716666666666667,1.7716666666666667,null,null,null,null,null,null,null,null,"Administracja",null,null,null,null,null,"GLOBAL DL SP. Z O.O.",null,"Mycie drzwi od zmywarki od wewnątrz – doczyszczenie boków ",null,null,null,1,null,"czy zima",{"$f":"IF(IFERROR(VLOOKUP(AD3,AA:AA,1,0),\"nie\")=\"nie\",\"nie\",\"tak\")","v":"nie"}]
[null,null,null,"O pracę z dojazdem",2.1316667153918001,1.8440273210166083,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GLOBAL DL SP. Z O.O. SP.K.",null,"Mycie lodówek od wewnątrz – przy przekładaniu produktów – bieżące zabrudzenia ",null,null,null,2]
[null,null,null,"O pracę z mieszkaniem",2.1906176208275099,1.9029782264523198,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HORIZONT  SP. Z O.O. SP.K.",null,"Mycie lodówek z zewnątrz ",null,null,null,3]
[null,null,null,"O pracę z dojazdem i mieszkaniem",2.3506097342885175,2.0629703399133259,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie lodówki"]
[null,null,null,"Agencja z dojazdem",1.89,1.89,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie mikrofali"]
[null,null,null,"Agencja z mieszkaniem",1.8100000000000003,1.8100000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie mikrofalówek od wewnątrz "]
[null,null,null,"Agencja z dojazdem i mieszkaniem",2.0499999999999998,2.0499999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie mikrofalówek z zewnątrz "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie naczyń"]
["HIGIENA - REFAKTURA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie ociekacza na sztućce i gąbki"]
["TAK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie pionowych powierzchni mebli biurowych "]
["NIE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie przeszkleń w drzwiach – na bieżąco miejsca zabrudzone"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie zlewozmywaka wraz z ociekaczem i kranem "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie zmywarki – specjalny program czyszczenia ze środkiem czyszczącym "]
[null,null,null,"Aktualny cennik",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odkurzanie lamp wiszących "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Odkurzanie powierzchni mebli tapicerowanych "]
[null,null,null,null,"[1]","[2] = [1] + ZUS + PIT","[3] = [2] x 20,5%","[4] = [2] + [3]","[5]","[6] = [4] + [5]",null,null,null,null,null,null,null,null,null,null,null,null,"Odkurzanie powierzchni wykładzinowej "]
[null,null,null,"stanowisko","Netto","Brutto pracownika","ZUS pracodawcy zł. 20,5%","Koszt pracodawcy (Brutto pracodawcy)","Marża oraz koszty dodatkowe","T&M","Mercury","FindWork","Logis","ArtVending","3D","Perfecta","AB OVO",null,null,null,null,null,"Opróżnianie koszy i wymiana wkładów foliowych "]
[null,null,null,"Pracownik porządkowy",13,17.37,{"$f":"F21*20.5%","v":3.5608499999999998},{"$f":"F21+G21","v":20.93085},"marża + koszt transportu + koszt mieszkania + koszt badań itd..",24.1,24.64,24.13,23.78,22.43,23.28,21.78,24.66,null,null,null,null,null,"Opróżnianie koszy i wymiana wkładów foliowych (wraz z pojemnikami niszczarek)"]
[null,null,null,"Jum Buster",13.5,18.05,{"$f":"F22*20.5%","v":3.70025},{"$f":"F22+G22","v":21.750250000000001},null,25,26.19,25.01,24.32,23.32,23.82,22.82,25.96,null,null,null,null,null,"Opróżnianie koszy i wymiana worków "]
[null,null,null,"Jum Buster pow. 3m",13.5,18.05,{"$f":"F23*20.5%","v":3.70025},{"$f":"F23+G23","v":21.750250000000001},null,26,"-","-","-","-","-","-","-",null,null,null,null,null,"Opróżnianie nieterminowych produktów z lodówki "]
[null,null,null,"Operator wózka widłowego",14.5,19.440000000000001,{"$f":"F24*20.5%","v":3.9851999999999999},{"$f":"F24+G24","v":23.4252},null,27,27.7,26.78,25.38,25.24,25.38,23.88,27.81,null,null,null,null,null,"Podlewanie kwiatów "]
[null,null,null,"Operator wózka widłowego wysoki skład",15.5,20.72,{"$f":"F25*20.5%","v":4.2475999999999994},{"$f":"F25+G25","v":24.967599999999997},null,28.5,"-",26.78,26.3,26.9,26.8,24.8,28.91,null,null,null,null,null,"Przecieranie drzwi do pomieszczenia z zewnątrz – łącznie z szybką w drzwiach "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie drzwi szafy przesuwnej oraz listwy przypodłogowej "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie gaśnic, kontaktów, przycisków ewakuacyjnych zamieszczonych na ścianach "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie koszy na śmieci "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie koszy na śmieci wilgotna szmatka "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie kurzy z zewnętrznych poziomych powierzchni mebli - meble wysokie ( regały) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie kurzy z zewnętrznych poziomych powierzchni mebli ( stoły, regały, lada recepcyjna) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie lamp wiszących / odkurzanie "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie lamp zawieszonych nad ladą recepcyjną i usuwanie z nich pajęczyn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno koszy na śmieci "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno nóg krzeseł i stołów oraz samych siedzisk krzeseł"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno poziomych powierzchni mebli – regałów, szafek, stołów "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno twardych powierzchni podłóg "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno zewnętrznych poziomych powierzchni mebli – stoły, blaty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno zewnętrznych poziomych powierzchni mebli (biurka, kontenerki, regały, szafki) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno zewnętrznych poziomych powierzchni mebli (półki, stoliki, regały) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie nóg krzeseł i stołów oraz obudów komputerów i monitorów, drukarek i niszczarek"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie paneli sterowania klimatyzacji "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie paneli sterowania klimatyzacji oraz czytników kart dostępu "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie paneli ściennych na placu głównym "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie pojemników do zbierania dokumentów "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie powierzchni pionowych szafek"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie powierzchni szafek pionowych – drzwi szafek z zewnątrz "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie powierzchni szafek wewnątrz "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie powierzchni szafek wewnątrz – półki wewnątrz szafek "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie powierzchni wysokich mebli "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie ramek zawieszonych w recepcji "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie sprzętu RTV (telewizory, niszczarki, kserokopiarki) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie sprzętu RTV w pomieszczeniach z kurzu "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie stołu do piłkarzyków "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie sufitowych wlotów wentylacyjnych"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie sufitowych wlotów wentylacyjnych "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie sufitowych wylotów wentylacyjnych"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie tabliczek przy drzwiowych "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie zewnętrznych powierzchni poziomych mebli - meble wysokie "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Regał z książkami - przetarcie całości półek "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ścieranie pasów farby tablicowej suchościeralnej "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usuwanie miejscowych plam z wykładzin i dywanów"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usuwanie pajęczyn "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usuwanie pajęczyn, kurzu"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Usuwanie plam z wykładzin i dywanów"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utrzymanie czystości ekspresu - cykl mycia oraz mycie zewnętrznych elementów ruchomych "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utrzymanie czystości lodówki do ekspresu  - mycie lodówki do ekspresu z zewnątrz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utrzymanie czystości pojemnika na mleko w lodówce do ekspresu – mycie ręczne pojemnika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uzupełnianie mydła do podajnika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uzupełnianie papierów toaletowych do podajnika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Uzupełnianie ręczników papierowych do podajnika"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie drzwi wraz z ościeżnicą, parapetów i kontaktów "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie klamek drzwi i drzwi "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie klamek drzwi i drzwi od wewnątrz "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie klamek drzwi i drzwi w całości"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie na wilgotno drzwi i parapetów "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie na wilgotno drzwi wejściowych przeszklonych (miejsca zabrudzeń) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wycieranie przeszkleń – bieżące zabrudzenia "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wynoszenie śmieci do kontenerów zbiorczych znajdujących się na terenie biurowca, łącznie ze śmieciami wielkogabarytowymi (np. palety, duże kartony)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zbieranie kubków i składanie do zmywarek, rozładowywanie zmywarki, domywanie brudnych naczyń ręcznie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zmywanie tablic suchościeralnych"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Przecieranie na wilgotno luster"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie kabin prysznicowych"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie i dezynfekca toalet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mycie i dezynfekcja pisuarów"]

{"sheet":"Dane kadrowe","index":1,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":true,"merged":[[0,0,0,6],[43,0,44,0],[43,1,43,2],[43,4,44,4],[43,5,43,6],[40,0,40,6],[29,0,29,6]]}
["Umowa o pracę"]
[]
["Wskaźniki dla UoP liczone na podstawie stawki netto/rbh [zł]"]
[]
["stawka netto/rbh [zł]","wskaźnik ubruttowienia"]
[13,1.3614999999999999]
[13.5,1.3639021164021163]
[14,1.3654999999999999]
[14.5,1.3675999999999999]
[15,1.369]
[15.5,1.3708]
[16,1.3719999999999999]
[17,1.3747]
[18,1.3771]
[19,1.3792]
[20,1.3811]
[21,1.3884000000000001]
[22,1.3884000000000001]
[23,1.3884000000000001]
[24,1.3884000000000001]
[25,1.3884000000000001]
[26,1.3933000000000002]
[27,1.3933000000000002]
[28,1.3933000000000002]
[29,1.3933000000000002]
[30,1.3933000000000002]
[]
[]
[]
["Umowa zlecenie"]
["Stawka netto za 1h","wskaźnik ubruttowienia"]
[13,1.3232999999999999,null,"Dla umowy zlecenie przyjmujemy stały wskaźnik:"]
[13.5,1.3234999999999999]
[14,1.3232999999999999,null,1.3234999999999999]
[14.5,1.3233999999999999]
[15,1.3234999999999999]
[15.5,1.3232999999999999]
[]
[]
[]
["Koszty ZUS pracodawcy (dotyczą UoP i Umowy zlecenie)"]
[]
["HORIZONT",null,null,null,"CEJS"]
["Rodzaj ubezpieczenia","Sposób finansowania i stopa % składki",null,null,"Rodzaj ubezpieczenia","Sposób finansowania i stopa % składki"]
[null,"pracodawca","pracownik",null,null,"pracodawca","pracownik"]
["Emerytalne",9.7600000000000006E-2,9.7600000000000006E-2,null,"Emerytalne",9.7600000000000006E-2,9.7600000000000006E-2]
["Rentowe",6.5000000000000002E-2,1.4999999999999999E-2,null,"Rentowe",6.5000000000000002E-2,1.4999999999999999E-2]
["Chorobowe","-",2.4500000000000001E-2,null,"Chorobowe","-",2.4500000000000001E-2]
["Wypadkowe",1.67E-2,"-",null,"Wypadkowe",9.5999999999999992E-3,"-"]
["Zdrowotne","-",0.09,null,"Zdrowotne","-",0.09]
["FP",2.4500000000000001E-2,"-",null,"FP",2.4500000000000001E-2,"-"]
["FGŚP",1E-3,"-",null,"FGŚP",1E-3,"-"]
[null,{"$f":"SUM(B46:B52)","v":0.20480000000000001},{"$f":"SUM(C46:C52)","v":0.2271},null,null,{"$f":"SUM(F46:F52)","v":0.19770000000000001},{"$f":"SUM(G46:G52)","v":0.2271}]

{"sheet":"PRACOWNICY","index":2,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[[29,2,29,9],[3,2,3,28],[1,2,1,28],[25,2,25,9]]}
[]
[null,null,"PRACOWNICY"]
[]
[null,null,"WYKAZ PRACOWNIKÓW"]
["Podsumowanie",null,"Lp","Typ pracownika","Opis stanowiska","Sezon","Rodzaj umowy","Od godziny","Do godziny","rbh/dzień","Ilość osób","Ilość dni pracujących w tygodniu ","Ilość dni w tygodniu","Średnio dni w miesiącu","Ilośc miesięcy w roku","Ilość pracujących miesięcy","rbh/m-c","zł netto/rbh stawka minimum","nowa stawka zł netto/rbh","zł netto/rbh","Netto pracownika","Brutto pracownika","Wskaźnik pracodawcy ZUS","Brutto pracodawcy","Chorobowe","Urlopowe","Zakwaterowanie","Dojazd","Koszt pracodawcy"]
[{"$f":"IF(G6=\"\",\"\",G6&\" - stawka \"&TEXT(R6,\"# ##0,00 zł\"))","v":"zlecenie - stawka 24,50 zł"},null,1,"Pracownik porządkowy - umowa zlecenie",null,"Cały rok",{"$f":"IF(D6=\"\",\"\",MID(D6,FIND(\"umowa\",D6)+6,100))","v":"zlecenie"},null,null,{"$f":"I6-H6+IF(I6<H6,1,0)","v":0},null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F6,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":12},{"$f":"IFERROR(CEILING(K6*J6*N6/M6*L6*P6/O6,TIME(1,0,0))*24,\"\")","v":0},{"$f":"IF(D6=\"\",\"\",VLOOKUP(D6,$D$36:$E$46,2,0))","v":24.5},null,{"$f":"IF(R6=\"\",\"\",MAX(R6:S6))","v":24.5},{"$f":"IF(Q6=\"\",\"\",Q6*T6)","v":0},{"$f":"IFERROR(IF(LEFT(G6,7)=\"O pracę\",U6*VLOOKUP(PRACOWNICY!T6,'Dane kadrowe'!$A$5:$B$26,2,1),U6*'Dane kadrowe'!$D$34),\"\")","v":0},{"$f":"IF(Q6=\"\",\"\",'Dane kadrowe'!$B$53)","v":0.20480000000000001},{"$f":"IF(V6=\"\",\"\",V6*(1+W6))","v":0},{"$f":"IF(LEFT(G6,7)='Dane wyjściowe'!$D$2,5%*X6,\"\")","v":""},{"$f":"IF(LEFT(G6,7)='Dane wyjściowe'!$D$2,10%*X6,\"\")","v":""},null,null,{"$f":"IF(X6=\"\",\"\",SUM(X6:AB6))","v":0}]
[{"$f":"IF(G7=\"\",\"\",G7&\" - stawka \"&TEXT(R7,\"# ##0,00 zł\"))","v":"zlecenie - stawka 24,50 zł"},null,2,"Pracownik porządkowy - umowa zlecenie",null,"Cały rok",{"$f":"IF(D7=\"\",\"\",MID(D7,FIND(\"umowa\",D7)+6,100))","v":"zlecenie"},null,null,{"$f":"I7-H7+IF(I7<H7,1,0)","v":0},null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F7,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":12},{"$f":"IFERROR(CEILING(K7*J7*N7/M7*L7*P7/O7,TIME(1,0,0))*24,\"\")","v":0},24.5,null,{"$f":"IF(R7=\"\",\"\",MAX(R7:S7))","v":24.5},{"$f":"IF(Q7=\"\",\"\",Q7*T7)","v":0},{"$f":"IFERROR(IF(LEFT(G7,7)=\"O pracę\",U7*VLOOKUP(PRACOWNICY!T7,'Dane kadrowe'!$A$5:$B$26,2,1),U7*'Dane kadrowe'!$D$34),\"\")","v":0},{"$f":"IF(Q7=\"\",\"\",'Dane kadrowe'!$B$53)","v":0.20480000000000001},{"$f":"IF(V7=\"\",\"\",V7*(1+W7))","v":0},{"$f":"IF(LEFT(G7,7)='Dane wyjściowe'!$D$2,5%*X7,\"\")","v":""},{"$f":"IF(LEFT(G7,7)='Dane wyjściowe'!$D$2,10%*X7,\"\")","v":""},null,null,{"$f":"IF(X7=\"\",\"\",SUM(X7:AB7))","v":0}]
["",null,3,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F8,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G8,7)=\"O pracę\",U8*VLOOKUP(PRACOWNICY!T8,'Dane kadrowe'!$A$5:$B$26,2,1),U8*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q8=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},{"$f":"IF(V8=\"\",\"\",V8*(1+W8))","v":""},{"$f":"IF(LEFT(G8,7)='Dane wyjściowe'!$D$2,5%*X8,\"\")","v":""},{"$f":"IF(LEFT(G8,7)='Dane wyjściowe'!$D$2,10%*X8,\"\")","v":""},null,null,{"$f":"IF(X8=\"\",\"\",SUM(X8:AB8))","v":""}]
["",null,4,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F9,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G9,7)=\"O pracę\",U9*VLOOKUP(PRACOWNICY!T9,'Dane kadrowe'!$A$5:$B$26,2,1),U9*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q9=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G9,7)='Dane wyjściowe'!$D$2,5%*X9,\"\")","v":""},{"$f":"IF(LEFT(G9,7)='Dane wyjściowe'!$D$2,10%*X9,\"\")","v":""},null,null,""]
["",null,5,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F10,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G10,7)=\"O pracę\",U10*VLOOKUP(PRACOWNICY!T10,'Dane kadrowe'!$A$5:$B$26,2,1),U10*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q10=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G10,7)='Dane wyjściowe'!$D$2,5%*X10,\"\")","v":""},{"$f":"IF(LEFT(G10,7)='Dane wyjściowe'!$D$2,10%*X10,\"\")","v":""},null,null,""]
["",null,6,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F11,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G11,7)=\"O pracę\",U11*VLOOKUP(PRACOWNICY!T11,'Dane kadrowe'!$A$5:$B$26,2,1),U11*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q11=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G11,7)='Dane wyjściowe'!$D$2,5%*X11,\"\")","v":""},{"$f":"IF(LEFT(G11,7)='Dane wyjściowe'!$D$2,10%*X11,\"\")","v":""},null,null,""]
["",null,7,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F12,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G12,7)=\"O pracę\",U12*VLOOKUP(PRACOWNICY!T12,'Dane kadrowe'!$A$5:$B$26,2,1),U12*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q12=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G12,7)='Dane wyjściowe'!$D$2,5%*X12,\"\")","v":""},{"$f":"IF(LEFT(G12,7)='Dane wyjściowe'!$D$2,10%*X12,\"\")","v":""},null,null,""]
["",null,8,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F13,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G13,7)=\"O pracę\",U13*VLOOKUP(PRACOWNICY!T13,'Dane kadrowe'!$A$5:$B$26,2,1),U13*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q13=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G13,7)='Dane wyjściowe'!$D$2,5%*X13,\"\")","v":""},{"$f":"IF(LEFT(G13,7)='Dane wyjściowe'!$D$2,10%*X13,\"\")","v":""},null,null,""]
["",null,9,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F14,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G14,7)=\"O pracę\",U14*VLOOKUP(PRACOWNICY!T14,'Dane kadrowe'!$A$5:$B$26,2,1),U14*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q14=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G14,7)='Dane wyjściowe'!$D$2,5%*X14,\"\")","v":""},{"$f":"IF(LEFT(G14,7)='Dane wyjściowe'!$D$2,10%*X14,\"\")","v":""},null,null,""]
["",null,10,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F15,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G15,7)=\"O pracę\",U15*VLOOKUP(PRACOWNICY!T15,'Dane kadrowe'!$A$5:$B$26,2,1),U15*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q15=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G15,7)='Dane wyjściowe'!$D$2,5%*X15,\"\")","v":""},{"$f":"IF(LEFT(G15,7)='Dane wyjściowe'!$D$2,10%*X15,\"\")","v":""},null,null,""]
["",null,11,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F16,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"",{"$f":"IF(Q16=\"\",\"\",Q16*T16)","v":""},{"$f":"IFERROR(IF(LEFT(G16,7)=\"O pracę\",U16*VLOOKUP(PRACOWNICY!T16,'Dane kadrowe'!$A$5:$B$26,2,1),U16*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q16=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},{"$f":"IF(V16=\"\",\"\",V16*(1+W16))","v":""},{"$f":"IF(LEFT(G16,7)='Dane wyjściowe'!$D$2,5%*X16,\"\")","v":""},{"$f":"IF(LEFT(G16,7)='Dane wyjściowe'!$D$2,10%*X16,\"\")","v":""},null,null,{"$f":"IF(X16=\"\",\"\",SUM(X16:AB16))","v":""}]
["",null,12,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F17,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"",{"$f":"IF(Q17=\"\",\"\",Q17*T17)","v":""},{"$f":"IFERROR(IF(LEFT(G17,7)=\"O pracę\",U17*VLOOKUP(PRACOWNICY!T17,'Dane kadrowe'!$A$5:$B$26,2,1),U17*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q17=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},{"$f":"IF(V17=\"\",\"\",V17*(1+W17))","v":""},{"$f":"IF(LEFT(G17,7)='Dane wyjściowe'!$D$2,5%*X17,\"\")","v":""},{"$f":"IF(LEFT(G17,7)='Dane wyjściowe'!$D$2,10%*X17,\"\")","v":""},null,null,{"$f":"IF(X17=\"\",\"\",SUM(X17:AB17))","v":""}]
["",null,13,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F18,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G18,7)=\"O pracę\",U18*VLOOKUP(PRACOWNICY!T18,'Dane kadrowe'!$A$5:$B$26,2,1),U18*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q18=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G18,7)='Dane wyjściowe'!$D$2,5%*X18,\"\")","v":""},{"$f":"IF(LEFT(G18,7)='Dane wyjściowe'!$D$2,10%*X18,\"\")","v":""},null,null,""]
["",null,14,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F19,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G19,7)=\"O pracę\",U19*VLOOKUP(PRACOWNICY!T19,'Dane kadrowe'!$A$5:$B$26,2,1),U19*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q19=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G19,7)='Dane wyjściowe'!$D$2,5%*X19,\"\")","v":""},{"$f":"IF(LEFT(G19,7)='Dane wyjściowe'!$D$2,10%*X19,\"\")","v":""},null,null,""]
["",null,15,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F20,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G20,7)=\"O pracę\",U20*VLOOKUP(PRACOWNICY!T20,'Dane kadrowe'!$A$5:$B$26,2,1),U20*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q20=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G20,7)='Dane wyjściowe'!$D$2,5%*X20,\"\")","v":""},{"$f":"IF(LEFT(G20,7)='Dane wyjściowe'!$D$2,10%*X20,\"\")","v":""},null,null,""]
["",null,16,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F21,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G21,7)=\"O pracę\",U21*VLOOKUP(PRACOWNICY!T21,'Dane kadrowe'!$A$5:$B$26,2,1),U21*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q21=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G21,7)='Dane wyjściowe'!$D$2,5%*X21,\"\")","v":""},{"$f":"IF(LEFT(G21,7)='Dane wyjściowe'!$D$2,10%*X21,\"\")","v":""},null,null,""]
["",null,17,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F22,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G22,7)=\"O pracę\",U22*VLOOKUP(PRACOWNICY!T22,'Dane kadrowe'!$A$5:$B$26,2,1),U22*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q22=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G22,7)='Dane wyjściowe'!$D$2,5%*X22,\"\")","v":""},{"$f":"IF(LEFT(G22,7)='Dane wyjściowe'!$D$2,10%*X22,\"\")","v":""},null,null,""]
["",null,18,null,null,null,"",null,null,0,null,null,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F23,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":""},"","",null,"","",{"$f":"IFERROR(IF(LEFT(G23,7)=\"O pracę\",U23*VLOOKUP(PRACOWNICY!T23,'Dane kadrowe'!$A$5:$B$26,2,1),U23*'Dane kadrowe'!$D$34),\"\")","v":""},{"$f":"IF(Q23=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},"",{"$f":"IF(LEFT(G23,7)='Dane wyjściowe'!$D$2,5%*X23,\"\")","v":""},{"$f":"IF(LEFT(G23,7)='Dane wyjściowe'!$D$2,10%*X23,\"\")","v":""},null,null,""]
[null,null,"SUMA",null,null,null,null,null,null,{"$f":"SUMPRODUCT(J6:J23,K6:K23)","v":0},{"$f":"SUM(K6:K23)","v":0},null,null,null,null,null,{"$f":"SUM(Q6:Q23)","v":0},null,null,null,{"$f":"SUM(U6:U23)","v":0},{"$f":"SUM(V6:V23)","v":0},null,{"$f":"SUM(X6:X23)","v":0},0,0,0,0,0]
[]
[null,null,"Koordynacja - nadzór / Koordynator mobliny "]
[null,null,"Lp","Typ pracownika","Opis stanowiska","Sezon","Rodzaj umowy","rbh/dzień","Ilość osób","Ilość dni pracujących w tygodniu ","Ilość dni w tygodniu","Średnio dni w miesiącu","Ilośc miesięcy w roku","Ilość pracujących miesięcy","rbh/m-c","zł netto/rbh stawka minimum","nowa stawka zł netto/rbh","zł netto/rbh","Netto pracownika","Brutto pracownika","Wskaźnik pracodawcy ZUS","Brutto pracodawcy","Zakwaterowanie","Dojazd","Koszt pracodawcy"]
[null,null,1,"Główny kierownik obiektu (przyjezdny) - umowa o pracę","Nadzór","Cały rok",{"$f":"IF(D28=\"\",\"\",MID(D28,FIND(\"umowa\",D28)+6,100))","v":"o pracę"},1,1,1,7,29.4,12,{"$f":"IFERROR(VLOOKUP(F28,'Dane wyjściowe'!$A$1:$B$4,2,0),\"\")","v":12},{"$f":"IFERROR(CEILING(I28*H28*L28/K28*J28*N28/M28,TIME(1,0,0)),\"\")","v":4.208333333333333},{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,$D$36:$E$46,2,0))","v":33},null,{"$f":"IF(P28=\"\",\"\",MAX(P28:Q28))","v":33},{"$f":"IFERROR(R28*O28,\"\")","v":138.875},{"$f":"IFERROR(IF(LEFT(G28,7)=\"O pracę\",S28*VLOOKUP(PRACOWNICY!R28,'Dane kadrowe'!$A$5:$B$26,2,1),S28*'Dane kadrowe'!$D$34),\"\")","v":193.49453750000004},{"$f":"IF(O28=\"\",\"\",'Dane kadrowe'!$B$53)","v":0.20480000000000001},{"$f":"IF(T28=\"\",\"\",T28*(1+U28))","v":233.12221878000005},null,null,{"$f":"IF(V28=\"\",\"\",V28+W28+X28)","v":233.12221878000005}]
[]
[null,null,"Dodatki funcyjne / dojazdy / inne "]
[null,null,"Lp","Rodzaj dodatku","Opis dodatku","Rodzaj umowy","Kwota całkowita netto","Brutto pracownika","Wskaźnik pracodawcy ZUS","Koszt pracodawcy"]
[null,null,1,"Inne dodatki dla pracowników / dojazdy",null,null,null,{"$f":"IF(F32=\"\",\"\",IFERROR(IF(LEFT(F32,7)=\"O pracę\",G32*VLOOKUP(G32,'Dane kadrowe'!$A$5:$B$26,2,1),G32*'Dane kadrowe'!$D$34),\"\"))","v":""},{"$f":"IF(F32=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},{"$f":"IF(H32=\"\",\"\",H32*(1+I32))","v":""}]
[null,null,2,"Inne dodatki dla pracowników",null,null,null,{"$f":"IF(F33=\"\",\"\",IFERROR(IF(LEFT(F33,7)=\"O pracę\",G33*VLOOKUP(G33,'Dane kadrowe'!$A$5:$B$26,2,1),G33*'Dane kadrowe'!$D$34),\"\"))","v":""},{"$f":"IF(F33=\"\",\"\",'Dane kadrowe'!$B$53)","v":""},{"$f":"IF(H33=\"\",\"\",H33*(1+I33))","v":""}]
[]
[]
[null,null,null,"TYP PRACOWNIKA","Minimalne stawki netto dla pracowników"]
[null,null,null,"Pracownik porządkowy - umowa o pracę",21.5]
[null,null,null,"Pracownik porządkowy - umowa zlecenie",24.5]
[null,null,null,"Pracownik porządkowy (teren zewnętrzny) - umowa o pracę",21.5]
[null,null,null,"Pracownik porządkowy (teren zewnętrzny) - umowa zlecenie",24.5]
[null,null,null,"Operator maszyny czyszczącej - umowa o pracę",21.5]
[null,null,null,"Operator maszyny czyszczącej - umowa zlecenie",24.5]
[null,null,null,"Koordynator - umowa zlecenie",27]
[null,null,null,"Koordynator - umowa o pracę",27]
[null,null,null,"Główny kierownik obiektu (przyjezdny) - umowa o pracę",33]

{"sheet":"Pracownicy podsuma","index":3,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Etykiety wierszy","Suma z rbh/m-c","Suma z Brutto pracodawcy z rezerwami"]
[null,null,0,0,null,null,"tabela potrzebna wyłącznie do Wykorzystania budżetu"]
[null,"Umowa o pracę - stawka 15,00 zł",168,4018.273056]
[null,"Umowa zlecenie - stawka 13,50 zł",252,5424.6686256000003]
[null,"Suma końcowa",420,9442.9416816000012]

{"sheet":"MASZYNY SPRZĘT","index":4,"n_rows":106,"n_cols":21,"rows_kept":106,"cut":false,"hidden":false,"merged":[[105,3,105,14],[81,3,81,16],[57,3,57,16],[3,3,3,16],[1,3,1,16],[55,3,55,14],[79,3,79,14],[93,3,93,14],[104,3,104,15],[102,3,102,14],[95,3,95,16]]}
[]
[null,null,null,"MASZYNY / SPRZĘT"]
[]
[null,null,null,"Maszyny sprzątające"]
[null,null,{"$f":"COUNTIF(C7:C29,2)","v":0},"Lp","Nazwa maszyny","Wydajność maszyny mkw/h","Szerokość czyszczenia mm","Czas pracy maszyny","Cena","Cena z wynajmem","Okres spłaty [msc]","Miesięczny koszt","Eksploatacja [msc]","Cena 1 szt. do oferty [msc]","Ilość maszyn","Kwota do oferty","Eksploatacja kwotowo (1 szt.)","Czy uwzględniać","Wskaźnik eksploatacji"]
[{"$f":"COUNTIF($R$6:R6,\"tak\")","v":0},{"$f":"IF(A6>=MAX($A6:A$6),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B6=\"TAK\",A6,\"\")","v":0},1,"Tennant T16 lit-jon + H2O + ES","8200/7000",910,"ok. 4h",103500,{"$f":"I6*1.2","v":124200},36,{"$f":"IFERROR((J6/K6)*O6,0)","v":0},{"$f":"L6*0.2","v":0},{"$f":"IFERROR((J6/K6)*S6,0)","v":4140},0,{"$f":"L6*S6","v":0},{"$f":"J6*S6-J6","v":24840},{"$f":"IF(O6>0,\"tak\",\"nie\")","v":"nie"},1.2]
[{"$f":"COUNTIF($R$6:R7,\"tak\")","v":0},{"$f":"IF(A7>MAX($A$6:A6),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B7=\"TAK\",A7,\"\")","v":""},{"$f":"D6+1","v":2},"Tennant T16 lit-jon + H2O","8200/7000",910,"ok. 4h",96000,{"$f":"I7*1.2","v":115200},36,{"$f":"IFERROR((J7/K7)*O7,0)","v":0},0,{"$f":"IFERROR((J7/K7)*S7,0)","v":3840},0,{"$f":"L7*S7","v":0},{"$f":"J7*S7-J7","v":23040},{"$f":"IF(O7>0,\"tak\",\"nie\")","v":"nie"},1.2]
[{"$f":"COUNTIF($R$6:R8,\"tak\")","v":0},{"$f":"IF(A8>MAX($A$6:A7),\"TAK\",\"NIE\")","v":"NIE"},"",{"$f":"D7+1","v":3},"Tennant T16 lit-jon","8200/7000",910,"ok. 4h",90000,{"$f":"I8*1.2","v":108000},36,{"$f":"IFERROR((J8/K8)*O8,0)","v":0},{"$f":"L8*0.2","v":0},{"$f":"IFERROR((J8/K8)*S8,0)","v":3600},0,{"$f":"L8*S8","v":0},{"$f":"J8*S8-J8","v":21600},"nie",1.2]
[{"$f":"COUNTIF($R$6:R9,\"tak\")","v":0},{"$f":"IF(A9>MAX($A$6:A8),\"TAK\",\"NIE\")","v":"NIE"},"",4,"Taski Swingo 5000 200 lit-jon",5000,1005,"ok. 6,5h",74500,89400,36,0,0,2980,0,0,17880,"nie",1.2]
[{"$f":"COUNTIF($R$6:R10,\"tak\")","v":0},{"$f":"IF(A10>MAX($A$6:A9),\"TAK\",\"NIE\")","v":"NIE"},"",5,"Tennant T12 lit-jon + H2O","6700 / 4500",800,"ok. 3,5h",78000,93600,36,0,0,3120,0,0,18720,"nie",1.2]
[{"$f":"COUNTIF($R$6:R11,\"tak\")","v":0},{"$f":"IF(A11>MAX($A$6:A10),\"TAK\",\"NIE\")","v":"NIE"},"",6,"Tennant T12 lit-jon ","6700 / 4500",800,"ok. 3,5h",73500,88200,36,0,0,2940,0,0,17640,"nie",1.2]
[{"$f":"COUNTIF($R$6:R12,\"tak\")","v":0},{"$f":"IF(A12>MAX($A$6:A11),\"TAK\",\"NIE\")","v":"NIE"},"",7,"Taski Swingo 4000 200 lit-jon",4000,850,"ok. 4,5 h",64750,77700,36,0,0,2590,0,0,15540,"nie",1.2]
[{"$f":"COUNTIF($R$6:R13,\"tak\")","v":0},{"$f":"IF(A13>MAX($A$6:A12),\"TAK\",\"NIE\")","v":"NIE"},"",8,"Tennant T7 lit-jon + H2O","5000/3000",810,"ok. 3,5h",58500,70200,36,0,0,2340,0,0,14040,"nie",1.2]
[{"$f":"COUNTIF($R$6:R14,\"tak\")","v":0},{"$f":"IF(A14>MAX($A$6:A13),\"TAK\",\"NIE\")","v":"NIE"},"",9,"Tennant T7 lit-jon","5000/3000",810,"ok. 3,5h",54000,64800,36,0,0,2160,0,0,12960,{"$f":"IF(O14>0,\"tak\",\"nie\")","v":"nie"},1.2]
[{"$f":"COUNTIF($R$6:R15,\"tak\")","v":0},{"$f":"IF(A15>MAX($A$6:A14),\"TAK\",\"NIE\")","v":"NIE"},"",10,"Numatic TVL850 (150T - 3 akumulatory)",4250,"650 / 750 / 850","ok. 3,5h",52500,63000,36,0,0,2100,0,0,12600,"nie",1.2]
[{"$f":"COUNTIF($R$6:R16,\"tak\")","v":0},{"$f":"IF(A16>MAX($A$6:A15),\"TAK\",\"NIE\")","v":"NIE"},"",11,"Numatic TVL850 (200T - 4 akumulatory)",4250,"650 / 750 / 850","ok. 4,5h",55500,66600,36,0,0,2220,0,0,13320,"nie",1.2]
[{"$f":"COUNTIF($R$6:R17,\"tak\")","v":0},{"$f":"IF(A17>MAX($A$6:A16),\"TAK\",\"NIE\")","v":"NIE"},"",12,"Numatic TVL850 (300T - 6 akumulatorów)",4250,"650 / 750 / 850","ok. 6,5h",61500,73800,36,0,0,2460,0,0,14760,"nie",1.2]
[{"$f":"COUNTIF($R$6:R18,\"tak\")","v":0},{"$f":"IF(A18>MAX($A$6:A17),\"TAK\",\"NIE\")","v":"NIE"},"",13,"Maszyna samojezdna Tennant T581","3290 / 2040",510,"ok. 2,5h",37500,45000,36,0,0,1500,0,0,9000,"nie",1.2]
[{"$f":"COUNTIF($R$6:R19,\"tak\")","v":0},{"$f":"IF(A19>MAX($A$6:A18),\"TAK\",\"NIE\")","v":"NIE"},"",14,"Maszyna samojezdna Nilfisk SC 3500","4260/2980",710,"ok. 4h",35300,42360,36,0,0,1412,0,0,8472,"nie",1.2]
[{"$f":"COUNTIF($R$6:R20,\"tak\")","v":0},{"$f":"IF(A20>MAX($A$6:A19),\"TAK\",\"NIE\")","v":"NIE"},"",15,"Maszyna Samojezdna Numatic CRL 8072/100T",3000,720,"ok. 3 h",43500,52200,36,0,0,1740,0,0,10440,"nie",1.2]
[{"$f":"COUNTIF($R$6:R21,\"tak\")","v":0},{"$f":"IF(A21>MAX($A$6:A20),\"TAK\",\"NIE\")","v":"NIE"},"",16,"Maszyna samojezdna Taski Swingo 2500 lit-jon",2500,700,"ok. 6 h",56600,67920,36,0,0,2264,0,0,13584,"nie",1.2]
[{"$f":"COUNTIF($R$6:R22,\"tak\")","v":0},{"$f":"IF(A22>MAX($A$6:A21),\"TAK\",\"NIE\")","v":"NIE"},"",17,"Maszyna samojezdna  Taski Swingo 2100 lit-jon",2100,550,"ok. 4 h",42800,51360,36,0,0,1712,0,0,{"$f":"J22*S22-J22","v":10272},"nie",1.2]
[{"$f":"COUNTIF($R$6:R23,\"tak\")","v":0},{"$f":"IF(A23>MAX($A$6:A22),\"TAK\",\"NIE\")","v":"NIE"},"",18,"Maszyna samojezdna Nilfisk SC2000 Full",2230,520,"ok. 4 h",26150,31380,36,0,0,1046,0,0,{"$f":"J23*S23-J23","v":6276},"nie",1.2]
[{"$f":"COUNTIF($R$6:R24,\"tak\")","v":0},{"$f":"IF(A24>MAX($A$6:A23),\"TAK\",\"NIE\")","v":"NIE"},"",19,"Cleanfix RA565 IBC mały automat samojezdny",3000,"1260/500/1050","ok. 4 h",30000,36000,36,0,0,1200,0,0,7200,"nie",1.2]
[{"$f":"COUNTIF($R$6:R25,\"tak\")","v":0},{"$f":"IF(A25>MAX($A$6:A24),\"TAK\",\"NIE\")","v":"NIE"},"",20,"Maszyna pchana - Numatic TBL4045 lit-fosfor",1600,450,"ok 100 min.",21800,26160,36,0,0,871.99999999999989,0,0,5232,"nie",1.2]
[{"$f":"COUNTIF($R$6:R26,\"tak\")","v":0},{"$f":"IF(A26>MAX($A$6:A25),\"TAK\",\"NIE\")","v":"NIE"},"",21,"Maszyna pchana - Tennant T300 e Li-ion + H2O","2500 / 1600",600,"ok. 3h",25500,30600,36,0,0,1020,0,0,6120,"nie",1.2]
[{"$f":"COUNTIF($R$6:R27,\"tak\")","v":0},{"$f":"IF(A27>MAX($A$6:A26),\"TAK\",\"NIE\")","v":"NIE"},"",22,"Maszyna pchana - Tennant T300 e Li-ion ","2500 / 1600",600,"ok. 3h",22500,{"$f":"I27*1.2","v":27000},36,{"$f":"IFERROR((J27/K27)*O27,0)","v":0},0,{"$f":"IFERROR((J27/K27)*S27,0)","v":900},0,0,{"$f":"J27*S27-J27","v":5400},"nie",1.2]
[{"$f":"COUNTIF($R$6:R28,\"tak\")","v":0},{"$f":"IF(A28>MAX($A$6:A27),\"TAK\",\"NIE\")","v":"NIE"},"",23,"Maszyna pchana - Taski Swingo 455 lit-jon",1290,455,"ok. 1,5-2h",18600,22320,36,0,0,744,0,0,4464,"nie",1.2]
[{"$f":"COUNTIF($R$6:R29,\"tak\")","v":0},{"$f":"IF(A29>MAX($A$6:A28),\"TAK\",\"NIE\")","v":"NIE"},"",24,"Maszyna pchana - Taski ULTIMAXX 1900 SD43 lit-jon",968,430,"ok. 2 h",26200,31440,36,0,0,1048,0,0,6288,"nie",1.2]
[{"$f":"COUNTIF($R$6:R30,\"tak\")","v":0},{"$f":"IF(A30>MAX($A$6:A29),\"TAK\",\"NIE\")","v":"NIE"},"",25,"Maszyna pchana - Taski ULTIMAXX 1900 DD55 lit-jon",null,550,"ok. 2 h",32700,39240,36,0,0,1308,0,0,7848,"nie",1.2]
[{"$f":"COUNTIF($R$6:R31,\"tak\")","v":0},{"$f":"IF(A31>MAX($A$6:A30),\"TAK\",\"NIE\")","v":"NIE"},"",26,"Maszyna pchana Nilfisk SC500 Full (z trakcją)","2650/1590",530,"ok. 5h",20850,25020,36,0,0,834,0,0,5004,"nie",1.2]
[{"$f":"COUNTIF($R$6:R32,\"tak\")","v":0},{"$f":"IF(A32>MAX($A$6:A31),\"TAK\",\"NIE\")","v":"NIE"},"",27,"Maszyna pchana Nilfisk SC430 B Full Go Line (bez trakcji)","2120/1272",530,"ok. 2-3h",11400,13680,36,0,0,456,0,0,2736,"nie",1.2]
[{"$f":"COUNTIF($R$6:R33,\"tak\")","v":0},{"$f":"IF(A33>MAX($A$6:A32),\"TAK\",\"NIE\")","v":"NIE"},"",28,"Maszyna pchana Nilfisk SC401BD (z trakcją)","1720/1032",430,"ok. 2,5 h",16300,19560,36,0,0,652,0,0,3912,"nie",1.2]
[{"$f":"COUNTIF($R$6:R34,\"tak\")","v":0},{"$f":"IF(A34>MAX($A$6:A33),\"TAK\",\"NIE\")","v":"NIE"},"",29,"Maszyna pchana Nilfisk SC401 B (bez trakcji)","1720/860",430,"ok. 2,5 h",14100,16920,36,0,0,564,0,0,3384,"nie",1.2]
[{"$f":"COUNTIF($R$6:R35,\"tak\")","v":0},{"$f":"IF(A35>MAX($A$6:A34),\"TAK\",\"NIE\")","v":"NIE"},"",30,"Tennant T2 lit-jon","1720 / 950",430,"ok. 3h",18000,21600,36,0,0,720,0,0,4320,"nie",1.2]
[{"$f":"COUNTIF($R$6:R36,\"tak\")","v":0},{"$f":"IF(A36>MAX($A$6:A35),\"TAK\",\"NIE\")","v":"NIE"},"",31,"Maszyna pchana Numatic TTB 3045NX-R ",1200,450,"ok. 70 min.",18000,21600,36,0,0,720,0,0,4320,"nie",1.2]
[{"$f":"COUNTIF($R$6:R37,\"tak\")","v":0},{"$f":"IF(A37>MAX($A$6:A36),\"TAK\",\"NIE\")","v":"NIE"},"",32,"Taski Ultimax 360 (2 baterie)",250,440,"ok. 1 h",16500,19800,36,0,0,660,0,0,{"$f":"J37*S37-J37","v":3960},"nie",1.2]
[{"$f":"COUNTIF($R$6:R38,\"tak\")","v":0},{"$f":"IF(A38>MAX($A$6:A37),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B38=\"TAK\",A38,\"\")","v":""},33,"Maszyna pchana - Nilfisk SC351 Full","1480/890",370,"ok. 1 h",11065,13278,36,{"$f":"IFERROR((J38/K38)*O38,0)","v":0},0,442.59999999999997,0,0,2655.5999999999985,"nie",1.2]
[{"$f":"COUNTIF($R$6:R39,\"tak\")","v":0},{"$f":"IF(A39>MAX($A$6:A38),\"TAK\",\"NIE\")","v":"NIE"},"",34,"Maszyna pchana - Tennant T191","1600/1200",455,"ok. 2h",14700,17640,36,{"$f":"IFERROR((J39/K39)*O39,0)","v":0},0,588,0,0,3528,"nie",1.2]
[{"$f":"COUNTIF($R$6:R40,\"tak\")","v":0},{"$f":"IF(A40>MAX($A$6:A39),\"TAK\",\"NIE\")","v":"NIE"},"",35,"Maszyna pchana Nilfisk SC250","1360/680",340,"ok. 40 min.",8840,10608,24,0,0,530.4,0,0,2121.6000000000004,"nie",1.2]
[{"$f":"COUNTIF($R$6:R41,\"tak\")","v":0},{"$f":"IF(A41>MAX($A$6:A40),\"TAK\",\"NIE\")","v":"NIE"},"",36,"Zamiatarka samojezdna TASKI balimat 2300 ",2300,null,null,10500,12600,24,0,0,630,0,0,2520,"nie",1.2]
[{"$f":"COUNTIF($R$6:R42,\"tak\")","v":0},{"$f":"IF(A42>MAX($A$6:A41),\"TAK\",\"NIE\")","v":"NIE"},"",37,"Zamiatarka samojezdna TASKI balimat 3300 ",3300,null,null,22500,27000,36,0,0,900,0,0,5400,"nie",1.2]
[{"$f":"COUNTIF($R$6:R43,\"tak\")","v":0},{"$f":"IF(A43>MAX($A$6:A42),\"TAK\",\"NIE\")","v":"NIE"},"",38,"Zamiatarka samojezdna TASKI balimat 6500 ",6500,"700-1150","ok. 3,5 h",52000,62400,36,0,{"$f":"L43*0.2","v":0},2080,0,0,12480,"nie",1.2]
[{"$f":"COUNTIF($R$6:R44,\"tak\")","v":0},{"$f":"IF(A44>MAX($A$6:A43),\"TAK\",\"NIE\")","v":"NIE"},"",39,"Zamiatarka samojezdna NILFISK SW3000 LI-JON","6120/4280",1350,"ok. 4h",42300,50760,36,0,0,1692,0,0,10152,"nie",1.2]
[{"$f":"COUNTIF($R$6:R45,\"tak\")","v":0},{"$f":"IF(A45>MAX($A$6:A44),\"TAK\",\"NIE\")","v":"NIE"},"",40,"Zamiatarka Tennant S680 (RECON - po regeneracji)",6300,"650-1050","ok. 3h",54000,64800,36,0,0,2160,0,0,12960,"nie",1.2]
[{"$f":"COUNTIF($R$6:R46,\"tak\")","v":0},{"$f":"IF(A46>MAX($A$6:A45),\"TAK\",\"NIE\")","v":"NIE"},"",41,"Zamiatarka z napędem ręcznym POLI JOLY",1000,"600-800","-",2790,3348,24,0,0,167.4,0,0,669.59999999999991,"nie",1.2]
[{"$f":"COUNTIF($R$6:R47,\"tak\")","v":0},{"$f":"IF(A47>MAX($A$6:A46),\"TAK\",\"NIE\")","v":"NIE"},"",42,"Podstawowa zamiatarka z napędem ręcznym KARCHER S4 Twin",2400,680,"-",800,960,24,0,0,48,0,0,192,"nie",1.2]
[{"$f":"COUNTIF($R$6:R48,\"tak\")","v":0},{"$f":"IF(A48>MAX($A$6:A47),\"TAK\",\"NIE\")","v":"NIE"},"",43,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R49,\"tak\")","v":0},{"$f":"IF(A49>MAX($A$6:A48),\"TAK\",\"NIE\")","v":"NIE"},"",44,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R50,\"tak\")","v":0},{"$f":"IF(A50>MAX($A$6:A49),\"TAK\",\"NIE\")","v":"NIE"},"",45,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R51,\"tak\")","v":0},{"$f":"IF(A51>MAX($A$6:A50),\"TAK\",\"NIE\")","v":"NIE"},"",46,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R52,\"tak\")","v":0},{"$f":"IF(A52>MAX($A$6:A51),\"TAK\",\"NIE\")","v":"NIE"},"",47,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R53,\"tak\")","v":0},{"$f":"IF(A53>MAX($A$6:A52),\"TAK\",\"NIE\")","v":"NIE"},"",48,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R54,\"tak\")","v":0},{"$f":"IF(A54>MAX($A$6:A53),\"TAK\",\"NIE\")","v":"NIE"},"",49,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R55,\"tak\")","v":0},{"$f":"IF(A55>MAX($A$6:A54),\"TAK\",\"NIE\")","v":"NIE"},"",50,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:P55)","v":0}]
[]
[null,null,null,"Sprzęt podstawowy - SPRZĘT DROBNY"]
[null,null,{"$f":"COUNTIF(C61:C92,2)","v":0},"Lp","Nazwa maszyny","Wydajność maszyny mkw/h","Szerokość czyszczenia mm","Czas pracy maszyny","Szerokość czyszczenia mm","Cena","Okres spłaty [msc]","Miesięczny koszt","Eksploatacja [msc]","Cena 1 szt. do oferty z eksploatacją [msc]","Ilość maszyn","Kwota do oferty","Eksploatacja kwotowo (1 szt.)","Czy uwzględniać","Wskaźnik eksploatacji","Cena z eksploatacją"]
[{"$f":"COUNTIF($R$60:R60,\"tak\")","v":0},{"$f":"IF(A60>MAX($A60:A$60),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(R60=\"TAK\",A60,\"\")","v":""},{"$f":"D55+1","v":51},"Odkurzacz biurowy - Numatic PRP180 / Taski Go","-",null,"-",null,555,24,{"$f":"IFERROR((J60/K60)*O60,0)","v":0},{"$f":"L60*(S60-1)","v":0},{"$f":"IFERROR((T60/K60),0)","v":27.75},0,{"$f":"L60*S60","v":0},{"$f":"T60-J60","v":111},{"$f":"IF(O60>0,\"tak\",\"nie\")","v":"nie"},1.2,{"$f":"J60*S60","v":666}]
[{"$f":"COUNTIF($R$60:R61,\"tak\")","v":0},{"$f":"IF(A61>MAX($A$60:A61),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(R61=\"TAK\",A61,\"\")","v":""},{"$f":"D60+1","v":52},"Odkurzacz piorący CT 470-2","-",null,"-",null,2200,12,{"$f":"IFERROR((J61/K61)*O61,0)","v":0},{"$f":"L61*(S61-1)","v":0},{"$f":"IFERROR((T61/K61),0)","v":220},0,{"$f":"L61*S61","v":0},{"$f":"T61-J61","v":440},{"$f":"IF(O61>0,\"tak\",\"nie\")","v":"nie"},1.2,{"$f":"J61*S61","v":2640}]
[{"$f":"COUNTIF($R$60:R62,\"tak\")","v":0},{"$f":"IF(A62>MAX($A$60:A62),\"TAK\",\"NIE\")","v":"NIE"},"",{"$f":"D61+1","v":53},"Odkurzacz przemysłowy AERO 31-21 INOX PC","-",null,"-",null,915,12,0,0,91.5,0,0,183,"nie",1.2,1098]
[{"$f":"COUNTIF($R$60:R63,\"tak\")","v":0},{"$f":"IF(A63>MAX($A$60:A63),\"TAK\",\"NIE\")","v":"NIE"},"",{"$f":"D62+1","v":54},"Odkurzacz plecakowy kablowy NILFISK GD10 BACK HEPA","-",null,"-",null,1445,12,0,0,144.5,0,0,289,"nie",1.2,1734]
[{"$f":"COUNTIF($R$60:R64,\"tak\")","v":0},{"$f":"IF(A64>MAX($A$60:A64),\"TAK\",\"NIE\")","v":"NIE"},"",55,"Odkurzacz plecakowy bateryjny NILFISK GD5 Battery","-",null,"-",null,4150,12,0,0,415,0,0,830,"nie",1.2,4980]
[{"$f":"COUNTIF($R$60:R65,\"tak\")","v":0},{"$f":"IF(A65>MAX($A$60:A65),\"TAK\",\"NIE\")","v":"NIE"},"",56,"Odkurzacz do pracy na sucho/mokro NILFISK VL500-35 BSF","-",null,"-",null,963,12,0,0,96.3,0,{"$f":"L65*S65","v":0},192.59999999999991,"nie",1.2,1155.5999999999999]
[{"$f":"COUNTIF($R$60:R66,\"tak\")","v":0},{"$f":"IF(A66>MAX($A$60:A66),\"TAK\",\"NIE\")","v":"NIE"},"",57,"Pralko-suszarka - podstawowa","-",null,"-",null,1200,12,0,0,120,0,0,240,"nie",1.2,1440]
[{"$f":"COUNTIF($R$60:R67,\"tak\")","v":0},{"$f":"IF(A67>MAX($A$60:A67),\"TAK\",\"NIE\")","v":"NIE"},"",58,"Profesjonalna pralnico-wirówka","-",null,"-",null,3660,24,0,0,183,0,{"$f":"L67*S67","v":0},732,"nie",1.2,4392]
[{"$f":"COUNTIF($R$60:R68,\"tak\")","v":0},{"$f":"IF(A68>MAX($A$60:A68),\"TAK\",\"NIE\")","v":"NIE"},"",59,"Myjka ciśnieniowa - podstawowa (125 bar)","-",null,"-",null,1230,12,0,0,123,0,{"$f":"L68*S68","v":0},246,"nie",1.2,1476]
[{"$f":"COUNTIF($R$60:R69,\"tak\")","v":0},{"$f":"IF(A69>MAX($A$60:A69),\"TAK\",\"NIE\")","v":"NIE"},"",60,"Myjka ciśnieniowa - profesjonalna (170 bar)","-",null,"-",null,3660,12,0,0,366,0,{"$f":"L69*S69","v":0},732,"nie",1.2,4392]
[{"$f":"COUNTIF($R$60:R70,\"tak\")","v":0},{"$f":"IF(A70>MAX($A$60:A70),\"TAK\",\"NIE\")","v":"NIE"},"",61,"Wózek do sprzątania mały","-",null,"-",null,585,24,{"$f":"IFERROR((J70/K70)*O70,0)","v":0},{"$f":"L70*(S70-1)","v":0},{"$f":"IFERROR((T70/K70),0)","v":29.25},0,{"$f":"L70*S70","v":0},{"$f":"T70-J70","v":117},"nie",1.2,702]
[{"$f":"COUNTIF($R$60:R71,\"tak\")","v":0},{"$f":"IF(A71>MAX($A$60:A71),\"TAK\",\"NIE\")","v":"NIE"},"",62,"Wózek do sprzątania duży (biura, magazyny)","-",null,"-",null,1045,24,{"$f":"IFERROR((J71/K71)*O71,0)","v":0},{"$f":"L71*(S71-1)","v":0},52.25,0,0,209,"nie",1.2,1254,"stały koszt co miesiąc"]
[{"$f":"COUNTIF($R$60:R72,\"tak\")","v":0},{"$f":"IF(A72>MAX($A$60:A72),\"TAK\",\"NIE\")","v":"NIE"},"",63,"Wózek medyczny do sprzątania - VERMOP","-",null,"-",null,3500,24,0,0,175,0,0,700,"nie",1.2,4200]
[{"$f":"COUNTIF($R$60:R73,\"tak\")","v":0},{"$f":"IF(A73>MAX($A$60:A73),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(R73=\"TAK\",A73,\"\")","v":""},64,1,null,null,null,null,null,null,{"$f":"IFERROR((J73/K73)*O73,0)","v":0},{"$f":"L73*(S73-1)","v":0},{"$f":"IFERROR((T73/K73),0)","v":0},0,{"$f":"L73*S73","v":0},{"$f":"T73-J73","v":0},{"$f":"IF(O73>0,\"tak\",\"nie\")","v":"nie"},1.2,{"$f":"J73*S73","v":0}]
[{"$f":"COUNTIF($R$60:R74,\"tak\")","v":0},{"$f":"IF(A74>MAX($A$60:A74),\"TAK\",\"NIE\")","v":"NIE"},"",65,1,null,null,null,null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[{"$f":"COUNTIF($R$60:R75,\"tak\")","v":0},{"$f":"IF(A75>MAX($A$60:A75),\"TAK\",\"NIE\")","v":"NIE"},"",66,1,null,null,null,null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[{"$f":"COUNTIF($R$60:R76,\"tak\")","v":0},{"$f":"IF(A76>MAX($A$60:A76),\"TAK\",\"NIE\")","v":"NIE"},"",67,1,null,null,null,null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[{"$f":"COUNTIF($R$60:R77,\"tak\")","v":0},{"$f":"IF(A77>MAX($A$60:A77),\"TAK\",\"NIE\")","v":"NIE"},"",{"$f":"D76+1","v":68},"Inne np.ścierki, mopy, butelki, atomizery","-",null,"-",null,30,1,{"$f":"IFERROR((J77/K77)*O77,0)","v":0},{"$f":"L77*(S77)","v":0},36,0,0,6,"nie",1.2,36]
[{"$f":"COUNTIF($R$60:R78,\"tak\")","v":0},{"$f":"IF(A78>MAX($A$60:A78),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(R78=\"TAK\",A78,\"\")","v":""},69,2,null,null,null,null,null,null,{"$f":"IFERROR((J78/K78)*O78,0)","v":0},{"$f":"L78*(S78-1)","v":0},{"$f":"IFERROR((T78/K78),0)","v":0},0,{"$f":"L78*S78","v":0},{"$f":"T78-J78","v":0},{"$f":"IF(O78>0,\"tak\",\"nie\")","v":"nie"},1.2,{"$f":"J78*S78","v":0}]
[{"$f":"COUNTIF($R$60:R79,\"tak\")","v":0},{"$f":"IF(A79>MAX($A$60:A79),\"TAK\",\"NIE\")","v":"NIE"},"",70,2,null,null,null,null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P60:P79)","v":0},null,"nie"]
[]
[null,null,null,"Sprzęt do koszenia - SPRZĘT DROBNY",null,null,null,null,null,null,null,null,null,null,null,null,null,"nie"]
[null,null,null,"Lp","Nazwa maszyny","Wydajność maszyny mkw/h",null,"Czas pracy maszyny",null,"Cena","Okres spłaty [msc]","Miesięczny koszt","Eksploatacja [msc]","Cena 1 szt. do oferty z eksploatacją [msc]","Ilość","Kwota do oferty","Eksploatacja kwotowo (1 szt.)",null,"Wskaźnik eksploatacji","Cena z eksploatacją"]
[{"$f":"COUNTIF($R$60:R84,\"tak\")","v":0},{"$f":"IF(A84>MAX($A$60:A83),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B84=\"TAK\",A84,\"\")","v":""},{"$f":"D79+1","v":71},"Kosiarka spalinowa","-",null,"-",null,2100,12,{"$f":"IFERROR((J84/K84)*O84,0)","v":0},{"$f":"L84*(S84-1)","v":0},{"$f":"IFERROR((T84/K84),0)","v":210},0,{"$f":"L84*S84","v":0},{"$f":"T84-J84","v":420},"nie",1.2,{"$f":"J84*S84","v":2520}]
[{"$f":"COUNTIF($R$60:R85,\"tak\")","v":0},{"$f":"IF(A85>MAX($A$60:A84),\"TAK\",\"NIE\")","v":"NIE"},"",72,"Kosa spalinowa (Sparta 441T - 2,0KM)","-",null,"-",null,1500,12,0,0,150,0,0,300,"nie",1.2,1800]
[{"$f":"COUNTIF($R$60:R86,\"tak\")","v":0},{"$f":"IF(A86>MAX($A$60:A85),\"TAK\",\"NIE\")","v":"NIE"},"",73,"Dmuchawa do liści plecakowa (BV163)","-",null,"-",null,1650,12,0,0,165,0,0,330,"nie",1.2,1980]
[{"$f":"COUNTIF($R$60:R87,\"tak\")","v":0},{"$f":"IF(A87>MAX($A$60:A86),\"TAK\",\"NIE\")","v":"NIE"},"",74,"Zamiatarka spalinowa / odrzutnik do śniegu OLEO MAC PKM100","-",null,"-",null,4200,12,0,0,420,0,0,840,"nie",1.2,5040]
[{"$f":"COUNTIF($R$60:R88,\"tak\")","v":0},{"$f":"IF(A88>MAX($A$60:A87),\"TAK\",\"NIE\")","v":"NIE"},"",75,"Traktor wielofunkcyjny z osprzętem OM92/16KH (16KM)","-",null,"-",null,10500,24,0,0,525,0,0,2100,"nie",1.2,12600]
[{"$f":"COUNTIF($R$60:R89,\"tak\")","v":0},{"$f":"IF(A89>MAX($A$60:A88),\"TAK\",\"NIE\")","v":"NIE"},"",76,"Przyczepka do traktora",null,null,null,null,1150,12,0,0,115,0,0,230,"nie",1.2,1380]
[{"$f":"COUNTIF($R$60:R90,\"tak\")","v":0},{"$f":"IF(A90>MAX($A$60:A89),\"TAK\",\"NIE\")","v":"NIE"},"",77,"Pług do traktora","-",null,"-",null,1550,12,0,0,155,0,0,310,"nie",1.2,1860]
[{"$f":"COUNTIF($R$60:R91,\"tak\")","v":0},{"$f":"IF(A91>MAX($A$60:A90),\"TAK\",\"NIE\")","v":"NIE"},"",78,"Łańcuchy na koła - do traktora","-",null,"-",null,310,12,0,0,31,0,0,62,"nie",1.2,372]
[{"$f":"COUNTIF($R$60:R92,\"tak\")","v":0},{"$f":"IF(A92>MAX($A$60:A91),\"TAK\",\"NIE\")","v":"NIE"},"",79,"Zamiatarka spalinowa YATO 100 CM, poj. 196 cm3","-",null,"-",null,2500,12,0,0,250,0,0,500,"nie",1.2,3000]
[{"$f":"COUNTIF($R$60:R93,\"tak\")","v":0},{"$f":"IF(A93>MAX($A$60:A92),\"TAK\",\"NIE\")","v":"NIE"},"",80,null,"-",null,"-",null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P84:P93)","v":0}]
[]
[null,null,null,"Teren zewnętrzny - sprzęt"]
[null,null,null,"Lp","Zestaw","Wydajność maszyny mkw/h",null,"Czas pracy maszyny",null,"Cena","Okres spłaty [msc]","Miesięczny koszt","Eksploatacja [msc]","Cena 1 szt. do oferty z eksploatacją [msc]","Ilość","Kwota do oferty","Eksploatacja kwotowo (1 szt.)",null,"Wskaźnik eksploatacji","Cena z eksploatacją"]
[null,null,null,1,"Miotła, łopata, grabie, szufelka, wiaderko","-",null,"-",null,300,12,{"$f":"IFERROR((J98/K98)*O98,0)","v":0},{"$f":"L98*(S98-1)","v":0},{"$f":"IFERROR((T98/K98),0)","v":30},0,{"$f":"L98*S98","v":0},{"$f":"T98-J98","v":60},{"$f":"IF(O98>0,\"tak\",\"nie\")","v":"nie"},1.2,{"$f":"J98*S98","v":360}]
[null,null,null,2,null,"-",null,"-",null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,3,null,"-",null,"-",null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,4,null,"-",null,"-",null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,5,null,"-",null,"-",null,null,null,0,0,0,0,0,0,"nie",1.2,0]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P98:P102)","v":0}]
[]
[null,null,null,"MASZYNY / SPRZĘT"]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P84:P93,P60:P79,P6:P55,P103)","v":0}]

{"sheet":"MASZYNY SPRZĘT ceny","index":5,"n_rows":106,"n_cols":20,"rows_kept":106,"cut":false,"hidden":true,"merged":[[104,3,104,4],[1,3,1,16],[3,3,3,16],[57,3,57,16],[81,3,81,16],[95,3,95,15],[102,3,102,14],[55,3,55,14],[79,3,79,14],[93,3,93,14]]}
[]
[null,null,null,"MASZYNY / SPRZĘT"]
[]
[null,null,null,"Maszyny sprzątające"]
[null,null,{"$f":"COUNTIF(C7:C25,2)","v":1},"Lp","Nazwa maszyny","Wydajność maszyny mkw/h","Szerokość czyszczenia mm","Czas pracy maszyny","Cena","Cena z leasingiem","Okres spłaty [msc]","Koszt leasingu [msc]","Eksploatacja [msc]","Cena 1 szt. do oferty [msc]","Ilość maszyn","Kwota do oferty","Eksploatacja kwotowo (1 szt.)","Czy uwzględniać","Wskaźnik eksploatacji"]
[{"$f":"COUNTIF($R$6:R6,\"tak\")","v":1},{"$f":"IF(A6>=MAX($A6:A$6),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B6=\"TAK\",A6,\"\")","v":1},1,"Tennant T16 lit-jon + H2O + ES","8200/7000",910,"ok. 4h",103500,{"$f":"I6*1.2","v":124200},36,{"$f":"IFERROR((J6/K6)*O6,0)","v":3450},{"$f":"L6*0.2","v":690},{"$f":"IFERROR((J6/K6)*S6,0)","v":4140},1,{"$f":"L6*S6","v":4140},{"$f":"J6*S6-J6","v":24840},{"$f":"IF(O6>0,\"tak\",\"nie\")","v":"tak"},1.2]
[{"$f":"COUNTIF($R$6:R7,\"tak\")","v":2},{"$f":"IF(A7>MAX($A$6:A6),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B7=\"TAK\",A7,\"\")","v":2},{"$f":"D6+1","v":2},"Tennant T16 lit-jon + H2O","8200/7001",911,"ok.4h",96000,{"$f":"I7*1.2","v":115200},36,{"$f":"IFERROR((J7/K7)*O7,0)","v":3200},640,{"$f":"IFERROR((J7/K7)*S7,0)","v":3840},1,3840,{"$f":"J7*S7-J7","v":23040},{"$f":"IF(O7>0,\"tak\",\"nie\")","v":"tak"},1.2]
[{"$f":"COUNTIF($R$6:R8,\"tak\")","v":3},{"$f":"IF(A8>MAX($A$6:A7),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B8=\"TAK\",A8,\"\")","v":3},{"$f":"D7+1","v":3},"Tennant T16 lit-jon","8200/7000",910,"ok. 4h",90000,{"$f":"I8*1.2","v":108000},36,{"$f":"IFERROR((J8/K8)*O8,0)","v":3000},{"$f":"L8*0.2","v":600},{"$f":"IFERROR((J8/K8)*S8,0)","v":3600},1,{"$f":"L8*S8","v":3600},{"$f":"J8*S8-J8","v":21600},"tak",1.2]
[{"$f":"COUNTIF($R$6:R9,\"tak\")","v":4},{"$f":"IF(A9>MAX($A$6:A8),\"TAK\",\"NIE\")","v":"TAK"},4,4,"Taski Swingo 5000 200 lit-jon",5000,1005,"ok. 6,5h",74500,89400,36,2483.3333333333335,496.66666666666674,2980,1,2980,17880,"tak",1.2]
[{"$f":"COUNTIF($R$6:R10,\"tak\")","v":5},{"$f":"IF(A10>MAX($A$6:A9),\"TAK\",\"NIE\")","v":"TAK"},5,5,"Tennant T12 lit-jon + H2O","6700 / 4500",800,"ok. 3,5h",78000,93600,36,2600,520,3120,1,3120,18720,"tak",1.2]
[{"$f":"COUNTIF($R$6:R11,\"tak\")","v":6},{"$f":"IF(A11>MAX($A$6:A10),\"TAK\",\"NIE\")","v":"TAK"},6,6,"Tennant T12 lit-jon ","6700 / 4500",800,"ok. 3,5h",73500,88200,36,2450,490,2940,1,2940,17640,"tak",1.2]
[{"$f":"COUNTIF($R$6:R12,\"tak\")","v":7},{"$f":"IF(A12>MAX($A$6:A11),\"TAK\",\"NIE\")","v":"TAK"},7,7,"Taski Swingo 4000 200 lit-jon",4000,850,"ok. 4,5 h",64750,77700,36,2158.3333333333335,431.66666666666674,2590,1,2590,15540,"tak",1.2]
[{"$f":"COUNTIF($R$6:R13,\"tak\")","v":8},{"$f":"IF(A13>MAX($A$6:A12),\"TAK\",\"NIE\")","v":"TAK"},8,8,"Tennant T7 lit-jon + H2O","5000/3000",810,"ok. 3,5h",58500,70200,36,1950,390,2340,1,2340,14040,"tak",1.2]
[{"$f":"COUNTIF($R$6:R14,\"tak\")","v":9},{"$f":"IF(A14>MAX($A$6:A13),\"TAK\",\"NIE\")","v":"TAK"},9,9,"Tennant T7 lit-jon","5000/3000",810,"ok. 3,5h",54000,64800,36,1800,360,2160,1,2160,12960,"tak",1.2]
[{"$f":"COUNTIF($R$6:R15,\"tak\")","v":10},{"$f":"IF(A15>MAX($A$6:A14),\"TAK\",\"NIE\")","v":"TAK"},10,10,"Numatic TVL850 (150T - 3 akumulatory)",4250,"650 / 750 / 850","ok. 3,5h",52500,63000,36,1750,350,2100,1,2100,12600,"tak",1.2]
[{"$f":"COUNTIF($R$6:R16,\"tak\")","v":11},{"$f":"IF(A16>MAX($A$6:A15),\"TAK\",\"NIE\")","v":"TAK"},11,11,"Numatic TVL850 (200T - 4 akumulatory)",4250,"650 / 750 / 850","ok. 4,5h",55500,66600,36,1850,370,2220,1,2220,13320,"tak",1.2]
[{"$f":"COUNTIF($R$6:R17,\"tak\")","v":12},{"$f":"IF(A17>MAX($A$6:A16),\"TAK\",\"NIE\")","v":"TAK"},12,12,"Numatic TVL850 (300T - 6 akumulatorów)",4250,"650 / 750 / 850","ok. 6,5h",61500,73800,36,2050,410,2460,1,2460,14760,"tak",1.2]
[{"$f":"COUNTIF($R$6:R18,\"tak\")","v":13},{"$f":"IF(A18>MAX($A$6:A17),\"TAK\",\"NIE\")","v":"TAK"},13,13,"Maszyna samojezdna Tennant T581","3290 / 2040",510,"ok. 2,5h",37500,45000,36,1250,250,1500,1,1500,9000,"tak",1.2]
[{"$f":"COUNTIF($R$6:R19,\"tak\")","v":14},{"$f":"IF(A19>MAX($A$6:A18),\"TAK\",\"NIE\")","v":"TAK"},14,14,"Maszyna samojezdna Nilfisk SC 3500","4260/2980",710,"ok. 4h",35300,42360,36,1176.6666666666667,235.33333333333337,1412,1,1412,{"$f":"J19*S19-J19","v":8472},"tak",1.2]
[{"$f":"COUNTIF($R$6:R20,\"tak\")","v":15},{"$f":"IF(A20>MAX($A$6:A19),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B20=\"TAK\",A20,\"\")","v":15},15,"Maszyna Samojezdna Numatic CRL 8072/100T",3000,720,"ok. 3 h",43500,52200,36,1450,290,1740,1,1740,{"$f":"J20*S20-J20","v":10440},"tak",1.2]
[{"$f":"COUNTIF($R$6:R21,\"tak\")","v":16},{"$f":"IF(A21>MAX($A$6:A20),\"TAK\",\"NIE\")","v":"TAK"},16,16,"Maszyna samojezdna Taski Swingo 2500 lit-jon",2500,700,"ok. 6 h",56600,67920,36,1886.6666666666667,377.33333333333337,2264,1,2264,13584,"tak",1.2]
[{"$f":"COUNTIF($R$6:R22,\"tak\")","v":17},{"$f":"IF(A22>MAX($A$6:A21),\"TAK\",\"NIE\")","v":"TAK"},17,17,"Maszyna samojezdna  Taski Swingo 2100 lit-jon",2100,550,"ok. 4 h",42800,51360,36,1426.6666666666667,285.33333333333337,1712,1,1712,10272,"tak",1.2]
[{"$f":"COUNTIF($R$6:R23,\"tak\")","v":18},{"$f":"IF(A23>MAX($A$6:A22),\"TAK\",\"NIE\")","v":"TAK"},18,18,"Maszyna samojezdna Nilfisk SC2000 Full",2230,520,"ok. 4 h",26150,31380,36,871.66666666666663,174.33333333333334,1046,1,1046,6276,"tak",1.2]
[{"$f":"COUNTIF($R$6:R24,\"tak\")","v":19},{"$f":"IF(A24>MAX($A$6:A23),\"TAK\",\"NIE\")","v":"TAK"},19,19,"Cleanfix RA565 IBC mały automat samojezdny",3000,"1260/500/1050","ok. 4 h",30000,36000,36,1000,200,1200,1,1200,7200,"tak",1.2]
[{"$f":"COUNTIF($R$6:R25,\"tak\")","v":20},{"$f":"IF(A25>MAX($A$6:A24),\"TAK\",\"NIE\")","v":"TAK"},20,20,"Maszyna pchana - Numatic TBL4045 lit-fosfor",1600,450,"ok 100 min.",21800,26160,36,726.66666666666663,145.33333333333334,871.99999999999989,1,871.99999999999989,5232,"tak",1.2]
[{"$f":"COUNTIF($R$6:R26,\"tak\")","v":21},{"$f":"IF(A26>MAX($A$6:A25),\"TAK\",\"NIE\")","v":"TAK"},21,21,"Maszyna pchana - Tennant T300 e Li-ion + H2O","2500 / 1600",600,"ok. 3h",25500,30600,36,850,170,1020,1,1020,6120,"tak",1.2]
[{"$f":"COUNTIF($R$6:R27,\"tak\")","v":22},{"$f":"IF(A27>MAX($A$6:A26),\"TAK\",\"NIE\")","v":"TAK"},22,22,"Maszyna pchana - Tennant T300 e Li-ion ","2500 / 1600",600,"ok. 3h",22500,27000,36,{"$f":"IFERROR((J27/K27)*O27,0)","v":750},{"$f":"L27*0.2","v":150},{"$f":"IFERROR((J27/K27)*S27,0)","v":900},1,{"$f":"L27*S27","v":900},{"$f":"J27*S27-J27","v":5400},"tak",1.2]
[{"$f":"COUNTIF($R$6:R28,\"tak\")","v":23},{"$f":"IF(A28>MAX($A$6:A27),\"TAK\",\"NIE\")","v":"TAK"},23,23,"Maszyna pchana - Taski Swingo 455 lit-jon",455,null,"ok. 1,5-2h",18600,22320,36,620,124,744,1,744,4464,"tak",1.2]
[{"$f":"COUNTIF($R$6:R29,\"tak\")","v":24},{"$f":"IF(A29>MAX($A$6:A28),\"TAK\",\"NIE\")","v":"TAK"},24,24,"Maszyna pchana - Taski ULTIMAXX 1900 SD43 lit-jon",968,430,"ok. 2 h",26200,31440,36,873.33333333333337,174.66666666666669,1048,1,1048,6288,"tak",1.2]
[{"$f":"COUNTIF($R$6:R30,\"tak\")","v":25},{"$f":"IF(A30>MAX($A$6:A29),\"TAK\",\"NIE\")","v":"TAK"},25,25,"Maszyna pchana - Taski ULTIMAXX 1900 DD55 lit-jon",null,550,"ok. 2 h",32700,39240,36,1090,218,1308,1,1308,7848,"tak",1.2]
[{"$f":"COUNTIF($R$6:R31,\"tak\")","v":26},{"$f":"IF(A31>MAX($A$6:A30),\"TAK\",\"NIE\")","v":"TAK"},26,26,"Maszyna pchana Nilfisk SC500 Full (z trakcją)","2650/1590",530,"ok. 5h",20850,25020,36,695,139,834,1,834,5004,"tak",1.2]
[{"$f":"COUNTIF($R$6:R32,\"tak\")","v":27},{"$f":"IF(A32>MAX($A$6:A31),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B32=\"TAK\",A32,\"\")","v":27},27,"Maszyna pchana Nilfisk SC430 B Full Go Line (bez trakcji)","2120/1272",530,"ok. 2-3h",11400,13680,36,380,76,456,1,456,2736,"tak",1.2]
[{"$f":"COUNTIF($R$6:R33,\"tak\")","v":28},{"$f":"IF(A33>MAX($A$6:A32),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B33=\"TAK\",A33,\"\")","v":28},28,"Maszyna pchana Nilfisk SC401BD (z trakcją)","1720/1032",430,"ok. 2,5 h",16300,19560,36,543.33333333333337,108.66666666666669,652,1,652,3912,"tak",1.2]
[{"$f":"COUNTIF($R$6:R34,\"tak\")","v":29},{"$f":"IF(A34>MAX($A$6:A33),\"TAK\",\"NIE\")","v":"TAK"},29,29,"Maszyna pchana Nilfisk SC401 B (bez trakcji)","1720/860",430,"ok. 2,5 h",14100,16920,36,470,94,564,1,564,3384,"tak",1.2]
[{"$f":"COUNTIF($R$6:R35,\"tak\")","v":30},{"$f":"IF(A35>MAX($A$6:A34),\"TAK\",\"NIE\")","v":"TAK"},30,30,"Tennant T2 lit-jon","1720 / 950",430,"ok. 3h",18000,21600,36,600,120,720,1,720,4320,"tak",1.2]
[{"$f":"COUNTIF($R$6:R36,\"tak\")","v":31},{"$f":"IF(A36>MAX($A$6:A35),\"TAK\",\"NIE\")","v":"TAK"},31,31,"Maszyna pchana Numatic TTB 3045NX-R ",1200,450,"ok. 70 min.",18000,21600,36,600,120,720,1,720,4320,"tak",1.2]
[{"$f":"COUNTIF($R$6:R37,\"tak\")","v":32},{"$f":"IF(A37>MAX($A$6:A36),\"TAK\",\"NIE\")","v":"TAK"},32,32,"Taski Ultimax 360 (2 baterie)",360,null,"ok. 1 h",16500,19800,36,550,110,660,1,660,3960,"tak",1.2]
[{"$f":"COUNTIF($R$6:R38,\"tak\")","v":33},{"$f":"IF(A38>MAX($A$6:A37),\"TAK\",\"NIE\")","v":"TAK"},33,33,"Maszyna pchana - Nilfisk SC351 Full","1480/890",370,"ok. 1 h",11065,13278,36,368.83333333333331,73.766666666666666,442.59999999999997,1,442.59999999999997,2655.5999999999985,"tak",1.2]
[{"$f":"COUNTIF($R$6:R39,\"tak\")","v":34},{"$f":"IF(A39>MAX($A$6:A38),\"TAK\",\"NIE\")","v":"TAK"},34,34,"Maszyna pchana - Tennant T191","1600/1200",455,"ok. 2h",14700,17640,36,490,98,588,1,588,3528,"tak",1.2]
[{"$f":"COUNTIF($R$6:R40,\"tak\")","v":35},{"$f":"IF(A40>MAX($A$6:A39),\"TAK\",\"NIE\")","v":"TAK"},35,35,"Maszyna pchana Nilfisk SC250","1360/680",340,"ok. 40 min.",8840,10608,24,442,88.4,530.4,1,530.4,2121.6000000000004,"tak",1.2]
[{"$f":"COUNTIF($R$6:R41,\"tak\")","v":36},{"$f":"IF(A41>MAX($A$6:A40),\"TAK\",\"NIE\")","v":"TAK"},36,36,"Zamiatarka samojezdna TASKI balimat 2300 ",2300,null,null,10500,12600,24,525,105,630,1,630,2520,"tak",1.2]
[{"$f":"COUNTIF($R$6:R42,\"tak\")","v":37},{"$f":"IF(A42>MAX($A$6:A41),\"TAK\",\"NIE\")","v":"TAK"},37,37,"Zamiatarka samojezdna TASKI balimat 3300 ",3300,null,null,22500,27000,36,750,150,900,1,900,5400,"tak",1.2]
[{"$f":"COUNTIF($R$6:R43,\"tak\")","v":38},{"$f":"IF(A43>MAX($A$6:A42),\"TAK\",\"NIE\")","v":"TAK"},38,38,"Zamiatarka samojezdna TASKI balimat 6500 ",6500,"700-1150","ok. 3,5 h",52000,62400,36,1733.3333333333333,346.66666666666669,2080,1,2080,12480,"tak",1.2]
[{"$f":"COUNTIF($R$6:R44,\"tak\")","v":39},{"$f":"IF(A44>MAX($A$6:A43),\"TAK\",\"NIE\")","v":"TAK"},39,39,"Zamiatarka samojezdna NILFISK SW3000 LI-JON","6120/4280",1350,"ok. 4h",42300,50760,36,1410,282,1692,1,1692,10152,"tak",1.2]
[{"$f":"COUNTIF($R$6:R45,\"tak\")","v":40},{"$f":"IF(A45>MAX($A$6:A44),\"TAK\",\"NIE\")","v":"TAK"},40,40,"Zamiatarka Tennant S680 (RECON - po regeneracji)",6300,"650-1050","ok. 3h",54000,64800,36,1800,360,2160,1,2160,12960,"tak",1.2]
[{"$f":"COUNTIF($R$6:R46,\"tak\")","v":41},{"$f":"IF(A46>MAX($A$6:A45),\"TAK\",\"NIE\")","v":"TAK"},41,41,"Zamiatarka z napędem ręcznym POLI JOLY",1000,"600-800","-",2790,3348,24,139.5,27.900000000000002,167.4,1,167.4,669.59999999999991,"tak",1.2]
[{"$f":"COUNTIF($R$6:R47,\"tak\")","v":42},{"$f":"IF(A47>MAX($A$6:A46),\"TAK\",\"NIE\")","v":"TAK"},42,42,"Podstawowa zamiatarka z napędem ręcznym KARCHER S4 Twin",2400,680,"-",800,960,24,40,8,48,1,48,192,"tak",1.2]
[{"$f":"COUNTIF($R$6:R48,\"tak\")","v":42},{"$f":"IF(A48>MAX($A$6:A47),\"TAK\",\"NIE\")","v":"NIE"},"",43,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R49,\"tak\")","v":42},{"$f":"IF(A49>MAX($A$6:A48),\"TAK\",\"NIE\")","v":"NIE"},"",44,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R50,\"tak\")","v":42},{"$f":"IF(A50>MAX($A$6:A49),\"TAK\",\"NIE\")","v":"NIE"},"",45,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R51,\"tak\")","v":42},{"$f":"IF(A51>MAX($A$6:A50),\"TAK\",\"NIE\")","v":"NIE"},"",46,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R52,\"tak\")","v":42},{"$f":"IF(A52>MAX($A$6:A51),\"TAK\",\"NIE\")","v":"NIE"},"",47,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R53,\"tak\")","v":42},{"$f":"IF(A53>MAX($A$6:A52),\"TAK\",\"NIE\")","v":"NIE"},"",48,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R54,\"tak\")","v":42},{"$f":"IF(A54>MAX($A$6:A53),\"TAK\",\"NIE\")","v":"NIE"},"",49,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[{"$f":"COUNTIF($R$6:R55,\"tak\")","v":42},{"$f":"IF(A55>MAX($A$6:A54),\"TAK\",\"NIE\")","v":"NIE"},"",50,null,null,null,null,null,0,null,0,0,0,0,0,0,"nie",1.2]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:P31)","v":52090}]
[]
[null,null,null,"Sprzęt podstawowy - SPRZĘT DROBNY"]
[null,null,{"$f":"COUNTIF(C61:C91,2)","v":1},"Lp","Nazwa maszyny","Wydajność maszyny mkw/h","Szerokość czyszczenia mm","Czas pracy maszyny","Cena","Cena z eksploatacją","Okres spłaty [msc]","Koszt leasingu [msc]","Eksploatacja [msc]","Cena 1 szt. do oferty [msc]","Ilość maszyn","Kwota do oferty","Eksploatacja kwotowo (1 szt.)","Czy uwzględniać","Wskaźnik eksploatacji"]
[{"$f":"COUNTIF($R$60:R60,\"tak\")","v":1},{"$f":"IF(A60>MAX($A60:A$60),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(R60=\"TAK\",A60,\"\")","v":1},{"$f":"D55+1","v":51},"Odkurzacz biurowy - Numatic PRP180 / Taski Go","-",null,"-",null,555,24,{"$f":"IFERROR((J60/K60)*O60,0)","v":23.125},{"$f":"L60*(S60-1)","v":4.6249999999999991},{"$f":"IFERROR((J60/K60)*S60,0)","v":27.75},1,{"$f":"L60*S60","v":27.75},{"$f":"J60*S60-J60","v":111},{"$f":"IF(O60>0,\"tak\",\"nie\")","v":"tak"},1.2]
[{"$f":"COUNTIF($R$60:R61,\"tak\")","v":2},{"$f":"IF(A61>MAX($A$60:A60),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B61=\"TAK\",A61,\"\")","v":2},52,"Odkurzacz piorący CT 470-2","-",null,"-",null,2200,12,{"$f":"IFERROR((J61/K61)*O61,0)","v":183.33333333333334},{"$f":"L61*(S61-1)","v":36.666666666666657},{"$f":"IFERROR((J61/K61)*S61,0)","v":220},1,{"$f":"L61*S61","v":220},{"$f":"J61*S61-J61","v":440},{"$f":"IF(O61>0,\"tak\",\"nie\")","v":"tak"},1.2]
[{"$f":"COUNTIF($R$60:R62,\"tak\")","v":3},{"$f":"IF(A62>MAX($A$60:A61),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B62=\"TAK\",A62,\"\")","v":3},53,"Odkurzacz przemysłowy AERO 31-21 INOX PC","-",null,"-",null,915,12,76.25,{"$f":"L62*(S62-1)","v":15.249999999999996},91.5,1,91.5,{"$f":"J62*S62-J62","v":183},"tak",1.2]
[{"$f":"COUNTIF($R$60:R63,\"tak\")","v":4},{"$f":"IF(A63>MAX($A$60:A62),\"TAK\",\"NIE\")","v":"TAK"},4,54,"Odkurzacz plecakowy kablowy NILFISK GD10 BACK HEPA","-",null,"-",null,1445,12,120.41666666666667,24.083333333333329,144.5,1,144.5,{"$f":"J63*S63-J63","v":289},"tak",1.2]
[{"$f":"COUNTIF($R$60:R64,\"tak\")","v":5},{"$f":"IF(A64>MAX($A$60:A63),\"TAK\",\"NIE\")","v":"TAK"},5,55,"Odkurzacz plecakowy bateryjny NILFISK GD5 Battery","-",null,"-",null,4150,12,345.83333333333331,69.166666666666643,{"$f":"IFERROR((J64/K64)*S64,0)","v":414.99999999999994},1,414.99999999999994,{"$f":"J64*S64-J64","v":830},"tak",1.2]
[{"$f":"COUNTIF($R$60:R65,\"tak\")","v":6},{"$f":"IF(A65>MAX($A$60:A64),\"TAK\",\"NIE\")","v":"TAK"},6,56,"Odkurzacz do pracy na sucho/mokro NILFISK VL500-35 BSF","-",null,"-",null,963,12,{"$f":"IFERROR((J65/K65)*O65,0)","v":80.25},{"$f":"L65*(S65-1)","v":16.049999999999997},{"$f":"IFERROR((J65/K65)*S65,0)","v":96.3},1,{"$f":"L65*S65","v":96.3},0,"tak",1.2]
[{"$f":"COUNTIF($R$60:R66,\"tak\")","v":7},{"$f":"IF(A66>MAX($A$60:A65),\"TAK\",\"NIE\")","v":"TAK"},7,57,"Pralka automatyczna - podstawowa","-",null,"-",null,1200,12,100,19.999999999999996,{"$f":"IFERROR((J66/K66)*S66,0)","v":120},1,120,0,"tak",1.2]
[{"$f":"COUNTIF($R$60:R67,\"tak\")","v":8},{"$f":"IF(A67>MAX($A$60:A66),\"TAK\",\"NIE\")","v":"TAK"},8,58,"Pralka automatyczna - profesjonalna","-",null,"-",null,3660,24,{"$f":"IFERROR((J67/K67)*O67,0)","v":152.5},30.499999999999993,{"$f":"IFERROR((J67/K67)*S67,0)","v":183},1,{"$f":"L67*S67","v":183},30,"tak",1.2]
[{"$f":"COUNTIF($R$60:R68,\"tak\")","v":9},{"$f":"IF(A68>MAX($A$60:A67),\"TAK\",\"NIE\")","v":"TAK"},9,59,"Myjka ciśnieniowa - podstawowa (125 bar)","-",null,"-",null,1230,12,102.5,20.499999999999996,123,1,{"$f":"L68*S68","v":123},{"$f":"IFERROR(J68*S68-J68,\"\")","v":246},"tak",1.2]
[{"$f":"COUNTIF($R$60:R69,\"tak\")","v":10},{"$f":"IF(A69>MAX($A$60:A68),\"TAK\",\"NIE\")","v":"TAK"},10,60,"Myjka ciśnieniowa - profesjonalna (170 bar)","-",null,"-",null,3660,12,305,60.999999999999986,366,1,366,{"$f":"IFERROR(J69*S69-J69,\"\")","v":732},"tak",1.2]
[{"$f":"COUNTIF($R$60:R70,\"tak\")","v":11},{"$f":"IF(A70>MAX($A$60:A69),\"TAK\",\"NIE\")","v":"TAK"},11,61,"Wózek do sprzątania mały","-",null,"-",null,585,24,{"$f":"IFERROR((J70/K70)*O70,0)","v":24.375},{"$f":"L70*(S70-1)","v":0},{"$f":"IFERROR((J70/K70)*S70,0)","v":24.375},1,{"$f":"L70*S70","v":24.375},{"$f":"IFERROR(J70*S70-J70,\"\")","v":0},"tak",1]
[{"$f":"COUNTIF($R$60:R71,\"tak\")","v":12},{"$f":"IF(A71>MAX($A$60:A70),\"TAK\",\"NIE\")","v":"TAK"},12,62,"Wózek do sprzątania duży (biura, magazyny)","-",null,"-",null,1045,24,43.541666666666664,0,43.541666666666664,1,43.541666666666664,0,"tak",1]
[{"$f":"COUNTIF($R$60:R72,\"tak\")","v":13},{"$f":"IF(A72>MAX($A$60:A71),\"TAK\",\"NIE\")","v":"TAK"},13,63,"Wózek medyczny do sprzątania - VERMOP","-",null,"-",null,3500,24,{"$f":"IFERROR((J72/K72)*O72,0)","v":145.83333333333334},{"$f":"L72*(S72-1)","v":0},{"$f":"IFERROR((J72/K72)*S72,0)","v":145.83333333333334},1,{"$f":"L72*S72","v":145.83333333333334},{"$f":"IFERROR(J72*S72-J72,\"\")","v":0},"tak",1]
[{"$f":"COUNTIF($R$60:R73,\"tak\")","v":13},{"$f":"IF(A73>MAX($A$60:A72),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B73=\"TAK\",A73,\"\")","v":""},64,null,null,null,null,null,null,null,{"$f":"IFERROR((J73/K73)*O73,0)","v":0},{"$f":"L73*(S73-1)","v":0},{"$f":"IFERROR((J73/K73)*S73,0)","v":0},null,{"$f":"L73*S73","v":0},{"$f":"IFERROR(J73*S73-J73,\"\")","v":0},{"$f":"IF(O73>0,\"tak\",\"nie\")","v":"nie"},1]
[{"$f":"COUNTIF($R$60:R74,\"tak\")","v":13},{"$f":"IF(A74>MAX($A$60:A73),\"TAK\",\"NIE\")","v":"NIE"},"",65,null,null,null,null,null,null,null,0,0,0,null,0,0,"nie",1]
[{"$f":"COUNTIF($R$60:R75,\"tak\")","v":13},{"$f":"IF(A75>MAX($A$60:A74),\"TAK\",\"NIE\")","v":"NIE"},"",66,null,null,null,null,null,null,null,0,0,0,null,0,0,"nie",1]
[{"$f":"COUNTIF($R$60:R76,\"tak\")","v":13},{"$f":"IF(A76>MAX($A$60:A75),\"TAK\",\"NIE\")","v":"NIE"},"",67,null,null,null,null,null,null,null,0,0,0,null,0,0,"nie",1]
[{"$f":"COUNTIF($R$60:R77,\"tak\")","v":14},{"$f":"IF(A77>MAX($A$60:A72),\"TAK\",\"NIE\")","v":"TAK"},14,{"$f":"D76+1","v":68},"Inne np.ścierki, mopy, butelki, atomizery","-",null,"-",null,30,1,30,0,30,1,30,0,"tak",1]
[{"$f":"COUNTIF($R$60:R78,\"tak\")","v":14},{"$f":"IF(A78>MAX($A$60:A77),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B78=\"TAK\",A78,\"\")","v":""},69,null,null,null,null,null,null,null,{"$f":"IFERROR((J78/K78)*O78,0)","v":0},{"$f":"L78*(S78-1)","v":0},{"$f":"IFERROR((J78/K78)*S78,0)","v":0},null,{"$f":"L78*S78","v":0},{"$f":"IFERROR(J78*S78-J78,\"\")","v":0},{"$f":"IF(O78>0,\"tak\",\"nie\")","v":"nie"},1]
[{"$f":"COUNTIF($R$60:R79,\"tak\")","v":14},{"$f":"IF(A79>MAX($A$60:A78),\"TAK\",\"NIE\")","v":"NIE"},"",70,null,null,null,null,null,null,null,0,0,0,null,0,0,"nie",1]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P60:P77)","v":2030.8}]
[{"$f":"COUNTIF($R$60:R81,\"tak\")","v":14},{"$f":"IF(A81>MAX($A$60:A68),\"TAK\",\"NIE\")","v":"TAK"},{"$f":"IF(B81=\"TAK\",A81,\"\")","v":14},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nie"]
[{"$f":"COUNTIF($R$60:R82,\"tak\")","v":14},{"$f":"IF(A82>MAX($A$60:A81),\"TAK\",\"NIE\")","v":"NIE"},"","Sprzęt do koszenia - SPRZĘT DROBNY",null,null,null,null,null,null,null,null,null,null,null,null,null,"nie"]
[{"$f":"COUNTIF($R$60:R83,\"tak\")","v":14},{"$f":"IF(A83>MAX($A$60:A82),\"TAK\",\"NIE\")","v":"NIE"},"","Lp","Nazwa maszyny","Wydajność maszyny mkw/h",null,"Czas pracy maszyny",null,"Cena","Okres spłaty [msc]","Koszt leasingu [msc]","Eksploatacja [msc]","Cena 1 szt. do oferty [msc]","Ilość","Kwota do oferty","Eksploatacja kwotowo (1 szt.)",null,"Wskaźnik eksploatacji","Cena z eksploatacją"]
[{"$f":"COUNTIF($R$60:R84,\"tak\")","v":15},{"$f":"IF(A84>MAX($A$60:A83),\"TAK\",\"NIE\")","v":"TAK"},15,{"$f":"#REF!+1","v":{"$error":"#REF!"}},"Kosiarka spalinowa","-",null,"-",null,2100,12,{"$f":"IFERROR((T84/K84)*O84,0)","v":210},{"$f":"L84*0.2","v":42},{"$f":"IFERROR((T84/K84)*S84,0)","v":252},1,{"$f":"L84*S84","v":252},{"$f":"T84*S84-T84","v":504},"tak",1.2,{"$f":"J84*1.2","v":2520}]
[{"$f":"COUNTIF($R$60:R85,\"tak\")","v":16},{"$f":"IF(A85>MAX($A$60:A84),\"TAK\",\"NIE\")","v":"TAK"},16,{"$error":"#REF!"},"Kosa spalinowa (Sparta 441T - 2,0KM)","-",null,"-",null,1500,12,150,30,180,1,180,360,"tak",1.2,1800]
[{"$f":"COUNTIF($R$60:R86,\"tak\")","v":17},{"$f":"IF(A86>MAX($A$60:A85),\"TAK\",\"NIE\")","v":"TAK"},17,{"$error":"#REF!"},"Dmuchawa do liści plecakowa (BV163)","-",null,"-",null,1650,12,165,33,198,1,198,396,"tak",1.2,1980]
[{"$f":"COUNTIF($R$60:R87,\"tak\")","v":18},{"$f":"IF(A87>MAX($A$60:A86),\"TAK\",\"NIE\")","v":"TAK"},18,{"$error":"#REF!"},"Zamiatarka spalinowa / odrzutnik do śniegu OLEO MAC PKM100","-",null,"-",null,4200,12,420,84,504,1,504,1008,"tak",1.2,5040]
[{"$f":"COUNTIF($R$60:R88,\"tak\")","v":19},{"$f":"IF(A88>MAX($A$60:A87),\"TAK\",\"NIE\")","v":"TAK"},19,{"$error":"#REF!"},"Traktor wielofunkcyjny z osprzętem OM92/16KH (16KM)","-",null,"-",null,10500,24,525,105,630,1,630,2520,"tak",1.2,12600]
[{"$f":"COUNTIF($R$60:R89,\"tak\")","v":20},{"$f":"IF(A89>MAX($A$60:A88),\"TAK\",\"NIE\")","v":"TAK"},20,{"$error":"#REF!"},"Przyczepka do traktora",null,null,null,null,1150,12,115,23,138,1,138,276,"tak",1.2,1380]
[{"$f":"COUNTIF($R$60:R90,\"tak\")","v":21},{"$f":"IF(A90>MAX($A$60:A89),\"TAK\",\"NIE\")","v":"TAK"},21,{"$error":"#REF!"},"Pług do traktora OM92/16KH (120 cm)","-",null,"-",null,1550,12,155,31,186,1,186,372,"tak",1.2,1860]
[{"$f":"COUNTIF($R$60:R91,\"tak\")","v":22},{"$f":"IF(A91>MAX($A$60:A90),\"TAK\",\"NIE\")","v":"TAK"},22,{"$error":"#REF!"},"Łańcuchy na koła - do traktora","-",null,"-",null,310,12,31,6.2,37.199999999999996,1,37.199999999999996,74.399999999999977,"tak",1.2,372]
[{"$f":"COUNTIF($R$60:R92,\"tak\")","v":23},{"$f":"IF(A92>MAX($A$60:A91),\"TAK\",\"NIE\")","v":"TAK"},23,{"$error":"#REF!"},"Zamiatarka spalinowa YATO 100 CM, poj. 196 cm3","-",null,"-",null,2500,12,250,50,300,1,300,600,"tak",1.2,3000]
[{"$f":"COUNTIF($R$60:R93,\"tak\")","v":24},{"$f":"IF(A93>MAX($A$60:A92),\"TAK\",\"NIE\")","v":"TAK"},24,{"$error":"#REF!"},null,"-",null,"-",null,null,null,0,0,0,1,0,0,"tak",1.2,0]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P84:P93)","v":2425.1999999999998}]
[]
[null,null,null,"Teren zewnętrzny - sprzęt"]
[null,null,null,"Lp","Zestaw","Wydajność maszyny mkw/h","Współczynnik","Czas pracy maszyny",null,"Cena","Okres spłaty [msc]","Miesięczny koszt","Eksploatacja [msc]","Cena 1 szt. do oferty [msc]","Ilość","Ryczałt",null,null,"Wskaźnik eksploatacji","Cena z eksploatacją"]
[null,null,null,1,"Miotła, łopata, grabie, szufelka, wiaderko",null,1,null,null,300,12,{"$f":"IFERROR((J98/K98)*O98,0)","v":25},{"$f":"L98*(S98-1)","v":4.9999999999999991},{"$f":"IFERROR((T98/K98),0)","v":30},1,{"$f":"L98*S98","v":30},null,null,1.2,{"$f":"J98*S98","v":360}]
[null,null,null,2,null,null,1,null,null,null,null,{"$f":"IFERROR((J99/K99)*O99,0)","v":0},{"$f":"L99*(S99-1)","v":0},{"$f":"IFERROR((T99/K99),0)","v":0},null,{"$f":"L99*S99","v":0},null,null,1.2,{"$f":"J99*S99","v":0}]
[null,null,null,3,null,null,1,null,null,null,null,0,0,0,null,0,null,null,1.2,0]
[null,null,null,4,null,null,1,null,null,null,null,0,0,0,null,0,null,null,1.2,0]
[null,null,null,5,null,null,1,null,null,null,null,0,0,0,null,0,null,null,1.2,0]
[null,null,null,"SUMA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P98:S102)","v":36.000000000000007}]
[]
[null,null,null,"MASZYNY / SPRZĘT"]
[null,null,null,"SUMA",{"$f":"SUM(P84:P93,P60:P77,P6:P31,H103)","v":56546}]

{"sheet":"CHEMIA","index":6,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,1,53,5],[1,1,1,5],[3,1,3,5],[13,1,13,5],[23,1,23,5],[33,1,33,5],[43,1,43,5]]}
[]
[null,"PIELĘGNACJA /  CHEMIA"]
[]
[null,"Biura"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ryczałt"]
[null,1,"<500",null,0.2,{"$f":"E6*D6","v":0}]
[null,2,"do 1000",null,0.15,0]
[null,3,"do 2000",null,0.125,0]
[null,4,"do 5000",null,0.12,0]
[null,5,"do 10 000",null,0.1,0]
[null,6,"> 10 000",null,0.09,0]
[null,"SUMA",null,{"$f":"SUM(D6:D11)","v":0},null,{"$f":"SUM(F6:F11)","v":0}]
[]
[null,"Powierzchnie produkcyjne"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ryczałt"]
[null,1,"<500",null,7.4999999999999997E-2,{"$f":"E16*D16","v":0}]
[null,2,"do  1000",null,7.4999999999999997E-2,0]
[null,3,"do 2000",null,0.06,0]
[null,4,"do 5000",null,0.05,0]
[null,5,"do 10 000",null,0.04,0]
[null,6,"> 10 000",null,3.5000000000000003E-2,0]
[null,"SUMA",null,{"$f":"SUM(D16:D21)","v":0},null,{"$f":"SUM(F16:F21)","v":0}]
[]
[null,"Powierzchnie magazynowe"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ryczałt"]
[null,1,"<500",null,7.4999999999999997E-2,{"$f":"E26*D26","v":0}]
[null,2,"do  1000",null,7.4999999999999997E-2,0]
[null,3,"do 2000",null,0.06,0]
[null,4,"do 5000",null,0.05,0]
[null,5,"do 10 000",null,0.04,0]
[null,6,"> 10 000",null,3.5000000000000003E-2,0]
[null,"SUMA",null,{"$f":"SUM(D26:D31)","v":0},null,{"$f":"SUM(F26:F31)","v":0}]
[]
[null,"Powierzchnie medyczne / sanitariaty"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ryczałt"]
[null,1,"<500",null,0.75,{"$f":"E36*D36","v":0}]
[null,2,"do 1000",null,0.6,0]
[null,3,"do 2000",null,0.5,0]
[null,4,"do 5000",null,0.4,0]
[null,5,"do 10 000",null,0.35,0]
[null,6,"> 10 000",null,0.25,0]
[null,"SUMA",null,{"$f":"SUM(D36:D41)","v":0},null,{"$f":"SUM(F36:F41)","v":0}]
[]
[null,"Teren zewnętrzny"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ryczałt"]
[null,1,"<1000",null,7.4999999999999997E-2,{"$f":"E46*D46","v":0}]
[null,2,"do 2000",null,7.4999999999999997E-2,{"$f":"E47*D47","v":0}]
[null,3,"do 5000",null,0.06,{"$f":"E48*D48","v":0}]
[null,4,"do 10 000",null,0.05,0]
[null,5,"do 30 000",null,0.04,0]
[null,6,"> 30 000",null,1.2E-2,0]
[null,"SUMA",null,{"$f":"SUM(D46:D51)","v":0},null,{"$f":"SUM(F46:F51)","v":0}]
[]
[null,"PIELĘGNACJA /  CHEMIA"]
[null,"SUMA",null,null,null,{"$f":"SUM(F12,F22,F32,F42,F52)","v":0}]

{"sheet":"HIGIENA","index":7,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[44,1,44,5],[1,1,1,5],[3,1,3,5],[10,1,10,5],[17,1,17,5],[24,1,24,5],[34,1,34,5]]}
[]
[null,"HIGIENA"]
[]
[null,"Biura"]
[null,"Lp","Standard","Ilość osób","Ryczałt osoba","Ryczałt"]
[null,1,"Niski",null,12,{"$f":"D6*E6","v":0}]
[null,2,"Średni",null,14,{"$f":"D7*E7","v":0}]
[null,3,"Wysoki",null,16,{"$f":"D8*E8","v":0}]
[null,"SUMA",null,{"$f":"SUM(D6:D8)","v":0},null,{"$f":"SUM(F6:F8)","v":0}]
[]
[null,"Powierzchnie produkcyjne"]
[null,"Lp","Standard","Ilość osób","Ryczałt osoba","Ryczałt"]
[null,1,"Niski",null,10,{"$f":"D13*E13","v":0}]
[null,2,"Średni",null,12,{"$f":"D14*E14","v":0}]
[null,3,"Wysoki",null,14,{"$f":"D15*E15","v":0}]
[null,"SUMA",null,{"$f":"SUM(D13:D15)","v":0},null,{"$f":"SUM(F13:F15)","v":0}]
[]
[null,"Powierzchnie magazynowe"]
[null,"Lp","Standard","Ilość osób","Ryczałt osoba","Ryczałt"]
[null,1,"Niski",null,10,{"$f":"D20*E20","v":0}]
[null,2,"Średni",null,12,{"$f":"D21*E21","v":0}]
[null,3,"Wysoki",null,14,{"$f":"D22*E22","v":0}]
[null,"SUMA",null,{"$f":"SUM(D20:D22)","v":0},null,{"$f":"SUM(F20:F22)","v":0}]
[]
[null,"Galeria"]
[null,"Lp","Przedział metrażu mkw","Metraż","Ryczałt mkw","Ryczałt"]
[null,1,"do 2000",null,0.35,{"$f":"D27*E27","v":0}]
[null,2,"do 5000",null,0.3,0]
[null,3,"do 10 000",null,0.25,0]
[null,4,"do 20 000",null,0.23,0]
[null,5,"do 30 000",null,0.21,0]
[null,6,"> 30 000",null,0.2,0]
[null,"SUMA",null,{"$f":"SUM(D27:D32)","v":0},null,{"$f":"SUM(F27:F32)","v":0}]
[]
[null,"Kosze"]
[null,"Lp","Przedział metrażu mkw","Metraż","Ryczałt mkw","Ryczałt"]
[null,1,"do 2000",null,0.2,{"$f":"D37*E37","v":0}]
[null,2,"do 5000",null,0.18,0]
[null,3,"do 10 000",null,0.15,0]
[null,4,"do 20 000",null,0.13,0]
[null,5,"do 30 000",null,0.11,0]
[null,6,"> 30 000",null,0.1,0]
[null,"SUMA",null,{"$f":"SUM(D37:D42)","v":0},null,{"$f":"SUM(F37:F42)","v":0}]
[]
[null,"HIGIENA"]
[null,"SUMA",null,null,null,{"$f":"SUM(F9,F16,F23,F33,F43)","v":0}]

{"sheet":"ZIMA","index":8,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,9],[28,1,28,6],[38,1,38,8],[18,1,18,8],[12,1,12,8],[3,1,3,9]]}
[]
[null,"ZIMA"]
[]
[null,"Sprzęt ciężki - na miejscu "]
[null,"Lp","Nazwa maszyny","Ilośc maszyn","rbh/dzień","Postojowe","zł/rbh","Dni pracujące / m-c","Kwota do oferty","Budżet na roboczogodziny","Budżet na postojowe "]
[null,1,"Traktor duży - zima",0,0,4500,150,0,{"$f":"((D6*H6*E6*G6*5))/12+((F6*5*D6)/12)","v":0},{"$f":"I6*12-K6","v":0},{"$f":"F6*5*D6","v":0}]
[null,{"$f":"B6+1","v":2},"Traktor mały - zima",0,0,2500,120,0,{"$f":"((D7*H7*E7*G7*5))/12+((F7*5*D7)/12)","v":0},{"$f":"I7*12-K7","v":0},{"$f":"F7*5*D7","v":0}]
[null,{"$f":"B7+1","v":3},"Ładowarka",0,0,3000,150,0,0,0,0]
[null,{"$f":"B8+1","v":4},"Wywrotka",0,0,3000,150,0,0,0,0]
[null,{"$f":"B9+1","v":5},null,null,null,null,null,0,0,{"$f":"I10*12-K10","v":0},0]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I6:I10)","v":0},{"$f":"SUM(J6:J10)","v":0},{"$f":"SUM(K6:K10)","v":0}]
[]
[null,"Teren zewnętrzny - sprzęt do prac ręcznych"]
[null,"Lp","Zestaw","Ilość",null,"Cena",null,null,"Kwota do oferty"]
[null,6,"Łopata do odśnieżania, łopatka, szufelka, wiaderko (ilość zestawów)",0,null,300,1,null,{"$f":"(D15*F15*G15)/12","v":0}]
[null,7,"Inne",null,null,null,1,null,{"$f":"(D16*F16*G16)/12","v":0}]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I15:I16)","v":0}]
[]
[null,"Sprzęt ciężki  - dojazd"]
[null,"Lp","Nazwa maszyny","Ilośc maszyn","rbh/przyjazd","Dojazd","zł/rhb","Ilość przyjazdów","Kwota do oferty [msc]"]
[null,1,"Traktor duży - zima",0,0,250,120,0,{"$f":"((D21*E21*H21*G21*5)+(D21*F21*H21*5))/12","v":0}]
[null,{"$f":"B21+1","v":2},"Traktor mały - zima",0,0,250,100,0,0]
[null,{"$f":"B22+1","v":3},"Ładowarka",0,0,250,100,0,{"$f":"((D23*E23*H23*G23*5)+(D23*F23*H23*5))/12","v":0}]
[null,{"$f":"B23+1","v":4},"Wywrotka",0,0,250,100,0,0]
[null,{"$f":"B24+1","v":5},null,null,null,null,null,0,0]
[null,{"$f":"B25+1","v":6},null,null,null,null,null,0,0]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0}]
[]
[null,"Koszty mieszanki / płatne przez okres 12 miesięcy (mieszanka sól/piach)"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ilość miesięcy w roku","Kwota do oferty"]
[null,1,"<1000",null,1.55,12,{"$f":"(E31*D31)/F31","v":0}]
[null,{"$f":"B31+1","v":2},"do 2000",null,1.3499999999999999,12,0]
[null,{"$f":"B32+1","v":3},"do 5000",null,1.1000000000000001,12,0]
[null,{"$f":"B33+1","v":4},"do 10 000",null,0.88000000000000012,12,0]
[null,{"$f":"B34+1","v":5},"do 30 000",null,0.55000000000000004,12,0]
[null,{"$f":"B35+1","v":6},"> 30 000",null,0.5,12,0]
[null,"SUMA",null,{"$f":"SUM(D31:D36)","v":0},null,null,{"$f":"SUM(G31:G36)","v":0}]
[]
[null,"ZIMA"]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I11,I17,I27,G37)","v":0}]

{"sheet":"ZIMA ceny","index":9,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":true,"merged":[[38,1,38,8],[1,1,1,9],[3,1,3,9],[12,1,12,8],[18,1,18,8],[28,1,28,6]]}
[]
[null,"ZIMA"]
[]
[null,"Sprzęt ciężki - na miejscu "]
[null,"Lp","Nazwa maszyny","Ilośc maszyn","rbh/dzień","Postojowe","zł/rbh","Dni pracujące","Kwota do oferty","Budżet na roboczogodziny","Budżet na postojowe "]
[null,1,"Traktor duży - zima",0,0,4500,150,0,{"$f":"((D6*H6*E6*G6*5))/12+((F6*5*D6)/12)","v":0},{"$f":"I6*12-K6","v":0},{"$f":"F6*5*D6","v":0}]
[null,{"$f":"B6+1","v":2},"Traktor mały - zima",0,0,2500,120,0,{"$f":"((D7*H7*E7*G7*5))/12+((F7*5*D7)/12)","v":0},{"$f":"I7*12-K7","v":0},{"$f":"F7*5*D7","v":0}]
[null,{"$f":"B7+1","v":3},"Ładowarka",0,0,3000,150,0,0,0,0]
[null,{"$f":"B8+1","v":4},"Wywrotka",0,0,3000,150,0,0,0,0]
[null,{"$f":"B9+1","v":5},null,null,null,null,null,0,0,{"$f":"I10*12-K10","v":0},0]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I6:I10)","v":0},{"$f":"SUM(J6:J10)","v":0},{"$f":"SUM(K6:K10)","v":0}]
[]
[null,"Teren zewnętrzny - sprzęt do prac ręcznych"]
[null,"Lp","Zestaw","ilość zestawów lub cena",null,"Cena",null,null,"Kwota do oferty"]
[null,6,"Łopata do odśnieżania, łopatka, szufelka, wiaderko (ilość zestawów)",null,null,300,1,null,{"$f":"(D15*F15*G15)/12","v":0}]
[null,7,"Inne (cena)",null,null,null,1,null,{"$f":"(D16*G16)/12","v":0}]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I15:I16)","v":0}]
[]
[null,"Sprzęt ciężki  - dojazd"]
[null,"Lp","Nazwa maszyny","Ilośc maszyn","rbh/przyjazd","Dojazd","zł/rhb","Ilość przyjazdów","Kwota do oferty [msc]"]
[null,1,"Traktor duży - zima",0,0,250,120,0,{"$f":"((D21*E21*H21*G21*5)+(D21*F21*H21*5))/12","v":0}]
[null,{"$f":"B21+1","v":2},"Traktor mały - zima",0,0,250,100,0,0]
[null,{"$f":"B22+1","v":3},"Ładowarka",0,0,250,100,0,{"$f":"((D23*E23*H23*G23*5)+(D23*F23*H23*5))/12","v":0}]
[null,{"$f":"B23+1","v":4},"Wywrotka",0,0,250,100,0,0]
[null,{"$f":"B24+1","v":5},null,null,null,null,null,0,0]
[null,{"$f":"B25+1","v":6},null,null,null,null,null,0,0]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I21:I26)","v":0}]
[]
[null,"Koszty mieszanki / płatne przez okres 12 miesięcy (mieszanka sól/piach)"]
[null,"Lp","Przedział metrażu mkw","Metraż","Współczynnik","Ilość miesięcy w roku","Kwota do oferty"]
[null,1,"<1000",null,1.35,12,{"$f":"(E31*D31)/F31","v":0}]
[null,{"$f":"B31+1","v":2},"do 2000",null,1.1499999999999999,12,0]
[null,{"$f":"B32+1","v":3},"do 5000",null,0.9,12,0]
[null,{"$f":"B33+1","v":4},"do 10 000",null,0.68,12,0]
[null,{"$f":"B34+1","v":5},"do 30 000",null,0.35,12,0]
[null,{"$f":"B35+1","v":6},"> 30 000",null,0.3,12,0]
[null,"SUMA",null,{"$f":"SUM(D31:D36)","v":0},null,null,{"$f":"SUM(G31:G36)","v":0}]
[]
[null,"ZIMA"]
[null,"SUMA",null,null,null,null,null,null,{"$f":"SUM(I11,I17,I27,G37)","v":0}]

{"sheet":"POZOSTAŁE","index":10,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,3,1,9],[22,3,22,9],[27,3,27,9],[3,3,3,9],[23,8,23,9],[24,8,24,9]]}
[]
[null,null,null,"POZOSTAŁE KOSZTY "]
[]
[null,null,null,"POZOSTAŁE KOSZTY"]
[null,null,null,"Lp","Nazwa","ilość / mkw","krotność w roku","Cena za jednostkę","Cena","Kwota do oferty [msc]"]
[null,null,null,1,"ZAKUP ODZIEŻY - pracownik biurowo-socjalny",0,1,210,{"$f":"IF(F6=\"\",\"\",F6*G6*H6)","v":0},{"$f":"IFERROR(I6/12,\"\")","v":0}]
[null,null,null,{"$f":"D6+1","v":2},"ZAKUP ODZIEŻY - pracownik magazynowo-produkcyjny",0,1,287,{"$f":"IF(F7=\"\",\"\",F7*G7*H7)","v":0},{"$f":"IFERROR(I7/12,\"\")","v":0}]
[null,null,{"$f":"COUNTIF(C9:C16,2)","v":0},{"$f":"D7+1","v":3},"Pranie strojów roboczych",{"$f":"F6+F7","v":0},12,20,{"$f":"IF(F8=\"\",\"\",F8*G8*H8)","v":0},0]
[{"$f":"COUNTIF($K$8:K9,\"tak\")","v":0},{"$f":"IF(A9>MAX($A$8:A8),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B9=\"TAK\",A9,\"\")","v":""},4,"Mycie okien",null,null,2,{"$f":"IF(F9=\"\",\"\",F9*G9*H9)","v":""},{"$f":"IFERROR(I9/12,\"\")","v":""},{"$f":"IF(F9*G9>0,\"tak\",\"nie\")","v":"nie"}]
[{"$f":"COUNTIF($K$8:K10,\"tak\")","v":0},{"$f":"IF(A10>MAX($A$8:A9),\"TAK\",\"NIE\")","v":"NIE"},"",5,"Przeszklenia wewnętrzne ",null,null,10,{"$f":"IF(F10=\"\",\"\",F10*G10*H10)","v":""},"","nie"]
[{"$f":"COUNTIF($K$8:K11,\"tak\")","v":0},{"$f":"IF(A11>MAX($A$8:A10),\"TAK\",\"NIE\")","v":"NIE"},"",6,"Nakładanie polimerów",null,null,8,"","","nie"]
[{"$f":"COUNTIF($K$8:K12,\"tak\")","v":0},{"$f":"IF(A12>MAX($A$8:A11),\"TAK\",\"NIE\")","v":"NIE"},"",7,"Paliwo do maszyn",null,null,7.5,"","","nie"]
[{"$f":"COUNTIF($K$8:K13,\"tak\")","v":0},{"$f":"IF(A13>MAX($A$8:A12),\"TAK\",\"NIE\")","v":"NIE"},"",8,"Pranie wykładzin",null,null,10,"","","nie"]
[{"$f":"COUNTIF($K$8:K14,\"tak\")","v":0},{"$f":"IF(A14>MAX($A$8:A13),\"TAK\",\"NIE\")","v":"NIE"},"",9,"Koszenie",null,null,null,"","","nie"]
[{"$f":"COUNTIF($K$8:K15,\"tak\")","v":0},{"$f":"IF(A15>MAX($A$8:A14),\"TAK\",\"NIE\")","v":"NIE"},"",10,null,null,null,null,"","","nie"]
[{"$f":"COUNTIF($K$8:K16,\"tak\")","v":0},{"$f":"IF(A16>MAX($A$8:A15),\"TAK\",\"NIE\")","v":"NIE"},"",11,null,null,null,null,"","","nie"]
[{"$f":"COUNTIF($K$8:K17,\"tak\")","v":0},{"$f":"IF(A17>MAX($A$8:A16),\"TAK\",\"NIE\")","v":"NIE"},{"$f":"IF(B17=\"TAK\",A17,\"\")","v":""},12,null,null,null,null,{"$f":"IF(F17=\"\",\"\",F17*G17*H17)","v":""},{"$f":"IFERROR(I17/12,\"\")","v":""},{"$f":"IF(F17*G17>0,\"tak\",\"nie\")","v":"nie"}]
[{"$f":"COUNTIF($K$8:K18,\"tak\")","v":0},{"$f":"IF(A18>MAX($A$8:A17),\"TAK\",\"NIE\")","v":"NIE"},"",13,null,null,null,null,"","","nie"]
[{"$f":"COUNTIF($K$8:K19,\"tak\")","v":0},{"$f":"IF(A19>MAX($A$8:A18),\"TAK\",\"NIE\")","v":"NIE"},"",14,null,null,null,null,"","","nie"]
[{"$f":"COUNTIF($K$8:K20,\"tak\")","v":0},{"$f":"IF(A20>MAX($A$8:A19),\"TAK\",\"NIE\")","v":"NIE"},"",15,null,null,null,null,"","","nie"]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(J6:J20)","v":0}]
[]
[null,null,null,"Budżet na dojazdy koordynatorów"]
[null,null,null,null,null,"odległośc w km (w 2 strony)","krotność w tygodniu","stawka za 1 km"]
[null,null,null,{"$f":"D24+1","v":1},"Obsługa obiektu - dostawy, kontrole",0,0,0.9,{"$f":"L25/12","v":0},null,null,{"$f":"(((F25*H25)*(G25*53)))","v":0}]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(I25:J25)","v":0}]
[]
[null,null,null,"POZOSTAŁE KOSZTY + BUDŻET NA DOJAZDY KOORDYNATORÓW"]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(J21,J26)","v":0}]

{"sheet":"POZOSTAŁE ceny","index":11,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":true,"merged":[[27,3,27,9],[1,3,1,9],[3,3,3,9],[22,3,22,9],[23,8,23,9],[24,8,24,9]]}
[]
[null,null,null,"POZOSTAŁE KOSZTY "]
[]
[null,null,null,"POZOSTAŁE KOSZTY"]
[null,null,null,"Lp","Nazwa","ilość / mkw","krotność w roku","Cena za jednostkę","Cena","Kwota do oferty [msc]"]
[null,null,null,1,"Zakup odzieży - pracownik biurowo-socjalny",null,1,210,{"$f":"IF(F6=\"\",\"\",F6*G6*H6)","v":""},{"$f":"IFERROR(I6/12,\"\")","v":""}]
[null,null,null,{"$f":"D6+1","v":2},"Zakup odzieży - pracownik magazynowo-produkcyjny",null,1,287,{"$f":"IF(F7=\"\",\"\",F7*G7*H7)","v":""},{"$f":"IFERROR(I7/12,\"\")","v":""}]
[null,null,null,{"$f":"D7+1","v":3},"Pranie strojów roboczych",null,12,20,{"$f":"IF(F8=\"\",\"\",F8*G8*H8)","v":""},""]
[null,null,null,4,"Mycie okien",null,2,2,{"$f":"IF(F9=\"\",\"\",F9*G9*H9)","v":""},{"$f":"IFERROR(I9/12,\"\")","v":""}]
[null,null,null,5,"Przeszklenia wewnętrzne ",null,null,10,{"$f":"IF(F10=\"\",\"\",F10*G10*H10)","v":""},""]
[null,null,null,6,"Nakładanie polimerów",null,null,8,"",""]
[null,null,null,7,"Paliwo do maszyn",null,null,7.5,"",""]
[null,null,null,8,"Pranie wykładzin",null,null,10,"",""]
[null,null,null,9,"Koszenie",null,null,null,"",""]
[null,null,null,10,null,null,null,null,"",""]
[null,null,null,11,null,null,null,null,"",""]
[null,null,null,12,null,null,null,null,{"$f":"IF(F17=\"\",\"\",F17*G17*H17)","v":""},{"$f":"IFERROR(I17/12,\"\")","v":""}]
[null,null,null,13,null,null,null,null,"",""]
[null,null,null,14,null,null,null,null,"",""]
[null,null,null,15,null,null,null,null,"",""]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(J6:J20)","v":0}]
[]
[null,null,null,"Budżet na dojazdy koordynatorów"]
[null,null,null,null,null,"odległośc w km (w 2 strony)","krotność w tygodniu","stawka za 1 km"]
[null,null,null,{"$f":"D24+1","v":1},"Obsługa obiektu - dostawy, kontrole",null,null,0.9,{"$f":"L25/12","v":0},null,null,{"$f":"(((F25*H25)*(G25*53)))","v":0}]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(I25:J25)","v":0}]
[]
[null,null,null,"POZOSTAŁE KOSZTY + BUDŻET NA DOJAZDY KOORDYNATORÓW"]
[null,null,null,"SUMA",null,null,null,null,null,{"$f":"SUM(J21,J26)","v":0}]

{"sheet":"PODSUMOWANIE","index":12,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,1,3],[3,1,3,3],[13,1,13,2],[22,1,22,2],[4,6,8,6],[2,6,2,9],[18,1,18,2],[20,1,20,2]]}
[]
[null,"PODSUMOWANIE"]
[null,null,null,null,null,null,"Rentowność kontraktów"]
[null,"KOSZTY",null,null,null,null,"rodzaj usługi","Wartość usługi od","Wartość usługi do","Min. próg rentowności"]
[null,"Lp","Rodzaj kosztów","Suma",null,null,"stała",0,2000,0.35]
[null,1,"Pracownicy",{"$f":"SUM(PRACOWNICY!AC24,PRACOWNICY!Y28,PRACOWNICY!J32,PRACOWNICY!J33)","v":233.12221878000005},null,null,null,{"$f":"I5+0.01","v":2000.01},5000,0.3]
[null,{"$f":"B6+1","v":2},"Zakup maszyn",{"$f":"SUM('MASZYNY SPRZĘT'!L6:L55,'MASZYNY SPRZĘT'!L60:L79,'MASZYNY SPRZĘT'!L84:L93,'MASZYNY SPRZĘT'!L98:L102)","v":0},null,null,null,{"$f":"I6+0.01","v":5000.01},10000,0.25]
[null,{"$f":"B7+1","v":3},"Eksploatacja maszyn",{"$f":"SUM('MASZYNY SPRZĘT'!M6:M55,'MASZYNY SPRZĘT'!M60:M79,'MASZYNY SPRZĘT'!M84:M93,'MASZYNY SPRZĘT'!M98:M102)-'MASZYNY SPRZĘT'!M77","v":0},null,null,null,{"$f":"I7+0.01","v":10000.01},20000,0.23]
[null,4,"Chemia",{"$f":"CHEMIA!F55","v":0},null,null,null,{"$f":"I8+0.01","v":20000.009999999998},null,0.2]
[null,5,"Higiena",{"$f":"HIGIENA!F46","v":0}]
[null,6,"Pozostałe ",{"$f":"POZOSTAŁE!J29","v":0}]
[null,7,"Zima",{"$f":"ZIMA!I40","v":0}]
[null,8]
[null,"SUMA",null,{"$f":"SUM(D6:D13)","v":233.12221878000005}]
[]
[null,"MARŻA PROPONOWANA",{"$f":"VLOOKUP(D14,$H$4:$J$9,3,1)","v":0.35}]
[null,"MARŻA FINALNA",0.3,{"$f":"D14*IF(C17=\"\",C16,C17)","v":69.936665634000008}]
[]
[null,"SUMA KOSZTÓW Z MARŻĄ",null,{"$f":"SUM(D14,D17)","v":303.05888441400009}]
[]
[null,"PROPOZYCJA CENY",null,{"$f":"CEILING(D19,100)","v":400}]
[]
[null,"ZYSK / STRATA",null,{"$f":"D21-D14","v":166.87778121999995}]

{"sheet":"Karta obiektu","index":13,"n_rows":177,"n_cols":13,"rows_kept":177,"cut":false,"hidden":false,"merged":[[169,7,169,11],[170,7,170,11],[171,7,171,11],[172,7,172,11],[173,7,173,11],[174,7,174,11],[176,7,176,11],[130,5,130,11],[131,7,131,11],[132,8,132,11],[133,8,133,11],[134,8,134,11],[135,8,135,11],[131,5,131,6],[167,7,167,11],[168,7,168,11],[167,5,167,6],[168,5,168,6],[169,5,169,6],[170,5,170,6],[171,5,171,6],[172,5,172,6],[173,5,173,6],[174,5,174,6],[90,5,91,11],[118,8,119,11],[121,1,121,11],[122,5,122,11],[123,5,123,11],[124,5,124,11],[103,1,103,11],[104,5,104,11],[105,5,105,11],[106,5,106,11],[107,5,107,11],[109,8,109,11],[111,5,111,11],[112,8,112,11],[113,8,113,11],[93,8,93,11],[94,5,94,11],[98,8,98,11],[99,5,99,11],[100,1,101,4],[122,1,122,4],[114,8,114,11],[113,5,113,7],[114,5,114,7],[66,8,66,11],[67,8,67,11],[79,8,79,11],[80,8,80,11],[68,8,68,11],[69,8,69,11],[70,8,70,11],[71,8,71,11],[72,8,72,11],[73,8,73,11],[74,8,74,11],[75,8,75,11],[76,8,76,11],[77,8,77,11],[78,8,78,11],[22,6,22,11],[23,6,23,11],[28,8,28,11],[27,6,27,11],[26,6,26,11],[25,1,25,11],[19,1,19,11],[28,6,28,7],[22,2,22,4],[27,1,27,3],[27,4,27,5],[23,2,23,4],[26,1,26,3],[26,4,26,5],[20,2,20,11],[21,6,21,11],[176,5,176,6],[176,1,176,4],[107,1,107,4],[172,1,172,4],[174,1,174,4],[173,1,173,4],[169,1,169,4],[170,1,170,4],[167,1,167,4],[168,1,168,4],[171,1,171,4],[131,1,131,2],[131,3,131,4],[141,1,141,2],[141,3,141,4],[144,1,144,11],[164,1,164,6],[136,8,136,11],[137,8,137,11],[138,8,138,11],[139,8,139,11],[140,8,140,11],[141,8,141,11],[166,1,166,11],[130,1,130,4],[126,1,126,4],[127,1,127,4],[123,1,123,4],[124,1,124,4],[125,1,125,4],[117,1,117,3],[118,1,118,3],[119,1,119,3],[118,5,119,7],[125,5,125,11],[126,5,126,11],[127,5,127,11],[117,5,117,11],[104,1,104,4],[105,1,105,4],[93,5,93,7],[93,1,93,3],[106,1,106,4],[99,1,99,4],[111,1,111,4],[109,1,109,3],[112,1,112,3],[113,1,113,3],[114,1,114,3],[115,1,115,3],[115,5,115,7],[109,5,109,7],[112,5,112,7],[95,5,96,11],[100,5,101,11],[98,5,98,7],[98,1,98,3],[94,1,94,4],[34,1,34,3],[34,5,34,7],[95,1,96,4],[90,1,91,4],[89,1,89,4],[115,8,115,11],[53,8,53,11],[54,8,54,11],[55,8,55,11],[56,8,56,11],[57,8,57,11],[58,8,58,11],[59,8,59,11],[60,8,60,11],[81,8,81,11],[82,8,82,11],[83,8,83,11],[84,8,84,11],[85,8,85,11],[86,8,86,11],[36,8,36,11],[37,8,37,11],[89,5,89,11],[38,8,38,11],[39,8,39,11],[40,8,40,11],[41,8,41,11],[42,8,42,11],[88,1,88,3],[88,5,88,7],[88,8,88,11],[29,6,29,7],[30,6,30,7],[31,6,31,7],[28,1,31,1],[28,2,31,3],[33,1,33,3],[33,5,33,7],[35,1,35,4],[29,8,29,11],[30,8,30,11],[31,8,31,11],[33,8,33,11],[34,8,34,11],[35,5,35,11],[43,8,43,11],[44,8,44,11],[8,1,8,2],[11,1,11,8],[13,2,13,4],[14,2,14,4],[21,2,21,4],[18,2,18,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[10,1,10,11],[12,1,12,11],[13,6,13,11],[14,8,14,11],[15,6,15,11],[16,6,16,11],[17,6,17,11],[18,6,18,11],[61,8,61,11],[62,8,62,11],[63,8,63,11],[64,8,64,11],[52,8,52,11],[45,8,45,11],[46,8,46,11],[47,8,47,11],[48,8,48,11],[49,8,49,11],[50,8,50,11],[51,8,51,11]]}
[null,null,null,null,null,"`",null,null,null,null,null,null,"Czy chować wiersz"]
[]
[]
[]
[]
[]
[]
[]
[null,"POCZĄTEK OBSŁUGI",null,{"$f":"IF(G15=\"\",\"\",G15)","v":""}]
[]
[null,"KARTA INFORMACYJNA OBIEKTU"]
[]
[null,"DANE KONTAKTOWE"]
[null,"Pełna nazwa \nzleceniodawcy",null,null,null,"Zgodnie z umową nr \nz dnia"]
[null,"Lokalizacja obiektu",null,null,null,"Data rozpoczęcia usługi",null,"Aneksy/zmiany"]
[null,"Rodzaj faktury",null,null,null,"Termin wystawiania faktury"]
[null,"Adres",null,null,null,"Osoba odpowiedzialna po stronie Zleceniodawcy"]
[null,"NIP",null,null,null,"Telefon"]
[null,"Dodatkowe informacje",null,null,null,"Email"]
[]
[null,"Spółka zleceniobiorcy"]
[null,"Przedstawiciel handlowy",null,null,null,"Kierownik operacyjny obiektu"]
[null,"Telefon",null,null,null,"Telefon"]
[null,"Email",null,null,null,"Email"]
[]
[null,"SPECYFIKACJA OBIEKTU"]
[null,"Łączna powierzchnia sprzątania w m2",null,null,"Powierzchnie wewnętrzne w m2",null,"Powiechnie zewnętrzne m2"]
[null,{"$f":"E28+G28","v":0},null,null,{"$f":"SUM(F29:F32)","v":0},null,{"$f":"CHEMIA!D52+I29","v":0}]
[null,"Typ posadzki",null,null,{"$f":"CHEMIA!B4","v":"Biura"},{"$f":"IF(CHEMIA!D12=\"\",\"\",CHEMIA!D12)","v":0},"Tereny zielone"]
[null,null,null,null,{"$f":"CHEMIA!B14","v":"Powierzchnie produkcyjne"},{"$f":"IF(CHEMIA!D22=\"\",\"\",CHEMIA!D22)","v":0},"Drogi"]
[null,null,null,null,{"$f":"CHEMIA!B24","v":"Powierzchnie magazynowe"},{"$f":"IF(CHEMIA!D32=\"\",\"\",CHEMIA!D32)","v":0},"Parkingi"]
[null,null,null,null,{"$f":"CHEMIA!B34","v":"Powierzchnie medyczne / sanitariaty"},{"$f":"IF(CHEMIA!D42=\"\",\"\",CHEMIA!D42)","v":0},"Ciągi pieszych"]
[]
[null,"Budżet na eksploatację maszyn (pady, szczotki, gumy, serwis)",null,null,{"$f":"SUM(E38:E66)","v":0},"Budżet na eksploatację sprzętu drobnego",null,null,{"$f":"SUM(I38:I87)","v":0}]
[null,"Budżet na najem maszyn",null,null,{"$f":"SUM(D38:D66)","v":0},"Budżet na zakup sprzętu drobnego",null,null,{"$f":"SUM(H38:H87)","v":0}]
[null,"WYKAZ MASZYN",null,null,null,"WYKAZ SPRZĘTU DROBNEGO"]
[null,"Symbol i nazwa","Ilość","Budżet na najem msc ","Koszt eksploatacji msc","Symbol i nazwa","Ilość","Budżet na zakup","Koszt eksploatacji msc"]
[1,{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G38,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A38,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"}]
[2,{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G39,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A39,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(C39,G39)<=0,\"TAK\",\"\")","v":"TAK"}]
[3,{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G40,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A40,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[4,{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G41,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A41,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[5,{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G42,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A42,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[6,{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G43,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A43,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[7,{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G44,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A44,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[8,{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G45,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A45,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[9,{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G46,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A46,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[10,{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G47,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A47,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[11,{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G48,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A48,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[12,{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G49,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A49,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[13,{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G50,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A50,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[14,{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G51,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A51,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[15,{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G52,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A52,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[16,{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G53,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A53,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[17,{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G54,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A54,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[18,{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G55,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A55,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[19,{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G56,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A56,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[20,{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G57,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A57,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[21,{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G58,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A58,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[22,{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G59,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A59,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[23,{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G60,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A60,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[24,{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G61,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A61,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[25,{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G62,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A62,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[26,{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G63,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A63,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[27,{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G64,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A64,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[28,{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$60:$S$80,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$60:$S$80,13,0),\"---\")","v":"---"},{"$f":"IFERROR(IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$60:$S$80,8,0),\"---\")*G65,\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A65,'MASZYNY SPRZĘT'!$C$60:$S$80,11,0),\"---\")","v":"---"},null,null,null,"TAK"]
[29,{"$f":"IFERROR(VLOOKUP(A66,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A66,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A66,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A66,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},"Teren zewnętrzny - sprzęt"]
[30,{"$f":"IFERROR(VLOOKUP(A67,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A67,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A67,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A67,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O84<1,\"---\",'MASZYNY SPRZĘT'!E84)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O84<1,\"---\",'MASZYNY SPRZĘT'!O84)","v":"---"},{"$f":"IF(F67=\"---\",\"---\",'MASZYNY SPRZĘT'!J84*'Karta obiektu'!G67)","v":"---"},{"$f":"IF(F67=\"---\",\"---\",'MASZYNY SPRZĘT'!M84)","v":"---"}]
[31,{"$f":"IFERROR(VLOOKUP(A68,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A68,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A68,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A68,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O85<1,\"---\",'MASZYNY SPRZĘT'!E85)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O85<1,\"---\",'MASZYNY SPRZĘT'!O85)","v":"---"},{"$f":"IF(F68=\"---\",\"---\",'MASZYNY SPRZĘT'!J85*'Karta obiektu'!G68)","v":"---"},{"$f":"IF(F68=\"---\",\"---\",'MASZYNY SPRZĘT'!M85)","v":"---"},null,null,null,{"$f":"IF(SUM(C68,G68)<=0,\"TAK\",\"\")","v":"TAK"}]
[32,{"$f":"IFERROR(VLOOKUP(A69,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A69,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A69,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A69,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O86<1,\"---\",'MASZYNY SPRZĘT'!E86)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O86<1,\"---\",'MASZYNY SPRZĘT'!O86)","v":"---"},{"$f":"IF(F69=\"---\",\"---\",'MASZYNY SPRZĘT'!J86*'Karta obiektu'!G69)","v":"---"},{"$f":"IF(F69=\"---\",\"---\",'MASZYNY SPRZĘT'!M86)","v":"---"},null,null,null,"TAK"]
[33,{"$f":"IFERROR(VLOOKUP(A70,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A70,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A70,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A70,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O87<1,\"---\",'MASZYNY SPRZĘT'!E87)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O87<1,\"---\",'MASZYNY SPRZĘT'!O87)","v":"---"},{"$f":"IF(F70=\"---\",\"---\",'MASZYNY SPRZĘT'!J87*'Karta obiektu'!G70)","v":"---"},{"$f":"IF(F70=\"---\",\"---\",'MASZYNY SPRZĘT'!M87)","v":"---"},null,null,null,"TAK"]
[34,{"$f":"IFERROR(VLOOKUP(A71,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A71,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A71,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A71,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O88<1,\"---\",'MASZYNY SPRZĘT'!E88)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O88<1,\"---\",'MASZYNY SPRZĘT'!O88)","v":"---"},{"$f":"IF(F71=\"---\",\"---\",'MASZYNY SPRZĘT'!J88*'Karta obiektu'!G71)","v":"---"},{"$f":"IF(F71=\"---\",\"---\",'MASZYNY SPRZĘT'!M88)","v":"---"},null,null,null,"TAK"]
[35,{"$f":"IFERROR(VLOOKUP(A72,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A72,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A72,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A72,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O89<1,\"---\",'MASZYNY SPRZĘT'!E89)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O89<1,\"---\",'MASZYNY SPRZĘT'!O89)","v":"---"},{"$f":"IF(F72=\"---\",\"---\",'MASZYNY SPRZĘT'!J89*'Karta obiektu'!G72)","v":"---"},{"$f":"IF(F72=\"---\",\"---\",'MASZYNY SPRZĘT'!M89)","v":"---"},null,null,null,"TAK"]
[36,{"$f":"IFERROR(VLOOKUP(A73,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A73,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A73,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A73,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O90<1,\"---\",'MASZYNY SPRZĘT'!E90)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O90<1,\"---\",'MASZYNY SPRZĘT'!O90)","v":"---"},{"$f":"IF(F73=\"---\",\"---\",'MASZYNY SPRZĘT'!J90*'Karta obiektu'!G73)","v":"---"},{"$f":"IF(F73=\"---\",\"---\",'MASZYNY SPRZĘT'!M90)","v":"---"},null,null,null,"TAK"]
[37,{"$f":"IFERROR(VLOOKUP(A74,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A74,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A74,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A74,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O91<1,\"---\",'MASZYNY SPRZĘT'!E91)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O91<1,\"---\",'MASZYNY SPRZĘT'!O91)","v":"---"},{"$f":"IF(F74=\"---\",\"---\",'MASZYNY SPRZĘT'!J91*'Karta obiektu'!G74)","v":"---"},{"$f":"IF(F74=\"---\",\"---\",'MASZYNY SPRZĘT'!M91)","v":"---"},null,null,null,"TAK"]
[38,{"$f":"IFERROR(VLOOKUP(A75,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A75,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A75,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A75,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O92<1,\"---\",'MASZYNY SPRZĘT'!E92)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O92<1,\"---\",'MASZYNY SPRZĘT'!O92)","v":"---"},{"$f":"IF(F75=\"---\",\"---\",'MASZYNY SPRZĘT'!J92*'Karta obiektu'!G75)","v":"---"},{"$f":"IF(F75=\"---\",\"---\",'MASZYNY SPRZĘT'!M92)","v":"---"},null,null,null,"TAK"]
[39,{"$f":"IFERROR(VLOOKUP(A76,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A76,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A76,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A76,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O93<1,\"---\",'MASZYNY SPRZĘT'!E93)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O93<1,\"---\",'MASZYNY SPRZĘT'!O93)","v":"---"},{"$f":"IF(F76=\"---\",\"---\",'MASZYNY SPRZĘT'!J93*'Karta obiektu'!G76)","v":"---"},{"$f":"IF(F76=\"---\",\"---\",'MASZYNY SPRZĘT'!M93)","v":"---"},null,null,null,"TAK"]
[40,{"$f":"IFERROR(VLOOKUP(A77,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A77,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A77,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A77,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O98<1,\"---\",'MASZYNY SPRZĘT'!E98)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O98<1,\"---\",'MASZYNY SPRZĘT'!O98)","v":"---"},{"$f":"IF(F77=\"---\",\"---\",'MASZYNY SPRZĘT'!J98*'Karta obiektu'!G77)","v":"---"},{"$f":"IF(F77=\"---\",\"---\",'MASZYNY SPRZĘT'!M98)","v":"---"},null,null,null,"TAK"]
[41,{"$f":"IFERROR(VLOOKUP(A78,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A78,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A78,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A78,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O99<1,\"---\",'MASZYNY SPRZĘT'!E99)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O99<1,\"---\",'MASZYNY SPRZĘT'!O99)","v":"---"},{"$f":"IF(F78=\"---\",\"---\",'MASZYNY SPRZĘT'!J99*'Karta obiektu'!G78)","v":"---"},{"$f":"IF(F78=\"---\",\"---\",'MASZYNY SPRZĘT'!M99)","v":"---"},null,null,null,"TAK"]
[42,{"$f":"IFERROR(VLOOKUP(A79,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A79,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A79,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A79,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O100<1,\"---\",'MASZYNY SPRZĘT'!E100)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O100<1,\"---\",'MASZYNY SPRZĘT'!O100)","v":"---"},{"$f":"IF(F79=\"---\",\"---\",'MASZYNY SPRZĘT'!J100*'Karta obiektu'!G79)","v":"---"},{"$f":"IF(F79=\"---\",\"---\",'MASZYNY SPRZĘT'!M100)","v":"---"},null,null,null,"TAK"]
[43,{"$f":"IFERROR(VLOOKUP(A80,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A80,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A80,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A80,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O101<1,\"---\",'MASZYNY SPRZĘT'!E101)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O101<1,\"---\",'MASZYNY SPRZĘT'!O101)","v":"---"},{"$f":"IF(F80=\"---\",\"---\",'MASZYNY SPRZĘT'!J101*'Karta obiektu'!G80)","v":"---"},{"$f":"IF(F80=\"---\",\"---\",'MASZYNY SPRZĘT'!M101)","v":"---"},null,null,null,"TAK"]
[44,{"$f":"IFERROR(VLOOKUP(A81,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A81,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A81,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A81,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O102<1,\"---\",'MASZYNY SPRZĘT'!E102)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O102<1,\"---\",'MASZYNY SPRZĘT'!O102)","v":"---"},{"$f":"IF(F81=\"---\",\"---\",'MASZYNY SPRZĘT'!J102*'Karta obiektu'!G81)","v":"---"},{"$f":"IF(F81=\"---\",\"---\",'MASZYNY SPRZĘT'!M102)","v":"---"},null,null,null,"TAK"]
[45,{"$f":"IFERROR(VLOOKUP(A82,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A82,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A82,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A82,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O103<1,\"---\",'MASZYNY SPRZĘT'!E103)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O103<1,\"---\",'MASZYNY SPRZĘT'!O103)","v":"---"},{"$f":"IF(F82=\"---\",\"---\",'MASZYNY SPRZĘT'!J103*'Karta obiektu'!G82)","v":"---"},{"$f":"IF(F82=\"---\",\"---\",'MASZYNY SPRZĘT'!M103)","v":"---"},null,null,null,"TAK"]
[46,{"$f":"IFERROR(VLOOKUP(A83,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A83,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A83,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A83,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O104<1,\"---\",'MASZYNY SPRZĘT'!E104)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O104<1,\"---\",'MASZYNY SPRZĘT'!O104)","v":"---"},{"$f":"IF(F83=\"---\",\"---\",'MASZYNY SPRZĘT'!J104*'Karta obiektu'!G83)","v":"---"},{"$f":"IF(F83=\"---\",\"---\",'MASZYNY SPRZĘT'!M104)","v":"---"},null,null,null,"TAK"]
[47,{"$f":"IFERROR(VLOOKUP(A84,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A84,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A84,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A84,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O105<1,\"---\",'MASZYNY SPRZĘT'!E105)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O105<1,\"---\",'MASZYNY SPRZĘT'!O105)","v":"---"},{"$f":"IF(F84=\"---\",\"---\",'MASZYNY SPRZĘT'!J105*'Karta obiektu'!G84)","v":"---"},{"$f":"IF(F84=\"---\",\"---\",'MASZYNY SPRZĘT'!M105)","v":"---"},null,null,null,"TAK"]
[48,{"$f":"IFERROR(VLOOKUP(A85,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A85,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A85,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A85,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O106<1,\"---\",'MASZYNY SPRZĘT'!E106)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O106<1,\"---\",'MASZYNY SPRZĘT'!O106)","v":"---"},{"$f":"IF(F85=\"---\",\"---\",'MASZYNY SPRZĘT'!J106*'Karta obiektu'!G85)","v":"---"},{"$f":"IF(F85=\"---\",\"---\",'MASZYNY SPRZĘT'!M106)","v":"---"},null,null,null,"TAK"]
[49,{"$f":"IFERROR(VLOOKUP(A86,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A86,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A86,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A86,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O107<1,\"---\",'MASZYNY SPRZĘT'!E107)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O107<1,\"---\",'MASZYNY SPRZĘT'!O107)","v":"---"},{"$f":"IF(F86=\"---\",\"---\",'MASZYNY SPRZĘT'!J107*'Karta obiektu'!G86)","v":"---"},{"$f":"IF(F86=\"---\",\"---\",'MASZYNY SPRZĘT'!M107)","v":"---"},null,null,null,"TAK"]
[50,{"$f":"IFERROR(VLOOKUP(A87,'MASZYNY SPRZĘT'!$C$6:$S$55,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A87,'MASZYNY SPRZĘT'!$C$6:$S$55,13,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A87,'MASZYNY SPRZĘT'!$C$6:$S$55,10,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A87,'MASZYNY SPRZĘT'!$C$6:$S$55,11,0),\"---\")","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O108<1,\"---\",'MASZYNY SPRZĘT'!E108)","v":"---"},{"$f":"IF('MASZYNY SPRZĘT'!O108<1,\"---\",'MASZYNY SPRZĘT'!O108)","v":"---"},{"$f":"IF(F87=\"---\",\"---\",'MASZYNY SPRZĘT'!J108*'Karta obiektu'!G87)","v":"---"},{"$f":"IF(F87=\"---\",\"---\",'MASZYNY SPRZĘT'!M108)","v":"---"},null,null,null,"TAK"]
[]
[null,"Budżet na dodatkowe materiały / urzadzenia:",null,null,null,"Budżet na chemię wewnętrzną",null,null,{"$f":"SUM(CHEMIA!F12,CHEMIA!F22,CHEMIA!F32,CHEMIA!F42)","v":0}]
[null,"UWAGI:",null,null,null,"UWAGI:"]
[]
[]
[]
[null,"Budżet na higienę:",null,null,{"$f":"SUM(HIGIENA!F9,HIGIENA!F16,HIGIENA!F23,HIGIENA!F33)","v":0},"Budżet na chemię zewnętrzną",null,null,{"$f":"CHEMIA!F52","v":0}]
[null,"UWAGI:",null,null,null,"UWAGI:"]
[]
[]
[]
[null,"HIGIENA - REFAKTURA",null,null,null,"Budżetna worki:",null,null,{"$f":"HIGIENA!F43","v":0}]
[null,"UWAGI:",null,null,null,"UWAGI:"]
[]
[]
[]
[null,"ZIMA",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM($F$105:$I$108,$E$113:$E$116,$E$119:$E$120,$I$113:$I$116,$I$119)<=0,\"TAK\",\"\")","v":"TAK"}]
[null,"Budżet całkowity na okres zimowy",null,null,null,{"$f":"ZIMA!I11*12","v":0},null,null,null,null,null,null,"TAK"]
[null,"Budżet miesięczny w okresie zimowym (listopad - marzec)",null,null,null,{"$f":"F105/5","v":0},null,null,null,null,null,null,"TAK"]
[null,"Budżet na roboczogodziny",null,null,null,{"$f":"ZIMA!J11","v":0},null,null,null,null,null,null,"TAK"]
[null,"Budżet na postojowe",null,null,null,{"$f":"ZIMA!K11","v":0},null,null,null,null,null,null,"TAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Nazwa",null,null,"Koszt","Nazwa",null,null,"Koszt",null,null,null,"TAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,{"$f":"ZIMA!B4","v":"Sprzęt ciężki - na miejscu "},null,null,null,{"$f":"ZIMA!B19","v":"Sprzęt ciężki  - dojazd"},null,null,null,null,null,null,"TAK"]
[null,{"$f":"ZIMA!C6&\" - budżet na postojowe\"","v":"Traktor duży - zima - budżet na postojowe"},null,null,{"$f":"ZIMA!K6","v":0},{"$f":"ZIMA!C21","v":"Traktor duży - zima"},null,null,{"$f":"ZIMA!I21","v":0},null,null,null,"TAK"]
[null,{"$f":"ZIMA!C7","v":"Traktor mały - zima"},null,null,{"$f":"ZIMA!I7","v":0},{"$f":"ZIMA!C22","v":"Traktor mały - zima"},null,null,{"$f":"ZIMA!I22","v":0},null,null,null,"TAK"]
[null,{"$f":"ZIMA!C8","v":"Ładowarka"},null,null,{"$f":"ZIMA!I8","v":0},{"$f":"ZIMA!C23","v":"Ładowarka"},null,null,{"$f":"ZIMA!I23","v":0},null,null,null,"TAK"]
[null,{"$f":"ZIMA!C9","v":"Wywrotka"},null,null,{"$f":"ZIMA!I9","v":0},{"$f":"ZIMA!C24","v":"Wywrotka"},null,null,{"$f":"ZIMA!I24","v":0},null,null,null,"TAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,{"$f":"ZIMA!B13","v":"Teren zewnętrzny - sprzęt do prac ręcznych"},null,null,"Budżet na zakup (roczny)",{"$f":"ZIMA!B29","v":"Koszty mieszanki / płatne przez okres 12 miesięcy (mieszanka sól/piach)"},null,null,null,null,null,null,"TAK"]
[null,{"$f":"ZIMA!C15","v":"Łopata do odśnieżania, łopatka, szufelka, wiaderko (ilość zestawów)"},null,null,{"$f":"ZIMA!I15*12","v":0},"Mieszanka sól/piach",null,null,{"$f":"ZIMA!G37","v":0},null,null,null,"TAK"]
[null,{"$f":"ZIMA!C16","v":"Inne"},null,null,{"$f":"ZIMA!I16*12","v":0},null,null,null,null,null,null,null,"TAK"]
[null,null,null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"REFAKTURA (budżet zimowy)",null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Nazwa",null,null,null,"Uwagi",null,null,null,null,null,null,"TAK"]
[null,"Sprzęt cieżki na miejscu",null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Teren zewnętrzny - sprzęt do prac",null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Sprzęt ciężki - dojazd",null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Koszty mieszanki soli",null,null,null,null,null,null,null,null,null,null,"TAK"]
[null,"Budżet na pracowników",null,null,null,null,null,null,null,null,null,null,"TAK"]
[]
[]
[null,"ODZIEŻ ROBOCZA",null,null,null,"PRACE DODATKOWE"]
[null,"ZAKUP ODZIEŻY (budżet roczny)",null,{"$f":"POZOSTAŁE!I6+POZOSTAŁE!I7","v":0},null,"Prace dodatkowe (budżet roczny)",null,{"$f":"SUM(H134:H142)","v":0}]
[null,"Spodnie",null,"Kamizelka",null,"Nazwa","Częstotliwość","Budżet roczny","Budżet miesięczny"]
[1,"T-shirt zwykły",null,"Kurtka",null,{"$f":"IFERROR(VLOOKUP(A134,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A134,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A134,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A134,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"}]
[2,"Koszulka polo",null,"Czapka",null,{"$f":"IFERROR(VLOOKUP(A135,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A135,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A135,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A135,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"}]
[3,"Fartuszek",null,"Kask",null,{"$f":"IFERROR(VLOOKUP(A136,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A136,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A136,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A136,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"}]
[4,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A137,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A137,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A137,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A137,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(G137:I137)<=0,\"TAK\",\"\")","v":"TAK"}]
[5,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A138,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A138,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A138,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A138,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(G138:I138)<=0,\"TAK\",\"\")","v":"TAK"}]
[6,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A139,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A139,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A139,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A139,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(G139:I139)<=0,\"TAK\",\"\")","v":"TAK"}]
[7,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A140,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A140,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A140,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A140,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(G140:I140)<=0,\"TAK\",\"\")","v":"TAK"}]
[8,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A141,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A141,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A141,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A141,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"},null,null,null,{"$f":"IF(SUM(G141:I141)<=0,\"TAK\",\"\")","v":"TAK"}]
[9,{"$f":"POZOSTAŁE!E8&\" (msc)\"","v":"Pranie strojów roboczych (msc)"},null,{"$f":"POZOSTAŁE!J8","v":0},null,{"$f":"IFERROR(VLOOKUP(A142,POZOSTAŁE!$C$9:$G$16,3,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A142,POZOSTAŁE!$C$9:$G$16,5,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A142,POZOSTAŁE!$C$9:$I$16,7,0),\"---\")","v":"---"},{"$f":"IFERROR(VLOOKUP(A142,POZOSTAŁE!$C$9:$J$16,8,0),\"---\")","v":"---"}]
[]
[]
[null,"PRACOWNICY"]
[null,"Ilość osób","Dni pracy w tyg","Sezon","Godziny pracy","zł netto/rbh","zł brutto/rbh","rbh/m-c","Wynagrodzenie netto","Wynagrodzenie brutto pracownika ","Typ umowy","Opis stanowiska"]
[null,{"$f":"IF(PRACOWNICY!K6=\"\",\"\",PRACOWNICY!K6)","v":""},{"$f":"IF(PRACOWNICY!L6=\"\",\"\",PRACOWNICY!L6)","v":""},{"$f":"IF(PRACOWNICY!F6=\"\",\"\",PRACOWNICY!F6)","v":"Cały rok"},{"$f":"IF(PRACOWNICY!H6=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H6,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I6,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T6=\"\",\"\",PRACOWNICY!T6)","v":24.5},{"$f":"IFERROR(IF(J147=\"\",\"\",J147/H147),0)","v":0},{"$f":"IF(PRACOWNICY!Q6=\"\",\"\",PRACOWNICY!Q6)","v":0},{"$f":"IF(PRACOWNICY!U6=\"\",\"\",PRACOWNICY!U6)","v":0},{"$f":"IF(PRACOWNICY!V6=\"\",\"\",PRACOWNICY!V6)","v":0},{"$f":"IF(PRACOWNICY!G6=\"\",\"\",PRACOWNICY!G6)","v":"zlecenie"},{"$f":"IF(PRACOWNICY!E6=\"\",\"\",PRACOWNICY!E6)","v":""},{"$f":"IF(B147=\"\",\"TAK\",\"\")","v":"TAK"}]
[null,{"$f":"IF(PRACOWNICY!K7=\"\",\"\",PRACOWNICY!K7)","v":""},{"$f":"IF(PRACOWNICY!L7=\"\",\"\",PRACOWNICY!L7)","v":""},{"$f":"IF(PRACOWNICY!F7=\"\",\"\",PRACOWNICY!F7)","v":"Cały rok"},{"$f":"IF(PRACOWNICY!H7=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H7,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I7,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T7=\"\",\"\",PRACOWNICY!T7)","v":24.5},{"$f":"IFERROR(IF(J148=\"\",\"\",J148/H148),0)","v":0},{"$f":"IF(PRACOWNICY!Q7=\"\",\"\",PRACOWNICY!Q7)","v":0},{"$f":"IF(PRACOWNICY!U7=\"\",\"\",PRACOWNICY!U7)","v":0},{"$f":"IF(PRACOWNICY!V7=\"\",\"\",PRACOWNICY!V7)","v":0},{"$f":"IF(PRACOWNICY!G7=\"\",\"\",PRACOWNICY!G7)","v":"zlecenie"},{"$f":"IF(PRACOWNICY!E7=\"\",\"\",PRACOWNICY!E7)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K8=\"\",\"\",PRACOWNICY!K8)","v":""},{"$f":"IF(PRACOWNICY!L8=\"\",\"\",PRACOWNICY!L8)","v":""},{"$f":"IF(PRACOWNICY!F8=\"\",\"\",PRACOWNICY!F8)","v":""},{"$f":"IF(PRACOWNICY!H8=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H8,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I8,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T8=\"\",\"\",PRACOWNICY!T8)","v":""},"",{"$f":"IF(PRACOWNICY!Q8=\"\",\"\",PRACOWNICY!Q8)","v":""},{"$f":"IF(PRACOWNICY!U8=\"\",\"\",PRACOWNICY!U8)","v":""},{"$f":"IF(PRACOWNICY!V8=\"\",\"\",PRACOWNICY!V8)","v":""},{"$f":"IF(PRACOWNICY!G8=\"\",\"\",PRACOWNICY!G8)","v":""},{"$f":"IF(PRACOWNICY!E8=\"\",\"\",PRACOWNICY!E8)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K9=\"\",\"\",PRACOWNICY!K9)","v":""},{"$f":"IF(PRACOWNICY!L9=\"\",\"\",PRACOWNICY!L9)","v":""},{"$f":"IF(PRACOWNICY!F9=\"\",\"\",PRACOWNICY!F9)","v":""},{"$f":"IF(PRACOWNICY!H9=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H9,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I9,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T9=\"\",\"\",PRACOWNICY!T9)","v":""},"",{"$f":"IF(PRACOWNICY!Q9=\"\",\"\",PRACOWNICY!Q9)","v":""},{"$f":"IF(PRACOWNICY!U9=\"\",\"\",PRACOWNICY!U9)","v":""},{"$f":"IF(PRACOWNICY!V9=\"\",\"\",PRACOWNICY!V9)","v":""},{"$f":"IF(PRACOWNICY!G9=\"\",\"\",PRACOWNICY!G9)","v":""},{"$f":"IF(PRACOWNICY!E9=\"\",\"\",PRACOWNICY!E9)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K10=\"\",\"\",PRACOWNICY!K10)","v":""},{"$f":"IF(PRACOWNICY!L10=\"\",\"\",PRACOWNICY!L10)","v":""},{"$f":"IF(PRACOWNICY!F10=\"\",\"\",PRACOWNICY!F10)","v":""},{"$f":"IF(PRACOWNICY!H10=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H10,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I10,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T10=\"\",\"\",PRACOWNICY!T10)","v":""},"",{"$f":"IF(PRACOWNICY!Q10=\"\",\"\",PRACOWNICY!Q10)","v":""},{"$f":"IF(PRACOWNICY!U10=\"\",\"\",PRACOWNICY!U10)","v":""},{"$f":"IF(PRACOWNICY!V10=\"\",\"\",PRACOWNICY!V10)","v":""},{"$f":"IF(PRACOWNICY!G10=\"\",\"\",PRACOWNICY!G10)","v":""},{"$f":"IF(PRACOWNICY!E10=\"\",\"\",PRACOWNICY!E10)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K11=\"\",\"\",PRACOWNICY!K11)","v":""},{"$f":"IF(PRACOWNICY!L11=\"\",\"\",PRACOWNICY!L11)","v":""},{"$f":"IF(PRACOWNICY!F11=\"\",\"\",PRACOWNICY!F11)","v":""},{"$f":"IF(PRACOWNICY!H11=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H11,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I11,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T11=\"\",\"\",PRACOWNICY!T11)","v":""},"",{"$f":"IF(PRACOWNICY!Q11=\"\",\"\",PRACOWNICY!Q11)","v":""},{"$f":"IF(PRACOWNICY!U11=\"\",\"\",PRACOWNICY!U11)","v":""},{"$f":"IF(PRACOWNICY!V11=\"\",\"\",PRACOWNICY!V11)","v":""},{"$f":"IF(PRACOWNICY!G11=\"\",\"\",PRACOWNICY!G11)","v":""},{"$f":"IF(PRACOWNICY!E11=\"\",\"\",PRACOWNICY!E11)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K12=\"\",\"\",PRACOWNICY!K12)","v":""},{"$f":"IF(PRACOWNICY!L12=\"\",\"\",PRACOWNICY!L12)","v":""},{"$f":"IF(PRACOWNICY!F12=\"\",\"\",PRACOWNICY!F12)","v":""},{"$f":"IF(PRACOWNICY!H12=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H12,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I12,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T12=\"\",\"\",PRACOWNICY!T12)","v":""},"",{"$f":"IF(PRACOWNICY!Q12=\"\",\"\",PRACOWNICY!Q12)","v":""},{"$f":"IF(PRACOWNICY!U12=\"\",\"\",PRACOWNICY!U12)","v":""},{"$f":"IF(PRACOWNICY!V12=\"\",\"\",PRACOWNICY!V12)","v":""},{"$f":"IF(PRACOWNICY!G12=\"\",\"\",PRACOWNICY!G12)","v":""},{"$f":"IF(PRACOWNICY!E12=\"\",\"\",PRACOWNICY!E12)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K13=\"\",\"\",PRACOWNICY!K13)","v":""},{"$f":"IF(PRACOWNICY!L13=\"\",\"\",PRACOWNICY!L13)","v":""},{"$f":"IF(PRACOWNICY!F13=\"\",\"\",PRACOWNICY!F13)","v":""},{"$f":"IF(PRACOWNICY!H13=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H13,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I13,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T13=\"\",\"\",PRACOWNICY!T13)","v":""},"",{"$f":"IF(PRACOWNICY!Q13=\"\",\"\",PRACOWNICY!Q13)","v":""},{"$f":"IF(PRACOWNICY!U13=\"\",\"\",PRACOWNICY!U13)","v":""},{"$f":"IF(PRACOWNICY!V13=\"\",\"\",PRACOWNICY!V13)","v":""},{"$f":"IF(PRACOWNICY!G13=\"\",\"\",PRACOWNICY!G13)","v":""},{"$f":"IF(PRACOWNICY!E13=\"\",\"\",PRACOWNICY!E13)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K14=\"\",\"\",PRACOWNICY!K14)","v":""},{"$f":"IF(PRACOWNICY!L14=\"\",\"\",PRACOWNICY!L14)","v":""},{"$f":"IF(PRACOWNICY!F14=\"\",\"\",PRACOWNICY!F14)","v":""},{"$f":"IF(PRACOWNICY!H14=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H14,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I14,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T14=\"\",\"\",PRACOWNICY!T14)","v":""},"",{"$f":"IF(PRACOWNICY!Q14=\"\",\"\",PRACOWNICY!Q14)","v":""},{"$f":"IF(PRACOWNICY!U14=\"\",\"\",PRACOWNICY!U14)","v":""},{"$f":"IF(PRACOWNICY!V14=\"\",\"\",PRACOWNICY!V14)","v":""},{"$f":"IF(PRACOWNICY!G14=\"\",\"\",PRACOWNICY!G14)","v":""},{"$f":"IF(PRACOWNICY!E14=\"\",\"\",PRACOWNICY!E14)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K15=\"\",\"\",PRACOWNICY!K15)","v":""},{"$f":"IF(PRACOWNICY!L15=\"\",\"\",PRACOWNICY!L15)","v":""},{"$f":"IF(PRACOWNICY!F15=\"\",\"\",PRACOWNICY!F15)","v":""},{"$f":"IF(PRACOWNICY!H15=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H15,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I15,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T15=\"\",\"\",PRACOWNICY!T15)","v":""},"",{"$f":"IF(PRACOWNICY!Q15=\"\",\"\",PRACOWNICY!Q15)","v":""},{"$f":"IF(PRACOWNICY!U15=\"\",\"\",PRACOWNICY!U15)","v":""},{"$f":"IF(PRACOWNICY!V15=\"\",\"\",PRACOWNICY!V15)","v":""},{"$f":"IF(PRACOWNICY!G15=\"\",\"\",PRACOWNICY!G15)","v":""},{"$f":"IF(PRACOWNICY!E15=\"\",\"\",PRACOWNICY!E15)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K16=\"\",\"\",PRACOWNICY!K16)","v":""},{"$f":"IF(PRACOWNICY!L16=\"\",\"\",PRACOWNICY!L16)","v":""},{"$f":"IF(PRACOWNICY!F16=\"\",\"\",PRACOWNICY!F16)","v":""},{"$f":"IF(PRACOWNICY!H16=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H16,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I16,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T16=\"\",\"\",PRACOWNICY!T16)","v":""},"",{"$f":"IF(PRACOWNICY!Q16=\"\",\"\",PRACOWNICY!Q16)","v":""},{"$f":"IF(PRACOWNICY!U16=\"\",\"\",PRACOWNICY!U16)","v":""},{"$f":"IF(PRACOWNICY!V16=\"\",\"\",PRACOWNICY!V16)","v":""},{"$f":"IF(PRACOWNICY!G16=\"\",\"\",PRACOWNICY!G16)","v":""},{"$f":"IF(PRACOWNICY!E16=\"\",\"\",PRACOWNICY!E16)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K17=\"\",\"\",PRACOWNICY!K17)","v":""},{"$f":"IF(PRACOWNICY!L17=\"\",\"\",PRACOWNICY!L17)","v":""},{"$f":"IF(PRACOWNICY!F17=\"\",\"\",PRACOWNICY!F17)","v":""},{"$f":"IF(PRACOWNICY!H17=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H17,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I17,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T17=\"\",\"\",PRACOWNICY!T17)","v":""},"",{"$f":"IF(PRACOWNICY!Q17=\"\",\"\",PRACOWNICY!Q17)","v":""},{"$f":"IF(PRACOWNICY!U17=\"\",\"\",PRACOWNICY!U17)","v":""},{"$f":"IF(PRACOWNICY!V17=\"\",\"\",PRACOWNICY!V17)","v":""},{"$f":"IF(PRACOWNICY!G17=\"\",\"\",PRACOWNICY!G17)","v":""},{"$f":"IF(PRACOWNICY!E17=\"\",\"\",PRACOWNICY!E17)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K18=\"\",\"\",PRACOWNICY!K18)","v":""},{"$f":"IF(PRACOWNICY!L18=\"\",\"\",PRACOWNICY!L18)","v":""},{"$f":"IF(PRACOWNICY!F18=\"\",\"\",PRACOWNICY!F18)","v":""},{"$f":"IF(PRACOWNICY!H18=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H18,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I18,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T18=\"\",\"\",PRACOWNICY!T18)","v":""},"",{"$f":"IF(PRACOWNICY!Q18=\"\",\"\",PRACOWNICY!Q18)","v":""},{"$f":"IF(PRACOWNICY!U18=\"\",\"\",PRACOWNICY!U18)","v":""},{"$f":"IF(PRACOWNICY!V18=\"\",\"\",PRACOWNICY!V18)","v":""},{"$f":"IF(PRACOWNICY!G18=\"\",\"\",PRACOWNICY!G18)","v":""},{"$f":"IF(PRACOWNICY!E18=\"\",\"\",PRACOWNICY!E18)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K19=\"\",\"\",PRACOWNICY!K19)","v":""},{"$f":"IF(PRACOWNICY!L19=\"\",\"\",PRACOWNICY!L19)","v":""},{"$f":"IF(PRACOWNICY!F19=\"\",\"\",PRACOWNICY!F19)","v":""},{"$f":"IF(PRACOWNICY!H19=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H19,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I19,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T19=\"\",\"\",PRACOWNICY!T19)","v":""},"",{"$f":"IF(PRACOWNICY!Q19=\"\",\"\",PRACOWNICY!Q19)","v":""},{"$f":"IF(PRACOWNICY!U19=\"\",\"\",PRACOWNICY!U19)","v":""},{"$f":"IF(PRACOWNICY!V19=\"\",\"\",PRACOWNICY!V19)","v":""},{"$f":"IF(PRACOWNICY!G19=\"\",\"\",PRACOWNICY!G19)","v":""},{"$f":"IF(PRACOWNICY!E19=\"\",\"\",PRACOWNICY!E19)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K20=\"\",\"\",PRACOWNICY!K20)","v":""},{"$f":"IF(PRACOWNICY!L20=\"\",\"\",PRACOWNICY!L20)","v":""},{"$f":"IF(PRACOWNICY!F20=\"\",\"\",PRACOWNICY!F20)","v":""},{"$f":"IF(PRACOWNICY!H20=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H20,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I20,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T20=\"\",\"\",PRACOWNICY!T20)","v":""},"",{"$f":"IF(PRACOWNICY!Q20=\"\",\"\",PRACOWNICY!Q20)","v":""},{"$f":"IF(PRACOWNICY!U20=\"\",\"\",PRACOWNICY!U20)","v":""},{"$f":"IF(PRACOWNICY!V20=\"\",\"\",PRACOWNICY!V20)","v":""},{"$f":"IF(PRACOWNICY!G20=\"\",\"\",PRACOWNICY!G20)","v":""},{"$f":"IF(PRACOWNICY!E20=\"\",\"\",PRACOWNICY!E20)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K21=\"\",\"\",PRACOWNICY!K21)","v":""},{"$f":"IF(PRACOWNICY!L21=\"\",\"\",PRACOWNICY!L21)","v":""},{"$f":"IF(PRACOWNICY!F21=\"\",\"\",PRACOWNICY!F21)","v":""},{"$f":"IF(PRACOWNICY!H21=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H21,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I21,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T21=\"\",\"\",PRACOWNICY!T21)","v":""},"",{"$f":"IF(PRACOWNICY!Q21=\"\",\"\",PRACOWNICY!Q21)","v":""},{"$f":"IF(PRACOWNICY!U21=\"\",\"\",PRACOWNICY!U21)","v":""},{"$f":"IF(PRACOWNICY!V21=\"\",\"\",PRACOWNICY!V21)","v":""},{"$f":"IF(PRACOWNICY!G21=\"\",\"\",PRACOWNICY!G21)","v":""},{"$f":"IF(PRACOWNICY!E21=\"\",\"\",PRACOWNICY!E21)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K22=\"\",\"\",PRACOWNICY!K22)","v":""},{"$f":"IF(PRACOWNICY!L22=\"\",\"\",PRACOWNICY!L22)","v":""},{"$f":"IF(PRACOWNICY!F22=\"\",\"\",PRACOWNICY!F22)","v":""},{"$f":"IF(PRACOWNICY!H22=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H22,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I22,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T22=\"\",\"\",PRACOWNICY!T22)","v":""},"",{"$f":"IF(PRACOWNICY!Q22=\"\",\"\",PRACOWNICY!Q22)","v":""},{"$f":"IF(PRACOWNICY!U22=\"\",\"\",PRACOWNICY!U22)","v":""},{"$f":"IF(PRACOWNICY!V22=\"\",\"\",PRACOWNICY!V22)","v":""},{"$f":"IF(PRACOWNICY!G22=\"\",\"\",PRACOWNICY!G22)","v":""},{"$f":"IF(PRACOWNICY!E22=\"\",\"\",PRACOWNICY!E22)","v":""},"TAK"]
[null,{"$f":"IF(PRACOWNICY!K23=\"\",\"\",PRACOWNICY!K23)","v":""},{"$f":"IF(PRACOWNICY!L23=\"\",\"\",PRACOWNICY!L23)","v":""},{"$f":"IF(PRACOWNICY!F23=\"\",\"\",PRACOWNICY!F23)","v":""},{"$f":"IF(PRACOWNICY!H23=\"\",\"\",_xlfn.CONCAT(TEXT(PRACOWNICY!H23,\"gg:mm\"),\"-\",TEXT(PRACOWNICY!I23,\"gg:mm\")))","v":""},{"$f":"IF(PRACOWNICY!T23=\"\",\"\",PRACOWNICY!T23)","v":""},"",{"$f":"IF(PRACOWNICY!Q23=\"\",\"\",PRACOWNICY!Q23)","v":""},{"$f":"IF(PRACOWNICY!U23=\"\",\"\",PRACOWNICY!U23)","v":""},{"$f":"IF(PRACOWNICY!V23=\"\",\"\",PRACOWNICY!V23)","v":""},{"$f":"IF(PRACOWNICY!G23=\"\",\"\",PRACOWNICY!G23)","v":""},{"$f":"IF(PRACOWNICY!E23=\"\",\"\",PRACOWNICY!E23)","v":""},"TAK"]
[null,"PODSUMOWANIE: suma roboczogodzin, budżet na wynagrodzenia / m-c",null,null,null,null,null,{"$f":"SUM(H147:H164)","v":0},{"$f":"SUM(I147:I164)","v":0},{"$f":"SUM(J147:J164)","v":0},"-","-"]
[]
[null,"KOORDYNACJA / NADZÓR / DODATKI DLA PRACOWNIKÓW"]
[null,"Nazwa stanowiska",null,null,null,"Kwota netto (pracownika)",null,"Kwota brutto (pracownika)"]
[null,{"$f":"PRACOWNICY!D28","v":"Główny kierownik obiektu (przyjezdny) - umowa o pracę"},null,null,null,{"$f":"PRACOWNICY!S28","v":138.875},null,{"$f":"PRACOWNICY!T28","v":193.49453750000004}]
[null,{"$f":"\"w tym: \"&PRACOWNICY!W27","v":"w tym: Zakwaterowanie"},null,null,null,"---------",null,{"$f":"PRACOWNICY!W28","v":0}]
[null,{"$f":"\"w tym: \"&PRACOWNICY!X27","v":"w tym: Dojazd"},null,null,null,"---------",null,{"$f":"PRACOWNICY!X28","v":0}]
[null,{"$f":"PRACOWNICY!D32&\": \"&PRACOWNICY!E32","v":"Inne dodatki dla pracowników / dojazdy: "},null,null,null,{"$f":"PRACOWNICY!G32","v":0},null,{"$f":"PRACOWNICY!J32","v":""}]
[null,{"$f":"IF(PRACOWNICY!D33=\"\",\"\",PRACOWNICY!D33&\": \"&PRACOWNICY!E33)","v":"Inne dodatki dla pracowników: "},null,null,null,{"$f":"PRACOWNICY!G33","v":0},null,{"$f":"PRACOWNICY!J33","v":""}]
[null,{"$f":"POZOSTAŁE!D23","v":"Budżet na dojazdy koordynatorów"},null,null,null,"---------",null,{"$f":"POZOSTAŁE!J26","v":0}]
[null,{"$f":"PRACOWNICY!D28&\" - ilość \"&PRACOWNICY!O27","v":"Główny kierownik obiektu (przyjezdny) - umowa o pracę - ilość rbh/m-c"},null,null,null,{"$f":"PRACOWNICY!O28","v":4.208333333333333},null,{"$f":"PRACOWNICY!O28","v":4.208333333333333}]
[]
[null,"Całkowity koszt pracowników",null,null,null,{"$f":"SUM(I147:I157,F169,F172,F173,F174)","v":138.875},null,{"$f":"SUM(J147:J157,H169,H172,H173,H174)","v":193.49453750000004}]

{"sheet":"Wykorzystanie budżetu","index":14,"n_rows":54,"n_cols":29,"rows_kept":54,"cut":false,"hidden":true,"merged":[[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,27,3,28],[3,17,3,18],[3,19,3,20],[3,21,3,22],[3,23,3,24],[3,25,3,26],[3,15,3,16],[30,1,30,3],[17,1,17,3],[24,1,24,3],[7,1,7,3],[26,1,26,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[27,1,27,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[25,1,25,2],[12,1,12,2],[50,1,50,2],[31,1,32,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[39,1,40,1],[13,1,13,2],[14,1,14,2],[18,1,18,2],[42,1,43,1],[46,1,46,2]]}
[null,null,null,null,null,"dodać formatowanie warunkowe"]
[null,"Początek projektu",{"$f":"'Karta obiektu'!D9","v":""}]
[null,null,null,null,"nr okresu",null,{"$f":"COUNTA($F$4:F4)","v":1},null,{"$f":"COUNTA($F$4:H4)","v":2},null,{"$f":"COUNTA($F$4:J4)","v":3},null,{"$f":"COUNTA($F$4:L4)","v":4},null,{"$f":"COUNTA($F$4:N4)","v":5},null,{"$f":"COUNTA($F$4:P4)","v":6},null,{"$f":"COUNTA($F$4:R4)","v":7},null,{"$f":"COUNTA($F$4:T4)","v":8},null,{"$f":"COUNTA($F$4:V4)","v":9},null,{"$f":"COUNTA($F$4:X4)","v":10},null,{"$f":"COUNTA($F$4:Z4)","v":11},null,{"$f":"COUNTA($F$4:AB4)","v":12}]
[null,null,null,null,null,{"$f":"C2","v":""},null,{"$f":"DATE(YEAR(F4),MONTH(F4)+1,DAY(F4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(H4),MONTH(H4)+1,DAY(H4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(J4),MONTH(J4)+1,DAY(J4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(L4),MONTH(L4)+1,DAY(L4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(N4),MONTH(N4)+1,DAY(N4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(P4),MONTH(P4)+1,DAY(P4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(R4),MONTH(R4)+1,DAY(R4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(T4),MONTH(T4)+1,DAY(T4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(V4),MONTH(V4)+1,DAY(V4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(X4),MONTH(X4)+1,DAY(X4))","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR(Z4),MONTH(Z4)+1,DAY(Z4))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,"Różnica względem budżetu narastająco",null,"Budżet msc","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki","Budżet","Wydatki"]
[]
[]
[null,"Eksploatacja maszyn (pady, szczotki, gumy, serwis)",null,{"$f":"('Karta obiektu'!E34*COUNTA(G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9,AC9)-SUM(G9,I9,K9,M9,O9,Q9,S9,U9,W9,Y9,AA9,AC9))","v":-6000},null,{"$f":"'Karta obiektu'!$E$34","v":0},2800,{"$f":"IF(G9=\"\",\"\",$F9+(F9-G9))","v":-2800},3200,{"$f":"IF(I9=\"\",\"\",$F9+(H9-I9))","v":-6000},null,{"$f":"IF(K9=\"\",\"\",$F9+(J9-K9))","v":""},null,{"$f":"IF(M9=\"\",\"\",$F9+(L9-M9))","v":""},null,{"$f":"IF(O9=\"\",\"\",$F9+(N9-O9))","v":""},null,{"$f":"IF(Q9=\"\",\"\",$F9+(P9-Q9))","v":""},null,{"$f":"IF(S9=\"\",\"\",$F9+(R9-S9))","v":""},null,{"$f":"IF(U9=\"\",\"\",$F9+(T9-U9))","v":""},null,{"$f":"IF(W9=\"\",\"\",$F9+(V9-W9))","v":""},null,{"$f":"IF(Y9=\"\",\"\",$F9+(X9-Y9))","v":""},null,{"$f":"IF(AA9=\"\",\"\",$F9+(Z9-AA9))","v":""}]
[null,"Najem maszyn",null,{"$f":"('Karta obiektu'!E35*COUNTA(G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10,AA10,AC10)-SUM(G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10,AA10,AC10))","v":-22750},null,{"$f":"'Karta obiektu'!$E$35","v":0},13000,{"$f":"IF(G10=\"\",\"\",$F10+(F10-G10))","v":-13000},9750,{"$f":"IF(I10=\"\",\"\",$F10+(H10-I10))","v":-22750},null,{"$f":"IF(K10=\"\",\"\",$F10+(J10-K10))","v":""},null,{"$f":"IF(M10=\"\",\"\",$F10+(L10-M10))","v":""},null,{"$f":"IF(O10=\"\",\"\",$F10+(N10-O10))","v":""},null,{"$f":"IF(Q10=\"\",\"\",$F10+(P10-Q10))","v":""},null,{"$f":"IF(S10=\"\",\"\",$F10+(R10-S10))","v":""},null,{"$f":"IF(U10=\"\",\"\",$F10+(T10-U10))","v":""},null,{"$f":"IF(W10=\"\",\"\",$F10+(V10-W10))","v":""},null,{"$f":"IF(Y10=\"\",\"\",$F10+(X10-Y10))","v":""},null,{"$f":"IF(AA10=\"\",\"\",$F10+(Z10-AA10))","v":""}]
[null,"Eksploatacja sprzętu drobnego",null,{"$f":"('Karta obiektu'!I34*COUNTA(G11,I11,K11,M11,O11,Q11,S11,U11,W11,Y11,AA11,AC11)-SUM(G11,I11,K11,M11,O11,Q11,S11,U11,W11,Y11,AA11,AC11))","v":-1130},null,{"$f":"'Karta obiektu'!$I$34","v":0},530,{"$f":"IF(G11=\"\",\"\",$F11+(F11-G11))","v":-530},600,{"$f":"IF(I11=\"\",\"\",$F11+(H11-I11))","v":-1130},null,{"$f":"IF(K11=\"\",\"\",$F11+(J11-K11))","v":""},null,{"$f":"IF(M11=\"\",\"\",$F11+(L11-M11))","v":""},null,{"$f":"IF(O11=\"\",\"\",$F11+(N11-O11))","v":""},null,{"$f":"IF(Q11=\"\",\"\",$F11+(P11-Q11))","v":""},null,{"$f":"IF(S11=\"\",\"\",$F11+(R11-S11))","v":""},null,{"$f":"IF(U11=\"\",\"\",$F11+(T11-U11))","v":""},null,{"$f":"IF(W11=\"\",\"\",$F11+(V11-W11))","v":""},null,{"$f":"IF(Y11=\"\",\"\",$F11+(X11-Y11))","v":""},null,{"$f":"IF(AA11=\"\",\"\",$F11+(Z11-AA11))","v":""}]
[null,"Zakup sprzętu drobnego",null,{"$f":"('Karta obiektu'!I35*COUNTA(G12,I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12)-SUM(G12,I12,K12,M12,O12,Q12,S12,U12,W12,Y12,AA12,AC12))","v":-5200},null,{"$f":"'Karta obiektu'!$I$35","v":0},2300,{"$f":"IF(G12=\"\",\"\",$F12+(F12-G12))","v":-2300},2900,{"$f":"IF(I12=\"\",\"\",$F12+(H12-I12))","v":-5200},null,{"$f":"IF(K12=\"\",\"\",$F12+(J12-K12))","v":""},null,{"$f":"IF(M12=\"\",\"\",$F12+(L12-M12))","v":""},null,{"$f":"IF(O12=\"\",\"\",$F12+(N12-O12))","v":""},null,{"$f":"IF(Q12=\"\",\"\",$F12+(P12-Q12))","v":""},null,{"$f":"IF(S12=\"\",\"\",$F12+(R12-S12))","v":""},null,{"$f":"IF(U12=\"\",\"\",$F12+(T12-U12))","v":""},null,{"$f":"IF(W12=\"\",\"\",$F12+(V12-W12))","v":""},null,{"$f":"IF(Y12=\"\",\"\",$F12+(X12-Y12))","v":""},null,{"$f":"IF(AA12=\"\",\"\",$F12+(Z12-AA12))","v":""}]
[null,"Materiały"]
[null,"Higiena",null,{"$f":"('Karta obiektu'!E94*COUNTA(G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14)-SUM(G14,I14,K14,M14,O14,Q14,S14,U14,W14,Y14,AA14,AC14))","v":-260},null,{"$f":"'Karta obiektu'!$E$94","v":0},100,{"$f":"IF(G14=\"\",\"\",$F14+(F14-G14))","v":-100},160,{"$f":"IF(I14=\"\",\"\",$F14+(H14-I14))","v":-260},null,{"$f":"IF(K14=\"\",\"\",$F14+(J14-K14))","v":""},null,{"$f":"IF(M14=\"\",\"\",$F14+(L14-M14))","v":""},null,{"$f":"IF(O14=\"\",\"\",$F14+(N14-O14))","v":""},null,{"$f":"IF(Q14=\"\",\"\",$F14+(P14-Q14))","v":""},null,{"$f":"IF(S14=\"\",\"\",$F14+(R14-S14))","v":""},null,{"$f":"IF(U14=\"\",\"\",$F14+(T14-U14))","v":""},null,{"$f":"IF(W14=\"\",\"\",$F14+(V14-W14))","v":""},null,{"$f":"IF(Y14=\"\",\"\",$F14+(X14-Y14))","v":""},null,{"$f":"IF(AA14=\"\",\"\",$F14+(Z14-AA14))","v":""}]
[null,"Chemia (wewn. i zewn.) + worki",null,{"$f":"(SUM('Karta obiektu'!$I$89,'Karta obiektu'!$I$94,'Karta obiektu'!$I$99)*COUNTA(G15,I15,K15,M15,O15,Q15,S15,U15,W15,Y15,AA15,AC15)-SUM(G15,I15,K15,M15,O15,Q15,S15,U15,W15,Y15,AA15,AC15))","v":0},null,{"$f":"SUM('Karta obiektu'!$I$89,'Karta obiektu'!$I$94,'Karta obiektu'!$I$99)","v":0},0,{"$f":"IF(G15=\"\",\"\",$F15+(F15-G15))","v":0},0,{"$f":"IF(I15=\"\",\"\",$F15+(H15-I15))","v":0},null,{"$f":"IF(K15=\"\",\"\",$F15+(J15-K15))","v":""},null,{"$f":"IF(M15=\"\",\"\",$F15+(L15-M15))","v":""},null,{"$f":"IF(O15=\"\",\"\",$F15+(N15-O15))","v":""},null,{"$f":"IF(Q15=\"\",\"\",$F15+(P15-Q15))","v":""},null,{"$f":"IF(S15=\"\",\"\",$F15+(R15-S15))","v":""},null,{"$f":"IF(U15=\"\",\"\",$F15+(T15-U15))","v":""},null,{"$f":"IF(W15=\"\",\"\",$F15+(V15-W15))","v":""},null,{"$f":"IF(Y15=\"\",\"\",$F15+(X15-Y15))","v":""},null,{"$f":"IF(AA15=\"\",\"\",$F15+(Z15-AA15))","v":""}]
[null,null,"SUMA",{"$f":"SUM(D9:D15)","v":-35340}]
[]
[null,"ZIMA",null,null,null,"na końcu dodać makro, które zakreśli miesiące niezimowe w tej sekcji - aby nie były wypełniane",null,null,null,null,null,null,"uwzględnić przesunięcie w formułach"]
[null,"Sprzęt ciężki - na miejscu",null,{"$f":"(SUM('Karta obiektu'!$E$113:$E$116)*COUNTA(G19,I19,K19,M19,O19,Q19,S19,U19,W19,Y19,AA19,AC19)-SUM(G19,I19,K19,M19,O19,Q19,S19,U19,W19,Y19,AA19,AC19))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Karta obiektu'!$E$113:$E$116)","v":0},null,{"$f":"IF(Q19=\"\",\"\",$P19+(P19-Q19))","v":""},null,{"$f":"IF(S19=\"\",\"\",$P19+(R19-S19))","v":""},null,{"$f":"IF(U19=\"\",\"\",$P19+(T19-U19))","v":""},null,{"$f":"IF(W19=\"\",\"\",$P19+(V19-W19))","v":""}]
[null,"Teren zewnętrzny - sprzęt do prac ręcznych",null,{"$f":"(SUM('Karta obiektu'!$E$119:$E$120)*COUNTA(G20,I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20)-SUM(G20,I20,K20,M20,O20,Q20,S20,U20,W20,Y20,AA20,AC20))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Karta obiektu'!$E$119:$E$120)","v":0},null,{"$f":"IF(Q20=\"\",\"\",$P20+(P20-Q20))","v":""},null,{"$f":"IF(S20=\"\",\"\",$P20+(R20-S20))","v":""},null,{"$f":"IF(U20=\"\",\"\",$P20+(T20-U20))","v":""},null,{"$f":"IF(W20=\"\",\"\",$P20+(V20-W20))","v":""}]
[null,"Sprzęt ciężki - dojazd",null,{"$f":"(SUM('Karta obiektu'!I113:I116)*COUNTA(G21,I21,K21,M21,O21,Q21,S21,U21,W21,Y21,AA21,AC21)-SUM(G21,I21,K21,M21,O21,Q21,S21,U21,W21,Y21,AA21,AC21))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Karta obiektu'!I113:I116)","v":0},null,{"$f":"IF(Q21=\"\",\"\",$P21+(P21-Q21))","v":""},null,{"$f":"IF(S21=\"\",\"\",$P21+(R21-S21))","v":""},null,{"$f":"IF(U21=\"\",\"\",$P21+(T21-U21))","v":""},null,{"$f":"IF(W21=\"\",\"\",$P21+(V21-W21))","v":""}]
[null,"Mieszanka sól/piach",null,{"$f":"(SUM('Karta obiektu'!I119:I120)*COUNTA(G22,I22,K22,M22,O22,Q22,S22,U22,W22,Y22,AA22,AC22)-SUM(G22,I22,K22,M22,O22,Q22,S22,U22,W22,Y22,AA22,AC22))","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('Karta obiektu'!I119:I120)","v":0},null,{"$f":"IF(Q22=\"\",\"\",$P22+(P22-Q22))","v":""},null,{"$f":"IF(S22=\"\",\"\",$P22+(R22-S22))","v":""},null,{"$f":"IF(U22=\"\",\"\",$P22+(T22-U22))","v":""},null,{"$f":"IF(W22=\"\",\"\",$P22+(V22-W22))","v":""}]
[null,"czy uwzględnić tu refakturę zimową?","SUMA",{"$f":"SUM(D19:D22)","v":0}]
[null,null,null,null,null,"sprawdzić by tobyły budżety miesięczne!"]
[]
[null,"Odzież robocza",null,{"$f":"(POZOSTAŁE!I6*COUNTA(G26,I26,K26,M26,O26,Q26,S26,U26,W26,Y26,AA26,AC26)-SUM(G26,I26,K26,M26,O26,Q26,S26,U26,W26,Y26,AA26,AC26))","v":-900},null,{"$f":"POZOSTAŁE!$I$6","v":0},200,{"$f":"IF(G26=\"\",\"\",$F26+(F26-G26))","v":-200},700,{"$f":"IF(I26=\"\",\"\",$F26+(H26-I26))","v":-900},null,{"$f":"IF(K26=\"\",\"\",$F26+(J26-K26))","v":""},null,{"$f":"IF(M26=\"\",\"\",$F26+(L26-M26))","v":""},null,{"$f":"IF(O26=\"\",\"\",$F26+(N26-O26))","v":""},null,{"$f":"IF(Q26=\"\",\"\",$F26+(P26-Q26))","v":""},null,{"$f":"IF(S26=\"\",\"\",$F26+(R26-S26))","v":""},null,{"$f":"IF(U26=\"\",\"\",$F26+(T26-U26))","v":""},null,{"$f":"IF(W26=\"\",\"\",$F26+(V26-W26))","v":""},null,{"$f":"IF(Y26=\"\",\"\",$F26+(X26-Y26))","v":""},null,{"$f":"IF(AA26=\"\",\"\",$F26+(Z26-AA26))","v":""}]
[null,"Pranie strojów roboczych",null,{"$f":"(POZOSTAŁE!I7*COUNTA(G27,I27,K27,M27,O27,Q27,S27,U27,W27,Y27,AA27,AC27)-SUM(G27,I27,K27,M27,O27,Q27,S27,U27,W27,Y27,AA27,AC27))","v":-70},null,{"$f":"POZOSTAŁE!$I$7","v":0},40,{"$f":"IF(G27=\"\",\"\",$F27+(F27-G27))","v":-40},30,{"$f":"IF(I27=\"\",\"\",$F27+(H27-I27))","v":-70},null,{"$f":"IF(K27=\"\",\"\",$F27+(J27-K27))","v":""},null,{"$f":"IF(M27=\"\",\"\",$F27+(L27-M27))","v":""},null,{"$f":"IF(O27=\"\",\"\",$F27+(N27-O27))","v":""},null,{"$f":"IF(Q27=\"\",\"\",$F27+(P27-Q27))","v":""},null,{"$f":"IF(S27=\"\",\"\",$F27+(R27-S27))","v":""},null,{"$f":"IF(U27=\"\",\"\",$F27+(T27-U27))","v":""},null,{"$f":"IF(W27=\"\",\"\",$F27+(V27-W27))","v":""},null,{"$f":"IF(Y27=\"\",\"\",$F27+(X27-Y27))","v":""},null,{"$f":"IF(AA27=\"\",\"\",$F27+(Z27-AA27))","v":""}]
[null,"Prace dodatkowe",null,{"$f":"(SUM('Karta obiektu'!$H$134:$H$142)*COUNTA(G28,I28,K28,M28,O28,Q28,S28,U28,W28,Y28,AA28,AC28)-SUM(G28,I28,K28,M28,O28,Q28,S28,U28,W28,Y28,AA28,AC28))","v":-300},null,{"$f":"SUM('Karta obiektu'!$H$134:$H$142)","v":0},200,{"$f":"IF(G28=\"\",\"\",$F28+(F28-G28))","v":-200},100,{"$f":"IF(I28=\"\",\"\",$F28+(H28-I28))","v":-300},null,{"$f":"IF(K28=\"\",\"\",$F28+(J28-K28))","v":""},null,{"$f":"IF(M28=\"\",\"\",$F28+(L28-M28))","v":""},null,{"$f":"IF(O28=\"\",\"\",$F28+(N28-O28))","v":""},null,{"$f":"IF(Q28=\"\",\"\",$F28+(P28-Q28))","v":""},null,{"$f":"IF(S28=\"\",\"\",$F28+(R28-S28))","v":""},null,{"$f":"IF(U28=\"\",\"\",$F28+(T28-U28))","v":""},null,{"$f":"IF(W28=\"\",\"\",$F28+(V28-W28))","v":""},null,{"$f":"IF(Y28=\"\",\"\",$F28+(X28-Y28))","v":""},null,{"$f":"IF(AA28=\"\",\"\",$F28+(Z28-AA28))","v":""}]
[null,null,"SUMA",{"$f":"SUM(D26:D28)","v":-1270}]
[]
[null,"PRACOWNICY"]
[null,{"$f":"'Pracownicy podsuma'!B4","v":"Umowa o pracę - stawka 15,00 zł"},"wynagrodzenie",{"$f":"(VLOOKUP(B32,'Pracownicy podsuma'!B:D,3,0)*COUNTA(G32,I32,K32,M32,O32,Q32,S32,U32,W32,Y32,AA32,AC32)-SUM(G32,I32,K32,M32,O32,Q32,S32,U32,W32,Y32,AA32,AC32))","v":36.546111999999994},null,{"$f":"VLOOKUP(B32,'Pracownicy podsuma'!B:D,3,0)","v":4018.273056},4200,{"$f":"IF(G32=\"\",\"\",$F32+(F32-G32))","v":3836.546112},3800,{"$f":"IF(I32=\"\",\"\",$F32+(H32-I32))","v":4054.819168},null,{"$f":"IF(K32=\"\",\"\",$F32+(J32-K32))","v":""},null,{"$f":"IF(M32=\"\",\"\",$F32+(L32-M32))","v":""},null,{"$f":"IF(O32=\"\",\"\",$F32+(N32-O32))","v":""},null,{"$f":"IF(Q32=\"\",\"\",$F32+(P32-Q32))","v":""},null,{"$f":"IF(S32=\"\",\"\",$F32+(R32-S32))","v":""},null,{"$f":"IF(U32=\"\",\"\",$F32+(T32-U32))","v":""},null,{"$f":"IF(W32=\"\",\"\",$F32+(V32-W32))","v":""},null,{"$f":"IF(Y32=\"\",\"\",$F32+(X32-Y32))","v":""},null,{"$f":"IF(AA32=\"\",\"\",$F32+(Z32-AA32))","v":""}]
[null,null,"ilość roboczogodzin",{"$f":"(VLOOKUP(B32,'Pracownicy podsuma'!B:D,2,0)*COUNTA(G33,I33,K33,M33,O33,Q33,S33,U33,W33,Y33,AA33,AC33)-SUM(G33,I33,K33,M33,O33,Q33,S33,U33,W33,Y33,AA33,AC33))","v":2},null,{"$f":"VLOOKUP(B32,'Pracownicy podsuma'!B:D,2,0)","v":168},167,{"$f":"IF(G33=\"\",\"\",$F33+(F33-G33))","v":169},167,{"$f":"IF(I33=\"\",\"\",$F33+(H33-I33))","v":170},null,{"$f":"IF(K33=\"\",\"\",$F33+(J33-K33))","v":""},null,{"$f":"IF(M33=\"\",\"\",$F33+(L33-M33))","v":""},null,{"$f":"IF(O33=\"\",\"\",$F33+(N33-O33))","v":""},null,{"$f":"IF(Q33=\"\",\"\",$F33+(P33-Q33))","v":""},null,{"$f":"IF(S33=\"\",\"\",$F33+(R33-S33))","v":""},null,{"$f":"IF(U33=\"\",\"\",$F33+(T33-U33))","v":""},null,{"$f":"IF(W33=\"\",\"\",$F33+(V33-W33))","v":""},null,{"$f":"IF(Y33=\"\",\"\",$F33+(X33-Y33))","v":""},null,{"$f":"IF(AA33=\"\",\"\",$F33+(Z33-AA33))","v":""}]
[null,{"$f":"'Pracownicy podsuma'!B5","v":"Umowa zlecenie - stawka 13,50 zł"},"wynagrodzenie",{"$f":"(VLOOKUP(B34,'Pracownicy podsuma'!B:D,3,0)*COUNTA(G34,I34,K34,M34,O34,Q34,S34,U34,W34,Y34,AA34,AC34)-SUM(G34,I34,K34,M34,O34,Q34,S34,U34,W34,Y34,AA34,AC34))","v":449.33725120000054},null,{"$f":"VLOOKUP(B34,'Pracownicy podsuma'!B:D,3,0)","v":5424.6686256000003},5500,{"$f":"IF(G34=\"\",\"\",$F34+(F34-G34))","v":5349.3372512000005},4900,{"$f":"IF(I34=\"\",\"\",$F34+(H34-I34))","v":5874.0058768000008},null,{"$f":"IF(K34=\"\",\"\",$F34+(J34-K34))","v":""},null,{"$f":"IF(M34=\"\",\"\",$F34+(L34-M34))","v":""},null,{"$f":"IF(O34=\"\",\"\",$F34+(N34-O34))","v":""},null,{"$f":"IF(Q34=\"\",\"\",$F34+(P34-Q34))","v":""},null,{"$f":"IF(S34=\"\",\"\",$F34+(R34-S34))","v":""},null,{"$f":"IF(U34=\"\",\"\",$F34+(T34-U34))","v":""},null,{"$f":"IF(W34=\"\",\"\",$F34+(V34-W34))","v":""},null,{"$f":"IF(Y34=\"\",\"\",$F34+(X34-Y34))","v":""},null,{"$f":"IF(AA34=\"\",\"\",$F34+(Z34-AA34))","v":""}]
[null,null,"ilość roboczogodzin",{"$f":"(VLOOKUP(B34,'Pracownicy podsuma'!B:D,2,0)*COUNTA(G35,I35,K35,M35,O35,Q35,S35,U35,W35,Y35,AA35,AC35)-SUM(G35,I35,K35,M35,O35,Q35,S35,U35,W35,Y35,AA35,AC35))","v":5},null,{"$f":"VLOOKUP(B34,'Pracownicy podsuma'!B:D,2,0)","v":252},250,{"$f":"IF(G35=\"\",\"\",$F35+(F35-G35))","v":254},249,{"$f":"IF(I35=\"\",\"\",$F35+(H35-I35))","v":257},null,{"$f":"IF(K35=\"\",\"\",$F35+(J35-K35))","v":""},null,{"$f":"IF(M35=\"\",\"\",$F35+(L35-M35))","v":""},null,{"$f":"IF(O35=\"\",\"\",$F35+(N35-O35))","v":""},null,{"$f":"IF(Q35=\"\",\"\",$F35+(P35-Q35))","v":""},null,{"$f":"IF(S35=\"\",\"\",$F35+(R35-S35))","v":""},null,{"$f":"IF(U35=\"\",\"\",$F35+(T35-U35))","v":""},null,{"$f":"IF(W35=\"\",\"\",$F35+(V35-W35))","v":""},null,{"$f":"IF(Y35=\"\",\"\",$F35+(X35-Y35))","v":""},null,{"$f":"IF(AA35=\"\",\"\",$F35+(Z35-AA35))","v":""}]
[null,null,"wynagrodzenie"]
[null,null,"ilość roboczogodzin"]
[null,null,"wynagrodzenie"]
[null,null,"ilość roboczogodzin"]
[null,null,"wynagrodzenie"]
[null,null,"ilość roboczogodzin"]
[]
[null,"Główny kierownik obiektu - przyjezdny","wynagrodzenie",{"$f":"(PRACOWNICY!Y28*COUNTA(G43,I43,K43,M43,O43,Q43,S43,U43,W43,Y43,AA43,AC43)-SUM(G43,I43,K43,M43,O43,Q43,S43,U43,W43,Y43,AA43,AC43))","v":-3.7555624399998919},null,{"$f":"PRACOWNICY!$Y$28","v":233.12221878000005},280,{"$f":"IF(G43=\"\",\"\",$F43+(F43-G43))","v":186.24443756000011},190,{"$f":"IF(I43=\"\",\"\",$F43+(H43-I43))","v":229.36665634000016},null,{"$f":"IF(K43=\"\",\"\",$F43+(J43-K43))","v":""},null,{"$f":"IF(M43=\"\",\"\",$F43+(L43-M43))","v":""},null,{"$f":"IF(O43=\"\",\"\",$F43+(N43-O43))","v":""},null,{"$f":"IF(Q43=\"\",\"\",$F43+(P43-Q43))","v":""},null,{"$f":"IF(S43=\"\",\"\",$F43+(R43-S43))","v":""},null,{"$f":"IF(U43=\"\",\"\",$F43+(T43-U43))","v":""},null,{"$f":"IF(W43=\"\",\"\",$F43+(V43-W43))","v":""},null,{"$f":"IF(Y43=\"\",\"\",$F43+(X43-Y43))","v":""},null,{"$f":"IF(AA43=\"\",\"\",$F43+(Z43-AA43))","v":""}]
[null,null,"ilość roboczogodzin",{"$f":"(PRACOWNICY!O28*COUNTA(G44,I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44)-SUM(G44,I44,K44,M44,O44,Q44,S44,U44,W44,Y44,AA44,AC44))","v":-6.5833333333333339},null,{"$f":"PRACOWNICY!$O$28","v":4.208333333333333},8,{"$f":"IF(G44=\"\",\"\",$F44+(F44-G44))","v":0.41666666666666607},7,{"$f":"IF(I44=\"\",\"\",$F44+(H44-I44))","v":-2.3750000000000009},null,{"$f":"IF(K44=\"\",\"\",$F44+(J44-K44))","v":""},null,{"$f":"IF(M44=\"\",\"\",$F44+(L44-M44))","v":""},null,{"$f":"IF(O44=\"\",\"\",$F44+(N44-O44))","v":""},null,{"$f":"IF(Q44=\"\",\"\",$F44+(P44-Q44))","v":""},null,{"$f":"IF(S44=\"\",\"\",$F44+(R44-S44))","v":""},null,{"$f":"IF(U44=\"\",\"\",$F44+(T44-U44))","v":""},null,{"$f":"IF(W44=\"\",\"\",$F44+(V44-W44))","v":""},null,{"$f":"IF(Y44=\"\",\"\",$F44+(X44-Y44))","v":""},null,{"$f":"IF(AA44=\"\",\"\",$F44+(Z44-AA44))","v":""}]
[]
[null,"Inne dodatki dla pracowników / dojazdy","wynagrodzenie",{"$f":"(PRACOWNICY!J32*COUNTA(G46,I46,K46,M46,O46,Q46,S46,U46,W46,Y46,AA46,AC46)-SUM(G46,I46,K46,M46,O46,Q46,S46,U46,W46,Y46,AA46,AC46))","v":{"$error":"#VALUE!"}},null,{"$f":"PRACOWNICY!$J$32","v":""},3300,{"$f":"IF(G46=\"\",\"\",$F46+(F46-G46))","v":{"$error":"#VALUE!"}},3350,{"$f":"IF(I46=\"\",\"\",$F46+(H46-I46))","v":{"$error":"#VALUE!"}},null,{"$f":"IF(K46=\"\",\"\",$F46+(J46-K46))","v":""},null,{"$f":"IF(M46=\"\",\"\",$F46+(L46-M46))","v":""},null,{"$f":"IF(O46=\"\",\"\",$F46+(N46-O46))","v":""},null,{"$f":"IF(Q46=\"\",\"\",$F46+(P46-Q46))","v":""},null,{"$f":"IF(S46=\"\",\"\",$F46+(R46-S46))","v":""},null,{"$f":"IF(U46=\"\",\"\",$F46+(T46-U46))","v":""},null,{"$f":"IF(W46=\"\",\"\",$F46+(V46-W46))","v":""},null,{"$f":"IF(Y46=\"\",\"\",$F46+(X46-Y46))","v":""},null,{"$f":"IF(AA46=\"\",\"\",$F46+(Z46-AA46))","v":""}]
[null,"Opis dodatków",null,{"$f":"PRACOWNICY!E32","v":0}]
[]
[null,null,"SUMA",{"$f":"SUM(D32,D34,D36,D38,D40,D43,D46)","v":{"$error":"#VALUE!"}}]
[]
[null,"Budżet na dojazdy koordynatorów",null,{"$f":"(POZOSTAŁE!J26*COUNTA(G51,I51,K51,M51,O51,Q51,S51,U51,W51,Y51,AA51,AC51)-SUM(G51,I51,K51,M51,O51,Q51,S51,U51,W51,Y51,AA51,AC51))","v":0},null,{"$f":"POZOSTAŁE!$J$26","v":0},null,{"$f":"IF(G51=\"\",\"\",$F51+(F51-G51))","v":""},null,{"$f":"IF(I51=\"\",\"\",$F51+(H51-I51))","v":""},null,{"$f":"IF(K51=\"\",\"\",$F51+(J51-K51))","v":""},null,{"$f":"IF(M51=\"\",\"\",$F51+(L51-M51))","v":""},null,{"$f":"IF(O51=\"\",\"\",$F51+(N51-O51))","v":""},null,{"$f":"IF(Q51=\"\",\"\",$F51+(P51-Q51))","v":""},null,{"$f":"IF(S51=\"\",\"\",$F51+(R51-S51))","v":""},null,{"$f":"IF(U51=\"\",\"\",$F51+(T51-U51))","v":""},null,{"$f":"IF(W51=\"\",\"\",$F51+(V51-W51))","v":""},null,{"$f":"IF(Y51=\"\",\"\",$F51+(X51-Y51))","v":""},null,{"$f":"IF(AA51=\"\",\"\",$F51+(Z51-AA51))","v":""}]
[]
[null,null,null,"Różnica względem budżetu narastająco"]
[null,null,null,{"$f":"SUM(D9:D15,D19:D22,D26:D28,D32,D34,D36,D38,D40,D43,D46,D51)","v":{"$error":"#VALUE!"}}]