{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Gryn. pinigų srautas per 12 mėn","Grynųjų pinigų srauto santrauka"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Gryn. pinigų srautas per 12 mėn","index":0,"n_rows":41,"n_cols":16,"rows_kept":41,"merged":[[7,0,7,15],[11,0,11,15],[17,0,17,15]]}
[]
["Grynųjų pinigų srautas per dvylika mėnesių",{"$nulls":13},"Finansinių metų pradžia:","2013-07-01"]
["Įmonės pavadinimas"]
["Adresas, miestas, valstybė, pašto kodas"]
["Telefonas, el. paštas, svetainė"]
[]
[null,"Pradžia",{"$f":"FinansiniaiMetai","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","Mėnesio\nvidurkis","Apžvalga"]
["Grynųjų pinigų suvestinė"]
["Turimi grynieji pinigai\n(mėnesio pradžioje)",{"v":55000,"d":"55,000"},{"$f":"IF(Įplaukos[[#Totals],[3stulpelis]]+Sumokėta[[#Totals],[3stulpelis]]=0,\"\",B11)","v":{"v":67593,"d":"67,593"}},{"$f":"IF(Įplaukos[[#Totals],[4stulpelis]]+Sumokėta[[#Totals],[4stulpelis]]=0,\"\",C11)","v":{"v":54265,"d":"54,265"}},{"$f":"IF(Įplaukos[[#Totals],[5stulpelis]]+Sumokėta[[#Totals],[5stulpelis]]=0,\"\",D11)","v":{"v":55739,"d":"55,739"}},{"$f":"IF(Įplaukos[[#Totals],[6stulpelis]]+Sumokėta[[#Totals],[6stulpelis]]=0,\"\",E11)","v":{"v":69290,"d":"69,290"}},{"$f":"IF(Įplaukos[[#Totals],[7stulpelis]]+Sumokėta[[#Totals],[7stulpelis]]=0,\"\",F11)","v":{"v":65618,"d":"65,618"}},{"$f":"IF(Įplaukos[[#Totals],[8stulpelis]]+Sumokėta[[#Totals],[8stulpelis]]=0,\"\",G11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[9stulpelis]]+Sumokėta[[#Totals],[9stulpelis]]=0,\"\",H11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[10stulpelis]]+Sumokėta[[#Totals],[10stulpelis]]=0,\"\",I11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[11stulpelis]]+Sumokėta[[#Totals],[11stulpelis]]=0,\"\",J11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[12stulpelis]]+Sumokėta[[#Totals],[12stulpelis]]=0,\"\",K11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[13stulpelis]]+Sumokėta[[#Totals],[13stulpelis]]=0,\"\",L11)","v":""},{"$f":"IF(Įplaukos[[#Totals],[14stulpelis]]+Sumokėta[[#Totals],[14stulpelis]]=0,\"\",M11)","v":""},{"$f":"IFERROR(AVERAGE(Suvestinė[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":62501,"d":"62,501"}}]
["Esami grynieji pinigai\n(turimi + įplaukos, prieš juos išgryninant) ",{"$f":"SUM(B9,Įplaukos[[#Totals],[2stulpelis]])","v":{"v":67593,"d":"67,593"}},{"$f":"IF(C9=\"\",\"\",SUM(C9,Įplaukos[[#Totals],[3stulpelis]]))","v":{"v":76065,"d":"76,065"}},{"$f":"IF(D9=\"\",\"\",SUM(D9,Įplaukos[[#Totals],[4stulpelis]]))","v":{"v":83301,"d":"83,301"}},{"$f":"IF(E9=\"\",\"\",SUM(E9,Įplaukos[[#Totals],[5stulpelis]]))","v":{"v":91032,"d":"91,032"}},{"$f":"IF(F9=\"\",\"\",SUM(F9,Įplaukos[[#Totals],[6stulpelis]]))","v":{"v":89662,"d":"89,662"}},{"$f":"IF(G9=\"\",\"\",SUM(G9,Įplaukos[[#Totals],[7stulpelis]]))","v":{"v":76200,"d":"76,200"}},{"$f":"IF(H9=\"\",\"\",SUM(H9,Įplaukos[[#Totals],[8stulpelis]]))","v":""},{"$f":"IF(I9=\"\",\"\",SUM(I9,Įplaukos[[#Totals],[9stulpelis]]))","v":""},{"$f":"IF(J9=\"\",\"\",SUM(J9,Įplaukos[[#Totals],[10stulpelis]]))","v":""},{"$f":"IF(K9=\"\",\"\",SUM(K9,Įplaukos[[#Totals],[11stulpelis]]))","v":""},{"$f":"IF(L9=\"\",\"\",SUM(L9,Įplaukos[[#Totals],[12stulpelis]]))","v":""},{"$f":"IF(M9=\"\",\"\",SUM(M9,Įplaukos[[#Totals],[13stulpelis]]))","v":""},{"$f":"IF(N9=\"\",\"\",SUM(N9,Įplaukos[[#Totals],[14stulpelis]]))","v":""},{"$f":"IFERROR(AVERAGE(Suvestinė[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":83252,"d":"83,252"}}]
["Pinigų srauto pozicija\n(mėnesio pabaigoje)",{"$f":"(B10-Sumokėta[[#Totals],[2stulpelis]])","v":{"v":67593,"d":"67,593"}},{"$f":"IFERROR(C10-Sumokėta[[#Totals],[3stulpelis]],\"\")","v":{"v":54265,"d":"54,265"}},{"$f":"IFERROR(D10-Sumokėta[[#Totals],[4stulpelis]],\"\")","v":{"v":55739,"d":"55,739"}},{"$f":"IFERROR(E10-Sumokėta[[#Totals],[5stulpelis]],\"\")","v":{"v":69290,"d":"69,290"}},{"$f":"IFERROR(F10-Sumokėta[[#Totals],[6stulpelis]],\"\")","v":{"v":65618,"d":"65,618"}},{"$f":"IFERROR(G10-Sumokėta[[#Totals],[7stulpelis]],\"\")","v":{"v":51413,"d":"51,413"}},{"$f":"IFERROR(H10-Sumokėta[[#Totals],[8stulpelis]],\"\")","v":""},{"$f":"IFERROR(I10-Sumokėta[[#Totals],[9stulpelis]],\"\")","v":""},{"$f":"IFERROR(J10-Sumokėta[[#Totals],[10stulpelis]],\"\")","v":""},{"$f":"IFERROR(K10-Sumokėta[[#Totals],[11stulpelis]],\"\")","v":""},{"$f":"IFERROR(L10-Sumokėta[[#Totals],[12stulpelis]],\"\")","v":""},{"$f":"IFERROR(M10-Sumokėta[[#Totals],[13stulpelis]],\"\")","v":""},{"$f":"IFERROR(N10-Sumokėta[[#Totals],[14stulpelis]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(Suvestinė[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":59265,"d":"59,265"}}]
[]
["Piniginės įplaukos"]
["Grynųjų pinigų pardavimas",{"v":5616,"d":"5,616"},{"v":3889,"d":"3,889"},{"v":24411,"d":"24,411"},{"v":31642,"d":"31,642"},{"v":14647,"d":"14,647"},{"v":3034,"d":"3,034"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Įplaukos[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":15524.6,"d":"15,525"}}]
["Pinigų gavimas iš kreditinių sąskaitų",{"v":4498,"d":"4,498"},{"v":3493,"d":"3,493"},{"v":1987,"d":"1,987"},{"v":1029,"d":"1,029"},{"v":2911,"d":"2,911"},{"v":4234,"d":"4,234"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Įplaukos[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":2730.8,"d":"2,731"}}]
["Paskola / kiti grynieji pinigai",{"v":2479,"d":"2,479"},{"v":1090,"d":"1,090"},{"v":2638,"d":"2,638"},{"v":2622,"d":"2,622"},{"v":2814,"d":"2,814"},{"v":3314,"d":"3,314"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Įplaukos[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":2495.6,"d":"2,496"}}]
["Bendroji piniginių įplaukų suma",{"$f":"SUBTOTAL(109,Įplaukos[2stulpelis])","v":{"v":12593,"d":"12,593"}},{"$f":"SUBTOTAL(109,Įplaukos[3stulpelis])","v":{"v":8472,"d":"8,472"}},{"$f":"SUBTOTAL(109,Įplaukos[4stulpelis])","v":{"v":29036,"d":"29,036"}},{"$f":"SUBTOTAL(109,Įplaukos[5stulpelis])","v":{"v":35293,"d":"35,293"}},{"$f":"SUBTOTAL(109,Įplaukos[6stulpelis])","v":{"v":20372,"d":"20,372"}},{"$f":"SUBTOTAL(109,Įplaukos[7stulpelis])","v":{"v":10582,"d":"10,582"}},{"$f":"SUBTOTAL(109,Įplaukos[8stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[9stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[10stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[11stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[12stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[13stulpelis])","v":0},{"$f":"SUBTOTAL(109,Įplaukos[14stulpelis])","v":0},{"$f":"IFERROR(AVERAGE(Įplaukos[[#Totals],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":8646.25,"d":"8,646"}}]
[]
["Sumokėti grynieji pinigai"]
["Pirkiniai (nurodyti)",null,521,323,274,451,104,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":334.6,"d":"335"}}]
["Bruto darbo užmokesčiai (tikslus išėmimas)",null,{"v":10572,"d":"10,572"},{"v":14514,"d":"14,514"},{"v":10561,"d":"10,561"},{"v":13170,"d":"13,170"},{"v":12478,"d":"12,478"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":12259,"d":"12,259"}}]
["Priemonės (biuro ir veikl.)",null,250,428,165,{"v":1168,"d":"1,168"},345,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":471.2,"d":"471"}}]
["Remontas ir priežiūra",null,0,{"v":2200,"d":"2,200"},163,67,0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":486}]
["Reklama",null,{"v":1100,"d":"1,100"},625,{"v":1356,"d":"1,356"},0,{"v":2560,"d":"2,560"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":1128.2,"d":"1,128"}}]
["Nuoma",null,{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":3500,"d":"3,500"}}]
["Komunalinės paslaugos",null,285,318,151,134,228,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":223.2,"d":"223"}}]
["Kita (nurodyti)",null,123,234,123,234,123,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":167.4,"d":"167"}}]
["Pagrindinės paskolos sumos mokėjimas",null,{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":4000,"d":"4,000"}}]
["Kapitalo pirkimas (nurodyti)",null,679,700,679,650,679,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":677.4,"d":"677"}}]
["Kitos veiklos pradžios išlaidos",null,400,350,400,300,400,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":370}]
["Rezervas ir (arba) sąlyginis deponavimas",null,300,300,300,300,300,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":300}]
["Nuosavybės atšaukimas",null,70,70,70,70,70,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Sumokėta[[#This Row],[3stulpelis]:[14stulpelis]]),\"\")","v":70}]
["Bendroji sumokėtų grynųjų pinigų suma",null,{"$f":"SUBTOTAL(109,Sumokėta[3stulpelis])","v":{"v":21800,"d":"21,800"}},{"$f":"SUBTOTAL(109,Sumokėta[4stulpelis])","v":{"v":27562,"d":"27,562"}},{"$f":"SUBTOTAL(109,Sumokėta[5stulpelis])","v":{"v":21742,"d":"21,742"}},{"$f":"SUBTOTAL(109,Sumokėta[6stulpelis])","v":{"v":24044,"d":"24,044"}},{"$f":"SUBTOTAL(109,Sumokėta[7stulpelis])","v":{"v":24787,"d":"24,787"}},{"$f":"SUBTOTAL(109,Sumokėta[8stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[9stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[10stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[11stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[12stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[13stulpelis])","v":0},{"$f":"SUBTOTAL(109,Sumokėta[14stulpelis])","v":0},{"$f":"IFERROR(AVERAGE(Sumokėta[[#Totals],[3stulpelis]:[14stulpelis]]),\"\")","v":{"v":9994.583333333334,"d":"9,995"}}]
[]
["Esminiai veiklos duomenys (informacija apie ne grynųjų pinigų srautus)"]
["Pardavimo apimtis (doleriais)",{"v":2000,"d":"2,000"},{"v":2500,"d":"2,500"},{"v":2257,"d":"2,257"},{"v":2387,"d":"2,387"},{"v":2664,"d":"2,664"},{"v":2324,"d":"2,324"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":{"v":2355.3333333333335,"d":"2,355"}}]
["Gautinos sumos",{"v":1500,"d":"1,500"},500,886,{"v":1035,"d":"1,035"},{"v":1775,"d":"1,775"},839,{"$nulls":7},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":{"v":1089.1666666666667,"d":"1,089"}}]
["Blogos skolos (mėnesio pabaigoje)",300,200,225,269,448,359,{"$nulls":7},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":{"v":300.1666666666667,"d":"300"}}]
["Turimas inventorius (mėnesio pabaigoje)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":""}]
["Mokėtinos sumos (mėnesio pabaigoje)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":""}]
["Nusidėvėjimas",{"$nulls":13},{"$f":"IFERROR(AVERAGE(EsminiaiVeiklosDuomenys[[#This Row],[2stulpelis]:[14stulpelis]]),\"\")","v":""}]

{"sheet":"Grynųjų pinigų srauto santrauka","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"Duomenų taškai:",5]
[null,null,"(Vilkite viršuje esantį slankiklį, kad pakeistumėte diagramoje pateikiamus suminius duomenų taškus.)"]