{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dane umowa o pracy","Koszty umowy o prace","Ile zabiera państwo","Ile procent zabiera państwo","Pracownik brutto umowa o pracę","Arkusz3","Arkusz4","1W"],"not_rendered":{"charts":8,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":5},"unopened":[{"sheet":"Koszty umowy o prace","index":1,"reason":"not_a_worksheet"},{"sheet":"Ile zabiera państwo","index":2,"reason":"not_a_worksheet"},{"sheet":"Ile procent zabiera państwo","index":3,"reason":"not_a_worksheet"},{"sheet":"Pracownik brutto umowa o pracę","index":4,"reason":"not_a_worksheet"}],"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 umowa o pracy","index":0,"n_rows":37,"n_cols":23,"rows_kept":37,"cut":false,"hidden":false,"merged":[[23,14,23,20],[23,1,23,13]]}
[null,"Kwota brutto",5000]
["Składka","Składki pokrywane przez pracodawcę","Składki pokrywane przez pracownika","Łącznie składki"]
["Emerytalna",9.7600000000000006E-2,9.7600000000000006E-2,{"$f":"SUM(B3:C3)","v":0.19520000000000001}]
["Rentowa",6.5000000000000002E-2,1.4999999999999999E-2,0.08]
["Wypadkowa",1.7999999999999999E-2,null,1.7999999999999999E-2,null,"      "]
["Chorobowa",null,2.4500000000000001E-2,2.4500000000000001E-2]
["Zdrowotna",null,0.09,0.09]
["FP",2.4500000000000001E-2,null,2.4500000000000001E-2]
["FGŚP",1E-3,null,1E-3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Kwota Wolna",556.02]
[]
[null,"Pracownik",null,null,null,null,null,null,null,null,null,null,null,null,"Pracodawca"]
["Data","Pracownik Brutto","Pracownik Emerytalna","Pracownik  Rentowa","Pracownik Chorobowa","Pracownik razem składki ZUS","Podstawa opodatkowania (też do wyliczenia zdrowotnej)","Koszty uzyskania przychodu","Podstawa Opodatkowania","Zdrowotna","Podatek 18%","Kwota Wolna odliczenie","Pracownik podatek po odjęciu zdrowotnych","Pracownik Netto","Pracodawca Brutto","Pracodawca Emerytalna"," Pracodawca Rentowa","Pracodawca Wypadkowa","Pracodawca FP","Pracodawca FGŚP","Pracodawca całkowity koszt","Dodatkowe koszty pracodawcy","Brutto + Składki + Podatek"]
[43101,{"$f":"$C$1","v":5000},{"$f":"B26*$C$3","v":488.00000000000006},{"$f":"B26*$C$4","v":75},{"$f":"B26*$C$6","v":122.5},{"$f":"C26+D26+E26","v":685.5},{"$f":"B26-F26","v":4314.5},111.25,{"$f":"G26-H26","v":4203.25},{"$f":"G26*$C$7","v":388.30500000000001},756.58499999999992,{"$f":"K26-($M$22/12)","v":710.24999999999989},{"$f":"L26-(G26*0.0775)","v":375.87624999999991},{"$f":"G26-J26-M26","v":3550.3187500000004},{"$f":"$C$1","v":5000},{"$f":"O26*$B$3","v":488.00000000000006},{"$f":"O26*$B$4","v":325},{"$f":"O26*$B$5","v":90},{"$f":"O26*$B$8","v":122.5},{"$f":"O26*$B$9","v":5},{"$f":"O26+SUM(P26:T26)","v":6030.5},0,0]
[43132,{"$f":"$C$1","v":5000},488.00000000000006,75,122.5,{"$f":"C27+D27+E27","v":685.5},{"$f":"B27-F27","v":4314.5},111.25,{"$f":"G27-H27","v":4203.25},388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,{"$f":"$C$1","v":5000},488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43160,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,{"$f":"G28-H28","v":4203.25},388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43191,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43221,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43252,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43282,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43313,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43344,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43374,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43405,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]
[43435,5000,488.00000000000006,75,122.5,685.5,4314.5,111.25,4203.25,388.30500000000001,756.58499999999992,710.24999999999989,375.87624999999991,3550.3187500000004,5000,488.00000000000006,325,90,122.5,5,6030.5,0,0]

{"sheet":"Arkusz3","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Pole obliczeniowe"]
["Kolejność rozwiązywania","Pole","Formuła"]
[1,"Składka Emerytalna","='Pracownik Emerytalna' +'Pracodawca Emerytalna'"]
[2,"Składka Rentowa ","='Pracownik  Rentowa' +' Pracodawca Rentowa'"]
[3,"Ile zabiera Państwo","='Pracodawca FP'+'Pracodawca FGŚP'+'Pracodawca Wypadkowa'+'Składka Emerytalna'+'Składka Rentowa '+'Pracownik podatek po odjęciu zdrowotnych'+'Pracownik Chorobowa'"]
[]
["Element obliczeniowy"]
["Kolejność rozwiązywania","Element","Formuła"]
[]
[]
["Notatka:","W sytuacji, gdy komórka jest aktualizowana przez więcej niż jedną formułę,"]
[null,"wartość jest ustalona przez formułę, która jest ostatnia w kolejności rozwiązywania."]
[]
[null,"Aby zmienić kolejność rozwiązywania formuł dla wielu elementów lub pól obliczeniowych,"]
[null,"na karcie Opcje w grupie Obliczenia kliknij przycisk Pola, elementy i zestawy, a następnie kliknij polecenie Kolejność rozwiązywania."]

{"sheet":"Arkusz4","index":6,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Pole obliczeniowe"]
["Kolejność rozwiązywania","Pole","Formuła"]
[1,"Składka Emerytalna","='Pracownik Emerytalna' +'Pracodawca Emerytalna'"]
[2,"Składka Rentowa ","='Pracownik  Rentowa' +' Pracodawca Rentowa'"]
[3]
[]
["Element obliczeniowy"]
["Kolejność rozwiązywania","Element","Formuła"]
[]
[]
["Notatka:","W sytuacji, gdy komórka jest aktualizowana przez więcej niż jedną formułę,"]
[null,"wartość jest ustalona przez formułę, która jest ostatnia w kolejności rozwiązywania."]
[]
[null,"Aby zmienić kolejność rozwiązywania formuł dla wielu elementów lub pól obliczeniowych,"]
[null,"na karcie Opcje w grupie Obliczenia kliknij przycisk Pola, elementy i zestawy, a następnie kliknij polecenie Kolejność rozwiązywania."]

{"sheet":"1W","index":7,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Etykiety kolumn"]
["Wartości",43101,43132,43160,43191,43221,43252,43282,43313,43344,43374,43405,43435,"Suma końcowa"]
["Emerytalna Pracownika",9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.7600000000000006E-2,9.760000000000002E-2]
[" Rentowa Pracownik",1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
["Chorobowa Pracownik",2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2,2.4500000000000001E-2]
["Zdrowotna Pracownik",7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7661000000000008E-2,7.7660999999999994E-2]
["Wynagrodzenie netto",0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.7100637500000001,0.71006374999999988]
["Zaliczka pracownik na PIT",7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999985E-2,7.5175249999999971E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Etykiety wierszy","Koszty wynagrodzenia pracodawcy","Pracownik brutto (umowa o prace)"," Pracownik Netto (na ręke)"," Ile zabiera Państwo"]
["2018",72366,60000,42603.82499999999,29762.17500000001]
["Suma końcowa",72366,60000,42603.82499999999,29762.17500000001]
["Etykiety wierszy"," Pracodawca FP"," Zdrowotna"," Pracodawca FGŚP"," Pracodawca Wypadkowa"," Składka Emerytalna"," Składka Rentowa "," Pracownik podatek po odjęciu zdrowotnych"," Pracownik Chorobowa"," Ile pobiera Państwo"]
["2018",1470,4659.66,60,1080,11712.000000000002,4800,4510.5149999999985,1470,29762.174999999999]
["Suma końcowa",1470,4659.66,60,1080,11712.000000000002,4800,4510.5149999999985,1470,29762.174999999999]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Etykiety wierszy"," Panśtwo % w całkowitym koszcie"," Pracownik netto % w całkowitym koszcie",null,null,null,null,null,null,null,0]
["2018",0.41127290440262015,0.58872709559737979,null,null,null,null,null,null,null,0]
["Suma końcowa",0.41127290440262015,0.58872709559737979,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Etykiety wierszy"," Pracodawca FP"," Pracodawca FGŚP"," Pracodawca Wypadkowa"," Skadka emerytalna"," Zdrowotna"," Pracownik podatek po odjęciu zdrowotnych"," Pracownik Chorobowa","  Składka rentowa","Suma z Wszystkie składki"]
["2018",1470,60,1080,11712.000000000002,4659.66,4510.5149999999985,1470,4800,29762.174999999999]
["Suma końcowa",1470,60,1080,11712.000000000002,4659.66,4510.5149999999985,1470,4800,29762.174999999999]