{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kalkulator"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Kalkulator","index":0,"n_rows":47,"n_cols":27,"rows_kept":47,"merged":[[0,0,0,9],[2,1,2,4],[2,7,2,8],[2,11,2,12],[4,11,5,11],[4,12,5,12],[6,11,7,11],[6,12,7,12],[8,11,10,11],[8,12,10,12],[21,1,21,4],[27,1,27,7],[27,13,27,24],[29,1,31,2],[29,3,31,7],[29,17,29,20],[33,1,35,2],[33,3,35,7],[37,1,39,2],[37,3,39,7]]}
["Ekwiwalent za wyszkolenie"]
[]
[null,"Parametry modelu",{"$nulls":5},"Dane zawodnika",{"$nulls":3},"Ekwiwalent za wyszkolenie"]
[]
[null,null,"Kategoria","Liga","Mnożnik",null,null,"Rok urodzenia",2000,null,null," WYMIAR EKWIWALENTU",{"$f":"Y45","v":{"v":6920.55,"d":"6,920.55"}}]
[null,null,"I","ESA",6,null,null,"Data rozpoczęcia szkolenia","2018-08-03"]
[null,null,"II","I, II liga",3,null,null,"Data zakończenia szkolenia","2019-06-30",null,null,"STOPA AMORTYZACJI",{"$f":"IF(AND(AA42,AA43,AA44),E20,IF(AND(AA42,AA43),E19,IF(AA42,E18,0)))","v":{"v":0,"d":"0.00"}}]
[null,null,"III","III Liga",1,null,null,"Data rejestracji w nowym klubie","2019-07-01"]
[null,null,"IV"," IV liga, Okręgówka",{"v":0.5,"d":"0.50"},null,null,"Kat. klubu pozyskującego","II",null,null,"WYMIAR NALEŻNEGO EKWIWALENTU PO UWZGLĘDNIENIU AMORTYZACJI",{"$f":"M5*(1-M7)","v":{"v":6920.55,"d":"6,920.55"}}]
[null,null,"V","Klasa A, B, C",0,null,null,"Kat. klubu odstępującego","III"]
[]
[null,"Kategoria","Wiek od","Wiek do","Wsp. bazowy"]
[null,"I",12,14,500]
[null,"II",15,18,2000]
[null,"III",19,21,3000]
[]
[null,"Kategoria","Wiek od","Wiek do","Stopa amortyzacji"]
[null,"I",22,22,0.25]
[null,"II",23,23,0.5]
[null,"III",24,24,1,{"$nulls":4},"   "]
[]
[null,"Pola oznaczone kolorem pomarańczowym wypełnia użytkownik."]
[]
[]
[]
[]
[]
[null,"Objaśnienia",{"$nulls":11},"TABELA POMOCNICZA"]
[]
[null,"Data rozpoczęcia szkolenia",null,"Rozumiana jako dzień, w którym zawodnik został zarejestrowany w poprzednim klubie (przed zmianą przynależności klubowej na zasadzie wolnego transferu) ",{"$nulls":9},"KATEGORIA WIEKOWA","WIEK PIŁKARZA (ROCZNIKOWO)","ROZPOCZĘCIE SZKOLENIA","LICZBA DNI W DANYM ROKU ","KOLUMNY POMOCNICZE - BEZ INTERPRETACJI",{"$nulls":3},"LICZBA DNI SZKOLENIA W DANYM WIEKU (ROCZNIKOWO)","CZĘŚĆ ROKU ODPOWIADAJĄCA OKRESOWI SZKOLENIA","PODSTAWA EKWIWALENTU ZA DANY ROK","WARTOŚĆ EKWIWALENTU ZA DANY ROK (PODSTWA x MNOŻNIK)","LICZBA DNI DO MOMENTU AKTYWOWANIA KATEGORII AMORTYZACJI"]
[{"$nulls":13},"I",12,{"$f":"DATE(($I$5)+O31,MONTH(1),DAY(1))","v":"2012-01-01"},{"$f":"IFERROR(DATEDIF(P31,P32,\"D\"),0)","v":366},{"$f":"IFERROR(DATEDIF($I$6,P32,\"D\"),0)","v":0},{"$f":"IFERROR(DATEDIF($I$6,P31,\"D\"),0)","v":0},{"$f":"R31-S31","v":0},{"$f":"IFERROR(DATEDIF($I$7,P31,\"D\"),0)","v":0},{"$f":"IF((T31-U32)<0,0,T31-U32)","v":0},{"$f":"V31/Q31","v":{"v":0,"d":"0.000"}},{"$f":"W31*$E$13","v":0},{"$f":"IF(AND($I$9=\"V\",$I$10<>\"V\"),X31*VLOOKUP(\"IV\",$C$6:$E$10,3),X31*VLOOKUP($I$9,$C$6:$E$10,3))","v":0},"-"]
[{"$nulls":13},"I",13,"2013-01-01",365,0,0,0,0,0,{"v":0,"d":"0.000"},{"$f":"W32*$E$13","v":0},{"$f":"IF(AND($I$9=\"V\",$I$10<>\"V\"),X32*VLOOKUP(\"IV\",$C$6:$E$10,3),X32*VLOOKUP($I$9,$C$6:$E$10,3))","v":0},"-"]
[{"$nulls":13},"I",14,"2014-01-01",365,0,0,0,0,0,{"v":0,"d":"0.000"},{"$f":"W33*$E$13","v":0},0,"-"]
[null,"Data zakończenia szkolenia",null,"Rozumiana jako ostatni dzień, w którym zawodnik był zarejestrowany w poprzednim klubie (przed zmianą przynależności klubowej na zasadzie wolnego transferu) ",{"$nulls":9},"II",15,"2015-01-01",365,0,0,0,0,0,{"v":0,"d":"0.000"},{"$f":"W34*$E$14","v":0},0,"-"]
[{"$nulls":13},"II",16,"2016-01-01",366,0,0,0,0,0,{"v":0,"d":"0.000"},{"$f":"W35*$E$14","v":0},0,"-"]
[{"$nulls":13},"II",17,"2017-01-01",365,0,0,0,0,0,{"v":0,"d":"0.000"},{"$f":"W36*$E$14","v":0},0,"-"]
[{"$nulls":13},"II",18,"2018-01-01",365,151,0,151,0,151,{"v":0.4136986301369863,"d":"0.414"},{"$f":"W37*$E$14","v":{"v":827.3972602739726,"d":"827"}},{"v":2482.1917808219177,"d":"2482"},"-"]
[null,"Data rejestracji w nowym klubie",null,"Rozumiana jako pierwszy dzień, w którym zawodnik był zarejestrowany w nowym klubie (po zmianie przynależności klubowej na zasadzie wolnego transferu) ",{"$nulls":9},"III",19,"2019-01-01",365,516,151,365,0,180,{"v":0.4931506849315068,"d":"0.493"},{"$f":"W38*$E$15","v":{"v":1479.4520547945206,"d":"1479"}},{"v":4438.356164383562,"d":"4438"},"-"]
[{"$nulls":13},"III",20,"2020-01-01",366,882,516,366,185,0,{"v":0,"d":"0.000"},{"$f":"W39*$E$15","v":0},0,"-"]
[{"$nulls":13},"III",21,"2021-01-01",{"$f":"IFERROR(DATEDIF(P40,P42,\"D\"),0)","v":365},{"$f":"IFERROR(DATEDIF($I$6,P42,\"D\"),0)","v":1247},882,365,551,0,{"v":0,"d":"0.000"},{"$f":"W40*$E$15","v":0},0,"-"]
[{"$nulls":20},{"$f":"IFERROR(DATEDIF($I$7,P42,\"D\"),0)","v":916}]
[{"$nulls":13},"A",22,{"$f":"DATE(($I$5)+O42,MONTH(1),DAY(1))","v":"2022-01-01"},{"$f":"IFERROR(DATEDIF(P42,P43,\"D\"),0)","v":365},{"$f":"IFERROR(DATEDIF($I$6,P43,\"D\"),0)","v":1612},{"$f":"IFERROR(DATEDIF($I$6,P42,\"D\"),0)","v":1247},{"$f":"R42-S42","v":365},{"$f":"IFERROR(DATEDIF($I$8,P42,\"D\"),0)","v":915},{"$f":"IF((T42-U43)<0,0,T42-U43)","v":0},{"$f":"V42/Q42","v":0},{"$f":"W42*$E$15","v":0},{"$f":"X42*VLOOKUP($I$9,$C$6:$E$10,3,FALSE)","v":0},{"$f":"IFERROR(DATEDIF($I$8,P42,\"D\"),0)","v":915},{"$f":"Z42<=0","v":false}]
[{"$nulls":13},"A",23,{"$f":"DATE(($I$5)+O43,MONTH(1),DAY(1))","v":"2023-01-01"},{"$f":"IFERROR(DATEDIF(P43,P44,\"D\"),0)","v":365},{"$f":"IFERROR(DATEDIF($I$6,P44,\"D\"),0)","v":1977},{"$f":"IFERROR(DATEDIF($I$6,P43,\"D\"),0)","v":1612},{"$f":"R43-S43","v":365},{"$f":"IFERROR(DATEDIF($I$8,P43,\"D\"),0)","v":1280},{"$f":"IF((T43-U44)<0,0,T43-U44)","v":0},{"$f":"V43/Q43","v":0},{"$f":"W43*$E$15","v":0},{"$f":"X43*VLOOKUP($I$9,$C$6:$E$10,3,FALSE)","v":0},{"$f":"IFERROR(DATEDIF($I$8,P43,\"D\"),0)","v":1280},{"$f":"Z43<=0","v":false}]
[{"$nulls":13},"A",24,{"$f":"DATE(($I$5)+O44,MONTH(1),DAY(1))","v":"2024-01-01"},{"$f":"IFERROR(DATEDIF(P44,P45,\"D\"),0)","v":366},{"$f":"IFERROR(DATEDIF($I$6,P45,\"D\"),0)","v":2343},null,null,{"$f":"IFERROR(DATEDIF($I$8,P44,\"D\"),0)","v":1645},{"$f":"IF((T44-U45)<0,0,T44-U45)","v":0},{"$f":"V44/Q44","v":0},{"$f":"W44*$E$15","v":0},{"$f":"X44*VLOOKUP($I$9,$C$6:$E$10,3,FALSE)","v":0},{"$f":"IFERROR(DATEDIF($I$8,P44,\"D\"),0)","v":1645},false]
[{"$nulls":14},25,{"$f":"DATE(($I$5)+O45,MONTH(1),DAY(1))","v":"2025-01-01"},{"$nulls":7},{"$f":"ROUND(SUM(X31:X40),2)","v":{"v":2306.85,"d":"2307"}},{"$f":"ROUND(SUM(Y31:Y40),2)","v":{"v":6920.55,"d":"6921"}},{"$f":"ROUND(IF(AND(AA42,AA43,AA44),Y45*(1-E20),IF(AND(AA42,AA43),Y45*(1-E19),IF(AA42,Y45*(1-E18),Y45))),2)","v":{"v":6920.55,"d":"6921"}}]
[]
[{"$nulls":24},{"$f":"SUM(Y31:Y40)","v":6920.54794520548}]