{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instrukcija","Sakuma lapa","UIN Data","UIN","2","5.1","6.2","8","9.1.1","15","31.2","Tiesibas","Symbols"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instrukcija","index":0,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,3,2,8],[3,3,3,8]]}
[]
[null,"Apraksts:","https://exceldarbariki.mozello.lv/produkti/uin/"]
[null,"Kā ieslēgt makrosus:",null,"https://exceldarbariki.mozello.lv/produkti/instrukcijas/"]
[null,"Kā atbloķēt makrosus:",null,"https://exceldarbariki.mozello.lv/produkti/ka-atbloket-makrosus/"]
[]
[null,"Nepieciešams ieiet EDS izlādēt (aktuālas = pēdējas) UIN deklarācijas XML formātā par visu pārskata periodu (līdz 12 mēnešiem)."]

{"sheet":"Sakuma lapa","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,8,5,10],[1,7,1,9],[2,7,2,9],[3,1,3,3],[5,2,5,3]]}
[]
[null,null,null,null,null,null,null,"Decimālais atdalītais",null,null,{"$f":"MID(1/10,2,1)","v":"."}]
[null,null,null,null,null,null,null,"Tūkstošu atdalītais"]
[null,"Nolasītais periods"]
[]
[null,"Gads","RegNr.",null,"Mēnesis","DokId",null,"Uzņemums"]

{"sheet":"UIN Data","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Id","Reg.Nr.","Gads","Menesis","Ceturksnis","Rinda","UINID","Summa"]

{"sheet":"UIN","index":3,"n_rows":160,"n_cols":18,"rows_kept":160,"cut":false,"hidden":false,"merged":[[1,3,1,5],[66,3,66,17],[72,3,72,17],[94,3,94,17],[100,3,100,17],[125,3,125,17],[146,3,146,17],[27,3,27,17],[3,3,3,17],[7,4,7,17],[16,4,16,17],[22,4,22,17],[44,4,44,17]]}
[null,null,null,null,null,{"$f":"'Sakuma lapa'!I6","v":0},0,1,2,3,4,5,6,7,8,9,10,11]
[null,null,null,"Periods",null,null,{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+G1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+G1,1)),2)","v":"190001"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+H1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+H1,1)),2)","v":"190002"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+I1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+I1,1)),2)","v":"190003"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+J1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+J1,1)),2)","v":"190004"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+K1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+K1,1)),2)","v":"190005"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+L1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+L1,1)),2)","v":"190006"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+M1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+M1,1)),2)","v":"190007"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+N1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+N1,1)),2)","v":"190008"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+O1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+O1,1)),2)","v":"190009"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+P1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+P1,1)),2)","v":"190010"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+Q1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+Q1,1)),2)","v":"190011"},{"$f":"YEAR(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+R1,1))&RIGHT(0&MONTH(DATE(YEAR('Sakuma lapa'!$E$4),MONTH('Sakuma lapa'!$E$4)+R1,1)),2)","v":"190012"}]
[]
[null,null,null,"Vai nodokļu maksātājam uz 2017.gada 31.decembri ir nesadalītā peļņa, iepriekšējo gadu nodokļa zaudējumi, kuri līdz taksācijas periodam nav pārnesti, vai uzkrājumi?"]
[null,"IeprZaudejumi",null,null,null,"Jā",{"$f":"IF(ISNA(VLOOKUP(G$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B5,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B5,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""}]
[null,"IeprZaudejumi",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B6,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B6,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,"1.1. Nesadalītā peļņa uz 2017.gada 31.decembri, kuru sadales brīdī neietver ar UIN apliekamajā bāzē"]
[null,"Tab1_1PelnaNesadalita",null,null,null,"Nesadalītā peļņa uz 31.12.2017",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B9,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B9,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_1Samazina",null,null,null,"Finanšu grāmatvedībā aprēķinātie zaudējumi, kas samazina nesadalīto peļņu",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B10,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B10,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_1Korekcija",null,null,null,"Citas koriģējošas summas (norāda summu ar “+” vai “-” zīmi)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B11,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B11,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_1PelnaDividendes",null,null,null,"Peļņas daļa, kuru sadala dividendēs taksācijas periodā",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B12,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B12,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_1Paradi",null,null,null,"Debitoru parādi, kuri samazinājuši ar nodokli apliekamo bāzi",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B13,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B13,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_1Aizdevums",null,null,null,"Aizdevums, kuram piemērots pārejas noteikumu 34.punkts",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B14,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B14,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,"Peļņas daļa, kuru sadalīs turpmākajos periodos",{"$f":"IF(G9+G11-SUM(G10,G12:G14)>0,G9+G11-SUM(G10,G12:G14),0)","v":0},0,0,0,0,0,{"$f":"IF(M9+M11-SUM(M10,M12:M14)>0,M9+M11-SUM(M10,M12:M14),0)","v":0},0,0,0,0,0]
[]
[null,null,null,null,"1.2. Pirmstaksācijas periodu zaudējumi, kuri radušies līdz 2017.gada 31.decembrim un kuri aprēķināti UIN vajadzībām saskaņā ar likuma “Par UIN” 14.pantu un nav pārnesti \n         nodokļa vajadzībām"]
[null,"Tab1_2Zaudejumi",null,null,null,"Zaudējumu summa, kuru var segt no nākamo piecu pārskata gadu nodokļa bāzes",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B18,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B18,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,"Pārskata gads, kurā pārnes zaudējumus",{"$f":"LEFT(G2,4)","v":"1900"},{"$f":"LEFT(H2,4)","v":"1900"},"1900","1900","1900","1900","1900","1900","1900","1900","1900","1900"]
[null,"Tab1_2Samazinats",null,null,null,"Zaudējumu summa, kura samazina nodokļa bāzi pārskata gadā",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B20,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B20,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,"Zaudējumu summa, kura attiecināma uz nākamajiem pārskata gadiem",{"$f":"IF(G18-G20>0,G18-G20,0)","v":0},{"$f":"IF(H18-H20>0,H18-H20,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"1.3. Uzkrājumi, kuri izveidoti līdz 2017.gada 31.decembrim"]
[null,"Tab1_3Uzkrajums",null,null,null,"Bilancē uzrādītais uzkrājumu atlikums uz 31.12.2017 x 0,75",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B24,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B24,'UIN Data'!$I:$I)","v":0}]
[null,"Tab1_3Samazinats",null,null,null,"Uzkrājumu summa, par kuru samazina nodokļa bāzi taksācijas periodā",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B25,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B25,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,"Uzkrājumu summa, kas attiecināma uz nākamajiem taksācijas periodiem",{"$f":"IF(G24-G25>0,G24-G25,0)","v":0},{"$f":"IF(H24-H25>0,H24-H25,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Vai taksācijas periodā ir izmaksātas dividendes vai tām pielīdzinātas izmaksas un veidojas nosacītās dividendes?"]
[null,"IzmaksatasUnNosacitasDividendes",null,null,null,"Jā, izmaksātas dividendes vai tām pielīdzinātas izmaksas",{"$f":"IF(ISNA(VLOOKUP(G$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,G$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,H$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,I$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,J$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,K$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,L$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,M$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,N$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,O$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,P$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,Q$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B29,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B29,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,R$2&$B29,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"IzmaksatasUnNosacitasDividendes",null,null,null,"Jā, veidojas nosacītās dividendes",{"$f":"IF(ISNA(VLOOKUP(G$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,G$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,H$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,I$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,J$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,K$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,L$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,M$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,N$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,O$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,P$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,Q$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B30,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B30,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,R$2&$B30,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"IzmaksatasUnNosacitasDividendes",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B31,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B31,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""}]
[]
[null,"R01",null,null,1,"Dividendes vai dividendēm pielīdzinātas izmaksas",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B33,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B33,'UIN Data'!$I:$I)","v":0}]
[null,"R02",null,null,2,"Taksācijas periodā saņemtās dividendes, kuras apliktas ar nodokli, un ienākums, kurš saņemts no pārstāvniecības (6.panta 1.d., 15.panta 4.d., bet ne vairāk kā (1.r.))",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B34,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B34,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,3,"Ar nodokli apliekamā bāze no dividendēm ((1.r -2.r.)/0.8>=0)",{"$f":"ROUND(IF((G33-G34)/0.8>0,(G33-G34)/0.8,0),0)","v":0},{"$f":"ROUND(IF((H33-H34)/0.8>0,(H33-H34)/0.8,0),0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,4,"Nodoklis no dividendēm (3.r. x 0.2)",{"$f":"ROUND(G35*0.2,0)","v":0},{"$f":"ROUND(H35*0.2,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,5,"Nosacītās dividendes (4.panta 2.d.1.p.c)ap.; 7.pants), tai skaitā:",{"$f":"SUM(G39:G41)","v":0},{"$f":"SUM(H39:H41)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,5.0999999999999996,"no samazināta pamatkapitāla (7.p.1.d.1.p.)",{"$f":"SUMIF('5.1'!$H:$H,G$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,H$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,I$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,J$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,K$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,L$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,M$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,N$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,O$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,P$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,Q$2,'5.1'!$G:$G)","v":0},{"$f":"SUMIF('5.1'!$H:$H,R$2,'5.1'!$G:$G)","v":0}]
[null,"R05_2",null,null,5.2,"no likvidācijas (7.p.1.d.2.p.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B40,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B40,'UIN Data'!$I:$I)","v":0}]
[null,"R05_3",null,null,5.3,"ja reģistrējas par mikrouzņēmumu nodokļa maksātāju (7.p.1.d.3.p.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B41,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B41,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,6,"Nosacīti sadalītā peļņa taksācijas periodā (4.panta 2.d.2.p.), tai skaitā:",{"$f":"SUM(G44:G52,G55:G63)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"R06_1",null,null,6.1,"ar saimniecisko darbību nesaistīti izdevumi (8.pants; 4.panta 2.d.2.p.a)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B44,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B44,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,"Vai debitora  parādam  tiek veidots uzkrājums?"]
[null,"DebitoraParadaUzkrajums",null,null,null,"Jā",{"$f":"IF(ISNA(VLOOKUP(G$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B46,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B46,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""}]
[null,"DebitoraParadaUzkrajums",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B47,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B47,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""}]
[]
[null,"R06_2",null,null,6.2,"nedroši debitoru parādi (9.panta 1.d.; 4.panta 2.d.2.p.b)ap.)",{"$f":"IF(G47<>\"\",SUMIF('UIN Data'!$H:$H,G$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,G$2,'6.2'!$F:$F))","v":0},{"$f":"IF(H47<>\"\",SUMIF('UIN Data'!$H:$H,H$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,H$2,'6.2'!$F:$F))","v":0},{"$f":"IF(I47<>\"\",SUMIF('UIN Data'!$H:$H,I$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,I$2,'6.2'!$F:$F))","v":0},{"$f":"IF(J47<>\"\",SUMIF('UIN Data'!$H:$H,J$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,J$2,'6.2'!$F:$F))","v":0},{"$f":"IF(K47<>\"\",SUMIF('UIN Data'!$H:$H,K$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,K$2,'6.2'!$F:$F))","v":0},{"$f":"IF(L47<>\"\",SUMIF('UIN Data'!$H:$H,L$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,L$2,'6.2'!$F:$F))","v":0},{"$f":"IF(M47<>\"\",SUMIF('UIN Data'!$H:$H,M$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,M$2,'6.2'!$F:$F))","v":0},{"$f":"IF(N47<>\"\",SUMIF('UIN Data'!$H:$H,N$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,N$2,'6.2'!$F:$F))","v":0},{"$f":"IF(O47<>\"\",SUMIF('UIN Data'!$H:$H,O$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,O$2,'6.2'!$F:$F))","v":0},{"$f":"IF(P47<>\"\",SUMIF('UIN Data'!$H:$H,P$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,P$2,'6.2'!$F:$F))","v":0},{"$f":"IF(Q47<>\"\",SUMIF('UIN Data'!$H:$H,Q$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,Q$2,'6.2'!$F:$F))","v":0},{"$f":"IF(R47<>\"\",SUMIF('UIN Data'!$H:$H,R$2&$B49,'UIN Data'!$I:$I),SUMIF('6.2'!$G:$G,R$2,'6.2'!$F:$F))","v":0}]
[null,"R06_3",null,null,6.3,"procentu maksājumi (10.pants; 4.panta 2.d.2.p.c)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B50,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B50,'UIN Data'!$I:$I)","v":0}]
[null,"R06_4",null,null,6.4,"aizdevumi saistītām personām (11.pants; 4.panta 2.d.2.p.d)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B51,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B51,'UIN Data'!$I:$I)","v":0}]
[null,"R06_5",null,null,6.5,"darījumu vērtības starpība, kas radusies darījumos ar saistītām personām \n(4.panta 2.d.2.p.e)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B52,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B52,'UIN Data'!$I:$I)","v":0}]
[null,"R06_5_1",null,null,"6.5.1","Darījumu kopējā vērtības summa, kas pārskata gadā veikti ar saistītām personām – nerezidentiem",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B53,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B53,'UIN Data'!$I:$I)","v":0}]
[null,"R06_5_2",null,null,"6.5.2","Darījumu kopējā vērtības summa, kas pārskata gadā veikti ar saistītām personām – rezidentiem",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B54,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B54,'UIN Data'!$I:$I)","v":0}]
[null,"R06_6",null,null,6.6,"piešķirtie labumi nerezidenta darbiniekiem, kuri attiecināti \nuz patstāvīgo pārstāvniecību (4.panta 2.d.2.p.f)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B55,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B55,'UIN Data'!$I:$I)","v":0}]
[null,"R06_7",null,null,6.7,"likvidācijas kvota (4.panta 2.d.2.p.g)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B56,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B56,'UIN Data'!$I:$I)","v":0}]
[null,"R06_8",null,null,"6.8","reorganizācijas procesā nodoto aktīvu vērtība saskaņā ar likuma 18.pantu (4.panta 2.d.2.p. h)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B57,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B57,'UIN Data'!$I:$I)","v":0}]
[null,"R06_9",null,null,"6.9","aktīva vērtība, kuru nodokļa maksātājs nodod pastāvīgajai pārstāvniecībai ārvalstī (4.panta 2.d.2.p. i)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B58,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B58,'UIN Data'!$I:$I)","v":0}]
[null,"R06_10",null,null,"6.10","aktīva vērtība, kuru pastāvīgā pārstāvniecība Latvijā nodod galvenajam uzņēmumam vai citai pastāvīgajai pārstāvniecībai ārvalstī (4.panta 2.d.2.p. j)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B59,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B59,'UIN Data'!$I:$I)","v":0}]
[null,"R06_11",null,null,"6.11","hibrīdneatbilstības rezultāts saskaņā ar likuma 7.1.pantu (4.panta 2.d.2.p. k)ap.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B60,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B60,'UIN Data'!$I:$I)","v":0}]
[null,"R06_12",null,null,"6.12","peļņas daļa (aktīvu vērtības pieaugums), kas ārvalsts sabiedrībā iegūta no neīstiem darījumiem (likuma 6.1.pants)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B61,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B61,'UIN Data'!$I:$I)","v":0}]
[null,"R06_13",null,null,"6.13",{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B62&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B62&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B62,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B62,'UIN Data'!$I:$I)","v":0}]
[null,"R06_14",null,null,"6.14",{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B63&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B63&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B63,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B63,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,7,"Ar nodokli apliekamā bāze no nosacītām dividendēm un nosacīti sadalītās peļņas ((5.r.+6.r.)/0.8)",{"$f":"(G43+G38)/0.8","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Vai ārvalstīs ir samaksāts nodoklis, par kuru piemēro nodokļu atvieglojumu?"]
[null,"NodoklisArvalstis",null,null,null,"Jā",{"$f":"IF(ISNA(VLOOKUP(G$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B68,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B68,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""}]
[null,"NodoklisArvalstis",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B69,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B69,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,8,"Nodokļa atvieglojums par ārvalstīs samaksāto nodokli \n(15.panta 1.d., bet ne vairāk kā 4.r.), tai skaitā",{"$f":"IF(SUMIF('8'!$I:$I,G$2,'8'!$G:$G)>G36,G36,SUMIF('8'!$I:$I,G$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,H$2,'8'!$G:$G)>H36,H36,SUMIF('8'!$I:$I,H$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,I$2,'8'!$G:$G)>I36,I36,SUMIF('8'!$I:$I,I$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,J$2,'8'!$G:$G)>J36,J36,SUMIF('8'!$I:$I,J$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,K$2,'8'!$G:$G)>K36,K36,SUMIF('8'!$I:$I,K$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,L$2,'8'!$G:$G)>L36,L36,SUMIF('8'!$I:$I,L$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,M$2,'8'!$G:$G)>M36,M36,SUMIF('8'!$I:$I,M$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,N$2,'8'!$G:$G)>N36,N36,SUMIF('8'!$I:$I,N$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,O$2,'8'!$G:$G)>O36,O36,SUMIF('8'!$I:$I,O$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,P$2,'8'!$G:$G)>P36,P36,SUMIF('8'!$I:$I,P$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,Q$2,'8'!$G:$G)>Q36,Q36,SUMIF('8'!$I:$I,Q$2,'8'!$G:$G))","v":0},{"$f":"IF(SUMIF('8'!$I:$I,R$2,'8'!$G:$G)>R36,R36,SUMIF('8'!$I:$I,R$2,'8'!$G:$G))","v":0}]
[]
[null,null,null,"Vai pārskata gadā ir veikti ziedojumi, par kuriem piemēro nodokļu atvieglojumus?"]
[null,"IrVeiktiZiedojumi",null,null,null," Jā, ziedojumi, par kuriem piemēro atvieglojumus saistībā ar Covid-19 infekcijas izplatību seku pārvarēšanu, kas nepārsniedz 8% no iepriekšējā gada peļņas pēc nodokļiem",{"$f":"IF(ISNA(VLOOKUP(G$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B74,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B74,'UIN Data'!$I:$I)=1,\"X\",\"\"))","v":""}]
[null,"IrVeiktiZiedojumi",null,null,null,"Jā, ziedojumi, par kuriem piemēro atvieglojumus, kas nepārsniedz 5% no iepriekšējā pārskata gada peļņas pēc nodokļiem",{"$f":"IF(ISNA(VLOOKUP(G$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B75,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B75,'UIN Data'!$I:$I)=4,\"X\",\"\"))","v":""}]
[null,"IrVeiktiZiedojumi",null,null,null,"Jā, ziedojumi, par kuriem piemēro atvieglojumus, kas nepārsniedz 2% no iepriekšējā pārskata gadā kopējās darba ņēmējiem aprēķinātās bruto darba samaksas, no kuras samaksāti VSAOI",{"$f":"IF(ISNA(VLOOKUP(G$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B76,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B76,'UIN Data'!$I:$I)=2,\"X\",\"\"))","v":""}]
[null,"IrVeiktiZiedojumi",null,null,null,"Jā, ziedojumi, par kuriem piemēro nodokļa atlaidi (12.panta 1.d.3.p.) (85% no ziedotās summas, bet ne vairāk kā 30% no 4.r.)",{"$f":"IF(ISNA(VLOOKUP(G$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B77,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B77,'UIN Data'!$I:$I)=3,\"X\",\"\"))","v":""}]
[null,"IrVeiktiZiedojumi",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B78,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B78,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""}]
[null,"R09_0_4",null,null,null,"Gada laikā faktiski ziedoto līdzekļu summa, ja ziedojumiem ir piemērots uzņēmumu ienākuma nodokļa atvieglojums ziedotājiem (12.pants)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B79,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B79,'UIN Data'!$I:$I)","v":0}]
[]
[null,"R9_1",null,null,9.1,"Nodokļa atlaide par ziedojumiem (12.panta 1.d.3.p.) (85% no ziedotās summas, bet ne vairāk kā 30% no 4.r.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B81,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B81,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,"9.1.1","Informācija par ziedojumiem nerezidentiem",{"$f":"SUMIF('9.1.1'!$H:$H,G$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,H$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,I$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,J$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,K$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,L$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,M$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,N$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,O$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,P$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,Q$2,'9.1.1'!$G:$G)","v":0},{"$f":"SUMIF('9.1.1'!$H:$H,R$2,'9.1.1'!$G:$G)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(G74=\"X\",0.08,IF(OR(G75=\"X\",G77=\"=X\"),0.05,IF(G76=\"X\",0.02,0)))","v":0},{"$f":"IF(H74=\"X\",0.08,IF(OR(H75=\"X\",H77=\"=X\"),0.05,IF(H76=\"X\",0.02,0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,"9.2.1","Ziedojumi, par kuriem piemēro nodokļu atvieglojumu"]
[null,"Summa",null,null,null,"Iepriekšējā pārskata gada peļņa pēc nodokļiem \t",{"$f":"IF(G74=\"X\",SUMIF('UIN Data'!$H:$H,G$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(H74=\"X\",SUMIF('UIN Data'!$H:$H,H$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(I74=\"X\",SUMIF('UIN Data'!$H:$H,I$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(J74=\"X\",SUMIF('UIN Data'!$H:$H,J$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(K74=\"X\",SUMIF('UIN Data'!$H:$H,K$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(L74=\"X\",SUMIF('UIN Data'!$H:$H,L$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(M74=\"X\",SUMIF('UIN Data'!$H:$H,M$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(N74=\"X\",SUMIF('UIN Data'!$H:$H,N$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(O74=\"X\",SUMIF('UIN Data'!$H:$H,O$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(P74=\"X\",SUMIF('UIN Data'!$H:$H,P$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(Q74=\"X\",SUMIF('UIN Data'!$H:$H,Q$2&$B85,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(R74=\"X\",SUMIF('UIN Data'!$H:$H,R$2&$B85,'UIN Data'!$I:$I),0)","v":0}]
[null,"SummaNeiekļauj",null,null,null,"Ziedojuma summa, kuru neiekļauj nodokļa bāzē (9.2.1. 1.rinda * 8%)",{"$f":"IF(G83>0,IF(SUMIF('UIN Data'!$H:$H,G$2&$B86,'UIN Data'!$I:$I)=0,ROUND(G85*G83,0),SUMIF('UIN Data'!$H:$H,G$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(H83>0,IF(SUMIF('UIN Data'!$H:$H,H$2&$B86,'UIN Data'!$I:$I)=0,ROUND(H85*H83,0),SUMIF('UIN Data'!$H:$H,H$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(I83>0,IF(SUMIF('UIN Data'!$H:$H,I$2&$B86,'UIN Data'!$I:$I)=0,ROUND(I85*I83,0),SUMIF('UIN Data'!$H:$H,I$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(J83>0,IF(SUMIF('UIN Data'!$H:$H,J$2&$B86,'UIN Data'!$I:$I)=0,ROUND(J85*J83,0),SUMIF('UIN Data'!$H:$H,J$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(K83>0,IF(SUMIF('UIN Data'!$H:$H,K$2&$B86,'UIN Data'!$I:$I)=0,ROUND(K85*K83,0),SUMIF('UIN Data'!$H:$H,K$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(L83>0,IF(SUMIF('UIN Data'!$H:$H,L$2&$B86,'UIN Data'!$I:$I)=0,ROUND(L85*L83,0),SUMIF('UIN Data'!$H:$H,L$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(M83>0,IF(SUMIF('UIN Data'!$H:$H,M$2&$B86,'UIN Data'!$I:$I)=0,ROUND(M85*M83,0),SUMIF('UIN Data'!$H:$H,M$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(N83>0,IF(SUMIF('UIN Data'!$H:$H,N$2&$B86,'UIN Data'!$I:$I)=0,ROUND(N85*N83,0),SUMIF('UIN Data'!$H:$H,N$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(O83>0,IF(SUMIF('UIN Data'!$H:$H,O$2&$B86,'UIN Data'!$I:$I)=0,ROUND(O85*O83,0),SUMIF('UIN Data'!$H:$H,O$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(P83>0,IF(SUMIF('UIN Data'!$H:$H,P$2&$B86,'UIN Data'!$I:$I)=0,ROUND(P85*P83,0),SUMIF('UIN Data'!$H:$H,P$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(Q83>0,IF(SUMIF('UIN Data'!$H:$H,Q$2&$B86,'UIN Data'!$I:$I)=0,ROUND(Q85*Q83,0),SUMIF('UIN Data'!$H:$H,Q$2&$B86,'UIN Data'!$I:$I)),0)","v":0},{"$f":"IF(R83>0,IF(SUMIF('UIN Data'!$H:$H,R$2&$B86,'UIN Data'!$I:$I)=0,ROUND(R85*R83,0),SUMIF('UIN Data'!$H:$H,R$2&$B86,'UIN Data'!$I:$I)),0)","v":0}]
[null,"SummaIekļauj",null,null,null,"Ziedojuma summa, kuru iekļauj nodokļa bāzē – deklarācijas 6.1.rindā (aizpilda, ja faktiskais ziedojums ir bijis lielāks par šīs tabulas 4.ailes summu)",{"$f":"IF(G74=\"X\",SUMIF('UIN Data'!$H:$H,G$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(H74=\"X\",SUMIF('UIN Data'!$H:$H,H$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(I74=\"X\",SUMIF('UIN Data'!$H:$H,I$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(J74=\"X\",SUMIF('UIN Data'!$H:$H,J$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(K74=\"X\",SUMIF('UIN Data'!$H:$H,K$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(L74=\"X\",SUMIF('UIN Data'!$H:$H,L$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(M74=\"X\",SUMIF('UIN Data'!$H:$H,M$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(N74=\"X\",SUMIF('UIN Data'!$H:$H,N$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(O74=\"X\",SUMIF('UIN Data'!$H:$H,O$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(P74=\"X\",SUMIF('UIN Data'!$H:$H,P$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(Q74=\"X\",SUMIF('UIN Data'!$H:$H,Q$2&$B87,'UIN Data'!$I:$I),0)","v":0},{"$f":"IF(R74=\"X\",SUMIF('UIN Data'!$H:$H,R$2&$B87,'UIN Data'!$I:$I),0)","v":0}]
[]
[null,"R10",null,null,10,"Atlaides summa, kuru aprēķina nodokļa maksātājs, kurš turpina piemērot UIN atlaidi saskaņā ar likumu “Par nodokļu piemērošanu brīvostās un speciālajās ekonomiskajās zonās” (pārejas noteikumu 23. un 24.p., ne vairāk kā 80% no 4.r.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B89,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B89,'UIN Data'!$I:$I)","v":0}]
[null,"R11",null,null,11,"Atlaides summa, kuru aprēķina nodokļa maksātājs, kurš turpina piemērot UIN atlaidi saskaņā ar likuma “Par UIN” 17.2 pantu (kas bija spēkā līdz 31.12.2017.) (pārejas noteikumu 20.p., ne vairāk kā 4.r. )",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B90,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B90,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,12,"Pirmstaksācijas periodu zaudējumi, kuri radušies līdz 31.12.2017. (1.2.tabulas 4.aile, bet ne vairāk kā 50 % no 4.r., pārejas noteikumu 13. un 14.punkts)",{"$f":"IF(G20>ROUND(G36*0.5,0),ROUND(G36*0.5,0),G20)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,13,"Nodoklis no dividendēm pēc 8.r., 9.1.r., 10.r., 11.r. un 12.r. norādīto atvieglojumu piemērošanas ((4.r.-8.r.-9.1.r.-10.r.-11.r.-12.r.)>=0)",{"$f":"IF(G36-G71-G81-G89-G90-G91>=0,G36-G71-G81-G89-G90-G91,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,14,"Ar nodokli apliekamā bāze no 13.r. aprēķinātā nodokļa no dividendēm (13.r./0.2)",{"$f":"ROUND(G92/0.2,0)","v":0},{"$f":"ROUND(H92/0.2,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Vai taksācijas periodā ir ienākumi no tiešās līdzdalības akciju, kuru turēšanas periods pārsniedz 36 mēnešus, atsavināšanas?"]
[null,"IenakumiNoAkcijuAtsavinasanas",null,null,null,"Jā",{"$f":"IF(ISNA(VLOOKUP(G$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B96,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B96,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""}]
[null,"IenakumiNoAkcijuAtsavinasanas",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B97,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B97,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,15,"Ienākums no tiešās līdzdalības akciju atsavināšanas, ja akciju turēšanas periods atsavināšanas brīdī pārsniedz 36 mēnešus (13.panta 1.d., bet ne vairāk kā 14.r.)",{"$f":"IF(SUMIF('15'!$J:$J,G$2,'15'!$H:$H)>=G93,G93,SUMIF('15'!$J:$J,G$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,H$2,'15'!$H:$H)>=H93,H93,SUMIF('15'!$J:$J,H$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,I$2,'15'!$H:$H)>=I93,I93,SUMIF('15'!$J:$J,I$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,J$2,'15'!$H:$H)>=J93,J93,SUMIF('15'!$J:$J,J$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,K$2,'15'!$H:$H)>=K93,K93,SUMIF('15'!$J:$J,K$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,L$2,'15'!$H:$H)>=L93,L93,SUMIF('15'!$J:$J,L$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,M$2,'15'!$H:$H)>=M93,M93,SUMIF('15'!$J:$J,M$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,N$2,'15'!$H:$H)>=N93,N93,SUMIF('15'!$J:$J,N$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,O$2,'15'!$H:$H)>=O93,O93,SUMIF('15'!$J:$J,O$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,P$2,'15'!$H:$H)>=P93,P93,SUMIF('15'!$J:$J,P$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,Q$2,'15'!$H:$H)>=Q93,Q93,SUMIF('15'!$J:$J,Q$2,'15'!$H:$H))","v":0},{"$f":"IF(SUMIF('15'!$J:$J,R$2,'15'!$H:$H)>=R93,R93,SUMIF('15'!$J:$J,R$2,'15'!$H:$H))","v":0}]
[]
[null,null,null,"Vai taksācijas periodā ir samazinājusies uzkrājumu summa, ja uzkrājumi ir izveidoti 2017.gadā un pārsniedz 2016.gadā izveidoto uzkrājumu summu?"]
[null,"SamazinajusiesUzkrajumuSumma",null,null,null,"Jā",{"$f":"IF(ISNA(VLOOKUP(G$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B102,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B102,'UIN Data'!$H:$I,2,0)=TRUE,\"X\",\"\"))","v":""}]
[null,"SamazinajusiesUzkrajumuSumma",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(G$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(H$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(I$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(J$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(K$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(L$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(M$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(N$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(O$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(P$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(Q$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B103,'UIN Data'!$H:$I,2,0)),\"\",IF(VLOOKUP(R$2&$B103,'UIN Data'!$H:$I,2,0)=FALSE,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,16,"Uzkrājumu (izņemot uzkrājumus debitoru parādiem) samazinājuma summa, ja uzkrājumi izveidoti 2017.gadā un pārsniedz 2016.gadā izveidoto uzkrājumu summu (pārejas noteikumu 18.p.un 19.p., bet ne vairāk kā 14.r.)",{"$f":"IF(ROUND(G107*0.75,0)>=G93,G93,ROUND(G107*0.75,0))","v":0},{"$f":"IF(ROUND(H107*0.75,0)>=H93,H93,ROUND(H107*0.75,0))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Tab16Summa",null,null,null,"Bilancē uz 31.12.2017. uzrādītā uzkrājumu summas daļa, kas pārsniedz 2016. pārskata gada bilancē uzrādīto uzkrājumu summu",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B106,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B106,'UIN Data'!$I:$I)","v":0}]
[null,"Tab16Samazinats",null,null,null,"Uzkrājumu summa, par kuru samazina nodokļa bāzi taksācijas periodā",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B107,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B107,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,"Uzkrājumu samazinājuma summa, kas attiecināma uz nākamajiem taksācijas periodiem",{"$f":"IF(G106-G107>=0,G106-G107,0)","v":0},{"$f":"IF(H106-H107>=0,H106-H107,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,17,"Ar nodokli apliekamā bāze no dividendēm pēc 15.r. un 16.r. piemērošanas \n((14.r.-15.r.-16.r.)>=0)",{"$f":"IF(G93-G99-G105>=0,G93-G99-G105,0)","v":0},{"$f":"IF(H93-H99-H105>=0,H93-H99-H105,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R18",null,null,18,"50% no summas, kas saņemta subsīdiju veidā kā valsts atbalsts lauksaimniecībai vai ES atbalsts lauksaimniecībai un lauku attīstībai (14.pants; ne vairāk kā (17.r.+7.r.) kopsumma)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B111,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B111,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,19,"Uzkrājumu samazinājuma summa, ja uzkrājumi izveidoti līdz 31.12.2017. un samazināti ar 01.01.2018. (pārejas noteikumu 17.p.un 19.p.; 1.3.tabulas 3.ailes summa, bet ne vairāk kā (17.r.+ 7.r.))",{"$f":"IF(G25>=G65+G110,G65+G110,G25)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"R20",null,null,20,"Debitoru parādu summa, kas ir atgūta un iekļauta nodokļa bāzē pirmstaksācijas periodos (9.panta 5.d.) (ne vairāk kā (17.r.+7.r.)) vai aizdevuma summa, kas iekļauta nodokļa bāzē (11.panta 5.d.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B113,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B113,'UIN Data'!$I:$I)","v":0}]
[null,"R21",null,null,21,"Debitoru parādu summa, kas radušies līdz 31.12.2017. (pārejas noteikumu 31. un 32.p.) (75 procenti no debitora parāda summas, bet ne vairāk kā (17.r.+7.r.))",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B114,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B114,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,22,"Ar nodokli apliekamā bāze pēc 18.r., 19.r., 20.r. un 21.r. piemērošanas\n((17.r.+7.r.-18.r.-19.r.-20.r.-21.r.)≥0)",{"$f":"IF(G110+G65-G111-G112-G113-G114>=0,G110+G65-G111-G112-G113-G114,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,23,"Nodoklis no 22.r. aprēķinātās nodokļa bāzes (22.r. x 0.2)",{"$f":"ROUND(G115*0.2,0)","v":0},{"$f":"ROUND(H115*0.2,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R24",null,null,24,"Valsts kapitālsabiedrības, kuras daļas vai akcijas nedrīkst atsavināt un kura pilda ar saimniecisko darbību nesaistītas valsts deleģētas funkcijas, zaudējumi (pārejas noteikumu 15.punkts; 15% no kopējās nesegto zaudējumu summas, bet ne vairāk kā 23.r.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B117,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B117,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,25,"Citas nodokli samazinošas summas t.sk.:",{"$f":"SUM(G120:G122)","v":0},{"$f":"SUM(H120:H122)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R25_1",null,null,25.1,{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B120&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B120&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B120,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B120,'UIN Data'!$I:$I)","v":0}]
[null,"R25_2",null,null,25.2,{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B121&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B121&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B121,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B121,'UIN Data'!$I:$I)","v":0}]
[null,"R25_3",null,null,25.3,{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B122&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B122&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B122,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B122,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,26,"Nodoklis pēc 24.r.un 25.r. piemērošanas ((23.r.-24r.-25.r.)≥0)",{"$f":"IF(G116-G117-G119>=0,G116-G117-G119,0)","v":0},{"$f":"IF(H116-H117-H119>=0,H116-H117-H119,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Vai ir veiktas izmaksas, par kurām nav ieturēts nodoklis izmaksas brīdī?"]
[null,"IzmaksasNavNodoklis",null,null,null,"Jā, izmaksas nerezidentiem",{"$f":"IF(ISNA(VLOOKUP(G$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,G$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,H$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,I$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,J$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,K$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,L$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,M$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,N$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,O$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,P$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,Q$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B127,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B127,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,R$2&$B127,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"IzmaksasNavNodoklis",null,null,null,"Jā, no saistītas personas, kura izmanto likumā \"Par nodokļu piemērošanu brīvostās un speciālajās ekonomiskajās zonās\" noteiktās nodokļa atlaides",{"$f":"IF(ISNA(VLOOKUP(G$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,G$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,H$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,I$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,J$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,K$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,L$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,M$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,N$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,O$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,P$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,Q$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B128,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B128,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,R$2&$B128,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"IzmaksasNavNodoklis",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B129,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B129,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,27,"Nodoklis no nerezidenta ienākuma, ja nodoklis netika ieturēts un iemaksāts budžetā (5.p.11.d.), tai skaitā:",{"$f":"SUM(G132:G136)","v":0},{"$f":"SUM(H132:H136)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R27_1",null,null,27.1,"nodoklis no atlīdzības par vadības un konsultatīvajiem pakalpojumiem (maksājuma summa ÷ 0.8 x 0.2)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B132,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B132,'UIN Data'!$I:$I)","v":0}]
[null,"R27_2",null,null,27.2,"nodoklis no atlīdzības par Latvijā esoša nekustamā īpašuma atsavināšanu (maksājuma summa ÷ 0.8 x 0.03)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B133,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B133,'UIN Data'!$I:$I)","v":0}]
[null,"R27_3",null,null,27.3,"nodoklis no maksājuma personai zemu nodokļu vai beznodokļu valstī vai teritorijā (maksājuma summa ÷ 0.8 x 0.2)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B134,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B134,'UIN Data'!$I:$I)","v":0}]
[null,"R27_4",null,null,27.4," \tnodoklis no atlīdzības par Latvijā esoša nekustamā īpašuma izīrēšanu vai iznomāšanu (maksājuma summa ÷ 0,8 x 0,05)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B135,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B135,'UIN Data'!$I:$I)","v":0}]
[null,"R27_5",null,null,27.5,{"$f":"IF(ISERROR(VLOOKUP(\"*\"&$B136&\"_nosaukums\",'UIN Data'!$H:$I,2,0)),\"Lietotāja definēts\",VLOOKUP(\"*\"&$B136&\"_nosaukums\",'UIN Data'!$H:$I,2,0))","v":"Lietotāja definēts"},{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B136,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B136,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,28,"Nodoklis no saistītas personas, kura izmanto likumā “Par nodokļu piemērošanu brīvostās uz speciālajās ekonomiskajās zonās” noteiktās nodokļu atlaides, ja nodoklis netika ieturēts un iemaksāts budžetā (4.p.18.d.), tai skaitā:",{"$f":"SUM(G139:G140)","v":0},{"$f":"SUM(H139:H140)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R28_1",null,null,28.1,"nodoklis no atlīdzības par vadības un konsultatīvajiem pakalpojumiem (maksājuma summa ÷ 0.8 x 0.2)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B139,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B139,'UIN Data'!$I:$I)","v":0}]
[null,"R28_2",null,null,28.2,"nodoklis no atlīdzības par Latvijā esoša nekustamā īpašuma atsavināšanu (maksājuma summa ÷ 0.8 x 0.03)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B140,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B140,'UIN Data'!$I:$I)","v":0}]
[]
[null,null,null,null,29,"Nodokļa kopsumma taksācijas mēnesī ((26.r.+27.r.+28.) -31.r.)",{"$f":"(G124+G131+G138)-G152","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"(R124+R131+R138)-R152","v":0}]
[]
[null,"R30_0",null,null,"30.0","Taksācijas periodā aprēķinātais avansa maksājums.",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B144,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B144,'UIN Data'!$I:$I)","v":0}]
[null,"R30",null,null,30,"Aprēķinātais nodoklis taksācijas mēnesī (ieskaitot papildus nodokli līdz 50 euro, ja par pārskata gadu aprēķinātā nodokļa summa ir mazāka par 50 euro) (17.panta 11.d. un 12.d.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B145,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B145,'UIN Data'!$I:$I)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(G$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(G$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(H$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(H$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(I$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(I$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(J$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(J$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(K$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(K$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(L$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(L$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(M$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(M$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(N$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(N$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(O$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(O$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(P$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(P$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(Q$2&$B145,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(R$2&$B145,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(R$2&$B145,'UIN Data'!$H:$I,2,0))","v":false}]
[null,null,null,"Vai taksācijas periodā veidojās nodokļa pārmaksa?"]
[null,"NodoklaParmaksa",null,null,null,"Jā, dēļ atmaksātās aizdevuma summas",{"$f":"IF(ISNA(VLOOKUP(G$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,G$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,H$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,I$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,J$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,K$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,L$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,M$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,N$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,O$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,P$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,Q$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B148,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B148,'UIN Data'!$I:$I)=1,SUMIF('UIN Data'!$H:$H,R$2&$B148,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"NodoklaParmaksa",null,null,null,"Jā, dēļ atgūtas debitora parāda summas",{"$f":"IF(ISNA(VLOOKUP(G$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,G$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,G$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,H$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,H$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,I$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,I$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,J$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,J$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,K$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,K$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,L$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,L$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,M$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,M$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,N$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,N$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,O$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,O$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,P$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,P$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,Q$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,Q$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B149,'UIN Data'!$H:$I,2,0)),\"\",IF(OR(SUMIF('UIN Data'!$H:$H,R$2&$B149,'UIN Data'!$I:$I)=2,SUMIF('UIN Data'!$H:$H,R$2&$B149,'UIN Data'!$I:$I)=3),\"X\",\"\"))","v":""}]
[null,"NodoklaParmaksa",null,null,null,"Nē",{"$f":"IF(ISNA(VLOOKUP(G$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,G$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(H$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,H$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(I$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,I$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(J$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,J$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(K$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,K$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(L$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,L$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(M$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,M$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(N$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,N$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(O$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,O$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(P$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,P$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,Q$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""},{"$f":"IF(ISNA(VLOOKUP(R$2&$B150,'UIN Data'!$H:$I,2,0)),\"\",IF(SUMIF('UIN Data'!$H:$H,R$2&$B150,'UIN Data'!$I:$I)=0,\"X\",\"\"))","v":""}]
[]
[null,null,null,null,31,"Nodokļa pārmaksa, tai skaitā:",{"$f":"SUM(G153:G154)","v":0},{"$f":"SUM(H153:H154)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"R31_1",null,null,31.1,"ja taksācijas periodā nodokļa maksātājam ir atmaksāta aizdevuma summa, kas bija iekļauta ar nodokli apliekamajā bāzē, vai aizdevums aplikts ar IIN, un šo summu nevar attiecināt pret taksācijas perioda nodokļa bāzi, bet ne vairāk kā attiecīgajā periodā samaksātais nodoklis (11.panta 5.d.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B153,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B153,'UIN Data'!$I:$I)","v":0}]
[null,"R31_2",null,null,31.2,"ja taksācijas periodā nodokļa maksātājam ir atgūta debitora parāda summa, kura pirmstaksācijas periodos ir iekļauta ar nodokli apliekamajā bāzē, bet ne vairāk kā attiecīgajā periodā samaksātais nodoklis (9.panta 5.d.)",{"$f":"SUMIF('UIN Data'!$H:$H,G$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,H$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,I$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,J$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,K$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,L$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,M$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,N$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,O$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,P$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,Q$2&$B154,'UIN Data'!$I:$I)","v":0},{"$f":"SUMIF('UIN Data'!$H:$H,R$2&$B154,'UIN Data'!$I:$I)","v":0}]
[]
[null,"PedejaDeklaracija",null,null,32,"Nodokļa aprēķina rezultāts pārskata gadā",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(G142:R142)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(G$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(G$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(H$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(H$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(I$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(I$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(J$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(J$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(K$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(K$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(L$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(L$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(M$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(M$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(N$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(N$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(O$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(O$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(P$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(P$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(Q$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(Q$2&$B156,'UIN Data'!$H:$I,2,0))","v":false},{"$f":"IF(ISNA(VLOOKUP(R$2&$B156,'UIN Data'!$H:$I,2,0)),FALSE,VLOOKUP(R$2&$B156,'UIN Data'!$H:$I,2,0))","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gada summa no pēdējās deklarācijas (no PDF izdrukas)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Starpība",{"$f":"R156-R158","v":0}]

{"sheet":"2","index":4,"n_rows":5,"n_cols":12,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,4,1],[1,9,4,9],[1,10,4,10],[1,2,3,3],[1,11,4,11],[1,4,4,4],[1,5,4,5],[1,6,4,6],[1,7,4,7],[1,8,4,8]]}
[]
[null,"Npk.","Taksācijas periods, kurā saņemtas dividendes",null,"Dividenžu izmaksātāja rezidences valsts","Dividenžu izmaksātāja reģistrācijas numurs","Dividenžu izmaksātāja nosaukums","Saņemto dividenžu summa","Samazinājuma summa par pirmstaksācijas periodos izmaksātajām dividendēm","Dividendes, par kurām samazināta nodokļa bāze taksācijas periodā","Dividendes, kuras attiecināmas uz nākamajiem taksācijas periodiem","Periods"]
[]
[]
[null,null,"No","Līdz"]

{"sheet":"5.1","index":5,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,1,3,1],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7],[1,2,2,3]]}
[]
[null,"Npk.","Taksācijas periods, kurā saņemtas dividendes",null,"Pamatkapitāla palielinājuma summa","Pamatkapitāla palielinājuma summa no nesadalītās peļņas","Pamatkapitāla samazinājuma summa taksācijas periodā, kuru iekļauj ar nodokli apliekamajā bāzē","Periods"]
[]
[null,null,"No","Līdz"]

{"sheet":"6.2","index":6,"n_rows":4,"n_cols":7,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,2,2,3],[1,1,3,1]]}
[]
[null,"Npk.","Taksācijas periods, kurā izveidoti uzkrājumi debitoru parādiem",null,"Uzkrājumu debitoru parādiem turēšanas periods (mēnešos)","Nodokļa bāzē iekļautā debitoru parādu summa pārskatā gadā","Periods"]
[]
[null,null,"No","Līdz"]

{"sheet":"8","index":7,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,8,3,8],[1,2,2,3],[1,1,3,1],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,3,7]]}
[]
[null,"Npk.","Taksācijas periods, kurā gūts ienākums un samaksāts nodoklis ārvalstī",null,"Valsts, kurā nodoklis samaksāts","Nodokļa summa, kura samaksāta ārvalstī (euro)","Nodokļa summa, kura samazina taksācijas perioda nodokli","Nodokļa summa, kuru pārnes uz nākamajiem taksācijas periodiem","Periods"]
[]
[null,null,"No","Līdz"]

{"sheet":"9.1.1","index":8,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,3,1],[1,7,3,7],[1,6,3,6],[1,5,3,5],[1,4,3,4],[1,3,3,3],[1,2,3,2]]}
[]
[null,"Npk.","Ziedojuma saņēmēja nodokļa maksātāja reģistrācijas kods","Ziedojumu saņēmēja nosaukums","Rezidences valsts","Ziedojuma veikšanas datums","Ziedojuma summa (EUR)","Periods"]

{"sheet":"15","index":9,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,7,5,7],[1,8,5,8],[1,9,5,9],[1,2,5,2],[1,1,5,1],[1,3,5,3],[1,4,5,4],[1,5,5,5],[1,6,5,6]]}
[]
[null,"Npk.","Akciju iegādes datums","Akciju atsavināšanas datums","Akciju turēšanas periods (mēnešos)","Akciju iegādes vērtība","Akciju atsavināšanas vērtība","Ienākums no akciju atsavināšanas, par kuru samazina nodokļa bāzi taksācijas periodā","Ienākums no akciju atsavināšanas, kas attiecināms uz turpmākajiem taksācijas periodiem","Periods"]

{"sheet":"31.2","index":10,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,5,1],[1,2,4,3],[1,8,5,8],[1,7,5,7],[1,6,5,6],[1,5,5,5],[1,4,5,4]]}
[]
[null,"Npk.","Taksācijas periods, kurā aizdevuma summa vai debitora parāda summa, iekļauta nodokļa bāzē",null,"Aizdevuma summa vai debitora parāda summa","Nodokļa summa, kas faktiski samaksāta par attiecīgo summu taksācijas periodā, kurā tā iekļauta nodokļa bāzē","Atmaksātā aizdevuma summa vai atgūtā debitora parāda summa","Nodokļa pārmaksa, ja taksācijas periodā ir atgūta attiecīgā aizdevuma vai debitora parāda summa","Periods"]
[]
[]
[]
[null,null,"No","Līdz"]

{"sheet":"Tiesibas","index":11,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"DatumsNo","2025-09-09",null,null,"TisWbName","ThisWbCustId","RN","ActivationDate","CompName/Path","Processor/HddSerialId","PROCESSOR_REVISION","USERNAME"]
[null,null,null,"DatumsLidz","2025-09-20",null,null,"UIN",1,25,"2020-09-09","-","-","-","-"]
[null,null,null,"Skaitītājs (demo versijai)"]
[]
[null,null,null,"ThisWbName","UIN"]
[null,null,null,"ThisWbCustId",1]
[null,null,null,"Limenis","D"]
[]
[null,null,null,"Nesakonfigurētas tiesības!"]
[null,null,null,"Nesakonfigurētas tiesības versijai!"]
[null,null,null,"Versijas periods ir beidzies!"]
[null,null,null,"Versijas apstrādes uzņēmuma RegNr neatbilst definētam!"]
[null,null,null,"Izvelētais RegNr nav definēts šajā versijā!"]
[null,null,null,"Lūdzu aizpildiet reģistrācijas numuru!"]
[null,null,null,"Versijas Importa/Eksporta skaits sasniedza 20!"]
[null,null,null,"Lūdzu veikt faila aktivāciju uz lapas \"Instrukcija\"!"]
[null,null,null,"Fails jau ir aktivizēts šim datoram un lietotājam!"]

{"sheet":"Symbols","index":12,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["FromEDS","ToXLM"]
["D+","i"]
["D ","u"]
["E ","n"]
["D<","l"]