{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["fleetovy formular","prehled dlr marzi"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"fleetovy formular","index":0,"n_rows":100,"n_cols":53,"rows_kept":100,"merged":[[0,0,0,25],[2,0,2,25],[4,3,4,10],[4,23,4,25],[6,0,7,14],[7,20,7,25],[9,2,9,5],[12,0,12,11],[12,18,12,25],[13,0,14,11],[13,13,13,17],[13,18,13,25],[14,18,14,25],[15,18,15,25],[16,0,17,11],[17,18,17,25],[19,21,19,24],[23,8,23,11],[23,21,23,24],[24,21,24,24],[25,13,25,18],[25,21,25,24],[26,8,26,11],[26,21,26,24],[27,8,27,11],[27,21,27,24],[28,21,28,24],[29,21,29,24],[33,8,33,10],[33,21,33,23],[34,8,34,10],[34,21,34,23],[36,5,36,6],[36,8,36,11],[36,21,36,24],[38,8,38,11],[38,21,38,24],[39,8,39,11],[39,21,39,24],[40,8,40,11],[40,21,40,24],[44,13,44,16],[45,21,45,24],[46,21,46,24],[49,21,49,24],[51,21,51,24],[53,8,53,10],[53,21,53,24],[55,8,55,10],[55,22,55,23],[56,8,56,10],[58,8,58,10],[60,8,60,10],[60,21,60,24],[63,0,67,15],[68,19,68,25],[69,0,69,25],[83,28,83,32],[83,33,83,37],[83,38,83,42],[83,43,83,47],[83,48,83,52]],"flags":["formulas_cached_only"]}
["Žádost o fleetový příspěvek FMC 2015 kombinovaný \nod 1.7.2015"]
[]
["(Pouze pro vozidla zadaná do systému VISTA s kódem \"F\", \"K\", \"D\" a \"Y\")"]
[]
["  Zpracoval/a:",{"$nulls":15},"Kód dealera:",{"$nulls":4},"C","Z",{"v":4,"d":"04"},{"$nulls":15},"kontrola rozdilu","vyplneni slevy"]
["  Dealerství:"]
[]
[{"$nulls":16},"Datum:",{"$nulls":3},"2015-08-19"]
[]
["FIN",{"$nulls":26},0]
["Konečný zákazník-velkoodběratel:",{"$nulls":12},"Údaje o voze:"]
[]
[{"$nulls":13},"Model Ford:"]
[{"$nulls":13},"Stupeň výbavy,motor,karoserie:"]
[{"$nulls":13},"Číslo objednávky:"]
["Financující leasingová společnost:",{"$nulls":12},"Číslo karoserie VIN:"]
[]
[{"$nulls":27},"kontrola"]
[]
["Datum uzavření kupní smlouvy se zákazníkem (ve formátu dd.mm.rrrr):",{"$nulls":26},0]
[]
["Údaje z faktury FMC:",{"$nulls":26},0]
[]
["Číslo faktury FMC:",{"$nulls":12},"POPLATKY DHD (doprava do ČR)",{"$nulls":13},0]
[{"$nulls":13},"POPLATKY DHD (náklady v ČR)",{"$nulls":13},0]
[{"$nulls":13},"VARIABILNÍ MARŽE BONUS 1 (prémiové standardy)",{"$nulls":13},0]
["PRVNÍ MEZISOUČET BEZ DPH:",{"$nulls":12},"VARIABILNÍ MARŽE BONUS 2 (CVP)",{"$nulls":13},0]
["Úprava faktury FMC bez DPH:",{"$nulls":12},"VARIABILNÍ MARŽE BONUS 3"]
[{"$nulls":13},"DOPRAVNI POJISTENI",{"$nulls":13},0]
[{"$nulls":13},"Cena CIP:",{"$nulls":7},{"v":0,"d":"0.00"}]
[]
["Kalkulace ceníkové ceny před slevou:",{"$nulls":12},"Kalkulace ceny pro zákazníka po slevě:"]
[]
["Přepočtový koeficient:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":4},"Zůstatková marže dealera:",{"$nulls":7},{"$error":"#N/A"}]
["DPH:",{"$nulls":7},{"v":21,"d":"21.00"},null,null,"  [%]",null,"DPH:",{"$nulls":7},21,null,null,"  [%]"]
[" ",{"$nulls":12}," "]
["Dealer. marže na faktuře:",{"$nulls":4},{"$error":"#N/A"},null,"[%]",{"$error":"#N/A"},{"$nulls":3},"Kc","Zůstatková delaerská marže bez DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kc"]
[]
["  Ceníková cena bez DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kc","  Cena pro zákaz. po slevě bez DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kč"]
["  DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kc","  DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kč"]
["  Ceníková cena s DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kc","  Cena pro zákaz. po slevě vč. DPH:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kč"]
[]
["Údaje z faktury Dealera na Zákazníka:"]
[]
["Číslo faktury Dealera na Zákazníka:"]
["Konečná cena vozu po slevě vč. DPH celkem (vč. lokální domontáže a příslušenství):",{"$nulls":24},"Kč"]
["Cena lokální přestavby a příslušenství fakturované zákazníkovi vč. DPH: *",{"$nulls":24},"Kč"]
[null,"* veškerá výbava montovaná dealerem nebo přestavbářem, na kterou FMC neposkytuje fleetový příspěvek (např. Defend Lock, "]
[null,"  přepážka nákl. prost., střešní nosič kol / box, FordProtect, apod.)"]
["Konečná cena vozu po slevě vč. DPH (bez lokální domontáže a příslušenství):",{"$nulls":20},{"v":0,"d":"0.0"},{"$nulls":3},"Kč",null,"kontrola"]
[]
["Kontrola - rozdíl mezi skutečně fakturovanou cenou a cenou spočítanou na formuláři:",{"$nulls":20},{"$error":"#N/A"},{"$nulls":3},"Kč",null,0,{"$nulls":11},0]
[]
["Celková sleva pro zákazníka:",{"$nulls":7},{"$error":"#N/A"},null,null,"  [%]",null,"Fleetový příspěvek FMC na 1 vozidlo:",{"$nulls":7},{"$error":"#N/A"},{"$nulls":3},"Kč"]
[]
["Podíl dealera na slevě %:",{"$nulls":10},"  [%]",null,"Počet vozidel v rámci této žádosti:",{"$nulls":8},1,null,"ks",{"$nulls":15},1]
["Podíl FORD MC na slevě %:",{"$nulls":10},"  [%]",null,"Fleetový příspěvek FMC celkem na počet vozidel výše:",{"$nulls":26},1]
[]
["Podíl FMC na slevě pevná částka:",{"$nulls":10},"  Kč bez DPH"]
[]
["Podíl FMC na slevě celkem (% + PČ):",{"$nulls":7},{"$error":"#N/A"},null,null,"  [%]",{"$nulls":9},{"$error":"#N/A"},{"$nulls":3},"Kč"]
[]
["Poznámka - zdůvodnění poskytnuté slevy:",{"$nulls":15},"Vyplní Dealer:",{"$nulls":4},"Vyplní FMC:"]
[{"$nulls":16},"Podpis zpracovatele:",{"$nulls":4},"Kontroloval:"]
[]
[]
[]
[{"$nulls":21},"  Dne:"]
["GIS1: 07.05, Retention period: 12",{"$nulls":18},"GIS2: Ford Confidential"]
[0,{"$nulls":35},0,0,null,0,2]
[]
[]
[]
[]
[]
[{"$nulls":29},"contract date calc","DW invoice date calc"]
[{"$nulls":28},"prevod data na cislo"]
[]
[{"$nulls":28},{"v":0,"d":"0.00"},1,1]
[]
[{"$nulls":28},"suma",2]
[]
[{"$nulls":28},"Dealers margin %  -contract date / DW invoice date"]
[{"$nulls":27},"contract date","do 31.12.2012",{"$nulls":4},"1.1.-31.3.2013",{"$nulls":4},"1.4.- 31.5.2013",{"$nulls":4},"1.6.2013-30.9.2014",{"$nulls":4},"od 1.10.2014"]
[{"$nulls":27},"DW invoice date","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014"]
[{"$nulls":27},"Ka",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.075,"d":"7.5%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.075,"d":"7.5%"}]
[{"$nulls":27},"Fiesta",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
[{"$nulls":27},"B-MAX",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
[{"$nulls":27},"Focus",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"}]
[{"$nulls":27},"C-MAX",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"}]
[{"$nulls":27},"Kuga",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"}]
[{"$nulls":27},"Mondeo",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
[{"$nulls":27},"S-MAX",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
[{"$nulls":27},"Galaxy",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
[{"$nulls":27},"Courier Tourneo",{"$nulls":18},{"v":0.06,"d":"6.0%"},{"v":0.0975,"d":"9.75%"},{"$nulls":3},{"v":0.06,"d":"6.0%"},{"v":0.0975,"d":"9.75%"}]
[{"$nulls":27},"Courier Transit",{"$nulls":18},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"$nulls":3},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]
[{"$nulls":27},"Connect",{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]
[{"$nulls":27},"Transit",{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"}]
[{"$nulls":27},"Custom",{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"}]
[{"$nulls":27},"Ranger            ",{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]

{"sheet":"prehled dlr marzi","index":1,"n_rows":20,"n_cols":26,"rows_kept":20,"merged":[[3,1,3,5],[3,6,3,10],[3,11,3,15],[3,16,3,20],[3,21,3,25]],"flags":["formulas_cached_only"]}
["Dealerská marže v závislosti na kombinaci data smlouvy se zákazníkem a datem vystavení faktury FMC"]
[]
[]
["datum smlouvy se zákazníkem ","do 31.12.2012",{"$nulls":4},"1.1.-31.3.2013",{"$nulls":4},"1.4.- 31.5.2013",{"$nulls":4},"1.6.2013-30.9.2014",{"$nulls":4},"od 1.10.2014"]
["datum vystavení faktury FMC","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014","do 31.12.2012","1.1.-31.3.2013","1.4.-31.5.2013","1.6.2013-31.9.2014","od 1.10.2014"]
["Ka",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.075,"d":"7.5%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.05,"d":"5.0%"},{"v":0.075,"d":"7.5%"}]
["Fiesta",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
["B-MAX",{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.09,"d":"9.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.08,"d":"8.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.06,"d":"6.0%"},{"v":0.075,"d":"7.5%"}]
["Focus",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"}]
["C-MAX",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.07,"d":"7.0%"},{"v":0.075,"d":"7.5%"}]
["Kuga",{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"},{"v":0.125,"d":"12.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.115,"d":"11.5%"},{"v":0.12,"d":"12.0%"}]
["Mondeo",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
["S-MAX",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
["Galaxy",{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"},{"v":0.135,"d":"13.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.125,"d":"12.5%"},{"v":0.12,"d":"12.0%"}]
["Courier Tourneo",{"$nulls":18},{"v":0.06,"d":"6.0%"},{"v":0.0975,"d":"9.75%"},{"$nulls":3},{"v":0.06,"d":"6.0%"},{"v":0.0975,"d":"9.75%"}]
["Courier Transit",{"$nulls":18},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"$nulls":3},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]
["Connect",{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]
["Transit",{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"}]
["Custom",{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.11,"d":"11.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.1,"d":"10.0%"},{"v":0.0975,"d":"9.75%"}]
["Ranger            ",{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"},{"v":0.1,"d":"10.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.09,"d":"9.0%"},{"v":0.0975,"d":"9.75%"}]