{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Naudas plūsma","Naudas plūsmas diagramma"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Naudas plūsma","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Naudas plūsmas prognoze mazam uzņēmumam"]
[null,"Uzņēmuma nosaukums"]
[null,"Sākuma datums",{"$f":"TODAY()","v":"2019-04-24"}]
[null,"Brīdinājums par minimālu naudas atlikumu",null,{"$f":"Naudas_minimums","v":0},{"$f":"Naudas_minimums","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Sākums","Jan-18","Feb-18","Mar-18","Apr-18","Mai-18","Jūn-18","Jūl-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Kopā"]
[null,"Pieejamā nauda (mēneša sākumā)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"NAUDAS IEŅĒMUMI"," ","Jan-18","Feb-18","Mar-18","Apr-18","Mai-18","Jūn-18","Jūl-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Kopā"]
[null,"Pārdošanas ieņēmumi",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Atgrieztās preces un neapliekamie minimumi",{"$nulls":13},0]
[null,"Debitoru parādi",{"$nulls":13},0]
[null,"Procenti, citi ienākumi",{"$nulls":13},0]
[null,"Aizdevumu atmaksa",{"$nulls":13},0]
[null,"Īpašnieka ieguldījumi",{"$nulls":13},0]
[null,"NAUDAS IEŅĒMUMI KOPĀ",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,KasesIeņēmumi[Kopā])","v":0}]
[null,"Kopējā pieejamā naudas summa",{"$f":"(C7+KasesIeņēmumi[[#Totals],[ ]])","v":0},{"$f":"(D7+KasesIeņēmumi[[#Totals],[Jan-18]])","v":0},{"$f":"(E7+KasesIeņēmumi[[#Totals],[Feb-18]])","v":0},{"$f":"(F7+KasesIeņēmumi[[#Totals],[Mar-18]])","v":0},{"$f":"(G7+KasesIeņēmumi[[#Totals],[Apr-18]])","v":0},{"$f":"(H7+KasesIeņēmumi[[#Totals],[Mai-18]])","v":0},{"$f":"(I7+KasesIeņēmumi[[#Totals],[Jūn-18]])","v":0},{"$f":"(J7+KasesIeņēmumi[[#Totals],[Jūl-18]])","v":0},{"$f":"(K7+KasesIeņēmumi[[#Totals],[Aug-18]])","v":0},{"$f":"(L7+KasesIeņēmumi[[#Totals],[Sep-18]])","v":0},{"$f":"(M7+KasesIeņēmumi[[#Totals],[Okt-18]])","v":0},{"$f":"(N7+KasesIeņēmumi[[#Totals],[Nov-18]])","v":0},{"$f":"(O7+KasesIeņēmumi[[#Totals],[Dec-18]])","v":0}]
[]
[null,"VEIKTĀS IZMAKSAS"," ","Jan-18","Feb-18","Mar-18","Apr-18","Mai-18","Jūn-18","Jūl-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Kopā"]
[null,"Reklamēšana",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Komisijas un algas",{"$nulls":13},0]
[null,"Līgumdarbs",{"$nulls":13},0]
[null,"Darbinieku priekšrocību programmas",{"$nulls":13},0]
[null,"Apdrošināšana (izņemot veselības)",{"$nulls":13},0]
[null,"Procenti",{"$nulls":13},0]
[null,"Materiāli un preces (PPPI)",{"$nulls":13},0]
[null,"Maltītes un izklaide",{"$nulls":13},0]
[null,"Hipotēkas procenti",{"$nulls":13},0]
[null,"Biroja izdevumi",{"$nulls":13},0]
[null,"Citi procenti",{"$nulls":13},0]
[null,"Pensija un peļņas sadales plāns",{"$nulls":13},0]
[null,"Pirkumi tālākai pārdošanai",{"$nulls":13},0]
[null,"Īre vai noma",{"$nulls":13},0]
[null,"Īre vai noma: transportlīdzekļi, aprīkojums",{"$nulls":13},0]
[null,"Remonts un uzturēšana",{"$nulls":13},0]
[null,"Materiāli (neizteikti PPPI)",{"$nulls":13},0]
[null,"Nodokļi un licences",{"$nulls":13},0]
[null,"Ceļošana",{"$nulls":13},0]
[null,"Komunālie pakalpojumi",{"$nulls":13},0]
[null,"Darba alga (sam. darb. nodokļi)",{"$nulls":13},0]
[null,"Citi izdevumi",{"$nulls":13},0]
[null,"Citi izdevumi",{"$nulls":13},0]
[null,"Citi izdevumi",{"$nulls":13},0]
[null,"Dažādi",{"$nulls":13},0]
[null,"STARPSUMMA",null,{"$f":"SUBTOTAL(109,Izdevumi[Jan-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Feb-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Mar-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Apr-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Mai-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Jūn-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Jūl-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Aug-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Sep-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Okt-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Nov-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Dec-18])","v":0},{"$f":"SUBTOTAL(109,Izdevumi[Kopā])","v":0}]
[null,"VEIKTĀS IZMAKSAS"," ","Jan-18","Feb-18","Mar-18","Apr-18","Mai-18","Jūn-18","Jūl-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Kopā"]
[null,"Aizdevuma pamatsumma",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Kapitāla palielināšanas pirkumi",{"$nulls":13},0]
[null,"Citas sākuma izmaksas",{"$nulls":13},0]
[null,"Rezervēts un/vai uzglabāts",{"$nulls":13},0]
[null,"Īpašnieku izņemtā summa",{"$nulls":13},0]
[null,"KOPĒJĀ IZMAKSĀTĀ SUMMA",null,{"$f":"Izdevumi[[#Totals],[Jan-18]]+SUBTOTAL(109,NaudasIzmaksa[Jan-18])","v":0},{"$f":"Izdevumi[[#Totals],[Feb-18]]+SUBTOTAL(109,NaudasIzmaksa[Feb-18])","v":0},{"$f":"Izdevumi[[#Totals],[Mar-18]]+SUBTOTAL(109,NaudasIzmaksa[Mar-18])","v":0},{"$f":"Izdevumi[[#Totals],[Apr-18]]+SUBTOTAL(109,NaudasIzmaksa[Apr-18])","v":0},{"$f":"Izdevumi[[#Totals],[Mai-18]]+SUBTOTAL(109,NaudasIzmaksa[Mai-18])","v":0},{"$f":"Izdevumi[[#Totals],[Jūn-18]]+SUBTOTAL(109,NaudasIzmaksa[Jūn-18])","v":0},{"$f":"Izdevumi[[#Totals],[Jūl-18]]+SUBTOTAL(109,NaudasIzmaksa[Jūl-18])","v":0},{"$f":"Izdevumi[[#Totals],[Aug-18]]+SUBTOTAL(109,NaudasIzmaksa[Aug-18])","v":0},{"$f":"Izdevumi[[#Totals],[Sep-18]]+SUBTOTAL(109,NaudasIzmaksa[Sep-18])","v":0},{"$f":"Izdevumi[[#Totals],[Okt-18]]+SUBTOTAL(109,NaudasIzmaksa[Okt-18])","v":0},{"$f":"Izdevumi[[#Totals],[Nov-18]]+SUBTOTAL(109,NaudasIzmaksa[Nov-18])","v":0},{"$f":"Izdevumi[[#Totals],[Dec-18]]+SUBTOTAL(109,NaudasIzmaksa[Dec-18])","v":0},0]
[null,"Pieejamā nauda (mēneša beigas)",{"$f":"C17","v":0},{"$f":"D17-NaudasIzmaksa[[#Totals],[Jan-18]]","v":0},{"$f":"E17-NaudasIzmaksa[[#Totals],[Feb-18]]","v":0},{"$f":"F17-NaudasIzmaksa[[#Totals],[Mar-18]]","v":0},{"$f":"G17-NaudasIzmaksa[[#Totals],[Apr-18]]","v":0},{"$f":"H17-NaudasIzmaksa[[#Totals],[Mai-18]]","v":0},{"$f":"I17-NaudasIzmaksa[[#Totals],[Jūn-18]]","v":0},{"$f":"J17-NaudasIzmaksa[[#Totals],[Jūl-18]]","v":0},{"$f":"K17-NaudasIzmaksa[[#Totals],[Aug-18]]","v":0},{"$f":"L17-NaudasIzmaksa[[#Totals],[Sep-18]]","v":0},{"$f":"M17-NaudasIzmaksa[[#Totals],[Okt-18]]","v":0},{"$f":"N17-NaudasIzmaksa[[#Totals],[Nov-18]]","v":0},{"$f":"O17-NaudasIzmaksa[[#Totals],[Dec-18]]","v":0}]
[]
[null,"CITI DARBĪBAS DATI"," ","Jan-18","Feb-18","Mar-18","Apr-18","Mai-18","Jūn-18","Jūl-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Kopā"]
[null,"Pārdošanas apjoms (eiro)",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Debitoru parādu atlikums",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Slikto parādu atlikums",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Pieejamie krājumi",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Kreditoru parādu atlikums",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Nolietojums",{"$nulls":13},{"$f":"SUM(CitiDarbībasDati[[#This Row],[Jan-18]:[Dec-18]])","v":0}]

{"sheet":"Naudas plūsmas diagramma","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Kombinētā diagramma, kurā redzams pieejamās naudas minimuma brīdinājums un naudas plūsmas prognoze, ir šajā šūnā."]
{"$rows_empty":34}
[null,"Brīdinājums par minimālu naudas atlikumu",null,{"$f":"[0]!Naudas_minimums","v":{"v":0,"d":"0 EUR"}}]