{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Naudas plūsmas pārskats"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Naudas plūsmas pārskats","index":0,"n_rows":50,"n_cols":18,"rows_kept":50,"merged":[[14,1,14,18],[39,1,39,18]]}
[null,"Naudas plūsma Pārskats"]
[]
[null,"Finanšu gada sākums:",null,"Pirms sākuma/sākums",{"$f":"UPPER(TEXT(FinanšuGadaSākumaDatums,\"mmm\"))","v":"JAN"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,1),\"mmm\"))","v":"FEB"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,2),\"mmm\"))","v":"MAR"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,3),\"mmm\"))","v":"APR"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,4),\"mmm\"))","v":"MAI"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,5),\"mmm\"))","v":"JŪN"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,6),\"mmm\"))","v":"JŪL"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,7),\"mmm\"))","v":"AUG"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,8),\"mmm\"))","v":"SEP"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,9),\"mmm\"))","v":"OKT"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,10),\"mmm\"))","v":"NOV"},{"$f":"UPPER(TEXT(EOMONTH(FinanšuGadaSākumaDatums,11),\"mmm\"))","v":"DEC"},null,"Kopā"]
[null,"2012-01-05",null,"APR.",{"$f":"FinanšuGadaSākumaDatums","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(FinanšuGadaSākumaDatums)","v":"2012-12-05"},null,"Apr. pozīcija"]
[]
[null,"Kases apgrozāmie līdzekļi (mēneša sākumā)",null,100,{"$f":"D50","v":100},-125,45,-1,224,269,269,269,269,269,269,269,null,{"$f":"P6","v":269}]
[]
[null,"Naudas ieņēmumi"]
[null,"Pārdošana par skaidru naudu",null,null,125,120,130,100,{"$nulls":9},{"$f":"SUM(NaudasIeņēmumi[[#This Row],[Periods 0]:[Periods 12]])","v":475}]
[null,"Ieņēmumi no kredītkontiem",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(NaudasIeņēmumi[[#This Row],[Periods 0]:[Periods 12]])","v":120}]
[null,"Aizdevumi/citi kapitāla ieguldījumi",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(NaudasIeņēmumi[[#This Row],[Periods 0]:[Periods 12]])","v":200}]
[null,"Kopā",null,{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 0])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 1])","v":175},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 2])","v":170},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 3])","v":180},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 4])","v":225},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 5])","v":45},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 6])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 7])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 8])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 9])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 10])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 11])","v":0},{"$f":"SUBTOTAL(109,NaudasIeņēmumi[Periods 12])","v":0}]
[null,"Kopējie pieejamie naudas līdzekļi (pirms skaidras naudas trūkuma)",null,{"$f":"D6+SUM(NaudasIeņēmumi[Periods 0])","v":100},{"$f":"E6+SUM(NaudasIeņēmumi[Periods 1])","v":275},{"$f":"F6+SUM(NaudasIeņēmumi[Periods 2])","v":45},{"$f":"G6+SUM(NaudasIeņēmumi[Periods 3])","v":225},{"$f":"H6+SUM(NaudasIeņēmumi[Periods 4])","v":224},{"$f":"I6+SUM(NaudasIeņēmumi[Periods 5])","v":269},{"$f":"J6+SUM(NaudasIeņēmumi[Periods 6])","v":269},{"$f":"K6+SUM(NaudasIeņēmumi[Periods 7])","v":269},{"$f":"L6+SUM(NaudasIeņēmumi[Periods 8])","v":269},{"$f":"M6+SUM(NaudasIeņēmumi[Periods 9])","v":269},{"$f":"N6+SUM(NaudasIeņēmumi[Periods 10])","v":269},{"$f":"O6+SUM(NaudasIeņēmumi[Periods 11])","v":269},{"$f":"P6+SUM(NaudasIeņēmumi[Periods 12])","v":269},null,{"$f":"R6+SUM(NaudasIeņēmumi[Total])","v":1064}]
[]
[]
[null,"Izmaksātā nauda"]
[null,"Pirkumi (tirdzniecība)",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":626}]
[null,"Pirkumi (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Pirkumi (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Bruto darba alga (precīza izņemšana)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Algu fonda izdevumi (nodokļi utt.)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Ārpakalpojumi",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Krājumi (birojs un vadīšana)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Remonts un apkope",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Reklamēšana",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Automašīnas, piegāde un ceļojumi",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Grāmatvedība un juridiskie pakalpojumi",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Īre",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Tālrunis",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Aprīkojums",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Apdrošināšana",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Nodokļi (nekustamais īpašums utt.)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Procenti",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Citi izdevumi (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Cits (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Cits (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Dažādi",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Kopā",null,{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 0])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 1])","v":400},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 2])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 3])","v":226},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 4])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 5])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 6])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 7])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 8])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 9])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 10])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 11])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 4])","v":0},null,{"$f":"SUBTOTAL(109,IzmaksātaNauda[Periods 6])","v":0}]
[]
[]
[null,"Izmaksātā nauda (bez P/Z)"]
[null,"Kredīta pamatsummas maksājums",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda2[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Kapitāla iegāde (norādīt)",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda2[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Citas sākotnējās izmaksas",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda2[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Rezerve un/vai noguldījums",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda2[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Īpašnieka izņemšana",{"$nulls":15},{"$f":"SUM(IzmaksātaNauda2[[#This Row],[Periods 0]:[Periods 12]])","v":0}]
[null,"Kopā",null,{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 0])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 1])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 2])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 3])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 4])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 5])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 1])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 2])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 3])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 4])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 5])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 6])","v":0},{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Periods 2])","v":0},null,{"$f":"SUBTOTAL(109,IzmaksātaNauda2[Total])","v":0}]
[null,"Kopējā izmaksātā nauda",null,{"$f":"SUM(IzmaksātaNauda[Periods 0],IzmaksātaNauda2[Periods 0])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 1],IzmaksātaNauda2[Periods 1])","v":400},{"$f":"SUM(IzmaksātaNauda[Periods 2],IzmaksātaNauda2[Periods 2])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 3],IzmaksātaNauda2[Periods 3])","v":226},{"$f":"SUM(IzmaksātaNauda[Periods 4],IzmaksātaNauda2[Periods 4])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 5],IzmaksātaNauda2[Periods 5])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 6],IzmaksātaNauda2[Periods 6])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 7],IzmaksātaNauda2[Periods 7])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 8],IzmaksātaNauda2[Periods 8])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 9],IzmaksātaNauda2[Periods 9])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 10],IzmaksātaNauda2[Periods 10])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 11],IzmaksātaNauda2[Periods 11])","v":0},{"$f":"SUM(IzmaksātaNauda[Periods 12],IzmaksātaNauda2[Periods 12])","v":0},null,{"$f":"SUM(IzmaksātaNauda[Total],IzmaksātaNauda2[Total])","v":626}]
[]
[null,"Kases atlikums (mēneša beigās)",null,{"$f":"D13-D48","v":100},-125,45,-1,224,269,269,269,269,269,269,269,269,null,{"$f":"R13-R48","v":438}]