{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["DMV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"DMV","index":0,"n_rows":81,"n_cols":12,"rows_kept":81,"cut":false,"hidden":false,"merged":[[6,9,7,9],[8,9,9,9],[6,10,7,10],[8,10,9,10]]}
[null,null,null,null,null,null,null,null,null,"! IZRAČUN DMV do 31.12.2020 !"]
["Moč motorja: Motorno kolo",null,null,null,{"$f":"MATCH(K3,F3:F6,0)","v":1},"Vrsta vozila:",null,null,null,"Datum izračuna:","2015-01-01"]
[0,1.5,null,null,1,"Osebno vozilo",null,null,null,"Vrsta vozila:","Osebno vozilo"]
[25.01,2,null,null,2,"Bivalno vozilo",null,null,null,"Vrsta goriva:","Ostalo (bencin, hibrid...)"]
[50.01,3,null,null,3,"Kolo z motorjem",null,null,null,"Izpust CO2:",200,"g/km"]
[75.010000000000005,5,null,null,4,"Motorno kolo",null,null,null,"Izpust EURO:","EURO4"]
[null,null,null,null,null,null,null,null,null,"Vozilo z najmanj 8 sedeži:"]
[null,null,null,null,{"$f":"MATCH(K4,F9:F11,0)","v":3},"Vrsta goriva:"]
["Moč motorja: Bivalno vozilo",null,null,null,1,"Elektrika",null,null,null,"Izpust trdih delcev večji od 0,005 g/km:"]
[0,6,null,null,2,"Dizel"]
[60.01,9,null,null,3,"Ostalo (bencin, hibrid...)",null,null,null,"Moč motorja:",222,"kW"]
[90.01,13,null,null,null,null,null,null,null,"Prostornina motorja:",2222,"cm3"]
[120.01,18,null,null,{"$f":"MATCH(K6,F14:F19,0)","v":4},"Izpust EURO:",null,null,null,"Delovanje motorja:","Dvotaktni"]
[null,null,null,null,1,"EURO1",null,null,null,"Davčna osnova:",10000,"€"]
[null,null,null,null,2,"EURO2"]
["Izpust CO2","Bencin","Dizel",null,3,"EURO3",null,null,null,"Stopnja davka:",{"$f":"IF(K2=\"\",\"Vnesite Dat.izračuna\",IF(E2=1,A58,IF(E2=2,A64,A70)))","v":11.1},"%"]
[0,0.5,1,null,4,"EURO4",null,null,null,"Znesek davka:",{"$f":"K14*K16/100","v":1110},"€"]
[110.01,1,2,null,5,"EURO5"]
[120.01,1.5,3,null,6,"EURO6",null,null,null,"Stopnja pribitka:",{"$f":"IF(K2=\"\",\"Vnesite Dat.izračuna\",SUM(E29,E36))","v":0},"%"]
[130.01,3,6,null,null,null,null,null,null,"Znesek pribitka:",{"$f":"K14*(K19%)","v":0},"€"]
[150.01,6,11,null,{"$f":"MATCH(K13,F22:F23,0)","v":1},"Delovanje motorja:"]
[170.01,9,15,null,1,"Dvotaktni",null,null,null,"Skupaj davek:",{"$f":"IF(K2=\"\",\"Vnesite Dat.izračuna\",K17+K20)","v":1110},"€"]
[190.01,13,18,null,2,"Ostalo"]
[210.01,18,22]
[230.01,23,26,null,true,"Vozilo z najmanj 8 sedeži"]
[250.01,28,31]
[null,null,null,null,false,"Izpust trdih delcev večji od 0,005 g/km"]
[]
["Pribitek EURO","Osebna/bivalna","Motorna",null,{"$f":"SUM(E30:E34)","v":0},"PribitekOsebna","prostornina od","prostornina do"]
[1,10,10,null,{"$f":"IF(E2<3,IF(AND(K12>=G30, K12<=H30),F30,0),0)","v":0},0,0,2499]
[2,10,5,null,{"$f":"IF(E2<3,IF(AND(K12>=G31, K12<=H31),F31,0),0)","v":0},8,2500,2999]
[3,5,0,null,{"$f":"IF(E2<3,IF(AND(K12>=G32, K12<=H32),F32,0),0)","v":0},10,3000,3499]
[4,2,0,null,{"$f":"IF(E2<3,IF(AND(K12>=G33, K12<=H33),F33,0),0)","v":0},13,3500,3999]
[5,0,0,null,{"$f":"IF(E2<3,IF(AND(K12>=G34, K12<=H34),F34,0),0)","v":0},16,4000,99999999.900000006]
[6,0,0]
[null,null,null,null,{"$f":"SUM(E37:E38)","v":0},"PribitekMotorna","prostornina od","prostornina do"]
[null,null,null,null,{"$f":"IF(E2>2,IF(AND(K12>=G37, K12<=H37),F37,0),0)","v":0},0,0,999]
["Prehodno obdobje do",null,"2011-01-01",null,{"$f":"IF(E2>2,IF(AND(K12>=G38, K12<=H38),F38,0),0)","v":0},5,1000,99999999.900000006]
["Izpust CO2","Dizel","Bencin"]
[0,0.5,1]
[120.01,1,2,null,"2012-06-01","Pribitek Datum"]
[130.01,2.5,4]
[150.01,5.5,9.5]
[170.01,8,12.5]
[190.01,10.5,14.5]
[210.01,18,22]
[230.01,23,26]
[205.01,28,31]
[]
[]
[]
["Osebno vozilo:"]
[{"$f":"IF(ISBLANK(K5), 999, IF(E8=1,0,K5))","v":200},"Izpust CO2 upoštevajoč vrsto goriva"]
[{"$f":"OR(E8<>2,AND(E13=6,E8=2),AND(E13=5,E8=2,K2<DATE(2012,1,1)))","v":true},"Lestvica za bencin?"]
[{"$f":"VLOOKUP(A53,IF(K2<C38,A40:C48,A17:C26),IF(A54,2,3),TRUE)","v":13},"Stopnja davka"]
[{"$f":"IF(E25, A55*0.7, A55)","v":9.1},"Upoštevanje št. sedežev"]
[{"$f":"A56+IF(E8=1,0,VLOOKUP(E13,A30:C35,2,0)-IF(AND(E13=4,K2<C38),1,0))","v":11.1},"Po pribitku za izpust EURO"]
[{"$f":"A57+IF(AND(E8=2,E27,K2<C38),2,IF(AND(E8=2,E27), 5, 0))","v":11.1},"Po pribitku za izpust trdih delcev"]
[]
[]
["Bivalno vozilo:"]
[{"$f":"IF(E8=1,0.5,VLOOKUP(K11,A10:B13,2,TRUE))","v":18},"Stopnja davka upoštevajoč moč vozila"]
[{"$f":"A62+IF(E8=1,0,VLOOKUP(E13,A30:C35,2,0)-IF(AND(E13=4,K2<C38),1,0))","v":20},"Po pribitku za izpust EURO"]
[{"$f":"A63+IF(AND(E8=2,E27,K2<C38),2,IF(AND(E8=2,E27), 5, 0))","v":20},"Po pribitku za izpust trdih delcev"]
[]
[]
["Kolo z motorjem:"]
[{"$f":"IF(E8=1,0.5,VLOOKUP(K11,A3:B6,2,TRUE))","v":5},"Stopnja davka upoštevajoč moč vozila"]
[{"$f":"A68+IF(E8=1,0,IF(E21=1,3,0))","v":8},"Pribitek za delovanje motorja"]
[{"$f":"A69+IF(E8=1,0,IF(AND(E2=3,E13=2),0,VLOOKUP(E13,A30:C35,3,0)))","v":8},"Po pribitku za izpust EURO"]
[]
["PribitekOsebna ","prostornina od","prostornina do"," "]
[0,0,2499]
[8,2500,2999]
[10,3000,3499]
[13,3500,3999]
[16,4000]
[]
["PribitekMotorna","prostornina od","prostornina do"]
[0,0,999]
[5,1000]