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

{"sheet":"Išlaidų ataskaita","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"merged":[[3,2,3,3],[3,5,3,6],[3,9,3,10],[4,2,4,3],[4,5,4,6],[4,9,4,10],[5,2,5,3],[5,5,5,6],[5,9,5,10],[6,2,6,3],[6,5,6,6],[6,9,6,10],[7,9,7,10]]}
[null,"IŠLAIDŲ ATASKAITA"]
[null,"CONTOSO, LTD"]
[null,"123 South Main Street, North Buffalo, NY 12345"]
[null,"TELEFONAS",4255550121,null,"VARDAS","Kotryna Butkienė",null,null,"PASKIRTIS","Metinio pardavimo seminaras",null,"KILOMETRO TARIFAS",{"v":1,"d":"1.00 EUR/ml"}]
[null,"FAKSAS",4255550122,null,"SKYRIUS","Pardavimas",null,null,"PRADŽIA",{"$f":"IFERROR(MIN(Išlaidos[DATA]),\"\")","v":"2018-06-04"},null,"MAITINIMO TARIFAS",{"v":60,"d":"60.00 EUR/dieną"}]
[null,"EL. PAŠTAS","info@contoso.com",null,"PAREIGOS","Generalinis direktorius",null,null,"PABAIGA",{"$f":"IFERROR(MAX(Išlaidos[DATA]),\"\")","v":"2018-07-04"},null,"VIEŠBUČIO TARIFAS",{"v":400,"d":"400.00 EUR/naktį"}]
[null,"SVETAINĖ","www.contoso.com",null,"VADOVAS","Mikas Giedraitis",null,null,"PARENGĖ:","Kotryna Butkienė",null,"TELEFONO TARIFAS",{"v":20,"d":"20.00 EUR/dieną"}]
[{"$nulls":8},"PATVIRTINO:","Mikas Giedraitis",null,"ĮVAIRIOS IŠLAIDOS TARIFAS",{"v":100,"d":"100.00 EUR/dieną"}]
[]
[null,"DATA","SĄSKAITA","APRAŠAS","VIEŠBUTIS","TRANSPORTAS","MAITINIMAS","TELEFONAS","ĮVAIRIOS IŠLAIDOS","RIDA \nPRADŽIA","RIDA \nPABAIGA","KILOMETRAŽAS \nIŠ VISO","IŠ VISO "]
[null,{"$f":"TODAY()","v":"2018-06-04"},"Pardavimas","Kilometražas",{"$nulls":4},{"v":100,"d":"100.00 EUR"},{"v":11378.5,"d":"11,378.5 ml"},{"v":11456.2,"d":"11,456.2 ml"},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":{"v":77.70000000000073,"d":"77.70 EUR"}},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":{"v":177.70000000000073,"d":"177.70 EUR"}}]
[null,{"$f":"TODAY()+30","v":"2018-07-04"},"Pardavimas","Konvencija",{"v":890,"d":"890.00 EUR"},{"v":450,"d":"450.00 EUR"},{"v":40,"d":"40.00 EUR"},null,{"v":10,"d":"10.00 EUR"},{"v":11500,"d":"11,500.0 ml"},{"v":11560,"d":"11,560.0 ml"},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":{"v":60,"d":"60.00 EUR"}},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":{"v":1450,"d":"1,450.00 EUR"}}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[{"$nulls":11},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[RIDA \nPRADŽIA]:[RIDA \nPABAIGA]])=2,(Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*KilometroTarifas,\"\")","v":""},{"$f":"IF(COUNTA(Išlaidos[[#This Row],[DATA]:[RIDA \nPABAIGA]])=0,\"\",SUM(Išlaidos[[#This Row],[VIEŠBUTIS]:[TRANSPORTAS]],Išlaidos[[#This Row],[MAITINIMAS]:[ĮVAIRIOS IŠLAIDOS]],((Išlaidos[[#This Row],[RIDA \nPABAIGA]]-Išlaidos[[#This Row],[RIDA \nPRADŽIA]])*(KilometroTarifas))))","v":""}]
[null,"BENDROSIOS SUMOS",null,null,{"$f":"SUBTOTAL(109,Išlaidos[VIEŠBUTIS])","v":{"v":890,"d":"890.00 EUR"}},{"$f":"SUBTOTAL(109,Išlaidos[TRANSPORTAS])","v":{"v":450,"d":"450.00 EUR"}},{"$f":"SUBTOTAL(109,Išlaidos[MAITINIMAS])","v":{"v":40,"d":"40.00 EUR"}},{"$f":"SUBTOTAL(109,Išlaidos[TELEFONAS])","v":0},{"$f":"SUBTOTAL(109,Išlaidos[ĮVAIRIOS IŠLAIDOS])","v":{"v":110,"d":"110.00 EUR"}},{"$nulls":3},{"$f":"SUBTOTAL(109,Išlaidos[[IŠ VISO ]])","v":{"v":1627.7000000000007,"d":"1,627.70 EUR"}}]
[{"$nulls":11},"AVANSAI",{"v":0,"d":"0.00 EUR"}]
[{"$nulls":11},"IŠ VISO",{"$f":"Išlaidos[[#Totals],[IŠ VISO ]]-Avansai","v":{"v":1627.7000000000007,"d":"1,627.70 EUR"}}]