{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["išlaidų ataskaita"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"išlaidų ataskaita","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]]}
["ĮMONĖS PAVADINIMAS"]
["IŠLAIDŲ ATASKAITA"]
[]
[null,"DARBUOTOJAS:","Virginija Aleknienė",{"$nulls":3},"PATVIRTINTAS:"]
[null,"SKYRIUS:","Pardavimas"]
[null,"SAVAITĖS PABAIGA:","2013-03-07",{"$nulls":3},"DATA:"]
[null,"TRANSPORTO IŠLAIDOS UŽ KIEKVIENĄ KILOMETRĄ:",{"v":0.67,"d":"0.67 Lt"}]
[]
[null,null,{"$f":"UPPER(TEXT(C10,\"dddd\"))","v":"PENKTADIENIS"},{"$f":"UPPER(TEXT(D10,\"dddd\"))","v":"ŠEŠTADIENIS"},"SEKMADIENIS","PIRMADIENIS","ANTRADIENIS","TREČIADIENIS","KETVIRTADIENIS"]
[null,"TRANSPORTAS",{"$f":"SavaitėsPabaiga-6","v":"2013-03-01"},{"$f":"SavaitėsPabaiga-5","v":"2013-03-02"},{"$f":"SavaitėsPabaiga-4","v":"2013-03-03"},{"$f":"SavaitėsPabaiga-3","v":"2013-03-04"},{"$f":"SavaitėsPabaiga-2","v":"2013-03-05"},{"$f":"SavaitėsPabaiga-1","v":"2013-03-06"},{"$f":"SavaitėsPabaiga","v":"2013-03-07"},"IŠ VISO"]
[null,"Nuvažiuotų kilometrų skaičius",{"v":145,"d":"145 "},{"$nulls":6},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":145,"d":"145 "}}]
[null,"Kompensavimas už nuvažiuotus kilometrus",{"$f":"C11*TransportoIšlaidųRodiklis","v":{"v":97.15,"d":"97.15 Lt"}},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":97.15,"d":"97.15 Lt"}}]
[null,"Automobilių statymo ir kelių mokesčiai",{"$nulls":3},{"v":17,"d":"17.00 Lt"},{"$nulls":3},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":17,"d":"17.00 Lt"}}]
[null,"Automobilio nuoma",{"v":79,"d":"79.00 Lt"},null,null,{"v":79,"d":"79.00 Lt"},{"$nulls":3},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":158,"d":"158.00 Lt"}}]
[null,"Taksi / limuzinas",{"$nulls":7},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Kita (važiavimas traukiniu arba autobusu)",{"$nulls":7},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Lėktuvo bilieto kaina",{"$nulls":3},{"v":235,"d":"235.00 Lt"},{"$nulls":3},{"$f":"SUM(Transportas[[#This Row],[1diena]:[7diena]])","v":{"v":235,"d":"235.00 Lt"}}]
[null,"IŠ VISO",{"$f":"SUBTOTAL(109,C12:C17)","v":{"v":176.15,"d":"176.15 Lt"}},{"$f":"SUBTOTAL(109,D12:D17)","v":{"v":0,"d":"0.00 Lt"}},null,{"$f":"SUBTOTAL(109,F12:F17)","v":{"v":331,"d":"331.00 Lt"}},{"$f":"SUBTOTAL(109,G12:G17)","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,H12:H17)","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,I12:I17)","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(J12:J17)","v":{"v":507.15,"d":"507.15 Lt"}}]
[]
[null,"APGYVENDINIMAS IR MAISTAS"]
[null,"Apgyvendinimas",{"v":145,"d":"145.00 Lt"},{"$nulls":6},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":145,"d":"145.00 Lt"}}]
[null,"Pusryčiai",{"v":11.49,"d":"11.49 Lt"},{"$nulls":6},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":11.49,"d":"11.49 Lt"}}]
[null,"Pietūs",{"v":12,"d":"12.00 Lt"},{"$nulls":6},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":12,"d":"12.00 Lt"}}]
[null,"Vakarienė",{"v":17,"d":"17.00 Lt"},{"$nulls":6},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":17,"d":"17.00 Lt"}}]
[null,"Užkandis",{"$f":"C24*TransportoIšlaidųRodiklis","v":{"v":11.39,"d":"11.39 Lt"}},{"$nulls":6},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":11.39,"d":"11.39 Lt"}}]
[null,"Tarpinė suma už maistą",{"$f":"SUM(C22:C24)","v":{"v":40.49,"d":"40.49 Lt"}},{"$f":"SUM(D22:D24)","v":{"v":0,"d":"0.00 Lt"}},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"$f":"SUM(ApgyvendinimasMaistas[[#This Row],[1diena]:[7diena]])","v":{"v":40.49,"d":"40.49 Lt"}}]
[null,"IŠ VISO",{"$f":"SUBTOTAL(109,C21,C26)","v":{"v":185.49,"d":"185.49 Lt"}},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":0,"d":"0.00 Lt"},{"v":185.49,"d":"185.49 Lt"}]
[]
[null,"ĮVAIRIOS IŠLAIDOS"]
[null,"Ištekliai",{"$nulls":7},{"$f":"SUM(Įvairūs[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Įranga",{"$nulls":7},{"$f":"SUM(Įvairūs[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Telefonas, faksas, internetas",{"$nulls":7},{"$f":"SUM(Įvairūs[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Kita*",{"$nulls":7},{"$f":"SUM(Įvairūs[[#This Row],[1diena]:[7diena]])","v":{"v":0,"d":"0.00 Lt"}}]
[null,"Pramogos*",{"$nulls":3},{"v":199,"d":"199.00 Lt"},{"$nulls":3},{"$f":"SUM(Įvairūs[[#This Row],[1diena]:[7diena]])","v":{"v":199,"d":"199.00 Lt"}}]
[null,"IŠ VISO",{"$f":"SUBTOTAL(109,Įvairūs[1diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[2diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[3diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[4diena])","v":{"v":199,"d":"199.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[5diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[6diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[7diena])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUBTOTAL(109,Įvairūs[iš viso])","v":{"v":199,"d":"199.00 Lt"}}]
[]
[null,"BENDROSIOS SUMOS",{"$f":"SUM(Įvairūs[[#Totals],[1diena]],ApgyvendinimasMaistas[[#Totals],[1diena]],Transportas[[#Totals],[1diena]])","v":{"v":361.64,"d":"361.64 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[2diena]],ApgyvendinimasMaistas[[#Totals],[2diena]],Transportas[[#Totals],[2diena]])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[3diena]],ApgyvendinimasMaistas[[#Totals],[3diena]],Transportas[[#Totals],[3diena]])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[4diena]],ApgyvendinimasMaistas[[#Totals],[4diena]],Transportas[[#Totals],[4diena]])","v":{"v":530,"d":"530.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[5diena]],ApgyvendinimasMaistas[[#Totals],[5diena]],Transportas[[#Totals],[5diena]])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[6diena]],ApgyvendinimasMaistas[[#Totals],[6diena]],Transportas[[#Totals],[6diena]])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[7diena]],ApgyvendinimasMaistas[[#Totals],[7diena]],Transportas[[#Totals],[7diena]])","v":{"v":0,"d":"0.00 Lt"}},{"$f":"SUM(Įvairūs[[#Totals],[iš viso]],ApgyvendinimasMaistas[[#Totals],[iš viso]],Transportas[[#Totals],[iš viso]])","v":{"v":891.64,"d":"891.64 Lt"}}]
[]
[{"$nulls":9},"BENDROJI IŠLAIDŲ SUMA"]
[null,"*Elementų „Pramogos“ ir „Kita“ nauda verslui:",{"$nulls":7},{"$f":"SUM(J18,J27,J35)","v":{"v":891.64,"d":"891.64 Lt"}}]
[{"$nulls":9},"AVANSAS"]
[]
[{"$nulls":9},"BENDROJI KOMPENSUOJAMA SUMA"]
[{"$nulls":9},{"$f":"J40-J42","v":{"v":891.64,"d":"891.64 Lt"}}]
[{"$nulls":9},"Prašome pridėti visus kvitus."]