{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Raport z wydatków"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Raport z wydatków","index":0,"n_rows":45,"n_cols":10,"rows_kept":45,"merged":[[18,1,18,9],[27,1,27,9],[35,1,35,9],[40,1,43,4]]}
["NAZWA FIRMY"]
["RAPORT Z WYDATKÓW"]
[]
[null,"PRACOWNIK:","Tomasz Bator",{"$nulls":3},"Z UPOWAŻNIENIA:"]
[null,"DZIAŁ:","Sprzedaż"]
[null,"KONIEC TYGODNIA:","2013-03-07",{"$nulls":3},"DATA:"]
[null,"STAWKA ZA KILOMETR:",{"v":0.67,"d":"0.67 zł"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"PIĄTEK"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"SOBOTA"},"NIEDZIELA","PONIEDZIAŁEK","WTOREK","ŚRODA","CZWARTEK"]
[null,"TRANSPORT",{"$f":"Koniec_tygodnia-6","v":"2013-03-01"},{"$f":"Koniec_tygodnia-5","v":"2013-03-02"},{"$f":"Koniec_tygodnia-4","v":"2013-03-03"},{"$f":"Koniec_tygodnia-3","v":"2013-03-04"},{"$f":"Koniec_tygodnia-2","v":"2013-03-05"},{"$f":"Koniec_tygodnia-1","v":"2013-03-06"},{"$f":"Koniec_tygodnia","v":"2013-03-07"},"SUMA"]
[null,"Przebyte kilometry",145,{"$nulls":6},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":145}]
[null,"Zwrot wydatków za przebyte kilometry",{"$f":"C11*StawkaZaKm","v":{"v":97.15,"d":"97.15 zł"}},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":97.15,"d":"97.15 zł"}}]
[null,"Parkowanie i opłaty za przejazdy",{"$nulls":3},{"v":17,"d":"17.00 zł"},{"$nulls":3},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":17,"d":"17.00 zł"}}]
[null,"Wypożyczanie samochodów",{"v":79,"d":"79.00 zł"},null,null,{"v":79,"d":"79.00 zł"},{"$nulls":3},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":158,"d":"158.00 zł"}}]
[null,"Taksówki/limuzyny",{"$nulls":7},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Inne (kolej lub autobus)",{"$nulls":7},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Bilety lotnicze",{"$nulls":3},{"v":235,"d":"235.00 zł"},{"$nulls":3},{"$f":"SUM(transport[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":235,"d":"235.00 zł"}}]
[null,"SUMA",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"176.15 zł"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"0.00 zł"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":"331.00 zł"}},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"507.15 zł"}}]
[]
[null,"ZAKWATEROWANIE I POSIŁKI"]
[null,"Zakwaterowanie",{"v":145,"d":"145.00 zł"},{"$nulls":6},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":145,"d":"145.00 zł"}}]
[null,"Śniadanie",{"v":11.49,"d":"11.49 zł"},{"$nulls":6},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":11.49,"d":"11.49 zł"}}]
[null,"Obiad",{"v":12,"d":"12.00 zł"},{"$nulls":6},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":12,"d":"12.00 zł"}}]
[null,"Kolacja",{"v":17,"d":"17.00 zł"},{"$nulls":6},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":17,"d":"17.00 zł"}}]
[null,"Przekąski",{"$f":"C24*StawkaZaKm","v":{"v":11.39,"d":"11.39 zł"}},{"$nulls":6},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":11.39,"d":"11.39 zł"}}]
[null,"Posiłki — suma częściowa",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"40.49 zł"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"0.00 zł"}},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"$f":"SUM(Zakwaterowanie_posiłki[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":40.49,"d":"40.49 zł"}}]
[null,"SUMA",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"185.49 zł"}},{"$f":"SUBTOTAL(109,D21,D26)","v":{"v":0,"d":"0.00 zł"}},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"v":0,"d":"0.00 zł"},{"$f":"SUBTOTAL(109,J21,J26)","v":{"v":185.49,"d":"185.49 zł"}}]
[]
[null,"RÓŻNE"]
[null,"Materiały",{"$nulls":7},{"$f":"SUM(Różne[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Wyposażenie",{"$nulls":7},{"$f":"SUM(Różne[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Telefon, faks, Internet",{"$nulls":7},{"$f":"SUM(Różne[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Inne*",{"$nulls":7},{"$f":"SUM(Różne[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}}]
[null,"Rozrywka*",{"$nulls":3},{"v":199,"d":"199.00 zł"},{"$nulls":3},{"$f":"SUM(Różne[[#This Row],[Dzień 1]:[Dzień 7]])","v":{"v":199,"d":"199.00 zł"}}]
[null,"SUMA",{"$f":"SUBTOTAL(109,Różne[Dzień 1])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 2])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 3])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 4])","v":{"v":199,"d":"199.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 5])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 6])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Dzień 7])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUBTOTAL(109,Różne[Suma])","v":{"v":199,"d":"199.00 zł"}}]
[]
[null,"SUMY KOŃCOWE",{"$f":"SUM(Różne[[#Totals],[Dzień 1]],Zakwaterowanie_posiłki[[#Totals],[Dzień 1]],transport[[#Totals],[Dzień 1]])","v":{"v":361.64,"d":"361.64 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 2]],Zakwaterowanie_posiłki[[#Totals],[Dzień 2]],transport[[#Totals],[Dzień 2]])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 3]],Zakwaterowanie_posiłki[[#Totals],[Dzień 3]],transport[[#Totals],[Dzień 3]])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 4]],Zakwaterowanie_posiłki[[#Totals],[Dzień 4]],transport[[#Totals],[Dzień 4]])","v":{"v":530,"d":"530.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 5]],Zakwaterowanie_posiłki[[#Totals],[Dzień 5]],transport[[#Totals],[Dzień 5]])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 6]],Zakwaterowanie_posiłki[[#Totals],[Dzień 6]],transport[[#Totals],[Dzień 6]])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Dzień 7]],Zakwaterowanie_posiłki[[#Totals],[Dzień 7]],transport[[#Totals],[Dzień 7]])","v":{"v":0,"d":"0.00 zł"}},{"$f":"SUM(Różne[[#Totals],[Suma]],Zakwaterowanie_posiłki[[#Totals],[Suma]],transport[[#Totals],[Suma]])","v":{"v":891.64,"d":"891.64 zł"}}]
[]
[{"$nulls":9},"WYDATKI RAZEM"]
[null,"*Cel biznesowy dla pozycji „Rozrywka” i „Inne”:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"891.64 zł"}}]
[{"$nulls":9},"ZALICZKI"]
[]
[{"$nulls":9},"ŁĄCZNY ZWROT WYDATKÓW"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"891.64 zł"}}]
[{"$nulls":9},"Proszę dołączyć wszystkie rachunki."]