{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Macro","Tame","VSAOI"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"Macro","index":0,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Lai būtu iespējams aizpildīt tāmi, ir jāiespējo makrosi šajā dokumentā!"]
[]
[]
[]
[null,"Informācijas par to, kā iespējams iespējot makrosus. "]

{"sheet":"Tame","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Nr.","Izmaksu pozīcijas nosaukums","Mērvienība","Skaits","1 vienības izmaksas\n(EUR)","LVAF finansējums\n(EUR)","% no kopējā fin.","Skaidrojumi"]
["1.","Atalgojums (kods 1100)",null,null,null,{"$f":"SUM(F5:F6)","v":0},{"$f":"IF(ISERROR($F4/$F$25),0,$F4/$F$25)","v":0}]
[1,null,"h",null,null,{"$f":"ROUND(D5*E5,2)","v":0}]
["..."]
["2.","Darba devēja sociālās apdrošināšanas iemaksas, sociāla rakstura pabalsi un kompensācijas (kods 1200)",null,null,null,{"$f":"SUM(F8:F9)","v":0},{"$f":"IF(ISERROR($F7/$F$25),0,$F7/$F$25)","v":0}]
[1,{"$f":"IF(B5=\"\",\"\",B5)","v":""},"%",null,null,{"$f":"ROUND(F5*D8/100,2)","v":0}]
["...",{"$f":"IF(B6=\"\",\"\",B6)","v":""}]
["3.","Honorāri un autoratlīdzības (kods 1150)",null,null,null,{"$f":"SUM(F11:F12)","v":0},{"$f":"IF(ISERROR($F10/$F$25),0,$F10/$F$25)","v":0}]
[1,null,null,null,null,{"$f":"ROUND(D11*E11,2)","v":0}]
["..."]
["4.","Komandējumi un dienesta braucieni (kods 2100)",null,null,null,{"$f":"SUM(F14:F15)","v":0},{"$f":"IF(ISERROR($F13/$F$25),0,$F13/$F$25)","v":0}]
[1,null,null,null,null,{"$f":"ROUND(D14*E14,2)","v":0}]
["..."]
["5.","Pakalpojumi (kods 2200)",null,null,null,{"$f":"SUM(F17:F18)","v":0},{"$f":"IF(ISERROR($F16/$F$25),0,$F16/$F$25)","v":0}]
[1,null,null,null,null,{"$f":"ROUND(D17*E17,2)","v":0}]
["..."]
["6.","Krājumi, materiāli, preces, biroja preces un inventārs (kods 2300)",null,null,null,{"$f":"SUM(F20:F21)","v":0},{"$f":"IF(ISERROR($F19/$F$25),0,$F19/$F$25)","v":0}]
[1,null,null,null,null,{"$f":"ROUND(D20*E20,2)","v":0}]
["..."]
["7.","Pamatlīdzekļi ( kods 5000)",null,null,null,{"$f":"SUM(F23:F24)","v":0},{"$f":"IF(ISERROR($F22/$F$25),0,$F22/$F$25)","v":0}]
[1,null,null,null,null,{"$f":"ROUND(D23*E23,2)","v":0}]
["..."]
[null,null,null,null,"KOPĀ: ",{"$f":"F4+F7+F10+F13+F16+F19+F22","v":0}]
[]
[]
[]
[]
[null,"Tāme saglabājas automātiski, to aizverot"]
[null,"Aizpildāmi ir tikai baltie lauki"]
[null,"Pelēkie lauki tiks iespējoti, aizpildot pozīcijas nosaukumu vai izmaksas"]
[null,"Skaidrojumu varēs ievadīt, mainīt, izmainot pozīcijas izmaksu lauku"]

{"sheet":"VSAOI","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Darba devēja likme darba ņēmējam",23.59]
["Darba devēja likme pensionāram",19.86]
["Darba devēja likme izdienas pensionāram vai invalīdam - valsts speciālās pensijas saņēmējam",21.5]
["Darba devēja likme nodarbinātam brīvības atņemšanas soda izciešanas laikā",20.5]
["Darba devēja likme pensionāram brīvības atņemšanas soda izciešanas laikā",16.88]